<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15">
<title>Anrufer-Liste</title>
</head>
<body>
<? if(!isset($l10)) $l10=0; ?>
<div align="center">
<form action="calls.php">
<button name="l10" value="0" type="submit">verpasst</button>
<button name="l10" value="1" type="submit">erfolglos</button>
<button name="l10" value="2" type="submit">angenommen</button>
<button name="l10" value="3" type="submit">angerufen</button>
</form>
</div>
<?
$host = "localhost";
$id = "<mysql_user_id>";
$pw = "mysql_user_password";
$db = "asteriskcdrdb";
$tabelle = "cdr";
$link = mysql_connect($host,$id,$pw);
mysql_select_db($db,$link);
$anzahl = mysql_num_rows(mysql_query("select * from $tabelle"))-10;
$felder = "src,dst,dcontext,clid,calldate,billsec,disposition";
$listcall=array( "select clid as Rufnummer,calldate as Anrufzeit from $tabelle where not billsec order by calldate desc limit 10",
"select dst as Rufnummer,calldate as Anrufzeit from $tabelle where not billsec and order by calldate desc limit 10",
"select clid as Rufnummer,calldate as Anrufzeit,sec_to_time(billsec) as Dauer from $tabelle where billsec and order by calldate desc limit 10",
"select dst as Rufnummer,calldate as Anrufzeit,sec_to_time(billsec) as Dauer from $tabelle where billsec and order by calldate desc limit 10",
);
$titelzeile=array( "Verpaßte Anrufe", "Erfolglose Anrufe", "Angenommene Anrufe", "Getätigte Anrufe");
show_table($listcall[$l10],$titelzeile[$l10]);
?>
</body>
</html>
<?php
function show_table($query_cmd,$titel)
{
$ergebnis = sql_status($query_cmd);
$anz_reihen = mysql_num_rows( $ergebnis );
$anz_felder = mysql_num_fields( $ergebnis );
print "<div align=center><table border=1>\n";
print "<tr><th colspan=$anz_felder bgcolor=LightGreen>$titel</th></tr>";
print "<tr>";
for ( $x=0; $x<$anz_felder; $x++ )
{ print "<th bgcolor=LightGreen>";
print mysql_field_name( $ergebnis,$x);
print "</th>";}
print "</tr>";
while ( $datensatz = mysql_fetch_row( $ergebnis ) )
{ print "<tr>\n";
foreach ( $datensatz as $feld )
print "\t<td bgcolor=Aquamarine>$feld</td>\n";
print "</tr>\n";}
print "</table></div><hr>\n";
}
?>
