20.03.2013, 18:27
i what to fetch player name but i fail code:
pawn Код:
CMD:testukas(playerid, params[])
{
mysql_query( "SELECT MAX(ID) FROM `vartotojai`" );
mysql_store_result();
if (mysql_num_rows())
{
new IDD = mysql_fetch_int(),
string[ 128 ];
mysql_query( "SELECT `Vardas` FROM `vartotojai` WHERE `ID` = '%i'", IDD);
mysql_store_result();
new fetch[ 24 ];
new Vardukas[ 24 ] = mysql_fetch_field_row(fetch, "Vardas");
format(string, sizeof(string), "Max ID: %i %s", IDD, Vardukas);
SendClientMessage(playerid,-1,string);
mysql_free_result();
}
mysql_free_result();
return 1;
}