Changeset 1531 in ExiteCMS for modules/common/download_statistics/php-files/modules/download_statistics/batch/migrate_download_statistics.php

Timestamp:

07/08/08 18:12:41 (4 years ago)

Author:

hverton

Message:

updated the batch tools to support the new "external download" field

File:

• modules/common/download_statistics/php-files/modules/download_statistics/batch/migrate_download_statistics.php (modified) (2 diffs)

modules/common/download_statistics/php-files/modules/download_statistics/batch/migrate_download_statistics.php

@@ -97 +97 @@
             $data = mysql_fetch_assoc($result);
         }
-        // fill the file_ipss table from the old statistics table and create the logfiles
+
+        // fill the file_ips table from the old statistics table and create the logfiles
         display("Creating the new download logfiles:"); 
         $result = mysql_query("SELECT * FROM ".$db_prefix.$table." ORDER BY ds_timestamp");
@@ -153 +154 @@
 }
 
+display("Update counters of the items in the download section");
+$result = mysql_query("SELECT * FROM ".$db_prefix."downloads WHERE download_external = 1")
+display("-> updating ".dbrows($result)." download records!");
+$data = mysql_fetch_assoc($result);
+while ($data !== false) {
+    // get the filename from the URL
+    $url = parse_url($data['download_url']);
+    // do we have a counter for it?
+    $result2 = mysql_query("SELECT * FROM ".$db_prefix."dlstats_files WHERE dlsf_file = '".$url['path']."' LIMIT 1");
+    if ($result2) {
+        // update the counter
+        $data2 = mysql_fetch_assoc($result2);
+        $result2 = mysql_query("UPDATE ".$db_prefix."downloads SET download_counter = '".$data2['dlsf_counter']."' WHERE download_id = '".$data['download_id']."'");
+    }
+    $data = mysql_fetch_assoc($result);
+}
+
 display(" ");
 display("Migration finished!");