02.10.2016, 07:44
I'm working on a basic register/login system with the latest version of MySQL and ran into an issue with saving string variables. When I register an account, everything appears fine in the database but when I disconnect, all the string variables appear blank.
I'm not sure where I'm going wrong here as no errors show up in the logs, so I was wondering if anyone else might know this issue.
pawn Код:
//Function that saves all stats on disconnect
public OnAccountSave(playerid)
{
new Float:x,Float:y,Float:z,Float:a;
GetPlayerPos(playerid,x,y,z); GetPlayerFacingAngle(playerid,a);
SaveAccountInt(playerid,"pID",Player[playerid][pID]);
SaveAccountString(playerid,"pName",Player[playerid][pName]);
SaveAccountString(playerid,"pPassword",Player[playerid][pPassword]);
SaveAccountString(playerid,"pSalt",Player[playerid][pSalt]);
//Other code
return 1;
}
//SaveAccountString function
public SaveAccountString(playerid,stat[],value[])
{
new query[128];
mysql_format(mysql,query,sizeof(query),"UPDATE `accounts` SET `%s` = '%e' WHERE `pID` = '%d'",stat,value,Player[playerid][pID]);
mysql_tquery(mysql,query,"","");
return 1;
}