Itemizer, Solution To Combat GM Corruption

[RCharles]

I am able to see that many members are requesting for some itemizer script, so maybe a repost of latheesan work from eAthena forum will be good..

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~

[Emistry]

any different from this ?

http://rathena.org/board/topic/60513-event-ticket-rewarder-php-log-viewer-anti-gm-corruption/page__hl__itemizer

both are the same...?

[WhatFT]

Can upload itemizer.sql?

I don't know how to setup tables in phpmyadmin. =/

[RCharles]

You mean that you don't know how to run this?

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;

just copy and paste it and run into your query in phpmyadmin database

[Blackzen]

i have problem in escape_sql every i make item for other or myself ..

[jpnazar]

how to disable KCP Menu?

[Erba]

both are the same