$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"; } $bx->box_column("right", "", $bgcolor, $db->f("reqid")); $pquery["reqid"] = $db->f("reqid"); $bx->box_column("center", "", $bgcolor, html_link("req_show.php", $pquery, $db->f("reqsubject"))); $bx->box_column("center", "", $bgcolor, $db->f("username")); $timestamp = mktimestamp($db->f("reqtime")); $bx->box_column("center", "", $bgcolor, timestr_short($timestamp));
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"; $blist->box_column("center", "", $bgcolor, "<B>" . $t->translate($pmessstatus) . "</B>"); break; case "unread": $bgcolor = "lightblue"; $blist->box_column("center", "", $bgcolor, "<B>" . $t->translate($pmessstatus) . "</B>"); break; case "read":