openrat-cms

commit bac6e0b556678bbd2dba43deb83bb2bb64f899a2
parent cc187d0c2f2639bfd6a03425da299c2d2d7039e0
Author: dankert <devnull@localhost>
Date:   Sat,  1 Dec 2007 18:50:10 +0100

Neue Methode "getLastChangedObjectByUserId()"

Diffstat:
objectClasses/Value.class.php
 | 
23
+++++++++++++++++++++++

1 file changed, 23 insertions(+), 0 deletions(-)
diff --git a/objectClasses/Value.class.php b/objectClasses/Value.class.php
@@ -1156,4 +1156,27 @@ SQL
 
 		return $db->getCol( $sql->query );
 	}
+
+	
+
+	/**
+	  * Es wird das Objekt ermittelt, welches der Benutzer zuletzt geändert hat.
+	  * 
+	  * @return Integer Objekt-Id
+	  */
+	function getLastChangedObjectByUserId( $userid )
+	{
+		$db = db_connection();
+		
+		$sql = new Sql( 'SELECT {t_object}.id FROM {t_value} '.
+		                ' LEFT JOIN {t_page} '.
+		                '   ON {t_page}.id={t_value}.pageid '.
+		                ' LEFT JOIN {t_object} '.
+		                '   ON {t_object}.id={t_page}.objectid '.
+		                ' WHERE {t_value}.lastchange_userid={userid}'.
+		                '  ORDER BY {t_object}.lastchange_date DESC' );
+		$sql->setInt   ( 'userid'    ,$userid           );
+
+		return $db->getOne( $sql->query );
+	}
 } 
\ No newline at end of file