[Librefm-commits] [1035] try out some simple ugly charting

[Clint Adams]

Revision: 1035
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1035
Author:   clint
Date:     2009-04-30 03:56:47 +0000 (Thu, 30 Apr 2009)
Log Message:
-----------
try out some simple ugly charting

Modified Paths:
--------------
    trunk/nixtape/data/User.php
    trunk/nixtape/profile.php
    trunk/nixtape/themes/librefm/templates/profile.tpl

Modified: trunk/nixtape/data/User.php
===================================================================
--- trunk/nixtape/data/User.php 2009-04-29 23:33:17 UTC (rev 1034)
+++ trunk/nixtape/data/User.php 2009-04-30 03:56:47 UTC (rev 1035)
@@ -179,5 +179,31 @@
                return $session_id;
        }
 
+       /**
+        * get user's top 20 tracks
+        *
+        * @return user's top 20 tracks
+        */
+       function getTopTracks($number=20) {
+               global $mdb2;
+
+               $res = $mdb2->query("SELECT COUNT(track) as c, artist, track 
FROM Scrobbles WHERE rating<>'S' GROUP BY track ORDER BY c DESC LIMIT 20");
+
+               if(PEAR::isError($res)) {
+                   return $res;
+               }
+
+               $data = $res->fetchAll(MDB2_FETCHMODE_ASSOC);
+               foreach($data as $i) {
+                   $row = sanitize($i);
+                   $row["artisturl"] = Server::getArtistURL($row["artist"]);
+                   $row["trackurl"] = Server::getTrackURL($row["track"]);
+                   $result[] = $row;
+               }
+
+               return $result;
+       }
+
+
 }
 

Modified: trunk/nixtape/profile.php
===================================================================
--- trunk/nixtape/profile.php   2009-04-29 23:33:17 UTC (rev 1034)
+++ trunk/nixtape/profile.php   2009-04-30 03:56:47 UTC (rev 1035)
@@ -76,6 +76,8 @@
                                'href' => 
$base_url.'/rdf.php?fmt=xml&page='.htmlentities($_SERVER['REQUEST_URI'])
                                )
                ));
+
+       $smarty->assign('toptracks', $user->getTopTracks);
        
        $smarty->display('profile.tpl');
 } else {

Modified: trunk/nixtape/themes/librefm/templates/profile.tpl
===================================================================
--- trunk/nixtape/themes/librefm/templates/profile.tpl  2009-04-29 23:33:17 UTC 
(rev 1034)
+++ trunk/nixtape/themes/librefm/templates/profile.tpl  2009-04-30 03:56:47 UTC 
(rev 1035)
@@ -58,6 +58,12 @@
 {/section}
 </ul>
 
+<ul>
+{section name=i loop=$toptracks}
+<li class="toptrack"><a 
href="{$toptracks[i].artisturl}">{$toptracks[i].artist}</a> - <a 
href="{$toptracks[i].trackurl}">>{$toptracks[i].track}<a></li>
+{/section}
+</ul>
+
 <!-- Column break -->
 </div></div><div class="yui-u" id="sidebar"><div style="padding: 10px;">