phpBB.de

Code: Alles auswählen

<?
$username="phpbb2";
$password="### dein passwort ###";
$database="phpbb2";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

//Tips auslesen
$query="SELECT * FROM phpbb_wm_tipps ORDER BY tipp_game";
$result=mysql_query($query);

$num=mysql_numrows($result);

//User abfragen
$query="SELECT * FROM phpbb_users";
$usersresult=mysql_query($query);

//Teams abfragen
$query="SELECT * FROM phpbb_wm_teams";
$teamsresult=mysql_query($query);

//Spiele abfragen
$query="SELECT * FROM phpbb_wm_games";
$gamesresult=mysql_query($query);


mysql_close();

//User zuordnen	
$anz=mysql_numrows($usersresult);
$i=0;
while ($i < $anz){
 $usernames[mysql_result($usersresult,$i,"user_id")]=mysql_result($usersresult,$i,"username");
 $userids[$i]=mysql_result($usersresult,$i,"user_id");
 $i++;
}

//Teams zuordnen
$anz=mysql_numrows($teamsresult);
$i=0;
while ($i < $anz){
 $teamnames[mysql_result($teamsresult,$i,"team_id")]=mysql_result($teamsresult,$i,"team_name");
 $teamflags[mysql_result($teamsresult,$i,"team_id")]=mysql_result($teamsresult,$i,"team_img");
 $i++;
}

//Spiele zuordnen
$anz=mysql_numrows($gamesresult);
$i=0;
while ($i < $anz){
 $gamenames[mysql_result($gamesresult,$i,"game_id")]='<td><img src="./images/wm/'.$teamflags[mysql_result($gamesresult,$i,"game_home")].'" border="0" /></td><td align=center>'. $teamnames[mysql_result($gamesresult,$i,"game_home")] . ' : ' . $teamnames[mysql_result($gamesresult,$i,"game_away")].'</td><td><img src="./images/wm/'.$teamflags[mysql_result($gamesresult,$i,"game_away")].'" border="0" /></td>';
 $i++;
}

echo "<b><center>Spielertips</center></b><br><br>";

//Ueber die Spieleintraege iterieren:
$j=0;
$anz_u=mysql_numrows($usersresult);
while ($j < $anz_u){
 $uid=$userids[$j];
 echo "<b>Mitspieler: $usernames[$uid]:</b><br><br>";
 $i=0;
 echo "<table border=\"1\" align=\"center\">";
 echo "<tr><th></th>";
 echo "<th>Begegnung</th>";
 echo "<th></th>";
 echo "<th>Tipp</th>";
 echo "<th>Pkt.</th></tr>";
 $grpcount=1;
 while ($i < $num) {

  $tippgame=mysql_result($result,$i,"tipp_game");
  $tippuser=mysql_result($result,$i,"tipp_user");
  $tipphome=mysql_result($result,$i,"tipp_home");
  $tippaway=mysql_result($result,$i,"tipp_away");
  $tipppoints=mysql_result($result,$i,"tipp_points");

  if($uid == $tippuser){
   if ($tippgame/6 > $grpcount){
    echo "<tr>";
    echo "<td></td>";
    echo "</tr>";
    $grpcount++;
   }
   echo "<tr>";
   echo "$gamenames[$tippgame]";
   echo "<td>";
   echo "$tipphome : $tippaway";
   echo "</td><td>";
   echo "$tipppoints";
   echo "</td></tr>";
  }
  $i++;
 }
 echo "</table>";
 echo "<br><hr><br>"; 
 $j++;
}

?>