CREATE TABLE IF NOT EXISTS `adminclicks` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `number` int(11) NOT NULL default '0',
  `adid` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `adminclicks`
--


-- --------------------------------------------------------

--
-- Table structure for table `adminlinks`
--

CREATE TABLE IF NOT EXISTS `adminlinks` (
  `id` int(11) NOT NULL auto_increment,
  `number` int(11) NOT NULL default '0',
  `adid` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `adminlinks`
--


-- --------------------------------------------------------

--
-- Table structure for table `adminnotes`
--

CREATE TABLE IF NOT EXISTS `adminnotes` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `htmlcode` longtext NOT NULL,
  KEY `index` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `adminnotes`
--

INSERT INTO `adminnotes` (`id`, `name`, `htmlcode`) VALUES
(1, 'Admin Notes', '');

-- --------------------------------------------------------

--
-- Table structure for table `adminsolos`
--

CREATE TABLE IF NOT EXISTS `adminsolos` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `approved` tinyint(4) NOT NULL default '0',
  `subject` varchar(100) NOT NULL default '',
  `adbody` longtext NOT NULL,
  `sent` tinyint(4) NOT NULL default '0',
  `datesent` int(15) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `date` int(15) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `adminsolos`
--


-- --------------------------------------------------------

--
-- Table structure for table `advertise`
--

CREATE TABLE IF NOT EXISTS `advertise` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `bannerurl` varchar(70) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `advertise`
--


-- --------------------------------------------------------

--
-- Table structure for table `autoresponder`
--

CREATE TABLE IF NOT EXISTS `autoresponder` (
  `id` int(9) NOT NULL auto_increment,
  `days` tinyint(4) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `message` text NOT NULL,
  `memtype` varchar(10) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `autoresponder`
--


-- --------------------------------------------------------

--
-- Table structure for table `banned_emails`
--

CREATE TABLE IF NOT EXISTS `banned_emails` (
  `id` int(15) NOT NULL auto_increment,
  `email` varchar(150) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `banned_emails`
--

INSERT INTO `banned_emails` (`id`, `email`) VALUES
(1, 'hotmail.com\r');

-- --------------------------------------------------------

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `bannerurl` varchar(100) NOT NULL default '',
  `targeturl` varchar(70) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `shown` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `show_views` int(9) NOT NULL default '0',
  `show_clicks` int(9) NOT NULL default '0',
  KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `banners`
--


-- --------------------------------------------------------

--
-- Table structure for table `bannerviews`
--

CREATE TABLE IF NOT EXISTS `bannerviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `blid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `blid` (`blid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bannerviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `botnav`
--

CREATE TABLE IF NOT EXISTS `botnav` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `targeturl` varchar(70) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `shown` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `show_views` int(9) NOT NULL default '0',
  `show_clicks` int(9) NOT NULL default '0',
  `date` int(15) NOT NULL default '0',
  KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `botnav`
--


-- --------------------------------------------------------

--
-- Table structure for table `botnavviews`
--

CREATE TABLE IF NOT EXISTS `botnavviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `blid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `blid` (`blid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `botnavviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `builder`
--

CREATE TABLE IF NOT EXISTS `builder` (
  `userid` varchar(20) NOT NULL default '',
  `fav1_title` varchar(100) NOT NULL default '',
  `fav1_desc` varchar(100) NOT NULL default '',
  `fav1_url` varchar(250) NOT NULL default '',
  `fav2_title` varchar(100) NOT NULL default '',
  `fav2_desc` varchar(100) NOT NULL default '',
  `fav2_url` varchar(250) NOT NULL default '',
  `fav3_title` varchar(100) NOT NULL default '',
  `fav3_desc` varchar(100) NOT NULL default '',
  `fav3_url` varchar(250) NOT NULL default '',
  `site1` varchar(255) NOT NULL default '',
  `site2` varchar(255) NOT NULL default '',
  `site3` varchar(255) NOT NULL default '',
  `site4` varchar(255) NOT NULL default '',
  `site5` varchar(255) NOT NULL default '',
  `site6` varchar(255) NOT NULL default '',
  `site7` varchar(255) NOT NULL default '',
  `site8` varchar(255) NOT NULL default '',
  `site9` varchar(255) NOT NULL default '',
  `site10` varchar(255) NOT NULL default '',
  `site11` varchar(255) NOT NULL default '',
  `fav1_bold` tinyint(4) NOT NULL default '0',
  `fav2_bold` tinyint(4) NOT NULL default '0',
  `fav3_bold` tinyint(4) NOT NULL default '0',
  `fav1_color` varchar(15) NOT NULL default '',
  `fav2_color` varchar(15) NOT NULL default '',
  `fav3_color` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `builder`
--


-- --------------------------------------------------------

--
-- Table structure for table `builder_cat`
--

CREATE TABLE IF NOT EXISTS `builder_cat` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `order` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `builder_cat`
--

INSERT INTO `builder_cat` (`id`, `name`, `order`) VALUES
(1, 'AdExchanges', 1);

-- --------------------------------------------------------

--
-- Table structure for table `builder_fav`
--

CREATE TABLE IF NOT EXISTS `builder_fav` (
  `id` int(5) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `desc` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `bold` tinyint(4) NOT NULL default '0',
  `color` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `builder_fav`
--


-- --------------------------------------------------------

--
-- Table structure for table `builder_sites`
--

CREATE TABLE IF NOT EXISTS `builder_sites` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `desc` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `order` int(9) NOT NULL default '0',
  `category` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `builder_sites`
--


-- --------------------------------------------------------

--
-- Table structure for table `buttons`
--

CREATE TABLE IF NOT EXISTS `buttons` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `bannerurl` varchar(100) NOT NULL default '',
  `targeturl` varchar(70) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `shown` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `show_views` int(9) NOT NULL default '0',
  `show_clicks` int(9) NOT NULL default '0',
  KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `buttons`
--


-- --------------------------------------------------------

--
-- Table structure for table `buttonviews`
--

CREATE TABLE IF NOT EXISTS `buttonviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `blid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `blid` (`blid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `buttonviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `clicks`
--

CREATE TABLE IF NOT EXISTS `clicks` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `number` int(11) NOT NULL default '0',
  `adid` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `clicks`
--


-- --------------------------------------------------------

--
-- Table structure for table `drawing`
--

CREATE TABLE IF NOT EXISTS `drawing` (
  `userid` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `drawing`
--


-- --------------------------------------------------------

--
-- Table structure for table `emails`
--

CREATE TABLE IF NOT EXISTS `emails` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `subject` varchar(255) default NULL,
  `message` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` (`id`, `title`, `subject`, `message`) VALUES
(1, 'newticket', 'New Support Request', 'Dear ~fullname~,\r\n\r\nYour support request has been received.  You will receive a response as quickly as possible.\r\n\r\nThank You for using ~sitename~!\r\n\r\nSincerely,\r\n~sitename~ Support\r\n'),
(2, 'ticketreply', 'Support Ticket Updated', '------------------------------------------------\r\nPLEASE DO NOT REPLY TO THIS EMAIL.  GO TO THE ONLINE HELP DESK INSTEAD\r\n~domain~/~subdomain~\r\n------------------------------------------------\r\n\r\nSubject: ~subj~\r\nCreated: ~timesubmitted~\r\nName: ~fullname~\r\n\r\nHello ~fullname~,\r\n\r\nYour ticket has been updated.  Please visit our online support center to view our response to you.\r\n\r\nThank you for using our Online Support Center.\r\n\r\nBest Regards,\r\n~sitename~ Support Center\r\n\r\n----------------------------------------------\r\n    Context of your support request\r\n----------------------------------------------\r\n[Status: ~ticketstatus~]\r\n\r\n~mesg~\r\n\r\n--------------------------------------------------------------------------------\r\n\r\n'),
(3, 'reply', 'New Reply Added', 'Dear ~fullname~,\r\n\r\nYour added reply has been received.  You will receive a response as quickly as possible.\r\n\r\nThank You for using ~sitename~!\r\n\r\nSincerely,\r\n~sitename~ Support\r\n');

-- --------------------------------------------------------

--
-- Table structure for table `email_promotion`
--

CREATE TABLE IF NOT EXISTS `email_promotion` (
  `id` int(11) NOT NULL auto_increment,
  `subject1` varchar(250) NOT NULL default '',
  `subject2` varchar(250) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `email_promotion`
--


-- --------------------------------------------------------

--
-- Table structure for table `footerads`
--

CREATE TABLE IF NOT EXISTS `footerads` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `approved` tinyint(4) NOT NULL default '0',
  `subject` varchar(35) default NULL,
  `desc1` varchar(35) default NULL,
  `desc2` varchar(35) default NULL,
  `paid` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `url` varchar(255) default NULL,
  `clicks` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `footerads`
--


-- --------------------------------------------------------

--
-- Table structure for table `hotlinks`
--

CREATE TABLE IF NOT EXISTS `hotlinks` (
  `id` int(15) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `subject` varchar(150) NOT NULL default '',
  `url` varchar(250) NOT NULL default '',
  `added` tinyint(4) NOT NULL default '0',
  `approved` tinyint(4) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  `max` int(9) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `purchase` int(15) NOT NULL default '0',
  `date` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hotlinks`
--


-- --------------------------------------------------------

--
-- Table structure for table `hotlink_clicks`
--

CREATE TABLE IF NOT EXISTS `hotlink_clicks` (
  `hotlinkid` int(11) NOT NULL default '0',
  `userid` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotlink_clicks`
--


-- --------------------------------------------------------

--
-- Table structure for table `links`
--

CREATE TABLE IF NOT EXISTS `links` (
  `id` int(11) NOT NULL auto_increment,
  `number` int(11) NOT NULL default '0',
  `adid` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `links`
--


-- --------------------------------------------------------

--
-- Table structure for table `loginads`
--

CREATE TABLE IF NOT EXISTS `loginads` (
  `id` int(15) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `subject` varchar(250) NOT NULL default '',
  `adbody` text NOT NULL,
  `approved` tinyint(4) NOT NULL default '0',
  `hits` int(10) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `loginads`
--


-- --------------------------------------------------------

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `lastname` varchar(50) NOT NULL default '',
  `contact_email` varchar(50) NOT NULL default '',
  `subscribed_email` varchar(80) NOT NULL default '',
  `paypal_email` varchar(50) NOT NULL default '',
  `alertpay_email` varchar(50) NOT NULL default '',
  `pword` varchar(20) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `referid` varchar(20) NOT NULL default '',
  `verified` tinyint(4) NOT NULL default '0',
  `solos` tinyint(4) NOT NULL default '0',
  `points` double NOT NULL default '0',
  `commission` double NOT NULL default '0',
  `ip` varchar(30) NOT NULL default '',
  `joindate` date NOT NULL default '0000-00-00',
  `subscribed` date NOT NULL default '0000-00-00',
  `memtype` varchar(15) NOT NULL default '',
  `confirmed` date NOT NULL default '0000-00-00',
  `vacation` tinyint(4) NOT NULL default '0',
  `vacation_date` int(15) NOT NULL default '0',
  `referrer` varchar(255) NOT NULL default '',
  `safepay_email` varchar(50) NOT NULL default '',
  `moneybookers_email` varchar(50) NOT NULL default '',
  `solo_clicks` int(10) NOT NULL default '0',
  `traffic_clicks` int(15) NOT NULL default '0',
  `textad_clicks` int(15) NOT NULL default '0',
  `lastlogin` varchar(20) NOT NULL default '',
  `upgrade_points` tinyint(4) NOT NULL default '0',
  `banner_clicks` int(15) NOT NULL default '0',
  `button_clicks` int(15) NOT NULL default '0',
  `hotlink_clicks` int(15) NOT NULL default '0',
  `htmlad_clicks` int(15) NOT NULL default '0',
  `traffic1_clicks` int(15) NOT NULL default '0',
  `solo1_clicks` int(15) NOT NULL default '0',
  `textad1_clicks` int(15) NOT NULL default '0',
  `banner1_clicks` int(15) NOT NULL default '0',
  `button1_clicks` int(15) NOT NULL default '0',
  `hotlink1_clicks` int(15) NOT NULL default '0',
  `htmlad1_clicks` int(15) NOT NULL default '0',
  `propoints` tinyint(4) NOT NULL default '0',
  `navtop_clicks` int(15) NOT NULL default '0',
  `navbot_clicks` int(15) NOT NULL default '0',
  `powersolo_clicks` int(15) NOT NULL default '0',
  `ptc_clicks` int(15) NOT NULL default '0',
  `navtop1_clicks` int(15) NOT NULL default '0',
  `navbot1_clicks` int(15) NOT NULL default '0',
  `powersolo1_clicks` int(15) NOT NULL default '0',
  `ptc1_clicks` int(15) NOT NULL default '0',
  `surf_clicks` int(15) NOT NULL default '0',
  `surf1_clicks` int(15) NOT NULL default '0',
  `surf_last_id` int(15) NOT NULL default '0',
  KEY `index` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `members`
--


-- --------------------------------------------------------

--
-- Table structure for table `navigation`
--

CREATE TABLE IF NOT EXISTS `navigation` (
  `name` varchar(100) NOT NULL default '',
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(150) NOT NULL default '',
  `status` char(3) NOT NULL default 'ON',
  `seq` int(11) NOT NULL default '0',
  `memtype` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `navigation`
--

INSERT INTO `navigation` (`name`, `id`, `url`, `status`, `seq`, `memtype`) VALUES
('<b>Start Here</b>', 1, 'index.php', 'ON', 1, ''),
('<b>Post Text Ads</b>', 2, 'post.php', 'ON', 2, ''),
('<b>Browse Text Ads<b/>', 3, 'browseads.php', 'ON', 3, ''),
('<b>Post HTML Ads</b>', 4, 'post_html.php', 'ON', 4, ''),
('<b>Browse HTML Ads<b/>', 5, 'browseads_html.php', 'ON', 5, ''),
('<b>View Traffic Links</b>', 6, 'tlinkview.php', 'ON', 6, ''),
('<b>View PTC Links</b>', 7, 'ptcadview.php', 'ON', 7, ''),
('<b>Browse Solo Ads</b>', 8, 'browsesoloads.php', 'ON', 8, ''),
('<b>Browse Admin Emails</b>', 9, 'browseadmincontact.php', 'ON', 9, ''),
('<b>Surf Now </b>', 10, 'surf.php', 'ON', 10, ''),
('<b>Add Surf Pages</b>', 11, 'mysurf.php', 'ON', 11, ''),
('<b>Advertising</b>', 12, 'advertise.php', 'ON', 12, ''),
('<b>Upgrade Account</b>', 13, 'upgrade.php', 'ON', 13, ''),
('<b>Tools & Stats</b>', 14, 'stats.php', 'ON', 14, ''),
('<b>Edit My Details</b>', 15, 'edit.php', 'ON', 15, ''),
('<b>Email My Referrals</b>', 16, 'refmail.php', 'ON', 16, ''),
('<b>Downline Builder</b>', 17, 'builder.php', 'ON', 17, ''),
('<b>Viral Url Cloaker</b>', 18, 'link.php', 'ON', 18, ''),
('<b>Referral Contest</b>', 19, '../contest.php', 'ON', 19, ''),
('<b>Weekly Drawing</b>', 20, 'draw.php', 'OFF', 20, ''),
('<b>Pro Bonuses</b>', 21, 'pro_bonus.php', 'OFF', 21, 'PRO'),
('<b>JV Bonuses</b>', 22, 'jv_bonus.php', 'ON', 22, 'JV Member'),
('<b>Super JV Bonuses</b>', 23, 'jvsuper_bonus.php', 'ON', 23, 'SUPER JV'),
('<b>Prize Rewards</b>', 24, 'prizeinfo.php', 'ON', 24, ''),
('<b>Contact Support</b>', 25, 'support.php', 'ON', 25, ''),
('<b>Delete Account</b>', 26, 'delete.php', 'ON', 26, ''),
('<b>Logout</b>', 27, 'logout.php', 'ON', 27, '');

-- --------------------------------------------------------

--
-- Table structure for table `offerpage`
--

CREATE TABLE IF NOT EXISTS `offerpage` (
  `price` float NOT NULL default '0',
  `points` int(8) NOT NULL default '0',
  `banner_num` int(8) NOT NULL default '0',
  `banner_views` int(8) NOT NULL default '0',
  `solo_num` int(8) NOT NULL default '0',
  `traffic_num` int(8) NOT NULL default '0',
  `traffic_views` int(8) NOT NULL default '0',
  `memtype` varchar(10) NOT NULL default '0',
  `enable` tinyint(4) NOT NULL default '0',
  `upgrade_pro` tinyint(4) NOT NULL default '0',
  `login_num` varchar(15) NOT NULL default '0',
  `login_views` varchar(15) NOT NULL default '0',
  `hotlink_num` int(8) NOT NULL default '0',
  `hotlink_views` int(8) NOT NULL default '0',
  `button_num` int(8) NOT NULL default '0',
  `button_views` int(8) NOT NULL default '0',
  `ptc_num` int(15) NOT NULL default '0',
  `ptc_views` int(15) NOT NULL default '0',
  `topnav_num` int(8) NOT NULL default '0',
  `botnav_num` int(8) NOT NULL default '0',
  `psolo_num` int(8) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `offerpage`
--

INSERT INTO `offerpage` (`price`, `points`, `banner_num`, `banner_views`, `solo_num`, `traffic_num`, `traffic_views`, `memtype`, `enable`, `upgrade_pro`, `login_num`, `login_views`, `hotlink_num`, `hotlink_views`, `button_num`, `button_views`, `ptc_num`, `ptc_views`, `topnav_num`, `botnav_num`, `psolo_num`) VALUES
(9.95, 50000, 4, 1000, 5, 4, 50, 'ALL', 1, 0, '1', '500', 4, 1000, 2, 1000, 1, 50, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `oto`
--

CREATE TABLE IF NOT EXISTS `oto` (
  `price` float NOT NULL default '0',
  `points` int(8) NOT NULL default '0',
  `banner_num` int(8) NOT NULL default '0',
  `banner_views` int(8) NOT NULL default '0',
  `solo_num` int(8) NOT NULL default '0',
  `memtype` varchar(10) NOT NULL default '0',
  `enable` tinyint(4) NOT NULL default '0',
  `traffic_num` int(8) NOT NULL default '0',
  `traffic_views` int(8) NOT NULL default '0',
  `upgrade_pro` tinyint(4) NOT NULL default '0',
  `login_num` varchar(15) NOT NULL default '0',
  `login_views` varchar(15) NOT NULL default '0',
  `hotlink_num` int(8) NOT NULL default '0',
  `hotlink_views` int(8) NOT NULL default '0',
  `button_num` int(8) NOT NULL default '0',
  `button_views` int(8) NOT NULL default '0',
  `ptc_num` int(15) NOT NULL default '0',
  `ptc_views` int(15) NOT NULL default '0',
  `topnav_num` int(8) NOT NULL default '0',
  `botnav_num` int(8) NOT NULL default '0',
  `psolo_num` int(8) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oto`
--

INSERT INTO `oto` (`price`, `points`, `banner_num`, `banner_views`, `solo_num`, `memtype`, `enable`, `traffic_num`, `traffic_views`, `upgrade_pro`, `login_num`, `login_views`, `hotlink_num`, `hotlink_views`, `button_num`, `button_views`, `ptc_num`, `ptc_views`, `topnav_num`, `botnav_num`, `psolo_num`) VALUES
(21, 150000, 10, 5000, 20, '0', 0, 10, 500, 0, '2', '500', 4, 2000, 2, 2000, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `htmlcode` longtext NOT NULL,
  KEY `index` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `htmlcode`) VALUES
(1, 'Index (Main) Page', 'Main Page Content Here'),
(2, 'Members Area Main Page', 'Members Area Content Here'),
(3, 'Advertiser Instructions', 'Advertise Page (displays at top) Content Here'),
(4, 'OTO', 'OTO Content Here'),
(5, 'Offer page', 'Special Offer Content Here'),
(6, 'Referral Contest', 'Referral Contest Content Here'),
(7, 'Downline Builder', 'Downline Builder Content Here'),
(8, 'Drawing', 'Drawing Content Here'),
(9, 'Prizes', 'Prize Information Content Here'),
(10, 'Contest', 'Contest Information Content Here'),
(11, 'Login #1', 'Login Ad Content Here'),
(12, 'Login #2', ''),
(13, 'Login #3', ''),
(14, 'Login #4', ''),
(15, 'Login #5', ''),
(16, 'Login #6', ''),
(17, 'Login #7', ''),
(18, 'Login #8', ''),
(19, 'Login #9', ''),
(20, 'Login #10', ''),
(21, 'Notes', ''),
(22, 'Pro Bonus', 'Pro Bonus Content Here'),
(23, 'JV Bonus', 'JV Bonus Content Here'),
(24, 'SuperJV Bonus', 'Super JV Bonus Content Here');

-- --------------------------------------------------------

--
-- Table structure for table `post`
--

CREATE TABLE IF NOT EXISTS `post` (
  `id` int(11) NOT NULL auto_increment,
  `adbody` longtext NOT NULL,
  `userid` varchar(30) NOT NULL default '',
  `posted` int(15) NOT NULL default '0',
  `url` varchar(255) NOT NULL default '0',
  `saved_id` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `post`
--


-- --------------------------------------------------------

--
-- Table structure for table `post_html`
--

CREATE TABLE IF NOT EXISTS `post_html` (
  `id` int(11) NOT NULL auto_increment,
  `adbody` longtext NOT NULL,
  `userid` varchar(30) NOT NULL default '',
  `posted` int(15) NOT NULL default '0',
  `url` varchar(255) NOT NULL default '0',
  `saved_id` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `post_html`
--


-- --------------------------------------------------------

--
-- Table structure for table `prizes`
--

CREATE TABLE IF NOT EXISTS `prizes` (
  `id` int(15) NOT NULL auto_increment,
  `clicks` int(15) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `solo_num` int(15) NOT NULL default '0',
  `traffic_num` int(15) NOT NULL default '0',
  `traffic_views` int(15) NOT NULL default '0',
  `botnav_num` int(15) NOT NULL default '0',
  `banner_num` int(15) NOT NULL default '0',
  `banner_views` int(15) NOT NULL default '0',
  `points` int(15) NOT NULL default '0',
  `commission` float NOT NULL default '0',
  `hotlink_num` int(15) NOT NULL default '0',
  `hotlink_views` int(15) NOT NULL default '0',
  `login_num` int(15) NOT NULL default '0',
  `login_views` int(15) NOT NULL default '0',
  `button_num` int(15) NOT NULL default '0',
  `button_views` int(15) NOT NULL default '0',
  `ptc_num` int(15) NOT NULL default '0',
  `ptc_views` int(15) NOT NULL default '0',
  `topnav_num` int(15) NOT NULL default '0',
  `psolo_num` int(15) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `prizes`
--

INSERT INTO `prizes` (`id`, `clicks`, `type`, `solo_num`, `traffic_num`, `traffic_views`, `botnav_num`, `banner_num`, `banner_views`, `points`, `commission`, `hotlink_num`, `hotlink_views`, `login_num`, `login_views`, `button_num`, `button_views`, `ptc_num`, `ptc_views`, `topnav_num`, `psolo_num`) VALUES
(1, 10, 'solo', 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `prizes_won`
--

CREATE TABLE IF NOT EXISTS `prizes_won` (
  `userid` varchar(20) NOT NULL default '',
  `won` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prizes_won`
--


-- --------------------------------------------------------

--
-- Table structure for table `prizetrans`
--

CREATE TABLE IF NOT EXISTS `prizetrans` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `action` text NOT NULL,
  `date` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `prizetrans`
--


-- --------------------------------------------------------

--
-- Table structure for table `promo_codes`
--

CREATE TABLE IF NOT EXISTS `promo_codes` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `code` varchar(50) NOT NULL default '',
  `max` int(9) NOT NULL default '0',
  `count` int(9) NOT NULL default '0',
  `points` int(8) NOT NULL default '0',
  `banner_num` int(8) NOT NULL default '0',
  `banner_views` int(8) NOT NULL default '0',
  `solo_num` int(8) NOT NULL default '0',
  `upgrade` varchar(15) NOT NULL default '0',
  `time` int(15) NOT NULL default '0',
  `members` varchar(10) NOT NULL default '',
  `supersolo_num` int(10) NOT NULL default '0',
  `traffic_num` int(8) NOT NULL default '0',
  `traffic_views` int(8) NOT NULL default '0',
  `login_num` varchar(15) NOT NULL default '0',
  `login_views` varchar(15) NOT NULL default '0',
  `hotlink_num` int(15) NOT NULL default '0',
  `hotlink_views` int(15) NOT NULL default '0',
  `button_num` int(15) NOT NULL default '0',
  `button_views` int(15) NOT NULL default '0',
  `ptc_num` int(15) NOT NULL default '0',
  `ptc_views` int(8) NOT NULL default '0',
  `topnav_num` int(8) NOT NULL default '0',
  `botnav_num` int(8) NOT NULL default '0',
  `psolo_num` int(8) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `promo_codes`
--

INSERT INTO `promo_codes` (`id`, `name`, `code`, `max`, `count`, `points`, `banner_num`, `banner_views`, `solo_num`, `upgrade`, `time`, `members`, `supersolo_num`, `traffic_num`, `traffic_views`, `login_num`, `login_views`, `hotlink_num`, `hotlink_views`, `button_num`, `button_views`, `ptc_num`, `ptc_views`, `topnav_num`, `botnav_num`, `psolo_num`) VALUES
(1, '1 Solo', 'traffic', 3000, 635, 500, 1, 500, 4, '0', 1213299319, 'New', 0, 1, 50, '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `promo_used`
--

CREATE TABLE IF NOT EXISTS `promo_used` (
  `promoid` int(9) NOT NULL default '0',
  `userid` varchar(30) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promo_used`
--


-- --------------------------------------------------------

--
-- Table structure for table `ptcads`
--

CREATE TABLE IF NOT EXISTS `ptcads` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `approved` tinyint(4) NOT NULL default '0',
  `subject` varchar(100) default NULL,
  `paid` int(11) NOT NULL default '0',
  `sent` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ptcads`
--


-- --------------------------------------------------------

--
-- Table structure for table `ptcadviews`
--

CREATE TABLE IF NOT EXISTS `ptcadviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `tlid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `tlid` (`tlid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ptcadviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `refmail`
--

CREATE TABLE IF NOT EXISTS `refmail` (
  `userid` varchar(20) NOT NULL default '0',
  `timestamp` int(15) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `refmail`
--


-- --------------------------------------------------------

--
-- Table structure for table `saved_html`
--

CREATE TABLE IF NOT EXISTS `saved_html` (
  `id` int(11) NOT NULL auto_increment,
  `adbody` longtext NOT NULL,
  `userid` varchar(30) NOT NULL default '',
  `url` varchar(255) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `saved_html`
--


-- --------------------------------------------------------

--
-- Table structure for table `saved_post`
--

CREATE TABLE IF NOT EXISTS `saved_post` (
  `id` int(11) NOT NULL auto_increment,
  `adbody` longtext NOT NULL,
  `userid` varchar(30) NOT NULL default '',
  `url` varchar(255) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `saved_post`
--


-- --------------------------------------------------------

--
-- Table structure for table `saved_solos`
--

CREATE TABLE IF NOT EXISTS `saved_solos` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  `adbody` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `saved_solos`
--


-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(30) NOT NULL default '',
  `setting` varchar(125) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`name`, `setting`) VALUES
('row1', 'x'),
('adminid', 'Admin'),
('adminpw', 'admin'),
('adminemail', ''),
('basecolour', '#FFFFCC'),
('contrastcolour', '#C0C0C0'),
('fonttype', 'Verdana'),
('fontcolour', '#00000'),
('domain', 'http://yourdomain.com'),
('sitename', 'Ad Exchange Site'),
('pointrate', ''),
('adminname', ''),
('adminaddress', ''),
('navmax', '3'),
('conteststart', '2009-01-01'),
('paypal', ''),
('alertpay', ''),
('seccode', ''),
('safepay_email', ''),
('safepay_passphrase', ''),
('moneybookers_email', ''),
('moneybookers_id', ''),
('pay_with', 'a:2:{s:6:"paypal";s:1:"1";s:8:"alertpay";s:1:"1";}'),
('drawing', '0'),
('drawwinner', ''),
('drawprice', '25'),
('nav_bg', '#B9D3EE'),
('nav_hover', '#00FF00'),
('nav_text', '#400000'),
('buttondisplay', '10'),
('bannerprice', '3.00'),
('soloprice', '3.00'),
('pointprice', '2.00'),
('navprice', '3.00'),
('hotlinkprice1', '4.00'),
('hotlinkpointprice1', '40000'),
('hotlinkprice2', '5.00'),
('hotlinkpointprice2', '60000'),
('hotlinkprice3', '6.00'),
('hotlinkpointprice3', '80000'),
('buttonpointprice', '10000'),
('buttonprice', '4.00'),
('tlinkprice1', '3.00'),
('tlinkprice2', '4.00'),
('tlinkprice3', '5.00'),
('tlinkpoints1', '10000'),
('tlinkpoints2', '25000'),
('tlinkpoints3', '60000'),
('navpricepoints', '60000'),
('loginpricepoints', '80000'),
('bannerpointprice', '6000'),
('sopointprice', '250000'),
('safprice', '6.00'),
('safpointprice', '100000'),
('adminnotice', '1'),
('supersoloprice', '5.00'),
('loginprice', '5.00'),
('solopointprice', '60000'),
('propoints', '1000'),
('propointsmonthly', '0'),
('prointerval', 'Lifetime'),
('proreadearn', '10'),
('prohtmlearn', '10'),
('probannerearn', '10'),
('proclickearn', '100'),
('protrafficearn', '20'),
('prohotlinkearn', '15'),
('probuttonclick', '10'),
('prosupersoloearn', '200'),
('adminproclickearn', '75'),
('propost', '5'),
('proposthtml', '2'),
('prosave', '5'),
('prosavehtml', '5'),
('prosavesolos', '5'),
('prourls', '1'),
('proreflogin', '5'),
('prorefpoints', '50'),
('procommission', '0'),
('propercent', '0'),
('probuycom', '10'),
('prosupercom', '5.00'),
('projvcom', '2.50'),
('jvpoints', '5000'),
('jvpointsmonthly', '500'),
('jvinterval', 'Lifetime'),
('jvprice', '12.00'),
('jvpointprice', '253000'),
('jvreadearn', '15'),
('jvhtmlearn', '15'),
('jvbannerearn', '20'),
('jvclickearn', '250'),
('jvtrafficearn', '25'),
('jvhotlinkearn', '25'),
('jvbuttonclick', '15'),
('jvsupersoloearn', '400'),
('adminjvclickearn', '150'),
('jvpost', '15'),
('jvposthtml', '7'),
('jvsave', '10'),
('jvsavehtml', '10'),
('jvsavesolos', '15'),
('jvurls', '10'),
('jvreflogin', '15'),
('jvrefpoints', '100'),
('jvcommission', '0'),
('jvpercent', '10'),
('jvbuycom', '25'),
('jvsupercom', '10.00'),
('jvjvcom', '5.00'),
('jvsignup', '0'),
('superjvpoints', '20000'),
('superjvpointsmonthly', '20000'),
('superjvprice', '25.00'),
('superjvinterval', 'Lifetime'),
('superjvpricepoints', '270000'),
('superjvreadearn', '35'),
('superjvhtmlearn', '40'),
('superjvbannerclick', '25'),
('superjvclickearn', '400'),
('superjvtrafficearn', '75'),
('superjvhotlinkearn', '50'),
('superjvbuttonclick', '25'),
('jvssupersoloearn', '650'),
('adminsuperjvclickearn', '200'),
('superjvpost', '25'),
('superjvposthtml', '10'),
('superjvsave', '20'),
('superjvsavehtml', '20'),
('superjvsavesolos', '20'),
('superjvurls', '25'),
('superjvreflogin', '55'),
('superjvrefpoints', '300'),
('superjvcommission', '0'),
('superjvpercent', '25'),
('superjvbuycom', '40'),
('superjvjvcom', '6.00'),
('superjv2supercom', '12.00'),
('proptcearn', '0.0025'),
('jvptcearn', '0.0050'),
('superjvptcearn', '0.01'),
('ptc1points', '50000'),
('ptc2points', '75000'),
('ptc3points', '100000'),
('ptc1', '4.00'),
('ptc2', '5.00'),
('ptc3', '7.00'),
('pronavtopearn', '25'),
('jvnavtopearn', '35'),
('superjvnavtopearn', '75'),
('navtopprice', '5.00'),
('navtoppointprice', '80000'),
('probotnavearn', '20'),
('jvbotnavearn', '30'),
('superjvbotnavearn', '50'),
('prosurfurls', '2'),
('jvsurfurls', '10'),
('superjvsurfurls', '25'),
('prosurfpoint', '25'),
('jvsurfpoint', '50'),
('superjvsurfpoint', '100'),
('topnavmax', '3'),
('linkgood', '5'),
('jvsurfpoint', '50'),
('jvsurfurls', '20'),
('prosurfpoint', '25'),
('prosurfurls', '10'),
('superjvsurfpoint', '75'),
('superjvsurfurls', '30');

-- --------------------------------------------------------

--
-- Table structure for table `solos`
--

CREATE TABLE IF NOT EXISTS `solos` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `approved` tinyint(4) NOT NULL default '0',
  `subject` varchar(100) NOT NULL default '',
  `adbody` longtext NOT NULL,
  `sent` tinyint(4) NOT NULL default '0',
  `datesent` int(15) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `url` varchar(250) NOT NULL default '',
  `date` int(15) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `solos`
--


-- --------------------------------------------------------

--
-- Table structure for table `support`
--

CREATE TABLE IF NOT EXISTS `support` (
  `id` int(11) NOT NULL auto_increment,
  `memberid` varchar(25) default NULL,
  `category` varchar(100) default NULL,
  `subj` varchar(200) default NULL,
  `mesg` text,
  `timesubmitted` datetime default NULL,
  `membertype` varchar(50) default NULL,
  `type` varchar(20) default NULL,
  `origid` int(11) NOT NULL default '0',
  `span` int(11) NOT NULL default '0',
  `ticketstatus` varchar(20) default NULL,
  `replyto` varchar(100) default NULL,
  `lastreply` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `support`
--


-- --------------------------------------------------------

--
-- Table structure for table `surfurls`
--

CREATE TABLE IF NOT EXISTS `surfurls` (
  `id` int(15) NOT NULL auto_increment,
  `userid` varchar(20) collate latin1_general_ci NOT NULL,
  `surfname` varchar(25) collate latin1_general_ci NOT NULL,
  `surfurl` varchar(255) collate latin1_general_ci NOT NULL,
  `surfview` int(15) NOT NULL default '0',
  `surfclicks` int(15) NOT NULL default '0',
  `surfpoint` int(15) NOT NULL default '0',
  `approved` tinyint(1) NOT NULL default '0' COMMENT '0= No, 1= Yes',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Surf URL table' AUTO_INCREMENT=1 ;

--
-- Dumping data for table `surfurls`
--



-- --------------------------------------------------------

--
-- Table structure for table `tlinks`
--

CREATE TABLE IF NOT EXISTS `tlinks` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `approved` tinyint(4) NOT NULL default '0',
  `subject` varchar(100) default NULL,
  `paid` int(11) NOT NULL default '0',
  `sent` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tlinks`
--


-- --------------------------------------------------------

--
-- Table structure for table `tlviews`
--

CREATE TABLE IF NOT EXISTS `tlviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `tlid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `tlid` (`tlid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tlviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `topnav`
--

CREATE TABLE IF NOT EXISTS `topnav` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `targeturl` varchar(70) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `shown` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `added` tinyint(4) NOT NULL default '0',
  `show_views` int(9) NOT NULL default '0',
  `show_clicks` int(9) NOT NULL default '0',
  `date` int(15) NOT NULL default '0',
  KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `topnav`
--


-- --------------------------------------------------------

--
-- Table structure for table `topnavviews`
--

CREATE TABLE IF NOT EXISTS `topnavviews` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(30) NOT NULL default '',
  `blid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `blid` (`blid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `topnavviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `action` text NOT NULL,
  `date` int(15) NOT NULL default '0',
  `quantity` varchar(50) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `userid`, `action`, `date`, `quantity`) VALUES
(1, 'dobee', 'SUPER JV Upgrade', 1295812274, 'Check for Transaction/Coupon');

-- --------------------------------------------------------

--
-- Table structure for table `urls`
--

CREATE TABLE IF NOT EXISTS `urls` (
  `id` int(16) NOT NULL auto_increment,
  `url_location` tinytext NOT NULL,
  `url_tag` tinytext NOT NULL,
  `clicks` int(11) NOT NULL default '0',
  `userid` varchar(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `urls`
--


-- --------------------------------------------------------

--
-- Table structure for table `viewed`
--

CREATE TABLE IF NOT EXISTS `viewed` (
  `id` int(11) NOT NULL auto_increment,
  `postid` int(11) NOT NULL default '0',
  `userid` varchar(30) NOT NULL default '',
  `paid` tinyint(1) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `viewed`
--


-- --------------------------------------------------------

--
-- Table structure for table `viewed_html`
--

CREATE TABLE IF NOT EXISTS `viewed_html` (
  `id` int(11) NOT NULL auto_increment,
  `postid` int(11) NOT NULL default '0',
  `userid` varchar(30) NOT NULL default '',
  `paid` tinyint(1) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `viewed_html`
--
