Guide how to make WOTLK server( noob friendly)

[darksideris]

First of all In bong post all things are old now , This guides works for all version but the download links are OLD P.S> read everything till the last line

this is whydb + arcemu guide(can be other databases and cores), files get it from bong post ( in release section),maps dbc ETC..( http://forum.ragezone.com/f434/arcemu-uploads-454556/)

first of all you should install appserv : http://www.appservnetwork.com/

1 click next , then agree, choose where you want to install ( default is the best thing)
2 then click next , select all: apache http sever ,Mysql database , php my admin , phphypertext ( click next)

3 write name NO CAPITAL Letter the name must be like wotlkwow and etc.. and set your email adress

4 enter root password ( this is mysql password remember it !!!)
and enable innoDB
click install

next thing is premium soft navicat you will find it in bong post

install it

then open hih press file/new connection ( in the top)
connection name write localhost
in the password write mysql password
then the connecntion will appear and click on it
press right mouse button press new database write name and click ok( make two databases one character second world)

now you will find 1981_character_structure and 1913_logon_structure ( database ) in arcemu/sql folder then press copy on them and paste in the queries ( in character database) then press 2 times on one of them and run then on another one

now you get world database , then you will find tool.bat open it with notepad ( edit)

SET world_db=here set the database name
save exit
then launch it normally ( by 2 times clicking left mouse button on him)
write root , press enter
and then your mysql password
press the letter as shown ( in whydb 226 the letter is "i") to import the database

now your database is done
its time to make configs
open your arcemu folder ( core folder)/configs
open arcemu-logonserver.Conf with notepad

# LogonDatabase Section
#
# These directives are the location of the `realms` and `accounts`
# tables.
#
# LogonDatabase.Host - The hostname that the database is located on
# LogonDatabase.Username - The username used for the mysql connection
# LogonDatabase.Password - The password used for the mysql connection
# LogonDatabase.Name - The database name
# LogonDatabase.Port - Port that MySQL listens on. Usually 3306.
# LogonDatabase.Type - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "my sql password"
Name = "database name write character "
Port = "3306"
Type = "1">


# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#

<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">

# Server console logging level
#
# This directive controls how much output the server will
# display in it's console. Set to 0 for none.
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#

<LogLevel Screen = "0"
File = "-1">

# Account Refresh Time
#
# This controls on which time interval accounts gets
# refreshed. (In seconds)
# Default = 600
# 600 seconds = 10 minutes - 1 second = 0.0166666667 minutes 300 seconds = 5 minutes, 150 seconds = 2.5minutes
#
#

<Rates AccountRefresh = "600">

# Accepted Build Range Setup
#
# These two directives set up which clients will be
# allowed to authenticate with the realm list.
#
# Set these to the same builds that the server was
# compiled for.
#
# As of the last update, version 3.0.3 was build 9183.
#

<Client MinBuild = "9183"
MaxBuild = "9183">

# WorldServer Setup
#
# RemotePassword
# This directive controls the password used to authenticate with the worldserver.
# It must be the same between the two configs. If it is not, your server will
# not register.
#
# Default: "change_me_logon"
#
# AllowedIPs
# This section MUST be completed, otherwise all attempts to link your servers will fail.
# These "Allowed" fields are a space-seperated list of CIDR-form IP addresses that are allowed
# to make server connections to your logonserver, and register realms.
# For example, everything in the 127.0.0.* range would be:
# 127.0.0.0/24, as 24 of the bits must match the 127.0.0.0
#
# To allow a single IP,
# 1.3.3.7/*** would allow only 1.3.3.7 to connect as 32 of the bits must match.
#
# AllowedModIPs
# In the same form as AllowedIPs, these are the IPs that are allowed to modify the database
# (adding bans, GMs, account permissions, etc)
#

<LogonServer RemotePassword = "This is your remote password make same in the world config"
AllowedIPs = "127.0.0.1/24"
AllowedModIPs = "127.0.0.1/24">



Now open arcemu-world.conf


First of all delete both die massages if those are still there
second

<WorldDatabase Hostname = "localhost" Username = "root" Password = "My sql passwrod" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "Mysql password" Name = "character" Port = "3306" Type = "1">

change these lines


Third


<LogonServer DisablePings = "0"
RemotePassword = "write same password what you wrote in logon remote password)">

other :


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# StartOnGMIsland
#
# Makes GM Characters start on GM Island
#
# Also sets their bind location to GM Island
# Default:1 (Yes) ( 0 you start in normal starting zones)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<GameMaster StartOnGMIsland = "0">


these are the xp and drop rates

XP="1"
QuestXP="1"
RestXP="1"
ExploreXP="1"
DropGrey="1"
DropWhite="1"
DropGreen="1"
DropBlue="1"
DropPurple="1"
DropOrange="1"
DropArtifact="1"
DropMoney="1"
bigger numbers means bigger rates( if somebody dont know :D)

Now open arcemu-realms.conf



<Realm1 Name = "Name of your realm"
Address = "write here you ip ( or no ip ) adrees( do NOT delete follow port in right side):8129"
Icon = "PVP" this is server icon there will be explanations what means each
Population = "1.0"
TimeZone = "1">


If you want to make instant level 80 or change gold cap ect open arcemu-optional.conf
also you will be able to edit deathknignt creation prequisities and limit

in the end put map , vmap ,DBC files in the core folder

now lastly open navicat connect to your connect ( click two times on connection )
Look here.jpg picture
then click two times on character database, select tables, open accounts ( look at there.jpg picture) and create acc write in login acc name in passwrod write passwrod set flags for original wow 0 for tbc 8 for WOTLK and tbc 24 if you want to make gm write AZ in gm

BTW FOR THE flags for originall wow leave 0, tbc 8 , wotlk 24

welll thats it :) if you got problems post here i will try to explain


