in-link
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Wed, Jul 16, 5:04 PM

in-link
View Options

	Index: branches/5.1.x/units/links/links_event_handler.php
	===================================================================
	--- branches/5.1.x/units/links/links_event_handler.php (revision 13549)
	+++ branches/5.1.x/units/links/links_event_handler.php (revision 13550)
	@@ -1,488 +1,517 @@
	<?php
	/**
	* @version $Id$
	* @package In-Link
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class LinksEventHandler extends kCatDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnContactFormSubmit' => Array('self' => true),
	'OnProcessReciprocalLinks' => Array('self' => true),
	'OnSetGrouping' => Array('self' => 'view'),
	'OnStoreSelected' => Array('self' => 'view'),
	'OnMerge' => Array('self' => 'edit'),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

	$object =& $event->getObject();

	if (!$this->Application->isAdminUser) {
	$object->addFilter('expire_filter', '(Expire > '.adodb_mktime().' OR Expire IS NULL)');
	}

	if (substr($event->Special, 0, 10) == 'duplicates') {
	$object->removeFilter('category_filter');

	$link_helper =& $this->Application->recallObject('LinkHelper');
	/* @var $link_helper LinkHelper */

	$grouping = $link_helper->getGrouping( $event->getPrefixSpecial() );
	switch ($event->Special) {
	case 'duplicates':
	foreach ($grouping as $group_field) {
	$object->AddGroupByField($object->TableName.'.'.$group_field);
	}
	$object->addFilter('has_dupes_filter', 'DupeCount > 1', AGGREGATE_FILTER, FLT_SYSTEM);
	break;

	case 'duplicates-sub':
	$main_object =& $this->Application->recallObject($event->Prefix.'.duplicates');
	foreach ($grouping as $field_index => $group_field) {
	$object->addFilter('dupe_filter_'.$field_index, '%1$s.`'.$group_field.'` = '.$this->Conn->qstr($main_object->GetDBField($group_field)) );
	}
	break;
	}
	$object->addFilter('primary_filter', TABLE_PREFIX.'CategoryItems.PrimaryCat = 1');
	}

	}

	/**
	* Set groping fields for link duplicate checker
	*
	* @param kEvent $event
	*/
	function OnSetGrouping(&$event)
	{
	$this->Application->LinkVar($event->getPrefixSpecial(true).'_dupe_fields', $event->getPrefixSpecial().'_dupe_fields');
	}

	/**
	* Merge duplicate links together (only categories) & delete duplicates
	*
	* @param kEvent $event
	*/
	function OnMerge(&$event)
	{
	$link_helper =& $this->Application->recallObject('LinkHelper');
	/* @var $link_helper LinkHelper */

	$grouping = $link_helper->getGrouping( $event->getPrefixSpecial() );

	$ids = $this->StoreSelectedIDs($event);
	if (!$ids) {
	return true;
	}

	// check, that user has not selected multiple links from same group
	$primary_links = Array();

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT *
	FROM '.$table_name.'
	WHERE '.$id_field.' IN ('.implode(',', $ids).')';
	$links = $this->Conn->Query($sql, $id_field);

	$groping_error = false;
	foreach ($links as $link_id => $link_data) {
	$group_key = '';
	foreach ($grouping as $grouping_field) {
	$group_key .= 'main_table.`'.$grouping_field.'` = '.$this->Conn->qstr($link_data[$grouping_field]).' AND ';
	}
	$group_key = substr($group_key, 0, -5);

	if (isset($primary_links[$group_key])) {
	$groping_error = true;
	break;
	}
	else {
	$primary_links[$group_key] = $link_data['ResourceId'];
	}
	}

	if (!$groping_error) {
	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');

	$categories_sql = 'SELECT main_table.ResourceId, ci.CategoryId, main_table.'.$id_field.'
	FROM '.$table_name.' main_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON main_table.ResourceId = ci.ItemResourceId
	WHERE %s';

	foreach ($primary_links as $group_key => $primary_resource_id) {
	$categories = Array();
	$group_links = Array();
	$group_categories = $this->Conn->Query(sprintf($categories_sql, $group_key));
	foreach ($group_categories as $category_data) {
	$group_links[ $category_data['ResourceId'] ] = $category_data[$id_field];
	$categories[$category_data['ResourceId'] == $primary_resource_id ? 'remove' : 'add'][] = $category_data['CategoryId'];
	}
	unset($group_links[$primary_resource_id]);
	$categories = array_unique( array_diff($categories['add'], $categories['remove']) );
	if ($categories) {
	// add link to other link categories
	$values_sql = '';
	foreach ($categories as $category_id) {
	$values_sql .= '('.$category_id.','.$primary_resource_id.',0),';
	}
	$values_sql = substr($values_sql, 0, -1);
	$insert_sql = 'INSERT INTO '.TABLE_PREFIX.'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES '.$values_sql;
	$this->Conn->Query($insert_sql);
	}

	// delete all links from group except primary
	$temp->DeleteItems($event->Prefix, $event->Special, array_values($group_links));
	}


	}
	else {
	$event->status = erFAIL;
	$event->redirect = false;
	$this->Application->SetVar($event->getPrefixSpecial().'_error', 1);
	}

	}

	/**
	* Stores ids, that were selected in duplicate checker
	*
	* @param kEvent $event
	*/
	function OnStoreSelected(&$event)
	{
	$this->StoreSelectedIDs($event);

	$event->SetRedirectParam('pass', 'm,' . $event->getPrefixSpecial());
	}

	/**
	* Allows to enhance link after creation
	*
	* @param kEvent $event
	*/
	function OnCreate(&$event)
	{
	parent::OnCreate($event);

	if ($event->status == erSUCCESS) {
	$object =& $event->getObject();
	/* @var $object kDBItem */

	// replace 0 id in post with actual created id (used in enhancement process)
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	array_rename_key($items_info, 0, $object->GetID());
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);

	// listing was created -> enhance it right away
	$enhancement_event = new kEvent('ls:OnRequestEnhancement');
	$this->Application->HandleEvent($enhancement_event);
	if (($enhancement_event->status == erSUCCESS) && strlen($enhancement_event->redirect)) {
	$event->SetRedirectParam('next_template', $event->redirect);
	$event->redirect = $enhancement_event->redirect;
	}
	}
	}

	/**
	* Adds free listing option to listing type selection
	*
	* @param kEvent $event
	*/
	function OnAfterConfigRead(&$event)
	{
	parent::OnAfterConfigRead($event);

	if (defined('IS_INSTALL') && IS_INSTALL) {
	return ;
	}

	$free_listings = $this->Application->ConfigValue('Link_AllowFreeListings');

	$virtual_fields = $this->Application->getUnitOption($event->Prefix, 'VirtualFields');
	$virtual_fields['ListingTypeId']['options'] = $free_listings ? Array (0 => 'lu_free_listing') : Array ();

	$language_id = $this->Application->GetVar('m_lang');
	$duplicate_options = array_flip($virtual_fields['DuplicateCheckFields']['options']);
	$duplicate_options['NAME'] = 'l' . $language_id . '_Name';
	$virtual_fields['DuplicateCheckFields']['options'] = array_flip($duplicate_options);
	$default = $virtual_fields['DuplicateCheckFields']['default'];
	$virtual_fields['DuplicateCheckFields']['default'] = str_replace('\|Name\|', '\|l' . $language_id . '_Name\|', $default);

	$this->Application->setUnitOption($event->Prefix, 'VirtualFields', $virtual_fields);

	if (!$this->Application->isAdminUser) {
	// for now only on Front-End
	$this->Application->setUnitOption($event->Prefix, 'PopulateMlFields', true);
	}
	}

	/**
	* contact us form submitted on link details page
	*
	* @param kEvent $event
	*/
	function OnContactFormSubmit(&$event)
	{
	$fields = Array (
	'ContactFormFullName', 'ContactFormEmail', 'ContactFormSubject', 'ContactFormBody', 'ContactFormCaptcha'
	);

	// reset errors var
	$this->Application->SetVar('ContactForm_HasErrors', '');

	// 1. validate form fields
	$required_fields = $this->Application->GetVar('FormRequiredFields');
	foreach ($fields as $field_name) {
	$field_value = trim($this->Application->GetVar($field_name));
	if (in_array($field_name, $required_fields)) {
	// custom captcha validation
	if ($field_name == 'ContactFormCaptcha') {
	if (!strlen($field_value) \|\| ($field_value != $this->Application->RecallVar($event->Prefix . '_captcha_code'))) {
	$this->Application->SetVar('error_'.$field_name, 1);

	$captcha_helper =& $this->Application->recallObject('CaptchaHelper');
	/* @var $captcha_helper kCaptchaHelper */
	$this->Application->StoreVar($event->Prefix . '_captcha_code', $captcha_helper->GenerateCaptchaCode());

	$event->status = erFAIL;
	$event->redirect = false;
	}
	}
	// email validation
	elseif (!strlen($field_value) \|\| ($field_name == 'ContactFormEmail' && !preg_match('/'.REGEX_EMAIL_USER.'@'.REGEX_EMAIL_DOMAIN.'/', $field_value))) {
	$this->Application->SetVar('error_'.$field_name, 1);
	$event->status = erFAIL;
	$event->redirect = false;
	}

	}
	}

	if ($event->status != erSUCCESS) {
	// set errors var
	$this->Application->SetVar('ContactForm_HasErrors', 1);
	return ;
	}

	$object =& $event->getObject(); // get link object
	/* @var $object kDBItem */

	$send_params = Array(
	'from_name' => $this->Application->GetVar('ContactFormFullName'),
	'from_email' => $this->Application->GetVar('ContactFormEmail'),
	'from_subject' => $this->Application->GetVar('ContactFormSubject'),
	'message' => $this->Application->GetVar('ContactFormBody'),
	'to_linkname' => $object->GetField('Name'),
	);

	$email_event =& $this->Application->EmailEventUser('LINK.CONTACTFORM', $object->GetDBField('CreatedById'), $send_params);

	if ($email_event->status == erSUCCESS) {
	$event->redirect = $this->Application->GetVar('success_template');

	$redirect_params = Array (
	'opener' => 's',
	'pass' => 'all',
	'thankyou_header' => $this->Application->GetVar('success_label_header'),
	'thankyou_text' => $this->Application->GetVar('success_label_body')
	);
	$event->setRedirectParams($redirect_params);

	$this->Application->EmailEventAdmin('LINK.CONTACTFORM', null, $send_params);
	}
	else {
	$this->Application->SetVar('error_ContactFormEmail', 1);
	$event->status = erFAIL;
	$event->redirect = false;
	}
	}

	/**
	* Makes reciprocal check on link, when it is created
	*
	* @param kEvent $event
	*/
	function OnBeforeItemCreate(&$event)
	{
	parent::OnBeforeItemCreate($event);

	$this->_checkLink($event);
	}

	/**
	* Makes reciprocal check on link, when it is updated
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	parent::OnBeforeItemUpdate($event);

	$this->_checkLink($event);
	}

	/**
	* Makes reciprocal check on link & saves results
	*
	* @param kEvent $event
	*/
	function _checkLink(&$event)
	{
	if (!$this->Application->ConfigValue('ReciprocalLinkChecking')) {
	return ;
	}

	$object =& $event->getObject();
	/* @var $object kDBItem */

	if ($object->GetDBField('Url') != $object->GetOriginalField('Url')) {
	// check only when url was changed

	$link_helper =& $this->Application->recallObject('LinkHelper');
	/* @var $link_helper LinkHelper */

	$link_checked = $link_helper->CheckReciprocalURL($object->GetDBField('Url'));

	$object->SetDBField('ReciprocalLinkFound', $link_checked ? LINK_IS_RECIPROCAL : LINK_IS_NOT_RECIPROCAL);

	if (!$link_checked) {
	$this->Application->EmailEventAdmin('LINK.RECIPROCAL.CHECK.FAILED');
	}
	}
	}

	/**
	* Update links status by their reciprocal status
	*
	* @param kEvent $event
	*/
	function OnProcessReciprocalLinks(&$event)
	{
	if (!$this->Application->ConfigValue('ReciprocalLinkChecking')) {
	return ;
	}

	$object =& $event->getObject( Array('skip_autoload' => true) );
	/* @var $object kDBItem */

	$link_helper =& $this->Application->recallObject('LinkHelper');
	/* @var $link_helper LinkHelper */

	// 1. verify all links, that were not verified previously
	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE (ReciprocalLinkFound = 0)';
	$not_checked_links = $this->Conn->GetCol($sql);

	foreach ($not_checked_links as $link_id) {
	$object->Load($link_id);

	$link_checked = $link_helper->CheckReciprocalURL($object->GetDBField('Url'));

	$object->SetDBField('ReciprocalLinkFound', $link_checked ? LINK_IS_RECIPROCAL : LINK_IS_NOT_RECIPROCAL);
	$object->Update();

	if ($link_checked) {
	$object->ApproveChanges();
	}
	else {
	$object->DeclineChanges();
	$this->Application->EmailEventAdmin('LINK.RECIPROCAL.CHECK.FAILED');
	}
	}

	// 2. approve all links, that have succeeded in reciprocal check (during adding/changing on front-end)
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');

	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE (ReciprocalLinkFound = ' . LINK_IS_RECIPROCAL . ') AND (Status <> ' . STATUS_ACTIVE . ')';
	$verified_links = $this->Conn->GetCol($sql);

	foreach ($verified_links as $link_id) {
	$object->Load($link_id);
	$object->ApproveChanges();
	}

	// 3. decline all links, that failed in reciprocal check (during adding/changing on front-end)
	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE (ReciprocalLinkFound = ' . LINK_IS_NOT_RECIPROCAL . ') AND (Status <> ' . STATUS_DISABLED . ')';
	$not_verified_links = $this->Conn->GetCol($sql);

	foreach ($not_verified_links as $link_id) {
	$object->Load($link_id);
	$object->DeclineChanges();
	}
	}

	/**
	* Allows to load duplicate link by special id
	*
	* @param kEvent $event
	* @return int
	*/
	function getPassedID(&$event)
	{
	$id = parent::getPassedID($event);

	if (($event->Special == 'duplicates') && !is_numeric($id)) {
	$load_keys = unserialize( base64_decode($id) );
	// can't return $load_keys as $id, because "kCatDBItem::GetKeyClause" will ignore them

	foreach ($load_keys as $field => $value) {
	$load_keys[$field] = $field . ' = ' . $this->Conn->qstr($value);
	}

	$sql = 'SELECT ' . $this->Application->getUnitOption($event->Prefix, 'IDField') . '
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . '
	WHERE (' . implode(') AND (', $load_keys) . ')';
	$id = $this->Conn->GetOne($sql);
	}

	return $id;
	}

	/**
	* Returns events, that require item-based (not just event-name based) permission check
	*
	* @return Array
	*/
	function _getMassPermissionEvents()
	{
	$events = parent::_getMassPermissionEvents();
	$events[] = 'OnMerge';

	return $events;
	}
	+
	+ /**
	+ * [HOOK] Allows to add cloned subitem to given prefix
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnCloneSubItem(&$event)
	+ {
	+ parent::OnCloneSubItem($event);
	+
	+ if ($event->MasterEvent->Prefix == 'rev') {
	+ $clones = $this->Application->getUnitOption($event->MasterEvent->Prefix, 'Clones');
	+ $subitem_prefix = $event->Prefix . '-' . $event->MasterEvent->Prefix;
	+
	+ $clones[$subitem_prefix]['ConfigMapping'] = Array (
	+ 'PerPage' => 'Perpage_LinkReviews',
	+ 'ShortListPerPage' => 'Perpage_LinkReviews_Short',
	+ 'DefaultSorting1Field' => 'Link_ReviewsSort',
	+ 'DefaultSorting2Field' => 'Link_ReviewsSort2',
	+ 'DefaultSorting1Dir' => 'Link_ReviewsOrder',
	+ 'DefaultSorting2Dir' => 'Link_ReviewsOrder2',
	+
	+ 'ReviewDelayInterval' => 'link_ReviewDelay_Interval',
	+ 'ReviewDelayValue' => 'link_ReviewDelay_Value',
	+ );
	+
	+ $this->Application->setUnitOption($event->MasterEvent->Prefix, 'Clones', $clones);
	+ }
	+ }
	}
	\ No newline at end of file
	Index: branches/5.1.x/units/links/links_config.php
	===================================================================
	--- branches/5.1.x/units/links/links_config.php (revision 13549)
	+++ branches/5.1.x/units/links/links_config.php (revision 13550)
	@@ -1,573 +1,651 @@
	<?php
	/**
	* @version $Id$
	* @package In-Link
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	- $config = Array(
	+ $config = Array (
	'Prefix' => 'l',
	- 'ItemClass' => Array('class'=>'kCatDBItem','file'=>'','build_event'=>'OnItemBuild'),
	- 'ListClass' => Array('class'=>'kCatDBList','file'=>'','build_event'=>'OnListBuild'),
	- 'EventHandlerClass' => Array('class' => 'LinksEventHandler', 'file' => 'links_event_handler.php', 'require_classes' => Array('kCatDBEventHandler'), 'build_event'=>'OnBuild'),
	- 'TagProcessorClass' => Array('class'=>'LinkTagProcessor','file'=>'link_tag_processor.php', 'require_classes' => Array('kCatDBTagProcessor'), 'build_event'=>'OnBuild'),
	+ 'ItemClass' => Array ('class' => 'kCatDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	+ 'ListClass' => Array ('class' => 'kCatDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	+ 'EventHandlerClass' => Array ('class' => 'LinksEventHandler', 'file' => 'links_event_handler.php', 'require_classes' => Array ('kCatDBEventHandler'), 'build_event' => 'OnBuild'),
	+ 'TagProcessorClass' => Array ('class' => 'LinkTagProcessor', 'file' => 'link_tag_processor.php', 'require_classes' => Array ('kCatDBTagProcessor'), 'build_event' => 'OnBuild'),
	'AutoLoad' => true,

	'ConfigPriority' => 0,

	'RewritePriority' => 101,
	'RewriteListener' => 'ModRewriteHelper:CategoryItemRewriteListener',

	'Hooks' => Array (
	Array (
	'Mode' => hBEFORE,
	'Conditional' => false,
	'HookToPrefix' => '',
	'HookToSpecial' => '*',
	- 'HookToEvent' => Array('OnAfterConfigRead'),
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	'DoPrefix' => 'cdata',
	'DoSpecial' => '*',
	'DoEvent' => 'OnDefineCustomFields',
	),

	Array (
	'Mode' => hBEFORE,
	'Conditional' => false,
	- 'HookToPrefix' => '',
	+ 'HookToPrefix' => '#file',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnCloneSubItem',
	+ ),
	+
	+ Array (
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'rev',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnCloneSubItem',
	+ ),
	+
	+ Array (
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'fav',
	'HookToSpecial' => '*',
	- 'HookToEvent' => Array('OnAfterConfigRead'),
	- 'DoPrefix' => '#file',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	'DoSpecial' => '*',
	- 'DoEvent' => 'OnDefineFiles',
	+ 'DoEvent' => 'OnCloneSubItem',
	),
	+
	+ Array (
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'rel',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnCloneSubItem',
	+ ),
	+
	+ Array (
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'img',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnCloneSubItem',
	+ ),
	+
	+ Array (
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'ci',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	+ 'DoPrefix' => '',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnCloneSubItem',
	+ ),
	+
	Array (
	'Mode' => hAFTER,
	'Conditional' => false,
	'HookToPrefix' => '',
	'HookToSpecial' => '*',
	- 'HookToEvent' => Array('OnAfterConfigRead'),
	+ 'HookToEvent' => Array ('OnAfterConfigRead'),
	'DoPrefix' => 'captcha',
	'DoSpecial' => '*',
	'DoEvent' => 'OnPrepareCaptcha',
	- ),
	+ ),
	),

	- 'QueryString' => Array(
	+ 'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	5 => 'mode',
	),

	'AggregateTags' => Array (
	Array (
	'AggregateTo' => 'l',
	'AggregatedTagName' => 'ListLinks',
	'LocalTagName' => 'PrintList2',
	),
	),

	'CatalogItem' => true,
	'AdminTemplatePath' => 'links',
	'AdminTemplatePrefix' => 'links_',
	'SearchConfigPostfix' => 'links',

	'IDField' => 'LinkId',
	- 'StatusField' => Array('Status'), // field, that is affected by Approve/Decline events
	+ 'StatusField' => Array ('Status'), // field, that is affected by Approve/Decline events

	'ItemType' => 4,

	- 'StatisticsInfo' => Array(
	- 'pending' => Array(
	+ 'StatisticsInfo' => Array (
	+ 'pending' => Array (
	'icon' => 'icon16_link_pending.png',
	'label' => 'la_Text_Links',
	'js_url' => '#url#',
	- 'url' => Array('t' => 'catalog/advanced_view', 'SetTab' => 'l', 'pass' => 'm,l.showall', 'l.showall_event' => 'OnSetFilterPattern', 'l.showall_filters' => 'show_active=0,show_pending=1,show_disabled=0,show_new=1,show_hot=1,show_pop=1,show_pick=1'),
	+ 'url' => Array ('t' => 'catalog/advanced_view', 'SetTab' => 'l', 'pass' => 'm,l.showall', 'l.showall_event' => 'OnSetFilterPattern', 'l.showall_filters' => 'show_active=0,show_pending=1,show_disabled=0,show_new=1,show_hot=1,show_pop=1,show_pick=1'),
	'status' => STATUS_PENDING,
	),
	),

	'TitlePhrase' => 'la_Text_Link', // phrase used to specify item type in relationship list

	'ViewMenuPhrase' => 'la_title_Links',
	'CatalogTabIcon' => 'in-link:icon16_links.png',
	'UsePendingEditing' => true, // item editing is controlled by LINK.ADD/EDIT, LINK.ADD/EDIT.PENDING permissions

	'CatalogSelectorName' => 'linklist', // used in old catalog section

	- 'ItemPropertyMappings' => Array(
	+ 'ItemPropertyMappings' => Array (
	'NewDays' => 'Link_NewDays', // number of days item to be NEW
	'MinPopVotes' => 'Link_MinPopVotes', // minimum number of votes for an item to be POP
	'MinPopRating' => 'Link_MinPopRating', // minimum rating for an item to be POP
	'MaxHotNumber' => 'Link_MaxHotNumber', // maximum number of HOT items

	'HotLimit' => 'Link_HotLimit', // variable name in inp_Cache table
	'ClickField' => 'Hits', // item click count is stored here (in item table)
	),

	'TitleField' => 'Name',

	- 'TitlePresets' => Array(
	- 'default' => Array(
	- 'new_status_labels' => Array('l' => '!la_title_AddingLink!'),
	- 'edit_status_labels' => Array('l'=>'!la_title_EditingLink!'),
	- 'new_titlefield' => Array('l'=>'!la_title_NewLink!'),
	+ 'TitlePresets' => Array (
	+ 'default' => Array (
	+ 'new_status_labels' => Array ('l' => '!la_title_AddingLink!'),
	+ 'edit_status_labels' => Array ('l' => '!la_title_EditingLink!'),
	+ 'new_titlefield' => Array ('l' => '!la_title_NewLink!'),
	),

	- 'links_edit' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_General!",
	+ 'links_edit' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_General!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next'),
	),

	- 'link_list' => Array(
	- 'prefixes' => Array('c_List', 'l_List'),
	+ 'link_list' => Array (
	+ 'prefixes' => Array ('c_List', 'l_List'),
	'format' => "!la_title_Categories! (#c_recordcount#) - !la_title_Links!",
	'toolbar_buttons' => Array (),
	),

	- 'links_categories' => Array(
	- 'prefixes' => Array('l','l-ci_List'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Categories!",
	+ 'links_categories' => Array (
	+ 'prefixes' => Array ('l', 'l-ci_List'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Categories!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next', 'new_item', 'delete', 'setprimary',),
	),

	- 'links_relations' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Relations!",
	+ 'links_relations' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Relations!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next', 'new_item', 'edit', 'delete', 'approve', 'decline', 'view', 'dbl-click'),
	),

	- 'links_images' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Images!",
	+ 'links_images' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Images!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next', 'new_item', 'edit', 'delete', 'move_up', 'move_down', 'setprimary', 'view', 'dbl-click'),
	),

	- 'links_files' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Files!",
	+ 'links_files' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Files!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next', 'new_item', 'edit', 'delete', 'view', 'dbl-click'),
	),

	- 'links_reviews' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Reviews!",
	+ 'links_reviews' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Reviews!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next', 'new_item', 'edit', 'delete', 'approve', 'decline', 'move_up', 'move_down', 'view', 'dbl-click'),
	),

	- 'links_custom' => Array(
	- 'prefixes' => Array('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Custom!",
	+ 'links_custom' => Array (
	+ 'prefixes' => Array ('l'), 'format' => "#l_status# '#l_titlefield#' - !la_title_Custom!",
	'toolbar_buttons' => Array ('select', 'cancel', 'prev', 'next'),
	),

	- 'images_edit' => Array(
	- 'prefixes' => Array('l', 'l-img'),
	- 'new_status_labels' => Array('l-img' => '!la_title_Adding_Image!'),
	- 'edit_status_labels' => Array('l-img' => '!la_title_Editing_Image!'),
	- 'new_titlefield' => Array('l-img' => '!la_title_New_Image!'),
	+ 'images_edit' => Array (
	+ 'prefixes' => Array ('l', 'l-img'),
	+ 'new_status_labels' => Array ('l-img' => '!la_title_Adding_Image!'),
	+ 'edit_status_labels' => Array ('l-img' => '!la_title_Editing_Image!'),
	+ 'new_titlefield' => Array ('l-img' => '!la_title_New_Image!'),
	'format' => "#l_status# '#l_titlefield#' - #l-img_status# '#l-img_titlefield#'",
	'toolbar_buttons' => Array ('select', 'cancel'),
	),

	'file_edit' => Array (
	'prefixes' => Array ('l', 'l-file'),
	'new_status_labels' => Array ('l-file' => "!la_title_AddingFile!"),
	'edit_status_labels' => Array ('l-file' => '!la_title_EditingFile!'),
	'new_titlefield' => Array ('l-file' => '!la_title_NewFile!'),
	'format' => "#l_status# '#l_titlefield#' - #l-file_status# '#l-file_titlefield#'",
	'toolbar_buttons' => Array ('select', 'cancel'),
	),

	- 'reviews_edit' => Array(
	- 'prefixes' => Array('l', 'l-rev'),
	- 'new_status_labels' => Array('l-rev'=>"!la_title_Adding_Review! '!la_title_New_Review!'"),
	- 'edit_status_labels' => Array('l-rev'=>'!la_title_Editing_Review!'),
	+ 'reviews_edit' => Array (
	+ 'prefixes' => Array ('l', 'l-rev'),
	+ 'new_status_labels' => Array ('l-rev' =>"!la_title_Adding_Review! '!la_title_New_Review!'"),
	+ 'edit_status_labels' => Array ('l-rev' => '!la_title_Editing_Review!'),
	'format' => "#l_status# '#l_titlefield#' - #l-rev_status#",
	'toolbar_buttons' => Array ('select', 'cancel'),
	),

	- 'relations_edit' => Array(
	- 'prefixes' => Array('l', 'l-rel'),
	- 'new_status_labels' => Array('l-rel'=>"!la_title_Adding_Relationship! '!la_title_New_Relationship!'"),
	- 'edit_status_labels' => Array('l-rel'=>'!la_title_Editing_Relationship!'),
	+ 'relations_edit' => Array (
	+ 'prefixes' => Array ('l', 'l-rel'),
	+ 'new_status_labels' => Array ('l-rel' =>"!la_title_Adding_Relationship! '!la_title_New_Relationship!'"),
	+ 'edit_status_labels' => Array ('l-rel' => '!la_title_Editing_Relationship!'),
	'format' => "#l_status# '#l_titlefield#' - #l-rel_status#",
	'toolbar_buttons' => Array ('select', 'cancel'),
	),

	- 'links_export' => Array('format' => '!la_title_LinksExport!'),
	+ 'links_export' => Array ('format' => '!la_title_LinksExport!'),

	- 'links_import' => Array('format' => '!la_title_ImportLinks!'),
	+ 'links_import' => Array ('format' => '!la_title_ImportLinks!'),

	- 'duplicate_links' => Array(
	- 'prefixes' => Array('l.duplicates_List'), 'format' => "!la_title_DuplicateLinks! - %s",
	+ 'duplicate_links' => Array (
	+ 'prefixes' => Array ('l.duplicates_List'), 'format' => "!la_title_DuplicateLinks! - %s",
	'toolbar_buttons' => Array ('edit', 'view', 'dbl-click'),
	),

	- 'duplicate_links_view' => Array(
	- 'prefixes' => Array('l.duplicates-sub_List'), 'format' => "!la_title_Links!",
	+ 'duplicate_links_view' => Array (
	+ 'prefixes' => Array ('l.duplicates-sub_List'), 'format' => "!la_title_Links!",
	'toolbar_buttons' => Array ('cancel', 'edit', 'delete', 'merge_links', 'view', 'dbl-click'),
	),

	- 'tree_in-link' => Array('format' => '!la_Text_Version! '.$this->Application->findModule('Name', 'In-Link', 'Version')),
	+ 'tree_in-link' => Array ('format' => '!la_Text_Version! '.$this->Application->findModule('Name', 'In-Link', 'Version')),
	),

	'EditTabPresets' => Array (
	'Default' => Array (
	'general' => Array ('title' => 'la_tab_General', 't' => 'in-link/links/links_edit', 'priority' => 1),
	'categories' => Array ('title' => 'la_tab_Categories', 't' => 'in-link/links/links_categories', 'priority' => 2),
	'relations' => Array ('title' => 'la_tab_Relations', 't' => 'in-link/links/links_relations', 'priority' => 3),
	'images' => Array ('title' => 'la_tab_Images', 't' => 'in-link/links/links_images', 'priority' => 4),
	'files' => Array ('title' => 'la_tab_Files', 't' => 'in-link/links/links_files', 'priority' => 5),
	'reviews' => Array ('title' => 'la_tab_Reviews', 't' => 'in-link/links/links_reviews', 'priority' => 6),
	'custom' => Array ('title' => 'la_tab_Custom', 't' => 'in-link/links/links_custom', 'priority' => 7),
	),
	),

	'PermItemPrefix' => 'LINK',

	'PermTabText' => 'In-Link',
	- 'PermSection' => Array('main' => 'CATEGORY:in-link:links_list', 'search' => 'in-link:configuration_search', 'email' => 'in-link:configuration_email', 'custom' => 'in-link:configuration_custom'),
	+ 'PermSection' => Array ('main' => 'CATEGORY:in-link:links_list', 'search' => 'in-link:configuration_search', 'email' => 'in-link:configuration_email', 'custom' => 'in-link:configuration_custom'),

	- 'Sections' => Array(
	- 'in-link' => Array(
	+ 'Sections' => Array (
	+ 'in-link' => Array (
	'parent' => 'in-portal:root',
	'icon' => 'settings_in-link',
	'label' => 'la_title_In-Link',
	- 'url' => Array('t' => 'index', 'pass_section' => true, 'pass' => 'm'),
	- 'permissions' => Array('view'),
	+ 'url' => Array ('t' => 'index', 'pass_section' => true, 'pass' => 'm'),
	+ 'permissions' => Array ('view'),
	'priority' => 2.3,
	'container' => true,
	'type' => stTREE,
	),

	- 'in-link:links' => Array(
	+ 'in-link:links' => Array (
	'parent' => 'in-portal:site',
	'icon' => 'links',
	'label' => 'la_tab_Links',
	- 'url' => Array('t' => 'catalog/advanced_view', 'anchor' => 'tab-l.showall', 'pass' => 'm'),
	+ 'url' => Array ('t' => 'catalog/advanced_view', 'anchor' => 'tab-l.showall', 'pass' => 'm'),
	'onclick' => 'setCatalogTab(\'l.showall\')',
	- 'permissions' => Array('view'),
	+ 'permissions' => Array ('view'),
	'priority' => 3.1,
	'type' => stTREE,
	),

	- 'in-link:duplicate_checker' => Array(
	+ 'in-link:duplicate_checker' => Array (
	'parent' => 'in-link',
	'icon' => 'duplicate_checker',
	'label' => 'la_tab_DuplicateChecker',
	- 'url' => Array('t' => 'in-link/duplicate_checker', 'pass' => 'm'),
	- 'permissions' => Array('view', 'add', 'edit', 'delete'),
	+ 'url' => Array ('t' => 'in-link/duplicate_checker', 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'add', 'edit', 'delete'),
	'priority' => 2,
	'type' => stTREE,
	),

	// link settings
	'in-link:setting_folder' => Array (
	'parent' => 'in-portal:system',
	'icon' => 'conf_directory',
	'label' => 'la_title_In-Link',
	'use_parent_header' => 1,
	'url' => Array ('t' => 'index', 'pass_section' => true, 'pass' => 'm'),
	'permissions' => Array ('view'),
	'priority' => 3.3,
	'container' => true,
	'type' => stTREE,
	),

	- /*'in-link:inlink_general' => Array(
	+ /*'in-link:inlink_general' => Array (
	'parent' => 'in-link:setting_folder',
	'icon' => 'core:settings_general',
	'label' => 'la_tab_GeneralSettings',
	- 'url' => Array('t' => 'config/config_general', 'pass_section' => true, 'pass' => 'm'),
	- 'permissions' => Array('view', 'edit'),
	+ 'url' => Array ('t' => 'config/config_general', 'pass_section' => true, 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'edit'),
	'priority' => 0.9,
	'type' => stTREE,
	),*/

	- 'in-link:configuration_output' => Array(
	+ 'in-link:configuration_output' => Array (
	'parent' => 'in-link:setting_folder',
	'icon' => 'core:conf_output',
	'label' => 'la_tab_ConfigOutput',
	- 'url' => Array('t' => 'config/config_general', 'pass_section' => true, 'pass' => 'm'),
	- 'permissions' => Array('view', 'edit'),
	+ 'url' => Array ('t' => 'config/config_general', 'pass_section' => true, 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'edit'),
	'priority' => 1,
	'type' => stTREE,
	),

	- 'in-link:configuration_search' => Array(
	+ 'in-link:configuration_search' => Array (
	'parent' => 'in-link:setting_folder',
	'icon' => 'core:conf_search',
	'label' => 'la_tab_ConfigSearch',
	- 'url' => Array('t' => 'config/config_search', 'module_key' => 'links', 'pass_section' => true, 'pass' => 'm'),
	- 'permissions' => Array('view', 'edit'),
	+ 'url' => Array ('t' => 'config/config_search', 'module_key' => 'links', 'pass_section' => true, 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'edit'),
	'priority' => 2,
	'type' => stTREE,
	),

	- 'in-link:configuration_email' => Array(
	+ 'in-link:configuration_email' => Array (
	'parent' => 'in-link:setting_folder',
	'icon' => 'core:conf_email',
	'label' => 'la_tab_ConfigE-mail',
	- 'url' => Array('t' => 'config/config_email', 'pass_section' => true, 'pass' => 'm'),
	- 'permissions' => Array('view', 'edit'),
	+ 'url' => Array ('t' => 'config/config_email', 'pass_section' => true, 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'edit'),
	'priority' => 3,
	'type' => stTREE,
	),

	- 'in-link:configuration_custom' => Array(
	+ 'in-link:configuration_custom' => Array (
	'parent' => 'in-link:setting_folder',
	'icon' => 'core:conf_customfields',
	'label' => 'la_tab_ConfigCustom',
	- 'url' => Array('t' => 'custom_fields/custom_fields_list', 'cf_type' => 4, 'pass_section' => true, 'pass' => 'm,cf'),
	- 'permissions' => Array('view', 'add', 'edit', 'delete'),
	+ 'url' => Array ('t' => 'custom_fields/custom_fields_list', 'cf_type' => 4, 'pass_section' => true, 'pass' => 'm,cf'),
	+ 'permissions' => Array ('view', 'add', 'edit', 'delete'),
	'priority' => 4,
	'type' => stTREE,
	),
	),

	- 'FilterMenu' => Array(
	- 'Groups' => Array(
	- Array('mode' => 'AND', 'filters' => Array('show_active','show_pending','show_disabled'), 'type' => WHERE_FILTER),
	- Array('mode' => 'AND', 'filters' => Array('show_new'), 'type' => HAVING_FILTER),
	- Array('mode' => 'AND', 'filters' => Array('show_hot'), 'type' => HAVING_FILTER),
	- Array('mode' => 'AND', 'filters' => Array('show_pop'), 'type' => HAVING_FILTER),
	- Array('mode' => 'AND', 'filters' => Array('show_pick'), 'type' => WHERE_FILTER),
	+ 'FilterMenu' => Array (
	+ 'Groups' => Array (
	+ Array ('mode' => 'AND', 'filters' => Array ('show_active', 'show_pending', 'show_disabled'), 'type' => WHERE_FILTER),
	+ Array ('mode' => 'AND', 'filters' => Array ('show_new'), 'type' => HAVING_FILTER),
	+ Array ('mode' => 'AND', 'filters' => Array ('show_hot'), 'type' => HAVING_FILTER),
	+ Array ('mode' => 'AND', 'filters' => Array ('show_pop'), 'type' => HAVING_FILTER),
	+ Array ('mode' => 'AND', 'filters' => Array ('show_pick'), 'type' => WHERE_FILTER),
	),
	- 'Filters' => Array(
	- 'show_active' => Array('label' =>'la_Active', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ),
	- 'show_pending' => Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ),
	- 'show_disabled' => Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ),
	- 's1' => Array(),
	- 'show_new' => Array('label' => 'la_Text_New', 'on_sql' => '', 'off_sql' => '`IsNew` != 1' ),
	- 'show_hot' => Array('label' => 'la_Text_Hot', 'on_sql' => '', 'off_sql' => '`IsHot` != 1' ),
	- 'show_pop' => Array('label' => 'la_Text_Pop', 'on_sql' => '', 'off_sql' => '`IsPop` != 1' ),
	- 'show_pick' => Array('label' => 'la_prompt_EditorsPick', 'on_sql' => '', 'off_sql' => '%1$s.`EditorsPick` != 1' ),
	+ 'Filters' => Array (
	+ 'show_active' => Array ('label' => 'la_Active', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ),
	+ 'show_pending' => Array ('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ),
	+ 'show_disabled' => Array ('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ),
	+ 's1' => Array (),
	+ 'show_new' => Array ('label' => 'la_Text_New', 'on_sql' => '', 'off_sql' => '`IsNew` != 1' ),
	+ 'show_hot' => Array ('label' => 'la_Text_Hot', 'on_sql' => '', 'off_sql' => '`IsHot` != 1' ),
	+ 'show_pop' => Array ('label' => 'la_Text_Pop', 'on_sql' => '', 'off_sql' => '`IsPop` != 1' ),
	+ 'show_pick' => Array ('label' => 'la_prompt_EditorsPick', 'on_sql' => '', 'off_sql' => '%1$s.`EditorsPick` != 1' ),
	)
	),

	'TableName' => TABLE_PREFIX.'Link',

	'CalculatedFields' => Array (
	'' => Array (
	'UserName' => 'IF (ISNULL(u.Login), IF (%1$s.CreatedById = -1, "root", IF (%1$s.CreatedById = -2, "Guest", "n/a")), u.Login)',
	'CategoryId' => TABLE_PREFIX.'%3$sCategoryItems.CategoryId',
	'Filename' => TABLE_PREFIX.'%3$sCategoryItems.Filename',
	'CategoryFilename' => TABLE_PREFIX.'Category.NamedParentPath',
	'PrimaryCat' => TABLE_PREFIX.'%3$sCategoryItems.PrimaryCat',
	'ParentPath' => TABLE_PREFIX.'Category.ParentPath',

	+ 'AltName' => 'img.AltName',
	'SameImages' => 'img.SameImages',
	'LocalThumb' => 'img.LocalThumb',
	'ThumbPath' => 'img.ThumbPath',
	'ThumbUrl' => 'img.ThumbUrl',
	'LocalImage' => 'img.LocalImage',
	'LocalPath' => 'img.LocalPath',
	'FullUrl' => 'img.Url',
	),
	),

	'CacheModRewrite' => true,

	- 'AggregatedCalculatedFields' => Array(
	+ 'AggregatedCalculatedFields' => Array (

	'duplicates' => Array (
	'DupeCount' => 'COUNT(*)',
	),
	),


	- 'ListSQLs' => Array( ''=>' SELECT %1$s.* %2$s
	+ 'ListSQLs' => Array ( '' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'%3$sCategoryItems ON '.TABLE_PREFIX.'%3$sCategoryItems.ItemResourceId = %1$s.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category ON '.TABLE_PREFIX.'Category.CategoryId = '.TABLE_PREFIX.'%3$sCategoryItems.CategoryId
	LEFT JOIN '.TABLE_PREFIX.'Images img ON img.ResourceId = %1$s.ResourceId AND img.DefaultImg = 1
	LEFT JOIN '.TABLE_PREFIX.'PermCache perm ON perm.CategoryId = '.TABLE_PREFIX.'%3$sCategoryItems.CategoryId
	LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.CreatedById = u.PortalUserId
	LEFT JOIN '.TABLE_PREFIX.'%3$sLinkCustomData cust ON %1$s.ResourceId = cust.ResourceId',

	), // key - special, value - list select sql

	- 'ListSortings' => Array(
	- '' => Array(
	- 'ForcedSorting' => Array('Priority' => 'desc'),
	- 'Sorting' => Array('Name' => 'asc', 'Description' => 'desc'),
	+ 'ListSortings' => Array (
	+ '' => Array (
	+ 'ForcedSorting' => Array ('Priority' => 'desc'),
	+ 'Sorting' => Array ('Name' => 'asc', 'Description' => 'desc'),
	)
	),
	- 'ItemSQLs' => Array( ''=>' SELECT %1$s.* %2$s
	+ 'ItemSQLs' => Array ( '' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'%3$sCategoryItems ON '.TABLE_PREFIX.'%3$sCategoryItems.ItemResourceId = %1$s.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category ON '.TABLE_PREFIX.'Category.CategoryId = '.TABLE_PREFIX.'%3$sCategoryItems.CategoryId
	LEFT JOIN '.TABLE_PREFIX.'Images img ON img.ResourceId = %1$s.ResourceId AND img.DefaultImg = 1
	LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.CreatedById = u.PortalUserId
	LEFT JOIN '.TABLE_PREFIX.'%3$sLinkCustomData cust ON %1$s.ResourceId = cust.ResourceId'),

	- 'SubItems' => Array('l-rev', 'l-ci', 'l-rel', 'l-img', 'l-cdata', 'l-fav', 'l-file'),
	+ 'SubItems' => Array ('l-rev', 'l-ci', 'l-rel', 'l-img', 'l-cdata', 'l-fav', 'l-file'),

	'Fields' => Array (
	- 'LinkId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0,),
	- 'Name' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'required' => 1, 'max_len' => 255, 'default' => ''),
	- 'AutomaticFilename' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 1),
	- 'Description' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'using_fck' => 1, 'default' => null),
	- 'Url' => Array('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => ''),
	- 'CreatedOn' => Array('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	- 'Modified' => Array('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	- 'Expire' => Array('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => null),
	- 'Hits' => Array('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%d', 'not_null' => 1, 'default' => 0),
	- 'CachedRating' => Array('type' => 'string', 'not_null' => 1, 'formatter' => 'kFormatter', 'default' => 0),
	- 'CachedVotesQty' => Array('type' => 'int', 'formatter' => 'kFormatter', 'not_null' => 1, 'default' => 0),
	- 'CachedReviewsQty' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	- 'CreatedById' => Array('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array(-1 => 'root', -2 => 'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1, 'default' => -1),
	- 'ModifiedById' => Array('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array(-1 => 'root', -2 => 'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1, 'default' => -1),
	- 'Priority' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	- 'Status' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Active', 2 => 'la_Pending', 0 => 'la_Disabled'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
	- 'EditorsPick' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0),
	- 'ResourceId' => Array('type' => 'int', 'default' => null),
	- 'HotItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1,'default' => 2),
	- 'PopItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1,'default' => 2),
	- 'NewItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1,'default' => 2),
	- 'OrgId' => Array('type' => 'int', 'default' => null),
	- 'CustomTemplate' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
	- 'MetaKeywords' => Array('type' => 'string', 'default' => null),
	- 'MetaDescription' => Array('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => null),
	+ 'LinkId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0,),
	+ 'Name' => Array ('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'required' => 1, 'max_len' => 255, 'default' => ''),
	+ 'AutomaticFilename' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 1),
	+ 'Description' => Array ('type' => 'string', 'formatter' => 'kMultiLanguage', 'using_fck' => 1, 'default' => null),
	+ 'Url' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => ''),
	+ 'CreatedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	+ 'Modified' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	+ 'Expire' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => null),
	+ 'Hits' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%d', 'not_null' => 1, 'default' => 0),
	+ 'CachedRating' => Array ('type' => 'string', 'not_null' => 1, 'formatter' => 'kFormatter', 'default' => 0),
	+ 'CachedVotesQty' => Array ('type' => 'int', 'formatter' => 'kFormatter', 'not_null' => 1, 'default' => 0),
	+ 'CachedReviewsQty' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'CreatedById' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (-1 => 'root', -2 => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1, 'default' => -1),
	+ 'ModifiedById' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (-1 => 'root', -2 => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1, 'default' => -1),
	+ 'Priority' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'Status' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (1 => 'la_Active', 2 => 'la_Pending', 0 => 'la_Disabled'), 'use_phrases' => 1,
	+ 'not_null' => 1, 'default' => 2,
	+ ),
	+ 'EditorsPick' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1,
	+ 'not_null' => 1, 'default' => 0,
	+ ),
	+ 'ResourceId' => Array ('type' => 'int', 'default' => null),
	+ 'HotItem' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
	+ 'PopItem' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
	+ 'NewItem' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
	+ 'OrgId' => Array ('type' => 'int', 'default' => null),
	+ 'CustomTemplate' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
	+ 'MetaKeywords' => Array ('type' => 'string', 'default' => null),
	+ 'MetaDescription' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => null),
	'ReciprocalLinkFound' => Array (
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_NotChecked', 1 => 'la_Yes', 2 => 'la_No'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 0
	),
	),

	- 'VirtualFields' => Array(
	- 'UserName' => Array('type' => 'string', 'default' => ''),
	- 'DupeCount' => Array('type' => 'string', 'default' => ''),
	+ 'VirtualFields' => Array (
	+ 'UserName' => Array ('type' => 'string', 'default' => ''),
	+ 'DupeCount' => Array ('type' => 'string', 'default' => ''),

	'ListingTypeId' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %1$s FROM '.TABLE_PREFIX.'ListingTypes ORDER BY Name', 'option_title_field' => 'Name', 'option_key_field' => 'ListingTypeId', 'default' => 0),

	'MoreCategories' => Array ('type' => 'string', 'default' => ''),

	// export related fields: begin
	'CategoryId' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => 0),
	- 'ExportFormat' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'CSV', /2 => 'XML'/), 'default' => 1),
	- 'ExportFilename' => Array('type' => 'string', 'default' => ''),
	- 'FieldsSeparatedBy' => Array('type' => 'string', 'default' => ','),
	- 'FieldsEnclosedBy' => Array('type' => 'string', 'default' => '"'),
	- 'LineEndings' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'Windows', 2 => 'UNIX'), 'default' => 1),
	- 'LineEndingsInside' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'CRLF', 2 => 'LF'), 'default' => 2),
	- 'IncludeFieldTitles' => Array('type' => 'int', 'default' => 1),
	- 'ExportColumns' => Array('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array()),
	- 'AvailableColumns' => Array('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array()),
	- 'CategoryFormat' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_MixedCategoryPath', 2 => 'la_SeparatedCategoryPath'), 'use_phrases' => 1, 'default' => 1),
	- 'CategorySeparator' => Array('type' => 'string', 'error_field' => 'CategoryFormat', 'default' => ':'),
	- 'IsBaseCategory' => Array('type' => 'int', 'default' => 0),
	+ 'ExportFormat' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'CSV', /2 => 'XML'/), 'default' => 1),
	+ 'ExportFilename' => Array ('type' => 'string', 'default' => ''),
	+ 'FieldsSeparatedBy' => Array ('type' => 'string', 'default' => ', '),
	+ 'FieldsEnclosedBy' => Array ('type' => 'string', 'default' => '"'),
	+ 'LineEndings' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'Windows', 2 => 'UNIX'), 'default' => 1),
	+ 'LineEndingsInside' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'CRLF', 2 => 'LF'), 'default' => 2),
	+ 'IncludeFieldTitles' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
	+ 'use_phrases' => 1, 'not_null' => 1, 'default' => 1,
	+ ),
	+ 'ExportColumns' => Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array ()),
	+ 'AvailableColumns' => Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array ()),
	+ 'CategoryFormat' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_MixedCategoryPath', 2 => 'la_SeparatedCategoryPath'), 'use_phrases' => 1, 'default' => 1),
	+ 'CategorySeparator' => Array ('type' => 'string', 'error_field' => 'CategoryFormat', 'default' => ':'),
	+ 'IsBaseCategory' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
	+ 'use_phrases' => 1, 'not_null' => 1, 'default' => 0,
	+ ),
	// export related fields: end

	// import related fields: begin
	- 'FieldTitles' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_Automatic', 2 => 'la_Manual'), 'use_phrases' => 1, 'default' => 1),
	- 'ImportSource' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_Upload', 2 => 'la_Local'), 'use_phrases' => 1, 'default' => 2),
	- 'ImportFilename' => Array('type' => 'string', 'formatter' => 'kUploadFormatter', 'max_size' => MAX_UPLOAD_SIZE, 'upload_dir' => (defined('EXPORT_BASE_PATH') ? EXPORT_BASE_PATH : '/system/export') . '/'),
	- 'ImportLocalFilename' => Array('type' => 'string', 'formatter' => 'kOptionsFormatter', 'default' => ''),
	- 'CheckDuplicatesMethod' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_IDField', 2 => 'la_OtherFields'), 'use_phrases' => 1, 'default' => 1),
	- 'ReplaceDuplicates' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1, 'default' => 0),
	- 'DuplicateCheckFields' => Array('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array('Name' => 'NAME', 'Url' => 'URL'), 'default' => '\|Name\|Url\|'),
	- 'SkipFirstRow' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array(1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 1),
	+ 'FieldTitles' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Automatic', 2 => 'la_Manual'), 'use_phrases' => 1, 'default' => 1),
	+ 'ImportSource' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Upload', 2 => 'la_Local'), 'use_phrases' => 1, 'default' => 2),
	+ 'ImportFilename' => Array ('type' => 'string', 'formatter' => 'kUploadFormatter', 'max_size' => MAX_UPLOAD_SIZE, 'upload_dir' => (defined('EXPORT_BASE_PATH') ? EXPORT_BASE_PATH : '/system/export') . '/'),
	+ 'ImportLocalFilename' => Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'default' => ''),
	+ 'CheckDuplicatesMethod' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_IDField', 2 => 'la_OtherFields'), 'use_phrases' => 1, 'default' => 1),
	+ 'ReplaceDuplicates' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1, 'default' => 0),
	+ 'DuplicateCheckFields' => Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array ('Name' => 'NAME', 'Url' => 'URL'), 'default' => '\|Name\|Url\|'),
	+ 'SkipFirstRow' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 1),
	// import related fields: end

	- 'ThumbnailImage' => Array('type' => 'string', 'default' => ''),
	- 'FullImage' => Array('type' => 'string', 'default' => ''),
	- 'ImageAlt' => Array('type' => 'string', 'default' => ''),
	-
	- 'Filename' => Array('type' => 'string','not_null' => 1,'default' => ''),
	- 'CachedNavbar' => Array('type' => 'string', 'default' => ''),
	- 'ParentPath' => Array('type' => 'string', 'default' => ''),
	+ 'ThumbnailImage' => Array ('type' => 'string', 'default' => ''),
	+ 'FullImage' => Array ('type' => 'string', 'default' => ''),
	+ 'ImageAlt' => Array ('type' => 'string', 'default' => ''),
	+
	+ 'Filename' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
	+ 'CachedNavbar' => Array ('type' => 'string', 'default' => ''),
	+ 'ParentPath' => Array ('type' => 'string', 'default' => ''),

	// for primary image
	- 'SameImages' => Array('type' => 'string', 'default' => ''),
	- 'LocalThumb' => Array('type' => 'string', 'default' => ''),
	- 'ThumbPath' => Array('type' => 'string', 'default' => ''),
	- 'ThumbUrl' => Array('type' => 'string', 'default' => ''),
	- 'LocalImage' => Array('type' => 'string', 'default' => ''),
	- 'LocalPath' => Array('type' => 'string', 'default' => ''),
	- 'FullUrl' => Array('type' => 'string', 'default' => ''),
	+ 'AltName' => Array ('type' => 'string', 'default' => ''),
	+ 'SameImages' => Array ('type' => 'string', 'default' => ''),
	+ 'LocalThumb' => Array ('type' => 'string', 'default' => ''),
	+ 'ThumbPath' => Array ('type' => 'string', 'default' => ''),
	+ 'ThumbUrl' => Array ('type' => 'string', 'default' => ''),
	+ 'LocalImage' => Array ('type' => 'string', 'default' => ''),
	+ 'LocalPath' => Array ('type' => 'string', 'default' => ''),
	+ 'FullUrl' => Array ('type' => 'string', 'default' => ''),
	),

	'Grids' => Array (
	'Default' => Array (
	'Icons' => Array (
	0 => 'icon16_link_disabled.png',
	1 => 'icon16_link.png',
	2 => 'icon16_link_pending.png',
	'NEW' => 'icon16_link_new.png',
	),
	'Fields' => Array (
	- 'LinkId' => Array ('title'=>'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	- 'Name' => Array ('title'=>'la_col_LinkName', 'data_block' => 'grid_catitem_td', 'width' => 200, ),
	+ 'LinkId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	+ 'Name' => Array ('title' => 'la_col_LinkName', 'data_block' => 'grid_catitem_td', 'width' => 200, ),
	'Url' => Array ('title' => 'la_col_LinkUrl', 'width' => 200, ),
	'Description' => Array ('title' => 'la_col_Description', 'first_chars' => 100, 'width' => 100, ),
	'CreatedOn' => Array ('title' => 'la_col_CreatedOn', 'filter_block' => 'grid_date_range_filter', 'width' => 145, ),
	'Modified' => Array ('title' => 'la_col_Modified', 'filter_block' => 'grid_date_range_filter', 'width' => 145, ),
	- 'Status' => Array('title' => 'la_col_Status', 'filter_block' => 'grid_options_filter', 'width' => 70, ),
	+ 'Status' => Array ('title' => 'la_col_Status', 'filter_block' => 'grid_options_filter', 'width' => 70, ),
	'Hits' => Array ('title' => 'la_col_Hits', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	'CachedRating' => Array ('title' => 'la_col_Rating', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	'CachedVotesQty' => Array ('title' => 'la_col_VoteCount', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	'CachedReviewsQty' => Array ('title' => 'la_col_ReviewCount', 'filter_block' => 'grid_range_filter', 'width' => 85, ),
	),
	),

	'Radio' => Array (
	'Icons' => Array (
	0 => 'icon16_link_disabled.png',
	1 => 'icon16_link.png',
	2 => 'icon16_link_pending.png',
	'NEW' => 'icon16_link_new.png',
	),
	'Selector' => 'radio',
	'Fields' => Array (
	- 'LinkId' => Array ('title'=>'la_col_Id', 'data_block' => 'grid_radio_td', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	- 'Name' => Array ('title'=>'la_col_LinkName', 'data_block' => 'grid_catitem_td', 'width' => 200, ),
	+ 'LinkId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_radio_td', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	+ 'Name' => Array ('title' => 'la_col_LinkName', 'data_block' => 'grid_catitem_td', 'width' => 200, ),
	'Url' => Array ('title' => 'la_col_LinkUrl', 'width' => 200, ),
	'Description' => Array ('title' => 'la_col_Description', 'first_chars' => 100, 'width' => 100, ),
	'CreatedOn' => Array ('title' => 'la_col_CreatedOn', 'filter_block' => 'grid_date_range_filter', 'width' => 145, ),
	'Modified' => Array ('title' => 'la_col_Modified', 'filter_block' => 'grid_date_range_filter', 'width' => 145, ),
	- 'Status' => Array('title' => 'la_col_Status', 'filter_block' => 'grid_options_filter', 'width' => 70, ),
	+ 'Status' => Array ('title' => 'la_col_Status', 'filter_block' => 'grid_options_filter', 'width' => 70, ),
	'Hits' => Array ('title' => 'la_col_Hits', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	'CachedRating' => Array ('title' => 'la_col_Rating', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	'CachedVotesQty' => Array ('title' => 'la_col_VoteCount', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
	'CachedReviewsQty' => Array ('title' => 'la_col_ReviewCount', 'filter_block' => 'grid_range_filter', 'width' => 85, ),
	),
	),

	'Duplicates' => Array (
	'Icons' => Array (
	0 => 'icon16_link_disabled.png',
	1 => 'icon16_link.png',
	2 => 'icon16_link_pending.png',
	'NEW' => 'icon16_link_new.png',
	),

	'Fields' => Array (
	'Name' => Array ('title' => 'la_col_LinkName', 'filter_block' => 'grid_like_filter', 'width' => 250, ),
	'Url' => Array ('title' => 'la_col_LinkUrl', 'filter_block' => 'grid_like_filter', 'width' => 300, ),
	'DupeCount' => Array ('title' => 'la_col_DupeCount', 'filter_block' => 'grid_range_filter', 'width' => 100, ),
	),
	),
	),


	- 'ConfigMapping' => Array(
	+ 'ConfigMapping' => Array (
	'PerPage' => 'Perpage_Links',
	'ShortListPerPage' => 'Perpage_Links_Short',
	'ForceEditorPick' => 'Link_ShowPick',
	'DefaultSorting1Field' => 'Link_SortField',
	'DefaultSorting2Field' => 'Link_SortField2',
	'DefaultSorting1Dir' => 'Link_SortOrder',
	'DefaultSorting2Dir' => 'Link_SortOrder2',

	'RatingDelayValue' => 'link_RatingDelay_Value',
	'RatingDelayInterval' => 'link_RatingDelay_Interval',

	),
	);
	\ No newline at end of file
	Index: branches/5.1.x/units/listings/listings_config.php
	===================================================================
	--- branches/5.1.x/units/listings/listings_config.php (revision 13549)
	+++ branches/5.1.x/units/listings/listings_config.php (revision 13550)
	@@ -1,167 +1,188 @@
	<?php
	/**
	* @version $Id$
	* @package In-Link
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	- $config = Array(
	+ $config = Array (
	'Prefix' => 'ls',
	- 'ItemClass' => Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'),
	- 'ListClass' => Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
	- 'EventHandlerClass' => Array('class'=>'ListingsEventHandler','file'=>'listings_event_handler.php','build_event'=>'OnBuild'),
	- 'TagProcessorClass' => Array('class'=>'ListingsTagProcessor','file'=>'listings_tag_processor.php','build_event'=>'OnBuild'),
	+ 'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	+ 'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	+ 'EventHandlerClass' => Array ('class' => 'ListingsEventHandler', 'file' => 'listings_event_handler.php', 'build_event' => 'OnBuild'),
	+ 'TagProcessorClass' => Array ('class' => 'ListingsTagProcessor', 'file' => 'listings_tag_processor.php', 'build_event' => 'OnBuild'),
	'AutoLoad' => true,

	- 'Hooks' => Array(
	- Array(
	+ 'Hooks' => Array (
	+ Array (
	'Mode' => hAFTER,
	'Conditional' => false,
	'HookToPrefix' => 'l',
	'HookToSpecial' => '*',
	- 'HookToEvent' => Array('OnBeforeDeleteOriginal'),
	+ 'HookToEvent' => Array ('OnBeforeDeleteOriginal'),
	'DoPrefix' => '',
	'DoSpecial' => '*',
	'DoEvent' => 'OnMoveEnhancement',
	),
	),

	- 'QueryString' => Array(
	+ 'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	5 => 'mode',
	),

	- 'RegularEvents' => Array(
	- 'listings_expiration' => Array('EventName' => 'OnCheckExpiredPaidListings', 'RunInterval' => 1800, 'Type' => reAFTER),
	+ 'RegularEvents' => Array (
	+ 'listings_expiration' => Array ('EventName' => 'OnCheckExpiredPaidListings', 'RunInterval' => 1800, 'Type' => reAFTER),
	),

	'IDField' => 'ListingId',
	- 'StatusField' => Array('Status', 'PendingRenewal'),
	+ 'StatusField' => Array ('Status', 'PendingRenewal'),
	'TitleField' => 'LinkName',

	- 'TitlePresets' => Array(
	- 'default' => Array( 'new_status_labels' => Array('ls'=>'!la_title_AddingListing!'),
	- 'edit_status_labels' => Array('ls'=>'!la_title_EditingListing!'),
	- 'new_titlefield' => Array('ls'=>'!la_title_NewListing!'),
	+ 'TitlePresets' => Array (
	+ 'default' => Array ( 'new_status_labels' => Array ('ls' => '!la_title_AddingListing!'),
	+ 'edit_status_labels' => Array ('ls' => '!la_title_EditingListing!'),
	+ 'new_titlefield' => Array ('ls' => '!la_title_NewListing!'),
	),

	- 'listing_list' => Array('prefixes' => Array('ls_List'), 'format' => "!la_title_PaidListings!",),
	- 'listing_edit' => Array('prefixes' => Array('ls'), 'format' => "#ls_status# '#ls_titlefield#' - !la_title_General!",),
	+ 'listing_list' => Array ('prefixes' => Array ('ls_List'), 'format' => "!la_title_PaidListings!",),
	+ 'listing_edit' => Array ('prefixes' => Array ('ls'), 'format' => "#ls_status# '#ls_titlefield#' - !la_title_General!",),
	),

	- 'PermSection' => Array('main' => 'in-link:paid_listings'),
	+ 'PermSection' => Array ('main' => 'in-link:paid_listings'),

	- 'Sections' => Array(
	- 'in-link:paid_listings_folder' => Array(
	+ 'Sections' => Array (
	+ 'in-link:paid_listings_folder' => Array (
	'parent' => 'in-link',
	'icon' => 'paid_listings',
	'label' => 'la_tab_PaidListings',
	'use_parent_header' => 1,
	- 'permissions' => Array(),
	+ 'permissions' => Array (),
	'priority' => 1,
	'type' => stTREE,
	),

	- 'in-link:paid_listings' => Array(
	+ 'in-link:paid_listings' => Array (
	'parent' => 'in-link:paid_listings_folder',
	'icon' => 'paid_listings',
	'label' => 'la_tab_Listings',
	- 'url' => Array('t' => 'in-link/paid_listings/paid_listings_list', 'pass' => 'm'),
	- 'permissions' => Array('view', 'add', 'edit', 'delete', 'advanced:approve', 'advanced:decline'),
	+ 'url' => Array ('t' => 'in-link/paid_listings/paid_listings_list', 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'add', 'edit', 'delete', 'advanced:approve', 'advanced:decline'),
	'priority' => 1.1, // <parent_priority>.<own_priority>, because this section replaces parent in tree
	'type' => stTAB,
	),
	),

	'TableName' => TABLE_PREFIX.'Listings',

	- 'ListSQLs' => Array( ''=>' SELECT %1$s.* %2$s
	+ 'ListSQLs' => Array ( '' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'Link item_table ON item_table.ResourceId = %1$s.ItemResourceId
	LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON u.PortalUserId = item_table.CreatedById'),

	- 'ItemSQLs' => Array( ''=>' SELECT %1$s.* %2$s
	+ 'ItemSQLs' => Array ( '' => ' SELECT %1$s.* %2$s
	FROM %1$s
	LEFT JOIN '.TABLE_PREFIX.'Link item_table ON item_table.ResourceId = %1$s.ItemResourceId
	LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON u.PortalUserId = item_table.CreatedById'),

	- 'ListSortings' => Array(
	- '' => Array(
	- 'Sorting' => Array('PurchasedOn' => 'desc'),
	+ 'ListSortings' => Array (
	+ '' => Array (
	+ 'Sorting' => Array ('PurchasedOn' => 'desc'),
	)
	),

	'CalculatedFields' => Array (
	'' => Array (
	'LinkName' => 'CONCAT(item_table.Name, " (", item_table.Url, ")")',
	'LinkOwner' => 'IF (ISNULL(u.Login), IF (item_table.CreatedById = -1, "root", IF (item_table.CreatedById = -2, "Guest", "n/a")), u.Login)',
	),
	),
	- 'Fields' => Array
	- (
	- 'ListingId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0,),
	- 'ListingTypeId' => Array('type' => 'int', 'formatter'=>'kOptionsFormatter', 'options_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'ListingTypes ORDER BY Name', 'option_key_field'=>'ListingTypeId', 'option_title_field'=>'Name', 'default' => 0,),
	- 'ItemResourceId' => Array('type' => 'int', 'required' => 1, 'unique' => Array('ItemResourceId'), 'error_field' => 'LinkName', 'default' => NULL),
	- 'PurchasedOn' => Array('type' => 'int', 'formatter'=>'kDateFormatter','default'=>'#NOW#'),
	- 'ExpiresOn' => Array('type' => 'int', 'formatter'=>'kDateFormatter','default' => '#NOW#','required'=>1),
	- 'Status' => Array('type' => 'int', 'not_null' => 1, 'default' => 2, 'formatter'=>'kOptionsFormatter','options' => Array(1 => 'la_Active', 2 => 'la_Pending', 0 => 'la_Disabled'),'use_phrases' => 1),
	- 'PendingRenewal' => Array('type' => 'int','formatter'=>'kOptionsFormatter','options' => Array(0 => 'la_NotPendingRenewal', 1 => 'la_PendingRenewal'),'use_phrases' => 1, 'not_null' => 1, 'default' => 0),
	- 'RenewalReminderSent' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	- ),
	+ 'Fields' => Array (
	+ 'ListingId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0,),
	+ 'ListingTypeId' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options_sql' => 'SELECT %s
	+ FROM '.TABLE_PREFIX.'ListingTypes
	+ ORDER BY Name',
	+ 'option_key_field' => 'ListingTypeId', 'option_title_field' => 'Name',
	+ 'default' => 0,
	+ ),
	+ 'ItemResourceId' => Array (
	+ 'type' => 'int',
	+ 'required' => 1, 'unique' => Array ('ItemResourceId'), 'default' => null,
	+ 'error_field' => 'LinkName',
	+ ),
	+ 'PurchasedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
	+ 'ExpiresOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#', 'required' =>1),
	+ 'Status' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (1 => 'la_Active', 2 => 'la_Pending', 0 => 'la_Disabled'), 'use_phrases' => 1,
	+ 'not_null' => 1, 'default' => 2,
	+ ),
	+ 'PendingRenewal' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (0 => 'la_NotPendingRenewal', 1 => 'la_PendingRenewal'), 'use_phrases' => 1,
	+ 'not_null' => 1, 'default' => 0,
	+ ),
	+ 'RenewalReminderSent' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ ),

	'VirtualFields' => Array (
	- 'LinkName' => Array ('type' => 'string'),
	- 'LinkOwner' => Array ('type' => 'string'),
	- ),
	+ 'LinkName' => Array ('type' => 'string'),
	+ 'LinkOwner' => Array ('type' => 'string'),
	+ ),

	- 'FilterMenu' => Array(
	- 'Groups' => Array(
	- Array('mode' => 'AND', 'filters' => Array(0,1,2), 'type' => WHERE_FILTER),
	- Array('mode' => 'AND', 'filters' => Array(3), 'type' => WHERE_FILTER),
	+ 'FilterMenu' => Array (
	+ 'Groups' => Array (
	+ Array ('mode' => 'AND', 'filters' => Array (0,1,2), 'type' => WHERE_FILTER),
	+ Array ('mode' => 'AND', 'filters' => Array (3), 'type' => WHERE_FILTER),
	),

	- 'Filters' => Array(
	- 0 => Array('label' =>'la_Enabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ),
	- 1 => Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ),
	- 2 => Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ),
	- 3 => Array('label' => 'la_PendingRenewal', 'on_sql' => '', 'off_sql' => '%1$s.PendingRenewal != 1' ),
	+ 'Filters' => Array (
	+ 0 => Array ('label' => 'la_Enabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ),
	+ 1 => Array ('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ),
	+ 2 => Array ('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ),
	+ 3 => Array ('label' => 'la_PendingRenewal', 'on_sql' => '', 'off_sql' => '%1$s.PendingRenewal != 1' ),
	)
	),

	- 'Grids' => Array(
	- 'Default' => Array(
	- 'Icons' => Array(
	+ 'Grids' => Array (
	+ 'Default' => Array (
	+ 'Icons' => Array (
	'default' => 'icon16_item.png',
	'1_0' => 'icon16_link.png',
	'0_0' => 'icon16_link_disabled.png',
	'2_0' => 'icon16_link_pending.png',
	'1_1' => 'icon16_link_pending.png',
	'0_1' => 'icon16_link_disabled.png',
	'2_1' => 'icon16_link_pending.png'),
	'module' => 'core',

	- 'Fields' => Array(
	- 'ListingId' => Array( 'title'=>'la_col_Id' , 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	- 'LinkName' => Array( 'title'=>'la_col_LinkName' , 'data_block' => 'link_td', 'filter_block' => 'grid_like_filter', 'width' => 170, ),
	- 'ListingTypeId' => Array( 'title'=>'la_col_ListingTypeName' , 'data_block' => 'listing_type_td', 'filter_block' => 'grid_like_filter', 'width' => 100, ),
	- 'LinkOwner' => Array( 'title'=>'la_col_LinkOwner', 'filter_block' => 'grid_like_filter', 'width' => 115, ),
	- 'PendingRenewal' => Array( 'title'=>'la_col_PendingRenewal', 'filter_block' => 'grid_options_filter', 'width' => 143, ),
	- 'PurchasedOn' => Array( 'title'=>'la_col_PurchasedOn', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
	- 'ExpiresOn' => Array( 'title'=>'la_col_ExpiresOn', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
	+ 'Fields' => Array (
	+ 'ListingId' => Array ( 'title' => 'la_col_Id' , 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60, ),
	+ 'LinkName' => Array ( 'title' => 'la_col_LinkName' , 'data_block' => 'link_td', 'filter_block' => 'grid_like_filter', 'width' => 170, ),
	+ 'ListingTypeId' => Array ( 'title' => 'la_col_ListingTypeName' , 'data_block' => 'listing_type_td', 'filter_block' => 'grid_like_filter', 'width' => 100, ),
	+ 'LinkOwner' => Array ( 'title' => 'la_col_LinkOwner', 'filter_block' => 'grid_like_filter', 'width' => 115, ),
	+ 'PendingRenewal' => Array ( 'title' => 'la_col_PendingRenewal', 'filter_block' => 'grid_options_filter', 'width' => 143, ),
	+ 'PurchasedOn' => Array ( 'title' => 'la_col_PurchasedOn', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
	+ 'ExpiresOn' => Array ( 'title' => 'la_col_ExpiresOn', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
	),
	),
	),

	);
	\ No newline at end of file
	Index: branches/5.1.x/units/listing_types/listing_types_config.php
	===================================================================
	--- branches/5.1.x/units/listing_types/listing_types_config.php (revision 13549)
	+++ branches/5.1.x/units/listing_types/listing_types_config.php (revision 13550)
	@@ -1,153 +1,162 @@
	<?php
	/**
	* @version $Id$
	* @package In-Link
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	- $config = Array(
	+ $config = Array (
	'Prefix' => 'lst',
	- 'ItemClass' => Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'),
	- 'ListClass' => Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
	- 'EventHandlerClass' => Array('class'=>'ListingTypesEventHandler','file'=>'listing_types_event_handler.php','build_event'=>'OnBuild'),
	- 'TagProcessorClass' => Array('class'=>'ListingTypesTagProcessor','file'=>'listing_types_tag_processor.php','build_event'=>'OnBuild'),
	+ 'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	+ 'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	+ 'EventHandlerClass' => Array ('class' => 'ListingTypesEventHandler', 'file' => 'listing_types_event_handler.php', 'build_event' => 'OnBuild'),
	+ 'TagProcessorClass' => Array ('class' => 'ListingTypesTagProcessor', 'file' => 'listing_types_tag_processor.php', 'build_event' => 'OnBuild'),
	'AutoLoad' => true,
	- 'AggregateTags' => Array(
	- Array(
	+ 'AggregateTags' => Array (
	+ Array (
	'AggregateTo' => 'l',
	'AggregatedTagName' => 'ListListingTypes',
	'LocalTagName' => 'PrintList',
	),
	- Array(
	+ Array (
	'AggregateTo' => 'l',
	'AggregatedTagName' => 'ListingTypeField',
	'LocalTagName' => 'Field',
	),
	),
	- 'Hooks' => Array(),
	- 'QueryString' => Array(
	+ 'Hooks' => Array (),
	+ 'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	5 => 'mode',
	),
	'IDField' => 'ListingTypeId',
	'TitleField' => 'Name',
	- 'TitlePresets' => Array(
	- 'default' => Array( 'new_status_labels' => Array('lst'=>'!la_title_AddingPaidListingType!'),
	- 'edit_status_labels' => Array('lst'=>'!la_title_EditingPaidListingType!'),
	- 'new_titlefield' => Array('lst'=>'!la_title_NewPaidListingType!'),
	+ 'TitlePresets' => Array (
	+ 'default' => Array ( 'new_status_labels' => Array ('lst' => '!la_title_AddingPaidListingType!'),
	+ 'edit_status_labels' => Array ('lst' => '!la_title_EditingPaidListingType!'),
	+ 'new_titlefield' => Array ('lst' => '!la_title_NewPaidListingType!'),
	),
	- 'listing_type_list'=>Array( 'prefixes' => Array('lst_List'),
	+ 'listing_type_list' =>Array ( 'prefixes' => Array ('lst_List'),
	'format' => "!la_title_PaidListingTypes!",
	),
	- 'listing_type_edit'=>Array( 'prefixes' => Array('lst'),
	- 'new_titlefield' => Array('lst'=>'!la_title_NewPaidListingType!'),
	+ 'listing_type_edit' =>Array ( 'prefixes' => Array ('lst'),
	+ 'new_titlefield' => Array ('lst' => '!la_title_NewPaidListingType!'),
	'format' => "#lst_status# '#lst_titlefield#' - !la_title_General!",
	),
	- 'listing_type_shop_cart'=>Array( 'prefixes' => Array('lst'),
	- 'new_titlefield' => Array('lst'=>'!la_title_NewPaidListingType!'),
	+ 'listing_type_shop_cart' =>Array ( 'prefixes' => Array ('lst'),
	+ 'new_titlefield' => Array ('lst' => '!la_title_NewPaidListingType!'),
	'format' => "#lst_status# '#lst_titlefield#' - !la_title_ShopCartEntry!",
	),


	),

	'EditTabPresets' => Array (
	'Default' => Array (
	'general' => Array ('title' => 'la_tab_General', 't' => 'in-link/paid_listings/paid_listing_type_edit', 'priority' => 1),
	),
	),

	- 'PermSection' => Array('main' => 'in-link:listing_types'),
	+ 'PermSection' => Array ('main' => 'in-link:listing_types'),

	- 'Sections' => Array(
	- 'in-link:listing_types' => Array(
	+ 'Sections' => Array (
	+ 'in-link:listing_types' => Array (
	'parent' => 'in-link:paid_listings_folder',
	'icon' => 'paid_listings',
	'label' => 'la_tab_ListingTypes',
	- 'url' => Array('t' => 'in-link/paid_listings/paid_listing_types_list', 'pass' => 'm'),
	- 'permissions' => Array('view', 'add', 'edit', 'delete'),
	+ 'url' => Array ('t' => 'in-link/paid_listings/paid_listing_types_list', 'pass' => 'm'),
	+ 'permissions' => Array ('view', 'add', 'edit', 'delete'),
	'priority' => 1.2, // <parent_priority>.<own_priority>, because this section replaces parent in tree
	'type' => stTAB,
	),
	),

	'TableName' => TABLE_PREFIX.'ListingTypes',

	- 'ListSQLs' => Array( ''=>'SELECT * FROM %s',), // key - special, value - list select sql
	+ 'ListSQLs' => Array ( '' => 'SELECT * FROM %s',), // key - special, value - list select sql

	- 'ItemSQLs' => Array( ''=>'SELECT * FROM %s',),
	+ 'ItemSQLs' => Array ( '' => 'SELECT * FROM %s',),

	- 'ListSortings' => Array(
	- '' => Array(
	- 'Sorting' => Array('ListingTypeId' => 'asc'),
	+ 'ListSortings' => Array (
	+ '' => Array (
	+ 'Sorting' => Array ('ListingTypeId' => 'asc'),
	)
	),

	- 'Fields' => Array
	- (
	- 'ListingTypeId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0,),
	- 'Name' => Array('type' => 'string','not_null' => '1','default' => '','required' => '1'),
	- 'Description' => Array('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL),
	- 'Duration' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	- 'DurationType' => Array('type' => 'int', 'not_null' => 1, 'default' => 0, 'formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(1 => 'la_opt_sec', 2 => 'la_opt_min', 3 => 'la_opt_hour', 4 => 'la_opt_day', 5 => 'la_opt_week', 6 => 'la_opt_month', 7 => 'la_opt_year')),
	- 'OnPurchaseEdPick' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off'), 'default' => 3),
	-
	- 'OnPurchaseStatus' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_Enabled', 0 => 'la_Disabled', 2 => 'la_Pending'),'default' => 3),
	-
	- 'OnPurchaseNew' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnPurchasePop' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnPurchaseHot' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnPurchasePriorityAction' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(0 => 'la_DontChange', 1 => 'la_SetEqualTo', 2 => 'la_IncreaseBy', 3 => 'la_DecreaseBy'),'default' => 0),
	- 'OnPurchasePriorityValue' => Array('type' => 'int','not_null' => '1','default' => 1),
	- 'OnPurchaseAddToCatEnabled' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'OnPurchaseAddToCat' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'OnPurchaseCustomTemplate' => Array('type' => 'string','not_null' => 1,'default' => ''),
	-
	- 'OnExpireEdPick' => Array('type' => 'int','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off'),'not_null' => '1','default' => 3),
	- 'OnExpireNew' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnExpirePop' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnExpireHot' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'),'default' => 3),
	- 'OnExpirePriorityAction' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(0 => 'la_DontChange', 1 => 'la_SetEqualTo', 2 => 'la_IncreaseBy', 3 => 'la_DecreaseBy'),'default' => 0),
	- 'OnExpirePriorityValue' => Array('type' => 'int','not_null' => '1','default' => 1),
	- 'OnExpireRemoveFromCatEnabled' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'OnExpireRemoveFromCat' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'OnExpireCustomTemplate' => Array('type' => 'string','not_null' => 1,'default' => ''),
	-
	- 'OnExpireStatus' => Array('type' => 'int','not_null' => '1','formatter'=>'kOptionsFormatter','use_phrases' => 1,'options' => Array(3 => 'la_Unchanged', 1 => 'la_Enabled', 0 => 'la_Disabled', 2 => 'la_Pending'),'default' => 3),
	- 'RenewalReminder' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'EnableBuying' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'ShopCartName' => Array('type' => 'string', 'default' => null),
	- 'Price' => Array('type' => 'double','default' => ''),
	- 'Recurring' => Array('type' => 'int','not_null' => '1','default' => 0),
	- 'VirtualProductId' => Array('type' => 'int','not_null' => '1','default' => 0),
	+ 'Fields' => Array (
	+ 'ListingTypeId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0,),
	+ 'Name' => Array ('type' => 'string', 'not_null' => 1, 'default' => '', 'required' => '1'),
	+ 'Description' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL),
	+ 'Duration' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'DurationType' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (1 => 'la_opt_sec', 2 => 'la_opt_min', 3 => 'la_opt_hour', 4 => 'la_opt_day', 5 => 'la_opt_week', 6 => 'la_opt_month', 7 => 'la_opt_year')),
	+ 'OnPurchaseEdPick' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off'), 'default' => 3),
	+
	+ 'OnPurchaseStatus' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_Enabled', 0 => 'la_Disabled', 2 => 'la_Pending'), 'default' => 3),
	+
	+ 'OnPurchaseNew' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnPurchasePop' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnPurchaseHot' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnPurchasePriorityAction' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (0 => 'la_DontChange', 1 => 'la_SetEqualTo', 2 => 'la_IncreaseBy', 3 => 'la_DecreaseBy'), 'default' => 0),
	+ 'OnPurchasePriorityValue' => Array ('type' => 'int', 'not_null' => 1, 'default' => 1),
	+ 'OnPurchaseAddToCatEnabled' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'OnPurchaseAddToCat' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'OnPurchaseCustomTemplate' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
	+
	+ 'OnExpireEdPick' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off'), 'not_null' => 1, 'default' => 3),
	+ 'OnExpireNew' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnExpirePop' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnExpireHot' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_On', 0 => 'la_Off', 2 => 'la_Auto'), 'default' => 3),
	+ 'OnExpirePriorityAction' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (0 => 'la_DontChange', 1 => 'la_SetEqualTo', 2 => 'la_IncreaseBy', 3 => 'la_DecreaseBy'), 'default' => 0),
	+ 'OnExpirePriorityValue' => Array ('type' => 'int', 'not_null' => 1, 'default' => 1),
	+ 'OnExpireRemoveFromCatEnabled' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'OnExpireRemoveFromCat' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'OnExpireCustomTemplate' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
	+
	+ 'OnExpireStatus' => Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' => Array (3 => 'la_Unchanged', 1 => 'la_Enabled', 0 => 'la_Disabled', 2 => 'la_Pending'), 'default' => 3),
	+ 'RenewalReminder' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	+ 'EnableBuying' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (0 => 'la_No', 1 => 'la_Yes',), 'use_phrases' => 1,
	+ 'default' => 1, 'not_null' => 1,
	+ ),
	+ 'ShopCartName' => Array ('type' => 'string', 'default' => null),
	+ 'Price' => Array ('type' => 'double', 'default' => ''),
	+ 'Recurring' => Array (
	+ 'type' => 'int',
	+ 'formatter' => 'kOptionsFormatter',
	+ 'options' => Array (0 => 'la_No', 1 => 'la_Yes',), 'use_phrases' => 1,
	+ 'default' => 0, 'not_null' => 1,
	+ ),
	+ 'VirtualProductId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	),

	- 'Grids' => Array(
	- 'Default' => Array(
	- 'Icons' => Array(
	+ 'Grids' => Array (
	+ 'Default' => Array (
	+ 'Icons' => Array (
	'default' => 'icon16_item.png',
	0 => 'icon16_disbaled.png',
	1 => 'icon16_item.png',
	'module' => 'core',
	),
	- 'Fields' => Array(
	- 'ListingTypeId' => Array( 'title'=>'la_col_Id' , 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60),
	- 'Name' => Array( 'title'=>'la_col_Name', 'filter_block' => 'grid_like_filter', 'width' => 250),
	- 'Duration' => Array( 'title'=>'la_col_Duration' , 'data_block' => 'duration_td', 'filter_block' => 'grid_like_filter', 'width' => 100),
	+ 'Fields' => Array (
	+ 'ListingTypeId' => Array ( 'title' => 'la_col_Id' , 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60),
	+ 'Name' => Array ( 'title' => 'la_col_Name', 'filter_block' => 'grid_like_filter', 'width' => 250),
	+ 'Duration' => Array ( 'title' => 'la_col_Duration' , 'data_block' => 'duration_td', 'filter_block' => 'grid_like_filter', 'width' => 100),
	),

	),
	),
	);
	\ No newline at end of file
	Index: branches/5.1.x/admin_templates/link_validation/link_validation_list.tpl
	===================================================================
	--- branches/5.1.x/admin_templates/link_validation/link_validation_list.tpl (revision 13549)
	+++ branches/5.1.x/admin_templates/link_validation/link_validation_list.tpl (revision 13550)
	@@ -1,134 +1,134 @@
	<inp2:m_include t="incs/header"/>
	<inp2:m_RenderElement name="combined_header" section="in-link:link_validation" prefix="link-validation" title_preset="link_validation_list" pagination="1"/>

	<!-- ToolBar -->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	//do not rename - this function is used in default grid for double click!
	function edit()
	{
	std_edit_item('l', 'in-link/links/links_edit');
	}

	var a_toolbar = new ToolBar();

	a_toolbar.AddButton(
	new ToolBarButton(
	'in-link:validate_continue',
	'<inp2:m_phrase label="la_ToolTip_ContinueValidation" escape="1"/>::<inp2:m_phrase label="la_ShortToolTip_Continue" escape="1"/>',
	function() {
	Application.SetVar('progress_template', 'in-link/link_validation/link_validation_progress');
	submit_event('link-validation', 'OnContinueValidation');
	}
	)
	);

	a_toolbar.AddButton(
	new ToolBarButton(
	'in-link:validate_restart',
	'<inp2:m_phrase label="la_ToolTip_NewValidation" escape="1"/>::<inp2:m_phrase label="la_ShortToolTip_New" escape="1"/>',
	function() {
	Application.SetVar('progress_template', 'in-link/link_validation/link_validation_progress');
	submit_event('link-validation', 'OnRestartValidation');
	}
	)
	);

	a_toolbar.AddButton( new ToolBarSeparator('sep1') );

	a_toolbar.AddButton(
	new ToolBarButton(
	'in-link:validate',
	'<inp2:m_phrase label="la_ToolTip_ValidateSelected" escape="1"/>',
	function() {
	Application.SetVar('progress_template', 'in-link/link_validation/link_validation_progress');
	submit_event('link-validation', 'OnValidateSelected');
	}
	)
	);

	a_toolbar.AddButton(
	new ToolBarButton(
	'in-link:validate_reset',
	'<inp2:m_phrase label="la_ToolTip_ResetValidationStatus" escape="1"/>::<inp2:m_phrase label="la_ShortToolTip_ResetValidationStatus" escape="1"/>',
	function() {
	submit_event('link-validation', 'OnResetValidationStatus');
	}
	)
	);

	a_toolbar.AddButton( new ToolBarSeparator('sep2') );

	a_toolbar.AddButton( new ToolBarButton('edit', '<inp2:m_phrase label="la_ToolTip_Edit" escape="1"/>', edit) );

	a_toolbar.AddButton(
	new ToolBarButton(
	'delete',
	'<inp2:m_phrase label="la_ToolTip_Delete" escape="1"/>',
	function() {
	var phrase = phrases['la_Delete_Confirm'] ? phrases['la_Delete_Confirm'] : 'Are you sure you want to delete selected items?';
	if (inpConfirm(phrase)) {
	submit_event('link-validation', 'OnDeleteLinks');
	}
	}
	)
	);

	a_toolbar.AddButton( new ToolBarSeparator('sep3') );

	a_toolbar.AddButton(
	new ToolBarButton(
	'approve',
	'<inp2:m_phrase label="la_ToolTip_Approve" escape="1"/>',
	function() {
	submit_event('link-validation', 'OnApproveLinks');
	}
	)
	);

	a_toolbar.AddButton(
	new ToolBarButton(
	'decline',
	'<inp2:m_phrase label="la_ToolTip_Decline" escape="1"/>',
	function() {
	submit_event('link-validation', 'OnDeclineLinks');
	}
	)
	);

	a_toolbar.AddButton( new ToolBarSeparator('sep4') );

	a_toolbar.AddButton( new ToolBarButton('view', '<inp2:m_phrase label="la_ToolTip_View" escape="1"/>', function() {
	show_viewmenu(a_toolbar,'view');
	}
	) );

	a_toolbar.Render();
	</script>
	</td>
	<inp2:m_RenderElement name="search_main_toolbar" prefix="link-validation" grid="Default"/>
	</tr>
	</tbody>
	</table>

	<inp2:m_DefineElement name="grid_url_td" format="" nl2br="" first_chars="" td_style="" currency="">
	<a href="<inp2:FormatUrl field='$field'/>"><inp2:Field field='$field' first_chars="30"/></a>
	</inp2:m_DefineElement>

	<inp2:m_DefineElement name="grid_link_name_td" format="" nl2br="" first_chars="" td_style="" currency="">
	<inp2:Field field='$field' first_chars="$first_chars"/><br />
	<span class="small-statistics">
	<inp2:Field name="CategoryId" db="db" result_to_var="item_category"/>
	<inp2:m_Phrase name="la_fld_Category"/>: <a href="<inp2:m_Link template="catalog/catalog" m_cat_id="$item_category"/>"><inp2:CategoryName /></a>
	</span>
	</inp2:m_DefineElement>


	-<inp2:m_RenderElement name="grid" PrefixSpecial="link-validation" IdField="ForeignLinkId" grid="Default" menu_filters="yes" grid_filters="1"/>
	+<inp2:m_RenderElement name="grid" PrefixSpecial="link-validation" IdField="ForeignLinkId" grid="Default" menu_filters="yes"/>
	<script type="text/javascript">
	Grids['link-validation'].SetDependantToolbarButtons( new Array('validate', 'validate_reset', 'edit', 'approve', 'decline', 'delete') );
	</script>
	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file
	Index: branches/5.1.x/install/upgrades.sql
	===================================================================
	--- branches/5.1.x/install/upgrades.sql (revision 13549)
	+++ branches/5.1.x/install/upgrades.sql (revision 13550)
	@@ -1,76 +1,92 @@
	# ===== v 4.3.9 =====
	INSERT INTO Events VALUES (DEFAULT, 'LINK.VALIDATION.RESULTS', NULL, 1, 0, 'In-Link', 'la_event_link.validation.results', 1);

	INSERT INTO ImportScripts VALUES (DEFAULT, 'Links from CSV file [In-Link]', '', 'l', 'In-Link', '', 'CSV', '1');

	UPDATE CustomField
	SET ValueList = '=+\|\|<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 2 AND (DestParentId = 225 OR DestParentId = 38) ORDER BY DestParentId DESC, DestAbbr ASC</SQL>'
	WHERE FieldName = 'LinkState';

	UPDATE CustomField
	SET ValueList = '=+\|\|<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 1 ORDER BY DestAbbr ASC</SQL>'
	WHERE FieldName = 'LinkCountry';

	# ===== v 5.0.0 =====
	INSERT INTO Counters VALUES (DEFAULT, 'linkhits_count', 'SELECT ROUND(SUM(Hits)) FROM <%PREFIX%>Link', NULL, NULL, '300', '0', '\|Link\|');
	UPDATE Category SET Template = '/in-link/designs/section' WHERE Template = 'inlink/index';
	UPDATE Category SET CachedTemplate = '/in-link/designs/section' WHERE CachedTemplate = 'inlink/index';

	UPDATE ConfigurationValues SET VariableValue = '/in-link/designs/section' WHERE VariableName = 'l_CategoryTemplate';
	UPDATE ConfigurationValues SET VariableValue = 'in-link/designs/detail' WHERE VariableName = 'l_ItemTemplate';

	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:links.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:setting_folder.view', 11, 1, 1, 0);
	DELETE FROM Permissions WHERE Permission LIKE 'in-link:inlink_general.%';

	UPDATE Events SET Description = 'la_event_link.owner.modify' WHERE Description = 'la_event_link.modify.modify';
	UPDATE Events SET Description = 'la_event_link.owner.modify.pending' WHERE Description = 'la_event_link.modify.modify.pending';

	UPDATE Phrase SET Module = 'In-Link' WHERE ((Phrase LIKE '%Links%' OR Phrase LIKE '%Listing%') AND (Module = 'Core') AND Phrase NOT IN ('la_section_QuickLinks'));

	UPDATE Phrase SET Module = 'In-Link', PhraseType = 1 WHERE ( (Phrase LIKE '%Validation%' OR Phrase LIKE 'la_title_In-Link') AND (Module = 'Core') AND Phrase NOT IN ('la_ValidationEmail', 'la_prompt_validation'));

	# ===== v 5.0.1 =====
	UPDATE ConfigurationValues SET VariableValue = 'in-link/links/link_detail' WHERE VariableName = 'l_ItemTemplate';

	UPDATE ConfigurationAdmin SET ValueList = 'ReviewText=la_opt_CommentText,CreatedOn=la_opt_CreatedOn'
	WHERE VariableName IN ('Link_ReviewsSort', 'Link_ReviewsSort2');

	UPDATE ConfigurationAdmin SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
	WHERE VariableName IN ('Link_ReviewsOrder', 'Link_ReviewsOrder2');

	UPDATE ConfigurationAdmin SET ValueList = 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_opt_CreatedOn,Hits=la_Link_Hits,CachedRating=la_opt_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>'
	WHERE VariableName IN ('Link_SortField', 'Link_SortField2');

	UPDATE ConfigurationAdmin
	SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year'
	WHERE VariableName IN ('link_ReviewDelay_Interval', 'link_RatingDelay_Interval');

	UPDATE CustomField SET FieldLabel = 'la_fld_cust_l_ItemTemplate', Prompt = 'la_fld_cust_l_ItemTemplate' WHERE FieldName = 'l_ItemTemplate';

	INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.add.pending', 1);

	UPDATE ConfigurationAdmin SET ValueList = 'style="width: 50px;"' WHERE VariableName IN ('link_ReviewDelay_Value', 'link_RatingDelay_Value');

	# ===== v 5.0.2-B1 =====
	ALTER TABLE ListingTypes CHANGE Description Description text NULL;
	ALTER TABLE LinkValidation CHANGE ValidationTime ValidationTime INT NULL DEFAULT NULL;
	ALTER TABLE LinkVisits CHANGE VisitTimestamp VisitTimestamp INT(11) NULL DEFAULT NULL;

	# ===== v 5.0.2-B2 =====

	# ===== v 5.0.2-RC1 =====

	# ===== v 5.0.2 =====

	+# ===== v 5.0.3-B1 =====
	+UPDATE Phrase
	+SET Module = 'In-Link'
	+WHERE Phrase IN (
	+ 'lu_PermName_Link.Add.Pending_desc', 'lu_PermName_Link.Add_desc', 'lu_PermName_Link.Delete_desc',
	+ 'lu_PermName_Link.Modify.Pending_desc', 'lu_PermName_Link.Modify_desc', 'lu_PermName_Link.Owner.Delete_desc',
	+ 'lu_PermName_Link.Owner.Modify.Pending_desc', 'lu_PermName_Link.Owner.Modify_desc', 'lu_PermName_Link.Rate_desc',
	+ 'lu_PermName_Link.Review_Pending_desc', 'lu_PermName_Link.View_desc'
	+);
	+
	+# ===== v 5.0.3-B2 =====
	+
	+# ===== v 5.0.3-RC1 =====
	+
	+# ===== v 5.0.3 =====
	+
	# ===== v 5.1.0-B1 =====
	UPDATE Modules SET Path = 'modules/in-link/' WHERE `Name` = 'In-Link';
	DELETE FROM ConfigurationValues WHERE VariableName IN ('StartValidationTime', 'LastExpirationTime', 'Link_Root');

	UPDATE CustomField
	SET ValueList = '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 2 ORDER BY StateCountryId DESC, IsoCode ASC</SQL>'
	WHERE ValueList = '=+\|\|<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 2 AND (DestParentId = 225 OR DestParentId = 38) ORDER BY DestParentId DESC, DestAbbr ASC</SQL>';

	UPDATE CustomField
	SET ValueList = '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 1 ORDER BY IsoCode ASC</SQL>'
	WHERE ValueList = '=+\|\|<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 1 ORDER BY DestAbbr ASC</SQL>';
	Index: branches/5.1.x/install/english.lang
	===================================================================
	--- branches/5.1.x/install/english.lang (revision 13549)
	+++ branches/5.1.x/install/english.lang (revision 13550)
	@@ -1,168 +1,168 @@
	<LANGUAGES>
	<LANGUAGE PackName="English" Encoding="base64"><DATEFORMAT>m/d/Y</DATEFORMAT><TIMEFORMAT>g:i A</TIMEFORMAT><INPUTDATEFORMAT>m/d/Y</INPUTDATEFORMAT><INPUTTIMEFORMAT>g:i:s A</INPUTTIMEFORMAT><DECIMAL>.</DECIMAL><THOUSANDS>,</THOUSANDS><CHARSET>utf-8</CHARSET><DOCS_URL>http://docs.in-portal.org/eng/index.php</DOCS_URL><UNITSYSTEM>2</UNITSYSTEM>
	<PHRASES>
	<PHRASE Label="la_ActionsUponExpire" Module="In-Link" Type="1">QWN0aW9ucyBVcG9uIEV4cGlyYXRpb24=</PHRASE>
	<PHRASE Label="la_ActionsUponPurchase" Module="In-Link" Type="1">QWN0aW9ucyBVcG9uIFB1cmNoYXNl</PHRASE>
	<PHRASE Label="la_col_DupeCount" Module="In-Link" Type="1">RHVwbGljYXRlcw==</PHRASE>
	<PHRASE Label="la_col_ExpiresOn" Module="In-Link" Type="1">RXhwaXJlcyBPbg==</PHRASE>
	<PHRASE Label="la_col_LinkName" Module="In-Link" Type="1">TGluaw==</PHRASE>
	<PHRASE Label="la_col_LinkOwner" Module="In-Link" Type="1">T3duZXI=</PHRASE>
	<PHRASE Label="la_col_ListingTypeName" Module="In-Link" Type="1">TGlzdGluZyBUeXBl</PHRASE>
	<PHRASE Label="la_col_PendingRenewal" Module="In-Link" Type="1">UGVuZGluZyBSZW5ld2Fs</PHRASE>
	<PHRASE Label="la_col_PurchasedOn" Module="In-Link" Type="1">RW5hYmxlZCBPbg==</PHRASE>
	<PHRASE Label="la_col_ValidatedOn" Module="In-Link" Type="1">VmFsaWRhdGVkIE9u</PHRASE>
	<PHRASE Label="la_col_ValidationCode" Module="In-Link" Type="1">VmFsaWRhdGlvbiBDb2Rl</PHRASE>
	<PHRASE Label="la_config_EnableLinkContactForm" Module="In-Link" Type="1">RW5hYmxlIExpbmsgQ29udGFjdCBGb3Jtcw==</PHRASE>
	<PHRASE Label="la_config_ReciprocalLinkChecking" Module="In-Link" Type="1">UmVjaXByb2NhbCBMaW5rIENoZWNraW5n</PHRASE>
	<PHRASE Label="la_DecreaseBy" Module="In-Link" Type="1">RGVjcmVhc2UgQnk=</PHRASE>
	<PHRASE Label="la_DontChange" Module="In-Link" Type="1">RG9uJ3QgQ2hhbmdl</PHRASE>
	<PHRASE Label="la_fld_AdditionalSection" Module="In-Link" Type="1">QWRkaXRpb25hbCBTZWN0aW9u</PHRASE>
	<PHRASE Label="la_fld_cust_l_ItemTemplate" Module="In-Link" Type="1">TGluayBJdGVtIFRlbXBsYXRl</PHRASE>
	<PHRASE Label="la_fld_EnableBuying" Module="In-Link" Type="1">RW5hYmxlIFB1cmNoYXNpbmc=</PHRASE>
	<PHRASE Label="la_fld_ExpiresOn" Module="In-Link" Type="1">RXhwaXJhdGlvbiBEYXRl</PHRASE>
	<PHRASE Label="la_fld_LinkAddress" Module="In-Link" Type="1">QWRkcmVzcw==</PHRASE>
	<PHRASE Label="la_fld_LinkCity" Module="In-Link" Type="1">Q2l0eQ==</PHRASE>
	<PHRASE Label="la_fld_LinkCountry" Module="In-Link" Type="1">Q291bnRyeQ==</PHRASE>
	<PHRASE Label="la_fld_LinkEnableGoogleMaps" Module="In-Link" Type="1">RW5hYmxlIEdvb2dsZSBNYXBz</PHRASE>
	<PHRASE Label="la_fld_LinkGoogleMapsAPIKey" Module="In-Link" Type="1">R29vZ2xlIE1hcHMgQVBJIEtleQ==</PHRASE>
	<PHRASE Label="la_fld_LinkName" Module="In-Link" Type="1">TGluayBOYW1l</PHRASE>
	<PHRASE Label="la_fld_LinkOwner" Module="In-Link" Type="1">TGluayBPd25lcg==</PHRASE>
	<PHRASE Label="la_fld_LinkPhone" Module="In-Link" Type="1">UGhvbmU=</PHRASE>
	<PHRASE Label="la_fld_LinkState" Module="In-Link" Type="1">U3RhdGU=</PHRASE>
	<PHRASE Label="la_fld_LinkStatus" Module="In-Link" Type="1">TGluayBTdGF0dXM=</PHRASE>
	<PHRASE Label="la_fld_LinkZipCode" Module="In-Link" Type="1">WmlwIGNvZGU=</PHRASE>
	<PHRASE Label="la_fld_Link_MaxHotNumber" Module="In-Link" Type="1">TWF4aW11bSBudW1iZXIgb2YgSE9UIGxpbmtz</PHRASE>
	<PHRASE Label="la_fld_Link_MinPopRating" Module="In-Link" Type="1">TWluaW11bSByYXRpbmcgdG8gY29uc2lkZXIgbGluayBQT1A=</PHRASE>
	<PHRASE Label="la_fld_Link_MinPopVotes" Module="In-Link" Type="1">TWluaW11bSBudW1iZXIgb2Ygdm90ZXMgdG8gY29uc2lkZXIgbGluayBQT1A=</PHRASE>
	<PHRASE Label="la_fld_ListingId" Module="In-Link" Type="1">SUQ=</PHRASE>
	<PHRASE Label="la_fld_ListingType" Module="In-Link" Type="1">TGlzdGluZyBUeXBl</PHRASE>
	<PHRASE Label="la_fld_ListingTypeDescription" Module="In-Link" Type="1">RGVzY3JpcHRpb24=</PHRASE>
	<PHRASE Label="la_fld_ListingTypeId" Module="In-Link" Type="1">SUQ=</PHRASE>
	<PHRASE Label="la_fld_ListingTypeName" Module="In-Link" Type="1">TmFtZQ==</PHRASE>
	<PHRASE Label="la_fld_PendingRenewal" Module="In-Link" Type="1">UGVuZGluZyBSZW5ld2Fs</PHRASE>
	<PHRASE Label="la_fld_PurchasedOn" Module="In-Link" Type="1">UHVyY2hhc2UgRGF0ZQ==</PHRASE>
	<PHRASE Label="la_fld_ReciprocalLinkFound" Module="In-Link" Type="1">UmVjaXByb2NhbCBMaW5rIFN0YXR1cw==</PHRASE>
	<PHRASE Label="la_fld_Recurring" Module="In-Link" Type="1">UmVjdXJyaW5n</PHRASE>
	<PHRASE Label="la_fld_RenewalReminder" Module="In-Link" Type="1">UmVuZXdhbCBSZW1pbmRlcg==</PHRASE>
	<PHRASE Label="la_fld_ShopCartName" Module="In-Link" Type="1">UHJvZHVjdCBOYW1l</PHRASE>
	<PHRASE Label="la_In-link" Module="In-Link" Type="1">SW4tTGluaw==</PHRASE>
	<PHRASE Label="la_IncreaseBy" Module="In-Link" Type="1">SW5jcmVhc2UgQnk=</PHRASE>
	<PHRASE Label="la_ItemTab_Links" Module="In-Link" Type="1">TGlua3M=</PHRASE>
	<PHRASE Label="la_link_AllowFreeListings" Module="In-Link" Type="1">QWxsb3cgRnJlZSBMaXN0aW5ncw==</PHRASE>
	<PHRASE Label="la_link_EnhancedLinks" Module="In-Link" Type="1">RW5oYW5jZWQgTGlzdGluZ3M=</PHRASE>
	<PHRASE Label="la_link_sortreviews2_prompt" Module="In-Link" Type="1">YW5kIHRoZW4gYnk=</PHRASE>
	<PHRASE Label="la_link_sortreviews_prompt" Module="In-Link" Type="1">U29ydCBDb21tZW50cyBieQ==</PHRASE>
	<PHRASE Label="la_menu_Grouping" Module="In-Link" Type="1">R3JvdXBpbmcgQnk=</PHRASE>
	<PHRASE Label="la_NotChecked" Module="In-Link" Type="1">Tm90IENoZWNrZWQ=</PHRASE>
	<PHRASE Label="la_NotPendingRenewal" Module="In-Link" Type="1">Tm8=</PHRASE>
	<PHRASE Label="la_PendingRenewal" Module="In-Link" Type="1">UGVuZGluZyBSZW5ld2Fs</PHRASE>
	<PHRASE Label="la_prompt_ActiveLinks" Module="In-Link" Type="1">QWN0aXZlIExpbmtz</PHRASE>
	<PHRASE Label="la_prompt_DisabledLinks" Module="In-Link" Type="1">RGlzYWJsZWQgTGlua3M=</PHRASE>
	<PHRASE Label="la_prompt_EditorsPickLinks" Module="In-Link" Type="1">RWRpdG9yJ3MgUGljayBMaW5rcw==</PHRASE>
	<PHRASE Label="la_prompt_HotLinks" Module="In-Link" Type="1">SG90IExpbmtz</PHRASE>
	<PHRASE Label="la_prompt_LinkReviews" Module="In-Link" Type="1">VG90YWwgTGluayBDb21tZW50cw==</PHRASE>
	<PHRASE Label="la_prompt_LinksAverageRating" Module="In-Link" Type="1">QXZlcmFnZSBSYXRpbmcgb2YgTGlua3M=</PHRASE>
	<PHRASE Label="la_prompt_MaxLinksHits" Module="In-Link" Type="1">TWF4aW11bSBIaXRzIG9mIGEgTGluaw==</PHRASE>
	<PHRASE Label="la_prompt_MaxLinksVotes" Module="In-Link" Type="1">TWF4aW11bSBWb3RlcyBvZiBhIExpbms=</PHRASE>
	<PHRASE Label="la_prompt_NewLinks" Module="In-Link" Type="1">TmV3IExpbmtz</PHRASE>
	<PHRASE Label="la_prompt_PendingLinks" Module="In-Link" Type="1">UGVuZGluZyBMaW5rcw==</PHRASE>
	<PHRASE Label="la_prompt_PopularLinks" Module="In-Link" Type="1">UG9wdWxhciBMaW5rcw==</PHRASE>
	<PHRASE Label="la_prompt_TotalLinks" Module="In-Link" Type="1">VG90YWwgTGlua3M=</PHRASE>
	<PHRASE Label="la_section_BusinessLocation" Module="In-Link" Type="1">TG9jYXRpb24=</PHRASE>
	<PHRASE Label="la_section_Link" Module="In-Link" Type="1">TGluaw==</PHRASE>
	<PHRASE Label="la_section_OriginalValues" Module="In-Link" Type="1">T3JpZ2luYWwgVmFsdWVz</PHRASE>
	<PHRASE Label="la_SetEqualTo" Module="In-Link" Type="1">U2V0IEVxdWFsIFRv</PHRASE>
	<PHRASE Label="la_ShortToolTip_ResetValidationStatus" Module="In-Link" Type="1">UmVzZXQ=</PHRASE>
	<PHRASE Label="la_tab_DuplicateChecker" Module="In-Link" Type="1">RHVwbGljYXRlIENoZWNrZXI=</PHRASE>
	<PHRASE Label="la_tab_Links" Module="In-Link" Type="1">TGlua3M=</PHRASE>
	<PHRASE Label="la_tab_LinkValidation" Module="In-Link" Type="1">TGluayBWYWxpZGF0aW9u</PHRASE>
	<PHRASE Label="la_tab_Listings" Module="In-Link" Type="1">TGlzdGluZ3M=</PHRASE>
	<PHRASE Label="la_tab_ListingTypes" Module="In-Link" Type="1">TGlzdGluZyBUeXBlcw==</PHRASE>
	<PHRASE Label="la_tab_PaidListings" Module="In-Link" Type="1">UGFpZCBMaXN0aW5ncw==</PHRASE>
	<PHRASE Label="la_tab_ShopCartEntry" Module="In-Link" Type="1">U2hvcHBpbmcgQ2FydCBFbnRyeQ==</PHRASE>
	<PHRASE Label="la_Text_Links" Module="In-Link" Type="1">TGlua3M=</PHRASE>
	<PHRASE Label="la_Text_PaidListing" Module="In-Link" Type="1">UGFpZCBMaXN0aW5n</PHRASE>
	<PHRASE Label="la_Text_PaidListingType" Module="In-Link" Type="1">TGlzdGluZyBUeXBl</PHRASE>
	<PHRASE Label="la_Text_ShopCartItem" Module="In-Link" Type="1">U2hvcHBpbmcgQ2FydCBJdGVt</PHRASE>
	<PHRASE Label="la_title_AddingLink" Module="In-Link" Type="1">QWRkaW5nIExpbms=</PHRASE>
	<PHRASE Label="la_title_AddingListing" Module="In-Link" Type="1">QWRkaW5nIExpc3Rpbmc=</PHRASE>
	<PHRASE Label="la_title_AddingPaidListingType" Module="In-Link" Type="1">QWRkaW5nIExpc3RpbmcgVHlwZQ==</PHRASE>
	<PHRASE Label="la_title_DuplicateLinks" Module="In-Link" Type="1">RHVwbGljYXRlIExpbmtz</PHRASE>
	<PHRASE Label="la_title_EditingLink" Module="In-Link" Type="1">RWRpdGluZyBMaW5r</PHRASE>
	<PHRASE Label="la_title_EditingListing" Module="In-Link" Type="1">RWRpdGluZyBMaXN0aW5n</PHRASE>
	<PHRASE Label="la_title_EditingPaidListingType" Module="In-Link" Type="1">RWRpdGluZyBMaXN0aW5nIFR5cGU=</PHRASE>
	<PHRASE Label="la_title_ImportLinks" Module="In-Link" Type="1">SW1wb3J0IExpbmtz</PHRASE>
	<PHRASE Label="la_title_In-Link" Module="In-Link" Type="1">RGlyZWN0b3J5</PHRASE>
	<PHRASE Label="la_title_Links" Module="In-Link" Type="1">TGlua3M=</PHRASE>
	<PHRASE Label="la_title_LinksExport" Module="In-Link" Type="1">TGlua3MgRXhwb3J0</PHRASE>
	<PHRASE Label="la_title_NewLink" Module="In-Link" Type="1">TmV3IExpbms=</PHRASE>
	<PHRASE Label="la_title_NewListing" Module="In-Link" Type="1">TmV3IExpc3Rpbmc=</PHRASE>
	<PHRASE Label="la_title_NewPaidListingType" Module="In-Link" Type="1">TmV3IExpc3RpbmcgVHlwZQ==</PHRASE>
	<PHRASE Label="la_title_PaidListings" Module="In-Link" Type="1">UGFpZCBMaXN0aW5ncw==</PHRASE>
	<PHRASE Label="la_title_PaidListingTypes" Module="In-Link" Type="1">TGlzdGluZyBUeXBlcw==</PHRASE>
	<PHRASE Label="la_title_ShopCartEntry" Module="In-Link" Type="1">U2hvcHBpbmcgQ2FydCBFbnRyeQ==</PHRASE>
	<PHRASE Label="la_ToolTip_ContinueValidation" Module="In-Link" Type="1">Q29udGludWUgTGluayBWYWxpZGF0aW9u</PHRASE>
	<PHRASE Label="la_ToolTip_Merge" Module="In-Link" Type="1">TWVyZ2U=</PHRASE>
	<PHRASE Label="la_ToolTip_newfile" Module="In-Link" Type="1">TmV3IEZpbGU=</PHRASE>
	<PHRASE Label="la_ToolTip_newlisttype" Module="In-Link" Type="1">TmV3IExpc3RpbmcgVHlwZQ==</PHRASE>
	<PHRASE Label="la_ToolTip_NewPaidListing" Module="In-Link" Type="1">TmV3IFBhaWQgTGlzdGluZw==</PHRASE>
	<PHRASE Label="la_ToolTip_NewValidation" Module="In-Link" Type="1">U3RhcnQgTmV3IFZhbGlkYXRpb24=</PHRASE>
	<PHRASE Label="la_ToolTip_ResetValidationStatus" Module="In-Link" Type="1">UmVzZXQgVmFsaWRhdGlvbiBTdGF0dXM=</PHRASE>
	<PHRASE Label="la_UseGridToApproveDecline" Module="In-Link" Type="1">VXNlIGdyaWQgdG8gQXBwcm92ZSAvIERlY2xpbmU=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Modify.Pending_desc" Module="Core" Type="2">TW9kaWZ5IExpbmsgUGVuZGluZw==</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Owner.Delete_desc" Module="Core" Type="2">TGluayBEZWxldGUgYnkgT3duZXI=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Owner.Modify.Pending_desc" Module="Core" Type="2">TGluayBNb2RpZnkgUGVuZGluZyBieSBPd25lcg==</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Owner.Modify_desc" Module="Core" Type="2">TGluayBNb2RpZnkgYnkgT3duZXI=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Review_Pending_desc" Module="Core" Type="2">UmV2aWV3IExpbmsgUGVuZGluZw==</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Review_desc" Module="In-Link" Type="2">Q29tbWVudCBMaW5r</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Add.Pending_desc" Module="Core" Type="2">UGVuZGluZyBMaW5r</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Add_desc" Module="Core" Type="2">QWRkIExpbms=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Delete_desc" Module="Core" Type="2">RGVsZXRlIExpbms=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Modify_desc" Module="Core" Type="2">TW9kaWZ5IExpbms=</PHRASE>
	- <PHRASE Label="lu_PermName_Link.Rate_desc" Module="Core" Type="2">UmF0ZSBMaW5r</PHRASE>
	- <PHRASE Label="lu_PermName_Link.View_desc" Module="Core" Type="2">VmlldyBMaW5r</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Add.Pending_desc" Module="In-Link" Type="2">UGVuZGluZyBMaW5r</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Add_desc" Module="In-Link" Type="2">QWRkIExpbms=</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Delete_desc" Module="In-Link" Type="2">RGVsZXRlIExpbms=</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Modify.Pending_desc" Module="In-Link" Type="2">TW9kaWZ5IExpbmsgUGVuZGluZw==</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Modify_desc" Module="In-Link" Type="2">TW9kaWZ5IExpbms=</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Owner.Delete_desc" Module="In-Link" Type="2">TGluayBEZWxldGUgYnkgT3duZXI=</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Owner.Modify.Pending_desc" Module="In-Link" Type="2">TGluayBNb2RpZnkgUGVuZGluZyBieSBPd25lcg==</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Owner.Modify_desc" Module="In-Link" Type="2">TGluayBNb2RpZnkgYnkgT3duZXI=</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Rate_desc" Module="In-Link" Type="2">UmF0ZSBMaW5r</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Review_desc" Module="In-Link" Type="2">Q29tbWVudCBMaW5r</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.Review_Pending_desc" Module="In-Link" Type="2">UmV2aWV3IExpbmsgUGVuZGluZw==</PHRASE>
	+ <PHRASE Label="lu_PermName_Link.View_desc" Module="In-Link" Type="2">VmlldyBMaW5r</PHRASE>
	</PHRASES>
	<EVENTS>
	<EVENT MessageType="html" Event="LINK.ADD" Type="0">U3ViamVjdDogTmV3IExpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgLSBBZGRlZAoKVGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIHlvdXIgbGluayB0byBvdXIgd2Vic2l0ZSE8YnIgLz4NCjxiciAvPg0KTGluayBkZXRhaWwgYXJlIGxpc3RlZCBiZWxvdzo8YnIgLz4NCjxiciAvPg0KTGluayBOYW1lOiA8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4gPGJyIC8+DQo8aW5wMjptX2lmIGNoZWNrPSJsX0ZpZWxkIiBuYW1lPSJVcmwiPiBMaW5rIFdlYnNpdGU6IDxpbnAyOmxfRmllbGQgbmFtZT0iVXJsIi8+PGJyIC8+DQo8L2lucDI6bV9pZj4gPGlucDI6bV9pZiBjaGVjaz0ibF9GaWVsZCIgbmFtZT0iRGVzY3JpcHRpb24iPiBEZXNjcmlwdGlvbjogPGlucDI6bF9GaWVsZCBuYW1lPSJEZXNjcmlwdGlvbiIvPjxiciAvPg0KPC9pbnAyOm1faWY+IDxiciAvPg0KPGJyIC8+DQpZb3UgY2FuIHZpZXcgeW91ciBsaW5rIGhlcmUgPGEgaHJlZj0iPGlucDI6bF9MaW5rTGluayB0ZW1wbGF0ZT0iX19kZWZhdWx0X18iLz4iPjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjwvYT4=</EVENT>
	<EVENT MessageType="html" Event="LINK.ADD" Type="1">U3ViamVjdDogTmV3IExpbmsgaGFzIGJlZW4gU3VibWl0dGVkCgpBIG5ldyBMaW5rIGhhcyBiZWVuIHN1Ym1pdHRlZCB0byB0aGUgd2Vic2l0ZSBieSA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVzZXJOYW1lIi8+LjxiciAvPg0KPGJyIC8+DQpMaW5rIE5hbWU6IDxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxiciAvPg0KPGlucDI6bV9pZiBjaGVjaz0ibF9GaWVsZCIgbmFtZT0iVXJsIj4gTGluayBXZWJzaXRlOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVybCIvPjxiciAvPg0KPC9pbnAyOm1faWY+IDxpbnAyOm1faWYgY2hlY2s9ImxfRmllbGQiIG5hbWU9IkRlc2NyaXB0aW9uIj4gRGVzY3JpcHRpb246IDxpbnAyOmxfRmllbGQgbmFtZT0iRGVzY3JpcHRpb24iLz48YnIgLz4NCjwvaW5wMjptX2lmPiA8YnIgLz4NCjxiciAvPg0KWW91IGNhbiB2aWV3IGl0IGhlcmUgPGEgaHJlZj0iPGlucDI6bF9MaW5rTGluayB0ZW1wbGF0ZT0iX19kZWZhdWx0X18iLz4iPjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjwvYT4=</EVENT>
	<EVENT MessageType="html" Event="LINK.ADD.PENDING" Type="0">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGlzIFBlbmRpbmcKClRoYW5rIHlvdSBmb3Igc3VibWl0dGluZyB5b3VyIExpbmsuPGJyLz48YnIvPg0KDQpDdXJyZW50bHkgaXQncyBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbC48YnIvPjxici8+DQoNCllvdSdsbCBiZSBjb250YWN0ZWQgZGlyZWN0bHkgYnkgZW1haWwuPGJyLz48YnIvPg0KDQpMaW5rIE5hbWU6IDxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxici8+DQo8aW5wMjptX2lmIGNoZWNrPSJsX0ZpZWxkIiBuYW1lPSJVcmwiPg0KTGluayBXZWJzaXRlOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVybCIvPjxici8+DQo8L2lucDI6bV9pZj4NCjxpbnAyOm1faWYgY2hlY2s9ImxfRmllbGQiIG5hbWU9IkRlc2NyaXB0aW9uIj4NCkRlc2NyaXB0aW9uOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IkRlc2NyaXB0aW9uIi8+PGJyLz4NCjwvaW5wMjptX2lmPg0KPGJyLz48YnIvPg0KDQo=</EVENT>
	<EVENT MessageType="html" Event="LINK.ADD.PENDING" Type="1">U3ViamVjdDogTmV3IExpbmsgIGhhcyBiZWVuIFN1Ym1pdHRlZCBhbmQgUGVuZGluZyEKCk5ldyBsaW5rIGhhcyBiZWVuIHN1Ym1pdHRlZCBhbmQgaXMgcGVuZGluZyBmb3IgYWRtaW5pc3RyYXRpdmUgYXBwcm92YWwuPGJyLz48YnIvPg0KDQpMaW5rIE5hbWU6IDxpbnAyOjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxici8+DQo8aW5wMjptX2lmIGNoZWNrPSJsX0ZpZWxkIiBuYW1lPSJVcmwiPg0KTGluayBXZWJzaXRlOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVybCIvPjxici8+DQo8L2lucDI6bV9pZj4NCjxpbnAyOm1faWYgY2hlY2s9ImxfRmllbGQiIG5hbWU9IkRlc2NyaXB0aW9uIj4NCkRlc2NyaXB0aW9uOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IkRlc2NyaXB0aW9uIi8+PGJyLz4NCjwvaW5wMjptX2lmPg0KPGJyLz48YnIvPg0KDQpQbGVhc2UgcHJvY2VlZCB0byB0aGUgQWRtaW5pc3RyYXRpdmUgQ29uc29sZSB0byBhcHByb3ZlIG9yIGRlbnkgdGhpcyBsaW5rPGJyLz48L2JyPg==</EVENT>
	<EVENT MessageType="html" Event="LINK.APPROVE" Type="0">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIC0gQXBwcm92ZWQhCgpZb3VyIExpbmsgaGFzIGJlZW4gQXBwcm92ZWQhPGJyIC8+DQo8YnIgLz4NCkxpbmsgTmFtZTogPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+PGJyIC8+DQo8YnIgLz4NCllvdSBjYW4gdmlldyBpdCBoZXJlIDxhIGhyZWY9IjxpbnAyOmxfTGlua0xpbmsgdGVtcGxhdGU9Il9fZGVmYXVsdF9fIi8+Ij48aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz48L2E+</EVENT>
	<EVENT MessageType="html" Event="LINK.CONTACTFORM" Type="0">U3ViamVjdDogIlJlcXVlc3QgSW5mb3JtYXRpb24iIGZvcm0gc3VibWl0dGVkCgpEZWFyIEJ1c2luZXNzIE93bmVyLDxiciAvPg0KPGJyIC8+DQomcXVvdDtSZXF1ZXN0IEluZm9ybWF0aW9uJnF1b3Q7IGZvcm0gaGFzIGJlZW4gc3VibWl0dGVkIGZvciA8aW5wMjptX3BhcmFtIG5hbWU9InRvX2xpbmtuYW1lIi8+PGJyIC8+DQo8YnIgLz4NCjxociBub3NoYWRlPSIiIHdpZHRoPSIxMDAlIiAvPg0KPGJyIC8+DQo8dGFibGU+DQogICAgPHRib2R5Pg0KICAgICAgICA8dHI+DQogICAgICAgICAgICA8dGQ+RnVsbCBuYW1lOjwvdGQ+DQogICAgICAgICAgICA8dGQ+PGlucDI6bV9wYXJhbSBuYW1lPSJmcm9tX25hbWUiIC8+PC90ZD4NCiAgICAgICAgPC90cj4NCiAgICAgICAgPHRyPg0KICAgICAgICAgICAgPHRkPkUtbWFpbDo8L3RkPg0KICAgICAgICAgICAgPHRkPjxhIGhyZWY9Im1haWx0bzo8aW5wMjptX3BhcmFtIG5hbWU9ImZyb21fZW1haWwiIC8+Ij48aW5wMjptX3BhcmFtIG5hbWU9ImZyb21fZW1haWwiIC8+PC9hPjwvdGQ+DQogICAgICAgIDwvdHI+DQogICAgICAgIDx0cj4NCiAgICAgICAgICAgIDx0ZD5TdWJqZWN0OjwvdGQ+DQogICAgICAgICAgICA8dGQ+PGlucDI6bV9wYXJhbSBuYW1lPSJmcm9tX3N1YmplY3QiIC8+PC90ZD4NCiAgICAgICAgPC90cj4NCiAgICAgICAgPHRyPg0KICAgICAgICAgICAgPHRkPlF1ZXN0aW9uczo8L3RkPg0KICAgICAgICAgICAgPHRkPjxpbnAyOm1fcGFyYW0gbmFtZT0ibWVzc2FnZSIvPiA8L3RkPg0KICAgICAgICA8L3RyPg0KICAgIDwvdGJvZHk+DQo8L3RhYmxlPg0KPGJyIC8+DQo8aHIgbm9zaGFkZT0iIiB3aWR0aD0iMTAwJSIgLz4NCjxiciAvPg==</EVENT>
	<EVENT MessageType="html" Event="LINK.CONTACTFORM" Type="1">U3ViamVjdDogSW5mb3JtYXRpb24gUmVxdWVzdCBmb3IgIjxpbnAyOm1fcGFyYW0gbmFtZT0idG9fbGlua25hbWUiIC8+IiBzdWJtaXR0ZWQKCkRlYXIgQWRtaW5pc3RyYXRvciw8YnIvPjxici8+DQoNCiJSZXF1ZXN0IEluZm9ybWF0aW9uIiBmb3JtIGhhcyBiZWVuIHN1Ym1pdHRlZCBmb3IgIjxpbnAyOm1fcGFyYW0gbmFtZT0idG9fbGlua25hbWUiIC8+Ijxici8+PGJyLz4NCg0KPGhyIHdpZHRoPSIxMDAlIiBub3NoYWRlPjxici8+DQoNCjx0YWJsZT4NCjx0cj4NCjx0ZD5GdWxsIG5hbWU6PC90ZD4NCjx0ZD48aW5wMjptX3BhcmFtIG5hbWU9ImZyb21fbmFtZSIgLz48L3RkPg0KPC90cj4NCg0KPHRyPg0KPHRkPkUtbWFpbDo8L3RkPg0KPHRkPjxpbnAyOm1fcGFyYW0gbmFtZT0iZnJvbV9lbWFpbCIgLz48L3RkPg0KPC90cj4NCg0KPHRyPg0KPHRkPlN1YmplY3Q6PC90ZD4NCjx0ZD48aW5wMjptX3BhcmFtIG5hbWU9ImZyb21fc3ViamVjdCIgLz48L3RkPg0KPC90cj4NCg0KPHRyPg0KPHRkPlF1ZXN0aW9uczo8L3RkPg0KPHRkPg0KPGJsb2NrcXVvdGU+DQo8aW5wMjptX3BhcmFtIG5hbWU9Im1lc3NhZ2UiLz4NCjwvYmxvY2txdW90ZT4NCjwvdGQ+DQo8L3RyPg0KPC90YWJsZT4NCjxicj48aHIgd2lkdGg9IjEwMCUiIG5vc2hhZGU+PGJyPg0K</EVENT>
	<EVENT MessageType="html" Event="LINK.DENY" Type="0">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGhhcyBiZWVuIGRlbmllZAoKU29ycnksIGJ1dCBzdWJtaXR0ZWQgYnkgeW91IExpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgaGFzIGJlZW4gZGVuaWVkPGJyPjxicj4NCg0KUGxlYXNlIGZlZWwgZnJlZSB0byBzdWJtaXQgYWdhaW4uPGJyPg==</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZWNlaXZlZCBhbmQgUGVuZGluZwoKRGVhciA8aW5wMjp1Li1pdGVtX0ZpZWxkIG5hbWU9IkZpcnN0TmFtZSIgLz4gPGlucDI6dS4taXRlbV9GaWVsZCBuYW1lPSJMYXN0TmFtZSIgLz4sPGJyLz48YnIvPg0KDQpUaGFuayB5b3UgZm9yIHN1Ym1pdHRpbmcgbGluayBlbmhhbmNlbWVudCByZXF1ZXN0LiBZb3Ugd2lsbCBiZSBub3RpZmllZCBvbmNlIHlvdXIgbGluayBlbmhhbmNlbWVudCBpcyBwcm9jZXNzZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBzdWJtaXR0ZWQKCkEgdXNlciBoYXMgc3VibWl0dGVkIGEgbGluayBlbmhhbmNlbWVudCByZXF1ZXN0Ljxici8+PGJyLz4NCg0KUGxlYXNlIHByb2NlZWQgdG8gYWRtaW5pc3RyYXRpdmUgY29uc29sZSB0byByZXZpZXcgaXQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.APPROVE" Type="0">U3ViamVjdDogWW91ciBMaW5rIGVuaGFuY2VtZW50IGZvciA8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiIC8+IC0gQXBwcm92ZWQhCgpEZWFyIDxpbnAyOnUuLWl0ZW1fRmllbGQgbmFtZT0iRmlyc3ROYW1lIiAvPiA8aW5wMjp1Li1pdGVtX0ZpZWxkIG5hbWU9Ikxhc3ROYW1lIiAvPiw8YnIvPjxici8+DQoNCllvdXIgcmVjZW50IGxpbmsgZW5oYW5jZW1lbnQgcmVxdWVzdCBoYXMgYmVlbiBhcHByb3ZlZC4gVGhhbmsgeW91IQ0K</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.APPROVE" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBpcyBBcHByb3ZlZAoKTGluayBlbmhhbmNlbWVudCBmb3IgPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IGFzIGJlZW4gYXBwcm92ZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.CANCEL" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gQ2FuY2VsZWQKCkRlYXIgPGlucDI6dS4taXRlbV9GaWVsZCBuYW1lPSJGaXJzdE5hbWUiIC8+IDxpbnAyOnUuLWl0ZW1fRmllbGQgbmFtZT0iTGFzdE5hbWUiIC8+LDxici8+PGJyLz4NCg0KWW91ciBsaW5rIGVuaGFuY2VtZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgb24gPGlucDI6Y29uZl9Db25maWdWYWx1ZSBuYW1lPSJTaXRlX05hbWUiLz4gaGFzIGJlZW4gY2FuY2VsZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.CANCEL" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gQ2FuY2VsZWQhCgpMaW5rIEVuaGFuY2VtZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgaGFzIGJlZW4gY2FuY2VsZWQh</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.DENY" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiAtIERlbmllZAoKRGVhciA8aW5wMjp1Li1pdGVtX0ZpZWxkIG5hbWU9IkZpcnN0TmFtZSIgLz4gPGlucDI6dS4taXRlbV9GaWVsZCBuYW1lPSJMYXN0TmFtZSIgLz4sPGJyLz48YnIvPg0KDQpTb3JyeSwgYnV0IHlvdXIgcmVjZW50IGxpbmsgZW5oYW5jZW1lbnQgcmVxdWVzdCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGhhcyBiZWVuIGRlbmllZC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.DENY" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBoYXMgYmVlbiBEZW5pZWQKCkxpbmsgZW5oYW5jZW1lbnQgZm9yIDxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4gaGFzIGJlZW4gZGVuaWVkLg==</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.EXPIRE" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gRXhwaXJlZAoKRGVhciA8aW5wMjp1Li1pdGVtX0ZpZWxkIG5hbWU9IkZpcnN0TmFtZSIgLz4gPGlucDI6dS4taXRlbV9GaWVsZCBuYW1lPSJMYXN0TmFtZSIgLz4sPGJyLz48YnIvPg0KDQpZb3VyIGVuaGFuY2VkIGxpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGF0IDxpbnAyOmNvbmZfQ29uZmlnVmFsdWUgbmFtZT0iU2l0ZV9OYW1lIi8+IGhhcyBleHBpcmVkLjxici8+PGJyLz4NCg0KSWYgeW91IHdhbnQgdG8gcmVuZXcgeW91ciBlbmhhbmNlZCBsaW5rLCBwbGVhc2UgcmUtc3VibWl0IGxpbmsgZW5oYW5jZW1lbnQgcmVxdWVzdC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.EXPIRE" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gRXhwaXJlZAoKRW5oYW5jZWQgbGluayA8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiIC8+IGhhcyBleHBpcmVkLg==</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.EXTEND" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZW5ld2FsIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgLSBTdWJtaXR0ZWQKCkRlYXIgPGlucDI6dS4taXRlbV9GaWVsZCBuYW1lPSJGaXJzdE5hbWUiIC8+IDxpbnAyOnUuLWl0ZW1fRmllbGQgbmFtZT0iTGFzdE5hbWUiIC8+LA0KDQpUaGFuayB5b3UgZm9yIHN1Ym1pdHRpbmcgbGluayBlbmhhbmNlbWVudCByZW5ld2FsIHJlcXVlc3QgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiIC8+Ii48YnIvPjxici8+DQoNCllvdSB3aWxsIGJlIG5vdGlmaWVkIHNob3J0bHkgb25jZSB5b3UgcmVxdWVzdCBpcyBwcm9jZXNzZWQuDQoNCg==</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.EXTEND" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZW5ld2FsIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgLSBTdWJtaXR0ZWQKCkxpbmsgZW5oYW5jZW1lbnQgcmVuZXdhbCByZXF1ZXN0IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgaGFzIGJlZW4gc3VibWl0dGVkIGJ5IHVzZXIuPGJyLz48YnIvPg0KDQpQbGVhc2UgcHJvY2VlZCB0byB0aGUgQWRtaW5pc3RyYXRpdmUgQ29uc29sZSB0byByZXZpZXcgaXQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEW" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gRXh0ZW5kZWQhCgpEZWFyIDxpbnAyOnUuLWl0ZW1fRmllbGQgbmFtZT0iRmlyc3ROYW1lIiAvPiA8aW5wMjp1Li1pdGVtX0ZpZWxkIG5hbWU9Ikxhc3ROYW1lIiAvPiw8YnIvPjxici8+DQoNCllvdSBsaW5rIGVuaGFuY2VtZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgb24gPGlucDI6Y29uZl9Db25maWdWYWx1ZSBuYW1lPSJTaXRlX05hbWUiLz4gaGFzIGJlZW4gZXh0ZW5kZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEW" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIC0gRXh0ZW5kZWQhCgpMaW5rIGVuaGFuY2VtZW50IGhhcyBiZWVuIGV4dGVuZGVkIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEW.FAILED" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZW5ld2FsIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgLSBGYWlsZWQKCkxpbmsgRW5oYW5jZW1lbnQgUmVuZXdhbCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGhhcyBmYWlsZWQgb24gb24gPGlucDI6Y29uZl9Db25maWdWYWx1ZSBuYW1lPSJTaXRlX05hbWUiLz4u</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEW.FAILED" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZW5ld2FsIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgLSBGYWlsZWQKCkxpbmsgRW5oYW5jZW1lbnQgUmVuZXdhbCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGhhcyBmYWlsZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEWAL.NOTICE" Type="0">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBSZW5ld2FsIG5vdGljZSBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iCgpEZWFyIDxpbnAyOnVfRmllbGQgbmFtZT0iRmlyc3ROYW1lIiAvPiA8aW5wMjp1X0ZpZWxkIG5hbWU9Ikxhc3ROYW1lIiAvPiw8YnIvPjxici8+DQoNCllvdXIgbGluayBlbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIG9uIDxpbnAyOmNvbmZfQ29uZmlnVmFsdWUgbmFtZT0iU2l0ZV9OYW1lIi8+IGlzIGFib3V0IHRvIGV4cGlyZS48YnIvPjxici8+DQoNClBsZWFzZSBsb2dpbiB0byB5b3VyIGFjY291bnQgdG8gcmVuZXcgeW91ciBsaW5rIGVuaGFuY2VtZW50Lg==</EVENT>
	<EVENT MessageType="html" Event="LINK.ENHANCE.RENEWAL.NOTICE" Type="1">U3ViamVjdDogTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGlzIGFib3V0IHRvIEV4cGlyZSEKClRoaXMgaXMgYW4gZW1haWwgbm90aWZpY2F0aW9uIHRoYXQgTGluayBFbmhhbmNlbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGlzIGFib3V0IHRvIEV4cGlyZS48YnIvPjxici8+DQo=</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY" Type="0">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiIC8+IiBoYXMgYmVlbiBVcGRhdGVkCgpUaGFuayB5b3UgZm9yIHVwZGF0aW5nIHlvdXIgTGluayBkZXRhaWxzLg0KDQpZb3VyIExpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGhhcyBiZWVuIG1vZGlmaWVk</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY" Type="1">U3ViamVjdDogTGluayAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgaGFzIGJlZW4gTW9kaWZpZWQKCkxpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGhhcyBiZWVuIG1vZGlmaWVkIHRvIHRoZSB1c2VyLg0K</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY.APPROVE" Type="0">U3ViamVjdDogWW91ciBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgYXBwcm92ZWQKCllvdXIgTW9kaWZpY2F0aW9ucyBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGxpbmsgd2VyZSBhcHByb3ZlZC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY.DENY" Type="0">U3ViamVjdDogWW91ciBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIERlY2xpbmVkCgpZb3VyIG1vZGlmaWNhdGlvbnMgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGxpbmsgd2VyZSBkZWNsaW5lZC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY.PENDING" Type="0">U3ViamVjdDogTGluayBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBwZW5kaW5nCgpUaGFuayB5b3UsPGJyPjxicj4NCg0KWW91ciBsaW5rIG1vZGlmaWNhdGlvbnMgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGFyZSBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.MODIFY.PENDING" Type="1">U3ViamVjdDogTGluayBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBwZW5kaW5nIGFwcHJvdmFsCgpNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBsaW5rIGFyZSBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.RECIPROCAL.CHECK.FAILED" Type="1">U3ViamVjdDogQ2hlY2sgZm9yIFJlY2lwcm9jYWwvQmFjayBMaW5rIG9uICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGlzIEZhaWxlZAoKQ2hlY2sgZm9yIFJlY2lwcm9jYWwvQmFjayBsaW5rIGlzIEZhaWxlZCBmb3I6PGJyLz48YnIvPg0KDQpMaW5rIElkOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IkxpbmtJZCIvPjxici8+DQpMaW5rIE5hbWU6IDxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxici8+DQpMaW5rIFdlYnNpdGU6IDxhIGhyZWY9IjxpbnAyOmxfRmllbGQgbmFtZT0iVXJsIi8+Ij48aW5wMjpsX0ZpZWxkIG5hbWU9IlVybCIvPjwvYT48YnIvPg0K</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.ADD" Type="0">U3ViamVjdDogWW91ciBDb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBTdWJtaXR0ZWQKClRoYW5rIHlvdSwgeW91ciBjb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBoYXMgYmVlbiBhZGRlZCB0byB0aGUgd2Vic2l0ZS4=</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.ADD" Type="1">U3ViamVjdDogTmV3IENvbW1lbnQgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGxpbmsgc3VibWl0dGVkCgpOZXcgY29tbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgbGluayBoYXMgYmVlbiBzdWJtaXR0ZWQu</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.ADD.PENDING" Type="0">U3ViamVjdDogWW91ciBDb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBsaW5rIGlzIHBlbmRpbmcKClRoYW5rIHlvdSBmb3Igc3VibWl0dGluZyB5b3VyIGNvbW1lbnQgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iLjxicj48YnI+DQoNCkN1cnJlbnRseSBpdCdzIHBlbmRpbmcgZm9yIGFkbWluaXN0cmF0aXZlIGFwcHJvdmFsIGFuZCB3aWxsIGJlIHB1Ymxpc2hlZCBzaG9ydGx5Lg==</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.ADD.PENDING" Type="1">WC1NYWlsZXI6IEluLVBvcnRhbApTdWJqZWN0OiBZb3VyIENvbW1lbnQgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGxpbmsgaXMgcGVuZGluZyBbYWRtaW5dCgpUaGFuayB5b3UgZm9yIHN1Ym1pdHRpbmcgeW91ciBjb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+Ii48YnI+PGJyPg0KDQpDdXJyZW50bHkgaXQncyBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbCBhbmQgd2lsbCBiZSBwdWJsaXNoZWQgc2hvcnRseS4=</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.APPROVE" Type="0">U3ViamVjdDogWW91ciBDb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIFB1Ymxpc2hlZAoKVGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIHlvdXIgY29tbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIuPGJyLz48YnIvPg0KDQpJdCdzIGFscmVhZHkgcHVibGlzaGVkIG9uIHRoZSB3ZWJzaXRlIQ==</EVENT>
	<EVENT MessageType="html" Event="LINK.REVIEW.DENY" Type="0">U3ViamVjdDogWW91ciBDb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIERlY2xpbmVkCgpTb3JyeSwgYnV0IHlvdXIgY29tbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgbGluayBoYXMgYmVlbiBkZWNsaW5lZC4=</EVENT>
	<EVENT MessageType="html" Event="LINK.VALIDATION.RESULTS" Type="1">U3ViamVjdDogTGluayBWYWxpZGF0aW9uIFJlc3VsdHMgKDxpbnAyOmxhbmcuY3VycmVudF9DdXJyZW50RGF0ZSBmb3JtYXQ9ImQtTS1ZIi8+KQoKTGluayBWYWxpZGF0aW9uIENvbXBsZXRlZCBvbiA8aW5wMjpsYW5nLmN1cnJlbnRfQ3VycmVudERhdGUgZm9ybWF0PSJkLU0tWSIvPiBhdCA8aW5wMjpsYW5nLmN1cnJlbnRfQ3VycmVudERhdGUgZm9ybWF0PSJIOmk6cyIvPjxiciAvPjxiciAvPg0KDQo8aW5wMjpsaW5rLXZhbGlkYXRpb24uaW52YWxpZF9Jbml0TGlzdCBwZXJfcGFnZT0iLTEiLz4NCjxpbnAyOm1faWYgY2hlY2s9ImxpbmstdmFsaWRhdGlvbi5pbnZhbGlkX1RvdGFsUmVjb3JkcyI+DQoJVGhlZXNlIGxpbmtzIHdlcmUgbWFya2VkIGFzIGludmFsaWQgZHVyaW5nIHZhbGlkYXRpb24gcHJvY2Vzczo8YnIgLz4NCg0KCTxpbnAyOm1fRGVmaW5lRWxlbWVudCBuYW1lPSJsaW5rX2VsZW1lbnQiPg0KCQk8bGk+DQoJCQk8aW5wMjpGaWVsZCBuYW1lPSJMaW5rTmFtZSIvPiAoPGlucDI6Q2F0ZWdvcnlOYW1lLz4pDQoJCTwvbGk+DQoJPC9pbnAyOm1fRGVmaW5lRWxlbWVudD4NCg0KCTx1bD4NCgkJPGlucDI6bGluay12YWxpZGF0aW9uLmludmFsaWRfUHJpbnRMaXN0IHJlbmRlcl9hcz0ibGlua19lbGVtZW50Ii8+DQoJPC91bD4NCjxpbnAyOm1fZWxzZS8+DQoJQWxsIGxpbmtzIGFwcGVhciB0byBiZSB2YWxpZC4NCjwvaW5wMjptX2lmPg==</EVENT>
	</EVENTS>
	</LANGUAGE>
	</LANGUAGES>
	\ No newline at end of file
	Index: branches/5.1.x/install/install_data.sql
	===================================================================
	--- branches/5.1.x/install/install_data.sql (revision 13549)
	+++ branches/5.1.x/install/install_data.sql (revision 13550)
	@@ -1,250 +1,243 @@
	# Section "in-link:configuration_output":
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_Highlight_OpenTag', '<span class="match">', 'In-Link', 'in-link:configuration_output', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_Highlight_CloseTag', '</span>', 'In-Link', 'in-link:configuration_output', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_RatingToPop', '5', 'In-Link', 'in-link:configuration_output', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_SortField', 'Name', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name\|\|Description=la_Link_Description\|\|Url=la_Link_URL\|\|CreatedOn=la_opt_CreatedOn\|\|Hits=la_Link_Hits\|\|CachedRating=la_opt_Rating\|\|<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_SortOrder', 'asc', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'asc=la_common_ascending\|\|desc=la_common_descending', 10.01, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_SortField2', 'Description', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name\|\|Description=la_Link_Description\|\|Url=la_Link_URL\|\|CreatedOn=la_opt_CreatedOn\|\|Hits=la_Link_Hits\|\|CachedRating=la_opt_Rating\|\|<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_SortOrder2', 'desc', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'asc=la_common_ascending\|\|desc=la_common_descending', 10.02, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Perpage_Links', '10', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_perpage_prompt', 'text', '', '', 10.03, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Perpage_Links_Short', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_perpage_short_prompt', 'text', '', '', 10.04, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_NewDays', '100', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_newdays_prompt', 'text', '', '', 10.05, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_MinPopRating', '5', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MinPopRating', 'text', '', '', 10.06, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_MinPopVotes', '20', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MinPopVotes', 'text', '', '', 10.07, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_MaxHotNumber', '5', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MaxHotNumber', 'text', '', '', 10.08, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_EnhancedLinks', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_EnhancedLinks', 'checkbox', '', '', 10.09, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_AllowFreeListings', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_AllowFreeListings', 'checkbox', '', '', 10.1, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_ShowPick', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_editorspick_prompt', 'checkbox', '', '', 10.11, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_UrlStatus', '', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_urlstatus_prompt', 'checkbox', '', '', 10.12, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'link_ReviewDelay_Value', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupReviews', 'text', '', 'style="width: 50px;"', 10.13, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'link_ReviewDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupReviews', 'select', '', '1=la_opt_Sec\|\|60=la_opt_Min\|\|3600=la_opt_Hour\|\|86400=la_opt_Day\|\|604800=la_opt_Week\|\|2419200=la_opt_Month\|\|29030400=la_opt_Year', 10.13, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'link_RatingDelay_Value', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupRating', 'text', '', 'style="width: 50px;"', 10.14, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'link_RatingDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupRating', 'select', '', '1=la_opt_Sec\|\|60=la_opt_Min\|\|3600=la_opt_Hour\|\|86400=la_opt_Day\|\|604800=la_opt_Week\|\|2419200=la_opt_Month\|\|29030400=la_opt_Year', 10.14, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_MaxCategories', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_MaxCategories', 'text', NULL, NULL, 10.15, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_EnableGoogleMaps', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_LinkEnableGoogleMaps', 'checkbox', NULL, NULL, 10.16, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_GoogleMapsAPIKey', '', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_LinkGoogleMapsAPIKey', 'text', NULL, NULL, 10.17, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_EnableLinkContactForm', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_config_EnableLinkContactForm', 'checkbox', NULL, NULL, 10.18, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'ReciprocalLinkChecking', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_config_ReciprocalLinkChecking', 'checkbox', NULL, NULL, 10.19, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_ReviewsSort', 'CreatedOn', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'ReviewText=la_opt_CommentText\|\|CreatedOn=la_opt_CreatedOn', 20.01, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_ReviewsOrder', 'desc', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'asc=la_common_Ascending\|\|desc=la_common_Descending', 20.01, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_ReviewsSort2', 'ReviewText', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'ReviewText=la_opt_CommentText\|\|CreatedOn=la_opt_CreatedOn', 20.02, 1, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Link_ReviewsOrder2', 'asc', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'asc=la_common_Ascending\|\|desc=la_common_Descending', 20.02, 2, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Perpage_LinkReviews', '10', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_review_perpage_prompt', 'text', NULL, NULL, 20.03, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Perpage_LinkReviews_Short', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_review_perpage_short_prompt', 'text', NULL, NULL, 20.04, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_CategoryTemplate', '/in-link/designs/section', 'In-Link', 'in-link:configuration_output', 'la_section_Templates', 'la_fld_CategoryTemplate', 'text', '', '', 30.01, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_ItemTemplate', 'in-link/designs/detail', 'In-Link', 'in-link:configuration_output', 'la_section_Templates', 'la_fld_ItemTemplate', 'text', '', '', 30.02, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_MaxImageCount', '5', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_MaxImageCount', 'text', '', '', 40.01, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_ThumbnailImageWidth', '120', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_ThumbnailImageWidth', 'text', '', '', 40.02, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_ThumbnailImageHeight', '120', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_ThumbnailImageHeight', 'text', '', '', 40.03, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_FullImageWidth', '450', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_FullImageWidth', 'text', '', '', 40.04, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'l_FullImageHeight', '450', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_FullImageHeight', 'text', '', '', 40.05, 0, 0, NULL);

	# Section "in-link:configuration_search":
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_LinkId', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_ReviewById', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Priority', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Status', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_EditorsPick', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_ResourceId', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_HotItem', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_PopItem', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_NewItem', '1', 'In-Link', 'in-link:configuration_search', '', '', '', NULL, NULL, 0, 0, 0, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'SearchRel_Keyword_links', '90', 'In-Link', 'in-link:configuration_search', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'SearchRel_Pop_links', '5', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'SearchRel_Rating_links', '5', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'SearchRel_Increase_links', '30', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_ShowMultiple_links', '0', 'In-Link', 'in-link:configuration_search', 'la_config_ShowMultiple', 'la_Text_MultipleShow', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Description', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_Description', 'checkbox', '', '', 1, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Name', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_Name', 'checkbox', '', '', 2, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Url', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_Url', 'checkbox', '', '', 5, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_CreatedOn', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_CreatedOn', 'checkbox', '', '', 5, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_Hits', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_Hits', 'checkbox', '', '', 6, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_CatchedRating', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_CatchedRating', 'checkbox', '', '', 7, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_CatchedVotesQty', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_CatchedVotesQty', 'checkbox', '', '', 8, 0, 1, NULL);
	INSERT INTO ConfigurationValues VALUES(DEFAULT, 'Search_Link_CatchedReviewsQty', '1', 'In-Link', 'in-link:configuration_search', 'la_Text_Link_Search', 'la_Link_CatchedReviewsQty', 'checkbox', '', '', 9, 0, 1, NULL);

	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ADD', NULL, 1, 1, NULL, 'In-Link', 'Add Link', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ADD', NULL, 1, 0, NULL, 'In-Link', 'Add Link', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'Add Pending Link', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ADD.PENDING', NULL, 1, 1, NULL, 'In-Link', 'Add Pending Link', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 1, NULL, 'In-Link', 'Modify Link', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 0, NULL, 'In-Link', 'Modify Link', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY.PENDING', NULL, 1, 0, NULL, 'In-Link', 'Link Modification Pending', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY.PENDING', NULL, 1, 1, NULL, 'In-Link', 'Link Modification Pending', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'Approve Link Modification', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.MODIFY.DENY', NULL, 1, 0, NULL, 'In-Link', 'Decline link modification', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'Approve Pending Link', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.DENY', NULL, 1, 0, NULL, 'In-Link', 'Deny Link', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 1, NULL, 'In-Link', 'Link Comment Added', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 0, NULL, 'In-Link', 'Link Comment Added', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'Link Comment Pending', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'Link Comment Pending', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'Link Comment Approved', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.REVIEW.DENY', NULL, 1, 0, NULL, 'In-Link', 'Link Comment Declined', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement submitted', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement submitted', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.APPROVE', NULL, 0, 0, NULL, 'In-Link', 'Link enhancement approved', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement approved', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.DENY', NULL, 0, 0, NULL, 'In-Link', 'Link enhancement denied', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.DENY', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement denied', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.EXPIRE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement expired', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.EXPIRE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement expired', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.EXTEND', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement renewal submitted', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.EXTEND', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement renewal submitted', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEW', NULL, 0, 0, NULL, 'In-Link', 'Link enhancement extended', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEW', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement extended', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEW.FAILED', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement renewal failed', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEW.FAILED', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement renewal failed', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.CANCEL', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement cancelled', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.CANCEL', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement cancelled', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEWAL.NOTICE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement is about to expire', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.ENHANCE.RENEWAL.NOTICE', NULL, 1, 0, NULL, 'In-Link', 'Link enhancement is about to expire', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.CONTACTFORM', NULL, 1, 0, NULL, 'In-Link', 'Link Contact Form', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.CONTACTFORM', NULL, 1, 0, NULL, 'In-Link', 'Link Contact Form', 0);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.RECIPROCAL.CHECK.FAILED', NULL, 1, 0, NULL, 'In-Link', 'Reciprocal Check Failed', 1);
	INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, FromUserId, Module, Description, Type) VALUES(DEFAULT, 'LINK.VALIDATION.RESULTS', NULL, 1, 0, NULL, 'In-Link', 'Link Validation Results', 1);

	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkAddress', 'lu_fld_LinkAddress', 0, 'la_section_BusinessLocation', 'la_fld_LinkAddress', 'text', 'size="40"', '', 1, 1, 0, 0);
	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkCity', 'lu_fld_LinkCity', 0, 'la_section_BusinessLocation', 'la_fld_LinkCity', 'text', 'size="40"', '', 2, 1, 0, 0);
	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkZipCode', 'lu_fld_LinkZipCode', 0, 'la_section_BusinessLocation', 'la_fld_LinkZipCode', 'text', NULL, '', 4, 1, 0, 0);
	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkState', 'lu_fld_LinkState', 0, 'la_section_BusinessLocation', 'la_fld_LinkState', 'select', '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 2 ORDER BY StateCountryId DESC, IsoCode ASC</SQL>', '', 3, 1, 0, 0);
	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkCountry', 'lu_fld_LinkCountry', 0, 'la_section_BusinessLocation', 'la_fld_LinkCountry', 'select', '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 1 ORDER BY IsoCode ASC</SQL>', '', 5, 1, 0, 0);
	INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkPhone', 'lu_fld_LinkPhone', 0, 'la_section_BusinessLocation', 'la_fld_LinkPhone', 'text', NULL, '', 6, 1, 0, 0);

	INSERT INTO ItemTypes VALUES (4, 'In-Link', 'l', 'Link', 'Name', 'CreatedById', 'Hits', 'CachedRating', 'la_ItemTab_Links', 1, 'in-link/admin/addlink.php', 'clsLink', 'Link');

	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.ADD', 'lu_PermName_Link.Add_desc', 'lu_PermName_Link.Add_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.VIEW', 'lu_PermName_Link.View_desc', 'lu_PermName_Link.View_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.ADD.PENDING', 'lu_PermName_Link.Add.Pending_desc', 'lu_PermName_Link.Add.Pending_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.MODIFY', 'lu_PermName_Link.Modify_desc', 'lu_PermName_Link.Modify_desc', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.DELETE', 'lu_PermName_Link.Delete_desc', 'lu_PermName_Link.Delete_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.RATE', 'lu_PermName_Link.Rate_desc', 'lu_PermName_Link.Rate_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.REVIEW', 'lu_PermName_Link.Review_desc', 'lu_PermName_Link.Review_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.REVIEW.PENDING', 'lu_PermName_Link.Review_Pending_desc', ' lu_PermName_Link.Review_Pending_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.MODIFY.PENDING', 'lu_PermName_Link.Modify.Pending_desc', 'lu_PermName_Link.Modify.Pending_desc', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 'lu_PermName_Link.Owner.Modify_desc', 'lu_PermName_Link.Owner.Modify_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 'lu_PermName_Link.Owner.Modify.Pending_desc', 'lu_PermName_Link.Owner.Modify.Pending_error', 'In-Link');
	INSERT INTO PermissionConfig VALUES (DEFAULT, 'LINK.OWNER.DELETE', 'lu_PermName_Link.Owner.Delete_desc', 'lu_PermName_Link.Owner.Delete_error', 'In-Link');

	INSERT INTO SearchConfig VALUES ('Link', 'OrgId', 0, 0, 'lu_fielddesc_link_orgid', 'lu_field_orgid', 'In-Link', 'la_text_link', 19, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'NewItem', 0, 1, 'lu_fielddesc_link_newitem', 'lu_field_newitem', 'In-Link', 'la_text_link', 18, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'PopItem', 0, 1, 'lu_fielddesc_link_popitem', 'lu_field_popitem', 'In-Link', 'la_text_link', 17, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'HotItem', 0, 1, 'lu_fielddesc_link_hotitem', 'lu_field_hotitem', 'In-Link', 'la_text_link', 16, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'ResourceId', 0, 1, 'lu_fielddesc_link_resourceid', 'lu_field_resourceid', 'In-Link', 'la_text_link', 15, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'EditorsPick', 0, 1, 'lu_fielddesc_link_editorspick', 'lu_field_editorspick', 'In-Link', 'la_text_link', 14, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Status', 0, 0, 'lu_fielddesc_link_status', 'lu_field_status', 'In-Link', 'la_text_link', 13, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Priority', 0, 0, 'lu_fielddesc_link_priority', 'lu_field_priority', 'In-Link', 'la_text_link', 12, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'ModifiedById', 0, 0, 'lu_fielddesc_link_modifiedbyid', 'lu_field_modifiedbyid', 'In-Link', 'la_text_link', 11, DEFAULT, 0, 'text', 'PortalUser.Login', '{ForeignTable}.PortalUserId={LocalTable}.ModifiedById', NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CreatedById', 0, 0, 'lu_fielddesc_link_createdbyid', 'lu_field_createdbyid', 'In-Link', 'la_text_link', 10, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CachedReviewsQty', 0, 0, 'lu_fielddesc_link_cachedreviewsqty', 'lu_field_cachedreviewsqty', 'In-Link', 'la_text_link', 9, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CachedVotesQty', 0, 0, 'lu_fielddesc_link_cachedvotesqty', 'lu_field_cachedvotesqty', 'In-Link', 'la_text_link', 8, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'LinkId', 0, 1, 'lu_fielddesc_link_linkid', 'lu_field_linkid', 'In-Link', 'la_text_link', 0, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Name', 1, 1, 'lu_fielddesc_link_name', 'lu_field_name', 'In-Link', 'la_text_link', 1, DEFAULT, 1, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Description', 1, 1, 'lu_fielddesc_link_description', 'lu_field_description', 'In-Link', 'la_text_link', 2, DEFAULT, 1, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Url', 1, 1, 'lu_fielddesc_link_url', 'lu_field_url', 'In-Link', 'la_text_link', 3, DEFAULT, 2, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CreatedOn', 0, 1, 'lu_fielddesc_link_createdon', 'lu_field_createdon', 'In-Link', 'la_text_link', 4, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Modified', 0, 1, 'lu_fielddesc_link_modified', 'lu_field_modified', 'In-Link', 'la_text_link', 5, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'Hits', 0, 1, 'lu_fielddesc_link_hits', 'lu_field_hits', 'In-Link', 'la_text_link', 6, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CachedRating', 0, 0, 'lu_fielddesc_link_cachedrating', 'lu_field_cachedrating', 'In-Link', 'la_text_link', 7, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT() AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
	INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);

	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 14, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 14, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 12, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 12, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 13, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 13, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 11, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.ADD', 11, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.DELETE', 11, 1, 0, {LinkCatId});
	-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.MODIFY', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 11, 1, 0, {LinkCatId});
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW.PENDING', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY.PENDING', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 15, 0, 0, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:links.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:setting_folder.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.add', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.delete', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.add', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.delete', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.add', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.add', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.delete', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:approve', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:decline', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.add', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.edit', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.delete', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:continue', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:restart', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:validate', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:reset', 11, 1, 1, 0);

	INSERT INTO ImportScripts VALUES (DEFAULT, 'Links from CSV file [In-Link]', '', 'l', 'In-Link', '', 'CSV', '1');

	INSERT INTO CustomField VALUES (DEFAULT, 1, 'l_ItemTemplate', 'la_fld_cust_l_ItemTemplate ', 0, 'la_title_SystemCF', 'la_fld_cust_l_ItemTemplate ', 'text', NULL, '', 0, 0, 1, 0);

	INSERT INTO Counters VALUES (DEFAULT, 'linkhits_count', 'SELECT ROUND(SUM(Hits)) FROM <%PREFIX%>Link', NULL, NULL, '300', '0', '\|Link\|');

	INSERT INTO Modules VALUES ('In-Link', 'modules/in-link/', 'l', DEFAULT, 1, 1, 'in-link/', 2, NULL);
	Index: branches/5.1.x
	===================================================================
	--- branches/5.1.x (revision 13549)
	+++ branches/5.1.x (revision 13550)

	Property changes on: branches/5.1.x
	___________________________________________________________________
	Modified: svn:mergeinfo
	## -0,0 +0,2 ##
	Merged /modules/in-link/branches/5.0.x:r13075-13506
	Merged /modules/in-link/releases/5.0.3:r13507-13549

in-linkNo OneTemporaryActions

File Metadata

in-linkView Options

Event Timeline

in-link
No OneTemporary
Actions

in-link
View Options