0 GROUP BY gUser_H ORDER BY gPlayedDate DESC"; $posquery = mysqli_query($con,$posqueryb); while($row = mysqli_fetch_array($posquery)){ $gamedate = date("m-j-Y", $row['gPlayedDate']); $gamedatefortom = date("l, F, jS, Y ", $row['gPlayedDate']); $theseason = $row['gSeason']; $theweek = $row['gWeek']; $teamabr = $row['myteam']; $hometeamid = $row['myteam']; $oppteamabr = $row['opp']; $awayteamid = $row['opp']; $hometeamscore = $row['hometeamscore']; $hometeamq1 = $row['qtr1h']; $hometeamq2 = $row['qtr2h']; $hometeamq3 = $row['qtr3h']; $hometeamq4 = $row['qtr4h']; $hometeamq5 = $row['oth']; $hometeamfd = $row['fdh']; $hometeamfum = $row['fumh']; $hometeamfuml = $row['fumhl']; $hometeamtop = $row['toph']; $hometeamfdf = $row['fourdfh']; $awayteamscore = $row['awayteamscore']; $awayteamq1 = $row['qtr1a']; $awayteamq2 = $row['qtr2a']; $awayteamq3 = $row['qtr3a']; $awayteamq4 = $row['qtr4a']; $awayteamq5 = $row['ota']; $awayteamfd = $row['fda']; $awayteamfum = $row['fuma']; $awayteamfuml = $row['fumal']; $awayteamtop = $row['topa']; $awayteamfdf = $row['fourdfa']; $homecoach = strtolower($row['thecoach']); $homecoachid = $row['coachid']; $nsm_check = $row["nsm_loc"]; $posquerybc = "SELECT su.uUname as theacoach, su.uUID as coachaid FROM sys_users as su WHERE uUID = '" . $row['gUser_A'] . "'"; $posqueryc = mysqli_query($con,$posquerybc); include("scripts/teamcleaner.php"); $team = $cleanteam; $thatawayteam = $cleanoppteam; include("attributes/teamcolors.html"); $hometeamfirst = $teamfn; $hometeamlast = $teamln; while($rowa = mysqli_fetch_array($posqueryc)){ $awaycoach = strtolower($rowa['theacoach']); $awaycoachid = $rowa['coachaid'] ; } if($row['hometeamscore'] > $row['awayteamscore']){$winna = h; $winnaabr = $team;}elseif($row['hometeamscore'] < $row['awayteamscore']){$winna = a; $winnaabr = $thatawayteam;}else{$winna = t; } } $posquerycomb = "select COUNT(cuID) as lecomments from comments where cgID = ". $gameid . ""; $posquerycom = mysqli_query($con,$posquerycomb); $posquerycombr = "select comment from comments where cgID = ". $gameid . ""; $posquerycomr = mysqli_query($con,$posquerycombr); $youtubec = 0; while($rowcom = mysqli_fetch_array($posquerycom)){ $comments = $rowcom['lecomments']; } while($rowcomr = mysqli_fetch_array($posquerycomr)){ $youtubesearch = strpos($rowcomr['comment'],'https://www.youtube.com/watch?v='); if ($youtubesearch === false) { }else{ $youtubec = ($youtubec + 1); } } ?> <?php echo $site_title; ?>Box Score
4 0 4
= $firstseasonwqff){ ?>
America, fuck yeah
0 || $awayteamq5 > 0){ ?> 0 || $awayteamq5 > 0){ ?> 0 || $awayteamq5 > 0){ ?>
1234OTT
<?php echo strtoupper($winnaabr); ?> Wins!
Season : Week : Played on | = 1){ ?>This game has a youtube video! 0 && $comments < 10){ ?> Comment(s) 9){ ?> This game has <?php echo $comments; ?> riveting comments! Comments0 Comments 0){ ?> - Add Yours! | Download the NSV


<?php echo $hometeamfirst; ?> <?php echo $hometeamlast; ?>
= $firstseasonwqff){ ?>= $firstseasonwqff){ ?>
Tot. YdsPass YdsRush Yds1st DFumLost
= $firstseasonwtack){ ?>= $firstseasonwqff){ ?>= $firstseasonwtack){ ?>= $firstseasonwqff){ ?>
SACKSINTTACKSFFRECOV.4D STOPST.O.P.


PASSING

0 ORDER BY gsPassYards DESC "; $posquery3 = mysqli_query($con,$posqueryb3); $counta = 1; while($row = mysqli_fetch_array($posquery3)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
COMPATT%YDSTDINTQBRFANT
%

RUSHING

0 ORDER BY gsRushYards DESC "; $posquery4 = mysqli_query($con,$posqueryb4); while($row = mysqli_fetch_array($posquery4)){ ?>
&season=" title=" " target="_top">qbplayer/ '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
ATTYDSAVGTDFANT

RECEIVING

0 ORDER BY gsReceptionYards DESC "; $posquery5 = mysqli_query($con,$posqueryb5); while($row = mysqli_fetch_array($posquery5)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RECYDSAVGTDFANT

DEFENSE

0 ORDER BY gsSacks DESC, gsDINTS DESC, gsTackles DESC "; $posquery6 = mysqli_query($con,$posqueryb6); while($row = mysqli_fetch_array($posquery6)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
TACKSACKINTYDSTDFANT

KICK RETURNS

0 ORDER BY gsKRYards DESC "; $posquery7 = mysqli_query($con,$posqueryb7); while($row = mysqli_fetch_array($posquery7)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RET.YDSAVGTDFANT
0 ORDER BY gsPRYards DESC "; $posquery8 = mysqli_query($con,$posqueryb8); while($row = mysqli_fetch_array($posquery8)){ ?>

PUNT RETURNS

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RET.YDSAVGTDFANT
0 "; $posquery8 = mysqli_query($con,$posqueryb8); while($row = mysqli_fetch_array($posquery8)){ ?>

KICKING

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
XPXP ATTFGFG ATTPTS / FANT
0 "; $posquery9 = mysqli_query($con,$posqueryb9); while($row = mysqli_fetch_array($posquery9)){ ?>

PUNTING

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
PYDSFANT


<?php echo $awayteamfirst; ?> <?php echo $awayteamlast; ?>
= $firstseasonwqff){ ?>= $firstseasonwqff){ ?>
Tot. YdsPass YdsRush Yds1st DFumLost
= $firstseasonwtack){ ?>= $firstseasonwqff){ ?>= $firstseasonwtack){ ?>= $firstseasonwqff){ ?>
SACKSINTTACKSFFRECOV.4D STOPST.O.P.


PASSING

'0' ORDER BY gsPassYards DESC "; $posquery3 = mysqli_query($con,$posqueryb3); $counta = 1; while($row = mysqli_fetch_array($posquery3)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
COMPATT%YDSTDINTQBRFANT
%

RUSHING

0 ORDER BY gsRushYards DESC "; $posquery4 = mysqli_query($con,$posqueryb4); while($row = mysqli_fetch_array($posquery4)){ ?>
&season=" title=" " target="_top">qbplayer/ '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
ATTYDSAVGTDFANT

RECEIVING

0 ORDER BY gsReceptionYards DESC "; $posquery5 = mysqli_query($con,$posqueryb5); while($row = mysqli_fetch_array($posquery5)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RECYDSAVGTDFANT

DEFENSE

0 ORDER BY gsSacks DESC, gsDINTS DESC, gsTackles DESC "; $posquery6 = mysqli_query($con,$posqueryb6); while($row = mysqli_fetch_array($posquery6)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
TACKSACKINTYDSTDFANT

KICK RETURNS

0 ORDER BY gsKRYards DESC "; $posquery7 = mysqli_query($con,$posqueryb7); while($row = mysqli_fetch_array($posquery7)){ ?>
&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RET.YDSAVGTDFANT
0 ORDER BY gsPRYards DESC "; $posquery8 = mysqli_query($con,$posqueryb8); while($row = mysqli_fetch_array($posquery8)){ ?>

PUNT RETURNS

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
RET.YDSAVGTDFANT
0 "; $posquery8 = mysqli_query($con,$posqueryb8); while($row = mysqli_fetch_array($posquery8)){ ?>

KICKING

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
XPXP ATTFGFG ATTPTS / FANT
0 "; $posquery9 = mysqli_query($con,$posqueryb9); while($row = mysqli_fetch_array($posquery9)){ ?>

PUNTING

&season=" title=" " target="_top"> '', ',' => '',' ' => '')));?>- '', ',' => '',' ' => '')));?>.jpg" alt=" " class="shadow" width="100%" /> .png" title=" 0){ echo("Injured!"); }elseif($row[gsCond] == 0){echo("Finished Game in Bad");}elseif($row[gsCond] == 1){echo("Finished Game in Average");}elseif($row[gsCond] == 2){echo("Finished Game in Good");}elseif($row[gsCond] == 3){echo("Finished Game in EXCELLENT!");} ?>" align="absmiddle" style="width:20px; height:auto;" />
PYDSFANT

