Where is better way mysql?
#6

Personally, i update every single query ad every update trough a function i did:

SavePlayerDataInt(playerid, field[], value);

Suggest you not saving users with a giant query, it's really heavy when you've got a roleplay gamemode with tons of fields.

Anyway, to update all the data you have to call it one by one in this way:

Код:
UPDATE `users` SET moneys = %i, level = %i, admin = %i WHERE `id` = %i
Reply


Messages In This Thread
Where is better way mysql? - by qmnty - 17.05.2015, 01:34
Re: Where is better way mysql? - by Konstantinos - 17.05.2015, 09:23
Re: Where is better way mysql? - by qmnty - 17.05.2015, 09:37
Re: Where is better way mysql? - by Konstantinos - 17.05.2015, 09:44
Re: Where is better way mysql? - by qmnty - 20.05.2015, 06:24
Re: Where is better way mysql? - by icra - 20.05.2015, 06:29
Re: Where is better way mysql? - by qmnty - 20.05.2015, 06:47
Re: Where is better way mysql? - by PowerPC603 - 20.05.2015, 20:38

Forum Jump:


Users browsing this thread: 1 Guest(s)