<?
include_once ("../inc/db.php");
$db = new db($fehler);
$V=(integer)($_POST['V']);
$H=(integer)($_POST['H']);
$count = 0;
$coV = 0;
//echo $count;
$Kord=($_POST['Kordinaten']);
$neu=($_POST['neu']); // weg n j
$Art=($_POST['Art']); // hinderniss oder weg
$Bild=($_POST['Bild']);// Grafik id
echo "Bild ".$Bild;
echo " Art ".$Art;
echo " ".$Kord.$neu;
$Kor = explode("-", $Kord);
echo "v".$Kor[0];
echo "h".$Kor[1]."<br>";
if ($neu !="" and $Kor[0] !="" and $Kor[1] !=""){
//update
$Sqlup=sprintf("Update map1 set F_artid='%d',Weg='%s' where H='%d' and V='%d'ORDER BY `H`,`V`;",($Bild),($Art),($Kor[1] ),($Kor[0]));
echo $Sqlup;
$db->query($Sqlup);
}
if ($neu =="" and $Kor[0] !="" and $Kor[1] !=""){
//insert
$Sqlstr=sprintf("INSERT INTO `map1` (`H`, `V`, `F_artid`, `Weg`) VALUES (%d, %d, %d, '%s');",($Kor[1] ),($Kor[0]),($Bild),($Art));
echo $Sqlstr;
$db->query($Sqlstr);
}
$Sql_bild="Select Mapgrafik_id,Grafik_art from map_grafik "; // Grafik art laden
unset($Mh);unset($Mv);unset($Mweg);unset($Mf_artid); //Dim Var löschen
$Sql_allmap="Select V,H,F_artid,Weg from map1 order by V,H";
$db->query($Sql_allmap);
while ($db->next_record()) {
$Mv[]=$db->r("V");
$Mh[]=$db->r("H");
$Mweg[]=$db->r("Weg");
$Mf_artid[]=$db->r("F_artid");
$daten++;
}
echo "Test".$daten;
?>
<html>
<body>
<style type="text/css">
<!--
a:link {text-decoration:none; }
a:visited {text-decoration:none; }
a:hover {text-decoration:none;}
a:active{text-decoration:none;}
-->
</style>
<table cellspacing="5" cellpadding="0" border =0>
<tr>
<td>
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" >
<table cellspacing="0" cellpadding="0">
<tr>
<td>V
<INPUT type="text" size=2 name="V" value=""/>
/
<INPUT type="text" size=2 name="H" value=""/>H
</td>
<td>
<input style="border:none;background:none" type=submit name="Button" value="Erstellen" />
</td>
</tr>
</table>
</form>
</td>
<td>
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" >
<table cellspacing="0" cellpadding="0">
<tr>
<td>
<select name="Bild" size="1">
<? $db->query($Sql_bild);
while ($db->next_record()) { ?>
<option value="<?=$db->r("Mapgrafik_id");?>"><?=$db->r("Grafik_art");?></option>
<? } ?>
</select>
</td>
<td>
<? if($Art=='j'){$c1="checked";}
if($Art=='n'){$c2="checked";} ?>
<input name="Art" type="radio" value="n" <?=$c2;?> >Hindernis
<input name="Art" type="radio" value="j" <?=$c1;?> >Weg
</td>
<td>
<INPUT class="input" type="hidden" name="V" value="<?=$V;?>" >
<INPUT class="input" type="hidden" name="H" value="<?=$H;?>" >
<input style="border:none;background:none" type=submit name="Button" value="Wählen" />
</td>
</tr>
</table>
</form>
</td>
<td>
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" >
<table cellspacing="0" cellpadding="0">
<tr>
<td>
<select name="Map" size="1">
<option>Map1</option>
<option>Map2</option>
</select>
</td>
<td>
<INPUT class="input" type="hidden" name="V" value="<?=$V;?>" >
<INPUT class="input" type="hidden" name="H" value="<?=$H;?>" >
<input style="border:none;background:none" type=submit name="Button" value="Laden" />
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" align="center" border=1>
<? while($coV < $V){
$coV++; ?>
<tr>
<? while($count < $H){
$count++; ?>
<form id="Feld<?=$coV."-".$count;?>" action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" >
<?
$i=0;
$Gefunden='';//zurücksetzen
while ($Mv[$i] <= $coV){
//echo"I".$i." Cov".$coV." Mv".$Mv[$i]." "." Mh".$Mh[$i]." H".$count." ";
if ($i > $daten) break;
if ($Mv[$i]==$coV and $Mh[$i]==$count){
$Gefunden='True';
break;
}
$i++; }
if($Gefunden=='True' and $Mweg[$i]=='n'){$Farbe='gray'; }
elseif($Gefunden=='True' and $Mweg[$i]=='j'){$Farbe='yellow'; }
else{$Farbe="";}
if($Gefunden=='True') {$ausgabe=$Mf_artid[$i];
//array verkleinern
unset($Mv[$i]);unset($Mh[$i]);unset($Mf_artid[$i]);
//echo "G".$Mv[$i];
}
else{$ausgabe="";}
?>
<td width="15" height="15" bgcolor="<?=$Farbe;?>" style=" font-size:9">
<INPUT class="input" type="hidden" name="Bild" value="<?=$Bild;?>" >
<INPUT class="input" type="hidden" name="Art" value="<?=$Art;?>" >
<INPUT class="input" type="hidden" name="V" value="<?=$V;?>" >
<INPUT class="input" type="hidden" name="H" value="<?=$H;?>" >
<INPUT class="input" type="hidden" name="neu" value="<?=$Mweg[$i];?>" >
<INPUT class="input" type="hidden" name="Kordinaten" value="<?=$coV.'-'.$count;?>" >
<a href="javascript:document.getElementById('Feld<?=$coV.'-'.$count;;?>').submit();"> <?=$ausgabe.str_repeat(' ',5);?></a>
</td>
</form>
<? };$count=0; ?>
</tr>
<? } ?>
<table>
