P server Homepage WICHTIG

07/09/2011 23:54 stylo971#1
Hallo,

plz ein Thread Link wo erklärt wird wie man die Regestrierung auf der Homepage mit dem Server einbindet

thx im vorraus

PS:Sri für die Rechtschreib und GRammatikfehler habs eillig xD
07/09/2011 23:56 Nexo24255#2
Für root server?
07/10/2011 00:05 stylo971#3
Quote:
Originally Posted by Nexo24255 View Post
Für root server?
[Only registered and activated users can see links. Click Here To Register...]

um genau zu sein weis ich es nich ^^ kannste ja selbst guckn

DANKE WENN DU MIR HIFEN KANNST
07/10/2011 00:10 Etany#4
Du musst das iwie mit deiner Datenbank verknüpfen SQL oder so etwas. Such ma in google dananch oder hier... :D
07/10/2011 00:18 stylo971#5
HAT JMD EIN LINK FÜR MICH AM BESTEN EINE AUSFÜHRLICHE BESCHREIBUNG ^^
07/10/2011 03:01 19Dani92#6
register.php:

Quote:
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>HYPER FLYFF</title>
<meta name="keywords" content="" />
<meta name="Gestured" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
<!-- start header -->
<div id="header">
<div id="menu">
<ul id="main">
<li class="current_page_item"><a href="index.php">Homepage</a></li>
<li><a href="Register.php">Registrieren</a></li>
<li><a href="Downloads.php">Downloads</a></li>
<li><a href="Ranking.php">Ranking</a></li>
<li><a href="Rules.php">Regeln</a></li>
<li><a href="Information.php">Informationen</a></li>
<li><a href="Contact.php">Kontakt</a></li>
<li><a href="Chat.php">Chat</a></li>
</ul>
</div>
<div id="logo">
<h1><a href="#"><span><center><font color="black" face="Comic Sans MS"><font color="darkred" face="Lucida Blackletter,Arial">F</font>ly <font color="darkred" face="Lucida Blackletter,Arial">F</font>or <font color="darkred" face="Lucida Blackletter,Arial">F</font>allen</font></center></span></a></h1>
</div>
</div>
<!-- end header -->
<!-- start page -->
<div id="page">
<div id="sidebar1" class="sidebar">
<ul>
<li>
<h2>Server Stats</h2>
<ul>
<li>Exp: 50</li>
<li>Drop: 50</li>
<li>Penya: 100</li>
<li>Special Event: x2 Exp, Drop, Penya</li>

</ul>
</li>
<li>
<h2>Status</h2>
<ul>

<br><li>Account Server:
<?php
$online = @fsockopen("DEINE IP", 12001, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>

<br><li>Login Server:
<?php
$online = @fsockopen("DEINE IP", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>
<br><li>World Server:
<?php
$online = @fsockopen("DEINE IP", 2101, $errno, $errstr, 1);
if($online >= 1) {
echo '<b><font color=#00FF00>Online</font></b>';
}
else {
echo '<b><font color=#FF0000>Offline</font></b>';
}
?></li>
</ul>
</li>
<li>
<h2>Server Details</h2>
<ul>
<li>Cpu: Intel(R) Core(TM) i7 CPU Q720 @ 1.60 GHz</li>
<li>Ram: 4,00 GB DDR3</li>
<li>HDD: 500GB Sata 2 Drives</li>
</ul>
</li>

</ul>
</div>
<!-- start content -->
<div id="content">
<div class="post">

<div class="entry">
<p><?php
require('./configs/reg_conf.php');
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'");
if (mssql_num_rows($result) != 0){
$exit = TRUE;
}
return $exit;
}

if(isset($_POST['submit'])){
$user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$email = preg_replace ("[^A-Za-z0-9]", "", $_POST['email']);
$pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
if($_POST['username'] == ""){
echo '<font color="red">Enter a user.</font><br /><br />';
}
else if($_POST['password'] == ""){
echo '<font color="red">Enter a password.</font><br /><br />';
}
else if ((strlen($_POST['username']) > 16) || (strlen($_POST['username']) < 3)){
echo '<font color="red">The user should be 3 to 16 characters.</font><br /><br />';
}
else if ((strlen($_POST['password']) > 16) || (strlen($_POST['password']) < 3)){
echo '<font color="red">The password should be 3 to 16 characters.</font><br /><br />';
}
else if($_POST['username'] != $user){
echo '<font color="red">User with invalid characters.</font><br /><br />';
}
else if($_POST['password'] != $pass){
echo '<font color="red">Password with invalid characters.</font><br /><br />';
}
else {
$pass = md5('kikugalanet' . $pass);
if(!doesUsernameExist($user)){
$stmt = mssql_init('usp_CreateNewAccount', $link);
mssql_bind($stmt, '@account', $user, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@pw', $pass, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@email', $email, SQLVARCHAR, false, false, 120);
mssql_execute($stmt) or die ("Something is wrong on the execution");
mssql_free_statement($stmt);
echo '<font color="Green">Register Successfull.</font><br /><br />';
}
else {
echo '<font color="red">User already Exist.</font><br /><br />';
}
}
mssql_close();
}

echo '<form action="#" method="post">';
echo 'Username: <input type="text" name="username" /><br />';
echo 'Password: <input type="password" name="password" /><br />';
echo 'Email: <input type="text" name="email" /><br />';
echo '<input type="submit" name="submit" value="Register" />';
echo '</form>';

?></p>

</div>
</div>

</div>
<!-- end content -->
<!-- start sidebars -->
<div id="sidebar2" class="sidebar">
<ul>
<li>
<h2>Weitere Informationen</h2>
<ul><?php
require('./configs/t_account_conf.php');
echo 'Total Accounts: ' . mssql_num_rows($query);
?>








<br>


<?php
require('./configs/t_character_conf.php');
echo 'Total Characters: ' . mssql_num_rows($query);
?>










<br>


<?php
require('./configs/t_user_conf.php');
echo 'Users Online: ' . mssql_num_rows($query);
?>

</ul>
</li>
</ul>
</div>
<!-- end sidebars -->
<div style="clear: both;">&nbsp;</div>
</div>
<!-- end page -->
</div>
<div id="footer">

</div>
</body>
</html>
reg_conf.php im unterordner configs! :

Quote:
<?php
$link = @mssql_connect("DEIN PC-NAMEN HIER REINSCHREIBEN\SQLEXPRESS", "", "DEIN DB PASSWORT HIER REINSCHREIBEN") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
$b = '';
$mail = '';


?>
ALLES aus den ALTEN Hyperflyff HP files

EDIT:

Such dir die Teile raus die du für dich benötigst!