--
-- Host: yourhomerepair.net    Database: yourhome_indexu
-- ------------------------------------------------------


--
-- 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=InnoDB 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) collate latin1_general_ci default NULL,
  `menu_url` varchar(255) collate latin1_general_ci default NULL,
  `order_number` int(11) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_admin_menu` VALUES (1,0,'Dashboard','summary.php',0),(3,0,'Categories','cat_view.php',0),(4,3,'View/ Edit/ Delete','cat_view.php',1),(5,3,'Add New Category','cat_add.php',2),(2,1,'Summary','summary.php',1),(7,3,'Check Category Structure','cat_struc.php',4),(8,3,'Update Category Path','cat_path_update.php',5),(6,3,'Pending Category','cat_pending_suggestion.php',3),(9,3,'Set Default Price','cat_set_default_price.php',6),(10,3,'Hidden Category','cat_view_hidden.php',7),(11,3,'Registered Users Only','cat_view_registered_only.php',8),(12,3,'Search Category','cat_search.php',9),(13,0,'Links','link_search.php',0),(14,13,'Search/ Edit/ Delete','link_search.php',1),(15,13,'Add New Link','link_add.php',2),(16,13,'Validate Link','link_validate.php',3),(17,13,'Premium Listing','link_premium_listing.php',4),(18,13,'Sponsored Listing','link_sponsored_listing.php',5),(19,13,'Suspended Listing','link_suspended_listing.php',6),(20,13,'Spam Links','link_validate.php?spam=1',7),(22,13,'Update Number of Links','app_update_nol.php',9),(23,13,'Update Tag Clouds','tag_cloud_update.php',10),(21,13,'Editor Pick Links','link_editor_pick.php',8),(25,13,'Validate Reviews','review_validate.php',11),(26,13,'Discount Coupon','coupon.php',12),(27,13,'Default Field','link_default_field.php',13),(28,13,'Custom Field','link_custom_field.php',14),(29,0,'Users','user_active.php',0),(30,29,'View All','user_active.php',1),(31,29,'Add New User','user_add.php',2),(32,29,'View Suspend','user_suspend.php',3),(33,29,'View Unactive','user_active.php?pflag=Unactive',4),(34,29,'Search User','user_search.php',5),(35,0,'Editors','editor_add.php',0),(36,35,'Add New Editor','editor_add.php',1),(37,35,'Validate Editors','editor_validate.php',2),(38,0,'Invoices','inv_config.php',0),(39,38,'Configure','inv_config.php',1),(40,38,'Create An Invoice','inv_create.php',2),(41,38,'Paid Invoice','inv_paid.php',3),(42,38,'Unpaid Invoice','inv_unpaid.php',4),(43,38,'Overdue Invoice','inv_overdue.php',5),(44,38,'Payment History','pay_history.php',6),(45,0,'Mailling Systems','message_view.php',0),(46,45,'Send/ Edit/ Delete','message_view.php',1),(47,45,'Create Template','message_create.php',2),(48,45,'Mailing List Subscribers','message_subscriber.php',3),(49,0,'Templates','template_manager.php',0),(50,49,'Site Templates Manager','template_manager.php',1),(51,49,'Import Site Template','template_import.php',2),(52,49,'Export Site Template','template_export.php',3),(53,49,'Email Templates','email_template.php',4),(54,49,'Export Email Template','email_template_export.php',5),(55,49,'Import Email Template','email_template_import.php',6),(56,0,'Tools','link_duplicate.php',0),(57,56,'Find Duplicate Link','link_duplicate.php',1),(58,56,'Broken Link Report','link_bad.php',2),(59,56,'Spider Link CheckUrl','checkurl_web.php',3),(60,56,'Block Name server Domain','blocked_domain_list.php',4),(61,56,'Add Block Name server Domain','add_blocked_domain.php',5),(62,56,'Unavailable domain listing','unavailable_link_list.php',6),(63,56,'Clear Template Cache','clear_templates_c.php',7),(64,56,'PHP Configuration','phpinfo.php',8),(65,56,'Sitemap Generator','sitemap.php',9),(66,56,'Cronjobs','cronjobs.php',10),(67,56,'Fetch Meta','fetch_meta.php',11),(68,56,'Hook Place','hook_place.php',12),(69,56,'CheckUrl Result','link_checkurl.php',13),(70,56,'View Search Log','log_search.php',14),(71,56,'Bad Words Filter','badword_filter.php',15),(72,0,'Options','app_setup.php',0),(73,72,'Setup','app_setup.php',1),(74,72,'Page Caching','app_page_caching.php',2),(75,72,'Mod-rewrite','app_mod_rewrite.php',3),(76,72,'Change Password','app_change_pwd.php',4),(77,0,'Database','db_import.php',0),(78,77,'Import','db_import.php',1),(79,77,'Export','db_export.php',2),(80,77,'Backup','db_backup.php',3),(81,77,'Query','db_query.php',4),(82,77,'Find Replace','db_find_replace.php',5),(83,0,'Plugins','plugin_listing.php',0),(84,83,'View All','plugin_listing.php',1);

--
-- 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) collate latin1_general_ci NOT NULL default '',
  `email` varchar(50) collate latin1_general_ci 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 COLLATE=latin1_general_ci;

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


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

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

--
-- 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) collate latin1_general_ci default NULL,
  `type` enum('domain','ip') collate latin1_general_ci default NULL,
  PRIMARY KEY  (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL default '',
  `description` text collate latin1_general_ci NOT NULL,
  `image` varchar(100) collate latin1_general_ci default NULL,
  `content` text collate latin1_general_ci,
  `visible` char(1) collate latin1_general_ci default NULL,
  `links` mediumint(9) default NULL,
  `meta_keyword` text collate latin1_general_ci,
  `meta_description` text collate latin1_general_ci,
  `permission` char(2) collate latin1_general_ci default NULL,
  `registered_only` char(1) collate latin1_general_ci default NULL,
  `header` text collate latin1_general_ci NOT NULL,
  `footer` text collate latin1_general_ci NOT NULL,
  `related` mediumint(6) NOT NULL default '0',
  `page_title` varchar(200) collate latin1_general_ci 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=32 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_category` VALUES (1,0,'Bathrooms Accents','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Buying Home','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Carpet Cleaning','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Climate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Conservatory Home Furniture','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Constructions & Maintenace','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Decor','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Domestic Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Doors & Windows','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Electrical Supplies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Energy','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Exterior Design ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Flooring','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Furniture Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Home & Garden','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Home Appliances','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home Atomation Systems','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Business Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Home Decor','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Home Shopping','','folder.gif','','1',0,'','','0','0','','',0,'',1,0,0,0,0),(21,0,'Home Storage','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Interior Decor','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Kitchens Accessories','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Lights','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Painting & Decorating','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Plumbing Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Restorage','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Safety','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Trading','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Wall Decor','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Welding Services','','folder.gif','','1',0,'','','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 collate latin1_general_ci,
  `path_with_url` text collate latin1_general_ci,
  `parents` text collate latin1_general_ci,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_category_path` VALUES (1,'Bathrooms Accents','<a href=\"http://yourhomerepair.net/bathrooms-accents/\" name=\"cat_1\" style=\"\">Bathrooms Accents</a>',';0;'),(2,'Buying Home','<a href=\"http://yourhomerepair.net/buying-home/\" name=\"cat_2\" style=\"\">Buying Home</a>',';0;'),(3,'Carpet Cleaning','<a href=\"http://yourhomerepair.net/carpet-cleaning/\" name=\"cat_3\" style=\"\">Carpet Cleaning</a>',';0;'),(4,'Climate','<a href=\"http://yourhomerepair.net/climate/\" name=\"cat_4\" style=\"\">Climate</a>',';0;'),(5,'Conservatory Home Furniture','<a href=\"http://yourhomerepair.net/conservatory-home-furniture/\" name=\"cat_5\" style=\"\">Conservatory Home Furniture</a>',';0;'),(6,'Constructions & Maintenace','<a href=\"http://yourhomerepair.net/constructions-maintenace/\" name=\"cat_6\" style=\"\">Constructions & Maintenace</a>',';0;'),(7,'Decor','<a href=\"http://yourhomerepair.net/decor/\" name=\"cat_7\" style=\"\">Decor</a>',';0;'),(8,'Domestic Supplies','<a href=\"http://yourhomerepair.net/domestic-supplies/\" name=\"cat_8\" style=\"\">Domestic Supplies</a>',';0;'),(9,'Doors & Windows','<a href=\"http://yourhomerepair.net/doors-windows/\" name=\"cat_9\" style=\"\">Doors & Windows</a>',';0;'),(10,'Electrical Supplies','<a href=\"http://yourhomerepair.net/electrical-supplies/\" name=\"cat_10\" style=\"\">Electrical Supplies</a>',';0;'),(11,'Energy','<a href=\"http://yourhomerepair.net/energy/\" name=\"cat_11\" style=\"\">Energy</a>',';0;'),(12,'Exterior Design ','<a href=\"http://yourhomerepair.net/exterior-design/\" name=\"cat_12\" style=\"\">Exterior Design </a>',';0;'),(13,'Flooring','<a href=\"http://yourhomerepair.net/flooring/\" name=\"cat_13\" style=\"\">Flooring</a>',';0;'),(14,'Furniture Services','<a href=\"http://yourhomerepair.net/furniture-services/\" name=\"cat_14\" style=\"\">Furniture Services</a>',';0;'),(15,'Home & Garden','<a href=\"http://yourhomerepair.net/home-garden/\" name=\"cat_15\" style=\"\">Home & Garden</a>',';0;'),(16,'Home Appliances','<a href=\"http://yourhomerepair.net/home-appliances/\" name=\"cat_16\" style=\"\">Home Appliances</a>',';0;'),(17,'Home Atomation Systems','<a href=\"http://yourhomerepair.net/home-atomation-systems/\" name=\"cat_17\" style=\"\">Home Atomation Systems</a>',';0;'),(18,'Home Business Services','<a href=\"http://yourhomerepair.net/home-business-services/\" name=\"cat_18\" style=\"\">Home Business Services</a>',';0;'),(19,'Home Decor','<a href=\"http://yourhomerepair.net/home-decor/\" name=\"cat_19\" style=\"\">Home Decor</a>',';0;'),(20,'Home Shopping','<a href=\"http://yourhomerepair.net/home-shopping/\" name=\"cat_20\" style=\"\">Home Shopping</a>',';0;'),(21,'Home Storage','<a href=\"http://yourhomerepair.net/home-storage/\" name=\"cat_21\" style=\"\">Home Storage</a>',';0;'),(22,'Interior Decor','<a href=\"http://yourhomerepair.net/interior-decor/\" name=\"cat_22\" style=\"\">Interior Decor</a>',';0;'),(23,'Kitchens Accessories','<a href=\"http://yourhomerepair.net/kitchens-accessories/\" name=\"cat_23\" style=\"\">Kitchens Accessories</a>',';0;'),(24,'Lights','<a href=\"http://yourhomerepair.net/lights/\" name=\"cat_24\" style=\"\">Lights</a>',';0;'),(25,'Painting & Decorating','<a href=\"http://yourhomerepair.net/painting-decorating/\" name=\"cat_25\" style=\"\">Painting & Decorating</a>',';0;'),(26,'Plumbing Services','<a href=\"http://yourhomerepair.net/plumbing-services/\" name=\"cat_26\" style=\"\">Plumbing Services</a>',';0;'),(27,'Restorage','<a href=\"http://yourhomerepair.net/restorage/\" name=\"cat_27\" style=\"\">Restorage</a>',';0;'),(28,'Safety','<a href=\"http://yourhomerepair.net/safety/\" name=\"cat_28\" style=\"\">Safety</a>',';0;'),(29,'Trading','<a href=\"http://yourhomerepair.net/trading/\" name=\"cat_29\" style=\"\">Trading</a>',';0;'),(30,'Wall Decor','<a href=\"http://yourhomerepair.net/wall-decor/\" name=\"cat_30\" style=\"\">Wall Decor</a>',';0;'),(31,'Welding Services','<a href=\"http://yourhomerepair.net/welding-services/\" name=\"cat_31\" style=\"\">Welding Services</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) collate latin1_general_ci default NULL,
  `category_description` text collate latin1_general_ci,
  `date` datetime default NULL,
  PRIMARY KEY  (`id_cat_suggession`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL default '',
  `reciprocal_found` char(1) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `filename` varchar(255) collate latin1_general_ci NOT NULL,
  `schedule` varchar(255) collate latin1_general_ci NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL default '',
  `field_text` varchar(64) collate latin1_general_ci NOT NULL default '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') collate latin1_general_ci NOT NULL default 'TEXT',
  `field_option` text collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `required` char(1) collate latin1_general_ci NOT NULL default '0',
  `searchable` char(1) collate latin1_general_ci NOT NULL default '1',
  `permission` char(1) collate latin1_general_ci NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL,
  `required` char(1) collate latin1_general_ci NOT NULL,
  `visible` char(1) collate latin1_general_ci NOT NULL default '1',
  `searchable` char(1) collate latin1_general_ci NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `coupon_value` varchar(50) collate latin1_general_ci default NULL,
  `link_type` varchar(255) collate latin1_general_ci 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 COLLATE=latin1_general_ci;

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


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

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

--
-- 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) collate latin1_general_ci default NULL,
  `subject` varchar(255) collate latin1_general_ci default NULL,
  `body` text collate latin1_general_ci,
  `altbody` text collate latin1_general_ci,
  PRIMARY KEY  (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_email_template` VALUES (1,'add_ok','Resource Added','<div style=\"font-weight:bold;\">Thank you for your submission to <%$site_name%></div>\r\n<p>\r\n<div style=\"float:left;width:200px;\">Resource ID</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$link_id%></div>\r\n<div style=\"float:left;width:200px;\">Title</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$title%></div>\r\n<div style=\"float:left;width:200px;\">Url</div>\r\n<div style=\"float:left;width:10px;\">  : </div>\r\n<div style=\"float:left;width:200px;\"><%$url%></div>\r\n<div style=\"float:left;width:200px;\">Description </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$description%></div>\r\n<div style=\"float:left;width:200px;\">Category </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$category%></div>\r\n<div style=\"float:left;width:200px;\">Contact name</div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$contact_name%></div>\r\n<div style=\"float:left;width:200px;\">Email</div>\r\n<div style=\"float:left;width:10px;\">  : </div>\r\n<div style=\"float:left;width:200px;\"><%$email%></div>\r\n<div style=\"float:left;width:200px;\">Password </div>\r\n<div style=\"float:left;width:10px;\"> : </div>\r\n<div style=\"float:left;width:200px;\"><%$password%></div>\r\n<p>\r\nYour link has been added.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n','Thank you for your submission to <%$site_name%>\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nPassword     : <%$password%>\r\nYour link has been added.\r\nRegards,\r\n<%$site_name%> Team'),(2,'add_ok_editor','Resource Added','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has been added.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n</div>','There\'s a new submission to <%$site_name%>.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has beed added.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(3,'add_ok_subscriber','Resource Added','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThere\'s a new submission to <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(4,'add_pending','Pending Resource','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYour link will be reviewed by our team. We will contact you as soon <br>\r\nas we have reviewed your link.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(5,'add_pending_editor','Pending Resource','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYou need to review this link here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/editor_link_validate.php\"><%$site_url%>/cp/editor_link_validate.php</a></label><br>\r\nYou can approve this submission by clicking here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$approve_notice%>\"><%$approve_notice%></a></label><br>\r\nYou can reject this submission by clicking here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$reject_notice%>\"><%$reject_notice%></a></label><br>\r\nSilent reject here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$reject_silent%>\"><%$reject_silent%></a></label><br>\r\n\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nYou can approve this submission by clicking here:\r\n<%$approve_notice%>\r\nYou can reject this submission by clicking here:\r\n<%$reject_notice%>\r\nSilent reject here:\r\n<%$reject_silent%>\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n'),(6,'approved','Editor Approved.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour submission at <b><%$site_name%></b> has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Password </td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your submission at <%$site_name%> has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nPassword     : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(7,'approved_editor','Link approved','<div style=\"font-family:arial;font-size:12px;\">\r\nThe following submission has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','The following submission has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(8,'approved_subscriber','link_approved','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThe following submission has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Resource ID</td><td style=\"width:10px;\">:</td><td ><%$link_id%></td></tr>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThe following submission has been approved.\r\nResource ID  : <%$link_id%>\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(9,'bad_link_editor','Broken link report','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new bad link report submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Name</td><td style=\"width:10px;\">:</td><td ><%$r_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Error type</td><td style=\"width:10px;\">:</td><td ><%$type_val%></td></tr>\r\n</table>\r\n<p>\r\nThis report has been added in your administrator area.<br>\r\nPlease review this report here:<br>\r\n<a href=\"<%$site_url%>/admin/link_bad.php\"><%$site_url%>/admin/link_bad.php</a>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new bad link report submission to <%$site_name%>.\r\nTitle       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\nCategory    : <%$category%>\r\nName        : <%$r_name%>\r\nEmail       : <%$r_email%>\r\nError type  : <%$type_val%>\r\nThis report has been added in your administrator area.\r\nPlease review this report here:\r\n<%$site_url%>/admin/link_bad.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(10,'become_editor_approved','Editor Approved.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour request to become an editor at <b><%$site_name%></b> has been approved.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your request to become an editor at <%$site_name%> has been approved.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(11,'become_editor_pending','Request to become an editor','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your request to become an editor at <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\nYour request will be processed soon.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your request to become an editor at <%$site_name%>.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nYour request will be processed soon.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(12,'become_editor_pending_admin','Request to become an editor','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new request to become an editor at <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\nPlease review editor request here:\r\n  <label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/admin/index.php\"><%$site_url%>/admin/index.php</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new request to become an editor at <%$site_name%>.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nPlease review editor requests here:\r\n<%$site_url%>/admin/index.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(13,'become_editor_rejected','Editor Rejected.','<div style=\"font-family:arial;font-size:12px;\">\r\nYour request to become an editor at <b><%$site_name%></b> has been rejected.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Name </td><td style=\"width:10px;\">:</td><td ><%$name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n<tr><td style=\"width:100px;\">Category </td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your request to become an editor at <%$site_name%> has been rejected.\r\nUsername  : <%$username%>\r\nName      : <%$name%>\r\nEmail     : <%$email%>\r\nCategory  : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(14,'inv_ask_payment','<%$company%>, Invoice #<%$invoice_id%>','<div style=\"font-family:arial;font-size:12px;\">\r\nAn invoice has been created, and is available for viewing at the following URL:<br>\r\n<label><a href=\"<%$site_url%>/invoice.php?id=<%$invoice_id%>\"><%$site_url%>/invoice.php?id=<%$invoice_id%></a></label>\r\n<p>\r\nIf you should have any questions, please do not hesitate to contact us.<br>\r\nThank you for your business.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','An invoice has been created, and is available for viewing at the following URL:\r\n<%$site_url%>/invoice.php?id=<%$invoice_id%>\r\nIf you should have any questions, please do not hesitate to contact us.\r\nThank you for your business.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(15,'mailing_list_sub','Mailing list subscription','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you. Your email address, <b><%$email%></b> has been added to our mailing list.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<%$site_name%> Team\r\n</div>','Thank you. Your email address, <%$email%> has been added to our mailing list.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(16,'mailing_list_sub_confirm','Mailing list validation code','<div style=\"font-family:arial;font-size:12px;\">\r\nWe received your subscription request onto our mailing list.<br>\r\nPlease confirm your subscription here:<br>\r\n<label style=\"margin-left:50px;\"><a href=\"<%$confirm_url%>\"><%$confirm_url%></a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','We received your subscription request onto our mailing list.\r\nPlease confirm your subscription here:\r\n<%$confirm_url%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(17,'modify_ok','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%></b>.\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nYour link has been changed.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link has been changed.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(18,'modify_ok_editor','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(19,'modify_ok_subscriber','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nYou are receiving this email because you have a subscription for update notifications in <b><%$category%></b> category.\r\n<p>\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(20,'modify_pending','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThank you for your submission to <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\nYour link will be reviewed by our team. We will contact you as soon <br>\r\nas we have reviewed your link.\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thank you for your submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(21,'modify_pending_editor','Resource Modified','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new submission to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nYou need to review this link here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/editor_link_validate.php\"><%$site_url%>/cp/editor_link_validate.php</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(22,'register_confirm','Registration','<div style=\"font-family:arial;font-size:12px;\">\r\nThanks for joining <b><%$site_name%><b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nPlease confirm your registration here:<br>\r\n<label style=\"margin-left:10px;\"><A href=\"<%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf\"><%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf</a></label>\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nPlease confirm your registration here:\r\n<%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(23,'register_ok','Registration','<div style=\"font-family:arial;font-size:12px;\">\r\nThanks for joining <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\nSincerely,\r\n<p>\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(24,'rejected','Your submission has been rejected','<div style=\"font-family:arial;font-size:12px;\">\r\nYour submission has been rejected.<br>\r\nThis may be caused by one of the following reason:\r\n<p>\r\n<ul>\r\n<li>adult material</li>\r\n<li>the site is under construction</li>\r\n<li>the topic is not related with our directory</li>\r\n</ul>\r\n</p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email/td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your submission has been rejected.\r\nThis may caused by one of the following reasons:\r\n- adult material\r\n- the site is under construction\r\n- the topic is not related with our directory\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(25,'rejected_editor','Link rejected','<div style=\"font-family:arial;font-size:12px;\">\r\nThe following submission has been rejected.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n<tr><td style=\"width:100px;\">Contact name</td><td style=\"width:10px;\">:</td><td ><%$contact_name%></td></tr>\r\n<tr><td style=\"width:100px;\">Email</td><td style=\"width:10px;\">:</td><td ><%$email%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','The following submission has been rejected.\r\nTitle        : <%$title%>\r\nUrl          : <%$url%>\r\nDescription  : <%$description%>\r\nCategory     : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail        : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(26,'review_pending_editor','Pending Review','<div style=\"font-family:arial;font-size:12px;\">\r\nThere\'s a new review to <b><%$site_name%></b>.\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n<tr><td style=\"width:100px;\">Category</td><td style=\"width:10px;\">:</td><td ><%$category%></td></tr>\r\n</table>\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Subject</td><td style=\"width:10px;\">:</td><td ><%$rev_subject%></td></tr>\r\n<tr><td style=\"width:100px;\">Rating</td><td style=\"width:10px;\">:</td><td ><%$rev_rating%></td></tr>\r\n<tr><td style=\"width:100px;\">Review</td><td style=\"width:10px;\">:</td><td ><%$rev_review%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nPlease review it here:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/cp/\"><%$site_url%>/cp/</a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>\r\n','There\'s new review to <%$site_name%>.\r\nTitle       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\nCategory    : <%$category%>\r\nUsername    : <%$username%>\r\nSubject     : <%$rev_subject%>\r\nRating      : <%$rev_rating%>\r\nReview      : <%$rev_review%>\r\nPlease review it here:\r\n<%$site_url%>/cp/\r\nRegards,\r\n<%$site_name%> Team\r\n'),(27,'send_pwd_link','Your resource password','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your password for <b><%$title%></b> (<a href=\"<%$url%>\"><%$url%></a>)\r\n<p>\r\nPassword : <%$password%>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your password for <%$title%> (<%$url%>)\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(28,'send_pwd_login','Your login password','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your username and password:\r\n<p>\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Username</td><td style=\"width:10px;\">:</td><td ><%$username%></td></tr>\r\n<tr><td style=\"width:100px;\">Password</td><td style=\"width:10px;\">:</td><td ><%$password%></td></tr>\r\n</table>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your username and password:\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(29,'send_pwd_reset','Password reset request','<div style=\"font-family:arial;font-size:12px;\">\r\nWe received a request to reset your password.<br>\r\nPlease visit this URL to proceed:<br>\r\n<label style=\"margin-left:10px;\"><a href=\"<%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%>\"><%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%></a></label>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','We received a request to reset your password.\r\nPlease visit this URL to proceed:\r\n<%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(30,'suggest_category','Category suggestion','<div style=\"font-family:arial;font-size:12px;\">\r\nCategory suggestion for <b><%$site_name%></b>.\r\n<p>\r\nParent               : <%$parent%>\r\nCategory Name        : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Category suggestion for <%$site_name%>.\r\nParent               : <%$parent%>\r\nCategory Name        : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(31,'tell_friend_favorite','Your friend has shared his/her favorite listing','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <%$friend_name%>,\r\n<p>\r\nI\'d like to share my favorite listing at <b><%$site_name%></b> (<a href=\"<%$site_url%>\"><%$site_url%></a>).<br>\r\nI hope you like them and find them useful.\r\n<p>\r\n<p>\r\n<%$fav_item%>\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>','Hi <%$friend_name%>,\r\nI\'d like to share my favorite listings at <%$site_name%> (<%$site_url%>).\r\nI hope you like them and find them useful.\r\n<%$fav_item%>\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(32,'tell_friend_favorite_rows',NULL,'<div style=\"font-family:arial;font-size:12px;\">\r\n<table cellspacing=0 cellpadding=0>\r\n<tr><td style=\"width:100px;\">Title</td><td style=\"width:10px;\">:</td><td ><%$title%></td></tr>\r\n<tr><td style=\"width:100px;\">Url</td><td style=\"width:10px;\">:</td><td ><%$url%></td></tr>\r\n<tr><td style=\"width:100px;\">Description</td><td style=\"width:10px;\">:</td><td ><%$description%></td></tr>\r\n</table>\r\n</div>\r\n','Title       : <%$title%>\r\nUrl         : <%$url%>\r\nDescription : <%$description%>\r\n'),(33,'tell_friend_link','Your friend recommended a link','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <b><%$friend_name%></b>,\r\n<p>\r\nI found a good website that you may find interesting.\r\n<p>\r\n<div>\r\n<label style=\"float:left;width:100px;\">Website</label><label style=\"float:left;\"> : <b><%$title%></b></label>\r\n</div>\r\n<div style=\"clear:both;\">\r\n<label style=\"clear:both;float:left;width:100px;\">Url </label><label style=\"float:left;\"> : <a href=\"<%$url%>\"><%$url%></a></label>\r\n</div>\r\n<p style=\"clear:both;\">\r\nI found this website from <%$site_name%> (<a href=\"<%$site_url%>\"><%$site_url%></a>).\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>\r\n','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting.\r\nWebsite : <%$title%>\r\nUrl     : <%$url%>\r\nI found this website from <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(34,'tell_friend_website','hi <%$friend_name%>, I found a good website that you may find interesting','<div style=\"font-family:arial;font-size:12px;\">\r\nHi <b><%$friend_name%></b>,\r\n<p>\r\nI found good website that you may find interesting. The website is <b><%$site_name%></b> (<a href=\"<%$site_url%>\"><%$site_url%></a>).\r\n<p>\r\n<p>\r\nSincerely,\r\n<p>\r\n<%$my_name%> <<%$my_email%>>\r\n</div>','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting. The website is <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(35,'send_activation_link','Your activation link','<div style=\"font-family:arial;font-size:12px;\">\r\nHere is your activation link\r\n<p>\r\nActivation Link  : <A href=\"<%$activation_link%>\"><%$activation_link%></a>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Here is your activation link\r\nActivation Link  : <%$activation_link%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(36,'send_activated_account','Your account had been activated','<div style=\"font-family:arial;font-size:12px;\">\r\nYour account had been activated. Now you can login.\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>','Your account had been activated. Now you can login.\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n');

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

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

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

INSERT INTO `idx_favorites` VALUES (1,'qcalebnorrisf','2012-02-12','My Favorites',NULL),(2,'pmelanirodgersi','2012-02-14','My Favorites',NULL),(3,'imolliechurcht','2012-02-14','My Favorites',NULL),(4,'lderekwangi','2012-02-15','My Favorites',NULL),(8,'unelsonlaneg','2012-02-16','My Favorites',NULL),(9,'pjackysiv','2012-02-19','My Favorites',NULL),(11,'aangeliascott','2012-03-13','',NULL),(12,'1simonpeterson1','2012-03-13','',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 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `hookname` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

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

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


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

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

--
-- 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`
--

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

--
-- Dumping data for table `idx_link`
--


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

CREATE TABLE `idx_link_temp` (
  `vid` mediumint(9) unsigned NOT NULL auto_increment,
  `spam` char(1) collate latin1_general_ci NOT NULL default '0',
  `link_id` mediumint(9) default NULL,
  `category_id` mediumint(9) unsigned NOT NULL default '0',
  `title` varchar(100) collate latin1_general_ci NOT NULL default '',
  `url` text collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  `contact_name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `email` varchar(100) collate latin1_general_ci 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) collate latin1_general_ci default NULL,
  `hot` char(1) collate latin1_general_ci default NULL,
  `top_rated` char(1) collate latin1_general_ci default NULL,
  `pick` char(1) collate latin1_general_ci default NULL,
  `password` varchar(20) collate latin1_general_ci default NULL,
  `updated` char(1) collate latin1_general_ci default NULL,
  `reviews` smallint(6) default NULL,
  `avg_review` float(4,2) default NULL,
  `last_updated` datetime default NULL,
  `official_review` text collate latin1_general_ci,
  `keywords` varchar(255) collate latin1_general_ci default NULL,
  `cat1` mediumint(6) NOT NULL default '0',
  `cat2` mediumint(6) NOT NULL default '0',
  `suspended` char(1) collate latin1_general_ci NOT NULL default '0',
  `reciprocal_url` varchar(255) collate latin1_general_ci default NULL,
  `address` varchar(255) collate latin1_general_ci default NULL,
  `city` varchar(255) collate latin1_general_ci default NULL,
  `state` varchar(255) collate latin1_general_ci default NULL,
  `country` varchar(255) collate latin1_general_ci default NULL,
  `zip` varchar(255) collate latin1_general_ci default NULL,
  `image` varchar(255) collate latin1_general_ci default NULL,
  `phone` varchar(255) collate latin1_general_ci default NULL,
  `fax` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

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

--
-- 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 collate latin1_general_ci,
  `subject` varchar(100) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

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

--
-- 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) collate latin1_general_ci 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 COLLATE=latin1_general_ci;

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


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

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

--
-- 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) collate latin1_general_ci default NULL,
  `enable` char(1) collate latin1_general_ci default NULL,
  `setting` text collate latin1_general_ci,
  `invoice_html` text collate latin1_general_ci,
  PRIMARY KEY  (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `email` varchar(255) collate latin1_general_ci default NULL,
  `type` varchar(255) collate latin1_general_ci default NULL,
  `detail` text collate latin1_general_ci,
  `amount` double default NULL,
  `time` datetime default NULL,
  `invoice_id` varchar(10) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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_plugin`
--

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

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

INSERT INTO `idx_plugin` VALUES (1,'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 collate latin1_general_ci NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `subject` varchar(100) collate latin1_general_ci default NULL,
  `status` char(1) collate latin1_general_ci default NULL,
  `username` varchar(20) collate latin1_general_ci default NULL,
  `name` varchar(20) collate latin1_general_ci default NULL,
  `email` varchar(100) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


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

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

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


--
-- Table structure for table `idx_sessions`
--

CREATE TABLE `idx_sessions` (
  `SESSKEY` varchar(32) collate latin1_general_ci NOT NULL default '',
  `EXPIRY` int(11) unsigned NOT NULL default '0',
  `EXPIREREF` varchar(64) collate latin1_general_ci default NULL,
  `DATA` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`SESSKEY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_sessions`
--

INSERT INTO `idx_sessions` VALUES ('84e13e41dea99cf7fcb2305154e443cb',1331879955,NULL,'JcJ5yEx_jLef381RTFdXeAjqdbY5X9hTuhDMQTgO30YqexR_2mt4IKQS6lkK4CNWmEI1pLaTjedhlQ9bPZOTu8nZEOOY2Bv2SdAc0aqgYTMrgwSPtN2sLZPwZyR2_yUWlk25qmnnJv9rmqrME_q7-f37iVgO-wHaW_yyMIq1KDg.'),('c4b3a682e6b8b6e69507e1466872a28d',1331879963,NULL,'RcZgOM201FIZ9rupc5rVR5SjH8XPmt2i6YSAytI1-7qx_D02lLzcL8w9uw108HBkgZJnZ6qRDUPUJAu9bWND8BGKKtObJAmKNsh5iCpGE-vQrK9yt3nT98n5zKim3W7S-HsnEKZd8E6hB62bFW2IUW6morirGFoHJ7XO4UNlyIA.'),('bf5b5dc978ffac2e8698eceedd9e3fba',1331879969,NULL,'9iHuNH4Sdjz4aTic-jiQC4xK9GDnOkXuuOFPhVZ-CO65Kv4yYuLm7EBGbAOSfo9YSCww5rKko3Q6T200Y5GMx5sgie-9_9mqwMOsAZwdW98L7466ZOS_YsUCP-5QSWPFBqPaKE82LHYrDNNtw1tByYCMq9lxilKKAOidQLuNUO7yYSEN0c6i2PwEehcPjHel'),('f5492df130dbe2686184ba28220ec3f4',1331879971,NULL,'9iHuNH4Sdjz4aTic-jiQC4xK9GDnOkXuuOFPhVZ-CO65Kv4yYuLm7EBGbAOSfo9YSCww5rKko3Q6T200Y5GMx5sgie-9_9mqwMOsAZwdW98L7466ZOS_YsUCP-5QSWPFBqPaKE82LHYrDNNtw1tByYCMq9lxilKKAOidQLuNUO7yYSEN0c6i2PwEehcPjHel'),('4d90148434720e69bcb423785e04a0fd',1331879980,NULL,'i0LyQd5dfAlIgHxfA_IeehLCf2dZ7sj3DqjuVsl0AD6hU1eWRhOjlmu3OWcew0E6ItHPJzip9ZJcHVgQUMNjR8pw1NEjGNrNeucu2pvD0Pr2vDZS5nUNhSXNydzOjz6wXt4IBThfOD3J3GuCU2D6BI81uT1zHCbHMmVFpW9W-vk.'),('7336421f1b2028a4a2938321a3e0c21e',1331879982,NULL,'7qY7DcKn46K7ibnh53P_g1JzOUePV_J88C2envstYD9j12KHbsXYrZUBvkEl2FjePPRerKpOIK0c_PXZ-6ND-cixynx3lIWxpVqpjzQefKLCGsVszDDQWqkSidA1NXIJx11AS8GaNvKnAeCjdRGnV246VCiAIM7AeoDmvFfqeit8xXmg3yA9qnk4irBBsz48'),('d9845ee9d6136932a0a00d923aca89a6',1331879988,NULL,'N0VExfC79xKhwJzEAphNlG5T0E1I0oOfuIt1IX2JnahE8fpElJQRD7tv9cCKzcEZ0HzYM_-5oknNLdp9y-JAs1Kip15-ddxqCE59R_7rJ7jW-4QTl1xsJ5ddJHSbUS1_xYixdDc86lcCesC-NAp4hpWvZpt61P4ZbCK-RqaIsLflXh3RVBnhieabtpvZk1rS'),('da15b80f0a5c01f7027ef4de0752dea2',1331879993,NULL,'-woNCC1rWthJUteh-0VPGGGrKjSuopS3OIMhLy7MOXle2QgQxp9gErgBMZfu6_Fkp85WIgt6eS-6uLNHqoH0l2Q_Nri3VoupyWO6NHNZ7KowVkg1ZvxWqZ4Jnpj-HUZROP8tY_hf7rXGSIs9WUrw8l1ssUYtYRsa0ah1rWVxHSc.'),('5824df14d0e5a55b59a48297be9fe584',1331879999,NULL,'H9NaxXLafpvPjf8HZLocg2ywS1ErQ1SoY4AvBfBCpBfIWc3ywS1KpBGuII7CK11Eusp0hyUQoRpmnFbfdOEXGriDFadwhc6vF35PnyhVgbplKF2b5nXpuIQ8-ogQcmCpCLwxjabfpVXFsNSSmcnPcHFZQtVypmwnaxUDj_FrNQxYxWoRBI1etIGhdW9MMdAj'),('381bb0c7bdfca8c51bca60ce5eebd488',1331880003,NULL,'2Tpxm05g6KPd3Hs_WVZul3aTnJ3A8BBQQYNgpK6bzfO5RfudWFBbouaW8zht9t-2KHjT-qXDPJrsroITwI3MWASt5CDjti677GUQgVP7OtdB8AfuiF2NHf0qacU5YGfJecp2KBqAC1OTExEqLavUifqPpiP4E477MImMXVyJ9NQ1ZFwgo2PGsLLd6dK4ID2H'),('26f26afede05bacc68a2cf7a70f7fd11',1331880007,NULL,'fQPaIlqcrMs_wf8UwJV_0V8cSPx4cZfAxljnaTBkdUkczC6Wf0WEVFHcUIChTHNwaqOG7JeSJKNv9IALHfXlRQp3vvlnSg7sA43R-q72TLg1yEDwhaF4zmVDSp3EmO-cbbktbeNNR14OiJQvK0BJyB0h7XaEd_iZVWBhTqyzJL2VXTX2D64BI9TaDyva6aYr'),('b0b0b8c707825838b4ed85e2569b1016',1331880014,NULL,'ZiEY_HGHppWAh18YEjTZ6YtzO7y4zWxC4iwmWNaLJCuxIpc29tweBy5jFxV25QIxNoRo5XE3w_1uhv1hy_sc-Ymxng_84wja_6p_yyXaf8AIgOW4gkaI4e1iDc88XadrBkRBH6onA6buvLWgoUZtD2wq3aINYV_6DwaD4-0BID_y7S3d6rL9bSoxeIQ1hlTZ'),('134472aa741ec66b57b7d481d152bd6b',1331880017,NULL,'n5XejAD2rXhi5h2JdB_1u9woK2DmmjFYiL_T7CtFgQfmWNS3dEJtBmZeDpdLT72IncoTsuTZXto1s0ZkDdsHdEYd6R9vBJTh6Rb6uGP0ROQtbcQpDWwL4z4LhNF4mTbUoZ7tKip4xZ9m3sJOO_QqLg3FU2mAL4rstfGmGNs_7C60Ev2wLsqj9IauCOL7bPqH'),('b1a7fe256cf805ac044841bcc227b3b3',1331880021,NULL,'HSTOljojFeC54EpBHwiJpl0LY-Bso5D5suGehCUHuwosI-WG6szQILnHZ1XUXKwNumqI7okQ82UiZmsTajzm8-h9NPrrEOBl2hdjwGGuPlhAbkeX0vDwxqj78ZU5oNSwJw-G_yS3mByWDC0ugAsCFdYLPdHz-6JSSPjnArbCUWB5jn6yh4py2qvBCNCCMkoC'),('82e781a81b2a9259c510c4bd2a58cf97',1331880026,NULL,'EohMu18JWFnYDr7CjPcly1TWSPZHS0LcZPBW6l5qI88D5uBGqn_c7iPfTtP869rf0AqMQSRQm4saoVPUqeU1B2mR5uq3r49FM_k35AN1bOfDQMrJoVVhxATHCM5okQ5rlp4tLGAFnK4KzXGQbcFvKaIV2Kl0b97yDyvOf9JJJ9nFe0-S3zaVMld_czREkDwN'),('b408e5d351f9e58952be5c94c8af8cc4',1331880030,NULL,'LgbIBI8cieJGP8s_I-9lVQJNUg3MPjZwV7jTUWxq7aBy8LBqGuR1rrZ9GRNmCq2yCMRe6cB7XbUhHnlPWGDrXBcjA8shw5f9togY4btLNw-qEW8l8XmukCBcGb6IBRfuUuwKHlYfz1ZAX7m6CbQkwQtFubVCnAm-RfBjjjhePS0.'),('bfe3b92b08cefc2bdf723e1f2926b1a8',1331880034,NULL,'MnqJ-a-td5ja_tc06LzvfZUQTDkeXmpxfkGaFNnNx0JDlR1H0y1oOh-nx56QxlAZP5WXRgKM8trvHTLg5JRXzEgLDmCKt7Da7BxPkgJMB-vz4YnMFypsBJcoNsvsd4WakjpVv_k0IrV46a1t_TPJ5kBXRTSK8oTOMbCJPv5sBw13CgShHEw-gyqRmaNgTvzC'),('ee9cf04cd899200a6aa21bb9e70ad25c',1331880038,NULL,'ZOul36k3m3e0AVa-W_qXH4DsILwawXj3P_Er6UJg7iboORrH-M9jZFC-svsM8YpO_LT5ki9M5bOxeGLoCUrtGYv5A6k5dHNVyaeJy36mm4Wv_EXL0z5z2HIhenhv2r8amuf41m4Cm0jgKPGALhkBIKtzIpqT8dlUoc-ko7CEVdIr37th0wbJSAIyAQPo4Rij'),('bf5db394d5c689bd2fb94eb71072885f',1331880043,NULL,'AxCT5B8eNIPspMYjreV9Eb8InjdR0dsNVo_WSjVhs8XqADX-lNi_-DTf17Ih2EP0GiTI6QQAjL8w-YkamG6U5RRp3YverhziRcSMHJDVR5_sKiXjtAZgt6XScfuhNjGFZIlnC3yGkHQpG1r3Ukb-YgV9O6qsnDojYUU_fsq55TM.'),('a560304e37ce8d0f3154b4e3ec79a3fc',1331880046,NULL,'wSNqzJtbm_FJZMWPl1nVErp1WTUXEgd8qz63qFcW0fcIZTnkEr9JxgH7Xo3esC2h-3s9mdAfPiRsfUKNNV0Wz1CUMLdk7b7Jry6aE4VR5RT18-mcHpKZXfDj_3WKTMXddVFkloUIZb24YA8ebqxyxNCkCbX_UIbfjkLDDqrX4ELbWlf9540rUkBoXMnKqOAU'),('df0ef723aab9ebdf8827c1d384923c38',1331880051,NULL,'NEfta2WgiDEc7OQTbW2-Y9hXreTg4MzO6PugIPAhgIuhNnx4mcWgohVwbsYVPcA7yzw23OaYMY8o75AHkaxVIShDSfPu4Ehtky_SL5A3jOw_I1uocCpPMmw51z9tdTpgoOzrNTWG-SEOAKQHtBOP5NACCO_Db86eij3lw-I8D9FWfO_v2gNH68rE5Sn1Yo6B'),('01de0f9868ae0c37ce12e2840975ba3f',1331880056,NULL,'n5XejAD2rXhi5h2JdB_1u9woK2DmmjFYiL_T7CtFgQfmWNS3dEJtBmZeDpdLT72IncoTsuTZXto1s0ZkDdsHdEYd6R9vBJTh6Rb6uGP0ROQtbcQpDWwL4z4LhNF4mTbUoZ7tKip4xZ9m3sJOO_QqLg3FU2mAL4rstfGmGNs_7C60Ev2wLsqj9IauCOL7bPqH'),('8fde60c1200552ba6f6d31a1c4a9c669',1331880062,NULL,'ZiEY_HGHppWAh18YEjTZ6YtzO7y4zWxC4iwmWNaLJCuxIpc29tweBy5jFxV25QIxNoRo5XE3w_1uhv1hy_sc-Ymxng_84wja_6p_yyXaf8AIgOW4gkaI4e1iDc88XadrBkRBH6onA6buvLWgoUZtD2wq3aINYV_6DwaD4-0BID_y7S3d6rL9bSoxeIQ1hlTZ'),('160b19946b8550b5b3d8dfecf16f958a',1331880066,NULL,'4_wbkZnInCFQ1qxdi2HBT3r8SdbdwifqYqnAHU53vw8YCdI_m0bsqRn_op010oeQmMAbVAt-jh8bJtkqt8xspGFniYV2nW_JclNbNqSMSJlYBSxtlSFrKfKIY6zkxL6XrKyLr1uF_wROLJQ54I2r7XWqeh_P6sFCFQVOSKfnfPceLT-fRKDZgug20p_-bhO_'),('cfe041abe75613d13eedff9a09ee1567',1331880071,NULL,'wSNqzJtbm_FJZMWPl1nVErp1WTUXEgd8qz63qFcW0fcIZTnkEr9JxgH7Xo3esC2h-3s9mdAfPiRsfUKNNV0Wz1CUMLdk7b7Jry6aE4VR5RT18-mcHpKZXfDj_3WKTMXddVFkloUIZb24YA8ebqxyxNCkCbX_UIbfjkLDDqrX4ELbWlf9540rUkBoXMnKqOAU'),('e3528657f3defa0d4cb101fa9c1b0705',1331880075,NULL,'pOon0gjxvkxAL389xl8cipwbiA0Onrj1UWZX0u6KwTR_WrcC2fWrQml2Ed5yY-djaA37oUOO2S0n57bdNdemT6Nmlo-OIUTUiSHTD0wS2yHDa9lvPHC3KRsPlKZZgDHeFoQHT9J95t29wtHc-Bv5grBvnQ_cGIf8xsVcWdfE9Y0KwLAEw28xMEUNbRtyNcWf'),('ee84e0a1579db6174beeb17dc1fed4c1',1331880085,NULL,'0oAKx1qSeaUuv_MEj9X0cJCH-G9kV7QVSz7SJCu_K6xgiiimAClmppCvMl4eqcdCZrQrNloaDL-FUvbaBnSM8dRIq390_j8dq4lZA8ZqNDsg6F4uhPz2MeE3B2RQoa6zrVmqMyFpNoyTpYGB3_wrc9dxIZpTeTcm9Z0yarieHK6RdKvolCsetpDjN721RXYo'),('334921625d16d24e901f3e068a6cea00',1331880089,NULL,'ZVxbjnbq7YpU1H7ekeVw_zFImdSeOcH1enLcSeHhDNk67SmtNeHHH7zUa-fSQtZi7V0L4RfWLSJ2pA9BjVmtjA3PNzLZC4J_wrws6PDK1RRmoUdBpzoeQmuiR1DpICEKh_OkrhFTQAzWwnccnD0BrMDHl12gqV78e9770wkf1pDpu8FSi99gdcPReOZytCXp'),('246e0181104f2620542a3f204a5db7ba',1331880093,NULL,'9COrgkdNkKf3qER9_duzZXVoHs8BHzn_IqeIejtl_IEQ0To1PQ3qL15yBD3P3-rJbnaHZ_0q2WG8W7SM-i9EKE34MMAKl7re5he4obXFG3oACtTSEC2z6ALu82sKUTZUYwAQ_T7mFVp44B9QYLfUT-LXmy6OZTgygFgVC7A4nVhfsrl06EC_HIIpwQKdd7J4'),('4e6296014f259611d1618f5ac0e7bc06',1331880098,NULL,'k9kN-XhY1_DbKu3AFErwOh_URUPh7r6kIldVNe3hHgHri7lcj5ZfeYujh01sW9XLVCVWZGCBDrNI6rW1nHbvshr9PZqeIqdjZWPYK_ELjcTB1pTraL1bINlbu4c5yq9-kfGpKA1ZO8SnZu97UN1XuDiP84aiymlFx6tVHb0Xy14VAFsIqvAvPpo6tV7_63w9'),('7bee378cd673e99a43ffd40b7c29196b',1331880103,NULL,'EtaNREabxm-HQUqsbUrnHtwqc5i9ON89Ve5tlz3j3Uqkwwmb1B7CjlgfKusW2DE7b2tl2c_9joqxzu_3ULeMYYRpTy7DvE255_5T2xtH8x4H301uzBs53-5qGdi_un2PdQpQYYqXRiKhhG6dVRcbKDg1WJGi5Wn1bVUn1sShBcTiyLTtfB-lcgQBZLvXGqnP'),('fe2a92955d6c3e13ff21fc8154209ccb',1331880107,NULL,'wIiZaj3r9jgrshbsBuCYlYP1xpx9Hbx5HMtu2DGgzJo6ovCVjOZUCb0nd-lGrAPLrBr9Nm_cHGvFV4Ga12SDl1C8yOU5Ykptlwr9xoCwUvISuXPuS0fBzxwnzF3YmYOw7Yy1A6LsJA73P_EMe1xxH_6I7vHnpm_s_MvJ8TUVpAOQCwD_F6tK5NE28PGzbPoQ'),('6d6d7c5961461f5ce745ef3780cb0696',1331880112,NULL,'n_G4CqyeFfk_WSejU7MXF6p49Lx6q1CrIdcMdmT0HKBjMQ4qV62nDzQ4RWGs_sTHXjbAqh3wtutzzhhwavKrnA9LjQAGnAEn9jWDyr0tDc-Bbx9omK_RUQJdJUQjlOul8TFZ7BKiHZS33eiP0PvAa4nBdAWVEGXbM2T3CdaqSzJdGpzyuzcnQGihb8wtWomL'),('36b05418686df13761878ca216fb1fd6',1331880116,NULL,'u6io3tJZy3xohQP_LQXXQDIt3-CdmJFHLB4ptccp0ji9lzk3qA5Du7LceEsZAlYymn-LuP26nHxnOE2Faxq0Vj07MJSrRcIRhxq_xEFgGuQLJZzV91dfs-PoMmqmnXoqeRKPwPV3q9TMK9jtNcIBKR_GvhcGFIwhs6wsmD-iIuw5tYu0G4SwCVUshqCVATfb'),('0fa7ef14d3d725b8e43b324a9eecb869',1331880124,NULL,'DOoikrPI8DONbgU3z8kS5mbsEMiCXv1ClOmNlR2LS8VJmQKh9qR9htUdb1j3a8Hu11aWWlExTr3nlX5oNKEtHPTfVwNypojh2PpKul0_v0leQM4RmMNus85u1KCcZN30GYgdIoeBTBTZv_Wq_8JrXnZthy2Qu9KHbIBGK69sQCh1YQtIJ2Jls4S61jNH1ZLt'),('12113ad71cf1fad4bedfedda20989883',1331880128,NULL,'m59YoVPL43fKk4Z-_WCgr22DQx3nckOTmzpt-bmk_20lFtkwslBfoaNNbhRA_mTcaScU3z2omrBktyKrr23wwkMqyEMyHvG0CdncdRHJXUNziP1qepaTtmUcDBH90yxCMK8SnAr4s2Ix9fxtOLUt_4bRpT2mu35qfNHU7I03EoeQgGDJc70v8rTtdrpF7IEM'),('2df7a65d8600db0b3e7e0f30c51ccc5c',1331881465,NULL,'9rnWy8bADI-xkB1FtHqf79kNgWvPu_7zwVn-Jajd54Ne12LUT9jCEFX9TtCCi9S4W8swcoF0tyRJthrSF0mj4q-65IuosOGmqCYvU4Q9xWWTVu0zpQRRNxm3z1U5ZxkvNi4zQbLTWX0Yo0m38L1hDw..'),('b86091996bc7b72e997e1a6cea3bf4c0',1331882750,NULL,'FB1P1OpkASLNwABEJoZJe4IVn1_smISnuyqvQkuAwDCIe0w_4VklDdsbpsm-LuM39fABsfQVJ-wxVXLydlYUDYNUYemZsPDkUQtk7rNXCKiH1vlfJKUS0NbsYp8kiLyUQXpJ9lnLdKInwrN5RVE9K-kyt3FTRvokVmqtxsPujvY.'),('0f93951ac3d5a40f89c79f598eb1d9fe',1331887879,NULL,'fuD_oKHqes7eRcNl_Ju2YdcotODZ9xqKrjBPGcjvJaTJWhXTAKtQdmbc5hZ4zVu2silNN19aUrdLqzOrAMHGv1-GvO0dYfnj3B0o0gT_3EJq_du3X38dktw9lbIUMnhJP1ErFNcvHJCN6xRzsLoJiUSEmqHB4u6D-JY0kmKW-Bj7Jx6DEBPpD7VwLP9tGdHx'),('0f3be7cc8c9e5ef6930f4f624fc27903',1331888625,NULL,'MmyM_avGJl2mGMiUlQfKmRE3wPok-e06fscnXtpdqIVV4IA0EbPX2SrU9kcDAyhmU1LRPECLNE9OCGia7D8_4mFRgbTDF1r-0uSnHO0DkSdHq3oLByFY_xKu0_5hXG6VLTR931JHoFOuwj__VliFQQ..'),('28643abff1f6862a17b4120e577df7ac',1331891799,NULL,'vHYWxEK6tNhdc-ViTW2_HSyiyzygEQ21USEPdGfFqzwI2U6pzU7ozCuhEel73daQ22hPobJ-FNx1uBOP82Q1q4Ar06SYtHmYxVtyxJbJ8xDfCqRcWqpy_UfWzBfD3VYR-OT9_hwf6lQH9HaWHWq_bGzQS2uJzmiEMTYteqFgz2CqBISg6vOiXJNENGdhgFOIh_amu5xf9YdTdhaev9RTcWTubl56n-opLXnublSBtg_dFvrlEgR0Ug-DvJy9Jk7d'),('32ee231b6faf79929ef6f3b3a8c28d65',1331893461,NULL,'Rgl62sjmutmNr8TXmaRU27D-7mEGzo4aXxkQs6OnxHT53lTOsQ_EfcJHBFG2mDCYUH1pY3jfge2Hbn2hTK5L8idnQ6lsqu3ywjcJ1x_xF_twltP2SuYCtDlDXe8FkonzvPKFtwFoTTX5EbGAMfi8OuZyOK_kbaHWwXvP1yOAqjQCaiMzemGenudFjk3jfnUo'),('dc57a4e3d6546a609be99fde0d589571',1331895806,NULL,'R8ZmeEMY2ZtflM1QHarTCiY5ztD1QB-7Oq2zo8xNSS0K-Hzn4-Xu5FnrJbXDdnu3XdXo6dDNSIyLsPbo3euSddwsmjp_Leq77Q2XsEnpsTbEfi9xd7cZDf9v46xHadj3h0qDNsehvgzod-eI_T5Tnw..'),('826c7e582a4d2a4af7b53df36b913508',1331898707,NULL,'2C_bPhDRJI2PJo6wfQG-CuPyJRUo2GP75egFUAbADdLPyIN36xe94LiC8hNS0scSFNSxCxvb1OnsY5Sb--Qww-VK8MbvfxJcuBtsFIzqjtOajXJGTBorYG_53HyC__Fm-NQtuPffhfWmt5q8blM2EAShwCEV5zWNkCoYRknIuYE.'),('67ea01ecdf0ce612624f901e5dd5e6d4',1331903158,NULL,'T5KbimKMfJnlEG98gW8x1fWUiEQKVVxJpHTLOiSGclk53ix_N2lkSbpc42_iOYtDQSbCNs6xAqGy0KDIn1YhCuwLwEBWkM_kE6jwiYVjyYoSdkew0meq5ztEb8YRS09SpXJdIo8HkmMX_lGWYDc9Sw..'),('8d1404b7f497850f19bd43288e7d4d87',1331909597,NULL,'VDIRK8SIl9pSzJXrE9_nUv9YIzbjkgGbDdQdZ5D9mmF-JYK7BpAd2kUDpKlkZu1c0kZovM3aWpFCeiiwANsanzr4p7LkSSFcEX9sNbZpsg_ym4GMfQ2L6WyL_fzbWKGF5qFo55_mKMjLg0y4xG7W72kOvatGpKtdayg6uRZq3YM.'),('10adac4c6ef75a46deea077f2cb78b3b',1331909983,NULL,'RlFlu09o72Q2ezP6IV19rH2pI8PLejC-vI29eBrNLrF9zKRlLK3Y3qsT9c27XIHEDnX43yqDepaG-yWKb7vfWArDytL1b5zCMfScKiDAcTzGTVEY4387FnmtaM9o6um8kyzLQlf2NACBRYyrvlIfaw..'),('0b494f28a73608dd6bc0a1a3765f823c',1331914042,NULL,'T-WD4zatyi6XSyLiXSuAztdv64ywNQ9p4QUs57v1hnSBzWc0TlScplQuUw-7-0ZzTO_96lg0HsrrYujlZT7WmVl6HPJZrApP0R62RqVTpOmgx4mVl77yDTaPdZTjyWuWEVEuufyRlOdoVuWlRcgOHqUQAy-6oxw2OyxdwGM9fLBfPmbdQrGRPLTy-VUM5knW'),('3ed392c79e14648fe6fc32b4b614e1be',1331914272,NULL,'LsXS2pG4M2JoQC7NtX-bTsVc_4s3XlazCKVAzrjXlmvBTG6rYDCuNOkMqwVxlnYXoXHorBCo-vUPLKxJJcxXHX1pNObjiya7oxbLeXVBoZ0yFV7W9I9Gn9lCW9p5aFFQcCnbFg_FTsLtgVDT242k8M1W1w2RA5E3C2irgPkWwQJnznUDY9W0jY5pwFca1xxk'),('11e53448eb85769163ea8ef05c20dd36',1331915533,NULL,'oeWRe4ZXqq-ZEZ9CrdXODGBJtIMbnLku5gqpjIn4jpEg1acNumwJtxFjHwYm3ZQ6b1YbygHG7qt11ROwOKTm_rf0RAFR4auC1f2-muQI_y5HpjceYLPhHmjw-7NL2zuEnsX78maITRx9Sf5-MBlA1OVMFrCsYDF15KPvn-pQZyA.'),('f9355c1d6c85f486a9164b22793ec703',1331916417,NULL,'yF7KcCX2HcSvuOuk3BJGhZGjqimSIzILaynILQ7SvnqIExmf36BNertzYYuq8E9DwCWqj6TKJSyiiCbTif-q2O6rAXLWF4O93BgCGYoMDtT_rHR9XeNKs2k2SyMkJr5UllLgWSJV656HULu7_ZklIw..'),('b5cb5ce2539b0a715765a5f1a620f80d',1331924631,NULL,'_bEpbjdVfD0fadvzwz_rhl_T7WCUeXWxumi0BSHQCq7N44wpjsbaDOg4R9bMaRM5TlDTQ76czp3MBflomOYMam4KEZcSPW1dylzglO6s7Ivvcc8pB4FckrzZRfyYS_tG0WQUTRkYuhGwqozPTyZuyw..'),('088cf4cadb92b60a827fd88525058649',1331924781,NULL,'_8NDJiGWsVfmEA8Z_mpbCiL98cxtmBu1FVz-TC-WsEjAYqXvx14spmZZdEpVmGwXrMLVCensuJ3ZYcdqKQSOjYjqc0Tqw_vPywoNWeIeRHxuDZJ1nXPwtZP_YpwSSCT9-W9GTpDm4QG6Xp-S02lOqhJuoW3hDTU1EFAFte-8EKeBesK_TeSH7rYS4Jgq1vnz'),('891305b1ccabc18099693ac3ac09738b',1331931136,NULL,'o-OgXG_p6TjZSc62lMkWcrqh2tYnqB2Oz1fxET4EaFkulcQoxXqmFfNjJhreLq-lfGADi7AJ3TbFAj-fzfKqSAZMkXTfFkTum8WM2aCvCuTUw6377xB0MfdOaIrwPNZZKBMNB4L44WGoG4FiWomVliNV9a2CtU2iW9mbPQKi_8nmar_UodDZlZPjUde9jo31'),('45ae079aafe6b314bce486db72e26f50',1331931837,NULL,'GtMktV-7GyK2EPpdwBtsz6hcRBNT-7B5FjwUixYkGElr8eROV8Jtp2us6oHgdLvyIXH-dIPwcxaH1ddvVR0q27hLnTMmMC-OTb9_O61Q6_QEm0hc69-F9rhVOoAcXoz8htSjOok3C_AeY4oi73JwFg..'),('9133551e7a20577c7f63f256b3b9d202',1331938981,NULL,'voX9Ly1pFuxjyO7Y5EIw6Ptj3pco-amjOforkCykw6lNc1H0A5JvB_ffMFgg41UVnGAya9zFENs8rGikwO7_G4KuElkyq_xk-sdGnKemeg1lCujwegPgNuEcbVaX23N08nWDPCBqazfjDR2fPD_TFw..'),('7ba554b94e681e483e24e95b641635f0',1331946286,NULL,'GtMktV-7GyK2EPpdwBtsz6hcRBNT-7B5FjwUixYkGElr8eROV8Jtp2us6oHgdLvyIXH-dIPwcxaH1ddvVR0q27hLnTMmMC-OTb9_O61Q6_QEm0hc69-F9rhVOoAcXoz8htSjOok3C_AeY4oi73JwFg..'),('c20732523d02c6534eb3eafdcf172048',1331946468,NULL,'zu3GySfc3CTe9hLRZ1cHSfBf6j6eUc1qZ0YGn05W2iYpqhnh520nQWJgD3Bjvu2xxvCIKEwvkuTB1kDuTtVokt_u4QsZGnGKo-hN-VsHK-bjtT1tLW4TpH_-rbl0--yMBe9wpyG1Ges_kwQAvW9OQ6AkU5pd_-8aWEuRxnH2ntgByOtssUZP1z6mo7GODist'),('00b09883cb6bcccfd8d73d327526fd29',1331951754,NULL,'neq0ZVZ563jxrvW2-jgbVciuodEcd2_VunoGUnEZaY2Av9p3nkqkbV6nFeaNRmyKVido-HPuGxtDmBE4-Ms99xwmJ0DFXEs9XL673M9LZ1Pj7Z5PhAZ2_uaomWFUU-Q6WiGwJS1ZaWlGcB64r8Qdl8stU7rIbpYORWtbLovcqbs.'),('2ea6774a5d1311d5e2d562e962cdd984',1331951984,NULL,'MYYXrrKTS-n3o9MT0pY2dFhwqeL2EXMF3h09tINc6ch55AvItyIUgv041ZA2FdyPNA44pv4W3AYwx4JWrkm4OKw99eOBvvrsWL94UVaAnbVBiXf7yxqdr5KZSRCo68A0D2Zt1Taj_KPs-4tFL4npOw..'),('a448fe56f7d0d1cb213e2debd27cf4c4',1331953278,NULL,'pHkjJAqVbGXrDFqKmYKOLHFvxdS7vVVU-9G7EGxViUsI94hwFT5wvPGH5AmNAW6uET_3WAYalTycBAh-JTpZa99w8aBnOE6GXql--XCQn03bLtTy4vuiHmeVf4l0qn1umsO406i8-cgaYNLJ8q6oSw..'),('d79e26e720721f1de5b0ae1de4c8968b',1331956008,NULL,'ZGTfyFXyGl5GyhE2OeySSUQZi2PAFG_MCsKVgzygBS8ml2Hi-BPFPdcNZhIQ2fTSZNpcOvWfVxjD09zAeU1VnPJk2kxJX3pDxWOAAyemAstboibZuxUt--iQLkNtmawaVQctuPz9xC1aB1s0V5e3L20E6DBDMFSg4WO9BYYEM8Y.'),('576dfb9479e39df9c5c7570bcfb02df4',1331960388,NULL,'AkRrYgVaXy-o0C4_ACYT9U7TuusjmZcq_Cc5ns3QNWJhs-yDLZJobacvJIxJSmMCvhpxY7u4nvQLfd6OkJUHfEWYR4w6G7CEMUuStMcZupFmSdtj371FoL37JYqdK-UEYMhzdooOw3oTg50f4DCfdwLjhuwqAxq3dE4vvnd_NM9G4efKueKZpUzcVQfteNtj'),('6c5bacb7fc1a463154989eccc9bfcc1d',1331960512,NULL,'kVSnRmrxfpEE63WWecL-fGoU3yXU5lulZRJqAr4maLMq8L5uBO5Bb6ScpjfMIAVRfU9VSk58hTu7J_JxO78TvtQhsgyjZFjQG98gVoOHejXZ68c7PJ154ryYNCgNOuM9z0zYcED1FpUA-ibv7ZYOrzryGObdygSnUCPaYIQ2hqgC22Klvw6QC8iP17ALnzgL'),('e0845c7ac267effa79a37bc6eab34fd2',1331960515,NULL,'ZgnCs1qKStprsxY2rv9-kEFMISSRYLDSArvj_2bknxUwDVv6kDkZBkplr3Ykg48odt8BWOuE8z-4LRriFFlNOw6PPT8G5i1aQ2iUpeYj3beb2RcAsNIGya7MOj_GYoEXYIUINqntqMvbhUjtqtEFi4ceVtXXH9EXE_s6GwxkOlvdGSfCpOIUfOZxOb1_lTrn'),('187ad1ed5c0fe7199bacda307f23eebd',1331960569,NULL,'wskc1-K1kcGm8ENKyYOnewNUkgH0qTgiaC94rAzYB5_PUm0kxy2U7bpuHTUWW-hzXBHIu7iVq0ur5KXCPvYL7Aikx10YdJo3av700Ze5sZEmaUMFS05_Y9zPk25e5aHVll7OouFl4t33-btUnCDbBDCU9jHksQwZr-BQlVCIfqOU-o6BRBlHprC3rMpdsUKz'),('2cc5a6cb18bd535b457c124041bc90a7',1331960580,NULL,'haepzm_pPBN9Yo-CYv747mYWFpmGqGyhB2ov2ETZ0XJvYo-VYpwSYeTf_5yRshOliYaBK69NhN3dCYUsPyaCww6ipY2XXhe3_yoJsenPVw9k3bKOznfFlhdU0CRKk-s44iRFPzmb53W5ibDRybmkBdO95pMTGfS8-ei_g2X7tH4fl7BoB07kq9luYwXcDvnt'),('fd57029e33069b7a1e8b48195eafdfac',1331960582,NULL,'IuJeBR6C0betJey7K7ZGPFRO_8Gp_1T6bagEfoiDL82Kr1A0vnNwPJHc1GCTGSLiX4w8q9otRhlm3ieF2gtrfcrGbY-7--_LVrTd8Iv8bjP9vC4CNui4EqDeaqiZHsWpoaxNS5FPY_m3PaTeuiiPnVfEMdfXCPZ0JAlRPPKogmifH0HoqLogKxXomLeCwZdF'),('0b83d1f2e05e8ae86708c4aae5d1ab50',1331960626,NULL,'t3rlnhdpyN74ZG88yL72Uwi2YvhqxjPlJPaCktGJEeIa7HxHXmf_i9gICPakxGlfYK_SB46aiopKpWzkwT_RTRGt9m-gzeWfjElsu1Zq7v3JpvNsRY7xJqTkTL2uVyrigERnN9cN5pGglNYm4opmYHT2QSnwUC5WJj-3W1ewuhR80Vy5l7cv6mdtaqfCCMUS'),('614dba9d6a41c750c72e3c4203dd89e2',1331960629,NULL,'MiM3lZmtMAzilbONtkI-NRo-BUCJvEDG3mEI1JOIT25W3sFBh6KMDWZ3yy1LHXWBRc4e_IGjMATQsE3fj5lTVwabp4Vf6WSXSxT2cU2UCg1CI53qqiz_idbhCcdTuWvTIUWW9P3L1V-xsLskE6STg9wc9vw62IbxDNDtq9k1F4W8PXTdcelWxp-z8WGvw6GJ'),('ba8201a433c5f5ff82e53a6f8488c442',1331960633,NULL,'ZhnVQKKlZ4QzJ6Tre4zVr-6OgmqO8htkeZ145sVgs2M7Ik_0QHYAwsHziIwlqiaU1D1u7AWNxgzZT4DWhMxMP5Y_dDPbn4pHIMJvGJ8-CgwZOtMLq6th34s36piRLZjKcYvnYVwaOEy8mNpNC2o6_OeNkBWs9EdDn7aG1Ob5KLudKNstKf6F_T5J33aflFWC'),('cea7641aeb734268f3dc91185998f0dc',1331960634,NULL,'ih1hhKEugMXBhUCUAr5Zw45PIdsiEvfs5mEP6VykNJRUim2GDeRiEZOoh7XmoTiM7xDNcSrm3uzEhqt6S5z0bgh91KYHVcjmycPHWMdFBab_St6J-WAbRenIhaME1U7smWXQdOhn-zjskUPj-j_Kiyj8jcxFWz5UPaP3goCXNsSgGiHInNSZW9qTGpHDFDdf'),('6fba2309359d9ca28fbef2658313918f',1331960637,NULL,'HU7Fx-WGM-UY365Ldn7Rru3I5NqUxJZRPxxi0zOWbidZ5CE8J1ovuw-uWHvhlsAHqU8Q1tSFF4V4K8I4KK4-2XkVUT1gzFC78Mz-XS-iwJWCQTykJMT9XqGnmOULXVD2OpOmkJZ8oAwIRlvwYq25adt-rPQd5cKCZzmCJZavYls94S_XXRc8TY8YnHNVDPyp'),('251b77e5f5f733eb07f71c4e80a38434',1331960648,NULL,'V8_zVArhdXKL5YEpFISHkv1NfOTtjXbDsxHoS8PUTDr8TaX271Ef03T4oXVbZH-RJOahjmX_e5x9j70gSZWQcY1udcvJ47GikaLN1PWXt694Gr7Qcbt6t2ov53p3opniwNn3RX6TWP5sa86k6YpeDhfwe0Cp2IGo9XZ4-4eqJjfrQcZFC3JGdoab3cHKWQQh'),('f229887c26dae84d9ecba08573751030',1331960652,NULL,'lV1cfH9oWOYdRfByntGOybxLesov4bhZR6EDc7UKmv2DXQNzqgrIp26R3l7IUI08VW2sbpRZ2akv1Eep63OEU_euy5hg4dHE5X_9R2NEHJAVv2YK8zb0m3HM71DOEhn-XS2jZNPzkik9KH0T6YVemsdGIusBH0dc-71mUvyp1PhzMaRb1O-rVu0VkP5HxwF8'),('9fc0100017c07e956f01fc0cdd2f245c',1331960653,NULL,'JjjHJjCSebUDSjRCAvV3AMxwOh_RlohjD0r3HkZIp176vK3-B9KoqghFH0cQ9duEo8onHGZwMo84pORNiC_J6CRxn0U6u_n_Z_-8XQvkd6q_2ZaFDHZDx8MunQHLaW2P0qF7rnjX9gKVxJliVBkGK3jkS3Q5G1WuYC_x4etA6ikZUy2HPplvFOiSz60Q52u9'),('2ba67f8dd7b9615b5e43227a74670303',1331960692,NULL,'xYbwqIIiqw8eLZwCqR0kEQi_EZWjBjBGAtsqCI5AK1aoyEUOoW46DR4z-vnmcQFnGOpXZEAgQJtAHXQFa8d3szIIHLUOfxnQTR6zagr7ZvRHr0Pkcf16l4xdgPdtnrnjF5bQ21n77uTanqOtLaHlIBqliu3_rnb0EHRzOcyWVCI08p1B0m5drQjEk6AQGsmc'),('5e857c02503d782da86e8cff3f729e9d',1331960697,NULL,'1-vZHK1W8daVbe57K66Kgk7BxVCYTvKszl61wzdlI2evzq5jAax2MyvqCOTe5mbngIN-NIY1BCLfdfFDzl7rv1hrExzGKJmEBqWexhaBzfTIXsL8i-tSeHVjhBDAlVUrTAiqpJ1oWAIr3AI75Huqdg..'),('dd486d45b20aa2c6429011ba2da102a7',1331960699,NULL,'ih1hhKEugMXBhUCUAr5Zw45PIdsiEvfs5mEP6VykNJRUim2GDeRiEZOoh7XmoTiM7xDNcSrm3uzEhqt6S5z0bgh91KYHVcjmycPHWMdFBab_St6J-WAbRenIhaME1U7smWXQdOhn-zjskUPj-j_Kiyj8jcxFWz5UPaP3goCXNsSgGiHInNSZW9qTGpHDFDdf'),('ed4347bcb97154e887390f657980cb5e',1331960705,NULL,'sOd3jSS5wDOCZWl-569sUqqVuQKHaEr_RoxDpcNjGDGtouPTiQvRDCpQxKYEH3zRCVKNtXGl8E7Rex_xFFr799BzHN8W8DgJ_RcSMrGU0GpN2IFihHj3Whzd3bKeobE0PJQq_n_QQ7w54TkHAlruHBphUAoP5VIDKS9QjPMrajd1FRv7JuMp_W2VG4sgxC_0'),('819da48c250adfb27f64e947dfe3d921',1331960709,NULL,'aiEDd__CWFdfRh0r1HZQdlj44OAas8X6GeqmXgZeD8hxmwItegucfUlK2VN9xTSM7bTZGAtW88lo0OfIj9mmuPYF9bg9DpW0EJePIML2F0Hh6McYs5pD5-P9VllAmLpChOSzwTx8Sj9hhInIaMuRt9djVdo8tiSo9aD1VCVXeycXgibM8Ts-Nk_P66awq7oE'),('26be3b3b854bd20c4092e3ed25e70afe',1331967864,NULL,'o1_rdaVsbhtRb87wympBlIzdTXyNndRhUWZueVzJwTz8q_RnzBn3b51Rr4Q8ce2dcPFqyI-nzb03Bf4lTwd19NyT6-4cmgo1PX15_Qm42dx7qFrTJ2OBvLkyVWpAOiC7qv-YtDO3G93_gODx_vmz5Q..'),('4ab6bceee3d24630f0a79b5e54afc29b',1331968988,NULL,'OfU3F6dqzWYGL7h7bKvNXW09iWNQOGlYruxyNgsz0k7ufRrGJ7lxRlN5RSYkU0Z7OxpNk4DusEpCsRdpwhBbfoFNJ0wTnoKHkq3GvchG3F86ge9sUz1UUWa9T_up1T1qVN0OKmaIwoea-eDFcVMABJsDtOybIvqXCFDKnGWMjATwKuS4npu7279D6e8ipaZK'),('2c58d3a99854cd0db1520b2b11229af5',1331970920,NULL,'p_Sn85wtu1jCj3a4F0z6sHG302NDTAIhJcLL6h_AuptLd5zxDwTAevAkFSUEwzUjuiTlJsNyXbPa9QUOyVNCGtB8XlqqpTUvhwaI_eEVW4p13jPVBqVDKNE7Q5v-kq7CrlHd2YlTWF0QyUsOEuYVYN-2DceZ9QPg_5LIiQnIexk.');

--
-- 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) collate latin1_general_ci default NULL,
  `set_hook_place` text collate latin1_general_ci,
  PRIMARY KEY  (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `setting_value` text collate latin1_general_ci,
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

INSERT INTO `idx_setting` VALUES (4,'site_name','Yourhomerepair.net'),(5,'site_url','http://yourhomerepair.net'),(6,'email_address','keyla.rabbani@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/yourhome/public_html/themes/'),(9,'admin_template_path','/home/yourhome/public_html/admin_tpl/'),(10,'plugin_path','/home/yourhome/public_html/plugin/'),(12,'active_theme','_Yourhomerepair.net'),(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) collate latin1_general_ci NOT NULL default '',
  `category_id` mediumint(8) unsigned NOT NULL default '0',
  `total` int(11) NOT NULL default '0',
  `tag_path` varchar(64) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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) collate latin1_general_ci default NULL,
  `who_is` varchar(255) collate latin1_general_ci default NULL,
  `note` text collate latin1_general_ci,
  `date` datetime default NULL,
  PRIMARY KEY  (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- 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 COLLATE=latin1_general_ci;

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


--
-- Table structure for table `idx_users`
--

CREATE TABLE `idx_users` (
  `username` varchar(20) collate latin1_general_ci NOT NULL default '',
  `password` varchar(50) collate latin1_general_ci NOT NULL,
  `name` varchar(50) collate latin1_general_ci default NULL,
  `email` varchar(50) collate latin1_general_ci default NULL,
  `date` date default NULL,
  `status` char(1) collate latin1_general_ci default NULL,
  `vcode` varchar(4) collate latin1_general_ci default NULL,
  `group_id` tinyint(4) default NULL,
  `homepage` varchar(100) collate latin1_general_ci default NULL,
  `icq` varchar(20) collate latin1_general_ci default NULL,
  `aol` varchar(20) collate latin1_general_ci default NULL,
  `yahoo` varchar(20) collate latin1_general_ci default NULL,
  `biography` text collate latin1_general_ci,
  `location` varchar(50) collate latin1_general_ci default NULL,
  `interest` varchar(50) collate latin1_general_ci default NULL,
  `occupation` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `idx_users`
--

INSERT INTO `idx_users` VALUES ('admin','35a9ba3f9089ceb0f78610cddd07d215','Administrator','keyla.rabbani@gmail.com','2012-01-18','1','',0,'','','','','','','',''),('qcalebnorrisf','dd5e2fe78efffd0d319bb4cde3513f82',NULL,'octaviodowns38@hotmail.com','2012-02-12','0','2126',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('pmelanirodgersi','3dcd3def2bdcc5c490c778dc85f835a7',NULL,'cleowynn1230@hotmail.com','2012-02-14','0','7333',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('imolliechurcht','bf6370487f0888c1b663175f1b2fde6c',NULL,'MarkkgleyAduyrien@hotmail.com','2012-02-14','0','3096',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('lderekwangi','f1008fc57effdf600308325635e8c1d5',NULL,'normanstokes1025@hotmail.com','2012-02-15','0','7340',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('unelsonlaneg','86a34e4bf2b3a28e37cded0571ba8401',NULL,'landonfitzge516@hotmail.com','2012-02-16','0','3655',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('pjackysiv','a7f371344ce6a5b299617a7219b82279',NULL,'donovanwalsh425@hotmail.com','2012-02-19','0','6898',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('aangeliascott','ed65879477403baad10748a88a17326b','','aangeliascott@gmail.com','2012-03-13','1','7130',2,'http://','','','','','','',''),('1simonpeterson1','56fa861e6605dd8f0116fe66ac20705b','','1simonpeterson1@gmail.com','2012-03-13','1','3639',2,'http://','','','','','','','');

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

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

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



