diff options
Diffstat (limited to 'bin/run_once/combine_daily_downloads.php')
| -rw-r--r-- | bin/run_once/combine_daily_downloads.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/bin/run_once/combine_daily_downloads.php b/bin/run_once/combine_daily_downloads.php index 34d9fa4..a66b0ea 100644 --- a/bin/run_once/combine_daily_downloads.php +++ b/bin/run_once/combine_daily_downloads.php @@ -47,19 +47,19 @@ require_once('../database.class.php'); $db = new Database(); -$addon_qry = $db->read("SELECT id FROM addons"); +$addon_qry = $db->query("SELECT id FROM addons"); while ($addon = mysql_fetch_array($addon_qry)) { echo "[Add-on {$addon['id']}]"; - $count_qry = $db->read("SELECT COUNT(*), date FROM download_counts WHERE addon_id={$addon['id']} GROUP BY date"); + $count_qry = $db->query("SELECT COUNT(*), date FROM download_counts WHERE addon_id={$addon['id']} GROUP BY date"); while ($count = mysql_fetch_array($count_qry)) { if ($count[0] > 1) { echo " ... {$count['date']} has {$count[0]} rows"; - $sum_qry = $db->read("SELECT SUM(count) FROM download_counts WHERE addon_id={$addon['id']} AND date='{$count['date']}'"); + $sum_qry = $db->query("SELECT SUM(count) FROM download_counts WHERE addon_id={$addon['id']} AND date='{$count['date']}'"); $sum = mysql_fetch_array($sum_qry); - $db->write("DELETE FROM download_counts WHERE addon_id={$addon['id']} AND date='{$count['date']}'"); - $db->write("INSERT INTO download_counts (addon_id, count, date) VALUES({$addon['id']}, $sum[0], '{$count['date']}')"); + $db->query("DELETE FROM download_counts WHERE addon_id={$addon['id']} AND date='{$count['date']}'", true); + $db->query("INSERT INTO download_counts (addon_id, count, date) VALUES({$addon['id']}, $sum[0], '{$count['date']}')", true); echo " - deleted rows and updated count to {$sum[0]}"; } } |