21.09.2016, 23:18
hey guys i have a /adminlist where it shows Name - AdminLevel - StaffPoints - HoursPlayed and it shows only if you have adminlevel 1 or bigger but it shows Players without admin , can some help what is wrong with this code ?
Код HTML:
CMD:adminlist(playerid, params[]) { if(gLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_ERROR, "Tu nu esti logat si nu poti sa folosesti aceasta comanda!"); if(!IsManager(playerid)) return SendClientMessage(playerid, COLOR_ERROR, "Nu ai gradul necesar ca sa folosesti aceasta comanda!"); const max_sort = 10; new string[500 + (MAX_PLAYER_NAME+1)*max_sort]; new Cache:result = mysql_query(handle, "SELECT * FROM `players` WHERE `AdminLevel` + `StaffPoints` + `HoursPlayed` > 2 ORDER BY `AdminLevel` DESC LIMIT 10"); new tmp = cache_num_rows(); if(tmp) { strcat(string,"Nume\tAdmin Level\tPuncte Staff\tOre jucate\n"); for(new i,a[11],c[11],h[11],n[MAX_PLAYER_NAME]; i<tmp; i++) { cache_get_field_content(i, "Name", n); cache_get_field_content(i, "AdminLevel", c); cache_get_field_content(i, "StaffPoints", a); cache_get_field_content(i, "HoursPlayed", h); format(string,sizeof(string),"%s%s\t%d\t%d\t%d\t%d\n",string,n,strval©,strval(a),strval(h)); } } cache_delete(result); if(string[0] == EOS) return SendClientMessage(playerid, COLOR_ERROR, "Nici un admin in baza de date!"); ShowPlayerDialog(playerid, 525242, DIALOG_STYLE_TABLIST_HEADERS, "Lista adminilor", string, "Iesi", ""); return 1; }