Changeset 868 for trunk/admin/stats.php

Timestamp:

Sep 18, 2005, 11:56:56 PM (19 years ago)

Author:

plg

Message:

• 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.

File:

• trunk/admin/stats.php (modified) (2 diffs)

trunk/admin/stats.php

@@ -81 +81 @@
   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
@@ -98 +101 @@
   // 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 ));