[Librefm-commits] [1850] query a list of all artists

[Clint Adams]

Revision: 1850
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1850
Author:   clint
Date:     2009-05-27 03:57:17 +0000 (Wed, 27 May 2009)
Log Message:
-----------
query a list of all artists

Modified Paths:
--------------
    trunk/nixtape/data/Server.php

Modified: trunk/nixtape/data/Server.php
===================================================================
--- trunk/nixtape/data/Server.php       2009-05-26 23:53:41 UTC (rev 1849)
+++ trunk/nixtape/data/Server.php       2009-05-27 03:57:17 UTC (rev 1850)
@@ -413,4 +413,25 @@
                return $session_id;
        }
 
+
+       static function getAllArtists() {
+               global $adodb;
+
+               $sql = 'SELECT * from Artist ORDER by name';
+               $adodb->SetFetchMode(ADODB_FETCH_ASSOC);
+               try {
+                       $res = $adodb->CacheGetAll(86400,$sql);
+               } catch (exception $e) {
+                       return null;
+               }
+
+               foreach($res as &$i) {
+                       $row = sanitize($i);
+
+                       $row['artisturl'] = Server::getArtistURL($row['name']);
+               }
+
+               return $res;
+       }
+
 }