Aiuto mappa.php

<?
session_start();
include ('inc/parametri.inc.php');
include ('inc/controllo.php');
include ('inc/open2.php');


/*function Pulsante($Dir, $IDDir) {

# echo $Dir.','.$IDDir."<br>";

if (($IDDir == "0") ||(($IDDir == ""))) {
return("<input type=button Value=' ".$Dir." ' style='color=brown'>");
} else {
$MySql = "SELECT Par, Breve, Pagina From Mappa WHERE ID = '".pars($IDDir)."'";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);

$Par = pars($rs['Par']);
$PaginaDir = pars($rs['Pagina']);

$temp = "<input type=submit Value=' $Dir ' style={background:gold}>";
$temp .= "<input type=hidden Name='Dir' Value='$IDDir'>";
$temp .= "<input type=hidden Name='Link' Value='$PaginaDir'>";
$temp .= "<input type=hidden Name='Par' Value='$Par'>";
$temp .= "<br>".htmlspecialchars($rs['Breve']);
$rs->close;
mysql_free_result($Result);
return($temp);
}
}*/


$Beep="beep.wav";

$Login=$_SESSION["Login"];
$Master=$_SESSION['Master'];

$op=$_REQUIRE['op'];
$Stanza=$_SESSION['Stanza'];

function Tempo()
{
return strftime("%H:%M");
}

$ore=strftime("%H");
$minuti=strftime("%M");


include("inc/controlloesilio.php");

/*if (($Master == '1') && ($op == 'Invisibile')) {
$Is_Invisibile = $_POST['Invisibile'];
$MySql = "UPDATE Presenti SET Is_Invisibile = '$Is_Invisibile' WHERE Nome = '".pars($Login)."'";
mysql_query($MySql);
}*/

$op = $_POST['op'];
if (($Master == '1') && ($op == 'CambioStato')) {
$NuovoStato = $_POST['StatoStanza'];
$MySql = "UPDATE Mappa SET Stato = '$NuovoStato' WHERE ID = '".pars($Stanza)."'";
mysql_query($MySql);
}


#---------------------------------------------------------------------------
$MySql = "Select Count(ID) AS NonLetti From Messaggi Where Destinatario = '".$Login."' and Letto = 0";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$NonLetti = $rs["NonLetti"];
$rs->close;
mysql_free_result($Result);



$MySql = "SELECT * FROM Mappa LEFT JOIN CodAllineamento ON CodAllineamento.IDAllineamento = Mappa.Allineamento WHERE Mappa.ID = '".pars($Stanza)."'";
#echo $MySql;
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$ID = $rs['ID'];
$N = $rs['N'];
$S = $rs['S'];
$E = $rs['E'];
$O = $rs['O'];
$Entra = $rs['Entra'];
$Esci = $rs['Esci'];
$Breve = $rs['Breve'];
$Descrizione = $rs['Descrizione'];
$Pagina = $rs['Pagina'];
$Chat = 0 + $rs['Chat'];
$Par = $rs['Par'];
$Immagine = $rs['Immagine'];
$Condizione = $rs['Condizione'];
$Stato = $rs['Stato'];
$LinkMappa = trim($rs['LinkMappa'].'');
$DescrizioneAllineamento = $rs['DescrizioneAllineamento'];
$ColoreAllineamento = $rs['Colore'];
$rs->close;
mysql_free_result($Result);

//echo "Stanza:".$ID; RIGA AGGIUNTA DI CORREZIONE.
$Stanza=$ID;



//$Stanza=107;

//echo $Stanza.",".$ID;

if ($Chat==1) {
$Pagina = 'palestra.php';
}



if($LinkMappa ==''){$LinkMappa = 'palestra.php';}


include ("inc/header.html.inc.php");
?>
<link rel="stylesheet" href="main_cornice.css" TYPE="text/css">
<meta HTTP-EQUIV="Refresh" CONTENT="60">
<style type="text/css">
<!--
body {
background-image: url();
background-repeat: no-repeat;
background-color: #000000;
}
-->
</style>
<script type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}

function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>



<body onLoad="MM_preloadImages('cdb1.jpg','persdt1.jpg','map1.jpg','osslg1.jpg','agg1.jpg','out1.jpg','loc1.jpg')">
<table height=1052 width=180 border=0 cellpadding="0" cellspacing="0">
<tr>
<td width="180" height="1052" valign=top><br>

<table border=0 width="180">



