if ($db->num_rows() > 0) {
$nquery["offset"] = $new_offset;
$nquery["limit"] = $limit;
$msg .= " " . html_link("req_show.php", $nquery, $t->translate("next page")) . " > ";
} else {
$msg .= " " . $t->translate("next page") . " > ";
}
$msg .= "]";
$bs->box_strip($msg);
$db->query("SELECT * FROM requests ORDER BY reqtime DESC LIMIT {$offset},{$limit}");
$number_of_requests = $db->num_rows();
$counter = 0;
$bx->box_begin();
$bx->box_body_begin();
$bx->box_columns_begin(6);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$bx->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Subject") . "</b>");
$bx->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Developer") . "</b>");
$bx->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Time") . "</b>");
$bx->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Task") . "</b>");
$bx->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Type") . "</b>");
$bx->box_column("center", "15%", $th_strip_title_bgcolor, "<b>" . $t->translate("Language") . "</b>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_requests) {
$db->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
$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'));
}
}
}
$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'));
}
}
}
$bx->box_begin();
$bx->box_title($t->translate("Computer Experience"));
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=0 cellpadding=3>\n";
$number_of_projects = $db->f("number_of_projects");
echo "<tr><td align=left>" . $t->translate("Number of Free Software/Open Source Projects") . ": {$number_of_projects}\n";
echo "<P>";
$db2->query("SELECT * FROM os_projects WHERE username='******'");
$number_of_projects = $db2->num_rows();
if ($number_of_projects > 0) {
$counter = 0;
$db->query("SELECT * from os_projects ");
$bx->box_begin();
$bx->box_body_begin();
$bx->box_columns_begin(3);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Project") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Comment") . "</b>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_projects) {
$db2->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
}
$bx->box_column("right", "", $bgcolor, $counter);
if (ereg("://", $db2->f("url"))) {
$bx->box_column("center", "", $bgcolor, "<A HREF=\"" . $db2->f("url") . "\">" . $db2->f("projectname") . "</A>");
$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();
$pmesssubject = $db->f("pmesssubject");
//$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><FONT SIZE=+2>" . $pmesssubject . "</FONT></b>", "");
$bgcolor = "#FFFFFF";
$bx->box_next_row_of_columns();
$bx->box_column("left", "30%", $bgcolor, "<B>" . $t->translate("Sender") . ":</B> ");
$pmessfrom = $db->f("pmessfrom");
$pmessfrom = ereg_replace("mailto:", "", $pmessfrom);
$bx->box_column("left", "70%", $bgcolor, $pmessfrom);
$bx->box_next_row_of_columns();
$bx->box_column("left", "30%", $bgcolor, "<B>" . $t->translate("Time") . ":</B> ");
$timestamp = mktimestamp($db->f("pmesstime"));
$bx->box_column("left", "70%", $bgcolor, timestr_short($timestamp));
$bx->box_next_row_of_columns();
$bx->box_colspan(2, "center", $bgcolor, "<b> </b>", "");
$bgcolor = "#F0F0F0";
$bx->box_next_row_of_columns();
$pmessmessage = $db->f("pmessmessage");
$bx->box_colspan(2, "left", $bgcolor, "<B>" . $t->translate("Content") . ":</B> <BR>\n" . "<PRE>" . $pmessmessage . "</PRE>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
$reqmessage = htmlentities($reqmessage);
$db->query("INSERT requests SET username = '******', language = '{$reqlang}', reqtime = {$reqtime}, projectname = '{$projectname}', tasktype='{$tasktype}', category='{$category}', reqsubject='{$reqsubject}', reqmessage='{$reqmessage}'");
if ($db->affected_rows() == 1) {
$bx->box_full($t->translate("Success"), $t->translate("Request posted"));
} else {
$bx->box_full($t->translate("Error"), $t->translate("Request wasn't posted"));
}
break;
}
$db->query("SELECT * FROM requests WHERE username='******' ORDER BY reqtime DESC");
$number_of_requests = $db->num_rows();
$counter = 0;
$blist->box_begin();
$blist->box_body_begin();
$blist->box_columns_begin(5);
$blist->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Subject") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Time") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Task") . "</b>");
$blist->box_column("center", "15%", $th_strip_title_bgcolor, "<b>" . $t->translate("Language") . "</b>");
$blist->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . $t->translate("-") . "</b>");
$blist->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . $t->translate("-") . "</b>");
$blist->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_requests) {
$db->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
$username = $auth->auth["uname"];
$db->query("SELECT * from developers WHERE username='******'");
$db->next_record();
$number_of_projects = $db->f("number_of_projects");
if ($number_of_projects <= 0) {
$number_of_projects = 6;
}
$counter = 0;
htmlp_form_action("addproj2db.php", "", "POST");
htmlp_form_hidden("number_of_projects", $number_of_projects);
//$bs->box_strip($msg);
$bx->box_begin();
$bx->box_title($t->translate("Please enter your Project Data"));
$bx->box_body_begin();
$bx->box_columns_begin(4);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Projectname") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("ProjectURL") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Comment") . "</b>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_projects) {
$counter++;
$bx->box_column("right", "", $bgcolor, $counter);
$bx->box_column("center", "", $bgcolor, html_input_text("projectname[{$counter}]", 25, 64, ""));
$bx->box_column("center", "", $bgcolor, html_input_text("projecturl[{$counter}]", 35, 255, ""));
$bx->box_column("center", "", $bgcolor, html_input_text("pcomment[{$counter}]", 42, 400, ""));
$bx->box_next_row_of_columns();
}
$bx->box_column("right", "", $bgcolor, html_form_submit($t->translate("Send"), ""));
$bx->box_next_row_of_columns();
######################################################################
require "include/prepend.php3";
page_open(array("sess" => "SourceAgency_Session", "auth" => "SourceAgency_Auth", "perm" => "SourceAgency_Perm"));
require "include/header.inc";
require "include/personallib.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);
start_content();
$page = "personal";
if ($perm->have_perm("devel_pending") || $perm->have_perm("sponsor_pending")) {
$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);
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$bx->box_begin();
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column("left", "60%", "", $t->translate('Hi') . ', <b>' . $auth->auth["uname"] . '</b>.<br>' . $t->translate('This is your personal page') . '.<br>' . $t->translate("Here you will find all the " . 'information related to you') . '.');
$bx->box_column_start("right", "40%", "");
personal_ratings_short($auth->auth["uname"]);
$bx->box_column_finish();
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
$bx->box_begin();
$bx->box_body_begin();
$bx->box_columns_begin(3, 'top');
$bx->box_column_start("center", "34%", "");
personal_my_projects($auth->auth["uname"]);
$bx->box_column_finish();
$bx->box_column_start("center", "33%", "");
personal_monitored_projects($auth->auth["uname"]);
$bx->box_column_finish();
$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('type' => $type, 'by' => $ltr . '%')) . "\">" . ($ltr . '%' == $by ? "<font color=\"red\">{$ltr}</font>" : "{$ltr}") . '</a> | ';
}
$msg .= "<a href=\"" . $sess->self_url() . $sess->add_query(array("type" => $type, "by" => "%")) . "\">" . ($by == "%" ? "<font color=\"red\">" . $t->translate("All") . "</font>" : $t->translate("All")) . "</a> ]";
$where = ($type == 'devel' || $type == 'sponsor' ? "perms LIKE '%{$type}%' AND " : '') . "username LIKE '{$by}'";
$bs->box_strip($msg);
$db->query("SELECT * FROM auth_user WHERE {$where} ORDER BY username ASC");
$bx->box_begin();
$bx->box_title($t->translate('Users') . ': ' . $t->translate($type));
$bx->box_body_begin();
$bx->box_columns_begin(5);
$bx->box_column('right', '5%', '', '<b>' . $t->translate('No.') . '</b>');
$bx->box_column('center', '25%', '', '<b># ' . $t->translate('Projects') . '</b>');
$bx->box_column('center', '25%', '', '<b>' . $t->translate('Username') . '</b>');
$bx->box_column('center', '25%', '', '<b>' . $t->translate('Realname') . '</b>');
$bx->box_column('center', '25%', '', '<b>' . $t->translate('E-Mail') . '</b>');
$bx->box_next_row_of_columns();
$i = 1;
$colors = array(0 => '#FFFFFF', 1 => '#DFDFDF');
while ($db->next_record()) {
$bgcolor = $colors[$i % 2];
$db2 = new DB_SourceAgency();
$db2->query("SELECT COUNT(*) FROM description " . "WHERE description_user='******' AND status>'0'");
$db2->next_record();
$num = '[' . sprintf('%03d', $db2->f("COUNT(*)")) . ']';
$bx->box_column('right', '', $bgcolor, $i);
$bx->box_column('center', '', $bgcolor, $num);
}
$db->query("SELECT * from os_projects where username='******'");
$number_of_projects = $db->num_rows();
$db->query("UPDATE developers SET number_of_projects='{$number_of_projects}' WHERE username='******'");
break;
}
$db->query("SELECT * FROM developers WHERE username='******'");
$db->next_record();
$number_of_projects = $db->f("number_of_projects");
$db->query("SELECT COUNT(*) FROM os_projects WHERE username='******'");
$db->next_record();
$projects_entered = $db->f("COUNT(*)");
if ($number_of_projects <= $projects_entered) {
$db->query("SELECT * from os_projects WHERE username='******'");
$bx->box_columns_begin(6);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Projectname") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("ProjectURL") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Comment") . "</b>");
$bx->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . " " . "</b>");
$bx->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . " " . "</b>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_projects) {
$db->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
}
} else {
$bx->box_full($t->translate("Error"), $t->translate("Message wasn't posted"));
}
} else {
$be->box_full($t->translate("Error"), $t->translate("Developer does not allow to contact him"));
}
}
break;
}
$db->query("SELECT * FROM pmessages WHERE pmessto='{$username}' ORDER BY pmesstime DESC");
$number_of_pmessages = $db->num_rows();
$counter = 0;
$blist->box_begin();
$blist->box_body_begin();
$blist->box_columns_begin(5);
$blist->box_column("center", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("Status") . "</b>");
$blist->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Subject") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Sender") . "</b>");
$blist->box_column("center", "20%", $th_strip_title_bgcolor, "<b>" . $t->translate("Time") . "</b>");
$blist->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . $t->translate("-") . "</b>");
$blist->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . $t->translate("-") . "</b>");
$blist->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $number_of_pmessages) {
$db->next_record();
$counter++;
$pmessstatus = $db->f("pmessstatus");
switch ($pmessstatus) {
case "new":
$bgcolor = "blue";
} 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();
htmlp_form_action();
$bx->box_columns_begin();
$db->query("SELECT * FROM auth_user WHERE username='******'uname'] . "'");
$db->next_record();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Username') . ':</b>');
$bx->box_column('left', '50%', '', html_input_text('username', 20, 32, $db->f('username')));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Password') . ':</b>');
$bx->box_column('left', '50%', '', html_input_password('password', 20, 32, $db->f('password')));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Confirm Password') . ':</b>');
$bx->box_column('left', '50%', '', html_input_password('cpassword', 20, 32, $db->f('password')));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Realname') . ':</b>');
$bx->box_column('left', '50%', '', html_input_text('realname', 20, 64, $db->f('realname')));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('E-mail') . ':</b>');
$bx->box_column('left', '50%', '', html_input_text('email_usr', 20, 128, $db->f('email_usr')));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Creation') . ':</b>');
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_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();
$bx->box_columns_begin(2);
$bx->box_column('left', '88%', '', $t->translate('Enter a New Frequently Asked Question'));
$bx->box_column('right', '12%', '', html_form_action('insfaq.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('Question') . ': ' . $db->f('question'));
$bx->box_body_begin();
$bx->box_columns_begin(2);
$bx->box_column('left', '76%', '', $db->f('answer'));
$bx->box_column('right', '12%', '', html_form_action('insfaq.php') . html_form_hidden('modify', 1) . html_form_hidden('delete', 0) . html_form_hidden('faqid', $db->f('faqid')) . html_form_submit($t->translate('Change'), 'Change') . html_form_end());
$bx->box_column('right', '12%', '', html_form_action('insfaq.php') . html_form_hidden('modify', 0) . html_form_hidden('delete', 1) . html_form_hidden('faqid', $db->f('faqid')) . html_form_submit($t->translate('Delete'), 'Delete') . html_form_end());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
echo $t->translate("ProgLanguage removed") . "\n";
$bx->box_body_end();
$bx->box_end();
}
break;
}
$db->query("SELECT COUNT(*) FROM prog_languages");
$db->next_record();
$lang_num = $db->f("COUNT(*)");
$db->query("SELECT * from prog_languages");
$bx->box_begin();
$bx->box_title($t->translate("Programming Languages"));
$bx->box_body_begin();
$counter = 0;
$bx->box_columns_begin(5);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("Code") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("ProgLanguageName") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("ColumnName") . "</b>");
//$bx->box_column("center","25%", $th_strip_title_bgcolor,"<b>".$t->translate("Language")."</b>");
$bx->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . " " . "</b>");
$bx->box_column("center", "10%", $th_strip_title_bgcolor, "<b>" . " " . "</b>");
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
while ($counter != $lang_num) {
$db->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
}
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());
$bx->box_columns_end();
$bx->box_body_end();
$bx->box_end();
$db2->next_record();
// echo "-".$i."-";
$query = $query . " AND prog_ability_values." . $db2->f("colname") . ">='{$ability[$i]}'";
}
}
$query = $query . " ORDER BY extra_perms.username ASC";
// echo "<p>".$query."\n";
$db->query($query);
$bx->box_begin();
$bx->box_title($t->translate("Search Results"));
$bx->box_body_begin();
if ($db->num_rows() == 0) {
echo $t->translate("No Results") . "\n";
} else {
$bx->box_columns_begin(4);
$bx->box_column("right", "5%", $th_strip_title_bgcolor, "<b>" . $t->translate("No.") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Username") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("Realname") . "</b>");
$bx->box_column("center", "25%", $th_strip_title_bgcolor, "<b>" . $t->translate("E-Mail") . "</b>");
$bx->box_next_row_of_columns();
$i = 1;
while ($db->next_record()) {
if ($counter % 2 != 1) {
$bgcolor = $th_box_body_bgcolor;
} else {
$bgcolor = $th_box_body_bgcolor2;
}
$counter++;
$bx->box_column("right", "", $bgcolor, $i);
$pquery["devname"] = $db->f("username");
$bx->box_column("center", "", $bgcolor, html_link("showprofile.php", $pquery, $db->f("username")));
}
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)) {
// It's already in our database
// but no rename and no deletion and no new url... ->error
$be->box_full($t->translate('Error'), $t->translate('That license already exists!'));
break;
}
$bx->box_full($t->translate("User Deletion"), $t->translate("User") . " <b>{$username}</b> " . $t->translate("has been deleted"));
break;
default:
break;
}
}
/* Output user administration forms, including all updated
information, if we come here after a submission...
*/
$bx->box_begin();
$bx->box_title($t->translate("User Administration"));
$bx->box_body_begin();
$bx->box_columns_begin(8);
$bx->box_column("center", "", "", $t->translate("Username"));
$bx->box_column("center", "", "", $t->translate("Password"));
$bx->box_column("center", "", "", $t->translate("Realname"));
$bx->box_column("center", "", "", $t->translate("E-Mail"));
$bx->box_column("center", "", "", $t->translate("Modification"));
$bx->box_column("center", "", "", $t->translate("Creation"));
$bx->box_column("center", "", "", $t->translate("Permission"));
$bx->box_column("center", "", "", $t->translate("Action"));
$bx->box_next_row_of_columns();
// Create a new user
htmlp_form_action("PHP_SELF", array(), "POST");
$bx->box_column("center", "", "", html_input_text("username", 12, 32, ""));
$bx->box_column("center", "", "", html_input_password("password", 12, 32, ""));
$bx->box_column("center", "", "", html_input_text("realname", 12, 32, ""));
$bx->box_column("center", "", "", html_input_text("email_usr", 12, 32, ""));
$bx->box_column("center", "", "", "");
