session_begin();
$auth->acl($user->data);
$user->setup('viewforum');
include($phpbb_root_path . 'config.php');
///MySQL Connect
mysql_connect(localhost,$dbuser,$dbpasswd);
mysql_select_db($dbname) or die( "Unable to select database");
//check if user exists
$check=mysql_query("SELECT * FROM " . $table_prefix . "users WHERE username_clean='" . strtolower($username) . "'");
$anymatches=mysql_num_rows($check);
if ($anymatches == 0) {
////add if not exist
echo "Member Does Not Exists... Adding...
";
include_once($phpbb_root_path . 'includes/functions_user.php');
if (($coppa ||
$config['require_activation'] == USER_ACTIVATION_SELF ||
$config['require_activation'] == USER_ACTIVATION_ADMIN) && $config['email_enable'])
{
$user_actkey = gen_rand_string(10);
$key_len = 54 - (strlen($server_url));
$key_len = ($key_len < 6) ? 6 : $key_len;
$user_actkey = substr($user_actkey, 0, $key_len);
$user_type = USER_INACTIVE;
$user_inactive_reason = INACTIVE_REGISTER;
$user_inactive_time = time();
}
else
{
$user_type = USER_NORMAL;
$user_actkey = '';
$user_inactive_reason = 0;
$user_inactive_time = 0;
}
$ip = $_SERVER['REMOTE_ADDR'];
$lang = 'en';
$email_template = 'user_welcome_inactive';
$user_row = array(
// Username
'username' => $username,
// Password
'user_password' => phpbb_hash($password),
// Email
'user_email' => $email,
// Group 2 is Registered Users
'group_id' => '2',
// Change Timezone here
'user_timezone' => '-8.00',
// Daylight Savings Time?
'user_dst' => '0',
// Set Users Language, Default 'en'
'user_lang' => $lang,
// User Type is normal user
'user_type' => $user_type,
// Activation Key from above
'user_actkey' => $user_actkey,
// IP Address
'user_ip' => $ip,
// User registration date
'user_regdate' => time(),
// If activation required
'user_inactive_reason' => $user_inactive_reason,
'user_inactive_time' => $user_inactive_time,
);
$server_url = generate_board_url();
$user_id = user_add($user_row);
if($user_id === false){
// There was a problem registering, do something
}else{
// User was successfully added to database, send an email now
include_once($phpbb_root_path . 'includes/functions_messenger.php');
$messenger = new messenger(false);
$messenger->template($email_template, $lang);
$messenger->to($email, $username);
$messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);
$messenger->headers('X-AntiAbuse: Username - ' . $username);
$messenger->headers('X-AntiAbuse: User IP - ' . $ip);
$messenger->assign_vars(array(
'WELCOME_MSG' => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),
'USERNAME' => htmlspecialchars_decode($username),
'PASSWORD' => htmlspecialchars_decode($password),
'U_ACTIVATE' => "$server_url/ucp.$phpEx?mode=activate&u=$user_id&k=$user_actkey")
);
if ($coppa)
{
$messenger->assign_vars(array(
'FAX_INFO' => $config['coppa_fax'],
'MAIL_INFO' => $config['coppa_mail'],
'EMAIL_ADDRESS' => $email)
);
}
if($messenger->send(NOTIFY_EMAIL)){
// Email was sent successfully, do something
}else{
// Could not send email, do something
}
}
echo "Banning...
";
///This sets the new profile to deactivated by admin (default was set to 0 by the above)
$query="UPDATE " . $table_prefix . "users SET user_inactive_reason = '3' WHERE username_clean='" . strtolower($username) . "'";
mysql_query($query);
}else{
// USERNAME EXISTS! DO SOMETHING ABOUT IT.
echo "Member Exists... Banning...
";
///This sets the new profile to deactivated by admin and changes the e-mail
$query="UPDATE " . $table_prefix . "users SET user_inactive_reason = '3', user_email = '$email' WHERE username_clean='" . strtolower($username) . "'";
mysql_query($query);
}
echo "Member Banned
";
mysql_close();
?>