--
-- Host: yourestateagents.com    Database: youresta_indexu
-- ------------------------------------------------------


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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Agents and Agencies','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(2,0,'Apartments Rentals','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(3,0,'Appraisers and Consultants','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(4,0,'Brokerages','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(5,0,'Commercial Real Estate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(6,0,'Construction & Builders','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(7,0,'Finance & Mortgage','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(8,0,'For Sale','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(9,0,'For Sale By Owner ','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(10,0,'Foreclosure Real Estate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(11,0,'Home Construction','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(12,0,'Home Inspection','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(13,0,'International Real Estate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(14,0,'Investment','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(15,0,'Luxury Real Estate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(16,0,'Moving & Relocation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(17,0,'Property Listing','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(18,0,'Property Management','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(19,0,'Real Estate','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(20,0,'Real Estate Directory ','','folder.gif','','1',0,'','','0','0','','',0,'',1,0,0,0,0),(21,0,'Real Estate Education','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(22,0,'Real Estate Listings','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(23,0,'Real Estate Marketing','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(24,0,'Removal Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(25,0,'Rent','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(26,0,'Rental Properties','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(27,0,'Residential','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(28,0,'Student Accommodation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(29,0,'Vacation Homes','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Agents and Agencies','<a href=\"http://yourestateagents.com/agents-and-agencies/\" name=\"cat_1\" style=\"\">Agents and Agencies</a>',';0;'),(2,'Apartments Rentals','<a href=\"http://yourestateagents.com/apartments-rentals/\" name=\"cat_2\" style=\"\">Apartments Rentals</a>',';0;'),(3,'Appraisers and Consultants','<a href=\"http://yourestateagents.com/appraisers-and-consultants/\" name=\"cat_3\" style=\"\">Appraisers and Consultants</a>',';0;'),(4,'Brokerages','<a href=\"http://yourestateagents.com/brokerages/\" name=\"cat_4\" style=\"\">Brokerages</a>',';0;'),(5,'Commercial Real Estate','<a href=\"http://yourestateagents.com/commercial-real-estate/\" name=\"cat_5\" style=\"\">Commercial Real Estate</a>',';0;'),(6,'Construction & Builders','<a href=\"http://yourestateagents.com/construction-builders/\" name=\"cat_6\" style=\"\">Construction & Builders</a>',';0;'),(7,'Finance & Mortgage','<a href=\"http://yourestateagents.com/finance-mortgage/\" name=\"cat_7\" style=\"\">Finance & Mortgage</a>',';0;'),(8,'For Sale','<a href=\"http://yourestateagents.com/for-sale/\" name=\"cat_8\" style=\"\">For Sale</a>',';0;'),(9,'For Sale By Owner ','<a href=\"http://yourestateagents.com/for-sale-by-owner/\" name=\"cat_9\" style=\"\">For Sale By Owner </a>',';0;'),(10,'Foreclosure Real Estate','<a href=\"http://yourestateagents.com/foreclosure-real-estate/\" name=\"cat_10\" style=\"\">Foreclosure Real Estate</a>',';0;'),(11,'Home Construction','<a href=\"http://yourestateagents.com/home-construction/\" name=\"cat_11\" style=\"\">Home Construction</a>',';0;'),(12,'Home Inspection','<a href=\"http://yourestateagents.com/home-inspection/\" name=\"cat_12\" style=\"\">Home Inspection</a>',';0;'),(13,'International Real Estate','<a href=\"http://yourestateagents.com/international-real-estate/\" name=\"cat_13\" style=\"\">International Real Estate</a>',';0;'),(14,'Investment','<a href=\"http://yourestateagents.com/investment/\" name=\"cat_14\" style=\"\">Investment</a>',';0;'),(15,'Luxury Real Estate','<a href=\"http://yourestateagents.com/luxury-real-estate/\" name=\"cat_15\" style=\"\">Luxury Real Estate</a>',';0;'),(16,'Moving & Relocation','<a href=\"http://yourestateagents.com/moving-relocation/\" name=\"cat_16\" style=\"\">Moving & Relocation</a>',';0;'),(17,'Property Listing','<a href=\"http://yourestateagents.com/property-listing/\" name=\"cat_17\" style=\"\">Property Listing</a>',';0;'),(18,'Property Management','<a href=\"http://yourestateagents.com/property-management/\" name=\"cat_18\" style=\"\">Property Management</a>',';0;'),(19,'Real Estate','<a href=\"http://yourestateagents.com/real-estate/\" name=\"cat_19\" style=\"\">Real Estate</a>',';0;'),(20,'Real Estate Directory ','<a href=\"http://yourestateagents.com/real-estate-directory/\" name=\"cat_20\" style=\"\">Real Estate Directory </a>',';0;'),(21,'Real Estate Education','<a href=\"http://yourestateagents.com/real-estate-education/\" name=\"cat_21\" style=\"\">Real Estate Education</a>',';0;'),(22,'Real Estate Listings','<a href=\"http://yourestateagents.com/real-estate-listings/\" name=\"cat_22\" style=\"\">Real Estate Listings</a>',';0;'),(23,'Real Estate Marketing','<a href=\"http://yourestateagents.com/real-estate-marketing/\" name=\"cat_23\" style=\"\">Real Estate Marketing</a>',';0;'),(24,'Removal Services','<a href=\"http://yourestateagents.com/removal-services/\" name=\"cat_24\" style=\"\">Removal Services</a>',';0;'),(25,'Rent','<a href=\"http://yourestateagents.com/rent/\" name=\"cat_25\" style=\"\">Rent</a>',';0;'),(26,'Rental Properties','<a href=\"http://yourestateagents.com/rental-properties/\" name=\"cat_26\" style=\"\">Rental Properties</a>',';0;'),(27,'Residential','<a href=\"http://yourestateagents.com/residential/\" name=\"cat_27\" style=\"\">Residential</a>',';0;'),(28,'Student Accommodation','<a href=\"http://yourestateagents.com/student-accommodation/\" name=\"cat_28\" style=\"\">Student Accommodation</a>',';0;'),(29,'Vacation Homes','<a href=\"http://yourestateagents.com/vacation-homes/\" name=\"cat_29\" style=\"\">Vacation Homes</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_favorites` VALUES (1,'aangeliascott','2012-03-13','',NULL),(2,'1simonpeterson1','2012-03-13','',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_sessions` VALUES ('b88a0472bf259e079691ca12cf6294fe',1331870767,NULL,'BRvnklvCVMin11e_jFiOBvB92bm5PNXzlhI35FX_RgrYlNib5SgW5gL9oh_KgBmCtCrsLw5bCSuZu1iOgaBm6biHRTkIQXPfVrtwXqc56IuMXo7sP1zdfKtYUN-Vzs5cJsmxibiNR9NFzKYfcpgHNA..'),('884f6350ef8bee557cf1b5c628883dfc',1331870999,NULL,'P5Zdp2ui9Ap-cViR6tXskV_L-a3vCaq03pKA7ZGKaUSMvD5GncvY3PfIPUF0BJ8ok-ogQu7DgE96kPcKE1oSkBoj6yV1fffz3c5tCO1W_BYdSMHhhQFMsxDZrgL9O4C0aSi3d6TaYHmJ9fInvF3IQKzEPB9B97W6dNeWJcNWCiU.'),('c1df9083d403465233e748c9c9b12e19',1331871420,NULL,'bxG_2q_Bo7UvEimRP5GZit6cBkMdqtFe78c0pDAXc0E48YieuR4j4TkSkdU7QXrAD46Hg559vL6tHVsbYpm63dPbYIRPXqOsOCv8SHubArwho5JhCC6AtVBlNMRWDWBSqxyhI8XM1AeGrp8Jvz1raxgUuhFFWQrswPQv0VKObP8BWSPPj9PmlAAPUBHyTjkJ'),('4c7f31d6f72acc3f06bf0a9bb7d20f08',1331871422,NULL,'gdC25t-FQ-kDbcA2jKRcILiTzOoZB6ItN3XEHwXT6EYGotenlbWqiw3RpEuBQ-Kmat-CkP9Fg5Qb6TGWOYZgOmTWLCPO_sGG0ObhCyXxOdrzQHoEw2yg0-tahLTyWUuHQb6mzzbmLlpc9e0IrNRxsOKQ3FseacZbmftEZH04PwNCOTGvNGyIG0cK6JiVSW0H'),('374cba02a607350e4a016158d6044992',1331871423,NULL,'EvWEJeS0OP1qapa9cXDFQCbb-TsNfQlIp1ztlnwI08kdGXKfjzgiBmWgnCGfHvXieOgH7n-a9cAujt34Wwmbmiwev8liKTf-rAYSzj9liGZUmcqWvmMa7YZQ_0G8Pe9ZobrOyDqk6ULM9YFra_9mR2bgAGSM0ovMpwYnzMX1BL40h6UxU7-atBBByEWDn3Es'),('e18fd1aab53c6ee108808cba8ac821af',1331871439,NULL,'MglkeqINbOtTvEkzeAiReAaa7xhbNerxYvoqRJqog34TfB8TAWez80YIiEBOa9GYC8yK1wqrpS4JXW6Wb6pJfQfi1YIxNEe3b-SMPA69giOyphWY_PWO3l8ke_mD33KEGJwDaaO-KY9s9D4iZ6IaC2Pn7nCtOGbqMvVLwuhZR8iTahP4etTUUW_zwcsMp-hQ'),('3b3e4f7ba8a00d9ac100c91ac03248ff',1331871441,NULL,'1ZvV3mM0Nou6n4FwPFuv7eh9tFOEl4JhgGU5lO5BEP6OyByqDbumwSyI58uwXp6LI4KmKjK2wWf7RRCbWFAW21ElKPU-PNt3ffIfTcfxaBq2X5pxK89-OxzUY2PrKmFQRd_3aGTrgTqjA4riP_Nxie0s0TYWE8Q2xkUQYUv5apGp6bLaSe2tdPy3XCblvIUu'),('f7c98937ce75ffcd09e5ea203ea11d1b',1331871444,NULL,'7nERxHGGXIDuQuTpSF_JUYKR3mIfOQ6HZTGa14dJ8AyjyrP95Zhohjy_MFBMfxFIw5hk0zq2NoT03qJe4Gy5G0tio7Wp-coNtIa1E0s-VVCDUuTknCHJqwQywA-3e7xnp90T3XWPVGbpfuFmTJ-VdOeZjkznuCpxDf4PwQxBipaPgnRG_J6ZzA5RoQDQd70N'),('d473e9a646b54ffe9db4e70c8f8f1270',1331871449,NULL,'U1DOjI4to91rHQWHJfP0rLLwUdYcrv6de_VLGwmSD1RkaZKCRrMrKDBXfNBTwfs6D-gvKUiwONvJPYDm8NJ7odB7a4-Sxm1dbig0j1jJhH18CZiwhJBLIQ9NOnLHhpdJft_kiEHgYnd9bNHxbx0DVr1V9zvSWUtu-QigEcyGPDoVNC651y4YAHWQ1JvTpygF'),('b75062931846d26b2f2052b421cee19d',1331871455,NULL,'EvWEJeS0OP1qapa9cXDFQCbb-TsNfQlIp1ztlnwI08kdGXKfjzgiBmWgnCGfHvXieOgH7n-a9cAujt34Wwmbmiwev8liKTf-rAYSzj9liGZUmcqWvmMa7YZQ_0G8Pe9ZobrOyDqk6ULM9YFra_9mR2bgAGSM0ovMpwYnzMX1BL40h6UxU7-atBBByEWDn3Es'),('b5da9a45d2b79f29f6a4d8dd50937c19',1331871469,NULL,'wF1h9CQp80UYO1kC4NU6iy_tJvEBqc1g4ivlWoiTm5WwGA5-FBzgsDj9tfDWB_mQeer0AFDadBi7pFHe7kuYATCdh9601dVvm58he4fN4CSw7rf8BMgqVTUWCXieQD5fbS8cp5ww9Qsy4jTBbcCxcyatdS1bIwMnaPep6LlFLKKMd9vCUxGrOclW4lwPFXnj'),('3096dde8437c693a57412bf8be02bf4a',1331871470,NULL,'mU5246xPMLKGMb29q_ujeAEhecnQgWZgxgWuk0di1u6BHnBxMddBTXrl0Xppl6HvstrKBRHSMys6A-UV4mAa_2qpq80deUrvMyGxBdtvaRO0a0T1Cbnf5PF6PgHf0z4EchbYLBqs2f3lNoXxy4w8SwElLRdKMFsKYub5ezRMp7irdLgp_d_UCwJCpUYGBGk2'),('175025a15b1995b04bbc801bb222f0bd',1331871475,NULL,'YJOo6bfIFnNHgxaA46So8WASr-HmaWnvurIum-UnUi-mwobaLhFUgW65FzoLNEugQL7jvBvv0PYRzL14qk_8vNM2JoytkFe6lOxNlkcUnPvlj7MS1vN5qoNFcVihI1m86Y8yPsVbMmycdfbGjPSv598k_fspW8GBQHJwltaFnQUD_K2efXrcMfEM3mnvpAMG'),('648cba365dbc02b8dd5a3b761760aa7b',1331871476,NULL,'NvIUw_nBbWdGvv2-1lEeSZivOlwnYGl9R60ypPGZ2pZF1zhlHGnt_RxXL4NAVgK9EotQDfA7MNPM-rpzwrrHfCxk5Lep-rCYKo0F5PGkGZv3BH0sXbhD_vAE-kNfXYTBIU-vgoECveV9CiHghr9s-w7KtTTpWD1FuAAWuaoWki1CtYemi_KvesdK0Y3Ew2bv'),('06352606e522e5f05cd1840c844271c2',1331871499,NULL,'OaIIH_LyciEpZjRHLNV_IoTIG77d_oYiQYP4NcCo6b35EO529Ec53VVkUA9sOoJ4rSwACKMI17Jdyvya5WtrRo-cJc64qOBq4Ng-MSRRzbTjQRNe17-VPJyzvK6kl3yUtR564OC792SmhqNoD7woq4hNoVHku7Zva1aiUpnToFaMGBeA4JJgXZi79Ofka6rm'),('5884d1a68915578ce2000a02d6fb0ce2',1331871510,NULL,'epjMVRS0vvmNU6bU9mzjFLQz4HSvGcWmYjFw2y6G0iFI4BOaFoUfdQlIRLTNZBKL3kSLAZi7qezfQ7YMSh_nIMJHQ0Y_KiN-eIKYgzp10EeZaynST8E0MyW_3L-2nqsH3r3k69PJGm-z4FKhV-PHAmmHG5JIAgmdY5lnAfh_poEyIWfarkra0cVGpjxN20OZ'),('0ad8e485abc90bc14b5be7886d637c8c',1331871513,NULL,'UKde88VoQTWbn24T_Vp0qbFwOSVcItLuADNd-fTodKFYOHR8KRaEyqol7nWTqVoC2kIBbE9NIpleOtujo0UZarE_T6BwxZgkGi_Hej7mi69WTwT1GB1oMnA5C5mRnTiRE2q3Mo3aayKOa9qzAVtDYnTU7syfYHx-IwBHHjF4PbRaQM7ZtdRrtARvddpL-PEV'),('51aba4d0554a39872a58dc5988e21b56',1331871543,NULL,'MglkeqINbOtTvEkzeAiReAaa7xhbNerxYvoqRJqog34TfB8TAWez80YIiEBOa9GYC8yK1wqrpS4JXW6Wb6pJfQfi1YIxNEe3b-SMPA69giOyphWY_PWO3l8ke_mD33KEGJwDaaO-KY9s9D4iZ6IaC2Pn7nCtOGbqMvVLwuhZR8iTahP4etTUUW_zwcsMp-hQ'),('96336969a475d3d1d01101207b149233',1331871549,NULL,'iC3owEnro_IU0dtW3wDNqc8Pa2wSHfuMjqXJ-DnmpoYzH1KiWfRAsJxPRbikqjGhPbE2S14YPYkm6tnFW0w_XPWa4o80hFrj-o_oWkvSeAbBUi5tLGgOnbUYMTcwCB_cNJ-GZWL0ZS9-g_3arD_pJVvMsVY1G7jSnrOx5DBCMQV5xoNQ_OE5PHawUus6H8Vm'),('4c81bbc366a12afda4695a6538bfc9ef',1331871551,NULL,'epjMVRS0vvmNU6bU9mzjFLQz4HSvGcWmYjFw2y6G0iFI4BOaFoUfdQlIRLTNZBKL3kSLAZi7qezfQ7YMSh_nIMJHQ0Y_KiN-eIKYgzp10EeZaynST8E0MyW_3L-2nqsH3r3k69PJGm-z4FKhV-PHAmmHG5JIAgmdY5lnAfh_poEyIWfarkra0cVGpjxN20OZ'),('1def961063743194dccfdb45837ae79f',1331871556,NULL,'EvWEJeS0OP1qapa9cXDFQCbb-TsNfQlIp1ztlnwI08kdGXKfjzgiBmWgnCGfHvXieOgH7n-a9cAujt34Wwmbmiwev8liKTf-rAYSzj9liGZUmcqWvmMa7YZQ_0G8Pe9ZobrOyDqk6ULM9YFra_9mR2bgAGSM0ovMpwYnzMX1BL40h6UxU7-atBBByEWDn3Es'),('ca9a562f96d54d33fa80a65889722233',1331871556,NULL,'UKde88VoQTWbn24T_Vp0qbFwOSVcItLuADNd-fTodKFYOHR8KRaEyqol7nWTqVoC2kIBbE9NIpleOtujo0UZarE_T6BwxZgkGi_Hej7mi69WTwT1GB1oMnA5C5mRnTiRE2q3Mo3aayKOa9qzAVtDYnTU7syfYHx-IwBHHjF4PbRaQM7ZtdRrtARvddpL-PEV'),('3fc15a15cb8e335f06a00eff5001bc54',1331871559,NULL,'DGr2h5YGwMxD6ilJ4X6Ejld0Euh_ZA0238HufjJtkdj44qi_mDMkiXrMm3hjOE8K1wEhqM0OwoOhT0yoPKZzd_U1uakEyl2oCSZriY0r6Isza3AnWyCFgoYx52NPGDVETN9LFNysap_SEJR70l30w40VNS8kKq6pjb6Sf-A0vDckxQHXdnXJhFcbYaoYxJHB'),('999f169380bca49659c9269e6f165633',1331871563,NULL,'rL2x1Pa6Ces3YRP92D3LUhs5ISFWsljyHSz3Yw9bPzlNcgLWyb1CXeYe5TH0F-qLJfhgp-xaeuUphn_stNRoiK_NbBJg-nAxTn6spHHKfvbrR-DhrigTeLjvSzgFIXxXshbTtzRl08lp_F6CqpKgTWAkgc-cEoYQ326ALDd4ykM79-Cqn2o3xCSxa7STW8i4'),('83ead6bfc80fc6e87fa3ddb1c9c50996',1331871571,NULL,'OwaZWQkctwU94fIgOb7n0YXY4igAPloYdPCoWqxdmfnhJNPVyvv-nyAyV433QOMAj7de6iD1H90ZYtckS9KVI6o-L3SeduF_WX6-VGiUEgvLlrspc1XXldaVCrvazogjBkgJfZg7-SRasXZSLsyqwkaxx5Hnw6E_bAgIm4hGfT5z429W16L1YFb3IIDl5A5v'),('426ce2324049f3d76ac7aaf79da3ec0e',1331871572,NULL,'wF1h9CQp80UYO1kC4NU6iy_tJvEBqc1g4ivlWoiTm5WwGA5-FBzgsDj9tfDWB_mQeer0AFDadBi7pFHe7kuYATCdh9601dVvm58he4fN4CSw7rf8BMgqVTUWCXieQD5fbS8cp5ww9Qsy4jTBbcCxcyatdS1bIwMnaPep6LlFLKKMd9vCUxGrOclW4lwPFXnj'),('e3ab6a466386fcfc45b57392925f4018',1331871577,NULL,'heL2tbmUZfmYTeLGak-4q1fCUMJ1Ac8hHH4UyZnfOswf_gV3SRACax7oOaQFSRpf72ESeKaEjDUD51YlGJYUePuoSO_j3mo6v5OxYQ5-_wJyhHEEYiY00R7ET2FrtMfAGIlWrLswBE9DbR9fVa5a3m5LLbBISOA3s1RNDA_IAOqOt7JAw3_YUoWagMBkuhWC'),('39b02a82f5316e91847e3b137c69650a',1331871578,NULL,'EvWEJeS0OP1qapa9cXDFQCbb-TsNfQlIp1ztlnwI08kdGXKfjzgiBmWgnCGfHvXieOgH7n-a9cAujt34Wwmbmiwev8liKTf-rAYSzj9liGZUmcqWvmMa7YZQ_0G8Pe9ZobrOyDqk6ULM9YFra_9mR2bgAGSM0ovMpwYnzMX1BL40h6UxU7-atBBByEWDn3Es'),('5c9cc6c4cd8ccc794eb7e7b10d8b5ae9',1331871579,NULL,'mqUYPOtjUnvDX_GXJCKbCx9j5M7tyBUhOVggpF_oP_D5L6XD5k1Nx9NpdtgMbYTbZH0FrYreiU-iBBKy7iEwxmBef65o8DDNNEh7rZ4pNQw0xkpHcdBxHkkdwMd03o3deDX-ItJjC8Ne4k8DzduzSMk8DoQyoSuKh8CnLsrtuNJ-6_FfRdw8YvxLgHpr94lB'),('16845c77af4fb18ca6ddc5439c854552',1331871603,NULL,'s3R7b1Bx9C769oeBeVpsp5p1tXVdOb-ExiEN47UR1Y2FGMTtT6yihAXoF1upX2aP46aJr7WGkKF_mrmsnfQ8N4k3aqJYQJCEyFF_wrThhvK4lDHA9FK0eINO3U069r3Sj1w0vDOMNi3whoFY5YrMVgJcyrKDi4wCdb56mWXOKfyTZtrXnVuX7PJBGssa0UFy'),('289ff14c3aaa3457b509337b5b6361c7',1331871604,NULL,'Omq7GkGutnMdjb_pqfmDwihkBsbVd5GMYmti5iNjfLnxGz4ssEssiEP0B9QqD10LQ9orNP53r1wUwTsGrgnzT91nnP1MTRSxLaYh1UCNvj9K7dYLk6ssb2UFfY8XPYQ3ScpEykibGA0eY-gONiVp-rDRtiqOWWZrQ22iRDMwQnHE7ppX3ehT1-EUlJfCBR1I'),('92b1a66b4178d469f0720306c79d1fb0',1331871634,NULL,'s3R7b1Bx9C769oeBeVpsp5p1tXVdOb-ExiEN47UR1Y2FGMTtT6yihAXoF1upX2aP46aJr7WGkKF_mrmsnfQ8N4k3aqJYQJCEyFF_wrThhvK4lDHA9FK0eINO3U069r3Sj1w0vDOMNi3whoFY5YrMVgJcyrKDi4wCdb56mWXOKfyTZtrXnVuX7PJBGssa0UFy'),('39bed6d63ee4beaca7e35ee5fdc93db4',1331871644,NULL,'s3R7b1Bx9C769oeBeVpsp5p1tXVdOb-ExiEN47UR1Y2FGMTtT6yihAXoF1upX2aP46aJr7WGkKF_mrmsnfQ8N4k3aqJYQJCEyFF_wrThhvK4lDHA9FK0eINO3U069r3Sj1w0vDOMNi3whoFY5YrMVgJcyrKDi4wCdb56mWXOKfyTZtrXnVuX7PJBGssa0UFy'),('1c3f1ddd3aa30df07c92421089abbf13',1331871654,NULL,'83m_UIc--N1s1_yzAHM-nOx_IrrKN_kTBAK5BMBE4hHrIefiL0pVcLF_VeDEiLlQLuaDDE3qgI9ZYiZduwdPqQ-DTOwXBaZFT4mD70jd62IO2dMCK8jr30uUIF29SBZuLJIV5NklSEVTg-AH4ZV-mtXf6hTa_f0fjTmG3rsq3xxwZu4g7sgpU1DHFehBgkEx'),('24b3624991c1fa24d9cae3fc18ad8296',1331871656,NULL,'Upm4vULx4x9M0oM52XHwSqOE6lmVhpeRRIInlYvVmarq1HTMjJutFi8U9h9RiEuY6D9Narq4qzAHj0MH9yLTgxGweoyZgLgYp5Zr7alk2QxVKZ-t4bC-m2c2Xr5nMVxvgErmrTn9heR6xVSUGWbUm5x9IMU3TWskm1fG4JymokIdPcNdS-N7v1tZJXZGXiGY'),('6bce219ae8677d6b2e45bea81f910465',1331871683,NULL,'RSUd8G-EOkshAbz8R6LF4n_ZPYY5Fw7RZiOmUdp9s2_g9mQTwY9Gbuk9dnTDCHVRiGSEcHj9V4A1Zw0R4DT4MrO10PoZca22MpmAdUFJ_mW7tggiFKTDXaZxtbzxiEnouGZFEAEhS1s8V__2ooe0bfH-Kqb4meASNiBK8C9sIgIwRpJ65zNCETb0dcYXYx-Idr-ooEj9TKAgLOazmWFDbw..'),('fff8a73591fac4049423f6f6f5e1948e',1331871681,NULL,'83m_UIc--N1s1_yzAHM-nOx_IrrKN_kTBAK5BMBE4hHrIefiL0pVcLF_VeDEiLlQLuaDDE3qgI9ZYiZduwdPqQ-DTOwXBaZFT4mD70jd62IO2dMCK8jr30uUIF29SBZuLJIV5NklSEVTg-AH4ZV-mtXf6hTa_f0fjTmG3rsq3xxwZu4g7sgpU1DHFehBgkEx'),('47becc43c901ceed2fb3e7a642407c76',1331871715,NULL,'bxG_2q_Bo7UvEimRP5GZit6cBkMdqtFe78c0pDAXc0E48YieuR4j4TkSkdU7QXrAD46Hg559vL6tHVsbYpm63dPbYIRPXqOsOCv8SHubArwho5JhCC6AtVBlNMRWDWBSqxyhI8XM1AeGrp8Jvz1raxgUuhFFWQrswPQv0VKObP8BWSPPj9PmlAAPUBHyTjkJ'),('b196132f28970a624514bafbb2d9dd79',1331871719,NULL,'EvWEJeS0OP1qapa9cXDFQCbb-TsNfQlIp1ztlnwI08kdGXKfjzgiBmWgnCGfHvXieOgH7n-a9cAujt34Wwmbmiwev8liKTf-rAYSzj9liGZUmcqWvmMa7YZQ_0G8Pe9ZobrOyDqk6ULM9YFra_9mR2bgAGSM0ovMpwYnzMX1BL40h6UxU7-atBBByEWDn3Es'),('9d54b275e9d38d22a7a8e17bf0e8936b',1331871724,NULL,'Upm4vULx4x9M0oM52XHwSqOE6lmVhpeRRIInlYvVmarq1HTMjJutFi8U9h9RiEuY6D9Narq4qzAHj0MH9yLTgxGweoyZgLgYp5Zr7alk2QxVKZ-t4bC-m2c2Xr5nMVxvgErmrTn9heR6xVSUGWbUm5x9IMU3TWskm1fG4JymokIdPcNdS-N7v1tZJXZGXiGY'),('542aff5776d2b196a71b8d3cf6ba1148',1331871747,NULL,'gdC25t-FQ-kDbcA2jKRcILiTzOoZB6ItN3XEHwXT6EYGotenlbWqiw3RpEuBQ-Kmat-CkP9Fg5Qb6TGWOYZgOmTWLCPO_sGG0ObhCyXxOdrzQHoEw2yg0-tahLTyWUuHQb6mzzbmLlpc9e0IrNRxsOKQ3FseacZbmftEZH04PwNCOTGvNGyIG0cK6JiVSW0H'),('0739c3fedfd1239a80ec905593b66170',1331871772,NULL,'bxG_2q_Bo7UvEimRP5GZit6cBkMdqtFe78c0pDAXc0E48YieuR4j4TkSkdU7QXrAD46Hg559vL6tHVsbYpm63dPbYIRPXqOsOCv8SHubArwho5JhCC6AtVBlNMRWDWBSqxyhI8XM1AeGrp8Jvz1raxgUuhFFWQrswPQv0VKObP8BWSPPj9PmlAAPUBHyTjkJ'),('cb17837769187b27198be8d8b82801b8',1331871848,NULL,'83m_UIc--N1s1_yzAHM-nOx_IrrKN_kTBAK5BMBE4hHrIefiL0pVcLF_VeDEiLlQLuaDDE3qgI9ZYiZduwdPqQ-DTOwXBaZFT4mD70jd62IO2dMCK8jr30uUIF29SBZuLJIV5NklSEVTg-AH4ZV-mtXf6hTa_f0fjTmG3rsq3xxwZu4g7sgpU1DHFehBgkEx'),('7a8b5d3ac5c06d3ade687566f75e903b',1331871851,NULL,'U1DOjI4to91rHQWHJfP0rLLwUdYcrv6de_VLGwmSD1RkaZKCRrMrKDBXfNBTwfs6D-gvKUiwONvJPYDm8NJ7odB7a4-Sxm1dbig0j1jJhH18CZiwhJBLIQ9NOnLHhpdJft_kiEHgYnd9bNHxbx0DVr1V9zvSWUtu-QigEcyGPDoVNC651y4YAHWQ1JvTpygF'),('fe7d8a2637d2a0c12d891adf425f886c',1331871887,NULL,'672uM-ogIrsBoobQCrOFmqQgRCG5b9bxzoNAYY0jr48zLeIYFsfpNxqgaY5GJS0GU19Xs3x-oYRML7zcIsOwcyYhLyuXRWEfVvFb4Oe0R_x8FlL4WwjKUNvojZPFXa6WLfi2IJRK3eMQadQgxXOkQ6gj3C8d8Xgh-h3N0m0sLDkuGi0Hg35vnLBCwVBP-8TF_GEIoCgBbjynPrxNPbrOIw..'),('9d70eb46be06966dd8221a5b3c13217f',1331872018,NULL,'Ptg86nNTnCRps5I0kl_FLHxCQei306Fxmie6uxjg3WVJibvXUoCKOJ6JzT6t5aEwFdpmooXFJywvy1HWMGC_EkyEkwBuAketeS6vo-lyl0F7yVJvatt_ojkfoEwlM6swnRc7RouACzqs3S1r3qwbZDqwLk2Aw2JId6RYLBocZdzTjH1EugPoTUSERbJDj24uUXNBtkfs5cS-hGKtAVhDug..'),('95aa45986b3ef66aeebb46432b42650a',1331873211,NULL,'HQqhdwMLA05dYWstu-y5K8Z5cA2KVn464yq7VTUKIccM8NS-WM0tjJ1MufpaCRajj3ufw7cBzdrouGtq4FH0An7DeFy89q6Oa1Yw-241gAAD62-MrNEJPZQMJn11sb19-9WC-na-Wb1OHvZXx46ZWA..'),('7b3bbef4c102c280f3941414efb1aaa1',1331876532,NULL,'4xOysGrvQAykdKTCde1tfHLhwFsE8Qz3LvEvwiflEW637yAHef44CfEdPeP3BcIQuPKT0xqo39fa5mSSa1JfZhkx9TFXwLvyhTV_hqV0sX-v588aLOr3vKFzHHR2e7eQqnHti_1f6a0HrmqJBWeK2P8ufArs9rhnDd8a64RIZeo.'),('58f5d9edf26d6e28292909da1572f821',1331876534,NULL,'nmbw6Q6S09spf840nu5F90RXwypXONCtrHBnmfTB8ecsEgMLRswjDYIBC-pcWl3XO4qnlW_ZnaWHblLQD7h7OJgN7Jvljv5Z_JkJHscluJMzN4MG63LC7L_aCq-Vfpb_RsMHE1vmCLB81jdQiO-ry8k_Ds6_xi7eqXRfrNbI3TM.'),('28ee67f4c839cf2436f8ef27d8e48c48',1331879375,NULL,'wzukRTLtkdzdG-ZrbIPqjlTJw2ezc-00LwT3nouEbARbfIGwCVbD9wraXz5n5kOnG5XYfiZWshHXkIBsNyEc1k7nc7zQncTy9CKoxWLqslQYoQc9P88XkhciZh6hfsiTSTNrA7Lvf3x6mugpBhpMG9ItL1ZT3dcyVj0rZ5eu_drW-IEeMK0n8j-YJEPaecM7'),('dfdbfc01a1f6a3452a440006444a38a5',1331880113,NULL,'m0DxS1LwxyGiNZloJi6ZJcpKSbGQqg29Bpc2-cd9u6LV0vCmxwocCsCOOQe0UwcOvjL1O9VGgMW1WueG2MMOj_EHUfYhz1WoKGYE0JbXl5syyHOTUQJNXHZJpjobR3JLa1Rp0ZHPGGmw8NZQzs7RK46RaRol_BhHglN84HOA-lw.'),('d22ba963d33629449f9138ab9a47f45a',1331880115,NULL,'LVsY40dshTTlEACeq7oH0O_1c76MIU_kANd4qa1onFsFkh6MNBHFrmuU4raccbmAjszTUrdQO1F0pDisKlB6ZCrMP03zn6kbaIMuaDHWLfAGhSk0Fm6Nb6X3z1DKX4PlYK4A3OWEcBUKSMV9D_ilsp703A5HMRUI3pveLpJQoNk.'),('4b11b940b23ba016fc2f7d58bb604f98',1331880952,NULL,'vSv8yC46eKvWbyq0UFJaID8zxbEz7A5hgJDGf5eRtuhHvh5S59Ee6KKRt6z6d9TpTxygf0himLERTT1KmDPg5nUq8kJn5-RLk2Jv9pt3cEPchsmPPcwkw1vxSKdJN0ajhoHfqb68pdXfspEnaz3mFQ..'),('cbe3e2953d83f9e3703e06793d726ef1',1331882793,NULL,'uUueS5EIOOvOZY2mFpuNHAFGWBV2whEN0p9UidCQ1skOlsrDnccPM78Fc6gbwmkgc4bTylVfTqTRkU6YUFqFzhoWPv4LTHT6MFcY-WwaoH3YmCLx91OE7Y00UGjPLOiZRnrF8zywz3TGZX3OfCNVKPduZw5pMxByy_JeEsBNCkamAMGXEoQSwt1DcQjpiYVo'),('1b0a78ac0caf555b224c72d6766829f5',1331884085,NULL,'kfwHR6D_zDaafkjfRxxBwDwWW5H2NSPaA5RdsC7ARWPPBy4xyUm8por9YTkPtM1l3Zn9omuLM0kKqaQMoY5_Wg0nJo_UO6WqJ6edrgJcd5rUjGFLPyYDaQnc_tosRmzJtqBFb00Wwh4-m5dEFY-UNot43hnSopchlhAjEmamhvs.'),('467308b0996b173c0f34448b595fc13a',1331884102,NULL,'LVsY40dshTTlEACeq7oH0O_1c76MIU_kANd4qa1onFsFkh6MNBHFrmuU4raccbmAjszTUrdQO1F0pDisKlB6ZCrMP03zn6kbaIMuaDHWLfAGhSk0Fm6Nb6X3z1DKX4PlYK4A3OWEcBUKSMV9D_ilsp703A5HMRUI3pveLpJQoNk.'),('f512316aa92b74c96f1d93d76fc34eff',1331887572,NULL,'N1BHPK3NiZ0-zA_dTQUitT5W26f7BiNecmP-8yyySFQkUxiyr9uD5fqVN5lOmwdJ-4dCJWX4xP8lVIAbuEuRisJpfS8lg5e3Mg6NOJ4i3rRDFyolW2-HmXNkUDSUzTdGv4TPuAanH5vytOEijtVNpA..'),('e3484414b9987ad4d6ff7fce4032c3b4',1331887693,NULL,'d1PRe01bIwBLQ_keWmOzIIlueACJZrLtkyM5s6TbXQYx81aUzfXckhuufpymtS14RJ4m6hlKB0q_SoldCd8yEk7PjweLLdpca22TTSk3_ofJTCENSZSrA6BZLyUj1x1AhEIyAzfPigB_ZgKLyB1-usXOr-QRHzRoY4TrpxhK8ms.'),('8c928b75584136c0ca68cf17512cb037',1331887710,NULL,'nmbw6Q6S09spf840nu5F90RXwypXONCtrHBnmfTB8ecsEgMLRswjDYIBC-pcWl3XO4qnlW_ZnaWHblLQD7h7OJgN7Jvljv5Z_JkJHscluJMzN4MG63LC7L_aCq-Vfpb_RsMHE1vmCLB81jdQiO-ry8k_Ds6_xi7eqXRfrNbI3TM.'),('c362448f0aa8deb5f5dfc2f85400b998',1331888770,NULL,'igJFwJR0gjs0E65AiTBMgpLpvksK-rPPoNCJNres9O71CJfdnMwS7tnWyu8Tc32pL0hGV6T-FLerFcgzLiZlSZFE1ROcmxYTZfzGVHOrFgB_GuBUs1SBmCiZ5utG7jZ-ZCkcJABLQjOzxmgEI6Hdd-l1GhX8pK_5hyXC_ZDghXmcL0jIhskqzKm-Ck3gDCFU'),('c68f58e29082b7d6aff71068f6cda0a6',1331889498,NULL,'2WHvqPvsCt3FrmNOqTDCHEy3hiZ1uINLqX2yrdYjnFR3xgKDTc8ZXtbG9sE7IdDbm8v-T5bKbmImlvOLAtfeb5c2Jm9rvmgT52okRcA2zf0F1-FV9DRRslkDgWuTkaSReD8ZXuteBvS3KYDBl5qOede5mHTO7zTxEm6JQKI5egPJlVaDh119Jka4W0rncoyI'),('218a7a8b1d7c58743c856c80dbbc2b7a',1331891457,NULL,'kpQgJeQ8mRtln4T4z3g4Z7OOQOE9-afja2l9ElREqwwO_wzR0V3vacF9ZdBPcfMNVJovgAiz20rPlM8ImaSlDSFsNKfXsN5vt7cQM9mJc6bCqMHYuO_tOCB5Zr3gJ6Rhg8gQhIX4Y9FSHS1g3t5ZHZ0PdJ5_jLA6zRXMAMUYa8A.'),('792eef55d31b604cc528f5991bf34cf2',1331891465,NULL,'QSM9BtntDr_4_jpVoaKkdzlyJ3uDBpO84Kf9yR8G5YiOEjDq3DShs0z0gSBpsjnAALVKqTmLqqNpWIebcxkPaBsHFsN1CvlnQamc6e7gskoI4eMnZkir6JNu_obSX8U6QluQCPlZZX-hwl3swhVhU3K5teJ_feMXsc-x8DDVp7I.'),('00845ce092d0beda209c8c6ccfdb41e5',1331895231,NULL,'bfPKlgEOFY19LTp5jB0ejOnYWFnSmMWMJ_flv4IjMgwwFsWXJHxrT8tQFuVrkABUPAcqxQqaWhInwmyEb17lUaXjcpqwWac9lcYwhO0Yz5R32Z9AMVXdh87M2UDbRiW9nFLwlotugN4vNz-lBrAc3uivNh1SNB1dEQTV2uE3-Nax5pOGgJ4unZAYvX127d1p'),('9d51e03bd1587f4b7eaa3837cf92889a',1331895270,NULL,'Rdr0Qnvpm8h0m87kF_04RLbs4DKdB7E5Txd2SRZXFvZCjvBgYoiSLOtCSlWP0AZ4M-xzqf2Tsz5uTNThW93pzkxR6jydG0yzAucUCjSAPznD9gkExMIq-ofvkTySE7VE8w3wrhWVylXYqIRSMLOk3g..'),('335e8d286749765e387e344abe6e663a',1331895285,NULL,'kfwHR6D_zDaafkjfRxxBwDwWW5H2NSPaA5RdsC7ARWPPBy4xyUm8por9YTkPtM1l3Zn9omuLM0kKqaQMoY5_Wg0nJo_UO6WqJ6edrgJcd5rUjGFLPyYDaQnc_tosRmzJtqBFb00Wwh4-m5dEFY-UNot43hnSopchlhAjEmamhvs.'),('8c270180be722be6f218f8c528f0ff8c',1331895316,NULL,'81-sCs0JKfdMNId16RNh_kwlvbgC6Dbxs66mgj6kUP6t_gjuONgk5M25MEpWacWdskHVIZwKLSoljYM9XJHLKrZ8q1hN2TqjEWbehtwyNsL7EHBpdUINrzhW3nRO-xfhRUZ2VCiHv1IvRRVBUtCuWtZb46ktSmf9JFaEVjTG0pA.'),('7facd105039f237a91a0f781362809a1',1331897232,NULL,'N6L4u4kjkMjJQhK5erq0ZSz1oXycmBRKG8j4BLeuWbzBxwShgHIPNfkgWTusz2fUAhXI_gJ3ZmYUA1Z0a2AbW_KlCtGj0mnV82Nq6hkIBXs6TVx1foKCM7IBaokEw0UTz8o2dVDMpPZS-dEQCmI0_ii78jxz2jwyBdW7mAkB7yU.'),('13eaac4799f2994599e05c95d699a8f1',1331897264,NULL,'-BzF2D_xVsDgkfYiR9HmHfZDSKRLHuDtad1IXCDLEIm4qePFxxhX-iEdfb3YlfmR3hjdc1MlDDfqSNdEyaN9NMt1ffYUfZADbDEy1TZ3uGfH1eq2fvckEp-2Z-31KOqOWetv99Bg_IsUbvY9LxiXDC8lqSjYwdDoyacezA5PbXU.'),('4686b63474f9d4a7b0e08f7c5d63ba9f',1331898884,NULL,'VfyzdlIHih9VJQTQ3SdGRL12fchexQagj9kEWGQA7zZy_FsR3XmnDQWikK_7jfU3Yz4oqX5a0e0rSjXbiWmuWhO91KHtB73cRzb_g3ZuzJSuZjHmpFKJzTfBNLQdSFDZrAIR25vU1Zcib1VzumbvI-E8riItqwuSyH3vfInlgnw.'),('92000589b8eb67a6443a7c0fae7f00d0',1331898916,NULL,'U9tYPmduaTg_kt26OQHzeWeSyzMMI8-r9EEZtOkSsIxiEd4Vi9lJcgDHYibNDeE3AnSYk_whyUccmQ--kXLzr6nimX-FjV-7TFrjUX7o5_0rJHmXU5U8zc-J12pbvdGQewiVYl-IpuSwziSnRn9phv6ooE50re5xCNBgX_jPCGI.'),('5f3c8ad9c32d6ef9406e348faaade423',1331899800,NULL,'D4ILxjQKrUdWzZjYd0--qs5fxprJ1AazSrO1iIHGkPPAfoToYt7cpsYLrGK7YBpwdtWhVV9FMlEu6yqI9ie5c36WNhsY6u7VEiDy7C4hatPfC0qcpJLi4gb9yuSyNx_EfU00bB2RfZX4Ykh8vy1Kg5NWqTm3iwN1N33QfXWeP7hDbxMiAr7iNyO-Jyhx258m'),('283c4136ff76bb8cc05cd56c7694ebb6',1331901378,NULL,'1c-SxUdLvAppGd_S32Mpu4nH0PCsSGfH7zXBw4LStCIAuCD2Gd7qOoBojMFJividvQb71-URKkPL1OuZNlTV9ojk0yAAkXrIuAc6Oc7F69LQKiW6aBtuAU1ZO5SejHgpgYyoQwtPtqJD9scqg18DvSJ9uK0zX8SGykzMH1QIcp9YGlPeR5LDs88ALjqAjQMg'),('09595fde2fb65d8647d844690fe3c212',1331901749,NULL,'4xOysGrvQAykdKTCde1tfHLhwFsE8Qz3LvEvwiflEW637yAHef44CfEdPeP3BcIQuPKT0xqo39fa5mSSa1JfZhkx9TFXwLvyhTV_hqV0sX-v588aLOr3vKFzHHR2e7eQqnHti_1f6a0HrmqJBWeK2P8ufArs9rhnDd8a64RIZeo.'),('2438fc668a1969d220b9797cbb59a499',1331901751,NULL,'IgW4pBuw69I_mh5CpqfV3kkEHRoCI-NL8xMRDKlNUte7lZ5gYUrlNxFYynrfqouLx5-oOaVRREDlOPxfnIzYrV0mgKRGuMZZvKNgfacAU5WO2U8UDEE2IFFYf6fYlkD3GJb_bVpzYWjR0IWGZsP6tMUtLhMBJx0sGT3AJgFCLjU.'),('8b34b1f410dea7bc469275e51738ba83',1331902111,NULL,'pqRdGzB0EJldvoXcmM5SFjiXJnpw7U0s9EXlFWn931-bU1WOSm-sBU6Kt-nBof5c4x8e1HvKvJ3cm_RtpjNUHpDgfD9hcdg_lAYCp_YofCVEb9qfncwVR02r_m-W2ghIpWRshHKbjs0ZJ2uiW8EOZw..'),('8ee7d83066dd4e274f47295588f62cd8',1331905629,NULL,'OmTMLPldPSjTCDjKxr03V2I22tNJlorSsdIByamk-x3FOBjbIdaNYkvSWAM6qDXpSKeu-_8n7zRxgUMc3E2D5afhMeGAicguUFClEpSav9jrL2UdX1wEwtDYThsuHtuGP0iK4SCNZzL-iqo2CszHTfoa9u-b19yMf0SGr911SLE.'),('4db98ec57370ee06eb703c98df94416d',1331905646,NULL,'NM4VaCI7B3ncZxEZOx7DCEqLQmv45eAhntLn5Wn7l6tcykTI9Qhlkf711S5CFvmwwH90dpoWHHeTv8L6U_dWa8hpJ5zwNtVvbecOWngv4LJPj06G6Ca_RBwCK9RxdxQBnZRK3ADQkkZQF8rpsy4iLQZlDHAAf7NQZYsViK6R0gk.'),('8a41e96bc5d56d40f642c40062231f65',1331907291,NULL,'0hrZ1CGdRNAplB2nJag5hHq_H1MgfQiRaofadmkcRVJbryFLotY0IqbCLN2CYqq_NV1jHj782PKX1YTsUADozNhr9Lkyp-dgxUM4CkTD_H2YtT0DMN1L2BR6TZqFpGWLeH6UpeuUwOQpRquKBzDGqxFAUF650qSwReIFIDTAmMF3kEVlmUinv5L2IG4rvfU4'),('97925b186756c32a27e5a47a8c56c2c9',1331909200,NULL,'eWsxAqPri3BLprVhSHD9SvtOz2ryc9UWBYF80f8d6M21NdUNgSMXYQoM51Hgo6yBDDWIt-bGDuVdhVLxspGdUHa5IwON40zTaSzTMHm9-7dijp-XedXtbx2afeDMKV2K3KuGl2DE7mG5pUYBbpY1oUrVboTONzncp7GnjTrqdhM.'),('76f3b43708935904781bfe56b7bdf0df',1331909214,NULL,'luWWeRKvmeAcP4YpTqC_lwTyTxeiM6ntzFwDCJcSkD1f6pl4EUZrSzj_W0F3IKwdCG5LhuF2eSVz-raCVl1bEaU0qSS3U93UNqDYpIdCN_ElzhsQ8RL1PObuY5GVN_79oy4qHI7STZJehg5r6D_6hzifVtFt5jDTUha0MP4J7CI.'),('6148b89cefe1bf4200612a1d7b03e49c',1331909467,NULL,'r0hp_EwQLJjnBv28ZSKe_tO7IDm-QxTyGqGXSezkLEnZH-FS1CbijrD7WPfZwRxf75Dt-Q_pRq-4rB2ZCvEeLlAWy3gBWPtSkCtHDQ3B9MiSkyjS07UcRWuQv7wPRR2epVWUCxkcCnYS3ijsHfOx_Q..'),('278b77fe46c96b41cfd519ce13ede055',1331910605,NULL,'bD6Pa92qfu5HhxFLudaQAZyHv3YXgZsUtcYZTGN1-eOMWZYIMVadKZjs-6CDYRGmgh7R29b-0mIWPcpbkGPc-LX5UT6s92T5N0IZSItOzZkhQER8UdtL11mMpbLCm3BIM_V3lgXuQs9I2ONhK3HLxg..'),('06236a84c69255a57148c7d6b1c85cb2',1331910835,NULL,'67wwQ-1UkWMim1J-OpGKe2ol1nvbhn7ZgQtyjoUb4m5Cy4eWSIh5vWuu447-mMOjW3hY1EGE459f2xhHH-QYy-U1f6-RirNeO7OBMm5nQTv_lRrhp7VHw1ey-w-TDd6fn638ihBmewhfZT7hMhKOm-IsRU4TKmPxBG_xETC_bk9rFEKzkWAyU6MzG2fqEBkO'),('044ac3dc7462b6ee040bf021bde24f04',1331911044,NULL,'Vt2SFftqoncKgy38ZWxuP1T86Qaket8QoZcbqnI-IT3t9p6FsbrMiAzkmytLp22_eEa4otFZ-bPKRZ6AQaHJ0GbPI-ESp6WpNSVmZe61upZDlm9TsD0P1Dzfc5Xwb3X5FPZirYec5Gy53UVUKAiOXELhvn3k_RMCAJiLLnp1_bI.'),('5e8eb0a5e3231c8cd51f7ea9abb401ef',1331911044,NULL,'Vt2SFftqoncKgy38ZWxuP1T86Qaket8QoZcbqnI-IT3t9p6FsbrMiAzkmytLp22_eEa4otFZ-bPKRZ6AQaHJ0GbPI-ESp6WpNSVmZe61upZDlm9TsD0P1Dzfc5Xwb3X5FPZirYec5Gy53UVUKAiOXELhvn3k_RMCAJiLLnp1_bI.'),('d06582df953db84ca2c03a0113383f30',1331911044,NULL,'Vt2SFftqoncKgy38ZWxuP1T86Qaket8QoZcbqnI-IT3t9p6FsbrMiAzkmytLp22_eEa4otFZ-bPKRZ6AQaHJ0GbPI-ESp6WpNSVmZe61upZDlm9TsD0P1Dzfc5Xwb3X5FPZirYec5Gy53UVUKAiOXELhvn3k_RMCAJiLLnp1_bI.'),('58d0f63f2569c5e75a0474b5916579ce',1331912704,NULL,'fS8MhAOUHT0ZDCh-JRzGRDP3wcuBwjj_xfkCAp4IOZLNWKVFEWq_znRCztT_VsUKvGZEYcnsEWLQ9ZUpAQvVRiP9RYo3pmUyXMNwQYA1uD7zAlEwAg8ZplGa3NUNLLI8UBFDryGzJx-97RsWn4eWUYNV312Ef8tQqF0w96GaPJc.'),('bc623ad15e3e15a582d9a5d7ee994f61',1331912713,NULL,'Rm8l_DPc3xir4gsm7LzVlmd9nvHfqZmKL6dIt1upzvVviONBafa7H0UkcKVInK8ew6EYNXZZdcjtmyDAdUP5lbCZwjUaTcbLWgTKozgaySFm9tYqAb9k_ycV0KT5anyNFtQvUfDzvU8X9Slqgf1XxP1BpD2m_RlUiFNA2c7kTRI.'),('413fb2cf8cead6a1bce0f1ad47d298cf',1331915403,NULL,'O1OtjwdCgcoI4m1EGK6RjQJI_Ob8eMlIQakt3-Mc4rTVWd9sHNbm63lCCnCbps1aTCutelYFmkyeEgJrFQKCccqRMEFv4DPcqpGUhAxwh7i7KF3-dx4pn3Xo5HVElBrwTsqiTPWrpr2-VWUIlY4vQA..'),('8aa6eed93b17a84b03ec8347e112b897',1331916744,NULL,'a327VW1Wa_m3wOMmY3R21dll8ak47HneHui0BvrMeRACYL6IKBUiO6yAJlUE0VKNHMwMmZ_LkswVIOKsM-Luz_Olc6U19bgG3OLW7YfFft8AODrs1Ckzdsb1MMWeDWVsuzyt8SO15Jz1wfzOvA4FzgEkL2qMA4H1RMYPLZV7AC4.'),('859cc44036054078fff81a0cad0804f7',1331916759,NULL,'Gt0pxUGyVbpQzAbwgOudGT3XYBokysfF6hIuCoGEmfExs3KZkRgf8rxg2Msz1lLl1ME3n26Wi9b9re_GfAq7pljlJ4NeK9JyCNEpTnLA1m-MOTdEm6N6pkTYPEWX9_D-uH5BBqv9HK00iBS1VFy4a3TzvyGoQqfZwH2ycVFgAKU.'),('cadc0f86b97c3ea409a1e851749cfd7b',1331916860,NULL,'RD_g981ZoHKu7ct4g7zNvbNRjM49cCijV7a_vdYRaI05aeGiHOSjDM6K-QObOPIaNAXyC00-VFXJwWyprldIb5_Lv89bHuvEx1ZNYl6uNnkqrlOTwG_xZdPF3lLPSsX36EdjiyvJYvQjTJpufcQR5A..'),('4ad3ef681e378dcbf0f9fa71d27f0cd7',1331920063,NULL,'SG-edC7xOqubintUaJz15uV39eHiw9EwUKHVEvDpPCjZSzZyPaz-Np3PHtTYtAWMkwojPTdOOH4s6VoxOjVX1CqY2s2pjSqYBebQ1tHPiUC1pVsYop_VuX_VOkbj4p6WhjUIZO-K7o-R2HbbTDGgoA..'),('71d036268a7c16b3d6a44f64293156c6',1331920503,NULL,'rToa7fE4Kj0w1rnXrdAur2YDrxTeyXDc9f1Xy3FKwizVSr0VHxrDL2RgMZ_P82yqWVIBWg8rGIYuz8ni-N9l7uK-sc6zVLtvhAEy0oKlmsZHTMip8JoofKoaA-_8HiaKmuZ_7L9VCmJbM6x-ttZBwQl1U_Yr6zfJdRx0Qz50phA.'),('b003089e132921a8272017a3e0a95e1c',1331920520,NULL,'jjHbrxBGlqNR7Tg98EG-remzQonEW3Y6yVhixuGRqKGaLM1_6eYT1ljJO8kLd_XNsNz_Ca5FvDcnjzO8WlG5QuhzJ41dd_izCpZtSK-tbSkOwkdo4YNTC6HsDO76WjTDLTJGqJrSvEvI1tx-mfzVVG_rObTfoBRseDVEW6J5PxQ.'),('b99f23c0d87ac22f7a888ea0f27e0938',1331923969,NULL,'BwyPg5VSRetvy5qP9oAu0ciAhQQHJpaJ_4RB4WAIqlrkEtKNGBQTpLW5Jor7JLOyhUpOZKaMAlDItdlpyav8ufe_BXbF0FuCJiE8x8A6laETljSw--GYVLR0Uyax2Kip6BZ77WAG0duwgjb3eNdE94TFve_fB0uK78-Qmk4gMSY.'),('41d6e653e5cab4ba4e15f6ec83a3972a',1331923987,NULL,'QSM9BtntDr_4_jpVoaKkdzlyJ3uDBpO84Kf9yR8G5YiOEjDq3DShs0z0gSBpsjnAALVKqTmLqqNpWIebcxkPaBsHFsN1CvlnQamc6e7gskoI4eMnZkir6JNu_obSX8U6QluQCPlZZX-hwl3swhVhU3K5teJ_feMXsc-x8DDVp7I.'),('4b45e515f0ff78e068a45cc71d59380e',1331924122,NULL,'_b6J2Z_sto9bttr4uGKwY7nRFl0cFDRekv4h4AqziCqKKVUioxHgJ9hBzOmzxAqBskGGQR0doOfVJnm1ub6FHc727YmRAjvPLX_JFNN915t0vgCu99sspkYNSUzkNj4uLhQPlMMoaFE-JJMOc1H9aQ..'),('3816392dc79d018b75c83acec408c470',1331927296,NULL,'OmTMLPldPSjTCDjKxr03V2I22tNJlorSsdIByamk-x3FOBjbIdaNYkvSWAM6qDXpSKeu-_8n7zRxgUMc3E2D5afhMeGAicguUFClEpSav9jrL2UdX1wEwtDYThsuHtuGP0iK4SCNZzL-iqo2CszHTfoa9u-b19yMf0SGr911SLE.'),('00a5d9ab77b7f386eed07a5d6d88789e',1331927312,NULL,'NM4VaCI7B3ncZxEZOx7DCEqLQmv45eAhntLn5Wn7l6tcykTI9Qhlkf711S5CFvmwwH90dpoWHHeTv8L6U_dWa8hpJ5zwNtVvbecOWngv4LJPj06G6Ca_RBwCK9RxdxQBnZRK3ADQkkZQF8rpsy4iLQZlDHAAf7NQZYsViK6R0gk.'),('516889d2e7004c792eaf551b0f0230b8',1331929622,NULL,'xWuOoPIzvLkCq1wcAnD43sIhhsz0pKtVxFj8mpS-Nc7FkDhq7nkyBRNeKd4AKQSG80su9U6ERlS9kBpwyCB5ne3tUQOI891qAJM0hlHawQyFzIblYOjd12jKDHFgX-ikmvls964Cm7EKDNIWuR-gY2zAH9-7Ms7QFS94meJJ_2UdimDs4J599WiY_FQftWsH'),('cd1d10b1982fec2cfacc18098003fca9',1331930790,NULL,'-cbn0cT1GKcp6gxYVcG0OsSiwXlT2cbYjTI-w2obEjDvprbGZ-GDSdC0GQSaPeJt3gyfcBZDSK1CKAfqNl5ZRg6pJsvMbgWpc5aG6RtEG5tPbzEfrxlia2fpQWqeteCRFm1_KukZ9TllyURcRpTKcQ..'),('4a07cdfca584a5fed3cfab34477cbafa',1331930920,NULL,'kpQgJeQ8mRtln4T4z3g4Z7OOQOE9-afja2l9ElREqwwO_wzR0V3vacF9ZdBPcfMNVJovgAiz20rPlM8ImaSlDSFsNKfXsN5vt7cQM9mJc6bCqMHYuO_tOCB5Zr3gJ6Rhg8gQhIX4Y9FSHS1g3t5ZHZ0PdJ5_jLA6zRXMAMUYa8A.'),('6cdb165d320e406b199045d5bb392b68',1331930937,NULL,'1_U8A-Vi4o8l7-I5tPUBl4FEFuJZTKRbt1sUMq2GNdSvidJmuSC3bI8wYgBkUqsD9y2B1mIXcxgzDmWYEXaRsmmCOm6xRm2F0Dkezr1ES2xHeHVGAAJ1qK1ees7H4YBVlVJPaU1z323iUzCBJH3a3ZmLRN553mBdoNpSF-JeqbY.'),('4ce09e70a6b11f9b266b57a8dcbe4ed8',1331934199,NULL,'hR52d9fxzSIIXwmkwqMb3ZS3-8FVIHOCJLrHy8sQ9dyKFmztR-qJZYxaVOqCdQsfKqO_2QmsD_CRMxyT_UkR3hwtR6ln4lydzuf7g8DalEtWsh_xd4q_cIWvx0MCE0HlGBehufI672CUoOTuSeHrkCgkJkmqHdVtVxjQPSZ-9js.'),('cdb645936adfd2f86794b0737a5c5f0f',1331934204,NULL,'81-sCs0JKfdMNId16RNh_kwlvbgC6Dbxs66mgj6kUP6t_gjuONgk5M25MEpWacWdskHVIZwKLSoljYM9XJHLKrZ8q1hN2TqjEWbehtwyNsL7EHBpdUINrzhW3nRO-xfhRUZ2VCiHv1IvRRVBUtCuWtZb46ktSmf9JFaEVjTG0pA.'),('df5e1fbcb63dcc14a583e0a11c4e2e4d',1331934372,NULL,'wIqmR0K3tQFDCbeM_DZZ_pi8NcTFlXdljS3YEweES1d8RfVzHAOLl90-o6AzHzjyDfrvMn1w-rpPzkZsKFlRIg4EjuDtZ9osJl06mApTzMdqhbPnXeP25bbs0rTQDy2Qno2_qh9o0HFF6yc6t91eVZJTZ1XUXdk91rNufRFC2wRlvfz6N1-0-u066pz9XrZz'),('820c622d0afe8794b862883a1108d873',1331937743,NULL,'4xOysGrvQAykdKTCde1tfHLhwFsE8Qz3LvEvwiflEW637yAHef44CfEdPeP3BcIQuPKT0xqo39fa5mSSa1JfZhkx9TFXwLvyhTV_hqV0sX-v588aLOr3vKFzHHR2e7eQqnHti_1f6a0HrmqJBWeK2P8ufArs9rhnDd8a64RIZeo.'),('d10c934030a0f02842dca299fea9adcd',1331937747,NULL,'tcnPGqP2pMprPslbtU-TyRVSW-JDDkiKap1kCd0lDxwjNpKnMY5d-4whEABAalDuChJADzIFz4mOv-l2Z2j4yL6v0urBfr6-FmazGYBuFygFEM-bw2OYCB8lt8WBqa6iWxQ-Esg7Q4_4R3_FTAi-y0gN8f1tQxzK2kyN0igNadA.'),('fbc44072bd468790b5bbcb9e6030bce8',1331938429,NULL,'05Pm8HlDcjVgssOCXdR0sRHYZ1y6lrfvq9r4EEmoUF6-zbYz4ApUL2fQro1rtRR938ZYVihxgS261vcN5hhahL50skWu9rH5EIDzXGhFHU4FQUwc6naRYok0WZU6uFDInYLAVBRXw_epQ_BqYZEe3g..'),('71efcd2a4464000125ec3dffba0f2fec',1331939140,NULL,'bP3lUUVK0a0lAJ8Vrd4FJEm7-YAZKV-B8KL9cCHqtCPPHzdseEhlPYYstHa4Y65Bg8zYjo6F-CTfikot3x4kYMjlmFwFWOpMUAuChtuIljoRo1ggdgxrDRvZuXAnX0teAFC430fINrq14X73Qrt_xqxeMDnF05vSIxAu4XegbCXsoxJoHz4HNGoLOFB2Bvvu'),('aca268fee676be23e1c9d9829284d0ec',1331941941,NULL,'hR52d9fxzSIIXwmkwqMb3ZS3-8FVIHOCJLrHy8sQ9dyKFmztR-qJZYxaVOqCdQsfKqO_2QmsD_CRMxyT_UkR3hwtR6ln4lydzuf7g8DalEtWsh_xd4q_cIWvx0MCE0HlGBehufI672CUoOTuSeHrkCgkJkmqHdVtVxjQPSZ-9js.'),('e18149107f63a6b3fe14c41dfef9182b',1331941972,NULL,'1_U8A-Vi4o8l7-I5tPUBl4FEFuJZTKRbt1sUMq2GNdSvidJmuSC3bI8wYgBkUqsD9y2B1mIXcxgzDmWYEXaRsmmCOm6xRm2F0Dkezr1ES2xHeHVGAAJ1qK1ees7H4YBVlVJPaU1z323iUzCBJH3a3ZmLRN553mBdoNpSF-JeqbY.'),('16b9b0cbe3606049a07935d8fc6113bc',1331943902,NULL,'GTUNQV9dTp4Q2LZj34gLi3Cnl1NqJoQTn0veOyQkviUyo3e_UVow_ixtiPMHx7t2sQJ8GNgCyuqVYHo8QRC1a4d0cZq6P366U7CtwSSpdsB_T43TWRLECMNBkVWFlcvmqsu1PPF9N8XiIQ2kJapFTSiFCsABPa15kVg3EML3G-Ewu2CCZTsghV--WUqhKZXU'),('21a542ac845a054498472f96e70950b4',1331944305,NULL,'CpI3pCwYt-qKQ50L5SKs4p4H5cqpLvdIPtjqvmbOOaeUGgmQnsvvmJ1ZWJ0Crx8hBq-4UppRYih3jsUR2zyQ_kuoWNxPTmQvE7gZ2pU-R7YU5UtMkegWTOY3Zv-aE284ga01d8aAN7FGl3B4n1q_zRWHrEVQ9BrRI_MaA5DCqkj9bFp5pIsEwJ0DOj2ZKYHP'),('19b8cf68fe619c3449dcbb7e3c63dfce',1331944876,NULL,'5wEutDCtiBPEFszPSl0xE2ApelbgbBhbew68-Q6AOC8g4OyVffWaGwPus8lA11kge7LdwQ82q-HlzHqrAYxJ1TqViVwXq_R1572esr4KvEmeTZcEm79RAVjlWoN3-v7m9CYFkyXpsd82Fo42oZQGxZfuzXxFjbnmQnIinwEh6CU.'),('ffb5ff484909f1d564c6118b4c6af540',1331944877,NULL,'tcnPGqP2pMprPslbtU-TyRVSW-JDDkiKap1kCd0lDxwjNpKnMY5d-4whEABAalDuChJADzIFz4mOv-l2Z2j4yL6v0urBfr6-FmazGYBuFygFEM-bw2OYCB8lt8WBqa6iWxQ-Esg7Q4_4R3_FTAi-y0gN8f1tQxzK2kyN0igNadA.'),('68db31e4b458811083e0509378507a44',1331945273,NULL,'_b6J2Z_sto9bttr4uGKwY7nRFl0cFDRekv4h4AqziCqKKVUioxHgJ9hBzOmzxAqBskGGQR0doOfVJnm1ub6FHc727YmRAjvPLX_JFNN915t0vgCu99sspkYNSUzkNj4uLhQPlMMoaFE-JJMOc1H9aQ..'),('befed0566acca382e23ced96babef047',1331948478,NULL,'89F0NWTekWRjqVhb-aZ_AIvQgD0jskqdhcw4DO1edMZI7dHNliABd6jElsS7hJTgvQ4Gu6Y3VHE3ocvKJAoRDQVDbck0687XWXXFD9ydQzGgOJzHcJBU5wgSS_QmhcZ8HsZwHIYH07z5f5ox_ZyHZj9vXQGw_KgnKT5MPeK7hv1eCLuIh9e5oUt1rAwDeB5T'),('38ce004ce96ab723a3efc9be2a8842c2',1331949303,NULL,'dmtp-vMV3eEnpBQvd0GKqF3kYHq4FLiXj2-9MQIfhXVwonMpjdBuxp9eJVI4TU4kTpQ69DkfP2O5cxltKcDTzP15kLPjgJi8lQD6820RQ3r6D3GHXCUJj_519IKmu5o48TcPhja4-egClPKz6t70-Dk4TkVc_GjUyke0Unx-YJM.'),('55e5026e981a825913c3804cabdec054',1331949876,NULL,'iVK0NDgucoMZmsKfTqP43WcSetjYqWqPplCgTwGeCv2UwNpdJdvh61-WhWhs8-bVn5vqc0_TCLzcBN5hcbpYJHOSjdP-YjVQmxPAVFq8_8dOWjdsFQ8KKYVxC99kuSD1jz4u8i9wArYUPoS_QDsABw..'),('5a28bd63f6ae375d777ef855670323e0',1331952447,NULL,'hR52d9fxzSIIXwmkwqMb3ZS3-8FVIHOCJLrHy8sQ9dyKFmztR-qJZYxaVOqCdQsfKqO_2QmsD_CRMxyT_UkR3hwtR6ln4lydzuf7g8DalEtWsh_xd4q_cIWvx0MCE0HlGBehufI672CUoOTuSeHrkCgkJkmqHdVtVxjQPSZ-9js.'),('62e3c10977e44a647b221bb46c81d36e',1331952460,NULL,'QSM9BtntDr_4_jpVoaKkdzlyJ3uDBpO84Kf9yR8G5YiOEjDq3DShs0z0gSBpsjnAALVKqTmLqqNpWIebcxkPaBsHFsN1CvlnQamc6e7gskoI4eMnZkir6JNu_obSX8U6QluQCPlZZX-hwl3swhVhU3K5teJ_feMXsc-x8DDVp7I.'),('925fd1cec4d56c68967e6336b5931218',1331952742,NULL,'JOhBXPZoyVJPsQOYm9mHExIbKh7D2pBiqjTEvL56k1d8Vp7WHRCukhEjcJXXKOIK4N4RQKV6_fSywDSNV42sd10Txx930wvm67YlBEUINj_45hs8wBWSIS_W3Nvuo9Xj_RlBp9KrRWpHUIVeGEhkOQ..'),('fcb9fac8b30d0e9dfbf306ab9615fc22',1331955484,NULL,'sfXrZjyQR1NhCTKkAj_KgRWGg63hPgt_b3b-J-14NWSY5Sk24Z_CQPvm3bfb-FWNoML3IRKdLWiKFaiphWIcINA9f0F514xgfm-B_o67bL7GUMKncbNXRPgMpqY52mul8ndQZhJ7qWitmwTTR6FCIlNaOpyjdx31RicqF6y5Udxi0xwNr3-BshGKDfOGlKNpBKNj7UWJMRSvBnYrpM4g5A..'),('c4dbb29cae091752dfce345b611d6678',1331955863,NULL,'L78efNDYdIkBX01za8VCiqfDaWfrLR190BR5C73HypQOVVHMyDZ8pXyF-wQJag-rjroIFavhHyJNZWTFobhVXUVkNYV4I9wE5c9YAygFS6NMOJCkJ1dyEbUa8VhIls0GKpi3wWd4somU7aSK6GxKeTbFamG5K9j_0heDVuWCeA4.'),('b04d716439fe79e7b36a04b16ecbf38a',1331955870,NULL,'Rm8l_DPc3xir4gsm7LzVlmd9nvHfqZmKL6dIt1upzvVviONBafa7H0UkcKVInK8ew6EYNXZZdcjtmyDAdUP5lbCZwjUaTcbLWgTKozgaySFm9tYqAb9k_ycV0KT5anyNFtQvUfDzvU8X9Slqgf1XxP1BpD2m_RlUiFNA2c7kTRI.'),('29f93a05c2aaafda26bcefa76c4717a5',1331959395,NULL,'kpQgJeQ8mRtln4T4z3g4Z7OOQOE9-afja2l9ElREqwwO_wzR0V3vacF9ZdBPcfMNVJovgAiz20rPlM8ImaSlDSFsNKfXsN5vt7cQM9mJc6bCqMHYuO_tOCB5Zr3gJ6Rhg8gQhIX4Y9FSHS1g3t5ZHZ0PdJ5_jLA6zRXMAMUYa8A.'),('68e96ee11c3c2fda5cca4a89edb34940',1331959401,NULL,'XE3NU9hb7Zju-507TJv5sCch_Vt9arXjAxdong5nLVAYlqYKQP5FaR369oRghhjw79Tl-7wLI8GmJwlPDKgY6l-KdqAgzQf0xZAxsblCF0kwUr5vhylHpXz6o7uaFGXn3IBf7bZ0Y0pjKhFqICXIqPV6kfS4Sj9RJUIWkXjv4CE.'),('9249524ba09fd7a74bd416c349d55ba4',1331959611,NULL,'78Z1IOWI2Y9KcIqif5B8LfdYQkj7GFhAXvA7SOxeA2_TXLfSEdV8-QGtg018EH3emKaAGLi9uSalhTnUBrzISJmxQyh87-x-DRV5C3g_id139hLlacA439Pg0Q0gq99ci8u3JA1_MwZmp2SOTQ7-PQ..'),('0771c84e4bea7c6049bcf86c40b37adf',1331960435,NULL,'H5yBvOyY5OD25oBqsWrX3lYIiC9QY5YiTlXyOrPvIcmd8pqq9WTjgORDJAkMsaI_rgQTvfvAeT_HhRMUsikBQNwiOegPBQAj3_qTmt6obfZcY64LO_7ptYBLKRHObqmeH3aKP-iLGDJcIVfBCwYs_cuZ7cYvLFCJC6B2KNXfgsljc8nI8z6woNV4EdQqiLGR'),('cbacf850457a760366b2ead88b51c9c9',1331960683,NULL,'lYwU80SuoLspGdSCJWDCCjsCh9qcQgHcY95jV93DEZfb4Sg2zG1EiF5ymA825lHppNxjdvu5NWx4tXNWbe0FO2S0yt5bM16QqTKpkBgepa7p6LaHGUlYP9ReM2kTs5IqafCWjsLrWx0oMojNN02KeMtXUDCFYjS1TiiYiuGgrec.'),('1c65a5340039cba8229250cd8d6ac7d0',1331963499,NULL,'m0DxS1LwxyGiNZloJi6ZJcpKSbGQqg29Bpc2-cd9u6LV0vCmxwocCsCOOQe0UwcOvjL1O9VGgMW1WueG2MMOj_EHUfYhz1WoKGYE0JbXl5syyHOTUQJNXHZJpjobR3JLa1Rp0ZHPGGmw8NZQzs7RK46RaRol_BhHglN84HOA-lw.'),('e46d98a4e5a65939dc846ad1a8cf24d2',1331963525,NULL,'NM4VaCI7B3ncZxEZOx7DCEqLQmv45eAhntLn5Wn7l6tcykTI9Qhlkf711S5CFvmwwH90dpoWHHeTv8L6U_dWa8hpJ5zwNtVvbecOWngv4LJPj06G6Ca_RBwCK9RxdxQBnZRK3ADQkkZQF8rpsy4iLQZlDHAAf7NQZYsViK6R0gk.'),('368a2903e40ca3aa18083bf6c78562e0',1331965135,NULL,'AG-xuvLIKJiSunhsVdB2IBTWprDw9Qbr82gYTvwLx_tXrpY5LZCqf7e9AxvtHAJw2WEefDRYBJRnbu1fhxI9RGlUHiseO-BIcsu28Iy3BXWHiNPWcGmjVIG37kOkvaaap-j5_EIygryfo4LV55a-X0CiNO_2ouVfAJuVsARU79SygTR5O3hdewT3zCPofaiY'),('dd0d86a7d7e09430a3d14ef66cba4c0c',1331966635,NULL,'bcr4FqthU8jvOTtb_UUwhiz5athXGTCj4WXy0pq0wNJsVLx-uvVtIMC1B0tLuK2tYLR0mU1McBn6aFi_TYFPolkamLPLiciwJcWQxYwjN1pNTxt8ShPePlZdDnaS8_FK-8z-Qz2-Vs54JIA2HTLwT-hNz2SCN-0l21e6mA15JF4.'),('0c3cfb148ea4089ae17e62cef06d27d1',1331966637,NULL,'nmbw6Q6S09spf840nu5F90RXwypXONCtrHBnmfTB8ecsEgMLRswjDYIBC-pcWl3XO4qnlW_ZnaWHblLQD7h7OJgN7Jvljv5Z_JkJHscluJMzN4MG63LC7L_aCq-Vfpb_RsMHE1vmCLB81jdQiO-ry8k_Ds6_xi7eqXRfrNbI3TM.'),('770124c5756dd17e64c6c0a597eda83f',1331967354,NULL,'RD_g981ZoHKu7ct4g7zNvbNRjM49cCijV7a_vdYRaI05aeGiHOSjDM6K-QObOPIaNAXyC00-VFXJwWyprldIb5_Lv89bHuvEx1ZNYl6uNnkqrlOTwG_xZdPF3lLPSsX36EdjiyvJYvQjTJpufcQR5A..'),('6ced089cc3ef3ddecc55f4f5a731b324',1331970495,NULL,'PmBw1mbvry-jXiQkmXDbjBNwIEUFyQV8K723bAjqa4-Ni2J2cP6_7HGHYLlJd-JfoPVeKdMllLkFHElDTGLqdfBP1RlZ-X-8zsh0MiZgjnn9QNKN_ZjxBpkAIXblDX8BDhAn_jXWoN9AIDpfSpYdm-JRU77TPU_d50iK1r86Y3w.'),('eb36be2191f06ddeb7d5f1c55891fa85',1331970511,NULL,'nPXsFUNEBEe4ys7L3LeTjKnreIShE6tDFxivPBjNlxfvtJ5Xow_qmva7gTaJGugVGkFZ_CDh49C9jQvMrrZnmGwWwlMg2YsyJ4mEv6bSuoPEwyN5xf6zGrcBUmduylfugiWcyyulDDaMbwSI_8GGFEccKmw90TJZeKjBkVtAdb8.');

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_users` VALUES ('admin','c3895d9ffdd78f728c35ab2c3558628d','Administrator','russell.fiegel@gmail.com','2012-01-18','1','',0,'','','','','','','',''),('aangeliascott','ed65879477403baad10748a88a17326b','','aangeliascott@gmail.com','2012-03-13','1','9245',2,'http://','','','','','','',''),('1simonpeterson1','56fa861e6605dd8f0116fe66ac20705b','','1simonpeterson1@gmail.com','2012-03-13','1','3074',2,'http://','','','','','','','');

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

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

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



