[iLearner]

PHP код:

COMMAND:rank(playerid, params[])
{
  if(playerData[playerid][playerLevel] >= 1) // your admin system here
  {
 
    new query[200], pname[24];
    format(query, sizeof(query),"SELECT username(whatever you called users row) FROM `playerdata`(what ever you called the table) WHERE CRank = 7 LIMIT 1");
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows(); 
   if(rows == 1)
    {
      while(mysql_fetch_row(query))
      {
        mysql_fetch_field("playerName", pname);
        new string[128];
        format(string, sizeof(string),"Username: %s  ",pname);
        SendClientMessage(playerid, 0xFF0000FF, string);
      }
      
    }
    if(!rows)
    {
      SendClientMessage(playerid, 0xFF0000FF,"SERVER: No players found with rank = 7");
    }
  }
  else return SendClientMessage(playerid, 0xFF0000FF,"You are not authorized to use this command!");
  mysql_free_result();
  return 1;
}