diff options
Diffstat (limited to 'bin/run_once/delete_duplicate_daily_downloads.php')
| -rw-r--r-- | bin/run_once/delete_duplicate_daily_downloads.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/bin/run_once/delete_duplicate_daily_downloads.php b/bin/run_once/delete_duplicate_daily_downloads.php index 136c8ea..5a8f771 100644 --- a/bin/run_once/delete_duplicate_daily_downloads.php +++ b/bin/run_once/delete_duplicate_daily_downloads.php @@ -48,7 +48,7 @@ require_once('../database.class.php'); $db = new Database(); -$addon_qry = $db->read("SELECT id FROM addons"); +$addon_qry = $db->query("SELECT id FROM addons"); $dates = array( '2008-09-23', @@ -63,11 +63,11 @@ while ($addon = mysql_fetch_array($addon_qry)) { foreach ($dates as $date) { echo "[{$date} Add-on {$addon['id']}]"; - $count_qry = $db->read("SELECT count(*), MIN(id) FROM download_counts WHERE addon_id={$addon['id']} AND date='{$date}'"); + $count_qry = $db->query("SELECT count(*), MIN(id) FROM download_counts WHERE addon_id={$addon['id']} AND date='{$date}'"); $count = mysql_fetch_array($count_qry); if ($count[0] > 1) { echo " ... {$date} has {$count[0]} rows on {$date}"; - $db->write("DELETE FROM download_counts WHERE id > {$count[1]} AND addon_id={$addon['id']} AND date='{$date}'"); + $db->query("DELETE FROM download_counts WHERE id > {$count[1]} AND addon_id={$addon['id']} AND date='{$date}'", true); echo " - deleted duplicate rows"; } else { echo " - is OK"; |