# Form for deleting docs
#
# This program is free software. You can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 or later of the GPL.
######################################################################
page_open(array("sess" => "DocsWell_Session", "auth" => "DocsWell_Auth", "perm" => "DocsWell_Perm"));
require "header.inc";
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
?>
<!-- content -->
<?php
if ($perm->have_perm("editor") || $perm->have_perm("admin")) {
$bx->box_begin();
$bx->box_title($t->translate("Delete an entry"));
$bx->box_body_begin();
## Dokument soll gelöscht werden, hier die Datenüberprüfung
if ($status == 'do_new') {
if ($Del) {
$db->query("UPDATE DOKUMENT SET STATUS='D' WHERE ID={$ID}");
$newentry = $t->translate("Entry status set to deleted");
}
}
## doc soll gelöscht werden
if ($status == 'edit_new' or $error_ar) {
$db->query("SELECT * FROM DOKUMENT WHERE ID={$ID}");
$db->next_record();
$eintrag[ANGELEGTVON] = $db->f("ANGELEGTVON");
$eintrag[SPRACHE] = $db->f("SPRACHE");
$eintrag[TYP] = $db->f("TYP");
@page_close();
page_open(array("sess" => "DocsWell_Session", "auth" => "DocsWell_Auth", "perm" => "DocsWell_Perm"));
}
require "header.inc";
$bx = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$bs = new box("100%", $th_strip_frame_color, $th_strip_frame_width, $th_strip_title_bgcolor, $th_strip_title_font_color, $th_strip_title_align, $th_strip_body_bgcolor, $th_strip_body_font_color, $th_strip_body_align);
?>
<!-- content -->
<?php
if ($config_perm_admlang != "all" && (!isset($perm) || !$perm->have_perm($config_perm_admlang))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$bx->box_begin();
$bx->box_title($t->translate("Document Language Administration"));
$bx->box_body_begin();
// Insert a new Language
$bs->box_strip($t->translate("Insert Language"));
echo "<form action=\"" . $sess->url("inslang.php") . "\" method=\"POST\">\n";
echo "<table border=0 cellspacing=0 cellpadding=3 width=100%>\n";
echo "<tr><td align=right width=30%>" . $t->translate("New Language") . " (100):</td><td width=70%><input type=\"TEXT\" name=\"language\" size=40 maxlength=100>\n";
echo "</td></tr>\n";
echo "<tr><td> </td>\n";
echo "<td><input type=\"submit\" value=\"" . $t->translate("Insert") . "\">";
echo "</td></tr>\n";
echo "</form>\n";
echo "</table>\n";
echo "<BR>\n";
// Rename Language
$bs->box_strip($t->translate("Rename Language"));
<!-- content -->
<?php
if ($config_perm_watch != "all" && (!isset($perm) || !$perm->have_perm($config_perm_watch))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$username = $auth->auth["uname"];
htmlp_form_action("watchset.php", array(), "POST");
echo "\n";
$db3->query("SELECT * FROM prog_ability_watch WHERE username='******'");
if ($db3->next_record()) {
$exists = 1;
} else {
$exists = 0;
}
$bx->box_begin();
$bx->box_title($t->translate("Set your Developers Watch"));
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=center><B>" . $t->translate("Which programming experiences you like to watch?") . "</B></td></tr><tr><td>\n";
echo "<center><table border=0>\n";
$db->query("SELECT * from prog_abilities WHERE translation='{$la}'");
$count = 0;
while ($db->next_record()) {
$count++;
$ability_code = $db->f("code");
$colname = $db->f("colname");
if ($count == 1) {
echo "<tr>\n";
}
echo "<td align=right>" . $db->f("ability") . "</td><td>\n";
htmlp_select("ability[" . $ability_code . "]");
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
?>
<!-- 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 {
if (isset($delete)) {
if ($delete == 1) {
$query = "SELECT * FROM faq WHERE faqid='{$faqid}' AND language='{$la}'";
$db->query($query);
$db->next_record();
faqshow($db);
$bx->box_begin();
$bx->box_title($t->translate("Do you really want to delete this FAQ? There is no way for undeletion."));
$bx->box_body_begin();
echo "<table><tr><td>\n";
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<input type=\"hidden\" name=\"faqid\" value=\"" . $db->f("faqid") . "\">\n";
echo "<input type=\"hidden\" name=\"delete\" value=\"2\">\n";
echo "<input type=\"hidden\" name=\"modify\" value=\"0\">\n";
echo "<input type=\"submit\" value=\"" . $t->translate("Yes, Delete") . "\">\n";
echo "</form></td><td>\n";
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<input type=\"hidden\" name=\"faqid\" value=\"" . $db->f("faqid") . "\">\n";
echo "<input type=\"hidden\" name=\"modify\" value=\"1\">\n";
echo "<input type=\"hidden\" name=\"delete\" value=\"0\">\n";
echo "<input type=\"submit\" value=\"" . $t->translate("No, Just Modify") . "\">\n";
echo "</form></td></tr></table>\n";
$bx->box_body_end();
}
if (isset($del_format)) {
// Formaqt in database and we want to delete it
if (!strcmp($del_format, "warning")) {
// You've got another chance before it's deleted
// We inform the administrator how many
// docs will be affected by this deletion
$db->query("SELECT ID FROM FORMATDEF WHERE NAME='{$format}'");
$db->next_record();
$formatid = $db->f("ID");
$db->query("SELECT COUNT(*) FROM FORMAT WHERE FORMATID='{$formatid}'");
$db->next_record();
$number_of_docs = $db->f("COUNT(*)");
$be->box_full($t->translate("Warning!"), $t->translate("If you press another time the Delete-button you will alter") . " {$number_of_docs} " . $t->translate("documants that have actually format") . " {$format}");
$bx->box_begin();
$bx->box_title($t->translate("Delete Format"));
$bx->box_body_begin();
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<table border=0 cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=right>" . $t->translate("Format") . ":</td><td>\n";
echo $format;
echo "</td></tr>\n";
echo "<tr><td> </td>\n";
echo "<input type=\"hidden\" name=\"format\" value=\"{$format}\">\n";
echo "<input type=\"hidden\" name=\"del_format\" value=\"too_late\">\n";
echo "<td><input type=\"submit\" value=\"" . $t->translate("Delete") . "\">";
echo "</td></tr>\n";
echo "</form>\n";
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
if (!isset($leaves)) {
$leaves = ":1:";
}
if (isset($addid)) {
$leaves .= ":{$addid}:";
}
if (isset($delid)) {
$leaves = str_replace(":{$delid}:", "", $leaves);
}
if ($action == "db_set") {
// DB SET
$query = "UPDATE tblsolutions SET category_id='{$cate_id}' WHERE solutions_id='{$solu_id}'";
$db->query($query);
}
/*------------------------------------------------------- BOX tbllicense */
$bx->box_begin();
$bx->box_title($t->translate("Select Category of Solution"));
$bx->box_body_begin();
/*----------------------------------------------------------- whole Tree */
category_tree(0, 0, $cate_id);
/*-----------------------------------------------------------------------*/
$bx->box_body_end();
$bx->box_end();
/*-----------------------------------------------------------------------*/
echo "<p align='center'><b>[<a href='" . $sess->url("newsolutions.php") . $sess->add_query(array("solu_id" => $solu_id)) . "'>" . $t->translate("Back to your solution") . "</a>]</b>";
?>
<!-- end content -->
<?php
require "footer.inc";
@page_close();
} else {
if ($action == "db_add") {
// DB ADD
$query = "INSERT tbllicense(license_name,license_url) VALUES('{$name}','{$lurl}')";
$db->query($query);
}
}
}
if ($action == "change") {
// CHANGE
$id = rawurldecode($id);
$name = rawurldecode($name);
$ourl = rawurldecode($ourl);
/*-------------------------------------------------------------------------------------*/
$bx->box_begin();
$bx->box_title($t->translate("Change License"));
$bx->box_body_begin();
/*-------------------------------------------------------------------------------------*/
echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>\n";
$tbw->table_begin();
$tbw->table_row_begin();
$tbw->table_body_column_begin();
/*----------*/
echo "<b>" . $t->translate("License") . ":</b>";
$tbw->table_body_column_next(2);
echo "<input type='text' size='40' maxlength='255' name='name' value='{$name}'>\n";
$tbw->table_body_column_end();
/*----------*/
$tbw->table_row_next();
$tbw->table_body_column_begin();
echo "<b>" . $t->translate("Homepage") . ":</b>";
require 'include/header.inc';
require 'include/faqlib.inc';
$bx = new box('80%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box('80%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
start_content();
if ($config_perm_admfaq != 'all' && (!isset($perm) || !$perm->have_perm($config_perm_admfaq))) {
$be->box_full($t->translate('Error'), $t->translate('Access denied'));
} else {
if (isset($delete)) {
if ($delete == 1) {
$query = "SELECT * FROM faq WHERE faqid='{$faqid}' AND " . "language='{$la}'";
$db->query($query);
$db->next_record();
faqshow($db);
$bx->box_begin();
$bx->box_title($t->translate('Do you really want to ' . 'delete this FAQ? ' . 'There is no way for undeletion.'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '76%', '', '<b>' . $db->f('question') . '</b><p>' . $db->f('answer'));
$bx->box_column('right', '12%', '', html_form_action('PHP_SELF') . html_form_hidden('modify', 0) . html_form_hidden('delete', 2) . html_form_hidden('faqid', $db->f('faqid')) . html_form_submit($t->translate('Yes, Delete'), 'Delete') . html_form_end() . html_form_action('PHP_SELF') . html_form_hidden('modify', 1) . html_form_hidden('delete', 0) . html_form_hidden('faqid', $db->f('faqid')) . html_form_submit($t->translate('No, just modify'), 'modify') . html_form_end());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
}
if ($delete == 2) {
// We remove it from our DB
$db->query("DELETE FROM faq WHERE faqid='{$faqid}' AND " . "language='{$la}'");
if ($db->affected_rows() < 1) {
$be->box_full($t->translate('Error'), $t->translate('Database Error'));
} else {
$bx->box_full($t->translate('Frequently Asked Questions ' . 'Administration'), $t->translate('The FAQ has been deleted'));
require 'include/header.inc';
require 'include/docolib.inc';
$bx = new box('80%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box('80%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
start_content();
if ($config_perm_admdoco != 'all' && (!isset($perm) || !$perm->have_perm($config_perm_admdoco))) {
$be->box_full($t->translate('Error'), $t->translate('Access denied'));
} else {
if (isset($delete)) {
if ($delete == 1) {
$query = "SELECT * FROM doco WHERE docoid='{$docoid}' " . "AND language='{$la}'";
$db->query($query);
$db->next_record();
doco_show($db);
$bx->box_begin();
$bx->box_title($t->translate('Do you really want to delete ' . 'this Page Documentation entry?'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '76%', '', $t->translate('There is no way for undeletion.'));
$bx->box_column('right', '12%', '', html_form_action('PHP_SELF') . html_form_hidden('modify', 0) . html_form_hidden('delete', 2) . html_form_hidden('docoid', $db->f('docoid')) . html_form_submit($t->translate('Yes, Delete')) . html_form_end() . html_form_action('PHP_SELF') . html_form_hidden('modify', 1) . html_form_hidden('delete', 0) . html_form_hidden('docoid', $db->f('docoid')) . html_form_submit($t->translate('No, just modify')) . html_form_end());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
}
if ($delete == 2) {
// We remove it from our DB
$db->query("DELETE FROM doco WHERE docoid='{$docoid}' " . "AND language='{$la}'");
if ($db->affected_rows() < 1) {
$be->box_full($t->translate('Error'), $t->translate('Database Error'));
} else {
$bx->box_full($t->translate('Page Documentation ' . 'Administration'), $t->translate('The documentation for that ' . 'page has been deleted'));
page_open(array("sess" => "DevCounter_Session", "auth" => "DevCounter_Auth", "perm" => "DevCounter_Perm"));
}
require "./include/header.inc";
$bx = new box("100%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$db2 = new DB_DevCounter();
$db3 = new DB_DevCounter();
?>
<!-- content -->
<?php
if (empty($auth->auth["uname"])) {
$be->box_full($t->translate("Not logged in"), $t->translate("Please login first"));
} else {
$bx->box_begin();
$bx->box_title($t->translate("Personal Data"));
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=0 cellpadding=3>\n";
htmlp_form_action("insert.php", "", "POST");
echo "\n";
$username = $auth->auth["uname"];
htmlp_form_hidden("username", $username);
echo "<tr><td align=right width=30%>" . $t->translate("Username") . ":</td><td width=70%> {$username}\n";
echo "<tr><td align=right width=30%>" . $t->translate("Nationality") . ":</td><td width=70%>\n";
htmlp_select("nationality");
echo "\n";
select_country(999);
htmlp_select_end();
echo "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Country you currently live in") . ":</td><td width=70%>\n";
htmlp_select("actual_country");
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$db2 = new DB_DevCounter();
?>
<!-- content -->
<?php
$counter = 0;
if (empty($auth->auth["uname"])) {
$be->box_full($t->translate("Not logged in"), $t->translate("Please login first"));
} else {
$username = $auth->auth["uname"];
$db->query("SELECT * FROM requests WHERE reqid='{$reqid}' AND username='******'");
if ($db->num_rows() == 1) {
$db->next_record();
$bx->box_begin();
$bx->box_title($t->translate("edit request"));
$bx->box_body_begin();
htmlp_form_action("req_manage.php", "", "POST");
htmlp_form_hidden("option", "edit");
htmlp_form_hidden("reqid", $reqid);
echo $t->translate("Subject") . ":<BR>";
$reqsubject = $db->f("reqsubject");
htmlp_input_text("reqsubject", 50, 75, $reqsubject);
htmlp_form_submit($t->translate("Send"), "");
echo "<BR>\n";
echo $t->translate("Related to which Project") . ":<BR>";
htmlp_select("projectname");
$devprojectname = $db->f("projectname");
$db2->query("SELECT * FROM os_projects WHERE username='******'");
while ($db2->next_record()) {
if ($devprojectname == $db2->f("projectname")) {
$db->query($query);
}
}
}
if ($action == "change") {
// CHANGE
$id = rawurldecode($id);
$keyword = rawurldecode($keyword);
$solu_id = rawurldecode($solu_id);
$db_chg = new DB_SourceLines();
$query = "SELECT * FROM tblkeyword WHERE keyword_id = '{$id}' AND solutions_id = '{$solu_id}'";
$db_chg->query($query);
$db_chg->next_record();
/*-----------------------------------------------------------------------*/
$bx->box_begin();
$bx->box_title($t->translate("Change keyword"));
$bx->box_body_begin();
/*-----------------------------------------------------------------------*/
echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
$tbw->table_begin();
// keyword
$tbw->table_row_begin();
$tbw->table_body_column_begin();
echo "<b>" . $t->translate("Keyword") . ":</b>";
$tbw->table_body_column_next(2);
echo "<input type='text' size='40' maxlength='128' name='keyword' value='" . $db_chg->f("keyword_text") . "'>";
$tbw->table_body_column_end();
// buttons
$tbw->table_row_next();
$tbw->table_body_column(" ");
$tbw->table_body_column_begin();
if ($action == "db_add") {
// DB_ADD
$query = "INSERT tbllanguage(language_name) VALUES('{$name}') ";
if (!$db->query($query)) {
mysql_die($db);
}
}
}
}
if ($action == "change") {
// CHANGE
$id = rawurldecode($id);
$name = rawurldecode($name);
/*-----------------------------------------------------------------------*/
$bx->box_begin();
$bx->box_title($t->translate("Change Language"));
$bx->box_body_begin();
/*-----------------------------------------------------------------------*/
echo "<form action='" . $sess->url(basename($PHP_SELF)) . "' method='POST'>";
$tbw->table_begin();
$tbw->table_row_begin();
$tbw->table_body_column_begin();
echo "<b>" . $t->translate("Language") . ":</b>";
$tbw->table_body_column_next(2);
echo "<input type='text' size='40' maxlength='128' name='name' value='{$name}'>";
$tbw->table_body_column_end();
// buttons
$tbw->table_row_next();
$tbw->table_body_column("");
$tbw->table_body_column_begin();
echo "<input type='hidden' name='id' value='{$id}'>";
if ($ml_notify) {
$message = "Username: {$username}\n";
$message .= "Realname: {$realname}\n";
$message .= "E-Mail: {$email_usr}\n";
mailuser("admin", "New User has registered", $message);
}
$bx->box_full($t->translate("User Registration"), $msg);
$reg = 1;
break;
default:
break;
}
}
if (!$reg) {
$bx->box_begin();
$bx->box_title($t->translate("Register as a new User"));
$bx->box_body_begin();
?>
<table border=0 cellspacing=0 cellpadding=3>
<tr>
<form method="post" action="<?php
$sess->pself_url();
?>
">
<td align=right><?php
echo $t->translate("Username");
?>
:</td><td><input type="text" name="username" size=20 maxlength=32 value=""></td>
</tr>
<tr valign=middle align=left>
<td align=right><?php
// URL is a blank line
$be->box_full($t->translate('Error'), $t->translate('New URL not specified'));
}
}
if (isset($del_license)) {
// License in database and we want to delete it
if (!strcmp($del_license, 'warning')) {
// You've got another chance before it's deleted ;-)
// We inform the administrator how many
// projects will be affected by this deletion
$db->query("SELECT COUNT(*) FROM developing WHERE " . "license='{$license}'");
$db->next_record();
$number_of_projects = $db->f('COUNT(*)');
$be->box_full($t->translate('Warning!'), $t->translate('If you press another time the ' . 'Delete-button you will alter') . ' ' . $number_of_projects . ' ' . $t->translate('projects that have ' . 'actually license') . ' ' . $license);
$bx->box_begin();
$bx->box_title($t->translate('Delete License'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '76%', '', '<b>' . $t->translate('License') . '</b>: ' . $license);
$bx->box_column('right', '12%', '', html_form_action('PHP_SELF') . html_form_hidden('license', $license) . html_form_hidden('del_license', 'too_late') . html_form_submit($t->translate('Delete')) . html_form_end());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
$bx->box_body_end();
$bx->box_end();
} else {
$db->query("DELETE from licenses WHERE license='{$license}'");
$bx->box_full($t->translate('Administration'), $t->translate('Deletion succesfully completed.'));
}
} else {
if (empty($new_license) && empty($new_url) && empty($del_license)) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
if (!isset($by) || empty($by)) {
$by = "";
}
$alphabet = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");
$msg = "[ ";
while (list(, $ltr) = each($alphabet)) {
$msg .= "<a href=\"" . $sess->self_url() . $sess->add_query(array("by" => $ltr)) . "\">{$ltr}</a> | ";
}
$msg .= "<a href=\"" . $sess->self_url() . $sess->add_query(array("by" => $ltr)) . "\">" . $t->translate("All") . "</a> ]";
$bs->box_strip($msg);
$by = $by . "%";
$db->query("SELECT DOKUMENT.ID,TITEL,AUTOR,SUBJECT,DATUM FROM KOMMENTAR,DOKUMENT WHERE DOKUMENT.ID = KOMMENTAR.DOKUMENTID AND DOKUMENT.TITEL LIKE '{$by}' ORDER BY KOMMENTAR.DATUM DESC");
$bx->box_begin();
$bx->box_title($t->translate("Comments"));
$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>\n";
echo "<td><b>" . $t->translate("Document") . "</b></td>\n";
echo "<td><b>" . $t->translate("Subject") . "</b></td>\n";
echo "<td><b>" . $t->translate("Author") . "</b></td>\n";
echo "<td><b>" . $t->translate("Posted on") . "</b></td>\n";
echo "<td> </td>\n";
echo "<td> </td></tr>\n";
$i = 1;
while ($db->next_record()) {
echo "<tr><td>{$i}</td>\n";
echo "<td><a href=\"" . $sess->url("docbyid.php?id=" . $db->f("ID") . "") . "\">" . $db->f("TITEL") . "</a></td>\n";
echo "<td>" . $db->f("SUBJECT") . "</td>\n";
echo "<td>" . $db->f("AUTOR") . "</td>\n";
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 or later of the GPL.
######################################################################
page_open(array("sess" => "DocsWell_Session", "auth" => "DocsWell_Auth", "perm" => "DocsWell_Perm"));
require "header.inc";
if ($category && !$kategorie) {
$kategorie = $category;
}
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
?>
<!-- content -->
<?php
if ($perm->have_perm("editor") || $perm->have_perm("admin")) {
$bx->box_begin();
$bx->box_title($t->translate("Verify new document"));
$bx->box_body_begin();
## Neues Dokument soll eingefügt werden, hier die Datenüberprüfung
if ($status == 'do_new') {
if ($Button == "OK") {
// Eingaben ueberpruefen
if (!$titel) {
$error_ar["titel"] = $t->translate("Error") . ": " . $t->translate("Please enter the titel of the document") . " (" . __LINE__ . ")";
// echo $error_ar["titel"];
}
if ($titel && strlen($titel) < 2) {
$error_ar["titel"] = $t->translate("Error") . ": " . $t->translate("The titel is to short") . " (" . __LINE__ . ")";
// echo $error_ar["titel"];
}
if (!$beschreibung) {
$error_ar["beschreibung"] = $t->translate("Error") . ": " . $t->translate("Please enter a description for this document") . " (" . __LINE__ . ")";
}
$reqlang = $db->f("language");
$bx->box_column("center", "", $bgcolor, get_lang($reqlang));
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
}
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
$bs->box_strip($msg);
} else {
$db->query("SELECT * FROM requests WHERE reqid='{$reqid}'");
$username = $auth->auth["uname"];
if ($db->num_rows() == 0) {
$bx->box_begin();
$bx->box_title($t->translate("Error"));
$bx->box_body_begin();
echo $t->translate("No such request");
$bx->box_body_end();
$bx->box_end();
} else {
$db->next_record();
$reqsubject = $db->f("reqsubject");
//$bs->box_strip($t->translate("Show request"));
$bx->box_begin();
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_colspan(2, "center", $th_strip_title_bgcolor, "<b>" . $reqsubject . "</b>", "");
$bgcolor = "#FFFFFF";
$bx->box_next_row_of_columns();
$bx->box_column("left", "30%", $bgcolor, "<B>" . $t->translate("Developer") . ":</B> ");
}
if (isset($del_type)) {
// Formaqt in database and we want to delete it
if (!strcmp($del_type, "warning")) {
// You've got another chance before it's deleted
// We inform the administrator how many
// docs will be affected by this deletion
$db->query("SELECT ID FROM TYPDEF WHERE NAME='{$type}'");
$db->next_record();
$typeid = $db->f("ID");
$db->query("SELECT COUNT(*) FROM DOKUMENT WHERE TYP='{$typeid}'");
$db->next_record();
$number_of_docs = $db->f("COUNT(*)");
$be->box_full($t->translate("Warning!"), $t->translate("If you press another time the Delete-button you will alter") . " {$number_of_docs} " . $t->translate("documants that have actually type") . " {$type}");
$bx->box_begin();
$bx->box_title($t->translate("Delete Type"));
$bx->box_body_begin();
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<table border=0 cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=right>" . $t->translate("Type") . ":</td><td>\n";
echo $type;
echo "</td></tr>\n";
echo "<tr><td> </td>\n";
echo "<input type=\"hidden\" name=\"type\" value=\"{$type}\">\n";
echo "<input type=\"hidden\" name=\"del_type\" value=\"too_late\">\n";
echo "<td><input type=\"submit\" value=\"" . $t->translate("Delete") . "\">";
echo "</td></tr>\n";
echo "</form>\n";
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
require "include/prepend.php3";
page_open(array('sess' => 'SourceAgency_Session'));
if (isset($auth) && !empty($auth->auth['perm'])) {
page_close();
page_open(array('sess' => 'SourceAgency_Session', 'auth' => 'SourceAgency_Auth', 'perm' => 'SourceAgency_Perm'));
}
require 'include/header.inc';
$bx = new box('97%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box('80%', $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
start_content();
if ($config_perm_admdoco != 'all' && (!isset($perm) || !$perm->have_perm($config_perm_admdoco))) {
$be->box_full($t->translate('Error'), $t->translate('Access denied'));
} else {
$db->query("SELECT * FROM doco WHERE language='{$la}'");
$bx->box_begin();
$bx->box_title($t->translate('Page Documentation Administration'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '88%', '', $t->translate('Enter a new ' . 'documentation entry ' . 'for a page'));
$bx->box_column('right', '12%', '', html_form_action('insdoco.php') . html_form_hidden('create', 1) . html_form_submit($t->translate('Insert'), 'Insert') . html_form_end());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
while ($db->next_record()) {
$bx->box_begin();
$bx->box_title($t->translate('Page') . ': ' . $db->f('page') . ', ' . $t->translate('Header') . ': ' . $db->f('header'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '76%', '', $db->f('doco'));
$bx->box_column('right', '12%', '', html_form_action('insdoco.php') . html_form_hidden('modify', 1) . html_form_hidden('delete', 0) . html_form_hidden('docoid', $db->f('docoid')) . html_form_submit($t->translate('Change'), 'Change') . html_form_end());
$bx->box_column('right', '12%', '', html_form_action('insdoco.php') . html_form_hidden('modify', 0) . html_form_hidden('delete', 1) . html_form_hidden('docoid', $db->f('docoid')) . html_form_submit($t->translate('Delete'), 'Delete') . html_form_end());
if ($ml_notify) {
$message = "Username: "******"uname"] . "\n";
$message .= "Realname: {$realname}\n";
$message .= "E-Mail: {$email_usr}\n";
mailuser("admin", "User parameters has changed", $message);
}
} else {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
}
break;
default:
break;
}
}
$bx->box_begin();
$bx->box_title($t->translate("Change User Parameters"));
$bx->box_body_begin();
echo "<table border=0 align=\"center\" cellspacing=0 cellpadding=3>\n";
$db->query("select * from auth_user where username='******'");
while ($db->next_record()) {
?>
<form method="post" action="<?php
$sess->pself_url();
?>
">
<tr valign=middle align=left>
<td align=right><?php
echo $t->translate("Username");
?>
:</td><td><?php
$db->p("username");
# This file permits that users can get their forgotten password via e-mail
#
# This program is free software. You can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 or later of the GPL.
######################################################################
require "include/prepend.php3";
page_open(array("sess" => "SourceAgency_Session"));
if (isset($auth) && !empty($auth->auth["perm"])) {
page_close();
page_open(array("sess" => "SourceAgency_Session", "auth" => "SourceAgency_Auth", "perm" => "SourceAgency_Perm"));
}
require "include/header.inc";
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
start_content();
$bx->box_begin();
$bx->box_title($t->translate("Forgot Password"));
$bx->box_body_begin();
echo "<form method=\"post\" action=\"remindme.php\">\n";
echo "<table border=0 cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=right>" . $t->translate("Username") . ":</td><td><input type=\"text\" name=\"username\" size=20 maxlength=32 value=\"\"></td></tr>\n";
echo "<tr valign=middle align=left>\n";
echo "<td align=right>" . $t->translate("E-Mail") . ":</td><td><input type=\"text\" name=\"email_usr\" size=20 maxlength=32 value=\"\"></td></tr>\n";
echo "<tr valign=middle align=left><td></td><td>\n";
echo "<input type=\"submit\" name=\"remind\" value=\"" . $t->translate("Remind me") . "\">\n";
echo "</td></tr></form></table>\n";
$bx->box_body_end();
$bx->box_end();
end_content();
require "include/footer.inc";
page_close();
}
$alphabet = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");
$msg = "[ ";
while (list(, $ltr) = each($alphabet)) {
$msg .= "<a href=\"" . $sess->url("users.php") . $sess->add_query(array("by" => $ltr . "%")) . "\">{$ltr}</a> | ";
}
$msg .= "<a href=\"" . $sess->self_url() . $sess->add_query(array("by" => "%")) . "\">" . $t->translate("All") . "</a> ]";
$bs->box_strip($msg);
$db->query("SELECT * FROM auth_user WHERE username LIKE '{$by}' ORDER BY username ASC");
$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>";
$be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
?>
<!-- content -->
<?php
if ($config_perm_admcomment != "all" && (!isset($perm) || !$perm->have_perm($config_perm_admcomment))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
if (isset($delete)) {
if ($delete == 1) {
$query = "SELECT * FROM KOMMENTAR WHERE DATUM='{$modification}' AND DOKUMENTID='{$id}'";
cmtshow($query);
$db->query($query);
$db->next_record();
$bx->box_begin();
$bx->box_title($t->translate("Delete this comment? (please, think there's no way for undoing comment deletion)"));
$bx->box_body_begin();
echo "<table><tr><td>\n";
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<input type=\"hidden\" name=\"modification\" value=\"" . $db->f("DATUM") . "\">\n";
echo "<input type=\"hidden\" name=\"id\" value=\"" . $db->f("ID") . "\">\n";
echo "<input type=\"hidden\" name=\"delete\" value=\"2\">\n";
echo "<input type=\"hidden\" name=\"modify\" value=\"0\">\n";
echo "<input type=\"submit\" value=\"" . $t->translate("Yes, Delete") . "\">\n";
echo "</form></td><td>\n";
echo "<form action=\"" . $sess->self_url() . "\" method=\"POST\">\n";
echo "<input type=\"hidden\" name=\"modification\" value=\"" . $db->f("DATUM") . "\">\n";
echo "<input type=\"hidden\" name=\"id\" value=\"" . $db->f("DOKUMENTID") . "\">\n";
echo "<input type=\"hidden\" name=\"modify\" value=\"1\">\n";
echo "<input type=\"hidden\" name=\"delete\" value=\"0\">\n";
echo "<input type=\"submit\" value=\"" . $t->translate("No, Just Modify") . "\">\n";
# the Free Software Foundation; either version 2 or later of the GPL.
######################################################################
require "./include/prepend.php3";
page_open(array("sess" => "DocsWell_Session", "auth" => "DocsWell_Auth", "perm" => "DocsWell_Perm"));
require "./include/header.inc";
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
?>
<!-- content -->
<?php
if (!$perm->have_perm("editor") && !$perm->have_perm("admin")) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$bx->box_begin();
$bx->box_title($t->translate("Insert new language"));
$bx->box_body_begin();
// Eine neue Sprache soll in die DB geschrieben werden
if ($status == 'insert_new') {
// Eingaben ueberpruefen
if (!$sprache) {
$error_ar = $t->translate("Please enter a new language") . ". (" . __LINE__ . ")";
} else {
$db->query("SELECT * FROM SPRACHEDEF WHERE SPRACHE='{$sprache}'");
if ($db->next_record()) {
$error_ar = $t->translate("This language already exists") . ". (" . __LINE__ . ")";
} else {
$query = "INSERT INTO SPRACHEDEF (SPRACHE) VALUES ('{$sprache}')";
$db->query($query);
$neuesprache = $t->translate("Done successfully");
}
}
require "./include/header.inc";
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$db2 = new DB_DevCounter();
?>
<!-- content -->
<?php
$counter = 0;
$db->query("SELECT * from extra_perms WHERE username='******'");
if ($db->num_rows() == 0) {
$be->box_full($t->translate("Error"), $t->translate("Unknown Developer"));
} else {
$bx->box_begin();
$bx->box_title($t->translate("Compose private message"));
$bx->box_body_begin();
htmlp_form_action("pmess_send.php", "", "POST");
htmlp_form_hidden("option", "send");
htmlp_form_hidden("devname", $devname);
if (empty($auth->auth["uname"])) {
$sender = "-";
htmlp_form_hidden("sender", $sender);
echo $t->translate("Your E-Mail") . ":<BR>";
htmlp_form_hidden("pmessto", $devname);
htmlp_input_text("email", 50, 75, "");
echo "<BR>\n";
} else {
$sender = $auth->auth["uname"];
$email = "-";
htmlp_form_hidden("sender", $sender);
page_open(array("sess" => "SourceWell_Session", "auth" => "SourceWell_Auth", "perm" => "SourceWell_Perm"));
}
require "./include/header.inc";
$bx = new box("100%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$bs = new box("100%", $th_strip_frame_color, $th_strip_frame_width, $th_strip_title_bgcolor, $th_strip_title_font_color, $th_strip_title_align, $th_strip_body_bgcolor, $th_strip_body_font_color, $th_strip_body_align);
?>
<!-- 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 * FROM faq WHERE language='{$la}'");
$bx->box_begin();
$bx->box_title($t->translate("Frequently Asked Questions Administration"));
$bx->box_body_begin();
echo "<table width=100% border=0><tr><td width=88%>\n";
echo "<b>" . $t->translate("Enter a New Frequently Asked Question") . "</b>\n";
echo "<form action=\"" . $sess->url("insfaq.php") . "\" method=\"POST\">\n";
echo "</td><td width=12% align=right>\n";
// Create Button
echo "<input type=\"hidden\" name=\"create\" value=\"1\">\n";
echo "<input type=\"submit\"value=\"" . $t->translate("Insert") . "\">\n";
echo "</td></tr></form></table>\n";
$i = 1;
while ($db->next_record()) {
$i++;
$bs->box_strip($t->translate("Question") . ": " . $db->f("question"));
echo "<table width=100% border=0><tr><td width=76%>";
echo "<b>" . $t->translate("Answer") . ":</b> " . $db->f("answer");
$msg .= "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => $ltr . "%")) . "\">{$ltr}</a> | ";
}
$msg .= "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "%")) . "\">" . $t->translate("All") . "</a> | ";
$msg .= "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "")) . "\">" . $t->translate("Unknown") . "</a> ]";
$bs->box_strip($msg);
$db->query("SELECT DISTINCT solutions_contact_name,solutions_contact_email,solutions_contact_url FROM tblsolutions WHERE solutions_contact_name LIKE '{$by}' AND tblsolutions.solutions_name != 'no_name' ORDER BY solutions_contact_name ASC");
$bx->box_begin();
if ($by == "%") {
$conby = "All";
} else {
$conby = ereg_replace("%", "", $by);
}
if (empty($conby)) {
$conby = "Unknown";
}
$bx->box_title($t->translate("Contact") . ": " . $conby);
$bx->box_body_begin();
?>
<table border=0 align=center cellspacing=1 cellpadding=1 width=100%>
<?php
echo "<tr><td><b>" . $t->translate("No") . ".</b></td><td><b># " . $t->translate("Sols") . "</b></td><td><b>" . $t->translate("Name") . "</b></td><td><b>" . $t->translate("E-Mail") . "</b></td><td><b>" . $t->translate("Homepage") . "</b></td></tr>\n";
$i = 1;
while ($db->next_record()) {
$solutions_contact_name = addslashes($db->f("solutions_contact_name"));
$solutions_contact_email = $db->f("solutions_contact_email");
$solutions_contact_url = $db->f("solutions_contact_url");
$db2 = new DB_SourceLines();
$db2->query("SELECT COUNT(*) FROM tblsolutions WHERE solutions_contact_name='{$solutions_contact_name}' AND solutions_contact_email='{$solutions_contact_email}' AND solutions_contact_url='{$solutions_contact_url}'");
$db2->next_record();
if ($db2->f("COUNT(*)")) {
$num = "[" . sprintf("%03d", $db2->f("COUNT(*)")) . "]";
// Check application
$db->query("SELECT * FROM software {$where}");
// echo"<p>SELECT * FROM software $where\n";
$i = 0;
while ($db->next_record()) {
$db_appid = $db->f("appid");
$db2 = new DB_SourceWell();
$db2->query("SELECT * FROM history WHERE appid='{$db_appid}' ORDER BY creation_his DESC");
$db2_exists = $db2->next_record();
$db_modification = $db->f("modification");
$db2_creation_his = $db2->f("creation_his");
if ($db_modification != $db2_creation_his) {
$timestamp = mktimestamp($db_modification);
$title = "<b><a href=\"" . htmlentities($sess->url("appbyid.php") . $sess->add_query(array("id" => $db->f(appid)))) . "\">" . $db->f(name) . "</a> (" . $db->f(appid) . ")</b>";
$bx->box_begin();
$bx->box_title($title);
$body = "Modification date: " . timestr($timestamp) . "\n";
$timestamp = mktimestamp($db2_creation_his);
$body .= "<br>History date: " . timestr($timestamp) . "\n";
$bx->box_body($body);
switch ($action) {
case "check":
if ($db2_exists) {
$action2 = "update";
} else {
$action2 = "insert";
}
$title = "<a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("action" => $action2, "id" => $db_appid))) . "\"><img src=\"images/recycled.png\" border=0 alt=\"" . $t->translate("Update") . "\"></a>\n";
$bx->box_title($title);
break;
case "update":
@page_close();
page_open(array("sess" => "DocsWell_Session", "auth" => "DocsWell_Auth", "perm" => "DocsWell_Perm"));
}
require "./include/header.inc";
$bx = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$bs = new box("100%", $th_strip_frame_color, $th_strip_frame_width, $th_strip_title_bgcolor, $th_strip_title_font_color, $th_strip_title_align, $th_strip_body_bgcolor, $th_strip_body_font_color, $th_strip_body_align);
?>
<!-- content -->
<?php
if ($config_perm_admtype != "all" && (!isset($perm) || !$perm->have_perm($config_perm_admtype))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$bx->box_begin();
$bx->box_title($t->translate("Type Administration"));
$bx->box_body_begin();
// Insert a new Type
$bs->box_strip($t->translate("Insert Type"));
echo "<form action=\"" . $sess->url("instyp.php") . "\" method=\"POST\">\n";
echo "<table border=0 cellspacing=0 cellpadding=3 width=100%>\n";
echo "<tr><td align=right width=30%>" . $t->translate("New Type") . " (100):</td><td width=70%><input type=\"TEXT\" name=\"type\" size=40 maxlength=100>\n";
echo "<tr><td align=right>" . $t->translate("Description") . " (255):</td><td><input type=\"TEXT\" name=\"description\" size=40 maxlength=255>\n";
echo "</td></tr>\n";
echo "<tr><td> </td>\n";
echo "<td><input type=\"submit\" value=\"" . $t->translate("Insert") . "\">";
echo "</td></tr>\n";
echo "</form>\n";
echo "</table>\n";
echo "<BR>\n";
// Rename Type
