13.08.2012, 20:31
So right know I've got this code:
This query, however, fails for some odd reason. When I check the logs for the printed string, it gives me the correct data:
In the MySQL logs, however, it shows me this:
I have no idea why it does this. So far, I've noticed that the 'is' part directs back to the format parameter in mysql_function_query.
Could anyone help me out on this one?
pawn Code:
new str[128];
format(str, sizeof str, "SELECT player_password FROM players WHERE player_name = '%s' LIMIT 1", p_info[playerid][player_name]);
printf("query: %s", str);
mysql_function_query(mysql_conn, str, true, "mysql_logreg", "is", playerid, inputtext);
Code:
query: SELECT player_password FROM players WHERE player_name = 'krispykreme' LIMIT 1
Code:
Passing query SELECT player_password FROM players WHERE player_name = 'krispykreme' LIMIT 1 | is
Could anyone help me out on this one?

