[Jon_De]

Quote:

Originally Posted by 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.

Use strcat