summaryrefslogtreecommitdiffstats
path: root/lib/class/shoutbox.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/shoutbox.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/shoutbox.class.php')
-rw-r--r--lib/class/shoutbox.class.php12
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