ocmd:members(playerid, params[])
{
// if(!IsPlayerAdmin(playerid)) return 0;
new str[128];
if(PlayerInfo[playerid][FracID] == 0) return SCM(playerid,COOLRED,"You are in no Frac");
mysql_format(handle, str, sizeof(str), "SELECT * FROM `user` WHERE FracID = '%d'",PlayerInfo[playerid][FracID]);
mysql_tquery(handle, str, "OnFrakMembersLoad", "d", playerid);
}
forward OnFrakMembersLoad(playerid);
public OnFrakMembersLoad(playerid)
{
new count;
cache_num_rows(count);
if(count > 0)
{
SendClientMessage(playerid, USAGE, "Members:");
for(new i = 0; i < count; i++)
{
new username[25], Rank[25],showmembs[128];
cache_get_value_name(i, "Name", username);
format(showmembs,sizeof(showmembs),"%s%s %s",str,"Members",((PlayerInfo[i][pLoggedIn] == true)?("{6EF83C}[ONLINE]"):("{ff0000}[OFFLINE]")));
ShowPlayerDialog(playerid, 345, DIALOG_STYLE_LIST, "Members", showmembs, "Choose", "Exit");
}
}
else return SendClientMessage(playerid, RED, "There are currently no Members > Server Error!");
return 1;
}
Sollte so klappen, ist aber ungetestet.
Les dich am besten mal in die MySQL R41-4 rein:
[wiki]MySQL/R40[/wiki]