CREATE TABLE IF NOT EXISTS `admlink` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`linkurl` varchar(75) COLLATE latin1_general_ci NOT NULL,
`link_text` varchar(100) COLLATE latin1_general_ci NOT NULL,
`clicks` int(11) NOT NULL,
`last_ip` varchar(25) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `admlink`
--
INSERT INTO `admlink` (`id`, `linkurl`, `link_text`, `clicks`, `last_ip`) VALUES
(1, 'http://trickscafe.com', 'HackMasterz Forum', 1, '111.92.144.85');
-- --------------------------------------------------------
--
-- Table structure for table `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`id` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`agent` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `clicks`
--
CREATE TABLE IF NOT EXISTS `clicks` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(200) NOT NULL,
`compid` int(100) NOT NULL,
`ip` tinytext NOT NULL,
`ua` text NOT NULL,
`time` varchar(200) NOT NULL,
`tm` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `comp`
--
CREATE TABLE IF NOT EXISTS `comp` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`uid` int(50) NOT NULL,
`url` varchar(50) NOT NULL,
`type` int(1) NOT NULL,
`adult` int(1) NOT NULL DEFAULT '0',
`img` varchar(200) NOT NULL,
`cat` text NOT NULL,
`lang` tinytext NOT NULL,
`intr1` tinytext NOT NULL,
`intr2` tinytext NOT NULL,
`intr3` tinytext NOT NULL,
`intr4` tinytext NOT NULL,
`intr5` tinytext NOT NULL,
`st` int(1) NOT NULL DEFAULT '0',
`ckey` varchar(250) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `guest`
--
CREATE TABLE IF NOT EXISTS `guest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`url` varchar(60) NOT NULL,
`mail` varchar(50) NOT NULL,
`msg` text NOT NULL,
`ua` varchar(100) NOT NULL,
`ip` varchar(30) NOT NULL,
`dt` varchar(20) NOT NULL,
`otvet` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `imp`
--
CREATE TABLE IF NOT EXISTS `imp` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(200) NOT NULL,
`compid` int(100) NOT NULL,
`ip` tinytext NOT NULL,
`ua` text NOT NULL,
`time` varchar(200) NOT NULL,
`tm` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `imp`
--
INSERT INTO `imp` (`id`, `uid`, `compid`, `ip`, `ua`, `time`, `tm`) VALUES
(1, 1, 1, '111.92.142.103', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.3 (KHTML, like Gecko) Chrome/4.0.223.9 Safari/532.3', 'July 24 2011', '1311512573'),
(2, 1, 1, '82.145.209.88', 'Opera/9.80 (J2ME/MIDP; Opera Mini/6.1.25378/25.685; U; en) Presto/2.5.25 Version/10.54', 'July 24 2011', '1311518729'),
(3, 1, 1, '111.92.130.172', 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0', 'July 24 2011', '1311530024'),
(4, 1, 1, '64.255.164.59', 'Opera/9.80 (J2ME/MIDP; Opera Mini/4.3.24355/25.685; U; en) Presto/2.5.25 Version/10.54', 'July 24 2011', '1311532584'),
(5, 1, 1, '111.92.129.108', 'Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0', 'July 25 2011', '1311540534'),
(6, 1, 1, '111.92.129.101', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.3 (KHTML, like Gecko) Chrome/4.0.223.9 Safari/532.3', 'July 25 2011', '1311600200'),
(7, 2, 3, '111.92.131.185', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 20 2011', '1313789473'),
(8, 14, 4, '111.92.144.85', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 21 2011', '1313874156'),
(9, 12, 5, '', '', 'August 21 2011', '1313929917'),
(10, 14, 5, '111.92.145.169', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 21 2011', '1313931076'),
(11, 18, 6, '67.159.5.242', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 21 2011', '1313931748'),
(12, 14, 5, '111.92.143.189', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 21 2011', '1313933022'),
(13, 18, 6, '111.92.144.225', 'Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0', 'August 21 2011', '1313941376');
-- --------------------------------------------------------
--
-- Table structure for table `loginlog`
--
CREATE TABLE IF NOT EXISTS `loginlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ua` text NOT NULL,
`ip` text NOT NULL,
`time` int(11) NOT NULL,
`access_num` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_t` varchar(200) COLLATE latin1_general_ci NOT NULL,
`news` text COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;
--
-- Dumping data for table `news`
--
INSERT INTO `news` (`id`, `news_t`, `news`) VALUES
(1, 'Test News', 'This is test news you can edit it your admin panel');
-- --------------------------------------------------------
--
-- Table structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(23) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `ip` (`ip`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `online`
--
INSERT INTO `online` (`id`, `ip`, `time`) VALUES
(1, '', 1),
(4, '111.92.137.123', 1312919480);
-- --------------------------------------------------------
--
-- Table structure for table `ref`
--
CREATE TABLE IF NOT EXISTS `ref` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`refid` varchar(75) COLLATE latin1_general_ci NOT NULL,
`refuser` varchar(75) COLLATE latin1_general_ci NOT NULL,
`validated` int(11) NOT NULL,
`site` varchar(100) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `sys`
--
CREATE TABLE IF NOT EXISTS `sys` (
`url` varchar(50) CHARACTER SET utf8 NOT NULL,
`sitename` varchar(75) CHARACTER SET utf8 NOT NULL,
`siteslogan` varchar(100) CHARACTER SET utf8 NOT NULL,
`email` varchar(75) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `sys`
--
INSERT INTO `sys` (`url`, `sitename`, `siteslogan`, `email`) VALUES
('http://ad.mobhell.com', 'ad.mobhell.com', 'CyBeRLiNK Script', 'support@mobhell.com');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(50) NOT NULL,
`pass` varchar(50) NOT NULL,
`point` varchar(200) NOT NULL,
`bal` varchar(200) NOT NULL,
`mail` varchar(50) NOT NULL,
`paypal` varchar(50) NOT NULL,
`laston` varchar(50) NOT NULL,
`skey` varchar(250) NOT NULL,
`pay` int(1) NOT NULL,
`site` varchar(200) NOT NULL,
`lastip` varchar(50) CHARACTER SET utf8 NOT NULL,
`lastagent` varchar(200) CHARACTER SET utf8 NOT NULL,
`fraud` int(255) NOT NULL,
`proxy` int(255) NOT NULL,
`verified` int(11) NOT NULL,
`veri_code` int(11) NOT NULL,
`cam` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `skey` (`skey`),
UNIQUE KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;