in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Feb 2, 9:58 AM

in-portal
View Options

	Index: trunk/kernel/include/item.php
	===================================================================
	--- trunk/kernel/include/item.php (revision 1066)
	+++ trunk/kernel/include/item.php (revision 1067)
	@@ -1,1043 +1,1048 @@
	<?php
	require_once($pathtoroot."kernel/include/itemreview.php");
	require_once($pathtoroot."kernel/include/itemrating.php");

	class clsItem extends clsParsedItem
	{
	var $type;
	var $Reviews;
	var $Related;
	var $Images;
	var $PrimaryCat;
	var $IsNew = FALSE;
	var $IsHot = FALSE;
	var $IsPop = FALSE;
	var $Keywords;
	var $OpenTagVar;
	var $CloseTagVar;
	var $AdminParser;
	var $CustomFields;
	var $FieldClass;
	var $CustomLoaded=0;
	var $ReviewSortOrder;
	var $ReviewPerPageVar;

	function clsItem($FullItem=FALSE)
	{
	$this->clsParsedItem();
	if($FullItem==TRUE)
	{
	$this->Reviews = new clsItemReviewList();
	$this->Related = new clsRelationshipList();
	}
	$this->Images = new clsImageList();
	$this->CustomFields = array();
	$this->FieldClass = new clsCustomFieldList();
	}

	function ClearCacheData()
	{
	DeleteModuleTagCache('kernel');
	DeleteModuleTagCache('inlink');
	DeleteModuleTagCache('innews');
	DeleteModuleTagCache('inbulletin');
	}

	/* item reviews */
	function &GetItemReviews($Page=1)
	{
	$res_id = $this->Get("ResourceId");
	$this->Reviews->itemID=$res_id;
	$this->Reviews->PerPageVar = $this->ReviewPerPageVar;
	$this->Reviews->Page = $Page;
	$this->Reviews->GetReviewList("Status=1",$this->ReviewSortOrder);
	return $this->Reviews;
	}

	function ReviewCount($TodayOnly=FALSE)
	{

	if(is_numeric($this->Get("CachedReviewsQty")) && !$TodayOnly)
	return (int)$this->Get("CachedReviewsQty");

	$this->Reviews->itemID=$this->Get("ResourceId");
	return (int)$this->Reviews->GetItemReviewCount($TodayOnly);
	}

	function ReviewsLoaded()
	{
	if($this->Reviews->itemID==$this->Get("ResourceId"))
	{
	return $this->Reviews->ItemCount();
	}
	else
	return 0;
	}

	function &AddReview($createdBy,$reviewText,$isPending,$ip=NULL,$ForceIP=0, $Module="", $CreatedOn = 0)
	{
	$this->Reviews->itemID=$this->Get("ResourceId");
	if($ip == NULL)
	$ip = $_SERVER["REMOTE_ADDR"];

	if(!$CreatedOn)
	$CreatedOn = mktime(0,0,0,adodb_date("m"),adodb_date("d"),adodb_date("Y"));
	$Status = 1;
	if($isPending)
	$Status = 2;

	$AutoModule = GetModuleByAction(); // determine module name by action
	if( $Module && ($AutoModule != $Module) ) $AutoModule = $Module;

	$r = $this->Reviews->AddReview($CreatedOn,$reviewText,$Status,$ip,0,$this->Get("ResourceId"),$this->type,$createdBy,0,$AutoModule);
	$this->Increment("CachedReviewsQty");
	return $r;
	}

	function ReviewIPExists($ip)
	{
	return ip_exists($ip,$this->Get("ResourceId"),$this->Reviews->SourceTable);
	}

	function DeleteReview($reviewID)
	{
	$r = $this->Reviews->GetReview($reviewID);
	if(is_object($r))
	{
	$r->Delete();
	$this->Decrement("CachedReviewsQty");
	}
	}

	function DeleteReviews()
	{
	$res_id = $this->Get("ResourceId");
	if($res_id)
	{
	$sql = "DELETE FROM ".GetTablePrefix()."ItemReview WHERE ItemId=$res_id";
	$this->adodbConnection->Execute($sql);
	unset($this->Reviews);
	$this->Reviews = new clsItemReviewList($res_id);
	}
	}

	/* item custom fields */

	function LoadCustomFields()
	{
	if(!$this->CustomLoaded && $this->Get("ResourceId")>0)
	{
	$this->FieldClass = new clsCustomFieldList();
	$this->FieldClass->Type = $this->type;
	$this->FieldClass->LoadFieldsAndValues($this->Get("ResourceId"));
	foreach($this->FieldClass->Items as $f)
	{
	$this->CustomFields[$f->Get("FieldName")] = $f->HasField('Value') ? $f->Get('Value') : '';
	}
	$this->CustomLoaded = 1;
	}
	}

	function SetCustomField($fieldname,$value)
	{
	// echo "Setting CF [<b>$fieldname</b>] = [$value]<br>";
	if(!$this->CustomLoaded)
	$this->LoadCustomFields();
	$this->CustomFields[$fieldname] = $value;
	}

	function SaveCustomFields()
	{
	//echo "Saving CFs<br>";
	if(!(int)$this->Get("ResourceId"))
	return TRUE;

	if(!$this->CustomLoaded)
	return TRUE;

	$data = new clsCustomDataList();
	$data->LoadResource($this->Get("ResourceId"));
	foreach($this->FieldClass->Items as $f)
	{
	$value = $this->CustomFields[$f->Get("FieldName")];
	$data->SetFieldValue($f->Get("CustomFieldId"),$this->Get("ResourceId"),$value);
	}
	$data->SaveData();
	unset($data);
	}

	function GetCustomFieldValue($fieldname,$default="")
	{
	if(!$this->CustomLoaded)
	$this->LoadCustomFields();
	$fieldname=strtolower($fieldname);
	foreach($this->CustomFields as $k=>$v)
	if(strtolower($k)==$fieldname)
	return $v;
	return $default;

	if(isset($this->CustomFields[$fieldname]))
	{
	$ret = $this->CustomFields[$fieldname];
	}
	elseif(isset($this->CustomFields[$fieldname=strtolower($fieldname)]))
	{
	$ret = $this->CustomFields[$fieldname];
	}
	else
	$ret = $default;
	return $ret;
	}


	function DeleteCustomData()
	{
	$cdata = new clsCustomDataList();
	$cdata->DeleteResource($this->Get("ResourceId"));
	}

	function Delete($RecordOnly=FALSE)
	{
	global $objFavorites;

	if($RecordOnly==FALSE)
	{
	$this->DeleteReviews();
	$this->DeleteRelations();
	$this->DeleteCustomData();
	if($this->NoResourceId==0)
	{
	if($this->UsingTempTable()==FALSE)
	{
	if(is_object($this->Images))
	$this->Images->DeleteResource($this->Get("ResourceId"));
	$objFavorites->DeleteItem($this->Get("ResourceId"));
	}
	}
	}
	parent::Delete();
	}

	/* item relationships */
	function GetRelatedItems()
	{
	global $objConfig;

	$where = "SourceId = ".$this->Get("ResourceId");
	$where .= " OR (TargetId=".$this->Get("ResourceId")." AND Type=1)";
	$orderBy = $objConfig->Get("Relation_Sortfield")." ".$objConfig->Get("Relation_Sortorder");
	$orderBy = trim($orderBy);
	$this->Related->Clear();
	$res = $this->Related->LoadRelated($where,$orderBy);
	return $res;
	}

	function &RelationObject()
	{
	return $this->Related;
	}

	function DeleteRelations()
	{
	$res_id = $this->Get("ResourceId");
	if($res_id)
	{
	$sql = "DELETE FROM ".GetTablePrefix()."Relationship WHERE SourceId=$res_id OR TargetId=$res_id";
	$this->adodbConnection->Execute($sql);
	unset($this->Reviews);
	$this->Related = new clsRelationshipList($res_id);
	}
	}


	/* keyword highlighting for searches */

	function HighlightField($field)
	{
	global $objConfig;

	if(/!strlen($OpenTag) \|\| !strlen($CloseTag) \|\|/ !is_array($this->Keywords))
	{
	//echo "Missing something<br>\n";
	return $this->Get($field);
	}

	if(strlen($this->OpenTagVar))
	$OpenTag = $objConfig->Get($this->OpenTagVar);
	if(strlen($this->CloseTagVar))
	$CloseTag = $objConfig->Get($this->CloseTagVar);

	$k = array_merge($this->Keywords["required"],$this->Keywords["normal"]);
	if(count($k))
	{
	$result = HighlightKeywords($k, $this->Get($field), $OpenTag, $CloseTag);
	}
	else
	{
	$result = $this->Get($field);
	//echo "No Keywords<br>\n";
	}
	return $result;
	}

	function HighlightText($text)
	{
	global $objConfig;

	if(strlen($this->OpenTagVar))
	$OpenTag = $objConfig->Get($this->OpenTagVar);
	if(strlen($this->CloseTagVar))
	$CloseTag = $objConfig->Get($this->CloseTagVar);

	if(!strlen($OpenTag) \|\| !strlen($CloseTag) \|\| !is_array($this->Keywords)) {
	return $text;
	}
	$k = array_merge($this->Keywords["required"],$this->Keywords["normal"]);
	if(count($k))
	{
	$result = HighlightKeywords($k,$text, $OpenTag, $CloseTag);
	}
	else
	$result = $text;

	return $result;
	}

	/* item status functions */

	function Is($name)
	{
	$var = "m_" . $name;
	return ( isset($this->$var) && $this->$var ) ? true : false;
	}

	function IsHotItem()
	{
	switch($this->Get("HotItem"))
	{
	case ALWAYS:
	return TRUE;
	break;
	case NEVER:
	return FALSE;
	break;
	case AUTO:
	return $this->IsHot;
	break;
	}
	}

	function SetHotItem()
	{
	$this->IsHot = FALSE;
	}

	function IsNewItem()
	{
	switch($this->Get("NewItem"))
	{
	case ALWAYS:
	return TRUE;
	break;
	case NEVER:
	return FALSE;
	break;
	case AUTO:
	return $this->IsNew;
	break;
	}
	}

	function SetNewItem()
	{
	$this->IsNew = FALSE;
	}

	function IsPopItem()
	{
	switch($this->Get("PopItem"))
	{
	case ALWAYS:
	return TRUE;
	break;
	case NEVER:
	return FALSE;
	break;
	case AUTO:
	return $this->IsPop;
	break;
	}
	}

	function SetPopItem()
	{
	$this->IsPop = FALSE;
	}

	function SetFromArray($data, $dirty = false)
	{
	parent::SetFromArray($data, $dirty);
	if(is_array($data))
	{
	if(array_key_exists("NewItem",$data))
	{
	$this->SetNewItem();
	}
	if(array_key_exists("HotItem",$data))
	{
	$this->SetHotItem();
	}
	if(array_key_exists("PopItem",$data))
	{
	$this->SetPopItem();
	}
	}
	}

	function Validate()
	{
	/* skeleton*/
	return true;
	}

	function LoadFromDatabase($Id, $IdField = null) // custom IdField by Alex)
	{
	/* skeleton */
	parent::LoadFromDatabase($Id, $IdField);
	}



	//Changes priority
	function MoveDown()
	{
	$this->Decrement("Priority");
	}

	function MoveUp()
	{
	$this->Increment("Priority");
	}

	function CheckPermission($permissionName)
	{
	//Check permission and if needs approval set approval
	global $objSession,$objCatList;

	$perm = $this->BasePermission;
	if(strlen($perm)>0)
	$perm .= ".";
	$perm .= $permissionName;

	//get an instance of the forum category
	$cat =& $objCatList->GetCategory($this->Get("CategoryId"));
	if(!is_object($cat))
	{
	return FALSE;
	}
	else
	{
	return ($cat->HasPermission($perm,$objSession->Get("GroupId")));
	}
	}

	function SubmitVote($voteRating, $voteNotes)
	{
	global $Errors;
	global $REMOTE_ADDR;

	if($this->rating_ip_exists($REMOTE_ADDR))
	{
	// $Errors->AddError("error.already_voted","","","",get_class($this),"SubmitVote");
	return false;
	}
	$vote = new clsItemRating(NULL);
	$vote->Set("ItemId",$this->UniqueId());
	$vote->Set("RatingValue",$voteRating);
	if(!$vote->Create())
	return false;

	$NumVotes = (int)$this->Get("CachedVotesQty");
	$CurrentRating = (int)$this->Get("CachedRating");

	$Rating = (($NumVotes * $CurrentRating) + $voteRating)/($NumVotes+1);
	$this->Set("CachedRating",$Rating);
	$this->Update();
	$this->Increment("CachedVotesQty");
	}

	function rating_ip_exists($ip)
	{
	$count = 0;
	$id = $this->Get("ResourceId");
	$sql = "SELECT count(*) as DupCount FROM ItemRating WHERE IPAddress='$ip' and ItemId=$id";
	$adodbConnection = &GetADODBConnection();
	$rs = $adodbConnection->Execute($sql);
	if($rs)
	{
	$count = $rs->fields["DupCount"];
	}
	return ($count>0);
	//return FALSE;
	}

	function PurgeRatings()
	{
	global $objConfig;

	$expired=time()-86400*$objConfig->Get("Timeout_Rating");
	$query="DELETE FROM ItemRating WHERE CreatedOn<$expired";
	$this->adodbConnection->Execute($query);
	}

	function GetThumbnailImage()
	{
	if($this->Images->NumItems()==0)
	$this->Images->GetResourceImages($this->Get("ResourceId"));
	return $this->Images->GetResourceThumbnail($this->Get("ResourceId"));
	}

	function GetImage($number)
	{
	return $this->Images->GetImageByResource($this->Get("ResourceId"),$number);
	}

	function GetImageByName($name)
	{
	if(!is_object($this->Images))
	$this->Images = new clsImageList();
	return $this->Images->GetImageByName($this->Get("ResourceId"),$name);
	}

	function &GetDefaultImage()
	{
	return $this->Images->GetDefaultImage($this->Get("ResourceId"));
	}
	+
	+ function &GetAvatarImage()
	+ {
	+ return $this->Images->GetAvatarImage($this->Get("ResourceId"));
	+ }

	function CreatePendingCopy()
	{
	$OrgId = $this->IdField();
	$this->Dirty();
	$this->Set("OrgId",$OrgId);
	$this->UnsetIdField();
	$this->Set("ResourceId",0);
	$this->Set("Status",-2);
	$this->Create();
	}

	function AddFavorite($PortalUserId=NULL)
	{
	global $objSession, $objFavorites;

	$res = FALSE;
	if($objSession->HasCatPermission("FAVORITES"))
	{
	if(!$PortalUserId)
	$PortalUserId = $objSession->Get("PortalUserId");
	if($PortalUserId==$objSession->Get("PortalUserId") \|\| $objSession->HasSystemPermission("ADMIN"))
	{
	$objFavorites->AddFavorite($PortalUserId,$this->Get("ResourceId"), $this->type);
	$res = TRUE;
	}
	}
	return $res;
	}

	function DeleteFavorite($PortalUserId=NULL)
	{
	global $objSession, $objFavorites;

	$res = FALSE;

	if($objSession->HasCatPermission("FAVORITES"))
	{
	if(!$PortalUserId)
	$PortalUserId = $objSession->Get("PortalUserId");
	//echo $PortalUserId." ".$objSession->Get("PortalUserId");
	if($PortalUserId==$objSession->Get("PortalUserId") \|\| $objSession->HasSystemPermission("ADMIN"))
	{
	$objFavorites->DeleteFavorite($PortalUserId,$this->Get("ResourceId"));
	$res = TRUE;
	}
	}
	return $res;
	}

	function IsFavorite($PortalUserId=NULL)
	{
	global $objSession, $objFavorites;

	$res = FALSE;


	if($objSession->HasCatPermission("FAVORITES"))
	{
	if(!$PortalUserId)
	$PortalUserId = $objSession->Get("PortalUserId");

	if($PortalUserId==$objSession->Get("PortalUserId") \|\| $objSession->HasSystemPermission("ADMIN"))
	{
	$i = $objFavorites->GetFavoriteObject($PortalUserId,$this->Get("ResourceId"));

	if(is_object($i))
	{
	$res = TRUE;
	}
	else
	$res = FALSE;
	}
	}

	return $res;
	}

	function CheckBanned()
	{
	global $objBanList;

	$objBanList->LoadItemRules($this->type);
	$found = FALSE;
	$MatchedRule = 0;
	foreach($objBanList->Items as $b)
	{
	$field = $b->Get("ItemField");
	if($this->FieldExists($field))
	{
	$ThisValue = strtolower($this->Get($field));
	$TestValue = strtolower($b->Get("ItemValue"));
	switch($b->Get("ItemVerb"))
	{
	case 0: /* any */
	$found = TRUE;
	break;
	case 1: /* is */
	if($ThisValue==$TestValue)
	$found = TRUE;
	break;
	case 2: /* is not */
	if($ThisValue != $TestValue)
	$found = TRUE;
	break;
	case 3: /* contains */
	if(strstr($ThisValue,$TestValue))
	$found = TRUE;
	break;
	case 4: /* not contains */
	if(!strstr($ThisValue,$TestValue))
	$found = TRUE;
	break;
	case 5: /* Greater Than */
	if($TestValue > $ThisValue)
	$found = TRUE;
	break;
	case 6: /* Less Than */
	if($TestValue < $ThisValue)
	$found = TRUE;
	break;
	case 7: /* exists */
	if(strlen($ThisValue)>0)
	$found = TRUE;
	break;
	case 8: /* unique */
	if($this->ValueExists($field,$ThisValue))
	$found = TRUE;
	break;
	}
	}
	if($found)
	{
	if($b->Get("RuleType")==0)
	{
	$MatchedRule = $b->Get("RuleId");
	}
	else
	{
	$MatchedRule = 0;
	}
	break;
	}
	}
	return $MatchedRule;
	}
	} /* clsItem */

	class clsCatItem extends clsItem
	{
	function clsCatItem($FullItem=FALSE)
	{
	$this->clsItem($FullItem);
	}

	function Delete($RecordOnly=FALSE)
	{
	global $objFavorites;

	parent::Delete($RecordOnly);
	if($RecordOnly==FALSE)
	{
	$this->RemoveFromAllCategories();
	}
	}
	/* category membership functions */

	function AssignPrimaryCategory($SourceTable)
	{
	$catid = 0;
	$sql = "SELECT * FROM $SourceTable WHERE ItemResourceId=".$this->Get("ResourceId")." LIMIT 1";
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	$catid = $rs->fields["CategoryId"];
	$this->SetPrimaryCategory($catid,$SourceTable);
	}
	return $catid;
	}

	function GetPrimaryCategory($SourceTable = "")
	{
	if(is_numeric($this->PrimaryCat))
	return $this->PrimaryCat;

	$this->PrimaryCat="";
	if( strlen($SourceTable) == 0 ) $SourceTable = GetTablePrefix()."CategoryItems";
	$res_id = $this->HasField('ResourceId') ? $this->Get('ResourceId') : 0;
	$sql = "SELECT * FROM $SourceTable WHERE ItemResourceId=".$res_id." AND PrimaryCat=1";
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	$this->PrimaryCat=$rs->fields["CategoryId"];
	return $this->PrimaryCat;
	}
	else
	{
	$this->AssignPrimaryCategory($SourceTable);
	return $this->PrimaryCat;
	}
	}

	function SetPrimaryCategory($CategoryId,$SourceTable = "")
	{
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	$rs = $this->adodbConnection->Execute('SELECT * FROM '.$SourceTable.' WHERE CategoryId='.$CategoryId.' AND ItemResourceId='.$this->Get("ResourceId"));
	$this->adodbConnection->Execute("UPDATE $SourceTable SET PrimaryCat=0 WHERE ItemResourceId=".$this->Get("ResourceId"));
	$this->adodbConnection->Execute("UPDATE $SourceTable SET PrimaryCat=1 WHERE CategoryId=$CategoryId AND ItemResourceId=".$this->Get("ResourceId"));

	$this->PrimaryCat=$CategoryId;
	}

	function CategoryMemberCount($SourceTable="")
	{
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	$sql = "SELECT count(*) as CatCount FROM $SourceTable WHERE ItemResourceId=".$this->Get("ResourceId");
	if($this->debuglevel)
	echo $sql."<br>\n";

	$rs = $this->adodbConnection->Execute($sql);
	$count = 0;
	if($rs && !$rs->EOF)
	$count = $rs->fields["CatCount"];
	return $count;
	}

	/**
	* Return comma separated CategoryId list,
	* where this item is member (will be shown there)
	*
	* @param string $SourceTable
	* @return string
	*/
	function CategoryMemberList($SourceTable="")
	{
	$cats = array();
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	$sql = "SELECT * FROM $SourceTable WHERE ItemResourceId=".$this->Get("ResourceId");

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

	$rs = $this->adodbConnection->Execute($sql);
	while($rs && !$rs->EOF)
	{
	$cats[] = $rs->fields["CategoryId"];
	$rs->MoveNext();
	}
	$catlist = implode(",",$cats);
	return $catlist;
	}

	function AddToCategory($CatId,$SourceTable="",$PrimaryValue=NULL)
	{
	global $objSession, $objCatList;

	if(!$SourceTable)
	$SourceTable = GetTablePrefix()."CategoryItems";

	if($this->type>0)
	{
	$Primary = 0;
	if(is_numeric($PrimaryValue))
	{
	$Primary = $PrimaryValue;
	if($Primary==1)
	$this->PrimaryCat = $CatId;
	}
	else
	{
	if(!is_numeric($this->GetPrimaryCategory()))
	{
	$Primary =1;
	$this->PrimaryCat = $CatId;
	}
	}

	// check if not exists

	$db =& $this->adodbConnection;
	$sql = sprintf('SELECT * FROM %s WHERE CategoryId = %s AND ItemResourceId = %s', $SourceTable, (int)$CatId, $this->Get("ResourceId"));
	$rs = $db->Execute($sql);

	if (is_object($rs)) {
	if($rs->RecordCount() == 0 )
	{
	$sql = "INSERT INTO $SourceTable (CategoryId,ItemResourceId, PrimaryCat) VALUES (".(int)$CatId.",'".$this->Get("ResourceId")."',$Primary)";
	if($this->debuglevel)
	echo $sql."<br>\n";
	$this->adodbConnection->Execute($sql);
	}
	}

	$c = $objCatList->GetCategory($CatId);
	}
	}

	function RemoveFromCategory($CatId,$SourceTable="",$Force=0)
	{
	if(!is_numeric($CatId)) return;
	global $objSession, $objCatList;
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	if($this->type>0)
	{
	$primary = $this->GetPrimaryCategory();
	if(($primary==$CatId && $this->CategoryMemberCount($SourceTable)>1) \|\| ($primary != $CatId) \|\| $Force)
	{
	$sql = "DELETE FROM $SourceTable WHERE CategoryId=$CatId AND ItemResourceId=".$this->Get("ResourceId");
	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo $sql."<br>\n";

	$this->adodbConnection->Execute($sql);
	$c = $objCatList->GetCategory($CatId);
	$c->ClearCacheData();
	}
	}
	}

	function MoveToCategory($OldCatId,$NewCatId,$SourceTable="")
	{
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	$sql = "UPDATE $SourceTable SET CategoryId=$NewCatId WHERE CategoryId=$OldCatId AND ItemResourceId=".$this->Get("ResourceId");
	if($this->debuglevel)
	echo $sql."<br>\n";

	$this->adodbConnection->Execute($sql);
	}

	function DeleteCategoryItems($CatId,$SourceTable = "")
	{
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	$CatCount = $this->CategoryMemberCount($SourceTable);
	if($CatCount>1)
	{
	$this->RemoveFromCategory($CatId,$SourceTable);
	$this->ClearCacheData();
	}
	else
	{
	$this->Delete();
	$sql = "DELETE FROM $SourceTable WHERE CategoryId=$CatId AND ItemResourceId=".$this->Get("ResourceId");
	if($this->debuglevel)
	echo $sql."<br>\n";

	$this->adodbConnection->Execute($sql);
	}
	}
	function RemoveFromAllCategories($SourceTable = "")
	{
	if(strlen($SourceTable)==0)
	$SourceTable = GetTablePrefix()."CategoryItems";

	if($this->type>0)
	{
	$sql = "SELECT * FROM $SourceTable WHERE ItemResourceId=".$this->Get("ResourceId");
	$rs = $this->adodbConnection->Execute($sql);
	while ($rs && !$rs->EOF)
	{
	$CategoryId = $rs->fields["CategoryId"];
	$rs->MoveNext();
	}
	$sql = "DELETE FROM $SourceTable WHERE ItemResourceId=".$this->Get("ResourceId");
	if($this->debuglevel)
	echo $sql."<br>\n";

	$this->adodbConnection->Execute($sql);
	}
	}

	function CopyToNewResource($TargetCat = NULL,$NameField="Name")
	{
	global $objSession;

	$CatList = $this->CategoryMemberList();

	$Cats = explode(",",$CatList);
	//echo "Target: $TargetCat<br>";
	$OldId = $this->Get("ResourceId");
	$this->UnsetIdField();
	$this->Dirty();
	if(!is_numeric($this->Get("OrgId")))
	$this->UnsetField("OrgId");
	$this->UnsetField("ResourceId");
	if(is_numeric($TargetCat) && strlen($NameField))
	{
	$OldName = $this->Get($NameField);
	if(substr($OldName,0,5)=="Copy ")
	{
	$parts = explode(" ",$OldName,4);
	if($parts[2]=="of" && is_numeric($parts[1]))
	{
	$Name = $parts[3];
	}
	else
	if($parts[1]=="of")
	{
	$Name = $parts[2]." ".$parts[3];
	}
	else
	$Name = $OldName;
	}
	else
	$Name = $OldName;
	$Names = CategoryItemNameCount($TargetCat,$this->tablename,$NameField,$Name);
	if(count($Names)>0)
	{
	$NameCount = count($Names);
	$found = FALSE;
	$NewName = "Copy of $Name";

	if(!in_array("Copy of $Name",$Names))
	{
	$found = TRUE;
	}
	else
	{
	for($x=2;$x<$NameCount+2;$x++)
	{

	$NewName = "Copy ".$x." of ".$Name;
	if(!in_array($NewName,$Names))
	{
	$found = TRUE;
	break;
	}

	}
	}
	if(!$found)
	{
	$NameCount++;
	$NewName = "Copy $NameCount of $Name";
	}
	$this->Set($NameField,$NewName);
	}
	}
	$this->Create();
	// copy relationships
	$NewId = $this->Get("ResourceId");
	$reldata = new clsRelationshipList($TargetCat,$this->IdField());
	$reldata->CopyToResource($OldId,$NewId);

	// copy reviews
	$rdata = new clsItemReviewList();
	$rdata->CopyToItemId($OldId,$NewId);
	unset($rdata);

	// copy custom fields
	$cdata = new clsCustomDataList();
	$cdata->CopyResource($OldId,$NewId);
	unset($cdata);

	// copy images
	if(is_object($this->Images))
	$this->Images->CopyResource($OldId,$NewId);

	$this->AddToCategory($TargetCat, '', 0); // insert (but with duplicate records check)
	//echo "ok";
	if(is_numeric($TargetCat))
	{
	if(is_array($Cats))
	{
	if(!in_array($TargetCat,$Cats))
	{
	$this->AddToCategory($TargetCat, 0); // insert
	}
	}
	$this->SetPrimaryCategory($TargetCat); // 2 updates
	}
	}

	function refreshLastUpdate($cat_id = null)
	{
	$db =& GetADODBConnection();
	$prefix = GetTablePrefix();

	// 1,2,3,4 - set lastupdate date to item's primary category as recent
	// change date of all items in this category of same type as this item

	// 1. get item category or use passed one
	if(!isset($cat_id)) $cat_id = $this->GetPrimaryCategory();
	if($cat_id == 0) return false;

	// 2. get all item ResourceIds in that category
	$sql = 'SELECT ItemResourceId FROM '.$prefix.'CategoryItems WHERE CategoryId = '.$cat_id;
	$item_rids = $db->GetCol($sql);
	if($item_rids)
	{
	$item_rids = implode(',',$item_rids);

	// 2a. get LastUpdate date based on all item in $cat_id category
	$sql = 'SELECT MAX(IF(Modified=0,CreatedOn,Modified)) FROM '.$this->tablename.' WHERE ResourceId IN ('.$item_rids.')';
	$item_last_update = $db->GetOne($sql);
	}
	else
	{
	$item_last_update = 0;
	}

	// 3. get LastUpdate date based on all $cat_id subcategories
	$sql = 'SELECT MAX(IF(Modified=0,CreatedOn,Modified)) FROM '.$prefix.'Category WHERE ParentId = '.$cat_id;
	$cat_last_update = $db->GetOne($sql);

	$last_update = max($item_last_update,$cat_last_update);

	// 4. set $last_update date to $cat_id category
	$sql = 'UPDATE '.$prefix.'Category SET Modified = '.$last_update.' WHERE CategoryId = '.$cat_id;
	$db->Execute($sql);

	// 5. get $cat_id parent CategoryId
	$sql = 'SELECT ParentId FROM '.$prefix.'Category WHERE CategoryId = '.$cat_id;
	if($cat_id > 0) $this->refreshLastUpdate( $db->GetOne($sql) );
	}

	}
	?>
	\ No newline at end of file

	Property changes on: trunk/kernel/include/item.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.17
	\ No newline at end of property
	+1.18
	\ No newline at end of property
	Index: trunk/kernel/include/portaluser.php
	===================================================================
	--- trunk/kernel/include/portaluser.php (revision 1066)
	+++ trunk/kernel/include/portaluser.php (revision 1067)
	@@ -1,1023 +1,1030 @@
	<?php

	RegisterPrefix("clsPortalUser","user","kernel/include/portaluser.php");

	class clsPortalUser extends clsItem
	{
	var $Vars; //contains the PersistantSessionData for the user
	var $VarsLoaded;
	var $PrimeGroup;

	function clsPortalUser($UserId=NULL)
	{
	- $this->clsParsedItem();
	+ // $this->clsParsedItem();
	+ $this->clsItem();
	$this->tablename=GetTablePrefix()."PortalUser";
	$this->type=6;
	$this->BasePermission="USER";
	$this->id_field = "PortalUserId";
	$this->TagPrefix="user";

	$this->Vars = array();
	$VarsLoaded = FALSE;
	$this->debuglevel = 0;
	if(isset($UserId))
	$this->LoadFromDatabase($UserId);
	}

	function Delete()
	{
	global $objGroups, $objFavorites;

	$g = $objGroups->GetPersonalGroup($this->Get("Login"));
	if(is_object($g))
	$g->Delete();
	$objFavorites->DeleteUser($this->Get("PortalUserId")); //delete favorites
	parent::Delete();
	}

	function RemoveFromAllGroups()
	{
	$sql = "DELETE FROM ".GetTablePrefix()."UserGroup WHERE PortaluserId=".$this->Get("PortalUserId");
	$this->adodbConnection->Execute($sql);
	}

	function RemoveFromGroup($GroupId)
	{
	$sql = "DELETE FROM ".GetTablePrefix()."UserGroup WHERE PortaluserId=".$this->Get("PortalUserId");
	$sql .= " AND GroupId=$GroupId";
	$this->adodbConnection->Execute($sql);
	}

	function PrimaryGroup($ReturnField = "GroupId")
	{
	global $objGroups;

	$ret = "";

	if(!is_object($this->PrimeGroup))
	{
	if((int)$this->Get("GroupId")>0)
	{
	$this->PrimeGroup =& $objGroups->GetItem($this->Get("GroupId"));
	}
	else
	{
	$this->PrimeGroup = new clsPortalGroup();
	$sql = "SELECT * FROM ".GetTablePrefix()."UserGroup INNER JOIN ".GetTablePrefix()."PortalGroup ON (".GetTablePrefix()."UserGroup.GroupId=".GetTablePrefix()."PortalGroup.GroupId) WHERE PrimaryGroup = 1 AND PortalUserId=".$this->Get("PortalUserId");
	//echo $sql;
	$rs = $this->adodbConnection->Execute($sql);

	if($rs && !$rs->EOF)
	$this->PrimeGroup->SetFromArray($rs->fields);
	}
	}
	$ret = $this->PrimeGroup->Get($ReturnField);
	return $ret;
	}

	function SetPrimaryGroup($GroupId)
	{
	if($this->IsInGroup($GroupId))
	{
	$sql = "UPDATE ".GetTablePrefix()."UserGroup SET PrimaryGroup=0 WHERE PortalUserId=".$this->Get("PortalUserId");
	$this->adodbConnection->Execute($sql);
	$sql = "UPDATE ".GetTablePrefix()."UserGroup SET PrimaryGroup=1 WHERE GroupId=$GroupId AND PortalUserId=".$this->Get("PortalUserId");
	$this->adodbConnection->Execute($sql);
	}
	}

	function GetGroupList()
	{
	$ret = array();
	$sql = "SELECT GroupId FROM %sUserGroup WHERE PortalUserId = %s ORDER BY PrimaryGroup";
	$sql = sprintf($sql, GetTablePrefix(), $this->Get("PortalUserId"));
	$ret = $this->adodbConnection->GetCol($sql);
	return $ret;
	}

	function IsInGroup($GroupId)
	{
	$groups = $this->GetGroupList();
	if( $groups === false ) return false;
	return in_array($GroupId, $groups) ? true : false;
	}

	function GetPersonalGroup($CreateIfMissing = FALSE)
	{
	global $objGroups;

	$n = "_".$this->Get("Login");
	$g = $objGroups->GetItemByField("Name",$n);
	if(!is_object($g) && $CreateIfMissing)
	$g = $this->CreatePersonalGroup();
	return $g;
	}

	function CreatePersonalGroup()
	{
	global $objGroups;

	$Description = $this->Get("FirstName")." ".$this->Get("LastName");
	$CreatedOn=time();
	$n = "_".$this->Get("Login");
	$g = $objGroups->Add_Group($n, $Description, $CreatedOn, 1, 0);
	$g->Set("Personal",1);
	$g->Set("System",0);
	$g->Set("Enabled",1);
	$g->Update();
	if(is_object($g))
	$g->AddUser($this->Get("PortalUserId"));
	return $g;
	}

	function Validate()
	{
	global $Errors;

	$dataValid = true;
	if(!strlen($this->Get("Login")))
	{
	$Errors->AddError("error.fieldIsRequired",'Login',"","",get_class($this),"Validate");
	$dataValid = false;
	}

	if(!strlen($this->Get("Email")))
	{
	$Errors->AddError("error.fieldIsRequired",'Email',"","",get_class($this),"Validate");
	$dataValid = false;
	}

	return $dataValid;
	}

	function Approve()
	{
	$this->Set("Status", 1);
	$this->Update();
	$this->SendUserEventMail("USER.APPROVE",$this->Get("PortalUserId"));
	$this->SendAdminEventMail("USER.APPROVE");
	}

	function Deny($IsBanned = 0)
	{
	$this->Set( Array('Status','IsBanned'), Array(0,$IsBanned) );
	$this->Update();
	$this->SendUserEventMail("USER.DENY",$this->Get("PortalUserId"));
	$this->SendAdminEventMail("USER.DENY");
	}

	function HasSystemPermission($PermissionName)
	{
	global $objGroups;

	$GroupList = $this->GetGroupList();
	for($i=0;$i<count($GroupList);$i++)
	{
	$g = $objGroups->GetItem($GroupList[$i]);
	$value = $g->HasSystemPermission($PermissionName);
	if($value != -1)
	break;
	}
	return $value;
	}

	function LoadPersistantVars()
	{
	global $objConfig;

	unset($this->Vars);
	$this->Vars = array();
	$user_id = $this->HasField('PortalUserId') ? $this->Get('PortalUserId') : 0;
	$sql = "SELECT VariableName, VariableValue FROM ".GetTablePrefix()."PersistantSessionData WHERE PortalUserId = 0 OR PortalUserId = ".$user_id." ORDER BY PortalUserId ASC";
	$result = $this->adodbConnection->Execute($sql);
	while ($result && !$result->EOF)
	{
	$data = $result->fields;
	$this->Vars[$data["VariableName"]] = $data["VariableValue"];
	$objConfig->Set($data["VariableName"], $data["VariableValue"], 1, 1);
	$result->MoveNext();
	}
	$this->VarsLoaded=TRUE;
	}

	function SetPersistantVariable($variableName, $variableValue)
	{
	global $objConfig;

	if(!$this->VarsLoaded)
	$this->LoadPersistantVars();
	$userid = $this->Get("PortalUserId");
	$objConfig->Set($variableName,$variableValue,1);
	$fields = array_keys($this->Vars);

	if(strlen($variableValue)>0)
	{
	if(in_array($variableName,$fields))
	{
	$sql = "UPDATE ".GetTablePrefix()."PersistantSessionData SET VariableValue='$variableValue' WHERE VariableName='$variableName' AND PortalUserId=$userid";
	}
	else
	$sql = "INSERT INTO ".GetTablePrefix()."PersistantSessionData (VariableName,VariableValue,PortalUserId) VALUES ('$variableName','$variableValue',$userid)";
	}
	else
	$sql = "DELETE FROM ".GetTablePrefix()."PersistantSessionData WHERE VariableName='$variableName' AND PortalUserId=$userid";

	$this->Vars[$variableName] = $variableValue;

	// echo "<BR>SQL: $sql<BR>";

	$this->adodbConnection->Execute($sql);
	}

	function GetPersistantVariable($variableName)
	{
	global $objConfig, $objSession;

	if(!$this->VarsLoaded)
	$this->LoadPersistantVars();

	$fields = array_keys($this->Vars);

	if(in_array($variableName,$fields))
	{
	$val = $this->Vars[$variableName];
	}
	else
	{
	if( $this->UniqueId() == $objSession->Get('PortalUserId') )
	{
	$val = $objConfig->Get($variableName);
	}
	else
	{
	$val = '';
	}
	}

	return $val;
	}

	function GetAllPersistantVars()
	{
	if(!$this->VarsLoaded)
	$this->LoadPersistantVars();

	return $this->Vars;
	}

	function GetIcon()
	{
	}

	function StatusIcon()
	{
	global $imagesURL;

	$url = $imagesURL."/itemicons/icon16_user";
	if($this->Get("Status")==0)
	{
	$url .= "_disabled";
	}
	else
	if($this->Get("Status")==2)
	{
	$url .= "_pending";
	}
	$url .= ".gif";
	return $url;
	}

	function IsFriend($UserId)
	{
	$ftable = GetTablePrefix()."Favorites";
	$sql = "SELECT count(*) as FriendCount FROM $ftable WHERE PortalUserId=$UserId AND ResourceId=";
	$sql .=$this->Get("ResourceId")." AND ItemTypeId=6";
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	return ($rs->fields["FriendCount"]>0);
	return FALSE;
	}

	function GetUserTime($timestamp)
	{
	if(is_numeric($this->Get("tz")))
	{
	return GetLocalTime($timestamp,$this->Get("tz"));
	}
	else
	return GetLocalTime($timestamp);
	}

	function ParseObject($element)
	{
	global $objConfig, $objUsers, $objCatList,$objSession, $var_list_update, $var_list, $m_var_list_update;
	//echo "<PRE>"; print_r($element); echo "</pre>";
	//echo "Tag Prefix: ".$this->TagPrefix." Element: ".$element->name."<br>";
	+ $this->clsPortalUser();
	if (strtolower($element->name) == 'touser') {
	$this->TagPrefix = "touser";
	}

	$extra_attribs = ExtraAttributes($element->attributes);
	if(strtolower($element->name)==$this->TagPrefix)
	{
	$field = strtolower($element->attributes["_field"]);
	if(substr($field,0,3)=="pp_")
	{
	$perm = $objSession->GetPersistantVariable($field);
	if($perm)
	{
	$field = substr($field,3);
	}
	else
	$field = "";
	}
	switch($field)
	{
	/*
	@field:user.login
	@description:User's login name
	*/
	case "username":
	case "login":
	$ret = $this->Get("Login");
	break;
	case "firstname":
	$ret = $this->Get("FirstName");
	break;
	case "lastname":
	$ret = $this->Get("LastName");
	break;
	case "password":
	/*
	@field:user.password
	@description:User password
	*/
	$ret = $objSession->Get("password");
	$objSession->Set("password", '');
	break;
	case "email":
	$ret = $this->Get("Email");
	break;
	case "street":
	$ret = $this->Get("Street");
	break;
	case "city":
	$ret = $this->Get("City");
	break;
	case "state":
	$ret = $this->Get("State");
	break;
	case "zip":
	$ret = $this->Get("Zip");
	break;
	case "phone":
	$ret = $this->Get("Phone");
	break;
	case "country":
	$ret = $this->Get("Country");
	break;
	case "primarygroup":
	/*
	@field:user.primarygroup
	@description:Parses a field from the user's primary group
	@attrib:_groupfield::group field name to parse, defaults to group name
	*/
	$groupfield = $element->attributes["_groupfield"];
	if(!strlen($groupfield))
	$groupfield="Name";
	$ret = $this->PrimaryGroup($groupfield);
	break;
	case "date":
	/*
	@field:user.date
	@description:Returns the date/time the user was created
	@attrib:_tz:bool:Convert the date to the user's local time
	@attrib:_part::Returns part of the date. The following options are available: month,day,year,time_24hr,time_12hr
	*/
	$d = $this->Get("CreatedOn");
	if($element->attributes["_tz"])
	{
	$d = GetLocalTime($d,$objSession->Get("tz"));
	}

	$part = strtolower($element->attributes["_part"]);
	if(strlen($part))
	{
	$ret = ExtractDatePart($part,$d);
	}
	else
	{
	if($d<=0)
	{
	$ret = "";
	}
	else
	$ret = LangDate($d);
	}
	break;
	case "dob":
	/*
	@field:user.dob
	@description:Returns the date/time of the users date of birth
	@attrib:_tz:bool:Convert the date to the user's local time
	@attrib:_part::Returns part of the date. The following options are available: month,day,year,time_24hr,time_12hr
	*/
	$d = $this->Get("dob");
	if($element->attributes["_tz"])
	{
	$d = GetLocalTime($d,$objSession->Get("tz"));
	}
	$part = strtolower($element->attributes["_part"]);
	if(strlen($part))
	{
	$ret = ExtractDatePart($part,$d);
	}
	else
	{
	// if($d<=0)
	// {
	// $ret = "";
	// }
	// else
	$ret = LangDate($d);
	}
	break;

	case "modified":
	/*
	@field:user.modified
	@description:Returns the date/time the user was last modified
	@attrib:_tz:bool:Convert the date to the user's local time
	@attrib:_part::Returns part of the date. The following options are available: month,day,year,time_24hr,time_12hr
	*/
	$d = $this->Get("Modified");
	if($d<=0)
	$d = $this->Get("CreatedOn");

	if($element->GetAttributeByName('_tz'))
	{
	$d = GetLocalTime($d,$objSession->Get("tz"));
	}

	$part = strtolower($element->GetAttributeByName('_part'));
	if(strlen($part))
	{
	$ret = ExtractDatePart($part,$d);
	}
	else
	{
	if($d<=0)
	{
	$ret = "";
	}
	else
	$ret = LangDate($d);
	}
	break;

	case 'send_pm_link':
	$var_list_update['t'] = $element->GetAttributeByName('_Template');
	$ret = GetIndexURL(2)."?env=".BuildEnv()."&ToUser=".$this->Get('Login');
	break;

	case "profile_link":
	/*
	@field:user.profile_link
	@description:Create a link to the user's profile
	@attrib:_template:tpl:template the link should point to
	*/
	$t = $element->attributes["_template"];
	if(strlen($t))
	{
	$var_list_update["t"] = $t;
	}
	else
	$var_list_update["t"] = $var_list["t"];
	$ret = GetIndexURL(2)."?env=" . BuildEnv()."&UserId=".$this->Get("PortalUserId");
	break;
	case "add_friend_link":
	/*
	@field:user.add_friend_link
	@description:link to add a user to the friends list
	@attrib:_template:tpl:Template link shoukd point to
	*/
	if($element->attributes["_force"] \|\| !$this->IsFriend($objSession->Get("PortalUserId")) &&
	$this->Get("PortalUserId") != $objSession->Get("PortalUserId"))
	{
	$t = $element->attributes["_template"];
	if(strlen($t))
	{
	$var_list_update["t"] = $t;
	}
	else
	$var_list_update["t"] = $var_list["t"];
	$action = "m_add_friend";
	$ret = GetIndexURL(2)."?env=" . BuildEnv()."&Action=".$action."&UserId=".$this->Get("PortalUserId");
	}
	else
	$ret = "";
	break;
	case "del_friend_link":
	/*
	@field:user.del_friend_link
	@description:link to remove a user from the friends list
	@attrib:_template:tpl:Template link shoukd point to
	*/
	if($element->attributes["_force"] \|\| $this->IsFriend($objSession->Get("PortalUserId")) &&
	$this->Get("PortalUserId") != $objSession->Get("PortalUserId"))
	{
	$t = $element->attributes["_template"];
	if(strlen($t))
	{
	$var_list_update["t"] = $t;
	}
	else
	$var_list_update["t"] = $var_list["t"];
	$action = "m_del_friend";
	$ret = GetIndexURL(2)."?env=" . BuildEnv()."&Action=".$action."&UserId=".$this->Get("PortalUserId");
	}
	else
	$ret = "";
	break;
	case "icon":
	$ret = $this->GetIcon();
	break;
	case "image":
	/*
	@field:user.image
	@description:Return an image associated with the user
	@attrib:_default:bool:If true, will return the default image if the requested image does not exist
	@attrib:_name::Return the image with this name
	@attrib:_thumbnail:bool:If true, return the thumbnail version of the image
	@attrib:_imagetag:bool:If true, returns a complete image tag. exta html attributes are passed to the image tag
	- */
	+ */
	+ $avatar = $element->attributes["_avatar"];
	$default = $element->attributes["_primary"];
	$name = $element->attributes["_name"];
	- if(strlen($name))
	+ if ($avatar)
	{
	- $img = $this->GetImageByName($name);
	- // echo "<PRE>";print_r($img); echo "</PRE>";
	+ $img = $this->GetAvatarImage();
	}
	- else
	+ elseif(strlen($name))
	{
	- if($default)
	- $img = $this->GetDefaultImage();
	+ $img = $this->GetImageByName($name);
	+ // echo "<PRE>";print_r($img); echo "</PRE>";
	}
	+ elseif ($default)
	+ {
	+ $img = $this->GetDefaultImage();
	+ }
	+
	if($img)
	{
	if($element->attributes["_thumbnail"])
	{
	$url = $img->parsetag("thumb_url");
	}
	else
	$url = $img->parsetag("image_url");
	}
	else
	{
	$url = $element->attributes["_defaulturl"];
	}

	if($element->attributes["_imagetag"])
	{
	if(strlen($url))
	{
	$ret = "<IMG src=\"$url\" $extra_attribs >";
	}
	else
	$ret = "";
	}
	else
	$ret = $url;
	break;

	case "custom":
	/*
	@field:cat.custom
	@description:Returns a custom field
	@attrib:_customfield::field name to return
	@attrib:_default::default value
	*/
	$field = $element->attributes["_customfield"];
	$default = $element->attributes["
	"];
	$ret = $this->GetPersistantVariable($field);
	if(!strlen($ret))
	$ret = $this->GetCustomFieldValue($field,$default);
	break;
	default:
	$ret = "Undefined:".$element->name;
	break;
	}
	}
	else
	{
	$ret = $this->parsetag($element->name);
	}

	return $ret;
	}

	function parsetag($tag)
	{
	global $m_var_list_update, $var_list_update, $var_list, $objConfig;
	if(is_object($tag))
	{
	$tagname = $tag->name;
	}
	else
	$tagname = $tag;
	switch($tagname)
	{
	case "user_id":
	return $this->Get("ResourceId");
	break;
	case "user_login":
	return $this->Get("Login");
	break;
	case "user_group":
	return $this->Get("PrimaryGroupName");
	break;
	case "user_firstname":
	return $this->Get("FirstName");
	break;
	case "user_lastname":
	return $this->Get("LastName");
	break;
	case "user_email":
	return $this->Get("Email");
	break;
	case "user_date":
	return LangDate($this->Get("CreatedOn"));
	break;
	case "user_time":
	return LangTime($this->Get("CreatedOn"));
	break;
	case "user_dob":
	return LangDate($this->Get("dob"));
	break;

	case "user_password":
	return $this->Get("Password");
	break;
	case "user_phone":
	return $this->Get("Phone");
	break;
	case "user_street":
	return $this->Get("Street");
	break;
	case "user_city":
	return $this->Get("City");
	break;
	case "user_state":
	return $this->Get("State");
	break;
	case "user_zip":
	return $this->Get("Zip");
	break;
	case "user_country":
	return $this->Get("Country");
	break;
	case "user_resourceid":
	return $this->Get("ResourceId");
	break;
	case "user_icon":
	return $this->GetIcon();
	break;
	case "user_profile_link":
	$var_list_update["t"] = "user_profile";
	$m_var_list_update["action"] = $this->Get("UserId");
	$ret = GetIndexURL(2)."?env=" . BuildEnv();
	unset($m_var_list_update["action"], $var_list_update["t"]);
	return $ret;
	break;
	case "user_messages":
	return $this->NewMessages();
	break;
	case "user_messages_link":
	$var_list_update["t"] = "inbulletin/bb_private_msg_list";
	return GetIndexURL(2)."?env=" . BuildEnv();
	unset($var_list_update);
	break;
	default:
	return "Undefined:$tagname";
	break;
	}
	}

	} /* class clsPortalUser*/


	class clsUserManager extends clsItemList //clsItemCollection
	{
	/this class wraps common user-related functions /
	// var $Page;

	function clsUserManager()
	{
	$this->clsItemCollection(); // clsItemList() // need to use this, but double limit clause being created (normal+default 0,100)
	$this->classname = "clsPortalUser";
	$this->SetTable('live', GetTablePrefix().'PortalUser');
	$this->Page = isset($_GET['lpn']) ? $_GET['lpn'] : 1;
	$this->EnablePaging = true;
	$this->PerPageVar = "Perpage_User";
	$this->AdminSearchFields = array("Login","FirstName","LastName","Email","Street","City", "State","Zip","Country","Phone");
	}

	function GetPageLinkList($dest_template=NULL,$link_template=NULL,$page = "")
	{
	global $objConfig, $m_var_list_update, $var_list_update, $var_list;

	if(!strlen($page))
	$page = GetIndexURL(2);
	$NumPages = $this->GetNumPages($objConfig->Get("Perpage_Topics"));
	if(strlen($dest_template)>0)
	{
	$var_list_update["t"]=$dest_template;
	}
	else
	{
	$var_list_update["t"] = $var_list["t"];
	}
	$o = "";
	if($this->Page>1)
	{
	$m_var_list_update["p"]=$this->Page-1;
	$prev_url = $page."?env=".BuildEnv();
	}
	if($this->Page<$NumPages)
	{
	$m_var_list_update["p"]=$this->Page+1;
	$next_url = $page."?env=".BuildEnv();
	}

	for($p=1;$p<=$NumPages;$p++)
	{
	$t = template($link_template);
	if($p!=$this->Page)
	{
	$m_var_list_update["p"]=$p;
	$href = $page."?env=".BuildEnv();
	$t = str_replace("<%page_link%>", $href, $t);
	$t = str_replace("<%page_number%>",$p,$t);
	$t = str_replace("<%prev_url%>",$prev_url,$t);
	$t = str_replace("<%next_url%>",$next_url,$t);
	$o .= $t;
	}
	else
	{
	$o .= "<SPAN class=\"CURRENT_PAGE\">$p</SPAN>";
	}
	}
	return $o;
	}


	function GetUser($ID)
	{
	$u = $this->GetItem($ID);
	return $u;
	}

	function GetUserName($Id)
	{
	$rs = $this->adodbConnection->Execute("SELECT Login from ".$this->SourceTable." where PortalUserId=$Id");
	return $rs->fields["Login"];
	}

	function GetUserId($Login)
	{
	$rs = $this->adodbConnection->Execute("SELECT PortalUserId from ".$this->SourceTable." where Login LIKE '$Login'");
	return $rs->fields["PortalUserId"];
	}


	function GetTotalUsers()
	{
	return $this->UserCount("1");
	}


	function GetLatestUser()
	{
	global $Errors;

	$sql = "SELECT max(CreatedOn) as LastDate FROM ".$this->SourceTable;
	$result = $this->adodbConnection->Execute($sql);
	if ($result === false \|\| !is_object($result))
	{
	$Errors->AddError("error.DatabaseError",NULL,$adodbConnection->ErrorMsg(),"",get_class($this),"GetLatestUser");
	return false;
	}
	$sql = "SELECT PortalUserId FROM ".$this->SourceTable." WHERE CreatedOn >= ".$result->fields["LastDate"];
	$result = $this->adodbConnection->Execute($sql);
	if (!rs \|\| $rs->EOF)
	{
	$Errors->AddError("error.DatabaseError",NULL,$adodbConnection->ErrorMsg(),"",get_class($this),"GetLatestUser");
	return false;
	}
	$u = $this->GetUser($result->fields["PortalUserId"]);
	return $u;
	}

	function &Add_User($Login, $Password, $Email, $CreatedOn, $FirstName="", $LastName="", $Status=2,
	$Phone="", $Street="", $City="", $State="", $Zip="", $Country="", $dob=0, $ip="", $CheckBanned=FALSE)
	{
	$u = new clsPortalUser(NULL);
	$u->tablename = $this->SourceTable;
	//echo "Creating User..<br>\n";
	$u->Set(array("Login", "Password", "FirstName", "LastName", "Email", "Status",
	"Phone","Street", "City", "State", "Zip", "Country", "CreatedOn","dob"),
	array($Login, $Password, $FirstName, $LastName, $Email, $Status,
	$Phone, $Street, $City, $State, $Zip, $Country, $CreatedOn, $dob));

	$BrokenRule = $CheckBanned ? $u->CheckBanned() : false;
	if(!$BrokenRule)
	{
	$u->Create();
	return $u;
	}
	return $BrokenRule;
	/md5($Password)/
	}

	function &Edit_User($UserId, $Login, $Password, $Email, $CreatedOn, $FirstName="", $LastName="",
	$Status=2, $Phone="", $Street="", $City="", $State="", $Zip="", $Country="", $dob=0, $MinPwResetDelay=300)
	{
	//echo "<font color=\"red\">Editing User: [$UserId]</font><br>";

	$u =& $this->GetItem($UserId);

	if(!$CreatedOn)
	$CreatedOn = $u->Get("CreatedOn");

	// $u->debuglevel=1;

	if (is_object($u))
	{
	$IsBanned = $u->Get('IsBanned');
	if($Status == 1) $IsBanned = 0;
	$u->Set(array("Login", "FirstName", "LastName", "Email", "Status",
	"Phone", "Street", "City", "State", "Zip", "Country", "CreatedOn","dob","IsBanned", "MinPwResetDelay"),
	array($Login, $FirstName, $LastName, $Email, $Status,
	$Phone, $Street, $City, $State, $Zip, $Country, $CreatedOn,$dob,$IsBanned,$MinPwResetDelay));
	if(strlen($Password))
	$u->Set("Password",$Password);
	$u->Update();
	}
	return $u;
	}

	function Delete_User($UserId)
	{
	$u = $this->GetItemByField("ResourceId",$UserId);
	if(is_object($u))
	{
	$u->RemoveFromAllGroups();
	$u->Delete();
	}
	}


	function LoadUsers($where = "",$orderBy = "")
	{
	global $objConfig;

	$this->Clear();
	if($this->Page<1)
	$this->Page=1;

	if(is_numeric($objConfig->Get("Perpage_Users")))
	{
	$Start = ($this->Page-1)*$objConfig->Get("Perpage_Users");
	$limit = "LIMIT ".$Start.",".$objConfig->Get("Perpage_Users");
	}
	else
	$limit = NULL;

	$where = trim($where);
	$orderBy = trim($orderBy);
	if(!strlen($where))
	$where = "1";

	$this->QueryItemCount=TableCount($this->SourceTable,$where,0);

	if($this->QueryItemCount>0)
	{
	if ($orderBy!="")
	{
	$this->Query_PortalUser($where,$orderBy,$limit);
	}
	else
	{
	$this->Query_PortalUser($where,"Login DESC",$limit);
	}
	}
	}

	function Query_PortalUser($whereClause,$orderByClause="", $limitClause="")
	{
	global $m_var_list,$Errors, $objSession;

	$resultSet = array();

	$utable = $this->SourceTable;
	$gtable = GetTablePrefix()."UserGroup";
	$sql = "SELECT * FROM $utable LEFT JOIN $gtable ON ($utable.PortalUserId=$gtable.PortalUserId)";

	if(isset($whereClause))
	$sql = sprintf('%s WHERE %s',$sql,$whereClause);

	if(isset($orderByClause))
	if(strlen(trim($orderByClause))>0)
	$sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);

	if(isset($limitClause))
	$sql = sprintf('%s %s',$sql,$limitClause);

	return $this->Query_Item($sql);
	}

	function Query_GroupPortalUser($whereClause,$orderByClause)
	{
	global $m_var_list,$objSession,$Errors;

	$resultSet = array();


	$table = $this->SourceTable;
	$sql = "SELECT * FROM $table LEFT JOIN ".GetTablePrefix()."UserGroup USING (PortalUserId) ";

	if(isset($whereClause))
	$sql = sprintf('%s WHERE %s',$sql,$whereClause);

	if(isset($orderByClause))
	$sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);

	return $this->query_item($sql);
	}

	function UserCount($whereClause)
	{
	$count = TableCount($this->SourceTable,$whereClause,0);
	return $count;
	}

	function CountActive()
	{
	return $this->UserCount("Status=1");
	}

	function CountPending()
	{
	return $this->UserCount("Status=2");
	}

	function CountDisabled()
	{
	return $this->UserCount("Status=0");
	}

	function CopyFromEditTable($idfield)
	{
	global $objSession;
	$GLOBALS['_CopyFromEditTable']=1;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	$sql = "SELECT * FROM $edit_table";
	$rs = $this->adodbConnection->Execute($sql);

	//echo $sql."<BR>";

	while($rs && !$rs->EOF)
	{
	$data = $rs->fields;
	$c = new $this->classname;
	$c->SetFromArray($data);
	$c->idfield = $idfield;
	$c->Dirty();
	if($c->Get($idfield)<1)
	{
	$old_id = $c->Get($idfield);
	$c->UnsetIdField();
	$c->Create();
	$sql = "UPDATE ".GetTablePrefix()."UserGroup SET PortalUserId=".$c->Get("PortalUserId");
	$sql .=" WHERE PortalUserId=0";
	$this->adodbConnection->Execute($sql);
	}
	else
	$c->Update();
	unset($c);
	$rs->MoveNext();
	}
	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
	unset($GLOBALS['_CopyFromEditTable']);
	}

	function PurgeEditTable()
	{
	parent::PurgeEditTable();
	$sql = "DELETE FROM ".GetTablePrefix()."UserGroup WHERE PortalUserId=0";
	$this->adodbConnection->Execute($sql);
	}
	} /clsUserManager/
	?>

	Property changes on: trunk/kernel/include/portaluser.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.22
	\ No newline at end of property
	+1.23
	\ No newline at end of property
	Index: trunk/kernel/include/image.php
	===================================================================
	--- trunk/kernel/include/image.php (revision 1066)
	+++ trunk/kernel/include/image.php (revision 1067)
	@@ -1,1225 +1,1243 @@
	<?php

	class clsImage extends clsParsedItem
	{
	var $Pending;

	function clsImage($id=NULL)
	{
	global $objSession;

	$this->clsParsedItem();
	$this->tablename = GetTablePrefix()."Images";
	$this->Pending = FALSE;
	$this->id_field = "ImageId";
	$this->type=-30;
	$this->TagPrefix = "image";
	$this->NoResourceId=1;
	if($id)
	$this->LoadFromDatabase($id);
	//$this->SetDebugLevel(0);
	}

	function DetectChanges($name, $value)
	{
	global $objSession;
	//print_pre($_POST);

	if ($this->Data[$name] != $value) {
	//echo "$name Modified tt ".$this->Data[$name]." tt $value<br>";
	if (!stristr($name, 'Resource') && !stristr($name, 'ImageId')) {
	if ($objSession->GetVariable("HasChanges") != 1) {
	$objSession->SetVariable("HasChanges", 2);
	}
	}
	}
	}

	function GetFileName($thumb = 0)
	{
	global $pathtoroot;

	if($thumb)
	{
	$p = $this->Get("ThumbPath");
	}
	else
	{
	$p = $this->Get("LocalPath");
	if(!strlen($p) && $this->Get("SameImages"))
	{
	$p = $this->Get("ThumbPath");
	}
	}

	if(strlen($p))
	{
	$parts = pathinfo($pathtoroot.$p);
	$filename = $parts["basename"];
	}
	else
	$filename = "";

	return $filename;
	}

	function GetImageDir()
	{
	global $pathtoroot;

	$p = $this->Get("ThumbPath");
	$localp = $this->Get("LocalPath");
	if(strlen($p))
	{
	$parts = pathinfo($pathtoroot.$p);
	$d = $parts["dirname"]."/";
	}
	elseif (strlen($localp))
	{
	$parts = pathinfo($pathtoroot.$localp);
	$d = $parts["dirname"]."/";
	}

	if($this->Pending)
	$d .= "pending/";

	return $d;
	}


	function Delete()
	{
	$this->DeleteLocalImage();
	parent::Delete();
	}

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

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

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

	foreach ($this->m_dirtyFieldsMap as $key => $value)
	{
	if(!is_numeric($key) && $key != $this->IdField())
	{
	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 ($objSession->GetVariable("HasChanges") == 2) {
	$objSession->SetVariable("HasChanges", 1);
	}

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

	return true;
	}

	function LoadFromDatabase($Id)
	{
	global $Errors;

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

	$sql = sprintf("SELECT * FROM ".$this->tablename." WHERE ImageId = '%s'",$Id);

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

	$data = $result->fields;

	$this->SetFromArray($data);
	$this->Clean();
	return true;
	}

	function LoadFromResource($Id,$ImageIndex)
	{
	global $Errors;

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

	$sql = sprintf("SELECT * FROM ".$this->tablename." WHERE ResourceId = '%s'AND ImageIndex = '%s'",$Id,$ImageIndex);

	$result = $this->adodbConnection->Execute($sql);
	if ($result === false \|\| $result->EOF)
	{
	// $Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"LoadFromResource");
	return false;
	}

	$data = $result->fields;

	$this->SetFromArray($data);

	return true;
	}

	function LocalImageExists()
	{
	global $objConfig, $pathtoroot;
	$result=FALSE;
	if($this->Get("LocalImage")==1 && $this->Get("SameImages")==0)
	{
	$imagepath = $pathtoroot.$this->Get("LocalPath");
	// $imagepath = $this->GetImageDir().$this->GetFileName();

	// echo "PATH: ".$this->GetImageDir()."; FILE: ".$this->GetFileName()."<BR>";

	if(strlen($imagepath)>0)
	{
	$result = file_exists($imagepath);
	}
	}
	return $result;
	}

	function LocalThumbExists()
	{
	$result=FALSE;
	global $objConfig, $pathtoroot;

	if($this->Get("LocalThumb")==1)
	{
	//$imagepath = $pathtoroot.$this->Get("ThumbPath");
	$imagepath = $this->GetImageDir().$this->GetFileName(1);
	if(strlen($imagepath)>0)
	{
	$result = file_exists($imagepath);
	}
	}
	return $result;
	}


	function DeleteLocalImage($Thumb=TRUE,$Full=TRUE)
	{
	global $pathtoroot;

	if($Full)
	{
	if($this->LocalImageExists())
	{
	// $filename = $this->GetImageDir().$this->GetFileName();
	$filename = $pathtoroot.$this->Get("LocalPath");
	// echo "FULL: $filename<BR>\n";
	@unlink($filename);
	}
	}

	if($Thumb)
	{
	if($this->LocalThumbExists())
	{
	$filename = $this->GetImageDir().$this->GetFileName(1);
	// echo "THUMB: $filename<BR>\n";
	@unlink($filename);
	}
	}
	}

	function StoreUploadedImage($file, $rewrite_name=1,$DestDir,$IsThumb=0,$IsUpload=TRUE)
	{
	/* move the uploaded image to its final location and update the LocalPath property */
	/* returns the destination filename on success */
	global $objConfig,$pathtoroot;

	$Dest_Dir = $DestDir;
	if($this->Pending)
	$Dest_Dir .= "pending/";

	if(((int)$file["error"]==0) && (substr($file["type"],0,6)=="image/") && @getimagesize($file["tmp_name"]) )
	{
	$parts = pathinfo($file["name"]);
	$ext = strtolower($parts["extension"]);

	if( $GLOBALS['debuglevel'] ) echo "Processing ".$file["tmp_name"]."<br>\n";

	if($rewrite_name==1)
	{

	if($IsThumb)
	$filename = "th_";
	$filename .= $this->Get("ResourceId")."_".$this->Get("ImageIndex").".".$ext;
	}
	else
	{
	$filename = $file["name"];
	}
	$destination = $pathtoroot.$Dest_Dir.$filename;
	if( $GLOBALS['debuglevel'] ) echo $file["tmp_name"]."=>".$destination."<br>\n";
	if($IsUpload==TRUE)
	{
	$result = @move_uploaded_file($file["tmp_name"],$destination);
	}
	else
	$result = copy($file["tmp_name"],$destination);
	if($result)
	{
	@chmod($Dest_Dir.$filename, 0666);
	return $Dest_Dir.$filename;
	}
	else
	return "";
	}
	else
	return "";
	}

	function CopyToPending()
	{
	global $pathtoroot;

	$ThumbPath = (strlen($this->Get("ThumbPath"))>0) ? $pathtoroot.$this->Get("ThumbPath") : '';
	$FullPath = strlen($this->Get("LocalPath")) ? $pathtoroot.$this->Get("LocalPath") : '';

	$dest = $this->GetImageDir()."pending/";


	// echo "DESTIN DIR: $dest<BR>";
	// echo "THUMB PATH: $ThumbPath <BR>";

	if(strlen($ThumbPath))
	{
	if(file_exists($ThumbPath))
	{
	$p = pathinfo($ThumbPath);
	$d = $dest.$p["basename"];
	if(file_exists($d))
	unlink($d);
	copy($ThumbPath,$d);
	@chmod($ThumbPath.$d, 0666);
	}
	}


	if(strlen($FullPath))
	{
	if(file_exists($FullPath))
	{
	$p = pathinfo($FullPath);
	$d = $dest.$p["basename"];
	if(file_exists($d))
	unlink($d);
	copy($FullPath,$d);
	@chmod($FullPath.$d, 0666);
	}
	}
	}

	function CopyFromPending()
	{
	global $pathtoroot,$pathchar;

	$ThumbPath = $this->Get("ThumbPath");
	$FullPath = $this->Get("LocalPath");

	// $src = $this->GetImageDir()."pending/";
	$src = $this->GetImageDir();

	if(strlen($ThumbPath))
	{
	if(strpos($ThumbPath,"pending/"))
	{
	if(file_exists($pathtoroot.$ThumbPath))
	{
	$path = pathinfo($pathtoroot.$ThumbPath);
	$p = explode("/",$ThumbPath);
	unset($p[count($p)-2]);

	$d = $pathtoroot.implode("/",$p);

	if(file_exists($d))
	unlink($d);

	copy($pathtoroot.$ThumbPath,$d);
	@chmod($pathtoroot.$ThumbPath.$d, 0666);
	unlink($pathtoroot.$ThumbPath);
	}

	}
	}
	if(strlen($FullPath))
	{
	if(file_exists($pathtoroot.$FullPath))
	{
	if(strpos($FullPath,"pending/"))
	{
	$path = pathinfo($pathtoroot.$FullPath);
	$p = explode("/",$FullPath);
	unset($p[count($p)-2]);

	$d = $pathtoroot.implode("/",$p);

	if(file_exists($d))
	unlink($d);
	copy($pathtoroot.$FullPath,$d);
	@chmod($pathtoroot.$FullPath.$d, 0666);
	unlink($pathtoroot.$FullPath);
	}
	}
	}
	}

	function DeleteFromPending()
	{
	global $pathtoroot;
	$ThumbPath = $pathtoroot.$this->Get("ThumbPath");
	$FullPath = $pathtoroot.$this->Get("LocalPath");

	$src = $this->GetImageDir()."pending/";
	$p = pathinfo($ThumbPath);
	$d = $src.$p["basename"];
	if(file_exists($d))
	@unlink($d);

	$p = pathinfo($FullPath);
	$d = $src.$p["basename"];
	if(file_exists($d))
	@unlink($d);
	}

	function RenameFiles($OldResId,$NewResId)
	{
	global $pathtoroot;

	if($this->Pending)
	{
	$ThumbPath = $this->GetImageDir().$this->GetFileName(TRUE);
	}
	else
	$ThumbPath = $pathtoroot.$this->Get("ThumbPath");
	$parts = pathinfo($ThumbPath);
	$ext = $parts["extension"];
	$pending="";
	if($this->Pending)
	{
	$pending="pending/";
	$FullPath = $this->GetImageDir().$this->GetFileName(FALSE);
	}
	else
	$FullPath = $pathtoroot.$this->Get("LocalPath");

	$NewThumb = $pathtoroot."kernel/images/".$pending."th_$NewResId_".$this->Get("ImageIndex").".$ext";
	$NewFull = $pathtoroot."kernel/images/".$pending."$NewResId_".$this->Get("ImageIndex").".$ext";
	if(file_exists($ThumbPath))
	{
	@rename($ThumbPath,$NewThumb);
	}

	if(file_exists($FullPath))
	{
	@rename($FullPath,$NewFull);
	}

	}

	function ReplaceImageFile($file)
	{
	global $objConfig;

	if($file["error"]==0)
	{
	$this->DeleteLocalImage();
	move_uploaded_file($file,$this->Get("LocalPath"));
	@chmod($this->Get("LocalPath"), 0666);
	}
	}

	function FullURL($ForceNoThumb=FALSE,$Default="kernel/images/noimage.gif")
	{
	global $rootURL, $objConfig,$pathtoroot;

	if($this->Get('SameImages') && !$ForceNoThumb)
	if (!(($this->Get('LocalImage') && strlen($this->Get('LocalPath'))) \|\|
	($this->Get('LocalImage') == 0 && strlen($this->Get('Url')))))
	{
	return $this->ThumbURL();
	}

	if(strlen($this->Get("Url")))
	return $this->Get("Url");
	if($this->Get("LocalImage")=="1")
	{
	$url = $this->Get("LocalPath");
	//$url = $this->GetImageDir().$this->GetFileName();
	if(file_exists($pathtoroot.$url))
	{
	if(strlen($url))
	{
	$url = $rootURL.$url;
	return $url;
	}
	else
	{
	if(strlen($Default))
	$url = $rootURL.$Default;
	return $url;
	}
	}
	else
	{
	if(strlen($Default))
	{
	return $rootURL.$Default;
	}
	else
	return "";
	}
	}
	else
	{
	if(strlen($Default))
	{
	return $rootURL.$Default;
	}
	else
	return "";
	}
	}

	function ThumbURL()
	{
	global $rootURL, $pathtoroot, $objConfig;

	if(strlen($this->Get("ThumbUrl")))
	{
	return $this->Get("ThumbUrl");
	}

	if($this->Get("LocalThumb")=="1")
	{
	$url = $this->Get("ThumbPath");
	//$url = $this->GetImageDir().$this->GetFileName();
	if(file_exists($pathtoroot.$url))
	{
	if(strlen($url))
	{
	$url = $rootURL.$url;
	}
	else
	$url = $rootURL."kernel/images/noimage.gif";
	return $url;
	}
	else
	return $rootURL."kernel/images/noimage.gif";
	}
	else
	{
	return $rootURL."kernel/images/noimage.gif";
	}
	}

	function ParseObject($element)
	{
	$extra_attribs = ExtraAttributes($element->attributes);
	if(strtolower($element->name)==$this->TagPrefix)
	{
	$field = strtolower($element->attributes["_field"]);
	switch($field)
	{
	case "name":
	$ret = $this->Get("Name");
	break;
	case "alt":
	$ret = $this->Get("AltName");
	break;
	case "full_url":
	$ret = $this->FullURL();
	break;
	case "thumb_url":
	$ret = $this->ThumbURL();
	break;
	}
	}
	else
	$ret = $element->Execute();
	return $ret;
	}

	function parsetag($tag)
	{
	if(is_object($tag))
	{
	$tagname = $tag->name;
	}
	else
	$tagname = $tag;
	switch($tagname)
	{
	case "image_name":
	$ret = $this->Get("Name");
	break;
	case "image_alt":
	$ret = $this->Get("AltName");
	break;
	case "image_url":
	$ret = $this->FullURL();
	break;
	case "thumb_url":
	$ret = $this->ThumbURL();
	break;
	}
	return $ret;
	}

	//Changes priority
	function MoveUp()
	{
	$this->Increment("Priority");
	}

	function MoveDown()
	{
	$this->Decrement("Priority");
	}

	function GetMaxPriority()
	{
	$SourceId = $this->Get("ResourceId");
	$sql = "SELECT MAX(Priority) as p from ".$this->tablename."WHERE ResourceId=$SourceId";
	$result = $this->adodbConnection->Execute($sql);
	return $result->fields["p"];
	}

	function GetMinPriority()
	{
	$SourceId = $this->Get("ResourceId");
	$sql = "SELECT MIN(Priority) as p from ".$this->tablename."WHERE ResourceId=$SourceId";
	$result = $this->adodbConnection->Execute($sql);
	return $result->fields["p"];
	}

	function UpdatePriority()
	{
	$SourceId = $this->Get("ResourceId");
	$sql = "SELECT MAX(Priority) as p from ".$this->tablename."WHERE ReourceId=$SourceId";
	$result = $this->adodbConnection->Execute($sql);
	$this->Set("Priority", $result->fields["p"]+1);
	}

	function MakeThumbnail () {

	}
	}

	class clsImageList extends clsItemCollection
	{
	var $Page;
	var $PerPageVar;

	function clsImageList()
	{
	$this->clsItemCollection();
	$this->PerPageVar = "Perpage_Images";
	$this->SourceTable = GetTablePrefix()."Images";
	$this->classname = "clsImage";
	}

	function LoadImages($where="",$orderBy = "")
	{
	global $objConfig;

	$this->Clear();
	if($this->Page<1)
	$this->Page=1;

	if(is_numeric($objConfig->Get("Perpage_Images")))
	{
	$Start = ($this->Page-1)*$objConfig->Get("Perpage_Images");
	$limit = "LIMIT ".$Start.",".$objConfig->Get("Perpage_Images");
	}
	else
	$limit = NULL;


	$this->QueryItemCount=TableCount("Images",$where,0);
	//echo $this->QueryItemCount."<br>\n";
	if(strlen(trim($orderBy))>0)
	{
	$orderBy = "Priority DESC, ".$orderBy;
	}
	else
	$orderBy = "Priority DESC";

	return $this->Query_Images($where,$orderBy,$limit);
	}

	function Query_Images($whereClause,$orderByClause=NULL,$limit=NULL)
	{
	global $objSession, $Errors;

	$sql = "SELECT * FROM ".$this->SourceTable;

	if(isset($whereClause))
	$sql = sprintf('%s WHERE %s',$sql,$whereClause);
	if(isset($orderByClause) && strlen(trim($orderByClause))>0)
	$sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);
	if(isset($limit) && strlen(trim($limit)))
	$sql .= " ".$limit;
	//echo $sql;
	return $this->Query_Item($sql);
	}

	function &Add($Name, $Alt, $ResourceId, $LocalImage, $LocalThumb,
	$Url, $ThumbUrl, $Enabled=1, $Priority=0, $DefaultImg=0, $ImageIndex=0,
	$SameImages=0, $ImageId=-999)
	{
	if($DefaultImg==1)
	{
	$sql = "UPDATE ".$this->SourceTable." SET DefaultImg=0 WHERE ResourceId=$ResourceId";
	$this->adodbConnection->Execute($sql);
	}

	$img = new clsImage();
	$img->tablename = $this->SourceTable;
	$img->Set(array("Name","AltName","ResourceId","LocalImage","LocalThumb",
	"Url","ThumbUrl","Enabled","Priority","DefaultImg","ImageIndex","SameImages"),
	array($Name,$Alt,$ResourceId,$LocalImage,$LocalThumb,
	$Url,$ThumbUrl,$Enabled,$Priority,$DefaultImg,$ImageIndex,$SameImages));

	if ($ImageId != -999)
	{
	$img->Set("ImageId", $ImageId);
	}

	if((int)$ImageIndex==0)
	$img->Set("ImageIndex",$this->GetNextImageIndex($ResourceId));
	$img->Create();
	array_push($this->Items,$img);
	return $img;
	}


	function Edit($ImageId,$Name, $Alt, $ResourceId, $LocalImage, $LocalThumb,
	$Url, $ThumbUrl, $Enabled=1, $Priority=0, $DefaultImg=0, $ImageIndex=0,
	$SameImages=0)
	{
	$img = $this->GetItem($ImageId);

	if((int)$ImageIndex==0)
	$ImageIndex = $img->Get("ImageIndex");

	if(!strlen($ThumbUrl) && !$LocalThumb)
	$ThumbUrl = $img->Get("ThumbUrl");

	$img->Set(array("Name","AltName","ResourceId","LocalImage","LocalThumb",
	"Url","ThumbUrl","Enabled","Priority","DefaultImg","ImageIndex","SameImages"),
	array($Name, $Alt, $ResourceId, $LocalImage, $LocalThumb,
	$Url, $ThumbUrl, $Enabled, $Priority, $DefaultImg, $ImageIndex,$SameImages));

	if((int)$ImageIndex==0)
	$img->Set("ImageIndex",$this->GetNextImageIndex($ResourceId));

	$img->Update();

	if($DefaultImg==1)
	{
	$sql = "UPDATE ".$this->SourceTable." SET DefaultImg=0 WHERE ResourceId=".$ResourceId." AND ImageId !=$ImageId";
	$this->adodbConnection->Execute($sql);
	}
	array_push($this->Items,$img);

	return $img;
	}

	function Delete_Image($ImageId)
	{
	$i = $this->GetItem($ImageId);
	$i->Delete();
	}

	function DeleteResource($ResourceId)
	{
	$this->Clear();
	$images = $this->Query_Images("ResourceId=".$ResourceId);
	if(is_array($images))
	{
	foreach($images as $i)
	{
	$i->Delete();
	}
	}
	}

	function LoadResource($ResourceId)
	{
	$sql = "SELECT * FROM ".$this->SourceTable." WHERE ResourceId=$ResourceId";
	$this->Query_Item($sql);
	}

	function CopyResource($SourceId,$DestId)
	{
	global $pathtoroot;

	$this->Clear();
	$this->LoadResource($SourceId);
	foreach($this->Items as $i)
	{
	if($i->Get("LocalThumb"))
	{
	$f = $pathtoroot.$i->Get("ThumbPath");
	if(file_exists($f))
	{
	$p = pathinfo($f);
	$dir = $p["dirname"];
	$ext = $p["extension"];
	$newfile = $dir."/th_".$DestId."_".$i->Get("ImageIndex").".".$ext;
	if(file_exists($newfile))
	@unlink($newfile);
	// echo $f." -> ".$newfile;
	copy($f,$newfile);
	}
	}
	if($i->Get("LocalImage"))
	{
	$f = $pathtoroot.$i->Get("LocalPath");
	if(file_exists($f))
	{
	$p = pathinfo($f);
	$dir = $p["dirname"];
	$ext = $p["extension"];
	$newfile = $dir."/".$DestId."_".$i->Get("ImageIndex").".".$ext;
	if(file_exists($newfile))
	@unlink($newfile);

	// echo $f." -> ".$newfile;
	copy($f,$newfile);
	}
	}
	}
	parent::CopyResource($SourceId,$DestId);
	$this->Clear();
	$this->LoadResource($DestId);
	foreach($this->Items as $img)
	{
	if($img->Get("LocalThumb"))
	{
	$f = str_replace("th_$SourceId","th_$DestId",$img->Get("ThumbPath"));
	$img->Set("ThumbPath",$f);
	}
	if($img->Get("LocalImage"))
	{
	$f = str_replace("/".$SourceId."_","/".$DestId."_",$img->Get("LocalPath"));
	$img->Set("LocalPath",$f);
	}
	$img->Update();
	}
	}

	function GetImageByResource($ResourceId,$Index)
	{
	$found=FALSE;
	if($this->NumItems()>0)
	{
	foreach($this->Items as $i)
	{
	if($i->Get("ResourceID")==$ResourceId and ($i->Get("ImageIndex")==$Index))
	{
	$found=TRUE;
	break;
	}
	}
	}
	if(!$found)
	{
	$i = NULL;
	$i = new clsImage();
	if($i->LoadFromResource($ResourceId,$Index))
	{
	array_push($this->Items, $i);
	}
	else
	unset($i);
	}
	if(is_object($i))
	{
	return $i;
	}
	else
	return FALSE;
	}

	function &GetDefaultImage($ResourceId)
	{
	$sql = "SELECT * FROM ".$this->SourceTable." WHERE ResourceId=$ResourceId AND DefaultImg=1";
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && ! $rs->EOF)
	{
	$data = $rs->fields;
	$img= new clsImage();
	$img->SetFromArray($data);
	$img->Clean();
	return $img;
	}
	else
	return FALSE;
	-
	}
	+
	+ function &GetAvatarImage($ResourceId)
	+ {
	+ $sql = 'SELECT * FROM '.$this->SourceTable.
	+ ' WHERE ResourceId='.$ResourceId.' AND Name="avatar" AND Enabled=1
	+ LIMIT 1';
	+ $rs = $this->adodbConnection->Execute($sql);
	+ if($rs && ! $rs->EOF)
	+ {
	+ $data = $rs->fields;
	+ $img= new clsImage();
	+ $img->SetFromArray($data);
	+ $img->Clean();
	+ return $img;
	+ }
	+ else
	+ return FALSE;
	+ }
	+
	function HandleImageUpload($FILE,$ResourceId,$RelatedTo,$DestDir, $Name="",$AltName="",$IsThumb=0)
	{
	global $objConfig;

	$img = $this->GetImageByResource($ResourceId,$RelatedTo);

	if(is_object($img) && $RelatedTo>0)
	{
	$img->Set("LocalImage",1);
	$img->Set("Name",$Name);
	$img->Set("AltName",$AltName);
	$img->Set("IsThumbnail",$IsThumb);
	$dest = $img->StoreUploadedImage($FILE,1,$DestDir);
	if(strlen($dest))
	{
	$img->Set("Url", $objConfig->Get("Site_Path").$dest);
	$img->Update();
	}
	}
	else
	{
	$img=$this->NewLocalImage($ResourceId,$RelatedTo,$Name,$AltName,$IsThumb,$FILE,$DestDir);
	}
	return $img;
	}

	function GetResourceImages($ResourceId)
	{
	$sql = "SELECT * FROM ".$this->SourceTable." WHERE ResourceId=".$ResourceId;
	$rs = $this->adodbConnection->Execute($sql);
	while($rs && !$rs->EOF)
	{
	$img = new clsImage();
	$img->LoadFromResource($ResourceId,$rs->fields["RelatedTo"]);
	array_push($this->Images,$img);
	$rs->MoveNext();
	}
	}

	function GetResourceThumbnail($ResourceId)
	{
	$found=FALSE;
	foreach($this->Images as $img)
	{
	if($img->Get("ResourceId")==$ResourceId && $img->Get("IsThumbnail")==1)
	{
	$found=TRUE;
	break;
	}
	}
	if($found)
	{
	return $img;
	}
	else
	return FALSE;
	}

	function &GetImageByName($ResourceId,$name)
	{
	$found = FALSE;
	foreach($this->Items as $img)
	{
	if($img->Get("ResourceId")==$ResourceId && $img->Get("Name")==$name)
	{
	$found=TRUE;
	break;
	}
	}
	if($found)
	{
	return $img;
	}
	else
	{
	$sql = "SELECT * FROM ".$this->SourceTable." WHERE ResourceId=$ResourceId AND Name LIKE '$name'";
	//echo $sql;
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	{
	$img = $this->AddItemFromArray($rs->fields);
	return $img;
	}
	else
	return FALSE;
	}
	}

	function CopyToPendingFiles()
	{
	$sql = "SELECT * FROM ".$this->SourceTable;
	$this->Clear();
	$this->Query_Item($sql);
	foreach($this->Items as $i)
	{
	if(strlen($i->Get("LocalImage")) \|\| strlen($i->Get("LocalThumb")))
	{
	$i->CopyToPending();
	}
	}
	}

	function CopyFromPendingFiles($edit_table)
	{
	$sql = "SELECT * FROM ".$edit_table;
	$this->Clear();
	$this->Query_Item($sql);
	foreach($this->Items as $i)
	{

	## Delete original Images
	$OrgImage = new clsImage($i->Get("ImageId"));
	$OrgImage->DeleteLocalImage();

	if($i->Get("LocalImage") \|\| $i->Get("LocalThumb"))
	{
	$i->CopyFromPending();

	$t = $i->Get("LocalPath");

	$p = pathinfo($t);
	$p_arr = explode("/", $p['dirname']);
	if (eregi("pending", $p_arr[count($p_arr)-1]))
	{
	unset($p_arr[count($p_arr)-1]);
	$p['dirname'] = implode("/", $p_arr);
	$LocalPath = $p['dirname']."/".$p['basename'];
	$i->Set("LocalPath", $LocalPath);
	}

	$t = $i->Get("ThumbPath");
	$p = pathinfo($t);

	$p_arr = explode("/", $p['dirname']);
	if (eregi("pending", $p_arr[count($p_arr)-1]))
	{
	unset($p_arr[count($p_arr)-1]);
	$p['dirname'] = implode("/", $p_arr);
	$ThumbPath = $p['dirname']."/".$p['basename'];
	$i->Set("ThumbPath", $ThumbPath);
	}

	$i->tablename = $edit_table;

	$update = 1;
	}

	## Empty the fields if are not used
	if (!$i->Get("LocalImage"))
	{
	$i->Set("LocalPath", "");
	$update = 1;
	}

	if (!$i->Get("LocalThumb"))
	{
	$i->Set("ThumbPath", "");
	$update = 1;
	}

	if ($update)
	$i->Update();

	}
	}

	function DeletePendingFiles($edit_table)
	{
	$sql = "SELECT * FROM ".$edit_table;
	$this->Clear();
	$this->Query_Item($sql);
	foreach($this->Items as $i)
	{
	$i->DeleteFromPending();
	}
	}

	function CopyToEditTable($idfield, $idlist)
	{
	global $objSession;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
	if(is_array($idlist))
	{
	$list = implode(",",$idlist);
	}
	else
	$list = $idlist;
	$query = "SELECT * FROM ".$this->SourceTable." WHERE $idfield IN ($list)";
	$insert = "CREATE TABLE ".$edit_table." ".$query;
	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo htmlentities($insert,ENT_NOQUOTES)."<br>\n";
	$this->adodbConnection->Execute($insert);
	$this->SourceTable = $edit_table;
	$this->CopyToPendingFiles();

	$this->UpdateFilenamesToPendings();
	}

	function UpdateFilenamesToPendings()
	{
	global $objSession;

	$edit_table = $this->SourceTable;

	$sql = "SELECT * FROM ".$edit_table." WHERE (LocalPath!='' AND LocalPath IS NOT NULL) OR (ThumbPath!='' AND ThumbPath IS NOT NULL)";
	$this->Clear();
	$this->Query_Item($sql);

	foreach($this->Items as $i)
	{
	$set = "";
	$ImageId = $i->Get("ImageId");

	## Update Local Image Path -> add "pending/" to PATH
	if (strlen($i->Get("LocalPath")))
	{
	$p = pathinfo($i->Get("LocalPath"));
	if (!eregi("/pending $", $p['dirname']))
	{
	$LocalPath = $p['dirname']."/pending/".$p['basename'];
	$set = "SET LocalPath='$LocalPath'";
	}
	}

	// echo "LocalImage: ".$i->Get("LocalImage").", PATH: ".$i->Get("LocalPath")."<BR>";

	## Update Local Thumb Path -> add "pending/" to PATH
	if (strlen($i->Get("ThumbPath")))
	{
	$p = pathinfo($i->Get("ThumbPath"));
	if (!eregi("/pending $", $p['dirname']))
	{
	$LocalThumb = $p['dirname']."/pending/".$p['basename'];
	if (strlen($set))
	$set.= ", ThumbPath='$LocalThumb'";
	else
	$set = "SET ThumbPath='$LocalThumb'";
	}
	}

	// echo "LocalThumb: ".$i->Get("LocalThumb").", PATH: ".$i->Get("ThumbPath")."<BR>";

	if (strlen($set))
	{
	$sql = "UPDATE $edit_table $set WHERE ImageId=$ImageId";
	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";
	$this->adodbConnection->Execute($sql);
	}
	}
	}

	function CopyFromEditTable($idfield)
	{
	global $objSession;
	$GLOBALS['_CopyFromEditTable']=1;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	$dummy =& $this->GetDummy();
	if( !$dummy->TableExists($edit_table) )
	{
	echo 'ERROR: Table "<b>'.$edit_table.'</b>" missing (class: <b>'.get_class($this).'</b>)<br>';
	//exit;
	return;
	}

	$rs = $this->adodbConnection->Execute("SELECT * FROM $edit_table WHERE ResourceId=0");
	while($rs && !$rs->EOF)
	{
	$id = $rs->fields["ImageId"];
	if($id>0)
	{
	$img = $this->GetItem($id);
	$img->Delete();
	}
	$rs->MoveNext();
	}
	$this->adodbConnection->Execute("DELETE FROM $edit_table WHERE ResourceId=0");
	$this->CopyFromPendingFiles($edit_table);
	parent::CopyFromEditTable($idfield);
	unset($GLOBALS['_CopyFromEditTable']);
	}

	function PurgeEditTable($idfield)
	{
	global $objSession;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	$this->DeletePendingFiles($edit_table);
	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
	}

	function GetNextImageIndex($ResourceId)
	{
	$sql = "SELECT MAX(ImageIndex) as MaxVal FROM ".$this->SourceTable." WHERE ResourceId=".$ResourceId;
	$rs = $this->adodbConnection->Execute($sql);
	if($rs)
	{
	$val = (int)$rs->fields["MaxVal"];
	$val++;
	}
	return $val;
	}

	function GetMaxPriority($ResourceId)
	{
	$sql = "SELECT MAX(Priority) as p from ".$this->SourceTable."WHERE ResourceId=$ResourceId";
	$result = $this->adodbConnection->Execute($sql);
	return $result->fields["p"];
	}

	function GetMinPriority($ResourceId)
	{
	$sql = "SELECT MIN(Priority) as p from ".$this->SourceTable."WHERE ResourceId=$ResourceId";
	$result = $this->adodbConnection->Execute($sql);
	return $result->fields["p"];
	}

	} /clsImageList/

	?>

	Property changes on: trunk/kernel/include/image.php
	___________________________________________________________________
	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