openrat-cms

Value.class.php (45461B)

---

 <?php
 namespace cms\model;
 use ArrayUtils;
 use cms\publish\Publish;
 use MacroRunner;
 use \ObjectNotFoundException;
 use \Logger;
 use \Text;
 use \Html;
 use \Http;
 use \Transformer;
 use \Code;
 use util\FileCache;
 
 // OpenRat Content Management System
 // Copyright (C) 2002-2012 Jan Dankert, cms@jandankert.de
 //
 // This program is free software; you can redistribute it and/or
 // modify it under the terms of the GNU General Public License
 // as published by the Free Software Foundation; either version 2
 // of the License, or (at your option) any later version.
 //
 // This program is distributed in the hope that it will be useful,
 // but WITHOUT ANY WARRANTY; without even the implied warranty of
 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 // GNU General Public License for more details.
 //
 // You should have received a copy of the GNU General Public License
 // along with this program; if not, write to the Free Software
 // Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 
 
 
 /**
  * Darstellen einer Inhaltes
  *
  * @version $Revision$
  * @author $Author$
  * @package openrat.objects
  */
 
 class Value extends ModelBase
 {
 	/**
 	 * ID dieser Inhaltes
 	 * @type Integer
 	 */
 	var $valueid=0;
 
 	/**
 	 * Seiten-Objekt der ?bergeordneten Seite
 	 * @type Page
 	 */
 	var $page;
 	
 	/**
 	 * Seiten-Id der uebergeordneten Seite
 	 * @type Integer
 	 */
 	var $pageid;
 	
 	/**
 	 * Kennzeichen, ob der Inhalt mit dem Inhalt einer anderern Seite verkn�pft wird.
 	 * @type BaseObject
 	 */
 	var $isLink = false;
 	
 	/**
 	 * Objekt-ID, auf die verlinkt wird
 	 * @type Integer
 	 */
 	var $linkToObjectId=0;
 
 	/**
 	 * Text-Inhalt
 	 * @type String
 	 */
 	var $text='';
 	
 	/**
 	 * Zahl. Auch Flie?kommazahlen werden als Ganzzahl gespeichert
 	 * @type Integer
 	 */
 	var $number=0;
 
 	
 	/**
 	 * Datum als Unix-Timestamp
 	 * @type Integer
 	 */
 	var $date=0;
 	
 	/**
 	 * Element-Objekt
 	 * @type Element
 	 */
 	var $element;
 	
 	/**
 	 * Element-Id
 	 * @type Integer
 	 */
 	var $elementid;
 	
 	/**
 	 * Der eigentliche Inhalt des Elementes
 	 * @type String
 	 */
 	var $value;
 	
 	/**
 	 * TimeStamp der letzten Aenderung
 	 * @type Integer
 	 */
 	var $lastchangeTimeStamp;
 	
 	/**
 	 * Benutzer-ID der letzten Aenderung
 	 * @type Integer
 	 */
 	var $lastchangeUserId;
 
 	/**
 	 * Benutzername der letzten Aenderung
 	 * @type Integer
 	 */
 	var $lastchangeUserName;
 	
 	/**
 	 * Schalter, ob dieser Inhalt der aktive Inhalt ist
 	 * @type Boolean
 	 */
 	var $active;
 	
 	/**
 	 * @type Publish
 	 */
 	public $publisher;
 
 	/**
 	 * @type Publish
      * @deprecated use #publisher
 	 */
 	var $publish = false;
 
     /**
      * @type Boolean
      * @deprecated
      */
 	public $simple;
 
 
     /**
      * Sprach-Id.
      * @var int
      */
     public $languageid;
 
     /**
      * Format
      *
      * @var int
      */
     public $format = null;
 
     /**
 	 * Konstruktor
 	 */
 	function __construct()
 	{
 		$this->lastchangeUserId    = 0;
 		$this->lastchangeTimeStamp = 0;
 
 	}
 
 	
 
 	/**
 	 * Laden des aktuellen Inhaltes aus der Datenbank
 	 */
 	function load()
 	{
 		if	( $this->publisher->isPublic() )
 			$stmt = db()->sql( 'SELECT * FROM {{value}}'.
 			                '  WHERE elementid ={elementid}'.
 			                '    AND pageid    ={pageid}'.
 			                '    AND languageid={languageid}'.
 			                '    AND publish=1' );
 		else
 			$stmt = db()->sql( 'SELECT * FROM {{value}}'.
 			                '  WHERE elementid ={elementid}'.
 			                '    AND pageid    ={pageid}'.
 			                '    AND languageid={languageid}'.
 			                '    AND active=1' );
 		$stmt->setInt( 'elementid' ,$this->element->elementid );
 		$stmt->setInt( 'pageid'    ,$this->pageid    );
 		$stmt->setInt( 'languageid',$this->languageid);
 		$row = $stmt->getRow();
 		
 		if	( count($row) > 0 ) // Wenn Inhalt gefunden
 		{
 			$this->text           = $row['text'  ];
 			$this->format         = $row['format'];
 			$this->valueid        = intval($row['id']          );
 			$this->linkToObjectId = intval($row['linkobjectid']);
 			$this->number         = intval($row['number'      ]);
 			$this->date           = intval($row['date'        ]);
 	
 			$this->active         = ( $row['active' ]=='1' );
 			$this->publish        = ( $row['publish']=='1' );
 	
 			$this->lastchangeTimeStamp = intval($row['lastchange_date'  ]);
 			$this->lastchangeUserId    = intval($row['lastchange_userid']);
 		}
 	}
 
 
 	/**
 	 * Laden eines bestimmten Inhaltes aus der Datenbank
 	 */
 	function loadWithId( $valueid=0 )
 	{
 		if	( $valueid != 0 )
 			$this->valueid = $valueid;
 
 		$db = db_connection();
 
 		$sql = $db->sql( 'SELECT {{value}}.*,{{user}}.name as lastchange_username'.
 		                ' FROM {{value}}'.
 		                ' LEFT JOIN {{user}} ON {{user}}.id={{value}}.lastchange_userid'.
 		                '  WHERE {{value}}.id={valueid}' );
 		$sql->setInt( 'valueid',$this->valueid);
 		$row = $sql->getRow();
 		
 		$this->text           =        $row['text'        ];
         $this->format         =        $row['format'      ];
 		$this->pageid         = intval($row['pageid'      ]);
 		$this->elementid      = intval($row['elementid'   ]);
 		$this->languageid     = intval($row['languageid'  ]);
 		$this->valueid        = intval($row['id'          ]);
 		$this->linkToObjectId = intval($row['linkobjectid']);
 		$this->number         = intval($row['number'      ]);
 		$this->date           = intval($row['date'        ]);
 
 		$this->active         = ( $row['active' ]=='1' );
 		$this->publish        = ( $row['publish']=='1' );
 
 		$this->lastchangeTimeStamp = intval($row['lastchange_date'    ]);
 		$this->lastchangeUserId    = intval($row['lastchange_userid'  ]);
 		$this->lastchangeUserName  =        $row['lastchange_username'];
 	}
 
 
 	/**
 	 * Alle Versionen des aktuellen Inhaltes werden ermittelt
 	 * @return Array
 	 */
 	function getVersionList()
 	{
 		$db = db_connection();
 
 		$sql = $db->sql( 'SELECT {{value}}.*,{{user}}.name as lastchange_username'.
 		                '  FROM {{value}}'.
 		                '  LEFT JOIN {{user}} ON {{user}}.id={{value}}.lastchange_userid'.
 		                '  WHERE elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}'.
 		                '  ORDER BY lastchange_date' );
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		$list = array();
 		foreach($sql->getAll() as $row )
 		{
 			$val = new Value();
 			$val->valueid = $row['id'];
 			
 			$val->text           = $row['text'];
             $val->format         = $row['format'];
 			$val->valueid        = intval($row['id']          );
 			$val->linkToObjectId = intval($row['linkobjectid']);
 			$val->number         = intval($row['number'      ]);
 			$val->date           = intval($row['date'        ]);
 	
 			$val->active         = ( $row['active' ]=='1' );
 			$val->publish        = ( $row['publish']=='1' );
 	
 			$val->lastchangeTimeStamp = intval($row['lastchange_date'    ]);
 			$val->lastchangeUserId    = intval($row['lastchange_userid'  ]);
 			$val->lastchangeUserName  = $row['lastchange_username'];
 			$list[] = $val;
 		}
 		return $list;
 	}
 
 
 	/**
 	 * Die Anzahl der Versionen des aktuellen Inhaltes wird ermittelt
 	 * @return Array
 	 */
 	function getCountVersions()
 	{
 		$db = db_connection();
 
 		$sql = $db->sql( 'SELECT COUNT(*) FROM {{value}}'.
 		                '  WHERE elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}' );
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		return $sql->getOne();
 	}
 
 
 	function getLastChangeTime()
 	{
 		$db = db_connection();
 
 		$sql = $db->sql( 
 <<<SQL
 	SELECT lastchange_date FROM {{value}}
 		WHERE elementid ={elementid}
 		  AND pageid    ={pageid}
 		  AND languageid={languageid}
 		  ORDER BY id DESC
 SQL
 		);
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		return $sql->getOne();
 	}
 	
 	
 	
 	/**
 	 * Inhalt freigeben
 	 */
 	function release()
 	{
 		$db = db_connection();
 
 		$sql = $db->sql( 'UPDATE {{value}}'.
 		                '  SET publish=0'.
 		                '  WHERE elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}' );
 		$sql->setInt( 'elementid' ,$this->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		$sql->query();
 
 		$sql = $db->sql( 'UPDATE {{value}}'.
 		                '  SET publish=1'.
 		                '  WHERE active    = 1'.
 		                '    AND elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}' );
 		$sql->setInt( 'elementid' ,$this->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		$sql->query();
 	}
 
 	/**
 	 * Inhalt speichern
 	 */
 	function save()
 	{
 		$db = db_connection();
 
 		$sql = $db->sql( 'UPDATE {{value}}'.
 		                '  SET active=0'.
 		                '  WHERE elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}' );
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 
 		$sql->query();
 
 		if	( $this->publish )
 		{
 			// Wenn Inhalt sofort veroeffentlicht werden kann, dann
 			// alle anderen Inhalte auf nicht-veroeffentlichen stellen 
 			$sql = $db->sql( 'UPDATE {{value}}'.
 			                '  SET publish=0'.
 			                '  WHERE elementid ={elementid}'.
 			                '    AND pageid    ={pageid}'.
 			                '    AND languageid={languageid}' );
 			$sql->setInt( 'elementid' ,$this->element->elementid );
 			$sql->setInt( 'pageid'    ,$this->pageid    );
 			$sql->setInt( 'languageid',$this->languageid);
 
 			$sql->query();
 		}
 
 		// Naechste ID aus Datenbank besorgen
 		$sql = $db->sql('SELECT MAX(id) FROM {{value}}');
 		$this->valueid = intval($sql->getOne())+1;
 
 		$sql = $db->sql( <<<SQL
 INSERT INTO {{value}}
             (id       ,linkobjectid  ,text  ,number  ,date  ,elementid  ,format  ,pageid  ,languageid  ,active,publish  ,lastchange_date  ,lastchange_userid  )
      VALUES ({valueid},{linkobjectid},{text},{number},{date},{elementid},{format},{pageid},{languageid},1     ,{publish},{lastchange_date},{lastchange_userid})
 SQL
 		);
 		$sql->setInt( 'valueid'   ,$this->valueid            );
 		$sql->setInt( 'format'    ,$this->format             );
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid             );
 		$sql->setInt( 'languageid',$this->languageid         );
 
 		if	( intval($this->linkToObjectId)==0)
 			$sql->setNull  ( 'linkobjectid' );
 		else	$sql->setInt   ( 'linkobjectid',$this->linkToObjectId   );
 
 		if	( $this->text == '' )
 			$sql->setNull  ( 'text' );
 		else	$sql->setString( 'text',$this->text );
 
 		if	( intval($this->number)==0)
 			$sql->setNull  ( 'number' );
 		else	$sql->setInt   ( 'number',$this->number );
 
 		if	( intval($this->date)==0)
 			$sql->setNull  ( 'date' );
 		else	$sql->setInt   ( 'date',$this->date );
 
 		$sql->setBoolean( 'publish'          ,$this->publish );
 		$sql->setInt    ( 'lastchange_date'  ,now()         );
 		$user = \Session::getUser();
 		$sql->setInt    ( 'lastchange_userid',$user->userid  );
 
 		$sql->query();
 		
 		// Nur ausfuehren, wenn in Konfiguration aktiviert.
 		$limit = config('content','revision-limit');
 		if	( isset($limit['enabled']) && $limit['enabled'] )
 			$this->checkLimit();
 	}
 
 	
 	/**
 	 * Pruefen, ob maximale Anzahl von Versionen erreicht.
 	 * In diesem Fall die zu alten Versionen l�schen.
 	 */
 	function checkLimit()
 	{
 		$limit = config('content','revision-limit');
 
 		$db = db_connection();
 
 		$sql = $db->sql( <<<SQL
 		SELECT id FROM {{value}}
 			                  WHERE elementid  = {elementid}
 			                    AND pageid     = {pageid}
 			                    AND languageid = {languageid}
 			                    AND active     = 0
 			                    AND publish    = 0
 			                   ORDER BY id
 SQL
 		);
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid             );
 		$sql->setInt( 'languageid',$this->languageid         );
 		$values = $sql->getCol();
 		
 		if	( count($values) > $limit['min-revisions'] )
 		{
 			$sql = $db->sql( <<<SQL
 			DELETE FROM {{value}}
 				                  WHERE elementid  = {elementid}
 				                    AND pageid     = {pageid}
 				                    AND languageid = {languageid}
 				                    AND active     = 0
 				                    AND publish    = 0
 				                    AND lastchange_date < {min_date}
 				                    AND id              < {min_id}
 SQL
 			);
 			$sql->setInt( 'elementid' ,$this->element->elementid );
 			$sql->setInt( 'pageid'    ,$this->pageid             );
 			$sql->setInt( 'languageid',$this->languageid         );
 			$sql->setInt( 'min_date'  ,$limit['max-age']*24*60*60);
 			$sql->setInt( 'min_id'    ,$values[count($values)-$limit['min-revisions']]);
 			$sql->query();
 		}
 		
 		if	( count($values) > $limit['max-revisions'] )
 		{
 			$sql = $db->sql( <<<SQL
 			DELETE FROM {{value}}
 				                  WHERE elementid  = {elementid}
 				                    AND pageid     = {pageid}
 				                    AND languageid = {languageid}
 				                    AND active     = 0
 				                    AND publish    = 0
 				                    AND lastchange_date < {min_date}
 				                    AND id              < {min_id}
 SQL
 			);
 			$sql->setInt( 'elementid' ,$this->element->elementid );
 			$sql->setInt( 'pageid'    ,$this->pageid             );
 			$sql->setInt( 'languageid',$this->languageid         );
 			$sql->setInt( 'min_date'  ,$limit['min-age']*24*60*60);
 			$sql->setInt( 'min_id'    ,$values[count($values)-$limit['max-revisions']]);
 			$sql->query();
 		}
 	}
 
 	
 	
 	/**
 	 * Diesen Inhalt loeschen
 	 */
 	function delete()
 	{
 		$db = db_connection();
 		$sql = $db->sql( 'DELETE * FROM {{value}}'.
 		                '  WHERE elementid ={elementid}'.
 		                '    AND pageid    ={pageid}'.
 		                '    AND languageid={languageid}' );
 		$sql->setInt( 'elementid' ,$this->element->elementid );
 		$sql->setInt( 'pageid'    ,$this->pageid    );
 		$sql->setInt( 'languageid',$this->languageid);
 		$row = $sql->getRow();
 	}
 
 
 	public function generate() {
 
 	    return $this->getCache()->get();
     }
 
 
     /**
      *
      * @return FileCache
      */
     public function getCache() {
 
         $cacheKey = array('db'=>db()->id,
             'value'=>$this->valueid,
             'page' =>is_object($this->page)?$this->page->objectid:0,
             'el'=>is_object($this->element)?$this->element->elementid:0,
             'language'=>$this->languageid,
             'model' =>is_object($this->page)?$this->page->modelid:0,
             'publish'=>\ClassUtils::getSimpleClassName($this->publisher) );
         return new FileCache( $cacheKey,function() {
             return $this->generateValue();
         },$this->lastchangeTimeStamp );
     }
 
 	/**
 	 * Hier findet die eigentliche Bereitstellung des Inhaltes statt, zu
 	 * jedem Elementtyp wird ein Inhalt ermittelt.
 	 * 
 	 * @return void (aber Eigenschaft 'value' wird gesetzt).
 	 */
 	private function generateValue()
 	{
 		global $conf;
 
 		if	( intval($this->valueid)==0 )
 			$this->load();
 	
 		$inhalt = '';
 		$raw    = false;
 		
 		global $conf;
 
 		// Inhalt ist mit anderer Seite verkn�pft.
 		if	( in_array($this->element->typeid,[Element::ELEMENT_TYPE_TEXT,Element::ELEMENT_TYPE_LONGTEXT,Element::ELEMENT_TYPE_DATE,Element::ELEMENT_TYPE_NUMBER]) && intval($this->linkToObjectId) != 0 && !$this->isLink )
 		{
 			$linkedPage = new Page( $this->linkToObjectId );
 			$linkedPage->load();
 			
 			$linkedValue = new Value();
 			$linkedValue->isLink     = true;
 			$linkedValue->pageid     = $linkedPage->pageid;
 			$linkedValue->page       = $linkedPage;
 			$linkedValue->element    = $this->element;
 			$linkedValue->languageid = $this->languageid;
 			$linkedValue->publisher  = $this->publisher;
 			//$v->modelid    = $this->modelid;
 			$linkedValue->load();
 			$linkedValue->generate();
 			$this->value = $linkedValue->value;
 			return;
 		}
 		
 		switch( $this->element->typeid )
 		{
             case Element::ELEMENT_TYPE_INSERT:
 
 				$objectid = $this->linkToObjectId;
 
 				if   ( intval($objectid) == 0 )
 					$objectid = $this->element->defaultObjectId;
 				
 				if	( ! BaseObject::available( $objectid) )
 					return;
 					
 				$object = new BaseObject( $objectid );
 				$object->objectLoadRaw();
 				
 				if	( $object->isFolder )
 				{
 					if   ( $this->publisher->isSimplePreview() )
 					{
 						$f = new Folder( $objectid );
 						$f->load();
 						$inhalt = $f->filename;
 						unset( $f );
 					}
 					else
 					{
 						if	( $objectid != $this->page->objectid ) // Rekursion vermeiden
 						{
 							$f = new Folder( $objectid );
 							foreach( $f->getObjectIds() as $oid )
 							{
 								if	( $oid != $this->page->objectid )  // Rekursion vermeiden
 								{
 									switch( $this->element->subtype )
 									{
 										case '':
 										case 'inline':
 											$o = new BaseObject( $oid );
 											$o->load();
 											switch( $o->typeid )
 											{
 												case BaseObject::TYPEID_PAGE:
 													$p = new Page( $oid );
 													$p->enclosingObjectId = $this->page->id;
 													$p->public         = $this->page->publisher->isPublic();
 													$p->modelid        = $this->page->modelid;
 													$p->languageid     = $this->languageid;
 													$p->mime_type      = $this->page->mimeType();
 													$p->load();
 													$p->generate();
 													$inhalt .= $p->value;
 													unset( $p );
 													break;
 												case BaseObject::TYPEID_LINK:
 													$l = new Link( $oid );
 													$l->load();
 													if	( $l->isLinkToObject )
 													{
 														$op = new BaseObject( $l->linkedObjectId );
 														$op->load();
 														if	( $op->isPage )
 														{
 															$p = new Page( $l->linkedObjectId );
 															$p->enclosingObjectId = $this->page->id;
 															$p->public         = $this->page->publisher->isPublic();
 															$p->modelid        = $this->page->modelid;
 															$p->languageid     = $this->languageid;
 															$p->load();
 															$p->generate();
 															$inhalt .= $p->value;
 															unset( $p );
 														}
 													}
 													break;
 											}
 											break;
 
 										case 'ssi':
 											$inhalt .= '<!--#include virtual="'.$this->page->path_to_object($oid).'" -->'; 
 											break;
 
 										default:
 											$inhalt = '?'.$this->element->subtype.'?';
 									}
 								}
 								else throw new \LogicException('FATAL: recursion detected');
 							}
 						}
 						else throw new LogicException('FATAL: recursion detected');
 					}
 				}
 				elseif	( $object->isPage )
 				{
 					if   ( $this->publisher->isSimplePreview() )
 					{
 						$p = new Page( $objectid );
 						$p->load();
 						$inhalt = $p->filename;
 						unset( $p );
 					}
 					else
 					{
 						if	( $objectid != $this->page->objectid ) // Rekursion vermeiden
 						{
 							switch( $this->element->subtype )
 							{
 								case '':
 								case 'inline':
 									$p = new Page( $objectid );
 									$p->enclosingObjectId = $this->page->id;
 									$p->publisher        = $this->page->publisher;
 									$p->modelid        = $this->page->modelid;
 									$p->languageid     = $this->languageid;
 									$p->mime_type      = $this->page->mimeType();
 									$p->load();
 									$p->generate();
 									$inhalt = $p->value;
 									unset( $p );
 									break;
 									
 								case 'ssi':
 									$inhalt = '<!--#include virtual="'.$this->page->path_to_object($objectid).'" -->'; 
 									break;
 									
 								default:
 									$inhalt = '?'.$this->element->subtype.'?';
 									break;
 							}
 						}
 						else throw new LogicException('FATAL: recursion detected');
 					}
 				}
 
 				if	( $this->publisher->isSimplePreview() )
 				{
 					$inhalt = strip_tags( $inhalt );
 					$inhalt = str_replace( "\n",'',$inhalt );
 					$inhalt = str_replace( "\r",'',$inhalt );
 				}
 				
 				break;
 
 
 			case Element::ELEMENT_TYPE_LINK:
 
 				$objectid = $this->linkToObjectId;
 				if   ( intval($objectid) == 0 )
 					$objectid = $this->element->defaultObjectId;
 	
 				if   ( $objectid==0 )
 				{
 					// Link noch nicht gefuellt
 					$inhalt = '';
 				}
 				elseif	 ( ! BaseObject::available($objectid) )
 				{
 					$inhalt = $this->publisher->isSimplePreview()?'-':'';
 				}
 				elseif   ( $this->publisher->isSimplePreview() )
 				{
 					$o = new BaseObject( $objectid );
 					$o->load();
 					$inhalt = $o->filename;
 				}
 				elseif	($this->element->subtype == 'image_data_uri' )
 				{
 					$file = new File($objectid);
 					$file->load();
 					$inhalt = 'data:'.$file->mimeType().';base64,'.base64_encode($file->loadValue());
 				}
 				else
 				{
 					$inhalt = $this->page->path_to_object( $objectid );
 				}
 				
 				break;
 
 
 			case Element::ELEMENT_TYPE_COPY:
 
 				list($linkElementName,$targetElementName) = explode('%',$this->element->name.'%');
 
 				if	( empty($targetElementName) )
 					break;
 
 				$element = new Element();
 				$element->name = $linkElementName;
 				$element->load();
 				
 				if	( intval($element->elementid)==0 )
 					break;
 				
 				$linkValue = new Value();
 				$linkValue->elementid = $element->elementid;
 				$linkValue->element   = $element;
 				$linkValue->pageid = $this->pageid;
 				$linkValue->page   = $this->page;
 				$linkValue->languageid = $this->languageid;
 				$linkValue->load();
 				
 				if	( !BaseObject::available( $linkValue->linkToObjectId ) )
 					break;
 
 				$linkedPage = new Page( $linkValue->linkToObjectId );
 				$linkedPage->load();
 
 				$linkedPageTemplate = new Template( $linkedPage->templateid );
 				$targetElementId = array_search( $targetElementName, $linkedPageTemplate->getElementNames() );
 				
 				if	( intval($targetElementId)==0 )
 					break;
 
 				$targetValue = new Value();
 				$targetValue->elementid = $targetElementId;
 				$targetValue->element = new Element($targetElementId);
 				$targetValue->element->load();
 				$targetValue->pageid = $linkedPage->pageid;
 				$targetValue->page   = $linkedPage;
 				$targetValue->generate();
 				
 				$inhalt = $targetValue->value; 
 				
 				break;
 
 
 			case Element::ELEMENT_TYPE_LINKINFO:
 
 				@list( $linkElementName, $name ) = explode('%',$this->element->name);
 				if	( is_null($name) )
 					break;
 
 				$template = new Template( $this->page->templateid );
 				$elementId = array_search( $linkElementName, $template->getElementNames() );
 				
 					
 				$element = new Element($elementId);
 				$element->load();
 				
 				$linkValue = new Value();
 				$linkValue->elementid = $element->elementid;
 				$linkValue->element   = $element;
 				$linkValue->pageid = $this->pageid;
 				$linkValue->languageid = $this->languageid;
 				$linkValue->publisher  = $this->publisher;
 				$linkValue->load();
 				
 				$objectid = $linkValue->linkToObjectId;
 				
 				if   ( intval($objectid) == 0 )
 					$objectid = $linkValue->element->defaultObjectId;
 					
 				if	( !BaseObject::available( $objectid ) )
 					break;
 					
 				$linkedObject = new BaseObject( $objectid );
 				$linkedObject->languageid = $this->languageid;
 				$linkedObject->load();
 				
 				switch( $this->element->subtype )
 				{
 					case 'width':
 						$f = new Image( $objectid );
 						$f->load();
 						if	( $f->isImage() )
 						{
 							$f->getImageSize();
 							$inhalt = $f->width;
 						}
 						unset($f);
 						break;
 					
 					case 'height':
 						$f = new Image( $objectid );
 						$f->load();
 						if	( $f->isImage() )
 						{
 							$f->getImageSize();
 							$inhalt = $f->height;
 						}
 						unset($f);
 						break;
 					
 					case 'id':
 						$inhalt = $objectid;
 						break;
 					
 					case 'name':
 						$inhalt = $linkedObject->name;
 						break;
 					
 					case 'description':
 						$inhalt = $linkedObject->description;
 						break;
 					
 					case 'create_user_desc':
 						$user = $linkedObject->createUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->desc;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'create_user_fullname':
 						$user = $linkedObject->createUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->fullname;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'create_user_mail':
 						$user = $linkedObject->createUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->mail;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'create_user_tel':
 						$user = $linkedObject->createUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->tel;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'create_user_username':
 						$user = $linkedObject->createUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->name;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'lastch_user_desc':
 						$user = $linkedObject->lastchangeUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->desc;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'lastch_user_fullname':
 						$user = $linkedObject->lastchangeUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->fullname;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'lastch_user_mail':
 						$user = $linkedObject->lastchangeUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->mail;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 					
 					case 'lastch_user_tel':
 						$user = $linkedObject->lastchangeUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->tel;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						
 						break;
 					
 					case 'lastch_user_username':
 						$user = $linkedObject->lastchangeUser;
 						try
 						{
 							$user->load();
 							$inhalt = $user->name;
 						}
 						catch( ObjectNotFoundException $e )
 						{
 						}
 						break;
 						
 					case 'mime-type':
 						if	( $linkedObject->isFile || $linkedObject->isImage || $linkedObject->isText  )
 						{
 							$f = new File( $objectid );
 							$f->load();
 								$inhalt = $f->mimeType();
 							unset($f);
 						}
 						break;
 					
 					case 'filename':
 						$inhalt = $linkedObject->filename();
 						break;
 					
 					case 'full_filename':
 						$inhalt = $linkedObject->full_filename();
 						break;
 					
 					default:
 						$inhalt = ''; 
 						Logger::error('subtype for linkinfo not implemented:'.$this->element->subtype);
 				}			
 				
 				break;
 
 			case Element::ELEMENT_TYPE_LINKDATE:
 
 				@list( $linkElementName, $name ) = explode('%',$this->element->name);
 				if	( is_null($name) )
 					break;
 
 				$template = new Template( $this->page->templateid );
 				$elementId = array_search( $linkElementName, $template->getElementNames() );
 					
 				$element = new Element($elementId);
 				$element->load();
 				
 				$linkValue = new Value();
 				$linkValue->elementid = $element->elementid;
 				$linkValue->element   = $element;
 				$linkValue->pageid = $this->pageid;
 				$linkValue->languageid = $this->languageid;
 				$linkValue->load();
 				
 				$objectid = $linkValue->linkToObjectId;
 				
 				if   ( intval($objectid) == 0 )
 					$objectid = $linkValue->element->defaultObjectId;
 					
 				if	( !BaseObject::available( $objectid ) )
 					break;
 					
 				$linkedObject = new BaseObject( $objectid );
 				$linkedObject->load();
 				
 				
 				switch( $this->element->subtype )
 				{
 					case 'date_published':
 						// START_TIME wird zu Beginn im Controller gesetzt.
 						// So erh�lt jede Datei das gleiche Ver�ffentlichungsdatum.
 						$date = START_TIME;
 						break;
 						
 					case 'date_saved':
 						$date = $linkedObject->lastchangeDate;
 						break;
 
 					case 'date_created':
 						$date = $linkedObject->createDate;
 						break;
 
 					default:  
 						Logger::warn('element:'.$this->element->name.', '.
 						             'type:'.$this->element->type.', '.
 						             'unknown subtype:'.$this->element->subtype);
 						$date = START_TIME;
 				}
 				
 				if	( strpos($this->element->dateformat,'%')!==FALSE )
 					$inhalt = strftime( $this->element->dateformat,$date );
 				else
 					$inhalt = date    ( $this->element->dateformat,$date );				
 				break;
 				
 			case Element::ELEMENT_TYPE_LONGTEXT:
 			case Element::ELEMENT_TYPE_TEXT:
 			case Element::ELEMENT_TYPE_SELECT:
 
 				$inhalt = $this->text;
 				$format = $this->format;
 
 				// Wenn Inhalt leer, dann versuchen, den Inhalt der Default-Sprache zu laden.
 				if   ( $inhalt == '' && $conf['content']['language']['use_default_language'] )
 				{
 					$project = new Project($this->page->projectid);
 					$this->languageid = $project->getDefaultLanguageId();
 					$this->load();
 					$inhalt = $this->text;
 				}
 				
 				// Wenn Inhalt leer, dann Vorbelegung verwenden
 				if   ( $inhalt == '' )  {
 
 					$inhalt = $this->element->defaultText;
 					$format = $this->element->format;
 				}
 
 				// Wenn HTML nicht erlaubt und Wiki-Formatierung aktiv, dann einfache HTML-Tags in Wiki umwandeln
                 $pageIsHtml = $this->page->isHtml();
 
                 //
 				switch( $format )
 				{
                     case Element::ELEMENT_FORMAT_TEXT:
                     case Element::ELEMENT_FORMAT_HTML:
 
                         if   ( !$this->element->html )
                         {
                             // HTML not allowed.
                             $inhalt = Text::encodeHtml( $inhalt );
                             $inhalt = Text::encodeHtmlSpecialChars( $inhalt );
                         }
 
                         break;
 
                     case Element::ELEMENT_FORMAT_WIKI:
 
                         if   ( $conf['editor']['wiki']['convert_bbcode'] )
                             $inhalt = Text::bbCode2Wiki( $inhalt );
 
                         if   ( !$this->element->html && $conf['editor']['wiki']['convert_html'] && $pageIsHtml)
                             $inhalt = Text::html2Wiki( $inhalt );
 
                         $transformer = new Transformer();
                         $transformer->text    = $inhalt;
                         $transformer->page    = $this->page;
                         $transformer->element = $this->element;
 
                         $transformer->transform();
                         $inhalt = $transformer->text;
                         break;
 
                     case Element::ELEMENT_FORMAT_MARKDOWN:
 
                         $mdConfig = Config()->subset('editor')->subset('markdown');
 
                         $parser = new \Parsedown();
                         $parser->setUrlsLinked( $mdConfig->is('urls-linked',true));
                         $parser->setMarkupEscaped( !$this->element->html );
 
                         $inhalt = $parser->parse( $inhalt );
                         break;
 
                     default:
                         throw new \LogicException('Unknown format: '.$this->format );
                 }
 
 				if   ( $this->publisher->isSimplePreview() )
 				{
 				    // Simple Preview with bare text.
 					$inhalt = strip_tags( $inhalt );
 					$inhalt = str_replace( "\n",'',$inhalt );
 					$inhalt = str_replace( "\r",'',$inhalt );
 				}
 
 				// "__OID__nnn__" ersetzen durch einen richtigen Link
 				foreach( Text::parseOID($inhalt) as $oid=>$t )
 				{
 					$url    = $this->page->path_to_object($oid);
 
 					foreach( $t as $match )
 					    $inhalt = str_replace($match,$url,$inhalt);
 				}
 
 				break;
 
 
 			// Zahl
 			//
 			// wird im entsprechenden Format angezeigt.
 			case Element::ELEMENT_TYPE_NUMBER:
 
 				if   ( $this->number == 0 )
 				{
 					// Zahl ist gleich 0, dann Default-Text
 					$inhalt = $this->element->defaultText;
 					break;
 				}
 	
 				$number = $this->number / pow(10,$this->element->decimals);
 				$inhalt = number_format( $number,$this->element->decimals,$this->element->decPoint,$this->element->thousandSep );
 	
 				break;
 	
 	
 			// Datum
             case Element::ELEMENT_TYPE_DATE:
 
 				$date = $this->date;
 
 				if   ( intval($date) == 0 )
 				{
 					// Datum wurde noch nicht eingegeben
 					$inhalt = $this->element->defaultText;
 					break;
 				}
 
 				// Datum gemaess Elementeinstellung formatieren
 				if	( strpos($this->element->dateformat,'%')!==FALSE )
 					$inhalt = strftime( $this->element->dateformat,$date );
 				else
 					$inhalt = date    ( $this->element->dateformat,$date );
 				break;
 
 
 			// Programmcode (PHP)
 			case Element::ELEMENT_TYPE_CODE:
 
 				if   ( $this->publisher->isSimplePreview() )
 					break;
 
 				// Die Ausführung von benutzer-erzeugtem PHP-Code kann in der
 				// Konfiguration aus Sicherheitsgründen deaktiviert sein.
 				if	( $conf['security']['disable_dynamic_code'] )
                 {
                     Logger::warn("Execution of dynamic code elements is disabled by configuration. Set security/disable_dynamic_code to true to allow this");
                     break;
                 }
 
 				$this->page->load();
 
 				// Das Ausführen geschieht über die Klasse "Code".
 				// In dieser wird der Code in eine Datei geschrieben und
 				// von dort eingebunden.
 				$code = new Code();
 				$code->setContextPage($this->page );
 				$code->code = $this->element->code;
 
                 ob_start();
 
                 // Jetzt ausfuehren des temporaeren PHP-Codes
                 $code->execute();
 
                 $output = ob_get_contents();
                 ob_end_clean();
 
                 // Ausgabe ermitteln.
                 $inhalt = $output;
 
 
                 break;
 
 
 			// Makros (dynamische Klassen)
 			case Element::ELEMENT_TYPE_DYNAMIC:
 
 				if   ( $this->publisher->isSimplePreview() )
 					break;
 
 				$this->page->load();
 				$macroName     = $this->element->subtype;
 				$macroSettings = $this->element->getDynamicParameters();
 
 				$runner = new MacroRunner();
 				try {
 					$inhalt .= $runner->executeMacro($macroName, $macroSettings,$this->page);
 				}
 				catch( \OpenRatException $e ) {
 					if	( !$this->publisher->isPublic() )
 						$inhalt = lang($e->key).' ('.$e->getMessage().')'; // Inform the viewer
 					else
 						; // Keep empty value in public mode.
 				}
 
 				// Wenn HTML-Ausgabe, dann Sonderzeichen in HTML �bersetzen
 				if   ( $this->page->isHtml() )
 					$inhalt = Text::encodeHtmlSpecialChars( $inhalt );
 				
 				break;
 
 
 			// Info-Feld als Datum
 			case Element::ELEMENT_TYPE_INFODATE:
 
 				if   ( $this->publisher->isSimplePreview() )
 					break;
 				
 				switch( $this->element->subtype )
 				{
 					case 'date_published':
 						// START_TIME wird zu Beginn im Controller gesetzt.
 						// So erh�lt jede Datei das gleiche Ver�ffentlichungsdatum.
 						$date = START_TIME;
 						break;
 						
 					case 'date_saved':
 						$date = $this->page->lastchangeDate;
 						break;
 
 					case 'date_created':
 						$date = $this->page->createDate;
 						break;
 
 					default:  
 						Logger::warn('element:'.$this->element->name.', '.
 						             'type:'.$this->element->type.', '.
 						             'unknown subtype:'.$this->element->subtype);
 						if	( !$this->publisher->isPublic() )
 							$inhalt = lang('ERROR_IN_ELEMENT');
 				}
 				
 				if	( strpos($this->element->dateformat,'%')!==FALSE )
 					$inhalt = strftime( $this->element->dateformat,$date );
 				else
 					$inhalt = date    ( $this->element->dateformat,$date );				
 
 				break;
 
 
 			// Info-Feld
 			case Element::ELEMENT_TYPE_INFO:
 
 				if   ( $this->publisher->isSimplePreview() )
 					break;
 
 				switch( $this->element->subtype )
 				{
 					case 'db_id':
 						$inhalt = $SESS['dbid'];
 						break;
 					case 'db_name':
 						$inhalt = $conf['database_'.$SESS['dbid']]['description'];
 						break;
 					case 'project_id':
 						$inhalt = $this->page->projectid;
 						break;
 					case 'project_name':
 						$inhalt = Project::create( $this->page->projectid )->load()->name;
 						break;
 					case 'language_id':
 						$inhalt = $this->page->languageid;
 						break;
 					case 'language_iso':
 						$language = new Language( $this->page->languageid );
 						$language->load();
 						$inhalt = $language->isoCode;
 						break;
 					case 'language_name':
 						$language = new Language( $this->page->languageid );
 						$language->load();
 						$inhalt = $language->name;
 						break;
 					case 'page_id':
 						$inhalt = $this->page->objectid;
 						break;
 					case 'page_name':
 						$inhalt = $this->page->name;
 						break;
 					case 'page_desc':
 						$inhalt = $this->page->desc;
 						break;
 					case 'page_fullfilename':
 						$inhalt = $this->page->full_filename();
 						break;
 					case 'page_filename':
 						$inhalt = $this->page->filename();
 						break;
 					case 'page_extension':
 						$inhalt = '';
 						break;
 					case 'edit_url':
 						$raw = true;
 						$db = \Session::getDatabase();
 						$inhalt = Html::url('page',null,$this->page->objectid,array('dbid'=>$db->id));
 						break;
 					case 'edit_fullurl':
 						$raw = true;
 						$inhalt = Http::getServer();
 
 						// Der Link soll nicht auf die API, sondern auf das UI zeigen.
 						if   ( substr($inhalt,-4) == 'api/' )
 						    $inhalt = substr($inhalt,0,-4);
 
 						$db = db();
 						$inhalt .= '/#/page/'.$this->page->objectid;
 						break;
 					case 'lastch_user_username':
 						$user = $this->page->lastchangeUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->name;
 						break;
 					case 'lastch_user_fullname':
 						$user = $this->page->lastchangeUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->fullname;
 						break;
 					case 'lastch_user_mail':
 						$user = $this->page->lastchangeUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->mail;
 						break;
 					case 'lastch_user_desc':
 						$user = $this->page->lastchangeUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->desc;
 						break;
 					case 'lastch_user_tel':
 						$user = $this->page->lastchangeUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->tel;
 						break;
 
 					case 'create_user_username':
 						$user = $this->page->createUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->name;
 						break;
 					case 'create_user_fullname':
 						$user = $this->page->createUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->fullname;
 						break;
 					case 'create_user_mail':
 						$user = $this->page->createUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->mail;
 						break;
 					case 'create_user_desc':
 						$user = $this->page->createUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->desc;
 						break;
 					case 'create_user_tel':
 						$user = $this->page->createUser;
 						if   ( $user->userid )
 							$user->load();
 						$inhalt = $user->tel;
 						break;
 
 					case 'act_user_username':
 						$user = \Session::getUser();
 						if   ( $user )
 							$inhalt = $user->name;
 						break;
 					case 'act_user_fullname':
 						$user = \Session::getUser();
 						if   ( $user )
 							$inhalt = $user->fullname;
 						break;
 					case 'act_user_mail':
 						$user = \Session::getUser();
 						if   ( $user )
 							$inhalt = $user->mail;
 						break;
 					case 'act_user_desc':
 						$user = \Session::getUser();
 						if   ( $user )
 							$inhalt = $user->desc;
 						break;
 					case 'act_user_tel':
 						$user = \Session::getUser();
 						if   ( $user )
 							$inhalt = $user->tel;
 						break;
 					default:
 						Logger::warn('element:'.$this->element->name.', '.
 						             'type:'.$this->element->type.', '.
 						             'unknown subtype:'.$this->element->subtype);
 						// Keine Fehlermeldung in erzeugte Seite schreiben. 
 				}
 
 				break;
 				
 			default:
 				// this should never happen in production.
 				if	( ! $this->publisher->isPublic() )
 				    // inform the user.
 					throw new \LogicException( 'Error in element '.$this->element->name.': '.
 				              'unknown type: '.$this->element->typeid.'');
 				else
 				    ; // do not crash the public publishing process.
 				
 		}
 
 		
 		switch( $this->element->type )
 		{
 			case 'longtext':
 			case 'text':
 			case 'select':
 				
 				if	( $conf['publish']['encode_utf8_in_html'] )
 					// Wenn HTML-Ausgabe, dann UTF-8-Zeichen als HTML-Code uebersetzen
 					if   ( $this->page->isHtml() )
 						$inhalt = translateutf8tohtml($inhalt);
 				break;
 				
 			default:
 		}
 
 					
 		
 		if   ( $this->page->icons && $this->element->withIcon && $this->page->isHtml() )
 		{
 			// Anklickbaren Link voranstellen.
 			$iconLink = '<a href="javascript:parent.openNewAction(\''.$this->element->name.'\',\'pageelement\',\''.$this->page->objectid.'_'.$this->element->elementid.'\');" title="'.$this->element->desc.'"><img src="'.OR_THEMES_DIR.$conf['interface']['theme'].'/images/icon_el_'.$this->element->type.IMG_ICON_EXT.'" border="0" align="left"></a>';
 			$inhalt   = $iconLink.$inhalt;
 		}
 		
 		$this->value = $inhalt;
 
 		return $this->value;
 	}
 
 
 	/**
 	  * Es werden Objekte mit einem Inhalt gesucht.
 	  * @param String Suchbegriff
 	  * @return Array Liste der gefundenen Objekt-IDs
 	  */
 	function getObjectIdsByValue( $text )
 	{
 		$db = db_connection();
 		
 		$sql = $db->sql( 'SELECT {{object}}.id FROM {{value}} '.
 		                ' LEFT JOIN {{page}} '.
 		                '   ON {{page}}.id={{value}}.pageid '.
 		                ' LEFT JOIN {{object}} '.
 		                '   ON {{object}}.id={{page}}.objectid '.
 		                ' WHERE {{value}}.text LIKE {text}'.
 		                '   AND {{value}}.languageid={languageid}'.
 		                '  ORDER BY {{object}}.lastchange_date DESC' );
 		                
 		$sql->setInt   ( 'languageid',$this->languageid );
 		$sql->setString( 'text'      ,'%'.$text.'%'     );
 		return $sql->getCol();
 	}
 
 
 	/**
 	  * Es werden Objekte mit einer UserId ermittelt
 	  * @param Integer Benutzer-Id der letzten ?nderung
 	  * @return Array Liste der gefundenen Objekt-IDs
 	  */
 	function getObjectIdsByLastChangeUserId( $userid )
 	{
 
 		$db = db_connection();
 		
 		$sql = $db->sql( 'SELECT {{object}}.id FROM {{value}} '.
 		                ' LEFT JOIN {{page}} '.
 		                '   ON {{page}}.id={{value}}.pageid '.
 		                ' LEFT JOIN {{object}} '.
 		                '   ON {{object}}.id={{page}}.objectid '.
 		                ' WHERE {{value}}.lastchange_userid={userid}'.
 		                '   AND {{value}}.languageid={languageid}'.
 		                '  ORDER BY {{object}}.lastchange_date DESC' );
 		$sql->setInt   ( 'languageid',$this->languageid );
 		$sql->setInt   ( 'userid'    ,$userid           );
 
 		return $sql->getCol();
 	}
 
 	
 
 	/**
 	  * Es wird das Objekt ermittelt, welches der Benutzer zuletzt ge�ndert hat.
 	  * 
 	  * @return Integer Objekt-Id
 	  */
 	public static function getLastChangedObjectByUserId( $userid )
 	{
 		$db = db_connection();
 		
 		$sql = $db->sql( <<<SQL
 SELECT {{object}}.id
   FROM {{value}} 
   LEFT JOIN {{page}} 
     ON {{page}}.id={{value}}.pageid 
   LEFT JOIN {{object}} 
     ON {{object}}.id={{page}}.objectid 
  WHERE {{value}}.lastchange_userid={userid}
  ORDER BY {{value}}.lastchange_date DESC
 SQL
 );
 		$sql->setInt   ( 'userid'    ,$userid           );
 		return $sql->getOne();
 	}
 	
 	
 	/**
 	  * Es wird das Objekt ermittelt, welches der Benutzer zuletzt ge�ndert hat.
 	  * 
 	  * @return Integer Objekt-Id
 	  */
 	public static function getLastChangedObjectInProjectByUserId( $projectid, $userid )
 	{
 		$db = db_connection();
 		
 		$sql = $db->sql( <<<SQL
 SELECT {{object}}.id
   FROM {{value}} 
   LEFT JOIN {{page}} 
     ON {{page}}.id={{value}}.pageid 
   LEFT JOIN {{object}} 
     ON {{object}}.id={{page}}.objectid 
  WHERE {{value}}.lastchange_userid={userid}
    AND {{object}}.projectid = {projectid}
  ORDER BY {{value}}.lastchange_date DESC
 SQL
 );
 		$sql->setInt   ( 'userid'    ,$userid     );
 		$sql->setInt   ( 'projectid' ,$projectid  );
 		return $sql->getOne();
 	}
 	
 	
 	/**
 	 * Ermittelt einen tempor�ren Dateinamen f�r diesen Inhalt. 
 	 */
 	function tmpfile()
 	{
 		$db = db_connection();
 		$filename = \FileUtils::getTempFileName(  );
 		return $filename;
 	}
 	
 	
 	
 	/**
 	 * Ermittelt den unbearbeiteten, "rohen" Inhalt.
 	 * 
 	 * @return mixed Inhalt
 	 */
 	public function getRawValue()
 	{
 		switch( $this->element->typeid )
 		{
 			case Element::ELEMENT_TYPE_LINK:
 				return $this->linkToObjectId;
 				
 			case Element::ELEMENT_TYPE_DATE;
 				return $this->date;
 				
 			default:
 				return $this->text;
 		}
 	}
 
 
     public function getName()
     {
         return '';
     }
 
 
     public function __toString()
 	{
 		return "Value: ".print_r($this,true);
 	}
 }