rgister code
<?php
// Definitions
$server_name = "Your PServer-Name";
$database_name = "(local)";
$database_user = "sa";
$database_pass = "YourPassword";
$auth_name = "Auth";
$sql_error ="There was an internal error. Please try it later.";
$user_exists = "Username already exists!";
$user_min_letters = "4"; // Shouldn't get changed
$user_max_letters = "10"; // Shouldn't get changed
$pass_min_letters = "5"; // Shouldn't get changed
$pass_max_letters = "10"; // Shouldn't get changed
$md5_key = "2011";
?>
<html>
<head>
<title><?php echo $server_name; ?></title>
<center><a href="http://dkfight.de/"><img src="http://dkfight.de/style/images/logo.png" /></a></center>
<!-- if .css-file exists, include it here -->
</head>
<body>
<?php
// When the Button was pressed
if(isset($_POST['submit'])) {
// Replace all not-wanted letters
$user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
// When Username was empty
if($_POST['username'] == "") {
echo '<p align="center"><font color="red"> Please type in an username.</font></p>';
}
// When password was empty or Passwort 1 is not Passwort 2
else if($_POST['password'] == "" OR $_POST['password'] !== $_POST['passwordd']) {
echo '<p align="center"><font color="red"> Please type in a password </font></p>';
}
// When username is not between 4 - 10 letters
else if ((strlen($_POST['username']) > $user_max_letters) || (strlen($_POST['username']) < $user_min_letters)){
echo '<p align="center"><font color="red"> Your username have to be between 4 and 10 letters. </font></p>';
}
// When password is not between 4 - 10 letters
else if ((strlen($_POST['password']) > $pass_max_letters) || (strlen($_POST['password']) < $pass_min_letters)){
echo '<p align="center"><font color="red"> Your password have to be between 4 and 10 letters. </font></p>';
}
// When Username got wrong letters
else if($_POST['username'] != $user){
echo '<p align="center"><font color="red"> Username got wrong letters. </font></p>';
}
// When Password got wrong letters
else if($_POST['password'] != $pass){
echo '<p align="center"><font color="red"> Password got wrong letters.</font></p>';
// When all was working fine till here
}else {
// Database-Connect
$serverName = $database_name;
$connectionInfo = array( "Database"=>$auth_name, "UID" => $database_user,"PWD" => $database_pass);
$conn = sqlsrv_connect( $serverName, $connectionInfo) or die($sql_error);
// Search for existing users
$cquery = sqlsrv_query($conn, "SELECT * FROM Accounts WHERE login_name = '$user'");
$ccount = sqlsrv_has_rows($cquery);
// When username exists
if($ccount === true) {
echo '<p align="center"><font color="red">'. $user_exists .'</font></p>';
}else{
// Final Step: Insert Account
// Get the encrypted pass
$pass = md5($md5_key . $pass);
// Define Query
$iquery = "INSERT INTO Accounts (login_name,password,block,withdraw_remain_time,ag e,auth_ok,pcbang,last_login_server_idx,event_code, result) VALUES('$user','$pass',0,0,18,1,1,1,0,1)";
// Insert Query
$insert = sqlsrv_query($conn, $iquery);
sqlsrv_close();
// If insert was true
if($insert) {
echo '<p align="center"><font color="green"><font>Registration Success!</font></p>';
// Else...
}else{
echo $sql_error;
}
}
}
}
?>
<!-- Form-Definition -->
<form method="post">
<table align="center" cellpadding="5" cellspacing="5">
<tr>
<!-- Accountname -->
<td>Accountname:</td>
<td><input type="text" name="username" size="30"></td>
</tr>
<tr>
<!-- Password -->
<td>Password:</td>
<td><input type="password" name="password" size="30"></td>
</tr>
<tr>
<!-- Passwort... again. -->
<td>Password... again.:</td>
<td><input type="password" name="passwordd" size="30"></td>
</tr>
<tr>
<!-- Button -->
<td colspan="2" align="right"><input type="submit" name="submit" value="Register!"></td>
</tr>
</table>
</form>
</body>
</html>
