diff options
Diffstat (limited to 'bin/run_once/calculate_undated_totals.php')
-rw-r--r-- | bin/run_once/calculate_undated_totals.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/bin/run_once/calculate_undated_totals.php b/bin/run_once/calculate_undated_totals.php index 8f33d8e..052d96a 100644 --- a/bin/run_once/calculate_undated_totals.php +++ b/bin/run_once/calculate_undated_totals.php @@ -47,17 +47,17 @@ require_once('../database.class.php'); $db = new Database(); -$addon_qry = $db->read("SELECT id, totaldownloads FROM addons"); +$addon_qry = $db->query("SELECT id, totaldownloads FROM addons"); while ($addon = mysql_fetch_array($addon_qry)) { echo "# [Add-on {$addon['id']}]"; - $sum_qry = $db->read("SELECT SUM(count) FROM download_counts WHERE addon_id={$addon['id']} AND date != '0000-00-00'"); + $sum_qry = $db->query("SELECT SUM(count) FROM download_counts WHERE addon_id={$addon['id']} AND date != '0000-00-00'"); $sum = mysql_fetch_array($sum_qry); if ($sum[0] > 0) { $undated = $addon['totaldownloads'] - $sum[0]; echo " {$addon['totaldownloads']} total - {$sum[0]} dated = {$undated} undated"; if ($undated > 0) { - //$db->write("INSERT INTO download_counts (addon_id, count, date) VALUES({$addon['id']}, $undated, '0000-00-00')"); + //$db->query("INSERT INTO download_counts (addon_id, count, date) VALUES({$addon['id']}, $undated, '0000-00-00')", true); echo "\nINSERT INTO download_counts (addon_id, count, date) VALUES({$addon['id']}, $undated, '0000-00-00');"; } } |