[Librefm-commits] [1088] try displaying only "free artists" in the tag cloud on the main page

[Clint Adams]

Revision: 1088
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1088
Author:   clint
Date:     2009-04-30 22:42:05 +0000 (Thu, 30 Apr 2009)
Log Message:
-----------
try displaying only "free artists" in the tag cloud on the main page

Modified Paths:
--------------
    trunk/gnukebox/install.php
    trunk/nixtape/index.php

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-04-30 22:26:02 UTC (rev 1087)
+++ trunk/gnukebox/install.php  2009-04-30 22:42:05 UTC (rev 1088)
@@ -226,13 +226,16 @@
                        expires INTEGER NOT NULL DEFAULT 0,
                        PRIMARY KEY(username,session))");
 
+       $res = $mdb2->exec("CREATE VIEW Free_Scrobbles AS SELECT s.* FROM 
Scrobbles s INNER JOIN Track t on lower(s.artist)=lower(t.artist) and 
lower(s.track)=lower(t.name) where t.streamable=1");
+
+
 // uncomment these to solve performance problems with getRecentScrobbles
 //     $res = $mdb2->exec("CREATE INDEX album_artistname_idx ON 
Album(artist_name)");
 //     $res = $mdb2->exec("CREATE INDEX scrobbles_artist_idx ON 
Scrobbles(artist)");
 //     $res = $mdb2->exec("CREATE INDEX scrobbles_time_idx ON 
Scrobbles(time)");
 //      $res = $mdb2->exec("CREATE INDEX track_artisttrack_idx ON 
Track(lower(artist),lower(name))");
+//      $res = $mdb2->exec("CREATE INDEX scrobbles_artisttrack_idx on 
scrobbles(lower(artist),lower(track))");
 
-
 // uncomment these if you're using postgresql and want to run the software as 
www-data
 //     $res = $mdb2->exec("GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE 
Album, Artist, Auth, Clientcodes, Error, Invitation_Request, Invitations, 
Now_Playing, Places, Radio_Sessions, Scrobble_Sessions, Scrobbles, 
Similar_artist, Tags, Track, Users to \"www-data\"");
 //     $res = $mdb2->exec("GRANT SELECT, UPDATE ON users_uniqueid_seq to 
\"www-data\"");

Modified: trunk/nixtape/index.php
===================================================================
--- trunk/nixtape/index.php     2009-04-30 22:26:02 UTC (rev 1087)
+++ trunk/nixtape/index.php     2009-04-30 22:42:05 UTC (rev 1088)
@@ -25,7 +25,7 @@
 require_once('data/Server.php');
 require_once('data/TagCloud.php');
 
-$aTagCloud = TagCloud::GenerateTagCloud('Scrobbles', 'artist');
+$aTagCloud = TagCloud::GenerateTagCloud('Free_Scrobbles', 'artist');
 if (!PEAR::isError ($aTagCloud)) {
        $smarty->assign('tagcloud', $aTagCloud);
 }