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 /comments.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 '')
| -rw-r--r-- | comments.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/comments.php b/comments.php index 958ff63f3..3d8c9cccf 100644 --- a/comments.php +++ b/comments.php @@ -51,11 +51,11 @@ $items_number = array(5,10,20,50,'all'); // $since_options = array( 1 => array('label' => l10n('today'), - 'clause' => 'date > SUBDATE(CURDATE(), INTERVAL 1 DAY)'), + 'clause' => 'date > '.pwg_db_get_recent_period_expression(1)), 2 => array('label' => sprintf(l10n('last %d days'), 7), - 'clause' => 'date > SUBDATE(CURDATE(), INTERVAL 7 DAY)'), + 'clause' => 'date > '.pwg_db_get_recent_period_expression(7)), 3 => array('label' => sprintf(l10n('last %d days'), 30), - 'clause' => 'date > SUBDATE(CURDATE(), INTERVAL 30 DAY)'), + 'clause' => 'date > '.pwg_db_get_recent_period_expression(30)), 4 => array('label' => l10n('the beginning'), 'clause' => '1=1') // stupid but generic ); @@ -138,7 +138,7 @@ $page['where_clauses'][] = $since_options[$page['since']]['clause']; // which status to filter on ? if ( !is_admin() ) { - $page['where_clauses'][] = 'validated="true"'; + $page['where_clauses'][] = 'validated=\'true\''; } $page['where_clauses'][] = get_sql_condition_FandF |