[2009] Emulation Expert Questions/Requests/FAQ thread

[Gastricpenguin]

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 http://www.arcemu.org/wiki/index.php?title=Main_Page.

Emu Programs

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.

[Kallblodig]

4.
Hello, I just made my server public, and It works perfect for me. But other people cant get in, they get stuck on ''Connecting'' and not getting in to the server.
Been trying to solve this for almost 8h now. + Rep if you can help solve this

[LJN]

Check your Realms.config and look for this,

<Realm1 Name = "Test"
Address = "YOUR IP:8129"
Icon = "PVP"
Population = "1.0"
TimeZone = "17">

It should not be your DNS name. (Or 127.0.0.1) If that doesnt work post your configs.

[Kallblodig]

Here is my current realm.config
Wich IP should I put in? my Dyns IP or 127.0.0.1 or my External IP?

#######################################################################
# ArcEmu Realms Configuration File
# Last updated at revision rev.1875
#######################################################################

#********************************************************************************
#* How to use this config file:                                                 *
#* Config files are in a block->variable->setting format.                       *
#* A < signifies the opening of a block, the block name is expected after that. * 
#* After the block name, a space and then the settings sperated by = / ' '.     *
#*                                                                              *
#* e.g.                                                                         *
#* <block setting="0" someval = "1">                                            *
#*                                                                              *
#* Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
#* of the line, or in shell format (#).                                         *
#********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
#    Address:127.0.0.1
#      The address (no port) of the server.
#
#    Port:8093
#      The port on which the logon server listens. (*** NOT 3724 ***)
#
#    Name:FrozenWoW
#      Not really relavant, but name the logon.
#
#    RealmCount:1
#      The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer Address = "127.0.0.1"
	Port = "8093"
	Name = "Default Logon"
	RealmCount = "2">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
#    Name:Frozen WoW
#      The name of the realm.
#    
#    Address: 	127.0.0.1:8093
#      The address (and port) of that realm.
#
#    Icon:PVP
#      The type of realm (PVP, Normal, RPPVP, RP)
#
#    TimeZone:8
#      The location of the server (1=Development, 2=United States, 3=Oceanic, 4=Latin America, 
#       5=Tournament, 6=Korean, 8=English, 9=German, 10=French)
#
#    Population:2
#      (0 = low, 1 = medium, 2 = high)
#
#   Important information below
#
#     change 127.0.0.1 to your EXTERNAL ip if you wish to have a PUBLIC server.
#     This issues come up a lot!
#
# 	Timezone values :
#	0=Korean				16=China
#	1=Development				17=CN1
#	2=United States				18=CN2
#	3=Oceanic				19=CN3
#	4=Latin America				20=CN4
#	5=Tournament				21=CN5
#	6=Korean				22=CN6
#	8=English				23=CN7
#	9=German				24=CN8
#	10=French				25=Tournament
#	11=Spanish				26=Test Server
#	12=Russian				27=Tournament
#	13=Tournament				28=QA Server
#	14=Taiwan				29=CN9
#	15=Tournament				30=TestServer2
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "SveaWoW"
	Address = "sveawow.servegame.org:8129" 
	Icon = "PVP"
	Population = "1.0"
	TimeZone = "1">

<Realm2 Name = "SveaWoW - Local"
        Address = "sveawow.servegame.org:8129"
        Icon = "PVP"
        Colour = "1"
Population = "1.0"
TimeZone = "1">

[latruwski]

the reason emu experts say custom spells are impossible is becuz it is for most people... (fully custom)
but yes you can create a new name, damageformula and with some ME a fully custom "look" however spells like blizz spells is close to impossible... not saying it is totally impossible though

People ask how to create custom spells and they can't even work on DB... i mean you have to draw a line somewhere... if they can't even work on DB or small stuff in core then you can't expect them to learn how to create custom spells instantly ^^

@ mjauuu
Did you edit host file etc? btw sorry that i am less active in helping, but i have exams now ^^

