PHP код:
CMD:topgroups(playerid,params[])
{
new
query[256];
new
DBResult:result;
format(query,sizeof(query),"SELECT GroupName, GroupKills FROM Groups ORDER BY GroupName, GroupKills DESC limit 3");
result = DB::Query(query);
new
gangkills,
gangname[30],
string[512];
for (new a; a < db_num_rows(result); a++, db_next_row(result))
{
db_get_field_assoc(query, "GroupName", gangname, sizeof(gangname));
gangkills = db_get_field_assoc_int(query, "GroupKills");
format(string,sizeof(string),"%s\nRank: %d - Name: %s - Kills: %i", string, a + 1, gangname, gangkills);
}
ShowPlayerDialog(playerid, 0xABCD, DIALOG_STYLE_MSGBOX, "Top Groups", string, "Close", "");
db_free_result(result);
return 1;
}