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

Click here for complete definitions of 2017 stats tracked

[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=”ChampS3 “;
} else if ($vdispc == “2”) {
$champ=”&c=2″; $champcode=”CombinedS3 “;
} else {
$champ=”&c=0”; $champcode=”S3 “; $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 BeatPercentage DESC”;
} else if ($vdispo == “15”) {
$sortop=”&sort=15″; $odisp=” ORDER BY Penalties 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 `Total Games` DESC”;
} else if ($vdispo == “19”) {
$sortop=”&sort=19″; $odisp=” ORDER BY `Drives` DESC”;
} else if ($vdispo == “20”) {
$sortop=”&sort=20″; $odisp=” ORDER BY `PlusMinus` DESC”;
} else if ($vdispo == “21”) {
$sortop=”&sort=21″; $odisp=” ORDER BY `BeatsDefensed` DESC”;
} else if ($vdispo == “22”) {
$sortop=”&sort=22″; $odisp=” ORDER BY `Games Played` DESC”;
} else {
$odisp=” ORDER BY LastName”;
}

[/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 ”

2017 MLQ Stats

“;
echo ”

Individual Quaffle Stats“;
echo ‘

‘;
echo ‘

‘; echo ”

First Name Last Name Team Games Goals Assists Shots Turnovers Takeaways Shot Blocks Cards

“;
$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[‘Games Played’] . “” . $row[‘Total Goals’] . “” . $row[‘Total Assists’] . “” . $row[‘Total Shots’] . “” . $row[‘Total Turnovers’] . “” . $row[‘Total Takeaways’] . “” . $row[‘Total Blocks’] . “” . $row[‘Penalties’] . ”

\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 TotalBeaterStats”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2017 MLQ Stats

“;
echo ”

Individual Beater Stats“;
echo ”

Stats Legend:

    • “;
    echo “

 

  • +/-: The number of goals scores minus the number of goals allowed by the team while this beater is on the field

 

“;
echo ”

 

  • Bt%: The percentage of all attempted beats that successfully knock out at least one target

 

“;
echo ”

 

  • BtAtt: The number of bludger throws a beater makes

 

“;
echo ”

 

  • ABR: The Adjusted Beating Range. 1 is a close range beat (within arm’s reach), 2 is a midrange beat and 3 is a long range beat (around 8 yards is the divider)

 

“;
echo ”

 

  • BtDef: The total number of defended beats by block, dodge and catch

 

“;
echo ”

 

  • TO Forced: the number of times the quaffle was turned over to the beater’s team due to the beater’s actions

 

“;
echo ”

 

  • 0 Forced: the number of times a zero bludger opportunity was afforded to the offense due to that beater’s actions

 

“;
echo ”

 

  • Cards: the total number of blue, yellow and red cards awarded to this player

 

“;
echo ”

 

“;
echo ‘

‘;
echo ‘

‘; echo ”

First Name Last Name Team Games Drives +/- Bt% BtAtt ABR BtDef TO Forced 0 Forced Cards

\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[‘Games Played’] . “” . $row[‘Drives’] . “” . $row[‘PlusMinus’] . “” . $row[‘BeatPercentage’] . “” . $row[‘BeatAttempts’] . “” . round($row[‘ABR’],3) . “” . $row[‘BeatsDefensed’] . “” . $row[‘TurnoversForced’] . “” . $row[‘NoBludgersForced’] . “” . $row[‘Penalties’] . ”

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

“;
echo ”

“;
mysql_close();
}
[/insert_php]