-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 22, 2013 at 10:09 AM
-- Server version: 5.5.30-30.2
-- PHP Version: 5.3.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `latenytz_latenytzdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `admintools`
--
CREATE TABLE IF NOT EXISTS `admintools` (
`uid` int(100) NOT NULL DEFAULT '0',
`tools` char(1) NOT NULL DEFAULT '0',
`boot` char(1) NOT NULL DEFAULT '0',
`ban` char(1) NOT NULL DEFAULT '0',
`unban` char(1) NOT NULL DEFAULT '0',
`ipban` char(1) NOT NULL DEFAULT '0',
`del` char(1) NOT NULL DEFAULT '0',
`validate` char(1) NOT NULL DEFAULT '0',
`delshout` char(1) NOT NULL DEFAULT '0',
`userinfo` char(1) NOT NULL DEFAULT '0',
`settings` char(1) NOT NULL DEFAULT '0',
`ghosts` char(1) NOT NULL DEFAULT '0',
`chat_tools` char(1) NOT NULL DEFAULT '0',
`forum_tools` char(1) NOT NULL DEFAULT '0',
`club_tools` char(1) NOT NULL DEFAULT '0',
`quiz_tools` char(1) NOT NULL DEFAULT '0',
`gallery_tools` char(1) NOT NULL DEFAULT '0',
`game_tools` char(1) NOT NULL DEFAULT '0',
`download_tools` char(1) NOT NULL DEFAULT '0',
`link_tools` char(1) NOT NULL DEFAULT '0',
`editusers` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admintools`
--
INSERT INTO `admintools` (`uid`, `tools`, `boot`, `ban`, `unban`, `ipban`, `del`, `validate`, `delshout`, `userinfo`, `settings`, `ghosts`, `chat_tools`, `forum_tools`, `club_tools`, `quiz_tools`, `gallery_tools`, `game_tools`, `download_tools`, `link_tools`, `editusers`) VALUES
(1, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
-- --------------------------------------------------------
--
-- Table structure for table `announcements`
--
CREATE TABLE IF NOT EXISTS `announcements` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`text` varchar(200) NOT NULL DEFAULT '',
`clubid` int(100) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `banned`
--
CREATE TABLE IF NOT EXISTS `banned` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`penalty` char(1) NOT NULL DEFAULT '0',
`byid` int(100) NOT NULL DEFAULT '0',
`remaining` int(100) NOT NULL DEFAULT '0',
`reason` varchar(100) NOT NULL DEFAULT '',
`ipaddress` varchar(30) NOT NULL DEFAULT '',
`browser` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `blocked`
--
CREATE TABLE IF NOT EXISTS `blocked` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site` varchar(255) NOT NULL DEFAULT 'NULL',
`autoreport` char(1) NOT NULL DEFAULT '0',
`ipaddress` varchar(15) NOT NULL DEFAULT 'NULL',
`browser` varchar(255) NOT NULL DEFAULT 'NULL',
`network` varchar(255) NOT NULL DEFAULT 'NULL',
`reason` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `blocked`
--
INSERT INTO `blocked` (`id`, `site`, `autoreport`, `ipaddress`, `browser`, `network`, `reason`) VALUES
(1, 'NULL', '0', 'NULL', 'Anonymouse.org', 'NULL', 'Forbidden Proxy'),
(2, 'checkout', '1', 'NULL', 'NULL', 'NULL', ''),
(3, 'visit', '1', 'NULL', 'NULL', 'NULL', ''),
(4, 'http:', '1', 'NULL', 'NULL', 'NULL', ''),
(5, 'www.', '1', 'NULL', 'NULL', 'NULL', ''),
(6, '.com', '1', 'NULL', 'NULL', 'NULL', ''),
(7, '.net', '1', 'NULL', 'NULL', 'NULL', ''),
(8, '.org', '1', 'NULL', 'NULL', 'NULL', ''),
(9, '.info', '1', 'NULL', 'NULL', 'NULL', ''),
(10, '.biz', '1', 'NULL', 'NULL', 'NULL', ''),
(11, '.mobi', '1', 'NULL', 'NULL', 'NULL', ''),
(12, '.ro', '1', 'NULL', 'NULL', 'NULL', ''),
(13, '.co.uk', '1', 'NULL', 'NULL', 'NULL', ''),
(14, '.me.uk', '1', 'NULL', 'NULL', 'NULL', ''),
(15, '.uk.to', '1', 'NULL', 'NULL', 'NULL', ''),
(16, '.co.za', '1', 'NULL', 'NULL', 'NULL', ''),
(17, '.web.tr', '1', 'NULL', 'NULL', 'NULL', ''),
(18, '.wen.ru', '1', 'NULL', 'NULL', 'NULL', '');
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE IF NOT EXISTS `blogs` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`date` int(20) NOT NULL DEFAULT '0',
`uid` int(10) NOT NULL DEFAULT '0',
`subject` varchar(50) NOT NULL DEFAULT '',
`body` varchar(255) NOT NULL DEFAULT '',
`reported` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `blog_comments`
--
CREATE TABLE IF NOT EXISTS `blog_comments` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`blogid` int(10) NOT NULL DEFAULT '0',
`uid` int(10) NOT NULL DEFAULT '0',
`comment` varchar(255) NOT NULL DEFAULT '',
`date` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `buds`
--
CREATE TABLE IF NOT EXISTS `buds` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`tid` int(100) NOT NULL DEFAULT '0',
`agreed` char(1) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id` int(99) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`toid` int(100) NOT NULL DEFAULT '0',
`timesent` int(50) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`rid` int(99) NOT NULL DEFAULT '0',
`exposed` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `chatonline`
--
CREATE TABLE IF NOT EXISTS `chatonline` (
`lton` int(15) NOT NULL DEFAULT '0',
`uid` int(100) NOT NULL DEFAULT '0',
`rid` int(99) NOT NULL DEFAULT '0',
PRIMARY KEY (`lton`),
UNIQUE KEY `username` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `chatrooms`
--
CREATE TABLE IF NOT EXISTS `chatrooms` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`public` char(1) NOT NULL DEFAULT '0',
`censored` char(1) NOT NULL DEFAULT '1',
`freaky` char(1) NOT NULL DEFAULT '0',
`lastmsg` int(100) NOT NULL DEFAULT '0',
`clubid` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `chatrooms`
--
INSERT INTO `chatrooms` (`id`, `name`, `password`, `public`, `censored`, `freaky`, `lastmsg`, `clubid`) VALUES
(1, 'Admin', '', '0', '1', '0', 1197112158, 1),
(2, 'General', '', '1', '1', '0', 1203493431, 0),
(3, 'Adults 18+', '', '1', '0', '0', 1203508898, 0),
(4, 'Gay n Lez', '', '1', '1', '0', 1202543992, 0),
(5, 'International', '', '1', '1', '0', 1203350696, 0),
(6, 'Garbage', '', '1', '1', '0', 1202939826, 0),
(7, 'Whats Hot', '', '1', '0', '0', 1203338295, 0);
-- --------------------------------------------------------
--
-- Table structure for table `clubmembers`
--
CREATE TABLE IF NOT EXISTS `clubmembers` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`clubid` int(100) NOT NULL DEFAULT '0',
`accepted` char(1) NOT NULL DEFAULT '0',
`points` int(100) NOT NULL DEFAULT '0',
`joined` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `clubmembers`
--
INSERT INTO `clubmembers` (`id`, `uid`, `clubid`, `accepted`, `points`, `joined`) VALUES
(1, 1, 1, '1', 0, 1186818708);
-- --------------------------------------------------------
--
-- Table structure for table `clubs`
--
CREATE TABLE IF NOT EXISTS `clubs` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`owner` int(100) NOT NULL DEFAULT '0',
`name` varchar(30) NOT NULL DEFAULT '',
`description` varchar(200) NOT NULL DEFAULT '',
`rules` text NOT NULL,
`logo` varchar(200) NOT NULL DEFAULT '',
`points` int(100) NOT NULL DEFAULT '0',
`created` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `clubs`
--
INSERT INTO `clubs` (`id`, `owner`, `name`, `description`, `rules`, `logo`, `points`, `created`) VALUES
(1, 1, 'Admin', 'Admin Club', 'For admins only!!!', '../images/admin.gif', 139, 1186818708);
-- --------------------------------------------------------
--
-- Table structure for table `dating`
--
CREATE TABLE IF NOT EXISTS `dating` (
`id` mediumint(4) NOT NULL AUTO_INCREMENT,
`uid` varchar(20) NOT NULL DEFAULT '',
`cat` char(3) NOT NULL DEFAULT '',
`aboutme` text NOT NULL,
`lookingfor` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `download_categories`
--
CREATE TABLE IF NOT EXISTS `download_categories` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`active` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `download_categories`
--
INSERT INTO `download_categories` (`id`, `name`, `description`, `active`) VALUES
(1, 'Music', 'mp3 Tones, Real Tones, Mono Tones Etc...', '1'),
(2, 'Pics', 'Wallpapers, Pictures, Animations and Screen Savers.', '1'),
(3, 'Applications/Games', 'Java Apps, S30, S40, S60 Apps Etc...', '1'),
(4, 'Movies', '3gp, Mp4 And Other Video Files', '1');
-- --------------------------------------------------------
--
-- Table structure for table `download_files`
--
CREATE TABLE IF NOT EXISTS `download_files` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL DEFAULT '0',
`filename` varchar(255) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '0',
`description` varchar(255) NOT NULL DEFAULT '',
`category` char(1) NOT NULL DEFAULT '0',
`hits` int(10) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
`active` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `filter`
--
CREATE TABLE IF NOT EXISTS `filter` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`word` varchar(25) NOT NULL DEFAULT '',
`replace` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `filter`
--
INSERT INTO `filter` (`id`, `word`, `replace`) VALUES
(1, 'fuck', 'f**k');
-- --------------------------------------------------------
--
-- Table structure for table `forumcats`
--
CREATE TABLE IF NOT EXISTS `forumcats` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`position` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `forumcats`
--
INSERT INTO `forumcats` (`id`, `name`, `position`) VALUES
(1, 'General', 1),
(2, 'Entertainment', 2),
(3, 'Technology', 3),
(4, 'Just 4 Fun', 4),
(5, 'Others+Info', 5);
-- --------------------------------------------------------
--
-- Table structure for table `forumposts`
--
CREATE TABLE IF NOT EXISTS `forumposts` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`thread` int(100) NOT NULL DEFAULT '0',
`uid` int(100) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
`quote` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL DEFAULT '',
`position` int(50) NOT NULL DEFAULT '0',
`catid` int(100) NOT NULL DEFAULT '0',
`clubid` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `forums`
--
INSERT INTO `forums` (`id`, `name`, `position`, `catid`, `clubid`) VALUES
(1, 'Admin', 0, 0, 1),
(2, 'General', 1, 1, 0),
(3, 'Adults 18+', 2, 1, 0),
(4, 'Newbies', 3, 1, 0),
(5, 'Gay n Lez', 4, 1, 0),
(6, 'international', 5, 1, 0),
(7, 'Music', 1, 2, 0),
(8, 'Movies', 2, 2, 0),
(9, 'Whats Hot', 3, 2, 0),
(10, 'Poems n Such', 4, 2, 0),
(11, 'pc', 1, 3, 0),
(12, 'Mobiles', 2, 3, 0),
(13, 'Web n Wap', 3, 3, 0),
(14, 'Joke Box', 1, 4, 0),
(15, 'Suggestions', 1, 5, 0),
(16, 'Download Requests', 2, 5, 0),
(17, 'Problems', 3, 5, 0),
(18, 'Garbage', 4, 5, 0),
(19, 'Site Info', 5, 5, 0);
-- --------------------------------------------------------
--
-- Table structure for table `forumtopics`
--
CREATE TABLE IF NOT EXISTS `forumtopics` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`fid` int(100) NOT NULL DEFAULT '0',
`uid` int(100) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`pinned` char(1) NOT NULL DEFAULT '0',
`closed` char(1) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
`views` int(100) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
`lastpost` int(100) NOT NULL DEFAULT '0',
`moved` char(1) NOT NULL DEFAULT '0',
`poll` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `forumtopics`
--
INSERT INTO `forumtopics` (`id`, `name`, `fid`, `uid`, `text`, `pinned`, `closed`, `date`, `views`, `reported`, `lastpost`, `moved`, `poll`) VALUES
(1, 'Hello, Im New', 4, 2, 'Hello :)', '0', '0', 1371745180, 2, '0', 1371745180, '0', 0);
-- --------------------------------------------------------
--
-- Table structure for table `gallery_categories`
--
CREATE TABLE IF NOT EXISTS `gallery_categories` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`active` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `gallery_categories`
--
INSERT INTO `gallery_categories` (`id`, `name`, `active`) VALUES
(1, 'Male', '1'),
(2, 'Female', '1'),
(3, 'Adult', '1');
-- --------------------------------------------------------
--
-- Table structure for table `gallery_files`
--
CREATE TABLE IF NOT EXISTS `gallery_files` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL DEFAULT '0',
`filename` varchar(50) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '0',
`category` char(1) NOT NULL DEFAULT '0',
`hits` int(10) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `games`
--
CREATE TABLE IF NOT EXISTS `games` (
`uid` int(100) NOT NULL DEFAULT '0',
`category` varchar(50) NOT NULL DEFAULT '',
`word1` varchar(50) NOT NULL DEFAULT '',
`word2` varchar(50) NOT NULL DEFAULT '',
`word3` varchar(50) NOT NULL DEFAULT '',
`word4` varchar(50) NOT NULL DEFAULT '',
`word5` varchar(50) NOT NULL DEFAULT '',
`word6` varchar(50) NOT NULL DEFAULT '',
`word7` varchar(50) NOT NULL DEFAULT '',
`word8` varchar(50) NOT NULL DEFAULT '',
`word9` varchar(50) NOT NULL DEFAULT '',
`word10` varchar(50) NOT NULL DEFAULT '',
`word11` varchar(50) NOT NULL DEFAULT '',
`word12` varchar(50) NOT NULL DEFAULT '',
`word13` varchar(50) NOT NULL DEFAULT '',
`word14` varchar(50) NOT NULL DEFAULT '',
`word15` varchar(50) NOT NULL DEFAULT '',
`word16` varchar(50) NOT NULL DEFAULT '',
`word17` varchar(50) NOT NULL DEFAULT '',
`word18` varchar(50) NOT NULL DEFAULT '',
`word19` varchar(50) NOT NULL DEFAULT '',
`word20` varchar(50) NOT NULL DEFAULT '',
`active` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `games`
--
INSERT INTO `games` (`uid`, `category`, `word1`, `word2`, `word3`, `word4`, `word5`, `word6`, `word7`, `word8`, `word9`, `word10`, `word11`, `word12`, `word13`, `word14`, `word15`, `word16`, `word17`, `word18`, `word19`, `word20`, `active`) VALUES
(0, 'wordscramble', 'dictionary', 'recognize', 'example', 'entertainment', 'experiment', 'appreciation', 'information', 'pronunciation', 'language', 'government', 'psychic', 'blueberry', 'selection', 'automatic', 'strawberry', 'bakery', 'shopping', 'eggplant', 'chicken', 'organic', '1'),
(0, 'Colors', 'black', 'blue', 'brown', 'cyan', 'gold', 'green', 'grey', 'lavender', 'maroon', 'olive', 'orange', 'pink', 'purple', 'red', 'scarlet', 'teal', 'turquoise', 'violet', 'white', 'yellow', '1'),
(0, 'Food', 'Sausages', 'Hamburger', 'Carrot', 'Cheese', 'Strawberry', 'Apple', 'Lettuce', 'Tomatoes', 'Chocolate', 'Cereal', 'Onions', 'Coconut', 'Gooseberry', 'Marmite', 'Spaghetti', 'Mango', 'Pasties', 'Cucumber', 'Tomatoes', 'Steak', '1'),
(0, 'Pc', 'Central Processing Unit', 'Motherboard', 'Radeon', 'Sound blaster', 'nvidia', 'Hard disk drive', 'Bios', 'Cmos', 'Power supply', 'Sata', 'Raid', 'Serial', 'Universal serial bus', 'Infra red', 'Accelerated graphics port', 'North bridge', 'South bridge', 'Logitech', 'Microsoft', 'Windows', '1'),
(0, 'Films', 'Free willy', 'Rocky', 'Star wars', 'Stargate', 'Home alone', 'Eragon', 'Garfield', 'Holiday', 'Green mile', 'Longest yard', 'Click', 'Wedding singer', 'XXX', 'Simpson the movie', 'I.T', 'Lord of the rings', 'Land before time', 'St. Trinians', 'Flushed away', 'Shrek', '1'),
(4, 'hangman', '0', 'yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0');
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`minage` int(10) NOT NULL DEFAULT '0',
`maxage` int(10) NOT NULL DEFAULT '0',
`level` char(1) NOT NULL DEFAULT '0',
`points` int(100) NOT NULL DEFAULT '0',
`fid` int(10) NOT NULL DEFAULT '0',
`rid` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`id`, `name`, `minage`, `maxage`, `level`, `points`, `fid`, `rid`) VALUES
(1, 'admin', 0, 0, '1', 0, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `guestbook`
--
CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`message` varchar(255) NOT NULL DEFAULT '',
`date` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `guestbook`
--
INSERT INTO `guestbook` (`id`, `uid`, `name`, `message`, `date`) VALUES
(1, 3, 'Shane (SCROOGE)', 'My lovely site :)', 1371745490);
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_chapel`
--
CREATE TABLE IF NOT EXISTS `ibwf_chapel` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`ismd` char(1) NOT NULL DEFAULT '0',
`uid` int(100) NOT NULL DEFAULT '0',
`mid` int(100) NOT NULL DEFAULT '0',
`rpen` char(1) NOT NULL DEFAULT '0',
`mdy` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=186 ;
-- --------------------------------------------------------
--
-- Table structure for table `ignored`
--
CREATE TABLE IF NOT EXISTS `ignored` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(99) NOT NULL DEFAULT '0',
`tid` int(99) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `inbox`
--
CREATE TABLE IF NOT EXISTS `inbox` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`byid` int(100) NOT NULL DEFAULT '0',
`toid` int(100) NOT NULL DEFAULT '0',
`fwd` int(100) NOT NULL DEFAULT '0',
`unread` char(1) NOT NULL DEFAULT '1',
`timesent` int(100) NOT NULL DEFAULT '0',
`archive` char(1) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
--
-- Dumping data for table `inbox`
--
INSERT INTO `inbox` (`id`, `text`, `byid`, `toid`, `fwd`, `unread`, `timesent`, `archive`, `reported`) VALUES
(4, 'Your guestbook has been signed by SCROOGE[br/][small][i]p.s: this is an automated pm[/i][/small]', 1, 3, 0, '1', 1371745490, '0', '0'),
(40, 'Whats ur link lol', 1, 5, 0, '0', 1371913441, '0', '0'),
(42, 'Brill tanx', 1, 5, 0, '0', 1371913526, '0', '0'),
(45, 'I did but u deleted me so i thought id change my name. links added and points bar removed', 1, 5, 0, '0', 1371913619, '0', '0'),
(38, 'Lmao. shes a host aint she?', 1, 5, 0, '0', 1371913400, '0', '0'),
(35, 'Yupp i know', 1, 5, 0, '0', 1371913313, '0', '0'),
(28, 'Lmao.. autoban is a bitch', 1, 5, 0, '0', 1371912868, '0', '0'),
(48, 'erm wheres links gone pmsl', 5, 1, 0, '1', 1371913765, '0', '0'),
(30, 'Oh i know that. My browser played up pmpl', 1, 5, 0, '0', 1371913241, '0', '0'),
(47, 'lol srry bout that lol', 1, 5, 0, '0', 1371913727, '0', '0'),
(33, 'Im removing the points from the links lol. its annoying. will u run this site for me if i make u owner? Iv seen ya on 2 other sites and ya good at running sites', 1, 5, 0, '0', 1371913296, '0', '0'),
(46, 'u were deleted cos no email lol only staff ses anyway n thanc', 5, 1, 0, '0', 1371913687, '0', '0'),
(26, 'Hello /reader =). Greetings from all LateNytz staff, we are happy to have you here, welcome to our big happy family!, Just follow the simple rules pls, Respect members and owners, Dont put your site addy in ur profiles or tell members ur sites name (that goes for site owners and admins) Make your mark in forums. Use chatrooms its fun! If u have problem putting your pic in your profile inbox an owner plz, put your correct birthdate in your profile so we can celebrate with u all, Enjoy ur stay with us, u can gain points by using forums and chat wich will unlock other site parts [small][i][br/]p.s: this is an automated pm[/i][/small]', 1, 5, 0, '0', 1371912590, '0', '0');
-- --------------------------------------------------------
--
-- Table structure for table `inbox2`
--
CREATE TABLE IF NOT EXISTS `inbox2` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`byid` int(100) NOT NULL DEFAULT '0',
`toid` int(100) NOT NULL DEFAULT '0',
`fwd` int(100) NOT NULL DEFAULT '0',
`unread` char(1) NOT NULL DEFAULT '1',
`timesent` int(100) NOT NULL DEFAULT '0',
`archive` char(1) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `ips`
--
CREATE TABLE IF NOT EXISTS `ips` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`ip` varchar(50) NOT NULL DEFAULT '',
`host` varchar(200) NOT NULL DEFAULT '',
`browser` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
--
-- Dumping data for table `ips`
--
INSERT INTO `ips` (`id`, `ip`, `host`, `browser`) VALUES
(1, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(2, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(3, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(4, '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla(5.0)'),
(5, '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla(5.0)'),
(6, '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla(5.0)'),
(7, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(8, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(9, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(10, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(11, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(12, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(13, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(14, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(15, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(16, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(17, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(18, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(19, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(20, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(21, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(22, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(23, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(24, '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla(5.0)'),
(25, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(26, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(27, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(28, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(29, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(30, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(31, '199.19.249.196', '199.19.249.196', 'Internet Explorer(7.0)'),
(32, '199.19.249.196', '199.19.249.196', 'Internet Explorer(7.0)'),
(33, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(34, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(35, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(36, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(37, '199.19.249.196', '199.19.249.196', 'Internet Explorer(7.0)'),
(38, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(39, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(40, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(41, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(42, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(43, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(44, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(45, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(46, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(47, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(48, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(49, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(50, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(51, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(52, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(53, '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera(9.80)'),
(54, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)'),
(55, '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla(5.0)');
-- --------------------------------------------------------
--
-- Table structure for table `links`
--
CREATE TABLE IF NOT EXISTS `links` (
`url` varchar(255) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `links`
--
INSERT INTO `links` (`url`, `title`) VALUES
('http://seductivenitez.co.uk/', 'SeductiveNitez'),
('http://chattybar.tk', 'ChattyBar');
-- --------------------------------------------------------
--
-- Table structure for table `logins`
--
CREATE TABLE IF NOT EXISTS `logins` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL DEFAULT '0',
`username` varchar(50) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL DEFAULT '',
`ip` varchar(50) NOT NULL DEFAULT '',
`host` varchar(200) NOT NULL DEFAULT '',
`browser` varchar(200) NOT NULL DEFAULT '',
`date` varchar(50) NOT NULL DEFAULT '',
`action` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;
--
-- Dumping data for table `logins`
--
INSERT INTO `logins` (`id`, `uid`, `username`, `password`, `ip`, `host`, `browser`, `date`, `action`) VALUES
(5, 2, 'woody', 'csiny22', '82.2.44.108', 'cpc1-leds9-0-0-cust107.leed.cable.ntl.com', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.4) Gecko/20091016 Firefox/3.5.4 (.NET CLR 3.5.30729)', '5:37pm - Tuesday 3rd November 2009', 'login'),
(10, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:11pm - Sunday 16th June 2013', 'login'),
(11, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:20pm - Sunday 16th June 2013', 'login'),
(12, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:30pm - Sunday 16th June 2013', 'login'),
(13, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:35pm - Sunday 16th June 2013', 'login'),
(14, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:37pm - Sunday 16th June 2013', 'login'),
(15, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:41pm - Sunday 16th June 2013', 'login'),
(16, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:45pm - Sunday 16th June 2013', 'login'),
(17, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '1:57pm - Sunday 16th June 2013', 'login'),
(18, 3, 'crazygaz1', 'lmao', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '2:13pm - Sunday 16th June 2013', 'login'),
(19, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '3:44pm - Sunday 16th June 2013', 'login'),
(20, 1, 'gazza', 'skyhd', '199.19.249.196', '199.19.249.196', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)', '3:44pm - Sunday 16th June 2013', 'login'),
(21, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:23pm - Sunday 16th June 2013', 'login'),
(22, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:28pm - Sunday 16th June 2013', 'login'),
(23, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:30pm - Sunday 16th June 2013', 'login'),
(24, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:30pm - Sunday 16th June 2013', 'login'),
(25, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:31pm - Sunday 16th June 2013', 'login'),
(26, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:33pm - Sunday 16th June 2013', 'login'),
(27, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:33pm - Sunday 16th June 2013', 'login'),
(28, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:34pm - Sunday 16th June 2013', 'login'),
(29, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:34pm - Sunday 16th June 2013', 'login'),
(30, 1, 'gazza', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '9:37pm - Sunday 16th June 2013', 'login'),
(34, 1, 'gazza', 'skyhd', '212.129.66.98', '212.129.66.98', 'Mozilla/5.0 (Linux; U; Android 2.3.6; en-gb; SAMSUNG GT-S5839i/S5839iBULL1 Build/GINGERBREAD) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1', '1:16pm - Monday 17th June 2013', 'login'),
(35, 1, 'gazza', 'skyhd', '92.251.255.13', '92.251.255.13.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '6:09pm - Monday 17th June 2013', 'login'),
(36, 3, 'crazygaz1', 'lmao', '92.251.255.13', '92.251.255.13.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '6:36pm - Monday 17th June 2013', 'login'),
(37, 1, 'gazza', 'skyhd', '92.251.255.13', '92.251.255.13.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '9:13pm - Monday 17th June 2013', 'login'),
(39, 1, 'gazza', 'skyhd', '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '2:02pm - Tuesday 18th June 2013', 'login'),
(40, 1, 'gazza', 'skyhd', '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '3:16pm - Tuesday 18th June 2013', 'login'),
(41, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:34pm - Tuesday 18th June 2013', 'login'),
(42, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:34pm - Tuesday 18th June 2013', 'login'),
(43, 1, 'gazza', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '8:34pm - Tuesday 18th June 2013', 'login'),
(44, 1, 'scrooge', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '9:37pm - Tuesday 18th June 2013', 'login'),
(70, 5, 'wapangel', 'ringdown', '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera/9.80 (Android 2.3.6; Linux; Opera Mobi/ADR-1301071820) Presto/2.11.355 Version/12.10', '3:58pm - Saturday 22nd June 2013', 'login'),
(46, 1, 'scrooge', 'skyhd', '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '4:36pm - Wednesday 19th June 2013', 'login'),
(47, 1, 'scrooge', 'skyhd', '199.19.249.196', '199.19.249.196', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; MS-RTC LM 8; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)', '4:36pm - Wednesday 19th June 2013', 'login'),
(48, 1, 'scrooge', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36', '5:48pm - Wednesday 19th June 2013', 'login'),
(49, 1, 'scrooge', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '6:17pm - Wednesday 19th June 2013', 'login'),
(50, 1, 'scrooge', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '5:13pm - Thursday 20th June 2013', 'login'),
(51, 2, 'kinkykitten', 'lolx', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '5:18pm - Thursday 20th June 2013', 'login'),
(52, 3, 'guestbook', 'gb123abc', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '5:21pm - Thursday 20th June 2013', 'login'),
(53, 1, 'SCROOGE', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '5:24pm - Thursday 20th June 2013', 'login'),
(54, 1, 'scrooge', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '8:03pm - Thursday 20th June 2013', 'login'),
(55, 1, 'scrooge', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (compatible; MSIE 10.0; Windows Phone 8.0; Trident/6.0; IEMobile/10.0; ARM; Touch; NOKIA; Lumia 520; Vodafone)', '9:50pm - Thursday 20th June 2013', 'login'),
(56, 1, 'scrooge', 'skyhd', '92.251.255.14', '92.251.255.14.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '7:13am - Friday 21st June 2013', 'login'),
(69, 5, 'wapangel', 'ringdown', '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', 'Opera/9.80 (Android 2.3.6; Linux; Opera Mobi/ADR-1301071820) Presto/2.11.355 Version/12.10', '3:50pm - Saturday 22nd June 2013', 'login'),
(68, 1, 'SCROOGE', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '3:43pm - Saturday 22nd June 2013', 'login'),
(59, 1, 'SCROOGE', 'skyhd', '92.251.255.12', '92.251.255.12.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '8:57am - Saturday 22nd June 2013', 'login'),
(67, 1, 'SCROOGE', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '3:32pm - Saturday 22nd June 2013', 'login'),
(66, 4, 'mzfilthy', 'england', '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '2:54pm - Saturday 22nd June 2013', 'login'),
(65, 1, 'SCROOGE', 'skyhd', '92.251.255.11', '92.251.255.11.threembb.ie', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '2:00pm - Saturday 22nd June 2013', 'login'),
(64, 4, 'mzfilthy', 'england', '90.204.15.11', '5acc0f0b.bb.sky.com', 'Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36', '1:58pm - Saturday 22nd June 2013', 'login');
-- --------------------------------------------------------
--
-- Table structure for table `logs`
--
CREATE TABLE IF NOT EXISTS `logs` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`action` varchar(20) NOT NULL DEFAULT '',
`details` text NOT NULL,
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `logs`
--
INSERT INTO `logs` (`id`, `action`, `details`, `date`) VALUES
(1, 'edited', '<b>MRMENTAL</b> edited MRMENTAL', 1371912249);
-- --------------------------------------------------------
--
-- Table structure for table `modtools`
--
CREATE TABLE IF NOT EXISTS `modtools` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`fid` int(100) NOT NULL DEFAULT '0',
`rid` int(100) NOT NULL DEFAULT '0',
`clubid` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `modtools`
--
INSERT INTO `modtools` (`id`, `uid`, `fid`, `rid`, `clubid`) VALUES
(1, 1, 3, 3, 0),
(2, 1, 16, 0, 0),
(3, 1, 18, 0, 0),
(4, 1, 5, 5, 0),
(5, 1, 2, 2, 0),
(6, 1, 6, 6, 0),
(7, 1, 14, 0, 0),
(8, 1, 12, 0, 0),
(9, 1, 8, 0, 0),
(10, 1, 7, 7, 0),
(11, 1, 4, 4, 0),
(12, 1, 11, 0, 0),
(13, 1, 10, 0, 0),
(14, 1, 17, 0, 0),
(15, 1, 19, 0, 0),
(16, 1, 15, 0, 0),
(17, 1, 13, 0, 0),
(18, 1, 9, 0, 0),
(19, 1, 1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `mpot`
--
CREATE TABLE IF NOT EXISTS `mpot` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ddt` varchar(50) NOT NULL DEFAULT '',
`dtm` varchar(20) NOT NULL DEFAULT '',
`ppl` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `mpot`
--
INSERT INTO `mpot` (`id`, `ddt`, `dtm`, `ppl`) VALUES
(1, 'Tuesday 6th October', '11:03pm', 3),
(2, 'Tuesday 3rd November', '5:41pm', 2),
(3, 'Sunday 16th June', '10:35pm', 2),
(4, 'Monday 17th June', '11:12pm', 2),
(5, 'Tuesday 18th June', '8:57pm', 2),
(6, 'Wednesday 19th June', '7:00pm', 2),
(7, 'Wednesday 19th June', '7:00pm', 2),
(8, 'Thursday 20th June', '5:37pm', 3),
(9, 'Friday 21st June', '11:29pm', 1),
(10, 'Saturday 22nd June', '4:09pm', 2);
-- --------------------------------------------------------
--
-- Table structure for table `network`
--
CREATE TABLE IF NOT EXISTS `network` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`subone` text NOT NULL,
`subtwo` text NOT NULL,
`isp` text NOT NULL,
`country` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=192 ;
--
-- Dumping data for table `network`
--
INSERT INTO `network` (`id`, `subone`, `subtwo`, `isp`, `country`) VALUES
(1, '85.195.119.14', '85.195.119.15', 'Anonymouse.org', 'Proxy'),
(2, '66.249.64.0', '66.249.95.255', 'Google Inc', 'Proxy'),
(3, '72.14.192.0', '72.14.255.255', 'Google Inc', 'Proxy'),
(4, '216.239.32.0', '216.239.63.255', 'Google Inc', 'Proxy'),
(5, '209.85.128.0', '209.85.255.255', 'Google Inc', 'Proxy'),
(6, '193.189.90.0', '193.189.91.255', 'Musiwave', 'Proxy'),
(7, '80.232.117.0', '80.232.117.255', 'Opera Software', 'Proxy'),
(8, '195.189.142.0', '195.189.143.255', 'Opera Software', 'Proxy'),
(9, '210.193.250.128', '210.193.250.159', 'Australian Water Services P/L', 'Australia'),
(10, '203.220.0.0', '203.220.255.255', 'Comindico', 'Australia'),
(11, '202.168.0.0', '202.168.63.255', 'Comindico', 'Australia'),
(12, '203.194.0.0', '203.194.63.255', 'Comindico', 'Australia'),
(13, '203.193.192.0', '203.193.223.255', 'Community Telco', 'Australia'),
(14, '122.148.0.0', '122.149.255.255', 'Dodo', 'Australia'),
(15, '220.233.0.0', '220.233.255.255', 'Exetel', 'Australia'),
(16, '203.217.0.0', '203.217.31.255', 'iiNet Limited', 'Australia'),
(17, '202.45.96.0', '202.45.127.255', 'Netspace', 'Australia'),
(18, '58.104.0.0', '58.111.255.255', 'Optus', 'Australia'),
(19, '61.88.0.0', '61.88.255.255', ' Optus', 'Australia'),
(20, '58.145.128.0', '58.145.159.255', 'Optus', 'Australia'),
(21, '211.28.0.0', '211.31.255.255', 'Optus', 'Australia'),
(22, '220.236.0.0', '220.239.255.255', 'Optus', 'Australia'),
(23, '58.160.0.0', '58.175.255.255', 'Telstra Bigpond', 'Australia'),
(24, '121.208.0.0', '121.223.255.255', 'Telstra Bigpond', 'Australia'),
(25, '143.238.0.0', '143.238.255.255', 'Telstra Bigpond', 'Australia'),
(26, '124.176.0.0', '124.191.255.255', 'Telstra Bigpond', 'Australia'),
(27, '192.148.116.0', '192.148.165.255', 'Telstra Internet', 'Australia'),
(28, '60.240.0.0', '60.241.255.255', 'TPG', 'Australia'),
(29, '220.101.0.0', '220.101.191.255', 'Unwired', 'Australia'),
(30, '203.20.32.0', '203.20.39.255', 'Vodafone', 'Australia'),
(31, '58.145.184.0', '58.145.191.255', 'Dhaka Gsm', 'Bangladesh'),
(32, '202.56.4.0', '202.56.7.255', 'Grameenphone', 'Bangladesh'),
(34, '202.160.32.0', '202.160.47.255', 'Jabatan Telekom', 'Brunei'),
(35, '202.152.64.0', '202.152.95.255', 'Simpur', 'Brunei'),
(36, '216.9.240.0', '216.9.255.255', 'Research In Motion', 'Canada'),
(37, '41.221.128.0', '41.221.135.255', 'Net@net Dsl', 'Egypt'),
(38, '193.253.141.0', '193.253.141.255', 'Orange', 'France'),
(39, '84.136.0.0', '84.191.255.255', 'Deutsche Telekom AG', 'Germany'),
(40, '212.23.96.0', '212.23.127.255', 'E-Plus Mobilfunk GmbH', 'Germany'),
(41, '216.230.128.0', '216.230.159.255', 'Telgua', 'Guatemala'),
(42, '190.80.0.0', '190.80.18.0', 'Guyana Telephone', 'Guyana'),
(43, '122.162.0.0', '122.163.255.255', 'Abts Delhi', 'India'),
(44, '202.78.232.0', '202.78.239.255', 'Alliance Braodband', 'India'),
(45, '117.96.0.0', '117.99.255.255', 'Bharti Airtel', 'India'),
(46, '203.145.131.0', '203.145.131.255', 'Bharti Cellular', 'India'),
(47, '203.145.128.0', '203.145.128.15', 'Bharti Cellular', 'India'),
(48, '203.145.188.128', '203.145.188.135', 'Bharti Cellular', 'India'),
(49, '202.56.231.112', '202.56.231.127', 'Bharti Cellular', 'India'),
(50, '203.145.159.32', '203.145.159.47', 'Bharti Cellular', 'India'),
(51, '125.16.0.0', '125.23.255.255', 'Bharti Cellular', 'India'),
(52, '59.88.0.0', '59.99.255.255', 'Bsnlnet', 'India'),
(53, '218.248.0.0', '218.248.255.255', 'Bsnlnet', 'India'),
(54, '210.212.31.0', '210.212.31.63', 'East-BSNL', 'India'),
(55, '203.145.137.160', '203.145.137.191', 'Idea Celular', 'India'),
(56, '203.145.134.192', '203.145.134.223', 'Idea Celular', 'India'),
(57, '203.192.192.0', '203.192.255.255', 'In2cable', 'India'),
(58, '219.91.128.0', '219.91.255.255', 'Iqara Telecom', 'India'),
(59, '203.88.0.0', '203.88.31.255', 'Max Telecom', 'India'),
(60, '164.100.0.0', '164.100.255.255', 'Nicnet', 'India'),
(61, '203.196.192.0', '203.196.255.255', 'Tata', 'India'),
(62, '59.160.0.0', '59.165.255.255', 'Videsh Sanchar Nigam', 'India'),
(63, '219.64.0.0', '219.65.255.255', 'VSNL', 'India'),
(64, '202.152.240.0', '202.152.240.255', 'Jakarta Xlgprs', 'Indonesia'),
(65, '222.124.34.128', '222.124.34.135', 'Telkom Net', 'Indonesia'),
(66, '125.164.0.0', '125.164.255.255', 'Telkom Net', 'Indonesia'),
(67, '212.150.0.0', '212.150.255.255', 'barak', 'Israel'),
(68, '81.199.0.0', '81.199.255.255', 'Ipplanet', 'Israel'),
(69, '192.118.8.0', '192.118.11.255', 'Partner Communications', 'Israel'),
(70, '213.26.0.0', '213.26.255.255', 'Telecomitalia', 'Italy'),
(71, '212.141.0.0', '212.141.255.255', 'Wind Telecom', 'Italy'),
(72, '83.225.0.0', '83.225.255.255', 'Vodafone', 'Italy'),
(73, '83.224.84.0', '83.224.255.255', 'Vodafone', 'Italy'),
(74, '83.224.0.0', '83.224.83.255', 'Vodafone', 'Italy'),
(75, '72.252.0.0', '72.252.255.255', 'Columbus Communication', 'Jamaica'),
(76, '66.54.112.0', '66.54.127.255', 'Digicel', 'Jamaica'),
(77, '208.131.160.0', '208.131.191.255', 'Digicel', 'Jamaica'),
(78, '72.27.0.0', '72.27.223.255', 'Digicel', 'Jamaica'),
(79, '78.0.0.0', '78.255.255.255', 'Riga Telekom', 'Latvia'),
(80, '213.226.128.0', '213.226.131.255', 'Bite Gsm & Internet', 'Lithuania'),
(81, '203.82.64.0', '203.82.95.255', 'Celcomnet', 'Malaysia'),
(82, '196.192.80.0', '196.192.83.255', 'Emtel Limited', 'Mauritius'),
(83, '218.208.128.0', '218.208.255.255', 'Adsl Sreamyx Tmnet', 'Malaysia'),
(84, '203.82.64.0', '203.82.95.255', 'Celcom Net', 'Malaysia'),
(85, '203.92.128.0', '203.92.159.255', 'Digi Telecommunications', 'Malaysia'),
(86, '202.190.0.0', '202.190.255.255', 'Jaring Communications', 'Malaysia'),
(87, '192.228.128.0', '192.228.255.255', 'Jaring Communications', 'Malaysia'),
(88, '202.75.128.0', '202.75.159.255', 'Maxis Communications', 'Malaysia'),
(89, '60.48.0.0', '60.54.255.255', 'Telekom', 'Malaysia'),
(90, '219.92.0.0', '219.93.255.255', 'Tmnet Telekom', 'Malaysia'),
(91, '58.26.6.0', '58.26.6.255', 'Vitaldelta-Tmnet', 'Malaysia'),
(92, '193.220.24.0', '193.220.25.255', 'Maputo', 'Mozambique'),
(93, '121.90.0.0', '121.90.255.255', 'Vodafone', 'New Zeland'),
(94, '196.46.240.0', '196.46.247.255', 'Vee Mobile', 'Nigeria'),
(95, '202.163.64.0', '202.163.95.255', 'Cyber Net', 'Pakistan'),
(96, '61.5.128.0', '61.5.159.255', 'Cyber Net', 'Pakistan'),
(97, '221.132.117.0', '221.132.117.63', 'Mobilink', 'Pakistan'),
(100, '121.1.0.0', '121.1.63.255', 'Smart Broadband', 'Philippines'),
(101, '89.211.0.0', '89.211.255.255', 'Qatar Telecom', 'Qatar'),
(102, '86.107.248.0', '86.107.255.255', 'Ambra', 'Romania'),
(103, '77.0.0.0', '77.255.255.255', 'Bucharest Rosite Net Srl', 'Romania'),
(104, '62.217.247.0', '62.217.247.255', 'Orange', 'Romania'),
(105, '141.1.0.0', '141.85.255.255', 'Pub-Nnet', 'Romania'),
(106, '217.118.84.0', '217.118.87.255', 'Jsc VimpelCom', 'Russia'),
(107, '212.118.140.0', '212.118.143.255', 'SaudiNet Dialup', 'Saudi Arabia'),
(108, '87.238.209.0', '87.238.210.255', 'Its-Net', 'Serbia'),
(109, '203.117.71.0', '203.117.71.255', 'StarHub WAP Applications', 'Singapore'),
(110, '196.208.0.0', '196.211.255.255', 'Internet Solutions', 'South Africa'),
(111, '196.34.0.0', '196.35.255.255', 'Internet Solutions', 'South Africa'),
(112, '147.110.0.0', '147.110.255.255', 'Eskom', 'South Africa'),
(113, '84.23.96.0', '84.23.103.255', 'Etihadetisalat', 'South Africa'),
(114, '196.36.0.0', '196.39.127.255', 'Is', 'South Africa'),
(115, '196.3.94.0', '196.3.94.255', 'Mtc', 'South Africa'),
(116, '196.11.239.0', '196.11.246.255', 'Mtn', 'South Africa'),
(117, '41.208.0.0', '41.208.63.255', 'Mtn', 'South Africa'),
(118, '168.209.0.0', '168.210.255.255', 'NedNet2', 'South Africa'),
(119, '41.194.4.0', '41.194.4.126', 'Online-Malawi', 'South Africa'),
(120, '201.219.18.0', ' 201.219.18.255', 'Telecsa', 'South Africa'),
(121, '41.242.0.0', '41.242.255.255', 'Telkom', 'South Africa'),
(122, '198.54.202.0', '198.54.202.255', 'Telkom', 'South Africa'),
(123, '155.239.208.0', '155.239.209.255', 'Telkom', 'South Africa'),
(124, '41.241.0.0', '41.241.255.255', 'Telkom', 'South Africa'),
(125, '155.239.165.0', '155.239.165.255', 'Telkom', 'South Africa'),
(126, '196.25.255.0', '196.25.255.255', 'Telkom', 'South Africa'),
(127, '196.30.0.0', '196.30.255.255', 'Verzion', 'South Africa'),
(128, '196.200.0.0', '196.207.255.255', 'Vodacom', 'South Africa'),
(129, '202.69.192.0', '202.69.207.255', 'Virgin Media', 'Sri Lanka'),
(130, '203.115.0.0', '203.115.63.255', 'Telecom', 'Sri Lanka'),
(131, '124.43.0.0', '124.43.255.255', 'La Telecom', 'Sri Lanka'),
(132, '116.0.0.0', '116.255.255.255', 'Lanka Communications', 'Sri Lanka'),
(133, '209.94.192.0', '209.94.223.255', 'San Fernando Tstt', 'Trinidad & Tobago'),
(134, '213.150.160.0', '213.150.191.255', 'Afrinic Net', 'Tunisia'),
(135, '193.95.0.0', '193.95.127.255', 'Afrinic Net', 'Tunisia'),
(136, '41.223.84.0', '41.223.87.255', 'Celtel', 'Uganda'),
(137, '41.222.0.0', '41.222.7.255', 'Infocom', 'Uganda'),
(138, '90.208.0.0', '90.209.255.255', 'BskyB Broadband', 'United Kingdom'),
(139, '90.192.0.0', '90.199.255.255', 'BskyB Broadband', 'United Kingdom'),
(140, '86.128.0.0', '86.135.255.255', 'BT Braodband', 'United Kingdom'),
(141, '217.42.0.0', '217.44.255.255', 'BT Braodband', 'United Kingdom'),
(142, '86.136.0.0', '86.141.255.255', 'BT Central Plus', 'United Kingdom'),
(143, '86.148.0.0', '86.159.255.255', 'BT Central Plus', 'United Kingdom'),
(144, '81.154.0.0', '81.157.255.255', 'BT Central Plus', 'United Kingdom'),
(145, '86.142.0.0', '86.144.255.255', 'BT Central Plus', 'United Kingdom'),
(146, '81.152.0.0', '81.152.250.255', 'BT Central Plus', 'United Kingdom'),
(147, '194.72.238.0', '194.72.238.255', 'BT Net', 'United Kingdom'),
(148, '82.108.65.96', '82.108.65.127', 'Conventry University', 'United Kingdom'),
(149, '217.171.128.0', '217.171.143.255', 'Hutchison 3G', 'United Kingdom'),
(150, '212.9.19.192', '212.9.19.207', 'Jersey Telecom Infra', 'United Kingdom'),
(151, '213.52.216.192', '213.52.216.197', 'London Novarra', 'United Kingdom'),
(152, '86.12.224.0', '86.12.255.255', 'Ntl', 'United Kingdom'),
(153, '82.0.0.0', '82.31.255.255', 'Ntl', 'United Kingdom'),
(154, '80.7.112.0', '80.7.127.255', 'Ntl', 'United Kingdom'),
(155, '193.113.200.0', '193.113.200.255', 'o2', 'United Kingdom'),
(156, '82.132.192.0', '82.132.193.255', 'o2', 'United Kingdom'),
(157, '193.35.128.0', '193.35.143.255', 'Orange', 'United Kingdom'),
(158, '85.90.235.0', '85.90.235.63', 'Telecity redbus Novarra', 'United Kingdom'),
(159, '80.192.13.0', '80.192.13.255', 'Telewest', 'United Kingdom'),
(160, '82.37.232.0', '82.37.239.255', 'Telewest', 'United Kingdom'),
(161, '149.254.0.0', '149.254.255.255', 'T-Mobile', 'United Kingdom'),
(162, '212.183.128.0', '212.183.144.255', 'Vodaphone', 'United Kingdom'),
(163, '205.142.16.0', '205.142.19.255', 'Alltel', 'United States'),
(164, '64.12.0.0', '64.12.255.255', 'Aol', 'United States'),
(165, '69.224.0.0', '69.239.255.255', 'AT&T Internet', 'United States'),
(166, '209.103.192.0', '209.103.223.255', 'Athenet Data Exchange', 'United States'),
(167, '209.183.32.0', '209.183.63.255', 'Cingular Wireless II', 'United States'),
(168, '98.192.0.0', '98.227.255.255', 'Comcast Cable Communications', 'United States'),
(169, '64.246.160.0', '64.246.191.255', 'Compass Communications', 'United States'),
(170, '63.208.0.0', '63.215.255.255', 'Cricket Communications', 'United States'),
(171, '205.239.0.0', '205.239.255.255', 'Eds', 'United States'),
(172, '76.0.0.0', '76.7.255.255', 'Embarq Global', 'United States'),
(173, '216.68.0.0', '216.68.255.255', 'Fuse Internet', 'United States'),
(174, '69.65.0.0', '69.65.63.255', 'Gigenet', 'United States'),
(175, '64.208.0.0', '64.209.127.255', 'Global Crossing', 'United States'),
(176, '72.29.64.0', '72.29.95.255', 'Host Dime', 'United States'),
(177, '64.152.0.0', '64.159.255.255', 'Level 3 Communications', 'United States'),
(178, '65.88.0.0', '65.91.255.255', 'Level 3 Communications', 'United States'),
(179, '65.192.0.0', '65.223.255.255', 'Mci Communications', 'United States'),
(180, '66.232.96.0', '66.232.127.255', 'Noc4hosts Inc', 'United States'),
(181, '67.80.0.0', '67.87.255.255', 'Optimum Online', 'United States'),
(182, '75.126.0.0', '75.126.255.255', 'SoftLayer', 'United States'),
(183, '67.228.0.0', '67.228.255.255', 'SoftLayer', 'United States'),
(184, '68.24.0.0', '68.31.255.255', 'Sprint', 'United States'),
(185, '70.0.0.0', '70.14.255.255', 'Sprint Wireless', 'United States'),
(186, '66.94.0.0', '66.94.31.255', 'T Mobile', 'United States'),
(187, '200.40.246.0', '200.40.246.26', 'Ancel', 'Uruguay'),
(188, '81.199.96.0', '81.199.103.255', 'Copper Net', 'Zambia'),
(190, '213.107.0.0', '213.107.15.255', 'NTL', 'United Kingdom'),
(191, '82.112.128.0', '82.112.151.255', 'Jersey Telecom Rapid', 'United Kingdom');
-- --------------------------------------------------------
--
-- Table structure for table `nicks`
--
CREATE TABLE IF NOT EXISTS `nicks` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`nicklvl` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(12) NOT NULL DEFAULT '0',
`time` int(100) NOT NULL DEFAULT '0',
`place` varchar(50) NOT NULL DEFAULT '',
`link` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
--
-- Dumping data for table `online`
--
INSERT INTO `online` (`id`, `uid`, `time`, `place`, `link`) VALUES
(55, 5, 1371913772, 'Main Menu', 'main.php'),
(53, 1, 1371913780, 'Inbox', 'inbox.php');
-- --------------------------------------------------------
--
-- Table structure for table `pollresults`
--
CREATE TABLE IF NOT EXISTS `pollresults` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`pollid` int(100) NOT NULL DEFAULT '0',
`uid` int(100) NOT NULL DEFAULT '0',
`answer` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `polls`
--
CREATE TABLE IF NOT EXISTS `polls` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`question` varchar(255) NOT NULL DEFAULT '',
`option1` varchar(100) NOT NULL DEFAULT '',
`option2` varchar(100) NOT NULL DEFAULT '',
`option3` varchar(100) NOT NULL DEFAULT '',
`option4` varchar(100) NOT NULL DEFAULT '',
`option5` varchar(100) NOT NULL DEFAULT '',
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `popups`
--
CREATE TABLE IF NOT EXISTS `popups` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`byid` int(100) NOT NULL DEFAULT '0',
`toid` int(100) NOT NULL DEFAULT '0',
`unread` char(1) NOT NULL DEFAULT '1',
`timesent` int(100) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `profiles`
--
CREATE TABLE IF NOT EXISTS `profiles` (
`uid` varchar(100) NOT NULL DEFAULT '',
`time` int(100) NOT NULL DEFAULT '0',
`birthday` varchar(10) NOT NULL DEFAULT '',
`sex` char(1) NOT NULL DEFAULT '',
`location` varchar(100) NOT NULL DEFAULT '',
`moreinfo` varchar(100) NOT NULL DEFAULT '',
`picture` varchar(100) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`status` varchar(50) NOT NULL DEFAULT '',
`mood` varchar(20) NOT NULL DEFAULT '',
`site_mood` char(1) NOT NULL DEFAULT '0',
`image` varchar(100) NOT NULL DEFAULT '',
`points` varchar(50) NOT NULL DEFAULT '0',
`forumposts` int(10) NOT NULL DEFAULT '0',
`chatmsgs` int(10) NOT NULL DEFAULT '0',
`shouts` int(10) NOT NULL DEFAULT '0',
`body_background` varchar(7) NOT NULL DEFAULT '#000000',
`body_text` varchar(7) NOT NULL DEFAULT '#808080',
`font_size` varchar(7) NOT NULL DEFAULT 'medium',
`border_color` varchar(7) NOT NULL DEFAULT '#808080',
`div_background` varchar(7) NOT NULL DEFAULT '#000000',
`link_color` varchar(7) NOT NULL DEFAULT '#cccccc',
`script` varchar(5) NOT NULL DEFAULT '',
`quiz_score` varchar(100) NOT NULL DEFAULT '0/0/0',
`quiz_easy` char(3) NOT NULL DEFAULT 'no',
`quiz_medium` char(3) NOT NULL DEFAULT 'no',
`quiz_hard` char(3) NOT NULL DEFAULT 'no',
`total_score` varchar(10) NOT NULL DEFAULT '0',
`proviews` varchar(10) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profiles`
--
INSERT INTO `profiles` (`uid`, `time`, `birthday`, `sex`, `location`, `moreinfo`, `picture`, `email`, `status`, `mood`, `site_mood`, `image`, `points`, `forumposts`, `chatmsgs`, `shouts`, `body_background`, `body_text`, `font_size`, `border_color`, `div_background`, `link_color`, `script`, `quiz_score`, `quiz_easy`, `quiz_medium`, `quiz_hard`, `total_score`, `proviews`) VALUES
('1', 9469, '1980-02-16', 'M', 'UK', 'Just Scrooge. Love u babe xO', 'http://latenytz.info/avatars/1-005.gif', 'scrooge@latenytz.info', '', '', '0', '', '0', 0, 0, 0, '#000000', '#808080', 'medium', '#808080', '#000000', '#cccccc', 'xhtml', '0/0/0', 'no', 'no', 'no', '0', '1'),
('2', 54, '1990-12-18', 'F', 'My Bed x', 'Thats all :)', '', 'emma@emma.emma', '', '', '0', '', '1', 1, 0, 0, '#000000', '#808080', 'medium', '#808080', '#000000', '#cccccc', 'xhtml', '0/0/0', 'no', 'no', 'no', '0', '8'),
('3', 164, '1946-01-01', 'F', 'Latenytz', 'Site Guestbook - No inboxes please.', '', 'guestbook@latenytz.info', '', '', '0', '', '0', 0, 0, 0, '#000000', '#808080', 'medium', '#808080', '#000000', '#cccccc', 'xhtml', '0/0/0', 'no', 'no', 'no', '0', ''),
('4', 2231, '1972-04-21', 'F', 'uk', 'here to have a look', '', 'hidden', '', '', '0', '', '480', 0, 0, 0, '#000000', '#808080', 'medium', '#808080', '#000000', '#cccccc', 'xhtml', '0/0/0', 'no', 'no', 'no', '0', '5'),
('5', 788, '1964-04-08', 'F', 'wapland', 'hi im waps angel :)', '', 'wapangel65@gmail.com', '', '', '0', '', '0', 0, 0, 0, '#A9A9A9', '#000000', 'medium', '#00FA9A', '#DCDCDC', '#8B0000', 'xhtml', '0/0/0', 'no', 'no', 'no', '0', '2');
-- --------------------------------------------------------
--
-- Table structure for table `quiz`
--
CREATE TABLE IF NOT EXISTS `quiz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`question` varchar(200) NOT NULL DEFAULT '',
`answer` varchar(30) NOT NULL DEFAULT '',
`difficulty` varchar(12) NOT NULL DEFAULT '',
`number` int(11) NOT NULL DEFAULT '0',
`answer1` varchar(50) NOT NULL DEFAULT '',
`answer2` varchar(50) NOT NULL DEFAULT '',
`answer3` varchar(50) NOT NULL DEFAULT '',
`answer4` varchar(50) NOT NULL DEFAULT '',
`switch` char(3) NOT NULL DEFAULT 'on',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `quiz`
--
INSERT INTO `quiz` (`id`, `question`, `answer`, `difficulty`, `number`, `answer1`, `answer2`, `answer3`, `answer4`, `switch`) VALUES
(1, 'what is 500 in roman numerals', 'd', 'easy', 1, 'a', 'g', 'v', 'd', 'on'),
(2, 'how many strings dose a violin have', '4', 'easy', 2, '7', '5', '4', '6', 'on'),
(3, 'what is the 5th planet in solar system called', 'jupiter', 'easy', 3, 'mars', 'moon', 'sun', 'jupiter', 'on'),
(4, 'what was the name of captain cooks famous ship', 'hms endeavour', 'easy', 4, 'msh boat', 'hms ship', 'hms endeavour', 'hsm jet boat', 'on'),
(5, 'in secabble how many letters have a value of 2', 'd n g', 'easy', 5, 'a n t', 's n r', 'd n g', 'p n q', 'on'),
(6, 'what is chiminage?', 'a toll', 'easy', 6, 'a tree', 'a river', 'a bat', 'a toll', 'on'),
(7, 'what animal is affed bye the disease braxy', 'sheep', 'easy', 7, 'bird', 'dog', 'goat', 'sheep', 'on'),
(8, 'what item of clothing is also know as a filibeg?', 'kilt', 'easy', 8, 'top', 'dress', 'kilt', 'pants', 'on'),
(9, 'what do you do with a zloty in poland', 'spend it', 'easy', 9, 'keep it', 'fine it', 'save it', 'spend it', 'on'),
(10, 'what dose the phrase mae clupa mean ?', 'my fault', 'easy', 10, 'iam guilty', 'not me', 'my fault', 'not my doing', 'on'),
(11, 'what sort creature is a scup?', 'a fish', 'med', 1, 'a dog', 'a cat', 'a fish', 'a bird', 'on'),
(12, 'what O is the name given to a pice of music opening a concert?', 'overture', 'med', 2, 'overkill', 'overbeat', 'overtune', 'overture', 'on'),
(13, 'what is the name of a small group of whales or seals?', 'a pod', 'med', 3, 'a school of fish', 'a group of whales', 'a pod', 'a group of seals', 'on'),
(14, 'what in ireland is a loy?', 'a spade', 'med', 4, 'a pick', 'a spoon', 'a spade', 'a meal', 'on'),
(15, 'who ranted about the way iam in a dark hit in 2000?', 'eminem', 'med', 5, 'fitty cents', 'nelly', 'eminem', 'snoop doggie', 'on'),
(16, 'who had hits with alcoholic', 'starsailor', 'med', 6, 'fiffty cents', 'justin timberlake', 'nelly furtardo', 'starsailor', 'on'),
(17, 'can you name the pudlicity shy lead singer of the arctic monkeys?', 'alex turner', 'med', 7, 'justin timberlake', 'amy winehouse', 'damien rice', 'alex turner', 'on'),
(18, 'who released fit but you know it from the album a grand dont come for free?', 'the streets', 'med', 8, 'pearl jam', 'ozzy', 'the streets', 'starsailor', 'on'),
(19, 'what is the name of the largest artery in the human body?', 'aorta', 'med', 9, 'vaines', 'red blood cells', 'aorta', 'white blood cells', 'on'),
(20, 'in which year did the explosion at chernbyl nuclear reactor occur?', '1986', 'med', 10, '1976', '1966', '1956', '1986', 'on'),
(21, 'what was the name of the russian submarine which was flooded and stranded on the sea bed in august?', 'the kursk', 'hard', 1, 'the russian', 'the France', 'the England', 'the kursk', 'on'),
(22, 'who or what was piper alpha?', 'a north sea oil rig', 'hard', 2, 'a sailing ship', 'a oil ship', 'a jetski', 'a north sea oil rig', 'on'),
(23, 'in which year were 8 members of the manchester united football team killed in a air disaster?', '1958', 'hard', 3, '1955', '1960', '1958', '1976', 'on'),
(24, 'in which year was the great fire of london?', '1666', 'hard', 4, '1709', '1810', '1666', '1909', 'on'),
(25, 'what particular gimmick was used in the 1958 film house of wax?', 'it was made in 3d', 'hard', 5, 'it was the wax', 'it was the house', 'it was made in 3d', 'it was never made', 'on'),
(26, 'what name was given to the light winds which blow across the equatot?', 'doldrums', 'hard', 6, 'lightrums', 'doldrums', 'brightrums', 'dolrums', 'on'),
(27, 'what is the alternatvie name of the tree konwen as the mountain ash?', 'rowan', 'hard', 7, 'ashly', 'ashflod', 'rowan', 'ash', 'on'),
(28, 'what is the name of the secince of the study of time', 'chonology', 'hard', 8, 'timespace', 'chonology', 'worldtime', 'time', 'on'),
(29, 'in which year was the lockerbie disaster which destroyed pan am flight 103?', '1988', 'hard', 9, '1974', '1964', '1988', '1990', 'on'),
(30, 'what type of disaster struck the central america in 1998?', 'hurricane mitch', 'hard', 10, 'hurricane paul', 'hurricane nina', 'hurricane mitch', 'hurricane sue', 'on');
-- --------------------------------------------------------
--
-- Table structure for table `quizusers`
--
CREATE TABLE IF NOT EXISTS `quizusers` (
`uid` int(100) NOT NULL DEFAULT '0',
`easy_question` char(2) NOT NULL DEFAULT '0',
`easy_next` char(2) NOT NULL DEFAULT '0',
`med_question` char(2) NOT NULL DEFAULT '0',
`med_next` char(2) NOT NULL DEFAULT '0',
`hard_question` char(2) NOT NULL DEFAULT '0',
`hard_next` char(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `ses`
--
CREATE TABLE IF NOT EXISTS `ses` (
`id` varchar(100) NOT NULL DEFAULT '',
`uid` varchar(30) NOT NULL DEFAULT '',
`expiretm` int(100) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ses`
--
INSERT INTO `ses` (`id`, `uid`, `expiretm`) VALUES
('fd15cb56b8c9d8918b4b467bd3fd7ec7', '1', 1371914980),
('afa7f1ef6da2e80b024a80f95a0350f9', '5', 1371914972);
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1, 'sesexp', '20'),
(2, '17:37 - Thu 20th Jun 13', '3'),
(3, 'greeting', '[font=yellow]Welcome to LateNytz[/font]'),
(4, 'Counter', '341'),
(5, 'antiflood', '5'),
(6, 'registration', '1'),
(7, 'forumview', '0'),
(8, 'lastbpm', '2013-06-22'),
(9, 'sitename', 'LateNytz'),
(10, 'site_email', 'adminteam@latenytz.info'),
(11, 'gallery_email', 'adminteam@latenytz.info'),
(12, 'timezone', 'europe/london'),
(13, 'validation', '0'),
(14, 'align', 'center');
-- --------------------------------------------------------
--
-- Table structure for table `shouts`
--
CREATE TABLE IF NOT EXISTS `shouts` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`shout` varchar(100) NOT NULL DEFAULT '',
`uid` int(100) NOT NULL DEFAULT '0',
`shtime` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `smilies`
--
CREATE TABLE IF NOT EXISTS `smilies` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`code` varchar(15) NOT NULL DEFAULT '',
`path` varchar(200) NOT NULL DEFAULT '',
`hidden` char(1) NOT NULL DEFAULT '0',
`mood` char(1) NOT NULL DEFAULT '0',
`date` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `scode` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `themes`
--
CREATE TABLE IF NOT EXISTS `themes` (
`color` varchar(20) NOT NULL DEFAULT '',
`hex` varchar(7) NOT NULL DEFAULT '',
`text` varchar(7) NOT NULL DEFAULT '#000000',
PRIMARY KEY (`color`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `themes`
--
INSERT INTO `themes` (`color`, `hex`, `text`) VALUES
('blue', '#0000FF', '#000000'),
('black', '#000000', '#FFFFFF'),
('brown', '#663300', '#000000'),
('gray', '#A9A9A9', '#000000'),
('orange', '#FF8C00', '#000000'),
('dark red', '#8B0000', '#000000'),
('violet', '#9400D3', '#000000'),
('pink', '#FF1493', '#000000'),
('light blue', '#00BFFF', '#000000'),
('light gray', '#DCDCDC', '#000000'),
('green', '#008000', '#000000'),
('light pink', '#FF69B4', '#000000'),
('purple', '#4B0082', '#000000'),
('light green', '#7CFC00', '#000000'),
('light purple', '#9370D8', '#000000'),
('aqua', '#00FA9A', '#000000'),
('dark blue', '#000066', '#000000'),
('red', '#FF0000', '#000000'),
('yellow', '#FFFF00', '#000000'),
('white', '#FFFFFF', '#000000');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`regdate` int(100) NOT NULL DEFAULT '0',
`username` varchar(12) NOT NULL DEFAULT '',
`password` varchar(40) NOT NULL DEFAULT '',
`level` char(1) NOT NULL DEFAULT '0',
`shield` char(1) NOT NULL DEFAULT '0',
`lastact` int(100) NOT NULL DEFAULT '0',
`pollid` int(100) NOT NULL DEFAULT '0',
`browser` varchar(100) NOT NULL DEFAULT '',
`ipaddress` varchar(30) NOT NULL DEFAULT '',
`host` varchar(100) NOT NULL DEFAULT '',
`validated` char(1) NOT NULL DEFAULT '0',
`images` char(1) NOT NULL DEFAULT '1',
`automsgs` char(1) NOT NULL DEFAULT '1',
`popups` char(1) NOT NULL DEFAULT '1',
`hidden` char(1) NOT NULL DEFAULT '0',
`viewpro` int(1) NOT NULL DEFAULT '0',
`profiletheme` varchar(100) NOT NULL DEFAULT 'site_medium.css',
`ms` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `regdate`, `username`, `password`, `level`, `shield`, `lastact`, `pollid`, `browser`, `ipaddress`, `host`, `validated`, `images`, `automsgs`, `popups`, `hidden`, `viewpro`, `profiletheme`, `ms`) VALUES
(1, 1371587771, 'MRMENTAL', 'bcee3e1e75af501283e6bb0ea701ab66', '7', '0', 1371913780, 0, 'Mozilla(5.0)', '92.251.255.11', '92.251.255.11.threembb.ie', '1', '1', '1', '1', '0', 0, 'site_medium.css', 2),
(2, 1371745106, 'kinkykitten', '56e0b8df8c3315f6bb9049552241df1e', '0', '0', 1371745192, 0, 'Mozilla(5.0)', '92.251.255.14', '92.251.255.14.threembb.ie', '1', '1', '1', '1', '0', 0, 'site_medium.css', 0),
(3, 1371745234, 'guestbook', 'acaa22ac516df80f5ec267a7382c1b6e', '0', '0', 1371745439, 0, 'Mozilla(5.0)', '92.251.255.14', '92.251.255.14.threembb.ie', '1', '1', '1', '1', '0', 0, 'site_medium.css', 0),
(4, 1371897069, 'mzfilthy', 'f48861ca24e26a23a923ca68657079f4', '0', '0', 1371909256, 0, 'Mozilla(5.0)', '90.204.15.11', '5acc0f0b.bb.sky.com', '1', '1', '1', '1', '0', 0, 'site_medium.css', 0),
(5, 1371912590, 'wapangel', '0c2697a9a69ce8aed9e90087b46bde14', '0', '0', 1371913772, 0, 'Opera(9.80)', '82.132.214.244', 'dab-bas1-h-1-8.dab.02.net', '1', '1', '1', '1', '0', 0, 'site_medium.css', 0);
-- --------------------------------------------------------
--
-- Table structure for table `usfun`
--
CREATE TABLE IF NOT EXISTS `usfun` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`uid` int(100) NOT NULL DEFAULT '0',
`action` varchar(10) NOT NULL DEFAULT '',
`target` int(100) NOT NULL DEFAULT '0',
`actime` int(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=252 ;
--
-- Dumping data for table `usfun`
--
INSERT INTO `usfun` (`id`, `uid`, `action`, `target`, `actime`) VALUES
(251, 0, 'smooch', 1, 1254866261);
-- --------------------------------------------------------
--
-- Table structure for table `wapsite`
--
CREATE TABLE IF NOT EXISTS `wapsite` (
`uid` int(100) NOT NULL DEFAULT '0',
`blog_comments` char(1) NOT NULL DEFAULT '1',
`guestbook` char(1) NOT NULL DEFAULT '0',
`reported` char(1) NOT NULL DEFAULT '0',
`mainpage` text NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '',
`surname` varchar(50) NOT NULL DEFAULT '',
`nickname` varchar(50) NOT NULL DEFAULT '',
`maritalstatus` char(1) NOT NULL DEFAULT '0',
`city` varchar(50) NOT NULL DEFAULT '',
`height` varchar(50) NOT NULL DEFAULT '',
`weight` varchar(50) NOT NULL DEFAULT '',
`bodytype` char(1) NOT NULL DEFAULT '0',
`origin` char(1) NOT NULL DEFAULT '0',
`hair` varchar(50) NOT NULL DEFAULT '',
`eyes` char(1) NOT NULL DEFAULT '0',
`happy` varchar(255) NOT NULL DEFAULT '',
`sad` varchar(255) NOT NULL DEFAULT '',
`interests` varchar(255) NOT NULL DEFAULT '',
`profession` varchar(50) NOT NULL DEFAULT '',
`badhabits` varchar(255) NOT NULL DEFAULT '',
`goodhabits` varchar(255) NOT NULL DEFAULT '',
`team` varchar(50) NOT NULL DEFAULT '',
`band` varchar(50) NOT NULL DEFAULT '',
`music` varchar(50) NOT NULL DEFAULT '',
`tvshow` varchar(50) NOT NULL DEFAULT '',
`food` varchar(50) NOT NULL DEFAULT '',
`author` varchar(50) NOT NULL DEFAULT '',
`movie` varchar(50) NOT NULL DEFAULT '',
`animal` varchar(50) NOT NULL DEFAULT '',
`place` varchar(255) NOT NULL DEFAULT '',
`thing` varchar(255) NOT NULL DEFAULT '',
`aboutme` text NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `wapsite`
--
INSERT INTO `wapsite` (`uid`, `blog_comments`, `guestbook`, `reported`, `mainpage`, `name`, `surname`, `nickname`, `maritalstatus`, `city`, `height`, `weight`, `bodytype`, `origin`, `hair`, `eyes`, `happy`, `sad`, `interests`, `profession`, `badhabits`, `goodhabits`, `team`, `band`, `music`, `tvshow`, `food`, `author`, `movie`, `animal`, `place`, `thing`, `aboutme`) VALUES
(3, '1', '1', '0', 'hellllllllllooooooooo :)', '', '', '', '0', '', '', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;