openrat-cms

commit 3fe465591ec040fce71fc384f1dd77eb6ea5bb96
parent 548efde6ef66f08dff1c1ea8fd3ce21d5003f875
Author: Jan Dankert <develop@jandankert.de>
Date:   Sat,  6 Mar 2021 01:27:59 +0100

Fix: Adding links was broken.

Diffstat:
M
modules/cms/model/Link.class.php
 | 
25
+++++++++++++------------
M
modules/cms/model/Url.class.php
 | 
3
---

2 files changed, 13 insertions(+), 15 deletions(-)
diff --git a/modules/cms/model/Link.class.php b/modules/cms/model/Link.class.php
@@ -73,13 +73,20 @@ class Link extends BaseObject
      */
     public function save()
 	{
-		$db = \cms\base\DB::get();
+		$db = DB::get();
 		
-		$sql = $db->sql('UPDATE {{link}} SET '.
-		               '  link_objectid = {linkobjectid}'.
-		                ' WHERE objectid={objectid}' );
+		$sql = $db->sql( <<<SQL
+ 		UPDATE {{link}}
+ 		   SET link_objectid = {linkobjectid}
+		 WHERE objectid={objectid}
+SQL
+);
 		$sql->setInt   ('objectid'    ,$this->objectid );
-		$sql->setInt ('linkobjectid',$this->linkedObjectId );
+
+		if ( ! $this->linkedObjectId )
+			$sql->setNull('linkobjectid');
+		else
+			$sql->setInt ('linkobjectid',$this->linkedObjectId );
 
 		$sql->query();
 
@@ -117,14 +124,9 @@ class Link extends BaseObject
 		               ' VALUES( {linkid},{objectid},{linkobjectid} )' );
 		$stmt->setInt   ('linkid'      ,$this->linkid         );
 		$stmt->setInt   ('objectid'    ,$this->objectid       );
-
-		if ($this->linkedObjectId == 0)
-            $stmt->setNull('linkobjectid');
-		else
-            $stmt->setInt ('linkobjectid',$this->linkedObjectId );
+        $stmt->setNull  ('linkobjectid');
 
 		$stmt->query();
 	}	
 }
 
-?>-
\ No newline at end of file
diff --git a/modules/cms/model/Url.class.php b/modules/cms/model/Url.class.php
@@ -109,5 +109,3 @@ class Url extends BaseObject
 		$sql->query();
 	}	
 }
-
-?>-
\ No newline at end of file