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
#2

any ideas?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)