[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[badot]

ME412

to that just install MySQL 5.0 to your computer just download in the net and installed you will provide the username and the password and the port will provide by the MySQL that username and password you will used it on configuring your logon config and world config and it will be used also in your SQLyog or Navicat do it first.

[macmac]

Hi,

All you need to do is this:

Edit your arcemu-logonserver conf:

change as shown here:

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "ascent"
Name = "X5_logon"
Port = "3306"
Type = "1">


Than edit arcemu-world.conf


change as shown here:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "X5_fun" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "X5_logon" Port = "3306" Type = "1">


Then startup SQLyog

connect to the database using username root
password ascent

right click on X5_fun and restore from batch repack_x19_updatefix_05.02.2009.sql

do the same on forums with cms_updated_03.02.2009.sql

then finally right click on X5_logon and apply logon_updatefix_04.02.2009.sql

The webby account page doesnt work so add accounts ib SQLyog

hope that helps you

its not a repack as we know it..... a little work to do

[movious]

ME412

it seems that you've already installed MYSQL 5 correctly

to solve MYSQL unknown host :
1.open folder configs/arcemu-world.conf
2.look for "..<WorldDatabase .. blabla" and "..<CharacterDatabase..blabla"
3.change Hostname = "host" to Hostname = "localhost"
4.leave port to the default value on the conf file

just run arcemu-logonserver.exe and arcemu-world.exe

i just downloaded ArcEmu_blizz_rev.2137 and it works like a charm.. but logonserver keeps crashing.. huff

[dragonz]

Im not sure how to do all that?

Do I need the MySQL Host address, Username, Password, and port? If so, do you know what they are?

I might be able to figure it out from there

Well you need to setup your config files for the arcemu-logon, and arcemu-world, so they can connect to your database (mysql)

1st if you ahve dropped the keazains pack in your c:// it should look something like this C:\Keazains pack\

2nd open the config files ! C:\Keazains pack\ArcEmu_rev.2137\configs\arcemu-logon.conf AND CHANGED THE THING IN RED !!!

#################################################################
# Keazain`s Compiling - Revision 47 X19 Date 03.02.2009
#################################################################


# 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 = "ascent"
               Name     = "x5_logon"
               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 = "100">

# 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 = "1000"
        MaxBuild = "9999">

# 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/32, 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 = "ascent"
             AllowedIPs = "127.0.0.1/24"
             AllowedModIPs = "127.0.0.1/24">

Now open C:\Keazains pack\ArcEmu_rev.2137\configs\arcemu-world.conf
and CHANGE THE STUFF IN RED !!!

#################################################################
# Keazain`s Compiling - Revision 47 X19 Date 03.02.2009
#################################################################

#/********************************************************************************
# * How to use this config file:                                                 *
# * Config files are in a block->variable->setting format.                       *
# * A < signifies the opening of a block, the block name is expected after that. * 
# * After the block name, a space and then the settings sperated by = / ' '.     *
# *                                                                              *
# * e.g.                                                                         *
# * <block setting="0" someval = "1">                                            *
# *                                                                              *
# * Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
# * of the line, or in shell format (#).                                         *
# ********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = SQLite (MySQL is stable, others are not)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "x5_fun" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "x5_logon" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8129">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Log Level Setup
#
#    Console Logging Level
#        This directive controls how much output the server will
#        display in it's console. Set to 0 for none, or -1 to disable.
#        -1 = Disabled; 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
#        Default: 3
#
#    World server packet logging feature
#        If this directive is turned on, a file called `world.log`
#        will be created in the server's directory and all packets
#        sent and received by clients will be dumped here in bfg
#        format.
#        Default: 0
#
#    DisableCrashdumpReport
#        Disables crashdump reports, else if the build has debugging enabled, 
#        arcemu-world will call ./arcemu-crashreport every time it starts, so 
#        if there is a core, a crashdump will automatically be reported 
#        to the tracker at sf.net
#        Needs gdb and curl
#        Linux only
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

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


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Server Settings
#
#    PlayerLimit
#        This directive controls the amount of sessions that will be
#        accepted by the server before it starts to add people to 
#        the server queue.
#        Default: 100
#
#    Motd
#        This message will be displayed by the server in the chat
#        box every time any user logs on. Colors can be used in the
#        standard WoW format.
#        Default: "No MOTD specified
#
#    Send Stats On Join
#        This directive controls whether the server will send the online player
#        count to a cilent when it enters the world.
#
#    Breathing Setup
#        If the breathing code is causing problems or you want to run a fun server, you can disable 
#        water checks by enabling this directive.
#        Default: 1
#
#    Seperate Channels Control
#        This directive controls whether horde and alliance chats will be seperated across channels.
#        Set to 1 for blizzlike seperated channels, or 0 to allow horde/alliance to speak to each other
#        across channels.
#        Default: 0
#
#    Compression Threshold
#        This directive controls the limit when update packets will be compressed using deflate.
#        For lower-bandwidth servers use a lower value at the cost of cpu time.
#        Default: 1000
#
#    Queue Update Rate
#        This directive controls how many milliseconds (ms) between the updates
#        that the queued players receieve telling them their position in the queue.
#        Default: 5000 (5 seconds).
#
#    Kick AFK Players
#        Time in milliseconds (ms) that a player will be kicked after they go afk.
#        Default: 0 (disabled)
#
#    Connection Timeout
#        This directive specifies the amount of seconds that the client will be disconnected
#        after if no ping packet is sent. It is advised to leave it at the default.
#        Default: 180
#
#    Realm Type
#        This is the realm type that will be used by the server to handle world pvp.
#        Default: 0 (pve)(RPPVE)
#        Other values: 1(pvp)(RPPVP)
#
#    AdjustPriority
#        Set the server to high process priority?
#        Default: 0
#
#    RequireAllSignatures
#        This directive controls whether the full 10 signatures will be required in order
#        to turn in a petition. Smaller servers would be better off having it turned off.
#        Default: off
#
#    ShowGMInWhoList
#        This directive controls whether GM's will be shown in player's who lists or not.
#        Default: on
#
#    MapUnloadTime
#        This directive controls whether to unload map cells after an idle period of <x> seconds.
#        Use on smaller servers or servers that are memory-limited. The server without cell unloading
#        can use over 1.2GB memory with all creatures loaded.
#        Default: 0
#
#    LimitedNames
#        This directive forces all character names to be a-z and A-Z compliant.
#        Default: 1
#
#    UseAccountData
#        This directive determines whether the account_data table is used to save custom client data.
#        May cause buggy behaviour.
#        Default: 0
#
#    AllowPlayerCommands
#        This directive, if enabled can allow players to use commands with a '0' command group.
#        Default: 0
#
#    EnableLFGJoin
#        If this is enabled, you can join the LFG channel without using the LFG tool.
#        Default: 0
#
#    TimeZone
#        Set your local timezone relative to GMT here.
#        Default: 0
#
#    Collision
#        Enable collision system (LoS checks).
#        Default: 0
#     Make sure you have collision.dll in the same folder as arcemu-world!
#
#    DisableFearMovement (In Battlegrounds and Arenas only!)
#        Disable fear movement in arenas & battlegrounds. 
#        Recommended if you do not have collision enabled!
#        Default: 0 (off) Not blizzlike
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Server PlayerLimit = "100"
        Motd = "Welcome to BLABLABLA"
        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">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Announce Configuration
#
#    Tag
#      Configure what is shown in front of your announces in the [] brackets.
#      Default: Staff (would give [Staff])
#
#    GMAdminTag
#      Configure whether the <GM> or <Admin> tag is shown in announces.
#      Default: 0 (disabled)
#
#    NameinAnnounce
#      If this is enabled the name of the person who makes an announcement will be shown in front of the msg.
#      Default: 1 (enabled)
#
#    NameinWAnnounce
#      If this is enabled the name of the person who makes an wide-screen announcement will be shown in front
#      of the message.
#      Default: 1 (enabled)
#
#    ShowInConsole
#      This controls whether announces are shown in the arcemu-world console or not.
#      This does not apply for the team-internal GM announce.
#      Default: 1 (enabled)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<Announce       Tag = "Staff"
                GMAdminTag = "0"
                NameinAnnounce = "1"
                NameinWAnnounce = "1"
                ShowInConsole = "1">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Power regeneration multiplier setup
# 
#    These directives set up the multiplier in which regen values will be
#    multiplied by every 2 seconds.
#    Powers: 
#        Power1 = Mana, Power2 = Rage, Power3 = Focus (pets), Power4 = Energy
#    
#    Reputation:
#        Kill = Rep gained on kill, Quest = rep gained from quests
#
#    Honor:
#        Honor = multiplier used to calculate honor per-kill.
#
#    PvP:
#        PvPTimer = in ms, the timeout for pvp after turning it off. default: 5mins (300000)
#        ArenaQueueDiff = maximum difference in average rating of 2 arena teams to be matched in queue
#
#    XP:
#        The xp that a player receives from killing a creature will be multiplied
#        by this value in order to get his xp gain.
#
#    RestXP: 
#        Amount of hours needed to get one Bubble rested XP ( one bubble is 5% of the complete XP bar)
#        Default is 8 hrs rest for one bubble. Raising this rate causes RestedXP to be earned faster,
#        F.e, setting a rate of 2 makes you require only 4 hrs reesting for 1 bubble (instead of 8).
#        Note that resting in a resting area (Zzz) goes 4 times faster.
#        Default: 1 (bubble every 8 hrs)
#
#    Drop(Color):
#        These values will be multiplied by the drop percentages of the items for creatures
#        to determine which items to drop. All default to 1.
#        To allow you better control of drops, separate multipliers have been created for items 
#        of each quality group. 
#
#    DropMoney:
#        This value will be multiplied by any gold looted and pickpocketed
#
#    Save:
#        Value in milliseconds (ms) that will be between player autosaves.
#        Default: 300000 (5 minutes)
# 
#    SkillChance:
#        The chance that you have to level up a skill in melee or a profession is multiplied
#        by this value.
#        Default: 1
#
#    SkillRate:
#        The amount of "levels" your skill goes up each time you gain a level is multiplied
#        by this value.
#
#    ArenaMultiplier
#         Every week/day the arena points gained by a player will be multiplied by this value.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Rates Health="3"  For these value put what you prefer ... leave the cote
       Power1="3"
       Power2="3"
       Power3="3"
       Power4="3"
       QuestReputation="10"
       KillReputation="10"
       Honor="10"
       PvPTimer="300000"
       ArenaQueueDiff="150"
       Compression="1"
       XP="10"
       QuestXP="10"
       RestXP="10"
       ExploreXP="10"
       DropGrey="1"
       DropWhite="5"
       DropGreen="10"
       DropBlue="10"
       DropPurple="10"
       DropOrange="10"
       DropArtifact="10"
       DropMoney="10"
       Save="300000"
       SkillChance="2"
       SkillRate="2"
       ArenaMultiplier2x="2"
       ArenaMultiplier3x="2"
       ArenaMultiplier5x="2">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# GM Client Channel
#
#   This should be set to 'gm_sync_channel' for the My_Master addon to work.
#   Default: gm_sync_channel
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<GMClient GmClientChannel = "gm_sync_channel">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Terrain & Collision Settings
#
#   Set the path to the map_xx.bin files and whether unloading should be enabled
#   for the main world maps here. Unloading the main world maps when they go idle
#   can save a great amount of memory if the cells aren't being activated/idled
#   often. Instance/Non-main maps will not be unloaded ever.
#
#   Default:
#      MapPath = "maps"
#      vMapPath = "vmaps"
#      UnloadMaps = 1
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Terrain MapPath = "maps"
         vMapPath = "vmaps"
         UnloadMaps = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Log Settings
# 
#    Cheaters:
#        This directive sets up the cheater logging file, if turned on any
#        cheat / packet exploit / speedhack attempts will be logged here.
#
#    GMCommands:
#        These two directives set up the GM command logging fie. If turned on,
#        most gm commands will be logged for this file for abuse investigation, etc.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Log Cheaters="0" GMCommands="0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Mail System Setup
#
#    These directives control the limits and behaviour of the ingame mail system.
#    All options must have Mail prefixed before them.
#   
#    ReloadDelay                 
#        Controls the delay at which the database is "refreshed". Use it if you're
#        inserting mail from an external source, such as a web-based interface.
#        0 turns it off.
#        Default: 0
#
#    DisablePostageCostsForGM 
#        Enables/disables the postage costs for GM's. DisablePostageCosts overrides this.
#        Default: 1
#
#    DisablePostageCosts
#        Disables postage costs for all players.
#        Default: 0
#
#    DisablePostageDelayItems
#        Disables the one hour wait time when sending mail with items attached.
#        Default: 1
#
#    DisableMessageExpiry
#        Turns off the 30 day / 3 day after read message expiry time. 
#        WARNING: A mailbox still cannot show more than 50 items at once
#        (stupid limitation in client).
#        Default: 0
#
#    EnableInterfactionMail
#        Removes the faction limitation for sending mail messages. Applies to all players.
#        Default: 1
#
#    EnableInterfactionMailForGM 
#        Removes the faction limitation for sending mail messages, but only applies
#        to GM's. EnableInterfactionMail overrides this.
#        Default: 1
#   
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Mail ReloadDelay="0"
      DisablePostageCostsForGM="1"
      DisablePostageCosts="0"
      DisablePostageDelayItems="1"
      DisableMessageExpiry="0"
      EnableInterfactionMail="1"
      EnableInterfactionMailForGM="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Status Dumper Config
#
#        These directives set up the status dumper plugin. Filename is an
#        absolute or relative path to the server binary. Interval is the
#        time that the stats will be dumped to xml.
#        Default: stats.xml / 120000 (2 minutes)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<StatDumper FileName = "stats.xml" Interval = "120000">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Startup Options
#
#    Preloading
#        This directive controls whether the entire world will be spawned at server
#        startup or on demand. It is advised to leave it disabled unless you are a
#        developer doing testing.
#        Default: off
#
#    Background Loot Loading
#        This directive controls whether loot will be loaded progressively during
#        startup or in the background in a seperate thread. Turning it on will
#        result in much faster startup times.
#        Default: on
#
#    Multithreaded Startup
#        This controls whether the server will spawn multiple worker threads to
#        use for loading the database and starting the server. Turning it on
#        increases the speed at which it starts up for each additional cpu in your
#        computer.
#        Default: on
#
#    Additional Table Binding
#        You can load static item/creature/etc data into the server using this directive.
#        This way throughout database updates your custom data can be preserved.
#        Format: "sourcetable destination table,sourcetable destinationtable"
#        Example: "myitems items,mynpcs creature_names"
#        Default: ""
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Startup Preloading = "0"
         BackgroundLootLoading = "1"
         EnableMultithreadedLoading = "1"
         LoadAdditionalTables="">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Flood Protection Setup
#
#    Lines
#        This is the number of "messages" or lines that it will allow before stopping messages from
#        being sent. This counter is reset every "Seconds" seconds.
#        Default: 0 (disabled)
#
#    Seconds
#        This is the number of seconds inbetween the Line counter being reset.
#        Default: 0 (disabled)
#
#    SendMessage
#        If this is enabled, a "Your message has triggered serverside flood protection. You can speak again in %u seconds."
#        message will be sent upon flood triggering.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Setup
#
#    DisablePings   
#        This directive controls whether pings will be sent to the logonserver to check
#        if the connection is still "alive". Expect problems if it is disabled.
#        Default: 0
#
#    RemotePassword
#        This directive controls the password used to authenticate with the logonserver.
#        It must be the same between the two configs. If it is not, your server will
#        not register.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer DisablePings = "0"
             RemotePassword = "ascent">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# AntiHack Setup
#
#    Teleport   
#        This directive controls anti-teleport hack checks will be enabled or not.
#        Default: 1
#
#    Speed
#        This directive controls anti-speed hack checks will be performed on player movement or not.
#        Default: 1
#
#    SpeedThreshold
#        This directive controls the threshold at which the speedhack detection will trip.
#        It's (characters' move time of distance - real move time of distance)
#        Default: -600.0
#
#    FallDamage
#        This directive controls anti-fall damage hack checks will be performed on player movement or not.
#        Default: 1
#
#    Flying
#        This directive controls whether flight hacks will be performed on players or not.
#        Default: 1
#
#    FlightThreshold
#       This directive controls the height at which you must be above the vmaps height before you are flagged as "flying" and are subject to kicks.
#       Default: 10
#
#    DisableOnGM
#        This directive controls hack checks will be disabled for GM's or not.
#        Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<AntiHack Teleport="1"
          Speed="1"
          FallDamage="1"
          Flight="1"
      FlightThreshold="10" 
          DisableOnGM="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Period Setup
#
#    These are the periods that the server will wait before doing periodic duties. At the moment only
#    arena point calculation and honor point calculation are used here.
#
#    Default:
#         Arena: weekly
#         Honor: daily
#             (blizzlike values)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Periods HonorUpdate="daily"
         ArenaUpdate="weekly"
         DailyUpdate="daily">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Channels Setup
#
#    These directives control some of the aspects in the channel system.
#
#    BannedChannels
#         If you would like to ban users from creating or joining a channel specify them here in a ';'
#         seperated list.
#         Default: ""
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Channels BannedChannels="">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# VoiceChat Setup
#
#    These directives control some of the aspects in the voice chat system.
#
#    Enabled
#         If you want to enable the voice chat system, this must be set to 1.
#         Default: "0"
#
#    ServerIP
#         This is the IP of the voice chat server.
#         Default: "127.0.0.1"
#
#    ServerPort
#         This is the TCP port of the voice chat server.
#         Default: "3727"
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<VoiceChat Enabled="0"
           ServerIP="127.0.0.1"
           ServerPort="3727">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Remote Console Setup
#
#    These directives control the remote administration console.
#
#    Enabled
#         If you want to enable the remote administration console, set this.
#         Default: 0
#
#    Host
#         This is the interface the RA server listens on.
#         Default: "0.0.0.0"
#
#    Port
#         This is the TCP port the RA server listens on. Connect to it with a regular telnet client.
#         Default: 8092
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<RemoteConsole Enabled="0"
               Host="0.0.0.0"
               Port="8092">
      

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Scripting Engine Setup
#
#    ArcEmu can support multiple script backends via the means of loading .dll files for them.
#    This section in the config can enable/disable those backends.
#
#    LUA
#         If you would like to enable the LUA scripting backend, enable this.
#         Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<ScriptBackends LUA="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Movement Setup
#
#    NOTE: For any of these directives to function, movement compression has to be compiled into
#          the server.
#
#    FlushInterval
#        This is the interval at which movement packets will be flushed to the client, i.e. compressed/sent.
#        If you have a high threshold, keeping this at 1-2 seconds will work better.
#        Default: 1000 (one second)
#
#    CompressionRate
#        This is the deflate compression rate. Higher will use more cpu, but smaller packets.
#        Range: 1-9 (or 0 is disable)
#        Default: 1
#
#    CompressionThreshold
#        This is the distance that will be used to determine if an object needs to be sent compressed or
#        normal. It is advised to keep it at least 30 units. This value is used for players.
#        Default: 30.0
#
#    CompressionThresholdCreatures
#        This is the distance that will be used to determine if an object needs to be sent compressed or
#        normal. This value is used for creatures, so it can be a lot lower.
#        Default: 10.0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Movement FlushInterval="1000"
          CompressRate="1"
          CompressThreshold="30.0"
          CompressThresholdCreatures="10.0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Localization Setup
#
#    LocaleBindings
#        This is a list of locale names and the other locale you want to associate with them.
#        For example, to make the European client always use the french language, "enGB=frFR"
#
#        Must be terminated by a space.
#
#        Default: ""
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Localization LocaleBindings="">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Dungeon / Instance Setup
#
#    TakeGroupLeaderID
#        If a player doesn't have an instance id, the group isn't already assigned
#        to an instance and the group or raid leader already have one, the player will
#        be bound to the instance id of the group/raid leader.
#        Default: 1 (enabled)
#
#    SlidingExpiration
#        If enabled, persistent instances will expire relative to the creation time.
#        Otherwise persistent instances will expire at fixed points of time. (blizz like)
#        Default: 0 (disabled)
#
#    DailyHeroicInstanceResetHour
#        Sets the hour of day when heroic instances will be resetted on disabled SlidingExpiration.
#        Default: 5
#
#    CheckTriggerPrerequsites
#        Entering & checks
#        Default: 1
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<InstanceHandling TakeGroupLeaderID="1" 
                  SlidingExpiration="0" 
                  DailyHeroicInstanceResetHour="5" 
                  CheckTriggerPrerequsites="1" >


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# BattleGround settings
# Set Rules for Min / Max players ---- PS.Min for each side | Max for Total
#
#    AlteracValley
#    AV_MIN
#    AV_MAX
#
#    ArathiBasin
#    AB_MIN
#    AB_MAX
#
#    WarSong
#    WS_MIN
#    WS_MAX
#
#    Eyes Of The Storm.
#    EOS_MIN
#    EOS_MAX
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<Battleground AV_MIN="0" 
                            AV_MAX="40" 
                            AB_MIN="4" 
                            AB_MAX="15" 
                            EOS_MIN="4" 
                            EOS_MAX="15" 
                            WS_MIN="2" 
                            WS_MAX="10" >

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

Now you should be ok, start mysql.bat (for server)and apache (for website)from server folder, start arcemu-logon.exe and start arcemu-world.exe from core folder, and you can logon with account ! (admin pass admin) .

For learning how to make account, i suggest you to read on MMO forums, since there'S already answer to all this stuff. Lucky you i was in the mood of helping you out!

PLz remember to add reputation ! (clicking on +Rep on my message)

good luck!

:worthless:

[ME412]

Edit: Might have it now.

[badot]

thanks macmac

that's a very nice guide +rep to that

hey ME412 just follow what macmac said and hoe it will help you and enjoy

[dragonz]

omg i just posted the same thing that macmac, lol i was editing this so it look nice , and he pulled it out before me lol ++ in my tuto i had forgot to change the database used (since mine was there) lol had to change them again o well

[movious]

does anyone use ArcEmu_blizz_rev.2137 ??

i can play for a few minutes and then it disconnect me..
when I alt-tabbed, arcemu-logonserver.exe shows no sign of error (i guess)
but i can't re-log.. my realm just goes offline..


I found a solution , maybe hehe
DISABLE VOICE AND RA ( i don't know why i enabled it in the first time anyway)... stable

gonna test it some more..

[ME412]

right click on X5_fun and restore from batch repack_x19_updatefix_05.02.2009.sql

do the same on forums with cms_updated_03.02.2009.sql

then finally right click on X5_logon and apply logon_updatefix_04.02.2009.sql

Not sure what to do here...

X5_fun?
repack_x19_updatefix_05.02.2009.sql?
cms_update_03.02.2009.sql?
X5_logon?
logon_updatefix_04.02.2009.sql?

I wasn't kidding when I said I was a noob at this stuff... (I liked the no-work repacks /cry)

[badot]

now i see the veterans of the MMOWNED are here to help and in needs of rep (lol)

dragonz, macmac and movious do you know how can i update my db from 2075 to 2137 including all the characters and equipment not in naked toons

[johnstone]

i have dont htis its not working all mach name wiz iv wiped all files and started from a frash install and it still doing the same thing and it has not worked iv updated all from your files and sql and deleted all in mysql and iv reloded and uploded new from the repack and the cms db all is not good for me ...BUT ILL JUST HOLD OUT FOR THE NEXST UPDATE AND hope the best from it for me im not sweeting it thanks for the thots ill trippole rechak it a gin lol o wall if its not going help the thers im ok ill get the new 1 out and hope it works thanks:wave:

hi johnstone
make sure that website db have the same call as in config... examble:
if you call website db forum or cms, you need to make database called forum or db and load cms db from my pack into that specific database
have you done that?

[movious]

Not sure what to do here...

X5_fun?
repack_x19_updatefix_05.02.2009.sql?
cms_update_03.02.2009.sql?
X5_logon?
logon_updatefix_04.02.2009.sql?

I wasn't kidding when I said I was a noob at this stuff... (I liked the no-work repacks /cry)

that's what you have to do to update your database
he's using SQLyog.. are you familiar with that program?

there are 3 basic databases needed to run this server : world, character and logon, but character db often merged with logon db

==>repack_x19_updatefix_05.02.2009.sqlto update your world (named X5_fun) database

==>logon_updatefix_04.02.2009.sql to update your logon (named X5_logon) database

i hope this helps..

[movious]

now i see the veterans of the MMOWNED are here to help and in needs of rep (lol)

dragonz, macmac and movious do you know how can i update my db from 2075 to 2137 including all the characters and equipment not in naked toons

naked? i've experienced that sooo many times.. i just update logon db. don't forget to dump your current character data first..

unless you've modified the db in the past, you'll have to manually update the tables one by one
for me, i drop the last one and restore from kaezan's included world db. i use blizz_x19_updatefix_05.02.2009.sql (214MB unpacked)

still testing it now, but it seems to be alright

i'm trying to help anyone because i need help too lol
o yeah.. i forget to thanks Kaezan for this amazing compile

[zadarkangel]

Hi guys,
I looked a little bit in the scrips and i found some bugs or let say things that make the scripts to fail.
This is the script for king Ymiron from utgarde pinnacle

--[[ Boss -- King Ymiron.lua

This script was written and is protected
by the GPL v2. This script was released
by Azolex of the Blua Scripting
Project. Please give proper accredidations
when re-releasing or sharing this script
with others in the emulation community.

~~End of License Agreement
-- Azolex, October 26, 2008. ]]
-- Not finished

-- Defines
local KY = 26861
local DarkSlashs = 48292
local Banes = 48294
local FetidRots = 48291
local ScreamDeads = 51750
local SpiritBursts = 48529
local SpiritStrikes = 48423
local CHAT_MSG_MONSTER_YELL = 14 
local LANG_UNIVERSAL = 0

-- Registers
RegisterUnitEvent(KY, 1, "KY_EnterCombat")
RegisterUnitEvent(KY, 2, "KY_OnLeaveCombat")
RegisterUnitEvent(KY, 4, "KY_OnDied")
RegisterUnitEvent(KY, 3, "KY_OnKill")

-- Script
function KY_EnterCombat(pUnit, Event)
	pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "You invade my home and then dare to challenge me? I will tear the hearts from your chests and offer them as gifts to the death god! Rualg nja gaborr! ")
	pUnit:RegisterEvent("DarkSlash",5000, 0) 
	pUnit:RegisterEvent("Bane",25000, 2) 
	pUnit:RegisterEvent("FetidRot",9000, 0) 
	pUnit:RegisterEvent("ScreamDead",40000, 2) 
	pUnit:RegisterEvent("SpiritBurst", 6000, 0)
	pUnit:RegisterEvent("SpiritStrike", 2000, 0)
end

function DarkSlash(pUnit,Event)
	pUnit:FullCastSpellOnTarget(DarkSlashs,pUnit:GetClosestPlayer())
end

function FetidRot(pUnit,Event)
	pUnit:FullCastSpellOnTarget(FetidRots,pUnit:GetRandomPlayer(0))
end

function ScreamDead(pUnit,Event)
	pUnit:FullCastSpell(ScreamDeads)
end

function Bane(pUnit,Event)
	pUnit:FullCastSpell(Banes)
end

function SpiritStrike(pUnit,Event)
	pUnit:FullCastSpellOnTarget(SpiritStrikes,pUnit:GetRandomPlayer(0))
end
	
function SpiritBurst(pUnit,Event)  -- Its AOE? --
	pUnit:FullCastSpell(SpiritBursts)
end



function KY_OnKill(pUnit,Event)
	local Choice=math.random(1, 4)
		if Choice==1 then
			pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "Your death is only the beginning! ")
		elseif Choice==2 then
			pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "You have failed your people! ")
		elseif Choice==3 then
			pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "There is a reason I am king! ")
		elseif Choice==4 then
			pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "Bleed no more! ")
end
end

function KY_OnLeaveCombat(pUnit, Event)
	pUnit:RemoveEvents()	
end

function KY_OnDied(pUnit, event, player)
	pUnit:SendChatMessage(CHAT_MSG_MONSTER_YELL, LANG_UNIVERSAL, "What... awaits me... now?")
	pUnit:RemoveEvents()
end

Ofc credits go to Azolex who wrote it, i just modified to work all the spells that king cast the time between is like in original script. seems like lua doesnt like the variables and the name of the functions to be the same( other programs does ). so u can replace this in the king ymiron script and use it. I will try 2 look on other and see what can be made 2 work or i will try 2 make new ones . have fun
ZaDarkangel-- Over and out

[badot]

naked? i've experienced that sooo many times.. i just update logon db. don't forget to dump your current character data first..

unless you've modified the db in the past, you'll have to manually update the tables one by one
for me, i drop the last one and restore from kaezan's included world db. i use blizz_x19_updatefix_05.02.2009.sql (214MB unpacked)

still testing it now, but it seems to be alright

i'm trying to help anyone because i need help too lol
o yeah.. i forget to thanks Kaezan for this amazing compile

thanks for the reply

ok only the character data will be dump
how about the the players item and the account or all of the logon db will be dump i need some help here