} 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";