Samp Server /Stats Problem
#9

Quote:
Originally Posted by Calisthenics
Посмотреть сообщение
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 Код:
Headshots` = '%s', `Kills` = '%s', `Deaths` = '%s',
These are not strings, change to %d specifier. Change all of them.

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
I have setted default values and don't work
Reply


Messages In This Thread
Samp Server /Stats Problem - by Cezar98 - 30.06.2018, 16:06
Re: Samp Server /Stats Problem - by Calisthenics - 30.06.2018, 16:11
Re: Samp Server /Stats Problem - by Cezar98 - 30.06.2018, 16:14
Re: Samp Server /Stats Problem - by Calisthenics - 30.06.2018, 16:17
Re: Samp Server /Stats Problem - by Cezar98 - 30.06.2018, 16:18
Re: Samp Server /Stats Problem - by Calisthenics - 30.06.2018, 16:35
Re: Samp Server /Stats Problem - by Cezar98 - 30.06.2018, 16:48
Re: Samp Server /Stats Problem - by Calisthenics - 30.06.2018, 17:05
Re: Samp Server /Stats Problem - by Cezar98 - 30.06.2018, 17:33
Re: Samp Server /Stats Problem - by Verc - 30.06.2018, 17:39

Forum Jump:


Users browsing this thread: 1 Guest(s)