[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1903] complete renaming c to freq
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1903] complete renaming c to freq |
Date: |
Wed, 03 Jun 2009 14:50:27 +0000 |
Revision: 1903
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1903
Author: clint
Date: 2009-06-03 14:50:26 +0000 (Wed, 03 Jun 2009)
Log Message:
-----------
complete renaming c to freq
Modified Paths:
--------------
trunk/nixtape/data/User.php
Modified: trunk/nixtape/data/User.php
===================================================================
--- trunk/nixtape/data/User.php 2009-06-03 14:50:24 UTC (rev 1902)
+++ trunk/nixtape/data/User.php 2009-06-03 14:50:26 UTC (rev 1903)
@@ -238,9 +238,9 @@
global $adodb;
if ($since) {
- $query = 'SELECT COUNT(track) as freq, artist, album,
track FROM Scrobbles WHERE userid = '.($this->uniqueid).' AND time >
'.(int)($since).' GROUP BY artist,album,track ORDER BY c DESC LIMIT ' .
($number);
+ $query = 'SELECT COUNT(track) as freq, artist, album,
track FROM Scrobbles WHERE userid = '.($this->uniqueid).' AND time >
'.(int)($since).' GROUP BY artist,album,track ORDER BY freq DESC LIMIT ' .
($number);
} else {
- $query = 'SELECT COUNT(track) as freq, artist, album,
track FROM Scrobbles WHERE userid = '.($this->uniqueid).' GROUP BY
artist,album,track ORDER BY c DESC LIMIT ' . ($number);
+ $query = 'SELECT COUNT(track) as freq, artist, album,
track FROM Scrobbles WHERE userid = '.($this->uniqueid).' GROUP BY
artist,album,track ORDER BY freq DESC LIMIT ' . ($number);
}
$adodb->SetFetchMode(ADODB_FETCH_ASSOC);
$data = $adodb->CacheGetAll(7200,$query);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1903] complete renaming c to freq,
Clint Adams <=