[SkyFlare]

Quote:

Originally Posted by Stefhan Why should I not use LIMIT 1 there? Could you please explain?

Because in your mysql line, you specifically are only updating 1 account row in MySQL at a time anyway
Why add extra mysql commands when youve already basically made it update 1 anyway,

Limiting it to 1 in another area such as saving player information before they quit the server, could possibly miss saving other players data if I am not wrong, but anyone else feel free to correct me if I am wrong...

BUT I do know that limit is used for specific mysql queries such as the following, read it, youll get an understanding
http://www.mysqltutorial.org/mysql-limit.aspx
Dont just read the top, read right through, you might actually find some use for it later on

pawn Код:

mysql_format(g_SQL, query, sizeof(query),"UPDATE `accounts` SET `helper` = %i WHERE `acc_dbid` = '%i' LIMIT 1",value, PlayerInfo[targetid][pHelper]);

pawn Код:

WHERE `acc_dbid` = '%i'