-[Only registered and activated users can see links. ]
-[Only registered and activated users can see links. ]
-[Only registered and activated users can see links. ]
-[Only registered and activated users can see links. ] (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 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: [Only registered and activated users can see links. ] (credits to JulianX)
I hope this guid helped u
Greetings, ziPlet
Last edited by ziPlet; 4 Weeks Ago at 04:17 PM.
Donate to remove ads, get your "DONATOR title, and get access to the MMOwned community's elite Shoutbawx.
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Join Date: Feb 2009
Posts: 2
Reputation: 3
hey, all of my stuff works ok except that when i create characters, they dont show up in my character list.. When i go onto the database it shows that i made them.. PLEASE HELP! thanks =D
[GUIDE] How to make a WOTLK 3.0.8 server 
)
