admin_files/editscore.php

Line 12
    $query="SELECT winner, loser, winconf 
        FROM sportsdb_wins 
        WHERE sportsdb_wins.winid = $winid 
        LIMIT 1";
    $result = mysql_query($query);
    $confid = mysql_result($result,0,'winconf');

Line 205
    	$query2="SELECT sportsdb_teams.teamid, sportsdb_teams.teamname, sportsdb_divs.divname FROM sportsdb_teams LEFT JOIN sportsdb_divs ON sportsdb_teams.teamdiv = sportsdb_divs.divid 
WHERE (sportsdb_teams.active = 1 AND sportsdb_divs.conference = $confid)
        OR sportsdb_teams.teamid = -1 
        ORDER BY divorder ASC, teamname ASC";

admin_files/updatescore.php

Line 11

    $query="SELECT winner, loser, winconf 
        FROM sportsdb_wins 
        WHERE sportsdb_wins.winid = $winid 
        LIMIT 1";
    $result = mysql_query($query);
    $confid = mysql_result($result,0,'winconf');

Line 56

        if ($winner == $loser && $winner != -1) die ("You cannot have a team play against itself.");

admin_files/mainview.php

Line 78
    $queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.rf, sportsdb_wins.ra, 
    sportsdb_wins.winner, sportsdb_wins.loser, 
    sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.winortie, 
    sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam
    FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams 
    WHERE sportsdb_wins.winconf = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie != 3
    ORDER BY wintime ASC";

Line 136
    $queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.winner, sportsdb_wins.loser, 
    sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam
    FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams
    WHERE sportsdb_wins.winconf = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie = 3
    ORDER BY wintime ASC";

admin_files/addscore.php

Line 79

$query="SELECT sportsdb_teams.teamname, sportsdb_teams.teamid, sportsdb_divs.divname FROM sportsdb_teams
            LEFT JOIN sportsdb_divs ON sportsdb_teams.teamdiv = sportsdb_divs.divid 
            WHERE (sportsdb_teams.active=1 AND sportsdb_divs.conference = $confid) 
            OR sportsdb_teams.teamid = -1 
            ORDER BY divorder ASC, teamname ASC";

Replace lines 106 and 107 with:

mysql_data_seek($result, 0);

admin_files/addscoreyes.php

Line 33
            if ($winner == $loser && $winner != -1) {

Line 40

            $query="INSERT INTO sportsdb_wins (wincomments, field, windate, wintime, winner, loser, winortie, rf, ra, winconf) VALUES ('$wincomments', '$field', $windate, $wintime, $winner, $loser, $winortie, $rf, $ra, $confid)";

standings.php

Line 389:

$queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.rf, sportsdb_wins.ra, 
    sportsdb_wins.winner, sportsdb_wins.loser, 
    sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.winortie, 
    sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam
    FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams 
    WHERE sportsdb_wins.winconf = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie != 3";

Line 479:

$queryscores = "SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.winner, sportsdb_wins.loser, 
    sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam
    FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams
    WHERE sportsdb_wins.winconf = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie = 3";