04.08.2015, 11:46
I am mind-fucked right now. I don't even know why it works on SELECT but it doesn't work using INSERT or I've done something wrong or the specifier wasn't explained properly and confused a lot of people.
Detecting if register or not
Register
Am I doing something wrong? or the new updates aren't documented properly.
Detecting if register or not
pawn Код:
new rows;
rows = db_parse(dataBase, ""TABLE_ACCOUNTS"", ""FIELD_USERNAME" = %q", playerData[playerid][playerUsername]);
pawn Код:
[12:43:15] [db_log_queries]: SELECT * FROM `Accounts` WHERE Username = Wells
[12:43:15] [Warning] db_query: Query failed: no such column: Wells - (no colums, so proceed to register menu.)
pawn Код:
new dbQuery[210];
WP_Hash(playerData[playerid][playerPassword], 129, inputtext);
format(dbQuery, sizeof(dbQuery), "INSERT INTO "TABLE_ACCOUNTS" ("FIELD_USERNAME", "FIELD_PASSWORD") VALUES (%q, %q)", playerData[playerid][playerUsername], playerData[playerid][playerPassword]);
db_free_result(db_query(dataBase, dbQuery));
pawn Код:
[12:43:20] [db_log_queries]: INSERT INTO Accounts (Username, Password) VALUES (, )
[12:43:20] [Warning] db_query: Query failed: near ",": syntax error
[12:43:20] [Error] db_free_result(): invalid result handle 0
[12:43:20] INSERT INTO Accounts (Username, Password) VALUES (, )