[Epic Guide] Setting Up and Running an ArcEmu Server from Scratch!

[psychobandit]

Yeah, took me four hours to download it too.

O.K. then, so you DO have the SVN for WhyDB. So then I would just re-read how to put the World DB into Navicat or whatever program you use because it seems like there is something wrong with it. The other possibility might be the world.config, but unless you deleted crap out of it, it should work just fine.
Beyond that, I would need a LOT more info to try & track it down.
.
.
.

[LoffelMan]

I'm gonna go ahead and be fail real quick and say
every time I try to start my world or logon.exe I get the message
This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem.
now as much as my question was answered in my own post if I reinstall im more than likely just going to mess it up more. any ideas?

My win and bin folders along with my logon and world.conf folders have red !'s on them as well.
Don't I look stupid?

[psychobandit]

I'm gonna go ahead and be fail real quick and say
every time I try to start my world or logon.exe I get the message
This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem.
now as much as my question was answered in my own post if I reinstall im more than likely just going to mess it up more. any ideas?

My win and bin folders along with my logon and world.conf folders have red !'s on them as well.
Don't I look stupid?

O.K., the libmySQL.dll is in this folder "SVN\arcemu\trunk\extras\arcemu-windows-libraries\DLL Files". You need to copy libmySQL.dll & also libeay32.dll into the server folder you created. IF you don't have that folder or the .dll's, then something didn't DL right to your SVN folder so delete it & DL it again.
As for the red exclamation points, the one on the "win" folder will be there after you compile & it's fine, it just means there were warnings in the compile which is normal. The one on the "bin" folder is not normal. I suggest you delete the "bin" folder & then do an SVN update & see if that gets rid of it. You can do the same with the .config folder but I think that is there because you modified the configs. Any time you change something in the SVN folders, the red "!" shows up. You should copy the configs to your server folder & THEN modify them k?

Now that we are a few pages further into the thread, I will point out again that all credit for this "how to" thread goes to "Apple Pi"
.
.
.

[LoffelMan]

Right-o. This should be my last question as my logon is working fine now.
When I start my world it gets down to some threads then gives me the message
Config: >> configs/world.conf
Unterminated comment. ( Sometimes Unterminated Block)
Config: >> configs/optional.conf
Sometimes it doesn't say either of these and says it can't connect to my host.
Thanks for the help thus far. If it wasn't for smart people eating questions down any guides I use people would be stuck as hell.

edit* I think I fixed the host connecting issue but the preposted stands firm.

[psychobandit]

Right-o. This should be my last question as my logon is working fine now.
When I start my world it gets down to some threads then gives me the message
Config: >> configs/world.conf
Unterminated comment. ( Sometimes Unterminated Block)
Config: >> configs/optional.conf
Sometimes it doesn't say either of these and says it can't connect to my host.
Thanks for the help thus far. If it wasn't for smart people eating questions down any guides I use people would be stuck as hell.

edit* I think I fixed the host connecting issue but the preposted stands firm.

Ya that is a continuing problem with windows installs. I made a fix for it but the guys over at Arc are being dicks & denied my changes.....stupid
So, find the "optional.config" that's in your server folder and open it with notepad, then copy the code I put below & paste it over the text that's in there now & save it.
BTW, The code below is exactly the same as what you already have, I just had to modify the symbols around all the comments so it'll read it properly & not cause that alarm/message (apparently windows likes "/****" and not "#####". Stupid windows ).

