20.11.2013, 21:49
Quote:
Thanks the suggestion but even I change the PlayerQuery to PlayerQuery[999][MAX_PLAYERS] (Only for test) and have the same error.
|
Try defining
pawn Code:
new SQLQuery[2048]; //(I know it's too big) at the top of your script
Then to free your string you can use:
pawn Code:
SQLQuery[0] = 0; //(Before you format it, of course.)
mysql_format(mysqlConnectHandle, SQLQuery, sizeof(SQLQuery), "INSERT INTO `playerinfo` (`ipAdress`, `name`, `password`, `admin`, `moderator`, `vip`, `credits`, `language`, `timeMuted`, `timeJailed`, `banned`, `skin`, `spawnInterior`) VALUES ('%s', '%e', sha1('%e'), '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i')", PlayerInfo[playerid][ipAdress], PlayerInfo[playerid][name], PlayerInfo[playerid][password], PlayerInfo[playerid][admin], PlayerInfo[playerid][moderator], PlayerInfo[playerid][vip], PlayerInfo[playerid][credits], PlayerInfo[playerid][language], PlayerInfo[playerid][timeMuted], PlayerInfo[playerid][timeJailed], PlayerInfo[playerid][banned], PlayerInfo[playerid][skin], PlayerInfo[playerid][spawnInterior]);
mysql_tquery(mysqlConnectHandle, SQLQuery, "", "");