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", "", "", "");