A solution for GM corruption, and player doubt!
Prize Giving NPC
EventRewards.txt
GMs use this NPC to give rewards without using #item or trading! This should be used in combination with removing @item from your Event GMs commands, and disabling their ability to trade.
The NPC logs everything in a SQL table, which you will need to create.
The NPC broadcasts that a player has received a prize(GMs have no way to hide the broadcast)
This script was not made by me, but it was heavily edited so that it only gives an item that you specify in the the settings, and will work with the group_id system!
Warning: If you do not use the group_id system you'll need to replace all instances of getgroupid() with getgmlevel()
SQL Log Web Viewer (PHP)
index.php
You can find an example of it
here.
It can be intergrated into a Flux page if you wish, but I chose not to.
Installation!
1)First execute this SQL query via phpmyadmin, or your preferred mysql query browser.
CREATE TABLE IF NOT EXISTS `itemizer` ( `id` int(11) unsigned NOT NULL auto_increment, `item_id` int(11) NOT NULL, `item_amount` int(11) NOT NULL, `item_name` varchar(255) NOT NULL, `char_id` int(11) NOT NULL, `char_name` varchar(255) NOT NULL, `reason` varchar(255) NOT NULL, `by_gm` varchar(255) NOT NULL, `when` datetime NOT NULL, `for` varchar(255) NOT NULL, `collected` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM ;
2) Place EventRewards.txt in your NPC/Custom Folder, and add it to scripts_custom.conf as so
npc: npc/custom/EventRewards.txt
3) (Optional Web Viewer) Open up Index.php and find this line.
mysql_connect("127.0.0.1", "User", "Password") or die (mysql_error ());
and
mysql_select_db("rathena_rag") or die(mysql_error());
Change 127.0.0.1 to your SQL database's IP, User to your SQL username, Password to your SQL password, and lastly rathena_rag to the name of your Ragnarok Database.
4) Create a new directory inside public_html called "rewards" or whatever you like, and place index.php in there!
5) I am not sure if it is safe to @loadnpc this script, so for safety reasons, I would suggest restarting the rAthena emulator.
6) Now give it a test, and if completed correctly you should have http://yourROsite.com/rewards/ looking like this.
~Credits~
*******Latheesan ( He created the original NPC called "Itemizer" )*******
Pancake ( Created the web viewer, and modified the script to work with group_id )
Coming soon:
The ability for GMs to whisper this NPC, so that they can reward players from any map!