[Release/Help] Some Homepagesnippets

[Xijezu]

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

1. Download This:
2. Extract it into your PHP/ext-folder (usually C:\Program Files (x86)\PHP\ext)
3. Open your php.ini (Findable in PHP-Folder), add this at the end:

 Spoiler

[PHP_PDO_SQLSRV_53_NTS_VC9]
extension=php_pdo_sqlsrv_53_nts_vc9.dll
[PHP_PDO_SQLSRV_52_TS_VC6]
extension=php_pdo_sqlsrv_52_ts_vc6.dll
[PHP_PDO_SQLSRV_53_TS_VC9]
extension=php_pdo_sqlsrv_53_ts_vc9.dll
[PHP_PDO_SQLSRV_52_NTS_VC6]
extension=php_pdo_sqlsrv_52_nts_vc6.dll
[PHP_PDO_SQLSRV_53_NTS_VC6]
extension=php_pdo_sqlsrv_53_nts_vc6.dll
[PHP_PDO_SQLSRV_53_TS_VC6]
extension=php_pdo_sqlsrv_53_ts_vc6.dll
[PHP_SQLSRV_52_NTS_VC6]
extension=php_sqlsrv_52_nts_vc6.dll
[PHP_SQLSRV_52_TS_VC6]
extension=php_sqlsrv_52_ts_vc6.dll
[PHP_SQLSRV_53_NTS_VC9]
extension=php_sqlsrv_53_nts_vc9.dll
[PHP_SQLSRV_53_NTS_VC6]
extension=php_sqlsrv_53_nts_vc6.dll
[PHP_SQLSRV_53_TS_VC6]
extension=php_sqlsrv_53_ts_vc6.dll
[PHP_SQLSRV_53_TS_VC9]
extension=php_sqlsrv_53_ts_vc9.dll

4. Restart XAMPP/IIS

Snippets:

Serverstatus

 Spoiler

PHP Code:

    $sone = fsockopen("127.0.0.1", 4502, $errno, $errstr, 1);
    if($sone >= 1) {
        echo '<font color="#266110">Online</font><br/>';
    }else {
        echo '<font color="#691f0e">Offline</font><br/>';
            }
    $stwo = fsockopen("127.0.0.1", 4518, $errno, $errstr, 1);
        if($stwo >=1) {
            echo ' <font color="#266110">Online</font><br/>';
            }else{
            echo '<font color="#691f0e">Offline</font><br/>';
            } 


Playercount

 Spoiler

PHP Code:

// Account-Echo start
$serverName = "(local)";
$connectionInfo = array( "Database"=>"Auth", "UID" => "sa","PWD" => "Password");
$conn = sqlsrv_connect( $serverName, $connectionInfo) or die("Connection failed.");
$accquery = "SELECT COUNT(account_id) as regs FROM Accounts";
$query = sqlsrv_query($conn, $accquery);
$dt = sqlsrv_fetch_array($query);
echo 'Accounts:  <font color="#948371">'.$dt["regs"].'</font> <br/>'; 


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.

[Xijezu]

#Added Registerscript

[mahmoudnasser]

ok help me ? in skype?

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\r\index.php on line 57

[Raskim2000]

NULL, my Fault.

[Xijezu]

Ich zitiere:
When username has wrong letters
When password has wrong letters

Somit stimmt das ganze schon, da er ja auch noch überprüfen soll, ob im Pass auch Sonderzeichen vorkommen.

[Raskim2000]

Ouh, sry Ich trink erstmal mein Kaffee aus bevor ich hier was anfange

[Xijezu]

Same here, ich hatte eben selber 2x password gelesen... Deswegen war ich selber total verwundert... xD

By the way, die PM hab ich losgeschickt.
Und: Guten Morgen ;D

[YemeBeni]

player online status ?

[Xijezu]

Not yet. Coming soon. ;D

[mahmoudnasser]

plz Xijezu ineed help ": plz