Changeset 1876

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

Location:

trunk/include

Files:

• category_cats.inc.php (modified) (1 diff)
• filter.inc.php (modified) (1 diff)
• functions_html.inc.php (modified) (1 diff)
• section_init.inc.php (modified) (1 diff)

trunk/include/category_cats.inc.php

@@ -40 +40 @@
   FROM '.CATEGORIES_TABLE.' INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.'
   ON id = cat_id and user_id = '.$user['id'].'
-  WHERE date_last > SUBDATE(
+  WHERE date_last >= SUBDATE(
     CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY
   )

trunk/include/filter.inc.php

@@ -96 +96 @@
     }
   $query.= '
-    date_available  > SUBDATE(
+    date_available >= SUBDATE(
       CURRENT_DATE,INTERVAL '.$filter['recent_period'].' DAY)';
 

trunk/include/functions_html.inc.php

@@ -56 +56 @@
   }
 
-  $diff = time() - $unixtime;
+  if (!isset($page['get_icon_cache']['unix_timestamp']))
+  {
+    // Use MySql date in order to standardize all recent "actions/queries"
+    list($page['get_icon_cache']['unix_timestamp']) = 
+      mysql_fetch_array(pwg_query('select UNIX_TIMESTAMP(CURRENT_DATE)'));
+  }
+
+  $diff = $page['get_icon_cache']['unix_timestamp'] - $unixtime;
   $day_in_seconds = 24*60*60;
   $page['get_icon_cache'][$date] = false;
-  if ( $diff < $user['recent_period'] * $day_in_seconds )
+  if ( $diff <= $user['recent_period'] * $day_in_seconds )
   {
     if ( !isset($page['get_icon_cache']['_icons_'] ) )

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'].'