SA-MP Forums Archive
Mysql not saving - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql not saving (/showthread.php?tid=648978)



Mysql not saving - DeksoN - 31.01.2018

Hello guys, im having problem, with my MYSQL, im running SATDM v12 by Jlalt MYSQL, and it's not saving money and score,the gamemode is saving cars, paintjobs,houses , just fine, but money and score not.
Can you please help me.
Im getting these errors in MYSQL log file.

https://pastebin.com/cYUBAwtK

Thank you in advance.


Re: Mysql not saving - Fratello - 31.01.2018

Show the query and it's usage.


Re: Mysql not saving - DeksoN - 31.01.2018

Here you go.

Код HTML:
format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS banneds(name VARCHAR(128), ip VARCHAR(128), date VARCHAR(128), time VARCHAR(128)\
  , bannedby VARCHAR(128), banned INT(10), reason VARCHAR(128), bdate INT(128), tempban INT(10) )");



Re: Mysql not saving - Mugala - 31.01.2018

you're using string instead of ints dude, change them into intergers (i/numbers).
by the way, u gave us wrong code.


Re: Mysql not saving - solstice_ - 31.01.2018

Quote:
Originally Posted by Mugalito
Посмотреть сообщение
you're using string instead of ints dude, change them into intergers (i/numbers).
by the way, u gave us wrong code.
Bro what's the problem between that? You are not helping anyone you're just saying random things all over the posts..


Re: Mysql not saving - Mugala - 31.01.2018

Quote:
Originally Posted by willbedie
Посмотреть сообщение
Bro what's the problem between that? You are not helping anyone you're just saying random things all over the posts..
actually there's a problem and I'm asking a question to get us in a solution.