Help... MySQL
#1

Код:
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...
Reply


Messages In This Thread
Help... MySQL - by SamJust - 17.09.2015, 23:10
Re: Help... MySQL - by SamJust - 17.09.2015, 23:21
Re: Help... MySQL - by SamJust - 17.09.2015, 23:30
Re: Help... MySQL - by Jefff - 17.09.2015, 23:46
Re: Help... MySQL - by SamJust - 20.09.2015, 10:00
Re: Help... MySQL - by SamJust - 20.09.2015, 22:03

Forum Jump:


Users browsing this thread: 2 Guest(s)