if ($db->f("contact") == "yes") {
mail($db->f("email_usr"), "[{$sys_name}] {$pmesssubject}", "{$pmessmessage}\n---\n \nRead your personal messages at http://devcounter.berlios.de/", "From: noreply@berlios.de\nReply-To: noreply@berlios.de\nX-Mailer: PHP");
}
} 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");
}
// Check application
$db->query("SELECT * FROM software {$where}");
// echo"<p>SELECT * FROM software $where\n";
$i = 0;
while ($db->next_record()) {
$db_appid = $db->f("appid");
$db2 = new DB_SourceWell();
$db2->query("SELECT * FROM history WHERE appid='{$db_appid}' ORDER BY creation_his DESC");
$db2_exists = $db2->next_record();
$db_modification = $db->f("modification");
$db2_creation_his = $db2->f("creation_his");
if ($db_modification != $db2_creation_his) {
$timestamp = mktimestamp($db_modification);
$title = "<b><a href=\"" . htmlentities($sess->url("appbyid.php") . $sess->add_query(array("id" => $db->f(appid)))) . "\">" . $db->f(name) . "</a> (" . $db->f(appid) . ")</b>";
$bx->box_begin();
$bx->box_title($title);
$body = "Modification date: " . timestr($timestamp) . "\n";
$timestamp = mktimestamp($db2_creation_his);
$body .= "<br>History date: " . timestr($timestamp) . "\n";
$bx->box_body($body);
switch ($action) {
case "check":
if ($db2_exists) {
$action2 = "update";
} else {
$action2 = "insert";
}
$title = "<a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("action" => $action2, "id" => $db_appid))) . "\"><img src=\"images/recycled.png\" border=0 alt=\"" . $t->translate("Update") . "\"></a>\n";
$bx->box_title($title);
break;
$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
require "./include/footer.inc";
@page_close();