WebSVN - is - Rev 2 - /trunk/html/map.php

is	Subversion Repositories:
[/] [trunk/] [html/] [map.php] - Rev 2
Compare with Previous - Blame - Download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css" media="screen"> @import "style.css"; </style>
<title>main frame - content holder</title>
</head>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body leftmargin=10 topmargin=0>

<?
include("header.htm");
?>
<center>
<table width=100%>
<tr>
<td align=center>


<table border=0 bgcolor=#000000 cellpadding=0 cellspacing=1>
<tr>
<?
$vchod=420;
while ($vchod>408)
{
echo '<td align=center class=text bgcolor=#FFFFFF>'.$vchod.'</td>';
$vchod--;
}
echo '<td align=center class=text bgcolor=#FFFFFF>713</td>
<td align=center class=text bgcolor=#FFFFFF>714</td>';

echo '</tr><tr><td>';


require('grab_globals.lib.php');
include ("fce.php");
$spojeni = MySQL_Connect($db_host, $db_user, $db_pass);
MySQL_Select_DB($db_name);
$patro=10;
$byt=0;

echo '<table bgcolor=#FFFFFF cellpadding=1 cellspacing=1><tr>
';
$dotaz=MySQL_Query("SELECT * FROM flats");


for ($i=1; $i<=462; $i++)
{
$byt++;

$cbytu++;
$string=MySQL_Fetch_Array($dotaz);
$cbytu=(3*$patro+$byt-1);
if ($cbytu==0 || $cbytu==1)
{
if ($cbytu==0)
{
$cbytu=1;
}
else
{
$cbytu=0;
}
}


if ($string["status"]==0) echo '<td><a target="_self" href="add_resident.php?flat='.$i.'"><img border=0 alt="č. bytu '.$cbytu.', '.$patro.'. patro, id '.$i.' " src="images/none.gif"></a></td>';

if ($string["status"]==1)
{
echo '<td><a target="_self" href="detail_user.php?flat='.$i.'"><img border=0 alt="'.$string["resident"].' - č. bytu '.$cbytu.', '.$patro.'. patro, id '.$i.'  " src="images/construction.bmp"></a></td>';
$vystavba++;
}
if ($string["status"]==2  && $string["inet"]==0)
{
echo '<td><a target="_self" href="detail_user.php?flat='.$i.'"><img border=0 alt="'.$string["resident"].' - č. bytu '.$cbytu.', '.$patro.'. patro, id '.$i.'  " src="images/active.bmp"></a></td>';
$pripojeno++;
}
if ($string["status"]==2  && $string["inet"]==1)
{
echo '<td><a target="_self" href="detail_user.php?flat='.$i.'"><img border=0 alt="'.$string["resident"].' - č. bytu '.$cbytu.', '.$patro.'. patro, id '.$i.'  " src="images/inet.bmp"></a></td>';
$pripojeno++;
}
Next($string);

if ($byt==3)
{
 $patro--;
 $byt=0;
 echo '</tr>';

if($i<462)
{
if ($patro<0)
{
$patro=10;

echo '</table></td><td bgcolor=#000000 ><table bgcolor=#FFFFFF cellpadding=1 cellspacing=1>';
}
else
{
 echo '<tr>';
}
}}

}

echo '</table>
</td></tr>
</table>



</td>
<td class=text>
<a target="_self" href="detail_user.php?flat=1000"><img border=0 alt="AP Yenik" src="images/ap.bmp"></a> - AP Yenik
<br><a target="_self" href="detail_user.php?flat=1001"><img border=0 alt="AP Jablonecká" src="images/ap.bmp"></a> - AP Jablonecká
</td>
</tr>
<tr>
<td colspan=2 align=left class=text>
<b>Statistika LAN Jablonka:</b> '.$pripojeno.' bytů připojeno, '.$vystavba.' plánovaných přípojek &nbsp;&nbsp;
<b>Legenda:</b>
<img src="images/none.gif"> - bez přípojky&nbsp;
<img src="images/construction.bmp"> - v plánu&nbsp;
<img src="images/active.bmp"> - aktivní&nbsp;
<img src="images/inet.bmp"> - aktivní a internet
</td>
</tr>
</table>

</center>
<br>
';

?>
</body>
</html>