/showall (Advance RolePlay)

[Good_Wilson]

/showall Advance RolePlay

CMD:showall(playerid, params[])
{
	if(PlayerLogged{playerid} == 0) return true;
	if(PlayerInfo[playerid][pLeader] == F_MIN1 || PlayerInfo[playerid][pLeader] == F_MIN2 || PlayerInfo[playerid][pLeader] == F_MIN3 || PlayerInfo[playerid][pLeader] == F_MIN4) return SendMes(playerid, COLOR_GREY, "Данная функция для вас запрещенна");
	new want_text[256], want,sttr[2000];
	new level,rank,namep[32];
	new member = PlayerInfo[playerid][pLeader];
	if(PlayerInfo[playerid][pLeader] > 0)
	{
		format(query, sizeof(query), "SELECT * FROM `"TABLE_ACCOUNT"` WHERE `member` = '%i'", member);
		mysql_query(query);
		mysql_store_result();
		if(mysql_num_rows() > 0)
		{
			format(want_text,sizeof(want_text),"Уровень\tРанг\tИмя\n\n");
			strcat(sttr, want_text);
			for(new i = 1; i < mysql_num_rows(); i++)
			{
				if(mysql_fetch_row_format(query))
				{
					mysql_get_field("level", var); level = strval(var);
					mysql_get_field("rank", var); rank = strval(var);
					mysql_get_field("name", namep);
				}
				format(want_text,sizeof(want_text), "{FFFFFF}%i\t%i\t%s\n", level, rank-1, namep);
				strcat(sttr, want_text);
				want++;
			}
		}
		format(string, 100, "{00D600}Показаны %i/45 игроков", want);
		ShowPlayerDialog(playerid, D_NULL, DIALOG_STYLE_MSGBOX, string, sttr, "Закрыть", "");
	}
	mysql_free_result();
	return true;
}