Hi,
this patch solves the problem that no stats are shown when using
Postgres with the stats.php3
Didn't test it with MySQL but it should work...
Uli
[EMAIL PROTECTED] htdocs]$ diff -u stats.php3 stats.new.php3
--- stats.php3 2003-08-28 15:01:59.000000000 +0200
+++ stats.new.php3 2003-11-10 14:10:09.000000000 +0100
@@ -98,23 +98,23 @@
$day = "$days[$i]";
if ($config[general_stats_use_totacct] == 'yes')
$search = @da_sql_query($link,$config,
- "SELECT $res[1],$res[2],$res[3] FROM
$config[sql_total_accounting_table]
+ "SELECT $res[1] AS sum1,$res[2] AS sum2,$res[3]
AS sum3 FROM $config[sql_total_accounting_table]
$sql_val[user] AND AcctDate = '$day' $s;");
else
$search = @da_sql_query($link,$config,
- "SELECT $res[1],$res[2],$res[3] FROM
$config[sql_accounting_table]
+ "SELECT $res[1] AS sum1,$res[2] AS sum2,$res[3]
AS sum3 FROM $config[sql_accounting_table]
$sql_val[user] AND AcctStopTime >= '$day
00:00:00'
AND AcctStopTime <= '$day 23:59:59' $s;");
if ($search){
$row = @da_sql_fetch_array($search,$config);
- $data[$day][1] = $row["$res[1]"];
- $data[sum][1] += $row["$res[1]"];
+ $data[$day][1] = $row[sum1];
+ $data[sum][1] += $row[sum1];
$num[1] = ($data[$day][1]) ? $num[1] + 1 :
$num[1];
- $data[$day][2] = $row["$res[2]"];
- $data[sum][2] += $row["$res[2]"];
+ $data[$day][2] = $row[sum2];
+ $data[sum][2] += $row[sum2];
$num[2] = ($data[$day][2]) ? $num[2] + 1 :
$num[2];
- $data[$day][3] = $row["$res[3]"];
- $data[sum][3] += $row["$res[3]"];
+ $data[$day][3] = $row[sum3];
+ $data[sum][3] += $row[sum3];
$num[3] = ($data[$day][3]) ? $num[3] + 1 :
$num[3];
}
else
--- stats.php3 2003-08-28 15:01:59.000000000 +0200
+++ stats.new.php3 2003-11-10 14:10:09.000000000 +0100
@@ -98,23 +98,23 @@
$day = "$days[$i]";
if ($config[general_stats_use_totacct] == 'yes')
$search = @da_sql_query($link,$config,
- "SELECT $res[1],$res[2],$res[3] FROM
$config[sql_total_accounting_table]
+ "SELECT $res[1] AS sum1,$res[2] AS sum2,$res[3] AS sum3 FROM
$config[sql_total_accounting_table]
$sql_val[user] AND AcctDate = '$day' $s;");
else
$search = @da_sql_query($link,$config,
- "SELECT $res[1],$res[2],$res[3] FROM
$config[sql_accounting_table]
+ "SELECT $res[1] AS sum1,$res[2] AS sum2,$res[3] AS sum3 FROM
$config[sql_accounting_table]
$sql_val[user] AND AcctStopTime >= '$day 00:00:00'
AND AcctStopTime <= '$day 23:59:59' $s;");
if ($search){
$row = @da_sql_fetch_array($search,$config);
- $data[$day][1] = $row["$res[1]"];
- $data[sum][1] += $row["$res[1]"];
+ $data[$day][1] = $row[sum1];
+ $data[sum][1] += $row[sum1];
$num[1] = ($data[$day][1]) ? $num[1] + 1 : $num[1];
- $data[$day][2] = $row["$res[2]"];
- $data[sum][2] += $row["$res[2]"];
+ $data[$day][2] = $row[sum2];
+ $data[sum][2] += $row[sum2];
$num[2] = ($data[$day][2]) ? $num[2] + 1 : $num[2];
- $data[$day][3] = $row["$res[3]"];
- $data[sum][3] += $row["$res[3]"];
+ $data[$day][3] = $row[sum3];
+ $data[sum][3] += $row[sum3];
$num[3] = ($data[$day][3]) ? $num[3] + 1 : $num[3];
}
else
