Page 1 of 1

Help... again again :)

Posted: Tue Mar 02, 2004 8:04 pm
by Flamie

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 ?

Posted: Tue Mar 02, 2004 8:28 pm
by Flamie
anyone :(

Posted: Tue Mar 02, 2004 8:30 pm
by markl999
Instead of all that fetching, adding, updating you can just do one update, e.g
mysql_query("UPDATE clan_reg SET wins=wins+1 WHERE tag='{$_POST['winningclan']}'") or die(mysql_error());