--
-- Host: prolinxdir.com    Database: prolinxd_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=MyISAM 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=36 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_category` VALUES (1,0,'Arts Gallery & Entertainment','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Automobiles','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Business & Investment','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Recruitment','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Designers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Communication','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Computers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Remodeling','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental Directories','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Education & Colleges','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Staffing','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Stationery','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Systems','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Health Resources','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Services & Products','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Interiors','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Restaurants','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Agents and Companies','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law & Legal Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Legal Consultants','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle, Society & People','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Medical Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Finance and Money','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News & Journals','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing & Fitting','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate & Agents','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Environment & Technology','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO & SMO Marketing','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Sales','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Recreation','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transportation Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel & Tour','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Weddings','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Arts Gallery & Entertainment','<a href=\"http://prolinxdir.com/arts-gallery-entertainment/\" name=\"cat_1\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(2,'Automobiles','<a href=\"http://prolinxdir.com/automobiles/\" name=\"cat_2\" style=\"\">Automobiles</a>',';0;'),(3,'Business & Investment','<a href=\"http://prolinxdir.com/business-investment/\" name=\"cat_3\" style=\"\">Business & Investment</a>',';0;'),(4,'Careers & Recruitment','<a href=\"http://prolinxdir.com/careers-recruitment/\" name=\"cat_4\" style=\"\">Careers & Recruitment</a>',';0;'),(5,'Clothing & Designers','<a href=\"http://prolinxdir.com/clothing-designers/\" name=\"cat_5\" style=\"\">Clothing & Designers</a>',';0;'),(6,'Communication','<a href=\"http://prolinxdir.com/communication/\" name=\"cat_6\" style=\"\">Communication</a>',';0;'),(7,'Computers','<a href=\"http://prolinxdir.com/computers/\" name=\"cat_7\" style=\"\">Computers</a>',';0;'),(8,'Construction and Remodeling','<a href=\"http://prolinxdir.com/construction-and-remodeling/\" name=\"cat_8\" style=\"\">Construction and Remodeling</a>',';0;'),(9,'Dental Directories','<a href=\"http://prolinxdir.com/dental-directories/\" name=\"cat_9\" style=\"\">Dental Directories</a>',';0;'),(10,'Education & Colleges','<a href=\"http://prolinxdir.com/education-colleges/\" name=\"cat_10\" style=\"\">Education & Colleges</a>',';0;'),(11,'Employment & Staffing','<a href=\"http://prolinxdir.com/employment-staffing/\" name=\"cat_11\" style=\"\">Employment & Staffing</a>',';0;'),(12,'Gifts & Stationery','<a href=\"http://prolinxdir.com/gifts-stationery/\" name=\"cat_12\" style=\"\">Gifts & Stationery</a>',';0;'),(13,'Hardware & Software Systems','<a href=\"http://prolinxdir.com/hardware-software-systems/\" name=\"cat_13\" style=\"\">Hardware & Software Systems</a>',';0;'),(14,'Health Resources','<a href=\"http://prolinxdir.com/health-resources/\" name=\"cat_14\" style=\"\">Health Resources</a>',';0;'),(15,'Healthcare Services & Products','<a href=\"http://prolinxdir.com/healthcare-services-products/\" name=\"cat_15\" style=\"\">Healthcare Services & Products</a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://prolinxdir.com/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://prolinxdir.com/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Interiors','<a href=\"http://prolinxdir.com/home-improvement-interiors/\" name=\"cat_18\" style=\"\">Home Improvement & Interiors</a>',';0;'),(19,'Hotels & Restaurants','<a href=\"http://prolinxdir.com/hotels-restaurants/\" name=\"cat_19\" style=\"\">Hotels & Restaurants</a>',';0;'),(20,'Insurance Agents and Companies','<a href=\"http://prolinxdir.com/insurance-agents-and-companies/\" name=\"cat_20\" style=\"\">Insurance Agents and Companies</a>',';0;'),(21,'Law & Legal Services','<a href=\"http://prolinxdir.com/law-legal-services/\" name=\"cat_21\" style=\"\">Law & Legal Services</a>',';0;'),(22,'Lawyers & Legal Consultants','<a href=\"http://prolinxdir.com/lawyers-legal-consultants/\" name=\"cat_22\" style=\"\">Lawyers & Legal Consultants</a>',';0;'),(23,'Lifestyle, Society & People','<a href=\"http://prolinxdir.com/lifestyle-society-people/\" name=\"cat_23\" style=\"\">Lifestyle, Society & People</a>',';0;'),(24,'Medicine & Medical Services','<a href=\"http://prolinxdir.com/medicine-medical-services/\" name=\"cat_24\" style=\"\">Medicine & Medical Services</a>',';0;'),(25,'Finance and Money','<a href=\"http://prolinxdir.com/finance-and-money/\" name=\"cat_25\" style=\"\">Finance and Money</a>',';0;'),(26,'News & Journals','<a href=\"http://prolinxdir.com/news-journals/\" name=\"cat_26\" style=\"\">News & Journals</a>',';0;'),(27,'Plumbing & Fitting','<a href=\"http://prolinxdir.com/plumbing-fitting/\" name=\"cat_27\" style=\"\">Plumbing & Fitting</a>',';0;'),(28,'Real Estate & Agents','<a href=\"http://prolinxdir.com/real-estate-agents/\" name=\"cat_28\" style=\"\">Real Estate & Agents</a>',';0;'),(29,'Environment & Technology','<a href=\"http://prolinxdir.com/environment-technology/\" name=\"cat_29\" style=\"\">Environment & Technology</a>',';0;'),(30,'SEO & SMO Marketing','<a href=\"http://prolinxdir.com/seo-smo-marketing/\" name=\"cat_30\" style=\"\">SEO & SMO Marketing</a>',';0;'),(31,'Shopping and Sales','<a href=\"http://prolinxdir.com/shopping-and-sales/\" name=\"cat_31\" style=\"\">Shopping and Sales</a>',';0;'),(32,'Sports & Recreation','<a href=\"http://prolinxdir.com/sports-recreation/\" name=\"cat_32\" style=\"\">Sports & Recreation</a>',';0;'),(33,'Transportation Services','<a href=\"http://prolinxdir.com/transportation-services/\" name=\"cat_33\" style=\"\">Transportation Services</a>',';0;'),(34,'Travel & Tour','<a href=\"http://prolinxdir.com/travel-tour/\" name=\"cat_34\" style=\"\">Travel & Tour</a>',';0;'),(35,'Weddings','<a href=\"http://prolinxdir.com/weddings/\" name=\"cat_35\" style=\"\">Weddings</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 DEFAULT CHARSET=latin1;

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


--
-- 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 AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `idx_link` VALUES (1,31,'Cigar Cases','http://www.habanosyhermanos.com','At Habanos & Hermanos, we offer discount cigars, the best cigar prices, cigar deals, and cheapest cigar accessories on the internet. We handle international cigars delivery, cigar humidors, cigar samplers, and more. We carry all premium cigars and boutique cigars, Arturo Fuente, Padron, Gurkha, Rocky Patel, Montecristo, Macanudo, Romeo and Juliet and more. Free shipping, low prices, the best online cigar prices available!','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-06 20:19:23',0,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cheap cigars, cheap humidors, cigar accessories, cigar ashtray, cigar cabinets, cigar cases, cigar cutters, cigar gifts, cigar lighters, custom humidors, gurkha cigars, humidor solutions, humidors for cigars, travel humidors, wholesale cigars',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,35,'Wedding Shopping India','http://www.parekhcards.com','Parekh Cards offers traditional and modern Indian Wedding Cards in a large selection of designs, colors, and styles. To shop check us out online!','Nilesh Parekh','weddingcards@vsnl.net',0,0,0.00,'2012-02-11 18:03:24',0,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'indian wedding favours, wedding program scroll, scroll wedding invitations, wedding shopping india, kankotri',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,22,'Workers Comp Lawyer Philadelphia','http://www.workerscompaccident.com','Adam M Kotlar Attorney at Law provides legal representation for work accidents cases in Cherry Hill, Mt Laurel, New Jersey (NJ) and surrounding areas. We take an aggressive and thorough approach to the law, and handle all sorts of work related legal claims. Call us at 856-751-7676 for free consultation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-13 15:40:46',0,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'workmans compensation cherry hill, car accident lawyer cherry hill, workers comp mt laurel, workers comp lawyer mt laurel, workers compensation new jersey, car accident lawyer new jersey, workmans comp lawyer nj, workers comp nj',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,18,'End Tables','http://www.shoparearugs.com','Shop Area Rugs offers best selection of cocktail ottoman, storage bench ottoman and end tables for every budget and lifestyle. For more details visit us online!','Zac Zolfaghari','zac@shoparearugs.com',0,0,0.00,'2012-03-03 12:52:43',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cocktail ottoman, storage bench ottoman, end tables, area rugs, 8x10 area rug, area rugs nj',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',0,'2012-02-18'),(2,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

--
-- Table structure for table `idx_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 ('bbe86be25019d308758c7dae5127a270',1330915728,NULL,'zikm0QdLh60Z6EaA-qVEVGLZmXi0jwbNFYER9gAFprg9TgRg5iKu17u4OdhMZKLIRVckMfrfxnjNXkPjBYiR2aId7i2nb1hWVxodppdoqNNib9WOQma8Jb9FKEOUgWwBIRVgd9xlZTnuNYQK4wuIEg..'),('581d0530f0c0ba112eff18e6f1e8e613',1330915763,NULL,'7k-fimNXZEzdxWnYuEPFT_Sl3eYPRrGPldOtHn6RxbJaak_QsDe6lvhDS2tcCI8HsRLO8s6nxnqfrJdP9sV84JHn7u3HazfjM7x0_flYfZNzWhYT-cjt2DEXbZERxC8TZ1KXgjq0vi5_aQPHc-OMbOqDKN48i8_JBep5nZKrh8mDGdoV4k6rz3ZaDy-YP-RzV6pP8tXbypjXZ0uKDFTVfQ..'),('ace40ed5a7a23ea450e2a9de0d22095a',1330916637,NULL,'mJCpn2c9uFI_nDlY_LYRFOsA3JLVcN6CYhyXtNE9UQqL2CKKTQNaImDK3L3RZ9jxP1pVPqb56Q5rZi-9alHTKLK5CrSLjDhmhh9CjQAeVuoMA6xg70IAuj8EUbWPkhFMeOM2uqas1NQUHz7ngk_uUA..'),('24c4a8df1c5c96ca0313efb8257dcac0',1330917788,NULL,'QbwGEbMC7FClCbAHpOy8X5NBHWOP9CH0kzeSWIpAsHFtFc0rn8uWuNKe3ATcDU_k9DeDXQRn4_5YuZCixjPPN-J_jadSF-6j4kLnu68BiDeFUHgi1EB9fIPb9dsezzRF0WYi2J6814vOVbRbMFNwq09hAvRfiWgvwJ3Fmdi6b7ACuaKDsoXefsPxlL_KoZAx'),('8a921c382f6d7a938e40c8863076a543',1330924007,NULL,'fzvVjVqnFuLGHtb3rGTkPTUoBZA7RNfCNuYjxza_rlMpKINqwRWlkcSvPKmOe1txn1hiL61ohkrk5bw9w6vVLWZoV80VXw74UB0YGp02gU4zuYQ2FgZ7wqmnG6WKg_-43k7DdI8exei-5JI5FFYBjA..'),('2b2498e1507af1ef6d089cf5ba4d60db',1330924511,NULL,'cyEbQxy78_y-b2kQ1HiBOLqB7aceXYWU7ORjdXJgkfOYovqQLiMO8Xf7dMCRxOJTXckoitsf0HCBUnhuL1c0hGnh2EB7dVxYAYpmWp6PCkM_VUAR7wFa4HOgMqnPNfQlaK_lLg8FZY0BA0itinKQBGp5YrdQx64rIWBcgIyf2b3TZk4mzBg1ctiDQQTAqrcn'),('ea27f07df96deb765010aeb66cc1692c',1330931146,NULL,'R2inpn3SESm36ODimnaNUAuDcZvbyy3Ptjq5iyFABTr6sr0LzcPXMYtb65Q0CkZJG8Gm9G_kia62pgu1o6pj8F4oOeF-azhAksWOlVk929ObgJY_8FGd06SKZopnquxGfmgP8jAN6qsvQoyzXIqWig..'),('c924dab704535e439297b105cbee6c8b',1330932986,NULL,'O_hHHS51J3vruCfscpELsykr8KAFoiKtDIfsl9mWssO7Q8E1pnY41j9aBQBLXZhYArRyL5iOv3RN853jy2H2kIE7IEVM3itoB69ozE8qbQOv_7ymjh5TUutywj7pdy65kXBrTkKMMsDfzB45HDsD0O1FHH07kNcI63Aimizp13qBXnxnqLwy14ZHmPMBC6Di'),('a69425825e2324c5f91e075fb4518187',1330936678,NULL,'w6-vdNOcx_LvhRN_Y-oRJyUl-I-A-Ci_qQ63skLAwbqg6FfgHrboVDBlK2yMgwvYMc06QfGGEGSfLYwyeYFck8DaI0c9_KXKYLdm1VsmpOVKy_p2R-6tcPB4SuXvMoxh_vLFXLHGNfyoNwqxs9M499tQXm58DPzBB1ysoaDOBX4.'),('3415b40dc09fc09e1f66a639eb26f098',1330937218,NULL,'5qz0xTYKac2sObjZPh3_PWbtAFUon0-SlLxGEmuFmSKawz03-QOxohtiuarusQBVQGSTBnyH8Qb6n2C1gfVJNgjGifsgjOooJIO2h-EZDc0xRdsuvlevmvjHLoVDubl1PyUfcTPa9dvrDWqOOW1zkg..'),('bef1174f5f0c0cbc750ad36db1f2e020',1330945455,NULL,'hsdfqUrvZFqIyt1Emt3Juhq65190_RmEfuDUa9YsDheJxvqX6lSrpCIaFUe-1RhBKWhn5VBJDiA8_CZQDBSrqB73vkCM42UCfLiCji2lpZHa2ZUCL078O3TM05CHKQ1gjPACBzPhIMsgqRiRXthzPQ..'),('25d0e9d2e55737a3cba32ff9b9f42ee5',1330950441,NULL,'7WeQlE5XoShPSlP2YDs3zvEwocyKwUHTdBe6o735k7MflQC1AyHbwmYkmbTby9zAUbkwnrl2hhCUzxYasjkCVG16r9bKbFeo-Tz9z7U6pZEeemGw9ul81qwC6UL57Zdo0rmn8jzIYGaqDZhbj9s8wvM_TIl7NThMpFQTyVauZD6iWs7YMO1Bs0y_xBFApSwJzgMiFlQzmB8NTCvMeKZ95Q..'),('b3d061be0e19c82791c5684fd4c77cf7',1330952769,NULL,'EohyO7tc7zJmQH5cawVC5wBoJuXcM-caURj-UIqWN4zpyg8aN4btfBDNbaZgGtmSIBO75kpeEny7SpksUZvNOF0J0il3pNzP1-AOz_FUh_HFtF0xUJGCMCrdHOXYWZjpsS6ZgqrxAoxD0VubxdPHDA..'),('27a1872ff2debcf84a061f19c0e34b2a',1330963907,NULL,'gpRZ8ZUUDkMSMD5iR4ZnFp3aXdBPE3OpRQxA_dJFuwEyp7c5KaK8d020LuoduK8-N3xQhqKmNR95ifKTo9ertPGaMY9zFLQaumMzKo70U6PAQ04WGHsKRXVkcgv2nYXWOu5vZpF3LZDVTKVmO0HLhtU_9SpS6BQFpi8Knk9f7yg.'),('6fc5277b9c1ae649c3de9e635e7e722f',1330965411,NULL,'p7Ibhj8aGuv_ioAaYtFONfAdhhbdzHk5QPqRqUSh-A8cQLJdfvGMvqpsVISS6yLvyk7nWCmmJFqP8isxhXKDXsnEF86KqttECCDBH_d9-kEABCOPSbMBObyIVhnKo9ZzMzqMj3wPfhdXUVpr9FJc3r4I7FusdMdkJFwZ51-jb2I.'),('cf440f4265f2a139e9dfb80bacd866df',1330967167,NULL,'pnCLT56NQ2RLe9e7OAWdINmAIlwWwlBvQR5DY2v0E_EL0dD6DF4G5xnRT_BcbinXQErADJIdF0vMW7ztMEdwknTTfDhibvcrjnpJ-ve1CLuGfBoHS-HLfziLSrZW5L5ABT7Abuk37ru9gopkzQetRg..'),('48abe396d3f0393a4ca1fc9a787ce063',1330979736,NULL,'sFzI70X5ZUZoPSRp3blPdDFRU4jWF-sx-Xb-ujtecb3N_D2-LIuTi7fwTq29i6GZJ_MUV3q9eeWTTY7MSyxhbycHX5o6dDeefzTuRfvCSviEiDNKLUwce57xYhxxU9F5W6Z_0SlGeOK6Qb0UvjvXPuw7J0eMPE5vQyqAgmM8_bA.'),('7bcde1bc6c3067c9fcb1cc5ce3e742da',1330981475,NULL,'U4ylgwvFNbd3I4nipt7V7NVLODu11RKIyam8IP1TUKwJaDliobDSOxVyqHCRY4wvJqGva5a-iAlGi_zrrrb3lVNVHj4Za4qMQtdyyV_cLq9jawVKJrlAlu-LqXrFLaM2Qqz9hEDiqefG7USIwWQnfQ..'),('86984cb5c630efe576da56b68f3419c9',1330987509,NULL,'GgC8SKbCiiLDcBDg_hPfuaahkCr9J8X17kKfaCeALwU1fAprT1_YJSNyLkPiwvsq1xAHLwYjwhucDh6Fe17CtSUSHciEP7FljzrZqWFXCx17Hvu0vG3PH8ujhIZ5Nm3imHkTBRyOw_rJvSgYzIxJ_g..'),('65790182641747455eb240d85dddf4b1',1330993942,NULL,'NM7YjRJMSRf3zVoUMv_RSQGJvCVHBVvesemORcQj3d1i4WaRmStrE2RdVt2FR34nw6j75LuuU0s5xpY7x6fcJu1Gme9ta0kBDwJQyJiBtgNuczp505WqIYcsNLaNhrpiJTs-Dg0iACbREmyAFfsyGD_C-wQxTZ3EojRPX2fRAMPkWEiM0QgLJjp8OmjuYNTf'),('ba67ccdb4ebaa305c642e084fd9a331c',1330996056,NULL,'NOpwJcS7ey3OYoVHnehVlWNmj8KsCPJoU0yDMXHgk4ZcCerqZssdjULwCtvU31Ly2kEeHuUBkYGukvRzoo2p5rl_xru6pOLkwHH5Ic-NLygS_ZBN9n5lLeCyvjHYBMSxlB-jb9Gwd9sNqzgtKb9y_A..'),('ce2d493059fd956b4f390b921027981a',1331002119,NULL,'hsdfqUrvZFqIyt1Emt3Juhq65190_RmEfuDUa9YsDheJxvqX6lSrpCIaFUe-1RhBKWhn5VBJDiA8_CZQDBSrqB73vkCM42UCfLiCji2lpZHa2ZUCL078O3TM05CHKQ1gjPACBzPhIMsgqRiRXthzPQ..'),('9d83ed8fdfbd5737fad8327a5f8a9aa0',1331006520,NULL,'y7JJGDKh0BCeRR5pLD96CcX8Zn2aaUljweVHkjBLHFRsBFZjHWLKkWIQdiRtHRtJATFadcaOsB_NLCULDBtybs0qxkGSckEhwEv4yFL3auuMymRJtfOpuIndYqyvBmy20Zq9-pH7YPlr_OgqN6yEER-I-da9kaFABBaElmWj_2rd9IcrxyBRGxUBqxABv8Hf-ZzIzbjnTGlh0jMTC0aIBA..'),('9206956bc75a2b84b2991ce5801c342e',1331010400,NULL,'WIe-EKvdiHo9ktIP7Th9D25dab1BFmBdqUwWkD6wsVQqaawyAuvBUnMjiNw1u4uIwW1Y9r4FyIb-dNL-gOr1mZTPN9yKBFtPej5WA4Pe8ISrflqNSuRHiz1EPj2Ow8EsZmHf1XWJUFSwiiCS7KsmOQ..'),('76a96ccdd5672caf2b309075c23b1e7d',1331017483,NULL,'I1FNqvNcYmbad4HqKrnz5guPjJVQ__EThB7rb-sylzXKu4pG97Q3SnnWkELuBWJhtddy5BYNidfmOrUfW9DSMQ46S9DpOGFizTP_sRxB3onaC0c116OmjrLRTR5Q3VS5pwPQG_JLAON-7JV57R740g..'),('8c5681b0ca98f03496ae164eb4313c5b',1331021178,NULL,'Ba_PrDbVyDGMBI4XrTJdDmU77cteiUBhoCuWC0QFuKHU9XvyqYV6ScP-cPtKAgok1yCfPHCQ2hzygA9ZLGT86GJxxmESXj2rFTFWsaVQmsxX--FvZOJQEkrtwOl1KF5g65nEcwjpLBv2R1lihe4u8BhPq6iOJFUpWdwXg8bBa0k.'),('f86f0ce314372348bd2850069c6401bb',1331031886,NULL,'ZZ5qSg_fT-xc4lHGy0VhMNCyEQB8rwf0ePKBxFSK50Ewir_LAG1wwobQ1HkIZg4Q3cESamz4tEQ4FhM9EMo_F9AZuROfSWhFkXyVdj8JblCCXhbJNCFVKD_hjoqgNQrywrIYj5UgD8qaNUGE3ZyKYA..'),('b630aaa3f516d0e4430a6121bf2bde4f',1331039212,NULL,'XcQrYNtsFVFpSLWE1PVOffaMntdFEY_W0bcgHsb9tjpgaJflkrwUClbZaad8KWiuQDKY3125oE1jC0j0Amgl3hPOFBYbeJKYZrT2w_ZwZI37BJKh38dL7Qltsm10Aeh0Yyt3yGNZY-pUhESsVwCAKw..'),('4ffcd63f4dc57dccda0b1a7895990ee6',1331043975,NULL,'NOpwJcS7ey3OYoVHnehVlWNmj8KsCPJoU0yDMXHgk4ZcCerqZssdjULwCtvU31Ly2kEeHuUBkYGukvRzoo2p5rl_xru6pOLkwHH5Ic-NLygS_ZBN9n5lLeCyvjHYBMSxlB-jb9Gwd9sNqzgtKb9y_A..'),('fd6407b7921f8ea89d03195f12166ec6',1331046133,NULL,'C2Ci-GlkQvUeyK3StjtuRTdz9jlrMjKlayNpWZanTBVNOhaa4doU08joOogA41vwSSm_ZXZ6v4-QBe_GirtMLxfmLmj1k3h9CCZXUNoFj72aAmGVDuyrUEmn0qlBdtueanqtXRamzMGxPa3ybPe3-w..'),('b7e2f98af179aa2da1499548c474a7a6',1331053620,NULL,'su4Pv-KnG2_cqvuu_vvk9PrbjnRUgB7ULIEu9wHkNjHWdx0PfaCevyVZ8i0p79nX0IUxhix17RvsKyQcuDRlAdlZ7hY83ozlBCjVEefTEdP9pwD1m9jg37-c0Thxni-RId2RVL_XcZBdoq95BtDJBQ..'),('056e3cc0102993483fc0b4cea6767b45',1331060736,NULL,'IFjdSjpYXPIlk-Zx11AemWAAGOgMsiFSQuzsPp26yQLppxcBfzAqK8FUDHV11Mca8E2RXvg21fufQiX3avLJhXBoRR06RTvK6Kze-z-z2jYuNPsaPnEVpgvL-scIe6dwPbLznOkMac4xBw2-8x-Zcg..'),('dc7e4c6bccefb30aac3c850a71b3b8a6',1331062808,NULL,'fGBWqxv1kpYxDPfSaopJm80VczcjNudLd7k7OKt6h9E51q5eoqRh0soKgd7dGUmzi8VoKH_tKpNthu8ZT1cuAhNd9du772MOnSadSTCxGxttSpJnv490cf7fdK_BH9-4JR7LUAR7wR4tXhn3YwGZ83xGn2LL7X6amdHtI4FH2OTR7GEeaYHkqBhJJZ4Y-j8i'),('dd4b39edf8132b512bf28bf08ef2e188',1331062845,NULL,'EayNf1Fxc-cMnJSiqatDBf_tH7tYtQFjQAGVaNihjgkBfMd4gXqtOVCKb2qyYTQXzG7bH-mEDm-QoLe3qWkz7xEP6LGn5sLo3VrpJxmLyTzLqwMcKaQdPIU6KI3jiHImwYx1EvyZfm67u0DPLRhLmK2HmYOt4Xv7F8aFQdgE7egcLRm1kwSwPDmZ51z8sFeo'),('d52ffa092c15a2e9cb5dd128679ccddf',1331065622,NULL,'OkzDIBY-oon_a2axPYpnB479VqDazmfUmQdNeEmKQ29LipXtgAFjhzVcgyDrjrXJB3XHHSQDno1uSWFBIyP8s8LJ7l1yDdJe-KuemtetFeGnrBwNJ6LjhntE5yBWuaTbEtCwNdZvnk5XxbczKPOJB2tB0sxJRWJh-Y-1sYwsHuzqF3ZtyDhz8-iLK89uuX3UiqbjnrpmcF4Mv5RYffwYMQ..'),('4b091acd2ecefe735ef172678fdf1f79',1331067869,NULL,'UEfamACh-i99zlN5yQo-FZxslM1PPAfNcqRWiu24ILJSu0Bo0d7WDOwJTs3U3aADOkmn_pRKJOn0RgezCFkwlw-AWlUwmJDdE_Qdojyr3Jei514Bhtlwx03KuPtKWciVZHg14HNh74rtmzukcAhGCw..'),('b419005a9e2aff700500f15917696aa1',1331075070,NULL,'N_apn7sLkBkYeIdI1s3yLsoVb205-hyMLWXZfbLYyQSvgNaApYzBMlJ96pHQiLPp3rem5oSet8LQ016np_TdTjPi21LFJWGldfSEhkrDLuNK7BXn2KaaA1DtuJmZ5xMtlJcOGardg8bZaj9rtjGmFQ..'),('d985539ec336241e6a695972777cfd83',1331082371,NULL,'W0rnUP5h_vhQNEXEbNuXvI-FWbhh9HDn5uvSLhHCzSj8O8jApTr_AJGKOu49n6uDAJtNXuBchFJzl_SF2uUi9D6qWnvfKU0gMO7mSj9yR4rIYvLrI4kWrrKylOEozm39m4i9ffAihn9T2LGGuHGZvg..'),('c4c1d9eb9fa04d13c65549919ce08ee4',1331089424,NULL,'IFjdSjpYXPIlk-Zx11AemWAAGOgMsiFSQuzsPp26yQLppxcBfzAqK8FUDHV11Mca8E2RXvg21fufQiX3avLJhXBoRR06RTvK6Kze-z-z2jYuNPsaPnEVpgvL-scIe6dwPbLznOkMac4xBw2-8x-Zcg..'),('80b2cfbc7a20cb0313a14a5b3921d9cb',1331095505,NULL,'FWRBDoUZwh43QO22KtsqPoluOtpN8xQVT96F68mGFghPDozLewQJIM_qyTcbGi-QBN5xspnMxTK2Gq0BeUZti188QWXvLQh069LrgghEvAOrUuEsmZXJ4UJFhuLV_vcnGv9DZpKXxcC0lmUrOd1zRw..'),('cd94dbf5bb2432dcf98a1294e57601c4',1331111062,NULL,'oL6CD1UzhapLrhwIu1nkr25iz4j2bAXKe1jmUOGu1TGg0Rlm-jttocslW9e08elXzNY5G5M4HIUDmWH_Wic_SEq9TbhMBhaewsSAo0iJgnE8Dn55CGrA0nr41dlpPj0EbzkkhYLYR26iPnTRyzkvzA..'),('61f348ec20171a6abf7c5f18672fafe9',1331125619,NULL,'rLp5m_96pHquaBSHJrPH0Enmsy3TnuBhhn_ab4jmb8nCnnwGaSi_m0FmGzqg1aW5576IPmZqCbQmK5DhnCnspG5_M37IfqpVWrH7GY5eIyDvSz_98KQyoqyLVKD8QNvh29YFMWoQwxNVJO4RJxiOsQ..'),('b40a4663a90f90ce03b4f260ec902cce',1331132549,NULL,'RlNxIOGUvLgUIvjXAQWDpu25vtfe_H7ZLEKXoS7PLwPeuLQ0c3Hok2so94t9_ef4Hqwk7RLllodyTOLxBGtjyq4HsI6qFdwz6Y1hj-rLKTbXA86-39pyHcSNxVdAA_Ha8QVTdhykLC9XfaC682BjWA..'),('29388634b1d33887172afae8d0be817e',1331134468,NULL,'cuM89nEq_x45-r7jXQ-yx_P2uvG8fSTSMX8jG9KrnFec6pkwS8S4_-eiydvpOUFsp-drlbk_e0InmQlWbfrFjdIpE0XP2g9q7N2zGs1PU8AHVnCvwJ6iEiJeUwu1iThdPhmsQmeaoQDZ8mnF90zTWJB2-lwYJvFvgGCYvEh8GIbIhXrI-lkXF3Ngf_TNoQL-'),('8f8c9d3fb2a2d0efe8582fb9e6a66801',1331134533,NULL,'PAP2LXcgNqNtvJyaqRypQD2U6UZESEMkTzJ_e7snodgZ6MYyx89VL4V-kOyZwmLpKPrmPU5u1OjDcY4CLGQXnAwk_5kJnKjYX64ASVy4xeNYSw98BxT9O7cYGswXtJ7m_KLltlj8S25hjfmV9Ic3V2c9kpqHBbrkRi6TbIW16YBKFeXwz4Lo1d5WyErKZbEB'),('35ba00673e577a921909fc3112138aa7',1331139982,NULL,'C5cK50DXkkURLOP9jEtrOJq8lnDzh6JX6ME3oby_4oJWDzt2DLAcHiDOSTzFXfpZrZDwhdFqbNNNne6BEJiDm27uFnIi8LwiWuqQc3kiNiU8S8T1pd5WdkB61a4uUVLhLOsJaZtDaOr4feGvwWRxPQ..'),('b0c3d1d2a241a3b58af6232024949b35',1331145933,NULL,'N55pRwwstL2oAreWnamujP6oZQnerCg2W6m2sTO3WaODad2Kz-u2fbJOKS8WxpXx7_EE235cgGfGnBnfWjP30k04_fRMN1iJx1OsET7kLG5l3-ddBIlz9GP0wPvMSOLD-yyqUJyUqyVQj7VrxBD4pA..'),('678b74ce64464685e7e3ee4f18de31be',1331154277,NULL,'xiToYVy1pYjWquWDGKh1Rfb4mKRbCXh-fKwrcFt2-NZmsPx9oL-vY1ynGuVCS9DKJPb07h-Sn0DT-YA8C8Wbh35y20mpIzrZPXwWaMjMeiSBZOsTRXm7oZePUMqPotcAvNWajIRbr0PsNEfOfuEXig..'),('5931e2a17c46573a1c4cf8fc7bb5d0ac',1331161505,NULL,'xiToYVy1pYjWquWDGKh1Rfb4mKRbCXh-fKwrcFt2-NZmsPx9oL-vY1ynGuVCS9DKJPb07h-Sn0DT-YA8C8Wbh35y20mpIzrZPXwWaMjMeiSBZOsTRXm7oZePUMqPotcAvNWajIRbr0PsNEfOfuEXig..'),('3ed8bbec3dc6aac95601d6eb73c93921',1331168736,NULL,'svX0ufQYeT6tswL0zJUMeHeHBc3CPeTfw1YWUN4SJXZSSpADhG2t0VDu0jiS3HG79-MfOzWRi7aFyQiWlvvTSn5HkeS8bHUThbRyumvDC1T2-NChbqRpOzRArwr-fMzNm2YL8-cbuipAKCV-A5-kWw..'),('97a3fb9edb822e534f5b2af12951cfb3',1331169975,NULL,'cSZOTQLvv7wKp6DK92nadSjqkqmacTleQ1WiMsnGIOOy3-hW-cE4DJeXFmMzGKGHqNZiV4EO5odV5Em17lCj5otUrPf6OebY7nyFaZ8mHzHHUvG6epno4rh_nRvM9bKneEq9uk7dLpz4tWXLMlXO0kLcPfKBI_R6oqxr3UO8Uyn5fgPj7o8Uq_rPlydpqt3T'),('39a6fd442577f631085cb43815d75418',1331170853,NULL,'4PGZmUh-Nu9s6n0O__dRZ4FFhcArW6g7s89n3qv9bF8UQoqBVuglQ9toYUK9H3v2CyCWSiFDeK8KaWGMMHzPSz_sQAUcr5YjAMWu9_-Y4kwqyn24njemAcPhTaRMZdusZ2seHwyzZhTz_pzkYdSuKDfVbOVj6QXDXhjxDJSLLLxQT3z0uHE2ZpJfDX5Gbuhdf_t5TmkkJPVFgtNQp4wAcQ..'),('598534ed30fb3ebcb17272e906ec000c',1331170941,NULL,'fLDp8-Xie6Cds1q4j9kSkyp93J6LOTvmzYXLeHWSY6vRocxTxoTJXlz_0Vj6m9oDvtjbsOr1aBWPS20vpqRwV-X9FKmkdkUP6ZInZ1XN9EdQx4eeaPx-53x6rZWEbTKKewoa4DtqC0yAuGo06kuGEoone82G89mxNJzh9lbYo38hM3vG42JmgfkcV1VZzVtb'),('08b3040aa061c58ecc67ff4ca82c6bbf',1331175703,NULL,'5yxY35bCcPrxs92z8OQV4kMMhtNNB8CGSEYHHhpDWLNHyVAQEDcSHDdJsthgTppLNaZpeqpJU52dblhZmJ-iwh8mA-ayIpwfwPWDJhIGl227j_w2wczkQqDJgWclr8d-aghf992d7T1YDDs1-0uFEg..'),('387b09a15419535ebbf92e6ad9f82b7f',1331183149,NULL,'eBg7rsjGC84HUHFVHAyTcmoOpqWsfCUJhs1Y1Ir3aqzGPVsUHwMnmzPF9oYfn6szzs3eNSi_3YrhQFSJsEks8KkZJxOMF4Biqs0zT2_silJTmtbDqPazLOhPdaeGr0ZcQjaLt2eBzrKi4t6DrJUIkA..');

--
-- 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','prolinxdir.com'),(5,'site_url','http://prolinxdir.com'),(6,'email_address','jaiden.quilty@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/prolinxd/public_html/themes/'),(9,'admin_template_path','/home/prolinxd/public_html/admin_tpl/'),(10,'plugin_path','/home/prolinxd/public_html/plugin/'),(12,'active_theme','_prolinxdir'),(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','8cb4bac0319dfd062af9a8000aa5f6b1','Administrator','jaiden.quilty@gmail.com','2011-12-05','1','',0,'','','','','','','','');

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



