[REQUEST] A WOTLK registration site that creates GM Accounts.

[j03l]

Hello! This is almost like the other thread i created, but this is a request.

So, yeah. Ive been looking for a long time now for how to make your registration site create GM accounts instead of "normal" accounts. But cant seem to find anything.. So know i wonder if someone can create or now where i can download such a registration site?

[FaTaL-V1CT1M]

Hey m8, So ill help you out / atleast try to:
first get this
http://www.mmowned.com/forums/emulat...tion-page.html registrationspage by LaAevie all credits for it go to LaAevie!
Ok, Ok i accept it im dumb :P managed to do twice the same error... :P
Ok, here it is, should be working correctly now...
Download the regpage i linked above, then delete all code in the index.php file and replace it with this:

<?php

$db_host='localhost';
$db_user='root';
$db_pass='';
$db_name='logon';
$server_message='MESSAGE! GOOD PLACE FOR SERVER LOGIN ADDRESS!';


$db = new DBLayer($db_host, $db_user, $db_pass, $db_name, $db_prefix, $p_connect);

class DBLayer
{
var $prefix;
var $link_id;
var $query_result;

var $saved_queries = array();
var $num_queries = 0;


function DBLayer($db_host, $db_user, $db_pass, $db_name, $db_prefix, $p_connect)
{
$this->prefix = $db_prefix;

if ($p_connect)
$this->link_id = @mysql_pconnect($db_host, $db_user, $db_pass);
else
$this->link_id = @mysql_connect($db_host, $db_user, $db_pass);

if ($this->link_id)
{
if (@mysql_select_db($db_name, $this->link_id))
return $this->link_id;
else
error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}
}


function select_db($dbsel)
{

return @mysql_select_db($dbsel, $this->link_id);

}

function pun_htmlspecialchars($str)
{
$str = preg_replace('/&(?!#[0-9]+/s', '&amp;', $str);
$str = str_replace(array('<', '>', '"'), array('&lt;', '&gt;', '&quot;'), $str);

return $str;
}

function start_transaction()
{
return;
}


function end_transaction()
{
return;
}


function query($sql, $unbuffered = false)
{
if (defined('PUN_SHOW_QUERIES'))
$q_start = get_microtime();

if ($unbuffered)
$this->query_result = @mysql_unbuffered_query($sql, $this->link_id);
else
$this->query_result = @mysql_query($sql, $this->link_id);

if ($this->query_result)
{
if (defined('PUN_SHOW_QUERIES'))
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));

++$this->num_queries;

return $this->query_result;
}
else
{
if (defined('PUN_SHOW_QUERIES'))
$this->saved_queries[] = array($sql, 0);

return false;
}
}


function result($query_id = 0, $row = 0)
{
return ($query_id) ? @mysql_result($query_id, $row) : false;
}

function fetch_assoc($query_id = 0)
{
return ($query_id) ? @mysql_fetch_assoc($query_id) : false;
}


function fetch_row($query_id = 0)
{
return ($query_id) ? @mysql_fetch_row($query_id) : false;
}


function num_rows($query_id = 0)
{
return ($query_id) ? @mysql_num_rows($query_id) : false;
}


function affected_rows()
{
return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false;
}


function insert_id()
{
return ($this->link_id) ? @mysql_insert_id($this->link_id) : false;
}


function get_num_queries()
{
return $this->num_queries;
}


function get_saved_queries()
{
return $this->saved_queries;
}


function free_result($query_id = false)
{
return ($query_id) ? @mysql_free_result($query_id) : false;
}


function escape($str)
{
if (is_array($str))
return '';
else if (function_exists('mysql_real_escape_string'))
return mysql_real_escape_string($str, $this->link_id);
else
return mysql_escape_string($str);
}


function error()
{
$result['error_sql'] = @current(@end($this->saved_queries));
$result['error_no'] = @mysql_errno($this->link_id);
$result['error_msg'] = @mysql_error($this->link_id);

return $result;
}


