in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Thu, Feb 6, 3:51 AM

in-portal
View Options

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

	class SkinEventHandler extends kDBEventHandler {

	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array (
	'OnItemBuild' => Array ('self' => true),
	);

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

	/**
	* With "primary" special loads primary skin
	*
	* @param kEvent $event
	* @return int
	*/
	function getPassedID(&$event)
	{
	if ($event->Special == 'primary') {
	return Array ('IsPrimary' => 1);
	}

	return parent::getPassedID($event);
	}

	/**
	* Allows to set selected theme as primary
	*
	* @param kEvent $event
	*/
	function OnSetPrimary(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	$ids = $this->StoreSelectedIDs($event);
	if ($ids) {
	$id = array_shift($ids);
	$this->setPrimary($id);
	}

	$this->clearSelectedIDs($event);
	}

	function setPrimary($id)
	{
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField');
	$table_name = $this->Application->getUnitOption($this->Prefix, 'TableName');

	$sql = 'UPDATE '.$table_name.'
	SET IsPrimary = 0';
	$this->Conn->Query($sql);


	$sql = 'UPDATE '.$table_name.'
	SET IsPrimary = 1
	WHERE '.$id_field.' = '.$id;
	$this->Conn->Query($sql);
	}


	/**
	* [HOOK] Compile stylesheet file based on theme definitions
	*
	* @param kEvent $event
	*/
	function OnCompileStylesheet(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SwitchToLive();

	$ids = $event->MasterEvent->getEventParam('ids');
	- if (!is_array($ids)) $ids = explode(',', $ids);
	-
	- if(!$ids) return false;
	- foreach($ids as $id)
	- {
	- $object->Load($id);
	- $this->Compile($object);
	+ if (!is_array($ids)) {
	+ $ids = explode(',', $ids);
	}
	- }

	- function Compile(&$object)
	- {
	- $ret = $object->GetDBField('CSS');
	- $options = $object->GetDBField('Options');
	- $options = unserialize($options);
	- $options['base_url'] = array('Value'=>rtrim($this->Application->BaseURL(), '/'));
	- foreach ($options as $key => $row) {
	- $ret = str_replace('@@'.$key.'@@', $row['Value'], $ret);
	- }
	-
	- $compile_ts = adodb_mktime();
	- $css_path = WRITEABLE . '/user_files/';
	-
	- $css_file = $css_path.'admin-'.mb_strtolower($object->GetDBField('Name')).'-'.$compile_ts.'.css';
	-
	- $fp = fopen($css_file,'w');
	- if($fp)
	- {
	- $prev_css = $css_path.'admin-'.mb_strtolower($object->GetDBField('Name')).'-'.$object->GetDBField('LastCompiled').'.css';
	- if( file_exists($prev_css) ) unlink($prev_css);
	+ if (!$ids) {
	+ return false;
	+ }

	- fwrite($fp, $ret);
	- fclose($fp);
	+ $skin_helper =& $this->Application->recallObject('SkinHelper');
	+ /* @var $skin_helper SkinHelper */

	- $sql = 'UPDATE '.$object->TableName.' SET LastCompiled = '.$compile_ts.' WHERE '.$object->IDField.' = '.$object->GetID();
	- $this->Conn->Query($sql);
	+ foreach($ids as $id) {
	+ $object->Load($id);
	+ $skin_helper->compile($object);
	}
	}
	}
	\ No newline at end of file
	Index: branches/5.0.x/core/units/configuration/configuration_event_handler.php
	===================================================================
	--- branches/5.0.x/core/units/configuration/configuration_event_handler.php (revision 12232)
	+++ branches/5.0.x/core/units/configuration/configuration_event_handler.php (revision 12233)
	@@ -1,230 +1,255 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.net/license/ for copyright notices and details.
	*/

	class ConfigurationEventHandler extends kDBEventHandler {

	-
	/**
	* Changes permission section to one from REQUEST, not from config
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	$event->setEventParam('PermSection', $this->Application->GetVar('section'));
	return parent::CheckPermission($event);
	}

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

	$module = $this->Application->GetVar('module');
	$section = $this->Application->GetVar('section');

	$object->addFilter('module_filter', '%1$s.ModuleOwner = '.$this->Conn->qstr($module));
	$object->addFilter('section_filter', '%1$s.Section = '.$this->Conn->qstr($section));

	if (defined('IS_INSTALL') && IS_INSTALL) {
	$object->addFilter('install_filter', 'ca.Install = 1');
	}
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();

	// if password field is empty, then don't update
	if ($object->GetDBField('element_type') == 'password') {
	if (trim($object->GetDBField('VariableValue')) == '') {
	$field_options = $object->GetFieldOptions('VariableValue');
	$field_options['skip_empty'] = 1;
	$object->SetFieldOptions('VariableValue', $field_options);
	}else {
	$password_formatter =& $this->Application->recallObject('kPasswordFormatter');
	$object->SetDBField('VariableValue', $password_formatter->EncryptPassword($object->GetDBField('VariableValue'), 'b38'));
	}
	}

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

	- $state_country_hash = Array(
	- 'Comm_State' => 'Comm_Country',
	- 'Comm_Shipping_State' => 'Comm_Shipping_Country'
	- );
	+ $state_country_hash = Array (
	+ 'Comm_State' => 'Comm_Country',
	+ 'Comm_Shipping_State' => 'Comm_Shipping_Country'
	+ );

	$field_name = $object->GetDBField('VariableName');
	- if (isset($state_country_hash[$field_name])) {
	+ if (array_key_exists($field_name, $state_country_hash)) {
	// if this is state field
	$check_state = $object->GetDBField('VariableValue');
	$check_country = $field_values[ $state_country_hash[$field_name] ]['VariableValue'];

	if (!($check_country && $check_state)) {
	return true;
	}

	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$state_iso = $cs_helper->CheckState($check_state, $check_country);
	if ($state_iso !== false) {
	$object->SetDBField('VariableValue', $state_iso);
	}
	- else
	- {
	+ else {
	$errormsgs = $this->Application->GetVar('errormsgs');
	$errors = !$errormsgs \|\| !isset($errormsgs[$event->Prefix_Special]) ? Array() : $errormsgs[$event->Prefix_Special];

	$errors[$field_name] = 'la_InvalidState';
	$errormsgs[$event->Prefix_Special] = $errors;

	$this->Application->SetVar('errormsgs', $errormsgs);
	$event->status = erFAIL;
	}
	}
	-
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function OnAfterItemUpdate(&$event)
	{
	$object =& $event->getObject();
	+ /* @var $object kDBItem */
	+
	if ($object->GetDBField('element_type') == 'password') {
	if (trim($object->GetDBField('VariableValue')) == '') {
	$field_options = $object->GetFieldOptions('VariableValue');
	unset($field_options['skip_empty']);
	$object->SetFieldOptions('VariableValue', $field_options);
	}
	}
	+
	+ // allows to check if variable's value was changed now
	+ $variable_name = $object->GetDBField('VariableName');
	+ $variable_value = $object->GetDBField('VariableValue');
	+ $watch_variables = Array ('Require_AdminSSL', 'AdminSSL_URL', 'AdvancedUserManagement', 'Site_Name');
	+
	+ if (in_array($variable_name, $watch_variables)) {
	+ $changed = $this->Application->GetVar($event->getPrefixSpecial() . '_changed', Array ());
	+
	+ if ($variable_value != $object->GetOriginalField('VariableValue')) {
	+ $changed[$variable_name] = $variable_value;
	+ $this->Application->SetVar($event->getPrefixSpecial() . '_changed', $changed);
	+ }
	+
	+ switch ($variable_name) {
	+ case 'Require_AdminSSL':
	+ case 'AdminSSL_URL':
	+ static $skin_deleted = false;
	+
	+ if (array_key_exists($variable_name, $changed) && !$skin_deleted) {
	+ // when administrative console is moved to SSL mode, then delete skin
	+ $skin_helper =& $this->Application->recallObject('SkinHelper');
	+ /* @var $skin_helper SkinHelper */
	+
	+ $skin_file = $skin_helper->getSkinPath();
	+ if (file_exists($skin_file)) {
	+ unlink($skin_file);
	+ }
	+
	+ $skin_deleted = true;
	+ }
	+ break;
	+ }
	+ }
	+
	}

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

	// 1. save user selected module root category
	$items_info = $this->Application->GetVar($event->getPrefixSpecial(true));
	$new_category_id = getArrayValue($items_info, 'ModuleRootCategory', 'VariableValue');
	if ($new_category_id !== false) {
	unset($items_info['ModuleRootCategory']);
	$this->Application->SetVar($event->getPrefixSpecial(true), $items_info);
	}

	parent::OnUpdate($event);

	if ($event->status == erSUCCESS && $new_category_id !== false) {
	// root category was submitted
	$module = $this->Application->GetVar('module');
	$root_category_id = $this->Application->findModule('Name', $module, 'RootCat');

	if ($root_category_id != $new_category_id) {
	// root category differs from one in db
	$fields_hash = Array('RootCat' => $new_category_id);
	$this->Conn->doUpdate($fields_hash, TABLE_PREFIX.'Modules', 'Name = '.$this->Conn->qstr($module));
	}
	}

	if ($event->status == erSUCCESS) { // reset cache
	- $refresh_sections = false;
	- if ($items_info) {
	- $id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	- $table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	-
	- $sql = 'SELECT ' . $id_field . '
	- FROM ' . $table_name . '
	- WHERE ' . $id_field . ' IN (' . implode(',', array_keys($items_info)) . ') AND (VariableName = "AdvancedUserManagement")';
	- $refresh_sections = $this->Conn->GetCol($sql);
	- }
	+ $changed = $this->Application->GetVar($event->getPrefixSpecial() . '_changed', Array ());
	+ $refresh_sections = array_key_exists('AdvancedUserManagement', $changed) \|\| array_key_exists('Site_Name', $changed);

	if ($refresh_sections) {
	// reset sections too, because of AdvancedUserManagement
	$event->SetRedirectParam('refresh_tree', 1);
	}

	$this->Application->UnitConfigReader->ResetParsedData($refresh_sections ? true : false);
	}
	}

	if ($this->Application->GetVar('errormsgs')) {
	// because we have list out there, and this is item
	$this->Application->removeObject($event->getPrefixSpecial());
	$event->redirect = false;
	}

	// keeps module and section in REQUEST to ensure, that last admin template will work
	$event->SetRedirectParam('module', $this->Application->GetVar('module'));
	$event->SetRedirectParam('section', $this->Application->GetVar('section'));
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	/*function OnChangeCountry(&$event)
	{
	$event->setPseudoClass('_List');
	$object = &$event->getObject( Array('per_page'=>-1) );
	$object->Query();
	$array_records =& $object->Records;
	foreach($array_records as $i=>$record){
	if ($record['VariableName']=='Comm_Country'){
	$values = $this->Application->GetVar('conf');
	$array_records[$i]['VariableValue'] = $values['Comm_Country']['VariableValue'];
	}
	}

	$event->redirect_params = Array('opener' => 's', 'pass'=>'all,conf'); //stay!
	$event->redirect = false;
	}*/

	/**
	* Process items from selector (selected_ids var, key - prefix, value - comma separated ids)
	*
	* @param kEvent $event
	*/
	function OnProcessSelected(&$event)
	{
	$selected_ids = $this->Application->GetVar('selected_ids');
	$this->Application->StoreVar('ModuleRootCategory', $selected_ids['c']);

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

	}



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

	class AdminTagProcessor extends kDBTagProcessor {

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

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

	/**
	* Returns section title with #section# keyword replaced with current section
	*
	* @param Array $params
	* @return string
	*/
	function GetSectionTitle($params)
	{
	if (array_key_exists('default', $params)) {
	return $params['default'];
	}

	return $this->Application->Phrase( replaceModuleSection($params['phrase']) );
	}

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

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

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

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

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

	$debug_mode = $this->Application->isDebugMode();
	$super_admin_mode = $this->Application->RecallVar('super_admin');

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

	if (isset($section_data['show_mode']) && is_numeric($section_data['show_mode'])) {
	$show_mode = $section_data['show_mode'];
	// if super admin section -> show in super admin mode & debug mode
	$show_section = $show_mode == smNORMAL \|\| ((($show_mode & smSUPER_ADMIN) == smSUPER_ADMIN) && ($super_admin_mode \|\| $debug_mode));
	if (!$show_section) {
	// if section is in debug mode only && debug mode -> show
	$show_section = (($show_mode & smDEBUG) == smDEBUG) && $debug_mode;
	}
	if (!$show_section) {
	continue;
	}
	}

	$params['section_name'] = $section_name;
	$ret .= $this->DrawTree($params);
	$deep_level--;
	}


	return $ret;
	}


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

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	/* @var $sections_helper kSectionsHelper */

	$section_data =& $sections_helper->getSectionData($section);
	if (!$section_data) {
	trigger_error('Use of undefined section "<strong>' . $section . '</strong>" in "<strong>' . __METHOD__ . '</strong>"', E_USER_ERROR);
	return '';
	}


	if (array_key_exists('parent', $params) && $params['parent']) {
	do {
	$section = $section_data['parent'];
	$section_data =& $sections_helper->getSectionData($section);
	} while (array_key_exists('use_parent_header', $section_data) && $section_data['use_parent_header']);
	}

	$info = $params['info'];
	switch ($info) {
	case 'module_path':
	if (isset($params['module']) && $params['module']) {
	$module = $params['module'];
	}
	elseif (isset($section_data['icon_module'])) {
	$module = $section_data['icon_module'];
	}
	else {
	$module = '#session#';
	}
	$res = $this->ModulePath(array('module' => $module));
	break;

	case 'perm_section':
	$res = $sections_helper->getPermSection($section);
	break;

	case 'label':
	$res = $section_data['label'];
	if ($section != 'in-portal:root') {
	// don't translate label for top section, because it's already translated
	$res = $this->Application->Phrase($res);
	}
	break;

	default:
	$res = $section_data[$info];
	break;
	}

	if (array_key_exists('as_label', $params) && $params['as_label']) {
	$res = $this->Application->Phrase($res);
	}

	return $res;
	}


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

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	/* @var $sections_helper kSectionsHelper */

	if (isset($params['use_first_child']) && $params['use_first_child']) {
	$section_name = $sections_helper->getFirstChild($section_name, true);
	}

	$section_data =& $sections_helper->getSectionData($section_name);

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

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

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

	return $ret;
	}

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

	$sections_helper =& $this->Application->recallObject('SectionsHelper');
	/* @var $sections_helper kSectionsHelper */

	$section_data =& $sections_helper->getSectionData($section_name);

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

	$debug_mode = $this->Application->isDebugMode();
	$super_admin_mode = $this->Application->RecallVar('super_admin');

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

	if (isset($section_data['show_mode']) && is_numeric($section_data['show_mode'])) {
	$show_mode = $section_data['show_mode'];
	// if super admin section -> show in super admin mode & debug mode
	$show_section = $show_mode == smNORMAL \|\| ((($show_mode & smSUPER_ADMIN) == smSUPER_ADMIN) && ($super_admin_mode \|\| $debug_mode));
	if (!$show_section) {
	// if section is in debug mode only && debug mode -> show
	$show_section = (($show_mode & smDEBUG) == smDEBUG) && $debug_mode;
	}
	if (!$show_section) {
	continue;
	}
	}

	if (isset($section_data['tabs_only']) && $section_data['tabs_only']) {
	$perm_status = false;
	$folder_label = $section_data['label'];
	ksort($section_data['children'], SORT_NUMERIC);
	foreach ($section_data['children'] as $priority => $section_name) {
	// if only tabs in this section & none of them have permission, then skip section too

	$section_name = $sections_helper->getPermSection($section_name);
	$perm_status = $this->Application->CheckPermission($section_name.'.view', 1);
	if ($perm_status) {
	break;
	}
	}
	if (!$perm_status) {
	// no permission for all tabs -> don't display tree node either
	continue;
	}

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

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

	// remove template, so it doesn't appear as additional parameter in url
	$template = $section_data['url']['t'];
	unset($section_data['url']['t']);

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

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

	// restore template
	$section_data['url']['t'] = $template;

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

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

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

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

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

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

	$m =& $this->Application->recallObject('m_TagProcessor');
	return $m->ModuleInclude($params);
	}

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

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

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

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

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


	return $ret;
	}

	/**
	* Returns list of module item tabs that have view permission in current category
	*
	* @param Array $params
	*/
	function ListCatalogTabs($params)
	{
	$ret = '';
	$special = isset($params['special']) ? $params['special'] : '';
	$replace_main = isset($params['replace_m']) && $params['replace_m'];
	$skip_prefixes = isset($params['skip_prefixes']) ? explode(',', $params['skip_prefixes']) : Array();

	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['render_as'];

	foreach ($this->Application->ModuleInfo as $module_name => $module_info) {
	$prefix = $module_info['Var'];

	if ($prefix == 'm' && $replace_main) {
	$prefix = 'c';
	}

	if (in_array($prefix, $skip_prefixes) \|\| !$this->Application->prefixRegistred($prefix) \|\| !$this->Application->getUnitOption($prefix, 'CatalogItem')) {
	continue;
	}

	$icon = $this->Application->getUnitOption($prefix, 'CatalogTabIcon');
	if (strpos($icon, ':') !== false) {
	list ($icon_module, $icon) = explode(':', $icon, 2);
	}
	else {
	$icon_module = 'core';
	}

	$label = $this->Application->getUnitOption($prefix, $params['title_property']);
	$block_params['title'] = $label;
	$block_params['prefix'] = $prefix;
	$block_params['icon_module'] = $icon_module;
	$block_params['icon'] = $icon;
	$ret .= $this->Application->ParseBlock($block_params);
	}
	return $ret;
	}

	/**
	* Renders inividual catalog tab based on prefix and title_property given
	*
	* @param Array $params
	* @return string
	*/
	function CatalogTab($params)
	{
	$icon = $this->Application->getUnitOption($params['prefix'], 'CatalogTabIcon');
	if (strpos($icon, ':') !== false) {
	list ($icon_module, $icon) = explode(':', $icon, 2);
	}
	else {
	$icon_module = 'core';
	}

	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['render_as'];
	$block_params['icon_module'] = $icon_module;
	$block_params['icon'] = $icon;
	$block_params['title'] = $this->Application->getUnitOption($params['prefix'], $params['title_property']);

	return $this->Application->ParseBlock($block_params);
	}

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

	$params['t'] = 'catalog/item_selector/item_selector_'.$mode;
	$params['m_cat_id'] = $this->Application->findModule('Name', 'Core', 'RootCat');

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

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

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

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

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

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

	$main_processor =& $this->Application->recallObject('m_TagProcessor');
	return $main_processor->T($params);
	}

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

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

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

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

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

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


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

	return $timestamp;

	}

	/**
	* Redirect to cache rebuild template, when required by installator
	*
	* @param Array $params
	*/
	function CheckPermCache($params)
	{
	// we have separate session between install wizard and admin console, so store in cache
	$sql = 'SELECT Data
	FROM '.TABLE_PREFIX.'Cache
	WHERE VarName = "ForcePermCacheUpdate"';
	$global_mark = $this->Conn->GetOne($sql);

	$local_mark = $this->Application->RecallVar('PermCache_UpdateRequired');

	if ($global_mark \|\| $local_mark) {
	$this->Application->RemoveVar('PermCache_UpdateRequired');

	if ($this->Application->ConfigValue('QuickCategoryPermissionRebuild')) {
	$updater =& $this->Application->recallObject('kPermCacheUpdater');
	/* @var $updater kPermCacheUpdater */

	$updater->OneStepRun();
	}
	else {
	// update with progress bar
	return true;
	}
	}

	return false;
	}

	/**
	* Checks if current protocol is SSL
	*
	* @param Array $params
	* @return int
	*/
	function IsSSL($params)
	{
	return (PROTOCOL == 'https://')? 1 : 0;
	}

	function PrintColumns($params)
	{
	$picker_helper =& $this->Application->RecallObject('ColumnPickerHelper');
	$picker_helper->SetGridName($this->Application->GetLinkedVar('grid_name'));
	/* @var $picker_helper kColumnPickerHelper */

	$main_prefix = $this->Application->RecallVar('main_prefix');
	$cols = $picker_helper->LoadColumns($main_prefix);

	$this->Application->Phrases->AddCachedPhrase('__FREEZER__', '-------------');

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

	/**
	* Allows to set popup size (key - current template name)
	*
	* @param Array $params
	*/
	function SetPopupSize($params)
	{
	$width = $params['width'];
	$height = $params['height'];

	if ($this->Application->GetVar('ajax') == 'yes') {
	// during AJAX request just output size
	die($width.'x'.$height);
	}

	if (!$this->UsePopups($params)) {
	return ;
	}

	$t = $this->Application->GetVar('t');
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'PopupSizes
	WHERE TemplateName = '.$this->Conn->qstr($t);
	$popup_info = $this->Conn->GetRow($sql);
	if (!$popup_info) {
	// create new popup size record
	$fields_hash = Array (
	'TemplateName' => $t,
	'PopupWidth' => $width,
	'PopupHeight' => $height,
	);
	$this->Conn->doInsert($fields_hash, TABLE_PREFIX.'PopupSizes');
	}
	elseif ($popup_info['PopupWidth'] != $width \|\| $popup_info['PopupHeight'] != $height) {
	// popup found and size in tag differs from one in db -> update in db
	$fields_hash = Array (
	'PopupWidth' => $width,
	'PopupHeight' => $height,
	);
	$this->Conn->doUpdate($fields_hash, TABLE_PREFIX.'PopupSizes', 'PopupId = '.$popup_info['PopupId']);
	}
	}

	/**
	* Returns popup size (by template), if not cached, then parse template to get value
	*
	* @param Array $params
	* @return string
	*/
	function GetPopupSize($params)
	{
	$t = $this->Application->GetVar('template_name');
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'PopupSizes
	WHERE TemplateName = '.$this->Conn->qstr($t);
	$popup_info = $this->Conn->GetRow($sql);
	if (!$popup_info) {
	$this->Application->InitParser();
	$this->Application->ParseBlock(array('name' => $t)); // dies when SetPopupSize tag found & in ajax requrest
	return '750x400'; // tag SetPopupSize not found in template -> use default size
	}
	return $popup_info['PopupWidth'].'x'.$popup_info['PopupHeight'];
	}

	function UsePopups($params)
	{
	return (int)$this->Application->ConfigValue('UsePopups') \|\| $this->Application->GetVar('_force_popup');
	}

	function UseToolbarLabels($params)
	{
	return (int)$this->Application->ConfigValue('UseToolbarLabels');
	}

	/**
	* Checks if debug mode enabled (optionally) and specified constant is on
	*
	* @param Array $params
	* @return bool
	*/
	function ConstOn($params)
	{
	$constant_name = $this->SelectParam($params, 'name,const');
	$debug_mode = isset($params['debug_mode']) && $params['debug_mode'] ? $this->Application->isDebugMode() : true;
	return $debug_mode && constOn($constant_name);
	}

	/**
	* Builds link to last template in main frame of admin
	*
	* @param Array $params
	* @return string
	*/
	function MainFrameLink($params)
	{
	$persistent = isset($params['persistent']) && $params['persistent'];
	if ($persistent && $this->Application->ConfigValue('RememberLastAdminTemplate')) {
	// check last_template in persistent session
	$last_template = $this->Application->RecallPersistentVar('last_template_popup');
	}
	else {
	// check last_template in session
	$last_template = $this->Application->RecallVar('last_template_popup'); // because of m_opener=s there
	}

	if (!$last_template) {
	$params['persistent'] = 1;
	return $persistent ? false : $this->MainFrameLink($params);
	}

	list($index_file, $env) = explode('\|', $last_template);
	$vars = $this->Application->HttpQuery->processQueryString($env, 'pass');
	$recursion_templates = Array ('login', 'index', 'no_permission');

	if (isset($vars['admin']) && $vars['admin'] == 1) {
	// index template doesn't begin recursion on front-end (in admin frame)
	$vars['m_theme'] = '';

	if (isset($params['m_opener']) && $params['m_opener'] == 'r') {
	// front-end link for highlighting purposes
	$vars['t'] = 'index';
	$vars['m_cat_id'] = $this->Application->findModule('Name', 'Core', 'RootCat');
	}

	unset($recursion_templates[ array_search('index', $recursion_templates)]);
	}

	if (in_array($vars['t'], $recursion_templates)) {
	// prevents redirect recursion OR old in-portal pages
	$params['persistent'] = 1;
	return $persistent ? false : $this->MainFrameLink($params);
	}

	$vars = array_merge_recursive2($vars, $params);
	$t = $vars['t'];
	unset($vars['t'], $vars['persistent']);

	// substitute language in link to current (link will work, even when language will be changed)
	$vars['m_lang'] = $this->Application->GetVar('m_lang');

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

	/**
	* Returns menu frame width or 200 in case, when invalid width specified in config
	*
	* @param Array $params
	* @return string
	*/
	function MenuFrameWidth($params)
	{
	$width = (int)$this->Application->ConfigValue('MenuFrameWidth');

	return $width > 0 ? $width : 200;
	}

	function AdminSkin($params)
	{
	- static $style;
	- if (!isset($style)) {
	- $style = $this->Conn->GetRow('SELECT * FROM '.TABLE_PREFIX.'Skins WHERE IsPrimary = 1');
	- }
	-
	- $css_path = WRITEABLE . DIRECTORY_SEPARATOR . 'user_files';
	- $css_url = $this->Application->BaseURL( str_replace(DIRECTORY_SEPARATOR, '/', WRITEBALE_BASE) ) . 'user_files/';
	-
	- $type = array_key_exists('type', $params) ? $params['type'] : false;
	- if ($type == 'logo') {
	- $type = 'Logo';
	- }
	-
	- if ($type == 'Logo' \|\| $type == 'LogoBottom' \|\| $type == 'LogoLogin') {
	- return $style[$type] ? $css_url.$style[$type] : '';
	- }
	-
	- $last_compiled = $style['LastCompiled'];
	-
	- $style_name = mb_strtolower( $style['Name'] );
	-
	- if( file_exists($css_path . '/' . 'admin-' . $style_name . '-' . $last_compiled . '.css') )
	- {
	- $ret = $css_url.'admin-'.$style_name.'-'.$last_compiled.'.css';
	-
	- }
	- else
	- {
	- // search for previously compiled stylesheet
	- $last_compiled = 0;
	- if( $dh = opendir($css_path) )
	- {
	- while( ($file = readdir($dh)) !== false )
	- {
	- if( preg_match('/admin-(.*)-([\d]+).css/', $file, $rets) )
	- {
	- if( $rets[1] == $style_name && $rets[2] > $last_compiled ) $last_compiled = $rets[2];
	- }
	- }
	- closedir($dh);
	- }
	- if ($last_compiled) {
	- // found
	- $ret = $css_url.'admin-'.$style_name.'-'.$last_compiled.'.css';
	- }
	- else {
	- // not found (try to compile on the fly)
	- $object =& $this->Application->recallObject('skin.-item', null, Array ('skip_autoload' => true));
	- /* @var $object kDBItem */
	-
	- $skin_eh =& $this->Application->recallObject('skin_EventHandler');
	- /* @var $skin_eh SkinEventHandler */
	-
	- $object->Load(1, 'IsPrimary');
	- $skin_eh->Compile($object);
	- $ret = $css_url.'admin-'.$style_name.'-'.adodb_mktime().'.css';
	- }
	- }
	-
	- if (isset($params['file_only'])) return $ret;
	+ $skin_helper =& $this->Application->recallObject('SkinHelper');
	+ /* @var $skin_helper SkinHelper */

	- return '<link rel="stylesheet" rev="stylesheet" href="'.$ret.'" type="text/css" media="screen" />';
	+ return $skin_helper->AdminSkinTag($params);
	}

	function PrintCompileErrors($params)
	{
	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['render_as'];

	$errors = $this->Application->RecallVar('compile_errors');
	if (!$errors) {
	return ;
	}

	$ret = '';
	$errors = unserialize($errors);

	foreach ($errors as $an_error) {
	$block_params['file'] = str_replace(FULL_PATH, '', $an_error['file']);
	$block_params['line'] = $an_error['line'];
	$block_params['message'] = $an_error['msg'];

	$ret .= $this->Application->ParseBlock($block_params);
	}

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

	return $ret;
	}

	function CompileErrorCount($params)
	{
	$errors = $this->Application->RecallVar('compile_errors');
	if (!$errors) {
	return 0;
	}

	return count( unserialize($errors) );
	}

	function ExportData($params)
	{
	$export_helper =& $this->Application->recallObject('CSVHelper');
	/* @var $export_helper kCSVHelper */
	$result = $export_helper->ExportData( $this->SelectParam($params, 'var,name,field') );
	return ($result === false) ? '' : $result;
	}

	function ImportData($params)
	{
	$import_helper =& $this->Application->recallObject('CSVHelper');
	/* @var $import_helper kCSVHelper */
	$result = $import_helper->ImportData( $this->SelectParam($params, 'var,name,field') );
	return ($result === false) ? '' : $result;
	}

	function PrintCSVNotImportedLines($params)
	{
	$import_helper =& $this->Application->recallObject('CSVHelper');
	/* @var $import_helper kCSVHelper */
	return $import_helper->GetNotImportedLines();
	}

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

	$ret = $this->getPrefixSpecial().'[0]['.$field.']'; // 0 always, as has no idfield
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	/**
	* Returns list of all backup file dates formatted
	* in passed block
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintBackupDates($params)
	{
	$datearray = $this->getDirList($this->Application->ConfigValue('Backup_Path'));
	$ret = '';
	foreach($datearray as $key => $value)
	{
	$params['backuptimestamp'] = $value['filedate'];
	$params['backuptime'] = date('F j, Y, g:i a', $value['filedate']);
	$params['backupsize'] = round($value['filesize']/1024/1024, 2); // MBytes
	$ret .= $this->Application->ParseBlock($params);
	}
	return $ret;
	}

	function getDirList ($dirName)
	{
	$fileinfo = array();
	$d = dir($dirName);

	while($entry = $d->read())
	{
	if ($entry != "." && $entry != "..")
	{
	if (!is_dir($dirName."/".$entry) && eregi("dump",$entry))
	{
	$fileinfo[]= Array('filedate' => $this->chopchop($entry),
	'filesize' => filesize($dirName. '/'. $entry)
	);
	}
	}
	}
	$d->close();
	rsort($fileinfo);

	return $fileinfo;

	}

	function chopchop ($filename)
	{
	$p = pathinfo($filename);
	$ext = '.'.$p["extension"];
	$filename;
	$filename= ereg_replace("dump","",$filename);
	$filename= ereg_replace($ext,"",$filename);
	return $filename;
	}

	function PrintPHPinfo($params)
	{
	$php_info = '';

	ob_start();

	phpinfo();
	$php_info .= ob_get_contents();

	ob_end_clean();

	$php_info = str_replace(" width=\"600\"", " width=\"100%\" align=\"center\"", $php_info);
	$php_info = str_replace("</body>", "", $php_info);
	$php_info = str_replace("<body>", "", $php_info);
	$php_info = str_replace("</html>", "", $php_info);
	$php_info = str_replace("<html>", "", $php_info);
	$php_info = str_replace("</head>", "", $php_info);
	$php_info = str_replace("<head>", "", $php_info);

	$offset = strpos($php_info, "<table");

	$php_info = substr($php_info, $offset);

	$php_info = '<style type="text/css">
	body {background-color: #ffffff; color: #000000;}
	body, td, th, h1, h2 {font-family: sans-serif;}
	pre {margin: 0px; font-family: monospace;}
	a:link {color: #000099; text-decoration: none; background-color: #ffffff;}
	a:hover {text-decoration: underline;}
	table {border-collapse: collapse;}
	.center {text-align: center;}
	.center table { margin-left: auto; margin-right: auto; text-align: left;}
	.center th { text-align: center !important; }
	td, th { border: 1px solid #000000; font-size: 75%; vertical-align: baseline;}
	h1 {font-size: 150%;}
	h2 {font-size: 125%;}
	.p {text-align: left;}
	.e {background-color: #ccccff; font-weight: bold; color: #000000;}
	.h {background-color: #9999cc; font-weight: bold; color: #000000;}
	.v {background-color: #cccccc; color: #000000;}
	i {color: #666666; background-color: #cccccc;}
	hr {width: 600px; background-color: #cccccc; border: 0px; height: 1px; color: #000000;}
	</style>'.$php_info;

	return $php_info;

	}

	function PrintSqlCols($params)
	{
	$a_data = unserialize($this->Application->GetVar('sql_rows'));
	$ret = '';
	$block = $params['render_as'];
	foreach ($a_data AS $a_row)
	{
	foreach ($a_row AS $col => $value)
	{
	$ret .= $this->Application->ParseBlock(Array('name'=>$block, 'value'=>$col));
	}
	break;
	}
	return $ret;
	}

	function PrintSqlRows($params)
	{
	$a_data = unserialize($this->Application->GetVar('sql_rows'));
	$ret = '';
	$block = $params['render_as'];
	foreach ($a_data AS $a_row)
	{
	$cells = '';
	foreach ($a_row AS $col => $value)
	{
	$cells .= '<td>'.$value.'</td>';
	}
	$ret .= $this->Application->ParseBlock(Array('name'=>$block, 'cells'=>$cells));
	}
	return $ret;
	}

	/**
	* Prints available and enabled import sources using given block
	*
	* @param Array $params
	* @return string
	*/
	function PrintImportSources($params)
	{
	$sql = 'SELECT *
	FROM ' . TABLE_PREFIX . 'ImportScripts
	WHERE (Status = ' . STATUS_ACTIVE . ') AND (Type = "CSV")';
	$import_sources = $this->Conn->Query($sql);

	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['render_as'];

	$ret = '';
	foreach ($import_sources as $import_source) {
	$block_params['script_id'] = $import_source['ImportId'];
	$block_params['script_module'] = $import_source['Module'];
	$block_params['script_name'] = $import_source['Name'];
	$block_params['script_prefix'] = $import_source['Prefix'];

	$ret .= $this->Application->ParseBlock($block_params);
	}

	return $ret;
	}

	/**
	* Checks, that new window should be opened in "incs/close_popup" template instead of refreshing parent window
	*
	* @param Array $params
	* @return bool
	*/
	function OpenNewWindow($params)
	{
	if (!$this->UsePopups($params)) {
	return false;
	}

	$diff = array_key_exists('diff', $params) ? $params['diff'] : 0;
	$wid = $this->Application->GetVar('m_wid');

	$stack_name = rtrim('opener_stack_' . $wid, '_');
	$opener_stack = $this->Application->RecallVar($stack_name);
	$opener_stack = $opener_stack ? unserialize($opener_stack) : Array ();

	return count($opener_stack) >= 2 - $diff;
	}

	/**
	* Allows to dynamically change current language in template
	*
	* @param Array $params
	*/
	function SetLanguage($params)
	{
	$this->Application->SetVar('m_lang', $params['language_id']);
	$this->Application->Phrases->Init('');

	$this->Application->Phrases->LanguageId = $params['language_id'];
	$this->Application->Phrases->LoadPhrases( $this->Application->Caches['PhraseList'] );
	}
	}

	?>
	\ No newline at end of file
	Index: branches/5.0.x/core/units/general/helpers/skin_helper.php
	===================================================================
	--- branches/5.0.x/core/units/general/helpers/skin_helper.php (nonexistent)
	+++ branches/5.0.x/core/units/general/helpers/skin_helper.php (revision 12233)
	@@ -0,0 +1,194 @@
	+<?php
	+
	+ class SkinHelper extends kHelper {
	+
	+ /**
	+ * Allows to read some skin fields and build link to admin skin file.
	+ * Will automatically compile skin file, when missing.
	+ *
	+ * @param Array $params
	+ * @return string
	+ */
	+ function AdminSkinTag($params)
	+ {
	+ if (array_key_exists('type', $params)) {
	+ // returns given field of skin
	+ return $this->_getStyleField( $params['type'] );
	+ }
	+
	+ $style_info = $this->_getStyleInfo();
	+
	+ if (file_exists( $this->getSkinPath() )) {
	+ // returns last compiled skin
	+ $ret = $this->getSkinPath(true);
	+ }
	+ else {
	+ // search for previously compiled skin
	+ $last_compiled = $this->_getLastCompiled( mb_strtolower($style_info['Name']) );
	+ if ($last_compiled) {
	+ // found
	+ $ret = $this->getSkinPath(true, $last_compiled);
	+ }
	+ else {
	+ // not found (try to compile on the fly)
	+ $skin =& $this->Application->recallObject('skin.-item', null, Array ('skip_autoload' => true));
	+ /* @var $skin kDBItem */
	+
	+ $skin->Load(1, 'IsPrimary');
	+ $last_compiled = $this->compile($skin);
	+ $ret = $last_compiled ? $this->getSkinPath(true, $last_compiled) : '';
	+ }
	+ }
	+
	+ if (array_key_exists('file_only', $params) && $params['file_only']) {
	+ return $ret;
	+ }
	+
	+ return '<link rel="stylesheet" rev="stylesheet" href="' . $ret . '" type="text/css" media="screen"/>';
	+ }
	+
	+ /**
	+ * Compiles given skin object
	+ *
	+ * @param kDBItem $object
	+ */
	+ function compile(&$object)
	+ {
	+ $ret = $object->GetDBField('CSS');
	+ $options = $object->GetDBField('Options');
	+ $options = unserialize($options);
	+ $options['base_url'] = Array ('Value' => rtrim($this->Application->BaseURL(), '/'));
	+
	+ foreach ($options as $key => $row) {
	+ $ret = str_replace('@@' . $key . '@@', $row['Value'], $ret);
	+ }
	+
	+ $compile_ts = adodb_mktime();
	+ $css_file = $this->_getStylesheetPath() . DIRECTORY_SEPARATOR . 'admin-' . mb_strtolower($object->GetDBField('Name')) . '-' . $compile_ts . '.css';
	+
	+ $fp = fopen($css_file, 'w');
	+ if (!$fp) {
	+ return false;
	+ }
	+
	+ $prev_css = $this->_getStylesheetPath() . '/admin-' . mb_strtolower($object->GetDBField('Name')) . '-' . $object->GetDBField('LastCompiled') . '.css';
	+ if (file_exists($prev_css)) {
	+ unlink($prev_css);
	+ }
	+
	+ fwrite($fp, $ret);
	+ fclose($fp);
	+
	+ $sql = 'UPDATE ' . $object->TableName . '
	+ SET LastCompiled = ' . $compile_ts . '
	+ WHERE ' . $object->IDField . ' = ' . $object->GetID();
	+ $this->Conn->Query($sql);
	+
	+ return $compile_ts;
	+ }
	+
	+ /**
	+ * Returns fields of primary admin skin
	+ *
	+ * @return Array
	+ */
	+ function _getStyleInfo()
	+ {
	+ static $style = null;
	+
	+ if (!isset($style)) {
	+ $sql = 'SELECT *
	+ FROM ' . TABLE_PREFIX . 'Skins
	+ WHERE IsPrimary = 1';
	+ $style = $this->Conn->GetRow($sql);
	+ }
	+
	+ return $style;
	+ }
	+
	+ /**
	+ * Returns requested field value of primary admin skin
	+ *
	+ * @param string $field
	+ * @return string
	+ */
	+ function _getStyleField($field)
	+ {
	+ if ($field == 'logo') {
	+ // old style method of calling
	+ $field = 'Logo';
	+ }
	+
	+ $style_info = $this->_getStyleInfo();
	+
	+ if (!$style_info[$field]) {
	+ return '';
	+ }
	+
	+ $image_fields = Array ('Logo', 'LogoBottom', 'LogoLogin');
	+ if (in_array($field, $image_fields)) {
	+ return $this->_getStylesheetPath(true) . '/' . $style_info[$field];
	+ }
	+
	+ return $style_info[$field];
	+ }
	+
	+ /**
	+ * Returns path, where compiled skin and it's image files are stored
	+ *
	+ * @param bool $url
	+ * @return string
	+ */
	+ function _getStylesheetPath($url = false)
	+ {
	+ if ($url) {
	+ return $this->Application->BaseURL( str_replace(DIRECTORY_SEPARATOR, '/', WRITEBALE_BASE) ) . 'user_files';
	+ }
	+
	+ return WRITEABLE . DIRECTORY_SEPARATOR . 'user_files';
	+ }
	+
	+ /**
	+ * Returns full path to primary admin skin using given or last compiled date
	+ *
	+ * @param unknown_type $url
	+ * @param unknown_type $compile_date
	+ * @return unknown
	+ */
	+ function getSkinPath($url = false, $compile_date = null)
	+ {
	+ $style_info = $this->_getStyleInfo();
	+
	+ if (!isset($compile_date)) {
	+ $compile_date = $style_info['LastCompiled'];
	+ }
	+
	+ $style_name = 'admin-' . mb_strtolower($style_info['Name']) . '-' . $compile_date . '.css';
	+
	+ return $this->_getStylesheetPath($url) . ($url ? '/' : DIRECTORY_SEPARATOR) . $style_name;
	+ }
	+
	+ /**
	+ * Returns maximal compilation date for given skin name
	+ *
	+ * @param string $style_name
	+ * @return int
	+ */
	+ function _getLastCompiled($style_name)
	+ {
	+ $last_compiled = 0;
	+ $dh = dir($this->_getStylesheetPath() . DIRECTORY_SEPARATOR);
	+
	+ while (false !== ($file = $dh->read())) {
	+ if ( preg_match('/admin-(.*)-([\d]+).css/', $file, $rets) ) {
	+ if ($rets[1] == $style_name && $rets[2] > $last_compiled) {
	+ $last_compiled = $rets[2];
	+ }
	+ }
	+ }
	+
	+ $dh->close();
	+
	+ return $last_compiled;
	+ }
	+ }
	\ No newline at end of file
	Index: branches/5.0.x/core/units/general/helpers/helpers_config.php
	===================================================================
	--- branches/5.0.x/core/units/general/helpers/helpers_config.php (revision 12232)
	+++ branches/5.0.x/core/units/general/helpers/helpers_config.php (revision 12233)
	@@ -1,49 +1,50 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.net/license/ for copyright notices and details.
	*/

	$config = Array (
	'Prefix' => 'helpers',
	'EventHandlerClass' => Array ('class' => 'kEventHandler', 'file' => '', 'build_event' => 'OnBuild'),

	'RegisterClasses' => Array (
	Array ('pseudo' => 'kMultiLanguageHelper', 'class' => 'kMultiLanguageHelper', 'file' => 'multilanguage.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'SearchHelper', 'class' => 'kSearchHelper', 'file' => 'search_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'SectionsHelper', 'class' => 'kSectionsHelper', 'file' => 'sections_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'PermissionsHelper', 'class' => 'kPermissionsHelper', 'file' => 'permissions_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ModulesHelper', 'class' => 'kModulesHelper', 'file' => 'modules.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ModRewriteHelper', 'class' => 'kModRewriteHelper', 'file' => 'mod_rewrite_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'RecursiveHelper', 'class' => 'kRecursiveHelper', 'file' => 'recursive_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'FilenamesHelper', 'class' => 'kFilenamesHelper', 'file' => 'filenames_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ClipboardHelper', 'class' => 'kClipboardHelper', 'file' => 'clipboard_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ColumnPickerHelper', 'class' => 'kColumnPickerHelper', 'file' => 'col_picker_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ThemesHelper', 'class' => 'kThemesHelper', 'file' => 'themes_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'CaptchaHelper', 'class' => 'kCaptchaHelper', 'file' => 'captcha_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'PriorityHelper', 'class' => 'kPriorityHelper', 'file' => 'priority_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'CurlHelper', 'class' => 'kCurlHelper', 'file' => 'curl_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'CountHelper', 'class' => 'kCountHelper', 'file' => 'count_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),

	Array ('pseudo' => 'ImageHelper', 'class' => 'ImageHelper', 'file' => 'image_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'FileHelper', 'class' => 'FileHelper', 'file' => 'file_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'CategoryHelper', 'class' => 'CategoryHelper', 'file' => 'category_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'CSVHelper', 'class' => 'kCSVHelper', 'file' => 'csv_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'ChartHelper', 'class' => 'kChartHelper', 'file' => 'chart_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'RatingHelper', 'class' => 'RatingHelper', 'file' => 'rating_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'FCKHelper', 'class' => 'fckFCKHelper', 'file' => 'fck_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'SpamHelper', 'class' => 'SpamHelper', 'file' => 'spam_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'TemplateHelper', 'class' => 'TemplateHelper', 'file' => 'template_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'MailingListHelper', 'class' => 'MailingListHelper', 'file' => 'mailing_list_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'JSONHelper', 'class' => 'JSONHelper', 'file' => 'json_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	Array ('pseudo' => 'LanguageImportHelper', 'class' => 'LanguageImportHelper', 'file' => 'language_import_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	+ Array ('pseudo' => 'SkinHelper', 'class' => 'SkinHelper', 'file' => 'skin_helper.php', 'build_event' => '', 'require_classes' => 'kHelper'),
	),
	);
	\ No newline at end of file
	Index: branches/5.0.x/core/admin_templates/config/config_universal.tpl
	===================================================================
	--- branches/5.0.x/core/admin_templates/config/config_universal.tpl (revision 12232)
	+++ branches/5.0.x/core/admin_templates/config/config_universal.tpl (revision 12233)
	@@ -1,97 +1,103 @@
	<inp2:m_include t="incs/header"/>

	<inp2:conf_InitList name="Default" per_page="-1"/>
	<inp2:m_Get name="section" result_to_var="section"/>
	<inp2:m_RenderElement name="combined_header" prefix="conf" section="$section" title_preset="section_label" perm_event="conf:OnLoad"/>

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

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

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

	function toggle_section($label) {
	var $table = document.getElementById('config_table');
	var $row = null;
	var $is_visible = false;

	for (var $i = 0; $i < $table.rows.length; $i++) {
	$row = $table.rows[$i];
	if ($row.getAttribute('header_label') != $label) {
	continue;
	}

	if (!$row.style.display) {
	$row.style.display = document.all ? 'block' : 'table-row';
	}

	$is_visible = !($row.style.display == 'none');
	$row.style.display = $is_visible ? 'none' : (document.all ? 'block' : 'table-row');

	document.getElementById('toggle_mark['+$label+']').innerHTML = '[' + ($is_visible ? '+' : '-') + ']';
	}
	}

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

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

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

	<inp2:conf_SaveWarning name="grid_save_warning"/>
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="bordered" id="config_table">
	<inp2:conf_PrintList list_name="default" block="config_block" full_block="config_block" half_block1="config_block1" half_block2="config_block2"/>
	</table>

	<script type="text/javascript">
	-<inp2:m_if check="m_Get" name="refresh_tree">
	- getFrame('menu').location.reload();
	-</inp2:m_if>
	+ <inp2:m_if check="m_Get" name="refresh_tree">
	+ getFrame('menu').location.reload();
	+ </inp2:m_if>
	+
	+ <inp2:m_if check="m_Get" name="refresh_all">
	+ var $menu_frame = getFrame('menu');
	+
	+ $menu_frame.parent.location.href = $menu_frame.parent.location.href;
	+ </inp2:m_if>
	</script>

	<inp2:m_include t="incs/footer"/>
	\ No newline at end of file
	Index: branches/5.0.x/core/install/upgrades.php
	===================================================================
	--- branches/5.0.x/core/install/upgrades.php (revision 12232)
	+++ branches/5.0.x/core/install/upgrades.php (revision 12233)
	@@ -1,1145 +1,1148 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.net/license/ for copyright notices and details.
	*/
	$upgrade_class = 'CoreUpgrades';

	/**
	* Class, that holds all upgrade scripts for "Core" module
	*
	*/
	class CoreUpgrades extends kHelper {

	/**
	* Install toolkit instance
	*
	* @var kInstallToolkit
	*/
	var $_toolkit = null;

	/**
	* Sets common instance of installator toolkit
	*
	* @param kInstallToolkit $instance
	*/
	function setToolkit(&$instance)
	{
	$this->_toolkit =& $instance;
	}

	/**
	* Changes table structure, where multilingual fields of TEXT type are present
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_1_0($mode)
	{
	if ($mode == 'before') {
	// don't user after, because In-Portal calls this method too
	$this->_toolkit->SaveConfig();
	}

	if ($mode == 'after') {
	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	/* @var $ml_helper kMultiLanguageHelper */

	$lang_count = $ml_helper->getLanguageCount();
	$this->Application->UnitConfigReader->iterateConfigs(Array (&$this, 'updateTextFields'), $lang_count);
	}
	}

	/**
	* Moves ReplacementTags functionality from EmailMessage to Events table
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_1_1($mode)
	{
	if ($mode == 'after') {
	$sql = 'SELECT ReplacementTags, EventId
	FROM '.TABLE_PREFIX.'EmailMessage
	WHERE (ReplacementTags IS NOT NULL) AND (ReplacementTags <> "") AND (LanguageId = 1)';
	$replacement_tags = $this->Conn->GetCol($sql, 'EventId');

	foreach ($replacement_tags as $event_id => $replacement_tag) {
	$sql = 'UPDATE '.TABLE_PREFIX.'Events
	SET ReplacementTags = '.$this->Conn->qstr($replacement_tag).'
	WHERE EventId = '.$event_id;
	$this->Conn->Query($sql);
	}

	// drop moved field from source table
	$sql = 'ALTER TABLE '.TABLE_PREFIX.'EmailMessage
	DROP `ReplacementTags`';
	$this->Conn->Query($sql);
	}
	}

	/**
	* Callback function, that makes all ml fields of text type null with same default value
	*
	* @param string $prefix
	* @param Array $config_data
	* @param int $language_count
	* @return bool
	*/
	function updateTextFields($prefix, &$config_data, $language_count)
	{
	if (!isset($config_data['TableName']) \|\| !isset($config_data['Fields'])) {
	// invalid config found or prefix not found
	return false;
	}

	$table_name = $config_data['TableName'];
	$table_structure = $this->Conn->Query('DESCRIBE '.$table_name, 'Field');
	if (!$table_structure) {
	// table not found
	return false;
	}

	$sqls = Array ();
	foreach ($config_data['Fields'] as $field => $options) {
	if (isset($options['formatter']) && $options['formatter'] == 'kMultiLanguage' && !isset($options['master_field'])) {
	// update all l<lang_id>_<field_name> fields (new format)
	for ($i = 1; $i <= $language_count; $i++) {
	$ml_field = 'l'.$i.'_'.$field;
	if ($table_structure[$ml_field]['Type'] == 'text') {
	$sqls[] = 'CHANGE '.$ml_field.' '.$ml_field.' TEXT NULL DEFAULT NULL';
	}
	}

	// update <field_name> if found (old format)
	if (isset($table_structure[$field]) && $table_structure[$field]['Type'] == 'text') {
	$sqls[] = 'CHANGE '.$field.' '.$field.' TEXT NULL DEFAULT NULL';
	}
	}
	}

	if ($sqls) {
	$sql = 'ALTER TABLE '.$table_name.' '.implode(', ', $sqls);
	$this->Conn->Query($sql);
	}

	return true;
	}

	/**
	* Replaces In-Portal tags in Forgot Password related email events to K4 ones
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_2_0($mode)
	{
	if ($mode == 'after') {
	// 1. get event ids based on their name and type combination
	$event_names = Array (
	'USER.PSWD_'.EVENT_TYPE_ADMIN,
	'USER.PSWD_'.EVENT_TYPE_FRONTEND,
	'USER.PSWDC_'.EVENT_TYPE_FRONTEND,
	);

	$event_sql = Array ();
	foreach ($event_names as $mixed_event) {
	list ($event_name, $event_type) = explode('_', $mixed_event, 2);
	$event_sql[] = 'Event = "'.$event_name.'" AND Type = '.$event_type;
	}

	$sql = 'SELECT EventId
	FROM '.TABLE_PREFIX.'Events
	WHERE ('.implode(') OR (', $event_sql).')';
	$event_ids = implode(',', $this->Conn->GetCol($sql));

	// 2. replace In-Portal tags to K4 tags
	$replacements = Array (
	'<inp:touser _Field="Password" />' => '<inp2:u_ForgottenPassword />',
	'<inp:m_confirm_password_link />' => '<inp2:u_ConfirmPasswordLink no_amp="1"/>',
	);

	foreach ($replacements as $old_tag => $new_tag) {
	$sql = 'UPDATE '.TABLE_PREFIX.'EmailMessage
	SET Template = REPLACE(Template, '.$this->Conn->qstr($old_tag).', '.$this->Conn->qstr($new_tag).')
	WHERE EventId IN ('.$event_ids.')';
	$this->Conn->Query($sql);
	}

	}
	}

	/**
	* Makes admin primary language same as front-end - not needed, done in SQL
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_2_1($mode)
	{

	}

	function Upgrade_4_2_2($mode)
	{
	if ($mode == 'before') {
	if ($this->Conn->GetOne('SELECT LanguageId FROM '.TABLE_PREFIX.'Language WHERE PrimaryLang = 1')) return ;
	$this->Conn->Query('UPDATE '.TABLE_PREFIX.'Language SET PrimaryLang = 1 ORDER BY LanguageId LIMIT 1');
	}
	}

	/**
	* Adds index to "dob" field in "PortalUser" table when it's missing
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_3_1($mode)
	{
	if ($mode == 'after') {
	$sql = 'DESCRIBE ' . TABLE_PREFIX . 'PortalUser';
	$structure = $this->Conn->Query($sql);

	foreach ($structure as $field_info) {
	if ($field_info['Field'] == 'dob') {
	if (!$field_info['Key']) {
	$sql = 'ALTER TABLE ' . TABLE_PREFIX . 'PortalUser
	ADD INDEX (dob)';
	$this->Conn->Query($sql);
	}
	break;
	}
	}
	}
	}

	/**
	* Removes duplicate phrases, update file paths in database
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_4_3_9($mode)
	{
	// 1. find In-Portal old <inp: tags
	$sql = 'SELECT EmailMessageId
	FROM '.TABLE_PREFIX.'EmailMessage
	WHERE Template LIKE \'%<inp:%\'';
	$event_ids = implode(',', $this->Conn->GetCol($sql));

	// 2. replace In-Portal old <inp: tags to K4 tags
	$replacements = Array (
	'<inp:m_category_field _Field="Name" _StripHTML="1"' => '<inp2:c_Field name="Name"',
	'<inp:touser _Field="password"' => '<inp2:u_Field name="Password_plain"',
	'<inp:touser _Field="UserName"' => '<inp2:u_Field name="Login"',
	'<inp:touser _Field="' => '<inp2:u_Field name="',
	'<inp:m_page_title' => '<inp2:m_BaseUrl',
	'<inp:m_theme_url _page="current"' => '<inp2:m_BaseUrl',
	'<inp:topic _field="text"' => '<inp2:bb-post_Field name="PostingText"',
	'<inp:topic _field="link" _Template="inbulletin/post_list"' => '<inp2:bb_TopicLink template="__default__"',
	);

	foreach ($replacements as $old_tag => $new_tag) {
	$sql = 'UPDATE '.TABLE_PREFIX.'EmailMessage
	SET Template = REPLACE(Template, '.$this->Conn->qstr($old_tag).', '.$this->Conn->qstr($new_tag).')
	WHERE EventId IN ('.$event_ids.')';
	$this->Conn->Query($sql);
	}

	if ($mode == 'after') {
	$this->_insertInPortalData();
	$this->_removeDuplicatePhrases();
	$this->_moveDatabaseFolders();

	// in case, when In-Portal module is enabled -> turn AdvancedUserManagement on too
	if ($this->Application->findModule('Name', 'In-Portal')) {
	$sql = 'UPDATE ' . TABLE_PREFIX . 'ConfigurationValues
	SET VariableValue = 1
	WHERE VariableName = "AdvancedUserManagement"';
	$this->Conn->Query($sql);
	}
	}
	}

	function _insertInPortalData()
	{
	$data = Array (
	'ConfigurationAdmin' => Array (
	'UniqueField' => 'VariableName',
	'Records' => Array (
	'AllowDeleteRootCats' => "('AllowDeleteRootCats', 'la_Text_General', 'la_AllowDeleteRootCats', 'checkbox', NULL , NULL , 10.09, 0, 0)",
	'Catalog_PreselectModuleTab' => "('Catalog_PreselectModuleTab', 'la_Text_General', 'la_config_CatalogPreselectModuleTab', 'checkbox', NULL, NULL, 10.10, 0, 1)",
	'RecycleBinFolder' => "('RecycleBinFolder', 'la_Text_General', 'la_config_RecycleBinFolder', 'text', NULL , NULL , 10.11, 0, 0)",
	'AdvancedUserManagement' => "('AdvancedUserManagement', 'la_Text_General', 'la_prompt_AdvancedUserManagement', 'checkbox', NULL, NULL, '10.011', 0, 1)",
	),
	),

	'ConfigurationValues' => Array (
	'UniqueField' => 'VariableName',
	'Records' => Array (
	'AdvancedUserManagement' => "(DEFAULT, 'AdvancedUserManagement', 0, 'In-Portal:Users', 'in-portal:configure_users')",
	),
	),

	'ItemTypes' => Array (
	'UniqueField' => 'ItemType',
	'Records' => Array (
	'1' => "(1, 'In-Portal', 'c', 'Category', 'Name', 'CreatedById', NULL, NULL, 'la_ItemTab_Categories', 1, 'admin/category/addcategory.php', 'clsCategory', 'Category')",
	'6' => "(6, 'In-Portal', 'u', 'PortalUser', 'Login', 'PortalUserId', NULL, NULL, '', 0, '', 'clsPortalUser', 'User')",
	),
	),

	'PermissionConfig' => Array (
	'UniqueField' => 'PermissionName',
	'Records' => Array (
	'CATEGORY.ADD' => "(DEFAULT, 'CATEGORY.ADD', 'lu_PermName_Category.Add_desc', 'lu_PermName_Category.Add_error', 'In-Portal')",
	'CATEGORY.DELETE' => "(DEFAULT, 'CATEGORY.DELETE', 'lu_PermName_Category.Delete_desc', 'lu_PermName_Category.Delete_error', 'In-Portal')",
	'CATEGORY.ADD.PENDING' => "(DEFAULT, 'CATEGORY.ADD.PENDING', 'lu_PermName_Category.AddPending_desc', 'lu_PermName_Category.AddPending_error', 'In-Portal')",
	'CATEGORY.MODIFY' => "(DEFAULT, 'CATEGORY.MODIFY', 'lu_PermName_Category.Modify_desc', 'lu_PermName_Category.Modify_error', 'In-Portal')",
	'ADMIN' => "(DEFAULT, 'ADMIN', 'lu_PermName_Admin_desc', 'lu_PermName_Admin_error', 'Admin')",
	'LOGIN' => "(DEFAULT, 'LOGIN', 'lu_PermName_Login_desc', 'lu_PermName_Admin_error', 'Front')",
	'DEBUG.ITEM' => "(DEFAULT, 'DEBUG.ITEM', 'lu_PermName_Debug.Item_desc', '', 'Admin')",
	'DEBUG.LIST' => "(DEFAULT, 'DEBUG.LIST', 'lu_PermName_Debug.List_desc', '', 'Admin')",
	'DEBUG.INFO' => "(DEFAULT, 'DEBUG.INFO', 'lu_PermName_Debug.Info_desc', '', 'Admin')",
	'PROFILE.MODIFY' => "(DEFAULT, 'PROFILE.MODIFY', 'lu_PermName_Profile.Modify_desc', '', 'Admin')",
	'SHOWLANG' => "(DEFAULT, 'SHOWLANG', 'lu_PermName_ShowLang_desc', '', 'Admin')",
	'FAVORITES' => "(DEFAULT, 'FAVORITES', 'lu_PermName_favorites_desc', 'lu_PermName_favorites_error', 'In-Portal')",
	'SYSTEM_ACCESS.READONLY' => "(DEFAULT, 'SYSTEM_ACCESS.READONLY', 'la_PermName_SystemAccess.ReadOnly_desc', 'la_PermName_SystemAccess.ReadOnly_error', 'Admin')",
	),
	),

	'Permissions' => Array (
	'UniqueField' => 'Permission;GroupId;Type;CatId',
	'Records' => Array (
	'LOGIN;12;1;0' => "(DEFAULT, 'LOGIN', 12, 1, 1, 0)",
	'in-portal:site.view;11;1;0' => "(DEFAULT, 'in-portal:site.view', 11, 1, 1, 0)",
	'in-portal:browse.view;11;1;0' => "(DEFAULT, 'in-portal:browse.view', 11, 1, 1, 0)",
	'in-portal:advanced_view.view;11;1;0' => "(DEFAULT, 'in-portal:advanced_view.view', 11, 1, 1, 0)",
	'in-portal:reviews.view;11;1;0' => "(DEFAULT, 'in-portal:reviews.view', 11, 1, 1, 0)",
	'in-portal:configure_categories.view;11;1;0' => "(DEFAULT, 'in-portal:configure_categories.view', 11, 1, 1, 0)",
	'in-portal:configure_categories.edit;11;1;0' => "(DEFAULT, 'in-portal:configure_categories.edit', 11, 1, 1, 0)",
	'in-portal:configuration_search.view;11;1;0' => "(DEFAULT, 'in-portal:configuration_search.view', 11, 1, 1, 0)",
	'in-portal:configuration_search.edit;11;1;0' => "(DEFAULT, 'in-portal:configuration_search.edit', 11, 1, 1, 0)",
	'in-portal:configuration_email.view;11;1;0' => "(DEFAULT, 'in-portal:configuration_email.view', 11, 1, 1, 0)",
	'in-portal:configuration_email.edit;11;1;0' => "(DEFAULT, 'in-portal:configuration_email.edit', 11, 1, 1, 0)",
	'in-portal:configuration_custom.view;11;1;0' => "(DEFAULT, 'in-portal:configuration_custom.view', 11, 1, 1, 0)",
	'in-portal:configuration_custom.add;11;1;0' => "(DEFAULT, 'in-portal:configuration_custom.add', 11, 1, 1, 0)",
	'in-portal:configuration_custom.edit;11;1;0' => "(DEFAULT, 'in-portal:configuration_custom.edit', 11, 1, 1, 0)",
	'in-portal:configuration_custom.delete;11;1;0' => "(DEFAULT, 'in-portal:configuration_custom.delete', 11, 1, 1, 0)",
	'in-portal:users.view;11;1;0' => "(DEFAULT, 'in-portal:users.view', 11, 1, 1, 0)",
	'in-portal:user_list.advanced:ban;11;1;0' => "(DEFAULT, 'in-portal:user_list.advanced:ban', 11, 1, 1, 0)",
	'in-portal:user_list.advanced:send_email;11;1;0' => "(DEFAULT, 'in-portal:user_list.advanced:send_email', 11, 1, 1, 0)",
	'in-portal:user_groups.view;11;1;0' => "(DEFAULT, 'in-portal:user_groups.view', 11, 1, 1, 0)",
	'in-portal:user_groups.add;11;1;0' => "(DEFAULT, 'in-portal:user_groups.add', 11, 1, 1, 0)",
	'in-portal:user_groups.edit;11;1;0' => "(DEFAULT, 'in-portal:user_groups.edit', 11, 1, 1, 0)",
	'in-portal:user_groups.delete;11;1;0' => "(DEFAULT, 'in-portal:user_groups.delete', 11, 1, 1, 0)",
	'in-portal:user_groups.advanced:send_email;11;1;0' => "(DEFAULT, 'in-portal:user_groups.advanced:send_email', 11, 1, 1, 0)",
	'in-portal:user_groups.advanced:manage_permissions;11;1;0' => "(DEFAULT, 'in-portal:user_groups.advanced:manage_permissions', 11, 1, 1, 0)",
	'in-portal:configure_users.view;11;1;0' => "(DEFAULT, 'in-portal:configure_users.view', 11, 1, 1, 0)",
	'in-portal:configure_users.edit;11;1;0' => "(DEFAULT, 'in-portal:configure_users.edit', 11, 1, 1, 0)",
	'in-portal:user_email.view;11;1;0' => "(DEFAULT, 'in-portal:user_email.view', 11, 1, 1, 0)",
	'in-portal:user_email.edit;11;1;0' => "(DEFAULT, 'in-portal:user_email.edit', 11, 1, 1, 0)",
	'in-portal:user_custom.view;11;1;0' => "(DEFAULT, 'in-portal:user_custom.view', 11, 1, 1, 0)",
	'in-portal:user_custom.add;11;1;0' => "(DEFAULT, 'in-portal:user_custom.add', 11, 1, 1, 0)",
	'in-portal:user_custom.edit;11;1;0' => "(DEFAULT, 'in-portal:user_custom.edit', 11, 1, 1, 0)",
	'in-portal:user_custom.delete;11;1;0' => "(DEFAULT, 'in-portal:user_custom.delete', 11, 1, 1, 0)",
	'in-portal:user_banlist.view;11;1;0' => "(DEFAULT, 'in-portal:user_banlist.view', 11, 1, 1, 0)",
	'in-portal:user_banlist.add;11;1;0' => "(DEFAULT, 'in-portal:user_banlist.add', 11, 1, 1, 0)",
	'in-portal:user_banlist.edit;11;1;0' => "(DEFAULT, 'in-portal:user_banlist.edit', 11, 1, 1, 0)",
	'in-portal:user_banlist.delete;11;1;0' => "(DEFAULT, 'in-portal:user_banlist.delete', 11, 1, 1, 0)",
	'in-portal:reports.view;11;1;0' => "(DEFAULT, 'in-portal:reports.view', 11, 1, 1, 0)",
	'in-portal:log_summary.view;11;1;0' => "(DEFAULT, 'in-portal:log_summary.view', 11, 1, 1, 0)",
	'in-portal:searchlog.view;11;1;0' => "(DEFAULT, 'in-portal:searchlog.view', 11, 1, 1, 0)",
	'in-portal:searchlog.delete;11;1;0' => "(DEFAULT, 'in-portal:searchlog.delete', 11, 1, 1, 0)",
	'in-portal:sessionlog.view;11;1;0' => "(DEFAULT, 'in-portal:sessionlog.view', 11, 1, 1, 0)",
	'in-portal:sessionlog.delete;11;1;0' => "(DEFAULT, 'in-portal:sessionlog.delete', 11, 1, 1, 0)",
	'in-portal:emaillog.view;11;1;0' => "(DEFAULT, 'in-portal:emaillog.view', 11, 1, 1, 0)",
	'in-portal:emaillog.delete;11;1;0' => "(DEFAULT, 'in-portal:emaillog.delete', 11, 1, 1, 0)",
	'in-portal:visits.view;11;1;0' => "(DEFAULT, 'in-portal:visits.view', 11, 1, 1, 0)",
	'in-portal:visits.delete;11;1;0' => "(DEFAULT, 'in-portal:visits.delete', 11, 1, 1, 0)",
	'in-portal:configure_general.view;11;1;0' => "(DEFAULT, 'in-portal:configure_general.view', 11, 1, 1, 0)",
	'in-portal:configure_general.edit;11;1;0' => "(DEFAULT, 'in-portal:configure_general.edit', 11, 1, 1, 0)",
	'in-portal:modules.view;11;1;0' => "(DEFAULT, 'in-portal:modules.view', 11, 1, 1, 0)",
	'in-portal:mod_status.view;11;1;0' => "(DEFAULT, 'in-portal:mod_status.view', 11, 1, 1, 0)",
	'in-portal:mod_status.edit;11;1;0' => "(DEFAULT, 'in-portal:mod_status.edit', 11, 1, 1, 0)",
	'in-portal:mod_status.advanced:approve;11;1;0' => "(DEFAULT, 'in-portal:mod_status.advanced:approve', 11, 1, 1, 0)",
	'in-portal:mod_status.advanced:decline;11;1;0' => "(DEFAULT, 'in-portal:mod_status.advanced:decline', 11, 1, 1, 0)",
	'in-portal:addmodule.view;11;1;0' => "(DEFAULT, 'in-portal:addmodule.view', 11, 1, 1, 0)",
	'in-portal:addmodule.add;11;1;0' => "(DEFAULT, 'in-portal:addmodule.add', 11, 1, 1, 0)",
	'in-portal:addmodule.edit;11;1;0' => "(DEFAULT, 'in-portal:addmodule.edit', 11, 1, 1, 0)",
	'in-portal:tag_library.view;11;1;0' => "(DEFAULT, 'in-portal:tag_library.view', 11, 1, 1, 0)",
	'in-portal:configure_themes.view;11;1;0' => "(DEFAULT, 'in-portal:configure_themes.view', 11, 1, 1, 0)",
	'in-portal:configure_themes.add;11;1;0' => "(DEFAULT, 'in-portal:configure_themes.add', 11, 1, 1, 0)",
	'in-portal:configure_themes.edit;11;1;0' => "(DEFAULT, 'in-portal:configure_themes.edit', 11, 1, 1, 0)",
	'in-portal:configure_themes.delete;11;1;0' => "(DEFAULT, 'in-portal:configure_themes.delete', 11, 1, 1, 0)",
	'in-portal:configure_styles.view;11;1;0' => "(DEFAULT, 'in-portal:configure_styles.view', 11, 1, 1, 0)",
	'in-portal:configure_styles.add;11;1;0' => "(DEFAULT, 'in-portal:configure_styles.add', 11, 1, 1, 0)",
	'in-portal:configure_styles.edit;11;1;0' => "(DEFAULT, 'in-portal:configure_styles.edit', 11, 1, 1, 0)",
	'in-portal:configure_styles.delete;11;1;0' => "(DEFAULT, 'in-portal:configure_styles.delete', 11, 1, 1, 0)",
	'in-portal:configure_lang.advanced:set_primary;11;1;0' => "(DEFAULT, 'in-portal:configure_lang.advanced:set_primary', 11, 1, 1, 0)",
	'in-portal:configure_lang.advanced:import;11;1;0' => "(DEFAULT, 'in-portal:configure_lang.advanced:import', 11, 1, 1, 0)",
	'in-portal:configure_lang.advanced:export;11;1;0' => "(DEFAULT, 'in-portal:configure_lang.advanced:export', 11, 1, 1, 0)",
	'in-portal:tools.view;11;1;0' => "(DEFAULT, 'in-portal:tools.view', 11, 1, 1, 0)",
	'in-portal:backup.view;11;1;0' => "(DEFAULT, 'in-portal:backup.view', 11, 1, 1, 0)",
	'in-portal:restore.view;11;1;0' => "(DEFAULT, 'in-portal:restore.view', 11, 1, 1, 0)",
	'in-portal:export.view;11;1;0' => "(DEFAULT, 'in-portal:export.view', 11, 1, 1, 0)",
	'in-portal:main_import.view;11;1;0' => "(DEFAULT, 'in-portal:main_import.view', 11, 1, 1, 0)",
	'in-portal:sql_query.view;11;1;0' => "(DEFAULT, 'in-portal:sql_query.view', 11, 1, 1, 0)",
	'in-portal:sql_query.edit;11;1;0' => "(DEFAULT, 'in-portal:sql_query.edit', 11, 1, 1, 0)",
	'in-portal:server_info.view;11;1;0' => "(DEFAULT, 'in-portal:server_info.view', 11, 1, 1, 0)",
	'in-portal:help.view;11;1;0' => "(DEFAULT, 'in-portal:help.view', 11, 1, 1, 0)",
	),
	),

	'SearchConfig' => Array (
	'UniqueField' => 'TableName;FieldName;ModuleName',
	'Records' => Array (
	'Category;NewItem;In-Portal' => "('Category', 'NewItem', 0, 1, 'lu_fielddesc_category_newitem', 'lu_field_newitem', 'In-Portal', 'la_text_category', 18, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;PopItem;In-Portal' => "('Category', 'PopItem', 0, 1, 'lu_fielddesc_category_popitem', 'lu_field_popitem', 'In-Portal', 'la_text_category', 19, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;HotItem;In-Portal' => "('Category', 'HotItem', 0, 1, 'lu_fielddesc_category_hotitem', 'lu_field_hotitem', 'In-Portal', 'la_text_category', 17, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;MetaDescription;In-Portal' => "('Category', 'MetaDescription', 0, 1, 'lu_fielddesc_category_metadescription', 'lu_field_metadescription', 'In-Portal', 'la_text_category', 16, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;ParentPath;In-Portal' => "('Category', 'ParentPath', 0, 1, 'lu_fielddesc_category_parentpath', 'lu_field_parentpath', 'In-Portal', 'la_text_category', 15, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;ResourceId;In-Portal' => "('Category', 'ResourceId', 0, 1, 'lu_fielddesc_category_resourceid', 'lu_field_resourceid', 'In-Portal', 'la_text_category', 14, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;CreatedById;In-Portal' => "('Category', 'CreatedById', 0, 1, 'lu_fielddesc_category_createdbyid', 'lu_field_createdbyid', 'In-Portal', 'la_text_category', 13, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;CachedNavbar;In-Portal' => "('Category', 'CachedNavbar', 0, 1, 'lu_fielddesc_category_cachednavbar', 'lu_field_cachednavbar', 'In-Portal', 'la_text_category', 12, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;CachedDescendantCatsQty;In-Portal' => "('Category', 'CachedDescendantCatsQty', 0, 1, 'lu_fielddesc_category_cacheddescendantcatsqty', 'lu_field_cacheddescendantcatsqty', 'In-Portal', 'la_text_category', 11, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;MetaKeywords;In-Portal' => "('Category', 'MetaKeywords', 0, 1, 'lu_fielddesc_category_metakeywords', 'lu_field_metakeywords', 'In-Portal', 'la_text_category', 10, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;Priority;In-Portal' => "('Category', 'Priority', 0, 1, 'lu_fielddesc_category_priority', 'lu_field_priority', 'In-Portal', 'la_text_category', 9, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;Status;In-Portal' => "('Category', 'Status', 0, 1, 'lu_fielddesc_category_status', 'lu_field_status', 'In-Portal', 'la_text_category', 7, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;EditorsPick;In-Portal' => "('Category', 'EditorsPick', 0, 1, 'lu_fielddesc_category_editorspick', 'lu_field_editorspick', 'In-Portal', 'la_text_category', 6, DEFAULT, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;CreatedOn;In-Portal' => "('Category', 'CreatedOn', 0, 1, 'lu_fielddesc_category_createdon', 'lu_field_createdon', 'In-Portal', 'la_text_category', 5, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;Description;In-Portal' => "('Category', 'Description', 1, 1, 'lu_fielddesc_category_description', 'lu_field_description', 'In-Portal', 'la_text_category', 4, DEFAULT, 2, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;Name;In-Portal' => "('Category', 'Name', 1, 1, 'lu_fielddesc_category_name', 'lu_field_name', 'In-Portal', 'la_text_category', 3, DEFAULT, 2, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;ParentId;In-Portal' => "('Category', 'ParentId', 0, 1, 'lu_fielddesc_category_parentid', 'lu_field_parentid', 'In-Portal', 'la_text_category', 2, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;CategoryId;In-Portal' => "('Category', 'CategoryId', 0, 1, 'lu_fielddesc_category_categoryid', 'lu_field_categoryid', 'In-Portal', 'la_text_category', 0, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;Modified;In-Portal' => "('Category', 'Modified', 0, 1, 'lu_fielddesc_category_modified', 'lu_field_modified', 'In-Portal', 'la_text_category', 20, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'Category;ModifiedById;In-Portal' => "('Category', 'ModifiedById', 0, 1, 'lu_fielddesc_category_modifiedbyid', 'lu_field_modifiedbyid', 'In-Portal', 'la_text_category', 21, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",

	'PortalUser;PortalUserId;In-Portal' => "('PortalUser', 'PortalUserId', -1, 0, 'lu_fielddesc_user_portaluserid', 'lu_field_portaluserid', 'In-Portal', 'la_text_user', 0, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Login;In-Portal' => "('PortalUser', 'Login', -1, 0, 'lu_fielddesc_user_login', 'lu_field_login', 'In-Portal', 'la_text_user', 1, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Password;In-Portal' => "('PortalUser', 'Password', -1, 0, 'lu_fielddesc_user_password', 'lu_field_password', 'In-Portal', 'la_text_user', 2, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;tz;In-Portal' => "('PortalUser', 'tz', -1, 0, 'lu_fielddesc_user_tz', 'lu_field_tz', 'In-Portal', 'la_text_user', 17, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;dob;In-Portal' => "('PortalUser', 'dob', -1, 0, 'lu_fielddesc_user_dob', 'lu_field_dob', 'In-Portal', 'la_text_user', 16, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Modified;In-Portal' => "('PortalUser', 'Modified', -1, 0, 'lu_fielddesc_user_modified', 'lu_field_modified', 'In-Portal', 'la_text_user', 15, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Status;In-Portal' => "('PortalUser', 'Status', -1, 0, 'lu_fielddesc_user_status', 'lu_field_status', 'In-Portal', 'la_text_user', 14, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;ResourceId;In-Portal' => "('PortalUser', 'ResourceId', -1, 0, 'lu_fielddesc_user_resourceid', 'lu_field_resourceid', 'In-Portal', 'la_text_user', 13, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Country;In-Portal' => "('PortalUser', 'Country', -1, 0, 'lu_fielddesc_user_country', 'lu_field_country', 'In-Portal', 'la_text_user', 12, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Zip;In-Portal' => "('PortalUser', 'Zip', -1, 0, 'lu_fielddesc_user_zip', 'lu_field_zip', 'In-Portal', 'la_text_user', 11, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;State;In-Portal' => "('PortalUser', 'State', -1, 0, 'lu_fielddesc_user_state', 'lu_field_state', 'In-Portal', 'la_text_user', 10, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;City;In-Portal' => "('PortalUser', 'City', -1, 0, 'lu_fielddesc_user_city', 'lu_field_city', 'In-Portal', 'la_text_user', 9, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Street;In-Portal' => "('PortalUser', 'Street', -1, 0, 'lu_fielddesc_user_street', 'lu_field_street', 'In-Portal', 'la_text_user', 8, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Phone;In-Portal' => "('PortalUser', 'Phone', -1, 0, 'lu_fielddesc_user_phone', 'lu_field_phone', 'In-Portal', 'la_text_user', 7, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;CreatedOn;In-Portal' => "('PortalUser', 'CreatedOn', -1, 0, 'lu_fielddesc_user_createdon', 'lu_field_createdon', 'In-Portal', 'la_text_user', 6, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;Email;In-Portal' => "('PortalUser', 'Email', -1, 0, 'lu_fielddesc_user_email', 'lu_field_email', 'In-Portal', 'la_text_user', 5, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;LastName;In-Portal' => "('PortalUser', 'LastName', -1, 0, 'lu_fielddesc_user_lastname', 'lu_field_lastname', 'In-Portal', 'la_text_user', 4, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	'PortalUser;FirstName;In-Portal' => "('PortalUser', 'FirstName', -1, 0, 'lu_fielddesc_user_firstname', 'lu_field_firstname', 'In-Portal', 'la_text_user', 3, DEFAULT, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL)",
	),
	),

	'StatItem' => Array (
	'UniqueField' => 'Module;ListLabel',
	'Records' => Array (
	'In-Portal;la_prompt_ActiveCategories' => "(DEFAULT, 'In-Portal', 'SELECT count(*) FROM <%prefix%>Category WHERE Status=1 ', NULL, 'la_prompt_ActiveCategories', '0', '1')",
	'In-Portal;la_prompt_ActiveUsers' => "(DEFAULT, 'In-Portal', 'SELECT count(*) FROM <%prefix%>PortalUser WHERE Status=1 ', NULL, 'la_prompt_ActiveUsers', '0', '1')",
	'In-Portal;la_prompt_CurrentSessions' => "(DEFAULT, 'In-Portal', 'SELECT count(*) FROM <%prefix%>UserSession', NULL, 'la_prompt_CurrentSessions', '0', '1')",
	'In-Portal;la_prompt_TotalCategories' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) as CategoryCount FROM <%prefix%>Category', NULL, 'la_prompt_TotalCategories', 0, 2)",
	'In-Portal;la_prompt_ActiveCategories' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS ActiveCategories FROM <%prefix%>Category WHERE Status = 1', NULL, 'la_prompt_ActiveCategories', 0, 2)",
	'In-Portal;la_prompt_PendingCategories' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS PendingCategories FROM <%prefix%>Category WHERE Status = 2', NULL, 'la_prompt_PendingCategories', 0, 2)",
	'In-Portal;la_prompt_DisabledCategories' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS DisabledCategories FROM <%prefix%>Category WHERE Status = 0', NULL, 'la_prompt_DisabledCategories', 0, 2)",
	'In-Portal;la_prompt_NewCategories' => "(DEFAULT, 'In-Portal', 'SELECT COUNT() AS NewCategories FROM <%prefix%>Category WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name=\"Category_DaysNew\"%>86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewCategories', 0, 2)",
	'In-Portal;la_prompt_CategoryEditorsPick' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) FROM <%prefix%>Category WHERE EditorsPick = 1', NULL, 'la_prompt_CategoryEditorsPick', 0, 2)",
	'In-Portal;la_prompt_NewestCategoryDate' => "(DEFAULT, 'In-Portal', 'SELECT <%m:post_format field=\"MAX(CreatedOn)\" type=\"date\"%> FROM <%prefix%>Category', NULL, 'la_prompt_NewestCategoryDate', 0, 2)",
	'In-Portal;la_prompt_LastCategoryUpdate' => "(DEFAULT, 'In-Portal', 'SELECT <%m:post_format field=\"MAX(Modified)\" type=\"date\"%> FROM <%prefix%>Category', NULL, 'la_prompt_LastCategoryUpdate', 0, 2)",
	'In-Portal;la_prompt_TopicsUsers' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS TotalUsers FROM <%prefix%>PortalUser', NULL, 'la_prompt_TopicsUsers', 0, 2)",
	'In-Portal;la_prompt_UsersActive' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS ActiveUsers FROM <%prefix%>PortalUser WHERE Status = 1', NULL, 'la_prompt_UsersActive', 0, 2)",
	'In-Portal;la_prompt_UsersPending' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS PendingUsers FROM <%prefix%>PortalUser WHERE Status = 2', NULL, 'la_prompt_UsersPending', 0, 2)",
	'In-Portal;la_prompt_UsersDisabled' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS DisabledUsers FROM <%prefix%>PortalUser WHERE Status = 0', NULL, 'la_prompt_UsersDisabled', 0, 2)",
	'In-Portal;la_prompt_NewestUserDate' => "(DEFAULT, 'In-Portal', 'SELECT <%m:post_format field=\"MAX(CreatedOn)\" type=\"date\"%> FROM <%prefix%>PortalUser', NULL, 'la_prompt_NewestUserDate', 0, 2)",
	'In-Portal;la_prompt_UsersUniqueCountries' => "(DEFAULT, 'In-Portal', 'SELECT COUNT( DISTINCT LOWER( Country ) ) FROM <%prefix%>PortalUser WHERE LENGTH(Country) > 0', NULL, 'la_prompt_UsersUniqueCountries', 0, 2)",
	'In-Portal;la_prompt_UsersUniqueStates' => "(DEFAULT, 'In-Portal', 'SELECT COUNT( DISTINCT LOWER( State ) ) FROM <%prefix%>PortalUser WHERE LENGTH(State) > 0', NULL, 'la_prompt_UsersUniqueStates', 0, 2)",
	'In-Portal;la_prompt_TotalUserGroups' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS TotalUserGroups FROM <%prefix%>PortalGroup', NULL, 'la_prompt_TotalUserGroups', 0, 2)",
	'In-Portal;la_prompt_BannedUsers' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS BannedUsers FROM <%prefix%>PortalUser WHERE IsBanned = 1', NULL, 'la_prompt_BannedUsers', 0, 2)",
	'In-Portal;la_prompt_NonExpiredSessions' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS NonExipedSessions FROM <%prefix%>UserSession WHERE Status = 1', NULL, 'la_prompt_NonExpiredSessions', 0, 2)",
	'In-Portal;la_prompt_ThemeCount' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS ThemeCount FROM <%prefix%>Theme', NULL, 'la_prompt_ThemeCount', 0, 2)",
	'In-Portal;la_prompt_RegionsCount' => "(DEFAULT, 'In-Portal', 'SELECT COUNT(*) AS RegionsCount FROM <%prefix%>Language', NULL, 'la_prompt_RegionsCount', 0, 2)",
	'In-Portal;la_prompt_TablesCount' => "(DEFAULT, 'In-Portal', '<%m:sql_action sql=\"SHOW+TABLES\" action=\"COUNT\" field=\"*\"%>', NULL, 'la_prompt_TablesCount', 0, 2)",
	'In-Portal;la_prompt_RecordsCount' => "(DEFAULT, 'In-Portal', '<%m:sql_action sql=\"SHOW+TABLE+STATUS\" action=\"SUM\" field=\"Rows\"%>', NULL, 'la_prompt_RecordsCount', 0, 2)",
	'In-Portal;la_prompt_SystemFileSize' => "(DEFAULT, 'In-Portal', '<%m:custom_action sql=\"empty\" action=\"SysFileSize\"%>', NULL, 'la_prompt_SystemFileSize', 0, 2)",
	'In-Portal;la_prompt_DataSize' => "(DEFAULT, 'In-Portal', '<%m:sql_action sql=\"SHOW+TABLE+STATUS\" action=\"SUM\" format_as=\"file\" field=\"Data_length\"%>', NULL, 'la_prompt_DataSize', 0, 2)",
	),
	),

	'StylesheetSelectors' => Array (
	'UniqueField' => 'SelectorId',
	'Records' => Array (
	'169' => "(169, 8, 'Calendar''s selected days', '.calendar tbody .selected', 'a:0:{}', '', 1, 'font-weight: bold;\\\r\\nbackground-color: #9ED7ED;\\r\\nborder: 1px solid #83B2C5;', 0)",
	'118' => "(118, 8, 'Data grid row', 'td.block-data-row', 'a:0:{}', '', 2, 'border-bottom: 1px solid #cccccc;', 48)",
	'81' => "(81, 8, '\"More\" link', 'a.link-more', 'a:0:{}', '', 2, 'text-decoration: underline;', 64)",
	'88' => "(88, 8, 'Block data, separated rows', 'td.block-data-grid', 'a:0:{}', '', 2, 'border: 1px solid #cccccc;', 48)",
	'42' => "(42, 8, 'Block Header', 'td.block-header', 'a:4:{s:5:\"color\";s:16:\"rgb(0, 159, 240)\";s:9:\"font-size\";s:4:\"20px\";s:11:\"font-weight\";s:6:\"normal\";s:7:\"padding\";s:3:\"5px\";}', 'Block Header', 1, 'font-family: Verdana, Helvetica, sans-serif;', 0)",
	'76' => "(76, 8, 'Navigation bar menu', 'tr.head-nav td', 'a:0:{}', '', 1, 'vertical-align: middle;', 0)",
	'48' => "(48, 8, 'Block data', 'td.block-data', 'a:2:{s:9:\"font-size\";s:5:\"12px;\";s:7:\"padding\";s:3:\"5px\";}', '', 1, '', 0)",
	'78' => "(78, 8, 'Body main style', 'body', 'a:0:{}', '', 1, 'padding: 0px; \\r\\nbackground-color: #ffffff; \\r\\nfont-family: arial, verdana, helvetica; \\r\\nfont-size: small;\\r\\nwidth: auto;\\r\\nmargin: 0px;', 0)",
	'58' => "(58, 8, 'Main table', 'table.main-table', 'a:0:{}', '', 1, 'width: 770px;\\r\\nmargin: 0px;\\r\\n/table-layout: fixed;/', 0)",
	'79' => "(79, 8, 'Block: header of data block', 'span.block-data-grid-header', 'a:0:{}', '', 1, 'font-family: Arial, Helvetica, sans-serif;\\r\\ncolor: #009DF6;\\r\\nfont-size: 12px;\\r\\nfont-weight: bold;\\r\\nbackground-color: #E6EEFF;\\r\\npadding: 6px;\\r\\nwhite-space: nowrap;', 0)",
	'64' => "(64, 8, 'Link', 'a', 'a:0:{}', '', 1, '', 0)",
	'46' => "(46, 8, 'Product title link', 'a.link-product1', 'a:0:{}', 'Product title link', 1, 'color: #62A1DE;\\r\\nfont-size: 14px;\\r\\nfont-weight: bold;\\r\\nline-height: 20px;\\r\\npadding-bottom: 10px;', 0)",
	'75' => "(75, 8, 'Copy of Main path link', 'table.main-path td a:hover', 'a:0:{}', '', 1, 'color: #ffffff;', 0)",
	'160' => "(160, 8, 'Current item in navigation bar', '.checkout-step-current', 'a:0:{}', '', 1, 'color: #A20303;\\r\\nfont-weight: bold;', 0)",
	'51' => "(51, 8, 'Right block data', 'td.right-block-data', 'a:1:{s:9:\"font-size\";s:4:\"11px\";}', '', 2, 'padding: 7px;\\r\\nbackground: #e3edf6 url(\"/in-commerce4/themes/default/img/bgr_login.jpg\") repeat-y scroll left top;\\r\\nborder-bottom: 1px solid #64a1df;', 48)",
	'67' => "(67, 8, 'Pagination bar: text', 'table.block-pagination td', 'a:3:{s:5:\"color\";s:7:\"#8B898B\";s:9:\"font-size\";s:4:\"12px\";s:11:\"font-weight\";s:6:\"normal\";}', '', 1, '', 0)",
	'45' => "(45, 8, 'Category link', 'a.subcat', 'a:0:{}', 'Category link', 1, 'color: #2069A4', 0)",
	'68' => "(68, 8, 'Pagination bar: link', 'table.block-pagination td a', 'a:3:{s:5:\"color\";s:7:\"#8B898B\";s:9:\"font-size\";s:5:\"12px;\";s:11:\"font-weight\";s:6:\"normal\";}', '', 1, '', 0)",
	'69' => "(69, 8, 'Product description in product list', '.product-list-description', 'a:2:{s:5:\"color\";s:7:\"#8B898B\";s:9:\"font-size\";s:4:\"12px\";}', '', 1, '', 0)",
	'73' => "(73, 8, 'Main path link', 'table.main-path td a', 'a:0:{}', '', 1, 'color: #d5e231;', 0)",
	'83' => "(83, 8, 'Product title link in list (shopping cart)', 'a.link-product-cart', 'a:0:{}', 'Product title link', 1, 'color: #18559C;\\r\\nfont-size: 12px;\\r\\nfont-weight: bold;\\r\\ntext-decoration: none;\\r\\n\\r\\n', 0)",
	'72' => "(72, 8, 'Main path block text', 'table.main-path td', 'a:0:{}', '', 1, 'color: #ffffff;\\r\\nfont-size: 10px;\\r\\nfont-weight: normal;\\r\\npadding: 1px;\\r\\n', 0)",
	'61' => "(61, 8, 'Block: header of data table', 'td.block-data-grid-header', 'a:6:{s:4:\"font\";s:28:\"Arial, Helvetica, sans-serif\";s:5:\"color\";s:7:\"#009DF6\";s:9:\"font-size\";s:4:\"12px\";s:11:\"font-weight\";s:4:\"bold\";s:16:\"background-color\";s:7:\"#E6EEFF\";s:7:\"padding\";s:3:\"6px\";}', '', 1, 'white-space: nowrap;\\r\\npadding-left: 10px;\\r\\n/\\r\\nbackground-image: url(/in-commerce4/themes/default/img/bullet1.gif);\\r\\nbackground-position: 10px 12px;\\r\\nbackground-repeat: no-repeat;\\r\\n/', 0)",
	'65' => "(65, 8, 'Link in product list additional row', 'td.product-list-additional a', 'a:1:{s:5:\"color\";s:7:\"#8B898B\";}', '', 2, '', 64)",
	'55' => "(55, 8, 'Main table, left column', 'td.main-column-left', 'a:0:{}', '', 1, 'width:180px;\\r\\nborder: 1px solid #62A1DE;\\r\\nborder-top: 0px;', 0)",
	'70' => "(70, 8, 'Product title link in list (category)', 'a.link-product-category', 'a:0:{}', 'Product title link', 1, 'color: #18559C;\\r\\nfont-size: 12px;\\r\\nfont-weight: bold;\\r\\ntext-decoration: none;\\r\\n\\r\\n', 0)",
	'66' => "(66, 8, 'Pagination bar block', 'table.block-pagination', 'a:0:{}', '', 1, '', 0)",
	'49' => "(49, 8, 'Bulleted list inside block', 'td.block-data ul li', 'a:0:{}', '', 1, ' list-style-image: url(/in-commerce4/themes/default/img/bullet2.gif);\\r\\n margin-bottom: 10px;\\r\\n font-size: 11px;', 0)",
	'87' => "(87, 8, 'Cart item input form element', 'td.cart-item-atributes input', 'a:0:{}', '', 1, 'border: 1px solid #7BB2E6;', 0)",
	'119' => "(119, 8, 'Data grid row header', 'td.block-data-row-hdr', 'a:0:{}', 'Used in order preview', 2, 'background-color: #eeeeee;\\r\\nborder-bottom: 1px solid #dddddd;\\r\\nborder-top: 1px solid #cccccc;\\r\\nfont-weight: bold;', 48)",
	'82' => "(82, 8, '\"More\" link image', 'a.link-more img', 'a:0:{}', '', 2, 'text-decoration: none;\\r\\npadding-left: 5px;', 64)",
	'63' => "(63, 8, 'Additional info under product description in list', 'td.product-list-additional', 'a:5:{s:5:\"color\";s:7:\"#8B898B\";s:9:\"font-size\";s:4:\"11px\";s:11:\"font-weight\";s:6:\"normal\";s:10:\"border-top\";s:18:\"1px dashed #8B898B\";s:13:\"border-bottom\";s:18:\"1px dashed #8B898B\";}', '', 2, '', 48)",
	'43' => "(43, 8, 'Block', 'table.block', 'a:2:{s:16:\"background-color\";s:7:\"#E3EEF9\";s:6:\"border\";s:17:\"1px solid #64A1DF\";}', 'Block', 1, 'border: 0; \\r\\nmargin-bottom: 1px;\\r\\nwidth: 100%;', 0)",
	'84' => "(84, 8, 'Cart item cell', 'td.cart-item', 'a:0:{}', '', 1, 'background-color: #F6FAFF;\\r\\nborder-left: 1px solid #ffffff;\\r\\nborder-bottom: 1px solid #ffffff;\\r\\npadding: 4px;', 0)",
	'57' => "(57, 8, 'Main table, right column', 'td.main-column-right', 'a:0:{}', '', 1, 'width:220px;\\r\\nborder: 1px solid #62A1DE;\\r\\nborder-top: 0px;', 0)",
	'161' => "(161, 8, 'Block for sub categories', 'td.block-data-subcats', 'a:0:{}', '', 2, ' background: #FFFFFF\\r\\nurl(/in-commerce4/themes/default/in-commerce/img/bgr_categories.jpg);\\r\\n background-repeat: no-repeat;\\r\\n background-position: top right;\\r\\nborder-bottom: 5px solid #DEEAFF;\\r\\npadding-left: 10px;', 48)",
	'77' => "(77, 8, 'Left block header', 'td.left-block-header', 'a:0:{}', '', 2, 'font-family : verdana, helvetica, sans-serif;\\r\\ncolor : #ffffff;\\r\\nfont-size : 12px;\\r\\nfont-weight : bold;\\r\\ntext-decoration : none;\\r\\nbackground-color: #64a1df;\\r\\npadding: 5px;\\r\\npadding-left: 7px;', 42)",
	'80' => "(80, 8, 'Right block data - text', 'td.right-block-data td', 'a:1:{s:9:\"font-size\";s:5:\"11px;\";}', '', 2, '', 48)",
	'53' => "(53, 8, 'Right block header', 'td.right-block-header', 'a:0:{}', '', 2, 'font-family : verdana, helvetica, sans-serif;\\r\\ncolor : #ffffff;\\r\\nfont-size : 12px;\\r\\nfont-weight : bold;\\r\\ntext-decoration : none;\\r\\nbackground-color: #64a1df;\\r\\npadding: 5px;\\r\\npadding-left: 7px;', 42)",
	'85' => "(85, 8, 'Cart item cell with attributes', 'td.cart-item-attributes', 'a:0:{}', '', 1, 'background-color: #E6EEFF;\\r\\nborder-left: 1px solid #ffffff;\\r\\nborder-bottom: 1px solid #ffffff;\\r\\npadding: 4px;\\r\\ntext-align: center;\\r\\nvertical-align: middle;\\r\\nfont-size: 12px;\\r\\nfont-weight: normal;', 0)",
	'86' => "(86, 8, 'Cart item cell with name', 'td.cart-item-name', 'a:0:{}', '', 1, 'background-color: #F6FAFF;\\r\\nborder-left: 1px solid #ffffff;\\r\\nborder-bottom: 1px solid #ffffff;\\r\\npadding: 3px;', 0)",
	'47' => "(47, 8, 'Block content of featured product', 'td.featured-block-data', 'a:0:{}', '', 1, 'font-family: Arial,Helvetica,sans-serif;\\r\\nfont-size: 12px;', 0)",
	'56' => "(56, 8, 'Main table, middle column', 'td.main-column-center', 'a:0:{}', '', 1, '\\r\\n', 0)",
	'50' => "(50, 8, 'Product title link in list', 'a.link-product2', 'a:0:{}', 'Product title link', 1, 'color: #62A1DE;\\r\\nfont-size: 12px;\\r\\nfont-weight: bold;\\r\\ntext-decoration: none;\\r\\n\\r\\n', 0)",
	'71' => "(71, 8, 'Main path block', 'table.main-path', 'a:0:{}', '', 1, 'background: #61b0ec url(\"/in-commerce4/themes/default/img/bgr_path.jpg\") repeat-y scroll left top;\\r\\nwidth: 100%;\\r\\nmargin-bottom: 1px;\\r\\nmargin-right: 1px; \\r\\nmargin-left: 1px;', 0)",
	'62' => "(62, 8, 'Block: columns header for data table', 'table.block-no-border th', 'a:6:{s:4:\"font\";s:28:\"Arial, Helvetica, sans-serif\";s:5:\"color\";s:7:\"#18559C\";s:9:\"font-size\";s:4:\"11px\";s:11:\"font-weight\";s:4:\"bold\";s:16:\"background-color\";s:7:\"#B4D2EE\";s:7:\"padding\";s:3:\"6px\";}', '', 1, 'text-align: left;', 0)",
	'59' => "(59, 8, 'Block without border', 'table.block-no-border', 'a:0:{}', '', 1, 'border: 0px; \\r\\nmargin-bottom: 10px;\\r\\nwidth: 100%;', 0)",
	'74' => "(74, 8, 'Main path language selector cell', 'td.main-path-language', 'a:0:{}', '', 1, 'vertical-align: middle;\\r\\ntext-align: right;\\r\\npadding-right: 6px;', 0)",
	'171' => "(171, 8, 'Calendar''s highlighted day', '.calendar tbody .hilite', 'a:0:{}', '', 1, 'background-color: #f6f6f6;\\r\\nborder: 1px solid #83B2C5 !important;', 0)",
	'175' => "(175, 8, 'Calendar''s days', '.calendar tbody .day', 'a:0:{}', '', 1, 'text-align: right;\\r\\npadding: 2px 4px 2px 2px;\\r\\nwidth: 2em;\\r\\nborder: 1px solid #fefefe;', 0)",
	'170' => "(170, 8, 'Calendar''s weekends', '.calendar .weekend', 'a:0:{}', '', 1, 'color: #990000;', 0)",
	'173' => "(173, 8, 'Calendar''s control buttons', '.calendar .calendar_button', 'a:0:{}', '', 1, 'color: black;\\r\\nfont-size: 12px;\\r\\nbackground-color: #eeeeee;', 0)",
	'174' => "(174, 8, 'Calendar''s day names', '.calendar thead .name', 'a:0:{}', '', 1, 'background-color: #DEEEF6;\\r\\nborder-bottom: 1px solid #000000;', 0)",
	'172' => "(172, 8, 'Calendar''s top and bottom titles', '.calendar .title', 'a:0:{}', '', 1, 'color: #FFFFFF;\\r\\nbackground-color: #62A1DE;\\r\\nborder: 1px solid #107DC5;\\r\\nborder-top: 0px;\\r\\npadding: 1px;', 0)",
	'60' => "(60, 8, 'Block header for featured product', 'td.featured-block-header', 'a:0:{}', '', 2, '\\r\\n', 42)",
	'54' => "(54, 8, 'Right block', 'table.right-block', 'a:0:{}', '', 2, 'background-color: #E3EEF9;\\r\\nborder: 0px;\\r\\nwidth: 100%;', 43)",
	'44' => "(44, 8, 'Block content', 'td.block-data-big', 'a:0:{}', 'Block content', 1, ' background: #DEEEF6\\r\\nurl(/in-commerce4/themes/default/img/menu_bg.gif);\\r\\n background-repeat: no-repeat;\\r\\n background-position: top right;\\r\\n', 0)",
	),
	),

	'Stylesheets' => Array (
	'UniqueField' => 'StylesheetId',
	'Records' => Array (
	'8' => "(8, 'Default', 'In-Portal Default Theme', '', 1124952555, 1)",
	),
	),

	'Counters' => Array (
	'UniqueField' => 'Name',
	'Records' => Array (
	'members_count' => "(DEFAULT, 'members_count', 'SELECT COUNT(*) FROM <%PREFIX%>PortalUser WHERE Status = 1', NULL , NULL , '3600', '0', '\|PortalUser\|')",
	'members_online' => "(DEFAULT, 'members_online', 'SELECT COUNT(*) FROM <%PREFIX%>UserSession WHERE PortalUserId > 0', NULL , NULL , '3600', '0', '\|UserSession\|')",
	'guests_online' => "(DEFAULT, 'guests_online', 'SELECT COUNT(*) FROM <%PREFIX%>UserSession WHERE PortalUserId <= 0', NULL , NULL , '3600', '0', '\|UserSession\|')",
	'users_online' => "(DEFAULT, 'users_online', 'SELECT COUNT(*) FROM <%PREFIX%>UserSession', NULL , NULL , '3600', '0', '\|UserSession\|')",
	),
	),
	);

	// check & insert if not found defined before data
	foreach ($data as $table_name => $table_info) {
	$unique_fields = explode(';', $table_info['UniqueField']);
	foreach ($table_info['Records'] as $unique_value => $insert_sql) {
	$unique_values = explode(';', $unique_value);

	$where_clause = Array ();
	foreach ($unique_fields as $field_index => $unique_field) {
	$where_clause[] = $unique_field . ' = ' . $this->Conn->qstr($unique_values[$field_index]);
	}

	$sql = 'SELECT ' . implode(', ', $unique_fields) . '
	FROM ' . TABLE_PREFIX . $table_name . '
	WHERE (' . implode(') AND (', $where_clause) . ')';
	$found = $this->Conn->GetRow($sql);
	if ($found) {
	$found = implode(';', $found);
	}

	if ($found != $unique_value) {
	$this->Conn->Query('INSERT INTO ' . TABLE_PREFIX . $table_name . ' VALUES ' . $insert_sql);
	}
	}
	}
	}

	/**
	* Removes duplicate phrases per language basis (created during proj-base and in-portal shared installation)
	*
	*/
	function _removeDuplicatePhrases()
	{
	$id_field = $this->Application->getUnitOption('phrases', 'IDField');
	$table_name = $this->Application->getUnitOption('phrases', 'TableName');

	$sql = 'SELECT LanguageId, Phrase, MIN(LastChanged) AS LastChanged, COUNT(*) AS DupeCount
	FROM ' . $table_name . '
	GROUP BY LanguageId, Phrase
	HAVING COUNT(*) > 1';
	$duplicate_phrases = $this->Conn->Query($sql);

	foreach ($duplicate_phrases as $phrase_record) {
	// 1. keep phrase, that was added first, because it is selected in PhrasesCache::LoadPhraseByLabel
	$where_clause = Array (
	'LanguageId = ' . $phrase_record['LanguageId'],
	'Phrase = ' . $this->Conn->qstr($phrase_record['Phrase']),
	'LastChanged' . ' = ' . $phrase_record['LastChanged'],
	);

	$sql = 'SELECT ' . $id_field . '
	FROM ' . $table_name . '
	WHERE (' . implode(') AND (', $where_clause) . ')';
	$phrase_id = $this->Conn->GetOne($sql);

	// 2. delete all other duplicates
	$where_clause = Array (
	'LanguageId = ' . $phrase_record['LanguageId'],
	'Phrase = ' . $this->Conn->qstr($phrase_record['Phrase']),
	$id_field . ' <> ' . $phrase_id,
	);

	$sql = 'DELETE FROM ' . $table_name . '
	WHERE (' . implode(') AND (', $where_clause) . ')';
	$this->Conn->Query($sql);
	}
	}

	function _moveDatabaseFolders()
	{
	// Tables: PageContent, Images
	if ($this->Conn->TableFound('PageContent')) {
	// 1. replaces "/kernel/user_files/" references in content blocks
	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	/* @var $ml_helper kMultiLanguageHelper */

	$language_count = $ml_helper->getLanguageCount();
	$replace_sql = '%1$s = REPLACE(%1$s, "/kernel/user_files/", "/system/user_files/")';

	$update_sqls = Array ();
	for ($i = 1; $i <= $language_count; $i++) {
	if (!$ml_helper->LanguageFound($i)) {
	continue;
	}

	$field = 'l' . $i . '_Content';
	$update_sqls[] = sprintf($replace_sql, $field);
	}

	if ($update_sqls) {
	$sql = 'UPDATE ' . TABLE_PREFIX . 'PageContent
	SET ' . implode(', ', $update_sqls);
	$this->Conn->Query($sql);
	}
	}

	// 2. replace path of images uploaded via "Images" tab of category items
	$this->_replaceImageFolder('/kernel/images/', '/system/images/');

	// 3. replace path of images uploaded via "Images" tab of category items (when badly formatted)
	$this->_replaceImageFolder('kernel/images/', 'system/images/');

	// 4. replace images uploaded via "In-Bulletin -> Emoticons" section
	$this->_replaceImageFolder('in-bulletin/images/emoticons/', 'system/images/emoticons/');

	// 5. update backup path in config
	$this->_toolkit->saveConfigValues(
	Array (
	'Backup_Path' => FULL_PATH . '/system/backupdata'
	)
	);
	}

	/**
	* Replaces mentions of "/kernel/images" folder in Images table
	*
	* @param string $from
	* @param string $to
	*/
	function _replaceImageFolder($from, $to)
	{
	$replace_sql = '%1$s = REPLACE(%1$s, "' . $from . '", "' . $to . '")';
	$sql = 'UPDATE ' . TABLE_PREFIX . 'Images
	SET ' . sprintf($replace_sql, 'ThumbPath') . ', ' . sprintf($replace_sql, 'LocalPath');
	$this->Conn->Query($sql);
	}


	/**
	* Update colors in skin (only if they were not changed manually)
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_5_0_0($mode)
	{
	if ($mode == 'before') {
	$this->_removeDuplicatePhrases(); // because In-Commerce & In-Link share some phrases with Proj-CMS
	$this->_createProjCMSTables();
	$this->_addMissingConfigurationVariables();
	}

	if ($mode == 'after') {
	$this->_fixSkinColors();
	$this->_restructureCatalog();
	$this->_sortImages();

	// $this->_sortConfigurationVariables('In-Portal', 'in-portal:configure_general');
	// $this->_sortConfigurationVariables('In-Portal', 'in-portal:configure_advanced');
	}
	}

	function _sortConfigurationVariables($module, $section)
	{
	$sql = 'SELECT ca.heading, cv.VariableName
	FROM ' . TABLE_PREFIX . 'ConfigurationAdmin ca
	LEFT JOIN ' . TABLE_PREFIX . 'ConfigurationValues cv USING(VariableName)
	WHERE (cv.ModuleOwner = ' . $this->Conn->qstr($module) . ') AND (cv.Section = ' . $this->Conn->qstr($section) . ')
	ORDER BY ca.DisplayOrder asc, ca.GroupDisplayOrder asc';
	$variables = $this->Conn->GetCol($sql, 'VariableName');

	if (!$variables) {
	return ;
	}

	$variables = $this->_groupRecords($variables);

	$group_number = 0;
	$variable_order = 1;

	$prev_heading = '';

	foreach ($variables as $variable_name => $variable_heading) {
	if ($prev_heading != $variable_heading) {
	$group_number++;
	$variable_order = 1;
	}

	$sql = 'UPDATE ' . TABLE_PREFIX . 'ConfigurationAdmin
	SET DisplayOrder = ' . $this->Conn->qstr($group_number * 10 + $variable_order / 100) . '
	WHERE VariableName = ' . $this->Conn->qstr($variable_name);
	$this->Conn->Query($sql);

	$variable_order++;
	$prev_heading = $variable_heading;
	}
	}

	/**
	* Group list records by header, saves internal order in group
	*
	* @param Array $records
	* @param string $heading_field
	*/
	function _groupRecords($variables)
	{
	$sorted = Array();

	foreach ($variables as $variable_name => $variable_heading) {
	$sorted[$variable_heading][] = $variable_name;
	}

	$variables = Array();
	foreach ($sorted as $heading => $heading_records) {
	foreach ($heading_records as $variable_name) {
	$variables[$variable_name] = $heading;
	}
	}

	return $variables;
	}

	/**
	* Returns module root category
	*
	* @param string $module_name
	* @return int
	*/
	function _getRootCategory($module_name)
	{
	// don't cache anything here (like in static variables), because database value is changed on the fly !!!
	$sql = 'SELECT RootCat
	FROM ' . TABLE_PREFIX . 'Modules
	WHERE LOWER(Name) = ' . $this->Conn->qstr( strtolower($module_name) );
	$root_category = $this->Conn->GetOne($sql);

	// put to cache too, because CategoriesEventHandler::_prepareAutoPage uses kApplication::findModule
	$this->Application->ModuleInfo[$module_name]['Name'] = $module_name;
	$this->Application->ModuleInfo[$module_name]['RootCat'] = $root_category;

	return $root_category;
	}

	/**
	* Move all categories (except "Content") from "Home" to "Content" category and hide them from menu
	*
	*/
	function _restructureCatalog()
	{
	$root_category = $this->_getRootCategory('Core');

	$sql = 'SELECT CategoryId
	FROM ' . TABLE_PREFIX . 'Category
	WHERE ParentId = 0 AND CategoryId <> ' . $root_category;
	$top_categories = $this->Conn->GetCol($sql);

	if ($top_categories) {
	// hide all categories located outside "Content" category from menu
	$sql = 'UPDATE ' . TABLE_PREFIX . 'Category
	SET IsMenu = 0
	WHERE (ParentPath LIKE "\|' . implode('\|%") OR (ParentPath LIKE "\|', $top_categories) . '\|%")';
	$this->Conn->Query($sql);

	// move all top level categories under "Content" category and make them visible in menu
	$sql = 'UPDATE ' . TABLE_PREFIX . 'Category
	SET IsMenu = 1, ParentId = ' . $root_category . '
	WHERE ParentId = 0 AND CategoryId <> ' . $root_category;
	$this->Conn->Query($sql);
	}

	// make sure, that all categories have valid value for Priority field

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

	$event = new kEvent('c:OnListBuild');

	// update all categories, because they are all under "Content" category now
	$sql = 'SELECT CategoryId
	FROM ' . TABLE_PREFIX . 'Category';
	$categories = $this->Conn->GetCol($sql);

	foreach ($categories as $category_id) {
	$priority_helper->recalculatePriorities($event, 'ParentId = ' . $category_id);
	}

	// create initial theme structure in Category table
	$this->_toolkit->rebuildThemes();

	// make sure, that all system templates have ThemeId set (only possible during platform project upgrade)
	$sql = 'SELECT ThemeId
	FROM ' . TABLE_PREFIX . 'Theme
	WHERE PrimaryTheme = 1';
	$primary_theme_id = $this->Conn->GetOne($sql);

	if ($primary_theme_id) {
	$sql = 'UPDATE ' . TABLE_PREFIX . 'Category
	SET ThemeId = ' . $primary_theme_id . '
	WHERE IsSystem = 1 AND ThemeId = 0';
	$this->Conn->Query($sql);
	}
	}

	/**
	* Changes skin colors to match new ones (only in case, when they match default values)
	*
	*/
	function _fixSkinColors()
	{
	$skin =& $this->Application->recallObject('skin', null, Array ('skip_autoload' => 1));
	/* @var $skin kDBItem */

	$skin->Load(1, 'IsPrimary');
	if ($skin->isLoaded()) {
	$skin_options = unserialize( $skin->GetDBField('Options') );

	$changes = Array (
	// option: from -> to
	'HeadBgColor' => Array ('#1961B8', '#007BF4'),
	'HeadBarColor' => Array ('#FFFFFF', '#000000'),
	);

	$can_change = true;
	foreach ($changes as $option_name => $change) {
	list ($change_from, $change_to) = $change;

	$can_change = $can_change && ($change_from == $skin_options[$option_name]['Value']);
	if ($can_change) {
	$skin_options[$option_name]['Value'] = $change_to;
	}
	}

	if ($can_change) {
	$skin->SetDBField('Options', serialize($skin_options));
	$skin->Update();

	- $skin_eh =& $this->Application->recallObject('skin_EventHandler');
	- /* @var $skin_eh SkinEventHandler */
	+ $skin_helper =& $this->Application->recallObject('SkinHelper');
	+ /* @var $skin_helper SkinHelper */

	- $skin_eh->Compile($skin);
	+ $skin_file = $skin_helper->getSkinPath();
	+ if (file_exists($skin_file)) {
	+ unlink($skin_file);
	+ }
	}
	}
	}

	/**
	* 1. Set root category not to generate filename automatically and hide it from catalog
	* 2. Hide root category of In-Edit and set it's fields
	*
	* @param int $category_id
	*/
	function _resetRootCategory($category_id)
	{
	$fields_hash = Array (
	'l1_Name' => 'Content', 'Filename' => 'Content', 'AutomaticFilename' => 0,
	'l1_Description' => 'Content', 'Status' => 4,
	);

	$this->Conn->doUpdate($fields_hash, TABLE_PREFIX . 'Category', 'CategoryId = ' . $category_id);
	}

	function _createProjCMSTables()
	{
	// 0. make sure, that Content category exists
	$root_category = $this->_getRootCategory('Proj-CMS');
	if ($root_category) {
	// proj-cms module found -> remove it
	$sql = 'DELETE FROM ' . TABLE_PREFIX . 'Modules
	WHERE Name = "Proj-CMS"';
	$this->Conn->Query($sql);
	unset($this->Application->ModuleInfo['Proj-CMS']);

	$this->_resetRootCategory($root_category);

	// unhide all structure categories
	$sql = 'UPDATE ' . TABLE_PREFIX . 'Category
	SET Status = 1
	WHERE (Status = 4) AND (CategoryId <> ' . $root_category . ')';
	$this->Conn->Query($sql);
	} else {
	$root_category = $this->_getRootCategory('In-Edit');
	if ($root_category) {
	// in-edit module found -> remove it
	$sql = 'DELETE FROM ' . TABLE_PREFIX . 'Modules
	WHERE Name = "In-Edit"';
	$this->Conn->Query($sql);
	unset($this->Application->ModuleInfo['In-Edit']);

	$this->_resetRootCategory($root_category);
	}
	}

	if (!$root_category) {
	// create "Content" category when Proj-CMS/In-Edit module was not installed before
	// use direct sql here, because category table structure doesn't yet match table structure in object

	$fields_hash = Array (
	'l1_Name' => 'Content', 'Filename' => 'Content', 'AutomaticFilename' => 0,
	'l1_Description' => 'Content', 'Status' => 4,
	);

	$this->Conn->doInsert($fields_hash, TABLE_PREFIX . 'Category');

	$root_category = $this->Conn->getInsertID();
	}

	$this->_toolkit->deleteCache();
	$this->_toolkit->SetModuleRootCategory('Core', $root_category);

	// 1. process "Category" table
	$structure = $this->Conn->Query('DESCRIBE ' . TABLE_PREFIX . 'Category', 'Field');
	if (!array_key_exists('Template', $structure)) {
	// fields from "Pages" table were not added to "Category" table (like before "Proj-CMS" module install)
	$sql = "ALTER TABLE " . TABLE_PREFIX . "Category
	ADD COLUMN Template varchar(255) default NULL,
	ADD COLUMN l1_Title varchar(255) default '',
	ADD COLUMN l2_Title varchar(255) default '',
	ADD COLUMN l3_Title varchar(255) default '',
	ADD COLUMN l4_Title varchar(255) default '',
	ADD COLUMN l5_Title varchar(255) default '',
	ADD COLUMN l1_MenuTitle varchar(255) NOT NULL default '',
	ADD COLUMN l2_MenuTitle varchar(255) NOT NULL default '',
	ADD COLUMN l3_MenuTitle varchar(255) NOT NULL default '',
	ADD COLUMN l4_MenuTitle varchar(255) NOT NULL default '',
	ADD COLUMN l5_MenuTitle varchar(255) NOT NULL default '',
	ADD COLUMN MetaTitle text,
	ADD COLUMN IndexTools text,
	ADD COLUMN IsIndex tinyint(1) NOT NULL default '0',
	ADD COLUMN IsMenu TINYINT(4) NOT NULL DEFAULT '1',
	ADD COLUMN IsSystem tinyint(4) NOT NULL default '0',
	ADD COLUMN FormId int(11) default NULL,
	ADD COLUMN FormSubmittedTemplate varchar(255) default NULL,
	ADD COLUMN l1_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l2_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l3_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l4_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l5_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN FriendlyURL varchar(255) NOT NULL default '',
	ADD INDEX IsIndex (IsIndex),
	ADD INDEX l1_Translated (l1_Translated),
	ADD INDEX l2_Translated (l2_Translated),
	ADD INDEX l3_Translated (l3_Translated),
	ADD INDEX l4_Translated (l4_Translated),
	ADD INDEX l5_Translated (l5_Translated)";
	$this->Conn->Query($sql);
	}

	if (array_key_exists('Path', $structure)) {
	$sql = 'ALTER TABLE ' . TABLE_PREFIX . 'Category
	DROP Path';
	$this->Conn->Query($sql);
	}

	// 2. process "PageContent" table
	if ($this->Conn->TableFound(TABLE_PREFIX . 'PageContent')) {
	$structure = $this->Conn->Query('DESCRIBE ' . TABLE_PREFIX . 'PageContent', 'Field');
	if (!array_key_exists('l1_Translated', $structure)) {
	$sql = "ALTER TABLE " . TABLE_PREFIX . "PageContent
	ADD COLUMN l1_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l2_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l3_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l4_Translated tinyint(4) NOT NULL default '0',
	ADD COLUMN l5_Translated tinyint(4) NOT NULL default '0'";
	$this->Conn->Query($sql);
	}
	}

	// 3. process "FormFields" table
	if ($this->Conn->TableFound(TABLE_PREFIX . 'FormFields')) {
	$structure = $this->Conn->Query('DESCRIBE ' . TABLE_PREFIX . 'FormFields', 'Field');
	if (!$structure['FormId']['Key']) {
	$sql = "ALTER TABLE " . TABLE_PREFIX . "FormFields
	CHANGE Validation Validation TINYINT NOT NULL DEFAULT '0',
	ADD INDEX FormId (FormId),
	ADD INDEX Priority (Priority),
	ADD INDEX IsSystem (IsSystem),
	ADD INDEX DisplayInGrid (DisplayInGrid)";
	$this->Conn->Query($sql);
	}
	}
	else {
	$this->Conn->Query("INSERT INTO " . TABLE_PREFIX . "Permissions VALUES (DEFAULT, 'in-portal:forms.view', 11, 1, 1, 0)");
	$this->Conn->Query("INSERT INTO " . TABLE_PREFIX . "Permissions VALUES (DEFAULT, 'in-portal:forms.add', 11, 1, 1, 0)");
	$this->Conn->Query("INSERT INTO " . TABLE_PREFIX . "Permissions VALUES (DEFAULT, 'in-portal:forms.edit', 11, 1, 1, 0)");
	$this->Conn->Query("INSERT INTO " . TABLE_PREFIX . "Permissions VALUES (DEFAULT, 'in-portal:forms.delete', 11, 1, 1, 0)");
	}

	// 4. process "FormSubmissions" table
	if ($this->Conn->TableFound(TABLE_PREFIX . 'FormSubmissions')) {
	$structure = $this->Conn->Query('DESCRIBE ' . TABLE_PREFIX . 'FormSubmissions', 'Field');
	if (!$structure['SubmissionTime']['Key']) {
	$sql = "ALTER TABLE " . TABLE_PREFIX . "FormSubmissions
	ADD INDEX SubmissionTime (SubmissionTime)";
	$this->Conn->Query($sql);
	}
	}
	else {
	$this->Conn->Query("INSERT INTO " . TABLE_PREFIX . "Permissions VALUES (DEFAULT, 'in-portal:submissions.view', 11, 1, 1, 0)");
	}

	// 5. add missing event
	$sql = 'SELECT EventId
	FROM ' . TABLE_PREFIX . 'Events
	WHERE (Event = "FORM.SUBMITTED") AND (Type = 1)';
	$event_id = $this->Conn->GetOne($sql);

	if (!$event_id) {
	$sql = "INSERT INTO " . TABLE_PREFIX . "Events VALUES (DEFAULT, 'FORM.SUBMITTED', NULL, 1, 0, 'Core:Category', 'la_event_FormSubmitted', 1)";
	$this->Conn->Query($sql);
	}

	$sql = 'SELECT EventId
	FROM ' . TABLE_PREFIX . 'Events
	WHERE (Event = "FORM.SUBMITTED") AND (Type = 0)';
	$event_id = $this->Conn->GetOne($sql);

	if (!$event_id) {
	$sql = "INSERT INTO " . TABLE_PREFIX . "Events VALUES (DEFAULT, 'FORM.SUBMITTED', NULL, 1, 0, 'Core:Category', 'la_event_FormSubmitted', 0)";
	$this->Conn->Query($sql);
	}
	}

	function _addMissingConfigurationVariables()
	{
	$variables = Array (
	'cms_DefaultDesign' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('cms_DefaultDesign', 'la_Text_General', 'la_prompt_DefaultDesignTemplate', 'text', NULL, NULL, 10.15, 0, 0)",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'cms_DefaultDesign', '/platform/designs/general', 'In-Portal', 'in-portal:configure_categories')",
	),

	'Require_AdminSSL' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('Require_AdminSSL', 'la_Text_Website', 'la_config_RequireSSLAdmin', 'checkbox', '', '', 10.105, 0, 1)",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'Require_AdminSSL', '', 'In-Portal', 'in-portal:configure_advanced')",
	),

	'UsePopups' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('UsePopups', 'la_Text_Website', 'la_config_UsePopups', 'radio', '', '1=la_Yes,0=la_No', 10.221, 0, 0)",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'UsePopups', '1', 'In-Portal', 'in-portal:configure_advanced')",
	),

	'UseDoubleSorting' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('UseDoubleSorting', 'la_Text_Website', 'la_config_UseDoubleSorting', 'radio', '', '1=la_Yes,0=la_No', 10.222, 0, 0)",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'UseDoubleSorting', '0', 'In-Portal', 'in-portal:configure_advanced')",
	),

	'MenuFrameWidth' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('MenuFrameWidth', 'la_title_General', 'la_prompt_MenuFrameWidth', 'text', NULL, NULL, 10.31, 0, 0)",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'MenuFrameWidth', 200, 'In-Portal', 'in-portal:configure_advanced')",
	),

	'DefaultSettingsUserId' => Array (
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationAdmin VALUES ('DefaultSettingsUserId', 'la_title_General', 'la_prompt_DefaultUserId', 'text', NULL, NULL, '10.06', '0', '0')",
	"INSERT INTO " . TABLE_PREFIX . "ConfigurationValues VALUES (DEFAULT, 'DefaultSettingsUserId', -1, 'In-Portal:Users', 'in-portal:configure_users')",
	),
	);

	foreach ($variables as $variable_name => $variable_sqls) {
	$sql = 'SELECT VariableId
	FROM ' . TABLE_PREFIX . 'ConfigurationValues
	WHERE VariableName = ' . $this->Conn->qstr($variable_name);
	$variable_id = $this->Conn->GetOne($sql);

	if ($variable_id) {
	continue;
	}

	foreach ($variable_sqls as $variable_sql) {
	$this->Conn->Query($variable_sql);
	}
	}
	}

	/**
	* Sort images in database (update Priority field)
	*
	*/
	function _sortImages()
	{
	$sql = 'SELECT *
	FROM ' . TABLE_PREFIX . 'Images
	ORDER BY ResourceId ASC , DefaultImg DESC , ImageId ASC';
	$images = $this->Conn->Query($sql);

	$priority = 0;
	$last_resource_id = false;

	foreach ($images as $image) {
	if ($image['ResourceId'] != $last_resource_id) {
	// each item have own priorities among it's images
	$priority = 0;
	$last_resource_id = $image['ResourceId'];
	}

	if (!$image['DefaultImg']) {
	$priority--;
	}

	$sql = 'UPDATE ' . TABLE_PREFIX . 'Images
	SET Priority = ' . $priority . '
	WHERE ImageId = ' . $image['ImageId'];
	$this->Conn->Query($sql);
	}
	}
	}
	\ No newline at end of file

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options