MySQL.
#10

pawn Код:
new adminstring[1024]/*Make the string as small as possible ;)*/, name[24], rank, online, string[10];  
mysql_query("SELECT * FROM admins WHERE alevel= 2");
mysql_store_result();
new numberofadmins = mysql_num_rows();
format(adminstring, sizeof(adminstring) "{FF0000}Current admins: %d{FFFFFF}\n", numberofadmins);
while(mysql_retrieve_row())
{
    mysql_fetch_field_row(name, "uname");
    mysql_fetch_field_row(string, "alevel"); rank = strval(string);
    mysql_fetch_field_row(string, "onlinestatus"); online = strval(string);
    format(adminstring, sizeof(adminstring), "%s\n%s (Level: %d Online: %d)", adminstring, name, rank, online);
}
mysql_free_result();
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_LIST, "Admins", adminstring, "OK", "");
Give that a go.
Reply


Messages In This Thread
MySQL. - by JoelR - 27.12.2012, 20:45
Re: MySQL. - by Peach - 27.12.2012, 20:48
Re: MySQL. - by JoelR - 27.12.2012, 20:52
Re: MySQL. - by JoelR - 27.12.2012, 20:58
Re: MySQL. - by Peach - 27.12.2012, 21:08
Re: MySQL. - by JoelR - 27.12.2012, 21:28
Re: MySQL. - by Unte99 - 27.12.2012, 22:01
Re: MySQL. - by JoelR - 27.12.2012, 22:03
Re: MySQL. - by JoelR - 28.12.2012, 00:06
Re: MySQL. - by [HiC]TheKiller - 28.12.2012, 01:44

Forum Jump:


Users browsing this thread: 2 Guest(s)