From b2a8c423c2ad93e2424a88bfb94208c879dde48a Mon Sep 17 00:00:00 2001 From: gmo Date: Tue, 18 Apr 2017 12:26:23 +0200 Subject: [PATCH] Add offset for CURRENT_TIMESTAMP https://github.com/YOURLS/YOURLS/issues/2221 --- yourls-infos.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/yourls-infos.php b/yourls-infos.php index 9da6bac..4873263 100644 --- a/yourls-infos.php +++ b/yourls-infos.php @@ -152,7 +152,7 @@ if( yourls_do_log_redirect() ) { DATE_FORMAT(DATE_ADD(`click_time`, INTERVAL " . YOURLS_HOURS_OFFSET . " HOUR), '%H %p') AS `time`, COUNT(*) AS `count` FROM `$table` - WHERE `shorturl` $keyword_range AND DATE_ADD(`click_time`, INTERVAL " . YOURLS_HOURS_OFFSET . " HOUR) > (CURRENT_TIMESTAMP - INTERVAL 1 DAY) + WHERE `shorturl` $keyword_range AND DATE_ADD(`click_time`, INTERVAL " . YOURLS_HOURS_OFFSET . " HOUR) > (DATE_ADD(CURRENT_TIMESTAMP, INTERVAL " . YOURLS_HOURS_OFFSET . " HOUR) - INTERVAL 1 DAY) GROUP BY `time`;"; $rows = $ydb->get_results( yourls_apply_filter( 'stat_query_last24h', $query ) ); -- 2.42.0