diff options
author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-12-14 03:17:14 +0000 |
---|---|---|
committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2009-12-14 03:17:14 +0000 |
commit | 4c4c945d30bd15bb31c531e177c7c93b476454a4 (patch) | |
tree | a9c11be082e238d547f3650c0510f1d3a47dcfff /lib/class/song.class.php | |
parent | 6ae813dff47e481f3754a1ea79a2b7c8a3aa7d82 (diff) | |
download | ampache-4c4c945d30bd15bb31c531e177c7c93b476454a4.tar.gz ampache-4c4c945d30bd15bb31c531e177c7c93b476454a4.tar.bz2 ampache-4c4c945d30bd15bb31c531e177c7c93b476454a4.zip |
Remove Dba::query from a few more classes
Diffstat (limited to 'lib/class/song.class.php')
-rw-r--r-- | lib/class/song.class.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/lib/class/song.class.php b/lib/class/song.class.php index 9a1b1bdd..7d30b116 100644 --- a/lib/class/song.class.php +++ b/lib/class/song.class.php @@ -143,7 +143,7 @@ class Song extends database_object implements media { "title,bitrate,rate,mode,size,time,track,played,song.enabled,update_time,". "mbid,". "addition_time FROM `song` WHERE `song`.`id` = '$id'"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = Dba::fetch_assoc($db_results); @@ -167,7 +167,7 @@ class Song extends database_object implements media { } $sql = "SELECT * FROM song_data WHERE `song_id`='$id'"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = Dba::fetch_assoc($db_results); @@ -286,7 +286,7 @@ class Song extends database_object implements media { public function has_flag() { $sql = "SELECT `id` FROM `flagged` WHERE `object_type`='song' AND `object_id`='$this->id' LIMIT 1"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); if (Dba::fetch_assoc($db_results)) { return true; @@ -433,7 +433,7 @@ class Song extends database_object implements media { "`size`='$size', `time`='$time', `track`='$track', " . "`mbid`='$mbid', " . "`update_time`='$update_time' WHERE `id`='$song_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); $comment = Dba::escape($new_song->comment); @@ -442,7 +442,7 @@ class Song extends database_object implements media { $sql = "UPDATE `song_data` SET `lyrics`='$lyrics', `language`='$language', `comment`='$comment' " . "WHERE `song_id`='$song_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); } // update_song @@ -632,7 +632,7 @@ class Song extends database_object implements media { $value = Dba::escape($value); $sql = "UPDATE `song` SET `$field`='$value' WHERE `id`='$song_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); return true; @@ -651,7 +651,7 @@ class Song extends database_object implements media { $value = Dba::escape($value); $sql = "UPDATE `song_data` SET `$field`='$value' WHERE `song_id`='$song_id'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); return true; @@ -929,7 +929,7 @@ class Song extends database_object implements media { "FROM `object_count` " . "WHERE `object_type`='song'$user_limit " . "ORDER BY `object_count`.`date` DESC "; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $results = array(); |