• Home
  • FAQ
  • Register
  • Log in
Welcome everyone to WWemu Community, You must be registered to post!
If you are looking for V.C.N






Log in

I forgot my password

Latest topics
» Need an unstuck
Tue 24 Nov 2009, 1:48 am by ombladon123

» Idea for Arena Rating and Arena Rewards
Mon 23 Nov 2009, 6:58 pm by Raddau

» shammy bug
Mon 23 Nov 2009, 12:35 pm by stomstrikes

» Gentlemen?
Mon 23 Nov 2009, 12:33 pm by stomstrikes

» Rous aka Zanukan attention please
Mon 23 Nov 2009, 2:36 am by ryonis

» I cant get my tokens when i vote.
Sun 22 Nov 2009, 12:26 pm by demonolator12345

» Hi again --- imweedy
Sat 21 Nov 2009, 11:04 pm by imweedy

» pizzabox2 whats ur name?
Sat 21 Nov 2009, 12:12 pm by yingyangi

» Epic Vendors. Mangos 3.2.3, Trinity 3.1.3, Arc-EMu
Thu 19 Nov 2009, 10:22 am by Veldor

» Congrats..
Sat 14 Nov 2009, 5:23 pm by ultininja

» W00t
Thu 12 Nov 2009, 5:07 am by teres

» Vcn
Wed 11 Nov 2009, 10:47 am by Gnomepunter

» Warlock fears true teh walls :S
Wed 11 Nov 2009, 7:20 am by Roflnothaste

» ummmm wtf?
Wed 11 Nov 2009, 7:17 am by Roflnothaste

» V.C.N Website for any Emu
Mon 09 Nov 2009, 3:29 pm by thomja

» The different of the two servers :)
Mon 09 Nov 2009, 3:23 pm by Zanukan

» Sup!
Sun 08 Nov 2009, 9:58 pm by itsafarlen

» Heroes of Northrend 3.2.2
Sun 08 Nov 2009, 3:37 pm by thomja

» [Release]T9 Vendors, ArcEMU and Mangos
Sun 08 Nov 2009, 3:13 pm by thomja

» Read here!
Sun 08 Nov 2009, 8:58 am by Zanukan

Who is Online ?
In total there are 12 users online :: 0 Registered, 0 Hidden and 12 Guests :: 1 Bot

None

[ View the whole list ]


Most users ever online was 395 on Sun 18 May 2008, 11:28 am
Top posters
ServerBot (7646)
 
Swifteh (7171)
 
Charlie Face (4524)
 
Lisyhalath (3900)
 
Scruffay (3895)
 
kitch (3536)
 
Min0rity (3192)
 
Ubberpownage88 (3021)
 
bacongrease2 (2761)
 
Juicy (2649)
 

Rss feeds

Yahoo! 
Google Reader 
MSN 
AOL 
NewsGator 
Rojo 
Bloglines 


Keywords

Vent  haste  how  patch  realm  warlock  points  connect  server  vote  wotlk  vcn  cant  realmlist  Rogue  VIP  donation  pet  arena  voting  hunter  warrior  the  down  list  account  


AAPDRDS fix

Post new topic   Reply to topic

WWemu Community Forums :: Releases :: Websites

View previous topic View next topic Go down

AAPDRDS fix

Post by Zanukan on Thu 05 Nov 2009, 5: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);
    }
?>

_________________


Zanukan
WWemu Expert
WWemu Expert

Number of posts: 853
Age: 31
Joined: 2007-12-11
Points: 9124
Reputation: 3197

http://www.vcnserver.net

Back to top Go down

View previous topic View next topic Back to top

Post new topic   Reply to topic

WWemu Community Forums :: Releases :: Websites

Permissions of this forum:
You cannot reply to topics in this forum