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">[email protected]</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">[email protected]</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(
)Hoffe, ihr könnt mir weiterhelfen.
Mfg. Pumbaaa
