[Librefm-commits] [1741] add User->getTotalTracks function

[Clint Adams]

Revision: 1741
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1741
Author:   clint
Date:     2009-05-23 16:50:01 +0000 (Sat, 23 May 2009)
Log Message:
-----------
add User->getTotalTracks function

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

Modified: trunk/nixtape/data/User.php
===================================================================
--- trunk/nixtape/data/User.php 2009-05-23 16:39:45 UTC (rev 1740)
+++ trunk/nixtape/data/User.php 2009-05-23 16:50:01 UTC (rev 1741)
@@ -264,4 +264,21 @@
 
                return $result;
        }
+
+       public function getTotalTracks($since=null) {
+               global $adodb;
+
+               if ($since) {
+                       $query = 'SELECT COUNT(*) FROM Scrobbles WHERE username 
= '.$adodb->qstr($this->name).' AND time > '.(int)($since);
+               } else {
+                       $query = 'SELECT COUNT(*) FROM Scrobbles WHERE username 
= '.$adodb->qstr($this->name);
+               }
+               try {
+                       $tracks = $adodb->CacheGetOne(200, $query)
+               } catch (exception $e) {
+                       $tracks = 0;
+               }
+
+               return $tracks;
+       }
 }