in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Fri, Jul 18, 7:11 AM

in-portal
View Options

	Index: trunk/kernel/units/general/cat_dbitem.php
	===================================================================
	--- trunk/kernel/units/general/cat_dbitem.php (revision 3616)
	+++ trunk/kernel/units/general/cat_dbitem.php (revision 3617)
	@@ -1,367 +1,360 @@
	<?php

	class kCatDBItem extends kDBItem {

	var $CustomFields = Array();

	/**
	* Category path, needed for import
	*
	* @var Array
	*/
	var $CategoryPath = Array();

	/**
	* Use automatic filename generation
	*
	* @var bool
	*/
	var $useFilenames = true;

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

	$item_type = $this->Application->getUnitOption($this->Prefix, 'ItemType');
	$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = '.$item_type;
	$this->CustomFields = $this->Conn->GetCol($sql, 'FieldName');
	}

	function Create($force_id=false, $system_create=false)
	{
	if (!$this->Validate()) return false;

	$this->SetDBField('ResourceId', $this->Application->NextResourceId());
	$this->SetDBField('Modified', adodb_mktime() );
	$this->SetDBField('CreatedById', $this->Application->GetVar('u_id'));

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	$ret = parent::Create();
	if($ret)
	{
	if ( kTempTablesHandler::IsTempTable($this->TableName) ) {
	$table = kTempTablesHandler::GetTempName(TABLE_PREFIX.'CategoryItems');
	}
	else {
	$table = TABLE_PREFIX.'CategoryItems';
	}
	$cat_id = $this->Application->GetVar('m_cat_id');
	$query = 'INSERT INTO '.$table.' (CategoryId,ItemResourceId,PrimaryCat)
	VALUES ('.$cat_id.','.$this->GetField('ResourceId').',1)';
	$this->Conn->Query($query);
	}
	return $ret;
	}

	function Update($id=null, $system_update=false)
	{
	$this->VirtualFields['ResourceId'] = true;
	$this->SetDBField('Modified', adodb_mktime() );
	$this->SetDBField('ModifiedById', $this->Application->GetVar('u_id'));

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	return parent::Update($id, $system_update);
	}

	function checkFilename()
	{
	if( !$this->GetDBField('AutomaticFilename') )
	{
	$filename = $this->GetDBField('Filename');
	$this->SetDBField('Filename', $this->stripDisallowed($filename) );
	}
	}

	function Copy($cat_id=null)
	{
	if (!isset($cat_id)) $cat_id = $this->Application->GetVar('m_cat_id');
	$this->NameCopy($cat_id);
	return $this->Create($cat_id);
	}

	function NameCopy($master=null, $foreign_key=null)
	{
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (!$title_field) return;

	$new_name = $this->GetDBField($title_field);
	$cat_id = $this->Application->GetVar('m_cat_id');
	$original_checked = false;
	do {
	if ( preg_match('/Copy ([0-9]) of (.*)/', $new_name, $regs) ) {
	$new_name = 'Copy '.( (int)$regs[1] + 1 ).' of '.$regs[2];
	}
	elseif ($original_checked) {
	$new_name = 'Copy of '.$new_name;
	}
	$query = 'SELECT '.$title_field.' FROM '.$this->TableName.'
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ON
	('.TABLE_PREFIX.'CategoryItems.ItemResourceId = '.$this->TableName.'.ResourceId)
	WHERE ('.TABLE_PREFIX.'CategoryItems.CategoryId = '.$cat_id.') AND '.
	$title_field.' = '.$this->Conn->qstr($new_name);
	$res = $this->Conn->GetOne($query);
	$original_checked = true;
	} while ($res !== false);
	$this->SetDBField($title_field, $new_name);
	}

	function MoveToCat($cat_id=null)
	{
	// $this->NameCopy();
	$cat_id = $this->Application->GetVar('m_cat_id');
	// check if the product already exists in destination cat
	$query = 'SELECT PrimaryCat FROM '.TABLE_PREFIX.'CategoryItems
	WHERE CategoryId = '.$cat_id.' AND ItemResourceId = '.$this->GetDBField('ResourceId');
	// if it's not found is_primary will be FALSE, if it's found but not primary it will be int 0
	$is_primary = $this->Conn->GetOne($query);
	$exists = $is_primary !== false;

	if ($exists) { // if the Product already exists in destination category
	if ($is_primary) return; // do nothing when we paste to primary
	// if it's not primary - delete it from destination category,
	// as we will move it from current primary below
	$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems
	WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND CategoryId = '.$cat_id;
	$this->Conn->Query($query);

	}
	$query = 'UPDATE '.TABLE_PREFIX.'CategoryItems SET CategoryId = '.$cat_id.
	' WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND PrimaryCat = 1';
	$this->Conn->Query($query);
	$this->Update();
	}

	// We need to delete CategoryItems record when deleting product
	function Delete($id=null)
	{
	if( isset($id) ) {
	$this->setID($id);
	}
	$this->Load($this->GetID());

	$ret = parent::Delete();
	if ($ret) {
	$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE ItemResourceId = '.$this->GetDBField('ResourceId');
	$this->Conn->Query($query);
	}

	return $ret;
	}

	/**
	* Deletes item from categories
	*
	* @param Array $delete_category_ids
	* @author Alex
	*/
	function DeleteFromCategories($delete_category_ids)
	{
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField'); // because item was loaded before by ResourceId

	$ci_table = $this->Application->getUnitOption('ci', 'TableName');
	$resource_id = $this->GetDBField('ResourceId');

	$item_cats_sql = 'SELECT CategoryId FROM %s WHERE ItemResourceId = %s';
	$delete_category_items_sql = 'DELETE FROM %s WHERE ItemResourceId = %s AND CategoryId IN (%s)';

	$category_ids = $this->Conn->GetCol( sprintf($item_cats_sql, $ci_table, $resource_id) );
	$cats_left = array_diff($category_ids, $delete_category_ids);
	if(!$cats_left)
	{
	$sql = 'SELECT %s FROM %s WHERE ResourceId = %s';
	$ids = $this->Conn->GetCol( sprintf($sql, $id_field, $this->TableName, $resource_id) );

	$temp =& $this->Application->recallObject($this->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$temp->DeleteItems($this->Prefix, $this->Special, $ids);
	}
	else
	{
	$this->Conn->Query( sprintf($delete_category_items_sql, $ci_table, $resource_id, implode(',', $delete_category_ids) ) );

	$sql = 'SELECT CategoryId FROM %s WHERE PrimaryCat = 1 AND ItemResourceId = %s';
	$primary_cat_id = $this->Conn->GetCol( sprintf($sql, $ci_table, $resource_id) );
	if( count($primary_cat_id) == 0 )
	{
	$sql = 'UPDATE %s SET PrimaryCat = 1 WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $ci_table, reset($cats_left), $resource_id ) );
	}
	}
	}

	function SetCustomField($field, $value)
	{
	$cf_id = getArrayValue($this->CustomFields, $field);
	if(!$cf_id) return false;

	$data_table = TABLE_PREFIX.'CustomMetaData';

	$sql = 'SELECT CustomDataId FROM '.$data_table.' WHERE CustomFieldId = %s AND ResourceId = %s';
	$data_id = (int)$this->Conn->GetOne( sprintf($sql, $cf_id, $this->GetDBField('ResourceId') ) );

	$lang_id = $this->Application->GetVar('lang.current_id');

	$sql = 'REPLACE INTO '.$data_table.'(CustomDataId,ResourceId,CustomFieldId,Value,l'.$lang_id.'_Value) VALUES (%1$s,%2$s,%3$s,%4$s,%4$s)';

	$this->Conn->Query( sprintf($sql, $data_id, $this->GetDBField('ResourceId'), $cf_id, $this->Conn->qstr($value) ) );
	}

	/**
	* replace not allowed symbols with "_" chars + remove duplicate "_" chars in result
	*
	* @param string $string
	* @return string
	*/
	function stripDisallowed($string)
	{
	$not_allowed = Array( ' ', '\\', '/', ':', '*', '?', '"', '<', '>', '\|', '`',
	'~', '!', '@', '#', '$', '%', '^', '&', '(', ')', '~',
	'+', '=', '-', '{', '}', ']', '[', "'", ';', '.', ',');

	$string = str_replace($not_allowed, '_', $string);
	$string = preg_replace('/(_+)/', '_', $string);
	$string = $this->checkAutoFilename($string);

	return $string;
	}

	function checkAutoFilename($filename)
	{
	if(!$filename) return $filename;

	$item_id = !$this->GetID() ? 0 : $this->GetID();

	// check temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_temp_ids = $this->Conn->GetCol($sql_temp);

	// check live table
	$sql_live = 'SELECT '.$this->IDField.' FROM '.kTempTablesHandler::GetLiveName($this->TableName).' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_live_ids = $this->Conn->GetCol($sql_live);

	$found_item_ids = array_unique( array_merge($found_temp_ids, $found_live_ids) );

	$has_page = preg_match('/(.)_([\d]+)([a-z])$/', $filename, $rets);

	$duplicates_found = (count($found_item_ids) > 1) \|\| ($found_item_ids && $found_item_ids[0] != $item_id);
	if ($duplicates_found \|\| $has_page) // other category has same filename as ours OR we have filename, that ends with _number
	{
	$append = $duplicates_found ? '_a' : '';
	if($has_page)
	{
	$filename = $rets[1].'_'.$rets[2];
	$append = $rets[3] ? $rets[3] : '_a';
	}

	// check live & temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	$sql_live = 'SELECT '.$this->IDField.' FROM '.kTempTablesHandler::GetLiveName($this->TableName).' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	while ( $this->Conn->GetOne( sprintf($sql_temp, $this->Conn->qstr($filename.$append)) ) > 0 \|\|
	$this->Conn->GetOne( sprintf($sql_live, $this->Conn->qstr($filename.$append)) ) > 0 )
	{
	if (substr($append, -1) == 'z') $append .= 'a';
	$append = substr($append, 0, strlen($append) - 1) . chr( ord( substr($append, -1) ) + 1 );
	}

	return $filename.$append;
	}

	return $filename;
	}

	/**
	* Generate item's filename based on it's title field value
	*
	* @return string
	*/
	function generateFilename()
	{
	if ( !$this->GetDBField('AutomaticFilename') && $this->GetDBField('Filename') ) return false;

	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	$name = $this->stripDisallowed( $this->GetDBField($title_field) );

	if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
	}

	/**
	* Check if value is set for required field
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateRequired($field, $params)
	{
	$res = true;
	$error_field = isset($params['error_field']) ? $params['error_field'] : $field;
	if ( getArrayValue($params,'required') )
	{
	- /*if (getArrayValue($params, 'formatter') == 'kUploadFormatter')
	- {
	- $value = $this->GetDBField($field);
	- $res = is_array($value) && $value['size'] ? true : false;
	- }
	- else {*/
	- $res = ( (string) $this->FieldValues[$field] != '');
	-// }
	+ $res = ( (string) $this->FieldValues[$field] != '');
	}
	if (!$res) $this->FieldErrors[$error_field]['pseudo'] = 'required';
	return $res;
	}

	/**
	* Adds item to other category
	*
	* @param int $category_id
	* @param bool $is_primary
	*/
	function assignToCategory($category_id, $is_primary = false)
	{
	$check_sql = ' SELECT CategoryId
	FROM '.TABLE_PREFIX.'CategoryItems
	WHERE (ItemResourceId = '.$this->GetDBField('ResourceId').') AND (PrimaryCat = 1)';
	$primary_category_id = $this->Conn->GetOne($check_sql);
	if (!$primary_category_id) $is_primary = true;

	if ($primary_category_id == $category_id) return ;

	$sql = 'INSERT INTO '.TABLE_PREFIX.'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES (%s,%s,%s)';
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId'), $is_primary ? 1 : 0) );
	}

	/**
	* Removes item from category specified
	*
	* @param int $category_id
	*/
	function removeFromCategory($category_id)
	{
	$sql = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId')) );
	}

	/**
	* Returns list of columns, that could exist in imported file
	*
	* @return Array
	*/
	function getPossibleExportColumns()
	{
	static $columns = null;
	if (!is_array($columns)) {
	$columns = array_merge($this->Fields['AvailableColumns']['options'], $this->Fields['ExportColumns']['options']);
	}
	return $columns;
	}
	}

	?>
	\ No newline at end of file

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

	//KERNEL4 STARTUP - FOR ACTIONS HANDLING

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

	$start = k4getmicrotime();

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

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

	//KERNEL4 END

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

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

	require_login();

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

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

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

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

	//admin only util

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

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


	$application->InitParser();

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

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


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

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

	//Set Environment Variable

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

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

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

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

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

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

	END;

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

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

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

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

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

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

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

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

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

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

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

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

	$TotalItemCount += $objCatList->QueryItemCount;

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

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

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

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


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


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

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

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

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

	Property changes on: trunk/admin/browse.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.29
	\ No newline at end of property
	+1.30
	\ No newline at end of property
	Index: trunk/core/units/general/cat_dbitem.php
	===================================================================
	--- trunk/core/units/general/cat_dbitem.php (revision 3616)
	+++ trunk/core/units/general/cat_dbitem.php (revision 3617)
	@@ -1,367 +1,360 @@
	<?php

	class kCatDBItem extends kDBItem {

	var $CustomFields = Array();

	/**
	* Category path, needed for import
	*
	* @var Array
	*/
	var $CategoryPath = Array();

	/**
	* Use automatic filename generation
	*
	* @var bool
	*/
	var $useFilenames = true;

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

	$item_type = $this->Application->getUnitOption($this->Prefix, 'ItemType');
	$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = '.$item_type;
	$this->CustomFields = $this->Conn->GetCol($sql, 'FieldName');
	}

	function Create($force_id=false, $system_create=false)
	{
	if (!$this->Validate()) return false;

	$this->SetDBField('ResourceId', $this->Application->NextResourceId());
	$this->SetDBField('Modified', adodb_mktime() );
	$this->SetDBField('CreatedById', $this->Application->GetVar('u_id'));

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	$ret = parent::Create();
	if($ret)
	{
	if ( kTempTablesHandler::IsTempTable($this->TableName) ) {
	$table = kTempTablesHandler::GetTempName(TABLE_PREFIX.'CategoryItems');
	}
	else {
	$table = TABLE_PREFIX.'CategoryItems';
	}
	$cat_id = $this->Application->GetVar('m_cat_id');
	$query = 'INSERT INTO '.$table.' (CategoryId,ItemResourceId,PrimaryCat)
	VALUES ('.$cat_id.','.$this->GetField('ResourceId').',1)';
	$this->Conn->Query($query);
	}
	return $ret;
	}

	function Update($id=null, $system_update=false)
	{
	$this->VirtualFields['ResourceId'] = true;
	$this->SetDBField('Modified', adodb_mktime() );
	$this->SetDBField('ModifiedById', $this->Application->GetVar('u_id'));

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	return parent::Update($id, $system_update);
	}

	function checkFilename()
	{
	if( !$this->GetDBField('AutomaticFilename') )
	{
	$filename = $this->GetDBField('Filename');
	$this->SetDBField('Filename', $this->stripDisallowed($filename) );
	}
	}

	function Copy($cat_id=null)
	{
	if (!isset($cat_id)) $cat_id = $this->Application->GetVar('m_cat_id');
	$this->NameCopy($cat_id);
	return $this->Create($cat_id);
	}

	function NameCopy($master=null, $foreign_key=null)
	{
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (!$title_field) return;

	$new_name = $this->GetDBField($title_field);
	$cat_id = $this->Application->GetVar('m_cat_id');
	$original_checked = false;
	do {
	if ( preg_match('/Copy ([0-9]) of (.*)/', $new_name, $regs) ) {
	$new_name = 'Copy '.( (int)$regs[1] + 1 ).' of '.$regs[2];
	}
	elseif ($original_checked) {
	$new_name = 'Copy of '.$new_name;
	}
	$query = 'SELECT '.$title_field.' FROM '.$this->TableName.'
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ON
	('.TABLE_PREFIX.'CategoryItems.ItemResourceId = '.$this->TableName.'.ResourceId)
	WHERE ('.TABLE_PREFIX.'CategoryItems.CategoryId = '.$cat_id.') AND '.
	$title_field.' = '.$this->Conn->qstr($new_name);
	$res = $this->Conn->GetOne($query);
	$original_checked = true;
	} while ($res !== false);
	$this->SetDBField($title_field, $new_name);
	}

	function MoveToCat($cat_id=null)
	{
	// $this->NameCopy();
	$cat_id = $this->Application->GetVar('m_cat_id');
	// check if the product already exists in destination cat
	$query = 'SELECT PrimaryCat FROM '.TABLE_PREFIX.'CategoryItems
	WHERE CategoryId = '.$cat_id.' AND ItemResourceId = '.$this->GetDBField('ResourceId');
	// if it's not found is_primary will be FALSE, if it's found but not primary it will be int 0
	$is_primary = $this->Conn->GetOne($query);
	$exists = $is_primary !== false;

	if ($exists) { // if the Product already exists in destination category
	if ($is_primary) return; // do nothing when we paste to primary
	// if it's not primary - delete it from destination category,
	// as we will move it from current primary below
	$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems
	WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND CategoryId = '.$cat_id;
	$this->Conn->Query($query);

	}
	$query = 'UPDATE '.TABLE_PREFIX.'CategoryItems SET CategoryId = '.$cat_id.
	' WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND PrimaryCat = 1';
	$this->Conn->Query($query);
	$this->Update();
	}

	// We need to delete CategoryItems record when deleting product
	function Delete($id=null)
	{
	if( isset($id) ) {
	$this->setID($id);
	}
	$this->Load($this->GetID());

	$ret = parent::Delete();
	if ($ret) {
	$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE ItemResourceId = '.$this->GetDBField('ResourceId');
	$this->Conn->Query($query);
	}

	return $ret;
	}

	/**
	* Deletes item from categories
	*
	* @param Array $delete_category_ids
	* @author Alex
	*/
	function DeleteFromCategories($delete_category_ids)
	{
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField'); // because item was loaded before by ResourceId

	$ci_table = $this->Application->getUnitOption('ci', 'TableName');
	$resource_id = $this->GetDBField('ResourceId');

	$item_cats_sql = 'SELECT CategoryId FROM %s WHERE ItemResourceId = %s';
	$delete_category_items_sql = 'DELETE FROM %s WHERE ItemResourceId = %s AND CategoryId IN (%s)';

	$category_ids = $this->Conn->GetCol( sprintf($item_cats_sql, $ci_table, $resource_id) );
	$cats_left = array_diff($category_ids, $delete_category_ids);
	if(!$cats_left)
	{
	$sql = 'SELECT %s FROM %s WHERE ResourceId = %s';
	$ids = $this->Conn->GetCol( sprintf($sql, $id_field, $this->TableName, $resource_id) );

	$temp =& $this->Application->recallObject($this->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$temp->DeleteItems($this->Prefix, $this->Special, $ids);
	}
	else
	{
	$this->Conn->Query( sprintf($delete_category_items_sql, $ci_table, $resource_id, implode(',', $delete_category_ids) ) );

	$sql = 'SELECT CategoryId FROM %s WHERE PrimaryCat = 1 AND ItemResourceId = %s';
	$primary_cat_id = $this->Conn->GetCol( sprintf($sql, $ci_table, $resource_id) );
	if( count($primary_cat_id) == 0 )
	{
	$sql = 'UPDATE %s SET PrimaryCat = 1 WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $ci_table, reset($cats_left), $resource_id ) );
	}
	}
	}

	function SetCustomField($field, $value)
	{
	$cf_id = getArrayValue($this->CustomFields, $field);
	if(!$cf_id) return false;

	$data_table = TABLE_PREFIX.'CustomMetaData';

	$sql = 'SELECT CustomDataId FROM '.$data_table.' WHERE CustomFieldId = %s AND ResourceId = %s';
	$data_id = (int)$this->Conn->GetOne( sprintf($sql, $cf_id, $this->GetDBField('ResourceId') ) );

	$lang_id = $this->Application->GetVar('lang.current_id');

	$sql = 'REPLACE INTO '.$data_table.'(CustomDataId,ResourceId,CustomFieldId,Value,l'.$lang_id.'_Value) VALUES (%1$s,%2$s,%3$s,%4$s,%4$s)';

	$this->Conn->Query( sprintf($sql, $data_id, $this->GetDBField('ResourceId'), $cf_id, $this->Conn->qstr($value) ) );
	}

	/**
	* replace not allowed symbols with "_" chars + remove duplicate "_" chars in result
	*
	* @param string $string
	* @return string
	*/
	function stripDisallowed($string)
	{
	$not_allowed = Array( ' ', '\\', '/', ':', '*', '?', '"', '<', '>', '\|', '`',
	'~', '!', '@', '#', '$', '%', '^', '&', '(', ')', '~',
	'+', '=', '-', '{', '}', ']', '[', "'", ';', '.', ',');

	$string = str_replace($not_allowed, '_', $string);
	$string = preg_replace('/(_+)/', '_', $string);
	$string = $this->checkAutoFilename($string);

	return $string;
	}

	function checkAutoFilename($filename)
	{
	if(!$filename) return $filename;

	$item_id = !$this->GetID() ? 0 : $this->GetID();

	// check temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_temp_ids = $this->Conn->GetCol($sql_temp);

	// check live table
	$sql_live = 'SELECT '.$this->IDField.' FROM '.kTempTablesHandler::GetLiveName($this->TableName).' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_live_ids = $this->Conn->GetCol($sql_live);

	$found_item_ids = array_unique( array_merge($found_temp_ids, $found_live_ids) );

	$has_page = preg_match('/(.)_([\d]+)([a-z])$/', $filename, $rets);

	$duplicates_found = (count($found_item_ids) > 1) \|\| ($found_item_ids && $found_item_ids[0] != $item_id);
	if ($duplicates_found \|\| $has_page) // other category has same filename as ours OR we have filename, that ends with _number
	{
	$append = $duplicates_found ? '_a' : '';
	if($has_page)
	{
	$filename = $rets[1].'_'.$rets[2];
	$append = $rets[3] ? $rets[3] : '_a';
	}

	// check live & temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	$sql_live = 'SELECT '.$this->IDField.' FROM '.kTempTablesHandler::GetLiveName($this->TableName).' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	while ( $this->Conn->GetOne( sprintf($sql_temp, $this->Conn->qstr($filename.$append)) ) > 0 \|\|
	$this->Conn->GetOne( sprintf($sql_live, $this->Conn->qstr($filename.$append)) ) > 0 )
	{
	if (substr($append, -1) == 'z') $append .= 'a';
	$append = substr($append, 0, strlen($append) - 1) . chr( ord( substr($append, -1) ) + 1 );
	}

	return $filename.$append;
	}

	return $filename;
	}

	/**
	* Generate item's filename based on it's title field value
	*
	* @return string
	*/
	function generateFilename()
	{
	if ( !$this->GetDBField('AutomaticFilename') && $this->GetDBField('Filename') ) return false;

	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	$name = $this->stripDisallowed( $this->GetDBField($title_field) );

	if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
	}

	/**
	* Check if value is set for required field
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateRequired($field, $params)
	{
	$res = true;
	$error_field = isset($params['error_field']) ? $params['error_field'] : $field;
	if ( getArrayValue($params,'required') )
	{
	- /*if (getArrayValue($params, 'formatter') == 'kUploadFormatter')
	- {
	- $value = $this->GetDBField($field);
	- $res = is_array($value) && $value['size'] ? true : false;
	- }
	- else {*/
	- $res = ( (string) $this->FieldValues[$field] != '');
	-// }
	+ $res = ( (string) $this->FieldValues[$field] != '');
	}
	if (!$res) $this->FieldErrors[$error_field]['pseudo'] = 'required';
	return $res;
	}

	/**
	* Adds item to other category
	*
	* @param int $category_id
	* @param bool $is_primary
	*/
	function assignToCategory($category_id, $is_primary = false)
	{
	$check_sql = ' SELECT CategoryId
	FROM '.TABLE_PREFIX.'CategoryItems
	WHERE (ItemResourceId = '.$this->GetDBField('ResourceId').') AND (PrimaryCat = 1)';
	$primary_category_id = $this->Conn->GetOne($check_sql);
	if (!$primary_category_id) $is_primary = true;

	if ($primary_category_id == $category_id) return ;

	$sql = 'INSERT INTO '.TABLE_PREFIX.'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES (%s,%s,%s)';
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId'), $is_primary ? 1 : 0) );
	}

	/**
	* Removes item from category specified
	*
	* @param int $category_id
	*/
	function removeFromCategory($category_id)
	{
	$sql = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId')) );
	}

	/**
	* Returns list of columns, that could exist in imported file
	*
	* @return Array
	*/
	function getPossibleExportColumns()
	{
	static $columns = null;
	if (!is_array($columns)) {
	$columns = array_merge($this->Fields['AvailableColumns']['options'], $this->Fields['ExportColumns']['options']);
	}
	return $columns;
	}
	}

	?>
	\ No newline at end of file

	Property changes on: trunk/core/units/general/cat_dbitem.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.21
	\ No newline at end of property
	+1.22
	\ 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