Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. CMD:members(playerid, params[])
  2. {
  3. if(PlayerInfo[playerid][pMember] >= 1 && PlayerInfo[playerid][pRank] >= 5)
  4. {
  5. new aim[5000],
  6. query[300],
  7. test[300],
  8. test1[300],
  9. test2[300],
  10. test3[300],
  11. test4[300],
  12. aimtotal[5000],
  13. result[300],
  14. idd,
  15. mid=0;
  16. format(query, sizeof(query), "SELECT * FROM `users` WHERE `users`.`Member` = '%d' ORDER BY `users`.`Rank` DESC LIMIT 50", PlayerInfo[playerid][pMember]);
  17. new Cache: membresult = mysql_query(SQL, query);
  18. for(new i, j = cache_get_row_count (); i != j; ++i)
  19. {
  20. cache_get_field_content(i, "name", result); format(test, 300, result);
  21. cache_get_field_content(i, "Rank", result); format(test1, 300, result);
  22. cache_get_field_content(i, "lastOn", result); format(test2, 300, result);
  23. cache_get_field_content(i, "FWarn", result); format(test3, 300, result);
  24. cache_get_field_content(i, "FactionTime", result); format(test4, 300, result);
  25. idd = cache_get_field_content_int(i, "id");
  26. Selected[playerid][mid] = idd;
  27. new id = GetPlayerID(test);
  28. if(id != INVALID_PLAYER_ID)
  29. {
  30. format(aim, sizeof(aim), "%s%s - %s\tonline right now\t%s/3 fw\t%s days\n", aim, test1, test, test3, test4);
  31. }
  32. else
  33. {
  34. format(aim, sizeof(aim), "%s%s - %s\t%s\t%s/3 fw\t%s days\n", aim, test1, test, test2, test3, test4);
  35. }
  36. mid++;
  37. }
  38. cache_delete(membresult);
  39. format(aimtotal, sizeof(aimtotal), "Rank - Name\tLast Login\tFW\tDays in faction\n%s",aim);
  40. if(PlayerInfo[playerid][pRank] >= 6)
  41. {
  42. ShowPlayerDialog(playerid,DIALOG_MEMBERS,DIALOG_STYLE_TABLIST_HEADERS,"Faction members",aimtotal,"Select","Exit");
  43. }
  44. else
  45. {
  46. ShowPlayerDialog(playerid,DIALOG_MEMBERS,DIALOG_STYLE_TABLIST_HEADERS,"Faction members",aimtotal,"Exit","");
  47. }
  48. }
  49. return 1;
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement