Logo

zurück

info("clicked showAllUsersSpecialTipps.php5"); printSpecials(); function printSpecials(){ echo "

Spezial-Tipps

"; echo "
"; echo ""; echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; $table_users=dbschema::users; $sql="SELECT * FROM $table_users t where username!='admin' ORDER BY lastname,firstname"; $sqlResult=mysql_query($sql); while($array=mysql_fetch_array($sqlResult)){ echo ""; printSpecialsForUser($array["username"]); echo ""; } echo "
UserWeltmeisterZweitplatzierterPlatz 3Torschützenkönig
"; } function printSpecialsForUser($username){ $dbutil=new dbutil(); $worldChampion=$dbutil->getRostrumPrediction($username, 1); $vice=$dbutil->getRostrumPrediction($username, 2); $third=$dbutil->getRostrumPrediction($username, 3); $tippTopscorer=$dbutil->getTopScorerPrediction($username); $tippedTeam=$dbutil->getTopScorerTeamPrediction($username); echo ""; echo "" . getUserInfo($username) . ""; echo "" . $worldChampion . ""; echo "" . $vice . ""; echo "" . $third . ""; echo "" . $tippTopscorer . "($tippedTeam)" . ""; echo ""; } function getUserInfo($username){ $tableusers=dbschema::users; $sql="SELECT * from $tableusers WHERE username='$username'"; $resultUser=mysql_query($sql); $array=mysql_fetch_array($resultUser); $firstname=$array["firstname"]; $lastname=$array["lastname"]; return "$firstname $lastname"; } ?>