Alrighty my auth voting system isnt removing the persons ip after 24 hours so the person cant revote.
Here is the SQL structure
Code:
-- --------------------------------------------------------
--
-- Table structure for table `tempvotes`
--
CREATE TABLE IF NOT EXISTS `tempvotes` (
`id` int(5) NOT NULL,
`time` int(9) NOT NULL,
`ipaddress` varchar(15) collate utf8_unicode_ci NOT NULL,
`voted` int(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `votes`
--
CREATE TABLE IF NOT EXISTS `votes` (
`id` int(11) NOT NULL auto_increment,
`time` int(9) NOT NULL,
`ipaddress` varchar(15) collate utf8_unicode_ci NOT NULL,
`authcode` varchar(6) collate utf8_unicode_ci NOT NULL,
`used` int(1) NOT NULL default '0',
`username` varchar(14) collate utf8_unicode_ci NOT NULL,
`guid` varchar(45) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
If anything else needed i will post it