aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--admin/images/monthly_stats.img.php21
-rw-r--r--admin/stats.php2
2 files changed, 16 insertions, 7 deletions
diff --git a/admin/images/monthly_stats.img.php b/admin/images/monthly_stats.img.php
index 9d4d9143d..9720d2a2a 100644
--- a/admin/images/monthly_stats.img.php
+++ b/admin/images/monthly_stats.img.php
@@ -36,10 +36,14 @@ $outputFormat = "png";
$legend = $lang['stats_global_graph_title'];
$imageHeight = 256;
$imageWidth = 512;
-$sql = "SELECT DISTINCT COUNT(*), DAY(date)
- FROM ".HISTORY_TABLE."
- WHERE (YEAR(date) = ".$_GET['year']." AND MONTH(date) = ".$_GET['month']." )
- GROUP BY DATE_FORMAT(date,'%Y-%m-%d') DESC;";
+$sql = '
+SELECT DISTINCT COUNT(*)
+ , DAYOFMONTH(date)
+ FROM '.HISTORY_TABLE.'
+ WHERE YEAR(date) = '.$_GET['year'].'
+ AND MONTH(date) = '.$_GET['month'].'
+ GROUP BY DATE_FORMAT(date, \'%Y-%m-%d\') DESC
+;';
//------------------------------------------------ Image definition
$image = ImageCreate($imageWidth, $imageHeight);
@@ -75,10 +79,15 @@ $myBarGraph->SetBarSpacing(5); // The default is 10. This changes the space
$result = pwg_query($sql)
or die(mysql_errno().": ".mysql_error()."<BR>".$sql);
-$days =array_fill(1,31,0);
+$days = array();
+for ($i = 1; $i <= 31; $i++)
+{
+ $days[$i] = 0;
+}
+
while ($r = mysql_fetch_row($result))
{
- $days [$r[1]]= $r[0];
+ $days[$r[1]]= $r[0];
}
$o=0;
while (list ($key,$value) = each($days ))
diff --git a/admin/stats.php b/admin/stats.php
index 0fa4d4245..61e3fbe39 100644
--- a/admin/stats.php
+++ b/admin/stats.php
@@ -65,7 +65,7 @@ $template->assign_vars(array(
//---------------------------------------------------------------- log history
$query = '
SELECT DISTINCT COUNT(*) as p,
- DATE(date) as d,
+ DAYOFMONTH(date) as d,
MONTH(date) as m,
YEAR(date) as y
FROM '.HISTORY_TABLE.'