[HOW TO] Auto approve new members when they sign up

[inmotion]

To allow each new member to automoaticlaly be approved when they register

1) Edit the file /register.php

find

    // insert new user record
    $sql = "INSERT into member_profile (user_name, password, email_address, account_status, account_type, date_created, random_code) VALUES ('$user_name', '$password', '$email_address', 'new', 'standard', '$date', '$random_code')";
    @mysql_query($sql) or die(@header("Location: " . "system_error.php?code=101"));

replace with

    // insert new user record
    $sql = "INSERT into member_profile (user_name, password, email_address, account_status, account_type, date_created, random_code) VALUES ('$user_name', '$password', '$email_address', 'active', 'standard', '$date', '$random_code')";
    @mysql_query($sql) or die(@header("Location: " . "system_error.php?code=101"));

2) You may also want to change the message that they see when they finish.

So in admin area, under "general" tab, change the notification for successful registration. to maybe some think like

"Your registration has been successful, you can now login"