}
}
if ($counter == 0) {
echo $t->translate("No documents found");
}
echo "</td></tr>";
echo "<tr><td colspan=\"2\">";
echo "</td></tr>";
echo "</table>\n";
$bs->box_strip($t->translate("Documents with deleted category"));
$db->query("SELECT ID,TITEL, KATEGORIE FROM DOKUMENT WHERE STATUS != 'D'");
echo "<table width=100% border=0><tr><td>\n";
$counter = 0;
while ($db->next_record()) {
$dbKat->query("SELECT ID FROM KATEGORIE WHERE ID=" . $db->f("KATEGORIE"));
if ($dbKat->num_rows() == 0) {
echo "<a href=\"update_online.php?ID=" . $db->f("ID") . "\">" . $db->f("TITEL") . "</a><br>";
$counter++;
}
}
if ($counter == 0) {
echo $t->translate("No documents found");
}
echo "</td></tr>";
echo "<tr><td colspan=\"2\">";
echo "</td></tr>";
echo "</table>\n";
$bs->box_strip($t->translate("All deleted documents"));
$db->query("SELECT ID,TITEL FROM DOKUMENT WHERE STATUS = 'D' ORDER BY TITEL");
echo "<table width=100% border=0><tr><td>\n";
$counter = 0;
