} else {
$username = $auth->auth["uname"];
$db->query("SELECT * FROM prog_ability_watch WHERE username='******'");
if ($db->next_record()) {
$query = "UPDATE ";
$update = 1;
} else {
$query = "INSERT INTO ";
$update = 0;
}
if (isset($action) && $action == "set") {
$counter = 0;
$query1 = $query . "prog_ability_watch SET username='******'";
while ($counter < count($ability)) {
$counter++;
$db2->query("SELECT colname FROM prog_abilities WHERE code='{$counter}'");
$db2->next_record();
$query1 .= ", " . $db2->f("colname") . "='{$ability[$counter]}'";
}
if ($update) {
$query1 .= " WHERE username='******'";
}
$db->query($query1);
$counter = 0;
$query2 = $query . "prog_language_watch SET username='******'";
while ($counter < count($plang)) {
$counter++;
$db2->query("SELECT colname FROM prog_languages WHERE code='{$counter}'");
$db2->next_record();
$query2 .= ", " . $db2->f("colname") . "='{$plang[$counter]}'";
}
$subj = "{$sys_name} daily newsletter for " . date("l dS of F Y");
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");
}
$cpassword = trim($cpassword);
$realname = trim($realname);
$email_usr = trim($email_usr);
if (empty($username) || empty($password) || empty($cpassword) || empty($email_usr)) {
// Do we have all necessary data?
$be->box_full($t->translate("Error"), $t->translate("Please enter") . " <b>" . $t->translate("Username") . "</b>, <b>" . $t->translate("Password") . "</b> " . $t->translate("and") . " <b>" . $t->translate("E-Mail") . "</b>!");
break;
}
if (strcmp($password, $cpassword)) {
// password are identical?
$be->box_full($t->translate("Error"), $t->translate("The passwords are not identical") . ". " . $t->translate("Please try again") . "!");
break;
}
/* Does the user already exist?
NOTE: This should be a transaction, but it isn't... */
$db->query("select * from auth_user where username='******'");
if ($db->nf() > 0) {
$be->box_full($t->translate("Error"), $t->translate("User") . " <B>{$username}</B> " . $t->translate("already exists") . "!<br>" . $t->translate("Please select a different Username") . ".");
break;
}
// Create a uid and insert the user...
$u_id = md5(uniqid($hash_secret));
$modification_usr = "******";
$creation_usr = "******";
$permlist = "user_pending";
$query = "insert into auth_user values('{$u_id}','{$username}','{$password}','{$realname}','{$email_usr}',{$modification_usr},{$creation_usr},'{$permlist}')";
$db->query($query);
if ($db->affected_rows() == 0) {
$be->box_full($t->translate("Error"), $t->translate("Registration of new Developer failed") . ":<br> {$query}");
break;
}
$pquery["devname"] = $db->f("username");
htmlp_link("pmess_compose.php", $pquery, $t->translate("write Developer"));
}
if ($db->f("showemail") == "yes") {
echo "<tr><td align=right width=30%>" . $t->translate("E-Mail") . ":</td><td width=70%><a href=\"mailto:" . $db->f("email_usr") . "\">" . ereg_replace("@", " at ", htmlentities($db->f("email_usr"))) . "</a>\n";
}
echo "<tr><td align=right width=30%>" . $t->translate("Developer last modified") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("modification_usr"));
echo timestr($timestamp) . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Developer created") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("creation_usr"));
echo timestr($timestamp) . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Profile last modified") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("creation"));
echo timestr($timestamp) . "</td></tr>\n";
$db2->query("SELECT devel_cnt FROM counter WHERE develid='{$develid}'");
$db2->next_record();
echo "<tr><td align=right width=30%>" . $t->translate("# of Visits") . ":</td><td width=70%>\n";
echo $db2->f("devel_cnt") . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Registration Number") . ":</td><td width=70%>\n";
echo printf("#%09d", $develid) . "</td></tr>\n";
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
$bx->box_begin();
$bx->box_title($t->translate("Professional Data"));
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=3 cellpadding=3>\n";
$profid = $db->f("profession");
$prof = get_profession($profid);
echo "<tr><td align=right width=30%>" . $t->translate("Profession") . ":</td><td width=70%>" . $t->translate($prof) . "\n";
while ($counter != $number_of_requests) {
$db->next_record();
$counter++;
if ($counter % 2 != 0) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#E0E0E0";
}
$blist->box_column("right", "", $bgcolor, $db->f("reqid"));
$pquery["reqid"] = $db->f("reqid");
$blist->box_column("center", "", $bgcolor, html_link("req_show.php", $pquery, $db->f("reqsubject")));
$timestamp = mktimestamp($db->f("reqtime"));
$blist->box_column("center", "", $bgcolor, timestr_short($timestamp));
$tasktype = $db->f("tasktype");
if ($tasktype != "other") {
$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"), ""));
require "./include/lib.inc";
$db = new DB_DevCounter();
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";
echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n";
echo "<rss version=\"0.91\">\n";
echo " <channel>\n";
echo " <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . $sys_name . " - " . $sys_title . "</description>\n";
echo " <language>en-us</language>\n";
echo " <image>\n";
echo " <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo " <url>" . $sys_url . $sys_logo_image . "</url>\n";
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n";
echo " <width>66</width>\n";
echo " <height>73</height>\n";
echo " </image>\n";
$db->query("SELECT * FROM requests ORDER BY reqtime DESC LIMIT 0,5");
while ($db->next_record()) {
echo " <item>\n";
echo " <title>" . htmlspecialchars($db->f("reqsubject"));
$timestamp = mktimestamp($db->f("reqtime"));
echo " [" . timestr_short($timestamp) . "]";
echo "</title>\n";
echo " <link>" . $sys_url . "req_show.php?reqid=" . $db->f("reqid") . "</link>\n";
echo " </item>\n";
}
echo " </channel>\n";
echo "</rss>\n";
// Developers by Programming Languages/Tools
// Developers by Programming Languages/Tools
case "prog_languages":
stats_title($t->translate("Developers listed by Programming Languages/Tools"));
$url = "0";
// No URL in function stats_display
$urlquery = "0";
// No URL query in function stats_display
$db2 = new DB_DevCounter();
$db3 = new DB_DevCounter();
$db->query("SELECT * FROM prog_languages");
while ($db->next_record()) {
stats_subtitle($t->translate($db->f("language")));
$db2->query("SELECT * FROM weightings");
while ($db2->next_record()) {
$db3->query("SELECT COUNT(*) FROM prog_language_values WHERE " . $db->f("colname") . "='" . $db2->f("weightid") . "'");
$db3->next_record();
$num = $db3->f("COUNT(*)");
stats_display($t->translate($db2->f("weighting")), $num, $url, $urlquery, $total_number_dev);
}
}
stats_end();
break;
// Developers by Nationality
// Developers by Nationality
case "nationality":
stats_title($t->translate("Developers listed by Nationality"));
$db->query("SELECT *,COUNT(*) AS nat_cnt FROM developers GROUP BY developers.nationality ORDER BY nat_cnt DESC");
while ($db->next_record()) {
stats_display(get_country($db->f("nationality")), $db->f("nat_cnt"), "", "", $total_number_dev);
}
$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));
$tasktype = $db->f("tasktype");
if ($tasktype != "other") {
$db2->query("SELECT * FROM prog_abilities WHERE translation='{$la}' AND code='{$tasktype}'");
$db2->next_record();
$tasktype = $db2->f("ability");
}
$bx->box_column("center", "", $bgcolor, $tasktype);
$category = $db->f("category");
switch ($category) {
case "member":
$bx->box_column("center", "", $bgcolor, $t->translate("new project member"));
break;
case "task":
$bx->box_column("center", "", $bgcolor, $t->translate("specific task"));
break;
case "help":
$bx->box_column("center", "", $bgcolor, $t->translate("help/assistance"));
break;
if ($db->f("contact") == "yes") {
$bx->box_begin();
$bx->box_title($t->translate("contact developer"));
$bx->box_body_begin();
htmlp_form_action("sendform.php", "", "POST");
htmlp_form_hidden("devname", $devname);
echo $t->translate("Subject:") . "<BR>";
htmlp_input_text("subject", 50, 75, "");
htmlp_form_submit("send", "");
echo "<BR>\n";
echo $t->translate("Your EMail Address:") . "<BR>";
if (empty($auth->auth["uname"])) {
htmlp_input_text("s_email", 50, 75, "");
} else {
$username = $auth->auth["uname"];
$db2->query("SELECT * from auth_user WHERE username='******'");
$db2->next_record();
htmlp_input_text("s_email", 50, 75, $db2->f("email_usr"));
}
echo "<BR>\n";
echo $t->translate("Content:") . "<BR>";
htmlp_textarea("body", 60, 30, "nowrap", 2000, "");
htmlp_form_end();
$bx->box_body_end();
$bx->box_end();
} else {
$be->box_full($t->translate("Error"), $t->translate("Developer does not allow to contact him"));
}
}
?>
<!-- end content -->
$db->query("SELECT * from prog_abilities WHERE translation='{$la}'");
$ability_amount = $db->num_rows();
$counter = 0;
while ($counter < $ability_amount) {
$counter++;
$db->next_record();
if ($counter % 2 == 1) {
echo "<tr><td width=33%>\n";
} else {
echo "<td width=33%>\n";
}
echo "<table border=0 width=100% cellpadding=3><tr><td align=right>";
echo $db->f("ability") . "\n";
echo "</td><td width=20%>";
htmlp_select("ability[" . $db->f("code") . "]");
$db2->query("SELECT * FROM weightings");
while ($db2->next_record()) {
$selected = 0;
if ($db2->f("weightid") == 0) {
$selected = 1;
}
htmlp_select_option($db2->f("weightid"), $selected, $t->translate($db2->f("weighting")));
}
htmlp_select_end();
echo "</td></tr></table>";
if ($counter % 2 == 0) {
echo "</td></tr>\n\n";
} else {
echo "</td>\n";
}
}
<h3><?php
echo $sys_name;
?>
Database Connection</h3>
<ul>
<li>I am now going to try to create a DB_<?php
echo $sys_name;
?>
database connection.<br>If an error occures, then you should look at these points and fix them before proceeding:
<ul>
<li>Have you introduced the correct database parameters (<i>Host</i>, <i>Database</i> name, <i>User</i> name and <i>Password</i>) in the include/local.inc file?
<li>Have you created the database tables and set the defaults? (you've got them in the <i>sql</i> subdirectory)
<li>Is your database running? ;-)
</ul>
<?php
$db = new DB_DevCounter();
if ($db->query("SELECT * FROM auth_user")) {
?>
<li><b><font color="green">Created a DB_<?php
echo $sys_name;
?>
database connection successfully.</font></b></li>
<?php
}
?>
</ul>
<p>[ <a href="install.php">Go back</a> ] [ <a href="install.php?action=check_session">Next</a> ]
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . $sys_name . " - " . $sys_title . "</description>\n";
echo " <language>en-us</language>\n";
echo " <image>\n";
echo " <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo " <url>" . $sys_url . $sys_logo_image . "</url>\n";
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n";
echo " <width>66</width>\n";
echo " <height>73</height>\n";
echo " </image>\n";
echo " <item>\n";
echo " <title><b>Developers:</b></title>\n";
echo " <link>http://devcounter.berlios.de/</link>\n";
echo " </item>\n";
$db->query("SELECT * FROM developers,auth_user,extra_perms WHERE developers.username=auth_user.username AND developers.username=extra_perms.username ORDER BY developers.creation DESC limit 5");
$i = 0;
while ($db->next_record()) {
echo " <item>\n";
echo " <title>" . htmlspecialchars($db->f("username"));
if ($db->f("showname") == "yes") {
echo " (" . htmlspecialchars($db->f("realname")) . ")";
}
$timestamp = mktimestamp($db->f("creation"));
echo " [" . timestr_short($timestamp) . "]";
echo "</title>\n";
echo " <link>" . $sys_url . "showprofile.php?devname=" . $db->f("username") . "</link>\n";
echo " </item>\n";
$i++;
}
echo " <item>\n";
reset($abilities);
$where = "";
while (list($name, $value) = each($abilities)) {
if ($where != "") {
$where .= " AND ";
}
$where .= "{$name}>='{$value}'";
}
$db2->query("SELECT * FROM prog_ability_values WHERE {$where}");
// echo "<p>SELECT * FROM prog_ability_values WHERE $where\n";
while ($db2->next_record()) {
$fusrnam = $db2->f("username");
// echo "<p>Match abilities: $fusrnam\n";
reset($langnam);
while (list(, $lang) = each($langnam)) {
$db3->query("SELECT {$lang} FROM prog_language_watch WHERE username='******'");
// echo "<p>SELECT $lang FROM prog_language_watch WHERE username='******'\n";
if ($db3->next_record()) {
$languages[$lang] = $db3->f($lang);
}
}
reset($languages);
$where2 = "";
while (list($name2, $value2) = each($languages)) {
if ($where2 != "") {
$where2 .= " AND ";
}
$where2 .= "{$name2}>='{$value2}'";
}
$db3->query("SELECT * FROM prog_language_values WHERE {$where2} AND username='******'");
// echo "<p>SELECT * FROM prog_language_values WHERE $where2 AND username='******'\n";
htmlp_select("nationality");
echo "\n";
select_country(999);
htmlp_select_end();
echo "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Country you currently live in") . ":</td><td width=70%>\n";
htmlp_select("actual_country");
echo "\n";
select_country(999);
htmlp_select_end();
echo "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Year of Birth") . ":</td><td width=70%>19<input type=\"TEXT\" name=\"year_of_birth\" size=3 maxlength=2></td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Gender") . ":</td><td width=70%>\n";
echo "<center><table width=80% border=0>\n";
echo "<tr>";
$db3->query("SELECT * FROM gender");
while ($db3->next_record()) {
$selected = 0;
if ($db3->f("gendid") == 1) {
$selected = 1;
}
echo "<td width=26%>";
htmlp_radio("gender", $db3->f("gendid"), $selected);
echo " " . $t->translate($db3->f("gender")) . "\n";
echo "</td>\n";
}
echo "</tr></table></center>\n";
echo "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Mother tongue") . ":</td><td width=70%>\n";
htmlp_select("mother_tongue");
echo "\n";
$db->query("SELECT * from extra_perms,auth_user WHERE auth_user.username='******' AND extra_perms.username='******'");
if ($db->num_rows() == 0) {
$be->box_full($t->translate("Error"), $t->translate("Unknown Developer"));
} else {
$db->next_record();
if ($db->f("contact") != "no") {
$pmesstime = "NOW()";
$pmesssubject = htmlentities($pmesssubject);
$pmessmessage = htmlentities($pmessmessage);
if ($sender == "-") {
$pmessfrom = "mailto:" . $email;
} else {
$pmessfrom = $sender;
}
//$pmessto = $devname;
$db2->query("INSERT pmessages SET pmesstime = {$pmesstime}, pmessto = '{$pmessto}', pmessstatus = 'new', pmessfrom = '{$username}', pmesssubject='{$pmesssubject}', pmessmessage='{$pmessmessage}'");
if ($db2->affected_rows() == 1) {
$bx->box_full($t->translate("Success"), $t->translate("Message posted"));
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");
$db->next_record();
$bx->box_begin();
$bx->box_title($t->translate("edit request"));
$bx->box_body_begin();
htmlp_form_action("req_manage.php", "", "POST");
htmlp_form_hidden("option", "edit");
htmlp_form_hidden("reqid", $reqid);
echo $t->translate("Subject") . ":<BR>";
$reqsubject = $db->f("reqsubject");
htmlp_input_text("reqsubject", 50, 75, $reqsubject);
htmlp_form_submit($t->translate("Send"), "");
echo "<BR>\n";
echo $t->translate("Related to which Project") . ":<BR>";
htmlp_select("projectname");
$devprojectname = $db->f("projectname");
$db2->query("SELECT * FROM os_projects WHERE username='******'");
while ($db2->next_record()) {
if ($devprojectname == $db2->f("projectname")) {
htmlp_select_option($db2->f("projectname"), 1, $db2->f("projectname"));
} else {
htmlp_select_option($db2->f("projectname"), 0, $db2->f("projectname"));
}
}
if ($devprojectname == "none") {
htmlp_select_option("none", 1, $t->translate("none"));
} else {
htmlp_select_option("none", 0, $t->translate("none"));
}
htmlp_select_end();
echo "<BR>\n";
echo $t->translate("Which type") . ":<BR>";
$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("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, "--- % ---");
}
require "./include/header.inc";
$bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align);
$be = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
$db2 = new DB_DevCounter();
$db3 = new DB_DevCounter();
?>
<!-- content -->
<?php
if ($config_perm_watch != "all" && (!isset($perm) || !$perm->have_perm($config_perm_watch))) {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
} else {
$username = $auth->auth["uname"];
htmlp_form_action("watchset.php", array(), "POST");
echo "\n";
$db3->query("SELECT * FROM prog_ability_watch WHERE username='******'");
if ($db3->next_record()) {
$exists = 1;
} else {
$exists = 0;
}
$bx->box_begin();
$bx->box_title($t->translate("Set your Developers Watch"));
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=center><B>" . $t->translate("Which programming experiences you like to watch?") . "</B></td></tr><tr><td>\n";
echo "<center><table border=0>\n";
$db->query("SELECT * from prog_abilities WHERE translation='{$la}'");
$count = 0;
while ($db->next_record()) {
$count++;
echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n";
echo "<rss version=\"0.91\">\n";
echo " <channel>\n";
echo " <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . $sys_name . " - " . $sys_title . "</description>\n";
echo " <language>en-us</language>\n";
echo " <image>\n";
echo " <title>" . htmlspecialchars($sys_name) . "</title>\n";
echo " <url>" . $sys_url . $sys_logo_image . "</url>\n";
echo " <link>" . $sys_url . "</link>\n";
echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n";
echo " <width>66</width>\n";
echo " <height>73</height>\n";
echo " </image>\n";
$db->query("SELECT * FROM developers,auth_user,extra_perms WHERE developers.username=auth_user.username AND developers.username=extra_perms.username ORDER BY developers.creation DESC limit 5");
$i = 0;
while ($db->next_record()) {
echo " <item>\n";
echo " <title>" . htmlspecialchars($db->f("username"));
if ($db->f("showname") == "yes") {
echo " (" . htmlspecialchars($db->f("realname")) . ")";
}
$timestamp = mktimestamp($db->f("creation"));
echo " [" . timestr_short($timestamp) . "]";
echo "</title>\n";
echo " <link>" . $sys_url . "showprofile.php?devname=" . $db->f("username") . "</link>\n";
echo " </item>\n";
$i++;
}
echo " </channel>\n";
