$bx->box_end(); $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"))) {
} } 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
if (is_not_set_or_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('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);
} else { $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"), ""));
# ###################################################################### 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"]);
} } 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":
# ###################################################################### 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'; require 'include/browselib.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 = 'browse'; $bx->box_begin(); $bx->box_body_begin(); $bx->box_columns_begin(2, 'top'); $bx->box_column_start('', '50%', ''); $bx->box_begin(); $bx->box_title($t->translate('Categories')); $bx->box_body_begin(); echo html_link('browse.php', array('through' => 'license'), $t->translate('License')); echo '<br>' . html_link('browse.php', array('through' => 'type'), $t->translate('Type')); echo '<br>' . html_link('browse.php', array('through' => 'steps'), $t->translate('Steps')); echo '<br>' . html_link('browse.php', array('through' => 'volume'), $t->translate('Volume')); echo '<br>' . html_link('browse.php', array('through' => 'platform'), $t->translate('Platform')); echo '<br>' . html_link('browse.php', array('through' => 'architecture'), $t->translate('Architecture')); echo '<br>' . html_link('browse.php', array('through' => 'environment'), $t->translate('Environment')); echo '<br>' . html_link('browse.php', array('through' => 'project_name'), $t->translate('Project Name')); $bx->box_body_end(); $bx->box_end(); $bx->box_column_finish();
$be->box_full($t->translate("Error"), $t->translate("Empty Project")); } $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";
$be->box_full($t->translate("Error"), $t->translate("User Deletion failed") . ":<br>{$query}"); 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, ""));