Ooku Ooku's Fantasy Players of the Game


2 && $margin < 7){ $intro1.= (" edged the "); }elseif($margin > 6 && $margin < 10){ $intro1.= (" beat the "); }elseif($margin > 9 && $margin < 13){ $intro1.= (" defeated the "); }elseif($margin > 12 && $margin < 16){ $intro1.= (" easily defeated the "); }elseif($margin > 15 && $margin < 19){ $intro1.= (" put a proper hurting on the "); }elseif($margin > 18 && $margin < 22){ $intro1.= (" smoked the "); }elseif($margin > 21 && $margin < 25){ $intro1.= (" humiliated the "); }elseif($margin > 24 && $margin < 28){ $intro1.= (" destroyed the "); }elseif($margin > 27 && $margin < 32){ $intro1.= (" put on a clinic, against the "); }elseif($margin > 31){ $intro1.= (" absolutely annihilated the "); } } $intro1.= $awayteamfirst; $intro1.= (" "); $intro1.= $awayteamlast; //$intro1.= (" led by coach "); //$intro1.= $awaycoach; $intro1.= (" , "); $intro1.= (" , at home , "); $intro1.= $hometeamscore; $intro1.= (" to "); $intro1.= $awayteamscore; $intro1.= (", "); if($margin > 31){ $intro1.= (" Bloody Pitiful mate "); }elseif($margin > 35){ $intro1.= (" You should probably retire "); $intro1.= $awaycoach; } }elseif($winna == "a"){ $margin = ($awayteamscore - $hometeamscore); $intro1.= $awayteamfirst; $intro1.= (" "); $intro1.= $awayteamlast; //$intro1.= (" led by coach "); //$intro1.= $awaycoach; $intro1.= (", "); if($hometeamscore == "0"){ $intro1.= (" skunked the "); }else{ if($margin < 3){ $intro1.= (" scraped out a win against the "); }elseif($margin > 2 && $margin < 7){ $intro1.= (" won in a close one against the "); }elseif($margin > 6 && $margin < 10){ $intro1.= (" came out on top against the "); }elseif($margin > 9 && $margin < 13){ $intro1.= (" got a solid win against the "); }elseif($margin > 12 && $margin < 16){ $intro1.= (" breezed to victory the "); }elseif($margin > 15 && $margin < 19){ $intro1.= (" put a proper hurting on the "); }elseif($margin > 18 && $margin < 22){ $intro1.= (" spanked the "); }elseif($margin > 21 && $margin < 25){ $intro1.= (" embarressed the "); }elseif($margin > 24 && $margin < 28){ $intro1.= (" blew up the "); }elseif($margin > 27 && $margin < 32){ $intro1.= (" took apart the "); }elseif($margin > 31){ $intro1.= (" killed the "); } } $intro1.= $hometeamfirst; $intro1.= (" "); $intro1.= $hometeamlast; //$intro1.= (" led by coach "); //$intro1.= $homecoach; $intro1.= (", on the road, "); $intro1.= $awayteamscore; $intro1.= (" to "); $intro1.= $hometeamscore; $intro1.= (", ."); if($margin > 31){ $intro1.= (" That's bloody awful mate, "); }elseif($margin > 35){ $intro1.= (" Good god "); $intro1.= $homecoach; $intro1.= (" that is pathetic, "); } }else{ $intro1.= $hometeamfirst; $intro1.= (" "); $intro1.= $hometeamlast; $intro1.= ("and"); $intro1.= $awayteamfirst; $intro1.= (" "); $intro1.= $awayteamlast; $intro1.= (" tied, well that's a rarity "); } if($winna == "h"){ $intro1.= (" Congratulations "); $intro1.= $homecoach; $intro1.= (" , well done mate! "); } else{ $intro1.= (" Congratulations "); $intro1.= $awaycoach; $intro1.= (" , well done, mate! "); } $intro1.= (" , , Right then. Its now time for ewwwkoos Fantasy Players of the Game! On offense, its "); $intro1.= $ofpgfirst; $intro1.= (" "); $intro1.= $ofpglast; $intro1.= (". "); $intro1.= $dfpgfirst; $intro1.= (" "); $intro1.= $dfpglast; $intro1.= (" is the Deefensive Fantasy Player of the Game and Finally, "); $intro1.= $stpgfirst; $intro1.= (" "); $intro1.= $stpglast; $intro1.= (" is your Special Teams Fantasy Player of the Game. "); ?>
Tom Wanchor's
Recap