Hello,
I've just completed one of my own solution to combat GM Corruption. As a server owner, i think one of the biggest headache is the gm corruption. Most of the corruptions are indirectly related to items, e.g. when a GM decides to give items to himself or his friends and then corrupt your economy and ruin all your hard work.
So, this is my solution. An NPC that helps your GM distribute items/KCP to him/her-self or to players (event prizes).
Script Features
- Complete Log Of All Item/KCP Distribution
- Easy To Configure
- Players Can View Their Own Collection Log
- Log Can Be Loaded From External Script (e.g. events_log.php) and show live transcript of every items given away in events
- Option To Notify/Announce, Check Weight before giving item, give item to a offline player and so on ...
TODO
- A config that let's you (admin) control how many times your gm can give item/kcp per hour
- Option to delete prize (whilst keeping the sql log)
- Check GM IP and against player's ip before giving out the item
- You guys suggest
Script Usage
Step 1) In your atcommand config, set all items related commands to 99 (admin only or 100 to completly disable it)
Step 2) Execute this query in your ragnarok database (you can use something like phpMyAdmin or wtv... you prefer)
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;
Step 3) Download the the NPC script from here : I have found a copy of the script since the link is broken. Here it is http://pastebin.com/QThjBmkh
Step 4) Edit the NPC script config and upload it to "npc/custom" folder on your server
Step 5) Edit the file "npc/scripts_custom.conf" and add this line :
npc: npc/custom/itemizer_v1.5.txt
Now restart your server and enjoy the GM corruption free server.
For additional security, you can always disable item trade for ALL gms except for Admin. This works quite nicely with the Itemizer.
Found a bug? Got a suggestion? Need help? Post here~