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