27.05.2012, 20:14
(
Last edited by starmaster014; 27/05/2012 at 08:48 PM.
)
Hey guys, i got a problem with MySQL.
I have a stock which returns the password of a user and that works fine:
But my problem is the stock which should return an Integer of a Field:
It gets called like this when a user login (for debugging):
printf("%s",mysql_GetInt("accounts", "Money", "Name", PlayerName(playerid)));
But in the log it just says "sqltest1" (thats a part from the password of the user, the full pw is "mysqltest1")
Why does it return a part of the password and not the integer from the right field?
Can someone help me? I use the mysql plugin by Strickenkid
greetz!
I have a stock which returns the password of a user and that works fine:
Code:
stock mysql_ReturnPasswort(Name[]) { new query[130], Get[130]; mysql_real_escape_string(Name, Name); format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name); mysql_query(query); mysql_store_result(); mysql_fetch_row(Get); mysql_free_result(); return Get; }
Code:
stock mysql_GetInt(Table[], Field[], Where[], Is[]) { new sqlint; new query[128]; mysql_real_escape_string(Table, Table); mysql_real_escape_string(Field, Field); mysql_real_escape_string(Where, Where); mysql_real_escape_string(Is, Is); format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is); mysql_query(query); mysql_store_result(); sqlint = mysql_fetch_int(connection); mysql_free_result(); return sqlint; }
printf("%s",mysql_GetInt("accounts", "Money", "Name", PlayerName(playerid)));
But in the log it just says "sqltest1" (thats a part from the password of the user, the full pw is "mysqltest1")
Why does it return a part of the password and not the integer from the right field?
Can someone help me? I use the mysql plugin by Strickenkid
greetz!