Register Probleme Help!!^^

10/15/2010 21:57 Ilove1337#1
Ich use den Register script hier:
HTML Code:
<!-- Start Register -->

<?php

#############################
##Copyright (c) TheJacob#####
##All Rights Reserved########
##[Only registered and activated users can see links. Click Here To Register...]##
#############################

#############################
#############################

##Configuration##
$mssql_server = [COLOR="Red"]"USER-E36AFF4323\SQLEXPRESS";[/COLOR] //MSSQL server name or IP
$mssql_username = "sa"; //MSSQL username
$mssql_password = "xxxxxxx"; //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 = "sa"; //MSSQL username column in account table
$mssql_password_column = "xxxxxx"; //MSSQL password column in account table
$hash = ""; //Hash code
$random_text_text = "e=mc2"; //Random text they must enter to register

#############################
#############################

##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>Cannot connect to the MSSQL server.</strong>");
    if ((strlen($mssql_server) == 0) || (strlen($mssql_username) == 0) || (strlen($mssql_password) == 0)) {
    echo "<strong>The connection configuration settings are invalid. Please make sure you've entered them in correctly.</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>Cannot select the Account database.</strong>");
    if (strlen($mssql_account_db) == 0) {
    echo "<strong>The account database configuration setting is invalid. Please make sure you've entered it correctly.</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
$random_text = @$_POST['random_text']; //Random text

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 ((isset($_POST['submit']) == true) and ($random_text != $random_text_text)) {
echo "The random text must be filled in correctly. Please take another look at the random text.";
}

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 ("<strong>Error occurred while executing the statement.</strong>");
mssql_free_statement($stmt);
echo "You've been successfully registered as <strong>" . $username . "</strong>!";
} else {
echo "The username already exists.";
}
}

?>

<br>
<center>
<form method ="post" action="#">
<table>

<tr>
<td><strong>Username</strong></td>
</tr>
<tr>
<td><input name="username" type="username"></td>
</tr>
<tr>
<td><strong>Password</strong></td>
</tr>
<tr>
<td><input name="password" type="password"></td>
</tr>
<tr>
<td><strong>Re-enter Password</strong></td>
</tr>
<tr>
<td><input name="rpassword" type="password"></td>
</tr>
<tr>
<td><strong>Please enter "<?php echo $random_text_text ?>" without the brackets below</strong></td>
</tr>
<tr>
<td><input name="random_text" type="text"></td>
</tr>
<tr>
<td><input name="submit" type="submit" value="Register"></td>
</tr>

</table>
</form>
</center>

<!-- End Regiser -->
Bekomme immer diesen error :

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: USER-E36AFF4323\SQLEXPRESS in C:\xampp\htdocs\flyff\SilenceofHell\register.php on line 31
Cannot connect to the MSSQL server.

und so log ich mich in mssql ein
[Only registered and activated users can see links. Click Here To Register...]

weiß vll jemand wieso ich diesen error bekomme wäre sehr dankbar ;)
10/16/2010 14:04 ocram1095#2
Also ic hhabe es geschafft das Register zum laufen bekommen aber auch nur weil ich viel ein kommentiert habe und auch hinzugefügt habe

wenn du willst kannst ja meins jetzt haben melde dich dann einfach



mfg ocram | Marco
10/16/2010 15:50 TheAnimeFreak#3
Guck ma in meine Signatur und da unten steht P server bla bla da ist auch eine gute register die geht immer xD die ist nich kompliziert
10/16/2010 19:20 Meikbrosoft#4
du hast deine daten in connection falsch geschrieben oder so^^
Quote:
##Configuration##
$mssql_server = "USER-E36AFF4323\SQLEXPRESS"; //MSSQL server name or IP
$mssql_username = "sa"; //MSSQL username
$mssql_password = "xxxxxxx"; //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 = "sa"; //MSSQL username column in account table
$mssql_password_column = "xxxxxx"; //MSSQL password column in account table
$hash = ""; //Hash code
$random_text_text = "e=mc2"; //Random text they must enter to register
da^^
10/16/2010 20:03 TheAnimeFreak#5
Quote:
Originally Posted by TheFreakBpx3 View Post
du hast deine daten in connection falsch geschrieben oder so^^

da^^
der sagte doch sql server oder ip versuch ma mit ip^^