How to make a WOTLK 3.0.9 Server
What do u need:
-Microsoft Net FrameWork 3.5
-MySQL
-SQLyog
-Repack (U can use the repack from keazain for example, credits go to keazain )
Configuration MySQL:
- Click Next.
- Choose Typical.
- Click on Install.
- MySQL Server Confugration.
- Click Next.
- Choose Standard Confugration and click Next.
- Click Next again.
- Enter the root password (for example: mypassword) and Confirm it then click Next again.
- Now Click on Execute and wait untill its done.
- Click Finish.
Ur done with this part.
Configuration SQLyog:
- Click Next.
- Click on I accept the terms in the License Agreement and then click Next.
- Click Next Again.
- Click on Install.
U can close the installer now.
-Open SQLyog and click Continue.
U will see the following things:
-MySQL Host Address:
User Name:
Password:
Port:
Database(s):
-Change it as follow:
MySQL Host Address: localhost
User Name: root
Password: UR MYSQL PASSWORD
Port: 3306
Database(s):
(Dont fill anything in Database(s))
-Click Connect now.
-Look up for root@localhost (its on the left side)
-Right click on it and click on Create Database.
-Enter the following name: logon.
-Click on Create.
-Repeat those steps again only this time fill this name in: world.
As u can see on the left side there is an logon database and a world database.
We will start with the logon database:
- Right click on logon and click on Restore from SQL dump.
- Click on ... (The buttom with the 3 dots)
- Open the logon.sql file and click on Execute.
Ur done with the logon database.
Now we will begin with the world database:
- Right click on world and click on Restore from SQL dump.
- Click on ... (The buttom with the 3 dots)
- Open the world.sql file and click on Execute.
Ur done with the SQLyog part.
Configuration of ArcEmu:
I'll show u guys now how to edit the config files.
We will start with the "arcemu-logonserver.conf"
Go to the folder of ArcEmu, then search for the map "configs" and open with notepad the file named "arcemu-logonserver.conf"
Look up for:
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "ascent"
Name = "character"
Port = "3306"
Type = "1">
And Change it as follow:
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "UR MYSQL PASSWORD"
Name = "logon"
Port = "3306"
Type = "1">
We scrolling a lil. bit down now and we will see this:
<LogonServer RemotePassword = "ascent"
AllowedIPs = "127.0.0.1/24"
AllowedModIPs = "127.0.0.1/24">
We change it into this:
<LogonServer RemotePassword = "UR MYSQL PASSWORD"
AllowedIPs = "127.0.0.1/24"
AllowedModIPs = "127.0.0.1/24">
U can save it now and close it.
We are going now to the "arcemu-world.conf" config:
U can see in the beginning already this part:
<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "arcemu" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "character" Port = "3306" Type = "1">
Change it to:
<WorldDatabase Hostname = "localhost" Username = "root" Password = "UR MYSQL PASSWORD" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "UR MYSQL PASSWORD" Name = "logon" Port = "3306" Type = "1">
Now lookup for the following thing:
<Server PlayerLimit = "100"
Motd = "Welcome to an ArcEmu based server! Wrath of the Lich King is now live!"
SendStatsOnJoin = "1"
EnableBreathing = "1"
SeperateChatChannels = "0"
CompressionThreshold = "1000"
QueueUpdateInterval = "5000"
KickAFKPlayers = "0"
ConnectionTimeout = "180"
RealmType = "1"
AdjustPriority = "0"
RequireAllSignatures = "0"
ShowGMInWhoList = "1"
MapUnloadTime="0"
LimitedNames="1"
UseAccountData="0"
AllowPlayerCommands="0"
EnableLFGJoin="0"
TimeZone="0"
Collision="0"
DisableFearMovement="0">
U can change it too:
<Server PlayerLimit = "MAX. PLAYERS WHAT U WANT ON THE SERVER "
Motd = "UR WELCOME MESSAGE"
Motd = "UR WELCOME MESSAGE"
SendStatsOnJoin = "1"
EnableBreathing = "1"
SeperateChatChannels = "0"
CompressionThreshold = "1000"
QueueUpdateInterval = "5000"
KickAFKPlayers = "0"
ConnectionTimeout = "180"
RealmType = "1"
AdjustPriority = "0"
RequireAllSignatures = "0"
ShowGMInWhoList = "1"
MapUnloadTime="0"
LimitedNames="1"
UseAccountData="0"
AllowPlayerCommands="0"
EnableLFGJoin="0"
TimeZone="0"
Collision="0"
DisableFearMovement="0">
Okay we go further again lookup for:
<Rates Health="10"
Power1="10"
Power2="10"
Power3="10"
Power4="10"
QuestReputation="10"
KillReputation="10"
Honor="10"
PvPTimer="300000"
ArenaQueueDiff="150"
Compression="1"
XP="550"
QuestXP="250"
RestXP="20"
ExploreXP="10"
DropGrey="150"
DropWhite="150"
DropGreen="120"
DropBlue="100"
DropPurple="70"
DropOrange="40"
DropArtifact="30"
DropMoney="1000"
Save="300000"
SkillChance="10"
SkillRate="10"
ArenaMultiplier2x="10"
ArenaMultiplier3x="10"
ArenaMultiplier5x="10">
This is optinal. (U need to do this by ur own)
Now look for this:
<LogonServer DisablePings = "0"
RemotePassword = "ascent">
And change it too:
<LogonServer DisablePings = "0"
RemotePassword = "UR MYSQL PASSWORD">
Now save and close.
We do the same thing with the arcemu-realml.conf, open it with the note-pad and edit this:
<LogonServer Address = "localhost"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">
And change it into this:
<LogonServer Address = "localhost"
Port = "8093"
Name = "logon"
RealmCount = "1">
Scroll down and look for:
<Realm1 Name = "Reon's - Fun Server"
Address = "5.168.170.139:8129"
Icon = "PVP"
Population = "1.0"
TimeZone = "1">
And change it too:
<Realm1 Name = "UR REALMLIST NAME (Example: OMGWTF Funserver)"
Address = "localhost:8129"
Icon = "PVP"
Population = "1.0"
TimeZone = "1">
How to join ur server:
Go to C:\Program Files\World of Warcraft\Data\enGB or enUS (or were ever ur WoW map is) and open the Realmlist.wtf and change it too:
set realmlist 127.0.0.1
set patchlist 127.0.0.1
set realmlistbn ""
set portal eu
Save and close it and Run WoW u can login now with:
Username: admin
Password: admin
Creating Accounts:
If u want to create a account then open SQLyog and connect to ur localhost.
-U need to see the tables from the logon DB so click on the + on the left side of logon.
-Then lookup for Accounts and click 1 time on it.
-Then u see somewere in the middle Table Data click on it.
-U only need to fill the following things in:
Acct: 1(if u want a second account make 2 of it, if ur creation another one make 3 of it etc etc)
Login: Ur username
Password: Ur Password
GM: AZ (az=admin) a (a=gm) or u can fill nothing in here and then its just a normal account without admin rights.
Flags: 24 (24 means WOTLK enabled on the account)
-Then click on the floppy picture or w/e u call it. (if u are with ur cursor on it u will see Save Changes)
U can close SQLyog now. (If ur server already is running go to the logon.exe and type reload in there)
How to make ur server PUBLIC? take a look at: http://www.mmowned.com/forums/ascent...n-hamachi.html (credits to JulianX)
I hope this guid helped u
Greetings, ziPlet