14.07.2011, 15:46
Quote:
|
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); Код:
error 075: input line too long (after substitutions) Код:
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", That request to be as fast, optimized, does not create lag and did not create big server load and server mysql load. |


