@reward request

[Heartbreak]

Please help me.. I've been having problems with corrupt gm's recently.. 
I want to add a command that does this things so i will be able to see in logs:

@reward1 Player name = Give item 7720 to a player and announce that he won an Event Coin.
@reward2 Player name = Give 50 berry ticket (ID 7307) to a player and announce that he won 50 berry tickets.. 

Please help me.. This is the only solution i find to avoid these corrupt GM's..

[sandbox]

I have uploaded a file.. Though it's still under approval, check it later!

 

http://rathena.org/board/files/file/3118-gm-reward-giver/

[Skorm]

I have uploaded a file.. Though it's still under approval, check it later!

 

http://rathena.org/board/files/file/3118-gm-reward-giver/

 

You should use .@ vars instead of @ vars which persist through execution. I've re-uploaded and approved the script.

[sandbox]

 

I have uploaded a file.. Though it's still under approval, check it later!

 

http://rathena.org/board/files/file/3118-gm-reward-giver/

 

You should use .@ vars instead of @ vars which persist through execution. I've re-uploaded and approved the script.

 

 

Thank you sir! Hope my other scripts gets approved as well. xD I admit they are kinda badly coded for they have been written years ago already..

[Heartbreak]

thanks a lot ! ermm.. but where should i put these ? 

CREATE TABLE evt_prize
(
rwd_time varchar(255),
player varchar(255),
item_id varchar(255),
amount varchar(255),
gm_name varchar(255)
);

will these work with @command like @reward ? 

thank you all for your fast replies  

[sandbox]

Put those codes on your RO SQL database..

 

No, unfortunately it's just an NPC.

[Heartbreak]

oki... thankies !  

[Missingno]

Here's a script-based atcommand version with SQL logging: http://rathena.org/board/files/file/3126-reward-command/

[ming089]

Here's a script-based atcommand version with SQL logging: http://rathena.org/board/files/file/3126-reward-command/

Sir santa poring where i put the script that u give??

[Missingno]

Sir santa poring where i put the script that u give??

My name isn't Santa Poring though...

 

Place the script in your npc (probably somewhere like npc/custom/) and then type @loadnpc npc/custom/reward.txt in-game. After you've run the SQL query in your logs schema, type @reward in-game to use the command (default syntax: @reward <preset> <player name>); there's no NPC to click, since the script is activated via @reward.

[ming089]

OK

 

 

Sir santa poring where i put the script that u give??

My name isn't Santa Poring though...

 

Place the script in your npc (probably somewhere like npc/custom/) and then type @loadnpc npc/custom/reward.txt in-game. After you've run the SQL query in your logs schema, type @reward in-game to use the command (default syntax: @reward <preset> <player name>); there's no NPC to click, since the script is activated via @reward.

 

OK thanks  

 

Sir santa poring.. i have enconuter error?

[Missingno]

What's your Git hash or revision number? Works on a fresh copy of rA, for me. o_o

[ming089]

ra> Revision 17702 and for ragexe 2013-08-07 do now the problem its say for line 59 to 69

[Missingno]

Sorry for the late reply; I've updated the script for some backwards compatibility, which fixes that error. Please download the newest version: http://rathena.org/board/files/file/3126-reward-command/