"; $output .= "\r\n"; $output .= "\r\n"; $output .= "\r\n"; return $output; } function dbconnect() { global $dbhost, $dbuser, $dbpass, $db, $con; $con = mysql_connect($dbhost,$dbuser,$dbpass); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($db, $con); } $url = $_SERVER['REQUEST_URI']; ini_set('memory_limit', '128M'); //hier gebeurt de magie $archief = $_GET["archive"]; $store = $_GET["store"]; $lang = $_GET["lang"]; if(strlen($lang) < 1) { $lang = langdetect(); if($lang <> "nl" && $lang <> "en") { $lang = "en"; } } if($store == "") { $store = "BE"; } $feed["BE"] = "http://itunes.apple.com/be/rss/topsongs/limit=100/xml"; $feed["US"] = "http://itunes.apple.com/us/rss/topsongs/limit=100/xml"; $feed["NL"] = "http://itunes.apple.com/nl/rss/topsongs/limit=100/xml"; if($lang == "nl") { $tekst["BE"] = "Belgische"; $tekst["US"] = "Amerikaanse"; $tekst["NL"] = "Nederlandse"; $tekst_store = $tekst; $tekst_country["BE"] = "Belgiƫ"; $tekst_country["US"] = "Amerika"; $tekst_country["NL"] = "Nederland"; $tekst_watching = "Dit is de iTunes top 100 van {$tekst_country[$store]}"; $tekst_titel = "Titel en artiest"; $tekst_other = "Andere player"; $tekst_choice = "mp3"; $tekst_NF = "Niet gevonden"; $tekst_previous = "Vorige"; $tekst_next = "Volgende"; $tekst_archive = "Archief"; $tekst_list = "lijst"; $tekst_of = "van"; $tekst_year = "jaar"; $tekst_arr_month = array ( "01" => 'Januari', "02" => 'Februari', "03" => 'Maart', "04" => 'April', "05" => 'Mei', "06" => 'Juni', "07" => 'Juli', "08" => 'Augustus', "09" => 'September', "10" => 'Oktober', "11" => 'November', "12" => 'December' ); $tekst_ta = "zoek betere videoclip"; $tekst_info = "Is de 30 of 90 seconden preview op iTunes niet voldoende om te beslissen of het nummer je geld waard is? Dan kun je hier de volledige videoclips van elk nummer via YouTube beluisteren. Veel plezier!"; } if($lang == "en") { $tekst["BE"] = "Belgian"; $tekst["US"] = "American"; $tekst["NL"] = "Dutch"; $tekst_store = $tekst; $tekst_country["BE"] = "Belgium"; $tekst_country["US"] = "the United States"; $tekst_country["NL"] = "the Netherlands"; $tekst_watching = "You are now watching the iTunes top 100 of {$tekst_country[$store]}"; $tekst_titel = "Title and artist"; $tekst_other = "Other player"; $tekst_choice = "mp3"; $tekst_NF = "Not found"; $tekst_previous = "Previous"; $tekst_next = "Next"; $tekst_archive = "Archive"; $tekst_list = "list"; $tekst_of = "of"; $tekst_year = "year"; $tekst_arr_month = array ( "01" => 'January', "02" => 'February', "03" => 'March', "04" => 'April', "05" => 'May', "06" => 'June', "07" => 'July', "08" => 'August', "09" => 'September', "10" => 'October', "11" => 'November', "12" => 'December' ); $tekst_ta = "find better videoclip"; $tekst_info = "Is a 30 or 90 seconds preview on iTunes not enough to decide if the single is worth the money? Then you can listen here to the full length videoclips of each song on YouTube. Have fun!"; } $tekst_watching = utf8_decode($tekst_watching); if(strlen($archief) < 1) { $iTunesSource = $feed[$store]; } else { $iTunesSource = "./itunesxml/{$archief}.xml"; } $start = $_GET["n"]; if($start == "" || $start > 91 || $start < 1) { $start = 1; } dbconnect(); function getYtIdFromQuery($titel,$keywords=" official") { $query = urlencode($titel . $keywords); //eerst ytID opzoeken in database $dbtitel = urlencode($titel); $sql = "SELECT * FROM iTunesCache WHERE titel='{$dbtitel}'"; $result = mysql_query($sql); $aantal = mysql_num_rows($result); if($aantal == 0) { $queryUrl = "http://gdata.youtube.com/feeds/api/videos?q={$query}&start-index=1&max-results=1&v=2&fields=entry(link)"; $xml = simplexml_load_file($queryUrl); if(isset($xml->entry->link)) { $attrs = $xml->entry->link->attributes(); $ytUrl = $attrs["href"]; $ytUrl = strstr($ytUrl,"?v="); $overbodig = strstr($ytUrl,"&"); $ytUrl = str_replace($overbodig,"",$ytUrl); $ytUrl = str_replace("?v=","",$ytUrl); //invoeren in database if(strlen($ytUrl) > 0) { $sql = "INSERT INTO iTunesCache (titel,ytID) VALUES('". $dbtitel . "','" . $ytUrl . "')"; mysql_query($sql); } } else { $ytUrl = "NotFound"; } } else { //ophalen uit database $row = mysql_fetch_array($result); $ytUrl = $row["ytID"]; } return $ytUrl; } //nieuwe versie opzoeken if($_GET["id"] == "ajax") { $ytID = $_GET["ytID"]; if(strlen($ytID) == 11) { dbconnect(); $ytID = mysql_real_escape_string($ytID); $sql = "SELECT titel FROM iTunesCache WHERE ytID='{$ytID}'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $titel = urldecode($row["titel"]); $sql = "DELETE FROM iTunesCache WHERE ytID='{$ytID}'"; $result = mysql_query($sql); $ytID = getYtIdFromQuery($titel); $ref = $_GET["ref"]; $ref = base64_decode($ref); header("Location: {$ref}&autoplay={$ytID}"); exit; } } //lijst aanmaken van iTunes top 100 $huidigmoment = date("dmY"); $archieffile = "./itunesxml/{$huidigmoment}{$store}.xml"; if(!file_exists($archieffile)) { $inhoud = file_get_contents($iTunesSource); $file = fopen($archieffile, "w+"); fputs($file, $inhoud); fclose($file); if(filesize($archieffile) < 1) { unlink($archieffile); } } else { if(strlen($archief) < 1) $iTunesSource = $archieffile; } //bij archief titel aanpassen if(strlen($archief) > 0) { $archive_store = substr($archief,8,2); $tekst_watching = $tekst[$archive_store]; $dag = substr($archief,0,2); if($dag < 10) { $dag = substr($dag,1,1); } $maand = substr($archief,2,2); $jaar = substr($archief,4,4); $tekst_watching .= " iTunes top 100 {$tekst_list} {$tekst_of} {$dag} ". $tekst_arr_month[$maand]. " {$jaar}"; } function makeULLI($array) { global $tekst_arr_month, $lang, $tekst_list, $tekst_of, $tekst_year, $tekst_store; $return = ""; return $return; } ?> 0) { ?> <?php echo $tekst_watching; ?> <?php echo $tekst[$store]; ?> iTunes top 100 Nederlands | English 0) { ?>

