phpBB.de

Code: Alles auswählen

<?php 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

// 
// Start session management 
// 
$userdata = session_pagestart($user_ip, PAGE_WM); 
init_userprefs($userdata); 
// 
// End session management 
// 

include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_wm.'.$phpEx); 

// 
// Check login status 
// 
if ( !$userdata['session_logged_in'] ) 
{ 
        redirect(append_sid("login.$phpEx")); 
} 


// 
// Check auth status 
// 
if ( $wm_config['restrict_to'] != 0 && !get_wm_auth() && $userdata['user_level'] != ADMIN && $userdata['user_id'] != $wm_config['wm_mod_id'] ) 
{ 
        $auth_msg = sprintf($lang['wm_access_denied'], '<a href="' . append_sid("groupcp.$phpEx?g=".$wm_config['restrict_to']) . '" class="gen">', '</a>', '<a href="'.append_sid("index.$phpEx").'" class="gen">', '</a>'); 
        message_die(GENERAL_MESSAGE, $auth_msg); 
} 

include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

@mysql_select_db($dbname) 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 user_id, username FROM " . USERS_TABLE; 
$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); 



//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]; 
//Tips zum User 

$query2="SELECT * FROM `phpbb_wm_tipps` WHERE `tipp_user` = '$uid' ORDER BY `tipp_game`"; 

$result2=mysql_query($query2); 

$num2=mysql_numrows($result2); 

if($num2 > 0) 

 { 
 echo "<b>Mitspieler: $usernames[$uid]</b><br><br>"; 
 $i=0; 
 echo "<table border=\"0\" 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++; 
   } 
  //Weltmeistertipp 
  if ($tippgame != 65){ 
           echo "<tr>"; 
           echo "$gamenames[$tippgame]"; 
           echo "<td>"; 
           echo "$tipphome : $tippaway"; 
           echo "</td><td>"; 
           echo "$tipppoints"; 
           echo "</td></tr>"; 
        } 
  else { 
           echo "Weltmeistertipp: "; 
                $querywm="SELECT team_name FROM phpbb_wm_teams WHERE team_id = '$tipphome' "; 
                $wmtipp=mysql_query($querywm); 
                $weltmeistertipp=mysql_result($wmtipp,0,"team_name"); 
           echo " <b> $weltmeistertipp</b>"; 
        } 
  } 
  $i++; 
 } 
 echo "</table>"; 
 echo "<br><hr><br>"; 
} 
 $j++; 
} 

include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>