ajax-last-played.php

<?php
//  +------------------------------------------------------------------------+
//  | O!MPD, Copyright © 2015-2021 Artur Sierzant                            |
//  | http://www.ompd.pl                                                     |
//  |                                                                        |
//  |                                                                        |
//  | This program is free software: you can redistribute it and/or modify   |
//  | it under the terms of the GNU General Public License as published by   |
//  | the Free Software Foundation, either version 3 of the License, or      |
//  | (at your option) any later version.                                    |
//  |                                                                        |
//  | This program is distributed in the hope that it will be useful,        |
//  | but WITHOUT ANY WARRANTY; without even the implied warranty of         |
//  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          |
//  | GNU General Public License for more details.                           |
//  |                                                                        |
//  | You should have received a copy of the GNU General Public License      |
//  | along with this program.  If not, see <http://www.gnu.org/licenses/>.  |
//  +------------------------------------------------------------------------+

require_once('include/initialize.inc.php');
require_once('include/library.inc.php');

global $cfg, $db;

$size = $_POST["tileSize"];
$user_id = $_POST["user_id"];

authenticate('access_media');


$query_string = "
  SELECT * FROM
  (SELECT album_id, time FROM counter
  WHERE user_id = $user_id
  ORDER BY time DESC
  LIMIT 20) c
  GROUP BY c.album_id
  ORDER BY c.time DESC";

$query = mysqli_query($db,$query_string);

$hra_session = false;

$c = 0;
while ( $album = mysqli_fetch_assoc ($query)) {
	$c++;
	if ($c > 15) break; //show max 15 albums
	$albums = array();
	$a_id = $album['album_id'];
	$albums['album_id'] = $a_id;
	$tidal_cover = '';
	if (isTidal($a_id)){
    if (!$cfg['use_tidal']) { //in case one stopped Tidal subscription
      $albums = null;
      continue;
    }
		$query1 = mysqli_query($db, "SELECT album, cover, artist_alphabetic, audio_quality FROM tidal_album 
		WHERE album_id='" . getTidalId($a_id) . "' LIMIT 1");
		$a = mysqli_fetch_assoc ( $query1 );
		$albums['album'] = $a['album'];
		$tidal_cover = $a['cover'];
		$albums['artist_alphabetic'] = $a['artist_alphabetic'];
		$albums['audio_quality'] = $a['audio_quality'];
	}
	elseif (isHra($a_id)){
		if (!$hra_session) {
			$h = new HraAPI;
			$h->username = $cfg["hra_username"];
			$h->password = $cfg["hra_password"];
			if (NJB_WINDOWS) $t->fixSSLcertificate();
			$conn = $h->connect();
			if ($conn === true) $hra_session = true;
		}
		if ($hra_session === true){
			$results = $h->getAlbum(getHraId($a_id));
			if ($results['data']['results']){
				$albums['album'] = $results['data']['results']['title'];
				$albums['cover'] = 'https://' . $results['data']['results']['cover']['master']['file_url'];
				$albums['artist_alphabetic'] = $results['data']['results']['artist'];
				if ($cfg['show_album_format']) {
					$albums['audio_quality'] = $results['data']['results']['tracks'][0]['format'];
				}
			}
			else {
				$albums = null;
			}
		}
		else {
			$albums = null;
		}
		
	}
	else {
		$query1 = mysqli_query($db, "SELECT album, image_id, artist_alphabetic FROM album 
		WHERE album_id='" . $a_id . "' LIMIT 1");
		$a = mysqli_fetch_assoc ( $query1 );
		$albums['album'] = $a['album'];
		$albums['image_id'] = $a['image_id'];
		$albums['artist_alphabetic'] = $a['artist_alphabetic'];
	}
	if ($albums) {
    draw_tile ( $size, $albums, '', 'echo', $tidal_cover );
  }
}
if ($c == 0) {
  echo "<h1>&nbsp;&nbsp;No recently played albums</h1>";
}
?>