PS if ur having problems ALWAYS write CORE AND DATABASE YOU USE !!!!!!!!!!!!!!!!!!!!

IF u use router just GO TO HELL
[/FONT][/SIZE]

ALWAYS KEEP UPDATED !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!









NOTE : its been a long time since my guide was made so i suggest not to use my provided links but my guide works for all version up to newest patch for Lich king( note config files might differ)

[MentaL]

[bong25]

Nice one.

BTW: In my thread you can download Navicat Serials already included.

Good job.

[darksideris]

i made couz somebody are noob that much that they dont even read what to do so the wont read more in your post

and thx bong

[Tavis]

Since this is for people that are n00bs with Ascent, I'll ask a n00b question: I keep getting errors for missing maps, how do i fix this? Where do I find the map files?

[darksideris]

there is a tools folder in core folder ( extractors) and put it in ur wow folder and run the exe it will extract it

[antonilo]

hmm, it says that i don't have any dbc files.. :P where to get them ? ^^

[darksideris]

you can get in bong post
lol

[Darkdan]

Hai.
This is Awsome.
Thanks for the Post :)

[ShadowAce]

when i click arcemu-logonserver it runs without a problem
but when i click arcemu-world it says major error/warning
one or more of the dbc files are missing
these are absolutly necessary for the server to function
the server will not start without them
i have checked everything and followed ur steps
.... what did i do wrong?

thanks
-ShadowAce

[darksideris]

extract the dbc files or downlaod them

[ShadowAce]

ive extracted the dbc files and stuff
where exactly do they go though?
ive downloaded everything and tried fixing this by myself

[darksideris]

have no idea :D iam just good at making server i dont know what does what :D

[ShadowAce]

lol good for u ...
sucks 2 be me ... hopefully ill figure it out
i usually dont have problems making stuff

[darksideris]

so everything works ?

[ShadowAce]

im re extracting the maps and stuff so it could take awhile

edit .... nope still says im missing something
i did all the maps and stuff twice

this is what im getting when i try and launch the arcemu-world bat