Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CMD:myraport(playerid, params[])
- {
- if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to log in first.");
- if(!IsAMember(playerid)) return SCM(playerid,COLOR_WHITE,"You are not a member of a mafia.");
- new x = PlayerInfo[playerid][pMember], string[189], sendername[30], id, killerid, turf;
- if(x <= 0) return 1;
- GetPlayerName(id, sendername, sizeof(sendername));
- {
- foreach(new i : Player)
- {
- format(string, sizeof(string), "--------------- [{008080}%s{FFFFFF}] faction activity ---------------", sendername);
- SCM(i, -1, string);
- format(string, sizeof(string), "War Kills: {008080}%d{FFFFFF} / War Deaths: {008080}%d{FFFFFF}",ucideri[killerid][turf], decese[i][turf]);
- SCM(i, -1, string);
- format(string, sizeof(string), "Deposited drugs: {008080}%d{FFFFFF} / Deposited materials: {008080}%d{FFFFFF}",PlayerInfo[i][pDrugsDeposit], PlayerInfo[i][pMatsDeposit]);
- SCM(i, -1, string);
- format(string, sizeof(string), "Deposited money: {008080}%d{FFFFFF}", PlayerInfo[i][pMoneyDeposit]);
- SCM(i, -1, string);
- mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE `MoneyDeposit`='%d' AND `name`='%s'", PlayerInfo[i][pMoneyDeposit], PlayerInfo[i][pNormalName]);
- mysql_tquery(SQL,string,"","");
- mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE `MatsDeposit`='%d' AND `name`='%s'", PlayerInfo[i][pMatsDeposit], PlayerInfo[i][pNormalName]);
- mysql_tquery(SQL,string,"","");
- mysql_format(SQL, string, sizeof(string), "SELECT * FROM users WHERE 'DrugsDeposit' ='%d' AND name = '%s'", PlayerInfo[i][pDrugsDeposit], PlayerInfo[i][pNormalName]);
- mysql_tquery(SQL,string,"","");
- }
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement