Changeset 591 for trunk/admin/stats.php

Timestamp:

Nov 5, 2004, 12:26:22 AM (19 years ago)

Author:

z0rglub

Message:

in queries table names use the constant and not hard coded table name

File:

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

trunk/admin/stats.php

@@ -48 +48 @@
 
 //---------------------------------------------------------------- log  history
-$query = "SELECT DISTINCT COUNT(*) as p, 
-  MONTH(date) as m,
-  YEAR(date) as y
-  FROM phpwg_history 
-  GROUP BY DATE_FORMAT(date,'%Y-%m') DESC;";
+$query = '
+SELECT DISTINCT COUNT(*) as p,
+       MONTH(date) as m,
+       YEAR(date) as y
+  FROM '.HISTORY_TABLE.' 
+  GROUP BY DATE_FORMAT(date,\'%Y-%m\') DESC
+;';
 $result = pwg_query( $query );
 $i=0;
@@ -61 +63 @@
   $current_month .= $row['m'];
   // Number of pictures seen
-  $query = "SELECT COUNT(*) as p,
-    FILE as f
-    FROM phpwg_history 
-    WHERE DATE_FORMAT(date,'%Y-%m') = '$current_month'
-        AND FILE = 'picture'
-        GROUP BY FILE;";
+  $query = '
+SELECT COUNT(*) as p,
+       FILE as f
+  FROM '.HISTORY_TABLE.' 
+  WHERE DATE_FORMAT(date,\'%Y-%m\') = \''.$current_month.'\'
+    AND FILE = \'picture\'
+  GROUP BY FILE
+;';
   $pictures = mysql_fetch_array(pwg_query( $query ));
   
   // Number of different visitors
-  $query = "SELECT COUNT(*) as p, login
-    FROM phpwg_history 
-    WHERE DATE_FORMAT(date,'%Y-%m') = '$current_month'
-        GROUP BY login, IP;";
+  $query = '
+SELECT COUNT(*) as p, login
+  FROM '.HISTORY_TABLE.' 
+  WHERE DATE_FORMAT(date,\'%Y-%m\') = \''.$current_month.'\'
+  GROUP BY login, IP
+;';
   $user_results = pwg_query( $query );
   $nb_visitors = 0;