ich hab ein kleines Problem


Statt 5:3 gestern gegen Arg hab ich 5:4 eingegeben.
Kann man denn diese Spiel komplett löschen und das Endergebnis neu eintragen ???
Es geht ja hier auch um die richtige vergabe der Punkte.
Danke schon mal.
DP
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);
?>