48 lines
2.0 KiB
PHP
48 lines
2.0 KiB
PHP
<?php
|
|
/*
|
|
* Smarty plugin
|
|
* -------------------------------------------------------------
|
|
* File: function.userscrobbles.php
|
|
* Type: function
|
|
* Name: userscrobbles
|
|
* Purpose: outputs an array of recent scrobbles by $userid
|
|
* -------------------------------------------------------------
|
|
*/
|
|
function smarty_function_userscrobbles($params, $template) {
|
|
|
|
/**
|
|
* Retrieves a list of tracks
|
|
*
|
|
* @param string $userid User's unique id (required)
|
|
* @return array scrobbles
|
|
*/
|
|
global $adodb, $base_url, $default_theme;
|
|
$default_artist_image = $base_url . '/themes/' . $default_theme . '/img/qm160.png';
|
|
$userid = $params['userid'];
|
|
$limit = $params['limit'] ? $params['limit'] : 20;
|
|
$offset = $params['offset'] ? $params['offset'] : 0;
|
|
|
|
//$query = 'SELECT s.artist, s.track, s.time, lt.userid as loved, a.image_small as image, t.streamable FROM Scrobbles s LEFT JOIN Scrobble_Track st ON (s.stid=st.id) LEFT JOIN Track t ON (st.track=t.id) LEFT JOIN Artist a ON (t.artist_name=a.name) LEFT JOIN Loved_Tracks lt ON (s.artist=lt.artist AND s.track=lt.track AND s.userid=lt.userid) WHERE s.userid=?';
|
|
$query = 'SELECT s.artist, s.track, s.time, lt.userid as loved, b.image as image, t.streamable FROM Scrobbles s LEFT JOIN Scrobble_Track st ON (s.stid=st.id) LEFT JOIN Track t ON (st.track=t.id) LEFT JOIN Artist a ON (t.artist_name=a.name) LEFT JOIN Loved_Tracks lt ON (s.artist=lt.artist AND s.track=lt.track AND s.userid=lt.userid) LEFT JOIN Album b ON (s.album=b.name) WHERE s.userid=?';
|
|
$qparams = array($userid);
|
|
|
|
$query .= ' ORDER BY time DESC LIMIT ? OFFSET ?';
|
|
$qparams[] = (int) $limit;
|
|
$qparams[] = (int) $offset;
|
|
|
|
$adodb->SetFetchMode(ADODB_FETCH_ASSOC);
|
|
$data = $adodb->CacheGetAll(600, $query, $qparams);
|
|
|
|
foreach($data as &$item) {
|
|
$item['artisturl'] = Server::getArtistURL($item['artist']);
|
|
$item['trackurl'] = Server::getTrackURL($item['artist'], null, $item['track']);
|
|
$item['timehuman'] = human_timestamp($item['time']);
|
|
if (!$item['image']) {
|
|
$item['image'] = $default_artist_image;
|
|
}
|
|
}
|
|
|
|
$template->assign(userscrobbles, $data);
|
|
}
|
|
?>
|