--
-- Host: healthprofessionalsdirectory.net    Database: healthpr_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) default NULL,
  `menu_url` varchar(255) default NULL,
  `order_number` int(11) default NULL,
  PRIMARY KEY  (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

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

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) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Addiction Care','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Alternative Medicine','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Beauty Tips','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Conditions and Diseases Care','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Consumer Shopping','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Dental Health','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Disabilities Care','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Emergency Healthcare','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Environmental Health Care','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Fitness Training','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Health Directories','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Health Education','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Health Nutrition ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Health Resources','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Industry','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Hospitals ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Jobs','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Kids Health','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Medical','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Mens Health Care','','folder.gif','','1',0,'','','0','0','','',0,'',1,0,0,0,0),(21,0,'Mental Disorders','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Nursing Diagnosis','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Pet Healthcare','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Pharmacies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Procedures','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Shopping','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Spas & Saloons','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Teen Fitness','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Weight Issues','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Womens Health Care','','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,
  `path_with_url` text,
  `parents` text,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category_path` VALUES (1,'Addiction Care','<a href=\"http://healthprofessionalsdirectory.net/addiction-care/\" name=\"cat_1\" style=\"\">Addiction Care</a>',';0;'),(2,'Alternative Medicine','<a href=\"http://healthprofessionalsdirectory.net/alternative-medicine/\" name=\"cat_2\" style=\"\">Alternative Medicine</a>',';0;'),(3,'Beauty Tips','<a href=\"http://healthprofessionalsdirectory.net/beauty-tips/\" name=\"cat_3\" style=\"\">Beauty Tips</a>',';0;'),(4,'Conditions and Diseases Care','<a href=\"http://healthprofessionalsdirectory.net/conditions-and-diseases-care/\" name=\"cat_4\" style=\"\">Conditions and Diseases Care</a>',';0;'),(5,'Consumer Shopping','<a href=\"http://healthprofessionalsdirectory.net/consumer-shopping/\" name=\"cat_5\" style=\"\">Consumer Shopping</a>',';0;'),(6,'Dental Health','<a href=\"http://healthprofessionalsdirectory.net/dental-health/\" name=\"cat_6\" style=\"\">Dental Health</a>',';0;'),(7,'Disabilities Care','<a href=\"http://healthprofessionalsdirectory.net/disabilities-care/\" name=\"cat_7\" style=\"\">Disabilities Care</a>',';0;'),(8,'Emergency Healthcare','<a href=\"http://healthprofessionalsdirectory.net/emergency-healthcare/\" name=\"cat_8\" style=\"\">Emergency Healthcare</a>',';0;'),(9,'Environmental Health Care','<a href=\"http://healthprofessionalsdirectory.net/environmental-health-care/\" name=\"cat_9\" style=\"\">Environmental Health Care</a>',';0;'),(10,'Fitness Training','<a href=\"http://healthprofessionalsdirectory.net/fitness-training/\" name=\"cat_10\" style=\"\">Fitness Training</a>',';0;'),(11,'Health Directories','<a href=\"http://healthprofessionalsdirectory.net/health-directories/\" name=\"cat_11\" style=\"\">Health Directories</a>',';0;'),(12,'Health Education','<a href=\"http://healthprofessionalsdirectory.net/health-education/\" name=\"cat_12\" style=\"\">Health Education</a>',';0;'),(13,'Health Nutrition ','<a href=\"http://healthprofessionalsdirectory.net/health-nutrition/\" name=\"cat_13\" style=\"\">Health Nutrition </a>',';0;'),(14,'Health Resources','<a href=\"http://healthprofessionalsdirectory.net/health-resources/\" name=\"cat_14\" style=\"\">Health Resources</a>',';0;'),(15,'Healthcare Industry','<a href=\"http://healthprofessionalsdirectory.net/healthcare-industry/\" name=\"cat_15\" style=\"\">Healthcare Industry</a>',';0;'),(16,'Hospitals ','<a href=\"http://healthprofessionalsdirectory.net/hospitals/\" name=\"cat_16\" style=\"\">Hospitals </a>',';0;'),(17,'Jobs','<a href=\"http://healthprofessionalsdirectory.net/jobs/\" name=\"cat_17\" style=\"\">Jobs</a>',';0;'),(18,'Kids Health','<a href=\"http://healthprofessionalsdirectory.net/kids-health/\" name=\"cat_18\" style=\"\">Kids Health</a>',';0;'),(19,'Medical','<a href=\"http://healthprofessionalsdirectory.net/medical/\" name=\"cat_19\" style=\"\">Medical</a>',';0;'),(20,'Mens Health Care','<a href=\"http://healthprofessionalsdirectory.net/mens-health-care/\" name=\"cat_20\" style=\"\">Mens Health Care</a>',';0;'),(21,'Mental Disorders','<a href=\"http://healthprofessionalsdirectory.net/mental-disorders/\" name=\"cat_21\" style=\"\">Mental Disorders</a>',';0;'),(22,'Nursing Diagnosis','<a href=\"http://healthprofessionalsdirectory.net/nursing-diagnosis/\" name=\"cat_22\" style=\"\">Nursing Diagnosis</a>',';0;'),(23,'Pet Healthcare','<a href=\"http://healthprofessionalsdirectory.net/pet-healthcare/\" name=\"cat_23\" style=\"\">Pet Healthcare</a>',';0;'),(24,'Pharmacies','<a href=\"http://healthprofessionalsdirectory.net/pharmacies/\" name=\"cat_24\" style=\"\">Pharmacies</a>',';0;'),(25,'Procedures','<a href=\"http://healthprofessionalsdirectory.net/procedures/\" name=\"cat_25\" style=\"\">Procedures</a>',';0;'),(26,'Shopping','<a href=\"http://healthprofessionalsdirectory.net/shopping/\" name=\"cat_26\" style=\"\">Shopping</a>',';0;'),(27,'Spas & Saloons','<a href=\"http://healthprofessionalsdirectory.net/spas-saloons/\" name=\"cat_27\" style=\"\">Spas & Saloons</a>',';0;'),(28,'Teen Fitness','<a href=\"http://healthprofessionalsdirectory.net/teen-fitness/\" name=\"cat_28\" style=\"\">Teen Fitness</a>',';0;'),(29,'Weight Issues','<a href=\"http://healthprofessionalsdirectory.net/weight-issues/\" name=\"cat_29\" style=\"\">Weight Issues</a>',';0;'),(30,'Womens Health Care','<a href=\"http://healthprofessionalsdirectory.net/womens-health-care/\" name=\"cat_30\" style=\"\">Womens Health Care</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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) default NULL,
  `date` date default NULL,
  `title` varchar(100) default NULL,
  `description` text,
  PRIMARY KEY  (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_favorites` VALUES (2,'aangeliascott','2012-03-13','',NULL),(3,'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;

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


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

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

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


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

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

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


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

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

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

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

--
-- Table structure for table `idx_link`
--

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_sessions` VALUES ('4e0fe89c485bd6bc6fb3c7cc3a30ffce',1331795767,NULL,'1v_CvCXGt8gFn0-e9TuFAdYXxHaL56BicJyDOx-W6PVPOlqd6r8nYSYlV8WY0SvmC-IcldQhi1AjADBgcBypMCt6AKGTvzPjoedZTqmap-S9LIwBP__KV1fSW4jDKUufKNCZiQr6DJxxhqPoYVro8FuAQR5z6Hevutg3nafcWJ9dujEWoCXe-8pzNEWRY_EP'),('e189843a49c580c0bd8f50d90341617c',1331795768,NULL,'INOD0K8xZssbaKxxHL-cTAaQGOeWVUMZdeZ4gYR8ww-IWC8SNTtWaBPjV4wpqUuXdr5OMRzBDfvldI5GqiL-X6R_do_meSBlWFtoF7OODi28SVmpQlIvXaCcTjkYrqQgS4XPlTyQm0WwiU2h5EO2y6HE4fZ-B9hIU3R8RDtSI9VZuDutaJo4UHGHdoXq11Fi'),('f76b50900a1f7a48209c6d01a3684697',1331795773,NULL,'CLpz1XkhjoQ12Oi4Y2ygRS0Yy8GJMMEYJNi_BnfSztjGdpXHBfXVIkOBFl1lVBxap_k2d-FD2WS8r3X_0BMKDkQzQ-6g6kBiF2ml82FYyNZ53OOKdnvwrkDeeGrIi-ruofy7u4Pkp9tRMlPSaISxU7cM5-GZqDoLwJ9la_BcMQw0l6wjEq3GcGZokAKEjtAS'),('d5d0c52e5d50f0eb834abbada3b09684',1331795781,NULL,'Gi_p_39thxMTgZYDCba8l__li_M7TEa98bXvByn8-IFziJQq4CktUqrGTF3TA0QiMvhsgSy0UkC22uqXYud0qMFQQLNE2NcrqDHpwdP6og2XscFmL8VC6J9rlLZ1pD_z25E4MpAOA5laCxyY6Bcy9P3hFPJMWuKGYlAyxEYTc7U1DUiAniB09cb_3_Kt0fGT'),('f617f481e68bed218e7b50f439117b23',1331795797,NULL,'INOD0K8xZssbaKxxHL-cTAaQGOeWVUMZdeZ4gYR8ww-IWC8SNTtWaBPjV4wpqUuXdr5OMRzBDfvldI5GqiL-X6R_do_meSBlWFtoF7OODi28SVmpQlIvXaCcTjkYrqQgS4XPlTyQm0WwiU2h5EO2y6HE4fZ-B9hIU3R8RDtSI9VZuDutaJo4UHGHdoXq11Fi'),('e38bce80f0e2d329ed3207f4e7782548',1331795798,NULL,'nwn2GvP0nqll0H8as6EKHyMh8dSmVdFU2mHuLYLM-OdKIWR2EK-yaAc_F5LGfn7eMGd0ywYqwAU-bAOql3qjWovbFVxWbiSMoS89TEqFNeaF2gLb8kTnud27mhEpGQE7dcF53CxSWBV_NoBlLvT1PjhoMNfC_NDDNfuvQFtYrBuXe28fXAi6ns7GHaZeN0HJ'),('9ed852274a6ba71344502e52e33a775c',1331795811,NULL,'jVUxbrM3g2J4p7vfgK8lxR5xjfaAZ_1TM0O5Do5HhkoGDw-iFs5oWuS51VlfGr0JLWItk9F4ONA9mdF0u3LTp8zSzD_A5vf9e8sOVJHpK3Sv1Nfj5KahM5Pxl2AA83UQ8enQnMyY_g11r-_i9eqWRUTre6AGo3x2vxzdtMgZFOXIx9lKO8SIW8txMKKqOa6z'),('1f852b7ec049a544d3a7e7e6e0ef02a3',1331795813,NULL,'0xEiZBq6Djc5Hc_eRdcTv_WqMK4f76ijD4MvBggz2Esb55o8jORWPnVbgIy_M7xrZRHiCITjz9oCl_BI2XD_fgjQcoYNSyTYdYApCKquCHwLaKVHuS3SmYMQHJogL7nyHAisOnor3NbizjqpaHA1nw-UdGKq-dVwn2sPacksPWJvho6oofFPXQEjYq79qQC9'),('262b67ff1a6dfccbef6e0b79155837f2',1331795814,NULL,'Z6uz-6gQRH2riEIsUd6lx4cSig36RxLuJC4F_K6mjBUn1WngPDjMFzdxLXIyyIe2RP_bhmA42PdDVRpONeiA8Q1eDt3PWOzgFxcRi4GxzFSkyTQ78BYaeygzrvqbp4qzrgwlm3FYMpqqJTEbeK2rP-x4tiL7b0t7vifuB36kqropdDkPCNhhXIe6EVefs1ss'),('07c0d6cc2f233aec633fb195fc45cbbb',1331795885,NULL,'Br5koqNcmOYmYXlGOub5xTbaxXolalNzfgVvMT83Ttspc_5JG8f22lOINDviO8qzIwq6Dnu_tOMDpg416vLPGvT2zz34ntobhd669vyqIHbqdLI_lRme7qa9My0LICEs1lZPzHG4xoQ0eseO3t519-rGOyCQHgQZG1vjktQnJDlfX9Brktgb_UAsEcseDehA'),('84b82854b32dc1ec7cb505c86c34f7fd',1331795895,NULL,'j6jGuAPuB0m2dbS2YoIlfX-h_5IMoTHBeDFWdZ5znijMrlvlaNZX3NMEBKzf0hCKxgYTfpBd7R9h5NXQ62keSLa0Ne3Ct1CcOzfYefGxtZPg8cClJ8GO2dI5Ky1dmvVrnG6ZwCnoo3UNnAoRPdzZ0qzSd3INFSwc5F2se356oDhMKaQp7A0qKBJ8lkDA3b5j'),('18e5c8b612a5be066b233aaddeeaaed5',1331795897,NULL,'b6KG1IV2Adlk22DEhznSIpo9ApG3cpLX_Ais7BltW4P7xUnZKPTZT9J60isKn-nbs-MKtac6_YDn0z8BDHjpXdSDJp6S86lei-xQ1wwnozQjaH7ZPekjkuFLCdHrGH3hZSqm3P-SXhbxIpdNUQOrdvXjCFkXP0odU7oYi2PcQ5lK_-tTgBvlM1FP4xHYcwAc'),('d5b61bbb8c51bd4e1d3a3968894ef05f',1331795898,NULL,'dOHL4WDguGOCya3kF8HTLQNa88l23MRhss7CpeiVY2zV5palzAdyjzWTGzcI71yXqPfK3vRqsM_FZNE6LZq9NcPKx4z8W6hcJgj98kGKIGbKzWIjzmn6vo-faj5u8qSLoUL1TuWAiyc5JLDINQqy4XV3PNE0H2pVoZcxEoCQv3G8iToXsBk8QhA1jQN7wBVy'),('bb342f8d1a9029af52a182f4ea225a5a',1331795901,NULL,'rvugSjnMwhXQDveFHKbRwSF4qIt9sAhhfISIxF9sZHVGMoFGkrichWaKcMCoIIsNG4M68UZdkdWM3dfRNCO7JufUWl9nxgELnOC9-vu2R1a5UlnXUKQaaqfYj25u5-SBsAFf8tBOZNVhA7OeGbqEQfNcR6SxIzHvXBdZw5c8qV0kf1MsKnorKaoG0ervzjyZ'),('8d5a693894e1f21993cd9ab23f2e73c3',1331795903,NULL,'SH_E61ZvZubIMLH8MYgrwE04Y9_KU7BkL9JRETqIOoe-9080KSviFXTkpE0_I82i3z8ZZsVbNMGVTPPtPWMLuH4pHjz2pceBya5cXuQY4t-GpASzcn0rmDe36rtEB_Y9xiqNlgIaitiSC3sf0f5Vq-C7raYVtJQiKpDZKFZGUPSE1r6Pb5Y58dU1iPb_WlzI'),('f67883a2d28d0b62c6f39fa319092107',1331795904,NULL,'ZmTCB0bnfmxNtDmYlw7m8LRrsY_wH9Ky65OdWyUdumKWJmNb4ztnwoYfE5xN87kleHuNfHJUpy7KOs0WK3Yuku6TPuhGmKCAosnrGBH-m0xUo5-0CDrGnzYmqEuVZI61n1Q7bM0s6SynZiHLCt4Jl4K1ZjosHCO2CrlK8yZu99W4PeQiecDXGsFHVk3sbcKt'),('0939d1ca8021ef95295bcbb0c6aaa76c',1331795909,NULL,'Br5koqNcmOYmYXlGOub5xTbaxXolalNzfgVvMT83Ttspc_5JG8f22lOINDviO8qzIwq6Dnu_tOMDpg416vLPGvT2zz34ntobhd669vyqIHbqdLI_lRme7qa9My0LICEs1lZPzHG4xoQ0eseO3t519-rGOyCQHgQZG1vjktQnJDlfX9Brktgb_UAsEcseDehA'),('a73f9a78b8a7a69c02dd1139dbdab13e',1331795913,NULL,'rvugSjnMwhXQDveFHKbRwSF4qIt9sAhhfISIxF9sZHVGMoFGkrichWaKcMCoIIsNG4M68UZdkdWM3dfRNCO7JufUWl9nxgELnOC9-vu2R1a5UlnXUKQaaqfYj25u5-SBsAFf8tBOZNVhA7OeGbqEQfNcR6SxIzHvXBdZw5c8qV0kf1MsKnorKaoG0ervzjyZ'),('1dbb54b0c326283cfd2afbde4bc94555',1331795916,NULL,'ZmTCB0bnfmxNtDmYlw7m8LRrsY_wH9Ky65OdWyUdumKWJmNb4ztnwoYfE5xN87kleHuNfHJUpy7KOs0WK3Yuku6TPuhGmKCAosnrGBH-m0xUo5-0CDrGnzYmqEuVZI61n1Q7bM0s6SynZiHLCt4Jl4K1ZjosHCO2CrlK8yZu99W4PeQiecDXGsFHVk3sbcKt'),('26406c2b6489775929c52b7469b4ff1e',1331795919,NULL,'dOHL4WDguGOCya3kF8HTLQNa88l23MRhss7CpeiVY2zV5palzAdyjzWTGzcI71yXqPfK3vRqsM_FZNE6LZq9NcPKx4z8W6hcJgj98kGKIGbKzWIjzmn6vo-faj5u8qSLoUL1TuWAiyc5JLDINQqy4XV3PNE0H2pVoZcxEoCQv3G8iToXsBk8QhA1jQN7wBVy'),('58e8750b9deef17f2b16916b44e565b6',1331795926,NULL,'HnzGqRvgzVov9jGc-82-lnGM_D5YbUlzNd9uKhCY6fltUcCKiWe11DffP2l57j2ls5xN3GP1fvI0t3dDmboWQW7EK4SbDEp0uSd2YfShJRzhkSHio_KFHnRVimTaSXGU9yrSAAdE6qo6zKK6IvQdAopDYc9sHIAmi3BCT1uxrrk.'),('22c8951853def2852124142d3764b239',1331796008,NULL,'8FytKhwMYy5KBBZJx5LbQn_daKLzId5qJ_SWQwQz7F8SspSBYL65XXW_4KXim2pXCfGq2dr4SPxaW11bpzx1VbaOuuhbf0Ov__93zepVm_rT4VgD2INIfIUV2wR5ZF4lW7K7dbmlBDnA_MZZB5HJvVC3z10cbJSNzc9ckxuxVoo.'),('084f2271f79a453061d86b81a1ab932a',1331796016,NULL,'panHdcRWh08w02PF-Ft8NEk2u21BgLGT-LcnWSEW9bgxDTPONqwrIiXGsNDTPdHI5GdsBlaZW9fauBeJp3uK9Al6R212F0LHIICbw3KBxA1PgBAltqZxoHNcppYmSF5r4N78uQL0gcDs3_hi9CTnpBwqnHwb3tP1f5jsDH0b7mivZBTq8_5kXbwUH8Qc7dPI'),('0d9efd40b763584880f78ab29b1f66df',1331801546,NULL,'A3-n4Nb7v_8_JFmBZDxIYC75z0-PpSNd5QJ-Tnbri5J8a7vWnmKuEm78-Pp2CpkIVOErWHEN5cq0HEAlrkM1DpKu-DiJASCdy1gjVNEIrTvYQnFQD5TSuF8YvAtw9AWL7sv6eGW9d_CFoZm_qdxfHRxzNyyK8H_H5xlFOsq-DxU.'),('47aed6f9522e86fd495056479e45863b',1331806651,NULL,'IKvUG0MIsXwZC7-Ql7Ll6GjZkUNupYaGn3qg1IcXE2Qq9ieE5RBwhXdEqNW3GwuDeTC-q9HijpOT6bdhiug__SM4eDI1q8nBq7_iPc-i14bqau_NjzviPyIDhZy041pXDprCm9BNBN6D0sIw9HZVhv9k77WokwuMYKDXA6uLiJf_UKtsW1iLLSdEbY3ixLc-'),('4f82d3f67cc525ee3879e37f0082e364',1331810637,NULL,'et-Jd9Nl9VpHKIUBt2igiZu87wc3PLpp-gKJN4iJe-c7iVzh32YOM7mDRl97HaODNVwt-3qdrpYFC4ZidQjUOG8Cg6EdU6ad4DModEF9C6sRdSWbA93g0fKny47vXTi3tSt3bYCjeq1fAkF3-W8XWvZRFfS_uUyNDql_fk5dFqI9GIZFUJQAvnQkpwNZjIcJ5jQ-4TNCsTK0WqwcFHiCtlSQ5SfuDnjWL-gYEDXFw9fnDRKWvTP_fSWPzpnwCIhQ'),('ea40b68fe729d6d81b1d1754d7987a55',1331812359,NULL,'lhVmdGLoWSqv859Ph3p5tfrDLERcroKzKyeiEA5WHAfy2hIOyNU1_1AZbUy9E6gOsCt0EB4VtDB8vW7PTwSLbzpCyYw48Zpejyyz7Vqxqf_65zg3Lg0cB09iy7XUPaJLIQHP-S9_ApjfcSyu2FKDsIoNsP6-BTQwUQ0lQlXib4A.'),('f0988394688ce506a9c668482d4d7ed2',1331817498,NULL,'Kxum4VT9XuzfZw6Spxr08wKrAGkfcNneTFUL2j-66x72cDVYTpM7fbcEHUZcwixC6N1qEaYH3SSnk4tJjk8cdhBTxwfLm3AC-Jx4vPFXdzgXsDnL1S-O-g7zB4w0NLVsKJSIsgLJHjx3wjWPe9A8kz1cbvr-k7k3Pyild4dF7Mq3LVStujNDzxcDuHdKjcf_'),('1bf232e810eb43ab4536c6849a605658',1331823092,NULL,'KpLeojHIMlEbTg6Lu54AE4O7zAqkpJHnJ9t7DguXrBInY1c4m318zIt5LW1khmzy81C3TbyTSsgT8aknWap-Xhcln1rqs3pdkq7JGmHf6ck51dB_VbOCi9oy9VMJjE7nCFyhYOOe13bIc-KSbSaomyW7hDme3_syCZOcH1NIqfc.'),('b81f9c931989671a83e0ab7317f605aa',1331823322,NULL,'_pPXFH-BN5X4EhfO8J-gWuba-9WIVd8IICDdjyNf0iq1muv2yJaMmFH7odsXqNqZ-i8UA1a6I4N7rqRSNJmVGKDwrDPdN1mV-KF6WjV2L9tnY-TMZxSsb0sLJO6zQIZY05OJy81g5VIX_VOR5Peb3w..'),('1297d97ccbbcb33a0a2d1a7bd43fd8bd',1331828169,NULL,'b9b346mCeryhgadNvCEcEhmUTP8x9b9wXpFDlbTUDIF4iQKZoe9Ryrr9x74cpuRO-R72vCHa5q51P-9EvKkTYGnfStKBsgdAEfK-W9ZI6QJlO4lqzeGxhQv78zzqvoDKjk5I128j-9V856m1fZ3MBy857Yx9OZut0GIF12VJbO55CuFrEb1IQmWQVBG_6C1J'),('8c14d17efda8e2c5a7cc9b995c3e7606',1331838875,NULL,'4jXAX1d08-cCkZtXl1CRQNt0kExUCGn4ngGB1gbuycJQ993Xxi-YF6dpn6OCinPyl8KbHlRRz5-_Tv6xsY6H-i9Fl2rOcfYJx180FDvWv_66zBNiTLpzFzD8Aa42gyUlMoPlVN1bLWwhO3Zdbwxpm5wc6dlJIdpjzUzW7mvEC7buksJd605K5M-njrFmjsiL'),('739611687fcfc3f5ec239c647a480cc2',1331844433,NULL,'enTDP55Co6pdtA16O5UPt9smob0Vgy9e6EWDwokhCkirOmuaVm94DLbChhoQtpd1SjubFNj8RYFvQmoVDGCRybT_QAn9NKaKSAdZQdcGoT4wEY6dCtsh_e2HPdDMxodJxW7rt_NP4aWsa6uRrbUbuG4iBBccvnc2_rjn0PA-F64.'),('7da47c74b0109b8a9a91d63a0ba93ce4',1331849695,NULL,'h_SR5s5DLEuEuBW4PRwnJ-MldyD-G76WtPeumKUdfL9Oc4qfvqi6J3QwvbJKp-TEuZCsA_HmoNUkllJsex5sdUxVhMS2mohuOgyzKkVQIzNDHK8d4817RJsa_rnEVhpCbueenjskXPA7aJL-DsLcqeRnHsrKv77GMgFA1cTxqLs.'),('25c6a78a58c3f7fd881212737a0c28c4',1331855253,NULL,'0ZKivCmZAymkV6XIlLHpNaZQUCqLtd23taT8aG19OoDAh6DTejMIaVcrvxi8qJX1cedwEH7Ywz08OVaO9rMYK8yu-KScLbsdufhN_nLyHrEetFh15Et3pDycmuud00rC9NNylnbR5KFgBF0y0XKn0Ji_g0gogzXupPD1S2BjoUAgIPKN24p1W9KgMocNFrrf'),('abcfbe30ffeeb0d11d998f3372f6fa92',1331855895,NULL,'Bf4boZIhpPFsEpOxvMHuttjRZwVFVbTS1Tf6KR2lY1OF7ymtmI6ol5wI1C6Vs4Q8bTmaf57SeKKNyFvqORH-O3zHuJ37xxBnXtPYHSBjV4W9SK_6ts_dAA6nKoJQJ4K8TOnxd0lWIKY2t-KOsUEnVeaXyLkddmyt6xEzshmr3k4_lY37TC0zo3XmuDJLlPhJ'),('704faca788f4cf40993a3d5ffccbde6a',1331860482,NULL,'vgeWMSHlcvtm8LSP0B7X-Y8RCU9g-uJmtDeqr762xZ5izfwAalD0QDs49GrcPRq1ipeTYLfkKi6D58ZvwmKRpejZKUPkL72ayA0T3R9_KOLPMin5NJXkS82PpN1wzYbGjXAeZkPhElsWTgvo1ntq5BWQ28ohL0hbfCYeHdXlrjo.'),('59bd4b68d9ff3ecc470bea7e631b0d5b',1331873951,NULL,'ZPLDHwfhiwoqCsWMVhOQqVreGPdzejmuraFhY7g_3Pw028orzpbh2QQ2wcRW-J3P9P61fQoD-rGZOU9BPGi2EsScrUWbDuAT8kO_gfClfsGmAHZ6gwk8CKpKqbrwflZ7tfd1UJauHJmJ9c5x7KdZty7-G5NRnaojWemlvyA8vwp8Yh4yh87lfCo2u-xoMb44'),('bcb0292633af79d562ca90cc423443b9',1331874195,NULL,'356aVNmTLEUYmM_ORJKMNo5H71HnMaBSk_-ju3nOac6bfN4ojrgveW3Flqga15J1ECaFXVEFGEGKU-8HclYaQ2JO1YTa8zJyJ21YVLLsW2eNl0uaT-Ps0ULhPK9g2MCQEifrDKadspD10ZTVP0f9pxnCwDaGUsFnzz1-k_znEa4.'),('5aba81ecaeb72dc180e7c7e04d54824f',1331879939,NULL,'vqTjFVHn5Mi55MrLpDGpgILZcYx9Z7pWrh_gOwwWlBiVz_4_ZUXEX-x_cXx0MlkxOoErjf_rwRnYMQdIWPjP29Inc_iAQ9MhhLBJ2gQZccDdErdodPnRxm1OUQmS34PZ4siVgHK8ynnOsRdLzmQQIHrZYyZQ1Dpe6xTHTnJx6F8.'),('9eca2b8ec5cf3cf289588f49e2f63c66',1331880664,NULL,'gMJOvKYAVvzPiLGzyaEz-El6ZiR2JUKb6rOM_kUMnyZLAlLcmuSRShcVc6WTU65MMdwsLa82iFoSEuIet23I1F9gEC9g_EbKlImiFY04WEkAbgog8LzXNT6iGXFPFl2NFUEtWxVLqBCWm7GqFgfk7li3fbEpIUu80x1o-tQyq7o.'),('3b0a819f3f31f72f808f691ab3bd599c',1331886037,NULL,'uBbUikjMGA-qlsFXfWxfU04kjsZM2WIzjV5gHhpfJF6DKa2Rw_MsUBwEBVoRT3g4eULkfuW1DhQQ9Im-dakY-7yPZL8eY5Vr-CeAiyiVPRYfWIcn1EmCyLlzZNz__QxrIXnqQux5YzmN8b-5bkQiOi1JzKzQ432-Yqr0Q3lTvos.'),('60f6598f53c56d64300113bfe6d340fa',1331891970,NULL,'OjKtYoOTYuW2yYJJzhadtQm_kBMAtrSSlibaA4HZBinKKZ3HfmdHLONL_oWfq7dGs6ggG92dX3oPjQliflRWlwA80KidzCY0DunVs4yK9QzAOoHUw0FcLIrLQ0vFmgmaFxUeuzagqa2F5l_zEuuGvByj2ipuXLMgdzkwlA_a5YA.'),('60853c5fe39002c307abfbff128a5c7b',1331895648,NULL,'cTWqROJNhopvZJJXm3YQI7jXTIhRXPvwwb57qD-DdFrj281E7VDHVaBOPMz3b8PNdLV1n77ja0s9RLYCFbMgsXqWxpVEmbydtI_Hb8E5sAzDcodWOFYT19obwKbO-5rj92vhK1mNfsNN1NTeTdHazPURJDOsQy67lxyrnPrpukQ92WGEFrlUxKT422YThrlu'),('6defe0b8180b9bd807cebad31132c631',1331895651,NULL,'1jT0IjlaJC7932bIq9mzhLLhpGLUKQ690qp3-Q9gpQq2oUbqMHv5rijN_Ik819l6CyFpnG8YJfWeNWzXa1yy7SwmLZxSm8cvvnchaOCZqZS5wbWpYDXw5mgfF5EPOFP8MJ0vqii-N2EMShsR3dvP3h2bw6mAgstpTbSjltbjqDiyZdKGv2MpZbQp7pqHi3ZC'),('a29fdec7140e125a2a6581d6328050f4',1331895654,NULL,'Nk_7NB4tPrfON29dDTS04RVkN59kJRD-ejNGw5MNScfuken6HU0HyCa-aujyjBmlPHkEXhHFRPxXKZiM3-FAFF7DkmheAXGy3g4fZOmq8UoqHltaqrNG46IfxQ2klyqBsfIrp5MP1hoUZmyWs1GXoBX25BORgPQxEurr6QcVBb3zLmnd0esSa_5fmox_osst'),('d472ac4706f88ec1266714ec78067d3a',1331895686,NULL,'3ONfNJr1zlp_VJa9pdMRHqsI2Q5GIR-qF35XW1Jb2lkUKshQaXy-yx1_PmiBn4NeKWnxp5BV-MmJVbdNgWGLBA7R_2jYFalpeddl_4j7YLiw5EPNyZnbPxdVnQy14qUWAdI_AAgyNaD7Au8AMNmWLrnkY3JMdfwr7gqk1TBCsoFtPp70VgKtk_LLO26wLSD7'),('7cad2d3e441d9db8cc133d0127beb1ca',1331895700,NULL,'oB32NQoarFzmQTMIQ766mX0v2SyYS7rkC8q270dOyeBpva-1xvuGB4pVVyPxnZf9VMkb52W3ojKL9rPmGpqxzysv3Sc8o56zxeDdSoqZNASwe8jhqzjsLyojSkI_bBWw_utKoOWEIkzWRSf35eqaV4kl7-M7OtjtPTb105hjqz3nq_owDK-11w24K2tjhyxK'),('7a054fa0053f3b832df5c4c72c8cb65d',1331895703,NULL,'oB32NQoarFzmQTMIQ766mX0v2SyYS7rkC8q270dOyeBpva-1xvuGB4pVVyPxnZf9VMkb52W3ojKL9rPmGpqxzysv3Sc8o56zxeDdSoqZNASwe8jhqzjsLyojSkI_bBWw_utKoOWEIkzWRSf35eqaV4kl7-M7OtjtPTb105hjqz3nq_owDK-11w24K2tjhyxK'),('54fa0d4b488484001e0fa7677d9b816d',1331895706,NULL,'m85kHbatXjtU51DT5g2YNlzB3yf1r45SIT_Kk7t-bXSfNANeViQKa7ul8i-m773oRF0dENIUQTR5-CzbQPzFagKYIsJJoATocfyicHIwNLTVnCeIaIL9NAILvHQnQ_bkb88JCNAjmGvo6yS0Mu1cvgIH-A7AhvJJfu3Jr79d65V1qz2lUi6V4m_ZYePBpAOs'),('3121b822dd9c94691b9bffa996dcadd1',1331895710,NULL,'cTWqROJNhopvZJJXm3YQI7jXTIhRXPvwwb57qD-DdFrj281E7VDHVaBOPMz3b8PNdLV1n77ja0s9RLYCFbMgsXqWxpVEmbydtI_Hb8E5sAzDcodWOFYT19obwKbO-5rj92vhK1mNfsNN1NTeTdHazPURJDOsQy67lxyrnPrpukQ92WGEFrlUxKT422YThrlu'),('24d07a4ff20b06cc5292602321a06a26',1331895714,NULL,'rzE6KRo5D05S6SgXk8YPl60VOnAr94yAoAX9TdZyBzKdMt9vGWvA3-CYhukv1-AEcEskyI_i3wxtNztMxs1PTDn3MklMPl1Ql3RR0hnrwSt0zW5iCkheGg8MCWBNKdpfJuBrd4oXoMdu1Eczp4Z6dmnPQ0qmO88iOjBKi0wpe8EAYQqtzE4ue9s71EKMJ_u7'),('9f025e73588fdb8c914783f08b45673b',1331895735,NULL,'XRKtFkAKcvqogVFe9JF7zzgddKejSRNM-p4ENGiuYVsiAUTAhLveL0H241P85UPvjaJFcohm1rBixzkuw5XKF0CR-Qj42SbX-dJsYmA1StjFWW60lb3LyhHSQzdl9TQxCeMdniDgm9EQYEgh5TTBsMgljE5LeC65GDBSdxnBv1t6s9CZmSuo4gyjwOimfZHX'),('a1f64c59709e133e5c429ded9f715595',1331895738,NULL,'m85kHbatXjtU51DT5g2YNlzB3yf1r45SIT_Kk7t-bXSfNANeViQKa7ul8i-m773oRF0dENIUQTR5-CzbQPzFagKYIsJJoATocfyicHIwNLTVnCeIaIL9NAILvHQnQ_bkb88JCNAjmGvo6yS0Mu1cvgIH-A7AhvJJfu3Jr79d65V1qz2lUi6V4m_ZYePBpAOs'),('376695bf3f1d5ebb131bd25ddb6b4696',1331895743,NULL,'oB32NQoarFzmQTMIQ766mX0v2SyYS7rkC8q270dOyeBpva-1xvuGB4pVVyPxnZf9VMkb52W3ojKL9rPmGpqxzysv3Sc8o56zxeDdSoqZNASwe8jhqzjsLyojSkI_bBWw_utKoOWEIkzWRSf35eqaV4kl7-M7OtjtPTb105hjqz3nq_owDK-11w24K2tjhyxK'),('8f9079daf66cdee1f14449fee22a22ec',1331895762,NULL,'ZdplllK8GNqm_e9rCczbtXBj1FDOKBGuEhmf0wrrzvQHB15cvWTLzGk3pVdn-IE-IHfmI7cMOh7uCl5LnLzBjP0mtgTJHdwK61nbh7rfGizUe8JCg61iGdfYZcteVP5RTEHZAza1XJwY7TqWl_PsYMZnVLWwp7mkRn2KEPREUcu4rLR1A3QrC07cZXQ_-GJv'),('02c32ef1d89513efd4a143b0ce9b0928',1331895763,NULL,'ZdplllK8GNqm_e9rCczbtXBj1FDOKBGuEhmf0wrrzvQHB15cvWTLzGk3pVdn-IE-IHfmI7cMOh7uCl5LnLzBjP0mtgTJHdwK61nbh7rfGizUe8JCg61iGdfYZcteVP5RTEHZAza1XJwY7TqWl_PsYMZnVLWwp7mkRn2KEPREUcu4rLR1A3QrC07cZXQ_-GJv'),('7645e349e7e48172d85a9382dcebad21',1331895769,NULL,'QKo2IcbL8Ijvsoii-E5UqApqp4wde9J3EpNr6VwhR6FY1BwuMSEVcGSjdJwH5OlHlaIDClBsdH11VVXHyJYodnMrSObDQWeduNFex9vrolmCjCliAqdPpy6ujeHuUQ5m6ALfecJGTjkWJ6kbvKygkgIAmGr9bhU9f2_t9pfs6e7YWb6fzAMtzEdeI5HA2vK-'),('9895ce23e9e7d362715bb08f732928f9',1331895774,NULL,'RaVORR9ig1Dhubql3bbgyxS_PEVMuyBXUD_srOQ8yDPQOjgNRkoK4SPYULc7z43-f-qStHsLIsDbVD9HyPJGp2MFC3xtVwWW2u0d5G7vefnaR5CZ_NyD8TXg3AML6_sUtE1kmjBXfDgkuAncsya2utGneMYLostpuUjvliX7ob8c7D--qogT6pMgurilwtns'),('345e61ad0ec9e0ad953b7ce8771b0e9c',1331895789,NULL,'Ghpfi8gWhNCbW_nmNLrbWy8MgCWvsaGLXby4AhVLtfaBF0f59j7vMWXLMGHGOWPaiVhvEne8dEWU_YPKdesNtZRjyvDvfTYf13RaojRRFHY9CnCSVTD1j_s2KazpduIQT_2cig7Cxig9TFVGoGnkHewP0xReIth9_J6P4NAJ8cKRESNOmaK-AOOgscM1lYk_'),('ccace40fe0164d47e2c1d1659c603e92',1331895796,NULL,'IzmhDmJboww1negkMRwPoBw54IQT0OGi0Mnp9mX3aWTp2wbbGS7B27eKADgEcK3pK-Zc0v5DzCxHmH3b0i3PWUCis80X_2DU9nDUMMIGlmsofDuI52SQ8LDQJGvBpS2UJoeiVyF60WJaLYWkUXF9RLp0Vw1o_99eE4AAnBrH3ae20HUoi6XFHep1hf1ewzCV'),('4f27904a1aa63e07bb26cb23d279c555',1331895829,NULL,'IAXtA8Vfq_s6U_H4J113VQTL0GEqLjBovMb0L7ff_cY-9Ur0zXxHombChE3qBkqego3oMzgHVxk3X-8OcU9yCLmBgr32Lij04Cs7JFib6_SsqcJa4paLFaMHuyHQNCEVA_gMENe-lBHr9w0KuWCjYcPoEOZKEJkdhXbD4XBZ2jVaxIqWxBkyxuIR8XpKgHlt'),('1cb2e98dd700ae441a5e0fb55db6f809',1331895831,NULL,'dT6KN6HnfFXJ4Fb3C_tPqNc8yK5hUximY_f6-MUQsn_CqZJ3JSVWqKz_AS63hSAFSINi91oQPRkwRJS1zqCOEp2wv97A-MqgNJ5--C03IhB-vvxCzCBVUvG4PAkO-IFzAa1x5ggvVS17v7IROpvRS5fjzAePEHDJdxWclXCuxppbzOjmpziZsDhShtxCuU-k'),('d22d4bfc9bc2865936b1478bc4e2aa58',1331895841,NULL,'slqIxYKsZLX58DHEFPg96eVlc2CrTCFqx-_6zPHzMsNhV0kUya2uXNdLSZEQs6RVyPUbPpTci88pZcVEFLM6DvsCjCRzgEPPwQ__QCj0FJ2EPgr6MLGsIrJY_ZP2ujNIHGXkXCWpphcVyjEqtF3md04ZGbXaBvwE2d9kpg_BIaQ.'),('1e7747829521da5095272330f36e939d',1331898443,NULL,'srvEiU-PuyLuNw7QQDYpMAxsn9FGJvec_1HdXlkEtUz2KUT9R2UgmlAzns8_LZFkifnHctN2xJ9de589wPZ642YbckNGNb6FXV07nf4nL_kq8Qb-vyb2QWjgI-9gkZSUh3-a1S26oRaSYwhWBkmy75RLiEeyDeUUkAq_ZhAoa14.'),('ab30546a3fd6db14b0117140f8ae2075',1331910048,NULL,'CMtJmx03qyJMfvPdO4BZSIUqOSEWZM55BzPxDCQOquYuZNWePvOfnLKNffpA_PX-tDF2yl1UR8cBLq89TLAaaXtaOuXI5OS3mmV8o-JCwOCVv5jE4PGDooafVHwkg2O82kbCjt6nacGOJB7Ndrq7m2GoJhT2aQJt_eYqH7Ig3jk.'),('788a311ed934fae43be765833449ec99',1331910281,NULL,'6be1uELdVfxFI37bQ5hx5XMF0LCIV9iBc4zKDgw94hyk3F0XE984Q-qlEBv6LegsS4bl4fP8NxRgsVF-B2do3eaqV3o-mQdiMZXpjaso602CWhIOTn8H8tmo3slXA5BnoNi4cBSAdOJnZUEZKsxhhg..'),('22d455cce287fb207d77268237ef94ba',1331910529,NULL,'3XjLuDqgSn6PXC6Wbwkfx6kwhvxmMiaFw6Z-ksFisSG0g4ILeXFSyAw6Nb5dHPXmbQcjkSsErYJeQFcZ686shU1U0aBjoOFP3839zuFqLebMyQuDxp9IeQusBmxgX2Sc_5z1gdC3tJM9ds_N89HS6gFM5VJ401KhiStL8gGuj8Seycy_6Zec6rrgBv6J7Y-m'),('757d731cd837d64fbb27602bd69c5fc8',1331918658,NULL,'Kq8sVt0i6Fo3p0Syc4MBy1D9kUjsstZLFEJPcpWJcy9Fvs7aW7wIgLWn1k-OkV8_J81zzFdlCLb4fW_DaxvbZDbBILxYSVegTCW-8gB6NixdCbiN6vpNEmHkUvietNd6hizXr0hv7hSPP_GGq-wvu4aLB_pFI-S0BZthanYpc25lfKrXyi0Hp5npDaoXwf9U'),('faa13a24a943597496fe9a3b2ad99cf1',1331927371,NULL,'2rhZqow-Na1afsQZTaK6zV5bR-PrhxQj6iSz98IFjwsnoC-PLQKeHqCF_pHvZ64JFJQd3zcQKaIqRgYTrUBW9ZNGpZRul7qbk17abqqgL2OWeYb69XE-Bbt6UBhvcAjb4IKrDfHWKamx6IFsIeucmJPl5s_E6HxWDI-TBd27dPPlvZut8gK9AWediLLo_GHy'),('6371050242ada72731cda7723742dd07',1331936732,NULL,'d-anRUFA0zth0uy23RsVBylcfh1XZvgcQV7ioNdyfX5cFaaeFf4jLEbvfO9_qzao_88rgIs3J8insTZKupTMr_mI9v-7cunqrqt4f43trnmsc8Vn7ffiKz-9AZIIdRaCxB4ByqqhAJ-XABEpHQfZig..'),('e9890c46b81a69461f87d9945fe31600',1331936796,NULL,'d-anRUFA0zth0uy23RsVBylcfh1XZvgcQV7ioNdyfX5cFaaeFf4jLEbvfO9_qzao_88rgIs3J8insTZKupTMr_mI9v-7cunqrqt4f43trnmsc8Vn7ffiKz-9AZIIdRaCxB4ByqqhAJ-XABEpHQfZig..'),('f0569ac060a7fda7e27117e67511bded',1331936928,NULL,'SaM_DOU1xmf9XYiwZW1kypUqMryZ1bVmthl1Zr__l9M-aF3pJeBSKk4HCypVpiChemgxQPy7XxFAfFjtYBhvDHRfVgNyoQsIOnreBMD7sckJM5hb-VnVrR-02Zx13t9Mf98DfrkQ9cwBG2eVAIrF0yYRahxsueBU7GKqiEa8gQ8.'),('01097ef74f9a866acf43915d06b33c74',1331937000,NULL,'ZmY_jrccRwXnLFxmWuzbCX2u1GCK1eeQVTGlqOa5JPKKOrUfwSaWQjU8yv1d_esJJIaTbW9u1dnEPO97Nw3jfegVJaev8arATKZD5Q3TqHMwD-0NHnaKRA5FkCzirEVJpFjCv4RDnH9gs2ACwfLmrHpWIkvZZbC54VjIC0QFXwU.'),('3fab02413636230bbb63e48f1189fadc',1331937065,NULL,'3Y5MO6wYde-to9e3sXDzJcXyF3QibhBfQtL2zOU5Bp4rDn-fdr__bA4OsthbZt55fx_DRRjFVBYFrlT6dw6lzLuvQS8wXTwb4v3dqHQQlPly4FafJwCFBJr8dHY4x5whkdXRpKagtyNQIp0RqD6UN6Em8hbwRGmnJoyvSBBzO_w.'),('11c517b75bff65eefc3ea8f287d4f1c2',1331937131,NULL,'miVbEGmFtJnqa-FWZme6aLkIoxq55y5lv14Wh9qnJkdbzIXHITxH5QGam9ZgjCVVGgTJ6b1odhWcH70TxyATKtqFJIm7YBdk-HiDQ574Guzbi4WnYfbw55o4T-oCG8n5QHRYkbp7sIvHy9QkpWEL1tTxvM_RhPf4mQ8lVWCYPiM.'),('c28d599239d446c16c26a3aad9cbf780',1331937260,NULL,'QapOjYE7ejIbTVPjd8t0NRCUFdNy4nEsKe7hXwFnYDBqUdf-dL-s1r2Tu_u_vF5_yPotWEjrodtcB5i97L5HJsf59qV74cpIzg1B4ETf5O1nqnHIkB56lVhArDO2DBhb-CEsh9dHwtOC6aFzeWmD5Vu5pXArA7JGzuEKY4NGorIWT2UaSwbuK79635zNEalC'),('09fb8dad1a2ff0c68d22062066021cfa',1331937300,NULL,'elPcOLkGX3sMgw6alwFE_JE0CS6Nc1GhZcUzYzEXOpGlEw1q4A4hyLgVGZLAEygdnL0xmtZJ0aMa7Jhiiis2VwRu7w1lJyxIhP1Vv4qsEkjyXxWipWewwRVn74Po4Vmygdoe2QMvStT8og7D-pZrfw5BOx9-xWnpQzPUGOBXa_M.'),('15b0cf2e56d7f73cc52324379ddaecb2',1331937366,NULL,'l1_qhzMstL-TPEEhQ_3bCR1GceG60PdpMO7JZWHcl_Dm1Yw1--Y5jV4mLpkEn_uHd40i9F39i7V7PAIl3GBzGL42lVBsE4rIQlnibEtdzL-kTZmfrzyqq2LTw-chPrfIPxzARxPdoLhRdWFQpWq3iXXvDgRUQs0uE4Ucxk55hAQ.'),('3bc25a9a5a6808b4abf2fb159467ffda',1331937512,NULL,'8GT1x5P8xe_uQHsE26fokHdCfo5gDQGtuHQBiK6hsCQoa0c5QhjX0xqbDOFd1t8jxsRhfEbf64YNZsS-w0zQjVuU0cEQo2gM3hAC4gKytNO9plHQlOBxOPvFO2kc6V4HGvCJRKxTVsRZrWsUw57rmyGxFjHua3ueb30lenr9b1A.'),('73d14d8fc5b9d19a09ee5c622e7dcdb7',1331937603,NULL,'d-anRUFA0zth0uy23RsVBylcfh1XZvgcQV7ioNdyfX5cFaaeFf4jLEbvfO9_qzao_88rgIs3J8insTZKupTMr_mI9v-7cunqrqt4f43trnmsc8Vn7ffiKz-9AZIIdRaCxB4ByqqhAJ-XABEpHQfZig..'),('d26243e61f70a7ba070ef15e582d5307',1331944478,NULL,'lRbSErvqv-cQCsM9kR7s3DACT2fxiXXj3BhZ5poi5BZsNLgUSAovSE-8_7xitvyugmJGsZepZ6Zxnl3X1vBbaU9F0NTB2Kug6V7Rv6SUtggikUjWGth-K7SbC55EnmunMEqDMuYW1rNn_aCWqKMk70Ju7QkkvNuF04xB59xGHN8qDfX1fGKS8sq6JAKw_6AS'),('ae875dd4fb571c9305f76af15a069a4e',1331952255,NULL,'uLK7gpLWZ5vvQpoV_zCGl3Q2YNr1Q3ea1Xi6BrqHh4Yu_7hZlXfqP9HMXLs01-DFrPNIvUWSsgNckjmHZxBRVh4Hppjrx8bhEZ750a_2LTHSsvbbtPymgtxoKbfxvqQrtzT_2fihQiajH6wi7Dl6RYOaPgYKjmgLaDMIA8ZTt0CWsKvkkxq9eDdg04nK6-vK'),('92e341b7c47bac9c02e29c5f8c2c7fa3',1331952501,NULL,'3nG0yQqvPZ525Ybl2zg7hj2AH5OhiA49hX5aUgx8bsJs1gkgQoC2SCSvIzsbI0HBu5Kta_00s6TCKzy7FaUPWfM-rzbKpRItiH7vlJwMzJHqiKRpWl-4wqAXs0QhmTn1N0eX6f9_awS2uNATy_m8w6VDGbpUj1exTnhC6P_f1lA.'),('5f3dbe438d30c76ddbcdbfa2fe80ec8d',1331955183,NULL,'zx8PlfYgppIrhtgqsJCl6AGfdkT3ulAwhhswtOu2gJHfBOAXEFeieE6IrtvHUMzytjNPg5lqmhwqhqzTymYYGJxMPyWAAK4PIZtfBXHk5FBK-9F0il4fjkFXhEy0KpPqDWV9-Eqy14fBybMPwIyR3zp9MD5KEOvnEZ9eMdDbDkVX4NiLQ7VtMqMVnbK74rQ3'),('baccfba790da190ae18bd773405aa6b0',1331955183,NULL,'V5QzzW2RdemffHNyYoz8JGMcU0XYUjBLoFfqEZTpKxTg9bFcBcGhmoEu32hPTxfd8xia6LxNBL5B6zkXhuT72cokXNY49GhflJrwjlpKUN-TWB7goGxvWlliTPfH95AQXJNVh9mSnL_O_AWDPQMH6_Z__Lu9eX4yd6_uHWyp6MnKm1O24atCVSC0I3e9zNpR'),('3a67156ee1910382350c2f4df8b02c32',1331955184,NULL,'cLKrHibqmRMFwX7KTG8QeiywtkcREyCPzVU87HbSKdm0do0m98TX-usa2FbYkcGglcdVGGA0vtoQ91peJP1IdcSRbSEi_y_pgbr0yGXEZo9KEyh0gNc7GDkypmSvev0lCusMatkqAUpPKxtky2Y5a6w-CVkcNMO0e5I4r_hZW-UnuoY-GB2-BJhDrEwTTmrW'),('1ec95ef87f9dc0998f35f02679a55b9e',1331955209,NULL,'bt-hzaCU3swllGa3_q-zZYnHRS4qI0j00MMwOW_8yWZW5xLIMoIsYo79ezdZ2fdwPsfqQkSQbIbVo0X558PHQ4DH8lNe7FbfiJei8hJmSi0yyFUdJYHq0sIMugFLmaCyCUa4MsmglfhWHtGgQUJ0Y1i9pRBSbnaSXTaNf6VywGnbpt74tjMAcibER9O7i8yF'),('803b9c17fa04d26f4c7bd81f2904719c',1331955232,NULL,'sWI2ineWuYKqg_9zLFhvzTQ35WmC2m5wPmScxPigznrx8sUjvhDF8o66ZPa48MGmbjujEEyiyUVi21GzbrRoeLgjUER3-0h5kYhMnq49-mvxn2y25fs6C7g-BS8OloZOOs6bsNI-OwEc2PlHAmfmuBnFW2UGJ6pgC7eero2eICz3DjqlMOUdRtJqivCrz0xc'),('080867a154eacf0922d28d787bb841c6',1331955233,NULL,'V5QzzW2RdemffHNyYoz8JGMcU0XYUjBLoFfqEZTpKxTg9bFcBcGhmoEu32hPTxfd8xia6LxNBL5B6zkXhuT72cokXNY49GhflJrwjlpKUN-TWB7goGxvWlliTPfH95AQXJNVh9mSnL_O_AWDPQMH6_Z__Lu9eX4yd6_uHWyp6MnKm1O24atCVSC0I3e9zNpR'),('5e1739b631463e7d481f9926ce148013',1331955276,NULL,'zx8PlfYgppIrhtgqsJCl6AGfdkT3ulAwhhswtOu2gJHfBOAXEFeieE6IrtvHUMzytjNPg5lqmhwqhqzTymYYGJxMPyWAAK4PIZtfBXHk5FBK-9F0il4fjkFXhEy0KpPqDWV9-Eqy14fBybMPwIyR3zp9MD5KEOvnEZ9eMdDbDkVX4NiLQ7VtMqMVnbK74rQ3'),('99fe31879bce1b97fc3b04ef6fc86b2e',1331955277,NULL,'V5QzzW2RdemffHNyYoz8JGMcU0XYUjBLoFfqEZTpKxTg9bFcBcGhmoEu32hPTxfd8xia6LxNBL5B6zkXhuT72cokXNY49GhflJrwjlpKUN-TWB7goGxvWlliTPfH95AQXJNVh9mSnL_O_AWDPQMH6_Z__Lu9eX4yd6_uHWyp6MnKm1O24atCVSC0I3e9zNpR'),('356ed569b4fb028ebfcf01b544a582e0',1331955278,NULL,'3-2n2dVBUuYGPTEiU1QErVDRx77CoVYdR9-HiZvD02gq7jJnJEN0LPNJzLBQSaKidVC3bWwgqtFD_GXHTfrtP7QO8PPr7TW-_chwUwLScX8gD_fCbe_5YJ_c3KmymhmPRnGfscDJu1E6AEvOhBgbl1LALEzk79ayg79McQwVGFwcjq1xsilv7mEFq44_heCN'),('03186a5b17dc11c8b154a4fa4d58324b',1331955294,NULL,'V5QzzW2RdemffHNyYoz8JGMcU0XYUjBLoFfqEZTpKxTg9bFcBcGhmoEu32hPTxfd8xia6LxNBL5B6zkXhuT72cokXNY49GhflJrwjlpKUN-TWB7goGxvWlliTPfH95AQXJNVh9mSnL_O_AWDPQMH6_Z__Lu9eX4yd6_uHWyp6MnKm1O24atCVSC0I3e9zNpR'),('9e23c89d02bf6b27c5024db71c45711e',1331955294,NULL,'bt-hzaCU3swllGa3_q-zZYnHRS4qI0j00MMwOW_8yWZW5xLIMoIsYo79ezdZ2fdwPsfqQkSQbIbVo0X558PHQ4DH8lNe7FbfiJei8hJmSi0yyFUdJYHq0sIMugFLmaCyCUa4MsmglfhWHtGgQUJ0Y1i9pRBSbnaSXTaNf6VywGnbpt74tjMAcibER9O7i8yF'),('3fbcdd290e34b1e2fb9d131c5373a91c',1331955295,NULL,'V5QzzW2RdemffHNyYoz8JGMcU0XYUjBLoFfqEZTpKxTg9bFcBcGhmoEu32hPTxfd8xia6LxNBL5B6zkXhuT72cokXNY49GhflJrwjlpKUN-TWB7goGxvWlliTPfH95AQXJNVh9mSnL_O_AWDPQMH6_Z__Lu9eX4yd6_uHWyp6MnKm1O24atCVSC0I3e9zNpR'),('4a61b86bb64941629b5870388ab862cf',1331955296,NULL,'bt-hzaCU3swllGa3_q-zZYnHRS4qI0j00MMwOW_8yWZW5xLIMoIsYo79ezdZ2fdwPsfqQkSQbIbVo0X558PHQ4DH8lNe7FbfiJei8hJmSi0yyFUdJYHq0sIMugFLmaCyCUa4MsmglfhWHtGgQUJ0Y1i9pRBSbnaSXTaNf6VywGnbpt74tjMAcibER9O7i8yF'),('f3504d17f0f831a0a4cdd6bbbc2f1bc2',1331955301,NULL,'zx8PlfYgppIrhtgqsJCl6AGfdkT3ulAwhhswtOu2gJHfBOAXEFeieE6IrtvHUMzytjNPg5lqmhwqhqzTymYYGJxMPyWAAK4PIZtfBXHk5FBK-9F0il4fjkFXhEy0KpPqDWV9-Eqy14fBybMPwIyR3zp9MD5KEOvnEZ9eMdDbDkVX4NiLQ7VtMqMVnbK74rQ3'),('1fa91c035a261735e0c83ae59e5ac79e',1331955302,NULL,'bt-hzaCU3swllGa3_q-zZYnHRS4qI0j00MMwOW_8yWZW5xLIMoIsYo79ezdZ2fdwPsfqQkSQbIbVo0X558PHQ4DH8lNe7FbfiJei8hJmSi0yyFUdJYHq0sIMugFLmaCyCUa4MsmglfhWHtGgQUJ0Y1i9pRBSbnaSXTaNf6VywGnbpt74tjMAcibER9O7i8yF'),('2cfa0133684d24e71133d436d686b1a8',1331955324,NULL,'zx8PlfYgppIrhtgqsJCl6AGfdkT3ulAwhhswtOu2gJHfBOAXEFeieE6IrtvHUMzytjNPg5lqmhwqhqzTymYYGJxMPyWAAK4PIZtfBXHk5FBK-9F0il4fjkFXhEy0KpPqDWV9-Eqy14fBybMPwIyR3zp9MD5KEOvnEZ9eMdDbDkVX4NiLQ7VtMqMVnbK74rQ3'),('365856532308cf6ea884649778d51658',1331955367,NULL,'zx8PlfYgppIrhtgqsJCl6AGfdkT3ulAwhhswtOu2gJHfBOAXEFeieE6IrtvHUMzytjNPg5lqmhwqhqzTymYYGJxMPyWAAK4PIZtfBXHk5FBK-9F0il4fjkFXhEy0KpPqDWV9-Eqy14fBybMPwIyR3zp9MD5KEOvnEZ9eMdDbDkVX4NiLQ7VtMqMVnbK74rQ3'),('c56b1c9e5a190d0a55078548acfe01a3',1331955377,NULL,'JAcFFhBBYCcOv7TlPnOKR7iW8pCGSVJ5fzVxqHXxuj4Wq3h9HGMCZaq_CHaGLTw-5zYMhW7NjEuT2OZJAGSap3-Px16cE-FXjN-TqOVH-ecZmI2OlVDQ6-9acmHMcaS7Mv40JDHHE_uocYE7TrPkqMO5ioONyn80GgetlmLlbqAeIlwnRBwO4cHDKMKXn0Ov'),('ad106398133361230223a67c2dcb7293',1331955378,NULL,'3-2n2dVBUuYGPTEiU1QErVDRx77CoVYdR9-HiZvD02gq7jJnJEN0LPNJzLBQSaKidVC3bWwgqtFD_GXHTfrtP7QO8PPr7TW-_chwUwLScX8gD_fCbe_5YJ_c3KmymhmPRnGfscDJu1E6AEvOhBgbl1LALEzk79ayg79McQwVGFwcjq1xsilv7mEFq44_heCN'),('e8a815e9bf551e37d61a6338abdf4f66',1331955382,NULL,'bt-hzaCU3swllGa3_q-zZYnHRS4qI0j00MMwOW_8yWZW5xLIMoIsYo79ezdZ2fdwPsfqQkSQbIbVo0X558PHQ4DH8lNe7FbfiJei8hJmSi0yyFUdJYHq0sIMugFLmaCyCUa4MsmglfhWHtGgQUJ0Y1i9pRBSbnaSXTaNf6VywGnbpt74tjMAcibER9O7i8yF'),('2c56336659c6cb7faf764f263059c214',1331955384,NULL,'m_d9lbIM35Cl6Bm6iTGLKB-5spCsIuj3Eesq85ZMNwHmrFRCQYl9tFAgLURQ3diuv5cbPoJrmwskUF1pXcQxDwvTfM7Bg5oYbzOQo_8WR0g8sezqP2dBBQHjW2hqKRCwW52hounkINnssGs0MZi199ELOjzldbH1jDcjpqsGHc8.'),('f17248be35cefb5791a0af7839d5f025',1331957470,NULL,'prRR_E91J8B4U9naCwBGU0KCUylme-L6y0ViXK9P_1c6fM4u6skL9fPFHZjRTNT197o11U9MVU2AD4xOFQS8yc4Y2im59SMczDuGOTZIl_pZNSC6gjBEfQ7Ntm160BcCM7BcGY--3QMFyH_RSvYnPQbBWHJSBgnfTWO4zxGSKRQ.'),('0c59917882428011051e38f5623f1adc',1331963055,NULL,'KY-nOOY3a-UDmfNQauiLPg2c1el-GXkrqdkZ49vVRiH6ApSeHDFoPV7-5vOj0nvjT9aNLBDNPkF2PrUFwO6yQavmLgru3v9p2EWSC3RsokCArBzHtPsIfVxyKPNIS303xTOTEBKZ3qAegeb0BaQD8MQb_UpPrA4h3QuHesLU2rg.'),('ffa83d5bae694045950632aa8c9ae795',1331967026,NULL,'j1EOtBePXM0_OwyZHYsZeVHJgvPDaKdOUOFAhoChQTdumpChCDBKH7UfHKVoY8isR5a5qdbXXWTftHWlOYd-FNJh-cKsedUD3A-PIOWjscYZl14Ezx5ojNKUY3GIcOn8aAr0Xm3ejvvyZbItjAmfpzu1L5i4GUSsSx8TT8nsLnnBbp5FLz3prbgZmR0lXw0R'),('d5e196ae21a43ff5b819af1d2b5a000f',1331968299,NULL,'vx68hjg79JeUzU3e1JZWl_2qe1rJ_UDKq2w_9mj9HuhOcHy-WQLtuW2DRbTJAI13vRf7t_o2-FeRie7yEicjZWnH4du3jFA7UiqLvPEM72o9j2dbkyKv_hisNAwyfAoeKZ9ODkAM5rF25msgki7kzHS5_1FEaGdyA2cvslW72-w.'),('b6c6d080573ccec253c3cb9425c0bac0',1331968700,NULL,'6cCXbuUhKK4Vzwu6BBTsGSai2StnA_2NDbax3rayLEsLmUz22J32xQk7sFwmWAaO-fDNrbh0PoBkkNEaSUCSLaY2nXYrJAF7xdIGzBEHyGC5rnoq8HszAqEBSXVXcCVR1aqZ6gHKH7C3lba9O1f6RXOQJTc4YLXOKyMWOGjrbO4.');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_users` VALUES ('admin','1ba1a1a5c82d3d4275dcc6c11090d40f','Administrator','kiya.bagan@gmail.com','2012-01-18','1','',0,'','','','','','','',''),('aangeliascott','ed65879477403baad10748a88a17326b','','aangeliascott@gmail.com','2012-03-13','1','3797',2,'http://','','','','','','',''),('1simonpeterson1','56fa861e6605dd8f0116fe66ac20705b','','1simonpeterson1@gmail.com','2012-03-13','1','3999',2,'http://','','','','','','','');

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

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

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



