Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- Start Register -->
- <?php
- #############################
- ##Copyright (c) TheJacob#####
- ##All Rights Reserved########
- ##thejacobpollack@gmail.com##
- #############################
- #############################
- #############################
- ##Configuration##
- $mssql_server = "localhost"; //MSSQL server name or IP
- $mssql_username = "sa"; //MSSQL username
- $mssql_password = 'password'; //MSSQL password
- $mssql_account_db = "ACCOUNT_DBF"; //MSSQL account database name
- $mssql_character_01_db = "CHARACTER_01_DBF"; //MSSQL character database name
- $mssql_account_table = "account_tbl"; //MSSQL account table name
- $mssql_username_column = "account"; //MSSQL username column in account table
- $mssql_password_column = "password"; //MSSQL password column in account table
- $hash = "kikugalanet"; //Hash code
- #############################
- #############################
- ##MSSQL Connect Function##
- function mssql_connect_ini($mssql_server,$mssql_username,$mssql_password) {
- $mssql_connect = mssql_connect($mssql_server, $mssql_username, $mssql_password) or die ("<strong>Keine Verbindung zum MSSQL Server.</strong>");
- if ((strlen($mssql_server) == 0) || (strlen($mssql_username) == 0) || (strlen($mssql_password) == 0)) {
- echo "<strong>Verbindungsdaten nicht korrekt.</strong>";
- }
- }
- ##MSSQL Account Database Select Function##
- function mssql_account_ini($mssql_account_db) {
- $mssql_select_db = mssql_select_db($mssql_account_db) or die ("<strong>Keine Verbindung zur Accountdatenbank</strong>");
- if (strlen($mssql_account_db) == 0) {
- echo "<strong>Verbindungsdaten</strong>";
- }
- }
- #############################
- #############################
- ##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
- $pemail = @$_POST['email'];
- if (isset($_POST['submit']) == true) {
- if ((isset($_POST['submit']) == true) and (strlen($pusername) < 3) || (strlen($pusername) > 15)) {
- echo "Benutzername sollte zwischen 3 und 15 Zeichen enthalten.";
- }
- else if ((isset($_POST['submit']) == true) and ((strlen($ppassword) < 3) || (strlen($ppassword) > 15) || (strlen($prpassword) < 3) || (strlen($prpassword) > 15))) {
- echo "Das Passwort 3 und 15 Zeichen enthalten.";
- }
- else if ((isset($_POST['submit']) == true) and ($ppassword != $prpassword)) {
- echo "Die Passwörter stimmen nicht überein.";
- }
- else if ((isset($_POST['submit']) == true) and (($pusername == $ppassword) || ($pusername == $prpassword))) {
- echo "Benutzername und Passwort können nicht gleich sein.";
- }
- else if(!preg_match( '/^[a-zA-Z0-9]/' , $pusername)){
- echo '<font color="red">Benutzername mit ungültigen Zeichen.</font><br /><br />';
- }
- else if(!preg_match ('/^[a-zA-Z0-9]/',$ppassword)){
- echo '<font color="red">Passwort mit ungültigen Zeichen.</font><br /><br />';
- }
- else if(!preg_match ('/^[a-zA-Z0-9]/',$prpassword)){
- echo '<font color="red">Passwort mit ungültigen Zeichen.</font><br /><br />';
- }
- else if(!preg_match ('/^[a-zA-Z0-9@.]/', $pemail)){
- echo '<font color="red">Email mit ungültigen Zeichen.</font><br /><br />';
- }
- 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', $pusername, SQLVARCHAR, false, false, 15);
- mssql_bind($stmt, '@password', md5($hash . $ppassword), SQLVARCHAR, false, false, 36);
- mssql_bind($stmt, '@email', $pemail, SQLVARCHAR, false, false, 120);
- mssql_execute($stmt) or die ("<strong>Error occurred while executing the statement.</strong>");
- mssql_free_statement($stmt);
- echo "Du wurdest erfolgreich als <strong>" . $pusername . "</strong> registriert.!";
- } else {
- echo "Benutzername existiert bereits.";
- }
- }
- ?>
- <br>
- <center>
- <form method ="post" action="#">
- <table>
- <tr>
- <td><strong>Benutzername:</strong></td>
- </tr>
- <tr>
- <td><input name="username" type="username"></td>
- </tr>
- <tr>
- <td><strong>Passwort:</strong></td>
- </tr>
- <tr>
- <td><input name="password" type="password"></td>
- </tr>
- <tr>
- <td><strong>Passwort wiederholen:</strong></td>
- </tr>
- <tr>
- <td><input name="rpassword" type="password"></td>
- </tr>
- <tr>
- <td><strong>E-Mail:</strong></td>
- </tr>
- <tr>
- <td><input name="email" type="email"></td>
- </tr>
- <tr>
- <tr>
- <td><input name="submit" type="submit" value="Register"></td>
- </tr>
- </table>
- </form>
- </center>
- <!-- End Regiser -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement