PCPIN Chat / IP filter not configured (fix)

gistfile1.txt

DROP TABLE IF EXISTS `pcpin_ipfilter`;
CREATE TABLE `pcpin_ipfilter` (
  `id` int(11) NOT NULL,
  `address` varchar(45) CHARACTER SET ascii NOT NULL DEFAULT '',
  `added_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `description` text NOT NULL,
  `action` enum('d','a') NOT NULL DEFAULT 'd',
  `type` varchar(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'IPv4'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;

INSERT INTO `pcpin_ipfilter` (`id`, `address`, `added_on`, `expires`, `description`, `action`, `type`) VALUES
(1, '*.*.*.*', '2017-06-04 22:40:10', '0000-00-00 00:00:00', 'This rule allows all IPv4 addresses', 'a', 'IPv4'),
(2, '*', '2017-06-04 22:40:10', '0000-00-00 00:00:00', 'This rule allows all IPv6 addresses', 'a', 'IPv6');

ALTER TABLE `pcpin_ipfilter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `address_2` (`address`,`action`),
  ADD KEY `address` (`address`),
  ADD KEY `added_on` (`added_on`),
  ADD KEY `expires` (`expires`),
  ADD KEY `action` (`action`),
  ADD KEY `type` (`type`);