unstuck one logon two character db and two worlds

**snake eyes** · 03-02-2009

hi
i made a php script unstuck u can use it at one relam with two database and one logon the only proplem with it that if a player got the same char name at both database it will chose the first but at least its tested and it works
here the config

Code:

<?php

//account database info
$aHost = "127.0.0.1";
$aDatabase = "logon";
$aPort = "3307";
$aUsername = "root";
$aPass = "mangos";

//character database info
$cHost = "127.0.0.1";
$cDatabase = "char_blizz";
$cDatabase2 = "char_fun";
$cPort = "3307";
$cUsername = "root";
$cPass = "mangos";

?>

and the php script it self as follow (dont forget to reply)

Code:

the right one as in the next replay

as u see its masy but it works i have been working on it for the last three days
and there is some variable that i did not use but i wanted to be the first to release such a thing

**snake eyes** · 03-04-2009

bleave it or not my computer crashed before ibackup the right script sorry about that i have relaised i posted the wrong one here it is the right script nad it's only for reviving wishing u good luck
<?php

echo "<html><body>";
echo "<center><table>";
echo "<tr><td colspan=2 align=center></td></tr>";

include('_config.php');
global $aHost, $aDatabase, $aPort, $aUsername, $aPass, $cHost, $cDatabase, $cDatabase2, $cPort, $cUsername, $cPass;

if(isset($_POST['submit']))
{
$account = $_POST['account'];
$password = $_POST['password'];
$character = $_POST['character'];

$acct = "";

//get make sure the character exists on the correct account and password is the same
$con = mysql_connect($aHost.":".$aPort, $aUsername, $aPass) or die(mysql_error());
mysql_select_db($aDatabase) or die(mysql_error());

//Remove bullshit characters from user entered data
$account = mysql_real_escape_string($account);
$password = mysql_real_escape_string($password);
$acct = mysql_real_escape_string($acct);

$query = "SELECT acct FROM accounts WHERE login ='".$account."' AND password = '".$password."'";

$result = mysql_query($query) or die(mysql_error());
$numrows = mysql_num_rows($result);

//if no rows, user entered invalid data
if ($numrows == 0)
{
die("Account name or password is incorrect!");
}
elseif ($numrows == 1)
{

$row = mysql_fetch_array($result);
$acct = $row[0];

//get accnt# from characters table where the name is character $character
$con = mysql_connect($cHost.":".$cPort, $cUsername, $cPass) or die(mysql_error());
mysql_select_db($cDatabase) or die(mysql_error());

//Remove bullshit characters from user entered data
$character = mysql_real_escape_string($character);

$query = "SELECT acct FROM characters WHERE name = '".$character."'";

$result = mysql_query($query) or die(mysql_error());
$numrows = mysql_num_rows($result);

echo "<tr><td align=center>";

//if no rows exist, the character does not exist

if($numrows == 0)
{

$con = mysql_connect($cHost.":".$cPort, $cUsername, $cPass) or die(mysql_error());
mysql_select_db($cDatabase2) or die(mysql_error());

$character = mysql_real_escape_string($character);

$query = "SELECT acct FROM characters WHERE name = '".$character."'";

$result = mysql_query($query) or die(mysql_error());
$numrows = mysql_num_rows($result);

echo "<tr><td align=center>";

//if no rows exist, the character does not exist
if($numrows == 0)

{
die("No such character exists on that account!");
}

elseif($numrows == 1)

{

$row = mysql_fetch_array($result);
$acct = $row[0];
}
}

//update the character table to set the character to hearth location
$query = "UPDATE `characters` SET `deathstate` = 0 , `player_flags` =0 , `auras` =0 WHERE name = '".$character."'";
mysql_query($query) or die(mysql_error());

}
$query = "UPDATE `characters` SET `deathstate` = 0 , `player_flags` =0 , `auras` =0 WHERE name = '".$character."'";
mysql_query($query) or die(mysql_error());
echo "<center>";
echo "<br />";
echo "<br />";
echo "The Character with the name '<b>".$character."</b>' under Account '<b>".$account."</b>' has been revived!<br>";
echo "<a href='/playertools/revive.php'>Back</a>";

echo "</td></tr>";

//close mysql connection
mysql_close();

}
//if page is loaded, display unstuck form
else
{

echo "<center>";
echo "<form name=myform method=post action'/revive.php'>";

echo "<br />";
echo "<h1><u><b>Character Revive</b></u></h1>";
echo "<br />";
echo "<tr><td width=125>Account: </td><td><input type=text name=account value=''></td></tr>";
echo "<br />";
echo "<tr><td width=125>Character: </td><td><input type=text name=character value=''></td></tr>";
echo "<br />";
echo "<tr><td width=125>Password: </td><td><input type=password name=password value=''></td></tr>";
echo "<br />";
echo "<tr><td colspan=2 align=center><br><input type=submit name=submit value=Revive></td></tr>";
echo "</form>";
}

echo "<center>";
echo "</table>";
echo "<br />";
echo "<br />";
echo "<small>You <b>MUST</b> be offline for this tool to successfully work</small><br /><br />";
echo "<br />";
echo " ";
echo "<br />";
echo "</center>";

?>

Shout-Out

User Tag List

Thread: unstuck one logon two character db and two worlds

Thread Tools

Search Thread

unstuck one logon two character db and two worlds

Similar Threads

[Selling] Atlantiss account with two characters (Rogue and Warrior, both on horde)

Looking for one or two people to help me get a 3.3.5a WOTLK Server up and running.

[SQL] How can i transfer characters from and arcemu server to one of trinity?

Glitchy's Model Swapper One Handed - Two Handed Problem!

2.4.3 and 3.0.9 whit one logon

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino