X-Git-Url: https://git.llucax.com/mecon/intranet.git/blobdiff_plain/707e1370e56a9a9536a81aab72b530c48e3d361e..8868480b53a3121abef5d9b051263b3c91e36e09:/lib/noticia.php?ds=inline

diff --git a/lib/noticia.php b/lib/noticia.php
index 96ba6b2..0b37c92 100644
--- a/lib/noticia.php
+++ b/lib/noticia.php
@@ -55,16 +55,19 @@ class noticia {
     {
         $this->noticia = $noticia;
         $db = MEconDAVDB::Connect();
-	$query = "SELECT headline, title, abstract, article, publication_date
-	          FROM Articles
-		  WHERE Article_id = $noticia";
+	$query = "SELECT A.headline, A.title, A.abstract, A.article,
+	                 A.publication_date, S.description
+	          FROM Articles A, Sections S
+		  WHERE Article_id = $noticia
+		  AND A.section_id = S.section_id";
 	$result = $db->query($query);
 	$row = $result->fetchRow();
-	$this->titulo2 = $row[0];
-	$this->titulo = $row[1];
-	$this->abstracto = $row[2];
+	$this->titulo = $row[0];
+	$this->titulo2 = $row[1];
+	$this->sintesis = $row[2];
 	$this->texto = $row[3];
 	$this->fecha = new Date($row[4]);
+	$this->seccion = $row[5];
     }
     // -X2C
 
@@ -95,9 +98,9 @@ class noticia {
      * @return string
      * @access public
      */
-    function getAbstracto() // ~X2C
+    function getSintesis() // ~X2C
     {
-        return $this->abstracto;
+        return $this->sintesis;
     }
     // -X2C
 
@@ -123,5 +126,16 @@ class noticia {
     }
     // -X2C
 
+    // +X2C Operation 191
+    /**
+     * @return void
+     * @access public
+     */
+    function getSeccion() // ~X2C
+    {
+        return $this->seccion;
+    }
+    // -X2C
+
 } // -X2C Class :noticia
-?>
+?>
\ No newline at end of file