AAPDRDS fix

Subject: AAPDRDS fix Thu 05 Nov 2009, 6:04 pm

Ok so i was helping one of the people from mmowned with AAPDRDS donation system.

And i found out the script was written with 2 mistakes, that is why most of the people cannot get it working.

here is why

index..php

Code:: }
else
{
$con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
mysql_select_db(MYSQL_DATA);
$res = mysql_query("SELECT entry,name FROM realms");
$REALMS = "{";
while($row = mysql_fetch_array($res))
{
$REALMS .= ((int)$row['entry']-1).":\"".$row['name']."\",";

this is wrong

Code:: $res = mysql_query("SELECT entry,name FROM realms");

Code:: $REALMS .= ((int)$row['entry']-1).":\"".$row['name']."\",";

has to be

Code:: $res = mysql_query("SELECT id,name FROM realms");

Code:: $REALMS .= ((int)$row['id']-1).":\"".$row['name']."\",";

has to be like this

Code:: header("Cache-control: no-cache, must-revalidate\r\n");
require_once("config.php");
if(isset($_GET['char']))
{
$con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
mysql_select_db(MYSQL_DATA);
$Name = mysql_real_escape_string($_GET['char']);
$Realm = mysql_real_escape_string($_GET['realm']);
$Realm = (int)$Realm+1;
$res = mysql_query("SELECT sqlhost,sqluser,sqlpass,chardb FROM realms WHERE id='{$Realm}'");
$row = mysql_fetch_array($res);
mysql_close($con);
$con = mysql_connect($row['sqlhost'],$row['sqluser'],$row['sqlpass']);
mysql_select_db($row['chardb']);
$res = mysql_query("SELECT guid FROM characters WHERE name='{$Name}'");
if(mysql_num_rows($res) == 1)
{
$row = mysql_fetch_array($res);
echo $row['guid'];
}
else
{
echo "0";
die;
}
mysql_close($con);
}
else
{
$con = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS);
mysql_select_db(MYSQL_DATA);
$res = mysql_query("SELECT id,name FROM realms");
$REALMS = "{";
while($row = mysql_fetch_array($res))
{
$REALMS .= ((int)$row['id']-1).":\"".$row['name']."\",";
}
$REALMS .= "\"undefined\":0}";
$res = mysql_query("SELECT entry,name,realm,description,price FROM rewards");
$REWARDS = "{";
while($row = mysql_fetch_array($res))
{
$REWARDS .= ((int)$row['entry']-1).":{name:\"".$row['name']."\",realm:".((int)$row['realm']-1).",description:\"".addslashes($row['description'])."\",price:".$row['price']."},";
$DESCRIPTIONS .= "".$row['description']."
";
}
$REWARDS .= "\"undefined\":0}";
$REWARDS = str_replace("\r","\\r",$REWARDS);
$REWARDS = str_replace("\n","\\n",$REWARDS);
include("form.php");
mysql_close($con);
}
?>