+/-

Main Page                   Other languages:   English  •   German   •   French   •   SpanishArcEmu Website     ArcEmu Forum     Bug Tracker

How to set up your world, logon, and character databases.

Contents 1 Installing MySQL 2 Installing a MySQL client 3 Creating empty databases 4 Importing logon and character databases 5 Getting a world database 6 Creating your administrator account 7 Next step

Installing MySQL

MySQL can be downloaded for free from here.

Installing a MySQL client

A SQL client lets you easily connect to the databases. You'll need one to import your initial database.

This is a list of some free SQL clients for Windows:

• SQLyog Community Edition
• Dreamcoder for MySQL
• HeidiSQL
• Navicat Lite
• dbForge Studio for MySQL 5.0 Express

In Linux you can also use the command line client that comes with MySql, which is ultimately the fastest way to import a full database.

Creating empty databases

Using your client, connect to 127.0.0.1 with the username as "root" and the password you set when you installed MySQL.
Create 3 databases and name them:

• arc_logon
• arc_character
• arc_world

(Not recommended but, if you have a limit at your provider on how many databases you can use all tables can be combined into one big database. Adjust the guide accordingly.)

Importing logon and character databases

You will not have a full database after importing these files an your server will not function, please continue reading.

Open your arcemurootfolder\sql directory. In this you will find 3 files:

character_structure.sql
logon_structure.sql
world_structure.sql

After that, switch to your character database and import the character_structure.sql file. If you're using SQLyog or Navicat you can do this by right-clicking the newly-created database, and then selecting Execute Batch File. Repeat this step with the logon database and the logon_structure.sql file.

world_structure.sql is the database structure only and it is for people who want to build their own database project. It doesn't contain any data. It's better to follow the next step how to get a world database.

Getting a world database

The world database contains all data on things like NPCs, GameObjects, quests, gossips. For more documentation on the world database please visit: World Database

There are many different projects with different aims the most popular categories are:

• Blizzlike data that is similar or identical to the real thing.
• Funserver data created or made with insane, game breaking stats or values.

ArcEmu does not have an official database. These are user contributed databases. ArcEmu has nothing to do with them, please consult with the owner's of the projects and or their media or documentation if you need help.

• WhyDB

Website: http://www.whydb.org/

SVN Address: http://svn.xp-dev.com/svn/whydb-users/

• A German language pack for WhyDB you can find here:

Website: http://arcgdb.org/

SVN Link: http://svn.code.sf.net/p/arcgdb/arcgdb/trunk

• Pathway (blizzlike, custom gmisland)

Forum link: http://arcemu.org/forums/index.php?showtopic=22205

Changelog/Installation Instructions: https://github.com/Marforius/Pathway-of-the-Damned

Git: git@github.com:Marforius/ArcAddons.git

To download data from the SVN repositories you need a up to date SVN client, f.ex. for Windows Tortoise SVN Client.

After loading a world project you may have to update the database structures to an actual release. You can find more information on updating the structures yourself on Updating

Creating your administrator account

Switch to your logon database. Run the following query (replacing the values for login and password with your own):

 INSERT INTO `accounts` (login, password, gm, flags, forceLanguage, banned) VALUES ('admin', 'admin', 'az', '24', 'enEN', '0');

A breakdown of this query for those that do not understand SQL:

• Username (login): Admin
• Password: Admin
• GM Level: az (for all commands)
• Expansion: All
• Banned: Not banned. (the field doesn't have a default value, so it's required)

Next step

After setting up the database correctly, you're now ready to move on to Server configuration.