[Tutorial] [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool]
#13

Quote:
Originally Posted by AndySedeyn
View Post
Update your plugin and include to MySQL R39-3.
I knew it was that, I must have replaced the wrong folder, it's working as it should now... Thanks for that, I knew it was something to do with outdated plugins. Glad I tried it again.

An update though, it's now doing it for 'GetPlayerCash', is this supposed to be in there?

GetPlayerCash(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);

If so what plugin does this go under, I only have the a_mysql and a_samp and whirlpool atm.

EDIT: I changed it to GetPlayerMoney (assuming you just had cash and money mixed around) and it compiled properly.

EDIT 2: Everythings running, plugins running, wamp running, dialog box pops up and the right credentials are inside the script, but whenever I register an account, nothing is being sent to the database.

PHP Code:
[18:25:04] [DEBUGmysql_tquery connection1query"INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Admin`, `"callback"OnAccountRegister"format"i"
[18:25:04] [DEBUGCMySQLQuery::Execute[OnAccountRegister] - starting query execution
[18:25:04] [ERRORCMySQLQuery::Execute[OnAccountRegister] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[18:25:04] [DEBUGCMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError 
Reply


Messages In This Thread
[UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 19.05.2015, 20:48
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Konstantinos - 19.05.2015, 21:25
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 19.05.2015, 21:29
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by MikE1990 - 20.05.2015, 13:47
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by sammp - 20.05.2015, 15:03
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 20.05.2015, 15:06
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by SKAzini - 20.05.2015, 17:54
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 20.05.2015, 17:57
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Antonio144 - 28.05.2015, 17:51
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 29.05.2015, 14:25
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by BR3TT - 29.05.2015, 23:54
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 30.05.2015, 06:11
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by BR3TT - 30.05.2015, 08:04
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 30.05.2015, 08:27
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 30.05.2015, 08:39
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by BR3TT - 30.05.2015, 10:38
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by STONEGOLD - 11.06.2015, 01:20
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 11.06.2015, 16:34
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by STONEGOLD - 11.06.2015, 19:39
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by dudu.r.oliveira - 13.06.2015, 15:46
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Denis1 - 15.06.2015, 13:01
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 15.06.2015, 14:33
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by MD5 - 15.06.2015, 16:49
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 15.06.2015, 17:07
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by sonanclar - 16.06.2015, 01:57
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by JaydenJason - 03.07.2015, 10:14
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AchievementMaster360 - 10.07.2015, 17:42
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 10.07.2015, 18:01
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Billeen - 20.07.2015, 14:10
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Overhaul - 20.07.2015, 14:21
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by saffierr - 18.03.2016, 13:09
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 18.03.2016, 13:12
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by saffierr - 18.03.2016, 13:15
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 18.03.2016, 13:29
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by saffierr - 18.03.2016, 17:07
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 18.03.2016, 17:32
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Konstantinos - 12.06.2016, 21:36
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by WhiteGhost - 12.06.2016, 23:23
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Slawiii - 13.06.2016, 00:49
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Konstantinos - 13.06.2016, 10:13
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Problems - 16.06.2016, 16:03
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 18.06.2016, 08:55
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Ankon - 02.07.2016, 10:55
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by faizal16 - 30.10.2016, 05:44
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Tenka - 01.12.2016, 05:15
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by AndySedeyn - 01.12.2016, 18:36
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Dorito - 04.12.2016, 09:25
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by KNIGHT786 - 07.12.2016, 13:33
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Yaa - 07.12.2016, 13:34
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by eikzdej - 14.01.2017, 01:42
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Lordzy - 14.01.2017, 04:49
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by eikzdej - 14.01.2017, 11:07
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by Lordzy - 14.01.2017, 14:00
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by justinnater - 18.01.2017, 09:48
Re: [UPDATED 19/05/2015]MySQL Registration System [Threaded Queries + Whirlpool] - by JudyMoody - 24.03.2018, 12:17

Forum Jump:


Users browsing this thread: 1 Guest(s)