$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> &nbsp; ");
     $reqdev = $db->f("username");
     $pquery["devname"] = $db->f("username");
     $bx->box_column("left", "70%", $bgcolor, html_link("showprofile.php", $pquery, $reqdev));
     $bx->box_next_row_of_columns();
     $bx->box_column("left", "", $bgcolor, "<B>" . $t->translate("Project") . ":</B> &nbsp; ");
     $projectname = $db->f("projectname");
     if ($projectname != "none") {
         $db2->query("SELECT * FROM os_projects WHERE username='******' AND projectname='{$projectname}'");
         $db2->next_record();
         if (ereg("://", $db2->f("url"))) {
             $bx->box_column("left", "", $bgcolor, "<A HREF=\"" . $db2->f("url") . "\">" . $db2->f("projectname") . "</A><BR> &nbsp; (" . $db2->f("comment") . ")");
         } else {
 $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();
     $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> &nbsp; ");
     $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> &nbsp; ");
     $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>&nbsp;</b>", "");
     $bgcolor = "#F0F0F0";
     $bx->box_next_row_of_columns();
     $pmessmessage = $db->f("pmessmessage");
            htmlp_form_hidden("oldpname", $db->f("projectname"));
            htmlp_form_hidden("option", "delete");
            $bgcolor = "gold";
            $bx->box_column("center", "", $bgcolor, html_form_submit($t->translate("Delete"), ""));
            htmlp_form_end();
            $bx->box_next_row_of_columns();
            $bgcolor = "#FFFFFF";
        }
        $bgcolor = "gold";
        htmlp_form_action("projects.php", array(), "POST");
        htmlp_form_hidden("option", "add");
        $bx->box_column("right", "", $bgcolor, "--");
        $bx->box_column("center", "", $bgcolor, html_input_text("projectname", 25, 64, ""));
        $bx->box_column("center", "", $bgcolor, html_input_text("projecturl", 35, 255, ""));
        $bx->box_column("center", "", $bgcolor, html_input_text("pcomment", 35, 400, ""));
        $bx->box_colspan(2, "center", $bgcolor, html_form_submit($t->translate("Add Project"), ""));
        $bx->box_columns_end();
        htmlp_form_end();
    } else {
        $be->box_begin();
        $be->box_title($t->translate("Error"));
        $be->box_body_begin();
        htmlp_link("addproj.php", "", $t->translate("Enter your projects here"));
        $be->box_body_end();
        $be->box_end();
    }
}
?>
<!-- end content -->

<?php 
$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>');
$bx->box_column('left', '50%', '', timestr(mktimestamp($db->f('creation_usr'))));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Last Modification') . ':</b>');
$bx->box_column('left', '50%', '', timestr(mktimestamp($db->f('modification_usr'))));
$bx->box_next_row_of_columns();
$bx->box_column('right', '50%', '', '<b>' . $t->translate('Permission') . ':</b>');
$bx->box_column('left', '50%', '', $db->f('perms'));
$bx->box_next_row_of_columns();
$bx->box_colspan(2, 'center', '', html_form_submit($t->translate('Change'), 'u_edit'));
$bx->box_columns_end();
htmlp_form_hidden('u_id', $db->f('user_id'));
htmlp_form_end();
$bx->box_body_end();
$bx->box_end();
end_content();
require 'include/footer.inc';
@page_close();
     htmlp_form_hidden("colname", $db->f("colname"));
     htmlp_form_hidden("option", "lang_delete");
     $bgcolor = "gold";
     $bx->box_column("center", "", $bgcolor, html_form_submit($t->translate("Delete"), ""));
     htmlp_form_end();
     $bx->box_next_row_of_columns();
     $bgcolor = "#FFFFFF";
 }
 $bgcolor = "gold";
 htmlp_form_action("adm_langs_tools.php", array(), "POST");
 htmlp_form_hidden("option", "lang_add");
 $bx->box_column("right", "", $bgcolor, "--");
 //$bx->box_column("right","",$bgcolor,html_input_text("code", 5, 64, ""));
 $bx->box_column("center", "", $bgcolor, html_input_text("language", 30, 64, ""));
 $bx->box_column("center", "", $bgcolor, html_input_text("colname", 25, 64, ""));
 $bx->box_colspan(2, "center", $bgcolor, html_form_submit($t->translate("Add ProgLanguage"), ""));
 $bx->box_columns_end();
 htmlp_form_end();
 $bx->box_body_end();
 $bx->box_end();
 $counter = 0;
 $db->query("SELECT COUNT(*) FROM prog_abilities");
 $db->next_record();
 $abil_num = $db->f("COUNT(*)");
 $db->query("SELECT * from prog_abilities");
 $bx->box_begin();
 $bx->box_title($t->translate("Programming Abilities"));
 $bx->box_body_begin();
 $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("ProgAbilityName") . "</b>");
            $db2->query("SELECT * FROM prog_abilities WHERE translation='{$la}' AND code='{$tasktype}'");
            $db2->next_record();
            $tasktype = $db2->f("ability");
        }
        $blist->box_column("center", "", $bgcolor, $tasktype);
        $reqlang = $db->f("language");
        $blist->box_column("center", "", $bgcolor, get_lang($reqlang));
        htmlp_form_action("req_edit.php", array(), "POST");
        htmlp_form_hidden("reqid", $db->f("reqid"));
        $blist->box_column("center", "", $bgcolor, html_form_submit($t->translate("Edit"), ""));
        htmlp_form_end();
        htmlp_form_action("req_manage.php", array(), "POST");
        htmlp_form_hidden("reqid", $db->f("reqid"));
        htmlp_form_hidden("option", "delete");
        $bgcolor = "gold";
        $blist->box_column("center", "", $bgcolor, html_form_submit($t->translate("Delete"), ""));
        htmlp_form_end();
        $blist->box_next_row_of_columns();
        $bgcolor = "gold";
    }
    $blist->box_colspan(7, "center", $bgcolor, html_link("req_compose.php", "", $t->translate("Create a new Request"), ""));
    $blist->box_columns_end();
    $blist->box_body_end();
    $blist->box_end();
}
?>
<!-- end content -->

<?php 
require "./include/footer.inc";
@page_close();