<html>
<html>
<head>
<!-- Konfiguration für den OnmouseOver -->
<script language=javascript type=text/javascript>
<!--
var dom = (document.getElementById) ? true : false;
var ns5 = ((navigator.userAgent.indexOf(Gecko)>-1) && dom) ? true: false;
var ie5 = ((navigator.userAgent.indexOf(MSIE)>-1) && dom) ? true : false;
var ns4 = (document.layers && !dom) ? true : false;
var ie4 = (document.all && !dom) ? true : false;
var nodyn = (!ns5 && !ns4 && !ie4 && !ie5) ? true : false;
var origWidth, origHeight;
if (ns4) {
origWidth = window.innerWidth; origHeight = window.innerHeight;
window.onresize = function() { if (window.innerWidth != origWidth || window.innerHeight != origHeight) history.go(0); }
}
if (nodyn) { event = nope }
/////////////////////// CUSTOMIZE HERE ////////////////////
// settings for tooltip
// Do you want tip to move when mouse moves over link?
var tipFollowMouse= true;
// Be sure to set tipWidth wide enough for widest image
var tipWidth= 160;
var offX= 20; // how far from mouse to show tip
var offY= 12;
var tipFontFamily= Verdana, arial, helvetica, sans-serif;
var tipFontSize= 8pt;
// set default text color and background color for tooltip here
// individual tooltips can have their own (set in messages arrays)
// but don't have to
var tipFontColor= #000000;
var tipBgColor= #DDECFF;
var tipBorderColor= #000080;
var tipBorderWidth= 3;
var tipBorderStyle= ridge;
var tipPadding= 4;
// tooltip content goes here (image, description, optional bgColor, optional textcolor)
var messages = new Array();
// multi-dimensional arrays containing:
// image and text for tooltip
// optional: bgColor and color to be sent to tooltip
messages[0] = new Array('images/fragezeichen.gif','EV1.1, Haus 1 Verwaltung',#FFFFFF);
messages[1] = new Array('','Reihe im Verteilerschrank,<br> 0/1=Ebene 0/1; UG1<br>',#DDECFF);
messages[2] = new Array('','Spalte im Verteilerschrank<br>A = 1. Dose in der Reihe<br>H = Letzte Dose','#DDECFF');
messages[3] = new Array('','Büronummer des Benutzers','#DDECFF');
messages[4] = new Array('','Netz:<br>BKR<br>UNI<br>SAP','#DDECFF');
//////////////////// END OF CUSTOMIZATION AREA ///////////////////
// preload images that are to appear in tooltip
// from arrays above
if (document.images) {
var theImgs = new Array();
for (var i=0; i<messages.length; i++) {
theImgs = new Image();
theImgs.src = messages[0];
}
}
// to layout image and text, 2-row table, image centered in top cell
// these go in var tip in doTooltip function
// startStr goes before image, midStr goes between image and text
var startStr = '<table width=' + tipWidth + '><tr><td align=center width=100%><img src=';
var midStr = ' border=0></td></tr><tr><td valign=top>';
var endStr = '</td></tr></table>';
////////////////////////////////////////////////////////////
// initTip - initialization for tooltip.
// Global variables for tooltip.
// Set styles for all but ns4.
// Set up mousemove capture if tipFollowMouse set true.
////////////////////////////////////////////////////////////
var tooltip, tipcss;
function initTip() {
if (nodyn) return;
tooltip = (ns4)? document.tipDiv.document: (ie4)? document.all['tipDiv']: (ie5||ns5)? document.getElementById('tipDiv'): null;
tipcss = (ns4)? document.tipDiv: tooltip.style;
if (ie4||ie5||ns5) { // ns4 would lose all this on rewrites
tipcss.width = tipWidth+px;
tipcss.fontFamily = tipFontFamily;
tipcss.fontSize = tipFontSize;
tipcss.color = tipFontColor;
tipcss.backgroundColor = tipBgColor;
tipcss.borderColor = tipBorderColor;
tipcss.borderWidth = tipBorderWidth+px;
tipcss.padding = tipPadding+px;
tipcss.borderStyle = tipBorderStyle;
}
if (tooltip&&tipFollowMouse) {
if (ns4) document.captureEvents(Event.MOUSEMOVE);
<html>
<head>
<!-- Konfiguration für den OnmouseOver -->
<script language=javascript type=text/javascript>
<!--
var dom = (document.getElementById) ? true : false;
var ns5 = ((navigator.userAgent.indexOf(Gecko)>-1) && dom) ? true: false;
var ie5 = ((navigator.userAgent.indexOf(MSIE)>-1) && dom) ? true : false;
var ns4 = (document.layers && !dom) ? true : false;
var ie4 = (document.all && !dom) ? true : false;
var nodyn = (!ns5 && !ns4 && !ie4 && !ie5) ? true : false;
var origWidth, origHeight;
if (ns4) {
origWidth = window.innerWidth; origHeight = window.innerHeight;
window.onresize = function() { if (window.innerWidth != origWidth || window.innerHeight != origHeight) history.go(0); }
<input type=text name=zimmer value=<? echo $data[zimmer] ?> size=50>
</td></tr><tr><td>Benutzername</td><td>
<input type=text name=benutzername value=<? echo $data[benutzername] ?> size=40>
</td></tr><tr><td>Bemerkung</td><td>
<input type=text name=bemerkung value=<? echo $data[bemerkung] ?> size=5>
</td></tr><tr><td>NZ</td><td>
<input type=text name=nz value=<? echo $data[nz] ?> size=5>
</td></tr><tr><td>Datum</td><td>
<input type=text name=datum value=<? echo $data[datum] ?> size=40>
</td></tr><tr><td>&nbsp;</td><td>
<input type=submit name=submit value=Ändern>
</td></tr></table>
</form>
<?
}
}
//Daten anzeigen
$start = 0;
$result = mysql_query(SELECT * FROM haus1 ORDER BY reihe limit $start,10,$db);
?>
<a href=index.php>zurück zur Übersicht</a><br><br>
<table border=1 cellspacing=0 cellpadding=3 align=center width=90%>
<tr>
<td><b>ID</b></td>
<td valign=top align=top><b>acodose</b><a href=# onmouseover=doTooltip(event,0) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Reihe</b> <a href=# onmouseover=doTooltip(event,1) onmouseout=hideTip()><img src=images/kommentar.gif align=right valign=top border=0></td>
<td><b>Spalte</b><a href=# onmouseover=doTooltip(event,2) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Zimmer</b><a href=# onmouseover=doTooltip(event,3) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Netz</b><a href=# onmouseover=doTooltip(event,4) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Benutzername</b>
</td>
<td><b>Bemerkung</b>
</td>
<td><b>NZ</b>
mouseY = (ns4||ns5)? evt.pageY: window.event.clientY + document.body.scrollTop;
}
// tooltip width and height
var tpWd = (ns4)? tooltip.width: (ie4||ie5)? tooltip.clientWidth: tooltip.offsetWidth;
var tpHt = (ns4)? tooltip.height: (ie4||ie5)? tooltip.clientHeight: tooltip.offsetHeight;
// document area in view (subtract scrollbar width for ns)
var winWd = (ns4||ns5)? window.innerWidth-20+window.pageXOffset: document.body.clientWidth+document.body.scrollLeft;
var winHt = (ns4||ns5)? window.innerHeight-20+window.pageYOffset: document.body.clientHeight+document.body.scrollTop;
// check mouse position against tip and window dimensions
// and position the tooltip
if ((mouseX+offX+tpWd)>winWd)
tipcss.left = (ns4)? mouseX-(tpWd+offX): mouseX-(tpWd+offX)+px;
else tipcss.left = (ns4)? mouseX+offX: mouseX+offX+px;
if ((mouseY+offY+tpHt)>winHt)
tipcss.top = (ns4)? winHt-(tpHt+offY): winHt-(tpHt+offY)+px;
else tipcss.top = (ns4)? mouseY+offY: mouseY+offY+px;
if (!tipFollowMouse) t1=setTimeout(tipcss.visibility='visible',100);
}
function hideTip() {
if (!tooltip) return;
t2=setTimeout(tipcss.visibility='hidden',100);
tipOn = false;
}
//-->
</script>
<!-- Ender Conf -->
<title>Patchliste</title>
<link rel=stylesheet type=text/css href=default.css>
</head>
<body>
<div id=tipDiv style=position:absolute; visibility:hidden; z-index:100></div>
<div align=center>
<h1>Patchfeldbelegung Haus 1</h1>
<?
//Verbindung herstellen
$db = mysql_connect(localhost,root);
mysql_select_db(patchlistebkp,$db);
// Variablen Festlegen
$entriesperpage = 5;
//Daten löschen
if($clear) mysql_query(DELETE FROM haus1 WHERE id=$clear,$db);
// Daten ändern
if ($edit) {
if ($submit) {
$sql = UPDATE haus1 SET acodose='$acodose', reihe='$reihe', netz='$netz', spalte='$spalte', zimmer='$zimmer', benutzername='$benutzername', bemerkung='$bemerkung', nz='$nz', datum='$datum' WHERE id=$edit;
$result = mysql_query($sql,$db);
echo Daten f&uuml;r die ID .$edit. wurden ge&auml;ndert;
}
else {
$sql = SELECT * FROM haus1 WHERE id=$edit;
$result = mysql_query($sql,$db);
$data = mysql_fetch_array($result);
?>
<form method=post action=<? echo $PHP_SELF ?>>
<input type=hidden name=edit value=<? echo $data[id] ?>>
<table border=0 align=center width=80%>
<tr><td>ACO- Dose</td><td>
<input type=text name=acodose value=<? echo $data[acodose] ?> size=50>
</td></tr><tr><td>Reihe:</td><td>
<input type=text name=reihe value=<? echo $data[reihe] ?> size=50>
</td></tr><tr><td>Spalte</td><td>
<input type=text name=spalte value=<? echo $data[spalte] ?> size=50>
</td></tr><tr><td>Netz</td><td>
<input type=text name=netz value=<? echo $data[netz] ?> size=50>
</td></tr><tr><td>Zimmer</td><td>
<input type=text name=zimmer value=<? echo $data[zimmer] ?> size=50>
</td></tr><tr><td>Benutzername</td><td>
<input type=text name=benutzername value=<? echo $data[benutzername] ?> size=40>
</td></tr><tr><td>Bemerkung</td><td>
<input type=text name=bemerkung value=<? echo $data[bemerkung] ?> size=5>
</td></tr><tr><td>NZ</td><td>
<input type=text name=nz value=<? echo $data[nz] ?> size=5>
</td></tr><tr><td>Datum</td><td>
<input type=text name=datum value=<? echo $data[datum] ?> size=40>
</td></tr><tr><td>&nbsp;</td><td>
<input type=submit name=submit value=Ändern>
</td></tr></table>
</form>
<?
}
}
//Daten anzeigen
$start = 0;
$result = mysql_query(SELECT * FROM haus1 ORDER BY reihe limit $start,10,$db);
?>
<a href=index.php>zurück zur Übersicht</a><br><br>
<table border=1 cellspacing=0 cellpadding=3 align=center width=90%>
<tr>
<td><b>ID</b></td>
<td valign=top align=top><b>acodose</b><a href=# onmouseover=doTooltip(event,0) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Reihe</b> <a href=# onmouseover=doTooltip(event,1) onmouseout=hideTip()><img src=images/kommentar.gif align=right valign=top border=0></td>
<td><b>Spalte</b><a href=# onmouseover=doTooltip(event,2) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Zimmer</b><a href=# onmouseover=doTooltip(event,3) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Netz</b><a href=# onmouseover=doTooltip(event,4) onmouseout=hideTip()>
<img src=images/kommentar.gif align=right valign=top border=0></a></td>
<td><b>Benutzername</b>
</td>
<td><b>Bemerkung</b>
</td>
<td><b>NZ</b>
</td>
<td><b>Datum</b>
</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<? while ($daten = mysql_fetch_array($result)) { ?>
<tr>
<td><? echo $daten[id]; ?></td>
<td><? echo $daten[acodose]; ?></td>
<td><? echo $daten[reihe]; ?></td>
<td><? echo $daten[spalte]; ?></td>
<td><? echo $daten[zimmer]; ?></td>
<td><? echo $daten[netz]; ?></td>
<td><? echo $daten[benutzername]; ?></td>
<td><? echo $daten[bemerkung]; ?></td>
<td><? echo $daten[nz]; ?></td>
<td><? echo $daten[datum]; ?></td>
<td><a href=<? echo ''.$PHP_SELF.'?clear='.$daten[id].'' ?>>Löschen</a></td>
<td><a href=<? echo ''.$PHP_SELF.'?edit='.$daten[id].'' ?>>Bearbeiten</a></td>
</tr>
<? }
$start=$start+6;
echo <a href='admin.php?start=$start'>Die Nächsten</a>;
?>
</table>
<br>
<a href=index.php>Zurück zur Übersicht</a>
</div>
</body>
</html>
Vielen dank!!
der erste bereich im header ist nur für einen bereich.. wenn ich mit der maustaste drüber gehe dass ein kleines fenster aufkommt...