Changeset 1648 for trunk/include/category_default.inc.php

Timestamp:

Dec 10, 2006, 11:48:32 PM (17 years ago)

Author:

rub

Message:

Feature Issue ID 0000601: Filter all public pages with only recent elements

It's a draft of the feature witch allows to show only recent elements.
Development are not finished.
Queries and special pages (best rates, tags, etc.) are not modified.
Only main php files about images and categories are ok.

Before to continue, I prefer to determinate a solution between modify cache implementation or hide counters.

Go to ​http://forum.phpwebgallery.net/viewtopic.php?pid=50015#p50015

File:

• trunk/include/category_default.inc.php (modified) (1 diff)

trunk/include/category_default.inc.php

@@ -47 +47 @@
 SELECT *
   FROM '.IMAGES_TABLE.'
-  WHERE id IN ('.implode(',', $selection).')
-;';
+  WHERE id IN ('.implode(',', $selection).')';
+  if ($page['filter_mode'])
+  {
+    $query.= '
+    AND date_available  > SUBDATE(
+      CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)';
+  }
+  $query.= ';';
   $result = pwg_query($query);
   while ($row = mysql_fetch_assoc($result))