saveToXml($output, 'artist'); $edit_id = -1; include 'foundAlbums.php'; } else { if ($albumName == 'albumName' || $albumName == '') { $artist = str_replace(' ', '+', $artist); $url = 'https://api.spotify.com/v1/search?q=' . $artist . '&type=artist'; $output = fetchAsJson($url); $url = 'https://api.spotify.com/v1/artists/' . $output['artists']['items'][0]['id'] . '/albums?album_type=album'; $output = fetchAsJson($url); saveToXml($output, 'album'); $edit_id = -1; include 'foundAlbums.php'; } else { $albumName = str_replace(' ', '+', $albumName); $artist = str_replace(' ', '+', $artist); $url = 'https://api.spotify.com/v1/search?q=album%3A' . $albumName . '+artist%3A' . $artist . '&type=album'; $albumName = ucwords(strtolower(str_replace('+', ' ', $albumName))); $artist = ucwords(strtolower(str_replace('+', ' ', $artist))); $outputAsJson = fetchAsJson($url); if ($outputAsJson['albums']['total'] == 0) { $imgUrl = '../img/placeholder.png'; $albumUrl = 'https://open.spotify.com/album/404'; } else { echo $albumID = $outputAsJson['albums']['items'][0]['id']; getAlbumInfo($year, $numTracks, $albumID); $imgUrl = $outputAsJson['albums']['items'][0]['images'][0]['url']; $albumUrl = $outputAsJson['albums']['items'][0]['external_urls']['spotify']; } } }
} $imageLength = getImageListLength($artist->image); insertImageUrl($dbHandle, $artist->image, $imageLength, $artistId, 0, $ARTIST_ARTWORK_FLAG, array(0 => $ARTIST_ARTWORK_FLAG, 1 => $ALBUM_ARTWORK_FLAG), $MAX_IMAGE_COUNT); saveBio($artistId . "-artist_bio.txt", $artist->bio->content, $fp, $DATABASE_SCRIPT_DIR, $DS_ARTIST_BIO_DIR, $DS_LOGS_DIR); $dbHandle->query("UPDATE artist_list SET \n `bio_file`='" . addslashes($artistId . "-artist_bio.txt") . "', time_added='" . getRandom() . "' WHERE artist_id='" . $artistId . "'"); } ////////////////////////////////////////////////////////////// // ALBUM STUFF // $dataDump = uwe_file_get_contents("http://ws.audioscrobbler.com/2.0/?method=artist.gettopalbums&artist=" . urlencode($artist->name) . "&api_key=" . $LASTFM_API_KEY . "&format=json"); $albumList = json_decode($dataDump)->topalbums; $albumLength = getAlbumLength($albumList); for ($i = 0; $i < $albumLength; $i++) { if ($albumLength == 1) { $albumInfo = getAlbumInfo($albumList->album); } else { $albumInfo = getAlbumInfo($albumList->album[$i]); } if (albumExist($dbHandle, $artistId, addslashes($albumInfo['name']))) { fprintf($fp, "DUP Album, skipping album\n"); $warning++; } else { $sql[0] = "INSERT INTO album_list (artist_id, album_title, time_added) VALUES ('" . $artistId . "', '" . addslashes($albumInfo['name']) . "', '" . getRandom() . "')"; $sql[1] = "SELECT * FROM album_list WHERE artist_id='" . $artistId . "' AND `album_title`='" . addslashes($albumInfo['name']) . "'"; if (!insertQuery($dbHandle, $sql)) { fprintf($fp, "Unable to add album to database\n"); fclose($fp); echo "Failed adding album"; exit; } if (!albumExist($dbHandle, $artistId, addslashes($albumInfo['name']))) { fprintf($fp, "Unable to retrieve album from database\n");
function getInfo($stream) { if (!$stream['info']['song']) { $stream['info']['song'] == 'Not found'; return $stream; } if (GET_TRACK_INFO == TRUE) { $stream = getTrackInfo($stream); } if (GET_ALBUM_INFO && isset($stream['album']['title'])) { $stream = getAlbumInfo($stream); } if (GET_ARTIST_INFO == TRUE) { $stream = getArtistInfo($stream); } if (GET_TRACK_BUY_LINK == TRUE) { $stream = getTrackBuyLink($stream); } if (CACHE_ALBUM_ART == TRUE) { $stream['album']['local_image'] = cacheAlbumArt($stream['album']['image_l']); } if (GET_LYRICS == TRUE) { $stream['track']['lyric'] = getLyric($stream['info']['artist'], $stream['info']['song']); } $stream['fetch_time'] = time(); return $stream; }
function showSubAlbum($root = 1) { global $db, $prefix, $moduleName, $iConfig, $pag, $ofsppg, $ofsbgn; $root = intval($root); $showDetails = intval($iConfig['show_details']); $showColumns = intval($iConfig['show_columns']); $thumbsPath = $iConfig['thumbs_path']; $thumbsRealPath = iPath($thumbsPath); $thumbsFormat = strtolower($iConfig['thumbs_format']); $albumCounter = 0; //echo '<table class="show-child" cellspacing="5" cellpadding="5"><tr>' . PHP_EOL; echo '<ul class="thumbnails">' . PHP_EOL; $column = 1; $srow = 1; $node = getNodes($root); $sql = 'SELECT node.*, (COUNT(parent.album_id) - (sub_tree.depth + 1)) AS depth FROM ' . $prefix . '_igallery_albums AS node, ' . $prefix . '_igallery_albums AS parent, ' . $prefix . '_igallery_albums AS sub_parent, ( SELECT node.*, (COUNT(parent.album_id) - 1) AS depth FROM ' . $prefix . '_igallery_albums AS node, ' . $prefix . '_igallery_albums AS parent WHERE node.album_left BETWEEN parent.album_left AND parent.album_right AND node.album_id = \'' . $node['id'] . '\' GROUP BY node.album_id ORDER BY node.album_left ) AS sub_tree WHERE node.album_left BETWEEN parent.album_left AND parent.album_right AND node.album_left BETWEEN sub_parent.album_left AND sub_parent.album_right AND sub_parent.album_id = sub_tree.album_id GROUP BY node.album_id HAVING depth = 1 ORDER BY node.album_left;'; $result = $db->sql_query($sql); while ($album = $db->sql_fetchrow($result)) { $albumCounter++; $catId = $album['album_id']; $folderName = $album['album_folder']; $cover = $album['album_cover']; $title = $album['album_title']; $description = $album['album_desc']; $albumParent = $album['album_id']; $what = getAlbumInfo($catId); $latestDate = $what[0]; $totalPics = $what[1]; if (!empty($cover)) { $info = pathinfo($cover); $rawCover = str_replace($info['extension'], '', $cover); } if (!empty($rawCover)) { $pictureId = $db->sql_fetchrow($db->sql_query('SELECT picture_id FROM ' . $prefix . '_igallery_pictures WHERE picture_file=\'' . $cover . '\' AND album_id=\'' . $albumId . '\' LIMIT 0,1')); $coverSrc = 'modules.php?name=' . $moduleName . '&op=getThumb&pictureid=' . $pictureId['picture_id']; } else { $catListIds = getSubAlbumIds($catId); if (!empty($catListIds) && $catListIds !== ',') { $catListIds = $catId . ', ' . $catListIds; $sql = 'album_id IN (' . $catListIds . ')'; } else { $sql = 'album_id=' . $catId . ''; } $data = $db->sql_fetchrow($db->sql_query('SELECT picture_id FROM ' . $prefix . '_igallery_pictures WHERE ' . $sql . ' LIMIT 0,1')); $pictureId = $data['picture_id']; $coverSrc = 'modules.php?name=' . $moduleName . '&op=getThumb&pictureid=' . $pictureId; } //echo '<td class="sub-album">' . PHP_EOL; //echo '<div class="thumb-target">' . PHP_EOL; echo '<li class="span3">' . PHP_EOL; echo '<div class="thumbnail">' . PHP_EOL; echo ' <a href="modules.php?name=' . $moduleName . '&op=showAlbum&albumid=' . $catId . '"><img class="sub-album" src="' . $coverSrc . '" alt="' . $title . '" /></a>' . PHP_EOL; //echo ' <div class="tooltip_description">' . PHP_EOL; //echo ' <p>' . PHP_EOL; //echo ' <span class="title">'.$title .'</span>'; echo ' <div class="caption">' . PHP_EOL; echo ' <h4>' . $title . '</h4>'; //echo showNewEmblem($latestDate); //echo '<br />' . PHP_EOL; if ($description) { echo ' <p>' . $description . '</p>' . PHP_EOL; } echo ' <span class="label label-info">' . $totalPics . ' ' . _IG_TOTALPICS . '</span>' . PHP_EOL; echo ' </div>'; echo '</div>'; echo '</li>' . PHP_EOL; /*if (($column%$showColumns)==0) { //echo '<div style="clear:left;"></div>' . PHP_EOL; echo '</tr><tr>' . PHP_EOL; $srow++; }*/ $column++; } //echo '<div style="clear:left;"></div></div>'; //echo '<td></td></tr></table>' . PHP_EOL; echo '</ul>' . PHP_EOL; //$totalItems = $db->sql_numrows($db->sql_query('SELECT album_id FROM '.$prefix .'_igallery_albums WHERE album_parent=0 AND album_active=1 ;')); //paginationSystem($ofsbgn, $ofsppg, $totalItems); //if ($srow!==1 || $column!==1) echo '<hr />'; }