[GUIDE] How to make a WOTLK 3.0.8 server menu

These ads disappear when you log in.

Page 1 of 12 12345 ... LastLast
Results 1 to 15 of 170
  1. #1
    ziPlet's Avatar Master Sergeant
    Reputation
    19
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    [GUIDE] How to make a WOTLK 3.0.8 server

    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 [email protected] (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
    Last edited by ziPlet; 10-21-2009 at 02:17 PM.

    These ads disappear when you log in.

  2. #2
    Vragoth's Avatar Established Member
    Reputation
    55
    Join Date
    Nov 2008
    Posts
    418
    Thanks G/R
    5/1
    Trade Feedback
    1 (100%)
    Nice contribution But were currently up at 3.0.9 so i think this is copied paste!

  3. #3
    Amicitus's Avatar Member CoreCoins User
    Reputation
    4
    Join Date
    Oct 2006
    Posts
    58
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Doesn't work, I get an error while executing the world.sql

  4. #4
    ziPlet's Avatar Master Sergeant
    Reputation
    19
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    I see, i've got the same problem i'll upload a new one.
    Last edited by ziPlet; 02-25-2009 at 02:03 PM.

  5. #5
    exar34's Avatar Private
    Reputation
    3
    Join Date
    Feb 2009
    Posts
    2
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    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

  6. #6
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Ty for the new sql.. tryed it earlyer today, and i also got the same problem as everyone else.. But i will try it now

  7. #7
    ziPlet's Avatar Master Sergeant
    Reputation
    19
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    im going to upload a new logon db too it seems its a lil bit buggy to.
    empty the logon database and execute the new one it should work then.

  8. #8
    ribce's Avatar Member CoreCoins User
    Reputation
    2
    Join Date
    Jan 2009
    Posts
    61
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    nice mate thanks

  9. #9
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    There are still a execution bug at 36k executed..

  10. #10
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    At 37670..

  11. #11
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    oh.. My fault.. havent seen there was a folder called LATEST SQL! xD Sry. works fine i think.

  12. #12
    ziPlet's Avatar Master Sergeant
    Reputation
    19
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    okay let me know if there are any bugs

  13. #13
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    At the Fun server, the World thing is bugged i think, when i run it it says: configs/arcemu-world.cfg And then it stops.

  14. #14
    ziPlet's Avatar Master Sergeant
    Reputation
    19
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    If u have that problem u need to replace it with other realm configs if u want i can upload those for u 2sec

  15. #15
    mandenjonas1's Avatar Master Sergeant
    Reputation
    21
    Join Date
    Sep 2007
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Thanks, would like that

Page 1 of 12 12345 ... LastLast

Similar Threads

  1. [GUIDE] How To Make A 2.3.x Private Server
    By [RagDoll] in forum WoW EMU Guides & Tutorials
    Replies: 153
    Last Post: 08-29-2008, 06:31 AM
  2. [Guide] How to make the best Host for your Server! [No-IP]
    By Mango Jerry in forum WoW EMU Guides & Tutorials
    Replies: 9
    Last Post: 06-01-2008, 09:26 AM
  3. Replies: 73
    Last Post: 05-25-2008, 03:08 AM
  4. [Video Guide] How to make a 2.3.2 private server easy
    By InternetExplorer in forum WoW EMU Guides & Tutorials
    Replies: 254
    Last Post: 04-11-2008, 06:25 PM
  5. [GUIDE] How To Make A 2.3.x Private Server
    By [RagDoll] in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 03-01-2008, 10:24 AM
All times are GMT -5. The time now is 07:10 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search