<tr>
<td height=37 align=center valign=top>
<? //meteo by mrfaber---------------------------------------------------------->
$mese=strftime("%m");
$giorno=strftime("%j");
$caso=((floor($giorno/3))%2)+1;
switch ($mese)
{
case 1: $minima=0; break;
case 2: $minima=4; break;
case 3: $minima=8; break;
case 4: $minima=12; break;
case 5: $minima=16; break;
case 6: $minima=20; break;
case 7: $minima=24; break;
case 8: $minima=24; break;
case 9: $minima=16; break;
case 10: $minima=10; break;
case 11: $minima=4; break;
case 12: $minima=0; break;
}

if($ore<14){$gradi=$minima+(floor($ore/3)*$caso);}
else{ $gradi=$minima+(4*$caso)-((floor($ore/3)*$caso))+(3*$caso);}

$caso=($giorno+($ora/4))%12;
switch ($caso)
{
case 0: $meteo="Sereno  "; break;
case 1: $meteo="Sereno  "; break;
case 2: $meteo="variabile  "; break;
case 3: $meteo="Nuvoloso"; break;
case 4: $meteo="Pioggia "; break;
case 5: $meteo="Nuvoloso"; break;
case 6: $meteo="Sereno  "; break;
case 7: $meteo="variabile  "; break;
case 8: $meteo="Pioggia "; break;
case 9: $meteo="Nuvoloso"; break;
case 10: $meteo="Sereno  "; break;
case 11: $meteo="Sereno  "; break;
}
$_SESSION['Meteo_S'] = $meteo;



?><b> <font color="#000000">

<br><br><br><br>
<? echo " ".strftime("%d")." ".strftime("%B")." ".(strftime("%Y")+$par_Data)."<BR>";?>
<? echo $meteo." ". $gradi."°C  ".Tempo();?>
<!--? include("meteo.inc.html"); ?-->

<!--? echo $stanza?--></td>
</tr>


<tr>
<td valign=top>
<!-- INIZIO MENU -->

<!--a href="albergo2.php" target=palestra alt="Stanze">     <img src="img/menumini.gif" border=0> STANZE PRIVATE</a><br-->



<hr width=100>
<p><a href="" onClick="window.open('araldo.php','ext2','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=500, height=645');return(false)" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('cdb','','cdb1.jpg',1)"><img src="img/cdb.jpg" name="cdb" border="0" id="cdb" /></a></p>
<p><a href="" onClick="window.open('scheda.php?pg=<?= urlencode($Login) ?>','ext1','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=800, height=600');return(false)" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('scheda','','persdt1.jpg',1)"><img src="img/persdt.jpg" name="scheda" border="0" id="scheda" /><!--?= strtoupper(htmlspecialchars($Login))?--></a></p>
<p><br>

