Registered Server locked

Duffman_DK · #1 11-09-2016, 06:09 PM

Hello.
I'm new to the EQEmu universe, but as an old EQ gamer, I tried to setup my own server. And with Akkas peq installer, it was very easy

I have recently used Akkas peq installer to setup my server.
Everything works fine, and server is listed in server list, But as an unregistered server.
Have created an WS account, and entered the account and password in the eqemu_config.xml file.
But something goes wrong after using the loginserver.
After starting the server, in the Server List, the status is first "pending" and short after "locked". And the server is not listed in the client.

My eqemu_config file:

Code:

<?xml version="1.0">
<server>
	<world>
		<shortname>Duffmans EQ Server</shortname>
		<longname>Duffmans EQ Server - Custom xp</longname>


		<loginserver1>
			<host>login.eqemulator.net</host>
			<port>5998</port>
			<account>WS Accountname</account>
			<password>WS Password</password>
		</loginserver1>
		<loginserver2>
			<host>192.168.xxx.xxx (LAN IP of computer running server)</host>
			<port>5998</port>
			<account>WS Accountname</account>
			<password>WS Password</password>
		</loginserver2>



		<tcp ip="192.168.xxx.xxx" port="9000" telnet="enable"/>

		<key>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</key>

		<http port="9080" enabled="true" mimefile="mime.types" />
	</world>

I have also tried this configuration in eqemu_config:

Code:

<?xml version="1.0">
<server>
	<world>
		<shortname>Duffmans EQ Server</shortname>
		<longname>Duffmans EQ Server - Custom xp</longname>


		<loginserver1>
			<host>xxx.xxx.xxx.xxx (WAN IP)</host>
			<port>5998</port>
			<account>WS Accountname</account>
			<password>WS Password</password>
		</loginserver1>
		<loginserver2>
			<host>192.168.xxx.xxx (LAN IP of computer running server)</host>
			<port>5998</port>
			<account>WS Accountname</account>
			<password>WS Password</password>
		</loginserver2>



		<tcp ip="192.168.xxx.xxx" port="9000" telnet="enable"/>

		<key>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</key>

		<http port="9080" enabled="true" mimefile="mime.types" />
	</world>

Then I get this error in the EQEmu Login Server cmd window:

Any help in order to get my registered server up and running would be greatly appreciated.
Thanks!
-Duffman_DK

javewow · #2 12-12-2016, 11:08 PM

Need to use the web to register a account

------confi.php----
<?php

$config['mysql_host'] = 'localhost'; //MySQL Host
$config['mysql_user'] = 'root'; //MySQL Username
$config['mysql_pass'] = 'eqemu'; //MySQL Password
$config['mysql_dbname'] = 'Akkpeq'; //Database Name

?>

---------account.php-----
<?php

//Recoding noriac

//includes
//require_once "maincore.php";
//require_once "subheader.php";
//require_once "side_left.php";
?>
<html>
<head><title><?php echo "$conf[browsertitle]"; $d = P;?></title><link rel="StyleSheet" type="text/css" MEDIA="screen" href="test.css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">

</style></head>
<body>
<center>

<div class="container">

<div class="container_body">
<div class="container_top">
<h1><?php echo "$lang[header]"; $lampstn="- ";?></h1>
</div>
<div class="container_left">
</div>
<div class="container_right">
</div>

<?php
/* Recoded Page for ascent
* This is just a simple registration page for Ascent
*/

// Settings -------------------------------------------------------------------------------
include_once "game_config.php";
// Database Connection -------------------------------------------------------------
// You should not need to change these two, unless you know what you are doing and know you need to.
$Con = mysql_connect($Host,$Username,$Password) or die ("Error connecting to the mysql server!");
$DB = mysql_select_db($Database) or die ("Error selecting the database!");
// Start forming the page -------------------------------------------------------------
$HTML = ""; // This will be used to store all the HTML and print it out in the end.
// HTML Header Var.
$HTML .= "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\"
\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">";
$HTML .= "<html><head><title>$Title</title></head>";
$HTML .= "<body>";
// Get the mode we are in.
// Anti-Script Injection
$search = array(
'@<script[^>]*?>.*?</script>@si', // Strip out javascript
'@<style[^>]*?>.*?</style>@siU', // Strip style tags properly
'@<[\/\!]*?[^<>]*?>@si', // Strip out HTML tags
'@<![\s\S]*?--[ \t\n\r]*>@' // Strip multi-line comments including CDATA
);

