Changeset 1238 for trunk/wifidog-auth/wifidog/classes/StatisticGraph/VisitsPerMonth.php

Timestamp:

05/30/07 12:35:43 (6 years ago)

Author:

benoitg

Message:

• VisitsPerMonth?.php, VisitePerWeekday?.php: Fix small sql bug when selecting a single user

Files:

• trunk/wifidog-auth/wifidog/classes/StatisticGraph/VisitsPerMonth.php (modified) (1 diff)

trunk/wifidog-auth/wifidog/classes/StatisticGraph/VisitsPerMonth.php

@@ -100 +100 @@
 $Plot =& $Plotarea->add($Bar);
 
-        $candidate_connections_sql = self :: $stats->getSqlCandidateConnectionsQuery("COUNT(DISTINCT user_id||connections.node_id) AS daily_connections, date_trunc('day', timestamp_in) AS date");
+        $candidate_connections_sql = self :: $stats->getSqlCandidateConnectionsQuery("COUNT(DISTINCT connections.user_id||connections.node_id) AS daily_connections, date_trunc('day', timestamp_in) AS date");
 $db->execSql("SELECT SUM(daily_connections) AS connections, date_trunc('month', date) AS month FROM ($candidate_connections_sql GROUP BY date) AS daily_connections_table GROUP BY month ORDER BY month", $results, false);
 if ($results != null) {