in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Aug 10, 11:11 AM

in-portal
View Options

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

	Index: trunk/kernel/units/categories/categories_event_handler.php
	===================================================================
	--- trunk/kernel/units/categories/categories_event_handler.php (revision 3030)
	+++ trunk/kernel/units/categories/categories_event_handler.php (revision 3031)
	@@ -1,226 +1,224 @@
	<?php

	class CategoriesEventHandler extends InpDBEventHandler {

	/**
	* Goes one level up from current category
	*
	* @param kEvent $event
	*/
	function OnCategoryUp(&$event)
	{
	$category_table = $this->Application->getUnitOption($event->Prefix,'TableName');
	$current_cat = $this->Application->GetVar('m_cat_id');

	if($current_cat)
	{
	$sql = 'SELECT ParentId FROM '.$category_table.' WHERE CategoryId = '.$current_cat;
	$cat_to_go = $this->Conn->GetOne($sql);
	}
	else
	{
	$cat_to_go = 0;
	}

	$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}

	/**
	* Goes to home category
	*
	* @param kEvent $event
	*/
	function OnGoHome(&$event)
	{
	$cat_to_go = 0;
	$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}

	/**
	* 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');
	}
	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('parent_filter', 'ParentId = '.$parent_cat_id);

	$view_perm = 1;
	$object->addFilter('perm_filter', 'PermId = '.$view_perm);
	- if (!defined('ADMIN')) {
	+ if ( !$this->Application->IsAdmin() )
	+ {
	$groups = explode(',',$this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', acl) \|\| ((NOT FIND_IN_SET('.$group.',dacl)) AND acl=\'\')';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	- }
	-
	- if (!defined('ADMIN')) {
	$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 (defined('ADMIN')) return parent::getPassedID($event);
	+ if ( $this->Application->IsAdmin() ) return parent::getPassedID($event);

	$ret = $this->Application->GetVar('m_cat_id');
	if($ret) return $ret;

	return parent::getPassedID($event);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/categories/categories_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.6
	\ No newline at end of property
	+1.7
	\ No newline at end of property
	Index: trunk/kernel/units/users/users_event_handler.php
	===================================================================
	--- trunk/kernel/units/users/users_event_handler.php (revision 3030)
	+++ trunk/kernel/units/users/users_event_handler.php (revision 3031)
	@@ -1,796 +1,796 @@
	<?php

	class UsersEventHandler extends InpDBEventHandler
	{

	function OnSessionExpire()
	{
	if( $this->Application->IsAdmin() )
	{
	$location = $this->Application->BaseURL().ADMIN_DIR.'/index.php?expired=1';
	header('Location: '.$location);
	exit;
	}
	else
	{
	$http_query =& $this->Application->recallObject('HTTPQuery');
	if( isset($http_query->Get[ENV_VAR_NAME]) ) unset($http_query->Get[ENV_VAR_NAME]);
	$t = $this->Application->GetVar('t');
	$this->Application->Redirect($t ? $t : 'index', $http_query->Get);
	}
	}

	/**
	* Checks user data and logs it in if allowed
	*
	* @param kEvent $event
	*/
	function OnLogin(&$event)
	{
	$this->Application->setUnitOption($event->Prefix, 'AutoLoad', false);
	$object =& $this->Application->recallObject('u');

	$password = $this->Application->GetVar('password');
	if(!$password)
	{
	$object->SetError('ValidateLogin', 'blank_password', 'lu_blank_password');
	$event->status = erFAIL;
	return false;
	}

	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	list($login_field, $submit_field) = $email_as_login ? Array('Email', 'email') : Array('Login', 'login');
	$login_value = $this->Application->GetVar($submit_field);

	/*$sql = 'SELECT PortalUserId FROM '.$object->TableName.' WHERE (%s = %s) AND (Password = MD5(%s))';
	$user_id = $this->Conn->GetOne( sprintf($sql, $login_field, $this->Conn->qstr($login_value), $this->Conn->qstr($password) ) );*/

	$sql = 'SELECT PortalUserId FROM '.$object->TableName.' WHERE (Email = %1$s OR Login = %1$s) AND (Password = MD5(%2$s))';
	$user_id = $this->Conn->GetOne( sprintf($sql, $this->Conn->qstr($login_value), $this->Conn->qstr($password) ) );

	if($user_id)
	{
	$object->Load($user_id);
	if( $object->GetDBField('Status') == STATUS_ACTIVE )
	{
	$groups = $object->getMembershipGroups(true);
	if(!$groups) $groups = Array();
	- if (!defined('ADMIN')) array_push($groups, $this->Application->ConfigValue('User_LoggedInGroup') );
	+ if ( !$this->Application->IsAdmin() ) array_push($groups, $this->Application->ConfigValue('User_LoggedInGroup') );
	$this->Application->StoreVar( 'UserGroups', implode(',', $groups) );

	if( $this->Application->CheckPermission('LOGIN',0) )
	{
	$session =& $this->Application->recallObject('Session');
	$session->SetField('PortalUserId', $user_id);
	$session->SetField('GroupList', implode(',', $groups) );
	$this->Application->SetVar('u_id', $user_id);
	$this->Application->StoreVar('user_id', $user_id);
	$this->Application->setVisitField('PortalUserId', $user_id);
	}
	else
	{
	$object->Load(-2);
	$object->SetError('ValidateLogin', 'no_permission', 'lu_no_permissions');
	$event->status = erFAIL;
	}

	$next_template = $this->Application->GetVar('next_template');
	if($next_template) $event->redirect = $next_template;
	}
	else
	{
	$event->redirect = $this->Application->GetVar('pending_disabled_template');
	}
	}
	else
	{
	$object->SetError('ValidateLogin', 'invalid_password', 'lu_invalid_password');
	$event->status = erFAIL;
	}
	}

	/**
	* Called when user logs in using old in-portal
	*
	* @param kEvent $event
	*/
	function OnInpLogin(&$event)
	{

	}

	function OnLogout(&$event)
	{
	$session =& $this->Application->recallObject('Session');
	$session->SetField('PortalUserId', -2);
	$this->Application->SetVar('u_id', -2);
	$this->Application->StoreVar('user_id', -2);
	$object =& $this->Application->recallObject('u');
	$object->Load(-2);

	$this->Application->DestroySession();

	$group_list = $this->Application->ConfigValue('User_GuestGroup').','.$this->Application->ConfigValue('User_LoggedInGroup');
	$session->SetField('GroupList', $group_list);
	$this->Application->StoreVar('UserGroups', $group_list);
	}

	/**
	* Prefill states dropdown with correct values
	*
	* @param kEvent $event
	* @access public
	*/
	function OnPrepareStates(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->PopulateStates($event, 'State', 'Country');

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

	if( $object->isRequired('Country') && $cs_helper->CountryHasStates( $object->GetDBField('Country') ) ) $object->setRequired('State', true);
	$object->setLogin();
	}

	/**
	* Redirects user after succesfull registration to confirmation template (on Front only)
	*
	* @param kEvent $event
	*/
	function OnAfterItemCreate(&$event)
	{
	$is_subscriber = $this->Application->GetVar('IsSubscriber');
	if(!$is_subscriber)
	{
	$object =& $event->getObject();

	$sql = 'UPDATE '.TABLE_PREFIX.'UserGroup
	SET PrimaryGroup = 0
	WHERE PortalUserId = '.$object->GetDBField('PortalUserId');
	$this->Conn->Query($sql);

	$group_id = $this->Application->ConfigValue('User_NewGroup');

	$sql = 'REPLACE INTO '.TABLE_PREFIX.'UserGroup(PortalUserId,GroupId,PrimaryGroup) VALUES (%s,%s,1)';
	$this->Conn->Query( sprintf($sql, $object->GetID(), $group_id) );
	}
	}

	/**
	* Login user if possible, if not then redirect to corresponding template
	*
	* @param kEvent $event
	*/
	function autoLoginUser(&$event)
	{
	$object =& $event->getObject();
	$this->Application->SetVar('u_id', $object->GetID() );

	if($object->GetDBField('Status') == STATUS_ACTIVE)
	{
	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	list($login_field, $submit_field) = $email_as_login ? Array('Email', 'email') : Array('Login', 'login');

	$this->Application->SetVar($submit_field, $object->GetDBField($login_field) );
	$this->Application->SetVar('password', $object->GetDBField('Password_plain') );

	$event->CallSubEvent('OnLogin');
	}
	}


	/**
	* When creating user & user with such email exists then force to use OnUpdate insted of OnCreate
	*
	* @param kEvent $event
	*/
	function OnSubstituteSubscriber(&$event)
	{
	$ret = false;
	$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);
	$user_email = $field_values['Email'];
	if($user_email)
	{
	// check if is subscriber
	$verify_user =& $this->Application->recallObject('u.verify', null, Array('skup_autoload' => true) );
	$verify_user->Load($user_email, 'Email');
	if( $verify_user->isLoaded() && $verify_user->isSubscriberOnly() )
	{
	$items_info = Array( $verify_user->GetDBField('PortalUserId') => $field_values );
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);
	$ret = true;
	}
	}
	}

	if( isset($event->MasterEvent) )
	{
	$event->MasterEvent->setEventParam('is_subscriber_only', $ret);
	}
	else
	{
	$event->setEventParam('is_subscriber_only', $ret);
	}
	}


	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return bool
	*/
	function isSubscriberOnly(&$event)
	{
	$event->CallSubEvent('OnSubstituteSubscriber');
	$is_subscriber = false;
	if( $event->getEventParam('is_subscriber_only') )
	{
	$is_subscriber = true;
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$this->OnUpdate($event);
	if($event->status == erSUCCESS)
	{
	$this->OnAfterItemCreate($event);
	$object->SendEmailEvents();
	if( !$this->Application->IsAdmin() && ($event->status == erSUCCESS) && $event->redirect) $this->autoLoginUser($event);
	}
	}
	return $is_subscriber;
	}

	/**
	* Creates new user
	*
	* @param kEvent $event
	*/
	function OnCreate(&$event)
	{
	if( !$this->Application->IsAdmin() ) $this->setUserStatus($event);

	if( !$this->isSubscriberOnly($event) )
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnCreate($event);

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

	$this->Application->SetVar('u_id', $object->getID() );
	$this->Application->setUnitOption('u', 'AutoLoad', true);

	$this->setNextTemplate($event);

	if( !$this->Application->IsAdmin() && ($event->status == erSUCCESS) && $event->redirect)
	{
	$object->SendEmailEvents();
	$this->autoLoginUser($event);
	}
	}
	}

	/**
	* Set's new user status based on config options
	*
	* @param kEvent $event
	*/
	function setUserStatus(&$event)
	{
	$this->Application->setUnitOption($event->Prefix,'AutoLoad',false);
	$object =& $event->getObject();

	$new_users_allowed = $this->Application->ConfigValue('User_Allow_New');
	// 1 - Instant, 2 - Not Allowed, 3 - Pending

	switch ($new_users_allowed)
	{
	case 1: // Instant
	$object->SetDBField('Status', 1);
	$next_template = $this->Application->GetVar('registration_confirm_template');
	if($next_template) $event->redirect = $next_template;
	break;

	case 3: // Pending
	$next_template = $this->Application->GetVar('registration_confirm_pending_template');
	if($next_template) $event->redirect = $next_template;
	$object->SetDBField('Status', 2);
	break;

	case 2: // Not Allowed
	$object->SetDBField('Status', 0);
	break;
	}
	}




	/**
	* Set's new unique resource id to user
	*
	* @param kEvent $event
	*/
	function OnBeforeItemCreate(&$event)
	{
	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	$object =& $event->getObject();
	if ($email_as_login) {
	$object->Fields['Email']['error_msgs']['unique'] = $this->Application->Phrase('lu_user_and_email_already_exist');
	}

	}

	/**
	* Set's new unique resource id to user
	*
	* @param kEvent $event
	*/
	function OnAfterItemValidate(&$event)
	{
	$object =& $event->getObject();
	$object->SetDBField('ResourceId', $this->Application->NextResourceId() );
	}


	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnRecommend(&$event){

	$friend_email = $this->Application->GetVar('friend_email');
	$friend_name = $this->Application->GetVar('friend_email');

	if (preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $friend_email))
	{

	$send_params = array();
	$send_params['to_email']=$friend_email;
	$send_params['to_name']=$friend_name;

	$user_id = $this->Application->GetVar('u_id');
	$email_event = &$this->Application->EmailEventUser('SITE.SUGGEST', $user_id, $send_params);

	if ($email_event->status == erSUCCESS){
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = $this->Application->GetVar('template_success');
	}
	else {
	// $event->redirect_params = array('opener' => 's', 'pass' => 'all');
	// $event->redirect = $this->Application->GetVar('template_fail');
	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['send_error'] = $this->Application->Phrase('lu_email_send_error');
	$object->FieldErrors['Email']['pseudo'] = 'send_error';
	$event->status = erFAIL;

	}
	}
	else {
	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['invalid_email'] = $this->Application->Phrase('lu_InvalidEmail');
	$object->FieldErrors['Email']['pseudo'] = 'invalid_email';
	$event->status = erFAIL;
	}


	}

	/**
	* Saves address changes and mades no redirect
	*
	* @param kEvent $event
	*/
	function OnUpdateAddress(&$event)
	{
	$this->Application->setUnitOption($event->Prefix,'AutoLoad',false);
	$object =& $event->getObject();

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

	$event->redirect = false;
	}

	function OnSubscribeQuery(&$event){

	$user_email = $this->Application->GetVar('subscriber_email');
	if ( preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $user_email) ){

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

	$this->Application->StoreVar('SubscriberEmail', $user_email);

	if( $object->Load(array('Email'=>$user_email)) ){
	$group_info = $this->GetGroupInfo($object->GetID());
	if($group_info){
	$event->redirect = $this->Application->GetVar('unsubscribe_template');
	}
	else {
	$event->redirect = $this->Application->GetVar('subscribe_template');
	}
	}
	else {
	$event->redirect = $this->Application->GetVar('subscribe_template');
	$this->Application->StoreVar('SubscriberEmail', $user_email);
	}

	}
	else {

	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['invalid_email'] = $this->Application->Phrase('lu_InvalidEmail');
	$object->FieldErrors['SubscribeEmail']['pseudo'] = 'invalid_email';
	$event->status = erFAIL;

	}


	//subscribe_query_ok_template
	}

	function OnSubscribeUser(&$event){

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

	$user_email = $this->Application->RecallVar('SubscriberEmail');

	if (preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $user_email)){

	if($object->Load(array('Email'=>$user_email))){

	$group_info = $this->GetGroupInfo($object->GetID());

	if ($group_info){
	if ($event->getEventParam('no_unsubscribe')) return;

	if ($group_info['PrimaryGroup']){
	// delete user
	$object->Delete();
	}
	else {
	$this->RemoveSubscriberGroup($object->GetID());
	}

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

	}
	else {
	$this->AddSubscriberGroup($object->GetID(), 0);
	$event->redirect = $this->Application->GetVar('subscribe_ok_template');
	}


	}
	else {

	$object->SetField('Email', $user_email);
	$object->SetField('Login', $user_email);
	$object->SetDBField('dob', 1);
	$object->SetDBField('dob_date', 1);
	$object->SetDBField('dob_time', 1);
	$ip = getenv('HTTP_X_FORWARDED_FOR')?getenv('HTTP_X_FORWARDED_FOR'):getenv('REMOTE_ADDR');
	$object->SetDBField('ip', $ip);

	$this->Application->SetVar('IsSubscriber', 1);

	if ($object->Create()) {

	$this->AddSubscriberGroup($object->GetID(), 1);
	$event->redirect = $this->Application->GetVar('subscribe_ok_template');
	}

	$this->Application->SetVar('IsSubscriber', 0);
	}
	}
	else {
	// error handling here
	$event->redirect = $this->Application->GetVar('subscribe_fail_template');
	}


	}

	function AddSubscriberGroup($user_id, $is_primary){

	$group_id = $this->Application->ConfigValue('User_SubscriberGroup');
	$sql = 'INSERT INTO '.TABLE_PREFIX.'UserGroup(PortalUserId,GroupId,PrimaryGroup) VALUES (%s,%s,'.$is_primary.')';
	$this->Conn->Query( sprintf($sql, $user_id, $group_id) );
	$this->Application->EmailEventAdmin('USER.SUBSCRIBE', $user_id);
	$this->Application->EmailEventUser('USER.SUBSCRIBE', $user_id);

	}

	function RemoveSubscriberGroup($user_id){

	$group_id = $this->Application->ConfigValue('User_SubscriberGroup');
	$sql = 'DELETE FROM '.TABLE_PREFIX.'UserGroup WHERE PortalUserId='.$user_id.' AND GroupId='.$this->Application->ConfigValue('User_SubscriberGroup');
	$this->Conn->Query($sql);
	$this->Application->EmailEventAdmin('USER.UNSUBSCRIBE', $user_id);
	$this->Application->EmailEventUser('USER.UNSUBSCRIBE', $user_id);

	}

	function GetGroupInfo($user_id){

	$group_info = $this->Conn->GetRow('SELECT * FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_id.'
	AND GroupId='.$this->Application->ConfigValue('User_SubscriberGroup'));
	return $group_info;

	}

	function OnForgotPassword(&$event){

	$this->Application->setUnitOption('u', 'AutoLoad', false);
	$user_object = &$this->Application->recallObject('u.forgot');
	$user_current_object = &$this->Application->recallObject('u');

	$username = $this->Application->GetVar('username');
	$email = $this->Application->GetVar('email');
	$found = false;
	$allow_reset = true;

	if( strlen($username) )
	{
	if( $user_object->Load(array('Login'=>$username)) )
	$found = ($user_object->GetDBField("Login")==$username && $user_object->GetDBField("Status")==1) && strlen($user_object->GetDBField("Password"));
	}
	else if( strlen($email) )
	{
	if( $user_object->Load(array('Email'=>$email)) )
	$found = ($user_object->GetDBField("Email")==$email && $user_object->GetDBField("Status")==1) && strlen($user_object->GetDBField("Password"));
	}

	if( $user_object->isLoaded() )
	{
	$PwResetConfirm = $user_object->GetDBField('PwResetConfirm');
	$PwRequestTime = $user_object->GetDBField('PwRequestTime');
	$PassResetTime = $user_object->GetDBField('PassResetTime');
	//$MinPwResetDelay = $user_object->GetDBField('MinPwResetDelay');
	$MinPwResetDelay = $this->Application->ConfigValue('Users_AllowReset');

	$allow_reset = (strlen($PwResetConfirm) ?
	mktime() > $PwRequestTime + $MinPwResetDelay :
	mktime() > $PassResetTime + $MinPwResetDelay);
	}

	if($found && $allow_reset)
	{
	$this->Application->StoreVar('tmp_user_id', $user_object->GetDBField("PortalUserId"));
	$this->Application->StoreVar('tmp_email', $user_object->GetDBField("Email"));

	//$this->Application->EmailEventUser('INCOMMERCEUSER.PSWDC', $user_object->GetDBField("PortalUserId"));

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

	}
	else
	{
	if(!strlen($username) && !strlen($email))
	{
	$user_current_object->ErrorMsgs['forgotpw_nodata'] = $this->Application->Phrase('lu_ferror_forgotpw_nodata');
	$user_current_object->FieldErrors['Login']['pseudo'] = 'lu_ferror_forgotpw_nodata';
	}
	else
	{

	if($allow_reset)
	{
	if( strlen($username) ){
	$user_current_object->ErrorMsgs['unknown_username'] = $this->Application->Phrase('lu_ferror_unknown_username');
	$user_current_object->FieldErrors['Login']['pseudo']='unknown_username';
	}
	if( strlen($email) ){
	$user_current_object->ErrorMsgs['unknown_email'] = $this->Application->Phrase('lu_ferror_unknown_email');
	$user_current_object->FieldErrors['Email']['pseudo']='unknown_email';
	}
	}
	else
	{
	$user_current_object->ErrorMsgs['reset_denied'] = $this->Application->Phrase('lu_ferror_reset_denied');
	if( strlen($username) ){
	$user_current_object->FieldErrors['Login']['pseudo']='reset_denied';
	}
	if( strlen($email) ){
	$user_current_object->FieldErrors['Email']['pseudo']='reset_denied';
	}
	}

	}

	if($user_current_object->FieldErrors){
	$event->redirect = false;
	}
	}

	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnResetPassword(&$event){

	$user_object = &$this->Application->recallObject('u.forgot');

	if($user_object->Load($this->Application->RecallVar('tmp_user_id'))){

	$this->Application->EmailEventUser('INCOMMERCEUSER.PSWDC', $user_object->GetDBField("PortalUserId"));
	$event->redirect = $this->Application->GetVar('template_success');

	$mod_object =& $this->Application->recallObject('mod.'.'In-Commerce');
	$m_cat_id = $mod_object->GetDBField('RootCat');
	$event->SetRedirectParam('pass', 'm');
	//$event->SetRedirectParam('m_cat_id', $m_cat_id);
	$this->Application->SetVar('m_cat_id', $m_cat_id);


	}

	}

	function OnResetPasswordConfirmed(&$event){

	$passed_key = $this->Application->GetVar('user_key');

	$user_object = &$this->Application->recallObject('u.forgot');
	$user_current_object = &$this->Application->recallObject('u');

	if (strlen(trim($passed_key)) == 0) {
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = false;

	$user_current_object->ErrorMsgs['code_is_not_valid'] = $this->Application->Phrase('lu_code_is_not_valid');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_is_not_valid';
	}


	if($user_object->Load(array('PwResetConfirm'=>$passed_key)))
	{
	$exp_time = $user_object->GetDBField('PwRequestTime') + 3600;
	$user_object->SetDBField("PwResetConfirm", '');
	$user_object->SetDBField("PwRequestTime", 0);
	if ($exp_time > mktime())
	{
	//$m_var_list_update['codevalidationresult'] = 'lu_resetpw_confirm_text';
	$newpw = makepassword4();

	$this->Application->StoreVar('password', $newpw);

	$user_object->SetDBField("Password",$newpw);
	$user_object->SetDBField("PassResetTime", time());
	$user_object->SetDBField("PwResetConfirm", '');
	$user_object->SetDBField("PwRequestTime", 0);
	$user_object->Update();

	$this->Application->SetVar('ForgottenPassword', $newpw);

	$email_event_user = &$this->Application->EmailEventUser('INCOMMERCEUSER.PSWD', $user_object->GetDBField('PortalUserId'));
	$email_event_admin = &$this->Application->EmailEventAdmin('INCOMMERCEUSER.PSWD');

	$this->Application->DeleteVar('ForgottenPassword');

	if ($email_event_user->status == erSUCCESS){
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = $this->Application->GetVar('template_success');
	}

	$user_object->SetDBField("Password",md5($newpw));
	$user_object->Update();

	} else {
	$user_current_object->ErrorMsgs['code_expired'] = $this->Application->Phrase('lu_code_expired');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_expired';
	$event->redirect = false;

	}
	} else {
	$user_current_object->ErrorMsgs['code_is_not_valid'] = $this->Application->Phrase('lu_code_is_not_valid');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_is_not_valid';
	$event->redirect = false;

	}
	}

	function OnUpdate(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnUpdate($event);

	$this->setNextTemplate($event);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function setNextTemplate(&$event)
	{
	if( !$this->Application->IsAdmin() )
	{
	$event->redirect_params['opener'] = 's';
	$object =& $event->getObject();
	if($object->GetDBField('Status') == STATUS_ACTIVE)
	{
	$next_template = $this->Application->GetVar('next_template');
	if($next_template) $event->redirect = $next_template;
	}
	}
	}

	function OnCheckExpiredMembership(&$event)
	{
	$sql = 'SELECT PortalUserId FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
	$user_ids = $this->Conn->GetCol($sql);
	if(is_array($user_ids) && count($user_ids) > 0)
	{
	foreach($user_ids as $id)
	{
	$email_event_user =& $this->Application->EmailEventUser('USER.MEMBERSHIP.EXPIRED', $id);
	$email_event_admin =& $this->Application->EmailEventAdmin('USER.MEMBERSHIP.EXPIRED');
	}
	}
	$sql = 'DELETE FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
	$this->Conn->Query($sql);

	$pre_expiration = mktime() + $this->Application->ConfigValue('User_MembershipExpirationReminder') * 3600 * 24;
	$sql = 'SELECT PortalUserId, GroupId FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.$pre_expiration.'
	AND ExpirationReminderSent = 0';
	$res = $this->Conn->Query($sql);
	if(is_array($res) && count($res) > 0)
	{
	$conditions = Array();
	foreach($res as $record)
	{
	$email_event_user =& $this->Application->EmailEventUser('USER.MEMBERSHIP.EXPIRATION_NOTICE', $record['PortalUserId']);
	$email_event_admin =& $this->Application->EmailEventAdmin('USER.MEMBERSHIP.EXPIRATION_NOTICE');
	$conditions[] = '(PortalUserId = '.$record['PortalUserId'].' AND GroupId = '.$record['GroupId'].')';
	}
	$sql = 'UPDATE '.TABLE_PREFIX.'UserGroup
	SET ExpirationReminderSent = 1
	WHERE '.implode(' OR ', $conditions);
	$this->Conn->Query($sql);
	}
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnRefreshForm(&$event)
	{
	$event->redirect = false;
	$item_info = $this->Application->GetVar($event->Prefix_Special);
	list($id, $fields) = each($item_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->setID($id);
	$object->IgnoreValidation = true;
	$object->SetFieldsFromHash($fields);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/users/users_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.35
	\ No newline at end of property
	+1.36
	\ No newline at end of property
	Index: trunk/kernel/units/email_events/email_events_event_handler.php
	===================================================================
	--- trunk/kernel/units/email_events/email_events_event_handler.php (revision 3030)
	+++ trunk/kernel/units/email_events/email_events_event_handler.php (revision 3031)
	@@ -1,213 +1,218 @@
	<?php

	class EmailEventsEventsHandler extends InpDBEventHandler
	{

	/**
	* 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();
	$this->Application->LinkVar('module', 'current_module');
	$module = $this->Application->GetVar('module');
	$object->addFilter('module_filter', '%1$s.Module = \''.$module.'\'');
	}
	}

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

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

	/**
	* Sets selected user to email events selected
	*
	* @param kEvent $event
	*/
	function OnSelectUser(&$event)
	{
	$user_name = $this->Application->GetVar( $event->getPrefixSpecial(true).'_PopupSelectedUser' );
	if( strlen($user_name) > 0 )
	{
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$ids = implode(',', $ids);

	$user_id = $this->Conn->GetOne('SELECT PortalUserId FROM '.TABLE_PREFIX.'PortalUser WHERE Login = '.$this->Conn->qstr($user_name) );

	$table = $this->Application->getUnitOption($event->Prefix,'TableName');
	$sql = 'UPDATE '.$table.' SET FromUserId = '.$user_id.' WHERE EventId IN ('.$ids.')';

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

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

	$this->Application->setUnitOption('emailmessages', 'AutoLoad', false);
	$message_object = &$this->Application->recallObject('emailmessages');

	$event_table = $this->Application->getUnitOption('emailevents', 'TableName');

	$event_object = &$event->getObject();
	$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 && defined("ADMIN")) return; // event only for front-end
	+ 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');
	$message_template = $message_object->GetDBField('Template');

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

	$old_autoload = $this->Application->getUnitOption('u', 'AutoLoad');
	$this->Application->setUnitOption('u', 'AutoLoad', false);

	$from_user_object = &$this->Application->recallObject('u.-item');
	$from_user_object->Load($from_user_id);
	// here if we don't have from_user loaded, it takes a default user from config values
	$from_user_email = $from_user_object->GetDBField('Email')?$from_user_object->GetDBField('Email'):$this->Application->ConfigValue('Smtp_AdminMailFrom');
	$from_user_name = trim($from_user_object->GetDBField('FirstName').' '.$from_user_object->GetDBField('LastName'));

	$to_user_object = &$this->Application->recallObject('u.-item');
	$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'));

	$this->Application->setUnitOption('u', 'AutoLoad', $old_autoload);

	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', '<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_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 = $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);
	}

	return $event;
	}
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/email_events/email_events_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.11
	\ No newline at end of property
	+1.12
	\ No newline at end of property
	Index: trunk/kernel/units/general/inp_ses_storage.php
	===================================================================
	--- trunk/kernel/units/general/inp_ses_storage.php (revision 3030)
	+++ trunk/kernel/units/general/inp_ses_storage.php (revision 3031)
	@@ -1,104 +1,105 @@
	<?php

	class InpSession extends Session
	{
	function Init($prefix,$special)
	{
	$this->SessionTimeout = $this->Application->ConfigValue('SessionTimeout');
	- if (BASE_PATH == '') {
	- $path = '/';
	- }
	- else {
	- $path = BASE_PATH;
	+
	+ $path = (BASE_PATH == '') ? '/' : BASE_PATH;
	+ if ( $this->Application->IsAdmin() ) $path = rtrim($path, '/').'/admin';
	+ $this->SetCookiePath($path);
	+
	+ $this->SetCookieName( $this->Application->ConfigValue('SessionCookieName') );
	+ $this->SetCookieDomain(SERVER_NAME);
	+
	+ if( $this->Application->IsAdmin() )
	+ {
	+ $mode = smAUTO;
	}
	- if ( defined('ADMIN') && ADMIN )
	+ else
	{
	- $path = rtrim($path, '/');
	- $path .= '/admin';
	+ $ses_mode = $this->Application->ConfigValue('CookieSessions');
	+ if ($ses_mode == 2) $mode = smAUTO;
	+ if ($ses_mode == 1) $mode = smCOOKIES_ONLY;
	+ if ($ses_mode == 0) $mode = smGET_ONLY;
	}
	- $this->SetCookiePath( $path );
	- $ses_mode = $this->Application->ConfigValue('CookieSessions');
	- if ($ses_mode == 2) $mode = smAUTO;
	- if ($ses_mode == 1) $mode = smCOOKIES_ONLY;
	- if ($ses_mode == 0) $mode = smGET_ONLY;
	- if ( defined('ADMIN') && ADMIN ) $mode = smAUTO;
	$this->SetMode($mode);
	- $this->SetCookieName( $this->Application->ConfigValue('SessionCookieName') );
	- $this->SetCookieDomain(SERVER_NAME);
	+
	parent::Init($prefix,$special);

	if( !$this->Application->IsAdmin() && $this->GetField('PortalUserId') <= 0 )
	{
	$group_list = $this->Application->ConfigValue('User_GuestGroup').','.$this->Application->ConfigValue('User_LoggedInGroup');
	$this->SetField('GroupList', $group_list);
	}
	}
	}

	class InpSessionStorage extends SessionStorage {

	function Init($prefix,$special)
	{
	parent::Init($prefix,$special);
	$this->setTableName(TABLE_PREFIX.'UserSession');
	$this->SessionDataTable = TABLE_PREFIX.'SessionData';
	$this->setIDField('SessionKey');
	$this->TimestampField = 'LastAccessed';
	$this->DataValueField = 'VariableValue';
	$this->DataVarField = 'VariableName';
	}

	function LocateSession($sid)
	{
	$query = ' SELECT '.$this->TimestampField.' FROM '.$this->TableName.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($sid);
	$result = $this->Conn->GetOne($query);

	if($result===false) return false;

	$this->Expiration = $result + $this->SessionTimeout;
	return true;
	}

	function UpdateSession(&$session)
	{
	$query = ' UPDATE '.$this->TableName.' SET '.$this->TimestampField.' = unix_timestamp() WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);
	$this->Conn->Query($query);
	}


	function StoreSession(&$session)
	{
	parent::StoreSession($session);
	$this->SetField($session, 'IpAddress', $_SERVER['REMOTE_ADDR']);
	$this->SetField($session, 'GroupList', $this->Application->ConfigValue('User_GuestGroup'));
	}

	function GetExpiredSIDs()
	{
	$query = ' SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE '.time().' - '.$this->TimestampField.' > '.$this->SessionTimeout;
	$ret = $this->Conn->GetCol($query);
	if($ret) $this->DeleteEditTables();
	return $ret;

	}

	function DeleteEditTables()
	{
	$tables = $this->Conn->GetCol('SHOW TABLES');
	$mask_edit_table = '/'.TABLE_PREFIX.'ses_(.)_edit_(.)/';
	$mask_search_table = '/'.TABLE_PREFIX.'ses_(.)_(.)/';

	$sql='SELECT COUNT(*) FROM '.$this->TableName.' WHERE '.$this->IDField.' = \'%s\'';
	foreach($tables as $table)
	{
	if( preg_match($mask_edit_table,$table,$rets) \|\| preg_match($mask_search_table,$table,$rets) )
	{
	$sid=$rets[1];
	$is_alive = $this->Conn->GetOne( sprintf($sql,$sid) );
	if(!$is_alive) $this->Conn->Query('DROP TABLE IF EXISTS '.$table);
	}
	}
	}
	}

	?>
	\ No newline at end of file

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

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

	class kCatDBEventHandler extends InpDBEventHandler {

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

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

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

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

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

	//recalling by different name, because we may get kDBList, if we recall just by prefix
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'.item', $event->Prefix);
	$this->prepareObject($object, $event);

	if ($this->Application->RecallVar($event->getPrefixSpecial().'_clipboard_mode') == 'copy') {
	$ids_arr = explode(',', $ids);

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

	if($ids_arr)
	{
	$temp->CloneItems($event->Prefix, $event->Special, $ids_arr);
	}
	}
	else { // mode == cut
	$ids_arr = explode(',', $ids);
	foreach ($ids_arr as $id) {
	$object->Load($id);
	$object->MoveToCat();
	}
	}
	$event->status = erSUCCESS;
	}

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

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

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


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

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

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

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndOpenTranslator(&$event)
	{
	$this->Application->SetVar('allow_translation', true);
	$object =& $event->getObject();
	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');
	if ($event->status == erSUCCESS) {
	// $url = $this->Application->HREF($t, '', Array('pass'=>'all', $event->getPrefixSpecial(true).'_id' => $object->GetId()));
	// $field = $this->Application->GetVar('translator_field');
	$cf_id = $this->Application->GetVar('translator_cf_id');
	if($cf_id)
	{
	$cv =& $this->Application->recallObject('cv.-item', null, Array('skip_autoload' => true) );
	$load_params = Array('CustomFieldId' => $cf_id, 'ResourceId'=> $object->GetDBField('ResourceId') );
	if( !$cv->Load($load_params) )
	{
	$cv->SetFieldsFromHash($load_params);
	$cv->Create();
	}
	$this->Application->SetVar('cv_id', $cv->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'),
	);

	// 1. SAVE LAST TEMPLATE TO SESSION
	$last_template = $this->Application->RecallVar('last_template');
	preg_match('/index4\.php\\|'.$this->Application->GetSID().'-(.*):/U', $last_template, $rets);
	$this->Application->StoreVar('return_template', $rets[1]);

	//$after_script = "openTranslator('".$event->getPrefixSpecial()."', '".$field."', '".$url."', '".$wnd_name."')";
	}

	// $this->Application->SetVar('after_script', $after_script);
	// $event->redirect = false;
	}

	/**
	* Apply scope clause
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();

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

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

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

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

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function PrepareObject(&$object, &$event)
	{

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

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

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

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

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

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

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

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

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

	/**
	* 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->GetVar('sid').'_'.TABLE_PREFIX.'Search';

	$keywords = trim($this->Application->GetVar('keywords'));
	if( !$this->Application->GetVar('INPORTAL_ON') )
	{
	$keywords = unhtmlentities($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);

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

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

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

	$join_clauses = Array();

	// field processing
	$weight_sum = 0;
	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($options['formatter'] == 'kMultiLanguage')
	{
	$field_list[$key] = 'l'.$lang.'_'.$field;
	}

	// processing fields from other tables
	if($foreign_field = $search_config[$field]['ForeignField'])
	{
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	unset($field_list[$key]);
	continue; // ignoring having type clauses in simple search
	/*$user_object =& $this->Application->recallObject('u');
	$user_groups = $user_object->GetDBField('PortalUserId') ?
	implode(',', $this->Conn->GetCol(' SELECT GroupId
	FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_object->GetDBField('PortalUserId'))) : 0;
	$having_list[$key] = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;
	$join_clauses[] = $join_clause;*/
	}
	else
	{
	$exploded = explode('.', $foreign_field);
	$foreign_table = TABLE_PREFIX.$exploded[0];

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

	$field_list[$key] = $alias.'.'.$exploded[1];
	$join_clause = str_replace('{ForeignTable}', $alias, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $product_table, $join_clause);
	if($search_config[$field]['CustomFieldId'])
	{
	$join_clause .= ' AND '.$alias.'.CustomFieldId='.$search_config[$field]['CustomFieldId'];
	}
	$join_clauses[] = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else
	{
	// processing fields from local table
	$field_list[$key] = $local_table.'.'.$field_list[$key];
	}
	}

	// keyword string processing
	$normal_keywords = Array();
	$plus_keywords = Array();
	$minus_keywords = Array();

	for($i = 0; $i < strlen($keywords); $i++)
	{
	if(substr($keywords, $i, 1) == ' ') continue;
	$extra_skip = 0;
	switch(substr($keywords, $i, 1))
	{
	case '+':
	if(substr($keywords, $i + 1, 1) == '"')
	{
	$keyword_start = $i + 2;
	$keyword_end = strpos($keywords, '"', $i + 2);
	$extra_skip = 2;
	}
	else
	{
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$extra_skip = 0;
	}
	$target_array =& $plus_keywords;
	break;
	case '-':
	if(substr($keywords, $i + 1, 1) == '"')
	{
	$keyword_start = $i + 2;
	$keyword_end = strpos($keywords, '"', $i + 2);
	$extra_skip = 2;
	}
	else
	{
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$extra_skip = 0;
	}
	$target_array =& $minus_keywords;
	break;
	case '"':
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, '"', $i + 1);
	$extra_skip = 1;
	$target_array =& $normal_keywords;
	break;
	default:
	$keyword_start = $i;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$target_array =& $normal_keywords;
	}

	if($keyword_end === false)
	{
	$keyword_end = strlen($keywords);
	}
	$keyword_length = $keyword_end - $keyword_start;
	$keyword = substr($keywords, $keyword_start, $keyword_length);

	if(strlen($keyword) >= $this->Application->ConfigValue('Search_MinKeyword_Length'))
	{
	$target_array[] = addcslashes($keyword, '"');
	}

	$i += $keyword_length + $extra_skip;
	}

	// preparing conditions
	$normal_conditions = Array();
	$plus_conditions = Array();
	$minus_conditions = Array();
	foreach($normal_keywords as $keyword)
	{
	$normal_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $field_list).' LIKE "%'.$keyword.'%"';
	}
	foreach($plus_keywords as $keyword)
	{
	$plus_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $field_list).' LIKE "%'.$keyword.'%"';
	}
	foreach($minus_keywords as $keyword)
	{
	foreach($field_list as $field)
	{
	$condition[] = $field.' NOT LIKE "%'.$keyword.'%" OR '.$field.' IS NULL';
	}
	$minus_conditions[] = '('.implode(') AND (', $condition).')';
	}

	// building where clause
	if($normal_conditions)
	{
	$where_clause = '('.implode(') OR (', $normal_conditions).')';
	}
	else
	{
	$where_clause = '1';
	}
	if($plus_conditions)
	{
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $plus_conditions).')';
	}
	if($minus_conditions)
	{
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $minus_conditions).')';
	}
	$where_clause = $where_clause.' AND '.$product_table.'.Status=1';

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

	// building having clause


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

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

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

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

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

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

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

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

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

	$keywords = $this->Application->GetVar('value');
	$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;
	$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($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 = $user_object->GetDBField('PortalUserId') ?
	implode(',', $this->Conn->GetCol(' SELECT GroupId
	FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_object->GetDBField('PortalUserId'))) : 0;
	$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];

	$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
	$field_name = $local_table.'.'.$field_name;
	}

	$condition = '';
	switch($record['FieldType'])
	{
	case 'text':
	if( !$this->Application->GetVar('INPORTAL_ON') )
	{
	$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 = 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 = 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;
	}
	}
	}
	}

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

	// making relevance clause
	if($relevance_parts)
	{
	$rel_keywords = $this->Application->ConfigValue('SearchRel_DefaultKeyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_DefaultPop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_DefaultRating_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->GetVar('sid').'_'.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);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/units/general/cat_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.10
	\ No newline at end of property
	+1.11
	\ No newline at end of property
	Index: trunk/core/kernel/session/session.php
	===================================================================
	--- trunk/core/kernel/session/session.php (revision 3030)
	+++ trunk/core/kernel/session/session.php (revision 3031)
	@@ -1,702 +1,702 @@
	<?php

	/*

	The session works the following way:

	1. When a visitor loads a page from the site the script checks if cookies_on varibale has been passed to it as a cookie.
	2. If it has been passed, the script tries to get Session ID (SID) from the request:
	3. Depending on session mode the script is getting SID differently.
	The following modes are available:

	smAUTO - Automatic mode: if cookies are on at the client side, the script relays only on cookies and
	ignore all other methods of passing SID.
	If cookies are off at the client side, the script relays on SID passed through query string
	and referal passed by the client. THIS METHOD IS NOT 100% SECURE, as long as attacker may
	get SID and substitude referal to gain access to user' session. One of the faults of this method
	is that the session is only created when the visitor clicks the first link on the site, so
	there is NO session at the first load of the page. (Actually there is a session, but it gets lost
	after the first click because we do not use SID in query string while we are not sure if we need it)

	smCOOKIES_ONLY - Cookies only: in this mode the script relays solely on cookies passed from the browser
	and ignores all other methods. In this mode there is no way to use sessions for clients
	without cookies support or cookies support disabled. The cookies are stored with the
	full domain name and path to base-directory of script installation.

	smGET_ONLY - GET only: the script will not set any cookies and will use only SID passed in
	query string using GET, it will also check referal. The script will set SID at the
	first load of the page

	smCOOKIES_AND_GET - Combined mode: the script will use both cookies and GET right from the start. If client has
	cookies enabled, the script will check SID stored in cookie and passed in query string, and will
	use this SID only if both cookie and query string matches. However if cookies are disabled on the
	client side, the script will work the same way as in GET_ONLY mode.

	4. After the script has the SID it tries to load it from the Storage (default is database)
	5. If such SID is found in the database, the script checks its expiration time. If session is not expired, it updates
	its expiration, and resend the cookie (if applicable to session mode)
	6. Then the script loads all the data (session variables) pertaining to the SID.



	Usage:

	$session =& new Session(smAUTO); //smAUTO is default, you could just leave the brackets empty, or provide another mode

	$session->SetCookieDomain('my.domain.com');
	$session->SetCookiePath('/myscript');
	$session->SetCookieName('my_sid_cookie');
	$session->SetGETName('sid');
	$session->InitSession();

	...

	//link output:

	echo "<a href='index.php?'". ( $session->NeedQueryString() ? 'sid='.$session->SID : '' ) .">My Link</a>";

	*/

	//Implements session storage in the database
	class SessionStorage extends kDBBase {

	var $Expiration;
	var $SessionTimeout=0;

	var $OriginalData=Array();

	var $TimestampField;
	var $SessionDataTable;
	var $DataValueField;
	var $DataVarField;

	function Init($prefix,$special)
	{
	parent::Init($prefix,$special);
	$this->setTableName('sessions');
	$this->setIDField('sid');
	$this->TimestampField = 'expire';
	$this->SessionDataTable = 'SessionData';
	$this->DataValueField = 'value';
	$this->DataVarField = 'var';
	}

	function setSessionTimeout($new_timeout)
	{
	$this->SessionTimeout = $new_timeout;
	}

	function StoreSession(&$session)
	{
	$query = ' INSERT INTO '.$this->TableName.' ('.$this->IDField.', '.$this->TimestampField.')'.
	' VALUES ('.$this->Conn->qstr($session->SID).', '.$session->Expiration.')';
	$this->Conn->Query($query);
	}

	function DeleteSession(&$session)
	{
	$query = ' DELETE FROM '.$this->TableName.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);
	$this->Conn->Query($query);

	$query = ' DELETE FROM '.$this->SessionDataTable.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);
	$this->Conn->Query($query);

	$this->OriginalData = Array();
	}

	function UpdateSession(&$session, $timeout=0)
	{
	$query = ' UPDATE '.$this->TableName.' SET '.$this->TimestampField.' = '.$session->Expiration.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);
	$this->Conn->Query($query);
	}

	function LocateSession($sid)
	{
	$query = ' SELECT '.$this->TimestampField.' FROM '.$this->TableName.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($sid);
	$result = $this->Conn->GetOne($query);

	if($result===false) return false;

	$this->Expiration = $result;
	return true;
	}

	function GetExpiration()
	{
	return $this->Expiration;
	}

	function LoadData(&$session)
	{
	$query = 'SELECT '.$this->DataValueField.','.$this->DataVarField.' FROM '.$this->SessionDataTable.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);

	$this->OriginalData = $this->Conn->GetCol($query, $this->DataVarField);
	return $this->OriginalData;
	}

	/**
	* Enter description here...
	*
	* @param Session $session
	* @param string $var_name
	*/
	function GetField(&$session, $var_name)
	{
	return $this->Conn->GetOne('SELECT '.$var_name.' FROM '.$this->TableName.' WHERE `'.$this->IDField.'` = '.$this->Conn->qstr($session->GetID()) );
	}

	function SetField(&$session, $var_name, $value)
	{
	return $this->Conn->Query('UPDATE '.$this->TableName.' SET '.$var_name.' = '.$this->Conn->qstr($value).' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->GetID()) );
	}

	function SaveData(&$session)
	{
	if(!$session->SID) return false; // can't save without sid

	$ses_data = $session->Data->GetParams();

	$replace = '';
	foreach ($ses_data as $key => $value)
	{
	if ( isset($this->OriginalData[$key]) && $this->OriginalData[$key] == $value)
	{
	continue; //skip unchanged session data
	}
	else
	{
	$replace .= sprintf("(%s, %s, %s),",
	$this->Conn->qstr($session->SID),
	$this->Conn->qstr($key),
	$this->Conn->qstr($value));
	}
	}
	$replace = rtrim($replace, ',');
	if ($replace != '') {
	$query = ' REPLACE INTO '.$this->SessionDataTable. ' ('.$this->IDField.', '.$this->DataVarField.', '.$this->DataValueField.') VALUES '.$replace;
	$this->Conn->Query($query);
	}
	}

	function RemoveFromData(&$session, $var)
	{
	$query = 'DELETE FROM '.$this->SessionDataTable.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID).
	' AND '.$this->DataVarField.' = '.$this->Conn->qstr($var);
	$this->Conn->Query($query);
	unset($this->OriginalData[$var]);
	}

	function GetExpiredSIDs()
	{
	$query = ' SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE '.$this->TimestampField.' > '.time();
	return $this->Conn->GetCol($query);
	}

	function DeleteExpired()
	{
	$expired_sids = $this->GetExpiredSIDs();
	if($expired_sids)
	{
	$where_clause=' WHERE '.$this->IDField.' IN ("'.implode('","',$expired_sids).'")';
	$sql = 'DELETE FROM '.$this->SessionDataTable.$where_clause;
	$this->Conn->Query($sql);

	$sql = 'DELETE FROM '.$this->TableName.$where_clause;
	$this->Conn->Query($sql);
	}
	return $expired_sids;
	}
	}

	define('smAUTO', 1);
	define('smCOOKIES_ONLY', 2);
	define('smGET_ONLY', 3);
	define('smCOOKIES_AND_GET', 4);

	class Session extends kBase {
	var $Checkers;

	var $Mode;
	var $OriginalMode = null;
	var $GETName = 'sid';

	var $CookiesEnabled = true;
	var $CookieName = 'sid';
	var $CookieDomain;
	var $CookiePath;
	var $CookieSecure = 0;

	var $SessionTimeout = 3600;
	var $Expiration;

	var $SID;

	var $Storage;

	var $CachedNeedQueryString = null;

	var $Data;


	function Session($mode=smAUTO)
	{
	parent::kBase();
	$this->SetMode($mode);
	}

	function SetMode($mode)
	{
	$this->Mode = $mode;
	$this->CachedNeedQueryString = null;
	$this->CachedSID = null;
	}

	function SetCookiePath($path)
	{
	$this->CookiePath = $path;
	}

	function SetCookieDomain($domain)
	{
	$this->CookieDomain = '.'.ltrim($domain, '.');
	}

	function SetGETName($get_name)
	{
	$this->GETName = $get_name;
	}

	function SetCookieName($cookie_name)
	{
	$this->CookieName = $cookie_name;
	}

	function InitStorage()
	{
	$this->Storage =& $this->Application->recallObject('SessionStorage');
	$this->Storage->setSessionTimeout($this->SessionTimeout);
	}

	function Init($prefix,$special)
	{
	parent::Init($prefix,$special);

	$this->CheckIfCookiesAreOn();
	if ($this->CookiesEnabled) $_COOKIE['cookies_on'] = 1;

	$this->Checkers = Array();
	$this->InitStorage();
	$this->Data =& new Params();

	$tmp_sid = $this->GetPassedSIDValue();

	if( !(defined('IS_INSTALL') && IS_INSTALL) )
	{
	$expired_sids = $this->DeleteExpired();
	if( ( $expired_sids && in_array($tmp_sid,$expired_sids) ) \|\| ( $tmp_sid && !$this->Check() ) )
	{
	$this->SetSession();
	$this->Application->HandleEvent($event, 'u:OnSessionExpire');
	}
	}

	if ($this->Check()) {
	$this->SID = $this->GetPassedSIDValue();
	$this->Refresh();
	$this->LoadData();
	}
	else {
	$this->SetSession();
	}

	if (!is_null($this->OriginalMode)) $this->SetMode($this->OriginalMode);
	}

	function IsHTTPSRedirect()
	{
	$http_referer = getArrayValue($_SERVER, 'HTTP_REFERER');
	return (
	( PROTOCOL == 'https://' && preg_match('#http:\/\/#', $http_referer) )
	\|\|
	( PROTOCOL == 'http://' && preg_match('#https:\/\/#', $http_referer) )
	);
	}

	function CheckReferer()
	{
	$path = preg_replace("/admin$/", '', $this->CookiePath); // removing /admin for compatability with in-portal (in-link/admin/add_link.php)
	$reg = '#^'.preg_quote(PROTOCOL.ltrim($this->CookieDomain, '.').$path).'#';
	return preg_match($reg, getArrayValue($_SERVER, 'HTTP_REFERER') ) \|\| (defined('IS_POPUP') && IS_POPUP);
	}

	/*function CheckDuplicateCookies()
	{
	if (isset($_SERVER['HTTP_COOKIE'])) {
	$cookie_str = $_SERVER['HTTP_COOKIE'];
	$cookies = explode('; ', $cookie_str);
	$all_cookies = array();
	foreach ($cookies as $cookie) {
	list($name, $value) = explode('=', $cookie);
	if (isset($all_cookies[$name])) {
	//double cookie name!!!
	$this->RemoveCookie($name);
	}
	else $all_cookies[$name] = $value;
	}
	}
	}

	function RemoveCookie($name)
	{
	$path = $_SERVER['PHP_SELF'];
	$path_parts = explode('/', $path);
	$cur_path = '';
	setcookie($name, false, null, $cur_path);
	foreach ($path_parts as $part) {
	$cur_path .= $part;
	setcookie($name, false, null, $cur_path);
	$cur_path .= '/';
	setcookie($name, false, null, $cur_path);
	}
	}*/

	function CheckIfCookiesAreOn()
	{
	// $this->CheckDuplicateCookies();
	- if ($this->Mode == smGET_ONLY \|\| (defined('INPORTAL_ENV')&&INPORTAL_ENV && defined('ADMIN')&&ADMIN && !$this->Application->GetVar('front')) )
	+ if ($this->Mode == smGET_ONLY \|\| (defined('INPORTAL_ENV')&&INPORTAL_ENV && $this->Application->IsAdmin() && !$this->Application->GetVar('front')) )
	{
	//we don't need to bother checking if we would not use it
	$this->CookiesEnabled = false;
	return;
	}
	$http_query =& $this->Application->recallObject('HTTPQuery');
	$cookies_on = isset($http_query->Cookie['cookies_on']); // not good here

	$get_sid = getArrayValue($http_query->Get, $this->GETName);
	if ($this->IsHTTPSRedirect() && $get_sid) { //Redirect from http to https on different domain
	$this->OriginalMode = $this->Mode;
	$this->SetMode(smGET_ONLY);
	}

	if (!$cookies_on \|\| $this->IsHTTPSRedirect()) {
	//If referer is our server, but we don't have our cookies_on, it's definetly off
	if ($this->CheckReferer() && !$this->Application->GetVar('admin') && !$this->IsHTTPSRedirect()) {
	$this->CookiesEnabled = false;
	}
	else {
	//Otherwise we still suppose cookies are on, because may be it's the first time user visits the site
	//So we send cookies on to get it next time (when referal will tell us if they are realy off
	setcookie(
	'cookies_on',
	1,
	time()+31104000, //one year should be enough
	$this->CookiePath,
	$this->CookieDomain,
	$this->CookieSecure
	);
	}
	}
	else
	$this->CookiesEnabled = true;
	return $this->CookiesEnabled;
	}

	function Check()
	{
	// we should check referer if cookies are disabled, and in combined mode
	// auto mode would detect cookies, get only mode would turn it off - so we would get here
	// and we don't care about referal in cookies only mode

	if ( $this->Mode != smCOOKIES_ONLY && (!$this->CookiesEnabled \|\| $this->Mode == smCOOKIES_AND_GET) ) {
	if (!$this->CheckReferer())
	return false;
	}

	$sid = $this->GetPassedSIDValue();

	if (empty($sid)) return false;

	//try to load session by sid, if everything is fine
	$result = $this->LoadSession($sid);

	return $result;
	}

	function LoadSession($sid)
	{
	if( $this->Storage->LocateSession($sid) ) {
	//if we have session with such SID - get its expiration
	$this->Expiration = $this->Storage->GetExpiration();

	//If session has expired
	if ($this->Expiration < time()) return false;

	//Otherwise it's ok
	return true;
	}
	else //fake or deleted due to expiration SID
	return false;
	}

	function GetPassedSIDValue($use_cache = 1)
	{
	if (!empty($this->CachedSID) && $use_cache) return $this->CachedSID;
	$http_query =& $this->Application->recallObject('HTTPQuery');
	$get_sid = getArrayValue($http_query->Get, $this->GETName);

	if ($this->Application->GetVar('admin') == 1 && $get_sid) {
	$sid = $get_sid;
	}
	else {
	switch ($this->Mode) {
	case smAUTO:
	//Cookies has the priority - we ignore everything else
	$sid=$this->CookiesEnabled ? getArrayValue($http_query->Cookie,$this->CookieName) : $get_sid;
	break;
	case smCOOKIES_ONLY:
	$sid = $http_query->Cookie[$this->CookieName];
	break;
	case smGET_ONLY:
	$sid = $get_sid;
	break;
	case smCOOKIES_AND_GET:
	$cookie_sid = $http_query->Cookie[$this->CookieName];
	//both sids should match if cookies are enabled
	if (!$this->CookiesEnabled \|\| ($cookie_sid == $get_sid))
	{
	$sid = $get_sid; //we use get here just in case cookies are disabled
	}
	else
	{
	$sid = '';
	}
	break;
	}
	}

	if ($this->Application->GetVar('front')) {
	$this->CookiesEnabled = false;
	}

	$this->CachedSID = $sid;
	return $this->CachedSID;
	}

	/**
	* Returns session id
	*
	* @return int
	* @access public
	*/
	function GetID()
	{
	return $this->SID;
	}

	/**
	* Generates new session id
	*
	* @return int
	* @access private
	*/
	function GenerateSID()
	{
	list($usec, $sec) = explode(" ",microtime());

	$sid_part_1 = substr($usec, 4, 4);
	$sid_part_2 = mt_rand(1,9);
	$sid_part_3 = substr($sec, 6, 4);
	$digit_one = substr($sid_part_1, 0, 1);
	if ($digit_one == 0) {
	$digit_one = mt_rand(1,9);
	$sid_part_1 = ereg_replace("^0","",$sid_part_1);
	$sid_part_1=$digit_one.$sid_part_1;
	}
	$this->setSID($sid_part_1.$sid_part_2.$sid_part_3);
	return $this->SID;
	}

	/**
	* Set's new session id
	*
	* @param int $new_sid
	* @access private
	*/
	function setSID($new_sid)
	{
	$this->SID=$new_sid;
	$this->Application->SetVar($this->GETName,$new_sid);
	}

	function SetSession()
	{
	$this->GenerateSID();
	$this->Expiration = time() + $this->SessionTimeout;
	switch ($this->Mode) {
	case smAUTO:
	if ($this->CookiesEnabled) {
	$this->SetSessionCookie();
	}
	break;
	case smGET_ONLY:
	break;
	case smCOOKIES_ONLY:
	case smCOOKIES_AND_GET:
	$this->SetSessionCookie();
	break;
	}
	$this->Storage->StoreSession($this);
	$this->Application->HandleEvent( new kEvent('visits:OnRegisterVisit') );
	}

	function SetSessionCookie()
	{
	setcookie(
	$this->CookieName,
	$this->SID,
	$this->Expiration,
	$this->CookiePath,
	$this->CookieDomain,
	$this->CookieSecure
	);

	$_COOKIE[$this->CookieName] = $this->SID; // for compatibility with in-portal
	}

	/**
	* Refreshes session expiration time
	*
	* @access private
	*/
	function Refresh()
	{
	if ($this->CookiesEnabled) $this->SetSessionCookie(); //we need to refresh the cookie
	$this->Storage->UpdateSession($this);
	}

	function Destroy()
	{
	$this->Storage->DeleteSession($this);
	$this->Data =& new Params();
	$this->SID = '';
	if ($this->CookiesEnabled) $this->SetSessionCookie(); //will remove the cookie due to value (sid) is empty
	$this->SetSession(); //will create a new session
	}

	function NeedQueryString($use_cache = 1)
	{
	if ($this->CachedNeedQueryString != null && $use_cache) return $this->CachedNeedQueryString;
	switch ($this->Mode) {
	case smAUTO:
	if ($this->CookiesEnabled) {
	$res = 0;
	}
	else {
	$res = 1;
	}
	break;
	case smCOOKIES_ONLY:
	break;
	case smGET_ONLY:
	case smCOOKIES_AND_GET:
	$res = 1;
	break;
	}
	$this->CachedNeedQueryString = $res;
	return $res;
	}

	function LoadData()
	{
	$this->Data->AddParams($this->Storage->LoadData($this));
	}

	function PrintSession($comment='')
	{
	if( $this->Application->isDebugMode() && dbg_ConstOn('DBG_SHOW_SESSIONDATA') )
	{
	global $debugger;
	$debugger->appendHTML('SessionStorage ('.$comment.'):');
	$session_data = $this->Data->GetParams();
	ksort($session_data);
	foreach($session_data as $session_key => $session_value)
	{
	if( IsSerialized($session_value) )
	{
	$session_data[$session_key] = unserialize($session_value);
	}
	}
	$debugger->dumpVars($session_data);

	// to insert after HTTPQuery if it's visible
	$new_row = dbg_ConstOn('DBG_SHOW_HTTPQUERY') ? 4 : 2;

	//$debugger->moveAfterRow($new_row,2);
	}
	}

	function SaveData()
	{
	if( $this->Application->GetVar('t') != 'help' )
	{
	$last_env = $this->Application->BuildEnv($this->Application->GetVar('t'), Array('m_opener' => 'u'), 'all');
	$last_template = basename($_SERVER['PHP_SELF']).'\|';
	$last_template .= substr($last_env, strlen(ENV_VAR_NAME) + 1);
	$this->StoreVar('last_template', $last_template);
	}
	$this->StoreVar('last_env', substr($this->Application->BuildEnv($this->Application->GetVar('t'),Array('pass'=>'all')), strlen(ENV_VAR_NAME)+1 ));

	$this->PrintSession('after save');
	$this->Storage->SaveData($this);
	}

	function StoreVar($name, $value)
	{
	$this->Data->Set($name, $value);
	}

	function StoreVarDefault($name, $value)
	{
	$tmp = $this->RecallVar($name);
	if($tmp === false \|\| $tmp == '')
	{
	$this->StoreVar($name, $value);
	}
	}

	function RecallVar($name,$default=false)
	{
	$ret = $this->Data->Get($name);
	return ($ret===false) ? $default : $ret;
	}

	function RemoveVar($name)
	{
	$this->Storage->RemoveFromData($this, $name);
	$this->Data->Remove($name);
	}

	function GetField($var_name)
	{
	return $this->Storage->GetField($this, $var_name);
	}

	function SetField($var_name, $value)
	{
	$this->Storage->SetField($this, $var_name, $value);
	}

	/**
	* Deletes expired sessions
	*
	* @return Array expired sids if any
	* @access private
	*/
	function DeleteExpired()
	{
	return $this->Storage->DeleteExpired();
	}

	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/session/session.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.29
	\ No newline at end of property
	+1.30
	\ No newline at end of property
	Index: trunk/core/kernel/utility/http_query.php
	===================================================================
	--- trunk/core/kernel/utility/http_query.php (revision 3030)
	+++ trunk/core/kernel/utility/http_query.php (revision 3031)
	@@ -1,489 +1,489 @@
	<?php

	class HTTPQuery extends Params {
	/**
	* $_POST vars
	*
	* @var Array
	* @access private
	*/
	var $Post;

	/**
	* $_GET vars
	*
	* @var Array
	* @access private
	*/
	var $Get;
	/**
	* $_COOKIE vars
	*
	* @var Array
	* @access private
	*/
	var $Cookie;

	/**
	* $_SERVER vars
	*
	* @var Array
	* @access private
	*/
	var $Server;

	/**
	* $_ENV vars
	*
	* @var Array
	* @access private
	*/
	var $Env;

	/**
	* Order in what write
	* all vars together in
	* the same array
	*
	* @var string
	*/
	var $Order;

	/**
	* Uploaded files info
	*
	* @var Array
	* @access private
	*/
	var $Files;

	var $specialsToRemove = Array();

	var $Admin = false;

	/**
	* Loads info from $_POST, $_GET and
	* related arrays into common place
	*
	* @param string $order
	* @return HTTPQuery
	* @access public
	*/
	function HTTPQuery($order='CGPF')
	{
	parent::Params();
	$this->Order = $order;
	- $this->Admin = defined('ADMIN') && ADMIN;
	+ $this->Admin = $this->Application->IsAdmin(); // better cache this value, not to calculate it each time in foreach
	$this->AddAllVars();

	$this->specialsToRemove = $this->Get('remove_specials');
	if($this->specialsToRemove)
	{
	$this->_Params = $this->removeSpecials($this->_Params);
	}
	ini_set('magic_quotes_gpc', 0);
	}

	function removeSpecials($array)
	{
	$ret = Array();
	$removed = false;
	foreach($this->specialsToRemove as $prefix_special => $flag)
	{
	if($flag)
	{
	$removed = true;
	list($prefix,$special) = explode('.',$prefix_special, 2);
	foreach ($array as $key => $val) {
	$new_key = preg_match("/^".$prefix."[._]{1}".$special."(.*)/", $key, $regs) ? $prefix.$regs[1] : $key;
	$ret[$new_key] = is_array($val) ? $this->removeSpecials($val) : $val;
	}
	}
	}
	return $removed ? $ret : $array;
	}

	/**
	* All all requested vars to
	* common storage place
	*
	* @access private
	*/
	function AddAllVars()
	{
	for ($i=0; $i < strlen($this->Order); $i++)
	{
	$current = $this->Order[$i];
	switch ($current) {
	case 'G':
	$this->Get =$this->AddVars($_GET);
	$this->processQueryString();
	break;
	case 'P':
	$this->Post = $this->AddVars($_POST);
	$this->convertPostEvents();
	break;
	case 'C':
	$this->Cookie = $this->AddVars($_COOKIE);
	break;
	case 'E';
	$this->Env = $this->AddVars($_ENV);
	break;
	case 'S';
	$this->Server = $this->AddVars($_SERVER);
	break;
	case 'F';
	$this->convertFiles();
	$this->Files = $this->MergeVars($_FILES, false); //do not strip slashes!
	break;
	}
	}
	}

	function convertFiles()
	{
	if (!$_FILES)
	{
	return false;
	}

	$file_keys = Array('error','name','size','tmp_name','type');

	$tmp = Array();
	foreach($_FILES as $file_name => $file_info)
	{
	if( is_array($file_info['error']) )
	{
	$tmp[$file_name] = $this->getArrayLevel( $file_info['error'], $file_name );
	}
	else
	{
	$normal_files[$file_name] = $file_info;
	}
	}

	if(!$tmp) return false;

	$files = $_FILES;
	$_FILES = Array();

	foreach($tmp as $prefix => $prefix_files)
	{
	$anchor =& $_FILES;
	foreach($prefix_files['keys'] as $key)
	{
	$anchor =& $anchor[$key];
	}
	foreach($prefix_files['value'] as $field_name)
	{
	unset($inner_anchor);
	unset($copy);
	$work_copy = $prefix_files['keys'];
	foreach($file_keys as $file_key)
	{
	$inner_anchor =& $files[$prefix][$file_key];
	if (isset($copy))
	{
	$work_copy = $copy;
	}
	else
	{
	$copy = $work_copy;
	}
	array_shift($work_copy);
	foreach($work_copy as $prefix_file_key)
	{
	$inner_anchor =& $inner_anchor[$prefix_file_key];
	}
	$anchor[$field_name][$file_key] = $inner_anchor[$field_name];
	}
	}
	}

	// keys: img_temp, 0, values: LocalPath, ThumbPath
	}

	function getArrayLevel(&$level, $prefix='')
	{
	$ret['keys'] = $prefix ? Array($prefix) : Array();
	$ret['value'] = Array();

	foreach($level as $level_key => $level_value)
	{
	if( is_array($level_value) )
	{
	$ret['keys'][] = $level_key;
	$tmp = $this->getArrayLevel($level_value);

	$ret['keys'] = array_merge($ret['keys'], $tmp['keys']);
	$ret['value'] = array_merge($ret['value'], $tmp['value']);
	}
	else
	{
	$ret['value'][] = $level_key;
	}
	}

	return $ret;
	}

	/**
	* Owerwrites GET events with POST events in case if they are set and not empty
	*
	*/
	function convertPostEvents()
	{
	$events = $this->Get('events');
	if( is_array($events) )
	{
	foreach ($events as $prefix_special => $event_name)
	{
	if($event_name) $this->Set($prefix_special.'_event', $event_name);
	}
	}
	}

	/**
	* Process QueryString only, create
	* events, ids, based on config
	* set template name and sid in
	* desired application variables.
	*
	* @access private
	*/
	function processQueryString()
	{
	// env=SID:TEMPLATE:m-1-1-1-1:l0-0-0:n-0-0-0:bb-0-0-1-1-1-0


	$env_var = $this->Get(ENV_VAR_NAME);
	if($env_var)
	{
	$sid = $this->Get('sid');
	if (defined('MOD_REWRITE') && MOD_REWRITE && $sid && !$this->Get('admin') )
	{
	//$env_var = rtrim($sid.$env_var, '/');
	$split_by = defined('INPORTAL_ENV') ? '-' : ':';
	$env_var = explode($split_by, $env_var, 2);
	$env_var[0] = $sid;
	$env_var = rtrim( implode($split_by, $env_var), '/');
	}
	$env_var = str_replace('\:','_&+$$+&_',$env_var); // replace escaped "=" with spec-chars :)

	$parts=explode(':',$env_var);

	if (defined('MOD_REWRITE') && MOD_REWRITE) $env_var = str_replace('/', ':', $env_var);

	if (defined('INPORTAL_ENV')) {
	$sub_parts = array_shift($parts);

	list($sid, $t) = explode('-', $sub_parts, 2);


	// Save Session ID
	if($sid) {
	$this->Set('sid',$sid);
	$this->Get['sid'] = $sid;
	}

	// Save Template Name
	$t=$this->getTemplateName( trim($t, '/') );
	if(!$t) $t='index';
	$this->Set('t', trim($t, '/') );
	}
	else {
	// Save Session ID
	$sid=array_shift($parts);
	if($sid) $this->Set('sid',$sid);

	// Save Template Name
	$t=$this->getTemplateName( array_shift($parts) );
	if(!$t) $t='index';
	$this->Set('t', trim($t, '/') );
	}

	if($parts)
	{
	$query_maps=Array();
	$event_manger =& $this->Application->recallObject('EventManager');

	$passed = Array();

	foreach($parts as $mixed_part)
	{
	//In-portal old style env conversion - adds '-' between prefix and first var
	$mixed_part = str_replace('_&+$$+&_',':',$mixed_part);
	$mixed_part = preg_replace("/^([a-zA-Z]+)([0-9]+)-(.*)/", "$1-$2-$3", $mixed_part);

	$escaped_part = str_replace('\-', '_&+$$+&_', $mixed_part);
	$escaped_part = explode('-', $escaped_part);

	$mixed_part = array();
	foreach ($escaped_part as $escaped_val) {
	$mixed_part[] = str_replace('_&+$$+&_', '-', $escaped_val);
	}

	$prefix_special=array_shift($mixed_part); // l.pick, l
	list($prefix)=explode('.',$prefix_special);

	$query_maps[$prefix_special]=$this->Application->getUnitOption($prefix,'QueryString');

	// if config is not defined for prefix in QueryString, then don't process it
	if( $query_maps[$prefix_special] )
	{
	array_push($passed, $prefix);
	foreach($query_maps[$prefix_special] as $index => $var_name)
	{
	// l_id, l_page, l_bla-bla-bla
	$val = $mixed_part[$index-1];
	if ($val == '') $val = false;
	$this->Set($prefix_special.'_'.$var_name, $val);
	}
	}
	else
	{
	unset($query_maps[$prefix_special]);
	}

	}
	$this->Set('passed', implode(',', $passed));
	$event_manger->setQueryMaps($query_maps);
	}
	}
	else
	{
	$t=$this->getTemplateName('index');
	$this->Set('t',$t);
	}
	}

	/**
	* Decides what template name to
	* use from $_GET or from $_POST
	*
	* @param string $querystring_template
	* @return string
	* @access private
	*/
	function getTemplateName($querystring_template)
	{
	$t_from_post = $this->Get('t');
	$t= $t_from_post ? $t_from_post : $querystring_template;

	if ( is_numeric($t) ) {
	$t = $this->Application->DB->GetOne('SELECT CONCAT(FilePath, \'/\', FileName) FROM '.TABLE_PREFIX.'ThemeFiles
	WHERE FileId = '.$t);
	}
	$t = preg_replace("/\.tpl$/", '', $t);

	return $t;
	}

	/**
	* Saves variables from array specified
	* into common variable storage place
	*
	* @param Array $array
	* @return Array
	* @access private
	*/
	function AddVars($array)
	{
	$array = $this->StripSlashes($array);
	foreach($array as $key => $value)
	{
	$this->Set($key,$value);
	}
	return $array;
	}

	function MergeVars($array, $strip_slashes=true)
	{
	if ($strip_slashes) $array = $this->StripSlashes($array);
	foreach($array as $key => $value)
	{
	$this->_Params = array_merge_recursive2($this->_Params, Array($key=>$value));
	}
	return $array;
	}

	function StripSlashes($array)
	{
	//if( !get_magic_quotes_gpc() ) return $array;
	foreach($array as $key=>$value)
	{
	if( is_array($value) )
	{
	$array[$key] = $this->StripSlashes($value);
	}
	else
	{
	if( get_magic_quotes_gpc() ) $value = stripslashes($value);
	if(!$this->Admin) $value = htmlspecialchars($value);
	$array[$key] = $value;
	}
	//$array[$key]=is_array($value)?$this->StripSlashes($value):stripslashes($value);
	}
	return $array;
	}

	/**
	* Returns the hash of http params
	* matching the mask with values
	*
	* @param string $mask
	* @return Array
	* @access public
	*/
	function GetSelectedValues($mask)
	{
	return $this->Application->ExtractByMask($this->Vars, $mask);
	}

	/**
	* Returns the sprintf'ed by format list of
	* http params matching the mask and set to on
	*
	* @param string $mask
	* @param string $format
	* @return string
	* @access public
	*/
	function GetSelectedIDs($mask, $format)
	{
	if ($mask == '') return;
	$result = '';
	foreach ($this->GetParams() as $name => $val)
	{
	if (eregi($mask, $name, $regs) && $val == 'on') {

	$result.= sprintf($format, $regs[1]);
	}
	}
	return $result;
	}

	/**
	* Returns the sprintf'ed by format list of
	* http params matching the mask and set to on
	*
	* @param string $mask
	* @param string $value_mask
	* @return Array
	* @access public
	*/
	function GetSelectedIDsArray($mask, $value_mask="%s,")
	{
	$str = $this->GetSelectedIDs($mask, $value_mask);
	$str = rtrim($str, ',');
	if (!empty($str)) {
	$ids = split(',', $str);
	if ($ids !== false)
	return $ids;
	else return Array();
	}
	else return Array();
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/utility/http_query.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.9
	\ No newline at end of property
	+1.10
	\ No newline at end of property
	Index: trunk/core/kernel/db/db_tag_processor.php
	===================================================================
	--- trunk/core/kernel/db/db_tag_processor.php (revision 3030)
	+++ trunk/core/kernel/db/db_tag_processor.php (revision 3031)
	@@ -1,1360 +1,1361 @@
	<?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->Application->recallObject( $this->getPrefixSpecial(), $this->Prefix, $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)
	{
	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 = 1;
	}
	else
	{
	$submit = 1;
	$status = 0;
	}
	$block_params['filter_action'] = 'set_filter("'.$prefix_special.'","'.$filter_key.'","'.$submit.'");';
	$block_params['filter_status'] = $status;
	$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 = array_merge($std_params, $block_params, $options);
	$o.= $this->Application->ParseBlock($block_params, 1);
	}
	return $o;
	}

	/**
	* Prints list content using block specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintList($params)
	{
	// $list =& $this->Application->recallObject( $this->getPrefixSpecial(), $this->Prefix.'_List',$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 = $params['list_name'];

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

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

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

	/**
	* Enter description here...
	*
	* @param unknown_type $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, $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);
	$list->Query();
	$this->Special = $special;

	if ($list_name) {
	$names_mapping[$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);
	}

	$list->GoFirst();

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

	$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();
	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 ($i % $columns == 0) {
	$o.= $block_start_row_params['name'] ? $this->Application->ParseBlock($block_start_row_params, 1) : '<tr>';
	}

	if (!$list->getCurrentRecord()){
	$o.= $block_empty_cell_params['name'] ? $this->Application->ParseBlock($block_params, 1) : '<td> </td>';
	}
	else {
	$o.= $this->Application->ParseBlock($block_params, 1);
	array_push($displayed, $list->GetDBField($id_field));
	}

	if (($i+1) % $columns == 0) {
	$o.= $block_end_row_params['name'] ? $this->Application->ParseBlock($block_end_row_params, 1) : '</tr>';
	}

	$list->GoNext();

	$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)
	{
	$list =& $this->Application->recallObject($this->getPrefixSpecial());

	return ($list->CurrentIndex < min($list->PerPage, $list->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']);
	}

	$pass = Array('pass' => 'all,'.$this->getPrefixSpecial());
	// $pass = Array('pass' => 'all');
	$http_query =& $this->Application->recallObject('HTTPQuery');
	$get = $http_query->Get;
	unset($get['env']);
	// $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())
	{
	$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)
	{
	$this->Application->setUnitOption('curr', 'AutoLoad', false);
	$currency =& $this->Application->recallObject('curr.-'.$iso);
	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->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $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( getArrayValue($params,'nl2br' ) ) $value = nl2br($value);
	if( !$this->HasParam($params, 'no_special') ) $value = htmlspecialchars($value);
	if( getArrayValue($params,'checked' ) ) $value = ($value == 1) ? 'checked' : '';
	if( 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 ($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;
	}

	/**
	* 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 = $params['field'];
	$object =& $this->Application->recallObject($this->getPrefixSpecial(), $this->Prefix, $params);

	$msg = $object->GetErrorMsg($field, false);

	return $msg;
	}

	function HasError($params)
	{
	if ($params['field'] == 'any') {
	$object =& $this->Application->recallObject($this->getPrefixSpecial());
	return $object->HasErrors();
	}
	else {
	return $this->Error($params) != '';
	}
	}

	function IsRequired($params)
	{
	$field = $params['field'];
	$object =& $this->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $params);

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

	function PredefinedOptions($params)
	{
	$field = $params['field'];
	$object =& $this->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $params);

	$value = $object->GetDBField($field);
	$options = $object->GetFieldOptions($field);
	if( $this->HasParam($params,'has_empty') )
	{
	$options['options'] = array_merge_recursive2( Array('' => ''), $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';

	$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']);
	foreach ($options['options'] as $key => $val) {
	$block_params['key'] = $key;
	$block_params['option'] = $val;
	$block_params['field_name'] = $this->InputName($params);
	$block_params[$selected_param_name] = ( $key == $value ? ' '.$selected : '');
	$block_params['PrefixSpecial'] = $this->getPrefixSpecial();
	$o .= $this->Application->ParseBlock($block_params, 1);
	}

	return $o;
	}

	function Format($params)
	{
	$field = $params['field'];
	$object =& $this->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $params);

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

	$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($options['format']);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $options['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) $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 = $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 input field name to
	* be placed on form (for correct
	* event processing)
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function InputName($params)
	{
	$prefix_special=$this->getPrefixSpecial();
	$object =& $this->Application->recallObject($prefix_special);

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

	if ( $idfield = getArrayValue($params, 'IdField') ) {
	$id = $object->GetDBField($idfield);
	}
	else {
	$id = $object->GetID();
	}

	return $prefix_special.'['.$id.']['.$params['field'].']';
	}



	/**
	* 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->Application->recallObject( $this->getPrefixSpecial() );
	return $object->PerPage;
	}

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

	function SaveEvent($params)
	{
	// SaveEvent is set during onbuild, but we may need it before any other tag calls onBuild
	$prefix_special = $this->getPrefixSpecial();
	$item = $this->Application->recallObject($prefix_special);

	return $this->Application->GetVar($prefix_special.'_SaveEvent');
	}

	function NextId($params)
	{
	$prefix_special=$this->getPrefixSpecial();
	$ids = explode(',', $this->Application->RecallVar($prefix_special.'_selected_ids'));
	$item = $this->Application->recallObject($prefix_special);
	$cur_id = $item->GetId();

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

	function PrevId($params)
	{
	$prefix_special=$this->getPrefixSpecial();
	$ids = explode(',', $this->Application->RecallVar($prefix_special.'_selected_ids'));
	$item = $this->Application->recallObject($prefix_special);
	$cur_id = $item->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->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $params);
	$ret = $object->GetDBField($this->SelectParam($params, 'name,field')) == $params['value'];
	// if( getArrayValue($params,'inverse') ) $ret = !$ret;
	return $ret;
	}

	function ItemIcon($params)
	{
	$object =& $this->Application->recallObject($this->getPrefixSpecial(),$this->Prefix, $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)
	{
	$title_presets = $this->Application->getUnitOption($this->Prefix,'TitlePresets');
	$title_info = getArrayValue($title_presets, $params['title_preset'] );
	if($title_info === false) return $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'] ]->GetID() ? 'edit' : 'new';

	// 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:
	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->Application->recallObject( $this->getPrefixSpecial() );
	$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 'textarea':
	$params['field_params'] = $helper->ParseConfigSQL($object->GetDBField($params['value_list_field']));
	break;

	case 'password':
	case 'text':
	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)
	{
	$object =& $this->Application->recallObject( $this->getPrefixSpecial(), $this->Prefix, $params );

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

	$lang_id = $this->Application->GetVar('m_lang');

	$sql = ' SELECT cv.l'.$lang_id.'_Value FROM '.TABLE_PREFIX.'CustomField cf
	LEFT JOIN '.TABLE_PREFIX.'CustomMetaData cv
	ON cf.CustomFieldId = cv.CustomFieldId
	WHERE cf.Type = '.$this->Application->getUnitOption($this->Prefix, 'ItemType').'
	AND cv.ResourceId = '.$object->GetDBField('ResourceId').'
	AND cf.FieldName = "'.$field.'"';
	return $this->Conn->GetOne($sql);
	}

	function CustomFieldLabel($params)
	{
	$prefix = $this->Prefix;
	$object =& $this->Application->recallObject( $prefix );

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

	$sql = ' SELECT FieldLabel FROM '.TABLE_PREFIX.'CustomField WHERE FieldName = "'.$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;
	$cols=min(ceil($per_page/$columns), ceil(sizeof($arr)/$columns));
	$imatrix=array();
	for ($row=0; $row<$rows; $row++) {
	for ($col=0; $col<$cols; $col++){
	$imatrix[$col$rows+$row]=$arr[$row$cols+$col];
	}
	}
	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 = $this->Application->GetVar($top_prefix.'_mode') == 't';
	$modified = $this->Application->RecallVar($top_prefix.'_modified');

	if($temp_tables && $modified)
	{
	return $this->Application->ParseBlock($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');
	return 'custom_filters['.$this->getPrefixSpecial().']['.$field.'_'.$params['type'].']';
	}

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

	$custom_filters = $this->Application->RecallVar($this->getPrefixSpecial().'_custom_filters');
	$custom_filters = $custom_filters ? unserialize($custom_filters) : Array();

	$append = getArrayValue($params, 'type');

	return getArrayValue($custom_filters, $field.( $append ? '_'.$append : '') );
	}

	function SearchFormat($params)
	{
	$field = $params['field'];
	$object =& $this->Application->recallObject($this->getPrefixSpecial(),$this->Prefix.'_List', $params);

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

	$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($options['format']);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $options['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, '');
	}
	return $error_msg;
	}

	/**
	* Returns templates path for module, which is gathered from prefix module
	*
	* @param Array $params
	* @return string
	* @author Alex
	*/
	function ModulePath($params)
	{
	$module_folder = $this->Application->getUnitOption($this->Prefix, 'ModuleFolder');
	return '../../'.$module_folder.'/admin_templates/';
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/db/db_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.28
	\ No newline at end of property
	+1.29
	\ No newline at end of property
	Index: trunk/core/kernel/startup.php
	===================================================================
	--- trunk/core/kernel/startup.php (revision 3030)
	+++ trunk/core/kernel/startup.php (revision 3031)
	@@ -1,106 +1,103 @@
	<?php

	define('KERNEL_PATH', FULL_PATH.'/kernel/kernel4');
	include_once(KERNEL_PATH.'/globals.php'); // non OOP functions used through kernel, e.g. print_pre
	-
	- if( defined('ADMIN') && ADMIN )
	- {
	- define('SPECIAL_TEMPLATES_FOLDER', '/kernel/admin_templates');
	- }
	+
	+ if( defined('ADMIN') && ADMIN ) define('SPECIAL_TEMPLATES_FOLDER', '/kernel/admin_templates');

	define('INPORTAL_ENV', 1);

	# New path detection method: begin
	safeDefine('REL_PATH', '/admin');
	$ps = preg_replace("/".preg_quote(rtrim(REL_PATH, '/'), '/')."$/", '', str_replace('\\', '/', dirname($_SERVER['PHP_SELF'])));
	safeDefine('BASE_PATH', $ps); // in case in-portal has defined it before
	# New path detection method: end

	safeDefine('INPORTAL_TAGS', true);
	safeDefine('SERVER_NAME', $_SERVER['HTTP_HOST']);
	safeDefine('KERNEL_PATH', FULL_PATH.'/kernel4');
	safeDefine('PROTOCOL', isset($_SERVER["HTTPS"]) ? 'https://' : 'http://');

	$vars = parse_portal_ini(FULL_PATH.'/config.php');

	if($vars === false)
	{
	global $rootURL;
	echo 'In-Portal is probably not installed, or configuration file is missing.<br>';
	echo 'Please use the installation script to fix the problem.<br><br>';
	if ( !preg_match('/admin/', __FILE__) ) $ins = '/admin';

	echo '<a href="'.PROTOCOL.SERVER_NAME.BASE_PATH.$ins.'/install.php">Go to installation script</a><br><br>';
	flush();
	exit;
	}

	define('SQL_TYPE', $vars['DBType']);
	define('SQL_SERVER', $vars['DBHost']);
	define('SQL_USER', $vars['DBUser']);
	define('SQL_PASS', $vars['DBUserPassword']);
	define('SQL_DB', $vars['DBName']);
	define('TABLE_PREFIX', $vars['TablePrefix']);
	define('DOMAIN', $vars['Domain']);

	ini_set('memory_limit', '50M');

	define('MODULES_PATH', FULL_PATH);
	define('EXPORT_PATH', FULL_PATH.'/admin/export');
	define('GW_CLASS_PATH', MODULES_PATH.'/in-commerce/units/gateways/gw_classes'); // Payment Gateway Classes Path

	safeDefine('ENV_VAR_NAME','env');

	k4_include_once(KERNEL_PATH.'/application.php');
	k4_include_once(MODULES_PATH.'/kernel/units/general/my_application.php');

	if( file_exists(FULL_PATH.'/debug.php') )
	{
	k4_include_once(FULL_PATH.'/debug.php');
	if( defined('DEBUG_MODE') && DEBUG_MODE ) include_once(KERNEL_PATH.'/utility/debugger.php');
	}

	k4_include_once(KERNEL_PATH.'/db/db_connection.php');

	safeDefine('IMAGES_PATH', '/kernel/images/');
	safeDefine('IMAGES_PENDING_PATH', IMAGES_PATH.'pending/');
	safeDefine('CUSTOM_UPLOAD_PATH', '/templates/images/custom/');
	safeDefine('MAX_UPLOAD_SIZE', min(ini_get('upload_max_filesize'), ini_get('post_max_size'))10241024);

	if( ini_get('safe_mode') ) define('SAFE_MODE', 1);

	safeDefine('CACHE_CONFIGS_FILES', 1);
	safeDefine('EXPERIMENTAL_PRE_PARSE', 1);
	safeDefine('SILENT_LOG', 0);

	k4_include_once(KERNEL_PATH."/kbase.php");
	k4_include_once(KERNEL_PATH.'/utility/event.php');
	k4_include_once(KERNEL_PATH."/utility/factory.php");
	k4_include_once(KERNEL_PATH."/languages/phrases_cache.php");

	// We should get rid of these includes:
	k4_include_once(KERNEL_PATH."/db/dblist.php");
	k4_include_once(KERNEL_PATH."/db/dbitem.php");

	k4_include_once(KERNEL_PATH.'/processors/tag_processor.php');
	k4_include_once(KERNEL_PATH."/db/db_tag_processor.php");

	k4_include_once(KERNEL_PATH."/event_handler.php");
	k4_include_once(KERNEL_PATH.'/db/db_event_handler.php');
	k4_include_once(MODULES_PATH.'/kernel/units/general/inp_db_event_handler.php');

	k4_include_once(KERNEL_PATH."/utility/temp_handler.php"); // needed because of static calls from kBase
	// up to here

	// global constants
	define('HAVING_FILTER', 1);
	define('WHERE_FILTER', 2);

	define('FLT_TYPE_AND', 'AND');
	define('FLT_TYPE_OR', 'OR');

	safeDefine('STATUS_DISABLED', 0);
	safeDefine('STATUS_ACTIVE', 1);
	safeDefine('STATUS_PENDING', 2);

	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/startup.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.27
	\ No newline at end of property
	+1.28
	\ No newline at end of property
	Index: trunk/core/kernel/application.php
	===================================================================
	--- trunk/core/kernel/application.php (revision 3030)
	+++ trunk/core/kernel/application.php (revision 3031)
	@@ -1,1384 +1,1384 @@
	<?php

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

	class kApplication {

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

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

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

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

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

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

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

	/**
	* Holds DBConnection
	*
	* @var kDBConnection
	*/
	var $DB;

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

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

	if(!$instance)
	{
	if (!defined('APPLICATION_CLASS')) define('APPLICATION_CLASS', 'kApplication');
	$class = APPLICATION_CLASS;
	$instance = new $class();
	}
	return $instance;
	}

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

	if( $this->isDebugMode() && dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$GLOBALS['debugger']->appendMemoryUsage('Application before Init:');
	}

	if( !$this->isDebugMode() )
	{
	error_reporting(0);
	ini_set('display_errors', 0);
	}

	$error_handler = set_error_handler( Array(&$this,'handleError') );
	if($error_handler) $this->errorHandlers[] = $error_handler;


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

	$this->Factory = new kFactory();

	$this->registerDefaultClasses();
	$this->SetDefaultConstants();

	// 1. to read configs before doing any recallObject (called from "SetDefaultConstants" anyway)
	$config_reader =& $this->recallObject('kUnitConfigReader');

	$this->VerifyLanguageId();
	$this->VerifyThemeId();

	if( $this->GetVar('m_cat_id') === false ) $this->SetVar('m_cat_id', 0);

	$this->Phrases = new PhrasesCache( $this->GetVar('m_lang') );

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

	if( !$this->GetVar('m_theme') ) $this->SetVar('m_theme', $this->GetDefaultThemeId() );
	$this->SetVar('theme.current_id', $this->GetVar('m_theme') );

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

	if( !$this->RecallVar('curr_iso') ) $this->StoreVar('curr_iso', $this->GetPrimaryCurrency() );

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

	$this->ValidateLogin(); // TODO: write that method

	if( $this->isDebugMode() )
	{
	$GLOBALS['debugger']->profileFinish('kernel4_startup');
	}

	if( defined('CMS') && CMS == 1 && !$this->GetVar('admin') && !$this->IsAdmin() )
	{
	define('MOD_REWRITE', 1);
	}

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

	/**
	* Checks if passed language id if valid and sets it to primary otherwise
	*
	*/
	function VerifyLanguageId()
	{
	$language_id = $this->GetVar('m_lang');
	if($language_id)
	{
	$table = $this->getUnitOption('lang','TableName');
	$id_field = $this->getUnitOption('lang','IDField');
	$language_ids = $this->DB->GetCol('SELECT '.$id_field.' FROM '.$table);
	}

	if(!$language_id \|\| !in_array($language_id, $language_ids) ) $this->SetVar('m_lang', $this->GetDefaultLanguageId() );
	}

	/**
	* Checks if passed theme id if valid and sets it to primary otherwise
	*
	*/
	function VerifyThemeId()
	{
	$theme_id = $this->GetVar('m_theme');
	if($theme_id)
	{
	$table = $this->getUnitOption('theme','TableName');
	$id_field = $this->getUnitOption('theme','IDField');
	$theme_ids = $this->DB->GetCol('SELECT '.$id_field.' FROM '.$table);
	}

	if(!$theme_id \|\| !in_array($theme_id, $theme_ids) ) $this->SetVar('m_theme', $this->GetDefaultThemeId() );
	}

	function GetDefaultLanguageId()
	{
	$table = $this->getUnitOption('lang','TableName');
	$id_field = $this->getUnitOption('lang','IDField');
	return $this->DB->GetOne('SELECT '.$id_field.' FROM '.$table.' WHERE PrimaryLang = 1');
	}

	function GetDefaultThemeId()
	{
	if (defined('DBG_FORCE_THEME') && DBG_FORCE_THEME){
	return DBG_FORCE_THEME;
	}
	$table = $this->getUnitOption('theme','TableName');
	$id_field = $this->getUnitOption('theme','IDField');
	return $this->DB->GetOne('SELECT '.$id_field.' FROM '.$table.' WHERE PrimaryTheme = 1');
	}

	function GetPrimaryCurrency()
	{
	$this->setUnitOption('mod','AutoLoad',false);
	$module =& $this->recallObject('mod');
	$this->setUnitOption('mod','AutoLoad',true);

	if( $module->Load('In-Commerce') && $module->GetDBField('Loaded') == 1 )
	{
	$table = $this->getUnitOption('curr','TableName');
	return $this->DB->GetOne('SELECT ISO FROM '.$table.' WHERE IsPrimary = 1');
	}
	else
	{
	return 'USD';
	}
	}

	/**
	* Registers default classes such as ItemController, GridController and LoginController
	*
	* Called automatically while initializing Application
	* @access private
	* @return void
	*/
	function RegisterDefaultClasses()
	{
	$this->registerClass('kArray',KERNEL_PATH.'/utility/params.php');
	$this->registerClass('Params',KERNEL_PATH.'/utility/params.php');

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

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

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

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

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

	$this->registerClass('kTempTablesHandler', KERNEL_PATH.'/utility/temp_handler.php');

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

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

	$this->registerClass('MainProcessor', KERNEL_PATH.'/processors/main_processor.php','m_TagProcessor');

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

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

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

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

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

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

	$this->registerModuleConstants();
	}

	/**
	* Registers each module specific constants if any found
	*
	*/
	function registerModuleConstants()
	{
	$modules_installed = $this->DB->GetCol('SELECT CONCAT(\'/\',Path) AS Path, Name FROM '.TABLE_PREFIX.'Modules WHERE Loaded = 1','Name');
	foreach($modules_installed as $module_path)
	{
	$contants_file = FULL_PATH.$module_path.'constants.php';
	if( file_exists($contants_file) ) k4_include_once($contants_file);
	}
	}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	flush();

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

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

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

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

	// Facade

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

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

	/**
	* Returns variable passed to the script as GET/POST/COOKIE
	*
	* @access public
	* @param string $var Variable name
	* @return mixed
	*/
	function GetVar($var,$mode=FALSE_ON_NULL)
	{
	$http_query =& $this->recallObject('HTTPQuery');
	return $http_query->Get($var,$mode);
	}

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

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

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

	/**
	* Deletes HTTPQuery variable
	*
	* @param string $var
	* @todo think about method name
	*/
	function DeleteVar($var)
	{
	$http_query =& $this->recallObject('HTTPQuery');
	return $http_query->Remove($var);
	}

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

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

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

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

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

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

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

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

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

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

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

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

	- if (defined('ADMIN') && $prefix == '') $prefix='/admin';
	- if (defined('ADMIN') && $prefix == '_FRONT_END_') $prefix = '';
	+ if ( $this->IsAdmin() && $prefix == '') $prefix='/admin';
	+ if ( $this->IsAdmin() && $prefix == '_FRONT_END_') $prefix = '';
	$index_file = isset($index_file) ? $index_file : (defined('INDEX_FILE') ? INDEX_FILE : basename($_SERVER['SCRIPT_NAME']));

	if( isset($params['index_file']) ) $index_file = $params['index_file'];

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

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

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

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

	if (defined('MOD_REWRITE') && MOD_REWRITE) {
	$env = $this->BuildEnv('', $params, $pass, $pass_events, false);
	$env = ltrim($env, ':-');

	$session =& $this->recallObject('Session');
	$sid = $session->NeedQueryString() ? '?sid='.$this->GetSID() : '';
	// $env = str_replace(':', '/', $env);
	$ret = rtrim($this->BaseURL($prefix, $ssl).$t.'.html/'.$env.'/'.$sid, '/');

	}
	else {
	$env = $this->BuildEnv($t, $params, $pass, $pass_events);
	$ret = $this->BaseURL($prefix, $ssl).$index_file.'?'.$env;
	}

	return $ret;
	}

	function BuildEnv($t, $params, $pass='all', $pass_events=false, $env_var=true)
	{
	$session =& $this->recallObject('Session');
	$sid = $session->NeedQueryString() && !(defined('MOD_REWRITE') && MOD_REWRITE) ? $this->GetSID() : '';
	if( getArrayValue($params,'admin') == 1 ) $sid = $this->GetSID();

	$ret = '';
	if ($env_var) {
	$ret = ENV_VAR_NAME.'=';
	}
	$ret .= defined('INPORTAL_ENV') ? $sid.'-'.$t : $sid.':'.$t;

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

	$pass = str_replace('all', trim($this->GetVar('passed'), ','), $pass);

	if(strlen($pass) > 0)
	{
	$pass_info = array_unique( explode(',',$pass) ); // array( prefix[.special], prefix[.special] ...
	foreach($pass_info as $pass_element)
	{
	$ret.=':';
	list($prefix)=explode('.',$pass_element);
	$query_vars = $this->getUnitOption($prefix,'QueryString');

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

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

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

	if ($this->getUnitOption($prefix, 'PortalStyleEnv') == true) {
	$ret.= array_shift($escaped).array_shift($escaped).'-'.implode('-',$escaped);
	}
	else {
	$ret.=implode('-',$escaped);
	}
	}
	}
	}
	unset($params['pass']);
	unset($params['opener']);
	unset($params['m_event']);

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

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

	foreach ($params as $param => $value)
	{
	$ret .= '&'.$param.'='.$value;
	}

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

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

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

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


	if( $this->isDebugMode() && dbg_ConstOn('DBG_REDIRECT') )
	{
	$GLOBALS['debugger']->appendTrace();
	echo "<b>Debug output above!!!</b> Proceed to redirect: <a href=\"$a_location\">$a_location</a><br>";
	}
	else
	{
	if(headers_sent() != '')
	{
	echo '<script language="javascript" type="text/javascript">window.location.href = \''.$a_location.'\';</script>';
	}
	else
	{
	header("$location");
	}
	}

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

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

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

	/**
	* Validtates user in session if required
	*
	*/
	function ValidateLogin()
	{
	if (defined('LOGIN_REQUIRED'))
	{
	// Original Kostja call
	//$login_controller =& $this->Factory->MakeClass(LOGIN_CONTROLLER, Array('model' => USER_MODEL, 'prefix' => 'login'));

	// Call proposed by Alex
	//$login_controller =& $this->RecallObject(LOGIN_CONTROLLER, Array('model' => USER_MODEL, 'prefix' => 'login'));

	//$login_controller->CheckLogin();
	}
	}

	/**
	* Returns configuration option value by name
	*
	* @param string $name
	* @return string
	*/
	function ConfigValue($name)
	{
	return $this->DB->GetOne('SELECT VariableValue FROM '.TABLE_PREFIX.'ConfigurationValues WHERE VariableName = '.$this->DB->qstr($name) );
	}

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

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

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

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

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

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

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

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

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

	return $result;
	}

	/**
	* Checks if application is in debug mode
	*
	* @return bool
	* @access public
	* @author Alex
	*/
	function isDebugMode()
	{
	return defined('DEBUG_MODE') && DEBUG_MODE && is_object($this->Debugger);
	}

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

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

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

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

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

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

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


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

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

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

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

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

	/**
	* Returns & blocks next ResourceId available in system
	*
	* @return int
	* @access public
	* @author Eduard
	*/
	function NextResourceId()
	{
	$this->DB->Query('LOCK TABLES '.TABLE_PREFIX.'IdGenerator WRITE');
	$this->DB->Query('UPDATE '.TABLE_PREFIX.'IdGenerator SET lastid = lastid+1');
	$id = $this->DB->GetOne("SELECT lastid FROM ".TABLE_PREFIX."IdGenerator");
	$this->DB->Query('UNLOCK TABLES');
	return $id;
	}

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

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

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

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

	return $event;
	}


	function LoggedIn()
	{
	$user =& $this->recallObject('u');
	return ($user->GetDBField('PortalUserId') > 0);
	}

	function CheckPermission($name, $cat_id = null)
	{
	if( !isset($cat_id) )
	{
	$cat_id = $this->GetVar('m_cat_id');
	}
	if( $cat_id == 0 )
	{
	$cat_hierarchy = Array(0);
	}
	else
	{
	$sql = 'SELECT ParentPath FROM '.$this->getUnitOption('c', 'TableName').' WHERE CategoryId = '.$cat_id;
	$cat_hierarchy = $this->DB->GetOne($sql);
	$cat_hierarchy = explode('\|', $cat_hierarchy);
	array_shift($cat_hierarchy);
	array_pop($cat_hierarchy);
	$cat_hierarchy = array_reverse($cat_hierarchy);
	array_push($cat_hierarchy, 0);
	}

	$groups = $this->RecallVar('UserGroups');

	foreach($cat_hierarchy as $category_id)
	{
	$sql = 'SELECT PermissionValue FROM '.TABLE_PREFIX.'Permissions
	WHERE Permission = "'.$name.'"
	AND CatId = '.$category_id.'
	AND GroupId IN ('.$groups.')';
	$res = $this->DB->GetOne($sql);
	if($res !== false)
	{
	return $res;
	}
	}

	return 0;
	}

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

	}

	?>

	Property changes on: trunk/core/kernel/application.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.65
	\ No newline at end of property
	+1.66
	\ No newline at end of property
	Index: trunk/core/kernel/parser/template.php
	===================================================================
	--- trunk/core/kernel/parser/template.php (revision 3030)
	+++ trunk/core/kernel/parser/template.php (revision 3031)
	@@ -1,190 +1,197 @@
	<?php

	class Template {
	var $Body = '';
	var $BasePath = '';
	var $Filename = '';

	function Template($base_path=null, $filename=null, $silent=0)
	{
	if ($this->SetBasePath($base_path)) {
	if (isset($filename)) {
	$this->Filename = $filename;
	$this->LoadTemplate($silent);
	}
	}
	}

	function SetBasePath($base_path=null)
	{
	if (isset($base_path)) {
	$base_path = eregi_replace("/$", '', $base_path); //Cutting possible last slash
	$this->BasePath = $base_path;
	return true;
	}
	return false;
	}

	function GetFullPath()
	{
	return $this->BasePath.'/'.$this->Filename.'.tpl';
	}

	function LoadTemplate($silent=0)
	{
	$filename = $this->GetFullPath();
	if(file_exists($filename)) {
	if (filesize ($filename) == 0) {
	trigger_error("Template file size is 0: <b>$filename</b>", ($silent ? E_USER_NOTICE : E_USER_ERROR) );
	}

	$handle = fopen ($filename, "r");
	$contents = fread ($handle, filesize ($filename));
	$this->SetBody($contents);
	fclose ($handle);
	return true;
	}
	else {
	/*global $debugger;
	if($debugger) $debugger->appendTrace();*/
	trigger_error("File or block not found: <b>$filename</b>", ($silent ? E_USER_NOTICE : E_USER_ERROR) );
	return false;
	}
	}

	function SetBody($body)
	{
	$this->Body = $body;
	}

	function GetBody()
	{
	return $this->Body;
	}
	}

	class TemplatesCache extends kBase {
	var $Templates = Array();
	var $BasePath;
	var $FileNames = Array();

	var $ModulesCache = Array();

	function TemplatesCache()
	{
	parent::kBase();
	$this->SetThemePath();
	$this->BasePath = FULL_PATH.THEMES_PATH;

	$conn =& $this->Application->GetADODBConnection();
	$this->ModulesCache = $conn->GetCol('SELECT LOWER(Name) FROM '.TABLE_PREFIX.'Modules');
	}

	function SetThemePath()
	{
	- if ( defined('SPECIAL_TEMPLATES_FOLDER') ) {
	- safeDefine( 'THEMES_PATH', preg_replace('/'.preg_quote(rtrim(FULL_PATH, '/'), '/').'/i','',str_replace('\\', '/', FULL_PATH)). SPECIAL_TEMPLATES_FOLDER );
	+ if ( defined('SPECIAL_TEMPLATES_FOLDER') )
	+ {
	+ $sub_folder = SPECIAL_TEMPLATES_FOLDER;
	+ }
	+ elseif( $this->Application->IsAdmin() )
	+ {
	+ $sub_folder = '/admin/templates';
	}
	- else {
	+ else
	+ {
	$current_theme = $this->Application->GetVar('m_theme');
	- $folder = $this->Application->DB->GetOne('SELECT Name FROM '.TABLE_PREFIX.'Theme WHERE ThemeId = '.$current_theme);
	- safeDefine( 'THEMES_PATH', preg_replace('/'.preg_quote(rtrim(FULL_PATH, '/'), '/').'/i','',str_replace('\\', '/', FULL_PATH)). ( defined('ADMIN') ? '/admin/templates' : '/themes/'.$folder));
	+ $theme_folder = $this->Application->DB->GetOne('SELECT Name FROM '.TABLE_PREFIX.'Theme WHERE ThemeId = '.$current_theme);
	+ $sub_folder = '/themes/'.$theme_folder;
	}
	+ safeDefine('THEMES_PATH', $sub_folder);
	}

	function LoadTemplate($filename, $title=NULL, $silent=0)
	{
	if (preg_match('#^[\/]{0,1}([^\/])\/(.)#', $filename, $regs)) {
	$module_filename = $regs[2];
	$first_dir = $regs[1];
	}
	else {
	$first_dir = '';
	$module_filename = $filename;
	}

	- if ( defined('ADMIN') && ADMIN && in_array(strtolower($first_dir), $this->ModulesCache)) {
	+ if ( $this->Application->IsAdmin() && in_array(strtolower($first_dir), $this->ModulesCache)) {
	$path = MODULES_PATH.'/'.strtolower($first_dir).'/admin_templates';
	}
	else {
	$path = $this->BasePath;
	$module_filename = $first_dir.'/'.$module_filename;
	}

	$template =& new Template($path, $module_filename, $silent);
	if (!isset($title)) $title = $filename;
	$this->SetTemplate($title, $template);
	}

	function GetRealFilename($filename, $base=null) {
	if (preg_match('#^[\/]{0,1}([^\/])\/(.)#', $filename, $regs)) {
	$module_filename = $regs[2];
	$first_dir = $regs[1];
	}
	else {
	$first_dir = '';
	$module_filename = $filename;
	}

	- if ( defined('ADMIN') && ADMIN && in_array(strtolower($first_dir), $this->ModulesCache)) {
	+ if ( $this->Application->IsAdmin() && in_array(strtolower($first_dir), $this->ModulesCache)) {
	$path = MODULES_PATH.'/'.strtolower($first_dir).'/admin_templates';
	}
	else {
	$path = isset($base) ? $base : $this->BasePath;
	$module_filename = $first_dir.'/'.$module_filename;
	}
	return $path.'/'.$module_filename;
	}

	function SetTemplate($title, &$template, $filename=null)
	{
	if (!isset($filename)) $filename=$title;
	$this->Templates[$title] = $template;
	$this->FileNames[$title] = $filename;
	}

	function &GetTemplate($title, $silent=0)
	{
	if (!isset($this->Templates[$title])) {
	$this->LoadTemplate($title, null, $silent);
	}
	return $this->Templates[$title];
	}

	function GetTemplateBody($title, $silent=0)
	{
	$template =& $this->GetTemplate($title, $silent);
	if ( !is_object($template) ) {
	return '';
	}
	return $template->GetBody();
	}

	function GetTemplateFileName($title)
	{
	return $this->FileNames[$title];
	}

	function SetTemplateBody($title, $body)
	{
	$template =& new Template();
	$template->SetBody($body);
	$this->SetTemplate($title, $template);
	}

	function ParseTemplate($template_name)
	{
	$Parser =& new TemplateParser($this->Application);
	return $Parser->Parse( $this->GetTemplateBody($template_name) );
	}

	function TemplateExists($filename)
	{
	if (!preg_match("/\.tpl$/", $filename)) $filename .= '.tpl';
	$real_file = $this->GetRealFilename($filename);
	return file_exists($real_file);
	}
	}


	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/parser/template.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.7
	\ No newline at end of property
	+1.8
	\ No newline at end of property
	Index: trunk/core/units/categories/categories_event_handler.php
	===================================================================
	--- trunk/core/units/categories/categories_event_handler.php (revision 3030)
	+++ trunk/core/units/categories/categories_event_handler.php (revision 3031)
	@@ -1,226 +1,224 @@
	<?php

	class CategoriesEventHandler extends InpDBEventHandler {

	/**
	* Goes one level up from current category
	*
	* @param kEvent $event
	*/
	function OnCategoryUp(&$event)
	{
	$category_table = $this->Application->getUnitOption($event->Prefix,'TableName');
	$current_cat = $this->Application->GetVar('m_cat_id');

	if($current_cat)
	{
	$sql = 'SELECT ParentId FROM '.$category_table.' WHERE CategoryId = '.$current_cat;
	$cat_to_go = $this->Conn->GetOne($sql);
	}
	else
	{
	$cat_to_go = 0;
	}

	$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}

	/**
	* Goes to home category
	*
	* @param kEvent $event
	*/
	function OnGoHome(&$event)
	{
	$cat_to_go = 0;
	$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}

	/**
	* 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');
	}
	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('parent_filter', 'ParentId = '.$parent_cat_id);

	$view_perm = 1;
	$object->addFilter('perm_filter', 'PermId = '.$view_perm);
	- if (!defined('ADMIN')) {
	+ if ( !$this->Application->IsAdmin() )
	+ {
	$groups = explode(',',$this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', acl) \|\| ((NOT FIND_IN_SET('.$group.',dacl)) AND acl=\'\')';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	- }
	-
	- if (!defined('ADMIN')) {
	$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 (defined('ADMIN')) return parent::getPassedID($event);
	+ if ( $this->Application->IsAdmin() ) return parent::getPassedID($event);

	$ret = $this->Application->GetVar('m_cat_id');
	if($ret) return $ret;

	return parent::getPassedID($event);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/categories/categories_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.6
	\ No newline at end of property
	+1.7
	\ No newline at end of property
	Index: trunk/core/units/users/users_event_handler.php
	===================================================================
	--- trunk/core/units/users/users_event_handler.php (revision 3030)
	+++ trunk/core/units/users/users_event_handler.php (revision 3031)
	@@ -1,796 +1,796 @@
	<?php

	class UsersEventHandler extends InpDBEventHandler
	{

	function OnSessionExpire()
	{
	if( $this->Application->IsAdmin() )
	{
	$location = $this->Application->BaseURL().ADMIN_DIR.'/index.php?expired=1';
	header('Location: '.$location);
	exit;
	}
	else
	{
	$http_query =& $this->Application->recallObject('HTTPQuery');
	if( isset($http_query->Get[ENV_VAR_NAME]) ) unset($http_query->Get[ENV_VAR_NAME]);
	$t = $this->Application->GetVar('t');
	$this->Application->Redirect($t ? $t : 'index', $http_query->Get);
	}
	}

	/**
	* Checks user data and logs it in if allowed
	*
	* @param kEvent $event
	*/
	function OnLogin(&$event)
	{
	$this->Application->setUnitOption($event->Prefix, 'AutoLoad', false);
	$object =& $this->Application->recallObject('u');

	$password = $this->Application->GetVar('password');
	if(!$password)
	{
	$object->SetError('ValidateLogin', 'blank_password', 'lu_blank_password');
	$event->status = erFAIL;
	return false;
	}

	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	list($login_field, $submit_field) = $email_as_login ? Array('Email', 'email') : Array('Login', 'login');
	$login_value = $this->Application->GetVar($submit_field);

	/*$sql = 'SELECT PortalUserId FROM '.$object->TableName.' WHERE (%s = %s) AND (Password = MD5(%s))';
	$user_id = $this->Conn->GetOne( sprintf($sql, $login_field, $this->Conn->qstr($login_value), $this->Conn->qstr($password) ) );*/

	$sql = 'SELECT PortalUserId FROM '.$object->TableName.' WHERE (Email = %1$s OR Login = %1$s) AND (Password = MD5(%2$s))';
	$user_id = $this->Conn->GetOne( sprintf($sql, $this->Conn->qstr($login_value), $this->Conn->qstr($password) ) );

	if($user_id)
	{
	$object->Load($user_id);
	if( $object->GetDBField('Status') == STATUS_ACTIVE )
	{
	$groups = $object->getMembershipGroups(true);
	if(!$groups) $groups = Array();
	- if (!defined('ADMIN')) array_push($groups, $this->Application->ConfigValue('User_LoggedInGroup') );
	+ if ( !$this->Application->IsAdmin() ) array_push($groups, $this->Application->ConfigValue('User_LoggedInGroup') );
	$this->Application->StoreVar( 'UserGroups', implode(',', $groups) );

	if( $this->Application->CheckPermission('LOGIN',0) )
	{
	$session =& $this->Application->recallObject('Session');
	$session->SetField('PortalUserId', $user_id);
	$session->SetField('GroupList', implode(',', $groups) );
	$this->Application->SetVar('u_id', $user_id);
	$this->Application->StoreVar('user_id', $user_id);
	$this->Application->setVisitField('PortalUserId', $user_id);
	}
	else
	{
	$object->Load(-2);
	$object->SetError('ValidateLogin', 'no_permission', 'lu_no_permissions');
	$event->status = erFAIL;
	}

	$next_template = $this->Application->GetVar('next_template');
	if($next_template) $event->redirect = $next_template;
	}
	else
	{
	$event->redirect = $this->Application->GetVar('pending_disabled_template');
	}
	}
	else
	{
	$object->SetError('ValidateLogin', 'invalid_password', 'lu_invalid_password');
	$event->status = erFAIL;
	}
	}

	/**
	* Called when user logs in using old in-portal
	*
	* @param kEvent $event
	*/
	function OnInpLogin(&$event)
	{

	}

	function OnLogout(&$event)
	{
	$session =& $this->Application->recallObject('Session');
	$session->SetField('PortalUserId', -2);
	$this->Application->SetVar('u_id', -2);
	$this->Application->StoreVar('user_id', -2);
	$object =& $this->Application->recallObject('u');
	$object->Load(-2);

	$this->Application->DestroySession();

	$group_list = $this->Application->ConfigValue('User_GuestGroup').','.$this->Application->ConfigValue('User_LoggedInGroup');
	$session->SetField('GroupList', $group_list);
	$this->Application->StoreVar('UserGroups', $group_list);
	}

	/**
	* Prefill states dropdown with correct values
	*
	* @param kEvent $event
	* @access public
	*/
	function OnPrepareStates(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->PopulateStates($event, 'State', 'Country');

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

	if( $object->isRequired('Country') && $cs_helper->CountryHasStates( $object->GetDBField('Country') ) ) $object->setRequired('State', true);
	$object->setLogin();
	}

	/**
	* Redirects user after succesfull registration to confirmation template (on Front only)
	*
	* @param kEvent $event
	*/
	function OnAfterItemCreate(&$event)
	{
	$is_subscriber = $this->Application->GetVar('IsSubscriber');
	if(!$is_subscriber)
	{
	$object =& $event->getObject();

	$sql = 'UPDATE '.TABLE_PREFIX.'UserGroup
	SET PrimaryGroup = 0
	WHERE PortalUserId = '.$object->GetDBField('PortalUserId');
	$this->Conn->Query($sql);

	$group_id = $this->Application->ConfigValue('User_NewGroup');

	$sql = 'REPLACE INTO '.TABLE_PREFIX.'UserGroup(PortalUserId,GroupId,PrimaryGroup) VALUES (%s,%s,1)';
	$this->Conn->Query( sprintf($sql, $object->GetID(), $group_id) );
	}
	}

	/**
	* Login user if possible, if not then redirect to corresponding template
	*
	* @param kEvent $event
	*/
	function autoLoginUser(&$event)
	{
	$object =& $event->getObject();
	$this->Application->SetVar('u_id', $object->GetID() );

	if($object->GetDBField('Status') == STATUS_ACTIVE)
	{
	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	list($login_field, $submit_field) = $email_as_login ? Array('Email', 'email') : Array('Login', 'login');

	$this->Application->SetVar($submit_field, $object->GetDBField($login_field) );
	$this->Application->SetVar('password', $object->GetDBField('Password_plain') );

	$event->CallSubEvent('OnLogin');
	}
	}


	/**
	* When creating user & user with such email exists then force to use OnUpdate insted of OnCreate
	*
	* @param kEvent $event
	*/
	function OnSubstituteSubscriber(&$event)
	{
	$ret = false;
	$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);
	$user_email = $field_values['Email'];
	if($user_email)
	{
	// check if is subscriber
	$verify_user =& $this->Application->recallObject('u.verify', null, Array('skup_autoload' => true) );
	$verify_user->Load($user_email, 'Email');
	if( $verify_user->isLoaded() && $verify_user->isSubscriberOnly() )
	{
	$items_info = Array( $verify_user->GetDBField('PortalUserId') => $field_values );
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);
	$ret = true;
	}
	}
	}

	if( isset($event->MasterEvent) )
	{
	$event->MasterEvent->setEventParam('is_subscriber_only', $ret);
	}
	else
	{
	$event->setEventParam('is_subscriber_only', $ret);
	}
	}


	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return bool
	*/
	function isSubscriberOnly(&$event)
	{
	$event->CallSubEvent('OnSubstituteSubscriber');
	$is_subscriber = false;
	if( $event->getEventParam('is_subscriber_only') )
	{
	$is_subscriber = true;
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$this->OnUpdate($event);
	if($event->status == erSUCCESS)
	{
	$this->OnAfterItemCreate($event);
	$object->SendEmailEvents();
	if( !$this->Application->IsAdmin() && ($event->status == erSUCCESS) && $event->redirect) $this->autoLoginUser($event);
	}
	}
	return $is_subscriber;
	}

	/**
	* Creates new user
	*
	* @param kEvent $event
	*/
	function OnCreate(&$event)
	{
	if( !$this->Application->IsAdmin() ) $this->setUserStatus($event);

	if( !$this->isSubscriberOnly($event) )
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnCreate($event);

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

	$this->Application->SetVar('u_id', $object->getID() );
	$this->Application->setUnitOption('u', 'AutoLoad', true);

	$this->setNextTemplate($event);

	if( !$this->Application->IsAdmin() && ($event->status == erSUCCESS) && $event->redirect)
	{
	$object->SendEmailEvents();
	$this->autoLoginUser($event);
	}
	}
	}

	/**
	* Set's new user status based on config options
	*
	* @param kEvent $event
	*/
	function setUserStatus(&$event)
	{
	$this->Application->setUnitOption($event->Prefix,'AutoLoad',false);
	$object =& $event->getObject();

	$new_users_allowed = $this->Application->ConfigValue('User_Allow_New');
	// 1 - Instant, 2 - Not Allowed, 3 - Pending

	switch ($new_users_allowed)
	{
	case 1: // Instant
	$object->SetDBField('Status', 1);
	$next_template = $this->Application->GetVar('registration_confirm_template');
	if($next_template) $event->redirect = $next_template;
	break;

	case 3: // Pending
	$next_template = $this->Application->GetVar('registration_confirm_pending_template');
	if($next_template) $event->redirect = $next_template;
	$object->SetDBField('Status', 2);
	break;

	case 2: // Not Allowed
	$object->SetDBField('Status', 0);
	break;
	}
	}




	/**
	* Set's new unique resource id to user
	*
	* @param kEvent $event
	*/
	function OnBeforeItemCreate(&$event)
	{
	$email_as_login = $this->Application->ConfigValue('Email_As_Login');
	$object =& $event->getObject();
	if ($email_as_login) {
	$object->Fields['Email']['error_msgs']['unique'] = $this->Application->Phrase('lu_user_and_email_already_exist');
	}

	}

	/**
	* Set's new unique resource id to user
	*
	* @param kEvent $event
	*/
	function OnAfterItemValidate(&$event)
	{
	$object =& $event->getObject();
	$object->SetDBField('ResourceId', $this->Application->NextResourceId() );
	}


	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnRecommend(&$event){

	$friend_email = $this->Application->GetVar('friend_email');
	$friend_name = $this->Application->GetVar('friend_email');

	if (preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $friend_email))
	{

	$send_params = array();
	$send_params['to_email']=$friend_email;
	$send_params['to_name']=$friend_name;

	$user_id = $this->Application->GetVar('u_id');
	$email_event = &$this->Application->EmailEventUser('SITE.SUGGEST', $user_id, $send_params);

	if ($email_event->status == erSUCCESS){
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = $this->Application->GetVar('template_success');
	}
	else {
	// $event->redirect_params = array('opener' => 's', 'pass' => 'all');
	// $event->redirect = $this->Application->GetVar('template_fail');
	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['send_error'] = $this->Application->Phrase('lu_email_send_error');
	$object->FieldErrors['Email']['pseudo'] = 'send_error';
	$event->status = erFAIL;

	}
	}
	else {
	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['invalid_email'] = $this->Application->Phrase('lu_InvalidEmail');
	$object->FieldErrors['Email']['pseudo'] = 'invalid_email';
	$event->status = erFAIL;
	}


	}

	/**
	* Saves address changes and mades no redirect
	*
	* @param kEvent $event
	*/
	function OnUpdateAddress(&$event)
	{
	$this->Application->setUnitOption($event->Prefix,'AutoLoad',false);
	$object =& $event->getObject();

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

	$event->redirect = false;
	}

	function OnSubscribeQuery(&$event){

	$user_email = $this->Application->GetVar('subscriber_email');
	if ( preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $user_email) ){

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

	$this->Application->StoreVar('SubscriberEmail', $user_email);

	if( $object->Load(array('Email'=>$user_email)) ){
	$group_info = $this->GetGroupInfo($object->GetID());
	if($group_info){
	$event->redirect = $this->Application->GetVar('unsubscribe_template');
	}
	else {
	$event->redirect = $this->Application->GetVar('subscribe_template');
	}
	}
	else {
	$event->redirect = $this->Application->GetVar('subscribe_template');
	$this->Application->StoreVar('SubscriberEmail', $user_email);
	}

	}
	else {

	$object =& $this->Application->recallObject('u');
	$object->ErrorMsgs['invalid_email'] = $this->Application->Phrase('lu_InvalidEmail');
	$object->FieldErrors['SubscribeEmail']['pseudo'] = 'invalid_email';
	$event->status = erFAIL;

	}


	//subscribe_query_ok_template
	}

	function OnSubscribeUser(&$event){

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

	$user_email = $this->Application->RecallVar('SubscriberEmail');

	if (preg_match("/^[_a-zA-Z0-9-\.]+@[a-zA-Z0-9-\.]+\.[a-z]{2,4}$/", $user_email)){

	if($object->Load(array('Email'=>$user_email))){

	$group_info = $this->GetGroupInfo($object->GetID());

	if ($group_info){
	if ($event->getEventParam('no_unsubscribe')) return;

	if ($group_info['PrimaryGroup']){
	// delete user
	$object->Delete();
	}
	else {
	$this->RemoveSubscriberGroup($object->GetID());
	}

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

	}
	else {
	$this->AddSubscriberGroup($object->GetID(), 0);
	$event->redirect = $this->Application->GetVar('subscribe_ok_template');
	}


	}
	else {

	$object->SetField('Email', $user_email);
	$object->SetField('Login', $user_email);
	$object->SetDBField('dob', 1);
	$object->SetDBField('dob_date', 1);
	$object->SetDBField('dob_time', 1);
	$ip = getenv('HTTP_X_FORWARDED_FOR')?getenv('HTTP_X_FORWARDED_FOR'):getenv('REMOTE_ADDR');
	$object->SetDBField('ip', $ip);

	$this->Application->SetVar('IsSubscriber', 1);

	if ($object->Create()) {

	$this->AddSubscriberGroup($object->GetID(), 1);
	$event->redirect = $this->Application->GetVar('subscribe_ok_template');
	}

	$this->Application->SetVar('IsSubscriber', 0);
	}
	}
	else {
	// error handling here
	$event->redirect = $this->Application->GetVar('subscribe_fail_template');
	}


	}

	function AddSubscriberGroup($user_id, $is_primary){

	$group_id = $this->Application->ConfigValue('User_SubscriberGroup');
	$sql = 'INSERT INTO '.TABLE_PREFIX.'UserGroup(PortalUserId,GroupId,PrimaryGroup) VALUES (%s,%s,'.$is_primary.')';
	$this->Conn->Query( sprintf($sql, $user_id, $group_id) );
	$this->Application->EmailEventAdmin('USER.SUBSCRIBE', $user_id);
	$this->Application->EmailEventUser('USER.SUBSCRIBE', $user_id);

	}

	function RemoveSubscriberGroup($user_id){

	$group_id = $this->Application->ConfigValue('User_SubscriberGroup');
	$sql = 'DELETE FROM '.TABLE_PREFIX.'UserGroup WHERE PortalUserId='.$user_id.' AND GroupId='.$this->Application->ConfigValue('User_SubscriberGroup');
	$this->Conn->Query($sql);
	$this->Application->EmailEventAdmin('USER.UNSUBSCRIBE', $user_id);
	$this->Application->EmailEventUser('USER.UNSUBSCRIBE', $user_id);

	}

	function GetGroupInfo($user_id){

	$group_info = $this->Conn->GetRow('SELECT * FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_id.'
	AND GroupId='.$this->Application->ConfigValue('User_SubscriberGroup'));
	return $group_info;

	}

	function OnForgotPassword(&$event){

	$this->Application->setUnitOption('u', 'AutoLoad', false);
	$user_object = &$this->Application->recallObject('u.forgot');
	$user_current_object = &$this->Application->recallObject('u');

	$username = $this->Application->GetVar('username');
	$email = $this->Application->GetVar('email');
	$found = false;
	$allow_reset = true;

	if( strlen($username) )
	{
	if( $user_object->Load(array('Login'=>$username)) )
	$found = ($user_object->GetDBField("Login")==$username && $user_object->GetDBField("Status")==1) && strlen($user_object->GetDBField("Password"));
	}
	else if( strlen($email) )
	{
	if( $user_object->Load(array('Email'=>$email)) )
	$found = ($user_object->GetDBField("Email")==$email && $user_object->GetDBField("Status")==1) && strlen($user_object->GetDBField("Password"));
	}

	if( $user_object->isLoaded() )
	{
	$PwResetConfirm = $user_object->GetDBField('PwResetConfirm');
	$PwRequestTime = $user_object->GetDBField('PwRequestTime');
	$PassResetTime = $user_object->GetDBField('PassResetTime');
	//$MinPwResetDelay = $user_object->GetDBField('MinPwResetDelay');
	$MinPwResetDelay = $this->Application->ConfigValue('Users_AllowReset');

	$allow_reset = (strlen($PwResetConfirm) ?
	mktime() > $PwRequestTime + $MinPwResetDelay :
	mktime() > $PassResetTime + $MinPwResetDelay);
	}

	if($found && $allow_reset)
	{
	$this->Application->StoreVar('tmp_user_id', $user_object->GetDBField("PortalUserId"));
	$this->Application->StoreVar('tmp_email', $user_object->GetDBField("Email"));

	//$this->Application->EmailEventUser('INCOMMERCEUSER.PSWDC', $user_object->GetDBField("PortalUserId"));

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

	}
	else
	{
	if(!strlen($username) && !strlen($email))
	{
	$user_current_object->ErrorMsgs['forgotpw_nodata'] = $this->Application->Phrase('lu_ferror_forgotpw_nodata');
	$user_current_object->FieldErrors['Login']['pseudo'] = 'lu_ferror_forgotpw_nodata';
	}
	else
	{

	if($allow_reset)
	{
	if( strlen($username) ){
	$user_current_object->ErrorMsgs['unknown_username'] = $this->Application->Phrase('lu_ferror_unknown_username');
	$user_current_object->FieldErrors['Login']['pseudo']='unknown_username';
	}
	if( strlen($email) ){
	$user_current_object->ErrorMsgs['unknown_email'] = $this->Application->Phrase('lu_ferror_unknown_email');
	$user_current_object->FieldErrors['Email']['pseudo']='unknown_email';
	}
	}
	else
	{
	$user_current_object->ErrorMsgs['reset_denied'] = $this->Application->Phrase('lu_ferror_reset_denied');
	if( strlen($username) ){
	$user_current_object->FieldErrors['Login']['pseudo']='reset_denied';
	}
	if( strlen($email) ){
	$user_current_object->FieldErrors['Email']['pseudo']='reset_denied';
	}
	}

	}

	if($user_current_object->FieldErrors){
	$event->redirect = false;
	}
	}

	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnResetPassword(&$event){

	$user_object = &$this->Application->recallObject('u.forgot');

	if($user_object->Load($this->Application->RecallVar('tmp_user_id'))){

	$this->Application->EmailEventUser('INCOMMERCEUSER.PSWDC', $user_object->GetDBField("PortalUserId"));
	$event->redirect = $this->Application->GetVar('template_success');

	$mod_object =& $this->Application->recallObject('mod.'.'In-Commerce');
	$m_cat_id = $mod_object->GetDBField('RootCat');
	$event->SetRedirectParam('pass', 'm');
	//$event->SetRedirectParam('m_cat_id', $m_cat_id);
	$this->Application->SetVar('m_cat_id', $m_cat_id);


	}

	}

	function OnResetPasswordConfirmed(&$event){

	$passed_key = $this->Application->GetVar('user_key');

	$user_object = &$this->Application->recallObject('u.forgot');
	$user_current_object = &$this->Application->recallObject('u');

	if (strlen(trim($passed_key)) == 0) {
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = false;

	$user_current_object->ErrorMsgs['code_is_not_valid'] = $this->Application->Phrase('lu_code_is_not_valid');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_is_not_valid';
	}


	if($user_object->Load(array('PwResetConfirm'=>$passed_key)))
	{
	$exp_time = $user_object->GetDBField('PwRequestTime') + 3600;
	$user_object->SetDBField("PwResetConfirm", '');
	$user_object->SetDBField("PwRequestTime", 0);
	if ($exp_time > mktime())
	{
	//$m_var_list_update['codevalidationresult'] = 'lu_resetpw_confirm_text';
	$newpw = makepassword4();

	$this->Application->StoreVar('password', $newpw);

	$user_object->SetDBField("Password",$newpw);
	$user_object->SetDBField("PassResetTime", time());
	$user_object->SetDBField("PwResetConfirm", '');
	$user_object->SetDBField("PwRequestTime", 0);
	$user_object->Update();

	$this->Application->SetVar('ForgottenPassword', $newpw);

	$email_event_user = &$this->Application->EmailEventUser('INCOMMERCEUSER.PSWD', $user_object->GetDBField('PortalUserId'));
	$email_event_admin = &$this->Application->EmailEventAdmin('INCOMMERCEUSER.PSWD');

	$this->Application->DeleteVar('ForgottenPassword');

	if ($email_event_user->status == erSUCCESS){
	$event->redirect_params = array('opener' => 's', 'pass' => 'all');
	$event->redirect = $this->Application->GetVar('template_success');
	}

	$user_object->SetDBField("Password",md5($newpw));
	$user_object->Update();

	} else {
	$user_current_object->ErrorMsgs['code_expired'] = $this->Application->Phrase('lu_code_expired');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_expired';
	$event->redirect = false;

	}
	} else {
	$user_current_object->ErrorMsgs['code_is_not_valid'] = $this->Application->Phrase('lu_code_is_not_valid');
	$user_current_object->FieldErrors['PwResetConfirm']['pseudo'] = 'code_is_not_valid';
	$event->redirect = false;

	}
	}

	function OnUpdate(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnUpdate($event);

	$this->setNextTemplate($event);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function setNextTemplate(&$event)
	{
	if( !$this->Application->IsAdmin() )
	{
	$event->redirect_params['opener'] = 's';
	$object =& $event->getObject();
	if($object->GetDBField('Status') == STATUS_ACTIVE)
	{
	$next_template = $this->Application->GetVar('next_template');
	if($next_template) $event->redirect = $next_template;
	}
	}
	}

	function OnCheckExpiredMembership(&$event)
	{
	$sql = 'SELECT PortalUserId FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
	$user_ids = $this->Conn->GetCol($sql);
	if(is_array($user_ids) && count($user_ids) > 0)
	{
	foreach($user_ids as $id)
	{
	$email_event_user =& $this->Application->EmailEventUser('USER.MEMBERSHIP.EXPIRED', $id);
	$email_event_admin =& $this->Application->EmailEventAdmin('USER.MEMBERSHIP.EXPIRED');
	}
	}
	$sql = 'DELETE FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.mktime();
	$this->Conn->Query($sql);

	$pre_expiration = mktime() + $this->Application->ConfigValue('User_MembershipExpirationReminder') * 3600 * 24;
	$sql = 'SELECT PortalUserId, GroupId FROM '.TABLE_PREFIX.'UserGroup
	WHERE MembershipExpires IS NOT NULL AND MembershipExpires < '.$pre_expiration.'
	AND ExpirationReminderSent = 0';
	$res = $this->Conn->Query($sql);
	if(is_array($res) && count($res) > 0)
	{
	$conditions = Array();
	foreach($res as $record)
	{
	$email_event_user =& $this->Application->EmailEventUser('USER.MEMBERSHIP.EXPIRATION_NOTICE', $record['PortalUserId']);
	$email_event_admin =& $this->Application->EmailEventAdmin('USER.MEMBERSHIP.EXPIRATION_NOTICE');
	$conditions[] = '(PortalUserId = '.$record['PortalUserId'].' AND GroupId = '.$record['GroupId'].')';
	}
	$sql = 'UPDATE '.TABLE_PREFIX.'UserGroup
	SET ExpirationReminderSent = 1
	WHERE '.implode(' OR ', $conditions);
	$this->Conn->Query($sql);
	}
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnRefreshForm(&$event)
	{
	$event->redirect = false;
	$item_info = $this->Application->GetVar($event->Prefix_Special);
	list($id, $fields) = each($item_info);

	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->setID($id);
	$object->IgnoreValidation = true;
	$object->SetFieldsFromHash($fields);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/users/users_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.35
	\ No newline at end of property
	+1.36
	\ No newline at end of property
	Index: trunk/core/units/email_events/email_events_event_handler.php
	===================================================================
	--- trunk/core/units/email_events/email_events_event_handler.php (revision 3030)
	+++ trunk/core/units/email_events/email_events_event_handler.php (revision 3031)
	@@ -1,213 +1,218 @@
	<?php

	class EmailEventsEventsHandler extends InpDBEventHandler
	{

	/**
	* 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();
	$this->Application->LinkVar('module', 'current_module');
	$module = $this->Application->GetVar('module');
	$object->addFilter('module_filter', '%1$s.Module = \''.$module.'\'');
	}
	}

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

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

	/**
	* Sets selected user to email events selected
	*
	* @param kEvent $event
	*/
	function OnSelectUser(&$event)
	{
	$user_name = $this->Application->GetVar( $event->getPrefixSpecial(true).'_PopupSelectedUser' );
	if( strlen($user_name) > 0 )
	{
	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	$ids = implode(',', $ids);

	$user_id = $this->Conn->GetOne('SELECT PortalUserId FROM '.TABLE_PREFIX.'PortalUser WHERE Login = '.$this->Conn->qstr($user_name) );

	$table = $this->Application->getUnitOption($event->Prefix,'TableName');
	$sql = 'UPDATE '.$table.' SET FromUserId = '.$user_id.' WHERE EventId IN ('.$ids.')';

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

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

	$this->Application->setUnitOption('emailmessages', 'AutoLoad', false);
	$message_object = &$this->Application->recallObject('emailmessages');

	$event_table = $this->Application->getUnitOption('emailevents', 'TableName');

	$event_object = &$event->getObject();
	$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 && defined("ADMIN")) return; // event only for front-end
	+ 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');
	$message_template = $message_object->GetDBField('Template');

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

	$old_autoload = $this->Application->getUnitOption('u', 'AutoLoad');
	$this->Application->setUnitOption('u', 'AutoLoad', false);

	$from_user_object = &$this->Application->recallObject('u.-item');
	$from_user_object->Load($from_user_id);
	// here if we don't have from_user loaded, it takes a default user from config values
	$from_user_email = $from_user_object->GetDBField('Email')?$from_user_object->GetDBField('Email'):$this->Application->ConfigValue('Smtp_AdminMailFrom');
	$from_user_name = trim($from_user_object->GetDBField('FirstName').' '.$from_user_object->GetDBField('LastName'));

	$to_user_object = &$this->Application->recallObject('u.-item');
	$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'));

	$this->Application->setUnitOption('u', 'AutoLoad', $old_autoload);

	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', '<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_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 = $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);
	}

	return $event;
	}
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/email_events/email_events_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.11
	\ No newline at end of property
	+1.12
	\ No newline at end of property
	Index: trunk/core/units/general/inp_ses_storage.php
	===================================================================
	--- trunk/core/units/general/inp_ses_storage.php (revision 3030)
	+++ trunk/core/units/general/inp_ses_storage.php (revision 3031)
	@@ -1,104 +1,105 @@
	<?php

	class InpSession extends Session
	{
	function Init($prefix,$special)
	{
	$this->SessionTimeout = $this->Application->ConfigValue('SessionTimeout');
	- if (BASE_PATH == '') {
	- $path = '/';
	- }
	- else {
	- $path = BASE_PATH;
	+
	+ $path = (BASE_PATH == '') ? '/' : BASE_PATH;
	+ if ( $this->Application->IsAdmin() ) $path = rtrim($path, '/').'/admin';
	+ $this->SetCookiePath($path);
	+
	+ $this->SetCookieName( $this->Application->ConfigValue('SessionCookieName') );
	+ $this->SetCookieDomain(SERVER_NAME);
	+
	+ if( $this->Application->IsAdmin() )
	+ {
	+ $mode = smAUTO;
	}
	- if ( defined('ADMIN') && ADMIN )
	+ else
	{
	- $path = rtrim($path, '/');
	- $path .= '/admin';
	+ $ses_mode = $this->Application->ConfigValue('CookieSessions');
	+ if ($ses_mode == 2) $mode = smAUTO;
	+ if ($ses_mode == 1) $mode = smCOOKIES_ONLY;
	+ if ($ses_mode == 0) $mode = smGET_ONLY;
	}
	- $this->SetCookiePath( $path );
	- $ses_mode = $this->Application->ConfigValue('CookieSessions');
	- if ($ses_mode == 2) $mode = smAUTO;
	- if ($ses_mode == 1) $mode = smCOOKIES_ONLY;
	- if ($ses_mode == 0) $mode = smGET_ONLY;
	- if ( defined('ADMIN') && ADMIN ) $mode = smAUTO;
	$this->SetMode($mode);
	- $this->SetCookieName( $this->Application->ConfigValue('SessionCookieName') );
	- $this->SetCookieDomain(SERVER_NAME);
	+
	parent::Init($prefix,$special);

	if( !$this->Application->IsAdmin() && $this->GetField('PortalUserId') <= 0 )
	{
	$group_list = $this->Application->ConfigValue('User_GuestGroup').','.$this->Application->ConfigValue('User_LoggedInGroup');
	$this->SetField('GroupList', $group_list);
	}
	}
	}

	class InpSessionStorage extends SessionStorage {

	function Init($prefix,$special)
	{
	parent::Init($prefix,$special);
	$this->setTableName(TABLE_PREFIX.'UserSession');
	$this->SessionDataTable = TABLE_PREFIX.'SessionData';
	$this->setIDField('SessionKey');
	$this->TimestampField = 'LastAccessed';
	$this->DataValueField = 'VariableValue';
	$this->DataVarField = 'VariableName';
	}

	function LocateSession($sid)
	{
	$query = ' SELECT '.$this->TimestampField.' FROM '.$this->TableName.' WHERE '.$this->IDField.' = '.$this->Conn->qstr($sid);
	$result = $this->Conn->GetOne($query);

	if($result===false) return false;

	$this->Expiration = $result + $this->SessionTimeout;
	return true;
	}

	function UpdateSession(&$session)
	{
	$query = ' UPDATE '.$this->TableName.' SET '.$this->TimestampField.' = unix_timestamp() WHERE '.$this->IDField.' = '.$this->Conn->qstr($session->SID);
	$this->Conn->Query($query);
	}


	function StoreSession(&$session)
	{
	parent::StoreSession($session);
	$this->SetField($session, 'IpAddress', $_SERVER['REMOTE_ADDR']);
	$this->SetField($session, 'GroupList', $this->Application->ConfigValue('User_GuestGroup'));
	}

	function GetExpiredSIDs()
	{
	$query = ' SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE '.time().' - '.$this->TimestampField.' > '.$this->SessionTimeout;
	$ret = $this->Conn->GetCol($query);
	if($ret) $this->DeleteEditTables();
	return $ret;

	}

	function DeleteEditTables()
	{
	$tables = $this->Conn->GetCol('SHOW TABLES');
	$mask_edit_table = '/'.TABLE_PREFIX.'ses_(.)_edit_(.)/';
	$mask_search_table = '/'.TABLE_PREFIX.'ses_(.)_(.)/';

	$sql='SELECT COUNT(*) FROM '.$this->TableName.' WHERE '.$this->IDField.' = \'%s\'';
	foreach($tables as $table)
	{
	if( preg_match($mask_edit_table,$table,$rets) \|\| preg_match($mask_search_table,$table,$rets) )
	{
	$sid=$rets[1];
	$is_alive = $this->Conn->GetOne( sprintf($sql,$sid) );
	if(!$is_alive) $this->Conn->Query('DROP TABLE IF EXISTS '.$table);
	}
	}
	}
	}

	?>
	\ No newline at end of file

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

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

	class kCatDBEventHandler extends InpDBEventHandler {

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

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

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

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

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

	//recalling by different name, because we may get kDBList, if we recall just by prefix
	$object =& $this->Application->recallObject($event->getPrefixSpecial().'.item', $event->Prefix);
	$this->prepareObject($object, $event);

	if ($this->Application->RecallVar($event->getPrefixSpecial().'_clipboard_mode') == 'copy') {
	$ids_arr = explode(',', $ids);

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

	if($ids_arr)
	{
	$temp->CloneItems($event->Prefix, $event->Special, $ids_arr);
	}
	}
	else { // mode == cut
	$ids_arr = explode(',', $ids);
	foreach ($ids_arr as $id) {
	$object->Load($id);
	$object->MoveToCat();
	}
	}
	$event->status = erSUCCESS;
	}

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

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

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


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

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

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

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

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnPreSaveAndOpenTranslator(&$event)
	{
	$this->Application->SetVar('allow_translation', true);
	$object =& $event->getObject();
	$this->RemoveRequiredFields($object);
	$event->CallSubEvent('OnPreSave');
	if ($event->status == erSUCCESS) {
	// $url = $this->Application->HREF($t, '', Array('pass'=>'all', $event->getPrefixSpecial(true).'_id' => $object->GetId()));
	// $field = $this->Application->GetVar('translator_field');
	$cf_id = $this->Application->GetVar('translator_cf_id');
	if($cf_id)
	{
	$cv =& $this->Application->recallObject('cv.-item', null, Array('skip_autoload' => true) );
	$load_params = Array('CustomFieldId' => $cf_id, 'ResourceId'=> $object->GetDBField('ResourceId') );
	if( !$cv->Load($load_params) )
	{
	$cv->SetFieldsFromHash($load_params);
	$cv->Create();
	}
	$this->Application->SetVar('cv_id', $cv->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'),
	);

	// 1. SAVE LAST TEMPLATE TO SESSION
	$last_template = $this->Application->RecallVar('last_template');
	preg_match('/index4\.php\\|'.$this->Application->GetSID().'-(.*):/U', $last_template, $rets);
	$this->Application->StoreVar('return_template', $rets[1]);

	//$after_script = "openTranslator('".$event->getPrefixSpecial()."', '".$field."', '".$url."', '".$wnd_name."')";
	}

	// $this->Application->SetVar('after_script', $after_script);
	// $event->redirect = false;
	}

	/**
	* Apply scope clause
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();

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

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

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

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

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function PrepareObject(&$object, &$event)
	{

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

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

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

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

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

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

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

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

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

	/**
	* 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->GetVar('sid').'_'.TABLE_PREFIX.'Search';

	$keywords = trim($this->Application->GetVar('keywords'));
	if( !$this->Application->GetVar('INPORTAL_ON') )
	{
	$keywords = unhtmlentities($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);

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

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

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

	$join_clauses = Array();

	// field processing
	$weight_sum = 0;
	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($options['formatter'] == 'kMultiLanguage')
	{
	$field_list[$key] = 'l'.$lang.'_'.$field;
	}

	// processing fields from other tables
	if($foreign_field = $search_config[$field]['ForeignField'])
	{
	$exploded = explode(':', $foreign_field, 2);
	if($exploded[0] == 'CALC')
	{
	unset($field_list[$key]);
	continue; // ignoring having type clauses in simple search
	/*$user_object =& $this->Application->recallObject('u');
	$user_groups = $user_object->GetDBField('PortalUserId') ?
	implode(',', $this->Conn->GetCol(' SELECT GroupId
	FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_object->GetDBField('PortalUserId'))) : 0;
	$having_list[$key] = str_replace('{PREFIX}', TABLE_PREFIX, $exploded[1]);
	$join_clause = str_replace('{PREFIX}', TABLE_PREFIX, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{USER_GROUPS}', $user_groups, $join_clause);
	$join_clause = ' LEFT JOIN '.$join_clause;
	$join_clauses[] = $join_clause;*/
	}
	else
	{
	$exploded = explode('.', $foreign_field);
	$foreign_table = TABLE_PREFIX.$exploded[0];

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

	$field_list[$key] = $alias.'.'.$exploded[1];
	$join_clause = str_replace('{ForeignTable}', $alias, $search_config[$field]['JoinClause']);
	$join_clause = str_replace('{LocalTable}', $product_table, $join_clause);
	if($search_config[$field]['CustomFieldId'])
	{
	$join_clause .= ' AND '.$alias.'.CustomFieldId='.$search_config[$field]['CustomFieldId'];
	}
	$join_clauses[] = ' LEFT JOIN '.$foreign_table.' '.$alias.'
	ON '.$join_clause;
	}
	}
	else
	{
	// processing fields from local table
	$field_list[$key] = $local_table.'.'.$field_list[$key];
	}
	}

	// keyword string processing
	$normal_keywords = Array();
	$plus_keywords = Array();
	$minus_keywords = Array();

	for($i = 0; $i < strlen($keywords); $i++)
	{
	if(substr($keywords, $i, 1) == ' ') continue;
	$extra_skip = 0;
	switch(substr($keywords, $i, 1))
	{
	case '+':
	if(substr($keywords, $i + 1, 1) == '"')
	{
	$keyword_start = $i + 2;
	$keyword_end = strpos($keywords, '"', $i + 2);
	$extra_skip = 2;
	}
	else
	{
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$extra_skip = 0;
	}
	$target_array =& $plus_keywords;
	break;
	case '-':
	if(substr($keywords, $i + 1, 1) == '"')
	{
	$keyword_start = $i + 2;
	$keyword_end = strpos($keywords, '"', $i + 2);
	$extra_skip = 2;
	}
	else
	{
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$extra_skip = 0;
	}
	$target_array =& $minus_keywords;
	break;
	case '"':
	$keyword_start = $i + 1;
	$keyword_end = strpos($keywords, '"', $i + 1);
	$extra_skip = 1;
	$target_array =& $normal_keywords;
	break;
	default:
	$keyword_start = $i;
	$keyword_end = strpos($keywords, ' ', $i + 1);
	$target_array =& $normal_keywords;
	}

	if($keyword_end === false)
	{
	$keyword_end = strlen($keywords);
	}
	$keyword_length = $keyword_end - $keyword_start;
	$keyword = substr($keywords, $keyword_start, $keyword_length);

	if(strlen($keyword) >= $this->Application->ConfigValue('Search_MinKeyword_Length'))
	{
	$target_array[] = addcslashes($keyword, '"');
	}

	$i += $keyword_length + $extra_skip;
	}

	// preparing conditions
	$normal_conditions = Array();
	$plus_conditions = Array();
	$minus_conditions = Array();
	foreach($normal_keywords as $keyword)
	{
	$normal_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $field_list).' LIKE "%'.$keyword.'%"';
	}
	foreach($plus_keywords as $keyword)
	{
	$plus_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $field_list).' LIKE "%'.$keyword.'%"';
	}
	foreach($minus_keywords as $keyword)
	{
	foreach($field_list as $field)
	{
	$condition[] = $field.' NOT LIKE "%'.$keyword.'%" OR '.$field.' IS NULL';
	}
	$minus_conditions[] = '('.implode(') AND (', $condition).')';
	}

	// building where clause
	if($normal_conditions)
	{
	$where_clause = '('.implode(') OR (', $normal_conditions).')';
	}
	else
	{
	$where_clause = '1';
	}
	if($plus_conditions)
	{
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $plus_conditions).')';
	}
	if($minus_conditions)
	{
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $minus_conditions).')';
	}
	$where_clause = $where_clause.' AND '.$product_table.'.Status=1';

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

	// building having clause


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

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

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

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

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

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

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

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

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

	$keywords = $this->Application->GetVar('value');
	$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;
	$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($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 = $user_object->GetDBField('PortalUserId') ?
	implode(',', $this->Conn->GetCol(' SELECT GroupId
	FROM '.TABLE_PREFIX.'UserGroup
	WHERE PortalUserId='.$user_object->GetDBField('PortalUserId'))) : 0;
	$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];

	$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
	$field_name = $local_table.'.'.$field_name;
	}

	$condition = '';
	switch($record['FieldType'])
	{
	case 'text':
	if( !$this->Application->GetVar('INPORTAL_ON') )
	{
	$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 = 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 = 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;
	}
	}
	}
	}

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

	// making relevance clause
	if($relevance_parts)
	{
	$rel_keywords = $this->Application->ConfigValue('SearchRel_DefaultKeyword_products') / 100;
	$rel_pop = $this->Application->ConfigValue('SearchRel_DefaultPop_products') / 100;
	$rel_rating = $this->Application->ConfigValue('SearchRel_DefaultRating_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->GetVar('sid').'_'.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);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/general/cat_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.10
	\ No newline at end of property
	+1.11
	\ 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