[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1741] add User->getTotalTracks function
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1741] add User->getTotalTracks function |
Date: |
Sat, 23 May 2009 16:50:02 +0000 |
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;
+ }
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1741] add User->getTotalTracks function,
Clint Adams <=