Please select from the following options to display statistics from season 2.

[insert_php]
global $vdisps;
global $vdispt;
global $vdispo;
global $vdispc;
global $pageop;
global $teamop;
global $tdisp;
global $sortop;
global $odisp;
global $champ;
global $champcode;

$vdisps = $_GET[‘page’];
$vdispt = $_GET[‘d’];
$vdispo = $_GET[‘sort’];
$vdispc = $_GET[‘c’];

if ($vdispt == “0”) {
$teamop=”&d=0″; $tdisp = “”;
} else if ($vdispt == “1”) {
$teamop=”&d=1″; $tdisp = “WHERE Team=’NYC'”;
} else if ($vdispt == “2”) {
$teamop=”&d=2″; $tdisp = “WHERE Team=’BOS'”;
} else if ($vdispt == “3”) {
$teamop=”&d=3″; $tdisp = “WHERE Team=’WAS'”;
} else if ($vdispt == “4”) {
$teamop=”&d=4″; $tdisp = “WHERE Team=’OTT'”;
} else if ($vdispt == “5”) {
$teamop=”&d=5″; $tdisp = “WHERE Team=’IND'”;
} else if ($vdispt == “6”) {
$teamop=”&d=6″; $tdisp = “WHERE Team=’CLE'”;
} else if ($vdispt == “7”) {
$teamop=”&d=7″; $tdisp = “WHERE Team=’DET'”;
} else if ($vdispt == “8”) {
$teamop=”&d=8″; $tdisp = “WHERE Team=’ROC'”;
} else if ($vdispt == “9”) {
$teamop=”&d=9″; $tdisp = “WHERE Team=’LC'”;
} else if ($vdispt == “10”) {
$teamop=”&d=10″; $tdisp = “WHERE Team=’AUS'”;
} else if ($vdispt == “11”) {
$teamop=”&d=11″; $tdisp = “WHERE Team=’KC'”;
} else if ($vdispt == “12”) {
$teamop=”&d=12″; $tdisp = “WHERE Team=’NO'”;
} else if ($vdispt == “13”) {
$teamop=”&d=13″; $tdisp = “WHERE Team=’SLC'”;
} else if ($vdispt == “14”) {
$teamop=”&d=14″; $tdisp = “WHERE Team=’LA'”;
} else if ($vdispt == “15”) {
$teamop=”&d=15″; $tdisp = “WHERE Team=’SF'”;
} else if ($vdispt == “16”) {
$teamop=”&d=16″; $tdisp = “WHERE Team=’PHX'”;
}

if ($vdispc == “1”) {
$champ=”&c=1″; $champcode=”ChampS2 “;
} else if ($vdispc == “2”) {
$champ=”&c=2″; $champcode=”CombinedS2 “;
} else {
$champ=”&c=0”; $champcode=”S2 “; $vdispc=”0”;
}

