AccUpdate Problem

Hi,

I tried to get the "persistant character script" to update the game score. The php script works just fine. There are 3 variables, 2 are old (user,passcrc and score).

I have the following problem, when I call the function i get the error "Invalid Account Name"(So the script doesnt send the information correct to the php file). Here are the scripts.

The functions:

Quote:
function UpdateGameScore(%client, %name, %passcrc, %score)
{
%client = %this.clientid;
//Store the clients passcrc
%client.passcrc = %passcrc;
updateaccount(%client, %name, %passcrc, %score);
//give 30 seconds for response or boot him!
%client.loginLoop = schedule(30000, 0, "clientLoginFailed", %client);
}


function UpdateAccount(%client, %username, %passcrc, %accscore)
{
%client.authReturned = false;
%accquery = "user="@%username@"\t"@
"passcrc="@%passcrc@"\t"@
"score="@%score@"\r";
%accserver = $AuthServer;
%accpath = $AuthServerPath;
%accscript = %accpath @ "score.php";
%accupd = new HTTPObject(AccUpdate);
%client.sendObject = %accupd; //store object details just in case
%accupd.clientid = %client;
%accupd.get(%accserver, %accscript, %accquery);
}

function AccUpdate::onLine( %this, %line )
{
%client = %this.clientid;
//Check if webpage returns the word Updated on the frst line
if(StrStr(%line, "Updated") != -1)
{
messageClient(%client,
'MsgClient', '\c3Account Updated.',
%client.name,
%client,
%client.sendGuid,
%client.score,
%client.isAiControlled,
%client.isAdmin,
%client.isSuperAdmin);
cancel(%client.loginLoop);
return;
}

//otherwise, update failed!
error("- ",%line);
clientLoginFailed(%client);
}

function AccUpdate::onConnectionDied( %this )
{
%client = %this.clientid;
%accerror= "Connection Died";
AccountUpdateFailed(%client, %accerror);
}

function AccUpdate::onDNSFailed( %this )
{
%client = %this.clientid;
%accerror= "Connection Failed";
AccountUpdateFailed(%client, %accerror);
}

function AccUpdate::onConnectFailed( %this )
{
%client = %this.clientid;
%accerror= "Connection Failed";
AccountUpdateFailed(%client, %accerror);
}

function AccountUpdateFailed(%client, %accerror)
{
error("Error: " @ %accerror);
}

The php file:

Quote:
//Check username is valid else error and exit
if(is_null($user) || $user == "" || $user == " ")
{
echo "Auth Server - Invalid Account Name ";
exit();
}

//Check password is valid else error and exit
if(is_null($passcrc) || $passcrc == "" || $passcrc == " ")
{
echo "Auth Server - Invalid Password";
exit();
}

//Check Score is valid else error and exit
if(is_null($score) || $score == "" || $score == " ")
{
echo "Auth Server - No Score to add.";
exit();
}

//Check password and username match
$home = mysql_connect($auth_host, $auth_user, $auth_pass);
mysql_select_db($auth_dbase);
$query = "select * from account where username='$user'";
$result = mysql_query($query,$home);
$row = mysql_fetch_assoc($result);
$temppass = $row['password'];
$username = $row['username'];
$crcpass = crc32($temppass);
$accscore = $row['Kills'];
$allscore = $accscore+$score;

if($user != $username)
{
echo "Auth Server - Incorrect Username ";
exit();
}


if($user == $username && $crcpass != $passcrc)
{
echo "Auth Server - Incorrect Password ";
exit();
}

if($user == $username && $crcpass == $passcrc)
{
//Update score
$home1 = mysql_connect($auth_host, $auth_user, $auth_pass);
$query1 = "UPDATE account SET kills = '$allscore' WHERE username='$user'";
$result1 = mysql_query($query1,$home1);
//Advise Server of updated data
echo "Auth Server - Account updated!";
}


?>

Thx,
Chris