/********************************************************************************
* ArcEmu Optional Configuration File
* Last Update: $Id: arcemu-optional.conf rev.2718
*
* This configuration file contains all non-blizzlike values.
********************************************************************************
********************************************************************************
* 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 (#).
********************************************************************************
********************************************************************************
* Optional Settings
*
*   Starting Level
*      This controls at which level characters are created. Range is from 1-80.
*      Default: 1
*
*    Level Cap
*      This variable controls the level that stats will be generated up to internally.
*      Beyond this level players can still see a higher level visually but their stats won't
*      increase beyond this point.
*      Default: 80
*
*    Generated Level Level Cap
*      This variable controls the level at which stats will generate up to. Generally the formulas go
*      crazy after level 80 so this way you can keep the high visual but stats at a reasonable value.
*      Default: 80
*
*    Allow The Burning Crusade characters
*      This will override account settings, so you can disable TBC from your server without having to mess with accounts.
*      Default: 1 
*
*    AdditionalFun
*      it's verbose.
*      Default: 0 (disabled)
*
*    Unstuck
*      Default: 0 (disabled)
*
*    UnstuckCooldown
*      Default: 60 (0 = No cooldown, otherwise time in seconds)
*
*    UnstuckToBind (Hearthstone coordinates)
*      Default: 1 (0 = No, 1 = Yes)
*
*    MaxProfessions
*      The maximum number of professions a player can have at a time.
*      Default: 2
*
********************************************************************************/

<Optional StartingLevel="1"
	LevelCap="80"
	GenLevelCap="80"
	AllowTBC="1"
	AntiMasterLootNinja="0" 
	AdditionalFun="0" 
	DKStartingTalents="0" 
	Unstuck="0" 
	UnstuckCooldown="60" 
	UnstuckToBind="1"
	MaxProfessions="2">

/********************************************************************************
* Interfaction Options
*
*    InterfactionChat
*      This directive controls whether horde and alliance players can talk to each other.
*      Default: 0 (disabled)
*
*    InterfactionGroup
*      This directive controls whether horde and alliance players are able to build a group together.
*      Default: 0 (disabled)
*
*    InterfactionGuild
*      This directive controls whether horde and alliance players are able to build crossfaction guilds
*      Default: 0 (disabled)
*
*    InterfactionTrade
*      This directive controls whether horde and alliance players can trade with each other.
*      Default: 0 (disabled)
*
*    InterfactionFriends
*      If this is enabled players can add other players from the opposite faction to their friends list
*      Default: 0 (disabled)
*
*    InterfactionMisc
*      This directive controls whether horde and alliance players are able to use different functions
*      on players of the opposite faction. This includes e.g. using the /who command.
*      Default: 0 (disabled)
*
*    CrossOverCharacters
*      If this is enabled players are able to create both, horde and alliance characters on a PVP realm.
*      Default: 0 (disabled)
*
********************************************************************************/

<Interfaction InterfactionChat="0" 	
	InterfactionGroup="0"
	InterfactionGuild="0"
	InterfactionTrade="0"
	InterfactionFriends="0"
	InterfactionMisc="0"
	CrossOverCharacters="0">

/********************************************************************************
* Color Configuration
*
*    AnnTagColor
*      This controls which color the [] tag in front of announces has.
*      Default: 2 (Light Blue)
*
*    AnnGMTagColor
*      This controls the color of the GM/Admin tag in announces. Only enabled if GMAdminTag is set to 1.
*      Default: 1 (Light red)
*
*    AnnNameColor
*      This controls the color of the gamemaster's name in announces.
*      Default: 4 (Green)
*
*    AnnMsgColor
*      This controls the color of message in announces.
*      Default: 6 (Gold)
*
*
*   You can choose one of the colors below.
*     LightRed	= 1
*     LightBlue	= 2
*     Blue		= 3
*     Green	= 4
*     Red		= 5
*     Gold 		= 6
*     Grey		= 7
*     White		= 8
*     Magenta 	= 9
*     Yellow 	= 10
********************************************************************************/

<Color AnnTagColor = "2"
	AnnGMTagColor = "1"
	AnnNameColor = "4"
	AnnMsgColor = "6">

/********************************************************************************
* Extra Scripts Configuration
*
*    Instant80
*      Enables Instant80 mode.
*
*    PvPToken
*      This directive enables  item rewards when there is a PvP Kill and players are level 70
*
*    PvPTokenID
*      If PvPToken is enabled, specify the item ID of your custom Token ID, or any other item
*
*    L70etc
*      Enables L70etc Band Gossip script.
*
********************************************************************************/

<Extra Instant80="0" 
	PvPToken="0" 
	PvPTokenID="13905" 
	PvPKillAnnounce="0" 
	Portals="0" 
	L80etc="0" 
	WeddingNPC="0">

