diff options
author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-12-14 05:21:36 +0000 |
---|---|---|
committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-12-14 05:21:36 +0000 |
commit | 9b3232ba299fbbe6bec922bf7034c005175c9365 (patch) | |
tree | 6801f81508b60b98cf1c1997775d085423896a76 /lib/class/stats.class.php | |
parent | 4c4c945d30bd15bb31c531e177c7c93b476454a4 (diff) | |
download | ampache-9b3232ba299fbbe6bec922bf7034c005175c9365.tar.gz ampache-9b3232ba299fbbe6bec922bf7034c005175c9365.tar.bz2 ampache-9b3232ba299fbbe6bec922bf7034c005175c9365.zip |
whole bunch more Dba::query replacements
Diffstat (limited to 'lib/class/stats.class.php')
-rw-r--r-- | lib/class/stats.class.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/lib/class/stats.class.php b/lib/class/stats.class.php index 2e3d1a07..b9abdf94 100644 --- a/lib/class/stats.class.php +++ b/lib/class/stats.class.php @@ -59,7 +59,7 @@ class Stats { $sql = "INSERT INTO `object_count` (`object_type`,`object_id`,`date`,`user`) " . " VALUES ('$type','$oid','$date','$user')"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); if (!$db_results) { debug_event('statistics','Unabled to insert statistics:' . $sql,'3'); @@ -81,7 +81,7 @@ class Stats { $user_id = Dba::escape($user_id); $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' ORDER BY `date` DESC LIMIT 1"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = Dba::fetch_assoc($db_results); @@ -104,7 +104,7 @@ class Stats { $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' AND `date`>='$time' " . "ORDER BY `date` DESC"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = array(); @@ -140,7 +140,7 @@ class Stats { $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" . " WHERE object_type='$type' AND date >= '$date'" . " GROUP BY object_id ORDER BY `count` DESC LIMIT $count"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = array(); @@ -176,7 +176,7 @@ class Stats { $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" . " WHERE object_type='$type' AND date >= '$date' AND user = '$user'" . " GROUP BY object_id ORDER BY `count` DESC LIMIT $count"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = array(); |