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();