From b1c5e25b5e4eed872230ebffe72cc7ece4533ee2 Mon Sep 17 00:00:00 2001 From: plegall Date: Sun, 18 Sep 2005 21:56:56 +0000 Subject: - bug 107 fixed: crash when logging visit on a category containing "'" character. Correction reported from branch 1.4 - bug fixed: in admin/stats, incorrect SQL queries gave no result. git-svn-id: http://piwigo.org/svn/trunk@868 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/stats.php | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'admin/stats.php') diff --git a/admin/stats.php b/admin/stats.php index 61e3fbe39..5e823a38d 100644 --- a/admin/stats.php +++ b/admin/stats.php @@ -80,8 +80,11 @@ while ( $row = mysql_fetch_array( $result ) ) $value = ''; if (isset($_GET['month']) && isset($_GET['year']) ) { - $where_clause = "DATE_FORMAT(date,'%Y-%m-%d') = '".$row['d']."'"; - $value = substr($row['d'],8,2); + $where_clause = 'DAYOFMONTH(date) = '.$row['d'].' + AND MONTH(date) = '.$row['m'].' + AND YEAR(date) = '.$row['y']; + $week_day = $lang['day'][date('w', mktime(12,0,0,$row['m'],$row['d'],$row['y']))]; + $value = $row['d'].' ('.$week_day.')'; } else { @@ -97,12 +100,10 @@ while ( $row = mysql_fetch_array( $result ) ) // Number of pictures seen $query = ' -SELECT COUNT(*) as p, - FILE as f +SELECT COUNT(*) as p FROM '.HISTORY_TABLE.' WHERE '.$where_clause.' AND FILE = \'picture\' - GROUP BY FILE ;'; $pictures = mysql_fetch_array(pwg_query( $query )); -- cgit v1.2.3