}
/* 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;
}
if ($showname == "on") {
$showname = "yes";
} else {
$showname = "no";
}
if ($showemail == "on") {
$showemail = "yes";
} else {
$showemail = "no";
}
$query = "insert into extra_perms values('{$username}','{$showname}','{$showemail}','yes','yes')";
$db->query($query);
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");
$number_of_pmessages = $db->num_rows();