/********************************************************************************
* GameMaster Configuration
*
*    ListOnlyActiveGMs
*      List only gamemasters with enabled GMFlag to players without any permissions.
*      Default: 0
*
*    HidePermissions
*      Hides permission flags from players without any permissions.
*      Default:0
*
*
********************************************************************************/

<GameMaster ListOnlyActiveGMs = "0"
	HidePermissions = "0">

/********************************************************************************
* Common Schedule Configuration (func from commonschedulethread.cpp p2wow's core)
*
*    AutoBroadCast (MultiLanguages supported)
*      Enable/Disable new broadcast system.(cebernic: blizzlike )
*      Default: 0(Disable) 1(Enable)
*
*    BroadCastInterval
*      Contents sending on interval by second
*      Default:(Min:10 Max:1440)
*
*    BroadCastTriggerPercentCap
*      Setup the cap of chance in condition with contents sending in each BroadCastInterval's value
*      Notice: OP can setup any of message's priority, this could be adjustment in field `percent` of table `worldbroadcast`
*      Default:99 (min:1 max:99, 99 only displaying message on priority 100 set.)
*      i.e : If set 50 ,it means all of messages 100% selected(but may not displayed) by higher than '50' priority with each broadcastinterval.
*      The total selected messages(>51 priority) chosen at random with send to all players.
*
*    BroadCastOrderMode [0-1]
*      0:RandomMode - By Triggering & Conditions 
*      1:SerialMode - [ignored both ->field `percent` from table `worldbroadcast` & TriggerPercentCap parameters.]
*      Default:0
*
********************************************************************************/

<CommonSchedule AutoBroadCast = "0"
	BroadCastInterval = "10"
	BroadCastTriggerPercentCap = "2"
	BroadCastOrderMode = "0">

/********************************************************************************
* Extra Class Configurations
*	DeathKnightPreReq
*		Enable/Disable requirement to have a level 55 character on your account before allowing creation
*		Of a Death Knight hero class.
*		1 = level 55
*		0 = Any level
*
*	DeathKnightLimit
*		Enable/Disable limit to have a more than one Death Knight Hero Class per realm.
*		1 = Enabled (Only one Death Knight per realm)
*		0 = Disabled (You can create a 10 DK per realm)
*
********************************************************************************/

<ClassOptions DeathKnightPreReq = "1"
	    DeathKnightLimit = "1" >

/********************************************************************************
* GoldSettings Configuration
*
*    EnableGoldCap
*      Enable/Disable Maximum Gold.
*      Default: 0(Disable) 1(Enable)
*
*    StartingGold
*      On Creating a character they will start with this amount in Gold
*      Default: 0
*
*    MaximumGold
*        Maximum amount of Gold a character can hold
*      Default: 214748 (214k gold)
*        Note: Client Max is 214748 Gold (2^31, signed int32)
*
********************************************************************************/

<GoldSettings EnableGoldCap = "1"
	      StartingGold = "0"
	      MaximumGold = "214748">

If you made any changes to the settings in your optional.config, you will need to go & change them again o.k.?
.
.
.

[LoffelMan]

Gah. Now I get spammed with Read buffer overflow in DBC reading of file DBC/Spell.dbc when I open my world.

[Griffton]

Not sure if this has been posted. About a week ago I tried this, but i kept getting plagued with an error when trying to compile it during step 3.

I had set up the majority of everything except Visual 08 Express on a diffrent partion.

Went back deleted everything on the diffrent partion, and installed them on my C:/ partion, and the errors went away.

Just posting this for that poor soul thats like me.


17 pages, at about say 2 minute load times isnt fun, sorry if this tip is a repost within this thread.

[psychobandit]

Gah. Now I get spammed with Read buffer overflow in DBC reading of file DBC/Spell.dbc when I open my world.

Did you extract the DBC files from game vers. 3.2.2a? if not, you need to because there were changes.
If you did extract them, it may be corrupt & you'll have to do it again.
Or, you could search the ArcEMU forums. I know I have seen that error before, I just don't remember what the exact cause was.
.
.
.

[psychobandit]