function close()
{
if ($this->link_id)
{
if ($this->query_result)
@mysql_free_result($this->query_result);

return @mysql_close($this->link_id);
}
else
return false;
}
}

$flags=0;
if(!empty($_POST['TBC'])){
$flags=8;
}
if(!empty($_POST['WotLK'])){
$flags=24;
}



if (isset($_POST['action']))
{
$login = ereg_replace( "[^A-Za-z0-9]", "", $_POST['username'] );
if ($login=='')
{
$war1="<font color='red'>Type in a username!</font>";
}
else
{
$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE login = '".$db->escape($login)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war1="<font color='red'>Username '".$login."' already exist!</font>";
$db->select_db($db_name);
}
else
{
$pass1 = ereg_replace( "[^A-Za-z0-9]", "", $_POST['password'] );
$pass2 = ereg_replace( "[^A-Za-z0-9]", "", $_POST['password2'] );
if ($pass1=='')
{
$war2="<font color='red'>Type in a password!</font>";
}
else
{
if ($pass1<>$pass2)
{
$war2="<font color='red'>Passwords does not match!</font>";
}
else
{
$email = htmlspecialchars($_POST['email']);
if ($email=='')
{
$war3="<font color='red'>Type in a email!</font>";
}
else
{
$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE email = '".$db->escape($email)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war3="<font color='red'>Email '".$email."' is already in use!</font>";
$db->select_db($db_name);
}
else
{
$db->select_db($acc_db);
$result = $db->query("INSERT INTO accounts (login, password, gm, banned, email, flags) VALUES ('".$login."','".$pass1."','a','0','".$db->escape($email)."','".$flags."')") or die(mysql_error());

$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE login = '".$db->escape($login)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war5="<font color='#00FF00'>Your account has been successfully created account.<br><br>Username: ".$login."<br><br>Password: ".$pass1."</font>";
$db->select_db($db_name);
}
}
}
}
}
}
}
}
?>
<!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></title>
<style type="text/css";>
body {
background: #000000 url(background.png) top no-repeat;
margin: 10px;
cursor: default;
color: #FFF;
padding-top: 160px;
padding-right: 35px;

}
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #fff;
text-align: left;
vertical-align: top;
font-size: 13px;
}
</style>
</head>

<body>
<table align="center" border="0">
<tr>
<td>
<form action="" method="post">
<label for="username">Username:</label><br />
<input type="text" id="username" maxlength="20" name="username" /><br />
<label for="password">Password:</label><br />
<input type="password" id="password" maxlength="20" name="password" /><br />
<label for="password2">Confirm Password:</label><br />
<input type="password" id="password2" maxlength="20" name="password2" /><br />
<label for="email">Email Address:</label><br />
<input type="text" id="email" maxlength="40" name="email" /><br /><br />
<label for="expansions">World of Warcraft Version:</label><br />
<input type="checkbox" name= "TBC" value="tb">Burning Crusade<br />
<input type="checkbox" name="WotLK" value="ww">Wrath of the Lich King<br /><br />
<input type="submit" name="action" value="Create Account" />
</form>
</td>
</tr>
</table>
<center><br /><?php print $server_message; ?><br />
<?php echo $war1; echo $war2; echo $war3; echo $war4; echo $war5; ?></center>
</body>
</html>








works for me atleast

[j03l]

Hey m8, So ill help you out / atleast try to:
first get this
http://www.mmowned.com/forums/emulat...tion-page.html registrationspage by LaAevie all credits for it go to LaAevie!

It didnt work, it is still creating normal accounts, but thanks for trying anyway!

[FaTaL-V1CT1M]

Please report back if its working, or not :P ^^
GL

FaTaL-V1CT1M

[j03l]

Its almost right! The only problem is that type of account is a and it should be 3. ^^" Atleast in my repack 3 means GM. <:

[FaTaL-V1CT1M]

