in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sat, Feb 22, 6:05 AM

in-portal
View Options

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

	defined('FULL_PATH') or die('restricted access!');

	/**
	* Performs action on multilingual fields
	*
	*/
	class kMultiLanguageHelper extends kHelper {

	/**
	* Maximal language id
	*
	* @var int
	*/
	var $languageCount = 0;

	/**
	* Languages created in system
	*
	* @var Array
	*/
	var $languagesIDs = Array ();

	/**
	* Structure of table, that is currently processed
	*
	* @var Array
	*/
	var $curStructure = Array();

	/**
	* Field, to get structure information from
	*
	* @var string
	*/
	var $curSourceField = false;

	/**
	* Indexes used in table of 32
	*
	* @var int
	*/
	var $curIndexCount = 0;

	/**
	* Fields from config, that are currently used
	*
	* @var Array
	*/
	var $curFields = Array();

	function kMultiLanguageHelper()
	{
	parent::kHelper();
	$this->languageCount = $this->getLanguageCount();
	}

	/**
	* Checks if language with specified id is created
	*
	* @param int $language_id
	* @return bool
	*/
	function LanguageFound($language_id)
	{
	return in_array($language_id, $this->languagesIDs) \|\| $language_id <= 5;
	}

	/**
	* Returns language count in system (always is divisible by 5)
	*
	*/
	function getLanguageCount()
	{
	if ($this->languageCount) {
	return $this->languageCount;
	}

	$id_field = $this->Application->getUnitOption('lang', 'IDField');
	$table_name = $this->Application->getUnitOption('lang', 'TableName');

	$this->languagesIDs = $this->Conn->GetCol('SELECT '.$id_field.' FROM '.$table_name);

	$languages_count = $this->Conn->GetOne('SELECT MAX('.$id_field.') FROM '.$table_name);

	return max($languages_count, 5);
	}


	function scanTable($mask)
	{
	$i = 0;
	$fields_found = 0;
	$fields = array_keys($this->curStructure);

	foreach ($fields as $field_name) {
	if (preg_match($mask, $field_name)) {
	$fields_found++;
	}
	}
	return $fields_found;
	}

	function readTableStructure($table_name, $refresh = false)
	{
	// if ($refresh \|\| !getArrayValue($structure_status, $prefix.'.'.$table_name)) {
	$this->curStructure = $this->Conn->Query('DESCRIBE '.$table_name, 'Field');
	$this->curIndexCount = count($this->Conn->Query('SHOW INDEXES FROM '.$table_name));
	// }
	}

	/**
	* Creates missing multilanguage fields in table by specified prefix
	*
	* @param string $prefix
	* @param bool $refresh Forces config field structure to be re-read from database
	*/
	function createFields($prefix, $refresh = false)
	{
	if ($refresh && preg_match('/(.*)-cdata$/', $prefix, $regs)) {
	// call main item config to clone cdata table
	$this->Application->UnitConfigReader->loadConfig($regs[1]);
	$this->Application->UnitConfigReader->runAfterConfigRead($prefix);
	}

	$table_name = $this->Application->getUnitOption($prefix, 'TableName');
	$this->curFields = $this->Application->getUnitOption($prefix, 'Fields');

	if (!($table_name && $this->curFields) \|\| ($table_name && !$this->Conn->TableFound($table_name))) {
	// invalid config found or prefix not found
	return true;
	}

	$sqls = Array();
	$this->readTableStructure($table_name, $refresh);

	foreach($this->curFields as $field_name => $field_options)
	{
	if (getArrayValue($field_options, 'formatter') == 'kMultiLanguage') {
	if (isset($field_options['master_field'])) {
	unset($this->curFields[$field_name]);
	continue;
	}

	$this->setSourceField($field_name);
	if ($this->languageCount > 0) {
	// `l77_Name` VARCHAR( 255 ) NULL DEFAULT '0';
	$field_mask = Array();
	$field_mask['name'] = 'l%s_'.$field_name;
	$field_mask['null'] = getArrayValue($field_options, 'not_null') ? 'NOT NULL' : 'NULL';

	if ($this->curSourceField) {
	$default_value = $this->getFieldParam('Default') != 'NULL' ? $this->Conn->qstr($this->getFieldParam('Default')) : $this->getFieldParam('Default');
	$field_mask['type'] = $this->getFieldParam('Type');
	}
	else {
	$default_value = is_null($field_options['default']) ? 'NULL' : $this->Conn->qstr($field_options['default']);
	$field_mask['type'] = $field_options['db_type'];
	}
	$field_mask['default'] = ($field_mask['null'] == 'NOT NULL' && $default_value == 'NULL') ? '' : 'DEFAULT '.$default_value;

	if (strtoupper($field_mask['type']) == 'TEXT') {
	// text fields in mysql doesn't have default value
	$field_mask = $field_mask['name'].' '.$field_mask['type'].' '.$field_mask['null'];
	}
	else {
	$field_mask = $field_mask['name'].' '.$field_mask['type'].' '.$field_mask['null'].' '.$field_mask['default'];
	}

	$alter_sqls = $this->generateAlterSQL($field_mask, 1, $this->languageCount);
	if ($alter_sqls) {
	$sqls[] = 'ALTER TABLE '.$table_name.' '.$alter_sqls;
	}
	}
	}
	}

	foreach ($sqls as $sql_query) {
	$this->Conn->Query($sql_query);
	}
	}

	+ /**
	+ * Creates missing multilanguage fields in table by specified prefix
	+ *
	+ * @param string $prefix
	+ * @param int $src_language
	+ * @param int $dst_language
	+ */
	+ function copyMissingData($prefix, $src_language, $dst_language)
	+ {
	+ $table_name = $this->Application->getUnitOption($prefix, 'TableName');
	+ $this->curFields = $this->Application->getUnitOption($prefix, 'Fields');
	+
	+ if (!($table_name && $this->curFields) \|\| ($table_name && !$this->Conn->TableFound($table_name))) {
	+ // invalid config found or prefix not found
	+ return true;
	+ }
	+
	+ foreach ($this->curFields as $field_name => $field_options) {
	+ $formatter = isset($field_options['formatter']) ? $field_options['formatter'] : '';
	+
	+ if ( ($formatter == 'kMultiLanguage') && !isset($field_options['master_field']) ) {
	+ $sql = 'UPDATE ' . $table_name . '
	+ SET l' . $dst_language . '_' . $field_name . ' = l' . $src_language . '_' . $field_name . '
	+ WHERE l' . $dst_language . '_' . $field_name . ' = "" OR l' . $dst_language . '_' . $field_name . ' IS NULL';
	+ $this->Conn->Query($sql);
	+ }
	+ }
	+ }
	+
	function deleteField($prefix, $custom_id)
	{
	$table_name = $this->Application->getUnitOption($prefix, 'TableName');
	$sql = 'DESCRIBE '.$table_name.' "l%_cust_'.$custom_id.'"';
	$fields = $this->Conn->GetCol($sql);

	$sql = 'ALTER TABLE '.$table_name.' ';
	$sql_template = 'DROP COLUMN %s, ';

	foreach ($fields as $field_name) {
	$sql .= sprintf($sql_template, $field_name);
	}

	$this->Conn->Query( substr($sql, 0, -2) );
	}

	/**
	* Returns parameter requested of current source field
	*
	* @param string $param_name
	* @return string
	*/
	function getFieldParam($param_name)
	{
	return $this->curStructure[$this->curSourceField][$param_name];
	}

	/**
	* Detects field name to create other fields from
	*
	* @param string $field_name
	*/
	function setSourceField($field_name)
	{
	$ret = $this->scanTable('/^l[\d]+_'.preg_quote($field_name, '/').'$/');
	if (!$ret) {
	// no multilingual fields at all (but we have such field without language prefix)
	$original_found = $this->scanTable('/^'.preg_quote($field_name, '$/').'/');
	$this->curSourceField = $original_found ? $field_name : false;
	}
	else {
	$this->curSourceField = 'l1_'.$field_name;
	}
	}

	/**
	* Returns ALTER statement part for adding required fields to table
	*
	* @param string $field_mask sql mask for creating field with correct definition (type & size)
	* @param int $start_index add new fields starting from this index
	* @param int $create_count create this much new multilingual field translations
	* @return string
	*/
	function generateAlterSQL($field_mask, $start_index, $create_count)
	{
	static $single_lang = null;
	if (!isset($single_lang)) {
	// if single language mode, then create indexes only on primary columns
	$table_name = $this->Application->getUnitOption('lang', 'TableName');
	$sql = 'SELECT COUNT(*)
	FROM '.$table_name.'
	WHERE Enabled = 1';
	// if language count = 0, then assume it's multi language mode
	$single_lang = $this->Conn->GetOne($sql) == 1;
	}

	$ret = '';
	$ml_field = preg_replace('/l(.?)_(.?) (.*)/', '\\2', $field_mask);

	$i_count = $start_index + $create_count;
	while ($start_index < $i_count) {

	if (isset($this->curStructure['l'.$start_index.'_'.$ml_field]) \|\| (!$this->LanguageFound($start_index)) ) {
	$start_index++;
	continue;
	}

	$prev_index = $start_index - 1;
	do {
	list($prev_field,$type) = explode(' ', sprintf($field_mask, $prev_index) );
	} while ($prev_index > 0 && !$this->LanguageFound($prev_index--));

	if (substr($prev_field, 0, 3) == 'l0_') {
	$prev_field = substr($prev_field, 3, strlen($prev_field));
	if (!$this->curSourceField) {
	// get field name before this one
	$fields = array_keys($this->curFields);
	// $prev_field = key(end($this->curStructure));
	$prev_field = $fields[array_search($prev_field, $fields) - 1];
	if (getArrayValue($this->curFields[$prev_field], 'formatter') == 'kMultiLanguage') {
	$prev_field = 'l'.$this->languageCount.'_'.$prev_field;
	}
	}
	}

	$field_expression = sprintf($field_mask, $start_index);
	$ret .= 'ADD COLUMN '.$field_expression.' AFTER `'.$prev_field.'`, ';

	if ($this->curIndexCount < 32 && ($start_index == $this->Application->GetDefaultLanguageId() \|\| !$single_lang)) {
	// create index for primary language column + for all others (if multiple languages installed)
	list($field_name, $field_params) = explode(' ', $field_expression, 2);

	$index_type = isset($this->curFields[$ml_field]['index_type']) ? $this->curFields[$prev_field]['index_type'] : 'string';

	$ret .= $index_type == 'string' ? 'ADD INDEX (`'.$field_name.'` (5) ), ' : 'ADD INDEX (`'.$field_name.'`), ';
	$this->curIndexCount++;
	}

	$start_index++;
	}
	return preg_replace('/, $/', ';', $ret);
	}
	}
	Index: branches/5.1.x/core/units/languages/languages_config.php
	===================================================================
	--- branches/5.1.x/core/units/languages/languages_config.php (revision 14123)
	+++ branches/5.1.x/core/units/languages/languages_config.php (revision 14124)
	@@ -1,271 +1,261 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	$config = Array (
	'Prefix' => 'lang',
	'ItemClass' => Array ('class' => 'LanguagesItem', 'file' => 'languages_item.php', 'build_event' => 'OnItemBuild'),
	'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	'EventHandlerClass' => Array ('class' => 'LanguagesEventHandler', 'file' => 'languages_event_handler.php', 'build_event' => 'OnBuild'),
	'TagProcessorClass' => Array ('class' => 'LanguagesTagProcessor', 'file' => 'languages_tag_processor.php', 'build_event' => 'OnBuild'),

	'AutoLoad' => true,
	'Hooks' => Array (
	Array (
	'Mode' => hAFTER,
	'Conditional' => false,
	'HookToPrefix' => 'lang',
	'HookToSpecial' => '*',
	- 'HookToEvent' => Array ('OnSave'),
	- 'DoPrefix' => '',
	- 'DoSpecial' => '',
	- 'DoEvent' => 'OnUpdatePrimary',
	- ),
	- Array (
	- 'Mode' => hAFTER,
	- 'Conditional' => false,
	- 'HookToPrefix' => 'lang',
	- 'HookToSpecial' => '*',
	'HookToEvent' => Array('OnSave', 'OnMassDelete'),
	'DoPrefix' => '',
	'DoSpecial' => '',
	'DoEvent' => 'OnScheduleTopFrameReload',
	),
	),
	'QueryString' => Array (
	1 => 'id',
	2 => 'Page',
	3 => 'PerPage',
	4 => 'event',
	5 => 'mode',
	),

	'IDField' => 'LanguageId',

	'StatusField' => Array ('Enabled', 'PrimaryLang'), // field, that is affected by Approve/Decline events

	'TitleField' => 'PackName', // field, used in bluebar when editing existing item

	'TitlePresets' => Array (
	'default' => Array (
	'new_status_labels' => Array ('lang' => '!la_title_Adding_Language!'),
	'edit_status_labels' => Array ('lang' => '!la_title_Editing_Language!'),
	),
	'languages_list' => Array (
	'prefixes' => Array ('lang_List'), 'format' => "!la_title_Configuration! - !la_title_LanguagePacks!",
	'toolbar_buttons' => Array (
	'new_item', 'edit', 'delete', 'export', 'import', 'setprimary', 'refresh', 'view', 'dbl-click'
	),
	),
	'languages_edit_general' => Array ('prefixes' => Array ('lang'), 'format' => "#lang_status# '#lang_titlefield#' - !la_title_General!"),
	'phrases_list' => Array (
	'prefixes' => Array ('lang', 'phrases_List'), 'format' => "#lang_status# '#lang_titlefield#' - !la_title_Labels!"
	),
	'phrase_edit' => Array (
	'prefixes' => Array ('phrases'),
	'new_status_labels' => Array ('phrases' => '!la_title_Adding_Phrase!'),
	'edit_status_labels' => Array ('phrases' => '!la_title_Editing_Phrase!'),
	'format' => "#phrases_status# '#phrases_titlefield#'",
	),
	'import_language' => Array (
	'prefixes' => Array ('phrases.import'), 'format' => "!la_title_InstallLanguagePackStep1!",
	),
	'import_language_step2' => Array (
	'prefixes' => Array ('phrases.import'), 'format' => "!la_title_InstallLanguagePackStep2!",
	),
	'export_language' => Array (
	'prefixes' => Array ('phrases.export'), 'format' => "!la_title_ExportLanguagePackStep1!",
	),
	'export_language_results' => Array (
	'prefixes' => Array(), 'format' => "!la_title_ExportLanguagePackResults!",
	),
	'events_list' => Array (
	'prefixes' => Array ('lang', 'emailevents_List'), 'format' => "#lang_status# '#lang_titlefield#' - !la_title_EmailEvents!",
	),
	'event_edit' => Array (
	'prefixes' => Array ('emailevents'),
	'edit_status_labels' => Array ('emailevents' => '!la_title_Editing_EmailEvent!'),
	'format' => '#emailevents_status# - #emailevents_titlefield#',
	),
	'email_messages_edit' => Array (
	'prefixes' => Array ('lang', 'emailevents'),
	'format' => "#lang_status# '#lang_titlefield#' - !la_title_EditingEmailEvent! '#emailevents_titlefield#'",
	),
	// for separate language list
	'languages_list_st' => Array (
	'prefixes' => Array ('lang_List'), 'format' => "!la_title_LanguagesManagement!",
	),
	),

	'EditTabPresets' => Array (
	'Default' => Array (
	'general' => Array ('title' => 'la_tab_General', 't' => 'regional/languages_edit', 'priority' => 1),
	'labels' => Array ('title' => 'la_tab_Labels', 't' => 'regional/languages_edit_phrases', 'priority' => 2),
	'email_events' => Array ('title' => 'la_tab_EmailEvents', 't' => 'regional/languages_edit_email_events', 'priority' => 3),
	),
	),

	'PermSection' => Array ('main' => 'in-portal:configure_lang'),

	'Sections' => Array (
	'in-portal:configure_lang' => Array (
	'parent' => 'in-portal:website_setting_folder',
	'icon' => 'conf_regional',
	'label' => 'la_tab_Regional',
	'url' => Array ('t' => 'regional/languages_list', 'pass' => 'm'),
	'permissions' => Array ('view', 'add', 'edit', 'delete', 'advanced:set_primary', 'advanced:import', 'advanced:export'),
	'priority' => 4,
	'type' => stTREE,
	),

	// "Lang. Management"
	/*'in-portal:lang_management' => Array (
	'parent' => 'in-portal:system',
	'icon' => 'core:settings_general',
	'label' => 'la_title_LangManagement',
	'url' => Array ('t' => 'languages/language_list', 'pass' => 'm'),
	'permissions' => Array ('view', 'add', 'edit', 'delete'),
	'perm_prefix' => 'lang',
	'priority' => 10.03,
	'show_mode' => smSUPER_ADMIN,
	'type' => stTREE,
	),*/
	),

	'TableName' => TABLE_PREFIX . 'Language',

	'AutoDelete' => true,
	'AutoClone' => true,

	'ListSQLs' => Array ('' => 'SELECT * FROM %s'),
	'ItemSQLs' => Array ('' => 'SELECT * FROM %s'),

	'ListSortings' => Array (
	'' => Array (
	'Sorting' => Array ('Priority' => 'desc', 'PackName' => 'asc'),
	),
	),

	'Fields' => Array (
	'LanguageId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'PackName' => Array (
	'type' => 'string',
	'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Language ORDER BY PackName', 'option_title_field' => 'PackName', 'option_key_field' => 'PackName',
	'not_null' => 1, 'required' => 1, 'default' => ''
	),
	'LocalName' => Array (
	'type' => 'string',
	'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Language ORDER BY PackName', 'option_title_field' => 'LocalName', 'option_key_field' => 'LocalName',
	'not_null' => 1, 'required' => 1, 'default' => ''
	),
	'Enabled' => Array (
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_Disabled', 1 => 'la_Active'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 1
	),
	'PrimaryLang' => Array(
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 0
	),
	'AdminInterfaceLang' => Array (
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 0
	),
	'Priority' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'IconURL' => Array ('type' => 'string', 'max_len' => 255, 'default' => NULL),
	'IconDisabledURL' => Array ('type' => 'string', 'max_len' => 255, 'default' => NULL),
	'InputDateFormat' => Array (
	'type' => 'string',
	'formatter' => 'kOptionsFormatter',
	'options' => Array ('m/d/Y' => 'mm/dd/yyyy', 'd/m/Y' => 'dd/mm/yyyy', 'm.d.Y' => 'mm.dd.yyyy', 'd.m.Y' => 'dd.mm.yyyy'),
	'not_null' => 1, 'required' => 1, 'default' => 'm/d/Y'
	),
	'InputTimeFormat' => Array (
	'type' => 'string',
	'formatter' => 'kOptionsFormatter',
	'options' => Array ('g:i:s A' => 'g:i:s A', 'g:i A' => 'g:i A', 'H:i:s' => 'H:i:s', 'H:i' => 'H:i'),
	'not_null' => '1', 'required' => 1, 'default' => 'g:i:s A',
	),
	'DateFormat' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => 'm/d/Y'),
	'TimeFormat' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => 'g:i:s A'),
	'DecimalPoint' => Array ('type' => 'string', 'not_null' => 1, 'required' => 1, 'default' => '.'),
	'ThousandSep' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
	'Charset' => Array ('type' => 'string', 'not_null' => '1', 'required' => 1, 'default' => 'utf-8'),
	'UnitSystem' => Array (
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Metric', 2 => 'la_US_UK'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 1
	),
	'FilenameReplacements' => Array ('type' => 'string', 'default' => NULL),
	'Locale' => Array (
	'type' => 'string',
	'formatter' => 'kOptionsFormatter',
	'options_sql' => " SELECT CONCAT(LocaleName, ' ' ,'\/',Locale,'\/') AS Name, Locale
	FROM " . TABLE_PREFIX . 'LocalesList
	ORDER BY LocaleId',
	'option_title_field' => 'Name', 'option_key_field' => 'Locale',
	'not_null' => 1, 'default' => 'en-US',
	),
	'UserDocsUrl' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
	),

	'VirtualFields' => Array (
	'CopyLabels' => Array ('type' => 'int', 'default' => 0),
	'CopyFromLanguage' => Array (
	'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Language ORDER BY PackName', 'option_title_field' => 'PackName', 'option_key_field' => 'LanguageId',
	'default' => '',
	),
	),

	'Grids' => Array(
	'Default' => Array (
	'Icons' => Array (
	'default' => 'icon16_item.png',
	'0_0' => 'icon16_disabled.png',
	'0_1' => 'icon16_disabled.png',
	'1_0' => 'icon16_item.png',
	'1_1' => 'icon16_primary.png',
	),
	'Fields' => Array(
	'LanguageId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 50, ),
	'PackName' => Array ('title' => 'la_col_PackName', 'filter_block' => 'grid_options_filter', 'width' => 150, ),//
	'PrimaryLang' => Array ('title' => 'la_col_IsPrimaryLanguage', 'filter_block' => 'grid_options_filter', 'width' => 150, ),
	'AdminInterfaceLang' => Array ('title' => 'la_col_AdminInterfaceLang', 'filter_block' => 'grid_options_filter', 'width' => 150, ),
	'Charset' => Array ('title' => 'la_col_Charset', 'filter_block' => 'grid_like_filter', 'width' => 100, ),
	'Priority' => Array ('title' => 'la_col_Priority', 'filter_block' => 'grid_like_filter', 'width' => 60, ),
	'Enabled' => Array ('title' => 'la_col_Status', 'filter_block' => 'grid_options_filter', 'width' => 60, ),
	),
	),

	/*'LangManagement' => Array (
	'Icons' => Array (
	'default' => 'icon16_item.png',
	'0_0' => 'icon16_disabled.png',
	'0_1' => 'icon16_disabled.png',
	'1_0' => 'icon16_item.png',
	'1_1' => 'icon16_primary.png',
	),
	'Fields' => Array (
	'LanguageId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 60),
	'PackName' => Array ('title' => 'la_col_Language', 'filter_block' => 'grid_options_filter', 'width' => 120),
	'LocalName' => Array ('title' => 'la_col_Prefix', 'filter_block' => 'grid_options_filter', 'width' => 120),
	'IconURL' => Array ('title' => 'la_col_Image', 'filter_block' => 'grid_empty_filter', 'width' => 80),
	),
	),*/
	),
	);
	\ No newline at end of file
	Index: branches/5.1.x/core/units/languages/languages_event_handler.php
	===================================================================
	--- branches/5.1.x/core/units/languages/languages_event_handler.php (revision 14123)
	+++ branches/5.1.x/core/units/languages/languages_event_handler.php (revision 14124)
	@@ -1,612 +1,613 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class LanguagesEventHandler extends kDBEventHandler
	{
	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnChangeLanguage' => Array('self' => true),
	'OnSetPrimary' => Array('self' => 'advanced:set_primary\|add\|edit'),
	'OnImportLanguage' => Array('self' => 'advanced:import'),
	'OnExportLanguage' => Array('self' => 'advanced:export'),
	'OnExportProgress' => Array('self' => 'advanced:export'),
	'OnReflectMultiLingualFields' => Array ('self' => 'view'),
	'OnSynchronizeLanguages' => Array ('self' => 'edit'),
	);

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

	/**
	* Permission check override
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	if ($event->Name == 'OnItemBuild') {
	// check permission without using $event->getSection(),
	// so first cache rebuild won't lead to "ldefault_Name" field being used
	return true;
	}

	return parent::CheckPermission($event);
	}

	/**
	* [HOOK] Updates table structure on new language adding/removing language
	*
	* @param kEvent $event
	*/
	function OnReflectMultiLingualFields(&$event)
	{
	if ($this->Application->GetVar('ajax') == 'yes') {
	$event->status = erSTOP;
	}

	if (is_object($event->MasterEvent)) {
	if ($event->MasterEvent->status != erSUCCESS) {
	// only rebuild when all fields are validated
	return ;
	}

	if (($event->MasterEvent->Name == 'OnSave') && !$this->Application->GetVar('new_language')) {
	// only rebuild during new language adding
	return ;
	}
	}

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

	$this->Application->UnitConfigReader->ReReadConfigs();
	foreach ($this->Application->UnitConfigReader->configData as $prefix => $config_data) {
	$ml_helper->createFields($prefix);
	}
	}

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

	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	if ($ids) {
	$id = array_shift($ids);
	$object =& $event->getObject( Array('skip_autoload' => true) );
	/* @var $object LanguagesItem */

	$object->Load($id);
	- $object->setPrimary();
	+ $object->copyMissingData( $object->setPrimary() );
	}
	}

	/**
	* [HOOK] Reset primary status of other languages if we are saving primary language
	*
	* @param kEvent $event
	*/
	function OnUpdatePrimary(&$event)
	{
	if ($event->MasterEvent->status != erSUCCESS) {
	return ;
	}

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

	$object->SwitchToLive();

	// set primary for each languages, that have this checkbox checked
	$ids = explode(',', $event->MasterEvent->getEventParam('ids'));
	foreach ($ids as $id) {
	$object->Load($id);
	if ($object->GetDBField('PrimaryLang')) {
	- $object->setPrimary(true, false);
	+ $object->copyMissingData( $object->setPrimary(true, false) );
	}

	if ($object->GetDBField('AdminInterfaceLang')) {
	$object->setPrimary(true, true);
	}
	}

	// if no primary language left, then set primary last language (not to load again) from edited list
	$sql = 'SELECT '.$object->IDField.'
	FROM '.$object->TableName.'
	WHERE PrimaryLang = 1';
	$primary_language = $this->Conn->GetOne($sql);

	if (!$primary_language) {
	$object->setPrimary(false, false); // set primary language
	}

	$sql = 'SELECT '.$object->IDField.'
	FROM '.$object->TableName.'
	WHERE AdminInterfaceLang = 1';
	$primary_language = $this->Conn->GetOne($sql);

	if (!$primary_language) {
	$object->setPrimary(false, true); // set admin interface language
	}
	}


	/**
	* Prefills options with dynamic values
	*
	* @param kEvent $event
	*/
	function OnAfterConfigRead(&$event)
	{
	parent::OnAfterConfigRead($event);

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

	// set dynamic hints for options in date format fields
	$options = $fields['InputDateFormat']['options'];
	if ($options) {
	foreach ($options as $i => $v) {
	$options[$i] = $v . ' (' . adodb_date($i) . ')';
	}
	$fields['InputDateFormat']['options'] = $options;
	}

	$options = $fields['InputTimeFormat']['options'];
	if ($options) {
	foreach ($options as $i => $v) {
	$options[$i] = $v . ' (' . adodb_date($i) . ')';
	}
	$fields['InputTimeFormat']['options'] = $options;
	}

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

	/**
	* Occurse before updating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	$status_fields = $this->Application->getUnitOption($event->Prefix, 'StatusField');
	$status_field = array_shift($status_fields);

	if ($object->GetDBField('PrimaryLang') == 1 && $object->GetDBField($status_field) == 0) {
	$object->SetDBField($status_field, 1);
	}
	}

	/**
	* Shows only enabled languages on front
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	$object =& $event->getObject();
	/* @var $object kDBList */

	if (in_array($event->Special, Array ('enabled', 'selected', 'available'))) {
	$object->addFilter('enabled_filter', '%1$s.Enabled = ' . STATUS_ACTIVE);
	}

	// site domain language picker
	if ($event->Special == 'selected' \|\| $event->Special == 'available') {
	$edit_picker_helper =& $this->Application->recallObject('EditPickerHelper');
	/* @var $edit_picker_helper EditPickerHelper */

	$edit_picker_helper->applyFilter($event, 'Languages');
	}

	// apply domain-based language filtering
	$languages = $this->Application->siteDomainField('Languages');

	if (strlen($languages)) {
	$languages = explode('\|', substr($languages, 1, -1));
	$object->addFilter('domain_filter', '%1$s.LanguageId IN (' . implode(',', $languages) . ')');
	}
	}

	/**
	* Copy labels from another language
	*
	* @param kEvent $event
	*/
	function OnAfterItemCreate(&$event)
	{
	parent::OnAfterItemCreate($event);

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

	$src_language = $object->GetDBField('CopyFromLanguage');

	if ($object->GetDBField('CopyLabels') && $src_language) {
	$dst_language = $object->GetID();

	// 1. schedule data copy after OnSave event is executed
	$var_name = $event->getPrefixSpecial() . '_copy_data' . $this->Application->GetVar('m_wid');
	$pending_actions = $this->Application->RecallVar($var_name, Array ());

	if ($pending_actions) {
	$pending_actions = unserialize($pending_actions);
	}

	$pending_actions[$src_language] = $dst_language;
	$this->Application->StoreVar($var_name, serialize($pending_actions));
	$object->SetDBField('CopyLabels', 0);
	}
	}

	/**
	* Saves language from temp table to live
	*
	* @param kEvent $event
	*/
	function OnSave(&$event)
	{
	parent::OnSave($event);

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

	$var_name = $event->getPrefixSpecial() . '_copy_data' . $this->Application->GetVar('m_wid');
	$pending_actions = $this->Application->RecallVar($var_name, Array ());

	if ($pending_actions) {
	$pending_actions = unserialize($pending_actions);
	}

	// create multilingual columns for phrases & email events table first (actual for 6+ language)
	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	$ml_helper->createFields('phrases');
	$ml_helper->createFields('emailevents');

	foreach ($pending_actions as $src_language => $dst_language) {
	// phrases import
	$sql = 'UPDATE ' . $this->Application->getUnitOption('phrases', 'TableName') . '
	SET l' . $dst_language . '_Translation = l' . $src_language . '_Translation';
	$this->Conn->Query($sql);

	// events import
	$sql = 'UPDATE ' . $this->Application->getUnitOption('emailevents', 'TableName') . '
	SET
	l' . $dst_language . '_Subject = l' . $src_language . '_Subject,
	l' . $dst_language . '_Body = l' . $src_language . '_Body';
	$this->Conn->Query($sql);
	}

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

	$event->CallSubEvent('OnReflectMultiLingualFields');
	+ $event->CallSubEvent('OnUpdatePrimary');
	}

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

	$object =& $event->getObject();
	$object->SetDBField('CopyLabels', 1);

	$live_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$primary_lang_id = $this->Conn->GetOne('SELECT '.$object->IDField.' FROM '.$live_table.' WHERE PrimaryLang = 1');

	$object->SetDBField('CopyFromLanguage', $primary_lang_id);
	}

	/**
	* Sets new language mark
	*
	* @param kEvent $event
	*/
	function OnBeforeDeleteFromLive(&$event)
	{
	$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 . ' = ' . $event->getEventParam('id');
	$id = $this->Conn->GetOne($sql);

	if (!$id) {
	$this->Application->SetVar('new_language', 1);
	}
	}

	function OnChangeLanguage(&$event)
	{
	$language_id = $this->Application->GetVar('language');

	if ($this->Application->isAdmin) {
	// admin data only
	$this->Application->SetVar('m_lang', $language_id);

	// set new language for this session (admin interface only)
	$this->Application->Session->SetField('Language', $language_id);

	// remember last user language in administrative console
	if ($this->Application->RecallVar('user_id') == USER_ROOT) {
	$this->Application->StorePersistentVar('AdminLanguage', $language_id);
	}
	else {
	$object =& $this->Application->recallObject('u.current');
	/* @var $object kDBItem */

	$object->SetDBField('AdminLanguage', $language_id);
	$object->Update();
	}

	// without this language change in admin will cause erase of last remembered tree section
	$this->Application->SetVar('skip_last_template', 1);
	}
	else {
	// changing language on Front-End
	$this->Application->SetVar('m_lang', $language_id);

	if (MOD_REWRITE) {
	$mod_rewrite_helper =& $this->Application->recallObject('ModRewriteHelper');
	/* @var $mod_rewrite_helper kModRewriteHelper */

	$mod_rewrite_helper->removePages();
	}
	}
	}

	/**
	* Parse language XML file into temp tables and redirect to progress bar screen
	*
	* @param kEvent $event
	*/
	function OnImportLanguage(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = erFAIL;
	return;
	}

	$items_info = $this->Application->GetVar('phrases_import');
	if ($items_info) {
	list ($id, $field_values) = each($items_info);

	$object =& $this->Application->recallObject('phrases.import', 'phrases', Array('skip_autoload' => true));
	/* @var $object kDBItem */

	$object->setID($id);
	$object->SetFieldsFromHash($field_values);

	if (!$object->Validate()) {
	$event->status = erFAIL;
	return ;
	}

	$filename = $object->GetField('LangFile', 'full_path');

	if (!filesize($filename)) {
	$object->SetError('LangFile', 'la_empty_file', 'la_EmptyFile');
	$event->status = erFAIL;
	}

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

	$language_import_helper->performImport(
	$filename,
	$object->GetDBField('PhraseType'),
	$object->GetDBField('Module'),
	$object->GetDBField('ImportOverwrite') ? LANG_OVERWRITE_EXISTING : LANG_SKIP_EXISTING
	);

	// delete uploaded language pack after import is finished
	unlink($filename);

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

	/**
	* Stores ids of selected languages and redirects to export language step 1
	*
	* @param kEvent $event
	*/
	function OnExportLanguage(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = erFAIL;
	return;
	}

	$this->Application->setUnitOption('phrases','AutoLoad',false);

	$this->StoreSelectedIDs($event);
	$this->Application->StoreVar('export_language_ids', implode(',', $this->getSelectedIDs($event)) );

	$event->setRedirectParams( Array('phrases.export_event' => 'OnNew', 'pass' => 'all,phrases.export') );
	}

	/**
	* Saves selected languages to xml file passed
	*
	* @param kEvent $event
	*/
	function OnExportProgress(&$event)
	{
	$items_info = $this->Application->GetVar('phrases_export');
	if ($items_info) {
	list($id, $field_values) = each($items_info);
	$object =& $this->Application->recallObject('phrases.export', null, Array('skip_autoload' => true));
	/* @var $object kDBItem */

	$object->setID($id);
	$object->SetFieldsFromHash($field_values);

	if (!$object->Validate()) {
	$event->status = erFAIL;
	return ;
	}

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

	$file_helper->CheckFolder(EXPORT_PATH);

	if (!is_writable(EXPORT_PATH)) {
	$event->status = erFAIL;
	$object->SetError('LangFile', 'write_error', 'la_ExportFolderNotWritable');

	return ;
	}

	if ( substr($field_values['LangFile'], -5) != '.lang') {
	$field_values['LangFile'] .= '.lang';
	}

	$filename = EXPORT_PATH . '/' . $field_values['LangFile'];

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

	if ($object->GetDBField('DoNotEncode')) {
	$language_import_helper->setExportEncoding('plain');
	}

	$language_import_helper->setExportLimits($field_values['ExportPhrases'], $field_values['ExportEmailEvents']);

	$lang_ids = explode(',', $this->Application->RecallVar('export_language_ids') );
	$language_import_helper->performExport($filename, $field_values['PhraseType'], $lang_ids, $field_values['Module']);

	}

	$event->redirect = 'regional/languages_export_step2';
	$event->SetRedirectParam('export_file', $field_values['LangFile']);
	}

	/**
	* Returns to previous template in opener stack
	*
	* @param kEvent $event
	*/
	function OnGoBack(&$event)
	{
	$event->redirect_params['opener'] = 'u';
	}

	function OnScheduleTopFrameReload(&$event)
	{
	$this->Application->StoreVar('RefreshTopFrame',1);
	}

	/**
	* Do now allow deleting current language
	*
	* @param kEvent $event
	*/
	function OnBeforeItemDelete(&$event)
	{
	$del_id = $event->getEventParam('id');
	$object =& $event->getObject(array('skip_autload' => true));
	$object->Load($del_id);

	if ($object->GetDBField('PrimaryLang') \|\| $object->GetDBField('AdminInterfaceLang') \|\| $del_id == $this->Application->GetVar('m_lang')) {
	$event->status = erFAIL;
	}
	}

	/**
	* Deletes phrases and email events on given language
	*
	* @param kEvent $event
	*/
	function OnAfterItemDelete(&$event)
	{
	parent::OnAfterItemDelete($event);

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

	// clean Events table
	$fields_hash = Array (
	'l' . $object->GetID() . '_Subject' => NULL,
	'l' . $object->GetID() . '_Body' => NULL,
	);
	$this->Conn->doUpdate($fields_hash, $this->Application->getUnitOption('emailevents', 'TableName'), 1);

	// clean Phrases table
	$fields_hash = Array (
	'l' . $object->GetID() . '_Translation' => NULL,
	);
	$this->Conn->doUpdate($fields_hash, $this->Application->getUnitOption('phrases', 'TableName'), 1);
	}

	/**
	* Copy missing phrases across all system languages (starting from primary)
	*
	* @param kEvent $event
	*/
	function OnSynchronizeLanguages(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	$event->status = erFAIL;
	return;
	}

	// get language list with primary language first
	$sql = 'SELECT LanguageId
	FROM ' . TABLE_PREFIX . 'Language
	ORDER BY PrimaryLang DESC';

	$source_langs = $this->Conn->GetCol($sql);
	$target_langs = $source_langs;

	foreach ($source_langs as $source_id) {
	foreach ($target_langs as $target_id) {
	if ($source_id == $target_id) {
	continue;
	}

	$sql = 'UPDATE ' . TABLE_PREFIX . 'Phrase
	SET l' . $target_id . '_Translation = l' . $source_id . '_Translation
	WHERE (l' . $target_id . '_Translation IS NULL) OR (l' . $target_id . '_Translation = "")';
	$this->Conn->Query($sql);
	}
	}
	}
	}
	\ No newline at end of file
	Index: branches/5.1.x/core/units/languages/languages_item.php
	===================================================================
	--- branches/5.1.x/core/units/languages/languages_item.php (revision 14123)
	+++ branches/5.1.x/core/units/languages/languages_item.php (revision 14124)
	@@ -1,239 +1,278 @@
	<?php
	/**
	* @version $Id$
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class LanguagesItem extends kDBItem
	{
	function generateID()
	{
	$sql = 'SELECT MAX('.$this->IDField.') FROM '.$this->Application->getUnitOption($this->Prefix, 'TableName');
	return $this->Conn->GetOne($sql) + 1;
	}

	+ /**
	+ * Set's current language as new primary and return previous primary language
	+ *
	+ * @param bool $reset_primary
	+ * @param bool $admin_language
	+ * @return int
	+ */
	function setPrimary($reset_primary = true, $admin_language = false)
	{
	+ $prev_primary = false;
	$primary_field = $admin_language ? 'AdminInterfaceLang' : 'PrimaryLang';
	+
	if ($reset_primary) {
	+ $sql = 'SELECT ' . $this->IDField . '
	+ FROM ' . $this->TableName . '
	+ WHERE ' . $primary_field . ' = 1';
	+ $prev_primary = $this->Conn->GetOne($sql);
	+
	$sql = 'UPDATE '.$this->TableName.'
	SET '.$primary_field.' = 0';
	$this->Conn->Query($sql);
	}

	$sql = 'UPDATE '.$this->TableName.'
	SET '.$primary_field.' = 1, Enabled = 1
	WHERE '.$this->IDField.' = '.$this->GetID();
	$this->Conn->Query($sql);

	// in case, when Update method is called for this langauge object
	$this->SetDBField($primary_field, 1);
	$this->SetDBField('Enabled', 1);
	+
	+ return $prev_primary;
	+ }
	+
	+ /**
	+ * Copies missing data on current language from given language
	+ *
	+ * @param int $from_language
	+ */
	+ function copyMissingData($from_language)
	+ {
	+ if ( !is_numeric($from_language) \|\| ($from_language == $this->GetID()) ) {
	+ // invalid or same language
	+ return ;
	+ }
	+
	+ $ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');
	+ /* @var $ml_helper kMultiLanguageHelper */
	+
	+ $to_language = $this->GetID();
	+ $this->Application->UnitConfigReader->ReReadConfigs();
	+
	+ foreach ($this->Application->UnitConfigReader->configData as $prefix => $config_data) {
	+ $ml_helper->copyMissingData($prefix, $from_language, $to_language);
	+ }
	}

	/**
	* Allows to format number according to regional settings
	*
	* @param float $number
	* @param int $precision
	* @return float
	*/
	function formatNumber($number, $precision = null)
	{
	if (is_null($precision)) {
	$precision = preg_match('/[\.,]+/', $number) ? strlen(preg_replace('/^.*[\.,]+/', '', $number)) : 0;
	}
	return number_format($number, $precision, (string)$this->GetDBField('DecimalPoint'), (string)$this->GetDBField('ThousandSep'));
	}

	/**
	* Returns language id based on HTTP header "Accept-Language"
	*
	* @return int
	*/
	function processAcceptLanguage()
	{
	if (!array_key_exists('HTTP_ACCEPT_LANGUAGE', $_SERVER) \|\| !$_SERVER['HTTP_ACCEPT_LANGUAGE']) {
	return false;
	}

	$accepted_languages = Array ();
	$language_string = explode(',', strtolower($_SERVER['HTTP_ACCEPT_LANGUAGE']));

	foreach ($language_string as $mixed_language) {
	if (strpos($mixed_language, ';') !== false) {
	list ($language_locale, $language_quality) = explode(';', $mixed_language);
	$language_quality = (float)substr($language_quality, 2); // format "q=4.45"
	}
	else {
	$language_locale = $mixed_language;
	$language_quality = 1.00;
	}

	$accepted_languages[ trim($language_locale) ] = trim($language_quality);
	}

	arsort($accepted_languages, SORT_NUMERIC);

	foreach ($accepted_languages as $language_locale => $language_quality) {
	$language_id = $this->getAvailableLanguage($language_locale);

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

	return false;
	}

	/**
	* Returns language ID based on given locale
	*
	* @param string $locale
	* @return int
	*/
	function getAvailableLanguage($locale)
	{
	$cache_key = 'available_languages[%LangSerial%]';
	$available_languages = $this->Application->getCache($cache_key);

	if ($available_languages === false) {
	$this->Conn->nextQueryCachable = true;
	$sql = 'SELECT LanguageId, LOWER(Locale) AS Locale
	FROM ' . TABLE_PREFIX . 'Language
	WHERE Enabled = 1';
	$available_languages = $this->Conn->GetCol($sql, 'Locale');
	$this->Application->setCache($cache_key, $available_languages);
	}

	if (strpos($locale, '-') !== false) {
	// exact language match requested
	$language_id = array_key_exists($locale, $available_languages) ? $available_languages[$locale] : false;

	if ($language_id && $this->siteDomainLanguageEnabled($language_id)) {
	return $language_id;
	}

	return false;
	}

	// partial (like "en" matches "en-GB" and "en-US") language match required
	foreach ($available_languages as $language_code => $language_id) {
	list ($language_code, ) = explode('-', $language_code);

	if (($locale == $language_code) && $this->siteDomainLanguageEnabled($language_id)) {
	return $language_id;
	}
	}

	return false;
	}

	/**
	* Checks, that url is empty
	*
	* @return bool
	*/
	function isEmptyUrl()
	{
	if ($this->Application->RewriteURLs()) {
	return !$this->Application->GetVar('_mod_rw_url_');
	}

	return !count($this->Application->HttpQuery->Get);
	}

	function Load($id, $id_field_name=null)
	{
	$default = false;
	if ($id == 'default') {
	// domain based primary language
	$default = true;
	$id = $this->Application->siteDomainField('PrimaryLanguageId');

	if ($id) {
	$res = parent::Load($id, $id_field_name, true);
	}
	else {
	$res = parent::Load(1, 'PrimaryLang', true);
	}

	if (
	!$this->Application->isAdmin && !defined('GW_NOTIFY') && preg_match('/[\/]{0,1}index.php[\/]{0,1}/', $_SERVER['PHP_SELF']) &&
	$this->isEmptyUrl() && $this->Application->ConfigValue('UseContentLanguageNegotiation')
	) {
	$language_id = $this->processAcceptLanguage();

	if ($language_id != $this->GetID()) {
	// redirect to same page with found language
	$url_params = Array (
	'm_cat_id' => 0, 'm_cat_page' => 1,
	'm_lang' => $language_id, 'm_opener' => 's',
	'pass' => 'm'
	);

	$this->Application->Redirect('', $url_params);
	}
	}
	}
	else {
	$res = parent::Load($id, $id_field_name, true);
	}

	if ($res) {
	if (!$this->siteDomainLanguageEnabled($this->GetID())) {
	// language isn't allowed in site domain
	return $this->Clear();
	}
	}

	if ($default) {
	if (!$res) {
	if ($this->Application->isAdmin) {
	$res = parent::Load(1);
	}
	else {
	if (defined('IS_INSTALL')) {
	// during first language import prevents sql errors
	$this->setID(1);
	$res = true;
	}
	else {
	$this->Application->ApplicationDie('No Primary Language Selected');
	}
	}
	}
	$this->Application->SetVar('lang.current_id', $this->GetID() );
	$this->Application->SetVar('m_lang', $this->GetID() );
	}

	return $res;
	}

	/**
	* Checks, that language is enabled in site domain
	*
	* @param int $id
	* @return bool
	*/
	function siteDomainLanguageEnabled($id)
	{
	$available_languages = $this->Application->siteDomainField('Languages');

	if ($available_languages) {
	return strpos($available_languages, '\|' .$id . '\|') !== false;
	}

	return true;
	}
	}
	\ 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