Code: Select all
<?php
<?php
include('header.php');
$dbhost = "localhost";
$dbuser = "USER";
$dbpass = "PASS";
$dbname = "wormahol_ecl";
$sql = mysql_connect( "$dbhost", "$dbuser", "$dbpass" );
mysql_select_db( $dbname, $sql );
$check = mysql_fetch_array( mysql_query( "select password from clan_reg where tag = '$_POST[winningclan]'" ) );
if (!$_POST['password'] || !$_POST['win1'] || !$_POST['win2'] || !$_POST['los1'] || !$_POST['los2'] || (md5( $_POST['password'] ) != $check['password'] ) )
{
print "
<font class='menutitle'>Report</font><br><br>
<form method='post' action='".$_SERVER['PHP_SELF']."'>
<center>
<h1><u>Game <i>Reporting</i></u></h1>
<table cellpadding='0' cellspacing='0 border='0' bgcolor='#000000' align='center'><tr><td>
<table cellspacing='1' cellpadding='4' width='100%'>
<tr>
<td align='center' class='head'>Description</td>
<td class='head' align='center'>Input</td>
</tr>
<tr>
<td align='center' class='row1'>Winning Clan:</td>
<td class='row1' align='left'>
<select name='winningclan' size='1' style='width:140px;'>
<option selected value='0'>-Winning clan/</option>";
$query = mysql_query( "SELECT * FROM `clan_reg` ORDER BY `tag`" );
for($i=1;$i<=mysql_num_rows($query);$i++)
{
$thisrow = mysql_fetch_array($query);
print "<option value='$thisrow[tag]'>$thisrow[tag]</option>";
}
print"</td></tr>
<td align='center' class ='row2'>Password:</td>
<td class ='row2'><input type='text' name='password' size='30' align='left'>
</td>
</tr>
<tr>
<td align='center' class='row1'>Losing Clan:</td>
<td class='row1' align='left'>
<select name='losingclan' size='1' style='width:140px;'>
<option selected value='0'>-Losing clan\/</option>";
$query = mysql_query( "SELECT * FROM `clan_reg` ORDER BY `tag`" );
for($i=1;$i<=mysql_num_rows($query);$i++)
{
$thisrow = mysql_fetch_array($query);
print "
<option value='$thisrow[tag]'>$thisrow[tag]</option>";
}
print"
<tr>
<td align='center' class='row2'>Scheme:</td>
<td class='row2' align='left'>
<select name='gametype' size='1' style='width:140px;'>
<option selected>-Select Scheme\/</option>
<option value='BnG'>BnG</option>
<option value='Elite'>Elite</option>
<option value='Pro'>Pro</option>
<option value='Roper'>Roper</option>
<option value='RopeRace'>Rope Race</option>
<option value='Shopper'>Shopper</option>
<option value='Team17'>Team17</option>
<option value='Other'>Other</option>
</select>
</td>
</tr>
<tr>
<td align='center' class='row1'>Winner 1:</td>
<td class='row1' align='left'><input type='text' name='win1' size='30'></td>
</tr>
<tr>
<td align='center' class='row2'>Winner 2:</td>
<td class='row2' align='left'><input type='text' name='win2' size='30'></td>
</tr>
<tr>
<td align='center' class='row1'>Loser 1:</td>
<td class='row1' align='left'><input type='text' name='los1' size='30'></td>
</tr>
<tr>
<td align='center' class='row2'>Loser 2:</td>
<td class='row2' align='left'><input type='text' name='los2' size='30'></td>
</tr>
<tr>
<td align='center' class='row1' colspan='2'><input type='submit' value='Submit' name='submit'></td>
</tr>
</table>
</td></tr></table>
<br>
</center>
</form>";
}
else
{
$winningclan = addslashes( $_POST['winningclan'] );
$losingclan = addslashes( $_POST['losingclan'] );
$gametype = addslashes( $_POST['gametype'] );
$win1 = addslashes( $_POST['win1'] );
$win2 = addslashes( $_POST['win2'] );
$los1 = addslashes( $_POST['los1'] );
$los2 = addslashes( $_POST['los2'] );
$newwin = mysql_fetch_array( mysql_query( "select wins from clan_reg where tag = '$_POST[winningclan]'" ) );
$newlos = mysql_fetch_array( mysql_query( "select losses from clan_reg where tag = '$_POST[losingclan]'" ) );
$addgame1 = mysql_fetch_array( mysql_query( "select games from clan_reg where tag = '$_POST[winningclan]'" ) );
$addgame2 = mysql_fetch_array( mysql_query( "select games from clan_reg where tag = '$_POST[losingclan]'" ) );
$addscore = mysql_fetch_array( mysql_query( "select points from clan_reg where tag = '$_POST[winningclan]'" ) );
$newwin = ".$newwin." + 1 ;
$newlos = ".$newlos." + 1 ;
$addgame1 = ".$addgame." + 1 ;
$addgame2 = ".$addgame." + 1 ;
$addscore = ".$addscore." + 2 ;
mysql_query("UPDATE clan_reg SET wins='$newwin' WHERE tag='$_POST[winningclan]'");
mysql_query("UPDATE clan_reg SET losses='$newlos' WHERE tag='$_POST[losingclan]'");
mysql_query("UPDATE clan_reg SET games='$addgame1' WHERE tag='$_POST[winningclan]'");
mysql_query("UPDATE clan_reg SET games='$addgame2' WHERE tag='$_POST[losingclan]'");
mysql_query("UPDATE clan_reg SET points='$addscore' WHERE tag='$_POST[winningclan]'");
mysql_query( "INSERT INTO games_rep ( clanid1, clanid, type, win_play1, win_play2, los_play1, los_play2 ) VALUES ( '$winningclan', '$losingclan', '$gametype', '$win1', '$win2', '$los1', '$los2' )" );
mysql_close( $sql );
}
include('footer.php');
?>
?>hmm, I had to post teh whole script, because there's a little problem, whenver this script is ran twice in a row, this part doesnt seem to work :
Code: Select all
<?php
$newwin = mysql_fetch_array( mysql_query( "select wins from clan_reg where tag = '$_POST[winningclan]'" ) );
$newlos = mysql_fetch_array( mysql_query( "select losses from clan_reg where tag = '$_POST[losingclan]'" ) );
$addgame1 = mysql_fetch_array( mysql_query( "select games from clan_reg where tag = '$_POST[winningclan]'" ) );
$addgame2 = mysql_fetch_array( mysql_query( "select games from clan_reg where tag = '$_POST[losingclan]'" ) );
$addscore = mysql_fetch_array( mysql_query( "select points from clan_reg where tag = '$_POST[winningclan]'" ) );
$newwin = ".$newwin." + 1 ;
$newlos = ".$newlos." + 1 ;
$addgame1 = ".$addgame." + 1 ;
$addgame2 = ".$addgame." + 1 ;
$addscore = ".$addscore." + 2 ;
mysql_query("UPDATE clan_reg SET wins='$newwin' WHERE tag='$_POST[winningclan]'");
mysql_query("UPDATE clan_reg SET losses='$newlos' WHERE tag='$_POST[losingclan]'");
mysql_query("UPDATE clan_reg SET games='$addgame1' WHERE tag='$_POST[winningclan]'");
mysql_query("UPDATE clan_reg SET games='$addgame2' WHERE tag='$_POST[losingclan]'");
mysql_query("UPDATE clan_reg SET points='$addscore' WHERE tag='$_POST[winningclan]'");
?>It does add 1 points to the stuff on the 1st time, then on the 2nd time it does everything but this...
Does anyone know why ?