in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Jul 20, 6:29 AM

in-portal
View Options

This file is larger than 256 KB, so syntax highlighting was skipped.

	Index: trunk/kernel/units/admin/admin_tag_processor.php
	===================================================================
	--- trunk/kernel/units/admin/admin_tag_processor.php (revision 4841)
	+++ trunk/kernel/units/admin/admin_tag_processor.php (revision 4842)
	@@ -1,335 +1,335 @@
	<?php

	class AdminTagProcessor extends kDBTagProcessor {

	function SetConst($params)
	{
	$name = $this->SelectParam($params, 'name,const');
	safeDefine($name, $params['value']);
	}

	/**
	* Allows to execute js script after the page is fully loaded
	*
	* @param Array $params
	* @return string
	*/
	function AfterScript($params)
	{
	$after_script = $this->Application->GetVar('after_script');
	if ($after_script) {
	return '<script type="text/javascript">'.$after_script.'</script>';
	}
	return '';
	}

	/**
	* Returns section title with #section# keyword replaced with current section
	*
	* @param Array $params
	* @return string
	*/
	function GetSectionTitle($params)
	{
	$params['name'] = replaceModuleSection($params['phrase']);
	return $this->Application->ProcessParsedTag('m', 'Phrase', $params);
	}

	/**
	* Returns section icon with #section# keyword replaced with current section
	*
	* @param Array $params
	* @return string
	*/
	function GetSectionIcon($params)
	{
	return replaceModuleSection($params['icon']);
	}

	/**
	* Allows to detect if current template is one of listed ones
	*
	* @param Array $params
	* @return int
	*/
	function TemplateMatches($params)
	{
	$templates = explode(',' ,$params['templates']);
	$t = $this->Application->GetVar('t');
	return in_array($t, $templates) ? 1 : 0;
	}

	/**
	* Save return script in cases, when old sections are opened from new sections
	*
	* @param Array $params
	*/
	function SaveReturnScript($params)
	{
	// admin/save_redirect.php?do=
	$url = str_replace($this->Application->BaseURL(), '', $this->Application->ProcessParsedTag('m', 'Link', $params) );
	$url = explode('?', $url, 2);
	$url = 'save_redirect.php?'.$url[1].'&do='.$url[0];

	$this->Application->StoreVar('ReturnScript', $url);
	}

	/**
	* Redirects to correct next import step template based on import script data
	*
	* @param Array $params
	*/
	function ImportRedirect($params)
	{
	$import_id = $this->Application->GetVar('import_id');
	if ($import_id) {
	// redirect forward to step3 (import parameters coosing)
	$this->Application->StoreVar('ImportScriptID', $import_id);

	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'ImportScripts
	WHERE is_id = '.$import_id;

	$db =& $this->Application->GetADODBConnection();
	$is_params = $db->GetRow($sql);

	if ($is_params['is_type'] == 'db') {
	$this->Application->Redirect('', null, '', 'import/step3.php');
	}
	elseif ($is_params['is_type'] == 'csv') {
	$module = strtolower($is_params['is_Module']);
	$template = $module.'/import';
	- $sql = 'SELECT Var
	- FROM '.TABLE_PREFIX.'Modules
	- WHERE LOWER(Name) = '.$db->qstr($module);
	- $item_prefix = $db->GetOne($sql);
	- $pass_params = Array('m_opener' => 'd', $item_prefix.'.import_id' => 0, $item_prefix.'.import_event' => 'OnNew', 'pass' => 'm,'.$item_prefix.'.import');
	+ $module_info = $this->Application->findModule('Name', $module);
	+
	+ $item_prefix = $module_info['Var'];
	+ $pass_params = Array('m_opener' => 'd', $item_prefix.'.import_id' => 0, $item_prefix.'.import_event' => 'OnNew', 'pass' => 'm,'.$item_prefix.'.import', 'm_cat_id' => $module_info['RootCat']);
	+
	$this->Application->Redirect($template, $pass_params);
	}
	}
	else {
	// redirect back to step2 (import type choosing)
	$this->Application->Redirect('', null, '', 'import/step2.php');
	}
	}

	/**
	* Returns version of module by name
	*
	* @param Array $params
	* @return string
	*/
	function ModuleVersion($params)
	{
	return $this->Application->findModule('Name', $params['module'], 'Version');
	}

	/**
	* Used in table form section drawing
	*
	* @param Array $params
	* @return string
	*/
	function DrawTree($params)
	{
	static $deep_level = 0;

	// when processings, then sort children by priority (key of children array)
	$ret = '';
	$section_name = $params['section_name'];
	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['children_count'] = isset($section_data['children']) ? count($section_data['children']) : 0;
	$params['deep_level'] = $deep_level++;
	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);
	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);
	$ret .= $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );
	if (!isset($section_data['children'])) {
	return $ret;
	}

	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $section_name) {
	$params['section_name'] = $section_name;
	$ret .= $this->DrawTree($params);
	$deep_level--;
	}


	return $ret;
	}


	function PrintSection($params)
	{
	$section_name = $params['section_name'];
	if ($section_name == '#session#') {
	$section_name = $this->Application->RecallVar('section');
	}

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	$params['section_name'] = $section_name;

	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);

	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);
	$ret = $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );

	return $ret;
	}

	/**
	* Used in XML drawing for tree
	*
	* @param Array $params
	* @return string
	*/
	function PrintSections($params)
	{
	// when processings, then sort children by priority (key of children array)
	$ret = '';
	$section_name = $params['section_name'];
	if ($section_name == '#session#') {
	$section_name = $this->Application->RecallVar('section');
	}

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	if (!isset($section_data['children'])) {
	return '';
	}

	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $section_name) {
	$params['section_name'] = $section_name;
	$section_data =& $sections_helper->getSectionData($section_name);

	if (isset($section_data['tabs_only']) && $section_data['tabs_only']) {
	$perm_status = false;
	$folder_label = $section_data['label'];
	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $priority => $section_name) {
	$perm_status = $this->Application->CheckPermission($section_name.'.view', 1);
	if ($perm_status) {
	break;
	}
	}
	if (!$perm_status) {
	// no permission for all tabs -> don't display tree node either
	continue;
	}

	$params['section_name'] = $section_name;
	$section_data =& $sections_helper->getSectionData($section_name);
	$section_data['label'] = $folder_label; // use folder label in tree
	$section_data['is_tab'] = 1;
	}
	elseif (!$this->Application->CheckPermission($section_name.'.view', 1)) {
	continue;
	}

	$params['children_count'] = isset($section_data['children']) ? count($section_data['children']) : 0;

	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);

	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);

	$late_load = getArrayValue($section_data, 'late_load');
	if ($late_load) {
	$t = $late_load['t'];
	unset($late_load['t']);
	$section_data['late_load'] = $this->Application->HREF($t, '', $late_load);
	$params['children_count'] = 99;
	}
	else {
	$section_data['late_load'] = '';
	}

	$ret .= $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );
	$params['section_name'] = $section_name;
	}

	return preg_replace("/\r\n\|\n/", '', $ret);
	}

	function ListSectionPermissions($params)
	{
	$section_name = isset($params['section_name']) ? $params['section_name'] : $this->Application->GetVar('section_name');
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$block_params = array_merge_recursive2($section_data, Array('name' => $params['render_as'], 'section_name' => $section_name));

	$ret = '';
	foreach ($section_data['permissions'] as $perm_name) {
	if (preg_match('/^advanced:(.*)/', $perm_name) != $params['type']) continue;
	$block_params['perm_name'] = $perm_name;
	$ret .= $this->Application->ParseBlock($block_params);
	}
	return $ret;
	}

	function ModuleInclude($params)
	{
	foreach ($params as $param_name => $param_value) {
	$params[$param_name] = replaceModuleSection($param_value);
	}

	return $this->Application->ProcessParsedTag('m', 'ModuleInclude', $params);
	}

	function TodayDate($params)
	{
	return date($params['format']);
	}

	function TreeEditWarrning($params)
	{
	$ret = $this->Application->Phrase($params['label']);
	$ret = str_replace(Array('<', '>', 'br/', 'br /', "\n", "\r"), Array('<', '>', 'br', 'br', '', ''), $ret);
	if (getArrayValue($params, 'escape')) {
	$ret = addslashes($ret);
	}
	$ret = str_replace('<br>', '\n', $ret);
	return $ret;
	}

	/**
	* Draws section tabs using block name passed
	*
	* @param Array $params
	*/
	function ListTabs($params)
	{
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($params['section_name']);

	$ret = '';
	$block_params = Array('name' => $params['render_as']);
	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $priority => $section_name) {
	// if (!$this->Application->CheckPermission($section_name.'.view', 1)) continue;

	$tab_data =& $sections_helper->getSectionData($section_name);
	$block_params['t'] = $tab_data['url']['t'];
	$block_params['title'] = $tab_data['label'];
	$block_params['main_prefix'] = $section_data['SectionPrefix'];
	$ret .= $this->Application->ParseBlock($block_params);
	}


	return $ret;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/admin/admin_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.16
	\ No newline at end of property
	+1.17
	\ No newline at end of property
	Index: trunk/kernel/units/custom_fields/custom_fields_event_handler.php
	===================================================================
	--- trunk/kernel/units/custom_fields/custom_fields_event_handler.php (revision 4841)
	+++ trunk/kernel/units/custom_fields/custom_fields_event_handler.php (revision 4842)
	@@ -1,145 +1,143 @@
	<?php
	class CustomFieldsEventHandler extends InpDBEventHandler {

	/**
	* Changes permission section to one from REQUEST, not from config
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	$sql = 'SELECT Prefix
	FROM '.TABLE_PREFIX.'ItemTypes
	WHERE ItemType = '.$this->Conn->qstr( $this->Application->GetVar('cf_type') );
	$main_prefix = $this->Conn->GetOne($sql);

	$section = $this->Application->getUnitOption($main_prefix.'.custom', 'PermSection');
	$event->setEventParam('PermSection', $section);
	return parent::CheckPermission($event);
	-
	-
	}

	/**
	* Apply any custom changes to list's sql query
	*
	* @param kEvent $event
	* @access protected
	* @see OnListBuild
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();

	$item_type = $this->Application->GetVar('cf_type');
	if (!$item_type) {
	$prefix = $event->getEventParam('SourcePrefix');
	$item_type = $this->Application->getUnitOption($prefix, 'ItemType');
	}

	if ($event->Special == 'general') {
	$object->addFilter('generaltab_filter', '%1$s.OnGeneralTab = 1');
	}

	if ($item_type) {
	$object->addFilter('itemtype_filter', '%1$s.Type = '.$item_type);
	}

	if (!$this->Application->IsAdmin()) {
	$object->addFilter('user_filter', '%1$s.IsSystem = 0');
	}
	}

	/**
	* Prevents from duplicate item creation
	*
	* @param kEvent $event
	*/
	function OnBeforeItemCreate(&$event)
	{
	$object =& $event->getObject();

	$live_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT COUNT(*)
	FROM '.$live_table.'
	WHERE FieldName = '.$this->Conn->qstr($object->GetDBField('FieldName')).' AND Type = '.$object->GetDBField('Type');
	$found = $this->Conn->GetOne($sql);

	if ($found) {
	$event->status = erFAIL;
	$object->SetError('FieldName', 'duplicate', 'la_error_CustomExists');
	}
	}

	/**
	* Occurse after deleting item, id of deleted item
	* is stored as 'id' param of event
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemDelete(&$event)
	{
	$object =& $event->getObject();
	$main_prefix = $this->getPrefixByItemType($object->GetDBField('Type'));

	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	$ml_helper->deleteField($main_prefix.'-cdata', $event->getEventParam('id'));
	}

	/**
	* Get config prefix based on item type
	*
	* @param unknown_type $item_type
	* @return unknown
	*/
	function getPrefixByItemType($item_type)
	{
	$sql = 'SELECT Prefix
	FROM '.TABLE_PREFIX.'ItemTypes
	WHERE ItemType = '.$item_type;
	return $this->Conn->GetOne($sql);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSaveCustomField(&$event)
	{
	if ($event->MasterEvent->status != erSUCCESS) {
	return false;
	}

	$object =& $event->getObject();
	$main_prefix = $this->getPrefixByItemType($object->GetDBField('Type'));

	$this->Application->HandleEvent( new kEvent($main_prefix.'-cdata:OnCreateCustomFields') );

	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	$ml_helper->createFields($main_prefix.'-cdata');
	}

	function OnMassDelete(&$event)
	{
	parent::OnMassDelete($event);
	$event->redirect_params = Array('opener' => 's');
	}

	/**
	* Prepare temp tables for creating new item
	* but does not create it. Actual create is
	* done in OnPreSaveCreated
	*
	* @param kEvent $event
	*/
	function OnPreCreate(&$event)
	{
	parent::OnPreCreate($event);

	$object =& $event->getObject();
	$object->SetDBField('Type', $this->Application->GetVar('cf_type'));
	}
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/custom_fields/custom_fields_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.13
	\ No newline at end of property
	+1.14
	\ No newline at end of property
	Index: trunk/kernel/units/general/cat_event_handler.php
	===================================================================
	--- trunk/kernel/units/general/cat_event_handler.php (revision 4841)
	+++ trunk/kernel/units/general/cat_event_handler.php (revision 4842)
	@@ -1,1757 +1,1757 @@
	<?php

	$application =& kApplication::Instance();
	$application->Factory->includeClassFile('kDBEventHandler');

	class kCatDBEventHandler extends InpDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnExport' => Array('self' => 'view\|advanced:export'),
	'OnExportBegin' => Array('self' => 'view\|advanced:export'),
	'OnSaveSettings' => Array('self' => 'add\|edit\|advanced:import'),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Checks permissions of user
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	if (!$this->Application->IsAdmin()) {
	if ($event->Name == 'OnSetSortingDirect') {
	// allow sorting on front event without view permission
	return true;
	}
	}

	-
	if ($event->Name == 'OnExport') {
	// save category_id before doing export
	$this->Application->LinkVar('m_cat_id');
	}

	if ($event->Name == 'OnNew' && preg_match('/(.*)\/import$/', $this->Application->GetVar('t'), $rets)) {
	// redirect to item import template, where permission (import) category will be chosen)
	- $this->Application->StoreVar('m_cat_id', $this->Application->findModule('Path', $rets[1].'/', 'RootCat'));
	+ $root_category = $this->Application->findModule('Path', $rets[1].'/', 'RootCat');
	+ $this->Application->StoreVar('m_cat_id', $root_category);
	}

	return parent::CheckPermission($event);
	}

	function OnCopy(&$event)
	{
	$object = $event->getObject();
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard', implode(',', $ids));
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard_mode', 'copy');

	$this->Application->StoreVar('ClipBoard', 'COPY-0.'.$object->TableName.'.ResourceId=0');
	$event->redirect_params = Array('opener' => 's', 'pass_events'=>true); //do not go up - STAY
	}

	function OnCut(&$event)
	{
	$object = $event->getObject();
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard', implode(',', $ids));
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard_mode', 'cut');

	$this->Application->StoreVar('ClipBoard', 'CUT-0.'.$object->TableName.'.ResourceId=0');
	$event->redirect_params = Array('opener' => 's', 'pass_events'=>true); //do not go up - STAY
	}

	function OnPaste(&$event)
	{
	$ids = $this->Application->RecallVar($event->getPrefixSpecial().'_clipboard');
	if ($ids == '') {
	$event->redirect = false;
	return;
	}

	$ids_arr = explode(',', $ids);

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

	if ($ids_arr) {
	$temp->CloneItems($event->Prefix, $event->Special, $ids_arr);
	}
	}
	else { // mode == cut
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'.item', $event->Prefix, Array('skip_autoload' => true));

	foreach ($ids_arr as $id) {
	$object->Load($id);
	$object->MoveToCat();
	}
	}
	$event->status = erSUCCESS;
	}

	/**
	* 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';


	$this->Application->setUnitOption($event->Prefix,'AutoLoad', false);
	$object =& $this->Application->recallObject($event->Prefix.'.item', $event->Prefix);

	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->setUnitOption($event->Prefix,'AutoLoad', true);
	$this->Application->SetVar('m_cat_id', $saved_cat_id);
	}
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndOpenTranslator(&$event)
	{
	$this->Application->SetVar('allow_translation', true);
	$object =& $event->getObject();
	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');

	if ($event->status == 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));
	$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');
	$event->redirect_params = Array('pass'=>'all,trans,'.$this->Application->GetVar('translator_prefixes'),
	$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'),
	);

	// 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'));
	}
	}

	/**
	* Return type clauses for list bulding on front
	*
	* @param kEvent $event
	* @return Array
	*/
	function getTypeClauses(&$event)
	{
	$types = $event->getEventParam('types');
	$except_types = $event->getEventParam('except');
	$type_clauses = Array();

	$type_clauses['pick']['include'] = '%1$s.EditorsPick = 1 AND '.TABLE_PREFIX.'CategoryItems.PrimaryCat = 1';
	$type_clauses['pick']['except'] = '%1$s.EditorsPick! = 1 AND '.TABLE_PREFIX.'CategoryItems.PrimaryCat = 1';
	$type_clauses['pick']['having_filter'] = false;

	$type_clauses['hot']['include'] = '`IsHot` = 1 AND PrimaryCat = 1';
	$type_clauses['hot']['except'] = '`IsHot`! = 1 AND PrimaryCat = 1';
	$type_clauses['hot']['having_filter'] = true;

	$type_clauses['pop']['include'] = '`IsPop` = 1 AND PrimaryCat = 1';
	$type_clauses['pop']['except'] = '`IsPop`! = 1 AND PrimaryCat = 1';
	$type_clauses['pop']['having_filter'] = true;

	$type_clauses['new']['include'] = '`IsNew` = 1 AND PrimaryCat = 1';
	$type_clauses['new']['except'] = '`IsNew`! = 1 AND PrimaryCat = 1';
	$type_clauses['new']['having_filter'] = true;

	$type_clauses['displayed']['include'] = '';
	$displayed = $this->Application->GetVar($event->Prefix.'_displayed_ids');
	if ($displayed) {
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$type_clauses['displayed']['except'] = '%1$s.'.$id_field.' NOT IN ('.$displayed.')';
	}
	else {
	$type_clauses['displayed']['except'] = '';
	}
	$type_clauses['displayed']['having_filter'] = false;

	if (strpos($types, 'search') !== false \|\| strpos($except_types, 'search') !== false) {
	$event_mapping = Array(
	'simple' => 'OnSimpleSearch',
	'subsearch' => 'OnSubSearch',
	'advanced' => 'OnAdvancedSearch');
	if($this->Application->GetVar('INPORTAL_ON') && $this->Application->GetVar('Action') == 'm_simple_subsearch')
	{
	$type = 'subsearch';
	}
	else
	{
	$type = $this->Application->GetVar('search_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);
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';
	if ( $this->Conn->Query($sql) ) {
	$search_res_ids = $this->Conn->GetCol('SELECT ResourceId FROM '.$search_table);
	}

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

	if (strpos($types, 'related') !== false \|\| strpos($except_types, 'related') !== false) {

	$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 = $this->Application->getUnitOption($event->Prefix, 'ItemType');

	$p_item =& $this->Application->recallObject($related_prefix.'.current', null, Array('skip_autoload' => true));
	$p_item->Load( $this->Application->GetVar($related_prefix.'_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).') AND PrimaryCat = 1';
	$type_clauses['related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_ids).') AND PrimaryCat = 1';
	}
	else {
	$type_clauses['related']['include'] = '0';
	$type_clauses['related']['except'] = '1';
	}
	$type_clauses['related']['having_filter'] = false;
	}

	return $type_clauses;
	}

	/**
	* Apply filters to list
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

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

	// add category filter if needed
	if ($event->Special != 'showall') {
	if ( $event->getEventParam('parent_cat_id') ) {
	$parent_cat_id = $event->getEventParam('parent_cat_id');
	}
	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 ((string) $parent_cat_id != 'any') {
	if ($event->getEventParam('recursive')) {
	$current_path = $this->Conn->GetOne('SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId='.$parent_cat_id);
	$subcats = $this->Conn->GetCol('SELECT CategoryId FROM '.TABLE_PREFIX.'Category WHERE ParentPath LIKE "'.$current_path.'%" ');
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.CategoryId IN ('.implode(', ', $subcats).')');
	}
	else {
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.CategoryId = '.$parent_cat_id );
	}
	}
	}
	else {
	$object->addFilter('primary_filter', 'PrimaryCat = 1');
	}

	// add permission filter
	$view_perm = 1;
	$object->addFilter('perm_filter', 'perm.PermId = '.$view_perm);

	if ( !$this->Application->IsAdmin() )
	{
	$groups = explode( ',', $this->Application->RecallVar('UserGroups') );
	foreach($groups as $group)
	{
	$view_filters[] = 'FIND_IN_SET('.$group.', perm.acl) \|\| ((NOT FIND_IN_SET('.$group.',perm.dacl)) AND perm.acl=\'\')';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	$object->addFilter('status_filter', $object->TableName.'.Status = 1');
	}

	$types = $event->getEventParam('types');
	$except_types = $event->getEventParam('except');
	$type_clauses = $this->getTypeClauses($event);

	// convert prepared type clauses into list filters
	$includes_or_filter =& $this->Application->makeClass('kMultipleFilter');
	$includes_or_filter->setType(FLT_TYPE_OR);

	$excepts_and_filter =& $this->Application->makeClass('kMultipleFilter');
	$excepts_and_filter->setType(FLT_TYPE_AND);

	$includes_or_filter_h =& $this->Application->makeClass('kMultipleFilter');
	$includes_or_filter_h->setType(FLT_TYPE_OR);

	$excepts_and_filter_h =& $this->Application->makeClass('kMultipleFilter');
	$excepts_and_filter_h->setType(FLT_TYPE_AND);

	$except_types_array = explode(',', $types);

	if ($types) {
	$types_array = explode(',', $types);
	for ($i = 0; $i < sizeof($types_array); $i++) {
	$type = trim($types_array[$i]);
	if (isset($type_clauses[$type])) {
	if ($type_clauses[$type]['having_filter']) {
	$includes_or_filter_h->removeFilter('filter_'.$type);
	$includes_or_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['include']);
	}else {
	$includes_or_filter->removeFilter('filter_'.$type);
	$includes_or_filter->addFilter('filter_'.$type, $type_clauses[$type]['include']);
	}
	}
	}
	}

	if ($except_types) {
	$except_types_array = explode(',', $except_types);
	for ($i = 0; $i < sizeof($except_types_array); $i++) {
	$type = trim($except_types_array[$i]);
	if (isset($type_clauses[$type])) {
	if ($type_clauses[$type]['having_filter']) {
	$excepts_and_filter_h->removeFilter('filter_'.$type);
	$excepts_and_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['except']);
	}else {
	$excepts_and_filter->removeFilter('filter_'.$type);
	$excepts_and_filter->addFilter('filter_'.$type, $type_clauses[$type]['except']);
	}
	}
	}
	}

	/*if ( !$this->Application->IsAdmin() ) {
	$object->addFilter('expire_filter', '%1$s.Expire IS NULL OR %1$s.Expire > UNIX_TIMESTAMP()');
	}*/

	/*$list_type = $event->getEventParam('ListType');
	switch($list_type)
	{
	case 'favorites':
	$fav_table = $this->Application->getUnitOption('fav','TableName');
	$user_id =& $this->Application->GetVar('u_id');

	$sql = 'SELECT DISTINCT f.ResourceId
	FROM '.$fav_table.' f
	LEFT JOIN '.$object->TableName.' p ON p.ResourceId = f.ResourceId
	WHERE f.PortalUserId = '.$user_id;
	$ids = $this->Conn->GetCol($sql);
	if(!$ids) $ids = Array(-1);
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.PrimaryCat = 1');
	$object->addFilter('favorites_filter', '%1$s.`ResourceId` IN ('.implode(',',$ids).')');
	break;
	case 'search':
	$search_results_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = ' SELECT DISTINCT ResourceId
	FROM '.$search_results_table.'
	WHERE ItemType=11';
	$ids = $this->Conn->GetCol($sql);
	if(!$ids) $ids = Array(-1);
	$object->addFilter('search_filter', '%1$s.`ResourceId` IN ('.implode(',',$ids).')');
	break;
	} */

	$object->addFilter('includes_filter', $includes_or_filter);
	$object->addFilter('excepts_filter', $excepts_and_filter);

	$object->addFilter('includes_filter_h', $includes_or_filter_h, HAVING_FILTER);
	$object->addFilter('excepts_filter_h', $excepts_and_filter_h, HAVING_FILTER);
	}

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function prepareObject(&$object, &$event)
	{
	$this->prepareItemStatuses($event);

	if ($event->Special == 'export' \|\| $event->Special == 'import')
	{
	$this->prepareExportColumns($event);
	}
	}

	/**
	* Creates calculated fields for all item statuses based on config settings
	*
	* @param kEvent $event
	*/
	function prepareItemStatuses(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');

	$new_days_var = getArrayValue($property_mappings, 'NewDays');
	if($new_days_var)
	{
	$object->addCalculatedField('IsNew', ' IF(%1$s.NewItem = 2,
	IF(%1$s.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue($new_days_var).
	'360024), 1, 0),
	%1$s.NewItem
	)');
	}

	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');
	if($hot_limit_var)
	{
	$sql = 'SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName = "'.$hot_limit_var.'"';
	$hot_limit = $this->Conn->GetOne($sql);
	if($hot_limit === false) $hot_limit = $this->CalculateHotLimit($event);
	$object->addCalculatedField('IsHot', ' IF(%1$s.HotItem = 2,
	IF(%1$s.Hits >= '.$hot_limit.', 1, 0),
	%1$s.HotItem
	)');
	}

	$votes2pop_var = getArrayValue($property_mappings, 'VotesToPop');
	$rating2pop_var = getArrayValue($property_mappings, 'RatingToPop');

	if($votes2pop_var && $rating2pop_var)
	{
	$object->addCalculatedField('IsPop', ' IF(%1$s.PopItem = 2,
	IF(%1$s.CachedVotesQty >= '.
	$this->Application->ConfigValue($votes2pop_var).
	' AND %1$s.CachedRating >= '.
	$this->Application->ConfigValue($rating2pop_var).
	', 1, 0),
	%1$s.PopItem)');
	}
	}

	function CalculateHotLimit(&$event)
	{
	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	$hot_count_var = getArrayValue($property_mappings, 'HotCount');
	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');

	if($hot_count_var && $hot_limit_var)
	{
	$last_hot = $this->Application->ConfigValue($hot_count_var) - 1;
	$sql = 'SELECT Hits FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	ORDER BY Hits DESC
	LIMIT '.$last_hot.', 1';
	$res = $this->Conn->GetCol($sql);
	$hot_limit = (double)array_shift($res);
	$this->Conn->Query('REPLACE INTO '.TABLE_PREFIX.'Cache VALUES ("'.$hot_limit_var.'", "'.$hot_limit.'", '.adodb_mktime().')');
	return $hot_limit;
	}
	return 0;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	if( $this->Application->IsAdmin() && ($this->Application->GetVar('Hits_original') !== false) &&
	floor($this->Application->GetVar('Hits_original')) != $object->GetDBField('Hits') )
	{
	$sql = 'SELECT MAX(Hits) FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	WHERE FLOOR(Hits) = '.$object->GetDBField('Hits');
	$hits = ( $res = $this->Conn->GetOne($sql) ) ? $res + 0.000001 : $object->GetDBField('Hits');
	$object->SetDBField('Hits', $hits);
	}
	}

	/**
	* Load price from temp table if product mode is temp table
	*
	* @param kEvent $event
	*/
	function OnAfterItemLoad(&$event)
	{
	$special = substr($event->Special, -6);
	if ($special == 'import' \|\| $special == 'export') {
	$object =& $event->getObject();
	$image_data = $object->getPrimaryImageData();

	if ($image_data) {
	$thumbnail_image = $image_data[$image_data['LocalThumb'] ? 'ThumbPath' : 'ThumbUrl'];
	if ($image_data['SameImages']) {
	$full_image = '';
	}
	else {
	$full_image = $image_data[$image_data['LocalImage'] ? 'LocalPath' : 'Url'];
	}
	$object->SetDBField('ThumbnailImage', $thumbnail_image);
	$object->SetDBField('FullImage', $full_image);
	$object->SetDBField('ImageAlt', $image_data['AltName']);
	}
	}

	}

	function OnAfterItemUpdate(&$event)
	{
	$this->CalculateHotLimit($event);

	if ( substr($event->Special, -6) == 'import') {
	$this->setCustomExportColumns($event);
	}
	}

	/**
	* sets values for import process
	*
	* @param kEvent $event
	*/
	function OnAfterItemCreate(&$event)
	{
	if ( substr($event->Special, -6) == 'import') {
	$this->setCustomExportColumns($event);
	}
	}

	/**
	* Make record to search log
	*
	* @param string $keywords
	* @param int $search_type 0 - simple search, 1 - advanced search
	*/
	function saveToSearchLog($keywords, $search_type = 0)
	{
	$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');
	}
	}

	/**
	* Makes simple search for products
	* based on keywords string
	*
	* @param kEvent $event
	* @todo Change all hardcoded Products table & In-Commerce module usage to dynamic usage from item config !!!
	*/
	function OnSimpleSearch(&$event)
	{
	if($this->Application->GetVar('INPORTAL_ON') && !($this->Application->GetVar('Action') == 'm_simple_search'))
	{
	return;
	}

	$event->redirect = false;
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';

	$keywords = unhtmlentities( trim($this->Application->GetVar('keywords')) );

	$query_object =& $this->Application->recallObject('HTTPQuery');
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';

	if(!isset($query_object->Get['keywords']) &&
	!isset($query_object->Post['keywords']) &&
	$this->Conn->Query($sql))
	{
	return; // used when navigating by pages or changing sorting in search results
	}
	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);
	if (!$this->Application->GetVar('INPORTAL_ON')) {
	// don't save search log, because in-portal already saved it
	$this->saveToSearchLog($keywords, 0); // 0 - simple search, 1 - advanced search
	}


	$keywords = strtr($keywords, Array('%' => '\\%', '_' => '\\_'));

	$event->setPseudoClass('_List');
	$object =& $event->getObject();
	$this->Application->SetVar($event->getPrefixSpecial().'_Page', 1);
	$lang = $this->Application->GetVar('m_lang');
	$product_table = $this->Application->getUnitOption('p', 'TableName');

	$sql = ' SELECT * FROM '.$this->Application->getUnitOption('confs', 'TableName').'
	WHERE ModuleName="In-Commerce"
	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 '.$product_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) {
	$options = $object->getFieldOptions($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 (getArrayValue($options, 'formatter') == 'kMultiLanguage') {
	$field_list[$key] = 'l'.$lang.'_'.$field;
	}

	// processing fields from other tables
	if($foreign_field = $search_config[$field]['ForeignField'])
	{
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	unset($field_list[$key]);
	continue; // ignoring having type clauses in simple search
	/*$user_object =& $this->Application->recallObject('u');
	$user_groups = $this->Application->RecallVar('UserGroups');
	$having_list[$key] = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;
	$join_clauses[] = $join_clause;*/
	}
	else
	{
	$exploded = explode('.', $foreign_field); // format: table.field_name
	$foreign_table = TABLE_PREFIX.$exploded[0];

	$alias_counter++;
	$alias = 't'.$alias_counter;

	$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}', $product_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';
	$field_list[$key] = 'l'.$lang.'_cust_'.array_search($field_list[$key], $custom_fields);
	}
	$field_list[$key] = $local_table.'.'.$field_list[$key];
	$search_config_map[ $field_list[$key] ] = $field;
	}
	}

	// keyword string processing
	$search_helper =& $this->Application->recallObject('SearchHelper');
	$where_clause = $search_helper->buildWhereClause($keywords, $field_list);

	$where_clause = $where_clause.' AND '.$product_table.'.Status=1';

	if($this->Application->GetVar('Action') == 'm_simple_subsearch') // subsearch, In-portal
	{
	if( $event->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$product_table.'.ResourceId IN ('.implode(',', $event->specificParams['ResultIds']).')';
	}
	}
	if( $event->MasterEvent && $event->MasterEvent->Name == 'OnListBuild' ) // subsearch, k4
	{
	if( $event->MasterEvent->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$product_table.'.ResourceId IN ('.implode(',', $event->MasterEvent->getEventParam('ResultIds')).')';
	}
	}

	// making relevance clause
	$positive_words = $search_helper->getPositiveKeywords($keywords);
	$this->Application->StoreVar('highlight_keywords', serialize($positive_words));
	$revelance_parts = Array();
	reset($search_config);
	foreach ($field_list as $field) {
	$config_elem = each($search_config);
	$weight = $search_config[ $search_config_map[$field] ]['Priority'];
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.implode(' ', $positive_words).'%", '.$weight_sum.', 0)';
	foreach ($positive_words as $keyword) {
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.$keyword.'%", '.$config_elem['value']['Priority'].', 0)';
	}
	}
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_products') / 100;
	$relevance_clause = '('.implode(' + ', $revelance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;

	// building final search query
	if (!$this->Application->GetVar('INPORTAL_ON')) {
	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table); // erase old search table if clean k4 event
	}

	if ($this->Conn->Query('SHOW TABLES LIKE "'.$search_table.'"')) {
	$select_intro = 'INSERT INTO '.$search_table.' (Relevance, ItemId, ResourceId, ItemType, EdPick) ';
	}
	else {
	$select_intro = 'CREATE TABLE '.$search_table.' AS ';
	}

	$sql = $select_intro.' SELECT '.$relevance_clause.' AS Relevance,
	'.$product_table.'.ProductId AS ItemId,
	'.$product_table.'.ResourceId,
	11 AS ItemType,
	'.$product_table.'.EditorsPick AS EdPick
	FROM '.$object->TableName.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$product_table.'.ProductId';

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSubSearch(&$event)
	{
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';
	if($this->Conn->Query($sql))
	{
	$sql = 'SELECT DISTINCT ResourceId FROM '.$search_table;
	$ids = $this->Conn->GetCol($sql);
	}
	$event->setEventParam('ResultIds', $ids);
	$event->CallSubEvent('OnSimpleSearch');
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @todo Change all hardcoded Products table & In-Commerce module usage to dynamic usage from item config !!!
	*/
	function OnAdvancedSearch(&$event)
	{
	$query_object =& $this->Application->recallObject('HTTPQuery');
	if(!isset($query_object->Post['andor']))
	{
	return; // used when navigating by pages or changing sorting in search results
	}

	$this->Application->RemoveVar('keywords');
	$this->Application->RemoveVar('Search_Keywords');

	$sql = ' SELECT * FROM '.$this->Application->getUnitOption('confs', 'TableName').'
	WHERE ModuleName="In-Commerce"
	AND AdvancedSearch=1';
	$search_config = $this->Conn->Query($sql);
	$lang = $this->Application->GetVar('m_lang');
	$object =& $event->getObject();
	$object->SetPage(1);
	$user_object =& $this->Application->recallObject('u');
	$product_table = $this->Application->getUnitOption('p', 'TableName');

	$search_keywords = $this->Application->GetVar('value'); // will not be changed

	$keywords = $this->Application->GetVar('value'); // will be changed down there
	$verbs = $this->Application->GetVar('verb');
	$glues = $this->Application->GetVar('andor');

	$and_conditions = Array();
	$or_conditions = Array();
	$and_having_conditions = Array();
	$or_having_conditions = Array();
	$join_clauses = Array();
	$highlight_keywords = Array();
	$relevance_parts = Array();

	$condition_patterns = Array( 'any' => '%s LIKE %s',
	'contains' => '%s LIKE %s',
	'notcontains' => '(NOT (%1$s LIKE %2$s) OR %1$s IS NULL)',
	'is' => '%s = %s',
	'isnot' => '(%1$s != %2$s OR %1$s IS NULL)');

	$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 '.$product_table.'.ResourceId = custom_data.ResourceId';
	}

	$search_log = '';
	$weight_sum = 0;
	// processing fields and preparing conditions
	foreach($search_config as $record)
	{
	$field = $record['FieldName'];
	$join_clause = '';
	$condition_mode = 'WHERE';

	// field processing

	$options = $object->getFieldOptions($field);
	$local_table = TABLE_PREFIX.$record['TableName'];
	$weight_sum += $record['Priority']; // counting weight sum; used when making relevance clause

	// processing multilingual fields
	if (getArrayValue($options, 'formatter') == 'kMultiLanguage') {
	$field_name = 'l'.$lang.'_'.$field;
	}
	else {
	$field_name = $field;
	}

	// processing fields from other tables
	if ($foreign_field = $record['ForeignField']) {
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	$user_groups = $this->Application->RecallVar('UserGroups');
	$field_name = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $record['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;

	$condition_mode = 'HAVING';
	}
	else {
	$exploded = explode('.', $foreign_field);
	$foreign_table = TABLE_PREFIX.$exploded[0];

	if($record['CustomFieldId']) {
	$exploded[1] = 'l'.$lang.'_'.$exploded[1];
	}

	$alias_counter++;
	$alias = 't'.$alias_counter;

	$field_name = $alias.'.'.$exploded[1];
	$join_clause = str_replace('{ForeignTable}', $alias, $record['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $product_table, $join_clause);

	if($record['CustomFieldId'])
	{
	$join_clause .= ' AND '.$alias.'.CustomFieldId='.$record['CustomFieldId'];
	}
	$join_clause = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else
	{
	// processing fields from local table
	if ($record['CustomFieldId']) {
	$local_table = 'custom_data';
	$field_name = 'l'.$lang.'_cust_'.array_search($field_name, $custom_fields);
	}

	$field_name = $local_table.'.'.$field_name;
	}

	$condition = '';
	switch($record['FieldType'])
	{
	case 'text':
	$keywords[$field] = unhtmlentities( $keywords[$field] );

	if(strlen($keywords[$field]) >= $this->Application->ConfigValue('Search_MinKeyword_Length'))
	{
	$highlight_keywords[] = $keywords[$field];
	if( in_array($verbs[$field], Array('any', 'contains', 'notcontains')) )
	{
	$keywords[$field] = '%'.strtr($keywords[$field], Array('%' => '\\%', '_' => '\\_')).'%';
	}
	$condition = sprintf( $condition_patterns[$verbs[$field]],
	$field_name,
	$this->Conn->qstr( $keywords[$field] ));
	}
	break;
	case 'boolean':
	if($keywords[$field] != -1)
	{
	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	switch($field)
	{
	case 'HotItem':
	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');
	if($hot_limit_var)
	{
	$sql = 'SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName="'.$hot_limit_var.'"';
	$hot_limit = (int)$this->Conn->GetOne($sql);
	$condition = 'IF('.$product_table.'.HotItem = 2,
	IF('.$product_table.'.Hits >= '.
	$hot_limit.
	', 1, 0), '.$product_table.'.HotItem) = '.$keywords[$field];
	}
	break;
	case 'PopItem':
	$votes2pop_var = getArrayValue($property_mappings, 'VotesToPop');
	$rating2pop_var = getArrayValue($property_mappings, 'RatingToPop');
	if($votes2pop_var && $rating2pop_var)
	{
	$condition = 'IF('.$product_table.'.PopItem = 2, IF('.$product_table.'.CachedVotesQty >= '.
	$this->Application->ConfigValue($votes2pop_var).
	' AND '.$product_table.'.CachedRating >= '.
	$this->Application->ConfigValue($rating2pop_var).
	', 1, 0), '.$product_table.'.PopItem) = '.$keywords[$field];
	}
	break;
	case 'NewItem':
	$new_days_var = getArrayValue($property_mappings, 'NewDays');
	if($new_days_var)
	{
	$condition = 'IF('.$product_table.'.NewItem = 2,
	IF('.$product_table.'.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue($new_days_var).
	'360024), 1, 0), '.$product_table.'.NewItem) = '.$keywords[$field];
	}
	break;
	case 'EditorsPick':
	$condition = $product_table.'.EditorsPick = '.$keywords[$field];
	break;
	}
	}
	break;
	case 'range':
	$range_conditions = Array();
	if($keywords[$field.'_from'] && !preg_match("/[^0-9]/i", $keywords[$field.'_from']))
	{
	$range_conditions[] = $field_name.' >= '.$keywords[$field.'_from'];
	}
	if($keywords[$field.'_to'] && !preg_match("/[^0-9]/i", $keywords[$field.'_to']))
	{
	$range_conditions[] = $field_name.' <= '.$keywords[$field.'_to'];
	}
	if($range_conditions)
	{
	$condition = implode(' AND ', $range_conditions);
	}
	break;
	case 'date':
	if($keywords[$field])
	{
	if( in_array($keywords[$field], Array('today', 'yesterday')) )
	{
	$current_time = getdate();
	$day_begin = adodb_mktime(0, 0, 0, $current_time['mon'], $current_time['mday'], $current_time['year']);
	$time_mapping = Array('today' => $day_begin, 'yesterday' => ($day_begin - 86400));
	$min_time = $time_mapping[$keywords[$field]];
	}
	else
	{
	$time_mapping = Array( 'last_week' => 604800, 'last_month' => 2628000,
	'last_3_months' => 7884000, 'last_6_months' => 15768000,
	'last_year' => 31536000
	);
	$min_time = adodb_mktime() - $time_mapping[$keywords[$field]];
	}
	$condition = $field_name.' > '.$min_time;
	}
	break;
	}

	if($condition)
	{
	if($join_clause)
	{
	$join_clauses[] = $join_clause;
	}
	$relevance_parts[] = 'IF('.$condition.', '.$record['Priority'].', 0)';
	if($glues[$field] == 1) // and
	{
	if($condition_mode == 'WHERE')
	{
	$and_conditions[] = $condition;
	}
	else
	{
	$and_having_conditions[] = $condition;
	}
	}
	else // or
	{
	if($condition_mode == 'WHERE')
	{
	$or_conditions[] = $condition;
	}
	else
	{
	$or_having_conditions[] = $condition;
	}
	}

	// create search log record
	$search_log_data = Array('search_config' => $record, 'verb' => getArrayValue($verbs, $field), 'value' => ($record['FieldType'] == 'range') ? $search_keywords[$field.'_from'].'\|'.$search_keywords[$field.'_to'] : $search_keywords[$field]);
	$search_log[] = $this->Application->Phrase('la_Field').' "'.$this->getHuman('Field', $search_log_data).'" '.$this->getHuman('Verb', $search_log_data).' '.$this->Application->Phrase('la_Value').' '.$this->getHuman('Value', $search_log_data).' '.$this->Application->Phrase($glues[$field] == 1 ? 'lu_And' : 'lu_Or');
	}
	}

	$search_log = implode('<br />', $search_log);
	$search_log = preg_replace('/(.*) '.preg_quote($this->Application->Phrase('lu_and'), '/').'\|'.preg_quote($this->Application->Phrase('lu_or'), '/').'$/is', '\\1', $search_log);
	$this->saveToSearchLog($search_log, 1); // advanced search

	$this->Application->StoreVar('highlight_keywords', serialize($highlight_keywords));

	// making relevance clause
	if($relevance_parts)
	{
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_products') / 100;
	$relevance_clause = '('.implode(' + ', $relevance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;
	}
	else
	{
	$relevance_clause = '0';
	}

	// building having clause
	if($or_having_conditions)
	{
	$and_having_conditions[] = '('.implode(' OR ', $or_having_conditions).')';
	}
	$having_clause = implode(' AND ', $and_having_conditions);
	$having_clause = $having_clause ? ' HAVING '.$having_clause : '';

	// building where clause
	if($or_conditions)
	{
	$and_conditions[] = '('.implode(' OR ', $or_conditions).')';
	}
	// $and_conditions[] = $product_table.'.Status = 1';
	$where_clause = implode(' AND ', $and_conditions);
	if(!$where_clause)
	{
	if($having_clause)
	{
	$where_clause = '1';
	}
	else
	{
	$where_clause = '0';
	$this->Application->SetVar('adv_search_error', 1);
	}
	}
	$where_clause .= ' AND '.$product_table.'.Status = 1';

	// building final search query
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';

	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table);

	$sql = ' CREATE TABLE '.$search_table.'
	SELECT '.$relevance_clause.' AS Relevance,
	'.$product_table.'.ProductId AS ItemId,
	'.$product_table.'.ResourceId AS ResourceId,
	11 AS ItemType,
	'.$product_table.'.EditorsPick AS EdPick
	FROM '.$product_table.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$product_table.'.ProductId'.
	$having_clause;

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


	function getHuman($type, $search_data)
	{
	$type = ucfirst(strtolower($type));
	extract($search_data);

	switch ($type) {
	case 'Field':
	return $this->Application->Phrase($search_config['DisplayName']);
	break;

	case 'Verb':
	return $verb ? $this->Application->Phrase('lu_advsearch_'.$verb) : '';
	break;

	case 'Value':
	switch ($search_config['FieldType']) {
	case 'date':
	$values = Array(0 => 'lu_comm_Any', 'today' => 'lu_comm_Today',
	'yesterday' => 'lu_comm_Yesterday', 'last_week' => 'lu_comm_LastWeek',
	'last_month' => 'lu_comm_LastMonth', 'last_3_months' => 'lu_comm_Last3Months',
	'last_6_months' => 'lu_comm_Last6Months', 'last_year' => 'lu_comm_LastYear');
	$ret = $this->Application->Phrase($values[$value]);
	break;

	case 'range':
	$value = explode('\|', $value);
	return $this->Application->Phrase('lu_comm_From').' "'.$value[0].'" '.$this->Application->Phrase('lu_comm_To').' "'.$value[1].'"';
	break;

	case 'boolean':
	$values = Array(1 => 'lu_comm_Yes', 0 => 'lu_comm_No', -1 => 'lu_comm_Both');
	$ret = $this->Application->Phrase($values[$value]);
	break;

	case 'text':
	$ret = $value;
	break;

	}
	return '"'.$ret.'"';
	break;
	}
	}



	/**
	* Set's correct page for list
	* based on data provided with event
	*
	* @param kEvent $event
	* @access private
	* @see OnListBuild
	*/
	function SetPagination(&$event)
	{
	// get PerPage (forced -> session -> config -> 10)
	$per_page = $this->getPerPage($event);

	$object =& $event->getObject();
	$object->SetPerPage($per_page);
	$this->Application->StoreVarDefault($event->getPrefixSpecial().'_Page', 1);

	$page = $this->Application->GetVar($event->getPrefixSpecial().'_Page');
	if (!$page)
	{
	$page = $this->Application->GetVar($event->getPrefixSpecial(true).'_Page');
	}

	if (!$page)
	{
	if( $this->Application->RewriteURLs() )
	{
	$page = $this->Application->GetVar($event->Prefix.'_Page');
	if (!$page)
	{
	$page = $this->Application->RecallVar($event->Prefix.'_Page');
	}
	if($page) $this->Application->StoreVar($event->getPrefixSpecial().'_Page', $page);
	}
	else
	{
	$page = $this->Application->RecallVar($event->getPrefixSpecial().'_Page');
	}
	}
	else {
	$this->Application->StoreVar($event->getPrefixSpecial().'_Page', $page);
	}

	if( !$event->getEventParam('skip_counting') )
	{
	$pages = $object->GetTotalPages();
	if($page > $pages)
	{
	$this->Application->StoreVar($event->getPrefixSpecial().'_Page', 1);
	$page = 1;
	}
	}

	/*$cur_per_page = $per_page;
	$per_page = $event->getEventParam('per_page');
	if ($per_page == 'list_next') {

	$cur_page = $page;

	$object =& $this->Application->recallObject($event->Prefix);
	$object->SetPerPage(1);
	$cur_item_index = $object->CurrentIndex;

	$page = ($cur_page-1) * $cur_per_page + $cur_item_index + 1;
	$object->SetPerPage(1);
	}*/

	$object->SetPage($page);
	}

	/* === RELATED TO IMPORT/EXPORT: BEGIN === */

	/**
	* Returns module folder
	*
	* @param kEvent $event
	* @return string
	*/
	function getModuleFolder(&$event)
	{
	return $this->Application->getUnitOption($event->Prefix, 'ModuleFolder');
	}

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnExport(&$event)
	{
	// use old fasion (in-portal) grid
	$selector_name = $this->Application->getUnitOption($event->Prefix, 'CatalogSelectorName');
	if ($selector_name) {
	$selected_ids = $this->Application->GetVar($selector_name);
	}
	else {
	$this->StoreSelectedIDs($event);
	$selected_ids = $this->getSelectedIDs($event);

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

	$selected_cats_ids = $this->Application->GetVar('export_categories');

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

	$event->redirect = $this->getModuleFolder($event).'/export';

	$redirect_params = Array( 'm_opener' => 'd',
	'index_file' => 'index4.php',
	$this->Prefix.'.export_event' => 'OnNew',
	'pass' => 'all,'.$this->Prefix.'.export');

	$event->setRedirectParams($redirect_params);
	}

	/**
	* Export form validation & processing
	*
	* @param kEvent $event
	*/
	function OnExportBegin(&$event)
	{
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if (!$items_info)
	{
	$items_info = unserialize( $this->Application->RecallVar($event->getPrefixSpecial().'_ItemsInfo') );
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);
	}

	list($item_id, $field_values) = each($items_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);
	$field_values['ImportFilename'] = $object->GetDBField('ImportFilename'); //if upload formatter has renamed the file during moving !!!

	$object->setID($item_id);
	$this->setRequiredFields($event);

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

	// save export/import options
	if ($event->Special == 'export')
	{
	$export_ids = $this->Application->RecallVar($event->Prefix.'_export_ids');
	$export_cats_ids = $this->Application->RecallVar($event->Prefix.'_export_cats_ids');

	// used for multistep export
	$field_values['export_ids'] = $export_ids ? explode(',', $export_ids) : false;
	$field_values['export_cats_ids'] = $export_cats_ids ? explode(',', $export_cats_ids) : Array( $this->Application->GetVar('m_cat_id') );
	}

	$field_values['ExportColumns'] = $field_values['ExportColumns'] ? explode('\|', substr($field_values['ExportColumns'], 1, -1) ) : Array();
	$field_values['start_from'] = 0;
	$export_object->saveOptions($event, $field_values);

	if( $export_object->verifyOptions($event) )
	{
	$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_progress';

	}
	else
	{
	// make uploaded file local & change source selection
	$filename = getArrayValue($field_values, 'ImportFilename');
	if ($filename) {
	$this->updateImportFiles($event);
	$object->SetDBField('ImportSource', 2);
	$field_values['ImportSource'] = 2;
	$object->SetDBField('ImportLocalFilename', $filename);
	$field_values['ImportLocalFilename'] = $filename;
	$export_object->saveOptions($event, $field_values);
	}

	$event->status = erFAIL;
	$event->redirect = false;
	}
	}

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

	/**
	* Sets correct available & export fields
	*
	* @param kEvent $event
	*/
	function prepareExportColumns(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$available_columns = Array();

	// category field (mixed)
	$available_columns['__CATEGORY__CategoryPath'] = 'CategoryPath';

	if ($event->Special == 'import') {
	// category field (separated fields)
	$max_level = $this->Application->ConfigValue('MaxImportCategoryLevels');
	$i = 0;
	while ($i < $max_level) {
	$available_columns['__CATEGORY__Category'.($i + 1)] = 'Category'.($i + 1);
	$i++;
	}
	}

	// db fields
	foreach ($object->Fields as $field_name => $field_options)
	{
	if (!$object->SkipField($field_name))
	{
	$available_columns[$field_name] = $field_name.(getArrayValue($field_options, 'required') ? '*' : '');
	}
	}

	$available_columns = array_merge_recursive2($available_columns, $this->getCustomExportColumns($event));

	// custom fields
	foreach ($object->customFields as $custom_id => $custom_name)
	{
	$available_columns['__CUSTOM__'.$custom_name] = $custom_name;
	}

	// columns already in use
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info)
	{
	list($item_id, $field_values) = each($items_info);
	$export_keys = $field_values['ExportColumns'];
	$export_keys = $export_keys ? explode('\|', substr($export_keys, 1, -1) ) : Array();
	}
	else {
	$export_keys = Array();
	}

	$export_columns = Array();
	foreach ($export_keys as $field_key)
	{
	$field_name = $this->getExportField($field_key);
	$export_columns[$field_key] = $field_name;
	unset($available_columns[$field_key]);
	}

	$options = $object->GetFieldOptions('ExportColumns');
	$options['options'] = $export_columns;
	$object->SetFieldOptions('ExportColumns', $options);

	$options = $object->GetFieldOptions('AvailableColumns');
	$options['options'] = $available_columns;
	$object->SetFieldOptions('AvailableColumns', $options);

	$this->updateImportFiles($event);
	}

	/**
	* Updates uploaded files list
	*
	* @param kEvent $event
	*/
	function updateImportFiles(&$event)
	{
	if ($event->Special != 'import') {
	return false;
	}

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

	$import_filenames = Array();

	if ($folder_handle = opendir(EXPORT_PATH)) {
	while (false !== ($file = readdir($folder_handle))) {
	if (is_dir(EXPORT_PATH.'/'.$file) \|\| substr($file, 0, 1) == '.' \|\| strtolower($file) == 'cvs' \|\| strtolower($file) == 'dummy' \|\| filesize(EXPORT_PATH.'/'.$file) == 0) continue;

	$file_size = formatSize( filesize(EXPORT_PATH.'/'.$file) );
	$import_filenames[$file] = $file.' ('.$file_size.')';
	}
	closedir($folder_handle);
	}

	$options = $object->GetFieldOptions('ImportLocalFilename');
	$options['options'] = $import_filenames;
	$object->SetFieldOptions('ImportLocalFilename', $options);
	}

	/**
	* Returns specific to each item type columns only
	*
	* @param kEvent $event
	* @return Array
	*/
	function getCustomExportColumns(&$event)
	{
	return Array( '__VIRTUAL__ThumbnailImage' => 'ThumbnailImage',
	'__VIRTUAL__FullImage' => 'FullImage',
	'__VIRTUAL__ImageAlt' => 'ImageAlt');
	}

	/**
	* Sets non standart virtual fields (e.g. to other tables)
	*
	* @param kEvent $event
	*/
	function setCustomExportColumns(&$event)
	{
	$this->restorePrimaryImage($event);
	}

	/**
	* Create/Update primary image record in info found in imported data
	*
	* @param kEvent $event
	*/
	function restorePrimaryImage(&$event)
	{
	$object =& $event->getObject();

	$has_image_info = $object->GetDBField('ImageAlt') && ($object->GetDBField('ThumbnailImage') \|\| $object->GetDBField('FullImage'));
	if (!$has_image_info) {
	return false;
	}

	$image_data = $object->getPrimaryImageData();

	$image =& $this->Application->recallObject('img', null, Array('skip_autoload' => true));
	if ($image_data) {
	$image->Load($image_data['ImageId']);
	}
	else {
	$image->Clear();
	$image->SetDBField('Name', 'main');
	$image->SetDBField('DefaultImg', 1);
	$image->SetDBField('ResourceId', $object->GetDBField('ResourceId'));
	}

	$image->SetDBField('AltName', $object->GetDBField('ImageAlt'));

	if ($object->GetDBField('ThumbnailImage')) {
	$thumbnail_field = $this->isURL( $object->GetDBField('ThumbnailImage') ) ? 'ThumbUrl' : 'ThumbPath';
	$image->SetDBField($thumbnail_field, $object->GetDBField('ThumbnailImage') );
	$image->SetDBField('LocalThumb', $thumbnail_field == 'ThumbPath' ? 1 : 0);
	}

	if (!$object->GetDBField('FullImage')) {
	$image->SetDBField('SameImages', 1);
	}
	else {
	$image->SetDBField('SameImages', 0);
	$full_field = $this->isURL( $object->GetDBField('FullImage') ) ? 'Url' : 'LocalPath';
	$image->SetDBField($full_field, $object->GetDBField('FullImage') );
	$image->SetDBField('LocalImage', $full_field == 'LocalPath' ? 1 : 0);
	}

	if ($image->isLoaded()) {
	$image->Update();
	}
	else {
	$image->Create();
	}
	}

	function isURL($path)
	{
	return preg_match('#(http\|https)://(.*)#', $path);
	}

	// ImportLocalFilename

	function getExportField($field_key)
	{
	$prepends = Array('__CUSTOM__', '__CATEGORY__');
	foreach ($prepends as $prepend)
	{
	if (substr($field_key, 0, strlen($prepend) ) == $prepend)
	{
	$field_key = substr($field_key, strlen($prepend), strlen($field_key) );
	break;
	}
	}
	return $field_key;
	}

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnImport(&$event)
	{

	$event->redirect = $this->getModuleFolder($event).'/import';

	$redirect_params = Array( 'm_opener' => 'd',
	'index_file' => 'index4.php',
	$this->Prefix.'.import_event' => 'OnNew',
	'pass' => 'all,'.$this->Prefix.'.import');

	$event->setRedirectParams($redirect_params);
	}

	/**
	* Prepares item for import/export operations
	*
	* @param kEvent $event
	*/
	function OnNew(&$event)
	{
	parent::OnNew($event);

	if ($event->Special != 'import' && $event->Special != 'export') return ;
	$this->setRequiredFields($event);
	$this->Application->StoreVar('ImportCategory', 0);
	}

	/**
	* set required fields based on import or export params
	*
	* @param kEvent $event
	*/
	function setRequiredFields(&$event)
	{
	$required_fields['common'] = Array('FieldsSeparatedBy', 'LineEndings', 'CategoryFormat');

	$required_fields['export'] = Array('ExportFormat', 'ExportFilename','ExportColumns');
	$required_fields['import'] = Array('FieldTitles', 'ImportSource', 'CheckDuplicatesMethod'); // ImportFilename, ImportLocalFilename

	$object =& $event->getObject();
	if ($event->Special == 'import')
	{
	$import_source = Array(1 => 'ImportFilename', 2 => 'ImportLocalFilename');
	$used_field = $import_source[ $object->GetDBField('ImportSource') ];

	$required_fields[$event->Special][] = $used_field;
	$object->Fields[$used_field]['error_field'] = 'ImportSource';

	if ($object->GetDBField('FieldTitles') == 2) $required_fields[$event->Special][] = 'ExportColumns'; // manual field titles
	}

	$required_fields = array_merge($required_fields['common'], $required_fields[$event->Special]);
	foreach ($required_fields as $required_field) {
	$object->setRequired($required_field, true);
	}
	}

	/**
	* Saves selected category as new import category
	*
	* @param kEvent $event
	*/
	function OnSelectItems(&$event)
	{
	$dst_field = $this->Application->RecallVar('dst_field');
	$items_info = $this->Application->GetVar('c');
	if ($items_info) {
	$category_id = array_shift( array_keys($items_info) );
	$sql = 'SELECT CategoryId
	FROM '.TABLE_PREFIX.'Category
	WHERE ResourceId = '.$category_id;
	$category_id = $this->Conn->GetOne($sql);
	}
	else {
	$category_id = 0;
	}

	if ($dst_field == 'ImportCategory') {
	$this->Application->StoreVar('ImportCategory', $category_id);
	$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 1); // not to loose import/export values on form refresh

	$this->Application->SetVar($event->getPrefixSpecial().'_id', 0);
	$this->Application->SetVar($event->getPrefixSpecial().'_event', 'OnExportBegin');

	$passed = $this->Application->GetVar('passed');
	$this->Application->SetVar('passed', $passed.','.$event->getPrefixSpecial());
	$event->setEventParam('pass_events', true);
	}

	if ($dst_field == 'ItemCategory') {
	$object =& $event->getObject(); // category item object (e.g. link, product, etc.)

	$ci_prefix = $object->Prefix.'-ci';
	$ci_object =& $this->Application->recallObject($ci_prefix, null, Array('skip_autoload' => true));

	$ci_object->Load($category_id);
	if (!$ci_object->isLoaded()) {
	$fields_hash = Array('CategoryId' => $category_id, 'ItemResourceId' => $object->GetDBField('ResourceId'));
	$ci_object->SetDBFieldsFromHash($fields_hash);
	$ci_object->Create(true);
	}
	}

	$this->finalizePopup($event);
	}

	/**
	* Saves Import/Export settings to session
	*
	* @param kEvent $event
	*/
	function OnSaveSettings(&$event)
	{
	$event->redirect = false;
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info) {
	list($id, $field_values) = each($items_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);
	$field_values['ImportFilename'] = $object->GetDBField('ImportFilename'); //if upload formatter has renamed the file during moving !!!
	$field_values['ImportSource'] = 2;
	$field_values['ImportLocalFilename'] = $object->GetDBField('ImportFilename');
	$items_info[$id] = $field_values;

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

	/* === RELATED TO IMPORT/EXPORT: END === */

	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/general/cat_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.52
	\ No newline at end of property
	+1.53
	\ No newline at end of property
	Index: trunk/kernel/units/general/helpers/permissions_helper.php
	===================================================================
	--- trunk/kernel/units/general/helpers/permissions_helper.php (revision 4841)
	+++ trunk/kernel/units/general/helpers/permissions_helper.php (revision 4842)
	@@ -1,367 +1,368 @@
	<?php

	class kPermissionsHelper extends kHelper {

	/**
	* Current set of permissions for group being edited
	*
	* @var Array
	*/
	var $Permissions = Array();

	function LoadPermissions($prefix)
	{
	$object =& $this->Application->recallObject($prefix.'-perm', null, Array('skip_autoload' => true));

	$foreign_key = $this->Application->getUnitOption($prefix.'-perm', 'ForeignKey');
	$foreign_value = $this->Application->GetVar($prefix.'_id');
	$sql = 'SELECT *
	FROM '.$object->TableName.'
	WHERE '.$foreign_key.' = '.$foreign_value;
	$permissions = $this->Conn->Query($sql, 'Permission');

	$this->Permissions = Array();
	foreach ($permissions as $perm_name => $perm_options) {
	$perm_record['value'] = $perm_options['PermissionValue'];
	$perm_record['id'] = $perm_options['PermissionId'];
	$this->Permissions[$perm_name] = $perm_record;
	}
	}

	function getPermissionValue($perm_name)
	{
	return getArrayValue($this->Permissions, $perm_name) ? $this->Permissions[$perm_name]['value'] : 0;
	}

	function getPermissionID($perm_name)
	{
	return getArrayValue($this->Permissions, $perm_name) ? $this->Permissions[$perm_name]['id'] : 0;
	}

	/**
	* This is old permission like ADMIN or LOGIN
	*
	* @param string $section_name
	* @param string $perm_name
	* @return bool
	*/
	function isOldPermission($section_name, $perm_name)
	{
	return $section_name == 'in-portal:root' && $perm_name != 'view';
	}

	/**
	* Returns permission names to check based on event name and item prefix (main item or subitem)
	*
	* @param kEvent $event
	* @return Array
	*/
	function getPermissionByEvent(&$event, $perm_mapping)
	{
	$top_prefix = $event->getEventParam('top_prefix');

	$pefix_type = ($top_prefix == $event->Prefix) ? 'self' : 'subitem';
	$perm_mapping = getArrayValue($perm_mapping, $event->Name);

	if (!$perm_mapping[$pefix_type]) {
	trigger_error('Permission mappings not defined for event <b>'.$top_prefix.' <- '.$event->Prefix.':'.$event->Name.'</b>', E_USER_ERROR);
	}

	if ($perm_mapping[$pefix_type] === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	return explode('\|', $perm_mapping[$pefix_type]);
	}

	/**
	* Common event permission checking method
	*
	* @param kEvent $event
	*/
	function CheckEventPermission(&$event, $perm_mapping)
	{
	$section = $event->getSection();
	if (preg_match('/^CATEGORY:(.*)/', $section)) {
	return $this->CheckEventCategoryPermission($event, $perm_mapping);
	}

	$top_prefix = $event->getEventParam('top_prefix');
	$check_perms = $this->getPermissionByEvent($event, $perm_mapping);

	if ($check_perms === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	$perm_status = false;
	foreach ($check_perms as $perm_name) {
	// check if at least one of required permissions is set
	$perm_name = $section.'.'.$perm_name;
	$perm_status = $this->CheckPermission($perm_name, 1);
	if (($perm_name == $section.'.add') && $perm_status && ($top_prefix == $event->Prefix)) {
	// main item, add permission allowed, but ID is > 0, then deny permission
	// how to get id here
	}
	if ($perm_status) {
	return $perm_status;
	}
	}

	if (!$perm_status) {
	if ($this->Application->isDebugMode()) {
	// for debugging purposes
	$event->SetRedirectParam('section', $section);
	$event->SetRedirectParam('main_prefix', $top_prefix);
	$event->SetRedirectParam('event_name', $event->Name);
	$event->SetRedirectParam('next_template', $this->Application->GetVar('t'));
	}
	$event->status = erPERM_FAIL;
	}
	return $perm_status;
	}

	/**
	* Checks non-system permission on event per category basis
	*
	* @param kEvent $event
	*/
	function CheckEventCategoryPermission(&$event, $event_perm_mapping)
	{
	// mapping between specific permissions and common permissions
	$perm_mapping = Array('add' => 'ADD', 'edit' => 'MODIFY', 'delete' => 'DELETE', 'view' => 'VIEW');

	$top_prefix = $event->getEventParam('top_prefix');
	$event_handler =& $this->Application->recallObject($event->Prefix.'_EventHandler');
	if ($event->Prefix != $top_prefix) {
	$top_event = new kEvent($top_prefix.':'.$event->Name);
	$id = $event_handler->getPassedID($top_event);
	}
	else {
	$id = $event_handler->getPassedID($event);
	}

	$item_prefix = $this->Application->getUnitOption($top_prefix, 'PermItemPrefix');

	// 1. get primary category of category item
	$id_field = $this->Application->getUnitOption($top_prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($top_prefix, 'TableName');
	$ci_table = $this->Application->getUnitOption($top_prefix.'-ci', 'TableName');

	if (!$id) {
	// item being created -> check by current (before editing started, saved in OnPreCreate event) category permissions
	$category_id = $this->Application->RecallVar('m_cat_id');
	}
	else {
	// item being edited -> check by it's primary category permissions
	$sql = 'SELECT ci.CategoryId
	FROM '.$table_name.' main_table
	LEFT JOIN '.$ci_table.' ci ON ci.ItemResourceId = main_table.ResourceId
	WHERE (main_table.'.$id_field.' = '.$id.') AND (ci.PrimaryCat = 1)';
	$category_id = $this->Conn->GetOne($sql);
	}

	if ((substr($event->Name, 0, 9) == 'OnPreSave') \|\| ($event->Name == 'OnSave')) {
	if ($event_handler->isNewItemCreate($event)) {
	return $this->CheckPermission($item_prefix.'.ADD', 0, $category_id);
	}
	else {
	return $this->CheckPermission($item_prefix.'.ADD', 0, $category_id) \|\| $this->CheckPermission($item_prefix.'.MODIFY', 0, $category_id);
	}
	}

	$perm_status = false;
	$check_perms = $this->getPermissionByEvent($event, $event_perm_mapping);

	if ($check_perms === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	foreach ($check_perms as $perm_name) {
	// check if at least one of required permissions is set
	if (!isset($perm_mapping[$perm_name])) {
	// not mapped permission (e.g. advanced:approve) -> skip
	continue;
	}
	$perm_name = $item_prefix.'.'.$perm_mapping[$perm_name];
	$this->showDebug('Event <b>'.$event->Name.'</b> permission(-s): <b>'.$perm_name.'</b>');
	$perm_status = $this->CheckPermission($perm_name, 0, $category_id);

	if ($perm_status) {
	return $perm_status;
	}
	}

	if (!$perm_status) {
	$event->SetRedirectParam('index_file', 'index.php'); // because called from browse.php
	if ($this->Application->isDebugMode()) {
	// for debugging purposes
	$event->SetRedirectParam('section', $event->getSection());
	$event->SetRedirectParam('main_prefix', $top_prefix);
	$event->SetRedirectParam('event_name', $event->Name);
	$event->SetRedirectParam('next_template', $this->Application->GetVar('t'));
	}
	$event->status = erPERM_FAIL;
	}
	return $perm_status;
	}

	function showDebug($text)
	{
	if (!$this->Application->isDebugMode()) return true;
	echo $text.'<br />';
	}

	function TagPermissionCheck($params, $tag_name)
	{
	$perm_event = getArrayValue($params, 'perm_event');
	$permission_groups = getArrayValue($params, 'permissions');

	if ($permission_groups) {
	- $this->showDebug('Tag <b>'.$tag_name.'</b> permission(-s): '.$permission_groups);
	+ $this->showDebug('Tag <b>'.$tag_name.'</b> permission(-s): <b>'.$permission_groups.'</b>');
	$permission_groups = explode('\|', $permission_groups);
	$group_has_permission = false;
	foreach ($permission_groups as $permission_group) {
	$permissions = explode(',', $permission_group);
	$has_permission = true;
	foreach ($permissions as $permission) {
	$has_permission = $has_permission && $this->CheckPermission($permission, isset($params['system']) && $params['system'] ? 1 : 0);
	}
	$group_has_permission = $group_has_permission \|\| $has_permission;

	if ($group_has_permission) {
	return true;
	}
	}
	return false;
	}
	elseif ($perm_event) {
	+ $this->showDebug('Tag <b>'.$tag_name.'</b> permission_event: <b>'.$perm_event.'</b>');
	list($prefix, $event) = explode(':', $perm_event);
	$event_handler =& $this->Application->recallObject($prefix.'_EventHandler');
	return $event_handler->CheckPermission( new kEvent($perm_event) );
	}

	return true;
	}

	/**
	* Returns no permission template to redirect to
	*
	* @param Array $params
	* @return Array
	*/
	function getPermissionTemplate($params)
	{
	$t = $this->Application->GetVar('t');
	if ($next_t = getArrayValue($params, 'next_template')) {
	$t = $next_t;
	}

	if (!$this->Application->LoggedIn()) {
	$redirect_template = $params['login_template'];
	$redirect_params = Array('next_template' => $t);
	}
	else {
	if (isset($params['no_permissions_template'])) {
	$redirect_template = $params['no_permissions_template'];
	}
	else {
	$redirect_template = $this->Application->IsAdmin() ? 'no_permission' : $this->Application->ConfigValue('NoPermissionTemplate');
	}

	- $redirect_params = $this->Application->isDebugMode() ? Array('from_template' => 1, 'perms' => $params['permissions'], 'next_template' => $t) : Array();
	+ $redirect_params = $this->Application->isDebugMode() ? Array('from_template' => 1, 'perms' => $params[ isset($params['permissions']) ? 'permissions' : 'perm_event'], 'next_template' => $t) : Array();
	}

	return Array($redirect_template, $redirect_params);
	}

	/**
	* Check current user permissions based on it's group permissions in specified category (for non-system permissions) or just checks if system permission is set
	*
	* @param string $name permission name
	* @param int $cat_id category id, current used if not specified
	* @param int $type permission type {1 - system, 0 - per category}
	* @return int
	*/
	function CheckPermission($name, $type = 1, $cat_id = null)
	{
	if ($this->Application->GetVar('u_id') == -1) {
	// "root" is allowed anywhere
	return $name == 'SYSTEM_ACCESS.READONLY' ? 0 : 1;
	}

	if ($type == 1) {
	// "system" permission are always checked per "Home" category (ID = 0)
	$cat_id = 0;
	}

	if (!isset($cat_id)) {
	$cat_id = $this->Application->GetVar('m_cat_id');
	}

	$cache_key = $name.'\|'.$type.'\|'.$cat_id;
	$perm_value = $this->Application->getCache('permissions', $cache_key);
	if ($perm_value !== false) {
	return $perm_value;
	}

	// perm cache is build only based on records in db, that's why if permission is not explicitly denied, then
	// that (perm cache creator) code thinks that it is allowed & adds corresponding record and code below will
	// return incorrect results

	/if (preg_match('/(.)\.VIEW$/', $name) && ($type == 0)) {
	// cached view permission of category: begin
	$sql = 'SELECT perm_cache.PermId
	FROM '.TABLE_PREFIX.'PermCache perm_cache
	LEFT JOIN '.TABLE_PREFIX.'PermissionConfig perm_config ON perm_cache.PermId = perm_config.PermissionConfigId
	WHERE (perm_config.PermissionName = '.$this->Conn->qstr($name).' AND perm_cache.CategoryId = '.$cat_id.')';

	$view_filters = Array();
	$groups = explode(',', $this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', perm_cache.ACL) \|\| ((NOT FIND_IN_SET('.$group.', perm_cache.DACL)) AND perm_cache.ACL = \'\')';
	}
	$sql .= ' AND ('.implode(' OR ', $view_filters).')';
	$perm_value = $this->Conn->GetOne($sql) ? 1 : 0;

	$this->Application->setCache('permissions', $cache_key, $perm_value);
	return $perm_value;
	// cached view permission of category: end
	}*/

	if ($cat_id == 0) {
	$cat_hierarchy = Array(0);
	}
	else {
	$sql = 'SELECT ParentPath
	FROM '.$this->Application->getUnitOption('c', 'TableName').'
	WHERE CategoryId = '.$cat_id;
	$cat_hierarchy = $this->Conn->GetOne($sql);
	$cat_hierarchy = explode('\|', $cat_hierarchy);
	array_shift($cat_hierarchy);
	array_pop($cat_hierarchy);
	$cat_hierarchy = array_reverse($cat_hierarchy);
	array_push($cat_hierarchy, 0);
	}

	$perm_value = 0;
	$groups = $this->Application->RecallVar('UserGroups');
	foreach ($cat_hierarchy as $category_id) {
	$sql = 'SELECT PermissionValue
	FROM '.TABLE_PREFIX.'Permissions
	WHERE Permission = "'.$name.'" AND CatId = '.$category_id.' AND GroupId IN ('.$groups.') AND Type = '.$type;
	$res = $this->Conn->GetOne($sql);
	if ($res !== false) {
	$perm_value = $res;
	break;
	}
	}

	$this->Application->setCache('permissions', $cache_key, $perm_value);
	return $perm_value;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/general/helpers/permissions_helper.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.7
	\ No newline at end of property
	+1.8
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/popups/translator.tpl
	===================================================================
	--- trunk/kernel/admin_templates/popups/translator.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/popups/translator.tpl (revision 4842)
	@@ -1,92 +1,93 @@
	+<inp2:m_RequireLogin perm_event="trans:OnLoad"/>
	<!--DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">-->
	<html>
	<head>
	<title>In-Portal</title>

	<meta http-equiv="content-type" content="text/html; charset=<inp2:trans_Field field="Charset"/>">
	<meta name="keywords" content="...">
	<meta name="description" content="...">
	<meta name="robots" content="all">
	<meta name="copyright" content="Copyright ® 2006 Test, Inc">
	<meta name="author" content="Intechnic Inc.">

	<inp2:m_base_ref/>

	<link rel="icon" href="img/favicon.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="img/favicon.ico" type="image/x-icon" />
	<link rel="stylesheet" rev="stylesheet" href="incs/style.css" type="text/css" media="screen" />

	<script language="javascript" src="incs/is.js"></script>
	<script language="javascript" src="incs/script.js"></script>
	<script language="javascript" src="incs/in-portal.js"></script>
	<script language="javascript" src="incs/toolbar.js"></script>
	<script language="javascript" src="incs/grid.js"></script>
	<script language="javascript" src="incs/tabs.js"></script>
	<script language="javascript">
	var t = '<inp2:m_get param="t"/>';
	var popups = '1';
	var multiple_windows = '1';
	var main_title = 'In-Portal';
	var tpl_changed = 0;
	var base_url = '<inp2:m_BaseURL/>';

	var img_path = "img/";

	</script>
	</head>

	<inp2:m_include t="incs/blocks"/>
	<inp2:m_include t="incs/in-portal"/>

	<inp2:m_ParseBlock name="kernel_form"/>
	<inp2:m_if prefix="m" function="IsDebugMode"/>
	<input type="button" class="button" value="Reload Frame" onclick="self.location.reload();" />  <input type="button" class="button" value="Show Debugger" onclick="$Debugger.Toggle();" />
	<inp2:m_endif/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">

	<inp2:m_ParseBlock name="blue_bar" prefix="trans" title_preset="trans_edit" module="in-commerce"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	a_toolbar = new ToolBar();

	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	submit_event('trans','OnSaveAndClose');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	window.close();
	}
	) );

	a_toolbar.Render();
	</script>

	</td>
	</tr>
	</tbody>
	</table>

	<input type="hidden" name="trans_prefix" value="<inp2:m_get var="trans_prefix"/>">
	<input type="hidden" name="trans_field" value="<inp2:m_get var="trans_field"/>">

	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<inp2:m_ParseBlock name="inp_edit_hidden" prefix="trans" field="Language"/>

	<inp2:m_ParseBlock name="subsection" title="!la_section_Translation!"/>
	<inp2:m_ParseBlock name="inp_label" prefix="trans" title="!la_fld_Original!" field="Original"/>
	<inp2:m_ParseBlock name="inp_edit_options" prefix="trans" field="SwitchLanguage" title="!la_fld_Language!" size="50" onchange="submit_event('trans', 'OnChangeLanguage')"/>

	<inp2:m_if check="m_get" var="trans_multi_line" value="1">
	<inp2:m_ParseBlock name="inp_edit_textarea" prefix="trans" field="Translation" title="!la_fld_Translation!" cols="50" rows="10"/>
	<inp2:m_else/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="trans" field="Translation" title="!la_fld_Translation!" size="50"/>
	</inp2:m_if>
	</table>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/popups/translator.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.10
	\ No newline at end of property
	+1.11
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/tree.tpl
	===================================================================
	--- trunk/kernel/admin_templates/tree.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/tree.tpl (revision 4842)
	@@ -1,124 +1,113 @@
	<inp2:m_include t="incs/header" nobody="yes"/>

	<inp2:adm_SetConst name="DBG_SKIP_REPORTING" value="1"/>

	<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" bgcolor="#DCEBF6">

	<script type="text/javascript">
	function credits(url)
	{
	var width = 200;
	var height = 200;
	var screen_x = (screen.availWidth-width)/2;
	var screen_y = (screen.availHeight-height)/2;
	window.open(url, 'credits', 'width=280,height=520,left='+screen_x+',top='+screen_y);
	}
	-
	-
	- function checkEditMode()
	- {
	- if (window.parent.getFrame('main').$edit_mode) {
	- return confirm('<inp2:m_Phrase label="la_EditingInProgress" escape="1"/>') ? true : false;
	- }
	-
	- return true;
	- }
	</script>

	<script src="incs/tree.js"></script>

	<style type="text/css">
	.tree_head.td, .tree_head, .tree_head:hover {
	font-weight: bold;
	font-size: 10px;
	color: #FFFFFF;
	font-family: Verdana, Arial;
	text-decoration: none;
	}

	.tree {
	padding: 0px;
	border: none;
	border-collapse: collapse;
	}

	.tree tr td {
	padding: 0px;
	margin: 0px;
	font-family: helvetica, arial, verdana,;
	font-size: 11px;
	white-space: nowrap;
	}

	.tree tr td a {
	font-size: 11px;
	color: #000000;
	font-family: Helvetica, Arial, Verdana;
	text-decoration: none;
	}

	.tree tr td a:hover {
	color: #009FF0;
	}
	-
	</style>

	<table cellpadding="0" cellspacing="0" border="0" width="100%">
	<tr style="background: #5291DE url(img/menu_bar.gif) repeat-x left bottom;" class="tree_head">
	<td align="left" width="80%" height="21">
	<a class="tree_head" href="javascript:credits('<inp2:m_Link index_file="help/credits.php" destform="popup"/>');">In-Portal v <inp2:adm_ModuleVersion module="In-Portal"/></a>
	</td>
	<td align="right" width="20%">
	<select name="language" style="width: 62px; border: 0px; background-color: #FFFFFF; font-size: 9px; color: black;" onchange="submit_event('lang', 'OnChangeLanguage', 'index');">
	<inp2:m_DefineElement name="lang_elem">
	<option value="<inp2:Field name="LanguageId"/>" <inp2:m_if check="SelectedLanguage">selected="selected"</inp2:m_if> ><inp2:Field name="PackName"/></option>
	</inp2:m_DefineElement>
	<inp2:lang_ListLanguages render_as="lang_elem" row_start_render_as="html:" row_end_render_as="html:"/>
	</select>
	</td>
	</tr>

	<tr>
	<td colspan="2" style="padding: 5px;">
	<inp2:m_DefineElement name="xml_node">
	<inp2:m_if check="m_ParamEquals" param="children_count" value="0">
	<item href="<inp2:m_param name="section_url"/>" onclick="checkEditMode()" icon="<inp2:$SectionPrefix_ModulePath/>img/icons/icon24_<inp2:m_param name="icon"/>.gif"><inp2:m_phrase name="$label" escape="1"/></item>
	<inp2:m_else/>
	<folder href="<inp2:m_param name="section_url"/>" onclick="checkEditMode()" name="<inp2:m_phrase name="$label" escape="1"/>" icon="<inp2:$SectionPrefix_ModulePath/>img/icons/icon24_<inp2:m_param name="icon"/>.gif" load_url="<inp2:m_param name="late_load"/>"><inp2:adm_PrintSections render_as="xml_node" section_name="$section_name"/></folder>
	</inp2:m_if>
	</inp2:m_DefineElement>

	<table class="tree">
	<tbody id="tree">
	</tbody>
	</table>
	<script type="text/javascript">
	var TREE_ICONS_PATH = 'img/tree'

	<inp2:m_DefineElement name="root_node">
	var the_tree = new TreeFolder('tree', '<inp2:m_param name="label"/>', '<inp2:m_param name="section_url"/>', '<inp2:$SectionPrefix_ModulePath/>img/icons/icon24_<inp2:m_param name="icon"/>.gif');
	</inp2:m_DefineElement>
	<inp2:adm_PrintSection render_as="root_node" section_name="in-portal:root"/>
	the_tree.AddFromXML('<tree><inp2:adm_PrintSections render_as="xml_node" section_name="in-portal:root"/></tree>');
	</script>
	</td>
	</tr>
	</table>

	<inp2:m_include t="incs/footer"/>

	<script type="text/javascript">
	// when changing language submit is made to frameset, not the current frame
	var $kf = document.getElementById($form_name);
	$kf.target = 'main_frame';

	function checkEditMode()
	{
	var $phrase = "<inp2:adm_TreeEditWarrning label="la_EditingInProgress" escape="1"/>";
	if (window.parent.getFrame('main').$edit_mode) {
	return confirm($phrase) ? true : false;
	}

	return true;
	}
	</script>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/tree.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.13
	\ No newline at end of property
	+1.14
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/custom_fields/custom_fields_edit.tpl
	===================================================================
	--- trunk/kernel/admin_templates/custom_fields/custom_fields_edit.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/custom_fields/custom_fields_edit.tpl (revision 4842)
	@@ -1,96 +1,97 @@
	+<inp2:m_RequireLogin perm_event="cf:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" prefix="cf" icon="icon46_settings_custom" title="!la_title_CustomFields!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="cf" title_preset="custom_fields_edit" module="in-portal" icon="icon46_settings_custom"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	a_toolbar = new ToolBar();
	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	submit_event('cf','<inp2:cf_SaveEvent/>');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	submit_event('cf','OnCancelEdit');
	}
	) );

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

	a_toolbar.AddButton( new ToolBarButton('prev', '<inp2:m_phrase label="la_ToolTip_Prev" escape="1"/>', function() {
	go_to_id('cf', '<inp2:cf_PrevId/>');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('next', '<inp2:m_phrase label="la_ToolTip_Next" escape="1"/>', function() {
	go_to_id('cf', '<inp2:cf_NextId/>');
	}
	) );


	a_toolbar.Render();

	<inp2:m_if prefix="cf" function="IsSingle"/>
	a_toolbar.HideButton('prev');
	a_toolbar.HideButton('next');
	a_toolbar.HideButton('sep1');
	<inp2:m_else/>
	<inp2:m_if prefix="cf" function="IsLast"/>
	a_toolbar.DisableButton('next');
	<inp2:m_endif/>
	<inp2:m_if prefix="cf" function="IsFirst"/>
	a_toolbar.DisableButton('prev');
	<inp2:m_endif/>
	<inp2:m_endif/>
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<script src="incs/calendar.js"></script>





	<inp2:m_ParseBlock name="inp_edit_hidden" prefix="cf" field="Type" db="db"/>

	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<inp2:m_ParseBlock name="subsection" title="!la_section_General!"/>


	<inp2:m_ParseBlock name="inp_id_label" prefix="cf" field="CustomFieldId" title="!la_prompt_FieldId!"/>


	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="FieldName" title="!la_prompt_FieldName!" size="40"/>

	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="FieldLabel" title="!la_prompt_FieldLabel!" size="40"/>

	<inp2:m_ParseBlock name="subsection" title="!la_tab_AdminUI!"/>

	<inp2:m_ParseBlock name="inp_edit_checkbox" prefix="cf" field="OnGeneralTab" title="!la_prompt_showgeneraltab!"/>

	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="Heading" title="!la_prompt_heading!" size="40"/>

	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="Prompt" title="!la_prompt_FieldPrompt!" size="40"/>

	<inp2:m_ParseBlock name="inp_edit_options" prefix="cf" field="ElementType" title="!la_prompt_InputType!" size="20" use_phrases="1"/>

	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="ValueList" title="!la_prompt_valuelist!" size="40"/>

	<inp2:m_ParseBlock name="inp_edit_box" prefix="cf" field="DisplayOrder" title="!la_field_displayorder!" size="10"/>

	<inp2:m_if check="m_IsDebugMode">
	<inp2:m_ParseBlock name="inp_edit_checkbox" prefix="cf" field="IsSystem" title="!la_fld_IsSystem!"/>
	</inp2:m_if>

	</table>

	<inp2:m_include t="incs/footer"/>

	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/custom_fields/custom_fields_edit.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/custom_fields/custom_fields_list.tpl
	===================================================================
	--- trunk/kernel/admin_templates/custom_fields/custom_fields_list.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/custom_fields/custom_fields_list.tpl (revision 4842)
	@@ -1,68 +1,69 @@
	+<inp2:m_RequireLogin perm_event="cf:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" prefix="cf" icon="icon46_settings_custom" title="!la_tab_ConfigCustom!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="cf" title_preset="custom_fields_list" module="in-portal" icon="icon46_settings_custom"/>

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

	var a_toolbar = new ToolBar();
	a_toolbar.AddButton( new ToolBarButton('new_item', '<inp2:m_phrase label="la_ToolTip_New_CustomField" escape="1"/>',
	function() {
	std_precreate_item('cf', 'custom_fields/custom_fields_edit')
	} ) );

	a_toolbar.AddButton( new ToolBarButton('edit', '<inp2:m_phrase label="la_ToolTip_Edit" escape="1"/>', edit) );
	a_toolbar.AddButton( new ToolBarButton('delete', '<inp2:m_phrase label="la_ToolTip_Delete" escape="1"/>',
	function() {
	std_delete_items('cf')
	} ) );

	a_toolbar.AddButton( new ToolBarSeparator('sep1') );
	<inp2:m_if check="m_isDebugMode">

	a_toolbar.AddButton( new ToolBarButton('clone', '<inp2:m_phrase label="la_ToolTip_Clone" escape="1"/>',
	function() {
	submit_event('cf', 'OnMassClone')
	} ) );

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

	a_toolbar.Render();
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:m_block name="cf_grid_data_td" />
	<td valign="top" class="text"><inp2:$PrefixSpecial_field field="$field" grid="$grid" no_special="no_special" as_label="1" /></td>
	<inp2:m_blockend />


	<inp2:m_block name="preview" />
	<inp2:m_ParseBlock name="preview_td" PrefixSpecial="$PrefixSpecial" field="$field" type="auto" max_width="100" max_height="100"/>
	<inp2:m_blockend />

	<inp2:m_ParseBlock name="grid" PrefixSpecial="cf" IdField="CustomFieldId" grid="Default" header_block="grid_column_title" data_block="grid_data_td" search="on"/>
	<script type="text/javascript">
	Grids['cf'].SetDependantToolbarButtons( new Array('edit','delete', 'clone') );
	</script>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/custom_fields/custom_fields_list.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.3
	\ No newline at end of property
	+1.4
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/index.tpl
	===================================================================
	--- trunk/kernel/admin_templates/index.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/index.tpl (revision 4842)
	@@ -1,47 +1,47 @@
	<inp2:m_RequireLogin login_template="login"/>
	<inp2:adm_SetConst name="DBG_SKIP_REPORTING" value="1"/>
	<!--DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">-->
	<html>
	<head>
	<meta http-equiv="content-type" content="text/html;charset=<inp2:lang_GetCharset/>">
	<title>In-portal Administration</title>

	<script type="text/javascript">
	window.name = 'main_frame';
	lala = navigator.appVersion.substring(0,1);

	if (navigator.appName == "Netscape") {
	if (lala != "5") {
	document.write("<frameset rows='96,*' framespacing='0' scrolling='no' frameborder='0'>");
	} else {
	document.write("<frameset rows='95,*' framespacing='0' scrolling='no' frameborder='0'>");
	}
	} else {
	document.write("<frameset rows='94,*' framespacing='0' scrolling='no' frameborder='0'>");
	}

	function getFrame($name)
	{
	var $frameset = window.frames;
	for ($i = 0; $i < window.length; $i++) {
	if ($frameset[$i].name == $name) {
	return $frameset[$i];
	}
	}
	return window;
	}
	</script>
	</head>

	- <frame src="<inp2:m_t t="head" pass="m"/>" name="head" scrolling="no" noresize>
	+ <frame src="<inp2:m_t t="head" pass="m" m_cat_id="0"/>" name="head" scrolling="no" noresize>
	<frameset cols="200,*" border="0">
	- <frame src="<inp2:m_t t="tree" pass="m"/>" name="menu" target="main" noresize scrolling="auto" marginwidth="0" marginheight="0">
	- <frame src="<inp2:m_t t="sections_list" section="in-portal:root" module="In-Portal" pass="m"/>" name="main" marginwidth="0" marginheight="0" frameborder="no" noresize scrolling="auto">
	+ <frame src="<inp2:m_t t="tree" pass="m" m_cat_id="0"/>" name="menu" target="main" noresize scrolling="auto" marginwidth="0" marginheight="0">
	+ <frame src="<inp2:m_t t="sections_list" section="in-portal:root" module="In-Portal" pass="m" m_cat_id="0"/>" name="main" marginwidth="0" marginheight="0" frameborder="no" noresize scrolling="auto">
	</frameset>
	</frameset>
	<noframes>
	<body bgcolor="#ffffff">
	<p></p>
	</body>
	</noframes>
	</html>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/index.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/config/config_general.tpl
	===================================================================
	--- trunk/kernel/admin_templates/config/config_general.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/config/config_general.tpl (revision 4842)
	@@ -1,101 +1,102 @@
	+<inp2:m_RequireLogin perm_event="conf:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">

	<inp2:m_ParseBlock name="section_header" prefix="conf" icon="icon46_settings_general" title="!la_tab_ConfigGeneral!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="conf" title_preset="config_list_general" icon="icon46_settings_general"/>


	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">

	function ValidatePassFld(fieldId){
	var passFld=document.getElementById(fieldId);
	var passVerifyFld=document.getElementById('verify_'+fieldId);
	if (passFld && passVerifyFld && passFld.value == passVerifyFld.value) {
	return true;
	}
	else {
	var passErrorCell=document.getElementById('error_'+fieldId);
	if (passErrorCell){
	passErrorCell.innerHTML='<inp2:m_phrase name="la_error_PasswordMatch" />';
	}
	return false;
	}
	}

	function ValidatePassFields(){
	var el=false;
	var validated=true;
	for (var i=0; i<document.forms.kernel_form.elements.length; i++){
	el=document.forms.kernel_form.elements[i];
	if (el.getAttribute('primarytype')=='password'){
	if (!ValidatePassFld(el.id)){
	validated=false;
	}
	}
	}
	return validated;
	}

	var a_toolbar = new ToolBar();
	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	if (ValidatePassFields()){
	submit_event('conf','<inp2:conf_SaveEvent/>');
	}
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	submit_event('conf','OnCancel');
	}
	) );

	a_toolbar.Render();
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:m_include t="incs/config_blocks"/>

	<inp2:conf_SaveWarning name="grid_save_warning"/>
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<!-- module root category selector: begin -->
	<tr class="subsectiontitle">
	<td colspan="2">
	<inp2:m_phrase name="la_Text_RootCategory" />
	</td>
	</tr>

	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
	<td>
	<span class="text">
	<inp2:m_phrase name="la_prompt_RootCategory" />
	</span>
	</td>
	<td>
	<inp2:m_DefineElement name="category_caption">
	<inp2:m_param name="separator"/><inp2:m_param name="cat_name"/>
	</inp2:m_DefineElement>

	<inp2:m_DefineElement name="root_cat_caption" />
	<inp2:m_param name="cat_name"/>
	</inp2:m_DefineElement>

	<b><inp2:c_RootCategoryName/><inp2:conf_CategoryPath separator=" > " rootcatblock="root_cat_caption" block="category_caption" /></b>
	<input type="hidden" name="conf[ModuleRootCategory][VariableValue]" value="<inp2:conf_ModuleRootCategory/>"/>
	<a href="javascript:openSelector('conf', '<inp2:m_t t="category_selector" pass="all,conf"/>', 'ModuleRootCategory');"><img src="img/icons/icon24_cat.gif" border="0" align="absmiddle" /></a>
	</td>
	</tr>
	<!-- module root category selector: end -->

	<inp2:conf_PrintList block="config_block" per_page="-1" full_block="config_block" half_block1="config_block1" half_block2="config_block2"/>
	</table>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/config/config_general.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2
	\ No newline at end of property
	+1.3
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/config/config_search.tpl
	===================================================================
	--- trunk/kernel/admin_templates/config/config_search.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/config/config_search.tpl (revision 4842)
	@@ -1,132 +1,133 @@
	+<inp2:m_RequireLogin perm_event="confs:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" prefix="confs" icon="icon46_settings_search" title="!la_tab_ConfigSearch!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="confs" title_preset="config_list_search" icon="icon46_settings_output"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	var a_toolbar = new ToolBar();
	<inp2:m_if check="m_IsDebugMode">
	a_toolbar.AddButton( new ToolBarButton('new_item', '<inp2:m_phrase label="la_ToolTip_NewSearchConfig" escape="1"/>', function() {
	std_new_item('confs', 'config/config_search_edit');
	}
	) );

	a_toolbar.AddButton( new ToolBarSeparator('sep2') );
	</inp2:m_if>

	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	submit_event('confs','<inp2:confs_SaveEvent/>');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	submit_event('confs','OnCancel');
	}
	) );

	a_toolbar.Render();
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:m_DefineElement name="confs_checkbox_td">
	<td valign="top" class="text">

	<inp2:m_if check="m_ParamEquals" name="nolabel" value="true">
	<inp2:m_else />
	<label for="_cb_<inp2:InputName field="$Field"/>"><inp2:m_Phrase label="$Label" /></label>
	</inp2:m_if>

	<input type="checkbox" name="_cb_<inp2:InputName field="$Field"/>" <inp2:Field field="$Field" checked="checked" db="db"/> id="_cb_<inp2:InputName field="$Field"/>" onclick="update_checkbox(this, document.getElementById('<inp2:InputName field="$Field"/>'))" >
	<input type="hidden" id="<inp2:InputName field="$Field"/>" name="<inp2:InputName field="$Field"/>" value="<inp2:Field field="$Field" db="db"/>">
	</td>
	</inp2:m_DefineElement>

	<inp2:m_DefineElement name="confs_edit_text">
	<td valign="top" class="text">
	<label for="<inp2:InputName field="$Field"/>"><inp2:m_Phrase label="$Label" /></label>
	<input type="text" name="<inp2:InputName field="$Field"/>" value="<inp2:Field field="$Field"/>" size="3" />
	</td>
	</inp2:m_DefineElement>

	<inp2:m_DefineElement name="confs_detail_row">
	<inp2:m_if check="m_ParamEquals" name="show_heading" value="1">
	<tr class="subsectiontitle">
	<td colspan="4">
	<inp2:Field name="ConfigHeader" as_label="1"/>
	</td>
	</tr>
	</inp2:m_if>

	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
	<td class="text">
	<inp2:Field field="DisplayName" as_label="true" />
	<inp2:m_if check="m_IsDebugMode">
	<br /><small>[ID: <b><inp2:Field name="SearchConfigId"/></b>; DisplayOrder: <b><inp2:Field name="DisplayOrder"/></b>; Field: <b><inp2:Field name="FieldName"/></b>]</small>
	</inp2:m_if>
	</td>
	<inp2:m_ParseBlock name="confs_checkbox_td" pass_params="true" IdField="SearchConfigId" Label="la_prompt_SimpleSearch" Field="SimpleSearch" />
	<inp2:m_ParseBlock name="confs_edit_text" pass_params="true" IdField="SearchConfigId" Label="la_prompt_weight" Field="Priority" />
	<inp2:m_ParseBlock name="confs_checkbox_td" pass_params="true" IdField="SearchConfigId" Label="la_prompt_AdvancedSearch" Field="AdvancedSearch" />
	</tr>
	</inp2:m_DefineElement>

	<inp2:m_DefineElement name="config_values">
	<tr class="subsectiontitle">
	<td colspan="4">
	<inp2:m_phrase name="$module_item" /> <inp2:m_phrase name="la_prompt_relevence_settings" />
	</td>
	</tr>

	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
	<td colspan="4">
	<inp2:m_phrase name="la_prompt_required_field_increase"/>
	<input type="text" size="3" name="conf[SearchRel_Increase_<inp2:m_param name="module_key" />][VariableValue]" VALUE="<inp2:Field field="SearchRel_Increase_{$module_key}" />">%
	</td>
	</tr>

	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
	<td colspan="4">
	<inp2:m_phrase name="la_prompt_relevence_percent"/>
	<input type="text" size="3" name="conf[SearchRel_Keyword_<inp2:m_param name="module_key" />][VariableValue]" value="<inp2:Field field="SearchRel_Keyword_{$module_key}" />">% <inp2:Field field="SearchRel_Keyword_{$module_key}_prompt" as_label="1" />
	<input type="text" size="3" name="conf[SearchRel_Pop_<inp2:m_param name="module_key" />][VariableValue]" value="<inp2:Field field="SearchRel_Pop_{$module_key}" />">% <inp2:Field field="SearchRel_Pop_{$module_key}_prompt" as_label="1" />
	<input type="text" size="3" name="conf[SearchRel_Rating_<inp2:m_param name="module_key" />][VariableValue]" value="<inp2:Field field="SearchRel_Rating_{$module_key}" />">% <inp2:Field field="SearchRel_Rating_{$module_key}_prompt" as_label="1" />
	</td>
	</tr>

	<inp2:m_if check="m_GetEquals" name="module" value="In-Portal" inverse="inverse">
	<tr class="subsectiontitle">
	<td colspan="4">
	<inp2:m_phrase name="$module_item" /> <inp2:m_phrase name="la_prompt_multipleshow" />
	</td>
	</tr>

	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
	<td class="text" width="120"><inp2:Field field="Search_ShowMultiple_{$module_key}_prompt" as_label="1"/></td>
	<td class="text" colspan="3">
	<input type="checkbox" name="_cb_conf[Search_ShowMultiple_<inp2:m_param name="module_key" />][VariableValue]" <inp2:Field field="Search_ShowMultiple_{$module_key}" checked="checked" db="db"/> id="_cb_conf[Search_ShowMultiple_<inp2:m_param name="module_key" />][VariableValue]" onclick="update_checkbox(this, document.getElementById('conf[Search_ShowMultiple_<inp2:m_param name="module_key" />][VariableValue]'))" >
	<input type="hidden" id="conf[Search_ShowMultiple_<inp2:m_param name="module_key" />][VariableValue]" name="conf[Search_ShowMultiple_<inp2:m_param name="module_key" />][VariableValue]" value="<inp2:Field field="Search_ShowMultiple_{$module_key}" db="db"/>">
	</td>
	</tr>
	</inp2:m_if>
	</inp2:m_DefineElement>

	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder"<inp2:m_if check="conf_ShowRelevance"> style="border-bottom-width: 0px;"</inp2:m_if>>
	<inp2:confs_PrintList render_as="confs_detail_row" />
	</table>

	<inp2:m_if check="conf_ShowRelevance">
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<inp2:conf_PrintConfList block="config_values" />
	</table>
	</inp2:m_if>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/config/config_search.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.8
	\ No newline at end of property
	+1.9
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/config/config_email.tpl
	===================================================================
	--- trunk/kernel/admin_templates/config/config_email.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/config/config_email.tpl (revision 4842)
	@@ -1,64 +1,65 @@
	+<inp2:m_RequireLogin perm_event="emailevents:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" prefix="emailevents.module" icon="icon46_settings_email" title="!la_title_emailevents!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="emailevents.module" title_preset="email_settings_list" icon="icon46_settings_email"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	//do not rename - this function is used in default grid for double click!
	function edit()
	{
	openSelector('emailevents.module', '<inp2:m_t t="user_selector" pass="all,emailevents.module" escape="1"/>', 'FromUserId', null, 'OnSaveSelected');
	}

	var a_toolbar = new ToolBar();

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


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

	a_toolbar.AddButton( new ToolBarButton('approve', '<inp2:m_phrase label="la_ToolTip_Enable" escape="1"/>', function() {
	submit_event('emailevents.module','OnMassApprove');
	}
	) );

	a_toolbar.AddButton( new ToolBarButton('decline', '<inp2:m_phrase label="la_ToolTip_Disable" escape="1"/>', function() {
	submit_event('emailevents.module','OnMassDecline');
	}
	) );

	a_toolbar.AddButton( new ToolBarButton('frontend_mail', '<inp2:m_phrase label="la_ToolTip_Email_FrontOnly" escape="1"/>', function() {
	submit_event('emailevents.module','OnFrontOnly');
	}
	) );

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

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

	a_toolbar.Render();
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:m_ParseBlock name="grid" PrefixSpecial="emailevents.module" IdField="EventId" grid="EmailSettings" header_block="grid_column_title" data_block="grid_data_td" search="on" has_filters="has_filters"/>
	<script type="text/javascript">
	Grids['emailevents.module'].SetDependantToolbarButtons( new Array('frontend_mail','usertogroup','approve','decline') );
	</script>

	<input type="hidden" name="emailevents.module_PopupSelectedUser" value="">

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/config/config_email.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/config/config_universal.tpl
	===================================================================
	--- trunk/kernel/admin_templates/config/config_universal.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/config/config_universal.tpl (revision 4842)
	@@ -1,70 +1,71 @@
	+<inp2:m_RequireLogin perm_event="conf:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" prefix="conf" icon="icon46_settings_#section#" title="!la_tab_Config#section#!"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="conf" title_preset="config_list_#section#" icon="icon46_settings_#section#"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">

	function ValidatePassFld(fieldId){
	var passFld=document.getElementById(fieldId);
	var passVerifyFld=document.getElementById('verify_'+fieldId);
	if (passFld && passVerifyFld && passFld.value == passVerifyFld.value) {
	return true;
	}
	else {
	var passErrorCell=document.getElementById('error_'+fieldId);
	if (passErrorCell){
	passErrorCell.innerHTML='<inp2:m_phrase name="la_error_PasswordMatch" />';
	}
	return false;
	}
	}

	function ValidatePassFields(){
	var el=false;
	var validated=true;
	for (var i=0; i<document.forms.kernel_form.elements.length; i++){
	el=document.forms.kernel_form.elements[i];
	if (el.getAttribute('primarytype')=='password'){
	if (!ValidatePassFld(el.id)){
	validated=false;
	}
	}
	}
	return validated;
	}

	var a_toolbar = new ToolBar();
	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	if (ValidatePassFields()){
	submit_event('conf','<inp2:conf_SaveEvent/>');
	}
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	submit_event('conf','OnCancel');
	}
	) );

	a_toolbar.Render();
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:m_include t="incs/config_blocks"/>

	<inp2:conf_SaveWarning name="grid_save_warning"/>
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<inp2:conf_PrintList block="config_block" per_page="-1" full_block="config_block" half_block1="config_block1" half_block2="config_block2"/>
	</table>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/config/config_universal.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/kernel/admin_templates/config/config_search_edit.tpl
	===================================================================
	--- trunk/kernel/admin_templates/config/config_search_edit.tpl (revision 4841)
	+++ trunk/kernel/admin_templates/config/config_search_edit.tpl (revision 4842)
	@@ -1,74 +1,75 @@
	+<inp2:m_RequireLogin perm_event="confs:OnLoad" system="1"/>
	<inp2:m_include t="incs/header" nobody="yes"/>

	<body topmargin="0" leftmargin="8" marginheight="0" marginwidth="8" bgcolor="#FFFFFF">
	<inp2:m_ParseBlock name="section_header" icon="icon46_settings_search" title="la_tab_ConfigSearch"/>

	<inp2:m_ParseBlock name="blue_bar" prefix="confs" title_preset="configsearch_edit" module="in-portal" icon="icon46_settings_search"/>

	<!-- ToolBar --->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<script type="text/javascript">
	a_toolbar = new ToolBar();
	a_toolbar.AddButton( new ToolBarButton('select', '<inp2:m_phrase label="la_ToolTip_Save" escape="1"/>', function() {
	submit_event('confs','<inp2:confs_SaveEvent/>');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('cancel', '<inp2:m_phrase label="la_ToolTip_Cancel" escape="1"/>', function() {
	submit_event('confs','OnGoBack');
	}
	) );

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

	a_toolbar.AddButton( new ToolBarButton('prev', '<inp2:m_phrase label="la_ToolTip_Prev" escape="1"/>', function() {
	go_to_id('confs', '<inp2:confs_PrevId/>');
	}
	) );
	a_toolbar.AddButton( new ToolBarButton('next', '<inp2:m_phrase label="la_ToolTip_Next" escape="1"/>', function() {
	go_to_id('confs', '<inp2:confs_NextId/>');
	}
	) );

	a_toolbar.Render();

	<inp2:m_if prefix="confs" function="IsSingle"/>
	a_toolbar.HideButton('prev');
	a_toolbar.HideButton('next');
	a_toolbar.HideButton('sep1');
	<inp2:m_else/>
	<inp2:m_if prefix="confs" function="IsLast"/>
	a_toolbar.DisableButton('next');
	<inp2:m_endif/>
	<inp2:m_if prefix="confs" function="IsFirst"/>
	a_toolbar.DisableButton('prev');
	<inp2:m_endif/>
	<inp2:m_endif/>
	</script>
	</td>
	</tr>
	</tbody>
	</table>

	<inp2:confs_SaveWarning name="grid_save_warning"/>
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<inp2:m_ParseBlock name="subsection" title="!la_section_General!"/>

	<inp2:m_ParseBlock name="inp_id_label" prefix="confs" field="SearchConfigId" title="la_fld_SearchConfigId"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="TableName" title="la_fld_TableName"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="FieldName" title="la_fld_FieldName"/>
	<inp2:m_ParseBlock name="inp_edit_checkbox" prefix="confs" field="SimpleSearch" title="la_fld_SimpleSearch"/>
	<inp2:m_ParseBlock name="inp_edit_checkbox" prefix="confs" field="AdvancedSearch" title="la_fld_AdvancedSearch"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="Description" title="la_fld_Description"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="DisplayName" title="la_fld_DisplayName"/>
	<inp2:m_ParseBlock name="inp_edit_options" prefix="confs" field="ModuleName" title="la_fld_ModuleName"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="ConfigHeader" title="la_fld_ConfigHeader"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="DisplayOrder" title="la_fld_DisplayOrder"/>
	<inp2:m_ParseBlock name="inp_edit_box" prefix="confs" field="Priority" title="la_fld_Priority"/>
	<inp2:m_ParseBlock name="inp_edit_options" prefix="confs" field="FieldType" title="la_fld_FieldType"/>
	</table>

	<inp2:m_include t="incs/footer"/>

	\ No newline at end of file

	Property changes on: trunk/kernel/admin_templates/config/config_search_edit.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.3
	\ No newline at end of property
	+1.4
	\ No newline at end of property
	Index: trunk/core/kernel/application.php
	===================================================================
	--- trunk/core/kernel/application.php (revision 4841)
	+++ trunk/core/kernel/application.php (revision 4842)
	@@ -1,2077 +1,2068 @@
	<?php

	/**
	* Basic class for Kernel3-based Application
	*
	* This class is a Facade for any other class which needs to deal with Kernel3 framework.<br>
	* The class incapsulates the main run-cycle of the script, provide access to all other objects in the framework.<br>
	* <br>
	* The class is a singleton, which means that there could be only one instance of KernelApplication in the script.<br>
	* This could be guranteed by NOT calling the class constuctor directly, but rather calling KernelApplication::Instance() method,
	* which returns an instance of the application. The method gurantees that it will return exactly the same instance for any call.<br>
	* See singleton pattern by GOF.
	* @package kernel4
	*/

	class kApplication {

	/**
	* Is true, when Init method was called already, prevents double initialization
	*
	* @var bool
	*/
	var $InitDone = false;

	/**
	* Holds internal TemplateParser object
	* @access private
	* @var TemplateParser
	*/
	var $Parser;

	/**
	* Holds parser output buffer
	* @access private
	* @var string
	*/
	var $HTML;

	/**
	* Prevents request from beeing proceeded twice in case if application init is called mere then one time
	*
	* @var bool
	* @todo This is not good anyway (by Alex)
	*/
	var $RequestProcessed = false;

	/**
	* The main Factory used to create
	* almost any class of kernel and
	* modules
	*
	* @access private
	* @var kFactory
	*/
	var $Factory;

	/**
	* All ConfigurationValues table content (hash) here
	*
	* @var Array
	* @access private
	*/
	var $ConfigHash = Array();

	/**
	* Ids of config variables used in current run (for caching)
	*
	* @var Array
	* @access private
	*/
	var $ConfigCacheIds = array();

	/**
	* Reference to debugger
	*
	* @var Debugger
	*/
	var $Debugger = null;

	/**
	* Holds all phrases used
	* in code and template
	*
	* @var PhrasesCache
	*/
	var $Phrases;

	/**
	* Modules table content, key - module name
	*
	* @var Array
	*/
	var $ModuleInfo = Array();

	/**
	* Holds DBConnection
	*
	* @var kDBConnection
	*/
	var $Conn = null;

	/**
	* Maintains list of user-defined error handlers
	*
	* @var Array
	*/
	var $errorHandlers = Array();


	// performance needs:
	/**
	* Holds a refererence to httpquery
	*
	* @var kHttpQuery
	*/
	var $HttpQuery = null;

	/**
	* Holds a reference to UnitConfigReader
	*
	* @var kUnitConfigReader
	*/
	var $UnitConfigReader = null;

	/**
	* Holds a reference to Session
	*
	* @var kSession
	*/
	var $Session = null;

	/**
	* Holds a ref to kEventManager
	*
	* @var kEventManager
	*/
	var $EventManager = null;

	var $Application = null;

	var $CompilationCache = array(); //used when compiling templates
	var $CachedProcessors = array(); //used when running compiled templates

	/**
	* Returns kApplication instance anywhere in the script.
	*
	* This method should be used to get single kApplication object instance anywhere in the
	* Kernel-based application. The method is guranteed to return the SAME instance of kApplication.
	* Anywhere in the script you could write:
	* <code>
	* $application =& kApplication::Instance();
	* </code>
	* or in an object:
	* <code>
	* $this->Application =& kApplication::Instance();
	* </code>
	* to get the instance of kApplication. Note that we call the Instance method as STATIC - directly from the class.
	* To use descendand of standard kApplication class in your project you would need to define APPLICATION_CLASS constant
	* BEFORE calling kApplication::Instance() for the first time. If APPLICATION_CLASS is not defined the method would
	* create and return default KernelApplication instance.
	* @static
	* @access public
	* @return kApplication
	*/
	function &Instance()
	{
	static $instance = false;

	if(!$instance)
	{
	safeDefine('APPLICATION_CLASS', 'kApplication');
	$class = APPLICATION_CLASS;
	$instance = new $class();
	$instance->Application =& $instance;
	}
	return $instance;
	}

	/**
	* Initializes the Application
	*
	* @access public
	* @see kHTTPQuery
	* @see Session
	* @see TemplatesCache
	* @return bool Was Init actually made now or before
	*/
	function Init()
	{
	if($this->InitDone) return false;

	if( defined('DEBUG_MODE') && $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->Debugger->appendMemoryUsage('Application before Init:');
	}
	if( !$this->isDebugMode() && !constOn('DBG_ZEND_PRESENT') )
	{
	error_reporting(0);
	ini_set('display_errors', 0);
	}
	if( !constOn('DBG_ZEND_PRESENT') )
	{
	$error_handler = set_error_handler( Array(&$this,'handleError') );
	if($error_handler) $this->errorHandlers[] = $error_handler;
	}

	$this->Conn = new kDBConnection(SQL_TYPE, Array(&$this, 'handleSQLError') );
	$this->Conn->Connect(SQL_SERVER, SQL_USER, SQL_PASS, SQL_DB);
	$this->Conn->debugMode = $this->isDebugMode();

	$this->Factory = new kFactory();
	$this->registerDefaultClasses();
	$this->Phrases = new PhrasesCache();
	$this->EventManager =& $this->Factory->makeClass('EventManager');
	$this->Factory->Storage['EventManager'] =& $this->EventManager;
	$this->RegisterDefaultBuildEvents();
	$this->SetDefaultConstants();

	$this->UnitConfigReader =& $this->recallObject('kUnitConfigReader');
	$this->UnitConfigReader->scanModules(MODULES_PATH);
	$this->registerModuleConstants();

	// extracted out of SetDefaultConstants because it uses ConfigValue which is read only in UnitConfigReader (optimization)
	$this->SetAdminDirectory();

	$rewrite_on = $this->ConfigValue('UseModRewrite');
	// admin=1 - when front is browsed using admin session
	$admin_on = getArrayValue($_REQUEST, 'admin') \|\| $this->IsAdmin();
	define('MOD_REWRITE', $rewrite_on && !$admin_on ? 1 : 0);

	$this->HttpQuery =& $this->recallObject('HTTPQuery');
	$this->Session =& $this->recallObject('Session');

	$this->HttpQuery->AfterInit();

	$this->UnitConfigReader->AfterConfigRead();

	$this->LoadCache();
	$this->InitConfig();

	// Module items are recalled during url parsing & PhrasesCache is needed already there,
	// because it's used in their build events. That's why phrases cache initialization is
	// called from kHTTPQuery in case when mod_rewrite is used
	if (!$this->RewriteURLs()) {
	$this->Phrases = new PhrasesCache();
	}

	$this->Phrases->Init('phrases');

	if(!$this->RecallVar('UserGroups')) {
	$session =& $this->recallObject('Session');
	$user_groups = trim($session->GetField('GroupList'), ',');
	if (!$user_groups) $user_groups = $this->ConfigValue('User_GuestGroup');
	$this->StoreVar('UserGroups', $user_groups);
	}

	if ($this->GetVar('m_cat_id') === false) $this->SetVar('m_cat_id', 0);
	if( !$this->RecallVar('curr_iso') ) $this->StoreVar('curr_iso', $this->GetPrimaryCurrency() );

	$this->SetVar('visits_id', $this->RecallVar('visit_id') );

	$language =& $this->recallObject( 'lang.current', null, Array('live_table' => true) );

	$this->HandleEvent( new kEvent('visits:OnRegisterVisit') );

	$this->ValidateLogin();

	if($this->isDebugMode()) {
	$this->Debugger->profileFinish('kernel4_startup');
	}

	$this->InitDone = true;
	return true;
	}

	/**
	* Returns module information. Searches module by requested field
	*
	* @param string $field
	* @param mixed $value
	* @param string field value to returns, if not specified, then return all fields
	* @param string field to return
	- * @param string field case-insensitive compare
	* @return Array
	*/
	- function findModule($field, $value, $return_field = null, $ci=false)
	+ function findModule($field, $value, $return_field = null)
	{
	$found = false;
	foreach ($this->ModuleInfo as $module_name => $module_info) {
	- if ($ci) {
	- if (strtolower($module_info[$field]) == strtolower($value)) {
	- $found = true;
	- break;
	- }
	- }
	- else {
	- if ($module_info[$field] == $value) {
	- $found = true;
	- break;
	- }
	+ if (strtolower($module_info[$field]) == strtolower($value)) {
	+ $found = true;
	+ break;
	}
	}

	if ($found) {
	return isset($return_field) ? $module_info[$return_field] : $module_info;
	}

	return false;
	}

	function refreshModuleInfo()
	{
	$modules_helper =& $this->recallObject('ModulesHelper');
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'Modules
	WHERE '.$modules_helper->getWhereClause().'
	ORDER BY LoadOrder';

	$this->ModuleInfo = $this->Conn->Query($sql, 'Name');
	$this->registerModuleConstants();
	}

	/**
	* Checks if passed language id if valid and sets it to primary otherwise
	*
	*/
	function VerifyLanguageId()
	{
	$language_id = $this->GetVar('m_lang');
	if (!$language_id) {
	$language_id = $this->GetDefaultLanguageId();
	if (!$language_id) {
	if (!$this->Application->IsAdmin()) {
	die ('No Primary Language Selected');
	}
	else {
	$language_id = 1;
	}
	}
	}
	$this->SetVar('lang.current_id', $language_id );
	$this->SetVar('m_lang', $language_id );

	$lang_mode = $this->GetVar('lang_mode');
	$this->SetVar('lang_mode', '');
	$lang =& $this->recallObject('lang.current');
	if ( !$lang->IsLoaded() \|\| (!$this->Application->IsAdmin() && !$lang->GetDBField('Enabled')) ) {
	if (!defined('IS_INSTALL')) die ('Unknown or disabled language');
	}
	$this->SetVar('lang_mode',$lang_mode);
	}

	/**
	* Checks if passed theme id if valid and sets it to primary otherwise
	*
	*/
	function VerifyThemeId()
	{
	if ($this->Application->IsAdmin()) return;

	$theme_id = $this->GetVar('m_theme');
	if (!$theme_id) {
	$theme_id = $this->GetDefaultThemeId();
	if (!$theme_id) {
	die('No Primary Theme Selected');
	}
	}
	$this->SetVar('m_theme', $theme_id);
	$this->SetVar('theme.current_id', $theme_id ); // KOSTJA: this is to fool theme' getPassedId
	$theme =& $this->recallObject('theme.current');
	if (!$theme->IsLoaded() \|\| !$theme->GetDBField('Enabled')) {
	if (!defined('IS_INSTALL')) die('Unknown or disabled theme');
	}
	}

	function GetDefaultLanguageId()
	{
	static $language_id = 0;

	if ($language_id > 0) return $language_id;

	$table = $this->getUnitOption('lang','TableName');
	$id_field = $this->getUnitOption('lang','IDField');
	$sql = 'SELECT '.$id_field.'
	FROM '.$table.'
	WHERE (PrimaryLang = 1) AND (Enabled = 1)';
	$language_id = $this->Conn->GetOne($sql);

	return $language_id;
	}

	function GetDefaultThemeId()
	{
	static $theme_id = 0;

	if($theme_id > 0) return $theme_id;

	if (constOn('DBG_FORCE_THEME')) {
	$theme_id = DBG_FORCE_THEME;
	}
	else {
	$table = $this->getUnitOption('theme','TableName');
	$id_field = $this->getUnitOption('theme','IDField');
	$sql = 'SELECT '.$id_field.'
	FROM '.$table.'
	WHERE (PrimaryTheme = 1) AND (Enabled = 1)';
	$theme_id = $this->Conn->GetOne($sql);
	}
	return $theme_id;
	}

	function GetPrimaryCurrency()
	{
	if ($this->isModuleEnabled('In-Commerce')) {
	$table = $this->getUnitOption('curr', 'TableName');
	return $this->Conn->GetOne('SELECT ISO FROM '.$table.' WHERE IsPrimary = 1');
	}
	else {
	return 'USD';
	}
	}

	/**
	* Registers default classes such as ItemController, GridController and LoginController
	*
	* Called automatically while initializing Application
	* @access private
	* @return void
	*/
	function RegisterDefaultClasses()
	{

	$this->registerClass('kTempTablesHandler', KERNEL_PATH.'/utility/temp_handler.php');
	$this->registerClass('kEventManager', KERNEL_PATH.'/event_manager.php', 'EventManager');
	$this->registerClass('kUnitConfigReader', KERNEL_PATH.'/utility/unit_config_reader.php');

	$this->registerClass('kArray', KERNEL_PATH.'/utility/params.php');
	$this->registerClass('Params', KERNEL_PATH.'/utility/params.php');

	$this->registerClass('kCache', KERNEL_PATH.'/utility/cache.php', 'Cache', Array('Params'));
	$this->registerClass('kHTTPQuery', KERNEL_PATH.'/utility/http_query.php', 'HTTPQuery', Array('Params') );

	$this->registerClass('Session', KERNEL_PATH.'/session/session.php');
	$this->registerClass('SessionStorage', KERNEL_PATH.'/session/session.php');



	$this->registerClass('Params', KERNEL_PATH.'/utility/params.php', 'kActions');

	/*$this->registerClass('kFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kOptionsFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kUploadFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kPictureFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kDateFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kLEFTFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kMultiLanguage', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kPasswordFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kCCDateFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kUnitFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kFilesizeFormatter', KERNEL_PATH.'/utility/formatters.php');
	$this->registerClass('kSerializedFormatter', KERNEL_PATH.'/utility/formatters.php');*/


	$this->registerClass('kMultipleFilter', KERNEL_PATH.'/utility/filters.php');
	$this->registerClass('kDBList', KERNEL_PATH.'/db/dblist.php');
	$this->registerClass('kDBItem', KERNEL_PATH.'/db/dbitem.php');
	$this->registerClass('kDBEventHandler', KERNEL_PATH.'/db/db_event_handler.php');

	$this->registerClass('kTagProcessor', KERNEL_PATH.'/processors/tag_processor.php');
	$this->registerClass('kMainTagProcessor', KERNEL_PATH.'/processors/main_processor.php','m_TagProcessor', 'kTagProcessor');
	$this->registerClass('kDBTagProcessor', KERNEL_PATH.'/db/db_tag_processor.php', null, 'kTagProcessor');

	$this->registerClass('TemplatesCache', KERNEL_PATH.'/parser/template.php');
	$this->registerClass('Template', KERNEL_PATH.'/parser/template.php');
	$this->registerClass('TemplateParser', KERNEL_PATH.'/parser/template_parser.php',null, 'kDBTagProcessor');

	$this->registerClass('kEmailMessage', KERNEL_PATH.'/utility/email.php');
	$this->registerClass('kSmtpClient', KERNEL_PATH.'/utility/smtp_client.php');

	if (file_exists(MODULES_PATH.'/in-commerce/units/currencies/currency_rates.php')) {
	$this->registerClass('kCurrencyRates', MODULES_PATH.'/in-commerce/units/currencies/currency_rates.php');
	}

	$this->registerClass('FCKeditor', FULL_PATH.'/admin/editor/cmseditor/fckeditor.php'); // need this?
	}

	function RegisterDefaultBuildEvents()
	{
	$event_manager =& $this->recallObject('EventManager');
	$event_manager->registerBuildEvent('kTempTablesHandler', 'OnTempHandlerBuild');
	}

	/**
	* Returns item's filename that corresponds id passed. If possible, then get it from cache
	*
	* @param string $prefix
	* @param int $id
	* @return string
	*/
	function getFilename($prefix, $id)
	{
	$filename = $this->getCache('filenames', $prefix.'_'.$id);
	if ($filename === false) {
	$table = $this->getUnitOption($prefix, 'TableName');
	$id_field = $this->getUnitOption($prefix, 'IDField');

	if ($prefix == 'c') {
	if(!$id) {
	$this->setCache('filenames', $prefix.'_'.$id, '');
	return '';
	}

	// this allows to save 2 sql queries for each category
	$sql = 'SELECT NamedParentPath, CachedCategoryTemplate, CachedItemTemplate
	FROM '.$table.'
	WHERE '.$id_field.' = '.$this->Conn->qstr($id);
	$category_data = $this->Conn->GetRow($sql);
	$filename = $category_data['NamedParentPath'];
	$this->setCache('category_templates', $id, $category_data['CachedCategoryTemplate']);
	$this->setCache('item_templates', $id, $category_data['CachedItemTemplate']);
	}
	else {
	$sql = 'SELECT Filename
	FROM '.$table.'
	WHERE '.$id_field.' = '.$this->Conn->qstr($id);
	$filename = $this->Conn->GetOne($sql);
	}
	$this->setCache('filenames', $prefix.'_'.$id, $filename);
	}
	return $filename;
	}


	/**
	* Adds new value to cache $cache_name and identified by key $key
	*
	* @param string $cache_name cache name
	* @param int $key key name to add to cache
	* @param mixed $value value of chached record
	*/
	function setCache($cache_name, $key, $value)
	{
	$cache =& $this->recallObject('Cache');
	$cache->setCache($cache_name, $key, $value);
	}

	/**
	* Returns cached $key value from cache named $cache_name
	*
	* @param string $cache_name cache name
	* @param int $key key name from cache
	* @return mixed
	*/
	function getCache($cache_name, $key)
	{
	$cache =& $this->recallObject('Cache');
	return $cache->getCache($cache_name, $key);
	}

	/**
	* Defines default constants if it's not defined before - in config.php
	*
	* @access private
	*/
	function SetDefaultConstants()
	{
	safeDefine('SERVER_NAME', $_SERVER['HTTP_HOST']);
	}

	function SetAdminDirectory()
	{
	$admin_dir = $this->ConfigValue('AdminDirectory');
	if(!$admin_dir) $admin_dir = 'admin';
	safeDefine('ADMIN_DIR', $admin_dir);
	}

	/**
	* Registers each module specific constants if any found
	*
	*/
	function registerModuleConstants()
	{
	if (!$this->ModuleInfo) return false;

	foreach($this->ModuleInfo as $module_name => $module_info)
	{
	$module_path = '/'.$module_info['Path'];
	$contants_file = FULL_PATH.$module_path.'constants.php';
	if( file_exists($contants_file) ) k4_include_once($contants_file);
	}
	return true;
	}

	function ProcessRequest()
	{
	$event_manager =& $this->recallObject('EventManager');

	if( $this->isDebugMode() && dbg_ConstOn('DBG_SHOW_HTTPQUERY') )
	{
	global $debugger;
	$http_query =& $this->recallObject('HTTPQuery');
	$debugger->appendHTML('HTTPQuery:');
	$debugger->dumpVars($http_query->_Params);
	}

	$event_manager->ProcessRequest();
	$event_manager->RunRegularEvents(reBEFORE);
	$this->RequestProcessed = true;
	}

	/**
	* Actually runs the parser against current template and stores parsing result
	*
	* This method gets t variable passed to the script, loads the template given in t variable and
	* parses it. The result is store in {@link $this->HTML} property.
	* @access public
	* @return void
	*/
	function Run()
	{
	if( $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->Debugger->appendMemoryUsage('Application before Run:');
	}

	if ($this->IsAdmin()) {
	// for permission checking in events & templates
	$this->LinkVar('module'); // for common configuration templates
	$this->LinkVar('section'); // for common configuration templates

	if ($this->GetVar('m_opener') == 'p') {
	$this->LinkVar('main_prefix'); // window prefix, that opened selector
	$this->LinkVar('dst_field'); // field to set value choosed in selector
	$this->LinkVar('return_template'); // template to go, when something was coosen from popup (from finalizePopup)
	}
	}

	if (!$this->RequestProcessed) $this->ProcessRequest();

	$this->InitParser();
	$template_cache =& $this->recallObject('TemplatesCache');
	$t = $this->GetVar('t');

	if ($this->isModuleEnabled('In-CMS')) {
	$cms_handler =& $this->recallObject('cms_EventHandler');
	if (!$template_cache->TemplateExists($t) && !$this->IsAdmin()) {
	$t = $cms_handler->GetDesignTemplate();
	}
	/*else {
	$cms_handler->SetCatByTemplate();
	}*/
	}

	if( $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->Debugger->appendMemoryUsage('Application before Parsing:');
	}

	$this->HTML = $this->Parser->Parse( $template_cache->GetTemplateBody($t), $t );

	if( $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->Debugger->appendMemoryUsage('Application after Parsing:');
	}
	}

	function InitParser()
	{
	if( !is_object($this->Parser) ) $this->Parser =& $this->recallObject('TemplateParser');
	}

	/**
	* Send the parser results to browser
	*
	* Actually send everything stored in {@link $this->HTML}, to the browser by echoing it.
	* @access public
	* @return void
	*/
	function Done()
	{
	if( $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->Debugger->appendMemoryUsage('Application before Done:');
	}

	if( $this->GetVar('admin') )
	{
	$reg = '/('.preg_quote(BASE_PATH, '/').'.\.html)(#.){0,1}(")/sU';
	$this->HTML = preg_replace($reg, "$1?admin=1$2$3", $this->HTML);
	}

	//eval("?".">".$this->HTML);

	echo $this->HTML;
	$this->UpdateCache();

	flush();

	if ($this->isDebugMode() && dbg_ConstOn('DBG_CACHE')) {
	$cache =& $this->recallObject('Cache');
	$cache->printStatistics();
	}

	$event_manager =& $this->recallObject('EventManager');
	$event_manager->RunRegularEvents(reAFTER);

	$session =& $this->recallObject('Session');
	$session->SaveData();
	//$this->SaveBlocksCache();
	}

	function SaveBlocksCache()
	{
	/*if (constOn('EXPERIMENTAL_PRE_PARSE')) {
	$data = serialize($this->PreParsedCache);

	$this->Conn->Query('REPLACE '.TABLE_PREFIX.'Cache (VarName, Data, Cached) VALUES ("blocks_cache", '.$this->Conn->qstr($data).', '.adodb_mktime().')');
	}*/
	}

	// Facade

	/**
	* Returns current session id (SID)
	* @access public
	* @return longint
	*/
	function GetSID()
	{
	$session =& $this->recallObject('Session');
	return $session->GetID();
	}

	function DestroySession()
	{
	$session =& $this->recallObject('Session');
	$session->Destroy();
	}

	/**
	* Returns variable passed to the script as GET/POST/COOKIE
	*
	* @access public
	* @param string $name Name of variable to retrieve
	* @param int $default default value returned in case if varible not present
	* @return mixed
	*/
	function GetVar($name, $default = false)
	{
	// $http_query =& $this->recallObject('HTTPQuery');
	return isset($this->HttpQuery->_Params[$name]) ? $this->HttpQuery->_Params[$name] : $default;
	}

	/**
	* Returns ALL variables passed to the script as GET/POST/COOKIE
	*
	* @access public
	* @return array
	*/
	function GetVars()
	{
	return $this->HttpQuery->GetParams();
	}

	/**
	* Set the variable 'as it was passed to the script through GET/POST/COOKIE'
	*
	* This could be useful to set the variable when you know that
	* other objects would relay on variable passed from GET/POST/COOKIE
	* or you could use SetVar() / GetVar() pairs to pass the values between different objects.<br>
	*
	* This method is formerly known as $this->Session->SetProperty.
	* @param string $var Variable name to set
	* @param mixed $val Variable value
	* @access public
	* @return void
	*/
	function SetVar($var,$val)
	{
	// $http_query =& $this->recallObject('HTTPQuery');
	return $this->HttpQuery->Set($var,$val);
	}

	/**
	* Deletes kHTTPQuery variable
	*
	* @param string $var
	* @todo think about method name
	*/
	function DeleteVar($var)
	{
	return $this->HttpQuery->Remove($var);
	}

	/**
	* Deletes Session variable
	*
	* @param string $var
	*/
	function RemoveVar($var)
	{
	return $this->Session->RemoveVar($var);
	}

	/**
	* Restores Session variable to it's db version
	*
	* @param string $var
	*/
	function RestoreVar($var)
	{
	return $this->Session->RestoreVar($var);
	}

	/**
	* Returns session variable value
	*
	* Return value of $var variable stored in Session. An optional default value could be passed as second parameter.
	*
	* @see SimpleSession
	* @access public
	* @param string $var Variable name
	* @param mixed $default Default value to return if no $var variable found in session
	* @return mixed
	*/
	function RecallVar($var,$default=false)
	{
	return $this->Session->RecallVar($var,$default);
	}

	/**
	* Stores variable $val in session under name $var
	*
	* Use this method to store variable in session. Later this variable could be recalled.
	* @see RecallVar
	* @access public
	* @param string $var Variable name
	* @param mixed $val Variable value
	*/
	function StoreVar($var, $val)
	{
	$session =& $this->recallObject('Session');
	$this->Session->StoreVar($var, $val);
	}

	function StoreVarDefault($var, $val)
	{
	$session =& $this->recallObject('Session');
	$this->Session->StoreVarDefault($var, $val);
	}

	/**
	* Links HTTP Query variable with session variable
	*
	* If variable $var is passed in HTTP Query it is stored in session for later use. If it's not passed it's recalled from session.
	* This method could be used for making sure that GetVar will return query or session value for given
	* variable, when query variable should overwrite session (and be stored there for later use).<br>
	* This could be used for passing item's ID into popup with multiple tab -
	* in popup script you just need to call LinkVar('id', 'current_id') before first use of GetVar('id').
	* After that you can be sure that GetVar('id') will return passed id or id passed earlier and stored in session
	* @access public
	* @param string $var HTTP Query (GPC) variable name
	* @param mixed $ses_var Session variable name
	* @param mixed $default Default variable value
	*/
	function LinkVar($var, $ses_var = null, $default = '')
	{
	if (!isset($ses_var)) $ses_var = $var;
	if ($this->GetVar($var) !== false) {
	$this->StoreVar($ses_var, $this->GetVar($var));
	}
	else {
	$this->SetVar($var, $this->RecallVar($ses_var, $default));
	}
	}

	/**
	* Returns variable from HTTP Query, or from session if not passed in HTTP Query
	*
	* The same as LinkVar, but also returns the variable value taken from HTTP Query if passed, or from session if not passed.
	* Returns the default value if variable does not exist in session and was not passed in HTTP Query
	*
	* @see LinkVar
	* @access public
	* @param string $var HTTP Query (GPC) variable name
	* @param mixed $ses_var Session variable name
	* @param mixed $default Default variable value
	* @return mixed
	*/
	function GetLinkedVar($var, $ses_var = null, $default = '')
	{
	$this->LinkVar($var, $ses_var, $default);
	return $this->GetVar($var);
	}

	function AddBlock($name, $tpl)
	{
	$this->cache[$name] = $tpl;
	}

	function SetTemplateBody($title,$body)
	{
	$templates_cache =& $this->recallObject('TemplatesCache');
	$templates_cache->SetTemplateBody($title,$body);
	}

	function ProcessTag($tag_data)
	{
	$a_tag = new Tag($tag_data,$this->Parser);
	return $a_tag->DoProcessTag();
	}

	function ProcessParsedTag($prefix, $tag, $params)
	{
	$a_tag = new Tag('',$this->Parser);
	$a_tag->Tag = $tag;
	$a_tag->Processor = $prefix;
	$a_tag->NamedParams = $params;
	return $a_tag->DoProcessTag();
	}

	/**
	* Return ADODB Connection object
	*
	* Returns ADODB Connection object already connected to the project database, configurable in config.php
	* @access public
	* @return kDBConnection
	*/
	function &GetADODBConnection()
	{
	return $this->Conn;
	}

	function ParseBlock($params,$pass_params=0,$as_template=false)
	{
	if (substr($params['name'], 0, 5) == 'html:') return substr($params['name'], 6);
	return $this->Parser->ParseBlock($params, $pass_params, $as_template);
	}

	/**
	* Returns index file, that could be passed as parameter to method, as parameter to tag and as constant or not passed at all
	*
	* @param string $prefix
	* @param string $index_file
	* @param Array $params
	* @return string
	*/
	function getIndexFile($prefix, $index_file, &$params)
	{
	if (isset($params['index_file'])) {
	$index_file = $params['index_file'];
	unset($params['index_file']);
	return $index_file;
	}

	if (isset($index_file)) {
	return $index_file;
	}

	if (defined('INDEX_FILE')) {
	return INDEX_FILE;
	}

	$cut_prefix = trim(BASE_PATH, '/').'/'.trim($prefix, '/');
	return trim(preg_replace('/'.preg_quote($cut_prefix, '/').'(.*)/', '\\1', $_SERVER['PHP_SELF']), '/');
	}

	/**
	* Return href for template
	*
	* @access public
	* @param string $t Template path
	* @var string $prefix index.php prefix - could be blank, 'admin'
	*/
	function HREF($t, $prefix='', $params=null, $index_file=null)
	{
	if(!$t) $t = $this->GetVar('t'); // moved from kMainTagProcessor->T()

	if ($this->GetVar('skip_last_template')) {
	$params['opener'] = 'p';
	$this->SetVar('m_opener', 'p');
	}

	if ($t == 'incs/close_popup') {
	// because this template closes the popup and we don't need popup mark here anymore
	$params['m_opener'] = 's';
	}

	if( substr($t, -4) == '.tpl' ) $t = substr($t, 0, strlen($t) - 4 );

	if ( $this->IsAdmin() && $prefix == '') $prefix = '/admin';
	if ( $this->IsAdmin() && $prefix == '_FRONT_END_') $prefix = '';

	$index_file = $this->getIndexFile($prefix, $index_file, $params);

	$ssl = isset($params['__SSL__']) ? $params['__SSL__'] : null;
	if ($ssl !== null) {
	$session =& $this->recallObject('Session');
	$cookie_url = $session->CookieDomain.$session->CookiePath;
	if ($ssl) {
	$target_url = $this->ConfigValue('SSL_URL');
	}
	else {
	$target_url = 'http://'.DOMAIN.$this->ConfigValue('Site_Path');
	}

	if (!preg_match('#'.preg_quote($cookie_url).'#', $target_url)) {
	$session->SetMode(smGET_ONLY);
	}
	}

	if (getArrayValue($params, 'opener') == 'u') {
	$opener_stack=$this->RecallVar('opener_stack');
	if($opener_stack) {
	$opener_stack=unserialize($opener_stack);
	if (count($opener_stack) > 0) {
	list($index_file, $env) = explode('\|', $opener_stack[count($opener_stack)-1]);
	$ret = $this->BaseURL($prefix, $ssl).$index_file.'?'.ENV_VAR_NAME.'='.$env;
	if( getArrayValue($params,'escape') ) $ret = addslashes($ret);
	return $ret;
	}
	else {
	//define('DBG_REDIRECT', 1);
	$t = $this->GetVar('t');
	}
	}
	else {
	//define('DBG_REDIRECT', 1);
	$t = $this->GetVar('t');
	}
	}

	$pass = isset($params['pass']) ? $params['pass'] : '';
	$pass_events = isset($params['pass_events']) ? $params['pass_events'] : false; // pass events with url

	$map_link = '';
	if( isset($params['anchor']) )
	{
	$map_link = '#'.$params['anchor'];
	unset($params['anchor']);
	}

	if ( isset($params['no_amp']) )
	{
	$params['__URLENCODE__'] = $params['no_amp'];
	unset($params['no_amp']);
	}

	$no_rewrite = false;
	if( isset($params['__NO_REWRITE__']) )
	{
	$no_rewrite = true;
	unset($params['__NO_REWRITE__']);
	}
	if ($this->RewriteURLs($ssl) && !$no_rewrite)
	{
	$session =& $this->recallObject('Session');
	if( $session->NeedQueryString() ) $params['sid'] = $this->GetSID();
	$url = $this->BuildEnv_NEW($t, $params, $pass, $pass_events);
	$ret = $this->BaseURL($prefix, $ssl).$url.$map_link;
	}
	else
	{
	$env = $this->BuildEnv($t, $params, $pass, $pass_events);
	$ret = $this->BaseURL($prefix, $ssl).$index_file.'?'.$env.$map_link;
	}

	return $ret;
	}


	/**
	* Returns sorted array of passed prefixes (to build url from)
	*
	* @param string $pass
	* @return Array
	*/
	function getPassInfo($pass = 'all')
	{
	$pass = str_replace('all', trim($this->GetVar('passed'), ','), $pass);

	if (!$pass) {
	return Array();
	}

	$pass_info = array_unique( explode(',', $pass) ); // array( prefix[.special], prefix[.special] ...
	sort($pass_info, SORT_STRING); // to be prefix1,prefix1.special1,prefix1.special2,prefix3.specialX

	// ensure that "m" prefix is at the beginning
	$main_index = array_search('m', $pass_info);
	if ($main_index !== false) {
	unset($pass_info[$main_index]);
	array_unshift($pass_info, 'm');
	}
	return $pass_info;
	}

	function BuildEnv_NEW($t, $params, $pass = 'all', $pass_events = false)
	{
	// $session =& $this->recallObject('Session');
	$force_admin = getArrayValue($params,'admin') \|\| $this->GetVar('admin');

	// if($force_admin) $sid = $this->GetSID();

	$ret = '';
	$env = '';

	$encode = false;
	if (isset($params['__URLENCODE__']))
	{
	$encode = $params['__URLENCODE__'];
	unset($params['__URLENCODE__']);
	}

	if (isset($params['__SSL__'])) {
	unset($params['__SSL__']);
	}

	$pass_info = $this->getPassInfo($pass);
	if ($pass_info) {
	if ($pass_info[0] == 'm') array_shift($pass_info);
	$params['t'] = $t;
	foreach($pass_info as $pass_index => $pass_element)
	{
	list($prefix) = explode('.', $pass_element);
	$require_rewrite = $this->findModule('Var', $prefix);
	if ($require_rewrite) {
	// if next prefix is same as current, but with special => exclude current prefix from url
	$next_prefix = getArrayValue($pass_info, $pass_index + 1);
	if ($next_prefix) {
	$next_prefix = substr($next_prefix, 0, strlen($prefix) + 1);
	if ($prefix.'.' == $next_prefix) continue;
	}

	$ret .= '/'.$this->BuildModuleEnv_NEW($pass_element, $params, $pass_events);
	}
	else
	{
	$env .= ':'.$this->BuildModuleEnv($pass_element, $params, $pass_events);
	}
	}
	$ret = $this->BuildModuleEnv_NEW('m', $params, $pass_events).$ret;

	$ret = trim($ret, '/').'.html';
	if($env) $params[ENV_VAR_NAME] = ltrim($env, ':');
	}

	unset($params['pass'], $params['opener'], $params['m_event']);
	if ($force_admin) $params['admin'] = 1;

	if( getArrayValue($params,'escape') )
	{
	$ret = addslashes($ret);
	unset($params['escape']);
	}

	$params_str = '';
	$join_string = $encode ? '&' : '&';
	foreach ($params as $param => $value)
	{
	$params_str .= $join_string.$param.'='.$value;
	}
	$ret .= preg_replace('/^'.$join_string.'(.*)/', '?\\1', $params_str);

	if ($encode) {
	$ret = str_replace('\\', '%5C', $ret);
	}
	return $ret;
	}


	function BuildModuleEnv_NEW($prefix_special, &$params, $pass_events = false)
	{
	$event_params = Array('pass_events' => $pass_events, 'url_params' => $params);
	$event = new kEvent($prefix_special.':BuildEnv', $event_params);
	$this->HandleEvent($event);
	$params = $event->getEventParam('url_params'); // save back unprocessed parameters

	$ret = '';
	if ($event->getEventParam('env_string')) {
	$ret = trim( $event->getEventParam('env_string'), '/');
	}
	return $ret;
	}

	/**
	* Builds env part that corresponds prefix passed
	*
	* @param string $prefix_special item's prefix & [special]
	* @param Array $params url params
	* @param bool $pass_events
	*/
	function BuildModuleEnv($prefix_special, &$params, $pass_events = false)
	{
	list($prefix) = explode('.', $prefix_special);
	$query_vars = $this->getUnitOption($prefix, 'QueryString');

	//if pass events is off and event is not implicity passed
	if( !$pass_events && !isset($params[$prefix_special.'_event']) ) {
	$params[$prefix_special.'_event'] = ''; // remove event from url if requested
	//otherwise it will use value from get_var
	}

	if(!$query_vars) return '';

	$tmp_string = Array(0 => $prefix_special);
	foreach($query_vars as $index => $var_name)
	{
	//if value passed in params use it, otherwise use current from application
	$var_name = $prefix_special.'_'.$var_name;
	$tmp_string[$index] = isset( $params[$var_name] ) ? $params[$var_name] : $this->GetVar($var_name);
	if ( isset($params[$var_name]) ) unset( $params[$var_name] );
	}

	$escaped = array();
	foreach ($tmp_string as $tmp_val) {
	$escaped[] = str_replace(Array('-',':'), Array('\-','\:'), $tmp_val);
	}

	$ret = implode('-', $escaped);
	if ($this->getUnitOption($prefix, 'PortalStyleEnv') == true)
	{
	$ret = preg_replace('/^([a-zA-Z]+)-([0-9]+)-(.*)/','\\1\\2-\\3', $ret);
	}
	return $ret;
	}

	function BuildEnv($t, $params, $pass='all', $pass_events = false, $env_var = true)
	{
	$session =& $this->recallObject('Session');
	$ssl = isset($params['__SSL__']) ? $params['__SSL__'] : 0;
	$sid = $session->NeedQueryString() && !$this->RewriteURLs($ssl) ? $this->GetSID() : '';
	if (getArrayValue($params,'admin') == 1) $sid = $this->GetSID();

	$ret = '';
	if ($env_var) {
	$ret = ENV_VAR_NAME.'=';
	}

	$ret .= $sid.(constOn('INPORTAL_ENV') ? '-' : ':');

	$encode = false;
	if (isset($params['__URLENCODE__'])) {
	$encode = $params['__URLENCODE__'];
	unset($params['__URLENCODE__']);
	}

	if (isset($params['__SSL__'])) {
	unset($params['__SSL__']);
	}

	$env_string = '';
	$category_id = isset($params['m_cat_id']) ? $params['m_cat_id'] : $this->GetVar('m_cat_id');

	$item_id = 0;
	$pass_info = $this->getPassInfo($pass);
	if ($pass_info) {
	if ($pass_info[0] == 'm') array_shift($pass_info);
	foreach ($pass_info as $pass_element) {
	list($prefix) = explode('.', $pass_element);
	$require_rewrite = $this->findModule('Var', $prefix);
	if ($require_rewrite) {
	$item_id = isset($params[$pass_element.'_id']) ? $params[$pass_element.'_id'] : $this->GetVar($pass_element.'_id');
	}
	$env_string .= ':'.$this->BuildModuleEnv($pass_element, $params, $pass_events);
	}
	}

	if (strtolower($t) == '__default__') {
	// to put category & item templates into cache
	$filename = $this->getFilename('c', $category_id);
	if ($item_id) {
	$t = $this->getCache('item_templates', $category_id);
	}
	elseif ($category_id) {
	$t = $this->getCache('category_templates', $category_id);
	}
	else {
	$t = 'index';
	}
	}

	$ret .= $t.':'.$this->BuildModuleEnv('m', $params, $pass_events).$env_string;

	unset($params['pass']);
	unset($params['opener']);
	unset($params['m_event']);

	if ($this->GetVar('admin') && !isset($params['admin'])) {
	$params['admin'] = 1;
	}

	if( getArrayValue($params,'escape') )
	{
	$ret = addslashes($ret);
	unset($params['escape']);
	}

	$join_string = $encode ? '&' : '&';
	$params_str = '';
	foreach ($params as $param => $value)
	{
	$params_str .= $join_string.$param.'='.$value;
	}
	$ret .= $params_str;

	if ($encode) {
	$ret = str_replace('\\', '%5C', $ret);
	}
	return $ret;
	}

	function BaseURL($prefix='', $ssl=null)
	{
	if ($ssl === null) {
	return PROTOCOL.SERVER_NAME.(defined('PORT')?':'.PORT : '').rtrim(BASE_PATH, '/').$prefix.'/';
	}
	else {
	if ($ssl) {
	return rtrim( $this->ConfigValue('SSL_URL'), '/').$prefix.'/';
	}
	else {
	return 'http://'.DOMAIN.(defined('PORT')?':'.PORT : '').rtrim( $this->ConfigValue('Site_Path'), '/').$prefix.'/';
	}
	}
	}

	function Redirect($t='', $params=null, $prefix='', $index_file=null)
	{
	if ($t == '' \|\| $t === true) $t = $this->GetVar('t');

	// pass prefixes and special from previous url
	$js_redirect = getArrayValue($params, 'js_redirect');
	if( isset($params['js_redirect']) ) unset($params['js_redirect']);

	if (!isset($params['pass'])) $params['pass'] = 'all';
	$params['__URLENCODE__'] = 1;
	$location = $this->HREF($t, $prefix, $params, $index_file);
	$a_location = $location;
	$location = "Location: $location";
	//echo " location : $location <br>";


	if( $this->isDebugMode() && dbg_ConstOn('DBG_REDIRECT') )
	{
	/*if( function_exists('apache_response_headers') )
	{
	$this->Debugger->appendHTML('Apache Responce Headers');
	$this->Debugger->dumpVars( apache_response_headers() );

	$this->Debugger->appendHTML('Apache Request Headers');
	$this->Debugger->dumpVars( apache_request_headers() );
	}*/
	$this->Debugger->appendTrace();
	echo "<b>Debug output above!!!</b> Proceed to redirect: <a href=\"$a_location\">$a_location</a><br>";
	}
	else
	{
	if($js_redirect)
	{
	$this->SetVar('t', 'redirect');
	$this->SetVar('redirect_to_js', addslashes($a_location) );
	$this->SetVar('redirect_to', $a_location);
	return true;
	}
	else
	{
	if(headers_sent() != '')
	{
	echo '<script language="javascript" type="text/javascript">window.location.href = \''.$a_location.'\';</script>';
	}
	else
	{
	header("$location");
	}
	}
	}

	$session =& $this->recallObject('Session');
	$session->SaveData();
	$this->SaveBlocksCache();
	exit;
	}

	function Phrase($label)
	{
	return $this->Phrases->GetPhrase($label);
	}

	/**
	* Replace language tags in exclamation marks found in text
	*
	* @param string $text
	* @param bool $force_escape force escaping, not escaping of resulting string
	* @return string
	* @access public
	*/
	function ReplaceLanguageTags($text, $force_escape=null)
	{
	// !!!!!!!!
	// if( !is_object($this->Phrases) ) $this->Debugger->appendTrace();
	return $this->Phrases->ReplaceLanguageTags($text,$force_escape);
	}

	/**
	* Checks if user is logged in, and creates
	* user object if so. User object can be recalled
	* later using "u" prefix. Also you may
	* get user id by getting "u_id" variable.
	*
	* @access private
	*/
	function ValidateLogin()
	{
	$session =& $this->recallObject('Session');
	$user_id = $session->GetField('PortalUserId');
	if (!$user_id && $user_id != -1) $user_id = -2;
	$this->SetVar('u_id', $user_id);
	$this->StoreVar('user_id', $user_id);

	if ($this->GetVar('expired') == 1) {
	$user =& $this->recallObject('u');
	$user->SetError('ValidateLogin', 'session_expired', 'la_text_sess_expired');
	}

	if (($user_id != -2) && constOn('DBG_REQUREST_LOG') ) {
	$http_query =& $this->recallObject('HTTPQuery');
	$http_query->writeRequestLog(DBG_REQUREST_LOG);
	}
	}

	function LoadCache() {
	$cache_key = $this->GetVar('t').$this->GetVar('m_theme').$this->GetVar('m_lang').$this->IsAdmin();
	$query = sprintf("SELECT PhraseList, ConfigVariables FROM %s WHERE Template = %s",
	TABLE_PREFIX.'PhraseCache',
	$this->Conn->Qstr(md5($cache_key)));
	$res = $this->Conn->GetRow($query);

	if ($res) {
	$this->Caches['PhraseList'] = $res['PhraseList'] ? explode(',', $res['PhraseList']) : array();

	$config_ids = $res['ConfigVariables'] ? explode(',', $res['ConfigVariables']) : array();
	$config_ids = array_diff($config_ids, $this->Caches['ConfigVariables']);
	}
	else {
	$config_ids = array();
	}
	$this->Caches['ConfigVariables'] = $config_ids;
	$this->ConfigCacheIds = $config_ids;
	}

	function UpdateCache()
	{
	$update = false;
	//something changed
	$update = $update \|\| $this->Phrases->NeedsCacheUpdate();
	$update = $update \|\| (count($this->ConfigCacheIds) && $this->ConfigCacheIds != $this->Caches['ConfigVariables']);
	if ($update) {
	$cache_key = $this->GetVar('t').$this->GetVar('m_theme').$this->GetVar('m_lang').$this->IsAdmin();
	$query = sprintf("REPLACE %s (PhraseList, CacheDate, Template, ConfigVariables)
	VALUES (%s, %s, %s, %s)",
	TABLE_PREFIX.'PhraseCache',
	$this->Conn->Qstr(join(',', $this->Phrases->Ids)),
	adodb_mktime(),
	$this->Conn->Qstr(md5($cache_key)),
	$this->Conn->qstr(implode(',', array_unique($this->ConfigCacheIds))));
	$this->Conn->Query($query);
	}
	}

	function InitConfig()
	{
	if (isset($this->Caches['ConfigVariables']) && count($this->Caches['ConfigVariables']) > 0) {
	$this->ConfigHash = array_merge($this->ConfigHash, $this->Conn->GetCol(
	'SELECT VariableValue, VariableName FROM '.TABLE_PREFIX.'ConfigurationValues
	WHERE VariableId IN ('.implode(',', $this->Caches['ConfigVariables']).')', 'VariableName'));
	}
	}

	/**
	* Returns configuration option value by name
	*
	* @param string $name
	* @return string
	*/
	function ConfigValue($name)
	{
	$res = isset($this->ConfigHash[$name]) ? $this->ConfigHash[$name] : false;
	if ($res !== false) return $res;

	$res = $this->Conn->GetRow('SELECT VariableId, VariableValue FROM '.TABLE_PREFIX.'ConfigurationValues WHERE VariableName = '.$this->Conn->qstr($name));
	if ($res) {
	$this->ConfigHash[$name] = $res['VariableValue'];
	$this->ConfigCacheIds[] = $res['VariableId'];
	return $res['VariableValue'];
	}
	return false;
	}

	function UpdateConfigCache()
	{
	if ($this->ConfigCacheIds) {

	}
	}

	/**
	* Allows to process any type of event
	*
	* @param kEvent $event
	* @access public
	* @author Alex
	*/
	function HandleEvent(&$event, $params=null, $specificParams=null)
	{
	if ( isset($params) ) {
	$event = new kEvent( $params, $specificParams );
	}

	if (!isset($this->EventManager)) {
	$this->EventManager =& $this->recallObject('EventManager');
	}

	$this->EventManager->HandleEvent($event);
	}

	/**
	* Registers new class in the factory
	*
	* @param string $real_class Real name of class as in class declaration
	* @param string $file Filename in what $real_class is declared
	* @param string $pseudo_class Name under this class object will be accessed using getObject method
	* @param Array $dependecies List of classes required for this class functioning
	* @access public
	* @author Alex
	*/
	function registerClass($real_class, $file, $pseudo_class = null, $dependecies = Array() )
	{
	$this->Factory->registerClass($real_class, $file, $pseudo_class, $dependecies);
	}

	/**
	* Add $class_name to required classes list for $depended_class class.
	* All required class files are included before $depended_class file is included
	*
	* @param string $depended_class
	* @param string $class_name
	* @author Alex
	*/
	function registerDependency($depended_class, $class_name)
	{
	$this->Factory->registerDependency($depended_class, $class_name);
	}

	/**
	* Registers Hook from subprefix event to master prefix event
	*
	* @param string $hookto_prefix
	* @param string $hookto_special
	* @param string $hookto_event
	* @param string $mode
	* @param string $do_prefix
	* @param string $do_special
	* @param string $do_event
	* @param string $conditional
	* @access public
	* @todo take care of a lot parameters passed
	* @author Kostja
	*/
	function registerHook($hookto_prefix, $hookto_special, $hookto_event, $mode, $do_prefix, $do_special, $do_event, $conditional)
	{
	$event_manager =& $this->recallObject('EventManager');
	$event_manager->registerHook($hookto_prefix, $hookto_special, $hookto_event, $mode, $do_prefix, $do_special, $do_event, $conditional);
	}

	/**
	* Allows one TagProcessor tag act as other TagProcessor tag
	*
	* @param Array $tag_info
	* @author Kostja
	*/
	function registerAggregateTag($tag_info)
	{
	$aggregator =& $this->recallObject('TagsAggregator', 'kArray');
	$aggregator->SetArrayValue($tag_info['AggregateTo'], $tag_info['AggregatedTagName'], Array($tag_info['LocalPrefix'], $tag_info['LocalTagName'], getArrayValue($tag_info, 'LocalSpecial')));
	}

	/**
	* Returns object using params specified,
	* creates it if is required
	*
	* @param string $name
	* @param string $pseudo_class
	* @param Array $event_params
	* @return Object
	* @author Alex
	*/
	function &recallObject($name,$pseudo_class=null,$event_params=Array())
	{
	$result =& $this->Factory->getObject($name, $pseudo_class, $event_params);
	return $result;
	}

	/**
	* Returns object using Variable number of params,
	* all params starting with 4th are passed to object consturctor
	*
	* @param string $name
	* @param string $pseudo_class
	* @param Array $event_params
	* @return Object
	* @author Alex
	*/
	function &recallObjectP($name,$pseudo_class=null,$event_params=Array())
	{
	$func_args = func_get_args();
	$result =& ref_call_user_func_array( Array(&$this->Factory, 'getObjectP'), $func_args );
	return $result;
	}

	/**
	* Returns tag processor for prefix specified
	*
	* @param string $prefix
	* @return kDBTagProcessor
	*/
	function &recallTagProcessor($prefix)
	{
	$result =& $this->recallObject($prefix.'_TagProcessor');
	return $result;
	}

	/**
	* Checks if object with prefix passes was already created in factory
	*
	* @param string $name object presudo_class, prefix
	* @return bool
	* @author Kostja
	*/
	function hasObject($name)
	{
	return isset($this->Factory->Storage[$name]);
	}

	/**
	* Removes object from storage by given name
	*
	* @param string $name Object's name in the Storage
	* @author Kostja
	*/
	function removeObject($name)
	{
	$this->Factory->DestroyObject($name);
	}

	/**
	* Get's real class name for pseudo class,
	* includes class file and creates class
	* instance
	*
	* @param string $pseudo_class
	* @return Object
	* @access public
	* @author Alex
	*/
	function &makeClass($pseudo_class)
	{
	$func_args = func_get_args();
	$result =& ref_call_user_func_array( Array(&$this->Factory, 'makeClass'), $func_args);

	return $result;
	}

	/**
	* Checks if application is in debug mode
	*
	* @param bool $check_debugger check if kApplication debugger is initialized too, not only for defined DEBUG_MODE constant
	* @return bool
	* @author Alex
	* @access public
	*/
	function isDebugMode($check_debugger = true)
	{
	$debug_mode = defined('DEBUG_MODE') && DEBUG_MODE;
	if($check_debugger)
	{
	$debug_mode = $debug_mode && is_object($this->Debugger);
	}
	return $debug_mode;
	}

	/**
	* Checks if it is admin
	*
	* @return bool
	* @author Alex
	*/
	function IsAdmin()
	{
	return constOn('ADMIN');
	}

	/**
	* Apply url rewriting used by mod_rewrite or not
	*
	* @param bool $ssl Force ssl link to be build
	* @return bool
	*/
	function RewriteURLs($ssl = false)
	{
	// case #1,#4:
	// we want to create https link from http mode
	// we want to create https link from https mode
	// conditions: ($ssl \|\| PROTOCOL == 'https://') && $this->ConfigValue('UseModRewriteWithSSL')

	// case #2,#3:
	// we want to create http link from https mode
	// we want to create http link from http mode
	// conditions: !$ssl && (PROTOCOL == 'https://' \|\| PROTOCOL == 'http://')

	$allow_rewriting =
	(!$ssl && (PROTOCOL == 'https://' \|\| PROTOCOL == 'http://')) // always allow mod_rewrite for http
	\|\| // or allow rewriting for redirect TO httpS or when already in httpS
	(($ssl \|\| PROTOCOL == 'https://') && $this->ConfigValue('UseModRewriteWithSSL')); // but only if it's allowed in config!
	return constOn('MOD_REWRITE') && $allow_rewriting;
	}

	/**
	* Reads unit (specified by $prefix)
	* option specified by $option
	*
	* @param string $prefix
	* @param string $option
	* @param mixed $default
	* @return string
	* @access public
	* @author Alex
	*/
	function getUnitOption($prefix, $option, $default = false)
	{
	/*if (!isset($this->UnitConfigReader)) {
	$this->UnitConfigReader =& $this->recallObject('kUnitConfigReader');
	}*/
	return $this->UnitConfigReader->getUnitOption($prefix, $option, $default);
	}

	/**
	* Set's new unit option value
	*
	* @param string $prefix
	* @param string $name
	* @param string $value
	* @author Alex
	* @access public
	*/
	function setUnitOption($prefix, $option, $value)
	{
	// $unit_config_reader =& $this->recallObject('kUnitConfigReader');
	return $this->UnitConfigReader->setUnitOption($prefix,$option,$value);
	}

	/**
	* Read all unit with $prefix options
	*
	* @param string $prefix
	* @return Array
	* @access public
	* @author Alex
	*/
	function getUnitOptions($prefix)
	{
	// $unit_config_reader =& $this->recallObject('kUnitConfigReader');
	return $this->UnitConfigReader->getUnitOptions($prefix);
	}

	/**
	* Returns true if config exists and is allowed for reading
	*
	* @param string $prefix
	* @return bool
	*/
	function prefixRegistred($prefix)
	{
	/*if (!isset($this->UnitConfigReader)) {
	$this->UnitConfigReader =& $this->recallObject('kUnitConfigReader');
	}*/
	return $this->UnitConfigReader->prefixRegistred($prefix);
	}

	/**
	* Splits any mixing of prefix and
	* special into correct ones
	*
	* @param string $prefix_special
	* @return Array
	* @access public
	* @author Alex
	*/
	function processPrefix($prefix_special)
	{
	return $this->Factory->processPrefix($prefix_special);
	}

	/**
	* Set's new event for $prefix_special
	* passed
	*
	* @param string $prefix_special
	* @param string $event_name
	* @access public
	*/
	function setEvent($prefix_special,$event_name)
	{
	$event_manager =& $this->recallObject('EventManager');
	$event_manager->setEvent($prefix_special,$event_name);
	}


	/**
	* SQL Error Handler
	*
	* @param int $code
	* @param string $msg
	* @param string $sql
	* @return bool
	* @access private
	* @author Alex
	*/
	function handleSQLError($code, $msg, $sql)
	{
	if ( isset($this->Debugger) )
	{
	$errorLevel = constOn('DBG_SQL_FAILURE') && !defined('IS_INSTALL') ? E_USER_ERROR : E_USER_WARNING;
	$this->Debugger->dumpVars($_REQUEST);
	$this->Debugger->appendTrace();

	$error_msg = '<span class="debug_error">'.$msg.' ('.$code.')</span><br><a href="javascript:$Debugger.SetClipboard(\''.htmlspecialchars($sql).'\');"><b>SQL</b></a>: '.$this->Debugger->formatSQL($sql);
	$long_id = $this->Debugger->mapLongError($error_msg);
	trigger_error( substr($msg.' ('.$code.') ['.$sql.']',0,1000).' #'.$long_id, $errorLevel);
	return true;
	}
	else
	{
	//$errorLevel = constOn('IS_INSTALL') ? E_USER_WARNING : E_USER_ERROR;
	$errorLevel = E_USER_WARNING;
	trigger_error('<b>SQL Error</b> in sql: '.$sql.', code <b>'.$code.'</b> ('.$msg.')', $errorLevel);
	/*echo '<b>xProcessing SQL</b>: '.$sql.'<br>';
	echo '<b>Error ('.$code.'):</b> '.$msg.'<br>';*/
	return $errorLevel == E_USER_ERROR ? false : true;
	}
	}

	/**
	* Default error handler
	*
	* @param int $errno
	* @param string $errstr
	* @param string $errfile
	* @param int $errline
	* @param Array $errcontext
	*/
	function handleError($errno, $errstr, $errfile = '', $errline = '', $errcontext = '')
	{
	if( constOn('SILENT_LOG') )
	{
	$fp = fopen(FULL_PATH.'/silent_log.txt','a');
	$time = adodb_date('d/m/Y H:i:s');
	fwrite($fp, '['.$time.'] #'.$errno.': '.strip_tags($errstr).' in ['.$errfile.'] on line '.$errline."\n");
	fclose($fp);
	}

	if( !$this->errorHandlers ) return true;

	$i = 0; // while (not foreach) because it is array of references in some cases
	$eh_count = count($this->errorHandlers);
	while($i < $eh_count)
	{
	if( is_array($this->errorHandlers[$i]) )
	{
	$object =& $this->errorHandlers[$i][0];
	$method = $this->errorHandlers[$i][1];
	$object->$method($errno, $errstr, $errfile, $errline, $errcontext);
	}
	else
	{
	$function = $this->errorHandlers[$i];
	$function($errno, $errstr, $errfile, $errline, $errcontext);
	}
	$i++;
	}
	}

	/**
	* Returns & blocks next ResourceId available in system
	*
	* @return int
	* @access public
	* @author Alex
	*/
	function NextResourceId()
	{
	$table_name = TABLE_PREFIX.'IdGenerator';

	$this->Conn->Query('LOCK TABLES '.$table_name.' WRITE');
	$this->Conn->Query('UPDATE '.$table_name.' SET lastid = lastid + 1');
	$id = $this->Conn->GetOne('SELECT lastid FROM '.$table_name);
	if($id === false)
	{
	$this->Conn->Query('INSERT INTO '.$table_name.' (lastid) VALUES (2)');
	$id = 2;
	}
	$this->Conn->Query('UNLOCK TABLES');
	return $id - 1;
	}

	/**
	* Returns main prefix for subtable prefix passes
	*
	* @param string $current_prefix
	* @return string
	* @access public
	* @author Kostja
	*/
	function GetTopmostPrefix($current_prefix)
	{
	while ( $parent_prefix = $this->getUnitOption($current_prefix, 'ParentPrefix') )
	{
	$current_prefix = $parent_prefix;
	}
	return $current_prefix;
	}

	function &EmailEventAdmin($email_event_name, $to_user_id = -1, $send_params = false)
	{
	return $this->EmailEvent($email_event_name, 1, $to_user_id, $send_params);
	}

	function &EmailEventUser($email_event_name, $to_user_id = -1, $send_params = false)
	{
	return $this->EmailEvent($email_event_name, 0, $to_user_id, $send_params);
	}

	function &EmailEvent($email_event_name, $email_event_type, $to_user_id = -1, $send_params = false)
	{
	$event = new kEvent('emailevents:OnEmailEvent');
	$event->setEventParam('EmailEventName', $email_event_name);
	$event->setEventParam('EmailEventToUserId', $to_user_id);
	$event->setEventParam('EmailEventType', $email_event_type);
	if ($send_params){
	$event->setEventParam('DirectSendParams', $send_params);
	}
	$this->HandleEvent($event);

	return $event;
	}


	function LoggedIn()
	{
	$user =& $this->recallObject('u');
	$user_id = $user->GetID();

	$ret = $user_id > 0;
	if ($this->IsAdmin() && ($user_id == -1)) {
	$ret = true;
	}
	return $ret;
	}

	/**
	* Check current user permissions based on it's group permissions in specified category
	*
	* @param string $name permission name
	* @param int $cat_id category id, current used if not specified
	* @param int $type permission type {1 - system, 0 - per category}
	* @return int
	*/
	function CheckPermission($name, $type = 1, $cat_id = null)
	{
	$perm_helper =& $this->recallObject('PermissionsHelper');
	return $perm_helper->CheckPermission($name, $type, $cat_id);
	}

	/**
	* Set's any field of current visit
	*
	* @param string $field
	* @param mixed $value
	*/
	function setVisitField($field, $value)
	{
	$visit =& $this->recallObject('visits');
	$visit->SetDBField($field, $value);
	$visit->Update();
	}

	/**
	* Allows to check if in-portal is installed
	*
	* @return bool
	*/
	function isInstalled()
	{
	return $this->InitDone && (count($this->ModuleInfo) > 0);
	}

	/**
	* Allows to determine if module is installed & enabled
	*
	* @param string $module_name
	* @return bool
	*/
	function isModuleEnabled($module_name)
	{
	return $this->findModule('Name', $module_name);

	}

	function reportError($class, $method)
	{
	$this->Debugger->appendTrace();
	trigger_error('depricated method <b>'.$class.'->'.$method.'(...)</b>', E_USER_ERROR);
	}


	/**
	* Get temp table name
	*
	* @param string $table
	* @return string
	*/
	function GetTempName($table)
	{
	return TABLE_PREFIX.'ses_'.$this->GetSID().'_edit_'.$table;
	}

	function GetTempTablePrefix()
	{
	return TABLE_PREFIX.'ses_'.$this->GetSID().'_edit_';
	}

	function IsTempTable($table)
	{
	return strpos($table, TABLE_PREFIX.'ses_'.$this->GetSID().'_edit_') !== false;
	}

	/**
	* Return live table name based on temp table name
	*
	* @param string $temp_table
	* @return string
	*/
	function GetLiveName($temp_table)
	{
	if( preg_match('/'.TABLE_PREFIX.'ses_'.$this->GetSID().'_edit_(.*)/',$temp_table,$rets) )
	{
	return $rets[1];
	}
	else
	{
	return $temp_table;
	}
	}

	function CheckProcessors($processors)
	{
	foreach ($processors as $a_processor)
	{
	if (!isset($this->CachedProcessors[$a_processor])) {
	$this->CachedProcessors[$a_processor] =& $this->recallObject($a_processor.'_TagProcessor');
	}
	}
	}

	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/application.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.142
	\ No newline at end of property
	+1.143
	\ No newline at end of property
	Index: trunk/core/units/admin/admin_tag_processor.php
	===================================================================
	--- trunk/core/units/admin/admin_tag_processor.php (revision 4841)
	+++ trunk/core/units/admin/admin_tag_processor.php (revision 4842)
	@@ -1,335 +1,335 @@
	<?php

	class AdminTagProcessor extends kDBTagProcessor {

	function SetConst($params)
	{
	$name = $this->SelectParam($params, 'name,const');
	safeDefine($name, $params['value']);
	}

	/**
	* Allows to execute js script after the page is fully loaded
	*
	* @param Array $params
	* @return string
	*/
	function AfterScript($params)
	{
	$after_script = $this->Application->GetVar('after_script');
	if ($after_script) {
	return '<script type="text/javascript">'.$after_script.'</script>';
	}
	return '';
	}

	/**
	* Returns section title with #section# keyword replaced with current section
	*
	* @param Array $params
	* @return string
	*/
	function GetSectionTitle($params)
	{
	$params['name'] = replaceModuleSection($params['phrase']);
	return $this->Application->ProcessParsedTag('m', 'Phrase', $params);
	}

	/**
	* Returns section icon with #section# keyword replaced with current section
	*
	* @param Array $params
	* @return string
	*/
	function GetSectionIcon($params)
	{
	return replaceModuleSection($params['icon']);
	}

	/**
	* Allows to detect if current template is one of listed ones
	*
	* @param Array $params
	* @return int
	*/
	function TemplateMatches($params)
	{
	$templates = explode(',' ,$params['templates']);
	$t = $this->Application->GetVar('t');
	return in_array($t, $templates) ? 1 : 0;
	}

	/**
	* Save return script in cases, when old sections are opened from new sections
	*
	* @param Array $params
	*/
	function SaveReturnScript($params)
	{
	// admin/save_redirect.php?do=
	$url = str_replace($this->Application->BaseURL(), '', $this->Application->ProcessParsedTag('m', 'Link', $params) );
	$url = explode('?', $url, 2);
	$url = 'save_redirect.php?'.$url[1].'&do='.$url[0];

	$this->Application->StoreVar('ReturnScript', $url);
	}

	/**
	* Redirects to correct next import step template based on import script data
	*
	* @param Array $params
	*/
	function ImportRedirect($params)
	{
	$import_id = $this->Application->GetVar('import_id');
	if ($import_id) {
	// redirect forward to step3 (import parameters coosing)
	$this->Application->StoreVar('ImportScriptID', $import_id);

	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'ImportScripts
	WHERE is_id = '.$import_id;

	$db =& $this->Application->GetADODBConnection();
	$is_params = $db->GetRow($sql);

	if ($is_params['is_type'] == 'db') {
	$this->Application->Redirect('', null, '', 'import/step3.php');
	}
	elseif ($is_params['is_type'] == 'csv') {
	$module = strtolower($is_params['is_Module']);
	$template = $module.'/import';
	- $sql = 'SELECT Var
	- FROM '.TABLE_PREFIX.'Modules
	- WHERE LOWER(Name) = '.$db->qstr($module);
	- $item_prefix = $db->GetOne($sql);
	- $pass_params = Array('m_opener' => 'd', $item_prefix.'.import_id' => 0, $item_prefix.'.import_event' => 'OnNew', 'pass' => 'm,'.$item_prefix.'.import');
	+ $module_info = $this->Application->findModule('Name', $module);
	+
	+ $item_prefix = $module_info['Var'];
	+ $pass_params = Array('m_opener' => 'd', $item_prefix.'.import_id' => 0, $item_prefix.'.import_event' => 'OnNew', 'pass' => 'm,'.$item_prefix.'.import', 'm_cat_id' => $module_info['RootCat']);
	+
	$this->Application->Redirect($template, $pass_params);
	}
	}
	else {
	// redirect back to step2 (import type choosing)
	$this->Application->Redirect('', null, '', 'import/step2.php');
	}
	}

	/**
	* Returns version of module by name
	*
	* @param Array $params
	* @return string
	*/
	function ModuleVersion($params)
	{
	return $this->Application->findModule('Name', $params['module'], 'Version');
	}

	/**
	* Used in table form section drawing
	*
	* @param Array $params
	* @return string
	*/
	function DrawTree($params)
	{
	static $deep_level = 0;

	// when processings, then sort children by priority (key of children array)
	$ret = '';
	$section_name = $params['section_name'];
	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['children_count'] = isset($section_data['children']) ? count($section_data['children']) : 0;
	$params['deep_level'] = $deep_level++;
	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);
	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);
	$ret .= $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );
	if (!isset($section_data['children'])) {
	return $ret;
	}

	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $section_name) {
	$params['section_name'] = $section_name;
	$ret .= $this->DrawTree($params);
	$deep_level--;
	}


	return $ret;
	}


	function PrintSection($params)
	{
	$section_name = $params['section_name'];
	if ($section_name == '#session#') {
	$section_name = $this->Application->RecallVar('section');
	}

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	$params['section_name'] = $section_name;

	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);

	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);
	$ret = $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );

	return $ret;
	}

	/**
	* Used in XML drawing for tree
	*
	* @param Array $params
	* @return string
	*/
	function PrintSections($params)
	{
	// when processings, then sort children by priority (key of children array)
	$ret = '';
	$section_name = $params['section_name'];
	if ($section_name == '#session#') {
	$section_name = $this->Application->RecallVar('section');
	}

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$params['name'] = $this->SelectParam($params, 'name,render_as,block');
	if (!isset($section_data['children'])) {
	return '';
	}

	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $section_name) {
	$params['section_name'] = $section_name;
	$section_data =& $sections_helper->getSectionData($section_name);

	if (isset($section_data['tabs_only']) && $section_data['tabs_only']) {
	$perm_status = false;
	$folder_label = $section_data['label'];
	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $priority => $section_name) {
	$perm_status = $this->Application->CheckPermission($section_name.'.view', 1);
	if ($perm_status) {
	break;
	}
	}
	if (!$perm_status) {
	// no permission for all tabs -> don't display tree node either
	continue;
	}

	$params['section_name'] = $section_name;
	$section_data =& $sections_helper->getSectionData($section_name);
	$section_data['label'] = $folder_label; // use folder label in tree
	$section_data['is_tab'] = 1;
	}
	elseif (!$this->Application->CheckPermission($section_name.'.view', 1)) {
	continue;
	}

	$params['children_count'] = isset($section_data['children']) ? count($section_data['children']) : 0;

	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);

	$section_data['section_url'] = $this->Application->HREF($template, '', $section_data['url']);

	$late_load = getArrayValue($section_data, 'late_load');
	if ($late_load) {
	$t = $late_load['t'];
	unset($late_load['t']);
	$section_data['late_load'] = $this->Application->HREF($t, '', $late_load);
	$params['children_count'] = 99;
	}
	else {
	$section_data['late_load'] = '';
	}

	$ret .= $this->Application->ParseBlock( array_merge_recursive2($params, $section_data) );
	$params['section_name'] = $section_name;
	}

	return preg_replace("/\r\n\|\n/", '', $ret);
	}

	function ListSectionPermissions($params)
	{
	$section_name = isset($params['section_name']) ? $params['section_name'] : $this->Application->GetVar('section_name');
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($section_name);

	$block_params = array_merge_recursive2($section_data, Array('name' => $params['render_as'], 'section_name' => $section_name));

	$ret = '';
	foreach ($section_data['permissions'] as $perm_name) {
	if (preg_match('/^advanced:(.*)/', $perm_name) != $params['type']) continue;
	$block_params['perm_name'] = $perm_name;
	$ret .= $this->Application->ParseBlock($block_params);
	}
	return $ret;
	}

	function ModuleInclude($params)
	{
	foreach ($params as $param_name => $param_value) {
	$params[$param_name] = replaceModuleSection($param_value);
	}

	return $this->Application->ProcessParsedTag('m', 'ModuleInclude', $params);
	}

	function TodayDate($params)
	{
	return date($params['format']);
	}

	function TreeEditWarrning($params)
	{
	$ret = $this->Application->Phrase($params['label']);
	$ret = str_replace(Array('<', '>', 'br/', 'br /', "\n", "\r"), Array('<', '>', 'br', 'br', '', ''), $ret);
	if (getArrayValue($params, 'escape')) {
	$ret = addslashes($ret);
	}
	$ret = str_replace('<br>', '\n', $ret);
	return $ret;
	}

	/**
	* Draws section tabs using block name passed
	*
	* @param Array $params
	*/
	function ListTabs($params)
	{
	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	$section_data =& $sections_helper->getSectionData($params['section_name']);

	$ret = '';
	$block_params = Array('name' => $params['render_as']);
	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $priority => $section_name) {
	// if (!$this->Application->CheckPermission($section_name.'.view', 1)) continue;

	$tab_data =& $sections_helper->getSectionData($section_name);
	$block_params['t'] = $tab_data['url']['t'];
	$block_params['title'] = $tab_data['label'];
	$block_params['main_prefix'] = $section_data['SectionPrefix'];
	$ret .= $this->Application->ParseBlock($block_params);
	}


	return $ret;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/admin/admin_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.16
	\ No newline at end of property
	+1.17
	\ No newline at end of property
	Index: trunk/core/units/custom_fields/custom_fields_event_handler.php
	===================================================================
	--- trunk/core/units/custom_fields/custom_fields_event_handler.php (revision 4841)
	+++ trunk/core/units/custom_fields/custom_fields_event_handler.php (revision 4842)
	@@ -1,145 +1,143 @@
	<?php
	class CustomFieldsEventHandler extends InpDBEventHandler {

	/**
	* Changes permission section to one from REQUEST, not from config
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	$sql = 'SELECT Prefix
	FROM '.TABLE_PREFIX.'ItemTypes
	WHERE ItemType = '.$this->Conn->qstr( $this->Application->GetVar('cf_type') );
	$main_prefix = $this->Conn->GetOne($sql);

	$section = $this->Application->getUnitOption($main_prefix.'.custom', 'PermSection');
	$event->setEventParam('PermSection', $section);
	return parent::CheckPermission($event);
	-
	-
	}

	/**
	* Apply any custom changes to list's sql query
	*
	* @param kEvent $event
	* @access protected
	* @see OnListBuild
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();

	$item_type = $this->Application->GetVar('cf_type');
	if (!$item_type) {
	$prefix = $event->getEventParam('SourcePrefix');
	$item_type = $this->Application->getUnitOption($prefix, 'ItemType');
	}

	if ($event->Special == 'general') {
	$object->addFilter('generaltab_filter', '%1$s.OnGeneralTab = 1');
	}

	if ($item_type) {
	$object->addFilter('itemtype_filter', '%1$s.Type = '.$item_type);
	}

	if (!$this->Application->IsAdmin()) {
	$object->addFilter('user_filter', '%1$s.IsSystem = 0');
	}
	}

	/**
	* Prevents from duplicate item creation
	*
	* @param kEvent $event
	*/
	function OnBeforeItemCreate(&$event)
	{
	$object =& $event->getObject();

	$live_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT COUNT(*)
	FROM '.$live_table.'
	WHERE FieldName = '.$this->Conn->qstr($object->GetDBField('FieldName')).' AND Type = '.$object->GetDBField('Type');
	$found = $this->Conn->GetOne($sql);

	if ($found) {
	$event->status = erFAIL;
	$object->SetError('FieldName', 'duplicate', 'la_error_CustomExists');
	}
	}

	/**
	* Occurse after deleting item, id of deleted item
	* is stored as 'id' param of event
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemDelete(&$event)
	{
	$object =& $event->getObject();
	$main_prefix = $this->getPrefixByItemType($object->GetDBField('Type'));

	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	$ml_helper->deleteField($main_prefix.'-cdata', $event->getEventParam('id'));
	}

	/**
	* Get config prefix based on item type
	*
	* @param unknown_type $item_type
	* @return unknown
	*/
	function getPrefixByItemType($item_type)
	{
	$sql = 'SELECT Prefix
	FROM '.TABLE_PREFIX.'ItemTypes
	WHERE ItemType = '.$item_type;
	return $this->Conn->GetOne($sql);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSaveCustomField(&$event)
	{
	if ($event->MasterEvent->status != erSUCCESS) {
	return false;
	}

	$object =& $event->getObject();
	$main_prefix = $this->getPrefixByItemType($object->GetDBField('Type'));

	$this->Application->HandleEvent( new kEvent($main_prefix.'-cdata:OnCreateCustomFields') );

	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	$ml_helper->createFields($main_prefix.'-cdata');
	}

	function OnMassDelete(&$event)
	{
	parent::OnMassDelete($event);
	$event->redirect_params = Array('opener' => 's');
	}

	/**
	* Prepare temp tables for creating new item
	* but does not create it. Actual create is
	* done in OnPreSaveCreated
	*
	* @param kEvent $event
	*/
	function OnPreCreate(&$event)
	{
	parent::OnPreCreate($event);

	$object =& $event->getObject();
	$object->SetDBField('Type', $this->Application->GetVar('cf_type'));
	}
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/custom_fields/custom_fields_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.13
	\ No newline at end of property
	+1.14
	\ No newline at end of property
	Index: trunk/core/units/general/cat_event_handler.php
	===================================================================
	--- trunk/core/units/general/cat_event_handler.php (revision 4841)
	+++ trunk/core/units/general/cat_event_handler.php (revision 4842)
	@@ -1,1757 +1,1757 @@
	<?php

	$application =& kApplication::Instance();
	$application->Factory->includeClassFile('kDBEventHandler');

	class kCatDBEventHandler extends InpDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnExport' => Array('self' => 'view\|advanced:export'),
	'OnExportBegin' => Array('self' => 'view\|advanced:export'),
	'OnSaveSettings' => Array('self' => 'add\|edit\|advanced:import'),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Checks permissions of user
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	if (!$this->Application->IsAdmin()) {
	if ($event->Name == 'OnSetSortingDirect') {
	// allow sorting on front event without view permission
	return true;
	}
	}

	-
	if ($event->Name == 'OnExport') {
	// save category_id before doing export
	$this->Application->LinkVar('m_cat_id');
	}

	if ($event->Name == 'OnNew' && preg_match('/(.*)\/import$/', $this->Application->GetVar('t'), $rets)) {
	// redirect to item import template, where permission (import) category will be chosen)
	- $this->Application->StoreVar('m_cat_id', $this->Application->findModule('Path', $rets[1].'/', 'RootCat'));
	+ $root_category = $this->Application->findModule('Path', $rets[1].'/', 'RootCat');
	+ $this->Application->StoreVar('m_cat_id', $root_category);
	}

	return parent::CheckPermission($event);
	}

	function OnCopy(&$event)
	{
	$object = $event->getObject();
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard', implode(',', $ids));
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard_mode', 'copy');

	$this->Application->StoreVar('ClipBoard', 'COPY-0.'.$object->TableName.'.ResourceId=0');
	$event->redirect_params = Array('opener' => 's', 'pass_events'=>true); //do not go up - STAY
	}

	function OnCut(&$event)
	{
	$object = $event->getObject();
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard', implode(',', $ids));
	$this->Application->StoreVar($event->getPrefixSpecial().'_clipboard_mode', 'cut');

	$this->Application->StoreVar('ClipBoard', 'CUT-0.'.$object->TableName.'.ResourceId=0');
	$event->redirect_params = Array('opener' => 's', 'pass_events'=>true); //do not go up - STAY
	}

	function OnPaste(&$event)
	{
	$ids = $this->Application->RecallVar($event->getPrefixSpecial().'_clipboard');
	if ($ids == '') {
	$event->redirect = false;
	return;
	}

	$ids_arr = explode(',', $ids);

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

	if ($ids_arr) {
	$temp->CloneItems($event->Prefix, $event->Special, $ids_arr);
	}
	}
	else { // mode == cut
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'.item', $event->Prefix, Array('skip_autoload' => true));

	foreach ($ids_arr as $id) {
	$object->Load($id);
	$object->MoveToCat();
	}
	}
	$event->status = erSUCCESS;
	}

	/**
	* 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';


	$this->Application->setUnitOption($event->Prefix,'AutoLoad', false);
	$object =& $this->Application->recallObject($event->Prefix.'.item', $event->Prefix);

	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->setUnitOption($event->Prefix,'AutoLoad', true);
	$this->Application->SetVar('m_cat_id', $saved_cat_id);
	}
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndOpenTranslator(&$event)
	{
	$this->Application->SetVar('allow_translation', true);
	$object =& $event->getObject();
	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');

	if ($event->status == 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));
	$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');
	$event->redirect_params = Array('pass'=>'all,trans,'.$this->Application->GetVar('translator_prefixes'),
	$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'),
	);

	// 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'));
	}
	}

	/**
	* Return type clauses for list bulding on front
	*
	* @param kEvent $event
	* @return Array
	*/
	function getTypeClauses(&$event)
	{
	$types = $event->getEventParam('types');
	$except_types = $event->getEventParam('except');
	$type_clauses = Array();

	$type_clauses['pick']['include'] = '%1$s.EditorsPick = 1 AND '.TABLE_PREFIX.'CategoryItems.PrimaryCat = 1';
	$type_clauses['pick']['except'] = '%1$s.EditorsPick! = 1 AND '.TABLE_PREFIX.'CategoryItems.PrimaryCat = 1';
	$type_clauses['pick']['having_filter'] = false;

	$type_clauses['hot']['include'] = '`IsHot` = 1 AND PrimaryCat = 1';
	$type_clauses['hot']['except'] = '`IsHot`! = 1 AND PrimaryCat = 1';
	$type_clauses['hot']['having_filter'] = true;

	$type_clauses['pop']['include'] = '`IsPop` = 1 AND PrimaryCat = 1';
	$type_clauses['pop']['except'] = '`IsPop`! = 1 AND PrimaryCat = 1';
	$type_clauses['pop']['having_filter'] = true;

	$type_clauses['new']['include'] = '`IsNew` = 1 AND PrimaryCat = 1';
	$type_clauses['new']['except'] = '`IsNew`! = 1 AND PrimaryCat = 1';
	$type_clauses['new']['having_filter'] = true;

	$type_clauses['displayed']['include'] = '';
	$displayed = $this->Application->GetVar($event->Prefix.'_displayed_ids');
	if ($displayed) {
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$type_clauses['displayed']['except'] = '%1$s.'.$id_field.' NOT IN ('.$displayed.')';
	}
	else {
	$type_clauses['displayed']['except'] = '';
	}
	$type_clauses['displayed']['having_filter'] = false;

	if (strpos($types, 'search') !== false \|\| strpos($except_types, 'search') !== false) {
	$event_mapping = Array(
	'simple' => 'OnSimpleSearch',
	'subsearch' => 'OnSubSearch',
	'advanced' => 'OnAdvancedSearch');
	if($this->Application->GetVar('INPORTAL_ON') && $this->Application->GetVar('Action') == 'm_simple_subsearch')
	{
	$type = 'subsearch';
	}
	else
	{
	$type = $this->Application->GetVar('search_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);
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';
	if ( $this->Conn->Query($sql) ) {
	$search_res_ids = $this->Conn->GetCol('SELECT ResourceId FROM '.$search_table);
	}

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

	if (strpos($types, 'related') !== false \|\| strpos($except_types, 'related') !== false) {

	$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 = $this->Application->getUnitOption($event->Prefix, 'ItemType');

	$p_item =& $this->Application->recallObject($related_prefix.'.current', null, Array('skip_autoload' => true));
	$p_item->Load( $this->Application->GetVar($related_prefix.'_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).') AND PrimaryCat = 1';
	$type_clauses['related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_ids).') AND PrimaryCat = 1';
	}
	else {
	$type_clauses['related']['include'] = '0';
	$type_clauses['related']['except'] = '1';
	}
	$type_clauses['related']['having_filter'] = false;
	}

	return $type_clauses;
	}

	/**
	* Apply filters to list
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

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

	// add category filter if needed
	if ($event->Special != 'showall') {
	if ( $event->getEventParam('parent_cat_id') ) {
	$parent_cat_id = $event->getEventParam('parent_cat_id');
	}
	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 ((string) $parent_cat_id != 'any') {
	if ($event->getEventParam('recursive')) {
	$current_path = $this->Conn->GetOne('SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId='.$parent_cat_id);
	$subcats = $this->Conn->GetCol('SELECT CategoryId FROM '.TABLE_PREFIX.'Category WHERE ParentPath LIKE "'.$current_path.'%" ');
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.CategoryId IN ('.implode(', ', $subcats).')');
	}
	else {
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.CategoryId = '.$parent_cat_id );
	}
	}
	}
	else {
	$object->addFilter('primary_filter', 'PrimaryCat = 1');
	}

	// add permission filter
	$view_perm = 1;
	$object->addFilter('perm_filter', 'perm.PermId = '.$view_perm);

	if ( !$this->Application->IsAdmin() )
	{
	$groups = explode( ',', $this->Application->RecallVar('UserGroups') );
	foreach($groups as $group)
	{
	$view_filters[] = 'FIND_IN_SET('.$group.', perm.acl) \|\| ((NOT FIND_IN_SET('.$group.',perm.dacl)) AND perm.acl=\'\')';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	$object->addFilter('status_filter', $object->TableName.'.Status = 1');
	}

	$types = $event->getEventParam('types');
	$except_types = $event->getEventParam('except');
	$type_clauses = $this->getTypeClauses($event);

	// convert prepared type clauses into list filters
	$includes_or_filter =& $this->Application->makeClass('kMultipleFilter');
	$includes_or_filter->setType(FLT_TYPE_OR);

	$excepts_and_filter =& $this->Application->makeClass('kMultipleFilter');
	$excepts_and_filter->setType(FLT_TYPE_AND);

	$includes_or_filter_h =& $this->Application->makeClass('kMultipleFilter');
	$includes_or_filter_h->setType(FLT_TYPE_OR);

	$excepts_and_filter_h =& $this->Application->makeClass('kMultipleFilter');
	$excepts_and_filter_h->setType(FLT_TYPE_AND);

	$except_types_array = explode(',', $types);

	if ($types) {
	$types_array = explode(',', $types);
	for ($i = 0; $i < sizeof($types_array); $i++) {
	$type = trim($types_array[$i]);
	if (isset($type_clauses[$type])) {
	if ($type_clauses[$type]['having_filter']) {
	$includes_or_filter_h->removeFilter('filter_'.$type);
	$includes_or_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['include']);
	}else {
	$includes_or_filter->removeFilter('filter_'.$type);
	$includes_or_filter->addFilter('filter_'.$type, $type_clauses[$type]['include']);
	}
	}
	}
	}

	if ($except_types) {
	$except_types_array = explode(',', $except_types);
	for ($i = 0; $i < sizeof($except_types_array); $i++) {
	$type = trim($except_types_array[$i]);
	if (isset($type_clauses[$type])) {
	if ($type_clauses[$type]['having_filter']) {
	$excepts_and_filter_h->removeFilter('filter_'.$type);
	$excepts_and_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['except']);
	}else {
	$excepts_and_filter->removeFilter('filter_'.$type);
	$excepts_and_filter->addFilter('filter_'.$type, $type_clauses[$type]['except']);
	}
	}
	}
	}

	/*if ( !$this->Application->IsAdmin() ) {
	$object->addFilter('expire_filter', '%1$s.Expire IS NULL OR %1$s.Expire > UNIX_TIMESTAMP()');
	}*/

	/*$list_type = $event->getEventParam('ListType');
	switch($list_type)
	{
	case 'favorites':
	$fav_table = $this->Application->getUnitOption('fav','TableName');
	$user_id =& $this->Application->GetVar('u_id');

	$sql = 'SELECT DISTINCT f.ResourceId
	FROM '.$fav_table.' f
	LEFT JOIN '.$object->TableName.' p ON p.ResourceId = f.ResourceId
	WHERE f.PortalUserId = '.$user_id;
	$ids = $this->Conn->GetCol($sql);
	if(!$ids) $ids = Array(-1);
	$object->addFilter('category_filter', TABLE_PREFIX.'CategoryItems.PrimaryCat = 1');
	$object->addFilter('favorites_filter', '%1$s.`ResourceId` IN ('.implode(',',$ids).')');
	break;
	case 'search':
	$search_results_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = ' SELECT DISTINCT ResourceId
	FROM '.$search_results_table.'
	WHERE ItemType=11';
	$ids = $this->Conn->GetCol($sql);
	if(!$ids) $ids = Array(-1);
	$object->addFilter('search_filter', '%1$s.`ResourceId` IN ('.implode(',',$ids).')');
	break;
	} */

	$object->addFilter('includes_filter', $includes_or_filter);
	$object->addFilter('excepts_filter', $excepts_and_filter);

	$object->addFilter('includes_filter_h', $includes_or_filter_h, HAVING_FILTER);
	$object->addFilter('excepts_filter_h', $excepts_and_filter_h, HAVING_FILTER);
	}

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function prepareObject(&$object, &$event)
	{
	$this->prepareItemStatuses($event);

	if ($event->Special == 'export' \|\| $event->Special == 'import')
	{
	$this->prepareExportColumns($event);
	}
	}

	/**
	* Creates calculated fields for all item statuses based on config settings
	*
	* @param kEvent $event
	*/
	function prepareItemStatuses(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');

	$new_days_var = getArrayValue($property_mappings, 'NewDays');
	if($new_days_var)
	{
	$object->addCalculatedField('IsNew', ' IF(%1$s.NewItem = 2,
	IF(%1$s.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue($new_days_var).
	'360024), 1, 0),
	%1$s.NewItem
	)');
	}

	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');
	if($hot_limit_var)
	{
	$sql = 'SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName = "'.$hot_limit_var.'"';
	$hot_limit = $this->Conn->GetOne($sql);
	if($hot_limit === false) $hot_limit = $this->CalculateHotLimit($event);
	$object->addCalculatedField('IsHot', ' IF(%1$s.HotItem = 2,
	IF(%1$s.Hits >= '.$hot_limit.', 1, 0),
	%1$s.HotItem
	)');
	}

	$votes2pop_var = getArrayValue($property_mappings, 'VotesToPop');
	$rating2pop_var = getArrayValue($property_mappings, 'RatingToPop');

	if($votes2pop_var && $rating2pop_var)
	{
	$object->addCalculatedField('IsPop', ' IF(%1$s.PopItem = 2,
	IF(%1$s.CachedVotesQty >= '.
	$this->Application->ConfigValue($votes2pop_var).
	' AND %1$s.CachedRating >= '.
	$this->Application->ConfigValue($rating2pop_var).
	', 1, 0),
	%1$s.PopItem)');
	}
	}

	function CalculateHotLimit(&$event)
	{
	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	$hot_count_var = getArrayValue($property_mappings, 'HotCount');
	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');

	if($hot_count_var && $hot_limit_var)
	{
	$last_hot = $this->Application->ConfigValue($hot_count_var) - 1;
	$sql = 'SELECT Hits FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	ORDER BY Hits DESC
	LIMIT '.$last_hot.', 1';
	$res = $this->Conn->GetCol($sql);
	$hot_limit = (double)array_shift($res);
	$this->Conn->Query('REPLACE INTO '.TABLE_PREFIX.'Cache VALUES ("'.$hot_limit_var.'", "'.$hot_limit.'", '.adodb_mktime().')');
	return $hot_limit;
	}
	return 0;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	if( $this->Application->IsAdmin() && ($this->Application->GetVar('Hits_original') !== false) &&
	floor($this->Application->GetVar('Hits_original')) != $object->GetDBField('Hits') )
	{
	$sql = 'SELECT MAX(Hits) FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	WHERE FLOOR(Hits) = '.$object->GetDBField('Hits');
	$hits = ( $res = $this->Conn->GetOne($sql) ) ? $res + 0.000001 : $object->GetDBField('Hits');
	$object->SetDBField('Hits', $hits);
	}
	}

	/**
	* Load price from temp table if product mode is temp table
	*
	* @param kEvent $event
	*/
	function OnAfterItemLoad(&$event)
	{
	$special = substr($event->Special, -6);
	if ($special == 'import' \|\| $special == 'export') {
	$object =& $event->getObject();
	$image_data = $object->getPrimaryImageData();

	if ($image_data) {
	$thumbnail_image = $image_data[$image_data['LocalThumb'] ? 'ThumbPath' : 'ThumbUrl'];
	if ($image_data['SameImages']) {
	$full_image = '';
	}
	else {
	$full_image = $image_data[$image_data['LocalImage'] ? 'LocalPath' : 'Url'];
	}
	$object->SetDBField('ThumbnailImage', $thumbnail_image);
	$object->SetDBField('FullImage', $full_image);
	$object->SetDBField('ImageAlt', $image_data['AltName']);
	}
	}

	}

	function OnAfterItemUpdate(&$event)
	{
	$this->CalculateHotLimit($event);

	if ( substr($event->Special, -6) == 'import') {
	$this->setCustomExportColumns($event);
	}
	}

	/**
	* sets values for import process
	*
	* @param kEvent $event
	*/
	function OnAfterItemCreate(&$event)
	{
	if ( substr($event->Special, -6) == 'import') {
	$this->setCustomExportColumns($event);
	}
	}

	/**
	* Make record to search log
	*
	* @param string $keywords
	* @param int $search_type 0 - simple search, 1 - advanced search
	*/
	function saveToSearchLog($keywords, $search_type = 0)
	{
	$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');
	}
	}

	/**
	* Makes simple search for products
	* based on keywords string
	*
	* @param kEvent $event
	* @todo Change all hardcoded Products table & In-Commerce module usage to dynamic usage from item config !!!
	*/
	function OnSimpleSearch(&$event)
	{
	if($this->Application->GetVar('INPORTAL_ON') && !($this->Application->GetVar('Action') == 'm_simple_search'))
	{
	return;
	}

	$event->redirect = false;
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';

	$keywords = unhtmlentities( trim($this->Application->GetVar('keywords')) );

	$query_object =& $this->Application->recallObject('HTTPQuery');
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';

	if(!isset($query_object->Get['keywords']) &&
	!isset($query_object->Post['keywords']) &&
	$this->Conn->Query($sql))
	{
	return; // used when navigating by pages or changing sorting in search results
	}
	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);
	if (!$this->Application->GetVar('INPORTAL_ON')) {
	// don't save search log, because in-portal already saved it
	$this->saveToSearchLog($keywords, 0); // 0 - simple search, 1 - advanced search
	}


	$keywords = strtr($keywords, Array('%' => '\\%', '_' => '\\_'));

	$event->setPseudoClass('_List');
	$object =& $event->getObject();
	$this->Application->SetVar($event->getPrefixSpecial().'_Page', 1);
	$lang = $this->Application->GetVar('m_lang');
	$product_table = $this->Application->getUnitOption('p', 'TableName');

	$sql = ' SELECT * FROM '.$this->Application->getUnitOption('confs', 'TableName').'
	WHERE ModuleName="In-Commerce"
	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 '.$product_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) {
	$options = $object->getFieldOptions($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 (getArrayValue($options, 'formatter') == 'kMultiLanguage') {
	$field_list[$key] = 'l'.$lang.'_'.$field;
	}

	// processing fields from other tables
	if($foreign_field = $search_config[$field]['ForeignField'])
	{
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	unset($field_list[$key]);
	continue; // ignoring having type clauses in simple search
	/*$user_object =& $this->Application->recallObject('u');
	$user_groups = $this->Application->RecallVar('UserGroups');
	$having_list[$key] = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;
	$join_clauses[] = $join_clause;*/
	}
	else
	{
	$exploded = explode('.', $foreign_field); // format: table.field_name
	$foreign_table = TABLE_PREFIX.$exploded[0];

	$alias_counter++;
	$alias = 't'.$alias_counter;

	$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}', $product_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';
	$field_list[$key] = 'l'.$lang.'_cust_'.array_search($field_list[$key], $custom_fields);
	}
	$field_list[$key] = $local_table.'.'.$field_list[$key];
	$search_config_map[ $field_list[$key] ] = $field;
	}
	}

	// keyword string processing
	$search_helper =& $this->Application->recallObject('SearchHelper');
	$where_clause = $search_helper->buildWhereClause($keywords, $field_list);

	$where_clause = $where_clause.' AND '.$product_table.'.Status=1';

	if($this->Application->GetVar('Action') == 'm_simple_subsearch') // subsearch, In-portal
	{
	if( $event->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$product_table.'.ResourceId IN ('.implode(',', $event->specificParams['ResultIds']).')';
	}
	}
	if( $event->MasterEvent && $event->MasterEvent->Name == 'OnListBuild' ) // subsearch, k4
	{
	if( $event->MasterEvent->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$product_table.'.ResourceId IN ('.implode(',', $event->MasterEvent->getEventParam('ResultIds')).')';
	}
	}

	// making relevance clause
	$positive_words = $search_helper->getPositiveKeywords($keywords);
	$this->Application->StoreVar('highlight_keywords', serialize($positive_words));
	$revelance_parts = Array();
	reset($search_config);
	foreach ($field_list as $field) {
	$config_elem = each($search_config);
	$weight = $search_config[ $search_config_map[$field] ]['Priority'];
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.implode(' ', $positive_words).'%", '.$weight_sum.', 0)';
	foreach ($positive_words as $keyword) {
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.$keyword.'%", '.$config_elem['value']['Priority'].', 0)';
	}
	}
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_products') / 100;
	$relevance_clause = '('.implode(' + ', $revelance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;

	// building final search query
	if (!$this->Application->GetVar('INPORTAL_ON')) {
	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table); // erase old search table if clean k4 event
	}

	if ($this->Conn->Query('SHOW TABLES LIKE "'.$search_table.'"')) {
	$select_intro = 'INSERT INTO '.$search_table.' (Relevance, ItemId, ResourceId, ItemType, EdPick) ';
	}
	else {
	$select_intro = 'CREATE TABLE '.$search_table.' AS ';
	}

	$sql = $select_intro.' SELECT '.$relevance_clause.' AS Relevance,
	'.$product_table.'.ProductId AS ItemId,
	'.$product_table.'.ResourceId,
	11 AS ItemType,
	'.$product_table.'.EditorsPick AS EdPick
	FROM '.$object->TableName.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$product_table.'.ProductId';

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSubSearch(&$event)
	{
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';
	$sql = 'SHOW TABLES LIKE "'.$search_table.'"';
	if($this->Conn->Query($sql))
	{
	$sql = 'SELECT DISTINCT ResourceId FROM '.$search_table;
	$ids = $this->Conn->GetCol($sql);
	}
	$event->setEventParam('ResultIds', $ids);
	$event->CallSubEvent('OnSimpleSearch');
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @todo Change all hardcoded Products table & In-Commerce module usage to dynamic usage from item config !!!
	*/
	function OnAdvancedSearch(&$event)
	{
	$query_object =& $this->Application->recallObject('HTTPQuery');
	if(!isset($query_object->Post['andor']))
	{
	return; // used when navigating by pages or changing sorting in search results
	}

	$this->Application->RemoveVar('keywords');
	$this->Application->RemoveVar('Search_Keywords');

	$sql = ' SELECT * FROM '.$this->Application->getUnitOption('confs', 'TableName').'
	WHERE ModuleName="In-Commerce"
	AND AdvancedSearch=1';
	$search_config = $this->Conn->Query($sql);
	$lang = $this->Application->GetVar('m_lang');
	$object =& $event->getObject();
	$object->SetPage(1);
	$user_object =& $this->Application->recallObject('u');
	$product_table = $this->Application->getUnitOption('p', 'TableName');

	$search_keywords = $this->Application->GetVar('value'); // will not be changed

	$keywords = $this->Application->GetVar('value'); // will be changed down there
	$verbs = $this->Application->GetVar('verb');
	$glues = $this->Application->GetVar('andor');

	$and_conditions = Array();
	$or_conditions = Array();
	$and_having_conditions = Array();
	$or_having_conditions = Array();
	$join_clauses = Array();
	$highlight_keywords = Array();
	$relevance_parts = Array();

	$condition_patterns = Array( 'any' => '%s LIKE %s',
	'contains' => '%s LIKE %s',
	'notcontains' => '(NOT (%1$s LIKE %2$s) OR %1$s IS NULL)',
	'is' => '%s = %s',
	'isnot' => '(%1$s != %2$s OR %1$s IS NULL)');

	$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 '.$product_table.'.ResourceId = custom_data.ResourceId';
	}

	$search_log = '';
	$weight_sum = 0;
	// processing fields and preparing conditions
	foreach($search_config as $record)
	{
	$field = $record['FieldName'];
	$join_clause = '';
	$condition_mode = 'WHERE';

	// field processing

	$options = $object->getFieldOptions($field);
	$local_table = TABLE_PREFIX.$record['TableName'];
	$weight_sum += $record['Priority']; // counting weight sum; used when making relevance clause

	// processing multilingual fields
	if (getArrayValue($options, 'formatter') == 'kMultiLanguage') {
	$field_name = 'l'.$lang.'_'.$field;
	}
	else {
	$field_name = $field;
	}

	// processing fields from other tables
	if ($foreign_field = $record['ForeignField']) {
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	$user_groups = $this->Application->RecallVar('UserGroups');
	$field_name = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $record['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;

	$condition_mode = 'HAVING';
	}
	else {
	$exploded = explode('.', $foreign_field);
	$foreign_table = TABLE_PREFIX.$exploded[0];

	if($record['CustomFieldId']) {
	$exploded[1] = 'l'.$lang.'_'.$exploded[1];
	}

	$alias_counter++;
	$alias = 't'.$alias_counter;

	$field_name = $alias.'.'.$exploded[1];
	$join_clause = str_replace('{ForeignTable}', $alias, $record['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $product_table, $join_clause);

	if($record['CustomFieldId'])
	{
	$join_clause .= ' AND '.$alias.'.CustomFieldId='.$record['CustomFieldId'];
	}
	$join_clause = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else
	{
	// processing fields from local table
	if ($record['CustomFieldId']) {
	$local_table = 'custom_data';
	$field_name = 'l'.$lang.'_cust_'.array_search($field_name, $custom_fields);
	}

	$field_name = $local_table.'.'.$field_name;
	}

	$condition = '';
	switch($record['FieldType'])
	{
	case 'text':
	$keywords[$field] = unhtmlentities( $keywords[$field] );

	if(strlen($keywords[$field]) >= $this->Application->ConfigValue('Search_MinKeyword_Length'))
	{
	$highlight_keywords[] = $keywords[$field];
	if( in_array($verbs[$field], Array('any', 'contains', 'notcontains')) )
	{
	$keywords[$field] = '%'.strtr($keywords[$field], Array('%' => '\\%', '_' => '\\_')).'%';
	}
	$condition = sprintf( $condition_patterns[$verbs[$field]],
	$field_name,
	$this->Conn->qstr( $keywords[$field] ));
	}
	break;
	case 'boolean':
	if($keywords[$field] != -1)
	{
	$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	switch($field)
	{
	case 'HotItem':
	$hot_limit_var = getArrayValue($property_mappings, 'HotLimit');
	if($hot_limit_var)
	{
	$sql = 'SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName="'.$hot_limit_var.'"';
	$hot_limit = (int)$this->Conn->GetOne($sql);
	$condition = 'IF('.$product_table.'.HotItem = 2,
	IF('.$product_table.'.Hits >= '.
	$hot_limit.
	', 1, 0), '.$product_table.'.HotItem) = '.$keywords[$field];
	}
	break;
	case 'PopItem':
	$votes2pop_var = getArrayValue($property_mappings, 'VotesToPop');
	$rating2pop_var = getArrayValue($property_mappings, 'RatingToPop');
	if($votes2pop_var && $rating2pop_var)
	{
	$condition = 'IF('.$product_table.'.PopItem = 2, IF('.$product_table.'.CachedVotesQty >= '.
	$this->Application->ConfigValue($votes2pop_var).
	' AND '.$product_table.'.CachedRating >= '.
	$this->Application->ConfigValue($rating2pop_var).
	', 1, 0), '.$product_table.'.PopItem) = '.$keywords[$field];
	}
	break;
	case 'NewItem':
	$new_days_var = getArrayValue($property_mappings, 'NewDays');
	if($new_days_var)
	{
	$condition = 'IF('.$product_table.'.NewItem = 2,
	IF('.$product_table.'.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue($new_days_var).
	'360024), 1, 0), '.$product_table.'.NewItem) = '.$keywords[$field];
	}
	break;
	case 'EditorsPick':
	$condition = $product_table.'.EditorsPick = '.$keywords[$field];
	break;
	}
	}
	break;
	case 'range':
	$range_conditions = Array();
	if($keywords[$field.'_from'] && !preg_match("/[^0-9]/i", $keywords[$field.'_from']))
	{
	$range_conditions[] = $field_name.' >= '.$keywords[$field.'_from'];
	}
	if($keywords[$field.'_to'] && !preg_match("/[^0-9]/i", $keywords[$field.'_to']))
	{
	$range_conditions[] = $field_name.' <= '.$keywords[$field.'_to'];
	}
	if($range_conditions)
	{
	$condition = implode(' AND ', $range_conditions);
	}
	break;
	case 'date':
	if($keywords[$field])
	{
	if( in_array($keywords[$field], Array('today', 'yesterday')) )
	{
	$current_time = getdate();
	$day_begin = adodb_mktime(0, 0, 0, $current_time['mon'], $current_time['mday'], $current_time['year']);
	$time_mapping = Array('today' => $day_begin, 'yesterday' => ($day_begin - 86400));
	$min_time = $time_mapping[$keywords[$field]];
	}
	else
	{
	$time_mapping = Array( 'last_week' => 604800, 'last_month' => 2628000,
	'last_3_months' => 7884000, 'last_6_months' => 15768000,
	'last_year' => 31536000
	);
	$min_time = adodb_mktime() - $time_mapping[$keywords[$field]];
	}
	$condition = $field_name.' > '.$min_time;
	}
	break;
	}

	if($condition)
	{
	if($join_clause)
	{
	$join_clauses[] = $join_clause;
	}
	$relevance_parts[] = 'IF('.$condition.', '.$record['Priority'].', 0)';
	if($glues[$field] == 1) // and
	{
	if($condition_mode == 'WHERE')
	{
	$and_conditions[] = $condition;
	}
	else
	{
	$and_having_conditions[] = $condition;
	}
	}
	else // or
	{
	if($condition_mode == 'WHERE')
	{
	$or_conditions[] = $condition;
	}
	else
	{
	$or_having_conditions[] = $condition;
	}
	}

	// create search log record
	$search_log_data = Array('search_config' => $record, 'verb' => getArrayValue($verbs, $field), 'value' => ($record['FieldType'] == 'range') ? $search_keywords[$field.'_from'].'\|'.$search_keywords[$field.'_to'] : $search_keywords[$field]);
	$search_log[] = $this->Application->Phrase('la_Field').' "'.$this->getHuman('Field', $search_log_data).'" '.$this->getHuman('Verb', $search_log_data).' '.$this->Application->Phrase('la_Value').' '.$this->getHuman('Value', $search_log_data).' '.$this->Application->Phrase($glues[$field] == 1 ? 'lu_And' : 'lu_Or');
	}
	}

	$search_log = implode('<br />', $search_log);
	$search_log = preg_replace('/(.*) '.preg_quote($this->Application->Phrase('lu_and'), '/').'\|'.preg_quote($this->Application->Phrase('lu_or'), '/').'$/is', '\\1', $search_log);
	$this->saveToSearchLog($search_log, 1); // advanced search

	$this->Application->StoreVar('highlight_keywords', serialize($highlight_keywords));

	// making relevance clause
	if($relevance_parts)
	{
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_products') / 100;
	$relevance_clause = '('.implode(' + ', $relevance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;
	}
	else
	{
	$relevance_clause = '0';
	}

	// building having clause
	if($or_having_conditions)
	{
	$and_having_conditions[] = '('.implode(' OR ', $or_having_conditions).')';
	}
	$having_clause = implode(' AND ', $and_having_conditions);
	$having_clause = $having_clause ? ' HAVING '.$having_clause : '';

	// building where clause
	if($or_conditions)
	{
	$and_conditions[] = '('.implode(' OR ', $or_conditions).')';
	}
	// $and_conditions[] = $product_table.'.Status = 1';
	$where_clause = implode(' AND ', $and_conditions);
	if(!$where_clause)
	{
	if($having_clause)
	{
	$where_clause = '1';
	}
	else
	{
	$where_clause = '0';
	$this->Application->SetVar('adv_search_error', 1);
	}
	}
	$where_clause .= ' AND '.$product_table.'.Status = 1';

	// building final search query
	$search_table = TABLE_PREFIX.'ses_'.$this->Application->GetSID().'_'.TABLE_PREFIX.'Search';

	$this->Conn->Query('DROP TABLE IF EXISTS '.$search_table);

	$sql = ' CREATE TABLE '.$search_table.'
	SELECT '.$relevance_clause.' AS Relevance,
	'.$product_table.'.ProductId AS ItemId,
	'.$product_table.'.ResourceId AS ResourceId,
	11 AS ItemType,
	'.$product_table.'.EditorsPick AS EdPick
	FROM '.$product_table.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$product_table.'.ProductId'.
	$having_clause;

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


	function getHuman($type, $search_data)
	{
	$type = ucfirst(strtolower($type));
	extract($search_data);

	switch ($type) {
	case 'Field':
	return $this->Application->Phrase($search_config['DisplayName']);
	break;

	case 'Verb':
	return $verb ? $this->Application->Phrase('lu_advsearch_'.$verb) : '';
	break;

	case 'Value':
	switch ($search_config['FieldType']) {
	case 'date':
	$values = Array(0 => 'lu_comm_Any', 'today' => 'lu_comm_Today',
	'yesterday' => 'lu_comm_Yesterday', 'last_week' => 'lu_comm_LastWeek',
	'last_month' => 'lu_comm_LastMonth', 'last_3_months' => 'lu_comm_Last3Months',
	'last_6_months' => 'lu_comm_Last6Months', 'last_year' => 'lu_comm_LastYear');
	$ret = $this->Application->Phrase($values[$value]);
	break;

	case 'range':
	$value = explode('\|', $value);
	return $this->Application->Phrase('lu_comm_From').' "'.$value[0].'" '.$this->Application->Phrase('lu_comm_To').' "'.$value[1].'"';
	break;

	case 'boolean':
	$values = Array(1 => 'lu_comm_Yes', 0 => 'lu_comm_No', -1 => 'lu_comm_Both');
	$ret = $this->Application->Phrase($values[$value]);
	break;

	case 'text':
	$ret = $value;
	break;

	}
	return '"'.$ret.'"';
	break;
	}
	}



	/**
	* Set's correct page for list
	* based on data provided with event
	*
	* @param kEvent $event
	* @access private
	* @see OnListBuild
	*/
	function SetPagination(&$event)
	{
	// get PerPage (forced -> session -> config -> 10)
	$per_page = $this->getPerPage($event);

	$object =& $event->getObject();
	$object->SetPerPage($per_page);
	$this->Application->StoreVarDefault($event->getPrefixSpecial().'_Page', 1);

	$page = $this->Application->GetVar($event->getPrefixSpecial().'_Page');
	if (!$page)
	{
	$page = $this->Application->GetVar($event->getPrefixSpecial(true).'_Page');
	}

	if (!$page)
	{
	if( $this->Application->RewriteURLs() )
	{
	$page = $this->Application->GetVar($event->Prefix.'_Page');
	if (!$page)
	{
	$page = $this->Application->RecallVar($event->Prefix.'_Page');
	}
	if($page) $this->Application->StoreVar($event->getPrefixSpecial().'_Page', $page);
	}
	else
	{
	$page = $this->Application->RecallVar($event->getPrefixSpecial().'_Page');
	}
	}
	else {
	$this->Application->StoreVar($event->getPrefixSpecial().'_Page', $page);
	}

	if( !$event->getEventParam('skip_counting') )
	{
	$pages = $object->GetTotalPages();
	if($page > $pages)
	{
	$this->Application->StoreVar($event->getPrefixSpecial().'_Page', 1);
	$page = 1;
	}
	}

	/*$cur_per_page = $per_page;
	$per_page = $event->getEventParam('per_page');
	if ($per_page == 'list_next') {

	$cur_page = $page;

	$object =& $this->Application->recallObject($event->Prefix);
	$object->SetPerPage(1);
	$cur_item_index = $object->CurrentIndex;

	$page = ($cur_page-1) * $cur_per_page + $cur_item_index + 1;
	$object->SetPerPage(1);
	}*/

	$object->SetPage($page);
	}

	/* === RELATED TO IMPORT/EXPORT: BEGIN === */

	/**
	* Returns module folder
	*
	* @param kEvent $event
	* @return string
	*/
	function getModuleFolder(&$event)
	{
	return $this->Application->getUnitOption($event->Prefix, 'ModuleFolder');
	}

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnExport(&$event)
	{
	// use old fasion (in-portal) grid
	$selector_name = $this->Application->getUnitOption($event->Prefix, 'CatalogSelectorName');
	if ($selector_name) {
	$selected_ids = $this->Application->GetVar($selector_name);
	}
	else {
	$this->StoreSelectedIDs($event);
	$selected_ids = $this->getSelectedIDs($event);

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

	$selected_cats_ids = $this->Application->GetVar('export_categories');

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

	$event->redirect = $this->getModuleFolder($event).'/export';

	$redirect_params = Array( 'm_opener' => 'd',
	'index_file' => 'index4.php',
	$this->Prefix.'.export_event' => 'OnNew',
	'pass' => 'all,'.$this->Prefix.'.export');

	$event->setRedirectParams($redirect_params);
	}

	/**
	* Export form validation & processing
	*
	* @param kEvent $event
	*/
	function OnExportBegin(&$event)
	{
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if (!$items_info)
	{
	$items_info = unserialize( $this->Application->RecallVar($event->getPrefixSpecial().'_ItemsInfo') );
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);
	}

	list($item_id, $field_values) = each($items_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);
	$field_values['ImportFilename'] = $object->GetDBField('ImportFilename'); //if upload formatter has renamed the file during moving !!!

	$object->setID($item_id);
	$this->setRequiredFields($event);

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

	// save export/import options
	if ($event->Special == 'export')
	{
	$export_ids = $this->Application->RecallVar($event->Prefix.'_export_ids');
	$export_cats_ids = $this->Application->RecallVar($event->Prefix.'_export_cats_ids');

	// used for multistep export
	$field_values['export_ids'] = $export_ids ? explode(',', $export_ids) : false;
	$field_values['export_cats_ids'] = $export_cats_ids ? explode(',', $export_cats_ids) : Array( $this->Application->GetVar('m_cat_id') );
	}

	$field_values['ExportColumns'] = $field_values['ExportColumns'] ? explode('\|', substr($field_values['ExportColumns'], 1, -1) ) : Array();
	$field_values['start_from'] = 0;
	$export_object->saveOptions($event, $field_values);

	if( $export_object->verifyOptions($event) )
	{
	$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_progress';

	}
	else
	{
	// make uploaded file local & change source selection
	$filename = getArrayValue($field_values, 'ImportFilename');
	if ($filename) {
	$this->updateImportFiles($event);
	$object->SetDBField('ImportSource', 2);
	$field_values['ImportSource'] = 2;
	$object->SetDBField('ImportLocalFilename', $filename);
	$field_values['ImportLocalFilename'] = $filename;
	$export_object->saveOptions($event, $field_values);
	}

	$event->status = erFAIL;
	$event->redirect = false;
	}
	}

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

	/**
	* Sets correct available & export fields
	*
	* @param kEvent $event
	*/
	function prepareExportColumns(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$available_columns = Array();

	// category field (mixed)
	$available_columns['__CATEGORY__CategoryPath'] = 'CategoryPath';

	if ($event->Special == 'import') {
	// category field (separated fields)
	$max_level = $this->Application->ConfigValue('MaxImportCategoryLevels');
	$i = 0;
	while ($i < $max_level) {
	$available_columns['__CATEGORY__Category'.($i + 1)] = 'Category'.($i + 1);
	$i++;
	}
	}

	// db fields
	foreach ($object->Fields as $field_name => $field_options)
	{
	if (!$object->SkipField($field_name))
	{
	$available_columns[$field_name] = $field_name.(getArrayValue($field_options, 'required') ? '*' : '');
	}
	}

	$available_columns = array_merge_recursive2($available_columns, $this->getCustomExportColumns($event));

	// custom fields
	foreach ($object->customFields as $custom_id => $custom_name)
	{
	$available_columns['__CUSTOM__'.$custom_name] = $custom_name;
	}

	// columns already in use
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info)
	{
	list($item_id, $field_values) = each($items_info);
	$export_keys = $field_values['ExportColumns'];
	$export_keys = $export_keys ? explode('\|', substr($export_keys, 1, -1) ) : Array();
	}
	else {
	$export_keys = Array();
	}

	$export_columns = Array();
	foreach ($export_keys as $field_key)
	{
	$field_name = $this->getExportField($field_key);
	$export_columns[$field_key] = $field_name;
	unset($available_columns[$field_key]);
	}

	$options = $object->GetFieldOptions('ExportColumns');
	$options['options'] = $export_columns;
	$object->SetFieldOptions('ExportColumns', $options);

	$options = $object->GetFieldOptions('AvailableColumns');
	$options['options'] = $available_columns;
	$object->SetFieldOptions('AvailableColumns', $options);

	$this->updateImportFiles($event);
	}

	/**
	* Updates uploaded files list
	*
	* @param kEvent $event
	*/
	function updateImportFiles(&$event)
	{
	if ($event->Special != 'import') {
	return false;
	}

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

	$import_filenames = Array();

	if ($folder_handle = opendir(EXPORT_PATH)) {
	while (false !== ($file = readdir($folder_handle))) {
	if (is_dir(EXPORT_PATH.'/'.$file) \|\| substr($file, 0, 1) == '.' \|\| strtolower($file) == 'cvs' \|\| strtolower($file) == 'dummy' \|\| filesize(EXPORT_PATH.'/'.$file) == 0) continue;

	$file_size = formatSize( filesize(EXPORT_PATH.'/'.$file) );
	$import_filenames[$file] = $file.' ('.$file_size.')';
	}
	closedir($folder_handle);
	}

	$options = $object->GetFieldOptions('ImportLocalFilename');
	$options['options'] = $import_filenames;
	$object->SetFieldOptions('ImportLocalFilename', $options);
	}

	/**
	* Returns specific to each item type columns only
	*
	* @param kEvent $event
	* @return Array
	*/
	function getCustomExportColumns(&$event)
	{
	return Array( '__VIRTUAL__ThumbnailImage' => 'ThumbnailImage',
	'__VIRTUAL__FullImage' => 'FullImage',
	'__VIRTUAL__ImageAlt' => 'ImageAlt');
	}

	/**
	* Sets non standart virtual fields (e.g. to other tables)
	*
	* @param kEvent $event
	*/
	function setCustomExportColumns(&$event)
	{
	$this->restorePrimaryImage($event);
	}

	/**
	* Create/Update primary image record in info found in imported data
	*
	* @param kEvent $event
	*/
	function restorePrimaryImage(&$event)
	{
	$object =& $event->getObject();

	$has_image_info = $object->GetDBField('ImageAlt') && ($object->GetDBField('ThumbnailImage') \|\| $object->GetDBField('FullImage'));
	if (!$has_image_info) {
	return false;
	}

	$image_data = $object->getPrimaryImageData();

	$image =& $this->Application->recallObject('img', null, Array('skip_autoload' => true));
	if ($image_data) {
	$image->Load($image_data['ImageId']);
	}
	else {
	$image->Clear();
	$image->SetDBField('Name', 'main');
	$image->SetDBField('DefaultImg', 1);
	$image->SetDBField('ResourceId', $object->GetDBField('ResourceId'));
	}

	$image->SetDBField('AltName', $object->GetDBField('ImageAlt'));

	if ($object->GetDBField('ThumbnailImage')) {
	$thumbnail_field = $this->isURL( $object->GetDBField('ThumbnailImage') ) ? 'ThumbUrl' : 'ThumbPath';
	$image->SetDBField($thumbnail_field, $object->GetDBField('ThumbnailImage') );
	$image->SetDBField('LocalThumb', $thumbnail_field == 'ThumbPath' ? 1 : 0);
	}

	if (!$object->GetDBField('FullImage')) {
	$image->SetDBField('SameImages', 1);
	}
	else {
	$image->SetDBField('SameImages', 0);
	$full_field = $this->isURL( $object->GetDBField('FullImage') ) ? 'Url' : 'LocalPath';
	$image->SetDBField($full_field, $object->GetDBField('FullImage') );
	$image->SetDBField('LocalImage', $full_field == 'LocalPath' ? 1 : 0);
	}

	if ($image->isLoaded()) {
	$image->Update();
	}
	else {
	$image->Create();
	}
	}

	function isURL($path)
	{
	return preg_match('#(http\|https)://(.*)#', $path);
	}

	// ImportLocalFilename

	function getExportField($field_key)
	{
	$prepends = Array('__CUSTOM__', '__CATEGORY__');
	foreach ($prepends as $prepend)
	{
	if (substr($field_key, 0, strlen($prepend) ) == $prepend)
	{
	$field_key = substr($field_key, strlen($prepend), strlen($field_key) );
	break;
	}
	}
	return $field_key;
	}

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnImport(&$event)
	{

	$event->redirect = $this->getModuleFolder($event).'/import';

	$redirect_params = Array( 'm_opener' => 'd',
	'index_file' => 'index4.php',
	$this->Prefix.'.import_event' => 'OnNew',
	'pass' => 'all,'.$this->Prefix.'.import');

	$event->setRedirectParams($redirect_params);
	}

	/**
	* Prepares item for import/export operations
	*
	* @param kEvent $event
	*/
	function OnNew(&$event)
	{
	parent::OnNew($event);

	if ($event->Special != 'import' && $event->Special != 'export') return ;
	$this->setRequiredFields($event);
	$this->Application->StoreVar('ImportCategory', 0);
	}

	/**
	* set required fields based on import or export params
	*
	* @param kEvent $event
	*/
	function setRequiredFields(&$event)
	{
	$required_fields['common'] = Array('FieldsSeparatedBy', 'LineEndings', 'CategoryFormat');

	$required_fields['export'] = Array('ExportFormat', 'ExportFilename','ExportColumns');
	$required_fields['import'] = Array('FieldTitles', 'ImportSource', 'CheckDuplicatesMethod'); // ImportFilename, ImportLocalFilename

	$object =& $event->getObject();
	if ($event->Special == 'import')
	{
	$import_source = Array(1 => 'ImportFilename', 2 => 'ImportLocalFilename');
	$used_field = $import_source[ $object->GetDBField('ImportSource') ];

	$required_fields[$event->Special][] = $used_field;
	$object->Fields[$used_field]['error_field'] = 'ImportSource';

	if ($object->GetDBField('FieldTitles') == 2) $required_fields[$event->Special][] = 'ExportColumns'; // manual field titles
	}

	$required_fields = array_merge($required_fields['common'], $required_fields[$event->Special]);
	foreach ($required_fields as $required_field) {
	$object->setRequired($required_field, true);
	}
	}

	/**
	* Saves selected category as new import category
	*
	* @param kEvent $event
	*/
	function OnSelectItems(&$event)
	{
	$dst_field = $this->Application->RecallVar('dst_field');
	$items_info = $this->Application->GetVar('c');
	if ($items_info) {
	$category_id = array_shift( array_keys($items_info) );
	$sql = 'SELECT CategoryId
	FROM '.TABLE_PREFIX.'Category
	WHERE ResourceId = '.$category_id;
	$category_id = $this->Conn->GetOne($sql);
	}
	else {
	$category_id = 0;
	}

	if ($dst_field == 'ImportCategory') {
	$this->Application->StoreVar('ImportCategory', $category_id);
	$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 1); // not to loose import/export values on form refresh

	$this->Application->SetVar($event->getPrefixSpecial().'_id', 0);
	$this->Application->SetVar($event->getPrefixSpecial().'_event', 'OnExportBegin');

	$passed = $this->Application->GetVar('passed');
	$this->Application->SetVar('passed', $passed.','.$event->getPrefixSpecial());
	$event->setEventParam('pass_events', true);
	}

	if ($dst_field == 'ItemCategory') {
	$object =& $event->getObject(); // category item object (e.g. link, product, etc.)

	$ci_prefix = $object->Prefix.'-ci';
	$ci_object =& $this->Application->recallObject($ci_prefix, null, Array('skip_autoload' => true));

	$ci_object->Load($category_id);
	if (!$ci_object->isLoaded()) {
	$fields_hash = Array('CategoryId' => $category_id, 'ItemResourceId' => $object->GetDBField('ResourceId'));
	$ci_object->SetDBFieldsFromHash($fields_hash);
	$ci_object->Create(true);
	}
	}

	$this->finalizePopup($event);
	}

	/**
	* Saves Import/Export settings to session
	*
	* @param kEvent $event
	*/
	function OnSaveSettings(&$event)
	{
	$event->redirect = false;
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info) {
	list($id, $field_values) = each($items_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);
	$field_values['ImportFilename'] = $object->GetDBField('ImportFilename'); //if upload formatter has renamed the file during moving !!!
	$field_values['ImportSource'] = 2;
	$field_values['ImportLocalFilename'] = $object->GetDBField('ImportFilename');
	$items_info[$id] = $field_values;

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

	/* === RELATED TO IMPORT/EXPORT: END === */

	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/general/cat_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.52
	\ No newline at end of property
	+1.53
	\ No newline at end of property
	Index: trunk/core/units/general/helpers/permissions_helper.php
	===================================================================
	--- trunk/core/units/general/helpers/permissions_helper.php (revision 4841)
	+++ trunk/core/units/general/helpers/permissions_helper.php (revision 4842)
	@@ -1,367 +1,368 @@
	<?php

	class kPermissionsHelper extends kHelper {

	/**
	* Current set of permissions for group being edited
	*
	* @var Array
	*/
	var $Permissions = Array();

	function LoadPermissions($prefix)
	{
	$object =& $this->Application->recallObject($prefix.'-perm', null, Array('skip_autoload' => true));

	$foreign_key = $this->Application->getUnitOption($prefix.'-perm', 'ForeignKey');
	$foreign_value = $this->Application->GetVar($prefix.'_id');
	$sql = 'SELECT *
	FROM '.$object->TableName.'
	WHERE '.$foreign_key.' = '.$foreign_value;
	$permissions = $this->Conn->Query($sql, 'Permission');

	$this->Permissions = Array();
	foreach ($permissions as $perm_name => $perm_options) {
	$perm_record['value'] = $perm_options['PermissionValue'];
	$perm_record['id'] = $perm_options['PermissionId'];
	$this->Permissions[$perm_name] = $perm_record;
	}
	}

	function getPermissionValue($perm_name)
	{
	return getArrayValue($this->Permissions, $perm_name) ? $this->Permissions[$perm_name]['value'] : 0;
	}

	function getPermissionID($perm_name)
	{
	return getArrayValue($this->Permissions, $perm_name) ? $this->Permissions[$perm_name]['id'] : 0;
	}

	/**
	* This is old permission like ADMIN or LOGIN
	*
	* @param string $section_name
	* @param string $perm_name
	* @return bool
	*/
	function isOldPermission($section_name, $perm_name)
	{
	return $section_name == 'in-portal:root' && $perm_name != 'view';
	}

	/**
	* Returns permission names to check based on event name and item prefix (main item or subitem)
	*
	* @param kEvent $event
	* @return Array
	*/
	function getPermissionByEvent(&$event, $perm_mapping)
	{
	$top_prefix = $event->getEventParam('top_prefix');

	$pefix_type = ($top_prefix == $event->Prefix) ? 'self' : 'subitem';
	$perm_mapping = getArrayValue($perm_mapping, $event->Name);

	if (!$perm_mapping[$pefix_type]) {
	trigger_error('Permission mappings not defined for event <b>'.$top_prefix.' <- '.$event->Prefix.':'.$event->Name.'</b>', E_USER_ERROR);
	}

	if ($perm_mapping[$pefix_type] === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	return explode('\|', $perm_mapping[$pefix_type]);
	}

	/**
	* Common event permission checking method
	*
	* @param kEvent $event
	*/
	function CheckEventPermission(&$event, $perm_mapping)
	{
	$section = $event->getSection();
	if (preg_match('/^CATEGORY:(.*)/', $section)) {
	return $this->CheckEventCategoryPermission($event, $perm_mapping);
	}

	$top_prefix = $event->getEventParam('top_prefix');
	$check_perms = $this->getPermissionByEvent($event, $perm_mapping);

	if ($check_perms === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	$perm_status = false;
	foreach ($check_perms as $perm_name) {
	// check if at least one of required permissions is set
	$perm_name = $section.'.'.$perm_name;
	$perm_status = $this->CheckPermission($perm_name, 1);
	if (($perm_name == $section.'.add') && $perm_status && ($top_prefix == $event->Prefix)) {
	// main item, add permission allowed, but ID is > 0, then deny permission
	// how to get id here
	}
	if ($perm_status) {
	return $perm_status;
	}
	}

	if (!$perm_status) {
	if ($this->Application->isDebugMode()) {
	// for debugging purposes
	$event->SetRedirectParam('section', $section);
	$event->SetRedirectParam('main_prefix', $top_prefix);
	$event->SetRedirectParam('event_name', $event->Name);
	$event->SetRedirectParam('next_template', $this->Application->GetVar('t'));
	}
	$event->status = erPERM_FAIL;
	}
	return $perm_status;
	}

	/**
	* Checks non-system permission on event per category basis
	*
	* @param kEvent $event
	*/
	function CheckEventCategoryPermission(&$event, $event_perm_mapping)
	{
	// mapping between specific permissions and common permissions
	$perm_mapping = Array('add' => 'ADD', 'edit' => 'MODIFY', 'delete' => 'DELETE', 'view' => 'VIEW');

	$top_prefix = $event->getEventParam('top_prefix');
	$event_handler =& $this->Application->recallObject($event->Prefix.'_EventHandler');
	if ($event->Prefix != $top_prefix) {
	$top_event = new kEvent($top_prefix.':'.$event->Name);
	$id = $event_handler->getPassedID($top_event);
	}
	else {
	$id = $event_handler->getPassedID($event);
	}

	$item_prefix = $this->Application->getUnitOption($top_prefix, 'PermItemPrefix');

	// 1. get primary category of category item
	$id_field = $this->Application->getUnitOption($top_prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($top_prefix, 'TableName');
	$ci_table = $this->Application->getUnitOption($top_prefix.'-ci', 'TableName');

	if (!$id) {
	// item being created -> check by current (before editing started, saved in OnPreCreate event) category permissions
	$category_id = $this->Application->RecallVar('m_cat_id');
	}
	else {
	// item being edited -> check by it's primary category permissions
	$sql = 'SELECT ci.CategoryId
	FROM '.$table_name.' main_table
	LEFT JOIN '.$ci_table.' ci ON ci.ItemResourceId = main_table.ResourceId
	WHERE (main_table.'.$id_field.' = '.$id.') AND (ci.PrimaryCat = 1)';
	$category_id = $this->Conn->GetOne($sql);
	}

	if ((substr($event->Name, 0, 9) == 'OnPreSave') \|\| ($event->Name == 'OnSave')) {
	if ($event_handler->isNewItemCreate($event)) {
	return $this->CheckPermission($item_prefix.'.ADD', 0, $category_id);
	}
	else {
	return $this->CheckPermission($item_prefix.'.ADD', 0, $category_id) \|\| $this->CheckPermission($item_prefix.'.MODIFY', 0, $category_id);
	}
	}

	$perm_status = false;
	$check_perms = $this->getPermissionByEvent($event, $event_perm_mapping);

	if ($check_perms === true) {
	// event is defined in mapping but is not checked by permissions
	return true;
	}

	foreach ($check_perms as $perm_name) {
	// check if at least one of required permissions is set
	if (!isset($perm_mapping[$perm_name])) {
	// not mapped permission (e.g. advanced:approve) -> skip
	continue;
	}
	$perm_name = $item_prefix.'.'.$perm_mapping[$perm_name];
	$this->showDebug('Event <b>'.$event->Name.'</b> permission(-s): <b>'.$perm_name.'</b>');
	$perm_status = $this->CheckPermission($perm_name, 0, $category_id);

	if ($perm_status) {
	return $perm_status;
	}
	}

	if (!$perm_status) {
	$event->SetRedirectParam('index_file', 'index.php'); // because called from browse.php
	if ($this->Application->isDebugMode()) {
	// for debugging purposes
	$event->SetRedirectParam('section', $event->getSection());
	$event->SetRedirectParam('main_prefix', $top_prefix);
	$event->SetRedirectParam('event_name', $event->Name);
	$event->SetRedirectParam('next_template', $this->Application->GetVar('t'));
	}
	$event->status = erPERM_FAIL;
	}
	return $perm_status;
	}

	function showDebug($text)
	{
	if (!$this->Application->isDebugMode()) return true;
	echo $text.'<br />';
	}

	function TagPermissionCheck($params, $tag_name)
	{
	$perm_event = getArrayValue($params, 'perm_event');
	$permission_groups = getArrayValue($params, 'permissions');

	if ($permission_groups) {
	- $this->showDebug('Tag <b>'.$tag_name.'</b> permission(-s): '.$permission_groups);
	+ $this->showDebug('Tag <b>'.$tag_name.'</b> permission(-s): <b>'.$permission_groups.'</b>');
	$permission_groups = explode('\|', $permission_groups);
	$group_has_permission = false;
	foreach ($permission_groups as $permission_group) {
	$permissions = explode(',', $permission_group);
	$has_permission = true;
	foreach ($permissions as $permission) {
	$has_permission = $has_permission && $this->CheckPermission($permission, isset($params['system']) && $params['system'] ? 1 : 0);
	}
	$group_has_permission = $group_has_permission \|\| $has_permission;

	if ($group_has_permission) {
	return true;
	}
	}
	return false;
	}
	elseif ($perm_event) {
	+ $this->showDebug('Tag <b>'.$tag_name.'</b> permission_event: <b>'.$perm_event.'</b>');
	list($prefix, $event) = explode(':', $perm_event);
	$event_handler =& $this->Application->recallObject($prefix.'_EventHandler');
	return $event_handler->CheckPermission( new kEvent($perm_event) );
	}

	return true;
	}

	/**
	* Returns no permission template to redirect to
	*
	* @param Array $params
	* @return Array
	*/
	function getPermissionTemplate($params)
	{
	$t = $this->Application->GetVar('t');
	if ($next_t = getArrayValue($params, 'next_template')) {
	$t = $next_t;
	}

	if (!$this->Application->LoggedIn()) {
	$redirect_template = $params['login_template'];
	$redirect_params = Array('next_template' => $t);
	}
	else {
	if (isset($params['no_permissions_template'])) {
	$redirect_template = $params['no_permissions_template'];
	}
	else {
	$redirect_template = $this->Application->IsAdmin() ? 'no_permission' : $this->Application->ConfigValue('NoPermissionTemplate');
	}

	- $redirect_params = $this->Application->isDebugMode() ? Array('from_template' => 1, 'perms' => $params['permissions'], 'next_template' => $t) : Array();
	+ $redirect_params = $this->Application->isDebugMode() ? Array('from_template' => 1, 'perms' => $params[ isset($params['permissions']) ? 'permissions' : 'perm_event'], 'next_template' => $t) : Array();
	}

	return Array($redirect_template, $redirect_params);
	}

	/**
	* Check current user permissions based on it's group permissions in specified category (for non-system permissions) or just checks if system permission is set
	*
	* @param string $name permission name
	* @param int $cat_id category id, current used if not specified
	* @param int $type permission type {1 - system, 0 - per category}
	* @return int
	*/
	function CheckPermission($name, $type = 1, $cat_id = null)
	{
	if ($this->Application->GetVar('u_id') == -1) {
	// "root" is allowed anywhere
	return $name == 'SYSTEM_ACCESS.READONLY' ? 0 : 1;
	}

	if ($type == 1) {
	// "system" permission are always checked per "Home" category (ID = 0)
	$cat_id = 0;
	}

	if (!isset($cat_id)) {
	$cat_id = $this->Application->GetVar('m_cat_id');
	}

	$cache_key = $name.'\|'.$type.'\|'.$cat_id;
	$perm_value = $this->Application->getCache('permissions', $cache_key);
	if ($perm_value !== false) {
	return $perm_value;
	}

	// perm cache is build only based on records in db, that's why if permission is not explicitly denied, then
	// that (perm cache creator) code thinks that it is allowed & adds corresponding record and code below will
	// return incorrect results

	/if (preg_match('/(.)\.VIEW$/', $name) && ($type == 0)) {
	// cached view permission of category: begin
	$sql = 'SELECT perm_cache.PermId
	FROM '.TABLE_PREFIX.'PermCache perm_cache
	LEFT JOIN '.TABLE_PREFIX.'PermissionConfig perm_config ON perm_cache.PermId = perm_config.PermissionConfigId
	WHERE (perm_config.PermissionName = '.$this->Conn->qstr($name).' AND perm_cache.CategoryId = '.$cat_id.')';

	$view_filters = Array();
	$groups = explode(',', $this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', perm_cache.ACL) \|\| ((NOT FIND_IN_SET('.$group.', perm_cache.DACL)) AND perm_cache.ACL = \'\')';
	}
	$sql .= ' AND ('.implode(' OR ', $view_filters).')';
	$perm_value = $this->Conn->GetOne($sql) ? 1 : 0;

	$this->Application->setCache('permissions', $cache_key, $perm_value);
	return $perm_value;
	// cached view permission of category: end
	}*/

	if ($cat_id == 0) {
	$cat_hierarchy = Array(0);
	}
	else {
	$sql = 'SELECT ParentPath
	FROM '.$this->Application->getUnitOption('c', 'TableName').'
	WHERE CategoryId = '.$cat_id;
	$cat_hierarchy = $this->Conn->GetOne($sql);
	$cat_hierarchy = explode('\|', $cat_hierarchy);
	array_shift($cat_hierarchy);
	array_pop($cat_hierarchy);
	$cat_hierarchy = array_reverse($cat_hierarchy);
	array_push($cat_hierarchy, 0);
	}

	$perm_value = 0;
	$groups = $this->Application->RecallVar('UserGroups');
	foreach ($cat_hierarchy as $category_id) {
	$sql = 'SELECT PermissionValue
	FROM '.TABLE_PREFIX.'Permissions
	WHERE Permission = "'.$name.'" AND CatId = '.$category_id.' AND GroupId IN ('.$groups.') AND Type = '.$type;
	$res = $this->Conn->GetOne($sql);
	if ($res !== false) {
	$perm_value = $res;
	break;
	}
	}

	$this->Application->setCache('permissions', $cache_key, $perm_value);
	return $perm_value;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/general/helpers/permissions_helper.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.7
	\ No newline at end of property
	+1.8
	\ No newline at end of property

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options