nicht angemeldet
<html>
<head>
<title>Datenbank</title>
</head>
<style type="text/css">
body
{
background-color: #dddddd;
margin-top: 0px;
}
tr#Zeile
{
cursor: pointer;
height: 28px;
}
td#Rahmenlinks
{
border-left: 1px solid Black;
}
</style>
<script type="text/javascript">
function anrufen(Nummer)
{
CallFenster = window.open("call.html", "CallFenster", "width=400,height=160");
CallFenster.focus();
CallFenster.document.writeln('<html>');
CallFenster.document.writeln('<head><title></title></head>');
CallFenster.document.writeln('<body bgcolor=green>');
CallFenster.document.writeln('<table width="100%" height=80 border=1><tr><td align="center">');
CallFenster.document.writeln('<form method="POST" action="http://fritz.box/cgi-bin/webcm" target="_self" id="uiPostForm" name="uiPostForm">');
CallFenster.document.writeln('<input type="hidden" name="login:command/password" value="******" id="uiPostPassword">');
CallFenster.document.writeln('<input type="hidden" name="telcfg:settings/UseClickToDial" value="1" id="uiPostClickToDial">');
CallFenster.document.writeln('<input type="hidden" name="telcfg:command/Dial" value="'+Nummer+'" id="uiPostDial">');
CallFenster.document.writeln('<input type="hidden" name="telcfg:settings/DialPort" value="**1" id="uiPostDialPort">');
CallFenster.document.writeln('<input type="hidden" name="getpage" value="../html/de/menus/menu2.html" id="uiPostGetPage">');
CallFenster.document.writeln('<input type="submit" value="Call">');
CallFenster.document.writeln('</form>');
CallFenster.document.writeln('</td></tr></table></body></html>');
}
</script>
<body>
<?
require "../config.inc.php";
$connect = mysql_connect($dbhost, $dbuser, $dbpwd) or die ("Die Verbindung zum Datenbankserver ist fehlgeschlagen");
mysql_select_db($db, $connect) or die ("Die Datenbank wurde nicht gefunden");
//Adressen auflisten
if (!empty($bustab)){$sql = "select * from adressen where Name like '$bustab%' order by Name;";}
else{$sql = "select * from adressen order by Name;";}
$query = mysql_query($sql);
?>
<table cellspacing=0 cellpadding=0>
<?
while ($daten = mysql_fetch_array($query))
{
if (!empty($daten[12])){$mail = '<a href="mailto:'.$daten[12].'"><img src="../grafik/mail.gif" border=0 alt="'.$daten[12].'"></a>';}else{$mail=' ';}
if (!empty($daten[7]))
{
$waehlen = str_replace(" ","", $daten[7]);
$nummer = str_replace(" ","/", $daten[7]);
$link = "javascript:anrufen('".$waehlen."')";
$fon = '<a href="'.$link.'"><img src="../grafik/telefon.gif" border=0 alt="'.$nummer.'"></a>';
}
else{$fon=' ';}
if (!empty($daten[9]))
{
$waehlen = str_replace(" ","", $daten[9]);
$nummer = str_replace(" ","/", $daten[9]);
$link = "javascript:anrufen('".$waehlen."')";
$handy = '<a href="'.$link.'"><img src="../grafik/handy.gif" border=0 alt="'.$nummer.'"></a>';
}
else{$handy=' ';}
if (!empty($daten[10]))
{
$waehlen = str_replace(" ","", $daten[10]);
$nummer = str_replace(" ","/", $daten[10]);
$link = "javascript:anrufen('".$waehlen."')";
$voip = '<a href="'.$link.'"><img src="../grafik/voip.gif" border=0 alt="'.$nummer.'"></a>';
}
else{$voip=' ';}
if (!empty($daten[17])){$armail = '<a href="mailto:'.$daten[17].'"><img src="../grafik/mail.gif" border=0 alt="'.$daten[17].'"></a>';}else{$armail=' ';}
if (!empty($daten[14]))
{
$waehlen = str_replace(" ","", $daten[14]);
$nummer = str_replace(" ","/", $daten[14]);
$link = "javascript:anrufen('".$waehlen."')";
$arfon = '<a href="'.$link.'"><img src="../grafik/telefon.gif" border=0 alt="'.$nummer.'"></a>';
}
else{$arfon=' ';}
if (!empty($daten[16]))
{
$waehlen = str_replace(" ","", $daten[16]);
$nummer = str_replace(" ","/", $daten[16]);
$link = "javascript:anrufen('".$waehlen."')";
$arhandy = '<a href="'.$link.'"><img src="../grafik/handy.gif" border=0 alt="'.$nummer.'"></a>';
}
else{$arhandy=' ';}
$arhandy = $daten[16];
$name = $daten[2]." ".$daten[3];
if (!empty($daten[1])){$name = $name." - ".$daten[1];}
?>
<tr id="Zeile" onMouseOver="bgColor='#bbbbbb'" onMouseOut="bgColor=''">
<td width="10" id="Rahmenlinks"> </td>
<td width="24"><?=$mail?></td>
<td width="28"><?=$fon?></td>
<td width="24"><?=$handy?></td>
<td width="24"><?=$voip?></td>
<td width="10"> </td>
<td width="10" id="Rahmenlinks"> </td>
<td width="24"><?=$armail?></td>
<td width="28"><?=$arfon?></td>
<td width="24"><?=$arhandy?></td>
<td width="10"> </td>
<td width="10" id="Rahmenlinks"> </td>
<td><?=$name?></td>
</tr>
<?
}
?>
</table>
</body>
</html>