--
-- Host: home-development.com    Database: homedeve_indexu
-- ------------------------------------------------------


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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Appliances','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Bathrooms','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Carpets','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Climate Control ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Conservatory','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Constructions & Maintenace','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Decorating','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'Domestic Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'Electrical','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Energy Efficiency','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Exterior ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Floors ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'Furniture ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Gardening','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Home Automation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Home Business','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Home Buyers','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Interior','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Kitchens','','folder.gif','','1',0,'','','0','0','','',0,'',1,0,0,0,0),(21,0,'Lighting ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Painting ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Plumbing','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Restoration ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Safety and Security','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Shopping','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Storage','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Trade Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Walls','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(30,0,'Welding and Soldering','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(31,0,'Windows and Doors','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Appliances','<a href=\"http://home-development.com/appliances/\" name=\"cat_1\" style=\"\">Appliances</a>',';0;'),(2,'Bathrooms','<a href=\"http://home-development.com/bathrooms/\" name=\"cat_2\" style=\"\">Bathrooms</a>',';0;'),(3,'Carpets','<a href=\"http://home-development.com/carpets/\" name=\"cat_3\" style=\"\">Carpets</a>',';0;'),(4,'Climate Control ','<a href=\"http://home-development.com/climate-control/\" name=\"cat_4\" style=\"\">Climate Control </a>',';0;'),(5,'Conservatory','<a href=\"http://home-development.com/conservatory/\" name=\"cat_5\" style=\"\">Conservatory</a>',';0;'),(6,'Constructions & Maintenace','<a href=\"http://home-development.com/constructions-maintenace/\" name=\"cat_6\" style=\"\">Constructions & Maintenace</a>',';0;'),(7,'Decorating','<a href=\"http://home-development.com/decorating/\" name=\"cat_7\" style=\"\">Decorating</a>',';0;'),(8,'Domestic Services','<a href=\"http://home-development.com/domestic-services/\" name=\"cat_8\" style=\"\">Domestic Services</a>',';0;'),(9,'Electrical','<a href=\"http://home-development.com/electrical/\" name=\"cat_9\" style=\"\">Electrical</a>',';0;'),(10,'Energy Efficiency','<a href=\"http://home-development.com/energy-efficiency/\" name=\"cat_10\" style=\"\">Energy Efficiency</a>',';0;'),(11,'Exterior ','<a href=\"http://home-development.com/exterior/\" name=\"cat_11\" style=\"\">Exterior </a>',';0;'),(12,'Floors ','<a href=\"http://home-development.com/floors/\" name=\"cat_12\" style=\"\">Floors </a>',';0;'),(13,'Furniture ','<a href=\"http://home-development.com/furniture/\" name=\"cat_13\" style=\"\">Furniture </a>',';0;'),(14,'Gardening','<a href=\"http://home-development.com/gardening/\" name=\"cat_14\" style=\"\">Gardening</a>',';0;'),(15,'Home Automation','<a href=\"http://home-development.com/home-automation/\" name=\"cat_15\" style=\"\">Home Automation</a>',';0;'),(16,'Home Business','<a href=\"http://home-development.com/home-business/\" name=\"cat_16\" style=\"\">Home Business</a>',';0;'),(17,'Home Buyers','<a href=\"http://home-development.com/home-buyers/\" name=\"cat_17\" style=\"\">Home Buyers</a>',';0;'),(18,'Home Improvement','<a href=\"http://home-development.com/home-improvement/\" name=\"cat_18\" style=\"\">Home Improvement</a>',';0;'),(19,'Interior','<a href=\"http://home-development.com/interior/\" name=\"cat_19\" style=\"\">Interior</a>',';0;'),(20,'Kitchens','<a href=\"http://home-development.com/kitchens/\" name=\"cat_20\" style=\"\">Kitchens</a>',';0;'),(21,'Lighting ','<a href=\"http://home-development.com/lighting/\" name=\"cat_21\" style=\"\">Lighting </a>',';0;'),(22,'Painting ','<a href=\"http://home-development.com/painting/\" name=\"cat_22\" style=\"\">Painting </a>',';0;'),(23,'Plumbing','<a href=\"http://home-development.com/plumbing/\" name=\"cat_23\" style=\"\">Plumbing</a>',';0;'),(24,'Restoration ','<a href=\"http://home-development.com/restoration/\" name=\"cat_24\" style=\"\">Restoration </a>',';0;'),(25,'Safety and Security','<a href=\"http://home-development.com/safety-and-security/\" name=\"cat_25\" style=\"\">Safety and Security</a>',';0;'),(26,'Shopping','<a href=\"http://home-development.com/shopping/\" name=\"cat_26\" style=\"\">Shopping</a>',';0;'),(27,'Storage','<a href=\"http://home-development.com/storage/\" name=\"cat_27\" style=\"\">Storage</a>',';0;'),(28,'Trade Services','<a href=\"http://home-development.com/trade-services/\" name=\"cat_28\" style=\"\">Trade Services</a>',';0;'),(29,'Walls','<a href=\"http://home-development.com/walls/\" name=\"cat_29\" style=\"\">Walls</a>',';0;'),(30,'Welding and Soldering','<a href=\"http://home-development.com/welding-and-soldering/\" name=\"cat_30\" style=\"\">Welding and Soldering</a>',';0;'),(31,'Windows and Doors','<a href=\"http://home-development.com/windows-and-doors/\" name=\"cat_31\" style=\"\">Windows and Doors</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_favorites` VALUES (1,'qcalebnorrish','2012-02-12','My Favorites',NULL),(2,'vmelanirodgersr','2012-02-14','My Favorites',NULL),(3,'nmolliechurchv','2012-02-14','My Favorites',NULL),(4,'gderekwangw','2012-02-15','My Favorites',NULL),(8,'pnelsonlaneu','2012-02-16','My Favorites',NULL),(9,'sjackyjok','2012-02-19','My Favorites',NULL),(11,'aangeliascott','2012-03-13','',NULL),(12,'1simonpeterson1','2012-03-13','',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_sessions` VALUES ('7d5b46c01aa96e37cf9a0e3edc169ec5',1331889897,NULL,'bf4pSbTCWJP-l2XWm8z9hgsHKqQ3HJRiJdNL1kqYyqoGEFgIIw5rvcMlhjZfYI1SHi2tZ4j9rQtm3ZgUPqxHEcIS-EuSR-_6_tKBiiCUBoHwR4JaT9DoD_e69kAiUv5oQ6GX5ya46zDIUIbG4aNGZWHaMMiai1guDTN3mkyY2xt5VHp__-nK4_1ziYix10sM'),('2e8d30910499ace9254b5cab19b26756',1331890486,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('c27a772f75bf737c614b39aa04a7841a',1331890492,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('4b2c814c485ae992bfe7e228dddaae8f',1331890494,NULL,'P12cexOEZW_mqrxNmPpCBaj4J1PtuZsKg4geRv9Cx0VXoImUtz3PQi0VapXfamLsjnJr52_9HfoLVsri35NsvBdObI7uJRFh2sU4MWB_I9J8j55Y_xy1QjeN3ZF628vzghz3_PT48xxd3dRJ8HfCprwdJh_70H4FK4BRNLT-WkvwM44N-N8uxfUN9wZIA52U'),('13ab4c4111cddb67fede2238ac0b3562',1331890505,NULL,'P12cexOEZW_mqrxNmPpCBaj4J1PtuZsKg4geRv9Cx0VXoImUtz3PQi0VapXfamLsjnJr52_9HfoLVsri35NsvBdObI7uJRFh2sU4MWB_I9J8j55Y_xy1QjeN3ZF628vzghz3_PT48xxd3dRJ8HfCprwdJh_70H4FK4BRNLT-WkvwM44N-N8uxfUN9wZIA52U'),('ad1e4320a1d378f4d27fdc066fa161d1',1331890558,NULL,'m5-FAZyY3sikGzSQmbuHYrWA4U0kr0eY1YPf4CHzaju7SbJM7pM_7L14J2yX1SI14iZTtnspMk30wwHvTHZ8Kkt5WfRa-HFWqN58hiYETjDafoljMUUHC_ZCm0QfFC9uhPuBMzCJb-jnxBfwZtPlKRQnugIM5BA_cX3ad2zxGras-IHnQFt6RFLQS2nP2uig'),('caf3dc624b1070a4db398135046ba6f2',1331890563,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('f06e479ddabe24dd2e5f0dcee1c03504',1331890572,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('9a75c2de90f5e1f9882bfbfb4ea2dc12',1331890576,NULL,'a1nN7J-IBAPk-ElYDr7xbxXmAHaNFVqXjanUCvuPCRDwUAhM_un7gPmyn5jw1-cBtqtp34AYQAvPXoj5xVE1k3kQhmuSyU2OirEghfzQNcwRTpdVB6CTDokN23u_pMbvNSwiVi-tezD7FsKz4VNZdEMRggaBfhgYhqwZ64jWzdsDzLDSJrxjapSsaqhP494g'),('90f16854bfb92b1d7ee0ad942c97c6ec',1331890583,NULL,'a1nN7J-IBAPk-ElYDr7xbxXmAHaNFVqXjanUCvuPCRDwUAhM_un7gPmyn5jw1-cBtqtp34AYQAvPXoj5xVE1k3kQhmuSyU2OirEghfzQNcwRTpdVB6CTDokN23u_pMbvNSwiVi-tezD7FsKz4VNZdEMRggaBfhgYhqwZ64jWzdsDzLDSJrxjapSsaqhP494g'),('eb790f38f47b6ac7dc25fb8003177f41',1331890677,NULL,'m5-FAZyY3sikGzSQmbuHYrWA4U0kr0eY1YPf4CHzaju7SbJM7pM_7L14J2yX1SI14iZTtnspMk30wwHvTHZ8Kkt5WfRa-HFWqN58hiYETjDafoljMUUHC_ZCm0QfFC9uhPuBMzCJb-jnxBfwZtPlKRQnugIM5BA_cX3ad2zxGras-IHnQFt6RFLQS2nP2uig'),('17cf34cdf1fd2ec7a78e72082f2528ae',1331890751,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('f2f3411136357e0c85bf705e8a98b67d',1331890759,NULL,'a1nN7J-IBAPk-ElYDr7xbxXmAHaNFVqXjanUCvuPCRDwUAhM_un7gPmyn5jw1-cBtqtp34AYQAvPXoj5xVE1k3kQhmuSyU2OirEghfzQNcwRTpdVB6CTDokN23u_pMbvNSwiVi-tezD7FsKz4VNZdEMRggaBfhgYhqwZ64jWzdsDzLDSJrxjapSsaqhP494g'),('1c5190a112888f881c0baf58981f8fcf',1331890762,NULL,'9xh2f2bd4-bdcYIebHW3BpdJW9D1PN3XMSUacyTTV47iWnHG8OspYvDxFXkwMi2P6c9Yg5L4kKTcRGgCVeXL8Sifl8nPYQ7d9c2mcZRVs5njteZhfFlLn17QdLg5CD_vmevfLPFwsJTL5-mgSt5273mqBCAB6UZ3C2d2TorkNvkh9X3j9tPhR_n6ry8ylDjA'),('67ccadb2fb672f7640b73ce9530e7967',1331890764,NULL,'P12cexOEZW_mqrxNmPpCBaj4J1PtuZsKg4geRv9Cx0VXoImUtz3PQi0VapXfamLsjnJr52_9HfoLVsri35NsvBdObI7uJRFh2sU4MWB_I9J8j55Y_xy1QjeN3ZF628vzghz3_PT48xxd3dRJ8HfCprwdJh_70H4FK4BRNLT-WkvwM44N-N8uxfUN9wZIA52U'),('4dde234e5c97c307a3572ede908076ae',1331890765,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('392381bef544eb642d7431f5c5168c0f',1331890769,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('89261b5455090a7b69bb3d625044637b',1331890772,NULL,'a1nN7J-IBAPk-ElYDr7xbxXmAHaNFVqXjanUCvuPCRDwUAhM_un7gPmyn5jw1-cBtqtp34AYQAvPXoj5xVE1k3kQhmuSyU2OirEghfzQNcwRTpdVB6CTDokN23u_pMbvNSwiVi-tezD7FsKz4VNZdEMRggaBfhgYhqwZ64jWzdsDzLDSJrxjapSsaqhP494g'),('2bb698b2bd8eff76d0becf7526befa15',1331890775,NULL,'m5-FAZyY3sikGzSQmbuHYrWA4U0kr0eY1YPf4CHzaju7SbJM7pM_7L14J2yX1SI14iZTtnspMk30wwHvTHZ8Kkt5WfRa-HFWqN58hiYETjDafoljMUUHC_ZCm0QfFC9uhPuBMzCJb-jnxBfwZtPlKRQnugIM5BA_cX3ad2zxGras-IHnQFt6RFLQS2nP2uig'),('edb620bb21f5196e06249a870914d0d2',1331890779,NULL,'8_tc09f8l5TDci0DIS4Lh2wvIewk9AoA60njinzgRnHkyK136E0rXQQKw8-0ZTPMrAGG_DfasyEqKNtVjp5eFbiLCI1F4DpnI9X9G8F7wTKtV3hwc4u6FpBEc--VYu96UGQ5G9dUcUSloIwbvf6t0ftnDdC6F9T8Lp3n8Z6RYQoNMfzf24sE6xYw3iU_ZhLD'),('da040222db7d38667ee6dd72888240ed',1331890780,NULL,'agKX95lUIMy9k_lfm1ZovGC-rduwtvvp7fmF-r-GFuV0fcmjnTRq8v8NPtJikbkXlx219p5l-rnh8xhyh8Bx0fv7QcXSkl1Qr0asoazC6e_q6E7F8n6LTLQ1KCHjIPB_RpbSfhh38T_mOKD52_wJ26n06RmBhOfh6Ry1VBTujKY.'),('014c004e27154d45f4358e667b1de46d',1331891512,NULL,'PsSrggFs9LsF2Pew8L8AvX1hG6lGVEacFhMGLhlm_lruEZyCi4KHdIsd44JsVYw0I06CJE_zr7q4iGUGIqvGN1Vp4ZHdZFYGDClN25h5a9Yy7B6FWsHpPrFlkHKrwhi8PVy_cL6rTiKZyjvdXLs428PAatqEBAC0GDiOvXQ57EQ.'),('515e91aa0d6520868634fa5af987d9a1',1331894639,NULL,'WjK0NpI0mu6ZwEtDoN6hkszkRf6c8UyeJ9j79RTw832CZVGZPBs7_8D98qZKKhsjXz7XwRF_FZmU2HKLfeeGWnciTmZWNUEg6fMbthOWSrXekUywzoTKc4iNGK0oj7XQZ30d7QsOGT_AGmdK2StJgq1Zgpf6ReILoPMVgXX9t8Q.'),('13393370c664f8fb92fe5f17170208b9',1331894840,NULL,'bp1yEL0Qw52juC4n9PibJ9nPg-PQBmUs1VMgFonQywNO3iei4Arp2ZfwDOM0qgOspKqIXuSVEmWa6j8jpa2HE_qgDY-aAfqQsrtkzdScewyx9yfXCjpYwWEB4iMoKdNepZPU1Ze4Y9RfAxN-1RpCpg..'),('4a2a2b5c8b90dc3c94e36a2487384b92',1331895442,NULL,'T39za4mkBUWz-Cvf6BEsnDa4-xfyvLaOcH7mTdLdlYi8LGVGQNUKySfmUcPfftZzncqJubdhhtvD1Dt6glAM6PGUoaJV-imxUY5Ii9mcB7077P6-n9wuUqG_Y8b1n8nwiz-1RKYoB6nSrWfe3hVLG0sYZ_fw879ReIRZkyufheD6GEsl4cAxnpqMmS8QsQEorrknRy7tYv7a8f5A_dphJA..'),('2e909bb45de0318fcb4a1f37515dfe14',1331898136,NULL,'XAuyDoFm_PAPTcEtM8QUQAl3iiJ5YpHmNlAdho0N1NCAo9Zdesw8MLndbUyRtAzGosoFKyUk-kVeMI1RtNAKSvWSwph51OlR9WpXrS_fTid9ee739AX_OLrYA_FdrqRd3hYLZUd_N02Tuf5YGz4Mv_Y8DqWzo-cdbIfir6iNwT8.'),('67c61430e03dac32630d49a5dfba77fb',1331899394,NULL,'74tRqV83Yh6ROxJadsVT907ootknIUbDuEct3bZPojkIDDnuzeN0AqGSdDIS1nelutBwcqeTkMu-KNpBFWkwYKxjqKnOR1XndGy-WX2FfT62BN3nvUi05aefEb2xx07pFm-HnsZgAia0Bo3ixYT2FFgqjVKT50DEBaXpjZ2r2fY.'),('ebb93b052fcaaca9b0682a8b23d4de12',1331902369,NULL,'b6CcCKeJRRDmqU1OWxUV_3KyG7VynaW04Dt6216ZyFsvsBo195_yfZT8q10lSTUQYB7j6wohP9NXyODPduswp4lZL-YVsT5KbON_cfKbsSvTvJXCGrxfQTXCfx4oll95NvlLj5G_gekkd0suaLopxA..'),('1f648ff1616ebc62d255d598dc2ea4af',1331904241,NULL,'ITXDg5-GAJPH0hKc9AYfxClI-lB3pMhfJSmRs9yxBZG5l_mvCuIX-OSnzbVlzyfJ6YcL85nJIvqHspPRqdZk6ENJHWuF2nFySMEegcLM3EQAB8_1XFaJI8z7KptV-vByc7weO-5x-iPckLEHGNBBMER9ByXuVRmbU89AjE18ssI.'),('bd85c80f15ccd3a41bcd860d43406637',1331907984,NULL,'vZmYB-mlw43wS-a-i_t2JydPh7EaqbdcTvTOKLhxuKoIIKP-rX_6FDuY1kaMLhVApmvmMRfB8g5EFaccKElLFydmw8ivAt7f7IoMwG8d_WzVej2MrUWADmEmF5ugDcf2nWrFsJ4-ZkOvF7NeEIlsWE4h-ufmirN6jtCHTwIG-UEgMDqqV_KMAownW1oQDPEW'),('df6fabfa34161a9af9ed21c8392aa835',1331909010,NULL,'Xu3r7vx6e_5Gqovz9nOvAbTMzaC4eiGHhpVBR3GdJxGKjNSDnqyecBq7japFlzOZ0HD3D4ByCBXeCnvFPWg1xfJayjzkrz7aWHKDx51jIXRcuF9FMinrRA-lRdwV6KKhFMnCzBBqrMOBercIz93vul0s4Pz1NNFRZ7TdoMwlZ6Y73xQ_FrAwo-09MFC8l42R'),('84c0647454679fa156e48b177bea9ad3',1331909114,NULL,'suUzw1TWt4c5j4L3hCG5R_qPesDeUL1htel-3Pbg-thgfMMvV0oFblpehIE_P9dfECno-bFRne8_EVmn1S_6sPwJGlNDtDSovjuwrhSc8jdhe6ZULPzMzwvyfhmiLZwZMvdH6NsFGC0a79zTFyJHiQ..'),('7cc533fd62593aa8a724ef9cb290fc39',1331909124,NULL,'CR_j9Ajjf_W_Z6XTRVO8VciC4E1PwSWCeReHJbxQa5i_brsxWAPW-tXUVPCv-sFChTFxID5moFX6XYp4G67JK3HcdBLSPbxWQP4RTKF0haNqvK6jg-geTY7OknyB-gRgGUNMVbAmba6j3Y4FbNJhoJR40WGZcGzv1PhT1yZUScY.'),('44cc79245a4076382a4585504d79e5c3',1331914017,NULL,'mniThkQObF-Qh99H_IYwl3IoyJORcyCiFbEUHdZtrHM_nDMjlGU0Z6wJ4lXfy4KW3tUc08hs3G6-Akm_ZRF5piCVawuRS-kTj6-Gda5j1emAaC7cuf1P9JsUOBSNcoyL8vgihqNZp6Covpjv9dT7Hr9FxT4mGtWAoWhaA-S6AJ0.'),('67cb11877899c2a4255376556211311b',1331916072,NULL,'B9nTS0UmCBgNpSYqQskGDMJZqavZyBbcv4O73BEY4LpQX6fImqLyNwe6ASQXkXelgnHSCoy7mK_Kohjl8qKh9CdtvXY3JKXkyRSwmjo71KIu5ROEh8V261FpQAvog0JnPksXL00j5V4imz_kx4AnYg..'),('4111a9f21a8e1609f7cba3cbfb9902f7',1331920125,NULL,'ar9V2-oG4I-6IMt9FOTEFMXgt-UbSCLTVv07aOlJUTOD1yJEMXIX0nPTqbOEaKhrWmZq8yLXetqu3imIjZdqSl9I_ZXcOPthpjc2Z30XzB7zjg23KqIHlZXJLCcn4TEpoJocm_9lZiOBV_xI8RUCdX6SbqfETpOfqa-ahbb6h6I.'),('d3861589803717fa6d8c754803ab543e',1331923697,NULL,'ARLCJqOLpxb1fLStnmwgP356vh2ZgYgIdIBfL28WPrkwfQCZhIpyxXSZGXk848TuS1ZuaQZJ5aZl-G196Cq9RljvFbZdbR3ApeOE4Ha5DO2MlfOKKewuJLVRud6pIozW8lbmRhCWw4QLgZGSEb8czA..'),('9dde863a7dcd52de8ee06e61e2eb5215',1331924333,NULL,'rlSW0YxA_p3dRdsv-VMngLW21qqT_OzhP6nk2kjXD3HvSi05CLbXgCyCPpGJGnEbePlLhmSQgtqG4eteoTtfno5CkZZxOxyy50JhLiInlYEuYS5PE3pHx1AehTlivqRmQ2tZLBgICDJGyFjj4j128SJxSZiPbA2Lsno4n9yU-sk.'),('c5e9c1826288bc9a2e264015860432c9',1331926088,NULL,'bUr3gPPPirSYfgmO_wyzw8rNrZS9UrdlfXKqUCRzbBP8plg8rzFTdwsiZOlz4C9fQehyVlN4_MEFgy8BQTWLs3PRg2JrJWn9TqdRfhzB3t-lXfhEnBgbb-opahxRzEw8dJzCj7LC2R0VlOe0I9w5OhkdUYRBuau73EhurQFHH3A.'),('17f96f99dc860e350f75570d6171edaa',1331929584,NULL,'CTX4ly7l3eV0nJ_YNpttvpIhhqg0EXBeZwoHRdfGk-Pf332T9vGNczINxjZ1Nj323kZK9_nZfUEPVVEnZ2XPKtZURTnx_pZlQ85Pwii9cx-OVh-QlCP4jH8ePVqy-g9qWrmkVk2VpD0Iap71PUbb9TcX4pWfBALHh4dspvDcHZ3rV7B5To86uH59F9qIjUbpXAiVDsgBLQr9JaBpxq6Z8Q..'),('56a7e500c4b2260982b0217935dde4ba',1331930837,NULL,'-zJ4t3Bh5F5X9Rdhg73ZvKFt95Oh_Mxg3-oyDYS2AKwvqG86IV1pfuDwuoIaceissdYUe3wYMTpSrD95lIGx1twuxbHixapo-WbEQ3d1SkyrzrWBTT9y-8ZJyyP17nr6hkCifG1aBBMus1yKdww7eA..'),('e869e1a422fbff20a1443ddbf1e6741c',1331932577,NULL,'YmghTVKjPjdVYeSjoLtZrrSItRlXL31FGzKgx6S-BmljrbG-d4VXJzM7lJE2KysskhppQ322aIhb_qUNVAa13jM6H4rMI_zZEm2odr2mxjdM31KZuzLvwUVu-gTx8sanGhUhU5kxsjD06-QxpTzQPO4zRDzdrbId_TLhCg2WMDM.'),('8630219cc860194c1003865f839cd89e',1331937992,NULL,'kjFGnANa-2f3XHto7Lcxf6RRr1byGpxMxDeE9svInFiDAUYGo0pP17TR9O3W7ud12VT3jzOySK1BXa7LFsdNdUvneI7MlxKTq4ZEgmJjT9p8uXNUN9gt-4sA6oGjztjrly99l7pCWk5JJXZFJq3YCw..'),('5c7399b45fbfc43db8905db5081286d7',1331938562,NULL,'gBuUOLF7BrFNAf5qhBn7W4D7K9JO6O_0fHLh9gT1ZfSJAkGSAxlbI4ryb-7F95sal039-VxgQDQbpak8BZfIZsJZkycPp-QS57wksCHVC7ZVK4bdBIpTDV42tSOk033TqM7Anid_Jl5fYYooVJ1HgtVjM7penvdWu0GE6tHtjW8.'),('3d3f525c5b4099ef2d586ad94ae0230a',1331944626,NULL,'26gAAiN-m0BgmrMu_cjWPL0Gg2xhiHdFgk257Ue2J3_8_5Webet3AvCezbcYoVhYggw58otL9PGT54r9U0UwPbio-mvF5FUofsfjnm8rEnpYKHOeJIuoK0vl3NvjGiIYAtXPSRs1VyHZyBfGlwMxMt2jSyRQj3H6CEZo56lXNAdCA5jkQ4C-xj7xVWB5b-u4'),('950932e84127b009b7d1a6dc40a3ae2c',1331945344,NULL,'_o39WIurzbqThrIbxOVSj8JIwxvswWcLCko9Nn1DiTEdbiHya8Nlj15saY4wsRo5hl80LnGMKSrFeK0oBpNw2FvHwIiufhYFrUOdBCqbatkooXXzk3KEFk4B2rq814u2sS53_jD6nJX0mdWoiuOQJg..'),('aa1846d5995ff31134e4bba1476c9ee0',1331945990,NULL,'N7iPjATfi-pIbS9DwosxYBHbFv1oMBfsgh9kWUHmt5yWJvAUZ5wFlwPlQtX5wchbhD94aFF-wV-IPlytrIF9LQ0pwaDVsw9j23SEOT5TwKsigioum7K07pw9ZaBFBAmgesAKc3cSalZJEQ2Y32Y90PDuGpvOzopMuotiiuIpNl4.'),('a24d45c7621fb889b34a8c9284fbb45e',1331951657,NULL,'fEUnP5GV0evGr1TX-Ga1JsifOjsntpoFGqlyV-pSnTSWiaEHXbcEJAViNyuglDiJpxrXk8OT9VtugVrgSKSYhpvVC-LhU00Jh7-InK3NCu1DDwrlm73M26bXvRtuSw26Qza6vc9SsqQk3Q4k_go5dTDt_UaCVxOv4VB9tnONJ5M.'),('de109af52e28a0d7785489370ad021f9',1331952350,NULL,'QBsLyfw4fLuGHNzNwwiRfCMuWTG7yTevXHpX1QVh5BU0rCNDZRBulE3l0L0mDNleY1Viok2MoWPnXsjgW--ux6c9PtIc86rem2miBRiyDcdng3fhxb4eQjh78Dcn3SLvwtlHay6ILrDCVzdc6ox-TQ..'),('7a2181b0d648b4a473ac293af8a59304',1331955023,NULL,'mZBNVmvtxhGKFAWUXIAOB42O6IGPV3o3bX-WCrgMiG8KDr4boHi6gFWx3K-g0urAwUS-y2gnjHQPoph8vfWU57MYDbrIDkXwl_3nU6CW44vz53dzI1pMWa6IN5A7cTEmaZzW1MzcTXbGxb2DQcInTF4GP1jzisuxyZxH-Cv3xl8.'),('092bf234d12da9dcb28eb2c28db0b81f',1331958576,NULL,'JgGC1ACf1RZ8PaEm_XwzGUWYeu7j8hrol0KM2FExYh0UkuTwn84IJbOu-W0hgCluSBfZzILvUVU7nD30k_p9N6if-UuhhjsJeAvELfr_OY6V15qfqPVXFK4mSRP2g7cnMmFPKGiyUQEHq00NbNkvHWxQGYMd_ONtlWuZsweyC18.'),('f555788e8180567bfc3420f654038563',1331959672,NULL,'-eF6T2eCZj6fpd_k6rSwBsAp_yJdLifQKF2MctW5_MID0hzh3c3S-PLJVnZe_1KJEIqz-flyjUIKzHVc1iOyHW3gU0HaZO87bf1qg-7gkGeYNV9t6-NKzEC2bZ0A8CB-shxxS3QkGk8aTKq8MBI8UA..'),('2d026bceae576477285ff3b1a316940b',1331960336,NULL,'6cks9Umius76mpGjVKqLGgWrFxEzC2uwkm2kQdkJwIR2aW3a_E_eVpyJr7_kVn3CgbtrBGgaE60UlwCMTsxzuwrg4BKKRB0AGdpEP28JwOXPWBzL5aJnTXUw4z1nSbJm1hY9YQSqt5asdQJ0MBaqVNz9aptu91L7Hcl4KxGTDB8.'),('8ad46e309b9ed5614956cabad6fecc0e',1331962427,NULL,'d_yP4PMroHpqJKj3vg6g7D1u-v0J95V57Ge1c26tyK7CUnRZBMV1ZmnsmH5YiXmHmTvtM3QLjzLhXwqfV5IoQRYOPAmEuudv_CiVScEtYbaZWxOaFvINyrwsbH38Rp8hGU-t6SMYjFs2Nd09y6ndxVvK23ejoSW4PoHzcXwwJki1Uj4qfdEfuagwjEiVrWrCsE-ApVUXiPYpkT6xjEGEYA..'),('5f2e0feccb8807b9526fd7bde0c1313a',1331965791,NULL,'rlcFSTqKrU3ITTVRqrZ8W0StTQaoeRMWO-SYlR9q4hTcBkUMZy6QLkPfN1ZdyUlZ8_KWX4f2WgUKLexXOioVMIggpyAzhJ08hNX16oCWlNQg3qbUr3fFvH3hq23wKDSXO3Dg1dkZz7YPunut2wsq-RHKd5gzW0f4yA44UvadN-yRBwaLTEmZ1fUUwSPJwOQ9'),('5a7af9b4c4832d0133e90401a860e2c4',1331966917,NULL,'wSvlOSMpLSnKUJbXsyZ6z_fkb9gvsoHo4-rqz0Shaz0izA0A1ZFbNZk_DojwmXghlAbEl_s5yG4TParlXHel4qWh6RprgCc1EK4XWo99bjDjMyTF35_P7VdCqIZHJGt9_aXh338PUxBqCxCTLgb2HA..'),('6a4a5313f0a2906b43fd9c5e62ac86a2',1331969409,NULL,'PvVbuhExWpe6EzDAQU9ujqjhU09Mjiez_MdZz91dU23sq1_L-1DPYN-9CjPJeqP5iv3jUaCbZGQ1op9XGwgoeyYpVdlPS7UnIC2UUrOqmr03lzIZaFusZ9PXXKCD-0RYqZe6B3LsRK80pxzy9wXTpy_fmFpK1S1ncE_NLbARezRlcxA1xA2aV-mSvWRdO1Rc');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_users` VALUES ('admin','85e24c44b8fe4f2a55d454b1ad3c46e2','Administrator','kennedi.kratzke@gmail.com','2012-01-18','1','',0,'','','','','','','',''),('qcalebnorrish','dd5e2fe78efffd0d319bb4cde3513f82',NULL,'octaviodowns38@hotmail.com','2012-02-12','0','1961',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('vmelanirodgersr','3dcd3def2bdcc5c490c778dc85f835a7',NULL,'cleowynn1230@hotmail.com','2012-02-14','0','4346',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('nmolliechurchv','bf6370487f0888c1b663175f1b2fde6c',NULL,'MarkkgleyAduyrien@hotmail.com','2012-02-14','0','4723',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('gderekwangw','f1008fc57effdf600308325635e8c1d5',NULL,'normanstokes1025@hotmail.com','2012-02-15','0','2134',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('pnelsonlaneu','86a34e4bf2b3a28e37cded0571ba8401',NULL,'landonfitzge516@hotmail.com','2012-02-16','0','5779',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('sjackyjok','a7f371344ce6a5b299617a7219b82279',NULL,'donovanwalsh425@hotmail.com','2012-02-19','0','2160',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('aangeliascott','ed65879477403baad10748a88a17326b','','aangeliascott@gmail.com','2012-03-13','1','5817',2,'http://','','','','','','',''),('1simonpeterson1','56fa861e6605dd8f0116fe66ac20705b','','1simonpeterson1@gmail.com','2012-03-13','1','7056',2,'http://','','','','','','','');

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

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

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