Not sure if this has been posted. About a week ago I tried this, but i kept getting plagued with an error when trying to compile it during step 3.

I had set up the majority of everything except Visual 08 Express on a diffrent partion.

Went back deleted everything on the diffrent partion, and installed them on my C:/ partion, and the errors went away.

Just posting this for that poor soul thats like me.


17 pages, at about say 2 minute load times isnt fun, sorry if this tip is a repost within this thread.

I don't believe that has been posted in here before so thanks for the info
.
.
.

[Seeznoevil]

Great guide so far but ive gotten stuck at finding a 3.3.0 DBC if anyone can link a site that has them available or direct link to one that would be great

[Seeznoevil]

Great guide so far but ive gotten stuck at finding a 3.3.0 DBC if anyone can link a site that has them available or direct link to one that would be great

[Starz]

Hmm... I have a tiny prob ><. It has been posted before, but there wasn't really any clear answer to it, and it was like half a year ago (Lol).

When I try creating a character, I get a disconnect. I tried over and over and over again, and was able to make one random character, and after that... nothing. Its all running nicely, except from the character creation. 3.2.2a btw. I don't get any errors or any messages anywhere, just a "You have been disconnected from the server.".

Is there any way to fix this?

[Starz]

Hmm... Just wanted to add this here, and yeah, I know I posted a problem above...

Anyway, if some of your friends, or basically a person from another IP can't connect, then I might have found out a way to solve it, but I can't promise it though.

What I did was to change my realmlist a little, and put it like this (Europe btw):

set realmlist <connection IP (Hamachi for me)>
set patchlist eu.version.worldofwarcraft.com
set realmlistbn ""
set portal eu


So, where I wrote "<connection IP (Hamachi for me)> would be where you put the host IP, which would be yours. If its Hamachi, as it is for me, then it would be something like:

set realmlist 5.XX.XXX.X
set patchlist eu.version.worldofwarcraft.com
set realmlistbn ""
set portal eu

As 5 is the first number in your Hamachi IP/ID. The "X"s are the number you put in, so just type in the IP/ID that is written on top of your Hamachi.

NOTE - If your friends or whoever who wants to connect to your server is using an older hamachi then the one you're using as/on the host, then it might not work. Make sure to uninstall the old Hamachi first, then download + install the new one.

And, no. I didn't connect through the same IP as my server is hosted on, as that's on another computer, without WoW and its connected to my neighbours net and the computer I game from, is my net.

A suggestion would be to "remake" this guide with new pics and info that is a little more "Up to date".

And an additional thing. If I was able to, I'd give you +Rep, but I'm currently just a "Leecher" here... Thanks for the awesome guide, and a major thanks to psychobandit for helping us all out while Apple Pi/Moonblade was away.

[THemeet]

Go to the folder where you downloaded WhyDB, there should be a file called tool.bat. Right click it and press edit. Change WhyDB_world to world. then save and close it. I can not find WhyDB_world in tool.bat

[psychobandit]

Hmm... I have a tiny prob ><. It has been posted before, but there wasn't really any clear answer to it, and it was like half a year ago (Lol).

When I try creating a character, I get a disconnect. I tried over and over and over again, and was able to make one random character, and after that... nothing. Its all running nicely, except from the character creation. 3.2.2a btw. I don't get any errors or any messages anywhere, just a "You have been disconnected from the server.".

Is there any way to fix this?

Which rev of Arc are you using? Somewhere between 3020 & 3100, I had that problem but the latest rev is working fine (rev 3103). If you DO have the latest rev, try clearing your games cache folder & then shutdown & startup your computer. DO NOT just restart it! It needs to be completely shut off, then turned on...I don't know why it matters but it does.

As for re-doing this help guide, Apple PI keeps talking about doing it. I think he's really busy with other stuff though so he hasn't had the time. It'll happen, just not sure when

Go to the folder where you downloaded WhyDB, there should be a file called tool.bat. Right click it and press edit. Change WhyDB_world to world. then save and close it. I can not find WhyDB_world in tool.bat

That part of the guide is no longer valid. When you run the tool.bat, it will ask you the name of your world DB. So no editting is needed, just run it & answer all the questions
.
.
.