31.07.2012, 00:11
Hey guys, I'm wonderin' if you can help me with something. I've tried three separate queries, each... Have their own issues.
This one, works like a charm.
^ Simply adding ",Group" to the query causes this:
^ Works, but it causes the script to freeze and doesn't load the next line of code.
Ideas?
pawn Код:
format(bigstring, sizeof(bigstring), "SELECT ID,Username,Registered,FirstLogin,LastLogin,RegisteredIP,CharacterSlots,Banned,LastCreated,Muted FROM "SQL_ACC" WHERE Username = '%s'",GetName(playerid));
pawn Код:
format(bigstring, sizeof(bigstring), "SELECT ID,Username,Registered,FirstLogin,LastLogin,RegisteredIP,CharacterSlots,Banned,LastCreated,Muted,Group FROM "SQL_ACC" WHERE Username = '%s'",GetName(playerid));
Quote:
Error ID: 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 'Group FROM Accounts WHERE `Username` = 'Corello'' at line 1 |
pawn Код:
format(bigstring, sizeof(bigstring), "SELECT `ID`,`Username`,`Registered`,`FirstLogin`,`LastLogin`,`RegisteredIP`,`CharacterSlots`,`Banned`,`LastCreated`,`Muted`,`Group` FROM "SQL_ACC" WHERE Username = '%s'",GetName(playerid));
Ideas?