diff options
| -rw-r--r-- | admin/images/monthly_stats.img.php | 21 | ||||
| -rw-r--r-- | admin/stats.php | 2 |
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.' |