File: //var/softaculous/esyndicat/esyndicat.sql
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `soft_esyn18`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]accounts`
--
CREATE TABLE `[[dbprefix]]accounts` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`nemail` varchar(50) NOT NULL DEFAULT '',
`sec_key` varchar(32) NOT NULL DEFAULT '',
`status` enum('approval','active','banned','unconfirmed') NOT NULL DEFAULT 'active',
`date_reg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]actions`
--
CREATE TABLE `[[dbprefix]]actions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL DEFAULT '',
`plugin` varchar(50) NOT NULL DEFAULT '',
`order` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]actions`
--
INSERT INTO `[[dbprefix]]actions` VALUES
(1, 'action_favorite', '', '', 1),
(2, 'report_listing', '', '', 2),
(3, 'visit_website', '', '', 3);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]action_show`
--
CREATE TABLE `[[dbprefix]]action_show` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`page` varchar(100) NOT NULL,
`action_name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]action_show`
--
INSERT INTO `[[dbprefix]]action_show` VALUES
(1, 'view_listing', 'action_favorite'),
(2, 'view_listing', 'report_listing'),
(3, 'view_listing', 'visit_website');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admins`
--
CREATE TABLE `[[dbprefix]]admins` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`fullname` varchar(100) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`submit_notif` enum('0','1') NOT NULL DEFAULT '0',
`super` enum('0','1') NOT NULL DEFAULT '1',
`status` enum('inactive','active') NOT NULL DEFAULT 'active',
`confirmation` varchar(32) NOT NULL DEFAULT '',
`date_reg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_visited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`state` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]admins`
--
INSERT INTO `[[dbprefix]]admins` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', 'Administrator', '[[admin_email]]', '1', '1', 'active', '', '[[regtime]]', '[[regtime]]', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_blocks`
--
CREATE TABLE `[[dbprefix]]admin_blocks` (
`name` varchar(100) NOT NULL DEFAULT '',
`plugin` varchar(50) NOT NULL DEFAULT '',
`title` text NOT NULL,
`order` float NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]admin_blocks`
--
INSERT INTO `[[dbprefix]]admin_blocks` VALUES
('common', '', 'Common', 1),
('categories', '', 'Categories', 2),
('listings', '', 'Listings', 3),
('plugins', '', 'Plugins', 4);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_pages`
--
CREATE TABLE `[[dbprefix]]admin_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`block_name` varchar(100) NOT NULL DEFAULT '',
`title` varchar(50) NOT NULL DEFAULT '',
`file` varchar(255) NOT NULL DEFAULT '',
`attr` varchar(100) NOT NULL DEFAULT '',
`params` varchar(255) NOT NULL DEFAULT '',
`aco` varchar(30) NOT NULL DEFAULT '',
`menus` set('main','header') DEFAULT NULL,
`plugin` varchar(50) NOT NULL DEFAULT '',
`order` float NOT NULL DEFAULT '0',
`header_order` float NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `[[dbprefix]]admin_pages`
--
INSERT INTO `[[dbprefix]]admin_pages` VALUES
(1, 'common', 'Admin Panel', 'index', '', '', 'index', 'main', '', 1, 0),
(2, 'common', 'Configuration', 'configuration', '', '', 'configuration', 'main', '', 2, 0),
(3, 'common', 'Manage Database', 'database', '', '', 'database', 'main', '', 3, 0),
(4, 'common', 'Language Manager', 'language', '', '', 'language', 'main', '', 4, 0),
(5, 'common', 'Manage Admins', 'admins', '', '', 'admins', 'main', '', 5, 0),
(6, 'common', 'Manage Accounts', 'accounts', '', '', 'accounts', 'main', '', 6, 0),
(7, 'common', 'Manage Templates', 'templates', '', '', 'templates', 'main', '', 7, 0),
(8, 'common', 'Manage Blocks', 'blocks', '', '', 'blocks', 'main', '', 8, 0),
(9, 'common', 'Visual Manage', 'visual', 'target="_blank"', '', 'visual', 'main', '', 9, 0),
(10, 'categories', 'Manage Categories', 'categories', '', '', 'categories', 'main', '', 1, 0),
(11, 'categories', 'Create Category', 'suggest-category', '', '', 'create_category', 'main,header', '', 2, 4),
(12, 'categories', 'Browse Categories', 'browse', '', '', 'browse', 'main,header', '', 3, 5),
(13, 'categories', 'Category Icons', 'category-icons', '', '', 'category_icons', 'main', '', 4, 0),
(14, 'listings', 'Create Listing', 'suggest-listing', '', '', 'create_listing', 'main,header', '', 1, 1),
(15, 'listings', 'Manage Listings', 'listings', '', '', 'listings', 'main,header', '', 2, 2),
(16, 'listings', 'Manage Comments', '', '', '', 'comments', 'main', 'comments', 3, 9),
(17, '', 'divider', '', '', '', '', 'header', '', 3, 3),
(18, '', 'Update Version', 'update', '', '', '', NULL, '', 0, 0),
(19, '', 'Sitemap', 'sitemap', '', '', 'sitemap', 'header', '', 0, 7),
(20, '', 'PHP Info', 'index&info', '', '', 'phpinfo', 'header', '', 0, 8),
(21, '', 'divider', '', '', '', '', 'header', '', 0, 5),
(22, '', 'Order Change', 'order-change', '', '', 'order_change', '', '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_permissions`
--
CREATE TABLE `[[dbprefix]]admin_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin_id` int(11) NOT NULL DEFAULT '0',
`aco` varchar(30) NOT NULL DEFAULT '',
`allow` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]blocks`
--
CREATE TABLE `[[dbprefix]]blocks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '',
`contents` text NOT NULL,
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`lang` varchar(2) NOT NULL DEFAULT '',
`position` varchar(50) NOT NULL DEFAULT 'left',
`type` enum('plain','smarty','php','html') NOT NULL DEFAULT 'plain',
`plugin` varchar(50) NOT NULL DEFAULT '',
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
`show_header` tinyint(1) NOT NULL DEFAULT '0',
`collapsible` tinyint(1) NOT NULL DEFAULT '0',
`collapsed` tinyint(1) NOT NULL DEFAULT '0',
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`multi_language` tinyint(1) NOT NULL,
`rss` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `[[dbprefix]]blocks`
--
INSERT INTO `[[dbprefix]]blocks` VALUES
(1, 'Featured', '{if isset($featured_listings)}\r\n {foreach from=$featured_listings item=featured_listing}\r\n <div class="featured-listing">\r\n <a href="{print_listing_url listing=$featured_listing}" class="countable listings title" id="lnk_{$featured_listing.id}_fea" {if $config.new_window}target="_blank"{/if}>{$featured_listing.title}</a>\r\n </div>\r\n {/foreach}\r\n{/if}', 2, 'en', 'left', 'smarty', '', 'active', 1, 1, 0, 1, 1, '0'),
(2, 'Partner', '{if isset($partner_listings)}\r\n {foreach from=$partner_listings item=partner_listing}\r\n <div class="partner-listing">\r\n <a href="{print_listing_url listing=$partner_listing}" class="countable listings title" id="lnk_{$partner_listing.id}_par" {if $config.new_window}target="_blank"{/if}>{$partner_listing.title}</a>\r\n </div>\r\n {/foreach}\r\n{/if}', 1, 'en', 'top', 'smarty', '', 'active', 1, 1, 0, 1, 1, '0'),
(3, 'Statistics', '<table cellpadding="2" cellspacing="2">\r\n {if isset($num_listings)}\r\n <tr>\r\n <td>{$lang.total_num_listings}</td>\r\n <td>{$num_listings|string_format:"%d"}</td>\r\n </tr>\r\n {/if}\r\n {if isset($num_categories)}\r\n <tr>\r\n <td>{$lang.total_num_categories}</td>\r\n <td>{$num_categories|string_format:"%d"}</td>\r\n </tr>\r\n {/if}\r\n {esynHooker name="statisticsBlock"}\r\n</table>', 4, 'en', 'right', 'smarty', '', 'active', 1, 0, 0, 0, 1, '0'),
(4, 'Accounts area', '{if $config.accounts}\r\n <!-- accounts box start -->\r\n {if $esynAccountInfo}\r\n {$lang.welcome}, <strong>{$esynAccountInfo.username}</strong>!\r\n <ul class="account-menu">\r\n {foreach from=$menus.account item=menu}\r\n {if $menu.name eq $smarty.const.ESYN_REALM}\r\n <li class="active">\r\n <div>{$menu.title}</div>\r\n </li>\r\n {else}\r\n <li>\r\n <a href="{$menu.url}"{if isset($menu.no_follow)}{$menu.no_follow}{/if}>{$menu.title}</a>\r\n </li>\r\n {/if}\r\n {/foreach}\r\n\r\n <li>\r\n <a href="logout.php?action=logout">{$lang.logout}</a>\r\n </li>\r\n </ul>\r\n {else}\r\n <form action="{$smarty.const.ESYN_URL}login.php" method="post">\r\n <table class="no" cellpadding="2" cellspacing="0">\r\n <tr>\r\n <td>{$lang.username}:<br />\r\n <input type="text" tabindex="1" class="text" name="username" size="18" value="" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>{$lang.password}:<br />\r\n <input type="password" tabindex="2" class="text" name="password" size="18" value="" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan="2" style="font-size: 10px;">\r\n <input type="submit" class="button" tabindex="6" name="login" value="{$lang.login}" />\r\n <a href="{$smarty.const.ESYN_URL}forgot.php">{$lang.forgot}</a>\r\n <a href="{$smarty.const.ESYN_URL}register.php" rel="nofollow">{$lang.register}</a>\r\n </td>\r\n </tr>\r\n </table>\r\n </form>\r\n {/if}\r\n <!-- accounts box end -->\r\n{/if}', 1, 'en', 'right', 'smarty', '', 'active', 1, 1, 0, 1, 1, '0'),
(5, 'Actions', '{if isset($esyndicat_actions) && !empty($esyndicat_actions)}{foreach from=$esyndicat_actions item=action}\r\n {assign var="action_key" value="esyndicat_action_"|cat:$action.name}\r\n\r\n {if $action.name eq ''action_favorite''}\r\n {if $esynAccountInfo}\r\n {if $esynAccountInfo.id neq $listing.account_id}\r\n {assign var="fav_array" value='',''|explode:$listing.fav_accounts_set}\r\n {if !empty($fav_array) && in_array($esynAccountInfo.id, $fav_array)}\r\n <a href="{if $action.url eq ''''}#{else}{$action.url}{/if}" class="esynactions_remove-favorite_{$listing.id}_{$esynAccountInfo.id}">{$lang.remove_from_favorites}</a><br />\r\n {else}\r\n <a href="{if $action.url eq ''''}#{else}{$action.url}{/if}" class="esynactions_add-favorite_{$listing.id}_{$esynAccountInfo.id}">{$lang.add_to_favorites}</a><br />\r\n {/if}\r\n {/if} \r\n {/if}\r\n {else}\r\n <a href="{if $action.url eq ''''}#{else}{$action.url}{/if}" class="esynactions_{$action.name|replace:"_":"-"}_{$listing.id}_{$listing.url}">{$lang.$action_key}</a><br />\r\n {/if}\r\n{/foreach}{/if}', 4, 'en', 'right', 'smarty', '', 'active', 1, 0, 0, 1, 1, '0'),
(6, 'Latest Comments', '{if isset($latest_comments)}\n {foreach from=$latest_comments item=comment name=latest_comments}\n <div class="posted">\n {print_img full=true fl="user.png" alt=$lang.comment_author}<strong>{$comment.author|escape:"html"}</strong> / {print_img full=true fl="calendar.png" alt=$lang.calendar} {$comment.date|date_format:$config.date_format}\n </div>\n {if $config.html_comments}\n <div class="comment">{$comment.body|truncate:100}<br /></div>\n {else}\n <div class="comment">{$comment.body|escape:"html"|truncate:100}<br /></div>\n {/if}\n <div style="float:right;"><a href="{print_listing_url listing=$comment.listing details=true}">{$lang.view_listing}</a></div>\n <div style="clear:both;"></div>\n {if !$smarty.foreach.latest_comments.last}<hr />{/if}\n {/foreach}\n{/if}', 5, 'en', 'right', 'smarty', 'comments', 'active', 1, 0, 0, 1, 1, '0'),
(7, 'Comments', '{include file=$smarty.const.ESYN_PLUGINS|cat:"comments/templates/comments.tpl"}', 5, 'en', 'bottom', 'smarty', 'comments', 'active', 1, 0, 0, 0, 1, '0');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]block_show`
--
CREATE TABLE `[[dbprefix]]block_show` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`page` varchar(100) NOT NULL DEFAULT '0',
`block_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `page` (`page`,`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]block_show`
--
INSERT INTO `[[dbprefix]]block_show` VALUES
(1, 'index', 3),
(2, 'view_listing', 5),
(3, 'view_listing', 7);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]categories`
--
CREATE TABLE `[[dbprefix]]categories` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(8) NOT NULL DEFAULT '0',
`parent_id` int(8) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`page_title` varchar(255) NOT NULL DEFAULT '',
`icon` varchar(255) NOT NULL DEFAULT '',
`description` text,
`status` enum('approval','active') NOT NULL DEFAULT 'approval',
`meta_description` tinytext,
`meta_keywords` tinytext,
`path` varchar(250) NOT NULL DEFAULT '',
`order` smallint(10) NOT NULL DEFAULT '0',
`locked` enum('0','1') NOT NULL DEFAULT '0',
`hidden` enum('0','1') NOT NULL DEFAULT '0',
`unique_tpl` enum('0','1') NOT NULL DEFAULT '0',
`level` smallint(6) NOT NULL DEFAULT '1',
`num_cols` tinyint(4) NOT NULL DEFAULT '0',
`num_neighbours` tinyint(4) NOT NULL DEFAULT '0',
`num_listings` int(8) NOT NULL DEFAULT '0',
`num_all_listings` int(8) NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`no_follow` tinyint(1) NOT NULL DEFAULT '0',
`confirmation` enum('0','1') NOT NULL DEFAULT '0',
`confirmation_text` text,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `status` (`status`),
KEY `path` (`path`),
KEY `order` (`order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `[[dbprefix]]categories`
--
INSERT INTO `[[dbprefix]]categories` VALUES
(0, 0, -1, 'ROOT', '', '', '', 'active', '', '', '', 0, '0', '0', '0', 0, 0, 0, 3, 3, 0, 0, '0', NULL),
(2, 0, 0, 'Sports', '', '', 'Sports Directory', 'active', NULL, NULL, 'sports', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(3, 0, 0, 'Shopping', '', '', 'Shopping Directory', 'active', NULL, NULL, 'shopping', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(4, 0, 0, 'Society', '', '', 'Society Directory', 'active', NULL, NULL, 'society', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(5, 0, 0, 'Misc', '', '', 'Miscellaneous and Everything Else Directory', 'active', NULL, NULL, 'misc', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(6, 0, 0, 'Science', '', '', 'Science Directory', 'active', NULL, NULL, 'science', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(7, 0, 0, 'Reference', '', '', 'Reference Directory', 'active', NULL, NULL, 'reference', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(8, 0, 0, 'Regional', '', '', 'Regional Directory', 'active', NULL, NULL, 'regional', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(9, 0, 0, 'News', '', '', 'News Directory', 'active', NULL, NULL, 'news', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(10, 0, 0, 'Home', '', '', 'Home Directory', 'active', NULL, NULL, 'home', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(11, 0, 0, 'Kids and Teens', '', '', 'Kids and Teen Directory', 'active', NULL, NULL, 'kids-and-teens', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(12, 0, 0, 'Games', '', '', 'Games Directory', 'active', NULL, NULL, 'games', 0, '0', '0', '0', 0, 0, 0, 1, 1, 0, 0, '0', NULL),
(13, 0, 0, 'Health', '', '', 'Health Directory', 'active', NULL, NULL, 'health', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(14, 0, 0, 'Computers', '', '', 'Computers Directory', 'active', NULL, NULL, 'computers', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(15, 0, 0, 'Arts', '', '', 'Arts Directory', 'active', NULL, NULL, 'arts', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL),
(16, 0, 0, 'Business', '', '', 'Business Directory', 'active', NULL, NULL, 'business', 0, '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, '0', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_clicks`
--
CREATE TABLE `[[dbprefix]]category_clicks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL DEFAULT '0',
`ip` varchar(15) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]comments`
--
CREATE TABLE `[[dbprefix]]comments` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`listing_id` int(8) NOT NULL DEFAULT '0',
`account_id` int(8) NOT NULL DEFAULT '0',
`author` varchar(100) NOT NULL DEFAULT '',
`url` varchar(100) NOT NULL DEFAULT '',
`body` text NOT NULL,
`email` varchar(100) NOT NULL DEFAULT '',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`rating` varchar(50) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('inactive','active') NOT NULL DEFAULT 'inactive',
`sess_id` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]config`
--
CREATE TABLE `[[dbprefix]]config` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`group_name` varchar(50) NOT NULL DEFAULT '',
`name` varchar(100) NOT NULL DEFAULT '',
`value` text NOT NULL,
`multiple_values` text NOT NULL,
`type` enum('text','textarea','checkbox','radio','select','divider','hidden','password','image') NOT NULL DEFAULT 'text',
`description` text NOT NULL,
`plugin` varchar(50) NOT NULL DEFAULT '',
`editor` enum('0','1') NOT NULL DEFAULT '0',
`order` float NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=251 ;
--
-- Dumping data for table `[[dbprefix]]config`
--
INSERT INTO `[[dbprefix]]config` VALUES
(1, '', 'htaccessfile_0', '# Uncomment next line if you get 404 error on accounts page\r\n# Options -MultiViews\r\n<IfModule mod_rewrite.c>\r\n# enable mod_rewrite\r\nRewriteEngine on\r\n\r\n', '', 'hidden', 'htaccess top section', '', '0', 0),
(2, '', 'htaccessfile_1', '# SECTION 1\r\n# correct urls for yahoo bot\r\nRewriteCond %{REQUEST_URI} !\\..+$\r\nRewriteCond %{REQUEST_URI} !/$\r\nRewriteRule (.*) %{REQUEST_URI}/ [R=301,L]\r\n\r\n# mod_rewrite rules for plugins\r\nRewriteRule ^mod/(.*)/$ controller.php?plugin=$1 [QSA,L]\r\nRewriteRule ^mod/(.*)/(.*)/$ controller.php?plugin=$1&file=$2 [QSA,L]\r\nRewriteRule ^mod/(.*)/(.*).html$ controller.php?plugin=$1&file=$2 [QSA,L]\r\n\r\n# mod_rewrite rules for view account page\r\nRewriteRule ^accounts/$ accounts.php [QSA,L]\r\nRewriteRule ^accounts/(.*)/$ accounts.php?alpha=$1 [QSA,L]\r\nRewriteRule ^accounts/(.*).html$ view-account.php?account=$1 [QSA,L]\r\n\r\nRewriteRule ^sitemap.xml$ tmp/sitemap/google/sitemap.xml [QSA,L]\r\n\r\nRewriteRule ^sitemap([0-9]+).xml$ tmp/sitemap/google/sitemap$1.xml [QSA,L]\r\nRewriteRule ^sitemap_index.xml$ tmp/sitemap/google/sitemap_index.xml [QSA,L]\r\nRewriteRule ^urllist.txt$ tmp/sitemap/yahoo/urllist.txt [QSA,L]', '', 'hidden', 'htaccess section 1', '', '0', 0),
(3, '', 'htaccessfile_2', '# SECTION 2\r\n# mod_rewrite rules for ROOT category\r\nRewriteRule ^index([0-9]+).html$ index.php?category=0&page=$1 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 2', '', '0', 0),
(4, '', 'htaccessfile_3', '# SECTION 3\r\n# mod_rewrite rules for categories pages with HTML path option disable\r\nRewriteRule ^(.*)/$ index.php?category=$1 [QSA,L]\r\nRewriteRule ^(.*)/index([0-9]+).html$ index.php?category=$1&page=$2 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 3', '', '0', 0),
(5, '', 'htaccessfile_4', '# SECTION 4\r\n# mod_rewrite rule for suggest listing page\r\nRewriteRule report-listing.php$ report-listing.php [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 4', '', '0', 0),
(6, '', 'htaccessfile_5', '# SECTION 5\r\nRewriteRule ^([a-z]+)-listings.html$ listings.php?view=$1 [QSA,L]\r\nRewriteRule ^([a-z]+)-listings([0-9]+).html$ listings.php?view=$1&page=$2 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 5', '', '0', 0),
(7, '', 'htaccessfile_6', '# SECTION 6\r\n# mod_rewrite rules for view listing page\r\nRewriteRule ^([^/]+)-l([0-9]+).html$ view-listing.php?cat=&title=$1&id=$2 [QSA,L]\r\nRewriteRule ^(.*)/([^/]+)-l([0-9]+).html$ view-listing.php?cat=$1&title=$2&id=$3 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 6', '', '0', 0),
(8, '', 'htaccessfile_7', '# SECTION 7\r\n# mod_rewrite rules for additional pages\r\nRewriteRule ^p/(.*).html$ page.php?name=$1 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 7', '', '0', 0),
(9, '', 'htaccessfile_8', '# SECTION 8\r\n# mod_rewrite rules for error pages\r\nRewriteRule ^([0-9]+).htm$ error.php?error=$1 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 8', '', '0', 0),
(10, '', 'htaccessfile_9', '# SECTION 9\r\n# mod_rewrite rules for suggest category page\r\nRewriteRule ^suggest-category-([0-9]+).html$ suggest-category.php?id=$1 [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 9', '', '0', 0),
(11, '', 'htaccessfile_10', '# SECTION 10\r\nRewriteRule ^LICENSE.htm$ LICENSE.htm [QSA,L]\r\n\r\n', '', 'hidden', 'htaccess section 10', '', '0', 0),
(12, '', 'htaccessfile_11', '# SECTION 11\r\n# mod_rewrite rules for categories pages\r\nRewriteRule ^(.*)_([0-9]+).html$ index.php?category=$1&page=$2 [QSA,L]\r\nRewriteRule ^(.*).html?(.*)$ index.php?category=$1&$2 [QSA,L]\r\nRewriteRule ^(.*).html$ index.php?category=$1 [QSA,L]\r\n</IfModule>\r\n\r\n', '', 'hidden', 'htaccess section 11', '', '0', 0),
(13, '', 'htaccessfile_12', '# SECTION 12\r\nErrorDocument 500 500.htm\r\nErrorDocument 404 404.htm\r\nErrorDocument 403 403.htm\r\nErrorDocument 401 401.htm', '', 'hidden', 'htaccess section 12', '', '0', 0),
(14, 'accounts', '', 'General', '1', 'divider', '', '', '0', 1),
(15, 'accounts', 'accounts', '1', '''1'',''0''', 'radio', 'Accounts', '', '0', 2),
(16, 'accounts', 'accounts_autoapproval', '0', '''1'',''0''', 'radio', 'Accounts Auto Approval', '', '0', 3),
(17, 'listings', 'accounts_registered', '1', '''1'',''0''', 'radio', 'Allow submissions for guests', '', '0', 4),
(18, 'captcha', '', 'General', '1', 'divider', '', '', '0', 1),
(19, 'captcha', 'captcha', '1', '''1'',''0''', 'radio', 'Captcha', '', '0', 2),
(20, 'captcha', 'captcha_name', 'kcaptcha', 'kcaptcha', 'hidden', 'Name of CAPTCHA', '', '0', 3),
(21, 'captcha', 'captcha_preview', '', '', 'text', 'Captcha preview', '', '0', 3.1),
(22, 'captcha', 'captcha_case_sensitive', '1', '1,0', 'radio', 'Case sensitive', '', '0', 120.1),
(23, 'captcha', 'captcha_num_chars', '5', '', 'text', 'Number of characters', '', '0', 121.1),
(24, 'categories', '', 'General', '1', 'divider', '', '', '0', 0),
(25, 'categories', 'suggest_category', '1', '''1'',''0''', 'radio', 'Allow category submission', '', '0', 1),
(26, 'categories', 'use_html_path', '0', '''1'',''0''', 'radio', 'Use .html extension in category URL', '', '0', 2),
(27, 'categories', 'related', '1', '''1'',''0''', 'radio', 'Related categories display', '', '0', 3),
(28, 'categories', 'neighbour', '1', '''1'',''0''', 'radio', 'Neighbour categories display', '', '0', 4),
(29, 'categories', 'show_children_listings', '0', '''1'',''0''', 'radio', 'Show subcategories listings in the parents', '', '0', 4.5),
(30, 'categories', 'categories_order', 'title', '''title'',''order''', 'select', 'Categories sorting', '', '0', 5),
(31, 'categories', 'num_categories_cols', '3', '', 'text', 'Number of columns', '', '0', 6),
(32, 'categories', 'num_listings_display', '1', '''1'',''0''', 'radio', 'Listings count indicator', '', '0', 7),
(33, 'categories', 'subcats_display', '3', '', 'text', 'Number of subcategories', '', '0', 8),
(34, 'categories', 'num_cats_for_search', '5', '', 'text', 'Number of categories on the search page', '', '0', 8),
(35, 'categories', 'categories_tree_type', 'tree', '''tree'',''dropdown'',''simple dropdown''', 'select', 'Category selection method', '', '0', 5.1),
(36, 'categories', 'categories_display_type', 'horizontal', '''vertical'',''horizontal''', 'select', 'Categories display type', '', '0', 4.9),
(37, 'categories', 'categories_icon_width', '32', '', 'text', 'Category icon width', '', '0', 8.1),
(38, 'categories', 'categories_icon_height', '32', '', 'text', 'Categories icon height', '', '0', 8.2),
(39, 'cronjob', '', 'Check-UP CRON', '1', 'divider', '', '', '0', 52),
(40, 'cronjob', 'cron_recip', '0', '''1'',''0''', 'radio', 'Cron for checking reciprocal listings', '', '0', 53),
(41, 'cronjob', 'cron_broken', '0', '''1'',''0''', 'radio', 'Gets listing status (checking for broken listings)', '', '0', 54),
(42, 'cronjob', 'cron_pagerank', '0', '''1'',''0''', 'radio', 'Cron for listings pagerank update', '', '0', 55),
(43, 'cronjob', 'cron_num_listings', '10', '', 'text', 'Number of listings to check in one run', '', '0', 56),
(44, 'cronjob', 'cron_check_interval', '1', '', 'text', 'Check interval (in days)', '', '0', 57),
(45, 'cronjob', '', 'CRON email reports', '1', 'divider', '', '', '0', 58),
(46, 'cronjob', 'cron_report_job', '0', '''1'',''0''', 'radio', 'CRON should send email each CronJob', '', '0', 59),
(47, 'cronjob', 'cron_report_job_extra', '0', '''1'',''0''', 'radio', 'Include list of listing URLs (each CronJob)', '', '0', 60),
(48, 'cronjob', 'cron_report_cycle', '0', '''1'',''0''', 'radio', 'CRON should send email after all listings will be checked', '', '0', 61),
(49, 'cronjob', 'cron_report_cycle_extra', '0', '''1'',''0''', 'radio', 'Include list of listing URLs (each CronCycle)', '', '0', 62),
(50, 'cronjob', '', 'Backup CRON', '1', 'divider', '', '', '0', 67),
(51, 'cronjob', 'cron_backup', '0', '''1'',''0''', 'radio', 'Backup cron functionality', '', '0', 68),
(52, 'cronjob', 'cron_backup_archive', '0', '''1'',''0''', 'radio', 'Archive Data (Zlib PHP requires)', '', '0', 69),
(53, 'cronjob', 'cron_backup_interval', '30', '', 'text', 'Make backup each [..] day(s)', '', '0', 70),
(54, 'cronjob', 'cron_backup_last_time', '', '', 'hidden', '', '', '0', 71),
(55, 'cronjob', 'cron', '1', '', 'hidden', '', '', '0', 0),
(56, 'general', '', 'Path & URLs', '1', 'divider', '', '', '0', 1),
(57, 'general', 'version', '1.8', '', 'hidden', '', '', '0', 2),
(58, 'general', 'site', 'eSyndiCat Directory', '1', 'text', 'Site title', '', '0', 3),
(59, 'general', 'site_logo', '', '', 'image', 'Site Logo', '', '0', 3.1),
(60, 'general', 'site_main_content', '', '', 'textarea', 'Index page content', '', '1', 3.13),
(61, 'general', 'site_description', '', '', 'textarea', 'Index META description', '', '0', 3.2),
(62, 'general', 'site_keywords', '', '', 'text', 'Index META keywords', '', '0', 3.3),
(63, 'general', 'backup', 'backup/', '1', 'text', 'Directory for database backups', '', '0', 5),
(64, 'general', '', 'Emails', '1', 'divider', '', '', '0', 7),
(65, 'general', 'site_email', '[[admin_email]]', '1', 'text', 'Email', '', '0', 8),
(66, 'general', 'bugs_email', '[[admin_email]]', '1', 'text', 'Bugs email', '', '0', 9),
(67, 'general', 'tmpl', 'cleancss', '', 'hidden', 'Your skin template', '', '0', 12),
(68, 'general', 'admin_tmpl', 'default', '1', 'hidden', 'Your admin skin template', '', '0', 12.1),
(69, 'general', '', 'Regional', '1', 'divider', '', '', '0', 13),
(70, 'general', 'lang', 'en', '1', 'select', 'Script language', '', '0', 14),
(71, 'general', 'charset', 'UTF-8', '1', 'text', 'Default charset for pages', '', '0', 15),
(72, 'general', 'date_format', '%b %e, %Y', '', 'text', 'Date format', '', '0', 15),
(73, 'general', '', 'General', '1', 'divider', '', '', '0', 16),
(74, 'general', 'suffix', ':: Powered by eSyndiCat', '1', 'text', 'Suffix for page titles', '', '0', 3.05),
(75, 'general', 'title_breadcrumb', '0', '''1'',''0''', 'radio', 'Full path to category in title', '', '0', 18),
(76, 'general', 'language_switch', '0', '''1'',''0''', 'radio', 'Language switching', '', '0', 19),
(77, 'general', 'mod_rewrite', '1', '''1'',''0''', 'radio', 'Apache mod_rewrite module', '', '0', 20),
(78, 'general', 'display_frontend', '1', '''1'',''0''', 'radio', 'Display FrontEnd', '', '0', 23),
(79, 'general', 'underconstruction', 'We are sorry. Our site is under construction.', '', 'textarea', 'Under construction message', '', '0', 24),
(80, 'general', 'esyndicat_new_plugins_url', 'http://tools.esyndicat.com/new_plugins.php', '', 'hidden', '', '', '0', 0),
(81, 'general', 'esyndicat_block_positions', 'left,right,top,center,bottom,user1,user2,verybottom,verytop,topbanner', '', 'hidden', 'eSyndiCat Block Positions', '', '0', 0),
(82, 'general', 'ckeditor_color', '#F00', '', 'hidden', 'CKEditor color', '', '0', 0),
(83, 'general', 'esyndicat_menu_type', 'inventory,main,bottom,account', '', 'hidden', 'menu type', '', '0', 0),
(84, 'general', 'display_twitter', '1', '', 'hidden', 'eSyndiCat Twitter Block', '', '0', 0),
(85, 'general', 'config_keys', 'recaptcha_publickey,recaptcha_privatekey,sendmail_path,smtp_secure_connection,smtp_server,smtp_user,smtp_password', '', 'hidden', '', '', '0', 0),
(86, 'general', 'default_categories_icon', 'templates/common/img/category_icons/category_icon.gif', '', 'hidden', 'Default categories icon path', '', '0', 0),
(87, 'listings', '', 'General', '1', 'divider', '', '', '0', 1),
(88, 'listings', 'allow_listings_submission', '1', '''1'',''0''', 'radio', 'Allow listing submission', '', '0', 2),
(89, 'listings', 'auto_approval', '0', '''1'',''0''', 'radio', 'Auto approval on submission', '', '0', 3),
(90, 'listings', 'new_window', '0', '''1'',''0''', 'radio', 'Open listings in a new window', '', '0', 4),
(91, 'listings', 'forward_to_listing_details', '1', '''1'',''0''', 'radio', 'Forward to listing details', '', '0', 5),
(92, 'listings', 'pagerank', '1', '''1'',''0''', 'radio', 'Google PageRank display', '', '0', 6),
(93, 'listings', 'thumbshot', '1', '''1'',''0''', 'radio', 'Display thumbshots', '', '0', 7),
(94, 'listings', 'num_index_listings', '10', '', 'text', 'Number of listings per page', '', '0', 8),
(95, 'listings', 'num_get_listings', '10', '', 'text', 'Number of listings(Top, New, Popular)', '', '0', 8.5),
(96, 'listings', 'num_featured_display', '3', '', 'text', 'Number of listings in Featured Box', '', '0', 9),
(97, 'listings', 'num_partner_display', '3', '', 'text', 'Number of listings in Partners Box', '', '0', 10),
(98, 'listings', '', 'Sorting', '1', 'divider', '', '', '0', 11),
(99, 'listings', 'visitor_sorting', '1', '''1'',''0''', 'radio', 'Allow listing ordering for visitors', '', '0', 12),
(100, 'listings', 'listings_sorting', 'alphabetic', '''alphabetic'',''date'',''clicks'',''rank''', 'select', 'Listings order by', '', '0', 13),
(101, 'listings', 'listings_sorting_type', 'ascending', '''ascending'',''descending''', 'select', 'Listings order type', '', '0', 14),
(102, 'listings', '', 'Description Field', '', 'divider', '', '', '0', 15),
(103, 'listings', 'description_num_chars', '300', '', 'text', 'Description snippet length', '', '0', 16),
(104, 'listings', 'description_min_max_length', '50,500', '', 'text', 'Description length limit', '', '0', 17),
(105, 'listings', '', 'Expiration Date', '1', 'divider', '', '', '0', 18),
(106, 'listings', 'expiration_period', '', '', 'text', 'Listing expiration period (days)', '', '0', 19),
(107, 'listings', 'expiration_action', '', '', 'text', 'Listing expiration action', '', '0', 20),
(108, 'listings', 'broken_listings_report', '1', '''1'',''0''', 'radio', 'Broken listings report', '', '0', 7.1),
(109, 'listing_checking', '', 'Broken Checking', '', 'divider', '', '', '0', 30.6),
(110, 'listing_checking', 'listing_check', '0', '''1'',''0''', 'radio', 'Checking for broken listings', '', '0', 31),
(111, 'listing_checking', 'broken_visitors', '1', '''1'',''0''', 'radio', 'Disabled in admin panel', '', '0', 31.5),
(112, 'listing_checking', 'http_headers', '301,302,200', '', 'text', 'Correct HTTP headers', '', '0', 31.55),
(113, 'listing_checking', '', 'Reciprocal Checking', '', 'divider', '', '', '0', 31.6),
(114, 'listing_checking', 'reciprocal_check', '0', '''1'',''0''', 'radio', 'Reciprocal listing checking', '', '0', 32),
(115, 'listing_checking', 'reciprocal_required_only_for_free', '0', '''1'',''0''', 'radio', 'Reciprocal required for free listings', '', '0', 32.1),
(116, 'listing_checking', 'reciprocal_domain', '1', '''1'',''0''', 'radio', 'Domain sensitive', '', '0', 32.1),
(117, 'listing_checking', 'reciprocal_text', '[[softurl]]/', '', 'text', 'Reciprocal checking for the following URL', '', '0', 56),
(118, 'listing_checking', 'recip_featured', '0', '''1'',''0''', 'radio', 'Make featured', '', '0', 56.5),
(119, 'listing_checking', 'reciprocal_visitors', '1', '''1'',''0''', 'radio', 'Checked in admin panel', '', '0', 99.95),
(120, 'listing_checking', '', 'Duplicate Checking', '', 'divider', '', '', '0', 100),
(121, 'listing_checking', 'duplicate_checking', '0', '''1'',''0''', 'radio', 'Duplicate listing checking', '', '0', 101),
(122, 'listing_checking', 'duplicate_type', 'domain', '''exact'',''domain'',''contain''', 'select', 'Duplicate checking type', '', '0', 102),
(123, 'listing_checking', 'duplicate_visitors', '1', '''1'',''0''', 'radio', 'Disabled in admin panel', '', '0', 103),
(124, 'listing_checking', 'reciprocal_label', 'To validate the reciprocal link please include the following HTML code in the page at the URL specified above, before submitting this form:', '', 'textarea', 'Reciprocal text on the suggest listing page', '', '0', 99.96),
(125, 'listing_checking', 'reciprocal_code', '', '', 'textarea', 'Reciprocal code', '', '0', 99.97),
(126, 'mail', '', 'Mail type', '1', 'divider', '', '', '0', 1),
(127, 'mail', 'mail_function', 'php mail', '''php mail'',''sendmail'',''smtp''', 'select', 'Mail method', '', '0', 2),
(128, 'mail', 'mimetype', 'html', '''html'',''plaintext''', 'select', 'Mime-Type', '', '0', 3),
(129, 'mail', '', 'Sendmail Configuration', '', 'divider', '', '', '0', 4),
(130, 'mail', 'sendmail_path', '/usr/bin/sendmail', '', 'text', 'Path to sendmail ', '', '0', 5),
(131, 'mail', '', 'SMTP Configuration', '', 'divider', '', '', '0', 6),
(132, 'mail', 'smtp_secure_connection', '', ''''',''SSL'',''TSL''', 'select', 'Use secure connection', '', '0', 7),
(133, 'mail', 'smtp_server', '', '', 'text', 'SMTP Server', '', '0', 8),
(134, 'mail', 'smtp_port', '25', '', 'text', 'SMTP Port', '', '0', 8.1),
(135, 'mail', 'smtp_user', '', '', 'text', 'SMTP Server Username', '', '0', 9),
(136, 'mail', 'smtp_password', '', '', 'password', 'SMTP Server Password', '', '0', 10),
(137, 'email_templates', '', 'Listing Submitted', '', 'divider', '', '', '0', 0.2),
(138, 'email_templates', 'listing_submit', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 0.3),
(139, 'email_templates', 'listing_submit_subject', 'Listing was submitted to {own_site}', '', 'text', 'Subject', '', '0', 0.4),
(140, 'email_templates', 'listing_submit_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n We are glad to inform you that a link to {your_site_url} has been submitted to <em><a href="{own_dir_url}">{own_site}</a></em> ({own_dir_url}). Your submission will be reviewed within 24 hours.</p>\r\n<p>\r\n After approval and activation, your URL will be listed at:</p>\r\n<p>\r\n <a href="{dir_listing}"><i>{dir_listing}</i></a></p>\r\n<p>\r\n Now, please add a link to <em><a href="{own_dir_url}">{own_site}</a></em> to any of your site's pages.</p>\r\n<p>\r\n Please use the code below:</p>\r\n<pre>\r\n<a href="{own_dir_url}">{own_site}</a></pre>\r\n<p>\r\n OR use the following information</p>\r\n<pre>\r\nTITLE: <em>{own_site}</em>\r\nURL: <em>{own_dir_url}</em>\r\nDESCRIPTION: <em>your site description</em>\r\n</pre>\r\n<p>\r\n All the listings in our directory are direct, so they will improve your listing popularity.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 0.5),
(141, 'email_templates', 'listing_submit_body_plaintext', 'Dear Sir/Madam,\r\n \r\nWe are glad to inform you that a link to {your_site_url}\r\nhas been submitted to {own_site} ({own_dir_url}).\r\nYour submission will be reviewed within 24 hours.\r\n \r\nAfter approval and activation, your URL will be listed at: \r\n{dir_listing}\r\n \r\nNow, please add a link to {own_dir_url} to any of your site''s pages.\r\n\r\nPlease use the code below:\r\n------------------------------------\r\n<a href="{own_dir_url}">{own_site}</a>\r\n------------------------------------\r\n\r\nOR use the following information\r\n------------------------------------\r\nTITLE: {own_site}\r\nURL: {own_dir_url}\r\nDESCRIPTION: your site description\r\n\r\nAll the listings in our directory are direct, so they will improve your listing popularity.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 0.51),
(142, 'email_templates', '', 'Listing Approved', '', 'divider', '', '', '0', 0.6),
(143, 'email_templates', 'listing_approve', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 0.65),
(144, 'email_templates', 'listing_approve_subject', 'Listing was approved in {own_site}', '', 'text', 'Subject', '', '0', 0.68),
(145, 'email_templates', 'listing_approve_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Congratulations! Your listing {your_site_url} has been approved for <em><a href="{own_dir_url}">{own_site}</a></em>. You can view it at:</p>\r\n<p>\r\n <em><a href="{dir_listing}">{dir_listing}</a></em></p>\r\n<p>\r\n If you have not placed reciprocal listing to <em><a href="{own_dir_url}">{own_site}</a></em> yet, please add a listing to {own_dir_url} to any of your site's pages.</p>\r\n<p>\r\n Please use the code below:</p>\r\n<pre>\r\n<a href="{own_dir_url}">{own_site}</a></pre>\r\n<p>\r\n OR use the following information</p>\r\n<pre>\r\nTITLE: <em>{own_site}</em>\r\nURL: <em>{own_dir_url}</em>\r\nDESCRIPTION: <em>your site description</em>\r\n</pre>\r\n<p>\r\n All the listings in our directory are direct, so they will improve your listing popularity.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 0.7),
(146, 'email_templates', 'listing_approve_body_plaintext', 'Dear Sir/Madam,\r\n \r\nCongratulations! Your listing {your_site_url} has been approved for {own_site}.\r\nYou can view it at {dir_listing}.\r\n \r\nIf you have not placed reciprocal listing to {own_site} yet,\r\nplease add a listing to {own_dir_url} to any of your site''s pages.\r\n\r\nPlease use the code below:\r\n------------------------------------\r\n<a href="{own_dir_url}">{own_site}</a>\r\n------------------------------------\r\n\r\nOR use the following information\r\n------------------------------------\r\nTITLE: {own_site}\r\nURL: {own_dir_url}\r\nDESCRIPTION: site description\r\n------------------------------------\r\n\r\nAll the listings in our directory are direct, so they will improve your listing popularity.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 0.7),
(147, 'email_templates', '', 'Listing Disapproved', '', 'divider', '', '', '0', 0.71),
(148, 'email_templates', 'listing_disapprove', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 0.72),
(149, 'email_templates', 'listing_disapprove_subject', 'Listing was disapproved in {own_site}', '', 'text', 'Subject', '', '0', 0.73),
(150, 'email_templates', 'listing_disapprove_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Your listing {your_site_url} has been disapproved in<em> <a href="{own_dir_url}">{own_site}</a></em>.</p>\r\n<p>\r\n If you have questions, please feel free to ask us.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 0.74),
(151, 'email_templates', 'listing_disapprove_body_plaintext', 'Dear Sir/Madam,\r\n\r\nYour listing {your_site_url} has been disapproved in {own_site} Listings Directory.\r\n\r\nIf you have questions, please feel free to ask us.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 0.741),
(152, 'email_templates', '', 'Listing Moved', '', 'divider', '', '', '0', 56.8),
(153, 'email_templates', 'listing_move', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 56.9),
(154, 'email_templates', 'listing_move_subject', 'Listing was moved in {own_site}', '', 'text', 'Subject', '', '0', 56.95),
(155, 'email_templates', 'listing_move_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n We are glad to inform you, that your listing to site {your_site_url} was moved into another category.</p>\r\n<p>\r\n This is the new location of your listing:</p>\r\n<p>\r\n <em><a href="{dir_listing}">{dir_listing}</a></em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 57),
(156, 'email_templates', 'listing_move_body_plaintext', 'Dear Sir/Madam,\r\n\r\nWe are glad to inform you, that your listing to site {your_site_url} was moved into another category. \r\nThis is the new location of your listing:\r\n\r\n{dir_listing}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 57.1),
(157, 'email_templates', '', 'Listing Modified', '', 'divider', '', '', '0', 57.5),
(158, 'email_templates', 'listing_modify', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 57.6),
(159, 'email_templates', 'listing_modify_subject', 'Listing was modified in {own_site}', '', 'text', 'Subject', '', '0', 57.7),
(160, 'email_templates', 'listing_modify_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n We are glad to inform you, that your listing to site {your_site_url} was modified.</p>\r\n<p>\r\n These are the new attributes of your listing:</p>\r\n<p>\r\n Title: <em>{your_site_title}</em><br />\r\n URL: <em>{your_site_url}</em><br />\r\n Description: <em>{your_site_desc}</em><br />\r\n Email: <em>{your_site_email}</em><br />\r\n Rank: <em>{your_site_rank}</em><br />\r\n Status: <em>{your_site_status}</em></p>\r\n<p>\r\n You can view your listing here:</p>\r\n<p>\r\n <em><a href="{dir_listing}">{dir_listing}</a></em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '1', 'textarea', 'HTML Body', '', '1', 57.8),
(161, 'email_templates', 'listing_modify_body_plaintext', 'Dear Sir/Madam,\r\n\r\nWe are glad to inform you, that your listing to site {your_site_url} was modified.\r\nThese are the new attributes of your listing:\r\n\r\nTitle: {your_site_title}\r\nURL: {your_site_url}\r\nDescription: {your_site_desc}\r\nEmail: {your_site_email}\r\nRank: {your_site_rank}\r\nStatus: {your_site_status}\r\n\r\nYou can view your listing here:\r\n{dir_listing}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '1', 'textarea', 'Email Body', '', '0', 57.81),
(162, 'email_templates', '', 'Listing Banned', '', 'divider', '', '', '0', 58),
(163, 'email_templates', 'listing_reject', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 58.5),
(164, 'email_templates', 'listing_reject_subject', 'Listing was banned in {own_site}', '', 'text', 'Subject', '', '0', 58.6),
(165, 'email_templates', 'listing_reject_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Your listing to {your_site_url} has been banned in <em><a href="{own_dir_url}">{own_site}</a></em>.</p>\r\n<p>\r\n If you have questions, please feel free to ask us.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '1', 'textarea', 'HTML Body', '', '1', 59),
(166, 'email_templates', 'listing_reject_body_plaintext', 'Dear Sir/Madam,\r\n\r\nListing to {your_site_url} in our directory has been banned.\r\n\r\nIf you have questions, please feel free to ask us.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '1', 'textarea', 'Email Body', '', '0', 59.1),
(167, 'email_templates', '', 'Listing Deleted', '', 'divider', '', '', '0', 59.9),
(168, 'email_templates', 'listing_delete', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 60),
(169, 'email_templates', 'listing_delete_subject', 'Listing was deleted from {own_site}', '', 'text', 'Subject', '', '0', 61),
(170, 'email_templates', 'listing_delete_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Your listing {your_site_url} has been deleted from</p>\r\n<p>\r\n <em><a href="{dir_listing}">{dir_listing}</a></em></p>\r\n<p>\r\n category, probably because you did not place reciprocal listing(s) to <em><a href="{own_dir_url}">{own_site}</a></em>. To see your listing again, please add a listing to our site and inform us.</p>\r\n<p>\r\n <em>{reason}</em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '1', 'textarea', 'HTML Body', '', '1', 62),
(171, 'email_templates', 'listing_delete_body_plaintext', 'Dear Sir/Madam,\r\n\r\nYour listing {your_site_url} has been deleted from {dir_listing} category,\r\nprobably because you did not place reciprocal listing(s) to {own_site}. \r\nTo see your listing again, please add a listing to our site and inform us.\r\n\r\n{reason}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '1', 'textarea', 'Email Body', '', '0', 62.1),
(172, 'email_templates', '', 'Listing Added', '', 'divider', '', '', '0', 62.5),
(173, 'email_templates', 'listing_admin_add', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 63),
(174, 'email_templates', 'listing_admin_add_subject', 'Listing was added to {own_site}', '', 'text', 'Subject', '', '0', 64),
(175, 'email_templates', 'listing_admin_add_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n We are glad to inform you that a listing to {your_site_url} has been added to <em><a href="{own_dir_url}">{own_site}</a></em> ({own_dir_url}).</p>\r\n<p>\r\n These are the attributes of your listing:<br />\r\n Title: <em>{your_site_title}</em><br />\r\n URL: <em>{your_site_url}</em><br />\r\n Description:<em> {your_site_desc}</em><br />\r\n Email: <em>{your_site_email}</em><br />\r\n Rank:<em> {your_site_rank}</em></p>\r\n<p>\r\n You can view your listing here:</p>\r\n<p>\r\n <em><a href="{dir_listing}">{dir_listing}</a></em></p>\r\n<p>\r\n Now, please add a listing to {own_site} to any of your site's pages.</p>\r\n<p>\r\n Please use the code below:<br />\r\n ------------------------------------<br />\r\n <a href="{own_dir_url}">{own_site}</a><br />\r\n ------------------------------------</p>\r\n<p>\r\n OR use the following information<br />\r\n ------------------------------------<br />\r\n TITLE: <em>{own_site}</em><br />\r\n URL: <em>{own_dir_url}</em><br />\r\n DESCRIPTION: <em>your site description</em></p>\r\n<p>\r\n All the listings in our directory are direct, so they will improve your listing popularity.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'Email that is sent when admin adds listing', '', '1', 65),
(176, 'email_templates', 'listing_admin_add_body_plaintext', 'Dear Sir/Madam,\r\n \r\nWe are glad to inform you that a listing to {your_site_url} has been added to {own_site} Listings Directory ({own_dir_url}).\r\n \r\nThese are the attributes of your listing:\r\nTitle: {your_site_title}\r\nURL: {your_site_url}\r\nDescription: {your_site_desc}\r\nEmail: {your_site_email}\r\nRank: {your_site_rank}\r\nStatus: {your_site_status}\r\n\r\nYou can view your listing here {dir_listing}\r\n\r\nNow, please add a listing to {own_site} to any of your site''s pages.\r\n\r\nPlease use the code below:\r\n------------------------------------\r\n<a href="{own_dir_url}">{own_site}</a>\r\n------------------------------------\r\n\r\nOR use the following information\r\n------------------------------------\r\nTITLE: {own_site}\r\nURL: {own_dir_url}\r\nDESCRIPTION: your site description\r\n\r\nAll the listings in our directory are direct, so they will improve your listing popularity.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 65.1),
(177, 'email_templates', '', 'Account Registration', '', 'divider', '', '', '0', 66.5),
(178, 'email_templates', 'register_account', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 66.6),
(179, 'email_templates', 'register_account_subject', 'Thanks for registration at {own_site}', '', 'text', 'Subject: ', '', '0', 67),
(180, 'email_templates', 'register_account_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Thanks for your registration at <em><a href="{own_dir_url}">{own_site}</a></em>. Here is information you should use in order to login:</p>\r\n<p>\r\n Your username: <strong>{account_username}</strong><br />\r\n Your password: <strong>{account_pwd}</strong><br />\r\n Your activation key: {key}</p>\r\n<p>\r\n To activate your account go to<em> <a href="{own_dir_url}register.php?user={account_username_url}&key={key}&action=confirm">{own_dir_url}register.php?user={account_username_url}&key={key}&action=confirm</a></em></p>\r\n<p>\r\n You may change your password later by editing your personal attributes in your account area.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 68),
(181, 'email_templates', 'register_account_body_plaintext', 'Dear Sir/Madam,\r\n\r\nThanks for your registration at {own_site}. Here is information you should use in order to login:\r\n\r\nYour username: {account_username}\r\nYour password: {account_pwd}\r\n\r\nYour activation key: {key}\r\n\r\nTo activate your account go to {own_dir_url}register.php?user={account_username_url}&key={key}&action=confirm\r\n\r\nYou may change your password later by editing your personal attributes in your account area.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 68),
(182, 'email_templates', '', 'Account Registration Admin Notification', '', 'divider', '', '', '0', 68.01),
(183, 'email_templates', 'account_register', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 68.02),
(184, 'email_templates', 'account_register_subject', 'Account was registered to {own_site}', '', 'text', 'Subject: ', '', '0', 68.03),
(185, 'email_templates', 'account_register_body_html', '<h3>\r\n Dear {admin_name},</h3>\r\n<p>\r\n Account was registered to <em><a href="{own_dir_url}">{own_site}</a></em>. Please check it.</p>\r\n<p>\r\n These are the attributes of the account:<br />\r\n Username:<em> {account_username}</em><br />\r\n Email:<em> {account_email}</em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 68.04),
(186, 'email_templates', 'account_register_body_plaintext', 'Dear {admin_name},\r\n\r\nAccount was registered to {own_site} Directory. Please check it.\r\n\r\nThese are the\r\nattributes of the account:\r\nUsername: {account_username}\r\nEmail: {account_email}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 68.05),
(187, 'email_templates', '', 'Account Confirmed Admin Notification', '', 'divider', '', '', '0', 68.06),
(188, 'email_templates', 'account_confirmed', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 68.07),
(189, 'email_templates', 'account_confirmed_subject', 'Account was confirmed in {own_site}', '', 'text', 'Subject: ', '', '0', 68.08),
(190, 'email_templates', 'account_confirmed_body_html', '<h3>\r\n Dear {admin_name},</h3>\r\n<p>\r\n Account was confirmed in <em><a href="{own_dir_url}">{own_site}</a></em>. Please check it.</p>\r\n<p>\r\n These are the attributes of the account:<br />\r\n Username:<em> {account_username}</em><br />\r\n Email:<em> {account_email}</em><br />\r\n Status:<em> {account_status}</em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 68.09),
(191, 'email_templates', 'account_confirmed_body_plaintext', 'Dear {admin_name},\r\n\r\nAccount was confirmed in {own_site} Directory. Please check it.\r\n\r\nThese are the\r\nattributes of the account:\r\nUsername: {account_username}\r\nEmail: {account_email}\r\nStatus: {account_status}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 68.09),
(192, 'email_templates', '', 'Admin Account Registration', '', 'divider', '', '', '0', 68.1),
(193, 'email_templates', 'register_account_admin', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 69),
(194, 'email_templates', 'register_account_admin_subject', 'Thanks for registration at {own_site}', '', 'text', 'Subject: ', '', '0', 69.1),
(195, 'email_templates', 'register_account_admin_body_plaintext', 'Dear Sir/Madam,\r\n\r\nYour website {your_site_url} has been added to {own_site}.\r\n\r\nThis is the information we have added:\r\n\r\nTitle: {your_site_title}\r\nDescription: {your_site_desc}\r\nURL: {your_site_url}\r\nEmail: {your_site_email}\r\n\r\nYou can find your listing at {dir_listing}\r\n\r\nIf you would like to update your listing information or provide more complete contact information, etc, you can login using the following information\r\n\r\nYour username: {account_username}\r\nYour password: {account_pwd}\r\n\r\nLogin page: {own_dir_url}/login.php\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 69.2),
(196, 'email_templates', 'register_account_admin_body_html', '<h3>\r\n Dear Sir/Madam,</h3>\r\n<p>\r\n Your website {your_site_url} has been added to {own_site}</p>\r\n<p>\r\n This is the information we have added:</p>\r\n<p>\r\n Title: {your_site_title}<br />\r\n Description: {your_site_desc}<br />\r\n URL: {your_site_url}<br />\r\n Email: {your_site_email}</p>\r\n<p>\r\n You can find your listing at {dir_listing}</p>\r\n<p>\r\n If you would like to update your listing information or provide more complete contact information, etc, you can login using the following information:</p>\r\n<p>\r\n Your username: {account_username}<br />\r\n Your password: {account_pwd}</p>\r\n<p>\r\n Login page: {own_dir_url}login.php</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 69.2),
(197, 'email_templates', '', 'Submission Notification Email for Admin', '', 'divider', '', '', '0', 80),
(198, 'email_templates', 'admin_notif_subject', 'Listing was submitted to {own_site}', '', 'text', 'Email subject', '', '0', 81),
(199, 'email_templates', 'admin_notif_body_html', '<h3>\r\n Dear {admin_name},</h3>\r\n<p>\r\n Listing was submitted to <em><a href="{own_dir_url}">{own_site}</a></em>. Please check it.</p>\r\n<p>\r\n These are the attributes of a listing:<br />\r\n Title:<em> {your_site_title}</em><br />\r\n URL: <em>{your_site_url}</em><br />\r\n Description: <em>{your_site_desc}</em><br />\r\n Email:<em> {your_site_email}</em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 82),
(200, 'email_templates', 'admin_notif_body_plaintext', 'Dear {admin_name},\r\n\r\nListing was submitted to {own_site} Directory. Please check it.\r\n\r\nThese are the attributes of a listing:\r\nTitle: {your_site_title}\r\nURL: {your_site_url}\r\nDescription: {your_site_desc}\r\nEmail: {your_site_email}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 82.1),
(201, 'email_templates', '', 'Submission Category Notification Email for Admin', '', 'divider', '', '', '0', 82.21),
(202, 'email_templates', 'suggest_category_subject', 'Category was submitted to {own_site}', '', 'text', 'Email subject', '', '0', 82.22),
(203, 'email_templates', 'suggest_category_body_html', '<h3>\r\n Dear {admin_name},</h3>\r\n<p>\r\n Category was submitted to <em><a href="{own_dir_url}">{own_site}</a></em>. Please check it.</p>\r\n<p>\r\n These are the attributes of a category:<br />\r\n Title:<em> {cat_title}</em><br />\r\n Category path: <em>{cat_path}</em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 82.23),
(204, 'email_templates', 'suggest_category_body_plaintext', 'Dear {admin_name},\r\n\r\nCategory was submitted to {own_site} Directory. Please check it.\r\n\r\nThese are the attributes of a category:\r\nTitle: {cat_title}\r\nCategory path: {cat_path}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 82.24),
(205, 'email_templates', '', 'Account Removed', '', 'divider', '', '', '0', 85.14),
(206, 'email_templates', 'account_deleted', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 85.15),
(207, 'email_templates', 'account_deleted_subject', 'Account deleted in {own_site}', '', 'text', 'Email subject', '', '0', 85.2),
(208, 'email_templates', 'account_deleted_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n Your account was removed from</p>\r\n<p>\r\n <em><a href="{own_dir_url}">{own_site}</a></em></p>\r\n<p>\r\n Let us know if you have any questions.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 85.3),
(209, 'email_templates', 'account_deleted_body_plaintext', 'Dear {username},\r\n\r\nYour account was removed from {own_site}. \r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 85.4),
(210, 'email_templates', '', 'Password Change Request', '', 'divider', '', '', '0', 86.5),
(211, 'email_templates', 'password_change_subject', 'Password change request at {own_site}', '', 'text', 'Email subject', '', '0', 87),
(212, 'email_templates', 'password_change_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n You requested a password change in <em><a href="{own_dir_url}">{own_site}</a></em>. Now you should use the following credentials to log in as account:</p>\r\n<p>\r\n username:<strong> {username}</strong><br />\r\n password: <strong>{password}</strong></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 88),
(213, 'email_templates', 'password_change_body_plaintext', 'Dear {username},\r\n\r\nYou requested a password change in {own_site}. Now you should use the following credentials to log in as account:\r\n\r\nUsername: {username}\r\nPassword: {password}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 88.1),
(214, 'email_templates', '', 'Account Approved', '', 'divider', '', '', '0', 88.2),
(215, 'email_templates', 'account_approved', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 88.21),
(216, 'email_templates', 'account_approved_subject', 'Account was approved at {own_site}', '', 'text', 'Email subject', '', '0', 88.3),
(217, 'email_templates', 'account_approved_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n Your account was approved in <em><a href="{own_dir_url}">{own_site}</a></em>. Now you can log in to the directory.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 88.4),
(218, 'email_templates', 'account_approved_body_plaintext', 'Dear {username},\r\n\r\nYour account was approved in {own_site}. Now you can log in to the directory.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 88.5),
(219, 'email_templates', '', 'Account Dispproved', '', 'divider', '', '', '0', 88.6),
(220, 'email_templates', 'account_disapproved', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 88.65),
(221, 'email_templates', 'account_disapproved_subject', 'Account was disapproved at {own_site}', '', 'text', 'Email subject', '', '0', 88.7),
(222, 'email_templates', 'account_disapproved_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n Your account was disapproved in <em><a href="{own_dir_url}">{own_site}</a></em>.</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 88.8),
(223, 'email_templates', 'account_disapproved_body_plaintext', 'Dear {username},\r\n\r\nYour account was disapproved in {own_site}.\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 88.9),
(224, 'email_templates', '', 'Report broken link', '', 'divider', '', '', '0', 95.1),
(225, 'email_templates', 'broken_listing_report_subject', 'Broken Listing Reported at {own_site}', '', 'text', 'Subject: ', '', '0', 95.2),
(226, 'email_templates', 'broken_listing_report_body_html', '<h3>\r\n Dear {admin_name},</h3>\r\n<p>\r\n The following listing is reported as being broken:</p>\r\n<p>\r\n Listing ID: {id}<br />\r\n Listing URL: {url}<br />\r\n Listing Title: {title}</p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 95.3),
(227, 'email_templates', 'broken_listing_report_body_plaintext', 'Dear {admin_name},\r\n\r\nThe following listing is reported as being broken:\r\n\r\nListing ID: {id}\r\nListing URL: {url}\r\nListing Title: {title}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 95.31),
(228, 'email_templates', '', 'Account Confirm Email', '', 'divider', '', '', '0', 70),
(229, 'email_templates', 'account_confirm_email', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 70.1),
(230, 'email_templates', 'account_confirm_email_subject', 'Confirm email in {own_site}', '', 'text', 'Subject: ', '', '0', 70.2),
(231, 'email_templates', 'account_confirm_email_body_plaintext', 'Dear {username},\r\n\r\nWe have received new password request for your account ({username}) in {own_site}.\r\n\r\nIf this request was initiated by you, please click on following link to confirm your email:\r\n{own_dir_url}confirm.php?action=restore_password&account={account_id}&r={sec_key}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 70.3),
(232, 'email_templates', 'account_confirm_email_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n We have received new password request for your account ({username}) in <em><a href="{own_dir_url}">{own_site}</a></em>.<br />\r\n <br />\r\n If this request was initiated by you, please click on following link to confirm your email:<br />\r\n <em><a href="{own_dir_url}confirm.php?action=restore_password&account={account_id}&r={sec_key}">{own_dir_url}confirm.php?action=restore_password&account={account_id}&r={sec_key}</a></em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 70.4),
(233, 'email_templates', '', 'Account Confirm Change Email', '', 'divider', '', '', '0', 70.5),
(234, 'email_templates', 'account_change_email', '1', '''1'',''0''', 'radio', 'Email sending', '', '0', 70.6),
(235, 'email_templates', 'account_change_email_subject', 'Confirm change email in {own_site}', '', 'text', 'Subject: ', '', '0', 70.7),
(236, 'email_templates', 'account_change_email_body_plaintext', 'Dear {username},\r\n\r\nWe have received change email request for your account ({username}) in {own_site}.\r\n\r\nIf this request was initiated by you, please click on following link to confirm your email:\r\n{own_dir_url}confirm.php?action=change_email&account={account_id}&r={sec_key}\r\n\r\n______________________________\r\nThank you,\r\n{own_site} Administration Team\r\n{own_dir_url}\r\n{own_email}', '', 'textarea', 'Email Body', '', '0', 70.8),
(237, 'email_templates', 'account_change_email_body_html', '<h3>\r\n Dear {username},</h3>\r\n<p>\r\n We have received change email request for your account ({username}) in <em><a href="{own_dir_url}">{own_site}</a></em>.<br />\r\n <br />\r\n If this request was initiated by you, please click on following link to confirm your email:<br />\r\n <em><a href="{own_dir_url}confirm.php?action=change_email&account={account_id}&r={sec_key}">{own_dir_url}confirm.php?action=change_email&account={account_id}&r={sec_key}</a></em></p>\r\n<p>\r\n ______________________________<br />\r\n Thank you,<br />\r\n {own_site} Administration Team<br />\r\n {own_dir_url}<br />\r\n {own_email}</p>\r\n', '', 'textarea', 'HTML Body', '', '1', 70.9),
(238, 'comments', 'div_comments', 'Comments Configuration', '', 'divider', 'Comments Configuration', 'comments', '0', 122.1),
(239, 'comments', 'allow_listing_comments_submission', '1', '1,0', 'radio', 'Allow listing comments submission', 'comments', '0', 123.1),
(240, 'comments', 'listing_comments_accounts', '1', '1,0', 'radio', 'Allows to comment for guests', 'comments', '0', 124.1),
(241, 'comments', 'html_comments', '0', '1,0', 'radio', 'Allows WYSIWYG', 'comments', '0', 125.1),
(242, 'comments', 'comments_approval', '0', '1,0', 'radio', 'Comments auto approval', 'comments', '0', 126.1),
(243, 'comments', 'comment_min_chars', '10', '', 'text', 'Min number of chars for listing comment', 'comments', '0', 127.1),
(244, 'comments', 'comment_max_chars', '300', '', 'text', 'Max number of chars for listing comment', 'comments', '0', 128.1),
(245, 'comments', 'num_latest_comments', '5', '', 'text', 'Number of latest comments in block', 'comments', '0', 129.1),
(246, 'comments', 'div_rating', 'Rating Configuration', '', 'divider', 'Rating Configuration', 'comments', '0', 130.1),
(247, 'comments', 'listing_rating', '1', '1,0', 'radio', 'Listings Rating', 'comments', '0', 131.1);
INSERT INTO `[[dbprefix]]config` VALUES
(248, 'comments', 'listing_rating_max', '10', '', 'text', 'Maximum listings rating', 'comments', '0', 132.1),
(249, 'comments', 'listing_rating_block_max', '10', '', 'text', 'Maximum listings in block rating', 'comments', '0', 133.1),
(250, 'comments', 'rate_period', '1', '', 'text', 'Rate period for IP (in days)', 'comments', '0', 134.1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]config_groups`
--
CREATE TABLE `[[dbprefix]]config_groups` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`plugin` varchar(50) NOT NULL DEFAULT '',
`title` varchar(150) NOT NULL DEFAULT '',
`order` float NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `[[dbprefix]]config_groups`
--
INSERT INTO `[[dbprefix]]config_groups` VALUES
(1, 'general', '', 'General Configuration', 1),
(2, 'categories', '', 'Categories Configuration', 2),
(3, 'listings', '', 'Listings Configuration', 3),
(4, 'accounts', '', 'Accounts Configuration', 4),
(5, 'listing_checking', '', 'Listing Checking', 7),
(6, 'mail', '', 'Mail Configuration', 8),
(7, 'email_templates', '', 'Email Templates', 9),
(8, 'cronjob', '', 'Cronjob Configuration', 10),
(9, 'captcha', '', 'Captcha Configuration', 12),
(10, 'miscellaneous', '', 'Miscellaneous', 13),
(11, 'comments', 'comments', 'Comments', 14);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cron`
--
CREATE TABLE `[[dbprefix]]cron` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL DEFAULT '',
`nextrun` int(10) unsigned NOT NULL DEFAULT '0',
`data` varchar(250) NOT NULL DEFAULT '',
`active` tinyint(1) NOT NULL DEFAULT '1',
`extras` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]cron`
--
INSERT INTO `[[dbprefix]]cron` VALUES
(1, 'check_listings', 0, '0 */3 * * * includes/cron/check.php', 1, NULL),
(2, 'check_expired', 0, '10 0 * * * includes/cron/check_expired.php', 1, NULL),
(3, 'backup', 0, '5 0 * * * includes/cron/backup.php', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]crossed`
--
CREATE TABLE `[[dbprefix]]crossed` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(8) unsigned NOT NULL DEFAULT '0',
`category_title` varchar(255) NOT NULL,
`crossed_id` int(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`,`crossed_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]field_categories`
--
CREATE TABLE `[[dbprefix]]field_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`field_id` int(11) NOT NULL DEFAULT '0',
`category_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]field_categories`
--
INSERT INTO `[[dbprefix]]field_categories` VALUES
(1, 1, 0),
(2, 2, 0),
(3, 3, 0),
(4, 4, 0),
(5, 5, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]flat_structure`
--
CREATE TABLE `[[dbprefix]]flat_structure` (
`parent_id` int(8) NOT NULL DEFAULT '0',
`category_id` int(8) NOT NULL DEFAULT '0',
KEY `parent_id` (`parent_id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]flat_structure`
--
INSERT INTO `[[dbprefix]]flat_structure` VALUES
(2, 2),
(0, 2),
(3, 3),
(0, 3),
(4, 4),
(0, 4),
(5, 5),
(0, 5),
(6, 6),
(0, 6),
(7, 7),
(0, 7),
(8, 8),
(0, 8),
(9, 9),
(0, 9),
(10, 10),
(0, 10),
(11, 11),
(0, 11),
(12, 12),
(0, 12),
(13, 13),
(0, 13),
(14, 14),
(0, 14),
(15, 15),
(0, 15),
(16, 16),
(0, 16);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]hooks`
--
CREATE TABLE `[[dbprefix]]hooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`plugin` varchar(50) NOT NULL DEFAULT '',
`name` varchar(250) NOT NULL DEFAULT '',
`type` enum('php','html','smarty','plain') NOT NULL DEFAULT 'php',
`code` text,
`file` text,
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
`order` smallint(5) unsigned NOT NULL DEFAULT '5',
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `[[dbprefix]]hooks`
--
INSERT INTO `[[dbprefix]]hooks` VALUES
(1, 'comments', 'viewListingAfterMainFieldsDisplay', 'smarty', '<tr>\n <td><strong>{$lang.comments}:</strong></td>\n <td>{$total_comments}</td>\n</tr>', '', 'active', 1),
(2, 'comments', 'statisticsBlock', 'smarty', '{if isset($num_total_comments)}\n <tr>\n <td>{$lang.comments}:</td>\n <td>{$num_total_comments}</td>\n </tr>\n{/if}', '', 'active', 2),
(3, 'comments', 'bootstrap', 'php', 'global $eSyndiCat, $esynSmarty, $esynConfig;\n \n$eSyndiCat->setTable("comments");\n$num_total_comments = $eSyndiCat->one("COUNT(*)", "`status` = ''active''");\n$eSyndiCat->resetTable(); \n$esynSmarty->assign(''num_total_comments'', $num_total_comments);\n \n$sql = "SELECT * FROM `{$eSyndiCat->mPrefix}comments`";\n$sql .= "WHERE `status`=''active''";\n$sql .= "ORDER BY `date` DESC ";\n$sql .= "LIMIT ".$esynConfig->getConfig(''num_latest_comments'');\n$latest_comments = $eSyndiCat->getAll($sql);\n\n$eSyndiCat->factory(''Listing'');\nglobal $esynListing;\nif (!empty($latest_comments))\n{\n foreach ($latest_comments as $key => $comment)\n {\n $latest_comments[$key][''listing''] = $esynListing->getListingById($comment[''listing_id'']);\n }\n}\n$esynSmarty->assign(''latest_comments'', $latest_comments);', '', 'active', 4),
(4, 'comments', 'viewListing', 'php', 'global $eSyndiCat, $esynSmarty, $esynConfig, $esynI18N, $listing;\n\n$eSyndiCat->setTable("comments");\n$comments = $eSyndiCat->all("*", "`listing_id` = :id AND `status` = ''active''", array(''id'' => $listing[''id'']));\n$eSyndiCat->resetTable();\n\nrequire_once(ESYN_HOME . ''plugins'' . ESYN_DS . ''comments'' . ESYN_DS . ''includes'' . ESYN_DS . ''classes'' . ESYN_DS . ''esynRating.php'');\n\n$esynRating = new esynRating();\n\n$rating = $esynRating->getRating($listing[''id'']);\n\n$rating[''voted''] = false;\n\nif($esynRating->isVoted($_SERVER[''REMOTE_ADDR''], $listing[''id'']))\n{\n $rating[''voted''] = true;\n\n $rating[''html''] = number_format($rating[''rating''], 2);\n $rating[''html''] .= '' / '';\n $rating[''html''] .= $esynConfig->getConfig(''listing_rating_block_max'');\n $rating[''html''] .= '' ('';\n $rating[''html''] .= $rating[''num_votes''];\n $rating[''html''] .= '' '';\n $rating[''html''] .= $rating[''num_votes''] > 1 ? $esynI18N[''votes_cast''] : $esynI18N[''vote_cast''];\n $rating[''html''] .= '') '';\n $rating[''html''] .= ''<span style="color: green;">'';\n $rating[''html''] .= $esynI18N[''thanks_for_voting''];\n $rating[''html''] .= ''</span>'';\n}\n\n$esynSmarty->assign(''comments'', $comments);\n$esynSmarty->assign(''rating'', $rating);\n$esynSmarty->assign(''total_comments'', count($comments));', '', 'active', 5);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]language`
--
CREATE TABLE `[[dbprefix]]language` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`key` varchar(100) NOT NULL DEFAULT '',
`value` text NOT NULL,
`lang` varchar(50) NOT NULL DEFAULT '',
`category` enum('admin','frontend','common','page','tooltip') NOT NULL DEFAULT 'frontend',
`code` varchar(2) NOT NULL DEFAULT '',
`plugin` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `category` (`category`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1259 ;
--
-- Dumping data for table `[[dbprefix]]language`
--
INSERT INTO `[[dbprefix]]language` VALUES
(1, 'login_to', 'Login To eSyndiCat Admin Panel', 'English', 'admin', 'en', NULL),
(2, 'login_to_text', 'Enter the login name into "Login" and password into the "Password" fields.\r\nThen click "Login".', 'English', 'admin', 'en', NULL),
(3, 'login', 'Login', 'English', 'common', 'en', NULL),
(4, 'install_not_deleted', 'WARNING!!! INSTALL DIRECTORY HASN''T BEEN REMOVED', 'English', 'admin', 'en', NULL),
(5, 'interface_language', 'Interface Language', 'English', 'common', 'en', NULL),
(6, 'password', 'Password', 'English', 'common', 'en', NULL),
(7, 'forgot_password', 'Forgot your password?', 'English', 'common', 'en', NULL),
(8, 'login_btn', 'Login', 'English', 'common', 'en', NULL),
(9, 'invalid_username', 'Invalid username.', 'English', 'common', 'en', NULL),
(10, 'invalid_password', 'Invalid password.', 'English', 'common', 'en', NULL),
(11, 'admin_panel', 'Admin Panel', 'English', 'admin', 'en', NULL),
(12, 'configuration', 'Configuration', 'English', 'admin', 'en', NULL),
(13, 'manage_admins', 'Manage Admins', 'English', 'admin', 'en', NULL),
(14, 'manage_database', 'Manage Database', 'English', 'admin', 'en', NULL),
(15, 'manage_accounts', 'Manage Accounts', 'English', 'admin', 'en', NULL),
(16, 'manage_pages', 'Manage Pages', 'English', 'admin', 'en', NULL),
(17, 'manage_fields', 'Manage Listing Fields', 'English', 'admin', 'en', NULL),
(18, 'manage_fields_recommendation', 'It is not recommended to you to add or change fields often.', 'English', 'admin', 'en', NULL),
(19, 'manage_language', 'Language Manager', 'English', 'admin', 'en', NULL),
(20, 'changes_saved', 'Changes saved.', 'English', 'common', 'en', NULL),
(21, 'items_deleted', 'Deleted.', 'English', 'common', 'en', NULL),
(22, 'category_locked', 'Category Locked', 'English', 'admin', 'en', NULL),
(23, 'import', 'Import', 'English', 'admin', 'en', NULL),
(24, 'export', 'Export', 'English', 'admin', 'en', NULL),
(25, 'save_changes', 'Save Changes', 'English', 'common', 'en', NULL),
(26, 'home', 'Home', 'English', 'common', 'en', NULL),
(27, 'management', 'Management', 'English', 'admin', 'en', NULL),
(28, 'help', 'Help', 'English', 'common', 'en', NULL),
(29, 'phrase_manager', 'Phrase Manager', 'English', 'admin', 'en', NULL),
(30, 'site_home', 'Site Home', 'English', 'admin', 'en', NULL),
(31, 'directory_home', 'Directory Home', 'English', 'admin', 'en', NULL),
(32, 'error_name', 'Name is incorrect.', 'English', 'common', 'en', NULL),
(33, 'edit', 'Edit', 'English', 'common', 'en', NULL),
(34, 'delete', 'Delete', 'English', 'common', 'en', NULL),
(35, 'error_description', 'Description is incorrect.', 'English', 'admin', 'en', NULL),
(36, 'help_content', 'Any help regarding eSyndiCat Software could be found here:<br /><br />\r\n1. <a href="http://www.esyndicat.com/forum/">eSyndiCat Support Forums</a><br /><br />\r\n2. <a href="http://www.esyndicat.com/desk/">eSyndiCat Help Desk</a><br /><br />\r\n3. <a href="http://www.esyndicat.com/desk/index.php?/Knowledgebase/List">Knowledge base</a><br /><br />\r\n\r\nPlease do not hesitate to contact us in case you have any questions.', 'English', 'admin', 'en', NULL),
(37, 'field_url', 'Listing URL', 'English', 'common', 'en', NULL),
(38, 'field_title', 'Title', 'English', 'common', 'en', NULL),
(39, 'field_description', 'Description', 'English', 'common', 'en', NULL),
(40, 'field_email', 'Email', 'English', 'common', 'en', NULL),
(41, 'field_reciprocal', 'Reciprocal URL', 'English', 'common', 'en', NULL),
(42, 'days', 'Days', 'English', 'admin', 'en', NULL),
(43, 'order', 'Order', 'English', 'common', 'en', NULL),
(44, 'save_order', 'Save Order', 'English', 'admin', 'en', NULL),
(45, 'cost', 'Cost', 'English', 'admin', 'en', NULL),
(46, 'description', 'Description', 'English', 'common', 'en', NULL),
(47, 'title', 'Title', 'English', 'common', 'en', NULL),
(48, 'add', 'Add', 'English', 'common', 'en', NULL),
(49, 'view_all', 'View All', 'English', 'common', 'en', NULL),
(50, 'search', 'Search', 'English', 'common', 'en', NULL),
(51, 'server_info', 'Server Info', 'English', 'admin', 'en', NULL),
(52, 'logout', 'Logout', 'English', 'common', 'en', NULL),
(53, 'edit_admin', 'Edit Admin', 'English', 'admin', 'en', NULL),
(54, 'admin_added', 'New admin successfully created.', 'English', 'admin', 'en', NULL),
(55, 'date', 'Date', 'English', 'common', 'en', NULL),
(56, 'status', 'Status', 'English', 'common', 'en', NULL),
(57, 'select_action', 'Select Action', 'English', 'admin', 'en', NULL),
(58, 'approve', 'Approve', 'English', 'admin', 'en', NULL),
(59, 'disapprove', 'Disapprove', 'English', 'admin', 'en', NULL),
(60, 'go', 'Go', 'English', 'common', 'en', NULL),
(61, '_select_', '-- select --', 'English', 'common', 'en', NULL),
(62, 'reply', 'Reply', 'English', 'common', 'en', NULL),
(63, 'subject_incorrect', 'Subject is incorrect.', 'English', 'admin', 'en', NULL),
(64, 'email_not_sent', 'Warning: Couldn''t deliver mail message.', 'English', 'admin', 'en', NULL),
(65, 'email_sent', 'Email sent.', 'English', 'common', 'en', NULL),
(66, 'body', 'Body', 'English', 'common', 'en', NULL),
(67, 'from', 'From', 'English', 'common', 'en', NULL),
(68, 'body_incorrect', 'Body is incorrect.', 'English', 'common', 'en', NULL),
(69, 'to', 'To', 'English', 'common', 'en', NULL),
(70, 'subject', 'Subject', 'English', 'common', 'en', NULL),
(71, 'author', 'Author', 'English', 'common', 'en', NULL),
(72, 'email', 'Email', 'English', 'common', 'en', NULL),
(73, 'approval', 'Approval', 'English', 'admin', 'en', NULL),
(74, 'active', 'Active', 'English', 'admin', 'en', NULL),
(75, 'categories', 'Categories', 'English', 'common', 'en', NULL),
(76, 'listings', 'Listings', 'English', 'common', 'en', NULL),
(77, 'banned', 'Banned', 'English', 'admin', 'en', NULL),
(78, 'broken', 'Broken', 'English', 'admin', 'en', NULL),
(79, 'nonrecip', 'Non reciprocal', 'English', 'admin', 'en', NULL),
(80, 'featured', 'Featured', 'English', 'common', 'en', NULL),
(81, 'partner', 'Partner', 'English', 'common', 'en', NULL),
(82, 'remove_featured', 'Remove featured', 'English', 'admin', 'en', NULL),
(83, 'remove_partner', 'Remove partner', 'English', 'admin', 'en', NULL),
(84, 'total', 'Total', 'English', 'common', 'en', NULL),
(85, 'reciprocal', 'Reciprocal', 'English', 'common', 'en', NULL),
(86, 'comments', 'Comments', 'English', 'common', 'en', NULL),
(87, 'accounts', 'Accounts', 'English', 'common', 'en', NULL),
(88, 'manage_categories', 'Manage Categories', 'English', 'admin', 'en', NULL),
(89, 'path', 'Path', 'English', 'admin', 'en', NULL),
(90, 'move', 'Move', 'English', 'common', 'en', NULL),
(91, 'no_categories', 'No categories. <a href="controller.php?file=suggest-category&id=[category_id]" style="font-weight: bold;">Click here</a> to create category.', 'English', 'admin', 'en', NULL),
(92, 'password_incorrect', 'Password is incorrect.', 'English', 'common', 'en', NULL),
(93, 'username_incorrect', 'Username is incorrect.', 'English', 'admin', 'en', NULL),
(94, 'username_exists', 'Username already exists.', 'English', 'admin', 'en', NULL),
(95, 'passwords_not_match', 'Passwords do not match.', 'English', 'common', 'en', NULL),
(96, 'account_added', 'Account added.', 'English', 'common', 'en', NULL),
(97, 'account', 'Account', 'English', 'common', 'en', NULL),
(98, 'browse_categories', 'Browse Categories', 'English', 'common', 'en', NULL),
(99, 'set_order', 'Set Order', 'English', 'admin', 'en', NULL),
(100, 'create', 'Create', 'English', 'common', 'en', NULL),
(101, 'copy_categories', 'Copy Subcategories', 'English', 'admin', 'en', NULL),
(102, 'manage_related', 'Manage Related', 'English', 'admin', 'en', NULL),
(103, 'manage_crossed', 'Manage Crossed', 'English', 'admin', 'en', NULL),
(104, 'browse', 'Browse', 'English', 'common', 'en', NULL),
(105, 'category', 'Category', 'English', 'common', 'en', NULL),
(106, 'listing', 'Listing', 'English', 'common', 'en', NULL),
(107, 'manage', 'Manage', 'English', 'admin', 'en', NULL),
(108, 'expand_all', 'Expand All', 'English', 'common', 'en', NULL),
(109, 'collapse_all', 'Collapse All', 'English', 'common', 'en', NULL),
(110, 'common', 'Common', 'English', 'admin', 'en', NULL),
(111, 'sql_management', 'SQL Management', 'English', 'admin', 'en', NULL),
(112, 'check_consistency', 'Check Consistency', 'English', 'admin', 'en', NULL),
(113, 'optimize_tables', 'optimize tables', 'English', 'admin', 'en', NULL),
(114, 'done', 'Done', 'English', 'common', 'en', NULL),
(115, 'all_categories', 'All Categories', 'English', 'common', 'en', NULL),
(116, 'all_listings', 'All Listings', 'English', 'common', 'en', NULL),
(117, 'all_accounts', 'All Accounts', 'English', 'admin', 'en', NULL),
(118, 'help_contents', 'Help Contents', 'English', 'admin', 'en', NULL),
(119, 'release_notes', 'Release Notes', 'English', 'admin', 'en', NULL),
(120, 'system_info', 'System Info', 'English', 'admin', 'en', NULL),
(121, 'about_esyndicat', 'About eSyndiCat', 'English', 'admin', 'en', NULL),
(122, 'title_incorrect', 'Title incorrect.', 'English', 'common', 'en', NULL),
(123, 'category_unlocked', 'Category unlocked', 'English', 'admin', 'en', NULL),
(124, 'unique_category_template', 'Use unique template', 'English', 'admin', 'en', NULL),
(125, 'category_unique', 'Category will use unique template now.', 'English', 'admin', 'en', NULL),
(126, 'category_ununique', 'Category will not use unique template anymore.', 'English', 'admin', 'en', NULL),
(127, 'moved', 'Moved.', 'English', 'admin', 'en', NULL),
(128, 'related_added', 'Related category added.', 'English', 'admin', 'en', NULL),
(129, 'already_related', 'Related category already exists.', 'English', 'admin', 'en', NULL),
(130, 'crossed_added', 'Crosslink added.', 'English', 'admin', 'en', NULL),
(131, 'already_crossed', 'Crossed link already exists.', 'English', 'admin', 'en', NULL),
(132, 'already_copied', 'Listing already exists in this category.', 'English', 'admin', 'en', NULL),
(133, 'copied', ' copied.', 'English', 'admin', 'en', NULL),
(134, 'rating_reset', 'Listing rating reset.', 'English', 'admin', 'en', NULL),
(135, 'featured_added', 'Listing added to featured.', 'English', 'admin', 'en', NULL),
(136, 'already_featured', 'Listing already featured.', 'English', 'admin', 'en', NULL),
(137, 'crossed_removed', 'Crosslink removed from this category.', 'English', 'admin', 'en', NULL),
(138, 'featured_removed', 'Listing removed from featured.', 'English', 'admin', 'en', NULL),
(139, 'partner_removed', 'Listing removed from partners.', 'English', 'admin', 'en', NULL),
(140, 'partner_added', 'Listing added to partners.', 'English', 'admin', 'en', NULL),
(141, 'already_partner', 'Listing already added to partners.', 'English', 'admin', 'en', NULL),
(142, 'subcategories_copied', 'All subcategories have been copied.', 'English', 'admin', 'en', NULL),
(143, 'lock', 'Lock', 'English', 'admin', 'en', NULL),
(144, 'unlock', 'Unlock', 'English', 'admin', 'en', NULL),
(145, 'add_related', 'Add Related', 'English', 'admin', 'en', NULL),
(146, 'add_crossed', 'Add Crossed', 'English', 'admin', 'en', NULL),
(147, 'no_related', 'No related categories. <a href="javascript:void(0)" onclick="$(''#treeContainer'').fadeIn();$(''#action'').val(''relate'');$(''#labelcat0'').disable();resetTree();return false;" style="font-weight: bold;">Click here</a> to add related category to <strong>{category_title}</strong>.', 'English', 'admin', 'en', NULL),
(148, 'are_you_sure_to_uninstall_selected_plugins', 'Are you sure you want to uninstall selected plugins?', 'English', 'admin', 'en', NULL),
(149, 'category_path_exists', 'Category with similar path value already exists', 'English', 'admin', 'en', NULL),
(150, 'are_you_sure_to_uninstall_selected_plugin', 'Are you sure you want uninstall this plugin?', 'English', 'admin', 'en', NULL),
(151, 'category_title_exists', 'Category with similar title value already exists', 'English', 'admin', 'en', NULL),
(152, 'category_added', 'Category added.', 'English', 'admin', 'en', NULL),
(153, 'meta_description', 'Meta-description', 'English', 'common', 'en', NULL),
(154, 'meta_keywords', 'Meta-keywords', 'English', 'common', 'en', NULL),
(155, 'parent', 'Parent', 'English', 'admin', 'en', NULL),
(156, 'yes', 'Yes', 'English', 'common', 'en', NULL),
(157, 'no', 'No', 'English', 'common', 'en', NULL),
(158, 'columns_num', 'Number Of Columns', 'English', 'admin', 'en', NULL),
(159, 'neighbours_num', 'Number Of Neighbours', 'English', 'admin', 'en', NULL),
(160, 'all_comments', 'All Comments', 'English', 'admin', 'en', NULL),
(161, 'comment', 'Comment', 'English', 'common', 'en', NULL),
(162, 'incorrect_dates', 'Incorrect dates.', 'English', 'admin', 'en', NULL),
(163, 'partner_since', 'Partner Since', 'English', 'common', 'en', NULL),
(164, 'clicks', 'Clicks', 'English', 'common', 'en', NULL),
(165, 'rating', 'Rating', 'English', 'common', 'en', NULL),
(166, 'featured_since', 'Featured Since', 'English', 'common', 'en', NULL),
(167, 'ban', 'Ban', 'English', 'common', 'en', NULL),
(168, 'deleted', 'Deleted.', 'English', 'common', 'en', NULL),
(169, 'settings', 'Settings', 'English', 'admin', 'en', NULL),
(170, 'upgrade_completed', 'Upgrade completed.', 'English', 'admin', 'en', NULL),
(171, 'state', 'State', 'English', 'admin', 'en', NULL),
(172, 'filter_by', 'Filter By', 'English', 'admin', 'en', NULL),
(173, 'send', 'Send', 'English', 'common', 'en', NULL),
(174, 'recipients', 'Recipients', 'English', 'admin', 'en', NULL),
(175, '_all_', '-- all --', 'English', 'admin', 'en', NULL),
(176, 'root_cant_deleted', 'Root category can not be deleted.', 'English', 'admin', 'en', NULL),
(177, 'cant_open_sql', 'Could not open file with sql instructions: {filename}.', 'English', 'admin', 'en', NULL),
(178, 'no_pages', 'No pages created. Please <a href="manage-pages.php?action=add">click here</a> to create a page.', 'English', 'admin', 'en', NULL),
(179, 'disable', 'Disable', 'English', 'common', 'en', NULL),
(180, 'enable', 'Enable', 'English', 'admin', 'en', NULL),
(181, 'myfield', 'myfield', 'English', 'common', 'en', NULL),
(182, 'pagerank', 'PageRank', 'English', 'common', 'en', NULL),
(183, 'some', 'some', 'English', 'common', 'en', NULL),
(184, '_status_', '- Status -', 'English', 'admin', 'en', NULL),
(185, '_state_', '- State -', 'English', 'admin', 'en', NULL),
(186, '_action_', '- Action -', 'English', 'admin', 'en', NULL),
(187, 'crosslisting_confirm', 'Are sure you want to make it crosslink?', 'English', 'admin', 'en', NULL),
(188, 'unknown_upload', 'Unknown error during file upload.', 'English', 'common', 'en', NULL),
(189, 'incorrect_filetype', 'Incorrect file type.', 'English', 'common', 'en', NULL),
(190, 'upload_correct_permission', 'Couldn''t copy uploaded image to the destination. Please make sure that the script has write permission.', 'English', 'common', 'en', NULL),
(191, 'view', 'View', 'English', 'common', 'en', NULL),
(192, 'additional_fields', 'Additional Fields', 'English', 'common', 'en', NULL),
(193, 'reciprocal_valid', 'Reciprocal Valid', 'English', 'admin', 'en', NULL),
(194, 'rank', 'Rank', 'English', 'common', 'en', NULL),
(195, 'email_notif', 'Send email notification', 'English', 'admin', 'en', NULL),
(196, 'admin', 'Admin', 'English', 'admin', 'en', NULL),
(197, 'logout_content', 'Logged out. <a href="../" style="font-weight: bold;">Click here</a> to go to directory home.<br />\r\n<a href="login.php" style="font-weight: bold;">Click here</a> to go to directory admin panel again.<br />', 'English', 'admin', 'en', NULL),
(198, 'incorrect_permissions', 'Please set correct permissions.', 'English', 'admin', 'en', NULL),
(199, 'incorrect_password_confirm', 'Please make sure you entered valid confirmation.', 'English', 'admin', 'en', NULL),
(200, 'incorrect_email', 'Please input correct email.', 'English', 'common', 'en', NULL),
(201, 'incorrect_password', 'Please input correct password.', 'English', 'admin', 'en', NULL),
(202, 'incorrect_fullname', 'Please input correct full name.', 'English', 'admin', 'en', NULL),
(203, 'added', 'Added.', 'English', 'admin', 'en', NULL),
(204, 'admins', 'Admins', 'English', 'admin', 'en', NULL),
(205, 'username', 'Username', 'English', 'common', 'en', NULL),
(206, 'fullname', 'Full Name', 'English', 'common', 'en', NULL),
(207, 'submission_notif', 'Submission Notification', 'English', 'admin', 'en', NULL),
(208, 'password_confirm', 'Password Confirmation', 'English', 'common', 'en', NULL),
(209, 'enabled', 'Enabled', 'English', 'common', 'en', NULL),
(210, 'disabled', 'Disabled', 'English', 'common', 'en', NULL),
(211, 'admin_permissions', 'Admin Permissions', 'English', 'admin', 'en', NULL),
(212, 'super_admin', 'Super Admin', 'English', 'admin', 'en', NULL),
(213, 'created', 'Created.', 'English', 'admin', 'en', NULL),
(214, 'related_confirm', 'Are sure you want to remove this related category?', 'English', 'admin', 'en', NULL),
(215, 'nothing_checked', 'Please check any items to delete.', 'English', 'admin', 'en', NULL),
(216, 'no_comments', 'No Comments.', 'English', 'common', 'en', NULL),
(217, 'no_crossed', 'No crossed categories. <a href="javascript:void(0);" onClick="$(''#treeContainer'').fadeIn();$(''#action'').val(''cross'');$(''#labelcat0'').disable();return false;" style="font-weight: bold;">Click here</a> to add crossed category to <strong>{category_title}</strong>.', 'English', 'admin', 'en', NULL),
(218, 'no_crossed_root', 'No crossed categories can be created for ROOT category.', 'English', 'admin', 'en', NULL),
(219, 'no_related_root', 'No related categories can be created for ROOT category.', 'English', 'admin', 'en', NULL),
(220, 'copy_subcats', 'Are sure you want to copy all subcategories to another category?', 'English', 'admin', 'en', NULL),
(221, 'copy_listing_confirm', 'Are sure you want to copy this listing to another category?', 'English', 'admin', 'en', NULL),
(222, 'move_listing_confirm', 'Are sure you want to move in this category?', 'English', 'admin', 'en', NULL),
(223, 'no_accounts', 'No accounts. <a href="manage-accounts.php?action=add">Click here</a> to add account.', 'English', 'admin', 'en', NULL),
(224, 'incorrect_name_url', 'Incorrect name. Please fill in the URL field.', 'English', 'admin', 'en', NULL),
(225, 'page_exists', 'Page with this URL already exists. Please change URL.', 'English', 'admin', 'en', NULL),
(226, 'page', 'Page', 'English', 'common', 'en', NULL),
(227, 'pages', 'Pages', 'English', 'common', 'en', NULL),
(228, 'page_url', 'Page UNIQUE key', 'English', 'admin', 'en', NULL),
(229, 'show_menus', 'Show in Menus', 'English', 'admin', 'en', NULL),
(230, 'top_menu', 'Main Menu', 'English', 'admin', 'en', NULL),
(231, 'bottom_menu', 'Bottom Menu', 'English', 'admin', 'en', NULL),
(232, 'account_menu', 'Account Menu', 'English', 'admin', 'en', NULL),
(233, 'external_url', 'External URL', 'English', 'admin', 'en', NULL),
(234, 'no_follow_url', 'No Follow URL', 'English', 'admin', 'en', NULL),
(235, 'page_external_url', 'Page External URL', 'English', 'admin', 'en', NULL),
(236, 'enter_external_url', 'Enter External URL', 'English', 'admin', 'en', NULL),
(237, 'page_content', 'Page Content', 'English', 'admin', 'en', NULL),
(238, 'page_content_sample', 'Your page content should be here...', 'English', 'common', 'en', NULL),
(239, 'url', 'URL', 'English', 'common', 'en', NULL),
(240, 'menus', 'Menus', 'English', 'admin', 'en', NULL),
(241, 'cant_write_sql', 'Cannot write to file {filename}.', 'English', 'admin', 'en', NULL),
(242, 'table_dumped', 'Table {table} successfully dumped into file {filename}.', 'English', 'admin', 'en', NULL),
(243, 'directory_not_writable', '{dirname} directory is not writable. You can not save to server.', 'English', 'admin', 'en', NULL),
(244, 'mysql_options', 'MySQL Options', 'English', 'admin', 'en', NULL),
(245, 'options', 'Options', 'English', 'admin', 'en', NULL),
(246, 'select_all', 'Select All ', 'English', 'admin', 'en', NULL),
(247, 'select_none', 'Select None', 'English', 'admin', 'en', NULL),
(248, 'structure', 'Structure', 'English', 'admin', 'en', NULL),
(249, 'add_drop_table', 'Add DROP TABLE', 'English', 'admin', 'en', NULL),
(250, 'data', 'Data', 'English', 'admin', 'en', NULL),
(251, 'complete_inserts', 'Complete Inserts', 'English', 'admin', 'en', NULL),
(252, 'use_real_prefix', 'Use real tables prefix', 'English', 'admin', 'en', NULL),
(253, 'save_as_file', 'Save as file', 'English', 'admin', 'en', NULL),
(254, 'save_to_server', 'Save to server', 'English', 'admin', 'en', NULL),
(255, 'save_to_pc', 'Save to PC', 'English', 'admin', 'en', NULL),
(256, 'export_not_checked', 'You have not choosen what to export.', 'English', 'admin', 'en', NULL),
(257, 'no_upgrades', 'No patches or upgrades available.', 'English', 'admin', 'en', NULL),
(258, 'location_sql_file', 'Location of MySQL upgrade file', 'English', 'admin', 'en', NULL),
(259, 'choose_import_file', 'Please choose a file to import.', 'English', 'admin', 'en', NULL),
(260, 'run_sql_queries', 'Run MySQL query/queries', 'English', 'admin', 'en', NULL),
(261, 'tables_fields', 'Tables/Fields', 'English', 'admin', 'en', NULL),
(262, 'show_query_again', 'Show this query again', 'English', 'admin', 'en', NULL),
(263, 'clear', 'Clear', 'English', 'admin', 'en', NULL),
(264, 'clear_confirm', 'Are you sure you want to clear your form?', 'English', 'admin', 'en', NULL),
(265, 'add_field', 'Add Field', 'English', 'admin', 'en', NULL),
(266, 'edit_field', 'Edit Field', 'English', 'admin', 'en', NULL),
(267, 'field_added', 'Field added.', 'English', 'admin', 'en', NULL),
(268, 'field_exists', 'Field already exists.', 'English', 'admin', 'en', NULL),
(269, 'field_length_incorrect', 'Field length invalid. Only digits allowed.', 'English', 'admin', 'en', NULL),
(270, 'field_name_incorrect', 'Field name should consist of letters and numbers only. Length 2-20.', 'English', 'admin', 'en', NULL),
(271, 'field_default_incorrect', 'You must choose default from values above.', 'English', 'admin', 'en', NULL),
(272, 'name', 'Name', 'English', 'admin', 'en', NULL),
(273, 'show_on_pages', 'Show On Pages', 'English', 'admin', 'en', NULL),
(274, 'suggest_listing', 'Suggest Listing', 'English', 'common', 'en', NULL),
(275, 'listing_details', 'Listing Details', 'English', 'common', 'en', NULL),
(276, 'required_field', 'Required Field', 'English', 'admin', 'en', NULL),
(277, 'visible_for_admin', 'Visible for admin only', 'English', 'admin', 'en', NULL),
(278, 'field_type', 'Field type', 'English', 'admin', 'en', NULL),
(279, 'field_length', 'Field length', 'English', 'admin', 'en', NULL),
(280, 'field_default', 'Field default value', 'English', 'admin', 'en', NULL),
(281, 'file_prefix', 'File Prefix', 'English', 'admin', 'en', NULL),
(282, 'image_height', 'Image Height', 'English', 'admin', 'en', NULL),
(283, 'image_width', 'Image Width', 'English', 'common', 'en', NULL),
(284, 'item_value', 'Item Value', 'English', 'admin', 'en', NULL),
(285, 'add_item_value', 'Add Item Value', 'English', 'admin', 'en', NULL),
(286, 'remove', 'Remove', 'English', 'common', 'en', NULL),
(287, 'of', 'of', 'English', 'common', 'en', NULL),
(288, 'first_page', 'First Page', 'English', 'common', 'en', NULL),
(289, 'previous_page', 'Previous Page', 'English', 'common', 'en', NULL),
(290, 'next_page', 'Next Page', 'English', 'common', 'en', NULL),
(291, 'last_page', 'Last Page', 'English', 'common', 'en', NULL),
(292, 'no_broken', 'No broken listings.', 'English', 'admin', 'en', NULL),
(293, 'no_norecip', 'No non-reciprocal listings.', 'English', 'admin', 'en', NULL),
(294, 'no_featured', 'No featured listings.', 'English', 'admin', 'en', NULL),
(295, 'no_partner', 'No partner listings.', 'English', 'admin', 'en', NULL),
(296, 'no_listings', 'No listings yet created. <a href="suggest-listing.php?id=0" style="font-weight: bold;">Click here</a> to add new one.', 'English', 'common', 'en', NULL),
(297, 'mark_as', 'Mark As', 'English', 'admin', 'en', NULL),
(298, 'check', 'Check', 'English', 'admin', 'en', NULL),
(299, 'config_groups', 'Configuration Groups', 'English', 'admin', 'en', NULL),
(300, 'search_by_keywords', 'Search by Keywords', 'English', 'admin', 'en', NULL),
(301, 'any_word', 'any word', 'English', 'common', 'en', NULL),
(302, 'all_words', 'all words', 'English', 'common', 'en', NULL),
(303, 'exact_match', 'exact match', 'English', 'common', 'en', NULL),
(304, 'search_by_dates', 'Search by dates', 'English', 'admin', 'en', NULL),
(305, 'header_incorrect', 'Listing header is unknown. Please check it manually.', 'English', 'admin', 'en', NULL),
(306, 'recip_incorrect', 'Please check it manually. Reciprocal link seems to be invalid.', 'English', 'admin', 'en', NULL),
(307, 'from_incorrect', 'Please specify the "From" address.', 'English', 'admin', 'en', NULL),
(308, 'email_message_sent', 'Your message being sent right now.', 'English', 'admin', 'en', NULL),
(309, 'incorrect_key', 'Phrase key is incorrect.', 'English', 'admin', 'en', NULL),
(310, 'incorrect_value', 'Please enter the value of the key.', 'English', 'admin', 'en', NULL),
(311, 'key_not_valid', 'Key is not valid only alphanumeric and underscore characters allowed.', 'English', 'admin', 'en', NULL),
(312, 'key_exists', 'The phrase with similar key already exists', 'English', 'admin', 'en', NULL),
(313, 'lang_incorrect', 'Please choose correct language.', 'English', 'admin', 'en', NULL),
(314, 'incorrect_text_field', 'Text field is incorrect.', 'English', 'admin', 'en', NULL),
(315, 'search_in_phrases', 'Search in Phrases', 'English', 'admin', 'en', NULL),
(316, 'download_lang', 'Export Language', 'English', 'admin', 'en', NULL),
(317, 'compare_languages', 'Compare Languages', 'English', 'admin', 'en', NULL),
(318, 'new_language', 'New Language', 'English', 'admin', 'en', NULL),
(319, 'copy_language', 'Copy Language', 'English', 'admin', 'en', NULL),
(320, 'add_phrase', 'Add Phrase', 'English', 'admin', 'en', NULL),
(321, 'language', 'Language', 'English', 'common', 'en', NULL),
(322, 'default', 'Default', 'English', 'common', 'en', NULL),
(323, 'edit_translate', 'Edit / Translate {language} phrases', 'English', 'admin', 'en', NULL),
(324, 'set_default', 'Set Default', 'English', 'common', 'en', NULL),
(325, 'download', 'Download', 'English', 'common', 'en', NULL),
(326, 'download_upload', 'Export/Import', 'English', 'admin', 'en', NULL),
(327, 'phrase_group', 'Phrase Group', 'English', 'admin', 'en', NULL),
(328, 'all_groups', 'All Groups', 'English', 'admin', 'en', NULL),
(329, 'display', 'Display', 'English', 'admin', 'en', NULL),
(330, 'no_search_results', 'No results found matching your criteria.', 'English', 'admin', 'en', NULL),
(331, 'about', 'About Us', 'English', 'frontend', 'en', NULL),
(332, 'account_created', 'Account created! Thank you!', 'English', 'common', 'en', NULL),
(333, 'advanced_search', 'Advanced Search', 'English', 'frontend', 'en', NULL),
(334, 'advertise', 'Advertise Us', 'English', 'frontend', 'en', NULL),
(335, 'approval_listings', 'Waiting Approval', 'English', 'common', 'en', NULL),
(336, 'ascending', 'ascending', 'English', 'frontend', 'en', NULL),
(337, 'author_email', 'Author Email', 'English', 'frontend', 'en', NULL),
(338, 'category_title', 'Category title', 'English', 'frontend', 'en', NULL),
(339, 'category_submitted', 'Category was submitted for consideration!', 'English', 'frontend', 'en', NULL),
(340, 'change_password', 'Change Password', 'English', 'frontend', 'en', NULL),
(341, 'characters_left', 'characters left', 'English', 'common', 'en', NULL),
(342, 'click_here', 'Click here', 'English', 'frontend', 'en', NULL),
(343, 'comment_added', 'Comment added.', 'English', 'common', 'en', NULL),
(344, 'comment_author', 'Comment Author', 'English', 'frontend', 'en', NULL),
(345, 'comment_rank', 'Listing Rank: ', 'English', 'frontend', 'en', NULL),
(346, 'company_info', 'Company Info', 'English', 'frontend', 'en', NULL),
(347, 'company_jobs', 'Company Jobs', 'English', 'frontend', 'en', NULL),
(348, 'company_policy', 'Company Policy', 'English', 'frontend', 'en', NULL),
(349, 'company_terms', 'Terms Of Service', 'English', 'frontend', 'en', NULL),
(350, 'complete_submission', 'Complete submission', 'English', 'frontend', 'en', NULL),
(351, 'confirmation_sent', 'Confirmation for password change request sent.', 'English', 'frontend', 'en', NULL),
(352, 'current_password', 'Current Password', 'English', 'frontend', 'en', NULL),
(353, 'description_empty', 'Description is empty!', 'English', 'frontend', 'en', NULL),
(354, 'descending', 'descending', 'English', 'frontend', 'en', NULL),
(355, 'edit_account', 'Edit Account', 'English', 'common', 'en', NULL),
(356, 'edit_info', 'Edit Info', 'English', 'frontend', 'en', NULL),
(357, 'edit_listing', 'Edit Listing', 'English', 'common', 'en', NULL),
(358, 'account_email_exists', 'Account with this email already exists!', 'English', 'common', 'en', NULL),
(359, 'account_listings', 'My listings', 'English', 'frontend', 'en', NULL),
(360, 'account_login', 'Account Login', 'English', 'frontend', 'en', NULL),
(361, 'account_no_listings', 'You have not submitted any listings. Please choose correct category and make sure it fits your listing best. Then click SUGGEST LISTING, input requested information and submit it. <br /> Usually it takes about 24 hours for a listing to be reviewed by administrator.', 'English', 'frontend', 'en', NULL),
(362, 'accounts_area', 'Accounts Area', 'English', 'frontend', 'en', NULL),
(363, 'error', 'Error', 'English', 'common', 'en', NULL),
(364, 'featured_listings', 'Featured', 'English', 'common', 'en', NULL),
(365, 'first', 'First', 'English', 'common', 'en', NULL),
(366, 'free', 'Free', 'English', 'frontend', 'en', NULL),
(367, 'friend_fullname', 'Your friend''s fullname', 'English', 'frontend', 'en', NULL),
(368, 'friend_told', 'Message has just been sent to your friend.', 'English', 'frontend', 'en', NULL),
(369, 'forgot', 'Forgot password?', 'English', 'frontend', 'en', NULL),
(370, 'last', 'Last', 'English', 'common', 'en', NULL),
(371, 'leave_comment', 'Leave Comment', 'English', 'frontend', 'en', NULL),
(372, 'listing_added', 'Listing added', 'English', 'common', 'en', NULL),
(373, 'listing_changed', 'Listing changed', 'English', 'frontend', 'en', NULL),
(374, 'listing_rank', 'Listing Rank', 'English', 'common', 'en', NULL),
(375, 'listing_status', 'Listing Status', 'English', 'common', 'en', NULL),
(376, 'listing_submitted', 'Thank you! Your listing was submitted for consideration', 'English', 'frontend', 'en', NULL),
(377, 'listings_found', 'Listings Found: ', 'English', 'frontend', 'en', NULL),
(378, 'logged_out', 'You have been logged out.', 'English', 'frontend', 'en', NULL),
(379, 'my_categories', 'My Categories', 'English', 'frontend', 'en', NULL),
(380, 'my_listings', 'My listings', 'English', 'frontend', 'en', NULL),
(381, 'new_listings', 'New listings', 'English', 'frontend', 'en', NULL),
(382, 'new_password', 'New Password', 'English', 'frontend', 'en', NULL),
(383, 'new_password2', 'New Password[confirm]', 'English', 'frontend', 'en', NULL),
(384, 'new_password_sent', 'New password has just been sent to account email!', 'English', 'frontend', 'en', NULL),
(385, 'neighbour_categories', 'Neighbour Categories', 'English', 'frontend', 'en', NULL),
(386, 'next', 'Next', 'English', 'common', 'en', NULL),
(387, 'no_results', 'No results', 'English', 'frontend', 'en', NULL),
(388, 'not_found_listings', 'No listings found. Please try to broaden your search criterias!', 'English', 'frontend', 'en', NULL),
(389, 'not_available', 'Not available', 'English', 'frontend', 'en', NULL),
(390, 'no_approval_listings', 'No listings waiting for approval in your categories', 'English', 'frontend', 'en', NULL),
(391, 'not_rated', 'This listing is not rated yet. Be the first who rates it!', 'English', 'frontend', 'en', NULL),
(392, 'partner_listings', 'Partner listings', 'English', 'common', 'en', NULL),
(393, 'policy', 'Privacy Policy', 'English', 'frontend', 'en', NULL),
(394, 'previous', 'Previous', 'English', 'common', 'en', NULL),
(395, 'reason', 'Reason', 'English', 'frontend', 'en', NULL),
(396, 'related_categories', 'Related Categories', 'English', 'common', 'en', NULL),
(397, 'restore_password', 'Restore password', 'English', 'common', 'en', NULL),
(398, 'statistics', 'Statistics', 'English', 'common', 'en', NULL),
(399, 'submit', 'Submit', 'English', 'common', 'en', NULL),
(400, 'submission', 'Submission', 'English', 'frontend', 'en', NULL),
(401, 'manage_listings', 'Manage Listings', 'English', 'admin', 'en', NULL),
(402, 'suggest_category_top1', 'You are going to suggest category here:', 'English', 'frontend', 'en', NULL),
(403, 'suggest_listing_top1', 'You are going to suggest your listing to the following category:', 'English', 'frontend', 'en', NULL),
(404, 'suggest_listing_top2', 'Please make sure your listing fits this category.', 'English', 'frontend', 'en', NULL),
(405, 'password_changed', 'Password has been successfully changed.', 'English', 'frontend', 'en', NULL),
(406, 'passwords_dont_match', 'Passwords you entered do not match.', 'English', 'frontend', 'en', NULL),
(407, 'password_empty', 'You have not entered a new password.', 'English', 'frontend', 'en', NULL),
(408, 'popular_listings', 'Popular listings', 'English', 'frontend', 'en', NULL),
(409, 'posted', 'posted on ', 'English', 'frontend', 'en', NULL),
(410, 'rate_listing', 'Rate Listing', 'English', 'frontend', 'en', NULL),
(411, 'report_broken_listing', 'Report Broken Listing', 'English', 'frontend', 'en', NULL),
(412, 'rating_num', 'Number of Ratings:', 'English', 'frontend', 'en', NULL),
(413, 'reciprocal_empty', 'Reciprocal link is empty!', 'English', 'frontend', 'en', NULL),
(414, 'register', 'Register', 'English', 'frontend', 'en', NULL),
(415, 'register_account', 'Do not have an account?', 'English', 'frontend', 'en', NULL),
(416, 'submission_confirmation', 'Please verify if submitted information is correct.', 'English', 'frontend', 'en', NULL),
(417, 'upgrade_listing', 'Upgrade Listing', 'English', 'frontend', 'en', NULL),
(418, 'url_empty', 'url is empty!', 'English', 'frontend', 'en', NULL),
(419, 'username_empty', 'Make sure you entered valid username or your account is active.', 'English', 'frontend', 'en', NULL),
(420, 'terms', 'Terms of Use', 'English', 'frontend', 'en', NULL),
(421, 'title_empty', 'Title is empty!', 'English', 'frontend', 'en', NULL),
(422, 'thanks', 'Thank you.', 'English', 'frontend', 'en', NULL),
(423, 'thank_text', 'to get back to index page.', 'English', 'frontend', 'en', NULL),
(424, 'thanks_for_vote', 'Thanks for vote.', 'English', 'frontend', 'en', NULL),
(425, 'top_listings', 'Top listings', 'English', 'frontend', 'en', NULL),
(426, 'total_num_categories', 'Number of categories:', 'English', 'frontend', 'en', NULL),
(427, 'total_num_listings', 'Number of listings:', 'English', 'frontend', 'en', NULL),
(428, 'transaction_failed', 'Transaction failed! Please contact us!', 'English', 'frontend', 'en', NULL),
(429, 'transaction_failed2', 'Stop trying hack our site! Your ip is has been tracked!', 'English', 'frontend', 'en', NULL),
(430, 'transaction_success_title', 'Transaction successful!', 'English', 'frontend', 'en', NULL),
(431, 'transaction_success', 'Transaction successful! You will be sent an email within 24 hours!', 'English', 'frontend', 'en', NULL),
(432, 'view_amazon', 'View Amazon Info', 'English', 'frontend', 'en', NULL),
(433, 'view_listing', 'View Listing', 'English', 'frontend', 'en', NULL),
(434, 'admin_deleted', 'Selected admin successfully deleted', 'English', 'admin', 'en', NULL),
(435, 'view_my_listings', 'View My listings', 'English', 'frontend', 'en', NULL),
(436, 'view_my_categories', 'Categories To Edit', 'English', 'frontend', 'en', NULL),
(437, 'your_email', 'Your email', 'English', 'frontend', 'en', NULL),
(438, 'your_listing_category', 'Your listing category', 'English', 'frontend', 'en', NULL),
(439, 'your_listing_url', 'Your listing URL', 'English', 'frontend', 'en', NULL),
(440, 'your_listing_title', 'Your listing title', 'English', 'frontend', 'en', NULL),
(441, 'your_listing_description', 'Your listing description', 'English', 'frontend', 'en', NULL),
(442, 'your_listing_reciprocal', 'Listing reciprocal URL', 'English', 'frontend', 'en', NULL),
(443, 'your_message', 'Your message here', 'English', 'frontend', 'en', NULL),
(444, 'your_password', 'Your password', 'English', 'frontend', 'en', NULL),
(445, 'your_password_confirm', 'Confirm your password', 'English', 'frontend', 'en', NULL),
(446, 'your_username', 'Your username', 'English', 'frontend', 'en', NULL),
(447, 'your_username_here', 'Your username here:', 'English', 'frontend', 'en', NULL),
(448, 'welcome', 'Welcome', 'English', 'frontend', 'en', NULL),
(449, 'wrong_image_type', 'Only following image types are allowed (<i>{types}</i>) for `{name}` field', 'English', 'common', 'en', NULL),
(450, 'sort_listings_by', 'Sort listings by: ', 'English', 'frontend', 'en', NULL),
(451, 'alphabetic', 'Alphabetic', 'English', 'frontend', 'en', NULL),
(452, 'error_already_voted', 'You''ve already voted. Please try later.', 'English', 'frontend', 'en', NULL),
(453, 'error_banned', 'Listing was banned. Please do not try to add it again.', 'English', 'frontend', 'en', NULL),
(454, 'error_broken_listing', 'Listing seems to be broken. Please check it manually.', 'English', 'common', 'en', NULL),
(455, 'error_captcha', 'Your confirmation code is incorrect.', 'English', 'frontend', 'en', NULL),
(456, 'error_category_empty', 'Please go into appropriate category and become account there.', 'English', 'frontend', 'en', NULL),
(457, 'error_category_exists', 'Category was already suggested before.', 'English', 'frontend', 'en', NULL),
(458, 'error_category_locked', 'This category is locked by administrator.', 'English', 'frontend', 'en', NULL),
(459, 'error_contact_fullname', 'Please fill in full name.', 'English', 'frontend', 'en', NULL),
(460, 'error_directory_readonly', 'Uploads directory is readonly. Please make it writable.', 'English', 'frontend', 'en', NULL),
(461, 'error_email_incorrect', 'Make sure you entered valid email.', 'English', 'common', 'en', NULL),
(462, 'error_listing_present', 'Your listing already exists in directory.', 'English', 'common', 'en', NULL),
(463, 'error_file_upload', 'Unknown error during file upload.', 'English', 'frontend', 'en', NULL),
(464, 'error_max_description', 'Your description length should be less than {num} symbols.', 'English', 'frontend', 'en', NULL),
(465, 'error_min_description', 'Your description length should be more than {num} symbols.', 'English', 'frontend', 'en', NULL),
(466, 'error_comment', 'Make sure you entered valid comment.', 'English', 'frontend', 'en', NULL),
(467, 'error_comment_author', 'Make sure you entered valid comment author.', 'English', 'frontend', 'en', NULL),
(468, 'error_comment_email', 'Make sure you entered valid author email.', 'English', 'frontend', 'en', NULL),
(469, 'error_max_comment', 'Your comment length should be less than {maxLength} symbols.', 'English', 'frontend', 'en', NULL),
(470, 'error_min_comment', 'Your comment length should be more than {minLength} symbols.', 'English', 'frontend', 'en', NULL),
(471, 'error_no_account_email', 'No accounts registered with this email.', 'English', 'frontend', 'en', NULL),
(472, 'error_root_category', 'You can not suggest in root category. Please choose an appropiate category and try again.', 'English', 'frontend', 'en', NULL),
(473, 'error_suggest_logged', 'You should be logged in to suggest listings.', 'English', 'frontend', 'en', NULL),
(474, 'error_password_empty', 'Please input correct password.', 'English', 'common', 'en', NULL),
(475, 'error_password_match', 'Passwords do not match.', 'English', 'common', 'en', NULL),
(476, 'error_reciprocal_listing', 'Please input correct reciprocal link.', 'English', 'frontend', 'en', NULL),
(477, 'error_reciprocal_domain', 'Please make sure you use a backlink from your domain.', 'English', 'frontend', 'en', NULL),
(478, 'error_username_empty', 'Please input correct username.', 'English', 'common', 'en', NULL),
(479, 'error_username_exists', 'Username already taken. Please input different username.', 'English', 'common', 'en', NULL),
(480, 'error_account_incorrect', 'Please fill in username.', 'English', 'frontend', 'en', NULL),
(481, 'error_accountpsw_incorrect', 'Please fill in password.', 'English', 'frontend', 'en', NULL),
(482, '200', 'URL located, content follows (200)', 'English', 'frontend', 'en', NULL),
(483, '301', 'Object moved permanently (301)', 'English', 'frontend', 'en', NULL),
(484, '302', 'Object moved (302)', 'English', 'frontend', 'en', NULL),
(485, '304', 'Not modified (304)', 'English', 'frontend', 'en', NULL),
(486, '400', 'Bad request (400)', 'English', 'frontend', 'en', NULL),
(487, '401', 'Unauthorized(401)', 'English', 'frontend', 'en', NULL),
(488, '403', 'Forbidden (403)', 'English', 'frontend', 'en', NULL),
(489, '404', 'Requested URL not found (404)', 'English', 'frontend', 'en', NULL),
(490, '500', 'Unknown server error (500)', 'English', 'frontend', 'en', NULL),
(491, '503', 'Server capacity reached (503)', 'English', 'frontend', 'en', NULL),
(492, '666', 'Error occurred while paid listing submission. Please try to sugget a listing again.', 'English', 'frontend', 'en', NULL),
(493, '670', 'Accounts functionality disabled by administrator.', 'English', 'frontend', 'en', NULL),
(494, '671', 'Permission denied. You don''t have enough permission to modify that listing.', 'English', 'common', 'en', NULL),
(495, '672', 'Suggest category functionality disabled by administrator.', 'English', 'frontend', 'en', NULL),
(496, '673', 'Your IP-address was banned by administrator', 'English', 'frontend', 'en', NULL),
(497, 'cancel', 'Cancel', 'English', 'common', 'en', NULL),
(498, 'click_here_to_edit', 'Click here to edit.', 'English', 'common', 'en', NULL),
(499, 'reset', 'Reset', 'English', 'common', 'en', NULL),
(500, 'key', 'Key', 'English', 'common', 'en', NULL),
(501, 'value', 'Value', 'English', 'common', 'en', NULL),
(502, 'import_from_server', 'Import the language file from your server', 'English', 'admin', 'en', NULL),
(503, 'import_from_pc', 'Import the language file from PC', 'English', 'admin', 'en', NULL),
(504, 'filename', 'Filename', 'English', 'common', 'en', NULL),
(505, 'all_languages', 'All Languages', 'English', 'common', 'en', NULL),
(506, 'search_in', 'Search in', 'English', 'common', 'en', NULL),
(507, 'phrase_text', 'Phrase Text', 'English', 'admin', 'en', NULL),
(508, 'phrase_var', 'Phrase Variable Name', 'English', 'admin', 'en', NULL),
(509, 'phrase_text_var', 'Phrase Text and Phrase Variable Name', 'English', 'admin', 'en', NULL),
(510, 'search_for_text', 'Search for Text', 'English', 'common', 'en', NULL),
(511, 'save', 'Save', 'English', 'common', 'en', NULL),
(512, 'no_backlink', 'No backlink', 'English', 'common', 'en', NULL),
(513, 'type', 'Type', 'English', 'admin', 'en', NULL),
(514, 'impressions', 'Impressions', 'English', 'admin', 'en', NULL),
(515, 'position', 'Position', 'English', 'common', 'en', NULL),
(516, 'include_subcats', 'Including subcategories', 'English', 'admin', 'en', NULL),
(517, 'other', 'Other', 'English', 'common', 'en', NULL),
(518, 'target', 'Target', 'English', 'admin', 'en', NULL),
(519, 'content', 'Content', 'English', 'admin', 'en', NULL),
(520, 'choose_file_upload', 'Choose a file to upload', 'English', 'admin', 'en', NULL),
(521, 'content_incorrect', 'Content can not be empty.', 'English', 'admin', 'en', NULL),
(522, 'copy', 'Copy', 'English', 'common', 'en', NULL),
(523, 'field_is_empty', '"{field}" is empty.', 'English', 'common', 'en', NULL),
(524, 'broken_report_sent', 'A report has been sent to the site administrator.', 'English', 'frontend', 'en', NULL),
(525, 'report', 'Report', 'English', 'common', 'en', NULL),
(526, 'close', 'Close', 'English', 'common', 'en', NULL),
(527, 'report_as_broken', 'Report the link {lurl} as being broken.', 'English', 'frontend', 'en', NULL),
(528, 'do_you_want_report_broken', 'Do you want to report broken listing?', 'English', 'frontend', 'en', NULL),
(529, 'remote_host', 'Remote host(IP more preferred)', 'English', 'admin', 'en', NULL),
(530, 'remote_db', 'Remote database', 'English', 'admin', 'en', NULL),
(531, 'remote_user', 'Remote username', 'English', 'admin', 'en', NULL),
(532, 'remote_pass', 'Remote password', 'English', 'admin', 'en', NULL),
(533, 'remote_prefix', 'Remote table prefix', 'English', 'admin', 'en', NULL),
(534, 'import_box', 'Importing', 'English', 'admin', 'en', NULL),
(535, 'manage_cache', 'Manage Cache', 'English', 'admin', 'en', NULL),
(536, 'ascii_required', 'Only alphanumeric ASCII characters are allowed', 'English', 'common', 'en', NULL),
(537, '1', 'Not available', 'English', 'frontend', 'en', NULL),
(538, 'expire', 'Expire', 'English', 'common', 'en', NULL),
(539, 'vote', 'Vote', 'English', 'common', 'en', NULL),
(540, 'error_invalid_path', 'Invalid category path', 'English', 'admin', 'en', NULL),
(541, 'tree', 'Tree', 'English', 'admin', 'en', NULL),
(542, 'category_cannot_be_moved', 'This category cannot be moved to its child category or to itself: {move_to}', 'English', 'admin', 'en', NULL),
(543, 'oops', 'Oops!', 'English', 'common', 'en', NULL),
(544, 'folder_incorrect_permissions', 'Sorry, you have not set necessary permissions. Please set writable permissions for the following directory {name}', 'English', 'common', 'en', NULL),
(545, 'generated_path_exists', 'Generated path: <i>{name}</i> already exists please specify another path or change your title slightly', 'English', 'admin', 'en', NULL),
(546, 'expire_date', 'Expire date', 'English', 'common', 'en', NULL),
(547, 'random_listings', 'Random listings', 'English', 'frontend', 'en', NULL),
(548, 'image_keepratio', 'Keep image ratio', 'English', 'admin', 'en', NULL),
(549, 'total_votes', 'Total <b>{num}</b> votes', 'English', 'common', 'en', NULL),
(550, 'category_cannot_be_copied', 'This category cannot be copied to its child category or to itself: {copy_to}', 'English', 'admin', 'en', NULL),
(551, 'suggest_category', 'Suggest Category', 'English', 'common', 'en', NULL),
(552, 'plugin_uninstalled', 'Selected plugin uninstalled successfully', 'English', 'admin', 'en', NULL),
(553, 'uninstall', 'Uninstall', 'English', 'admin', 'en', NULL),
(554, 'plugin_installed', 'Plugin successfully installed', 'English', 'admin', 'en', NULL),
(555, 'import_and_install', 'Import & install', 'English', 'admin', 'en', NULL),
(556, 'file_doesnt_exist', 'File doesn''t exist', 'English', 'admin', 'en', NULL),
(557, 'import_plugin_from_server', 'Import plugin installer file from this server (specify an absolute path). You can also type an URL.', 'English', 'admin', 'en', NULL),
(558, 'import_plugin_installer', 'Upload plugins installer XML file (in most cases install.xml)', 'English', 'admin', 'en', NULL),
(559, 'active_plugins', 'Active plugins', 'English', 'admin', 'en', NULL),
(560, 'plugins', 'Plugins', 'English', 'admin', 'en', NULL),
(561, 'parent_category', 'Parent category', 'English', 'common', 'en', NULL),
(562, 'manage_blocks', 'Manage Blocks', 'English', 'admin', 'en', NULL),
(563, 'block', 'Block', 'English', 'admin', 'en', NULL),
(564, 'no_blocks', 'There is no blocks', 'English', 'admin', 'en', NULL),
(565, 'add_block', 'Add Block', 'English', 'admin', 'en', NULL),
(566, 'edit_block', 'Edit Block', 'English', 'admin', 'en', NULL),
(567, 'contents', 'Contents', 'English', 'admin', 'en', NULL),
(568, 'block_created', 'Block created', 'English', 'admin', 'en', NULL),
(569, 'broken_listings', 'Broken Listings', 'English', 'admin', 'en', NULL),
(570, 'banned_listings', 'Banned listings', 'English', 'admin', 'en', NULL),
(571, 'nonrecip_listings', 'Non-reciprocal Listings', 'English', 'admin', 'en', NULL),
(572, 'reciprocal_listings', 'Reciprocal Listings', 'English', 'admin', 'en', NULL),
(573, 'create_category', 'Create Category', 'English', 'admin', 'en', NULL),
(574, 'create_listing', 'Create Listing', 'English', 'admin', 'en', NULL),
(575, 'whoisonline', 'Who is online right now', 'English', 'admin', 'en', NULL),
(576, 'create_admin', 'Create Admin', 'English', 'admin', 'en', NULL),
(577, 'plugin', 'Plugin', 'English', 'admin', 'en', NULL),
(578, 'manage_plugins', 'Manage Plugins', 'English', 'admin', 'en', NULL),
(579, 'blocks', 'Blocks', 'English', 'admin', 'en', NULL),
(580, 'admin_comment', 'Admin comment', 'English', 'admin', 'en', NULL),
(581, 'searchable', 'Searchable', 'English', 'common', 'en', NULL),
(582, 'file_types', 'Allowed file types (comma separated values (don''t include point), example: pdf, doc, odf, mov)', 'English', 'common', 'en', NULL),
(583, 'fulltext_search', 'Fulltext search', 'English', 'admin', 'en', NULL),
(584, 'section', 'Search section', 'English', 'common', 'en', NULL),
(585, 'manage_sections', 'Manage Search sections', 'English', 'admin', 'en', NULL),
(586, 'sections', 'Search sections', 'English', 'common', 'en', NULL),
(587, 'section_added', 'Section added', 'English', 'admin', 'en', NULL),
(588, 'section_exists', 'Section exists', 'English', 'admin', 'en', NULL),
(589, 'contains', 'Contains', 'English', 'common', 'en', NULL),
(590, 'where', 'Where', 'English', 'common', 'en', NULL),
(591, 'search_match', 'Match', 'English', 'common', 'en', NULL),
(592, 'relevance', 'Relevance', 'English', 'common', 'en', NULL),
(593, 'perpage', 'Per page', 'English', 'common', 'en', NULL),
(594, 'output_settings', 'Output settings', 'English', 'common', 'en', NULL),
(595, 'no_sections', 'No sections created. Please <a href="manage-sections.php?action=add">click here</a> to create a section.', 'English', 'admin', 'en', NULL),
(596, 'admins_deleted', 'Selected admins successfully deleted', 'English', 'admin', 'en', NULL),
(597, 'access_denied', '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">\n<html><head>\n<title>403 Forbidden</title>\n</head><body>\n<h1>Forbidden</h1>\n<p>You don''t have permission to access this page on this server.</p>\n<a href="javascript:history.go(-1)">« Back</a>\n</body></html>', 'English', 'admin', 'en', NULL),
(598, 'deep_links', 'Deep links', 'English', 'common', 'en', NULL),
(599, 'too_big_value', 'Too big value for "<i>{name}</i>"', 'English', 'admin', 'en', NULL),
(600, 'search_listings', 'Search Listings', 'English', 'admin', 'en', NULL),
(601, 'approval_accounts', 'Approval Accounts', 'English', 'admin', 'en', NULL),
(602, 'active_accounts', 'Active accounts', 'English', 'admin', 'en', NULL),
(603, 'search_account', 'Search Account', 'English', 'admin', 'en', NULL),
(604, 'create_account', 'Create Account', 'English', 'admin', 'en', NULL),
(605, 'filter_by_status', 'Filter by status', 'English', 'admin', 'en', NULL),
(606, 'filter_by_state', 'Filter by state', 'English', 'admin', 'en', NULL),
(607, 'active_listings', 'Active Listings', 'English', 'admin', 'en', NULL),
(608, 'approval_categories', 'Approval Categories', 'English', 'admin', 'en', NULL),
(609, 'active_categories', 'Active Categories', 'English', 'admin', 'en', NULL),
(610, 'start_search', 'Start search', 'English', 'common', 'en', NULL);
INSERT INTO `[[dbprefix]]language` VALUES
(611, 'confirmation', 'Confirmation', 'English', 'common', 'en', NULL),
(612, 'na', 'n/a', 'English', 'common', 'en', NULL),
(613, 'loading', 'Loading ...', 'English', 'common', 'en', NULL),
(614, 'phrase_added', 'Phrase added', 'English', 'admin', 'en', NULL),
(615, 'are_you_sure_to_delete', 'Are you sure you want to delete', 'English', 'admin', 'en', NULL),
(616, 'are_you_sure_to_resend_confirmation', 'Are you sure you want to resend confirmation email?', 'English', 'admin', 'en', NULL),
(617, 'are_you_sure_to_delete_selected_blocks', 'Are you sure you want to delete selected blocks?', 'English', 'admin', 'en', NULL),
(618, 'are_you_sure_to_delete_this_block', 'Are you sure you want to delete this block?', 'English', 'admin', 'en', NULL),
(619, 'are_you_sure_to_delete_this_category', 'Are you sure you want to delete this category? All its subcategories and listings will be deleted too!', 'English', 'admin', 'en', NULL),
(620, 'are_you_sure_to_delete_selected_categories', 'Are you sure you want to delete selected categories? All its subcategories and listings will be deleted too!', 'English', 'admin', 'en', NULL),
(621, 'are_you_sure_to_delete_selected_admins', 'Are you sure you want to delete selected administrators?', 'English', 'admin', 'en', NULL),
(622, 'are_you_sure_to_delete_selected_comments', 'Are you sure you want to delete selected comments?', 'English', 'admin', 'en', NULL),
(623, 'are_you_sure_to_delete_this_admin', 'Are you sure you want to delete this administrator?', 'English', 'admin', 'en', NULL),
(624, 'are_you_sure_to_delete_this_listing', 'Are you sure you want to delete this listing?', 'English', 'admin', 'en', NULL),
(625, 'are_you_sure_to_this_listing_featured', 'Are you sure you don''t want to have this listing featured?', 'English', 'admin', 'en', NULL),
(626, 'are_you_sure_to_remove_featured', 'Are you sure you don''t want to have this listings as featured?', 'English', 'admin', 'en', NULL),
(627, 'are_you_sure_to_this_listing_partner', 'Are you sure you want to mark this listing as partner', 'English', 'admin', 'en', NULL),
(628, 'are_you_sure_to_remove_partner', 'Are you sure you don''t want to have this listing as partner', 'English', 'admin', 'en', NULL),
(629, 'are_you_sure_to_remove_crosslink', 'Are you sure you want to remove this cross link?', 'English', 'admin', 'en', NULL),
(630, 'are_you_sure_to_delete_this_account', 'Are you sure you want to delete this account?', 'English', 'admin', 'en', NULL),
(631, 'are_you_sure_to_delete_this_listing_field', 'Are you sure you want to delete this listing field? Note: Whole column including its data will be deleted!', 'English', 'admin', 'en', NULL),
(632, 'are_you_sure_to_delete_this_page', 'Are you sure you want to delete this page?', 'English', 'admin', 'en', NULL),
(633, 'are_you_sure_to_delete_this_comment', 'Are you sure you want to delete this comment?', 'English', 'admin', 'en', NULL),
(634, 'are_you_sure_to_delete_category_relationship', 'Are you sure you want to remove category relationship?', 'English', 'admin', 'en', NULL),
(635, 'are_you_sure_to_delete_category_crossing', 'Are you sure you want to delete crossed category?', 'English', 'admin', 'en', NULL),
(636, 'are_you_sure_to_remove_selected_from_featured', 'Are you sure you want to remove featured mark from selected listings?', 'English', 'admin', 'en', NULL),
(637, 'are_you_sure_to_delete_selected_listings', 'Are you sure you want to delete selected listings? Note: There is no Undo!', 'English', 'admin', 'en', NULL),
(638, 'are_you_sure_to_delete_selected_accounts', 'Are you sure you want to delete selected accounts?', 'English', 'admin', 'en', NULL),
(639, 'are_you_sure_to_delete_this_page', 'Are you sure you want to delete this page?', 'English', 'admin', 'en', NULL),
(640, 'are_you_sure_to_delete_selected_pages', 'Are you sure you want to delete selected pages?', 'English', 'admin', 'en', NULL),
(641, 'are_you_sure_to_logout', 'Are you sure you want to logout?', 'English', 'admin', 'en', NULL),
(642, 'edit_category', 'Edit Category', 'English', 'admin', 'en', NULL),
(643, 'lock_status', 'Lock status', 'English', 'admin', 'en', NULL),
(644, 'change', 'change', 'English', 'common', 'en', NULL),
(645, 'listing_category', 'Listing category', 'English', 'common', 'en', NULL),
(646, 'error_login', 'Either login or password is invalid', 'English', 'common', 'en', NULL),
(647, 'user_default', 'User default', 'English', 'common', 'en', NULL),
(648, 'active_listings_count', 'ACTIVE LISTINGS COUNT', 'English', 'admin', 'en', NULL),
(649, 'recount', 'recount', 'English', 'admin', 'en', NULL),
(650, 'categories_relation', 'CATEGORIES RELATION', 'English', 'admin', 'en', NULL),
(651, 'repair', 'repair', 'English', 'admin', 'en', NULL),
(652, 'listings_and_categories', 'LISTINGS AND CAT-IES', 'English', 'admin', 'en', NULL),
(653, 'find_and_delete', 'delete orphan', 'English', 'admin', 'en', NULL),
(654, 'orphan_listings_deleted', '{num} orphan listing(s) deleted!', 'English', 'admin', 'en', NULL),
(655, 'no_orphan_listings', 'No orphan listings found', 'English', 'admin', 'en', NULL),
(656, 'no_orphan_categories', 'No orphan categories found', 'English', 'admin', 'en', NULL),
(657, 'orphan_categories_deleted', '{num} orphan categories deleted', 'English', 'admin', 'en', NULL),
(658, 'admin_activity_expired', 'Admin activity expired', 'English', 'admin', 'en', NULL),
(659, 'message', 'Message', 'English', 'admin', 'en', NULL),
(660, 'source_file', 'source file', 'English', 'admin', 'en', NULL),
(661, 'line', 'Line', 'English', 'admin', 'en', NULL),
(662, 'are_you_sure_to_delete_selected_phrases', 'Are you sure you want to delete selected phrases?', 'English', 'admin', 'en', NULL),
(663, 'are_you_sure_to_delete_selected_log_messages', 'Are you sure you want to delete selected log messages?', 'English', 'admin', 'en', NULL),
(664, 'language_already_exists', 'Language already exists', 'English', 'admin', 'en', NULL),
(665, 'bad_iso', 'Bad country - ISO code.', 'English', 'admin', 'en', NULL),
(666, 'copy_default_language_to', 'Copy default language [<b> [lang] </b>] to ', 'English', 'admin', 'en', NULL),
(667, 'repair_tables', 'REPAIR TABLES', 'English', 'admin', 'en', NULL),
(668, 'language_deleted', 'Selected language successfully deleted', 'English', 'admin', 'en', NULL),
(669, 'crossed_deleted', 'Selected crossing successfully deleted', 'English', 'admin', 'en', NULL),
(670, 'related_deleted', 'Selected relations successfully deleted', 'English', 'admin', 'en', NULL),
(671, 'are_you_sure_to_delete_selected_language', 'Are you sure you want to delete selected language? Note: All phrases will be deleted. There is no undo!', 'English', 'admin', 'en', NULL),
(672, 'two_language_required_to_compare', 'At least two languages required to compare them', 'English', 'admin', 'en', NULL),
(673, 'all_fields', 'All fields', 'English', 'admin', 'en', NULL),
(674, 'compare', 'Compare', 'English', 'admin', 'en', NULL),
(675, 'differences_found', '<b>{num}</b> differences found. Compared by <b>{category}</b>', 'English', 'admin', 'en', NULL),
(676, 'add_new_values', 'Add new values', 'English', 'admin', 'en', NULL),
(677, 'phrases_added', 'Phrases added', 'English', 'admin', 'en', NULL),
(678, 'copy_with_listings', 'Do you want to copy categories with listings?', 'English', 'admin', 'en', NULL),
(679, 'tried_disapprove_current_admin', 'You''ve tried to disapprove current admin which is couldn''t be done.', 'English', 'admin', 'en', NULL),
(680, 'tried_delete_current_admin', 'You''ve tried to delete current admin which is couldn''t be done.', 'English', 'admin', 'en', NULL),
(681, 'listings_added', 'Listings added', 'English', 'admin', 'en', NULL),
(682, 'manage_acl', 'Manage ACL', 'English', 'admin', 'en', NULL),
(683, 'acl_created', 'Acl created', 'English', 'admin', 'en', NULL),
(684, 'visible_on_pages', 'Visible on pages', 'English', 'admin', 'en', NULL),
(685, 'visual_manage', 'Visual Manage', 'English', 'admin', 'en', NULL),
(686, 'exit', 'Exit', 'English', 'common', 'en', NULL),
(687, 'youre_in_manage_mode', 'You''re in manage mode', 'English', 'frontend', 'en', NULL),
(688, 'show_header', 'Show header', 'English', 'admin', 'en', NULL),
(689, 'sticky', 'Sticky', 'English', 'admin', 'en', NULL),
(690, '_check_status_', '- Check Status -', 'English', 'admin', 'en', NULL),
(691, 'destination_valid', 'Destination Valid', 'English', 'admin', 'en', NULL),
(692, 'destination_broken', 'Destination Broken', 'English', 'admin', 'en', NULL),
(693, 'reciprocal_broken', 'Reciprocal Broken', 'English', 'admin', 'en', NULL),
(694, 'regular', 'Regular', 'English', 'admin', 'en', NULL),
(695, '_type_', '- Type -', 'English', 'admin', 'en', NULL),
(696, 'all', 'All', 'English', 'admin', 'en', NULL),
(697, 'code', 'Code', 'English', 'common', 'en', NULL),
(698, 'enable_no_follow', 'Enable No-Follow', 'English', 'admin', 'en', NULL),
(699, 'lock_category', 'Lock category', 'English', 'admin', 'en', NULL),
(700, 'number_of_columns', 'Number of Columns', 'English', 'admin', 'en', NULL),
(701, 'number_of_neighbours', 'Number of Neighbours', 'English', 'admin', 'en', NULL),
(702, 'all_neighbours', 'All neighbours', 'English', 'admin', 'en', NULL),
(703, 'number_of_neigh_tip', '<i>0</i> - do not display neighbour categories', 'English', 'admin', 'en', NULL),
(704, 'number_of_cols_tip', 'value should be more than 0', 'English', 'admin', 'en', NULL),
(705, 'custom', 'Custom', 'English', 'admin', 'en', NULL),
(706, 'quick_links', 'Quick links', 'English', 'common', 'en', NULL),
(707, 'add_as_crossed_to_other_categories', 'Add also to other categories as crossed', 'English', 'common', 'en', NULL),
(708, 'suspend', 'Suspend', 'English', 'common', 'en', NULL),
(709, 'no_listings_in_category', 'No listings in this category. <a href="suggest-listing.php?id={category_id}" style="font-weight: bold;">Click here</a> to add listing to <strong>{category_title}</strong>.', 'English', 'admin', 'en', NULL),
(710, 'wrong_file_extension', 'Wrong file extension for {field} field. Please use one of the following extensions <i>{allowed}</i>', 'English', 'frontend', 'en', NULL),
(711, 'global', 'Global', 'English', 'admin', 'en', NULL),
(712, 'are_you_sure_to_delete_selected_phrase', 'Are you sure you want to delete this phrase?', 'English', 'admin', 'en', NULL),
(713, 'block_deleted', 'Selected block successfully deleted', 'English', 'admin', 'en', NULL),
(714, 'blocks_deleted', 'Selected blocks successfully deleted', 'English', 'admin', 'en', NULL),
(715, 'leave_empty_to_show_everywhere', 'Leave empty to show everywhere', 'English', 'admin', 'en', NULL),
(716, 'nothing_found', 'Nothing found', 'English', 'admin', 'en', NULL),
(717, 'compose', 'Compose', 'English', 'admin', 'en', NULL),
(718, 'bind_to_categories', 'Bind to categories', 'English', 'admin', 'en', NULL),
(719, 'start_date', 'Start date', 'English', 'admin', 'en', NULL),
(720, 'end_date', 'End date', 'English', 'admin', 'en', NULL),
(721, 'password_restore_description', 'If you see this page that means that you''ve received an email with\r\n\r\nthis URL.\r\n\r\nThis page is intended to set a new password for your administration\r\n\r\naccount.\r\n\r\n<div style="color:red;padding:10px;border:1px solid gray"><p>It is assumed that you know your username (login)</p><p>There is only one attempt!!!</p><p>Otherwise you''ll have to request restoration again (in login page)</p></div>', 'English', 'admin', 'en', NULL),
(722, 'new_password', 'New password', 'English', 'admin', 'en', NULL),
(723, 'locked', 'Locked', 'English', 'admin', 'en', NULL),
(724, 'no_follow', 'No follow', 'English', 'admin', 'en', NULL),
(725, 'categories_deleted', 'Categories deleted', 'English', 'admin', 'en', NULL),
(726, 'category_deleted', 'Category deleted', 'English', 'admin', 'en', NULL),
(727, 'listing_moved', 'Listing successfully moved', 'English', 'admin', 'en', NULL),
(728, 'listings_moved', 'Listings successfully moved', 'English', 'admin', 'en', NULL),
(729, 'listing_copied', 'Listing successfully copied', 'English', 'admin', 'en', NULL),
(730, 'listings_copied', 'Listings successfully copied', 'English', 'admin', 'en', NULL),
(731, 'listings_deleted', 'Selected listings successfully deleted', 'English', 'admin', 'en', NULL),
(732, 'listing_deleted', 'Listing deleted successfully', 'English', 'admin', 'en', NULL),
(733, 'go_back', 'Go back', 'English', 'common', 'en', NULL),
(734, 'listing_remove_reason', 'You can type removing reason (included to email) <br /><i>no affect for cross links</i>', 'English', 'admin', 'en', NULL),
(735, 'ok', 'Ok', 'English', 'common', 'en', NULL),
(736, 'multi_language', 'Multilingual', 'English', 'admin', 'en', NULL),
(737, 'editor_not_showed_listing_inactive', 'For security reasons html editor is showed only if status is active and HTML is allowed from configuration.', 'English', 'admin', 'en', NULL),
(738, 'crossed_to', 'Crossed to', 'English', 'common', 'en', NULL),
(739, 'main_cat', 'main', 'English', 'admin', 'en', NULL),
(740, 'move_listing', 'Move listing', 'English', 'frontend', 'en', NULL),
(741, 'listing_returned', 'Listing was returned back!', 'English', 'common', 'en', NULL),
(742, 'listing_move_confirmation', 'You are going to move listing to another category, please be sure you want do this. If listing has active status it will be disapproved.', 'English', 'frontend', 'en', NULL),
(743, 'listing_fin_move_confirmation', 'Are you sure you want to move this listing?', 'English', 'frontend', 'en', NULL),
(744, 'moved_from', 'Moved From', 'English', 'admin', 'en', NULL),
(745, 'update_pagerank', 'Update pagerank', 'English', 'admin', 'en', NULL),
(746, 'rate_this', 'Rate this {rate}', 'English', 'frontend', 'en', NULL),
(747, 'are_you_sure_to_cancel_listing_moving', 'Are you sure you want cancel account listing moving?', 'English', 'admin', 'en', NULL),
(748, 'add_page', 'Add Page', 'English', 'admin', 'en', NULL),
(749, 'inventory_menu', 'Inventory Menu', 'English', 'admin', 'en', NULL),
(750, 'edit_page', 'Edit Page', 'English', 'admin', 'en', NULL),
(751, 'page_added', 'Page added', 'English', 'admin', 'en', NULL),
(752, 'unique_key', 'UNIQUE key', 'English', 'admin', 'en', NULL),
(753, 'modrewrite_url_thesame', 'Non MOD-REWRITE URL the same', 'English', 'admin', 'en', NULL),
(754, 'modrewrite_url', 'Non MOD-REWRITE URL', 'English', 'admin', 'en', NULL),
(755, 'apply', 'Apply', 'English', 'common', 'en', NULL),
(756, 'favorites_added', 'The Listing has been added to favorites.', 'English', 'common', 'en', NULL),
(757, 'view_my_favorites', 'View My favorites', 'English', 'common', 'en', NULL),
(758, 'remove_from_favorites', 'Remove from favorites', 'English', 'common', 'en', NULL),
(759, 'favorites_removed', 'The Listing has been removed from favorites.', 'English', 'common', 'en', NULL),
(760, 'add_to_favorites', 'Add To Favorites', 'English', 'common', 'en', NULL),
(761, 'my_favorite_listings', 'My favorite listings', 'English', 'common', 'en', NULL),
(762, 'install', 'Install', 'English', 'admin', 'en', NULL),
(763, 'slogan', 'Want to build a Directory<br />you can be proud of?', 'English', 'frontend', 'en', NULL),
(764, 'comment_approval', 'Your comment is waiting for approval.', 'English', 'frontend', 'en', NULL),
(765, 'edit_comment', 'Edit comment', 'English', 'admin', 'en', NULL),
(766, 'add_listing_comment', 'Add Listing Comment', 'English', 'admin', 'en', NULL),
(767, 'recip_recheck', 'Recheck reciprocal', 'English', 'admin', 'en', NULL),
(768, 'error_url', 'You''ve entered invalid URL', 'English', 'common', 'en', NULL),
(769, 'plugin_is_up_to_date', 'Plugin is up to date', 'English', 'admin', 'en', NULL),
(770, 'error_occurred_while_plugin_updating', 'Unknown error occured while updating plugin', 'English', 'admin', 'en', NULL),
(771, 'vote_cast', 'vote cast', 'English', 'frontend', 'en', NULL),
(772, 'vote_casts', 'vote casts', 'English', 'frontend', 'en', NULL),
(773, 'changelog', 'Changelog', 'English', 'admin', 'en', NULL),
(774, 'upgrade_instructions', 'Upgrade instructions', 'English', 'admin', 'en', NULL),
(775, 'new_version_of_plugin_available', 'New version of plugin is available do you wish to update it? <input type="button" value="{yes}" onclick="updatePlugin(''{urlToGetNewVersion}'', ''{plugin}'', ''{updateInstructions}'')" /> <input type="button" value="{no}" onclick="$(''#notification'').hide()" />', 'English', 'admin', 'en', NULL),
(776, 'unknown_plugin', 'This plugin is unknown', 'English', 'admin', 'en', NULL),
(777, 'get_new_version', 'Get new version', 'English', 'admin', 'en', NULL),
(778, 'version', 'Version', 'English', 'admin', 'en', NULL),
(779, 'latest_version', 'Latest version', 'English', 'admin', 'en', NULL),
(780, 'upgrade_tip', 'You can use this page also if you want to upgrade existing plugin. Just specify install.xml file and press "{import_and_install}" button.', 'English', 'admin', 'en', NULL),
(781, 'existing_plugins', 'EXISTING PLUGINS', 'English', 'admin', 'en', NULL),
(782, 'no_plugins', 'No plugins.', 'English', 'admin', 'en', NULL),
(783, 'install_upgrade', 'Install or upgrade', 'English', 'admin', 'en', NULL),
(784, 'search_criterias', 'Search Criterias', 'English', 'frontend', 'en', NULL),
(785, 'listings_legend', 'listings waiting for administrator approval', 'English', 'frontend', 'en', NULL),
(786, 'filter_by_type', 'Filter by type', 'English', 'admin', 'en', NULL),
(787, 'check_updates', 'Check for updates', 'English', 'admin', 'en', NULL),
(788, 'multicross', 'Multicross', 'English', 'admin', 'en', NULL),
(789, 'add_favorite', 'Do you want to add the listing to favorites?', 'English', 'frontend', 'en', NULL),
(790, 'remove_favorite', 'Do you want to remove the listing from favorites?', 'English', 'frontend', 'en', NULL),
(791, 'mcross_warning', 'You can not cross one more link', 'English', 'common', 'en', NULL),
(792, 'cross_warning', 'You can not cross listing into main category', 'English', 'common', 'en', NULL),
(793, 'page_title_index', 'Home', 'English', 'page', 'en', NULL),
(794, 'page_title_search', 'Search', 'English', 'page', 'en', NULL),
(795, 'page_title_new_listings', 'New Listings', 'English', 'page', 'en', NULL),
(796, 'page_title_top_listings', 'Top Listings', 'English', 'page', 'en', NULL),
(797, 'page_title_popular_listings', 'Popular Listings', 'English', 'page', 'en', NULL),
(798, 'page_title_random_listings', 'Random Listings', 'English', 'page', 'en', NULL),
(799, 'page_title_suggest_listing', 'Suggest Listing', 'English', 'page', 'en', NULL),
(800, 'page_title_suggest_category', 'Suggest Category', 'English', 'page', 'en', NULL),
(801, 'page_title_edit_account', 'Edit Account', 'English', 'page', 'en', NULL),
(802, 'page_title_favorites_listings', 'Favorites', 'English', 'page', 'en', NULL),
(803, 'page_title_account_listings', 'My Listings', 'English', 'page', 'en', NULL),
(804, 'page_title_about', 'About Us', 'English', 'page', 'en', NULL),
(805, 'page_title_terms', 'Terms of Use', 'English', 'page', 'en', NULL),
(806, 'page_title_help', 'Help', 'English', 'page', 'en', NULL),
(807, 'page_title_policy', 'Privacy Policy', 'English', 'page', 'en', NULL),
(808, 'cannot_move_due_to_crosslink', 'Listing moving rejected because it''s cross link exists on the destination category', 'English', 'admin', 'en', NULL),
(809, 'page_title_advertise', 'Advertise Us', 'English', 'page', 'en', NULL),
(810, 'listings_submission_disabled', 'Listings submission is disabled by adminstrator.', 'English', 'frontend', 'en', NULL),
(811, 'plugin_successfully_updated', 'Plugin successfully updated', 'English', 'admin', 'en', NULL),
(812, 'plugin_upload_following_files', 'This plugin goes with the following files please upload them to the appropriate folders. <ul>{files}</ul>', 'English', 'admin', 'en', NULL),
(813, 'plugin_remove_following_files', 'This plugin goes with the following files please delete them to completely remove the plugin. <ul>{files}</ul>', 'English', 'admin', 'en', NULL),
(814, 'error_email', 'Make sure you entered valid email.', 'English', 'common', 'en', NULL),
(815, 'update_plugin', 'Update plugin', 'English', 'admin', 'en', NULL),
(816, 'thankyou_tail', '<p>Please read our letter with further instructions.</p>', 'English', 'common', 'en', NULL),
(817, 'thankyou_head', '<p>Below is the information you submitted so far. You will be able to extend and edit this information via your member account.</p><p><span style="color: #F00; font-weight: bold;">IMPORTANT!</span> Your account password has been sent to the following email address:</p>', 'English', 'common', 'en', NULL),
(818, 'reg_confirmed', 'Account confirmed. Please sign in.', 'English', 'common', 'en', NULL),
(819, 'reg_confirm_err', 'Error. You key not found.', 'English', 'common', 'en', NULL),
(820, 'reg_confirmation', 'Registration Confirmation', 'English', 'common', 'en', NULL),
(821, 'confirm', 'Confirm', 'English', 'common', 'en', NULL),
(822, 'error_javascript', 'You have to enable JavaScript in your browser.', 'English', 'common', 'en', NULL),
(823, 'redraw_captcha', 'Click on image to redraw.', 'English', 'frontend', 'en', NULL),
(824, 'text_captcha', 'Please input letters you see on the image.', 'English', 'frontend', 'en', NULL),
(825, 'favorites_listings', 'Favorite Listings', 'English', 'frontend', 'en', NULL),
(826, 'image_deleted', 'Image deleted', 'English', 'admin', 'en', NULL),
(827, 'notice_field_type_empty', 'You have to select the field type.', 'English', 'admin', 'en', NULL),
(828, 'page_title', 'Page title', 'English', 'admin', 'en', NULL),
(829, 'error_min_textarea', 'Your {field} length should be more than {num} symbols.', 'English', 'frontend', 'en', NULL),
(830, 'error_max_textarea', 'Your {field} length should be less than {num} symbols.', 'English', 'frontend', 'en', NULL),
(831, 'field_max_length', 'Max length', 'English', 'admin', 'en', NULL),
(832, 'field_min_length', 'Min length', 'English', 'admin', 'en', NULL),
(833, 'characters_count', 'Characters count', 'English', 'frontend', 'en', NULL),
(834, 'no_file', 'There is no file', 'English', 'admin', 'en', NULL),
(835, 'plugin_errors', 'Plugin errors', 'English', 'admin', 'en', NULL),
(836, 'captcha', 'Captcha', 'English', 'frontend', 'en', NULL),
(837, 'fields', 'Fields', 'English', 'frontend', 'en', NULL),
(838, 'reg_confirmed_pending', 'Account confirmed. Your account is still pending approval by the administrator.', 'English', 'frontend', 'en', NULL),
(839, 'rememberme', 'Remember Me', 'English', 'frontend', 'en', NULL),
(840, 'tooltip', 'Tooltip', 'English', 'admin', 'en', NULL),
(841, 'field_min_length', 'Min length', 'English', 'admin', 'en', NULL),
(842, 'field_max_length', 'Max length', 'English', 'admin', 'en', NULL),
(843, 'new_account', 'New account', 'English', 'admin', 'en', NULL),
(844, 'cross', 'Cross', 'English', 'admin', 'en', NULL),
(845, 'listings_crossed', 'Listings successfully crossed', 'English', 'admin', 'en', NULL),
(846, 'listing_crossed', 'Listing successfully crossed', 'English', 'admin', 'en', NULL),
(847, 'wyswyg_editor', 'WYSWYG editor', 'English', 'admin', 'en', NULL),
(848, 'manage_transactions', 'Manage Transactions', 'English', 'admin', 'en', NULL),
(849, 'edit_transaction', 'Edit transaction', 'English', 'admin', 'en', NULL),
(850, 'create_transaction', 'Create transaction', 'English', 'admin', 'en', NULL),
(851, 'inactive', 'Inactive', 'English', 'admin', 'en', NULL),
(852, 'error_username_incorrect', 'Make sure you entered valid username.', 'English', 'frontend', 'en', NULL),
(853, 'unconfirmed', 'Unconfirmed', 'English', 'common', 'en', NULL),
(854, 'thumb_width', 'Thumbnail width', 'English', 'admin', 'en', NULL),
(855, 'thumb_height', 'Thumbnail height', 'English', 'admin', 'en', NULL),
(856, 'resize_mode', 'Resize mode', 'English', 'admin', 'en', NULL),
(857, 'expiration_period', 'Expiration Period', 'English', 'admin', 'en', NULL),
(858, 'expiration_period_incorrect', 'Expiration period incorrect. It should be numeric.', 'English', 'admin', 'en', NULL),
(859, 'are_you_sure_to_delete_this_transaction', 'Are you sure to delete this transaction?', 'English', 'admin', 'en', NULL),
(860, 'category_icons', 'Category Icons', 'English', 'admin', 'en', NULL),
(861, 'icon', 'Icon', 'English', 'admin', 'en', NULL),
(862, 'choose_icon', 'Choose icon', 'English', 'admin', 'en', NULL),
(863, 'remove_icon', 'Remove Icon', 'English', 'admin', 'en', NULL),
(864, 'admin_check_new_password', 'Please check your email for confirmation link.', 'English', 'admin', 'en', NULL),
(865, 'admin_new_password_sent', 'The new password has been sent to your email. Please check your email.', 'English', 'admin', 'en', NULL),
(866, 'tab_content_help', '<h2>Useful Links:</h2>\r\n<a href="http://www.esyndicat.com/docs/glossary.html" target="_blank">Glossary Of Terms</a><br />\r\n<a href="http://www.esyndicat.com/desk/" target="_blank">HelpDesk</a><br />\r\n<a href="http://www.esyndicat.com/docs/" target="_blank">Documentation</a><br /><br />\r\n\r\nIf you have any questions please ask in the support <a href="http://www.esyndicat.com/forum/" target="_blank">forums</a> or <a href="http://www.esyndicat.com/desk/" target="_blank">helpdesk</a>.', 'English', 'admin', 'en', NULL),
(867, 'tab_title_help', 'Help', 'English', 'admin', 'en', NULL),
(868, 'tab_content_search', '<form action="controller.php?file=listings" method="get">\r\n<table>\r\n<tr>\r\n <td width="115">Search Listings: </td>\r\n <td>\r\n <input type="hidden" name="file" value="listings" />\r\n <input type="text" class="common question" size="23" name="quick_search" id="quick_search_listing" />\r\n <input type="submit" class="common" value="Search" />\r\n </td>\r\n</tr>\r\n</table>\r\n</form>\r\n\r\n<form action="controller.php?file=categories" method="get">\r\n<table>\r\n<tr>\r\n <td width="115">Search Categories: </td>\r\n <td>\r\n <input type="hidden" name="file" value="categories" />\r\n <input type="text" class="common question" size="23" name="quick_search" id="quick_search_category" />\r\n <input type="submit" class="common" value="Search" />\r\n </td>\r\n</tr>\r\n</table>\r\n</form>\r\n\r\n<form action="controller.php?file=accounts" method="get">\r\n<table>\r\n<tr>\r\n <td width="115">Search Accounts: </td>\r\n <td>\r\n <input type="hidden" name="file" value="accounts" />\r\n <input type="text" class="common question" size="23" name="quick_search" id="quick_search_account" />\r\n <input type="submit" class="common" value="Search" />\r\n </td>\r\n</tr>\r\n</table>\r\n</form>', 'English', 'admin', 'en', NULL),
(869, 'tab_title_search', 'Search', 'English', 'admin', 'en', NULL),
(870, 'page_key_incorrect', 'Page key is incorrect.', 'English', 'admin', 'en', NULL),
(871, 'page_menu_incorrect', 'Page menus is incorrect.', 'English', 'admin', 'en', NULL),
(872, 'export_tables_incorrect', 'Please select tables for export.', 'English', 'admin', 'en', NULL),
(873, 'incorrect_permissions', 'Please check permissions.', 'English', 'admin', 'en', NULL),
(874, 'incorrect_username', 'Please input correct username.', 'English', 'admin', 'en', NULL),
(875, 'update_msg', 'eSyndiCat Directory {version} is avaiable. <a href="controller.php?file=update">Please update now.</a>', 'English', 'admin', 'en', NULL),
(876, 'update_version', 'Update Version', 'English', 'admin', 'en', NULL),
(877, 'listing_fields', 'Listing Fields', 'English', 'admin', 'en', NULL),
(878, 'search_sections', 'Search Sections', 'English', 'admin', 'en', NULL),
(879, 'custom_url', 'Custom SEO URL', 'English', 'admin', 'en', NULL),
(880, 'custom_url_exist', 'Page with such custom SEO URL already exist.', 'English', 'admin', 'en', NULL),
(881, 'readme', 'Readme', 'English', 'admin', 'en', NULL),
(882, 'reset_all', 'Reset all', 'English', 'admin', 'en', NULL),
(883, 'reset_backup_alert', 'Please create a backup before resetting any table.', 'English', 'admin', 'en', NULL),
(884, 'reset_success', 'Reset has been successful done.', 'English', 'admin', 'en', NULL),
(885, 'reset_choose_table', 'Please choose any table.', 'English', 'admin', 'en', NULL),
(886, 'auto_generate_password', 'Auto generate password', 'English', 'frontend', 'en', NULL),
(887, 'available_plugins', 'Available Plugins', 'English', 'admin', 'en', NULL),
(888, 'installed_plugins', 'Installed Plugins', 'English', 'admin', 'en', NULL),
(889, 'connection_information', 'Connection Information', 'English', 'admin', 'en', NULL),
(890, 'hostname', 'Hostname', 'English', 'admin', 'en', NULL),
(891, 'update', 'Update', 'English', 'admin', 'en', NULL),
(892, 'update_notice', 'Before updating please backup your database and files.', 'English', 'admin', 'en', NULL),
(893, 'no_updates', 'There is no any updates.', 'English', 'admin', 'en', NULL),
(894, 'can_not_get_method', 'Can not get the coping method.', 'English', 'admin', 'en', NULL),
(895, 'script_success_updated', 'Script has been updated successfully. Your current version is {version}.', 'English', 'admin', 'en', NULL),
(896, 'url_package_empty', 'The package URL is empty.', 'English', 'admin', 'en', NULL),
(897, 'get_package_content_error', 'Error occurs while getting package content.', 'English', 'admin', 'en', NULL),
(898, 'unpack_error', 'Error occurs while unpacking package.', 'English', 'admin', 'en', NULL),
(899, 'ftp_details_error', 'Connection details are wrong.', 'English', 'admin', 'en', NULL),
(900, 'ftp_connect_error', 'Can not connect to server.', 'English', 'admin', 'en', NULL),
(901, 'ftp_login_error', 'Can not login as {username}.', 'English', 'admin', 'en', NULL),
(902, 'license_empty ', 'Your License Number is empty. Please input your license number and save configuration <a href="{url}admin/controller.php?file=configuration">here</a>', 'English', 'admin', 'en', NULL),
(903, 'update_overwrite_note', 'Please note. The update script will overwrite your existing files. If you have any modification please create a backup of your files before updating.<br /><br />Do you want to continue?', 'English', 'admin', 'en', NULL),
(904, 'warning', 'WARNING', 'English', 'admin', 'en', NULL),
(905, 'license_not_valid', 'Your license number is not valid. Please check it in the configuration section.', 'English', 'admin', 'en', NULL),
(906, 'domain_not_valid', 'Your domain name is not valid.', 'English', 'admin', 'en', NULL),
(907, 'listings_chart', 'Listings Chart', 'English', 'admin', 'en', NULL),
(908, 'plugin_description', 'Description', 'English', 'admin', 'en', NULL),
(909, 'plugin_changelog', 'Changelog', 'English', 'admin', 'en', NULL),
(910, 'plugin_faq', 'FAQ', 'English', 'admin', 'en', NULL),
(911, 'plugin_installation', 'Installation', 'English', 'admin', 'en', NULL),
(912, 'plugin_notes', 'Notes', 'English', 'admin', 'en', NULL),
(913, 'plugin_screenshots', 'Screenshots', 'English', 'admin', 'en', NULL),
(914, 'plugin_documentation', 'Plugin Documentation', 'English', 'admin', 'en', NULL),
(915, 'do_not_display_neighbours', 'Do not display neighbours', 'English', 'admin', 'en', NULL),
(916, 'choose_importer', 'Choose Importer', 'English', 'admin', 'en', NULL),
(917, 'database_name', 'Database Name', 'English', 'admin', 'en', NULL),
(918, 'database_username', 'Database Username', 'English', 'admin', 'en', NULL),
(919, 'database_password', 'Database Password', 'English', 'admin', 'en', NULL),
(920, 'find_database', 'Find Database', 'English', 'admin', 'en', NULL),
(921, 'database_prefix', 'Database Prefix', 'English', 'admin', 'en', NULL),
(922, 'select', 'Select', 'English', 'admin', 'en', NULL),
(923, 'database_host', 'Database Host', 'English', 'admin', 'en', NULL),
(924, 'database_connection_error', 'Could not connect to database.', 'English', 'admin', 'en', NULL),
(925, 'database_selection_error', 'An error occured while selecting database.', 'English', 'admin', 'en', NULL),
(926, 'manage_importer', 'Manage Imports', 'English', 'admin', 'en', NULL),
(927, 'convert_database_complete', 'Convert database successfully complete.', 'English', 'admin', 'en', NULL),
(928, 'no_importers', 'There is no any importers.', 'English', 'admin', 'en', NULL),
(929, 'import_report', 'Import Report', 'English', 'admin', 'en', NULL),
(930, 'assign_account', 'Assign to account', 'English', 'admin', 'en', NULL),
(931, 'existing_account', 'Existing account', 'English', 'admin', 'en', NULL),
(932, 'dont_assign', 'Don not assign', 'English', 'admin', 'en', NULL),
(933, 'xml_parse_error', 'Error occurs while parse XML file', 'English', 'admin', 'en', NULL),
(934, 'xml_file_empty', 'XML file empty.', 'English', 'admin', 'en', NULL),
(935, 'esyndicat_new_plugins', 'eSyndiCat New Plugins', 'English', 'admin', 'en', NULL),
(936, 'quick_search_account_qtip', 'Please input account ID, username or email', 'English', 'admin', 'en', NULL),
(937, 'id', 'ID', 'English', 'admin', 'en', NULL),
(938, 'items_per_page', 'Items per page', 'English', 'admin', 'en', NULL),
(939, 'do', 'Do!', 'English', 'admin', 'en', NULL),
(940, 'error_saving_changes', 'Error saving changes...', 'English', 'admin', 'en', NULL),
(941, 'filter', 'Filter', 'English', 'admin', 'en', NULL),
(942, 'action', 'Action', 'English', 'admin', 'en', NULL),
(943, 'action_confirm', 'Do you really want to {action} [ {listings} ] to {category} category?', 'English', 'admin', 'en', NULL),
(944, 'view_logo', 'View Logo', 'English', 'admin', 'en', NULL),
(945, 'site_logo_image_error', 'Error occurs while uploading site logo image.', 'English', 'admin', 'en', NULL),
(946, 'wrong_image_type', 'Only following image types are allowed (<i>{types}</i>).', 'English', 'admin', 'en', NULL),
(947, 'params_wrong', 'Params are wrong.', 'English', 'admin', 'en', NULL),
(948, 'uploading_site_logo', 'Uploading Site Logo...', 'English', 'admin', 'en', NULL),
(949, 'image_uploaded', '"Image {name} is successfully uploaded.', 'English', 'admin', 'en', NULL),
(950, 'upload_site_logo', 'Upload Site Logo', 'English', 'admin', 'en', NULL),
(951, 'upload', 'Upload', 'English', 'admin', 'en', NULL),
(952, 'are_you_sure_to_delete_selected_icons', 'Do you really want to remove selected icons?', 'English', 'admin', 'en', NULL),
(953, 'select_icon', 'Select a icon', 'English', 'admin', 'en', NULL),
(954, 'uploading_icon', 'Uploading Icon', 'English', 'admin', 'en', NULL),
(955, 'upload_new_category_icon', 'Upload New Category Icon', 'English', 'admin', 'en', NULL),
(956, 'htaccess_file', '.htaccess file', 'English', 'admin', 'en', NULL),
(957, 'copy_to_clipboard', 'Copy to clipboard', 'English', 'admin', 'en', NULL),
(958, 'select_logo', 'Select Site Logo', 'English', 'admin', 'en', NULL),
(959, 'logo', 'Logo', 'English', 'admin', 'en', NULL),
(960, 'add_new_phrase', 'Add new phrase?', 'English', 'admin', 'en', NULL),
(961, 'add_one_more_phrase', 'Would you like to add one more phrase?', 'English', 'admin', 'en', NULL),
(962, 'searching', 'Searching...', 'English', 'admin', 'en', NULL),
(963, 'type_username_email', '-- type your username or email --', 'English', 'admin', 'en', NULL),
(964, 'last_updated', 'Last Updated', 'English', 'admin', 'en', NULL),
(965, 'error_while_doc_tabs', 'Error while getting doc tabs.', 'English', 'admin', 'en', NULL),
(966, 'type_account_username', 'Type account username', 'English', 'admin', 'en', NULL),
(967, 'or', 'OR', 'English', 'common', 'en', NULL),
(968, 'and', 'AND', 'English', 'common', 'en', NULL),
(969, 'type_listing_title', 'Type the listing title...', 'English', 'admin', 'en', NULL),
(970, 'order_number', 'Order Number', 'English', 'admin', 'en', NULL),
(971, 'condition', 'Condition', 'English', 'admin', 'en', NULL),
(972, 'add_transaction', 'Add transaction', 'English', 'admin', 'en', NULL),
(973, 'add_new_transaction', 'Do you want to add new transaction?', 'English', 'admin', 'en', NULL),
(974, 'and_then', 'and then', 'English', 'admin', 'en', NULL),
(975, 'go_to_list', 'Go to list', 'English', 'admin', 'en', NULL),
(976, 'add_another_one', 'Add another one', 'English', 'admin', 'en', NULL),
(977, 'go_to_browse', 'Go to browse', 'English', 'admin', 'en', NULL),
(978, 'go_to_browse_new_category', 'Go to browse new category', 'English', 'admin', 'en', NULL),
(979, 'page_content_about', 'About Us page content', 'English', 'page', 'en', NULL),
(980, 'page_content_policy', 'Privacy Policy page content', 'English', 'page', 'en', NULL),
(981, 'page_content_terms', 'Terms Of Use page content', 'English', 'page', 'en', NULL),
(982, 'page_content_help', 'Help page content', 'English', 'page', 'en', NULL),
(983, 'page_content_advertise', 'Advertise Us page content', 'English', 'page', 'en', NULL),
(984, 'file_format', 'File Format', 'English', 'admin', 'en', NULL),
(985, 'csv_format', 'CSV format', 'English', 'admin', 'en', NULL),
(986, 'sql_format', 'SQL format', 'English', 'admin', 'en', NULL),
(987, 'newly_added_listings', 'Newly added listings', 'English', 'frontend', 'en', NULL),
(988, 'most_popular_listings', 'Most popular listings', 'English', 'frontend', 'en', NULL),
(989, 'rss_feed', 'RSS feed', 'English', 'frontend', 'en', NULL),
(990, 'quick_search_listing_qtip', 'Please input listing URL, title, description, ID or account username', 'English', 'admin', 'en', NULL),
(991, 'quick_search_category_qtip', 'Please input category title', 'English', 'admin', 'en', NULL),
(992, 'installer_not_removed', 'Installer has not been removed. Please delete install/index.php file immediately!', 'English', 'admin', 'en', NULL),
(993, 'config_writable', 'The includes/config.inc.php still has writable privileges. Please change config.inc.php permissions to non-writable.', 'English', 'admin', 'en', NULL),
(994, 'esyndicat_action_add_favorite', 'Add Favorite', 'English', 'frontend', 'en', NULL),
(995, 'esyndicat_action_remove_favorite', 'Remove Favorite', 'English', 'frontend', 'en', NULL),
(996, 'esyndicat_action_report_listing', 'Report Listing', 'English', 'frontend', 'en', NULL),
(997, 'esyndicat_action_visit_website', 'Visit Website', 'English', 'frontend', 'en', NULL),
(998, 'doc_plugin_not_available', 'Documentation of plugin is not available.', 'English', 'admin', 'en', NULL),
(999, 'plain_text_templates', 'Plain Text Templates', 'English', 'admin', 'en', NULL),
(1000, 'html_templates', 'HTML templates', 'English', 'admin', 'en', NULL),
(1001, 'nothing', 'Nothing', 'English', 'admin', 'en', NULL),
(1002, 'no_captcha_preview', 'No captcha preview', 'English', 'admin', 'en', NULL),
(1003, 'quick_jump_to', 'Quick Jump To', 'English', 'admin', 'en', NULL),
(1004, 'howdy', 'Howdy', 'English', 'admin', 'en', NULL),
(1005, 'iso_code', 'ISO - code', 'English', 'admin', 'en', NULL),
(1006, 'digit_only', 'digit only(1-255) default is 100', 'English', 'admin', 'en', NULL),
(1007, 'proportional', 'PROPORTIONAL', 'English', 'admin', 'en', NULL),
(1008, 'stretch', 'STRETCH', 'English', 'admin', 'en', NULL),
(1009, 'fit', 'FIT', 'English', 'admin', 'en', NULL),
(1010, 'proportional_tip', 'The mod will attempt to fit the image inside the "frame" create by the width and height arguments.', 'English', 'admin', 'en', NULL),
(1011, 'stretch_tip', 'The mod will stretch the image if necessary to fit into that "frame".', 'English', 'admin', 'en', NULL),
(1012, 'fit_tip', 'The will attempt to resize the image proportionally only if it does not fit inside the "frame" set by the provided width and height: if it does fit, the image will not be resized at all.', 'English', 'admin', 'en', NULL),
(1013, 'show_in_search_as', 'Show in search page as', 'English', 'admin', 'en', NULL),
(1014, 'checkboxes', 'Checkboxes Set', 'English', 'admin', 'en', NULL),
(1015, 'radios', 'Radios Set', 'English', 'admin', 'en', NULL),
(1016, 'dropdown', 'Dropdown List', 'English', 'admin', 'en', NULL),
(1017, 'title_for_any', 'Title for "any" meta option', 'English', 'admin', 'en', NULL),
(1018, 'mark_after_submit', 'Mark listing after submit as', 'English', 'admin', 'en', NULL),
(1019, 'send_expiration_email', 'Send email in [...] day(s) before expiration', 'English', 'admin', 'en', NULL),
(1020, 'assign_fields', 'Assign fields', 'English', 'admin', 'en', NULL),
(1021, 'xml_syndication', 'XML syndication', 'English', 'frontend', 'en', NULL),
(1022, 'enter_confirmation', 'Please enter confirmation code below', 'English', 'frontend', 'en', NULL),
(1023, 'unknown', 'Unknown', 'English', 'frontend', 'en', NULL),
(1024, 'upload_writable_permission', 'Please set writable permissions for uploads/ directory. chmod 777 uploads/', 'English', 'admin', 'en', NULL),
(1025, 'confirm_not_valid', 'Confirmations data is not valid. Please recheck the confirm link.', 'English', 'frontend', 'en', NULL),
(1026, 'keywords', 'Keywords', 'English', 'admin', 'en', NULL),
(1027, 'check_listing_fields', 'Please recheck your information.', 'English', 'frontend', 'en', NULL),
(1028, 'are_you_sure_to_delete_this_deep_link', 'Are you sure you want to delete this deep link?', 'English', 'admin', 'en', NULL),
(1029, 'collapsible', 'Collapsible', 'English', 'admin', 'en', NULL),
(1030, 'block_options', 'Block Options', 'English', 'admin', 'en', NULL),
(1031, 'block_contents', 'Block Contents', 'English', 'admin', 'en', NULL),
(1032, 'error_contents', 'Contents field is a required.', 'English', 'common', 'en', NULL),
(1033, 'error_title', 'Title field is required.', 'English', 'admin', 'en', NULL),
(1034, 'block_languages_empty', 'You need to choose language.', 'English', 'admin', 'en', NULL),
(1035, 'error_lang_title', 'Title {lang} field is a required.', 'English', 'admin', 'en', NULL),
(1036, 'error_lang_contents', 'Contents {lang} field is a required.', 'English', 'admin', 'en', NULL),
(1037, 'new', 'New', 'English', 'common', 'en', NULL),
(1038, 'hide_category', 'Hide category', 'English', 'admin', 'en', NULL),
(1039, 'go_to_config', 'Go to configuration page of {plugin}', 'English', 'admin', 'en', NULL),
(1040, 'go_to_manage', 'Go to manage page of {plugin}', 'English', 'admin', 'en', NULL),
(1041, 'upgrade_plugin', 'Run upgrade of the {plugin}', 'English', 'admin', 'en', NULL),
(1042, 'manage_templates', 'Manage Templates', 'English', 'admin', 'en', NULL),
(1043, 'screenshot', 'Screenshot', 'English', 'admin', 'en', NULL),
(1044, 'operation', 'Operation', 'English', 'admin', 'en', NULL),
(1045, 'details', 'Details', 'English', 'admin', 'en', NULL),
(1046, 'contributor', 'Contributor', 'English', 'admin', 'en', NULL),
(1047, 'release_date', 'Release Date', 'English', 'admin', 'en', NULL),
(1048, 'esyndicat_version', 'eSyndiCat version', 'English', 'admin', 'en', NULL),
(1049, 'template_empty', 'Template doesn''t exists.', 'English', 'admin', 'en', NULL),
(1050, 'template_folder_error', 'Template folder doesn''t exist.', 'English', 'admin', 'en', NULL),
(1051, 'template_xmlfile_error', 'The XML file of {template} doesn''t exist.', 'English', 'admin', 'en', NULL),
(1052, 'template_installed', 'The {template} template successfully installed.', 'English', 'admin', 'en', NULL),
(1053, 'date_registration ', 'Date Registration', 'English', 'frontend', 'en', NULL),
(1054, 'view_account_details', 'View account details', 'English', 'frontend', 'en', NULL),
(1055, 'no_accounts', 'There is no any accounts.', 'English', 'frontend', 'en', NULL),
(1056, 'no_account_listings', 'Account does not have any listings yet.', 'English', 'frontend', 'en', NULL),
(1057, 'page_title_accounts', 'Accounts', 'English', 'page', 'en', NULL),
(1058, 'rebuild_htaccess', 'Rebuild htaccess', 'English', 'admin', 'en', NULL),
(1059, 'notif_htaccess_permission', 'Please set the writable permission to rebuild the .htaccess file.', 'English', 'admin', 'en', NULL),
(1060, 'notification', 'Notification', 'English', 'admin', 'en', NULL),
(1061, 'notif_htaccess_rebuilt', 'The .htaccess file has been rebuilt.', 'English', 'admin', 'en', NULL),
(1062, 'submitted', 'Submitted', 'English', 'admin', 'en', NULL),
(1063, 'preview', 'Preview', 'English', 'admin', 'en', NULL),
(1064, 'page_title_account_login', 'Account Login', 'English', 'page', 'en', NULL),
(1065, 'page_title_account_register', 'Account Register', 'English', 'page', 'en', NULL),
(1066, 'page_title_edit_listing', 'Edit Listing', 'English', 'page', 'en', NULL),
(1067, 'page_title_account_logout', 'Account Logout', 'English', 'page', 'en', NULL),
(1068, 'page_title_thank', 'Thank', 'English', 'page', 'en', NULL),
(1069, 'page_title_account_password_forgot', 'Account Password Forgot', 'English', 'page', 'en', NULL),
(1070, 'page_title_error', 'Error', 'English', 'page', 'en', NULL),
(1071, 'page_title_accounts', 'Accounts', 'English', 'page', 'en', NULL),
(1072, 'page_title_view_listing', 'View Listing', 'English', 'page', 'en', NULL),
(1073, 'page_title_report_broken_listing', 'Report Broken Listing', 'English', 'page', 'en', NULL),
(1074, 'miscellaneous', 'Miscellaneous', 'English', 'admin', 'en', NULL),
(1075, 'category_url_will_be', 'Category URL will be', 'English', 'admin', 'en', NULL),
(1076, 'page_url_will_be', 'Page URL will be', 'English', 'admin', 'en', NULL),
(1077, 'max_num_images', 'Max number of images', 'English', 'admin', 'en', NULL),
(1078, 'no_more_files', 'You can not upload more files. Limit exceeded.', 'English', 'common', 'en', NULL),
(1079, 'category_locked_subcategories_alert', 'This category will be locked. Do you want to have subcategories locked also?', 'English', 'admin', 'en', NULL),
(1080, 'category_unlocked_subcategories_alert', 'This category will be unlocked. Do you want to have subcategories unlocked also?', 'English', 'admin', 'en', NULL),
(1081, 'hide', 'Hide', 'English', 'admin', 'en', NULL),
(1082, 'logo_image_not_found', 'Logo image cannot be found. Please reupload logo image.', 'English', 'admin', 'en', NULL),
(1083, 'page_title_index_browse', 'Browse Categories', 'English', 'page', 'en', NULL),
(1084, 'youre_in_preview_mode', 'You are in template preview mode.', 'English', 'frontend', 'en', NULL),
(1085, 'add_another_one_to_same', 'Add another in the same category', 'English', 'admin', 'en', NULL),
(1086, 'listing_expired', 'Expired', 'English', 'admin', 'en', NULL),
(1087, 'block_type_tip_plain', 'Plain type is used when you wish to display simple information. It will be displayed as is plus escaping HTML tags.', 'English', 'admin', 'en', NULL),
(1088, 'block_type_tip_html', 'HTML type is used for formatted HTML display. You can use WYSIWYG editor for your block content. This block can be also used for JavaScript code, but you <span style="color: red">need to paste it in SOURCE mode</span>.', 'English', 'admin', 'en', NULL),
(1089, 'block_type_tip_smarty', 'Smarty type block is used for smarty code. You can get more information about Smarty template engine here: <a href="http://www.smarty.net" target="_blank">http://www.smarty.net</a>', 'English', 'admin', 'en', NULL),
(1090, 'block_type_tip_php', 'PHP is used to have php code in your block content.', 'English', 'admin', 'en', NULL),
(1091, 'accounts', 'Enables accounts for your eSyndiCat Directory', 'English', 'tooltip', 'en', NULL),
(1092, 'accounts_autoapproval', 'Sends out confirmation emails and automatically approves accounts.', 'English', 'tooltip', 'en', NULL),
(1093, 'accounts_registered', 'Disabling this, reduces spam posts.', 'English', 'tooltip', 'en', NULL),
(1094, 'display_new_plugins', 'Notifies when a new plugin is available.', 'English', 'tooltip', 'en', NULL),
(1095, 'captcha', 'Activates Captcha', 'English', 'tooltip', 'en', NULL),
(1096, 'captcha_name', 'kcaptcha is default', 'English', 'tooltip', 'en', NULL),
(1097, 'captcha_preview', 'Displays what the image will look like.', 'English', 'tooltip', 'en', NULL),
(1098, 'captcha_case_sensitive', 'Default is enable; Exact entry is needed.', 'English', 'tooltip', 'en', NULL),
(1099, 'captcha_num_chars', 'Recommended to use 4 or 5 letters.', 'English', 'tooltip', 'en', NULL),
(1100, 'suggest_category', 'This displays the Submit Category link', 'English', 'tooltip', 'en', NULL),
(1101, 'use_html_path', 'This places all of the categories as /"yourcategory".html', 'English', 'tooltip', 'en', NULL),
(1102, 'related', 'Displays the Related Categories links at the bottom of the category used', 'English', 'tooltip', 'en', NULL),
(1103, 'neighbour', 'Displays Neighbor categories within the category chosen', 'English', 'tooltip', 'en', NULL),
(1104, 'show_children_listings', 'Shows listings in the categories within the main category', 'English', 'tooltip', 'en', NULL),
(1105, 'categories_order', 'Preferred sorting can be defined by Title or Order', 'English', 'tooltip', 'en', NULL),
(1106, 'categories_tree_type', 'Define as a Directory Tree like in 2.2 or Dropdown selection', 'English', 'tooltip', 'en', NULL),
(1107, 'num_categories_cols', 'Displays the number of columns for your categories', 'English', 'tooltip', 'en', NULL),
(1108, 'num_listings_display', 'Shows a listing display showing category and listing numbers', 'English', 'tooltip', 'en', NULL),
(1109, 'subcats_display', 'Displays the subcategories listings under the main category', 'English', 'tooltip', 'en', NULL),
(1110, 'cron_recip', 'Checks reciprocal status and disables the listing.', 'English', 'tooltip', 'en', NULL),
(1111, 'cron_broken', 'This updates listing status.', 'English', 'tooltip', 'en', NULL),
(1112, 'cron_pagerank', 'This will update the pagerank of sites.', 'English', 'tooltip', 'en', NULL),
(1113, 'cron_num_listings', 'Default is 10; Perfect for shared hosting accounts. VPS 25-35, Dedicated 100.', 'English', 'tooltip', 'en', NULL),
(1114, 'cron_check_interval', '1 is default; Recommended for large directories.', 'English', 'tooltip', 'en', NULL),
(1115, 'cron_report_job', 'Sends an email after cronjob is complete.', 'English', 'tooltip', 'en', NULL),
(1116, 'cron_report_job_extra', 'Includes the what listings were updated in the email.', 'English', 'tooltip', 'en', NULL),
(1117, 'cron_report_cycle', 'After all listings are checked, An email will notify you.', 'English', 'tooltip', 'en', NULL),
(1118, 'cron_report_cycle_extra', 'Listing will include all listings that were completed.', 'English', 'tooltip', 'en', NULL),
(1119, 'cron_backup', 'Enables a backup of your database.', 'English', 'tooltip', 'en', NULL),
(1120, 'cron_backup_archive', 'Enabled will backup the database into a zip file to conserve space.', 'English', 'tooltip', 'en', NULL),
(1121, 'cron_backup_interval', 'Default is 30 days, If your site is active, it is recommended to reduce the time.', 'English', 'tooltip', 'en', NULL),
(1122, 'currency_symbol', 'Default is $.', 'English', 'tooltip', 'en', NULL),
(1123, 'site', 'This will be your site''s name.', 'English', 'tooltip', 'en', NULL),
(1124, 'site_logo', 'Upload your logo here, keep the image size.', 'English', 'tooltip', 'en', NULL),
(1125, 'backup', 'Default is backup/ recommended that you do not alter.', 'English', 'tooltip', 'en', NULL),
(1126, 'admin', 'Default is admin/ recommended that you do not alter.', 'English', 'tooltip', 'en', NULL);
INSERT INTO `[[dbprefix]]language` VALUES
(1127, 'site_email', 'Email address you wish to get account changes and alerts sent to.', 'English', 'tooltip', 'en', NULL),
(1128, 'bugs_email', 'Email address you wish to be alerted if there is a problem.', 'English', 'tooltip', 'en', NULL),
(1129, 'lang', 'Select your preferred language of your site.', 'English', 'tooltip', 'en', NULL),
(1130, 'charset', 'Default is UTF-8.', 'English', 'tooltip', 'en', NULL),
(1131, 'date_format', 'Select your preferred date format %e is timezone, %Y is 4-digit year.', 'English', 'tooltip', 'en', NULL),
(1132, 'suffix', 'This is the 2nd description for your Title bar.', 'English', 'tooltip', 'en', NULL),
(1133, 'title_breadcrumb', 'Produces breadcrumbs in Title.', 'English', 'tooltip', 'en', NULL),
(1134, 'language_switch', 'Allows users on the front of your site changed language.', 'English', 'tooltip', 'en', NULL),
(1135, 'mod_rewrite', 'Produces SEO friendly URLs.', 'English', 'tooltip', 'en', NULL),
(1136, 'caching', 'If you are using slow shared hosting, this will cache your pages for faster loading.', 'English', 'tooltip', 'en', NULL),
(1137, 'display_frontend', 'Enabling the Frontend displays your site as intended.', 'English', 'tooltip', 'en', NULL),
(1138, 'underconstruction', 'If Display Frontend is disabled. The below message will be shown.', 'English', 'tooltip', 'en', NULL),
(1139, 'listing_check', 'Enabling this will check from broken listings.', 'English', 'tooltip', 'en', NULL),
(1140, 'reciprocal_check', 'Enable this for link checking; Cron configuration is required.', 'English', 'tooltip', 'en', NULL),
(1141, 'reciprocal_required_only_for_free', 'Enable this for gaining a link exchange function.', 'English', 'tooltip', 'en', NULL),
(1142, 'reciprocal_domain', 'Makes reciprocal domain name sensitive.', 'English', 'tooltip', 'en', NULL),
(1143, 'reciprocal_text', 'This is your preferred domain you want to promote.', 'English', 'tooltip', 'en', NULL),
(1144, 'recip_featured', 'Allows reciprocal listings to be featured.', 'English', 'tooltip', 'en', NULL),
(1145, 'reciprocal_label', 'This text can be edited to fit your needs.', 'English', 'tooltip', 'en', NULL),
(1146, 'reciprocal_code', 'This code is for the client to paste within his site for Reciprocal listing checks.', 'English', 'tooltip', 'en', NULL),
(1147, 'duplicate_checking', 'Enables Duplicate listing Check; Frequency is determined in Cron Configuration.', 'English', 'tooltip', 'en', NULL),
(1148, 'duplicate_type', 'Checks links based on the dropdown choice.', 'English', 'tooltip', 'en', NULL),
(1149, 'duplicate_visitors', 'Disables Link Checking', 'English', 'tooltip', 'en', NULL),
(1150, 'allow_listings_submission', 'Enables the Submit Listings button.', 'English', 'tooltip', 'en', NULL),
(1151, 'auto_approval', 'Automatic Submission approval; Note: Do not enable if you want to manually approve listings.', 'English', 'tooltip', 'en', NULL),
(1152, 'new_window', 'Opens a new window when directed to the listing.', 'English', 'tooltip', 'en', NULL),
(1153, 'forward_to_listing_details', 'Opens the on-site listing instead of being forwards to the actual site.', 'English', 'tooltip', 'en', NULL),
(1154, 'pagerank', 'Shows the pagerank on both the site details and truncated listings.', 'English', 'tooltip', 'en', NULL),
(1155, 'thumbshot', 'Displays a small screen capture of the listings website.', 'English', 'tooltip', 'en', NULL),
(1156, 'broken_listings_report', 'Enabling this will check the broken listings and send an email report.\r\n', 'English', 'tooltip', 'en', NULL),
(1157, 'description_num_chars', 'Limits description on Browse Categories, Popular Listings, and few other listings pages.', 'English', 'tooltip', 'en', NULL),
(1158, 'description_min_max_length', 'Min & max length values for the listing description field.', 'English', 'tooltip', 'en', NULL),
(1159, 'num_index_listings', 'Selecting how many listings you want displayed per page. Default is 10.', 'English', 'tooltip', 'en', NULL),
(1160, 'num_get_listings', 'Select the number of listings you want displayed on the Top, New and Popular listings pages.', 'English', 'tooltip', 'en', NULL),
(1161, 'num_featured_display', 'Displays the selected number of listings you want in the Featured box.', 'English', 'tooltip', 'en', NULL),
(1162, 'num_partner_display', 'Displays the selected number of listings you want in the Partners box.', 'English', 'tooltip', 'en', NULL),
(1163, 'visitor_sorting', 'Enabling this will allow users to view listings by alpha, rank, clicks or date.', 'English', 'tooltip', 'en', NULL),
(1164, 'listings_sorting', 'This will be the default setting for users to start viewing the listings.', 'English', 'tooltip', 'en', NULL),
(1165, 'listings_sorting_type', 'Ascending or Descending settings will determine by preference.', 'English', 'tooltip', 'en', NULL),
(1166, 'expiration_period', 'If a listing is not paid or subscription expires, the number of days before action below is taken.', 'English', 'tooltip', 'en', NULL),
(1167, 'expiration_action', 'When the days allowed above expire, this setting will determine what action is to be taken. Default is Nothing.', 'English', 'tooltip', 'en', NULL),
(1168, 'mail_function', 'The Mail Method to send emails.', 'English', 'tooltip', 'en', NULL),
(1169, 'mimetype', 'Determines whether you want to send text or html emails (templates located in the Email Template tab to the left).', 'English', 'tooltip', 'en', NULL),
(1170, 'sendmail_path', 'Default is /usr/bin/sendmail', 'English', 'tooltip', 'en', NULL),
(1171, 'smtp_server', 'That would be Ex. (smtp.yourdomain.com)', 'English', 'tooltip', 'en', NULL),
(1172, 'smtp_user', 'The username is specified with your email/hosting provider.', 'English', 'tooltip', 'en', NULL),
(1173, 'smtp_password', 'Password for the username above.', 'English', 'tooltip', 'en', NULL),
(1174, 'resend_confirmation_email', 'Resend confirmation email', 'English', 'admin', 'en', NULL),
(1175, 'confirmation_resent', 'Confirmation email resent.', 'English', 'admin', 'en', NULL),
(1176, 'categories_display_type', 'Defines categories display type.<br />\r\nExample:<br />\r\n<pre>Horizontal:\r\na b c d\r\ne f g h\r\nVertical:\r\na c e g \r\nb d f h</pre>', 'English', 'tooltip', 'en', NULL),
(1177, 'item', 'Item', 'English', 'admin', 'en', NULL),
(1178, 'categories_icon_notif', 'Create and upload images to "uploads/category-icons" folder to be able choose your own category icons.', 'English', 'admin', 'en', NULL),
(1179, 'remove_reason', 'Remove reason', 'English', 'admin', 'en', NULL),
(1180, 'view_image', 'View Image', 'English', 'admin', 'en', NULL),
(1181, 'image_not_found', 'Image not found', 'English', 'admin', 'en', NULL),
(1182, 'uploading_image', 'Uploading Image', 'English', 'admin', 'en', NULL),
(1183, 'select_image', 'Select Image', 'English', 'admin', 'en', NULL),
(1184, 'image', 'Image', 'English', 'admin', 'en', NULL),
(1185, 'upload_image_error', 'Upload Image Error', 'English', 'admin', 'en', NULL),
(1186, 'collapsed', 'Collapsed', 'English', 'admin', 'en', NULL),
(1187, 'cannot_create_folder', 'Can''t create folders for sitemap files.', 'English', 'admin', 'en', NULL),
(1188, 'not_writable_folder', 'Sitemap file''s folder non writable.', 'English', 'admin', 'en', NULL),
(1189, 'create_gy_sitemap', 'Create Google Yahoo sitemap.', 'English', 'admin', 'en', NULL),
(1190, 'total_items', 'total items', 'English', 'admin', 'en', NULL),
(1191, 'start_from', 'start from', 'English', 'admin', 'en', NULL),
(1192, 'processing', 'Processing.', 'English', 'admin', 'en', NULL),
(1193, 'finished', 'Finished.', 'English', 'admin', 'en', NULL),
(1194, 'progress', 'Progress.', 'English', 'admin', 'en', NULL),
(1195, 'start', 'Start.', 'English', 'admin', 'en', NULL),
(1196, 'instead_thumbnail', 'Instead of thumbnail', 'English', 'admin', 'en', NULL),
(1197, 'twitter_news', 'Twitter News', 'English', 'admin', 'en', NULL),
(1198, 'unbroken', 'Unbroken', 'English', 'admin', 'en', NULL),
(1199, 'more', 'more...', 'English', 'frontend', 'en', NULL),
(1200, 'categories_found', 'Categories found: ', 'English', 'frontend', 'en', NULL),
(1201, 'username_banned', 'Your account has been banned by administrator.', 'English', 'frontend', 'en', NULL),
(1202, 'last_visited', 'Last Visited', 'English', 'common', 'en', NULL),
(1203, 'item_selected', 'item selected', 'English', 'admin', 'en', NULL),
(1204, 'items_selected', 'items selected', 'English', 'admin', 'en', NULL),
(1205, 'set_as_default', 'Set As Default', 'English', 'admin', 'en', NULL),
(1206, 'are_you_sure_to_set_as_default_selected_icons', 'Are you sure to set selected image as default icon for all categories?', 'English', 'admin', 'en', NULL),
(1207, 'image_set_as_default_icon_categories', 'image set as default icon for categories.', 'English', 'admin', 'en', NULL),
(1208, 'instructions_restore_password_sent', 'Email with instructions to restore password has been sent.', 'English', 'frontend', 'en', NULL),
(1209, 'instructions_change_email_sent', 'Email with instructions to change email has been sent.', 'English', 'frontend', 'en', NULL),
(1210, 'change_email', 'Change Email', 'English', 'frontend', 'en', NULL),
(1211, 'confirm_email', 'Confirm Email', 'English', 'frontend', 'en', NULL),
(1212, 'account_successful_change_email', 'You have successfully change your account email.', 'English', 'frontend', 'en', NULL),
(1213, 'hook_editor', 'Hook Editor', 'English', 'admin', 'en', NULL),
(1214, 'field_meta_description', 'Meta Description', 'English', 'common', 'en', NULL),
(1215, 'field_meta_keywords', 'Meta Keywords', 'English', 'common', 'en', NULL),
(1216, 'hook_editor_alert', 'Please be very careful when editing hooks. It can be easily broken plugins functionality.', 'English', 'admin', 'en', NULL),
(1217, 'never', 'never', 'English', 'admin', 'en', NULL),
(1218, 'error_deep_link_not_similar', 'The domain of deep link ( {url} ) is not similar as listing URL.', 'English', 'frontend', 'en', NULL),
(1219, 'image_removed', 'Image has been removed.', 'English', 'admin', 'en', NULL),
(1220, 'hide_category_option', 'This option allows to hide category in the list though it will be still accessible via direct link.', 'English', 'admin', 'en', NULL),
(1221, 'submit_feedback', 'Submit Feedback to eSyndiCat Team', 'English', 'admin', 'en', NULL),
(1222, 'feedback_terms', 'If you have any ideas how to improve our software, found a bug or want to request custom modification you are welcome to use this feedback form. We will log all your requests in our database. We will prepare terms of contacting and violators will be banned.', 'English', 'admin', 'en', NULL),
(1223, 'bug_report', 'Bug Report', 'English', 'admin', 'en', NULL),
(1224, 'feature_request', 'New Feature Request', 'English', 'admin', 'en', NULL),
(1225, 'custom_quote', 'Custom Modification', 'English', 'admin', 'en', NULL),
(1226, 'message_body', 'Message Body', 'English', 'admin', 'en', NULL),
(1227, 'send_confirm', 'Are you sure you wish to send this feedback to eSyndiCat Team?', 'English', 'admin', 'en', NULL),
(1228, 'request_submitted', 'Thanks. Your request has been submitted.', 'English', 'admin', 'en', NULL),
(1229, 'check_listing', 'check listing...', 'English', 'common', 'en', NULL),
(1230, 'comments', 'Comments', 'English', 'common', 'en', NULL),
(1231, 'comment_author', 'Comment Author', 'English', 'common', 'en', NULL),
(1232, 'author_email', 'Author Email', 'English', 'common', 'en', NULL),
(1233, 'author_url', 'Author URL', 'English', 'common', 'en', NULL),
(1234, 'leave_comment', 'Leave Comment', 'English', 'common', 'en', NULL),
(1235, 'all_comments', 'All Comments', 'English', 'admin', 'en', NULL),
(1236, 'comment', 'Comment', 'English', 'common', 'en', NULL),
(1237, 'no_comments', 'No Comments.', 'English', 'common', 'en', NULL),
(1238, 'comment_added', 'Comment added.', 'English', 'common', 'en', NULL),
(1239, 'comment_waits_approve', 'Your comment should be approved by administrator.', 'English', 'common', 'en', NULL),
(1240, 'manage_comments', 'Manage Comments', 'English', 'admin', 'en', NULL),
(1241, 'are_you_sure_to_delete_selected_comments', 'Are you sure you want to delete selected comments?', 'English', 'admin', 'en', NULL),
(1242, 'are_you_sure_to_delete_this_comment', 'Are you sure you want to delete this comment?', 'English', 'admin', 'en', NULL),
(1243, 'edit_comment', 'Edit comment', 'English', 'admin', 'en', NULL),
(1244, 'error_comment', 'Make sure you entered valid comment.', 'English', 'frontend', 'en', NULL),
(1245, 'error_comment_author', 'Make sure you entered valid comment author.', 'English', 'frontend', 'en', NULL),
(1246, 'error_comment_email', 'Make sure you entered valid author email.', 'English', 'frontend', 'en', NULL),
(1247, 'error_max_comment', 'Your comment length should be less than {maxLength} symbols.', 'English', 'frontend', 'en', NULL),
(1248, 'error_min_comment', 'Your comment length should be more than {minLength} symbols.', 'English', 'frontend', 'en', NULL),
(1249, 'error_comment_logged', 'You should be logged in to comment listings.', 'English', 'frontend', 'en', NULL),
(1250, 'listing_comments_submission_disabled', 'Listing comments submission is disabled by adminstrator.', 'English', 'frontend', 'en', NULL),
(1251, 'comment_rate_this', 'Rate this', 'English', 'frontend', 'en', NULL),
(1252, 'rating', 'Rating', 'English', 'frontend', 'en', NULL),
(1253, 'not_set', 'not set', 'English', 'frontend', 'en', NULL),
(1254, 'vote_cast', 'Vote cast', 'English', 'frontend', 'en', NULL),
(1255, 'votes_cast', 'Votes cast', 'English', 'frontend', 'en', NULL),
(1256, 'thanks_for_voting', 'Thanks for voting', 'English', 'frontend', 'en', NULL),
(1257, 'visual_mode', 'Visual Mode', 'English', 'admin', 'en', NULL),
(1258, 'calendar', 'Calendar', 'English', 'frontend', 'en', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]listings`
--
CREATE TABLE `[[dbprefix]]listings` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(8) NOT NULL DEFAULT '0',
`category_id` int(11) NOT NULL DEFAULT '0',
`transaction_id` int(11) NOT NULL DEFAULT '0',
`moved_from` int(8) NOT NULL DEFAULT '-1',
`domain` varchar(150) NOT NULL DEFAULT '',
`url` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`email` varchar(100) NOT NULL DEFAULT '',
`reciprocal` varchar(100) NOT NULL DEFAULT '',
`recip_valid` enum('0','1') NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`listing_header` int(4) NOT NULL DEFAULT '0',
`status` enum('approval','banned','active') NOT NULL DEFAULT 'approval',
`pagerank` tinyint(2) NOT NULL DEFAULT '-1',
`rank` tinyint(3) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`clicks` int(10) unsigned NOT NULL DEFAULT '0',
`partner` enum('0','1') NOT NULL DEFAULT '0',
`partner_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`featured` enum('0','1') NOT NULL DEFAULT '0',
`featured_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL DEFAULT '',
`expire` int(4) NOT NULL DEFAULT '0',
`action_expire` varchar(20) NOT NULL DEFAULT '',
`last_check_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`cron_cycle` enum('0','1') NOT NULL DEFAULT '0',
`fav_accounts_set` text NOT NULL,
`meta_description` text NOT NULL,
`meta_keywords` text NOT NULL,
`num_votes` int(11) NOT NULL DEFAULT '0',
`rating` float NOT NULL DEFAULT '0',
`min_rating` int(11) NOT NULL DEFAULT '0',
`max_rating` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`),
KEY `date` (`date`),
KEY `recip_valid` (`recip_valid`),
KEY `listing_header` (`listing_header`),
KEY `status` (`status`),
KEY `featured` (`featured`),
KEY `partner` (`partner`),
FULLTEXT KEY `url` (`url`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]listings`
--
INSERT INTO `[[dbprefix]]listings` VALUES
(1, 0, 0, 0, -1, 'www.esyndicat.com', 'http://www.esyndicat.com', 'eSyndiCat is a full featured software that can be used as an addition to your existing site or as a stand-alone platform. Using eSyndiCat Directory Software your website can achieve top rank and take the leading positions in the most popular search engines! You can choose both free and paid versions.', 'no-reply@esyndicat.com', '', '0', '', 200, 'active', 5, 0, '[[regtime]]', '0000-00-00 00:00:00', 0, '0', '0000-00-00 00:00:00', '1', '[[regtime]]', 'eSyndicat Directory Script', 0, '', '0000-00-00 00:00:00', '0', '', '', '', 0, 0, 0, 0),
(2, 0, 12, 0, -1, 'www.onlinecasino.us', 'https://www.onlinecasino.us/', '<p>Compare <a href="https://www.onlinecasino.us/" title="Online Casino - The ultimate gambling portal in the US">online casinos</a>, play free instant casino games & find anything related to gambling. Contribute to the OC Project & Earn Real Money. Join OC today!</p>', '', '', '0', '', 200, 'active', 5, 0, '[[regtime]]', '0000-00-00 00:00:00', 0, '0', '0000-00-00 00:00:00', '1', '[[regtime]]', 'OC Project', 0, '', '0000-00-00 00:00:00', '0', '', '', '', 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]listing_categories`
--
CREATE TABLE `[[dbprefix]]listing_categories` (
`listing_id` int(8) NOT NULL DEFAULT '0',
`category_id` int(8) NOT NULL DEFAULT '0',
KEY `listing_id` (`listing_id`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]listing_clicks`
--
CREATE TABLE `[[dbprefix]]listing_clicks` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`listing_id` int(8) NOT NULL DEFAULT '0',
`ip` varchar(16) NOT NULL DEFAULT '',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `listing_id` (`listing_id`),
KEY `ip` (`ip`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]listing_fields`
--
CREATE TABLE `[[dbprefix]]listing_fields` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`type` enum('text','textarea','combo','radio','checkbox','storage','image','number','pictures') NOT NULL DEFAULT 'text',
`length` varchar(255) NOT NULL DEFAULT '',
`values` text,
`default` varchar(255) NOT NULL DEFAULT '',
`order` double NOT NULL DEFAULT '0',
`tooltip` text NOT NULL,
`editor` enum('0','1') NOT NULL DEFAULT '0',
`required` enum('1','0') NOT NULL DEFAULT '0',
`adminonly` enum('0','1') NOT NULL DEFAULT '0',
`pages` set('suggest','edit','view') NOT NULL DEFAULT '',
`image_height` int(4) NOT NULL DEFAULT '0',
`image_width` int(4) NOT NULL DEFAULT '0',
`thumb_width` int(4) NOT NULL DEFAULT '0',
`thumb_height` int(4) NOT NULL DEFAULT '0',
`resize_mode` int(4) NOT NULL DEFAULT '1001',
`file_prefix` varchar(50) NOT NULL DEFAULT '',
`searchable` tinyint(1) NOT NULL DEFAULT '0',
`file_types` text,
`section_key` varchar(30) NOT NULL DEFAULT '',
`show_as` enum('checkbox','radio','combo') NOT NULL DEFAULT 'checkbox',
`any_meta` varchar(50) NOT NULL DEFAULT '',
`recursive` tinyint(1) NOT NULL DEFAULT '0',
`instead_thumbnail` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `[[dbprefix]]listing_fields`
--
INSERT INTO `[[dbprefix]]listing_fields` VALUES
(1, 'url', 'text', '150', '', 'http://', 2, '', '0', '1', '0', 'suggest,edit,view', 0, 0, 0, 0, 1001, '', 0, '', '', 'checkbox', '', 1, 0),
(2, 'title', 'text', '200', '', '', 1, '', '0', '0', '0', 'suggest,edit,view', 0, 0, 0, 0, 1001, '', 1, '', '', 'checkbox', '', 1, 0),
(3, 'description', 'textarea', '50,500', '', '', 3, '', '0', '0', '0', 'suggest,edit,view', 0, 0, 0, 0, 1001, '', 1, '', '', 'checkbox', '', 1, 0),
(4, 'email', 'text', '100', '', '', 5, '', '0', '1', '0', 'suggest,edit', 0, 0, 0, 0, 1001, '', 0, '', '', 'checkbox', '', 1, 0),
(5, 'reciprocal', 'text', '100', '', 'http://', 4, '', '0', '0', '0', 'suggest,edit', 0, 0, 0, 0, 1001, '', 0, '', '', 'checkbox', '', 1, 0),
(6, 'meta_description', 'textarea', '0,150', '', '', 6, '', '0', '0', '1', '', 0, 0, 0, 0, 1001, '', 0, '', '', 'checkbox', '', 1, 0),
(7, 'meta_keywords', 'textarea', '0,256', '', '', 7, '', '0', '0', '1', '', 0, 0, 0, 0, 1001, '', 0, '', '', 'checkbox', '', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]pages`
--
CREATE TABLE `[[dbprefix]]pages` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`menus` set('main','bottom','account','inventory') NOT NULL DEFAULT 'main',
`status` enum('inactive','active','draft') NOT NULL DEFAULT 'inactive',
`last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`plugin` varchar(50) NOT NULL DEFAULT '',
`order` float NOT NULL DEFAULT '0',
`unique_url` varchar(150) NOT NULL,
`non_modrewrite_url` varchar(150) NOT NULL,
`custom_url` varchar(255) NOT NULL DEFAULT '',
`meta_description` tinytext,
`meta_keywords` tinytext,
`nofollow` enum('1','0') NOT NULL DEFAULT '0',
`readonly` enum('0','1') NOT NULL DEFAULT '0',
`group` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `[[dbprefix]]pages`
--
INSERT INTO `[[dbprefix]]pages` VALUES
(1, 'index', 'main,inventory', 'active', '[[regtime]]', '', 1, 'index.php', 'index.php', '', '', '', '0', '0', 'miscellaneous'),
(2, 'index_browse', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '0', 'miscellaneous'),
(3, 'search', 'main,inventory', 'active', '[[regtime]]', '', 2, 'search.php', 'search.php', '', '', '', '0', '0', 'listings'),
(4, 'new_listings', 'main', 'active', '[[regtime]]', '', 3, 'new-listings.html', 'listings.php?view=new', '', '', '', '0', '0', 'listings'),
(5, 'top_listings', 'main', 'active', '[[regtime]]', '', 4, 'top-listings.html', 'listings.php?view=top', '', '', '', '0', '0', 'listings'),
(6, 'popular_listings', 'main', 'active', '[[regtime]]', '', 5, 'popular-listings.html', 'listings.php?view=popular', '', '', '', '0', '0', 'listings'),
(7, 'random_listings', 'main', 'active', '[[regtime]]', '', 6, 'random-listings.html', 'listings.php?view=random', '', '', '', '0', '0', 'listings'),
(8, 'suggest_listing', 'main,inventory', 'active', '[[regtime]]', '', 7, 'suggest-listing.php?id={idcat}', 'suggest-listing.php?id={idcat}', '', '', '', '1', '0', 'listings'),
(9, 'suggest_category', 'main', 'active', '[[regtime]]', '', 8, 'suggest-category.php?id={idcat}', 'suggest-category.php?id={idcat}', '', '', '', '1', '0', 'miscellaneous'),
(10, 'account_listings', 'account', 'active', '[[regtime]]', '', 9, 'account-listings.html', 'listings.php?view=account', '', '', '', '0', '0', 'listings'),
(11, 'favorites_listings', 'account', 'active', '[[regtime]]', '', 10, 'favorites-listings.html', 'listings.php?view=favorites', '', '', '', '0', '0', 'listings'),
(12, 'edit_account', 'account', 'active', '[[regtime]]', '', 11, 'edit-account.php', 'edit-account.php', '', '', '', '1', '0', 'accounts'),
(13, 'accounts', 'main', 'active', '[[regtime]]', '', 1.1, 'accounts/', 'accounts.php', '', '', '', '0', '0', 'accounts'),
(14, 'account_login', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'accounts'),
(15, 'account_logout', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'accounts'),
(16, 'account_register', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '0', 'accounts'),
(17, 'thank', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'listings'),
(18, 'view_listing', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'listings'),
(19, 'edit_listing', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'listings'),
(20, 'account_password_forgot', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'accounts'),
(21, 'error', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'pages'),
(22, 'confirm', '', 'active', '[[regtime]]', '', 0, '', '', '', '', '', '0', '1', 'pages');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]plugins`
--
CREATE TABLE `[[dbprefix]]plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`author` varchar(75) NOT NULL DEFAULT '',
`contributor` varchar(75) NOT NULL DEFAULT '',
`title` varchar(150) NOT NULL DEFAULT '',
`status` enum('inactive','active','incomplete') NOT NULL DEFAULT 'active',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`version` varchar(15) NOT NULL DEFAULT '',
`summary` text NOT NULL,
`htaccess` text,
`uninstall_code` text,
`uninstall_sql` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]plugins`
--
INSERT INTO `[[dbprefix]]plugins` VALUES
(1, 'kcaptcha', 'Sergey Ten', 'Intelliants LLC', 'KCaptcha', 'active', '0000-00-00 00:00:00', '1.0', 'Plugin will add the CAPTCHA to all pages where it needs.', '', 'global $esynConfig;\n\n $current_value = $esynConfig->getConfig(''captcha_name'');\n\n $esynConfig->setTable(''config'');\n $current_values = $esynConfig->one("`multiple_values`", "`name` = ''captcha_name''");\n $esynConfig->resetTable();\n\n $values = explode('','', $current_values);\n\n if (!empty($values))\n {\n foreach($values as $key => $value)\n {\n if (''kcaptcha'' == $value)\n {\n unset($values[$key]);\n }\n }\n }\n\n $updated_values = join('','', $values);\n\n $esynConfig->setTable(''config'');\n $esynConfig->update(array(''multiple_values'' => $updated_values), "`name` = ''captcha_name''");\n $esynConfig->resetTable();', ''),
(2, 'comments', 'Sergey Ten', 'Intelliants LLC', 'Comments', 'active', '0000-00-00 00:00:00', '2.0', 'The plugin allows visitors adding comments to listings.', NULL, NULL, 'a:3:{i:0;a:2:{s:5:"query";s:30:"DROP TABLE `{prefix}comments`;";s:8:"external";b:0;}i:1;a:2:{s:5:"query";s:27:"DROP TABLE `{prefix}votes`;";s:8:"external";b:0;}i:2;a:2:{s:5:"query";s:101:"ALTER TABLE `{prefix}listings` DROP `num_votes`, DROP `rating`, DROP `min_rating`, DROP `max_rating`;";s:8:"external";b:0;}}');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]related`
--
CREATE TABLE `[[dbprefix]]related` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`category_id` int(8) NOT NULL DEFAULT '0',
`related_id` int(8) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`),
KEY `related_id` (`related_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tabs`
--
CREATE TABLE `[[dbprefix]]tabs` (
`name` varchar(255) NOT NULL DEFAULT '',
`sticky` enum('1','0') NOT NULL DEFAULT '1',
`order` float NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]tabs`
--
INSERT INTO `[[dbprefix]]tabs` VALUES
('help', '1', 1),
('search', '1', 2);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tab_pages`
--
CREATE TABLE `[[dbprefix]]tab_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tab_name` varchar(255) NOT NULL DEFAULT '',
`page_name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]votes`
--
CREATE TABLE `[[dbprefix]]votes` (
`listing_id` int(8) NOT NULL DEFAULT '0',
`vote_value` tinyint(4) NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
KEY `ip_address` (`ip_address`),
KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;