Code: Select all
//username, email and password not blank
if ($username <> "" && $email <> "" & $password <> "")
{
echo 'here'; //<-makes it here
//check if username or email not allready in use
$info = mysql_fetch_object(mysql_query("SELECT id FROM users WHERE (username='$username' OR user_email='$email')")) or die(mysql_error());
//username and email not taken
if ($info->id == "")
{
$query="INSERT INTO users (
username,
user_pass,
user_email,
user_verified,
user_rank,
user_gender,
user_country,
usern_state,
user_zip,
user_dob,
user_join_date
) VALUES (
'".$username."',
'".$password."',
'".$email."',
'".$code."',
'0',
'".$gender."',
'".$country."',
'".$state."',
'".$zip."',
'".$dob."',
'".time()."'
)";
mysql_query($query) or die(mysql_error());
$query="INSERT INTO user_settings (
username,
popup_on_new_msg,
email_on_new_mesg,
popup_on_lost_highscore,
email_on_lost_highscore,
popup_friend_invite,
email_friend_invite,
daily_anime,
daily_manga,
daily_poetry,
daily_fanfictions,
daily_gaming,
daily_comics,
daily_midis,
daily_mp3s,
daily_horoscopes,
daily_jokes,
weekly_anime,
weekly_manga,
weekly_poetry,
weekly_fanfictions,
weekly_gaming,
weekly_comics,
weekly_midis,
weekly_mp3s,
weekly_horoscopes,
weekly_jokes,
monthly_anime,
monthly_manga,
monthly_poetry,
monthly_fanfictions,
monthly_gaming,
monthly_comics,
monthly_midis,
monthly_mp3s,
monthly_horoscopes,
monthly_jokes
) VALUES (
'y',
'y',
'y',
'y',
'y',
'y',
'".$subscriptions[0]."',
'".$subscriptions[1]."',
'".$subscriptions[2]."',
'".$subscriptions[3]."',
'".$subscriptions[4]."',
'".$subscriptions[5]."',
'".$subscriptions[6]."',
'".$subscriptions[7]."',
'".$subscriptions[8]."',
'".$subscriptions[9]."',
'".$subscriptions[10]."',
'".$subscriptions[11]."',
'".$subscriptions[12]."',
'".$subscriptions[13]."',
'".$subscriptions[14]."',
'".$subscriptions[15]."',
'".$subscriptions[16]."',
'".$subscriptions[17]."',
'".$subscriptions[18]."',
'".$subscriptions[19]."',
'".$subscriptions[20]."',
'".$subscriptions[21]."',
'".$subscriptions[22]."',
'".$subscriptions[23]."',
'".$subscriptions[24]."',
'".$subscriptions[25]."',
'".$subscriptions[26]."',
'".$subscriptions[27]."',
'".$subscriptions[28]."',
'".$subscriptions[29]."'
)";
mysql_query($query) or die("There was an error, your account subscriptions was not set, please contact an admin to fix the problem");
echo 'registration complete';
}
else
{
echo 'username allready taken';
}
}
//username email or password is blank
else
{
if ($username == "")
$eRR = "Username not set...<br>";
if ($email == "")
$eRR = "Email address not set...<br>";
if ($password == "")
$eRR = "Password not set...<br>";
echo $eRR;
}
?>