Cannot connect to the MSSQL server."); if ((strlen($mssql_server) == 0) || (strlen($mssql_username) == 0) || (strlen($mssql_password) == 0)) { echo "The connection configuration settings are invalid. Please make sure you've entered them in correctly."; } } ##MSSQL Account Database Select Function## function mssql_account_ini($mssql_account_db) { $mssql_select_db = mssql_select_db($mssql_account_db) or die ("Cannot select the Account database."); if (strlen($mssql_account_db) == 0) { echo "The account database configuration setting is invalid. Please make sure you've entered it correctly."; } } ############################# ############################# ##MSSQL Core Functionality## mssql_connect_ini($mssql_server,$mssql_username,$mssql_password); mssql_account_ini($mssql_account_db); ############################# ############################# $pusername = @$_POST['username']; //Post wsername $ppassword = @$_POST['password']; //Post password $prpassword = @$_POST['rpassword']; //Post re-enter password if (isset($_POST['submit']) == true) { $username = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $pusername); $password = preg_replace("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", "", $ppassword); if ((isset($_POST['submit']) == true) and (strlen($pusername) < 3) || (strlen($pusername) > 15)) { echo "Your username must be between 3 and 15 characters in length."; } else if ((isset($_POST['submit']) == true) and ((strlen($ppassword) < 3) || (strlen($ppassword) > 15) || (strlen($prpassword) < 3) || (strlen($prpassword) > 15))) { echo "The password must be between 3 and 15 characters in length."; } else if ((isset($_POST['submit']) == true) and ($ppassword != $prpassword)) { echo "The passwords must be the same."; } else if ((isset($_POST['submit']) == true) and (($pusername == $ppassword) || ($pusername == $prpassword))) { echo "The username and password cannot be the same."; } else if (mssql_num_rows(mssql_query("SELECT * FROM $mssql_account_table WHERE $mssql_username_column = '$username'")) == '0') { $stmt = mssql_init('createaccount'); mssql_bind($stmt, '@account', $username, SQLVARCHAR, false, false, 15); mssql_bind($stmt, '@password', md5($hash . $password), SQLVARCHAR, false, false, 36); mssql_execute($stmt) or die ("Error occurred while executing the statement."); mssql_free_statement($stmt); echo "You've been successfully registered as " . $username . "!"; } else { echo "The username already exists."; } } ?>

Username

Password

Re-enter Password

Get your own Chat Box! Go Large!