Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.


Panel
borderColor#3399cc
bgColor#DCF1FC
titleColor#FFFFFF
titleBGColor#3399cc
borderStylesolid
titleGuide

This article is part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps.

Sección


Columna

<< Step 3: Server Setup


Columna

Step 5: Networking >>




Nota

Before proceeding, please make sure that you have compiled your sources and they are up-to-date.


Getting Started with Trinity Database (TDB)

Since this commit we introduced a new and automatic way of installing and keeping the databases up-to-date.

This is described in more detail in the following instructions.


Panel
borderColor#BBB
bgColor#F0F0F0
borderStylesolid

Contents

Tabla de contenidos
maxLevel2


Downloading the Database

Download the latest database compilation from TrinityCore Downloads (you may need to click on Next at page footer to see the proper TDB files).

  • Note that there are different database compilations available for different branches of TrinityCore, for example 3.3.5 and master.

Click the database release you want to download, scroll down to the bottom and you should see a link to download TDB_full_*.7z the green Download button on top right next to right column.

  • You want to download the file in .7z format - that is the database download and the others are not
  • The file is in .7z format, so you will need an archive program like 7zip to unpack it.
Advertencia
titleImportant

There are multiple .sql files to choose from in the .7z archive. If this is your first time installing TrinityCore, you will ONLY need the file/s with the name starting by "TDB_full" on your worldserver directory (the files inside updates are made to update from older TDB revisions without having to apply every file if you have autoupdater disabled (NOT RECOMMENDED)).

Installing The Trinity Databases

Advertencia

Import the content of https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql (master branch) or https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql (3.3.5a branch) with your favorite mysql client with root account before starting core.

TIP: edit those 2 files and change default password to something else for increased security (remember to edit conf files to use new password).


Expandir
titleTrinityCore Databases (expand)

Trinity needs 3 databases to run at 3.3.5 branch and 4 for master - AuthCharacters, World and hotfixes (master only):

  • auth - holds account data - usernames, passwords, GM access, realm information, etc.
  • characters - holds character data - created characters, inventory, bank items, auction house, tickets, etc.
  • world - holds game-experience content such as NPCs, quests, objects, etc
  • hotfixes (master only) - holds fixes not already added to the core or other official databases.


From the unpacked 7z folder copy the SQL files that start with "TDB_world_" and "TDB_hotfixes_" (6.x branch only) to the directory where your worldserver binary is (DON'T RENAME THOSE FILES OR AUTOMATIC SETUP WILL FAIL).

NOTICE: you don't need to import any databases, only the file creating users. If you have plans to import databases manually you need to disable autoupdater on config files.

If you have plans to change default mysql usernames and passwords make sure you have set valid database login information and the table names you want to use in the same config files (authserver/bnetserver/worldserver.conf) under "CONNECTIONS AND DIRECTORIES".

  • Notice that the databases are not created yet. The names you set in the config will be used for the created databases.

Start worldserver and press enter when it asks if you want to create databases.


Info
  • If you get errors you may want to check your mysql login credentials in worldserver.conf and read the error message as it may tell you what to do.
  • If you get errors finding the TDB_world_ file, make sure to cd into the /bin/ folder first.
  • If you have hand created usernames, be sure they have create/alter/delete permissions.
  • You may also have deleted or moved the source folder that was used to compile the server.
    In that case you should set the setting called "SourceDirectory" in worldserver.conf under "CONNECTIONS AND DIRECTORIES" to point to the source folder you moved or downloaded.


After the server has created the databases it will look for maps and vmaps, if not found it will exit.

Keeping the DB up to date

Both core and DB fixes will be committed to the TrinityCore repository, which you may also view in Git Extensions by following the "Fetch" instructions in Keeping the Source Up-to-Date Windows / Linux. Pending fixes can be found on our tracker with data from the developers and contributors.

Final Steps - Running and Connecting to Your Server

After completing all the steps listed above you can now start your server.

  • Run the authserver (bnetserver on master)  and worldserver to run your server. Both must stay running for your server to accept connections to it.
    • Tip: The authserver (bnetserver on master) allows you to enter your username (email on master)/password to connect to the Realm Selection screen, and the worldserver allows you to connect to the realm itself. Once you are in-game, the authserver (bnetserver on master) can be safely closed if you wish.


Advertencia

!NEVER! create an account directly into your database unless you are ABSOLUTELY SURE that you know what to do and how to do it!


  • Next create your Login Account by typing directly into the worldserver window the GM Command account create. Syntax: account create $account $password – (see examples below)
  • If you wish to set the account as a GM then type into the worldserver window: account set gmlevel $account #level #realmid where $account is the account name to change, #level can be 0-3 and #realmid is the realm ID. Setting a #level of "3" is GM account level (higher numbers = more access), and the "-1" is the realm ID that stands for "all realms".

    Sugerencia

    Open the world database in your database management tool and find the command table. This table shows a full list of GM commands, their descriptions, and the security (GM level) needed to use them. You will not find a more accurate list of current GM commands anywhere else (assuming you keep your database up-to-date). The security level for a given command identifies that THAT GM level can use the command, along with all GM levels above it. For example, if a command has a security of 2, all accounts with a GM level of 2, 3, and 4 will be able to use it. More detailed information can be found at GM Commands Page.


  • Minimize your servers and run WoW (never run WoW using the Launcher unless you edited the realmlist.wtf's patchlist option above).
  • Log in using the user/pass you just created.
  • The Trinity realm should be selectable. Log in, create a character, and you're all done!

Account Creation Examples:

3.3.5

To create your account:

Type: account create <user> <pass>

Example: account create test test

To set your account level:

Type: account set gmlevel <user> 3 -1

Example: account set gmlevel test 3 -1

Login to your account:

Log in with account test and password test through wow.exe.

master

To create your account:

Type: bnetaccount create <user> <pass>

Example: bnetaccount create test@test test

To set your account level:

Type: account set gmlevel <user#realm> 3 -1

Example: account set gmlevel 1#1 3 -1

Note: The username used for setting your gmlevel is not the same as the username you create with bnetaccount. You must manually find the username in auth.account.username. These are formatted as 1#1, 2#1, etc.

Login to your account:

Log in with email test@test and password test.through Wow_Patched.exe or Wow-64_Patched.exe.

Troubleshooting

"Unable to open wmo_list.txt! Nothing extracted."

you need to run Mapextractor.exe before the makevmaps_simple.bat.


Expandir

Note: You can run the following query on the World database to see your current DB and core revision:

Bloque de código
languagesql
SELECT * FROM `version`;

This assumes that you have completed the previous steps of the installation guide.

Note: If you have made any custom changes to your database, you may wish to backup (export) all three of them (world, characters, and auth) before performing the next few steps.

Sugerencia
titlePro Tip

If your world database is ever corrupted (ex. creatures or objects are accidentally deleted), it is easy to revert it back to its original state by dropping your world database.



Thanks to the automatic DB updater the single step you have to do, is to fetch a new revision (Keeping the Source Up-to-Date WindowsLinux) and the appropriate updates will we applied at server startup.

Insertar extracto
_Installation Helper
_Installation Helper
nopaneltrue


Panel
borderColor#3399cc
bgColor#DCF1FC
titleColor#FFFFFF
titleBGColor#3399cc
borderStylesolid
titleGuide

This article is part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps.

Sección


Columna

<< Step 3: Server Setup


Columna

Step 5: Networking >>