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/shoutbox.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/shoutbox.class.php')
-rw-r--r-- | lib/class/shoutbox.class.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/lib/class/shoutbox.class.php b/lib/class/shoutbox.class.php index d8db9a36..d0c591d3 100644 --- a/lib/class/shoutbox.class.php +++ b/lib/class/shoutbox.class.php @@ -46,7 +46,7 @@ class shoutBox { $sticky_id = Dba::escape($shout_id); $sql = "SELECT * FROM `user_shout` WHERE `id`='$shout_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $data = Dba::fetch_assoc($db_results); @@ -76,7 +76,7 @@ class shoutBox { // Only get as many as we need $limit = intval($limit) - count($shouts); $sql = "SELECT * FROM `user_shout` WHERE `sticky`='0' ORDER BY `date` DESC LIMIT $limit"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($row = Dba::fetch_assoc($db_results)) { $shouts[] = $row['id']; @@ -93,7 +93,7 @@ class shoutBox { public static function get_sticky() { $sql = "SELECT * FROM `user_shout` WHERE `sticky`='1' ORDER BY `date` DESC"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = array(); @@ -165,7 +165,7 @@ class shoutBox { $sql = "INSERT INTO `user_shout` (`user`,`date`,`text`,`sticky`,`object_id`,`object_type`) " . "VALUES ('$user','$date','$text','$sticky','$object_id','$object_type')"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); $insert_id = Dba::insert_id(); @@ -184,7 +184,7 @@ class shoutBox { $sticky = make_bool($data['sticky']); $sql = "UPDATE `user_shout` SET `text`='$text', `sticky`='$sticky' WHERE `id`='$id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); return true; @@ -215,7 +215,7 @@ class shoutBox { // Delete the shoutbox post $sql = "DELETE FROM `user_shout` WHERE `id`='$shout_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); } // delete |