if (!$res) {
$body->line('no further feedback');
} else {
$table = new Table();
$table->setClas('result');
$table->setId('listing');
$table->build();
$odd = TRUE;
foreach ($res as $item) {
if (!$titles) {
$tr = new Th();
$names = array_keys(get_object_vars($item));
foreach ($names as $title) {
$tr->add($title);
}
$tr->build();
$titles = TRUE;
}
$tr = new Tr();
if ($odd) {
$tr->setGlobalClass('even');
$odd = FALSE;
} else {
$tr->setGlobalClass('odd');
$odd = TRUE;
}
foreach ($item as $data) {
// display odd characters
$tr->add(htmlentities($data));
}
$tr->build();
$body->line();
$q = "PRAGMA index_list(" . $req->get('table') . ")";
$sql->qo($q);
$res = $sql->fo();
if (!$res) {
$body->line('No indexes defined<br>');
} else {
$table = new Table();
$table->setClas('result');
$table->build();
$th = new Th();
$th->add('Name');
$th->add('Unique ?');
$th->add('Columns');
$th->add(' ');
$th->build();
foreach ($res as $item) {
if ($item->unique == 1) {
$uniq = 'Y';
} else {
$uniq = 'N';
}
$drop = new Link();
$drop->setHref('controller.php?cmd=drop_idx&idxname=' . $item->name . '&table=' . $req->get('table'));
$drop->setName('[ drop ]');
$drop->setJs(' onclick="return PSA.really_drop(\' index [' . $item->name . ']\');" ');
$tr = new Tr();
if ($odd) {
$tr->setGlobalClass('even');
$odd = FALSE;
} else {
