CREATE TABLE `sites` (
  `siteid` int(11) NOT NULL auto_increment,
  `sitetitle` varchar(100) default NULL,
  `sitedescription` text,
  `info` varchar(255) NOT NULL default '',
  `pic` varchar(255) NOT NULL default '',
  `restriction` varchar(255) NOT NULL default '',
  `siteurl` varchar(100) default NULL,
  `sitedate` varchar(10) default NULL,
  `sponsordate` varchar(50) default NULL,
  `sitecatid` int(11) default NULL,
  `sitehits` int(11) NOT NULL default '0',
  `tclicks` int(11) NOT NULL default '0',
  `total_sp_clicks` int(11) NOT NULL default '0',
  `clicks_purchased` int(11) NOT NULL default '0',
  `totclicks_purchased` int(11) NOT NULL default '0',
  `sites_userid` int(11) default NULL,
  `updatetime` varchar(50) NOT NULL default '',
  `rectype` varchar(50) NOT NULL default '',
  `txn_id` varchar(100) NOT NULL default '',
  `subscr_id` varchar(100) NOT NULL default '',
  `payment_status` varchar(100) NOT NULL default '',
  `_type` varchar(100) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  `sponsor` tinyint(1) NOT NULL default '0',
  `price` varchar(10) NOT NULL default '',
  `invoice` int(11) NOT NULL default '0',
  `acomments` text NOT NULL,
  PRIMARY KEY  (`siteid`),
  FULLTEXT KEY `searchportal` (`sitetitle`,`sitedescription`,`siteurl`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10458 ;

-- 
-- Dumping data for table `sites`
-- 

INSERT INTO `sites` VALUES (428, 'Picture Rotator for AdSense', 'Picture Rotator for AdSenserrnNEW TOOL FOR INCREASE ADSENSE CTRrrn rrnHeres an important AdSense tool, which in some cases has increased click-through (CTR) four-fold and even seven-fold in some cases.rrn rrnAdSense publishers have found that if you place graphics directly above AdSense ads, you attract attention to the ads and increase click-throughs - and revenue.', '', '', '', 'http://hotscripts.com/jump.php?listing_id=51066&jump_type=0', '1166598000', '', 58, 7, 0, 0, 0, 0, 1, '', '', '', '', '', '', 1, 0, '', 0, '');
INSERT INTO `sites` VALUES (427, 'NBS Ads', 'Everyone wants to advertise their site, and this script enables you to easily manage an advertising system and generate some added revenue for your business. With NBS Ads installed on your site, you can increase your services and appeal to a wider range of consumers, making your site alot more professional. You can easily integrate the banners to any part of your site with the code given to you in your admincp. Have as many as you like on as many pages as you like and they will all act independantly random.rrnrrnFeatures Include:rrn? User controlsrrn? Easy banner viewingrrn? Page cut off systemrrn? User banning functions ? Allow multiple admin accountsrrn? Expiry Controlrrn? IP storing and checkingrrn? Verification system', '', '', '', 'http://hotscripts.com/jump.php?listing_id=44307&jump_type=0', '1166598000', '', 58, 6, 0, 0, 0, 0, 1, '', '', '', '', '', '', 1, 0, '', 0, '');
INSERT INTO `sites` VALUES (425, 'AClass Advertising Network', 'Banner Exchange, Traffic Exchange , PopUp exchange ,  Links Exchange !  Script accept PayPal,StormPay,E-gold,MoneyBookers! Start earning money now !!', '', '', '', 'http://hotscripts.com/jump.php?listing_id=41778&jump_type=0', '1166598000', '', 58, 5, 0, 0, 0, 0, 1, '', '', '', '', '', '', 1, 0, '', 0, '');
INSERT INTO `sites` VALUES (426, 'ATM Advertising & Promotion Script', 'ATM Hits is a NEW Advertising PHP Script that was created for the Internet Marketer in mind! There is no other advertising script like it! We have created a unique product that will allow you to offer your online visitors a chance to match a lucky number against the scripts randomly generated number. If a user matches a number he/she will receive 3 prizes that you can setup from the admin area. The prizes will be sent automatically via email. Each time a visitor submits his/her lucky number they will be shown a random website. You can have your site as the default until a user purchases one of your advertising packages. This is really a powerful money making script! You have the option to sell advertising space using Paypal or Clickbank. This can all be handled by the admin through the administrative panel. You can setup 8 texts ads through the admin area and these ads will be displayed in real time on the front page. You can even upload your favorite affiliate banners from the admin...', '', '', '', 'http://hotscripts.com/jump.php?listing_id=46891&jump_type=0', '1166598000', '', 58, 6, 0, 0, 0, 0, 1, '', '', '', '', '', '', 1, 0, '', 0, '');
INSERT INTO `sites` VALUES (424, 'QuickPop', 'QuickPop is a single php script that allows you to create unblock-able pop ups simply by specifying a HTML file.', '', '', '', 'http://hotscripts.com/jump.php?listing_id=62839&jump_type=0', '1166598000', '', 58, 6, 0, 0, 0, 0, 1, '', '', '', '', '', '', 1, 0, '', 0, '');