where('id', $inv['id'])->update(['valid' => \App\Models\Invite::VALID_NO]); stderr(nexus_trans('nexus.invalid_argument'), nexus_trans('invite.invalid_inviter')); exit(); } $ip = getip(); $res = sql_query("SELECT username FROM users WHERE id = $inviter") or sqlerr(__FILE__, __LINE__); $arr = mysql_fetch_assoc($res); $invusername = $arr['username']; } if (!mkglobal("wantusername:wantpassword:email")) { die(); } if ($isPreRegisterEmailAndUsername && $type == 'invite' && !empty($inv["pre_register_username"]) && !empty($inv["pre_register_email"])) { $wantusername = $inv["pre_register_username"]; $email = $inv["pre_register_email"]; } $email = htmlspecialchars(trim($email)); $email = safe_email($email); if (!check_email($email)) bark($lang_takesignup['std_invalid_email_address']); if(EmailBanned($email)) bark($lang_takesignup['std_email_address_banned']); if(!EmailAllowed($email)) bark($lang_takesignup['std_wrong_email_address_domains'].allowedemails()); $country = $_POST["country"]; int_check($country); if ($showschool == 'yes'){ $school = $_POST["school"]; int_check($school); } $gender = htmlspecialchars(trim($_POST["gender"])); $allowed_genders = array("Male","Female","male","female"); if (!in_array($gender, $allowed_genders, true)) bark($lang_takesignup['std_invalid_gender']); if (empty($wantusername) || empty($wantpassword) || empty($email) || empty($country) || empty($gender)) bark($lang_takesignup['std_blank_field']); if (strlen($wantusername) > 12) bark($lang_takesignup['std_username_too_long']); //if ($wantpassword != $passagain) // bark($lang_takesignup['std_passwords_unmatched']); //if (strlen($wantpassword) < 6) // bark($lang_takesignup['std_password_too_short']); // //if (strlen($wantpassword) > 40) // bark($lang_takesignup['std_password_too_long']); // //if ($wantpassword == $wantusername) // bark($lang_takesignup['std_password_equals_username']); if (!validemail($email)) bark($lang_takesignup['std_wrong_email_address_format']); if (!validusername($wantusername)) bark($lang_takesignup['std_invalid_username']); // make sure user agrees to everything... if ($_POST["rulesverify"] != "yes" || $_POST["faqverify"] != "yes" || $_POST["ageverify"] != "yes") stderr($lang_takesignup['std_signup_failed'], $lang_takesignup['std_unqualified']); // check if email addy is already in use $a = (@mysql_fetch_row(@sql_query("select count(*) from users where BINARY email='".mysql_real_escape_string($email)."'"))) or sqlerr(__FILE__, __LINE__); if ($a[0] != 0) bark($lang_takesignup['std_email_address'].$email.$lang_takesignup['std_in_use']); /* // do simple proxy check if (isproxy()) bark("You appear to be connecting through a proxy server. Your organization or ISP may use a transparent caching HTTP proxy. Please try and access the site on port 81 (this should bypass the proxy server).
Note: if you run an Internet-accessible web server on the local machine you need to shut it down until the sign-up is complete.");
$res = sql_query("SELECT COUNT(*) FROM users") or sqlerr(__FILE__, __LINE__);
$arr = mysql_fetch_row($res);
*/
$secret = mksecret();
//$wantpasshash = md5($secret . $wantpassword . $secret);
$wantpasshash = hash('sha256', $secret . $wantpassword);
$editsecret = ($verification == 'admin' ? '' : $secret);
$invite_count = (int) $invite_count;
$passkey = md5($wantusername.date("Y-m-d H:i:s").$wantpasshash);
$wantusername = sqlesc($wantusername);
$wantpasshash = sqlesc($wantpasshash);
$secret = sqlesc($secret);
$editsecret = sqlesc($editsecret);
$send_email = $email;
$email = sqlesc($email);
$country = sqlesc($country);
$gender = sqlesc($gender);
$sitelangid = sqlesc(get_langid_from_langcookie());
$authKey = sqlesc(mksecret());
$res_check_user = sql_query("SELECT * FROM users WHERE username = " . $wantusername);
if(mysql_num_rows($res_check_user) == 1)
bark($lang_takesignup['std_username_exists']);
$ret = sql_query("INSERT INTO users (username, passhash, passkey, secret, auth_key, editsecret, email, country, gender, status, class, invites, ".($type == 'invite' ? "invited_by," : "")." added, last_access, lang, stylesheet".($showschool == 'yes' ? ", school" : "").", uploaded) VALUES (" . $wantusername . "," . $wantpasshash . "," . sqlesc($passkey) . "," . $secret . "," . $authKey. "," . $editsecret . "," . $email . "," . $country . "," . $gender . ", 'pending', ".$defaultclass_class.",". $invite_count .", ".($type == 'invite' ? "'$inviter'," : "") ." '". date("Y-m-d H:i:s") ."' , " . " '". date("Y-m-d H:i:s") ."' , ".$sitelangid . ",".$defcss.($showschool == 'yes' ? ",".$school : "").",".($iniupload_main > 0 ? $iniupload_main : 0).")") or sqlerr(__FILE__, __LINE__);
$id = mysql_insert_id();
$userInfo = \App\Models\User::query()->find($id, \App\Models\User::$commonFields);
fire_event("user_created", $userInfo);
$tmpInviteCount = get_setting('main.tmp_invite_count');
if ($tmpInviteCount > 0) {
$userRep = new \App\Repositories\UserRepository();
$userRep->addTemporaryInvite(null, $id, 'increment', $tmpInviteCount, 7);
}
$dt = date("Y-m-d H:i:s");
$subject = $lang_takesignup['msg_subject'].$SITENAME."!";
$siteName = \App\Models\Setting::getSiteName();
$msg = \App\Models\MessageTemplate::forRegisterWelcome($userInfo->lang, ['username' => $userInfo->username]);
if (empty($msg)) {
$msg = $lang_takesignup['msg_congratulations'].$wantusername.sprintf($lang_takesignup['msg_you_are_a_member'],$siteName, $siteName);
}
\App\Models\Message::add([
'sender' => 0,
'receiver' => $id,
'subject' => $subject,
'added' => $dt,
'msg' => $msg,
]);
//write_log("User account $id ($wantusername) was created");
$res = sql_query("SELECT passhash, secret, editsecret, status FROM users WHERE id = ".sqlesc($id)) or sqlerr(__FILE__, __LINE__);
$row = mysql_fetch_assoc($res);
$psecret = md5($row['secret']);
$ip = getip();
$usern = htmlspecialchars($wantusername);
$title = $SITENAME.$lang_takesignup['mail_title'];
$confirmUrl = getSchemeAndHttpHost() . "/confirm.php?id=$id&secret=$psecret";
$confirmResendUrl = getSchemeAndHttpHost() . "/confirm_resend.php";
$mailTwo = sprintf($lang_takeinvite['mail_two'], $siteName);
$mailFive = sprintf($lang_takeinvite['mail_five'], $siteName, $siteName, $REPORTMAIL, $siteName);
$body = <<
$confirmUrl
{$lang_takesignup['mail_four_1']}
{$lang_takesignup['mail_here']}
$confirmResendUrl
{$mailFive}
EOD;
if ($type == 'invite')
{
//don't forget to delete confirmed invitee's hash code from table invites
//sql_query("DELETE FROM invites WHERE hash = '".mysql_real_escape_string($code)."'");
// set invalid
$update = [
'valid' => \App\Models\Invite::VALID_NO,
'invitee_register_uid' => $id,
'invitee_register_email' => $_POST['email'],
'invitee_register_username' => $_POST['wantusername'],
];
\App\Models\Invite::query()->where('id', $inv['id'])->update($update);
$dt = date("Y-m-d H:i:s");
$locale = get_user_locale($inviter);
$subject = nexus_trans("user.msg_invited_user_has_registered", [], $locale);
$msg = nexus_trans("user.msg_user_you_invited", [],$locale).$wantusername.nexus_trans("user.msg_has_registered", [], $locale);
//sql_query("UPDATE users SET uploaded = uploaded + 10737418240 WHERE id = $inviter"); //add 10GB to invitor's uploading credit
\App\Models\Message::add([
'sender' => 0,
'receiver' => $inviter,
'subject' => $subject,
'added' => $dt,
'msg' => $msg,
]);
$Cache->delete_value('user_'.$inviter.'_unread_message_count');
$Cache->delete_value('user_'.$inviter.'_inbox_count');
}
if ($verification == 'admin'){
if ($type == 'invite')
header("Location: " . get_protocol_prefix() . "$BASEURL/ok.php?type=inviter");
else
header("Location: " . get_protocol_prefix() . "$BASEURL/ok.php?type=adminactivate");
}
elseif ($verification == 'automatic' || $smtptype == 'none'){
header("Location: " . get_protocol_prefix() . "$BASEURL/confirm.php?id=$id&secret=$psecret");
}
else{
sent_mail($send_email,$SITENAME,$SITEEMAIL,$title,$body,"signup",false,false,'');
header("Location: " . get_protocol_prefix() . "$BASEURL/ok.php?type=signup&email=" . rawurlencode($send_email));
}
?>