Re: Whats wrong?
Posted: Fri Feb 19, 2010 3:29 pm
Means the query first before you tried to use $result failed.
hint: look at mysql_error( $result)
hint: look at mysql_error( $result)
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$dbhost = 'localhost';
$dbuser = '********';
$dbpass = '********';
$dbname = '********;
if(!in_array($_SERVER['REMOTE_ADDR'],
array('81.20.151.38', '81.20.148.122'))) {
die("Error: Unknown IP");
}
mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error()); mysql_select_db("$dbname") or die(mysql_error());
$result = mysql_query("SELECT `player_id` FROM `wc3_player` WHERE `player_name` ='".$_GET['message']."'") or die(mysql_error());
if(mysql_num_rows($result) != 1) {
echo " No user found";exit;
}else{
$addxp = 75000;
$id = mysql_query("SELECT `tablename` `player_id` FROM `wc3_player` WHERE `player_name` ='".$_GET['message']."'");
mysql_query("UPDATE `database`.`wc3_player_race` SET `race_xp` = `race_xp` + ".$addxp." WHERE `wc3_player_race`.`player_id` = '1'' AND `wc3_player_race`.`race_id` =1");
echo "Points added";
}
?>