01.07.2014, 00:55
Can anyone tell me what I'm doing wrong here:
I have no idea why sscanf won't save the values to those variables, on the debug I get this:
The only thing I get is a warning in the console saying 'string buffer overflow', but I don't think that's the problem
pawn Код:
stock LoadStats(playerid)
{
format(Query, sizeof(Query), "SELECT * FROM `jugadores` WHERE nickname = '%s'", pName(playerid));
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Query, "|");
sscanf(Query, "p<|>s[24]s[128]s[16]ddddd", pInfo[playerid][nickname],pInfo[playerid][pass],pInfo[playerid][IP],
pInfo[playerid][score],pInfo[playerid][kills],pInfo[playerid][deaths],pInfo[playerid][money],pInfo[playerid][AdminLvl]);
printf("Money: %d", pInfo[playerid][money]);
mysql_free_result();
return 1;
}
Код:
0:15:04] CMySQLHandler::Query(SELECT * FROM `jugadores` WHERE nickname = 'Onfroi') - Successfully executed. [20:15:04] >> mysql_store_result( Connection handle: 1 ) [20:15:04] CMySQLHandler::StoreResult() - Result was stored. [20:15:04] >> mysql_fetch_row_format( Connection handle: 1 ) [20:15:04] CMySQLHandler::FetchRow() - Return: 4|Onfroi|a94a8fe5ccb19ba61c4c0873d391e987982fbbd3|127.0.0.1|0|0|0|1000|0 [20:15:04] >> mysql_free_result( Connection handle: 1 ) [20:15:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [20:15:04] >> mysql_free_result( Connection handle: 1 ) [20:15:04] CMySQLHandler::FreeResult() - The result is already empty. [20:15:10] >> mysql_query( Connection handle: 1 ) [20:15:10] CMySQLHandler::Query(UPDATE `jugadores` SET `score`='0', `kills`='0', `deaths`='0', `money`='0', `AdminLvl`='0' WHERE (`nickname` = 'Onfroi')) - Successfully executed.
