Emulation Expert FAQ's
Table of Contents
1. Core Issues
2. Database Questions
3. Emu Programs
4. Connectivity Issues
5. General Questions
_______________________________________________________________________
Core Issues
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.
Database Questions
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.
Where can I learn more about the fields in the database?
Arcemu provides a great web-wiki that informs us of almost every field used in our databases. If you are stuck on a field while editing the databse, check out the wiki here Arcemu Wiki.
Arcemu WIKI: http://www.arcemu.info/wiki/index.php?title=Main_Page
Arcemu FORUM: Sign In
Arcemu SVN: svn://arcemu.info/svn
Mangos WIKI: MangosWiki
Mangos FORUM: MaNGOS: the open source MMORPG server
Mangos SVN: mangos's mangos at master - GitHub
Trinity WIKI: TCWiki
Trinity FORUM: Trinity Core Forum
Trinity SVN: https://trinitycore.googlecode.com/hg
Wcell WIKI: WCell Wiki
Wcell FORUM: WCell Forums • Index page
Wcell SVN: WCell's WCell at master - GitHub
Emu Programs
Downloads
Heidisql: Official HeidiSQL Website
NavicatPremium: Comming soon
SQLyog: Hotfile.com: One click file hosting: SQLyog_Ultimate_8.6.0-1.rar
Vendor Creator: Filebeam - Beam up that File Scottie!
Loot Creator: Filebeam - Beam up that File Scottie!
Database Editor: DarkSector's jDB Editor
Quice: Official Web
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)
What's a restarter and where can I get one?
A 'restarter' is simply a program that checks to make sure your server is online. If it's online and running, the restarter just hides in the background and all is well. If your server happens to go down or crash, the restarter will works its magic and restart your world.exe. You can find easy to use restarters in the Programs Sub Forum, or by searching.
Connectivity Issues
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".
General Help
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.
Can I create custom player titles?
Again, technically you could. But it requires hours of client-side editing. Go to the model section to learn more.
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.
Im gonna keep updating because one that Gastric posted was to old... So yeah im gonna help you and Credits to Gastric for old post
Old post: [2009] Emulation Expert Questions/Requests/FAQ thread