$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) . " "; }