diff options
| author | rub <rub@piwigo.org> | 2007-03-07 18:51:58 +0000 |
|---|---|---|
| committer | rub <rub@piwigo.org> | 2007-03-07 18:51:58 +0000 |
| commit | 1415354b9c13b0dca0b8933206589f3e3fec972d (patch) | |
| tree | 15382ec00bdced60ef1ad8e87f0b685c2bef31f9 /include/category_cats.inc.php | |
| parent | 885393221f6c8045d858ea545b1339120eb5b625 (diff) | |
0000662: Recent elements don't use sometimes time and not truncated datetime
&
Standardize system date used
git-svn-id: http://piwigo.org/svn/trunk@1876 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'include/category_cats.inc.php')
| -rw-r--r-- | include/category_cats.inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/category_cats.inc.php b/include/category_cats.inc.php index cfdd8db66..6e6304b94 100644 --- a/include/category_cats.inc.php +++ b/include/category_cats.inc.php @@ -39,7 +39,7 @@ SELECT date_last, max_date_last, count_images, count_categories, global_rank 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 ) '.get_sql_condition_FandF |