Page MenuHomeIn-Portal Phabricator
Files F1203791

in-link
No OneTemporary
Actions

File Metadata

Created
Mon, Nov 3, 8:35 PM

in-link
View Options

Index: branches/5.0.x/in-link/units/listings/listings_event_handler.php
===================================================================
--- branches/5.0.x/in-link/units/listings/listings_event_handler.php (revision 12424)
+++ branches/5.0.x/in-link/units/listings/listings_event_handler.php (revision 12425)
@@ -1,775 +1,770 @@
<?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.net/license/ for copyright notices and details.
*/
defined('FULL_PATH') or die('restricted access!');
class ListingsEventHandler extends kDBEventHandler {
/**
* Allows to override standart permission mapping
*
*/
function mapPermissions()
{
parent::mapPermissions();
$permissions = Array(
// front
'OnRequestEnhancement' => Array ('self' => true),
'OnCancelEnhancement' => Array ('self' => true),
'OnExtendEnhancement' => Array ('self' => true),
);
$this->permMapping = array_merge($this->permMapping, $permissions);
}
/**
* Adds selected link to listing
*
* @param kEvent $event
*/
function OnProcessSelected(&$event)
{
$object =& $event->getObject();
$selected_ids = $this->Application->GetVar('selected_ids');
if ($selected_ids['l']) {
$link_id = $selected_ids['l'];
$sql = 'SELECT ResourceId
FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE '.$this->Application->getUnitOption('l', 'IDField').' = '.$link_id;
$object->SetDBField($this->Application->RecallVar('dst_field'), $this->Conn->GetOne($sql));
$object->IgnoreValidation = true;
// $this->RemoveRequiredFields($object);
$object->Update();
}
$this->finalizePopup($event);
}
function OnPreSaveListing(&$event)
{
$event->redirect=false;
$object =& $event->getObject( Array('skip_autoload' => true) );
$object->IgnoreValidation = true;
// $this->RemoveRequiredFields($object);
$event->CallSubEvent('OnPreSave');
$this->Application->SetVar($event->getPrefixSpecial(true).'_id', $object->GetId());
return;
}
function OnBeforeItemUpdate(&$event)
{
$object =& $event->getObject();
- if($object->IgnoreValidation)
- {
+ if ($object->IgnoreValidation) {
$object->UpdateFormattersMasterFields();
}
}
function OnBeforeItemCreate(&$event)
{
$object =& $event->getObject();
- if($object->IgnoreValidation)
- {
+ if ($object->IgnoreValidation) {
$object->UpdateFormattersMasterFields();
}
}
/**
* Enter description here...
*
* @param kEvent $event
*/
function OnBeforeDeleteFromLive(&$event)
{
$object =& $event->getObject();
$sql = 'SELECT * FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
WHERE ListingId = '.$object->GetId();
$original_values = $this->Conn->GetRow($sql);
$type_modified = ($object->GetDBField('ListingTypeId') != $original_values['ListingTypeId']);
$link_modified = ($object->GetDBField('ItemResourceId') != $original_values['ItemResourceId']);
$status_modified = ($object->GetDBField('Status') != $original_values['Status']);
- if($status_modified)
- {
- $email_event = $object->GetDBField('Status') ? 'LINK.ENHANCE.APPROVE' : 'LINK.ENHANCE.APPROVE';
+ if ($status_modified) {
+ $email_event = $object->GetDBField('Status') ? 'LINK.ENHANCE.APPROVE' : 'LINK.ENHANCE.DENY';
$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
+
$email_event_user =& $this->Application->EmailEventUser($email_event, $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin($email_event);
}
- if( $type_modified || $link_modified )
- {
+ if ( $type_modified || $link_modified ) {
$this->ResetLink($original_values);
}
- if( $status_modified || $type_modified || $link_modified )
- {
+ if ( $status_modified || $type_modified || $link_modified ) {
$this->EnhanceLink($object, $original_values);
}
- if( $status_modified && !($type_modified || $link_modified) )
- {
+ if ( $status_modified && !($type_modified || $link_modified) ) {
$this->ResetLink($original_values);
}
}
function EnhanceLink(&$object, $original_values)
{
if ($object->GetDBField('Status') != STATUS_ACTIVE) {
return false;
}
if ($object->GetDBField('ExpiresOn') < adodb_mktime()) {
$object->SetDBField('Status', STATUS_PENDING);
$object->Update();
$this->ResetLink($original_values);
return false;
}
$this->UpdateLink('OnPurchase', $object->GetDBField('ItemResourceId'), $object->GetDBField('ListingTypeId'));
$listtype_object =& $this->Application->recallObject('lst');
- if( $listtype_object->GetDBField('OnPurchaseAddToCatEnabled') )
+ if ( $listtype_object->GetDBField('OnPurchaseAddToCatEnabled') )
{
$link_object =& $this->Application->recallObject('l');
$add_to_cat = (int)$listtype_object->GetDBField('OnPurchaseAddToCat');
$sql = 'DELETE FROM '.$this->Application->getUnitOption('l-ci', 'TableName').'
WHERE CategoryId = '.$add_to_cat.'
AND ItemResourceId = '.$link_object->GetDBField('ResourceId').'
AND PrimaryCat = 0';
$this->Conn->Query($sql);
$sql = 'INSERT INTO '.$this->Application->getUnitOption('l-ci', 'TableName').'
(CategoryId, ItemResourceId, PrimaryCat)
VALUES ('.$add_to_cat.', '.$link_object->GetDBField('ResourceId').', 0)';
$this->Conn->Query($sql);
}
}
function ResetLink($original_values)
{
static $has_been_reset = Array();
if( $original_values['Status'] != STATUS_ACTIVE ||
getArrayValue($has_been_reset, $original_values['ListingId']) )
{
return;
}
$has_been_reset[$original_values['ListingId']] = 1;
$this->UpdateLink('OnExpire', $original_values['ItemResourceId'], $original_values['ListingTypeId']);
$listtype_object =& $this->Application->recallObject('lst');
if( $listtype_object->GetDBField('OnExpireRemoveFromCatEnabled') )
{
$remove_from_cat = $listtype_object->GetDBField('OnExpireRemoveFromCat');
$sql = 'DELETE FROM '.$this->Application->getUnitOption('l-ci', 'TableName').'
WHERE ItemResourceId = '.$original_values['ItemResourceId'].'
AND CategoryId = '.$remove_from_cat.'
AND PrimaryCat = 0';
$this->Conn->Query($sql);
}
}
function UpdateLink($action_prefix, $resource_id, $listtype_id)
{
$link_object =& $this->Application->recallObject('l', null, Array('skip_autoload' => true));
$link_object->Load($resource_id, 'ResourceId');
// "-item", because can be called as regular after event, and just "lst" recalls list instead
$listtype_object =& $this->Application->recallObject('lst.-item', null, Array('skip_autoload' => true));
$listtype_object->Load($listtype_id);
$action_fields = Array( 'EdPick' => 'EditorsPick',
'New' => 'NewItem',
'Hot' => 'HotItem',
'Pop' => 'PopItem',
'Status' => 'Status',
'CustomTemplate' => 'CustomTemplate',
);
// $action_prefix = 'OnPurchase';
foreach($action_fields as $action => $field)
{
$action_value = $listtype_object->GetDBField($action_prefix.$action);
if( $action_value != 3 )
{
$link_object->SetDBField($field, $action_value);
}
}
$priority_value = $listtype_object->GetDBField($action_prefix.'PriorityValue');
switch( $listtype_object->GetDBField($action_prefix.'PriorityAction') )
{
case 1: // equal
$link_object->SetDBField('Priority', $priority_value);
break;
case 2: // increase
$original_priority = $link_object->GetDBField('Priority');
$link_object->SetDBField('Priority', $original_priority + $priority_value);
break;
case 3: // decrease
$original_priority = $link_object->GetDBField('Priority');
$link_object->SetDBField('Priority', $original_priority - $priority_value);
break;
default:
}
$link_object->Update();
}
/**
* Enter description here...
*
* @param kEvent $event
*/
function OnRequestEnhancement(&$event)
{
if ($this->Application->isModuleEnabled('In-Commerce')) {
$l_info = $this->Application->GetVar('l');
if (!$l_info) {
return false;
}
list ($link_id, $link_info) = each($l_info);
$listing_type_id = $link_info['ListingTypeId'];
$listing_type =& $this->Application->recallObject('lst', null, Array('skip_autoload' => true));
$listing_type->Load($listing_type_id);
if ($listing_type->GetDBField('EnableBuying')) {
$add_to_cart_event = new kEvent('ord:OnAddVirtualProductToCart');
$this->Application->HandleEvent($add_to_cart_event);
if ($add_to_cart_event->redirect) {
$event->SetRedirectParam('pass', 'm');
$event->redirect = $add_to_cart_event->redirect;
}
return true;
}
}
$event->CallSubEvent('OnListingCreate');
}
/**
* Create listing or extend existing listing period
*
* @param kEvent $event
*/
function OnListingCreate(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
switch ($event->Name) {
case 'EnhanceLinkAfterOrderApprove':
case 'EnhancedLinkOnCompleteOrder':
// when order with listing virtual product is approved
$fields = $event->getEventParam('field_values');
$item_data = unserialize($fields['ItemData']);
$listing_type_id = $item_data['ListingTypeId'];
$link_id = $item_data['LinkId'];
$new_processing = getArrayValue($item_data, 'HasNewProcessing');
break;
case 'OnListingCreate':
// when requesting enhancement from front (and not via in-commerce)
$links_info = $this->Application->GetVar('l');
if (!$links_info) return false;
$event->redirect = false;
list($link_id, $link_info) = each($links_info);
$listing_type_id = $link_info['ListingTypeId'];
$new_processing = false;
break;
}
if (!$listing_type_id) {
// free or invalid listing type selected
return false;
}
// get resource_id of link beeing enhanced
$sql = 'SELECT ResourceId
FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE LinkId = '.$link_id;
$resource_id = $this->Conn->GetOne($sql);
// get listing by link's resource_id
$object->Load($resource_id, 'ItemResourceId');
if ($object->isLoaded()) {
$original_values = $object->FieldValues;
}
else {
// set initial fields to listing
$object->SetDBField('ListingTypeId', $listing_type_id);
$object->SetDBField('ItemResourceId', $resource_id);
if ($event->Name == 'OnListingCreate' || $new_processing) {
$item_status = STATUS_PENDING;
}
else {
$item_status = STATUS_ACTIVE;
}
$object->SetDBField('Status', $item_status);
}
// set date of purchase for new listings
$purchased_on = max(adodb_mktime(), $object->GetDBField('ExpiresOn'));
if (!$object->isLoaded()) {
$object->SetDBField('PurchasedOn_date', $purchased_on);
$object->SetDBField('PurchasedOn_time', $purchased_on);
}
// set expiration time for listing
$listing_type =& $this->Application->recallObject('lst', null, Array('skip_autoload' => true));
$listing_type->Load($listing_type_id);
$dur_type_mapping = Array( 1 => 1,
2 => 60,
3 => 3600,
4 => 3600*24,
5 => 3600*24*7,
6 => 3600*24*365/12,
7 => 3600*24*365
);
$duration = $listing_type->GetDBField('Duration');
$duration_type = $listing_type->GetDBField('DurationType');
$expiration_interval = $duration * $dur_type_mapping[$duration_type];
$expiration_date = $purchased_on + $expiration_interval;
$object->SetDBField('ExpiresOn_date', $expiration_date);
$object->SetDBField('ExpiresOn_time', $expiration_date);
// when extending enhancement mark listing as non-received renewal reminder
$object->SetDBField('RenewalReminderSent', 0);
$action = $object->isLoaded() ? 'Update' : 'Create';
if ($object->$action()) {
$event->status = erSUCCESS;
switch ($event->Name) {
case 'EnhanceLinkAfterOrderApprove':
case 'EnhancedLinkOnCompleteOrder':
// when order with listing virtual product is approved
if (getArrayValue($original_values, 'Status') != STATUS_ACTIVE) {
$this->EnhanceLink($object, Array());
}
break;
case 'OnListingCreate':
// when requesting enhancement from front (and not via in-commerce)
$event->redirect = $this->Application->GetVar('success_template');
$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE', $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE');
break;
}
}
else {
$event->status = erFAIL;
}
}
/**
* Enter description here...
*
* @param kEvent $event
*/
function EnhancedLinkOnCompleteOrder(&$event)
{
// create enhancement, but pending
$this->OnListingCreate($event);
// save created listing_id back to itemdata
$object =& $event->getObject( Array('skip_autoload' => true) );
$fields = $event->getEventParam('field_values');
$item_data = unserialize($fields['ItemData']);
unset($item_data['ListingTypeId']);
$item_data['ListingId'] = $object->GetID();
$orditems_idfield = $this->Application->getUnitOption('orditems', 'IDField');
$orditems_table = $this->Application->getUnitOption('orditems', 'TableName');
$this->Conn->doUpdate( Array('ItemData' => serialize($item_data)), $orditems_table, $orditems_idfield.' = '.$fields['OrderItemId'] );
}
/**
* Enter description here...
*
* @param kEvent $event
*/
function EnhanceLinkAfterOrderApprove(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
$fields = $event->getEventParam('field_values');
$item_data = unserialize($fields['ItemData']);
if ( getArrayValue($item_data, 'HasNewProcessing') ) {
// new processing: just approve created listing here
$listing_id = $item_data['ListingId'];
$object->Load($listing_id);
// moved enhancement period to time admin approved enhancement
$time_diff = adodb_mktime() - $object->GetDBField('PurchasedOn');
$object->SetDBField('PurchasedOn_date', $object->GetDBField('PurchasedOn_date') + $time_diff);
$object->SetDBField('PurchasedOn_time', $object->GetDBField('PurchasedOn_time') + $time_diff);
$object->SetDBField('ExpiresOn_date', $object->GetDBField('ExpiresOn_date') + $time_diff);
$object->SetDBField('ExpiresOn_time', $object->GetDBField('ExpiresOn_time') + $time_diff);
$object->SetDBField('Status', STATUS_ACTIVE);
$object->Update();
$this->EnhanceLink($object, Array());
return true;
}
else {
// create listing & approve it at the same time
$this->OnListingCreate($event);
}
}
/**
* Delete listing
*
* @param kEvent $event
*/
function EnhanceLinkAfterOrderDeny(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
$fields = $event->getEventParam('field_values');
$item_data = unserialize($fields['ItemData']);
$listing_id = $item_data['ListingId'];
$temp_handler =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
$temp_handler->DeleteItems($event->Prefix, $event->Special, Array($listing_id));
}
/**
* Enter description here...
*
* @param kEvent $event
*/
function ExpireLink(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
$fields = $event->getEventParam('field_values');
$item_data = unserialize($fields['ItemData']);
$sql = 'SELECT ListingId FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
WHERE ItemResourceId = '.$item_data['LinkId'];
$listing_id = $this->Conn->GetOne($sql);
$object->Load($listing_id);
$original_values = $object->FieldValues;
$object->SetDBField('Status', 2);
if($object->Update())
{
$event->status = erSUCCESS;
$this->ResetLink($original_values);
}
else
{
$event->status = erFAIL;
}
}
function iterateItems(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
$ids = $this->StoreSelectedIDs($event);
if ($event->Name == 'OnMassApprove') {
foreach ($ids as $id) {
$object->Load($id);
if ($object->GetDBField('Status') != STATUS_ACTIVE) {
$original_values = $object->FieldValues;
$object->SetDBField('Status', STATUS_ACTIVE);
$this->EnhanceLink($object, $original_values);
}
}
}
if ($event->Name == 'OnMassDecline') {
foreach ($ids as $id) {
$object->Load($id);
if ($object->GetDBField('Status') == STATUS_ACTIVE) {
$original_values = $object->FieldValues;
$this->ResetLink($original_values);
$sql = 'SELECT CreatedById
FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.DENY', $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.DENY');
}
}
}
parent::iterateItems($event);
// extend period for pending/renewal links (if owner has agreed)
if ($event->Name == 'OnMassApprove') {
$lst_object =& $this->Application->recallObject('lst', null, Array('skip_autoload' => true));
foreach ($ids as $id) {
$object->Load($id);
$sql = 'SELECT CreatedById
FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$owner_id = $this->Conn->GetOne($sql);
if ($object->GetDBField('PendingRenewal') == 1) {
$lst_object->Load( $object->GetDBField('ListingTypeId') );
$dur_type_mapping = Array( 1 => 1,
2 => 60,
3 => 3600,
4 => 3600*24,
5 => 3600*24*7,
6 => 3600*24*365/12,
7 => 3600*24*365
);
$duration = $lst_object->GetDBField('Duration');
$duration_type = $lst_object->GetDBField('DurationType');
$expiration_interval = $duration * $dur_type_mapping[$duration_type];
$renewal_begins = max( adodb_mktime(), $object->GetDBField('ExpiresOn') );
$expiration_date = $renewal_begins + $expiration_interval;
$object->SetDBField('ExpiresOn_date', $expiration_date);
$object->SetDBField('ExpiresOn_time', $expiration_date);
$object->SetDBField('RenewalReminderSent', 0);
$object->SetDBField('PendingRenewal', 0);
if ($object->Update()) {
$event->status = erSUCCESS;
$event->redirect_params = Array('opener' => 's'); //stay!
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.RENEW', $owner_id);
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.RENEW');
}
else {
$event->status=erFAIL;
$event->redirect=false;
break;
}
}
else {
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.APPROVE', $owner_id);
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.APPROVE');
}
}
}
}
/**
* Redirects to cancel template on front-end
*
* @param kEvent $event
*/
function OnCancel(&$event)
{
parent::OnCancel($event);
if (!$this->Application->IsAdmin()) {
$event->SetRedirectParam('opener', 's');
$event->redirect = $this->Application->GetVar('cancel_template');
}
}
/**
* Checks that user is owner of link & returns listing id if permissions are ok
*
* @param kEvent $event
* @return mixed
*/
function verifyListingOwner(&$event)
{
$link_id = $this->Application->GetVar('l_id');
$user_id = $this->Application->RecallVar('user_id');
$sql = 'SELECT ResourceId
FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE (LinkId = '.$link_id.') AND (CreatedById = '.$user_id.')';
$resource_id = $this->Conn->GetOne($sql);
if (!$resource_id) {
$event->status = erFAIL;
return false;
}
$sql = 'SELECT ListingId
FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
WHERE ItemResourceId = '.$resource_id;
return $this->Conn->GetOne($sql);
}
function OnExtendEnhancement(&$event)
{
$listing_id = $this->verifyListingOwner($event);
if (!$listing_id) {
return ;
}
$object =& $event->getObject( Array('skip_autoload' => true) );
$object->Load($listing_id);
$object->SetDBField('PendingRenewal', 1);
$object->Update();
$event->redirect = $this->Application->GetVar('success_template');
$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.EXTEND', $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.EXTEND');
}
function OnCancelEnhancement(&$event)
{
$listing_id = $this->verifyListingOwner($event);
if (!$listing_id) {
return ;
}
$object =& $event->getObject( Array('skip_autoload' => true) );
$object->Load($listing_id);
$original_values = $object->FieldValues;
$original_values['Status'] = 1;
$this->ResetLink($original_values);
$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.CANCEL', $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.CANCEL');
$object->Delete();
$event->redirect = $this->Application->GetVar('success_template');
}
function OnCheckExpiredPaidListings(&$event)
{
$sql = 'SELECT ListingId FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
WHERE ExpiresOn < '.adodb_mktime().' AND Status = 1';
$expired_listings = $this->Conn->GetCol($sql);
if(is_array($expired_listings) && count($expired_listings) > 0)
{
$object =& $this->Application->recallObject($event->Prefix.'.-item', null, Array('skip_autoload' => true));
foreach($expired_listings as $listing_id)
{
$object->Load($listing_id);
$original_values = $object->FieldValues;
$this->ResetLink($original_values);
$object->SetDBField('Status', 2);
$object->Update();
$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.EXPIRE', $this->Conn->GetOne($sql));
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.EXPIRE');
}
}
$sql = 'SELECT ls.ListingId, l.CreatedById FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').' ls
LEFT JOIN '.$this->Application->getUnitOption('lst', 'TableName').' lst
ON ls.ListingTypeId = lst.ListingTypeId
LEFT JOIN '.$this->Application->getUnitOption('l', 'TableName').' l
ON ls.ItemResourceId = l.ResourceId
WHERE ls.Status = 1
AND ls.ExpiresOn < '.adodb_mktime().' + lst.RenewalReminder * 3600 *24
AND ls.RenewalReminderSent = 0';
$res = $this->Conn->Query($sql);
if(is_array($res) && count($res) > 0)
{
$listing_ids = Array();
foreach($res as $record)
{
$email_event_user =& $this->Application->EmailEventUser('LINK.ENHANCE.RENEWAL.NOTICE', $record['CreatedById']);
$email_event_admin =& $this->Application->EmailEventAdmin('LINK.ENHANCE.RENEWAL.NOTICE');
$listing_ids[] = $record['ListingId'];
}
$sql = 'UPDATE '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
SET RenewalReminderSent = 1
WHERE ListingId IN ('.implode(',', $listing_ids).')';
$this->Conn->Query($sql);
}
}
function OnMassDelete(&$event)
{
$object =& $event->getObject( Array('skip_autoload' => true) );
$ids = $this->StoreSelectedIDs($event);
foreach($ids as $id)
{
$object->Load($id);
if($object->GetDBField('Status') == 1)
{
$original_values = $object->FieldValues;
$this->ResetLink($original_values);
}
}
parent::OnMassDelete($event);
}
/**
* Moves enhancement from original link to it's pending copy, that is going to be approved
*
* @param kEvent $event
*/
function OnMoveEnhancement(&$event)
{
$id_field = $this->Application->getUnitOption($event->MasterEvent->Prefix, 'IDField');
$item_table_name = $this->Application->getUnitOption($event->MasterEvent->Prefix, 'TableName');
$pending_id = $event->MasterEvent->getEventParam('id');
$original_id = $event->MasterEvent->getEventParam('original_id');
$sql = 'SELECT ResourceId, '.$id_field.'
FROM '.$item_table_name.'
WHERE '.$id_field.' IN ('.$pending_id.','.$original_id.')';
$resource_ids = $this->Conn->GetCol($sql, $id_field);
$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
$sql = 'UPDATE '.$table_name.'
SET ItemResourceId = '.$resource_ids[$pending_id].'
WHERE ItemResourceId = '.$resource_ids[$original_id];
$this->Conn->Query($sql);
}
/**
* Makes calcualated fields to go to multilingual link fields
*
* @param kEvent $event
*/
function OnAfterConfigRead(&$event)
{
parent::OnAfterConfigRead($event);
$language_id = $this->Application->GetVar('m_lang');
$calculated_fields = $this->Application->getUnitOption($event->Prefix, 'CalculatedFields');
$calculated_fields['']['LinkName'] = 'CONCAT(item_table.l' . $language_id . '_Name, " (", item_table.Url, ")")';
$this->Application->setUnitOption($event->Prefix, 'CalculatedFields', $calculated_fields);
}
}
\ No newline at end of file
Index: branches/5.0.x/in-link/install/upgrades.php
===================================================================
--- branches/5.0.x/in-link/install/upgrades.php (revision 12424)
+++ branches/5.0.x/in-link/install/upgrades.php (revision 12425)
@@ -1,119 +1,136 @@
<?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.net/license/ for copyright notices and details.
*/
defined('FULL_PATH') or die('restricted access!');
$upgrade_class = 'InLinkUpgrades';
/**
* Class, that holds all upgrade scripts for "Core" module
*
*/
class InLinkUpgrades extends kHelper {
/**
* Install toolkit instance
*
* @var kInstallToolkit
*/
var $_toolkit = null;
/**
* Sets common instance of installator toolkit
*
* @param kInstallToolkit $instance
*/
function setToolkit(&$instance)
{
$this->_toolkit =& $instance;
}
/**
* Changes table structure, where multilingual fields of TEXT type are present
*
* @param string $mode when called mode {before, after)
*/
function Upgrade_5_0_0($mode)
{
if ($mode == 'after') {
$root_category = $this->Application->findModule('Name', 'In-Link', 'RootCat');
$sql = 'UPDATE ' . $this->Application->getUnitOption('c', 'TableName') . '
SET UseMenuIconUrl = 1, MenuIconUrl = "in-link/img/menu_links.gif"
WHERE ' . $this->Application->getUnitOption('c', 'IDField') . ' = ' . $root_category;
$this->Conn->Query($sql);
$this->_updateDetailTemplate('l', 'inlink/detail', 'in-link/designs/detail');
// copy link name and description to their multilingual equivalents
$this->_copyToMultilingual();
}
}
/**
* Copy link values from normal fields to multilingual
*
*/
function _copyToMultilingual()
{
$fields = Array ('Name', 'Description');
$primary_language = $this->Application->GetDefaultLanguageId();
$set_clause = Array ();
foreach ($fields as $field) {
$set_clause[] = 'l' . $primary_language . '_' . $field . ' = ' . $field;
}
$sql = 'UPDATE ' . TABLE_PREFIX . 'Link
SET ' . implode(', ', $set_clause);
$this->Conn->Query($sql);
}
/**
* Replaces deprecated detail template design with new one
*
* @param string $prefix
* @param string $from_template
* @param string $to_template
*/
function _updateDetailTemplate($prefix, $from_template, $to_template)
{
$sql = 'SELECT CustomFieldId
FROM ' . TABLE_PREFIX . 'CustomField
WHERE FieldName = "' . $prefix . '_ItemTemplate"';
$custom_field_id = $this->Conn->GetOne($sql);
$ml_formatter =& $this->Application->recallObject('kMultiLanguage');
/* @var $ml_formatter kMultiLanguage */
$field = $ml_formatter->LangFieldName('cust_' . $custom_field_id, true);
$sql = 'UPDATE ' . TABLE_PREFIX . 'CategoryCustomData
SET ' . $field . ' = "' . $to_template . '"
WHERE ' . $field . ' = "' . $from_template . '"';
$this->Conn->Query($sql);
}
/**
- * Update to 5.0.1, update details template
+ * Update to 5.0.1
*
* @param string $mode when called mode {before, after)
*/
function Upgrade_5_0_1($mode)
{
if ($mode == 'after') {
$this->_updateDetailTemplate('l', 'in-link/designs/detail', 'in-link/links/link_detail');
+
+ // delete old events
+ $events_to_delete = Array ( '"LINK.OWNER.MODIFY.PENDING"', '"LINK.OWNER.MODIFY"' );
+ $sql = 'SELECT EventId
+ FROM ' . TABLE_PREFIX . 'Events
+ WHERE Event IN (' . implode(',', $events_to_delete) . ')';
+
+ $event_ids = $this->Conn->GetCol($sql);
+
+ if ($event_ids) {
+ $sql = 'DELETE FROM EmailMessages WHERE EventId IN (' . implode(',', $event_ids) . ')';
+ $this->Conn->Query($sql);
+
+ $sql = 'DELETE FROM Events WHERE EventId IN (' . implode(',', $event_ids) . ')';
+ $this->Conn->Query($sql);
+ }
}
}
+
}
\ No newline at end of file
Index: branches/5.0.x/in-link/install/upgrades.sql
===================================================================
--- branches/5.0.x/in-link/install/upgrades.sql (revision 12424)
+++ branches/5.0.x/in-link/install/upgrades.sql (revision 12425)
@@ -1,55 +1,58 @@
# ===== 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 = 'Link_ReviewsSort';
UPDATE ConfigurationAdmin SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
WHERE VariableName = 'Link_ReviewsOrder';
UPDATE ConfigurationAdmin SET ValueList = 'ReviewText=la_opt_CommentText,CreatedOn=la_opt_CreatedOn'
WHERE VariableName = 'Link_ReviewsSort2';
UPDATE ConfigurationAdmin SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
WHERE VariableName = '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 = 'Link_SortField';
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 = '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 = 'link_ReviewDelay_Interval';
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 = 'link_RatingDelay_Interval';
UPDATE CustomField SET FieldLabel = 'la_fld_cust_l_ItemTemplate', Prompt = 'la_fld_cust_l_ItemTemplate' WHERE FieldName = 'l_ItemTemplate';
+
+DELETE FROM Events WHERE Event IN ('LINK.OWNER.MODIFY.PENDING', 'LINK.OWNER.MODIFY');
+DELETE FROM Phrase WHERE Phrase IN ('la_event_link.owner.modify', 'la_event_link.owner.modify.pending');
Index: branches/5.0.x/in-link/install/english.lang
===================================================================
--- branches/5.0.x/in-link/install/english.lang (revision 12424)
+++ branches/5.0.x/in-link/install/english.lang (revision 12425)
@@ -1,255 +1,250 @@
<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><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">RHVwbGljYXRlIENvdW50</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_event_link.link.contactform" Module="In-Link" Type="1">TGluayBDb250YWN0IEZvcm0=</PHRASE>
<PHRASE Label="la_event_link.link.enhance" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBzdWJtaXR0ZWQ=</PHRASE>
<PHRASE Label="la_event_link.link.enhance.approve" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBhcHByb3ZlZA==</PHRASE>
<PHRASE Label="la_event_link.link.enhance.deny" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBkZW5pZWQ=</PHRASE>
<PHRASE Label="la_event_link.link.enhance.expire" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBleHBpcmVk</PHRASE>
<PHRASE Label="la_event_link.link.enhance.extend" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCByZW5ld2FsIHN1Ym1pdHRlZA==</PHRASE>
<PHRASE Label="la_event_link.link.enhance.renew" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBleHRlbmRlZA==</PHRASE>
<PHRASE Label="la_event_link.link.enhance.renewal_notice" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBpcyBhYm91dCB0byBleHBpcmU=</PHRASE>
<PHRASE Label="la_event_link.link.enhance.renew_cancel" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCBjYW5jZWxsZWQ=</PHRASE>
<PHRASE Label="la_event_link.link.enhance.renew_failed" Module="In-Link" Type="1">TGluayBlbmhhbmNlbWVudCByZW5ld2FsIGZhaWxlZA==</PHRASE>
- <PHRASE Label="la_event_link.owner.modify" Module="In-Link" Type="1">TGluayBPd25lciBNb2RpZnk=</PHRASE>
- <PHRASE Label="la_event_link.owner.modify.pending" Module="In-Link" Type="1">TGluayBPd25lciBNb2RpZnkgUGVuZGluZw==</PHRASE>
+ <PHRASE Label="la_event_link.modify" Module="In-Link" Type="1">TW9kaWZ5IExpbms=</PHRASE>
<PHRASE Label="la_event_Link.Reciprocal.Check.Failed" Module="In-Link" Type="1">UmVjaXByb2NhbCBDaGVjayBGYWlsZWQ=</PHRASE>
<PHRASE Label="la_event_link.review.add" Module="In-Link" Type="1">TGluayBDb21tZW50IEFkZGVk</PHRASE>
<PHRASE Label="la_event_link.review.add.pending" Module="In-Link" Type="1">TGluayBDb21tZW50IFBlbmRpbmc=</PHRASE>
<PHRASE Label="la_event_link.review.approve" Module="In-Link" Type="1">TGluayBDb21tZW50IEFwcHJvdmVk</PHRASE>
<PHRASE Label="la_event_link.review.deny" Module="In-Link" Type="1">TGluayBDb21tZW50IERlY2xpbmVk</PHRASE>
<PHRASE Label="la_event_link.validation.results" Module="In-Link" Type="1">TGluayBWYWxpZGF0aW9uIFJlc3VsdHM=</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_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">SW4tbGluaw==</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_newlisting" Module="In-Link" Type="0">TmV3IExpc3Rpbmc=</PHRASE>
<PHRASE Label="la_ToolTip_newlisttype" Module="In-Link" Type="1">TmV3IExpc3RpbmcgVHlwZQ==</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_AreYouSureToCancelEnhancement" Module="In-Link" Type="0">WW91IGFyZSBhYm91dCB0byBjYW5jZWwgeW91ciBsaW5rIGVuaGFuY2VtZW50Lg==</PHRASE>
<PHRASE Label="lu_AreYouSureToExtendEnhancement" Module="In-Link" Type="0">WW91IGFyZSBhYm91dCB0byBleHRlbmQgeW91ciBsaW5rIGVuaGFuY2VtZW50Lg==</PHRASE>
<PHRASE Label="lu_btn_CancelEnhancement" Module="In-Link" Type="0">Q2FuY2VsIEVuaGFuY2VtZW50</PHRASE>
<PHRASE Label="lu_btn_Enhance" Module="In-Link" Type="0">RW5oYW5jZQ==</PHRASE>
<PHRASE Label="lu_btn_EnhanceLink" Module="In-Link" Type="0">RW5oYW5jZSBMaW5r</PHRASE>
<PHRASE Label="lu_btn_ExtendCancelEnhancement" Module="In-Link" Type="0">RXh0ZW5kIC8gQ2FuY2VsIEVuaGFuY2VtZW50</PHRASE>
<PHRASE Label="lu_btn_ExtendEnhancement" Module="In-Link" Type="0">RXh0ZW5kIEVuaGFuY2VtZW50</PHRASE>
<PHRASE Label="lu_btn_RateThisLink" Module="In-Link" Type="0">UmF0ZSB0aGlzIGxpbms=</PHRASE>
<PHRASE Label="lu_btn_ReviewThisLink" Module="In-Link" Type="0">Q29tbWVudCB0aGlzIExpbms=</PHRASE>
<PHRASE Label="lu_btn_VisitLink" Module="In-Link" Type="0">VmlzaXQgTGluaw==</PHRASE>
<PHRASE Label="lu_CancelEnhancementConfirmation" Module="In-Link" Type="0">QXJlIHlvdSBzdXJlIHlvdSB3YW50IHRvIGNhbmNlbCB5b3VyIGVuaGFuY2VkIGxpbms/IFRoZSBsaXN0aW5nIHR5cGUgd2lsbCBiZSByZXNldCB0byByZWd1bGFyLg==</PHRASE>
<PHRASE Label="lu_ChooseListingType" Module="In-Link" Type="0">Q2hvb3NlIExpc3RpbmcgVHlwZQ==</PHRASE>
<PHRASE Label="lu_col_Duration" Module="In-Link" Type="0">RHVyYXRpb24=</PHRASE>
<PHRASE Label="lu_DeleteLinkConfirm" Module="In-Link" Type="0">QXJlIHlvdSBzdXJlIHlvdSB3YW50IHRvIGRlbGV0ZSB0aGUgbGluaz8NClRoaXMgYWN0aW9uIGNhbm5vdCBiZSB1bmRvbmUu</PHRASE>
<PHRASE Label="lu_description_MyLinks" Module="In-Link" Type="0">TWFuYWdlIHlvdXIgTGlua3MgaGVyZQ==</PHRASE>
<PHRASE Label="lu_EnhancementSetToRenewOn" Module="In-Link" Type="0">RW5oYW5jZW1lbnQgc2V0IHRvIHJlbmV3IGF1dG9tYXRpY2FsbHkgb24=</PHRASE>
<PHRASE Label="lu_ExtendEnhancementConfirmation" Module="In-Link" Type="0">QXJlIHlvdSBzdXJlIHlvdSB3YW50IHRvIGV4dGVuZCB5b3VyIGxpbmsgZW5oYW5jZW1lbnQ/</PHRASE>
<PHRASE Label="lu_fld_LinkAddress" Module="In-Link" Type="0">QWRkcmVzcw==</PHRASE>
<PHRASE Label="lu_fld_LinkCity" Module="In-Link" Type="0">Q2l0eQ==</PHRASE>
<PHRASE Label="lu_fld_LinkCountry" Module="In-Link" Type="0">Q291bnRyeQ==</PHRASE>
<PHRASE Label="lu_fld_LinkPhone" Module="In-Link" Type="0">UGhvbmU=</PHRASE>
<PHRASE Label="lu_fld_LinkState" Module="In-Link" Type="0">U3RhdGU=</PHRASE>
<PHRASE Label="lu_fld_LinkZipCode" Module="In-Link" Type="0">WmlwIGNvZGU=</PHRASE>
<PHRASE Label="lu_fld_listingexpirationdate" Module="In-Link" Type="0">RW5oYW5jZW1lbnQgZXhwaXJlcyBvbg==</PHRASE>
<PHRASE Label="lu_fld_ListingType" Module="In-Link" Type="0">TGlzdGluZyBUeXBl</PHRASE>
<PHRASE Label="lu_fld_listingtypename" Module="In-Link" Type="0">TGlzdGluZyBUeXBl</PHRASE>
<PHRASE Label="lu_fld_Url" Module="In-Link" Type="0">VXJs</PHRASE>
<PHRASE Label="lu_free_listing" Module="In-Link" Type="0">RnJlZSBMaXN0aW5n</PHRASE>
<PHRASE Label="lu_GoogleMaps" Module="In-Link" Type="0">R29vZ2xlIE1hcHM=</PHRASE>
<PHRASE Label="lu_header_Thankyou" Module="In-Link" Type="0">VGhhbmsgeW91IQ==</PHRASE>
<PHRASE Label="lu_LinkNameAZ" Module="In-Link" Type="0">TGluayBOYW1lIEEgdG8gWg==</PHRASE>
<PHRASE Label="lu_LinkNameZA" Module="In-Link" Type="0">TGluayBOYW1lIFogdG8gQQ==</PHRASE>
<PHRASE Label="lu_LinksUpdated" Module="In-Link" Type="0">TGlua3MgdXBkYXRlZA==</PHRASE>
<PHRASE Label="lu_Link_ContactFormThankyouText" Module="In-Link" Type="0">WW91ciBpbmZvcm1hdGlvbiByZXF1ZXN0IGhhcyBiZWVuIHNlbnQgb3V0LiA8YnIvPjxici8+WW91J2xsIGJlIGNvbnRhY3RlZCBzaG9ydGx5IQ==</PHRASE>
<PHRASE Label="lu_Link_RequestInformation" Module="In-Link" Type="0">UmVxdWVzdCBJbmZvcm1hdGlvbg==</PHRASE>
<PHRASE Label="lu_MyLinks" Module="In-Link" Type="0">TXkgTGlua3M=</PHRASE>
<PHRASE Label="lu_noenhancments" Module="In-Link" Type="0">Tm8gTGluayBFbmhhbmNtZW50cyBjdXJyZW50bHkgYXZhaWxhYmxl</PHRASE>
<PHRASE Label="lu_NoLinks" Module="In-Link" Type="0">Tm8gTGlua3M=</PHRASE>
<PHRASE Label="lu_notice_SubscriptionAddToCart" Module="In-Link" Type="0">QWZ0ZXIgc2VsZWN0aW5nIGxpc3RpbmcgdHlwZSBpdCB3aWxsIGJlIGFkZGVkIHRvIHlvdXIgc2hvcHBpbmcgY2FydC4gT25jZSB5b3UgY29tcGxldGUgY2hlY2tvdXQgYW5kIHlvdXIgb3JkZXIgaXMgYXBwcm92ZWQgeW91ciBsaW5rIHN0YXR1cyB3aWxsIGJlIHVwZ3JhZGVkLiBZb3Ugd2lsbCBiZSBub3RpZmllZCBieSBlbWFpbCB3aGVuIHRoaXMgaXMgZG9uZS4=</PHRASE>
<PHRASE Label="lu_PendingEnhancement" Module="In-Link" Type="0">cGVuZGluZw==</PHRASE>
<PHRASE Label="lu_PermName_Link.Review_desc" Module="In-Link" Type="1">Q29tbWVudCBMaW5r</PHRASE>
<PHRASE Label="lu_section_LinkDetails" Module="In-Link" Type="0">TGluayBEZXRhaWxz</PHRASE>
<PHRASE Label="lu_SortLinksBy" Module="In-Link" Type="0">U29ydCBMaW5rcyBCeQ==</PHRASE>
<PHRASE Label="lu_SuggestLink" Module="In-Link" Type="0">U3VnZ2VzdCBMaW5r</PHRASE>
<PHRASE Label="lu_text_addlinkreviewconfirm" Module="In-Link" Type="0">VGhhbmsgeW91IGZvciBjb21tZW50aW5nIG9uIHRoaXMgbGluay4=</PHRASE>
<PHRASE Label="lu_text_addlinkreviewpendingconfirm" Module="In-Link" Type="0">VGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIHlvdXIgY29tbWVudCBmb3IgdGhpcyBsaW5rIC0gaXQncyBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbC4=</PHRASE>
<PHRASE Label="lu_text_enhancementconfirmation" Module="In-Link" Type="0">WW91ciBsaW5rIGhhcyBiZWVuIGVuaGFuY2VkLg==</PHRASE>
<PHRASE Label="lu_text_ModifyLinkConfirm" Module="In-Link" Type="0">WW91ciBMaW5rIGhhcyBiZWVuIG1vZGlmaWVk</PHRASE>
<PHRASE Label="lu_text_modifylinkpendingconfirm" Module="In-Link" Type="0">VGhhbmsgeW91IGZvciB1cGRhdGluZyB5b3VyIGxpbmsuIFlvdXIgbW9kaWZpY2F0aW9ucyBhcmUgd2FpdGluZyBmb3IgYWRtaW5pc3RyYXRpdmUgYXBwcm92YWwu</PHRASE>
<PHRASE Label="lu_text_MyLinks" Module="In-Link" Type="0">TXkgTGlua3M=</PHRASE>
<PHRASE Label="lu_text_nolinkreviewpermission" Module="In-Link" Type="0">Tm8gcGVybWlzc2lvbnMgdG8gY29tbWVudCBvbiB0aGlzIGxpbmsu</PHRASE>
<PHRASE Label="lu_text_nomodifylinkpermission" Module="In-Link" Type="0">Tm8gcGVybWlzc2lvbnMgdG8gcGVyZm9ybSBtb2RpZnkgdGhlIGxpbms=</PHRASE>
<PHRASE Label="lu_text_nosuggestlinkpermission" Module="In-Link" Type="0">Tm8gcGVybWlzc2lvbnMgdG8gc3VnZ2VzdCBsaW5rIGludG8gdGhlIGN1cnJlbnQgY2F0ZWdvcnk=</PHRASE>
<PHRASE Label="lu_text_suggestlinkconfirm" Module="In-Link" Type="0">VGhhbmsgeW91IGZvciB1cGRhdGluZyB5b3VyIGxpbmsu</PHRASE>
<PHRASE Label="lu_text_suggestlinkpendingconfirm" Module="In-Link" Type="0">VGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIHlvdXIgbGluay4gQ3VycmVudGx5IGl0J3Mgd2FpdGluZyBmb3IgYWRtaW5pc3RyYXRpdmUgYXBwcm92YWw=</PHRASE>
<PHRASE Label="lu_title_addlinkreviewconfirm" Module="In-Link" Type="0">TGluayBDb21tZW50IEFkZGVk</PHRASE>
<PHRASE Label="lu_title_addlinkreviewpendingconfirm" Module="In-Link" Type="0">TGluayBDb21tZW50IFBlbmRpbmc=</PHRASE>
<PHRASE Label="lu_title_confirmcancelenhancement" Module="In-Link" Type="0">RW5oYW5jZW1lbnQgQ2FuY2VsbGF0aW9uIENvbmZpcm1hdGlvbg==</PHRASE>
<PHRASE Label="lu_title_confirmextendenhancement" Module="In-Link" Type="0">RW5oYW5jZW1lbnQgRXh0ZW50aW9uIENvbmZpcm1hdGlvbg==</PHRASE>
<PHRASE Label="lu_title_EnhanceLink" Module="In-Link" Type="0">RW5oYW5jZSBMaW5r</PHRASE>
<PHRASE Label="lu_title_EnhancementDetails" Module="In-Link" Type="0">RW5oYW5jZW1lbnQgRGV0YWlscw==</PHRASE>
<PHRASE Label="lu_title_extendcancelenhancement" Module="In-Link" Type="0">RXh0ZW5kIC8gQ2FuY2VsIExpbmsgRW5oYW5jZW1lbnQ=</PHRASE>
<PHRASE Label="lu_title_favoritelinks" Module="In-Link" Type="0">RmF2b3JpdGUgTGlua3M=</PHRASE>
<PHRASE Label="lu_title_HotLinks" Module="In-Link" Type="0">SG90IExpbmtz</PHRASE>
<PHRASE Label="lu_title_LinkDetails" Module="In-Link" Type="0">TGluayBEZXRhaWxz</PHRASE>
<PHRASE Label="lu_title_Links" Module="In-Link" Type="0">TGlua3M=</PHRASE>
<PHRASE Label="lu_title_linksearchresults" Module="In-Link" Type="0">TGlua3MgU2VhcmNoIFJlc3VsdHM=</PHRASE>
<PHRASE Label="lu_title_ModifyLink" Module="In-Link" Type="0">TW9kaWZ5IExpbms=</PHRASE>
<PHRASE Label="lu_title_modifylinkconfirm" Module="In-Link" Type="0">TGluayBNb2RpZmllZA==</PHRASE>
<PHRASE Label="lu_title_modifylinkpendingconfirm" Module="In-Link" Type="0">UGVuZGluZyBMaW5rIENvbmZpcm1hdGlvbg==</PHRASE>
<PHRASE Label="lu_title_MyLinks" Module="In-Link" Type="0">TXkgTGlua3M=</PHRASE>
<PHRASE Label="lu_title_NewLinks" Module="In-Link" Type="0">TmV3IExpbmtz</PHRASE>
<PHRASE Label="lu_title_PickLinks" Module="In-Link" Type="0">RWRpdG9yJ3MgUGljayBMaW5rcw==</PHRASE>
<PHRASE Label="lu_title_poplinks" Module="In-Link" Type="0">UG9wdWxhciBMaW5rcw==</PHRASE>
<PHRASE Label="lu_title_ReviewThisLink" Module="In-Link" Type="0">Q29tbWVudCB0aGlzIExpbms=</PHRASE>
<PHRASE Label="lu_title_SuggestLink" Module="In-Link" Type="0">U3VnZ2VzdCBMaW5r</PHRASE>
<PHRASE Label="lu_title_suggestlinkconfirm" Module="In-Link" Type="0">QWRkIExpbmsgQ29uZmlybWF0aW9u</PHRASE>
<PHRASE Label="lu_title_suggestlinkpendingconfirm" Module="In-Link" Type="0">UGVuZGluZyBMaW5rIENvbmZpcm1hdGlvbg==</PHRASE>
<PHRASE Label="lu_ToCancelEnhancement" Module="In-Link" Type="0">dG8gY2FuY2VsIGxpbmsgZW5oYW5jZW1lbnQ=</PHRASE>
<PHRASE Label="lu_TotalLinks" Module="In-Link" Type="0">VG90YWwgTGlua3M=</PHRASE>
</PHRASES>
<EVENTS>
<EVENT MessageType="html" Event="LINK.ADD" Type="0">U3ViamVjdDogTmV3IExpbmsgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgLSBBZGRlZAoKVGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIHlvdXIgbGluayB0byBvdXIgd2Vic2l0ZSE8YnIvPjxici8+DQoNCkxpbmsgZGV0YWlsIGFyZSBsaXN0ZWQgYmVsb3c6PGJyLz48YnIvPg0KDQpMaW5rIE5hbWU6IDxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxici8+DQo8aW5wMjptX2lmIGNoZWNrPSJsX0ZpZWxkIiBuYW1lPSJVcmwiPg0KTGluayBXZWJzaXRlOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVybCIvPjxici8+DQo8L2lucDI6bV9pZj4NCjxpbnAyOm1faWYgY2hlY2s9ImxfRmllbGQiIG5hbWU9IkRlc2NyaXB0aW9uIj4NCkRlc2NyaXB0aW9uOiA8aW5wMjpsX0ZpZWxkIG5hbWU9IkRlc2NyaXB0aW9uIi8+PGJyLz4NCjwvaW5wMjptX2lmPg0KPGJyLz48YnIvPg0KDQpZb3UgY2FuIHZpZXcgeW91ciBsaW5rIGhlcmUgPGEgaHJlZj0iPGlucDI6bF9MaW5rTGluayB0ZW1wbGF0ZT0iX19kZWZhdWx0X18iLz4iPjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjwvYT4=</EVENT>
<EVENT MessageType="html" Event="LINK.ADD" Type="1">U3ViamVjdDogTmV3IExpbmsgaGFzIGJlZW4gU3VibWl0dGVkCgpBIG5ldyBMaW5rIGhhcyBiZWVuIHN1Ym1pdHRlZCB0byB0aGUgd2Vic2l0ZSBieSA8aW5wMjpsX0ZpZWxkIG5hbWU9IlVzZXJOYW1lIi8+Ljxici8+PGJyLz4NCg0KTGluayBOYW1lOiA8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz48YnIvPg0KPGlucDI6bV9pZiBjaGVjaz0ibF9GaWVsZCIgbmFtZT0iVXJsIj4NCkxpbmsgV2Vic2l0ZTogPGlucDI6bF9GaWVsZCBuYW1lPSJVcmwiLz48YnIvPg0KPC9pbnAyOm1faWY+DQo8aW5wMjptX2lmIGNoZWNrPSJsX0ZpZWxkIiBuYW1lPSJEZXNjcmlwdGlvbiI+DQpEZXNjcmlwdGlvbjogPGlucDI6bF9GaWVsZCBuYW1lPSJEZXNjcmlwdGlvbiIvPjxici8+DQo8L2lucDI6bV9pZj4NCjxici8+PGJyLz4NCg0KWW91IGNhbiB2aWV3IGl0IGhlcmUgPGEgaHJlZj0iPGlucDI6bF9MaW5rTGluayB0ZW1wbGF0ZT0iX19kZWZhdWx0X18iLz4iPjxpbnAyOjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjwvYT4NCg==</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">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjo8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIC0gQXBwcm92ZWQhCgpZb3VyIExpbmsgaGFzIGJlZW4gQXBwcm92ZWQhPGJyLz48YnIvPg0KDQpMaW5rIE5hbWU6IDxpbnAyOjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjxici8+PGJyLz4NCg0KWW91IGNhbiB2aWV3IGl0IGhlcmUgPGEgaHJlZj0iPGlucDI6bF9MaW5rTGluayB0ZW1wbGF0ZT0iX19kZWZhdWx0X18iLz4iPjxpbnAyOjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPjwvYT4NCg0K</EVENT>
<EVENT MessageType="html" Event="LINK.CONTACTFORM" Type="0">U3ViamVjdDogIlJlcXVlc3QgSW5mb3JtYXRpb24iIGZvcm0gc3VibWl0dGVkCgpEZWFyIEJ1c2luZXNzIE93bmVyLDxici8+PGJyLz4NCg0KIlJlcXVlc3QgSW5mb3JtYXRpb24iIGZvcm0gaGFzIGJlZW4gc3VibWl0dGVkIGZvciA8aW5wMjptX3BhcmFtIG5hbWU9InRvX2xpbmtuYW1lIj48YnI+PGJyPg0KPGhyIHdpZHRoPSIxMDAlIiBub3NoYWRlPjxicj4NCg0KPHRhYmxlPg0KPHRyPg0KPHRkPkZ1bGwgbmFtZTo8L3RkPg0KPHRkPjxpbnAyOm1fcGFyYW0gbmFtZT0iZnJvbV9uYW1lIiAvPjwvdGQ+DQo8L3RyPg0KDQo8dHI+DQo8dGQ+RS1tYWlsOjwvdGQ+DQo8dGQ+PGEgaHJlZj0ibWFpbHRvOjxpbnAyOm1fcGFyYW0gbmFtZT0iZnJvbV9lbWFpbCIgLz4iPjxpbnAyOm1fcGFyYW0gbmFtZT0iZnJvbV9lbWFpbCIgLz48L2E+PC90ZD4NCjwvdHI+DQoNCjx0cj4NCjx0ZD5TdWJqZWN0OjwvdGQ+DQo8dGQ+PGlucDI6bV9wYXJhbSBuYW1lPSJmcm9tX3N1YmplY3QiIC8+PC90ZD4NCjwvdHI+DQoNCjx0cj4NCjx0ZD5RdWVzdGlvbnM6PC90ZD4NCjx0ZD4NCjxpbnAyOm1fcGFyYW0gbmFtZT0ibWVzc2FnZSIvPg0KPC90ZD4NCjwvdHI+DQo8L3RhYmxlPg0KPGJyPjxociB3aWR0aD0iMTAwJSIgbm9zaGFkZT48YnI+</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">U3ViamVjdDogWW91ciBMaW5rICI8aW5wMjo8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIC0gRGVuaWVkCgpTb3JyeSwgYnV0IHN1Ym1pdHRlZCBieSB5b3UgTGluayAoPGlucDI6PGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+KSBoYXMgYmVlbiBEZW5pZWQhPGJyLz48YnIvPg0KDQpQbGVhc2UgZmVlbCBmcmVlIHRvIHN1Ym1pdCBhZ2Fpbi48YnIvPg==</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">U3ViamVjdDogWW91ciBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIiAvPiIgLSBBcHByb3ZlZCEKCllvdXIgTW9kaWZpY2F0aW9ucyBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIgLz4iIGxpbmsgd2VyZSBhcHByb3ZlZCBieSB0aGUgd2Vic2l0ZS4=</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+IiAtIFBlbmRpbmcKCk1vZGlmaWNhdGlvbnMgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIGxpbmsgYXJlIHBlbmRpbmcgZm9yIGFkbWluaXN0cmF0aXZlIGFwcHJvdmFsLg==</EVENT>
- <EVENT MessageType="html" Event="LINK.MODIFY.PENDING" Type="1">U3ViamVjdDogTGluayBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIFBlbmRpbmchCgpNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBsaW5rIGFyZSBwZW5kaW5nIGZvciBhZG1pbmlzdHJhdGl2ZSBhcHByb3ZhbC4=</EVENT>
- <EVENT MessageType="html" Event="LINK.OWNER.MODIFY" Type="0">U3ViamVjdDogTGluayBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIEFjY2VwdGVkCgpNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBsaW5rIGFyZSBhY2NlcHRlZC4=</EVENT>
- <EVENT MessageType="html" Event="LINK.OWNER.MODIFY" Type="1">U3ViamVjdDogTGluayAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBNb2RpZmllZCBieSBPd25lcgoKTGluayAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiBoYXMgYmVlbiBtb2RpZmllZCBieSBpdCdzIG93bmVyLg==</EVENT>
- <EVENT MessageType="html" Event="LINK.OWNER.MODIFY.PENDING" Type="0">U3ViamVjdDogWW91ciBMaW5rIE1vZGlmaWNhdGlvbnMgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIC0gUGVuZGluZwoKVGhhbmsgeW91LCB5b3VyIGxpbmsgbW9kaWZpY2F0aW9ucyBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgYXJlIHBlbmRpbmcgZm9yIGFkbWluaXN0cmF0aXZlIGFwcHJvdmFsLg==</EVENT>
- <EVENT MessageType="html" Event="LINK.OWNER.MODIFY.PENDING" Type="1">U3ViamVjdDogTGluayBNb2RpZmljYXRpb25zIGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIFBlbmRpbmcKCkxpbmsgbW9kaWZpY2F0aW9ucyBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgc3VibWl0dGVkIGJ5IGl0J3Mgb3duZXIgYXJlIHBlbmRpbmcgZm9yIHlvdXIgYXBwcm92YWwu</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">U3ViamVjdDogTmV3IENvbW1lbnQgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iIExpbmsgU3VibWl0dGVkCgpOZXcgY29tbWVudCBmb3IgIjxpbnAyOmxfRmllbGQgbmFtZT0iTmFtZSIvPiIgbGluayBoYXMgYmVlbiBzdWJtaXR0ZWQu</EVENT>
- <EVENT MessageType="html" Event="LINK.REVIEW.ADD.PENDING" Type="0">U3ViamVjdDogWW91ciBDb21tZW50IGZvciAiPGlucDI6bF9GaWVsZCBuYW1lPSJOYW1lIi8+IiAtIFBlbmRpbmcKClRoYW5rIHlvdSBmb3Igc3VibWl0dGluZyB5b3VyIGNvbW1lbnQgZm9yICI8aW5wMjpsX0ZpZWxkIG5hbWU9Ik5hbWUiLz4iLjxici8+PGJyLz4NCg0KQ3VycmVudGx5IGl0J3MgcGVuZGluZyBmb3IgYWRtaW5pc3RyYXRpdmUgYXBwcm92YWwgYW5kIHdpbGwgYmUgcHVibGlzaGVkIHNob3J0bHku</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.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.0.x/in-link/install/install_data.sql
===================================================================
--- branches/5.0.x/in-link/install/install_data.sql (revision 12424)
+++ branches/5.0.x/in-link/install/install_data.sql (revision 12425)
@@ -1,308 +1,304 @@
INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', '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);
INSERT INTO ConfigurationAdmin VALUES ('Link_SortOrder', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.01, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', '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);
INSERT INTO ConfigurationAdmin VALUES ('Link_SortOrder2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.02, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Links', 'la_Text_Links', 'la_link_perpage_prompt', 'text', '', '', 10.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_NewDays', 'la_Text_Links', 'la_link_newdays_prompt', 'text', '', '', 10.05, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_MinPopRating', 'la_Text_Links', 'la_fld_Link_MinPopRating', 'text', '', '', 10.06, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_MaxHotNumber', 'la_Text_Links', 'la_fld_Link_MaxHotNumber', 'text', '', '', 10.08, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_EnhancedLinks', 'la_Text_Links', 'la_link_EnhancedLinks', 'checkbox', '', '', 10.09, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_AllowFreeListings', 'la_Text_Links', 'la_link_AllowFreeListings', 'checkbox', '', '', 10.1, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_ShowPick', 'la_Text_Links', 'la_link_editorspick_prompt', 'checkbox', '', '', 10.11, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_UrlStatus', 'la_Text_Links', 'la_link_urlstatus_prompt', 'checkbox', '', '', 10.12, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_ReviewsSort', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'ReviewText=la_opt_CommentText,CreatedOn=la_opt_CreatedOn', 20.01, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_ReviewsOrder', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'asc=la_common_Ascending,desc=la_common_Descending', 20.01, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_ReviewsSort2', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'ReviewText=la_common_ReviewText,CreatedOn=la_opt_CreatedOn', 20.02, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_ReviewsOrder2', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'asc=la_common_Ascending,desc=la_common_Descending', 20.02, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Link_MinPopVotes', 'la_Text_Links', 'la_fld_Link_MinPopVotes', 'text', '', '', 10.07, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_LinkReviews', 'la_Text_Reviews', 'la_review_perpage_prompt', 'text', NULL, NULL, 20.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_LinkReviews_Short', 'la_Text_Reviews', 'la_review_perpage_short_prompt', 'text', NULL, NULL, 20.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Links_Short', 'la_Text_Links', 'la_link_perpage_short_prompt', 'text', '', '', 10.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_Name', 'la_Text_Link_Search', 'la_Link_Name', 'checkbox', '', '', 2, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_Description', 'la_Text_Link_Search', 'la_Link_Description', 'checkbox', '', '', 1, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_Url', 'la_Text_Link_Search', 'la_Link_Url', 'checkbox', '', '', 5, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_CreatedOn', 'la_Text_Link_Search', 'la_Link_CreatedOn', 'checkbox', '', '', 5, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_Hits', 'la_Text_Link_Search', 'la_Link_Hits', 'checkbox', '', '', 6, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_CatchedRating', 'la_Text_Link_Search', 'la_Link_CatchedRating', 'checkbox', '', '', 7, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_CatchedVotesQty', 'la_Text_Link_Search', 'la_Link_CatchedVotesQty', 'checkbox', '', '', 8, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_Link_CatchedReviewsQty', 'la_Text_Link_Search', 'la_Link_CatchedReviewsQty', 'checkbox', '', '', 9, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('link_ReviewDelay_Value', 'la_Text_Links', 'la_prompt_DupReviews', 'text', '', '', 10.13, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('link_ReviewDelay_Interval', '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);
INSERT INTO ConfigurationAdmin VALUES ('link_RatingDelay_Value', 'la_Text_Links', 'la_prompt_DupRating', 'text', '', '', 10.14, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('link_RatingDelay_Interval', '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);
INSERT INTO ConfigurationAdmin VALUES ('l_CategoryTemplate', 'la_section_Templates', 'la_fld_CategoryTemplate', 'text', '', '', 30.01, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_ItemTemplate', 'la_section_Templates', 'la_fld_ItemTemplate', 'text', '', '', 30.02, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_MaxImageCount', 'la_section_ImageSettings', 'la_config_MaxImageCount', 'text', '', '', 40.01, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_ThumbnailImageWidth', 'la_section_ImageSettings', 'la_config_ThumbnailImageWidth', 'text', '', '', 40.02, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_ThumbnailImageHeight', 'la_section_ImageSettings', 'la_config_ThumbnailImageHeight', 'text', '', '', 40.03, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_FullImageWidth', 'la_section_ImageSettings', 'la_config_FullImageWidth', 'text', '', '', 40.04, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('l_FullImageHeight', 'la_section_ImageSettings', 'la_config_FullImageHeight', 'text', '', '', 40.05, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Keyword_links', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Pop_links', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Rating_links', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Increase_links', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Search_ShowMultiple_links', 'la_config_ShowMultiple', 'la_Text_MultipleShow', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('l_MaxCategories', 'la_Text_Links', 'la_fld_MaxCategories', 'text', NULL, NULL, 10.15, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('l_EnableGoogleMaps', 'la_Text_Links', 'la_fld_LinkEnableGoogleMaps', 'checkbox', NULL, NULL, 10.16, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('l_GoogleMapsAPIKey', 'la_Text_Links', 'la_fld_LinkGoogleMapsAPIKey', 'text', NULL, NULL, 10.17, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('l_EnableLinkContactForm', 'la_Text_Links', 'la_config_EnableLinkContactForm', 'checkbox', NULL, NULL, 10.18, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('ReciprocalLinkChecking', 'la_Text_Links', 'la_config_ReciprocalLinkChecking', 'checkbox', NULL, NULL, 10.19, 0, 0);
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Perpage_Links', '10', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_SortField', 'Name', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_SortOrder', 'asc', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_SortField2', 'Description', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_SortOrder2', 'desc', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_NewDays', '100', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_MinPopRating', '5', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_MaxHotNumber', '5', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_EnhancedLinks', '0', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_AllowFreeListings', '1', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_ShowPick', '1', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_UrlStatus', '', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_ReviewsSort', 'CreatedOn', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_ReviewsOrder', 'desc', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_ReviewsSort2', 'ReviewText', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_ReviewsOrder2', 'asc', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_MinPopVotes', '20', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_LinkId', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Name', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Description', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Url', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_CreatedOn', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Hits', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_CatchedRating', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_CatchedVotesQty', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_CatchedReviewsQty', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_ReviewById', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Priority', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_Status', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_EditorsPick', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_ResourceId', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_HotItem', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_PopItem', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_Link_NewItem', '1', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'link_ReviewDelay_Value', '1', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'link_ReviewDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'link_RatingDelay_Value', '1', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'link_RatingDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_Root', '{LinkCatId}', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Perpage_Links_Short', '3', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_Highlight_OpenTag', '<span class="match">', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_Highlight_CloseTag', '</span>', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Perpage_LinkReviews_Short', '3', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Perpage_LinkReviews', '10', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_CategoryTemplate', '/in-link/designs/section', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_ItemTemplate', 'in-link/designs/detail', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_MaxImageCount', 5, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_ThumbnailImageWidth', 120, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_ThumbnailImageHeight', 120, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_FullImageWidth', 450, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_FullImageHeight', 450, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'SearchRel_Keyword_links', '90', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'SearchRel_Pop_links', '5', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'SearchRel_Rating_links', '5', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'SearchRel_Increase_links', '30', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Search_ShowMultiple_links', '0', 'In-Link', 'in-link:configuration_search');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'StartValidationTime', '0', 'In-Link', '');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'LastExpirationTime', '0', 'In-Link', '');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Link_RatingToPop', '5', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_MaxCategories', '3', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_EnableGoogleMaps', '0', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_GoogleMapsAPIKey', '', 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'l_EnableLinkContactForm', 1, 'In-Link', 'in-link:configuration_output');
INSERT INTO ConfigurationValues VALUES (DEFAULT, 'ReciprocalLinkChecking', '0', 'In-Link', 'in-link:configuration_output');
INSERT INTO Events VALUES(DEFAULT, 'LINK.ADD', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.add', 1);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.modify', 1);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.review.add', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ADD', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.add', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.approve', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.deny', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.approve', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.add', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.approve', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.deny', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.add.pending', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ADD.PENDING', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.add.pending', 1);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.modify', 1);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.pending', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY.PENDING', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.modify.pending', 1);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.OWNER.MODIFY', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.modify.modify', 1);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.OWNER.MODIFY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.modify', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.OWNER.MODIFY.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.modify.pending', 0);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.OWNER.MODIFY.PENDING', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.modify.modify.pending', 1);
-INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.add.pending', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.approve', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.MODIFY.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.modify.deny', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.approve', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.deny', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 1, NULL, 'In-Link', 'la_event_link.review.add', 1);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.add', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.ADD.PENDING', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.add.pending', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.approve', 0);
+INSERT INTO Events VALUES(DEFAULT, 'LINK.REVIEW.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.review.deny', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.APPROVE', NULL, 0, 0, NULL, 'In-Link', 'la_event_link.link.enhance.approve', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.APPROVE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.approve', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.DENY', NULL, 0, 0, NULL, 'In-Link', 'la_event_link.link.enhance.deny', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.DENY', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.deny', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.EXPIRE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.expire', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.EXPIRE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.expire', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.EXTEND', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.extend', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.EXTEND', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.extend', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEW', NULL, 0, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEW', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEW.FAILED', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew_failed', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEW.FAILED', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew_failed', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.CANCEL', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew_cancel', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.CANCEL', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renew_cancel', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEWAL.NOTICE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renewal_notice', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.ENHANCE.RENEWAL.NOTICE', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.enhance.renewal_notice', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.CONTACTFORM', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.contactform', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.CONTACTFORM', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.link.contactform', 0);
INSERT INTO Events VALUES(DEFAULT, 'LINK.RECIPROCAL.CHECK.FAILED', NULL, 1, 0, NULL, 'In-Link', 'la_event_link.reciprocal.check.failed', 1);
INSERT INTO Events VALUES(DEFAULT, 'LINK.VALIDATION.RESULTS', NULL, 1, 0, NULL, 'In-Link', 'la_event_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 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>', '', 3, 1, 0, 0);
INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkCountry', 'lu_fld_LinkCountry', 0, 'la_section_BusinessLocation', 'la_fld_LinkCountry', 'select', '=+||<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 1 ORDER BY DestAbbr 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', 'in-link/', 'l', '0.0.0', 1, 1, 'in-link/', 2, '1054738405');

Event Timeline

In-Portal CMS · In-Portal Community Pages · In-Portal Issue Tracker · In-Portal Repository Browser · Quality Assurance · In-Portal CI Server