Versuche es so:
ocmd:members(playerid,params[])
{
new string[145], tmp[32], rang;
if(pInfo[playerid][pSektion] == 0) return SCM(playerid,COLOR_RED,"Du bist in keiner Fraktion!");
SCM(playerid,COLOR_YELLOW,"------ Fraktion-Mitglieder Liste ------");
format(string, sizeof(string), "SELECT Name, Online, Rang FROM accounts WHERE Fraktion = '%d'", pInfo[playerid][pSektion]);
mysql_query(string);
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_field_row(string,"Name");
mysql_fetch_field_row(tmp,"Rang");
rang = strval(tmp);
mysql_fetch_field_row(tmp,"Online");
if(strval(tmp) == 0)
{
format(string,sizeof(string),"Name: {FFFFFF}%s {FEF849}| Rang: {FFFFFF}%d {FEF849}| Status: {FF0000}OFFLINE",string,rang);
}
else
{
format(string,sizeof(string),"Name: {FFFFFF}%s {FEF849}| Rang: {FFFFFF}%d {FEF849}| Status: {00FF00}ONLINE",string, rang);
}
SCM(playerid,COLOR_YELLOW,string);
}
mysql_free_result();
SCM(playerid,COLOR_YELLOW,"-----------------------------------------------");
return 1;
}
Alles anzeigen
Das "Rang" musst du gegebenenfalls anpassen, an das wie es bei dir heißt.