Help customizing a script

phpkyle92

Okay, I found a sports standings script that is ALMOST perfect for my website and what I'm trying to do. However, it's missing one feature that I must have for the standings script to be worth it for my website.

Out of the box, it calculates a team's overall win/loss record, their winning percentage and some other stats. But what I need it to also calculate is a team's win/loss record against teams in their conference.

The script is called Peter's Sports League Standings. I tried to enlist the assistance of the script writer through the forum, but he says he does not have time to help, so I was hoping someone here could.

Here is a link to that thread: http://www.theblog.ca/peter-forum/peters-sports-league-standings/division-record-column-under-standings

I've gotten close a couple of times I think. It displays numbers, but there are incorrect.

Let me know whatever other information you need and I will supply it!

dagon

your going to have to narrow down the issue, with code, no one is going to download some script, read several pages of forum posts to work it all out for you (for free). That or hire some one.

phpkyle92

Well...I'll try to explain it...and it's only one page with a few posts...

But, here is the code:

(SELECT COUNT(*) FROM sportsdb_wins WHERE winner = teamid AND (winortie = 3 or winortie = 1) AND (SELECT teamdiv FROM sportsdb_teams WHERE teamid = loser) = teamdiv) AS divwins,

Basically, divwins is supposed to select the teamID of the current row, if the winortie value is 3 or 1 (if they won or won by forfeit), if the losing team is a team that in their teamdiv (conference).

This value should be 5, but it is returning three. When I run the query in PHPMyAdmin, filling in the variables with an example of a teamid/teamdiv combination that would be used by the script, it still returns the Number three.

Let me know what other information is needed...