in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Feb 2, 6:41 AM

in-portal
View Options

	Index: trunk/kernel/include/itemdb.php
	===================================================================
	--- trunk/kernel/include/itemdb.php (revision 835)
	+++ trunk/kernel/include/itemdb.php (revision 836)
	@@ -1,579 +1,578 @@
	<?php

	define('FT_OPTION', 1); // option formatter

	class clsItemDB
	{
	var $Formatters = Array(); // by Alex
	var $m_dirtyFieldsMap = array();
	var $Data = array();
	var $adodbConnection;
	var $tablename;
	var $BasePermission;
	var $id_field;
	var $NoResourceId;
	var $debuglevel;

	var $SelectSQL = 'SELECT * FROM %s WHERE %s';

	function clsItemDB()
	{
	$this->adodbConnection = &GetADODBConnection();
	$this->tablename="";
	$this->NoResourceId=0;
	$this->debuglevel=0;
	}

	// ============================================================================================
	function GetFormatter($field)
	{
	return $this->HasFormatter($field) ? $this->Formatters[$field] : false;
	}

	function SetFormatter($field, $type, $params)
	{
	// by Alex
	// all params after 2nd are formmater type specific
	$this->Formatters[$field]['type'] = $type;
	switch($type)
	{
	case FT_OPTION:
	$this->Formatters[$field]['options'] = $params;
	break;
	}
	}
	/*
	function FormatFields()
	{
	// format item in list data before printing

	foreach($this->Formatters as $field => $formatter)
	$this->Data[$field] = $this->FormatField($field);
	}
	*/
	function FormatField($field)
	{
	// formats single field if it has formatter
	if( $this->HasFormatter($field) )
	{
	$fmt = $this->Formatters[$field];
	switch($fmt['type'])
	{
	case FT_OPTION:
	return $fmt['options'][ $this->Data[$field] ];
	break;
	}
	}
	else
	return $this->Get($field);
	}

	function HasFormatter($field)
	{
	// checks if formatter is set for field
	return isset($this->Formatters[$field]) ? 1 : 0;
	}
	// ============================================================================================

	function UnsetIdField()
	{
	$f = $this->IdField();
	unset($this->Data[$f]);
	unset($this->m_dirtyFieldsMap[$f]);
	}

	function UnsetField($field)
	{
	unset($this->Data[$field]);
	unset($this->m_dirtyFieldsMap[$field]);
	}

	function IdField()
	{
	if(!strlen($this->id_field))
	{
	return $this->tablename."Id";
	}
	else
	return $this->id_field;
	}

	function UniqueId()
	{
	return $this->Get($this->IdField());
	}

	function SetUniqueId($value)
	{
	$var = $this->IdField();
	$this->Set($var, $value);
	}

	function SetModified($UserId=NULL)
	{
	global $objSession;

	$keys = array_keys($this->Data);
	if(in_array("Modified",$keys))
	{
	$this->Set("Modified",adodb_date("U"));
	}
	if(in_array("ModifiedById",$keys))
	{
	if(!$UserId)
	$UserId = $objSession->Get("PortalUserId");
	$this->Set("ModifiedById",$UserId);
	}
	}

	function PrintVars()
	{
	echo '<pre>'.print_r($this->Data, true).'</pre>';
	}

	// =================================================================
	function GetFormatted($name)
	{
	// get formatted field value
	return $this->FormatField($name);
	}

	function Get($name)
	{
	// get un-formatted field value
	//if( !isset($this->Data[$name]) ) print_pre( debug_backtrace() );
	return $this->HasField($name) ? $this->Data[$name] : '';
	}
	// =================================================================

	function HasField($name)
	{
	// checks if field exists in item
	return isset($this->Data[$name]) ? 1 : 0;
	}

	function Set($name, $value)
	{
	//echo "Setting Field <b>$name</b>: = [$value]<br>";
	if( is_array($name) )
	{
	for ($i=0; $i < sizeof($name); $i++)
	{
	$var = "m_" . $name[$i];
	if( !$this->HasField($name[$i]) \|\| ($this->Data[$name[$i]] != $value[$i]))
	{
	+ $this->DetectChanges($name[$i], $value[$i]);
	$this->Data[$name[$i]] = $value[$i];
	- $this->m_dirtyFieldsMap[$name[$i]] = $value[$i];
	+ $this->m_dirtyFieldsMap[$name[$i]] = $value[$i];
	}
	}
	}
	else
	{
	$var = "m_" . $name;
	if( !$this->HasField($name) \|\| $this->Data[$name] != $value )
	{
	+ $this->DetectChanges($name, $value);
	$this->Data[$name] = $value;
	$this->m_dirtyFieldsMap[$name] = $value;
	}
	}
	}

	function Dirty($list=NULL)
	{
	if($list==NULL)
	{
	foreach($this->Data as $field => $value)
	{
	$this->m_dirtyFieldsMap[$field] = $value;
	}
	}
	else
	{
	foreach($list as $field)
	{
	$this->m_dirtyFieldsMap[$field] = $this->Data[$field];
	}
	}
	}

	function Clean($list=NULL)
	{
	if($list == NULL)
	{
	unset($this->m_dirtyFieldsMap);
	$this->m_dirtyFieldsMap=array();
	}
	else
	{
	foreach($list as $value)
	{
	$varname = "m_" . $value;
	unset($this->m_dirtyFieldsMap[$value]);
	}
	}
	}

	function SetDebugLevel($value)
	{
	$this->debuglevel = $value;
	}

	function SetFromArray($data, $dirty = false)
	{
	if(is_array($data))
	{
	$this->Data = $data;
	if($dirty) $this->m_dirtyFieldsMap = $data;
	}
	}

	function GetData()
	{
	return $this->Data;
	}

	function SetData($data, $dirty = false)
	{
	$this->SetFromArray($data, $dirty);
	}

	function Delete()
	{
	global $Errors;

	if($this->Get($this->IdField())==0)
	{
	$Errors->AddError("error.AppError",NULL,'Internal error: Delete requires set id',"",get_class($this),"Delete");
	return false;
	}

	$sql = sprintf('DELETE FROM %s WHERE %s = %s', $this->tablename, $this->IdField(),
	$this->UniqueId());
	if($this->debuglevel>0)
	echo $sql."<br>";
	if ($this->adodbConnection->Execute($sql) === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Delete");
	return false;
	}
	return true;
	}

	function Update($UpdatedBy=NULL)
	{
	global $Errors, $objSession;

	if(count($this->m_dirtyFieldsMap) == 0)
	return true;

	$this->SetModified($UpdatedBy);
	$sql = "UPDATE ".$this->tablename ." SET ";
	$first = 1;

	- $this->DetectChanges();
	-
	foreach ($this->m_dirtyFieldsMap as $key => $value)
	{
	if(!is_numeric($key) && $key != $this->IdField() && $key!='ResourceId')
	{
	if($first)
	{
	if(isset($GLOBALS['_CopyFromEditTable']))
	$sql = sprintf("%s %s=%s",$sql,$key,$this->adodbConnection->qstr(($value)));
	else
	$sql = sprintf("%s %s=%s",$sql,$key,$this->adodbConnection->qstr(stripslashes($value)));
	$first = 0;
	}
	else
	{
	if(isset($GLOBALS['_CopyFromEditTable']))
	$sql = sprintf("%s, %s=%s",$sql,$key,$this->adodbConnection->qstr(($value)));
	else
	$sql = sprintf("%s, %s=%s",$sql,$key,$this->adodbConnection->qstr(stripslashes($value)));
	}
	}
	}

	$sql = sprintf("%s WHERE %s = '%s'",$sql, $this->IdField(), $this->UniqueId());

	if($this->debuglevel>0)
	echo $sql."<br>";
	if ($this->adodbConnection->Execute($sql) === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Update");
	return false;
	}

	/* if ($this->adodbConnection->Affected_Rows() > 0) {
	$objSession->SetVariable("HasChanges", 1);
	}*/

	return true;
	}

	function ReplaceID($new_id)
	{
	// replace item's id, because Update method
	// is too dummy to do this autommatically
	// USED in temporary table editing stuff
	$db =& $this->adodbConnection;
	$sql = "UPDATE %1\$s SET `%2\$s` = %3\$s WHERE `%2\$s` = %4\$s";
	$sql = sprintf($sql, $this->tablename, $this->IdField(), $new_id, (int)$this->UniqueId() );
	if($this->debuglevel > 0) echo $sql.'<br>';
	$db->Execute($sql);
	}

	function CreateSQL()
	{
	global $Errors;

	$sql = "INSERT IGNORE INTO ".$this->tablename." (";
	$first = 1;
	foreach ($this->Data as $key => $value)
	{
	if($first)
	{
	$sql = sprintf("%s %s",$sql,$key);
	$first = 0;
	}
	else
	{
	$sql = sprintf("%s, %s",$sql,$key);
	}
	}
	$sql = sprintf('%s ) VALUES (',$sql);
	$first = 1;
	foreach ($this->Data as $key => $value)
	{
	if( is_array($value) )
	{
	echo "Invalid Value: ";
	print_pre($value);
	echo "Tracing:<br>";
	trace();
	die();
	}
	if($first)
	{
	if(isset($GLOBALS['_CopyFromEditTable']))
	$sql = sprintf("%s %s",$sql,$this->adodbConnection->qstr(($value)));
	else
	$sql = sprintf("%s %s",$sql,$this->adodbConnection->qstr(stripslashes($value)));
	$first = 0;
	}
	else
	{
	if(isset($GLOBALS['_CopyFromEditTable']))
	$sql = sprintf("%s, %s",$sql,$this->adodbConnection->qstr(($value)));
	else
	$sql = sprintf("%s, %s",$sql,$this->adodbConnection->qstr(stripslashes($value)));
	}
	}
	$sql = sprintf('%s)',$sql);

	return $sql;
	}

	- function DetectChanges()
	+ function DetectChanges($name, $value)
	{
	global $objSession;
	-//print_pre($this->m_dirtyFieldsMap);
	- foreach ($this->m_dirtyFieldsMap as $key => $value) {
	- //if ($this->Data[$key] != $this->m_dirtyFieldsMap[$key]) {
	- if ((!strstr($key, 'Modif') && $key != 'CreatedOn')) {
	- $objSession->SetVariable("HasChanges", 1);
	- }
	- //}
	- }
	+ //print_pre($_POST);
	+ //echo "$name: $value<br>";
	+ if ($this->Data[$name] != $value && !strstr($name, 'Modif') && !strstr($name, 'Created')) {
	+ //echo "$name Modified ".$this->Data[$name]." $value<br>";
	+ if (!strstr($name, 'Hot') && !strstr($name, 'Pop')) {
	+ $objSession->SetVariable("HasChanges", 1);
	+ }
	+ }
	}

	function Create()
	{
	global $Errors, $objSession;

	if($this->debuglevel) echo "Creating Item: ".get_class($this)."<br>";
	if($this->NoResourceId!=1 && (int)$this->Get("ResourceId")==0)
	{
	$this->Set("ResourceId", GetNextResourceId());
	}
	$sql = $this->CreateSql();

	if($this->debuglevel>0)
	echo $sql."<br>\n";

	if ($this->adodbConnection->Execute($sql) === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Create");
	return false;
	}

	$this->SetUniqueId($this->adodbConnection->Insert_ID());

	- $this->DetectChanges();
	/*if ($this->adodbConnection->Affected_Rows() > 0) {
	$objSession->SetVariable("HasChanges", 1);
	} */

	return true;
	}

	function Increment($field)
	{
	global $Errors;

	$sql = "Update ".$this->tablename." set $field=$field+1 where ".$this->IdField()."=" . $this->UniqueId();
	if($this->debuglevel>0)
	echo $sql."<br>";
	$result = $this->adodbConnection->Execute($sql);
	if ($result === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Increment");
	return false;
	}
	$this->Set($field,$this->Get($field)+1);
	}

	function Decrement($field)
	{
	global $Errors;

	$sql = "Update ".$this->tablename." set $field=$field-1 where ".$this->IdField()."=" . $this->UniqueId();
	if($this->debuglevel>0)
	echo $sql;
	$result = $this->adodbConnection->Execute($sql);
	if ($result === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Decrement");
	return false;
	}
	$this->Set($field,$this->Get($field)-1);
	}

	function GetFieldList($UseLoadedData=FALSE)
	{
	if(count($this->Data) && $UseLoadedData==TRUE)
	{
	$res = array_keys($this->Data);
	}
	else
	{
	$res = $this->adodbConnection->MetaColumnNames($this->tablename);
	}
	return $res;
	}

	function UsingTempTable()
	{
	global $objSession;

	$temp = $objSession->GetEditTable($this->tablename);
	$p = GetTablePrefix()."ses";
	$t = substr($temp,0,strlen($p));
	$ThisTable = substr($this->tablename,0,strlen($p));
	if($t==$ThisTable)
	{
	return TRUE;
	}
	else
	return FALSE;
	}

	function LoadFromDatabase($Id, $IdField = null) // custom IdField by Alex
	{
	global $objSession,$Errors;

	if(!isset($Id))
	{
	$Errors->AddError("error.AppError",NULL,'Internal error: LoadFromDatabase id',"",get_class($this),"LoadFromDatabase");
	return false;
	}

	// --------- multiple ids allowed: begin -----------------
	$id_field = isset($IdField) ? $IdField : $this->IdField();
	if( !is_array($id_field) ) $id_field = Array($id_field);
	if( !is_array($Id) ) $Id = Array($Id);

	$i = 0; $id_count = count($id_field);
	$conditions = Array();
	while($i < $id_count)
	{
	$conditions[] = "(`".$id_field[$i]."` = '".$Id[$i]."')";
	$i++;
	}
	$sql = sprintf($this->SelectSQL, $this->tablename, implode(' AND ', $conditions) );
	// --------- multiple ids allowed: end --------------------
	if($this->debuglevel) echo "Load SQL: $sql<br>";
	$result = $this->adodbConnection->Execute($sql);
	if ($result === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"LoadFromDatabase");
	return false;
	}
	$data = $result->fields;
	if($this->debuglevel) print_pre($data);
	if(is_array($data))
	$this->SetFromArray($data);
	$this->Clean();
	return TRUE;
	}

	function FieldExists($field)
	{
	$res = array_key_exists($field,$this->Data);
	return $res;
	}

	function ValueExists($Field,$Value)
	{
	$sql = "SELECT $Field FROM ".$this->tablename." WHERE $Field='$Value'";
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	return TRUE;
	}
	else
	return FALSE;
	}

	function FieldMax($Field)
	{
	$sql = "SELECT Max($Field) as m FROM ".$this->tablename;
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	$ret = $rs->fields["m"];
	}
	else
	$ret = 0;
	}

	function FieldMin($Field)
	{
	$sql = "SELECT Min($Field) as m FROM ".$this->tablename;
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	$ret = $rs->fields["m"];
	}
	else
	$ret = 0;
	}

	function TableExists($table = null)
	{
	// checks if table specified in item exists in db
	$db =& $this->adodbConnection;
	$sql = "SHOW TABLES LIKE '%s'";
	if($table == null) $table = $this->tablename;
	$rs = $db->Execute( sprintf($sql, $table) );

	if( $rs->RecordCount() == 1 ) // table exists in normal case
	return 1;
	else // check if table exists in lowercase
	$rs = $db->Execute( sprintf($sql, strtolower($table) ) );

	return ($rs->RecordCount() == 1) ? 1 : 0;
	}

	}
	?>

	Property changes on: trunk/kernel/include/itemdb.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.13
	\ No newline at end of property
	+1.14
	\ No newline at end of property
	Index: trunk/kernel/searchaction.php
	===================================================================
	--- trunk/kernel/searchaction.php (revision 835)
	+++ trunk/kernel/searchaction.php (revision 836)
	@@ -1,212 +1,249 @@
	<?php
	/* action handlers for listview searches */

	//echo "in search action (global)<br>";
	//print_pre($_REQUEST);

	switch($Action)
	{
	case "m_SearchWord": /* browse and modify*/
	$searchlist = trim($objSession->GetVariable("SearchWord"));
	if($_POST["NewSearch"]==1)
	$searchlist = "";
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["SearchWord"];
	$objSession->SetVariable("SearchWord",$searchlist);
	$objSession->SetVariable("SearchType",$_POST["SearchType"]);
	//$objSession->SetVariable("SearchScope",(int)$_POST["SearchScope"]);
	$objSession->SetVariable("SearchScope", 2);

	break;
	case "m_ClearSearch": /* browse and modify*/
	$objSession->SetVariable("SearchWord","");
	break;

	case "m_user_search": /* user list */
	$searchlist = trim($objSession->GetVariable("UserSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("UserSearchWord",$searchlist);
	$objSession->SetVariable("Page_Userlist",1);
	break;
	case "m_user_search_reset": /user list /
	$objSession->SetVariable("UserSearchWord","");
	$objSession->SetVariable("Page_Userlist",1);
	break;
	+
	+ case "m_usergroup_search": /* user list */
	+ $searchlist = trim($objSession->GetVariable("UserGroupSearchWord"));
	+ if(strlen($searchlist)>0)
	+ $searchlist = ",";
	+ $searchlist = $_POST["list_search"];
	+ $objSession->SetVariable("UserGroupSearchWord",$searchlist);
	+ $objSession->SetVariable("Page_Userlist",1);
	+ break;
	+ case "m_usergroup_search_reset": /user list /
	+ $objSession->SetVariable("UserGroupSearchWord","");
	+ $objSession->SetVariable("Page_Userlist",1);
	+ break;

	case "m_summary_search": /* summary list */
	$searchlist = trim($objSession->GetVariable("UserSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("SummarySearchWord",$searchlist);
	$objSession->SetVariable("Page_Summary",1);
	break;

	case "m_summary_search_reset": /* summary list */
	$objSession->SetVariable("SummarySearchWord","");
	$objSession->SetVariable("Page_Summary",1);
	break;

	case "m_userselect_search": /* popup user list */
	$searchlist = trim($objSession->GetVariable("UserSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("UserSelectSearchWord",$searchlist);
	$objSession->SetVariable("Page_UserSelect",1);
	break;
	case "m_userselect_search_reset": /* popup user list */
	$objSession->SetVariable("UserSelectSearchWord","");
	$objSession->SetVariable("Page_UserSelect",1);
	break;


	case "m_group_search": /* group list */
	$searchlist = trim($objSession->GetVariable("GroupSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("GroupSearchWord",$searchlist);
	$objSession->SetVariable("Page_Grouplist",1);
	break;
	case "m_group_search_reset": /group list /
	$objSession->SetVariable("GroupSearchWord","");
	break;

	case "m_rel_search": /* category relations list */
	$searchlist = trim($objSession->GetVariable("CatRelSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("CatRelSearchWord",$searchlist);
	$objSession->SetVariable("Page_Relations",1);
	break;
	case "m_rel_search_reset": /* category relations list */
	$objSession->SetVariable("CatRelSearchWord","");
	break;

	case "m_group_search": /* group list */
	$searchlist = trim($objSession->GetVariable("GroupSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("GroupSearchWord",$searchlist);
	$objSession->SetVariable("Page_Grouplist",1);
	break;
	case "m_group_search_reset": /group list /
	$objSession->SetVariable("GroupSearchWord","");
	break;

	case "m_phrase_search": /* category relations list */
	$searchlist = trim($objSession->GetVariable("PhraseSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("PhraseSearchWord",$searchlist);
	$objSession->SetVariable("Page_Phrase",1);
	break;
	case "m_phrase_search_reset": /* category relations list */
	$objSession->SetVariable("PhraseSearchWord","");
	$objSession->SetVariable("Page_Phrase",1);
	break;

	case "m_template_file_search": /* theme template file list */
	$searchlist = trim($objSession->GetVariable("TemplateSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("TemplateSearchWord",$searchlist);
	$objSession->SetVariable("Page_Template",1);
	break;
	case "m_template_file_search_reset": /* theme template file list */
	$objSession->SetVariable("TemplateSearchWord","");
	$objSession->SetVariable("Page_Template",1);
	break;
	case "m_lang_search": /* language package list */
	$searchlist = trim($objSession->GetVariable("LangSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("LangSearchWord",$searchlist);
	$objSession->SetVariable("Page_LV_Lang",1);
	break;
	case "m_lang_search_reset": /* language package list */
	$objSession->SetVariable("LangSearchWord","");
	$objSession->SetVariable("Page_LV_Lang",1);
	break;
	case "m_emailevent_search": /* Email event list */
	$searchlist = trim($objSession->GetVariable("EmailEventSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("EmailEventSearchWord",$searchlist);
	$objSession->SetVariable("Page_Email",1);
	break;
	case "m_emailevent_search_reset":
	$objSession->SetVariable("EmailEventSearchWord","");
	$objSession->SetVariable("Page_Email",1);
	break;
	case "m_langemailevent_search": /* Email event list */
	$searchlist = trim($objSession->GetVariable("LangEmailEventSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("LangEmailEventSearchWord",$searchlist);
	$objSession->SetVariable("Page_LangEmail",1);
	break;
	case "m_langemailevent_search_reset":
	$objSession->SetVariable("LangEmailEventSearchWord","");
	$objSession->SetVariable("Page_LangEmail",1);
	break;
	case "m_rule_search": /* Email event list */
	$searchlist = trim($objSession->GetVariable("RuleSearchWord"));
	if(strlen($searchlist)>0)
	$searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("RuleSearchWord",$searchlist);
	$objSession->SetVariable("Page_BanRules",1);
	break;
	case "m_rule_search_reset":
	$objSession->SetVariable("RuleSearchWord","");
	$objSession->SetVariable("Page_BanRules",1);
	break;

	// Theme List Search
	case 'm_theme_search':
	$searchlist = trim( $objSession->GetVariable("ThemeSearchWord") );
	if(strlen($searchlist) > 0) $searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("ThemeSearchWord",$searchlist);
	$objSession->SetVariable("Page_LV_Themes",1);
	break;

	case 'm_theme_search_reset':
	$objSession->SetVariable("ThemeSearchWord","");
	$objSession->SetVariable("Page_LV_Themes",1);
	break;

	// Advanced View Search Actions
	case 'm_adv_view_search':
	SaveAdvView_SearchWord('m');
	break;

	case 'm_adv_view_search_reset':
	ResetAdvView_SearchWord('m');
	break;

	case 'm_emaillog_search':
	$searchlist = trim( $objSession->GetVariable("EmailsLSearchWord") );
	if(strlen($searchlist) > 0) $searchlist = ",";
	$searchlist = $_POST["list_search"];
	$objSession->SetVariable("EmailsLSearchWord",$searchlist);
	$objSession->SetVariable("Page_EmailsL",1);
	break;
	case 'm_emaillog_search_reset':
	$objSession->SetVariable("EmailsLSearchWord","");
	$objSession->SetVariable("Page_EmailsL",1);
	break;
	+
	+ case 'm_searchword_search':
	+ $searchlist = trim( $objSession->GetVariable("KeywordSearchWord") );
	+ if(strlen($searchlist) > 0) $searchlist = ",";
	+ $searchlist = $_POST["list_search"];
	+ $objSession->SetVariable("KeywordSearchWord",$searchlist);
	+ $objSession->SetVariable("Page_SearchLog",1);
	+ break;
	+ case 'm_searchword_search_reset':
	+ $objSession->SetVariable("KeywordSearchWord","");
	+ $objSession->SetVariable("Page_SearchLog",1);
	+ break;
	+
	+ case 'm_session_search':
	+ $searchlist = trim( $objSession->GetVariable("SessionSearchWord") );
	+ if(strlen($searchlist) > 0) $searchlist = ",";
	+ $searchlist = $_POST["list_search"];
	+ $objSession->SetVariable("SessionSearchWord",$searchlist);
	+ $objSession->SetVariable("Page_Sessionlist",1);
	+ break;
	+ case 'm_session_search_reset':
	+ $objSession->SetVariable("SessionSearchWord","");
	+ $objSession->SetVariable("Page_Sessionlist",1);
	+ break;
	}
	?>

	Property changes on: trunk/kernel/searchaction.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.6
	\ No newline at end of property
	+1.7
	\ No newline at end of property
	Index: trunk/kernel/frontaction.php
	===================================================================
	--- trunk/kernel/frontaction.php (revision 835)
	+++ trunk/kernel/frontaction.php (revision 836)
	@@ -1,885 +1,947 @@
	<?php

	if( defined('DEBUG_ACTIONS') && (DEBUG_ACTIONS & FRONT_KERNEL_ACTIONS) == FRONT_KERNEL_ACTIONS )
	{
	if($Action) $debugger->appendHTML('Front Action: <b>'.$Action.'</b>');
	}

	if( defined('DEBUG_ACTIONS') && (DEBUG_ACTIONS & FRONT_SHOW_REQUEST) == FRONT_SHOW_REQUEST )
	{
	// don't show debug output in tree & header of admin & while logging in
	$script = basename($_SERVER['PHP_SELF']);
	$debugger->appendHTML('ScriptName: <b>'.$script.'</b> (<b>'.dirname($_SERVER['PHP_SELF']).'</b>)');
	$requestTable = '<table border="0" cellspacing="0" cellpadding="4" class="flat_table">
	<thead style="font-weight: bold;"><td>Src</td><td>Name</td><td>Value</td></thead>';

	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));
	}
	$src = isset($_GET[$key]) ? 'GE' : (isset($_POST[$key]) ? 'PO' : (isset($_COOKIE[$key]) ? 'CO' : '?') );
	$requestTable .= '<tr><td>'.$src.'</td><td>'.$key.'</td><td>'.$value.'</td></tr>';
	}
	$requestTable .= '</table>';
	$debugger->appendHTML($requestTable);
	unset($script, $requestTable);
	// echo "SID: ".$objSession->GetSessionKey().'<br>';
	}

	switch($Action)
	{
	case "m_login":
	// if($objSession->ValidSession()) $objSession->Logout();
	//echo $objSession->GetSessionKey()."<br>\n";
	if ($objConfig->Get("CookieSessions") == 1 && $_COOKIE["CookiesTest"] != "1") {
	$FormError["login"]["login_user"] = language("lu_cookies_error");
	}
	else
	{
	$MissingCount = SetMissingDataErrors("login");
	if($MissingCount==2)
	{
	$FormError["login"]["login_user"]= language("lu_ferror_loginboth");
	unset($FormError["login"]["login_password"]);
	}

	if($MissingCount==0)
	{
	if($_POST["login_user"]=="root")
	{
	$FormError["login"]["login_user"]= language("lu_access_denied");
	}
	else
	{
	$LoginCheck = $objSession->Login( $_POST["login_user"], md5($_POST["login_password"]) );
	if($LoginCheck === true)
	{
	if( !headers_sent() && GetVar('usercookie') == 1 )
	{
	$c = $_POST["login_user"]."\|";
	$pw = $_POST["login_password"];
	if(strlen($pw) < 31) $pw = md5($pw);
	$c .= $pw;
	setcookie("login",$c,time()+2592000);
	}

	// set new destination template if passed
	$dest = GetVar('dest', true);
	if(!$dest) $dest = GetVar('DestTemplate', true);
	if($dest) $var_list['t'] = $dest;
	}
	else
	{
	switch($LoginCheck)
	{
	case -1: // user or/and pass wrong
	$FormError["login"]["login_password"] = language("lu_incorrect_login");
	break;

	case -2: // user ok, but has no permission
	$FormError["login"]["login_password"] = language("la_text_nopermissions");
	break;
	}
	}
	}
	}
	}
	break;

	case "m_forgotpw":
	$MissingCount = SetMissingDataErrors("forgotpw");
	if($MissingCount==0)
	{
	$username = $_POST["username"];
	$email = $_POST["email"];
	$found = FALSE;
	if(strlen($username))
	{
	$u = $objUsers->GetItemByField("Login",$username);
	if(is_object($u))
	$found = ($u->Get("Login")==$username && $u->Get("Status")==1) && strlen($u->Get("Password"));
	}
	else if(strlen($email))
	{
	$u = $objUsers->GetItemByField("Email",$email);
	if(is_object($u))
	$found = ($u->Get("Email")==$email && $u->Get("Status")==1) && strlen($u->Get("Password"));
	}
	if($found)
	{
	$newpw = makepassword();
	$objSession->Set('password', $newpw);
	$u->Set("Password",$newpw);
	$u->Update();
	$u->SendUserEventMail("USER.PSWD",$u->Get("PortalUserId"));
	$u->SendAdminEventMail("USER.PSWD");
	$u->Set("Password",md5($newpw));
	$u->Update();
	$u->Clean();
	}
	else
	{
	if(!strlen($username) && !strlen($email))
	{
	$FormError["forgotpw"]["username"] = language("lu_ferror_forgotpw_nodata");
	$MissingCount++;
	}
	else
	{
	if(strlen($username))
	$FormError["forgotpw"]["username"] = language("lu_ferror_unknown_username");
	if(strlen($email))
	$FormError["forgotpw"]["email"] = language("lu_ferror_unknown_email");
	$MissingCount++;
	}
	if(strlen($_GET["error"]))
	$var_list["t"] = $_GET["error"];
	}
	}
	else
	if(strlen($_GET["error"]))
	$var_list["t"] = $_GET["error"];
	break;
	case "m_subscribe_confirm":
	$t = "";
	$SubscribeAddress = $_POST["subscribe_email"];
	if(!ValidEmail($SubscribeAddress)&& strlen($SubscribeAddress))
	{
	$t = $_GET["Error"];
	$SubscribeError = "lu_invalid_emailaddress";
	}
	else
	{
	if((int)$objConfig->Get("User_SubscriberGroup")>0)
	{
	$g = $objGroups->GetItem($objConfig->Get("User_SubscriberGroup"));
	if(is_object($g))
	{
	$email = $_POST["subscribe_email"];
	if(strlen($email)>0)
	{
	$u = $objUsers->GetItemByField("Email",$email);

	if(is_object($u))
	{
	if($u->CheckBanned())
	{
	$t = $_GET["Error"];
	$SubscribeError ="lu_subscribe_banned";
	}
	else
	{
	if($u->IsInGroup($g->Get("GroupId")))
	{
	$t = $_GET["Unsubscribe"];
	}
	else
	$t = $_GET["Subscribe"];
	}
	}
	else
	$t = $_GET["Subscribe"];
	}
	else
	{
	$t = $_GET["Error"];
	$SubscribeError ="lu_subscribe_no_address";
	}
	}
	else
	{
	$t = $_GET["Error"];
	$SubscribeError ="lu_subscribe_unknown_error";
	}
	}
	}
	if(strlen($t))
	{
	$var_list["t"] = $t;
	$var_list_update["t"] = $t;
	}
	break;
	case "m_subscribe":
	//phpinfo(INFO_VARIABLES);
	if($_POST["buttons"][0]==language("lu_button_yes"))
	{
	$SubscribeAddress = $_POST["subscribe_email"];
	if(strlen($SubscribeAddress)>0)
	{
	if(ValidEmail($SubscribeAddress))
	{
	$GroupId = (int)$objConfig->Get("User_SubscriberGroup");
	if ($GroupId)
	{
	$g = $objGroups->GetItem($GroupId);
	$u = $objUsers->GetItemByField("Email",$SubscribeAddress);
	if(is_object($u))
	{
	if(strtolower($u->Get("Email"))==strtolower($SubscribeAddress))
	{
	$bExists = TRUE;
	}
	else
	$bExists = FALSE;
	}
	if($bExists)
	{
	$g->AddUser($u->Get("PortalUserId"));
	}
	else
	{
	$u = new clsPortalUser(NULL);
	$u->Set("Email",$SubscribeAddress);
	$u->Set("ip",$_SERVER['REMOTE_ADDR']);
	$u->Set("CreatedOn",date("U"));
	$u->Set("Status",1);
	if(!$u->CheckBanned())
	{
	$u->Create();
	$g->AddUser($u->Get("PortalUserId"),1);
	}
	else
	$SubscribeResult = "lu_subscribe_banned";
	}
	$SubscribeResult = "lu_subscribe_success";
	$u->SendUserEventMail("USER.SUBSCRIBE",$u->Get("PortalUserId"));
	$u->SendAdminEventMail("USER.SUBSCRIBE");
	if(strlen($_GET["Subscribe"])>0)
	$var_list["t"] = $_GET["Subscribe"];
	}
	}
	else
	{
	$SubscribeResult = "lu_invalid_emailaddress";
	}
	}
	else
	$SubscribeResult = "lu_subscribe_missing_address";
	}

	if(!strlen($SubscribeResult))
	$SubscribeResult = "lu_subscribe_success";
	break;
	case "m_unsubscribe":

	if($_POST["buttons"][0]==language("lu_button_yes"))
	{
	$MissingCount = SetMissingDataErrors("m_unsubscribe");

	if($MissingCount==0)
	{
	$email = $_POST["subscribe_email"];
	$u = $objUsers->GetItemByField("Email",$email);
	if(is_object($u))
	{
	if(strtolower($u->Get("Email"))==strtolower($email))
	{
	$GroupId = (int)$objConfig->Get("User_SubscriberGroup");
	if($u->PrimaryGroup()==$GroupId)
	{
	$u_gorup_list = $u->GetGroupList();

	if (count($u_gorup_list) > 1) {
	$u->RemoveFromGroup($GroupId);
	}
	else {
	$u->RemoveFromAllGroups();
	$u->Delete();
	}
	}
	else
	{
	$u->RemoveFromGroup($GroupId);
	}
	}
	}
	if(strlen($_GET["Subscribe"])>0)
	$var_list["t"] = $_GET["Subscribe"];
	}
	}

	break;
	case "m_logout":
	// $objSession->Logout();
	//unset($objSession);
	//$objSession = new clsUserSession();
	// $var_list_update["t"] = "index";
	// setcookie("login","",time()-3600);
	break;
	case "m_register":
	$_POST=inp_escape($_POST);
	$MissingCount = SetMissingDataErrors("m_register");

	if(!$objConfig->Get("User_Password_Auto"))
	{
	if(($_POST["password"] != $_POST["passwordverify"]) \|\| !strlen($_POST["passwordverify"]))
	{
	$MissingCount++;
	$FormError["m_register"]["passwordverify"] = language("lu_ferror_pswd_mismatch");
	}

	if(strlen($_POST["password"])>30)
	{
	// echo "VAR: ".$_POST["password"]; die();
	$MissingCount++;
	$FormError["m_register"]["password"] = language("lu_ferror_pswd_toolong");
	}

	if (strlen($_POST['password']) < $objConfig->Get("Min_Password"))
	{
	$MissingCount++;
	$FormError["m_register"]["password"] = language("lu_ferror_pswd_tooshort");
	}
	}

	$u = $objUsers->GetItemByField("Login",$_POST["username"]);

	if(is_object($u))
	{
	if($u->Get("Login")==$_POST["username"])
	{
	$MissingCount++;
	$FormError["m_register"]["username"] = language("lu_user_exists");
	}
	}

	if (strlen($_POST['username']) < $objConfig->Get("Min_UserName"))
	{
	$MissingCount++;
	$FormError["m_register"]["username"] = language("lu_ferror_username_tooshort");
	}

	if(!$MissingCount)
	{
	$CreatedOn = adodb_date("U");
	$GroupId = $objConfig->Get("User_NewGroup");
	$Status=0;

	/* determine the status of new users */
	switch ($objConfig->Get("User_Allow_New"))
	{
	case "1":
	$Status=1;
	break;
	case "3":
	$Status=2;
	break;
	}

	/* set Destination template */
	$var_list["t"] = strlen($_GET["dest"])? $_GET["dest"] : "index";

	if($Status>0)
	{
	if($objConfig->Get("User_Password_Auto"))
	{
	$password = makepassword();
	$objSession->Set("password", $password);
	}
	else
	$password = $_POST["password"];

	$_POST["dob"] = $_POST["dob_month"]."/".$_POST["dob_day"]."/".$_POST["dob_year"];
	$dob = DateTimestamp($_POST["dob"],GetDateFormat());
	$ip = $_SERVER['REMOTE_ADDR'];

	$u = &$objUsers->Add_User($_POST["username"], md5($password), $_POST["email"], $CreatedOn, $_POST["firstname"], $_POST["lastname"], $Status, $_POST["phone"], $_POST["street"], $_POST["city"], $_POST["state"], $_POST["zip"], $_POST["country"], $dob, $ip, TRUE);

	if(!is_object($u))
	{
	$RuleId=$u;
	$r = $objBanList->GetItem($RuleId);
	$err = $r->Get("ErrorTag");

	if(strlen($err))
	{
	$FormError["m_register"][$r->Get("ItemField")] = language($err);
	$MissingCount++;
	}
	}
	else
	{
	$u->Set("Password",$password);
	$u->Clean();
	if($GroupId>0)
	{
	$g = $objGroups->GetItem($GroupId);
	$g->AddUser($u->Get("PortalUserId"),1);
	}

	$custom = $_POST["custom"];
	if(is_array($custom))
	{
	for($x=0;$x<count($custom);$x++)
	{
	$u->SetCustomField($custom[$x],$_POST[$custom[$x]]);
	}
	$u->SaveCustomFields();
	}

	if($Status==1)
	{
	if($objConfig->Get("User_Password_Auto"))
	{
	$u->SendUserEventMail("USER.VALIDATE",$u->Get("PortalUserId"));
	$u->SendAdminEventMail("USER.VALIDATE");
	}
	else
	{
	$doLoginNow = true;
	$u->SendUserEventMail("USER.ADD",$u->Get("PortalUserId"));
	$u->SendAdminEventMail("USER.ADD");
	}
	}
	else
	{
	$u->SendUserEventMail("USER.ADD.PENDING",$u->Get("PortalUserId"));
	$u->SendAdminEventMail("USER.ADD.PENDING");
	}

	if ($doLoginNow)
	$objSession->Login($_POST["username"], md5($password));

	}
	}
	}
	break;
	case "m_add_friend":
	$id = $_GET["UserId"];
	$userid = $objSession->Get("PortalUserId");
	if($id!=$userid)
	{
	$u =& $objUsers->GetItem($id);
	$u->AddFavorite($userid);
	}
	break;
	case "m_del_friend":
	$id = $_GET["UserId"];
	$userid = $objSession->Get("PortalUserId");
	$u =& $objUsers->GetItem($id);
	$u->DeleteFavorite();
	break;
	case "m_acctinfo":
	// phpinfo(INFO_VARIABLES);
	$_POST=inp_escape($_POST);
	$MissingCount = SetMissingDataErrors("m_acctinfo");
	$UserId = $_GET["UserId"];
	if($UserId != $objSession->Get("PortalUserId"))
	{
	$MissingCount++;
	$FormError["m_acctinfo"]["UserId"] = language("lu_ferror_m_profile_userid");
	}
	if(strlen($_POST["password"])>0)
	{
	if(($_POST["password"] != $_POST["passwordverify"]) \|\| !strlen($_POST["passwordverify"]))
	{
	$MissingCount++;
	$FormError["m_acctinfo"]["passwordverify"] = language("lu_ferror_pswd_mismatch");
	}

	if(strlen($_POST["password"])>30)
	{
	// echo "VAR: ".$_POST["password"]; die();
	$MissingCount++;
	$FormError["m_acctinfo"]["password"] = language("lu_ferror_pswd_toolong");
	}

	if (strlen($_POST['password']) < $objConfig->Get("Min_Password"))
	{
	$MissingCount++;
	$FormError["m_acctinfo"]["password"] = language("lu_ferror_pswd_tooshort");
	}
	}
	if(!$MissingCount)
	{
	/* save profile */
	$u =& $objUsers->GetItem($UserId);
	$status = $u->Get("Status");
	$_POST["dob"] = $_POST["dob_month"]."/".$_POST["dob_day"]."/".$_POST["dob_year"];
	$dob = DateTimestamp($_POST["dob"], GetDateFormat());
	if(strlen($_POST["password"])>0)
	{
	$password = md5($_POST["password"]);
	}
	else
	$password = "";
	$objUsers->Edit_User($UserId, $_POST["username"], $password, $_POST["email"], 0,
	$_POST["firstname"], $_POST["lastname"], $status, $_POST["phone"],
	$_POST["street"], $_POST["city"], $_POST["state"], $_POST["zip"],
	$_POST["country"], $dob);

	$ResourceId= $u->Get("ResourceId");
	$objCustomDataList->LoadResource($ResourceId);
	$objCustomFields = new clsCustomFieldList(6);
	for($i=0;$i<$objCustomFields->NumItems(); $i++)
	{
	$field = & $objCustomFields->GetItemRefByIndex($i);
	$fieldid= $field->Get("CustomFieldId");
	$fname = $field->Get("FieldName");
	if(isset($_POST[$fname]))
	$objCustomDataList->SetFieldValue($fieldid,$ResourceId,$_POST[$fname]);
	elseif(isset($_POST[strtolower($fname)]))
	$objCustomDataList->SetFieldValue($fieldid,$ResourceId,$_POST[strtolower($fname)]);
	}
	$objCustomDataList->SaveData();

	}
	break;
	case "m_profile":
	$userid = $objSession->Get("PortalUserId");
	if($userid>0)
	{
	$u = $objUsers->GetItem($userid);
	foreach($_POST as $field=>$value)
	{
	if(substr($field,0,3)=="pp_")
	{
	$objSession->SetPersistantVariable($field,$value);
	}
	}
	}
	break;
	case "m_set_lang":
	$lang = $_GET["lang"];
	$LangId = 0;
	if(strlen($lang))
	{
	$l = $objLanguages->GetItemByField("PackName",$lang);
	if(is_object($l))
	{
	$LangId = $l->Get("LanguageId");
	}
	}
	if($LangId)
	{
	if($objSession->Get("PortalUserId")>0)
	{
	$objSession->SetPersistantVariable("Language",$LangId);
	}
	$objSession->Set("Language",$LangId);
	$objSession->Update();
	$m_var_list_update["lang"] = $LangId;
	$m_var_list["lang"] = $LangId;
	}
	break;

	case "m_set_theme":
	$id = $_POST["ThemeId"];
	if(!is_numeric($id))
	$id = $_GET["ThemeId"];
	if($id)
	{
	$objSession->SetThemeName($id);
	$m_var_list["t"] = "index";
	$m_var_list_update["theme"] = $id;
	$m_var_list["theme"] = $id;
	unset($CurrentTheme);
	}
	break;

	case "m_sort_cats":
	$objSession->SetVariable("Category_Sortfield",$_POST["cat_field_sort"]);
	$objSession->SetVariable("Category_Sortorder",$_POST["cat_sort_order"]);
	break;
	case "m_add_cat_confirm":
	// phpinfo(INFO_VARIABLES);
	$perm = 0;
	$CategoryId=$objCatList->CurrentCategoryID();
	if ($objSession->HasCatPermission("CATEGORY.ADD.PENDING"))
	$perm = 2;
	if ($objSession->HasCatPermission("CATEGORY.ADD"))
	$perm = 1;
	if ($perm == 0)
	{
	$MissingCount++;
	$FormError["m_addcat"]["name"] = language("lu_ferror_no_access");
	}
	else
	{
	$MissingCount = SetMissingDataErrors("m_addcat");
	if(is_array($_FILES))
	{
	foreach($_FILES as $field => $file)
	{
	$allowed = TRUE;
	if(strlen($_POST["imagetypes"][$field]))
	{
	$types = explode(",",strtolower($_POST["imagetypes"][$field]));
	if(is_array($types))
	{
	if(count($types)>0)
	{
	$path_parts = pathinfo($file["name"]);
	$ext = $path_parts["extension"];
	$allowed = in_array($ext,$types);
	if(!$allowed)
	{
	$MissingCount++;
	$FormError["m_addcat"][$field] = language("lu_ferror_wrongtype");
	}
	}
	}
	}
	$maxsize = (int)$_POST["maxsize"][$field];
	if($maxsize>0 && $allowed && $file["size"]>$maxsize)
	{
	$allowed = FALSE;
	$MissingCount++;
	$FormError["m_addcat"][$field] = language("lu_ferror_toolarge");
	}
	}
	}
	if($MissingCount==0)
	{
	$CreatedOn = date("U");
	$_POST=inp_striptags($_POST);
	$name = $_POST["name"];
	$desc = $_POST["description"];
	$metadesc = $_POST["meta_description"];
	$keywords = $_POST["meta_keywords"];
	$parent = $objCatList->CurrentCategoryID();
	$cat =& $objCatList->Add($parent, $name, $desc, $CreatedOn,
	0, $perm, 2, 2, 2, 0, $keywords,$metadesc);
	$cat->UpdateCachedPath();
	$cat->Update();
	$cat->UpdateACL();
	$objCatList->UpdateMissingCacheData();

	if(strlen($_GET["Confirm"]))
	{
	$var_list["t"] = $_GET["Confirm"];
	}
	else
	$var_list["t"] = $_GET["DestTemplate"];
	}
	}
	break;
	case "m_front_review_add":
	if($objSession->InSpamControl($_POST["ItemId"]))
	{
	$StatusMessage["review"] = language("la_Review_AlreadyReviewed");
	}
	else
	{
	$objReviews = new clsItemReviewList();
	$Status = $objConfig->Get("Review_DefaultStatus");
	$CreatedOn = adodb_date("U");
	$html = (int)$objConfig->Get("Review_Html");
	$ReviewText = inp_striptags($_POST["review_text"]);

	$r = $objReviews->AddReview($CreatedOn,$ReviewText,$Status, $IPAddress,
	0, $_POST["ItemId"], $_POST["ItemType"], $objSession->Get("PortalUserId"));
	foreach($ItemTypes as $type=>$id)
	{
	if($id==$_POST["ItemType"])
	{
	$ValName = $type."_ReviewDelay_Value";
	$IntName = $type."_ReviewDelay_Interval";
	break;
	}
	}
	if(strlen($ValName) && strlen($IntName))
	{
	$exp_secs = $objConfig->Get($ValName) * $objConfig->Get($IntName);
	$objSession->AddToSpamControl($_POST["ItemId"],$exp_secs);
	if(is_object($r))
	{
	if($Status)
	{
	$StatusMessage["review"] = language("la_Review_Added");
	}
	else
	$StatusMessage["review"] = language("la_Review_Pending");
	}
	else
	$StatusMessage["review"] = language("la_Review_Error");
	}
	else
	$StatusMessage["error"] = language("la_ConfigError_Review");
	}
	break;
	case "m_suggest_email":
	$cutoff = time()+(int)$objConfig->Get("Suggest_MinInterval");
	$email = inp_striptags($_POST["suggest_email"]);

	if (strlen($email))
	{
	if(ValidEmail($email))
	{
	$sql = "SELECT * FROM ".GetTablePrefix()."SuggestMail WHERE email='".$email."' and sent<".$cutoff;
	$adodbConnection = &GetADODBConnection();
	$rs = $adodbConnection->Execute($sql);

	$rs = false;

	if($rs && !$rs->EOF)
	{
	if(strlen($_GET["Error"])>0)
	$var_list["t"] = $_GET["Error"];
	$suggest_result = "$email ".language("lu_already_suggested ")." ".LangDate($rs->fields["sent"]);
	}
	else
	{
	$Event =& $objMessageList->GetEmailEventObject("USER.SUGGEST");
	if(is_object($Event))
	{
	if($Event->Get("Enabled")=="1")
	{
	$Event->Item = $this;
	$Event->SendToAddress($email);

	$sql = "INSERT INTO ".GetTablePrefix()."SuggestMail (email,sent) VALUES ('".$email."','".time()."')";

	$rs = $adodbConnection->Execute($sql);
	$suggest_result=language("lu_suggest_success")." ".$email;
	}
	}
	$e =& $objMessageList->GetEmailEventObject("USER.SUGGEST",1);

	if($e->Get("Enabled")==1)
	$e->SendAdmin();

	if(strlen($_GET["Confirm"])>0)
	$var_list["t"] = $_GET["Confirm"];
	}
	}
	else
	{
	if(strlen($_GET["Error"])>0)
	$var_list["t"] = $_GET["Error"];
	$suggest_result=language("lu_invalid_emailaddress");
	}
	}
	else
	{
	if(strlen($_GET["Error"])>0)
	$var_list["t"] = $_GET["Error"];
	$suggest_result=language("lu_suggest_no_address");
	}
	break;
	case "m_simple_search":
	$keywords = $_POST["keywords"];
	$type = $objItemTypes->GetTypeByName("Category");
	$objSearch = new clsSearchResults("Category","clsCategory");
	+ $length = $objConfig->Get('Search_MinKeyword_Length');

	if(strlen($keywords))
	- {
	- $objSearchList = new clsSearchLogList();
	- $objSearchList->UpdateKeyword($keywords,0);
	+ {
	+ $performSearch = false;
	+ $isExact = (substr($keywords, 0, 1) == '"' && substr($keywords, strlen($keywords) - 1, 1) == '"');

	- $objSearch->SetKeywords($keywords);
	- $objSearch->AddSimpleFields();
	- if(is_numeric($objConfig->Get("SearchRel_Pop_category")))
	- $objSearch->PctPop = ($objConfig->Get("SearchRel_Pop_category")/100);
	- if(is_numeric($objConfig->Get("SearchRel_Keyword_category")))
	- $objSearch->PctRelevance = ($objConfig->Get("SearchRel_Keyword_category")/100);
	- if(is_numeric($objConfig->Get("SearchRel_Rating_article")))
	- $objSearch->PctRating = ($objConfig->Get("SearchRel_Rating_category")/100);
	-
	- //echo "Searching On $keywords<br>\n";
	- $objSearch->PerformSearch(1,$SortOrder,TRUE);
	- $SearchPerformed = TRUE;
	- //$objSearch->SetRelevence($type->Get("ItemType"), "CategoryId");
	- //echo "Finished Setting Category Relevence<br>\n";
	+ if ($isExact) {
	+ $performSearch = (strlen(trim(str_replace('"', '', $keywords))) >= $length);
	+ }
	+ else {
	+ $key_arr = explode(' ', $keywords);
	+
	+ foreach($key_arr as $value) {
	+ if (strlen($value) < $length) {
	+ $keywords = str_replace(' '.$value, '', $keywords);
	+ $keywords = str_replace($value.' ', '', $keywords);
	+ }
	+ }
	+
	+ $keywords = str_replace(' ', ' ', $keywords);
	+
	+ $performSearch = (strlen($keywords) >= $length);
	+ }
	+
	+ if ($performSearch) {
	+ $objSearchList = new clsSearchLogList();
	+ $objSearchList->UpdateKeyword($keywords,0);
	+
	+ $objSearch->SetKeywords($keywords);
	+ $objSearch->AddSimpleFields();
	+ if(is_numeric($objConfig->Get("SearchRel_Pop_category")))
	+ $objSearch->PctPop = ($objConfig->Get("SearchRel_Pop_category")/100);
	+ if(is_numeric($objConfig->Get("SearchRel_Keyword_category")))
	+ $objSearch->PctRelevance = ($objConfig->Get("SearchRel_Keyword_category")/100);
	+ if(is_numeric($objConfig->Get("SearchRel_Rating_article")))
	+ $objSearch->PctRating = ($objConfig->Get("SearchRel_Rating_category")/100);
	+
	+ //echo "Searching On $keywords<br>\n";
	+ $objSearch->PerformSearch(1,$SortOrder,TRUE);
	+ $SearchPerformed = TRUE;
	+ //$objSearch->SetRelevence($type->Get("ItemType"), "CategoryId");
	+ //echo "Finished Setting Category Relevence<br>\n";
	+ }
	+ else {
	+ if(strlen($_GET["Error"])>0)
	+ $var_list["t"] = $_GET["Error"];
	+
	+ $MissingCount = SetMissingDataErrors("m_simplesearch");
	+ $MissingCount++;
	+ $FormError["m_simplesearch"]["keywords"] = language("lu_keywords_tooshort");
	+ }
	}
	else
	{
	if(strlen($_GET["Error"])>0)
	$var_list["t"] = $_GET["Error"];

	$MissingCount = SetMissingDataErrors("m_simplesearch");
	$MissingCount++;
	$FormError["m_simplesearch"]["keywords"] = language("lu_no_keyword");
	}
	break;
	case "m_adv_search":
	if( !is_object($objSearchConfig) ) $objSearchConfig = new clsSearchConfigList();
	switch($_GET["type"])
	{
	case 1: /* category */
	//echo "Searching for categories<br>";
	$objAdvSearch = new clsAdvancedSearchResults("Category","clsCategory");
	foreach($objSearchConfig->Items as $field)
	{
	$fld = $field->Get("FieldName");

	$Verb = $_POST["verb"][$field->Get("FieldName")];
	if(!strlen($Verb) && $field->Get("FieldType")=="boolean")
	{
	if($_POST["value"][$field->Get("FieldName")]!=-1)
	{
	$Value = $_POST["value"][$field->Get("FieldName")];
	$Verb = "is";
	}
	}
	else
	{
	$Value = $_POST["value"][$field->Get("FieldName")];
	}
	switch( $_POST["andor"][$field->Get("FieldName")])
	{
	case 1:
	$Conjuction = "AND";
	break;
	case 2:
	$Conjuction = "OR";
	break;
	default:
	$Conjuction = "";
	break;
	}
	if(strlen($Verb)>0 && $Verb!="any")
	{
	//echo "Adding CAT SearchField: [".$field->Get("TableName")."]; [".$field->Get("FieldName")."]; [$Verb]; [$Value]; [$Conjuction]<br>";
	$objAdvSearch->AddAdvancedField($field->Get("TableName"),$field->Get("FieldName"),$Verb,$Value,$Conjuction);
	}

	}
	$objAdvSearch->PerformSearch(1,NULL,TRUE);
	break;
	}
	break;
	case "m_id":
	echo $Action.":".$DownloadId;
	die();
	break;
	case "m_simple_subsearch":
	$keywords = $_POST["keywords"];
	$type = $objItemTypes->GetTypeByName("Category");
	$objSearch = new clsSearchResults("Category","clsCategory");
	+ $length = $objConfig->Get('Search_MinKeyword_Length');
	+
	if(strlen($keywords))
	- {
	+ {
	+ $performSearch = false;
	+ $isExact = (substr($keywords, 0, 1) == '"' && substr($keywords, strlen($keywords) - 1, 1) == '"');
	+
	+ if ($isExact) {
	+ $performSearch = (strlen(trim(str_replace('"', '', $keywords))) >= $length);
	+ }
	+ else {
	+ $key_arr = explode(' ', $keywords);
	+
	+ foreach($key_arr as $value) {
	+ if (strlen($value) < $length) {
	+ $keywords = str_replace(' '.$value, '', $keywords);
	+ $keywords = str_replace($value.' ', '', $keywords);
	+ }
	+ }
	+
	+ $keywords = str_replace(' ', ' ', $keywords);
	+
	+ $performSearch = (strlen($keywords) >= $length);
	+ }
	+
	+ if ($performSearch) {
	$objSearchList = new clsSearchLogList();
	$objSearchList->UpdateKeyword($keywords,0);

	$objSearch->SetKeywords($keywords);
	$objSearch->AddSimpleFields();
	if(is_numeric($objConfig->Get("SearchRel_Pop_category")))
	$objSearch->PctPop = ($objConfig->Get("SearchRel_Pop_category")/100);
	if(is_numeric($objConfig->Get("SearchRel_Keyword_category")))
	$objSearch->PctRelevance = ($objConfig->Get("SearchRel_Keyword_category")/100);
	if(is_numeric($objConfig->Get("SearchRel_Rating_article")))
	$objSearch->PctRating = ($objConfig->Get("SearchRel_Rating_category")/100);

	$SearchResultIdList = $objSearch->Result_IdList();
	if(count($SearchResultIdList)>0)
	{
	$objSearch->PerformSearch(1,$SortOrder,TRUE,$SearchResultIdList);
	//$objSearch->SetRelevence($type->Get("ItemType"), "CategoryId");
	}
	$SearchPerformed = TRUE;
	+ }
	+ else {
	+ $MissingCount = SetMissingDataErrors("m_simplesearch");
	+ $MissingCount++;
	+ $FormError["m_simplesearch"]["keywords"] = language("lu_keywords_tooshort");
	+ }
	}
	else {
	$MissingCount = SetMissingDataErrors("m_simplesearch");
	$MissingCount++;
	$FormError["m_simplesearch"]["keywords"] = language("lu_no_keyword");
	}
	break;
	}
	?>

	Property changes on: trunk/kernel/frontaction.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.24
	\ No newline at end of property
	+1.25
	\ No newline at end of property
	Index: trunk/tools/debug_sample.php
	===================================================================
	--- trunk/tools/debug_sample.php (revision 835)
	+++ trunk/tools/debug_sample.php (revision 836)
	@@ -1,123 +1,126 @@
	<?php
	// uncomment next line to enable sql logging
	define('ADODB_OUTP', 'SQLLog');

	// sql logging to screen
	define('DOC_ROOT', $_SERVER['DOCUMENT_ROOT']);
	define('WINDOWS_ROOT', 'w:');
	define('WINDOWS_EDITOR', 'c:\Program Files\Zend\ZendStudio-4.0Beta\bin\ZDE.exe %F'); // %F - filename, %L - line number


	//define('SQL_TO_SCREEN', 1); // output sql queries to screen

	// sql logging to file
	define('SQL_TO_FILE', 1); // output sql queries to file
	define('SQL_ERROR_DIE', 1);
	define('SQL_OUTPUT', DOC_ROOT.'/inportal_sqls.txt'); // file where to store sql queries
	define('SQL_OVERWRITE', 1); // overwrite or not sql_log file

	// various levels of debugging

	// Admin:
	define('KERNEL_ACTIONS', 1); // only kernel
	define('MODULE_ACTIONS', 2); // only modules
	define('SEARCH_ACTIONS', 4); // kernel & modules
	define('SHOW_REQUEST', 8); // show formatted $_REQUEST array passed to script (GE - $_GET, PO - $_POST, CO - $_COOKIE)

	// Front:
	define('FRONT_KERNEL_ACTIONS', 16);
	define('FRONT_SHOW_REQUEST', 32);

	define('DEBUG_MODE', 1); // global debugging
	define('DEBUG_ACTIONS', KERNEL_ACTIONS + SHOW_REQUEST + FRONT_KERNEL_ACTIONS + FRONT_SHOW_REQUEST);
	//define('DEBUG_HELP', 1); // allow to add missing help
	+
	+ // For local license testing
	+ define('GET_LICENSE_URL', 'http://maris.prod.intechnic.lv/in-business/license.php');

	if( defined('DEBUG_MODE') && constant('DEBUG_MODE') == 1 )
	{
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	}
	ini_set('max_execution_time', '30');
	//ini_set('memory_limit', 512000000);
	function SQLLog($msg, $newline = true)
	{
	static $file_reset = false;

	//$LocationMessage = 'Called from file ['.basename($_SERVER['PHP_SELF']).']';
	//if($msg != $LocationMessage) SQLLog($LocationMessage);

	$db =& GetADODBConnection();
	// telestial specific: begin
	static $prefix = '';
	$prefix = GetTablePrefix();
	// 'Theme'
	$skip_tables = Array( 'Modules','Language','PermissionConfig','PermCache',
	'SessionData','UserSession','Phrase','ConfigurationValues',
	'PersistantSessionData','Events','EmailQueue',
	'Permissions');
	foreach($skip_tables as $table)
	if( strpos($msg, $prefix.$table) !== false ) return false;
	// telestial specific: end

	$select_pos = strpos($msg, 'SELECT ');
	if($select_pos !== false)
	{
	// add affected rows
	$before = substr($msg,0,$select_pos);
	$after = substr($msg,$select_pos,strlen($msg));
	$msg = $before.'AR: ['.$db->Affected_Rows().'] '.$after;
	}

	if($newline) $msg .= "<br>\n";
	if( defined('SQL_TO_SCREEN') && SQL_TO_SCREEN == 1 ) echo $msg;
	if( defined('SQL_TO_FILE') && SQL_TO_FILE == 1 )
	{
	if($file_reset == false && defined('SQL_OVERWRITE') && SQL_OVERWRITE)
	{
	if( file_exists(SQL_OUTPUT) ) unlink(SQL_OUTPUT);
	$file_reset = true;
	}
	$msg = str_replace(Array("<hr />\n",'   <code></code>','<','>','"'),Array('','','<','>','"'),$msg);
	$fp = fopen(SQL_OUTPUT, 'a');
	fwrite($fp,$msg);
	fclose($fp);
	}
	}

	/**
	* @return string
	* @desc Returnts trace results to place where called from
	*/
	function trace()
	{
	$trace_results = debug_backtrace();
	array_shift($trace_results);
	echo 'Called from [<b>'.$trace_results[0]['function'].'</b>]<br>';
	print_pre($trace_results);
	}

	function DebugByFile()
	{
	$ScriptName = basename( $_SERVER['PHP_SELF'] );
	switch ($ScriptName)
	{
	case 'step3.php':
	global $objSession;
	$objSession->SetVariable('import_sql_type', 'mysql');
	$objSession->SetVariable('import_server', 'localhost');
	$objSession->SetVariable('import_db', 'alex_in_portal'); //maris_inlink');
	$objSession->SetVariable('import_user', 'dev');
	$objSession->SetVariable('import_pass', 'dev-25-sql');

	$objSession->SetVariable('categoryid', 101); // resource id
	$objSession->SetVariable('import_category_id', 1); // category id
	$objSession->SetVariable('catnavbar', 'Home>Directory (debug_auto_complete)');
	$objSession->SetVariable('user_admin_names','admin');
	$objSession->SetVariable('user_admin_values', 11);
	$objSession->SetVariable('user_regular_names','Member');
	$objSession->SetVariable('user_regular_values', 13);
	break;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/tools/debug_sample.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2
	\ No newline at end of property
	+1.3
	\ No newline at end of property
	Index: trunk/admin/users/adduser_items.php
	===================================================================
	--- trunk/admin/users/adduser_items.php (revision 835)
	+++ trunk/admin/users/adduser_items.php (revision 836)
	@@ -1,334 +1,332 @@
	<?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. ##
	##############################################################
	if(!strlen($pathtoroot))
	{
	$path=dirname(realpath(__FILE__));
	if(strlen($path))
	{
	/* determine the OS type for path parsing */
	$pos = strpos($path,":");
	if ($pos === false)
	{
	$gOS_TYPE="unix";
	$pathchar = "/";
	}
	else
	{
	$gOS_TYPE="win";
	$pathchar="\\";
	}
	$p = $path.$pathchar;
	/Start looking for the root flag file /
	while(!strlen($pathtoroot) && strlen($p))
	{
	$sub = substr($p,strlen($pathchar)*-1);
	if($sub==$pathchar)
	{
	$filename = $p."root.flg";
	}
	else
	$filename = $p.$pathchar."root.flg";
	if(file_exists($filename))
	{
	$pathtoroot = $p;
	}
	else
	{
	$parent = realpath($p.$pathchar."..".$pathchar);
	if($parent!=$p)
	{
	$p = $parent;
	}
	else
	$p = "";
	}
	}
	if(!strlen($pathtoroot))
	$pathtoroot = ".".$pathchar;
	}
	else
	{
	$pathtoroot = ".".$pathchar;
	}
	}

	$sub = substr($pathtoroot,strlen($pathchar)*-1);
	if($sub!=$pathchar)
	{
	$pathtoroot = $pathtoroot.$pathchar;
	}
	//echo $pathtoroot;

	require_once($pathtoroot."kernel/startup.php");
	//admin only util
	$rootURL="http://".ThisDomain().$objConfig->Get("Site_Path");
	$admin = $objConfig->Get("AdminDirectory");
	if(!strlen($admin))
	$admin = "admin";

	$localURL=$rootURL."kernel/";
	$adminURL = $rootURL.$admin;
	$imagesURL = $adminURL."/images";

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

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

	unset($objEditItems);

	$objEditItems = new clsCatList();
	$objEditItems->SourceTable = $objSession->GetEditTable("PortalUser");
	$objEditItems->EnablePaging = FALSE;
	//Multiedit init
	$en = GetVar('en');
	$objEditItems->Query_Item("SELECT * FROM ".$objEditItems->SourceTable);


	$itemcount=$objEditItems->NumItems();
	$c = $objEditItems->GetItemByIndex($en);

	-$objImageList = new clsImageList();
	-$objImageList->Query_Images("ResourceId=".$c->Get("ResourceId"),"");
	-
	if($itemcount>1)
	{
	if ($en+1 == $itemcount)
	$en_next = -1;
	else
	$en_next = $en+1;

	if ($en == 0)
	$en_prev = -1;
	else
	$en_prev = $en-1;
	}
	$action = "m_item_list";

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

	$section = 'in-portal:edituser_items';
	$sec = $objSections->GetSection($section);

	$title = GetTitle("la_Text_User", "la_tab_Images", $c->Get('PortalUserId'), $c->Get('Login'));//admin_language("la_Text_Editing")." ".admin_language("la_Text_User")." '".$c->Get("Login")."' - ".admin_language("la_tab_Images");

	$objListToolBar = new clsToolBar();
	$objListToolBar->Add("img_save", "la_Save","#","swap('img_save','toolbar/tool_select_f2.gif');", "swap('img_save', 'toolbar/tool_select.gif');","do_edit_save('save_edit_buttons','".$admin."/users/user_list.php',1);","tool_select.gif");
	$objListToolBar->Add("img_cancel", "la_Cancel","#","swap('img_cancel','toolbar/tool_cancel_f2.gif');", "swap('img_cancel', 'toolbar/tool_cancel.gif');","do_edit_save('save_edit_buttons','".$admin."/users/user_list.php',2);","tool_cancel.gif");
	if($itemcount == 1) $objListToolBar->Add("divider");

	$objListToolBar->Set("section",$section);
	$objListToolBar->Set("load_menu_func","");
	$objListToolBar->Set("CheckClass","ImageChecks");

	if ( isset($en_prev) \|\| isset($en_next) )
	{
	$url = $RootUrl.$admin."/users/adduser_items.php";
	$StatusField = "UserEditStatus";
	$form = "edituser";
	MultiEditButtons($objListToolBar,$en_next,$en_prev,$form,$StatusField,$url,$sec->Get("OnClick"),'','la_PrevUser','la_NextUser');
	$objListToolBar->Add("divider");
	}

	$listImages = array();

	$objListToolBar->Add("viewmenubutton", "la_ToolTip_View","#","swap('viewmenubutton','toolbar/tool_view_f2.gif'); ",
	"swap('viewmenubutton', 'toolbar/tool_view.gif');",
	"ShowViewMenu();","tool_view.gif");


	$objListToolBar->AddToInitScript($listImages);
	$objListToolBar->AddToInitScript("fwLoadMenus();");

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

	-if ($UserView != $Bit_All) {
	+
	+if ($ItemView != $Bit_All) {
	$filter = true;
	}


	$title = admin_language("la_Text_Editing")." ".admin_language("la_Text_User")." '".$c->Get("Login")."' - ".admin_language("la_tab_ItemList");
	int_header($objListToolBar,NULL, $title);
	if ($objSession->GetVariable("HasChanges") == 1) {
	?>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
	<tr>
	<td valign="top">
	<?php int_hint_red(admin_language("la_Warning_Save_Item")); ?>
	</td>
	</tr>
	</table>
	<?php } ?>
	<?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 } ?>
	<form name="edituser" ID="edituser" action="<?php echo $_SERVER["PHP_SELF"]."?".$envar;?>" method=POST>
	<table cellSpacing="0" cellPadding="2" width="100%" class="tableborder">
	<tbody>
	<?php

	if( GetVar('lpn') )
	{
	$objSession->SetVariable("Page_Items",(int)$_GET["lpn"]);
	$page = (int)$_GET["lpn"];
	}
	else
	{
	$page = $objSession->GetVariable("Page_Items");
	}
	$objItems = new clsMultiTypeList();
	$table = $objSession->GetEditTable("UserItems"); //$objSession->GetSessionKey()."_UserItems";
	$objItems->SourceTable = $table;

	// ==== build sql depending on modules installed: begin ====
	$prefix = GetTablePrefix();
	$modules = $objModules->GetModuleList();
	$sql_source = $objModules->ExecuteFunction('GetModuleInfo', 'rel_list');

	$sql_templates['ItemName'] = 'IFNULL('.$prefix."%s.%s,' ')";
	$sql_templates['TableJoin'] = 'LEFT JOIN '.$prefix."%1\$s ON ".$prefix."%1\$s.ResourceId = ut.ResourceId";
	$sql_templates['ItemType'] = "IF(ut.ItemType = %s, '%s', %s)";

	$sql = "SELECT TRIM(CONCAT(%s)) AS ItemName, %s AS ItemTypeStr, ut.ItemType as ItemType, ".
	'ut.ResourceId as ItemId FROM '.$table." ut %s ".
	'WHERE ut.PortalUserId = '.$c->Get("PortalUserId");


	$sql_parts = Array();
	$sql_parts['ItemType'] = "''";
	foreach($modules as $module)
	{
	$sql_parts['ItemName'][] = sprintf($sql_templates['ItemName'], $sql_source[$module]['MainTable'], $sql_source[$module]['ItemNameField']);
	$sql_parts['TableJoin'][] = sprintf($sql_templates['TableJoin'], $sql_source[$module]['MainTable']);
	$sql_parts['ItemType'] = sprintf( $sql_templates['ItemType'],
	$sql_source[$module]['TargetType'],
	admin_language($sql_source[$module]['ItemNamePhrase']),
	$sql_parts['ItemType']);
	}

	$sql = sprintf($sql, implode(', ',$sql_parts['ItemName']), $sql_parts['ItemType'], implode(' ',$sql_parts['TableJoin']));
	// ==== build sql depending on modules installed: end ====

	if(strlen($itemFilter))
	$sql .= " AND ($itemFilter)";

	$countwhere = "PortalUserId=".$c->Get("PortalUserId");
	if(strlen($itemFilter))
	$countwhere .= " AND ($itemFilter)";

	$itemcount = TableCount($table,$countwhere,0);

	if(strlen(trim($objConfig->Get("UserItem_LV_Sortfield"))))
	{
	$order = " ORDER BY ". $objConfig->Get("UserItem_LV_Sortfield")." ".$objConfig->Get("UserItem_LV_Sortorder");
	}
	else
	$order = "";

	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";

	$objListView = new clsListView($objListToolBar);
	$objListView->CurrentPageVar = "Page_Items";
	$objListView->PerPageVar = "Perpage_Items";

	$objItems->Query_Item($sql, $objListView->GetLimitSQL() );


	for($i=0;$i<count($objItems->Items);$i++)
	{
	$item =& $objItems->GetItemRefByIndex($i);

	$n = $item->Get("ItemName");
	$type = $item->Get("ItemType");
	$url = $objItemTypes->GetTypeEditUrl($type);
	if(strlen($url))
	{
	$url .= "?env=".BuildEnv()."&newsession=1&item=".$item->Get("ItemId")."&return=".$admin."/users/adduser_items.php";
	$url = "<A TARGET=\"editwin\" HREF=\"".$url."\">$n</A>";
	$item->Set("ItemName",$url);
	}
	}

	$objListView->SetListItems($objItems);
	$objListView->IdField = "ResourceId";
	$order = $objConfig->Get("UserItem_LV_Sortfield");
	$SortOrder=0;
	if($objConfig->Get("UserItem_LV_Sortorder")=="asc")
	$SortOrder=1;

	$objListView->ColumnHeaders->Add("ItemName",admin_language("la_ColHeader_Item"),1,0,$order,"width=\"20%\"","UserItem_LV_Sortfield","UserItem_LV_Sortorder" ,"ItemName");
	$objListView->ColumnHeaders->Add("ItemTypeStr",admin_language("la_ColHeader_ItemType"),1,0,$order,"width=\"20%\"","UserItem_LV_Sortfield","UserItem_LV_Sortorder","ItemType");
	//$objListView->ColumnHeaders->Add("DateCreated",admin_language("la_prompt_CreatedOn"),1,0,$order,"width=\"20%\"","UserItem_LV_Sortfield","UserItem_LV_Sortorder","DateCreated");

	$objListView->ColumnHeaders->SetSort($objConfig->Get("UserItem_LV_Sortfield"), $objConfig->Get("UserItem_LV_Sortorder"));

	$objListView->PrintToolBar = FALSE;
	$objListView->checkboxes = FALSE;
	$objListView->CheckboxName = "";
	$objListView->TotalItemCount = $itemcount;


	/* for($i=0;$i<count($objImageList->Items);$i++)
	{
	$img =& $objImageList->GetItemRefByIndex($i);
	$objListView->RowIcons[] = $img->Get("Icon");
	}
	*/
	//$objListView->SliceItems();
	print $objListView->PrintList();

	?>
	<input TYPE="hidden" NAME="ResourceId" VALUE="<?php echo $c->Get("ResourceId"); ?>">
	<input type="hidden" name="Action" value="m_item_image">

	</FORM>
	<FORM NAME="save_edit_buttons" ID="save_edit_buttons" method="POST" ACTION="">
	<tr <?php int_table_color(); ?>>
	<td colspan="5">
	<input type=hidden NAME="Action" VALUE="save_user_edit">
	<input type="hidden" name="UserEditStatus" VALUE="0">
	</td>
	</tr>
	</FORM>
	</TBODY>
	</table>
	<!-- CODE FOR VIEW MENU -->
	<form ID="viewmenu" method="post" action="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>" 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>
	<script src="<?php echo $adminURL; ?>/listview/listview.js"></script>
	<script>
	//initSelectiorContainers()
	</script>
	<!-- END CODE-->
	<?php int_footer(); ?>


	Property changes on: trunk/admin/users/adduser_items.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/logs/searchlog.php
	===================================================================
	--- trunk/admin/logs/searchlog.php (revision 835)
	+++ trunk/admin/logs/searchlog.php (revision 836)
	@@ -1,227 +1,227 @@
	<?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. ##
	##############################################################
	if(!strlen($pathtoroot))
	{
	$path=dirname(realpath(__FILE__));
	if(strlen($path))
	{
	/* determine the OS type for path parsing */
	$pos = strpos($path,":");
	if ($pos === false)
	{
	$gOS_TYPE="unix";
	$pathchar = "/";
	}
	else
	{
	$gOS_TYPE="win";
	$pathchar="\\";
	}
	$p = $path.$pathchar;
	/Start looking for the root flag file /
	while(!strlen($pathtoroot) && strlen($p))
	{
	$sub = substr($p,strlen($pathchar)*-1);
	if($sub==$pathchar)
	{
	$filename = $p."root.flg";
	}
	else
	$filename = $p.$pathchar."root.flg";
	if(file_exists($filename))
	{
	$pathtoroot = $p;
	}
	else
	{
	$parent = realpath($p.$pathchar."..".$pathchar);
	if($parent!=$p)
	{
	$p = $parent;
	}
	else
	$p = "";
	}
	}
	if(!strlen($pathtoroot))
	$pathtoroot = ".".$pathchar;
	}
	else
	{
	$pathtoroot = ".".$pathchar;
	}
	}

	$sub = substr($pathtoroot,strlen($pathchar)*-1);
	if($sub!=$pathchar)
	{
	$pathtoroot = $pathtoroot.$pathchar;
	}
	//echo $pathtoroot;

	require_once($pathtoroot."kernel/startup.php");

	$rootURL="http://".ThisDomain().$objConfig->Get("Site_Path");

	$admin = $objConfig->Get("AdminDirectory");
	if(!strlen($admin))
	$admin = "admin";
	$localURL=$rootURL."kernel/";
	$adminURL = $rootURL.$admin;
	$imagesURL = $adminURL."/images";

	//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");
	require_once($pathtoroot.$admin."/listview/listview.php");

	$pathtolocal = $pathtoroot;

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

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

	//Display header

	$objListToolBar = new clsToolBar();

	$objListToolBar->Set("section",$section);
	$objListToolBar->Set("load_menu_func","");
	$objListToolBar->Set("CheckClass","ListChecks");
	$objListToolBar->Set("CheckForm","searchlistform");

	$listImages = array();
	//$img, $alt, $link, $onMouseOver, $onMouseOut, $onClick

	$objListToolBar->Add("log_refresh", "la_ToolTip_Refresh","#","swap('log_refresh','toolbar/tool_refresh_f2.gif');",
	"swap('log_refresh', 'toolbar/tool_refresh.gif');","window.location.reload(true);",
	"tool_refresh.gif", FALSE, TRUE);

	$objListToolBar->Add("log_reset","la_ToolTip_Reset","#", "if (ListChecks.itemChecked()) swap('log_reset','toolbar/tool_reset_f2.gif');",
	"if (ListChecks.itemChecked()) swap('log_reset', 'toolbar/tool_reset.gif');","if (ListChecks.itemChecked()) ListChecks.check_submit('searchlog','m_keyword_reset');",
	"tool_reset.gif", TRUE, TRUE);

	$listImages[] = "ListChecks.addImage('log_reset','$imagesURL/toolbar/tool_reset.gif','$imagesURL/toolbar/tool_reset_f3.gif',1); ";

	$objListToolBar->Add("divider");

	$objListToolBar->Add("user_print", "la_ToolTip_Print","#","swap('user_print','toolbar/tool_print_f2.gif');",
	"swap('user_print', 'toolbar/tool_print.gif');","window.print();","tool_print.gif");

	/*$objListToolBar->Add("viewmenubutton", "la_ToolTip_View","#","swap('viewmenubutton','toolbar/tool_view_f2.gif'); ",
	"swap('viewmenubutton', 'toolbar/tool_view.gif');",
	"ShowViewMenu();","tool_view.gif");
	*/
	$objListToolBar->AddToInitScript($listImages);
	$objListToolBar->AddToInitScript("fwLoadMenus();");

	$objSearchList = new clsSearchLogList();

	$order = $objConfig->Get("SearchLog_SortOrder");
	$SearchWords = $objSession->GetVariable("KeywordSearchWord");
	if(strlen($SearchWords))
	{
	- $where = $objSearchWords->AdminSearchWhereClause($SearchWords);
	+ $where = $objSearchList->AdminSearchWhereClause($SearchWords);
	}
	else
	$where = "";

	$sql = "SELECT ELT(sl.SearchType+1,'".admin_language("la_Text_Simple")."','".admin_language("la_Text_Advanced")."') as TextType,sl.* FROM ".GetTablePrefix()."SearchLog as sl";

	if(strlen($where))
	$sql .= " WHERE ".$where;

	$orderBy = trim($objConfig->Get("SearchLog_SortField")." ".$objConfig->Get("SearchLog_SortOrder"));
	if(strlen($orderBy))
	$sql .=" ORDER BY ".$orderBy;

	$sql .=" ".GetLimitSQL($objSession->GetVariable("Page_SearchLog"),$objConfig->Get("Perpage_SearchLog"));

	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo $sql."<br>\n";

	$objSearchList->Query_Item($sql);
	$itemcount = TableCount(GetTablePrefix()."SearchLog", $where,0);

	$objListView = new clsListView($objListToolBar,$objSearchList);
	$objListView->IdField = "SearchLogId";
	$objListView->PageLinkTemplate = $pathtoroot.$admin."/templates/user_page_link.tpl";

	$objListView->ColumnHeaders->Add("TextType",admin_language("la_prompt_SearchType"),1,0,$order,"width=\"20%\"","SearchLog_SortField","SearchLog_SortOrder","TextType");
	$objListView->ColumnHeaders->Add("Keyword",admin_language("la_prompt_Keyword"),1,0,$order,"width=\"20%\"","SearchLog_SortField","SearchLog_SortOrder","Keyword");
	$objListView->ColumnHeaders->Add("Indices",admin_language("la_prompt_Frequency"),1,0,$order,"width=\"30%\"","SearchLog_SortField","SearchLog_SortOrder","Indices");
	$objListView->ColumnHeaders->SetSort($objConfig->Get("SearchLog_SortField"),$order);

	$objListView->PrintToolBar = FALSE;
	$objListView->SearchBar = TRUE;
	$objListView->SearchKeywords = $SearchWords;
	$objListView->SearchAction="m_searchword_search";
	$objListView->CurrentPageVar = "Page_SearchLog";
	$objListView->PerPageVar = "Perpage_SearchLog";
	$objListView->CheckboxName = "itemlist[]";
	$objListView->TotalItemCount = $itemcount;

	$objListView->ConfigureViewMenu("SearchLog_SortField","SearchLog_SortOrder","TextType","","",0);

	$filter = false;
	if ($SearchWords != '') {
	$filter = true;
	}

	$title = admin_language("la_Show_Log")." (".$itemcount.")";
	$h = "\n\n<SCRIPT Language=\"JavaScript1.2\">\n".$objListView->GetViewMenu($imagesURL)."\n</SCRIPT>\n";
	int_header($objListToolBar,NULL,$title, NULL, $h);
	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 } ?>
	<FORM method="POST" ACTION="" NAME="searchlistform" ID="searchlistform">
	<?php
	print $objListView->PrintList();
	?>
	<input type="hidden" name="Action" value="">
	</FORM>

	<!-- CODE FOR VIEW MENU -->
	<form ID="viewmenu" method="post" action="<?php echo $_SERVER["PHP_SELF"]."?env=".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>
	<FORM ID="ListSearchForm" NAME="ListSearchForm" method="POST" action="<?php echo $_SERVER["PHP_SELF"]."?env=".BuildEnv(); ?>">
	<INPUT TYPE="HIDDEN" NAME="Action" VALUE="">
	<INPUT TYPE="HIDDEN" NAME="list_search">
	</FORM>
	<script src="<?php echo $adminURL; ?>/listview/listview.js"></script>
	<script>
	initSelectiorContainers();
	<?php echo $objListToolBar->Get("CheckClass").".setImages();"; ?>
	</script>
	<!-- END CODE-->
	<?php int_footer(); ?>


	Property changes on: trunk/admin/logs/searchlog.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.3
	\ No newline at end of property
	+1.4
	\ No newline at end of property
	Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql
	===================================================================
	--- trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql (revision 835)
	+++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql (revision 836)
	@@ -1,5 +1,8 @@
	-ALTER TABLE Category DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	-ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	-ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	-
	+ALTER TABLE Category DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	+ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	+ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
	+
	+INSERT INTO ConfigurationValues VALUES ('Search_MinKeyword_Length', '3', 'In-Portal', '');
	+
	+
	UPDATE Modules SET Version = '1.0.10' WHERE Name = 'In-Portal';
	\ No newline at end of file

	Property changes on: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2
	\ No newline at end of property
	+1.3
	\ No newline at end of property
	Index: trunk/admin/install/inportal_data.sql
	===================================================================
	--- trunk/admin/install/inportal_data.sql (revision 835)
	+++ trunk/admin/install/inportal_data.sql (revision 836)
	@@ -1,282 +1,283 @@
	INSERT INTO ConfigurationAdmin VALUES ('Site_Name', 'la_Text_Website', 'la_config_website_name', 'text', '', '', 7, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Site_Path', 'la_Text_Website', 'la_config_web_address', 'text', '', '', 6, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Backup_Path', 'la_Text_BackupPath', 'la_config_backup_path', 'text', '', '', 6, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Domain_Detect', 'la_Text_Website', 'la_config_detect_domain', 'text', '', '', 8, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_Sortfield', 'la_Text_General', 'la_category_sortfield_prompt', 'select', '', 'Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,Pop=la_Category_Pop,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=0</SQL>', 1, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_Sortorder', 'la_Text_General', 'la_category_sortfield_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 2, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_Sortfield2', 'la_Text_General', 'la_category_sortfield2_prompt', 'select', '', 'Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,Pop=la_Category_Pop,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=0</SQL>', 3, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_Sortorder2', 'la_text_General', 'la_category_sortfield2_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 4, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Perpage_Category', 'la_Text_General', 'la_category_perpage_prompt', 'text', '', '', 5, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_DaysNew', 'la_Text_General', 'la_category_daysnew_prompt', 'text', '', '', 6, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_ShowPick', 'la_Text_General', 'la_category_showpick_prompt', 'checkbox', '', '', 7, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_MetaKey', 'la_Text_MetaInfo', 'la_category_metakey', 'text', '', '', 8, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Category_MetaDesc', 'la_Text_MetaInfo', 'la_category_metadesc', 'text', '', '', 9, 1);
	INSERT INTO ConfigurationAdmin VALUES ('User_NewGroup', 'la_Text_General', 'la_users_new_group', 'select', NULL, '0=lu_none,<SQL>SELECT GroupId as OptionName, Name as OptionValue FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 3, 1);
	INSERT INTO ConfigurationAdmin VALUES ('User_GuestGroup', 'la_Text_General', 'la_users_guest_group', 'select', NULL, '0=lu_none,<SQL>SELECT GroupId as OptionName, Name as OptionValue FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 4, 1);
	INSERT INTO ConfigurationAdmin VALUES ('RootPass', 'la_Text_General', 'la_prompt_root_pass', 'password', NULL, NULL, 11, 0);
	INSERT INTO ConfigurationAdmin VALUES ('RootPassVerify', 'la_Text_General', 'la_prompt_root_pass_verify', 'password', NULL, NULL, 11, 0);
	INSERT INTO ConfigurationAdmin VALUES ('User_Allow_New', 'la_Text_General', 'la_users_allow_new', 'radio', '', '1=la_User_Instant,2=la_User_Not_Allowed,3=la_User_Upon_Approval', 1, 1);
	INSERT INTO ConfigurationAdmin VALUES ('User_Password_Auto', 'la_Text_General', 'la_users_password_auto', 'checkbox', '', '', 10, 1);
	INSERT INTO ConfigurationAdmin VALUES ('User_Votes_Deny', 'la_Text_Restrictions', 'la_users_votes_deny', 'text', '', '', 4, 1);
	INSERT INTO ConfigurationAdmin VALUES ('User_Review_Deny', 'la_Text_Restrictions', 'la_users_review_deny', 'text', '', '', 5, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Server_Name', 'la_Text_Website', 'la_config_server_name', 'text', '', '', 4, 0);
	INSERT INTO ConfigurationAdmin VALUES ('Config_Server_Time', 'la_Text_Date_Time_Settings', 'la_config_time_server', 'select', '', '1=la_m12,2=la_m11,3=la_m10,5=la_m9,6=la_m8,7=la_m7,8=la_m6,9=la_m5,10=la_m4,11=la_m3,12=la_m2,13=la_m1,14=la_m0,15=la_p1,16=la_p2,17=la_p3,18=la_p4,19=la_p5,20=la_p6,21=la_p7,22=la_p8,23=la_p9,24=la_p10,25=la_p11,26=la_p12,27=la_p13', 6, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Config_Site_Time', 'la_Text_Date_Time_Settings', 'la_config_site_zone', 'select', '', '1=la_m12,2=la_m11,3=la_m10,5=la_m9,6=la_m8,7=la_m7,8=la_m6,9=la_m5,10=la_m4,11=la_m3,12=la_m2,13=la_m1,14=la_m0,15=la_p1,16=la_p2,17=la_p3,18=la_p4,19=la_p5,20=la_p6,21=la_p7,22=la_p8,23=la_p9,24=la_p10,25=la_p11,26=la_p12,27=la_p13', 7, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_Server', 'la_Text_smtp_server', 'la_prompt_mailserver', 'text', NULL, NULL, 10, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_Port', 'la_Text_smtp_server', 'la_prompt_mailport', 'text', NULL, NULL, 11, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_Authenticate', 'la_Text_smtp_server', 'la_prompt_mailauthenticate', 'checkbox', NULL, NULL, 12, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_User', 'la_Text_smtp_server', 'la_prompt_smtp_user', 'text', NULL, NULL, 13, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_Pass', 'la_Text_smtp_server', 'la_prompt_smtp_pass', 'text', NULL, NULL, 14, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_SendHTML', 'la_Text_smtp_server', 'la_prompt_mailhtml', 'checkbox', NULL, NULL, 15, 0);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_DefaultHeaders', 'la_Text_smtp_server', 'la_prompt_smtpheaders', 'textarea', NULL, 'COLS=40 ROWS=5', 16, 0);
	INSERT INTO ConfigurationAdmin VALUES ('Smtp_AdminMailFrom', 'la_Text_smtp_server', 'la_prompt_AdminMailFrom', 'text', NULL, NULL, 17, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Perpage_Category_Short', 'la_Text_General', 'la_category_perpage__short_prompt', 'text', '', '', 5, 1);
	INSERT INTO ConfigurationAdmin VALUES ('CookieSessions', 'la_Text_Website', 'la_prompt_session_management', 'select', NULL, '0=lu_query_string,1=lu_cookies,2=lu_auto', 8, 1);
	INSERT INTO ConfigurationAdmin VALUES ('SessionTimeout', 'la_Text_Website', 'la_prompt_session_timeout', 'text','', '', 9, 1);
	INSERT INTO ConfigurationAdmin VALUES ('SystemTagCache', 'la_Text_Website', 'la_prompt_syscache_enable', 'checkbox', NULL, NULL, 10, 0);
	INSERT INTO ConfigurationAdmin VALUES ('User_SubscriberGroup', 'la_Text_General', 'la_users_subscriber_group', 'select', NULL, '0=lu_none,<SQL>SELECT GroupId as OptionName, Name as OptionValue FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 5, 1);
	INSERT INTO ConfigurationAdmin VALUES ('Root_Name', 'la_Text_General', 'la_prompt_root_name', 'text', '', '', 8, 1);
	INSERT INTO ConfigurationAdmin VALUES ('SocketBlockingMode', 'la_Text_Website', 'la_prompt_socket_blocking_mode', 'checkbox', NULL, NULL, 11, 0);
	INSERT INTO ConfigurationAdmin VALUES ('Min_UserName', 'la_Text_General', 'la_text_min_username', 'text', '', '', 1, 0);
	INSERT INTO ConfigurationAdmin VALUES ('Min_Password', 'la_Text_General', 'la_text_min_password', 'text', '', '', 2, 0);

	INSERT INTO ConfigurationValues VALUES ('Columns_Category', '2', 'In-Portal', 'Categories')
	INSERT INTO ConfigurationValues VALUES ('DomainSelect','1','In-Portal','in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Site_Path', '/', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Archive', '25', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('debug', '1', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_User', '100', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_LangEmail', '20', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('Default_FromAddr', '', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('email_replyto', '', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('email_footer', 'message footer goes here', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('Default_Theme', 'default', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Default_Language', 'English', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('SessionTimeout', '3600', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('User_SortOrder', 'asc', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Suggest_MinInterval', '3600', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('SubCat_ListCount', '3', 'inportal', '')
	INSERT INTO ConfigurationValues VALUES ('Timeout_Rating', '3600', 'In-Portal', 'System')
	INSERT INTO ConfigurationValues VALUES ('User_SortField', 'u.CreatedOn', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Relations', '10', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Group_SortField', 'GroupName', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Group_SortOrder', 'asc', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Default_FromName', 'Webmaster', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Category', '10', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_Sortfield', 'Name', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_Sortorder', 'asc', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('MetaKeywords', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Relation_LV_Sortfield', 'ItemType', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('ampm_time', '1', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Template', '10', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Phrase', '40', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Sessionlist', '20', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Category_Sortfield2', 'Description', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_Sortorder2', 'asc', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_DaysNew', '8', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_ShowPick', '', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_MetaKey', '', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_MetaDesc', '', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('MetaDescription', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('User_NewGroup', '13', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('User_Allow_New', '3', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('User_Password_Auto', '0', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('User_Votes_Deny', '5', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('User_Review_Deny', '5', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('Config_Name', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Company', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Reg_Number', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Website_Name', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Web_Address', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Server_Time', '14', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Config_Site_Time', '14', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Site_Name', 'In-Portal', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Backup_Path', '', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Items', '20', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('GuestSessions', '1', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Smtp_Server', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_Port', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_User', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_Pass', NULL, 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_SendHTML', '1', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_Authenticate', '0', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Email', '10', 'In-Portal', '')
	INSERT INTO ConfigurationValues VALUES ('Smtp_DefaultHeaders', 'X-Priority: 1\r\nX-MSMail-Priority: High\r\nX-Mailer: In-Portal', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Smtp_AdminMailFrom', 'portal@user.domain.name', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('Category_Highlight_OpenTag', '<span class="match">', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('Category_Highlight_CloseTag', '</span>', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('User_GuestGroup', '14', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('RootPass', '', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('RootPassVerify', '', 'In-Portal:Users', 'in-portal:configure_users')
	INSERT INTO ConfigurationValues VALUES ('Perpage_Category_Short', '3', 'In-Portal', 'in-portal:configure_categories')
	INSERT INTO ConfigurationValues VALUES ('CookieSessions', '2', 'In-Portal', 'in-portal:configure_general')
	INSERT INTO ConfigurationValues VALUES ('SearchRel_Increase_category', '30', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_Keyword_category', '90', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_Pop_category', '5', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_Rating_category', '5', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_DefaultIncrease', '30', 'In-Portal', 'inportal:configure_searchdefault');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_DefaultKeyword', '80', 'In-Portal', 'SearchRel_DefaultKeyword');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_DefaultPop', '10', 'In-Portal', 'inportal:configuration_searchdefault');
	INSERT INTO ConfigurationValues VALUES ('SearchRel_DefaultRating', '10', 'In-Portal', 'inportal:configure_searchdefault');
	INSERT INTO ConfigurationValues VALUES ('SystemTagCache', '0', 'In-Portal', 'in-portal:configure_general');
	INSERT INTO ConfigurationValues VALUES ('Root_Name', 'lu_rootcategory_name', 'In-Portal', 'in-portal:configure_categories');
	INSERT INTO ConfigurationValues VALUES ('User_SubscriberGroup', '12', 'In-Portal:Users', 'in-portal:configure_users');
	INSERT INTO ConfigurationValues VALUES ('SocketBlockingMode', '0', 'In-Portal', 'in-portal:configure_general');
	INSERT INTO ConfigurationValues VALUES ('Min_UserName', '3', 'In-Portal:Users', 'in-portal:configure_users');
	INSERT INTO ConfigurationValues VALUES ('Min_Password', '5', 'In-Portal:Users', 'in-portal:configure_users');
	INSERT INTO ConfigurationValues VALUES ('LinksValidation_LV_Sortfield', 'ValidationTime', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('CustomConfig_LV_Sortfield', 'FieldName', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Event_LV_SortField', 'Description', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Theme_LV_SortField', 'Name', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Template_LV_SortField', 'FileName', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Lang_LV_SortField', 'PackName', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Phrase_LV_SortField', 'Phrase', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('LangEmail_LV_SortField', 'Description', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('CustomData_LV_SortField', 'FieldName', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Summary_SortField', 'Module', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Session_SortField', 'UserName', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('SearchLog_SortField', 'Keyword', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_StatItem', '10', 'inportal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Groups', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Event', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_BanRules', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_SearchLog', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_LV_lang', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_LV_Themes', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_LV_Catlist', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Reviews', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Modules', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Grouplist', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_Images', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('EmailsL_SortField', 'time_sent', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_EmailsL', '20', 'In-Portal', '');
	INSERT INTO ConfigurationValues VALUES ('Perpage_CustomData', '20', 'In-Portal', '');
	+INSERT INTO ConfigurationValues VALUES ('Search_MinKeyword_Length', '3', 'In-Portal', '');

	INSERT INTO Events VALUES (30, 'USER.ADD', 1, 0, 'In-Portal:Users', 'la_event_user.add', 0)
	INSERT INTO Events VALUES (32, 'USER.ADD', 2, 0, 'In-Portal:Users', 'la_event_user.add', 1)
	INSERT INTO Events VALUES (31, 'USER.APPROVE', 1, 0, 'In-Portal:Users', 'la_event_user.approve', 0)
	INSERT INTO Events VALUES (33, 'USER.APPROVE', 2, 0, 'In-Portal:Users', 'la_event_user.approve', 1)
	INSERT INTO Events VALUES (34, 'USER.VALIDATE', 1, 0, 'In-Portal:Users', 'la_event_user.validate', 0)
	INSERT INTO Events VALUES (35, 'USER.VALIDATE', 2, 0, 'In-Portal:Users', 'la_event_user.validate', 1)
	INSERT INTO Events VALUES (36, 'USER.DENY', 1, 0, 'In-Portal:Users', 'la_event_user.deny', 0)
	INSERT INTO Events VALUES (37, 'USER.DENY', 2, 0, 'In-Portal:Users', 'la_event_user.deny', 1)
	INSERT INTO Events VALUES (38, 'USER.PSWD', 2, 0, 'In-Portal:Users', 'la_event_user.forgotpw', 1)
	INSERT INTO Events VALUES (39, 'USER.PSWD', 1, 0, 'In-Portal:Users', 'la_event_user.forgotpw', 0)
	INSERT INTO Events VALUES (45, 'USER.ADD.PENDING', 1, 0, 'In-Portal:Users', 'la_event_user.add.pending', 0)
	INSERT INTO Events VALUES (47, 'CATEGORY.ADD', 1, 0, 'In-Portal:Category', 'la_event_category.add', 0)
	INSERT INTO Events VALUES (48, 'CATEGORY.ADD.PENDING', 1, 0, 'In-Portal:Category', 'la_event_category.add.pending', 0)
	INSERT INTO Events VALUES (49, 'CATEGORY.ADD.PENDING', 2, 0, 'In-Portal:Category', 'la_event_category.add.pending', 1)
	INSERT INTO Events VALUES (50, 'CATEGORY.ADD', 2, 0, 'In-Portal:Category', 'la_event_category.add', 1)
	INSERT INTO Events VALUES (51, 'CATEGORY.DELETE', 1, 0, 'In-Portal:Category', 'la_event_category_delete', 0)
	INSERT INTO Events VALUES (52, 'CATEGORY.DELETE', 2, 0, 'In-Portal:Category', 'la_event_category_delete', 1)
	INSERT INTO Events VALUES (53, 'CATEGORY.MODIFY', 1, 0, 'In-Portal:Category', 'la_event_category.modify', 0)
	INSERT INTO Events VALUES (54, 'CATEGORY.MODIFY', 2, 0, 'In-Portal:Category', 'la_event_category.modify', 1)
	INSERT INTO Events VALUES (56, 'CATEGORY.APPROVE', 1, 0, 'In-Portal:Category', 'la_event_category.approve', 0)
	INSERT INTO Events VALUES (57, 'CATEGORY.APPROVE', 2, 0, 'In-Portal:Category', 'la_event_category.approve', 1)
	INSERT INTO Events VALUES (58, 'CATEGORY.DENY', 1, 0, 'In-Portal:Category', 'la_event_category.deny', 0)
	INSERT INTO Events VALUES (59, 'CATEGORY.DENY', 2, 0, 'In-Portal:Category', 'la_event_category.deny', 1)
	INSERT INTO Events VALUES (60, 'USER.SUBSCRIBE', 1, 0, 'In-Portal:Users', 'la_event_user.subscribe', 0);
	INSERT INTO Events VALUES (61, 'USER.SUBSCRIBE', 2, 0, 'In-Portal:Users', 'la_event_user.subscribe', 1);
	INSERT INTO Events VALUES (62, 'USER.UNSUBSCRIBE', 1, 0, 'In-Portal:Users', 'la_event_user.unsubscribe', 0);
	INSERT INTO Events VALUES (63, 'USER.UNSUBSCRIBE', 2, 0, 'In-Portal:Users', 'la_event_user.unsubscribe', 1);
	INSERT INTO Events VALUES (64,'USER.SUGGEST', '1', '0', 'In-Portal:Users', 'la_event_user.suggest', '0');
	INSERT INTO Events VALUES (65,'USER.SUGGEST', '2', '0', 'In-Portal:Users', 'la_event_user.suggest', '1');

	INSERT INTO IdGenerator VALUES ('100');

	INSERT INTO ItemTypes VALUES (1, 'In-Portal', 'Category', 'Name', 'CreatedById', NULL, NULL, 'la_ItemTab_Categories', 1, 'admin/category/addcategory.php', 'clsCategory', 'Category');
	INSERT INTO ItemTypes VALUES (6, 'In-Portal', 'PortalUser', 'Login', 'PortalUserId', NULL, NULL, '', 0, '', 'clsPortalUser', 'User');

	INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '1.0.10', 1, 0, '', 0, '1054738405');

	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.VIEW', 'lu_PermName_Category.View_desc', 'lu_PermName_Category.View_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.ADD', 'lu_PermName_Category.Add_desc', 'lu_PermName_Category.Add_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.DELETE', 'lu_PermName_Category.Delete_desc', 'lu_PermName_Category.Delete_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.ADD.PENDING', 'lu_PermName_Category.AddPending_desc', 'lu_PermName_Category.AddPending_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.MODIFY', 'lu_PermName_Category.Modify_desc', 'lu_PermName_Category.Modify_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('ADMIN', 'lu_PermName_Admin_desc', 'lu_PermName_Admin_error', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('LOGIN', 'lu_PermName_Login_desc', 'lu_PermName_Admin_error', 'Front');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('DEBUG.ITEM', 'lu_PermName_Debug.Item_desc', '', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('DEBUG.LIST', 'lu_PermName_Debug.List_desc', '', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('DEBUG.INFO', 'lu_PermName_Debug.Info_desc', '', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('PROFILE.MODIFY', 'lu_PermName_Profile.Modify_desc', '', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('SHOWLANG', 'lu_PermName_ShowLang_desc', '', 'Admin');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('FAVORITES', 'lu_PermName_favorites_desc', 'lu_PermName_favorites_error', 'In-Portal');
	INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('SYSTEM_ACCESS.READONLY', 'la_PermName_SystemAccess.ReadOnly_desc', 'la_PermName_SystemAccess.ReadOnly_error', 'Admin');

	INSERT INTO PortalGroup VALUES (13, 'Member', '', '1054738682', 0, 0, 1, 13);
	INSERT INTO PortalGroup VALUES (12, 'Subscribers', '', '1054738670', 0, 0, 1, 12);
	INSERT INTO PortalGroup VALUES (14, 'Guest', 'Guest User', '0', 1, 0, 1, 14);
	INSERT INTO PortalGroup VALUES (11, 'admin', '', '1054738405', 0, 0, 1, 11);

	INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('LOGIN', 13, 1, 1, 0);
	INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('LOGIN', 11, 1, 1, 0);
	INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('LOGIN', 12, 1, 1, 0);
	INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('ADMIN', 11, 1, 1, 0);

	INSERT INTO SearchConfig VALUES ('Category', 'NewItem', 0, 1, 'lu_fielddesc_category_newitem', 'lu_field_newitem', 'In-Portal', 'la_Text_Category', 18, 80, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'PopItem', 0, 1, 'lu_fielddesc_category_popitem', 'lu_field_popitem', 'In-Portal', 'la_Text_Category', 19, 81, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'HotItem', 0, 1, 'lu_fielddesc_category_hotitem', 'lu_field_hotitem', 'In-Portal', 'la_Text_Category', 17, 79, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'MetaDescription', 0, 1, 'lu_fielddesc_category_metadescription', 'lu_field_metadescription', 'In-Portal', 'la_Text_Category', 16, 78, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'ParentPath', 0, 1, 'lu_fielddesc_category_parentpath', 'lu_field_parentpath', 'In-Portal', 'la_Text_Category', 15, 77, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'ResourceId', 0, 1, 'lu_fielddesc_category_resourceid', 'lu_field_resourceid', 'In-Portal', 'la_Text_Category', 14, 76, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'CreatedById', 0, 1, 'lu_fielddesc_category_createdbyid', 'lu_field_createdbyid', 'In-Portal', 'la_Text_Category', 13, 75, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'CachedNavbar', 0, 1, 'lu_fielddesc_category_cachednavbar', 'lu_field_cachednavbar', 'In-Portal', 'la_Text_Category', 12, 74, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'CachedDescendantCatsQty', 0, 1, 'lu_fielddesc_category_cacheddescendantcatsqty', 'lu_field_cacheddescendantcatsqty', 'In-Portal', 'la_Text_Category', 11, 73, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'MetaKeywords', 0, 1, 'lu_fielddesc_category_metakeywords', 'lu_field_metakeywords', 'In-Portal', 'la_Text_Category', 10, 72, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'Priority', 0, 1, 'lu_fielddesc_category_priority', 'lu_field_priority', 'In-Portal', 'la_Text_Category', 9, 71, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'Status', 0, 1, 'lu_fielddesc_category_status', 'lu_field_status', 'In-Portal', 'la_Text_Category', 7, 69, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'EditorsPick', 0, 1, 'lu_fielddesc_category_editorspick', 'lu_field_editorspick', 'In-Portal', 'la_Text_Category', 6, 68, 0, 'boolean', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'CreatedOn', 0, 1, 'lu_fielddesc_category_createdon', 'lu_field_createdon', 'In-Portal', 'la_Text_Category', 5, 67, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'Description', 1, 1, 'lu_fielddesc_category_description', 'lu_field_description', 'In-Portal', 'la_Text_Category', 4, 66, 2, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'Name', 1, 1, 'lu_fielddesc_category_name', 'lu_field_name', 'In-Portal', 'la_Text_Category', 3, 65, 2, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'ParentId', 0, 1, 'lu_fielddesc_category_parentid', 'lu_field_parentid', 'In-Portal', 'la_Text_Category', 2, 64, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'CategoryId', 0, 1, 'lu_fielddesc_category_categoryid', 'lu_field_categoryid', 'In-Portal', 'la_Text_Category', 0, 62, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'Modified', 0, 1, 'lu_fielddesc_category_modified', 'lu_field_modified', 'In-Portal', 'la_Text_Category', 20, 82, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('Category', 'ModifiedById', 0, 1, 'lu_fielddesc_category_modifiedbyid', 'lu_field_modifiedbyid', 'In-Portal', 'la_Text_Category', 21, 83, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'PortalUserId', 0, 0, 'lu_fielddesc_user_portaluserid', 'lu_field_portaluserid', 'In-Portal', 'la_text_user', 0, 173, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Login', 0, 0, 'lu_fielddesc_user_login', 'lu_field_login', 'In-Portal', 'la_text_user', 1, 174, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Password', 0, 0, 'lu_fielddesc_user_password', 'lu_field_password', 'In-Portal', 'la_text_user', 2, 175, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'tz', 0, 0, 'lu_fielddesc_user_tz', 'lu_field_tz', 'In-Portal', 'la_text_user', 17, 190, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'dob', 0, 0, 'lu_fielddesc_user_dob', 'lu_field_dob', 'In-Portal', 'la_text_user', 16, 189, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Modified', 0, 0, 'lu_fielddesc_user_modified', 'lu_field_modified', 'In-Portal', 'la_text_user', 15, 188, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Status', 0, 0, 'lu_fielddesc_user_status', 'lu_field_status', 'In-Portal', 'la_text_user', 14, 187, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'ResourceId', 0, 0, 'lu_fielddesc_user_resourceid', 'lu_field_resourceid', 'In-Portal', 'la_text_user', 13, 186, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Country', 0, 0, 'lu_fielddesc_user_country', 'lu_field_country', 'In-Portal', 'la_text_user', 12, 185, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Zip', 0, 0, 'lu_fielddesc_user_zip', 'lu_field_zip', 'In-Portal', 'la_text_user', 11, 184, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'State', 0, 0, 'lu_fielddesc_user_state', 'lu_field_state', 'In-Portal', 'la_text_user', 10, 183, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'City', 0, 0, 'lu_fielddesc_user_city', 'lu_field_city', 'In-Portal', 'la_text_user', 9, 182, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Street', 0, 0, 'lu_fielddesc_user_street', 'lu_field_street', 'In-Portal', 'la_text_user', 8, 181, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Phone', 0, 0, 'lu_fielddesc_user_phone', 'lu_field_phone', 'In-Portal', 'la_text_user', 7, 180, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'CreatedOn', 0, 0, 'lu_fielddesc_user_createdon', 'lu_field_createdon', 'In-Portal', 'la_text_user', 6, 179, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'Email', 0, 0, 'lu_fielddesc_user_email', 'lu_field_email', 'In-Portal', 'la_text_user', 5, 178, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'LastName', 0, 0, 'lu_fielddesc_user_lastname', 'lu_field_lastname', 'In-Portal', 'la_text_user', 4, 177, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);
	INSERT INTO SearchConfig VALUES ('PortalUser', 'FirstName', 0, 0, 'lu_fielddesc_user_firstname', 'lu_field_firstname', 'In-Portal', 'la_text_user', 3, 176, 0, 'text', NULL, NULL, NULL, NULL, NULL, NULL, 0);

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

	Property changes on: trunk/admin/install/inportal_data.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.14
	\ No newline at end of property
	+1.15
	\ 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