require "include/sponsoringlib.inc";
$bx = new box("100%", $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);
start_content();
$page = "sponsoring_accepted";
if (check_proid($proid)) {
top_bar($proid, $page);
$db->query("SELECT creation FROM sponsoring WHERE proid='{$proid}' " . "AND sponsor='{$sponsor}'");
$db->next_record();
$creation = $db->f("creation");
$db->query("UPDATE sponsoring SET status='A',creation='{$creation}' " . "WHERE proid='{$proid}' AND sponsor='{$sponsor}'");
if ($db->affected_rows()) {
print $t->translate('Sponsoring involvement by') . " <b>{$sponsor}</b> " . $t->translate('has been accepted') . ".<p>\n";
} else {
print $t->translate('There has been a database error') . ".<p>\n";
}
htmlp_link("sponsoring.php", array("proid" => $proid), $t->translate("Back to the Sponsoring Involvement Page"));
// Send mail to the ones that monitor this project
include "monitorlib.inc";
include "config.inc";
monitor_mail($proid, "sponsoring", $t->translate('Sponsoring involvement accepted for project') . " {$proid}", $t->translate('An event has happened') . ".");
// mail new sponsor that he has been accepted
$db->query("SELECT email_usr FROM auth_user WHERE username='******'");
$db->next_record();
$message = "\n" . $t->translate("Hi") . ",{$sponsor}\n\n" . $t->translate("Your sponsoring involvement for project") . " {$proid} " . $t->translate("has been accepted") . ".\n\n";
mail($db->f("email_usr"), "[" . $GLOBALS["sys_name"] . "] " . $t->translate("Sponsoring involvement accepted"), $message, "From: " . $GLOBALS["ml_fromaddr"] . "\nReply-To: " . $GLOBALS["ml_replyaddr"] . "\nX-Mailer: PHP");
// Insert into history
$db->query("INSERT history SET proid='{$proid}', history_user='******', type='sponsoring', " . "action='Sponsor {$sponsor} accepted as sponsor'");
}
end_content();
require "include/footer.inc";
@page_close();
print_country($actual_country);
echo "<tr><td align=right valign=top width=30%>" . $t->translate("Mother tongue") . ":</td><td width=70%>\n";
$mother_tongue = $db->f("mother_tongue");
print_lang($mother_tongue);
echo "<tr><td align=right valign=top width=30%>" . $t->translate("Other languages") . ":</td><td width=70%>\n";
$other_lang_1 = $db->f("other_lang_1");
echo "1. ";
print_lang($other_lang_1);
$other_lang_2 = $db->f("other_lang_2");
echo "<BR>2. ";
print_lang($other_lang_2);
echo "</td></tr>\n";
if ($db->f("contact") != "no") {
echo "<tr><td align=right width=30%>" . $t->translate("Contact") . ":</td><td width=70%>";
$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();
if ($db->num_rows() == 0) {
$bx->box_begin();
$bx->box_title($t->translate("Developer") . ": " . $username);
$bx->box_body_begin();
htmlp_link("questionaire.php", "", $t->translate("Please enter your Profile"));
$bx->box_body_end();
$bx->box_end();
} else {
$db->next_record();
$number_of_projects = $db->f("number_of_projects");
$db->query("SELECT * from os_projects WHERE username='******'");
if ($db->num_rows() == 0 && $number_of_projects > 0) {
$bx->box_begin();
$bx->box_title($t->translate("Developer") . ": " . $username);
$bx->box_body_begin();
htmlp_link("addproj.php", "", $t->translate("Please enter your Project Data"));
$bx->box_body_end();
$bx->box_end();
}
}
echo " ";
echo "</TD><TD WIDTH=\"250\" VALIGN=\"top\">";
require "./include/Box-Newest-Requests.inc";
require "./include/Box-Newest-Developers.inc";
require "./include/Box-Newest-PMessages.inc";
echo "</TD></TR>\n";
echo "</TABLE>\n";
}
}
?>
<!-- end content -->
$quorum = show_decision_proposals($proid);
break;
case '4':
$quorum = show_decision_referees($proid);
break;
case '5':
echo '<p>';
global $g_step_text;
// NOI18N: 'Decision on step 5 (follow-up)'
htmlp_link('step5_sponsor.php', array('proid' => $proid), $t->translate('Decision on step 5') . ' (' . $g_step_text[5] . ')');
break;
case '6':
echo '<p>';
global $g_step_text;
// NOI18N: 'Decision on step 6 (rating)'
htmlp_link('step6_edit.php', array('proid' => $proid), $t->translate('Decision on step 6') . ' (' . $g_step_text[6] . ')');
break;
default:
lib_die('Error in decisions.php: given project status ' . 'is not possible');
}
}
if ($quorum || is_set_and_not_empty($Yes)) {
if ($No || is_not_set_or_empty($Yes)) {
are_you_sure_message($proid);
} else {
switch ($project_status) {
case '1':
$what = 'consultant';
$table = 'consultants';
break;
case '2':
$bgcolor = "gold";
$bx->box_column("center", "", $bgcolor, html_form_submit($t->translate("Delete"), ""));
htmlp_form_end();
$bx->box_next_row_of_columns();
$bgcolor = "#FFFFFF";
}
$bgcolor = "gold";
htmlp_form_action("projects.php", array(), "POST");
htmlp_form_hidden("option", "add");
$bx->box_column("right", "", $bgcolor, "--");
$bx->box_column("center", "", $bgcolor, html_input_text("projectname", 25, 64, ""));
$bx->box_column("center", "", $bgcolor, html_input_text("projecturl", 35, 255, ""));
$bx->box_column("center", "", $bgcolor, html_input_text("pcomment", 35, 400, ""));
$bx->box_colspan(2, "center", $bgcolor, html_form_submit($t->translate("Add Project"), ""));
$bx->box_columns_end();
htmlp_form_end();
} else {
$be->box_begin();
$be->box_title($t->translate("Error"));
$be->box_body_begin();
htmlp_link("addproj.php", "", $t->translate("Enter your projects here"));
$be->box_body_end();
$be->box_end();
}
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
$be->box_full($t->translate("Error"), $t->translate("Database Access failed"));
} else {
if ($number_of_projects > 0) {
$bx->box_begin();
$bx->box_title($t->translate("The Projects"));
$bx->box_body_begin();
echo "\n<P>";
htmlp_link("./addproj.php", "", $t->translate("Please enter your Project Data"));
echo "\n<P>";
$bx->box_body_end();
$bx->box_end();
} else {
$bx->box_begin();
$bx->box_title($t->translate("Thank you"));
$bx->box_body_begin();
echo "\n<P>";
echo $t->translate("Thank you for entering your Profile");
echo "\n<BR>";
htmlp_link("./index.php", "", $t->translate("Please proceed with the main page"));
echo "\n<P>";
$bx->box_body_end();
$bx->box_end();
}
}
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
echo "</td></tr>\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=center>";
echo "<B><FONT SIZE=+1>" . $t->translate("Projects") . "</FONT></B><BR>";
$db->query("SELECT * from os_projects WHERE username='******'");
if ($db->num_rows() == 0) {
htmlp_link("addproj.php", "", $t->translate("Manage your Project List"));
} else {
htmlp_link("projects.php", "", $t->translate("Manage your Project List"));
}
echo "</td></tr>\n";
echo "</TABLE>";
$bx->box_body_end();
$bx->box_body_begin();
echo "<table border=0 width=100% align=center cellspacing=0 cellpadding=3>\n";
echo "<tr><td align=center><B><B><FONT SIZE=+1>" . $t->translate("Which of these programming expirience do you have?") . "</FONT></B></td></tr><tr><td>\n";
echo "<center><table width=90% border=0>\n";
$db2->query("select * from prog_ability_values WHERE username='******'");
$db2->next_record();
$db->query("SELECT * from prog_abilities WHERE translation='{$la}'");
$ability_amount = $db->num_rows();
$counter = 0;
while ($counter < $ability_amount) {
$counter++;
