--
-- Host: ipromoteweb.com    Database: ipromote_ipro
-- ------------------------------------------------------


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (4,0,'Automobile industry','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Arts & Humanities','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Business & Economy','','folder.gif','','1',7,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Careers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Clothing & Fashion','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Mass Communications','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Computers & IT','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Construction Services','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Dental Health','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Education & Training','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Employment Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Gift Baskets','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Hardware & Software Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Health & Medical','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Healthcare Related','','folder.gif','','1',6,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Air Conditioning & Heating','','folder.gif','','1',3,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Home & Garden Decor','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Home Improvement Services','','folder.gif','','1',14,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Hotels & Resorts','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Insurance Services','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Law Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Lawyers and Law Firms','','folder.gif','','1',14,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Lifestyle & People','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'Medicine  Facilities','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Financial Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'News','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Plumbing & Plumbers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'Real Estate Services','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Technology & Science','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'SEO Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Shopping and Fashion','','folder.gif','','1',4,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Games & Sports','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Transport & Freight Forwarding ','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(36,0,'Travel & Vacations','','folder.gif','','1',1,'','','1','0','','',0,'',0,0,0,0,0),(37,0,'Wedding Accessories','','folder.gif','','1',2,'','','1','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (3,'Arts & Humanities','<a href=\"http://ipromoteweb.com/arts-humanities/\" name=\"cat_3\" style=\"\">Arts & Humanities</a>',';0;'),(4,'Automobile industry','<a href=\"http://ipromoteweb.com/automobile-industry/\" name=\"cat_4\" style=\"\">Automobile industry</a>',';0;'),(5,'Business & Economy','<a href=\"http://ipromoteweb.com/business-economy/\" name=\"cat_5\" style=\"\">Business & Economy</a>',';0;'),(6,'Careers','<a href=\"http://ipromoteweb.com/careers/\" name=\"cat_6\" style=\"\">Careers</a>',';0;'),(7,'Clothing & Fashion','<a href=\"http://ipromoteweb.com/clothing-fashion/\" name=\"cat_7\" style=\"\">Clothing & Fashion</a>',';0;'),(8,'Mass Communications','<a href=\"http://ipromoteweb.com/mass-communications/\" name=\"cat_8\" style=\"\">Mass Communications</a>',';0;'),(9,'Computers & IT','<a href=\"http://ipromoteweb.com/computers-it/\" name=\"cat_9\" style=\"\">Computers & IT</a>',';0;'),(10,'Construction Services','<a href=\"http://ipromoteweb.com/construction-services/\" name=\"cat_10\" style=\"\">Construction Services</a>',';0;'),(11,'Dental Health','<a href=\"http://ipromoteweb.com/dental-health/\" name=\"cat_11\" style=\"\">Dental Health</a>',';0;'),(12,'Education & Training','<a href=\"http://ipromoteweb.com/education-training/\" name=\"cat_12\" style=\"\">Education & Training</a>',';0;'),(13,'Employment Services','<a href=\"http://ipromoteweb.com/employment-services/\" name=\"cat_13\" style=\"\">Employment Services</a>',';0;'),(14,'Gift Baskets','<a href=\"http://ipromoteweb.com/gift-baskets/\" name=\"cat_14\" style=\"\">Gift Baskets</a>',';0;'),(15,'Hardware & Software Services','<a href=\"http://ipromoteweb.com/hardware-software-services/\" name=\"cat_15\" style=\"\">Hardware & Software Services</a>',';0;'),(16,'Health & Medical','<a href=\"http://ipromoteweb.com/health-medical/\" name=\"cat_16\" style=\"\">Health & Medical</a>',';0;'),(17,'Healthcare Related','<a href=\"http://ipromoteweb.com/healthcare-related/\" name=\"cat_17\" style=\"\">Healthcare Related</a>',';0;'),(18,'Air Conditioning & Heating','<a href=\"http://ipromoteweb.com/air-conditioning-heating/\" name=\"cat_18\" style=\"\">Air Conditioning & Heating</a>',';0;'),(19,'Home & Garden Decor','<a href=\"http://ipromoteweb.com/home-garden-decor/\" name=\"cat_19\" style=\"\">Home & Garden Decor</a>',';0;'),(20,'Home Improvement Services','<a href=\"http://ipromoteweb.com/home-improvement-services/\" name=\"cat_20\" style=\"\">Home Improvement Services</a>',';0;'),(21,'Hotels & Resorts','<a href=\"http://ipromoteweb.com/hotels-resorts/\" name=\"cat_21\" style=\"\">Hotels & Resorts</a>',';0;'),(22,'Insurance Services','<a href=\"http://ipromoteweb.com/insurance-services/\" name=\"cat_22\" style=\"\">Insurance Services</a>',';0;'),(23,'Law Services','<a href=\"http://ipromoteweb.com/law-services/\" name=\"cat_23\" style=\"\">Law Services</a>',';0;'),(24,'Lawyers and Law Firms','<a href=\"http://ipromoteweb.com/lawyers-and-law-firms/\" name=\"cat_24\" style=\"\">Lawyers and Law Firms</a>',';0;'),(25,'Lifestyle & People','<a href=\"http://ipromoteweb.com/lifestyle-people/\" name=\"cat_25\" style=\"\">Lifestyle & People</a>',';0;'),(26,'Medicine  Facilities','<a href=\"http://ipromoteweb.com/medicine-facilities/\" name=\"cat_26\" style=\"\">Medicine  Facilities</a>',';0;'),(27,'Financial Services','<a href=\"http://ipromoteweb.com/financial-services/\" name=\"cat_27\" style=\"\">Financial Services</a>',';0;'),(28,'News','<a href=\"http://ipromoteweb.com/news/\" name=\"cat_28\" style=\"\">News</a>',';0;'),(29,'Plumbing & Plumbers','<a href=\"http://ipromoteweb.com/plumbing-plumbers/\" name=\"cat_29\" style=\"\">Plumbing & Plumbers</a>',';0;'),(30,'Real Estate Services','<a href=\"http://ipromoteweb.com/real-estate-services/\" name=\"cat_30\" style=\"\">Real Estate Services</a>',';0;'),(31,'Technology & Science','<a href=\"http://ipromoteweb.com/technology-science/\" name=\"cat_31\" style=\"\">Technology & Science</a>',';0;'),(32,'SEO Services','<a href=\"http://ipromoteweb.com/seo-services/\" name=\"cat_32\" style=\"\">SEO Services</a>',';0;'),(33,'Shopping and Fashion','<a href=\"http://ipromoteweb.com/shopping-and-fashion/\" name=\"cat_33\" style=\"\">Shopping and Fashion</a>',';0;'),(34,'Games & Sports','<a href=\"http://ipromoteweb.com/games-sports/\" name=\"cat_34\" style=\"\">Games & Sports</a>',';0;'),(35,'Transport & Freight Forwarding ','<a href=\"http://ipromoteweb.com/transport-freight-forwarding/\" name=\"cat_35\" style=\"\">Transport & Freight Forwarding </a>',';0;'),(36,'Travel & Vacations','<a href=\"http://ipromoteweb.com/travel-vacations/\" name=\"cat_36\" style=\"\">Travel & Vacations</a>',';0;'),(37,'Wedding Accessories','<a href=\"http://ipromoteweb.com/wedding-accessories/\" name=\"cat_37\" style=\"\">Wedding Accessories</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_favorites` VALUES (1,'adaptive84','2011-12-12','My Favorites',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_link` VALUES (2,31,'Engineering Tyler TX','http://www.johnsonpace.com','Johnson  Pace  located in Longview TX specialized in engineering architecture and surveying offers  and offers multi-disciplinary servicesfor more ninformation contact 9037530663','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2011-12-24 16:56:03',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' architect longview tx, engineering longview tx, surveying longview tx ,surveying tyler tx, architect shreveport la,  architecture companies longview tx, architecture companies tyler tx, engineering tyler tx,  architecture companies shreveport la',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,24,'DUI Lawyer Berkeley Springs WV','http://www.westvirginiaduilawyers.com/http://www.westvirginiaduilawyers.com/','Harley Wagner is an experienced DUI lawyer who runs the only law firm in the State of WV that focuses solely on DUI defense. The Wagner Law Firm dedicates 100% of its resources to the practice of DUI. Call us today at (304)901-7400 for a free initial consultation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2011-12-30 11:20:53',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dui advice Berkeley Springs WV,DUI Lawyer Berkeley Springs WV,DUI Attorneys Berkeley Springs WV,DUI Defense Lawyer Berkeley Springs WV,DWI Lawyer Berkeley Springs WV,DWI Attorneys Berkeley Springs WV,dui advice Morgantown WV,dui advice Charles Town WV',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,24,'injury attorneys Wilmington','http://www.naglefirm.com/Wilmington/','At Nagle & Associates, the personal injury / auto accident attorneys are dedicated to protect the rights of accident victims in Wilmington, North Carolina to provide them with maximum amount of financial compensation for their personal injuries.','David - BR','david@breakthroughmarketingteam.com',0,0,0.00,'2011-12-31 16:23:26',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'auto accident lawyer wilmington, car accident lawyers wilmington, automobile accident attorney wilmington, motor vehicle accident attorneys wilmington, personal injury lawyer wilmington, personal injury attorney wilmington',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,3,'Cheap Concert Tickets Online','http://www.ticketshowdealer.com','TicketShowDealer.com offers online cheap concert tickets.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-01-03 13:59:25',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'broadway cheap tickets, cheap concert tickets online, online concert tickets, concert tickets online, buy concert tickets online, book of mormon broadway tickets, discount broadway theater tickets, discount theater tickets, cheap theater tickets',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,24,'Accident Attorneys Kingston 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-01-03 15:33:05',0,NULL,'0','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),(7,17,'Dental Oral Surgery Grove City 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-01-03 16:23:29',0,NULL,'0','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',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,24,'Bail Bond Pueblo','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-01-03 16:28:22',0,NULL,'0','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),(9,10,'Rent Office Space Gujarat','http://www.trinnitydevelopers.com','The Trinnity Developers caters all the expanding needs of Surat City in Construction. For details check us out online or call us at 09227902700!','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-01-05 15:38:08',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rent office space gujarat, commercial properties rental surat, business investment surat, commercial space surat, business centre gujarat, rent office space gujarat, investment in surat',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,9,'Small Business Hosting','http://www.24shells.net','24Shells provides web hosting services of best quality and the highest degree of professionalism. Browse us online to learn more about the hosting options available at 24Shells!','Tushit','tushit@24shells.net',0,0,0.00,'2012-01-05 17:55:54',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'24 shells, dedicated server provider, windows virtual servers, windows web hosting, small business hosting, reseller web site hosting, dedicated server, reseller hosting, windows hosting',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,7,'Stick on Bra','http://www.strapsandstrings.com','Straps And Strings offers designer and branded collection of Lingeries and Bras at affordable prices. To buy call us at +91 120 4227272 or visit us online!','Saurabh Dadu','ceo@strapsandstrings.com',0,0,0.00,'2012-01-08 14:26:24',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bra brands, push-up bra, stick on bra, designer lingerie, bridal lingerie, lingerie   ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,24,'Bankruptcy Lawyer 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-01-06 15:12:32',0,NULL,'0','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),(13,22,'Health Insurance Berks County','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-01-06 15:19:28',0,NULL,'0','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),(14,17,'Gum Surgery 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-01-06 15:36:30',0,NULL,'0','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),(15,5,'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-01-06 15:41:35',0,NULL,'0','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),(16,5,'Dumpster Rental Fall River MA','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-01-06 15:45:41',0,NULL,'0','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),(17,10,'Remodeling San Antonio TX','http://www.WestRidgeConstruction.com','West Ridge Construction is largest custom home builder, specializes in custom home construction and home design in San Antonio, TX. We built homes with the finest products, built by knowledgeable subcontractors, and built with you. We also specialize in remodeling kitchens, If you want to update your kitchen contact us at 830-438-4520 for more information.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-06 16:18:37',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'remodeling san antonio tx, custom homes san antonio tx, home builder san antonio tx, kitchen remodelers san antonio tx, remodeler san antonio tx, remodelers san antonio tx, residential home builder san antonio tx, kitchen remodeling san antonio tx',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,24,'Bankruptcy Ephrata 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-01-06 16:31:47',0,NULL,'0','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),(19,18,'Air Conditioning Repair 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-01-06 16:46:05',0,NULL,'0','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),(20,20,'Tile Huntington Beach','http://www.castletile.com','Castle Tile offers countless tile lines from a number of quality tile manufacturers and natural stone quarries in Irvine, Fountain Valley, Newport and Huntington Beach. Our experienced and knowledgeable staff is available to you six days a week to guide you for the specific needs of your project.  Call today for home design at (949)645-5906.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-01-06 16:49:02',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tile irvine, flooring tile irvine, tiles irvine, tile newport beach, flooring tile newport beach, tiles newport beach, tile huntington beach, flooring tile huntington beach, tiles huntington beach, tile fountain valley, flooring tile fountain valley, tile',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,24,'Veterans Affairs Portsmouth','http://www.davidhuffmanlawservices.com','David Huffman is a disabled Vietnam veteran who focuses on veteran’s law and social security.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-09 14:06:36',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Social Security Disability Norfolk, Social Security Disability Portsmouth, Social Security Disability Suffolk, Social Security Disability Virginia Beach, Veterans Affairs Hampton, Veterans Affairs Portsmouth, Veterans Affairs Roanoke',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,24,'Workers Comp Lawyer Philadelphia','http://www.workerscompaccident.com','Adam M Kotlar Attorney at Law provides legal representation for work accidents cases in Cherry Hill, Mt Laurel, New Jersey (NJ) and surrounding areas. We take an aggressive and thorough approach to the law, and handle all sorts of work related legal claims. Call us at 856-751-7676 for free consultation.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-10 14:15:04',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Car Accident Lawyer New Jersey, Car Accident Lawyer NJ, Car Accident Lawyer Philadelphia, Workers Comp Lawyer Philadelphia, Workers Comp Turnersville, Workers Compensation Turnersville, Workmans Comp Lawyer Philadelphia, Workmans Compensation Turnersville',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,24,'Injury attorney Atlanta','http://www.kaufmanlaw.net','Atlanta, Georgia Personal Injury Attorney Kaufman Law, P.C. has the experience, dedication and drive to recover the compensation you deserve. If you need a Personal Injury Lawyer in Atlanta, Columbus or Savannah, GA, call 888-973-2540 right now for counsel. - (404) 355-4000 - 12 Beck Street, N.W. Atlanta, GA. 30318','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-16 16:38:46',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Auto Accident Attorney Atlanta, Injury attorney Atlanta, Car Accident Attorney Atlanta, Car Accident Lawyer Atlanta, Injury Lawyer Atlanta, Personal injury Attorney Atlanta, Personal Injury Lawyer Atlanta',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,24,'Criminal Lawyer Austin TX','http://www.atxattorney.com','Nichols & Gill, P.C. is an Austin based law firm dedicated to defending the rights of people accused of crimes such as Driving While Intoxicated (DWIs), Assault Family Violence, theft and Drug Possession. Call us at 512-448-9677 for aggressive criminal defense.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-22 13:30:18',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Criminal Lawyer Austin TX, Criminal Attorney Austin TX, Criminal Attorney Austin Texas, Criminal Lawyer Austin Texas',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,5,'Nevis citizenship','http://www.saintkittscitizenship.com','SaintKittscitizenship.com caters to persons seeking citizenship in the Federation of St. Kitts and Nevis. Citizenship of St. Kitts & Nevis can be obtained by marriage, descent or by investment. The St. Kitts Citizenship by Investment programme is one of the oldest programmes of its kind. It offers persons citizenship through investment in the Federation.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-01-24 15:21:33',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'St Kitts Economic Citizenship, St Kitts & Nevis Citizenship, Nevis citizenship, Economic citizenship, St Kitts passport, Real Estate in St Kitts, SIDF',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,17,'Home Health Birmingham','http://www.alwaysthereinc.com','Always There In - provides assisted living and sitter services to cover a wide range of non medical, basic home care needs.We also provide medical home care services, including skilled nursing services, RN medication management, disease education and more.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-28 17:54:36',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'assisted living birmingham, assisted living huntsville, assisted living pell city, home health huntsville, nursing homes huntsville, nursing homes pell city, sitter services birmingham',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,17,'Nursing Homes Huntsville','http://www.alwaysthereinc.com','Always There In - provides assisted living and sitter services to cover a wide range of non medical, basic home care needs.We also provide medical home care services, including skilled nursing services, RN medication management, disease education and more.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-28 17:54:57',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'assisted living birmingham, assisted living huntsville, assisted living pell city, home health huntsville, nursing homes huntsville, nursing homes pell city, sitter services birmingham',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,33,'Gun shop St Louis','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-01-28 18:02:16',0,NULL,'0','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),(29,18,'Heating West Bloomfield','http://www.levineandsons.com','We offer same day service for most repairs. for emergency service we offer fast 60-minute arrival. we also offer no dig sewer line repairs that will save your money.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-28 18:18:57',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'air conditioning bloomfield hills, air conditioning farmington hills, air conditioning repair birmingham, air conditioning repair bloomfield hills, heating farmington hills, heating west bloomfield, plumber birmingham, plumber bloomfield hills',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,24,'Criminal Attorney Dutchess County','http://www.smandb.com','Serino, MacKay & Berube, PPLC is a full service law firm serving the Dutchess County and Poughkeepsie, NY. With over two former senior assistant attorneys on staff and 45 years combined experience, we can help you navigate through the often confusing and stressful legal system.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-28 18:29:51',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bankruptcy lawyer poughkeepsie ny, criminal lawyer dutchess county, dwi lawyer poughkeepsie  ny, divorce lawyer dutchess county, criminal attorney poughkeepsie ny, bankruptcy attorney dutchess  county, divorce attorney poughkeepsie ny',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,5,'Electrical contractor 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-01-28 19:22:01',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'electrician wichita, electricians wichita, electrical contractor wichita, electrician houston, electricians houston, electrical contractor houston',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,18,'Heating Repair Buford','http://www.hixonheatingandair.com','Hixon Heating & Air Conditioning is an experienced and reliable heating and air conditioning contractor serving Grayson, Buford, Dacula, Lawrenceville & Loganville for over 15 years. Customer satisfaction is our #1 goal. We gaurantee to beat any written estimate by 10% on any comparable heating and air products by any legitimate heating and air specialist.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-01-28 19:28:25',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'air conditioning grayson, hvac repair buford, heating repair dacula, air conditioning  buford, hvac repair loganville, heating repair snellville, air conditioning dacula, hvac repair  grayson, heating repair loganville, hvac repair snellville ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,20,'Cleaning Service North Charlotte','http://northcharlotte.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in North Charlotte at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 12:56:43',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning north charlotte,house cleaning north charlotte,cleaning services north charlotte, residential cleaning north charlotte',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,20,'Home Cleaning Orange Park','http://orangepark.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Orange Park at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 14:29:42',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' thecleaningauthority,the cleaning authority,home cleaning orange park,house cleaning orange park,cleaning services orange park, residential cleaning orange park,maid services orange park',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,30,'Homes for rent Lubbock','http://www.lynnwoodtownhomes.com','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-01-28 19:57:28',0,NULL,'0','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),(35,20,'Maid Service Huntington','http://huntington.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Huntington at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-03 14:11:15',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning huntington,house cleaning huntington,cleaning services huntington, residential cleaning huntington,maid services huntington,green cleaning huntington, professional cleaning huntington',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,20,'Cleaning Services North Tarrant County','http://northtarrantcounty.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in North Tarrant County at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-04 13:09:05',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning north tarrant county,house cleaning north tarrant county,cleaning services north tarrant county, residential cleaning north tarrant county',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,20,'Home Cleaning Northwest Valley','http://northwestvalley.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Northwest Valley at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-04 13:29:27',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning northwest valley,house cleaning northwest valley,cleaning services northwest valley, residential cleaning northwest valley',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,20,'Maid Service Oklahoma City','http://oklahomacity.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Oklahoma City at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-04 14:10:34',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' thecleaningauthority,the cleaning authority,home cleaning oklahoma city,house cleaning oklahoma city,cleaning services oklahoma city, residential cleaning oklahoma city',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,20,'Maid Service Olathe','http://olathe.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Olathe at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-04 14:14:11',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning olathe,house cleaning olathe,cleaning services olathe, residential cleaning olathe,maid services olathe,green cleaning olathe',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,20,'Cleaning Services Orlando','http://palmetto.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Orlando at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 14:42:42',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning orlando,house cleaning orlando,cleaning services orlando, residential cleaning orlando,maid services orlando,green cleaning orlando',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,20,'Maid Service Orlando','http://orlando.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Orlando at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 14:46:09',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' thecleaningauthority,the cleaning authority,home cleaning orlando,house cleaning orlando,cleaning services orlando, residential cleaning orlando,maid services orlando,green cleaning orlando',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,20,'House Cleaning Oswego','http://oswego.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Oswego at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-07 14:56:51',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning oswego,house cleaning oswego,cleaning services oswego, residential cleaning oswego,maid services oswego,green cleaning oswego',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,33,'Discount Cigars','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-09 20:17:25',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),(46,37,'Indian Wedding Cards','http://www.parekhcards.com','Parekh Cards offers the finest collection of Indian Wedding Cards which represents colorful, joyous and vibrant mood of Indian Wedding. Place an order online!','Nilesh Parekh','weddingcards@vsnl.net',0,0,0.00,'2012-02-14 17:58:08',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hindu wedding cards, indian wedding cards, indian marriage cards, indian wedding card, wedding cards, wedding card ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,24,'Criminal Attorney Hagerstown MD','http://www.dayandschiszik.net','The Day & Schiszik law firm serving Frederick, Hagerstown and Urbana MD, offers legal representation for a variety of divorce, child custody criminal and child support cases. We provide skillful and individualized attention as your family law lawyer and divorce attorney. We Call us today at 301-662-8811.','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-02-14 15:26:44',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'divorce attorney Frederick MD, child custody Frederick MD, child support Frederick MD, family law lawyer Frederick MD, divorce lawyer Urbana MD, divorce attorney Urbana MD, child custody Urbana MD, child support Urbana MD, family law lawyer Urbana MD',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,24,'Lawyer Corona','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-02-17 17:25:54',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'accident attorneys riverside , accident lawyer riverside , lawyer riverside , lawyers riverside, lawyer corona , lawyers corona, personal injury attorneys corona, personal injury lawyer corona',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,36,'budget hotel phuket','http://www.fargotravel.com','Fargo Travel specializes in hotel reservations, group and individual sightseeing tours, passenger transfers and a variety of package tours conducted both within Thailand. We offer you a personalized service in selecting the hotel that suits your holiday needs.','Nick','nick@fargotravel.com',0,0,0.00,'2012-02-16 16:33:14',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'discount pattaya hotels, Krabi Beach Resort, Discount Krabi Hotels, Krabi hotel reservations, phuket hotel reservation, budget hotel phuket, 5 star hotels in phuket, Koh Samui Hotels Reservation, Thailand hotels',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,17,'phlebotomy carts','http://www.customcomfort.com','Custom Comfort Medtek, a medical furniture manufacturer, has provided the medical industry with high quality innovative medical products including hospital furniture, blood laboratory furniture, phlebotomy chairs, phlebotomy supplies and equipment to since 1987 serving the oncology, dialysis, blood bank, labs, outpatient clinics and hospital markets. Call us at 800-749-0933 to place your order!','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-16 16:46:23',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Dialysis chair, exam tables, Medical cabinet, medical cabinets, medical cart, medical carts, medical seating, Medical Stools, medical supply cabinet, phlebotomy cart, phlebotomy carts, Treatment Tables',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,20,'Mold remediation Wilmette','http://www.castinorestoration.com','At Castino Restoration, we are the leading Water, Flood, Fire and Mold Remediation experts serving Northbrook, Wilmette, Winnetka, Glencoe, Lake Forest since 1974. We also offer Carpet Cleaning throughout the United States. Our professional and caring crews maintain a clean and orderly workspace and will do a great job for you.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-20 16:41:48',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fire damage northbrook, mold remediation northbrook, carpet cleaning northbrook, flood damage wilmette, fire damage wilmette, mold remediation wilmette, carpet cleaning wilmette, flood damage winnetka, fire damage winnetka, mold remediation winnetka',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,17,'Cellulite Reduction Houston Tx','http://www.soma-solutions.com/','Soma Solutions, LLC in Houston offers  VelaShape II treatments, GentleMax Laser services, and skin rejuvenation services to help you to look  healthier, firmer and younger.for more details call at 703-790-2639','Yellow Book','stuart@ebrandz.com',0,0,0.00,'2012-02-21 15:37:28',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cellulite reduction vienna  va, botox vienna  va, juvederm vienna  va, botox injections mclean  va, botox treatments mclean  va, cellulite reduction mclean  va, botox mclean  va, juvederm mclean  va,botox treatments houston, tx',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,5,'Home Theater Installations Suffolk County','http://www.sounddimensionsplus.com','Sound Dimensions Plus has been servicing the audio video needs of the customers, both in their homes & in their vehicles. Our home theater division has designed and installed many systems in Nassau & Suffolk County area. We also offer professional installation of electronics for your vehicle.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-21 16:34:15',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'home theater installation nassau county, home theater system nassau county, home theater design nassau county, home theater installations suffolk county, home theater installers suffolk county, home theater system suffolk county, home theater design suffo',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,24,'Workers Comp Attorney Omaha','http://www.renschandrensch.com','Rensch & Rensch Law have over thirty-five years of combined legal experience to helping injured people in Omaha, Nebraskans. We handle all types of personal injury cases, ranging from minor fender-bender car accidents to large, worker’s compensation & complex medical malpractice cases. Call us directly at (402) 498-4400 to get more information.','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-21 17:13:45',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal injury attorney omaha ne, workers comp attorney omaha ne, car accident attorney omaha ne, injury attorney  omaha ne, personal injury lawyer omaha ne, personal injury lawyer omaha ne, personal injury attorney omaha',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,5,'Tile Cleaning Vancouver WA','http://www.aquacarepdx.com','Aqua Care provides environmentally friendly carpet cleaning service to residential and commercial customers of Portland & Vancouver.  We use a process that leaves behind no soap or chemicals, has a reduced dry time and is safe for your pets.  We even offer same day service and guaranteed satisfaction!','Stuart','stuart@smwebmarketing.com',0,0,0.00,'2012-02-21 19:38:38',0,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' carpet cleaner portland, tile cleaning vancouver wa,  carpet cleaning portland, carpet cleaners  Vancouver wa, upholstery cleaning portland, carpet cleaning vancouver wa, tile cleaning portland, upholstery cleaning vancouver wa',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,20,'House Cleaning Oregon City','http://oregoncity.thecleaningauthority.com','The Cleaning Authority, a dedicated leader in the green home cleaning industry offers you top quality house cleaning and maid services in Oregon City at the best possible price.','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-24 14:33:29',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'thecleaningauthority,the cleaning authority,home cleaning oregon city,house cleaning oregon city,cleaning services oregon city, residential cleaning oregon city,maid services oregon city',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,20,'Floral Rugs','http://www.shoparearugs.com','Find stunning collection of area rugs, wool rugs, persian rugs, oriental rugs, antique rugs, floral rugs to suit your needs. Check us out online for more details!','Zac Zolfaghari','zac@shoparearugs.com',0,0,0.00,'2012-02-26 12:47:40',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'floral rugs, oriental rugs, persian rugs, wool rugs, designer rugs ',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,37,'Wedding Scrolls','http://www.regalcards.com','Come, look and buy most exquisite and exclusive Indian wedding cards for your upcoming dream wedding. The collection offers unique and exceptional designer Indian wedding invitations.','Prabudhha Kothari','info@regalcards.com',0,0,0.00,'2012-02-27 15:33:03',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'indian wedding card, indian wedding invitation, hindu wedding invitation cards, indian wedding invitations, wedding invitation, wedding scrolls, wedding card, sikh wedding invitation cards, marriage cards, invitation card, wedding cards, invitation cards',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,33,'Classroom Furniture','http://www.chairsbazaar.com','CHAIRS BAZAAR is the leading office furniture & chairs manufacturer of all types of office chairs including ergonomic, executive, revolving, mesh, godrej, computer, chairs, modular furniture, office desk, seating systems & solutions, school, classroom furniture, chairs for architects & interior designers. We have the widest selection of high quality chairs available with 50% Discounts and Free Delivery in India. Call us on 7738101101 / 9892690690.','Arun Talwar','arun@chairsbazaar.com',0,0,0.00,'2012-02-27 17:37:15',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'office chairs bangalore , office chairs in india, office chairs india , office chairs manufacturers in india,  office chairs mumbai , office chairs pune, computer furniture , school furniture, interior designers india,  seating systems',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,5,'Sheet Metal Fabricators','http://www.samsfabrications.co.uk','Find high quality and reliable precision sheet metal fabricators at Sams Fabrications. Check us out online for more details!','Paul Waterhouse','sales@samsfabrications.co.uk',0,0,0.00,'2012-02-27 18:11:37',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sheet metal, smoking shelters, sheet metal fabricators, precision sheet metal, metal fabricators, sheetmetal, metal fabricators',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,33,'Gillette in India','http://www.cilory.com','Cilory offers the best collection anti aging products, deodorants and other personal care products from well known brands. To shop check us out online!','simon peterson','1simonpeterson1@gmail.com',0,0,0.00,'2012-02-29 18:02:18',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'anti aging products, deodorant in india, durex in india, gillette in india, shilajit',0,0,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_pagerank` VALUES (19,'g',0,'2012-03-04'),(11,'g',0,'2012-01-10'),(13,'g',0,'2012-01-10'),(20,'g',0,'2012-01-14'),(7,'g',0,'2012-01-15'),(14,'g',0,'2012-01-15'),(16,'g',0,'2012-01-16'),(15,'g',0,'2012-01-16'),(2,'g',0,'2012-01-16'),(5,'g',0,'2012-01-16'),(22,'g',0,'2012-01-19'),(3,'g',0,'2012-01-19'),(6,'g',0,'2012-01-19'),(10,'g',0,'2012-01-19'),(8,'g',0,'2012-01-19'),(9,'g',0,'2012-01-19'),(17,'g',0,'2012-01-19'),(4,'g',0,'2012-01-19'),(12,'g',0,'2012-01-19'),(18,'g',0,'2012-01-19'),(21,'g',0,'2012-01-19'),(23,'g',0,'2012-01-19'),(25,'g',0,'2012-01-26'),(24,'g',0,'2012-01-26'),(28,'g',0,'2012-02-03'),(34,'g',0,'2012-02-04'),(29,'g',0,'2012-02-06'),(32,'g',0,'2012-02-06'),(31,'g',0,'2012-02-06'),(35,'g',0,'2012-02-10'),(37,'g',0,'2012-02-10'),(38,'g',0,'2012-02-11'),(36,'g',0,'2012-02-11'),(39,'g',0,'2012-02-11'),(27,'g',0,'2012-02-17'),(26,'g',0,'2012-02-17'),(47,'g',0,'2012-02-18'),(45,'g',0,'2012-02-19'),(30,'g',0,'2012-02-19'),(46,'g',0,'2012-02-24'),(42,'g',0,'2012-02-25'),(40,'g',0,'2012-02-25'),(41,'g',0,'2012-02-25'),(43,'g',0,'2012-02-25'),(49,'g',0,'2012-02-25'),(44,'g',0,'2012-02-26'),(51,'g',0,'2012-02-26'),(55,'g',0,'2012-02-27'),(53,'g',0,'2012-02-27'),(48,'g',0,'2012-02-29'),(54,'g',0,'2012-02-29'),(59,'g',0,'2012-03-02'),(61,'g',0,'2012-03-02'),(50,'g',0,'2012-03-06'),(52,'g',0,'2012-03-06'),(57,'g',0,'2012-03-06'),(56,'g',0,'2012-03-06');

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `idx_sessions` VALUES ('007b2d6917aafd6194b7dd79aa99dc75',1331152096,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22199.21.99.103%22%3B'),('774331ea4c4d323a76d37e12c903adfd',1331153450,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.94%22%3B'),('fc24117a9655e02e64cc3f8d2b8a5f3b',1331153476,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A15%3A%22220.181.108.182%22%3B'),('a233c081d70c4d031e15ca199212a2d6',1331154190,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.5.66%22%3B'),('1129082e107b066da83284cdc2dd5465',1331154982,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.gif%22%3Bindexu_session_ip%7Cs%3A13%3A%22124.216.31.41%22%3B'),('fc97e385cfa53433782966f99f6d082e',1331157060,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.94%22%3B'),('7bb0e5eab5c405de89c84af98e5f0739',1331157085,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A15%3A%22220.181.108.171%22%3B'),('1fd8f3b8b3e3a3d6b6355a3b20d37e2c',1331159359,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A10%3A%22%2Findex.gif%22%3Bindexu_session_ip%7Cs%3A14%3A%2264.178.157.118%22%3B'),('4607aecaf7ca1e1517c45992e1c8fde2',1331159396,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A31%3A%22%2Fdetail%2F58%2Fwedding-scrolls.html%22%3Bindexu_session_ip%7Cs%3A12%3A%22180.76.5.113%22%3B'),('2b4e6a422ddad52eeacb6cc8610f515d',1331160783,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.107%22%3B'),('406bcaf9d415731f3b411eb9aef77820',1331160815,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A15%3A%22220.181.108.183%22%3B'),('d12ea3c8c58d32f78682f546dd3a479e',1331161421,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A11%3A%22180.76.6.21%22%3B'),('aaa4bd846e95db8b3536091e9c2e7d15',1331163132,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A38%3A%22%2Ftag%2Fdui-attorneys-berkeley-springs-wv%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.68%22%3B'),('2792ab5ad4935d9c798fdefda5c2e930',1331163367,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A15%3A%22%2Fdental-health%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22208.115.111.68%22%3B'),('ea1e609fa061a5a0600eba21e6c0ceb6',1331164019,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A13%3A%22123.125.71.97%22%3B'),('32aaedcfe482c47538c8f463d496f418',1331164037,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A15%3A%22220.181.108.173%22%3B'),('612c222c578aa324813f000d95819000',1331167692,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A14%3A%22123.125.71.109%22%3B'),('b0fd54d1cf2beb3e33d0d7637e05f5ee',1331167711,NULL,'indexu_session_username%7CN%3Bindexu_session_location%7Cs%3A1%3A%22%2F%22%3Bindexu_session_ip%7Cs%3A15%3A%22220.181.108.185%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) DEFAULT NULL,
  `set_hook_place` text,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `idx_users` VALUES ('admin','b7c0a086fd7fb859c0a4977e9c2e16a2','Administrator','isabella.remo@gmail.com','2011-10-04','1','',0,'','','','','','','','');

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

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

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



