in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Wed, Jul 23, 10:41 AM

in-portal
View Options

	Index: branches/unlabeled/unlabeled-1.9.2/core/units/category_items/category_items_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.9.2/core/units/category_items/category_items_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.9.2/core/units/category_items/category_items_event_handler.php (revision 6878)
	@@ -1,127 +1,127 @@
	<?php

	class CategoryItemsEventHander extends kDBEventHandler
	{

	/**
	* Setting language dependant navbar as calculated field
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();

	$ml_formatter =& $this->Application->recallObject('kMultiLanguage');
	$object->addCalculatedField('CategoryName', 'c.'.$ml_formatter->LangFieldName('CachedNavbar'));
	}

	/**
	* Set's new category as primary for product
	*
	* @param kEvent $event
	*/
	function OnSetPrimary(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	- $this->StoreSelectedIDs($event);
	- $ids=$this->getSelectedIDs($event);
	+ $ids = $this->StoreSelectedIDs($event);
	+
	if($ids)
	{
	$id = array_shift($ids);
	$table_info = $object->getLinkedInfo();

	$this->Conn->Query('UPDATE '.$object->TableName.' SET PrimaryCat = 0 WHERE '.$table_info['ForeignKey'].' = '.$table_info['ParentId']);
	$this->Conn->Query('UPDATE '.$object->TableName.' SET PrimaryCat = 1 WHERE ('.$table_info['ForeignKey'].' = '.$table_info['ParentId'].') AND (CategoryId = '.$id.')');
	}
	$event->redirect_params = Array('opener' => 's', 'pass_events' => true); //stay!
	}

	/**
	* Apply custom processing to item
	*
	* @param kEvent $event
	*/
	function customProcessing(&$event, $type)
	{
	if($event->Name == 'OnMassDelete')
	{
	$object =& $event->getObject();
	$table_info = $object->getLinkedInfo();

	switch ($type)
	{
	case 'before':
	$ids = $event->getEventParam('ids');
	if($ids)
	{
	$ids = $this->Conn->GetCol('SELECT CategoryId FROM '.$object->TableName.' WHERE (PrimaryCat=0) AND ('.$table_info['ForeignKey'].'='.$table_info['ParentId'].') AND CategoryId IN ('.implode(',',$ids).')');
	$event->setEventParam('ids',$ids);
	}
	break;

	// not needed because 'before' does not allow to delete primary cat!
	/*case 'after':
	// set 1st not deleted category as primary
	$has_primary = $this->Conn->GetOne('SELECT COUNT(*) FROM '.$object->TableName.' WHERE (PrimaryCat=1) AND ('.$table_info['ForeignKey'].' = '.$table_info['ParentId'].')');
	if(!$has_primary)
	{
	$cat_id = $this->Conn->GetOne('SELECT CategoryId FROM '.$object->TableName.' WHERE '.$table_info['ForeignKey'].' = '.$table_info['ParentId']);
	$this->Conn->Query('UPDATE '.$object->TableName.' SET PrimaryCat = 1 WHERE ('.$table_info['ForeignKey'].' = '.$table_info['ParentId'].') AND (CategoryId = '.$cat_id.')');
	}
	break;*/
	}
	}
	}

	/**
	* Removes primary mark from cloned category items record
	*
	* @param kEvent $event
	*/
	function OnAfterClone(&$event)
	{
	$id = $event->getEventParam('id');
	$table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$sql = 'UPDATE %s SET PrimaryCat = 0 WHERE %s = %s';

	$this->Conn->Query( sprintf($sql, $table, $id_field, $id) );
	}

	/**
	* Deletes items of requested type from requested categories.
	* In case if item is deleted from it's last category, then delete item too.
	*
	* @param kEvent $event
	*/
	function OnDeleteFromCategory(&$event)
	{
	$category_ids = $event->getEventParam('category_ids');
	if(!$category_ids) return false;

	$item_prefix = $event->getEventParam('item_prefix');
	$item =& $this->Application->recallObject($item_prefix.'.-item', null, Array('skip_autoload' => true));

	$ci_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$item_table = $this->Application->getUnitOption($item_prefix, 'TableName');

	$sql = 'SELECT ItemResourceId, CategoryId FROM %1$s INNER JOIN %2$s ON (%1$s.ResourceId = %2$s.ItemResourceId) WHERE CategoryId IN (%3$s)';
	$category_items = $this->Conn->Query( sprintf($sql, $item_table, $ci_table, implode(',', $category_ids) ) );

	$item_hash = Array();
	foreach($category_items as $ci_row)
	{
	$item_hash[ $ci_row['ItemResourceId'] ][] = $ci_row['CategoryId'];
	}

	foreach($item_hash as $item_resource_id => $delete_category_ids)
	{
	$item->Load($item_resource_id, 'ResourceId');
	$item->DeleteFromCategories($delete_category_ids);
	}
	}

	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.9.2/core/units/category_items/category_items_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.9
	\ No newline at end of property
	+1.9.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.68.2/core/units/general/cat_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.68.2/core/units/general/cat_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.68.2/core/units/general/cat_event_handler.php (revision 6878)
	@@ -1,1701 +1,1701 @@
	<?php

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

	class kCatDBEventHandler extends kDBEventHandler {

	/**
	* 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'),
	'OnBeforeDeleteOriginal' => Array('self' => 'edit\|advanced:approve'),

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

	);
	$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)
	$root_category = $this->Application->findModule('Path', $rets[1].'/', 'RootCat');
	$this->Application->StoreVar('m_cat_id', $root_category);
	}

	if ($event->Name == 'OnEdit' \|\| $event->Name == 'OnSave') {
	// check each id from selected individually and only if all are allowed proceed next
	if ($event->Name == 'OnEdit') {
	$selected_ids = implode(',', $this->StoreSelectedIDs($event));
	}
	else {
	- $selected_ids = $this->Application->RecallVar($event->getPrefixSpecial().'_selected_ids');
	+ $selected_ids = implode(',', $this->getSelectedIDs($event, true));
	}

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT '.$id_field.', CreatedById, ci.CategoryId
	FROM '.$table_name.' item_table
	LEFT JOIN '.$this->Application->getUnitOption('ci', 'TableName').' ci ON ci.ItemResourceId = item_table.ResourceId
	WHERE '.$id_field.' IN ('.$selected_ids.') AND (ci.PrimaryCat = 1)';
	$items = $this->Conn->Query($sql, $id_field);

	$perm_value = true;
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	foreach ($items as $item_id => $item_data) {
	if ($perm_helper->ModifyCheckPermission($item_data['CreatedById'], $item_data['CategoryId'], $event->Prefix) == 0) {
	// one of items selected has no permission
	$perm_value = false;
	break;
	}
	}

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

	return $perm_value;
	}

	return parent::CheckPermission($event);
	}

	/**
	* Add selected items to clipboard with mode = COPY (CLONE)
	*
	* @param kEvent $event
	*/
	function OnCopy(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'copy', $this->StoreSelectedIDs($event));
	}

	/**
	* Add selected items to clipboard with mode = CUT
	*
	* @param kEvent $event
	*/
	function OnCut(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'cut', $this->StoreSelectedIDs($event));
	}

	/**
	* Performs category item paste
	*
	* @param kEvent $event
	*/
	function OnPaste(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

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

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

	if ($clipboard_data['copy']) {
	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$this->Application->SetVar('ResetCatBeforeClone', 1);
	$temp->CloneItems($event->Prefix, $event->Special, $clipboard_data['copy']);
	}

	if ($clipboard_data['cut']) {
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'.item', $event->Prefix, Array('skip_autoload' => true));

	foreach ($clipboard_data['cut'] as $id) {
	$object->Load($id);
	$object->MoveToCat();
	}
	}
	}

	/**
	* 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
	if ($this->Application->RecallVar('user_id') == -1) {
	// for "root" CATEGORY.VIEW permission is checked for items lists too
	$view_perm = 1;
	}
	else {
	// for any real user itemlist view permission is checked instead of CATEGORY.VIEW
	$sql = 'SELECT PermissionConfigId
	FROM '.TABLE_PREFIX.'PermissionConfig
	WHERE PermissionName = "'.$this->Application->getUnitOption($event->Prefix, 'PermItemPrefix').'.VIEW"';
	$view_perm = $this->Conn->GetOne($sql);

	$groups = explode( ',', $this->Application->RecallVar('UserGroups') );
	foreach($groups as $group)
	{
	$view_filters[] = 'FIND_IN_SET('.$group.', perm.acl)';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	}

	$object->addFilter('perm_filter', 'perm.PermId = '.$view_perm);

	if ( !$this->Application->IsAdmin() )
	{
	$object->addFilter('status_filter', $object->TableName.'.Status = 1');
	if ($this->Application->getUnitOption($event->Prefix, 'UsePendingEditing')) {
	// if category item uses pending editing abilities, then in no cases show pending copies on front
	$object->addFilter('original_filter', '%1$s.OrgId = 0 OR %1$s.OrgId IS NULL');
	}
	}
	else {
	if ($this->Application->getUnitOption($event->Prefix, 'UsePendingEditing')) {
	$pending_ids = $this->Conn->GetCol(
	'SELECT OrgId FROM '.$object->TableName.'
	WHERE Status = -2 AND OrgId IS NOT NULL');
	if ($pending_ids) {
	$object->addFilter('no_original_filter', '%1$s.'.$object->IDField.' NOT IN ('.implode(',', $pending_ids).')');
	}
	}
	}

	$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);

	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->RecallVar('user_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);

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

	if ($event->Special == 'export' \|\| $event->Special == 'import')
	{
	$export_helper =& $this->Application->recallObject('CatItemExportHelper');
	$export_helper->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_map = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	if (!$property_map) {
	return ;
	}

	// new items
	$object->addCalculatedField('IsNew', ' IF(%1$s.NewItem = 2,
	IF(%1$s.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue($property_map['NewDays']).
	'360024), 1, 0),
	%1$s.NewItem
	)');

	// hot items (cache updated every hour)
	$sql = 'SELECT Data
	FROM '.TABLE_PREFIX.'Cache
	WHERE (VarName = "'.$property_map['HotLimit'].'") AND (Cached >'.(adodb_mktime() - 3600).')';
	$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.'.$property_map['ClickField'].' >= '.$hot_limit.', 1, 0),
	%1$s.HotItem
	)');

	// popular items
	$object->addCalculatedField('IsPop', ' IF(%1$s.PopItem = 2,
	IF(%1$s.CachedVotesQty >= '.
	$this->Application->ConfigValue($property_map['MinPopVotes']).
	' AND %1$s.CachedRating >= '.
	$this->Application->ConfigValue($property_map['MinPopRating']).
	', 1, 0),
	%1$s.PopItem)');

	}

	function CalculateHotLimit(&$event)
	{
	$property_map = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	if (!$property_map) {
	return;
	}
	$click_field = $property_map['ClickField'];

	$last_hot = $this->Application->ConfigValue($property_map['MaxHotNumber']) - 1;
	$sql = 'SELECT '.$click_field.' FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	ORDER BY '.$click_field.' DESC
	LIMIT '.$last_hot.', 1';
	$res = $this->Conn->GetCol($sql);
	$hot_limit = (double)array_shift($res);
	$this->Conn->Query('REPLACE INTO '.TABLE_PREFIX.'Cache (VarName, Data, Cached) VALUES ("'.$property_map['HotLimit'].'", "'.$hot_limit.'", '.adodb_mktime().')');
	return $hot_limit;

	return 0;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$property_map = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
	if (!$property_map) {
	return;
	}
	$click_field = $property_map['ClickField'];

	$object =& $event->getObject();
	if( $this->Application->IsAdmin() && ($this->Application->GetVar($click_field.'_original') !== false) &&
	floor($this->Application->GetVar($click_field.'_original')) != $object->GetDBField($click_field) )
	{
	$sql = 'SELECT MAX('.$click_field.') FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
	WHERE FLOOR('.$click_field.') = '.$object->GetDBField($click_field);
	$hits = ( $res = $this->Conn->GetOne($sql) ) ? $res + 0.000001 : $object->GetDBField($click_field);
	$object->SetDBField($click_field, $hits);
	}
	}

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

	//substituiting pending status value for pending editing
	if ($object->HasField('OrgId') && $object->GetDBField('OrgId') > 0 && $object->GetDBField('Status') == -2) {
	$options = $object->Fields['Status']['options'];
	foreach ($options as $key => $val) {
	if ($key == 2) $key = -2;
	$new_options[$key] = $val;
	}
	$object->Fields['Status']['options'] = $new_options;
	}

	}

	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');
	$items_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$module_name = $this->Application->findModule('Var', $event->Prefix, 'Name');

	$sql = ' SELECT * FROM '.$this->Application->getUnitOption('confs', 'TableName').'
	WHERE ModuleName="'.$module_name.'"
	AND SimpleSearch=1';
	$search_config = $this->Conn->Query($sql, 'FieldName');
	$field_list = array_keys($search_config);

	$join_clauses = Array();

	// field processing
	$weight_sum = 0;

	$alias_counter = 0;

	$custom_fields = $this->Application->getUnitOption($event->Prefix, 'CustomFields');
	if ($custom_fields) {
	$custom_table = $this->Application->getUnitOption($event->Prefix.'-cdata', 'TableName');
	$join_clauses[] = ' LEFT JOIN '.$custom_table.' custom_data ON '.$items_table.'.ResourceId = custom_data.ResourceId';
	}

	// what field in search config becomes what field in sql (key - new field, value - old field (from searchconfig table))
	$search_config_map = Array();

	foreach ($field_list as $key => $field) {
	$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.'_primary'] = 'l'.$this->Application->GetDefaultLanguageId().'_'.$field;
	$field_list[$key] = 'l'.$lang.'_'.$field;

	if(!isset($search_config[$field]['ForeignField']))
	{
	$field_list[$key.'_primary'] = $local_table.'.'.$field_list[$key.'_primary'];
	$search_config_map[ $field_list[$key.'_primary'] ] = $field;
	}
	}

	// processing fields from other tables
	if($foreign_field = $search_config[$field]['ForeignField'])
	{
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	unset($field_list[$key]);
	continue; // ignoring having type clauses in simple search
	/*$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
	{
	$multi_lingual = false;
	if ($exploded[0] == 'MULTI')
	{
	$multi_lingual = true;
	$foreign_field = $exploded[1];
	}
	$exploded = explode('.', $foreign_field); // format: table.field_name
	$foreign_table = TABLE_PREFIX.$exploded[0];

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

	if ($multi_lingual) {
	$field_list[$key] = $alias.'.'.'l'.$lang.'_'.$exploded[1];
	$field_list[$key.'_primary'] = 'l'.$this->Application->GetDefaultLanguageId().'_'.$field;
	$search_config_map[ $field_list[$key] ] = $field;
	$search_config_map[ $field_list[$key.'_primary'] ] = $field;
	}
	else {
	$field_list[$key] = $alias.'.'.$exploded[1];
	$search_config_map[ $field_list[$key] ] = $field;
	}

	$join_clause = str_replace('{ForeignTable}', $alias, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $items_table, $join_clause);

	$join_clauses[] = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else {
	// processing fields from local table
	if ($search_config[$field]['CustomFieldId']) {
	$local_table = 'custom_data';
	$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 '.$items_table.'.Status=1';

	if($this->Application->GetVar('Action') == 'm_simple_subsearch') // subsearch, In-portal
	{
	if( $event->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$items_table.'.ResourceId IN ('.implode(',', $event->specificParams['ResultIds']).')';
	}
	}
	if( $event->MasterEvent && $event->MasterEvent->Name == 'OnListBuild' ) // subsearch, k4
	{
	if( $event->MasterEvent->getEventParam('ResultIds') )
	{
	$where_clause .= ' AND '.$items_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 = $search_config[ $search_config_map[$field] ];
	$weight = $config_elem['Priority'];
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.implode(' ', $positive_words).'%", '.$weight_sum.', 0)';
	foreach ($positive_words as $keyword) {
	$revelance_parts[] = 'IF('.$field.' LIKE "%'.$keyword.'%", '.$weight.', 0)';
	}
	}
	$conf_postfix = $this->Application->getUnitOption($event->Prefix, 'SearchConfigPostfix');
	$rel_keywords = $this->Application->ConfigValue('SearchRel_Keyword_'.$conf_postfix) / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_Pop_'.$conf_postfix) / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_Rating_'.$conf_postfix) / 100;
	$relevance_clause = '('.implode(' + ', $revelance_parts).') / '.$weight_sum.' * '.$rel_keywords;
	if ($rel_pop && isset($object->Fields['Hits'])) {
	$relevance_clause .= ' + (Hits + 1) / (MAX(Hits) + 1) * '.$rel_pop;
	}
	if ($rel_rating && isset($object->Fields['CachedRating'])) {
	$relevance_clause .= ' + (CachedRating + 1) / (MAX(CachedRating) + 1) * '.$rel_rating;
	}

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


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

	$edpick_clause = $this->Application->getUnitOption($event->Prefix.'.EditorsPick', 'Fields') ? $items_table.'.EditorsPick' : '0';


	$sql = $select_intro.' SELECT '.$relevance_clause.' AS Relevance,
	'.$items_table.'.'.$this->Application->getUnitOption($event->Prefix, 'IDField').' AS ItemId,
	'.$items_table.'.ResourceId,
	'.$this->Application->getUnitOption($event->Prefix, 'ItemType').' AS ItemType,
	'.$edpick_clause.' AS EdPick
	FROM '.$object->TableName.'
	'.implode(' ', $join_clauses).'
	WHERE '.$where_clause.'
	GROUP BY '.$items_table.'.'.$this->Application->getUnitOption($event->Prefix, 'IDField');

	$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);
	$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 === */

	/**
	* 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);
	+ $selected_ids = $this->StoreSelectedIDs($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);

	$export_helper =& $this->Application->recallObject('CatItemExportHelper');
	$event->redirect = $export_helper->getModuleFolder($event).'/export';

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

	$event->setRedirectParams($redirect_params);
	}

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

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

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

	/**
	* Process items selected in item_selector
	*
	* @param kEvent $event
	*/
	function OnProcessSelected(&$event)
	{
	$selected_ids = $this->Application->GetVar('selected_ids');

	$dst_field = $this->Application->RecallVar('dst_field');

	if ($dst_field == 'ItemCategory') {
	// Item Edit -> Categories Tab -> New Categories
	$object =& $event->getObject();
	$category_ids = explode(',', $selected_ids['c']);
	foreach ($category_ids as $category_id) {
	$object->assignToCategory($category_id);
	}
	}

	if ($dst_field == 'ImportCategory') {
	// Tools -> Import -> Item Import -> Select Import Category
	$this->Application->StoreVar('ImportCategory', $selected_ids['c']);
	$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);
	}

	$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));
	}
	}

	function OnCancelAction(&$event)
	{
	$event->redirect_params = Array('pass' => 'all,'.$event->GetPrefixSpecial());
	$event->redirect = $this->Application->GetVar('cancel_template');
	}

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

	/**
	* Stores item's owner login into separate field together with id
	*
	* @param kEvent $event
	* @param string $id_field
	* @param string $cached_field
	*/
	function cacheItemOwner(&$event, $id_field, $cached_field)
	{
	$object =& $event->getObject();

	$user_id = $object->GetDBField($id_field);
	$options = $object->GetFieldOptions($id_field);
	if (isset($options['options'][$user_id])) {
	$object->SetDBField($cached_field, $options['options'][$user_id]);
	}
	else {
	$id_field = $this->Application->getUnitOption('u', 'IDField');
	$table_name = $this->Application->getUnitOption('u', 'TableName');

	$sql = 'SELECT Login
	FROM '.$table_name.'
	WHERE '.$id_field.' = '.$user_id;
	$object->SetDBField($cached_field, $this->Conn->GetOne($sql));
	}
	}

	/**
	* Saves item beeing edited into temp table
	*
	* @param kEvent $event
	*/
	function OnPreSave(&$event)
	{
	parent::OnPreSave($event);
	$use_pending_editing = $this->Application->getUnitOption($event->Prefix, 'UsePendingEditing');
	if ($event->status == erSUCCESS && $use_pending_editing) {
	// decision: clone or not clone

	$object =& $event->getObject();
	if ($object->GetID() == 0 \|\| $object->GetDBField('OrgId') > 0) {
	// new items or cloned items shouldn't be cloned again
	return true;
	}
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	if ($perm_helper->ModifyCheckPermission($object->GetDBField('CreatedById'), $object->GetDBField('CategoryId'), $event->Prefix) == 2) {

	// 1. clone original item
	$temp_handler =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$cloned_ids = $temp_handler->CloneItems($event->Prefix, $event->Special, Array($object->GetID()), null, null, null, true);
	$ci_table = $this->Application->GetTempName(TABLE_PREFIX.'CategoryItems');

	// 2. delete record from CategoryItems (about cloned item) that was automatically created during call of Create method of kCatDBItem
	$sql = 'SELECT ResourceId
	FROM '.$object->TableName.'
	WHERE '.$object->IDField.' = '.$cloned_ids[0];
	$clone_resource_id = $this->Conn->GetOne($sql);

	$sql = 'DELETE FROM '.$ci_table.'
	WHERE ItemResourceId = '.$clone_resource_id.' AND PrimaryCat = 1';
	$this->Conn->Query($sql);

	// 3. copy main item categoryitems to cloned item
	$sql = ' INSERT INTO '.$ci_table.' (CategoryId, ItemResourceId, PrimaryCat, ItemPrefix, Filename)
	SELECT CategoryId, '.$clone_resource_id.' AS ItemResourceId, PrimaryCat, ItemPrefix, Filename
	FROM '.$ci_table.'
	WHERE ItemResourceId = '.$object->GetDBField('ResourceId');
	$this->Conn->Query($sql);

	// 4. put cloned id to OrgId field of item being cloned
	$sql = 'UPDATE '.$object->TableName.'
	SET OrgId = '.$object->GetID().'
	WHERE '.$object->IDField.' = '.$cloned_ids[0];
	$this->Conn->Query($sql);

	// 5. substitute id of item being cloned with clone id
	$this->Application->SetVar($event->getPrefixSpecial().'_id', $cloned_ids[0]);
	- $selected_ids = explode(',', $this->Application->RecallVar($event->getPrefixSpecial().'_selected_ids'));
	+
	+ $selected_ids = $this->getSelectedIDs($event, true);
	$selected_ids[ array_search($object->GetID(), $selected_ids) ] = $cloned_ids[0];
	- $this->Application->StoreVar($event->getPrefixSpecial().'_selected_ids', implode(',', $selected_ids));
	+ $this->StoreSelectedIDs($event, $selected_ids);

	// 6. delete original item from temp table
	$temp_handler->DeleteItems($event->Prefix, $event->Special, Array($object->GetID()));
	}
	}
	}

	/**
	* Sets default expiration based on module setting
	*
	* @param kEvent $event
	*/
	function OnPreCreate(&$event)
	{
	parent::OnPreCreate($event);

	if ($event->status == erSUCCESS) {
	$object =& $event->getObject();
	$object->SetDBField('CreatedById', $this->Application->RecallVar('user_id'));
	}
	}

	/**
	* Occures before original item of item in pending editing got deleted (for hooking only)
	*
	* @param kEvent $event
	*/
	function OnBeforeDeleteOriginal(&$event)
	{

	}

	/**
	* Occures before an item is cloneded
	* Id of ORIGINAL item is passed as event' 'id' param
	* Do not call object' Update method in this event, just set needed fields!
	*
	* @param kEvent $event
	*/
	function OnBeforeClone(&$event)
	{
	if ($this->Application->GetVar('ResetCatBeforeClone')) {
	$object =& $event->getObject();
	$object->SetDBField('CategoryId', null);
	}
	}

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

	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$ids = $this->StoreSelectedIDs($event);

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

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

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

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

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.68.2/core/units/general/cat_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.68.2.1
	\ No newline at end of property
	+1.68.2.2
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php (revision 6878)
	@@ -1,1653 +1,1662 @@
	<?php

	class kDBTagProcessor extends TagProcessor {

	/**
	* Description
	*
	* @var kDBConnection
	* @access public
	*/
	var $Conn;

	function kDBTagProcessor()
	{
	parent::kBase();
	$this->Conn =& $this->Application->GetADODBConnection();
	}


	/**
	* Returns true if "new" button was pressed in toolbar
	*
	* @param Array $params
	* @return bool
	*/
	function IsNewMode($params)
	{
	$object =& $this->getObject($params);
	return $object->GetID() <= 0;
	}

	/**
	* Returns view menu name for current prefix
	*
	* @param Array $params
	* @return string
	*/
	function GetItemName($params)
	{
	$item_name = $this->Application->getUnitOption($this->Prefix, 'ViewMenuPhrase');
	return $this->Application->Phrase($item_name);
	}

	function ViewMenu($params)
	{
	$block_params = $params;
	unset($block_params['block']);
	$block_params['name'] = $params['block'];

	$list =& $this->GetList($params);
	$block_params['PrefixSpecial'] = $list->getPrefixSpecial();
	return $this->Application->ParseBlock($block_params);
	}

	function SearchKeyword($params)
	{
	$list =& $this->GetList($params);
	return $this->Application->RecallVar($list->getPrefixSpecial().'_search_keyword');
	}

	/**
	* Draw filter menu content (for ViewMenu) based on filters defined in config
	*
	* @param Array $params
	* @return string
	*/
	function DrawFilterMenu($params)
	{
	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['spearator_block'];
	$separator = $this->Application->ParseBlock($block_params);
	$filter_menu = $this->Application->getUnitOption($this->Prefix,'FilterMenu');
	if(!$filter_menu)
	{
	trigger_error('<span class="debug_error">no filters defined</span> for prefix <b>'.$this->Prefix.'</b>, but <b>DrawFilterMenu</b> tag used', E_USER_WARNING);
	return '';
	}

	// Params: label, filter_action, filter_status
	$block_params['name'] = $params['item_block'];

	$view_filter = $this->Application->RecallVar($this->getPrefixSpecial().'_view_filter');
	if($view_filter === false)
	{
	$event_params = Array('prefix'=>$this->Prefix,'special'=>$this->Special,'name'=>'OnRemoveFilters');
	$this->Application->HandleEvent( new kEvent($event_params) );
	$view_filter = $this->Application->RecallVar($this->getPrefixSpecial().'_view_filter');
	}
	$view_filter = unserialize($view_filter);

	$filters = Array();
	$prefix_special = $this->getPrefixSpecial();

	foreach ($filter_menu['Filters'] as $filter_key => $filter_params) {
	$group_params = isset($filter_params['group_id']) ? $filter_menu['Groups'][ $filter_params['group_id'] ] : Array();
	if (!isset($group_params['element_type'])) {
	$group_params['element_type'] = 'checkbox';
	}

	if (!$filter_params) {
	$filters[] = $separator;
	continue;
	}

	$block_params['label'] = addslashes( $this->Application->Phrase($filter_params['label']) );
	if (getArrayValue($view_filter,$filter_key)) {
	$submit = 0;
	$status = $group_params['element_type'] == 'checkbox' ? '[\'img/check_on.gif\']' : '[\'img/menu_dot.gif\']';
	}
	else {
	$submit = 1;
	$status = 'null';
	}
	$block_params['filter_action'] = 'set_filter("'.$prefix_special.'","'.$filter_key.'","'.$submit.'",'.$params['ajax'].');';
	$block_params['filter_status'] = $status; // 1 - checkbox, 2 - radio, 0 - no image
	$filters[] = $this->Application->ParseBlock($block_params);
	}


	return implode('', $filters);
	}

	function IterateGridFields($params)
	{
	$mode = $params['mode'];
	$def_block = $params['block'];

	$grids = $this->Application->getUnitOption($this->Prefix,'Grids');
	$grid_config = $grids[$params['grid']]['Fields'];

	$std_params['pass_params']='true';
	$std_params['PrefixSpecial']=$this->getPrefixSpecial();

	$o = '';
	foreach ($grid_config as $field => $options) {
	$block_params = Array();
	$block_params['name'] = isset($options[$mode.'_block']) ? $options[$mode.'_block'] : $def_block;
	$block_params['field'] = $field;
	$block_params['sort_field'] = isset($options['sort_field']) ? $options['sort_field'] : $field;
	$block_params['filter_field'] = isset($options['filter_field']) ? $options['filter_field'] : $field;
	$block_params = array_merge($std_params, $block_params, $options);
	$o.= $this->Application->ParseBlock($block_params, 1);
	}
	return $o;
	}

	function GridFieldsCount($params)
	{
	$grids = $this->Application->getUnitOption($this->Prefix, 'Grids');
	$grid_config = $grids[$params['grid']]['Fields'];

	return count($grid_config);
	}

	/**
	* Prints list content using block specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintList($params)
	{
	$list =& $this->GetList($params);
	$id_field = $this->Application->getUnitOption($this->Prefix,'IDField');

	$list->Query();
	$o = '';
	$list->GoFirst();

	$block_params=$this->prepareTagParams($params);
	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	$block_params['pass_params'] = 'true';

	while (!$list->EOL())
	{
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', $list->GetDBField($id_field) ); // for edit/delete links using GET
	$o.= $this->Application->ParseBlock($block_params, 1);
	$list->GoNext();
	}

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

	function InitList($params)
	{
	$list_name = isset($params['list_name']) ? $params['list_name'] : '';

	$names_mapping = $this->Application->GetVar('NamesToSpecialMapping');

	if( !getArrayValue($names_mapping, $this->Prefix, $list_name) )
	{
	$list =& $this->GetList($params);
	}
	}

	function BuildListSpecial($params)
	{
	return $this->Special;
	}

	/**
	* Enter description here...
	*
	* @param Array $params
	* @return kDBList
	*/
	function &GetList($params)
	{
	$list_name = $this->SelectParam($params, 'list_name,name');
	if (!$list_name) {
	$list_name = $this->Application->Parser->GetParam('list_name');
	}

	$requery = getArrayValue($params, 'requery');
	if ($list_name && !$requery){
	$names_mapping = $this->Application->GetVar('NamesToSpecialMapping');

	$special = getArrayValue($names_mapping, $this->Prefix, $list_name);
	if(!$special)
	{
	$special = $this->BuildListSpecial($params);
	}
	}
	else
	{
	$special = $this->BuildListSpecial($params);
	}

	$prefix_special = rtrim($this->Prefix.'.'.$special, '.');
	$params['skip_counting'] = true;
	$list =& $this->Application->recallObject( $prefix_special, $this->Prefix.'_List', $params);
	if ($requery) {
	$this->Application->HandleEvent($an_event, $prefix_special.':OnListBuild', $params);
	}
	$list->Query($requery);
	$this->Special = $special;

	if ($list_name) {
	$names_mapping[$this->Prefix][$list_name] = $special;
	$this->Application->SetVar('NamesToSpecialMapping', $names_mapping);
	}

	return $list;
	}

	function ListMarker($params)
	{
	$list =& $this->GetList($params);
	$ret = $list->getPrefixSpecial();
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	function SubmitName($params)
	{
	$list =& $this->GetList($params);

	$prefix_special = $list->getPrefixSpecial();

	return 'events['.$prefix_special.']['.$params['event'].']';
	}


	function CombinedSortingDropDownName($params)
	{
	$list =& $this->GetList($params);
	$prefix_special = $list->getPrefixSpecial();

	return $prefix_special.'_CombinedSorting';
	}

	function SortingSelected($params)
	{
	$list =& $this->GetList($params);
	$user_sorting_start = $this->getUserSortIndex();

	$sorting = strtolower($list->GetOrderField($user_sorting_start).'\|'.$list->GetOrderDirection($user_sorting_start));

	if ($sorting == strtolower($params['sorting'])) return $params['selected'];
	}



	/**
	* Prints list content using block specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintList2($params)
	{
	$per_page = $this->SelectParam($params, 'per_page,max_items');
	if ($per_page !== false) $params['per_page'] = $per_page;

	$list =& $this->GetList($params);
	$o = '';

	$direction = (isset($params['direction']) && $params['direction']=="H")?"H":"V";
	$columns = (isset($params['columns'])) ? $params['columns'] : 1;

	$id_field = (isset($params['id_field'])) ? $params['id_field'] : $this->Application->getUnitOption($this->Prefix, 'IDField');

	if ($columns>1 && $direction=="V") {
	$list->Records = $this->LinearToVertical($list->Records, $columns, $list->GetPerPage());
	$list->SelectedCount=count($list->Records);
	ksort($list->Records); // this is issued twice, maybe need to be removed
	}

	$list->GoFirst();

	$block_params=$this->prepareTagParams($params);
	$block_params['name']=$this->SelectParam($params, 'render_as,block');
	$block_params['pass_params']='true';
	$block_params['column_width'] = 100 / $columns;
	$block_start_row_params = $this->prepareTagParams($params);
	$block_start_row_params['name'] = $this->SelectParam($params, 'row_start_render_as,block_row_start,row_start_block');

	$block_end_row_params=$this->prepareTagParams($params);
	$block_end_row_params['name'] = $this->SelectParam($params, 'row_end_render_as,block_row_end,row_end_block');

	$block_empty_cell_params = $this->prepareTagParams($params);
	$block_empty_cell_params['name'] = $this->SelectParam($params, 'empty_cell_render_as,block_empty_cell,empty_cell_block');

	$i=0;

	$backup_id=$this->Application->GetVar($this->Prefix."_id");
	$displayed = array();
	$column_number = 1;

	$cache_mod_rw = $this->Application->getUnitOption($this->Prefix, 'CacheModRewrite') && $this->Application->RewriteURLs();

	while (!$list->EOL())
	{
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', $list->GetDBField($id_field) ); // for edit/delete links using GET
	$this->Application->SetVar( $this->Prefix.'_id', $list->GetDBField($id_field) );

	if ($cache_mod_rw) {
	$this->Application->setCache('filenames', $this->Prefix.'_'.$list->GetDBField($id_field), $list->GetDBField('Filename'));
	$this->Application->setCache('filenames', 'c_'.$list->GetDBField('CategoryId'), $list->GetDBField('CategoryFilename'));
	}

	if ($i % $columns == 0) {
	// record in this iteration is first in row, then open row
	$column_number = 1;
	$o.= $block_start_row_params['name'] ?
	$this->Application->ParseBlock($block_start_row_params, 1) :
	(!isset($params['no_table']) ? '<tr>' : '');
	}
	else {
	$column_number++;
	}

	$block_params['column_number'] = $column_number;
	$o.= $this->Application->ParseBlock($block_params, 1);
	array_push($displayed, $list->GetDBField($id_field));

	if (($i+1) % $columns == 0) {
	// record in next iteration is first in row too, then close this row
	$o.= $block_end_row_params['name'] ?
	$this->Application->ParseBlock($block_end_row_params, 1) :
	(!isset($params['no_table']) ? '<tr>' : '');
	}

	$list->GoNext();
	$i++;
	}

	// append empty cells in place of missing cells in last row
	while ($i % $columns != 0) {
	// until next cell will be in new row append empty cells
	$o .= $block_empty_cell_params['name'] ? $this->Application->ParseBlock($block_empty_cell_params, 1) : '<td> </td>';

	if (($i+1) % $columns == 0) {
	// record in next iteration is first in row too, then close this row
	$o .= $block_end_row_params['name'] ? $this->Application->ParseBlock($block_end_row_params, 1) : '</tr>';
	}
	$i++;
	}

	$cur_displayed = $this->Application->GetVar($this->Prefix.'_displayed_ids');
	if (!$cur_displayed) {
	$cur_displayed = Array();
	}
	else {
	$cur_displayed = explode(',', $cur_displayed);
	}

	$displayed = array_unique(array_merge($displayed, $cur_displayed));
	$this->Application->SetVar($this->Prefix.'_displayed_ids', implode(',',$displayed));

	$this->Application->SetVar( $this->Prefix.'_id', $backup_id);
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', '');

	if (isset($params['more_link_render_as'])) {
	$block_params = $params;
	$params['render_as'] = $params['more_link_render_as'];
	$o .= $this->MoreLink($params);
	}

	return $o;
	}

	function MoreLink($params)
	{
	$per_page = $this->SelectParam($params, 'per_page,max_items');
	if ($per_page !== false) $params['per_page'] = $per_page;
	$list =& $this->GetList($params);
	if ($list->PerPage < $list->RecordsCount) {
	$block_params = array();
	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	return $this->Application->ParseBlock($block_params, 1);
	}
	}

	function NotLastItem($params)
	{
	$object =& $this->getList($params); // maybe we should use $this->GetList($params) instead
	return ($object->CurrentIndex < min($object->PerPage == -1 ? $object->RecordsCount : $object->PerPage, $object->RecordsCount) - 1);
	}

	function PageLink($params)
	{
	$t = isset($params['template']) ? $param['template'] : '';
	if (!$t) $t = $this->Application->GetVar('t');

	if (isset($params['page'])) {
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $params['page']);
	}

	// $http_query =& $this->Application->recallObject('HTTPQuery');
	// $get = $http_query->getRedirectParams();
	$pass = Array('pass' => 'm,'.$this->getPrefixSpecial());
	// $pass = array_merge($get, $pass);

	return $this->Application->HREF($t, '', $pass);
	}

	function ColumnWidth($params)
	{
	$columns = $this->Application->Parser->GetParam('columns');
	return round(100/$columns).'%';
	}

	/**
	* Append prefix and special to tag
	* params (get them from tagname) like
	* they were really passed as params
	*
	* @param Array $tag_params
	* @return Array
	* @access protected
	*/
	function prepareTagParams($tag_params = Array())
	{
	/*if (isset($tag_params['list_name'])) {
	$list =& $this->GetList($tag_params);
	$this->Init($list->Prefix, $list->Special);
	}*/

	$ret = $tag_params;
	$ret['Prefix'] = $this->Prefix;
	$ret['Special'] = $this->Special;
	$ret['PrefixSpecial'] = $this->getPrefixSpecial();
	return $ret;
	}

	function GetISO($currency)
	{
	if ($currency == 'selected') {
	$iso = $this->Application->RecallVar('curr_iso');
	}
	elseif ($currency == 'primary' \|\| $currency == '') {
	$iso = $this->Application->GetPrimaryCurrency();
	}
	else { //explicit currency
	$iso = $currency;
	}
	return $iso;
	}

	function ConvertCurrency($value, $iso)
	{
	$converter =& $this->Application->recallObject('kCurrencyRates');
	// convery primary currency to selected (if they are the same, converter will just return)
	$value = $converter->Convert($value, 'PRIMARY', $iso);
	return $value;
	}

	function AddCurrencySymbol($value, $iso)
	{
	$currency =& $this->Application->recallObject('curr.-'.$iso, null, Array('skip_autoload' => true));
	if( !$currency->isLoaded() ) $currency->Load($iso, 'ISO');

	$symbol = $currency->GetDBField('Symbol');
	if (!$symbol) $symbol = $currency->GetDBField('ISO').' ';
	if ($currency->GetDBField('SymbolPosition') == 0) {
	$value = $symbol.$value;
	}
	if ($currency->GetDBField('SymbolPosition') == 1) {
	$value = $value.$symbol;
	}
	return $value;
	}

	/**
	* Get's requested field value
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Field($params)
	{
	$field = $this->SelectParam($params, 'name,field');

	if( !$this->Application->IsAdmin() ) $params['no_special'] = 'no_special';

	$object =& $this->getObject($params);

	if ( $this->HasParam($params, 'db') )
	{
	$value = $object->GetDBField($field);
	}
	else
	{
	if( $this->HasParam($params, 'currency') )
	{
	$iso = $this->GetISO($params['currency']);
	$original = $object->GetDBField($field);
	$value = $this->ConvertCurrency($original, $iso);
	$object->SetDBField($field, $value);
	$object->Fields[$field]['converted'] = true;
	}

	$format = getArrayValue($params, 'format');
	if( !$format \|\| $format == '$format' )
	{
	$format = null;
	}
	else
	{
	if(preg_match("/_regional_(.*)/", $format, $regs))
	{
	$lang =& $this->Application->recallObject('lang.current');
	$format = $lang->GetDBField($regs[1]);
	}
	}
	$value = $object->GetField($field, $format);

	if( $this->SelectParam($params, 'negative') )
	{
	if(strpos($value, '-') === 0)
	{
	$value = substr($value, 1);
	}
	else
	{
	$value = '-'.$value;
	}
	}

	if( $this->HasParam($params, 'currency') )
	{
	$value = $this->AddCurrencySymbol($value, $iso);
	$params['no_special'] = 1;
	}
	}

	if( !$this->HasParam($params, 'no_special') ) $value = htmlspecialchars($value);
	if( getArrayValue($params,'checked' ) ) $value = ($value == ( isset($params['value']) ? $params['value'] : 1)) ? 'checked' : '';
	if( isset($params['plus_or_as_label']) ) {
	$value = substr($value, 0,1) == '+' ? substr($value, 1) : $this->Application->Phrase($value);
	}
	elseif( getArrayValue($params,'as_label') ) $value = $this->Application->Phrase($value);

	$first_chars = $this->SelectParam($params,'first_chars,cut_first');
	if($first_chars)
	{
	$needs_cut = strlen($value) > $first_chars;
	$value = substr($value,0,$first_chars);
	if($needs_cut) $value .= ' ...';
	}
	if( getArrayValue($params,'nl2br' ) ) $value = nl2br($value);

	if ($value != '') $this->Application->Parser->DataExists = true;

	if( $this->HasParam($params, 'currency') )
	{
	//restoring value in original currency, for other Field tags to work properly
	$object->SetDBField($field, $original);
	}

	return $value;
	}

	function SetField($params)
	{
	// <inp2:SetField field="Value" src=p:cust_{$custom_name}"/>

	$object =& $this->getObject($params);
	$dst_field = $this->SelectParam($params, 'name,field');

	list($prefix_special, $src_field) = explode(':', $params['src']);
	$src_object =& $this->Application->recallObject($prefix_special);
	$object->SetDBField($dst_field, $src_object->GetDBField($src_field));
	}

	/**
	* Checks if parameter is passed
	* Note: works like Tag and line simple method too
	*
	* @param Array $params
	* @param string $param_name
	* @return bool
	*/
	function HasParam($params, $param_name = null)
	{
	if( !isset($param_name) )
	{
	$param_name = $this->SelectParam($params, 'name');
	$params = $this->Application->Parser->Params;
	}
	$value = getArrayValue($params, $param_name);
	return $value && ($value != '$'.$param_name);
	}

	function PhraseField($params)
	{
	$field_label = $this->Field($params);
	$translation = $this->Application->Phrase( $field_label );
	return $translation;
	}

	function Error($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);
	$msg = $object->GetErrorMsg($field, false);
	return $msg;
	}

	function HasError($params)
	{
	if ($params['field'] == 'any')
	{
	$object =& $this->getObject($params);

	$skip_fields = getArrayValue($params, 'except');
	$skip_fields = $skip_fields ? explode(',', $skip_fields) : Array();

	return $object->HasErrors($skip_fields);
	}
	else
	{
	$fields = $this->SelectParam($params, 'field,fields');
	$fields = explode(',', $fields);
	$res = false;
	foreach($fields as $field)
	{
	$params['field'] = $field;
	$res = $res \|\| ($this->Error($params) != '');
	}
	return $res;
	}
	}

	function IsRequired($params)
	{
	$field = $params['field'];
	$object =& $this->getObject($params);;

	$formatter_class = getArrayValue($object->Fields, $field, 'formatter');
	if ($formatter_class == 'kMultiLanguage')
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$field = $formatter->LangFieldName($field);
	}

	$options = $object->GetFieldOptions($field);
	return getArrayValue($options,'required');
	}

	function PredefinedOptions($params)
	{
	$field = $params['field'];
	$object =& $this->getObject($params);

	$value = $object->GetDBField($field);
	$options = $object->GetFieldOptions($field);
	if( $this->HasParam($params,'has_empty') )
	{
	$empty_value = getArrayValue($params, 'empty_value');
	if($empty_value === false) $empty_value = '';
	$options['options'] = array_merge_recursive2( Array($empty_value => ''), $options['options'] );
	}

	$block_params = $this->prepareTagParams($params);

	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	$block_params['field'] = $params['field'];
	$block_params['pass_params'] = 'true';
	$block_params['field_name'] = $this->InputName($params);
	$block_params['PrefixSpecial'] = $this->getPrefixSpecial();

	$selected_param_name = getArrayValue($params,'selected_param');
	if(!$selected_param_name) $selected_param_name = $params['selected'];
	$selected = $params['selected'];

	$o = '';
	if( $this->HasParam($params,'no_empty') && !getArrayValue($options['options'],'') ) array_shift($options['options']);

	if( strpos($value, '\|') !== false )
	{
	// multiple selection checkboxes
	$value = explode('\|', substr($value, 1, -1) );
	foreach ($options['options'] as $key => $val)
	{
	$block_params['key'] = $key;
	$block_params['option'] = $val;
	$block_params[$selected_param_name] = ( in_array($key, $value) ? ' '.$selected : '');
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}
	else
	{
	// single selection radio or checkboxes
	foreach ($options['options'] as $key => $val)
	{
	$block_params['key'] = $key;
	$block_params['option'] = $val;
	$block_params[$selected_param_name] = ( $key == $value ? ' '.$selected : '');
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}
	return $o;
	}

	function PredefinedSearchOptions($params)
	{
	$object =& $this->getObject($params);
	$field = $params['field'];
	$saved_value = $object->GetDBField($field);

	$object->SetDBField($field, $this->SearchField($params));
	$view_name = $this->Application->RecallVar($this->getPrefixSpecial().'_current_view');
	$custom_filter = $this->Application->RecallPersistentVar($this->getPrefixSpecial().'_custom_filter.'.$view_name);

	$ret = $this->PredefinedOptions($params);
	$object->SetDBField($field, $saved_value);
	return $ret;
	}

	function Format($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);

	$options = $object->GetFieldOptions($field);

	$format = $options[ $this->SelectParam($params, 'input_format') ? 'input_format' : 'format' ];

	$formatter_class = getArrayValue($options,'formatter');
	if($formatter_class)
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$human_format = getArrayValue($params,'human');
	$edit_size = getArrayValue($params,'edit_size');
	$sample = getArrayValue($params,'sample');
	if($sample)
	{
	return $formatter->GetSample($field, $options, $object);
	}
	elseif($human_format \|\| $edit_size)
	{
	$format = $formatter->HumanFormat($format);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $format;
	}

	/**
	* Print grid pagination using
	* block names specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintPages($params)
	{
	$list =& $this->GetList($params);
	$prefix_special = $list->getPrefixSpecial();
	$total_pages = $list->GetTotalPages();

	if ($total_pages > 1) $this->Application->Parser->DataExists = true;

	if($total_pages == 0) $total_pages = 1; // display 1st page as selected in case if we have no pages at all
	$o = '';

	// what are these 2 lines for?
	$this->Application->SetVar($prefix_special.'_event','');
	$this->Application->SetVar($prefix_special.'_id','');

	$current_page = $list->Page; // $this->Application->RecallVar($prefix_special.'_Page');

	$block_params = $this->prepareTagParams($params);

	$split = ( isset($params['split'] ) ? $params['split'] : 10 );

	$split_start = $current_page - ceil($split/2);
	if ($split_start < 1){
	$split_start = 1;
	}
	$split_end = $split_start + $split-1;

	if ($split_end > $total_pages) {
	$split_end = $total_pages;
	$split_start = max($split_end - $split + 1, 1);
	}

	if ($current_page > 1){
	$prev_block_params = $this->prepareTagParams();

	if ($total_pages > $split){
	$prev_block_params['page'] = max($current_page-$split, 1);
	$prev_block_params['name'] = $this->SelectParam($params, 'prev_page_split_render_as,prev_page_split_block');
	if ($prev_block_params['name']){
	$o .= $this->Application->ParseBlock($prev_block_params, 1);
	}
	}

	$prev_block_params['name'] = 'page';
	$prev_block_params['page'] = $current_page-1;
	$prev_block_params['name'] = $this->SelectParam($params, 'prev_page_render_as,block_prev_page,prev_page_block');
	if ($prev_block_params['name']) {
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page-1);
	$o .= $this->Application->ParseBlock($prev_block_params, 1);
	}
	}
	else {
	if ( $no_prev_page_block = $this->SelectParam($params, 'no_prev_page_render_as,block_no_prev_page') ) {
	$block_params['name'] = $no_prev_page_block;
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}

	$separator_params['name'] = $this->SelectParam($params, 'separator_render_as,block_separator');
	for ($i = $split_start; $i <= $split_end; $i++)
	{
	if ($i == $current_page) {
	$block = $this->SelectParam($params, 'current_render_as,active_render_as,block_current,active_block');
	}
	else {
	$block = $this->SelectParam($params, 'link_render_as,inactive_render_as,block_link,inactive_block');
	}

	$block_params['name'] = $block;
	$block_params['page'] = $i;
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $i);
	$o .= $this->Application->ParseBlock($block_params, 1);

	if ($this->SelectParam($params, 'separator_render_as,block_separator')
	&& $i < $split_end)
	{
	$o .= $this->Application->ParseBlock($separator_params, 1);
	}
	}

	if ($current_page < $total_pages){
	$next_block_params = $this->prepareTagParams();
	$next_block_params['page']=$current_page+1;
	$next_block_params['name'] = $this->SelectParam($params, 'next_page_render_as,block_next_page,next_page_block');
	if ($next_block_params['name']){
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page+1);
	$o .= $this->Application->ParseBlock($next_block_params, 1);
	}
	if ($total_pages > $split){
	$next_block_params['page']=min($current_page+$split, $total_pages);
	$next_block_params['name'] = $this->SelectParam($params, 'next_page_split_render_as,next_page_split_block');
	if ($next_block_params['name']){
	$o .= $this->Application->ParseBlock($next_block_params, 1);
	}
	}
	}

	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page);
	return $o;
	}

	/**
	* Print grid pagination using
	* block names specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PaginationBar($params)
	{
	return $this->PrintPages($params);
	}


	/**
	* Returns field name (processed by kMultiLanguage formatter
	* if required) and item's id from it's IDField or field required
	*
	* @param Array $params
	* @return Array (id,field)
	* @access private
	*/
	function prepareInputName($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);

	$formatter_class = getArrayValue($object->Fields, $field, 'formatter');
	if ($formatter_class == 'kMultiLanguage')
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$field = $formatter->LangFieldName($field);
	}

	$id_field = getArrayValue($params, 'IdField');
	$id = $id_field ? $object->GetDBField($id_field) : $object->GetID();

	return Array($id, $field);
	}


	/**
	* Returns input field name to
	* be placed on form (for correct
	* event processing)
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function InputName($params)
	{
	list($id, $field) = $this->prepareInputName($params);

	$ret = $this->getPrefixSpecial().'['.$id.']['.$field.']';
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	/**
	* Allows to override various field options through hidden fields with specific names in submit.
	* This tag generates this special names
	*
	* @param Array $params
	* @return string
	* @author Alex
	*/
	function FieldModifier($params)
	{
	list($id, $field) = $this->prepareInputName($params);

	$ret = 'field_modifiers['.$this->getPrefixSpecial().']['.$field.']['.$params['type'].']';
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	/**
	* Returns index where 1st changable sorting field begins
	*
	* @return int
	* @access private
	*/
	function getUserSortIndex()
	{
	$list_sortings = $this->Application->getUnitOption($this->Prefix, 'ListSortings');
	$sorting_prefix = getArrayValue($list_sortings, $this->Special) ? $this->Special : '';

	$user_sorting_start = 0;
	if ( $forced_sorting = getArrayValue($list_sortings, $sorting_prefix, 'ForcedSorting') ) {
	$user_sorting_start = count($forced_sorting);
	}
	return $user_sorting_start;
	}

	/**
	* Returns order direction for given field
	*
	*
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Order($params)
	{
	$field = $params['field'];
	$user_sorting_start = $this->getUserSortIndex();

	$list =& $this->GetList($params);

	if ($list->GetOrderField($user_sorting_start) == $field)
	{
	return strtolower($list->GetOrderDirection($user_sorting_start));
	}
	elseif($list->GetOrderField($user_sorting_start+1) == $field)
	{
	return '2_'.strtolower($list->GetOrderDirection($user_sorting_start+1));
	}
	else
	{
	return 'no';
	}
	}

	/**
	* Get's information of sorting field at "pos" position,
	* like sorting field name (type="field") or sorting direction (type="direction")
	*
	* @param Array $params
	* @return mixed
	*/
	function OrderInfo($params)
	{
	$user_sorting_start = $this->getUserSortIndex() + --$params['pos'];
	$list =& $this->GetList($params);
	// $object =& $this->Application->recallObject( $this->getPrefixSpecial() );

	if($params['type'] == 'field') return $list->GetOrderField($user_sorting_start);
	if($params['type'] == 'direction') return $list->GetOrderDirection($user_sorting_start);
	}

	/**
	* Checks if sorting field/direction matches passed field/direction parameter
	*
	* @param Array $params
	* @return bool
	*/
	function IsOrder($params)
	{
	$params['type'] = isset($params['field']) ? 'field' : 'direction';
	$value = $this->OrderInfo($params);

	if( isset($params['field']) ) return $params['field'] == $value;
	if( isset($params['direction']) ) return $params['direction'] == $value;
	}

	/**
	* Returns list perpage
	*
	* @param Array $params
	* @return int
	*/
	function PerPage($params)
	{
	$object =& $this->getObject($params);
	return $object->PerPage;
	}

	/**
	* Checks if list perpage matches value specified
	*
	* @param Array $params
	* @return bool
	*/
	function PerPageEquals($params)
	{
	$object =& $this->getObject($params);
	return $object->PerPage == $params['value'];
	}

	function SaveEvent($params)
	{
	// SaveEvent is set during OnItemBuild, but we may need it before any other tag calls OnItemBuild
	$object =& $this->getObject($params);
	return $this->Application->GetVar($this->getPrefixSpecial().'_SaveEvent');
	}

	function NextId($params)
	{
	$object =& $this->getObject($params);
	- $ids = explode(',', $this->Application->RecallVar($this->getPrefixSpecial().'_selected_ids'));
	+
	+ $wid = $this->Application->GetTopmostWid($this->Prefix);
	+ $session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	+ $ids = explode(',', $this->Application->RecallVar($session_name));

	$cur_id = $object->GetID();

	$i = array_search($cur_id, $ids);
	if ($i !== false) {
	return $i < count($ids) - 1 ? $ids[$i + 1] : '';
	}
	return '';
	}

	function PrevId($params)
	{
	$object =& $this->getObject($params);
	- $ids = explode(',', $this->Application->RecallVar($this->getPrefixSpecial().'_selected_ids'));
	+
	+ $wid = $this->Application->GetTopmostWid($this->Prefix);
	+ $session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	+ $ids = explode(',', $this->Application->RecallVar($session_name));

	$cur_id = $object->GetID();

	$i = array_search($cur_id, $ids);
	if ($i !== false) {
	return $i > 0 ? $ids[$i - 1] : '';
	}
	return '';
	}

	function IsSingle($params)
	{
	return ($this->NextId($params) === '' && $this->PrevId($params) === '');
	}

	function IsLast($params)
	{
	return ($this->NextId($params) === '');
	}

	function IsFirst($params)
	{
	return ($this->PrevId($params) === '');
	}

	/**
	* Checks if field value is equal to proposed one
	*
	* @param Array $params
	* @return bool
	*/
	function FieldEquals($params)
	{
	$object =& $this->getObject($params);
	$ret = $object->GetDBField($this->SelectParam($params, 'name,field')) == $params['value'];
	// if( getArrayValue($params,'inverse') ) $ret = !$ret;
	return $ret;
	}

	function ItemIcon($params)
	{
	$object =& $this->getObject($params);

	$grids = $this->Application->getUnitOption($this->Prefix,'Grids');
	$icons =& $grids[ $params['grid'] ]['Icons'];

	$key = '';
	$status_fields = $this->Application->getUnitOption($this->Prefix,'StatusField');
	if(!$status_fields) return $icons['default'];

	foreach($status_fields as $status_field)
	{
	$key .= $object->GetDBField($status_field).'_';
	}
	$key = rtrim($key,'_');
	$value = ($key !== false) ? $key : 'default';

	return isset($icons[$value]) ? $icons[$value] : $icons['default'];
	}

	/**
	* Generates bluebar title + initializes prefixes used on page
	*
	* @param Array $params
	* @return string
	*/
	function SectionTitle($params)
	{
	$preset_name = replaceModuleSection($params['title_preset']);
	$title_presets = $this->Application->getUnitOption($this->Prefix,'TitlePresets');
	$title_info = getArrayValue($title_presets, $preset_name);
	if($title_info === false) return str_replace('#preset_name#', $preset_name, $params['title']);

	if( getArrayValue($title_presets,'default') )
	{
	// use default labels + custom labels specified in preset used
	$title_info = array_merge_recursive2($title_presets['default'], $title_info);
	}

	$title = $title_info['format'];

	// 1. get objects in use for title construction
	$objects = Array();
	$object_status = Array();
	$status_labels = Array();

	$prefixes = getArrayValue($title_info,'prefixes');
	$all_tag_params = getArrayValue($title_info,'tag_params');
	if($prefixes)
	{
	$tag_params = Array();
	foreach($prefixes as $prefix_special)
	{
	$prefix_data = $this->Application->processPrefix($prefix_special);
	$prefix_data['prefix_special'] = rtrim($prefix_data['prefix_special'],'.');

	if($all_tag_params)
	{
	$tag_params = getArrayValue($all_tag_params, $prefix_data['prefix_special']);
	if(!$tag_params) $tag_params = Array();
	}

	$tag_params = array_merge_recursive2($params, $tag_params);
	$objects[ $prefix_data['prefix_special'] ] =& $this->Application->recallObject($prefix_data['prefix_special'], $prefix_data['prefix'], $tag_params);
	$object_status[ $prefix_data['prefix_special'] ] = $objects[ $prefix_data['prefix_special'] ]->IsNewItem() ? 'new' : 'edit';

	// a. set object's status field (adding item/editing item) for each object in title
	if( getArrayValue($title_info[ $object_status[ $prefix_data['prefix_special'] ].'_status_labels' ],$prefix_data['prefix_special']) )
	{
	$status_labels[ $prefix_data['prefix_special'] ] = $title_info[ $object_status[ $prefix_data['prefix_special'] ].'_status_labels' ][ $prefix_data['prefix_special'] ];
	$title = str_replace('#'.$prefix_data['prefix_special'].'_status#', $status_labels[ $prefix_data['prefix_special'] ], $title);
	}

	// b. setting object's titlefield value (in titlebar ONLY) to default in case if object beeing created with no titlefield filled in
	if( $object_status[ $prefix_data['prefix_special'] ] == 'new' )
	{
	$new_value = $this->getInfo( $objects[ $prefix_data['prefix_special'] ], 'titlefield' );
	if(!$new_value && getArrayValue($title_info['new_titlefield'],$prefix_data['prefix_special']) ) $new_value = $this->Application->Phrase($title_info['new_titlefield'][ $prefix_data['prefix_special'] ]);
	$title = str_replace('#'.$prefix_data['prefix_special'].'_titlefield#', $new_value, $title);
	}
	}
	}

	// 2. replace phrases if any found in format string
	$title = $this->Application->ReplaceLanguageTags($title,false);

	// 3. find and replace any replacement vars
	preg_match_all('/#(._.)#/Uis',$title,$rets);
	if($rets[1])
	{
	$replacement_vars = array_keys( array_flip($rets[1]) );
	foreach($replacement_vars as $replacement_var)
	{
	$var_info = explode('_',$replacement_var,2);
	$object =& $objects[ $var_info[0] ];
	$new_value = $this->getInfo($object,$var_info[1]);
	$title = str_replace('#'.$replacement_var.'#', $new_value, $title);
	}
	}

	$cut_first = getArrayValue($params,'cut_first');
	if( $cut_first && strlen($title) > $cut_first && !preg_match('/<a href="(.)">(.)<\/a>/',$title) ) $title = substr($title, 0, $cut_first).' ...';

	return $title;
	}

	function getInfo(&$object, $info_type)
	{
	switch ($info_type)
	{
	case 'titlefield':
	$field = $this->Application->getUnitOption($object->Prefix,'TitleField');
	return $field !== false ? $object->GetField($field) : 'TitleField Missing';
	break;

	case 'recordcount':
	$of_phrase = $this->Application->Phrase('la_of');
	return $object->NoFilterCount != $object->RecordsCount ? $object->RecordsCount.' '.$of_phrase.' '.$object->NoFilterCount : $object->RecordsCount;
	break;

	default:
	return $object->GetField($info_type);
	break;
	}
	}

	/**
	* Parses block depending on its element type.
	* For radio and select elements values are taken from 'value_list_field' in key1=value1,key2=value2
	* format. key=value can be substituted by <SQL>SELECT f1 AS OptionName, f2 AS OptionValue... FROM <PREFIX>TableName </SQL>
	* where prefix is TABLE_PREFIX
	*
	* @param Array $params
	* @return string
	*/
	function ConfigFormElement($params)
	{
	$object =& $this->getObject($params);
	$field = $params['field'];

	$helper =& $this->Application->recallObject('InpCustomFieldsHelper');

	$element_type = $object->GetDBField($params['element_type_field']);

	if($element_type == 'label') $element_type = 'text';
	$params['name'] = $params['blocks_prefix'].$element_type;

	switch ($element_type) {
	case 'select':
	case 'radio':
	$field_options = $object->GetFieldOptions($field, 'options');
	$field_options['options'] = $helper->GetValuesHash( $object->GetDBField($params['value_list_field']) );
	$object->SetFieldOptions($field, $field_options);
	break;

	case 'text':
	case 'textarea':
	$params['field_params'] = $helper->ParseConfigSQL($object->GetDBField($params['value_list_field']));
	break;

	case 'password':
	case 'checkbox':
	default:
	break;
	}
	return $this->Application->ParseBlock($params, 1);
	}

	/**
	* Get's requested custom field value
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function CustomField($params)
	{
	$params['name'] = 'cust_'.$this->SelectParam($params, 'name,field');
	return $this->Field($params);
	}

	function CustomFieldLabel($params)
	{
	$object =& $this->getObject($params);

	$field = $this->SelectParam($params, 'name,field');

	$sql = 'SELECT FieldLabel
	FROM '.$this->Application->getUnitOption('cf', 'TableName').'
	WHERE FieldName = '.$this->Conn->qstr($field);
	return $this->Application->Phrase($this->Conn->GetOne($sql));
	}

	/**
	* transposes 1-dimensional array elements for vertical alignment according to given columns and per_page parameters
	*
	* @param array $arr
	* @param int $columns
	* @param int $per_page
	* @return array
	*/
	function LinearToVertical(&$arr, $columns, $per_page)
	{
	$rows = $columns;
	// in case if after applying per_page limit record count less then
	// can fill requrested column count, then fill as much as we can
	$cols = min(ceil($per_page / $columns), ceil(count($arr) / $columns));
	$imatrix = array();
	for ($row = 0; $row < $rows; $row++) {
	for ($col = 0; $col < $cols; $col++) {
	$source_index = $row * $cols + $col;
	if (!isset($arr[$source_index])) {
	// in case if source array element count is less then element count in one row
	continue;
	}
	$imatrix[$col * $rows + $row] = $arr[$source_index];
	}
	}

	ksort($imatrix);
	reset($imatrix);
	return $imatrix;
	}

	/**
	* If data was modfied & is in TempTables mode, then parse block with name passed;
	* remove modification mark if not in TempTables mode
	*
	* @param Array $params
	* @return string
	* @access public
	* @author Alexey
	*/
	function SaveWarning($params)
	{
	$main_prefix = getArrayValue($params, 'main_prefix');
	if ($main_prefix && $main_prefix != '$main_prefix') {
	$top_prefix = $main_prefix;
	}
	else {
	$top_prefix = $this->Application->GetTopmostPrefix($this->Prefix);
	}

	$temp_tables = substr($this->Application->GetVar($top_prefix.'_mode'), 0, 1) == 't';
	$modified = $this->Application->RecallVar($top_prefix.'_modified');

	if ($temp_tables && $modified) {
	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $this->SelectParam($params, 'render_as,name');
	$block_params['edit_mode'] = $temp_tables ? 1 : 0;
	return $this->Application->ParseBlock($block_params);
	}
	$this->Application->RemoveVar($top_prefix.'_modified');
	return '';
	}

	/**
	* Returns list record count queries (on all pages)
	*
	* @param Array $params
	* @return int
	*/
	function TotalRecords($params)
	{
	$list =& $this->GetList($params);
	if (!$list->Counted) $list->CountRecs();
	return $list->RecordsCount;
	}

	/**
	* Range filter field name
	*
	* @param Array $params
	* @return string
	*/
	function SearchInputName($params)
	{
	$field = $this->SelectParam($params, 'field,name');

	$ret = 'custom_filters['.$this->getPrefixSpecial().']['.$params['grid'].']['.$field.']['.$params['filter_type'].']';

	if (isset($params['type'])) {
	$ret .= '['.$params['type'].']';
	}

	return $ret;
	}

	/**
	* Return range filter field value
	*
	* @param Array $params
	* @return string
	*/
	function SearchField($params) // RangeValue
	{
	$field = $this->SelectParam($params, 'field,name');

	$view_name = $this->Application->RecallVar($this->getPrefixSpecial().'_current_view');
	$custom_filter = $this->Application->RecallPersistentVar($this->getPrefixSpecial().'_custom_filter.'.$view_name);
	$custom_filter = $custom_filter ? unserialize($custom_filter) : Array();

	if (isset($custom_filter[ $params['grid'] ][$field])) {
	$ret = $custom_filter[ $params['grid'] ][$field][ $params['filter_type'] ]['submit_value'];
	if (isset($params['type'])) {
	$ret = $ret[ $params['type'] ];
	}
	return $ret;
	}

	return '';
	}

	function SearchFormat($params)
	{
	$field = $params['field'];
	$object =& $this->GetList($params);

	$options = $object->GetFieldOptions($field);

	$format = $options[ $this->SelectParam($params, 'input_format') ? 'input_format' : 'format' ];

	$formatter_class = getArrayValue($options,'formatter');
	if($formatter_class)
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$human_format = getArrayValue($params,'human');
	$edit_size = getArrayValue($params,'edit_size');
	$sample = getArrayValue($params,'sample');
	if($sample)
	{
	return $formatter->GetSample($field, $options, $object);
	}
	elseif($human_format \|\| $edit_size)
	{
	$format = $formatter->HumanFormat($format);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $format;
	}

	/**
	* Returns error of range field
	*
	* @param unknown_type $params
	* @return unknown
	*/
	function SearchError($params)
	{
	$field = $this->SelectParam($params, 'field,name');

	$error_var_name = $this->getPrefixSpecial().'_'.$field.'_'.$params['type'].'_error';
	$error_msg = $this->Application->RecallVar($error_var_name);
	if($error_msg)
	{
	$this->Application->StoreVar($error_var_name, '');
	}

	$object =& $this->Application->recallObject($this->Prefix.'.'.$this->Special.'-item', null, Array('skip_autoload' => true));
	return $object->ErrorMsgs[$error_msg];
	}

	/**
	* Returns templates path for module, which is gathered from prefix module
	*
	* @param Array $params
	* @return string
	* @author Alex
	*/
	function ModulePath($params)
	{
	$force_module = getArrayValue($params, 'module');
	if ($force_module) {
	if ($force_module == '#session#') {
	$force_module = $this->Application->RecallVar('module');
	if (!$force_module) $force_module = 'core';
	}
	else {
	$force_module = strtolower($force_module);
	}

	if ($force_module == 'core') {
	$module_folder = 'core';
	}
	else {
	$module_folder = trim( $this->Application->findModule('Name', $force_module, 'Path'), '/');
	}
	}
	else {
	$module_folder = $this->Application->getUnitOption($this->Prefix, 'ModuleFolder');
	}
	return '../../'.$module_folder.'/admin_templates/';
	}

	/**
	* Returns object used in tag processor
	*
	* @access public
	* @return kDBBase
	*/
	function &getObject($params = Array())
	{
	$object =& $this->Application->recallObject($this->getPrefixSpecial(), $this->Prefix, $params);
	return $object;
	}

	/**
	* Checks if object propery value matches value passed
	*
	* @param Array $params
	* @return bool
	*/
	function PropertyEquals($params)
	{
	$object =& $this->getObject($params);
	$property_name = $this->SelectParam($params, 'name,var,property');
	return $object->$property_name == $params['value'];
	}

	/**
	* Group list records by header, saves internal order in group
	*
	* @param Array $records
	* @param string $heading_field
	*/
	function groupRecords(&$records, $heading_field)
	{
	$sorted = Array();
	$i = 0; $record_count = count($records);
	while ($i < $record_count) {
	$sorted[ $records[$i][$heading_field] ][] = $records[$i];
	$i++;
	}

	$records = Array();
	foreach ($sorted as $heading => $heading_records) {
	$records = array_merge_recursive($records, $heading_records);
	}
	}

	function DisplayOriginal($params)
	{
	return false;
	}

	function MultipleEditing($params)
	{
	- $selected_ids = $this->Application->RecallVar($this->getPrefixSpecial().'_selected_ids');
	+ $wid = $this->Application->GetTopmostWid($this->Prefix);
	+ $session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	+ $selected_ids = explode(',', $this->Application->RecallVar($session_name));
	+
	$ret = '';
	if ($selected_ids) {
	$selected_ids = explode(',', $selected_ids);
	$object =& $this->getObject( array_merge_recursive2($params, Array('skip_autoload' => true)) );
	$params['name'] = $params['render_as'];
	foreach ($selected_ids as $id) {
	$object->Load($id);
	$ret .= $this->Application->ParseBlock($params);
	}
	}

	return $ret;
	}

	function ExportStatus($params)
	{
	$export_object =& $this->Application->recallObject('CatItemExportHelper');

	$event = new kEvent($this->getPrefixSpecial().':OnDummy');

	$action_method = 'perform'.ucfirst($this->Special);
	$field_values = $export_object->$action_method($event);

	// finish code is done from JS now
	if ($field_values['start_from'] == $field_values['total_records'])
	{
	if ($this->Special == 'import') {
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	$this->Application->Redirect('categories/cache_updater', Array('m_opener' => 'r', 'pass' => 'm', 'continue' => 1, 'no_amp' => 1));
	}
	elseif ($this->Special == 'export') {
	$finish_t = $this->Application->RecallVar('export_finish_t');
	$this->Application->Redirect($finish_t, Array('pass' => 'all'));
	$this->Application->RemoveVar('export_finish_t');
	}
	}

	$export_options = $export_object->loadOptions($event);
	return $export_options['start_from'] * 100 / $export_options['total_records'];
	}

	/**
	* Returns path where exported category items should be saved
	*
	* @param Array $params
	*/
	function ExportPath($params)
	{
	$ret = EXPORT_PATH.'/';

	if( getArrayValue($params, 'as_url') )
	{
	$ret = str_replace( FULL_PATH.'/', $this->Application->BaseURL(), $ret);
	}

	$export_options = unserialize($this->Application->RecallVar($this->getPrefixSpecial().'_options'));
	$ret .= $export_options['ExportFilename'].'.'.($export_options['ExportFormat'] == 1 ? 'csv' : 'xml');

	return $ret;
	}

	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.68.4.3
	\ No newline at end of property
	+1.68.4.4
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.2.2/kernel/units/images/image_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.2.2/kernel/units/images/image_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.2.2/kernel/units/images/image_event_handler.php (revision 6878)
	@@ -1,336 +1,334 @@
	<?php
	class ImageEventHandler extends kDBEventHandler {

	function mapEvents()
	{
	parent::mapEvents(); // ensure auto-adding of approve/decine and so on events
	$image_events = Array(
	'OnAfterCopyToTemp'=>'ImageAction',
	'OnBeforeDeleteFromLive'=>'ImageAction',
	'OnBeforeCopyToLive'=>'ImageAction',
	'OnBeforeItemDelete'=>'ImageAction',
	'OnAfterClone'=>'ImageAction',
	);

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

	function customProcessing(&$event, $type)
	{
	$object =& $event->GetObject();
	switch ($type)
	{
	case 'before' :
	if ($object->GetDBField('LocalImage'))
	{
	$object->SetDBField('Url', '');
	}
	else
	{
	$object->SetDBField('LocalPath', '');
	}

	if ($object->GetDBField('LocalThumb'))
	{
	$object->SetDBField('ThumbUrl', '');
	}
	else
	{
	$object->SetDBField('ThumbPath', '');
	}

	if ($object->GetDBField('SameImages'))
	{
	$object->SetDBField('LocalImage', 1);
	$object->SetDBField('LocalPath', '');
	$object->SetDBField('Url', '');
	}
	break;
	case 'after' :
	if ($object->GetDBField('DefaultImg') )
	{
	$sql = 'UPDATE '.$object->TableName.' SET DefaultImg=0 WHERE ResourceId='.
	$object->GetDBField('ResourceId').' AND ImageId<>'.
	$object->GetId();
	$res = $this->Conn->Query($sql);
	}
	break;
	default:
	}
	}

	function ImageAction(&$event)
	{
	$id = $event->getEventParam('id');
	$object =& $this->Application->recallObject($event->Prefix.'.-item', $event->Prefix);
	if (in_array($event->Name, Array('OnBeforeDeleteFromLive','OnAfterClone')) ) {
	$object->SwitchToLive();
	}
	elseif ($event->Name == 'OnBeforeItemDelete') {
	// keep current table
	}
	else {
	$object->SwitchToTemp();
	}

	$object->Load($id);

	$fields = Array('LocalPath' => 'LocalImage', 'ThumbPath' => 'LocalThumb');
	foreach ($fields as $a_field => $mode_field) {
	$file = $object->GetField($a_field);
	if (!$file) continue;
	$source_file = FULL_PATH.$file;

	switch ($event->Name) {
	// Copy image files to pending dir and update corresponding fields in temp record
	// Checking for existing files and renaming if nessessary - two users may upload same pending files at the same time!
	case 'OnAfterCopyToTemp':
	$new_file = IMAGES_PENDING_PATH . $this->ValidateFileName(FULL_PATH.IMAGES_PENDING_PATH, basename($file));
	$dest_file = FULL_PATH.$new_file;
	copy($source_file, $dest_file);
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;

	// Copy image files to live dir (checking if fileexists and renameing if nessessary)
	// and update corresponding fields in temp record (which gets copied to live automatically)
	case 'OnBeforeCopyToLive':
	if ( $object->GetDBField($mode_field) ) { // if image is local
	// rename file if it exists in live folder
	$new_file = IMAGES_PATH . $this->ValidateFileName(FULL_PATH.IMAGES_PATH, basename($file));
	$dest_file = FULL_PATH.$new_file;
	rename($source_file, $dest_file);
	}
	else { // if image is remote url - remove local file (if any), update local file field with empty value
	if (file_exists($source_file)) @unlink($source_file);
	$new_file = '';
	}
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;

	case 'OnBeforeDeleteFromLive': // Delete image files from live folder before copying over from temp
	case 'OnBeforeItemDelete': // Delete image files when deleteing Image object
	@unlink(FULL_PATH.$file);
	break;

	case 'OnAfterClone': // Copy files when cloning objects, renaming it on the fly
	$path_info = pathinfo($file);
	$new_file = $path_info['dirname'].'/'.$this->ValidateFileName(FULL_PATH.$path_info['dirname'], $path_info['basename']);
	$dest_file = FULL_PATH . $new_file;
	copy($source_file, $dest_file);
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;
	}
	}
	if ( in_array($event->Name, Array('OnAfterClone', 'OnBeforeCopyToLive', 'OnAfterCopyToTemp')) ) {
	$object->Update(null, true);
	}
	}

	function ValidateFileName($path, $name)
	{
	$parts = pathinfo($name);
	$ext = '.'.$parts['extension'];
	$filename = substr($parts['basename'], 0, -strlen($ext));
	$new_name = $filename.$ext;
	while ( file_exists($path.'/'.$new_name) )
	{
	if ( preg_match("/({$filename}_)([0-9]*)($ext)/", $new_name, $regs) ) {
	$new_name = $regs[1].($regs[2]+1).$regs[3];
	}
	else {
	$new_name = $filename.'_1'.$ext;
	}
	}
	return $new_name;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSetPrimary(&$event)
	{
	$object =& $event->getObject();
	$object->SetDBField('DefaultImg', 1);
	$object->Update();
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	// $parent_info = $object->getLinkedInfo();
	$id = $object->GetDBField('ResourceId');
	// $id = $parent_info['ParentId'] ? $parent_info['ParentId'] : $this->Application->GetVar('p_id');
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE ResourceId='.$id.' AND DefaultImg=1';
	if(!$this->Conn->GetOne($sql))
	{
	$object->SetDBField('DefaultImg', 1);
	}
	if($object->GetDBField('DefaultImg') && $object->Validate())
	{

	$sql = 'UPDATE '.$object->TableName.'
	SET DefaultImg = 0
	WHERE ResourceId = '.$id.' AND ImageId <> '.$object->GetDBField('ImageId');
	$this->Conn->Query($sql);
	$object->SetDBField('Enabled', 1);
	}
	}

	function OnAfterItemCreate(&$event)
	{
	$event->CallSubEvent('OnBeforeItemUpdate');
	$object =& $event->getObject();
	$object->Update();
	}

	/**
	* Deletes all selected items.
	* Automatically recurse into sub-items using temp handler, and deletes sub-items
	* by calling its Delete method if sub-item has AutoDelete set to true in its config file
	*
	* @param kEvent $event
	*/
	function OnMassDelete(&$event)
	{
	$event->status=erSUCCESS;

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

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

	$object =& $event->getObject();
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE DefaultImg=1';
	$primary = $this->Conn->GetOne($sql);
	if( $primary && ($key = array_search($primary, $ids)) )
	{
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE DefaultImg=0';
	$res = $this->Conn->Query($sql);
	if($res)
	{
	unset($ids[$key]);
	}
	}

	if($ids)
	{
	$temp->DeleteItems($event->Prefix, $event->Special, $ids);
	}
	$this->clearSelectedIDs($event);
	}

	/*function OnAfterItemLoad(&$event)
	{
	$object =& $event->getObject();

	if ( $object->GetDBField('ThumbPath') \|\| $object->GetDBField('SameImages') )
	{
	// return local image or url
	$path = $object->GetDBField('LocalThumb') ? PROTOCOL.SERVER_NAME.BASE_PATH.$object->GetDBField('ThumbPath') : $object->GetDBField('ThumbUrl');
	if ( $object->GetDBField('LocalThumb') && !file_exists(FULL_PATH.$object->GetDBField('ThumbPath')) ) $path = '';
	}
	else { // if we need full which is not the same as thumb
	$path = $object->GetDBField('LocalImage') ? PROTOCOL.SERVER_NAME.BASE_PATH.$object->GetDBField('LocalPath') : $object->GetDBField('Url');
	if ( $object->GetDBField('LocalImage') && !file_exists(FULL_PATH.$object->GetDBField('LocalPath')) ) $path = '';
	}

	$object->SetDBField('ImageUrl', $path);
	}*/

	function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

	$types=$event->getEventParam('types');
	$except_types=$event->getEventParam('except');
	$object =& $event->getObject();
	$type_clauses = Array();

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

	if($product_id = $event->getEventParam('product_id'))
	{
	$object->removeFilter('parent_filter');
	$sql = 'SELECT ResourceId FROM '.$this->Application->getUnitOption('p', 'TableName').'
	WHERE ProductId = '.$product_id;
	$resource_id = (int) $this->Conn->GetOne($sql);
	$object->addFilter('product_images', '%1$s.ResourceId = '.$resource_id);
	}

	$type_clauses['additional']['include'] = '%1$s.DefaultImg != 1';
	$type_clauses['additional']['except'] = '%1$s.DefaultImg = 1';
	$type_clauses['additional']['having_filter'] = false;

	/********************************************/

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

	$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);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.2.2/kernel/units/images/image_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2
	\ No newline at end of property
	+1.2.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.2.2/core/units/images/image_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.2.2/core/units/images/image_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.2.2/core/units/images/image_event_handler.php (revision 6878)
	@@ -1,336 +1,334 @@
	<?php
	class ImageEventHandler extends kDBEventHandler {

	function mapEvents()
	{
	parent::mapEvents(); // ensure auto-adding of approve/decine and so on events
	$image_events = Array(
	'OnAfterCopyToTemp'=>'ImageAction',
	'OnBeforeDeleteFromLive'=>'ImageAction',
	'OnBeforeCopyToLive'=>'ImageAction',
	'OnBeforeItemDelete'=>'ImageAction',
	'OnAfterClone'=>'ImageAction',
	);

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

	function customProcessing(&$event, $type)
	{
	$object =& $event->GetObject();
	switch ($type)
	{
	case 'before' :
	if ($object->GetDBField('LocalImage'))
	{
	$object->SetDBField('Url', '');
	}
	else
	{
	$object->SetDBField('LocalPath', '');
	}

	if ($object->GetDBField('LocalThumb'))
	{
	$object->SetDBField('ThumbUrl', '');
	}
	else
	{
	$object->SetDBField('ThumbPath', '');
	}

	if ($object->GetDBField('SameImages'))
	{
	$object->SetDBField('LocalImage', 1);
	$object->SetDBField('LocalPath', '');
	$object->SetDBField('Url', '');
	}
	break;
	case 'after' :
	if ($object->GetDBField('DefaultImg') )
	{
	$sql = 'UPDATE '.$object->TableName.' SET DefaultImg=0 WHERE ResourceId='.
	$object->GetDBField('ResourceId').' AND ImageId<>'.
	$object->GetId();
	$res = $this->Conn->Query($sql);
	}
	break;
	default:
	}
	}

	function ImageAction(&$event)
	{
	$id = $event->getEventParam('id');
	$object =& $this->Application->recallObject($event->Prefix.'.-item', $event->Prefix);
	if (in_array($event->Name, Array('OnBeforeDeleteFromLive','OnAfterClone')) ) {
	$object->SwitchToLive();
	}
	elseif ($event->Name == 'OnBeforeItemDelete') {
	// keep current table
	}
	else {
	$object->SwitchToTemp();
	}

	$object->Load($id);

	$fields = Array('LocalPath' => 'LocalImage', 'ThumbPath' => 'LocalThumb');
	foreach ($fields as $a_field => $mode_field) {
	$file = $object->GetField($a_field);
	if (!$file) continue;
	$source_file = FULL_PATH.$file;

	switch ($event->Name) {
	// Copy image files to pending dir and update corresponding fields in temp record
	// Checking for existing files and renaming if nessessary - two users may upload same pending files at the same time!
	case 'OnAfterCopyToTemp':
	$new_file = IMAGES_PENDING_PATH . $this->ValidateFileName(FULL_PATH.IMAGES_PENDING_PATH, basename($file));
	$dest_file = FULL_PATH.$new_file;
	copy($source_file, $dest_file);
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;

	// Copy image files to live dir (checking if fileexists and renameing if nessessary)
	// and update corresponding fields in temp record (which gets copied to live automatically)
	case 'OnBeforeCopyToLive':
	if ( $object->GetDBField($mode_field) ) { // if image is local
	// rename file if it exists in live folder
	$new_file = IMAGES_PATH . $this->ValidateFileName(FULL_PATH.IMAGES_PATH, basename($file));
	$dest_file = FULL_PATH.$new_file;
	rename($source_file, $dest_file);
	}
	else { // if image is remote url - remove local file (if any), update local file field with empty value
	if (file_exists($source_file)) @unlink($source_file);
	$new_file = '';
	}
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;

	case 'OnBeforeDeleteFromLive': // Delete image files from live folder before copying over from temp
	case 'OnBeforeItemDelete': // Delete image files when deleteing Image object
	@unlink(FULL_PATH.$file);
	break;

	case 'OnAfterClone': // Copy files when cloning objects, renaming it on the fly
	$path_info = pathinfo($file);
	$new_file = $path_info['dirname'].'/'.$this->ValidateFileName(FULL_PATH.$path_info['dirname'], $path_info['basename']);
	$dest_file = FULL_PATH . $new_file;
	copy($source_file, $dest_file);
	$object->Fields[$a_field]['skip_empty'] = false;
	$object->SetDBField($a_field, $new_file);
	break;
	}
	}
	if ( in_array($event->Name, Array('OnAfterClone', 'OnBeforeCopyToLive', 'OnAfterCopyToTemp')) ) {
	$object->Update(null, true);
	}
	}

	function ValidateFileName($path, $name)
	{
	$parts = pathinfo($name);
	$ext = '.'.$parts['extension'];
	$filename = substr($parts['basename'], 0, -strlen($ext));
	$new_name = $filename.$ext;
	while ( file_exists($path.'/'.$new_name) )
	{
	if ( preg_match("/({$filename}_)([0-9]*)($ext)/", $new_name, $regs) ) {
	$new_name = $regs[1].($regs[2]+1).$regs[3];
	}
	else {
	$new_name = $filename.'_1'.$ext;
	}
	}
	return $new_name;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnSetPrimary(&$event)
	{
	$object =& $event->getObject();
	$object->SetDBField('DefaultImg', 1);
	$object->Update();
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	// $parent_info = $object->getLinkedInfo();
	$id = $object->GetDBField('ResourceId');
	// $id = $parent_info['ParentId'] ? $parent_info['ParentId'] : $this->Application->GetVar('p_id');
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE ResourceId='.$id.' AND DefaultImg=1';
	if(!$this->Conn->GetOne($sql))
	{
	$object->SetDBField('DefaultImg', 1);
	}
	if($object->GetDBField('DefaultImg') && $object->Validate())
	{

	$sql = 'UPDATE '.$object->TableName.'
	SET DefaultImg = 0
	WHERE ResourceId = '.$id.' AND ImageId <> '.$object->GetDBField('ImageId');
	$this->Conn->Query($sql);
	$object->SetDBField('Enabled', 1);
	}
	}

	function OnAfterItemCreate(&$event)
	{
	$event->CallSubEvent('OnBeforeItemUpdate');
	$object =& $event->getObject();
	$object->Update();
	}

	/**
	* Deletes all selected items.
	* Automatically recurse into sub-items using temp handler, and deletes sub-items
	* by calling its Delete method if sub-item has AutoDelete set to true in its config file
	*
	* @param kEvent $event
	*/
	function OnMassDelete(&$event)
	{
	$event->status=erSUCCESS;

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

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

	$object =& $event->getObject();
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE DefaultImg=1';
	$primary = $this->Conn->GetOne($sql);
	if( $primary && ($key = array_search($primary, $ids)) )
	{
	$sql = 'SELECT ImageId FROM '.$object->TableName.' WHERE DefaultImg=0';
	$res = $this->Conn->Query($sql);
	if($res)
	{
	unset($ids[$key]);
	}
	}

	if($ids)
	{
	$temp->DeleteItems($event->Prefix, $event->Special, $ids);
	}
	$this->clearSelectedIDs($event);
	}

	/*function OnAfterItemLoad(&$event)
	{
	$object =& $event->getObject();

	if ( $object->GetDBField('ThumbPath') \|\| $object->GetDBField('SameImages') )
	{
	// return local image or url
	$path = $object->GetDBField('LocalThumb') ? PROTOCOL.SERVER_NAME.BASE_PATH.$object->GetDBField('ThumbPath') : $object->GetDBField('ThumbUrl');
	if ( $object->GetDBField('LocalThumb') && !file_exists(FULL_PATH.$object->GetDBField('ThumbPath')) ) $path = '';
	}
	else { // if we need full which is not the same as thumb
	$path = $object->GetDBField('LocalImage') ? PROTOCOL.SERVER_NAME.BASE_PATH.$object->GetDBField('LocalPath') : $object->GetDBField('Url');
	if ( $object->GetDBField('LocalImage') && !file_exists(FULL_PATH.$object->GetDBField('LocalPath')) ) $path = '';
	}

	$object->SetDBField('ImageUrl', $path);
	}*/

	function SetCustomQuery(&$event)
	{
	parent::SetCustomQuery($event);

	$types=$event->getEventParam('types');
	$except_types=$event->getEventParam('except');
	$object =& $event->getObject();
	$type_clauses = Array();

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

	if($product_id = $event->getEventParam('product_id'))
	{
	$object->removeFilter('parent_filter');
	$sql = 'SELECT ResourceId FROM '.$this->Application->getUnitOption('p', 'TableName').'
	WHERE ProductId = '.$product_id;
	$resource_id = (int) $this->Conn->GetOne($sql);
	$object->addFilter('product_images', '%1$s.ResourceId = '.$resource_id);
	}

	$type_clauses['additional']['include'] = '%1$s.DefaultImg != 1';
	$type_clauses['additional']['except'] = '%1$s.DefaultImg = 1';
	$type_clauses['additional']['having_filter'] = false;

	/********************************************/

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

	$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);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.2.2/core/units/images/image_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2
	\ No newline at end of property
	+1.2.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.27.2/core/units/admin/admin_tag_processor.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.27.2/core/units/admin/admin_tag_processor.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.27.2/core/units/admin/admin_tag_processor.php (revision 6878)
	@@ -1,553 +1,553 @@
	<?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';
	$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;
	}

	/**
	* Returns list of module item tabs that have view permission in current category
	*
	* @param Array $params
	*/
	function ListCatalogTabs($params)
	{
	$ret = '';
	$special = isset($params['special']) ? $params['special'] : '';
	$replace_main = isset($params['replace_m']) && $params['replace_m'];
	$skip_prefixes = isset($params['skip_prefixes']) ? explode(',', $params['skip_prefixes']) : Array();
	$block_params = Array('name' => $params['render_as']);
	foreach ($this->Application->ModuleInfo as $module_name => $module_info) {
	$prefix = $module_info['Var'];

	if (in_array($prefix, $skip_prefixes) \|\| !$this->Application->getUnitOption($prefix, 'CatalogItem')) continue;
	if ($prefix == 'm' && $replace_main) $prefix = 'c';
	$label = $this->Application->getUnitOption($prefix, $params['title_property']);
	$block_params['title'] = $label;
	$block_params['prefix'] = $prefix;
	$ret .= $this->Application->ParseBlock($block_params);
	}
	return $ret;
	}

	function FCKEditor($params)
	{
	include_once(FULL_PATH.'/admin/editor/cmseditor/fckeditor.php');
	$oFCKeditor = new FCKeditor($params['name']);
	$oFCKeditor->BasePath = BASE_PATH.'/admin/editor/cmseditor/';
	$oFCKeditor->Width = $params['width'] ;
	$oFCKeditor->Height = $params['height'] ;
	$oFCKeditor->ToolbarSet = 'Advanced' ;
	$oFCKeditor->Value = '' ;
	$oFCKeditor->Config = Array(
	//'UserFilesPath' => $pathtoroot.'kernel/user_files',
	'ProjectPath' => BASE_PATH.'/',
	'CustomConfigurationsPath' => $this->Application->BaseURL().'admin/editor/inp_fckconfig.js',
	'EditorAreaCSS' => $this->Application->BaseURL().'/themes/inportal_site/inc/inportal.css', //GetThemeCSS(),
	//'StylesXmlPath' => '../../inp_styles.xml',
	// 'Debug' => 1,
	'Admin' => 1,
	'K4' => 1,
	);
	return $oFCKeditor->CreateHtml();

	}

	/**
	* Allows to construct link for opening any type of catalog item selector
	*
	* @param Array $params
	* @return string
	*/
	function SelectorLink($params)
	{
	$mode = 'catalog';
	if (isset($params['mode'])) { // {catalog, advanced_view}
	$mode = $params['mode'];
	unset($params['mode']);
	}

	$params['t'] = 'in-portal/item_selector/item_selector_'.$mode;

	$default_params = Array('no_amp' => 1, 'pass' => 'all,'.$params['prefix']);
	unset($params['prefix']);

	$pass_through = Array();
	if (isset($params['tabs_dependant'])) { // {yes, no}
	$pass_through['td'] = $params['tabs_dependant'];
	unset($params['tabs_dependant']);
	}

	if (isset($params['selection_mode'])) { // {single, multi}
	$pass_through['tm'] = $params['selection_mode'];
	unset($params['selection_mode']);
	}

	if (isset($params['tab_prefixes'])) { // {all, none, <comma separated prefix list}
	$pass_through['tp'] = $params['tab_prefixes'];
	unset($params['tab_prefixes']);
	}

	if ($pass_through) {
	// add pass_through to selector url if any
	$params['pass_through'] = implode(',', array_keys($pass_through));
	$params = array_merge_recursive2($params, $pass_through);
	}

	// user can override default parameters (except pass_through of course)
	$params = array_merge_recursive2($default_params, $params);

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

	function TimeFrame($params)
	{
	$w = adodb_date('w');
	$m = adodb_date('m');
	$y = adodb_date('Y');
	//FirstDayOfWeek is 0 for Sunday and 1 for Monday
	$fdow = $this->Application->ConfigValue('FirstDayOfWeek');
	if ($fdow && $w == 0) $w = 7;
	$today_start = adodb_mktime(0,0,0,adodb_date('m'),adodb_date('d'),$y);
	$first_day_of_this_week = $today_start - ($w - $fdow)*86400;
	$first_day_of_this_month = adodb_mktime(0,0,0,$m,1,$y);
	$this_quater = ceil($m/3);
	$this_quater_start = adodb_mktime(0,0,0,$this_quater*3-2,1,$y);

	switch ($params['type']) {
	case 'last_week_start':
	$timestamp = $first_day_of_this_week - 86400*7;
	break;
	case 'last_week_end':
	$timestamp = $first_day_of_this_week - 1;
	break;

	case 'last_month_start':
	$timestamp = $m == 1 ? adodb_mktime(0,0,0,12,1,$y-1) : adodb_mktime(0,0,0,$m-1,1,$y);
	break;
	case 'last_month_end':
	$timestamp = $first_day_of_this_month = adodb_mktime(0,0,0,$m,1,$y) - 1;
	break;

	case 'last_quater_start':
	$timestamp = $this_quater == 1 ? adodb_mktime(0,0,0,10,1,$y-1) : adodb_mktime(0,0,0,($this_quater-1)*3-2,1,$y);
	break;
	case 'last_quater_end':
	$timestamp = $this_quater_start - 1;
	break;

	case 'last_6_months_start':
	$timestamp = $m <= 6 ? adodb_mktime(0,0,0,$m+6,1,$y-1) : adodb_mktime(0,0,0,$m-6,1,$y);
	break;

	case 'last_year_start':
	$timestamp = adodb_mktime(0,0,0,1,1,$y-1);
	break;
	case 'last_year_end':
	$timestamp = adodb_mktime(23,59,59,12,31,$y-1);
	break;
	}


	if (isset($params['format'])) {
	$format = $params['format'];
	if(preg_match("/_regional_(.*)/", $format, $regs))
	{
	$lang =& $this->Application->recallObject('lang.current');
	$format = $lang->GetDBField($regs[1]);
	}
	return adodb_date($format, $timestamp);
	}

	return $timestamp;

	}
	function CheckPermCache($params)
	{
	if ($this->Conn->GetOne('SELECT Data FROM '.TABLE_PREFIX.'Cache WHERE VarName = \'ForcePermCacheUpdate\'')) {
	$this->Application->Redirect($params['cache_update_t'], array('continue' => 1));
	}
	}
	/**
	* Checks if current protocol is SSL
	*
	* @param Array $params
	* @return int
	*/
	function IsSSL($params)
	{
	return (PROTOCOL == 'https://')? 1 : 0;
	}

	function PrintColumns($params)
	{
	$var_name = $this->Application->GetVar('picker_name');
	$new = isset($params['new']) && $params['new'];
	if ($new) {
	$var_name = 'column_picker_'.$var_name;
	}

	$user =& $this->Application->recallObject('u');
	$val = $user->getPersistantVar($var_name);
	$cols = $val ? unserialize($val) : array();

	$o = '';
	if ($params['hidden'] == 'true') {
	foreach ($cols['hidden_fields'] as $col) {
	$title = $new ? $this->Application->Phrase($cols['titles'][$col]) : $cols['titles'][$col];
	$o .= "<option value='$col'>".$title;
	}
	}
	else {
	foreach ($cols['order'] as $col) {
	if (in_array($col, $cols['hidden_fields'])) continue;
	$title = $new ? $this->Application->Phrase($cols['titles'][$col]) : $cols['titles'][$col];
	$o .= "<option value='$col'>".$title;
	}
	}
	return $o;
	}

	/**
	* Allows to set popup size (key - current template name)
	*
	* @param Array $params
	*/
	function SetPopupSize($params)
	{

	}

	function UsePopups($params)
	{
	- return true;
	+ return false;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.27.2/core/units/admin/admin_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.27.2.4
	\ No newline at end of property
	+1.27.2.5
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.28.2/core/units/email_events/email_events_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.28.2/core/units/email_events/email_events_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.28.2/core/units/email_events/email_events_event_handler.php (revision 6878)
	@@ -1,273 +1,275 @@
	<?php

	class EmailEventsEventsHandler extends kDBEventHandler
	{

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnFrontOnly' => Array('self' => 'edit'),
	'OnSaveSelected' => Array('self' => 'view'),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Changes permission section to one from REQUEST, not from config
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	$module = $this->Application->GetVar('module');
	$module = explode(':', $module, 2);

	if (count($module) == 1) {
	$main_prefix = $this->Application->findModule('Name', $module[0], 'Var');
	}
	else {
	$exceptions = Array('Category' => 'c', 'Users' => 'u');
	$main_prefix = $exceptions[ $module[1] ];
	}
	$section = $this->Application->getUnitOption($main_prefix.'.email', '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)
	{
	if ($event->Special == 'module') {
	$object =& $event->getObject();
	$module = $this->Application->GetVar('module');
	$object->addFilter('module_filter', '%1$s.Module = '.$this->Conn->qstr($module));
	}
	}

	/**
	* Sets status Front-End Only to selected email events
	*
	* @param kEvent $event
	*/
	function OnFrontOnly(&$event)
	{
	$ids = implode(',', $this->StoreSelectedIDs($event));

	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'UPDATE '.$table_name.'
	SET Enabled = 2
	WHERE EventId IN ('.$ids.')';
	$this->Conn->Query($sql);
	}

	/**
	* Sets selected user to email events selected
	*
	* @param kEvent $event
	*/
	function OnSelectUser(&$event)
	{
	$items_info = $this->Application->GetVar('u');
	if ($items_info) {
	$user_id = array_shift( array_keys($items_info) );
	-
	+
	+ $selected_ids = $this->getSelectedIDs($event, true);
	+
	$ids = $this->Application->RecallVar($event->getPrefixSpecial().'_selected_ids');
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'UPDATE '.$table_name.'
	SET '.$this->Application->RecallVar('dst_field').' = '.$user_id.'
	WHERE '.$id_field.' IN ('.$ids.')';
	$this->Conn->Query($sql);
	}

	$this->finalizePopup($event);
	}

	/**
	* Saves selected ids to session
	*
	* @param kEvent $event
	*/
	function OnSaveSelected(&$event)
	{
	$this->StoreSelectedIDs($event);
	}

	/**
	* Raised when email message shoul be sent
	*
	* @param kEvent $event
	*/
	function OnEmailEvent(&$event){

	$email_event = $event->getEventParam('EmailEventName');
	if( strpos($email_event, '_') !== false )
	{
	trigger_error('<span class="debug_error">Invalid email event name</span> <b>'.$email_event.'</b>. Use only <b>UPPERCASE characters</b> and <b>dots</b> as email event names', E_USER_ERROR);
	}

	$to_user_id = $event->getEventParam('EmailEventToUserId');
	$email_event_type = $event->getEventParam('EmailEventType');

	$message_object = &$this->Application->recallObject('emailmessages', null, Array('skip_autoload' => true));
	$event_table = $this->Application->getUnitOption('emailevents', 'TableName');

	$event_object =& $event->getObject( Array('skip_autoload' => true) );
	$event_object->Load(array('Event'=>$email_event, 'Type'=>$email_event_type));

	$event_id = $event_object->GetDBField('EventId');
	$from_user_id = $event_object->GetDBField('FromUserId');
	$type = $event_object->GetDBField('Type');
	$enabled = $event_object->GetDBField('Enabled');

	$direct_send_params = $event->getEventParam('DirectSendParams');

	if ($enabled == 0) return; // disabled event
	if ($enabled == 2 && $this->Application->IsAdmin() ) return; // event only for front-end

	if ($type == 1){
	// For type "Admin" recipient is a user from field FromUserId which means From/To user in Email events list
	$to_user_id = $from_user_id;
	$from_user_id = -1;
	}
	/*
	if (!($to_user_id > 0) && !$direct_send_params){
	// if we can not determine recepient we will not send email
	return;
	}
	*/
	//Parse Message Template
	$message_object->Load(array('EventId' => $event_id, 'LanguageId' => $this->Application->GetVar('m_lang')));
	$message_type = $message_object->GetDBField('MessageType');

	$email_object = &$this->Application->recallObject('kEmailMessage');
	$email_object->Clear();

	// add footer: begin
	$sql = 'SELECT em.Template
	FROM '.$message_object->TableName.' em
	LEFT JOIN '.TABLE_PREFIX.'Events e ON e.EventId = em.EventId
	WHERE em.LanguageId = '.$message_object->GetDBField('LanguageId').' AND e.Event = "COMMON.FOOTER"';
	$footer = explode("\n\n", $this->Conn->GetOne($sql));
	$footer = $message_object->GetDBField('MessageType') == 'text' ? $email_object->convertHTMLtoPlain($footer[1]) : $footer[1];
	$message_template = $message_object->GetDBField('Template')."\r\n".$footer;
	// add footer: end

	$from_user_object = &$this->Application->recallObject('u.email-from', null, Array('skip_autoload' => true));
	$from_user_object->Load($from_user_id);
	// here if we don't have from_user loaded, it takes a default user from config values
	if ( $from_user_object->IsLoaded() ) {
	$from_user_email = $from_user_object->GetDBField('Email');
	$from_user_name = trim($from_user_object->GetDBField('FirstName').' '.$from_user_object->GetDBField('LastName'));
	}
	else {
	$from_user_email = $this->Application->ConfigValue('Smtp_AdminMailFrom');
	}

	$to_user_object = &$this->Application->recallObject('u.email-to', null, Array('skip_autoload' => true));
	$to_user_object->Load($to_user_id);
	$to_user_email = $to_user_object->GetDBField('Email');
	$to_user_name = trim($to_user_object->GetDBField('FirstName').' '.$to_user_object->GetDBField('LastName'));

	if($direct_send_params){
	$to_user_email = ( $direct_send_params['to_email'] ? $direct_send_params['to_email'] : $to_user_email );
	$to_user_name = ( $direct_send_params['to_name'] ? $direct_send_params['to_name'] : $to_user_name );
	$from_user_email = ( $direct_send_params['from_email'] ? $direct_send_params['from_email'] : $from_user_email);
	$from_user_name = ( $direct_send_params['from_name'] ? $direct_send_params['from_name'] : $from_user_name );
	$message_body_additional = $direct_send_params['message'];
	}

	$to_user_email = $to_user_email ? $to_user_email : $this->Application->ConfigValue('Smtp_AdminMailFrom');

	$this->Application->makeClass('Template');
	$this->Application->InitParser();
	$parser_params = $this->Application->Parser->Params;
	$direct_send_params['message_text'] = $message_body_additional;
	$this->Application->Parser->Params = array_merge_recursive2($this->Application->Parser->Params, $direct_send_params);
	$message_template = str_replace('<inp:touser _Field="password"', '<inp2:u_Field name="Password_plain"', $message_template);
	$message_template = str_replace('<inp:touser _Field="UserName"', '<inp2:u_Field name="Login"', $message_template);
	$message_template = str_replace('<inp:touser _Field', '<inp2:u_Field name', $message_template);
	$message_template = $this->Application->Parser->Parse($message_template, 'email_template', 0);
	$this->Application->Parser->Params = $parser_params;

	$message_template = str_replace("\r", "", $message_template);

	list($message_headers, $message_body) = explode("\n\n", $message_template, 2);


	$email_object->setFrom($from_user_email, $from_user_name);
	$email_object->setTo($to_user_email, $to_user_name);
	$email_object->setSubject('Mail message');

	$email_object->setHeaders($message_headers);

	if ($message_type == 'html'){
	$email_object->setHTMLBody($message_body);
	}
	else {
	$email_object->setTextBody($message_body);
	}

	$smtp_object = &$this->Application->recallObject('kSmtpClient');
	$smtp_object->debug = $this->Application->isDebugMode() && constOn('DBG_SMTP');

	$smtp_server = $this->Application->ConfigValue('Smtp_Server');
	$smtp_port = $this->Application->ConfigValue('Smtp_Port');

	$smtp_authenticate = $this->Application->ConfigValue('Smtp_Authenticate');
	if ($smtp_authenticate){
	$smtp_user = $this->Application->ConfigValue('Smtp_User');
	$smtp_pass = $this->Application->ConfigValue('Smtp_Pass');
	}else{
	$smtp_user = '';
	$smtp_pass = '';
	}


	if ($smtp_server){
	if ($email_object->sendSMTP($smtp_object, $smtp_server, $smtp_user, $smtp_pass, $smtp_authenticate)){
	$event->status=erSUCCESS;
	}
	else {
	$event->status=erFAIL;
	}
	}else{
	if($email_object->send()){
	$event->status=erSUCCESS;
	}
	else {
	$event->status=erFAIL;
	}
	}

	if ($event->status == erSUCCESS){
	if (!$from_user_name) {
	$from_user_name = strip_tags( $this->Application->ConfigValue('Site_Name') );
	}
	$sql = 'INSERT INTO '.TABLE_PREFIX.'EmailLog SET
	fromuser = '.$this->Conn->qstr($from_user_name.' ('.$from_user_email.')').',
	addressto = '.$this->Conn->qstr($to_user_name.' ('.$to_user_email.')').',
	subject = '.$this->Conn->qstr($email_object->Subject).',
	timestamp = UNIX_TIMESTAMP(),
	event = '.$this->Conn->qstr($email_event);
	$this->Conn->Query($sql);
	}

	$this->Application->removeObject('u.email-from');
	$this->Application->removeObject('u.email-to');
	return $event;
	}
	}
	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.28.2/core/units/email_events/email_events_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.28
	\ No newline at end of property
	+1.28.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.79.4/core/kernel/db/db_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.79.4/core/kernel/db/db_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.79.4/core/kernel/db/db_event_handler.php (revision 6878)
	@@ -1,1967 +1,1992 @@
	<?php

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

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


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

	/**
	* Description
	*
	* @var kDBConnection
	* @access public
	*/
	var $Conn;

	/**
	* Adds ability to address db connection
	*
	* @return kDBEventHandler
	* @access public
	*/
	function kDBEventHandler()
	{
	parent::kBase();
	$this->Conn =& $this->Application->GetADODBConnection();
	}

	/**
	* Checks permissions of user
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	if (!$this->Application->IsAdmin()) {
	$allow_events = Array('OnSearch', 'OnSearchReset', 'OnNew');
	if (in_array($event->Name, $allow_events)) {
	// allow search on front
	return true;
	}
	}

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

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

	return parent::CheckPermission($event);
	}

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

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

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

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

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

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


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

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

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

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

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

	'OnGoBack' => Array('self' => true, 'subitem' => true),
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

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

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

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

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

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

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

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

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

	$ids = Array();

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

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

	- $this->Application->SetVar($event->getPrefixSpecial().'_selected_ids',implode(',',$ret));
	- $this->Application->LinkVar($event->getPrefixSpecial().'_selected_ids');
	+ $this->Application->SetVar($event->getPrefixSpecial().'_selected_ids', implode(',',$ret));
	+ $this->Application->LinkVar($event->getPrefixSpecial().'_selected_ids', $session_name);

	// This is critical - otherwise getPassedID will return last ID stored in session! (not exactly true)
	// this smells... needs to be refactored
	$first_id = getArrayValue($ret,0);
	if (($first_id === false) && ($event->getEventParam('raise_warnings') == 1)) {
	if ($this->Application->isDebugMode()) {
	$this->Application->Debugger->appendTrace();
	}
	trigger_error('Requested ID for prefix <b>'.$event->getPrefixSpecial().'</b> <span class="debug_error">not passed</span>',E_USER_NOTICE);
	}
	$this->Application->SetVar($event->getPrefixSpecial(true).'_id', $first_id);
	return $ret;
	}

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

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

	/**
	* Removes any information about current/selected ids
	* from Application variables and Session
	*
	* @param kEvent $event
	*/
	function clearSelectedIDs(&$event)
	{
	$prefix_special = $event->getPrefixSpecial();
	- $ids = $this->Application->RecallVar($prefix_special.'_selected_ids');
	+
	+ $ids = implode(',', $this->getSelectedIDs($event, true));
	$event->setEventParam('ids', $ids);
	-
	- $this->Application->RemoveVar($prefix_special.'_selected_ids');
	+
	+ $wid = $this->Application->GetTopmostWid($event->Prefix);
	+ $session_name = rtrim($prefix_special.'_selected_ids_'.$wid, '_');
	+
	+ $this->Application->RemoveVar($session_name);
	$this->Application->SetVar($prefix_special.'_selected_ids', '');

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

	/*function SetSaveEvent(&$event)
	{
	$this->Application->SetVar($event->Prefix_Special.'_SaveEvent','OnUpdate');
	$this->Application->LinkVar($event->Prefix_Special.'_SaveEvent');
	}*/

	/**
	* Common builder part for Item & List
	*
	* @param kDBBase $object
	* @param kEvent $event
	* @access private
	*/
	function dbBuild(&$object, &$event)
	{
	$object->Configure();
	$this->PrepareObject($object, $event);

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

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

	// This strange constuction creates hidden field for storing event name in form submit
	// It pass SaveEvent to next screen, otherwise after unsuccsefull create it will try to update rather than create
	$current_event = $this->Application->GetVar($event->Prefix_Special.'_event');
	// $this->Application->setEvent($event->Prefix_Special, $current_event);
	$this->Application->setEvent($event->Prefix_Special, '');

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

	/**
	* Builds item (loads if needed)
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnItemBuild(&$event)
	{
	$object =& $event->getObject();
	$this->dbBuild($object,$event);

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

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

	if($auto_load && !$skip_autload) $this->LoadItem($event);

	$actions =& $this->Application->recallObject('kActions');
	$actions->Set($event->Prefix_Special.'_GoTab', '');

	$actions->Set($event->Prefix_Special.'_GoId', '');
	}

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

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return unknown
	*/
	function UseTempTables(&$event)
	{
	$object = &$event->getObject();
	$top_prefix = $this->Application->GetTopmostPrefix($event->Prefix);

	$var_names = Array (
	$top_prefix.'_mode',
	rtrim($top_prefix.'_'.$event->Special, '_'),
	rtrim($top_prefix.'.'.$event->Special, '.'),
	);

	$temp_mode = false;
	foreach ($var_names as $var_name) {
	$value = $this->Application->GetVar($var_name);
	if (substr($value, 0, 1) == 't') {
	$temp_mode = true;
	break;
	}
	}

	return $temp_mode;
	}

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

	/**
	* Load item if id is available
	*
	* @param kEvent $event
	*/
	function LoadItem(&$event)
	{
	$object =& $event->getObject();
	$id = $this->getPassedID($event);
	if ($object->Load($id) )
	{
	$actions =& $this->Application->recallObject('kActions');
	$actions->Set($event->Prefix_Special.'_id', $object->GetID() );

	$use_pending_editing = $this->Application->getUnitOption($event->Prefix, 'UsePendingEditing');
	if ($use_pending_editing && $event->Special != 'original') {
	$this->Application->SetVar($event->Prefix.'.original_id', $object->GetDBField('OrgId'));
	}
	}
	else
	{
	$object->setID($id);
	}
	}

	/**
	* Builds list
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnListBuild(&$event)
	{
	$object =& $event->getObject();

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

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

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

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

	// $object->CalculateTotals(); // Now called in getTotals to avoid extra query

	$actions =& $this->Application->recallObject('kActions');
	$actions->Set('remove_specials['.$event->Prefix_Special.']', '0');
	$actions->Set($event->Prefix_Special.'_GoTab', '');
	}


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

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

	}

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

	/**
	* 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) {
	$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;
	}
	}

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

	$cur_page = $page;
	$cur_per_page = $per_page;

	$object->SetPerPage(1);

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

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

	$object->SetPage($page);
	}

	function getPerPage(&$event)
	{
	$per_page = $event->getEventParam('per_page');

	/* if ($per_page == 'list_next') {
	$per_page = '';
	}*/

	$config_mapping = $this->Application->getUnitOption($event->Prefix, 'ConfigMapping');

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

	if(!$per_page)
	{
	$per_page_var = $event->getPrefixSpecial().'_PerPage';

	$per_page = $this->Application->RecallVar($per_page_var);
	if(!$per_page)
	{

	if ($config_mapping) {
	if (!isset($config_mapping['PerPage'])) {
	trigger_error('Incorrect mapping of <span class="debug_error">PerPage</span> key in config for prefix <b>'.$event->Prefix.'</b>', E_USER_WARNING);
	}
	$per_page = $this->Application->ConfigValue($config_mapping['PerPage']);
	}
	if(!$per_page) $per_page = 10;
	}
	}

	return $per_page;
	}

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

	$cur_sort1 = $this->Application->RecallVar($event->Prefix_Special.'_Sort1');
	$cur_sort1_dir = $this->Application->RecallVar($event->Prefix_Special.'_Sort1_Dir');
	$cur_sort2 = $this->Application->RecallVar($event->Prefix_Special.'_Sort2');
	$cur_sort2_dir = $this->Application->RecallVar($event->Prefix_Special.'_Sort2_Dir');


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

	$tag_sort_by = $event->getEventParam('sort_by');
	if ($tag_sort_by) {
	if ($tag_sort_by == 'random') {
	$by = 'RAND()';
	$dir = '';
	}
	else {
	list($by, $dir) = explode(',', $tag_sort_by);
	}
	$object->AddOrderField($by, $dir);
	}

	if ($sorting_configs && isset ($sorting_configs['DefaultSorting1Field'])){
	$list_sortings[$sorting_prefix]['Sorting'] = Array(
	$this->Application->ConfigValue($sorting_configs['DefaultSorting1Field']) => $this->Application->ConfigValue($sorting_configs['DefaultSorting1Dir']),
	$this->Application->ConfigValue($sorting_configs['DefaultSorting2Field']) => $this->Application->ConfigValue($sorting_configs['DefaultSorting2Dir']),
	);
	}

	// Use default if not specified
	if ( !$cur_sort1 \|\| !$cur_sort1_dir)
	{
	if ( $sorting = getArrayValue($list_sortings, $sorting_prefix, 'Sorting') ) {
	reset($sorting);
	$cur_sort1 = key($sorting);
	$cur_sort1_dir = current($sorting);
	if (next($sorting)) {
	$cur_sort2 = key($sorting);
	$cur_sort2_dir = current($sorting);
	}
	}
	}

	if ( $forced_sorting = getArrayValue($list_sortings, $sorting_prefix, 'ForcedSorting') ) {
	foreach ($forced_sorting as $field => $dir) {
	$object->AddOrderField($field, $dir);
	}
	}

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

	/**
	* Adds filters found in session to object
	*
	* @param kEvent $event
	* @param string $session_var variable name in session, where filter is stored
	* @param string $filter_class filter class, e.g. FLT_SYSTEM, FLT_NORMAL, etc.
	*/
	function addStoredFilter(&$event, $session_var, $filter_class)
	{
	$filter_data = $this->Application->RecallVar($event->getPrefixSpecial().'_'.$session_var);
	if ($filter_data) {
	$object =& $event->getObject();
	$filter_data = unserialize($filter_data);
	foreach ($filter_data as $filter_field => $filter_params) {
	$filter_type = ($filter_params['type'] == 'having') ? HAVING_FILTER : WHERE_FILTER;
	$object->addFilter($filter_field, $filter_params['value'], $filter_type, $filter_sub_type);
	}
	}
	}

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

	// add search filter
	$filter_data = $this->Application->RecallVar($event->getPrefixSpecial().'_search_filter');
	if ($filter_data) {
	$filter_data = unserialize($filter_data);
	foreach ($filter_data as $filter_field => $filter_params) {
	$filter_type = ($filter_params['type'] == 'having') ? HAVING_FILTER : WHERE_FILTER;
	$object->addFilter($filter_field, $filter_params['value'], $filter_type, FLT_SEARCH);
	}
	}

	// add custom filter
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial().'_current_view');
	$custom_filters = $this->Application->RecallPersistentVar($event->getPrefixSpecial().'_custom_filter.'.$view_name);
	if ($custom_filters) {
	$grid_name = $event->getEventParam('grid');
	$custom_filters = unserialize($custom_filters);
	if (isset($custom_filters[$grid_name])) {
	foreach ($custom_filters[$grid_name] as $field_name => $field_options) {
	list ($filter_type, $field_options) = each($field_options);
	if ($field_options['value']) {
	$filter_type = ($field_options['sql_filter_type'] == 'having') ? HAVING_FILTER : WHERE_FILTER;
	$object->addFilter($field_name, $field_options['value'], $filter_type, FLT_CUSTOM);
	}
	}
	}
	}

	$view_filter = $this->Application->RecallVar($event->getPrefixSpecial().'_view_filter');
	if($view_filter)
	{
	$view_filter = unserialize($view_filter);
	$temp_filter =& $this->Application->makeClass('kMultipleFilter');
	$filter_menu = $this->Application->getUnitOption($event->Prefix,'FilterMenu');

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

	$temp_filter->setType( constant('FLT_TYPE_'.$group_info['mode']) );
	$temp_filter->clearFilters();
	foreach ($group_info['filters'] as $flt_id)
	{
	$sql_key = getArrayValue($view_filter,$flt_id) ? 'on_sql' : 'off_sql';
	if ($filter_menu['Filters'][$flt_id][$sql_key] != '')
	{
	$temp_filter->addFilter('view_filter_'.$flt_id, $filter_menu['Filters'][$flt_id][$sql_key]);
	}
	}
	$object->addFilter('view_group_'.$group_key, $temp_filter, $group_info['type'] , FLT_VIEW);
	$group_key++;
	}
	}
	}

	/**
	* Set's new sorting for list
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnSetSorting(&$event)
	{
	$cur_sort1 = $this->Application->RecallVar($event->Prefix_Special.'_Sort1');
	$cur_sort1_dir = $this->Application->RecallVar($event->Prefix_Special.'_Sort1_Dir');
	$cur_sort2 = $this->Application->RecallVar($event->Prefix_Special.'_Sort2');
	$cur_sort2_dir = $this->Application->RecallVar($event->Prefix_Special.'_Sort2_Dir');

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

	$this->Application->StoreVar($event->Prefix_Special.'_Sort1', $cur_sort1);
	$this->Application->StoreVar($event->Prefix_Special.'_Sort1_Dir', $cur_sort1_dir);
	$this->Application->StoreVar($event->Prefix_Special.'_Sort2', $cur_sort2);
	$this->Application->StoreVar($event->Prefix_Special.'_Sort2_Dir', $cur_sort2_dir);
	}

	/**
	* Set sorting directly to session
	*
	* @param kEvent $event
	*/
	function OnSetSortingDirect(&$event)
	{
	$combined = $this->Application->GetVar($event->getPrefixSpecial(true).'_CombinedSorting');
	if ($combined) {
	list($field,$dir) = explode('\|',$combined);
	$this->Application->StoreVar($event->Prefix_Special.'_Sort1', $field);
	$this->Application->StoreVar($event->Prefix_Special.'_Sort1_Dir', $dir);
	return;
	}

	$field_pos = $this->Application->GetVar($event->getPrefixSpecial(true).'_SortPos');
	$this->Application->LinkVar( $event->getPrefixSpecial(true).'_Sort'.$field_pos, $event->Prefix_Special.'_Sort'.$field_pos);
	$this->Application->LinkVar( $event->getPrefixSpecial(true).'_Sort'.$field_pos.'_Dir', $event->Prefix_Special.'_Sort'.$field_pos.'_Dir');
	}

	/**
	* Reset grid sorting to default (from config)
	*
	* @param kEvent $event
	*/
	function OnResetSorting(&$event)
	{
	$this->Application->RemoveVar($event->Prefix_Special.'_Sort1');
	$this->Application->RemoveVar($event->Prefix_Special.'_Sort1_Dir');
	$this->Application->RemoveVar($event->Prefix_Special.'_Sort2');
	$this->Application->RemoveVar($event->Prefix_Special.'_Sort2_Dir');
	}

	/**
	* Creates needed sql query to load item,
	* if no query is defined in config for
	* special requested, then use default
	* query
	*
	* @param kEvent $event
	* @access protected
	*/
	function ItemPrepareQuery(&$event)
	{
	$sqls = $this->Application->getUnitOption($event->Prefix,'ItemSQLs');
	return isset($sqls[$event->Special]) ? $sqls[$event->Special] : $sqls[''];
	}

	/**
	* Creates needed sql query to load list,
	* if no query is defined in config for
	* special requested, then use default
	* query
	*
	* @param kEvent $event
	* @access protected
	*/
	function ListPrepareQuery(&$event)
	{
	$sqls = $this->Application->getUnitOption($event->Prefix,'ListSQLs');
	return isset( $sqls[$event->Special] ) ? $sqls[$event->Special] : $sqls[''];
	}

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

	}

	/* Edit Events mostly used in Admin */

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

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

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

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

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

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if($items_info)
	{
	foreach($items_info as $id => $field_values)
	{
	$object->Load($id);
	$object->SetFieldsFromHash($field_values);
	$this->customProcessing($event, 'before');
	if( $object->Update($id) )
	{
	$this->customProcessing($event, 'after');
	$event->status=erSUCCESS;
	}
	else
	{
	$event->status=erFAIL;
	$event->redirect=false;
	break;
	}
	}
	}
	$event->redirect_params = Array('opener'=>'u');
	}

	/**
	* Delete's kDBItem object
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnDelete(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->ID = $this->getPassedID($event);
	if( $object->Delete() )
	{
	$event->status = erSUCCESS;
	}
	else
	{
	$event->status = erFAIL;
	$event->redirect = false;
	}
	}

	/**
	* Prepares new kDBItem object
	*
	* @param kEvent $event
	* @access protected
	*/
	function OnNew(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->setID(0);
	$this->Application->SetVar($event->Prefix_Special.'_SaveEvent','OnCreate');

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

	$event->redirect = false;
	}

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

	$items_info = $this->Application->GetVar($event->getPrefixSpecial(true));
	if ($items_info) {
	$delete_ids = Array();
	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	foreach ($items_info as $id => $field_values) {
	$object->Load($id);
	// record created for using with selector (e.g. Reviews->Select User), and not validated => Delete it
	if ($object->isLoaded() && !$object->Validate() && ($id <= 0) ) {
	$delete_ids[] = $id;
	}
	}

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

	$event->redirect_params = Array('opener'=>'u');
	}


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

	$event->status=erSUCCESS;

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

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

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

	if($ids)
	{
	$temp->DeleteItems($event->Prefix, $event->Special, $ids);
	}
	$this->clearSelectedIDs($event);
	}

	/**
	* Sets window id (of first opened edit window) to temp mark in uls
	*
	* @param kEvent $event
	*/
	function setTempWindowID(&$event)
	{
	$mode = $this->Application->GetVar($event->Prefix.'_mode');
	if ($mode == 't') {
	$wid = $this->Application->GetVar('m_wid');
	$this->Application->SetVar($event->Prefix.'_mode', 't'.$wid);
	}
	}

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

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

	$temp->PrepareEdit();

	$event->redirect=false;
	}

	/**
	* Saves content of temp table into live and
	* redirects to event' default redirect (normally grid template)
	*
	* @param kEvent $event
	*/
	function OnSave(&$event)
	{
	$event->CallSubEvent('OnPreSave');
	if ($event->status == erSUCCESS) {
	$skip_master = false;
	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');

	if (!$this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$live_ids = $temp->SaveEdit($event->getEventParam('master_ids') ? $event->getEventParam('master_ids') : Array());
	if ($live_ids) {
	// ensure, that newly created item ids are avalable as if they were selected from grid
	// NOTE: only works if main item has subitems !!!
	- $this->Application->StoreVar($event->getPrefixSpecial().'_selected_ids', implode(',', $live_ids));
	+ $this->StoreSelectedIDs($event, $live_ids);
	}
	}
	$this->clearSelectedIDs($event);

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

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

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

	$this->clearSelectedIDs($event);
	$event->redirect_params = Array('opener'=>'u');
	$this->Application->RemoveVar($event->getPrefixSpecial().'_modified');
	}


	/**
	* Allows to determine if we are creating new item or editing already created item
	*
	* @param kEvent $event
	* @return bool
	*/
	function isNewItemCreate(&$event)
	{
	$event->setEventParam('raise_warnings', 0);
	$item_id = $this->getPassedID($event);
	return ($item_id == '') ? true : false;
	}

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

	if ($this->isNewItemCreate($event)) {
	$event->CallSubEvent('OnPreSaveCreated');
	if (is_object($event->MasterEvent)) {
	$event->MasterEvent->setEventParam('IsNew',true);
	}
	return;
	}

	$object =& $event->getObject( Array('skip_autoload' => true) );

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if ($items_info) {
	foreach ($items_info as $id => $field_values) {
	$object->SetDefaultValues();
	$object->Load($id);
	$object->SetFieldsFromHash($field_values);
	$this->customProcessing($event, 'before');
	if( $object->Update($id) )
	{
	$this->customProcessing($event, 'after');
	$event->status=erSUCCESS;
	}
	else {
	$event->status = erFAIL;
	$event->redirect = false;
	break;
	}
	}
	}
	}

	/**
	* Saves edited item in temp table and loads
	* item with passed id in current template
	* Used in Prev/Next buttons
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndGo(&$event)
	{
	$event->CallSubEvent('OnPreSave');
	if ($event->status==erSUCCESS) {
	$event->redirect_params[$event->getPrefixSpecial(true).'_id'] = $this->Application->GetVar($event->Prefix_Special.'_GoId');
	}
	}

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

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

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

	$object =& $event->getObject( Array('skip_autoload' => true) );

	$temp =& $this->Application->recallObject($event->Prefix.'_TempHandler', 'kTempTablesHandler');
	$temp->PrepareEdit();

	$object->setID(0);

	$event->redirect=false;
	}

	/**
	* Creates a new item in temp table and
	* stores item id in App vars and Session on succsess
	*
	* @param kEvent $event
	*/
	function OnPreSaveCreated(&$event)
	{
	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if($items_info) $field_values = array_shift($items_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);

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

	if( $object->Create() )
	{
	$this->customProcessing($event, 'after');
	$event->redirect_params[$event->getPrefixSpecial(true).'_id'] = $object->GetId();
	$event->status=erSUCCESS;
	}
	else
	{
	$event->status=erFAIL;
	$event->redirect=false;
	$object->setID(0);
	}

	}

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

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$ids = $this->StoreSelectedIDs($event);

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

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

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

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

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

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

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

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

	$event->status = erSUCCESS;

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

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

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

	$this->clearSelectedIDs($event);
	}

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

	function OnPreSavePopup(&$event)
	{
	$object =& $event->getObject();
	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');

	$this->finalizePopup($event);
	}


	/* End of Edit events */

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

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

	}

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

	}

	/**
	* Occurse before creating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemCreate(&$event)
	{

	}

	/**
	* Occurse after creating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemCreate(&$event)
	{

	}

	/**
	* Occurse before updating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemUpdate(&$event)
	{

	}

	/**
	* Occurse after updating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnAfterItemUpdate(&$event)
	{

	}

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

	}

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

	}

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

	}

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

	}

	/**
	* Occures before an item is deleted from live table when copying from temp
	* (temp handler deleted all items from live and then copy over all items from temp)
	* Id of item being deleted is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnBeforeDeleteFromLive(&$event)
	{

	}

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

	}

	/**
	* !!! NOT FULLY IMPLEMENTED - SEE TEMP HANDLER COMMENTS (search by event name)!!!
	* Occures after an item has been copied to live table
	* Id of copied item is passed as event' 'id' param
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToLive(&$event)
	{

	}

	/**
	* Occures before an item is cloneded
	* Id of ORIGINAL item is passed as event' 'id' param
	* Do not call object' Update method in this event, just set needed fields!
	*
	* @param kEvent $event
	*/
	function OnBeforeClone(&$event)
	{

	}

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

	}

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

	/*return ;

	// 2. substitute opener
	$opener_stack = $this->Application->RecallVar('opener_stack');
	$opener_stack = $opener_stack ? unserialize($opener_stack) : Array();
	//array_pop($opener_stack);

	$t = $this->Application->RecallVar('return_template');
	$this->Application->RemoveVar('return_template');

	// restore original "m" prefix all params, that have values before opening selector
	$return_m = $this->Application->RecallVar('return_m');
	$this->Application->RemoveVar('return_m');
	$this->Application->HttpQuery->parseEnvPart($return_m);

	$pass_events = $event->getEventParam('pass_events');
	$redirect_params = array_merge_recursive2($event->redirect_params, Array('m_opener' => 'u', '__URLENCODE__' => 1));

	$new_level = 'index.php\|'.ltrim($this->Application->BuildEnv($t, $redirect_params, 'all', $pass_events), ENV_VAR_NAME.'=');
	array_push($opener_stack, $new_level);
	$this->Application->StoreVar('opener_stack', serialize($opener_stack));*/
	}


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

	$search_helper =& $this->Application->recallObject('SearchHelper');
	$search_helper->performSearch($event);
	}

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

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

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

	$view_filter[$filter_id] = $filter_value;

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

	function OnSetFilterPattern(&$event)
	{
	$filters = $this->Application->GetVar($event->getPrefixSpecial(true).'_filters');
	if (!$filters) return ;

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

	$filters = explode(',', $filters);
	foreach ($filters as $a_filter) {
	list($id, $value) = explode('=', $a_filter);
	$view_filter[$id] = $value;
	}
	$this->Application->StoreVar( $event->getPrefixSpecial().'_view_filter', serialize($view_filter) );
	$event->redirect = false;
	}

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

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

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	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'));
	}
	}

	function RemoveRequiredFields(&$object)
	{
	// making all field non-required to achieve successful presave
	foreach($object->Fields as $field => $options)
	{
	if(isset($options['required']))
	{
	unset($object->Fields[$field]['required']);
	}
	}
	}

	/**
	* Dynamically fills customdata config
	*
	* @param kEvent $event
	*/
	function OnCreateCustomFields(&$event)
	{
	$main_prefix = $this->Application->getUnitOption($event->Prefix, 'ParentPrefix');
	if (!$main_prefix) return false;
	$item_type = $this->Application->getUnitOption($main_prefix, 'ItemType');
	if (!$item_type) {
	// no main config of such type
	return false;
	}

	// 1. get custom field information
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'CustomField
	WHERE Type = '.$item_type.'
	ORDER BY CustomFieldId';
	$custom_fields = $this->Conn->Query($sql, 'CustomFieldId');
	if (!$custom_fields) {
	// config doesn't have custom fields
	return false;
	}

	// 2. create fields (for customdata item)
	$fields = $this->Application->getUnitOption($event->Prefix, 'Fields', Array());
	$field_options = Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'db_type' => 'text', 'default' => '');
	foreach ($custom_fields as $custom_id => $custom_params) {
	if (isset($fields['cust_'.$custom_id])) continue;
	$fields['cust_'.$custom_id] = $field_options;
	}
	$this->Application->setUnitOption($event->Prefix, 'Fields', $fields);

	// 3. create virtual & calculated fields (for main item)
	$calculated_fields = Array();
	$virtual_fields = $this->Application->getUnitOption($main_prefix, 'VirtualFields', Array());

	$cf_helper =& $this->Application->recallObject('InpCustomFieldsHelper');
	$field_options = Array('type' => 'string', 'not_null' => 1, 'default' => '');
	$ml_formatter =& $this->Application->recallObject('kMultiLanguage');

	foreach ($custom_fields as $custom_id => $custom_params) {
	switch ($custom_params['ElementType']) {
	case 'date':
	case 'datetime':
	unset($field_options['options']);
	$field_options['formatter'] = 'kDateFormatter';
	break;

	case 'select':
	case 'radio':
	if ($custom_params['ValueList']) {
	$field_options['options'] = $cf_helper->GetValuesHash($custom_params['ValueList']);
	$field_options['formatter'] = 'kOptionsFormatter';
	}
	break;

	default:
	unset($field_options['options'], $field_options['formatter']);
	break;
	}

	$custom_name = $custom_params['FieldName'];
	$calculated_fields['cust_'.$custom_name] = 'cust.'.$ml_formatter->LangFieldName('cust_'.$custom_id);
	if (!isset($virtual_fields['cust_'.$custom_name])) {
	$virtual_fields['cust_'.$custom_name] = Array();
	}
	$virtual_fields['cust_'.$custom_name] = array_merge_recursive2($field_options, $virtual_fields['cust_'.$custom_name]);
	$custom_fields[$custom_id] = $custom_name;
	}

	$config_calculated_fields = $this->Application->getUnitOption($main_prefix, 'CalculatedFields', Array());
	foreach ($config_calculated_fields as $special => $special_fields) {
	$config_calculated_fields[$special] = array_merge_recursive2($config_calculated_fields[$special], $calculated_fields);
	}
	$this->Application->setUnitOption($main_prefix, 'CalculatedFields', $config_calculated_fields);

	$this->Application->setUnitOption($main_prefix, 'CustomFields', $custom_fields);
	$this->Application->setUnitOption($main_prefix, 'VirtualFields', $virtual_fields);
	}

	/**
	* Saves selected user in needed field
	*
	* @param kEvent $event
	*/
	function OnSelectUser(&$event)
	{
	$items_info = $this->Application->GetVar('u');
	if ($items_info) {
	$user_id = array_shift( array_keys($items_info) );

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

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

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

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

	if ($is_new) {
	$object->Create();
	if (!$is_main && $object->IsTempTable()) {
	$object->setTempID();
	}
	}
	else {
	$object->Update();
	}
	}

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


	/ EXPORT RELATED /

	/**
	* Shows export dialog
	*
	* @param kEvent $event
	*/
	function OnExport(&$event)
	{
	$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;
	}

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

	$export_t = $this->Application->GetVar('export_template');
	$this->Application->LinkVar('export_finish_t');
	$this->Application->LinkVar('export_progress_t');
	$this->Application->StoreVar('export_oroginal_special', $event->Special);
	$export_helper =& $this->Application->recallObject('CatItemExportHelper');
	$event->redirect = $export_t ? $export_t : $export_helper->getModuleFolder($event).'/export';

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

	$event->setRedirectParams($redirect_params);
	}

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

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

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

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

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

	}

	function OnDeleteExportPreset(&$event)
	{
	$object =& $event->GetObject();

	$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
	if($items_info)
	{
	list($id,$field_values) = each($items_info);
	$preset_key = $field_values['ExportPresets'];

	$user =& $this->Application->recallObject('u');
	$export_settings = $user->getPersistantVar('export_settings');
	if (!$export_settings) return ;
	$export_settings = unserialize($export_settings);
	if (!isset($export_settings[$event->Prefix])) return ;

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

	}


	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.79.4/core/kernel/db/db_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.79.4.5
	\ No newline at end of property
	+1.79.4.6
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.25.2/core/units/categories/categories_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.25.2/core/units/categories/categories_event_handler.php (revision 6877)
	+++ branches/unlabeled/unlabeled-1.25.2/core/units/categories/categories_event_handler.php (revision 6878)
	@@ -1,507 +1,507 @@
	<?php

	class CategoriesEventHandler extends kDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnRebuildCache' => Array('self' => 'add\|edit'),
	// 'OnSave' => Array('self' => 'add\|edit')
	);
	$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 == 'OnEdit' \|\| $event->Name == 'OnSave') {
	// check each id from selected individually and only if all are allowed proceed next
	if ($event->Name == 'OnEdit') {
	$selected_ids = implode(',', $this->StoreSelectedIDs($event));
	}
	else {
	- $selected_ids = $this->Application->RecallVar($event->getPrefixSpecial().'_selected_ids');
	+ $selected_ids = implode(',', $this->getSelectedIDs($event, true));
	}

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT '.$id_field.', CreatedById
	FROM '.$table_name.' item_table
	WHERE '.$id_field.' IN ('.$selected_ids.')';
	$items = $this->Conn->Query($sql, $id_field);

	$perm_value = true;
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	foreach ($items as $item_id => $item_data) {
	if ($perm_helper->ModifyCheckPermission($item_data['CreatedById'], $item_data[$id_field], $event->Prefix) == 0) {
	// one of items selected has no permission
	$perm_value = false;
	break;
	}
	}

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

	return $perm_value;
	}

	return parent::CheckPermission($event);
	}

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

	$types=$event->getEventParam('types');
	$except_types=$event->getEventParam('except');
	$object =& $event->getObject();
	$type_clauses = Array();

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

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

	if ($parent_cat_id == 'Root') {
	$module_name = $event->getEventParam('module') ? $event->getEventParam('module') : 'In-Commerce';
	$module =& $this->Application->recallObject('mod.'.$module_name);
	$parent_cat_id = $module->GetDBField('RootCat');
	}

	}
	else {
	$parent_cat_id = $this->Application->GetVar('c_id');
	if (!$parent_cat_id) {
	$parent_cat_id = $this->Application->GetVar('m_cat_id');
	}
	if (!$parent_cat_id) {
	$parent_cat_id = 0;
	}
	}

	if ("$parent_cat_id" != '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('parent_filter', 'ParentId IN ('.implode(', ', $subcats).')');
	}
	else {
	$object->addFilter('parent_filter', 'ParentId = '.$parent_cat_id);
	}
	}

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

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

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

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

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

	if(strpos($types, 'product_related') !== false)
	{
	$object->removeFilter('parent_filter');

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

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

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

	/********************************************/

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

	$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);
	}

	function GetPassedId(&$event)
	{
	if ( $this->Application->IsAdmin() ) {
	return parent::getPassedID($event);
	}

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

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function prepareObject(&$object, &$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

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

	/**
	* Set correct parent path for newly created categories
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToLive(&$event)
	{
	if ($event->getEventParam('temp_id') == 0) {
	$object =& $this->Application->recallObject($event->Prefix.'.-item', null, Array('skip_autoload' => true, 'live_table' => true));
	$object->Load($event->getEventParam('id'));
	if ($object->isLoaded()) {
	// update path only for real categories (not including "Home" root category)
	$fields_hash = Array('ParentPath' => $object->buildParentPath());
	$this->Conn->doUpdate($fields_hash, $object->TableName, 'CategoryId = '.$object->GetID());
	}
	}
	}

	/**
	* Set cache modification mark if needed
	*
	* @param kEvent $event
	*/
	function OnBeforeDeleteFromLive(&$event)
	{
	$id = $event->getEventParam('id');

	// loding anyway, because this object is needed by "c-perm:OnBeforeDeleteFromLive" event
	$temp_object =& $event->getObject( Array('skip_autoload' => true) );
	$temp_object->Load($id);

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

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

	$cached_fields = Array('Name', 'Filename', 'CategoryTemplate');

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

	/**
	* Checks cache update mark and redirect to cache if needed
	*
	* @param kEvent $event
	*/
	function OnSave(&$event)
	{
	$object =& $event->getObject();
	if ($object->IsRoot()) {
	$event->setEventParam('master_ids', Array(0));
	}

	parent::OnSave($event);
	if ($event->status == erSUCCESS && $this->Application->RecallVar('PermCache_UpdateRequired')) {
	// "catalog" should be in opener stack by now
	$wid = $this->Application->GetVar('m_wid');
	$stack_name = rtrim('opener_stack_'.$wid, '_');

	$opener_stack = unserialize($this->Application->RecallVar($stack_name));
	$opener_stack[0] = str_replace('catalog', 'categories/cache_updater', $opener_stack[0]);
	$this->Application->StoreVar($stack_name, serialize($opener_stack));
	$this->Application->RemoveVar('PermCache_UpdateRequired');
	}
	}

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

	// $event->status = erSUCCESS;

	$ids = $this->StoreSelectedIDs($event);
	if ($ids) {
	$recursive_helper =& $this->Application->recallObject('RecursiveHelper');
	foreach ($ids as $id) {
	$recursive_helper->DeleteCategory($id);
	}
	}
	$this->clearSelectedIDs($event);
	}

	/**
	* Add selected items to clipboard with mode = COPY (CLONE)
	*
	* @param kEvent $event
	*/
	function OnCopy(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'copy', $this->StoreSelectedIDs($event));
	}

	/**
	* Add selected items to clipboard with mode = CUT
	*
	* @param kEvent $event
	*/
	function OnCut(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'cut', $this->StoreSelectedIDs($event));
	}

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

	$event->redirect = $paste_event->redirect;
	$event->redirect_params = $paste_event->redirect_params;
	$event->status = $paste_event->status;
	}
	}

	/**
	* Paste categories with subitems from clipboard
	*
	* @param kEvent $event
	*/
	function OnPaste(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

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

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

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

	if ($clipboard_data['copy']) {
	foreach ($clipboard_data['copy'] as $id) {
	$recursive_helper->PasteCategory($id);
	}
	}

	if ($clipboard_data['cut'] \|\| $clipboard_data['copy']) {
	$event->redirect = 'categories/cache_updater';
	}
	}

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

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

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

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

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

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

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

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

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

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.25.2/core/units/categories/categories_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.25.2.2
	\ No newline at end of property
	+1.25.2.3
	\ 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