This script is pretty much perfect, besides the fact that it does not count wins and losses against conference teams.
The developer is not currently supporting/developing this script, but he is trying to point me in the direction I need to complete this.
HOwever, after over a month of trying, I'm convinced I need help.
So, here is the code I currently have, below it is what he wrote which explains what it needs to do.
I can get this code to return numbers, just not the right ones. Reply back for any ounce of information you need...I'll supply whatever you want...I'm borderline desperate! LOL
Code: Select all
(SELECT COUNT(*) FROM sportsdb_wins WHERE winner = teamid AND (winortie = 1 or winortie = 2) AND (SELECT teamid FROM sportsdb_teams WHERE teamid = loser AND teamdiv = teamdiv)) AS divwins,
(SELECT COUNT(*) FROM sportsdb_wins WHERE loser = teamid AND (winortie = 4 or winortie = 5) AND (SELECT teamid FROM sportsdb_teams WHERE teamid = winner AND teamdiv = teamdiv)) AS divlosses,
I'll also need to get the number of losses, which would just be reversing the script.