<?php
ob_start();
?>
<div id="newest" data-role="collapsible" data-inline="true" data-theme="b">
<h3>Newest additions</h3>
<ul id="newest-list" data-role="listview" data-inset="true" data-theme="a" class="list">
<?php
include "../mysql.php";
include "../functions.php";
$db = new JHoDisc();
$db->connect();
if ($db->select("`subrelease` JOIN `release` ON release.id=subrelease.id_release JOIN `names` on names.id=release.id_name", "subrelease.name as name,names.name as album,id_release as id,subrelease.id as id2,band,type,format", null, "subrelease.pubDate DESC LIMIT 31")) {
$nameRow = $db->getResult();
foreach ($nameRow as $item) {
echo "<li><a rel='external' href='/mobile/release/" . $item['band'] . "/" . $item['format'] . "/" . $item['type'] . "/" . $item['id'] . "/" . $item['id2'] . "#n" . $item['id2'] . "'>" . $db->bandShortNames[$item['band']] . " - " . $item['album'] . " - " . $item['name'] . "</a></li>";
}
}
?>
</ul>
</div>
<?php
$fp = fopen("newest.php", 'w');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
<?php
include 'mysql.php';
include 'functions.php';
$db = new JHoDisc();
$db->connect();
$result = $db->getRSS();
$now = date(DATE_RSS);
$output = "<?xml version='1.0' encoding='UTF-8'?>\r\n\t\t<rss version='2.0' xmlns:atom='http://www.w3.org/2005/Atom'>\r\n\t\t\t<channel>\r\n\t\t\t\t<atom:link href='http://jhodiscography.xtreemhost.com/rss/qotsa.xml' rel='self' type='application/rss+xml' />\r\n\t\t\t\t<title>Joshua Homme discography</title>\r\n\t\t\t\t<description>Kyuss, QotSA, EoDM, Desert Sessions, TCV</description>\r\n\t\t\t\t<link>http://jhodiscography.xtreemhost.com/</link>\r\n\t\t\t\t<pubDate>{$now}</pubDate>\r\n\t\t\t\t<lastBuildDate>{$now}</lastBuildDate>\r\n\t\t\t\t";
$domain = "jhodiscography.xtreemhost.com";
foreach ($result as $item) {
$mainImage = $domain . "/assets/images/releases/" . $item['band'] . "/" . $item['format'] . "/" . $item['type'] . "/" . $item['id'] . "/" . $item['id2'] . "/1.jpg";
$output .= '<item>
<guid>http://jhodiscography.xtreemhost.com/releases/' . $item['band'] . "/" . $item['format'] . "/" . $item['type'] . "/" . $item['id'] . '/' . $item['id2'] . '</guid>
<title>
' . $db->bandShortNames[$item['band']] . " - " . $item['album'] . ' - ' . $item['name'] . '
</title>
<description>
<![CDATA[<table border="0" cellpadding="0" style="text-align: center;font-size: 12px;">
<tr>
<td width="50%" style="padding: 0 5px;">
<a href="http://jhodiscography.xtreemhost.com/releases/' . $item['band'] . "/" . $item['format'] . "/" . $item['type'] . "/" . $item['id'] . '/' . $item['id2'] . '">
<img border="0" src="http://' . $mainImage . '" width="135px"/>
</a>
</td>
<td style="padding: 0 5px 0 5px; text-align: left;">
<b>Year:</b> ' . $item['year'] . '<br /><br/>
<b>Released by:</b> ' . $item['label'] . '<br /><br/>
<b>Info / barcode:</b> ' . $item['info'] . '<br /><br/>
<b>Mx#:</b> ' . $item['matrix'] . '
</td>
<?php
include '../mysql.php';
include '../functions.php';
$db = new JHoDisc();
$db->connect();
$db->setVars($_REQUEST['band'], $_REQUEST['format'], $_REQUEST['type'], null);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<link rel="stylesheet" href="https://ajax.aspnetcdn.com/ajax/jquery.mobile/1.1.1/jquery.mobile-1.1.1.min.css" />
<link rel="stylesheet" href="/mobile/style.css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js">
</script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.mobile/1.1.1/jquery.mobile-1.1.1.min.js">
</script>
<script>$.mobile.pushStateEnabled = false;</script>
<title>
<?php
echo $db->getTitle() . " Discography - " . $db->getReleaseType() . " " . $db->getFormatName();
?>
</title>
<script type="text/javascript" src="/assets/scripts/ga.js"></script>
<link rel='alternate' type='application/rss+xml' title='Joshua Homme discography' href='http://jhodiscography.xtreemhost.com/rss/qotsa.xml' />
</head>
<body>
<div data-role="page" id="page1">
<div data-role="header" class="header" data-theme="a">
<?php
session_start();
if (isset($_REQUEST['desktop'])) {
$_SESSION['desktop'] = true;
}
include 'mysql.php';
include 'functions.php';
$db = new JHoDisc();
$db->connect();
$url = "";
if ($_REQUEST['id'] && is_numeric($_REQUEST['id'])) {
$db->setVars(null, null, null, $_REQUEST['id']);
$vars = $db->getVars();
if ($vars['band'] != $_REQUEST['band'] || $vars['format'] != $_REQUEST['format'] || $vars['type'] != $_REQUEST['type']) {
header("Location: /error.php");
}
$url = "releases/" . $vars['band'] . "/" . $vars['format'] . "/" . $vars['type'] . "/" . $vars['id'] . "/" . $_REQUEST['show'];
} else {
$db->setVars($_REQUEST['band'], $_REQUEST['format'], null, null);
$vars = $db->getVars();
if (isset($_REQUEST['type'])) {
$url = "releases/";
}
$url .= $vars['band'] . "/" . $vars['format'] . "/" . $_REQUEST['type'];
}
if (!isset($_SESSION['desktop'])) {
$useragent = $_SERVER['HTTP_USER_AGENT'];
if (preg_match('/android.+mobile|avantgo|bada\\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|meego.+mobile|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\\-(n|u)|c55\\/|capi|ccwa|cdm\\-|cell|chtm|cldc|cmd\\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\\-s|devi|dica|dmob|do(c|p)o|ds(12|\\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\\-|_)|g1 u|g560|gene|gf\\-5|g\\-mo|go(\\.w|od)|gr(ad|un)|haie|hcit|hd\\-(m|p|t)|hei\\-|hi(pt|ta)|hp( i|ip)|hs\\-c|ht(c(\\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\\-(20|go|ma)|i230|iac( |\\-|\\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\\/)|klon|kpt |kwc\\-|kyo(c|k)|le(no|xi)|lg( g|\\/(k|l|u)|50|54|\\-[a-w])|libw|lynx|m1\\-w|m3ga|m50\\/|ma(te|ui|xo)|mc(01|21|ca)|m\\-cr|me(di|rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\\-2|po(ck|rt|se)|prox|psio|pt\\-g|qa\\-a|qc(07|12|21|32|60|\\-[2-7]|i\\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\\-|oo|p\\-)|sdk\\/|se(c(\\-|0|1)|47|mc|nd|ri)|sgh\\-|shar|sie(\\-|m)|sk\\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\\-|v\\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\\-|tdg\\-|tel(i|m)|tim\\-|t\\-mo|to(pl|sh)|ts(70|m\\-|m3|m5)|tx\\-9|up(\\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\\-|your|zeto|zte\\-/i', substr($useragent, 0, 4))) {
$_SESSION['mobile'] = true;
header("Location: /mobile/{$url}");
<?php
include '../mysql.php';
include '../functions.php';
$db = new JHoDisc();
$db->connect();
$db->setVars(null, null, null, $_GET['id']);
$vars = $db->getvars();
$db->setOppId();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<link rel="stylesheet" href="https://ajax.aspnetcdn.com/ajax/jquery.mobile/1.1.1/jquery.mobile-1.1.1.min.css" />
<link rel="stylesheet" href="/mobile/style.css" />
<link rel="stylesheet" href="/mobile/photoswipe/photoswipe.css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.mobile/1.1.1/jquery.mobile-1.1.1.min.js"></script>
<script type="text/javascript" src="/mobile/photoswipe/lib/klass.min.js"></script>
<script type="text/javascript" src="/mobile/photoswipe/code.photoswipe.jquery-3.0.5.min.js"></script>
<script>$.mobile.pushStateEnabled = false;</script>
<title>
<?php
echo $db->bandShortNames[$vars['band']] . " - " . $db->getReleaseName() . " - " . $db->getFormatName() . " " . $db->getReleaseType() . " - " . $db->getTitle() . " Discography";
?>
</title>
<script type="text/javascript" src="/assets/scripts/ga.js"></script>
<link rel='alternate' type='application/rss+xml' title='Joshua Homme discography' href='http://jhodiscography.xtreemhost.com/rss/qotsa.xml' />
</head>
