$bx->box_begin();
if ($by && $by == "%") {
$bystr = $t->translate("All");
} else {
$bystr = ereg_replace("%", "", $by);
}
$bx->box_title($t->translate("Users") . ": " . $bystr);
$bx->box_body_begin();
echo "<table border=0 align=center cellspacing=1 cellpadding=1 width=100%>\n";
echo "<tr><td><b>" . $t->translate("No") . ".</b></td><td><b># " . $t->translate("Docs") . "</b></td><td><b>" . $t->translate("Username") . "</b></td><td><b>" . $t->translate("Realname") . "</b></td><td><b>" . $t->translate("E-Mail") . "</b></td></tr>\n";
$i = 1;
while ($db->next_record()) {
$username = $db->f("username");
$db2 = new DB_DocsWell();
$db2->query("SELECT COUNT(*) FROM DOKUMENT d, KATEGORIE k WHERE d.ANGELEGTVON='{$username}' AND d.status!='D' AND d.KATEGORIE=k.ID");
$db2->next_record();
$num = "[" . sprintf("%03d", $db2->f("COUNT(*)")) . "]";
echo "<tr><td>" . sprintf("%d", $i) . "</td>\n";
echo "<td><a href=\"" . $sess->url("docbyuser.php") . $sess->add_query(array("usr" => $username)) . "\">{$num}</a></td>\n";
echo "<td>" . $username . "</td>\n";
echo "<td>" . $db->f("realname") . "</td>";
echo "<td><<a href=\"mailto:" . $db->f("email_usr") . "\">" . ereg_replace("@", " at ", htmlentities($db->f("email_usr"))) . "</a>></td>";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
}
?>
<!-- end content -->
<!-- content -->
<?php
if ($config_perm_admfaq != "all" && (!isset($perm) || !$perm->have_perm($config_perm_admfaq))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$db->query("SELECT ID,TITEL, KATEGORIE FROM DOKUMENT WHERE STATUS !='D'");
$dbKat = new DB_DocsWell();
$bx->box_begin();
$bx->box_title($t->translate("Document and category check"));
$bx->box_body_begin();
$bs->box_strip($t->translate("Documents with categories that have further sub-categories (documents should only hang on leaves)"));
echo "<table width=100% border=0><tr><td>\n";
$counter = 0;
while ($db->next_record()) {
$dbKat->query("SELECT count(*) as anz FROM KATEGORIE WHERE PARENT_ID=" . $db->f("KATEGORIE"));
$dbKat->next_record();
if ($dbKat->f("anz") > 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("Documents with deleted category"));
$db->query("SELECT ID,TITEL, KATEGORIE FROM DOKUMENT WHERE STATUS != 'D'");
echo "<table width=100% border=0><tr><td>\n";
?>
:</B><BR><font size="1">(<?php
echo $t->translate("multiselection possible");
?>
)</font></TD>
<TD>
<select name="mautoren[]" size="15" multiple>
<?php
//############################# Autoren holen ##################################
$db->query("SELECT * FROM AUTOR ORDER BY NACHNAME ASC");
$db2 = new DB_DocsWell();
while ($db->next_record()) {
echo "<option value=\"" . $db->f("ID") . "\" ";
if (!$mautoren) {
$db2->query("SELECT * FROM PENDING_ATR_DKMNT WHERE PENDING_ID={$ID}");
while ($db2->next_record()) {
if ($db2->f("AUTOR_ID") == $db->f("ID")) {
echo " selected ";
}
}
} else {
for ($i = 0; $i < count($mautoren); $i++) {
if ($mautoren[$i] == $db->f("ID")) {
echo " selected ";
}
}
}
echo ">" . $db->f("NACHNAME");
if ($db->f("VORNAME") != "") {
echo ", " . $db->f("VORNAME");
}
?>
</TD>
</TR>
<TR>
<TD align="right" valign="top"><B><?php
echo $t->translate("Category");
?>
:</B></TD>
<TD>
<?php
$dbKat = new DB_DocsWell();
$cat_path = "";
$dbt = new DB_DocsWell();
$dbt->query("SELECT * FROM KATEGORIE WHERE ID=" . $kategorie);
//echo "------>".$db->f("KATID");
$dbt->next_record();
$parent = $dbt->f("PARENT_ID");
$pfad = array();
while ($parent != 1) {
array_unshift($pfad, $dbt->f("NAME"));
$dbt->query("SELECT * FROM KATEGORIE WHERE ID={$parent}");
$dbt->next_record();
$parent = $dbt->f("PARENT_ID");
}
array_unshift($pfad, $dbt->f("NAME"));
$counter = 0;
$anz = count($pfad);
foreach ($pfad as $onestep) {
$counter++;
$cat_path .= " :: " . $t->translate($onestep) . " ";
}
