[Guide]How to setup a 3.0.3 server using Ultimate 3.0.3 Repack

[brandonrulz1]

thanks...and btw guys, wotlk servers just came out, of course there r gonna be bugs

[B14d3r11]

So um Did i do something wrong or is this good? Cause i noticed u had ALOT more databases then i did. Btw why does extracting the Maps and Vmaps take SOOO LONG.

Okay i am extracting Both the Vmap and Maps. Do i need to know anything else?
Like When i extract the Vmaps & Maps where shall i put them?
What is the "Extra" Folder for? (is it a Website if so tell me what program i need to use)
Do i put in the .sql files into mysql in folder "Structure and updates"?

Im sorry im asking soo many questions but... I kinda forgot how to make a server after not doing it for like 2 years


Heres what happens when i almost finish w/ the vmaps

[forgotten0ne]

I dont know if you got it fixed about the sql database messing up, but just uninstall it and re install it, then make the 2 database's world and logon and it should work. As for the person with the question about the username its default to be root. I havent tried all of the fixes i seen on here or anything yet, i was having a problem with logging in too before, it kept saying connected but wouldn't go anywhere, all i did was restart my computer started the logon and world, and it worked. I have to do it everytime so it might be a memory thing. I am going to test the DK thing in a few mins. As for the map and vmap extracters on other servers i have tried to get working i have found the same problem. there isnt really any good ones i have found yet, but i didnt even add maps or vmaps to this and it worked alright. I have been looking at other sql files for other emu's and seeing if i could use them to get things to work right in here, and nothing so far. I am also looking for a sql file for the trainers. I know someone that has them but i dont think he will give up where he got them because he dont like compeditive servers. All i am making this server for is to be bored and make funny wow movies, but i seem to run into so many problems. When i have more answers i will post them, dont know when that will be though. Yes i think its dumb that the scripter hasnt replied to help anyone out, but might be because he is working on things and can figure them out, who knows though. Well going to try the DK thing.

[graverm]

i can't conect to my new "connection" on Navicat 8 Lite (first step) what shall i do??

[nabtard]

i can't conect to my new "connection" on Navicat 8 Lite (first step) what shall i do??

Have you installed MSQL and set a name / password ect?
That has to be the same as what you type into Navicat to access it

Easiest way to do this
Typical Install > Change the Service Name to root > Password can be whatever you like, root is usually easiest to remember

After that you should be able to get into Navicat

Also i've seen people wondering about the login problem, thats because you've probably made a mistake in the config files

<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "logon" Port = "3306" Type = "1">

Most people make a common mistake and use the Name = World for both of them..
CharacterDatabase needs to be set to "Logon" so keep that in mind

Also!, Not done yet

If you want Northrend working and dont really understand the post Carlsson was on about, Heres what you do (More simplified at least)

After you have everything sorted and your server running, head on into Navicat or whatever you're using, Go into "World" and look for "Worldmap_Info" Right click on it and click on "Dump SQL File"
This might sound like a delete info or something for first time users
but it actually just makes a notepad to the location you've set it to,
I.E Desktop - Anyway.

When you've dumped the file somewhere go into it and scroll right down to the bottom, Now what you'll see is a ton of rubbish and it is imo, so dont worry about it at all :P

Now once you get to the bottom, add this:
INSERT INTO `worldmap_info` VALUES ('571', '216', '0', '0', '1', '0', '0', '0', '571', 'Northrend', '1', '0', '0', '0', '0', '0', '0', '120', '0');

Save and close it, Head on back over to Navicat or whatever, and Right Click on "World" > "Execute Batch File" and execute the Worldmap_info you just edited on the Desktop or wherever you put it, This is how i done it anyway

Just adding a quick edit to sort another thing:

B13d3r11 - You dont need Vmaps from as far as i've seen so no need to worry about it, just put the maps in your server folder and it should run fine

Keep in mind im no expert at all this and this is what i've picked up along the way of making a few servers

Hope this is of some help!

[ArmoredFish]

This is not Wotlk BTW! You can't make DK's nor do a .modify level 80 you can do 70 but 80 does not work.

[dcwaller]

ok im sorry but im rly new nd i need help bad

[cornboi]

this is beastly and all i got server working but how come i cant make a DK or go to northrend?

EDIT: wait do i have to like extract maps? cause i didnt but i can still play LoL

[tuulas4630]

nice guide!!

[forgotten0ne]

I dont know if you got it fixed about the sql database messing up, but just uninstall it and re install it, then make the 2 database's world and logon and it should work. As for the person with the question about the username its default to be root. I havent tried all of the fixes i seen on here or anything yet, i was having a problem with logging in too before, it kept saying connected but wouldn't go anywhere, all i did was restart my computer started the logon and world, and it worked. I have to do it everytime so it might be a memory thing. I am going to test the DK thing in a few mins. As for the map and vmap extracters on other servers i have tried to get working i have found the same problem. there isnt really any good ones i have found yet, but i didnt even add maps or vmaps to this and it worked alright. I have been looking at other sql files for other emu's and seeing if i could use them to get things to work right in here, and nothing so far. I am also looking for a sql file for the trainers. I know someone that has them but i dont think he will give up where he got them because he dont like compeditive servers. All i am making this server for is to be bored and make funny wow movies, but i seem to run into so many problems. When i have more answers i will post them, dont know when that will be though. Yes i think its dumb that the scripter hasnt replied to help anyone out, but might be because he is working on things and can figure them out, who knows though. Well going to try the DK thing.

Update: some of the things i did just messed up my server, dont know what it was so i deleted the server and started over. i have to do somemore mods n i think i will have it. ill keep updating as i go.

[Rigia]

This is not Wotlk BTW! You can't make DK's nor do a .modify level 80 you can do 70 but 80 does not work.

If you wanna make a lv 80 or even 255 then go to the Ascent-world.conf and scroll down to u find LevelCap = "70" and replace it with this LevelCap = "255"for lv 255 or LevelCap = "80"for lv 80

u CAN make DK's Just go to Navicant>Logon(or what ever ur Database is called)>accounts Then change the flag:

TBC = 8

TBC and Wotlk = 4

[Tehn00bman]

Umm, I can't get into instances..Help plz!!

[maxos123]

i did everything as u saud.i have my server but when im creating a char im dc...i have 3.0.3(9183) release.could it be wrong?

[graverm]

Thanks "nabtard" i'll try it right away

[graverm]

by the way i couldn't make a MySQL with the port name 3306 so i changed the port to 3309 and it didn't work to open ascent-logonserver.exe and acent-realmserver.exe... what shall i do?? and where can i change the port name?? any hints??