if ($vdispo == “1”) {
$sortop=”&sort=1″; $odisp=” ORDER BY FirstName”;
} else if ($vdispo == “2”) {
$sortop=”&sort=2″; $odisp=” ORDER BY LastName”;
} else if ($vdispo == “3”) {
$sortop=”&sort=3″; $odisp=” ORDER BY Team”;
} else if ($vdispo == “4”) {
$sortop=”&sort=4″; $odisp=” ORDER BY `Total Goals` DESC”;
} else if ($vdispo == “5”) {
$sortop=”&sort=5″; $odisp=” ORDER BY `Total Assists` DESC”;
} else if ($vdispo == “6”) {
$sortop=”&sort=6″; $odisp=” ORDER BY `Total Shots` DESC”;
} else if ($vdispo == “7”) {
$sortop=”&sort=7″; $odisp=” ORDER BY `Total Turnovers` DESC”;
} else if ($vdispo == “8”) {
$sortop=”&sort=8″; $odisp=” ORDER BY `Total Takeaways` DESC”;
} else if ($vdispo == “9”) {
$sortop=”&sort=9″; $odisp=” ORDER BY `Total Blocks` DESC”;
} else if ($vdispo == “10”) {
$sortop=”&sort=10″; $odisp=” ORDER BY Beats DESC”;
} else if ($vdispo == “11”) {
$sortop=”&sort=11″; $odisp=” ORDER BY BeatAttempts DESC”;
} else if ($vdispo == “12”) {
$sortop=”&sort=12″; $odisp=” ORDER BY ABR DESC”;
} else if ($vdispo == “13”) {
$sortop=”&sort=13″; $odisp=” ORDER BY TurnoversForced DESC”;
} else if ($vdispo == “14”) {
$sortop=”&sort=14″; $odisp=” ORDER BY ControlLost DESC”;
} else if ($vdispo == “15”) {
$sortop=”&sort=15″; $odisp=” ORDER BY ControlGained DESC”;
} else if ($vdispo == “16”) {
$sortop=”&sort=16″; $odisp=” ORDER BY NoBludgersForced DESC”;
} else if ($vdispo == “17”) {
$sortop=”&sort=17″; $odisp=” ORDER BY `Total Games` DESC”;
} else if ($vdispo == “18”) {
$sortop=”&sort=18″; $odisp=” ORDER BY `Average Goals` DESC”;
} else if ($vdispo == “19”) {
$sortop=”&sort=19″; $odisp=” ORDER BY `Average Assists` DESC”;
} else if ($vdispo == “20”) {
$sortop=”&sort=20″; $odisp=” ORDER BY `Average Shots` DESC”;
} else if ($vdispo == “21”) {
$sortop=”&sort=21″; $odisp=” ORDER BY `Average Turnovers` DESC”;
} else if ($vdispo == “22”) {
$sortop=”&sort=22″; $odisp=” ORDER BY `Average Takeaways` DESC”;
} else if ($vdispo == “23”) {
$sortop=”&sort=23″; $odisp=” ORDER BY `Average Blocks` DESC”;
} else if ($vdispo == “24”) {
$sortop=”&sort=24″; $odisp=” ORDER BY `Total Games` DESC”;
} else if ($vdispo == “25”) {
$sortop=”&sort=25″; $odisp=” ORDER BY `Average Beats` DESC”;
} else if ($vdispo == “26”) {
$sortop=”&sort=26″; $odisp=” ORDER BY `Average Beat Attempts` DESC”;
} else if ($vdispo == “27”) {
$sortop=”&sort=27″; $odisp=” ORDER BY `Average Turnovers Forced` DESC”;
} else if ($vdispo == “28”) {
$sortop=”&sort=28″; $odisp=” ORDER BY `Average Control Lost` DESC”;
} else if ($vdispo == “29”) {
$sortop=”&sort=29″; $odisp=” ORDER BY `Average Control Gained` DESC”;
} else if ($vdispo == “30”) {
$sortop=”&sort=30″; $odisp=” ORDER BY `Average No-Bludgers Forced` DESC”;
} else if ($vdispo == “31”) {
$sortop=”&sort=31″; $odisp=” ORDER BY `Drives` DESC”;
} else if ($vdispo == “32”) {
$sortop=”&sort=32″; $odisp=” ORDER BY `PlusMinus` DESC”;
} else if ($vdispo == “33”) {
$sortop=”&sort=33″; $odisp=” ORDER BY `BeatsDefensed` DESC”;
}

[/insert_php]

SELECT TEAM TO DISPLAY

SELECT GAMES:

Regular Season

Championship

Combined

STATS TO DISPLAY

[insert_php]
if ($vdisps == “a1” || $vdisps == “”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalQuaffleStats”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2016 MLQ Stats

“;
echo ”

Individual Quaffle Stats“;
echo ‘

‘; echo ”

First Name Last Name Team Total Goals Total Assists Total Shots Total Turnovers Total Takeaways Total Blocks

“;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Goals’] . “” . $row[‘Total Assists’] . “” . $row[‘Total Shots’] . “” . $row[‘Total Turnovers’] . “” . $row[‘Total Takeaways’] . “” . $row[‘Total Blocks’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “b1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalQuaffleStatsPerGame”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2016 MLQ Stats

“;
echo ”

Quaffle Stats Per Game“;
echo ‘

‘; echo ”

First Name Last Name Team Games Rostered Avg Goals Avg Assists Avg Shots Avg Turnovers Avg Takeaways Avg Blocks

“;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Games’] . “” . $row[‘Average Goals’] . “” . $row[‘Average Assists’] . “” . $row[‘Average Shots’] . “” . $row[‘Average Turnovers’] . “” . $row[‘Average Takeaways’] . “” . $row[‘Average Blocks’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “d1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalBeaterStats”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2016 MLQ Stats

“;
echo ”

Individual Beater Stats“;
echo ‘

‘; echo ”

First Name Last Name Team Drives +/- Beats BeatAtts Avg Range BtsDef TO Forced Ctrl+ Ctrl- No-Bldg Forced

\r\n”;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Drives’] . “” . $row[‘PlusMinus’] . “” . $row[‘Beats’] . “” . $row[‘BeatAttempts’] . “” . round($row[‘ABR’],3) . “” . $row[‘BeatsDefensed’] . “” . $row[‘TurnoversForced’] . “” . $row[‘ControlLost’] . “” . $row[‘ControlGained’] . “” . $row[‘NoBludgersForced’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “c1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalBeaterStatsPerGame”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2016 MLQ Stats

“;
echo ”

Individual Beater Stats“;
echo ‘

‘; echo ”

First Name Last Name Team Games Rostered Avg Beats Avg Beat Attempts Avg Range Avg Turnovers Forced Avg Control Lost Avg Control Gained Avg No-Bludgers Forced

\r\n”;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Games’] . “” . $row[‘Average Beats’] . “” . $row[‘Average Beat Attempts’] . “” . round($row[‘ABR’],3) . “” . $row[‘Average Turnovers Forced’] . “” . $row[‘Average Control Lost’] . “” . $row[‘Average Control Gained’] . “” . $row[‘Average No-Bludgers Forced’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
}
[/insert_php]