iTunes top 100

\n"); ?>

iTunes store | iTunes store | iTunes store

"; if(strlen($archief) > 0) { $prefix = "archive={$archief}"; } else { $prefix = "store={$store}"; } for ($i = 1; $i <= 100; $i += 20) { if($i == $start) { $html_nav .= "{$i}-" . ($i + 19). " "; } else { $html_nav .= "{$i}-" . ($i + 19). " "; } } $html_nav .= ""; if($start < 20) { $html_nav2 = "\r\n{$tekst_previous} {$html_nav} {$tekst_next}"; } else { if($start > 80) { $html_nav2 = "\r\n{$tekst_previous} {$html_nav} {$tekst_next}"; } else { $html_nav2 = "\r\n{$tekst_previous} {$html_nav} {$tekst_next}"; } } echo $html_nav2; ?> entry[($i-1)]->title; $attrs = $rss->entry[($i-1)]->link->attributes(); $iTuneslink = $attrs["href"]; $ytID = getYtIdFromQuery($titel); $trackTitle = urlencode($titel); if($ytID <> "NotFound") { $downloadurl = "http://tunetune.net/{$lang}#http://www.youtube.com/watch?v=" . $ytID; if($gYTID == "") { $gYTID = $ytID; } echo "\r\n\r\n \r\n \r\n\r\n"; } else { $ytID = getYtIdFromQuery($titel," VEVO"); if($ytID <> "NotFound") { if($gYTID == "") { $gYTID = $ytID; } $downloadurl = "http://tunetune.net/{$lang}#http://www.youtube.com/watch?v=" . $ytID; echo "\r\n\r\n \r\n \r\n\r\n"; } else { echo "\r\n\r\n\r\n\r\n\r\n\r\n"; } } } ?>
Nr
{$i}". utf8_decode(wordwrap($titel, 35, "
\n")) . "
", "\r\n
{$tekst_ta}", "\r\n
iTunes | {$tekst_choice}\r\n
{$i}" . utf8_decode(wordwrap($titel, 35, "
\n")) . "
", "\r\n
{$tekst_ta}", "\r\n
iTunes | {$tekst_choice}\r\n
{$i}{$titel}iTunes | {$tekst_NF}



If you have questions or suggestions, please e-mail to hannesbossuyt@gmail.com. You can download the source code here
Made by Hannes Bossuyt
?>