MySQL-Login doesn't works anymore - 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-Login doesn't works anymore (/showthread.php?tid=282539)

---

MySQL-Login doesn't works anymore - DarthXela - 11.09.2011

Hello,
first thing : sorry for my bad english. I'm from Germany.
my problem :
My script gots a MySQL-Account-System.
Up to now there was no problem, but now the password don't gets retrieved.
I didn't changed anything on the script; i just putted in a MySQL-Housesystem-Filterscript.
It doesn't work since i had it in the server.
So i took it out again, but it has not achieved anything.
The connection is made : My MySQL-Whitelist works, and it detects, if the player gots an account, but it writes no new account and the password isn't taken.

The mysql_log-File :

[Sat Sep 10 20:12:07 2011] -------------------------
[Sat Sep 10 20:12:07 2011] Logging Started
[Sat Sep 10 20:12:07 2011] -------------------------
[Sat Sep 10 20:12:07 2011] Connected (0) to samp015 @ 62.75.145.37 via TCP/IP.
[Sat Sep 10 20:12:07 2011] MySQL Server Version 5.0.51a-24+lenny5.
[Sat Sep 10 20:13:02 2011] Error (0): Failed to exeute query. 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.

What can i do ? I don't know how to continue.

DarthXela

---

Re: MySQL-Login doesn't works anymore - Kingunit - 11.09.2011

---

AW: MySQL-Login doesn't works anymore - DarthXela - 11.09.2011

Ya, but i don't know, what is wrong.

---

Re: MySQL-Login doesn't works anymore - Vince - 11.09.2011

Log says it all.

---

AW: Re: MySQL-Login doesn't works anymore - DarthXela - 11.09.2011

Yes, i know, but i don't know, WHERE the syntax error is.

---

Re: MySQL-Login doesn't works anymore - Pinguinn - 11.09.2011

Post the queries you have

---

AW: MySQL-Login doesn't works anymore - DarthXela - 11.09.2011

SELECT user FROM whitelist WHERE user='%s' OR user='%s' LIMIT 1
SELECT * FROM banned WHERE IP = '%s'
SELECT * FROM accounts WHERE Username = '%s'
INSERT INTO whitelist (user) VALUES ('%s')
UPDATE whitelist SET user=md5('null') WHERE user='%s'
INSERT INTO accounts (Username, Password, IP, AdminLevel, PremiumLevel, Faction, Score, Money, Kills, Deaths, Handy) VALUES ('%s', '%s', '%s', '0', '0', '0', '0', '%d', '0', '0', '0')
SELECT * FROM accounts WHERE Username = '%s' AND Password = '%s'
UPDATE accounts SET IP = '%s' WHERE Username= '%s'
SELECT * FROM banned WHERE Username = '%s'
UPDATE accounts SET AdminLevel = '%d', Score = '%d', Money = '%d', Kills = '%d', Deaths = '%d' WHERE Username= '%s'
INSERT INTO banned (Username, IP, Banner, Reason) VALUES ('%s', '%s', '%s', '%s')
SELECT * FROM accounts WHERE Username = '%s'
UPDATE accounts SET Username = '%s'

I think, that's it. Need anything more ?

Edit : Do u need the context ?

---

Re: MySQL-Login doesn't works anymore - Pinguinn - 11.09.2011

Well, I don't really know what the problem is, but try removing the queries one by one to see which line is causing the error

---