SA-MP Forums Archive
mysql_real_escape_string crashing server? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql_real_escape_string crashing server? (/showthread.php?tid=411068)


mysql_real_escape_string crashing server? - Johndaonee - 27.01.2013

I've had these random server crashes lately and it's all about this query that crashes it

Quote:

[18:13:11] UPDATE `accounts` SET Password = '\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\]\ะบ\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\', Level = '92', Admin = '92', Banned = '92', Sex = '92', Tutorial = '92', Bank = '234', Experience = '93', Money = '92', Skin = '92', SpawnPoint = '92', HouseKey = '92', BizKey = '92', pRefunder = '92', LoadPosX = '0.000000', LoadPosY = '0.000000', LoadPosZ = '0.000000', LoadPosInt = '0', LoadPosW = '0', Crashed = '92', DeadPosX = '0.000000', DeadPosY = '0.000000', DeadPosZ = '0.000000', V1 = '1373', V2 = '0', V3 = '0', V4 = '0', V5 = '0', V6 = '0', V7 = '0', V8 = '0', V9 = '0', V10 = '0', CarKey = '92', Savings = '92', Cell = '92', Forum = '\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \', Gun0 = '0', Gun1 = '0', Gun2 = '0', Gun3 = '0', Gun4 = '0', Gun5 = '0', Gun6 = '0', Gun7 = '0', Gun8 = '0', Gun9 = '41', Gun10 = '0', Gun11 = '0', Gun12 = '0', GunAmmo0 = '0', GunAmmo1 = '0', GunAmmo2 = '0', GunAmmo3 = '0', GunAmmo4 = '0', GunAmmo5 = '0', GunAmmo6 = '0', GunAmmo7 = '0', GunAmmo8 = '0', GunAmmo9 = '50', GunAmmo10 = '0', GunAmmo11 = '0', GunAmmo12 = '0', Tax = '92', TaxDay = '\\\\\\\\\\\\\\\\\\\\\\\\\\\', TaxCounter = '92', WarehouseKey = '92' WHERE UserID = '92'
Has anybody had anything like this before? These '\\\\\\\\\\' are coming out of no-where, the integers are all returning 92 and the strings are all \\\\\\\\\\

The password is whirlpooled, all the strings are escaped as shown under this.

mysql_real_escape_string( PlayerInfo[playerid][pNote1], PlayerInfo[playerid][pNote1] );


What happens is it saves somebodies account before this one comes and then the server crashes when this query has been run and then some of the current accounts are bugged (wrong stats)