30.06.2018, 17:33
Quote:
The problem is not in INSERT query.
However a suggestion, use default values in mysql table. This way, you will not have to use so many '0' in your code and the query will be a lot smaller. Only strings require apostrophes around, not integers or floating-point numbers. Grave accent symbol is used if a column/table name has the same name as a SQL keyword to avoid conflicts, they are not required either for your case. Anyway, we will fix the UPDATE query which is faulty. Take a look here: pawn Код:
One more important thing: update data when they change. Level, skin etc can be updated when they change via commands/dialogs kicks, bans etc can be increased when admins take action against the said player |