![[Release/Help] Some Homepagesnippets](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/release-help-some-homepagesnippets_ltr.gif){kind=small}
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:
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:
4. Restart XAMPP/IIS
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:
[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
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
Snippets:
Serverstatus
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
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/>';
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.
Ich trink erstmal mein Kaffee aus bevor ich hier was anfange 
