[Guide] How to make 2.4.0 Ascent WoW Server with Apple's Ascent v3!!! PATCH 2.4.x!

[Appled]

I did put world.sql and DBC Files to rar files cause they were too big files :P
And all DB updates are too on .rar files Sorry about that

Download Apple's Ascent v3!
Click here!
Includes:
Mall! Made by Ackhole, Thanks to him!
DBC's (packed)
DB Updates (packed)
World.sql (packed)
AA Website
NCDB 26
Ascent rev 4321
and everything else nice!
Without:
Trainers bug
Quests bug
Spawns on Quel'danas (.recall port 2.4)
New dungeons.



HOW TO SET UP ?

You find MySQL Setup from your AA Tools folder --> Typical > Install > Next > Next > Tick that Configure the Mysql Server now and finish > Next > Standard > Next > Put password to ascent(Tick Enable root access bla bla bla) > Next and Execute!



Then:
First just install Navicat; it is in Tools folder.Then open, should popup Connection window.
Connection name can be what ever you want.Username is root.And Mysql Password is ascent.Then click Test Connect.If works, then click Connect.
Make new Database called world and then right click of it and choose Execute Batch file.Look up world.sql.Go to your server folder and DB Sql Files, there is world.rar. Run it and there is world.sql.
Go to tools folder and install .net framwork is you haven't install it yet
And then just put server on! Click ascent-world.exe and ascent-logon.exe (when database Extractor is done ^^)
Have fun!
How to make Public?

::Public for all::
For all!
:ynDNS::
First go to Dyndns and make account.When you have made just login.Then go to My Hosts and make new host.
Hostname: Name don't matter, but you need to remember it.
Wildcard: Tick it
Service Type: Host with IP address
IP Address: Click Use auto detected IP address
Mail Routing: Don't do anything
Then Create Host!!
::Hosts::
Go to My Computer > C disk > Windows > System32 > Drivers > etc > Open hosts file in notepad and add:
127.0.0.1 Host you created
Internal IP Host you created
External IP Host you created
::How to get internal IP?Just click Start > Run > CMD > Ipconfig and then look up your IP::
::How to get External IP?Just go to http://www.myipaddress.com/::
::Ports::
Connect to your Router, Username and Password should be admin and admin.
Forward those ::
UDB / TPC

3036
3724
6881-6999
8129
2093
6112
8050
8245
3306
80
::Conf::
Open ascent-realms.conf and change Logonserver Address to your Hostname and too change Realm1 Address to Your hostname:8129
::Testing::
Open ascent-world.exe and too ascent-logon.exe, if again works GZ GZ GZ
::Accounts::
Open Navicat and find World Database, look up Accounts table and make account:
acct: Don't write anything
login: Username
password: Password
GM: (AZ is admin, A is GM, Empty is player)
banned: Don't write anything
Then go all way to flags
Flags: (8 is Burning Crusade and 0 is non BC)
If you got server open, Open ascent-logon.exe and write there reload, if not just start server
Then tell them to set their realmlist to your hostname!!

Made by ~Apple
Don't copy without asking from me first!

[Opirity1]

I did put world.sql and DBC Files to rar files cause they were too big files :P
And all DB updates are too on .rar files Sorry about that

Download Apple's Ascent v3!
Click here!
Includes:
Mall! Made by Ackhole, Thanks to him!
DBC's (packed)
DB Updates (packed)
World.sql (packed)
AA Website
NCDB 26
Ascent rev 4321
and everything else nice!
Without:
Trainers bug
Quests bug
Spawns on Quel'danas (.recall port 2.4)
New dungeons.



HOW TO SET UP ?

You find MySQL Setup from your AA Tools folder --> Typical > Install > Next > Next > Tick that Configure the Mysql Server now and finish > Next > Standard > Next > Put password to ascent(Tick Enable root access bla bla bla) > Next and Execute!



Then:
First just install Navicat; it is in Tools folder.Then open, should popup Connection window.
Connection name can be what ever you want.Username is root.And Mysql Password is ascent.Then click Test Connect.If works, then click Connect.
Make new Database called world and then right click of it and choose Execute Batch file.Look up world.sql.Go to your server folder and DB Sql Files, there is world.rar. Run it and there is world.sql.
Go to tools folder and install .net framwork is you haven't install it yet
And then just put server on! Click ascent-world.exe and ascent-logon.exe (when database Extractor is done ^^)
Have fun!
How to make Public?



Made by ~Apple
Don't copy without asking from me first!

sorry i copyed

[Appled]

xD :P But rep me?

[MooseBoi]

how about you listen to your own instructions,
"Don't copy without asking from me first!"

http://www.***********/forums/f16/guide-how-make-2-4-0-ascent-wow-server-apples-ascent-v3-patch-2-4-0-a-576/

doesnt let me post the website, but replace *********** with mmopro . net

[Appled]

I asked from me already :P

[Arkile]

do know what im doing wrong every time i run ascent world it sas "major error/warning
one or more of the DBC files are missing.
these are absoutely necessary for the server to function.
the server will not start without them."
do you maybe know what im missing or what im doing wrong?

[uberboy]

do know what im doing wrong every time i run ascent world it sas "major error/warning
one or more of the DBC files are missing.
these are absoutely necessary for the server to function.
the server will not start without them."
do you maybe know what im missing or what im doing wrong?

you'll need to extract the dbc map from dbc.rar pease-a-cake ^^

works fine but the portal to mall dont work so you'll need to make a new1

+Repme plz i'm 1 +Rep from leecher mod


and ther is no web page so how do i get?

[Arkile]

o ok thanks and +REP im gunna see if this works

[leethunter]

when i try to exicute the world.sql i get this error


[Err] 1050 - Table 'account_data' already exists
[Err] -- ----------------------------
-- Table structure for account_data
-- ----------------------------
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`uiconfig0` blob,
`uiconfig1` blob,
`uiconfig2` blob,
`uiconfig3` blob,
`uiconfig4` blob,
`uiconfig5` blob,
`uiconfig6` blob,
`uiconfig7` blob,
`uiconfig8` blob,
PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

[gymp]

leethunter you sure world.sql aint still running? Because the table is already created maybe you are running it again. It is failing because its already there. But guys i have a question thanks for the tut it seems to be good. When i finally login as a gm ie. admin admin. It lets me select development realm and says connected but hangs there like i am using the wrong client version. I am using 2.4.1 and I have deleted my cache. any ideas ?

[kheel]

dude nice guide doing it right now.. but pls put in a website... your very good @explaining so would be a gr8 help hehe +rep 2 u

EDIT: is the logon in the World DB 2?
EDIT2: nvm looked@the configs and seems like it hehe

[huntress_of_prey]

I have Vista and I had to use resource hacker to config mysql. It works fine now, Howerver when I try to run ascent-world...I get the error saying the side by side configuration is incorrect. How do I fix this?

[Appled]

Portal to Mall..You need one item for it, I don't remember what was it^^
Is your vista 64bit`?
and leethunter: You don't need old account tables and etc.

[kheel]

is my host name the one DynDNS like "ascenscion.game-server.cc" or is it the IP?? ( externel )

[thpthpthp]

hey tryed this but i got screwd up on the first part =/ while intalliing mysql when i hit "Execute" at the end i get this error

"The secuity settings could not be applied to the database because the conection has failed with the following error.

if a personal firewall is runing on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [retry] to apply the security settings.

if you are re-onsta;;ing after you uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last is still neededto connect to the server. in this case please select skip now and re-run the Configuration Wizard from the start menu."

i had installed MySQL before while trying to set up another priv server but i dont remember the password since it was a LONG time ago