MySQL.
#6

pawn Код:
new admins[250], query[100], name[24], rank, online, string[256];  
format(query, sizeof(query), "SELECT * FROM admins WHERE alevel= 2");
mysql_query(query);
mysql_store_result();
new numberofadmins = mysql_num_rows();
for(new admins1 = 0; admins1 < numberofadmins; admins1++)
{
    while(mysql_retrieve_row())
    {
        mysql_fetch_field_row(admins, "uname"); format(name, sizeof(name), "%s", admins);
        mysql_fetch_field_row(admins, "alevel"); rank = strval(admins);
        mysql_fetch_field_row(admins, "onlinestatus"); online = strval(admins);
        admins1 ++;
    }
}
mysql_free_result();

format(string, sizeof(string), "%s\n%s (Level: %d Online: %d)", string, name, rank, online);
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_LIST, "Admins", string, "OK", "");
That's not working.

It displays the first person in it at that's it.
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: 1 Guest(s)