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.