Changeset 418 for trunk/client/modules/Elezioni/rss.php

Timestamp:

May 29, 2024, 1:45:09 PM (5 months ago)

Author:

roby

Message:

• CLIENT

-- attivato l'rss per la pagina principale
-- eliminata una query non più in uso per il tema Futura2

• INSTALL

-- corretta la creazione di una tabella del db

File:

• trunk/client/modules/Elezioni/rss.php (modified) (8 diffs)

trunk/client/modules/Elezioni/rss.php

@@ -27 +27 @@
 
         list($descr_com) = $res->fetch(PDO::FETCH_NUM);
-
-
-
-echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n";
+//URL
+$PHP_SELF=$_SERVER['PHP_SELF'];
+$siteurl.=$PHP_SELF;
+
+echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
 echo "<rss version=\"2.0\" \n";
 echo "  xmlns:dc=\"http://purl.org/dc/elements/1.1/\"\n";
 echo "  xmlns:sy=\"http://purl.org/rss/1.0/modules/syndication/\"\n";
 echo "  xmlns:admin=\"http://webns.net/mvcb/\"\n";
+echo "  xmlns:atom=\"http://www.w3.org/2005/Atom\"\n";
 echo "  xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\n\n";
 echo "<channel>\n";
 echo "<title>".htmlspecialchars($descr_com)." - $descr_cons</title>\n";
-echo "<link>".htmlspecialchars($siteurl)."</link>\n";
+echo "<link>https://".htmlspecialchars($siteurl)."</link>\n";
 echo "<description>".$sitename."</description>\n";
 echo "<dc:language>it-IT</dc:language>\n";
@@ -46 +48 @@
 echo "<sy:updateFrequency>1</sy:updateFrequency>\n";
 echo "<sy:updateBase>".$now."</sy:updateBase>\n\n";
-
-list ($gruppo,$pro,$titolo)=grupporss();
+echo "<atom:link href=\"https://$siteurl?op=rss&amp;rss=1&amp;name=Elezioni&amp;id_comune=$id_comune&amp;file=index&amp;id_cons_gen=$id_cons_gen\" rel=\"self\" type=\"application/rss+xml\" />\n";
+
+list ($gruppo,$pro,$titolo,$idg)=grupporss();
 
 
@@ -58 +61 @@
     echo "<item>\n";
     echo "<title>".$gruppo[$x]." ".$pro[$x] ."% </title>\n";
-    echo "<link>$siteurl/modules.php?id_cons_gen=$id_cons_gen&amp;name=Elezioni&amp;id_comune=$id_comune&amp;file=index</link>\n";
+    echo "<link>https://$siteurl?op=rss&amp;rss=1&amp;name=Elezioni&amp;id_comune=$id_comune&amp;file=index&amp;id_cons_gen=$id_cons_gen</link>\n";
+        echo "<guid>https://$siteurl?op=rss&amp;rss=1&amp;name=Elezioni&amp;id_comune=$id_comune&amp;file=index&amp;id_cons_gen=$id_cons_gen&amp;gruppo=$idg[$x]</guid>\n";
     
 #    echo "<description><![CDATA['aa']]></description>\n";
@@ -89 +93 @@
         if ($genere==4){$tab="ele_voti_lista";}
         if ($votog){$tab="ele_voti_lista";}
-        $sql="select *  from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
+        $sql="select id_sez  from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
         $res = $dbi->prepare("$sql");
         $res->execute();
@@ -138 +142 @@
                                 left join ".$prefix."_$tab as t2 on (t1.id_gruppo=t2.id_gruppo)
                                 where   t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1
-                                group by t2.id_gruppo
+                                group by t1.id_gruppo,t1.num_gruppo,t1.descrizione
                                 order by somma desc";
                                 $res = $dbi->prepare("$sql");
@@ -151 +155 @@
                         left join ".$prefix."_$tab as t2 on (t1.id_lista=t2.id_lista)
                                 where   t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons
-                                group by t2.id_lista
+                                group by t1.id_lista,t1.num_lista,t1.descrizione
                                 order by somma desc";
                                 $res = $dbi->prepare("$sql");
@@ -176 +180 @@
 
 
-                                        
+                                $idg[$i]=$id;   
                                 
 
@@ -196 +200 @@
                 
 
-                return array($gruppo,$pro,$titolo);
+                return array($gruppo,$pro,$titolo,$idg);