openrat-cms

commit 151d752032a3e7a6c747bc54ce19e8b5df68a46b
parent 31057ff5a685251c6bc181e89ce8e820bd1e99a1
Author: dankert <devnull@localhost>
Date:   Sun,  2 May 2004 14:01:33 +0200

Funktion release() zum freigeben von Inhalten

Diffstat:
objectClasses/Value.class.php
 | 
36
+++++++++++++++++++++++++++++++++++-

1 file changed, 35 insertions(+), 1 deletion(-)
diff --git a/objectClasses/Value.class.php b/objectClasses/Value.class.php
@@ -20,7 +20,10 @@
 // Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 // ---------------------------------------------------------------------------
 // $Log$
-// Revision 1.4  2004-05-02 11:40:00  dankert
+// Revision 1.5  2004-05-02 12:01:33  dankert
+// Funktion release() zum freigeben von Inhalten
+//
+// Revision 1.4  2004/05/02 11:40:00  dankert
 // Freigabestatus der Seiteninhalte verarbeiten
 //
 // Revision 1.3  2004/04/24 18:11:28  dankert
@@ -494,6 +497,37 @@ class Value
 
 
 	/**
+	 * Inhalt freigeben
+	 */
+	function release()
+	{
+		$db = db_connection();
+
+		$sql = new Sql( 'UPDATE {t_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);
+
+		$db->query( $sql->query );
+
+		$sql = new Sql( 'UPDATE {t_value}'.
+		                '  SET publish=1'.
+		                '  WHERE active    = 1'.
+		                '    AND elementid ={elementid}'.
+		                '    AND pageid    ={pageid}'.
+		                '    AND languageid={languageid}' );
+		$sql->setInt( 'elementid' ,$this->element->elementid );
+		$sql->setInt( 'pageid'    ,$this->pageid    );
+		$sql->setInt( 'languageid',$this->languageid);
+
+		$db->query( $sql->query );
+	}
+
+	/**
 	 * Inhalt speichern
 	 */
 	function save()