in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Thu, Feb 6, 7:09 AM

in-portal
View Options

	Index: branches/5.0.x/core/kernel/utility/temp_handler.php
	===================================================================
	--- branches/5.0.x/core/kernel/utility/temp_handler.php (revision 12782)
	+++ branches/5.0.x/core/kernel/utility/temp_handler.php (revision 12783)
	@@ -1,934 +1,936 @@
	<?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 kTempTablesHandler extends kBase {

	var $Tables = Array();

	/**
	* Master table name for temp handler
	*
	* @var string
	* @access private
	*/
	var $MasterTable = '';

	/**
	* IDs from master table
	*
	* @var Array
	* @access private
	*/
	var $MasterIDs = Array();

	var $AlreadyProcessed = Array();

	var $DroppedTables = Array();

	var $FinalRefs = Array();

	var $CopiedTables = Array();


	/**
	* IDs of newly cloned items (key - prefix.special, value - array of ids)
	*
	* @var Array
	*/
	var $savedIDs = Array();

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


	/**
	* Window ID of current window
	*
	* @var mixed
	*/
	var $WindowID = '';

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

	function SetTables($tables)
	{
	// set tablename as key for tables array
	$ret = Array();
	$this->Tables = $tables;
	$this->MasterTable = $tables['TableName'];
	}

	function saveID($prefix, $special = '', $id = null)
	{
	if (!isset($this->savedIDs[$prefix.($special ? '.' : '').$special])) {
	$this->savedIDs[$prefix.($special ? '.' : '').$special] = array();
	}
	if (is_array($id)) {
	foreach ($id as $tmp_id => $live_id) {
	$this->savedIDs[$prefix.($special ? '.' : '').$special][$tmp_id] = $live_id;
	}
	}
	else {
	$this->savedIDs[$prefix.($special ? '.' : '').$special][] = $id;
	}
	}

	/**
	* Get temp table name
	*
	* @param string $table
	* @return string
	*/
	function GetTempName($table)
	{
	return $this->Application->GetTempName($table, $this->WindowID);
	}

	function GetTempTablePrefix()
	{
	return $this->Application->GetTempTablePrefix($this->WindowID);
	}

	/**
	* Return live table name based on temp table name
	*
	* @param string $temp_table
	* @return string
	*/
	function GetLiveName($temp_table)
	{
	return $this->Application->GetLiveName($temp_table);
	}

	function IsTempTable($table)
	{
	return $this->Application->IsTempTable($table);
	}

	/**
	* Return temporary table name for master table
	*
	* @return string
	* @access public
	*/
	function GetMasterTempName()
	{
	return $this->GetTempName($this->MasterTable);
	}

	function CreateTempTable($table)
	{
	$query = sprintf("CREATE TABLE %s SELECT * FROM %s WHERE 0",
	$this->GetTempName($table),
	$table);

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

	function BuildTables($prefix, $ids)
	{
	$this->WindowID = $this->Application->GetVar('m_wid');

	$this->TableIdCounter = 0;
	$tables = Array(
	'TableName' => $this->Application->getUnitOption($prefix, 'TableName'),
	'IdField' => $this->Application->getUnitOption($prefix, 'IDField'),
	'IDs' => $ids,
	'Prefix' => $prefix,
	'TableId' => $this->TableIdCounter++,
	);

	/*$parent_prefix = $this->Application->getUnitOption($prefix, 'ParentPrefix');
	if ($parent_prefix) {
	$tables['ForeignKey'] = $this->Application->getUnitOption($prefix, 'ForeignKey');
	$tables['ParentPrefix'] = $parent_prefix;
	$tables['ParentTableKey'] = $this->Application->getUnitOption($prefix, 'ParentTableKey');
	}*/

	$this->FinalRefs[ $tables['TableName'] ] = $tables['TableId']; // don't forget to add main table to FinalRefs too

	$SubItems = $this->Application->getUnitOption($prefix,'SubItems');
	if (is_array($SubItems)) {
	foreach ($SubItems as $prefix) {
	$this->AddTables($prefix, $tables);
	}
	}
	$this->SetTables($tables);
	}

	/**
	* Searches through TempHandler tables info for required prefix
	*
	* @param string $prefix
	* @param Array $master
	* @return mixed
	*/
	function SearchTable($prefix, $master = null)
	{
	if (is_null($master)) {
	$master = $this->Tables;
	}

	if ($master['Prefix'] == $prefix) {
	return $master;
	}

	if (isset($master['SubTables'])) {
	foreach ($master['SubTables'] as $sub_table) {
	$found = $this->SearchTable($prefix, $sub_table);
	if ($found !== false) {
	return $found;
	}
	}
	}

	return false;
	}

	function AddTables($prefix, &$tables)
	{
	if (!$this->Application->prefixRegistred($prefix)) {
	// allows to skip subitem processing if subitem module not enabled/installed
	return ;
	}

	$tmp = Array(
	'TableName' => $this->Application->getUnitOption($prefix,'TableName'),
	'IdField' => $this->Application->getUnitOption($prefix,'IDField'),
	'ForeignKey' => $this->Application->getUnitOption($prefix,'ForeignKey'),
	'ParentPrefix' => $this->Application->getUnitOption($prefix, 'ParentPrefix'),
	'ParentTableKey' => $this->Application->getUnitOption($prefix,'ParentTableKey'),
	'Prefix' => $prefix,
	'AutoClone' => $this->Application->getUnitOption($prefix,'AutoClone'),
	'AutoDelete' => $this->Application->getUnitOption($prefix,'AutoDelete'),
	'TableId' => $this->TableIdCounter++,
	);

	$this->FinalRefs[ $tmp['TableName'] ] = $tmp['TableId'];

	$constrain = $this->Application->getUnitOption($prefix,'Constrain');
	if ($constrain)
	{
	$tmp['Constrain'] = $constrain;
	$this->FinalRefs[ $tmp['TableName'].$tmp['Constrain'] ] = $tmp['TableId'];
	}

	$SubItems = $this->Application->getUnitOption($prefix,'SubItems');
	$same_sub_counter = 1;
	if( is_array($SubItems) )
	{
	foreach($SubItems as $prefix)
	{
	$this->AddTables($prefix, $tmp);
	}
	}

	if ( !is_array(getArrayValue($tables, 'SubTables')) ) {
	$tables['SubTables'] = array();
	}

	$tables['SubTables'][] = $tmp;
	}

	function CloneItems($prefix, $special, $ids, $master = null, $foreign_key = null, $parent_prefix = null, $skip_filenames = false)
	{
	if (!isset($master)) $master = $this->Tables;

	// recalling by different name, because we may get kDBList, if we recall just by prefix
	if (!preg_match('/(.*)-item$/', $special)) {
	$special .= '-item';
	}

	$object =& $this->Application->recallObject($prefix.'.'.$special, $prefix, Array('skip_autoload' => true));
	$object->PopulateMultiLangFields();

	foreach ($ids as $id) {
	$mode = 'create';
	if ( $cloned_ids = getArrayValue($this->AlreadyProcessed, $master['TableName']) ) {
	// if we have already cloned the id, replace it with cloned id and set mode to update
	// update mode is needed to update second ForeignKey for items cloned by first ForeignKey
	if ( getArrayValue($cloned_ids, $id) ) {
	$id = $cloned_ids[$id];
	$mode = 'update';
	}
	}

	$object->Load($id);
	$original_values = $object->FieldValues;

	if (!$skip_filenames) {
	$object->NameCopy($master, $foreign_key);
	}
	elseif ($master['TableName'] == $this->MasterTable) {
	// kCatDBItem class only has this attribute
	$object->useFilenames = false;
	}

	if (isset($foreign_key)) {
	$master_foreign_key_field = is_array($master['ForeignKey']) ? $master['ForeignKey'][$parent_prefix] : $master['ForeignKey'];
	$object->SetDBField($master_foreign_key_field, $foreign_key);
	}

	if ($mode == 'create') {
	$this->RaiseEvent('OnBeforeClone', $master['Prefix'], $special, Array($object->GetId()), $foreign_key);
	}

	+ $object->inCloning = true;
	$res = $mode == 'update' ? $object->Update() : $object->Create();
	+ $object->inCloning = false;

	if ($res)
	{
	if ( $mode == 'create' && is_array( getArrayValue($master, 'ForeignKey')) ) {
	// remember original => clone mapping for dual ForeignKey updating
	$this->AlreadyProcessed[$master['TableName']][$id] = $object->GetId();
	}
	if ($object->mode == 't') {
	$object->setTempID();
	}
	if ($mode == 'create') {
	$this->RaiseEvent('OnAfterClone', $master['Prefix'], $special, Array($object->GetId()), $foreign_key, array('original_id' => $id) );
	$this->saveID($master['Prefix'], $special, $object->GetID());
	}

	if ( is_array(getArrayValue($master, 'SubTables')) ) {
	foreach($master['SubTables'] as $sub_table) {
	if (!getArrayValue($sub_table, 'AutoClone')) continue;
	$sub_TableName = ($object->mode == 't') ? $this->GetTempName($sub_table['TableName']) : $sub_table['TableName'];

	$foreign_key_field = is_array($sub_table['ForeignKey']) ? $sub_table['ForeignKey'][$master['Prefix']] : $sub_table['ForeignKey'];
	$parent_key_field = is_array($sub_table['ParentTableKey']) ? $sub_table['ParentTableKey'][$master['Prefix']] : $sub_table['ParentTableKey'];

	if (!$foreign_key_field \|\| !$parent_key_field) continue;

	$query = 'SELECT '.$sub_table['IdField'].' FROM '.$sub_TableName.'
	WHERE '.$foreign_key_field.' = '.$original_values[$parent_key_field];
	if (isset($sub_table['Constrain'])) $query .= ' AND '.$sub_table['Constrain'];

	$sub_ids = $this->Conn->GetCol($query);

	if ( is_array(getArrayValue($sub_table, 'ForeignKey')) ) {
	// $sub_ids could containt newly cloned items, we need to remove it here
	// to escape double cloning

	$cloned_ids = getArrayValue($this->AlreadyProcessed, $sub_table['TableName']);
	if ( !$cloned_ids ) $cloned_ids = Array();
	$new_ids = array_values($cloned_ids);
	$sub_ids = array_diff($sub_ids, $new_ids);
	}

	$parent_key = $object->GetDBField($parent_key_field);

	$this->CloneItems($sub_table['Prefix'], $special, $sub_ids, $sub_table, $parent_key, $master['Prefix']);
	}
	}
	}
	}

	if (!$ids) {
	$this->savedIDs[$prefix.($special ? '.' : '').$special] = Array();
	}

	return $this->savedIDs[$prefix.($special ? '.' : '').$special];
	}

	function DeleteItems($prefix, $special, $ids, $master=null, $foreign_key=null)
	{
	if (!isset($master)) $master = $this->Tables;
	if( strpos($prefix,'.') !== false ) list($prefix,$special) = explode('.', $prefix, 2);

	$prefix_special = rtrim($prefix.'.'.$special, '.');

	//recalling by different name, because we may get kDBList, if we recall just by prefix
	$recall_prefix = $prefix_special.($special ? '' : '.').'-item';
	$object =& $this->Application->recallObject($recall_prefix, $prefix, Array('skip_autoload' => true));

	foreach ($ids as $id)
	{
	$object->Load($id);
	$original_values = $object->FieldValues;
	if( !$object->Delete($id) ) continue;

	if ( is_array(getArrayValue($master, 'SubTables')) ) {
	foreach($master['SubTables'] as $sub_table) {
	if (!getArrayValue($sub_table, 'AutoDelete')) continue;
	$sub_TableName = ($object->mode == 't') ? $this->GetTempName($sub_table['TableName']) : $sub_table['TableName'];

	$foreign_key_field = is_array($sub_table['ForeignKey']) ? getArrayValue($sub_table, 'ForeignKey', $master['Prefix']) : $sub_table['ForeignKey'];
	$parent_key_field = is_array($sub_table['ParentTableKey']) ? getArrayValue($sub_table, 'ParentTableKey', $master['Prefix']) : $sub_table['ParentTableKey'];

	if (!$foreign_key_field \|\| !$parent_key_field) continue;

	$query = 'SELECT '.$sub_table['IdField'].' FROM '.$sub_TableName.'
	WHERE '.$foreign_key_field.' = '.$original_values[$parent_key_field];

	$sub_ids = $this->Conn->GetCol($query);

	$parent_key = $object->GetDBField(is_array($sub_table['ParentTableKey']) ? $sub_table['ParentTableKey'][$prefix] : $sub_table['ParentTableKey']);

	$this->DeleteItems($sub_table['Prefix'], '', $sub_ids, $sub_table, $parent_key);
	}
	}

	}
	}

	function DoCopyLiveToTemp($master, $ids, $parent_prefix=null)
	{
	// when two tables refers the same table as sub-sub-table, and ForeignKey and ParentTableKey are arrays
	// the table will be first copied by first sub-table, then dropped and copied over by last ForeignKey in the array
	// this should not do any problems :)
	if ( !preg_match("/.*\.[0-9]+/", $master['Prefix']) ) {
	if( $this->DropTempTable($master['TableName']) )
	{
	$this->CreateTempTable($master['TableName']);
	}
	}

	if (is_array($ids)) {
	$ids = join(',', $ids);
	}

	$table_sig = $master['TableName'].(isset($master['Constrain']) ? $master['Constrain'] : '');

	if ($ids != '' && !in_array($table_sig, $this->CopiedTables)) {
	if ( getArrayValue($master, 'ForeignKey') ) {
	if ( is_array($master['ForeignKey']) ) {
	$key_field = $master['ForeignKey'][$parent_prefix];
	}
	else {
	$key_field = $master['ForeignKey'];
	}
	}
	else {
	$key_field = $master['IdField'];
	}

	$query = 'INSERT INTO '.$this->GetTempName($master['TableName']).'
	SELECT * FROM '.$master['TableName'].'
	WHERE '.$key_field.' IN ('.$ids.')';
	if (isset($master['Constrain'])) $query .= ' AND '.$master['Constrain'];
	$this->Conn->Query($query);

	$this->CopiedTables[] = $table_sig;

	$query = 'SELECT '.$master['IdField'].' FROM '.$master['TableName'].'
	WHERE '.$key_field.' IN ('.$ids.')';
	if (isset($master['Constrain'])) $query .= ' AND '.$master['Constrain'];
	$this->RaiseEvent( 'OnAfterCopyToTemp', $master['Prefix'], '', $this->Conn->GetCol($query) );
	}

	if ( getArrayValue($master, 'SubTables') ) {
	foreach ($master['SubTables'] as $sub_table) {

	$parent_key = is_array($sub_table['ParentTableKey']) ? $sub_table['ParentTableKey'][$master['Prefix']] : $sub_table['ParentTableKey'];
	if (!$parent_key) continue;

	if ( $ids != '' && $parent_key != $key_field ) {
	$query = 'SELECT '.$parent_key.' FROM '.$master['TableName'].'
	WHERE '.$key_field.' IN ('.$ids.')';
	$sub_foreign_keys = join(',', $this->Conn->GetCol($query));
	}
	else {
	$sub_foreign_keys = $ids;
	}
	$this->DoCopyLiveToTemp($sub_table, $sub_foreign_keys, $master['Prefix']);
	}
	}
	}

	function GetForeignKeys($master, $sub_table, $live_id, $temp_id=null)
	{
	$mode = 1; //multi
	if (!is_array($live_id)) {
	$live_id = Array($live_id);
	$mode = 2; //single
	}
	if (isset($temp_id) && !is_array($temp_id)) $temp_id = Array($temp_id);

	if ( isset($sub_table['ParentTableKey']) ) {
	if ( is_array($sub_table['ParentTableKey']) ) {
	$parent_key_field = $sub_table['ParentTableKey'][$master['Prefix']];
	}
	else {
	$parent_key_field = $sub_table['ParentTableKey'];
	}
	}
	else {
	$parent_key_field = $master['IdField'];
	}

	if ( $cached = getArrayValue($this->FKeysCache, $master['TableName'].'.'.$parent_key_field) ) {
	if ( array_key_exists(serialize($live_id), $cached) ) {
	list($live_foreign_key, $temp_foreign_key) = $cached[serialize($live_id)];
	if ($mode == 1) {
	return $live_foreign_key;
	}
	else {
	return Array($live_foreign_key[0], $temp_foreign_key[0]);
	}
	}
	}

	if ($parent_key_field != $master['IdField']) {
	$query = 'SELECT '.$parent_key_field.' FROM '.$master['TableName'].'
	WHERE '.$master['IdField'].' IN ('.join(',', $live_id).')';
	$live_foreign_key = $this->Conn->GetCol($query);

	if (isset($temp_id)) {
	// because DoCopyTempToOriginal resets negative IDs to 0 in temp table (one by one) before copying to live
	$temp_key = $temp_id < 0 ? 0 : $temp_id;
	$query = 'SELECT '.$parent_key_field.' FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$master['IdField'].' IN ('.join(',', $temp_key).')';
	$temp_foreign_key = $this->Conn->GetCol($query);
	}
	else {
	$temp_foreign_key = Array();
	}
	}
	else {
	$live_foreign_key = $live_id;
	$temp_foreign_key = $temp_id;
	}

	$this->FKeysCache[$master['TableName'].'.'.$parent_key_field][serialize($live_id)] = Array($live_foreign_key, $temp_foreign_key);

	if ($mode == 1) {
	return $live_foreign_key;
	}
	else {
	return Array($live_foreign_key[0], $temp_foreign_key[0]);
	}
	}

	function DoCopyTempToOriginal($master, $parent_prefix = null, $current_ids = Array())
	{
	if (!$current_ids) {
	$query = 'SELECT '.$master['IdField'].' FROM '.$this->GetTempName($master['TableName']);
	if (isset($master['Constrain'])) $query .= ' WHERE '.$master['Constrain'];
	$current_ids = $this->Conn->GetCol($query);
	}

	$table_sig = $master['TableName'].(isset($master['Constrain']) ? $master['Constrain'] : '');

	if ($current_ids) {
	// delete all ids from live table - for MasterTable ONLY!
	// because items from Sub Tables get deteleted in CopySubTablesToLive !BY ForeignKey!
	if ($master['TableName'] == $this->MasterTable) {
	$this->RaiseEvent( 'OnBeforeDeleteFromLive', $master['Prefix'], '', $current_ids );

	$query = 'DELETE FROM '.$master['TableName'].' WHERE '.$master['IdField'].' IN ('.join(',', $current_ids).')';
	$this->Conn->Query($query);
	}

	if ( getArrayValue($master, 'SubTables') ) {
	if( in_array($table_sig, $this->CopiedTables) \|\| $this->FinalRefs[$table_sig] != $master['TableId'] ) return;

	foreach($current_ids AS $id)
	{
	$this->RaiseEvent( 'OnBeforeCopyToLive', $master['Prefix'], '', Array($id) );

	//reset negative ids to 0, so autoincrement in live table works fine
	if($id < 0)
	{
	$query = 'UPDATE '.$this->GetTempName($master['TableName']).'
	SET '.$master['IdField'].' = 0
	WHERE '.$master['IdField'].' = '.$id;
	if (isset($master['Constrain'])) $query .= ' AND '.$master['Constrain'];
	$this->Conn->Query($query);
	$id_to_copy = 0;
	}
	else
	{
	$id_to_copy = $id;
	}

	//copy current id_to_copy (0 for new or real id) to live table
	$query = 'INSERT INTO '.$master['TableName'].'
	SELECT * FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$master['IdField'].' = '.$id_to_copy;
	$this->Conn->Query($query);
	$insert_id = $id_to_copy == 0 ? $this->Conn->getInsertID() : $id_to_copy;

	$this->saveID($master['Prefix'], '', array($id => $insert_id));
	$this->RaiseEvent( 'OnAfterCopyToLive', $master['Prefix'], '', Array($insert_id), null, array('temp_id' => $id) );

	$this->UpdateForeignKeys($master, $insert_id, $id);

	//delete already copied record from master temp table
	$query = 'DELETE FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$master['IdField'].' = '.$id_to_copy;
	if (isset($master['Constrain'])) $query .= ' AND '.$master['Constrain'];
	$this->Conn->Query($query);
	}

	$this->CopiedTables[] = $table_sig;

	// when all of ids in current master has been processed, copy all sub-tables data
	$this->CopySubTablesToLive($master, $current_ids);
	}
	elseif( !in_array($table_sig, $this->CopiedTables) && ($this->FinalRefs[$table_sig] == $master['TableId']) ) { //If current master doesn't have sub-tables - we could use mass operations
	// We don't need to delete items from live here, as it get deleted in the beggining of the method for MasterTable
	// or in parent table processing for sub-tables
	$this->RaiseEvent('OnBeforeCopyToLive', $master['Prefix'], '', $current_ids);

	$live_ids = array();
	foreach ($current_ids as $an_id) {
	if ($an_id > 0) {
	$live_ids[$an_id] = $an_id;
	// positive (already live) IDs will be copied in on query all togather below,
	// so we just store it here
	continue;
	}
	else { // zero or negaitve ids should be copied one by one to get their InsertId
	// reseting to 0 so it get inserted into live table with autoincrement
	$query = 'UPDATE '.$this->GetTempName($master['TableName']).'
	SET '.$master['IdField'].' = 0
	WHERE '.$master['IdField'].' = '.$an_id;
	// constrain is not needed here because ID is already unique
	$this->Conn->Query($query);

	// copying
	$query = 'INSERT INTO '.$master['TableName'].'
	SELECT * FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$master['IdField'].' = 0';
	$this->Conn->Query($query);
	$live_ids[$an_id] = $this->Conn->getInsertID(); //storing newly created live id

	//delete already copied record from master temp table
	$query = 'DELETE FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$master['IdField'].' = 0';
	$this->Conn->Query($query);
	$this->UpdateChangeLogForeignKeys($master, $live_ids[$an_id], $an_id);
	}
	}

	// copy ALL records to live table
	$query = 'INSERT INTO '.$master['TableName'].'
	SELECT * FROM '.$this->GetTempName($master['TableName']);
	if (isset($master['Constrain'])) $query .= ' WHERE '.$master['Constrain'];
	$this->Conn->Query($query);

	$this->CopiedTables[] = $table_sig;
	$this->RaiseEvent('OnAfterCopyToLive', $master['Prefix'], '', $live_ids);

	$this->saveID($master['Prefix'], '', $live_ids);

	// no need to clear temp table - it will be dropped by next statement
	}
	}

	if ($this->FinalRefs[ $master['TableName'] ] != $master['TableId']) return;

	/*if ( is_array(getArrayValue($master, 'ForeignKey')) ) { //if multiple ForeignKeys
	if ( $master['ForeignKey'][$parent_prefix] != end($master['ForeignKey']) ) {
	return; // Do not delete temp table if not all ForeignKeys have been processed (current is not the last)
	}
	}*/
	$this->DropTempTable($master['TableName']);
	$this->Application->resetCounters($master['TableName']);

	if (!isset($this->savedIDs[ $master['Prefix'] ])) {
	$this->savedIDs[ $master['Prefix'] ] = Array();
	}

	return $this->savedIDs[ $master['Prefix'] ];
	}

	/**
	* Create separate connection for locking purposes
	*
	* @return kDBConnection
	*/
	function &_getSeparateConnection()
	{
	static $connection = null;

	if (!isset($connection)) {
	$connection = new kDBConnection(SQL_TYPE, Array(&$this->Application, 'handleSQLError') );
	$connection->debugMode = $this->Application->isDebugMode();
	$connection->Connect(SQL_SERVER, SQL_USER, SQL_PASS, SQL_DB, true);
	}

	return $connection;
	}

	function UpdateChangeLogForeignKeys($master, $live_id, $temp_id)
	{
	$main_prefix = $this->Application->GetTopmostPrefix($master['Prefix']);
	$ses_var_name = $main_prefix.'_changes_'.$this->Application->GetTopmostWid($this->Prefix);
	$changes = $this->Application->RecallVar($ses_var_name);
	$changes = $changes ? unserialize($changes) : array();

	foreach ($changes as $key => $rec) {
	if ($rec['Prefix'] == $master['Prefix']) {
	if ($rec['ItemId'] == $temp_id) {
	$changes[$key]['ItemId'] = $live_id;
	}
	}
	if ($rec['MasterPrefix'] == $master['Prefix']) {
	if ($rec['MasterId'] == $temp_id) {
	$changes[$key]['MasterId'] = $live_id;
	}
	}
	}
	$this->Application->StoreVar($ses_var_name, serialize($changes));
	}

	function UpdateForeignKeys($master, $live_id, $temp_id) {
	$this->UpdateChangeLogForeignKeys($master, $live_id, $temp_id);
	foreach ($master['SubTables'] as $sub_table) {
	$foreign_key_field = is_array($sub_table['ForeignKey']) ? getArrayValue($sub_table, 'ForeignKey', $master['Prefix']) : $sub_table['ForeignKey'];
	if (!$foreign_key_field) return;

	list ($live_foreign_key, $temp_foreign_key) = $this->GetForeignKeys($master, $sub_table, $live_id, $temp_id);

	//Update ForeignKey in sub TEMP table
	if ($live_foreign_key != $temp_foreign_key) {
	$query = 'UPDATE '.$this->GetTempName($sub_table['TableName']).'
	SET '.$foreign_key_field.' = '.$live_foreign_key.'
	WHERE '.$foreign_key_field.' = '.$temp_foreign_key;
	if (isset($sub_table['Constrain'])) $query .= ' AND '.$sub_table['Constrain'];
	$this->Conn->Query($query);
	}
	}
	}

	function CopySubTablesToLive($master, $current_ids) {
	foreach ($master['SubTables'] as $sub_table) {

	$table_sig = $sub_table['TableName'].(isset($sub_table['Constrain']) ? $sub_table['Constrain'] : '');

	// delete records from live table by foreign key, so that records deleted from temp table
	// get deleted from live
	if (count($current_ids) > 0 && !in_array($table_sig, $this->CopiedTables) ) {
	$foreign_key_field = is_array($sub_table['ForeignKey']) ? getArrayValue($sub_table, 'ForeignKey', $master['Prefix']) : $sub_table['ForeignKey'];
	if (!$foreign_key_field) continue;
	$foreign_keys = $this->GetForeignKeys($master, $sub_table, $current_ids);
	if (count($foreign_keys) > 0) {
	$query = 'SELECT '.$sub_table['IdField'].' FROM '.$sub_table['TableName'].'
	WHERE '.$foreign_key_field.' IN ('.join(',', $foreign_keys).')';
	if (isset($sub_table['Constrain'])) $query .= ' AND '.$sub_table['Constrain'];

	if ( $this->RaiseEvent( 'OnBeforeDeleteFromLive', $sub_table['Prefix'], '', $this->Conn->GetCol($query), $foreign_keys ) ){
	$query = 'DELETE FROM '.$sub_table['TableName'].'
	WHERE '.$foreign_key_field.' IN ('.join(',', $foreign_keys).')';
	if (isset($sub_table['Constrain'])) $query .= ' AND '.$sub_table['Constrain'];
	$this->Conn->Query($query);
	}
	}
	}
	//sub_table passed here becomes master in the method, and recursively updated and copy its sub tables
	$this->DoCopyTempToOriginal($sub_table, $master['Prefix']);
	}
	}

	function RaiseEvent($name, $prefix, $special, $ids, $foreign_key = null, $add_params = null)
	{
	if ( !is_array($ids) ) return ;

	$event_key = $prefix.($special ? '.' : '').$special.':'.$name;
	$event = new kEvent($event_key);
	if (isset($foreign_key)) {
	$event->setEventParam('foreign_key', $foreign_key);
	}

	foreach($ids as $id)
	{
	$event->setEventParam('id', $id);
	if (is_array($add_params)) {
	foreach ($add_params as $name => $val) {
	$event->setEventParam($name, $val);
	}
	}
	$this->Application->HandleEvent($event);
	}
	return $event->status == erSUCCESS;
	}

	function DropTempTable($table)
	{
	if( in_array($table, $this->DroppedTables) ) return false;
	$query = sprintf("DROP TABLE IF EXISTS %s",
	$this->GetTempName($table)
	);
	array_push($this->DroppedTables, $table);
	$this->DroppedTables = array_unique($this->DroppedTables);
	$this->Conn->Query($query);

	return true;
	}

	function PrepareEdit()
	{
	$this->DoCopyLiveToTemp($this->Tables, $this->Tables['IDs']);
	if ($this->Application->getUnitOption($this->Tables['Prefix'],'CheckSimulatniousEdit')) {
	$this->CheckSimultaniousEdit();
	}
	}

	function SaveEdit($master_ids = Array())
	{
	// SessionKey field is required for deleting records from expired sessions
	$conn =& $this->_getSeparateConnection();

	$sleep_count = 0;
	do {
	// aquire lock
	$conn->ChangeQuery('LOCK TABLES '.TABLE_PREFIX.'Semaphores WRITE');

	$sql = 'SELECT SessionKey
	FROM ' . TABLE_PREFIX . 'Semaphores
	WHERE (MainPrefix = ' . $conn->qstr($this->Tables['Prefix']) . ')';
	$another_coping_active = $conn->GetOne($sql);

	if ($another_coping_active) {
	// another user is coping data from temp table to live -> release lock and try again after 1 second
	$conn->ChangeQuery('UNLOCK TABLES');
	$sleep_count++;
	sleep(1);
	}
	} while ($another_coping_active && ($sleep_count <= 30));

	if ($sleep_count > 30) {
	// another coping process failed to finished in 30 seconds
	$error_message = $this->Application->Phrase('la_error_TemporaryTableCopingFailed');
	$this->Application->SetVar('_temp_table_message', $error_message);

	return false;
	}

	// mark, that we are coping from temp to live right now, so other similar attempt (from another script) will fail
	$fields_hash = Array (
	'SessionKey' => $this->Application->GetSID(),
	'Timestamp' => adodb_mktime(),
	'MainPrefix' => $this->Tables['Prefix'],
	);

	$conn->doInsert($fields_hash, TABLE_PREFIX.'Semaphores');
	$semaphore_id = $conn->getInsertID();

	// unlock table now to prevent permanent lock in case, when coping will end with SQL error in the middle
	$conn->ChangeQuery('UNLOCK TABLES');

	$ids = $this->DoCopyTempToOriginal($this->Tables, null, $master_ids);

	// remove mark, that we are coping from temp to live
	$conn->Query('LOCK TABLES '.TABLE_PREFIX.'Semaphores WRITE');

	$sql = 'DELETE FROM ' . TABLE_PREFIX . 'Semaphores
	WHERE SemaphoreId = ' . $semaphore_id;
	$conn->ChangeQuery($sql);

	$conn->ChangeQuery('UNLOCK TABLES');

	return $ids;
	}

	function CancelEdit($master=null)
	{
	if (!isset($master)) $master = $this->Tables;
	$this->DropTempTable($master['TableName']);
	if ( getArrayValue($master, 'SubTables') ) {
	foreach ($master['SubTables'] as $sub_table) {
	$this->CancelEdit($sub_table);
	}
	}
	}

	/**
	* Checks, that someone is editing selected records and returns true, when no one.
	*
	* @param Array $ids
	*
	* @return bool
	*/
	function CheckSimultaniousEdit($ids = null)
	{
	$tables = $this->Conn->GetCol('SHOW TABLES');
	$mask_edit_table = '/' . TABLE_PREFIX . 'ses_(.*)_edit_' . $this->MasterTable . '$/';

	$my_sid = $this->Application->GetSID();
	$my_wid = $this->Application->GetVar('m_wid');
	$ids = implode(',', isset($ids) ? $ids : $this->Tables['IDs']);
	$sids = Array ();
	if (!$ids) {
	return true;
	}

	foreach ($tables as $table) {
	if ( preg_match($mask_edit_table, $table, $rets) ) {
	$sid = preg_replace('/(.)_(.)/', '\\1', $rets[1]); // remove popup's wid from sid
	if ($sid == $my_sid) {
	if ($my_wid) {
	// using popups for editing
	if (preg_replace('/(.)_(.)/', '\\2', $rets[1]) == $my_wid) {
	// don't count window, that is being opened right now
	continue;
	}
	}
	else {
	// not using popups for editing -> don't count my session tables
	continue;
	}
	}

	$sql = 'SELECT COUNT(' . $this->Tables['IdField'] . ')
	FROM ' . $table . '
	WHERE ' . $this->Tables['IdField'] . ' IN (' . $ids . ')';
	$found = $this->Conn->GetOne($sql);

	if (!$found \|\| in_array($sid, $sids)) {
	continue;
	}

	$sids[] = $sid;
	}
	}

	if ($sids) {
	// detect who is it
	$sql = 'SELECT
	CONCAT(IF (s.PortalUserId = -1, \'root\',
	IF (s.PortalUserId = -2, \'Guest\',
	CONCAT(FirstName, \' \', LastName, \' (\', Login, \')\')
	)
	), \' IP: \', s.IpAddress, \'\') FROM ' . TABLE_PREFIX . 'UserSession AS s
	LEFT JOIN ' . TABLE_PREFIX . 'PortalUser AS u
	ON u.PortalUserId = s.PortalUserId
	WHERE s.SessionKey IN (' . implode(',', $sids) . ')';
	$users = $this->Conn->GetCol($sql);

	if ($users) {
	$this->Application->SetVar('_simultanious_edit_message',
	sprintf($this->Application->Phrase('la_record_being_edited_by'), join(",\n", $users))
	);

	return false;
	}
	}

	return true;
	}

	}
	\ No newline at end of file
	Index: branches/5.0.x/core/kernel/db/dbitem.php
	===================================================================
	--- branches/5.0.x/core/kernel/db/dbitem.php (revision 12782)
	+++ branches/5.0.x/core/kernel/db/dbitem.php (revision 12783)
	@@ -1,1302 +1,1309 @@
	<?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!');

	/**
	* DBItem
	*
	* Desciption
	* @package kernel4
	*/
	class kDBItem extends kDBBase {

	/**
	* Description
	*
	* @var array Associative array of current item' field values
	* @access public
	*/
	var $FieldValues;

	/**
	* Unformatted field values, before parse
	*
	* @var Array
	* @access private
	*/
	var $DirtyFieldValues = Array();

	/**
	* Holds item values after loading (not affected by submit)
	*
	* @var Array
	* @access private
	*/
	var $OriginalFieldValues = Array ();

	var $FieldErrors;

	var $ErrorMsgs = Array();

	/**
	* If set to true, Update will skip Validation before running
	*
	* @var array Associative array of current item' field values
	* @access public
	*/
	var $IgnoreValidation = false;

	var $Loaded = false;

	/**
	* Holds item' primary key value
	*
	* @var int Value of primary key field for current item
	* @access public
	*/
	var $ID;

	+ /**
	+ * This object is used in cloning operations
	+ *
	+ * @var bool
	+ */
	+ var $inCloning = false;
	+
	function kDBItem()
	{
	parent::kDBBase();
	$this->ErrorMsgs['required'] = '!la_err_required!'; //'Field is required';
	$this->ErrorMsgs['unique'] = '!la_err_unique!'; //'Field value must be unique';
	$this->ErrorMsgs['value_out_of_range'] = '!la_err_value_out_of_range!'; //'Field is out of range, possible values from %s to %s';
	$this->ErrorMsgs['length_out_of_range'] = '!la_err_length_out_of_range!'; //'Field is out of range';
	$this->ErrorMsgs['bad_type'] = '!la_err_bad_type!'; //'Incorrect data format, please use %s';
	$this->ErrorMsgs['invalid_format'] = '!la_err_invalid_format!'; //'Incorrect data format, please use %s';
	$this->ErrorMsgs['bad_date_format'] = '!la_err_bad_date_format!'; //'Incorrect date format, please use (%s) ex. (%s)';
	$this->ErrorMsgs['primary_lang_required'] = '!la_err_primary_lang_required!';
	}

	function SetDirtyField($field_name, $field_value)
	{
	$this->DirtyFieldValues[$field_name] = $field_value;
	}

	function GetDirtyField($field_name)
	{
	return $this->DirtyFieldValues[$field_name];
	}

	function GetOriginalField($field_name, $formatted = false, $format=null)
	{
	if (array_key_exists($field_name, $this->OriginalFieldValues)) {
	// item was loaded before
	$value = $this->OriginalFieldValues[$field_name];
	}
	else {
	// no original fields -> use default field value
	$value = $this->Fields[$field_name]['default'];
	}

	if (!$formatted) {
	return $value;
	}

	$options = $this->GetFieldOptions($field_name);
	$res = $value;
	if (array_key_exists('formatter', $options)) {
	$formatter =& $this->Application->recallObject($options['formatter']);
	/* @var $formatter kFormatter */

	$res = $formatter->Format($value, $field_name, $this, $format);
	}
	return $res;
	}

	/**
	* Sets original field value (useful for custom virtual fields)
	*
	* @param string $field_name
	*/
	function SetOriginalField($field_name, $field_value)
	{
	$this->OriginalFieldValues[$field_name] = $field_value;
	}

	/**
	* Set's default values for all fields
	*
	* @param bool $populate_ml_fields create all ml fields from db in config or not
	*
	* @access public
	*/
	function SetDefaultValues($populate_ml_fields = false)
	{
	parent::SetDefaultValues($populate_ml_fields);
	if ($populate_ml_fields) {
	$this->PopulateMultiLangFields();
	}

	foreach ($this->Fields as $field => $params) {
	if ( isset($params['default']) ) {
	$this->SetDBField($field, $params['default']);
	}
	else {
	$this->SetDBField($field, NULL);
	}
	}
	}

	/**
	* Sets current item field value
	* (applies formatting)
	*
	* @access public
	* @param string $name Name of the field
	* @param mixed $value Value to set the field to
	* @return void
	*/
	function SetField($name,$value)
	{
	$options = $this->GetFieldOptions($name);
	$parsed = $value;
	if ($value == '') {
	$parsed = NULL;
	}

	// kFormatter is always used, to make sure, that numeric value is converted to normal representation
	// according to regional format, even when formatter is not set (try seting format to 1.234,56 to understand why)
	$formatter =& $this->Application->recallObject(isset($options['formatter']) ? $options['formatter'] : 'kFormatter');
	$parsed = $formatter->Parse($value, $name, $this);

	$this->SetDBField($name,$parsed);
	}

	/**
	* Sets current item field value
	* (doesn't apply formatting)
	*
	* @access public
	* @param string $name Name of the field
	* @param mixed $value Value to set the field to
	* @return void
	*/
	function SetDBField($name,$value)
	{
	$this->FieldValues[$name] = $value;
	/*if (isset($this->Fields[$name]['formatter'])) {
	$formatter =& $this->Application->recallObject($this->Fields[$name]['formatter']);
	$formatter->UpdateSubFields($name, $value, $this->Fields[$name], $this);
	}*/
	}

	/**
	* Set's field error, if pseudo passed not found then create it with message text supplied.
	* Don't owerrite existing pseudo translation.
	*
	* @param string $field
	* @param string $pseudo
	* @param string $error_label
	*
	* @return bool
	*/
	function SetError($field, $pseudo, $error_label = null, $error_params = null)
	{
	$error_field = isset($this->Fields[$field]['error_field']) ? $this->Fields[$field]['error_field'] : $field;
	if (isset($this->FieldErrors[$error_field]['pseudo'])) {
	// don't set more then one error on field
	return false;
	}

	$this->FieldErrors[$error_field]['pseudo'] = $pseudo;

	if (isset($error_params)) {
	// additional params, that helps to determine error sources
	$this->FieldErrors[$error_field]['params'] = $error_params;
	}

	if (isset($error_label) && !isset($this->ErrorMsgs[$pseudo])) {
	// label for error (only when not already set)
	$this->ErrorMsgs[$pseudo] = (substr($error_label, 0, 1) == '+') ? substr($error_label, 1) : '!'.$error_label.'!';
	}

	return true;
	}

	/**
	* Return current item' field value by field name
	* (doesn't apply formatter)
	*
	* @access public
	* @param string $name field name to return
	* @return mixed
	*/
	function GetDBField($name)
	{
	/*if (!array_key_exists($name, $this->FieldValues) && defined('DEBUG_MODE') && DEBUG_MODE) {
	$this->Application->Debugger->appendTrace();
	}*/

	return $this->FieldValues[$name];
	}

	function HasField($name)
	{
	return isset($this->FieldValues[$name]);
	}

	function GetFieldValues()
	{
	return $this->FieldValues;
	}

	/**
	* Sets item' fields corresponding to elements in passed $hash values.
	*
	* The function sets current item fields to values passed in $hash, by matching $hash keys with field names
	* of current item. If current item' fields are unknown {@link kDBItem::PrepareFields()} is called before acutally setting the fields
	*
	* @access public
	* @param Array $hash
	* @param Array $set_fields Optional param, field names in target object to set, other fields will be skipped
	* @return void
	*/
	function SetFieldsFromHash($hash, $set_fields = null)
	{
	// used in formatter which work with multiple fields together
	foreach($hash as $field_name => $field_value) {
	if (is_numeric($field_name) \|\| !array_key_exists($field_name, $this->Fields)) {
	continue;
	}

	if (is_array($set_fields) && !in_array($field_name, $set_fields)) {
	continue;
	}

	$this->SetDirtyField($field_name, $field_value);
	}

	// formats all fields using associated formatters
	foreach ($hash as $field_name => $field_value)
	{
	if (is_numeric($field_name) \|\| !array_key_exists($field_name, $this->Fields)) {
	continue;
	}

	if (is_array($set_fields) && !in_array($field_name, $set_fields)) {
	continue;
	}

	$this->SetField($field_name,$field_value);
	}
	}

	function SetDBFieldsFromHash($hash, $set_fields = null)
	{
	foreach ($hash as $field_name => $field_value) {
	if (is_numeric($field_name) \|\| !array_key_exists($field_name, $this->Fields)) {
	continue;
	}

	if (is_array($set_fields) && !in_array($field_name, $set_fields)) {
	continue;
	}

	$this->SetDBField($field_name, $field_value);
	}
	}

	/**
	* Returns part of SQL WHERE clause identifing the record, ex. id = 25
	*
	* @access public
	* @param string $method Child class may want to know who called GetKeyClause, Load(), Update(), Delete() send its names as method
	* @param Array $keys_hash alternative, then item id, keys hash to load item by
	* @return void
	* @see kDBItem::Load()
	* @see kDBItem::Update()
	* @see kDBItem::Delete()
	*/
	function GetKeyClause($method=null, $keys_hash = null)
	{
	if (!isset($keys_hash)) {
	$keys_hash = Array ($this->IDField => $this->ID);
	}

	$ret = '';

	foreach ($keys_hash as $field => $value) {
	if (!preg_match('/\./', $field)) {
	$ret .= '(`' . $this->TableName . '`.' . $field . ' = ' . $this->Conn->qstr($value) . ') AND ';
	}
	else {
	$ret .= '(' . $field . ' = ' . $this->Conn->qstr($value) . ') AND ';
	}
	}

	return substr($ret, 0, -5);
	}

	/**
	* Loads item from the database by given id
	*
	* @access public
	* @param mixed $id item id of keys->values hash to load item by
	* @param string $id_field_name Optional parameter to load item by given Id field
	* @return bool True if item has been loaded, false otherwise
	*/
	function Load($id, $id_field_name = null)
	{
	if ( isset($id_field_name) ) {
	$this->SetIDField($id_field_name); // set new IDField
	}

	$keys_sql = '';
	if (is_array($id)) {
	$keys_sql = $this->GetKeyClause('load', $id);
	}
	else {
	$this->setID($id);
	$keys_sql = $this->GetKeyClause('load');
	}

	if ( isset($id_field_name) ) {
	// restore original IDField from unit config
	$this->setIDField( $this->Application->getUnitOption($this->Prefix, 'IDField') );
	}

	if (($id === false) \|\| !$keys_sql) {
	return $this->Clear();
	}

	if (!$this->raiseEvent('OnBeforeItemLoad', $id)) {
	return false;
	}

	$q = $this->GetSelectSQL() . ' WHERE ' . $keys_sql;
	$field_values = $this->Conn->GetRow($q);

	if ($field_values) {
	$this->FieldValues = array_merge_recursive2($this->FieldValues, $field_values);
	$this->OriginalFieldValues = $this->FieldValues;
	}
	else {
	return $this->Clear();
	}

	if (is_array($id) \|\| isset($id_field_name)) {
	$this->setID($this->FieldValues[$this->IDField]);
	}

	$this->UpdateFormattersSubFields(); // used for updating separate virtual date/time fields from DB timestamp (for example)

	$this->raiseEvent('OnAfterItemLoad', $this->GetID());
	$this->Loaded = true;

	return true;
	}

	/**
	* Builds select sql, SELECT ... FROM parts only
	*
	* @access public
	* @return string
	*/
	function GetSelectSQL()
	{
	$sql = $this->addCalculatedFields($this->SelectClause);
	return parent::GetSelectSQL($sql);
	}

	function UpdateFormattersMasterFields()
	{
	foreach ($this->Fields as $field => $options) {
	if (isset($options['formatter'])) {
	$formatter =& $this->Application->recallObject($options['formatter']);
	$formatter->UpdateMasterFields($field, $this->GetDBField($field), $options, $this);
	}
	}
	}

	/**
	* Allows to skip certain fields from getting into sql queries
	*
	* @param string $field_name
	* @param mixed $force_id
	* @return bool
	*/
	function skipField($field_name, $force_id = false)
	{
	$skip = false;

	// 1. skipping 'virtual' field
	$skip = $skip \|\| array_key_exists($field_name, $this->VirtualFields);

	// 2. don't write empty field value to db, when "skip_empty" option is set
	$field_value = array_key_exists($field_name, $this->FieldValues) ? $this->FieldValues[$field_name] : false;
	$skip_empty = array_key_exists('skip_empty', $this->Fields[$field_name]) ? $this->Fields[$field_name]['skip_empty'] : false;
	$skip = $skip \|\| (!$field_value && $skip_empty);

	// 3. skipping field not in Fields (nor virtual, nor real)
	$skip = $skip \|\| !array_key_exists($field_name, $this->Fields);

	return $skip;
	}

	/**
	* Updates previously loaded record with current item' values
	*
	* @access public
	* @param int Primery Key Id to update
	* @return bool
	*/
	function Update($id = null, $system_update = false)
	{
	if (isset($id)) {
	$this->setID($id);
	}

	if (!$this->raiseEvent('OnBeforeItemUpdate')) {
	return false;
	}

	if (!isset($this->ID)) {
	// ID could be set inside OnBeforeItemUpdate event, so don't combine this check with previous one
	return false;
	}

	// validate before updating
	if (!$this->Validate()) {
	return false;
	}

	if (!$this->raiseEvent('OnAfterItemValidate')) {
	return false;
	}

	if (!$this->FieldValues) {
	// nothing to update
	return true;
	}

	$sql = '';

	foreach ($this->FieldValues as $field_name => $field_value) {
	if ($this->skipField($field_name)) {
	continue;
	}

	if ( is_null($field_value) ) {
	if (array_key_exists('not_null', $this->Fields[$field_name]) && $this->Fields[$field_name]['not_null']) {
	// "kFormatter::Parse" methods converts empty values to NULL and for
	// not-null fields they are replaced with default value here
	$field_value = $this->Fields[$field_name]['default'];
	}
	}

	$sql .= '`' . $field_name . '` = ' . $this->Conn->qstr($field_value) . ', ';
	}

	$sql = 'UPDATE ' . $this->TableName . '
	SET ' . substr($sql, 0, -2) . '
	WHERE ' . $this->GetKeyClause('update');

	if ($this->Conn->ChangeQuery($sql) === false) {
	// there was and sql error
	return false;
	}

	$affected = $this->Conn->getAffectedRows();
	if (!$system_update && $affected == 1) {
	$this->setModifiedFlag(clUPDATE);
	}

	$this->saveCustomFields();
	$this->raiseEvent('OnAfterItemUpdate');
	$this->Loaded = true;

	if ($this->mode != 't') {
	$this->Application->resetCounters($this->TableName);
	}

	return true;
	}

	function ValidateField($field)
	{
	$options = $this->Fields[$field];

	/*if (isset($options['formatter'])) {
	$formatter =& $this->Application->recallObject($options['formatter']);
	$formatter->UpdateMasterFields($field, $this->GetDBField($field), $options, $this);
	}*/

	$error_field = isset($options['error_field']) ? $options['error_field'] : $field;
	$res = !isset($this->FieldErrors[$error_field]['pseudo']) \|\| !$this->FieldErrors[$error_field]['pseudo'];

	$res = $res && $this->ValidateRequired($field, $options);
	$res = $res && $this->ValidateType($field, $options);
	$res = $res && $this->ValidateRange($field, $options);
	$res = $res && $this->ValidateUnique($field, $options);
	$res = $res && $this->CustomValidation($field, $options);

	return $res;
	}

	/**
	* Validate all item fields based on
	* constraints set in each field options
	* in config
	*
	* @return bool
	* @access private
	*/
	function Validate()
	{
	$this->UpdateFormattersMasterFields(); //order is critical - should be called BEFORE checking errors

	if ($this->IgnoreValidation) {
	return true;
	}

	$global_res = true;
	foreach ($this->Fields as $field => $params) {
	$res = $this->ValidateField($field);


	$global_res = $global_res && $res;
	}

	if (!$global_res && $this->Application->isDebugMode()) {
	$error_msg = ' Validation failed in prefix <strong>'.$this->Prefix.'</strong>,
	FieldErrors follow (look at items with <strong>"pseudo"</strong> key set)<br />
	You may ignore this notice if submitted data really has a validation error';
	trigger_error(trim($error_msg), E_USER_NOTICE);
	$this->Application->Debugger->dumpVars($this->FieldErrors);
	}

	return $global_res;
	}

	/**
	* Check field value by user-defined alghoritm
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	*/
	function CustomValidation($field, $params)
	{
	return true;
	}

	/**
	* Check if item has errors
	*
	* @param Array $skip_fields fields to skip during error checking
	* @return bool
	*/
	function HasErrors($skip_fields)
	{
	$global_res = false;

	foreach ($this->Fields as $field => $field_params) {
	// If Formatter has set some error messages during values parsing
	if ( !( in_array($field, $skip_fields) ) &&
	isset($this->FieldErrors[$field]['pseudo']) && $this->FieldErrors[$field] != '') {
	$global_res = true;
	}
	}
	return $global_res;
	}

	/**
	* Check if value in field matches field type specified in config
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	*/
	function ValidateType($field, $params)
	{
	$res = true;
	$val = $this->FieldValues[$field];
	if ( $val != '' &&
	isset($params['type']) &&
	preg_match("#int\|integer\|double\|float\|real\|numeric\|string#", $params['type'])
	) {
	if ($params['type'] == 'numeric') {
	trigger_error('Invalid field type <strong>'.$params['type'].'</strong> (in ValidateType method), please use <strong>float</strong> instead', E_USER_NOTICE);
	$params['type'] = 'float';
	}
	$res = is_numeric($val);
	if ($params['type']=='string' \|\| $res) {
	$f = 'is_'.$params['type'];
	settype($val, $params['type']);
	$res = $f($val) && ($val == $this->FieldValues[$field]);
	}
	if (!$res) {
	$this->SetError($field, 'bad_type', null, $params['type']);
	}
	}
	return $res;
	}

	/**
	* Check if value is set for required field
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateRequired($field, $params)
	{
	$res = true;
	if (isset($params['required']) && $params['required']) {
	$check_value = $this->FieldValues[$field];
	if ($this->Application->ConfigValue('TrimRequiredFields')) {
	$check_value = trim($check_value);
	}
	$res = ((string)$check_value != '');
	}

	if (!$res) {
	$this->SetError($field, 'required');
	}

	return $res;
	}

	/**
	* Validates that current record has unique field combination among other table records
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateUnique($field, $params)
	{
	$res = true;
	$unique_fields = getArrayValue($params,'unique');
	if($unique_fields !== false)
	{
	$where = Array();
	array_push($unique_fields,$field);
	foreach($unique_fields as $unique_field)
	{
	// if field is not empty or if it is required - we add where condition
	if ((string)$this->GetDBField($unique_field) != '' \|\| (isset($this->Fields[$unique_field]['required']) && $this->Fields[$unique_field]['required'])) {
	$where[] = '`'.$unique_field.'` = '.$this->Conn->qstr( $this->GetDBField($unique_field) );
	}
	else {
	// not good if we check by less fields than indicated
	return true;
	}
	}
	// This can ONLY happen if all unique fields are empty and not required.
	// In such case we return true, because if unique field is not required there may be numerous empty values
	// if (!$where) return true;

	$sql = 'SELECT COUNT(*) FROM %s WHERE ('.implode(') AND (',$where).') AND ('.$this->IDField.' <> '.(int)$this->ID.')';

	$res_temp = $this->Conn->GetOne( str_replace('%s', $this->TableName, $sql) );

	$current_table_only = getArrayValue($params, 'current_table_only'); // check unique record only in current table
	$res_live = $current_table_only ? 0 : $this->Conn->GetOne( str_replace('%s', $this->Application->GetLiveName($this->TableName), $sql) );

	$res = ($res_temp == 0) && ($res_live == 0);

	if (!$res) {
	$this->SetError($field, 'unique');
	}
	}
	return $res;
	}

	/**
	* Check if field value is in range specified in config
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateRange($field, $params)
	{
	$res = true;
	$val = $this->FieldValues[$field];

	if ( isset($params['type']) && preg_match("#int\|integer\|double\|float\|real#", $params['type']) && strlen($val) > 0 ) {
	if ( isset($params['max_value_inc'])) {
	$res = $res && $val <= $params['max_value_inc'];
	$max_val = $params['max_value_inc'].' (inclusive)';
	}
	if ( isset($params['min_value_inc'])) {
	$res = $res && $val >= $params['min_value_inc'];
	$min_val = $params['min_value_inc'].' (inclusive)';
	}
	if ( isset($params['max_value_exc'])) {
	$res = $res && $val < $params['max_value_exc'];
	$max_val = $params['max_value_exc'].' (exclusive)';
	}
	if ( isset($params['min_value_exc'])) {
	$res = $res && $val > $params['min_value_exc'];
	$min_val = $params['min_value_exc'].' (exclusive)';
	}
	}
	if (!$res) {
	if ( !isset($min_val) ) $min_val = '-∞';
	if ( !isset($max_val) ) $max_val = '∞';

	$this->SetError($field, 'value_out_of_range', null, Array ($min_val, $max_val));
	return $res;
	}
	if ( isset($params['max_len'])) {
	$res = $res && mb_strlen($val) <= $params['max_len'];
	}
	if ( isset($params['min_len'])) {
	$res = $res && mb_strlen($val) >= $params['min_len'];
	}
	if (!$res) {
	$error_params = Array (getArrayValue($params, 'min_len'), getArrayValue($params, 'max_len'));
	$this->SetError($field, 'length_out_of_range', null, $error_params);
	return $res;
	}
	return $res;
	}

	/**
	* Return error message for field
	*
	* @param string $field
	* @return string
	* @access public
	*/
	function GetErrorMsg($field, $force_escape = null)
	{
	if( !isset($this->FieldErrors[$field]) ) return '';

	$err = getArrayValue($this->FieldErrors[$field], 'pseudo');
	if (!$err) return '';
	// if special error msg defined in config
	if( isset($this->Fields[$field]['error_msgs'][$err]) )
	{
	$msg = $this->Fields[$field]['error_msgs'][$err];
	}
	else //fall back to defaults
	{
	if( !isset($this->ErrorMsgs[$err]) ) {
	trigger_error('No user message is defined for pseudo error <b>'.$err.'</b><br>', E_USER_WARNING);
	return $err; //return the pseudo itself
	}
	$msg = $this->ErrorMsgs[$err];
	}
	$msg = $this->Application->ReplaceLanguageTags($msg, $force_escape);

	if ( isset($this->FieldErrors[$field]['params']) )
	{
	return vsprintf($msg, $this->FieldErrors[$field]['params']);
	}
	return $msg;
	}

	/**
	* Creates a record in the database table with current item' values
	*
	* @param mixed $force_id Set to TRUE to force creating of item's own ID or to value to force creating of passed id. Do not pass 1 for true, pass exactly TRUE!
	* @access public
	* @return bool
	*/
	function Create($force_id = false, $system_create = false)
	{
	if (!$this->raiseEvent('OnBeforeItemCreate')) {
	return false;
	}

	// Validating fields before attempting to create record
	if (!$this->Validate()) {
	return false;
	}

	if (!$this->raiseEvent('OnAfterItemValidate')) {
	return false;
	}

	if (is_int($force_id)) {
	$this->FieldValues[$this->IDField] = $force_id;
	}
	elseif (!$force_id \|\| !is_bool($force_id)) {
	$this->FieldValues[$this->IDField] = $this->generateID();
	}

	$fields_sql = '';
	$values_sql = '';
	foreach ($this->FieldValues as $field_name => $field_value) {
	if ($this->skipField($field_name, $force_id)) {
	continue;
	}

	if (is_null($field_value)) {
	if (array_key_exists('not_null', $this->Fields[$field_name]) && $this->Fields[$field_name]['not_null']) {
	// "kFormatter::Parse" methods converts empty values to NULL and for
	// not-null fields they are replaced with default value here
	$values_sql .= $this->Conn->qstr($this->Fields[$field_name]['default']);
	}
	else {
	$values_sql .= $this->Conn->qstr($field_value);
	}
	}
	else {
	if (($field_name == $this->IDField) && ($field_value == 0)) {
	// don't skip IDField in INSERT statement, just use DEFAULT keyword as it's value
	$values_sql .= 'DEFAULT';
	}
	else {
	$values_sql .= $this->Conn->qstr($field_value);
	}
	}

	$fields_sql .= '`' . $field_name . '`, '; //Adding field name to fields block of Insert statement
	$values_sql .= ', ';
	}

	$sql = 'INSERT INTO ' . $this->TableName . ' (' . substr($fields_sql, 0, -2) . ')
	VALUES (' . substr($values_sql, 0, -2) . ')';

	//Executing the query and checking the result
	if ($this->Conn->ChangeQuery($sql) === false) {
	return false;
	}

	$insert_id = $this->Conn->getInsertID();
	if ($insert_id == 0) {
	// insert into temp table (id is not auto-increment field)
	$insert_id = $this->FieldValues[$this->IDField];
	}
	$this->setID($insert_id);

	if (!$system_create){
	$this->setModifiedFlag(clCREATE);
	}

	$this->saveCustomFields();
	if ($this->mode != 't') {
	$this->Application->resetCounters($this->TableName);
	}
	$this->raiseEvent('OnAfterItemCreate');
	$this->Loaded = true;

	return true;
	}

	/**
	* Deletes the record from databse
	*
	* @access public
	* @return bool
	*/
	function Delete($id = null)
	{
	if (isset($id)) {
	$this->setID($id);
	}

	if (!$this->raiseEvent('OnBeforeItemDelete')) {
	return false;
	}

	$sql = 'DELETE FROM ' . $this->TableName . '
	WHERE ' . $this->GetKeyClause('Delete');

	$ret = $this->Conn->ChangeQuery($sql);
	$affected_rows = $this->Conn->getAffectedRows();

	$this->setModifiedFlag(clDELETE); // will change affected rows, so get it before this line

	if ($affected_rows > 0) {
	// something was actually deleted
	$this->raiseEvent('OnAfterItemDelete');
	}

	if ($this->mode != 't') {
	$this->Application->resetCounters($this->TableName);
	}

	return $ret;
	}

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

	$lang_count = $ml_helper->getLanguageCount();
	foreach ($this->Fields as $field => $options)
	{
	// master field is set only for CURRENT language
	if (isset($options['formatter']) && $options['formatter'] == 'kMultiLanguage' && isset($options['master_field'])) {
	if (preg_match('/^l([0-9]+)_(.*)/', $field, $regs)) {
	$l = $regs[1];
	$name = $regs[2];
	// MuliLanguage formatter sets error_field to master_field, but in PopulateMlFields mode, we display ML fields directly
	// so we set it back to itself, otherwise error will not be displayed
	$this->Fields['l' . $l . '_' . $name]['error_field'] = 'l' . $l . '_' . $name;
	for ($i = 1; $i <= $lang_count; $i++) {
	if ($i == $l \|\| !$ml_helper->LanguageFound($i)) continue;
	$f_options = $options;
	$f_options['error_field'] = 'l' . $i . '_' . $name; // set error field back to itself - see comment above
	if ($i != $this->Application->GetDefaultLanguageId()) {
	unset($f_options['required']); // all non-primary language field set to non-required
	}
	$this->Fields['l' . $i . '_' . $name] = $f_options;
	}
	}
	}
	}
	}

	/**
	* Sets new name for item in case if it is beeing copied
	* in same table
	*
	* @param array $master Table data from TempHandler
	* @param int $foreign_key ForeignKey value to filter name check query by
	* @param string $title_field FieldName to alter, by default - TitleField of the prefix
	* @param string $format sprintf-style format of renaming pattern, by default Copy %1$s of %2$s which makes it Copy [Number] of Original Name
	* @access private
	*/
	function NameCopy($master=null, $foreign_key=null, $title_field=null, $format='Copy %1$s of %2$s')
	{
	if (!isset($title_field)) {
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (!$title_field \|\| isset($this->CalculatedFields[$title_field]) ) return;
	}

	$new_name = $this->GetDBField($title_field);
	$original_checked = false;
	do {
	if ( preg_match('/'.sprintf($format, '([0-9]) ', '(.*)').'/', $new_name, $regs) ) {
	$new_name = sprintf($format, ($regs[1]+1), $regs[2]);
	}
	elseif ($original_checked) {
	$new_name = sprintf($format, '', $new_name);
	}

	// if we are cloning in temp table this will look for names in temp table,
	// since object' TableName contains correct TableName (for temp also!)
	// if we are cloning live - look in live
	$query = 'SELECT '.$title_field.' FROM '.$this->TableName.'
	WHERE '.$title_field.' = '.$this->Conn->qstr($new_name);

	$foreign_key_field = getArrayValue($master, 'ForeignKey');
	$foreign_key_field = is_array($foreign_key_field) ? $foreign_key_field[ $master['ParentPrefix'] ] : $foreign_key_field;

	if ($foreign_key_field && isset($foreign_key)) {
	$query .= ' AND '.$foreign_key_field.' = '.$foreign_key;
	}

	$res = $this->Conn->GetOne($query);

	/*// if not found in live table, check in temp table if applicable
	if ($res === false && $object->Special == 'temp') {
	$query = 'SELECT '.$name_field.' FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$name_field.' = '.$this->Conn->qstr($new_name);
	$res = $this->Conn->GetOne($query);
	}*/

	$original_checked = true;
	} while ($res !== false);
	$this->SetDBField($title_field, $new_name);
	}

	function raiseEvent($name, $id = null, $additional_params = Array())
	{
	if( !isset($id) ) $id = $this->GetID();
	$event = new kEvent( Array('name'=>$name,'prefix'=>$this->Prefix,'special'=>$this->Special) );
	$event->setEventParam('id', $id);

	if ($additional_params) {
	foreach ($additional_params as $ap_name => $ap_value) {
	$event->setEventParam($ap_name, $ap_value);
	}
	}

	$this->Application->HandleEvent($event);
	return $event->status == erSUCCESS ? true : false;
	}

	/**
	* Set's new ID for item
	*
	* @param int $new_id
	* @access public
	*/
	function setID($new_id)
	{
	$this->ID = $new_id;
	$this->SetDBField($this->IDField, $new_id);
	}

	/**
	* Generate and set new temporary id
	*
	* @access private
	*/
	function setTempID()
	{
	$new_id = (int)$this->Conn->GetOne('SELECT MIN('.$this->IDField.') FROM '.$this->TableName);
	if($new_id > 0) $new_id = 0;
	--$new_id;

	$this->Conn->Query('UPDATE '.$this->TableName.' SET `'.$this->IDField.'` = '.$new_id.' WHERE `'.$this->IDField.'` = '.$this->GetID());

	if ($this->ShouldLogChanges()) {
	// Updating TempId in ChangesLog, if changes are disabled
	$ses_var_name = $this->Application->GetTopmostPrefix($this->Prefix).'_changes_'.$this->Application->GetTopmostWid($this->Prefix);
	$changes = $this->Application->RecallVar($ses_var_name);
	$changes = $changes ? unserialize($changes) : Array ();
	if ($changes) {
	foreach ($changes as $key => $rec) {
	if ($rec['Prefix'] == $this->Prefix && $rec['ItemId'] == $this->GetID()) {
	$changes[$key]['ItemId'] = $new_id;
	}
	}
	}
	$this->Application->StoreVar($ses_var_name, serialize($changes));
	}

	$this->SetID($new_id);
	}

	/**
	* Set's modification flag for main prefix of current prefix to true
	*
	* @access private
	* @author Alexey
	*/
	function setModifiedFlag($mode = null)
	{
	$main_prefix = $this->Application->GetTopmostPrefix($this->Prefix);
	$this->Application->StoreVar($main_prefix.'_modified', '1', !$this->Application->isAdmin);

	if ($this->ShouldLogChanges()) {
	$this->LogChanges($main_prefix, $mode);
	if (!$this->IsTempTable()) {
	$handler =& $this->Application->recallObject($this->Prefix.'_EventHandler');
	$ses_var_name = $main_prefix.'_changes_'.$this->Application->GetTopmostWid($this->Prefix);
	$handler->SaveLoggedChanges($ses_var_name);
	}
	}
	}

	/**
	* Determines, that changes made to this item should be written to change log
	*
	* @return bool
	*/
	function ShouldLogChanges()
	{
	$log_changes = $this->Application->getUnitOption($this->Prefix, 'LogChanges') \|\| $this->Application->ConfigValue('UseChangeLog');

	return $log_changes && !$this->Application->getUnitOption($this->Prefix, 'ForceDontLogChanges');
	}

	function LogChanges($main_prefix, $mode)
	{
	if (!$mode) {
	return ;
	}

	$ses_var_name = $main_prefix.'_changes_'.$this->Application->GetTopmostWid($this->Prefix);
	$changes = $this->Application->RecallVar($ses_var_name);
	$changes = $changes ? unserialize($changes) : array();

	$general = array(
	'Prefix' => $this->Prefix,
	'ItemId' => $this->GetID(),
	'OccuredOn' => adodb_mktime(),
	'MasterPrefix' => $main_prefix,
	'MasterId' => $this->Prefix == $main_prefix ? $this->GetID() : $this->Application->GetVar($main_prefix.'_id'), // is that correct (Kostja)??
	'Action' => $mode,
	);
	switch ($mode) {
	case clUPDATE:
	$changes[] = array_merge($general, Array(
	'Changes' => serialize(array_merge($this->GetTitleField(), $this->GetChangedFields())),
	));
	break;
	case clCREATE:
	$changes[] = array_merge($general, Array(
	'Changes' => serialize($this->GetTitleField()),
	));
	break;
	case clDELETE:
	$changes[] = array_merge($general, Array(
	'Changes' => serialize(array_merge($this->GetTitleField(), $this->GetRealFields())),
	));
	}

	$this->Application->StoreVar($ses_var_name, serialize($changes));
	}

	function GetTitleField()
	{
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if ($title_field && $this->GetField($title_field)) {
	return Array($title_field => $this->GetField($title_field));
	}
	}

	function GetRealFields()
	{
	if (function_exists('array_diff_key')) {
	$db_fields = array_diff_key($this->FieldValues, $this->VirtualFields, $this->CalculatedFields);
	}
	else {
	$db_fields = array();
	foreach ($this->FieldValues as $key => $value) {
	if (array_key_exists($key, $this->VirtualFields) \|\| array_key_exists($key, $this->CalculatedFields)) continue;
	$db_fields[$key] = $value;
	}
	}
	return $db_fields;
	}

	function GetChangedFields()
	{
	$changes = array();

	$diff = array_diff_assoc($this->GetRealFields(), $this->OriginalFieldValues);
	foreach ($diff as $field => $new_value) {
	$changes[$field] = array('old' => $this->GetOriginalField($field, true), 'new' => $this->GetField($field));
	}
	return $changes;
	}

	/**
	* Returns ID of currently processed record
	*
	* @return int
	* @access public
	*/
	function GetID()
	{
	return $this->ID;
	}

	/**
	* Generates ID for new items before inserting into database
	*
	* @return int
	* @access private
	*/
	function generateID()
	{
	return 0;
	}

	/**
	* Returns true if item was loaded successfully by Load method
	*
	* @return bool
	*/
	function isLoaded()
	{
	return $this->Loaded;
	}

	/**
	* Checks if field is required
	*
	* @param string $field
	* @return bool
	*/
	function isRequired($field)
	{
	return getArrayValue( $this->Fields[$field], 'required' );
	}

	/**
	* Sets new required flag to field
	*
	* @param string $field
	* @param bool $is_required
	*/
	function setRequired($field, $is_required = true)
	{
	$this->Fields[$field]['required'] = $is_required;
	}

	function Clear($new_id = null)
	{
	$this->Loaded = false;
	$this->FieldValues = Array();
	$this->OriginalFieldValues = Array ();
	$this->SetDefaultValues(); // will wear off kDBItem::setID effect, so set it later
	$this->FieldErrors = Array();

	$this->setID($new_id);

	return $this->Loaded;
	}

	function Query($force = false)
	{
	if ($this->Application->isDebugMode()) {
	$this->Application->Debugger->appendTrace();
	}

	trigger_error('<b>Query</b> method is called in class <b>'.get_class($this).'</b> for prefix <b>'.$this->getPrefixSpecial().'</b>', E_USER_ERROR);
	}

	function saveCustomFields()
	{
	- if (!$this->customFields) {
	+ if (!$this->customFields \|\| $this->inCloning) {
	return true;
	}

	$cdata_key = rtrim($this->Prefix.'-cdata.'.$this->Special, '.');
	$cdata =& $this->Application->recallObject($cdata_key, null, Array('skip_autoload' => true, 'populate_ml_fields' => true));

	$resource_id = $this->GetDBField('ResourceId');
	$cdata->Load($resource_id, 'ResourceId');
	$cdata->SetDBField('ResourceId', $resource_id);

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

	foreach ($this->customFields as $custom_id => $custom_name) {
	$force_primary = isset($cdata->Fields['cust_'.$custom_id]['force_primary']) && $cdata->Fields['cust_'.$custom_id]['force_primary'];
	$cdata->SetDBField($ml_formatter->LangFieldName('cust_'.$custom_id, $force_primary), $this->GetDBField('cust_'.$custom_name));
	}

	if ($cdata->isLoaded()) {
	$ret = $cdata->Update();
	}
	else {
	$ret = $cdata->Create();
	if ($cdata->mode == 't') $cdata->setTempID();
	}

	return $ret;
	}

	/**
	* Returns specified field value from all selected rows.
	* Don't affect current record index
	*
	* @param string $field
	* @return Array
	*/
	function GetCol($field)
	{
	return Array (0 => $this->GetDBField($field));
	}

	}
	\ No newline at end of file
	Index: branches/5.0.x/core/units/custom_data/custom_data_config.php
	===================================================================
	--- branches/5.0.x/core/units/custom_data/custom_data_config.php (revision 12782)
	+++ branches/5.0.x/core/units/custom_data/custom_data_config.php (revision 12783)
	@@ -1,49 +1,49 @@
	<?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' => 'cdata',

	'QueryString' => Array (
	1 => 'id',
	2 => 'event',
	),

	'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'),
	'ListClass' => Array('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
	'EventHandlerClass' => Array('class' => 'CustomDataEventHandler', 'file' => 'custom_data_event_handler.php', 'build_event' => 'OnBuild'),
	'TagProcessorClass' => Array('class' => 'kDBTagProcessor', 'file' => '', 'build_event' => 'OnBuild'),
	'AutoLoad' => true,

	'IDField' => 'CustomDataId',

	'ParentTableKey' => 'ResourceId',
	'ForeignKey' => 'ResourceId',
	'AutoDelete' => true,
	- 'AutoClone' => false,
	+ 'AutoClone' => true,

	'CalculatedFields' => Array (
	'' => Array(),
	),

	'ListSQLs' => Array('' => 'SELECT %1$s.* %2$s FROM %1$s'),
	'ItemSQLs' => Array('' => 'SELECT %1$s.* %2$s FROM %1$s'),

	'Fields' => Array (
	'CustomDataId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	'ResourceId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
	),
	);
	\ 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