[PawnNewCommer]

I'm doing in my script, save the data in the player database.
Makes a request of this kind in Public updateaccount:

Код:

new query[MAX_STRING];
format(query,sizeof(query)," UPDATE players SET PlayerLevel=%d,AdminLevel=%d,Sex=%d,Age=%d,Money=%d,Kills=%d,...,..., etc. a lot of data (over 35)  WHERE id=%d",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pKills],
....
etc. a lot of data (over 50)
....
PlayerInfo[playerid][pSQLID]);
mysql_query(query);

When I compile the mod, I get an error:

Код:

error 075: input line too long (after substitutions)

in line:

Код:

format(query,sizeof(query)," UPDATE players SET PlayerLevel=%d,AdminLevel=%d,Sex=%d,Age=%d,Money=%d,Kills=%d,...,..., etc. a lot of data (over 35)  WHERE id=%d",

How to make a long query?
That request to be as fast, optimized, does not create lag and did not create big server load and server mysql load.