--
-- Host: classyweb.biz    Database: classywe_db
-- ------------------------------------------------------


--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
--

--
-- Table structure for table `directory_save_data`
--

CREATE TABLE `directory_save_data` (
  `id` bigint(100) NOT NULL auto_increment,
  `schedule_id` bigint(100) NOT NULL,
  `project_id` bigint(100) NOT NULL,
  `link_id` bigint(100) NOT NULL,
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directory_save_data`
--


--
-- Table structure for table `idx_admin_menu`
--

CREATE TABLE `idx_admin_menu` (
  `menu_id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `menu_title` varchar(255) default NULL,
  `menu_url` varchar(255) default NULL,
  `order_number` int(11) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_admin_menu`
--



--
-- Table structure for table `idx_bad_link`
--

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(9) unsigned NOT NULL auto_increment,
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_bad_link`
--


--
-- Table structure for table `idx_badwords`
--

CREATE TABLE `idx_badwords` (
  `word` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_badwords`
--


--
-- Table structure for table `idx_blocked_domain`
--

CREATE TABLE `idx_blocked_domain` (
  `blocked_id` int(11) NOT NULL auto_increment,
  `blocked` varchar(255) default NULL,
  `type` enum('domain','ip') default NULL,
  PRIMARY KEY  (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_blocked_domain`
--

INSERT INTO `idx_blocked_domain` VALUES (1,'buydomains.com','domain'),(2,'this-domain-for-sale.com ','domain'),(3,'oversee.net','domain'),(4,'eNom','domain'),(5,'sedoparking.com','domain');

--
-- Table structure for table `idx_category`
--

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(9) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `image` varchar(100) default NULL,
  `content` text,
  `visible` char(1) default NULL,
  `links` mediumint(9) default NULL,
  `meta_keyword` text,
  `meta_description` text,
  `permission` char(2) default NULL,
  `registered_only` char(1) default NULL,
  `header` text NOT NULL,
  `footer` text NOT NULL,
  `related` mediumint(6) NOT NULL default '0',
  `page_title` varchar(200) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `order_num` smallint(6) NOT NULL default '0',
  `basic_price` double unsigned NOT NULL default '0',
  `premium_price` double unsigned NOT NULL default '0',
  `sponsored_price` double unsigned NOT NULL default '0',
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category`
--

INSERT INTO `idx_category` VALUES (1,0,'Arts Gallery & Entertainment','','folder.gif','','1',21,'','','0','0','','',0,'',3,0,0,0,0),(2,0,'Automobiles','','folder.gif','','1',52,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Business & Investment','','folder.gif','','1',176,'','','0','0','','',0,'',2,0,0,0,0),(4,0,'Careers & Recruitment','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Designers','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Communication','','folder.gif','','1',19,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Computers','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Maintenance','','folder.gif','','1',89,'','','0','0','','',0,'',1,0,0,0,0),(9,0,'Dental','','folder.gif','','1',59,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Education','','folder.gif','','1',30,'','','0','0','','',0,'',1,0,0,0,0),(11,0,'Employment','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Gifts','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software','','folder.gif','','1',13,'','','0','0','','',0,'',1,0,0,0,0),(14,0,'Health & fitness','','folder.gif','','1',4,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare','','folder.gif','','1',199,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Heating and Air Conditioning','','folder.gif','','1',81,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home & Garden','','folder.gif','','1',206,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement','','folder.gif','','1',131,'','','0','0','','',0,'',1,0,0,0,0),(19,0,'Hotels & Motels','','folder.gif','','1',88,'','','0','0','','',0,'',1,0,0,0,0),(20,0,'Insurance','','folder.gif','','1',31,'','','0','0','','',0,'',0,0,0,0,0),(21,0,'Law & Politics','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers','','folder.gif','','1',207,'','','0','0','','',0,'',1,0,0,0,0),(23,0,'Lifestyle & Relationships','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Medicine','','folder.gif','','1',14,'','','0','0','','',0,'',1,0,0,0,0),(25,0,'Money & Finance','','folder.gif','','1',22,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'News & Issues','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing','','folder.gif','','1',41,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate','','folder.gif','','1',44,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Science & Technology','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO','','folder.gif','','1',26,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',78,'','','0','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',61,'','','0','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',27,'','','0','0','','',0,'',3,0,0,0,0),(35,0,'Wedding','','folder.gif','','1',8,'','','0','0','','',0,'',0,0,0,0,0);

--
-- Table structure for table `idx_category_path`
--

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL default '0',
  `path` text,
  `path_with_url` text,
  `parents` text,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_path`
--

INSERT INTO `idx_category_path` VALUES (1,'Arts Gallery & Entertainment','<a href=\"http://classyweb.biz/arts-gallery-entertainment/\" name=\"cat_1\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(2,'Automobiles','<a href=\"http://classyweb.biz/automobiles/\" name=\"cat_2\" style=\"\">Automobiles</a>',';0;'),(3,'Business & Investment','<a href=\"http://classyweb.biz/business-investment/\" name=\"cat_3\" style=\"\">Business & Investment</a>',';0;'),(4,'Careers & Recruitment','<a href=\"http://classyweb.biz/careers-recruitment/\" name=\"cat_4\" style=\"\">Careers & Recruitment</a>',';0;'),(5,'Clothing & Designers','<a href=\"http://classyweb.biz/clothing-designers/\" name=\"cat_5\" style=\"\">Clothing & Designers</a>',';0;'),(6,'Communication','<a href=\"http://classyweb.biz/communication/\" name=\"cat_6\" style=\"\">Communication</a>',';0;'),(7,'Computers','<a href=\"http://classyweb.biz/computers/\" name=\"cat_7\" style=\"\">Computers</a>',';0;'),(8,'Construction and Maintenance','<a href=\"http://classyweb.biz/construction-and-maintenance/\" name=\"cat_8\" style=\"\">Construction and Maintenance</a>',';0;'),(9,'Dental','<a href=\"http://classyweb.biz/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Education','<a href=\"http://classyweb.biz/education/\" name=\"cat_10\" style=\"\">Education</a>',';0;'),(11,'Employment','<a href=\"http://classyweb.biz/employment/\" name=\"cat_11\" style=\"\">Employment</a>',';0;'),(12,'Gifts','<a href=\"http://classyweb.biz/gifts/\" name=\"cat_12\" style=\"\">Gifts</a>',';0;'),(13,'Hardware & Software','<a href=\"http://classyweb.biz/hardware-software/\" name=\"cat_13\" style=\"\">Hardware & Software</a>',';0;'),(14,'Health & fitness','<a href=\"http://classyweb.biz/health-fitness/\" name=\"cat_14\" style=\"\">Health & fitness</a>',';0;'),(15,'Healthcare','<a href=\"http://classyweb.biz/healthcare/\" name=\"cat_15\" style=\"\">Healthcare</a>',';0;'),(16,'Heating and Air Conditioning','<a href=\"http://classyweb.biz/heating-and-air-conditioning/\" name=\"cat_16\" style=\"\">Heating and Air Conditioning</a>',';0;'),(17,'Home & Garden','<a href=\"http://classyweb.biz/home-garden/\" name=\"cat_17\" style=\"\">Home & Garden</a>',';0;'),(18,'Home Improvement','<a href=\"http://classyweb.biz/home-improvement/\" name=\"cat_18\" style=\"\">Home Improvement</a>',';0;'),(19,'Hotels & Motels','<a href=\"http://classyweb.biz/hotels-motels/\" name=\"cat_19\" style=\"\">Hotels & Motels</a>',';0;'),(20,'Insurance','<a href=\"http://classyweb.biz/insurance/\" name=\"cat_20\" style=\"\">Insurance</a>',';0;'),(21,'Law & Politics','<a href=\"http://classyweb.biz/law-politics/\" name=\"cat_21\" style=\"\">Law & Politics</a>',';0;'),(22,'Lawyers','<a href=\"http://classyweb.biz/lawyers/\" name=\"cat_22\" style=\"\">Lawyers</a>',';0;'),(23,'Lifestyle & Relationships','<a href=\"http://classyweb.biz/lifestyle-relationships/\" name=\"cat_23\" style=\"\">Lifestyle & Relationships</a>',';0;'),(24,'Medicine','<a href=\"http://classyweb.biz/medicine/\" name=\"cat_24\" style=\"\">Medicine</a>',';0;'),(25,'Money & Finance','<a href=\"http://classyweb.biz/money-finance/\" name=\"cat_25\" style=\"\">Money & Finance</a>',';0;'),(26,'News & Issues','<a href=\"http://classyweb.biz/news-issues/\" name=\"cat_26\" style=\"\">News & Issues</a>',';0;'),(27,'Plumbing','<a href=\"http://classyweb.biz/plumbing/\" name=\"cat_27\" style=\"\">Plumbing</a>',';0;'),(28,'Real Estate','<a href=\"http://classyweb.biz/real-estate/\" name=\"cat_28\" style=\"\">Real Estate</a>',';0;'),(29,'Science & Technology','<a href=\"http://classyweb.biz/science-technology/\" name=\"cat_29\" style=\"\">Science & Technology</a>',';0;'),(30,'SEO & SMO','<a href=\"http://classyweb.biz/seo-smo/\" name=\"cat_30\" style=\"\">SEO & SMO</a>',';0;'),(31,'Shopping','<a href=\"http://classyweb.biz/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://classyweb.biz/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://classyweb.biz/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://classyweb.biz/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://classyweb.biz/wedding/\" name=\"cat_35\" style=\"\">Wedding</a>',';0;');

--
-- Table structure for table `idx_category_suggession`
--

CREATE TABLE `idx_category_suggession` (
  `id_cat_suggession` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `name` varchar(255) default NULL,
  `category_description` text,
  `date` datetime default NULL,
  PRIMARY KEY  (`id_cat_suggession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_category_suggession`
--


--
-- Table structure for table `idx_checkurl`
--

CREATE TABLE `idx_checkurl` (
  `link_id` mediumint(9) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `live` char(1) NOT NULL default '',
  `reciprocal_found` char(1) NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_checkurl`
--


--
-- Table structure for table `idx_cronjobs`
--

CREATE TABLE `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL auto_increment,
  `cronjobs_name` varchar(255) default NULL,
  `filename` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) NOT NULL,
  PRIMARY KEY  (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_cronjobs`
--

INSERT INTO `idx_cronjobs` VALUES (1,NULL,'clear_templates_c.php','1,*,*,*,*','0000-00-00 00:00:00',''),(2,NULL,'update_tag_cloud.php','*,24,*,*,*','0000-00-00 00:00:00',''),(3,NULL,'clear_rss_cache.php','*,24,*,*,*','0000-00-00 00:00:00','');

--
-- Table structure for table `idx_custom_field`
--

CREATE TABLE `idx_custom_field` (
  `field_name` varchar(32) NOT NULL default '',
  `field_text` varchar(64) NOT NULL default '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') NOT NULL default 'TEXT',
  `field_option` text NOT NULL,
  `field_img_width` int(10) unsigned NOT NULL default '0',
  `field_img_height` int(10) unsigned NOT NULL default '0',
  `field_file_size` int(10) unsigned NOT NULL default '0',
  `field_file_extension` varchar(64) NOT NULL default '',
  `required` char(1) NOT NULL default '0',
  `searchable` char(1) NOT NULL default '1',
  `permission` char(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_custom_field`
--

INSERT INTO `idx_custom_field` VALUES ('image','Image','IMAGE','',0,0,0,'','0','0','2'),('address','Address','TEXT','',0,0,0,'','0','0','0'),('city','City','TEXT','',0,0,0,'','0','0','0'),('state','State','TEXT','',0,0,0,'','0','0','0'),('country','Country','TEXT','',0,0,0,'','0','0','0'),('zip','Zip','TEXT','',0,0,0,'','0','0','0'),('phone','Phone','TEXT','',0,0,0,'','0','0','0'),('fax','Fax','TEXT','',0,0,0,'','0','0','0');

--
-- Table structure for table `idx_default_field`
--

CREATE TABLE `idx_default_field` (
  `field_name` varchar(64) NOT NULL,
  `required` char(1) NOT NULL,
  `visible` char(1) NOT NULL default '1',
  `searchable` char(1) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_default_field`
--

INSERT INTO `idx_default_field` VALUES ('title','1','1','1'),('url','1','1','1'),('description','1','1','1'),('keywords','1','1','0'),('contact_name','1','1','1'),('email','1','1','1'),('reciprocal_url','0','0','1');

--
-- Table structure for table `idx_discount_coupon`
--

CREATE TABLE `idx_discount_coupon` (
  `coupon_id` int(11) NOT NULL auto_increment,
  `coupon_code` varchar(255) default NULL,
  `coupon_value` varchar(50) default NULL,
  `link_type` varchar(255) default NULL,
  `start_date` date default NULL,
  `expired_date` date default NULL,
  `expired_usage` int(11) default NULL,
  `usage_count` int(11) default NULL,
  PRIMARY KEY  (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_discount_coupon`
--


--
-- Table structure for table `idx_editor`
--

CREATE TABLE `idx_editor` (
  `username` varchar(20) default NULL,
  `category_id` mediumint(9) default NULL,
  `category` char(1) default NULL,
  `link` char(1) default NULL,
  `review` char(1) default NULL,
  `pick` char(1) default NULL,
  `status` char(1) default NULL,
  `date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_editor`
--


--
-- Table structure for table `idx_email_template`
--

CREATE TABLE `idx_email_template` (
  `email_template_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `subject` varchar(255) default NULL,
  `body` text,
  `altbody` text,
  PRIMARY KEY  (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_email_template`
--



--
-- Table structure for table `idx_favorites`
--

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `date` date default NULL,
  `title` varchar(100) default NULL,
  `description` text,
  PRIMARY KEY  (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites`
--

INSERT INTO `idx_favorites` VALUES (1,'adaptive84','2011-12-07','My Favorites',NULL);

--
-- Table structure for table `idx_favorites_detail`
--

CREATE TABLE `idx_favorites_detail` (
  `favorite_id` int(11) default NULL,
  `link_id` mediumint(9) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_favorites_detail`
--


--
-- Table structure for table `idx_hook_place`
--

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `hookname` varchar(255) default NULL,
  PRIMARY KEY  (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_hook_place`
--


--
-- Table structure for table `idx_invoice`
--

CREATE TABLE `idx_invoice` (
  `invoice_id` varchar(10) NOT NULL default '',
  `invoice_date` date default NULL,
  `due_date` date default NULL,
  `invoiced_to` text,
  `service` varchar(255) default NULL,
  `description` text,
  `total` double(8,2) default NULL,
  `comment` text,
  `paid` char(1) default NULL,
  `paid_date` date default NULL,
  `email` varchar(255) default NULL,
  PRIMARY KEY  (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice`
--


--
-- Table structure for table `idx_invoice_config`
--

CREATE TABLE `idx_invoice_config` (
  `company` varchar(255) default NULL,
  `contact` varchar(255) default NULL,
  `address` text,
  `phone` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `currency_symbol` varchar(255) default '$',
  `currency_code` varchar(255) default 'USD'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_invoice_config`
--

INSERT INTO `idx_invoice_config` VALUES ('Your website / Company','Billing Department','Your address','Your phone #','Billing<name@yourdomain.com>','$','USD');

--
-- Table structure for table `idx_link_temp`
--

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL auto_increment,
  `spam` char(1) NOT NULL default '0',
  `link_id` mediumint(9) default NULL,
  `category_id` mediumint(9) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` text NOT NULL,
  `description` text NOT NULL,
  `contact_name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `hits` mediumint(9) default NULL,
  `votes` smallint(6) default NULL,
  `rating` float(4,2) default NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `bid` smallint(6) NOT NULL default '0',
  `new` char(1) default NULL,
  `hot` char(1) default NULL,
  `top_rated` char(1) default NULL,
  `pick` char(1) default NULL,
  `password` varchar(20) default NULL,
  `updated` char(1) default NULL,
  `reviews` smallint(6) default NULL,
  `avg_review` float(4,2) default NULL,
  `last_updated` datetime default NULL,
  `official_review` text,
  `keywords` varchar(255) default NULL,
  `cat1` mediumint(6) NOT NULL default '0',
  `cat2` mediumint(6) NOT NULL default '0',
  `suspended` char(1) NOT NULL default '0',
  `reciprocal_url` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `image` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp`
--


--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_temp_user`
--


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_link_user`
--


--
-- Table structure for table `idx_mailing_list`
--

CREATE TABLE `idx_mailing_list` (
  `email` varchar(50) NOT NULL default '',
  `code` varchar(4) default NULL,
  `status` char(1) default NULL,
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL auto_increment,
  `date` date default NULL,
  `body` text,
  `subject` varchar(100) default NULL,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_message`
--


--
-- Table structure for table `idx_notification`
--

CREATE TABLE `idx_notification` (
  `username` varchar(20) NOT NULL default '',
  `category_id` mediumint(9) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_notification`
--


--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL default '0',
  `engine` char(1) NOT NULL default '',
  `rank` tinyint(4) NOT NULL default '0',
  `last_update` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pagerank`
--

INSERT INTO `idx_pagerank` VALUES (2,'g',0,'2012-02-16'),(3,'g',0,'2012-01-22'),(1,'g',0,'2012-02-23'),(4,'g',0,'2011-10-12'),(5,'g',0,'2011-10-12'),(6,'g',0,'2011-10-12'),(7,'g',0,'2011-10-12'),(680,'g',0,'2011-12-08'),(885,'g',0,'2011-12-08'),(795,'g',0,'2011-12-06'),(2197,'g',0,'2011-12-08'),(761,'g',0,'2011-12-08'),(694,'g',0,'2011-12-06'),(1541,'g',0,'2011-12-08'),(1978,'g',0,'2011-12-07'),(684,'g',0,'2011-12-06'),(1780,'g',0,'2011-12-06'),(62,'g',0,'2011-10-31'),(63,'g',0,'2011-11-04'),(66,'g',0,'2011-12-27'),(862,'g',0,'2011-12-05'),(784,'g',0,'2011-12-05'),(686,'g',0,'2011-12-05'),(1124,'g',0,'2011-12-05'),(785,'g',0,'2011-12-05'),(1342,'g',0,'2011-12-05'),(679,'g',0,'2011-12-05'),(828,'g',0,'2011-12-05'),(806,'g',0,'2011-12-05'),(817,'g',0,'2011-12-05'),(75,'g',0,'2012-02-08'),(68,'g',0,'2012-01-25'),(79,'g',0,'2012-01-24'),(9,'g',1,'2011-09-27'),(10,'g',3,'2011-09-27'),(11,'g',4,'2011-09-27'),(51,'g',6,'2011-09-27'),(53,'g',0,'2011-09-27'),(64,'g',0,'2011-09-27'),(85,'g',0,'2012-01-12'),(86,'g',0,'2012-01-19'),(111,'g',0,'2012-02-22'),(174,'g',0,'2012-02-16'),(132,'g',0,'2012-02-15'),(173,'g',0,'2012-03-05'),(137,'g',0,'2012-02-15'),(149,'g',0,'2011-12-24'),(116,'g',0,'2012-01-25'),(169,'g',0,'2012-02-06'),(166,'g',0,'2011-10-04'),(129,'g',0,'2012-01-10'),(133,'g',0,'2012-01-04'),(144,'g',0,'2012-01-25'),(162,'g',0,'2012-02-06'),(84,'g',0,'2012-02-15'),(83,'g',0,'2012-02-15'),(8,'g',0,'2011-11-21'),(87,'g',0,'2012-01-25'),(125,'g',0,'2012-01-23'),(88,'g',0,'2011-11-22'),(152,'g',0,'2012-02-15'),(158,'g',0,'2012-01-24'),(91,'g',0,'2012-01-05'),(130,'g',0,'2012-02-16'),(138,'g',0,'2012-02-15'),(76,'g',0,'2012-02-04'),(157,'g',0,'2011-12-27'),(136,'g',0,'2011-10-04'),(134,'g',0,'2012-02-15'),(160,'g',0,'2012-03-05'),(176,'g',0,'2012-01-19'),(92,'g',0,'2012-02-04'),(80,'g',0,'2012-01-05'),(117,'g',0,'2012-02-18'),(177,'g',0,'2011-12-27'),(147,'g',0,'2012-02-27'),(81,'g',0,'2012-02-08'),(139,'g',0,'2012-02-08'),(114,'g',0,'2012-03-05'),(148,'g',0,'2012-03-05'),(143,'g',0,'2012-02-29'),(135,'g',0,'2012-01-23'),(167,'g',3,'2011-10-05'),(154,'g',0,'2011-12-24'),(127,'g',0,'2012-02-16'),(89,'g',0,'2011-12-27'),(156,'g',0,'2012-02-21'),(72,'g',0,'2012-02-08'),(175,'g',0,'2012-03-05'),(112,'g',0,'2011-12-27'),(95,'g',0,'2012-01-10'),(70,'g',0,'2012-02-21'),(65,'g',0,'2011-12-24'),(90,'g',0,'2011-12-27'),(141,'g',0,'2012-02-27'),(153,'g',0,'2011-12-24'),(151,'g',0,'2012-02-10'),(13,'g',0,'2011-12-27'),(82,'g',0,'2012-02-08'),(124,'g',0,'2012-02-18'),(69,'g',0,'2012-02-08'),(142,'g',0,'2012-01-10'),(150,'g',0,'2012-01-10'),(168,'g',0,'2011-10-05'),(159,'g',0,'2012-02-22'),(73,'g',0,'2012-02-08'),(12,'g',0,'2012-02-08'),(71,'g',0,'2012-01-26'),(164,'g',0,'2011-12-27'),(146,'g',0,'2012-01-10'),(93,'g',0,'2012-02-08'),(128,'g',0,'2012-01-24'),(145,'g',0,'2012-02-15'),(74,'g',0,'2012-01-21'),(165,'g',0,'2012-01-11'),(67,'g',0,'2012-01-15'),(118,'g',0,'2012-02-16'),(123,'g',0,'2012-02-16'),(171,'g',0,'2011-10-06'),(170,'g',0,'2012-02-24'),(155,'g',0,'2011-10-06'),(15,'g',0,'2012-01-25'),(342,'g',0,'2012-02-26'),(411,'g',0,'2012-02-26'),(283,'g',0,'2012-02-26'),(243,'g',0,'2011-12-24'),(224,'g',0,'2011-12-24'),(206,'g',0,'2011-12-24'),(191,'g',0,'2011-12-24'),(466,'g',0,'2011-12-24'),(179,'g',0,'2012-01-07'),(238,'g',0,'2011-12-24'),(468,'g',0,'2011-12-24'),(199,'g',0,'2011-12-24'),(231,'g',0,'2011-11-22'),(185,'g',0,'2011-12-27'),(178,'g',0,'2012-02-27'),(303,'g',0,'2011-12-24'),(213,'g',0,'2012-01-26'),(239,'g',0,'2011-12-27'),(293,'g',0,'2011-11-22'),(255,'g',0,'2011-10-07'),(198,'g',0,'2012-01-22'),(207,'g',0,'2012-01-24'),(291,'g',0,'2011-11-22'),(210,'g',0,'2011-11-22'),(296,'g',0,'2012-01-22'),(241,'g',0,'2012-02-27'),(209,'g',0,'2012-02-16'),(195,'g',0,'2012-02-21'),(187,'g',0,'2012-03-05'),(184,'g',0,'2012-03-05'),(182,'g',0,'2012-03-05'),(189,'g',0,'2012-03-05'),(316,'g',0,'2012-01-20'),(308,'g',0,'2012-01-09'),(463,'g',0,'2012-01-09'),(265,'g',0,'2012-01-09'),(307,'g',0,'2012-01-10'),(309,'g',0,'2012-02-16'),(193,'g',0,'2012-02-27'),(457,'g',0,'2012-01-09'),(314,'g',0,'2012-01-10'),(461,'g',0,'2011-10-08'),(305,'g',0,'2011-10-08'),(471,'g',0,'2012-01-21'),(317,'g',0,'2011-10-09'),(96,'g',0,'2011-12-12'),(99,'g',0,'2012-01-22'),(97,'g',0,'2012-01-23'),(98,'g',0,'2012-01-20'),(103,'g',0,'2011-12-12'),(100,'g',0,'2012-02-26'),(101,'g',0,'2012-01-11'),(102,'g',0,'2011-12-12'),(215,'g',0,'2011-12-27'),(445,'g',0,'2011-12-27'),(194,'g',0,'2011-12-27'),(236,'g',0,'2012-02-22'),(181,'g',0,'2012-01-25'),(197,'g',0,'2012-01-21'),(180,'g',0,'2012-02-04'),(208,'g',0,'2012-02-04'),(225,'g',0,'2012-01-20'),(475,'g',0,'2011-10-11'),(226,'g',0,'2012-01-24'),(214,'g',0,'2012-02-25'),(495,'g',0,'2011-10-12'),(183,'g',0,'2011-10-12'),(498,'g',0,'2012-01-07'),(485,'g',0,'2012-02-01'),(601,'g',0,'2012-02-01'),(489,'g',0,'2011-10-12'),(482,'g',0,'2011-12-27'),(202,'g',0,'2012-02-06'),(525,'g',0,'2011-12-27'),(502,'g',0,'2012-02-06'),(529,'g',0,'2012-02-19'),(521,'g',0,'2012-02-06'),(595,'g',0,'2011-12-27'),(522,'g',0,'2012-02-06'),(523,'g',0,'2012-01-07'),(589,'g',0,'2012-02-29'),(491,'g',0,'2011-10-12'),(534,'g',0,'2011-10-12'),(539,'g',0,'2011-12-24'),(512,'g',0,'2011-12-24'),(470,'g',0,'2012-01-24'),(467,'g',0,'2011-10-12'),(550,'g',0,'2011-10-12'),(580,'g',0,'2012-01-25'),(519,'g',0,'2012-01-25'),(586,'g',0,'2011-12-24'),(480,'g',0,'2012-01-22'),(592,'g',0,'2012-01-23'),(479,'g',0,'2011-12-02'),(602,'g',0,'2012-02-16'),(603,'g',0,'2012-02-16'),(583,'g',0,'2012-01-23'),(604,'g',0,'2012-02-16'),(598,'g',0,'2012-01-19'),(599,'g',0,'2011-10-12'),(547,'g',0,'2012-02-27'),(557,'g',0,'2012-02-27'),(560,'g',0,'2012-02-27'),(78,'g',0,'2011-10-12'),(119,'g',0,'2011-10-12'),(120,'g',0,'2011-10-12'),(564,'g',0,'2012-01-24'),(161,'g',0,'2012-01-17'),(172,'g',0,'2012-01-17'),(203,'g',0,'2012-01-17'),(218,'g',0,'2012-01-17'),(234,'g',0,'2012-01-17'),(237,'g',0,'2012-01-17'),(267,'g',0,'2012-01-17'),(458,'g',0,'2011-11-11'),(460,'g',0,'2012-03-01'),(532,'g',0,'2011-11-11'),(546,'g',0,'2011-11-11'),(563,'g',0,'2011-11-11'),(593,'g',0,'2011-11-11'),(597,'g',0,'2011-11-11'),(140,'g',0,'2012-01-04'),(451,'g',0,'2012-01-04'),(459,'g',0,'2012-01-04'),(104,'g',0,'2012-02-20'),(105,'g',0,'2011-10-12'),(494,'g',0,'2012-01-04'),(106,'g',0,'2011-10-12'),(107,'g',0,'2011-10-12'),(531,'g',0,'2012-01-04'),(108,'g',0,'2011-10-12'),(109,'g',0,'2011-10-12'),(542,'g',0,'2012-01-04'),(576,'g',0,'2012-01-04'),(110,'g',0,'2011-10-12'),(115,'g',0,'2011-10-12'),(122,'g',0,'2011-10-12'),(518,'g',0,'2011-12-27'),(201,'g',0,'2012-01-28'),(211,'g',0,'2012-01-28'),(216,'g',0,'2012-01-28'),(221,'g',0,'2012-01-28'),(272,'g',0,'2012-01-28'),(298,'g',0,'2012-01-28'),(453,'g',0,'2012-01-28'),(465,'g',0,'2012-01-28'),(567,'g',0,'2011-12-08'),(575,'g',0,'2011-12-08'),(579,'g',0,'2011-12-08'),(582,'g',0,'2011-12-08'),(481,'g',0,'2012-01-28'),(496,'g',0,'2012-01-28'),(506,'g',0,'2012-01-28'),(499,'g',0,'2012-01-28'),(537,'g',0,'2012-01-28'),(541,'g',0,'2012-01-28'),(553,'g',0,'2012-01-28'),(566,'g',0,'2011-10-12'),(227,'g',0,'2011-10-12'),(266,'g',0,'2011-10-12'),(242,'g',0,'2011-12-27'),(486,'g',0,'2011-12-27'),(509,'g',0,'2011-12-27'),(505,'g',0,'2012-01-24'),(530,'g',0,'2011-10-12'),(533,'g',0,'2011-10-12'),(572,'g',0,'2012-01-17'),(789,'g',0,'2011-12-05'),(798,'g',0,'2011-12-05'),(639,'g',0,'2011-12-03'),(520,'g',0,'2011-12-24'),(619,'g',0,'2011-12-03'),(1149,'g',0,'2011-12-03'),(793,'g',0,'2011-12-03'),(540,'g',0,'2011-12-24'),(1609,'g',0,'2011-12-02'),(951,'g',0,'2011-12-02'),(693,'g',0,'2011-12-03'),(1191,'g',0,'2011-12-03'),(953,'g',0,'2011-12-02'),(1183,'g',0,'2011-12-03'),(1607,'g',0,'2011-12-02'),(1111,'g',0,'2011-12-03'),(77,'g',0,'2011-12-24'),(1180,'g',0,'2011-12-03'),(1187,'g',0,'2011-12-03'),(126,'g',0,'2011-12-24'),(1120,'g',0,'2011-12-03'),(548,'g',0,'2011-12-24'),(1135,'g',0,'2011-12-03'),(788,'g',0,'2011-12-03'),(565,'g',0,'2012-01-28'),(192,'g',0,'2011-10-12'),(196,'g',0,'2011-10-12'),(217,'g',0,'2011-10-12'),(219,'g',0,'2011-10-12'),(222,'g',0,'2011-10-12'),(233,'g',0,'2011-12-27'),(223,'g',0,'2011-10-12'),(488,'g',0,'2012-01-10'),(240,'g',0,'2011-10-12'),(244,'g',0,'2011-12-27'),(246,'g',0,'2012-02-26'),(559,'g',0,'2012-01-21'),(248,'g',0,'2012-02-26'),(247,'g',0,'2012-02-26'),(249,'g',0,'2012-02-27'),(250,'g',0,'2012-02-26'),(121,'g',0,'2011-10-12'),(251,'g',0,'2012-02-26'),(264,'g',0,'2011-10-12'),(163,'g',0,'2012-01-17'),(269,'g',0,'2011-10-12'),(270,'g',0,'2011-10-12'),(230,'g',0,'2012-01-17'),(273,'g',0,'2011-10-12'),(280,'g',0,'2011-10-12'),(312,'g',0,'2012-03-01'),(275,'g',0,'2011-10-12'),(503,'g',0,'2011-11-11'),(131,'g',0,'2012-01-04'),(276,'g',0,'2011-10-12'),(292,'g',0,'2011-10-12'),(282,'g',0,'2011-10-12'),(294,'g',0,'2011-10-12'),(483,'g',0,'2012-01-04'),(257,'g',0,'2011-10-12'),(277,'g',0,'2011-10-12'),(500,'g',0,'2012-01-04'),(295,'g',0,'2011-10-12'),(258,'g',0,'2011-10-12'),(278,'g',0,'2011-10-12'),(284,'g',0,'2011-10-12'),(259,'g',0,'2011-10-12'),(113,'g',0,'2011-10-12'),(279,'g',0,'2011-10-12'),(513,'g',0,'2011-12-24'),(587,'g',0,'2012-02-01'),(260,'g',0,'2011-10-12'),(286,'g',0,'2011-10-12'),(205,'g',0,'2012-01-28'),(261,'g',0,'2011-10-12'),(287,'g',0,'2011-10-12'),(288,'g',0,'2012-01-28'),(304,'g',0,'2011-10-12'),(262,'g',0,'2011-10-12'),(306,'g',0,'2011-10-12'),(289,'g',0,'2011-10-12'),(263,'g',0,'2011-10-12'),(551,'g',0,'2012-01-28'),(558,'g',0,'2012-01-28'),(327,'g',0,'2012-02-26'),(329,'g',0,'2012-02-26'),(328,'g',0,'2012-02-26'),(462,'g',0,'2011-10-12'),(331,'g',0,'2011-10-12'),(332,'g',0,'2011-10-12'),(333,'g',0,'2011-10-12'),(497,'g',0,'2011-10-12'),(336,'g',0,'2011-10-12'),(510,'g',0,'2011-12-27'),(517,'g',0,'2011-10-12'),(338,'g',0,'2011-10-12'),(335,'g',0,'2011-10-12'),(339,'g',0,'2011-10-12'),(340,'g',0,'2011-10-12'),(341,'g',0,'2011-10-12'),(344,'g',0,'2012-02-29'),(860,'g',0,'2011-12-05'),(814,'g',0,'2011-12-05'),(345,'g',0,'2012-02-29'),(315,'g',0,'2011-10-12'),(1199,'g',0,'2011-12-03'),(318,'g',0,'2011-10-12'),(1114,'g',0,'2011-12-03'),(321,'g',0,'2012-02-26'),(322,'g',0,'2012-02-26'),(323,'g',0,'2012-02-26'),(325,'g',0,'2012-02-26'),(324,'g',0,'2012-02-27'),(571,'g',0,'2011-12-16'),(186,'g',0,'2012-02-26'),(94,'g',0,'2012-01-24'),(204,'g',0,'2012-02-26'),(212,'g',0,'2012-02-26'),(220,'g',0,'2012-02-26'),(228,'g',0,'2012-02-26'),(229,'g',0,'2011-10-12'),(758,'g',0,'2011-12-03'),(299,'g',0,'2012-02-26'),(555,'g',0,'2011-12-24'),(232,'g',0,'2012-02-26'),(695,'g',0,'2011-12-03'),(235,'g',0,'2011-10-12'),(188,'g',0,'2011-12-12'),(446,'g',0,'2012-02-26'),(268,'g',0,'2012-02-26'),(190,'g',0,'2012-02-18'),(448,'g',0,'2011-10-12'),(449,'g',0,'2011-10-12'),(455,'g',0,'2012-02-27'),(200,'g',0,'2011-10-12'),(464,'g',0,'2012-02-26'),(584,'g',0,'2012-02-27'),(245,'g',0,'2011-10-12'),(591,'g',0,'2011-10-12'),(590,'g',0,'2012-02-25'),(610,'g',0,'2012-02-25'),(472,'g',0,'2012-02-27'),(515,'g',0,'2012-02-04'),(252,'g',0,'2012-02-26'),(474,'g',0,'2012-02-26'),(524,'g',0,'2012-02-04'),(484,'g',0,'2012-02-04'),(526,'g',0,'2012-02-04'),(487,'g',0,'2012-02-04'),(253,'g',0,'2012-02-27'),(528,'g',0,'2011-10-12'),(274,'g',0,'2011-10-12'),(536,'g',0,'2011-10-12'),(492,'g',0,'2012-02-04'),(254,'g',0,'2012-02-26'),(493,'g',0,'2012-02-04'),(504,'g',0,'2012-02-04'),(281,'g',0,'2011-10-12'),(544,'g',0,'2012-02-26'),(545,'g',0,'2012-02-26'),(507,'g',0,'2012-02-04'),(511,'g',0,'2012-02-04'),(549,'g',0,'2012-02-26'),(556,'g',0,'2011-10-12'),(256,'g',0,'2012-02-25'),(570,'g',0,'2012-02-26'),(450,'g',0,'2012-02-21'),(554,'g',0,'2012-02-21'),(581,'g',0,'2012-02-21'),(611,'g',0,'2012-02-26'),(516,'g',0,'2012-01-11'),(596,'g',0,'2012-01-11'),(605,'g',0,'2012-03-01'),(297,'g',0,'2011-10-12'),(606,'g',0,'2011-11-19'),(285,'g',0,'2011-10-12'),(608,'g',0,'2011-11-19'),(538,'g',0,'2012-02-03'),(300,'g',0,'2011-10-12'),(301,'g',0,'2011-10-12'),(290,'g',0,'2011-10-12'),(310,'g',0,'2011-10-12'),(311,'g',0,'2011-10-12'),(326,'g',0,'2012-02-27'),(330,'g',0,'2012-02-26'),(334,'g',0,'2011-10-12'),(337,'g',0,'2011-10-12'),(343,'g',0,'2012-02-29'),(313,'g',0,'2011-10-12'),(319,'g',0,'2011-10-12'),(320,'g',0,'2011-10-12'),(302,'g',0,'2012-02-26'),(447,'g',0,'2011-10-12'),(271,'g',0,'2012-02-26'),(456,'g',0,'2012-02-28'),(469,'g',0,'2011-10-12'),(574,'g',0,'2011-10-12'),(578,'g',0,'2012-02-26'),(609,'g',0,'2012-02-29'),(473,'g',0,'2012-02-26'),(527,'g',0,'2012-02-21'),(607,'g',0,'2011-11-19'),(594,'g',0,'2012-02-03'),(600,'g',0,'2012-02-03'),(561,'g',0,'2011-10-12'),(562,'g',0,'2011-10-12'),(569,'g',0,'2011-10-12'),(614,'g',0,'2011-12-27'),(634,'g',0,'2012-02-22'),(632,'g',0,'2012-02-22'),(631,'g',0,'2012-02-20'),(629,'g',0,'2012-02-22'),(622,'g',0,'2012-01-24'),(624,'g',0,'2012-02-22'),(552,'g',0,'2011-11-01'),(573,'g',0,'2011-11-01'),(588,'g',0,'2011-11-01'),(585,'g',0,'2011-11-01'),(568,'g',0,'2011-11-01'),(577,'g',0,'2011-11-01'),(630,'g',0,'2011-11-01'),(617,'g',0,'2012-01-07'),(628,'g',0,'2012-02-03'),(372,'g',0,'2011-11-10'),(370,'g',0,'2011-11-10'),(366,'g',0,'2011-11-10'),(369,'g',0,'2011-11-10'),(374,'g',0,'2011-11-10'),(368,'g',0,'2011-11-10'),(375,'g',0,'2011-11-10'),(371,'g',0,'2011-11-10'),(367,'g',0,'2011-11-10'),(373,'g',0,'2011-11-10'),(359,'g',0,'2011-11-10'),(363,'g',0,'2011-11-10'),(360,'g',0,'2011-11-10'),(356,'g',0,'2011-11-10'),(362,'g',0,'2011-11-10'),(358,'g',0,'2011-11-10'),(365,'g',0,'2011-11-10'),(357,'g',0,'2011-11-10'),(361,'g',0,'2011-11-10'),(364,'g',0,'2011-11-10'),(378,'g',0,'2011-11-10'),(380,'g',0,'2011-11-10'),(382,'g',0,'2011-11-10'),(381,'g',0,'2011-11-10'),(376,'g',0,'2011-11-10'),(384,'g',0,'2011-11-10'),(379,'g',0,'2011-11-10'),(377,'g',0,'2011-11-10'),(385,'g',0,'2011-11-10'),(383,'g',0,'2011-11-10'),(640,'g',0,'2011-11-11'),(633,'g',0,'2011-11-11'),(712,'g',0,'2011-11-14'),(985,'g',0,'2011-11-14'),(762,'g',0,'2011-11-14'),(649,'g',0,'2011-11-14'),(1212,'g',0,'2011-11-14'),(1418,'g',0,'2011-11-15'),(1641,'g',0,'2011-11-15'),(1368,'g',0,'2011-11-15'),(1305,'g',0,'2011-11-15'),(938,'g',0,'2011-11-15'),(709,'g',0,'2011-11-15'),(730,'g',0,'2011-11-15'),(984,'g',0,'2011-11-15'),(851,'g',0,'2011-11-15'),(866,'g',0,'2011-11-15'),(1017,'g',0,'2011-11-15'),(1077,'g',0,'2011-11-15'),(752,'g',0,'2011-11-16'),(834,'g',0,'2011-11-18'),(838,'g',0,'2011-11-18'),(833,'g',0,'2011-11-18'),(926,'g',0,'2011-11-18'),(651,'g',0,'2011-11-18'),(825,'g',0,'2011-11-18'),(734,'g',0,'2011-11-18'),(750,'g',0,'2011-11-18'),(842,'g',0,'2011-11-18'),(871,'g',0,'2011-11-18'),(997,'g',0,'2011-11-18'),(1060,'g',0,'2011-11-19'),(1210,'g',0,'2011-11-19'),(1293,'g',0,'2011-11-19'),(687,'g',0,'2011-11-19'),(650,'g',0,'2011-11-19'),(661,'g',0,'2011-11-19'),(635,'g',0,'2011-11-19'),(677,'g',0,'2011-11-19'),(692,'g',0,'2011-11-19'),(718,'g',0,'2011-11-19'),(777,'g',0,'2011-11-19'),(748,'g',0,'2011-11-19'),(743,'g',0,'2011-11-19'),(733,'g',0,'2011-11-19'),(690,'g',0,'2011-11-19'),(1267,'g',0,'2011-11-20'),(818,'g',0,'2011-11-20'),(797,'g',0,'2011-11-20'),(840,'g',0,'2011-11-20'),(732,'g',0,'2011-11-20'),(830,'g',0,'2011-11-20'),(864,'g',0,'2011-11-20'),(1453,'g',0,'2011-11-20'),(1474,'g',0,'2011-11-20'),(1388,'g',0,'2011-11-20'),(1269,'g',0,'2011-11-20'),(1270,'g',0,'2011-11-20'),(1945,'g',0,'2011-11-20'),(1289,'g',0,'2011-11-20'),(1268,'g',0,'2011-11-21'),(1266,'g',0,'2011-11-21'),(928,'g',0,'2011-11-21'),(1406,'g',0,'2011-11-22'),(1498,'g',0,'2011-11-22'),(1866,'g',0,'2011-11-22'),(1949,'g',0,'2011-11-22'),(765,'g',0,'2011-12-08'),(787,'g',0,'2011-12-08'),(745,'g',0,'2011-12-08'),(740,'g',0,'2011-12-08'),(1987,'g',0,'2011-12-08'),(1965,'g',0,'2011-12-08'),(1984,'g',0,'2011-12-08'),(1972,'g',0,'2011-12-08'),(1986,'g',0,'2011-12-08'),(1968,'g',0,'2011-12-09'),(1974,'g',0,'2011-12-09'),(1975,'g',0,'2011-12-10'),(1966,'g',0,'2011-12-10'),(3636,'g',0,'2011-12-11'),(4486,'g',0,'2011-12-11'),(2788,'g',0,'2011-12-11'),(4353,'g',0,'2011-12-12'),(4303,'g',0,'2011-12-12'),(3846,'g',0,'2011-12-12'),(3837,'g',0,'2011-12-12'),(4302,'g',0,'2011-12-12'),(4496,'g',0,'2011-12-12'),(3845,'g',0,'2011-12-12'),(4308,'g',0,'2011-12-12'),(4306,'g',0,'2011-12-12'),(3850,'g',0,'2011-12-12'),(4309,'g',0,'2011-12-12'),(3938,'g',0,'2011-12-12'),(3666,'g',0,'2011-12-12'),(4301,'g',0,'2011-12-12'),(3939,'g',0,'2011-12-12'),(3704,'g',0,'2012-01-24'),(3706,'g',0,'2012-01-24'),(3740,'g',0,'2012-01-24'),(3855,'g',0,'2012-01-24'),(4015,'g',0,'2012-01-24'),(4158,'g',0,'2011-12-13'),(4152,'g',0,'2012-01-24'),(4280,'g',0,'2011-12-13'),(4331,'g',0,'2011-12-13'),(3733,'g',0,'2011-12-16'),(4311,'g',0,'2011-12-16'),(3905,'g',0,'2011-12-16'),(3772,'g',0,'2011-12-16'),(4182,'g',0,'2011-12-16'),(4174,'g',0,'2011-12-16'),(4259,'g',0,'2011-12-16'),(4317,'g',0,'2011-12-16'),(4319,'g',0,'2011-12-17'),(3940,'g',0,'2011-12-17'),(4318,'g',0,'2011-12-17'),(4270,'g',0,'2011-12-17'),(3893,'g',0,'2012-03-05'),(3705,'g',0,'2012-03-05'),(3755,'g',0,'2012-03-05'),(3745,'g',0,'2012-03-05'),(3760,'g',0,'2012-02-01'),(3789,'g',0,'2011-12-18'),(3730,'g',0,'2012-02-21'),(412,'g',0,'2011-12-19'),(417,'g',0,'2011-12-19'),(4340,'g',0,'2011-12-23'),(4413,'g',0,'2011-12-23'),(4447,'g',0,'2011-12-23'),(4445,'g',0,'2011-12-23'),(4446,'g',0,'2011-12-23'),(4412,'g',0,'2011-12-23'),(4414,'g',0,'2011-12-23'),(3876,'g',0,'2011-12-24'),(3852,'g',0,'2011-12-24'),(3842,'g',0,'2011-12-24'),(3830,'g',0,'2012-02-10'),(3809,'g',0,'2012-02-10'),(3744,'g',0,'2012-02-10'),(4603,'g',0,'2012-02-10'),(3764,'g',0,'2011-12-24'),(4540,'g',0,'2011-12-24'),(4484,'g',0,'2011-12-24'),(4026,'g',0,'2012-02-27'),(3945,'g',0,'2012-02-27'),(3766,'g',0,'2012-02-27'),(4626,'g',0,'2012-02-27'),(4029,'g',0,'2011-12-24'),(3996,'g',0,'2011-12-24'),(3950,'g',0,'2011-12-24'),(3878,'g',0,'2011-12-24'),(3863,'g',0,'2011-12-24'),(3742,'g',0,'2011-12-24'),(3721,'g',0,'2011-12-24'),(4604,'g',0,'2011-12-24'),(3774,'g',0,'2011-12-24'),(4356,'g',0,'2011-12-24'),(3664,'g',0,'2011-12-24'),(4250,'g',0,'2011-12-24'),(4147,'g',0,'2011-12-24'),(3724,'g',0,'2011-12-25'),(4444,'g',0,'2011-12-25'),(4544,'g',0,'2011-12-25'),(4591,'g',0,'2011-12-25'),(4609,'g',0,'2011-12-25'),(4607,'g',0,'2011-12-25'),(4546,'g',0,'2011-12-25'),(4535,'g',0,'2011-12-25'),(4586,'g',0,'2011-12-25'),(4592,'g',0,'2011-12-25'),(4585,'g',0,'2011-12-25'),(4612,'g',0,'2011-12-25'),(4601,'g',0,'2011-12-27'),(3997,'g',0,'2011-12-27'),(3946,'g',0,'2011-12-27'),(3949,'g',0,'2011-12-27'),(3952,'g',0,'2011-12-27'),(3955,'g',0,'2012-02-14'),(3956,'g',0,'2012-02-14'),(3958,'g',0,'2011-12-27'),(4011,'g',0,'2012-02-14'),(508,'g',0,'2011-12-27'),(3957,'g',0,'2012-02-14'),(3944,'g',0,'2012-02-14'),(3975,'g',0,'2012-02-14'),(4642,'g',0,'2012-02-06'),(4136,'g',0,'2011-12-27'),(3854,'g',0,'2011-12-28'),(4577,'g',0,'2011-12-28'),(4627,'g',0,'2011-12-28'),(4072,'g',0,'2011-12-28'),(3883,'g',0,'2011-12-28'),(4009,'g',0,'2011-12-28'),(3746,'g',0,'2011-12-28'),(3762,'g',0,'2011-12-28'),(4568,'g',0,'2011-12-29'),(4580,'g',0,'2011-12-30'),(4695,'g',0,'2012-02-10'),(4673,'g',0,'2012-02-10'),(4669,'g',0,'2012-01-04'),(4681,'g',0,'2012-01-04'),(4556,'g',0,'2012-01-04'),(4352,'g',0,'2012-01-05'),(4373,'g',0,'2012-01-05'),(4472,'g',0,'2012-01-05'),(4385,'g',0,'2012-01-05'),(4310,'g',0,'2012-01-05'),(4611,'g',0,'2012-01-05'),(4621,'g',0,'2012-01-05'),(4701,'g',0,'2012-02-06'),(4676,'g',0,'2012-02-06'),(4479,'g',0,'2012-01-06'),(4509,'g',0,'2012-01-06'),(4505,'g',0,'2012-01-06'),(4735,'g',0,'2012-02-15'),(4690,'g',0,'2012-01-06'),(4732,'g',0,'2012-01-06'),(4725,'g',0,'2012-01-09'),(3879,'g',0,'2012-01-09'),(3873,'g',0,'2012-01-09'),(3870,'g',0,'2012-01-09'),(3986,'g',0,'2012-01-09'),(3902,'g',0,'2012-01-09'),(3989,'g',0,'2012-01-09'),(3869,'g',0,'2012-01-09'),(3849,'g',0,'2012-01-09'),(3959,'g',0,'2012-01-09'),(3866,'g',0,'2012-01-09'),(501,'g',0,'2012-01-09'),(490,'g',0,'2012-01-09'),(535,'g',0,'2012-01-09'),(478,'g',0,'2012-01-09'),(543,'g',0,'2012-01-09'),(514,'g',0,'2012-01-09'),(4687,'g',0,'2012-01-10'),(4752,'g',0,'2012-01-10'),(4702,'g',0,'2012-01-10'),(4758,'g',0,'2012-01-10'),(4740,'g',0,'2012-01-10'),(4698,'g',0,'2012-01-10'),(4705,'g',0,'2012-01-10'),(4751,'g',0,'2012-01-10'),(4694,'g',0,'2012-01-10'),(4763,'g',0,'2012-01-10'),(4745,'g',0,'2012-02-16'),(4741,'g',0,'2012-01-10'),(4713,'g',0,'2012-01-10'),(4770,'g',0,'2012-01-10'),(4771,'g',0,'2012-01-10'),(612,'g',0,'2012-01-11'),(4654,'g',0,'2012-01-11'),(4689,'g',0,'2012-01-11'),(4734,'g',0,'2012-01-11'),(4737,'g',0,'2012-01-11'),(4636,'g',0,'2012-01-11'),(4674,'g',0,'2012-01-11'),(4711,'g',0,'2012-01-11'),(3844,'g',0,'2012-01-11'),(3843,'g',0,'2012-01-11'),(4044,'g',0,'2012-01-11'),(4137,'g',0,'2012-01-11'),(4168,'g',0,'2012-01-11'),(4164,'g',0,'2012-01-11'),(4057,'g',0,'2012-01-11'),(4143,'g',0,'2012-01-11'),(4239,'g',0,'2012-01-11'),(4074,'g',0,'2012-01-11'),(4170,'g',0,'2012-01-11'),(4145,'g',0,'2012-01-11'),(4089,'g',0,'2012-01-11'),(4151,'g',0,'2012-01-11'),(4135,'g',0,'2012-01-11'),(4160,'g',0,'2012-01-11'),(4773,'g',0,'2012-01-12'),(4278,'g',0,'2012-01-12'),(4778,'g',0,'2012-01-13'),(4777,'g',0,'2012-01-13'),(4791,'g',0,'2012-01-14'),(4787,'g',0,'2012-01-14'),(4776,'g',0,'2012-01-14'),(4750,'g',0,'2012-01-14'),(4774,'g',0,'2012-01-15'),(4785,'g',0,'2012-01-15'),(4729,'g',0,'2012-02-27'),(642,'g',0,'2012-01-17'),(623,'g',0,'2012-01-17'),(644,'g',0,'2012-01-17'),(4775,'g',0,'2012-01-17'),(4813,'g',0,'2012-01-17'),(621,'g',0,'2012-01-17'),(4804,'g',0,'2012-01-17'),(4800,'g',0,'2012-01-17'),(4767,'g',0,'2012-01-17'),(4789,'g',0,'2012-01-17'),(4697,'g',0,'2012-01-17'),(4805,'g',0,'2012-01-17'),(4816,'g',0,'2012-01-17'),(625,'g',0,'2012-01-17'),(4712,'g',0,'2012-01-17'),(4792,'g',0,'2012-01-17'),(4765,'g',0,'2012-01-17'),(4703,'g',0,'2012-01-17'),(4738,'g',0,'2012-01-17'),(3917,'g',0,'2012-01-17'),(3921,'g',0,'2012-01-17'),(3910,'g',0,'2012-01-17'),(3919,'g',0,'2012-01-17'),(3923,'g',0,'2012-01-17'),(3925,'g',0,'2012-01-17'),(4063,'g',0,'2012-01-17'),(4039,'g',0,'2012-01-17'),(3918,'g',0,'2012-01-17'),(3924,'g',0,'2012-01-17'),(4764,'g',0,'2012-01-19'),(4812,'g',0,'2012-01-19'),(4731,'g',0,'2012-01-19'),(4790,'g',0,'2012-01-19'),(4726,'g',0,'2012-01-19'),(4786,'g',0,'2012-01-19'),(4779,'g',0,'2012-01-19'),(4810,'g',0,'2012-01-19'),(4801,'g',0,'2012-01-19'),(4799,'g',0,'2012-01-19'),(4761,'g',0,'2012-01-19'),(4839,'g',0,'2012-01-19'),(4824,'g',0,'2012-01-19'),(4454,'g',0,'2012-01-19'),(4448,'g',0,'2012-01-19'),(4452,'g',0,'2012-01-19'),(4380,'g',0,'2012-01-20'),(4510,'g',0,'2012-01-20'),(3711,'g',0,'2012-01-20'),(4658,'g',0,'2012-01-20'),(3710,'g',0,'2012-01-21'),(3709,'g',0,'2012-01-21'),(3691,'g',0,'2012-01-21'),(4638,'g',0,'2012-01-21'),(4570,'g',0,'2012-01-21'),(3673,'g',0,'2012-01-21'),(4541,'g',0,'2012-01-21'),(4543,'g',0,'2012-01-21'),(4223,'g',0,'2012-01-21'),(4175,'g',0,'2012-01-21'),(4565,'g',0,'2012-01-21'),(4134,'g',0,'2012-01-21'),(3803,'g',0,'2012-01-21'),(4028,'g',0,'2012-01-21'),(4094,'g',0,'2012-01-21'),(4001,'g',0,'2012-01-21'),(4083,'g',0,'2012-01-21'),(4104,'g',0,'2012-01-21'),(4017,'g',0,'2012-01-21'),(3712,'g',0,'2012-01-21'),(4107,'g',0,'2012-01-21'),(4102,'g',0,'2012-01-21'),(3967,'g',0,'2012-01-21'),(4065,'g',0,'2012-01-21'),(4092,'g',0,'2012-01-21'),(3725,'g',0,'2012-01-21'),(4099,'g',0,'2012-01-21'),(4090,'g',0,'2012-01-21'),(4006,'g',0,'2012-01-21'),(3861,'g',0,'2012-01-21'),(3988,'g',0,'2012-01-21'),(3719,'g',0,'2012-01-21'),(3713,'g',0,'2012-01-21'),(4101,'g',0,'2012-01-21'),(3926,'g',0,'2012-01-21'),(4109,'g',0,'2012-01-21'),(4105,'g',0,'2012-01-21'),(3775,'g',0,'2012-01-21'),(4820,'g',0,'2012-01-21'),(4633,'g',0,'2012-01-21'),(4615,'g',0,'2012-01-21'),(4651,'g',0,'2012-01-21'),(4634,'g',0,'2012-01-21'),(4649,'g',0,'2012-01-21'),(4618,'g',0,'2012-01-21'),(4655,'g',0,'2012-01-21'),(4666,'g',0,'2012-01-21'),(4610,'g',0,'2012-01-21'),(4650,'g',0,'2012-01-21'),(4831,'g',0,'2012-01-21'),(4783,'g',0,'2012-01-22'),(4782,'g',0,'2012-01-22'),(4008,'g',0,'2012-01-22'),(3977,'g',0,'2012-01-22'),(3973,'g',0,'2012-01-23'),(4032,'g',0,'2012-01-23'),(4036,'g',0,'2012-01-23'),(3974,'g',0,'2012-01-23'),(4007,'g',0,'2012-01-23'),(3980,'g',0,'2012-01-23'),(3998,'g',0,'2012-01-23'),(3987,'g',0,'2012-01-23'),(4798,'g',0,'2012-01-24'),(4853,'g',0,'2012-01-24'),(4817,'g',0,'2012-01-24'),(4841,'g',0,'2012-01-24'),(4857,'g',0,'2012-01-24'),(4863,'g',0,'2012-01-24'),(4829,'g',0,'2012-01-24'),(4803,'g',0,'2012-01-24'),(4869,'g',0,'2012-01-25'),(4891,'g',0,'2012-01-28'),(4868,'g',0,'2012-01-28'),(4584,'g',0,'2012-01-28'),(4858,'g',0,'2012-01-31'),(4926,'g',0,'2012-02-01'),(4932,'g',0,'2012-02-01'),(4914,'g',0,'2012-02-01'),(4424,'g',0,'2012-02-01'),(4490,'g',0,'2012-02-01'),(4485,'g',0,'2012-02-01'),(4368,'g',0,'2012-02-01'),(4428,'g',0,'2012-02-01'),(615,'g',0,'2012-02-01'),(616,'g',0,'2012-02-01'),(4833,'g',0,'2012-02-01'),(4855,'g',0,'2012-02-01'),(4871,'g',0,'2012-02-01'),(4806,'g',0,'2012-02-01'),(4838,'g',0,'2012-02-01'),(4728,'g',0,'2012-02-01'),(4924,'g',0,'2012-02-01'),(4600,'g',0,'2012-02-03'),(4904,'g',0,'2012-02-03'),(4903,'g',0,'2012-02-03'),(4877,'g',0,'2012-02-03'),(4925,'g',0,'2012-02-03'),(4756,'g',0,'2012-02-03'),(4938,'g',0,'2012-02-03'),(4944,'g',0,'2012-02-03'),(4872,'g',0,'2012-02-03'),(4950,'g',0,'2012-02-03'),(4874,'g',0,'2012-02-03'),(4876,'g',0,'2012-02-03'),(4951,'g',0,'2012-02-03'),(4913,'g',0,'2012-02-05'),(4928,'g',0,'2012-02-05'),(4902,'g',0,'2012-02-05'),(4842,'g',0,'2012-02-06'),(4334,'g',0,'2012-02-06'),(4443,'g',0,'2012-02-06'),(4357,'g',0,'2012-02-06'),(4203,'g',0,'2012-02-06'),(4314,'g',0,'2012-02-06'),(4202,'g',0,'2012-02-06'),(4198,'g',0,'2012-02-06'),(4200,'g',0,'2012-02-06'),(4196,'g',0,'2012-02-06'),(4189,'g',0,'2012-02-06'),(4194,'g',0,'2012-02-06'),(4197,'g',0,'2012-02-06'),(4204,'g',0,'2012-02-06'),(4716,'g',0,'2012-02-06'),(3754,'g',0,'2012-02-06'),(4066,'g',0,'2012-02-06'),(4811,'g',0,'2012-02-06'),(4583,'g',0,'2012-02-06'),(4547,'g',0,'2012-02-06'),(4662,'g',0,'2012-02-06'),(3806,'g',0,'2012-02-06'),(4605,'g',0,'2012-02-06'),(4091,'g',0,'2012-02-06'),(4005,'g',0,'2012-02-06'),(4068,'g',0,'2012-02-06'),(4784,'g',0,'2012-02-06'),(3703,'g',0,'2012-02-06'),(4113,'g',0,'2012-02-06'),(4760,'g',0,'2012-02-06'),(4086,'g',0,'2012-02-06'),(4720,'g',0,'2012-02-06'),(4724,'g',0,'2012-02-06'),(4971,'g',0,'2012-02-06'),(4915,'g',0,'2012-02-07'),(4923,'g',0,'2012-02-07'),(4930,'g',0,'2012-02-07'),(4900,'g',0,'2012-02-07'),(4856,'g',0,'2012-02-07'),(4941,'g',0,'2012-02-07'),(4940,'g',0,'2012-02-07'),(4769,'g',0,'2012-02-10'),(4754,'g',0,'2012-02-10'),(4759,'g',0,'2012-02-10'),(4753,'g',0,'2012-02-10'),(3962,'g',0,'2012-02-10'),(3961,'g',0,'2012-02-10'),(3963,'g',0,'2012-02-10'),(3964,'g',0,'2012-02-10'),(3894,'g',0,'2012-02-10'),(3892,'g',0,'2012-02-10'),(3891,'g',0,'2012-02-10'),(3901,'g',0,'2012-02-10'),(3960,'g',0,'2012-02-10'),(3915,'g',0,'2012-02-10'),(4124,'g',0,'2012-02-10'),(4171,'g',0,'2012-02-10'),(4657,'g',0,'2012-02-10'),(4166,'g',0,'2012-02-10'),(4156,'g',0,'2012-02-10'),(4111,'g',0,'2012-02-10'),(4097,'g',0,'2012-02-10'),(4120,'g',0,'2012-02-10'),(4177,'g',0,'2012-02-10'),(4141,'g',0,'2012-02-10'),(4664,'g',0,'2012-02-10'),(4630,'g',0,'2012-02-10'),(4675,'g',0,'2012-02-10'),(4647,'g',0,'2012-02-10'),(4631,'g',0,'2012-02-10'),(4670,'g',0,'2012-02-10'),(4632,'g',0,'2012-02-10'),(4693,'g',0,'2012-02-10'),(4641,'g',0,'2012-02-10'),(4686,'g',0,'2012-02-10'),(4185,'g',0,'2012-02-10'),(4180,'g',0,'2012-02-10'),(4191,'g',0,'2012-02-10'),(4179,'g',0,'2012-02-10'),(4190,'g',0,'2012-02-10'),(4183,'g',0,'2012-02-10'),(4187,'g',0,'2012-02-10'),(4192,'g',0,'2012-02-10'),(4188,'g',0,'2012-02-10'),(4181,'g',0,'2012-02-10'),(4539,'g',0,'2012-02-10'),(4588,'g',0,'2012-02-10'),(4574,'g',0,'2012-02-10'),(4559,'g',0,'2012-02-10'),(4587,'g',0,'2012-02-10'),(3686,'g',0,'2012-02-10'),(4589,'g',0,'2012-02-10'),(4106,'g',0,'2012-02-10'),(3979,'g',0,'2012-02-10'),(4637,'g',0,'2012-02-10'),(3747,'g',0,'2012-02-10'),(3748,'g',0,'2012-02-10'),(3678,'g',0,'2012-02-10'),(3743,'g',0,'2012-02-10'),(3750,'g',0,'2012-02-10'),(3815,'g',0,'2012-02-10'),(3817,'g',0,'2012-02-10'),(3875,'g',0,'2012-02-10'),(3739,'g',0,'2012-02-10'),(3871,'g',0,'2012-02-10'),(4823,'g',0,'2012-02-10'),(3669,'g',0,'2012-02-10'),(4781,'g',0,'2012-02-10'),(4560,'g',0,'2012-02-10'),(3887,'g',0,'2012-02-10'),(3880,'g',0,'2012-02-10'),(3888,'g',0,'2012-02-10'),(3890,'g',0,'2012-02-10'),(3787,'g',0,'2012-02-10'),(3881,'g',0,'2012-02-10'),(3786,'g',0,'2012-02-10'),(3877,'g',0,'2012-02-10'),(3758,'g',0,'2012-02-10'),(4736,'g',0,'2012-02-10'),(4730,'g',0,'2012-02-10'),(4710,'g',0,'2012-02-10'),(4747,'g',0,'2012-02-10'),(4718,'g',0,'2012-02-10'),(4748,'g',0,'2012-02-10'),(4696,'g',0,'2012-02-10'),(4719,'g',0,'2012-02-10'),(4699,'g',0,'2012-02-10'),(4708,'g',0,'2012-02-10'),(4860,'g',0,'2012-02-10'),(4827,'g',0,'2012-02-10'),(4835,'g',0,'2012-02-10'),(4946,'g',0,'2012-02-10'),(4851,'g',0,'2012-02-10'),(4866,'g',0,'2012-02-10'),(4870,'g',0,'2012-02-10'),(4828,'g',0,'2012-02-10'),(4911,'g',0,'2012-02-10'),(4840,'g',0,'2012-02-10'),(4312,'g',0,'2012-02-10'),(4341,'g',0,'2012-02-10'),(4332,'g',0,'2012-02-10'),(3916,'g',0,'2012-02-10'),(3985,'g',0,'2012-02-10'),(3934,'g',0,'2012-02-10'),(3984,'g',0,'2012-02-10'),(3953,'g',0,'2012-02-10'),(3886,'g',0,'2012-02-10'),(3936,'g',0,'2012-02-10'),(3913,'g',0,'2012-02-10'),(3942,'g',0,'2012-02-10'),(3935,'g',0,'2012-02-10'),(4437,'g',0,'2012-02-10'),(4386,'g',0,'2012-02-11'),(4388,'g',0,'2012-02-11'),(4455,'g',0,'2012-02-11'),(4430,'g',0,'2012-02-11'),(4435,'g',0,'2012-02-11'),(4442,'g',0,'2012-02-11'),(4387,'g',0,'2012-02-11'),(4382,'g',0,'2012-02-11'),(4466,'g',0,'2012-02-11'),(4027,'g',0,'2012-02-11'),(3992,'g',0,'2012-02-11'),(4014,'g',0,'2012-02-11'),(3995,'g',0,'2012-02-11'),(4035,'g',0,'2012-02-11'),(4038,'g',0,'2012-02-11'),(4512,'g',0,'2012-02-11'),(4622,'g',0,'2012-02-11'),(4598,'g',0,'2012-02-11'),(4582,'g',0,'2012-02-11'),(4656,'g',0,'2012-02-11'),(4536,'g',0,'2012-02-11'),(4625,'g',0,'2012-02-11'),(4557,'g',0,'2012-02-11'),(4606,'g',0,'2012-02-11'),(4545,'g',0,'2012-02-11'),(4571,'g',0,'2012-02-11'),(4986,'g',0,'2012-02-11'),(4996,'g',0,'2012-02-11'),(4983,'g',0,'2012-02-11'),(4990,'g',0,'2012-02-11'),(4982,'g',0,'2012-02-12'),(4993,'g',0,'2012-02-13'),(5001,'g',0,'2012-02-13'),(4945,'g',0,'2012-02-13'),(3929,'g',0,'2012-02-14'),(3928,'g',0,'2012-02-14'),(4051,'g',0,'2012-02-14'),(3930,'g',0,'2012-02-14'),(3941,'g',0,'2012-02-14'),(4013,'g',0,'2012-02-14'),(4081,'g',0,'2012-02-14'),(4021,'g',0,'2012-02-14'),(4058,'g',0,'2012-02-14'),(4093,'g',0,'2012-02-14'),(3931,'g',0,'2012-02-14'),(3914,'g',0,'2012-02-14'),(3943,'g',0,'2012-02-14'),(3927,'g',0,'2012-02-14'),(4205,'g',0,'2012-02-14'),(4116,'g',0,'2012-02-14'),(4206,'g',0,'2012-02-14'),(4112,'g',0,'2012-02-14'),(4163,'g',0,'2012-02-14'),(4153,'g',0,'2012-02-14'),(4169,'g',0,'2012-02-14'),(4161,'g',0,'2012-02-14'),(4149,'g',0,'2012-02-14'),(4184,'g',0,'2012-02-14'),(4240,'g',0,'2012-02-14'),(4211,'g',0,'2012-02-14'),(4209,'g',0,'2012-02-14'),(4241,'g',0,'2012-02-14'),(4219,'g',0,'2012-02-14'),(4207,'g',0,'2012-02-14'),(4208,'g',0,'2012-02-14'),(4222,'g',0,'2012-02-14'),(4564,'g',0,'2012-02-14'),(4212,'g',0,'2012-02-14'),(4355,'g',0,'2012-02-14'),(4377,'g',0,'2012-02-14'),(4295,'g',0,'2012-02-14'),(4358,'g',0,'2012-02-14'),(4375,'g',0,'2012-02-14'),(4363,'g',0,'2012-02-14'),(4381,'g',0,'2012-02-14'),(4325,'g',0,'2012-02-14'),(4376,'g',0,'2012-02-14'),(4383,'g',0,'2012-02-14'),(4503,'g',0,'2012-02-14'),(4451,'g',0,'2012-02-14'),(4487,'g',0,'2012-02-14'),(4408,'g',0,'2012-02-14'),(4954,'g',0,'2012-02-14'),(4493,'g',0,'2012-02-14'),(4438,'g',0,'2012-02-14'),(4501,'g',0,'2012-02-14'),(4502,'g',0,'2012-02-14'),(4062,'g',0,'2012-02-14'),(4162,'g',0,'2012-02-15'),(4984,'g',0,'2012-02-15'),(4964,'g',0,'2012-02-15'),(4960,'g',0,'2012-02-15'),(4384,'g',0,'2012-02-15'),(4030,'g',0,'2012-02-15'),(5004,'g',0,'2012-02-15'),(5009,'g',0,'2012-02-15'),(5015,'g',0,'2012-02-15'),(5003,'g',0,'2012-02-16'),(5018,'g',0,'2012-02-17'),(4578,'g',0,'2012-02-17'),(4788,'g',0,'2012-02-17'),(4549,'g',0,'2012-02-17'),(4576,'g',0,'2012-02-17'),(4780,'g',0,'2012-02-17'),(3885,'g',0,'2012-02-17'),(4579,'g',0,'2012-02-17'),(4808,'g',0,'2012-02-17'),(3897,'g',0,'2012-02-17'),(4766,'g',0,'2012-02-17'),(4552,'g',0,'2012-02-17'),(4379,'g',0,'2012-02-17'),(4328,'g',0,'2012-02-17'),(3692,'g',0,'2012-02-17'),(3676,'g',0,'2012-02-17'),(4953,'g',0,'2012-02-17'),(4968,'g',0,'2012-02-17'),(4955,'g',0,'2012-02-18'),(4393,'g',0,'2012-02-18'),(4969,'g',0,'2012-02-18'),(4419,'g',0,'2012-02-18'),(4471,'g',0,'2012-02-18'),(4291,'g',0,'2012-02-18'),(4395,'g',0,'2012-02-18'),(3932,'g',0,'2012-02-18'),(3811,'g',0,'2012-02-18'),(3771,'g',0,'2012-02-18'),(3933,'g',0,'2012-02-18'),(3832,'g',0,'2012-02-18'),(3702,'g',0,'2012-02-18'),(3707,'g',0,'2012-02-18'),(4292,'g',0,'2012-02-18'),(4422,'g',0,'2012-02-18'),(4374,'g',0,'2012-02-18'),(4242,'g',0,'2012-02-18'),(4327,'g',0,'2012-02-18'),(3797,'g',0,'2012-02-18'),(4768,'g',0,'2012-02-18'),(3682,'g',0,'2012-02-18'),(4757,'g',0,'2012-02-18'),(4998,'g',0,'2012-02-18'),(4802,'g',0,'2012-02-18'),(4566,'g',0,'2012-02-18'),(3872,'g',0,'2012-02-18'),(4739,'g',0,'2012-02-18'),(3688,'g',0,'2012-02-18'),(3829,'g',0,'2012-02-18'),(4599,'g',0,'2012-02-18'),(4593,'g',0,'2012-02-18'),(3840,'g',0,'2012-02-18'),(3874,'g',0,'2012-02-18'),(3684,'g',0,'2012-02-18'),(3818,'g',0,'2012-02-18'),(5016,'g',0,'2012-02-18'),(3826,'g',0,'2012-02-18'),(4743,'g',0,'2012-02-18'),(4733,'g',0,'2012-02-18'),(4595,'g',0,'2012-02-18'),(3697,'g',0,'2012-02-18'),(4742,'g',0,'2012-02-18'),(3801,'g',0,'2012-02-18'),(5014,'g',0,'2012-02-18'),(3867,'g',0,'2012-02-18'),(4249,'g',0,'2012-02-18'),(3680,'g',0,'2012-02-19'),(4988,'g',0,'2012-02-19'),(5010,'g',0,'2012-02-19'),(4991,'g',0,'2012-02-19'),(5002,'g',0,'2012-02-19'),(5017,'g',0,'2012-02-20'),(4994,'g',0,'2012-02-20'),(4989,'g',0,'2012-02-20'),(4749,'g',0,'2012-02-20'),(4691,'g',0,'2012-02-20'),(4715,'g',0,'2012-02-20'),(4709,'g',0,'2012-02-20'),(4722,'g',0,'2012-02-21'),(5006,'g',0,'2012-02-21'),(3693,'g',0,'2012-02-21'),(4992,'g',0,'2012-02-22'),(4987,'g',0,'2012-02-22'),(3799,'g',0,'2012-02-22'),(3773,'g',0,'2012-02-22'),(4999,'g',0,'2012-02-22'),(4608,'g',0,'2012-02-22'),(3757,'g',0,'2012-02-22'),(3911,'g',0,'2012-02-22'),(3718,'g',0,'2012-02-22'),(5030,'g',0,'2012-02-22'),(4975,'g',0,'2012-02-22'),(4635,'g',0,'2012-02-22'),(4613,'g',0,'2012-02-22'),(4665,'g',0,'2012-02-22'),(4659,'g',0,'2012-02-22'),(3777,'g',0,'2012-02-22'),(4307,'g',0,'2012-02-22'),(4660,'g',0,'2012-02-22'),(4762,'g',0,'2012-02-22'),(4416,'g',0,'2012-02-22'),(4614,'g',0,'2012-02-22'),(4935,'g',0,'2012-02-22'),(3752,'g',0,'2012-02-22'),(4901,'g',0,'2012-02-22'),(4004,'g',0,'2012-02-22'),(4652,'g',0,'2012-02-22'),(4554,'g',0,'2012-02-22'),(3889,'g',0,'2012-02-22'),(3681,'g',0,'2012-02-23'),(4643,'g',0,'2012-02-23'),(4590,'g',0,'2012-02-23'),(3839,'g',0,'2012-02-23'),(4628,'g',0,'2012-02-23'),(4873,'g',0,'2012-02-23'),(4010,'g',0,'2012-02-23'),(4933,'g',0,'2012-02-23'),(4640,'g',0,'2012-02-23'),(4878,'g',0,'2012-02-23'),(4922,'g',0,'2012-02-23'),(5022,'g',0,'2012-02-23'),(3823,'g',0,'2012-02-23'),(4594,'g',0,'2012-02-23'),(4807,'g',0,'2012-02-23'),(4714,'g',0,'2012-02-23'),(5005,'g',0,'2012-02-23'),(3735,'g',0,'2012-02-23'),(5021,'g',0,'2012-02-23'),(3723,'g',0,'2012-02-23'),(3848,'g',0,'2012-02-23'),(3716,'g',0,'2012-02-23'),(4333,'g',0,'2012-02-23'),(4917,'g',0,'2012-02-23'),(3714,'g',0,'2012-02-23'),(4875,'g',0,'2012-02-23'),(4973,'g',0,'2012-02-23'),(4653,'g',0,'2012-02-23'),(4508,'g',0,'2012-02-23'),(3749,'g',0,'2012-02-23'),(3685,'g',0,'2012-02-23'),(4830,'g',0,'2012-02-23'),(4845,'g',0,'2012-02-23'),(4849,'g',0,'2012-02-23'),(5025,'g',0,'2012-02-24'),(3695,'g',0,'2012-02-24'),(5036,'g',0,'2012-02-25'),(5033,'g',0,'2012-02-25'),(5023,'g',0,'2012-02-25'),(5045,'g',0,'2012-02-25'),(4906,'g',0,'2012-02-25'),(4707,'g',0,'2012-02-25'),(643,'g',0,'2012-02-25'),(4826,'g',0,'2012-02-25'),(4916,'g',0,'2012-02-25'),(4949,'g',0,'2012-02-25'),(3990,'g',0,'2012-02-26'),(3779,'g',0,'2012-02-26'),(3816,'g',0,'2012-02-26'),(4943,'g',0,'2012-02-26'),(4822,'g',0,'2012-02-26'),(4814,'g',0,'2012-02-26'),(4850,'g',0,'2012-02-26'),(4639,'g',0,'2012-02-26'),(4727,'g',0,'2012-02-26'),(4304,'g',0,'2012-02-26'),(4692,'g',0,'2012-02-26'),(4862,'g',0,'2012-02-26'),(4098,'g',0,'2012-02-26'),(4108,'g',0,'2012-02-26'),(4144,'g',0,'2012-02-26'),(4257,'g',0,'2012-02-26'),(4645,'g',0,'2012-02-26'),(4861,'g',0,'2012-02-26'),(4071,'g',0,'2012-02-26'),(4133,'g',0,'2012-02-26'),(4018,'g',0,'2012-02-27'),(3968,'g',0,'2012-02-27'),(4084,'g',0,'2012-02-27'),(4131,'g',0,'2012-02-27'),(4019,'g',0,'2012-02-27'),(613,'g',0,'2012-02-27'),(4596,'g',0,'2012-02-27'),(4832,'g',0,'2012-02-27'),(3948,'g',0,'2012-02-27'),(3947,'g',0,'2012-02-27'),(5043,'g',0,'2012-02-27'),(5049,'g',0,'2012-02-27'),(5064,'g',0,'2012-02-27'),(5051,'g',0,'2012-02-27'),(4854,'g',0,'2012-02-27'),(4976,'g',0,'2012-02-27'),(4293,'g',0,'2012-02-27'),(351,'g',0,'2012-02-29'),(350,'g',0,'2012-02-29'),(347,'g',0,'2012-02-29'),(348,'g',0,'2012-02-29'),(346,'g',0,'2012-02-29'),(349,'g',0,'2012-02-29'),(5063,'g',0,'2012-02-29'),(5070,'g',0,'2012-02-29'),(4033,'g',0,'2012-02-29'),(4345,'g',0,'2012-02-29'),(5091,'g',0,'2012-02-29'),(4717,'g',0,'2012-02-29'),(5024,'g',0,'2012-02-29'),(4995,'g',0,'2012-02-29'),(4456,'g',0,'2012-02-29'),(4947,'g',0,'2012-02-29'),(4704,'g',0,'2012-02-29'),(4118,'g',0,'2012-02-29'),(3970,'g',0,'2012-02-29'),(3741,'g',0,'2012-02-29'),(3736,'g',0,'2012-02-29'),(5012,'g',0,'2012-02-29'),(4942,'g',0,'2012-02-29'),(4389,'g',0,'2012-02-29'),(4095,'g',0,'2012-02-29'),(4037,'g',0,'2012-03-01'),(4939,'g',0,'2012-03-01'),(5011,'g',0,'2012-03-01'),(5058,'g',0,'2012-03-01'),(3737,'g',0,'2012-03-01'),(4366,'g',0,'2012-03-01'),(4347,'g',0,'2012-03-01'),(3862,'g',0,'2012-03-01'),(4247,'g',0,'2012-03-01'),(3865,'g',0,'2012-03-01'),(4129,'g',0,'2012-03-01'),(4173,'g',0,'2012-03-01'),(4330,'g',0,'2012-03-01'),(4000,'g',0,'2012-03-01'),(4248,'g',0,'2012-03-01'),(4367,'g',0,'2012-03-01'),(4684,'g',0,'2012-03-01'),(3665,'g',0,'2012-03-01'),(4100,'g',0,'2012-03-01'),(3978,'g',0,'2012-03-01'),(4819,'g',0,'2012-03-01'),(3778,'g',0,'2012-03-01'),(3784,'g',0,'2012-03-01'),(4114,'g',0,'2012-03-01'),(4286,'g',0,'2012-03-01'),(4864,'g',0,'2012-03-01'),(4834,'g',0,'2012-03-01'),(3795,'g',0,'2012-03-01'),(3804,'g',0,'2012-03-01'),(3859,'g',0,'2012-03-01'),(3698,'g',0,'2012-03-01'),(3722,'g',0,'2012-03-01'),(638,'g',0,'2012-03-01'),(4818,'g',0,'2012-03-01'),(4667,'g',0,'2012-03-01'),(4077,'g',0,'2012-03-01'),(4825,'g',0,'2012-03-01'),(4948,'g',0,'2012-03-01'),(4815,'g',0,'2012-03-01'),(5039,'g',0,'2012-03-01'),(4837,'g',0,'2012-03-01'),(4852,'g',0,'2012-03-01'),(3700,'g',0,'2012-03-01'),(4746,'g',0,'2012-03-01'),(648,'g',0,'2012-03-01'),(647,'g',0,'2012-03-01'),(645,'g',0,'2012-03-01'),(4846,'g',0,'2012-03-01'),(641,'g',0,'2012-03-01'),(637,'g',0,'2012-03-01'),(646,'g',0,'2012-03-01'),(4867,'g',0,'2012-03-01'),(4918,'g',0,'2012-03-01'),(4859,'g',0,'2012-03-01'),(4934,'g',0,'2012-03-01'),(4905,'g',0,'2012-03-01'),(4865,'g',0,'2012-03-01'),(4847,'g',0,'2012-03-01'),(4937,'g',0,'2012-03-01'),(4931,'g',0,'2012-03-01'),(5085,'g',0,'2012-03-01'),(3836,'g',0,'2012-03-01'),(3814,'g',0,'2012-03-02'),(4907,'g',0,'2012-03-02'),(4744,'g',0,'2012-03-02'),(4908,'g',0,'2012-03-02'),(4929,'g',0,'2012-03-02'),(5082,'g',0,'2012-03-03'),(5101,'g',0,'2012-03-03'),(5105,'g',0,'2012-03-03'),(5102,'g',0,'2012-03-03'),(5106,'g',0,'2012-03-03'),(4981,'g',0,'2012-03-04'),(5084,'g',0,'2012-03-04'),(5103,'g',0,'2012-03-04'),(5104,'g',0,'2012-03-04'),(5086,'g',0,'2012-03-04'),(5013,'g',0,'2012-03-04'),(5093,'g',0,'2012-03-04'),(5077,'g',0,'2012-03-04'),(5095,'g',0,'2012-03-04'),(4020,'g',0,'2012-03-05'),(4985,'g',0,'2012-03-05'),(4553,'g',0,'2012-03-05'),(3858,'g',0,'2012-03-05'),(4176,'g',0,'2012-03-05'),(3909,'g',0,'2012-03-05'),(5060,'g',0,'2012-03-05'),(5061,'g',0,'2012-03-06'),(4283,'g',0,'2012-03-06'),(5059,'g',0,'2012-03-06'),(4920,'g',0,'2012-03-06'),(4921,'g',0,'2012-03-06'),(4927,'g',0,'2012-03-06'),(4281,'g',0,'2012-03-06'),(5065,'g',0,'2012-03-06'),(3882,'g',0,'2012-03-06'),(5131,'g',0,'2012-03-06'),(4148,'g',0,'2012-03-06'),(4682,'g',0,'2012-03-06'),(3756,'g',0,'2012-03-06'),(4146,'g',0,'2012-03-06'),(5034,'g',0,'2012-03-06'),(4088,'g',0,'2012-03-06'),(4069,'g',0,'2012-03-06'),(4115,'g',0,'2012-03-06'),(4127,'g',0,'2012-03-06'),(4076,'g',0,'2012-03-06'),(4213,'g',0,'2012-03-06'),(4680,'g',0,'2012-03-06'),(4075,'g',0,'2012-03-06'),(5117,'g',0,'2012-03-06'),(4909,'g',0,'2012-03-06'),(4672,'g',0,'2012-03-06'),(4671,'g',0,'2012-03-06'),(4646,'g',0,'2012-03-06'),(5046,'g',0,'2012-03-06'),(4644,'g',0,'2012-03-06'),(5127,'g',0,'2012-03-06'),(5027,'g',0,'2012-03-06'),(3800,'g',0,'2012-03-06'),(3841,'g',0,'2012-03-06'),(5044,'g',0,'2012-03-06'),(5055,'g',0,'2012-03-06'),(5048,'g',0,'2012-03-06'),(5062,'g',0,'2012-03-06'),(5037,'g',0,'2012-03-06'),(3805,'g',0,'2012-03-06'),(3831,'g',0,'2012-03-06'),(4064,'g',0,'2012-03-06'),(3993,'g',0,'2012-03-06'),(3999,'g',0,'2012-03-06'),(4067,'g',0,'2012-03-06'),(3994,'g',0,'2012-03-06'),(5031,'g',0,'2012-03-06'),(4059,'g',0,'2012-03-06'),(4046,'g',0,'2012-03-06'),(4060,'g',0,'2012-03-06'),(5072,'g',0,'2012-03-06'),(4910,'g',0,'2012-03-06'),(4898,'g',0,'2012-03-06'),(4897,'g',0,'2012-03-06'),(5098,'g',0,'2012-03-07'),(4899,'g',0,'2012-03-07'),(4896,'g',0,'2012-03-07'),(4573,'g',0,'2012-03-07'),(3694,'g',0,'2012-03-07'),(5092,'g',0,'2012-03-07'),(4534,'g',0,'2012-03-07'),(3701,'g',0,'2012-03-07'),(4569,'g',0,'2012-03-07'),(4407,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `premium` char(1) default NULL,
  `sponsored` char(1) default NULL,
  `expire` datetime default NULL,
  `paid` char(1) default NULL,
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `enable` char(1) default NULL,
  `setting` text,
  `invoice_html` text,
  PRIMARY KEY  (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL auto_increment,
  `contact_name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `detail` text,
  `amount` double default NULL,
  `time` datetime default NULL,
  `invoice_id` varchar(10) default NULL,
  PRIMARY KEY  (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_pl_sociable`
--

CREATE TABLE `idx_pl_sociable` (
  `sb_id` int(11) NOT NULL auto_increment,
  `sb_name` varchar(255) character set utf8 default NULL,
  `sb_url` varchar(255) character set utf8 default NULL,
  `sb_icon` varchar(255) character set utf8 default NULL,
  `sb_enable` char(1) character set utf8 default '0',
  PRIMARY KEY  (`sb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_sociable`
--

INSERT INTO `idx_pl_sociable` VALUES (1,'BarraPunto','http://barrapunto.com/submit.pl?subj=TITLE&amp;story=PERMALINK','barrapunto.png','0'),(2,'Bitacoras.com','http://bitacoras.com/anotaciones/PERMALINK','bitacoras.png','0'),(3,'BlinkList','http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=PERMALINK&amp;Title=TITLE','blinklist.png','0'),(4,'blogmarks','http://blogmarks.net/my/new.php?mini=1&amp;simple=1&amp;url=PERMALINK&amp;title=TITLE','blogmarks.png','0'),(5,'Blogosphere News','http://www.blogospherenews.com/submit.php?url=PERMALINK&amp;title=TITLE','blogospherenews.png','0'),(6,'blogtercimlap','http://cimlap.blogter.hu/index.php?action=suggest_link&amp;title=TITLE&amp;url=PERMALINK','blogter.png','0'),(7,'Faves','http://faves.com/Authoring.aspx?u=PERMALINK&amp;title=TITLE','bluedot.png','0'),(8,'connotea','http://www.connotea.org/addpopup?continue=confirm&amp;uri=PERMALINK&amp;title=TITLE&amp;description=EXCERPT','connotea.png','0'),(9,'Current','http://current.com/clipper.htm?url=PERMALINK&amp;title=TITLE','current.png','0'),(10,'del.icio.us','http://delicious.com/post?url=PERMALINK&amp;title=TITLE&amp;notes=EXCERPT','delicious.png','0'),(11,'Digg','http://digg.com/submit?phase=2&amp;url=PERMALINK&amp;title=TITLE&amp;bodytext=EXCERPT','digg.png','1'),(12,'Diigo','http://www.diigo.com/post?url=PERMALINK&amp;title=TITLE','diigo.png','0'),(13,'DotNetKicks','http://www.dotnetkicks.com/kick/?url=PERMALINK&amp;title=TITLE','dotnetkicks.png','0'),(14,'DZone','http://www.dzone.com/links/add.html?url=PERMALINK&amp;title=TITLE','dzone.png','0'),(15,'eKudos','http://www.ekudos.nl/artikel/nieuw?url=PERMALINK&amp;title=TITLE&amp;desc=EXCERPT','ekudos.png','0'),(16,'email','mailto:?subject=TITLE&amp;body=PERMALINK','email_link.png','0'),(17,'Facebook','http://www.facebook.com/share.php?u=PERMALINK&amp;t=TITLE','facebook.png','1'),(18,'Fark','http://cgi.fark.com/cgi/fark/farkit.pl?h=TITLE&amp;u=PERMALINK','fark.png','0'),(19,'Fleck','http://beta3.fleck.com/bookmarklet.php?url=PERMALINK&amp;title=TITLE','fleck.png','0'),(20,'FriendFeed','http://www.friendfeed.com/share?title=TITLE&amp;link=PERMALINK','friendfeed.png','0'),(21,'FSDaily','http://www.fsdaily.com/submit?url=PERMALINK&amp;title=TITLE','fsdaily.png','0'),(22,'Global Grind','http://globalgrind.com/submission/submit.aspx?url=PERMALINK&amp;type=Article&amp;title=TITLE','globalgrind.png','0'),(23,'Google','http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=PERMALINK&amp;title=TITLE&amp;annotation=EXCERPT','googlebookmark.png','0'),(24,'Gwar','http://www.gwar.pl/DodajGwar.html?u=PERMALINK','gwar.png','0'),(25,'HackerNews','http://news.ycombinator.com/submitlink?u=PERMALINK&amp;t=TITLE','hackernews.png','0'),(26,'Haohao','http://www.haohaoreport.com/submit.php?url=PERMALINK&amp;title=TITLE','haohao.png','0'),(27,'HealthRanker','http://healthranker.com/submit.php?url=PERMALINK&amp;title=TITLE','healthranker.png','0'),(28,'HelloTxt','http://hellotxt.com/?status=TITLE+PERMALINK','hellotxt.png','0'),(29,'Hemidemi','http://www.hemidemi.com/user_bookmark/new?title=TITLE&amp;url=PERMALINK','hemidemi.png','0'),(30,'Hyves','http://www.hyves.nl/profilemanage/add/tips/?name=TITLE&amp;text=EXCERPT+PERMALINK&amp;rating=5','hyves.png','0'),(31,'Identi.ca','http://identi.ca/notice/new?status_textarea=PERMALINK','identica.png','0'),(32,'IndianPad','http://www.indianpad.com/submit.php?url=PERMALINK','indianpad.png','0'),(33,'Internetmedia','http://internetmedia.hu/submit.php?url=PERMALINK','im.png','0'),(34,'Kirtsy','http://www.kirtsy.com/submit.php?url=PERMALINK&amp;title=TITLE','kirtsy.png','0'),(35,'laaik.it','http://laaik.it/NewStoryCompact.aspx?uri=PERMALINK&amp;headline=TITLE&amp;cat=5e082fcc-8a3b-47e2-acec-fdf64ff19d12','laaikit.png','0'),(36,'LinkArena','http://linkarena.com/bookmarks/addlink/?url=PERMALINK&amp;title=TITLE','linkarena.png','0'),(37,'LinkaGoGo','http://www.linkagogo.com/go/AddNoPopup?url=PERMALINK&amp;title=TITLE','linkagogo.png','0'),(38,'LinkedIn','http://www.linkedin.com/shareArticle?mini=true&amp;url=PERMALINK&amp;title=TITLE&amp;source=BLOGNAME&amp;summary=EXCERPT','linkedin.png','0'),(39,'Linkter','http://www.linkter.hu/index.php?action=suggest_link&amp;url=PERMALINK&amp;title=TITLE','linkter.png','0'),(40,'Live','https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=PERMALINK&amp;title=TITLE','live.png','0'),(41,'Meneame','http://meneame.net/submit.php?url=PERMALINK','meneame.png','0'),(42,'MisterWong','http://www.mister-wong.com/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(43,'MisterWong.DE','http://www.mister-wong.de/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(44,'Mixx','http://www.mixx.com/submit?page_url=PERMALINK&amp;title=TITLE','mixx.png','0'),(45,'muti','http://www.muti.co.za/submit?url=PERMALINK&amp;title=TITLE','muti.png','0'),(46,'MyShare','http://myshare.url.com.tw/index.php?func=newurl&amp;url=PERMALINK&amp;desc=TITLE','myshare.png','0'),(47,'MySpace','http://www.myspace.com/Modules/PostTo/Pages/?u=PERMALINK&amp;t=TITLE','myspace.png','0'),(48,'MSNReporter','http://reporter.nl.msn.com/?fn=contribute&amp;Title=TITLE&amp;URL=PERMALINK&amp;cat_id=6&amp;tag_id=31&amp;Remark=EXCERPT','msnreporter.png','0'),(49,'N4G','http://www.n4g.com/tips.aspx?url=PERMALINK&amp;title=TITLE','n4g.png','0'),(50,'Netvibes','http://www.netvibes.com/share?title=TITLE&amp;url=PERMALINK','netvibes.png','0'),(51,'NewsVine','http://www.newsvine.com/_tools/seed&amp;save?u=PERMALINK&amp;h=TITLE','newsvine.png','0'),(52,'Netvouz','http://www.netvouz.com/action/submitBookmark?url=PERMALINK&amp;title=TITLE&amp;popup=no','netvouz.png','0'),(53,'NuJIJ','http://nujij.nl/jij.lynkx?t=TITLE&amp;u=PERMALINK&amp;b=EXCERPT','nujij.png','0'),(54,'Ping.fm','http://ping.fm/ref/?link=PERMALINK&amp;title=TITLE&amp;body=EXCERPT','ping.png','0'),(55,'Posterous','http://posterous.com/share?linkto=PERMALINK&amp;title=TITLE&amp;selection=EXCERPT','posterous.png','0'),(56,'PDF','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','pdf.png','0'),(57,'Print','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','printfriendly.png','0'),(58,'Propeller','http://www.propeller.com/submit/?url=PERMALINK','propeller.png','0'),(59,'Ratimarks','http://ratimarks.org/bookmarks.php/?action=add&address=PERMALINK&amp;title=TITLE','ratimarks.png','0'),(60,'Rec6','http://rec6.via6.com/link.php?url=PERMALINK&amp;=TITLE','rec6.png','0'),(61,'Reddit','http://reddit.com/submit?url=PERMALINK&amp;title=TITLE','reddit.png','0'),(62,'RSS','FEEDLINK','rss.png','0'),(63,'Scoopeo','http://www.scoopeo.com/scoop/new?newurl=PERMALINK&amp;title=TITLE','scoopeo.png','0'),(64,'Segnalo','http://segnalo.alice.it/post.html.php?url=PERMALINK&amp;title=TITLE','segnalo.png','0'),(65,'Simpy','http://www.simpy.com/simpy/LinkAdd.do?href=PERMALINK&amp;title=TITLE','simpy.png','0'),(66,'Slashdot','http://slashdot.org/bookmark.pl?title=TITLE&amp;url=PERMALINK','slashdot.png','0'),(67,'Socialogs','http://socialogs.com/add_story.php?story_url=PERMALINK&amp;story_title=TITLE','socialogs.png','0'),(68,'SphereIt','http://www.sphere.com/search?q=sphereit:PERMALINK&amp;title=TITLE','sphere.png','0'),(69,'Sphinn','http://sphinn.com/index.php?c=post&amp;m=submit&amp;link=PERMALINK','sphinn.png','0'),(70,'StumbleUpon','http://www.stumbleupon.com/submit?url=PERMALINK&amp;title=TITLE','stumbleupon.png','0'),(71,'Techmeme','http://twitter.com/home/?status=tip%20@Techmeme%20PERMALINK%20TITLE','techmeme.png','0'),(72,'Technorati','http://technorati.com/faves?add=PERMALINK','technorati.png','1'),(73,'ThisNext','http://www.thisnext.com/pick/new/submit/sociable/?url=PERMALINK&amp;name=TITLE','thisnext.png','0'),(74,'Tipd','http://tipd.com/submit.php?url=PERMALINK','tipd.png','0'),(75,'Tumblr','http://www.tumblr.com/share?v=3&amp;u=PERMALINK&amp;t=TITLE&amp;s=EXCERPT','tumblr.png','0'),(76,'Twitter','http://twitter.com/home?status=TITLE%20-%20PERMALINK','twitter.png','1'),(77,'Upnews','http://www.upnews.it/submit?url=PERMALINK&amp;title=TITLE','upnews.png','0'),(78,'Webnews.de','http://www.webnews.de/einstellen?url=PERMALINK&amp;title=TITLE','webnews.png','0'),(79,'Webride','http://webride.org/discuss/split.php?uri=PERMALINK&amp;title=TITLE','webride.png','0'),(80,'Wikio','http://www.wikio.com/vote?url=PERMALINK','wikio.png','0'),(81,'Wikio FR','http://www.wikio.fr/vote?url=PERMALINK','wikio.png','0'),(82,'Wikio IT','http://www.wikio.it/vote?url=PERMALINK','wikio.png','0'),(83,'Wists','http://wists.com/s.php?c=&amp;r=PERMALINK&amp;title=TITLE','wists.png','0'),(84,'Wykop','http://www.wykop.pl/dodaj?url=PERMALINK','wykop.png','0'),(85,'Xerpi','http://www.xerpi.com/block/add_link_from_extension?url=PERMALINK&amp;title=TITLE','xerpi.png','0'),(86,'YahooBuzz','http://buzz.yahoo.com/submit/?submitUrl=PERMALINK&amp;submitHeadline=TITLE&amp;submitSummary=EXCERPT&amp;submitCategory=science&amp;submitAssetType=text','yahoobuzz.png','0'),(87,'Yahoo! Bookmarks','http://bookmarks.yahoo.com/toolbar/savebm?u=PERMALINK&amp;t=TITLE&opener=bm&amp;ei=UTF-8&amp;d=EXCERPT','yahoomyweb.png','0'),(88,'Yigg','http://yigg.de/neu?exturl=PERMALINK&amp;exttitle=TITLE','yiggit.png','0'),(89,'Blogplay','http://blogplay.com','blogplay.png','0');

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) character set utf8 default NULL,
  `cs` varchar(255) character set utf8 default NULL,
  `at` varchar(255) character set utf8 default NULL,
  `ats` varchar(255) character set utf8 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('gsewzdFbaaR8Uu5eIjJoQ','cwnwR3KnJIM9zJoV8ZtEFzIFdLRALWvuMs2lKuFk','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `plugin_file` varchar(255) default NULL,
  `status` enum('0','1') default NULL,
  `option_plugin` text,
  PRIMARY KEY  (`plugin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_plugin`
--

INSERT INTO `idx_plugin` VALUES (1,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL),(2,'Sociable','sociable/sociable.php','1',NULL);

--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL auto_increment,
  `link_id` mediumint(9) unsigned NOT NULL default '0',
  `review` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `subject` varchar(100) default NULL,
  `status` char(1) default NULL,
  `username` varchar(20) default NULL,
  `name` varchar(20) default NULL,
  `email` varchar(100) default NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_review`
--


--
-- Table structure for table `idx_searchlog`
--

CREATE TABLE `idx_searchlog` (
  `keyword` varchar(100) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `result` mediumint(9) unsigned default NULL,
  `ip` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_searchlog`
--

INSERT INTO `idx_searchlog` VALUES ('eyelidplasticsurgerylosangeles.com','2011-12-02 15:58:24',2,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:04:10',2,'203.92.47.195'),('lighting55.com','2011-12-05 14:55:29',2,'203.92.47.195'),('lighting55.com','2011-12-05 15:16:02',2,'203.92.47.195'),('home business','2011-12-27 17:32:04',26,'190.142.228.29'),('GrowingStars.com','2012-02-21 04:52:52',1,'203.92.47.195');

--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL auto_increment,
  `plugin` varchar(255) default NULL,
  `set_hook_place` text,
  PRIMARY KEY  (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL auto_increment,
  `setting_name` varchar(255) default NULL,
  `setting_value` text,
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_setting`
--

INSERT INTO `idx_setting` VALUES (4,'site_name','classyweb.biz'),(5,'site_url','http://classyweb.biz'),(6,'email_address','ashlynns.moseman@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/classywe/public_html/themes/'),(9,'admin_template_path','/home/classywe/public_html/admin_tpl/'),(10,'plugin_path','/home/classywe/public_html/plugin/'),(12,'active_theme','_classyweb'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','0'),(26,'only_registered_can_add_review','0'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) NOT NULL default '',
  `category_id` mediumint(8) unsigned NOT NULL default '0',
  `total` int(11) NOT NULL default '0',
  `tag_path` varchar(64) NOT NULL,
  PRIMARY KEY  (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_tags`
--


--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL auto_increment,
  `link_id` int(11) default NULL,
  `url` varchar(255) default NULL,
  `who_is` varchar(255) default NULL,
  `note` text,
  `date` datetime default NULL,
  PRIMARY KEY  (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) default NULL,
  `record_execution` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL default '0',
  `ip` varchar(100) default NULL,
  `value` tinyint(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_votes`
--



