$table->addColumn("MAC address", "mac");
$table->addColumn("Hostname", "hostname");
$table->addColumn("Start", "start");
$table->addColumn("End", "end");
$table->addColumn("Online", "online");
$table->addColumn("Lease Type", "act", "listhdr");
// populate table data
$table->setData($leases);
?>
<p>
<table class="sortable" id="sortabletable" name="sortabletable" width="100%" border="0" cellpadding="0" cellspacing="0">
<?php
echo $table->getColumnHTML();
foreach ($table->getData() as $data) {
if ($data['act'] == "active" || $data['act'] == "static" || $_GET['all'] == 1) {
if ($data['act'] != "active" && $data['act'] != "static") {
$fspans = "<span class=\"gray\">";
$fspane = "</span>";
} else {
$fspans = $fspane = "";
}
$lip = ip2long($data['ip']);
if ($data['act'] == "static") {
foreach ($config['dhcpd'] as $dhcpif => $dhcpifconf) {
if (is_array($dhcpifconf['staticmap'])) {
foreach ($dhcpifconf['staticmap'] as $staticent) {
if ($data['ip'] == $staticent['ipaddr']) {
$data['if'] = $dhcpif;
break;
$menu->selectMenu($mode);
$menu->renderHTML();
$html .= $menu->getHTML();
unset($menu);
$html .= "<h1> Database " . $DB->Name($Server) . " - Table " . $Tablename . "</h1>";
// different views
switch ($mode) {
case "column":
switch ($submode) {
default:
// COLUMN DEFAULT
if (isset($Tablename)) {
$tbl = new Table($Server);
$tbl->setOwner($User);
$tbl->setName($Tablename);
$tbl->getData();
// table comment
if ($tbl->comments) {
$html .= "<br><table border=0><tr><th bgcolor=\"#DDDDDD\">Comments</th></tr>";
$html .= "<tr bgcolor=\"#DDDDDD\"><td>" . nl2br($tbl->comments) . "<td><tr>";
$html .= "</table><br>";
}
// table
$data = array();
if (is_array($tbl->columns)) {
foreach ($tbl->columns as $column) {
$tmp["Fieldname"] = $column->name;
$tmp["Types"] = $column->type;
$tmp["Lenght"] = $column->length;
$tmp["Scale"] = $column->scale;
$tmp["Null"] = $column->nullable;
