X-Git-Url: https://git.llucax.com/mecon/intranet.git/blobdiff_plain/1555e161f408c3be2f719ae0197a4a63d18774e0..80e7fe0c5252de7db56416187636dac4e0f6fcdf:/sistema/local_lib/HTML_Titulares.php

diff --git a/sistema/local_lib/HTML_Titulares.php b/sistema/local_lib/HTML_Titulares.php
index 1de656c..1ab8314 100644
--- a/sistema/local_lib/HTML_Titulares.php
+++ b/sistema/local_lib/HTML_Titulares.php
@@ -73,16 +73,22 @@ class HTML_Titulares extends HTML_Table {
       $query = "SELECT Articles.article_id,
                         IF(Articles.publication_date > '$fecha_nuevo', 'NUEVA', null)
                  FROM Articles, ArticlePublicationStates
-		 WHERE Articles.article_publication_state_id =
-		        ArticlePublicationStates.article_publication_state_id
-		 AND ArticlePublicationStates.publication_state_id=5 ";
+  	  	         WHERE Articles.article_publication_state_id =
+		            ArticlePublicationStates.article_publication_state_id
+        		 AND ArticlePublicationStates.publication_state_id=5 ";
       if(!is_null($grupo_secciones))
       {
         $gs = new AI_GrupoSecciones($grupo_secciones);
-	$gs->cargar($db2);
-	if(count($gs->secciones) > 0)
-  	    $query .= 'AND Articles.section_id IN('.implode(',', $gs->secciones).') ';
+    	$gs->cargar($db2);
+	    if(count($gs->secciones) > 0)
+  	        $query .= ' AND Articles.section_id IN('.implode(',', $gs->secciones).') ';
       }
+      else{
+        $censuradas = $db2->getCol('SELECT seccion FROM secciones_censuradas');
+        $query .= ' AND Articles.section_id NOT IN('.implode(',', $censuradas).') ';
+        
+      }
+      
       if(!is_null($antiguedad))
       {
         $hoy->subtractSeconds(60*60*24*$antiguedad);
@@ -94,8 +100,8 @@ class HTML_Titulares extends HTML_Table {
       $this->numero_noticias = $result->numRows();//FIXME no documentado
       if(DB::isError($result))
          die($result->getMessage("query mal hecho"));
-      $ht1 = new HTML_Table(array('width'=>'300', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0'));
-      $ht2 = new HTML_Table(array('width'=>'300', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0'));
+      $ht1 = new HTML_Table(array('width'=>'280', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0'));
+      $ht2 = new HTML_Table(array('width'=>'280', 'border'=>'0', 'cellspacing'=>'0', 'cellpadding' => '0'));
       $impar = true;
       while($row = $result->fetchRow())
       {