aboutsummaryrefslogtreecommitdiffstats
path: root/comments.php
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2009-11-25 19:02:57 +0000
committernikrou <nikrou@piwigo.org>2009-11-25 19:02:57 +0000
commit13ea9d50e35d9dd8cf7235a39d97a344e6091ea0 (patch)
treea3c6e08df8ea10d0d5f56ffc2f1f14d6cbcfcd67 /comments.php
parentd30639ec98f8e2929137ab6e00cb2fe3ba295957 (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.php8
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