new query[512], result[512]; format(query, sizeof(query), "SELECT `Inv` FROM `accounts` WHERE `Name` = '%s'", Name(playerid)); mysql_query(query, 1, 0, MySQL); mysql_store_result(); if(mysql_num_rows() == 1) { mysql_fetch_row_format(result, "|"); sscanf(result, "p<|>iiiiiiiiii", PlayerInfo[playerid][Inv][0], PlayerInfo[playerid][Inv][1], PlayerInfo[playerid][Inv][2], PlayerInfo[playerid][Inv][3], PlayerInfo[playerid][Inv][4], PlayerInfo[playerid][Inv][5], PlayerInfo[playerid][Inv][6], PlayerInfo[playerid][Inv][7], PlayerInfo[playerid][Inv][8], PlayerInfo[playerid][Inv][9]); } mysql_free_result();
[02:27:10] >> mysql_query_callback( Connection handle: 1 ) [02:27:11] >> mysql_store_result( Connection handle: 1 ) [02:27:11] CMySQLHandler::StoreResult() - No data to store. [02:27:11] >> mysql_num_rows( Connection handle: 1 ) [02:27:11] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [02:27:11] Passing query SELECT `Inv` FROM `accounts` WHERE `Name` = 'Sam_Just' | siii [02:27:11] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `Inv` FROM `accounts` WHERE `Name` = 'Sam_Just') [02:27:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [02:27:11] >> mysql_free_result( Connection handle: 1 ) [02:27:11] CMySQLHandler::FreeResult() - The result is already empty. [02:27:11] >> mysql_query_callback( Connection handle: 1 ) [02:27:11] >> mysql_store_result( Connection handle: 1 ) [02:27:11] CMySQLHandler::StoreResult() - Result was stored. [02:27:11] >> mysql_num_rows( Connection handle: 1 ) [02:27:11] CMySQLHandler::NumRows() - Returned 1 row(s) [02:27:11] >> mysql_fetch_row_format( Connection handle: 1 ) [02:27:11] CMySQLHandler::FetchRow() - Return: 1|2|4|5|0|0|0|0|0|3| [02:27:11] >> mysql_free_result( Connection handle: 1 ) [02:27:11] CMySQLHandler::FreeResult() - Result was successfully free'd. [02:27:11] OnQueryFinish(siii) - Threaded function called. [02:27:11] Passing query SELECT `InvAm` FROM `accounts` WHERE `Name` = 'Sam_Just' | siii [02:27:11] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `InvAm` FROM `accounts` WHERE `Name` = 'Sam_Just') [02:27:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [02:27:11] OnQueryFinish(siii) - Threaded function called.
, 1, 0, MySQL
new query[512];
format(query, 128, "SELECT `Inv` FROM `accounts` WHERE `Name` = '%s' LIMIT 1", Name(playerid));
mysql_query(query); // or mysql_query(query, -1, -1, MySQL);
mysql_store_result();
if(mysql_fetch_row(query))
{
sscanf(query, "p<|>iiiiiiiiii", PlayerInfo[playerid][Inv][0], PlayerInfo[playerid][Inv][1], PlayerInfo[playerid][Inv][2],
PlayerInfo[playerid][Inv][3], PlayerInfo[playerid][Inv][4], PlayerInfo[playerid][Inv][5], PlayerInfo[playerid][Inv][6],
PlayerInfo[playerid][Inv][7], PlayerInfo[playerid][Inv][8], PlayerInfo[playerid][Inv][9]);
}
mysql_free_result();
Why you are using this part
pawn Код:
pawn Код:
|