echo "<tr><td align=right width=30%>" . $t->translate("Profession") . ":</td><td width=70%>" . $t->translate($prof) . "\n";
$qualid = $db->f("qualification");
$qual = get_qualification($qualid);
echo "<tr><td align=right width=30%>" . $t->translate("Qualification") . ":</td><td width=70%>" . $t->translate($qual) . "\n";
echo "</table>\n";
$bx->box_body_end();
$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) {
mail($ml_newstoaddr, $subj, $msg, "From: {$ml_newsfromaddr}\nReply-To: {$ml_newsreplyaddr}\nX-Mailer: PHP");
echo "{$sys_name} daily newsletter sent at " . date("l dS of F Y H:i:s") . "\n";
break;
}
} else {
echo "No application at " . date("l dS of F Y H:i:s") . "\n";
}
}
switch ($period) {
case "daily":
default:
$db->query("SELECT DISTINCT extra_perms.username,auth_user.email_usr from extra_perms,auth_user where extra_perms.contact='dai' AND extra_perms.username=auth_user.username");
while ($db->next_record()) {
$u_name = $db->f("username");
$db2->query("SELECT * from extra_perms,pmessages where extra_perms.username=pmessages.pmessto AND extra_perms.username='******' AND pmessages.pmessstatus='new'");
if ($db2->num_rows()) {
echo "<BR>{$u_name}\n";
$messagetext = "DevCounter Notification of new personal messages.\n";
$messagetext .= "At " . date("l dS of F Y H:i") . " you've these new messages: \n\n\n";
while ($db2->next_record()) {
$pmesssubject = $db2->f("pmesssubject");
$pmessfrom = $db2->f("pmessfrom");
$pmessfrom = ereg_replace("mailto:", "", $pmessfrom);
$messagetext .= "{$pmesssubject} --- {$pmessfrom}\n";
echo "<BR> --- {$pmesssubject} - {$pmessfrom}";
}
$messagetitle = "[{$sys_name}] Notification of new personal messages (" . date("l dS of F Y H:i") . ")";
$messagetext .= "\n\nRead your personal messages at DevCounter (http://devcounter.berlios.de/)\n";
mail($db->f("email_usr"), $messagetitle, $messagetext, "From: {$ml_newsfromaddr}\nReply-To: no-reply@berlios.de\nX-Mailer: PHP");
}
}
$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 = $offset + 1;
while ($db->next_record()) {
if ($i % 2 != 0) {
$bgcolor = "#E0E0E0";
} else {
$bgcolor = "#FFFFFF";
}
$username = $db->f("username");
$bx->box_column("right", "", $bgcolor, $i);
$pquery["devname"] = $db->f("username");
$db2->query("SELECT * from developers,extra_perms WHERE developers.username='******'");
if ($db2->num_rows() == 0) {
$bx->box_column("center", "", $bgcolor, $username);
} else {
$bx->box_column("center", "", $bgcolor, html_link("showprofile.php", $pquery, $username));
}
if ($db->f("showname") == "yes") {
$bx->box_column("center", "", $bgcolor, $db->f("realname"));
} else {
$bx->box_column("center", "", $bgcolor, "--- % ---");
}
if ($db->f("showemail") == "yes") {
$bx->box_column("center", "", $bgcolor, html_link("mailto:" . $db->f("email_usr"), "", ereg_replace("@", " at ", htmlentities($db->f("email_usr")))));
} else {
$bx->box_column("center", "", $bgcolor, "--- % ---");
}
$bx->box_next_row_of_columns();
