Ultimate Emulator FAQ

[Ziddy1337]

Ultimate Emulation FAQ!

I decided to write this one evening when i was bored, and it is a work in progress. If you have anything to add, PM me and i'll add it to the thread or post a reply. (I know there is one of these already but its pretty much empty and i have nothing better to do) (I stole the few from the current FAQ too, so credits to Gastricpenguin for those)

Note: This is generally for ArcEmu, Aspire and Ascent. There are some Mangos sections, but its not my strong point, so if people can provide some decent FAQ's on that, it will be appriciated.

Table of Contents:

1. Database Issues.
2. Connectivity Problems.
3. Core Problems.
4. Program Issues.
5. General Problems and FAQ.

Database Issues

How do I convert my database into a sql file?
There are a few ways to do this. Through Navicat and SqlYog you can just right-click on a database and select "Backup database as SQL..." and select a destination. You can also right click on a specific table and choose the same option to export individual tables into sql files.

How do I execute queries into my database?
If you are using Navicat or SqlYog you can easily right click on your database and select the "Execute batch file.." option.

I DC when i make a Death Knight!
This is generally caused by outdated databases. Ensure you have the most recent stable release and apply the sql updates. You need WoTLK installed and also ensure your account is flagged for wotlk.

When i use the Death Gate skill as a Death Knight, i spawn under the map and fall to my death
This can be fixed by executing the following sql into your world database:

REPLACE INTO `teleport_coords` VALUES ('53822', 'Death Gate', '609', '2355.7', '-5662.71', '426.027', '0');

Connectivity Problems

Why can't my friends join my server, but i can?
This is generally due to not having the ports forwarded. To find out how to forward your ports visit this website: PortForward.com - Free Help Setting up Your Router or Firewall. You need to open the following ports: 3724, 8129, 8093, 6112, 6056, 6881-6999, 3306, 3036, 8093.

I can log into my server, but the character i make doesnt appear
This is caused by outdated databases. Update your databases with the latest sql updates and it'll work fine.

How do i open my server to the public?
Open the realms config file and find this:

Realm1 Name = "Your Realm"
Address = "EXTERNAL IP:8129"

Change the bit that says external IP to your external IP. Make sure you keep the :8129 as this is the server port. To find out your external IP goto What's My IP Address? Your IP is 206.71.153.245.
Next create a dns at www.dyndns.org. Next, open your hosts file (windows/system32/drivers/ect/hosts) and at the bottom add "Your EXTERNAL IP Your DNS" without the quote marks.

My World.exe cant connect to my logonserver.exe! (Failed Authentication)
This is caused when you have the wrong password in your Config files. In world.conf search for this: RemotePassword = "change_me_logon"
Then in your realms.conf, search for "LogonServer RemotePassword = "change_me_logon"
Ensure the "change_me_logon" part is the same password and ensure you keep the " " marks. For example, your password could be mmowned so it would appear as "mmowned".

Core Problems

When I create a character on my server it doesn't show up or gives me a "login failed" message. What do i do?
When your character doesn't show up on the selection screen, or if you get a "login failed" message when you try and login, this means your character database is out of date. Download the latest SQL updates and execute them into your character database. If the problem still persists, try executing a fresh up-to-date character database.

Can i create custom PvP titles?
Simply put, yes you can. This however involves dbc and database edting. For more on dbc editing you can visit the Model Editing forum.

Is it possible to make items cost Badges instead of Gold?
Yes it is. Simply go into your database, under the Vendors table you will see the extended_cost collumn. Put the Badge ID in that collumn on the item you want to make cost badges. You can find the badge ID's in extendedcost.dbc or by using the search button on the forum.

How can i edit the DBC files?
You need a DBC editor. You can find them online and on the forum by using the search button.

Program Issues

What can I use to edit my database?
Navicat, SqlYog, HeidiSql or any of the database editors found in our Emu Server Programs Section. The most common one is GDE (Global Database Editor)

General Problems and FAQ

Is there a way I can put my own custom music files into my wow private server?
No. You would have to edit the client-side dbc files. If you want to learn more about DBC editing, go to the model-editing section.

Can I make a custom spell?
Technically, yes you can create a custom spell. It requires DBC and client side editing. If you want to learn more about it, go to the Model Editing section, as we won't help here.

Where can i find my realmlist.wtf file?
This can be found in your Main WoW Folder, normally World of Warcraft/Data/enGB/realmlist.wtf for GB and World of Warcraft/Data/enUS/realmlist.wtf for America.

What are the account flags for Wrath of the Lich King?
Generally, the WoTLK flag is 24 and TBC is 8.

How do i make people Game Masters or Admins?
In the accounts table of your database, put az in the 'gm' collumn. For Mangos, write 3.

How can i allow Horde and Alliance talk to each other?
Change the settings in your config files. For ArcEmu, you can do this in the optional.conf by changing "interfactionchat=0" to "interfactionchat=1"

How do i change the level cap of my server?
In the ArcEmu-Optional config, search for levelcap= and change the number to anything you like. Generally this is 80 by default as anything higher can be buggy.

Is it possible to create multiple realms?
Yes it is. Follow this great guide by Volitle: Click Me

How can i create a LUA Teleporter?
Follow this great guide: Click Me

How can i find out Mob information In game?
This is fairly simple. Just click the mob and type .npc info

Credits:

Me for spending 3 hours of my life writing this in Notepad.
Gastricpenguin for the current FAQ.
Volitle for his Multiple realm guide.

Anybody who contributes will have their name added here.

[RyeRye]

It's a nice post.

First!

[LJN]

Nah mines bigger,
http://www.mmowned.com/forums/emulat...4-big-one.html

You did good work +rep

[RyeRye]

Nah mines bigger,
http://www.mmowned.com/forums/emulat...4-big-one.html

You did good work +rep

Thats what she said :P

Lol!

Nice guide there too by the way.

[Ziddy1337]

Nah mines bigger,
http://www.mmowned.com/forums/emulat...4-big-one.html

You did good work +rep

Yeah, but yours a general guide and mine is a FAQ that will eventually have everything you need to know. Still a nice guide though.

Thanks for rep :wiggle:

[stoneharry]

Good faq but it's not that detailed

[Aznex]

How do i open my server to the public?
Open the realms config file and find this:

Realm1 Name = "Your Realm"
Address = "EXTERNAL IP:8129"

Change the bit that says external IP to your external IP. Make sure you keep the :8129 as this is the server port. To find out your external IP goto What's My IP Address? Your IP is 206.71.153.245.
Next create a dns at DynDNS.com: DNS Hosting, E-mail Delivery, VPS Hosting and Other Services. Next, open your hosts file (windows/system32/drivers/ect/hosts) and at the bottom add "Your EXTERNAL IP Your DNS" without the quote marks.

You don't HAVE to use your external IP in your config files you could just as well use your DynDNS But +Rep because u got that right. So many people fail at that part

[Hellgawd]

Did you jack the formatting from Gastric's thread :P

[Ziddy1337]

Did you jack the formatting from Gastric's thread :P

His thread gave the the idea for the colours yeah.
Though i did give credit for his thread, unlike him... :weepy:

I'll be updating this alot over the weekend and hopefully people will start refering to it rather than starting new threads for old problems.