Liebe Elitepvpers,
Versuche schon seit einiger Zeit ein Register Script auf die Flyff Pserver HP einzubinden(Offi V14), aber immer wenn ich auf "Account erstellen" klicke, kommt dieser Fehler:
und die functions.php:
Hab alles versucht, regi Script hab ich übrigens von den Homepage Addons von Jusikid([Only registered and activated users can see links. Click Here To Register...])
Hoffe, ihr könnt mir weiterhelfen.
Mfg. Pumbaaa
Versuche schon seit einiger Zeit ein Register Script auf die Flyff Pserver HP einzubinden(Offi V14), aber immer wenn ich auf "Account erstellen" klicke, kommt dieser Fehler:
Hier die register.php(angegebene Zeile markiert):Quote:
Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\register.php on line 240
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ultimate Alliance :: Register</title>
<link rel="stylesheet" type="text/css" href="default.css" />
<center>
<div class="laufschrift"><font size="4px"><marquee><font color="white">Willkommen auf der Homepage von Ultimate Alliance</font color></marquee></font size>
<img src="img/lauftex" ></center>
<center>
<img src="img/Header/header.png" >
</center>
</head>
<body>
<div class="main">
<br clear="all" />
<!-- Navigation -->
<div class="navigation">
<a href="index.php"><img src="img/Buttons/Home.png" alt="News" /></a>
<a href="forum.php" target="_blank"><img src="img/Buttons/Forum.png" alt="Forum" /></a>
<a href="register.php"><img src="img/Buttons/Register.png" alt="Register" /></a>
<a href="ranking.php"><img src="img/Buttons/Ranking.png" alt="Ranking" /></a>
<a href="team.php"><img src="img/Buttons/Team.png" alt="Team" /></a>
<a href="chat.php"><img src="img/Buttons/Chat.png" alt="Chat" /></a>
<a href="download.php"><img src="img/Buttons/Downloads.png" alt="Downloads" /></a>
</div>
<!-- Navigation Ende --> <br><!-- Left Side -->
<br>
<br>
<div class="" >
<img src="img/" >
<br>
<br>
<div class="linke_seite">
<!-- Serverrates -->
<img src="img/Serverrates.png" alt="Serverrates" />
<div class="panel_box01" >
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">Exp:</div></th>
<td><div align="right"> x500</div></td>
</tr>
<tr>
<th scope="row"><div align="left">Drop:</div></th>
<td><div align="right"> x20</div></td>
</tr>
<tr>
<th scope="row"><div align="left">Penya:</div></th>
<td><div align="right"> x200</div></td></center>
</tr>
<tr>
<th scope="row"><div align="left">Regen Event:</div></th>
<td><div align="right"> x2 EXP</div></td>
</tr>
</tbody></table>
______________________
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">User Online:</div></th>
<td><div align="right"><src="configs/online.php"></div></td>
</tr>
<tr>
<th scope="row"><div align="left">Accounts:</div></th>
<td><div align="right"><src="configs/acc.php"></div></td>
</tr>
<tr>
<th scope="row"><div align="left">Character:</div></th>
<td><div align="right"><src="configs/char.php"></div></td></center>
</tr>
</tbody></table>
______________________<br>
<h1>Vote</h1>
<!-- topofgames.com -->
<a href="http://topofgames.com/index.php?do=votes&id=21834"><img border="0" src="http://pics.livejournal.com/samaritanyn/pic/0006xbhs.gif" alt="topofgames.com" /></a>
<!-- /topofgames.com -->
<br>
<br>
<br>
<center>
</div>
<div class="panel_box01_1" >
<img src="img/panel_box01_1.png" />
</div>
<!-- Serverrates Ende --> <!-- Support -->
<center>
<img src="img/support.png" alt="Support" />
<div class="panel_box02">
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">Skype:</div></th>
<td><div align="right">.......</div></div></td>
</tr>
<tr>
<th scope="row"><div align="left">E-Mail:</div></th>
<td><div align="right">.....@....de</div></td>
</tr>
</tbody></table>
<br>
<br>
<br>
</div>
<div class="panel_box02_2" >
<img src="img/panel_box02_2.png" />
</div>
<!-- Support Ende -->
</div>
<!-- Linke Seite Ende --> <!-- Rechte Seite -->
<div class="rechte_seite" >
<!-- Server Status -->
<img src="img/Serverstatus.png" alt="Serverstatus" />
<div class="panel_box03" >
<center>
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<b><br>- Account Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/Online.png">';
}
else {
echo '<img src="img/Buttons/Offline.png">';
}
?> <br />
<b><br>- Login Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?><br>
<b><br>- PopCrank 1-1 -<br><b>
<?php
$online = @fsockopen("127.0.0.1", 12001, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?><br>
<b><br>- World Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 2101, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?>
<br>
<br>
</div>
<div class="panel_box03_3" >
<img src="img/panel_box03_3" />
</div>
<br>
<br>
<!-- Server Status Ende -->
<center>
<?php
$ip=GetEnv("REMOTE_ADDR");
echo "Deine Ip: $ip"
?><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<a href="http://www.****************/" ><img src="img/Buttons/sponsor.png" alt="Mmorpg-Core" /></a>
<br>
<a href="http://www.elitepvpers.com/forum/" ><img src="img/Buttons/sponsor01.png" alt="Elite PVP" /></a>
<br>
<a href="http://www.************/" ><img src="img/Buttons/sponsor02.png" alt="********" /></a>
<br>
</div>
<br>
<br>
<br>
<!-- Rechte Seite Ende --> <!-- Mitte -->
<div class="mittelfeld" >
<div class="content">
<div class="panel_main">
<h1><u>Register:</u></h1>
<?php
include "functions.php";
if(isset($_POST['submit']))
{
$server = "****\SQLEXPRESS";
$user = "****";
$pass= "****";
$username = strtolower(trim(htmlspecialchars(addslashes($_POST['username']))));
$password = md5("0900sas9!00".$_POST['password']);
$ip = trim(htmlspecialchars($_POST['ip']));
################################################## ###########
if(strlen($username) < 4 ||
strlen($username) > 16)
{
die("Dein Benutzername ist zu kurz/lang .<br>Er muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
if(strlen($_POST['password']) < 4 ||
strlen($_POST['password']) > 16)
{
die("Dein Passwort ist zu kurz/lang .<br>Es muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
################################################## ###########
$conn = mssql_connect($server,$user,$pass);
if(!$conn)
{
die("Connection failed!<br>");
}
$select = mssql_select_db("ACCOUNT_DBF",$conn);
if(!$select)
{
die("Can't select Database!<br>");
}
################################################## ###########
if(exist($username) != '0')
{
die ("Der Benutzername ".$username." wird schon benutzt .");
}
if(existip($ip) >= '2')
{
die("Du hast schon genug Accounts erstellt.");
}
################################################## ###########
$bind = mssql_init("createaccount",$conn);
if(!$bind)
{
die("Couldn't Bind Variables.<br>");
}
$acc = $username;
$pass = $password;
$ipadress = $ip;
mssql_bind($bind, '@account' , $acc , SQLVARCHAR);
mssql_bind($bind, '@password', $pass, SQLVARCHAR);
mssql_bind($bind, '@ipadress', $ip , SQLVARCHAR);
$execute = mssql_execute($bind);
if($execute)
{
echo 'Account wurde <font color="green">erfolgreich</font> erstellt !';
}
else
{
echo 'Account erstellung<font color="red">fehlgeschlagen</font> !';
}
mssql_close($conn);
}
else
{
?>
<center>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table>
<tr>
<td colspan="2" align ="center">
<h3>Account erstellen</h3>
</td>
</tr>
<tr>
<td align ="right">
Account :
</td>
<td>
<input type="text" size="20" name="username" maxlength="15" />
</td>
<td> </td>
</tr>
<tr>
<td align ="right">
Passwort :
</td>
<td>
<input type="password" size="20" name="password" maxlength="32" />
</td>
</tr>
<tr>
<td>
<input type="hidden" size="20" name="ip" maxlength="32" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="Account erstellen" />
</td>
</tr>
</table>
</form>
</center>
<?php
}
?>
</center>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</div>
<div class="panel_main_1" >
<img src="img/" />
</div>
</div>
</div>
</div>
<!-- Mitte Ende -->
<!-- Footer -->
<br>
<div class="footer">
<center>
<h1><font size="3px"></font>Copyright © <a href="http://DarkNetwork.000a.de">DarkNetwork</a></font size></h1> <br>
</div>
<!-- Footer Ende -->
</div>
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ultimate Alliance :: Register</title>
<link rel="stylesheet" type="text/css" href="default.css" />
<center>
<div class="laufschrift"><font size="4px"><marquee><font color="white">Willkommen auf der Homepage von Ultimate Alliance</font color></marquee></font size>
<img src="img/lauftex" ></center>
<center>
<img src="img/Header/header.png" >
</center>
</head>
<body>
<div class="main">
<br clear="all" />
<!-- Navigation -->
<div class="navigation">
<a href="index.php"><img src="img/Buttons/Home.png" alt="News" /></a>
<a href="forum.php" target="_blank"><img src="img/Buttons/Forum.png" alt="Forum" /></a>
<a href="register.php"><img src="img/Buttons/Register.png" alt="Register" /></a>
<a href="ranking.php"><img src="img/Buttons/Ranking.png" alt="Ranking" /></a>
<a href="team.php"><img src="img/Buttons/Team.png" alt="Team" /></a>
<a href="chat.php"><img src="img/Buttons/Chat.png" alt="Chat" /></a>
<a href="download.php"><img src="img/Buttons/Downloads.png" alt="Downloads" /></a>
</div>
<!-- Navigation Ende --> <br><!-- Left Side -->
<br>
<br>
<div class="" >
<img src="img/" >
<br>
<br>
<div class="linke_seite">
<!-- Serverrates -->
<img src="img/Serverrates.png" alt="Serverrates" />
<div class="panel_box01" >
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">Exp:</div></th>
<td><div align="right"> x500</div></td>
</tr>
<tr>
<th scope="row"><div align="left">Drop:</div></th>
<td><div align="right"> x20</div></td>
</tr>
<tr>
<th scope="row"><div align="left">Penya:</div></th>
<td><div align="right"> x200</div></td></center>
</tr>
<tr>
<th scope="row"><div align="left">Regen Event:</div></th>
<td><div align="right"> x2 EXP</div></td>
</tr>
</tbody></table>
______________________
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">User Online:</div></th>
<td><div align="right"><src="configs/online.php"></div></td>
</tr>
<tr>
<th scope="row"><div align="left">Accounts:</div></th>
<td><div align="right"><src="configs/acc.php"></div></td>
</tr>
<tr>
<th scope="row"><div align="left">Character:</div></th>
<td><div align="right"><src="configs/char.php"></div></td></center>
</tr>
</tbody></table>
______________________<br>
<h1>Vote</h1>
<!-- topofgames.com -->
<a href="http://topofgames.com/index.php?do=votes&id=21834"><img border="0" src="http://pics.livejournal.com/samaritanyn/pic/0006xbhs.gif" alt="topofgames.com" /></a>
<!-- /topofgames.com -->
<br>
<br>
<br>
<center>
</div>
<div class="panel_box01_1" >
<img src="img/panel_box01_1.png" />
</div>
<!-- Serverrates Ende --> <!-- Support -->
<center>
<img src="img/support.png" alt="Support" />
<div class="panel_box02">
<center>
<legend> <font color="green"></font> </legend>
<table border="0" width="179">
<tbody><tr>
<th scope="row"><div align="left">Skype:</div></th>
<td><div align="right">.......</div></div></td>
</tr>
<tr>
<th scope="row"><div align="left">E-Mail:</div></th>
<td><div align="right">.....@....de</div></td>
</tr>
</tbody></table>
<br>
<br>
<br>
</div>
<div class="panel_box02_2" >
<img src="img/panel_box02_2.png" />
</div>
<!-- Support Ende -->
</div>
<!-- Linke Seite Ende --> <!-- Rechte Seite -->
<div class="rechte_seite" >
<!-- Server Status -->
<img src="img/Serverstatus.png" alt="Serverstatus" />
<div class="panel_box03" >
<center>
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<b><br>- Account Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/Online.png">';
}
else {
echo '<img src="img/Buttons/Offline.png">';
}
?> <br />
<b><br>- Login Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?><br>
<b><br>- PopCrank 1-1 -<br><b>
<?php
$online = @fsockopen("127.0.0.1", 12001, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?><br>
<b><br>- World Server -<br></b>
<?php
$online = @fsockopen("127.0.0.1", 2101, $errno, $errstr, 1);
if($online >= 1) {
echo '<img src="img/Buttons/online.png">';
}
else {
echo '<img src="img/Buttons/offline.png">';
}
?>
<br>
<br>
</div>
<div class="panel_box03_3" >
<img src="img/panel_box03_3" />
</div>
<br>
<br>
<!-- Server Status Ende -->
<center>
<?php
$ip=GetEnv("REMOTE_ADDR");
echo "Deine Ip: $ip"
?><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<a href="http://www.****************/" ><img src="img/Buttons/sponsor.png" alt="Mmorpg-Core" /></a>
<br>
<a href="http://www.elitepvpers.com/forum/" ><img src="img/Buttons/sponsor01.png" alt="Elite PVP" /></a>
<br>
<a href="http://www.************/" ><img src="img/Buttons/sponsor02.png" alt="********" /></a>
<br>
</div>
<br>
<br>
<br>
<!-- Rechte Seite Ende --> <!-- Mitte -->
<div class="mittelfeld" >
<div class="content">
<div class="panel_main">
<h1><u>Register:</u></h1>
<?php
include "functions.php";
if(isset($_POST['submit']))
{
$server = "****\SQLEXPRESS";
$user = "****";
$pass= "****";
$username = strtolower(trim(htmlspecialchars(addslashes($_POST['username']))));
$password = md5("0900sas9!00".$_POST['password']);
$ip = trim(htmlspecialchars($_POST['ip']));
################################################## ###########
if(strlen($username) < 4 ||
strlen($username) > 16)
{
die("Dein Benutzername ist zu kurz/lang .<br>Er muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
if(strlen($_POST['password']) < 4 ||
strlen($_POST['password']) > 16)
{
die("Dein Passwort ist zu kurz/lang .<br>Es muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
################################################## ###########
$conn = mssql_connect($server,$user,$pass);
if(!$conn)
{
die("Connection failed!<br>");
}
$select = mssql_select_db("ACCOUNT_DBF",$conn);
if(!$select)
{
die("Can't select Database!<br>");
}
################################################## ###########
if(exist($username) != '0')
{
die ("Der Benutzername ".$username." wird schon benutzt .");
}
if(existip($ip) >= '2')
{
die("Du hast schon genug Accounts erstellt.");
}
################################################## ###########
$bind = mssql_init("createaccount",$conn);
if(!$bind)
{
die("Couldn't Bind Variables.<br>");
}
$acc = $username;
$pass = $password;
$ipadress = $ip;
mssql_bind($bind, '@account' , $acc , SQLVARCHAR);
mssql_bind($bind, '@password', $pass, SQLVARCHAR);
mssql_bind($bind, '@ipadress', $ip , SQLVARCHAR);
$execute = mssql_execute($bind);
if($execute)
{
echo 'Account wurde <font color="green">erfolgreich</font> erstellt !';
}
else
{
echo 'Account erstellung<font color="red">fehlgeschlagen</font> !';
}
mssql_close($conn);
}
else
{
?>
<center>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table>
<tr>
<td colspan="2" align ="center">
<h3>Account erstellen</h3>
</td>
</tr>
<tr>
<td align ="right">
Account :
</td>
<td>
<input type="text" size="20" name="username" maxlength="15" />
</td>
<td> </td>
</tr>
<tr>
<td align ="right">
Passwort :
</td>
<td>
<input type="password" size="20" name="password" maxlength="32" />
</td>
</tr>
<tr>
<td>
<input type="hidden" size="20" name="ip" maxlength="32" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="Account erstellen" />
</td>
</tr>
</table>
</form>
</center>
<?php
}
?>
</center>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</div>
<div class="panel_main_1" >
<img src="img/" />
</div>
</div>
</div>
</div>
<!-- Mitte Ende -->
<!-- Footer -->
<br>
<div class="footer">
<center>
<h1><font size="3px"></font>Copyright © <a href="http://DarkNetwork.000a.de">DarkNetwork</a></font size></h1> <br>
</div>
<!-- Footer Ende -->
</div>
</body>
</html>
und die functions.php:
<?php
function exist($account){
$sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'";
$result = mssql_query($sql);
if(!$result) {
die("MSSQL Error");
}
$check = mssql_num_rows($result);
return $check;
}
function existip($ip){
$sql = "SELECT * FROM ACCOUNT_TBL_DETAIL WHERE ip='".$ip."'";
$result = mssql_query($sql);
if(!$result) {
die("MSSQL Error");
}
$check = mssql_num_rows($result);
return $check;
}
?>
function exist($account){
$sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'";
$result = mssql_query($sql);
if(!$result) {
die("MSSQL Error");
}
$check = mssql_num_rows($result);
return $check;
}
function existip($ip){
$sql = "SELECT * FROM ACCOUNT_TBL_DETAIL WHERE ip='".$ip."'";
$result = mssql_query($sql);
if(!$result) {
die("MSSQL Error");
}
$check = mssql_num_rows($result);
return $check;
}
?>
Hab alles versucht, regi Script hab ich übrigens von den Homepage Addons von Jusikid([Only registered and activated users can see links. Click Here To Register...])
Hoffe, ihr könnt mir weiterhelfen.
Mfg. Pumbaaa