Players may be selected from the 2017 Seasonal Statistics page to display here.

[insert_php]
global $pid;
$pid = $_GET[‘player’];

if ($pid==0 || $pid==””) {
echo ”

No player selected.

“;
} else {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalQuaffleStatsS3 WHERE Player=”.$pid;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo ‘

‘;
echo ”; echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
$clean=””;
if ($row[‘Blues’]+$row[‘Yellows’]+$row[‘Reds’]==0 && $row[‘Games Played’] > 2) { $clean=”✅”; }
echo “”;
}
echo ”

“.$row[‘FirstName’].” “.$row[‘LastName’].” “.$row[‘Team’].”
Chaser Statistics Games Played: “.$row[‘Games Played’].”
Goals Shots Shot % Assists
“.$row[‘Total Goals’].” “.$row[‘Total Shots’].” “.$row[‘Shot Percent’].” “.$row[‘Total Assists’].”
Turnovers Tackles Takeaways Shot Blocks
“.$row[‘Total Turnovers’].” “.$row[‘Tackles’].” “.$row[‘Total Takeaways’].” “.$row[‘Total Blocks’].”
Blue Cards Yellow Cards Red Cards
“.$row[‘Blues’].” “.$row[‘Yellows’].” “.$row[‘Reds’].” “.$clean.”

“;
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalBeaterStatsS3 WHERE Player=”.$pid;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo ‘

‘; echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;
echo “”;}
echo ”

“.$row[‘FirstName’].” “.$row[‘LastName’].” “.$row[‘Team’].”
Beater Statistics Games Played: “.$row[‘Games Played’].”
Total Drives:”.$row[‘Drives’].” +/-: “.$row[‘PlusMinus’].”
Beats Def Catches Blocks Dodges TO forced 0B Forced
“.$row[‘BeatsDefensed’].” “.$row[‘BeatsCaught’].” “.$row[‘BeatsBlocked’].” “.$row[‘BeatsDodged’].” “.$row[‘TurnoversForced’].” “.$row[‘NoBludgersForced’].”
Close, mid and long range beat attempts & percent
Close Bt% Close BtAtt Mid Bt% Mid BtAtt Long Bt% Long BtAtt
“.$row[‘CRBP’].”% “.$row[‘CRBA’].” “.$row[‘MRBP’].”% “.$row[‘MRBA’].” “.$row[‘LRBP’].”% “.$row[‘LRBA’].”
Blue Cards Yellow Cards Red Cards
“.$row[‘Blues’].” “.$row[‘Yellows’].” “.$row[‘Reds’].”

“;
}
[/insert_php]