$MODE = htmlspecialchars(preg_replace($search, '', $_GET['m']), ENT_QUOTES);
if (($MODE == null || !isset($MODE)) && $AllowReg)
{
if ($ShowWarning)
{
$HTML .= "<fieldset><legend> Warning: </legend>";
$HTML .= "For your accounts security, please do not make your username, or password the same as any other";
$HTML .= "<br /> account information you use on another website, dispite what people say, it <b>is</b> possible";
$HTML .= "<br /> for people to recover your account information. Thank you.";
$HTML .= "</fieldset>";
}
$HTML .= "<br />";
$HTML .= "<form method='post' action='game_acc.php?m=submit'>";
$HTML .= "<table cellspacing = '0' cellpadding = '0' border = '0'>";
$HTML .= "<tr><td>Username:</td><td> <input type='text' name='Username' id='Username' /></td></tr>";
$HTML .= "<tr><td>Password:</td><td> <input type='password' name='password' id='password' /></td></tr>";
$HTML .= "<tr><td>Retype Password:</td><td> <input type='password' name='passconf' id='passconf' /></td></tr>";
$HTML .= "<tr><td>E-Mail:</td><td> <input type='text' name='email' id='email' /></td></tr>";
// Get the TBC settings.
if ($AllowTBC && !$ForceTBC)
{
//$HTML.= "<tr><td></td><td><input type='checkbox' name='tbc' id='tbc' /></td></tr>";
}
$HTML .= "<tr><td></td><td><input type='submit' value='Submit' /></td></tr>";
$HTML .= "</table>";
$HTML .= "</form>";
//$HTML .= "</fieldset>";
} else if ($MODE == "submit" && $AllowReg)
{
// Being system of checks.
$Username = htmlspecialchars(preg_replace($search, '', $_POST['Username']), ENT_QUOTES);
$Password = htmlspecialchars(preg_replace($search, '', $_POST['password']), ENT_QUOTES);
$PassConf = htmlspecialchars(preg_replace($search, '', $_POST['passconf']), ENT_QUOTES);
$Email = htmlspecialchars(preg_replace($search, '', $_POST['email']), ENT_QUOTES);
$ip = $_SERVER['REMOTE_ADDR'];
$Username = mysql_real_escape_string($Username);
$Password = mysql_real_escape_string($Password);
$PassConf = mysql_real_escape_string($PassConf);
$Email = mysql_real_escape_string($Email);
$HTML .= "<p>";
if ($AllowTBC && !$ForceTBC)
{
$TBC = htmlspecialchars(preg_replace($search, '', $_POST['tbc']), ENT_QUOTES);
}
$Continue = true;
if ($Username == null || $Username == "")
{
$HTML .="<br /><b> You must enter a username!</b>";
$Continue = false;
}
if ($Password == null || $Password == "")
{
$HTML .="<br /><b> You must enter a password!</b>";
$Continue = false;
}
if ($PassConf == null || $PassConf == "")
{
$HTML .="<br /><b> You must enter a confirmation password!</b>";
$Continue = false;
}
if ($PassConf != $Password)
{
$HTML .="<br /><b> Your passwords did not match!</b>";
$Continue = false;
}
if ($Email == null || $Email == "")
{
$HTML .="<br /><b> You must enter an e-mail!</b>";
$Continue = false;
}
// check if already registered.
$UserCheck = mysql_query("SELECT name FROM login_accounts WHERE name = '$Username'");
if (mysql_num_rows($UserCheck) > 0)
{
$HTML .= "<br /><b> This username is already registered, please select another</b>";
$Continue = false;
}
// Check if this IP has more than the accounts per IP limit
$UserCheck = mysql_query("SELECT ip FROM login_accounts WHERE ip = '$ip'");
if (mysql_num_rows($UserCheck) > $AccsPerIP)
{
$HTML .= "<br /><b> You have reached your maximum amount of accounts, which is currently: $AccsPerIP </b>";
$Continue = false;
}
// Check to make sure the e-mail is valid
if (!ereg("^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$",$Email))
{
$HTML .= "<br /><b> You have entered an invalid e-mail! E-Mails should be in the form user@domain.com</b>";
$Continue = false;
}
$HTML .= "</p>";
if ($Continue)
{
// Register the account.
if ($ForceTBC)
{
$Flag = 1;
} else if ($AllowTBC)
{
if ($TBC)
{
$Flag = 1;
} else
{
$Flag = 0;
}
}
mysql_query("INSERT INTO `login_accounts` (`name`,`password`,`email`,`ip`,`user_active`) VALUES ('$Username','".(md5($password))."','$Email','$ip' ,'1')")
or die("Error creating your Account!");
// Check to make sure it was actually registered
$Check = mysql_query("SELECT name FROM login_accounts WHERE name = '$Username'");
$HTML .= "<p>";
if (mysql_num_rows($Check) == 1)
{
$HTML .= "<br />Your account was registered!<br><b>It may take up to 5 to 10 min before it becomes active</b>";
} else
{
$HTML .= "<br />There was an error registering your account!";
}
$HTML .= "</p>";
} else
{

if ($ShowWarning)
{
$HTML .= "<fieldset><legend> Warning: </legend>";
$HTML .= "For your accounts security, please do not make your username, or password the same as any other";
$HTML .= "<br /> account information you use on another website, dispite what people say, it <b>is</b> possible";
$HTML .= "<br /> for people to recover your account information. Thank you.";
$HTML .= "</fieldset>";
}
$HTML .= "<form method='submit' action='game_acc.php'>";
$HTML .= "<table cellspacing = '0' cellpadding = '0' border = '0'>";
//$HTML .= "<tr><td>Username:</td><td> <input type='text' name='Username' id='Username' /></td></tr>";
//$HTML .= "<tr><td>Password:</td><td> <input type='password' name='password' id='password' /></td></tr>";
//$HTML .= "<tr><td>Retype Password:</td><td> <input type='password' name='passconf' id='passconf' /></td></tr>";
//$HTML .= "<tr><td>E-Mail:</td><td> <input type='text' name='email' id='email' /></td></tr>";
// Get the TBC settings.
if ($AllowTBC && !$ForceTBC)
{
$HTML.= "";
}
$HTML .= "<tr><td></td><td><input type='submit' value='Reload Page' /></td></tr>";
$HTML .= "</table>";
$HTML .= "</form>";
//$HTML .= "</fieldset>";
}
} else if (!$AllowReg)
{
$HTML .= "<p><b> Sorry, but registration is currently closed, please try again later </b></p>";
}
$HTML .= "</body></html>";

echo $HTML;
mysql_close($Con);

?>
</div>

</body>
</html>

</center>