Changeset 2296

Timestamp:

Apr 4, 2008, 9:47:07 PM (16 years ago)

Author:

rvelices

Message:

• an optimization of a Mysql query for tags (oddly but it's faster)
• now the dates in the RSS feed are always correct (and in GMT)

Location:

trunk

Files:

• feed.php (modified) (4 diffs)
• include/feedcreator.class.php (modified) (1 diff)
• include/section_init.inc.php (modified) (4 diffs)

trunk/feed.php

@@ -3 +3 @@
 // | PhpWebGallery - a PHP based picture gallery                           |
 // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
-// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
+// | Copyright (C) 2003-2008 PhpWebGallery Team - http://phpwebgallery.net |
 // +-----------------------------------------------------------------------+
 // | file          : $Id$
@@ -139 +139 @@
     $item->descriptionHtmlSyndicated = true;
 
-    $item->date = ts_to_iso8601(mysqldt_to_ts($dbnow));
+    $item->date = mysqldt_to_ts($dbnow);
     $item->author = 'PhpWebGallery notifier';
     $item->guid= sprintf('%s', $dbnow);;
@@ -191 +191 @@
   $item->descriptionHtmlSyndicated = true;
 
-  $item->date = ts_to_iso8601(mysqldt_to_ts($date));
+  $item->date = mysqldt_to_ts($date);
   $item->author = 'PhpWebGallery notifier';
   $item->guid= sprintf('%s', 'pics-'.$date);;
@@ -198 +198 @@
 }
 
+$fileName= $conf['local_data_dir'].'/tmp';
+@mkdir($fileName); // just in case
+$fileName.='/feed.xml';
 // send XML feed
-echo $rss->saveFeed('RSS2.0', '', true);
+echo $rss->saveFeed('RSS2.0', $fileName, true);
 ?>

trunk/include/feedcreator.class.php

@@ -157 +157 @@
 
 // your local timezone, set to "" to disable or for GMT
-define("TIME_ZONE","+01:00");
+define("TIME_ZONE","+00:00");
 
 

trunk/include/section_init.inc.php

@@ -3 +3 @@
 // | PhpWebGallery - a PHP based picture gallery                           |
 // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
-// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
+// | Copyright (C) 2003-2008 PhpWebGallery Team - http://phpwebgallery.net |
 // +-----------------------------------------------------------------------+
 // | file          : $Id$
@@ -287 +287 @@
     {
       $query = '
-SELECT image_id
+SELECT DISTINCT image_id
   FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON image_id=id
   WHERE image_id IN ('.implode(',', $items).')
@@ -293 +293 @@
     $conf['order_by'].'
 ;';
-      $items = array_unique(
-        array_from_query($query, 'image_id')
-        );
+      $items =  array_from_query($query, 'image_id');
     }
 
@@ -304 +302 @@
       array(
         'title' => $title,
-        'items' => array_values($items),
+        'items' => $items,
         )
       );