Changeset 3619 for extensions/piclens/generate_rss.php

Timestamp:

Jul 17, 2009, 7:41:22 PM (15 years ago)

Author:

tiico

Message:

Add compatiblity with tag page (piclens and wall)
Add parameter to avoid double image in the feed

File:

• extensions/piclens/generate_rss.php (modified) (5 diffs)

extensions/piclens/generate_rss.php

@@ -178 +178 @@
                 }
 
+                // Gestion des tags
+                elseif (($page['section']) == 'tags')
+                {
+//                      $row = get_image_ids_for_tags($page['tags_id']);
+                        // $cat need to bo not null...
+                        array_push($cat, "1");
+                        $query = 'SELECT DISTINCT(tag.image_id) , img.id, img.file, img.date_available, img.date_creation, img.tn_ext, img.name, 
+                                          img.comment, img.author, img.hit ,img.filesize, img.average_rate, img.has_high, img.path, 
+                                          img.level , ic.category_id, cat.name AS catname, cat.comment AS catcomment, cat.rank, cat.status, 
+                                          cat.visible, cat.uppercats, cat.permalink, cat.dir '
+                                        .' FROM '.IMAGE_TAG_TABLE.' AS tag '."\n"
+                                        .' INNER JOIN '.IMAGES_TABLE.' AS img ON tag.image_id = img.id'
+                                        .' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON img.id = ic.image_id'
+                                        .' INNER JOIN '.CATEGORIES_TABLE.' AS cat ON ic.category_id = cat.id'                   
+                                        .' WHERE tag.tag_id IN ('.implode(',', $page['tag_ids']).') '
+                                    .$forbidden
+                                        .' '.$conf['order_by'].';';
+                }
+                
+                
                 elseif (($page['section']) == 'categories')
                 {
@@ -320 +340 @@
                 {
                         $result = pwg_query($query);
+                        
                         while ($row = mysql_fetch_assoc($result))
                         {
@@ -329 +350 @@
                                                 && ((isset($row['catname']) ? !(substr_count($row['catname'],  $piclens_extdesc_hidden)) : true))
                                                 ))
-                                        array_push($pictures, $row);
+                                {
+                                        // Suppression des doublons (même path)
+                                        if ($obj->my_config['piclens_exclude_double'])
+                                        {
+                                                $double = false;
+                                                foreach ($pictures as $key => $values)
+                                                        // même path
+                                                        if ($row['path'] == $values['path'])
+                                                                $double=true;
+
+                                                // pas de double trouvé
+                                                if (!$double)
+                                                        array_push($pictures, $row);
+                                        }
+                                        else
+                                                array_push($pictures, $row);
+                                }
                         }
                 }
                 // Fin requetes recherches photos
 
-                
+
                 // Creation du fichier xml (flux rss)
                 // It's a rss file
@@ -366 +403 @@
 
                 // Icone de la gallerie dans le flux RSS
-//              echo '<logo url="'.get_root_url().'template-common/favicon.ico"></logo>';
                 echo "\n";
                 echo '<atom:icon>'.$obj->root_site_piclens.'template-common/favicon.ico</atom:icon>';
                 echo "\n";
-//   <atom:link href="http://mywebsite.com/photos.rss" rel="self" type="application/rss+xml" />
 
                 // Pour chacune des images, preparation du flux xml
@@ -544 +579 @@
                         echo "<link>" . $url . "</link>\n";
 
-//                      echo "<guid>" . $row['id'] . "\</guid>\n";                              
                         echo "<guid isPermaLink=\"false\">\"" . $row['id'] . "\"</guid>\n";