MySQL Whitelist

How to setup MySQL Whitelist ?

First, you have to set up connection info in config:

<small> whitelistStorage: 0
mysqlHost: 'localhost'
mysqlPort: 3306
mysqlUser: 'root'
mysqlPass: 'toor'
mysqlDatabase: 'minecraft'
mysqlTable: 'cIP'
</small>

Second, you must create a table in the database. Just use this SQL command to create table:

<small>CREATE TABLE IF NOT EXISTS `cIP` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(1) NOT NULL DEFAULT '0', `item` text COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;</small>

Third, how to add new record:

This record will whitelist IP: 93.153.31.151
<small>INSERT INTO `cIP` (`type`, `item`) VALUES (0, '93.153.31.151');</small>
This record will whitelist command /tell
<small>INSERT INTO `cIP` (`type`, `item`) VALUES (1, '/tell');</small>

If you will have got any questions or problems PM me or write to comment from main plugin page.