Ajutor setare raport

[Andu Marian]

salut , as avea si eu nevoie de ajutor la setarea cmd:ticket cand un player da ticket sa se actualizeze pe panel in raport 

MD:ticket(playerid,params[])

{

if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");

    if(IsPlayerConnected(playerid))

    {

        if(OnDuty[playerid] != 1) return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}You are not on Duty.");

        new giveplayerid,moneys,result[50],giveplayer[25],sendername[25],string[128];

if(sscanf(params, "uis[50]",giveplayerid,moneys,result)) return SendClientMessage(playerid, COLOR_WHITE, "{FF9900}Scrie: {33CCFF}/ticket <Name/Playerid> <Amount of Money> <Reason>");

if(moneys < 1 || moneys > 99999) return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Ticket money can't be below 1 or higher then 99999.");

if(IsACop(giveplayerid)) return SendClientMessage(playerid, COLOR_WHITE, "{FFFFCC}Error: You can't give a ticket to a Cop!");

if(IsPlayerConnected(giveplayerid))

{

   if(giveplayerid != INVALID_PLAYER_ID)

   {

       if (ProxDetectorS(8.0, playerid, giveplayerid))

{

   if(PlayerInfo[playerid][pMember] == 1 || PlayerInfo[playerid][pMember] == 8)

   {

    GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer));

GetPlayerName(playerid, sendername, sizeof(sendername));

format(string, sizeof(string), "{B8FFDB}* You gave %s a Ticket costing $%s, reason: %s", giveplayer, FormatNumber(moneys), result);

SendClientMessage(playerid, COLOR_WHITE, string);

format(string, sizeof(string), "{B8FFDB}* Officer %s has given you a Ticket costing $%s, reason: %s, type /accept ticket %d to accept it", sendername, FormatNumber(moneys), result,playerid);

SendClientMessage(giveplayerid, COLOR_WHITE, string);

TicketOffer[giveplayerid] = playerid;

TicketMoney[giveplayerid] = moneys;

new str[256];

return 1;

}

else return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}You are not a LSPD/LVPD member.");

}

else return SendClientMessage(playerid, COLOR_WHITE,"{FFFFCC}This player is not near you.");

}

}

else return SendClientMessage(playerid, COLOR_WHITE, "{FFFFCC}Error: Player not connected.");

}

return 1;

}

[Zooky.]

Trebuie sa updatezi datele in baza de date, si de acolo se la afisezi in panel.

[Andu Marian]

am incercat sa fac asa , am adaugat la urm comanda :

 

new str[256];

       mysql_format(SQL,str,sizeof(str),"UPDATE users SET `Tickets`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pCommands],PlayerInfo[playerid][pNormalName]);

       mysql_tquery(SQL,str,"","");

 

e ok ?