in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Thu, Feb 6, 12:12 AM

in-portal
View Options

	Index: branches/5.2.x/core/kernel/db/db_event_handler.php
	===================================================================
	--- branches/5.2.x/core/kernel/db/db_event_handler.php (revision 14609)
	+++ branches/5.2.x/core/kernel/db/db_event_handler.php (revision 14610)
	@@ -1,3091 +1,3104 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @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!');

	define('EH_CUSTOM_PROCESSING_BEFORE',1);
	define('EH_CUSTOM_PROCESSING_AFTER',2);

	/**
	* Note:
	* 1. When adressing variables from submit containing
	* Prefix_Special as part of their name use
	* $event->getPrefixSpecial(true) instead of
	* $event->getPrefixSpecial() as usual. This is due PHP
	* is converting "." symbols in variable names during
	* submit info "_". $event->getPrefixSpecial optional
	* 1st parameter returns correct corrent Prefix_Special
	* for variables beeing submitted such way (e.g. variable
	* name that will be converted by PHP: "users.read_only_id"
	* will be submitted as "users_read_only_id".
	*
	* 2. When using $this->Application-LinkVar on variables submitted
	* from form which contain $Prefix_Special then note 1st item. Example:
	* LinkVar($event->getPrefixSpecial(true).'_varname',$event->getPrefixSpecial().'_varname')
	*
	*/


	/**
	* EventHandler that is used to process
	* any database related events
	*
	*/
	class kDBEventHandler extends kEventHandler {

	/**
	* Checks permissions of user
	*
	* @param kEvent $event
	* @return bool
	* @access public
	*/
	function CheckPermission(&$event)
	{
	$section = $event->getSection();

	if (!$this->Application->isAdmin) {
	$allow_events = Array('OnSearch', 'OnSearchReset', 'OnNew');
	if (in_array($event->Name, $allow_events)) {
	// allow search on front
	return true;
	}
	}
	elseif (($event->Name == 'OnPreSaveAndChangeLanguage') && !$this->UseTempTables($event)) {
	// allow changing language in grids, when not in editing mode
	return $this->Application->CheckPermission($section . '.view', 1);
	}

	if (!preg_match('/^CATEGORY:(.*)/', $section)) {
	// only if not category item events
	if ((substr($event->Name, 0, 9) == 'OnPreSave') \|\| ($event->Name == 'OnSave')) {
	if ($this->isNewItemCreate($event)) {
	return $this->Application->CheckPermission($section.'.add', 1);
	}
	else {
	return $this->Application->CheckPermission($section.'.add', 1) \|\| $this->Application->CheckPermission($section.'.edit', 1);
	}
	}
	}

	if ($event->Name == 'OnPreCreate') {
	// save category_id before item create (for item category selector not to destroy permission checking category)
	$this->Application->LinkVar('m_cat_id');
	}

	if ($event->Name == 'OnSaveWidths') {
	return $this->Application->isAdminUser;
	}

	return parent::CheckPermission($event);
	}

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnLoad' => Array('self' => 'view', 'subitem' => 'view'),
	'OnItemBuild' => Array('self' => 'view', 'subitem' => 'view'),
	'OnSuggestValues' => Array('self' => 'view', 'subitem' => 'view'),

	'OnBuild' => Array('self' => true),

	'OnNew' => Array('self' => 'add', 'subitem' => 'add\|edit'),
	'OnCreate' => Array('self' => 'add', 'subitem' => 'add\|edit'),
	'OnUpdate' => Array('self' => 'edit', 'subitem' => 'add\|edit'),
	'OnSetPrimary' => Array('self' => 'add\|edit', 'subitem' => 'add\|edit'),
	'OnDelete' => Array('self' => 'delete', 'subitem' => 'add\|edit'),
	'OnDeleteAll' => Array('self' => 'delete', 'subitem' => 'add\|edit'),
	'OnMassDelete' => Array('self' => 'delete', 'subitem' => 'add\|edit'),
	'OnMassClone' => Array('self' => 'add', 'subitem' => 'add\|edit'),

	'OnCut' => array('self'=>'edit', 'subitem' => 'edit'),
	'OnCopy' => array('self'=>'edit', 'subitem' => 'edit'),
	'OnPaste' => array('self'=>'edit', 'subitem' => 'edit'),

	'OnSelectItems' => Array('self' => 'add\|edit', 'subitem' => 'add\|edit'),
	'OnProcessSelected' => Array('self' => 'add\|edit', 'subitem' => 'add\|edit'),
	'OnStoreSelected' => Array('self' => 'add\|edit', 'subitem' => 'add\|edit'),
	'OnSelectUser' => Array('self' => 'add\|edit', 'subitem' => 'add\|edit'),

	'OnMassApprove' => Array('self' => 'advanced:approve\|edit', 'subitem' => 'advanced:approve\|add\|edit'),
	'OnMassDecline' => Array('self' => 'advanced:decline\|edit', 'subitem' => 'advanced:decline\|add\|edit'),
	'OnMassMoveUp' => Array('self' => 'advanced:move_up\|edit', 'subitem' => 'advanced:move_up\|add\|edit'),
	'OnMassMoveDown' => Array('self' => 'advanced:move_down\|edit', 'subitem' => 'advanced:move_down\|add\|edit'),

	'OnPreCreate' => Array('self' => 'add\|add.pending', 'subitem' => 'edit\|edit.pending'),
	'OnEdit' => Array('self' => 'edit\|edit.pending', 'subitem' => 'edit\|edit.pending'),

	'OnExport' => Array('self' => 'view\|advanced:export'),
	'OnExportBegin' => Array('self' => 'view\|advanced:export'),
	'OnExportProgress' => Array('self' => 'view\|advanced:export'),


	'OnSetAutoRefreshInterval' => Array ('self' => true, 'subitem' => true),
	'OnAutoRefreshToggle' => Array ('self' => true, 'subitem' => true),

	// theese event do not harm, but just in case check them too :)
	'OnCancelEdit' => Array('self' => true, 'subitem' => true),
	'OnCancel' => Array('self' => true, 'subitem' => true),
	'OnReset' => Array('self' => true, 'subitem' => true),

	'OnSetSorting' => Array('self' => true, 'subitem' => true),
	'OnSetSortingDirect' => Array('self' => true, 'subitem' => true),
	'OnResetSorting' => Array('self' => true, 'subitem' => true),

	'OnSetFilter' => Array('self' => true, 'subitem' => true),
	'OnApplyFilters' => Array('self' => true, 'subitem' => true),
	'OnRemoveFilters' => Array('self' => true, 'subitem' => true),
	'OnSetFilterPattern' => Array('self' => true, 'subitem' => true),

	'OnSetPerPage' => Array('self' => true, 'subitem' => true),
	'OnSetPage' => Array('self' => true, 'subitem' => true),

	'OnSearch' => Array('self' => true, 'subitem' => true),
	'OnSearchReset' => Array('self' => true, 'subitem' => true),

	'OnGoBack' => Array('self' => true, 'subitem' => true),

	// it checks permission itself since flash uploader does not send cookies
	'OnUploadFile' => Array ('self' => true, 'subitem' => true),
	'OnDeleteFile' => Array ('self' => true, 'subitem' => true),

	'OnViewFile' => Array ('self' => true, 'subitem' => true),
	'OnSaveWidths' => Array ('self' => true, 'subitem' => true),

	'OnValidateMInputFields' => Array ('self' => 'view'),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	function mapEvents()
	{
	$events_map = Array(
	'OnRemoveFilters' => 'FilterAction',
	'OnApplyFilters' => 'FilterAction',
	'OnMassApprove'=>'iterateItems',
	'OnMassDecline'=>'iterateItems',
	'OnMassMoveUp'=>'iterateItems',
	'OnMassMoveDown'=>'iterateItems',
	);

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

	/**
	* Returns ID of current item to be edited
	* by checking ID passed in get/post as prefix_id
	* or by looking at first from selected ids, stored.
	* Returned id is also stored in Session in case
	* it was explicitly passed as get/post
	*
	* @param kEvent $event
	* @return int
	*/
	function getPassedID(&$event)
	{
	if ($event->getEventParam('raise_warnings') === false) {
	$event->setEventParam('raise_warnings', 1);
	}

	if (preg_match('/^auto-(.*)/', $event->Special, $regs) && $this->Application->prefixRegistred($regs[1])) {
	// <inp2:lang.auto-phrase_Field name="DateFormat"/> - returns field DateFormat value from language (LanguageId is extracted from current phrase object)
	$main_object =& $this->Application->recallObject($regs[1]);
	/* @var $main_object kDBItem */

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	return $main_object->GetDBField($id_field);
	}

	// 1. get id from post (used in admin)
	$ret = $this->Application->GetVar($event->getPrefixSpecial(true).'_id');
	if (($ret !== false) && ($ret != '')) {
	return $ret;
	}

	// 2. get id from env (used in front)
	$ret = $this->Application->GetVar($event->getPrefixSpecial().'_id');
	if (($ret !== false) && ($ret != '')) {
	return $ret;
	}

	// recall selected ids array and use the first one
	$ids = $this->Application->GetVar($event->getPrefixSpecial().'_selected_ids');
	if ($ids != '') {
	$ids = explode(',',$ids);
	if ($ids) {
	$ret = array_shift($ids);
	}
	}
	else { // if selected ids are not yet stored
	$this->StoreSelectedIDs($event);
	return $this->Application->GetVar($event->getPrefixSpecial().'_id'); // StoreSelectedIDs sets this variable
	}

	return $ret;
	}

	/**
	* Prepares and stores selected_ids string
	* in Session and Application Variables
	* by getting all checked ids from grid plus
	* id passed in get/post as prefix_id
	*
	* @param kEvent $event
	* @param Array $direct_ids
	*
	* @return Array ids stored
	*/
	function StoreSelectedIDs(&$event, $direct_ids = null)
	{
	$wid = $this->Application->GetTopmostWid($event->Prefix);
	$session_name = rtrim($event->getPrefixSpecial().'_selected_ids_'.$wid, '_');

	$ids = $event->getEventParam('ids');
	if (isset($direct_ids) \|\| ($ids !== false)) {
	// save ids directly if they given + reset array indexes
	$resulting_ids = $direct_ids ? array_values($direct_ids) : ($ids ? array_values($ids) : false);
	if ($resulting_ids) {
	$this->Application->SetVar($event->getPrefixSpecial() . '_selected_ids', implode(',', $resulting_ids));
	$this->Application->LinkVar($event->getPrefixSpecial() . '_selected_ids', $session_name, '', true);
	$this->Application->SetVar($event->getPrefixSpecial() . '_id', $resulting_ids[0]);

	return $resulting_ids;
	}

	return Array ();
	}

	$ret = Array();

	// May be we don't need this part: ?
	$passed = $this->Application->GetVar($event->getPrefixSpecial(true).'_id');
	if($passed !== false && $passed != '')
	{
	array_push($ret, $passed);
	}

	$ids = Array();

	// get selected ids from post & save them to session
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if($items_info)
	{
	$id_field = $this->Application->getUnitOption($event->Prefix,'IDField');
	foreach($items_info as $id => $field_values)
	{
	if( getArrayValue($field_values,$id_field) ) array_push($ids,$id);
	}
	//$ids=array_keys($items_info);
	}

	$ret = array_unique(array_merge($ret, $ids));

	$this->Application->SetVar($event->getPrefixSpecial().'_selected_ids', implode(',',$ret));
	$this->Application->LinkVar($event->getPrefixSpecial().'_selected_ids', $session_name, '', !$ret); // optional when IDs are missing

	// This is critical - otherwise getPassedID will return last ID stored in session! (not exactly true)
	// this smells... needs to be refactored
	$first_id = getArrayValue($ret,0);
	if (($first_id === false) && ($event->getEventParam('raise_warnings') == 1)) {
	if ( $this->Application->isDebugMode() ) {
	$this->Application->Debugger->appendTrace();
	}

	trigger_error('Requested ID for prefix <strong>' . $event->getPrefixSpecial() . '</strong> <span class="debug_error">not passed</span>', E_USER_NOTICE);
	}

	$this->Application->SetVar($event->getPrefixSpecial() . '_id', $first_id);
	return $ret;
	}

	/**
	* Returns stored selected ids as an array
	*
	* @param kEvent $event
	* @param bool $from_session return ids from session (written, when editing was started)
	* @return array
	*/
	function getSelectedIDs(&$event, $from_session = false)
	{
	if ($from_session) {
	$wid = $this->Application->GetTopmostWid($event->Prefix);
	$var_name = rtrim($event->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	$ret = $this->Application->RecallVar($var_name);
	}
	else {
	$ret = $this->Application->GetVar($event->getPrefixSpecial().'_selected_ids');
	}

	return explode(',', $ret);
	}

	/**
	* Stores IDs, selected in grid in session
	*
	* @param kEvent $event
	*/
	function OnStoreSelected(&$event)
	{
	$this->StoreSelectedIDs($event);

	$id = $this->Application->GetVar($event->getPrefixSpecial() . '_id');

	if ($id !== false) {
	$event->SetRedirectParam($event->getPrefixSpecial() . '_id', $id);
	$event->SetRedirectParam('pass', 'all,' . $event->getPrefixSpecial());
	}
	}

	/**
	* Returs associative array of submitted fields for current item
	* Could be used while creating/editing single item -
	* meaning on any edit form, except grid edit
	*
	* @param kEvent $event
	*/
	function getSubmittedFields(&$event)
	{
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	$field_values = $items_info ? array_shift($items_info) : Array();
	return $field_values;
	}

	/**
	* Removes any information about current/selected ids
	* from Application variables and Session
	*
	* @param kEvent $event
	*/
	function clearSelectedIDs(&$event)
	{
	$prefix_special = $event->getPrefixSpecial();

	$ids = implode(',', $this->getSelectedIDs($event, true));
	$event->setEventParam('ids', $ids);

	$wid = $this->Application->GetTopmostWid($event->Prefix);
	$session_name = rtrim($prefix_special.'_selected_ids_'.$wid, '_');

	$this->Application->RemoveVar($session_name);
	$this->Application->SetVar($prefix_special.'_selected_ids', '');

	$this->Application->SetVar($prefix_special.'_id', ''); // $event->getPrefixSpecial(true).'_id' too may be
	}

	/**
	* Common builder part for Item & List
	*
	* @param kDBBase $object
	* @param kEvent $event
	* @access private
	*/
	function dbBuild(&$object, &$event)
	{
	// for permission checking inside item/list build events
	$event->setEventParam('top_prefix', $this->Application->GetTopmostPrefix($event->Prefix, true));

	if ( $event->getEventParam('form_name') !== false ) {
	$form_name = $event->getEventParam('form_name');
	}
	else {
	$request_forms = $this->Application->GetVar('forms', Array ());
	$form_name = (string)getArrayValue( $request_forms, $object->getPrefixSpecial() );
	}

	$object->Configure( $event->getEventParam('populate_ml_fields') \|\| $this->Application->getUnitOption($event->Prefix, 'PopulateMlFields'), $form_name );
	$this->PrepareObject($object, $event);

	$parent_event = $event->getEventParam('parent_event');

	if ( is_object($parent_event) ) {
	$object->setParentEvent($parent_event);
	}

	// force live table if specified or is original item
	$live_table = $event->getEventParam('live_table') \|\| $event->Special == 'original';

	if( $this->UseTempTables($event) && !$live_table )
	{
	$object->SwitchToTemp();
	}

	$this->Application->setEvent($event->getPrefixSpecial(), '');

	$save_event = $this->UseTempTables($event) && $this->Application->GetTopmostPrefix($event->Prefix) == $event->Prefix ? 'OnSave' : 'OnUpdate';
	$this->Application->SetVar($event->getPrefixSpecial().'_SaveEvent',$save_event);
	}

	/**
	* Checks, that currently loaded item is allowed for viewing (non permission-based)
	*
	* @param kEvent $event
	* @return bool
	*/
	function checkItemStatus(&$event)
	{
	$status_fields = $this->Application->getUnitOption($event->Prefix,'StatusField');
	if (!$status_fields) {
	return true;
	}

	$status_field = array_shift($status_fields);
	if ($status_field == 'Status' \|\| $status_field == 'Enabled') {
	$object =& $event->getObject();
	if (!$object->isLoaded()) {
	return true;
	}

	return $object->GetDBField($status_field) == STATUS_ACTIVE;
	}
	return true;
	}

	/**
	* Shows not found template content
	*
	* @param kEvent $event
	*
	*/
	function _errorNotFound(&$event)
	{
	if ($event->getEventParam('raise_warnings') === 0) {
	// when it's possible, that autoload fails do nothing
	return ;
	}

	if ( $this->Application->isDebugMode() ) {
	$this->Application->Debugger->appendTrace();
	}

	trigger_error('ItemLoad Permission Failed for prefix [' . $event->getPrefixSpecial() . '] in <strong>checkItemStatus</strong>, leading to "404 Not Found"', E_USER_NOTICE);

	header('HTTP/1.0 404 Not Found');

	while (ob_get_level()) {
	ob_end_clean();
	}

	// object is used inside template parsing, so break out any parsing and return error document
	$error_template = $this->Application->ConfigValue('ErrorTemplate');

	$themes_helper =& $this->Application->recallObject('ThemesHelper');
	/* @var $themes_helper kThemesHelper */

	$this->Application->SetVar('t', $error_template);
	$this->Application->SetVar('m_cat_id', $themes_helper->getPageByTemplate($error_template));

	// in case if missing item is recalled first from event (not from template)
	$this->Application->InitParser();
	$this->Application->HTML = $this->Application->ParseBlock( Array ('name' => $error_template) );
	$this->Application->Done();
	exit;
	}

	/**
	* Builds item (loads if needed)
	*
	* Pattern: Prototype Manager
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnItemBuild(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$this->dbBuild($object, $event);

	$sql = $this->ItemPrepareQuery($event);
	$sql = $this->Application->ReplaceLanguageTags($sql);
	$object->setSelectSQL($sql);

	// 2. loads if allowed
	$auto_load = $this->Application->getUnitOption($event->Prefix,'AutoLoad');
	$skip_autload = $event->getEventParam('skip_autoload');

	if ($auto_load && !$skip_autload) {
	$perm_status = true;
	$user_id = $this->Application->RecallVar('user_id');
	$event->setEventParam('top_prefix', $this->Application->GetTopmostPrefix($event->Prefix, true));
	$status_checked = false;
	if ($user_id == USER_ROOT \|\| $this->CheckPermission($event)) {
	// don't autoload item, when user doesn't have view permission
	$this->LoadItem($event);

	$status_checked = true;
	$editing_mode = defined('EDITING_MODE') ? EDITING_MODE : false;

	if ($user_id != USER_ROOT && !$this->Application->isAdmin && !($editing_mode \|\| $this->checkItemStatus($event))) {
	// non-root user AND on front-end AND (not editing mode \|\| incorrect status)
	$perm_status = false;
	}
	}
	else {
	$perm_status = false;
	}

	if (!$perm_status) {
	// when no permission to view item -> redirect to no pemrission template
	if ( $this->Application->isDebugMode() ) {
	$this->Application->Debugger->appendTrace();
	}

	trigger_error('ItemLoad Permission Failed for prefix ['.$event->getPrefixSpecial().'] in <strong>'.($status_checked ? 'checkItemStatus' : 'CheckPermission').'</strong>', E_USER_NOTICE);
	$template = $this->Application->isAdmin ? 'no_permission' : $this->Application->ConfigValue('NoPermissionTemplate');

	if (MOD_REWRITE) {
	$redirect_params = Array (
	'm_cat_id' => 0,
	'next_template' => urlencode('external:' . $_SERVER['REQUEST_URI']),
	);
	}
	else {
	$redirect_params = Array (
	'next_template' => $this->Application->GetVar('t'),
	);
	}

	$this->Application->Redirect($template, $redirect_params);
	}
	}

	$actions =& $this->Application->recallObject('kActions');
	/* @var $actions Params */

	$actions->Set($event->getPrefixSpecial().'_GoTab', '');
	$actions->Set($event->getPrefixSpecial().'_GoId', '');
	$actions->Set('forms[' . $event->getPrefixSpecial() . ']', $object->getFormName());
	}

	/**
	* Build subtables array from configs
	*
	* @param kEvent $event
	*/
	function OnTempHandlerBuild(&$event)
	{
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	/* @var $object kTempTablesHandler */

	$object->BuildTables( $event->Prefix, $this->getSelectedIDs($event) );
	}

	/**
	* Checks, that object used in event should use temp tables
	*
	* @param kEvent $event
	* @return bool
	*/
	function UseTempTables(&$event)
	{
	$top_prefix = $this->Application->GetTopmostPrefix($event->Prefix); // passed parent, not always actual
	$special = ($top_prefix == $event->Prefix) ? $event->Special : $this->getMainSpecial($event);

	return $this->Application->IsTempMode($event->Prefix, $special);
	}

	/**
	* Returns table prefix from event (temp or live)
	*
	* @param kEvent $event
	* @return string
	* @todo Needed? Should be refactored (by Alex)
	*/
	function TablePrefix(&$event)
	{
	return $this->UseTempTables($event) ? $this->Application->GetTempTablePrefix('prefix:'.$event->Prefix).TABLE_PREFIX : TABLE_PREFIX;
	}

	/**
	* Load item if id is available
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function LoadItem(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$id = $this->getPassedID($event);

	if ( $object->isLoaded() && !is_array($id) && ($object->GetID() == $id) ) {
	// object is already loaded by same id
	return ;
	}

	if ( $object->Load($id) ) {
	$actions =& $this->Application->recallObject('kActions');
	/* @var $actions Params */

	$actions->Set($event->getPrefixSpecial() . '_id', $object->GetID());
	}
	else {
	$object->setID($id);
	}
	}

	/**
	* Builds list
	*
	* Pattern: Prototype Manager
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnListBuild(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBList */

	$this->dbBuild($object, $event);

	if ( !$object->isMainList() && $event->getEventParam('main_list') ) {
	// once list is set to main, then even "requery" parameter can't remove that
	/*$passed = $this->Application->GetVar('passed');
	$this->Application->SetVar('passed', $passed . ',' . $event->Prefix);*/

	$object->becameMain();
	}

	$object->setGridName($event->getEventParam('grid'));

	$sql = $this->ListPrepareQuery($event);
	$sql = $this->Application->ReplaceLanguageTags($sql);
	$object->setSelectSQL($sql);

	$object->reset();

	$object->linkToParent( $this->getMainSpecial($event) );

	$this->AddFilters($event);
	$this->SetCustomQuery($event); // new!, use this for dynamic queries based on specials for ex.
	$this->SetPagination($event);
	$this->SetSorting($event);

	$actions =& $this->Application->recallObject('kActions');
	/* @var $actions Params */

	$actions->Set('remove_specials[' . $event->getPrefixSpecial() . ']', '0');
	$actions->Set($event->getPrefixSpecial() . '_GoTab', '');
	}

	/**
	* Get's special of main item for linking with subitem
	*
	* @param kEvent $event
	* @return string
	*/
	function getMainSpecial(&$event)
	{
	$main_special = $event->getEventParam('main_special');

	if ($main_special === false) {
	// main item's special not passed

	if (substr($event->Special, -5) == '-item') {
	// temp handler added "-item" to given special -> process that here
	return substr($event->Special, 0, -5);
	}

	// by default subitem's special is used for main item searching
	return $event->Special;
	}

	return $main_special;
	}

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

	}

	/**
	* Set's new perpage for grid
	*
	* @param kEvent $event
	*/
	function OnSetPerPage(&$event)
	{
	$per_page = $this->Application->GetVar($event->getPrefixSpecial(true) . '_PerPage');
	$event->SetRedirectParam($event->getPrefixSpecial() . '_PerPage', $per_page);
	$event->SetRedirectParam('pass', 'all,' . $event->getPrefixSpecial());

	if (!$this->Application->isAdminUser) {
	$list_helper =& $this->Application->recallObject('ListHelper');
	/* @var $list_helper ListHelper */

	$this->_passListParams($event, 'per_page');

	/*if ($per_page != $list_helper->getDefaultPerPage($event->Prefix)) {
	$event->SetRedirectParam('per_page', $per_page);
	}*/
	}
	}

	/**
	* Occurs when page is changed (only for hooking)
	*
	* @param kEvent $event
	*/
	function OnSetPage(&$event)
	{
	$page = $this->Application->GetVar($event->getPrefixSpecial(true) . '_Page');
	$event->SetRedirectParam($event->getPrefixSpecial() . '_Page', $page);
	$event->SetRedirectParam('pass', 'all,' . $event->getPrefixSpecial());

	if (!$this->Application->isAdminUser) {
	/*if ($page > 1) {
	$event->SetRedirectParam('page', $page);
	}*/

	$this->_passListParams($event, 'page');
	}
	}

	/**
	* Passes through main list pagination and sorting
	*
	* @param kEvent $event
	* @param string $skip_var
	*/
	function _passListParams(&$event, $skip_var)
	{
	$param_names = array_diff(Array ('page', 'per_page', 'sort_by'), Array ($skip_var));

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

	foreach ($param_names as $param_name) {
	$value = $this->Application->GetVar($param_name);

	switch ($param_name) {
	case 'page':
	if ($value > 1) {
	$event->SetRedirectParam('page', $value);
	}
	break;

	case 'per_page':
	if ($value > 0) {
	if ($value != $list_helper->getDefaultPerPage($event->Prefix)) {
	$event->SetRedirectParam('per_page', $value);
	}
	}
	break;

	case 'sort_by':
	$event->setPseudoClass('_List');
	$object =& $event->getObject( Array ('main_list' => 1) );
	/* @var $object kDBList */

	if ($list_helper->hasUserSorting($object)) {
	$event->SetRedirectParam('sort_by', $value);
	}
	break;
	}
	}
	}

	/**
	* Set's correct page for list
	* based on data provided with event
	*
	* @param kEvent $event
	* @access private
	* @see OnListBuild
	*/
	function SetPagination(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBList */

	// get PerPage (forced -> session -> config -> 10)
	$object->SetPerPage( $this->getPerPage($event) );

	// main lists on Front-End have special get parameter for page
	$page = $object->isMainList() ? $this->Application->GetVar('page') : false;

	if (!$page) {
	// page is given in "env" variable for given prefix
	$page = $this->Application->GetVar($event->getPrefixSpecial() . '_Page');
	}

	if (!$page && $event->Special) {
	// when not part of env, then variables like "prefix.special_Page" are
	// replaced (by PHP) with "prefix_special_Page", so check for that too
	$page = $this->Application->GetVar($event->getPrefixSpecial(true) . '_Page');
	}

	if (!$object->isMainList()) {
	// main lists doesn't use session for page storing
	$this->Application->StoreVarDefault($event->getPrefixSpecial() . '_Page', 1, true); // true for optional

	if ($page) {
	// page found in request -> store in session
	$this->Application->StoreVar($event->getPrefixSpecial() . '_Page', $page, true); //true for optional
	}
	else {
	// page not found in request -> get from session
	$page = $this->Application->RecallVar($event->getPrefixSpecial() . '_Page');
	}

	if ( !$event->getEventParam('skip_counting') ) {
	// when stored page is larger, then maximal list page number
	// (such case is also processed in kDBList::Query method)
	$pages = $object->GetTotalPages();

	if ($page > $pages) {
	$page = 1;
	$this->Application->StoreVar($event->getPrefixSpecial() . '_Page', 1, true);
	}
	}
	}

	$object->SetPage($page);
	}

	/**
	* Returns current per-page setting for list
	*
	* @param kEvent $event
	* @return int
	*/
	function getPerPage(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBList */

	$per_page = $event->getEventParam('per_page');

	if ($per_page) {
	// per-page is passed as tag parameter to PrintList, InitList, etc.
	$config_mapping = $this->Application->getUnitOption($event->Prefix, 'ConfigMapping');

	// 2. per-page setting is stored in configuration variable
	if ($config_mapping) {
	// such pseudo per-pages are only defined in templates directly
	switch ($per_page) {
	case 'short_list':
	$per_page = $this->Application->ConfigValue($config_mapping['ShortListPerPage']);
	break;

	case 'default':
	$per_page = $this->Application->ConfigValue($config_mapping['PerPage']);
	break;
	}
	}

	return $per_page;
	}

	if (!$per_page && $object->isMainList()) {
	// main lists on Front-End have special get parameter for per-page
	$per_page = $this->Application->GetVar('per_page');
	}

	if (!$per_page) {
	// per-page is given in "env" variable for given prefix
	$per_page = $this->Application->GetVar($event->getPrefixSpecial() . '_PerPage');
	}

	if (!$per_page && $event->Special) {
	// when not part of env, then variables like "prefix.special_PerPage" are
	// replaced (by PHP) with "prefix_special_PerPage", so check for that too
	$per_page = $this->Application->GetVar($event->getPrefixSpecial(true) . '_PerPage');
	}

	if (!$object->isMainList()) {
	// per-page given in env and not in main list
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial() . '_current_view');

	if ($per_page) {
	// per-page found in request -> store in session and persistent session
	$this->setListSetting($event, 'PerPage', $per_page);
	}
	else {
	// per-page not found in request -> get from pesistent session (or session)
	$per_page = $this->getListSetting($event, 'PerPage');
	}
	}

	if (!$per_page) {
	// per page wan't found in request/session/persistent session
	$list_helper =& $this->Application->recallObject('ListHelper');
	/* @var $list_helper ListHelper */

	// allow to override default per-page value from tag
	$default_per_page = $event->getEventParam('default_per_page');

	if (!is_numeric($default_per_page)) {
	$default_per_page = 10;
	}

	$per_page = $list_helper->getDefaultPerPage($event->Prefix, $default_per_page);
	}

	return $per_page;
	}

	/**
	* Set's correct sorting for list
	* based on data provided with event
	*
	* @param kEvent $event
	* @access private
	* @see OnListBuild
	*/
	function SetSorting(&$event)
	{
	$event->setPseudoClass('_List');

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

	if ($object->isMainList()) {
	$sort_by = $this->Application->GetVar('sort_by');
	$cur_sort1 = $cur_sort1_dir = $cur_sort2 = $cur_sort2_dir = false;

	if ($sort_by) {
	list ($cur_sort1, $cur_sort1_dir) = explode(',', $sort_by);
	}
	}
	else {
	$cur_sort1 = $this->getListSetting($event, 'Sort1');
	$cur_sort1_dir = $this->getListSetting($event, 'Sort1_Dir');
	$cur_sort2 = $this->getListSetting($event, 'Sort2');
	$cur_sort2_dir = $this->getListSetting($event, 'Sort2_Dir');
	}

	$tag_sort_by = $event->getEventParam('sort_by');

	if ($tag_sort_by) {
	if ($tag_sort_by == 'random') {
	$object->AddOrderField('RAND()', '');
	}
	else {
	// multiple sortings could be specified at once
	$tag_sort_by = explode('\|', $tag_sort_by);

	foreach ($tag_sort_by as $sorting_element) {
	list ($by, $dir) = explode(',', $sorting_element);
	$object->AddOrderField($by, $dir);
	}
	}
	}

	$list_sortings = $this->Application->getUnitOption($event->Prefix, 'ListSortings', Array ());
	$sorting_prefix = array_key_exists($event->Special, $list_sortings) ? $event->Special : '';
	$sorting_configs = $this->Application->getUnitOption($event->Prefix, 'ConfigMapping');

	if ($sorting_configs && array_key_exists('DefaultSorting1Field', $sorting_configs)) {
	// sorting defined in configuration variables overrides one from unit config
	$list_sortings[$sorting_prefix]['Sorting'] = Array (
	$this->Application->ConfigValue($sorting_configs['DefaultSorting1Field']) => $this->Application->ConfigValue($sorting_configs['DefaultSorting1Dir']),
	$this->Application->ConfigValue($sorting_configs['DefaultSorting2Field']) => $this->Application->ConfigValue($sorting_configs['DefaultSorting2Dir']),
	);
	}

	// use default if not specified in session
	if (!$cur_sort1 \|\| !$cur_sort1_dir) {
	$sorting = getArrayValue($list_sortings, $sorting_prefix, 'Sorting');

	if ($sorting) {
	reset($sorting);
	$cur_sort1 = key($sorting);
	$cur_sort1_dir = current($sorting);

	if (next($sorting)) {
	$cur_sort2 = key($sorting);
	$cur_sort2_dir = current($sorting);
	}
	}
	}

	// always add forced sorting before any user sorting fields
	$forced_sorting = getArrayValue($list_sortings, $sorting_prefix, 'ForcedSorting');
	/* @var $forced_sorting Array */

	if ($forced_sorting) {
	foreach ($forced_sorting as $field => $dir) {
	$object->AddOrderField($field, $dir);
	}
	}

	// add user sorting fields
	if ($cur_sort1 != '' && $cur_sort1_dir != '') {
	$object->AddOrderField($cur_sort1, $cur_sort1_dir);
	}

	if ($cur_sort2 != '' && $cur_sort2_dir != '') {
	$object->AddOrderField($cur_sort2, $cur_sort2_dir);
	}
	}

	/**
	* Gets list setting by name (persistent or real session)
	*
	* @param kEvent $event
	* @param string $variable_name
	* @return string
	*/
	function getListSetting(&$event, $variable_name)
	{
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial() . '_current_view');
	$storage_prefix = $event->getEventParam('same_special') ? $event->Prefix : $event->getPrefixSpecial();

	// get sorting from pesistent session
	$variable_value = $this->Application->RecallPersistentVar($storage_prefix . '_' . $variable_name . '.' . $view_name, ALLOW_DEFAULT_SETTINGS);

	/*if (!$variable_value) {
	// get sorting from session
	$variable_value = $this->Application->RecallVar($storage_prefix . '_' . $variable_name);
	}*/

	return $variable_value;
	}

	/**
	* Sets list setting by name (persistent and real session)
	*
	* @param kEvent $event
	* @param string $variable_name
	* @param string $variable_value
	*/
	function setListSetting(&$event, $variable_name, $variable_value = null)
	{
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial() . '_current_view');
	// $this->Application->StoreVar($event->getPrefixSpecial() . '_' . $variable_name, $variable_value, true); //true for optional

	if ( isset($variable_value) ) {
	$this->Application->StorePersistentVar($event->getPrefixSpecial() . '_' . $variable_name . '.' . $view_name, $variable_value, true); //true for optional
	}
	else {
	$this->Application->RemovePersistentVar($event->getPrefixSpecial() . '_' . $variable_name . '.' . $view_name);
	}
	}

	/**
	* Add filters found in session
	*
	* @param kEvent $event
	*/
	function AddFilters(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBList */

	$edit_mark = rtrim($this->Application->GetSID() . '_' . $this->Application->GetTopmostWid($event->Prefix), '_');

	// add search filter
	$filter_data = $this->Application->RecallVar($event->getPrefixSpecial() . '_search_filter');

	if ( $filter_data ) {
	$filter_data = unserialize($filter_data);

	foreach ($filter_data as $filter_field => $filter_params) {
	$filter_type = ($filter_params['type'] == 'having') ? kDBList::HAVING_FILTER : kDBList::WHERE_FILTER;
	$filter_value = str_replace(EDIT_MARK, $edit_mark, $filter_params['value']);
	$object->addFilter($filter_field, $filter_value, $filter_type, kDBList::FLT_SEARCH);
	}
	}

	// add custom filter
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial() . '_current_view');
	$custom_filters = $this->Application->RecallPersistentVar($event->getPrefixSpecial() . '_custom_filter.' . $view_name);

	if ( $custom_filters ) {
	$grid_name = $event->getEventParam('grid');
	$custom_filters = unserialize($custom_filters);

	if ( isset($custom_filters[$grid_name]) ) {
	foreach ($custom_filters[$grid_name] as $field_name => $field_options) {
	list ($filter_type, $field_options) = each($field_options);

	if ( isset($field_options['value']) && $field_options['value'] ) {
	$filter_type = ($field_options['sql_filter_type'] == 'having') ? kDBList::HAVING_FILTER : kDBList::WHERE_FILTER;
	$filter_value = str_replace(EDIT_MARK, $edit_mark, $field_options['value']);
	$object->addFilter($field_name, $filter_value, $filter_type, kDBList::FLT_CUSTOM);
	}
	}
	}
	}

	$view_filter = $this->Application->RecallVar($event->getPrefixSpecial() . '_view_filter');

	if ( $view_filter ) {
	$view_filter = unserialize($view_filter);

	$temp_filter =& $this->Application->makeClass('kMultipleFilter');
	/* @var $temp_filter kMultipleFilter */

	$filter_menu = $this->Application->getUnitOption($event->Prefix, 'FilterMenu');

	$group_key = 0;
	$group_count = count($filter_menu['Groups']);

	while ( $group_key < $group_count ) {
	$group_info = $filter_menu['Groups'][$group_key];

	$temp_filter->setType(constant('kDBList::FLT_TYPE_' . $group_info['mode']));
	$temp_filter->clearFilters();

	foreach ($group_info['filters'] as $flt_id) {
	$sql_key = getArrayValue($view_filter, $flt_id) ? 'on_sql' : 'off_sql';

	if ( $filter_menu['Filters'][$flt_id][$sql_key] != '' ) {
	$temp_filter->addFilter('view_filter_' . $flt_id, $filter_menu['Filters'][$flt_id][$sql_key]);
	}
	}

	$object->addFilter('view_group_' . $group_key, $temp_filter, $group_info['type'], kDBList::FLT_VIEW);
	$group_key++;
	}
	}
	}

	/**
	* Set's new sorting for list
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnSetSorting(&$event)
	{
	$cur_sort1 = $this->getListSetting($event, 'Sort1');
	$cur_sort1_dir = $this->getListSetting($event, 'Sort1_Dir');

	$use_double_sorting = $this->Application->ConfigValue('UseDoubleSorting');

	if ($use_double_sorting) {
	$cur_sort2 = $this->getListSetting($event, 'Sort2');
	$cur_sort2_dir = $this->getListSetting($event, 'Sort2_Dir');
	}

	$passed_sort1 = $this->Application->GetVar($event->getPrefixSpecial(true) . '_Sort1');
	if ($cur_sort1 == $passed_sort1) {
	$cur_sort1_dir = $cur_sort1_dir == 'asc' ? 'desc' : 'asc';
	}
	else {
	if ($use_double_sorting) {
	$cur_sort2 = $cur_sort1;
	$cur_sort2_dir = $cur_sort1_dir;
	}
	$cur_sort1 = $passed_sort1;
	$cur_sort1_dir = 'asc';
	}

	$this->setListSetting($event, 'Sort1', $cur_sort1);
	$this->setListSetting($event, 'Sort1_Dir', $cur_sort1_dir);

	if ($use_double_sorting) {
	$this->setListSetting($event, 'Sort2', $cur_sort2);
	$this->setListSetting($event, 'Sort2_Dir', $cur_sort2_dir);
	}
	}

	/**
	* Set sorting directly to session (used for category item sorting (front-end), grid sorting (admin, view menu)
	*
	* @param kEvent $event
	*/
	function OnSetSortingDirect(&$event)
	{
	// used on Front-End in category item lists
	$prefix_special = $event->getPrefixSpecial();
	$combined = $this->Application->GetVar($event->getPrefixSpecial(true) . '_CombinedSorting');

	if ($combined) {
	list ($field, $dir) = explode('\|', $combined);

	if ($this->Application->isAdmin \|\| !$this->Application->GetVar('main_list')) {
	$this->setListSetting($event, 'Sort1', $field);
	$this->setListSetting($event, 'Sort1_Dir', $dir);
	}
	else {
	$event->setPseudoClass('_List');
	$this->Application->SetVar('sort_by', $field . ',' . $dir);

	$object =& $event->getObject( Array ('main_list' => 1) );
	/* @var $object kDBList */

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

	$this->_passListParams($event, 'sort_by');

	if ($list_helper->hasUserSorting($object)) {
	$event->SetRedirectParam('sort_by', $field . ',' . strtolower($dir));
	}

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

	return ;
	}

	// used in "View Menu -> Sort" menu in administrative console
	$field_pos = $this->Application->GetVar($event->getPrefixSpecial(true) . '_SortPos');
	$this->Application->LinkVar($event->getPrefixSpecial(true) . '_Sort' . $field_pos, $prefix_special . '_Sort' . $field_pos);
	$this->Application->LinkVar($event->getPrefixSpecial(true) . '_Sort' . $field_pos . '_Dir', $prefix_special . '_Sort' . $field_pos . '_Dir');
	}

	/**
	* Reset grid sorting to default (from config)
	*
	* @param kEvent $event
	*/
	function OnResetSorting(&$event)
	{
	$this->setListSetting($event, 'Sort1');
	$this->setListSetting($event, 'Sort1_Dir');
	$this->setListSetting($event, 'Sort2');
	$this->setListSetting($event, 'Sort2_Dir');
	}

	/**
	* Sets grid refresh interval
	*
	* @param kEvent $event
	*/
	function OnSetAutoRefreshInterval(&$event)
	{
	$refresh_interval = $this->Application->GetVar('refresh_interval');

	$view_name = $this->Application->RecallVar($event->getPrefixSpecial().'_current_view');
	$this->Application->StorePersistentVar($event->getPrefixSpecial().'_refresh_interval.'.$view_name, $refresh_interval);
	}

	/**
	* Changes auto-refresh state for grid
	*
	* @param kEvent $event
	*/
	function OnAutoRefreshToggle(&$event)
	{
	$refresh_intervals = $this->Application->ConfigValue('AutoRefreshIntervals');
	if (!$refresh_intervals) {
	return ;
	}

	$view_name = $this->Application->RecallVar($event->getPrefixSpecial().'_current_view');
	$auto_refresh = $this->Application->RecallPersistentVar($event->getPrefixSpecial().'_auto_refresh.'.$view_name);

	if ($auto_refresh === false) {
	$refresh_intervals = explode(',', $refresh_intervals);
	$this->Application->StorePersistentVar($event->getPrefixSpecial().'_refresh_interval.'.$view_name, $refresh_intervals[0]);
	}

	$this->Application->StorePersistentVar($event->getPrefixSpecial().'_auto_refresh.'.$view_name, $auto_refresh ? 0 : 1);
	}

	/**
	* Creates needed sql query to load item,
	* if no query is defined in config for
	* special requested, then use default
	* query
	*
	* @param kEvent $event
	* @access protected
	*/
	function ItemPrepareQuery(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$sqls = $object->getFormOption('ItemSQLs', Array ());
	$special = isset($sqls[$event->Special]) ? $event->Special : '';

	// preferred special not found in ItemSQLs -> use analog from ListSQLs

	return isset($sqls[$special]) ? $sqls[$special] : $this->ListPrepareQuery($event);
	}

	/**
	* Creates needed sql query to load list,
	* if no query is defined in config for
	* special requested, then use default
	* query
	*
	* @param kEvent $event
	* @access protected
	*/
	function ListPrepareQuery(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$sqls = $object->getFormOption('ListSQLs', Array ());

	return $sqls[ array_key_exists($event->Special, $sqls) ? $event->Special : '' ];
	}

	/**
	* Apply custom processing to item
	*
	* @param kEvent $event
	* @param string $type
	* @return void
	* @access protected
	*/
	protected function customProcessing(&$event, $type)
	{

	}

	/* Edit Events mostly used in Admin */

	/**
	* Creates new kDBItem
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnCreate(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	/* @var $object kDBItem */

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info) {
	list($id,$field_values) = each($items_info);
	$object->SetFieldsFromHash($field_values);
	}

	$this->customProcessing($event,'before');

	//look at kDBItem' Create for ForceCreateId description, it's rarely used and is NOT set by default
	if ( $object->Create($event->getEventParam('ForceCreateId')) ) {
	$this->customProcessing($event,'after');
	$event->status=kEvent::erSUCCESS;
	$event->setRedirectParams(Array('opener'=>'u'), true);
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	$this->Application->SetVar($event->getPrefixSpecial().'_SaveEvent','OnCreate');
	$object->setID($id);
	}
	}

	/**
	* Updates kDBItem
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnUpdate(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return;
	}

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

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );

	if ( $items_info ) {
	foreach ($items_info as $id => $field_values) {
	$object->Load($id);
	$object->SetFieldsFromHash($field_values);
	$this->customProcessing($event, 'before');

	if ( $object->Update($id) ) {
	$this->customProcessing($event, 'after');
	$event->status = kEvent::erSUCCESS;
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}

	$event->SetRedirectParam('opener', 'u');
	}

	/**
	* Delete's kDBItem object
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnDelete(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = kEvent::erFAIL;
	return;
	}

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

	$temp->DeleteItems($event->Prefix, $event->Special, Array($this->getPassedID($event)));
	}

	/**
	* Deletes all records from table
	*
	* @param kEvent $event
	*/
	function OnDeleteAll(&$event)
	{
	$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);
	}
	}

	/**
	* Prepares new kDBItem object
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnNew(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	/* @var $object kDBItem */

	$object->Clear(0);
	$this->Application->SetVar($event->getPrefixSpecial().'_SaveEvent', 'OnCreate');

	if ($event->getEventParam('top_prefix') != $event->Prefix) {
	// this is subitem prefix, so use main item special
	$table_info = $object->getLinkedInfo( $this->getMainSpecial($event) );
	}
	else {
	$table_info = $object->getLinkedInfo();
	}

	$object->SetDBField($table_info['ForeignKey'], $table_info['ParentId']);

	$event->redirect = false;
	}

	/**
	* Cancels kDBItem Editing/Creation
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnCancel(&$event)
	{
	$object =& $event->getObject(Array ('skip_autoload' => true));
	/* @var $object kDBItem */

	$items_info = $this->Application->GetVar($event->getPrefixSpecial(true));

	if ( $items_info ) {
	$delete_ids = Array ();

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

	foreach ($items_info as $id => $field_values) {
	$object->Load($id);
	// record created for using with selector (e.g. Reviews->Select User), and not validated => Delete it
	if ( $object->isLoaded() && !$object->Validate() && ($id <= 0) ) {
	$delete_ids[] = $id;
	}
	}

	if ( $delete_ids ) {
	$temp_handler->DeleteItems($event->Prefix, $event->Special, $delete_ids);
	}
	}

	$event->SetRedirectParam('opener', 'u');
	}

	/**
	* Deletes all selected items.
	* Automatically recurse into sub-items using temp handler, and deletes sub-items
	* by calling its Delete method if sub-item has AutoDelete set to true in its config file
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnMassDelete(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return ;
	}

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

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

	$event->setEventParam('ids', $ids);
	$this->customProcessing($event, 'before');
	$ids = $event->getEventParam('ids');

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

	$this->clearSelectedIDs($event);
	}

	/**
	* Sets window id (of first opened edit window) to temp mark in uls
	*
	* @param kEvent $event
	*/
	function setTempWindowID(&$event)
	{
	$prefixes = Array ($event->Prefix, $event->getPrefixSpecial(true));

	foreach ($prefixes as $prefix) {
	$mode = $this->Application->GetVar($prefix . '_mode');

	if ($mode == 't') {
	$wid = $this->Application->GetVar('m_wid');
	$this->Application->SetVar(str_replace('_', '.', $prefix) . '_mode', 't' . $wid);
	break;
	}
	}
	}

	/**
	* Prepare temp tables and populate it
	* with items selected in the grid
	*
	* @param kEvent $event
	*/
	function OnEdit(&$event)
	{
	$this->setTempWindowID($event);
	$ids = $this->StoreSelectedIDs($event);

	$this->Application->RemoveVar( $this->_getPendingActionVariableName($event) );

	$changes_var_name = $this->Prefix . '_changes_' . $this->Application->GetTopmostWid($this->Prefix);
	$this->Application->RemoveVar($changes_var_name);

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

	$temp->PrepareEdit();

	$event->SetRedirectParam('m_lang', $this->Application->GetDefaultLanguageId());
	$event->SetRedirectParam($event->getPrefixSpecial() . '_id', array_shift($ids));
	$event->SetRedirectParam('pass', 'all,' . $event->getPrefixSpecial());
	}

	/**
	* Saves content of temp table into live and
	* redirects to event' default redirect (normally grid template)
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnSave(&$event)
	{
	$event->CallSubEvent('OnPreSave');

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

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

	$changes_var_name = $this->Prefix . '_changes_' . $this->Application->GetTopmostWid($this->Prefix);

	if ( !$this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$live_ids = $temp_handler->SaveEdit($event->getEventParam('master_ids') ? $event->getEventParam('master_ids') : Array ());

	if ( $live_ids === false ) {
	// coping from table failed, because we have another coping process to same table, that wasn't finished
	$event->status = kEvent::erFAIL;
	return ;
	}

	if ( $live_ids ) {
	// ensure, that newly created item ids are available as if they were selected from grid
	// NOTE: only works if main item has sub-items !!!
	$this->StoreSelectedIDs($event, $live_ids);
	}

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

	$this->SaveLoggedChanges($changes_var_name, $object->ShouldLogChanges());
	}
	else {
	$event->status = kEvent::erFAIL;
	}

	$this->clearSelectedIDs($event);

	$event->setRedirectParams(Array ('opener' => 'u'), true);
	$this->Application->RemoveVar($event->getPrefixSpecial() . '_modified');

	// all temp tables are deleted here => all after hooks should think, that it's live mode now
	$this->Application->SetVar($event->Prefix . '_mode', '');
	}

	function SaveLoggedChanges($changes_var_name, $save = true)
	{
	// 1. get changes, that were made
	$changes = $this->Application->RecallVar($changes_var_name);
	$changes = $changes ? unserialize($changes) : Array ();
	$this->Application->RemoveVar($changes_var_name);

	if (!$changes) {
	// no changes, skip processing
	return ;
	}

	// TODO: 2. optimize change log records (replace multiple changes to same record with one change record)

	$to_increment = Array ();

	// 3. collect serials to reset based on foreign keys
	foreach ($changes as $index => $rec) {
	if (array_key_exists('DependentFields', $rec)) {

	foreach ($rec['DependentFields'] as $field_name => $field_value) {
	// will be "ci\|ItemResourceId:345"
	$to_increment[] = $rec['Prefix'] . '\|' . $field_name . ':' . $field_value;

	// also reset sub-item prefix general serial
	$to_increment[] = $rec['Prefix'];
	}

	unset($changes[$index]['DependentFields']);
	}

	unset($changes[$index]['ParentId'], $changes[$index]['ParentPrefix']);
	}

	// 4. collect serials to reset based on changed ids
	foreach ($changes as $change) {
	$to_increment[] = $change['MasterPrefix'] . '\|' . $change['MasterId'];

	if ($change['MasterPrefix'] != $change['Prefix']) {
	// also reset sub-item prefix general serial
	$to_increment[] = $change['Prefix'];

	// will be "ci\|ItemResourceId"
	$to_increment[] = $change['Prefix'] . '\|' . $change['ItemId'];
	}
	}

	// 5. reset serials collected before
	$to_increment = array_unique($to_increment);
	$this->Application->incrementCacheSerial($this->Prefix);

	foreach ($to_increment as $to_increment_mixed) {
	if (strpos($to_increment_mixed, '\|') !== false) {
	list ($to_increment_prefix, $to_increment_id) = explode('\|', $to_increment_mixed, 2);
	$this->Application->incrementCacheSerial($to_increment_prefix, $to_increment_id);
	}
	else {
	$this->Application->incrementCacheSerial($to_increment_mixed);
	}
	}

	// save changes to database
	$sesion_log_id = $this->Application->RecallVar('_SessionLogId_');

	if (!$save \|\| !$sesion_log_id) {
	// saving changes to database disabled OR related session log missing
	return ;
	}

	$add_fields = Array (
	'PortalUserId' => $this->Application->RecallVar('user_id'),
	'SessionLogId' => $sesion_log_id,
	);

	$change_log_table = $this->Application->getUnitOption('change-log', 'TableName');

	foreach ($changes as $rec) {
	$this->Conn->doInsert(array_merge($rec, $add_fields), $change_log_table);
	}

	$this->Application->incrementCacheSerial('change-log');

	$sql = 'UPDATE ' . $this->Application->getUnitOption('session-log', 'TableName') . '
	SET AffectedItems = AffectedItems + ' . count($changes) . '
	WHERE SessionLogId = ' . $sesion_log_id;
	$this->Conn->Query($sql);

	$this->Application->incrementCacheSerial('session-log');
	}

	/**
	* Cancels edit
	* Removes all temp tables and clears selected ids
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnCancelEdit(&$event)
	{
	$temp_handler =& $this->Application->recallObject($event->getPrefixSpecial() . '_TempHandler', 'kTempTablesHandler');
	/* @var $temp_handler kTempTablesHandler */

	$temp_handler->CancelEdit();

	$this->clearSelectedIDs($event);
	$event->setRedirectParams(Array ('opener' => 'u'), true);
	$this->Application->RemoveVar($event->getPrefixSpecial() . '_modified');

	$changes_var_name = $this->Prefix . '_changes_' . $this->Application->GetTopmostWid($this->Prefix);
	$this->Application->RemoveVar($changes_var_name);
	}

	/**
	* Allows to determine if we are creating new item or editing already created item
	*
	* @param kEvent $event
	* @return bool
	*/
	function isNewItemCreate(&$event)
	{
	$object =& $event->getObject( Array ('raise_warnings' => 0) );
	/* @var $object kDBItem */

	return !$object->isLoaded();
	}

	/**
	* Saves edited item into temp table
	* If there is no id, new item is created in temp table
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreSave(&$event)
	{
	// if there is no id - it means we need to create an item
	if ( is_object($event->MasterEvent) ) {
	$event->MasterEvent->setEventParam('IsNew', false);
	}

	if ( $this->isNewItemCreate($event) ) {
	$event->CallSubEvent('OnPreSaveCreated');

	if ( is_object($event->MasterEvent) ) {
	$event->MasterEvent->setEventParam('IsNew', true);
	}

	return ;
	}

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

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ( $items_info ) {
	foreach ($items_info as $id => $field_values) {
	$object->Load($id);
	$object->SetFieldsFromHash($field_values);
	$this->customProcessing($event, 'before');

	if ( $object->Update($id) ) {
	$this->customProcessing($event, 'after');
	$event->status = kEvent::erSUCCESS;
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}
	}

	/**
	* [HOOK] Saves sub-item
	*
	* @param kEvent $event
	*/
	function OnPreSaveSubItem(&$event)
	{
	$not_created = $this->isNewItemCreate($event);

	$event->CallSubEvent($not_created ? 'OnCreate' : 'OnUpdate');
	if ($event->status == kEvent::erSUCCESS) {
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$this->Application->SetVar($event->getPrefixSpecial() . '_id', $object->GetID());
	}
	else {
	$event->MasterEvent->status = $event->status;
	}

	$event->SetRedirectParam('opener', 's');
	}

	/**
	* Saves edited item in temp table and loads
	* item with passed id in current template
	* Used in Prev/Next buttons
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndGo(&$event)
	{
	$event->CallSubEvent('OnPreSave');

	if ($event->status == kEvent::erSUCCESS) {
	$id = $this->Application->GetVar($event->getPrefixSpecial(true) . '_GoId');
	$event->SetRedirectParam($event->getPrefixSpecial() . '_id', $id);
	}
	}

	/**
	* Saves edited item in temp table and goes
	* to passed tabs, by redirecting to it with OnPreSave event
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndGoToTab(&$event)
	{
	$event->CallSubEvent('OnPreSave');
	if ($event->status==kEvent::erSUCCESS) {
	$event->redirect=$this->Application->GetVar($event->getPrefixSpecial(true).'_GoTab');
	}
	}

	/**
	* Saves editable list and goes to passed tab,
	* by redirecting to it with empty event
	*
	* @param kEvent $event
	*/
	function OnUpdateAndGoToTab(&$event)
	{
	$event->setPseudoClass('_List');
	$event->CallSubEvent('OnUpdate');
	if ($event->status==kEvent::erSUCCESS) {
	$event->redirect=$this->Application->GetVar($event->getPrefixSpecial(true).'_GoTab');
	}
	}

	/**
	* Prepare temp tables for creating new item
	* but does not create it. Actual create is
	* done in OnPreSaveCreated
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreCreate(&$event)
	{
	$this->setTempWindowID($event);
	$this->clearSelectedIDs($event);
	$this->Application->SetVar('m_lang', $this->Application->GetDefaultLanguageId());

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

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

	$temp_handler->PrepareEdit();

	$object->setID(0);
	$this->Application->SetVar($event->getPrefixSpecial() . '_id', 0);
	$this->Application->SetVar($event->getPrefixSpecial() . '_PreCreate', 1);

	$changes_var_name = $this->Prefix . '_changes_' . $this->Application->GetTopmostWid($this->Prefix);
	$this->Application->RemoveVar($changes_var_name);

	$event->redirect = false;
	}

	/**
	* Creates a new item in temp table and
	* stores item id in App vars and Session on success
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreSaveCreated(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	/* @var $object kDBItem */

	$object->SetFieldsFromHash( $this->getSubmittedFields($event) );

	$this->customProcessing($event, 'before');

	if ( $object->Create() ) {
	$this->customProcessing($event, 'after');
	$event->SetRedirectParam($event->getPrefixSpecial(true) . '_id', $object->GetID());
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	$object->setID(0);
	}
	}

	/**
	* Reloads form to loose all changes made during item editing
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnReset(&$event)
	{
	//do nothing - should reset :)
	if ( $this->isNewItemCreate($event) ) {
	// just reset id to 0 in case it was create
	$object =& $event->getObject( Array ('skip_autoload' => true) );
	/* @var $object kDBItem */

	$object->setID(0);
	$this->Application->SetVar($event->getPrefixSpecial() . '_id', 0);
	}
	}

	/**
	* Apply same processing to each item being selected in grid
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function iterateItems(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return ;
	}

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

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

	if ( $ids ) {
	$status_field = array_shift( $this->Application->getUnitOption($event->Prefix, 'StatusField') );
	$order_field = $this->Application->getUnitOption($event->Prefix, 'OrderField');

	if ( !$order_field ) {
	$order_field = 'Priority';
	}

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

	switch ( $event->Name ) {
	case 'OnMassApprove':
	$object->SetDBField($status_field, 1);
	break;

	case 'OnMassDecline':
	$object->SetDBField($status_field, 0);
	break;

	case 'OnMassMoveUp':
	$object->SetDBField($order_field, $object->GetDBField($order_field) + 1);
	break;

	case 'OnMassMoveDown':
	$object->SetDBField($order_field, $object->GetDBField($order_field) - 1);
	break;
	}

	if ( $object->Update() ) {
	$event->status = kEvent::erSUCCESS;
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}

	$this->clearSelectedIDs($event);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnMassClone(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return ;
	}

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

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

	if ( $ids ) {
	$temp_handler->CloneItems($event->Prefix, $event->Special, $ids);
	}

	$this->clearSelectedIDs($event);
	}

	function check_array($records, $field, $value)
	{
	foreach ($records as $record) {
	if ($record[$field] == $value) {
	return true;
	}
	}
	return false;
	}

	/**
	* Saves data from editing form to database without checking required fields
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreSavePopup(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');

	$event->SetRedirectParam('opener', 'u');
	}


	/* End of Edit events */

	// III. Events that allow to put some code before and after Update,Load,Create and Delete methods of item

	/**
	* Occurse before loading item, 'id' parameter
	* allows to get id of item beeing loaded
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemLoad(&$event)
	{

	}

	/**
	* Occurs after loading item, 'id' parameter
	* allows to get id of item that was loaded
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterItemLoad(&$event)
	{

	}

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

	}

	/**
	* Occurs after creating item
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterItemCreate(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	if ( !$object->IsTempTable() ) {
	$this->_proccessPendingActions($event);
	}
	}

	/**
	* Occurs before updating item
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeItemUpdate(&$event)
	{

	}

	/**
	* Occurs after updating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemUpdate(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	if ( !$object->IsTempTable() ) {
	$this->_proccessPendingActions($event);
	}
	}

	/**
	* Occurse before deleting item, id of item beeing
	* deleted is stored as 'id' event param
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemDelete(&$event)
	{

	}

	/**
	* Occurse after deleting item, id of deleted item
	* is stored as 'id' param of event
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemDelete(&$event)
	{

	}

	/**
	* Occurs before validation attempt
	*
	* @param kEvent $event
	*/
	function OnBeforeItemValidate(&$event)
	{

	}

	/**
	* Occurs after successful item validation
	*
	* @param kEvent $event
	*/
	function OnAfterItemValidate(&$event)
	{

	}

	/**
	* Occures after an item has been copied to temp
	* Id of copied item is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToTemp(&$event)
	{

	}

	/**
	* 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(&$event)
	{

	}

	/**
	* Occures before an item is copied to live table (after all foreign keys have been updated)
	* Id of item being copied is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnBeforeCopyToLive(&$event)
	{

	}

	/**
	* Occures after an item has been copied to live table
	* Id of copied item is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToLive(&$event)
	{
	$this->_proccessPendingActions($event);
	}

	/**
	* Processing file pending actions (e.g. delete scheduled files)
	*
	* @param kEvent $event
	*/
	function _proccessPendingActions(&$event)
	{
	$var_name = $this->_getPendingActionVariableName($event);
	$schedule = $this->Application->RecallVar($var_name);

	if ( $schedule ) {
	$schedule = unserialize($schedule);

	foreach ($schedule as $data) {
	if ( $data['action'] == 'delete' ) {
	unlink( $data['file'] );
	}
	}

	$this->Application->RemoveVar($var_name);
	}
	}

	/**
	* Returns variable name, used to store pending file actions
	*
	* @param kEvent $event
	* @return string
	*/
	function _getPendingActionVariableName(&$event)
	{
	$window_id = $this->Application->GetTopmostWid($event->Prefix);

	return $event->Prefix . '_file_pending_actions' . $window_id;
	}

	/**
	* Occurs before an item has been cloned
	* Id of newly created item is passed as event' 'id' param
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeClone(&$event)
	{

	}

	/**
	* Occures after an item has been cloned
	* Id of newly created item is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnAfterClone(&$event)
	{

	}

	/**
	* Occures after list is queried
	*
	* @param kEvent $event
	*/
	function OnAfterListQuery(&$event)
	{

	}

	/**
	* Ensures that popup will be closed automatically
	* and parent window will be refreshed with template
	* passed
	*
	* @param kEvent $event
	* @return void
	* @access protected
	* @deprecated
	*/
	protected function finalizePopup(&$event)
	{
	$event->SetRedirectParam('opener', 'u');
	}

	/**
	* Create search filters based on search query
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnSearch(&$event)
	{
	$event->setPseudoClass('_List');

	$search_helper =& $this->Application->recallObject('SearchHelper');
	/* @var $search_helper kSearchHelper */

	$search_helper->performSearch($event);
	}

	/**
	* Clear search keywords
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnSearchReset(&$event)
	{
	$search_helper =& $this->Application->recallObject('SearchHelper');
	/* @var $search_helper kSearchHelper */

	$search_helper->resetSearch($event);
	}

	/**
	* Set's new filter value (filter_id meaning from config)
	*
	* @param kEvent $event
	*/
	function OnSetFilter(&$event)
	{
	$filter_id = $this->Application->GetVar('filter_id');
	$filter_value = $this->Application->GetVar('filter_value');

	$view_filter = $this->Application->RecallVar($event->getPrefixSpecial().'_view_filter');
	$view_filter = $view_filter ? unserialize($view_filter) : Array();

	$view_filter[$filter_id] = $filter_value;

	$this->Application->StoreVar( $event->getPrefixSpecial().'_view_filter', serialize($view_filter) );
	}

	/**
	* Sets view filter based on request
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnSetFilterPattern(&$event)
	{
	$filters = $this->Application->GetVar($event->getPrefixSpecial(true) . '_filters');
	if ( !$filters ) {
	return;
	}

	$view_filter = $this->Application->RecallVar($event->getPrefixSpecial() . '_view_filter');
	$view_filter = $view_filter ? unserialize($view_filter) : Array ();

	$filters = explode(',', $filters);

	foreach ($filters as $a_filter) {
	list($id, $value) = explode('=', $a_filter);
	$view_filter[$id] = $value;
	}

	$this->Application->StoreVar($event->getPrefixSpecial() . '_view_filter', serialize($view_filter));
	$event->redirect = false;
	}

	/**
	* Add/Remove all filters applied to list from "View" menu
	*
	* @param kEvent $event
	*/
	function FilterAction(&$event)
	{
	$view_filter = Array();
	$filter_menu = $this->Application->getUnitOption($event->Prefix,'FilterMenu');
	switch ($event->Name)
	{
	case 'OnRemoveFilters':
	$filter_value = 1;
	break;

	case 'OnApplyFilters':
	$filter_value = 0;
	break;
	}

	foreach($filter_menu['Filters'] as $filter_key => $filter_params)
	{
	if(!$filter_params) continue;
	$view_filter[$filter_key] = $filter_value;
	}
	$this->Application->StoreVar( $event->getPrefixSpecial().'_view_filter', serialize($view_filter) );
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @access protected
	*/
	protected function OnPreSaveAndOpenTranslator(&$event)
	{
	$this->Application->SetVar('allow_translation', true);

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

	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');

	if ( $event->status == kEvent::erSUCCESS ) {
	$resource_id = $this->Application->GetVar('translator_resource_id');

	if ( $resource_id ) {
	$t_prefixes = explode(',', $this->Application->GetVar('translator_prefixes'));

	$cdata =& $this->Application->recallObject($t_prefixes[1], null, Array ('skip_autoload' => true));
	/* @var $cdata kDBItem */

	$cdata->Load($resource_id, 'ResourceId');

	if ( !$cdata->isLoaded() ) {
	$cdata->SetDBField('ResourceId', $resource_id);
	$cdata->Create();
	}

	$this->Application->SetVar($cdata->getPrefixSpecial() . '_id', $cdata->GetID());
	}

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

	$redirect_params = Array (
	'pass' => 'all,trans,' . $this->Application->GetVar('translator_prefixes'),
	'opener' => 's',
	$event->getPrefixSpecial(true) . '_id' => $object->GetID(),
	'trans_event' => 'OnLoad',
	'trans_prefix' => $this->Application->GetVar('translator_prefixes'),
	'trans_field' => $this->Application->GetVar('translator_field'),
	'trans_multi_line' => $this->Application->GetVar('translator_multi_line'),
	);

	$event->setRedirectParams($redirect_params, true);

	// 1. SAVE LAST TEMPLATE TO SESSION (really needed here, because of tweaky redirect)
	$last_template = $this->Application->RecallVar('last_template');
	preg_match('/index4\.php\\|' . $this->Application->GetSID() . '-(.*):/U', $last_template, $rets);
	$this->Application->StoreVar('return_template', $this->Application->GetVar('t'));
	}
	}

	/**
	* Makes all fields non-required
	*
	* @param kDBItem $object
	*/
	function RemoveRequiredFields(&$object)
	{
	// making all field non-required to achieve successful presave
	$fields = array_keys( $object->getFields() );

	foreach ($fields as $field) {
	if ( $object->isRequired($field) ) {
	$object->setRequired($field, false);
	}
	}
	}

	/**
	* Saves selected user in needed field
	*
	* @param kEvent $event
	*/
	function OnSelectUser(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$items_info = $this->Application->GetVar('u');

	if ( $items_info ) {
	$user_id = array_shift( array_keys($items_info) );

	$this->RemoveRequiredFields($object);

	$is_new = !$object->isLoaded();
	$is_main = substr($this->Application->GetVar($event->Prefix . '_mode'), 0, 1) == 't';

	if ( $is_new ) {
	$new_event = $is_main ? 'OnPreCreate' : 'OnNew';
	$event->CallSubEvent($new_event);
	$event->redirect = true;
	}

	$object->SetDBField($this->Application->RecallVar('dst_field'), $user_id);

	if ( $is_new ) {
	$object->Create();
	}
	else {
	$object->Update();
	}
	}

	$event->SetRedirectParam($event->getPrefixSpecial() . '_id', $object->GetID());
	$event->SetRedirectParam('opener', 'u');
	}


	/ EXPORT RELATED /

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnExport(&$event)
	{
	$selected_ids = $this->StoreSelectedIDs($event);

	if (implode(',', $selected_ids) == '') {
	// K4 fix when no ids found bad selected ids array is formed
	$selected_ids = false;
	}

	$this->Application->StoreVar($event->Prefix.'_export_ids', $selected_ids ? implode(',', $selected_ids) : '' );

	$this->Application->LinkVar('export_finish_t');
	$this->Application->LinkVar('export_progress_t');
	$this->Application->StoreVar('export_oroginal_special', $event->Special);

	$export_helper =& $this->Application->recallObject('CatItemExportHelper');

	/*list ($index_file, $env) = explode('\|', $this->Application->RecallVar('last_template'));
	$finish_url = $this->Application->BaseURL('/admin').$index_file.'?'.ENV_VAR_NAME.'='.$env;
	$this->Application->StoreVar('export_finish_url', $finish_url);*/

	$redirect_params = Array (
	$this->Prefix . '.export_event' => 'OnNew',
	'pass' => 'all,' . $this->Prefix . '.export'
	);

	$event->setRedirectParams($redirect_params);
	}

	/**
	* Apply some special processing to object being
	* recalled before using it in other events that
	* call prepareObject
	*
	* @param kDBItem\|kDBList $object
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function prepareObject(&$object, &$event)
	{
	if ( $event->Special == 'export' \|\| $event->Special == 'import' ) {
	$export_helper =& $this->Application->recallObject('CatItemExportHelper');
	/* @var $export_helper kCatDBItemExportHelper */

	$export_helper->prepareExportColumns($event);
	}
	}

	/**
	* Returns specific to each item type columns only
	*
	* @param kEvent $event
	* @return Array
	*/
	function getCustomExportColumns(&$event)
	{
	return Array();
	}

	/**
	* Export form validation & processing
	*
	* @param kEvent $event
	*/
	function OnExportBegin(&$event)
	{
	$export_helper =& $this->Application->recallObject('CatItemExportHelper');
	/* @var $export_helper kCatDBItemExportHelper */
	$export_helper->OnExportBegin($event);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnExportCancel(&$event)
	{
	$this->OnGoBack($event);
	}

	/**
	* Allows configuring export options
	*
	* @param kEvent $event
	*/
	function OnBeforeExportBegin(&$event)
	{

	}

	/**
	* Deletes export preset
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnDeleteExportPreset(&$event)
	{
	$field_values = $this->getSubmittedFields($event);

	if ( !$field_values ) {
	return ;
	}

	$preset_key = $field_values['ExportPresets'];
	$export_settings = $this->Application->RecallPersistentVar('export_settings');

	if ( !$export_settings ) {
	return ;
	}

	$export_settings = unserialize($export_settings);

	if ( !isset($export_settings[$event->Prefix]) ) {
	return ;
	}

	$to_delete = '';

	foreach ($export_settings[$event->Prefix] as $key => $val) {
	if ( implode('\|', $val['ExportColumns']) == $preset_key ) {
	$to_delete = $key;
	break;
	}
	}

	if ( $to_delete ) {
	unset($export_settings[$event->Prefix][$to_delete]);
	$this->Application->StorePersistentVar('export_settings', serialize($export_settings));
	}
	}

	/**
	* Saves changes & changes language
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndChangeLanguage(&$event)
	{
	if ($this->UseTempTables($event)) {
	$event->CallSubEvent('OnPreSave');
	}

	if ($event->status == kEvent::erSUCCESS) {
	$this->Application->SetVar('m_lang', $this->Application->GetVar('language'));

	$data = $this->Application->GetVar('st_id');

	if ($data) {
	$event->SetRedirectParam('st_id', $data);
	}
	}
	}

	/**
	* Used to save files uploaded via swfuploader
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnUploadFile(&$event)
	{
	$event->status = kEvent::erSTOP;
	// define('DBG_SKIP_REPORTING', 0);
	$default_msg = "Flash requires that we output something or it won't fire the uploadSuccess event";

	if (!$this->Application->HttpQuery->Post) {
	// Variables {field, id, flashsid} are always submitted through POST!
	// When file size is larger, then "upload_max_filesize" (in php.ini),
	// then these variables also are not submitted -> handle such case.
	header('HTTP/1.0 413 File size exceeds allowed limit');
	echo $default_msg;
	return ;
	}

	if (!$this->_checkFlashUploaderPermission($event)) {
	// 403 Forbidden
	header('HTTP/1.0 403 You don\'t have permissions to upload');
	echo $default_msg;
	return ;
	}

	$value = $this->Application->GetVar('Filedata');

	if (!$value \|\| ($value['error'] != UPLOAD_ERR_OK)) {
	// 413 Request Entity Too Large (file uploads disabled OR uploaded file was
	// to large for web server to accept, see "upload_max_filesize" in php.ini)
	header('HTTP/1.0 413 File size exceeds allowed limit');
	echo $default_msg;
	return ;
	}

	$tmp_path = WRITEABLE . '/tmp/';
	$fname = $value['name'];
	$id = $this->Application->GetVar('id');

	if ($id) {
	$fname = $id . '_' . $fname;
	}

	$field_name = $this->Application->GetVar('field');
	$fields = $this->Application->getUnitOption($event->Prefix, 'Fields');
	$virtual_fields = $this->Application->getUnitOption($event->Prefix, 'VirtualFields');
	$field_options = array_key_exists($field_name, $fields) ? $fields[$field_name] : $virtual_fields[$field_name];

	$upload_dir = $field_options['upload_dir'];
	$storage_format = array_key_exists('storage_format', $field_options) ? $field_options['storage_format'] : false;

	if (!is_writable($tmp_path)) {
	// 500 Internal Server Error
	// check both temp and live upload directory
	header('HTTP/1.0 500 Write permissions not set on the server');
	echo $default_msg;
	return ;
	}

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

	$fname = $upload_formatter->_ensureUniqueFilename($tmp_path, $fname);

	if ($storage_format) {
	$image_helper =& $this->Application->recallObject('ImageHelper');
	/* @var $image_helper ImageHelper */

	move_uploaded_file($value['tmp_name'], $value['tmp_name'] . '.jpg'); // add extension, so ResizeImage can work
	$url = $image_helper->ResizeImage($value['tmp_name'] . '.jpg', $storage_format);
	$tmp_name = preg_replace('/^' . preg_quote($this->Application->BaseURL(), '/') . '/', '/', $url);
	rename($tmp_name, $tmp_path.$fname);
	}
	else {
	move_uploaded_file($value['tmp_name'], $tmp_path.$fname);
	}

	echo preg_replace('/^' . preg_quote($id, '/') . '_/', '', $fname);

	$this->deleteTempFiles($tmp_path);
	}

	/**
	* Delete temporary files, that won't be used for sure
	*
	* @param string $path
	*/
	function deleteTempFiles($path)
	{
	$files = glob($path . '.');
	$max_file_date = strtotime('-1 day');

	foreach ($files as $file) {
	if (filemtime($file) < $max_file_date) {
	unlink($file);
	}
	}
	}

	/**
	* Checks, that flash uploader is allowed to perform upload
	*
	* @param kEvent $event
	* @return bool
	*/
	function _checkFlashUploaderPermission(&$event)
	{
	// Flash uploader does NOT send correct cookies, so we need to make our own check
	$cookie_name = 'adm_' . $this->Application->ConfigValue('SessionCookieName');
	$this->Application->HttpQuery->Cookie['cookies_on'] = 1;
	$this->Application->HttpQuery->Cookie[$cookie_name] = $this->Application->GetVar('flashsid');

	// this prevents session from auto-expiring when KeepSessionOnBrowserClose & FireFox is used
	$this->Application->HttpQuery->Cookie[$cookie_name . '_live'] = $this->Application->GetVar('flashsid');

	$admin_ses =& $this->Application->recallObject('Session.admin');
	/* @var $admin_ses Session */

	if ($admin_ses->RecallVar('user_id') == USER_ROOT) {
	return true;
	}

	// copy some data from given session to current session
	$backup_user_id = $this->Application->RecallVar('user_id');
	$this->Application->StoreVar('user_id', $admin_ses->RecallVar('user_id'));

	$backup_user_groups = $this->Application->RecallVar('UserGroups');
	$this->Application->StoreVar('UserGroups', $admin_ses->RecallVar('UserGroups'));

	// check permissions using event, that have "add\|edit" rule
	$check_event = new kEvent($event->getPrefixSpecial() . ':OnProcessSelected');
	$check_event->setEventParam('top_prefix', $this->Application->GetTopmostPrefix($event->Prefix, true));
	$allowed_to_upload = $this->CheckPermission($check_event);

	// restore changed data, so nothing gets saved to database
	$this->Application->StoreVar('user_id', $backup_user_id);
	$this->Application->StoreVar('UserGroups', $backup_user_groups);

	return $allowed_to_upload;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnDeleteFile(&$event)
	{
	$event->status = kEvent::erSTOP;

	if (strpos($this->Application->GetVar('file'), '../') !== false) {
	return ;
	}

	$object =& $event->getObject( Array ('skip_autoload' => true) );
	$options = $object->GetFieldOptions( $this->Application->GetVar('field') );

	$var_name = $this->_getPendingActionVariableName($event);
	$schedule = $this->Application->RecallVar($var_name);
	$schedule = $schedule ? unserialize($schedule) : Array ();
	$schedule[] = Array ('action' => 'delete', 'file' => FULL_PATH . $options['upload_dir'] . $this->Application->GetVar('file'));
	$this->Application->StoreVar($var_name, serialize($schedule));
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnViewFile(&$event)
	{
	$event->status = kEvent::erSTOP;

	$file = $this->Application->GetVar('file');
	if ((strpos($file, '../') !== false) \|\| (trim($file) !== $file)) {
	// when relative paths or special chars are found template names from url, then it's hacking attempt
	return ;
	}

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

	$field = $this->Application->GetVar('field');
	$options = $object->GetFieldOptions($field);

	// set current uploaded file
	if ($this->Application->GetVar('tmp')) {
	$options['upload_dir'] = WRITEBALE_BASE . '/tmp/';
	unset($options['include_path']);
	$object->SetFieldOptions($field, $options);

	$object->SetDBField($field, $this->Application->GetVar('id') . '_' . $file);
	}
	else {
	$object->SetDBField($field, $file);
	}

	// get url to uploaded file
	if ($this->Application->GetVar('thumb')) {
	$url = $object->GetField($field, $options['thumb_format']);
	}
	else {
	$url = $object->GetField($field, 'full_url'); // don't use "file_urls" format to prevent recursion
	}

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

	$path = $file_helper->urlToPath($url);

	if (!file_exists($path)) {
	exit;
	}

	$type = mime_content_type($path);

	header('Content-Length: ' . filesize($path));
	header('Content-Type: ' . $type);
	header('Content-Disposition: inline; filename="' . $file . '"');

	readfile($path);
	}

	/**
	* Validates MInput control fields
	*
	* @param kEvent $event
	*/
	function OnValidateMInputFields(&$event)
	{
	$minput_helper =& $this->Application->recallObject('MInputHelper');
	/* @var $minput_helper MInputHelper */

	$minput_helper->OnValidateMInputFields($event);
	}

	/**
	* Returns auto-complete values for ajax-dropdown
	*
	* @param kEvent $event
	*/
	function OnSuggestValues(&$event)
	{
	if (!$this->Application->isAdminUser) {
	// very careful here, because this event allows to
	// view every object field -> limit only to logged-in admins
	return ;
	}

	$event->status = kEvent::erSTOP;

	$field = $this->Application->GetVar('field');
	$cur_value = $this->Application->GetVar('cur_value');
	$fields = $this->Application->getUnitOption($event->Prefix, 'Fields');

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

	if (!$field \|\| !$cur_value \|\| !$object->isField($field)) {
	return ;
	}

	$limit = $this->Application->GetVar('limit');
	if (!$limit) {
	$limit = 20;
	}

	$sql = 'SELECT DISTINCT '.$field.'
	FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	WHERE '.$field.' LIKE '.$this->Conn->qstr($cur_value.'%').'
	ORDER BY '.$field.'
	LIMIT 0,' . $limit;
	$data = $this->Conn->GetCol($sql);

	$this->Application->XMLHeader();

	echo '<suggestions>';

	foreach ($data as $item) {
	echo '<item>' . htmlspecialchars($item) . '</item>';
	}

	echo '</suggestions>';
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSaveWidths(&$event)
	{
	$event->status = kEvent::erSTOP;

	/*$lang =& $this->Application->recallObject('lang.current');
	header('Content-type: text/xml; charset=' . $lang->GetDBField('Charset'));*/

	$picker_helper =& $this->Application->RecallObject('ColumnPickerHelper');
	/* @var $picker_helper kColumnPickerHelper */

	$picker_helper->PreparePicker($event->getPrefixSpecial(), $this->Application->GetVar('grid_name'));
	$picker_helper->SaveWidths($event->getPrefixSpecial(), $this->Application->GetVar('widths'));

	echo 'OK';
	}

	/**
	* Called from CSV import script after item fields
	* are set and validated, but before actual item create/update.
	* If event status is kEvent::erSUCCESS, line will be imported,
	* else it will not be imported but added to skipped lines
	* and displayed in the end of import.
	* Event status is preset from import script.
	*
	* @param kEvent $event
	*/
	function OnBeforeCSVLineImport(&$event)
	{
	// abstract, for hooking
	}

	/**
	* [HOOK] Allows to add cloned subitem to given prefix
	*
	* @param kEvent $event
	*/
	function OnCloneSubItem(&$event)
	{
	$clones = $this->Application->getUnitOption($event->MasterEvent->Prefix, 'Clones');

	$subitem_prefix = $event->Prefix . '-' . preg_replace('/^#/', '', $event->MasterEvent->Prefix);
	$clones[$subitem_prefix] = Array ('ParentPrefix' => $event->Prefix);
	$this->Application->setUnitOption($event->MasterEvent->Prefix, 'Clones', $clones);
	}
	+
	+ /**
	+ * Returns constrain for priority calculations
	+ *
	+ * @param kEvent $event
	+ * @return void
	+ * @see PriorityEventHandler
	+ * @access protected
	+ */
	+ protected function OnGetConstrainInfo(&$event)
	+ {
	+ $event->setEventParam('constrain_info', Array ('', ''));
	+ }
	}
	\ No newline at end of file
	Index: branches/5.2.x/core/units/priorites/priority_eh.php
	===================================================================
	--- branches/5.2.x/core/units/priorites/priority_eh.php (nonexistent)
	+++ branches/5.2.x/core/units/priorites/priority_eh.php (revision 14610)
	@@ -0,0 +1,370 @@
	+<?php
	+
	+class PriorityEventHandler extends kDBEventHandler {
	+
	+ /**
	+ * Allows to override standart permission mapping
	+ *
	+ */
	+ function mapPermissions()
	+ {
	+ parent::mapPermissions();
	+
	+ $permissions = Array (
	+ 'OnRecalculatePriorities' => Array ('self' => true),
	+ );
	+
	+ $this->permMapping = array_merge($this->permMapping, $permissions);
	+ }
	+
	+ function mapEvents()
	+ {
	+ parent::mapEvents();
	+
	+ $events_map = Array (
	+ 'OnMassMoveUp' => 'OnChangePriority',
	+ 'OnMassMoveDown' => 'OnChangePriority',
	+ );
	+
	+ $this->eventMethods = array_merge($this->eventMethods, $events_map);
	+ }
	+
	+ /**
	+ * Enter description here...
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnAfterConfigRead(&$event)
	+ {
	+ $hooks = Array(
	+ Array(
	+ 'Mode' => hAFTER,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnAfterItemLoad', 'OnPreCreate', 'OnListBuild'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnPreparePriorities',
	+ 'Conditional' => false,
	+ ),
	+ Array(
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnPreSaveCreated'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnPreparePriorities',
	+ 'Conditional' => false,
	+ ),
	+ Array(
	+ 'Mode' => hAFTER,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnPreSave', 'OnPreSaveCreated', 'OnSave', 'OnUpdate'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnSavePriorityChanges',
	+ 'Conditional' => false,
	+ ),
	+ Array(
	+ 'Mode' => hAFTER,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnSave'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnSaveItems',
	+ 'Conditional' => false,
	+ ),
	+ Array(
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnBeforeItemCreate'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnItemCreate',
	+ 'Conditional' => false,
	+ ),
	+ Array(
	+ 'Mode' => hBEFORE,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => '',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array('OnAfterItemDelete'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnItemDelete',
	+ 'Conditional' => false,
	+ )
	+ );
	+
	+ $prefixes = $this->Application->getUnitOption($event->Prefix, 'ProcessPrefixes', Array ());
	+ /* @var $prefixes Array */
	+
	+ foreach ($prefixes as $prefix) {
	+ foreach ($hooks as $hook) {
	+ if ( !is_array($hook['HookToEvent']) ) {
	+ $hook['HookToEvent'] = Array($hook['HookToEvent']);
	+ }
	+
	+ foreach ($hook['HookToEvent'] as $hook_event) {
	+ $this->Application->registerHook(
	+ $prefix . '.' . $hook['HookToSpecial'] . ':' . $hook_event,
	+ $event->Prefix . '.' . $hook['DoSpecial'] . ':' . $hook['DoEvent'],
	+ $hook['Mode'],
	+ $hook['Conditional']
	+ );
	+ }
	+ }
	+ }
	+ }
	+
	+ /**
	+ * Should be hooked to OnAfterItemLoad, OnPreSaveCreated (why latter?)
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnPreparePriorities(&$event)
	+ {
	+ if ( !$this->Application->isAdminUser ) {
	+ return ;
	+ }
	+
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+ $is_new = $event->MasterEvent->Name == 'OnPreCreate' \|\| $event->MasterEvent->Name == 'OnPreSaveCreated';
	+ $priority_helper->preparePriorities($event->MasterEvent, $is_new, $constrain, $joins);
	+ }
	+
	+ /**
	+ * Enter description here...
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnSavePriorityChanges(&$event)
	+ {
	+ if ($event->MasterEvent->status != erSUCCESS) {
	+ // don't update priorities, when OnSave validation failed
	+ return ;
	+ }
	+
	+ $object =& $event->MasterEvent->getObject();
	+
	+ $tmp = $this->Application->RecallVar('priority_changes'.$this->Application->GetVar('m_wid'));
	+ $changes = $tmp ? unserialize($tmp) : array();
	+
	+ if (!isset($changes[$object->GetID()])) {
	+ $changes[$object->GetId()]['old'] = $object->GetID() == 0 ? 'new' : $object->GetDBField('OldPriority');
	+ }
	+
	+ if ($changes[$object->GetId()]['old'] == $object->GetDBField('Priority')) return ;
	+ $changes[$object->GetId()]['new'] = $object->GetDBField('Priority');
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+
	+ if ($constrain) {
	+ $changes[$object->GetId()]['constrain'] = $constrain;
	+ }
	+
	+ $this->Application->StoreVar('priority_changes'.$this->Application->GetVar('m_wid'), serialize($changes));
	+ }
	+
	+ /**
	+ * Enter description here...
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnItemDelete(&$event)
	+ {
	+ // just store the prefix in which the items were deleted
	+ $del = $this->Application->RecallVar('priority_deleted' . $this->Application->GetVar('m_wid'));
	+ $del = $del ? unserialize($del) : array();
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+ $cache_key = crc32($event->MasterEvent->Prefix . ':' . $constrain . ':' . $joins);
	+
	+ if ( !isset($del[$cache_key]) ) {
	+ $del[$cache_key] = Array (
	+ 'prefix' => $event->MasterEvent->Prefix,
	+ 'constrain' => $constrain,
	+ 'joins' => $joins,
	+ );
	+
	+ $this->Application->StoreVar('priority_deleted' . $this->Application->GetVar('m_wid'), serialize($del));
	+ }
	+ }
	+
	+ /**
	+ * Called before script shut-down and recalculate all deleted prefixes, to avoid recalculation on each deleted item
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnBeforeShutDown(&$event)
	+ {
	+ $del = $this->Application->RecallVar('priority_deleted'.$this->Application->GetVar('m_wid'));
	+ $del = $del ? unserialize($del) : array();
	+
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ foreach ($del as $del_info) {
	+ $dummy_event = new kEvent( array('prefix'=>$del_info['prefix'], 'name'=>'Dummy' ) );
	+ $ids = $priority_helper->recalculatePriorities($dummy_event, $del_info['constrain'], $del_info['joins']);
	+
	+ if ($ids) {
	+ $priority_helper->massUpdateChanged($del_info['prefix'], $ids);
	+ }
	+ }
	+
	+ $this->Application->RemoveVar('priority_deleted'.$this->Application->GetVar('m_wid'));
	+ }
	+
	+ /**
	+ * Enter description here...
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnSaveItems(&$event)
	+ {
	+ $tmp = $this->Application->RecallVar('priority_changes'.$this->Application->GetVar('m_wid'));
	+ $changes = $tmp ? unserialize($tmp) : array();
	+
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+ $ids = $priority_helper->updatePriorities($event->MasterEvent, $changes, Array (0 => $event->MasterEvent->getEventParam('ids')), $constrain, $joins);
	+
	+ if ($ids) {
	+ $priority_helper->massUpdateChanged($event->MasterEvent->Prefix, $ids);
	+ }
	+ }
	+
	+ function OnItemCreate(&$event)
	+ {
	+ $obj =& $event->MasterEvent->getObject();
	+ if ($obj->GetDBField('Priority') == 0) {
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+ $priority_helper->preparePriorities($event->MasterEvent, true, $constrain, $joins);
	+ }
	+ }
	+
	+ /**
	+ * Processes OnMassMoveUp, OnMassMoveDown events
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnChangePriority(&$event)
	+ {
	+ $prefix = $this->Application->GetVar('priority_prefix');
	+ $dummy_event = new kEvent( array('prefix'=>$prefix, 'name'=>'Dummy' ) );
	+
	+ $ids = $this->StoreSelectedIDs($dummy_event);
	+
	+ if ($ids) {
	+ $id_field = $this->Application->getUnitOption($prefix, 'IDField');
	+ $table_name = $this->Application->getUnitOption($prefix, 'TableName');
	+
	+ if ( $this->Application->IsTempMode($prefix) ) {
	+ $table_name = $this->Application->GetTempName($table_name, 'prefix:' . $prefix);
	+ }
	+
	+ $sql = 'SELECT Priority, '.$id_field.'
	+ FROM '.$table_name.'
	+ WHERE '.$id_field.' IN ('.implode(',', $ids).') ORDER BY Priority DESC';
	+ $priorities = $this->Conn->GetCol($sql, $id_field);
	+
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+
	+ $sql = 'SELECT IFNULL(MIN(item_table.Priority), -1)
	+ FROM '.$table_name . ' item_table
	+ ' . $joins;
	+
	+ if ( $constrain ) {
	+ $sql .= ' WHERE ' . $priority_helper->normalizeConstrain($constrain);
	+ }
	+
	+ $min_priority = $this->Conn->GetOne($sql);
	+
	+ foreach ($ids as $id) {
	+ $new_priority = $priorities[$id] + ($event->Name == 'OnMassMoveUp' ? +1 : -1);
	+ if ($new_priority > -1 \|\| $new_priority < $min_priority) {
	+ continue;
	+ }
	+
	+ $changes = Array (
	+ $id => Array ('old' => $priorities[$id], 'new' => $new_priority),
	+ );
	+
	+ if ($constrain) {
	+ $changes[$id]['constrain'] = $constrain;
	+ }
	+
	+ $sql = 'UPDATE '.$table_name.'
	+ SET Priority = '.$new_priority.'
	+ WHERE '.$id_field.' = '.$id;
	+ $this->Conn->Query($sql);
	+
	+ $ids = $priority_helper->updatePriorities($dummy_event, $changes, Array ($id => $id), $constrain, $joins);
	+
	+ if ($ids) {
	+ $priority_helper->massUpdateChanged($prefix, $ids);
	+ }
	+ }
	+ }
	+
	+ $this->clearSelectedIDs($dummy_event);
	+ }
	+
	+ /**
	+ * Completely recalculates priorities in current category
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnRecalculatePriorities(&$event)
	+ {
	+ $priority_helper =& $this->Application->recallObject('PriorityHelper');
	+ /* @var $priority_helper kPriorityHelper */
	+
	+ $prefix = $this->Application->GetVar('priority_prefix');
	+ $dummy_event = new kEvent( array('prefix'=>$prefix, 'name'=>'Dummy' ) );
	+
	+ list ($constrain, $joins) = $this->getConstrainInfo($event);
	+ $ids = $priority_helper->recalculatePriorities($dummy_event, $constrain, $joins);
	+
	+ if ($ids) {
	+ $priority_helper->massUpdateChanged($prefix, $ids);
	+ }
	+ }
	+
	+ /**
	+ * Returns constrain for current priority calculations
	+ *
	+ * @param kEvent $event
	+ * @return Array
	+ */
	+ function getConstrainInfo(&$event)
	+ {
	+ $constrain_event = new kEvent($event->MasterEvent->getPrefixSpecial() . ':OnGetConstrainInfo');
	+ $constrain_event->setEventParam('actual_event', $event->Name);
	+ $constrain_event->setEventParam('original_event', $event->MasterEvent->Name);
	+ $this->Application->HandleEvent($constrain_event);
	+
	+ return $constrain_event->getEventParam('constrain_info');
	+ }
	+}

	Property changes on: branches/5.2.x/core/units/priorites/priority_eh.php
	___________________________________________________________________
	Added: svn:eol-style
	## -0,0 +1 ##
	+LF
	\ No newline at end of property
	Added: svn:keywords
	## -0,0 +1 ##
	+Id
	\ No newline at end of property
	Index: branches/5.2.x/core/units/priorites/priorites_config.php
	===================================================================
	--- branches/5.2.x/core/units/priorites/priorites_config.php (nonexistent)
	+++ branches/5.2.x/core/units/priorites/priorites_config.php (revision 14610)
	@@ -0,0 +1,31 @@
	+<?php
	+
	+ $config = Array (
	+ 'Prefix' => 'priority',
	+ 'EventHandlerClass' => Array ('class' => 'PriorityEventHandler', 'file' => 'priority_eh.php', 'build_event' => 'OnBuild'),
	+
	+ 'QueryString' => Array (
	+ 1 => 'prefix',
	+ 2 => 'event',
	+ ),
	+
	+ 'Hooks' => Array (
	+ Array (
	+ 'Mode' => hAFTER,
	+ 'Conditional' => false,
	+ 'HookToPrefix' => 'adm',
	+ 'HookToSpecial' => '*',
	+ 'HookToEvent' => Array ('OnBeforeShutdown'),
	+ 'DoPrefix' => 'priority',
	+ 'DoSpecial' => '*',
	+ 'DoEvent' => 'OnBeforeShutdown',
	+ 'Conditional' => false,
	+ ),
	+ ),
	+
	+ 'PermSection' => Array ('main' => 'custom'),
	+
	+ 'ProcessPrefixes' => Array(
	+ 'c', 'st'
	+ ),
	+ );

	Property changes on: branches/5.2.x/core/units/priorites/priorites_config.php
	___________________________________________________________________
	Added: svn:eol-style
	## -0,0 +1 ##
	+LF
	\ No newline at end of property
	Added: svn:keywords
	## -0,0 +1 ##
	+Id
	\ No newline at end of property
	Index: branches/5.2.x/core/units/categories/categories_event_handler.php
	===================================================================
	--- branches/5.2.x/core/units/categories/categories_event_handler.php (revision 14609)
	+++ branches/5.2.x/core/units/categories/categories_event_handler.php (revision 14610)
	@@ -1,2554 +1,2484 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @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 CategoriesEventHandler extends kDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();

	$permissions = Array (
	'OnRebuildCache' => Array ('self' => 'add\|edit'),
	'OnCopy' => Array ('self' => true),
	'OnCut' => Array ('self' => 'edit'),
	'OnPasteClipboard' => Array ('self' => true),
	'OnPaste' => Array ('self' => 'add\|edit', 'subitem' => 'edit'),

	'OnRecalculatePriorities' => Array ('self' => 'add\|edit'), // category ordering
	'OnItemBuild' => Array ('self' => true), // always allow to view individual categories (regardless of CATEGORY.VIEW right)
	'OnUpdatePreviewBlock' => Array ('self' => true), // for FCKEditor integration
	);

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

	/**
	* Categories are sorted using special sorting event
	*
	*/
	function mapEvents()
	{
	parent::mapEvents();

	$events_map = Array (
	'OnMassMoveUp' => 'OnChangePriority',
	'OnMassMoveDown' => 'OnChangePriority',
	);

	$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(&$event)
	{
	if ($event->Name == 'OnResetCMSMenuCache') {
	// events from "Tools -> System Tools" section are controlled via that section "edit" permission

	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	$perm_value = $this->Application->CheckPermission('in-portal:service.edit');

	return $perm_helper->finalizePermissionCheck($event, $perm_value);
	}

	if (!$this->Application->isAdmin) {
	if ($event->Name == 'OnSetSortingDirect') {
	// allow sorting on front event without view permission
	return true;
	}

	if ($event->Name == 'OnItemBuild') {
	$category_id = $this->getPassedID($event);
	if ($category_id == 0) {
	return true;
	}
	}
	}

	if (in_array($event->Name, $this->_getMassPermissionEvents())) {
	$items = $this->_getPermissionCheckInfo($event);

	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	if (($event->Name == 'OnSave') && array_key_exists(0, $items)) {
	// adding new item (ID = 0)
	$perm_value = $perm_helper->AddCheckPermission($items[0]['ParentId'], $event->Prefix) > 0;
	}
	else {
	// leave only items, that can be edited
	$ids = Array ();
	$check_method = in_array($event->Name, Array ('OnMassDelete', 'OnCut')) ? 'DeleteCheckPermission' : 'ModifyCheckPermission';
	foreach ($items as $item_id => $item_data) {
	if ($perm_helper->$check_method($item_data['CreatedById'], $item_data['ParentId'], $event->Prefix) > 0) {
	$ids[] = $item_id;
	}
	}

	if (!$ids) {
	// no items left for editing -> no permission
	return $perm_helper->finalizePermissionCheck($event, false);
	}

	$perm_value = true;
	$event->setEventParam('ids', $ids); // will be used later by "kDBEventHandler::StoreSelectedIDs" method
	}

	return $perm_helper->finalizePermissionCheck($event, $perm_value);
	}

	if ($event->Name == 'OnRecalculatePriorities') {
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	$category_id = $this->Application->GetVar('m_cat_id');

	return $perm_helper->AddCheckPermission($category_id, $event->Prefix) \|\| $perm_helper->ModifyCheckPermission(0, $category_id, $event->Prefix);
	}

	if ($event->Name == 'OnPasteClipboard') {
	// forces permission check to work by current category for "Paste In Category" operation
	$category_id = $this->Application->GetVar('m_cat_id');
	$this->Application->SetVar('c_id', $category_id);
	}

	return parent::CheckPermission($event);
	}

	/**
	* Returns events, that require item-based (not just event-name based) permission check
	*
	* @return Array
	*/
	function _getMassPermissionEvents()
	{
	return Array (
	'OnEdit', 'OnSave', 'OnMassDelete', 'OnMassApprove',
	'OnMassDecline', 'OnMassMoveUp', 'OnMassMoveDown',
	'OnCut',
	);
	}

	/**
	* Returns category item IDs, that require permission checking
	*
	* @param kEvent $event
	* @return string
	*/
	function _getPermissionCheckIDs(&$event)
	{
	if ($event->Name == 'OnSave') {
	$selected_ids = implode(',', $this->getSelectedIDs($event, true));
	if (!$selected_ids) {
	$selected_ids = 0; // when saving newly created item (OnPreCreate -> OnPreSave -> OnSave)
	}
	}
	else {
	// OnEdit, OnMassDelete events, when items are checked in grid
	$selected_ids = implode(',', $this->StoreSelectedIDs($event));
	}

	return $selected_ids;
	}

	/**
	* Returns information used in permission checking
	*
	* @param kEvent $event
	* @return Array
	*/
	function _getPermissionCheckInfo(&$event)
	{
	// when saving data from temp table to live table check by data from temp table
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');

	if ($event->Name == 'OnSave') {
	$table_name = $this->Application->GetTempName($table_name, 'prefix:' . $event->Prefix);
	}

	$sql = 'SELECT ' . $id_field . ', CreatedById, ParentId
	FROM ' . $table_name . '
	WHERE ' . $id_field . ' IN (' . $this->_getPermissionCheckIDs($event) . ')';
	$items = $this->Conn->Query($sql, $id_field);

	if (!$items) {
	// when creating new category, then no IDs are stored in session
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	list ($id, $fields_hash) = each($items_info);

	if (array_key_exists('ParentId', $fields_hash)) {
	$item_category = $fields_hash['ParentId'];
	}
	else {
	$item_category = $this->Application->RecallVar('m_cat_id'); // saved in c:OnPreCreate event permission checking
	}

	$items[$id] = Array (
	'CreatedById' => $this->Application->RecallVar('user_id'),
	'ParentId' => $item_category,
	);
	}

	return $items;
	}

	/**
	* Set's mark, that root category is edited
	*
	* @param kEvent $event
	*/
	function OnEdit(&$event)
	{
	$category_id = $this->Application->GetVar($event->getPrefixSpecial() . '_id');
	$home_category = $this->Application->getBaseCategory();

	$this->Application->StoreVar('IsRootCategory_'.$this->Application->GetVar('m_wid'), ($category_id === '0') \|\| ($category_id == $home_category));

	parent::OnEdit($event);

	if ($event->status == kEvent::erSUCCESS) {
	// keep "Section Properties" link (in browse modes) clean
	$this->Application->DeleteVar('admin');
	}
	}

	/**
	* Adds selected link to listing
	*
	* @param kEvent $event
	*/
	function OnProcessSelected(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$selected_ids = $this->Application->GetVar('selected_ids');

	$this->RemoveRequiredFields($object);
	$object->SetDBField($this->Application->RecallVar('dst_field'), $selected_ids['c']);
	$object->Update();

	$this->finalizePopup($event);
	}

	/**
	* Apply system filter to categories list
	*
	* @param kEvent $event
	* @return void
	* @access protected
	* @see kDBEventHandler::OnListBuild()
	*/
	protected function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

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

	// don't show "Content" category in advanced view
	$object->addFilter('system_categories', '%1$s.Status <> 4');

	// show system templates from current theme only + all virtual templates
	$object->addFilter('theme_filter', '%1$s.ThemeId = ' . $this->_getCurrentThemeId() . ' OR %1$s.ThemeId = 0');

	if ($event->Special == 'showall') {
	// if using recycle bin don't show categories from there
	$recycle_bin = $this->Application->ConfigValue('RecycleBinFolder');
	if ($recycle_bin) {
	$sql = 'SELECT TreeLeft, TreeRight
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$recycle_bin;
	$tree_indexes = $this->Conn->GetRow($sql);

	$object->addFilter('recyclebin_filter', '%1$s.TreeLeft < '.$tree_indexes['TreeLeft'].' OR %1$s.TreeLeft > '.$tree_indexes['TreeRight']);
	}
	}

	if ($event->getEventParam('parent_cat_id') !== false) {
	$parent_cat_id = $event->getEventParam('parent_cat_id');

	if ("$parent_cat_id" == 'Root') {
	$module_name = $event->getEventParam('module') ? $event->getEventParam('module') : 'In-Commerce';
	$parent_cat_id = $this->Application->findModule('Name', $module_name, 'RootCat');
	}
	}
	else {
	$parent_cat_id = $this->Application->GetVar('c_id');
	if (!$parent_cat_id) {
	$parent_cat_id = $this->Application->GetVar('m_cat_id');
	}
	if (!$parent_cat_id) {
	$parent_cat_id = 0;
	}
	}

	if ("$parent_cat_id" == '0') {
	// replace "0" category with "Content" category id (this way template
	$parent_cat_id = $this->Application->getBaseCategory();
	}

	if ("$parent_cat_id" != 'any') {
	if ($event->getEventParam('recursive')) {
	if ($parent_cat_id > 0) {
	// not "Home" category
	$tree_indexes = $this->Application->getTreeIndex($parent_cat_id);

	$object->addFilter('parent_filter', TABLE_PREFIX.'Category.TreeLeft BETWEEN '.$tree_indexes['TreeLeft'].' AND '.$tree_indexes['TreeRight']);
	}
	}
	else {
	$object->addFilter('parent_filter', '%1$s.ParentId = '.$parent_cat_id);
	}
	}

	$object->addFilter('perm_filter', TABLE_PREFIX . 'PermCache.PermId = 1'); // check for CATEGORY.VIEW permission
	if ($this->Application->RecallVar('user_id') != USER_ROOT) {
	// apply permission filters to all users except "root"
	$groups = explode(',',$this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', ' . TABLE_PREFIX . 'PermCache.ACL)';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	}

	if (!$this->Application->isAdminUser) {
	// apply status filter only on front
	$object->addFilter('status_filter', $object->TableName.'.Status = 1');
	}

	// process "types" and "except" parameters
	$type_clauses = Array();

	$types = $event->getEventParam('types');
	$types = $types ? explode(',', $types) : Array ();

	$except_types = $event->getEventParam('except');
	$except_types = $except_types ? explode(',', $except_types) : Array ();

	if (in_array('related', $types) \|\| in_array('related', $except_types)) {
	$related_to = $event->getEventParam('related_to');
	if (!$related_to) {
	$related_prefix = $event->Prefix;
	}
	else {
	$sql = 'SELECT Prefix
	FROM '.TABLE_PREFIX.'ItemTypes
	WHERE ItemName = '.$this->Conn->qstr($related_to);
	$related_prefix = $this->Conn->GetOne($sql);
	}

	$rel_table = $this->Application->getUnitOption('rel', 'TableName');
	$item_type = (int)$this->Application->getUnitOption($event->Prefix, 'ItemType');

	if ($item_type == 0) {
	trigger_error('<strong>ItemType</strong> not defined for prefix <strong>' . $event->Prefix . '</strong>', E_USER_WARNING);
	}

	// process case, then this list is called inside another list
	$prefix_special = $event->getEventParam('PrefixSpecial');
	if (!$prefix_special) {
	$prefix_special = $this->Application->Parser->GetParam('PrefixSpecial');
	}

	$id = false;
	if ($prefix_special !== false) {
	$processed_prefix = $this->Application->processPrefix($prefix_special);
	if ($processed_prefix['prefix'] == $related_prefix) {
	// printing related categories within list of items (not on details page)
	$list =& $this->Application->recallObject($prefix_special);
	/* @var $list kDBList */

	$id = $list->GetID();
	}
	}

	if ($id === false) {
	// printing related categories for single item (possibly on details page)
	if ($related_prefix == 'c') {
	$id = $this->Application->GetVar('m_cat_id');
	}
	else {
	$id = $this->Application->GetVar($related_prefix . '_id');
	}
	}

	$p_item =& $this->Application->recallObject($related_prefix . '.current', null, Array('skip_autoload' => true));
	/* @var $p_item kCatDBItem */
	-
	+
	$p_item->Load( (int)$id );

	$p_resource_id = $p_item->GetDBField('ResourceId');

	$sql = 'SELECT SourceId, TargetId FROM '.$rel_table.'
	WHERE
	(Enabled = 1)
	AND (
	(Type = 0 AND SourceId = '.$p_resource_id.' AND TargetType = '.$item_type.')
	OR
	(Type = 1
	AND (
	(SourceId = '.$p_resource_id.' AND TargetType = '.$item_type.')
	OR
	(TargetId = '.$p_resource_id.' AND SourceType = '.$item_type.')
	)
	)
	)';

	$related_ids_array = $this->Conn->Query($sql);
	$related_ids = Array();

	foreach ($related_ids_array as $key => $record) {
	$related_ids[] = $record[ $record['SourceId'] == $p_resource_id ? 'TargetId' : 'SourceId' ];
	}

	if (count($related_ids) > 0) {
	$type_clauses['related']['include'] = '%1$s.ResourceId IN ('.implode(',', $related_ids).')';
	$type_clauses['related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_ids).')';
	}
	else {
	$type_clauses['related']['include'] = '0';
	$type_clauses['related']['except'] = '1';
	}

	$type_clauses['related']['having_filter'] = false;
	}

	if (in_array('category_related', $type_clauses)) {
	$object->removeFilter('parent_filter');
	$resource_id = $this->Conn->GetOne('
	SELECT ResourceId FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	WHERE CategoryId = '.$parent_cat_id
	);

	$sql = 'SELECT DISTINCT(TargetId) FROM '.TABLE_PREFIX.'Relationship
	WHERE SourceId = '.$resource_id.' AND SourceType = 1';
	$related_cats = $this->Conn->GetCol($sql);
	$related_cats = is_array($related_cats) ? $related_cats : Array();

	$sql = 'SELECT DISTINCT(SourceId) FROM '.TABLE_PREFIX.'Relationship
	WHERE TargetId = '.$resource_id.' AND TargetType = 1 AND Type = 1';
	$related_cats2 = $this->Conn->GetCol($sql);
	$related_cats2 = is_array($related_cats2) ? $related_cats2 : Array();
	$related_cats = array_unique( array_merge( $related_cats2, $related_cats ) );

	if ($related_cats) {
	$type_clauses['category_related']['include'] = '%1$s.ResourceId IN ('.implode(',', $related_cats).')';
	$type_clauses['category_related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_cats).')';
	}
	else
	{
	$type_clauses['category_related']['include'] = '0';
	$type_clauses['category_related']['except'] = '1';
	}
	$type_clauses['category_related']['having_filter'] = false;
	}

	if (in_array('product_related', $types)) {
	$object->removeFilter('parent_filter');

	$product_id = $event->getEventParam('product_id') ? $event->getEventParam('product_id') : $this->Application->GetVar('p_id');
	$resource_id = $this->Conn->GetOne('
	SELECT ResourceId FROM '.$this->Application->getUnitOption('p', 'TableName').'
	WHERE ProductId = '.$product_id
	);

	$sql = 'SELECT DISTINCT(TargetId) FROM '.TABLE_PREFIX.'Relationship
	WHERE SourceId = '.$resource_id.' AND TargetType = 1';
	$related_cats = $this->Conn->GetCol($sql);
	$related_cats = is_array($related_cats) ? $related_cats : Array();
	$sql = 'SELECT DISTINCT(SourceId) FROM '.TABLE_PREFIX.'Relationship
	WHERE TargetId = '.$resource_id.' AND SourceType = 1 AND Type = 1';
	$related_cats2 = $this->Conn->GetCol($sql);
	$related_cats2 = is_array($related_cats2) ? $related_cats2 : Array();
	$related_cats = array_unique( array_merge( $related_cats2, $related_cats ) );

	if ($related_cats) {
	$type_clauses['product_related']['include'] = '%1$s.ResourceId IN ('.implode(',', $related_cats).')';
	$type_clauses['product_related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_cats).')';
	}
	else {
	$type_clauses['product_related']['include'] = '0';
	$type_clauses['product_related']['except'] = '1';
	}

	$type_clauses['product_related']['having_filter'] = false;
	}

	$type_clauses['menu']['include'] = '%1$s.IsMenu = 1';
	$type_clauses['menu']['except'] = '%1$s.IsMenu = 0';
	$type_clauses['menu']['having_filter'] = false;

	if (in_array('search', $types) \|\| in_array('search', $except_types)) {
	$event_mapping = Array (
	'simple' => 'OnSimpleSearch',
	'subsearch' => 'OnSubSearch',
	'advanced' => 'OnAdvancedSearch'
	);

	$type = $this->Application->GetVar('search_type', 'simple');

	if ($keywords = $event->getEventParam('keyword_string')) {
	// processing keyword_string param of ListProducts tag
	$this->Application->SetVar('keywords', $keywords);
	$type = 'simple';
	}

	$search_event = $event_mapping[$type];
	$this->$search_event($event);

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

	$search_sql = ' FROM ' . TABLE_PREFIX . 'ses_' . $this->Application->GetSID() . '_' . TABLE_PREFIX . 'Search
	search_result LEFT JOIN %1$s ON %1$s.ResourceId = search_result.ResourceId';
	$sql = str_replace('FROM %1$s', $search_sql, $object->SelectClause);

	$object->SetSelectSQL($sql);

	$object->addCalculatedField('Relevance', 'search_result.Relevance');
	$object->AddOrderField('search_result.Relevance', 'desc', true);

	$type_clauses['search']['include'] = '1';
	$type_clauses['search']['except'] = '0';
	$type_clauses['search']['having_filter'] = false;
	}

	$search_helper =& $this->Application->recallObject('SearchHelper');
	/* @var $search_helper kSearchHelper */

	$search_helper->SetComplexFilter($event, $type_clauses, implode(',', $types), implode(',', $except_types));
	}

	/**
	* Returns current theme id
	*
	* @return int
	*/
	function _getCurrentThemeId()
	{
	$themes_helper =& $this->Application->recallObject('ThemesHelper');
	/* @var $themes_helper kThemesHelper */

	return (int)$themes_helper->getCurrentThemeId();
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return int
	*/
	function getPassedID(&$event)
	{
	if (($event->Special == 'page') \|\| ($event->Special == '-virtual') \|\| ($event->Prefix == 'st')) {
	return $this->_getPassedStructureID($event);
	}

	if ($this->Application->isAdmin) {
	return parent::getPassedID($event);
	}

	return $this->Application->GetVar('m_cat_id');
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return int
	*/
	function _getPassedStructureID(&$event)
	{
	static $page_by_template = Array ();

	if ($event->Special == 'current') {
	return $this->Application->GetVar('m_cat_id');
	}

	$event->setEventParam('raise_warnings', 0);

	$page_id = parent::getPassedID($event);

	if ($page_id === false) {
	$template = $event->getEventParam('page');
	if (!$template) {
	$template = $this->Application->GetVar('t');
	}

	// bug: when template contains "-" symbols (or others, that stripDisallowed will replace) it's not found
	if (!array_key_exists($template, $page_by_template)) {
	$sql = 'SELECT ' . $this->Application->getUnitOption($event->Prefix, 'IDField') . '
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . '
	WHERE
	(
	(NamedParentPath = ' . $this->Conn->qstr($template) . ') OR
	(NamedParentPath = ' . $this->Conn->qstr('Content/' . $template) . ') OR
	(`Type` = ' . PAGE_TYPE_TEMPLATE . ' AND CachedTemplate = ' . $this->Conn->qstr($template) . ')
	) AND (ThemeId = ' . $this->_getCurrentThemeId() . ' OR ThemeId = 0)';

	$page_id = $this->Conn->GetOne($sql);
	}
	else {
	$page_id = $page_by_template[$template];
	}

	if ($page_id === false && EDITING_MODE) {
	// create missing pages, when in editing mode
	$object =& $this->Application->recallObject($this->Prefix . '.rebuild', null, Array('skip_autoload' => true));
	/* @var $object CategoriesItem */

	$created = $this->_prepareAutoPage($object, $template, null, SMS_MODE_AUTO); // create virtual (not system!) page
	if ($created) {
	if ($this->Application->ConfigValue('QuickCategoryPermissionRebuild') \|\| !$this->Application->isAdmin) {
	$updater =& $this->Application->makeClass('kPermCacheUpdater');
	/* @var $updater kPermCacheUpdater */

	$updater->OneStepRun();
	}

	$this->_resetMenuCache();

	$this->Application->RemoveVar('PermCache_UpdateRequired');

	$page_id = $object->GetID();
	$this->Application->SetVar('m_cat_id', $page_id);
	}
	}

	if ($page_id) {
	$page_by_template[$template] = $page_id;
	}
	}

	if (!$page_id && !$this->Application->isAdmin) {
	$page_id = $this->Application->GetVar('m_cat_id');
	}

	return $page_id;
	}

	function ParentGetPassedId(&$event)
	{
	return parent::GetPassedId($event);
	}

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function prepareObject(&$object, &$event)
	{
	if ($event->Special != '-virtual') {
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$object->addCalculatedField(
	'IsNew',
	' IF(%1$s.NewItem = 2,
	IF(%1$s.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue('Category_DaysNew').
	'360024), 1, 0),
	%1$s.NewItem
	)');
	}
	}

	/**
	* Set correct parent path for newly created categories
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToLive(&$event)
	{
	$object =& $this->Application->recallObject($event->Prefix . '.-item', null, Array ('skip_autoload' => true, 'live_table' => true));
	/* @var $object CategoriesItem */

	$parent_path = false;
	$object->Load( $event->getEventParam('id') );

	if ( $event->getEventParam('temp_id') == 0 ) {
	if ( $object->isLoaded() ) {
	// update path only for real categories (not including "Home" root category)
	$fields_hash = Array ('ParentPath' => $object->buildParentPath());
	$this->Conn->doUpdate($fields_hash, $object->TableName, 'CategoryId = ' . $object->GetID());
	$parent_path = $fields_hash['ParentPath'];
	}
	}
	else {
	$parent_path = $object->GetDBField('ParentPath');
	}

	if ( $parent_path ) {
	$cache_updater =& $this->Application->makeClass('kPermCacheUpdater', Array (null, $parent_path));
	/* @var $cache_updater kPermCacheUpdater */

	$cache_updater->OneStepRun();
	}
	}

	/**
	* Set cache modification mark if needed
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeDeleteFromLive(&$event)
	{
	parent::OnBeforeDeleteFromLive($event);

	$id = $event->getEventParam('id');

	// loading anyway, because this object is needed by "c-perm:OnBeforeDeleteFromLive" event
	$temp_object =& $event->getObject(Array ('skip_autoload' => true));
	/* @var $temp_object CategoriesItem */

	$temp_object->Load($id);

	if ( $id == 0 ) {
	if ( $temp_object->isLoaded() ) {
	// new category -> update cache (not loaded when "Home" category)
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	}

	return ;
	}

	// existing category was edited, check if in-cache fields are modified
	$live_object =& $this->Application->recallObject($event->Prefix . '.-item', null, Array ('live_table' => true, 'skip_autoload' => true));
	/* @var $live_object CategoriesItem */

	$live_object->Load($id);
	$cached_fields = Array ('l' . $this->Application->GetDefaultLanguageId() . '_Name', 'Filename', 'Template', 'ParentId', 'Priority');

	foreach ($cached_fields as $cached_field) {
	if ( $live_object->GetDBField($cached_field) != $temp_object->GetDBField($cached_field) ) {
	// use session instead of REQUEST because of permission editing in category can contain
	// multiple submits, that changes data before OnSave event occurs
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	break;
	}
	}
	}

	/**
	* Calls kDBEventHandler::OnSave original event
	* Used in proj-cms:StructureEventHandler->OnSave
	*
	* @param kEvent $event
	*/
	function parentOnSave(&$event)
	{
	parent::OnSave($event);
	}

	/**
	* Reset root-category flag when new category is created
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreCreate(&$event)
	{
	// 1. for permission editing of Home category
	$this->Application->RemoveVar('IsRootCategory_' . $this->Application->GetVar('m_wid'));

	parent::OnPreCreate($event);

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

	// 2. preset template
	$category_id = $this->Application->GetVar('m_cat_id');
	$root_category = $this->Application->getBaseCategory();
	-
	+
	if ( $category_id == $root_category ) {
	$object->SetDBField('Template', $this->_getDefaultDesign());
	}

	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- // 3. prepare priorities dropdown
	- $priority_helper->preparePriorities($event, true, 'ParentId = ' . $category_id);
	-
	- // 4. set default owner
	+ // 3. set default owner
	$object->SetDBField('CreatedById', $this->Application->RecallVar('user_id'));
	}

	/**
	* Checks cache update mark and redirect to cache if needed
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnSave(&$event)
	{
	// get data from live table before it is overwritten by parent OnSave method call
	$ids = $this->getSelectedIDs($event, true);
	$is_editing = implode('', $ids);
	$old_statuses = $is_editing ? $this->_getCategoryStatus($ids) : Array ();

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

	parent::OnSave($event);

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

	- // 1. update priorities
	- $tmp = $this->Application->RecallVar('priority_changes' . $this->Application->GetVar('m_wid'));
	- $changes = $tmp ? unserialize($tmp) : Array ();
	- $changed_ids = array_keys($changes);
	-
	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- $priority_helper->updatePriorities($event, $changes, Array (0 => $event->getEventParam('ids')));
	-
	if ( $this->Application->RecallVar('PermCache_UpdateRequired') ) {
	$this->Application->RemoveVar('IsRootCategory_' . $this->Application->GetVar('m_wid'));
	}

	$this->Application->StoreVar('RefreshStructureTree', 1);
	$this->_resetMenuCache();

	if ( $is_editing ) {
	- // 2. send email event to category owner, when it's status is changed (from admin)
	+ // send email event to category owner, when it's status is changed (from admin)
	$object->SwitchToLive();
	$new_statuses = $this->_getCategoryStatus($ids);
	$process_statuses = Array (STATUS_ACTIVE, STATUS_DISABLED);

	foreach ($new_statuses as $category_id => $new_status) {
	if ( $new_status != $old_statuses[$category_id] && in_array($new_status, $process_statuses) ) {
	$object->Load($category_id);
	$email_event = $new_status == STATUS_ACTIVE ? 'CATEGORY.APPROVE' : 'CATEGORY.DENY';
	$this->Application->EmailEventUser($email_event, $object->GetDBField('CreatedById'));
	}
	}
	}
	}

	/**
	* Returns statuses of given categories
	*
	* @param Array $category_ids
	* @return Array
	*/
	function _getCategoryStatus($category_ids)
	{
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($this->Prefix, 'TableName');

	$sql = 'SELECT Status, ' . $id_field . '
	FROM ' . $table_name . '
	WHERE ' . $id_field . ' IN (' . implode(',', $category_ids) . ')';
	return $this->Conn->GetCol($sql, $id_field);
	}

	/**
	* Creates a new item in temp table and
	* stores item id in App vars and Session on success
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPreSaveCreated(&$event)
	{
	$object =& $event->getObject( Array ('skip_autoload' => true) );
	/* @var $object CategoriesItem */

	if ( $object->IsRoot() ) {
	// don't create root category while saving permissions
	return;
	}

	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- $category_id = $this->Application->GetVar('m_cat_id');
	- $priority_helper->preparePriorities($event, true, 'ParentId = ' . $category_id);
	-
	parent::OnPreSaveCreated($event);
	}

	/**
	* Deletes sym link to other category
	*
	* @param kEvent $event
	*/
	function OnAfterItemDelete(&$event)
	{
	parent::OnAfterItemDelete($event);

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

	$sql = 'UPDATE '.$object->TableName.'
	SET SymLinkCategoryId = NULL
	WHERE SymLinkCategoryId = '.$object->GetID();

	$this->Conn->Query($sql);
	}

	/**
	* Exclude root categories from deleting
	*
	* @param kEvent $event
	* @param string $type
	* @return void
	* @access protected
	*/
	protected function customProcessing(&$event, $type)
	{
	- if ($event->Name == 'OnMassDelete' && $type == 'before') {
	+ if ( $event->Name == 'OnMassDelete' && $type == 'before' ) {
	$ids = $event->getEventParam('ids');
	- if (!$ids \|\| $this->Application->ConfigValue('AllowDeleteRootCats')) {
	- return ;
	+ if ( !$ids \|\| $this->Application->ConfigValue('AllowDeleteRootCats') ) {
	+ return;
	}

	+ $root_categories = Array ();
	+
	// get module root categories and exclude them
	foreach ($this->Application->ModuleInfo as $module_info) {
	$root_categories[] = $module_info['RootCat'];
	}
	+
	$root_categories = array_unique($root_categories);

	- if ($root_categories && array_intersect($ids, $root_categories)) {
	+ if ( $root_categories && array_intersect($ids, $root_categories) ) {
	$event->setEventParam('ids', array_diff($ids, $root_categories));
	$this->Application->StoreVar('root_delete_error', 1);
	}
	}
	-
	- $change_events = Array ('OnPreSave', 'OnPreSaveCreated', 'OnUpdate', 'OnSave');
	- if ($type == 'after' && in_array($event->Name, $change_events)) {
	- $object =& $event->getObject();
	- /* @var $object kDBItem */
	-
	- $tmp = $this->Application->RecallVar('priority_changes'.$this->Application->GetVar('m_wid'));
	- $changes = $tmp ? unserialize($tmp) : array();
	-
	- if (!isset($changes[$object->GetID()])) {
	- $changes[$object->GetId()]['old'] = $object->GetID() == 0 ? 'new' : $object->GetDBField('OldPriority');
	- }
	-
	- if ($changes[$object->GetId()]['old'] == $object->GetDBField('Priority')) return ;
	-
	- $changes[$object->GetId()]['new'] = $object->GetDBField('Priority');
	- $changes[$object->GetId()]['parent'] = $object->GetDBField('ParentId');
	-
	- $this->Application->StoreVar('priority_changes'.$this->Application->GetVar('m_wid'), serialize($changes));
	- }
	}

	/**
	* Checks, that given template exists (physically) in given theme
	*
	* @param string $template
	* @param int $theme_id
	* @return bool
	*/
	function _templateFound($template, $theme_id = null)
	{
	static $init_made = false;

	if (!$init_made) {
	$this->Application->InitParser(true);
	$init_made = true;
	}

	if (!isset($theme_id)) {
	$theme_id = $this->_getCurrentThemeId();
	}

	$theme_name = $this->_getThemeName($theme_id);

	return $this->Application->TemplatesCache->TemplateExists('theme:' . $theme_name . '/' . $template);
	}

	/**
	* Removes ".tpl" in template path
	*
	* @param string $template
	* @return string
	*/
	function _stripTemplateExtension($template)
	{
	// return preg_replace('/\.[^.\\\\\\/]*$/', '', $template);

	return preg_replace('/^[\\/]{0,1}(.*)\.tpl$/', "$1", $template);
	}

	/**
	* Deletes all selected items.
	* Automatically recurse into sub-items using temp handler, and deletes sub-items
	* by calling its Delete method if sub-item has AutoDelete set to true in its config file
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnMassDelete(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return ;
	}

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

	if ( $recycle_bin = $this->Application->ConfigValue('RecycleBinFolder') ) {
	$rb =& $this->Application->recallObject('c.recycle', null, Array ('skip_autoload' => true));
	/* @var $rb CategoriesItem */

	$rb->Load($recycle_bin);

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

	foreach ($ids as $id) {
	$cat->Load($id);
	if ( preg_match('/^' . preg_quote($rb->GetDBField('ParentPath'), '/') . '/', $cat->GetDBField('ParentPath')) ) {
	$to_delete[] = $id;
	continue;
	}
	$cat->SetDBField('ParentId', $recycle_bin);
	$cat->Update();
	}
	$ids = $to_delete;
	$event->redirect = 'categories/cache_updater';
	}

	$event->setEventParam('ids', $ids);
	$this->customProcessing($event, 'before');
	$ids = $event->getEventParam('ids');

	if ( $ids ) {
	$recursive_helper =& $this->Application->recallObject('RecursiveHelper');
	/* @var $recursive_helper kRecursiveHelper */

	foreach ($ids as $id) {
	$recursive_helper->DeleteCategory($id, $event->Prefix);
	}
	}
	$this->clearSelectedIDs($event);

	- // update priorities
	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- // after deleting categories, all priorities should be recalculated
	- $parent_id = $this->Application->GetVar('m_cat_id');
	- $priority_helper->recalculatePriorities($event, 'ParentId = ' . $parent_id);
	-
	$this->Application->StoreVar('RefreshStructureTree', 1);
	$this->_resetMenuCache();
	}

	/**
	* Add selected items to clipboard with mode = COPY (CLONE)
	*
	* @param kEvent $event
	*/
	function OnCopy(&$event)
	{
	$this->Application->RemoveVar('clipboard');

	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	/* @var $clipboard_helper kClipboardHelper */

	$clipboard_helper->setClipboard($event, 'copy', $this->StoreSelectedIDs($event));
	$this->clearSelectedIDs($event);
	}

	/**
	* Add selected items to clipboard with mode = CUT
	*
	* @param kEvent $event
	*/
	function OnCut(&$event)
	{
	$this->Application->RemoveVar('clipboard');

	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	/* @var $clipboard_helper kClipboardHelper */

	$clipboard_helper->setClipboard($event, 'cut', $this->StoreSelectedIDs($event));
	$this->clearSelectedIDs($event);
	}

	/**
	* Controls all item paste operations. Can occur only with filled clipbord.
	*
	* @param kEvent $event
	*/
	function OnPasteClipboard(&$event)
	{
	$clipboard = unserialize( $this->Application->RecallVar('clipboard') );
	foreach ($clipboard as $prefix => $clipboard_data) {
	$paste_event = new kEvent($prefix.':OnPaste', Array('clipboard_data' => $clipboard_data));
	$this->Application->HandleEvent($paste_event);

	$event->copyFrom($paste_event);
	}
	}

	/**
	* Checks permission for OnPaste event
	*
	* @param kEvent $event
	* @return bool
	*/
	function _checkPastePermission(&$event)
	{
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	$category_id = $this->Application->GetVar('m_cat_id');
	if ($perm_helper->AddCheckPermission($category_id, $event->Prefix) == 0) {
	// no items left for editing -> no permission
	return $perm_helper->finalizePermissionCheck($event, false);
	}

	return true;
	}

	/**
	* Paste categories with sub-items from clipboard
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnPaste(&$event)
	{
	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) \|\| !$this->_checkPastePermission($event) ) {
	$event->status = kEvent::erFAIL;
	return;
	}

	$clipboard_data = $event->getEventParam('clipboard_data');

	if ( !$clipboard_data['cut'] && !$clipboard_data['copy'] ) {
	return;
	}

	// 1. get ParentId of moved category(-es) before it gets updated!!!)
	$source_category_id = 0;
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');

	if ( $clipboard_data['cut'] ) {
	$sql = 'SELECT ParentId
	FROM ' . $table_name . '
	WHERE ' . $id_field . ' = ' . $clipboard_data['cut'][0];
	$source_category_id = $this->Conn->GetOne($sql);
	}

	$recursive_helper =& $this->Application->recallObject('RecursiveHelper');
	/* @var $recursive_helper kRecursiveHelper */

	if ( $clipboard_data['cut'] ) {
	$recursive_helper->MoveCategories($clipboard_data['cut'], $this->Application->GetVar('m_cat_id'));
	}

	if ( $clipboard_data['copy'] ) {
	// don't allow to copy/paste system OR theme-linked virtual pages

	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE ' . $id_field . ' IN (' . implode(',', $clipboard_data['copy']) . ') AND (`Type` = ' . PAGE_TYPE_VIRTUAL . ') AND (ThemeId = 0)';
	$allowed_ids = $this->Conn->GetCol($sql);

	if ( !$allowed_ids ) {
	return;
	}

	foreach ($allowed_ids as $id) {
	$recursive_helper->PasteCategory($id, $event->Prefix);
	}
	}

	$priority_helper =& $this->Application->recallObject('PriorityHelper');
	/* @var $priority_helper kPriorityHelper */

	if ( $clipboard_data['cut'] ) {
	- $priority_helper->recalculatePriorities($event, 'ParentId = ' . $source_category_id);
	+ $ids = $priority_helper->recalculatePriorities($event, 'ParentId = ' . $source_category_id);
	+
	+ if ( $ids ) {
	+ $priority_helper->massUpdateChanged($event->Prefix, $ids);
	+ }
	}

	// recalculate priorities of newly pasted categories in destination category
	$parent_id = $this->Application->GetVar('m_cat_id');
	- $priority_helper->recalculatePriorities($event, 'ParentId = ' . $parent_id);
	+ $ids = $priority_helper->recalculatePriorities($event, 'ParentId = ' . $parent_id);
	+
	+ if ( $ids ) {
	+ $priority_helper->massUpdateChanged($event->Prefix, $ids);
	+ }

	if ( $clipboard_data['cut'] \|\| $clipboard_data['copy'] ) {
	// rebuild with progress bar
	if ( $this->Application->ConfigValue('QuickCategoryPermissionRebuild') ) {
	$updater =& $this->Application->makeClass('kPermCacheUpdater');
	/* @var $updater kPermCacheUpdater */

	$updater->OneStepRun();
	}
	else {
	$event->redirect = 'categories/cache_updater';
	}

	$this->_resetMenuCache();
	$this->Application->StoreVar('RefreshStructureTree', 1);
	}
	}

	/**
	* Occurs when pasting category
	*
	* @param kEvent $event
	*/
	/*function OnCatPaste(&$event)
	{
	$inp_clipboard = $this->Application->RecallVar('ClipBoard');
	$inp_clipboard = explode('-', $inp_clipboard, 2);

	if($inp_clipboard[0] == 'COPY')
	{
	$saved_cat_id = $this->Application->GetVar('m_cat_id');
	$cat_ids = $event->getEventParam('cat_ids');

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$ids_sql = 'SELECT '.$id_field.' FROM '.$table.' WHERE ResourceId IN (%s)';
	$resource_ids_sql = 'SELECT ItemResourceId FROM '.TABLE_PREFIX.'CategoryItems WHERE CategoryId = %s AND PrimaryCat = 1';

	$object =& $this->Application->recallObject($event->Prefix.'.item', $event->Prefix, Array('skip_autoload' => true));

	foreach($cat_ids as $source_cat => $dest_cat)
	{
	$item_resource_ids = $this->Conn->GetCol( sprintf($resource_ids_sql, $source_cat) );
	if(!$item_resource_ids) continue;

	$this->Application->SetVar('m_cat_id', $dest_cat);
	$item_ids = $this->Conn->GetCol( sprintf($ids_sql, implode(',', $item_resource_ids) ) );

	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	if($item_ids) $temp->CloneItems($event->Prefix, $event->Special, $item_ids);
	}

	$this->Application->SetVar('m_cat_id', $saved_cat_id);
	}
	}*/

	/**
	* Cleares clipboard content
	*
	* @param kEvent $event
	*/
	function OnClearClipboard(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	}

	/**
	* Sets correct status for new categories created on front-end
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeItemCreate(&$event)
	{
	parent::OnBeforeItemCreate($event);

	$this->_beforeItemChange($event);

	if ( $this->Application->isAdminUser \|\| $event->Prefix == 'st' ) {
	// don't check category permissions when auto-creating structure pages
	return ;
	}

	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	$new_status = false;
	$category_id = $this->Application->GetVar('m_cat_id');

	if ( $perm_helper->CheckPermission('CATEGORY.ADD', 0, $category_id) ) {
	$new_status = STATUS_ACTIVE;
	}
	else {
	if ( $perm_helper->CheckPermission('CATEGORY.ADD.PENDING', 0, $category_id) ) {
	$new_status = STATUS_PENDING;
	}
	}

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

	$object->SetDBField('Status', $new_status);

	// don't forget to set Priority for suggested from Front-End categories
	$min_priority = $this->_getNextPriority($object->GetDBField('ParentId'), $object->TableName);
	$object->SetDBField('Priority', $min_priority);
	}
	else {
	$event->status = kEvent::erPERM_FAIL;
	return ;
	}
	}

	/**
	* Returns next available priority for given category from given table
	*
	* @param int $category_id
	* @param string $table_name
	* @return int
	*/
	function _getNextPriority($category_id, $table_name)
	{
	$sql = 'SELECT MIN(Priority)
	FROM ' . $table_name . '
	WHERE ParentId = ' . $category_id;
	return (int)$this->Conn->GetOne($sql) - 1;
	}

	/**
	* Sets correct status for new categories created on front-end
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnBeforeItemUpdate(&$event)
	{
	parent::OnBeforeItemUpdate($event);

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

	if ( $object->GetChangedFields() ) {
	$object->SetDBField('ModifiedById', $this->Application->RecallVar('user_id'));
	}

	$this->_beforeItemChange($event);
	}

	/**
	* Performs redirect to correct suggest confirmation template
	*
	* @param kEvent $event
	*/
	function OnCreate(&$event)
	{
	parent::OnCreate($event);

	if ($this->Application->isAdminUser \|\| $event->status != kEvent::erSUCCESS) {
	// don't sent email or rebuild cache directly after category is created by admin
	return ;
	}

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

	$cache_updater =& $this->Application->makeClass('kPermCacheUpdater', Array (null, $object->GetDBField('ParentPath')));
	/* @var $cache_updater kPermCacheUpdater */

	$cache_updater->OneStepRun();

	$is_active = ($object->GetDBField('Status') == STATUS_ACTIVE);

	$next_template = $is_active ? 'suggest_confirm_template' : 'suggest_pending_confirm_template';
	$event->redirect = $this->Application->GetVar($next_template);
	$event->SetRedirectParam('opener', 's');

	// send email events
	$perm_prefix = $this->Application->getUnitOption($event->Prefix, 'PermItemPrefix');

	$event_suffix = $is_active ? 'ADD' : 'ADD.PENDING';
	$this->Application->EmailEventAdmin($perm_prefix.'.'.$event_suffix);
	$this->Application->EmailEventUser($perm_prefix.'.'.$event_suffix, $object->GetDBField('CreatedById'));
	}

	/**
	* Returns current per-page setting for list
	*
	* @param kEvent $event
	* @return int
	*/
	function getPerPage(&$event)
	{
	if (!$this->Application->isAdmin) {
	$event->setEventParam('same_special', true);
	}

	return parent::getPerPage($event);
	}

	/**
	* Set's correct page for list
	* based on data provided with event
	*
	* @param kEvent $event
	* @access private
	* @see OnListBuild
	*/
	function SetPagination(&$event)
	{
	parent::SetPagination($event);

	if ( !$this->Application->isAdmin ) {
	$page_var = $event->getEventParam('page_var');

	if ( $page_var !== false ) {
	$page = $this->Application->GetVar($page_var);

	if ( is_numeric($page) ) {
	$object =& $event->getObject();
	/* @var $object kDBList */

	$object->SetPage($page);
	}
	}
	}
	}

	/**
	* Apply same processing to each item being selected in grid
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function iterateItems(&$event)
	{
	if ( $event->Name != 'OnMassApprove' && $event->Name != 'OnMassDecline' ) {
	parent::iterateItems($event);
	}

	if ( $this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1) ) {
	$event->status = kEvent::erFAIL;
	return;
	}

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

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

	if ( $ids ) {
	$propagate_category_status = $this->Application->GetVar('propagate_category_status');
	$status_field = array_shift( $this->Application->getUnitOption($event->Prefix, 'StatusField') );

	foreach ($ids as $id) {
	$object->Load($id);
	$object->SetDBField($status_field, $event->Name == 'OnMassApprove' ? 1 : 0);

	if ( $object->Update() ) {
	if ( $propagate_category_status ) {
	$sql = 'UPDATE ' . $object->TableName . '
	SET ' . $status_field . ' = ' . $object->GetDBField($status_field) . '
	WHERE TreeLeft BETWEEN ' . $object->GetDBField('TreeLeft') . ' AND ' . $object->GetDBField('TreeRight');
	$this->Conn->Query($sql);
	}

	$event->status = kEvent::erSUCCESS;

	$email_event = $event->Name == 'OnMassApprove' ? 'CATEGORY.APPROVE' : 'CATEGORY.DENY';
	$this->Application->EmailEventUser($email_event, $object->GetDBField('CreatedById'));
	}
	else {
	$event->status = kEvent::erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}

	$this->clearSelectedIDs($event);
	$this->Application->StoreVar('RefreshStructureTree', 1);
	}

	/**
	* Checks, that currently loaded item is allowed for viewing (non permission-based)
	*
	* @param kEvent $event
	* @return bool
	*/
	function checkItemStatus(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	if ( !$object->isLoaded() ) {
	return true;
	}

	if ( $object->GetDBField('Status') != STATUS_ACTIVE && $object->GetDBField('Status') != 4 ) {
	if ( !$object->GetDBField('DirectLinkEnabled') \|\| !$object->GetDBField('DirectLinkAuthKey') ) {
	return false;
	}

	return $this->Application->GetVar('authkey') == $object->GetDBField('DirectLinkAuthKey');
	}

	return true;
	}

	// ============= for cms page processing =======================

	/**
	* Returns default design template
	*
	* @return string
	*/
	function _getDefaultDesign()
	{
	$default_design = trim($this->Application->ConfigValue('cms_DefaultDesign'), '/');

	if (!$default_design) {
	// theme-based alias for default design
	return '#default_design#';
	}

	if (strpos($default_design, '#') === false) {
	// real template, not alias, so prefix with "/"
	return '/' . $default_design;
	}

	// alias
	return $default_design;
	}

	/**
	* Returns default design based on given virtual template (used from kApplication::Run)
	*
	* @param string $t
	* @return string
	* @access public
	*/
	public function GetDesignTemplate($t = null)
	{
	if ( !isset($t) ) {
	$t = $this->Application->GetVar('t');
	}

	$page =& $this->Application->recallObject($this->Prefix . '.-virtual', null, Array ('page' => $t));
	/* @var $page CategoriesItem */

	if ( $page->isLoaded() ) {
	$real_t = $page->GetDBField('CachedTemplate');
	$this->Application->SetVar('m_cat_id', $page->GetDBField('CategoryId'));
	-
	+
	if ( $page->GetDBField('FormId') ) {
	$this->Application->SetVar('form_id', $page->GetDBField('FormId'));
	}
	}
	else {
	$not_found = $this->Application->ConfigValue('ErrorTemplate');
	$real_t = $not_found ? $not_found : 'error_notfound';

	$themes_helper =& $this->Application->recallObject('ThemesHelper');
	/* @var $themes_helper kThemesHelper */

	$theme_id = $this->Application->GetVar('m_theme');
	$category_id = $themes_helper->getPageByTemplate($real_t, $theme_id);
	$this->Application->SetVar('m_cat_id', $category_id);

	header('HTTP/1.0 404 Not Found');
	}

	// replace alias in form #alias_name# to actual template used in this theme
	$theme =& $this->Application->recallObject('theme.current');
	/* @var $theme kDBItem */

	$template = $theme->GetField('TemplateAliases', $real_t);

	if ( $template ) {
	return $template;
	}

	return $real_t;
	}

	/**
	* Sets category id based on found template (used from kApplication::Run)
	*
	* @deprecated
	*/
	/*function SetCatByTemplate()
	{
	$t = $this->Application->GetVar('t');
	$page =& $this->Application->recallObject($this->Prefix . '.-virtual');

	if ($page->isLoaded()) {
	$this->Application->SetVar('m_cat_id', $page->GetDBField('CategoryId') );
	}
	}*/

	/**
	* Prepares template paths
	*
	* @param kEvent $event
	*/
	function _beforeItemChange(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	$now = adodb_mktime();

	if ( !$this->Application->isDebugMode() && strpos($event->Special, 'rebuild') === false ) {
	$object->SetDBField('Type', $object->GetOriginalField('Type'));
	$object->SetDBField('Protected', $object->GetOriginalField('Protected'));

	if ( $object->GetDBField('Protected') ) {
	// some fields are read-only for protected pages, when debug mode is off
	$object->SetDBField('AutomaticFilename', $object->GetOriginalField('AutomaticFilename'));
	$object->SetDBField('Filename', $object->GetOriginalField('Filename'));
	$object->SetDBField('Status', $object->GetOriginalField('Status'));
	}
	}

	if ($object->GetChangedFields()) {
	$object->SetDBField('Modified_date', $now);
	$object->SetDBField('Modified_time', $now);
	}

	$object->setRequired('PageCacheKey', $object->GetDBField('OverridePageCacheKey'));
	$object->SetDBField('Template', $this->_stripTemplateExtension( $object->GetDBField('Template') ));

	if ($object->GetDBField('Type') == PAGE_TYPE_TEMPLATE) {
	if (!$this->_templateFound($object->GetDBField('Template'), $object->GetDBField('ThemeId'))) {
	$object->SetError('Template', 'template_file_missing', 'la_error_TemplateFileMissing');
	}
	}

	$this->_saveTitleField($object, 'Title');
	$this->_saveTitleField($object, 'MenuTitle');

	$root_category = $this->Application->getBaseCategory();

	if ( file_exists(FULL_PATH . '/themes') && ($object->GetDBField('ParentId') == $root_category) && ($object->GetDBField('Template') == CATEGORY_TEMPLATE_INHERIT) ) {
	// there are themes + creating top level category
	$object->SetError('Template', 'no_inherit');
	}

	if ( !$this->Application->isAdminUser && $object->isVirtualField('cust_RssSource') ) {
	// only administrator can set/change "cust_RssSource" field

	if ($object->GetDBField('cust_RssSource') != $object->GetOriginalField('cust_RssSource')) {
	$object->SetError('cust_RssSource', 'not_allowed', 'la_error_OperationNotAllowed');
	}
	}

	if ( !$object->GetDBField('DirectLinkAuthKey') ) {
	$key_parts = Array (
	$object->GetID(),
	$object->GetDBField('ParentId'),
	$object->GetField('Name'),
	'b38'
	);

	$object->SetDBField('DirectLinkAuthKey', substr( md5( implode(':', $key_parts) ), 0, 20 ));
	}
	}

	/**
	* Sets page name to requested field in case when:
	* 1. page was auto created (through theme file rebuld)
	* 2. requested field is emtpy
	*
	* @param kDBItem $object
	* @param string $field
	* @author Alex
	*/
	function _saveTitleField(&$object, $field)
	{
	$value = $object->GetField($field, 'no_default'); // current value of target field

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

	$src_field = $ml_formatter->LangFieldName('Name');
	$dst_field = $ml_formatter->LangFieldName($field);

	$dst_field_not_changed = $object->GetOriginalField($dst_field) == $value;

	if ($value == '' \|\| preg_match('/^_Auto: (.*)/', $value) \|\| (($object->GetOriginalField($src_field) == $value) && $dst_field_not_changed)) {
	// target field is empty OR target field value starts with "_Auto: " OR (source field value
	// before change was equals to current target field value AND target field value wasn't changed)
	$object->SetField($dst_field, $object->GetField($src_field));
	}
	}

	/**
	* Don't allow to delete system pages, when not in debug mode
	*
	* @param kEvent $event
	*/
	function OnBeforeItemDelete(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBItem */

	if ( $object->GetDBField('Protected') && !$this->Application->isDebugMode() ) {
	$event->status = kEvent::erFAIL;
	}
	}

	/**
	* Creates category based on given TPL file
	*
	* @param CategoriesItem $object
	* @param string $template
	* @param int $theme_id
	* @param int $system_mode
	* @param array $template_info
	* @return bool
	*/
	function _prepareAutoPage(&$object, $template, $theme_id = null, $system_mode = SMS_MODE_AUTO, $template_info = Array ())
	{
	$template = $this->_stripTemplateExtension($template);

	if ($system_mode == SMS_MODE_AUTO) {
	$page_type = $this->_templateFound($template, $theme_id) ? PAGE_TYPE_TEMPLATE : PAGE_TYPE_VIRTUAL;
	}
	else {
	$page_type = $system_mode == SMS_MODE_FORCE ? PAGE_TYPE_TEMPLATE : PAGE_TYPE_VIRTUAL;
	}

	if (($page_type == PAGE_TYPE_TEMPLATE) && ($template_info === false)) {
	// do not autocreate system pages, when browsing through site
	return false;
	}

	if (!isset($theme_id)) {
	$theme_id = $this->_getCurrentThemeId();
	}

	$root_category = $this->Application->getBaseCategory();
	$page_category = $this->Application->GetVar('m_cat_id');
	if (!$page_category) {
	$page_category = $root_category;
	$this->Application->SetVar('m_cat_id', $page_category);
	}

	if (($page_type == PAGE_TYPE_VIRTUAL) && (strpos($template, '/') !== false)) {
	// virtual page, but have "/" in template path -> create it's path
	$category_path = explode('/', $template);
	$template = array_pop($category_path);

	$page_category = $this->_getParentCategoryFromPath($category_path, $root_category, $theme_id);
	}

	$page_name = ($page_type == PAGE_TYPE_TEMPLATE) ? '_Auto: ' . $template : $template;
	$page_description = '';

	if ($page_type == PAGE_TYPE_TEMPLATE) {
	$design_template = strtolower($template); // leading "/" not added !
	if ($template_info) {
	if (array_key_exists('name', $template_info) && $template_info['name']) {
	$page_name = $template_info['name'];
	}

	if (array_key_exists('desc', $template_info) && $template_info['desc']) {
	$page_description = $template_info['desc'];
	}

	if (array_key_exists('section', $template_info) && $template_info['section']) {
	// this will override any global "m_cat_id"
	$page_category = $this->_getParentCategoryFromPath(explode('\|\|', $template_info['section']), $root_category, $theme_id);
	}
	}
	}
	else {
	$design_template = $this->_getDefaultDesign(); // leading "/" added !
	}

	$object->Clear();
	$object->SetDBField('ParentId', $page_category);
	$object->SetDBField('Type', $page_type);
	$object->SetDBField('Protected', 1); // $page_type == PAGE_TYPE_TEMPLATE

	$object->SetDBField('IsMenu', 0);
	$object->SetDBField('ThemeId', $theme_id);

	// put all templates to then end of list (in their category)
	$min_priority = $this->_getNextPriority($page_category, $object->TableName);
	$object->SetDBField('Priority', $min_priority);

	$object->SetDBField('Template', $design_template);
	$object->SetDBField('CachedTemplate', $design_template);

	$primary_language = $this->Application->GetDefaultLanguageId();
	$current_language = $this->Application->GetVar('m_lang');
	$object->SetDBField('l' . $primary_language . '_Name', $page_name);
	$object->SetDBField('l' . $current_language . '_Name', $page_name);
	$object->SetDBField('l' . $primary_language . '_Description', $page_description);
	$object->SetDBField('l' . $current_language . '_Description', $page_description);

	return $object->Create();
	}

	function _getParentCategoryFromPath($category_path, $base_category, $theme_id = null)
	{
	static $category_ids = Array ();

	if (!$category_path) {
	return $base_category;
	}

	if (array_key_exists(implode('\|\|', $category_path), $category_ids)) {
	return $category_ids[ implode('\|\|', $category_path) ];
	}

	$backup_category_id = $this->Application->GetVar('m_cat_id');

	$object =& $this->Application->recallObject($this->Prefix . '.rebuild-path', null, Array ('skip_autoload' => true));
	/* @var $object kDBItem */

	$parent_id = $base_category;

	$filenames_helper =& $this->Application->recallObject('FilenamesHelper');
	/* @var $filenames_helper kFilenamesHelper */

	$safe_category_path = array_map(Array (&$filenames_helper, 'replaceSequences'), $category_path);

	foreach ($category_path as $category_order => $category_name) {
	$this->Application->SetVar('m_cat_id', $parent_id);

	// get virtual category first, when possible
	$sql = 'SELECT ' . $object->IDField . '
	FROM ' . $object->TableName . '
	WHERE
	(
	Filename = ' . $this->Conn->qstr($safe_category_path[$category_order]) . ' OR
	Filename = ' . $this->Conn->qstr( $filenames_helper->replaceSequences('_Auto: ' . $category_name) ) . '
	) AND
	(ParentId = ' . $parent_id . ') AND
	(ThemeId = 0 OR ThemeId = ' . $theme_id . ')
	ORDER BY ThemeId ASC';
	$parent_id = $this->Conn->GetOne($sql);

	if ($parent_id === false) {
	// page not found
	$template = implode('/', array_slice($safe_category_path, 0, $category_order + 1));

	// don't process system templates in sub-categories
	$system = $this->_templateFound($template, $theme_id) && (strpos($template, '/') === false);

	if (!$this->_prepareAutoPage($object, $category_name, $theme_id, $system ? SMS_MODE_FORCE : false)) {
	// page was not created
	break;
	}

	$parent_id = $object->GetID();
	}
	}

	$this->Application->SetVar('m_cat_id', $backup_category_id);
	$category_ids[ implode('\|\|', $category_path) ] = $parent_id;

	return $parent_id;
	}

	/**
	* Returns theme name by it's id. Used in structure page creation.
	*
	* @param int $theme_id
	* @return string
	*/
	function _getThemeName($theme_id)
	{
	static $themes = null;

	if (!isset($themes)) {
	$id_field = $this->Application->getUnitOption('theme', 'IDField');
	$table_name = $this->Application->getUnitOption('theme', 'TableName');

	$sql = 'SELECT Name, ' . $id_field . '
	FROM ' . $table_name . '
	WHERE Enabled = 1';
	$themes = $this->Conn->GetCol($sql, $id_field);
	}

	return array_key_exists($theme_id, $themes) ? $themes[$theme_id] : false;
	}

	/**
	* Resets SMS-menu cache
	*
	* @param kEvent $event
	*/
	function OnResetCMSMenuCache(&$event)
	{
	if ($this->Application->GetVar('ajax') == 'yes') {
	$event->status = kEvent::erSTOP;
	}

	$this->_resetMenuCache();
	}

	function _resetMenuCache()
	{
	// reset cms menu cache (all variables are automatically rebuild, when missing)
	if ($this->Application->isCachingType(CACHING_TYPE_MEMORY)) {
	$this->Application->rebuildCache('master:cms_menu', kCache::REBUILD_LATER, CacheSettings::$cmsMenuRebuildTime);
	$this->Application->rebuildCache('master:StructureTree', kCache::REBUILD_LATER, CacheSettings::$structureTreeRebuildTime);
	$this->Application->rebuildCache('master:template_mapping', kCache::REBUILD_LATER, CacheSettings::$templateMappingRebuildTime);
	}
	else {
	$this->Application->rebuildDBCache('cms_menu', kCache::REBUILD_LATER, CacheSettings::$cmsMenuRebuildTime);
	$this->Application->rebuildDBCache('StructureTree', kCache::REBUILD_LATER, CacheSettings::$structureTreeRebuildTime);
	$this->Application->rebuildDBCache('template_mapping', kCache::REBUILD_LATER, CacheSettings::$templateMappingRebuildTime);
	}
	}

	/**
	* Updates structure config
	*
	* @param kEvent $event
	*/
	function OnAfterConfigRead(&$event)
	{
	parent::OnAfterConfigRead($event);

	if (defined('IS_INSTALL') && IS_INSTALL) {
	// skip any processing, because Category table doesn't exists until install is finished
	return ;
	}

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

	$settings = $site_config_helper->getSettings();

	$root_category = $this->Application->getBaseCategory();

	// set root category
	$section_ajustments = $this->Application->getUnitOption($event->Prefix, 'SectionAdjustments');

	$section_ajustments['in-portal:browse'] = Array (
	'url' => Array ('m_cat_id' => $root_category),
	'late_load' => Array ('m_cat_id' => $root_category),
	'onclick' => 'checkCatalog(' . $root_category . ')',
	);

	$section_ajustments['in-portal:browse_site'] = Array (
	'url' => Array ('editing_mode' => $settings['default_editing_mode']),
	);

	$this->Application->setUnitOption($event->Prefix, 'SectionAdjustments', $section_ajustments);

	// prepare structure dropdown
	$category_helper =& $this->Application->recallObject('CategoryHelper');
	/* @var $category_helper CategoryHelper */

	$fields = $this->Application->getUnitOption($event->Prefix, 'Fields');

	$fields['ParentId']['default'] = (int)$this->Application->GetVar('m_cat_id');
	$fields['ParentId']['options'] = $category_helper->getStructureTreeAsOptions();

	// limit design list by theme
	$design_folders = Array ('tf.FilePath = "/designs"', 'tf.FilePath = "/platform/designs"');
	foreach ($this->Application->ModuleInfo as $module_name => $module_info) {
	$design_folders[] = 'tf.FilePath = "/' . $module_info['TemplatePath'] . 'designs"';
	}
	$design_folders = array_unique($design_folders);

	$theme_id = $this->_getCurrentThemeId();
	$design_sql = $fields['Template']['options_sql'];
	$design_sql = str_replace('(tf.FilePath = "/designs")', '(' . implode(' OR ', $design_folders) . ')' . ' AND (t.ThemeId = ' . $theme_id . ')', $design_sql);
	$fields['Template']['options_sql'] = $design_sql;

	// adds "Inherit From Parent" option to "Template" field
	$fields['Template']['options'] = Array (CATEGORY_TEMPLATE_INHERIT => $this->Application->Phrase('la_opt_InheritFromParent'));

	$this->Application->setUnitOption($event->Prefix, 'Fields', $fields);

	if ($this->Application->isAdmin) {
	// don't sort by Front-End sorting fields
	$config_mapping = $this->Application->getUnitOption($event->Prefix, 'ConfigMapping');
	$remove_keys = Array ('DefaultSorting1Field', 'DefaultSorting2Field', 'DefaultSorting1Dir', 'DefaultSorting2Dir');
	foreach ($remove_keys as $remove_key) {
	unset($config_mapping[$remove_key]);
	}
	$this->Application->setUnitOption($event->Prefix, 'ConfigMapping', $config_mapping);
	}
	else {
	// sort by parent path on Front-End only
	$list_sortings = $this->Application->getUnitOption($event->Prefix, 'ListSortings', Array ());
	$list_sortings['']['ForcedSorting'] = Array ("CurrentSort" => 'asc');
	$this->Application->setUnitOption($event->Prefix, 'ListSortings', $list_sortings);
	}

	// add grids for advanced view (with primary category column)
	$grids = $this->Application->getUnitOption($this->Prefix, 'Grids');
	$process_grids = Array ('Default', 'Radio');
	foreach ($process_grids as $process_grid) {
	$grid_data = $grids[$process_grid];
	$grid_data['Fields']['CachedNavbar'] = Array ('title' => 'la_col_Path', 'data_block' => 'grid_parent_category_td', 'filter_block' => 'grid_like_filter');
	$grids[$process_grid . 'ShowAll'] = $grid_data;
	}
	$this->Application->setUnitOption($this->Prefix, 'Grids', $grids);
	}

	/**
	* Removes this item and it's children (recursive) from structure dropdown
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterItemLoad(&$event)
	{
	parent::OnAfterItemLoad($event);

	if ( !$this->Application->isAdmin ) {
	// calculate priorities dropdown only for admin
	- return ;
	+ return;
	}

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

	// remove this category & it's children from dropdown
	$sql = 'SELECT ' . $object->IDField . '
	FROM ' . $this->Application->getUnitOption($event->Prefix, 'TableName') . '
	WHERE ParentPath LIKE "' . $object->GetDBField('ParentPath') . '%"';
	$remove_categories = $this->Conn->GetCol($sql);

	- $field_options = $object->GetFieldOptions('ParentId');
	+ $options = $object->GetFieldOption('ParentId', 'options');
	foreach ($remove_categories as $remove_category) {
	- unset($field_options['options'][$remove_category]);
	+ unset($options[$remove_category]);
	}
	- $object->SetFieldOptions('ParentId', $field_options);
	-
	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- $priority_helper->preparePriorities($event, false, 'ParentId = ' . $object->GetDBField('ParentId'));
	-
	- // storing priority right after load for comparing when updating
	- $object->SetDBField('OldPriority', $object->GetDBField('Priority'));
	- }
	-
	- /**
	- * Builds list
	- *
	- * @param kEvent $event
	- * @access protected
	- */
	- function OnListBuild(&$event)
	- {
	- parent::OnListBuild($event);
	-
	- if (!$this->Application->isAdminUser) {
	- return ;
	- }
	-
	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- $priority_helper->preparePriorities($event, false, 'ParentId = '.$this->Application->GetVar('m_cat_id'));
	+ $object->SetFieldOption('ParentId', 'options', $options);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnAfterRebuildThemes(&$event)
	{
	$sql = 'SELECT t.ThemeId, CONCAT( tf.FilePath, \'/\', tf.FileName ) AS Path, tf.FileMetaInfo
	FROM '.TABLE_PREFIX.'ThemeFiles AS tf
	LEFT JOIN '.TABLE_PREFIX.'Theme AS t ON t.ThemeId = tf.ThemeId
	WHERE t.Enabled = 1 AND tf.FileType = 1
	AND (
	SELECT COUNT(CategoryId)
	FROM ' . TABLE_PREFIX . 'Category c
	WHERE CONCAT(\'/\', c.Template, \'.tpl\') = CONCAT( tf.FilePath, \'/\', tf.FileName ) AND (c.ThemeId = t.ThemeId)
	) = 0 ';
	$files = $this->Conn->Query($sql, 'Path');
	if (!$files) {
	// all possible pages are already created
	return ;
	}

	set_time_limit(0);
	ini_set('memory_limit', -1);

	$dummy =& $this->Application->recallObject($event->Prefix . '.rebuild', null, Array ('skip_autoload' => true));
	/* @var $dummy kDBItem */

	$error_count = 0;
	foreach ($files as $a_file => $file_info) {
	$status = $this->_prepareAutoPage($dummy, $a_file, $file_info['ThemeId'], SMS_MODE_FORCE, unserialize($file_info['FileMetaInfo'])); // create system page
	if (!$status) {
	$error_count++;
	}
	}

	if ($this->Application->ConfigValue('QuickCategoryPermissionRebuild')) {
	$updater =& $this->Application->makeClass('kPermCacheUpdater');
	/* @var $updater kPermCacheUpdater */

	$updater->OneStepRun();
	}

	$this->_resetMenuCache();

	if ($error_count) {
	// allow user to review error after structure page creation
	$event->MasterEvent->redirect = false;
	}
	}

	/**
	* Processes OnMassMoveUp, OnMassMoveDown events
	*
	* @param kEvent $event
	*/
	function OnChangePriority(&$event)
	{
	- if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	- $event->status = kEvent::erFAIL;
	- return;
	- }
	-
	- $object =& $event->getObject( Array('skip_autoload' => true) );
	- $ids = $this->StoreSelectedIDs($event);
	-
	- if ($ids) {
	- $id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	- $table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	- $parent_id = $this->Application->GetVar('m_cat_id');
	-
	- $sql = 'SELECT Priority, '.$id_field.'
	- FROM '.$table_name.'
	- WHERE '.$id_field.' IN ('.implode(',', $ids).')';
	- $priorities = $this->Conn->GetCol($sql, $id_field);
	-
	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	-
	- foreach ($ids as $id) {
	- $new_priority = $priorities[$id] + ($event->Name == 'OnMassMoveUp' ? +1 : -1);
	-
	- $changes = Array (
	- $id => Array ('old' => $priorities[$id], 'new' => $new_priority, 'parent' => $parent_id),
	- );
	-
	- $sql = 'UPDATE '.$table_name.'
	- SET Priority = '.$new_priority.'
	- WHERE '.$id_field.' = '.$id;
	- $this->Conn->Query($sql);
	-
	- $priority_helper->updatePriorities($event, $changes, Array ($id => $id));
	- }
	- }
	+ $this->Application->SetVar('priority_prefix', $event->getPrefixSpecial());
	+ $event->CallSubEvent('priority:' . $event->Name);

	- $this->clearSelectedIDs($event);
	$this->Application->StoreVar('RefreshStructureTree', 1);
	$this->_resetMenuCache();
	}

	/**
	* Completely recalculates priorities in current category
	*
	* @param kEvent $event
	*/
	function OnRecalculatePriorities(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = kEvent::erFAIL;
	return;
	}

	- $priority_helper =& $this->Application->recallObject('PriorityHelper');
	- /* @var $priority_helper kPriorityHelper */
	+ $this->Application->SetVar('priority_prefix', $event->getPrefixSpecial());
	+ $event->CallSubEvent('priority:' . $event->Name);

	- $parent_id = $this->Application->GetVar('m_cat_id');
	- $priority_helper->recalculatePriorities($event, 'ParentId = ' . $parent_id);
	$this->_resetMenuCache();
	}

	/**
	* Update Preview Block for FCKEditor
	*
	* @param kEvent $event
	*/
	function OnUpdatePreviewBlock(&$event)
	{
	$event->status = kEvent::erSTOP;
	$string = kUtil::unhtmlentities($this->Application->GetVar('preview_content'));

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

	$string = $category_helper->replacePageIds($string);

	$this->Application->StoreVar('_editor_preview_content_', $string);
	}

	/**
	* Makes simple search for categories
	* based on keywords string
	*
	* @param kEvent $event
	*/
	function OnSimpleSearch(&$event)
	{
	$event->redirect = false;
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';

	$keywords = kUtil::unhtmlentities( trim($this->Application->GetVar('keywords')) );

	$query_object =& $this->Application->recallObject('HTTPQuery');
	/* @var $query_object kHTTPQuery */
	-
	+
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';

	if ( !isset($query_object->Get['keywords']) && !isset($query_object->Post['keywords']) && $this->Conn->Query($sql) ) {
	// used when navigating by pages or changing sorting in search results
	return;
	}

	if(!$keywords \|\| strlen($keywords) < $this->Application->ConfigValue('Search_MinKeyword_Length'))
	{
	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table);
	$this->Application->SetVar('keywords_too_short', 1);
	return; // if no or too short keyword entered, doing nothing
	}

	$this->Application->StoreVar('keywords', $keywords);

	$this->saveToSearchLog($keywords, 0); // 0 - simple search, 1 - advanced search

	$keywords = strtr($keywords, Array('%' => '\\%', '_' => '\\_'));

	$event->setPseudoClass('_List');

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

	$this->Application->SetVar($event->getPrefixSpecial().'_Page', 1);
	$lang = $this->Application->GetVar('m_lang');
	$items_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$module_name = 'In-Portal';

	$sql = 'SELECT *
	FROM ' . $this->Application->getUnitOption('confs', 'TableName') . '
	WHERE ModuleName = ' . $this->Conn->qstr($module_name) . ' AND SimpleSearch = 1';
	$search_config = $this->Conn->Query($sql, 'FieldName');

	$field_list = array_keys($search_config);

	$join_clauses = Array();

	// field processing
	$weight_sum = 0;

	$alias_counter = 0;

	$custom_fields = $this->Application->getUnitOption($event->Prefix, 'CustomFields');
	if ($custom_fields) {
	$custom_table = $this->Application->getUnitOption($event->Prefix.'-cdata', 'TableName');
	$join_clauses[] = ' LEFT JOIN '.$custom_table.' custom_data ON '.$items_table.'.ResourceId = custom_data.ResourceId';
	}

	// what field in search config becomes what field in sql (key - new field, value - old field (from searchconfig table))
	$search_config_map = Array();

	foreach ($field_list as $key => $field) {
	$local_table = TABLE_PREFIX.$search_config[$field]['TableName'];
	$weight_sum += $search_config[$field]['Priority']; // counting weight sum; used when making relevance clause

	// processing multilingual fields
	if ( $object->GetFieldOption($field, 'formatter') == 'kMultiLanguage' ) {
	$field_list[$key.'_primary'] = 'l'.$this->Application->GetDefaultLanguageId().'_'.$field;
	$field_list[$key] = 'l'.$lang.'_'.$field;

	if (!isset($search_config[$field]['ForeignField'])) {
	$field_list[$key.'_primary'] = $local_table.'.'.$field_list[$key.'_primary'];
	$search_config_map[ $field_list[$key.'_primary'] ] = $field;
	}
	}

	// processing fields from other tables
	if ($foreign_field = $search_config[$field]['ForeignField']) {
	$exploded = explode(':', $foreign_field, 2);
	if ($exploded[0] == 'CALC') {
	// ignoring having type clauses in simple search
	unset($field_list[$key]);
	continue;
	}
	else {
	$multi_lingual = false;
	if ($exploded[0] == 'MULTI') {
	$multi_lingual = true;
	$foreign_field = $exploded[1];
	}

	$exploded = explode('.', $foreign_field); // format: table.field_name
	$foreign_table = TABLE_PREFIX.$exploded[0];

	$alias_counter++;
	$alias = 't'.$alias_counter;

	if ($multi_lingual) {
	$field_list[$key] = $alias.'.'.'l'.$lang.'_'.$exploded[1];
	$field_list[$key.'_primary'] = 'l'.$this->Application->GetDefaultLanguageId().'_'.$field;
	$search_config_map[ $field_list[$key] ] = $field;
	$search_config_map[ $field_list[$key.'_primary'] ] = $field;
	}
	else {
	$field_list[$key] = $alias.'.'.$exploded[1];
	$search_config_map[ $field_list[$key] ] = $field;
	}

	$join_clause = str_replace('{ForeignTable}', $alias, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $items_table, $join_clause);

	$join_clauses[] = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else {
	// processing fields from local table
	if ($search_config[$field]['CustomFieldId']) {
	$local_table = 'custom_data';

	// search by custom field value on current language
	$custom_field_id = array_search($field_list[$key], $custom_fields);
	$field_list[$key] = 'l'.$lang.'_cust_'.$custom_field_id;

	// search by custom field value on primary language
	$field_list[$key.'_primary'] = $local_table.'.l'.$this->Application->GetDefaultLanguageId().'_cust_'.$custom_field_id;
	$search_config_map[ $field_list[$key.'_primary'] ] = $field;
	}

	$field_list[$key] = $local_table.'.'.$field_list[$key];
	$search_config_map[ $field_list[$key] ] = $field;
	}
	}

	// keyword string processing
	$search_helper =& $this->Application->recallObject('SearchHelper');
	/* @var $search_helper kSearchHelper */

	$where_clause = Array ();
	foreach ($field_list as $field) {
	if (preg_match('/^' . preg_quote($items_table, '/') . '\.(.*)/', $field, $regs)) {
	// local real field
	$filter_data = $search_helper->getSearchClause($object, $regs[1], $keywords, false);
	if ($filter_data) {
	$where_clause[] = $filter_data['value'];
	}
	}
	elseif (preg_match('/^custom_data\.(.*)/', $field, $regs)) {
	$custom_field_name = 'cust_' . $search_config_map[$field];
	$filter_data = $search_helper->getSearchClause($object, $custom_field_name, $keywords, false);
	if ($filter_data) {
	$where_clause[] = str_replace('`' . $custom_field_name . '`', $field, $filter_data['value']);
	}
	}
	else {
	$where_clause[] = $search_helper->buildWhereClause($keywords, Array ($field));
	}
	}

	$where_clause = '((' . implode(') OR (', $where_clause) . '))'; // 2 braces for next clauses, see below!

	$where_clause = $where_clause . ' AND (' . $items_table . '.Status = ' . STATUS_ACTIVE . ')';

	if ($event->MasterEvent && $event->MasterEvent->Name == 'OnListBuild') {
	if ($event->MasterEvent->getEventParam('ResultIds')) {
	$where_clause .= ' AND '.$items_table.'.ResourceId IN ('.implode(',', $event->MasterEvent->getEventParam('ResultIds')).')';
	}
	}

	// exclude template based sections from search results (ie. registration)
	if ( $this->Application->ConfigValue('ExcludeTemplateSectionsFromSearch') ) {
	$where_clause .= ' AND ' . $items_table . '.ThemeId = 0';
	}

	// making relevance clause
	$positive_words = $search_helper->getPositiveKeywords($keywords);
	$this->Application->StoreVar('highlight_keywords', serialize($positive_words));
	$revelance_parts = Array();
	reset($search_config);

	foreach ($positive_words as $keyword_index => $positive_word) {
	$positive_word = $search_helper->transformWildcards($positive_word);
	$positive_words[$keyword_index] = $this->Conn->escape($positive_word);
	}

	foreach ($field_list as $field) {

	if (!array_key_exists($field, $search_config_map)) {
	$map_key = $search_config_map[$items_table . '.' . $field];
	}
	else {
	$map_key = $search_config_map[$field];
	}

	$config_elem = $search_config[ $map_key ];
	$weight = $config_elem['Priority'];

	// search by whole words only ([[:<:]] - word boundary)
	/*$revelance_parts[] = 'IF('.$field.' REGEXP "[[:<:]]('.implode(' ', $positive_words).')[[:>:]]", '.$weight.', 0)';
	foreach ($positive_words as $keyword) {
	$revelance_parts[] = 'IF('.$field.' REGEXP "[[:<:]]('.$keyword.')[[:>:]]", '.$weight.', 0)';
	}*/

	// search by partial word matches too
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.implode(' ', $positive_words).'%", '.$weight_sum.', 0)';
	foreach ($positive_words as $keyword) {
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.$keyword.'%", '.$weight.', 0)';
	}
	}

	$revelance_parts = array_unique($revelance_parts);

	$conf_postfix = $this->Application->getUnitOption($event->Prefix, 'SearchConfigPostfix');
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_'.$conf_postfix) / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_'.$conf_postfix) / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_'.$conf_postfix) / 100;
	$relevance_clause = '('.implode(' + ', $revelance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	if ($rel_pop && $object->isField('Hits')) {
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	}
	if ($rel_rating && $object->isField('CachedRating')) {
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;
	}

	// building final search query
	if (!$this->Application->GetVar('do_not_drop_search_table')) {
	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table); // erase old search table if clean k4 event
	$this->Application->SetVar('do_not_drop_search_table', true);
	}


	$search_table_exists = $this->Conn->Query('SHOW TABLES LIKE "'.$search_table.'"');
	if ($search_table_exists) {
	$select_intro = 'INSERT INTO '.$search_table.' (Relevance, ItemId, ResourceId, ItemType, EdPick) ';
	}
	else {
	$select_intro = 'CREATE TABLE '.$search_table.' AS ';
	}

	$edpick_clause = $this->Application->getUnitOption($event->Prefix.'.EditorsPick', 'Fields') ? $items_table.'.EditorsPick' : '0';


	$sql = $select_intro.' SELECT '.$relevance_clause.' AS Relevance,
	'.$items_table.'.'.$this->Application->getUnitOption($event->Prefix, 'IDField').' AS ItemId,
	'.$items_table.'.ResourceId,
	'.$this->Application->getUnitOption($event->Prefix, 'ItemType').' AS ItemType,
	'.$edpick_clause.' AS EdPick
	FROM '.$object->TableName.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$items_table.'.'.$this->Application->getUnitOption($event->Prefix, 'IDField').' ORDER BY Relevance DESC';

	$res = $this->Conn->Query($sql);

	if ( !$search_table_exists ) {
	$sql = 'ALTER TABLE ' . $search_table . '
	ADD INDEX (ResourceId),
	ADD INDEX (Relevance)';
	$this->Conn->Query($sql);
	}
	}

	/**
	* Make record to search log
	*
	* @param string $keywords
	* @param int $search_type 0 - simple search, 1 - advanced search
	*/
	function saveToSearchLog($keywords, $search_type = 0)
	{
	// don't save keywords for each module separately, just one time
	// static variable can't help here, because each module uses it's own class instance !
	if (!$this->Application->GetVar('search_logged')) {
	$sql = 'UPDATE '.TABLE_PREFIX.'SearchLog
	SET Indices = Indices + 1
	WHERE Keyword = '.$this->Conn->qstr($keywords).' AND SearchType = '.$search_type; // 0 - simple search, 1 - advanced search
	$this->Conn->Query($sql);
	if ($this->Conn->getAffectedRows() == 0) {
	$fields_hash = Array('Keyword' => $keywords, 'Indices' => 1, 'SearchType' => $search_type);
	$this->Conn->doInsert($fields_hash, TABLE_PREFIX.'SearchLog');
	}

	$this->Application->SetVar('search_logged', 1);
	}
	}

	/**
	* Load item if id is available
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function LoadItem(&$event)
	{
	if ( $event->Special != '-virtual' ) {
	parent::LoadItem($event);
	return;
	}

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

	$id = $this->getPassedID($event);

	if ( $object->isLoaded() && !is_array($id) && ($object->GetID() == $id) ) {
	// object is already loaded by same id
	return;
	}

	if ( $object->Load($id, null, true) ) {
	$actions =& $this->Application->recallObject('kActions');
	/* @var $actions Params */

	$actions->Set($event->getPrefixSpecial() . '_id', $object->GetID());
	}
	else {
	$object->setID($id);
	}
	}
	+
	+ /**
	+ * Returns constrain for priority calculations
	+ *
	+ * @param kEvent $event
	+ * @return void
	+ * @see PriorityEventHandler
	+ * @access protected
	+ */
	+ protected function OnGetConstrainInfo(&$event)
	+ {
	+ $contarain = ''; // for OnSave
	+
	+ $event_name = $event->getEventParam('original_event');
	+ $actual_event_name = $event->getEventParam('actual_event');
	+
	+ if ( $actual_event_name == 'OnSavePriorityChanges' \|\| $event_name == 'OnAfterItemLoad' \|\| $event_name == 'OnAfterItemDelete' ) {
	+ $object =& $event->getObject();
	+ /* @var $object kDBItem */
	+
	+ $contarain = 'ParentId = ' . $object->GetDBField('ParentId');
	+ }
	+ elseif ( $actual_event_name == 'OnPreparePriorities' ) {
	+ $contarain = 'ParentId = ' . $this->Application->GetVar('m_cat_id');
	+ }
	+ elseif ( $event_name == 'OnSave' ) {
	+ $contarain = '';
	+ }
	+ else {
	+ $contarain = 'ParentId = ' . $this->Application->GetVar('m_cat_id');
	+ }
	+
	+ $event->setEventParam('constrain_info', Array ($contarain, ''));
	+ }
	}
	\ No newline at end of file
	Index: branches/5.2.x/core/units/helpers/priority_helper.php
	===================================================================
	--- branches/5.2.x/core/units/helpers/priority_helper.php (revision 14609)
	+++ branches/5.2.x/core/units/helpers/priority_helper.php (revision 14610)
	@@ -1,178 +1,245 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @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 kPriorityHelper extends kHelper {

	-
	/**
	* Prepares options for priority dropdown
	*
	* @param kEvent $event
	* @param bool $is_new for newly created items add new priority to the end
	* @param string $constrain constrain for priority selection (if any)
	+ * @param string $joins left joins, used by constrain (if any)
	*
	*/
	- function preparePriorities(&$event, $is_new = false, $constrain = '')
	+ function preparePriorities(&$event, $is_new = false, $constrain = '', $joins = '')
	{
	$object =& $event->getObject();
	+ /* @var $object kDBItem */

	$field_options = $object->GetFieldOptions('Priority');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');

	$sql = 'SELECT COUNT(*)
	- FROM '.$table_name;
	- if ($constrain) {
	- $sql .= ' WHERE '.$constrain;
	+ FROM ' . $table_name . ' item_table
	+ ' . $joins;
	+
	+ if ( $constrain ) {
	+ $sql .= ' WHERE ' . $this->normalizeConstrain($constrain);
	}

	if ( !$object->isField('OldPriority') ) {
	// make sure, then OldPriority field is defined
	$virtual_fields = $object->getVirtualFields();
	- $virtual_fields['OldPriority'] = Array('type' => 'int', 'default' => 0);
	+ $virtual_fields['OldPriority'] = Array ('type' => 'int', 'default' => 0);
	$object->setVirtualFields($virtual_fields);
	}

	$items_count = $this->Conn->GetOne($sql);
	+ $current_priority = $object instanceof kDBList ? 0 : $object->GetDBField('Priority');

	- // instanceof is not used, because PHP4 doesn't support it
	- $current_priority = is_a($object, 'kDBList') ? 0 : $object->GetDBField('Priority');
	-
	- if ($is_new \|\| $current_priority == -($items_count+1)) {
	+ if ( $is_new \|\| $current_priority == -($items_count + 1) ) {
	$items_count++;
	}

	- if ($is_new) {
	+ if ( $is_new ) {
	// add new item to the end of list
	$object->SetDBField('Priority', -$items_count);
	$object->SetDBField('OldPriority', -$items_count);
	}
	else {
	+ // storing priority right after load for comparing when updating
	$object->SetDBField('OldPriority', $current_priority);
	}

	for ($i = 1; $i <= $items_count; $i++) {
	$field_options['options'][-$i] = $i;
	}

	$object->SetFieldOptions('Priority', $field_options);
	- // storing prioriry right after load for comparing when updating
	}

	/**
	* Updates priorities for changed items
	*
	* @param kEvent $event
	- * @param Array $changes = Array (ID => Array ('parent' => ..., 'new' => ..., 'old' => ...), ...)
	+ * @param Array $changes = Array (ID => Array ('constrain' => ..., 'new' => ..., 'old' => ...), ...)
	* @param Array $new_ids = Array (temp_id => live_id)
	* @param string $constrain
	+ * @param string $joins
	+ * @return Array
	*/
	- function updatePriorities(&$event, $changes, $new_ids, $constrain = '')
	+ function updatePriorities(&$event, $changes, $new_ids, $constrain = '', $joins = '')
	{
	- if (!$changes) {
	+ // TODO: no need pass external $constrain, since the one from $pair is used
	+
	+ if ( !$changes ) {
	// no changes to process
	return Array ();
	}
	+
	list ($id, $pair) = each($changes);

	- if (!$id && !array_key_exists('parent', $pair)) {
	+ if ( !$id && !isset($pair['constrain']) ) {
	// adding new item without constrain -> priority stays the same
	return Array ($id);
	}

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

	- $ids = array();
	+ if ( $this->Application->IsTempMode($event->Prefix, $event->Special) ) {
	+ $table_name = $this->Application->GetTempName($table_name, 'prefix:' . $event->Prefix);
	+ }
	+
	+ $ids = Array ();
	$not_processed = array_keys($changes);

	foreach ($changes as $id => $pair) {
	array_push($ids, $id);
	- $constrain = isset($pair['parent']) ? 'ParentId = '.$pair['parent'].' AND ' : '';
	+ $constrain = isset($pair['constrain']) ? $this->normalizeConstrain($pair['constrain']) . ' AND ' : '';

	- if ($pair['old'] == 'new') {
	+ if ( $pair['old'] == 'new' ) {
	// replace 0 with newly created item id (from $new_ids mapping)
	- $not_processed[ array_search($id, $not_processed) ] = $new_ids[$id];
	+ $not_processed[array_search($id, $not_processed)] = $new_ids[$id];
	$id = $new_ids[$id];

	- $sql = 'SELECT MIN(Priority)
	- FROM '.$table_name.'
	- WHERE '.$constrain.' '.$id_field.' NOT IN ('.implode(',', $not_processed).')';
	+ $sql = 'SELECT MIN(item_table.Priority)
	+ FROM ' . $table_name . ' item_table
	+ ' . $joins . '
	+ WHERE ' . $constrain . ' item_table.' . $id_field . ' NOT IN (' . implode(',', $not_processed) . ')';
	$min_priority = (int)$this->Conn->GetOne($sql) - 1;

	- if ($pair['new'] < $min_priority) {
	+ if ( $pair['new'] < $min_priority ) {
	$pair['new'] = $min_priority;
	}
	+
	$pair['old'] = $min_priority;
	}

	- if ($pair['new'] < $pair['old']) {
	- $set = ' SET Priority = Priority + 1';
	- $where =' WHERE '.$constrain.'
	- Priority >= '.$pair['new'].'
	+ if ( $pair['new'] < $pair['old'] ) {
	+ $set = ' SET item_table.Priority = item_table.Priority + 1';
	+ $where = ' WHERE ' . $constrain . '
	+ item_table.Priority >= ' . $pair['new'] . '
	AND
	- Priority < '.$pair['old'].'
	+ item_table.Priority < ' . $pair['old'] . '
	AND
	- '.$id_field.' NOT IN ('.implode(',', $not_processed).')';
	+ ' . $id_field . ' NOT IN (' . implode(',', $not_processed) . ')';
	}
	- elseif ($pair['new'] > $pair['old']) {
	- $set = ' SET Priority = Priority - 1';
	- $where =' WHERE '.$constrain.'
	- Priority > '.$pair['old'].'
	+ elseif ( $pair['new'] > $pair['old'] ) {
	+ $set = ' SET item_table.Priority = item_table.Priority - 1';
	+ $where = ' WHERE ' . $constrain . '
	+ item_table.Priority > ' . $pair['old'] . '
	AND
	- Priority <= '.$pair['new'].'
	+ item_table.Priority <= ' . $pair['new'] . '
	AND
	- '.$id_field.' NOT IN ('.implode(',', $not_processed).')';
	+ ' . $id_field . ' NOT IN (' . implode(',', $not_processed) . ')';
	}
	else {
	- $set = 'SET Priority = '.$pair['new'];
	- $where = ' WHERE '.$id_field.' = '.$id;
	+ $set = ' SET item_table.Priority = ' . $pair['new'];
	+ $where = ' WHERE ' . $id_field . ' = ' . $id;
	}
	- $ids = array_merge($ids, $this->Conn->GetCol('SELECT '.$id_field.' FROM '.$table_name.$where));
	- $q = 'UPDATE '.$table_name.' '.$set.$where;
	+
	+ $sql = 'SELECT item_table.' . $id_field . '
	+ FROM ' . $table_name . ' item_table
	+ ' . $joins . '
	+ ' . $where;
	+ $ids = array_merge($ids, $this->Conn->GetCol($sql));
	+
	+ $q = 'UPDATE ' . $table_name . ' item_table
	+ ' . $joins . '
	+ ' . $set . $where;
	$this->Conn->Query($q);

	- unset( $not_processed[array_search($id, $not_processed)] );
	+ unset($not_processed[array_search($id, $not_processed)]);
	}
	+
	return $ids;
	}

	/**
	* Recalculates priorities
	*
	* @param kEvent $event
	* @param string $constrain
	+ * @param string $joins
	+ * @return Array
	*/
	- function recalculatePriorities(&$event, $constrain = '')
	+ function recalculatePriorities(&$event, $constrain = '', $joins = '')
	{
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	+ $constrain = $this->normalizeConstrain($constrain);

	- $sql = 'SELECT '.$id_field.'
	- FROM '.$table_name.
	- ($constrain ? ' WHERE '.$constrain : '').'
	- ORDER BY Priority DESC';
	+ if ( $this->Application->IsTempMode($event->Prefix, $event->Special) ) {
	+ $table_name = $this->Application->GetTempName($table_name, 'prefix:' . $event->Prefix);
	+ }

	+ $sql = 'SELECT ' . $id_field . '
	+ FROM ' . $table_name . ' item_table ' .
	+ $joins . ' ' .
	+ ($constrain ? ' WHERE ' . $constrain : '') . '
	+ ORDER BY item_table.Priority DESC';
	$items = $this->Conn->GetCol($sql);

	foreach ($items as $item_number => $item_id) {
	- $sql = 'UPDATE '.$table_name.'
	- SET Priority = '.-($item_number + 1).'
	- WHERE '.$id_field.' = '.$item_id;
	+ $sql = 'UPDATE ' . $table_name . '
	+ SET Priority = ' . -($item_number + 1) . '
	+ WHERE ' . $id_field . ' = ' . $item_id;
	$this->Conn->Query($sql);
	}
	+
	return $items;
	}
	+
	+ /**
	+ * Adds current table name into constrain if doesn't have it already (to prevent ambiguous columns during joins)
	+ *
	+ * @param string $constrain
	+ * @return string
	+ */
	+ function normalizeConstrain($constrain)
	+ {
	+ if ( strpos($constrain, '.') === false ) {
	+ return 'item_table.' . $constrain;
	+ }
	+
	+ return $constrain;
	+ }
	+
	+ /**
	+ * Performs fake kDBItem::Update call, so any OnBefore/OnAfter events would be notified of priority change
	+ *
	+ * @param string $prefix
	+ * @param Array $ids
	+ */
	+ function massUpdateChanged($prefix, $ids)
	+ {
	+ $ids = array_unique($ids);
	+
	+ $dummy =& $this->Application->recallObject($prefix . '.-dummy', null, Array ('skip_autoload' => true));
	+ /* @var $dummy kDBItem */
	+
	+ $sql = $dummy->GetSelectSQL() . '
	+ WHERE ' . $dummy->TableName . '.' . $dummy->IDField . ' IN (' . implode(',', $ids) . ')';
	+ $records = $this->Conn->Query($sql);
	+
	+ foreach ($records as $record) {
	+ $dummy->LoadFromHash($record);
	+ $dummy->Update();
	+ }
	+ }
	}
	\ No newline at end of file

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options