Athens Fiesta
We are looking forward to make Athens Fiesta Online better, and we need your support.
By donating you can help us provide best gaming experience to every player including you.
Goal: New Dedicated server. (Dual CPU, 24GB Ram, Rid 0 40GB SSD)
15 || strlen( $username ) < 3 ) $errors[] = 'Username must be at least 3 characters long and no longer that 15 characters';
if ( ereg( '[^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( 'STORMY-PC\SQLEXPRESS', 'sa', 'Mitek2011' );
if ( !$mssql_link )
{
die( 'Can\'t connect to database!' );
}
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) VALUES ('$username', '$password', '$username');" );
if( $inserUser )
{
echo 'Account has been created! Enjoy!';
}
else
{
die( 'MSSQL Error!' );
}
}
else
{
die( 'Such username is already in use!' );
}
}
}
else
{
foreach ( $errors as $myError )
{
echo '
'.$myError;
}
}
}
else
{ ?>