Change experience to all players MYSQL
#6

Quote:
Originally Posted by introzen
View Post
Just as the error itself tells you, you're trying to save an int value to a pre-defined string.
Code:
error 035: argument type mismatch (argument 2)
pawn Code:
cache_get_value_int(0, nameOnTable, skillLVL);
whereas
pawn Code:
new nameOnTable[64];
I'd suggest you do read up on mysql and then complete the command rather than making a temp one to later re-do it. This way is inefficient.

Also, rather use a switch() on skillselect than if/else statements, much simpler.
Just like UserID, is string
cache_get_value_int(0, "UserID", userID);

And it's working...

Quote:
Originally Posted by SymonClash
View Post
Code:
update yourplayerstable set skill_level_name = 0
I dont want to set to 0, i want to get the old value and set the new value = old value / 2
Reply


Messages In This Thread
Change experience to all players MYSQL - by binnyl - 24.03.2019, 15:46
Re: Change experience to all players MYSQL - by binnyl - 25.03.2019, 01:35
Re: Change experience to all players MYSQL - by binnyl - 29.03.2019, 04:48
Re: Change experience to all players MYSQL - by introzen - 29.03.2019, 09:11
Re: Change experience to all players MYSQL - by SymonClash - 29.03.2019, 09:23
Re: Change experience to all players MYSQL - by binnyl - 30.03.2019, 06:37

Forum Jump:


Users browsing this thread: 1 Guest(s)