[LJN]

Here is my current realm.config
Wich IP should I put in? my Dyns IP or 127.0.0.1 or my External IP?

[code]#######################################################################
# ArcEmu Realms Configuration File
# Last updated at revision rev.1875
#######################################################################

#******************************************************************************* *
#* How to use this config file: *
#* Config files are in a block->variable->setting format. *
#* A < signifies the opening of a block, the block name is expected after that. *
#* After the block name, a space and then the settings sperated by = / ' '. *
#* *
#* e.g. *
#* <block setting="0" someval = "1"> *
#* *
#* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
#* of the line, or in shell format (#). *
#******************************************************************************* */

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Section
#
# Address:127.0.0.1
# The address (no port) of the server.
#
# Port:8093
# The port on which the logon server listens. (*** NOT 3724 ***)
#
# Name:FrozenWoW
# Not really relavant, but name the logon.
#
# RealmCount:1
# The number of realms in the next section.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
# Name:Frozen WoW
# The name of the realm.
#
# Address: 127.0.0.1:8093
# The address (and port) of that realm.
#
# Icon:PVP
# The type of realm (PVP, Normal, RPPVP, RP)
#
# TimeZone:8
# The location of the server (1=Development, 2=United States, 3=Oceanic, 4=Latin America,
# 5=Tournament, 6=Korean, 8=English, 9=German, 10=French)
#
# Population:2
# (0 = low, 1 = medium, 2 = high)
#
# Important information below
#
# change 127.0.0.1 to your EXTERNAL ip if you wish to have a PUBLIC server.
# This issues come up a lot!
#
# Timezone values :
# 0=Korean 16=China
# 1=Development 17=CN1
# 2=United States 18=CN2
# 3=Oceanic 19=CN3
# 4=Latin America 20=CN4
# 5=Tournament 21=CN5
# 6=Korean 22=CN6
# 8=English 23=CN7
# 9=German 24=CN8
# 10=French 25=Tournament
# 11=Spanish 26=Test Server
# 12=Russian 27=Tournament
# 13=Tournament 28=QA Server
# 14=Taiwan 29=CN9
# 15=Tournament 30=TestServer2
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "SveaWoW"
Address = "YOUR IP:8129"
Icon = "PVP"
Population = "1.0"
TimeZone = "1">

God why does every noob make another realm? Anyway Use your Ip there NOT NOT NOT your your dns host name.
Use this- http://www.whatismyip.com/

[Kallblodig]

Heya, got another issue, My server is public now on Hamachi. But atm only GMs can create DK even tho if they got a character above lvl 55. Any Ideas how to change it so non GMs can make DKs too?

Thx for replying <3

[Gastricpenguin]

What are the account flags of the normal players?

[RyeRye]

What are the account flags of the normal players?

I don't know, Umm. for WOTLK its 24.

[Choices]

I don't know, Umm. for WOTLK its 24.

I think he was asking the guy above, not in general

[LJN]

8-Normal 16-TBC 24- Wotlk. I think? Sounds Right

[2dgreengiant]

What core are you using ?

[dogg336]

What are the Flags for tbc client in arcemu 1999????

[Sounddead]

@Dogg336

The flags for The Burning Crusade is 8.

[Kallblodig]

Heya m8ts, sorry for spamming this thread with questions and my problems. I can assure you this will be my last question. Me and my friends have made a WoW private server wotlk for hamachi, it works fine. We cant make it public beacouse of my router is fu##ed up. It allows usally up to about 3 ports untill this problem uccour. I can forward some ports but some I cant, When I try to add a new port I fill out everything and hit apply. BUT now the port isnt in the forwarded port list! So its not working! We don't want to go hamachi, since it can only host 15 ppl in my network for free... Please help! <3



Im using 3COM 3CR858-91 router
Yes, I used Portforward.com to learn how to port forward but I cant find any soloution to my problem there :/

+ Rep to the one who can help me in this mess