in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Thu, Jul 17, 1:40 PM

in-portal
View Options

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

	Index: trunk/kernel/include/debugger.php
	===================================================================
	--- trunk/kernel/include/debugger.php (revision 3647)
	+++ trunk/kernel/include/debugger.php (revision 3648)
	@@ -1,1017 +1,1029 @@
	<?php

	if( !class_exists('Debugger') )
	{
	function dbg_ConstOn($const_name)
	{
	return defined($const_name) && constant($const_name);
	}

	function dbg_safeDefine($const_name,$const_value)
	{
	if(!defined($const_name)) define($const_name,$const_value);
	}

	- unset($_REQUEST['debug_host']); // this var messed up whole detection stuff :(
	+ unset($_REQUEST['debug_host'], $_REQUEST['debug_fastfile']); // this var messed up whole detection stuff :(

	// Detect fact, that this session beeing debugged by Zend Studio
	foreach($_REQUEST as $rq_name=>$rq_value)
	{
	if( substr($rq_name,0,6)=='debug_' )
	{
	dbg_safeDefine('DBG_ZEND_PRESENT', 1);
	break;
	}
	}

	dbg_safeDefine('DBG_ZEND_PRESENT',0);

	// set default values for debugger constants
	$dbg_constMap=Array('DBG_OPTIONS'=>0,
	'DBG_USE_HIGHLIGHT'=>1,
	'DBG_USE_SHUTDOWN_FUNC'=>DBG_ZEND_PRESENT?0:1,
	'DBG_HANDLE_ERRORS'=>DBG_ZEND_PRESENT?0:1,
	'DBG_IGNORE_STRICT_ERRORS'=>1,
	'DBG_DOMVIEWER'=>'/temp/domviewer.html',
	'DOC_ROOT'=> str_replace('\\', '/', realpath($_SERVER['DOCUMENT_ROOT']) ), // windows hack
	'DBG_LOCAL_BASE_PATH'=>'w:');

	foreach($dbg_constMap as $dbg_constName=>$dbg_constValue)
	{
	dbg_safeDefine($dbg_constName,$dbg_constValue);
	}

	// only for IE, in case if no windows php script editor defined
	/*if(!defined('WINDOWS_EDITOR'))
	{
	$dbg_editor = 0;
	$dbg_editors[0] = Array('editor' => 'c:\Program Files\UltraEdit\uedit32.exe', 'params' => '%F/%L');
	$dbg_editors[1] = Array('editor' => 'c:\Program Files\Zend\ZendStudio-4.0Beta\bin\ZDE.exe', 'params' => '%F');
	define('WINDOWS_EDITOR',$dbg_editors[$dbg_editor]['editor'].' '.$dbg_editors[$dbg_editor]['params']);
	unset($dbg_editors,$dbg_editor);
	}*/

	class Debugger
	{
	/**
	* Debugger data for building report
	*
	* @var Array
	*/
	var $Data = Array();
	var $ProfilerData = Array();
	var $ProfilerTotals = Array();
	+ var $ProfilerTotalCount = Array();
	var $RecursionStack = Array(); // prevent recursion when processing debug_backtrace() function results

	var $TraceNextError=false;

	var $Options = 0;
	var $OptionsMap = Array('shutdown_func' => 1, 'error_handler' => 2,
	'output_buffer' => 4, 'highlight_output' => 8);


	var $longErrors=Array();

	/**
	* Amount of memory used by debugger itself
	*
	* @var Array
	* @access private
	*/
	var $memoryUsage=Array();

	var $IncludesData=Array();
	var $IncludeLevel=0;

	var $reportDone = false;

	function Debugger()
	{
	$this->profileStart('kernel4_startup', 'Startup and Initialization of kernel4');
	$this->profileStart('script_runtime', 'Script runtime');
	ini_set('display_errors',dbg_ConstOn('DBG_ZEND_PRESENT')?0:1);
	$this->memoryUsage['error_handling']=0; // memory amount used by error handler
	$this->appendRequest();
	}

	function initOptions()
	{

	}

	function mapLongError($msg)
	{
	$key=$this->generateID();
	$this->longErrors[$key]=$msg;
	return $key;
	}

	function setOption($name,$value)
	{
	if( !isset($this->OptionsMap[$name]) ) die('undefined debugger option: ['.$name.']<br>');
	if($value)
	{
	$this->Options\|=$this->OptionsMap[$name];
	}
	else
	{
	$this->Options=$this->Options&~$this->OptionsMap[$name];
	}
	}

	function getOption($name)
	{
	if( !isset($this->OptionsMap[$name]) ) die('undefined debugger option: ['.$name.']<br>');
	return ($this->Options & $this->OptionsMap[$name]) == $this->OptionsMap[$name];
	}

	/**
	* Set's flag, that next error that occurs will
	* be prepended by backtrace results
	*
	*/
	function traceNext()
	{
	$this->TraceNextError=true;
	}

	function dumpVars()
	{
	$dumpVars = func_get_args();
	foreach($dumpVars as $varValue)
	{
	$this->Data[] = Array('value' => $varValue, 'debug_type' => 'var_dump');
	}
	}

	function prepareHTML($dataIndex)
	{
	$Data =& $this->Data[$dataIndex];
	if($Data['debug_type'] == 'html') return $Data['html'];

	switch($Data['debug_type'])
	{
	case 'error':
	$fileLink = $this->getFileLink($Data['file'],$Data['line']);
	$ret = '<b class="debug_error">'.$this->getErrorNameByCode($Data['no']).'</b>: '.$Data['str'];
	$ret .= ' in <b>'.$fileLink.'</b> on line <b>'.$Data['line'].'</b>';
	return $ret;
	break;

	case 'var_dump':
	return $this->highlightString( print_r($Data['value'], true) );
	break;

	case 'trace':
	ini_set('memory_limit','500M');
	$trace =& $Data['trace'];

	//return 'sorry';
	//return $this->highlightString(print_r($trace,true));


	$i = 0; $traceCount = count($trace);
	$ret = '';
	while($i < $traceCount)
	{
	$traceRec =& $trace[$i];
	$argsID = 'trace_args_'.$dataIndex.'_'.$i;

	$has_args = isset($traceRec['args']);

	if(isset($traceRec['file']))
	{
	$func_name=isset($traceRec['class'])?$traceRec['class'].$traceRec['type'].$traceRec['function']:$traceRec['function'];
	$args_link = $has_args ? '<a href="javascript:toggleTraceArgs(\''.$argsID.'\');" title="Show/Hide Function Arguments"><b>Function</b></a>' : '<b>Function</b>';

	$ret .= $args_link.': '.$this->getFileLink($traceRec['file'],$traceRec['line'],$func_name);
	$ret .= ' in <b>'.basename($traceRec['file']).'</b> on line <b>'.$traceRec['line'].'</b><br>';
	}
	else
	{
	$ret .= 'no file information available';
	}

	// ensure parameter value is not longer then 200 symbols
	if($has_args)
	{
	$this->processTraceArguments($traceRec['args']);
	$args = $this->highlightString(print_r($traceRec['args'], true));
	$ret .= '<div id="'.$argsID.'" style="display: none;">'.$args.'</div>';
	}
	$i++;
	}
	return $ret;
	break;

	case 'profiler':
	$profileKey = $Data['profile_key'];
	$Data =& $this->ProfilerData[$profileKey];
	$runtime = ($Data['ends'] - $Data['begins']); // in seconds
	return '<b>Name</b>: '.$Data['description'].'<br><b>Runtime</b>: '.$runtime.'s';
	break;

	default:
	return 'incorrect debug data';
	break;
	}
	}

	function isApplication(&$object)
	{
	$app_class = defined('APPLICATION_CLASS') ? strtolower(APPLICATION_CLASS) : 'kApplication';
	return get_class($object) == $app_class;
	}

	function processTraceArguments(&$traceArgs)
	{
	if(!$traceArgs) return '';

	$array_keys = array_keys($traceArgs);
	foreach($array_keys as $argID)
	{
	$argValue =& $traceArgs[$argID];

	if( is_array($argValue) \|\| is_object($argValue) )
	{
	if(is_object($argValue) && !in_array(get_class($argValue),$this->RecursionStack) )
	{
	array_push($this->RecursionStack, get_class($argValue));

	if( get_class($argValue) == 'kfactory' \|\| $this->isApplication($argValue) \|\| get_class($argValue) == 'templateparser' )
	{
	$argValue = null;
	continue;
	}

	// object & not in stack - ok
	settype($argValue,'array');
	$this->processTraceArguments($argValue);
	array_pop($this->RecursionStack);
	}
	elseif(is_object($argValue) && in_array(get_class($argValue),$this->RecursionStack) )
	{
	// object & in stack - recursion
	$traceArgs[$argID] = '** RECURSION *';
	}
	else
	{
	// normal array here
	$this->processTraceArguments($argValue);
	}
	}
	else
	{
	$traceArgs[$argID] = $this->cutStringForHTML($traceArgs[$argID]);
	}
	}
	}

	function cutStringForHTML($string)
	{
	if( strlen($string) > 200 ) $string = substr($string,0,50).' ...';
	return $string;
	}

	/**
	* Format SQL Query using predefined formatting
	* and highlighting techniques
	*
	* @param string $sql
	* @return string
	*/
	function formatSQL($sql)
	{
	$sql = preg_replace('/(\n\|\t\| )+/is',' ',$sql);
	$sql = preg_replace('/(CREATE TABLE\|DROP TABLE\|SELECT\|UPDATE\|SET\|REPLACE\|INSERT\|DELETE\|VALUES\|FROM\|LEFT JOIN\|INNER JOIN\|LIMIT\|WHERE\|HAVING\|GROUP BY\|ORDER BY) /is', "\n\t$1 ",$sql);
	return $this->highlightString($sql);
	}

	function highlightString($string)
	{
	if( dbg_ConstOn('DBG_USE_HIGHLIGHT') )
	{
	$string = str_replace( Array('\\', '/') , Array('_no_match_string_', '_n_m_s_'), $string);
	$string = highlight_string('<?php '.$string.'?>', true);
	$string = str_replace( Array('_no_match_string_', '_n_m_s_'), Array('\\', '/'), $string);
	return preg_replace('/<\?(.)php (.)\?>/s','$2',$string);
	}
	else
	{
	return $string;
	}
	}

	function getFileLink($file, $lineno = 1, $title = '')
	{
	if(!$title) $title = $file;
	$is_mozilla=strpos(strtolower($_SERVER['HTTP_USER_AGENT']),'firefox')!==false?true:false;
	if($is_mozilla)
	{
	return '<a href="file://'.$this->getLocalFile($file).'">'.$title.'</a>';
	}
	else
	{
	return '<a href="javascript:editFile(\''.$this->getLocalFile($file).'\','.$lineno.');" title="'.$file.'">'.$title.'</a>';
	}

	}

	function getLocalFile($remoteFile)
	{
	return str_replace(DOC_ROOT, DBG_LOCAL_BASE_PATH, $remoteFile);
	}

	function appendTrace()
	{
	$trace = debug_backtrace();
	array_shift($trace);
	$this->Data[] = Array('trace' => $trace, 'debug_type' => 'trace');
	}

	function appendMemoryUsage($msg, $used=null)
	{
	if (!isset($used)) $used = round(memory_get_usage()/1024);
	$this->appendHTML('<b>Memory usage</b> '.$msg.' '.$used.'Kb');
	}

	function appendHTML($html)
	{
	$this->Data[] = Array('html' => $html,'debug_type' => 'html');
	}

	/**
	* Change debugger info that was already generated before.
	* Returns true if html was set.
	*
	* @param int $index
	* @param string $html
	* @param string $type = {'append','prepend','replace'}
	* @return bool
	*/
	function setHTMLByIndex($index,$html,$type='append')
	{
	if( !isset($this->Data[$index]) \|\| $this->Data[$index]['debug_type'] != 'html' )
	{
	return false;
	}

	switch ($type)
	{
	case 'append':
	$this->Data[$index]['html'] .= '<br>'.$html;
	break;
	case 'prepend':
	$this->Data[$index]['html'] = $this->Data[$index]['html'].'<br>'.$html;
	break;
	case 'replace':
	$this->Data[$index]['html'] = $html;
	break;
	}
	return true;
	}

	/**
	* Move $debugLineCount lines of input from debug output
	* end to beginning.
	*
	* @param int $debugLineCount
	*/
	function moveToBegin($debugLineCount)
	{
	$lines = array_splice($this->Data,count($this->Data)-$debugLineCount,$debugLineCount);
	$this->Data = array_merge($lines,$this->Data);
	}

	function moveAfterRow($new_row, $debugLineCount)
	{
	$lines = array_splice($this->Data,count($this->Data)-$debugLineCount,$debugLineCount);
	$rows_before = array_splice($this->Data,0,$new_row,$lines);
	$this->Data = array_merge($rows_before,$this->Data);
	}

	function appendRequest()
	{
	- $script = $_SERVER['SCRIPT_FILENAME'];
	+ if (isset($_SERVER['SCRIPT_FILENAME'])) {
	+ $script = $_SERVER['SCRIPT_FILENAME'];
	+ }
	+ else {
	+ $script = $_SERVER['DOCUMENT_ROOT'].$_SERVER['PHP_SELF'];
	+ }
	+
	$this->appendHTML('ScriptName: <b>'.$this->getFileLink($script,1,basename($script)).'</b> (<b>'.dirname($script).'</b>)');

	$this->appendHTML('<a href="http://www.brainjar.com/dhtml/domviewer/" target="_blank">DomViewer</a>: <input id="dbg_domviewer" type="text" value="window" style="border: 1px solid #000000;"/> <button class="button" onclick="return dbg_OpenDOMViewer();">Show</button>');

	ob_start();
	?>
	<table border="0" cellspacing="0" cellpadding="0" class="dbg_flat_table" style="width: 100%;">
	<thead style="font-weight: bold;">
	<td width="20">Src</td><td>Name</td><td>Value</td>
	</thead>
	<?php
	foreach($_REQUEST as $key => $value)
	{
	if( !is_array($value) && trim($value) == '' )
	{
	$value = '<b class="debug_error">no value</b>';
	}
	else
	{
	$value = htmlspecialchars(print_r($value, true));
	}

	$in_cookie = isset($_COOKIE[$key]);
	$src = isset($_GET[$key]) && !$in_cookie ? 'GE' : (isset($_POST[$key]) && !$in_cookie ? 'PO' : ($in_cookie ? 'CO' : '?') );
	echo '<tr><td>'.$src.'</td><td>'.$key.'</td><td>'.$value.'</td></tr>';
	}
	?>
	</table>
	<?php
	$this->appendHTML( ob_get_contents() );
	ob_end_clean();
	}

	function appendSession()
	{
	if( isset($_SESSION)&&$_SESSION )
	{
	$this->appendHTML('PHP Session: [<b>'.ini_get('session.name').'</b>]');
	$this->dumpVars($_SESSION);
	$this->moveToBegin(2);
	}
	}

	function profileStart($key, $description)
	{
	$timeStamp = $this->getMoment();
	$this->ProfilerData[$key] = Array('begins' => $timeStamp, 'ends' => 5000, 'debuggerRowID' => count($this->Data), 'description' => $description);
	$this->Data[] = array('profile_key' => $key, 'debug_type' => 'profiler');
	}

	function profileFinish($key)
	{
	$this->ProfilerData[$key]['ends'] = $this->getMoment();
	}

	function profilerAddTotal($total_key, $key=null, $value=null)
	{
	if (!isset($this->ProfilerTotals[$total_key])) {
	$this->ProfilerTotals[$total_key] = 0;
	+ $this->ProfilerTotalCount[$total_key] = 0;
	}
	if (!isset($value)) {
	$value = $this->ProfilerData[$key]['ends'] - $this->ProfilerData[$key]['begins'];
	}
	$this->ProfilerTotals[$total_key] += $value;
	+ $this->ProfilerTotalCount[$total_key]++;
	}

	function getMoment()
	{
	list($usec, $sec) = explode(' ', microtime());
	return ((float)$usec + (float)$sec);
	}

	function generateID()
	{
	list($usec, $sec) = explode(" ",microtime());

	$id_part_1 = substr($usec, 4, 4);
	$id_part_2 = mt_rand(1,9);
	$id_part_3 = substr($sec, 6, 4);
	$digit_one = substr($id_part_1, 0, 1);
	if ($digit_one == 0) {
	$digit_one = mt_rand(1,9);
	$id_part_1 = ereg_replace("^0","",$id_part_1);
	$id_part_1=$digit_one.$id_part_1;
	}
	return $id_part_1.$id_part_2.$id_part_3;
	}


	function getErrorNameByCode($errorCode)
	{
	switch($errorCode)
	{
	case E_USER_ERROR:
	return 'Fatal Error';
	break;

	case E_WARNING:
	case E_USER_WARNING:
	return 'Warning';
	break;

	case E_NOTICE:
	case E_USER_NOTICE:
	return 'Notice';
	break;

	case E_STRICT:
	return 'PHP5 Strict';
	break;

	default:
	return '';
	break;
	}
	}

	/**
	* Generates report
	*
	*/
	function printReport($returnResult = false, $clean_output_buffer = true)
	{
	if($this->reportDone) return '';

	if( dbg_ConstOn('DBG_SKIP_REPORTING') ) return;

	$this->profileFinish('script_runtime');
	if( dbg_ConstOn('DBG_ZEND_PRESENT') ) return;

	dbg_safeDefine('DBG_RAISE_ON_WARNINGS',0);
	dbg_safeDefine('DBG_WINDOW_WIDTH', 700);

	$this->memoryUsage['debugger_start']=memory_get_usage();

	// show php session if any
	$this->appendSession();

	// ensure, that 1st line of debug output always is this one:
	$this->appendHTML('<a href="javascript:toggleDebugLayer(27);">Hide Debugger</a>');
	$this->moveToBegin(1);

	if( dbg_ConstOn('DBG_SQL_PROFILE') && isset($this->ProfilerTotals['sql']) )
	{
	- $this->appendHTML('<b>SQL Total time:</b> '.$this->ProfilerTotals['sql']);
	+ $this->appendHTML('<b>SQL Total time:</b> '.$this->ProfilerTotals['sql'].' Number of queries: '.$this->ProfilerTotalCount['sql']);
	}

	if( dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->appendHTML('<b>Memory used by Objects:</b> '.round($this->ProfilerTotals['objects']/1024, 2).'Kb');
	}

	if( dbg_ConstOn('DBG_INCLUDED_FILES') )
	{
	$files = get_included_files();
	$this->appendHTML('<b>Included files:</b>');
	foreach ($files as $file)
	{
	$this->appendHTML($this->getFileLink($this->getLocalFile($file)).' ('.round(filesize($file)/1024, 2).'Kb)');
	}
	}

	if( dbg_ConstOn('DBG_PROFILE_INCLUDES') )
	{
	$this->appendHTML('<b>Included files statistics:</b>'.( dbg_ConstOn('DBG_SORT_INCLUDES_MEM') ? ' (sorted by memory usage)':''));
	$totals = Array( 'mem' => 0, 'time' => 0);
	$totals_configs = Array( 'mem' => 0, 'time' => 0);
	if ( dbg_ConstOn('DBG_SORT_INCLUDES_MEM') ) {
	array_multisort($this->IncludesData['mem'], SORT_DESC, $this->IncludesData['file'], $this->IncludesData['time'], $this->IncludesData['level']);
	}
	foreach ($this->IncludesData['file'] as $key => $file_name) {
	$this->appendHTML( str_repeat(' -> ', ($this->IncludesData['level'][$key] >= 0 ? $this->IncludesData['level'][$key] : 0)).$file_name.' Mem: '.sprintf("%.4f Kb", $this->IncludesData['mem'][$key]/1024).' Time: '.sprintf("%.4f", $this->IncludesData['time'][$key]));
	if ($this->IncludesData['level'][$key] == 0) {
	$totals['mem'] += $this->IncludesData['mem'][$key];
	$totals['time'] += $this->IncludesData['time'][$key];
	}
	else if ($this->IncludesData['level'][$key] == -1) {
	$totals_configs['mem'] += $this->IncludesData['mem'][$key];
	$totals_configs['time'] += $this->IncludesData['time'][$key];
	}
	}
	$this->appendHTML('<b>Sub-Total classes:</b> '.' Mem: '.sprintf("%.4f Kb", $totals['mem']/1024).' Time: '.sprintf("%.4f", $totals['time']));
	$this->appendHTML('<b>Sub-Total configs:</b> '.' Mem: '.sprintf("%.4f Kb", $totals_configs['mem']/1024).' Time: '.sprintf("%.4f", $totals_configs['time']));
	$this->appendHTML('<span class="error"><b>Grand Total:</b></span> '.' Mem: '.sprintf("%.4f Kb", ($totals['mem']+$totals_configs['mem'])/1024).' Time: '.sprintf("%.4f", $totals['time']+$totals_configs['time']));
	}


	$i = 0; $lineCount = count($this->Data);
	if( !ob_get_length() ) ob_start();
	?>
	<style type="text/css">

	.dbg_flat_table {
	border-collapse: collapse;
	width: auto;
	}

	.dbg_flat_table TD {
	border: 1px solid buttonface;
	padding: 4px;
	}

	.debug_layer_table {
	border-collapse: collapse;
	width: <?php echo DBG_WINDOW_WIDTH - 20; ?>px;
	}

	.debug_text, .debug_row_even TD, .debug_row_odd TD {
	color: #000000;
	font-family: Verdana;
	font-size: 11px;
	word-wrap: break-word;
	}

	.debug_cell {
	border: 1px solid #FF0000;
	padding: 4px;
	word-wrap: break-word;
	text-align: left;
	}

	.debug_row_even {
	background-color: #CCCCFF;
	}

	.debug_row_odd {
	background-color: #FFFFCC;
	}

	.debug_layer_container {
	left: 2px;
	top: 1px;
	width: <?php echo DBG_WINDOW_WIDTH; ?>px;
	z-index: +1000;
	position: absolute;
	overflow: auto;
	border: 2px solid;
	padding: 3px;
	border-top-color: threedlightshadow;
	border-left-color: threedlightshadow;
	border-right-color: threeddarkshadow;
	border-bottom-color: threeddarkshadow;
	background-color: buttonface;
	}

	.debug_layer {
	padding: 0px;
	width: <?php echo DBG_WINDOW_WIDTH - 20; ?>px;
	}

	.debug_error {
	color: #FF0000;
	}
	</style>
	<div id="debug_layer" class="debug_layer_container" style="display: none;">
	<div class="debug_layer">
	<table width="100%" cellpadding="0" cellspacing="1" border="0" class="debug_layer_table">
	<?php
	while ($i < $lineCount)
	{
	echo '<tr class="debug_row_'.(($i % 2) ? 'odd' : 'even').'"><td class="debug_cell">'.$this->prepareHTML($i).'</td></tr>';
	$i++;
	}
	?>
	</table>
	</div>
	</div>
	<script language="javascript">

	function dbg_OpenDOMViewer()
	{
	var $value = document.getElementById('dbg_domviewer').value;
	DOMViewerObj = ($value.indexOf('"') != -1) ? document.getElementById( $value.substring(1,$value.length-1) ) : eval($value);
	window.open('<?php echo constant('DBG_DOMVIEWER'); ?>');
	return false;
	}

	function getEventKeyCode($e)
	{
	var $KeyCode = 0;
	if($e.keyCode) $KeyCode = $e.keyCode;
	else if($e.which) $KeyCode = $e.which;
	return $KeyCode;
	}

	function keyProcessor($e)
	{
	if(!$e) $e = window.event;
	var $KeyCode = getEventKeyCode($e);
	if($KeyCode==123\|\|$KeyCode==27) // F12 or ESC
	{
	toggleDebugLayer($KeyCode);
	$e.cancelBubble = true;
	if($e.stopPropagation) $e.stopPropagation();
	}
	}

	function toggleDebugLayer($KeyCode)
	{
	var $isVisible=false;
	var $DebugLayer = document.getElementById('debug_layer');
	if( typeof($DebugLayer) != 'undefined' )
	{
	$isVisible = ($DebugLayer.style.display == 'none')?false:true;
	if(!$isVisible&&$KeyCode==27) return false;

	resizeDebugLayer(null);
	$DebugLayer.style.display = $isVisible?'none':'block';
	}
	}

	function prepareSizes($Prefix)
	{
	var $ret = '';
	$ret = eval('document.body.'+$Prefix+'Top')+'; ';
	$ret += eval('document.body.'+$Prefix+'Left')+'; ';
	$ret += eval('document.body.'+$Prefix+'Height')+'; ';
	$ret += eval('document.body.'+$Prefix+'Width')+'; ';
	return $ret;
	}

	function resizeDebugLayer($e)
	{
	if(!$e) $e = window.event;
	var $DebugLayer = document.getElementById('debug_layer');
	var $TopMargin = 1;

	var $pageWidth = document.all ? document.body.offsetWidth - 4 : window.innerWidth;
	var $pageHeight = document.all ? document.body.clientHeight : window.innerHeight; // document.body.offsetHeight - 2

	var $pageTop = document.all ? document.body.offsetTop + document.body.scrollTop : window.scrollY;

	if( typeof($DebugLayer) != 'undefined' )
	{
	if(document.all)
	{
	$DebugLayer.style.top = ($pageTop + 2) + 'px';
	$DebugLayer.style.height = ($pageHeight - 2 - 4) + 'px';
	}
	else
	{
	$DebugLayer.style.top = ($pageTop + 2) + 'px';
	$DebugLayer.style.height = ($pageHeight - 2 - 15) + 'px';
	}
	}
	// window.parent.status = 'OFFSET: '+prepareSizes('offset')+' \| SCROLL: '+prepareSizes('scroll')+' \| CLIENT: '+prepareSizes('client');
	// window.parent.status += 'DL Info: '+$DebugLayer.style.top+'; S.AH: '+screen.availHeight;
	return true;
	}

	function SetClipboard(copyText)
	{
	if(window.clipboardData)
	{
	// IE send-to-clipboard method.
	window.clipboardData.setData('Text', copyText);
	}
	else if (window.netscape)
	{
	// You have to sign the code to enable this or allow the action in about:config by changing user_pref("signed.applets.codebase_principal_support", true);
	netscape.security.PrivilegeManager.enablePrivilege('UniversalXPConnect');

	// Store support string in an object.
	var str = Components.classes["@mozilla.org/supports-string;1"].createInstance(Components.interfaces.nsISupportsString);
	if (!str) return false;
	str.data=copyText;

	// Make transferable.
	var trans = Components.classes["@mozilla.org/widget/transferable;1"].createInstance(Components.interfaces.nsITransferable);
	if (!trans) return false;

	// Specify what datatypes we want to obtain, which is text in this case.
	trans.addDataFlavor("text/unicode");
	trans.setTransferData("text/unicode",str,copyText.length*2);

	var clipid=Components.interfaces.nsIClipboard;
	var clip = Components.classes["@mozilla.org/widget/clipboard;1"].getService(clipid);
	if (!clip) return false;

	clip.setData(trans,null,clipid.kGlobalClipboard);
	}

	}

	function showProps($Obj, $Name)
	{
	var $ret = '';
	for($Prop in $Obj)
	{
	$ret += $Name+'.'+$Prop+' = '+$Obj[$Prop]+"\n";
	}
	return $ret;
	}

	function editFile($fileName,$lineNo)
	{
	if(!document.all)
	{
	alert('Only works in IE');
	return;
	}

	var $editorPath = '<?php echo defined('WINDOWS_EDITOR') ? addslashes(WINDOWS_EDITOR) : '' ?>';
	if($editorPath)
	{
	var $obj = new ActiveXObject("LaunchinIE.Launch");
	$editorPath = $editorPath.replace('%F',$fileName);
	$editorPath = $editorPath.replace('%L',$lineNo);
	$obj.LaunchApplication($editorPath);
	}
	else
	{
	alert('Editor path not defined!');
	}
	}

	function toggleTraceArgs($ArgsLayerID)
	{
	var $ArgsLayer = document.getElementById($ArgsLayerID);
	$ArgsLayer.style.display = ($ArgsLayer.style.display == 'none') ? 'block' : 'none';
	}


	document.onkeydown = keyProcessor;
	window.onresize = resizeDebugLayer;
	window.onscroll = resizeDebugLayer;
	window.focus();
	if( typeof($isFatalError) != 'undefined' && $isFatalError == 1 \|\| <?php echo DBG_RAISE_ON_WARNINGS; ?> )
	{
	toggleDebugLayer();
	}
	if( typeof($isFatalError) != 'undefined' && $isFatalError == 1)
	{
	document.getElementById('debug_layer').scrollTop = 10000000;
	}
	</script>
	<?php

	dbg_safeDefine('DBG_SHOW_MEMORY_USAGE', 1);
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') )
	{
	$this->memoryUsage['debugger_finish']=memory_get_usage();
	$this->memoryUsage['print_report']=$this->memoryUsage['debugger_finish']-$this->memoryUsage['debugger_start'];
	$this->memoryUsage['total']=$this->memoryUsage['print_report']+$this->memoryUsage['error_handling'];
	$this->memoryUsage['application']=memory_get_usage()-$this->memoryUsage['total'];
	}

	if($returnResult)
	{
	$ret = ob_get_contents();
	if($clean_output_buffer) ob_clean();
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) $ret .= $this->getMemoryUsageReport();
	$this->reportDone = true;
	return $ret;
	}
	else
	{
	if( !dbg_ConstOn('DBG_HIDE_FULL_REPORT') )
	{
	ob_end_flush();
	}
	else
	{
	if($clean_output_buffer) ob_clean();
	}
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) echo $this->getMemoryUsageReport();
	$this->reportDone = true;
	}
	}

	/**
	* Format's memory usage report by debugger
	*
	* @return string
	* @access private
	*/
	function getMemoryUsageReport()
	{
	if( !dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) return '';

	$info = Array('<a href="javascript:self.location.reload()">printReport</a>'=>'print_report',
	'saveError'=>'error_handling',
	'Total'=>'total',
	'Application'=>'application');
	$ret=Array();
	foreach($info as $title => $value_key)
	{
	$ret[]='<tr><td>'.$title.':</td><td><b>'.$this->formatSize($this->memoryUsage[$value_key]).'</b></td></tr>';
	}
	return '<table class="dbg_flat_table">'.implode('',$ret).'</table>';
	}


	/**
	* User-defined error handler
	*
	* @param int $errno
	* @param string $errstr
	* @param string $errfile
	* @param int $errline
	* @param array $errcontext
	*/
	function saveError($errno, $errstr, $errfile = '', $errline = '', $errcontext = '')
	{
	$memory_used=Array();
	$memory_used['begin']=memory_get_usage();

	$errorType = $this->getErrorNameByCode($errno);
	if(!$errorType)
	{
	trigger_error('Unknown error type ['.$errno.']', E_USER_ERROR);
	return false;
	}

	if( dbg_ConstOn('DBG_IGNORE_STRICT_ERRORS') && defined('E_STRICT') && ($errno == E_STRICT) ) return;

	$long_id_pos=strrpos($errstr,'#');
	if($long_id_pos!==false)
	{
	// replace short message with long one (due triger_error limitations on message size)
	$long_id=substr($errstr,$long_id_pos+1,strlen($errstr));
	$errstr=$this->longErrors[$long_id];
	unset($this->longErrors[$long_id]);
	}


	/*in /www/kostja/in-commerce4/kernel/kernel4/parser/construct_tags.php(177) : runtime-created function on line

	[PRE-PARSED block, $line 13]: Undefined variable: IdField*/
	/*
	if( strpos($errfile,'runtime-created') !== false ) {
	$errfile = ' PRE-PARSED block <b>'.$this->CurrentPreParsedBlock.'</b> ';
	}*/

	if( strpos($errfile,'eval()\'d code') !== false )
	{
	$errstr = '[<b>EVAL</b>, line <b>'.$errline.'</b>]: '.$errstr;
	$tmpStr = $errfile;
	$pos = strpos($tmpStr,'(');
	$errfile = substr($tmpStr,0,$pos);
	$pos++;
	$errline = substr($tmpStr,$pos,strpos($tmpStr,')',$pos)-$pos);
	}
	// if($this->TraceNextError \|\| $errno == E_USER_ERROR)
	if($this->TraceNextError)
	{
	$this->appendTrace();
	$this->TraceNextError=false;
	}
	$this->Data[] = Array('no' => $errno, 'str' => $errstr, 'file' => $errfile, 'line' => $errline, 'context' => $errcontext, 'debug_type' => 'error');
	$memory_used['end']=memory_get_usage();
	$this->memoryUsage['error_handling']+=$memory_used['end']-$memory_used['begin'];
	if( substr($errorType,0,5) == 'Fatal')
	{
	echo '<script language="javascript">var $isFatalError = 1;</script>';
	if( !dbg_ConstOn('DBG_USE_SHUTDOWN_FUNC') ) $this->printReport();
	exit;
	}
	}

	function saveToFile($msg)
	{
	$fp = fopen($_SERVER['DOCUMENT_ROOT'].'/vb_debug.txt', 'a');
	fwrite($fp,$msg."\n");
	fclose($fp);
	}

	/**
	* Formats file/memory size in nice way
	*
	* @param int $bytes
	* @return string
	* @access public
	*/
	function formatSize($bytes)
	{
	if ($bytes >= 1099511627776) {
	$return = round($bytes / 1024 / 1024 / 1024 / 1024, 2);
	$suffix = "TB";
	} elseif ($bytes >= 1073741824) {
	$return = round($bytes / 1024 / 1024 / 1024, 2);
	$suffix = "GB";
	} elseif ($bytes >= 1048576) {
	$return = round($bytes / 1024 / 1024, 2);
	$suffix = "MB";
	} elseif ($bytes >= 1024) {
	$return = round($bytes / 1024, 2);
	$suffix = "KB";
	} else {
	$return = $bytes;
	$suffix = "Byte";
	}
	$return .= ' '.$suffix;
	return $return;
	}

	}

	if( !function_exists('memory_get_usage') )
	{
	function memory_get_usage(){ return -1; }
	}

	+ if( !dbg_ConstOn('DBG_ZEND_PRESENT') )
	+ {
	$debugger = new Debugger();
	+ }

	if( dbg_ConstOn('DBG_HANDLE_ERRORS') )
	{
	if( class_exists('kApplication') )
	{
	$application =& kApplication::Instance();
	$application->Debugger =& $debugger;
	$application->errorHandlers[] = Array(&$debugger, 'saveError');
	}
	else
	{
	set_error_handler( Array(&$debugger, 'saveError') );
	}
	}

	if( dbg_ConstOn('DBG_USE_SHUTDOWN_FUNC') ) register_shutdown_function( Array(&$debugger, 'printReport') );
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/include/debugger.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.47
	\ No newline at end of property
	+1.48
	\ No newline at end of property
	Index: trunk/kernel/admin/include/toolbar/browse.php
	===================================================================
	--- trunk/kernel/admin/include/toolbar/browse.php (revision 3647)
	+++ trunk/kernel/admin/include/toolbar/browse.php (revision 3648)
	@@ -1,935 +1,938 @@
	<?php
	global $objConfig,$objSections,$section, $rootURL,$adminURL, $admin, $imagesURL,$envar,
	$m_var_list_update,$objCatList, $homeURL, $upURL, $objSession,$CatScopeClause,$DefaultTab;

	global $CategoryFilter,$TotalItemCount;

	global $Bit_All,$Bit_Pending,$Bit_Disabled,$Bit_New,$Bit_Pop,$Bit_Hot,$Bit_Ed;

	global $hideSelectAll;

	/* bit place holders for category view menu */
	$Bit_Active=64;
	$Bit_Pending=32;
	$Bit_Disabled=16;
	$Bit_New=8;
	$Bit_Pop=4;
	$Bit_Hot=2;
	$Bit_Ed=1;

	if( isset($_GET['SetTab']) )
	{
	if($_GET["SetTab"] != "categories")
	{
	$m_tab_CatTab_Hide = 1;
	$DefaultTab = $_GET["SetTab"];
	}
	else
	{
	$DefaultTab="categories";
	$m_tab_CatTab_Hide = 0;
	}
	}
	else
	$m_tab_CatTab_Hide = (int)$objConfig->Get("CatTab_Hide");

	$CategoryView = $objConfig->Get("Category_View");
	if(!is_numeric($CategoryView))
	{
	$CategoryView = 127;
	}

	$Category_Sortfield = $objConfig->Get("Category_Sortfield");
	if(!strlen($Category_Sortfield))
	$Category_Sortfield = "Name";

	$Category_Sortorder = $objConfig->Get("Category_Sortorder");
	if(!strlen($Category_Sortorder))
	$Category_Sortorder = "desc";

	$Perpage_Category = (int)$objConfig->Get("Perpage_Category");
	if(!$Perpage_Category)
	$Perpage_Category="'all'";


	if($CategoryView == 127)
	{
	$Category_ShowAll = 1;
	}
	else
	{
	$Category_ShowAll=0;
	$Status = array();
	$Mod = array();
	if($CategoryView & $Bit_Pending)
	$Status[] = STATUS_PENDING;

	if($CategoryView & $Bit_Active)
	$Status[] = STATUS_ACTIVE;


	if($CategoryView & $Bit_Disabled)
	$Status[] = STATUS_DISABLED;

	if(count($Status))
	{
	$CategoryFilter .= " AND (Status IN (".implode(",",$Status).") ";
	}
	else
	$CategoryFilter .= " AND ((Status=-1) ";

	if($CategoryView & $Bit_Ed)
	{
	$CategoryFilter .= " OR (EditorsPick=1) ";
	}

	if($CategoryView & $Bit_New)
	{
	$cutoff = adodb_date("U") - ($objConfig->Get("Category_DaysNew") * 86400);
	$CategoryFilter .= " OR (CreatedOn > ".$cutoff.") ";
	}
	$CategoryFilter .= ")";
	}

	$list = $objSession->GetVariable("SearchWord");
	if(strlen($list))
	{
	$CatScope = $objSession->GetVariable("SearchScope");
	switch($CatScope)
	{
	case 0 :
	$CatScopeClause = "";
	break;
	case 1:
	$cat = $objCatList->CurrentCategoryID();
	if($cat>0)
	{
	$allcats = $objCatList->AllSubCats($cat);
	if(count($allcats)>0)
	{
	$catlist = implode(",",$allcats);
	$CatScopeClause = " CategoryId IN ($catlist) ";
	}
	}
	break;
	case 2:
	$CatScopeClause = "CategoryId=".$objCatList->CurrentCategoryID();
	break;
	}
	}
	else
	$CatScopeClause="";

	$Cat_Paste = "false";
	if($objCatList->ItemsOnClipboard()>0)
	$Cat_Paste = "true";

	$CurrentCat = $objCatList->CurrentCategoryID();
	if($CurrentCat>0)
	{
	$c = $objCatList->GetItem($CurrentCat);
	$CurrentRes = (int)$c->Get("ResourceId");
	}
	else
	$CurrentRes =0;
	$mnuClearSearch = language("la_SearchMenu_Clear");
	$mnuNewSearch = language("la_SearchMenu_New");
	$mnuSearchCategory = language("la_SearchMenu_Categories");

	$lang_New = language("la_Text_New");
	$lang_Hot = language("la_Text_Hot");
	$lang_EdPick = language("la_prompt_EditorsPick");
	$lang_Pop = language("la_Text_Pop");

	$lang_Rating = language("la_prompt_Rating");
	$lang_Hits = language("la_prompt_Hits");
	$lang_Votes = language("la_prompt_Votes");
	$lang_Name = language("la_prompt_Name");

	$lang_Categories = language("la_ItemTab_Categories");
	$lang_Description = language("la_prompt_Description");
	$lang_MetaKeywords = language("la_prompt_MetaKeywords");
	$lang_SubSearch = language("la_prompt_SubSearch");
	$lang_Within = language("la_Text_Within");
	$lang_Current = language("la_Text_Current");
	$lang_Active = language("la_Text_Active");
	$lang_SubCats = language("la_Text_SubCats");
	$lang_SubItems = language("la_Text_Subitems");

	// View, Sort, Select, Per Page
	$lang_View = language('la_Text_View');
	$lang_Sort = language('la_Text_Sort');
	$lang_PerPage = language('la_prompt_PerPage');
	$lang_Select = language('la_Text_Select');

	print <<<END

	<script language="JavaScript">
	// global usage phrases
	var lang_View = '$lang_View';
	var lang_Sort = '$lang_Sort';
	var lang_PerPage = '$lang_PerPage';
	var lang_Select = '$lang_Select';

	// local usage phrases
	var Category_Sortfield = '$Category_Sortfield';
	var Category_Sortorder = '$Category_Sortorder';
	var Category_Perpage = $Perpage_Category;
	var Category_ShowAll = $Category_ShowAll;
	var CategoryView = $CategoryView;
	var default_tab = "$DefaultTab";
	var Categories_Paste = $Cat_Paste;
	var CurrentCat = $CurrentCat;
	var CurrentRes = $CurrentRes;

	PasteButton = PasteButton \|\| Categories_Paste;

	//JS Language variables
	var lang_New = "$lang_New";
	var lang_Hot = "$lang_Hot";
	var lang_EdPick = "$lang_EdPick";

	var lang_Pop = "$lang_Pop";
	var lang_Rating = "$lang_Rating";
	var lang_Hits = "$lang_Hits";
	var lang_Votes = "$lang_Votes";
	var lang_Name = "$lang_Name";
	var lang_Categories = "$lang_Categories";
	var lang_Description = "$lang_Description";
	var lang_MetaKeywords = "$lang_MetaKeywords";
	var lang_SubSearch = "$lang_SubSearch";
	var lang_Within="$lang_Within";
	var lang_Current = "$lang_Current";
	var lang_Active = "$lang_Active";
	var lang_SubCats = "$lang_SubCats";
	var lang_SubItems = "$lang_SubItems";


	var m_tab_CatTab_hide = $m_tab_CatTab_Hide;
	var hostname = '$rootURL';
	var env = '$envar';
	var actionlist = new Array();
	var homeURL = "$homeURL";
	var upURL = "$upURL";


	// K4 code for handling toolbar operations: begin
	var \$TabRegistry = Array();

	function InpGrid(tab)
	{
	this.TabId = tab;
	}

	InpGrid.prototype.ClearSelection = function(force,called_from)
	{
	unselectAll(this.TabId, 1); //1 means don't upate toolbar
	}

	function registerTab(\$tab_id)
	{
	var \$tab = document.getElementById(\$tab_id);
	var \$index = \$TabRegistry.length;

	\$TabRegistry[\$index] = new Array();
	\$TabRegistry[\$index]['tab_id'] = \$tab_id;
	\$TabRegistry[\$index]['prefix_special'] = \$tab.getAttribute('PrefixSpecial');
	\$TabRegistry[\$index]['edit_template'] = \$tab.getAttribute('EditURL');
	}

	function queryTabRegistry(\$search_key, \$search_value, \$return_key)
	{
	var \$i = 0;
	while(\$i < \$TabRegistry.length)
	{
	if(\$TabRegistry[\$i][\$search_key] == \$search_value)
	{
	return \$TabRegistry[\$i][\$return_key];
	break;
	}
	\$i++;
	}
	return '<'+\$search_key+'='+\$search_value+'>';
	}

	function k4_actionHandler(action, prefix_special)
	{
	var k4_action = '';
	switch (action)
	{
	case 'edit':
	k4_action = 'edit_item("'+prefix_special+'")';
	break;
	case 'delete':
	k4_action = 'delete_items("'+prefix_special+'")';
	break;
	case 'unselect':
	k4_action = 'unselect("'+prefix_special+'")';
	break;

	case 'approve':
	k4_action = 'approve_items("'+prefix_special+'")';
	break;
	case 'decline':
	k4_action = 'decine_items("'+prefix_special+'")';
	break;

	case 'm_rebuild_cache':
	k4_action = 'rebuild_cache("c")';
	break;

	- case 'import':
	- k4_action = 'import_items("'+prefix_special+'")';
	- break;
	+// case 'import':
	+// k4_action = 'import_items("'+prefix_special+'")';
	+// break;

	case 'export':
	k4_action = 'export_items("'+prefix_special+'")';
	break;

	case 'copy':
	k4_action = 'copy_items("'+prefix_special+'")';
	break;
	case 'cut':
	k4_action = 'cut_items("'+prefix_special+'")';
	break;

	case 'move_up':
	k4_action = 'move_up("'+prefix_special+'")';
	break;
	case 'move_down':
	k4_action = 'move_down("'+prefix_special+'")';
	break;
	}

	if (k4_action != '')
	{
	\$form_prefix = queryTabRegistry('prefix_special', prefix_special, 'tab_id');
	eval(k4_action);
	}
	else alert(action+' not implemented');

	}

	function approve_items(prefix_special)
	{
	set_hidden_field('remove_specials['+prefix_special+']',1);
	submit_event(prefix_special,'OnMassApprove','')
	}

	function decine_items(prefix_special)
	{
	set_hidden_field('remove_specials['+prefix_special+']',1);
	submit_event(prefix_special,'OnMassDecline','')
	}

	- function import_items(prefix_special)
	- {
	- set_hidden_field('remove_specials['+prefix_special+']',1);
	- submit_event(prefix_special,'OnImport','')
	- }
	+// function import_items(prefix_special)
	+// {
	+// set_hidden_field('remove_specials['+prefix_special+']',1);
	+// submit_event(prefix_special,'OnImport','')
	+// }

	function export_items(prefix_special)
	{
	set_hidden_field('remove_specials['+prefix_special+']',1);
	submit_event(prefix_special,'OnExport','')
	}

	function edit()
	{
	edit_item( queryTabRegistry('tab_id', activeTab.id, 'prefix_special') );
	}

	function edit_item(prefix_special)
	{
	opener_action('d');
	set_hidden_field(prefix_special+'_mode', 't');
	submit_event(prefix_special, 'OnEdit', queryTabRegistry('prefix_special', prefix_special, 'edit_template'), '../../admin/index4.php');
	}

	function delete_items(prefix_special)
	{
	set_hidden_field('remove_specials['+prefix_special+']',1);
	submit_event(prefix_special,'OnMassDelete','')
	}

	function copy_items(prefix_special)
	{
	submit_event(prefix_special,'OnCopy','')
	}

	function cut_items(prefix_special)
	{
	submit_event(prefix_special,'OnCut','')
	}

	function move_up(prefix_special)
	{
	submit_event(prefix_special,'OnMassMoveUp','')
	}

	function move_down(prefix_special)
	{
	submit_event(prefix_special,'OnMassMoveDown','')
	}

	function unselect(prefix_special)
	{
	Grids[prefix_special].ClearSelection(null,'Inp_AdvancedView.Unselect');
	}

	function rebuild_cache(prefix_special)
	{
	submit_event(prefix_special,'OnRebuildCache','')
	}
	// K4 code for handling toolbar operations: end



	function InitPage()
	{
	addCommonActions();
	initToolbar('mainToolBar', actionHandler);
	initCheckBoxes();
	//toggleMenu();
	}

	function AddButtonAction(action_name,action_value)
	{
	actionlist[actionlist.length] = new Array(action_name, action_value);
	}

	function actionHandler(button)
	{
	// alert('a button has been pressed!');
	for(i=0; i<actionlist.length;i++)
	{

	a = actionlist[i];
	if(button.action==a[0])
	{
	// alert('Button action '+a[0]+' is '+a[1]);
	eval(a[1]);
	break;
	}
	}
	}

	function addCommonActions()
	{
	AddButtonAction('upcat',"get_to_server(upURL,'');");// UP
	AddButtonAction('homecat',"get_to_server(homeURL,'');"); //home
	AddButtonAction('new_cat',"get_to_server('$adminURL/category/addcategory.php',env+'&new=1');"); //new cat
	AddButtonAction('editcat',"edit_current(); "); //edit current
	AddButtonAction('edit',"check_submit('','edit');"); //edit
	AddButtonAction('delete',"check_submit('$admin/browse','delete');"); //delete
	AddButtonAction('approve',"check_submit('$admin/browse','approve');"); //approve
	AddButtonAction('decline',"check_submit('$admin/browse','decline');"); //decline

	- AddButtonAction('import',"check_submit('$admin/browse','import');"); // import
	+// AddButtonAction('import',"check_submit('$admin/browse','import');"); // import
	AddButtonAction('export',"check_submit('$admin/browse','export');"); // export

	AddButtonAction('rebuild_cache',"check_submit('$admin/category/category_maint', 'm_rebuild_cache');"); // rebuild_cache

	AddButtonAction('cut',"check_submit('$admin/browse','cut');"); //cut
	AddButtonAction('copy',"check_submit('$admin/browse','copy');"); //copy
	AddButtonAction('paste',"get_to_server('$adminURL/browse.php',env+'&Action=m_paste');"); //paste
	AddButtonAction('move_up',"check_submit('$admin/browse','move_up');"); //up
	AddButtonAction('move_down',"check_submit('$admin/browse','move_down');"); //down
	AddButtonAction('print',"window.print();"); //print ?
	AddButtonAction('view',"toggleMenu(); window.FW_showMenu(window.cat_menu,getRealLeft(button) - ((document.all) ? 6 : -2),getRealTop(button)+32);");
	AddButtonAction('search_a',"setSearchMenu(); window.FW_showMenu(window.SearchMenu,getRealLeft(button)-134 - ((document.all) ? 8 : -1),getRealTop(button)+22);");
	AddButtonAction('search_b',"search_submit();");
	AddButtonAction('search_c',"new_search_submit();");
	}

	function AdminCatNav(url)
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	f.action = url;
	new_search_submit();
	}
	}

	function search_submit()
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	//alert('Setting SearchWord to ' + f.value);
	f.Action.value = "m_SearchWord";
	f.submit();
	}
	}
	function new_search_submit()
	{
	var newSearchInput = document.getElementById("NewSearch");
	if (newSearchInput) newSearchInput.value = 1;
	search_submit();
	}

	function ClearSearch()
	{
	//alert('Clearing Search');
	f = document.getElementById("admin_search");
	if(f)
	{
	f.Action.value = "m_ClearSearch";
	f.submit();
	}
	}

	function SetSearchType(value)
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	f.SearchType.value = value;
	}
	}

	function SetSearchScope(value)
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	f.SearchScope.value = value;
	}
	}

	function ToggleNewSearch()
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	value = f.NewSearch.value;
	if(value==1)
	{
	f.NewSearch.value=0;
	}
	else
	f.NewSearch.value=1;
	}
	}
	function isNewSearch()
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	return f.NewSearch.value;
	}
	else return 0;
	}


	function get_to_server(path,attr)
	{
	if(attr.length>0)
	path = path + '?'+attr;

	window.location.href=path;
	return true;
	}

	function check_submit(page, actionValue)
	{
	if (actionValue.match(/delete$/))
	{
	if (!theMainScript.Confirm(lang_DeleteConfirm)) return;
	}

	var formname = '';
	var action_prefix ='';

	var isCatImportExport = activeTab && isAnyChecked('categories') && (actionValue == 'import' \|\| actionValue == 'export');

	- if (activeTab && (!isAnyChecked('categories') \|\| isCatImportExport))
	+ // skip news & topics for export operations (not to raise js errors)
	+ var allowProcessing = (activeTab.getAttribute("PrefixSpecial") != 'n' && activeTab.getAttribute("PrefixSpecial") != 'bb');
	+
	+ if (allowProcessing && activeTab && (!isAnyChecked('categories') \|\| isCatImportExport))
	{
	form_name = activeTab.id;
	action_prefix = activeTab.getAttribute("ActionPrefix");
	if (page.length == 0) page = activeTab.getAttribute("EditURL");

	if (actionValue == 'export') {
	save_selected_categories('export_categories');
	}

	if ( action_prefix.match("k4:(.*)") )
	{
	act = RegExp.$1;
	act = act.replace('$\$event$$', actionValue);
	act = act.replace('$\$prefix$$', activeTab.getAttribute("PrefixSpecial") );
	eval(act);
	return;
	}
	- else if(actionValue == 'export' \|\| actionValue == 'import')
	+ else if(actionValue == 'export') // \|\| actionValue == 'import'
	{
	return k4_actionHandler(actionValue, activeTab.getAttribute("PrefixSpecial"));
	}
	}
	else
	{
	form_name = 'categories';
	action_prefix = 'm_cat_';
	if (page.length == 0) page = "$admin" + '/category/addcategory';
	}

	var f = document.getElementsByName(form_name+'_form')[0];
	if(f)
	{
	if (actionValue.substring(0,2) == 'm_')
	{
	f.Action.value = actionValue;
	}
	else
	{
	f.Action.value = action_prefix + actionValue;
	}

	f.action = '$rootURL' + page + '.php?'+ env;
	// alert(f.name+ ' is submitting to '+ f.action + ' action=' + f.Action.value);
	f.submit();
	}
	} // check submit

	function save_selected_categories(field_name)
	{
	var result = '';
	var checkboxes = document.getElementsByName('catlist[]');

	for (var i = 0; i < checkboxes.length; i++)
	{
	if (checkboxes[i].checked == true)
	{
	result += checkboxes[i].value + ',';
	}
	}
	result = result.replace(/(.*),\$/, '\$1');
	if (activeTab) \$form_prefix = activeTab.id;
	set_hidden_field(field_name, result);
	}

	function edit_current()
	{
	if(CurrentCat==0)
	{
	get_to_server('$adminURL/category/addcategory_permissions.php',env+'&item=0');
	}
	else
	get_to_server('$adminURL/category/addcategory.php',env+'&item=$CurrentRes');
	}

	function flip_current(field_suffix)
	{
	if(activeTab)
	{
	field = activeTab.getAttribute("tabTitle")+field_suffix;
	return flip(eval(field));
	}
	}

	function config_current(field_suffix,value)
	{
	if(activeTab)
	{
	field = activeTab.getAttribute("tabTitle")+field_suffix;
	config_val(field,value);
	}
	}

	function getSType(type,value)
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	if (f.SearchType.value == type) return 2; else return 0;
	} else return 0;

	}

	function getSScope(scope)
	{
	f = document.getElementById("admin_search");
	if(f)
	{
	if (f.SearchScope.value == scope) return 2; else return 0;
	} else return 0;

	}

	function setSearchMenu()
	{

	window.SearchMenu = new Menu("search");
	SearchMenu.addMenuItem(lang_All,"SetSearchType('all');",getSType('all'));
	SearchMenu.addMenuSeparator()

	SearchMenu.addMenuItem(lang_Categories, "SetSearchType('categories');",getSType('categories'));
	param = "";

	for (var i = 0; i < tabIDs.length; i++)
	{
	d = document.getElementById(tabIDs[i]);
	if(d)
	{
	tabname = d.getAttribute("tabTitle");
	param = "SetSearchType('"+tabname+"');";

	SearchMenu.addMenuItem(tabname,param,getSType(tabname));
	}
	}

	SearchMenu.addMenuSeparator();
	SearchMenu.addMenuItem(lang_All+' '+lang_Categories,"SetSearchScope('0');",getSScope(0));
	SearchMenu.addMenuItem(lang_SubSearch,"ToggleNewSearch();",isNewSearch());
	SearchMenu.addMenuItem(lang_Current+' '+lang_Categories,"SetSearchScope('2');",getSScope(2));
	SearchMenu.addMenuItem(lang_Within+' '+lang_Categories,"SetSearchScope('1');",getSScope(1));

	SearchMenu.addMenuSeparator();

	window.SearchMenu.addMenuItem('$mnuClearSearch',"ClearSearch();","");
	window.triedToWriteMenus = false;
	window.SearchMenu.writeMenus();
	}

	\$fw_menus['c_view_menu'] = function()
	{
	// filtering menu
	\$Menus['c_filtring_menu'] = new Menu(lang_View);
	\$Menus['c_filtring_menu'].addMenuItem(lang_All,"config_val('Category_View', 127);",CategoryView==127);
	\$Menus['c_filtring_menu'].addMenuSeparator();
	\$Menus['c_filtring_menu'].addMenuItem(lang_Active,"FlipBit('Category_View',CategoryView,6);",BitStatus(CategoryView,6));
	\$Menus['c_filtring_menu'].addMenuItem(lang_Pending,"FlipBit('Category_View',CategoryView,5);", BitStatus(CategoryView,5));
	\$Menus['c_filtring_menu'].addMenuItem(lang_Disabled,"FlipBit('Category_View',CategoryView,4);",BitStatus(CategoryView,4));
	\$Menus['c_filtring_menu'].addMenuSeparator();
	\$Menus['c_filtring_menu'].addMenuItem(lang_New,"FlipBit('Category_View',CategoryView,3);",BitStatus(CategoryView,3));
	\$Menus['c_filtring_menu'].addMenuItem(lang_EdPick,"FlipBit('Category_View',CategoryView,0);",BitStatus(CategoryView,0));

	// sorting menu
	\$Menus['c_sorting_menu'] = new Menu(lang_Sort);
	\$Menus['c_sorting_menu'].addMenuItem(lang_Asc,"config_val('Category_Sortorder','asc');",RadioIsSelected(Category_Sortorder,'asc'));
	\$Menus['c_sorting_menu'].addMenuItem(lang_Desc,"config_val('Category_Sortorder','desc');",RadioIsSelected(Category_Sortorder,'desc'));
	\$Menus['c_sorting_menu'].addMenuSeparator();
	\$Menus['c_sorting_menu'].addMenuItem(lang_Default,"config_val('Category_Sortfield','Name');","");
	\$Menus['c_sorting_menu'].addMenuItem(lang_Name,"config_val('Category_Sortfield','Name');",RadioIsSelected(Category_Sortfield,'Name'));
	\$Menus['c_sorting_menu'].addMenuItem(lang_Description,"config_val('Category_Sortfield','Description');",RadioIsSelected(Category_Sortfield,'Description'));
	\$Menus['c_sorting_menu'].addMenuItem(lang_CreatedOn,"config_val('Category_Sortfield','CreatedOn');",RadioIsSelected(Category_Sortfield,'CreatedOn'));
	\$Menus['c_sorting_menu'].addMenuItem(lang_SubCats,"config_val('Category_Sortfield','CachedDescendantCatsQty');",RadioIsSelected(Category_Sortfield,'CachedDescendantCatsQty'));

	// perpage menu

	// select menu
	\$Menus['c_select_menu'] = new Menu(lang_Select);
	\$Menus['c_select_menu'].addMenuItem(lang_All,"javascript:selectAllC('categories');","");
	\$Menus['c_select_menu'].addMenuItem(lang_Unselect,"javascript:unselectAll('categories');","");
	\$Menus['c_select_menu'].addMenuItem(lang_Invert,"javascript:invert('categories');","");

	// view menu
	\$Menus['c_view_menu'] = new Menu(lang_Categories);
	\$Menus['c_view_menu'].addMenuItem( \$Menus['c_filtring_menu'] );
	\$Menus['c_view_menu'].addMenuItem( \$Menus['c_sorting_menu'] );
	\$Menus['c_view_menu'].addMenuItem( \$Menus['c_select_menu'] );
	}

	function toggleMenu()
	{
	var \$ViewMenus = new Array();

	// prepare categories menu
	if (document.getElementById('categories').active)
	{
	\$fw_menus['c_view_menu']();
	\$ViewMenus.push('c');
	}

	if (activeTab)
	{
	var prefix_special = activeTab.getAttribute('PrefixSpecial');
	\$fw_menus[prefix_special+'_view_menu']();
	\$ViewMenus.push(prefix_special);
	}

	if(\$ViewMenus.length == 1)
	{
	prefix_special = \$ViewMenus[\$ViewMenus.length-1];
	window.cat_menu = \$Menus[prefix_special+'_view_menu'];
	}
	else
	{
	window.cat_menu = new Menu('ViewMenu_mixed');

	// merge menus into new one
	for(var i in \$ViewMenus)
	{
	prefix_special = \$ViewMenus[i];
	window.cat_menu.addMenuItem( \$Menus[prefix_special+'_view_menu'] );
	}
	}

	window.triedToWriteMenus = false;
	window.cat_menu.writeMenus();
	}

	function toggleCategoriesA(tabHeader, instant)
	{
	var categories = document.getElementById('categories');
	if (!categories) return;
	toggleCategories(instant);

	tabHeader.setAttribute("background", '$imagesURL'+'/itemtabs/' + ((categories.active) ? "tab_active" : "tab_inactive") + ".gif")
	var images = tabHeader.getElementsByTagName("IMG");
	if (images.length < 1) return;
	images[0].src = '$imagesURL'+'/itemtabs/' + ((categories.active) ? "divider_up" : "divider_dn") + ".gif";
	}

	function toggleCategoriesB(tabHeader, instant)
	{
	var categories = document.getElementById('categories');
	if (!categories) return;
	toggleCategories(instant);
	var active_str = '$imagesURL'+'/itemtabs/' + (categories.active ? 'tab_active' : 'tab_inactive');
	SetBackground('l_cat', active_str + '_l.gif');
	SetBackground('m_cat', active_str + '.gif');
	SetBackground('m1_cat', active_str + '.gif');
	SetBackground('r_cat', active_str + '_r.gif');

	var images = tabHeader.getElementsByTagName("IMG");
	if (images.length < 1) return;
	images[0].src = '$imagesURL'+'/itemtabs/' + ((categories.active) ? "divider_up" : "divider_dn") + ".gif";
	}

	function toggleTabA(tabId, atm)
	{
	var hl = document.getElementById("hidden_line");
	var activeTabId;


	if (activeTab) activeTabId = activeTab.id;
	if (activeTabId == tabId)
	{
	var devider = document.getElementById("tabsDevider");
	devider.style.display = "";

	unselectAll(tabId);
	var tab = document.getElementById(tabId);
	tab.active = false;
	activeTab = null;
	collapseTab = tab;
	toolbar.setTab(null);
	showTab();
	}

	else
	{
	if (activeTab) toggleTab(tabId, true)
	else toggleTab(tabId, atm)

	if (hl) hl.style.display = "none";
	}
	tab_hdr = document.getElementById('tab_headers');
	if (!tab_hdr) return;
	for (var i = 0; i < tabIDs.length; i++)
	{
	var tabHeader;
	TDs = tab_hdr.getElementsByTagName("TD");
	for (var j = 0; j < TDs.length; j++)
	if (TDs[j].getAttribute("tabHeaderOf") == tabIDs[i])
	{
	tabHeader = TDs[j];
	break;
	}
	if (!tabHeader) continue;

	var tab = document.getElementById(tabIDs[i]);
	if (!tab) continue;

	tabHeader.setAttribute("background", "$imagesURL/itemtabs/" + ((tab.active) ? "tab_active" : "tab_inactive") + ".gif")

	var images = tabHeader.getElementsByTagName("IMG");
	if (images.length < 1) continue;

	images[0].src = "$imagesURL/itemtabs/" + ((tab.active) ? "divider_up" : "divider_dn") + ".gif";
	}
	}

	function toggleTabB(tabId, atm)
	{
	var hl = document.getElementById("hidden_line");
	var activeTabId;

	if (activeTab) activeTabId = activeTab.id;
	if (activeTabId == tabId)
	{
	var devider = document.getElementById("tabsDevider");
	devider.style.display = "";

	unselectAll(tabId);
	var tab = document.getElementById(tabId);
	tab.active = false;
	activeTab = null;
	collapseTab = tab;
	toolbar.setTab(null);
	showTab();
	}
	else
	{
	if (activeTab)
	toggleTab(tabId, true)
	else
	toggleTab(tabId, atm)
	if (hl) hl.style.display = "none";
	}
	tab_hdr = document.getElementById('tab_headers');
	if (!tab_hdr) return;

	// process all module tabs
	var active_str = '';
	for(var i = 0; i < tabIDs.length; i++)
	{
	var tabHeader;
	TDs = tab_hdr.getElementsByTagName("TD");
	for (var j = 0; j < TDs.length; j++)
	if (TDs[j].getAttribute("tabHeaderOf") == tabIDs[i])
	{
	tabHeader = TDs[j];
	break;
	}
	if (!tabHeader) continue;

	var tab = document.getElementById(tabIDs[i]);
	if (!tab) continue;
	active_str = (tab.active) ? "tab_active" : "tab_inactive";

	if (TDs[j].getAttribute("tabHeaderOf") == tabId) {
	// module tab is selected
	SetBackground('l_' + tabId, "$imagesURL/itemtabs/" + active_str + "_l.gif");
	SetBackground('m_' + tabId, "$imagesURL/itemtabs/" + active_str + ".gif");
	SetBackground('m1_' + tabId, "$imagesURL/itemtabs/" + active_str + ".gif");
	SetBackground('r_' + tabId, "$imagesURL/itemtabs/" + active_str + "_r.gif");
	}
	else
	{
	// module tab is not selected
	SetBackground('l_' +tabIDs[i], "$imagesURL/itemtabs/" + active_str + "_l.gif");
	SetBackground('m_' + tabIDs[i], "$imagesURL/itemtabs/" + active_str + ".gif");
	SetBackground('m1_' + tabIDs[i], "$imagesURL/itemtabs/" + active_str + ".gif");
	SetBackground('r_' + tabIDs[i], "$imagesURL/itemtabs/" + active_str + "_r.gif");
	}

	var images = tabHeader.getElementsByTagName("IMG");
	if (images.length < 1) continue;

	images[0].src = "$imagesURL/itemtabs/" + ((tab.active) ? "divider_up" : "divider_dn") + ".gif";
	}
	}

	function SetBackground(element_id, img_url)
	{
	// set background image of element specified by id
	var el = document.getElementById(element_id);
	el.style.backgroundImage = 'url('+img_url+')';
	}
	</script>

	END;
	?>

	Property changes on: trunk/kernel/admin/include/toolbar/browse.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.14
	\ No newline at end of property
	+1.15
	\ No newline at end of property
	Index: trunk/kernel/units/general/cat_dbitem_export.php
	===================================================================
	--- trunk/kernel/units/general/cat_dbitem_export.php (revision 3647)
	+++ trunk/kernel/units/general/cat_dbitem_export.php (revision 3648)
	@@ -1,870 +1,876 @@
	<?php

	define('EXPORT_STEP', 200); // export by 200 items (e.g. links)
	define('IMPORT_CHUNK', 50120); // 5 KB

	class kCatDBItemExportHelper extends kHelper {


	var $cache = Array();

	var $exportFields = Array();

	/**
	* Export options
	*
	* @var Array
	*/
	var $exportOptions = Array();

	/**
	* If we have custom fields in export
	*
	* @var unknown_type
	*/
	var $hasCustomFields = false;

	/**
	* Custom field values for last item beeing exported
	*
	* @var Array
	*/
	var $customValues = Array();

	/**
	* Item beeing currenly exported
	*
	* @var kCatDBItem
	*/
	var $curItem = null;

	/**
	* Dummy category object
	*
	* @var CategoriesItem
	*/
	var $dummyCategory = null;

	/**
	* Pointer to opened file
	*
	* @var resource
	*/
	var $filePointer = null;

	/**
	* Returns value from cache if found or false otherwise
	*
	* @param string $type
	* @param int $key
	* @return mixed
	*/
	function getFromCache($type, $key)
	{
	return getArrayValue($this->cache, $type, $key);
	}

	/**
	* Adds value to be cached
	*
	* @param string $type
	* @param int $key
	* @param mixed $value
	*/
	function addToCache($type, $key, $value)
	{
	// if (!isset($this->cache[$type])) $this->cache[$type] = Array();
	$this->cache[$type][$key] = $value;
	}

	/**
	* Fill required fields with dummy values
	*
	* @param kEvent $event
	*/
	function fillRequiredFields(&$event)
	{
	$object =& $event->getObject();

	$fields = array_keys($object->Fields);
	foreach ($fields as $field_name)
	{
	$field_options =& $object->Fields[$field_name];
	if (isset($object->VirtualFields[$field_name]) \|\| !getArrayValue($field_options, 'required') ) continue;

	$formatter_class = getArrayValue($field_options, 'formatter');
	if ($formatter_class) // not tested
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$sample_value = $formatter->GetSample($field_name, $field_options, $object);
	}
	$object->SetDBField($field_name, isset($sample_value) && $sample_value ? $sample_value : 'dummy');
	}
	}

	/**
	* Verifies that all user entered export params are correct
	*
	* @param kEvent $event
	*/
	function verifyOptions(&$event)
	{
	if ($this->Application->RecallVar($event->getPrefixSpecial().'_ForceNotValid'))
	{
	$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 0);
	return false;
	}

	$this->fillRequiredFields($event);

	$object =& $event->getObject();
	$cross_unique_fields = Array('FieldsSeparatedBy', 'FieldsEnclosedBy');
	if (($object->GetDBField('CategoryFormat') == 1) \|\| ($event->Special == 'import')) // in one field
	{
	$object->setRequired('CategorySeparator', true);
	$cross_unique_fields[] = 'CategorySeparator';
	}

	$ret = $object->Validate();

	// check if cross unique fields has no same values
	foreach ($cross_unique_fields as $field_index => $field_name)
	{
	if (getArrayValue($object->FieldErrors, $field_name, 'pseudo') == 'required') continue;

	$check_fields = $cross_unique_fields;
	unset($check_fields[$field_index]);

	foreach ($check_fields as $check_field)
	{
	if ($object->GetDBField($field_name) == $object->GetDBField($check_field))
	{
	$object->SetError($check_field, 'unique');
	}
	}
	}

	if ($event->Special == 'import')
	{
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));

	$automatic_fields = ($object->GetDBField('FieldTitles') == 1);
	$object->setRequired('ExportColumns', !$automatic_fields);
	$category_prefix = '__CATEGORY__';
	if ( $automatic_fields && ($this->exportOptions['SkipFirstRow']) ) {
	$this->openFile($event);
	$this->exportOptions['ExportColumns'] = $this->readRecord();
	$this->closeFile();

	// remove additional (non-parseble columns)
	foreach ($this->exportOptions['ExportColumns'] as $field_index => $field_name) {
	if (!$this->validateField($field_name, $object)) {
	unset($this->exportOptions['ExportColumns'][$field_index]);
	}
	}
	$category_prefix = '';
	}

	// 1. check, that we have column definitions
	if (!$this->exportOptions['ExportColumns']) {
	$object->setError('ExportColumns', 'required');
	$ret = false;
	}

	// 2. check, that we have only mixed category field or only separated category fields
	$category_found['mixed'] = false;
	$category_found['separated'] = false;

	foreach ($this->exportOptions['ExportColumns'] as $import_field) {
	if (preg_match('/^'.$category_prefix.'Category(Path\|[0-9]+)/', $import_field, $rets)) {
	$category_found[$rets[1] == 'Path' ? 'mixed' : 'separated'] = true;
	}
	}
	if ($category_found['mixed'] && $category_found['separated']) {
	$object->SetError('ExportColumns', 'unique_category', 'la_error_unique_category_field');
	$ret = false;
	}

	// 3. check, that duplicates check fields are selected & present in imported fields
	if ($this->exportOptions['ReplaceDuplicates']) {
	if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
	$check_fields = Array($object->IDField);
	}
	else {
	$check_fields = $this->exportOptions['DuplicateCheckFields'] ? explode('\|', substr($this->exportOptions['DuplicateCheckFields'], 1, -1)) : Array();
	$object =& $event->getObject();

	$language_id = $this->Application->GetDefaultLanguageId();
	foreach ($check_fields as $index => $check_field) {
	foreach ($object->Fields as $field_name => $field_options) {
	if ($field_name == 'l'.$language_id.'_'.$check_field) {
	$check_fields[$index] = 'l'.$language_id.'_'.$check_field;
	break;
	}
	}
	}
	}
	$this->exportOptions['DuplicateCheckFields'] = $check_fields;

	if (!$check_fields) {
	$object->setError('CheckDuplicatesMethod', 'required');
	$ret = false;
	}
	else {
	foreach ($check_fields as $check_field) {
	if (!in_array($check_field, $this->exportOptions['ExportColumns'])) {
	$object->setError('ExportColumns', 'required');
	$ret = false;
	break;
	}
	}
	}
	}
	}

	return $ret;
	}

	/**
	* Returns filename to read import data from
	*
	* @return string
	*/
	function getImportFilename()
	{
	if ($this->exportOptions['ImportSource'] == 1)
	{
	$ret = $this->exportOptions['ImportFilename']['name'];
	}
	else {
	$ret = $this->exportOptions['ImportLocalFilename'];
	}
	return EXPORT_PATH.'/'.$ret;
	}

	/**
	* Returns filename to write export data to
	*
	* @return string
	*/
	function getExportFilename()
	{
	return EXPORT_PATH.'/'.$this->exportOptions['ExportFilename'].'.'.$this->getFileExtension();
	}

	/**
	* Opens file required for export/import operations
	*
	* @param kEvent $event
	*/
	function openFile(&$event)
	{
	if ($event->Special == 'export') {
	$write_mode = ($this->exportOptions['start_from'] == 0) ? 'w' : 'a';
	$this->filePointer = fopen($this->getExportFilename(), $write_mode);
	}
	else {
	$this->filePointer = fopen($this->getImportFilename(), 'r');
	}
	+
	+ // skip UTF-8 BOM Modifier
	+ $first_chars = fread($this->filePointer, 3);
	+ if (bin2hex($first_chars) != 'efbbbf') {
	+ fseek($this->filePointer, 0);
	+ }
	}

	/**
	* Closes opened file
	*
	*/
	function closeFile()
	{
	fclose($this->filePointer);
	}

	function getExportSQL($count_only = false)
	{
	if ($this->exportOptions['export_ids'] === false)
	{
	// get links from current category & all it's subcategories
	$sql = 'SELECT item_table.*, ci.CategoryId
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE ';

	if ($this->exportOptions['export_cats_ids'][0] == 0)
	{
	$sql .= '1';
	}
	else {
	foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
	$sql .= '(c.ParentPath LIKE "%\|'.$category_id.'\|%") OR ';
	}
	$sql = preg_replace('/(.*) OR $/', '\\1', $sql);
	}

	$sql .= ' ORDER BY ci.PrimaryCat DESC'; // NEW
	}
	else {
	// get only selected links
	$sql = 'SELECT item_table.*, '.$this->exportOptions['export_cats_ids'][0].' AS CategoryId
	FROM '.$this->curItem->TableName.' item_table
	WHERE '.$this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
	}

	if (!$count_only)
	{
	$sql .= ' LIMIT '.$this->exportOptions['start_from'].','.EXPORT_STEP;
	}
	else {
	$sql = preg_replace("/^.SELECT(.?)FROM(?!_)/is", "SELECT COUNT(*) AS count FROM ", $sql);
	}

	return $sql;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function performExport(&$event)
	{
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
	$this->exportFields = $this->exportOptions['ExportColumns'];
	$this->curItem =& $event->getObject( Array('skip_autoload' => true) );

	$this->openFile($event);

	if ($this->exportOptions['start_from'] == 0) // first export step
	{
	if (!getArrayValue($this->exportOptions, 'IsBaseCategory')) {
	$this->exportOptions['IsBaseCategory'] = 0;
	}

	if ($this->exportOptions['IsBaseCategory'] ) {
	$sql = 'SELECT CachedNavbar
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$this->Application->GetVar('m_cat_id');
	$this->exportOptions['BaseLevel'] = substr_count($this->Conn->GetOne($sql), '>') + 1; // level to cut from other categories
	}

	// 1. export field titles if required
	if ($this->exportOptions['IncludeFieldTitles'])
	{
	$data_array = Array();
	foreach ($this->exportFields as $export_field)
	{
	$data_array = array_merge($data_array, $this->getFieldCaption($export_field));
	}
	$this->writeRecord($data_array);
	}
	$this->exportOptions['total_records'] = $this->Conn->GetOne( $this->getExportSQL(true) );
	$this->exportOptions['has_custom_fields'] = $this->scanCustomFields();
	}

	$this->hasCustomFields = $this->exportOptions['has_custom_fields'];

	// 2. export data
	$records = $this->Conn->Query( $this->getExportSQL() );
	$records_exported = 0;
	foreach ($records as $record_info) {
	$this->curItem->SetDBFieldsFromHash($record_info);
	if ($this->hasCustomFields)
	{
	$this->loadItemCustomFields();
	}

	$data_array = Array();
	foreach ($this->exportFields as $export_field)
	{
	$data_array = array_merge($data_array, $this->getFieldValue($export_field) );
	}
	$this->writeRecord($data_array);
	$records_exported++;
	}
	$this->closeFile();

	$this->exportOptions['start_from'] += $records_exported;
	$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );

	return $this->exportOptions;
	}

	function getItemFields()
	{
	// just in case dummy user selected automtic mode & moved columns too :(
	return array_merge($this->curItem->Fields['AvailableColumns']['options'], $this->curItem->Fields['ExportColumns']['options']);
	}

	/**
	* Checks if field really belongs to importable field list
	*
	* @param string $field_name
	* @param kCatDBItem $object
	* @return bool
	*/
	function validateField($field_name, &$object)
	{
	// 1. convert custom field
	$field_name = preg_replace('/^Custom_(.*)/', '__CUSTOM__\\1', $field_name);

	// 2. convert category field (mixed version & serparated version)
	$field_name = preg_replace('/^Category(Path\|[0-9]+)/', '__CATEGORY__Category\\1', $field_name);

	$valid_fields = $object->getPossibleExportColumns();
	return isset($valid_fields[$field_name]);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function performImport(&$event)
	{
	if (!$this->exportOptions) {
	// load import options in case if not previously loaded in verification function
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
	}

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

	$backup_category_id = $this->Application->GetVar('m_cat_id');
	$this->Application->SetVar('m_cat_id', (int)$this->Application->RecallVar('ImportCategory') );

	$this->openFile($event);

	$bytes_imported = 0;
	if ($this->exportOptions['start_from'] == 0) // first export step
	{
	// 1st time run
	if ($this->exportOptions['SkipFirstRow']) {
	$this->readRecord();
	$this->exportOptions['start_from'] = ftell($this->filePointer);
	$bytes_imported = ftell($this->filePointer);
	}

	$current_category_id = $this->Application->GetVar('m_cat_id');
	if ($current_category_id > 0) {
	$sql = 'SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId = '.$current_category_id;
	$this->exportOptions['ImportCategoryPath'] = $this->Conn->GetOne($sql);
	}
	else {
	$this->exportOptions['ImportCategoryPath'] = '';
	}
	$this->exportOptions['total_records'] = filesize($this->getImportFilename());
	}
	else {
	$this->cache['new_ids'] = $this->exportOptions['new_ids_hash'];
	}
	$this->exportFields = $this->exportOptions['ExportColumns'];
	$this->addToCache('category_parent_path', $this->Application->GetVar('m_cat_id'), $this->exportOptions['ImportCategoryPath']);

	// 2. import data
	$this->dummyCategory =& $this->Application->recallObject('c.-tmpitem', 'c', Array('skip_autoload' => true));
	fseek($this->filePointer, $this->exportOptions['start_from']);

	while (($bytes_imported < IMPORT_CHUNK) && !feof($this->filePointer)) {
	$this->customValues = Array();
	$data = $this->readRecord();
	if ($data) {
	foreach ($data as $field_index => $field_value) {
	$this->setFieldValue($field_index, $field_value);
	}
	$this->curItem->setID( $this->curItem->GetDBField($this->curItem->IDField) );
	$this->processCurrentItem($event);
	}
	$bytes_imported = ftell($this->filePointer) - $this->exportOptions['start_from'];
	}

	$this->closeFile();
	$this->Application->SetVar('m_cat_id', $backup_category_id);

	$this->exportOptions['start_from'] += $bytes_imported;
	$this->exportOptions['new_ids_hash'] = getArrayValue($this->cache, 'new_ids');
	$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );

	return $this->exportOptions;
	}

	function setFieldValue($field_index, $value)
	{
	$field_name = $this->exportFields[$field_index];

	if (substr($field_name, 0, 7) == 'Custom_') {
	$field_name = substr($field_name, 7);
	$this->customValues[$field_name] = $value;
	}
	elseif ($field_name == 'CategoryPath') {
	$this->curItem->CategoryPath = explode($this->exportOptions['CategorySeparator'], $value);
	}
	elseif (substr($field_name, 0, 8) == 'Category') {
	$this->curItem->CategoryPath[ (int)substr($field_name, 8) ] = $value;
	}
	else {
	$this->curItem->SetField($field_name, $value);
	}
	}

	/**
	* Returns temporary items for import procedures
	*
	* @param kEvent $event
	* @return kCatDBItem
	*/
	function &getTempItem(&$event)
	{
	return $this->Application->recallObject($event->Prefix.'.-tmpitem', $event->Prefix, Array('skip_autoload' => true));
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function processCurrentItem(&$event)
	{
	$tmp_item =& $this->getTempItem($event);

	// create/update categories
	$backup_category_id = $this->Application->GetVar('m_cat_id');

	foreach ($this->curItem->CategoryPath as $category_name) {
	if (!$category_name) continue;
	$category_id = $this->getFromCache('category_names', $category_name);
	if ($category_id === false) {
	// get parent category path to search only in it
	$current_category_id = $this->Application->GetVar('m_cat_id');
	$parent_path = $this->getParentPath($current_category_id);

	// get category id from database by name
	$sql = 'SELECT CategoryId
	FROM '.TABLE_PREFIX.'Category
	WHERE (Name = '.$this->Conn->qstr($category_name).') AND (ParentPath LIKE "'.$parent_path.'%")';
	$category_id = $this->Conn->GetOne($sql);

	if ($category_id === false) {
	// category not in db -> create
	$category_fields = Array( 'Name' => $category_name, 'Description' => $category_name,
	'Status' => STATUS_ACTIVE, 'ParentId' => $current_category_id,
	);
	$this->dummyCategory->SetDBFieldsFromHash($category_fields);
	if ($this->dummyCategory->Create()) {
	$category_id = $this->dummyCategory->GetID();
	$this->addToCache('category_parent_path', $category_id, $this->dummyCategory->GetDBField('ParentPath'));
	$this->addToCache('category_names', $category_name, $category_id);
	}
	}
	else {
	$this->addToCache('category_names', $category_name, $category_id);
	}
	}

	if ($category_id) {
	$this->Application->SetVar('m_cat_id', $category_id);
	}
	}
	if (!$this->curItem->CategoryPath) {
	$category_id = $backup_category_id;
	}

	// create main record
	$save_method = 'Create';
	if ($this->exportOptions['ReplaceDuplicates']) {
	if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
	$load_keys = Array($this->curItem->IDField => $this->curItem->GetID());
	}
	else {
	$key_fields = $this->exportOptions['DuplicateCheckFields'];
	foreach ($key_fields as $key_field) {
	$load_keys[$key_field] = $this->curItem->GetDBField($key_field);
	}
	}

	$where_clause = '';
	foreach ($load_keys as $field_name => $field_value) {
	$where_clause .= '(item_table.`'.$field_name.'` = '.$this->Conn->qstr($field_value).') AND ';
	}
	$where_clause = preg_replace('/(.*) AND $/', '\\1', $where_clause);

	$item_id = $this->getFromCache('new_ids', $where_clause);
	if (!$item_id) {
	$parent_path = $this->getParentPath($category_id);
	$sql = 'SELECT '.$this->curItem->IDField.'
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE (c.ParentPath LIKE "'.$parent_path.'%") AND '.$where_clause;
	$item_id = $this->Conn->GetOne($sql);
	}
	$save_method = $tmp_item->Load($item_id) ? 'Update' : 'Create';
	}

	$resource_id = $tmp_item->isLoaded() ? $tmp_item->GetDBField('ResourceId') : 0;
	$tmp_item->SetDBFieldsFromHash($this->curItem->FieldValues);
	if( ($save_method == 'Update') && $resource_id ) {
	$tmp_item->SetDBField('ResourceId', $resource_id);
	$tmp_item->setID($item_id);
	}

	if (!$tmp_item->$save_method()) {
	return false;
	}

	if ( ($save_method == 'Create') && $this->exportOptions['ReplaceDuplicates'] ) {
	// map new id to old id
	$this->addToCache('new_ids', $where_clause, $tmp_item->GetID() );
	}

	// set custom fields
	foreach ($this->customValues as $custom_field => $custom_value) {
	if (($save_method == 'Create') && !$custom_value) continue;
	$tmp_item->SetCustomField($custom_field, $custom_value);
	}

	// assign item to categories
	$tmp_item->assignToCategory($category_id, false);

	$this->Application->SetVar('m_cat_id', $backup_category_id);
	return true;
	}

	/**
	* Returns category parent path, if possible, then from cache
	*
	* @param int $category_id
	* @return string
	*/
	function getParentPath($category_id)
	{
	$parent_path = $this->getFromCache('category_parent_path', $category_id);
	if ($parent_path === false) {
	$sql = 'SELECT ParentPath
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$category_id;
	$parent_path = $this->Conn->GetOne($sql);
	$this->addToCache('category_parent_path', $category_id, $parent_path);
	}
	return $parent_path;
	}

	function loadItemCustomFields()
	{
	$sql = 'SELECT meta_data.Value, cf.FieldName
	FROM '.TABLE_PREFIX.'CustomMetaData meta_data
	LEFT JOIN '.TABLE_PREFIX.'CustomField cf ON cf.CustomFieldId = meta_data.CustomFieldId
	WHERE meta_data.ResourceId = '.$this->curItem->GetDBField('ResourceId');
	$this->customValues = $this->Conn->GetCol($sql, 'FieldName');
	}

	function getFileExtension()
	{
	return $this->exportOptions['ExportFormat'] == 1 ? 'csv' : 'xml';
	}

	function getLineSeparator($option = 'LineEndings')
	{
	return $this->exportOptions[$option] == 1 ? "\r\n" : "\n";
	}

	function scanCustomFields()
	{
	$ret = false;
	$export_fields = $this->exportOptions['ExportColumns'];
	foreach ($export_fields as $field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$ret = true;
	break;
	}
	}
	return $ret;
	}

	/**
	* Returns field caption for any exported field
	*
	* @param string $field
	* @return string
	*/
	function getFieldCaption($field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$ret = 'Custom_'.substr($field, 10, strlen($field) );
	}
	elseif (substr($field, 0, 12) == '__CATEGORY__')
	{
	return $this->getCategoryTitle();
	}
	else
	{
	$ret = $field;
	}

	return Array($ret);
	}

	/**
	* Returns requested field value (including custom fields and category fields)
	*
	* @param string $field
	* @return string
	*/
	function getFieldValue($field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$field = substr($field, 10, strlen($field) );
	$ret = isset($this->customValues[$field]) ? $this->customValues[$field] : '';
	}
	elseif (substr($field, 0, 12) == '__CATEGORY__')
	{
	return $this->getCategoryPath();
	}
	else
	{
	$ret = $this->curItem->GetField($field);
	}

	$ret = str_replace("\r\n", $this->getLineSeparator('LineEndingsInside'), $ret);
	return Array($ret);
	}

	/**
	* Returns category field(-s) caption based on export mode
	*
	* @return string
	*/
	function getCategoryTitle()
	{
	if ($this->exportOptions['CategoryFormat'] == 1)
	{
	// category path in one field
	return Array('CategoryPath');
	}
	else
	{
	// category path in separated fields
	$category_count = $this->getMaxCategoryLevel();

	$i = 0;
	$ret = Array();
	while ($i < $category_count) {
	$ret[] = 'Category'.($i + 1);
	$i++;
	}
	return $ret;
	}
	}

	/**
	* Returns category path in required format for current link
	*
	* @return string
	*/
	function getCategoryPath()
	{
	$category_id = $this->curItem->GetDBField('CategoryId');
	$category_path = $this->getFromCache('category_path', $category_id);
	if (!$category_path)
	{
	$sql = 'SELECT CachedNavbar
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$category_id;
	$category_path = $this->Conn->GetOne($sql);
	$category_path = $category_path ? explode('>', $category_path) : Array();

	if ($this->exportOptions['IsBaseCategory']) {
	$i = $this->exportOptions['BaseLevel'];
	while ($i > 0) {
	array_shift($category_path);
	$i--;
	}
	}

	if ($this->exportOptions['CategoryFormat'] == 1) {
	// category path in single field
	$category_path = Array( implode($this->exportOptions['CategorySeparator'], $category_path) );
	}
	else {
	// category path in separated fields
	$category_count = $this->getMaxCategoryLevel();
	$levels_used = count($category_path);
	if ($levels_used < $category_count)
	{
	$i = 0;
	while ($i < $category_count - $levels_used) {
	$category_path[] = '';
	$i++;
	}
	}
	}
	$this->addToCache('category_path', $category_id, $category_path);
	}

	return $category_path;
	}

	/**
	* Get maximal category deep level from links beeing exported
	*
	* @return int
	*/
	function getMaxCategoryLevel()
	{
	static $max_level = -1;

	if ($max_level != -1)
	{
	return $max_level;
	}

	$sql = 'SELECT IF(c.CategoryId IS NULL, 0, MAX( LENGTH(c.ParentPath) - LENGTH( REPLACE(c.ParentPath, "\|", "") ) - 1 ))
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON item_table.ResourceId = ci.ItemResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE (ci.PrimaryCat = 1) AND ';

	$where_clause = '';
	if ($this->exportOptions['export_ids'] === false) {
	// get links from current category & all it's subcategories
	if ($this->exportOptions['export_cats_ids'][0] == 0) {
	$where_clause = 1;
	}
	else {
	foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
	$where_clause .= '(c.ParentPath LIKE "%\|'.$category_id.'\|%") OR ';
	}
	$where_clause = preg_replace('/(.*) OR $/', '\\1', $where_clause);
	}
	}
	else {
	// get only selected links
	$where_clause = $this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
	}

	$max_level = $this->Conn->GetOne($sql.'('.$where_clause.')');

	if ($this->exportOptions['IsBaseCategory'] ) {
	$max_level -= $this->exportOptions['BaseLevel'];
	}

	return $max_level;
	}

	/**
	* Saves one record to export file
	*
	* @param Array $fields_hash
	*/
	function writeRecord($fields_hash)
	{
	fputcsv2($this->filePointer, $fields_hash, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy'], $this->getLineSeparator() );
	}

	function readRecord()
	{
	return fgetcsv($this->filePointer, 10000, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy']);
	}
	}

	?>

	Property changes on: trunk/kernel/units/general/cat_dbitem_export.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/admin/browse.php
	===================================================================
	--- trunk/admin/browse.php (revision 3647)
	+++ trunk/admin/browse.php (revision 3648)
	@@ -1,447 +1,446 @@
	<?php
	##############################################################
	##In-portal ##
	##############################################################
	## In-portal ##
	## Intechnic Corporation ##
	## All Rights Reserved, 1998-2002 ##
	## ##
	## No portion of this code may be copied, reproduced or ##
	## otherwise redistributed without proper written ##
	## consent of Intechnic Corporation. Violation will ##
	## result in revocation of the license and support ##
	## privileges along maximum prosecution allowed by law. ##
	##############################################################

	//KERNEL4 STARTUP - FOR ACTIONS HANDLING

	function k4getmicrotime()
	{
	list($usec, $sec) = explode(" ", microtime());
	return ((float)$usec + (float)$sec);
	}

	$start = k4getmicrotime();

	define('ADMIN', 1);
	define('FULL_PATH', realpath(dirname(__FILE__).'/..'));
	define('APPLICATION_CLASS', 'MyApplication');
	include_once(FULL_PATH."/kernel/kernel4/startup.php");

	$application =& kApplication::Instance();
	$application->Init();
	$application->ProcessRequest();
	if($application->GetVar('Action') == 'm_paste') define('REDIRECT_REQUIRED',1); // this script can issue redirect header

	//KERNEL4 END

	define('REQUIRE_LAYER_HEADER', 1);
	$b_topmargin = "0";
	//$b_header_addon = "<DIV style='position:relative; z-Index: 1; background-color: #ffffff; padding-top:1px;'><div style='position:absolute; width:100%;top:0px;' align='right'><img src='images/logo_bg.gif'></div><img src='images/spacer.gif' width=1 height=15><br><div style='z-Index:1; position:relative'>";

	require_once FULL_PATH.'/kernel/startup.php';

	require_login();

	$indexURL = $rootURL."index.php";
	$homeURL = "javascript:AdminCatNav('".$_SERVER["PHP_SELF"]."?env=".BuildEnv()."');";

	$m_var_list_update["cat"] = 0;
	unset($m_var_list_update["cat"]);

	$envar = "env=" . BuildEnv();

	if($objCatList->CurrentCategoryID()>0)
	{
	$c = $objCatList->CurrentCat();
	$upURL = "javascript:AdminCatNav('".$c->Admin_Parent_Link()."');";
	}
	else
	$upURL = $_SERVER["PHP_SELF"]."?".$envar;

	//admin only util

	$pathtolocal = $pathtoroot."kernel/";
	require_once ($pathtoroot.$admin."/include/elements.php");
	//require_once ($pathtoroot."kernel/admin/include/navmenu.php");
	require_once ($pathtolocal."admin/include/navmenu.php");
	require_once($pathtoroot.$admin."/browse/toolbar.php");

	$m = GetModuleArray();
	foreach($m as $key=>$value)
	{
	$path = $pathtoroot.$value."admin/include/parser.php";
	if(file_exists($path))
	{
	//echo "<!-- $path -->";
	@include_once($path);
	}
	}


	$application->InitParser();

	$cat_templates = $objModules->ExecuteFunction('GetModuleInfo', 'catalog_template');
	foreach ($cat_templates as $a_mod => $a_template) {
	if (!$a_template) continue;
	$a_var = $a_mod.'_TAB_HTML';
	$$a_var = $application->ParseBlock(Array('name'=>$a_template), 0, true);
	}

	//$application->SetVar('t', 'in-commerce/products/products_catalog');


	if( !defined('IS_INSTALL') ) define('IS_INSTALL', 0);
	if( !IS_INSTALL ) require_login();

	//Set Section
	$section = 'in-portal:browse';

	//Set Environment Variable

	//echo $objCatList->ItemsOnClipboard()." Categories on the clipboard<br>\n";
	//echo $objTopicList->ItemsOnClipboard()." Topics on the clipboard<br>\n";
	//echo $objLinkList->ItemsOnClipboard()." Links on the clipboard<br>\n";
	//echo $objArticleList->ItemsOnClipboard()." Articles on the clipboard<br>\n";

	// save last category visited
	$objSession->SetVariable('prev_category', $objSession->GetVariable('last_category') );
	$objSession->SetVariable('last_category', $objCatList->CurrentCategoryID() );

	/* // for testing
	$last_cat = $objSession->GetVariable('last_category');
	$prev_cat = $objSession->GetVariable('prev_category');
	echo "Last CAT: [$last_cat]<br>";
	echo "Prev CAT: [$prev_cat]<br>";
	*/
	$SearchType = $objSession->GetVariable("SearchType");
	if(!strlen($SearchType))
	$SearchType = "all";
	$SearchLabel = "la_SearchLabel";
	if( GetVar('SearchWord') !== false ) $objSession->SetVariable('admin_seach_words', GetVar('SearchWord') );
	$SearchWord = $objSession->GetVariable('admin_seach_words');

	// where should all edit popups submit changes
	$objSession->SetVariable("ReturnScript", basename($_SERVER['PHP_SELF']) );
	$charset = GetRegionalOption('Charset');

	$m_tag_processor =& $application->recallObject('m_TagProcessor');
	$base_href = $m_tag_processor->Base_Ref();

	/* page header */
	print <<<END
	<html>
	<head>
	<title>In-portal</title>
	$base_href
	<meta http-equiv="content-type" content="text/html;charset=$charset">
	<meta http-equiv="Pragma" content="no-cache">
	<script language="JavaScript">
	imagesPath='$imagesURL'+'/';
	</script>

	END;

	require_once($pathtoroot.$admin."/include/mainscript.php");

	print <<<END
	<script type="text/javascript">
	if (window.opener != null) {
	theMainScript.CloseAndRefreshParent();
	}
	</script>
	END;

	print <<<END
	<script src="$browseURL/toolbar.js"></script>
	<script src="$browseURL/checkboxes_new.js"></script>
	<script language="JavaScript1.2" src="$browseURL/fw_menu.js"></script>
	<script language="javascript" src="incs/script.js"></script>
	<link rel="stylesheet" type="text/css" href="$browseURL/checkboxes.css">
	<link rel="stylesheet" type="text/css" href="$cssURL/style.css">
	<link rel="stylesheet" type="text/css" href="$browseURL/toolbar.css">
	END;
	load_module_styles();
	if( !isset($list) ) $list = '';
	if(($SearchType=="categories" \|\| $SearchType="all") && strlen($list))
	{
	int_SectionHeader(NULL,NULL,NULL,admin_language("la_Title_SearchResults"));
	}
	else
	int_SectionHeader();

	$filter = false; // always initialize variables before use

	if($objSession->GetVariable("SearchWord") != '') {
	$filter = true;
	}
	else {
	$bit_combo = $objModules->ExecuteFunction('GetModuleInfo', 'all_bitmask');
	$bit_combo = $objModules->MergeReturn($bit_combo);
	foreach($bit_combo['VarName'] as $mod_name => $VarName)
	{
	//echo "VarName: [$VarName] = [".$objConfig->Get($VarName)."], ALL = [".$bit_combo['Bits'][$mod_name]."]<br>";
	if( $objConfig->Get($VarName) )
	if( $objConfig->Get($VarName) != $bit_combo['Bits'][$mod_name] )
	{
	$filter = true;
	break;
	}
	}
	}
	?>
	</div>
	<!-- alex mark -->
	<table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td>
	<div name="toolBar" id="mainToolBar">
	<tb:button action="upcat" title="<?php echo admin_language("la_ToolTip_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="homecat" title="<?php echo admin_language("la_ToolTip_Home"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="new_cat" title="<?php echo admin_language("la_ToolTip_New_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="editcat" title="<?php echo admin_language("la_ToolTip_Edit_Current_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">

	<?php
	foreach($NewButtons as $btn)
	{
	print '<tb:button action="'.$btn['Action'].'" title="'.$btn['Alt'].'" ImagePath="'.$btn['ImagePath'].'" ';
	if (getArrayValue($btn, 'Tab')) print 'tab="'.$btn['Tab'].'"';
	print ">\n";
	}
	?>

	<tb:button action="edit" title="<?php echo admin_language("la_ToolTip_Edit"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="delete" title="<?php echo admin_language("la_ToolTip_Delete"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="approve" title="<?php echo admin_language("la_ToolTip_Approve"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="decline" title="<?php echo admin_language("la_ToolTip_Decline"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">

	- <tb:button action="import" title="<?php echo admin_language("la_ToolTip_Import"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="export" title="<?php echo admin_language("la_ToolTip_Export"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">

	<tb:button action="rebuild_cache" title="<?php echo admin_language("la_ToolTip_RebuildCategoryCache"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">

	<tb:button action="cut" title="<?php echo admin_language("la_ToolTip_Cut"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="copy" title="<?php echo admin_language("la_ToolTip_Copy"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="paste" title="<?php echo admin_language("la_ToolTip_Paste"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="move_up" title="<?php echo admin_language("la_ToolTip_Move_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="move_down" title="<?php echo admin_language("la_ToolTip_Move_Down"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="print" title="<?php echo admin_language("la_ToolTip_Print"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="view" title="<?php echo admin_language("la_ToolTip_View"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	</div>
	</td>
	</tr>
	</tbody>
	</table>

	<table cellspacing="0" cellpadding="0" width="100%" bgcolor="#e0e0da" border="0" class="tableborder_full_a">
	<tbody>
	<tr>
	<td><img height="15" src="<?php echo $imagesURL; ?>/arrow.gif" width="15" align="middle" border="0">
	<span class="navbar"><?php $attribs["admin"]=1; print m_navbar($attribs); ?></span>
	</td>
	<td align="right">
	<FORM METHOD="POST" ACTION="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>" NAME="admin_search" ID="admin_search"><INPUT ID="SearchScope" NAME="SearchScope" type="hidden" VALUE="<?php echo $objSession->GetVariable("SearchScope"); ?>"><INPUT ID="SearchType" NAME="SearchType" TYPE="hidden" VALUE="<?php echo $objSession->GetVariable("SearchType"); ?>"><INPUT ID="NewSearch" NAME="NewSearch" TYPE="hidden" VALUE="0"><INPUT TYPE="HIDDEN" NAME="Action" value="m_Exec_Search">
	<table cellspacing="0" cellpadding="0"><tr>
	<td><?php echo admin_language($SearchLabel); ?> </td>
	<td><input ID="SearchWord" type="text" value="<?php echo inp_htmlize($SearchWord,1); ?>" name="SearchWord" size="10" style="border-width: 1; border-style: solid; border-color: 999999"></td>
	<td><img id="imgSearch" action="search_b" src="<?php echo $imagesURL."/toolbar/";?>/icon16_search.gif" title="<?php echo admin_language("la_ToolTip_Search"); ?>" align="absMiddle" onclick="this.action = this.getAttribute('action'); actionHandler(this);" src="<?php echo $imagesURL."/toolbar/";?>/arrow16.gif" onmouseover="this.src='<?php echo $imagesURL."/toolbar/";?>/icon16_search_f2.gif'" onmouseout="this.src='<?php echo $imagesURL."/toolbar/";?>/icon16_search.gif'" style="cursor:hand" width="22" width="22"><!--<img action="search_a" title="<?php echo admin_language("la_ToolTip_Search"); ?>" align="absMiddle" onclick="this.action = this.getAttribute('action'); actionHandler(this);" src="<?php echo $imagesURL."/toolbar/";?>/arrow16.gif" onmouseover="this.src='<?php echo $imagesURL."/toolbar/";?>/arrow16_f2.gif'" onmouseout="this.src='<?php echo $imagesURL."/toolbar/";?>/arrow16.gif'" style="cursor:hand">-->
	<img action="search_c" src="<?php echo $imagesURL."/toolbar/";?>/icon16_search_reset.gif" title="<?php echo admin_language("la_ToolTip_Search"); ?>" align="absMiddle" onclick="document.all.SearchWord.value = ''; this.action = this.getAttribute('action'); actionHandler(this);" onmouseover="this.src='<?php echo $imagesURL."/toolbar/";?>/icon16_search_reset_f2.gif'" onmouseout="this.src='<?php echo $imagesURL."/toolbar/";?>/icon16_search_reset.gif'" style="cursor:hand" width="22" width="22">
	</td>
	</tr></table>
	</FORM>
	<!--tb:button action="search_b" title="<?php echo admin_language("la_ToolTip_Search"); ?>" align="right" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
	<tb:button action="search_a" title="<?php echo admin_language("la_ToolTip_Search"); ?>" align="right" ImagePath="<?php echo $imagesURL."/toolbar/";?>"-->
	</td>
	</tr>
	</tbody>
	</table>
	<?php if ($filter) { ?>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
	<tr>
	<td valign="top">
	<?php int_hint_red(admin_language("la_Warning_Filter")); ?>
	</td>
	</tr>
	</table>
	<?php } ?>
	<br>
	<!-- CATEGORY DIVIDER -->
	<?php

	$OrderBy = $objCatList->QueryOrderByClause(TRUE,TRUE,TRUE);
	$objCatList->Clear();
	$IsSearch = FALSE;
	if($SearchType == 'categories' \|\| $SearchType == 'all')
	{
	$list = $objSession->GetVariable("SearchWord");
	$SearchQuery = $objCatList->AdminSearchWhereClause($list);
	if(strlen($SearchQuery))
	{
	$SearchQuery = " (".$SearchQuery.") ";
	if( strlen($CatScopeClause) ) {
	$SearchQuery .= " AND ParentId = ".$objCatList->CurrentCategoryID();//" AND ".$CatScopeClause;
	}
	$objCatList->LoadCategories($SearchQuery.$CategoryFilter,$OrderBy);
	$IsSearch = TRUE;
	}
	else
	$objCatList->LoadCategories("ParentId=".$objCatList->CurrentCategoryID()." ".$CategoryFilter,$OrderBy);
	}
	else
	$objCatList->LoadCategories("ParentId=".$objCatList->CurrentCategoryID()." ".$CategoryFilter, $OrderBy);

	$TotalItemCount += $objCatList->QueryItemCount;

	?>
	<?php
	$e = $Errors->GetAdminUserErrors();
	if(count($e)>0)
	{
	echo "<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" border=\"0\">";
	for($ex = 0; $ex<count($e);$ex++)
	{
	echo "<tr><td width=\100%\" class=\"error\">".prompt_language($e[$ex])."</td></tr>";
	}
	echo "</TABLE><br>";
	}
	?>
	<table cellspacing="0" cellpadding="0" width="100%" border="0">
	<tbody>
	<tr>
	<td width="138" height="20" nowrap="nowrap" class="active_tab" onclick="toggleCategoriesB(this)" id="cats_tab">
	<table cellspacing="0" cellpadding="0" width="100%" border="0">
	<tr>
	<td id="l_cat" background="<?php echo $imagesURL; ?>/itemtabs/tab_active_l.gif" class="left_tab">
	<img src="<?php echo $imagesURL; ?>/itemtabs/divider_up.gif" width="20" height="20" border="0" align="absmiddle">
	</td>
	<td id="m_cat" nowrap background="<?php echo $imagesURL; ?>/itemtabs/tab_active.gif" class="tab_class">
	<?php echo admin_language("la_ItemTab_Categories"); ?>:
	</td>
	<td id="m1_cat" align="right" valign="top" background="<?php echo $imagesURL; ?>/itemtabs/tab_active.gif" class="tab_class">
	<span class="cats_stats">(<?php echo $objCatList->QueryItemCount; ?>)</span>
	</td>
	<td id="r_cat" background="<?php echo $imagesURL; ?>/itemtabs/tab_active_r.gif" class="right_tab">
	<img src="<?php echo $imagesURL; ?>/spacer.gif" width="21" height="20">
	</td>
	</tr>
	</table>
	</td>
	<td> </td>
	</tr>
	</tbody>
	</table>
	<div class="divider" style="" id="categoriesDevider"><img width="1" height="1" src="<?php echo $imagesURL; ?>/spacer.gif"></div>
	</DIV>
	</div>
	<DIV style="background-color: #ffffff; position: relative; padding-top: 1px; top: -1px; z-Index:0" id="firstContainer">
	<DIV style="background-color: #ffffff; position: relative; padding-top: 1px; top: -1px; z-Index:2" id="secondContainer">
	<!-- CATEGORY OUTPUT START -->
	<div id="categories" tabtitle="Categories">
	<form id="categories_form" name="categories_form" action="" method="post">
	<input type="hidden" name="Action">
	<?php
	if($IsSearch)
	{
	$template = "cat_search_element.tpl";
	}
	else {
	$template = "cat_element.tpl";
	}
	print adListSubCats($objCatList->CurrentCategoryID(),$template);
	?>
	</form>
	</div>
	<BR>
	<!-- CATEGORY OUTPUT END -->
	<?php
	print $ItemTabs->TabRow();
	if(count($ItemTabs->Tabs))
	{
	?>
	<div class="divider" id="tabsDevider"><img width=1 height=1 src="images/spacer.gif"></div>
	<?php
	}
	?>
	</DIV>
	<?php
	unset($m);

	//echo $application->ParseBlock(Array('name'=>'kernel_form_start'), 0, true);

	$m = GetModuleArray("admin");
	foreach($m as $key=>$value)
	{
	$path = $pathtoroot.$value."admin/browse.php";
	if(file_exists($path))
	{
	//echo "\n<!-- $path -->\n";
	include_once($path);
	}
	}

	//echo $application->ParseBlock(Array('name'=>'kernel_form_end'), 0, true);


	$admin = $objConfig->Get("AdminDirectory");
	if(!strlen($admin)) $admin = "admin";
	?>
	<form method="post" action="<?php echo $rootURL.$admin; ?>/browse.php?env=<?php echo BuildEnv(); ?>" name="viewmenu">
	<input type="hidden" name="fieldname" value="">
	<input type="hidden" name="varvalue" value="">
	<input type="hidden" name="varvalue2" value="">
	<input type="hidden" name="Action" value="">
	</form>
	</DIV>
	<!-- END CODE-->
	<script language="JavaScript">
	InitPage();


	cats_on = theMainScript.GetCookie('cats_tab_on');
	if (cats_on == 0) {
	toggleCategoriesB(document.getElementById('cats_tab'), true);
	}

	tabs_on = theMainScript.GetCookie('tabs_on');
	if (tabs_on == '1' \|\| tabs_on == null) {
	if(default_tab.length == 0 \|\| default_tab == 'categories' )
	{
	cookie_start = theMainScript.GetCookie('active_tab');
	if (cookie_start != null) start_tab = cookie_start;
	if(start_tab!=null) {
	//alert('ok');
	toggleTabB(start_tab, true);
	}
	}
	else
	{
	//alert('ok');
	toggleTabB(default_tab,true);
	}
	}

	d = document.getElementById('SearchWord');
	if(d)
	{
	d.onkeyup = function(event) {
	if(window.event.keyCode==13)
	{
	var el = document.getElementById('imgSearch');
	el.onclick();
	}
	}
	}
	</script>

	<?php
	$objSession->SetVariable("HasChanges", 0);
	int_footer();
	?>
	\ No newline at end of file

	Property changes on: trunk/admin/browse.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.30
	\ No newline at end of property
	+1.31
	\ No newline at end of property
	Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.6.sql
	===================================================================
	--- trunk/admin/install/upgrades/inportal_upgrade_v1.1.6.sql (revision 3647)
	+++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.6.sql (revision 3648)
	@@ -1,10 +1,13 @@
	ALTER TABLE Category ADD INDEX (Filename ( 5 ));

	INSERT INTO ConfigurationAdmin VALUES ('MaxImportCategoryLevels', 'la_Text_General', 'la_prompt_max_import_category_levels', 'text', '', '', 9, 1);
	INSERT INTO ConfigurationValues VALUES ('MaxImportCategoryLevels', '10', 'In-Portal', 'in-portal:configure_categories');

	ALTER TABLE ItemTypes ADD Prefix VARCHAR(20) NOT NULL AFTER Module;
	UPDATE ItemTypes SET Prefix = 'c' WHERE SourceTable = 'Category';
	UPDATE ItemTypes SET Prefix = 'u' WHERE SourceTable = 'PortalUser';

	+ALTER TABLE ImportScripts ADD is_type VARCHAR(10) NOT NULL;
	+UPDATE ImportScripts SET is_type = 'db';
	+
	UPDATE Modules SET Version = '1.1.6' WHERE Name = 'In-Portal';
	\ No newline at end of file

	Property changes on: trunk/admin/install/upgrades/inportal_upgrade_v1.1.6.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.5
	\ No newline at end of property
	+1.6
	\ No newline at end of property
	Index: trunk/admin/install/inportal_schema.sql
	===================================================================
	--- trunk/admin/install/inportal_schema.sql (revision 3647)
	+++ trunk/admin/install/inportal_schema.sql (revision 3648)
	@@ -1,701 +1,702 @@
	CREATE TABLE BanRules (
	RuleId int(11) NOT NULL auto_increment,
	RuleType tinyint(4) NOT NULL default '0',
	ItemField varchar(255) default NULL,
	ItemVerb tinyint(4) NOT NULL default '0',
	ItemValue varchar(255) NOT NULL default '',
	ItemType int(11) NOT NULL default '0',
	Priority int(11) NOT NULL default '0',
	Status tinyint(4) NOT NULL default '1',
	ErrorTag varchar(255) default NULL,
	PRIMARY KEY (RuleId)
	)

	# --------------------------------------------------------

	CREATE TABLE Category (
	CategoryId int(11) NOT NULL auto_increment,
	Type int(11) NOT NULL default '0',
	ParentId int(11) NOT NULL default '0',
	Name varchar(255) NOT NULL default '',
	Filename varchar(255) NOT NULL,
	AutomaticFilename tinyint(3) unsigned NOT NULL default '0',
	Description text NOT NULL,
	CreatedOn int(11) NOT NULL default '0',
	EditorsPick tinyint(4) default NULL,
	Status tinyint(4) NOT NULL default '0',
	Pop tinyint(4) default NULL,
	Priority int(11) NOT NULL default '0',
	MetaKeywords varchar(255) default NULL,
	CachedDescendantCatsQty int(11) default NULL,
	CachedNavbar text NOT NULL,
	CreatedById int(11) NOT NULL default '0',
	ResourceId int(11) default NULL,
	ParentPath text NOT NULL,
	NamedParentPath text NOT NULL,
	MetaDescription varchar(255) default NULL,
	HotItem int(11) NOT NULL default '2',
	NewItem int(11) NOT NULL default '2',
	PopItem int(11) NOT NULL default '2',
	Modified int(11) NOT NULL default '0',
	ModifiedById int(11) NOT NULL default '0',
	PRIMARY KEY (CategoryId),
	KEY ParentId (ParentId),
	UNIQUE KEY ResourceId (ResourceId),
	KEY Modified (Modified),
	KEY Priority (Priority),
	KEY sorting (Name,Priority),
	KEY Filename (Filename(5))
	)

	# --------------------------------------------------------

	CREATE TABLE CategoryItems (
	CategoryId int(11) NOT NULL default '0',
	ItemResourceId int(11) NOT NULL default '0',
	PrimaryCat tinyint(4) NOT NULL default '0',
	KEY CategoryId (CategoryId),
	KEY ItemResourceId (ItemResourceId),
	KEY PrimaryCat (PrimaryCat)
	)

	# --------------------------------------------------------

	CREATE TABLE ConfigurationAdmin (
	VariableName varchar(80) NOT NULL default '',
	heading varchar(255) default NULL,
	prompt varchar(255) default NULL,
	element_type varchar(20) NOT NULL default '',
	validation varchar(255) default NULL,
	ValueList text default NULL,
	DisplayOrder int(11) NOT NULL default '0',
	Install int(11) NOT NULL default '1',
	PRIMARY KEY (VariableName)
	)

	# --------------------------------------------------------

	CREATE TABLE ConfigurationValues (
	VariableName varchar(255) NOT NULL default '',
	VariableValue varchar(255) default NULL,
	ModuleOwner varchar(20) default 'In-Portal',
	Section varchar(255) NOT NULL default '',
	PRIMARY KEY (VariableName)
	)

	# --------------------------------------------------------

	CREATE TABLE CountCache (
	ListType int(11) NOT NULL default '0',
	ItemType int(11) NOT NULL default '-1',
	Value int(11) NOT NULL default '0',
	CountCacheId int(11) NOT NULL auto_increment,
	LastUpdate int(11) NOT NULL default '0',
	ExtraId varchar(50) default NULL,
	TodayOnly tinyint(4) NOT NULL default '0',
	PRIMARY KEY (CountCacheId)
	)

	# --------------------------------------------------------

	CREATE TABLE CustomField (
	CustomFieldId int(11) NOT NULL auto_increment,
	Type int(11) NOT NULL default '0',
	FieldName varchar(255) NOT NULL default '',
	FieldLabel varchar(40) default NULL,
	Heading varchar(60) default NULL,
	Prompt varchar(60) default NULL,
	ElementType varchar(50) NOT NULL default '',
	ValueList varchar(255) default NULL,
	DisplayOrder int(11) NOT NULL default '0',
	OnGeneralTab tinyint(4) NOT NULL default '0',
	PRIMARY KEY (CustomFieldId),
	KEY Type (Type)
	)

	# --------------------------------------------------------

	CREATE TABLE CustomMetaData (
	CustomDataId int(11) NOT NULL auto_increment,
	ResourceId int(11) NOT NULL default '0',
	CustomFieldId int(11) NOT NULL default '0',
	Value text NOT NULL,
	l1_Value text NOT NULL,
	l2_Value text NOT NULL,
	l3_Value text NOT NULL,
	l4_Value text NOT NULL,
	l5_Value text NOT NULL,
	PRIMARY KEY (CustomDataId),
	KEY ResourceId (ResourceId),
	KEY CustomFieldId (CustomFieldId)
	)

	# --------------------------------------------------------

	CREATE TABLE EmailMessage (
	EmailMessageId int(10) NOT NULL auto_increment,
	Template longtext,
	MessageType enum('html','text') NOT NULL default 'text',
	LanguageId int(11) NOT NULL default '0',
	EventId int(11) NOT NULL default '0',
	PRIMARY KEY (EmailMessageId)
	)

	# --------------------------------------------------------

	CREATE TABLE EmailQueue (
	Subject text NOT NULL,
	toaddr text NOT NULL,
	fromaddr text NOT NULL,
	message blob,
	headers blob,
	queued timestamp NOT NULL
	)

	# --------------------------------------------------------

	CREATE TABLE EmailSubscribers (
	EmailMessageId int(11) NOT NULL default '0',
	PortalUserId int(11) NOT NULL default '0'
	)

	# --------------------------------------------------------

	CREATE TABLE Events (
	EventId int(11) NOT NULL auto_increment,
	Event varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '1',
	FromUserId int(11) NOT NULL default '0',
	Module varchar(40) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	Type int(11) NOT NULL default '0',
	PRIMARY KEY (EventId)
	)

	# --------------------------------------------------------

	CREATE TABLE Favorites (
	FavoriteId int(11) NOT NULL auto_increment,
	PortalUserId int(11) NOT NULL default '0',
	ResourceId int(11) NOT NULL default '0',
	ItemTypeId int(11) NOT NULL default '0',
	Modified int(11) NOT NULL default '0',
	PRIMARY KEY (FavoriteId),
	UNIQUE KEY main (PortalUserId,ResourceId)
	)

	# --------------------------------------------------------

	CREATE TABLE IdGenerator (
	lastid int(11) default NULL
	)

	# --------------------------------------------------------

	CREATE TABLE Images (
	ImageId int(11) NOT NULL auto_increment,
	ResourceId int(11) NOT NULL default '0',
	Url varchar(255) NOT NULL default '',
	Name varchar(255) NOT NULL default '',
	AltName varchar(255) default NULL,
	ImageIndex int(11) NOT NULL default '0',
	LocalImage tinyint(4) NOT NULL default '1',
	LocalPath varchar(240) NOT NULL default '',
	Enabled int(11) NOT NULL default '1',
	DefaultImg int(11) NOT NULL default '0',
	ThumbUrl varchar(255) default NULL,
	Priority int(11) NOT NULL default '0',
	ThumbPath varchar(255) default NULL,
	LocalThumb tinyint(4) NOT NULL default '0',
	SameImages tinyint(4) NOT NULL default '0',
	PRIMARY KEY (ImageId),
	KEY ResourceId (ResourceId)
	)

	# --------------------------------------------------------

	CREATE TABLE ItemRating (
	RatingId int(11) NOT NULL auto_increment,
	IPAddress varchar(255) NOT NULL default '',
	CreatedOn double NOT NULL default '0',
	RatingValue int(11) NOT NULL default '0',
	ItemId int(11) NOT NULL default '0',
	PRIMARY KEY (RatingId)
	)

	# --------------------------------------------------------

	CREATE TABLE ItemReview (
	ReviewId int(11) NOT NULL auto_increment,
	CreatedOn double NOT NULL default '0',
	ReviewText longtext NOT NULL,
	IPAddress varchar(255) NOT NULL default '',
	ItemId int(11) NOT NULL default '0',
	CreatedById int(11) NOT NULL default '0',
	ItemType tinyint(4) NOT NULL default '0',
	Priority int(11) NOT NULL default '0',
	Status tinyint(4) NOT NULL default '0',
	TextFormat int(11) NOT NULL default '0',
	Module varchar(255) NOT NULL default '',
	PRIMARY KEY (ReviewId)
	)

	# --------------------------------------------------------

	CREATE TABLE ItemTypes (
	ItemType int(11) NOT NULL default '0',
	Module varchar(50) NOT NULL default '',
	Prefix varchar(20) NOT NULL default '',
	SourceTable varchar(100) NOT NULL default '',
	TitleField varchar(50) default NULL,
	CreatorField varchar(255) NOT NULL default '',
	PopField varchar(255) default NULL,
	RateField varchar(255) default NULL,
	LangVar varchar(255) NOT NULL default '',
	PrimaryItem int(11) NOT NULL default '0',
	EditUrl varchar(255) NOT NULL default '',
	ClassName varchar(40) NOT NULL default '',
	ItemName varchar(50) NOT NULL default '',
	PRIMARY KEY (ItemType),
	KEY Module (Module)
	)

	# --------------------------------------------------------

	CREATE TABLE Language (
	LanguageId int(11) NOT NULL auto_increment,
	PackName varchar(40) NOT NULL default '',
	LocalName varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '0',
	PrimaryLang int(11) NOT NULL default '0',
	IconURL varchar(255) default NULL,
	DateFormat varchar(50) NOT NULL default '',
	TimeFormat varchar(50) NOT NULL default '',
	DecimalPoint char(2) NOT NULL default '.',
	ThousandSep char(1) NOT NULL default ',',
	Charset varchar(20) NOT NULL default '',
	UnitSystem tinyint(4) NOT NULL default '1',
	PRIMARY KEY (LanguageId)
	)

	# --------------------------------------------------------

	CREATE TABLE Modules (
	Name varchar(255) NOT NULL default '',
	Path varchar(255) NOT NULL default '',
	Var varchar(10) NOT NULL default '',
	Version varchar(10) NOT NULL default '',
	Loaded tinyint(4) NOT NULL default '1',
	LoadOrder tinyint(4) NOT NULL default '0',
	TemplatePath varchar(255) NOT NULL default '',
	RootCat int(11) NOT NULL default '0',
	BuildDate double NOT NULL default '0',
	PRIMARY KEY (Name)
	)

	# --------------------------------------------------------

	CREATE TABLE PermCache (
	PermCacheId int(11) NOT NULL auto_increment,
	CategoryId int(11) NOT NULL default '0',
	PermId int(11) NOT NULL default '0',
	ACL varchar(255) NOT NULL default '',
	DACL varchar(255) NOT NULL default '',
	PRIMARY KEY (PermCacheId),
	KEY CategoryId (CategoryId),
	KEY PermId (PermId)
	)

	# --------------------------------------------------------

	CREATE TABLE PermissionConfig (
	PermissionConfigId int(11) NOT NULL auto_increment,
	PermissionName varchar(30) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	ErrorMessage varchar(255) NOT NULL default '',
	ModuleId varchar(20) NOT NULL default '0',
	PRIMARY KEY (PermissionConfigId),
	KEY PermissionName (PermissionName)
	)

	# --------------------------------------------------------

	CREATE TABLE Permissions (
	PermissionId int(11) NOT NULL auto_increment,
	Permission varchar(30) NOT NULL default '',
	GroupId int(11) default '0',
	PermissionValue int(11) NOT NULL default '0',
	Type tinyint(4) NOT NULL default '0',
	CatId int(11) NOT NULL default '0',
	PRIMARY KEY (PermissionId)
	)

	# --------------------------------------------------------

	CREATE TABLE PersistantSessionData (
	PortalUserId int(11) NOT NULL default '0',
	VariableName varchar(255) NOT NULL default '',
	VariableValue text NOT NULL,
	PRIMARY KEY (PortalUserId,VariableName),
	KEY UserId (PortalUserId),
	KEY VariableName (VariableName)
	)
	# --------------------------------------------------------

	CREATE TABLE Phrase (
	Phrase varchar(255) NOT NULL default '',
	Translation text NOT NULL default '',
	PhraseType int(11) NOT NULL default '0',
	PhraseId int(11) NOT NULL auto_increment,
	LanguageId int(11) NOT NULL default '0',
	LastChanged int(10) unsigned NOT NULL default '0',
	LastChangeIP varchar(15) NOT NULL default '',
	Module varchar(30) NOT NULL default '',
	PRIMARY KEY (PhraseId),
	KEY LanguageId (LanguageId),
	INDEX Phrase_Index (Phrase)
	)

	# --------------------------------------------------------

	CREATE TABLE PhraseCache (
	Template varchar(40) NOT NULL default '',
	PhraseList text NOT NULL,
	CacheDate int(11) NOT NULL default '0',
	ThemeId int(11) NOT NULL default '0',
	StylesheetId int(10) unsigned NOT NULL default '0',
	PRIMARY KEY (Template)
	)

	# --------------------------------------------------------

	CREATE TABLE PortalGroup (
	GroupId int(11) NOT NULL auto_increment,
	Name varchar(255) NOT NULL default '',
	Description varchar(255) default NULL,
	CreatedOn double NOT NULL default '0',
	System tinyint(4) NOT NULL default '0',
	Personal tinyint(4) NOT NULL default '0',
	Enabled tinyint(4) NOT NULL default '1',
	ResourceId int(11) NOT NULL default '0',
	PRIMARY KEY (GroupId),
	UNIQUE KEY Name (Name),
	UNIQUE KEY ResourceId (ResourceId),
	KEY Personal (Personal),
	KEY Enabled (Enabled)
	)

	# --------------------------------------------------------

	CREATE TABLE PortalUser (
	PortalUserId int(11) NOT NULL auto_increment,
	Login varchar(255) default NULL,
	Password varchar(255) default NULL,
	FirstName varchar(255) default NULL,
	LastName varchar(255) default NULL,
	Email varchar(255) NOT NULL default '',
	CreatedOn double NOT NULL default '0',
	Phone varchar(20) default NULL,
	Street varchar(255) default NULL,
	City varchar(20) default NULL,
	State VARCHAR(20) NOT NULL,
	Zip varchar(20) default NULL,
	Country varchar(20) NOT NULL default '',
	ResourceId int(11) NOT NULL default '0',
	Status tinyint(4) NOT NULL default '2',
	Modified int(11) NOT NULL default '0',
	dob double NOT NULL default '0',
	tz int(11) default NULL,
	ip varchar(20) default NULL,
	IsBanned tinyint(1) NOT NULL default '0',
	PassResetTime bigint(20),
	PwResetConfirm varchar(255),
	PwRequestTime bigint(25),
	MinPwResetDelay int(11) NOT NULL default '1800',
	PRIMARY KEY (PortalUserId),
	UNIQUE KEY Login (Login),
	UNIQUE KEY ResourceId (ResourceId),
	KEY CreatedOn (CreatedOn)
	)

	# --------------------------------------------------------

	CREATE TABLE Relationship (
	RelationshipId int(11) NOT NULL auto_increment,
	SourceId int(11) default NULL,
	TargetId int(11) default NULL,
	SourceType tinyint(4) NOT NULL default '0',
	TargetType tinyint(4) NOT NULL default '0',
	Type int(11) NOT NULL default '0',
	Enabled int(11) NOT NULL default '1',
	Priority int(11) NOT NULL default '0',
	PRIMARY KEY (RelationshipId),
	KEY RelSource (SourceId),
	KEY RelTarget (TargetId)
	)

	# --------------------------------------------------------

	CREATE TABLE SearchConfig (
	TableName varchar(40) NOT NULL default '',
	FieldName varchar(40) NOT NULL default '',
	SimpleSearch tinyint(4) NOT NULL default '0',
	AdvancedSearch tinyint(4) NOT NULL default '0',
	Description varchar(255) default NULL,
	DisplayName varchar(80) default NULL,
	ModuleName varchar(20) default NULL,
	ConfigHeader varchar(255) default NULL,
	DisplayOrder int(11) NOT NULL default '0',
	SearchConfigId int(11) NOT NULL auto_increment,
	Priority int(11) NOT NULL default '0',
	FieldType varchar(20) NOT NULL default 'text',
	ForeignField TEXT,
	JoinClause TEXT,
	IsWhere text,
	IsNotWhere text,
	ContainsWhere text,
	NotContainsWhere text,
	CustomFieldId int(11) NOT NULL default '0',
	PRIMARY KEY (SearchConfigId)
	)

	# --------------------------------------------------------

	CREATE TABLE SearchLog (
	SearchLogId int(11) NOT NULL auto_increment,
	Keyword varchar(255) NOT NULL default '',
	Indices bigint(20) NOT NULL default '0',
	SearchType int(11) NOT NULL default '0',
	PRIMARY KEY (SearchLogId)
	)

	# --------------------------------------------------------

	CREATE TABLE IgnoreKeywords (
	keyword varchar(20) NOT NULL default '',
	PRIMARY KEY (keyword)
	)

	# --------------------------------------------------------

	CREATE TABLE SessionData (
	SessionKey varchar(50) NOT NULL default '',
	VariableName varchar(255) NOT NULL default '',
	VariableValue text NOT NULL,
	PRIMARY KEY (SessionKey,VariableName),
	KEY SessionKey (SessionKey),
	KEY VariableName (VariableName)
	)

	# --------------------------------------------------------

	CREATE TABLE SpamControl (
	ItemResourceId int(11) NOT NULL default '0',
	IPaddress varchar(20) NOT NULL default '',
	Expire double NOT NULL default '0',
	PortalUserId int(11) NOT NULL default '0',
	DataType varchar(20) default NULL
	)

	# --------------------------------------------------------

	CREATE TABLE StatItem (
	StatItemId int(11) NOT NULL auto_increment,
	Module varchar(20) NOT NULL default '',
	ValueSQL varchar(255) default NULL,
	ResetSQL varchar(255) default NULL,
	ListLabel varchar(255) NOT NULL default '',
	Priority int(11) NOT NULL default '0',
	AdminSummary int(11) NOT NULL default '0',
	PRIMARY KEY (StatItemId)
	)

	# --------------------------------------------------------

	CREATE TABLE Theme (
	ThemeId int(11) NOT NULL auto_increment,
	Name varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '1',
	Description varchar(255) default NULL,
	PrimaryTheme int(11) NOT NULL default '0',
	CacheTimeout int(11) NOT NULL default '0',
	StylesheetId INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (ThemeId)
	)

	# --------------------------------------------------------

	CREATE TABLE ThemeFiles (
	FileId int(11) NOT NULL auto_increment,
	ThemeId int(11) NOT NULL default '0',
	FileName varchar(255) NOT NULL default '',
	FilePath varchar(255) NOT NULL default '',
	Description varchar(255) default NULL,
	FileType int(11) NOT NULL default '0',
	PRIMARY KEY (FileId),
	KEY theme (ThemeId)
	)

	# --------------------------------------------------------

	CREATE TABLE UserGroup (
	PortalUserId int(11) NOT NULL default '0',
	GroupId int(11) NOT NULL default '0',
	MembershipExpires int(10) unsigned default NULL,
	PrimaryGroup tinyint(4) NOT NULL default '1',
	ExpirationReminderSent tinyint(4) NOT NULL default '0',
	PRIMARY KEY (PortalUserId,GroupId),
	KEY GroupId (GroupId),
	KEY PrimaryGroup (PrimaryGroup)
	)

	# --------------------------------------------------------



	CREATE TABLE UserSession (
	SessionKey varchar(50) NOT NULL default '',
	CurrentTempKey varchar(50) default NULL,
	PrevTempKey varchar(50) default NULL,
	LastAccessed double NOT NULL default '0',
	PortalUserId varchar(255) NOT NULL default '',
	Language varchar(255) NOT NULL default '',
	Theme varchar(255) NOT NULL default '',
	GroupId int(11) NOT NULL default '0',
	IpAddress varchar(20) NOT NULL default '0.0.0.0',
	Status int(11) NOT NULL default '1',
	GroupList varchar(255) default NULL,
	tz int(11) default NULL,
	PRIMARY KEY (SessionKey),
	KEY UserId (PortalUserId),
	KEY LastAccessed (LastAccessed)
	)

	# --------------------------------------------------------

	CREATE TABLE SuggestMail (
	email varchar(255) NOT NULL default '',
	sent double,
	PRIMARY KEY (email)
	)

	# --------------------------------------------------------

	CREATE TABLE SysCache (
	SysCacheId int(11) NOT NULL auto_increment,
	Name varchar(255) NOT NULL default '',
	Value mediumtext,
	Expire double NOT NULL default '0',
	Module varchar(20) default NULL,
	Context varchar(255) default NULL,
	GroupList varchar(255) NOT NULL default '',
	PRIMARY KEY (SysCacheId),
	KEY Name (Name)
	)

	# --------------------------------------------------------

	CREATE TABLE TagLibrary (
	TagId int(11) NOT NULL auto_increment,
	name varchar(255) NOT NULL default '',
	description text,
	example text,
	scope varchar(20) NOT NULL default 'global',
	PRIMARY KEY (TagId)
	)

	# --------------------------------------------------------

	CREATE TABLE TagAttributes (
	AttrId int(11) NOT NULL auto_increment,
	TagId int(11) NOT NULL default '0',
	Name varchar(255) NOT NULL default '',
	AttrType varchar(20) default NULL,
	DefValue varchar(255) default NULL,
	Description TEXT,
	Required int(11) NOT NULL default '0',
	PRIMARY KEY (AttrId)
	)

	# --------------------------------------------------------

	CREATE TABLE EmailLog (
	EmailLogId int(11) NOT NULL auto_increment,
	fromuser varchar(200) default NULL,
	addressto varchar(255) default NULL,
	subject varchar(255) default NULL,
	timestamp bigint(20) default '0',
	event varchar(100) default NULL,
	PRIMARY KEY (EmailLogId)
	)

	# --------------------------------------------------------

	CREATE TABLE ImportScripts (
	is_id smallint(5) unsigned NOT NULL auto_increment,
	is_Module varchar(50) NOT NULL default '',
	is_string_id varchar(10) NOT NULL default '',
	is_script varchar(100) NOT NULL default '',
	is_label varchar(255) NOT NULL default '',
	is_field_prefix varchar(50) NOT NULL default '',
	is_requred_fields varchar(255) NOT NULL default '',
	is_enabled tinyint(1) unsigned NOT NULL default '0',
	+ is_type varchar(10) NOT NULL default '',
	PRIMARY KEY (is_id)
	)

	# --------------------------------------------------------

	CREATE TABLE Cache (
	VarName varchar(255) NOT NULL default '',
	Data longtext,
	Cached int(11) default NULL,
	PRIMARY KEY (VarName),
	KEY Cached (Cached)
	)
	# --------------------------------------------------------
	CREATE TABLE StylesheetSelectors (
	SelectorId int(11) NOT NULL auto_increment,
	StylesheetId int(11) NOT NULL default '0',
	Name varchar(255) NOT NULL default '',
	SelectorName varchar(255) NOT NULL default '',
	SelectorData text NOT NULL,
	Description text NOT NULL,
	Type tinyint(4) NOT NULL default '0',
	AdvancedCSS text NOT NULL,
	ParentId int(11) NOT NULL default '0',
	PRIMARY KEY (SelectorId)
	)
	# --------------------------------------------------------
	CREATE TABLE Stylesheets (
	StylesheetId int(11) NOT NULL auto_increment,
	Name varchar(255) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	AdvancedCSS text NOT NULL,
	LastCompiled int(10) unsigned NOT NULL default '0',
	Enabled int(11) NOT NULL default '0',
	PRIMARY KEY (StylesheetId)
	)
	# --------------------------------------------------------

	CREATE TABLE StdDestinations (
	DestId int(11) NOT NULL auto_increment,
	DestType int(11) NOT NULL default '0',
	DestParentId int(11) default NULL,
	DestName varchar(255) NOT NULL default '',
	DestAbbr char(3) NOT NULL default '',
	DestAbbr2 char(2) default '',
	PRIMARY KEY (DestId)
	)
	# --------------------------------------------------------
	CREATE TABLE Visits (
	VisitId int(11) NOT NULL auto_increment,
	VisitDate int(10) unsigned NOT NULL default '0',
	Referer varchar(255) NOT NULL default '',
	IPAddress varchar(15) NOT NULL default '',
	AffiliateId int(10) unsigned NOT NULL default '0',
	PortalUserId int(11) NOT NULL default '0',
	PRIMARY KEY (VisitId),
	KEY PortalUserId (PortalUserId),
	KEY AffiliateId (AffiliateId)
	)
	# --------------------------------------------------------
	\ No newline at end of file

	Property changes on: trunk/admin/install/inportal_schema.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.37
	\ No newline at end of property
	+1.38
	\ No newline at end of property
	Index: trunk/admin/import/step2.php
	===================================================================
	--- trunk/admin/import/step2.php (revision 3647)
	+++ trunk/admin/import/step2.php (revision 3648)
	@@ -1,72 +1,75 @@
	<?php

	// new startup: begin
	define('REL_PATH', 'admin/import');
	$relation_level = count( explode('/', REL_PATH) );
	define('FULL_PATH', realpath(dirname(__FILE__) . str_repeat('/..', $relation_level) ) );
	require_once FULL_PATH.'/kernel/startup.php';
	// new startup: end

	$pathtolocal = $pathtoroot."kernel/";
	require_once ($pathtoroot.$admin."/include/elements.php");
	require_once ($pathtoroot."kernel/admin/include/navmenu.php");
	require_once ($pathtolocal."admin/include/navmenu.php");
	require_once($pathtoroot.$admin."/toolbar.php");
	//Set Section
	$section = "in-portal:main_import";

	//Set Environment Variable
	$envar = "env=" . BuildEnv();
	$var = '?env='.BuildEnv();

	$sec = $objSections->GetSection($section);
	$objCatToolBar = new clsToolBar();

	// Previous Button
	$MouseOver="swap('moveleft','toolbar/tool_prev_f2.gif');";
	$MouseOut="swap('moveleft', 'toolbar/tool_prev.gif');";
	$link = $adminURL.'/import/step1.php'.$var;
	$objCatToolBar->Add('moveleft','la_ToolTip_PreviousStep', $link, $MouseOver, $MouseOut,'','tool_prev.gif');

	// Next Button
	$MouseOver = "if( ChoiseMade('import_form','choose') !== false ) swap('moveright','toolbar/tool_next_f2.gif');";
	$MouseOut = "if( ChoiseMade('import_form','choose') !== false ) swap('moveright', 'toolbar/tool_next.gif');";

	if($ro_perm)
	{
	$click_url = $adminURL."/import/step1.php".$var;
	$onClick = "if( ChoiseMade('import_form','choose') ) document.location= '$click_url'; ";
	}
	else
	{
	- $click_url = $adminURL."/import/step3.php".$var;
	+ $application =& kApplication::Instance();
	+ $click_url = $application->HREF('import_redirect', '', null, 'index4.php'); // $adminURL."/import/step3.php".$var;
	$onClick = "ImportRedirect('import_form', ChoiseMade('import_form','choose'), '$click_url');";
	}
	$objCatToolBar->Add("moveright",'la_ToolTip_NextStep','#',$MouseOver,$MouseOut,$onClick,"tool_next_f3.gif");

	// header
	$title = admin_language("la_performing_import")." - ".admin_language("la_Step")." 2";
	int_header($objCatToolBar,NULL,$title);
	-
	+
	+ $objSession->SetVariable("ReturnScript", 'browse.php'); // return to catalog if import is made
	+
	?>
	<form name="import_form" id="import_form" method="post" action="<?php echo $click_url; ?>">
	<input type="hidden" name="import_id" id="import_id" value="">
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">

	<?php int_subsection_title("Import Source"); ?>
	<tr <?php echo int_table_color(); ?>>
	<td><span class="text">Select the program you are importing the data from:</span></td>
	</tr>
	<tr <?php echo int_table_color(); ?>>
	<td>
	<?php
	foreach($import_scripts as $id => $iscript)
	echo '<input type="radio" name="choose" id="ch'.$id.'" value="'.$id.'" onclick="swap(\'moveright\', \'toolbar/tool_next.gif\')"'.(!$iscript['enabled'] ? ' disabled="true"' : '').'><span class="text"><label for="ch'.$id.'">'.$iscript['label'].'</label></span><br />'."\n";
	?>
	</td>
	</tr>
	</table>
	</form>
	<?php
	int_footer();
	?>
	\ No newline at end of file

	Property changes on: trunk/admin/import/step2.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.5
	\ No newline at end of property
	+1.6
	\ No newline at end of property
	Index: trunk/admin/import/step3.php
	===================================================================
	--- trunk/admin/import/step3.php (revision 3647)
	+++ trunk/admin/import/step3.php (revision 3648)
	@@ -1,92 +1,91 @@
	<?php

	// new startup: begin
	define('REL_PATH', 'admin/import');
	$relation_level = count( explode('/', REL_PATH) );
	define('FULL_PATH', realpath(dirname(__FILE__) . str_repeat('/..', $relation_level) ) );
	require_once FULL_PATH.'/kernel/startup.php';
	// new startup: end

	//admin only util
	$pathtolocal = $pathtoroot."kernel/";
	require_once ($pathtoroot.$admin."/include/elements.php");
	require_once ($pathtoroot."kernel/admin/include/navmenu.php");
	require_once ($pathtolocal."admin/include/navmenu.php");
	require_once($pathtoroot.$admin."/toolbar.php");
	//Set Section
	$section = "in-portal:main_import";

	//Set Environment Variable
	$envar = "env=" . BuildEnv();
	$var = "?env=".BuildEnv();

	-
	- if( isset($_POST['import_id']) ) $objSession->SetVariable('ImportScriptID', $_POST['import_id']);
	+// if( isset($_POST['import_id']) ) $objSession->SetVariable('ImportScriptID', $_POST['import_id']);
	$import_script = GetImportScript( $objSession->GetVariable('ImportScriptID') );


	$sec = $objSections->GetSection($section);
	$objCatToolBar = new clsToolBar();

	// Previous Button
	$MouseOver = "swap('moveleft','toolbar/tool_prev_f2.gif');";
	$MouseOut = "swap('moveleft', 'toolbar/tool_prev.gif');";
	$link = $adminURL."/import/step2.php".$var;
	$objCatToolBar->Add("moveleft",admin_language("la_ToolTip_Previous")." ".admin_language("la_Text_Step"),$link,$MouseOver,$MouseOut,"","tool_prev.gif");

	// Next Button
	$MouseOver = "swap('moveright','toolbar/tool_next_f2.gif');";
	$MouseOut = "swap('moveright', 'toolbar/tool_next.gif');";
	$link2 = $adminURL."/import/step4.php".$var;
	$onClick = "document.import_form.submit();";
	$objCatToolBar->Add("moveright",admin_language("la_ToolTip_Next")." ".admin_language("la_Text_Step"),'#',$MouseOver,$MouseOut,$onClick,"tool_next.gif");

	// Header
	$title = admin_language("la_performing_import")." - ".admin_language("la_Step")." 3";
	int_header($objCatToolBar,NULL,$title);
	?>

	<form name="import_form" METHOD="POST" action='<?php echo $adminURL."/import/step4.php".$var ; ?>' >
	<input type="hidden" name="Action" value="checkconn">
	<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
	<?php int_subsection_title(admin_language("la_prompt_DatabaseSettings").' - '.$import_script['label']); ?>
	<tr <?php echo int_table_color(); ?>>
	<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_SqlType"); ?></span></td>
	<td>
	<select name="db_sql_type" style="width: 197px;">
	<option value="mysql" selected>MySQL</option>
	</select>
	</td>
	</tr>
	<tr <?php echo int_table_color(); ?>>
	<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_Server"); ?></span></td>
	<td>
	<input type="text" name="db_server" class="text" size="30" value="<?php echo $objSession->GetVariable("import_server"); ?>">
	</td>
	</tr>
	<tr <?php echo int_table_color(); ?>>
	<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbName"); ?></span></td>
	<td>
	<input type="text" name="db_db" class="text" size="30" value="<?php echo $objSession->GetVariable("import_db"); ?>">
	</td>
	</tr>
	<tr <?php echo int_table_color(); ?>>
	<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbUsername"); ?></span></td>
	<td>
	<input type="text" name="db_user" class="text" size="30" value="<?php echo $objSession->GetVariable("import_user"); ?>">
	</td>
	</tr>
	<tr <?php echo int_table_color(); ?>>
	<td width="60%" valign="top"><span class="text"><?php echo $import_script['field_prefix'].' '.admin_language("la_prompt_DbPass"); ?></span></td>
	<td>
	<input type="password" name="db_pass" class="text" size="30" value="<?php echo $objSession->GetVariable("import_pass"); ?>">
	</td>
	</tr>
	<tr>
	<td colspan="2"><span class="error"><?php echo $objSession->GetVariable("error_importing"); ?></span></td>
	</tr>
	</table>
	</form>
	<?php
	int_footer();
	?>
	\ No newline at end of file

	Property changes on: trunk/admin/import/step3.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.5
	\ No newline at end of property
	+1.6
	\ No newline at end of property
	Index: trunk/core/kernel/processors/main_processor.php
	===================================================================
	--- trunk/core/kernel/processors/main_processor.php (revision 3647)
	+++ trunk/core/kernel/processors/main_processor.php (revision 3648)
	@@ -1,823 +1,857 @@
	<?php

	class kMainTagProcessor extends TagProcessor {

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

	$actions =& $this->Application->recallObject('kActions');
	$actions->Set('t', $this->Application->GetVar('t'));
	$actions->Set('sid', $this->Application->GetSID());
	$actions->Set('m_opener', $this->Application->GetVar('m_opener') );

	}

	/**
	* Used to handle calls where tag name
	* match with existing php function name
	*
	* @param Tag $tag
	* @return string
	*/
	function ProcessTag(&$tag)
	{
	if ($tag->Tag=='include') $tag->Tag='MyInclude';
	return parent::ProcessTag($tag);
	}

	/**
	* Creates <base href ..> HTML tag for all templates
	* affects future css, js files and href params of links
	*
	* @return string
	* @access public
	*/
	function Base_Ref()
	{
	$url = $this->Application->BaseURL().substr(THEMES_PATH,1).'/';
	return '<base href="'.$url.'" />';
	}

	/**
	* Returns base url for web-site
	*
	* @return string
	* @access public
	*/
	function BaseURL()
	{
	return $this->Application->BaseURL();
	}

	function TemplatesBase($params)
	{
	return $this->Application->BaseURL().THEMES_PATH;
	}

	function ProjectBase($params)
	{
	return $this->Application->BaseURL();
	}

	/*function Base($params)
	{
	return $this->Application->BaseURL().$params['add'];
	}*/

	/**
	* Used to create link to any template.
	* use "pass" paramter if "t" tag to specify
	* prefix & special of object to be represented
	* in resulting url
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function T($params)
	{
	//by default link to current template
	$t = $this->SelectParam($params, 't,template');
	unset($params['t']);
	unset($params['template']);
	$prefix=isset($params['prefix']) ? $params['prefix'] : ''; unset($params['prefix']);
	$index_file = isset($params['index_file']) ? $params['index_file'] : null; unset($params['index_file']);

	return $this->Application->HREF($t, $prefix, $params, $index_file);
	}

	function Link($params)
	{
	if (isset($params['template'])) {
	$params['t'] = $params['template'];
	unset($params['template']);
	}
	if (!isset($params['pass']) && !isset($params['no_pass'])) $params['pass'] = 'm';
	if (isset($params['no_pass'])) unset($params['no_pass']);

	if( $this->Application->GetVar('admin') ) $params['admin'] = 1;

	return $this->T($params);
	}

	function Env($params)
	{
	$t = $params['template'];
	unset($params['template']);
	return $this->Application->BuildEnv($t, $params, 'm', null, false);
	}

	function FormAction($params)
	{
	return $this->Application->ProcessParsedTag('m', 't', Array( 'pass'=>'all,m' ) );
	}

	/*// NEEDS TEST
	function Config($params)
	{
	return $this->Application->ConfigOption($params['var']);
	}

	function Object($params)
	{
	$name = $params['name'];
	$method = $params['method'];

	$tmp =& $this->Application->recallObject($name);
	if ($tmp != null) {
	if (method_exists($tmp, $method))
	return $tmp->$method($params);
	else
	echo "Method $method does not exist in object ".get_class($tmp)." named $name<br>";
	}
	else
	echo "Object $name does not exist in the appliaction<br>";
	}*/

	/**
	* Tag, that always returns true.
	* For parser testing purposes
	*
	* @param Array $params
	* @return bool
	* @access public
	*/
	function True($params)
	{
	return true;
	}

	/**
	* Tag, that always returns false.
	* For parser testing purposes
	*
	* @param Array $params
	* @return bool
	* @access public
	*/
	function False($params)
	{
	return false;
	}

	/**
	* Returns block parameter by name
	*
	* @param Array $params
	* @return stirng
	* @access public
	*/
	function Param($params)
	{
	//$parser =& $this->Application->recallObject('TemplateParser');
	$res = $this->Application->Parser->GetParam($params['name']);
	if ($res === false) $res = '';
	if (isset($params['plus']))
	$res += $params['plus'];
	return $res;
	}

	/**
	* Compares block parameter with value specified
	*
	* @param Array $params
	* @return bool
	* @access public
	*/
	function ParamEquals($params)
	{
	//$parser =& $this->Application->recallObject('TemplateParser');
	$name = $this->SelectParam($params, 'name,var,param');
	$value = $params['value'];
	return ($this->Application->Parser->GetParam($name) == $value);
	}

	/*function PHP_Self($params)
	{
	return $HTTP_SERVER_VARS['PHP_SELF'];
	}
	*/

	/**
	* Returns session variable value by name
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Recall($params)
	{
	$ret = $this->Application->RecallVar( $this->SelectParam($params,'name,var,param') );
	$ret = ($ret === false && isset($params['no_null'])) ? '' : $ret;
	if( getArrayValue($params,'special') \|\| getArrayValue($params,'htmlchars')) $ret = htmlspecialchars($ret);

	if ( getArrayValue($params, 'urlencode') ) $ret = urlencode($ret);

	return $ret;
	}

	// bad style to store something from template to session !!! (by Alex)
	// Used here only to test how session works, nothing more
	function Store($params)
	{
	//echo"Store $params[name]<br>";
	$name = $params['name'];
	$value = $params['value'];
	$this->Application->StoreVar($name,$value);
	}

	/**
	* Sets application variable value(-s)
	*
	* @param Array $params
	* @access public
	*/
	function Set($params)
	{
	foreach ($params as $param => $value) {
	$this->Application->SetVar($param, $value);
	}
	}

	/**
	* Increment application variable
	* specified by number specified
	*
	* @param Array $params
	* @access public
	*/
	function Inc($params)
	{
	$this->Application->SetVar($params['param'], $this->Application->GetVar($params['param']) + $params['by']);
	}

	/**
	* Retrieves application variable
	* value by name
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Get($params)
	{
	$ret = $this->Application->GetVar($this->SelectParam($params, 'name,var,param'), EMPTY_ON_NULL);
	return getArrayValue($params, 'htmlchars') ? htmlspecialchars($ret) : $ret;
	}

	/**
	* Retrieves application constant
	* value by name
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function GetConst($params)
	{
	return defined($this->SelectParam($params, 'name,const')) ? constant($this->SelectParam($params, 'name,const,param')) : '';
	}

	/**
	* Retrieves configuration variable value by name
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function GetConfig($params)
	{
	$config_name = $this->SelectParam($params, 'name,var');
	$ret = $this->Application->ConfigValue($config_name);
	if( getArrayValue($params, 'escape') ) $ret = addslashes($ret);
	return $ret;
	}

	function ConfigEquals($params)
	{
	$option = $this->SelectParam($params, 'name,option,var');
	return $this->Application->ConfigValue($option) == getArrayValue($params, 'value');
	}

	/**
	* Creates all hidden fields
	* needed for kernel_form
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function DumpSystemInfo($params)
	{
	$actions =& $this->Application->recallObject('kActions');
	$actions->Set('t', $this->Application->GetVar('t') );

	$params = $actions->GetParams();
	$o='';
	foreach ($params AS $name => $val)
	{
	$o .= "<input type='hidden' name='$name' id='$name' value='$val'>\n";
	}
	return $o;
	}

	function GetFormHiddens($params)
	{
	$sid = $this->Application->GetSID();
	$t = $this->SelectParam($params, 'template,t');
	unset($params['template']);
	$env = $this->Application->BuildEnv($t, $params, 'm', null, false);
	$o = '';
	if ( $this->Application->RewriteURLs() )
	{
	$session =& $this->Application->recallObject('Session');
	if ($session->NeedQueryString()) {
	$o .= "<input type='hidden' name='sid' id='sid' value='$sid'>\n";
	}
	}
	else {
	$o .= "<input type='hidden' name='env' id='env' value='$env'>\n";
	}
	return $o;
	}

	function Odd_Even($params)
	{
	$odd = $params['odd'];
	$even = $params['even'];
	if (!isset($params['var'])) {
	$var = 'odd_even';
	}
	else {
	$var = $params['var'];
	}

	if ($this->Application->GetVar($var) == 'even') {
	if (!isset($params['readonly']) \|\| !$params['readonly']) {
	$this->Application->SetVar($var, 'odd');
	}
	return $even;
	}
	else {
	if (!isset($params['readonly']) \|\| !$params['readonly']) {
	$this->Application->SetVar($var, 'even');
	}
	return $odd;
	}
	}

	/**
	* Returns phrase translation by name
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Phrase($params)
	{
	// m:phrase name="phrase_name" default="Tr-alala" updated="2004-01-29 12:49"
	if (array_key_exists('default', $params)) return $params['default']; //backward compatibility
	return $this->Application->Phrase($this->SelectParam($params, 'label,name,title'));
	}

	// for tabs
	function is_active($params)
	{
	$test_templ = $this->SelectParam($params, 'templ,template,t');
	if ( !getArrayValue($params,'allow_empty') )
	{
	$if_true=getArrayValue($params,'true') ? $params['true'] : 1;
	$if_false=getArrayValue($params,'false') ? $params['false'] : 0;
	}
	else
	{
	$if_true=$params['true'];
	$if_false=$params['false'];
	}

	if ( preg_match("/^".str_replace('/', '\/', $test_templ)."/", $this->Application->GetVar('t'))) {
	return $if_true;
	}
	else {
	return $if_false;
	}
	}

	function IsNotActive($params)
	{
	return !$this->is_active($params);
	}

	function IsActive($params)
	{
	return $this->is_active($params);
	}

	function is_t_active($params)
	{
	return $this->is_active($params);
	}

	function CurrentTemplate($params)
	{
	return $this->is_active($params);
	}

	/**
	* Checks if session variable
	* specified by name value match
	* value passed as parameter
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function RecallEquals($params)
	{
	$name = $params['var'];
	$value = $params['value'];
	return ($this->Application->RecallVar($name) == $value);
	}

	/**
	* Checks if application variable
	* specified by name value match
	* value passed as parameter
	*
	* @param Array $params
	* @return bool
	* @access public
	*/
	function GetEquals($params)
	{
	$name = $this->SelectParam($params, 'var,name,param');
	$value = $params['value'];
	if ($this->Application->GetVar($name) == $value) {
	return 1;
	}
	}

	/**
	* Includes template
	* and returns it's
	* parsed version
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function MyInclude($params)
	{
	$BlockParser =& $this->Application->makeClass('TemplateParser');
	$BlockParser->SetParams($params);
	$parser =& $this->Application->Parser;
	$this->Application->Parser =& $BlockParser;

	$t = $this->SelectParam($params, 't,template,block,name');
	$t = eregi_replace("\.tpl$", '', $t);

	$templates_cache =& $this->Application->recallObject('TemplatesCache');

	$res = $BlockParser->Parse( $templates_cache->GetTemplateBody($t), $t );

	if ( !$BlockParser->DataExists && (isset($params['data_exists']) \|\| isset($params['block_no_data'])) ) {
	if ($block_no_data = getArrayValue($params, 'block_no_data')) {
	$res = $BlockParser->Parse(
	$templates_cache->GetTemplateBody($block_no_data, $silent),
	$t
	);
	}
	else {
	$res = '';
	}
	}
	$this->Application->Parser =& $parser;
	$this->Application->Parser->DataExists = $this->Application->Parser->DataExists \|\| $BlockParser->DataExists;
	return $res;
	}

	/*function Kernel_Scripts($params)
	{
	return '<script type="text/javascript" src="'.PROTOCOL.SERVER_NAME.BASE_PATH.'/kernel3/js/grid.js"></script>';
	}*/


	/*function GetUserPermission($params)
	{
	// echo"GetUserPermission $params[name]";
	if ($this->Application->RecallVar('user_type') == 1)
	return 1;
	else {
	$perm_name = $params[name];
	$aPermissions = unserialize($this->Application->RecallVar('user_permissions'));
	if ($aPermissions)
	return $aPermissions[$perm_name];
	}
	}*/


	/**
	* Set's parser block param value
	*
	* @param Array $params
	* @access public
	*/
	function AddParam($params)
	{
	$parser =& $this->Application->Parser; // recallObject('TemplateParser');
	foreach ($params as $param => $value) {
	$this->Application->SetVar($param, $value);
	$parser->SetParam($param, $value);
	$parser->AddParam('/\$'.$param.'/', $value);
	}
	}

	/*function ParseToVar($params)
	{
	$var = $params['var'];
	$tagdata = $params['tag'];
	$parser =& $this->Application->Parser; //recallObject('TemplateParser');
	$res = $this->Application->ProcessTag($tagdata);

	$parser->SetParam($var, $res);
	$parser->AddParam('/\$'.$var.'/', $res);
	return '';
	}*/

	/*function TagNotEmpty($params)
	{
	$tagdata = $params['tag'];
	$res = $this->Application->ProcessTag($tagdata);
	return $res != '';
	}*/

	/*function TagEmpty($params)
	{
	return !$this->TagNotEmpty($params);
	}*/

	/**
	* Parses block and returns result
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function ParseBlock($params)
	{
	$parser =& $this->Application->Parser; // recallObject('TemplateParser');
	return $parser->ParseBlock($params);
	}

	function RenderElement($params)
	{
	return $this->ParseBlock($params);
	}

	/**
	* Checks if debug mode is on
	*
	* @return bool
	* @access public
	*/
	function IsDebugMode()
	{
	return $this->Application->isDebugMode();
	}

	function MassParse($params)
	{
	$qty = $params['qty'];
	$block = $params['block'];
	$mode = $params['mode'];

	$o = '';
	if ($mode == 'func') {
	$func = create_function('$params', '
	$o = \'<tr>\';
	$o.= \'<td>a\'.$params[\'param1\'].\'</td>\';
	$o.= \'<td>a\'.$params[\'param2\'].\'</td>\';
	$o.= \'<td>a\'.$params[\'param3\'].\'</td>\';
	$o.= \'<td>a\'.$params[\'param4\'].\'</td>\';
	$o.= \'</tr>\';
	return $o;
	');
	for ($i=1; $i<$qty; $i++) {
	$block_params['param1'] = rand(1, 10000);
	$block_params['param2'] = rand(1, 10000);
	$block_params['param3'] = rand(1, 10000);
	$block_params['param4'] = rand(1, 10000);
	$o .= $func($block_params);
	}
	return $o;
	}

	$block_params['name'] = $block;

	for ($i=0; $i<$qty; $i++) {
	$block_params['param1'] = rand(1, 10000);
	$block_params['param2'] = rand(1, 10000);
	$block_params['param3'] = rand(1, 10000);
	$block_params['param4'] = rand(1, 10000);
	$block_params['passed'] = $params['passed'];
	$block_params['prefix'] = 'm';

	$o.= $this->Application->ParseBlock($block_params, 1);
	}
	return $o;
	}

	function AfterScript($params)
	{
	$after_script = $this->Application->GetVar('after_script');
	if ( $after_script ) {
	return '<script type="text/javascript">'.$after_script.'</script>';
	}
	return '';
	}

	function LoggedIn($params)
	{
	return $this->Application->LoggedIn();
	}

	/**
	* Checks if user is logged in and if not redirects it to template passed
	*
	* @param Array $params
	*/
	function RequireLogin($params)
	{
	if($permission_groups = getArrayValue($params, 'permissions'))
	{
	$permission_groups = explode('\|', $permission_groups);
	$group_has_permission = false;
	foreach($permission_groups as $permission_group)
	{
	$permissions = explode(',', $permission_group);
	$has_permission = true;
	foreach($permissions as $permission)
	{
	$has_permission = $has_permission && $this->Application->CheckPermission($permission);
	}
	$group_has_permission = $group_has_permission \|\| $has_permission;

	if($group_has_permission)
	{
	return;
	}
	}

	if( !$this->Application->LoggedIn() )
	{
	$t = $this->Application->GetVar('t');
	$this->Application->Redirect( $params['login_template'], Array('next_template'=>$t) );
	}
	else
	{
	$this->Application->Redirect( $params['no_permissions_template'] );
	}
	}

	$condition = getArrayValue($params,'condition');
	if(!$condition)
	{
	$condition = true;
	}
	else
	{
	if( substr($condition,0,1) == '!' )
	{
	$condition = !$this->Application->ConfigValue( substr($condition,1) );
	}
	else
	{
	$condition = $this->Application->ConfigValue($condition);
	}
	}

	$group = $this->SelectParam($params, 'group');
	$group_access = true;
	if ($group) {
	$conn =& $this->Application->DB;
	$group_id = $conn->GetOne('SELECT GroupId FROM '.TABLE_PREFIX.'PortalGroup WHERE Name = '.$conn->qstr($group));
	if ($group_id) {
	$groups = explode(',', $this->Application->RecallVar('UserGroups'));
	$group_access = in_array($group_id, $groups);
	}
	}

	if( (!$this->Application->LoggedIn() \|\| !$group_access) && $condition )
	{
	$t = $this->Application->GetVar('t');
	$this->Application->Redirect( $params['login_template'], Array('next_template'=>$t) );
	}
	}

	/**
	* Checks if SSL is on and redirects to SSL URL if needed
	* If SSL_URL is not defined in config - the tag does not do anything
	* If for_logged_in_only="1" exits if user is not logged in.
	* If called without params forces https right away. If called with by_config="1" checks the
	* Require SSL setting from General Config and if it is ON forces https
	*
	* @param unknown_type $params
	*/
	function CheckSSL($params)
	{
	$ssl = $this->Application->ConfigValue('SSL_URL');
	if (!$ssl) return; //SSL URL is not set - no way to require SSL

	$require = false;

	if ($params['mode'] == 'required') {
	$require = true;
	if (isset($params['for_logged_in_only']) && $params['for_logged_in_only'] && !$this->Application->LoggedIn()) {
	$require = false;
	}

	if (isset($params['condition'])) {
	if (!$this->Application->ConfigValue($params['condition'])) {
	$require = false;
	}
	}
	}

	$http_query =& $this->Application->recallObject('HTTPQuery');
	$pass = $http_query->getRedirectParams();

	if ($require) {
	if (PROTOCOL == 'https://') {
	$this->Application->SetVar('__KEEP_SSL__', 1);
	return;
	}
	$this->Application->Redirect('', array_merge_recursive2($pass, Array('__SSL__' => 1)));
	}
	else {
	if (PROTOCOL == 'https://' && $this->Application->ConfigValue('Force_HTTP_When_SSL_Not_Required')) {
	if ($this->Application->GetVar('__KEEP_SSL__')) return;
	$this->Application->Redirect('', array_merge_recursive2($pass, Array('__SSL__' => 0)));
	}
	}
	}

	function SaveReturnScript($params)
	{
	// admin/save_redirect.php?do=
	$url = str_replace($this->Application->BaseURL(), '', $this->T($params) );
	$url = explode('?', $url, 2);
	$url = 'save_redirect.php?'.$url[1].'&do='.$url[0];

	$this->Application->StoreVar('ReturnScript', $url);
	}

	function ConstOn($params)
	{
	$name = $this->SelectParam($params,'name,const');
	return $this->Application->isDebugMode() && dbg_ConstOn($name);
	}

	function SetDefaultCategory($params)
	{
	$module_name = $params['module'];
	$module =& $this->Application->recallObject('mod.'.$module_name);
	$this->Application->SetVar('m_cat_id', $module->GetDBField('RootCat') );
	}
	+
	+ function ImportRedirect($params)
	+ {
	+ $import_id = $this->Application->GetVar('import_id');
	+ if ($import_id) {
	+ // redirect forward to step3 (import parameters coosing)
	+ $this->Application->StoreVar('ImportScriptID', $import_id);
	+
	+ $sql = 'SELECT *
	+ FROM '.TABLE_PREFIX.'ImportScripts
	+ WHERE is_id = '.$import_id;
	+
	+ $db =& $this->Application->GetADODBConnection();
	+ $is_params = $db->GetRow($sql);
	+
	+ if ($is_params['is_type'] == 'db') {
	+ $this->Application->Redirect('', null, '', 'import/step3.php');
	+ }
	+ elseif ($is_params['is_type'] == 'csv') {
	+ $module = strtolower($is_params['is_Module']);
	+ $template = $module.'/import';
	+ $sql = 'SELECT Var
	+ FROM '.TABLE_PREFIX.'Modules
	+ WHERE LOWER(Name) = '.$db->qstr($module);
	+ $item_prefix = $db->GetOne($sql);
	+ $pass_params = Array('m_opener' => 'd', $item_prefix.'.import_id' => 0, $item_prefix.'.import_event' => 'OnNew', 'pass' => 'm,'.$item_prefix.'.import');
	+ $this->Application->Redirect($template, $pass_params);
	+ }
	+ }
	+ else {
	+ // redirect back to step2 (import type choosing)
	+ $this->Application->Redirect('', null, '', 'import/step2.php');
	+ }
	+ }

	/*
	function Login($params)
	{
	$user_prefix = 'users';
	$this->parser->registerprefix($user_prefix);
	$user_class = $this->parser->processors[$user_prefix]->item_class;

	$candidate = new $user_class(NULL, $this->parser->processors[$user_prefix]);
	//print_pre($this->Session->Property);

	$special = array_shift($params);
	//echo"$special<br>";
	$candidate_id = $candidate->Login($this->Session->GetProperty('username'), $this->Session->GetProperty('password'), $special);

	if ($candidate_id !== false) {
	$this->Session->SetField('user_id', $candidate_id);
	$this->Session->Update();
	$this->Session->AfterLogin();

	$this->parser->register_prefix('m');
	$template = array_shift($params);
	if ($template == '') $template = 'index';
	$location = $this->parser->do_process_tag('m', 't', Array($template));
	header("Location: $location");
	exit;
	}
	elseif ($this->Session->GetProperty('username') != '') {
	$this->Session->SetProperty('login_error', 'Incorrect username or password');
	}
	}
	*/

	}


	?>

	Property changes on: trunk/core/kernel/processors/main_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.31
	\ No newline at end of property
	+1.32
	\ No newline at end of property
	Index: trunk/core/kernel/utility/debugger.php
	===================================================================
	--- trunk/core/kernel/utility/debugger.php (revision 3647)
	+++ trunk/core/kernel/utility/debugger.php (revision 3648)
	@@ -1,1023 +1,1029 @@
	<?php

	if( !class_exists('Debugger') )
	{
	function dbg_ConstOn($const_name)
	{
	return defined($const_name) && constant($const_name);
	}

	function dbg_safeDefine($const_name,$const_value)
	{
	if(!defined($const_name)) define($const_name,$const_value);
	}

	unset($_REQUEST['debug_host'], $_REQUEST['debug_fastfile']); // this var messed up whole detection stuff :(

	// Detect fact, that this session beeing debugged by Zend Studio
	foreach($_REQUEST as $rq_name=>$rq_value)
	{
	if( substr($rq_name,0,6)=='debug_' )
	{
	dbg_safeDefine('DBG_ZEND_PRESENT', 1);
	break;
	}
	}

	dbg_safeDefine('DBG_ZEND_PRESENT',0);

	// set default values for debugger constants
	$dbg_constMap=Array('DBG_OPTIONS'=>0,
	'DBG_USE_HIGHLIGHT'=>1,
	'DBG_USE_SHUTDOWN_FUNC'=>DBG_ZEND_PRESENT?0:1,
	'DBG_HANDLE_ERRORS'=>DBG_ZEND_PRESENT?0:1,
	'DBG_IGNORE_STRICT_ERRORS'=>1,
	'DBG_DOMVIEWER'=>'/temp/domviewer.html',
	'DOC_ROOT'=> str_replace('\\', '/', realpath($_SERVER['DOCUMENT_ROOT']) ), // windows hack
	'DBG_LOCAL_BASE_PATH'=>'w:');

	foreach($dbg_constMap as $dbg_constName=>$dbg_constValue)
	{
	dbg_safeDefine($dbg_constName,$dbg_constValue);
	}

	// only for IE, in case if no windows php script editor defined
	/*if(!defined('WINDOWS_EDITOR'))
	{
	$dbg_editor = 0;
	$dbg_editors[0] = Array('editor' => 'c:\Program Files\UltraEdit\uedit32.exe', 'params' => '%F/%L');
	$dbg_editors[1] = Array('editor' => 'c:\Program Files\Zend\ZendStudio-4.0Beta\bin\ZDE.exe', 'params' => '%F');
	define('WINDOWS_EDITOR',$dbg_editors[$dbg_editor]['editor'].' '.$dbg_editors[$dbg_editor]['params']);
	unset($dbg_editors,$dbg_editor);
	}*/

	class Debugger
	{
	/**
	* Debugger data for building report
	*
	* @var Array
	*/
	var $Data = Array();
	var $ProfilerData = Array();
	var $ProfilerTotals = Array();
	var $ProfilerTotalCount = Array();
	var $RecursionStack = Array(); // prevent recursion when processing debug_backtrace() function results

	var $TraceNextError=false;

	var $Options = 0;
	var $OptionsMap = Array('shutdown_func' => 1, 'error_handler' => 2,
	'output_buffer' => 4, 'highlight_output' => 8);


	var $longErrors=Array();

	/**
	* Amount of memory used by debugger itself
	*
	* @var Array
	* @access private
	*/
	var $memoryUsage=Array();

	var $IncludesData=Array();
	var $IncludeLevel=0;

	var $reportDone = false;

	function Debugger()
	{
	$this->profileStart('kernel4_startup', 'Startup and Initialization of kernel4');
	$this->profileStart('script_runtime', 'Script runtime');
	ini_set('display_errors',dbg_ConstOn('DBG_ZEND_PRESENT')?0:1);
	$this->memoryUsage['error_handling']=0; // memory amount used by error handler
	$this->appendRequest();
	}

	function initOptions()
	{

	}

	function mapLongError($msg)
	{
	$key=$this->generateID();
	$this->longErrors[$key]=$msg;
	return $key;
	}

	function setOption($name,$value)
	{
	if( !isset($this->OptionsMap[$name]) ) die('undefined debugger option: ['.$name.']<br>');
	if($value)
	{
	$this->Options\|=$this->OptionsMap[$name];
	}
	else
	{
	$this->Options=$this->Options&~$this->OptionsMap[$name];
	}
	}

	function getOption($name)
	{
	if( !isset($this->OptionsMap[$name]) ) die('undefined debugger option: ['.$name.']<br>');
	return ($this->Options & $this->OptionsMap[$name]) == $this->OptionsMap[$name];
	}

	/**
	* Set's flag, that next error that occurs will
	* be prepended by backtrace results
	*
	*/
	function traceNext()
	{
	$this->TraceNextError=true;
	}

	function dumpVars()
	{
	$dumpVars = func_get_args();
	foreach($dumpVars as $varValue)
	{
	$this->Data[] = Array('value' => $varValue, 'debug_type' => 'var_dump');
	}
	}

	function prepareHTML($dataIndex)
	{
	$Data =& $this->Data[$dataIndex];
	if($Data['debug_type'] == 'html') return $Data['html'];

	switch($Data['debug_type'])
	{
	case 'error':
	$fileLink = $this->getFileLink($Data['file'],$Data['line']);
	$ret = '<b class="debug_error">'.$this->getErrorNameByCode($Data['no']).'</b>: '.$Data['str'];
	$ret .= ' in <b>'.$fileLink.'</b> on line <b>'.$Data['line'].'</b>';
	return $ret;
	break;

	case 'var_dump':
	return $this->highlightString( print_r($Data['value'], true) );
	break;

	case 'trace':
	ini_set('memory_limit','500M');
	$trace =& $Data['trace'];

	//return 'sorry';
	//return $this->highlightString(print_r($trace,true));


	$i = 0; $traceCount = count($trace);
	$ret = '';
	while($i < $traceCount)
	{
	$traceRec =& $trace[$i];
	$argsID = 'trace_args_'.$dataIndex.'_'.$i;

	$has_args = isset($traceRec['args']);

	if(isset($traceRec['file']))
	{
	$func_name=isset($traceRec['class'])?$traceRec['class'].$traceRec['type'].$traceRec['function']:$traceRec['function'];
	$args_link = $has_args ? '<a href="javascript:toggleTraceArgs(\''.$argsID.'\');" title="Show/Hide Function Arguments"><b>Function</b></a>' : '<b>Function</b>';

	$ret .= $args_link.': '.$this->getFileLink($traceRec['file'],$traceRec['line'],$func_name);
	$ret .= ' in <b>'.basename($traceRec['file']).'</b> on line <b>'.$traceRec['line'].'</b><br>';
	}
	else
	{
	$ret .= 'no file information available';
	}

	// ensure parameter value is not longer then 200 symbols
	if($has_args)
	{
	$this->processTraceArguments($traceRec['args']);
	$args = $this->highlightString(print_r($traceRec['args'], true));
	$ret .= '<div id="'.$argsID.'" style="display: none;">'.$args.'</div>';
	}
	$i++;
	}
	return $ret;
	break;

	case 'profiler':
	$profileKey = $Data['profile_key'];
	$Data =& $this->ProfilerData[$profileKey];
	$runtime = ($Data['ends'] - $Data['begins']); // in seconds
	return '<b>Name</b>: '.$Data['description'].'<br><b>Runtime</b>: '.$runtime.'s';
	break;

	default:
	return 'incorrect debug data';
	break;
	}
	}

	function isApplication(&$object)
	{
	$app_class = defined('APPLICATION_CLASS') ? strtolower(APPLICATION_CLASS) : 'kApplication';
	return get_class($object) == $app_class;
	}

	function processTraceArguments(&$traceArgs)
	{
	if(!$traceArgs) return '';

	$array_keys = array_keys($traceArgs);
	foreach($array_keys as $argID)
	{
	$argValue =& $traceArgs[$argID];

	if( is_array($argValue) \|\| is_object($argValue) )
	{
	if(is_object($argValue) && !in_array(get_class($argValue),$this->RecursionStack) )
	{
	array_push($this->RecursionStack, get_class($argValue));

	if( get_class($argValue) == 'kfactory' \|\| $this->isApplication($argValue) \|\| get_class($argValue) == 'templateparser' )
	{
	$argValue = null;
	continue;
	}

	// object & not in stack - ok
	settype($argValue,'array');
	$this->processTraceArguments($argValue);
	array_pop($this->RecursionStack);
	}
	elseif(is_object($argValue) && in_array(get_class($argValue),$this->RecursionStack) )
	{
	// object & in stack - recursion
	$traceArgs[$argID] = '** RECURSION *';
	}
	else
	{
	// normal array here
	$this->processTraceArguments($argValue);
	}
	}
	else
	{
	$traceArgs[$argID] = $this->cutStringForHTML($traceArgs[$argID]);
	}
	}
	}

	function cutStringForHTML($string)
	{
	if( strlen($string) > 200 ) $string = substr($string,0,50).' ...';
	return $string;
	}

	/**
	* Format SQL Query using predefined formatting
	* and highlighting techniques
	*
	* @param string $sql
	* @return string
	*/
	function formatSQL($sql)
	{
	$sql = preg_replace('/(\n\|\t\| )+/is',' ',$sql);
	$sql = preg_replace('/(CREATE TABLE\|DROP TABLE\|SELECT\|UPDATE\|SET\|REPLACE\|INSERT\|DELETE\|VALUES\|FROM\|LEFT JOIN\|INNER JOIN\|LIMIT\|WHERE\|HAVING\|GROUP BY\|ORDER BY) /is', "\n\t$1 ",$sql);
	return $this->highlightString($sql);
	}

	function highlightString($string)
	{
	if( dbg_ConstOn('DBG_USE_HIGHLIGHT') )
	{
	$string = str_replace( Array('\\', '/') , Array('_no_match_string_', '_n_m_s_'), $string);
	$string = highlight_string('<?php '.$string.'?>', true);
	$string = str_replace( Array('_no_match_string_', '_n_m_s_'), Array('\\', '/'), $string);
	return preg_replace('/<\?(.)php (.)\?>/s', '$2', $string);
	}
	else
	{
	return $string;
	}
	}

	function getFileLink($file, $lineno = 1, $title = '')
	{
	if(!$title) $title = $file;
	$is_mozilla=strpos(strtolower($_SERVER['HTTP_USER_AGENT']),'firefox')!==false?true:false;
	if($is_mozilla)
	{
	return '<a href="file://'.$this->getLocalFile($file).'">'.$title.'</a>';
	}
	else
	{
	return '<a href="javascript:editFile(\''.$this->getLocalFile($file).'\','.$lineno.');" title="'.$file.'">'.$title.'</a>';
	}

	}

	function getLocalFile($remoteFile)
	{
	return str_replace(DOC_ROOT, DBG_LOCAL_BASE_PATH, $remoteFile);
	}

	function appendTrace()
	{
	$trace = debug_backtrace();
	array_shift($trace);
	$this->Data[] = Array('trace' => $trace, 'debug_type' => 'trace');
	}

	function appendMemoryUsage($msg, $used=null)
	{
	if (!isset($used)) $used = round(memory_get_usage()/1024);
	$this->appendHTML('<b>Memory usage</b> '.$msg.' '.$used.'Kb');
	}

	function appendHTML($html)
	{
	$this->Data[] = Array('html' => $html,'debug_type' => 'html');
	}

	/**
	* Change debugger info that was already generated before.
	* Returns true if html was set.
	*
	* @param int $index
	* @param string $html
	* @param string $type = {'append','prepend','replace'}
	* @return bool
	*/
	function setHTMLByIndex($index,$html,$type='append')
	{
	if( !isset($this->Data[$index]) \|\| $this->Data[$index]['debug_type'] != 'html' )
	{
	return false;
	}

	switch ($type)
	{
	case 'append':
	$this->Data[$index]['html'] .= '<br>'.$html;
	break;
	case 'prepend':
	$this->Data[$index]['html'] = $this->Data[$index]['html'].'<br>'.$html;
	break;
	case 'replace':
	$this->Data[$index]['html'] = $html;
	break;
	}
	return true;
	}

	/**
	* Move $debugLineCount lines of input from debug output
	* end to beginning.
	*
	* @param int $debugLineCount
	*/
	function moveToBegin($debugLineCount)
	{
	$lines = array_splice($this->Data,count($this->Data)-$debugLineCount,$debugLineCount);
	$this->Data = array_merge($lines,$this->Data);
	}

	function moveAfterRow($new_row, $debugLineCount)
	{
	$lines = array_splice($this->Data,count($this->Data)-$debugLineCount,$debugLineCount);
	$rows_before = array_splice($this->Data,0,$new_row,$lines);
	$this->Data = array_merge($rows_before,$this->Data);
	}

	function appendRequest()
	{
	- $script = $_SERVER['PHP_SELF'];
	+ if (isset($_SERVER['SCRIPT_FILENAME'])) {
	+ $script = $_SERVER['SCRIPT_FILENAME'];
	+ }
	+ else {
	+ $script = $_SERVER['DOCUMENT_ROOT'].$_SERVER['PHP_SELF'];
	+ }
	+
	$this->appendHTML('ScriptName: <b>'.$this->getFileLink($script,1,basename($script)).'</b> (<b>'.dirname($script).'</b>)');

	$this->appendHTML('<a href="http://www.brainjar.com/dhtml/domviewer/" target="_blank">DomViewer</a>: <input id="dbg_domviewer" type="text" value="window" style="border: 1px solid #000000;"/> <button class="button" onclick="return dbg_OpenDOMViewer();">Show</button>');

	ob_start();
	?>
	<table border="0" cellspacing="0" cellpadding="0" class="dbg_flat_table" style="width: 100%;">
	<thead style="font-weight: bold;">
	<td width="20">Src</td><td>Name</td><td>Value</td>
	</thead>
	<?php
	foreach($_REQUEST as $key => $value)
	{
	if( !is_array($value) && trim($value) == '' )
	{
	$value = '<b class="debug_error">no value</b>';
	}
	else
	{
	$value = htmlspecialchars(print_r($value, true));
	}

	$in_cookie = isset($_COOKIE[$key]);
	$src = isset($_GET[$key]) && !$in_cookie ? 'GE' : (isset($_POST[$key]) && !$in_cookie ? 'PO' : ($in_cookie ? 'CO' : '?') );
	echo '<tr><td>'.$src.'</td><td>'.$key.'</td><td>'.$value.'</td></tr>';
	}
	?>
	</table>
	<?php
	$this->appendHTML( ob_get_contents() );
	ob_end_clean();
	}

	function appendSession()
	{
	if( isset($_SESSION)&&$_SESSION )
	{
	$this->appendHTML('PHP Session: [<b>'.ini_get('session.name').'</b>]');
	$this->dumpVars($_SESSION);
	$this->moveToBegin(2);
	}
	}

	function profileStart($key, $description)
	{
	$timeStamp = $this->getMoment();
	$this->ProfilerData[$key] = Array('begins' => $timeStamp, 'ends' => 5000, 'debuggerRowID' => count($this->Data), 'description' => $description);
	$this->Data[] = array('profile_key' => $key, 'debug_type' => 'profiler');
	}

	function profileFinish($key)
	{
	$this->ProfilerData[$key]['ends'] = $this->getMoment();
	}

	function profilerAddTotal($total_key, $key=null, $value=null)
	{
	if (!isset($this->ProfilerTotals[$total_key])) {
	$this->ProfilerTotals[$total_key] = 0;
	$this->ProfilerTotalCount[$total_key] = 0;
	}
	if (!isset($value)) {
	$value = $this->ProfilerData[$key]['ends'] - $this->ProfilerData[$key]['begins'];
	}
	$this->ProfilerTotals[$total_key] += $value;
	$this->ProfilerTotalCount[$total_key]++;
	}

	function getMoment()
	{
	list($usec, $sec) = explode(' ', microtime());
	return ((float)$usec + (float)$sec);
	}

	function generateID()
	{
	list($usec, $sec) = explode(" ",microtime());

	$id_part_1 = substr($usec, 4, 4);
	$id_part_2 = mt_rand(1,9);
	$id_part_3 = substr($sec, 6, 4);
	$digit_one = substr($id_part_1, 0, 1);
	if ($digit_one == 0) {
	$digit_one = mt_rand(1,9);
	$id_part_1 = ereg_replace("^0","",$id_part_1);
	$id_part_1=$digit_one.$id_part_1;
	}
	return $id_part_1.$id_part_2.$id_part_3;
	}


	function getErrorNameByCode($errorCode)
	{
	switch($errorCode)
	{
	case E_USER_ERROR:
	return 'Fatal Error';
	break;

	case E_WARNING:
	case E_USER_WARNING:
	return 'Warning';
	break;

	case E_NOTICE:
	case E_USER_NOTICE:
	return 'Notice';
	break;

	case E_STRICT:
	return 'PHP5 Strict';
	break;

	default:
	return '';
	break;
	}
	}

	/**
	* Generates report
	*
	*/
	function printReport($returnResult = false, $clean_output_buffer = true)
	{
	if($this->reportDone) return '';

	if( dbg_ConstOn('DBG_SKIP_REPORTING') ) return;

	$this->profileFinish('script_runtime');
	if( dbg_ConstOn('DBG_ZEND_PRESENT') ) return;

	dbg_safeDefine('DBG_RAISE_ON_WARNINGS',0);
	dbg_safeDefine('DBG_WINDOW_WIDTH', 700);

	$this->memoryUsage['debugger_start']=memory_get_usage();

	// show php session if any
	$this->appendSession();

	// ensure, that 1st line of debug output always is this one:
	$this->appendHTML('<a href="javascript:toggleDebugLayer(27);">Hide Debugger</a>');
	$this->moveToBegin(1);

	if( dbg_ConstOn('DBG_SQL_PROFILE') && isset($this->ProfilerTotals['sql']) )
	{
	$this->appendHTML('<b>SQL Total time:</b> '.$this->ProfilerTotals['sql'].' Number of queries: '.$this->ProfilerTotalCount['sql']);
	}

	if( dbg_ConstOn('DBG_PROFILE_MEMORY') )
	{
	$this->appendHTML('<b>Memory used by Objects:</b> '.round($this->ProfilerTotals['objects']/1024, 2).'Kb');
	}

	if( dbg_ConstOn('DBG_INCLUDED_FILES') )
	{
	$files = get_included_files();
	$this->appendHTML('<b>Included files:</b>');
	foreach ($files as $file)
	{
	$this->appendHTML($this->getFileLink($this->getLocalFile($file)).' ('.round(filesize($file)/1024, 2).'Kb)');
	}
	}

	if( dbg_ConstOn('DBG_PROFILE_INCLUDES') )
	{
	$this->appendHTML('<b>Included files statistics:</b>'.( dbg_ConstOn('DBG_SORT_INCLUDES_MEM') ? ' (sorted by memory usage)':''));
	$totals = Array( 'mem' => 0, 'time' => 0);
	$totals_configs = Array( 'mem' => 0, 'time' => 0);
	if ( dbg_ConstOn('DBG_SORT_INCLUDES_MEM') ) {
	array_multisort($this->IncludesData['mem'], SORT_DESC, $this->IncludesData['file'], $this->IncludesData['time'], $this->IncludesData['level']);
	}
	foreach ($this->IncludesData['file'] as $key => $file_name) {
	$this->appendHTML( str_repeat(' -> ', ($this->IncludesData['level'][$key] >= 0 ? $this->IncludesData['level'][$key] : 0)).$file_name.' Mem: '.sprintf("%.4f Kb", $this->IncludesData['mem'][$key]/1024).' Time: '.sprintf("%.4f", $this->IncludesData['time'][$key]));
	if ($this->IncludesData['level'][$key] == 0) {
	$totals['mem'] += $this->IncludesData['mem'][$key];
	$totals['time'] += $this->IncludesData['time'][$key];
	}
	else if ($this->IncludesData['level'][$key] == -1) {
	$totals_configs['mem'] += $this->IncludesData['mem'][$key];
	$totals_configs['time'] += $this->IncludesData['time'][$key];
	}
	}
	$this->appendHTML('<b>Sub-Total classes:</b> '.' Mem: '.sprintf("%.4f Kb", $totals['mem']/1024).' Time: '.sprintf("%.4f", $totals['time']));
	$this->appendHTML('<b>Sub-Total configs:</b> '.' Mem: '.sprintf("%.4f Kb", $totals_configs['mem']/1024).' Time: '.sprintf("%.4f", $totals_configs['time']));
	$this->appendHTML('<span class="error"><b>Grand Total:</b></span> '.' Mem: '.sprintf("%.4f Kb", ($totals['mem']+$totals_configs['mem'])/1024).' Time: '.sprintf("%.4f", $totals['time']+$totals_configs['time']));
	}


	$i = 0; $lineCount = count($this->Data);
	if( !ob_get_length() ) ob_start();
	?>
	<style type="text/css">

	.dbg_flat_table {
	border-collapse: collapse;
	width: auto;
	}

	.dbg_flat_table TD {
	border: 1px solid buttonface;
	padding: 4px;
	}

	.debug_layer_table {
	border-collapse: collapse;
	width: <?php echo DBG_WINDOW_WIDTH - 20; ?>px;
	}

	.debug_text, .debug_row_even TD, .debug_row_odd TD {
	color: #000000;
	font-family: Verdana;
	font-size: 11px;
	word-wrap: break-word;
	}

	.debug_cell {
	border: 1px solid #FF0000;
	padding: 4px;
	word-wrap: break-word;
	text-align: left;
	}

	.debug_row_even {
	background-color: #CCCCFF;
	}

	.debug_row_odd {
	background-color: #FFFFCC;
	}

	.debug_layer_container {
	left: 2px;
	top: 1px;
	width: <?php echo DBG_WINDOW_WIDTH; ?>px;
	z-index: +1000;
	position: absolute;
	overflow: auto;
	border: 2px solid;
	padding: 3px;
	border-top-color: threedlightshadow;
	border-left-color: threedlightshadow;
	border-right-color: threeddarkshadow;
	border-bottom-color: threeddarkshadow;
	background-color: buttonface;
	}

	.debug_layer {
	padding: 0px;
	width: <?php echo DBG_WINDOW_WIDTH - 20; ?>px;
	}

	.debug_error {
	color: #FF0000;
	}
	</style>
	<div id="debug_layer" class="debug_layer_container" style="display: none;">
	<div class="debug_layer">
	<table width="100%" cellpadding="0" cellspacing="1" border="0" class="debug_layer_table">
	<?php
	while ($i < $lineCount)
	{
	echo '<tr class="debug_row_'.(($i % 2) ? 'odd' : 'even').'"><td class="debug_cell">'.$this->prepareHTML($i).'</td></tr>';
	$i++;
	}
	?>
	</table>
	</div>
	</div>
	<script language="javascript">

	function dbg_OpenDOMViewer()
	{
	var $value = document.getElementById('dbg_domviewer').value;
	DOMViewerObj = ($value.indexOf('"') != -1) ? document.getElementById( $value.substring(1,$value.length-1) ) : eval($value);
	window.open('<?php echo constant('DBG_DOMVIEWER'); ?>');
	return false;
	}

	function getEventKeyCode($e)
	{
	var $KeyCode = 0;
	if($e.keyCode) $KeyCode = $e.keyCode;
	else if($e.which) $KeyCode = $e.which;
	return $KeyCode;
	}

	function keyProcessor($e)
	{
	if(!$e) $e = window.event;
	var $KeyCode = getEventKeyCode($e);
	if($KeyCode==123\|\|$KeyCode==27) // F12 or ESC
	{
	toggleDebugLayer($KeyCode);
	$e.cancelBubble = true;
	if($e.stopPropagation) $e.stopPropagation();
	}
	}

	function toggleDebugLayer($KeyCode)
	{
	var $isVisible=false;
	var $DebugLayer = document.getElementById('debug_layer');
	if( typeof($DebugLayer) != 'undefined' )
	{
	$isVisible = ($DebugLayer.style.display == 'none')?false:true;
	if(!$isVisible&&$KeyCode==27) return false;

	resizeDebugLayer(null);
	$DebugLayer.style.display = $isVisible?'none':'block';
	}
	}

	function prepareSizes($Prefix)
	{
	var $ret = '';
	$ret = eval('document.body.'+$Prefix+'Top')+'; ';
	$ret += eval('document.body.'+$Prefix+'Left')+'; ';
	$ret += eval('document.body.'+$Prefix+'Height')+'; ';
	$ret += eval('document.body.'+$Prefix+'Width')+'; ';
	return $ret;
	}

	function resizeDebugLayer($e)
	{
	if(!$e) $e = window.event;
	var $DebugLayer = document.getElementById('debug_layer');
	var $TopMargin = 1;

	var $pageWidth = document.all ? document.body.offsetWidth - 4 : window.innerWidth;
	var $pageHeight = document.all ? document.body.clientHeight : window.innerHeight; // document.body.offsetHeight - 2

	var $pageTop = document.all ? document.body.offsetTop + document.body.scrollTop : window.scrollY;

	if( typeof($DebugLayer) != 'undefined' )
	{
	if(document.all)
	{
	$DebugLayer.style.top = ($pageTop + 2) + 'px';
	$DebugLayer.style.height = ($pageHeight - 2 - 4) + 'px';
	}
	else
	{
	$DebugLayer.style.top = ($pageTop + 2) + 'px';
	$DebugLayer.style.height = ($pageHeight - 2 - 15) + 'px';
	}
	}
	// window.parent.status = 'OFFSET: '+prepareSizes('offset')+' \| SCROLL: '+prepareSizes('scroll')+' \| CLIENT: '+prepareSizes('client');
	// window.parent.status += 'DL Info: '+$DebugLayer.style.top+'; S.AH: '+screen.availHeight;
	return true;
	}

	function SetClipboard(copyText)
	{
	if(window.clipboardData)
	{
	// IE send-to-clipboard method.
	window.clipboardData.setData('Text', copyText);
	}
	else if (window.netscape)
	{
	// You have to sign the code to enable this or allow the action in about:config by changing user_pref("signed.applets.codebase_principal_support", true);
	netscape.security.PrivilegeManager.enablePrivilege('UniversalXPConnect');

	// Store support string in an object.
	var str = Components.classes["@mozilla.org/supports-string;1"].createInstance(Components.interfaces.nsISupportsString);
	if (!str) return false;
	str.data=copyText;

	// Make transferable.
	var trans = Components.classes["@mozilla.org/widget/transferable;1"].createInstance(Components.interfaces.nsITransferable);
	if (!trans) return false;

	// Specify what datatypes we want to obtain, which is text in this case.
	trans.addDataFlavor("text/unicode");
	trans.setTransferData("text/unicode",str,copyText.length*2);

	var clipid=Components.interfaces.nsIClipboard;
	var clip = Components.classes["@mozilla.org/widget/clipboard;1"].getService(clipid);
	if (!clip) return false;

	clip.setData(trans,null,clipid.kGlobalClipboard);
	}

	}

	function showProps($Obj, $Name)
	{
	var $ret = '';
	for($Prop in $Obj)
	{
	$ret += $Name+'.'+$Prop+' = '+$Obj[$Prop]+"\n";
	}
	return $ret;
	}

	function editFile($fileName,$lineNo)
	{
	if(!document.all)
	{
	alert('Only works in IE');
	return;
	}

	var $editorPath = '<?php echo defined('WINDOWS_EDITOR') ? addslashes(WINDOWS_EDITOR) : '' ?>';
	if($editorPath)
	{
	var $obj = new ActiveXObject("LaunchinIE.Launch");
	$editorPath = $editorPath.replace('%F',$fileName);
	$editorPath = $editorPath.replace('%L',$lineNo);
	$obj.LaunchApplication($editorPath);
	}
	else
	{
	alert('Editor path not defined!');
	}
	}

	function toggleTraceArgs($ArgsLayerID)
	{
	var $ArgsLayer = document.getElementById($ArgsLayerID);
	$ArgsLayer.style.display = ($ArgsLayer.style.display == 'none') ? 'block' : 'none';
	}


	document.onkeydown = keyProcessor;
	window.onresize = resizeDebugLayer;
	window.onscroll = resizeDebugLayer;
	window.focus();
	if( typeof($isFatalError) != 'undefined' && $isFatalError == 1 \|\| <?php echo DBG_RAISE_ON_WARNINGS; ?> )
	{
	toggleDebugLayer();
	}
	if( typeof($isFatalError) != 'undefined' && $isFatalError == 1)
	{
	document.getElementById('debug_layer').scrollTop = 10000000;
	}
	</script>
	<?php

	dbg_safeDefine('DBG_SHOW_MEMORY_USAGE', 1);
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') )
	{
	$this->memoryUsage['debugger_finish']=memory_get_usage();
	$this->memoryUsage['print_report']=$this->memoryUsage['debugger_finish']-$this->memoryUsage['debugger_start'];
	$this->memoryUsage['total']=$this->memoryUsage['print_report']+$this->memoryUsage['error_handling'];
	$this->memoryUsage['application']=memory_get_usage()-$this->memoryUsage['total'];
	}

	if($returnResult)
	{
	$ret = ob_get_contents();
	if($clean_output_buffer) ob_clean();
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) $ret .= $this->getMemoryUsageReport();
	$this->reportDone = true;
	return $ret;
	}
	else
	{
	if( !dbg_ConstOn('DBG_HIDE_FULL_REPORT') )
	{
	ob_end_flush();
	}
	else
	{
	if($clean_output_buffer) ob_clean();
	}
	if( dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) echo $this->getMemoryUsageReport();
	$this->reportDone = true;
	}
	}

	/**
	* Format's memory usage report by debugger
	*
	* @return string
	* @access private
	*/
	function getMemoryUsageReport()
	{
	if( !dbg_ConstOn('DBG_SHOW_MEMORY_USAGE') ) return '';

	$info = Array('<a href="javascript:self.location.reload()">printReport</a>'=>'print_report',
	'saveError'=>'error_handling',
	'Total'=>'total',
	'Application'=>'application');
	$ret=Array();
	foreach($info as $title => $value_key)
	{
	$ret[]='<tr><td>'.$title.':</td><td><b>'.$this->formatSize($this->memoryUsage[$value_key]).'</b></td></tr>';
	}
	return '<table class="dbg_flat_table">'.implode('',$ret).'</table>';
	}


	/**
	* User-defined error handler
	*
	* @param int $errno
	* @param string $errstr
	* @param string $errfile
	* @param int $errline
	* @param array $errcontext
	*/
	function saveError($errno, $errstr, $errfile = '', $errline = '', $errcontext = '')
	{
	$memory_used=Array();
	$memory_used['begin']=memory_get_usage();

	$errorType = $this->getErrorNameByCode($errno);
	if(!$errorType)
	{
	trigger_error('Unknown error type ['.$errno.']', E_USER_ERROR);
	return false;
	}

	if( dbg_ConstOn('DBG_IGNORE_STRICT_ERRORS') && defined('E_STRICT') && ($errno == E_STRICT) ) return;

	$long_id_pos=strrpos($errstr,'#');
	if($long_id_pos!==false)
	{
	// replace short message with long one (due triger_error limitations on message size)
	$long_id=substr($errstr,$long_id_pos+1,strlen($errstr));
	$errstr=$this->longErrors[$long_id];
	unset($this->longErrors[$long_id]);
	}


	/*in /www/kostja/in-commerce4/kernel/kernel4/parser/construct_tags.php(177) : runtime-created function on line

	[PRE-PARSED block, $line 13]: Undefined variable: IdField*/
	/*
	if( strpos($errfile,'runtime-created') !== false ) {
	$errfile = ' PRE-PARSED block <b>'.$this->CurrentPreParsedBlock.'</b> ';
	}*/

	if( strpos($errfile,'eval()\'d code') !== false )
	{
	$errstr = '[<b>EVAL</b>, line <b>'.$errline.'</b>]: '.$errstr;
	$tmpStr = $errfile;
	$pos = strpos($tmpStr,'(');
	$errfile = substr($tmpStr,0,$pos);
	$pos++;
	$errline = substr($tmpStr,$pos,strpos($tmpStr,')',$pos)-$pos);
	}
	// if($this->TraceNextError \|\| $errno == E_USER_ERROR)
	if($this->TraceNextError)
	{
	$this->appendTrace();
	$this->TraceNextError=false;
	}
	$this->Data[] = Array('no' => $errno, 'str' => $errstr, 'file' => $errfile, 'line' => $errline, 'context' => $errcontext, 'debug_type' => 'error');
	$memory_used['end']=memory_get_usage();
	$this->memoryUsage['error_handling']+=$memory_used['end']-$memory_used['begin'];
	if( substr($errorType,0,5) == 'Fatal')
	{
	echo '<script language="javascript">var $isFatalError = 1;</script>';
	if( !dbg_ConstOn('DBG_USE_SHUTDOWN_FUNC') ) $this->printReport();
	exit;
	}
	}

	function saveToFile($msg)
	{
	$fp = fopen($_SERVER['DOCUMENT_ROOT'].'/vb_debug.txt', 'a');
	fwrite($fp,$msg."\n");
	fclose($fp);
	}

	/**
	* Formats file/memory size in nice way
	*
	* @param int $bytes
	* @return string
	* @access public
	*/
	function formatSize($bytes)
	{
	if ($bytes >= 1099511627776) {
	$return = round($bytes / 1024 / 1024 / 1024 / 1024, 2);
	$suffix = "TB";
	} elseif ($bytes >= 1073741824) {
	$return = round($bytes / 1024 / 1024 / 1024, 2);
	$suffix = "GB";
	} elseif ($bytes >= 1048576) {
	$return = round($bytes / 1024 / 1024, 2);
	$suffix = "MB";
	} elseif ($bytes >= 1024) {
	$return = round($bytes / 1024, 2);
	$suffix = "KB";
	} else {
	$return = $bytes;
	$suffix = "Byte";
	}
	$return .= ' '.$suffix;
	return $return;
	}

	}

	if( !function_exists('memory_get_usage') )
	{
	function memory_get_usage(){ return -1; }
	}

	if( !dbg_ConstOn('DBG_ZEND_PRESENT') )
	{
	$debugger = new Debugger();
	}

	if( dbg_ConstOn('DBG_HANDLE_ERRORS') )
	{
	if( class_exists('kApplication') )
	{
	$application =& kApplication::Instance();
	$application->Debugger =& $debugger;
	$application->errorHandlers[] = Array(&$debugger, 'saveError');
	}
	else
	{
	set_error_handler( Array(&$debugger, 'saveError') );
	}
	}

	if( dbg_ConstOn('DBG_USE_SHUTDOWN_FUNC') ) register_shutdown_function( Array(&$debugger, 'printReport') );
	}
	?>
	\ No newline at end of file

	Property changes on: trunk/core/kernel/utility/debugger.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.31
	\ No newline at end of property
	+1.32
	\ No newline at end of property
	Index: trunk/core/units/general/cat_dbitem_export.php
	===================================================================
	--- trunk/core/units/general/cat_dbitem_export.php (revision 3647)
	+++ trunk/core/units/general/cat_dbitem_export.php (revision 3648)
	@@ -1,870 +1,876 @@
	<?php

	define('EXPORT_STEP', 200); // export by 200 items (e.g. links)
	define('IMPORT_CHUNK', 50120); // 5 KB

	class kCatDBItemExportHelper extends kHelper {


	var $cache = Array();

	var $exportFields = Array();

	/**
	* Export options
	*
	* @var Array
	*/
	var $exportOptions = Array();

	/**
	* If we have custom fields in export
	*
	* @var unknown_type
	*/
	var $hasCustomFields = false;

	/**
	* Custom field values for last item beeing exported
	*
	* @var Array
	*/
	var $customValues = Array();

	/**
	* Item beeing currenly exported
	*
	* @var kCatDBItem
	*/
	var $curItem = null;

	/**
	* Dummy category object
	*
	* @var CategoriesItem
	*/
	var $dummyCategory = null;

	/**
	* Pointer to opened file
	*
	* @var resource
	*/
	var $filePointer = null;

	/**
	* Returns value from cache if found or false otherwise
	*
	* @param string $type
	* @param int $key
	* @return mixed
	*/
	function getFromCache($type, $key)
	{
	return getArrayValue($this->cache, $type, $key);
	}

	/**
	* Adds value to be cached
	*
	* @param string $type
	* @param int $key
	* @param mixed $value
	*/
	function addToCache($type, $key, $value)
	{
	// if (!isset($this->cache[$type])) $this->cache[$type] = Array();
	$this->cache[$type][$key] = $value;
	}

	/**
	* Fill required fields with dummy values
	*
	* @param kEvent $event
	*/
	function fillRequiredFields(&$event)
	{
	$object =& $event->getObject();

	$fields = array_keys($object->Fields);
	foreach ($fields as $field_name)
	{
	$field_options =& $object->Fields[$field_name];
	if (isset($object->VirtualFields[$field_name]) \|\| !getArrayValue($field_options, 'required') ) continue;

	$formatter_class = getArrayValue($field_options, 'formatter');
	if ($formatter_class) // not tested
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$sample_value = $formatter->GetSample($field_name, $field_options, $object);
	}
	$object->SetDBField($field_name, isset($sample_value) && $sample_value ? $sample_value : 'dummy');
	}
	}

	/**
	* Verifies that all user entered export params are correct
	*
	* @param kEvent $event
	*/
	function verifyOptions(&$event)
	{
	if ($this->Application->RecallVar($event->getPrefixSpecial().'_ForceNotValid'))
	{
	$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 0);
	return false;
	}

	$this->fillRequiredFields($event);

	$object =& $event->getObject();
	$cross_unique_fields = Array('FieldsSeparatedBy', 'FieldsEnclosedBy');
	if (($object->GetDBField('CategoryFormat') == 1) \|\| ($event->Special == 'import')) // in one field
	{
	$object->setRequired('CategorySeparator', true);
	$cross_unique_fields[] = 'CategorySeparator';
	}

	$ret = $object->Validate();

	// check if cross unique fields has no same values
	foreach ($cross_unique_fields as $field_index => $field_name)
	{
	if (getArrayValue($object->FieldErrors, $field_name, 'pseudo') == 'required') continue;

	$check_fields = $cross_unique_fields;
	unset($check_fields[$field_index]);

	foreach ($check_fields as $check_field)
	{
	if ($object->GetDBField($field_name) == $object->GetDBField($check_field))
	{
	$object->SetError($check_field, 'unique');
	}
	}
	}

	if ($event->Special == 'import')
	{
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));

	$automatic_fields = ($object->GetDBField('FieldTitles') == 1);
	$object->setRequired('ExportColumns', !$automatic_fields);
	$category_prefix = '__CATEGORY__';
	if ( $automatic_fields && ($this->exportOptions['SkipFirstRow']) ) {
	$this->openFile($event);
	$this->exportOptions['ExportColumns'] = $this->readRecord();
	$this->closeFile();

	// remove additional (non-parseble columns)
	foreach ($this->exportOptions['ExportColumns'] as $field_index => $field_name) {
	if (!$this->validateField($field_name, $object)) {
	unset($this->exportOptions['ExportColumns'][$field_index]);
	}
	}
	$category_prefix = '';
	}

	// 1. check, that we have column definitions
	if (!$this->exportOptions['ExportColumns']) {
	$object->setError('ExportColumns', 'required');
	$ret = false;
	}

	// 2. check, that we have only mixed category field or only separated category fields
	$category_found['mixed'] = false;
	$category_found['separated'] = false;

	foreach ($this->exportOptions['ExportColumns'] as $import_field) {
	if (preg_match('/^'.$category_prefix.'Category(Path\|[0-9]+)/', $import_field, $rets)) {
	$category_found[$rets[1] == 'Path' ? 'mixed' : 'separated'] = true;
	}
	}
	if ($category_found['mixed'] && $category_found['separated']) {
	$object->SetError('ExportColumns', 'unique_category', 'la_error_unique_category_field');
	$ret = false;
	}

	// 3. check, that duplicates check fields are selected & present in imported fields
	if ($this->exportOptions['ReplaceDuplicates']) {
	if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
	$check_fields = Array($object->IDField);
	}
	else {
	$check_fields = $this->exportOptions['DuplicateCheckFields'] ? explode('\|', substr($this->exportOptions['DuplicateCheckFields'], 1, -1)) : Array();
	$object =& $event->getObject();

	$language_id = $this->Application->GetDefaultLanguageId();
	foreach ($check_fields as $index => $check_field) {
	foreach ($object->Fields as $field_name => $field_options) {
	if ($field_name == 'l'.$language_id.'_'.$check_field) {
	$check_fields[$index] = 'l'.$language_id.'_'.$check_field;
	break;
	}
	}
	}
	}
	$this->exportOptions['DuplicateCheckFields'] = $check_fields;

	if (!$check_fields) {
	$object->setError('CheckDuplicatesMethod', 'required');
	$ret = false;
	}
	else {
	foreach ($check_fields as $check_field) {
	if (!in_array($check_field, $this->exportOptions['ExportColumns'])) {
	$object->setError('ExportColumns', 'required');
	$ret = false;
	break;
	}
	}
	}
	}
	}

	return $ret;
	}

	/**
	* Returns filename to read import data from
	*
	* @return string
	*/
	function getImportFilename()
	{
	if ($this->exportOptions['ImportSource'] == 1)
	{
	$ret = $this->exportOptions['ImportFilename']['name'];
	}
	else {
	$ret = $this->exportOptions['ImportLocalFilename'];
	}
	return EXPORT_PATH.'/'.$ret;
	}

	/**
	* Returns filename to write export data to
	*
	* @return string
	*/
	function getExportFilename()
	{
	return EXPORT_PATH.'/'.$this->exportOptions['ExportFilename'].'.'.$this->getFileExtension();
	}

	/**
	* Opens file required for export/import operations
	*
	* @param kEvent $event
	*/
	function openFile(&$event)
	{
	if ($event->Special == 'export') {
	$write_mode = ($this->exportOptions['start_from'] == 0) ? 'w' : 'a';
	$this->filePointer = fopen($this->getExportFilename(), $write_mode);
	}
	else {
	$this->filePointer = fopen($this->getImportFilename(), 'r');
	}
	+
	+ // skip UTF-8 BOM Modifier
	+ $first_chars = fread($this->filePointer, 3);
	+ if (bin2hex($first_chars) != 'efbbbf') {
	+ fseek($this->filePointer, 0);
	+ }
	}

	/**
	* Closes opened file
	*
	*/
	function closeFile()
	{
	fclose($this->filePointer);
	}

	function getExportSQL($count_only = false)
	{
	if ($this->exportOptions['export_ids'] === false)
	{
	// get links from current category & all it's subcategories
	$sql = 'SELECT item_table.*, ci.CategoryId
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE ';

	if ($this->exportOptions['export_cats_ids'][0] == 0)
	{
	$sql .= '1';
	}
	else {
	foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
	$sql .= '(c.ParentPath LIKE "%\|'.$category_id.'\|%") OR ';
	}
	$sql = preg_replace('/(.*) OR $/', '\\1', $sql);
	}

	$sql .= ' ORDER BY ci.PrimaryCat DESC'; // NEW
	}
	else {
	// get only selected links
	$sql = 'SELECT item_table.*, '.$this->exportOptions['export_cats_ids'][0].' AS CategoryId
	FROM '.$this->curItem->TableName.' item_table
	WHERE '.$this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
	}

	if (!$count_only)
	{
	$sql .= ' LIMIT '.$this->exportOptions['start_from'].','.EXPORT_STEP;
	}
	else {
	$sql = preg_replace("/^.SELECT(.?)FROM(?!_)/is", "SELECT COUNT(*) AS count FROM ", $sql);
	}

	return $sql;
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function performExport(&$event)
	{
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
	$this->exportFields = $this->exportOptions['ExportColumns'];
	$this->curItem =& $event->getObject( Array('skip_autoload' => true) );

	$this->openFile($event);

	if ($this->exportOptions['start_from'] == 0) // first export step
	{
	if (!getArrayValue($this->exportOptions, 'IsBaseCategory')) {
	$this->exportOptions['IsBaseCategory'] = 0;
	}

	if ($this->exportOptions['IsBaseCategory'] ) {
	$sql = 'SELECT CachedNavbar
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$this->Application->GetVar('m_cat_id');
	$this->exportOptions['BaseLevel'] = substr_count($this->Conn->GetOne($sql), '>') + 1; // level to cut from other categories
	}

	// 1. export field titles if required
	if ($this->exportOptions['IncludeFieldTitles'])
	{
	$data_array = Array();
	foreach ($this->exportFields as $export_field)
	{
	$data_array = array_merge($data_array, $this->getFieldCaption($export_field));
	}
	$this->writeRecord($data_array);
	}
	$this->exportOptions['total_records'] = $this->Conn->GetOne( $this->getExportSQL(true) );
	$this->exportOptions['has_custom_fields'] = $this->scanCustomFields();
	}

	$this->hasCustomFields = $this->exportOptions['has_custom_fields'];

	// 2. export data
	$records = $this->Conn->Query( $this->getExportSQL() );
	$records_exported = 0;
	foreach ($records as $record_info) {
	$this->curItem->SetDBFieldsFromHash($record_info);
	if ($this->hasCustomFields)
	{
	$this->loadItemCustomFields();
	}

	$data_array = Array();
	foreach ($this->exportFields as $export_field)
	{
	$data_array = array_merge($data_array, $this->getFieldValue($export_field) );
	}
	$this->writeRecord($data_array);
	$records_exported++;
	}
	$this->closeFile();

	$this->exportOptions['start_from'] += $records_exported;
	$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );

	return $this->exportOptions;
	}

	function getItemFields()
	{
	// just in case dummy user selected automtic mode & moved columns too :(
	return array_merge($this->curItem->Fields['AvailableColumns']['options'], $this->curItem->Fields['ExportColumns']['options']);
	}

	/**
	* Checks if field really belongs to importable field list
	*
	* @param string $field_name
	* @param kCatDBItem $object
	* @return bool
	*/
	function validateField($field_name, &$object)
	{
	// 1. convert custom field
	$field_name = preg_replace('/^Custom_(.*)/', '__CUSTOM__\\1', $field_name);

	// 2. convert category field (mixed version & serparated version)
	$field_name = preg_replace('/^Category(Path\|[0-9]+)/', '__CATEGORY__Category\\1', $field_name);

	$valid_fields = $object->getPossibleExportColumns();
	return isset($valid_fields[$field_name]);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function performImport(&$event)
	{
	if (!$this->exportOptions) {
	// load import options in case if not previously loaded in verification function
	$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
	}

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

	$backup_category_id = $this->Application->GetVar('m_cat_id');
	$this->Application->SetVar('m_cat_id', (int)$this->Application->RecallVar('ImportCategory') );

	$this->openFile($event);

	$bytes_imported = 0;
	if ($this->exportOptions['start_from'] == 0) // first export step
	{
	// 1st time run
	if ($this->exportOptions['SkipFirstRow']) {
	$this->readRecord();
	$this->exportOptions['start_from'] = ftell($this->filePointer);
	$bytes_imported = ftell($this->filePointer);
	}

	$current_category_id = $this->Application->GetVar('m_cat_id');
	if ($current_category_id > 0) {
	$sql = 'SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId = '.$current_category_id;
	$this->exportOptions['ImportCategoryPath'] = $this->Conn->GetOne($sql);
	}
	else {
	$this->exportOptions['ImportCategoryPath'] = '';
	}
	$this->exportOptions['total_records'] = filesize($this->getImportFilename());
	}
	else {
	$this->cache['new_ids'] = $this->exportOptions['new_ids_hash'];
	}
	$this->exportFields = $this->exportOptions['ExportColumns'];
	$this->addToCache('category_parent_path', $this->Application->GetVar('m_cat_id'), $this->exportOptions['ImportCategoryPath']);

	// 2. import data
	$this->dummyCategory =& $this->Application->recallObject('c.-tmpitem', 'c', Array('skip_autoload' => true));
	fseek($this->filePointer, $this->exportOptions['start_from']);

	while (($bytes_imported < IMPORT_CHUNK) && !feof($this->filePointer)) {
	$this->customValues = Array();
	$data = $this->readRecord();
	if ($data) {
	foreach ($data as $field_index => $field_value) {
	$this->setFieldValue($field_index, $field_value);
	}
	$this->curItem->setID( $this->curItem->GetDBField($this->curItem->IDField) );
	$this->processCurrentItem($event);
	}
	$bytes_imported = ftell($this->filePointer) - $this->exportOptions['start_from'];
	}

	$this->closeFile();
	$this->Application->SetVar('m_cat_id', $backup_category_id);

	$this->exportOptions['start_from'] += $bytes_imported;
	$this->exportOptions['new_ids_hash'] = getArrayValue($this->cache, 'new_ids');
	$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );

	return $this->exportOptions;
	}

	function setFieldValue($field_index, $value)
	{
	$field_name = $this->exportFields[$field_index];

	if (substr($field_name, 0, 7) == 'Custom_') {
	$field_name = substr($field_name, 7);
	$this->customValues[$field_name] = $value;
	}
	elseif ($field_name == 'CategoryPath') {
	$this->curItem->CategoryPath = explode($this->exportOptions['CategorySeparator'], $value);
	}
	elseif (substr($field_name, 0, 8) == 'Category') {
	$this->curItem->CategoryPath[ (int)substr($field_name, 8) ] = $value;
	}
	else {
	$this->curItem->SetField($field_name, $value);
	}
	}

	/**
	* Returns temporary items for import procedures
	*
	* @param kEvent $event
	* @return kCatDBItem
	*/
	function &getTempItem(&$event)
	{
	return $this->Application->recallObject($event->Prefix.'.-tmpitem', $event->Prefix, Array('skip_autoload' => true));
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function processCurrentItem(&$event)
	{
	$tmp_item =& $this->getTempItem($event);

	// create/update categories
	$backup_category_id = $this->Application->GetVar('m_cat_id');

	foreach ($this->curItem->CategoryPath as $category_name) {
	if (!$category_name) continue;
	$category_id = $this->getFromCache('category_names', $category_name);
	if ($category_id === false) {
	// get parent category path to search only in it
	$current_category_id = $this->Application->GetVar('m_cat_id');
	$parent_path = $this->getParentPath($current_category_id);

	// get category id from database by name
	$sql = 'SELECT CategoryId
	FROM '.TABLE_PREFIX.'Category
	WHERE (Name = '.$this->Conn->qstr($category_name).') AND (ParentPath LIKE "'.$parent_path.'%")';
	$category_id = $this->Conn->GetOne($sql);

	if ($category_id === false) {
	// category not in db -> create
	$category_fields = Array( 'Name' => $category_name, 'Description' => $category_name,
	'Status' => STATUS_ACTIVE, 'ParentId' => $current_category_id,
	);
	$this->dummyCategory->SetDBFieldsFromHash($category_fields);
	if ($this->dummyCategory->Create()) {
	$category_id = $this->dummyCategory->GetID();
	$this->addToCache('category_parent_path', $category_id, $this->dummyCategory->GetDBField('ParentPath'));
	$this->addToCache('category_names', $category_name, $category_id);
	}
	}
	else {
	$this->addToCache('category_names', $category_name, $category_id);
	}
	}

	if ($category_id) {
	$this->Application->SetVar('m_cat_id', $category_id);
	}
	}
	if (!$this->curItem->CategoryPath) {
	$category_id = $backup_category_id;
	}

	// create main record
	$save_method = 'Create';
	if ($this->exportOptions['ReplaceDuplicates']) {
	if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
	$load_keys = Array($this->curItem->IDField => $this->curItem->GetID());
	}
	else {
	$key_fields = $this->exportOptions['DuplicateCheckFields'];
	foreach ($key_fields as $key_field) {
	$load_keys[$key_field] = $this->curItem->GetDBField($key_field);
	}
	}

	$where_clause = '';
	foreach ($load_keys as $field_name => $field_value) {
	$where_clause .= '(item_table.`'.$field_name.'` = '.$this->Conn->qstr($field_value).') AND ';
	}
	$where_clause = preg_replace('/(.*) AND $/', '\\1', $where_clause);

	$item_id = $this->getFromCache('new_ids', $where_clause);
	if (!$item_id) {
	$parent_path = $this->getParentPath($category_id);
	$sql = 'SELECT '.$this->curItem->IDField.'
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE (c.ParentPath LIKE "'.$parent_path.'%") AND '.$where_clause;
	$item_id = $this->Conn->GetOne($sql);
	}
	$save_method = $tmp_item->Load($item_id) ? 'Update' : 'Create';
	}

	$resource_id = $tmp_item->isLoaded() ? $tmp_item->GetDBField('ResourceId') : 0;
	$tmp_item->SetDBFieldsFromHash($this->curItem->FieldValues);
	if( ($save_method == 'Update') && $resource_id ) {
	$tmp_item->SetDBField('ResourceId', $resource_id);
	$tmp_item->setID($item_id);
	}

	if (!$tmp_item->$save_method()) {
	return false;
	}

	if ( ($save_method == 'Create') && $this->exportOptions['ReplaceDuplicates'] ) {
	// map new id to old id
	$this->addToCache('new_ids', $where_clause, $tmp_item->GetID() );
	}

	// set custom fields
	foreach ($this->customValues as $custom_field => $custom_value) {
	if (($save_method == 'Create') && !$custom_value) continue;
	$tmp_item->SetCustomField($custom_field, $custom_value);
	}

	// assign item to categories
	$tmp_item->assignToCategory($category_id, false);

	$this->Application->SetVar('m_cat_id', $backup_category_id);
	return true;
	}

	/**
	* Returns category parent path, if possible, then from cache
	*
	* @param int $category_id
	* @return string
	*/
	function getParentPath($category_id)
	{
	$parent_path = $this->getFromCache('category_parent_path', $category_id);
	if ($parent_path === false) {
	$sql = 'SELECT ParentPath
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$category_id;
	$parent_path = $this->Conn->GetOne($sql);
	$this->addToCache('category_parent_path', $category_id, $parent_path);
	}
	return $parent_path;
	}

	function loadItemCustomFields()
	{
	$sql = 'SELECT meta_data.Value, cf.FieldName
	FROM '.TABLE_PREFIX.'CustomMetaData meta_data
	LEFT JOIN '.TABLE_PREFIX.'CustomField cf ON cf.CustomFieldId = meta_data.CustomFieldId
	WHERE meta_data.ResourceId = '.$this->curItem->GetDBField('ResourceId');
	$this->customValues = $this->Conn->GetCol($sql, 'FieldName');
	}

	function getFileExtension()
	{
	return $this->exportOptions['ExportFormat'] == 1 ? 'csv' : 'xml';
	}

	function getLineSeparator($option = 'LineEndings')
	{
	return $this->exportOptions[$option] == 1 ? "\r\n" : "\n";
	}

	function scanCustomFields()
	{
	$ret = false;
	$export_fields = $this->exportOptions['ExportColumns'];
	foreach ($export_fields as $field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$ret = true;
	break;
	}
	}
	return $ret;
	}

	/**
	* Returns field caption for any exported field
	*
	* @param string $field
	* @return string
	*/
	function getFieldCaption($field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$ret = 'Custom_'.substr($field, 10, strlen($field) );
	}
	elseif (substr($field, 0, 12) == '__CATEGORY__')
	{
	return $this->getCategoryTitle();
	}
	else
	{
	$ret = $field;
	}

	return Array($ret);
	}

	/**
	* Returns requested field value (including custom fields and category fields)
	*
	* @param string $field
	* @return string
	*/
	function getFieldValue($field)
	{
	if (substr($field, 0, 10) == '__CUSTOM__')
	{
	$field = substr($field, 10, strlen($field) );
	$ret = isset($this->customValues[$field]) ? $this->customValues[$field] : '';
	}
	elseif (substr($field, 0, 12) == '__CATEGORY__')
	{
	return $this->getCategoryPath();
	}
	else
	{
	$ret = $this->curItem->GetField($field);
	}

	$ret = str_replace("\r\n", $this->getLineSeparator('LineEndingsInside'), $ret);
	return Array($ret);
	}

	/**
	* Returns category field(-s) caption based on export mode
	*
	* @return string
	*/
	function getCategoryTitle()
	{
	if ($this->exportOptions['CategoryFormat'] == 1)
	{
	// category path in one field
	return Array('CategoryPath');
	}
	else
	{
	// category path in separated fields
	$category_count = $this->getMaxCategoryLevel();

	$i = 0;
	$ret = Array();
	while ($i < $category_count) {
	$ret[] = 'Category'.($i + 1);
	$i++;
	}
	return $ret;
	}
	}

	/**
	* Returns category path in required format for current link
	*
	* @return string
	*/
	function getCategoryPath()
	{
	$category_id = $this->curItem->GetDBField('CategoryId');
	$category_path = $this->getFromCache('category_path', $category_id);
	if (!$category_path)
	{
	$sql = 'SELECT CachedNavbar
	FROM '.TABLE_PREFIX.'Category
	WHERE CategoryId = '.$category_id;
	$category_path = $this->Conn->GetOne($sql);
	$category_path = $category_path ? explode('>', $category_path) : Array();

	if ($this->exportOptions['IsBaseCategory']) {
	$i = $this->exportOptions['BaseLevel'];
	while ($i > 0) {
	array_shift($category_path);
	$i--;
	}
	}

	if ($this->exportOptions['CategoryFormat'] == 1) {
	// category path in single field
	$category_path = Array( implode($this->exportOptions['CategorySeparator'], $category_path) );
	}
	else {
	// category path in separated fields
	$category_count = $this->getMaxCategoryLevel();
	$levels_used = count($category_path);
	if ($levels_used < $category_count)
	{
	$i = 0;
	while ($i < $category_count - $levels_used) {
	$category_path[] = '';
	$i++;
	}
	}
	}
	$this->addToCache('category_path', $category_id, $category_path);
	}

	return $category_path;
	}

	/**
	* Get maximal category deep level from links beeing exported
	*
	* @return int
	*/
	function getMaxCategoryLevel()
	{
	static $max_level = -1;

	if ($max_level != -1)
	{
	return $max_level;
	}

	$sql = 'SELECT IF(c.CategoryId IS NULL, 0, MAX( LENGTH(c.ParentPath) - LENGTH( REPLACE(c.ParentPath, "\|", "") ) - 1 ))
	FROM '.$this->curItem->TableName.' item_table
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON item_table.ResourceId = ci.ItemResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
	WHERE (ci.PrimaryCat = 1) AND ';

	$where_clause = '';
	if ($this->exportOptions['export_ids'] === false) {
	// get links from current category & all it's subcategories
	if ($this->exportOptions['export_cats_ids'][0] == 0) {
	$where_clause = 1;
	}
	else {
	foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
	$where_clause .= '(c.ParentPath LIKE "%\|'.$category_id.'\|%") OR ';
	}
	$where_clause = preg_replace('/(.*) OR $/', '\\1', $where_clause);
	}
	}
	else {
	// get only selected links
	$where_clause = $this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
	}

	$max_level = $this->Conn->GetOne($sql.'('.$where_clause.')');

	if ($this->exportOptions['IsBaseCategory'] ) {
	$max_level -= $this->exportOptions['BaseLevel'];
	}

	return $max_level;
	}

	/**
	* Saves one record to export file
	*
	* @param Array $fields_hash
	*/
	function writeRecord($fields_hash)
	{
	fputcsv2($this->filePointer, $fields_hash, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy'], $this->getLineSeparator() );
	}

	function readRecord()
	{
	return fgetcsv($this->filePointer, 10000, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy']);
	}
	}

	?>

	Property changes on: trunk/core/units/general/cat_dbitem_export.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.5
	\ No newline at end of property
	Index: trunk/globals.php
	===================================================================
	--- trunk/globals.php (revision 3647)
	+++ trunk/globals.php (revision 3648)
	@@ -1,2064 +1,2066 @@
	<?php

	if (!function_exists('parse_portal_ini')) {
	function parse_portal_ini($file, $parse_section = false) {

	if (!file_exists($file)) return;

	if(file_exists($file) && !is_readable($file))
	die('Could Not Open Ini File');

	$contents = file($file);

	$retval = array();

	$section = '';
	$ln = 1;
	$resave = false;
	foreach($contents as $line) {
	if ($ln == 1 && $line != '<'.'?'.'php die() ?'.">\n") {
	$resave = true;
	}
	$ln++;
	$line = trim($line);
	$line = eregi_replace(';[.]*','',$line);
	if(strlen($line) > 0) {
	//echo $line . " - ";
	if(eregi('^[[a-z]+]$',str_replace(' ', '', $line))) {
	//echo 'section';
	$section = substr($line,1,(strlen($line)-2));
	if ($parse_section) {
	$retval[$section] = array();
	}
	continue;
	} elseif(eregi('=',$line)) {
	//echo 'main element';
	list($key,$val) = explode(' = ',$line);
	if (!$parse_section) {
	$retval[trim($key)] = str_replace('"', '', $val);
	}
	else {
	$retval[$section][trim($key)] = str_replace('"', '', $val);
	}
	} //end if
	//echo '<br />';
	} //end if
	} //end foreach
	if ($resave) {
	$fp = fopen($file, "w");
	reset($contents);
	fwrite($fp,'<'.'?'.'php die() ?'.">\n\n");
	foreach($contents as $line) fwrite($fp,"$line");
	fclose($fp);
	}

	return $retval;
	}
	}

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

	while($key = key($vars))
	{
	$key = "g_".$key;
	global $$key;
	$$key = current($vars); //variable variables
	next($vars);
	}

	/list the tables which contain item data /
	$ItemTables = array();

	$KeywordIgnore = array();
	global $debuglevel;

	$debuglevel = 0;
	//$GLOBALS['debuglevel'] = 0;

	/New, Hot, Pop field values /
	define('NEVER', 0);
	define('ALWAYS', 1);
	define('AUTO', 2);

	/Status Values /
	if( !defined('STATUS_DISABLED') ) define('STATUS_DISABLED', 0);
	if( !defined('STATUS_ACTIVE') ) define('STATUS_ACTIVE', 1);
	if( !defined('STATUS_PENDING') ) define('STATUS_PENDING', 2);

	$LogLevel = 0;
	$LogFile = NULL;

	/**
	* @return object
	* @desc Returns reference to database connection
	*/
	function &GetADODBConnection()
	{
	static $DB = null;

	global $g_DBType, $g_DBHost, $g_DBUser, $g_DBUserPassword, $g_DBName, $g_DebugMode;
	global $ADODB_FETCH_MODE, $ADODB_COUNTRECS, $ADODB_CACHE_DIR, $pathtoroot;

	if( !isset($DB) && strlen($g_DBType) > 0 )
	{
	$DB = ADONewConnection($g_DBType);
	$connected = $DB->Connect($g_DBHost, $g_DBUser, $g_DBUserPassword, $g_DBName);
	if(!$connected) die("Error connecting to database $g_DBHost <br>\n");

	$ADODB_CACHE_DIR = $pathtoroot."cache";
	$ADODB_FETCH_MODE = 2;
	$ADODB_COUNTRECS = false;
	$DB->debug = defined('ADODB_OUTP') ? 1 : 0;
	$DB->cacheSecs = 3600;
	$DB->Execute('SET SQL_BIG_SELECTS = 1');
	}
	elseif( !strlen($g_DBType) )
	{
	global $rootURL;
	echo 'In-Portal is probably not installed, or configuration file is missing.<br>';
	echo 'Please use the installation script to fix the problem.<br><br>';
	if ( !preg_match('/admin/', __FILE__) ) $ins = 'admin/';

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

	function GetNextResourceId($Increment=1)
	{
	global $objModules, $pathtoroot;
	$table_name = GetTablePrefix().'IdGenerator';

	$db = &GetADODBConnection();

	// dummy protection: get maximal resource id used actually and fix last_id used
	$max_resourceid = 0;

	$m = GetModuleArray();
	foreach($m as $key=>$value)
	{
	$path = $pathtoroot. $value."admin/include/parser.php";
	if(file_exists($path))
	{
	include_once($path);
	}
	}

	$table_info = $objModules->ExecuteFunction('GetModuleInfo', 'dupe_resourceids');
	$sql_template = 'SELECT MAX(ResourceId) FROM '.GetTablePrefix().'%s';

	foreach($table_info as $module_name => $module_info)
	{
	foreach($module_info as $module_sub_info)
	{
	$sql = sprintf($sql_template,$module_sub_info['Table']);
	$tmp_resourceid = $db->GetOne($sql);
	if($tmp_resourceid > $max_resourceid) $max_resourceid = $tmp_resourceid;
	}
	}

	// update lastid to be next resourceid available
	$db->Execute('LOCK TABLES '.$table_name.' WRITE');

	$last_id = $db->GetOne('SELECT lastid FROM '.$table_name);
	if ($last_id - 1 > $max_resourceid) $max_resourceid = $last_id - 1;

	$id_diff = $db->GetOne('SELECT '.$max_resourceid.' + 1 - lastid FROM '.$table_name);
	if($id_diff) $Increment += $id_diff;

	$sql = 'UPDATE '.$table_name.' SET lastid = lastid + '.$Increment; // set new id in db
	$db->Execute($sql);

	$val = $db->GetOne('SELECT lastid FROM '.$table_name);
	if($val === false)
	{
	$db->Execute('INSERT INTO '.$table_name.' (lastid) VALUES ('.$Increment.')');
	$val = $Increment;
	}
	$db->Execute('UNLOCK TABLES');

	return $val - $Increment + $id_diff; // return previous free id (-1) ?
	}

	function AddSlash($s)
	{
	if(substr($s,-1) != "/")
	{
	return $s."/";
	}
	else
	return $s;
	}

	function StripNewline($s)
	{
	$bfound = false;
	while (strlen($s)>0 && !$bfound)
	{
	if(ord(substr($s,-1))<32)
	{
	$s = substr($s,0,-1);
	}
	else
	$bfound = true;
	}
	return $s;
	}

	function DeleteElement($array, $indice)
	{
	for($i=$indice;$i<count($array)-1;$i++)
	$array[$i] = $array[$i+1];
	unset($array[count($array)-1]);
	return $array;
	}

	function DeleteElementValue($needle, &$haystack)
	{
	while(($gotcha = array_search($needle,$haystack)) > -1)
	unset($haystack[$gotcha]);
	}

	function TableCount($TableName, $where="",$JoinCats=1)
	{
	$db = &GetADODBConnection();
	if(!$JoinCats)
	{
	$sql = "SELECT count(*) as TableCount FROM $TableName";
	}
	else
	$sql = "SELECT count(*) as TableCount FROM $TableName INNER JOIN ".GetTablePrefix()."CategoryItems ON ".GetTablePrefix()."CategoryItems.ItemResourceId=$TableName.ResourceId";
	if(strlen($where)>0)
	$sql .= " WHERE ".$where;

	$rs = $db->Execute($sql);

	// echo "SQL TABLE COUNT: ".$sql."<br>\n";

	$res = $rs->fields["TableCount"];
	return $res;
	}

	Function QueryCount($sql)
	{
	$sql = preg_replace('/SELECT(.)FROM[ \n\r](.)/is','SELECT COUNT(*) AS TableCount FROM $2', $sql);
	$sql = preg_replace('/(.)LIMIT(.)/is','$1', $sql);
	$sql = preg_replace('/(.)ORDER BY(.)/is','$1', $sql);

	//echo $sql;

	$db =& GetADODBConnection();
	return $db->GetOne($sql);
	}

	function GetPageCount($ItemsPerPage,$NumItems)
	{
	if($ItemsPerPage==0 \|\| $NumItems==0)
	{
	return 1;
	}
	$value = $NumItems/$ItemsPerPage;
	return ceil($value);
	}


	/**
	* @return string
	* @desc Returns database table prefix entered while installation
	*/
	function GetTablePrefix()
	{
	global $g_TablePrefix;

	return $g_TablePrefix;
	}

	function TableHasPrefix($t)
	{
	$pre = GetTablePrefix();

	if(strlen($pre)>0)
	{
	if(substr($t,0,strlen($pre))==$pre)
	{
	return TRUE;
	}
	else
	return FALSE;
	}
	else
	return TRUE;
	}

	function AddTablePrefix($t)
	{
	if(!TableHasPrefix($t))
	$t = GetTablePrefix().$t;

	return $t;
	}

	function ThisDomain()
	{
	global $objConfig, $g_Domain;

	if($objConfig->Get("DomainDetect"))
	{
	$d = $_SERVER['HTTP_HOST'];
	}
	else
	$d = $g_Domain;

	return $d;
	}

	function GetIndexUrl($secure=0)
	{
	global $indexURL, $rootURL, $secureURL;

	if ( class_exists('kApplication') )
	{
	$application =& kApplication::Instance();
	return $application->BaseURL().'index.php';
	}

	switch($secure)
	{
	case 0:
	$ret = $indexURL;
	break;

	case 1:
	$ret = $secureURL."index.php";
	break;

	case 2:
	$ret = $rootURL."index.php";
	break;

	default:
	$ret = $i;
	break;
	}
	return $ret;
	}

	function GetLimitSQL($Page,$PerPage)
	{
	if($Page<1)
	$Page=1;

	if(is_numeric($PerPage))
	{
	if($PerPage==0)
	$PerPage = 20;
	$Start = ($Page-1)*$PerPage;
	$limit = "LIMIT ".$Start.",".$PerPage;
	}
	else
	$limit = NULL;
	return $limit;
	}

	function filelist ($currentdir, $startdir=NULL,$ext=NULL)
	{
	global $pathchar;

	//chdir ($currentdir);

	// remember where we started from
	if (!$startdir)
	{
	$startdir = $currentdir;
	}

	$d = @opendir($currentdir);

	$files = array();
	if(!$d)
	return $files;
	//list the files in the dir
	while (false !== ($file = readdir($d)))
	{
	if ($file != ".." && $file != ".")
	{
	if (is_dir($currentdir."/".$file))
	{
	// If $file is a directory take a look inside
	$a = filelist ($currentdir."/".$file, $startdir,$ext);
	if(is_array($a))
	$files = array_merge($files,$a);
	}
	else
	{
	if($ext!=NULL)
	{
	$extstr = stristr($file,".".$ext);
	if(strlen($extstr))
	$files[] = $currentdir."/".$file;
	}
	else
	$files[] = $currentdir.'/'.$file;
	}
	}
	}

	closedir ($d);

	return $files;
	}

	function DecimalToBin($dec,$WordLength=8)
	{
	$bits = array();

	$str = str_pad(decbin($dec),$WordLength,"0",STR_PAD_LEFT);
	for($i=$WordLength;$i>0;$i--)
	{
	$bits[$i-1] = (int)substr($str,$i-1,1);
	}
	return $bits;
	}
	/*
	function inp_escape($in, $html_enable=0)
	{
	$out = stripslashes($in);
	$out = str_replace("\n", "\n^br^", $out);
	if($html_enable==0)
	{
	$out=ereg_replace("<","<",$out);
	$out=ereg_replace(">",">",$out);
	$out=ereg_replace("\"",""",$out);
	$out = str_replace("\n^br^", "\n<br />", $out);
	}
	else
	$out = str_replace("\n^br^", "\n", $out);
	$out=addslashes($out);

	return $out;
	}
	*/
	function inp_escape($var,$html=0)
	{
	if($html)return $var;
	if(is_array($var))
	foreach($var as $k=>$v)
	$var[$k]=inp_escape($v);
	else
	// $var=htmlspecialchars($var,ENT_NOQUOTES);
	$var=strtr($var,Array('<'=>'<','>'=>'>',));
	return $var;
	}
	function inp_striptags($var,$html=0)
	{
	if($html)return $var;
	if(is_array($var))
	foreach($var as $k=>$v)
	$var[$k]=inp_striptags($v);
	else
	$var=strip_tags($var);
	return $var;
	}

	function inp_unescape($in)
	{
	// if (get_magic_quotes_gpc())
	return $in;
	$out=stripslashes($in);
	return $out;
	}

	function inp_textarea_unescape($in)
	{
	// if (get_magic_quotes_gpc())
	return $in;
	$out=stripslashes($in);
	$out = str_replace("\n<br />", "\n", $out);
	return $out;
	}

	function HighlightKeywords($Keywords, $html, $OpenTag="", $CloseTag="")
	{
	global $objConfig;

	if(!strlen($OpenTag))
	$OpenTag = "<B>";
	if(!strlen($CloseTag))
	$CloseTag = "</B>";

	$r = preg_split('((>)\|(<))', $html, -1, PREG_SPLIT_DELIM_CAPTURE);

	foreach ($Keywords as $k) {
	for ($i = 0; $i < count($r); $i++) {
	if ($r[$i] == "<") {
	$i++; continue;
	}
	$r[$i] = preg_replace("/($k)/i", "$OpenTag\\1$CloseTag", $r[$i]);
	}
	}
	return join("", $r);
	}

	/*
	function HighlightKeywords($Keywords,$html, $OpenTag="", $CloseTag="")
	{
	global $objConfig;

	if(!strlen($OpenTag))
	$OpenTag = "<B>";
	if(!strlen($CloseTag))
	$CloseTag = "</B>";
	$ret = strip_tags($html);

	foreach ($Keywords as $k)
	{
	if(strlen($k))
	{
	//$html = str_replace("<$k>", ":#:", $html);
	//$html = str_replace("</$k>", ":##:", $html);
	//$html = strip_tags($html);
	if ($html = preg_replace("/($k)/Ui","$OpenTag\\1$CloseTag", $html))
	//if ($html = preg_replace("/(>[^<])($k)([^<]< )/Ui","$OpenTag\\1$CloseTag", $html))
	$ret = $html;
	//$ret = str_replace(":#:", "<$k>", $ret);
	//$ret = str_replace(":##:", "</$k>", $ret);
	}
	}
	return $ret;
	}
	*/
	function ExtractDatePart($part,$datestamp)
	{
	switch($part)
	{
	case "month":
	if($datestamp<=0)
	{
	$ret = "";
	}
	else
	$ret = adodb_date("m",$datestamp);
	break;
	case "day":
	if($datestamp<=0)
	{
	$ret = "";
	}
	else
	$ret = adodb_date("d", $datestamp);
	break;
	case "year":
	if($datestamp<=0)
	{
	$ret = "";
	}
	else
	$ret = adodb_date("Y", $datestamp);
	break;
	case "time_24hr":
	if($datestamp<=0)
	{
	$ret = "";
	}
	else
	$ret = adodb_date("H:i", $datestamp);
	break;
	case "time_12hr":
	if($datestamp<=0)
	{
	$ret = "";
	}
	else
	$ret = adodb_date("g:i a",$datestamp);
	break;
	default:
	$ret = adodb_date($part, $datestamp);
	break;
	}
	return $ret;
	}

	function GetLocalTime($TimeStamp,$TargetZone=NULL)
	{
	if($TargetZone==NULL)
	$TargetZone = $objConfig->Get("Config_Site_Time");
	$server = $objConfig->Get("Config_Server_Time");
	if($TargetZone!=$server)
	{
	$offset = ($server - $TargetZone) * -1;
	$TimeStamp = $TimeStamp + (3600 * $offset);
	}
	return $TimeStamp;
	}

	function _unhtmlentities ($string)
	{
	$trans_tbl = get_html_translation_table (HTML_ENTITIES);
	$trans_tbl = array_flip ($trans_tbl);
	return strtr ($string, $trans_tbl);
	}

	function getLastStr($hay, $need){
	$getLastStr = 0;
	$pos = strpos($hay, $need);
	if (is_int ($pos)){ //this is to decide whether it is "false" or "0"
	while($pos) {
	$getLastStr = $getLastStr + $pos + strlen($need);
	$hay = substr ($hay , $pos + strlen($need));
	$pos = strpos($hay, $need);
	}
	return $getLastStr - strlen($need);
	} else {
	return -1; //if $need wasn´t found it returns "-1" , because it could return "0" if it´s found on position "0".
	}
	}

	// --- bbcode processing function: begin ----
	function PreformatBBCodes($text)
	{
	// convert phpbb url bbcode to valid in-bulletin's format
	// 1. urls
	$text = preg_replace('/\[url=(.)\](.)\[\/url\]/Ui','[url href="$1"]$2[/url]',$text);
	$text = preg_replace('/\[url\](.*)\[\/url\]/Ui','[url href="$1"]$1[/url]',$text);
	// 2. images
	$text = preg_replace('/\[img\](.*)\[\/img\]/Ui','[img src="$1" border="0"][/img]',$text);
	// 3. color
	$text = preg_replace('/\[color=(.)\](.)\[\/color\]/Ui','[font color="$1"]$2[/font]',$text);
	// 4. size
	$text = preg_replace('/\[size=(.)\](.)\[\/size\]/Ui','[font size="$1"]$2[/font]',$text);
	// 5. lists
	$text = preg_replace('/\[list(.)\](.)\[\/list\]/Uis','[ul]$2[/ul]',$text);
	// 6. email to link
	$text = preg_replace('/\[email\](.*)\[\/email\]/Ui','[url href="mailto:$1"]$1[/url]',$text);
	//7. b tag
	$text = preg_replace('/\[(b\|i\|u):(.)\](.)\[\/(b\|i\|u):(.*)\]/Ui','[$1]$3[/$4]',$text);
	//8. code tag
	$text = preg_replace('/\[code:(.)\](.)\[\/code:(.*)\]/Uis','[code]$2[/code]',$text);
	return $text;
	}

	/**
	* @return string
	* @param string $BBCode
	* @param string $TagParams
	* @param string $TextInside
	* @param string $ParamsAllowed
	* @desc Removes not allowed params from tag and returns result
	*/
	function CheckBBCodeAttribs($BBCode, $TagParams, $TextInside, $ParamsAllowed)
	{
	// $BBCode - bbcode to check, $TagParams - params string entered by user
	// $TextInside - text between opening and closing bbcode tag
	// $ParamsAllowed - list of allowed parameter names ("\|" separated)
	$TagParams=str_replace('\"','"',$TagParams);
	$TextInside=str_replace('\"','"',$TextInside);
	if( $ParamsAllowed && preg_match_all('/ +([^=])=["\']?([^ "\'])["\']?/is',$TagParams,$params,PREG_SET_ORDER) )
	{
	$ret = Array();
	foreach($params as $param)
	{
	// remove spaces in both parameter name & value & lowercase parameter name
	$param[1] = strtolower(trim($param[1])); // name lowercased
	if(($BBCode=='url')&&($param[1]=='href'))
	if(false!==strpos(strtolower($param[2]),'script:'))
	return $TextInside;
	// $param[2]='about:blank';
	if( isset($ParamsAllowed[ $param[1] ]) )
	$ret[] = $param[1].'="'.$param[2].'"';
	}
	$ret = count($ret) ? ' '.implode(' ',$ret) : '';
	return '<'.$BBCode.$ret.'>'.$TextInside.'</'.$BBCode.'>';
	}
	else
	return '<'.$BBCode.'>'.$TextInside.'</'.$BBCode.'>';
	return false;
	}
	function ReplaceBBCode($text)
	{
	global $objConfig;
	// convert phpbb bbcodes to in-bulletin bbcodes
	$text = PreformatBBCodes($text);

	// $tag_defs = 'b:;i:;u:;ul:type\|align;font:color\|face\|size;url:href;img:src\|border';

	$tags_defs = $objConfig->Get('BBTags');
	foreach(explode(';',$tags_defs) as $tag)
	{
	$tag = explode(':',$tag);
	$tag_name = $tag[0];
	$tag_params = $tag[1]?array_flip(explode('\|',$tag[1])):0;
	$text = preg_replace('/\['.$tag_name.'(.)\](.)\[\/'.$tag_name.' *\]/Uise','CheckBBCodeAttribs("'.$tag_name.'",\'$1\',\'$2\',$tag_params);', $text);
	}

	// additional processing for [url], [*], [img] bbcode
	$text = preg_replace('/<url>(.*)<\/url>/Usi','<url href="$1">$1</url>',$text);
	$text = preg_replace('/<font>(.*)<\/font>/Usi','$1',$text); // skip empty fonts
	$text = str_replace( Array('<url','</url>','[*]'),
	Array('<a target="_blank"','</a>','<li>'),
	$text);

	// bbcode [code]xxx[/code] processing
	$text = preg_replace('/\[code\](.*)\[\/code\]/Uise', "ReplaceCodeBBCode('$1')", $text);
	return $text;
	}
	function leadSpace2nbsp($x)
	{
	return "\n".str_repeat(' ',strlen($x));
	}
	function ReplaceCodeBBCode($input_string)
	{
	$input_string=str_replace('\"','"',$input_string);
	$input_string=$GLOBALS['objSmileys']->UndoSmileys(_unhtmlentities($input_string));
	$input_string=trim($input_string);
	$input_string=inp_htmlize($input_string);
	$input_string=str_replace("\r",'',$input_string);
	$input_string = str_replace("\t", " ", $input_string);
	$input_string = preg_replace('/\n( +)/se',"leadSpace2nbsp('$1')",$input_string);
	$input_string='<div style="border:1px solid #888888;width:100%;background-color:#eeeeee;margin-top:6px;margin-bottom:6px"><div style="padding:10px;"><code>'.$input_string.'</code></div></div>';
	// $input_string='<textarea wrap="off" style="border:1px solid #888888;width:100%;height:200px;background-color:#eeeeee;">'.inp_htmlize($input_string).'</textarea>';
	return $input_string;

	if(false!==strpos($input_string,'<'.'?'))
	{
	$input_string=str_replace('<'.'?','<'.'?php',$input_string);
	$input_string=str_replace('<'.'?phpphp','<'.'?php',$input_string);
	$input_string=@highlight_string($input_string,1);
	}
	else
	{
	$input_string = @highlight_string('<'.'?php'.$input_string.'?'.'>',1);
	$input_string = str_replace('<?php', '', str_replace('?>', '', $input_string));
	}
	return str_replace('<br />','',$input_string);

	}


	// --- bbcode processing function: end ----

	function GetMinValue($Table,$Field, $Where=NULL)
	{
	$ret = 0;
	$sql = "SELECT min($Field) as val FROM $Table ";
	if(strlen($where))
	$sql .= "WHERE $Where";
	$ado = &GetADODBConnection();
	$rs = $ado->execute($sql);
	if($rs)
	$ret = (int)$rs->fields["val"];
	return $ret;
	}


	if (!function_exists( 'getmicrotime' ) ) {
	function getmicrotime()
	{
	list($usec, $sec) = explode(" ",microtime());
	return ((float)$usec + (float)$sec);
	}
	}

	function SetMissingDataErrors($f)
	{
	global $FormError;

	$count = 0;
	if(is_array($_POST))
	{
	if(is_array($_POST["required"]))
	{
	foreach($_POST["required"] as $r)
	{
	$found = FALSE;
	if(is_array($_FILES))
	{
	if( isset($_FILES[$r]) && $_FILES[$r]['size'] > 0 ) $found = TRUE;
	}

	if(!strlen(trim($_POST[$r])) && !$found)
	{
	$count++;

	if (($r == "dob_day") \|\| ($r == "dob_month") \|\| ($r == "dob_year"))
	$r = "dob";

	$tag = isset($_POST["errors"]) ? $_POST["errors"][$r] : '';
	if(!strlen($tag))
	$tag = "lu_ferror_".$f."_".$r;
	$FormError[$f][$r] = language($tag);
	}
	}
	}
	}
	return $count;
	}

	function makepassword($length=10)
	{
	$pass_length=$length;

	$p1=array('b','c','d','f','g','h','j','k','l','m','n','p','q','r','s','t','v','w','x','y','z');
	$p2=array('a','e','i','o','u');
	$p3=array('1','2','3','4','5','6','7','8','9');
	$p4=array('(','&',')',';','%'); // if you need real strong stuff

	// how much elements in the array
	// can be done with a array count but counting once here is faster

	$s1=21;// this is the count of $p1
	$s2=5; // this is the count of $p2
	$s3=9; // this is the count of $p3
	$s4=5; // this is the count of $p4

	// possible readable combinations

	$c1='121'; // will be like 'bab'
	$c2='212'; // will be like 'aba'
	$c3='12'; // will be like 'ab'
	$c4='3'; // will be just a number '1 to 9' if you dont like number delete the 3
	// $c5='4'; // uncomment to active the strong stuff

	$comb='4'; // the amount of combinations you made above (and did not comment out)



	for ($p=0;$p<$pass_length;)
	{
	mt_srand((double)microtime()*1000000);
	$strpart=mt_rand(1,$comb);
	// checking if the stringpart is not the same as the previous one
	if($strpart<>$previous)
	{
	$pass_structure.=${'c'.$strpart};

	// shortcutting the loop a bit
	$p=$p+strlen(${'c'.$strpart});
	}
	$previous=$strpart;
	}


	// generating the password from the structure defined in $pass_structure
	for ($g=0;$g<strlen($pass_structure);$g++)
	{
	mt_srand((double)microtime()*1000000);
	$sel=substr($pass_structure,$g,1);
	$pass.=${'p'.$sel}[mt_rand(0,-1+${'s'.$sel})];

	}
	return $pass;
	}

	function LogEntry($text,$writefile=FALSE)
	{
	global $g_LogFile,$LogFile, $LogData, $LogLevel, $timestart;

	static $last;

	if(strlen($g_LogFile))
	{
	$el = str_pad(getmicrotime()- $timestart,10," ");
	if($last>0)
	$elapsed = getmicrotime() - $last;

	if(strlen($el)>10)
	$el = substr($el,0,10);
	$indent = str_repeat(" ",$LogLevel);
	$text = str_pad($text,$LogLevel,"==",STR_PAD_LEFT);
	$LogData .= "$el:". round($elapsed,6).":$indent $text";
	$last = getmicrotime();
	if($writefile==TRUE && is_writable($g_LogFile))
	{
	if(!$LogFile)
	{
	if(file_exists($g_LogFile))
	unlink($g_LogFile);
	$LogFile=@fopen($g_LogFile,"w");
	}
	if($LogFile)
	{
	fputs($LogFile,$LogData);
	}
	}
	}
	}

	function ValidEmail($email)
	{
	if (eregi("^[a-z0-9]+([-_\.]?[a-z0-9])+@[a-z0-9]+([-_\.]?[a-z0-9])+\.[a-z]{2,4}", $email))
	{
	return TRUE;
	}
	else
	{
	return FALSE;
	}
	}

	function language($phrase,$LangId=0)
	{
	global $objSession, $objLanguageCache, $objLanguages;

	if($LangId==0)
	$LangId = $objSession->Get("Language");

	if($LangId==0)
	$LangId = $objLanguages->GetPrimary();

	$translation = $objLanguageCache->GetTranslation($phrase,$LangId);

	return $translation;
	}

	function admin_language($phrase,$lang=0,$LinkMissing=FALSE)
	{
	global $objSession, $objLanguageCache, $objLanguages;

	//echo "Language passed: $lang<br>";

	if($lang==0)
	$lang = $objSession->Get("Language");

	//echo "Language from session: $lang<br>";

	if($lang==0)
	$lang = $objLanguages->GetPrimary();

	//echo "Language after primary: $lang<br>";
	//echo "Phrase: $phrase<br>";
	$translation = $objLanguageCache->GetTranslation($phrase,$lang);
	if($LinkMissing && substr($translation,0,1)=="!" && substr($translation,-1)=="!")
	{
	$res = "<A href=\"javascript:OpenPhraseEditor('&direct=1&label=$phrase'); \">$translation</A>";
	return $res;
	}
	else
	return $translation;
	}

	function prompt_language($phrase,$lang=0)
	{
	return admin_language($phrase,$lang,TRUE);
	}

	function GetPrimaryTranslation($Phrase)
	{
	global $objLanguages;

	$l = $objLanguages->GetPrimary();
	return language($Phrase,$l);
	}

	function CategoryNameCount($ParentId,$Name)
	{
	$cat_table = GetTablePrefix()."Category";
	$sql = "SELECT Name from $cat_table WHERE ParentId=$ParentId AND ";
	$sql .="(Name LIKE '".addslashes($Name)."' OR Name LIKE 'Copy of ".addslashes($Name)."' OR Name LIKE 'Copy % of ".addslashes($Name)."')";

	$ado = &GetADODBConnection();
	$rs = $ado->Execute($sql);
	$ret = array();
	while($rs && !$rs->EOF)
	{
	$ret[] = $rs->fields["Name"];
	$rs->MoveNext();
	}
	return $ret;
	}

	function CategoryItemNameCount($CategoryId,$Table,$Field,$Name)
	{
	$Name=addslashes($Name);
	$cat_table = GetTablePrefix()."CategoryItems";
	$sql = "SELECT $Field FROM $Table INNER JOIN $cat_table ON ($Table.ResourceId=$cat_table.ItemResourceId) ";
	$sql .=" WHERE ($Field LIKE 'Copy % of $Name' OR $Field LIKE '$Name' OR $Field LIKE 'Copy of $Name') AND CategoryId=$CategoryId";
	//echo $sql."<br>\n ";
	$ado = &GetADODBConnection();
	$rs = $ado->Execute($sql);
	$ret = array();
	while($rs && !$rs->EOF)
	{
	$ret[] = $rs->fields[$Field];
	$rs->MoveNext();
	}
	return $ret;
	}

	function &GetItemCollection($ItemName)
	{
	global $objItemTypes;

	if(is_numeric($ItemName))
	{
	$item = $objItemTypes->GetItem($ItemName);
	}
	else
	$item = $objItemTypes->GetTypeByName($ItemName);
	if(is_object($item))
	{
	$module = $item->Get("Module");
	$prefix = ModuleTagPrefix($module);
	$func = $prefix."_ItemCollection";
	if(function_exists($func))
	{
	$var =& $func();
	}
	}
	return $var;
	}


	function UpdateCategoryCount($item_type,$CategoriesIds,$ListType='')
	{
	global $objCountCache, $objItemTypes;
	$db=&GetADODBConnection();
	if( !is_numeric($item_type) )
	{
	$sql = 'SELECT ItemType FROM '.$objItemTypes->SourceTable.' WHERE ItemName=\''.$item_type.'\'';
	$item_type=$db->GetOne($sql);
	}
	$objCountCache->EraseGlobalTypeCache($item_type);
	if($item_type)
	{
	if(is_array($CategoriesIds))
	{
	$CategoriesIds=implode(',',$CategoriesIds);
	}
	if (!$CategoriesIds)
	{

	}

	if(!is_array($ListType)) $ListType=Array($ListType=>'opa');

	$sql = 'SELECT ParentPath FROM '.GetTablePrefix().'Category WHERE CategoryId IN ('.$CategoriesIds.')';
	$rs = $db->Execute($sql);
	$parents = Array();
	while (!$rs->EOF)
	{
	$tmp=$rs->fields['ParentPath'];
	$tmp=substr($tmp,1,strlen($tmp)-2);
	$tmp=explode('\|',$tmp);
	foreach ($tmp as $tmp_cat_id) {
	$parents[$tmp_cat_id]=1;
	}
	$rs->MoveNext();
	}
	$parents=array_keys($parents);
	$list_types=array_keys($ListType);
	foreach($parents as $ParentCategoryId)
	{
	foreach ($list_types as $list_type) {
	$objCountCache->DeleteValue($list_type, $item_type, $ParentCategoryId, 0); // total count
	$objCountCache->DeleteValue($list_type, $item_type, $ParentCategoryId, 1); // total count today
	}
	}
	}
	else
	{
	die('wrong item type passed to "UpdateCategoryCount"');
	}

	/* if(is_object($item))
	{
	$ItemType = $item->Get("ItemType");

	$sql = "DELETE FROM ".$objCountCache->SourceTable." WHERE ItemType=$ItemType";
	if( is_numeric($ListType) ) $sql .= " AND ListType=$ListType";
	$objCountCache->adodbConnection->Execute($sql);
	} */
	}

	function ResetCache($CategoryId)
	{
	global $objCountCache;
	$db =& GetADODBConnection();
	$sql = 'SELECT ParentPath FROM '.GetTablePrefix().'Category WHERE CategoryId = '.$CategoryId;
	$parents = $db->GetOne($sql);
	$parents = substr($parents,1,strlen($parents)-2);
	$parents = explode('\|',$parents);
	foreach($parents as $ParentCategoryId)
	{
	$objCountCache->DeleteValue('_', TYPE_TOPIC, $ParentCategoryId, 0); // total topic count
	$objCountCache->DeleteValue('_', TYPE_TOPIC, $ParentCategoryId, 1); // total
	}
	}

	function UpdateModifiedCategoryCount($ItemTypeName,$CatId=NULL,$Modifier=0,$ExtraId=NULL)
	{
	}

	function UpdateGroupCategoryCount($ItemTypeName,$CatId=NULL,$Modifier=0,$GroupId=NULL)
	{
	}

	function GetTagCache($module,$tag,$attribs,$env)
	{
	global $objSystemCache, $objSession, $objConfig;

	if($objConfig->Get("SystemTagCache") && !$objSession->Get('PortalUserId'))
	{
	$name = $tag;
	if(is_array($attribs))
	{
	foreach($attribs as $n => $val)
	{
	$name .= "-".$val;
	}
	}
	$CachedValue = $objSystemCache->GetContextValue($name,$module,$env, $objSession->Get("GroupList"));
	}
	else
	$CachedValue="";
	return $CachedValue;
	}

	function SaveTagCache($module, $tag, $attribs, $env, $newvalue)
	{
	global $objSystemCache, $objSession, $objConfig;

	if($objConfig->Get("SystemTagCache"))
	{
	$name = $tag;
	if(is_array($attribs))
	{
	foreach($attribs as $a => $val)
	{
	$name .= "-".$val;
	}
	}
	$objSystemCache->EditCacheItem($name,$newvalue,$module,0,$env,$objSession->Get("GroupList"));
	}
	}

	function DeleteTagCache($name,$extraparams, $env="")
	{
	global $objSystemCache, $objConfig;

	if($objConfig->Get("SystemTagCache"))
	{
	$where = "Name LIKE '$name%".$extraparams."'";
	if(strlen($env))
	$where .= " AND Context LIKE $env";
	$objSystemCache->DeleteCachedItem($where);
	}
	}

	/**
	* Deletes whole tag cache for
	* selected module
	*
	* @param string $module
	* @param string $name
	* @access public
	*/
	function DeleteModuleTagCache($module, $tagname='')
	{
	global $objSystemCache, $objConfig;

	if($objConfig->Get("SystemTagCache"))
	{
	$where = 'Module LIKE \''.$module.'\'';
	if(strlen($tagname))
	{
	$where .= ' AND Name LIKE \''.$tagname.'\'';
	}
	$objSystemCache->DeleteCachedItem($where);
	}
	}



	/*function ClearTagCache()
	{
	global $objSystemCache, $objConfig;

	if($objConfig->Get("SystemTagCache"))
	{
	$where = '';
	$objSystemCache->DeleteCachedItem($where);
	}
	}*/

	/*function EraseCountCache()
	{
	// global $objSystemCache, $objConfig;

	$db =& GetADODBConnection();
	$sql = 'DELETE * FROM '.GetTablePrefix().'CountCache';
	return $db->Execute($sql) ? true : false;
	}*/


	function ParseTagLibrary()
	{
	$objTagList = new clsTagList();
	$objTagList->ParseInportalTags();
	unset($objTagList);
	}

	function GetDateFormat($LangId=0)
	{
	global $objLanguages;

	if(!$LangId)
	$LangId= $objLanguages->GetPrimary();
	$l = $objLanguages->GetItem($LangId);
	if(is_object($l))
	{
	$fmt = $l->Get("DateFormat");
	}
	else
	$fmt = "m-d-Y";

	if(isset($GLOBALS['FrontEnd'])&&$GLOBALS['FrontEnd'])
	return $fmt;
	return preg_replace('/y+/i','Y',$fmt);
	}

	function GetTimeFormat($LangId=0)
	{
	global $objLanguages;

	if(!$LangId)
	$LangId= $objLanguages->GetPrimary();
	$l = $objLanguages->GetItem($LangId);
	if(is_object($l))
	{
	$fmt = $l->Get("TimeFormat");
	}
	else
	$fmt = "H:i:s";
	return $fmt;
	}

	/**
	* Gets one of currently selected language options
	*
	* @param string $optionName
	* @param int $LangId
	* @return string
	* @access public
	*/
	function GetRegionalOption($optionName,$LangId=0)
	{
	global $objLanguages, $objSession;

	if(!$LangId) $LangId=$objSession->Get('Language');
	if(!$LangId) $LangId=$objLanguages->GetPrimary();
	$l = $objLanguages->GetItem($LangId);
	return is_object($l)?$l->Get($optionName):false;
	}

	function LangDate($TimeStamp=NULL,$LangId=0)
	{
	$fmt = GetDateFormat($LangId);
	$ret = adodb_date($fmt,$TimeStamp);
	return $ret;
	}

	function LangTime($TimeStamp=NULL,$LangId=0)
	{
	$fmt = GetTimeFormat($LangId);
	$ret = adodb_date($fmt,$TimeStamp);
	return $ret;
	}

	function LangNumber($Num,$DecPlaces=NULL,$LangId=0)
	{
	global $objLanguages;

	if(!$LangId)
	$LangId= $objLanguages->GetPrimary();
	$l = $objLanguages->GetItem($LangId);
	if(is_object($l))
	{
	$ret = number_format($Num,$DecPlaces,$l->Get("DecimalPoint"),$l->Get("ThousandSep"));
	}
	else
	$ret = $num;

	return $ret;
	}

	function replacePngTags($x, $spacer="images/spacer.gif")
	{
	global $rootURL,$pathtoroot;

	// make sure that we are only replacing for the Windows versions of Internet
	// Explorer 5+, and not Opera identified as MSIE
	$msie='/msie\s([5-9])\.?[0-9].(win)/i';
	$opera='/opera\s+[0-9]+/i';
	if(!isset($_SERVER['HTTP_USER_AGENT']) \|\|
	!preg_match($msie,$_SERVER['HTTP_USER_AGENT']) \|\|
	preg_match($opera,$_SERVER['HTTP_USER_AGENT']))
	return $x;

	// find all the png images in backgrounds
	preg_match_all('/background-image:\surl$\'(.\.png)\'$;/Uis',$x,$background);
	for($i=0;$i<count($background[0]);$i++){
	// simply replace:
	// "background-image: url('image.png');"
	// with:
	// "filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(
	// enabled=true, sizingMethod=scale src='image.png');"
	// haven't tested to see if background-repeat styles work...
	$x=str_replace($background[0][$i],'filter:progid:DXImageTransform.'.
	'Microsoft.AlphaImageLoader(enabled=true, sizingMethod=scale'.
	' src=\''.$background[1][$i].'\');',$x);
	}

	// OK, time to find all the IMG tags with ".png" in them
	preg_match_all('/(<img.\.png.>\|<input.type=([\'"])image\\2.\.png.*>)/Uis',$x,$images);
	while(list($imgnum,$v)=@each($images[0])){
	$original=$v;
	$atts=''; $width=0; $height=0;
	// If the size is defined by styles, find
	preg_match_all('/style=".(width: ([0-9]+))px.'.
	'(height: ([0-9]+))px.*"/Ui',$v,$arr2);
	if(is_array($arr2) && count($arr2[0])){
	// size was defined by styles, get values
	$width=$arr2[2][0];
	$height=$arr2[4][0];
	}
	// size was not defined by styles, get values
	preg_match_all('/width=\"?([0-9]+)\"?/i',$v,$arr2);
	if(is_array($arr2) && count($arr2[0])){
	$width=$arr2[1][0];
	}
	preg_match_all('/height=\"?([0-9]+)\"?/i',$v,$arr2);
	if(is_array($arr2) && count($arr2[0])){
	$height=$arr2[1][0];
	}
	preg_match_all('/src=\"([^\"]+\.png)\"/i',$v,$arr2);
	if(isset($arr2[1][0]) && !empty($arr2[1][0]))
	$image=$arr2[1][0];
	else
	$image=NULL;

	// We do this so that we can put our spacer.gif image in the same
	// directory as the image
	$tmp=split('[\\/]',$image);
	array_pop($tmp);
	$image_path=join('/',$tmp);
	if(substr($image,0,strlen($rootURL))==$rootURL)
	{
	$path = str_replace($rootURL,$pathtoroot,$image);
	}
	else
	{
	$path = $pathtoroot."themes/telestial/$image";
	}
	// echo "Sizing $path.. <br>\n";
	// echo "Full Tag: ".htmlentities($image)."<br>\n";
	//if(!$height \|\| !$width)
	//{

	$g = imagecreatefrompng($path);
	if($g)
	{
	$height = imagesy($g);
	$width = imagesx($g);
	}
	//}
	if(strlen($image_path)) $image_path.='/';

	// end quote is already supplied by originial src attribute
	$replace_src_with=$spacer.'" style="width: '.$width.
	'px; height: '.$height.'px; filter: progid:DXImageTransform.'.
	'Microsoft.AlphaImageLoader(src=\''.$image.'\', sizingMethod='.
	'\'scale\')';

	// now create the new tag from the old
	$new_tag=str_replace($image,$replace_src_with,$original);

	// now place the new tag into the content
	$x=str_replace($original,$new_tag,$x);
	}
	return $x;
	}

	if (!function_exists('print_pre')) {
	function print_pre($str)
	{
	// no comments here :)
	echo '<pre>'.print_r($str, true).'</pre>';
	}
	}

	function GetOptions($field) // by Alex
	{
	// get dropdown values from custom field
	$tmp =& new clsCustomField();

	$tmp->LoadFromDatabase($field, 'FieldName');
	$tmp_values = $tmp->Get('ValueList');
	unset($tmp);
	$tmp_values = explode(',', $tmp_values);

	foreach($tmp_values as $mixed)
	{
	$elem = explode('=', trim($mixed));
	$ret[ $elem[0] ] = $elem[1];
	}
	return $ret;
	}

	function ResetPage($module_prefix, $page_variable = 'p')
	{
	// resets page in specific module when category is changed
	global $objSession;
	if( !is_object($objSession) ) // when changing pages session doesn't exist -> InPortal BUG
	{
	global $var_list, $SessionQueryString, $FrontEnd;
	$objSession = new clsUserSession($var_list["sid"],($SessionQueryString && $FrontEnd==1));
	}

	$last_cat = $objSession->GetVariable('last_category');
	$prev_cat = $objSession->GetVariable('prev_category');
	//echo "Resetting Page [$prev_cat] -> [$last_cat]<br>";

	if($prev_cat != $last_cat) $GLOBALS[$module_prefix.'_var_list'][$page_variable] = 1;
	}

	if( !function_exists('GetVar') )
	{
	/**
	* @return string
	* @param string $name
	* @param bool $post_priority
	* @desc Get's variable from http query
	*/
	function GetVar($name, $post_priority = false)
	{
	if(!$post_priority) // follow gpc_order in php.ini
	return isset($_REQUEST[$name]) ? $_REQUEST[$name] : false;
	else // get variable from post 1stly if not found then from get
	return isset($_POST[$name]) && $_POST[$name] !== false ? $_POST[$name] : ( isset($_GET[$name]) && $_GET[$name] ? $_GET[$name] : false );
	}
	}

	function SetVar($VarName, $VarValue)
	{
	$_REQUEST[$VarName] = $VarValue;
	$_POST[$VarName] = $VarValue;
	$_GET[$VarName] = $VarValue;
	}

	function PassVar(&$source)
	{
	// source array + any count of key names in passed array
	$params = func_get_args();
	array_shift($params);

	if( count($params) )
	{
	$ret = Array();
	foreach($params as $var_name)
	if( isset($source[$var_name]) )
	$ret[] = $var_name.'='.$source[$var_name];
	$ret = '&'.implode('&', $ret);
	}
	return $ret;
	}

	function GetSubmitVariable(&$array, $postfix)
	{
	// gets edit status of module
	// used in case if some modules share
	// common action parsed by kernel parser,
	// but each module uses own EditStatus variable

	$modules = Array('In-Link' => 'Link', 'In-News' => 'News', 'In-Bulletin' => 'Topic', 'In-Portal'=>'Review');
	foreach($modules as $module => $prefix)
	if( isset($array[$prefix.$postfix]) )
	return Array('Module' => $module, 'variable' => $array[$prefix.$postfix]);
	return false;
	}

	function GetModuleByAction()
	{
	$prefix2module = Array('m' => 'In-Portal', 'l' => 'In-Link', 'n' => 'In-News', 'bb' => 'In-Bulletin');
	$action = GetVar('Action');
	if($action)
	{
	$module_prefix = explode('_', $action);
	return $prefix2module[ $module_prefix[0] ];
	}
	else
	return false;
	}

	function dir_size($dir) {
	// calculates folder size based on filesizes inside it (recursively)
	$totalsize=0;
	if ($dirstream = @opendir($dir)) {
	while (false !== ($filename = readdir($dirstream))) {
	if ($filename!="." && $filename!="..")
	{
	if (is_file($dir."/".$filename))
	$totalsize+=filesize($dir."/".$filename);

	if (is_dir($dir."/".$filename))
	$totalsize+=dir_size($dir."/".$filename);
	}
	}
	}
	closedir($dirstream);
	return $totalsize;
	}

	function size($bytes) {
	// shows formatted file/directory size
	$types = Array("la_bytes","la_kilobytes","la_megabytes","la_gigabytes","la_terabytes");
	$current = 0;
	while ($bytes > 1024) {
	$current++;
	$bytes /= 1024;
	}
	return round($bytes,2)." ".language($types[$current]);
	}

	function echod($str)
	{
	// echo debug output
	echo str_replace( Array('[',']'), Array('[<b>', '</b>]'), $str).'<br>';
	}


	function PrepareParams($source, $to_lower, $mapping)
	{
	// prepare array with form values to use with item
	$result = Array();
	foreach($to_lower as $field)
	$result[ $field ] = $source[ strtolower($field) ];

	if( is_array($mapping) )
	{
	foreach($mapping as $field_from => $field_to)
	$result[$field_to] = $source[$field_from];
	}

	return $result;
	}

	function GetELT($field, $phrases = Array())
	{
	// returns FieldOptions equivalent in In-Portal
	$ret = Array();
	foreach($phrases as $phrase)
	$ret[] = admin_language($phrase);
	$ret = "'".implode("','", $ret)."'";
	return 'ELT('.$field.','.$ret.')';
	}

	function GetModuleImgPath($module)
	{
	global $rootURL, $admin;
	return $rootURL.$module.'/'.$admin.'/images';
	}

	function ActionPostProcess($StatusField, $ListClass, $ListObjectName = '', $IDField = null)
	{
	// each action postprocessing stuff from admin
	if( !isset($_REQUEST[$StatusField]) ) return false;

	$list =& $GLOBALS[$ListObjectName];
	if( !is_object($list) ) $list = new $ListClass();
	$SFValue = $_REQUEST[$StatusField]; // status field value
	switch($SFValue)
	{
	case 1: // User hit "Save" button
	$list->CopyFromEditTable($IDField);
	break;
	case 2: // User hit "Cancel" button
	$list->PurgeEditTable($IDField);
	break;
	}
	if( function_exists('SpecificProcessing') ) SpecificProcessing($StatusField, $SFValue);
	if($SFValue == 1 \|\| $SFValue == 2) $list->Clear();
	}

	if( !function_exists('getArrayValue') )
	{
	/**
	* Returns array value if key exists
	*
	* @param Array $aArray
	* @param int $aIndex
	* @return string
	*/
	function getArrayValue(&$aArray, $aIndex)
	{
	return isset($aArray[$aIndex]) ? $aArray[$aIndex] : false;
	}
	}
	function MakeHTMLTag($element, $attrib_prefix)
	{
	$result = Array();
	$ap_length = strlen($attrib_prefix);
	foreach($element->attributes as $attib_name => $attr_value)
	if( substr($attib_name, $ap_length) == $ap_length )
	$result[] = substr($attib_name, $ap_length, strlen($attib_name)).'="'.$attr_value.'"';
	return count($result) ? implode(' ', $result) : false;
	}

	function GetImportScripts()
	{
	// return currently installed import scripts
	static $import_scripts = Array();
	if( count($import_scripts) == 0 )
	{
	- $sql = 'SELECT * FROM '.GetTablePrefix().'ImportScripts ORDER BY is_id';
	- $db =&GetADODBConnection();
	+
	+ $sql = 'SELECT imp.* , m.LoadOrder
	+ FROM '.TABLE_PREFIX.'ImportScripts imp
	+ LEFT JOIN '.TABLE_PREFIX.'Modules m ON m.Name = imp.is_Module
	+ ORDER BY m.LoadOrder';
	+
	+ $db =& GetADODBConnection();
	$rs = $db->Execute($sql);
	- if( $rs && $rs->RecordCount() > 0 )
	- {
	- while(!$rs->EOF)
	- {
	+ if ($rs && $rs->RecordCount() > 0) {
	+ while (!$rs->EOF) {
	$rec =& $rs->fields;
	- $import_scripts[] = Array( 'label' => $rec['is_label'], 'url' => $rec['is_script'],
	+ $import_scripts[ $rec['is_id'] ] = Array( 'label' => $rec['is_label'], 'url' => $rec['is_script'],
	'enabled' => $rec['is_enabled'], 'field_prefix' => $rec['is_field_prefix'],
	'id' => $rec['is_string_id'], 'required_fields' => $rec['is_requred_fields'],
	'module' => strtolower($rec['is_Module']) );
	$rs->MoveNext();
	}
	}
	- else
	- {
	+ else {
	$import_scripts = Array();
	}
	}
	return $import_scripts;
	}

	function GetImportScript($id)
	{
	$scripts = GetImportScripts();
	return isset($scripts[$id]) ? $scripts[$id] : false;
	}
	function GetNextTemplate($current_template)
	{
	// used on front, returns next template to make
	// redirect to
	$dest = GetVar('dest', true);
	if(!$dest) $dest = GetVar('DestTemplate', true);
	return $dest ? $dest : $current_template;
	}


	// functions for dealign with enviroment variable construction
	function GenerateModuleEnv($prefix, $var_list)
	{
	// globalize module varible arrays
	$main =& $GLOBALS[$prefix.'_var_list'];
	$update =& $GLOBALS[$prefix.'_var_list_update'];
	//echo "VAR: [$main]; VAR_UPDATE: [$update]<br>";

	// if update var count is zero, then do nothing
	if( !is_array($update) \|\| count($update) == 0 ) return '';

	// ensure that we have no empty values in enviroment variable
	foreach($update as $vl_key => $vl_value) {
	if(!$vl_value) $update[$vl_key] = '0'; // unset($update[$vl_key]);
	}

	foreach($main as $vl_key => $vl_value) {
	if(!$vl_value) $main[$vl_key] = '0'; // unset($main[$vl_key]);
	}

	$ret = Array();
	foreach($var_list as $var_name) {
	$value = GetEnvVar($prefix, $var_name);
	if(!$value && $var_name == 'id') $value = '0';
	$ret[] = $value;
	}

	// Removing all var_list_udpate
	$keys = array_keys($update);
	foreach ($keys as $key) {
	unset($update[$key]);
	}

	return ':'.$prefix.implode('-',$ret);
	}

	// functions for dealign with enviroment variable construction
	function GenerateModuleEnv_NEW($prefix, $var_list)
	{
	// globalize module varible arrays
	$main =& $GLOBALS[$prefix.'_var_list'];
	$update =& $GLOBALS[$prefix.'_var_list_update'];
	//echo "VAR: [$main]; VAR_UPDATE: [$update]<br>";

	if ( isset($update) && $update )
	{
	// ensure that we have no empty values in enviroment variable
	foreach($update as $vl_key => $vl_value) {
	if(!$vl_value) $update[$vl_key] = '0'; // unset($update[$vl_key]);
	}

	$app =& kApplication::Instance();
	$passed = $app->GetVar('prefixes_passed');
	$passed[] = $prefix;
	$app->SetVar('prefixes_passed', $passed);
	}
	else
	{
	return Array();
	}

	foreach($main as $vl_key => $vl_value) {
	if(!$vl_value) $main[$vl_key] = '0'; // unset($main[$vl_key]);
	}

	$ret = Array();
	foreach($var_list as $src_name => $dst_name) {
	$ret[$dst_name] = GetEnvVar($prefix, $src_name);
	}

	// Removing all var_list_udpate
	if ( isset($update) && $update )
	{
	$keys = array_keys($update);
	foreach ($keys as $key) unset($update[$key]);
	}
	return $ret;
	}

	function GetEnvVar($prefix, $name)
	{
	// get variable from template variable's list
	// (used in module parsers to build env string)
	$main =& $GLOBALS[$prefix.'_var_list'];
	$update =& $GLOBALS[$prefix.'_var_list_update'];

	return isset($update[$name]) ? $update[$name] : ( isset($main[$name]) ? $main[$name] : '');
	}

	/**
	* Checks if debug mode is active
	*
	* @return bool
	*/
	function IsDebugMode($check_debugger = true)
	{
	$debug_mode = defined('DEBUG_MODE') && DEBUG_MODE;
	if($check_debugger) $debug_mode = $debug_mode && isset($GLOBALS['debugger']);
	return $debug_mode;
	}

	/**
	* Checks if we are in admin
	*
	* @return bool
	*/
	function IsAdmin()
	{
	return defined('ADMIN') && constant('ADMIN') == 1 ? 1 : 0;
	}

	/**
	* Two strings in-case-sensitive compare.
	* Returns >0, when string1 > string2,
	* <0, when string1 > string2,
	* 0, when string1 = string2
	*
	* @param string $string1
	* @param string $string2
	* @return int
	*/
	function stricmp ($string1, $string2) {
	return strcmp(strtolower($string1), strtolower($string2));
	}

	/**
	* Generates unique code
	*
	* @return string
	*/
	function GenerateCode()
	{
	list($usec, $sec) = explode(" ",microtime());

	$id_part_1 = substr($usec, 4, 4);
	$id_part_2 = mt_rand(1,9);
	$id_part_3 = substr($sec, 6, 4);
	$digit_one = substr($id_part_1, 0, 1);
	if ($digit_one == 0) {
	$digit_one = mt_rand(1,9);
	$id_part_1 = ereg_replace("^0","",$id_part_1);
	$id_part_1=$digit_one.$id_part_1;
	}
	return $id_part_1.$id_part_2.$id_part_3;
	}

	function bracket_comp($elem1, $elem2)
	{
	if( ($elem1['End']>$elem2['End'] \|\| $elem1['End'] == -1) && $elem2['End'] != -1 )
	{
	return 1;
	}
	elseif ( ($elem1['End']<$elem2['End'] \|\| $elem2['End'] == -1) && $elem1['End'] != -1 )
	{
	return -1;
	}
	else
	{
	return 0;
	}
	}

	function bracket_id_sort($first_id, $second_id)
	{
	$first_abs = abs($first_id);
	$second_abs = abs($second_id);
	$first_sign = ($first_id == 0) ? 0 : $first_id / $first_abs;
	$second_sign = ($second_id == 0) ? 0 : $second_id / $second_abs;
	if($first_sign != $second_sign)
	{
	if($first_id > $second_id) {
	$bigger =& $first_abs;
	$smaller =& $second_abs;
	}
	else {
	$bigger =& $second_abs;
	$smaller =& $first_abs;
	}
	$smaller = $bigger + $smaller;
	}

	if($first_abs > $second_abs) {
	return 1;
	}
	elseif ($first_abs < $second_abs)
	{
	return -1;
	}
	else
	{
	return 0;
	}
	}

	function pr_bracket_comp($elem1, $elem2)
	{

	if ($elem1['MinQty']!="" && $elem1['MaxQty']=="" && $elem2['MinQty']!="" && $elem2['MaxQty']!="") return 1;
	if ($elem1['MinQty']!="" && $elem1['MaxQty']=="" && $elem2['MinQty']=="" && $elem2['MaxQty']=="") return -1;


	if ($elem1['MaxQty']=="" && $elem2['MaxQty']!="") return 1;
	if ($elem1['MaxQty']!="" && $elem2['MaxQty']=="") return -1;


	if( ($elem1['MaxQty']>$elem2['MaxQty'] && $elem2['MaxQty']!=-1) \|\| ($elem1['MaxQty'] == -1 && $elem2['MaxQty'] != -1 ))
	{
	return 1;
	}
	elseif ( ($elem1['MaxQty']<$elem2['MaxQty']) \|\| ($elem2['MaxQty'] == -1 && $elem1['MaxQty'] != -1 ))
	{
	return -1;
	}
	else
	{
	return 0;
	}
	}

	function ap_bracket_comp($elem1, $elem2)
	{

	if ($elem1['FromAmount']!="" && $elem1['ToAmount']=="" && $elem2['FromAmount']!="" && $elem2['ToAmount']!="") return 1;
	if ($elem1['FromAmount']!="" && $elem1['ToAmount']=="" && $elem2['FromAmount']=="" && $elem2['ToAmount']=="") return -1;


	if ($elem1['ToAmount']=="" && $elem2['ToAmount']!="") return 1;
	if ($elem1['ToAmount']!="" && $elem2['ToAmount']=="") return -1;


	if( ($elem1['ToAmount']>$elem2['ToAmount'] && $elem2['ToAmount']!=-1) \|\| ($elem1['ToAmount'] == -1 && $elem2['ToAmount'] != -1 ))
	{
	return 1;
	}
	elseif ( ($elem1['ToAmount']<$elem2['ToAmount']) \|\| ($elem2['ToAmount'] == -1 && $elem1['ToAmount'] != -1 ))
	{
	return -1;
	}
	else
	{
	return 0;
	}
	}

	function pr_bracket_id_sort($first_id, $second_id)
	{
	$first_abs = abs($first_id);
	$second_abs = abs($second_id);
	$first_sign = ($first_id == 0) ? 0 : $first_id / $first_abs;
	$second_sign = ($second_id == 0) ? 0 : $second_id / $second_abs;
	if($first_sign != $second_sign)
	{
	if($first_id > $second_id) {
	$bigger =& $first_abs;
	$smaller =& $second_abs;
	}
	else {
	$bigger =& $second_abs;
	$smaller =& $first_abs;
	}
	$smaller = $bigger + $smaller;
	}

	if($first_abs > $second_abs) {
	return 1;
	}
	elseif ($first_abs < $second_abs)
	{
	return -1;
	}
	else
	{
	return 0;
	}
	}

	function inp_htmlize($var, $strip = 0)
	{
	if( is_array($var) )
	{
	foreach($var as $k => $v) $var[$k] = inp_htmlize($v, $strip);
	}
	else
	{
	$var = htmlspecialchars($strip ? stripslashes($var) : $var);
	}
	return $var;
	}

	/**
	* Sets in-portal cookies, that will not harm K4 to breath free :)
	*
	* @param string $name
	* @param mixed $value
	* @param int $expire
	* @author Alex
	*/
	function set_cookie($name, $value, $expire = 0, $cookie_path = null)
	{
	if (!isset($cookie_path))
	{
	$cookie_path = IsAdmin() ? rtrim(BASE_PATH, '/').'/admin' : BASE_PATH;
	}
	setcookie($name, $value, $expire, $cookie_path, $_SERVER['HTTP_HOST']);
	}

	/**
	* If we are on login required template, but we are not logged in, then logout user
	*
	* @return bool
	*/
	function require_login($condition = null, $redirect_params = 'logout=1', $pass_env = false)
	{
	if( !isset($condition) ) $condition = !admin_login();
	if(!$condition) return false;

	global $objSession, $adminURL;
	if( !headers_sent() ) set_cookie(SESSION_COOKIE_NAME, ' ', adodb_mktime() - 3600);
	$objSession->Logout();
	if($pass_env) $redirect_params = 'env='.BuildEnv().'&'.$redirect_params;
	header('Location: '.$adminURL.'/index.php?'.$redirect_params);
	exit;
	}

	if( !function_exists('safeDefine') )
	{
	/**
	* Define constant if it was not already defined before
	*
	* @param string $const_name
	* @param string $const_value
	* @access public
	*/
	function safeDefine($const_name, $const_value)
	{
	if(!defined($const_name)) define($const_name,$const_value);
	}
	}

	/**
	* Builds up K4 url from data supplied by in-portal
	*
	* @param string $t template
	* @param Array $params
	* @param string $index_file
	* @return string
	*/
	function HREF_Wrapper($t = '', $params = null, $index_file = null)
	{
	$url_params = BuildEnv_NEW();
	if( isset($params) ) $url_params = array_merge_recursive2($url_params, $params);
	if(!$t)
	{
	$t = $url_params['t'];
	unset($url_params['t']);
	}
	$app =& kApplication::Instance();
	return $app->HREF($t, '', $url_params, $index_file);
	}

	/**
	* Set url params based on tag params & mapping hash passed
	*
	* @param Array $url_params - url params before change
	* @param Array $tag_attribs - tag attributes
	* @param Array $params_map key - tag_param, value - url_param
	*/
	function MapTagParams(&$url_params, $tag_attribs, $params_map)
	{
	foreach ($params_map as $tag_param => $url_param)
	{
	if( getArrayValue($tag_attribs, $tag_param) ) $url_params[$url_param] = $tag_attribs[$tag_param];
	}
	}

	function ExtractParams($params_str, $separator = '&')
	{
	if(!$params_str) return Array();

	$ret = Array();
	$parts = explode($separator, trim($params_str, $separator) );
	foreach ($parts as $part)
	{
	list($var_name, $var_value) = explode('=', $part);
	$ret[$var_name] = $var_value;
	}
	return $ret;
	}

	if( !function_exists('constOn') )
	{
	/**
	* Checks if constant is defined and has positive value
	*
	* @param string $const_name
	* @return bool
	*/
	function constOn($const_name)
	{
	return defined($const_name) && constant($const_name);
	}
	}

	function &recallObject($var_name, $class_name)
	{
	if (!isset($GLOBALS[$var_name]) \|\| !is_object($GLOBALS[$var_name]))
	{
	$GLOBALS[$var_name] = new $class_name();
	}
	return $GLOBALS[$var_name];
	}

	?>

	Property changes on: trunk/globals.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.90
	\ No newline at end of property
	+1.91
	\ No newline at end of property

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options