mysql save accounts
#1

gamemode larp
accounts save in public OnPlayerUpdateEx(playerid)
accounts have 225 parameters(PlayerInfo)

passage function
Код:
public OnPlayerUpdateEx(playerid) 
{ 
MySQLCheckConnection(); 
new query[MAX_STRING]; 
format(query, MAX_STRING, "UPDATE players SET "); 
MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]); //strcat connect
MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "pLevel", PlayerInfo[playerid][pLevel]); 
MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "pSpawn", PlayerInfo[playerid][pSpawn]); 
MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]); 
}
get a very large request, and because of the restriction request is cut off, the server crashes
how to solve the problem?
if MAX_STRING > 2000,server crashed
Reply


Messages In This Thread
mysql save accounts - by hitmany - 11.04.2011, 13:09
Re: mysql save accounts - by hitmany - 13.04.2011, 14:12

Forum Jump:


Users browsing this thread: 1 Guest(s)