$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++;
$ability_code = $db->f("code");
$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;
case "test":
$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>";
htmlp_select("category");
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
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);
}
stats_end();
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";
while ($db3->next_record()) {
$count++;
