MySQL Player Password. - Printable Version

MySQL Player Password. - 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 Player Password. (/showthread.php?tid=567722)

MySQL Player Password. - TheSnaKe - 16.03.2015

nevermind

Re: MySQL Player Password. - BleverCastard - 16.03.2015

Your INSERT query is showing "%d" rather than "%s"(for your password).

Also, if you don't know how to use MySQL, I suggest not using it. You're scripting in two different languages using it for SA:MP(MySQL itself and PAWN langauge).

Re: MySQL Player Password. - TheSnaKe - 16.03.2015

Quote:

Originally Posted by BleverCastard

Your INSERT query is showing "%d" rather than "%s"(for your password).

Also, if you don't know how to use MySQL, I suggest not using it. You're scripting in two different languages using it for SA:MP(MySQL itself and PAWN langauge).

With "%s", my account is not even getting saved in the database.

Re: MySQL Player Password. - Abagail - 16.03.2015

Quote:

Originally Posted by TheSnaKe

With "%s", my account is not even getting saved in the database.

Probably because it's declared as an integer, where it should be a VARCHAR or a string in the database. As a earlier post stated, MySQL is another scripting language in itself and isn't plug-and-play. There is even a college degree for SQL, so don't think it'll be easy to use. Just a heads up, although changing it to a VARCHAR in the database should do the trick(and just an FYI - you should enable the MySQL debugging mode for things like that / check mysql_errors.log).

Re: MySQL Player Password. - TheSnaKe - 16.03.2015

deleted