hotsport.info

Runkosarja - Pudotuspelit - Liigakarsinta

"; echo ""; echo "Lentopallon miesten SM-liigan pistetilastot $area

"; echo "Pisteet:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(p) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 20"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo ""; echo ""; echo "

"; echo "Pistekeskiarvo:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(h1+a1+t1)/count(*) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 10"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $pka=$access30["2"]; $pka=round($pka, 1); @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $pka, "; } } echo "

"; echo ""; echo "

"; echo "Hyökkäyspisteet:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(h1) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 10"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo "

"; echo ""; echo "

"; echo "Plus/miinus tehotilasto:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(pm) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 10"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo "

"; echo ""; echo "

"; echo "Torjunnat:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(t1) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 10"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo "

"; echo ""; echo "

"; echo "Ässäsyötöt:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(a1) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 10"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo "

"; echo ""; echo "

"; echo "Vastaanottoprosentti:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(v1+v2)/SUM(v1+v2+v3+v4)*100,SUM(v1+v2+v3+v4) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $vp=$access30["2"]; $v2=$access30["3"]; $vp=round($vp, 1); if ($v2 < 30){}else{ if ($i > 9){}else{ @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $vp, "; } }}} echo "

"; echo ""; echo "

"; echo "Hyökkäysprosentti:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(h1)/SUM(h1+h2+h3)*100,SUM(h1+h2+h3) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $hp=$access30["2"]; $h2=$access30["3"]; $hp=round($hp, 1); if ($h2 < 30){}else{ if ($i > 9){}else{ @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $hp, "; } }}} echo "

"; echo ""; echo "

"; echo "Syöttöprosentti:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(a1+a2)/SUM(a1+a2+a3+a4)*100,SUM(a1+a2+a3+a4) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $ap=$access30["2"]; $a2=$access30["3"]; $ap=round($ap, 1); if ($a2 < 15){}else{ if ($i > 9){}else{ @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $ap, "; } }}} echo "

"; if ($area == "Pudotuspelit"){$lid=122;} elseif ($area == "Liigakarsinta"){$lid=1222;} else {$lid=12; $area = "Runkosarja";} echo ""; echo "

"; echo "Lentopallon naisten SM-liigan pistetilastot $area

"; echo "Pisteet:
"; $i = 0; @$outcome30=mysql_query("SELECT TID,PID,SUM(p) FROM datalentis_data WHERE LID='$lid' AND year='$year' GROUP BY PID ORDER BY 3 DESC LIMIT 20"); require("failure.php"); while ($access30=mysql_fetch_array($outcome30)) { $TID=$access30["0"]; $PID=$access30["1"]; $p=$access30["2"]; @$outcome31=mysql_query("SELECT * FROM datalentis_players WHERE PID='$PID'"); while ($access31=mysql_fetch_array($outcome31)){ $lastname=$access31["lastname"]; $firstname=$access31["firstname"]; @$outcome31=mysql_query("SELECT * FROM datalentis_teams WHERE TID='$TID'"); while ($access31=mysql_fetch_array($outcome31)){ $team=$access31["shortname"]; } $i++; echo "$i) $firstname $lastname $team $p, "; } } echo "

"; echo ""; echo "