diff options
| author | nikrou <nikrou@piwigo.org> | 2009-11-25 19:02:57 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2009-11-25 19:02:57 +0000 |
| commit | 13ea9d50e35d9dd8cf7235a39d97a344e6091ea0 (patch) | |
| tree | a3c6e08df8ea10d0d5f56ffc2f1f14d6cbcfcd67 /include/section_init.inc.php | |
| parent | d30639ec98f8e2929137ab6e00cb2fe3ba295957 (diff) | |
Feature 1255: modification in sql queries
- manage random function
- manage regex syntax
- manage quote (single instead of double)
- manage interval
git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'include/section_init.inc.php')
| -rw-r--r-- | include/section_init.inc.php | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/include/section_init.inc.php b/include/section_init.inc.php index ce3e3a553..5cc0fbb35 100644 --- a/include/section_init.inc.php +++ b/include/section_init.inc.php @@ -449,8 +449,7 @@ SELECT DISTINCT(id) FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE - date_available >= SUBDATE( - CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY) + date_available >= '.pwg_db_get_recent_period_expression($user['recent_period']).' '.$forbidden.' '.$conf['order_by'].' ;'; |