in-link
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Apr 20, 10:31 AM

in-link
View Options

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

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

	class LinksEventHandler extends kCatDBEventHandler {

	/**
	* Allows to override standard permission mapping
	*
	* @return void
	* @access protected
	* @see kEventHandler::$permMapping
	*/
	protected function mapPermissions()
	{
	parent::mapPermissions();

	$permissions = Array (
	'OnContactFormSubmit' => Array ('self' => true),
	'OnProcessReciprocalLinks' => Array ('self' => true),
	'OnSetGrouping' => Array ('self' => 'view'),
	'OnStoreSelected' => Array ('self' => 'view'),
	'OnMerge' => Array ('self' => 'edit'),
	);

	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Apply any custom changes to list's sql query
	*
	* @param kEvent $event
	* @return void
	* @access protected
	* @see kDBEventHandler::OnListBuild()
	*/
	protected function SetCustomQuery(kEvent $event)
	{
	parent::SetCustomQuery($event);

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

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

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

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

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

	switch ($event->Special) {
	case 'duplicates':
	foreach ($grouping as $group_field) {
	$object->AddGroupByField($object->TableName . '.' . $group_field);
	}

	$object->addFilter('has_dupes_filter', 'DupeCount > 1', kDBList::AGGREGATE_FILTER);
	break;

	case 'duplicates-sub':
	$main_object = $this->Application->recallObject($event->Prefix . '.duplicates');
	/* @var $main_object kDBItem */

	foreach ($grouping as $field_index => $group_field) {
	$object->addFilter('dupe_filter_' . $field_index, '%1$s.`' . $group_field . '` = ' . $this->Conn->qstr($main_object->GetDBField($group_field)));
	}
	break;
	}

	$object->addFilter('primary_filter', TABLE_PREFIX . 'CategoryItems.PrimaryCat = 1');
	}
	}

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

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

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

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

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

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

	$groping_error = false;

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

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

	if ( !$groping_error ) {
	$temp_handler = $this->Application->recallObject($event->getPrefixSpecial() . '_TempHandler', 'kTempTablesHandler');
	/* @var $temp_handler kTempTablesHandler */

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

	foreach ($primary_links as $group_key => $primary_resource_id) {
	$categories = Array ();
	$group_links = Array ();
	$group_categories = $this->Conn->Query(sprintf($categories_sql, $group_key));

	foreach ($group_categories as $category_data) {
	$group_links[$category_data['ResourceId']] = $category_data[$id_field];
	$categories[$category_data['ResourceId'] == $primary_resource_id ? 'remove' : 'add'][] = $category_data['CategoryId'];
	}

	unset($group_links[$primary_resource_id]);
	$categories = array_unique(array_diff($categories['add'], $categories['remove']));

	if ( $categories ) {
	// add link to other link categories
	$values_sql = '';
	foreach ($categories as $category_id) {
	$values_sql .= '(' . $category_id . ',' . $primary_resource_id . ',0),';
	}
	$values_sql = substr($values_sql, 0, -1);
	$insert_sql = 'INSERT INTO ' . TABLE_PREFIX . 'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES ' . $values_sql;
	$this->Conn->Query($insert_sql);
	}

	// delete all links from group except primary
	$temp_handler->DeleteItems($event->Prefix, $event->Special, array_values($group_links));
	}
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	$this->Application->SetVar($event->getPrefixSpecial().'_error', 1);
	}
	}

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

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

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

	if ( $event->status != kEvent::erSUCCESS ) {
	return;
	}

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

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

	// listing was created -> enhance it right away
	$enhancement_event = new kEvent('ls:OnRequestEnhancement');
	$this->Application->HandleEvent($enhancement_event);

	if ( ($enhancement_event->status == kEvent::erSUCCESS) && strlen($enhancement_event->redirect) ) {
	$event->SetRedirectParam('next_template', $event->redirect);
	$event->redirect = $enhancement_event->redirect;
	}
	}

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

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

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

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

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

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

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

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

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

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

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

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

	}
	}

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

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

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

	- $email_sent = $this->Application->EmailEventUser('LINK.CONTACTFORM', $object->GetDBField('CreatedById'), $send_params);
	+ $email_sent = $this->Application->emailUser('LINK.CONTACTFORM', $object->GetDBField('CreatedById'), $send_params);

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

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

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

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

	$this->_checkLink($event);
	}

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

	$this->_checkLink($event);
	}

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

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

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

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

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

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

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

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

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

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

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');

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

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

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

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

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

	// 2. approve all links, that have succeeded in reciprocal check (during adding/changing on front-end)
	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE (ReciprocalLinkFound = ' . LINK_IS_RECIPROCAL . ') AND (Status <> ' . STATUS_ACTIVE . ')';
	$verified_links = $this->Conn->GetCol($sql);

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

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

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

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

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

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

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

	return $id;
	}

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

	return $events;
	}

	/**
	* [HOOK] Allows to add cloned subitem to given prefix
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnCloneSubItem(kEvent $event)
	{
	parent::OnCloneSubItem($event);

	if ( $event->MasterEvent->Prefix == 'rev' ) {
	$clones = $this->Application->getUnitOption($event->MasterEvent->Prefix, 'Clones');
	$subitem_prefix = $event->Prefix . '-' . $event->MasterEvent->Prefix;

	$clones[$subitem_prefix]['ConfigMapping'] = Array (
	'PerPage' => 'Perpage_LinkReviews',
	'ShortListPerPage' => 'Perpage_LinkReviews_Short',
	'DefaultSorting1Field' => 'Link_ReviewsSort',
	'DefaultSorting2Field' => 'Link_ReviewsSort2',
	'DefaultSorting1Dir' => 'Link_ReviewsOrder',
	'DefaultSorting2Dir' => 'Link_ReviewsOrder2',

	'ReviewDelayInterval' => 'link_ReviewDelay_Interval',
	'ReviewDelayValue' => 'link_ReviewDelay_Value',
	);

	$this->Application->setUnitOption($event->MasterEvent->Prefix, 'Clones', $clones);
	}
	}

	/**
	* Occurs before original item of item in pending editing got deleted (for hooking only)
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeDeleteOriginal(kEvent $event)
	{
	parent::OnBeforeDeleteOriginal($event);

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

	$link_id = $event->getEventParam('original_id');
	$new_resource_id = $object->GetDBField('ResourceId');

	$sql = 'SELECT ResourceId
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . '
	WHERE ' . $this->Application->getUnitOption($event->Prefix, 'IDField') . '=' . $link_id;
	$old_resource_id = $this->Conn->GetOne($sql);

	$this->Application->SetVar('original_resource_id', $old_resource_id);
	$this->changeResourceId('rel', 'TargetId', $old_resource_id, $new_resource_id);
	}

	/**
	* Occurs after original item of item in pending editing got deleted
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterDeleteOriginal(kEvent $event)
	{
	parent::OnAfterDeleteOriginal($event);

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

	$old_resource_id = $this->Application->GetVar('original_resource_id');
	$new_resource_id = $object->GetDBField('ResourceId');

	$this->changeResourceId('ls', 'ItemResourceId', $old_resource_id, $new_resource_id);
	}

	/**
	* Changes item resource id in one field
	*
	* @param string $prefix
	* @param string $field
	* @param string $old_resource_id
	* @param string $new_resource_id
	* @return void
	* @access protected
	*/
	protected function changeResourceId($prefix, $field, $old_resource_id, $new_resource_id)
	{
	$fields_hash = Array ($field => $new_resource_id);
	$table_name = $this->Application->getUnitOption($prefix, 'TableName');

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

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

	class LinkValidationEventHandler extends kDBEventHandler {

	/**
	* Allows to override standard permission mapping
	*
	* @return void
	* @access protected
	* @see kEventHandler::$permMapping
	*/
	protected function mapPermissions()
	{
	parent::mapPermissions();

	$permissions = Array (
	'OnResetValidationStatus' => Array ('self' => 'advanced:reset',),
	'OnRestartValidation' => Array ('self' => 'advanced:restart',),
	'OnContinueValidation' => Array ('self' => 'advanced:continue',),
	'OnValidateSelected' => Array ('self' => 'advanced:validate',),
	'OnValidateProgress' => Array ('self' => 'advanced:validate\|advanced:continue\|advanced:restart\|advanced:reset',),
	'OnCancelValidation' => Array ('self' => 'advanced:validate\|advanced:continue\|advanced:restart\|advanced:reset',),
	'OnCronValidation' => Array ('self' => 'advanced:validate\|advanced:continue\|advanced:restart\|advanced:reset',),
	);

	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Define alternative event processing method names
	*
	* @return void
	* @see kEventHandler::$eventMethods
	* @access protected
	*/
	protected function mapEvents()
	{
	parent::mapEvents();

	$events_map = Array (
	'OnApproveLinks' => 'iterateItems',
	'OnDeclineLinks' => 'iterateItems',
	);

	$this->eventMethods = array_merge($this->eventMethods, $events_map);
	}

	/**
	* Checks user permission to execute given $event
	*
	* @param kEvent $event
	* @return bool
	* @access public
	*/
	public function CheckPermission(kEvent $event)
	{
	$check_events = Array ('OnApproveLinks', 'OnDeclineLinks', 'OnDeleteLinks');

	if ( in_array($event->Name, $check_events) ) {
	$ids = $this->_getSelectedIds($event);

	$perm_value = true;
	if ( $ids ) {
	$perm_helper = $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	$items = $perm_helper->GetCategoryItemData('l', $ids);
	$check_method = $event->Name == 'OnDeleteLinks' ? 'DeleteCheckPermission' : 'ModifyCheckPermission';
	foreach ($items as $item_id => $item_data) {
	if ( $perm_helper->$check_method($item_data['CreatedById'], $item_data['CategoryId'], 'l') == 0 ) {
	// one of items selected has no permission
	$perm_value = false;
	break;
	}
	}

	if ( !$perm_value ) {
	$event->status = kEvent::erPERM_FAIL;
	}
	}

	return $perm_value;
	}

	return parent::CheckPermission($event);
	}

	/**
	* Adds calculates fields for category name
	*
	* @param kDBItem\|kDBList $object
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function prepareObject(&$object, kEvent $event)
	{
	parent::prepareObject($object, $event);

	$object->addCalculatedField('CachedNavbar', 'c.l' . $this->Application->GetVar('m_lang') . '_CachedNavbar');
	}

	/**
	* Allows to show only invalid links
	*
	* @param kEvent $event
	* @return void
	* @access protected
	* @see kDBEventHandler::OnListBuild()
	*/
	protected function SetCustomQuery(kEvent $event)
	{
	parent::SetCustomQuery($event);

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

	$object->addFilter('primary_category_filter', 'ci.PrimaryCat = 1');

	if ( $event->Special == 'invalid' ) {
	$object->addFilter('status_filter', '%1$s.ValidationStatus = ' . LINK_VALIDATION_INVALID);
	}
	}

	/**
	* Restarts link validation process
	*
	* @param kEvent $event
	*/
	function OnRestartValidation($event)
	{
	$this->_resetValidation($event);

	$this->OnContinueValidation($event);
	}

	/**
	* Restarts link validation process
	*
	* @param kEvent $event
	*/
	function _resetValidation($event)
	{
	// 1. delete previous validation results
	$sql = 'SELECT ' . $this->Application->getUnitOption($event->Prefix, 'IDField') . '
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName');
	$ids = $this->Conn->GetCol($sql);

	if ($ids) {
	$temp_handler = $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	/* @var $temp_handler kTempTablesHandler */

	$temp_handler->DeleteItems($event->Prefix, $event->Special, $ids);
	}
	}

	/**
	* Validates only selected links
	*
	* @param kEvent $event
	*/
	function OnValidateSelected($event)
	{
	$link_ids = $this->_getSelectedIds($event);
	if (!$link_ids) {
	return ;
	}

	$validation_data = Array (
	'processed' => 0,
	'total' => count($link_ids),
	'items' => $link_ids,
	);
	$this->Application->StoreVar($event->Prefix . '_status', serialize($validation_data));

	$event->redirect = $this->Application->GetVar('progress_template');
	}

	/**
	* Validates only links, that were not previously validated
	*
	* @param kEvent $event
	*/
	function OnContinueValidation($event)
	{
	$have_data = $this->_prepareValidation($event);
	if ($have_data) {
	$event->redirect = $this->Application->GetVar('progress_template');
	}
	}

	/**
	* Performs validation
	*
	* @param kEvent $event
	* @param bool $from_ajax
	*/
	function _validate($event, $from_ajax = true)
	{
	$validation_data = unserialize( $this->Application->RecallVar($event->Prefix . '_status') );

	$i = 0;
	$link_ids = $validation_data['items'];
	$per_page = count($link_ids) >= LINK_VALIDATION_PER_PAGE ? LINK_VALIDATION_PER_PAGE : count($link_ids);

	while ($i < $per_page) {
	$this->_validateLink($link_ids[$i]);
	$i++;
	}

	// remove processed links from array
	array_splice($link_ids, 0, LINK_VALIDATION_PER_PAGE);

	// store validation progress
	$validation_data['processed'] += $i;
	$validation_data['items'] = $link_ids;

	if ($validation_data['processed'] >= $validation_data['total']) {
	// finished
	- $this->Application->EmailEventAdmin('LINK.VALIDATION.RESULTS');
	+ $this->Application->emailAdmin('LINK.VALIDATION.RESULTS');

	$this->Application->RemoveVar($event->Prefix . '_status');
	return true;
	}

	// show progress, proceed to next step
	$this->Application->StoreVar($event->Prefix . '_status', serialize($validation_data));

	if ($from_ajax) {
	echo $validation_data['processed'] / $validation_data['total'] * 100;
	$event->status = kEvent::erSTOP;
	}

	return false;
	}

	/**
	* Performs validation of links (called from AjaxProgressBar)
	*
	* @param kEvent $event
	*/
	function OnValidateProgress($event)
	{
	$done = $this->_validate($event, true);

	if ($done) {
	$this->Application->Redirect( $this->Application->GetVar('finish_template') );
	}
	}

	/**
	* Returns categories, that are located inside recycle bin category
	*
	* @return Array
	*/
	function _getRecycleBinCategories()
	{
	$recycle_bin = $this->Application->ConfigValue('RecycleBinFolder');
	if (!is_numeric($recycle_bin)) {
	return Array ();
	}

	$recycle_categories = $this->Application->RecallVar('recycle_categories');
	if ($recycle_categories === false) {
	$tree_indexes = $this->Application->getTreeIndex($recycle_bin);

	$sql = 'SELECT ' . $this->Application->getUnitOption('c', 'IDField') . '
	FROM ' . $this->Application->getUnitOption('c', 'TableName') . '
	WHERE TreeLeft BETWEEN ' . $tree_indexes['TreeLeft'] . ' AND ' . $tree_indexes['TreeRight'];
	$recycle_categories = serialize( $this->Conn->GetCol($sql) );

	// store recycle bin categories in session to prevent query below happening on each link validation step
	$this->Application->StoreVar('recycle_categories', $recycle_categories);
	}

	return unserialize($recycle_categories);

	}

	/**
	* Checks, that link is located in one of RecycleBin subcategories
	*
	* @param unknown_type $resource_id
	* @return unknown
	*/
	function _inRecycleBin($resource_id)
	{
	static $recycle_bin = null;

	if (!isset($recycle_bin)) {
	$recycle_bin = $this->_getRecycleBinCategories();
	}

	if (!$recycle_bin) {
	// Recycle Bin not used in system -> link is 100% not there
	return false;
	}

	$sql = 'SELECT CategoryId
	FROM ' . $this->Application->getUnitOption('l-ci', 'TableName') . '
	WHERE ItemResourceId = ' . $resource_id . ' AND PrimaryCat = 1';

	return in_array( $this->Conn->GetOne($sql), $recycle_bin);
	}

	function _validateLink($link_id)
	{
	$curl_helper = $this->Application->recallObject('CurlHelper');
	/* @var $curl_helper kCurlHelper */

	$sql = 'SELECT Url, ResourceId
	FROM ' . $this->Application->getUnitOption('l', 'TableName') . '
	WHERE ' . $this->Application->getUnitOption('l', 'IDField') . ' = ' . $link_id;
	$link_data = $this->Conn->GetRow($sql);

	if (!preg_match('/^(http\|https):\/\/(.*)/U', $link_data['Url']) \|\| $this->_inRecycleBin($link_data['ResourceId'])) {
	return ;
	}

	$curl_helper->timeout = LINK_VALIDATION_TIMEOUT;

	$result = $curl_helper->Send($link_data['Url']);
	if ($result === false \|\| $curl_helper->lastErrorMsg != '') {
	$curl_helper->lastErrorCode = 500;
	}

	$link_validation = $this->Application->recallObject($this->Prefix . '.-item', null, Array ('skip_autoload' => true));
	/* @var $link_validation kDBItem */

	$link_validation->Load($link_id, 'LinkId');

	$now = adodb_mktime();

	$fields_hash = Array (
	'LinkId' => $link_id,
	'ValidationTime_date' => $now,
	'ValidationTime_time' => $now,
	'ValidationCode' => $curl_helper->lastHTTPCode,
	'ValidationStatus' => $curl_helper->lastHTTPCode < 400 ? LINK_VALIDATION_VALID : LINK_VALIDATION_INVALID,
	);
	$link_validation->SetDBFieldsFromHash($fields_hash);

	return $link_validation->isLoaded() ? $link_validation->Update() : $link_validation->Create();
	}

	/**
	* Cancels validation (from validation progress bar)
	*
	* @param kEvent $event
	*/
	function OnCancelValidation($event)
	{
	$this->Application->RemoveVar($event->Prefix . '_status');
	}

	/**
	* Resets validation status for selected
	*
	* @param kEvent $event
	*/
	function OnResetValidationStatus($event)
	{
	$ids = $this->_getSelectedIds($event, true);
	if (!$ids) {
	return ;
	}

	$temp_handler = $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	/* @var $temp_handler kTempTablesHandler */

	$temp_handler->DeleteItems($event->Prefix, $event->Special, $ids);
	}

	/**
	* Returns ids, that user has checked in grid
	*
	* @param kEvent $event
	* @param bool $transform convert link ids to link validation ids
	* @return Array
	*/
	function _getSelectedIds($event, $transform = false)
	{
	$ids = Array();

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info) {
	foreach ($items_info as $id => $field_values) {
	if ( getArrayValue($field_values, 'ForeignLinkId') ) {
	// we are not gathering ids by unit idfield here!
	array_push($ids, $id);
	}
	}
	}

	if ($transform && $ids) {
	$sql = 'SELECT ' . $this->Application->getUnitOption($event->Prefix, 'IDField') . '
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . '
	WHERE LinkId IN (' . implode(',', $ids) . ')';
	$ids = $this->Conn->GetCol($sql);
	}

	return $ids;
	}

	/**
	* Approves/declines selected links
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function iterateItems(kEvent $event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return;
	}

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

	$object = $this->Application->recallObject('l.-item', null, Array ('skip_autoload' => true));
	/* @var $object kCatDBItem */

	foreach ($ids as $id) {
	$ret = true;
	$object->Load($id);

	switch ( $event->Name ) {
	case 'OnApproveLinks':
	$ret = $object->ApproveChanges();
	break;

	case 'OnDeclineLinks':
	$ret = $object->DeclineChanges();
	break;
	}

	if ( !$ret ) {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}

	/**
	* Deletes selected links
	*
	* @param kEvent $event
	*/
	function OnDeleteLinks($event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = kEvent::erFAIL;
	return;
	}

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

	$temp_handler = $this->Application->recallObject('l_TempHandler', 'kTempTablesHandler');
	/* @var $temp_handler kTempTablesHandler */

	$temp_handler->DeleteItems('l', '', $ids);
	}

	/**
	* [HOOK] Allows to edit links, used in selected link validation records
	*
	* @param kEvent $event
	*/
	function OnPrepareLinkEditing($event)
	{
	// hook to OnAfterConfigRead instead of OnEdit, because fake ids should be available in CheckPermission
	if ($this->Application->GetVar('l_event') != 'OnEdit') {
	return ;
	}

	$ids = $this->_getSelectedIds($event);
	$id_field = $this->Application->getUnitOption('l', 'IDField');

	$items_info = Array ();
	foreach ($ids as $id) {
	$items_info[$id][$id_field] = 'on';
	}

	$this->Application->SetVar('l', $items_info);
	}

	/**
	* Gets all links, that are not yet validated and prepare data
	*
	* @param kEvent $event
	*
	* @return bool
	*/
	function _prepareValidation($event)
	{
	// 2. get ids of all links and put them into validation queue
	$id_field = $this->Application->getUnitOption('l', 'IDField');
	$sql = 'SELECT ' . $id_field . '
	FROM ' . $this->Application->getUnitOption('l', 'TableName') . '
	WHERE LinkId NOT IN (SELECT LinkId FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . ')';
	$link_ids = $this->Conn->GetCol($sql);

	if ($link_ids) {
	$validation_data = Array (
	'processed' => 0,
	'total' => count($link_ids),
	'items' => $link_ids,
	);
	$this->Application->StoreVar($event->Prefix . '_status', serialize($validation_data)); // 4K links will be 78KB serialized
	return true;
	}

	return false;
	}

	/**
	* [SCHEDULED TASK] Performs link validation through cron
	*
	* @param kEvent $event
	*/
	function OnCronValidation($event)
	{
	$this->_resetValidation($event); // remove this for continuing to non validated before links

	$have_data = $this->_prepareValidation($event);
	if ($have_data) {
	do {
	$done = $this->_validate($event, false);
	} while (!$done);
	}
	}

	/**
	* Makes calculated fields to go to multilingual link fields
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterConfigRead(kEvent $event)
	{
	parent::OnAfterConfigRead($event);

	$calculated_fields = $this->Application->getUnitOption($event->Prefix, 'CalculatedFields');
	$calculated_fields['']['LinkName'] = 'l.l' . $this->Application->GetVar('m_lang') . '_Name';
	$this->Application->setUnitOption($event->Prefix, 'CalculatedFields', $calculated_fields);
	}

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

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

	class ListingsEventHandler extends kDBEventHandler {

	/**
	* Allows to override standard permission mapping
	*
	* @return void
	* @access protected
	* @see kEventHandler::$permMapping
	*/
	protected 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;
	}

	/**
	* Occurs before updating item
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeItemUpdate(kEvent $event)
	{
	$object = $event->getObject();
	/* @var $object kDBItem */

	if ( $object->IgnoreValidation ) {
	$object->UpdateFormattersMasterFields();
	}
	}

	/**
	* Occurs before creating item
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeItemCreate(kEvent $event)
	{
	parent::OnBeforeItemCreate($event);

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

	if ( $object->IgnoreValidation ) {
	$object->UpdateFormattersMasterFields();
	}
	}

	/**
	* Occurs before an item is deleted from live table when copying from temp
	* (temp handler deleted all items from live and then copy over all items from temp)
	* Id of item being deleted is passed as event' 'id' param
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeDeleteFromLive(kEvent $event)
	{
	parent::OnBeforeDeleteFromLive($event);

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

	$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.DENY';
	$sql = 'SELECT CreatedById
	FROM ' . $this->Application->getUnitOption('l', 'TableName') . '
	WHERE ResourceId = ' . $object->GetDBField('ItemResourceId');
	$user_id = $this->Conn->GetOne($sql);

	- $this->Application->EmailEventUser($email_event, $user_id);
	- $this->Application->EmailEventAdmin($email_event);
	+ $this->Application->emailUser($email_event, $user_id);
	+ $this->Application->emailAdmin($email_event);
	}

	if ( $type_modified \|\| $link_modified ) {
	$this->ResetLink($original_values);
	}

	if ( $status_modified \|\| $type_modified \|\| $link_modified ) {
	$this->EnhanceLink($object, $original_values);
	}

	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') )
	{
	$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)
	{
	$new_processing = false;
	$link_id = $listing_type_id = 0;

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

	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->GetFieldValues();
	}
	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 => 3600247,
	6 => 360024365/12,
	7 => 360024365
	);
	$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 = kEvent::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');
	- $this->Application->EmailEventUser('LINK.ENHANCE', $this->Conn->GetOne($sql));
	- $this->Application->EmailEventAdmin('LINK.ENHANCE');
	+ $this->Application->emailUser('LINK.ENHANCE', $this->Conn->GetOne($sql));
	+ $this->Application->emailAdmin('LINK.ENHANCE');
	break;
	}


	}
	else {
	$event->status = kEvent::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) );
	/* @var $object kDBItem */

	$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));
	/* @var $object kDBItem */

	$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->GetFieldValues();
	$object->SetDBField('Status', 2);

	if ( $object->Update() ) {
	$event->status = kEvent::erSUCCESS;
	$this->ResetLink($original_values);
	}
	else {
	$event->status = kEvent::erFAIL;
	}
	}

	/**
	* Apply same processing to each item being selected in grid
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function iterateItems(kEvent $event)
	{
	$object = $event->getObject(Array ('skip_autoload' => true));
	/* @var $object kDBItem */

	$ids = $this->StoreSelectedIDs($event);

	if ( $event->Name == 'OnMassApprove' ) {
	foreach ($ids as $id) {
	$object->Load($id);
	if ( $object->GetDBField('Status') != STATUS_ACTIVE ) {
	$original_values = $object->GetFieldValues();
	$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->GetFieldValues();
	$this->ResetLink($original_values);

	$sql = 'SELECT CreatedById
	FROM ' . $this->Application->getUnitOption('l', 'TableName') . '
	WHERE ResourceId = ' . $object->GetDBField('ItemResourceId');
	- $this->Application->EmailEventUser('LINK.ENHANCE.DENY', $this->Conn->GetOne($sql));
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.DENY');
	+ $this->Application->emailUser('LINK.ENHANCE.DENY', $this->Conn->GetOne($sql));
	+ $this->Application->emailAdmin('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));
	/* @var $lst_object kDBItem */

	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 = kEvent::erSUCCESS;
	$event->SetRedirectParam('opener', 's');
	- $this->Application->EmailEventUser('LINK.ENHANCE.RENEW', $owner_id);
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.RENEW');
	+ $this->Application->emailUser('LINK.ENHANCE.RENEW', $owner_id);
	+ $this->Application->emailAdmin('LINK.ENHANCE.RENEW');
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	else {
	- $this->Application->EmailEventUser('LINK.ENHANCE.APPROVE', $owner_id);
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.APPROVE');
	+ $this->Application->emailUser('LINK.ENHANCE.APPROVE', $owner_id);
	+ $this->Application->emailAdmin('LINK.ENHANCE.APPROVE');
	}
	}
	}
	}

	/**
	* Redirects to cancel template on front-end
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnCancel(kEvent $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 = kEvent::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');
	- $this->Application->EmailEventUser('LINK.ENHANCE.EXTEND', $this->Conn->GetOne($sql));
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.EXTEND');
	+ $this->Application->emailUser('LINK.ENHANCE.EXTEND', $this->Conn->GetOne($sql));
	+ $this->Application->emailAdmin('LINK.ENHANCE.EXTEND');
	}

	/**
	* Cancels enhancement
	*
	* @param kEvent $event
	*/
	function OnCancelEnhancement($event)
	{
	$listing_id = $this->verifyListingOwner($event);
	if ( !$listing_id ) {
	return;
	}

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

	$object->Load($listing_id);

	$original_values = $object->GetFieldValues();
	$original_values['Status'] = 1;
	$this->ResetLink($original_values);

	$sql = 'SELECT CreatedById FROM ' . $this->Application->getUnitOption('l', 'TableName') . '
	WHERE ResourceId = ' . $object->GetDBField('ItemResourceId');
	- $this->Application->EmailEventUser('LINK.ENHANCE.CANCEL', $this->Conn->GetOne($sql));
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.CANCEL');
	+ $this->Application->emailUser('LINK.ENHANCE.CANCEL', $this->Conn->GetOne($sql));
	+ $this->Application->emailAdmin('LINK.ENHANCE.CANCEL');

	$object->Delete();
	$event->redirect = $this->Application->GetVar('success_template');
	}

	/**
	* Checks expired paid listings
	*
	* @param kEvent $event
	*/
	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));
	/* @var $object kDBItem */

	foreach($expired_listings as $listing_id)
	{
	$object->Load($listing_id);
	$original_values = $object->GetFieldValues();
	$this->ResetLink($original_values);
	$object->SetDBField('Status', 2);
	$object->Update();

	$sql = 'SELECT CreatedById FROM '.$this->Application->getUnitOption('l', 'TableName').'
	WHERE ResourceId = '.$object->GetDBField('ItemResourceId');
	- $this->Application->EmailEventUser('LINK.ENHANCE.EXPIRE', $this->Conn->GetOne($sql));
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.EXPIRE');
	+ $this->Application->emailUser('LINK.ENHANCE.EXPIRE', $this->Conn->GetOne($sql));
	+ $this->Application->emailAdmin('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)
	{
	- $this->Application->EmailEventUser('LINK.ENHANCE.RENEWAL.NOTICE', $record['CreatedById']);
	- $this->Application->EmailEventAdmin('LINK.ENHANCE.RENEWAL.NOTICE');
	+ $this->Application->emailUser('LINK.ENHANCE.RENEWAL.NOTICE', $record['CreatedById']);
	+ $this->Application->emailAdmin('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);
	}
	}

	/**
	* Removes enhancements on listing delete
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnMassDelete(kEvent $event)
	{
	$object = $event->getObject(Array ('skip_autoload' => true));
	/* @var $object kDBItem */

	$ids = $this->StoreSelectedIDs($event);

	foreach ($ids as $id) {
	$object->Load($id);

	if ( $object->GetDBField('Status') == STATUS_ACTIVE ) {
	$this->ResetLink( $object->GetFieldValues() );
	}
	}

	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 calculated fields to go to multilingual link fields
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterConfigRead(kEvent $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.2.x/install/install_data.sql
	===================================================================
	--- branches/5.2.x/install/install_data.sql (revision 15605)
	+++ branches/5.2.x/install/install_data.sql (revision 15606)
	@@ -1,226 +1,226 @@
	# Section "in-link:configuration_output":
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_SortField', 'Name', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name\|\|Description=la_Link_Description\|\|Url=la_Link_URL\|\|CreatedOn=la_opt_CreatedOn\|\|Hits=la_Link_Hits\|\|CachedRating=la_opt_Rating\|\|<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomFields WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_SortOrder', 'asc', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'asc=la_common_ascending\|\|desc=la_common_descending', 10.01, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_SortField2', 'Description', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name\|\|Description=la_Link_Description\|\|Url=la_Link_URL\|\|CreatedOn=la_opt_CreatedOn\|\|Hits=la_Link_Hits\|\|CachedRating=la_opt_Rating\|\|<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomFields WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_SortOrder2', 'desc', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'asc=la_common_ascending\|\|desc=la_common_descending', 10.02, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Perpage_Links', '10', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_perpage_prompt', 'text', '', '', 10.03, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Perpage_Links_Short', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_perpage_short_prompt', 'text', '', '', 10.04, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_NewDays', '100', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_newdays_prompt', 'text', '', '', 10.05, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_MinPopRating', '5', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MinPopRating', 'text', '', '', 10.06, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_MinPopVotes', '20', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MinPopVotes', 'text', '', '', 10.07, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_MaxHotNumber', '5', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_Link_MaxHotNumber', 'text', '', '', 10.08, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_EnhancedLinks', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_EnhancedLinks', 'checkbox', '', '', 10.09, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_AllowFreeListings', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_AllowFreeListings', 'checkbox', '', '', 10.1, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_ShowPick', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_link_editorspick_prompt', 'checkbox', '', '', 10.11, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'link_ReviewDelay_Value', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupReviews', 'text', '', 'style="width: 50px;"', 10.12, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'link_ReviewDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupReviews', 'select', '', '1=la_opt_Sec\|\|60=la_opt_Min\|\|3600=la_opt_Hour\|\|86400=la_opt_Day\|\|604800=la_opt_Week\|\|2419200=la_opt_Month\|\|29030400=la_opt_Year', 10.12, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'link_RatingDelay_Value', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupRating', 'text', '', 'style="width: 50px;"', 10.13, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'link_RatingDelay_Interval', '2419200', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_prompt_DupRating', 'select', '', '1=la_opt_Sec\|\|60=la_opt_Min\|\|3600=la_opt_Hour\|\|86400=la_opt_Day\|\|604800=la_opt_Week\|\|2419200=la_opt_Month\|\|29030400=la_opt_Year', 10.13, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_MaxCategories', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_MaxCategories', 'text', NULL, NULL, 10.14, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_EnableGoogleMaps', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_fld_LinkEnableGoogleMaps', 'checkbox', NULL, NULL, 10.15, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_EnableLinkContactForm', '1', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_config_EnableLinkContactForm', 'checkbox', NULL, NULL, 10.16, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'ReciprocalLinkChecking', '0', 'In-Link', 'in-link:configuration_output', 'la_Text_Links', 'la_config_ReciprocalLinkChecking', 'checkbox', NULL, NULL, 10.17, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_ReviewsSort', 'CreatedOn', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'ReviewText=la_opt_CommentText\|\|CreatedOn=la_opt_CreatedOn', 20.01, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_ReviewsOrder', 'desc', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews_prompt', 'select', '', 'asc=la_common_Ascending\|\|desc=la_common_Descending', 20.01, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_ReviewsSort2', 'ReviewText', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'ReviewText=la_opt_CommentText\|\|CreatedOn=la_opt_CreatedOn', 20.02, 1, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Link_ReviewsOrder2', 'asc', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_link_sortreviews2_prompt', 'select', '', 'asc=la_common_Ascending\|\|desc=la_common_Descending', 20.02, 2, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Perpage_LinkReviews', '10', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_review_perpage_prompt', 'text', NULL, NULL, 20.03, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Perpage_LinkReviews_Short', '3', 'In-Link', 'in-link:configuration_output', 'la_Text_Reviews', 'la_review_perpage_short_prompt', 'text', NULL, NULL, 20.04, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_CategoryTemplate', '/in-link/designs/section', 'In-Link', 'in-link:configuration_output', 'la_section_Templates', 'la_fld_CategoryTemplate', 'text', '', '', 30.01, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_ItemTemplate', 'in-link/links/link_detail', 'In-Link', 'in-link:configuration_output', 'la_section_Templates', 'la_fld_ItemTemplate', 'text', '', '', 30.02, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_MaxImageCount', '5', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_MaxImageCount', 'text', '', '', 40.01, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_ThumbnailImageWidth', '120', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_ThumbnailImageWidth', 'text', '', '', 40.02, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_ThumbnailImageHeight', '120', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_ThumbnailImageHeight', 'text', '', '', 40.03, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_FullImageWidth', '450', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_FullImageWidth', 'text', '', '', 40.04, 0, 0, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'l_FullImageHeight', '450', 'In-Link', 'in-link:configuration_output', 'la_section_ImageSettings', 'la_config_FullImageHeight', 'text', '', '', 40.05, 0, 0, NULL);

	# Section "in-link:configuration_search":
	INSERT INTO SystemSettings VALUES(DEFAULT, 'SearchRel_Keyword_links', '90', 'In-Link', 'in-link:configuration_search', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'SearchRel_Pop_links', '5', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'SearchRel_Rating_links', '5', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'SearchRel_Increase_links', '30', 'In-Link', 'in-link:configuration_search', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 0, 1, NULL);
	INSERT INTO SystemSettings VALUES(DEFAULT, 'Search_ShowMultiple_links', '0', 'In-Link', 'in-link:configuration_search', 'la_config_ShowMultiple', 'la_Text_MultipleShow', 'text', NULL, NULL, 0, 0, 1, NULL);

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

	INSERT INTO CustomFields VALUES (DEFAULT, 4, 'LinkAddress', 'lu_fld_LinkAddress', 0, 'la_section_BusinessLocation', 'la_fld_LinkAddress', 'text', 'size="40"', '', 1, 1, 0, 0);
	INSERT INTO CustomFields VALUES (DEFAULT, 4, 'LinkCity', 'lu_fld_LinkCity', 0, 'la_section_BusinessLocation', 'la_fld_LinkCity', 'text', 'size="40"', '', 2, 1, 0, 0);
	INSERT INTO CustomFields VALUES (DEFAULT, 4, 'LinkZipCode', 'lu_fld_LinkZipCode', 0, 'la_section_BusinessLocation', 'la_fld_LinkZipCode', 'text', NULL, '', 4, 1, 0, 0);
	INSERT INTO CustomFields VALUES (DEFAULT, 4, 'LinkState', 'lu_fld_LinkState', 0, 'la_section_BusinessLocation', 'la_fld_LinkState', 'select', '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 2 ORDER BY StateCountryId DESC, IsoCode ASC</SQL>', '', 3, 1, 0, 0);
	INSERT INTO CustomFields VALUES (DEFAULT, 4, 'LinkCountry', 'lu_fld_LinkCountry', 0, 'la_section_BusinessLocation', 'la_fld_LinkCountry', 'select', '=+\|\|<SQL+>SELECT IsoCode AS OptionValue, l%3$s_Name AS OptionName FROM <PREFIX>CountryStates WHERE Type = 1 ORDER BY IsoCode ASC</SQL>', '', 5, 1, 0, 0);
	INSERT INTO CustomFields 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 CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.ADD', 'la_PermName_Link.Add_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.VIEW', 'la_PermName_Link.View_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.ADD.PENDING', 'la_PermName_Link.Add.Pending_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.MODIFY', 'la_PermName_Link.Modify_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.DELETE', 'la_PermName_Link.Delete_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.RATE', 'la_PermName_Link.Rate_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.REVIEW', 'la_PermName_Link.Review_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.REVIEW.PENDING', 'la_PermName_Link.Review_Pending_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.MODIFY.PENDING', 'la_PermName_Link.Modify.Pending_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 'la_PermName_Link.Owner.Modify_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 'la_PermName_Link.Owner.Modify.Pending_desc', 'In-Link', 1);
	INSERT INTO CategoryPermissionsConfig VALUES (DEFAULT, 'LINK.OWNER.DELETE', 'la_PermName_Link.Owner.Delete_desc', 'In-Link', 1);

	INSERT INTO SearchConfig VALUES ('Link', 'OrgId', 0, 0, 'lu_fielddesc_link_orgid', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_field_modifiedbyid', 'In-Link', 'la_text_link', 11, DEFAULT, 0, 'text', 'Users.Username', '{ForeignTable}.PortalUserId={LocalTable}.ModifiedById', NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('Link', 'CreatedById', 0, 0, 'lu_fielddesc_link_createdbyid', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_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', 'lc_field_cachedrating', 'In-Link', 'la_text_link', 7, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkAddress', 1, 1, 'la_fld_LinkAddress', 'lu_fld_LinkAddress', 'In-Link', 'la_section_BusinessLocation', 1, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkCity', 1, 1, 'la_fld_LinkCity', 'lu_fld_LinkCity', 'In-Link', 'la_section_BusinessLocation', 2, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkState', 1, 1, 'la_fld_LinkState', 'lu_fld_LinkState', 'In-Link', 'la_section_BusinessLocation', 3, DEFAULT, 0, 'select', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkZipCode', 1, 1, 'la_fld_LinkZipCode', 'lu_fld_LinkZipCode', 'In-Link', 'la_section_BusinessLocation', 4, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkCountry', 1, 1, 'la_fld_LinkCountry', 'lu_fld_LinkCountry', 'In-Link', 'la_section_BusinessLocation', 5, DEFAULT, 0, 'select', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
	INSERT INTO SearchConfig VALUES ('CustomFields', 'LinkPhone', 1, 1, 'la_fld_LinkPhone', 'lu_fld_LinkPhone', 'In-Link', 'la_section_BusinessLocation', 6, 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%>CatalogReviews WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);

	INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 14, 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, '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, '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.add', 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_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 CustomFields VALUES (DEFAULT, 1, 'l_ItemTemplate', 'la_fld_cust_l_ItemTemplate ', 0, 'la_title_SystemCF', 'la_fld_cust_l_ItemTemplate ', 'text', NULL, '', 0, 0, 1, 0);

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

	INSERT INTO Modules VALUES ('In-Link', 'modules/in-link/', 'l', DEFAULT, 1, 1, 'in-link/', 2, NULL, NULL);

in-linkNo OneTemporaryActions

File Metadata

in-linkView Options

Event Timeline

in-link
No OneTemporary
Actions

in-link
View Options