[SamJust]

Код:

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();

Sometimes this code gives the result I need, but most of the times it returns a bunch of zeros...

[SamJust]

It supposed to return somethin like 1|2|3|0|0|0|0|0|, and it does it if u call the function not in OnPlayerConnect, but if u call it OnPlayerConnect it gives back 0|0|0|0|0|0|0|0|

[SamJust]

Код:

[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.

This is the crazy stuf I get in mysql_log.txt

[Jefff]

Why you are using this part

pawn Код:

, 1, 0, MySQL

pawn Код:

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();

[SamJust]

Quote:

Originally Posted by Jefff Why you are using this part pawn Код: , 1, 0, MySQL pawn Код: 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();

for some reason I can't compile it without numbers, and -1 -1 did not help.

[SamJust]

Ok, when I chaged MySQL Pawno plugin it sudenly started working.