--
-- Host: premiumfaves.com    Database: premiumf_indexu
-- ------------------------------------------------------


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

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

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


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

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

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

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

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

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

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


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

CREATE TABLE `idx_badwords` (
  `word` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts & Music','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Auto Industry','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Economy & Business','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Careers & Job Search','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Clothing Accessories','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Communications Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Computer Services','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Building & Construction','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Educational Resources','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment & Recruitment Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gifts & Flowers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Resources','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Medical & Health','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Management ','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning, Heating & Ventilating','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Family ,Home & Garden','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement & Interiors','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Restaurants','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Agents and Companies','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers & Judges','','folder.gif','','1',6,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle , Dating & Relationships ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine & Hospitals ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Finance & Investment Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News & Magazines','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Development','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Energy & Science ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO ,SMO & PPC','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping and Retail','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Recreation & Sports','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transport & Moving Services ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel Industry','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Wedding & Events','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Arts & Music','<a href=\"http://premiumfaves.com/arts-music/\" name=\"cat_1\" style=\"\">Arts & Music</a>',';0;'),(2,'Auto Industry','<a href=\"http://premiumfaves.com/auto-industry/\" name=\"cat_2\" style=\"\">Auto Industry</a>',';0;'),(3,'Economy & Business','<a href=\"http://premiumfaves.com/economy-business/\" name=\"cat_3\" style=\"\">Economy & Business</a>',';0;'),(4,'Careers & Job Search','<a href=\"http://premiumfaves.com/careers-job-search/\" name=\"cat_4\" style=\"\">Careers & Job Search</a>',';0;'),(5,'Clothing Accessories','<a href=\"http://premiumfaves.com/clothing-accessories/\" name=\"cat_5\" style=\"\">Clothing Accessories</a>',';0;'),(6,'Communications Services','<a href=\"http://premiumfaves.com/communications-services/\" name=\"cat_6\" style=\"\">Communications Services</a>',';0;'),(7,'Computer Services','<a href=\"http://premiumfaves.com/computer-services/\" name=\"cat_7\" style=\"\">Computer Services</a>',';0;'),(8,'Building & Construction','<a href=\"http://premiumfaves.com/building-construction/\" name=\"cat_8\" style=\"\">Building & Construction</a>',';0;'),(9,'Dental','<a href=\"http://premiumfaves.com/dental/\" name=\"cat_9\" style=\"\">Dental</a>',';0;'),(10,'Educational Resources','<a href=\"http://premiumfaves.com/educational-resources/\" name=\"cat_10\" style=\"\">Educational Resources</a>',';0;'),(11,'Employment & Recruitment Services','<a href=\"http://premiumfaves.com/employment-recruitment-services/\" name=\"cat_11\" style=\"\">Employment & Recruitment Services</a>',';0;'),(12,'Gifts & Flowers','<a href=\"http://premiumfaves.com/gifts-flowers/\" name=\"cat_12\" style=\"\">Gifts & Flowers</a>',';0;'),(13,'Hardware & Software Resources','<a href=\"http://premiumfaves.com/hardware-software-resources/\" name=\"cat_13\" style=\"\">Hardware & Software Resources</a>',';0;'),(14,'Medical & Health','<a href=\"http://premiumfaves.com/medical-health/\" name=\"cat_14\" style=\"\">Medical & Health</a>',';0;'),(15,'Healthcare Management ','<a href=\"http://premiumfaves.com/healthcare-management/\" name=\"cat_15\" style=\"\">Healthcare Management </a>',';0;'),(16,'Air Conditioning, Heating & Ventilating','<a href=\"http://premiumfaves.com/air-conditioning-heating-ventilating/\" name=\"cat_16\" style=\"\">Air Conditioning, Heating & Ventilating</a>',';0;'),(17,'Family ,Home & Garden','<a href=\"http://premiumfaves.com/family-home-garden/\" name=\"cat_17\" style=\"\">Family ,Home & Garden</a>',';0;'),(18,'Home Improvement & Interiors','<a href=\"http://premiumfaves.com/home-improvement-interiors/\" name=\"cat_18\" style=\"\">Home Improvement & Interiors</a>',';0;'),(19,'Hotels & Restaurants','<a href=\"http://premiumfaves.com/hotels-restaurants/\" name=\"cat_19\" style=\"\">Hotels & Restaurants</a>',';0;'),(20,'Insurance Agents and Companies','<a href=\"http://premiumfaves.com/insurance-agents-and-companies/\" name=\"cat_20\" style=\"\">Insurance Agents and Companies</a>',';0;'),(21,'Law','<a href=\"http://premiumfaves.com/law/\" name=\"cat_21\" style=\"\">Law</a>',';0;'),(22,'Lawyers & Judges','<a href=\"http://premiumfaves.com/lawyers-judges/\" name=\"cat_22\" style=\"\">Lawyers & Judges</a>',';0;'),(23,'Lifestyle , Dating & Relationships ','<a href=\"http://premiumfaves.com/lifestyle-dating-relationships/\" name=\"cat_23\" style=\"\">Lifestyle , Dating & Relationships </a>',';0;'),(24,'Medicine & Hospitals ','<a href=\"http://premiumfaves.com/medicine-hospitals/\" name=\"cat_24\" style=\"\">Medicine & Hospitals </a>',';0;'),(25,'Finance & Investment Services','<a href=\"http://premiumfaves.com/finance-investment-services/\" name=\"cat_25\" style=\"\">Finance & Investment Services</a>',';0;'),(26,'News & Magazines','<a href=\"http://premiumfaves.com/news-magazines/\" name=\"cat_26\" style=\"\">News & Magazines</a>',';0;'),(27,'Plumbing Services','<a href=\"http://premiumfaves.com/plumbing-services/\" name=\"cat_27\" style=\"\">Plumbing Services</a>',';0;'),(28,'Real Estate Development','<a href=\"http://premiumfaves.com/real-estate-development/\" name=\"cat_28\" style=\"\">Real Estate Development</a>',';0;'),(29,'Energy & Science ','<a href=\"http://premiumfaves.com/energy-science/\" name=\"cat_29\" style=\"\">Energy & Science </a>',';0;'),(30,'SEO ,SMO & PPC','<a href=\"http://premiumfaves.com/seo-smo-ppc/\" name=\"cat_30\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(31,'Shopping and Retail','<a href=\"http://premiumfaves.com/shopping-and-retail/\" name=\"cat_31\" style=\"\">Shopping and Retail</a>',';0;'),(32,'Recreation & Sports','<a href=\"http://premiumfaves.com/recreation-sports/\" name=\"cat_32\" style=\"\">Recreation & Sports</a>',';0;'),(33,'Transport & Moving Services ','<a href=\"http://premiumfaves.com/transport-moving-services/\" name=\"cat_33\" style=\"\">Transport & Moving Services </a>',';0;'),(34,'Travel Industry','<a href=\"http://premiumfaves.com/travel-industry/\" name=\"cat_34\" style=\"\">Travel Industry</a>',';0;'),(35,'Wedding & Events','<a href=\"http://premiumfaves.com/wedding-events/\" name=\"cat_35\" style=\"\">Wedding & Events</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hookname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_link` VALUES (5,7,'Virtual Private Servers','http://www.24shells.net','24Shells provides affordable Virtual Private Server Hosting and Web Hosting Solutions. Visit us online for more information!','Tushit','tushit@24shells.net',0,0,0.00,'2012-03-04 11:27:22',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'24 shells, managed web hosting, virtual private servers, web hosting, web hosting solutions, windows hosting, windows web hosting, virtual private server hosting, virtual server hosting',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,31,'Silver Buyers St Louis MO','http://www.stoneledgeguns.com','Stone Ledge Gun and Pawn offers the largest selection of new and used guns, professional gold, silver, and jewelry trading services in St Louis MO, Washington. We will deal in any items of value, and specialize in pawning and trading new, used, and antique guns & Jewelry with an experience of over 10 years.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 17:44:14',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gun shop st louis mo, 9mm guns st louis, gold buyers st louis mo,  local gun shop st louis, gun shops st louis mo, silver buyers washington mo, pawn shop washington mo',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,31,'Cigar Cabinets','http://www.habanosyhermanos.com','At Habanos & Hermanos, we offer discount cigars, the best cigar prices, cigar deals, and cheapest cigar accessories on the internet. We handle international cigars delivery, cigar humidors, cigar samplers, and more. We carry all premium cigars and boutique cigars, Arturo Fuente, Padron, Gurkha, Rocky Patel, Montecristo, Macanudo, Romeo and Juliet and more. Free shipping, low prices, the best online cigar prices available!','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 20:19:23',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cheap cigars, cheap humidors, cigar accessories, cigar ashtray, cigar cabinets, cigar cases, cigar cutters, cigar gifts, cigar lighters, custom humidors, gurkha cigars, humidor solutions, humidors for cigars, travel humidors, wholesale cigars',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,35,'Kankotri','http://www.parekhcards.com','Parekh Cards offers traditional and modern Indian Wedding Cards in a large selection of designs, colors, and styles. To shop check us out online!','Nilesh Parekh','weddingcards@vsnl.net',0,0,0.00,'2012-02-12 18:03:24',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'indian wedding favours, wedding program scroll, scroll wedding invitations, wedding shopping india, kankotri',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,22,'Car Accident Lawyer New Jersey','http://www.workerscompaccident.com','Adam M Kotlar Attorney at Law provides legal representation for work accidents cases in Cherry Hill, Mt Laurel, New Jersey (NJ) and surrounding areas. We take an aggressive and thorough approach to the law, and handle all sorts of work related legal claims. Call us at 856-751-7676 for free consultation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-14 15:40:46',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'workmans compensation cherry hill, car accident lawyer cherry hill, workers comp mt laurel, workers comp lawyer mt laurel, workers compensation new jersey, car accident lawyer new jersey, workmans comp lawyer nj, workers comp nj',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,16,'Air Conditioning Repair West Bloomfield','http://www.levineandsons.com','Levine & Sons has been servicing residential and commercial plumbing, heating & air conditioning systems for over 80 years in West Bloomfield, Farmington Hills, Bloomfield Hills & Birmingham. Our fully trained, factory-Certified technicians do complete diagnosis of problem and provide a complete price estimate before we start the work.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 18:01:45',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' plumbing farmington hills, plumbing bloomfield hills,plumber bloomfield hills, plumbing repair bloomfield hills, drain cleaning bloomfield hills, air conditioning birmingham, air conditioning repair birmingham, air conditioning royal oak,',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,22,'DWI Lawyer Berkeley Springs WV','http://www.westvirginiaduilawyers.com','Wagner is an experienced and the only law firm in Martinsburg, Morgantown, Charles Town in West Virginia which solely focuses on DUI and DWI defense. From first offense misdemeanor cases to more serious DUI homicide cases, the Wagner Law Firm is fully capable of defending you effectively in court.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 18:27:21',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dui attorneys martinsburg wv, dui attorneys morgantown wv, dui defense lawyer charles town wv, dui defense lawyer martinsburg wv, dui lawyer martinsburg wv, dui lawyer morgantown wv, dwi attorneys charles town wv, dwi attorneys martinsburg wv',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,3,'Electrician Houston','http://www.tracyelectricinc.com','Tracy Electric, Inc. is an electrical contractor which specializes in the design and installation of electrical systems for industrial plants, commercial buildings, and residential projects.  We provide 24 hour design and on-site services, electrical engineering, construction, instrumentation and control system services in Wichita & Houston to help tailor to our customers’ needs.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-04 19:19:07',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' electricians wichita, electrical contractor houston,  electrical contractor wichita, electricians  houston',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,22,'Accident Lawyer Riverside','http://www.sweeneyattorneys.com','We are a family of lawyers that care and can assist you if you have been injured in a accident. We are experienced Riverside County personal injury attorneys that have serviced thousands of injury claims throughout our combined 45 years of service.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 19:27:39',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal injury attorneys riverside, personal injury lawyers riverside, injury attorneys riverside, accident attorneys riverside, car accident attorney riverside, accident lawyer riverside',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,22,'Bankruptcy Lawyers Hudson NY','http://www.mspinaclaw.com','Whether you’re seeking compensation for a workplace injury or to discharge debt  in Kingston & Hudson Ny,  our attorneys believe in giving every client the attention and dedication they deserve. Call 845-331-5777 and get a free consultation today.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 19:35:01',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'accident lawyers kingston ny, accident attorneys hudson ny, Bankruptcy lawyers hudson ny, bankruptcy attorneys kingston ny, workers  compensation hudson ny, social security disability kingston ny, traffic  lawyers hudson ny',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,15,'Dental Oral Surgery Butler PA','http://www.quadcountyoralsurgery.com','Do you have problems biting or chewing? When you\'re eating, do your lower teeth hit the roof of your mouth, causing discomfort? The Oral surgeon at Quad County will help you overcome your pain with the help of dental surgery such as Dental implants, TMJ & painless extraction of wisdom tooth in Butler & Kittanning PA area.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 19:46:10',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dental implants kittanning pa, oral surgeon butler pa, dental oral surgery grove city pa, tmj  kittanning pa, wisdom teeth butler pa, oral surgeon kittanning pa, dental oral surgery butler pa,  Tmj grove city pa, dental oral surgery kittanning pa, dental ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,22,'Bail Bond man Colorado Springs','http://www.dennisblackwellbailbonds.com','Dennis Blackwell Bail Bonds is a family owned business serving Colorado springs, Pubelo and the entire United States for 18 years. With our office located on the same street as the El Paso County Criminal Justice Center (CJC), we guarantee that you have chosen the fastest and most convenient bail bond service in Colorado Springs.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 19:53:29',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bail bonds colorado springs, bail bondsmen pueblo, bail bondsman colorado springs, bail bond man pueblo, bail bond colorado springs, bail bonds pueblo, bail bondsman colorado springs',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,28,'Houses for rent Lubbock','http://','Lynnwood Townhomes were designed with students in mind.  It is a student housing in Lubbock where every bedroom is a master suite with a luxurious walk in closet and full private bathroom. The town homes are zoned as apartments where more than two unrelated people can live legally.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-04 19:58:09',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'town homes for rent lubbock, student housing lubbock, rental properties lubbock, houses for  rent lubbock, homes for rent lubbock, rental homes lubbock, apartments for rent lubbock, town  homes lubbock',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,22,'Bankruptcy Attorneys Lancaster CA','http://www.DLBKlaw.com','Our bankruptcy law firm’s goal is to protect all of your possessions and get you back on track to financial security by guiding you through the bankruptcy process. With our no-interest monthly payment plan everyone can afford our bankruptcy firm, and with our friendly and experienced staff we can quickly and easily get you through the system so that you can return to a normal lifestyle.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-04 20:08:28',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bankruptcy questions fontana, bankruptcy attorneys lancaster  ca, bankruptcy lawyers fontana  ca, bankruptcy lawyer lancaster ca, bankruptcy attorney fontana ca, bankruptcy lawyers lancaster  ca, bankruptcy questions lancaster ca',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,20,'Auto Insurance Lancaster PA','http://www.unruhinsurance.com','Unruh Insurance Agency, Inc. is a professional organization dedicated to providing the best insurance protection and service possible. We Offer homeowners,car,auto & health insurance and services in Lancaster PA & Berks County. Contact us today at 1-877-854-3309 for more information.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-04 20:12:07',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'insurance berks county, homeowners insurance berks county, health insurance lancaster pa, health insurance berks county, car insurance berks county, auto insurance berks county, insurance lancaster pa, auto insurance lancaster pa',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,3,'Tile Huntington Beach','http://www.castletile.com','Anderson\'s Towing has 25 years experience in offering services like towing and impound services for the public as well as Federal, State, County and City Departments. We provide service 24/7 t competitive price in Modesto, Turlock & Stockton CA. Call 209-538-8697 for towing service.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-03-06 12:20:25',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'towing modesto ca, tow truck modesto ca, tow service modesto ca, road service modesto ca, flat tire modesto ca, towing turlock ca, tow truck turlock ca, tow service turlock ca, road service turlock ca, flat tire turlock ca, towing stockton ca',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,16,'Heater San Diego','http://www.thaheatandair.com','THA is the leading San Diego HVAC company for all residential and commercial heating and cooling systems for over 30 years.  We also provide repairs, spring and winter inspections, and yearly service agreements for all brands.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-06 12:24:06',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'air conditioning san diego, heating san diego, heater san diego, hvac san diego, ac san diego,  heating and air san diego, furnace san diego, heater repair san diego, air conditioning repair san diego, furnace repair san diego',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,22,'Bankruptcy Attorney Lancaster PA','http://mitchellsommers.com','The bankruptcy attorneys of the Law Offices in Ephrata and Lancaster, PA,  provides the best quality legal services to you and your business in a timely fashion and also helps people file for bankruptcy relief under the Bankruptcy Code .Call Mitchell A. Sommers ESQ, P.C. at 717-733-6607 for a legal consultation today.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-06 12:52:10',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bankruptcy lancaster, pa, bankruptcy lawyer lancaster, pa, bankruptcy attorney lancaster, pa, foreclosure lawyer  lancaster, pa, bankruptcy ephrata, pa, bankruptcy lawyer ephrata, pa, bankruptcy attorney ephrata, pa, foreclosure lawyer ephrata, pa  ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,3,'Waste Disposal Providence RI','http://www.abcdisposal.com','ABC Disposal Service, Inc. is the largest waste removal company in Massachusetts & Rhode Island. We offers residents waste, construction waste debris and recycling collection services at reasonable and competitive rates in Providence, RI & Cape Cod, New Bedford, Fall River, MA  . We also provides containers for safely transport and dispose of any type of non-hazardous materials generated from your site.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-06 14:31:06',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dumpster rental cape cod ma, roll off container providence ri, waste disposal new bedford ma, garbage removalfall river ma, recycling cape cod ma, waste disposal providence ri, garbage removal new bedford ma, recycling fall river ma     ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,3,'Fire Proof Safes St  Louis','http://www.batesstlock.com','Upgrade your Business & home\'s security in St.Louis city & county with new technologies from Bates Street Lock & Safe. Services and products available from us include antique lock service and repair, automotive high security keys, interchangeable core locks, lock service and repair, master key systems, restricted key systems and safe sales, service & installation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-06 14:35:29',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'safes st  louis, safe opening st  louis, safe cracking st  louis, safe moving st  louis, crack safes st  louis,high security safes st  louis, fire proof safes st  louis, how to open a safe st  louis',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,15,'Periodontics Las Vegas','http://www.redrockperio.com','Redrockperio offers dentistry services in Las Vegas with highest caliber diagnostics, optimal treatment planning, and simply beautiful results. We also provides Dental Implants, periodontal Surgery, Sedation Dentistry, Gum Treatments & many more with new technologies in a clean, comfortable environment.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-03-06 14:38:20',0,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'periodontal surgery las vegas, dental implants las vegas, sedation dentistry las vegas, gum treatments las vegas, periodontist las vegas, implant dentistry las vegas, gum surgery las vegas, periodontics las vegas, implant dentist las vegas  ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (1,'g',0,'2012-02-13'),(2,'g',0,'2012-02-13'),(4,'g',0,'2012-02-20'),(3,'g',0,'2012-02-20'),(5,'g',0,'2012-03-06'),(10,'g',0,'2012-03-07'),(8,'g',0,'2012-03-07'),(11,'g',0,'2012-03-07'),(13,'g',0,'2012-03-07'),(15,'g',0,'2012-03-07'),(6,'g',0,'2012-03-07');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_sessions` VALUES ('29ae4a1628cc93c7b749751fb361519d',1330572049,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A39%3A%22%2Fthemes%2F_premiumfaves%2Ftrackclick.js.php%22%3Bindexu_session_ip%7Cs%3A13%3A%2295.25.247.209%22%3B'),('19c4a7f633aa20158189d94d30357cd9',1330573170,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.90%22%3B'),('3d47675ff95c8be8b5d16b354b9abd14',1330573402,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D2%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.225%22%3B'),('5a818ce0f28ccc0f39ad3cdd03dd04a5',1330576828,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fhotels-restaurants%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.29%22%3B'),('e248686c141f484a0836a31b515b5b7c',1330592836,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fnews-magazines%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.29%22%3B'),('7f2c591be4965e6a6da0cce8025a43c4',1330593937,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Flifestyle-dating-relationships%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22157.55.17.201%22%3B'),('7be20798ac15097caff0570cb192877a',1330599608,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fadministrator%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2278.29.15.137%22%3B'),('23053b5d303754033951ed70ef1b91b0',1330601665,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D32%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.98%22%3B'),('0f299822a965aaaf34edb498072b71ef',1330617754,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D32%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.58%22%3B'),('7b7b6ab301334cf8841ac3e355a07358',1330628507,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D28%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.156%22%3B'),('e64be90e0c9d4f05bed88f22fd00ccfb',1330639439,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D25%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.67%22%3B'),('eea42a3c909f5fe39bbe91c4c78cd6a7',1330650240,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D7%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.155%22%3B'),('f40ed6edbd173e4f7c7fc4d114b44f70',1330657583,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A8%3A%22%2Fnew.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22207.46.13.157%22%3B'),('a7f1a840dff2865b2f9c967ca575aae7',1330657815,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.88%22%3B'),('1df6e6ff62759e0404dbd59fc239b2c6',1330658077,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A45%3A%22%2Fdetail%2F4%2Fcar-accident-lawyer-new-jersey.html%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.151%22%3B'),('edd807dbb9fa476de47bd5c68486bd89',1330666257,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D2%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.154%22%3B'),('73715123c8e143f1116014765582744c',1330668290,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A27%3A%22%2Ftransport-moving-services%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2265.52.104.27%22%3B'),('f485753bfb8a0881c7153c5da7ab58b4',1330673829,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.107%22%3B'),('77355c735af536a3f875175386ce4608',1330673831,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.108%22%3B'),('87a1e314e9630734cc2ac8ed299a28fb',1330674874,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.94%22%3B'),('601e5f6c26763cafbb00b3a57d7ee63d',1330680472,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A8%3A%22%2Fdental%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.110.190%22%3B'),('fa0fbc3f9db16ea393f3c55334f31702',1330692378,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.67%22%3B'),('8410affce2aff1a8b28172cb6ae11dd2',1330697269,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A22%3A%22%2Fclothing-accessories%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%2264.120.183.213%22%3B'),('6d18d3784723f57b11f85f366f15e80c',1330701979,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D2%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.186%22%3B'),('2dbbc018d85b17abf564218dd1028203',1330704299,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.110.199%22%3B'),('2b051defbe008f153aae85a212fc8e6f',1330707631,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.24%22%3B'),('975ee38ad4dcd9adb287a6981f89dfd4',1330720610,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Flifestyle-dating-relationships%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.116%22%3B'),('73e36fd6564fe6584c303db1d1cabee2',1330723695,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D1%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.107%22%3B'),('151ea471c097f91b7c404868fcd4f59f',1330738880,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('c3774c22b2908bf8d03a1a6a4d422732',1330744658,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.99%22%3B'),('a03a89fc0d638f8efe19506f69d85b0e',1330744897,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D7%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.161%22%3B'),('1384c30fbf8f46165a1c0eff0f960204',1330744907,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.110.199%22%3B'),('89ef282b1d3d44bc5ae044de7001da29',1330748403,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A33%3A%22%2Femployment-recruitment-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22207.46.13.117%22%3B'),('8945ad38b3b0448241c106d5ef264b52',1330750853,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.65%22%3B'),('3a8239eb0c35caa87f11cd87d344a627',1330751538,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A21%3A%22%2Fsuggest_category.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22207.46.13.114%22%3Bcaptcha_key%7Cs%3A4%3A%226076%22%3B'),('2b2ac5c23dcc5be12bd19b28c6bd30c7',1330756875,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.137%22%3B'),('9a963635c38cd4c81f4faca1820df62e',1330762968,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.6.29%22%3B'),('3569e4e4297b49f0ee77e994a6223e48',1330769233,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Finsurance-agents-and-companies%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22157.55.18.21%22%3B'),('065b925a6b2e35825f63d196f85ba2d8',1330769389,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.58%22%3B'),('5231b242458ee9a5b0937941cf418054',1330781581,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.194%22%3B'),('64fdc2f87a2d9aef012553d8b6f79c19',1330787108,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D28%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.166%22%3B'),('15bdb59316d91a1f445a77602302bde1',1330789398,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Freal-estate-development%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.23%22%3B'),('25da6da526890bcae7a9585193a2ac10',1330797783,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.101%22%3B'),('e3aaddb5633dff07b5e5d72246349182',1330804173,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A28%3A%22%2Fhome-improvement-interiors%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('0f03fbb45311a370875ec157955f8c0b',1330807907,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.114%22%3B'),('eb58cf265bf059fe46cb3c61f2ce2909',1330808780,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.213%22%3B'),('9e6664f107db4aa1ea879fb12ff1e94f',1330813737,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('e6c6817823bf6ea2f350a572f5e88d47',1330814934,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Freal-estate-development%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22157.55.17.193%22%3B'),('3315ab2fd8751ab90fd6dbf7571c6783',1330819518,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.95%22%3B'),('b6379bcf737f2586a4240b7fe651caee',1330820429,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Frecreation-sports%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('532732fa6ef27f51bb79c07e9444ac74',1330822185,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Finsurance-agents-and-companies%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.25%22%3B'),('0a8d9f4b5667216fb7fcb6aa6edb1421',1330827010,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fenergy-science%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('cfa611caeb1678f45fa81df05f3e9faf',1330829081,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.55%22%3B'),('8380f44b26550e21ee8f05e9d469a0e4',1330829297,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fgifts-flowers%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.35%22%3B'),('72af91d2457ce2f2e7f390b4ba58ed65',1330829375,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A21%3A%22%2Fsuggest_category.php%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.93%22%3Bcaptcha_key%7Cs%3A4%3A%229209%22%3B'),('63ce62c12a4cf8ef0802353b2f611fbd',1330836365,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Fhealthcare-management%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('7071a25e916da3711976312263e7aa57',1330837724,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A8%3A%22%2Fnew.php%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.189%22%3B'),('2a94d9cecfcee34558f42e1d01816581',1330844285,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A8%3A%22%2Fdental%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('6ea7d6a5a9570b7830d4055946054da4',1330846417,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D7%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.89%22%3B'),('7735660505d717789cdb8914430e5649',1330849716,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Fair-conditioning-heating-ventilating%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('587d5f99dae973a528826ad5335d5c39',1330855836,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A12%3A%22%2Farts-music%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('955c895d9c44d312fa47f9cf6c621bee',1330860252,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Feducational-resources%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.97%22%3B'),('bcae701476747d0eb4e4227c35fe85ce',1330863517,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D1%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.163%22%3B'),('0684411d70be2178719be630cc2ad303',1330864249,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fhotels-restaurants%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('ab70c33f44fd5d2a1f3568a6762f0638',1330870965,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fauto-industry%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.116%22%3B'),('2d6694de22470995d0fead828d298cce',1330870979,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Fcommunications-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.110.199%22%3B'),('b6755b4183c6256298d55032ed9e2f22',1330874419,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.66%22%3B'),('aaec1f9319033576b2cfe9c7c06077dd',1330885281,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.146%22%3B'),('b94a1e20b8f6db741918111308a00dbe',1330892021,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Ffinance-investment-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22157.55.17.199%22%3B'),('2226faee1b7673ec5c7ee0ff2b9f8522',1330895926,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.231%22%3B'),('f6f3452afcd854e3bba1bf3ad74688ce',1330903024,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A13%3A%22%2Fseo-smo-ppc%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22207.46.204.244%22%3B'),('3a818d9225b1ae88f0ae11f5c57b9923',1330905988,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Feconomy-business%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.98%22%3B'),('344bac103a51edce3f0beb327213e65d',1330906890,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.177%22%3B'),('43c14c5f26de09b610b0ca29a8eb012c',1330915364,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Fair-conditioning-heating-ventilating%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2265.52.109.26%22%3B'),('071be5ec707cf4c2fd83ac246d57f8a3',1330915652,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fgifts-flowers%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22207.46.13.206%22%3B'),('43719f9540da4f5ce1070e600d845c81',1330923274,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.101%22%3B'),('001b68954ad58aa537f9dbe80f567784',1330923553,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D33%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.101%22%3B'),('b22da9ec158a1ea3ceff9de35e9b38de',1330934066,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.94%22%3B'),('bc3f90324acbcdb4a17bba698b20a2e9',1330934233,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Ftravel-industry%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%2264.120.183.213%22%3B'),('4cee254471db94ecd219acd275340afd',1330939122,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Fbuilding-construction%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.13%22%3B'),('18cc1b8fc2d59af5dd533ecfbf7dbcd2',1330941452,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Feconomy-business%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.109.152%22%3B'),('41378d59781c4ec51cf3d7c11deaff1e',1330944178,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Fbuilding-construction%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2265.52.109.153%22%3B'),('5f891c50de85b34d195d6dc42d756caf',1330953349,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Ffamily-home-garden%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.88%22%3B'),('f6f0c7b32e8601b612b24f6050ea699a',1330955824,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D13%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.100%22%3B'),('4d6d6e35f1aeacf3bfe04beab3e0d667',1330956553,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fcomputer-services%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2265.52.104.90%22%3B'),('b8c4c12e824df695d263d3f7f3991cb2',1330962550,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A28%3A%22%2Ftag%2Fworkmans-comp-lawyer-nj%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.98%22%3B'),('36009ad0e30f46172d3f80f28d7a1ad3',1330973248,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A34%3A%22%2Ftag%2Fworkers-comp-lawyer-mt-laurel%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.99%22%3B'),('858c2bcbd9d146b00365cb7d08bc24ec',1330973635,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fhotels-restaurants%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2265.52.108.68%22%3B'),('2627ba1c8f9c584ef32299787b7d7f59',1330984131,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A36%3A%22%2Ftag%2Fcar-accident-lawyer-cherry-hill%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.168%22%3B'),('96998b2572ea41e224dc498733a0f1e5',1330994956,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.164%22%3B'),('1d50c5c90d0fcd942aadd725286d4fb5',1330996623,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Frecreation-sports%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22157.55.16.87%22%3B'),('c81d60bbed0e5fd56cbb64df5541a503',1331002436,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fhardware-software-resources%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22207.46.13.50%22%3B'),('9dd0084a29ec4179c4e906e38a6df58b',1331002665,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Frecreation-sports%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.32%22%3B'),('0bf5dde72a5acb774da7ea4dd0c06765',1331002728,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Ftag%2Fworkmans-compensation-cherry-hill%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.232%22%3B'),('6b86aea0819dd6b98621250433f250ec',1331008264,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fplumbing-services%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%2265.52.104.88%22%3B'),('d87dba3aeb9fb42933bbcb534d02e865',1331011383,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A36%3A%22%2Ftag%2Fworkers-compensation-new-jersey%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.147%22%3B'),('2ddf7f5ee62cce6f9302e3f86592c4a2',1331019929,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Ftag%2Fworkers-comp-nj%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.65%22%3B'),('a2b794a80d6430f90a4886c0f61e1d7b',1331028670,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A27%3A%22%2Ftag%2Fworkers-comp-mt-laurel%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.147%22%3B'),('9f64a0ce89b28cda58790b85bc9f4f6c',1331037315,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A35%3A%22%2Ftag%2Fcar-accident-lawyer-new-jersey%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.225%22%3B'),('804721e132dafde0b1d37d7f17755b35',1331043758,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fplumbing-services%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%2264.120.183.213%22%3B'),('a7c2882db94778259b4c10f77bdc8560',1331048645,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A35%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%26ltr%3DW%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.146%22%3B'),('ea7059627b544dd3595832e3ab744b5c',1331050483,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Ftravel-industry%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.17%22%3B'),('cca6dde0cd507758d1f865e6b4493511',1331075444,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A8%3A%22%2Fdental%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.82%22%3B'),('91b78c587b88096aa72bfc24c0ac11f5',1331076478,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D12%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.110%22%3B'),('b2aaf51638035d1cf3c94161955e26e9',1331088224,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D9%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.145%22%3B'),('880821235f682565581ce3ea754c3fd1',1331096847,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D23%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.171%22%3B'),('b22e9b9505a421988516a642231337c9',1331105400,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A14%3A%22%2Fget_rated.php%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.212%22%3B'),('9aeba974f0426002d14a5080946c600f',1331105413,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A14%3A%2238.126.199.154%22%3B'),('5adbc4b2256c989255f9b5808cc9c0f6',1331105417,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A14%3A%2238.126.199.154%22%3B'),('3ded16ef82b7e53eb57a05462663168c',1331105455,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A14%3A%2238.126.199.154%22%3B'),('1c3995f991e7243c800cb89ff733fd28',1331109656,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A21%3A%22%2Fshopping-and-retail%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22203.92.47.195%22%3B'),('ad6a15ee05e3e1cf9469935bf7fc9589',1331105528,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Fthemes%2F_premiumfaves%2Flayout.css%22%3Bindexu_session_ip%7Cs%3A13%3A%22203.92.47.195%22%3B'),('7d1a0402aa747ee128d067e18acd15b2',1331109659,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Fthemes%2F_premiumfaves%2Flayout.css%22%3Bindexu_session_ip%7Cs%3A13%3A%22203.92.47.195%22%3B'),('682a1ab7c2b5a48da8e4aaa8b11525a2',1331106263,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22223.165.30.67%22%3B'),('598141ffeacc639d392901b5a7c02752',1331106265,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22223.165.30.67%22%3B'),('99ca2fc8a7d218ab8037f76229eb9370',1331108533,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Flawyers-judges%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2288.80.205.219%22%3B'),('f757ddd2c6daa0d6c2a4731df07edb71',1331108534,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Fthemes%2F_premiumfaves%2Flayout.css%22%3Bindexu_session_ip%7Cs%3A13%3A%2288.80.205.219%22%3B'),('ec7e297d13750c96d46be19e9f0415be',1331109137,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A12%3A%22%2Ffavicon.ico%22%3Bindexu_session_ip%7Cs%3A13%3A%22174.34.147.86%22%3B'),('7145797407d4472544efba088b810783',1331109132,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Fthemes%2F_premiumfaves%2Flayout.css%22%3Bindexu_session_ip%7Cs%3A13%3A%22174.34.147.86%22%3B'),('043a633a85fd3067151a748a5f1f6670',1331109134,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A39%3A%22%2Fthemes%2F_premiumfaves%2Ftrackclick.js.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22174.34.147.86%22%3B'),('607765876003fd69301696a7d565a80a',1331109294,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fcomputer-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%2266.197.181.48%22%3B'),('0e489b774c46446b537e95567b40997c',1331110336,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A21%3A%22%2Fshopping-and-retail%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.18%22%3B'),('1656b2bc0f0ee2550091979e2b6a0300',1331111432,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fwedding-events%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.52%22%3B'),('2bfe54ab40c6a1794686615170f3239b',1331114240,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D14%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.60%22%3B'),('019684d2f5429a2d6a650f6e1b9f1e0d',1331114496,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Flawyers-judges%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.117%22%3B'),('e11891c10ff0555ebed494323f3d8d71',1331114628,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.86%22%3B'),('66f867a2240d6feb8ed05e90232136ec',1331122586,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fgifts-flowers%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%2264.120.183.213%22%3B'),('8bad5acd12ae510c1f702743ee5d2a84',1331122819,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D19%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.141%22%3B'),('e92c342103bf1bf82d7a435cd97a0704',1331139967,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A13%3A%22%2Ftag%2Fkankotri%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.170%22%3B'),('c8cae80426e00daac32b24250016b875',1331140198,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fuser_search.php%3Fpflag%3Dsearch%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.101%22%3B'),('672ae7e479790a7fd9e2dfc17586babc',1331150695,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A14%3A%22%2Ftop_rated.php%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.6.211%22%3B'),('f7f9a84df4f72b92b4c6a0fade742dfe',1331157537,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.110%22%3B'),('4457b53319dbd17da79a5fb646586388',1331157967,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Freal-estate-development%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.115%22%3B'),('93813a57b446e13ce75d99147b85f36c',1331158193,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Fhardware-software-resources%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.23%22%3B'),('b3bcb4895c0d75bf38a4ae78212e4bec',1331158423,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A22%3A%22%2Fclothing-accessories%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.96%22%3B'),('8e96cf6d1539d4965357d12ab02a52c9',1331158651,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Flawyers-judges%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.101%22%3B'),('c328f6c3f46421b0952efa880a72fe20',1331158881,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fmedicine-hospitals%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.112%22%3B'),('2c8bf1de1c948859b9369a546c10ccc1',1331159111,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fmedical-health%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.69%22%3B'),('47ad5eb9785269e6314f5e5084ab4116',1331159340,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Fair-conditioning-heating-ventilating%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.117%22%3B'),('e25f7a8bec989af26445cdd210f7b824',1331159568,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fcareers-job-search%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.28%22%3B'),('99e9182d727e0809f59f34baeeceff65',1331159797,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A33%3A%22%2Femployment-recruitment-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.53%22%3B'),('3a6312c5cf51c242668a26cd50fe64df',1331160027,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A27%3A%22%2Ftransport-moving-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.87%22%3B'),('49da8a18cccf8c394291ce95b620e609',1331160256,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A25%3A%22%2Fcommunications-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.80%22%3B'),('c22cb0fbf49338e145447455fb3db7eb',1331160485,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fplumbing-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.94%22%3B'),('2ea83a46269e38df721fcdebf1d5324f',1331160720,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A21%3A%22%2Fshopping-and-retail%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.115%22%3B'),('31725735f2d7823f71642c4e728719a0',1331160950,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A13%3A%22%2Fseo-smo-ppc%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.18%22%3B'),('75462d877c7f5002c43370ae1ca669b4',1331161178,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fenergy-science%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.25%22%3B'),('784d5cf9b9eafec4e5e64a0515078e3c',1331161407,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fnews-magazines%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.59%22%3B'),('1e4128734ef7ce0df1b492c9f702d86f',1331161637,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Flifestyle-dating-relationships%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.111%22%3B'),('eb0111a382f36dbec5fa0566554d4490',1331161867,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A23%3A%22%2Fhealthcare-management%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.99%22%3B'),('ddcaf5ec54e9b7fd03bf87aca2eb9c06',1331162096,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A12%3A%22%2Farts-music%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.94%22%3B'),('99f1564030be5360bf1c96d3f3358f26',1331162554,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A5%3A%22%2Flaw%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.90%22%3B'),('75012234519e4876330e781084c7e98a',1331162804,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A32%3A%22%2Fthemes%2F_premiumfaves%2Flayout.css%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.33%22%3B'),('89ac6d3480c745a16e379a90445c3372',1331163035,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A16%3A%22%2Fwedding-events%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.106%22%3B'),('57074990cd9a4910214459a38465dd87',1331163260,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A29%3A%22%2Ffinance-investment-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.12%22%3B'),('9d0b0b9d7fcd5d4de0fa3603ecfba2c7',1331164175,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A19%3A%22%2Fcomputer-services%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.27%22%3B'),('c1e3a29e61693942a18c133c1cd995da',1331164405,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A20%3A%22%2Fhotels-restaurants%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.83%22%3B'),('9da0a47b02dd7566d5f5eaf3ebfc89d2',1331164861,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.php%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.17%22%3B'),('67fd767beef6291e7cbcfdca73f7fff0',1331164862,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.19%22%3B'),('6df6e581a78dda69e72e5a9158574489',1331165091,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A22%3A%22%2Fthemes%2F_premiumfaves%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.96%22%3B'),('1d7f98c789dc1ebf2431294cd27b8c45',1331165318,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A28%3A%22%2Fhome-improvement-interiors%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.22%22%3B'),('0b9df675b209d627a99ae35a4a5b9d6b',1331172361,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A17%3A%22%2Fbrowse.php%3Fcat%3D9%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.166%22%3B'),('8c8f8cbb7ea380ab35b11aa1070ab489',1331174512,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.162%22%3B'),('7a9da3431988192c1d4e5e0d1d9afee8',1331174744,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D17%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.189%22%3B'),('c2fe354ae3d79ab4fcbfa627f4d8b48d',1331177830,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22100.43.83.153%22%3B'),('bf3e82e8eb0cf1812fb6f5de85e480ac',1331179337,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D14%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.100%22%3B'),('dfb658b7d4447a70d2245971e5e54926',1331183994,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A18%3A%22%2Fbrowse.php%3Fcat%3D24%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.65%22%3B');

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

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_hook_place` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

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

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

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

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


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

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

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


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

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) DEFAULT NULL,
  `record_execution` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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

INSERT INTO `idx_users` VALUES ('admin','8cb4bac0319dfd062af9a8000aa5f6b1','Administrator','annika.lesieur@gmail.com','2011-11-27','1','',0,'','','','','','','','');

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

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

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



