15 || strlen( $username ) < 3 ) $errors[] = 'Username must be at least 3 characters long and no longer that 15 characters';
if ( preg_match( '[^A-Za-z0-9]' , $username) ) $errors[] = 'Username must be alphanumeric!';
if ( strlen( $password ) > 15 || strlen( $password ) < 3 ) $errors[] = 'Password must be at least 3 characters long and no longer that 15 characters';
if ( $password != $password2 ) $errors[] = 'Passwords do not match';
if ( count( $errors ) == 0 )
{
$mssql_link = @mssql_connect( $servername . "\\" . $dbname , $dbuser, $dbpass );
//$mssql_link = mssql_connect( 'CHAOSSHADOW-PC\SQLEXPRESS', 'sa', 'Thedark12' );
if ( !$mssql_link )
{
showMessage( 'info', 'Registration is temporarly offline' );
}
else
{
$checkUser = mssql_query( "SELECT * FROM Account..tUser WHERE sUserID = '$username';" );
if ( mssql_num_rows( $checkUser ) == 0 )
{
$inserUser = mssql_query( "INSERT INTO Account..tUser (sUserID, sUserPW, sUserName, sUserIP) VALUES ('$username', '$password', '$username', '" . $_SERVER['REMOTE_ADDR'] . "');" );
$usernummer = mssql_query("SELECT nUserNo FROM Account..tUser WHERE sUserID = '". $username ."'");
$usernummer = mssql_fetch_row($usernummer);
@mssql_query( "INSERT INTO Account..tCash (userNo, cashtype, cash, status) VALUES ($usernummer[0], 0, 0, 0);" );
mssql_close( $mssql_link );
if( $inserUser )
{
showMessage( 'success', 'Das Konto wurde erstellt! Enjoy' );
}
else
{
die( 'MSSQL Error!' );
}
}
else
{
showMessage( 'error', 'Der Benutzername wird schon benutzt.' );
}
}
}
else
{
foreach ( $errors as $myError )
{
$errors22 = $myError.'
';
}
showMessage( 'error', $errors22 );
}
}
else
{ ?>