30 ): $error_flag="Y"; $error_message="Password length must be between 4 and 30 characters! Please choose another password."; elseif ($password != $password2): $error_flag="Y"; $error_message="Passwords do not match!"; elseif ( $gfaq_name == ""): $error_flag="Y"; $error_message="You must enter your GameFAQ's username!"; elseif ( $email == ""): $error_flag="Y"; $error_message="You must enter a valid email address!"; else: $result = mysqli_query($link, "select count(*) from member where username='$db_username'"); $row = mysqli_fetch_row($result); if ( $row[0] == 0 ): $result = mysqli_query($link, "select count(*) from member where gfaq_name='$db_gfaq_name'"); $row = mysqli_fetch_row($result); if ( $row[0] == 0 ): $hashed_password = addslashes(crypt($password, $password)); $sql = "insert into member (gfaq_name, username, email, creation_date, activity_level, user_level, hashed_password, signup_date, instance_name) values ('$db_gfaq_name', '$db_username', '$db_email', CURDATE(), 5, 'U', '$hashed_password',CURDATE(), '$instance_name')"; mysqli_query($link, $sql ); $result = mysqli_query($link,"select member_id from member where username='$db_username'"); $row = mysqli_fetch_row($result); $login_id = $row[0]; $login_time = date("YmdHis",time()); $my_activity_level = 5; $login_key = crypt($login_id, $login_time); setCookie("opsc_login_id",$login_id,time()+2592000); setCookie("opsc_login_time",$login_time,time()+2592000); setCookie("opsc_login_key",$login_key,time()+2592000); $cmd = "view_new"; $success_message="You are now successfully registered. You can now add your pawn(s)."; $sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'SIGNUP', 'S', '$ip_address')"; $result = mysqli_query($link, $sql ); if(!$result): $debug_msg = mysqli_error($link); endif; else: $error_message = "A member with that GameFAQs name already exists! Please pick some other GameFAQs name."; $error_flag="Y"; endif; else: $error_message = "Member with that username already exists! Please pick some other username."; $error_flag="Y"; endif; endif; endif; endif;?> Official Dragon's Dogma Pawn Sharing Club - Sign Up
Signup to Official Pawn Sharing Club
To begin, please complete the registration form below.

If you already have an account here but have forgotten your username or password, use forgot password function to recover your lost login credentials.
In case you are still not able to login, please send mail to at GameFAQs to recover it.
You are not allowed to use same GameFAQs' name that is already registered to site for other existing account.

* indicates required field
Your Details

This will not be shown for others and will be account name you can login into this site. Please do not use special characters in your username.

Password length must be minimum 4 characters.

This will be shown for others as your name in spreadsheet that they identify you in GameFAQs forum. If you do not have an account in GameFAQs or prefer staying anonymous, you may enter here name of your choice.

This is solely used for contact purposes.
Submit
Welcome !
You have now successfully signed up to the Pawn Sharing Club.

Please write down the following information what you need when you login next time or forgot your password:

"; echo "Password: " . htmlspecialchars($password) . "
"; echo "GameFAQ name: " . htmlspecialchars($gfaq_name) . "
"; echo "Email: " . htmlspecialchars($email) . "
"; $mailsubject = "Welcome to Official Pawn Sharing Club"; $msg = "Dear " . $gfaq_name . ",\n\n"; $msg .= "Thank you for registering to Official Pawn Sharing Club!\n\n"; $msg .= "Please use the following credentials when you login to http://$instance_name\n\n"; $msg .= "Username: " . $username . "\n"; $msg .= "Password: " . $password . "\n\n"; $msg .= "Best Regards,\n"; $msg .= "OPSC Support"; if (mail($email, $mailsubject, $msg, $mailheaders)): echo " 
A welcome mail containing this information was also sent to your email address " . $email . "."; endif; ?>

Next you can add your pawn to list by clicking My Pawns menu button.