Didn't notice. Lmao.
This should help. Change it to fit with your system/variables.
pawn Код:
mysql_format(MySQLCon, query, sizeof(query), "SELECT * FROM `players` WHERE `faction` = '%d'", pInfo[playerid][faction]);
mysql_tquery(MySQLCon, query, "", "");
new numrows = cache_get_rows();
new username[MAX_PLAYER_NAME], string[128];
if(numrows > 0)
{
for(new i; i < numrows; i++)
{
cache_get_field_content(i, "Username", username, 1, sizeof(username));
if(ReturnUser(username)) {
format(string, sizeof(string), "%s[ONLINE]", username);
return SendClientMessage(playerid, -1, string);
}
format(string, sizeof(string), "%s[OFFLINE]", username);
SendClientMessage(playerid, -1, string);
}
}
work how-ever I did it fast so it might have mistakes.