Ah, ok np, Easy change :P gimme few sec

[FaTaL-V1CT1M]

<?php

$db_host='localhost';
$db_user='root';
$db_pass='';
$db_name='logon';
$server_message='MESSAGE! GOOD PLACE FOR SERVER LOGIN ADDRESS!';


$db = new DBLayer($db_host, $db_user, $db_pass, $db_name, $db_prefix, $p_connect);

class DBLayer
{
var $prefix;
var $link_id;
var $query_result;

var $saved_queries = array();
var $num_queries = 0;


function DBLayer($db_host, $db_user, $db_pass, $db_name, $db_prefix, $p_connect)
{
$this->prefix = $db_prefix;

if ($p_connect)
$this->link_id = @mysql_pconnect($db_host, $db_user, $db_pass);
else
$this->link_id = @mysql_connect($db_host, $db_user, $db_pass);

if ($this->link_id)
{
if (@mysql_select_db($db_name, $this->link_id))
return $this->link_id;
else
error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}
}


function select_db($dbsel)
{

return @mysql_select_db($dbsel, $this->link_id);

}

function pun_htmlspecialchars($str)
{
$str = preg_replace('/&(?!#[0-9]+/s', '&amp;', $str);
$str = str_replace(array('<', '>', '"'), array('&lt;', '&gt;', '&quot;'), $str);

return $str;
}

function start_transaction()
{
return;
}


function end_transaction()
{
return;
}


function query($sql, $unbuffered = false)
{
if (defined('PUN_SHOW_QUERIES'))
$q_start = get_microtime();

if ($unbuffered)
$this->query_result = @mysql_unbuffered_query($sql, $this->link_id);
else
$this->query_result = @mysql_query($sql, $this->link_id);

if ($this->query_result)
{
if (defined('PUN_SHOW_QUERIES'))
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));

++$this->num_queries;

return $this->query_result;
}
else
{
if (defined('PUN_SHOW_QUERIES'))
$this->saved_queries[] = array($sql, 0);

return false;
}
}


function result($query_id = 0, $row = 0)
{
return ($query_id) ? @mysql_result($query_id, $row) : false;
}

function fetch_assoc($query_id = 0)
{
return ($query_id) ? @mysql_fetch_assoc($query_id) : false;
}


function fetch_row($query_id = 0)
{
return ($query_id) ? @mysql_fetch_row($query_id) : false;
}


function num_rows($query_id = 0)
{
return ($query_id) ? @mysql_num_rows($query_id) : false;
}


function affected_rows()
{
return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false;
}


function insert_id()
{
return ($this->link_id) ? @mysql_insert_id($this->link_id) : false;
}


function get_num_queries()
{
return $this->num_queries;
}


function get_saved_queries()
{
return $this->saved_queries;
}


function free_result($query_id = false)
{
return ($query_id) ? @mysql_free_result($query_id) : false;
}


function escape($str)
{
if (is_array($str))
return '';
else if (function_exists('mysql_real_escape_string'))
return mysql_real_escape_string($str, $this->link_id);
else
return mysql_escape_string($str);
}


function error()
{
$result['error_sql'] = @current(@end($this->saved_queries));
$result['error_no'] = @mysql_errno($this->link_id);
$result['error_msg'] = @mysql_error($this->link_id);

return $result;
}


function close()
{
if ($this->link_id)
{
if ($this->query_result)
@mysql_free_result($this->query_result);

return @mysql_close($this->link_id);
}
else
return false;
}
}

$flags=0;
if(!empty($_POST['TBC'])){
$flags=8;
}
if(!empty($_POST['WotLK'])){
$flags=24;
}



