- Joined
- Jan 20, 2008
- Messages
- 335
- Reaction score
- 0
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 :
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 )
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 :grr:
[/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)
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 :
You must be registered to see links
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 )
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 :grr:
[/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)
Attachments
You must be registered for see attachments list
Last edited: