Complete Pandora Installation Guide

THE COMPLETE PANDORA INSTALLATION GUIDE

STEP 1 : APACHE2TRIAD INSTALLATION

First of all we will work with Apache2Triad, not EasyPHP. Now go to [Only registered and activated users can see links. Click Here To Register...] download and download Apache2Triad 1.4.3 from a mirror. (about 70.30 MB. I know its big but it will solve all of your problems)

After you downloaded the Apache2Triad double click on it and start the setup process.

Pic 1 ? First Screen
[Only registered and activated users can see links. Click Here To Register...]
Then click the plus sign left of the ?create autostarting services? option.

Pic 2 ? Selecting autostarting services
[Only registered and activated users can see links. Click Here To Register...]

Now UNCHECK all options except ?Apache service? and MySQL service? as shown in Pic 3.

Pic 3 - Editing autostarting services
[Only registered and activated users can see links. Click Here To Register...]

Click ?Next?.

Now setup will ask you where to install Apache2Triad. Leave it alone and click ?Next?.

Pic 4 ? Selecting installation path
[Only registered and activated users can see links. Click Here To Register...]

Now it will ask you the main password which you will use for all Apache modules. It will also be the password for the ?root? user in mysql. Write to ?Enter new password? section ?12345678?. (except quotes).
Enter the same password to ?Re-enter password? section.

Pic 5 ? Setting the main password
[Only registered and activated users can see links. Click Here To Register...]

Now click ?Next?. It will show you the license agreement. Read it and if you agree with it click ?I Agree?.

Pic 6 ? License agreement
[Only registered and activated users can see links. Click Here To Register...]

Now the installation will start. Just sit back and enjoy it :)

Pic 7 ? Installation starts
[Only registered and activated users can see links. Click Here To Register...]

After installation is complete you will get this message:

Pic 8 ? Post configuration
[Only registered and activated users can see links. Click Here To Register...]

Click OK.

Apache2Triad setup will do some processes so stay tuned. After that you will get this screen :

Pic 9 ? Confirming password
[Only registered and activated users can see links. Click Here To Register...]

Enter ?12345678? without quotes and press ENTER. That must be the same password which we used before.

After that setup will do something again. Then you will get this message :

Pic 10 ? Reboot request
[Only registered and activated users can see links. Click Here To Register...]

***WARNING***
Don?t press OK until the following screen disappears!

Pic 11 ? The important screen
[Only registered and activated users can see links. Click Here To Register...]

After it disappears you can press OK to reboot your computer. (now i?ll reboot too, so see u soon :D )

Ok now i?m back :)

You can check if your apache2triad works fine. Open your browser and type ?localhost?. If u get a screen like this everything is ok.

Pic 12 ? The relaxing screen
[Only registered and activated users can see links. Click Here To Register...]

Ok. We have completed the installation of Apache2Triad.

STEP 2 : INSTALLATION OF PANDORA

First get pandora from this links :

Part #1: [Only registered and activated users can see links. Click Here To Register...]
Part #2: [Only registered and activated users can see links. Click Here To Register...]

Extract it to your desktop and run pandora.exe. You will get a screen that can make you scared. But don?t panic, it?s normal.

Pic 13 ? The ?hacked? message
[Only registered and activated users can see links. Click Here To Register...]

Click OK and you will get another screen. Wait for 4-5 seconds and it will disappear.

Follow the instructions on the screen. I suggest you don?t change the installation path (default ?C:\Program Files\Project Pandora?).

After the installation PCW (Pandora Configuration Wizard) will open. Click ?Next? in the first screen.

In the second screen it will ask you username, password and DB (database) name. Leave them alone and check ?Use Defaults? option then click ?Next?.

Pic 14 ? PCW Step 1
[Only registered and activated users can see links. Click Here To Register...]

In the next screen it will ask you something about your realm.

Pic 15 ? PCW Step 2
[Only registered and activated users can see links. Click Here To Register...]

You can enter anything you want in first 2 boxes (Realm Name and Player Limit). Actually i don?t know what is MOTD for biggrin.gif . But we don?t need it. Now click ?Next?.

Now in this step you need to know your ?LAN IP?.

Pic 16 ? PCW Step 3
[Only registered and activated users can see links. Click Here To Register...]

In order to learn your LAN IP follow the steps below:

- Click your start menu then select ?run?.
- Type ?cmd? in the run dialog box (without quotes) and click ?OK?.
- Now you are in command prompt. Type ?ipconfig? (without quotes) and press ENTER.
- You will get an output like this :
[Only registered and activated users can see links. Click Here To Register...]

The important data is IP Adress section. Write down this ip adress.

Now close this window and go back to pandora configuration wizard. Change the Host Adress from 127.0.0.1 to the ip adress that you wrote down. In my conditions it must be like this :[Only registered and activated users can see links. Click Here To Register...]

Now click ?Next?.

You will get a message that says configuration is done. Click ?Finish? to exit wizard.

STEP 3 ? SETTING UP THE SQL DATABASE

Now we will prepare the pandora?s database.

First we need to create our database. Open your browser and type ?localhost/phpmyadmin? (without quotes).[Only registered and activated users can see links. Click Here To Register...]

Enter your username (root) , enter your password (12345678) , check ?remember my password? option and click OK.

Now you are in phpmyadmin. [Only registered and activated users can see links. Click Here To Register...]

In the ?Create new database? section, type ?pandora? as shown above and click ?Create?

Now you have an SQL database named ?pandora?. We don?t need phpmyadmin anymore so close it.

-----------------
Now we will fill our database with pandora?s data.

Before doing this go to your pandora folder and open sql folder. open pandora.sql with Wordpad (this will take some time). in the edit menu select "replace".

enter the first box "DEFAULT CHARSET=latin1" (without quotes) and leave the second box empty. then click "replace all". save and close it.

Click your start menu and select ?run?. Type ?cmd? (without quotes) and press ENTER.

In command prompt type ?mysql ?u root ?p? (without quotes) and press ENTER.
[Only registered and activated users can see links. Click Here To Register...]

Enter your password (12345678) and press ENTER.
[Only registered and activated users can see links. Click Here To Register...]

After that type "use pandora;" (without quotes) and press ENTER.[Only registered and activated users can see links. Click Here To Register...]

Type the string that shown below and press ENTER. [Only registered and activated users can see links. Click Here To Register...]

MySQL will process the pandora?s database and it will make necessary changes. When it finishes you will get this : [Only registered and activated users can see links. Click Here To Register...]
Now we made our database. It?s time to make some configuration. You can close command prompt.

STEP 4 ? CONFIGURING PANDORA
Now go to your pandora folder (C:\Program Files\Project Pandora). Right click to Pandora.conf and select ?Open with...? . In the program list find Notepad and click OK.

Make your configuration file equal to this (texts in red are the changes you need to change) :

Code:

###########################################################################
# Project Pandora - Configuration file
###########################################################################

# MySQL connection information - REQUIRED
# DatabaseInfo = &#34;host;login;password;databasename&#34; - password cannot be empty
# Defaults are&#58; DatabaseInfo =&#34;localhost,pandora,pandora,pandora&#34;
Databaseinfo = &#34;localhost;root;12345678;pandora&#34;

# IP or DNS of the server &#40;both logon and world&#41;.
# You need to set this to your external IP.
# Default&#58; 127.0.0.1 &#40;localhost&#41;
# Please note that if you want to have other people connect, you must set this to your IP Adresss
Host = 192.168.1.2
LogonServerPort = 3724
WorldServerPort = 3725

# Set up your realm name here, server will add this single realm to list
# Please Note the last option! 1 Sets it to use the configuration here, and 0 sets it to use the SQL configuration &#40;Hence enabling multiple realms&#41;
# RealmName = Name of the Realm
# RealmAddr = Address of Realm - This should be set to whatever your host is
# RealmPort = The Port for the Realm &#40;default = WorldServerPort&#41;
# RealmlistFromConfig = 1 - Use realmlist specified here, 0 - Use from 'realms' table in SQL database.
RealmName = &#34;Test Realm&#34;
RealmAddr = 192.168.1.2
RealmPort = 3725
RealmlistFromConfig = 1

# Logging detail level
# 0 = Minimum; 1 = Error; 2 = Detailed; 3 = Full/Debug
# Default&#58; 0
# The higher this setting the more lag the server can experience
LogLevel = 3

# Packet logging for the worldserver
# Default&#58; 0
#LogWorld = 0

# Packet logging for the realmserver
# Default&#58; 0
#LogRealm = 0

# Maximum number of players in the world. Excluding GM's
# Default&#58; 100
PlayerLimit = 2

# Message of the Day. Displayed at worldlogin for every user.
Motd = &#34;Welcome to |cffff6060Test WoW|r server.&#34;

Now save it and close.

STEP 5 ? CONFIGURING WOW
Go to your WOW directory. Open realmlist.wtf with notepad. Delete all the text in it and write ?set realmlist YOUR_LAN_IP? (without quotes).

YOUR_LAN_IP is your ip adress which we learned with ipconfig. In my condition i must write ?set realmlist 192.168.1.2? (without quotes).

Save it and close.

STEP 6 ? CREATING ACCOUNTS
Go to your pandora folder (C:\Program Files\Project Pandora). Extract the ?EasyPHP 1-8.rar? to your desktop.

Now go to your desktop and double click the ?EasyPHP1-8? folder. Right click the ?www? folder and select ?cut?.

Go to your apache2triad folder (C:\Apache2Triad). Right click on ?htdocs? folder and select ?paste?.

Now double click ?htdocs? folder then double click ?www? folder. Right click on the ?config.php? and select ?open with..?. In the program list select Wordpad (not Microsoft Word) and click OK.

Find these lines :

Code:

//Wow server settings.
//------------------------------------------------------------------------------------------
&#036;acct_db=&#34;wow_server&#34;; //Name of the wow database.
&#036;acct_host=&#34;localhost&#34;; //Ip adres of the lud server.
&#036;acct_user=&#34;ludmilla&#34;; // DB username &#40;mysql&#41;
&#036;acct_pass=&#34;ludmilla&#34;; //DB Pass &#40;Mysql&#41;
//End of wow server settings

Change them to this :

Code:

//Wow server settings.
//------------------------------------------------------------------------------------------
&#036;acct_db=&#34;pandora&#34;; //Name of the wow database.
&#036;acct_host=&#34;localhost&#34;; //Ip adres of the lud server.
&#036;acct_user=&#34;root&#34;; // DB username &#40;mysql&#41;
&#036;acct_pass=&#34;12345678&#34;; //DB Pass &#40;Mysql&#41;
//End of wow server settings

Now save it and close.

Open your browser and type ?localhost/www? and press ENTER. You will get this :
[Only registered and activated users can see links. Click Here To Register...]
Now you can create accounts by clicking the ?Register now!? link.

Thats all. I hope this will help you.

Credits : spawnedc - Bl!zzhacker ;)

***********

Quote:

this fixes the database error
copy evrything from this folder
C:\programfiles\Project Pandora\EasyPHP1-8\EasyPHP1-8\mysql
and replace evrything in this folder
C:\apache2triad\mysql\

thanks to darkyy - Bl!zzhacker :D