if (isset($_POST['action']))
{
$login = ereg_replace( "[^A-Za-z0-9]", "", $_POST['username'] );
if ($login=='')
{
$war1="<font color='red'>Type in a username!</font>";
}
else
{
$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE login = '".$db->escape($login)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war1="<font color='red'>Username '".$login."' already exist!</font>";
$db->select_db($db_name);
}
else
{
$pass1 = ereg_replace( "[^A-Za-z0-9]", "", $_POST['password'] );
$pass2 = ereg_replace( "[^A-Za-z0-9]", "", $_POST['password2'] );
if ($pass1=='')
{
$war2="<font color='red'>Type in a password!</font>";
}
else
{
if ($pass1<>$pass2)
{
$war2="<font color='red'>Passwords does not match!</font>";
}
else
{
$email = htmlspecialchars($_POST['email']);
if ($email=='')
{
$war3="<font color='red'>Type in a email!</font>";
}
else
{
$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE email = '".$db->escape($email)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war3="<font color='red'>Email '".$email."' is already in use!</font>";
$db->select_db($db_name);
}
else
{
$db->select_db($acc_db);
$result = $db->query("INSERT INTO accounts (login, password, gm, banned, email, flags) VALUES ('".$login."','".$pass1."','3','0','".$db->escape($email)."','".$flags."')") or die(mysql_error());

$db->select_db($acc_db);
$result = $db->query("SELECT login FROM accounts WHERE login = '".$db->escape($login)."' LIMIT 1") or die(mysql_error());
$rows = $db->num_rows($result);
if ($rows>=1)
{
$war5="<font color='#00FF00'>Your account has been successfully created account.<br><br>Username: ".$login."<br><br>Password: ".$pass1."</font>";
$db->select_db($db_name);
}
}
}
}
}
}
}
}
?>
<!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></title>
<style type="text/css";>
body {
background: #000000 url(background.png) top no-repeat;
margin: 10px;
cursor: default;
color: #FFF;
padding-top: 160px;
padding-right: 35px;

}
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #fff;
text-align: left;
vertical-align: top;
font-size: 13px;
}
</style>
</head>

<body>
<table align="center" border="0">
<tr>
<td>
<form action="" method="post">
<label for="username">Username:</label><br />
<input type="text" id="username" maxlength="20" name="username" /><br />
<label for="password">Password:</label><br />
<input type="password" id="password" maxlength="20" name="password" /><br />
<label for="password2">Confirm Password:</label><br />
<input type="password" id="password2" maxlength="20" name="password2" /><br />
<label for="email">Email Address:</label><br />
<input type="text" id="email" maxlength="40" name="email" /><br /><br />
<label for="expansions">World of Warcraft Version:</label><br />
<input type="checkbox" name= "TBC" value="tb">Burning Crusade<br />
<input type="checkbox" name="WotLK" value="ww">Wrath of the Lich King<br /><br />
<input type="submit" name="action" value="Create Account" />
</form>
</td>
</tr>
</table>
<center><br /><?php print $server_message; ?><br />
<?php echo $war1; echo $war2; echo $war3; echo $war4; echo $war5; ?></center>
</body>
</html>


try that one

[j03l]

Yes, it works! Thank you very much! ^^" +Rep

[FaTaL-V1CT1M]

Np m8, Glad i could help and thnx for the rep , Just PM me if you need any further assistance with web or smth

FaTaL-V1CT1M

[Apple Pi]

Fatal, next time you copy code please wrap it in [code], thanks.

 OM NOM NOM

[FaTaL-V1CT1M]

Yeh, srry was kinda tired yesterday ^^ and forgot it .. /shame
thanks for telling me tho

[chiem]

Well, it's really this part of the code that needs to change:


$result = $db->query("INSERT INTO accounts (login, password, gm, banned, email, flags) VALUES ('".$login."','".$pass1."','3','0','".$db->escape($email)."','".$flags."')") or


I don't know the code for Emulator's GM code, but the red area is where you'd put the GM level. For example, if admin is 1, then, all the accounts made would have admin power. I'm guessing that 2 is GM or Super GM i really don't know but, that's all you have to change
And the SQL code up above is the code that inserts the accounts into each SQL Database, so ya .