Changeset 775

Timestamp:

Apr 26, 2005, 10:47:16 PM (19 years ago)

Author:

plg

Message:

• DATE() is available only since MySQL 4.1.1, replaced by DAYOFMONTH()

• array_fill function available only with PHP >= 4.2.0, replaced by a for loop

Location:

trunk/admin

Files:

• images/monthly_stats.img.php (modified) (2 diffs)
• stats.php (modified) (1 diff)

trunk/admin/images/monthly_stats.img.php

@@ -37 +37 @@
 $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
@@ -76 +80 @@
 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;

trunk/admin/stats.php

@@ -66 +66 @@
 $query = '
 SELECT DISTINCT COUNT(*) as p,
-       DATE(date) as d,
+       DAYOFMONTH(date) as d,
        MONTH(date) as m,
        YEAR(date) as y