GTAONLINE.PL :: [INNE] MySQL

Cze?? i czo?em. Robi? sys. osi?gni?? i mam pewien problem, chodzi z ich odczytem - w og?le nie dzia?a. Printowa?em "o1" czyli zmienn? l1 i w logach wyskoczy?a pusta linijka (tylko z czasem).

Kod:
Kod:
new stri[256];

	new l1, l2, l3, l4, l5, l6, l7, l8, l9, l10, l11, l12, l13, l14, l15, l16, l17, l18, l19, l20;

	GetPlayerName(playerid, plInfo[playerid][Nick], MAX_PLAYER_NAME);

	format(stri, sizeof(stri), "SELECT `Nick` FROM `Osiagniecia` WHERE `Nick` = '%s'", plInfo[playerid][Nick]);

	mysql_query(stri);

	mysql_store_result();

	if(mysql_num_rows() == 0)

	{

	    new Query[300];

	 	format(Query, sizeof(Query), "INSERT INTO `Osiagniecia` (`Nick`,`o1`,`o2`,`o3`,`o4`,`o5`,`o6`,`o7`,`o8`,`o9`,`o10`,`o11`,`o12`,`o13`,`o14`,`o15`,`o16`,`o17`,`o18`,`o19`,`o20`) VALUES ('%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",PlayerName(playerid),0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

		mysql_query(Query);

	}

	else

	{

    	format(stri, 256, "SELECT * FROM `Osiagniecia` WHERE `Nick` = '%s'", plInfo[playerid][Nick]);

		if(mysql_retrieve_row())

		{

			new result[35];

			mysql_get_field("o1", result);

			l1 = strval(result);

			mysql_get_field("o2", result);

			l2 = strval(result);

			mysql_get_field("o3", result);

			l3 = strval(result);

			mysql_get_field("o4", result);

			l4 = strval(result);

			mysql_get_field("o5", result);

			l5 = strval(result);

			mysql_get_field("o6", result);

			l6 = strval(result);

			mysql_get_field("o7", result);

			l7 = strval(result);

			mysql_get_field("o8", result);

			l8 = strval(result);

			mysql_get_field("o9", result);

			l9 = strval(result);

			mysql_get_field("o10", result);

			l10 = strval(result);

			mysql_get_field("o11", result);

			l11 = strval(result);

			mysql_get_field("o12", result);

			l12 = strval(result);

			mysql_get_field("o13", result);

			l13 = strval(result);

			mysql_get_field("o14", result);

			l14 = strval(result);

			mysql_get_field("o15", result);

			l15 = strval(result);

			mysql_get_field("o16", result);

			l16 = strval(result);

			mysql_get_field("o17", result);

			l17 = strval(result);

			mysql_get_field("o18", result);

			l18 = strval(result);

			mysql_get_field("o19", result);

			l19 = strval(result);

			mysql_get_field("o20", result);

			l20 = strval(result);

		}

		osiag[0][playerid] = l1;

		osiag[1][playerid] = l2;

		osiag[2][playerid] = l3;

		osiag[3][playerid] = l4;

		osiag[4][playerid] = l5;

		osiag[5][playerid] = l6;

		osiag[6][playerid] = l7;

		osiag[7][playerid] = l8;

		osiag[8][playerid] = l9;

		osiag[9][playerid] = l10;

		osiag[10][playerid] = l11;

		osiag[11][playerid] = l12;

		osiag[12][playerid] = l13;

		osiag[13][playerid] = l14;

		osiag[14][playerid] = l15;

		osiag[15][playerid] = l16;

		osiag[16][playerid] = l17;

		osiag[17][playerid] = l18;

		osiag[18][playerid] = l19;

		osiag[19][playerid] = l20;

	}

    mysql_free_result();
Za pomoc kilka piwek i rep +10