[Eth]

Quote:

Originally Posted by ****** I'll tell you this: Neither of you are even close! As I said, go learn SQL.

If you know the answer then why don't you help him instead of doing those comments? lol.
and this one you posted up here:

pawn Код:

format(query, sizeof (query), "UPDATE `users` DELETE `pass`, `salt` FROM `users` WHERE `id` = '%i'", gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query, false, "", "");

is totally wrong.
try to delete one after an other And make sure that your code is the same as this:

pawn Код:

new query[300];
    format(query, sizeof (query), "DELETE `pass` FROM `users` WHERE `id` = '%i'",
    gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query, false, "", "", "");

then:

pawn Код:

new query2[300];
    format(query2, sizeof (query2), "DELETE `salt` FROM `users` WHERE `id` = '%i'",
    gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query2, false, "", "", "");

full code:

pawn Код:

new query[300];
    format(query, sizeof (query), "DELETE `pass` FROM `users` WHERE `id` = '%i'",
    gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query, false, "", "", "");
    new query2[300];
    format(query2, sizeof (query2), "DELETE `salt` FROM `users` WHERE `id` = '%i'",
    gPlayerInfo[playerid][pID]);
    mysql_function_query(gHandle, query2, false, "", "", "");