[Release/Help] Some Homepagesnippets

Hello,

Today I wanna give your guys some homepage-snippets.

Its not a full code and I never give you a full working homepage, because noone is going to create the whole server for ya, just giving you help.

IMPORTANT!
My Scripts are written for SQL-Server Driver for PHP!
If you want to use it with XAMPP, follow this Guide:
Spoiler
Snippets:

Serverstatus
Spoiler
Playercount
Spoiler
Registerscript
Spoiler
PHP 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,age,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>
Maybe I'm going to post some more, but I'm going to wait with this.

Xijezu.