summaryrefslogtreecommitdiffstats
path: root/lib/class/stats.class.php
diff options
context:
space:
mode:
authorKarl 'vollmerk' Vollmer <vollmer@ampache.org>2009-12-14 05:21:36 +0000
committerKarl 'vollmerk' Vollmer <vollmer@ampache.org>2009-12-14 05:21:36 +0000
commit9b3232ba299fbbe6bec922bf7034c005175c9365 (patch)
tree6801f81508b60b98cf1c1997775d085423896a76 /lib/class/stats.class.php
parent4c4c945d30bd15bb31c531e177c7c93b476454a4 (diff)
downloadampache-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.php10
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();