Played by: ".$row['nickname']."
"; if ($row['imclient'] != "") { echo $row['imclient'].": ".$row['imname']."
"; } echo "
"; echo ""; $teamid = $row['teamid']; $gameResults = mysql_query("select count(*),'Wins' as type from game where (playerHome=$teamid AND scoreHome>ScoreAway) OR (playerAway=$teamid AND scoreAway>scoreHome) UNION select count(*), 'Ties' as type from game where ((playerHome=$teamid OR playerAway=$teamid) AND scoreHome=scoreAway) UNION select count(*), 'Loss' as type from game where (playerHome=$teamid AND scoreHome "; } echo "

Division: ".$row['divisionName']."	GP	W	T	L	Pts	GF	GA
".$row['name']." - (".$row['nickname'].")	$played	".$teamResults['Wins']."	".$teamResults['Ties']."	".$teamResults['Loss']."	$pts	$goalsFor	$goalsAgainst

"; mysql_free_result($teaminfo); // show schedule $teams = mysql_query("select users.nickname,teams.name as teamname,teams.id as teamid from users_teams inner join users on (users_teams.user=users.id) inner join teams on (users_teams.team=teams.id) order by teams.name;"); $teamSelect=""; $teamHash; while ($row = mysql_fetch_assoc($teams)) { $teamHash[$row['teamid']] = $row['teamname']; $playerHash[$row['teamid']] = $row['nickname']; } mysql_free_result($teams); echo "
"; $games = mysql_query("select * from game where playerHome=$teamid OR playerAway=$teamid order by playoff asc, round;"); echo ""; $prevRound = ""; $playoff = 0; while ($res = mysql_fetch_assoc($games)) { $gameid = $res['id']; $hometeam = $teamHash[$res['playerHome']]; $homeplayer = $playerHash[$res['playerHome']]; $awayteam = $teamHash[$res['playerAway']]; $awayplayer = $playerHash[$res['playerAway']]; if ($playoff == 0 && $res['playoff'] == 1) { echo ""; $playoff=1; } $score = "Submit Results"; if ($res['scoreHome'] != "" && $res['scoreAway'] != "") $score = "".$res['scoreAway']." - ".$res['scoreHome'].""; echo ""; } mysql_free_result($games); echo "

Schedule
Playoffs
".$awayteam." (".$awayplayer.") vs. ".$hometeam." (".$homeplayer.")	Round: ".$res['round']."	$score

"; $roster = mysql_query("SELECT * FROM player WHERE team=".$_GET['teamid']." ORDER BY position;"); echo ""; while($row = mysql_fetch_assoc($roster)) { $stats = mysql_query("SELECT sum(number) as num,type FROM game_stats where playerid=".$row['id']." AND approved=1 group by type;"); if ($row['picture'] != "") $pic = ""; else $pic = " "; echo ""; mysql_free_result($stats); } echo "

Roster
$pic	".$row['name']."	".$row['position']."	"; if (mysql_num_rows($stats)==0) echo " "; while ($stat = mysql_fetch_assoc($stats)) { $type = $stat['type']; if ($type=='Goal') $type = "Goals"; echo $type.": ".$stat['num']." "; } echo "

"; mysql_free_result($roster); include('footer.php'); ?>