Dear Sir / Madam ,
We’re writing a script unstuck ASP.NET language.
Which fields from the database “Characters” to update for
unstuck character/S ?
I got a sample file.
However, some fields use in the file PHP is not Database trinitycore.
<?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>";
?>
For EXample :
//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.“'”;
Fileds : deathstate , player_flags , auras
Sorry. tour English is bad.