<?php
	header("Content-Type: text/html; charset=ISO-8859-1");
	
	$zona = "0";
	$getZona = "";
	$getZona2 = "";
	if (isset($_GET["z"]))
	{
		$zona = $_GET["z"];
		if ($zona != 0)
		{
			$getZona = "?z=" . $zona;
			$getZona2 = "&z=" . $zona;
		}
	}
	
	$handle = new DBAccess();
	$link = $handle->openConnection();
	
	contaAccessi($handle);
	
	if (isset($_SESSION["UtenteID"]))
	{
		$utente = new Utente($_SESSION["UtenteID"], $handle);
	}
	else
	{
		$utente = new Utente(0, $handle);
	}
	
	$headerHTMLtitle = "LiveUs.it";
	$headerHTMLrss = array();
	$headerHTMLrssTitle = array();
	switch($menuDestra)
	{
		case "u1": //utente.php
			if (isset($_GET["id"]))
			{
				$utente->getUtente($handle, $_GET["id"]);
				$headerHTMLtitle = $utente->Nome . " " . $utente->Cognome . " - LiveUs.it";
				$headerHTMLrss[0] = "http://www.liveus.it/rss.php?p=u1&id=" . $utente->ID;
				$headerHTMLrssTitle[0] = $headerHTMLtitle;
			}
			break;
		case "a2": //articolo.php
			$articolo = new Articolo($handle, $_GET["id"]);
			$headerHTMLtitle = $articolo->getTitolo($handle) . ", di " . getAutoriArticolo($handle, $articolo->ID, 0) . " - LiveUs.it";
			$ogTitle = $articolo->getTitolo($handle);
			$ogType = "website";
			$ogImage = "http://www.liveus.it/images/banner200x200.gif";
			if ($articolo->Foto != "")
			{
				$ogImage = "http://www.liveus.it/public/articolo/" . $articolo->Foto;
			}
			$ogURL = "http://http://www.liveus.it/articolo.php?id=" . $_GET["id"];
			$ogDescription = "Articolo di " . getAutoriArticolo($handle, $articolo->ID, 0);
			if ($articolo->IDTipo == "5")
			{
				$ogDescription = "Segnalazione di " . getAutoriArticolo($handle, $articolo->ID, 0);
			}
			break;
		case "c0": //concerti.php
			if (isset($_GET["g"]))
			{
				$arrConcerti = array();
				$gg = $_GET["g"];
				getConcertiFuturi($handle, "", "", 0, $arrConcerti, 0, 1, $gg);
				if (count($arrConcerti) > 0)
				{
					//$dtConcerto = "";
					$dtConcerto = substr($gg, 6, 2) . " " . getNomeMese(substr($gg, 4, 2)) . " " . substr($gg, 0, 4);
					$headerHTMLtitle = "Concerti del " . $dtConcerto . " - LiveUs.it";
					$ogTitle = $headerHTMLtitle;
					$ogType = "website";
					$ogImage = "http://www.liveus.it/images/banner200x200.gif";
					if ($arrConcerti[0]["Foto"] != "")
					{
						$ogImage = "http://www.liveus.it/public/" . $arrConcerti[0]["PathFoto"] . "/" . $arrConcerti[0]["Foto"];
					}
					$ogURL = "http://http://www.liveus.it/concerti.php?g=" . $_GET["g"];
					$posto = $arrConcerti[0]["Sigla"];
					if (!is_null($arrConcerti[0]["Comune"]))
					{
						$posto = $arrConcerti[0]["Comune"] . ", " . $posto;	
					}
					$ogDescription = formatDateFromSQL($arrConcerti[0]["DataOra"], "dataestesa") . ", ore " . formatDateFromSQL($arrConcerti[0]["DataOra"], "ora") . ". " . 
											 		 getNomeArtistiConcerto($handle, $arrConcerti[0]["ID"], 0) . " @ " . $arrConcerti[0]["NomeLuogo"] . " (" . $posto . ").";
					if (count($arrConcerti) > 1)
					{
						$ogDescription .= " E ancora: ";
						for ($i = 1; $i < count($arrConcerti); $i++)
						{
							if ($i > 1)
							{
								$ogDescription .= ", ";
							}
							$ogDescription .= getNomeArtistiConcerto($handle, $arrConcerti[$i]["ID"], 0);
						}
						$ogDescription .= "...";
					}
				}
			}
			break;
		case "c1": //concerto.php
			if (isset($_GET["id"]))
			{
				$concerto = new Concerto($handle, $_GET["id"]);
				$headerHTMLtitle = getNomeArtistiConcerto($handle, $id, 0) . " @ " . $concerto->NomeLuogo . " - LiveUs.it";
				$ogTitle = $headerHTMLtitle;
				$ogType = "website";
				$ogImage = "http://www.liveus.it/images/banner200x200.gif";
				if ($concerto->Foto != "")
				{
					$ogImage = "http://www.liveus.it/public/" . $concerto->PathFoto . "/" . $concerto->Foto;
				}
				$ogURL = "http://http://www.liveus.it/concerto.php?id=" . $_GET["id"];
				$ogDescription = formatDateFromSQL($concerto->DataOra, "dataestesa") . ", ore " . formatDateFromSQL($concerto->DataOra, "ora") . ".";
			}
			break;
		case "r1": //realta.php
			if (isset($_GET["id"]))
			{
				$realta = new Realta($handle, $_GET["id"]);
				$headerHTMLtitle = $realta->Nome . " - LiveUs.it";
				$t = 2;
				if ($realta->TipoIsLuogo)
				{
					$t = 1;
				}
				if ($realta->TipoIsArtista)
				{
					$t = 0;
				}
				$headerHTMLrss[0] = "http://www.liveus.it/rss.php?p=r1&id=" . $_GET["id"] . "&t=" . $t;
				$headerHTMLrssTitle[0] = $headerHTMLtitle;
			}
			break;
		case "i":
			$headerHTMLrssTitle[0] = "Ultimi Articoli - LiveUs.it";
			$headerHTMLrss[0] = "http://www.liveus.it/rss.php?p=ia";
			$headerHTMLrssTitle[1] = "Prossimi Concerti - LiveUs.it";
			$headerHTMLrss[1] = "http://www.liveus.it/rss.php?p=ic" . $getZona2;
			break;
		case "dz":
			$ogTitle = "DEVELOPER ZONE - LiveUs.it";
			$ogType = "website";
			$ogImage = "http://www.liveus.it/images/banner200x200.gif";
			$ogURL = "http://www.liveus.it/developer.php";
			$ogDescription = "LiveUs.it è un social network musicale open source, cioè gli autori (più precisamente i detentori dei diritti) ne permettono, anzi ne favoriscono il libero studio e l'apporto di modifiche da parte di altri programmatori indipendenti.";
			break;
	}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
	<title><?php echo $headerHTMLtitle; ?></title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
	<meta name="google-site-verification" content="iz4f8OY4fm1WSg4aBjyXHc5bbieOkJZaWL3kaXMGl7w" />
	<meta name="Author" content="Daniele Assereto" />
	<meta name="Keywords" content="Live Us, LiveUs, Musica, Italia, Live, Concerti, Gigs, Italy, Locali, Booking" />
<?php
	if (count($headerHTMLrss) > 0)
	{
		for ($i = 0; $i < count($headerHTMLrss); $i++)
		{
			echo "	<link rel='alternate' type='application/rss+xml' title='" . $headerHTMLrssTitle[$i] . " (RSS 2.0)' href='" . $headerHTMLrss[$i] . "' />\n";
		}
	}
?>
	<link rel="stylesheet" href="style.css" type="text/css" />
<?php
	if ($menuDestra != "i")
	{
?>
	<link href="/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css"/>
	<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
  <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
	<script type="text/javascript" src="jquery.form.js"></script>
	<script type="text/javascript" src="/facebox/facebox.js"></script> 
<?php
		if (isset($_SESSION["UtenteID"]) || $menuDestra == "register")
		{
?>
	<script type="text/javascript" src="jquery.autocomplete.js"></script>
	<script type="text/javascript" src="tinymce/tiny_mce.js"></script>
	<script type="text/javascript" language="javascript">
  <!--
    tinyMCE.init({
        mode : "textareas",
        theme : "advanced",
        theme_advanced_buttons1 : "bold,italic,underline,separator,justifyleft,justifycenter,justifyright,justifyfull,separator,link,code",
        theme_advanced_buttons2 : "",
        theme_advanced_buttons3 : "",
        theme_advanced_toolbar_location : "top",
        theme_advanced_toolbar_align : "left",
        theme_advanced_statusbar_location : "bottom",
        extended_valid_elements : "a[name|href|target|title|onclick],img[class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]"
    });

		$(document).ready(function(){
				$('#submitform').ajaxForm({
					target: '#error',
					success: function() {
					$('#error').fadeIn('slow');
					}
			});
		$('a[rel*=facebox]').facebox()
			 });
			 
		function filtraZona(idZona)
		{
			location.href = "http://" + location.hostname + location.pathname + "?z=" + idZona;
		}
	//-->
	</script>
<?php
		}
	}
	
	if (isset($ogTitle))
	{
		if ($ogTitle != "")
		{
			echo "<meta property=\"og:title\" content=\"" . $ogTitle . "\" />";
			echo "<meta property=\"og:type\" content=\"" . $ogType . "\" />";
			echo "<meta property=\"og:image\" content=\"" . $ogImage . "\" />";
			echo "<meta property=\"og:url\" content=\"" . $ogURL . "\" />";
			echo "<meta name=\"description\" property=\"og:description\" content=\"" . $ogDescription . "\" />";
			echo "<meta property=\"og:site_name\" content=\"LiveUs.it\" />";
			echo "<meta property=\"og:locale\" content=\"it_IT\" />";
		}
	}
