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/artist.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/artist.class.php')
| -rw-r--r-- | lib/class/artist.class.php | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/lib/class/artist.class.php b/lib/class/artist.class.php index c2c80a61..a61b0e92 100644 --- a/lib/class/artist.class.php +++ b/lib/class/artist.class.php @@ -84,7 +84,7 @@ class Artist extends database_object { $idlist = '(' . implode(',', $ids) . ')'; $sql = "SELECT * FROM `artist` WHERE `id` IN $idlist"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($row = Dba::fetch_assoc($db_results)) { parent::add_to_cache('artist',$row['id'],$row); @@ -94,7 +94,7 @@ class Artist extends database_object { if ($extra) { $sql = "SELECT `song`.`artist`, COUNT(`song`.`id`) AS `song_count`, COUNT(DISTINCT `song`.`album`) AS `album_count`, SUM(`song`.`time`) AS `time` FROM `song` " . "WHERE `song`.`artist` IN $idlist GROUP BY `song`.`artist`"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($row = Dba::fetch_assoc($db_results)) { parent::add_to_cache('artist_extra',$row['artist'],$row); @@ -114,7 +114,7 @@ class Artist extends database_object { $name = Dba::escape($name); $sql = "SELECT `id` FROM `artist` WHERE `name`='$name'"; - $db_results = Dba::query($sql); + $db_results = Dba::write($sql); $row = Dba::fetch_assoc($db_results); @@ -135,7 +135,7 @@ class Artist extends database_object { $sql = "SELECT `album`.`id` FROM album LEFT JOIN `song` ON `song`.`album`=`album`.`id` " . "WHERE `song`.`artist`='$this->id' GROUP BY `album`.`id` ORDER BY `album`.`name`,`album`.`disk`,`album`.`year`"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; @@ -152,7 +152,7 @@ class Artist extends database_object { public function get_songs() { $sql = "SELECT `song`.`id` FROM `song` WHERE `song`.`artist`='" . Dba::escape($this->id) . "' ORDER BY album, track"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; @@ -171,7 +171,7 @@ class Artist extends database_object { $results = array(); $sql = "SELECT `id` FROM `song` WHERE `artist`='$this->id' ORDER BY RAND()"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); while ($r = Dba::fetch_assoc($db_results)) { $results[] = $r['id']; @@ -195,7 +195,7 @@ class Artist extends database_object { $uid = Dba::escape($this->id); $sql = "SELECT `song`.`artist`,COUNT(`song`.`id`) AS `song_count`, COUNT(DISTINCT `song`.`album`) AS `album_count`, SUM(`song`.`time`) AS `time` FROM `song` " . "WHERE `song`.`artist`='$uid' GROUP BY `song`.`artist`"; - $db_results = Dba::query($sql); + $db_results = Dba::read($sql); $row = Dba::fetch_assoc($db_results); parent::add_to_cache('artist_extra',$row['artist'],$row); } |