Changeset 862 in ExiteCMS for modules/common/download_statistics_panel/php-files/modules/download_statistics_panel/download_statistics_panel.php

Timestamp:

10/02/07 22:27:18 (5 years ago)

Author:

hverton

Message:

Added an image upload function to the Wiki module
Optimized the speed of the download panels
Fixed a crash due to "attachment to big" in M2F

File:

• modules/common/download_statistics_panel/php-files/modules/download_statistics_panel/download_statistics_panel.php (modified) (1 diff)

modules/common/download_statistics_panel/php-files/modules/download_statistics_panel/download_statistics_panel.php

@@ -35 +35 @@
 // first panel: statistics overview
 
-$data = dbarray(dbquery("SELECT MIN(ds_timestamp) AS timestamp FROM ".$db_prefix."dls_statistics"));
-if (!is_array($data)) $data = array("timestamp" => time());
-$variables['date_first'] = $data['timestamp'];
-
-$data = dbarray(dbquery("SELECT MAX(ds_timestamp) AS timestamp FROM ".$db_prefix."dls_statistics"));
-if (!is_array($data)) $data = array("timestamp" => time());
-$variables['date_last'] = $data['timestamp'];
-
-$data = dbarray(dbquery("SELECT COUNT(*) AS count FROM ".$db_prefix."dls_statistics"));
-if (!is_array($data)) $data = array("count" => 0);
-$variables['stats_count'] = $data['count'];
-
-$data = dbarray(dbquery("SELECT COUNT(DISTINCT ds_url) AS count FROM ".$db_prefix."dls_statistics"));
-if (!is_array($data)) $data = array("count" => 0);
-$variables['stats_files'] = $data['count'];
+if (isset($_POST['date_first'])) {
+    $variables['date_first'] = $_POST['date_first'];
+} else {
+    $data = dbarray(dbquery("SELECT MIN(ds_timestamp) AS timestamp FROM ".$db_prefix."dls_statistics"));
+    if (!is_array($data)) $data = array("timestamp" => time());
+    $variables['date_first'] = $data['timestamp'];
+}
+
+if (isset($_POST['date_last'])) {
+    $variables['date_last'] = $_POST['date_last'];
+} else {
+    $data = dbarray(dbquery("SELECT MAX(ds_timestamp) AS timestamp FROM ".$db_prefix."dls_statistics"));
+    if (!is_array($data)) $data = array("timestamp" => time());
+    $variables['date_last'] = $data['timestamp'];
+}
+
+if (isset($_POST['stats_count'])) {
+    $variables['stats_count'] = $_POST['stats_count'];
+} else {
+    $data = dbarray(dbquery("SELECT COUNT(*) AS count FROM ".$db_prefix."dls_statistics"));
+    if (!is_array($data)) $data = array("count" => 0);
+    $variables['stats_count'] = $data['count'];
+}
+
+if (isset($_POST['stats_files'])) {
+    $variables['stats_files'] = $_POST['stats_files'];
+} else {
+    $result = dbquery("SELECT COUNT(ds_url) AS count FROM ".$db_prefix."dls_statistics GROUP BY ds_url");
+    $variables['stats_files'] = dbrows($result);
+}
 
 // second panels: statistics per download mirror