11.03.2018, 14:53
PHP код:
CMD:top10(playerid, params[])
{
new gString[900], query[70];
new rows = cache_num_rows();
mysql_format(g_SQL, query, sizeof query, "SELECT * FROM `players` WHERE `respect` > 0 ORDER BY `respect` DESC LIMIT 10", true);
mysql_tquery(g_SQL, query);
if (rows)
{
for (new i = 0; i < rows; i ++)
{
cache_get_value(i, "username", pInfo[playerid][Name], MAX_PLAYER_NAME);
cache_get_value_int(i, "respect", pInfo[playerid][Respect]);
format(gString, sizeof(gString), "%s%s (%s)", gString, pInfo[playerid][Name], pInfo[playerid][Respect]);
}
ShowPlayerDialog(playerid, DIALOG_TOP, DIALOG_STYLE_LIST, "/top10 players", gString, "Ok", "");
format(gString, sizeof(gString), "{99ff66}(INFO) %s ( %d ) is viewing /top10 table.", PlayerName[playerid], playerid);
SendClientMessageToAll(-1, gString);
}
return 1;
}