--
-- Host: ibiznet.co    Database: ibiznetc_indexu
-- ------------------------------------------------------


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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `idx_category` VALUES (1,0,'Arts','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(2,0,'Automotive Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(3,0,'Business Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(4,0,'Jobs & Careers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(5,0,'Clothing & Style','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(6,0,'Communication & Technology','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(7,0,'Internet & Computer Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(8,0,'Construction and Contractors','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(9,0,'Dental Care','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(10,0,'Education & Research','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(11,0,'Employment Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(12,0,'Gift Baskets','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(13,0,'Hardware & Software Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(14,0,'Health & Medical','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(15,0,'Healthcare Related','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(16,0,'Air Conditioning & Heating','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(17,0,'Home & Garden Decor','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(18,0,'Home Improvement Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(19,0,'Hotels & Resorts','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(20,0,'Insurance Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(21,0,'Law Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(22,0,'Lawyers and Law Firms','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(23,0,'Lifestyle & People','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(24,0,'Medicine  Facilities','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(25,0,'Financial Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(26,0,'News','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(27,0,'Plumbing & Plumbers','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(28,0,'Real Estate Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(29,0,'Technology & Science','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(30,0,'SEO Services','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(31,0,'Shopping','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(32,0,'Sports & Games','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(33,0,'Transportation and Logistics','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(34,0,'Travel','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0),(35,0,'Wedding','','folder.gif','','1',0,'','','1','0','','',0,'',0,0,0,0,0);

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

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

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

INSERT INTO `idx_category_path` VALUES (1,'Arts','<a href=\"http://ibiznet.co/arts/\" name=\"cat_1\" style=\"\">Arts</a>',';0;'),(2,'Automotive Services','<a href=\"http://ibiznet.co/automotive-services/\" name=\"cat_2\" style=\"\">Automotive Services</a>',';0;'),(3,'Business Services','<a href=\"http://ibiznet.co/business-services/\" name=\"cat_3\" style=\"\">Business Services</a>',';0;'),(4,'Jobs & Careers','<a href=\"http://ibiznet.co/jobs-careers/\" name=\"cat_4\" style=\"\">Jobs & Careers</a>',';0;'),(5,'Clothing & Style','<a href=\"http://ibiznet.co/clothing-style/\" name=\"cat_5\" style=\"\">Clothing & Style</a>',';0;'),(6,'Communication & Technology','<a href=\"http://ibiznet.co/communication-technology/\" name=\"cat_6\" style=\"\">Communication & Technology</a>',';0;'),(7,'Internet & Computer Services','<a href=\"http://ibiznet.co/internet-computer-services/\" name=\"cat_7\" style=\"\">Internet & Computer Services</a>',';0;'),(8,'Construction and Contractors','<a href=\"http://ibiznet.co/construction-and-contractors/\" name=\"cat_8\" style=\"\">Construction and Contractors</a>',';0;'),(9,'Dental Care','<a href=\"http://ibiznet.co/dental-care/\" name=\"cat_9\" style=\"\">Dental Care</a>',';0;'),(10,'Education & Research','<a href=\"http://ibiznet.co/education-research/\" name=\"cat_10\" style=\"\">Education & Research</a>',';0;'),(11,'Employment Services','<a href=\"http://ibiznet.co/employment-services/\" name=\"cat_11\" style=\"\">Employment Services</a>',';0;'),(12,'Gift Baskets','<a href=\"http://ibiznet.co/gift-baskets/\" name=\"cat_12\" style=\"\">Gift Baskets</a>',';0;'),(13,'Hardware & Software Services','<a href=\"http://ibiznet.co/hardware-software-services/\" name=\"cat_13\" style=\"\">Hardware & Software Services</a>',';0;'),(14,'Health & Medical','<a href=\"http://ibiznet.co/health-medical/\" name=\"cat_14\" style=\"\">Health & Medical</a>',';0;'),(15,'Healthcare Related','<a href=\"http://ibiznet.co/healthcare-related/\" name=\"cat_15\" style=\"\">Healthcare Related</a>',';0;'),(16,'Air Conditioning & Heating','<a href=\"http://ibiznet.co/air-conditioning-heating/\" name=\"cat_16\" style=\"\">Air Conditioning & Heating</a>',';0;'),(17,'Home & Garden Decor','<a href=\"http://ibiznet.co/home-garden-decor/\" name=\"cat_17\" style=\"\">Home & Garden Decor</a>',';0;'),(18,'Home Improvement Services','<a href=\"http://ibiznet.co/home-improvement-services/\" name=\"cat_18\" style=\"\">Home Improvement Services</a>',';0;'),(19,'Hotels & Resorts','<a href=\"http://ibiznet.co/hotels-resorts/\" name=\"cat_19\" style=\"\">Hotels & Resorts</a>',';0;'),(20,'Insurance Services','<a href=\"http://ibiznet.co/insurance-services/\" name=\"cat_20\" style=\"\">Insurance Services</a>',';0;'),(21,'Law Services','<a href=\"http://ibiznet.co/law-services/\" name=\"cat_21\" style=\"\">Law Services</a>',';0;'),(22,'Lawyers and Law Firms','<a href=\"http://ibiznet.co/lawyers-and-law-firms/\" name=\"cat_22\" style=\"\">Lawyers and Law Firms</a>',';0;'),(23,'Lifestyle & People','<a href=\"http://ibiznet.co/lifestyle-people/\" name=\"cat_23\" style=\"\">Lifestyle & People</a>',';0;'),(24,'Medicine  Facilities','<a href=\"http://ibiznet.co/medicine-facilities/\" name=\"cat_24\" style=\"\">Medicine  Facilities</a>',';0;'),(25,'Financial Services','<a href=\"http://ibiznet.co/financial-services/\" name=\"cat_25\" style=\"\">Financial Services</a>',';0;'),(26,'News','<a href=\"http://ibiznet.co/news/\" name=\"cat_26\" style=\"\">News</a>',';0;'),(27,'Plumbing & Plumbers','<a href=\"http://ibiznet.co/plumbing-plumbers/\" name=\"cat_27\" style=\"\">Plumbing & Plumbers</a>',';0;'),(28,'Real Estate Services','<a href=\"http://ibiznet.co/real-estate-services/\" name=\"cat_28\" style=\"\">Real Estate Services</a>',';0;'),(29,'Technology & Science','<a href=\"http://ibiznet.co/technology-science/\" name=\"cat_29\" style=\"\">Technology & Science</a>',';0;'),(30,'SEO Services','<a href=\"http://ibiznet.co/seo-services/\" name=\"cat_30\" style=\"\">SEO Services</a>',';0;'),(31,'Shopping','<a href=\"http://ibiznet.co/shopping/\" name=\"cat_31\" style=\"\">Shopping</a>',';0;'),(32,'Sports & Games','<a href=\"http://ibiznet.co/sports-games/\" name=\"cat_32\" style=\"\">Sports & Games</a>',';0;'),(33,'Transportation and Logistics','<a href=\"http://ibiznet.co/transportation-and-logistics/\" name=\"cat_33\" style=\"\">Transportation and Logistics</a>',';0;'),(34,'Travel','<a href=\"http://ibiznet.co/travel/\" name=\"cat_34\" style=\"\">Travel</a>',';0;'),(35,'Wedding','<a href=\"http://ibiznet.co/wedding/\" name=\"cat_35\" style=\"\">Wedding</a>',';0;');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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

INSERT INTO `idx_searchlog` VALUES ('mysentrybank.com','2012-02-15 03:11:08',0,'203.92.47.195');

--
-- 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 ('b0a1eef4adc3a7880e7b3b5beb293e3c',1330902160,NULL,'EIy1aaUvlgms6VKYRhX2I1Ojjigud7zZ_DCkE5LtrjFkyMlb3I7CjCPGrnmEZqnNRQ1AsKfvleP0hhtPwuzuqndD5vtX7GhkUNXlukAZr6_DRWqMs3u87KCt7xtJtUj8vLdi3QD5H5Kl3c_VKg5Y3_sHYKop-bdryLfEWYZwHQo.'),('54730adcd17a36c4d4d34610ae902e6e',1330902388,NULL,'lYw0CcCRoNxQ_0wBFSxegckd4qv40wHH_7LBZKHeoVVEHUerPkTnd3-45FY0tKsFTEDZ5RqIVD5cHX0KT3a1vnSZgbwnZiSw3DZyNdkx1JIx1HK1mStzbFsRWXaqIlGWdG-MfOX2LlpHaSYG50WBZJnFdljg2fH7z0EKkMWF_ERucy4iEcLj46mmegPxqxaR'),('2606db41598bce09f37fd885ab2976b9',1330902620,NULL,'cKg12KQBuW2A5J_kWRh1nWt4zT04d-kWuqWIZJrPpby_5ladgqUaPNFTn-FMW9m0W0PX_zXGUE4FXwvf8iNVLuqLB2OavxjoNGbkqA70ddKsB-rm6_YLYdI1Y96nv8HjTZFD5c5BqzdOvQWCuIhTilU0JKTCuOQTZLF8yhdH37j_38Hq3l0TIDPKBYzZg7Hj'),('af2591715eb625b2701d9ab6ae204feb',1330902849,NULL,'-gCbDKSIpTpAMGEWfc9gLukMNLecM8wFvxD-OHhIJGSayINcU6xeZyaanJS7XFZEv8Q3AxcXyEgTkLtuu7IZk6hypEiOr9jgRS6P2b08VDjVXyumtgpJy6IKC-EANkBZnr4jEC1lWZOHJC9FHjzjCA2cEzEdqToTt77QBKXdJAs7RwFWTQLaQDzxHW5XIhNs'),('aa8c703cb622df8b9fc03059fba91dbf',1330903078,NULL,'Wvh5EuLR_JP4ihgnT0MJ-pezSF_3ZPK4xQ26lu6NtE6FUqliM6EKoDA7haYdiRIJ6cs4MVBb1eThLZf_60ACJO91yPhaDnPFVwcyxGapPInKDrMlevG4cvk6nmsGdUjA-YGJc5rb9oS0v171vdRHDC_jrbCB8LgDSRBvWxLche8.'),('22f9fd992617e654e7fd9853304c945d',1330903306,NULL,'y-uEhqA7MBZUUNeoqCn3ucEjMJqHaiMV2DNR7DrUQqq8W6N0V0w8o50dZ4pvZnbPSiRp4SOLv69kKeGnWLtP4S1qHtgtY4ULNgJu_jRjKyu8DwZPJA0b298QyLSxeUt8xPKeQxGn3mPyQWnxLqB0DJQp0vpH4xrQnnasH3VE1hc.'),('dcee9f9e01d42362d1a667953b89e012',1330903536,NULL,'0A8owbJilSy8pX1Igt9t1nv1oRHbbSC0gkXKBTgiMRKpqBv7yTbzkFSxEne8YhKjRbMw6ngCV4kuyFahq7PP1iR05yNkLizHeMAzMR2ufs9rypdyt-j7eLTlMS_p12HwHb6CgtOrOmLVM_QX1MO_C0mkw0cQgH7p4eQjV77y3CLuI7KXA8WrG9bBzq2MiFFA'),('2a7936da3a1839a823da4646e78c906a',1330903767,NULL,'0-HiHzQX1JiDFsT5qnGoz6znkZbX52fqSysacnxZ3BheeQmJoZUaN8DyyJA54ZhPySApsndFKthXjHCrdfAdz63xfNplEmxTJTVH8uAFJlR-XYH0Nf9Wzabh881K6kE3X9sDfR0APsuQBCABTPiAweUW0HPU7OS7REqrTShHu_ccOXAdr4gHXGxROj-HZETc'),('092ab2a7c72c117b0045b892f4e28d5e',1330903995,NULL,'vzllLdgZiVr1LUAn0u_CmY2TVaGpv_jdwLRrr4dl09N3am0GqmOUetXfpSM6EOxSRKG75qmmd0Dwu88yhRKj2NPPXQgux90O4aidLx81_sT4sPtdcz0QXUujBZBZ6WHjP5mDZCdQBAYEjw8BVM-QJwG4Kg4VxweoiBM9ZayS-TD6jj-Wj76300KrzkMVlnM1'),('a8c9ba0eb361a65059bc8da6359bcf2b',1330904223,NULL,'p58G9n7Ddco9K4bQGQxMoLeLVXqBBWFMCMrIuPxuIP6QD1Q6X_MLgb3gp6y4VzJaiFIA6nJ836spNbRgDx30JbrG1XAOzRCk0PaZGbyGDmVkwoL4xRBFg4f40Z0OJ1nu6zagQJC7lzSKj6niu3bMo4Co5115a61I0qd7s5QwYu8Cp7hCuWgMuVPuwgFpZNS4'),('b17652b4b88d6531217513a8ee7dc066',1330904457,NULL,'9kQwavOjFVagPg9RNi60CZAvamvbshyK_84xXys46Q7o8Tg0miqZEXJcGR_1y0fUmg6MV03ABjWN2H26Rtpovru5cgTR0Cv5__EAniKvBX-J3RwLkMiS09kHOybK4dM2prNjqhyK5VCCIxkI6oSS5fr8Csipq3OmenIt4Uu4aVXR154K9Sj1YkZuVnuiMUyP'),('7020d5267dc7bcd7255522c2ddacc4a3',1330904682,NULL,'lehuUb7Tcy7MKszA1kaXf4Z-7RG4vFLm3givBETMPrMuNIiWYWptIgSUXSmNkRx1Rvwm5KHPnpHEI9coDpazP5LWfLEmEVzc2zTqxbZUqtBxPzXPB6pv9zFgSKawCh5I3U2bu_5rRbZprC5w1nk7yj4tTQTSOYcesfEY-vj2464.'),('c91f7c1272921a1ceb517e85bbc72b76',1330904911,NULL,'5z6y214KNxCsGOF3toERIxQtKLF0Uwls0IIiNa0ITz6gZODfrT25QbMkmB2Py-439ZrbuofDAVrcaQD2zwhtekpo_B-PZiJX-tzgJg8akpnMN8upKyKN2XRaHc5sdxMe2V7RHvvGFj1UwpSJZRWc13bL6Oouq-Ez26yis8JTBC67GImvUbBRWiCQxO5-DOsH'),('3c395b29124c262b27bf54f5edae4fb0',1330905139,NULL,'ebnVv4Js1n3ZW2JmTsFi-XqeaC0i1Gv_BS9yP2HMCV-y2499EnKp4_5wf6owQDyhHOK-jKiwayf1Vzgi-VDZmlvc4BseiwmDBoQobbfSxuu6nAvNK-3uE3TsAYHwJo8jErRha56AetUr-Ltj8oG4iIor0dbFRRHbdHdJ-0zbWANM6MwOLmVr_b7E8qhxs0Im'),('d093ec088834b3d894a19b4fc50f4892',1330905368,NULL,'BPYGMwT9btnmqloO-JpbUosTV9FMMLnFcAM4lPA8rxTqHP11QCMUeQgVGltwjmIgqaHjrLJLlqSkdaObTc58Inbue2d9KHA2HJisC-6yIG-iQw1PJroQsz_Nebuk9EkeWydPd-9Ar1CPPAe6PGe85x0Lj-QW_3m5l3Vjn80g-Ao.'),('07b05f318ea54bc60a00a6531a578280',1330905913,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('81212d346928d7b58ef7f28acdf64d4a',1330905913,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('817bd2dc5f8f6fd72adbcba741f55894',1330905914,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('47c21cf6f50af4dc7d69f3557b11fa31',1330905914,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('8f2e3a82175e71c8abc6aa95664a192b',1330937913,NULL,'-WfCKFhZvcDxdVRLgBMCVKRHFjEGse-T_3d1LCCsTPCm7O4asRz_Co9tsv3i0YPtEoOIYDkqdaXdtq1S14UCFDwX-lzZhf9RAqo9y5rzDNC19e5l2ycShjwAoY9ePv9EgAatcO6AKCkilrnwJ2HXFB_X2nNUJKspd4S8GLFa9Ms.'),('eb2c3c75bd813088bd707537d2ca5282',1330937914,NULL,'3WRwuAzjlSYbuZGoo_gOrPZe2HZTYlEKzpdk55QkYRNlJeRacfUVb9tyDPMYeBsg_HGatmYNMfxH-hqUfbnLPKMtWTxoBrhUp0TCDsnscp0PCPi-Kq2z6gNX0A1j9Z6xHe17YJXa1Ot566GpMAmlUa4ZvGkE1-6NZc7dG79KfJc.'),('1172329abbd7a18f15aadc3c1e1d5587',1330940287,NULL,'3XU32cTg_huD4NeVfXnQzC_RY_aGOy0aMhPvjne53I-0Aqd7MTTKofAo_mOYGRVNbKjzNMsyn8KsyxyJYKTTPeeWr8TlFtv2E0SYfJ3wwliPj4j8uPsmqzngkwxFKWc203tGJf_ygBWjCfNqgEAMENErCHkXOIlR7TciF7PL-Ug.'),('0abc5f6082e566b490e3a2c65a5b838f',1330941955,NULL,'MfoOjU5BOYnOVkJnr5Kn8jG_eVUYWJOalJugRJouYbgUuBGAzr87-Iy3HLR5NMliTSITJj5P04el1f7eByYCH5uwlrTCM2bidJN2KXUWOssY9lBBiaL_AqGApKsfCkzbNhkB9f_6FhXt2k7NvfH2Nk5MjYYMoW_6ti09cCwjmmk.'),('13ed5ba78a9972362822d2f2a9ab5e0b',1330945808,NULL,'DHZNBYm0T6kanKpZfLnTzrL8FSAEaUtmDjbHXPC0xGcYnv3ejGrkiLaOKkkNr13r6he8qFjl5kUIyVPhUhYCFS0YiBSA-8cQMRPoeJugc1eVgnQQ9m8YhzTu3eqfoI1uVREf9LxIHNLtg3R_CJeHCUS8l5PnRB8yfB2x53XN7FU.'),('8f821d62dd6bed432886323c2d077f4b',1330957352,NULL,'Qu4tbUxzFmgOG84VvnCv5RQVWpP9PvDaCHEsEWLnAj38M9vewvxwVM23C2kLYJ7LnBqpBIHcemiiFN5F4HKP7wihJzZWXYhwA9on7FViiCtgLJhO2MjJ91L6OSDePpTvG99EzXoitxJRSbr5sNVtHlER7oforkZC_GZMoYj1t7GmPkn7ZgXzAO3iLAy3mJPk'),('800588b8a56b48978fc9c86e179484be',1330958862,NULL,'ITGbneY7W_vcYluweVjxUQEJRjqOraVHLQ8FP0l_UAHTbb7czpzc0IGlON_3ZW6Bw7e_Vq7PQfcCEjBxVnn_Suztjm24WyBHJVycca7vLLxgc7MgvZkwtE03fWtU-5H1dN4XUtA1gcMopnxmok0f7Of20KJby-HR9QbkbHbD7gbPJxBA8wD65_6Nj90eEi4s'),('84a5ffd9ac22ce8579d1008bd15019c3',1330978231,NULL,'RTTjReXB30iD9F1rq09uBQXoZ1lJVBMfZB9VLug83RyUK4pnkHlJ6M8hkd-CJndfmz5McAiORyWSN9QuaTPPuuqfuzV47gsa2gJ4mkPN6qkKMfr0TaVoCqNBf7XdIqO38OmQJNRRlYc3O46CSK5t8Ha-jNR4HmczsqaIny8S3IQ.'),('2522ede9011efa4844014db424452d87',1331000057,NULL,'gMlLUs_qb_UxnBQodq79Xf4rRFq0dw0CkoLemUU3WhiMSzDXO455EvhSPCNH_mCFqKLI-uSYHIrIn2oZmHHAaVbYr4TYMcKh7rPFAmzgnuOPV6folpqp4c7u4yRa4dM0YXEl3YjL_SGaG0IWepQqReiTSW5ij6J17bj4z-uaqvOCWRc1LULxQLwM3f4K85f7'),('2060f73ad78fecbc758c3cfed3ff0b08',1331004798,NULL,'qj4hxeEEB4fhxC8h_lY0mJJALep7pmWlotXNpe0C-qIl6x3rYm-Qvco0ak_rMm-et2xqAn0Q4-aNLWeE930QPRRc3f7YkRCygq-IhyxRGxOk56ob9kYeNii66r97IKy0xIpqS36UkHSRefqf5mXMDozCOTmBg9MyN755lZNQ3HQ.'),('a77ed8e391ad6f79eba12493c1ed5b21',1331005223,NULL,'V_zENIpUE24WGS6_Sc5kWuVorFPSbacN9P_QF9A0hpBMCccMq1dZlYXtV0uloqckxZgGefx_d4P7sfwHqrZ_eWEZ6i1D9AS6jQBo_msfdCDO2Zk-yXpWNdzJh7syPGZPd_czsatRaMyypopG5DEnGDOXPyJR5nBqxbMtYuIcUeMP5BRtSDHsNofr-BoG3yIy'),('be9f1b79998cfff25cacc0d7aa9b5ee4',1331007723,NULL,'14cTPmGpcghhWvEXDiRq0aFvTGnIvbv672CwqLzEbUtTOgZjn9XPBLOUktEAG6WBDYcvoASxRt54J4t2KrXAavQ87_f3TplHI_1uQFWsXozbigDMhr2D25aGcwwX2ewyixAPtE-iBB8iSf7xseafrOt7uBnMISPzmlGUb4J_GkCZVE06USlTN4tb8tWrSoYC'),('9cd481136e899f6e82dede68be30af6d',1331011832,NULL,'Hrwz88AaQkzkS_V-cEtflHtEzESpj4lTw-ZH9QucFAH8uDMqUeMwprEe63R11r6yFYpTb7aCDHlIVpJSKkdtSymdxQz709-qEqgAqpAdg1kq4Vk991wCfv6GxN9x6rRlyDWI9oG2y-WshyIoDbO-emzxh3b-BTTs6sdeqfi79zg.'),('2b4b8f978fda461b3251990cc230ff3c',1331015796,NULL,'m14G45f4CqdFt18E-nxc0yu473u5QikPBV9VouuAN3g-nP0AJSjDpkPD28jt2lg2OnKvqmS_q9_DGhxc8G8OscDRhJ2Q8xJs9y-CiKV4b2R6Q9sjjr_wO39aTEBauxzbWHdbOO-k3QN7Ei5SvKdvexTAk9qKlCCmjV23xAv91eY.'),('15b7340de79880ecfe4dc9938c5499a5',1331016675,NULL,'wSwk7dTbYEjJQrcbijqUIXsG3mQVoraIEY_GgwMgI_p088ZdCDZtL1x914vyGr-nmefmRWfbOJd0mFmOn9vGMn7ohso_GWcnRbZcHa0y-ELKIoLkNacB5q--op2QBnt2NoSWizkqvpfuls9qmJSJO076rtxwqvPZZsig__7L2bw.'),('16084019fa0b7f2aaa60378da5730cc0',1331019911,NULL,'WcPJFQNKDiXHlbLiKlb-z6ztXwlqeb5gt72x9HzuSQ5K2dewz2dD6Ol1W5tvmOJMJanI1xOOHIS-rbaNPQcl6obx8qRncy9HRUHbpPnjSO42PlYbbsEj5q-IqoWpFml-q5XisYl5NB03NCiVFSPoVrYTOC9hFHrqq0ZJAJPo9_0.'),('5fba87fd2220c9c455e83db63907e9a0',1331019952,NULL,'n-53ne5KSv-pP-k1BPMsu_IQ4N2vxr7A-tfmIdkujJqq-GI-gJNn5rxexoMb7VLNeeDznogZo2Ay6BYBF5nAHklf8AGTyTF2GQ59_I7dLE-KKl2cY0e6pZ6ShTnfWALS6Aa2c38kM96w-KA7zwquDp8WhxUbwVx7iyqGGYY6k1RVDQQTJs79Yvywu32gTWiv'),('5d73137eae7e6b1dbed831e3071bb128',1331020066,NULL,'3XU32cTg_huD4NeVfXnQzC_RY_aGOy0aMhPvjne53I-0Aqd7MTTKofAo_mOYGRVNbKjzNMsyn8KsyxyJYKTTPeeWr8TlFtv2E0SYfJ3wwliPj4j8uPsmqzngkwxFKWc203tGJf_ygBWjCfNqgEAMENErCHkXOIlR7TciF7PL-Ug.'),('dafefdc32b055403ce2ac6d19494f261',1331023995,NULL,'qKfLAUA5WQ5VmvU2x3f7EWpRzlHFG19EVz2HJPmarWj6_x-7K8uAP9gZoTA7vydIOeoFIJWnLXKJBeonczWC-FX5NCgooqCIu57AAiavYrZxqOfoB8zJwyx1vNnAl9PPGWQz9ZfgBKgZW8sk3SSUCRYR0R2PP3RKhgO-VD2ESo8.'),('983ba6cff010bcfc7ffcd4d82426cabe',1331023996,NULL,'qKfLAUA5WQ5VmvU2x3f7EWpRzlHFG19EVz2HJPmarWj6_x-7K8uAP9gZoTA7vydIOeoFIJWnLXKJBeonczWC-FX5NCgooqCIu57AAiavYrZxqOfoB8zJwyx1vNnAl9PPGWQz9ZfgBKgZW8sk3SSUCRYR0R2PP3RKhgO-VD2ESo8.'),('2cf25ad938c70dd97219240a64758ae0',1331024505,NULL,'k49JtuhY5Tz7cj3D4uwlAUFsiM_AIBjOHeyiJHbCXsdTLjXrwZZp4mCoN7Kyoo8p1KU1FdK62Z1kPPKlZdoTdDVvTeRsLW5HS9u2iZZlsv37SzW6YzJaKxY0eWoCEn_Zp7Yi4ojkdbox-YNM1DSjzO3Ete1WOB1s5NLUIN9OuQq_OQE5PR4oqBtFrXfrkaNC'),('b54d300d85676209ecd36433a9b30a37',1331025298,NULL,'hDKE0hAywypM9Q3Qzq7Y9Y1Dvb42V3hH6aHvw2Ol9JyPTQj8zXgHdpsWgr8NAlYYVGUApBDAZTJLpA0ryST1_uC0fhS_XSe0rD-YWEl9oICnJeStd70hCW1AXJCeDCeuHQdeZeovYXdNDt-VmH4FNA..'),('6d8be678f904dbc99f59f43bd7c6bb27',1331029421,NULL,'PezdncNf8Xc1o7mBmMx2VdqSodonOu-wafmMCxxmbsVnsLi9QBR-mKgIy0ykBxn_5mkb0cWRCZJ2-KFwzUxhE0GGq-NNu64Ghrhv_Dd8FX45IMwfP01CwY4tny4xKRZdkuh3wKE7M7z4ODjhlv01p7Mrn9Rd3r6TbJUpQ8MbSKM.'),('74cb80ef5e9049727dcaaa08db2f31b1',1331034860,NULL,'fGYwAOg4CcRNUhMv5oMQnDmNT-eAKTV6K8cIQv4mI80Z2wKrcWCY_G3GfJLdhbGWanqEALdvvi12QOtI6zD5zhDqWAz5D3_ojqORBPf0szCrWhIOFD02GYggX-f467bxB15Br0zduCw_HKTEwaDpCqaw1WfxmLIEANnvPsq31Hk-Z5MQukaUFJnd8CYJiMd8'),('c6db70c3c6b19996f3e496d247ac648f',1331038250,NULL,'zKdovfm_eKq1gEF_TITbyGQCbtvX-AUEmlVUdkYkqF30dcEzWehMIHxtlGQ2-M2lnF6kz-sE2xxZkYuMLUmC5XIeNsfcAGvSicO0S0rhQ4qJ-9fp2PgQ9rzneE-KW98SSroncWToWp62VQfYCoYFETPWZb5vCw0Cw0UdSLi6Sn4yGnaM9gQmBRErKrGRkhy7ydYyraImDUmeqHiOXHYaWQ..'),('40460141cf964e0892a260929b538d45',1331038341,NULL,'ejKpaufnVHBtxGr7xf5PrUDNJfqcnJ4cDL51k42TsnAadGiEHzmxI_3aCM3aJoDrTJxroQLjCSIJLC3QnSJ8YeJ1GJw8YwGuu3_qjL3eCHJqhDagEOAx2tvBCsEQeEjNsf7Tx82ZFKpGct_mmqnfFgtX_rYMUB0tpsqW7areoYU4fVnrgMdNodYAi34ySnSutYFQgyHFwsOXcC1-O7gQuQ..'),('124363f931ddf18c0641cd8aad821e75',1331040925,NULL,'-k5dr8svUANGwQjftdQkt6WIouTtATo0FydGK5axMSphNYRA-SgvRxb0xJ_2qHm2WG4oYrGw6N_oCdG9iteRumLgkhe-Gwv_sg9IZ25NIIzrKq5y2N1TbeH2WcoU9CQirPez7TVej3VWLpAUvCXiEOQVvELjoBe6gh_StVXXdE0.'),('612e67fdb6e4a7f197c58344b6b314f5',1331047392,NULL,'JgI-aL1T8VUQdfVRV0GWDoAswX4wOcJ3GOdY4LmE6H6Xd_4AhhqLi5CUrMUMXFg0-qdh1k3x8jnluh1ou2yhfA80e7-ScIBye21IU4VRbKWi0rqFFVVlUyn_-lCYVedHNlD2JNZT-7Wd7rXjU9wsYZMqbRci70cQmjVQ3EZbpMBPBPjfDAnw45JtK1HQH9jM'),('95ef8d25a98239cf6db84f3ef8aac144',1331054146,NULL,'fwQ1oyesi50X97JZvIJyvLhz1Y65fjMm-iEPLhNZS7ykfY-pD6ma_HkKu9oRop8WgFREE9ISa-8_lKwhE4RV0FsoC3XmUlakmUiHpVxxJimJ8dSbnWZaRSfhgKdYSmGGzkdIaL-Vlbp7Ns2LAoSMW0qFIlfeURw_Dx5YCpS56QHJc_yJFIklKTlkB2MabEDk'),('5281f5fe0d571c72c6f107a2d55df68c',1331054982,NULL,'tnOjrL50bLrc-IGMu7u3ZQaM74hFRr_njdHV7xVeTtg1Qp9KQkK12Pyo8lSpr59W2Duu_-vHgxUYlIzjlcM41hGgaPZ_xntQ1vGhFn5EM95f0A0N2ERdnmDbdftNdu_bdNAnjWJZLeZAesnKfreON2qq3UDnhT4zbXTUkfJQnvo.'),('fc4535ff5393ebb1292223e596fae6a8',1331060979,NULL,'iKl_ISbPMHh-Oe0YCtDfWJvUtxeYfUIpX0vB0cdW7qqHsJi472bwiP-qIdIMjNwtR5rwNYjl6jCp9TzdPa24eqQDvtGmuDmfrjmTWnlyJQbEcpCy0oUsBr7i3jxMix9wdOv3uB5nmuLKBptuXy-ZS4LE6NPOHC_RAxBLa3tldlU.'),('9e42ba4b775c7e896dcae42f7243a210',1331064232,NULL,'QxKXusSHfU_CKzcrGhj3sy2PWcgUesD3WqtLW_indQj9WZoAuiGdNw2rMJxKMOkj7M7qKrnPm-r94nop2uabYdp2W4iJgiLDIR_JFuAh8Acj-QNUG7axXf-9LkAhHkgVPqmr6qJAqQJnoJBnDkZjqA..'),('d807d0391cc5934180f74722cb97cace',1331064233,NULL,'eGBdZdLMnDqDysAefX8H81bncqX1Zywm6g9JZCWfC8DPxQ8CJZS46VzWxLmpn_atv0I5hF-lgiSz3cwgOCFmsqWR2MPgP0ugQB7r8Ug3C9qi4MMJ2VL51FXJ62A5kN1ZtuAscIBsyWH627-Wd6p5hKcuLsvqtTs7_kLCKz7-dtE.'),('8d4867482a7e8a3dab5a0df4129b89a9',1331064234,NULL,'4TMm6ehhd-kJSX7xHiXduIAY0WYiE-VHsu56-t8alGupJLRVEUfWreKhINWsNb6Tql39uIIW6_OeFB8hE176WYSgnD4NbLm3NtQidifTMrgSYSA3VyaRH6Ae4WIAqyDmVQpeoKLtX3qLjQuo2gp708I9H7ZI_DUhjQPNQHDlrh6mcGQm3qG4sFYzKUJ8yev8'),('56ed520ef84bab6b30a184ddb02064ad',1331064234,NULL,'uqVospkwnho2Qshbu8dzSxJ6gnIlDMzbIZRJGQPQGkFsNUZNVCTekt8U5fITvVWl_b3_Yt_1zxMn74EBr0AeNnVW6nUSdR38Nru0NGAOvv8nz-9J-GO6i2T1vSt0HhDYCX_y_gG9VlFHt2VuCB21cS9P2Rl9M9iAr6kVHy9_QkVUlmZXGUlNvNbakHIJCnbC'),('4d1ce3d08aae01cb7c5a3740db805fbd',1331064235,NULL,'Baejv745wQl3gFnspxi-_Y-xRnt20jMdxvQkPc-pxLXNdIo8rILWv35U2-jqBcoS0vhKTfb_N_ejVP22MkRSHTlUsSNsMXxIs_X6G6mYA16Sax1kt8g7HCtux27npSP97nGvkHaciwZJFSIm9cm0jZK2RcH2xUzuSNQshAHCYd4.'),('1bcad1ab06e9640205463676cf42b6d1',1331064235,NULL,'bxIAV5JWjmf3rTYyT_5FGTj4kuFTeenLEYU2VzehZILIRpMh0VEOmvij6Emw9fujgEuWrw8E98-qEdtqGu1_yvitQ6ZJMATfgg3Gsivg9V0hrJfhL5_j_evAJ7CN94mZUGB41el6s5iN2Ad3rhnP5fmzJlRnZx6rJin-QVX1A_0.'),('a41d94ec652519ac56c969396b683e0a',1331064893,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('84dceeb2d364ff1af237fa715dc0860d',1331064893,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('c41c69e817b3a51e77ec78b12d4686b2',1331064894,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('e7e66e9128d4f7688543af0b156d1061',1331064894,NULL,'floee0VJwAT6eCTRHpgK5VVG1wppk7bQalbPrlI97dD_ZmUlHm8IVFUbXdJl1MwNGcUwC1IDy1avtedQf5jHvM-q5pxSf4SI7Bs3eUD5LHeFSZ41S0hDMbxKOV0pGN2ZpStFv3gxHl1QIC-me6e8g1c6NLSiX_igjs5qeYfUN8s.'),('d73039e59f655c1ae79fc2ad333bb1e0',1331067697,NULL,'qg4j34n9FzGZT8rOGdme-AT6NLApnQ1U19DmSCZ1Bh3Nk52k9jAWe8fjbQ3ZXuFpGjlpZ3R1SIR2s359X9-WU0_fE8JN6PvkINFNcvNH7TJCtJPvqlV84beKTUlrtwQ-Hy28WTRh-h5BuzZ46Jl2FDQ9j1WwvpaEXBXlHa4qwd06paXpAF8l28uhi1t9ju6y'),('468754aa4b7c5d3491fd91f70f53738e',1331074424,NULL,'y1RXIFRmBa6im7n9rwBKjR22F44EXPmk1JKKC8_RObiJeISxrvhr9rCMVMgot_KxOq0vZCvG75o6n4UZBcD3vaNMFOVp5UrxkYtL9wOeDycYNDO5u2NIQyoqzFDXkYxZi_YPZwOWVI85LAaK1EIeYC-7wO55X4DZyZGFYaX_Ipb57yr-geIXkEzRW9IYLIiZ'),('09e42cf75b761931736d5a3ef5200b1e',1331081054,NULL,'yjiEreYQVjg2rcWdTKLcZ9QpgWTx2kRnvHQJwTRYGucD40zoSq2GYZXQUtgYUXVQQFT6iqcXVSCC9lWrGVfU9-hZym6FKUHug90n3YsIxw18cHpWDv_Pq2AeplWxk7NWyKEmHH6FUIbeP_aryuSH75JW5nqPKVSC8jIltS9EQpA.'),('dce6bac6433ab4a803553f6decd3c506',1331087665,NULL,'OZ1kgSCHhu05qK45_2h5HgY__59RSYVeFUvq-FMvhb2tqPT7YyP53XlHFrkWp3hVAOwleHgaE5nvNFpV61-kMjn3_JuyJqWykviJEBebn2D91i9GMw5iEpdj0lcw3qW7p76M7LfuZdk254oRL6ks48Pxdb79oChwVmsm2Ts_5TVcOg3yH6ek25dBiUrItnL_'),('e7f33bd7ab26f911eccff6cab4b999dd',1331092021,NULL,'WE8siF1FIEOONOfLW47B5c-GwEDgJDUAHxQt7ut0lzDy9wFVNNmYnXUvlVZM40NuhV0QywhWc8rKoI7EpKS26nQDDleNSnSTXuFbbh5blKbz2aHA8cWzxFi11fGgV3ULg2ZQr9y8lwpnD8MXo7-diDsbU4uO-prtM4TubpuQphM.'),('34a4da3411e0939639493154ae83a739',1331097716,NULL,'mBCGKshgdgQpLkWq75FNk8EEAxxFR0XVBlyW9XcSevo8nFLNEz65pDle-xbGk1nPRF7Gj0lxQ2ReSdlSxzEO4vhRhGX5cckECgHxcsbhrsR7SYWqYfPhVu0s0Rr0c_6AvdFpVMbTiZNSSLcOLaAUADt3fQRMyYT9uV5ZImcBGeQ.'),('0fcab81cdc1abe8196f0a4c398d3164f',1331110773,NULL,'qNN7-Lm12yGcAqYDpCXG3JDpgBpykJHvI7stdEvwSBPBWHMYGTR7Z2mtO78rjhOK3b8pxo0RFuz83Od_so_hpk1douTGl_2ImSAZiKV3o0SGMdZvPml8nJcMAK3h6KtPiZ041MA7deHrtFE66BtvlT_giNc8LZo-JFuWN4Anj5W2oGQjkbwkiOPcXcEg7MZ-'),('107d8864b0b9e795c13544bb965a2a1c',1331117228,NULL,'sYkWPs3A_iFy_INBC9FKJDqkyRuP2d07In9Jebl7EwdcBasSUbmcqnoUEpZrcaR3amD7kv3VLlSX9looIFHrJXMmEhUzSEoHfS8_LKe6ruZ6cyGNLSF0imXzN5dJjQtuWhshy6jaxT-Bm4EvW1_c_GgrlTwQoplXCBv6siPmhK5fzB43rzfVp_Lp0hWy2VUb'),('d1265989cd87264347c6990d69076f4c',1331119124,NULL,'MjnPXQ2nbZCIvM3S8AV2uZIcZDkrf1jrCD8B7Tc-4szR6WvzOcFCbNULKQ6N3NhopBJYr5eojms8oSUe6QeDh-lYKK9iphUyllMriW_YGa0A9wgxQQ0ha0oLvzMaZri9Pb9qinrqbdhq6kTkud0TJnJkS6bSNSwstzdEXurrLW4.'),('388c494d7336d87d1f09143c0f8e0849',1331123534,NULL,'_K1H0CisxH8cNiwI-lVr2ld7iQ1Gw_Mho7b1p5fIkmYRo47D-TYI8jsl1521cbXXCcTgYhZcK6IKgdjYfBtQRCLkfMjVX3AygD9DGt7rOJVfNNBvnCC3nnSVpSfuu7YpwoKwGzPuSlVyDmYXFDaR4EWuU6IAH6cwl_e4J_d1h97i1KR4MOAaQOnt-uQ8T3qL'),('cff8e70697b6544f441b84f551c15230',1331129660,NULL,'0elOBlhazQ3c-C7OIPNtPJSYkDJH6PLSQfELmXj9cKkxdvjPRmcCNpGcjPfHuhncb1At_jE8xzQBVijlHdaKwTd4GwuhOtjFI4OUpCFjuIwxdeJZYTSQoOtfn23tSfWJa2QcackGFvGT6Rk6SbYEalaHXxsfpt7xP6E6AhSmV1sky8YBRb9AyoWLyreW1z5c'),('79616ba9666841fe2c620abd348195df',1331135633,NULL,'jBP4KYJwPXrOr0JjpkfJRyHuZFMjZ4KwSF8KOFbnhKCh8ZQ1rjAqolg5R0MWWgD6DxUD--mMZ8tpuyITLfhR4iKujLRolzO6rPYKyiQ2TCZ-gKvM70jE4rgT4YMdcig3yb3tcjM25UsnPjcGRFPsWC5EyddFFeqtwpQRu4a0Dt91093eO5pjqanDU-1rEd3s'),('4578b0b9b1f1c4fa2d14bbcad0abb131',1331141526,NULL,'lQeByxrp2PRrho4av1TBmNvvugVzP6insp2vtWn-v0p-4oh-9x1Keko0RKeItZAUeTNVzVzH6DWvOc-VjossguWRoQ6VOJkr6mW9Puj-WWMPpv8ub4KzLYEgaUM25pd22xqq2OEnnL2b_e0Pq3BvO3BrsJLuB-bSEk0Ihx6smH9CvsDFemWYAffLh-iORASR'),('03e4237f529d79f69d8f753df4b55ce0',1331147153,NULL,'m14G45f4CqdFt18E-nxc0yu473u5QikPBV9VouuAN3g-nP0AJSjDpkPD28jt2lg2OnKvqmS_q9_DGhxc8G8OscDRhJ2Q8xJs9y-CiKV4b2R6Q9sjjr_wO39aTEBauxzbWHdbOO-k3QN7Ei5SvKdvexTAk9qKlCCmjV23xAv91eY.'),('d2053d03e1988780fe010a540ebecf82',1331152761,NULL,'dOc8DbRKJLAXcYjzjhqjdeKoV2IWqhTqz8N2skIHqaodsZzh1cFtjNlcdhkVU3qkEv0vcB9u28I8OQ40fCTnWvyrDBek8GQlS2SjMYo8Rlt_T2ownXPfBEKpHsrlJGs0wcoN1w8oFy52WIeW10pJSH2VnfTyd6OIU_kL_668kPI.');

--
-- 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','ibiznet.co'),(5,'site_url','http://ibiznet.co'),(6,'email_address','julie.reitherssly@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/ibiznetc/public_html/themes/'),(9,'admin_template_path','/home/ibiznetc/public_html/admin_tpl/'),(10,'plugin_path','/home/ibiznetc/public_html/plugin/'),(12,'active_theme','_ibiznet'),(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','julie.reitherssly@gmail.com','2011-11-16','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`
--