?>
</head>
<body>

<table style='width:100%; height:100%;'><tr>
<td style='width:50%; background-image:url(images/<?php echo ImgLiveUs("background-sx.gif"); ?>); background-repeat:no-repeat; background-position:top right;'></td>
<td style='width:1003px; background-image:url(images/<?php echo ImgLiveUs("background.gif"); ?>); background-repeat:no-repeat; background-position:top;'>
<table style='height:100%;'>
<tr><td colspan='4' style='width:1003px; height:146px; background-image:url(<?php echo ImgLiveUs("images/top.gif"); ?>); vertical-align:top;'>
<table align='left'><tr><td><a href='http://www.liveus.it/index.php'><img src='images/null.gif' alt='LiveUs' width='250' height='70' border='0' style='margin-top:70px;'></a></td></tr></table>
<?php
	$banner = getBanner($handle);
	echo "<a href='" . $banner["Link"] . "' target='_blank'><img src='/public/banner/" . ImgLiveUs($banner["Foto"]) ."' alt='" . $banner["Alt"] . "' border='0' width='468' height='60' style='margin:40 0 0 212;'></a>";
?>	
	<div style='text-align:right; margin-top:30px; margin-right:185px;'>
<?php
	if ($utente->ID == 0)
	{
?>
<a style='font-weight:bold; text-transform:uppercase; color:#000000' href='login.php'>Login</a> / 
<a style='font-weight:bold; text-transform:uppercase; color:#000000' href='register.php'>Register</a>
<?php
	}
	else
	{
		echo "<a href='utente.php' style='color:#000000'>" . $utente->Nome . " " . $utente->Cognome . "</a> / ";
?>
<a style='font-weight:bold; text-transform:uppercase; color:#000000' href='login.php?a=LOGOUT'>Esci</a>
<?php
	}
?>
	</div>
	</td></tr>

<tr style='background-color:#FFFFFF;'>
<td style='vertical-align:top; width:20px; background-image:url(images/left.gif);'><img src='images/jack.gif' alt='' width='20' height='112'></td>
<td style='vertical-align:top; width:137px; height:100%; text-align:center;'>
	<table style='text-align:center; width:100%; height:100%; border-style:solid; border-color:#000000; border-width:5px 5px 0px 5px;'><tr><td style='padding:2px; text-align:center; vertical-align:top;'>
	<table style='text-align:center; width:100%; height:100%; vackground:#FBC44F; background-image:url(images/<?php echo ImgLiveUs("lateral.gif"); ?>);'><tr><td style='background-image:url(images/microphone.png); background-repeat:no-repeat; background-position:bottom right; test-align:center; vertical-align:top;'>
	<center>
	<form><select id='zona' name='zona' style='width:115px; margin-top:4px;' onchange='filtraZona(this.options[selectedIndex].value);'><option value='0'>Filtra per regione...</option>
