Advertisement
Guest User

Untitled

a guest
Feb 27th, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. CMD:myraport(playerid, params[])
  2. {
  3. if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to log in first.");
  4. if(!IsAMember(playerid)) return SCM(playerid,COLOR_WHITE,"You are not a member of a mafia.");
  5. new x = PlayerInfo[playerid][pMember], string[189], sendername[30], id, killerid, turf;
  6. if(x <= 0) return 1;
  7. GetPlayerName(id, sendername, sizeof(sendername));
  8. {
  9. foreach(new i : Player)
  10. {
  11. format(string, sizeof(string), "--------------- [{008080}%s{FFFFFF}] faction activity ---------------", sendername);
  12. SCM(i, -1, string);
  13. format(string, sizeof(string), "War Kills: {008080}%d{FFFFFF} / War Deaths: {008080}%d{FFFFFF}",ucideri[killerid][turf], decese[i][turf]);
  14. SCM(i, -1, string);
  15. format(string, sizeof(string), "Deposited drugs: {008080}%d{FFFFFF} / Deposited materials: {008080}%d{FFFFFF}",PlayerInfo[i][pDrugsDeposit], PlayerInfo[i][pMatsDeposit]);
  16. SCM(i, -1, string);
  17. format(string, sizeof(string), "Deposited money: {008080}%d{FFFFFF}", PlayerInfo[i][pMoneyDeposit]);
  18. SCM(i, -1, string);
  19. mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE `MoneyDeposit`='%d' AND `name`='%s'", PlayerInfo[i][pMoneyDeposit], PlayerInfo[i][pNormalName]);
  20. mysql_tquery(SQL,string,"","");
  21. mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE `MatsDeposit`='%d' AND `name`='%s'", PlayerInfo[i][pMatsDeposit], PlayerInfo[i][pNormalName]);
  22. mysql_tquery(SQL,string,"","");
  23. mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE 'DrugsDeposit' ='%d' AND name = '%s'", PlayerInfo[i][pDrugsDeposit], PlayerInfo[i][pNormalName]);
  24. mysql_tquery(SQL,string,"","");
  25. }
  26. }
  27. return 1;
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement