Changeset 1876 for trunk/include/section_init.inc.php

Timestamp:

Mar 7, 2007, 7:51:58 PM (17 years ago)

Author:

rub

Message:

0000662: Recent elements don't use sometimes time and not truncated datetime
&
Standardize system date used

File:

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

trunk/include/section_init.inc.php

@@ -558 +558 @@
   FROM '.IMAGES_TABLE.'
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
-  WHERE date_available > \''.
-      date('Y-m-d', time() - 60*60*24*$user['recent_period']).'\'
+  WHERE
+    date_available >= SUBDATE(
+      CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)
     '.$forbidden.'
   '.$conf['order_by'].'