From 13ea9d50e35d9dd8cf7235a39d97a344e6091ea0 Mon Sep 17 00:00:00 2001 From: nikrou Date: Wed, 25 Nov 2009 19:02:57 +0000 Subject: 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 --- comments.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'comments.php') 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 -- cgit v1.2.3