<?
	$query = "SELECT z.ID, z.Nome FROM zona z INNER JOIN zona_provincia zp ON zp.IDZona = z.ID INNER JOIN realta r ON zp.IDProvincia = r.IDProvincia GROUP BY z.ID, z.Nome
						UNION ALL
						SELECT z.ID, z.Nome FROM zona z INNER JOIN zona_nazione zn ON zn.IDZona = z.ID INNER JOIN realta r ON zn.IDNazione = r.IDNazione GROUP BY z.ID, z.Nome
						ORDER BY ID";
	$res = $handle->getRecordset($query);
	$num_row = mysql_num_rows($res);
	
	if ($num_row > 0)
	{
		while($row = mysql_fetch_assoc($res))
		{
			$selected = "";
			if ($row["ID"] == $zona)
			{
				$selected = " selected";
			}
			echo "<option value='" . $row["ID"] . "'" . $selected . ">" . $row["Nome"] . "</option>";
		}
	}
?>
	</select></form>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:15px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='concerti.php<?php echo $getZona; ?>'><img src='images/concerts.gif' border='0' alt='CONCERTS' width='106' height='15' align='center'></a></div>
	<div style='margin-right:4px; text-align:right;'><img src='images/foglia-dx.png' alt='' width='32' height='25'></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='artisti.php<?php echo $getZona; ?>'><img src='images/artists.gif' border='0' alt='ARTISTS' width='106' height='15' align='center'></a></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='luoghi.php<?php echo $getZona; ?>'><img src='images/locations.gif' border='0' alt='LOCATIONS' width='106' height='15' align='center'></a></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='organizzatori.php<?php echo $getZona; ?>'><img src='images/makers.gif' border='0' alt='MAKERS' width='106' height='15' align='center'></a></div>
	<div style='margin-left:4px;'><img src='images/foglia-sx.png' alt='' width='32' height='25'></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='novita.php<?php echo $getZona; ?>'><img src='images/novita.gif' border='0' alt='NOVITA' width='106' height='15' align='center'></a></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='articoli.php<?php echo $getZona; ?>'><img src='images/articles.gif' border='0' alt='ARTICLES' width='106' height='15' align='center'></a></div>
	<div style='margin-right:4px; text-align:right;'><img src='images/foglia-dx.png' alt='' width='32' height='25'></div>
	<div style='text-align:center; vertical-align:middle; width:106px; padding:7px 4px 7px 3px; margin-top:4px; border-width:1px; border-style:solid; border-color:#000000; background:#FFFFFF;'><a href='/forum/' target='_blank'><img src='images/forum.gif' border='0' alt='FORUM' width='106' height='15' align='center'></a></div>
	<div style='margin-left:4px;'><img src='images/foglia-sx.png' alt='' width='32' height='25'></div>
	</center>
	<div style='position:relative; bottom:-50px; left:-8px;'><img src='images/ramo.png' alt='' width='50' height='107'></div>
	</td></tr></table>
	</td></tr></table>	
</td>
<td style='vertical-align:top; width:668px; height:100%'>
	<table style='width:668px; height:79px;'><tr>
	<td style='vertical-align:top; width:94px;'><img src='images/null.gif' alt='' width='94' height='1'></td>
	<td style='vertical-align:top; width:207px;'><img src='images/<?php echo ImgLiveUs("guitars.gif"); ?>' alt='' width='207' height='79'></td>
	<td style='vertical-align:middle; width:367px; text-align:middle;'>
<?php
	switch($menuDestra)
	{
		case "c0": //concerti.php
			echo "<img src='images/" . ImgLiveUs("concerts_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "a0": //artisti.php
			echo "<img src='images/" . ImgLiveUs("artists_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "l0": //luoghi.php
			echo "<img src='images/" . ImgLiveUs("locations_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "m0": //organizzatori.php
			echo "<img src='images/" . ImgLiveUs("makers_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "r0": //articoli.php
			echo "<img src='images/" . ImgLiveUs("articles_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "g0": //garagerec.php
			echo "<img src='images/" . ImgLiveUs("garagerec_big.gif") . "' alt='Concerts' width='367' height='79'>";
			break;
		case "n0": //novita.php
			echo "<img src='images/" . ImgLiveUs("novita_big.gif") . "' alt='Novita' width='367' height='79'>";
			break;
		default:
			break;
	}
?>		
	</td>
	</tr></table>
	<table style='width:668px; height:100%;'><tr style='height:100%'><td colspan='3' style='height:100%; padding:5px; vertical-align:top;'>