CMD:viplevel1(playerid, params[])
{
new query[80];
new
ID,
output[800];
mysql_format(mysql, query, sizeof(query), "SELECT user FROM players WHERE level = 1");
new Cache:result = mysql_query(mysql, query);
new rows, fields;
cache_get_data(rows, fields, mysql);
if(rows)
{
new
username[24];
ID ++;
cache_get_field_content(0, "user",username, mysql, 24);
format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, username);
ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", output, "OK", "Cancel");}
else {
ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", "No vip of this level.", "OK", "Cancel");}
cache_delete(result);
return 1;
}
You can make a loop to loop through all VIP players, and display each string for each VIP-player.
|
CMD:viplevel1(playerid, params[])
{
new query[80];
new
ID,
output[800];
mysql_format(mysql, query, sizeof(query), "SELECT user FROM players WHERE level = 1");
new Cache:result = mysql_query(mysql, query);
new rows, fields;
cache_get_data(rows, fields, mysql);
while(rows != 0)
{
new
username[24];
rows --;
cache_get_field_content(ID, "user",username, mysql, 24);
ID ++;
format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, username);
ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", output, "OK", "Cancel");}
else {
ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", "No vip of this level.", "OK", "Cancel");}
cache_delete(result);
return 1;
}