<a href="" onClick="window.open('messaggi.php','ext2','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=500, height=645');return(false)">
<? if ($NonLetti == 0 ) { ?>

<img src="img/padd.jpg" border="0">

<? } else ($NonLetti >= 1 ) { ?>

<!--embed src="<?= $Beep ?>" width=0 height=0 autostart=true loop=false hidden=true-->
<?= " ".$NonLetti ?>

<img src="img/padd1.jpg" border="0"> </a></p>

<p><!--?=$LinkMappa?--><a href="main.php?Dir=1" target=_top onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('mapp','','map1.jpg',1)"><img src="img/map.jpg" name="mapp" border="0" id="mapp" /></a><!--?echo "ID= ".$ID;?--></p>
<p><a href="" onClick="window.open('guarda.php?ID=<?=$Stanza?>','ext2','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=500, height=645');return(false)" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('luogo','','osslg1.jpg',1)"><img src="img/osslg.jpg" name="luogo" border="0" id="luogo" /></a></p>
<p><a href="main.php?Dir=<?= $ID ?>" target=_top alt="Aggiorna"" " onmouseout="MM_swapImgRestore()" onMouseOver="MM_swapImage('aggiorna','','agg1.jpg',1)"><img src="img/agg.jpg" name="aggiorna" border="0" id="aggiorna" /></a></p>
<p><a href="logout.php" target=_top alt="Esci dal gioco" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('esci','','out1.jpg',1)"><img src="img/out.jpg" name="esci" border="0" id="esci" /></a></p>

<!-- FINE MENU -->

</td></tr></table>


<?
$MySql = "SELECT * FROM Presenti WHERE Nome = '".addslashes($_SESSION['Login'])."'";

$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$IDGilda_Presenti = 0 + $rs['IDGilda'];
$rs->close;
mysql_free_result($Result);

$MySql = "SELECT * FROM Personaggio WHERE Nome = '".addslashes($_SESSION['Login'])."'";

$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$Updated = 0;

if (mysql_num_rows($Result) > 0) {

$IDRazza = 0 + $rs['IDRazza'];
$IDGilda = 0 + $rs['IDGilda'];
$Master = 0 + $rs['Master'];
$Sesso = strtolower($rs["Sesso"]."");
$_SESSION['Sesso_S'] = $Sesso;
$_SESSION['Super_S'] = $rs['Super'];

$Pres = 'S';
$rs->close;

if (($IDGilda != $_SESSION['IDGilda_S']) || ($IDRazza != $_SESSION['IDRazza_S']) || ($IDGilda_Presenti == 0)){

$Updated = 1;

$MySql = "SELECT * FROM Razza WHERE IDRazza = '$IDRazza'";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$ImgRazza = $rs['URLImg'];
$DescRazza = $rs['Razza'];
$rs->close;

$MySql = "SELECT * FROM Gilda WHERE IDGilda = '$IDGilda'";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$ImgGilda = $rs['URLImg'];
$DescGilda = $rs['Gilda'];
$_SESSION['Esilio_S'] = $rs['Esilio'];
$_SESSION['Prigione_S'] = $rs['Prigione'];
$_SESSION['LogFinanza_S'] = $rs['LogFinanza'];
$_SESSION['LogDoppi_S'] = $rs['LogDoppi'];
$_SESSION['Gst_AR_S'] = $rs['Gst_AR'];
$_SESSION['Gst_Razza_S'] = $rs['Gst_Razza'];
$rs->close;
mysql_free_result($Result);

$_SESSION['IDGilda_S'] = $IDGilda;
$_SESSION['ImgGilda_S'] = $ImgGilda;
$_SESSION['DescGilda_S'] = $DescGilda;
$_SESSION['IDRazza_S'] = $IDRazza;
$_SESSION['ImgRazza_S'] = $ImgRazza;
$_SESSION['DescRazza_S'] = $DescRazza;

$MySql = 'UPDATE Presenti';
$MySql.= ' SET Sesso = ''.addslashes($Sesso).''';
$MySql.= ', SET IDGilda = '.$IDGilda;
$MySql.= ', SET ImgGilda = ''.addslashes($ImgGilda).''';
$MySql.= ', SET DescGilda = ''.addslashes($DescGilda).''';
$MySql.= ', SET IDRazza = '.$IDRazza;
$MySql.= ', SET ImgRazza = ''.addslashes($ImgRazza).''';
$MySql.= ', SET DescRazza = ''.addslashes($DescRazza).''';
$MySql.= ' WHERE Nome = ''.addslashes($_SESSION['Login']).''';

mysql_query($MySql);

}

//if ($rs['Esilio']!= '2000-01-01 00:00:00'){$_SESSION['Gattabuia']=0;}
//else{$_SESSION['Gattabuia']=0;}
} else {
$rs->close;
mysql_free_result($Result);
exit();
}?>



<div style="width:180; height:220; overflow: auto;" align=center>

<table border=0 width=150 cellpadding=0 cellspacing=0 >
<tr><td>
<hr size="1">
<font color=" #000000"><b> Sono entrati:</b><br></font>
<?
#------ sezione da attivare se i pg spariscono ------

$st = 0 + $Stanza;
$stApparente = $st;
$MySql = "SELECT StanzaApparente FROM Mappa WHERE ID = $st";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
If ($rs) {
$stApparente = $rs["StanzaApparente"];
}
$rs->close;
mysql_free_result($Result);

$MySql = "SELECT Nome FROM Mappa_Click WHERE IDClick = '".$_SESSION['Mappa']."'";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$NomeMappaClick=$rs['Nome'];
$rs->close;
mysql_free_result($Result);


if(($_SESSION['Admin_S']==1) || ($_SESSION['Super_S']==1) || ($_SESSION['Master']==1)){$PresentiMaster=1;}

$MySql = "SELECT * FROM Presenti WHERE Nome = '".pars($Login)."'";
$Result = mysql_query($MySql);
if (mysql_num_rows($Result)==0) {
mysql_free_result($Result);

$MySql = "INSERT INTO Presenti (Nome, Stanza, StanzaApparente, Mappa, Sesso, IDRazza, ImgRazza, IDGilda, ImgGilda, Sesso, OraEntrata, OraUscita, UltimoRefresh, Master)";
$MySql .= " VALUES ('".pars($Login)."', $st, $stApparente, '".addslashes($NomeMappaClick)."', '".$_SESSION['IDRazza_S']."', '".$_SESSION['ImgRazza_S']."', '".$_SESSION['IDGilda_S']."', '".$_SESSION['ImgGilda_S']."', '".$_SESSION['Sesso_S']."', NOW(), '2037-12-31 00:00:00', NOW(),".$PresentiMaster." )";
$Result = mysql_query($MySql);
mysql_free_result($Result);
} else {
mysql_free_result($Result);

if ($Updated == 1) {
$MySql = "UPDATE Presenti SET Stanza = $st, StanzaApparente = $stApparente, Mappa = '".addslashes($NomeMappaClick)."', UltimoRefresh = NOW(), OraUscita = '2037-12-31 00:00:00', Sesso='".$_SESSION['Sesso_S']."', IDRazza='".$_SESSION['IDRazza_S']."', ImgRazza = '".$_SESSION['ImgRazza_S']."', IDGilda='".$_SESSION['IDGilda_S']."', ImgGilda='".$_SESSION['ImgGilda_S']."' WHERE Nome = '".pars($Login)."'";
$Result = mysql_query($MySql);
} else {
$MySql = "UPDATE Presenti SET Stanza = $st, StanzaApparente = $stApparente, Mappa = '".addslashes($NomeMappaClick)."', UltimoRefresh = NOW(), OraUscita = '2037-12-31 00:00:00' WHERE Nome = '".pars($Login)."'";
$Result = mysql_query($MySql);
}
};

$MySql="Select * From Presenti WHERE DATE_ADD(OraEntrata, INTERVAL 4 MINUTE) > NOW() ORDER BY Nome";
$Result = mysql_query($MySql);
while($rs = mysql_fetch_array($Result))
{

echo "<a href=""onClick="window.open('scheda.php?pg=".urlencode(trim($rs["Nome"]))."','ext1','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=800, height=600');return(false)"> <IMG SRC='img/testamini".strtolower($rs["Sesso"]).".gif' width=8 height=8 border=0> ".htmlspecialchars(trim($rs["Nome"]))."</a><br>";
}
$rs->close;
mysql_free_result($Result);
?>

</td>
</tr>
<tr>
<td>

<font color=" #000000"><br><b> Sono usciti:</b><br></font >

<?
$MySql="Select * From Presenti WHERE (OraUscita < NOW()) AND (DATE_ADD(OraUscita, INTERVAL 3 MINUTE) > NOW()) ORDER BY Nome";
$Result = mysql_query($MySql);
while($rs = mysql_fetch_array($Result))
{

echo "<a href=""onClick="window.open('scheda.php?pg=".urlencode(trim($rs["Nome"]))."','ext1','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=800, height=600');return(false)"> <IMG SRC='img/testamini".strtolower($rs["Sesso"]).".gif' width=8 height=8 border=0> ".htmlspecialchars(trim($rs["Nome"]))."</a><br>";
}
$rs->close;
mysql_free_result($Result);
if ($Stanza > 0)
{
?>
<hr size="1">
</td>
</tr>
<tr>
<td>

<font color=" #000000"><b> <?echo $Breve;?>: </b><br></font>
<?
$MySql="Select * From Presenti where OraUscita = '2037-12-31 00:00:00' and StanzaApparente = $Stanza AND Is_Invisibile = 0 ORDER BY Nome";
$Result = mysql_query($MySql);
while($rs = mysql_fetch_array($Result))
{

echo "<a href=""onClick="window.open('scheda.php?pg=".urlencode(trim($rs["Nome"]))."','ext1','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=800, height=600');return(false)"> <IMG SRC='img/testamini".strtolower($rs["Sesso"]).".gif' width=8 height=8 border=0> ".htmlspecialchars(trim($rs["Nome"]))."</a><br>";
}
$rs->close;
mysql_free_result($Result);
}

$cont=0;
$MySql="SELECT count(Nome) AS Numero FROM Presenti WHERE OraUscita = '2037-12-31 00:00:00'";
$Result = mysql_query($MySql);
$rs = mysql_fetch_array($Result);
$cont=$rs["Numero"];
$rs->close;
mysql_free_result($Result);
?>
<hr size="1"></td>
</tr>
<tr>
<td><p><a href="" onClick="window.open('lista2.php','ext2','toolbar=0, location=0, directories=0, statusbar=0, status=0, scrollbars=1, resizable=0, copyhistory=0, menuBar=0, width=500, height=645');return(false)" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('presenti','','loc1.jpg',1)"><img src="img/loc.jpg" name="presenti" border="0" id="presenti" /><b><?= $cont; ?></b></a></p>

</td>
</tr>

<tr></tr></table>

</div>
</td></tr></table>



</body>
</html>
<!-- <?= $Stanza ?> -->