AzerothCore CN - docs-en

ac-dashboard-core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

## Introduction The AzerothCore bash dashboard is a collection of scripts that help with the installation and maintenance of an AzerothCore server. It allows to easily install, update and execute AzerothCore on your machine in a tremendously small amount of steps.

account.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_access.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_access <-Back-to:Auth The `account_access` table This table holds security access level for any realm in realmlist table. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO TINYINT UNSIGNED NO INT

account_banned.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_banned <-Back-to:Auth The `account_banned` table This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI

account_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_data <-Back-to:Characters The `account_data` table Contains data about client account and settings. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Account Identifier TINYINT UNSIGNED PRI NO 0

account_instance_times.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_instance_times <-Back-to:Characters The `account_instance_times` table This table controls how many instances the account's characters have been in last 1 hour. If there is 5 records per account, the player won't be able to enter another instance. Structure

account_muted.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_muted <-Back-to:Auth The `account_muted` table This table contains account IDs whose characters are assigned a ban chat (mute). GM-Command: .mute [$playerName] $timeInMinutes [$reason]. Disable chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.

account_tutorial.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

account_tutorial <-Back-to:Characters The `account_tutorial` table This table is used to store the tutorial state of all the accounts. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Unique Account Identifier INT

achievement.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:31:35+00:00

Achievement ''%%Back-to:DBC%%'' Achievement.dbc This DBC contains all achievements. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer Achievement ID 2 Faction Integer -1: both, 0: Horde or 1: Alliance 3 Map Integer Only set if achievement is related to a zone, otherwise set to -1

achievement_criteria.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:32:24+00:00

Achievement Criteria ''%%Back-to:DBC%%'' Achievement_Criteria.dbc This DBC has been added with WoW 3.0.1.8303 and contains the needed criteria to obtain an achievement. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer Criteria ID 2 Achievement

achievement_criteria_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

achievement_criteria_data <-Back-to:World The `achievement_criteria_data` table This table contains the data that a player needs to obtain / complete in order to receive a given achievement. Structure Field Type Attributes Key Null Default Extra Comment

achievement_dbc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

achievement_dbc <-Back-to:World The `achievement_dbc` table Stores achievement data that is missing in Achievement.dbc Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT SIGNED NO -1 INT SIGNED NO -1

achievement_reward.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

achievement_reward <-Back-to:World The `achievement_reward` table This table describes the reward that you will receive when you obtain a given achievement. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0

achievement_reward_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

achievement_reward_locale <-Back-to:World The `achievement_reward_locale` table It is the table that stores the translations of the table achievement_reward, so that the game client can display the messages in different languages. Structure Field Type Attributes

acore_string.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

acore_string <-Back-to:World The `acore_string` table This table holds all of the strings used internally by the server. This table is provided with the main purpose of translation in mind. To see which locale IDs correspond to what languages, visit the Localization_lang page.

addons.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

addons <-Back-to:Characters The `addons` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(120) SIGNED PRI NO

arch-linux.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Arch Linux Install If you are an Arch Linux user you can install it from AUR (Arch User Repository) Install dependencies Install //base-devel// All you need to install AUR packages is //base-devel// and //git//, you can install them with pacman: $ sudo pacman -S base-devel git Install //AzerothCore//

areatable.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:35:10+00:00

AreaTable ''%%Back-to:DBC%%'' AreaTable.dbc This DBC contains the zone and subzone lists. For the purposes of this wiki article, the zone IDs, names, mapID and AreaID will be included. Version is : 3.3.5a Structure Column Name Type Notes 1 ID Int Zone Area

areatrigger.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

areatrigger <-Back-to:World The `areatrigger` table This table contains trigger points for events in certain coordinates in the maps. Structure Field Type Attributes Key Null Default Extra Comment entry INT UNSIGNED PRI NO AUTO_INCREMENT map

areatrigger_involvedrelation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

areatrigger_involvedrelation <-Back-to:World The `areatrigger_involvedrelation` table Enable a trigger to finish one condition of a quest (explore) If there is a record in the table for a quest, then the quest will not be completed until the player activates this areatriger. The quest is not necessarily finished after that, but that one condition of the quest is satisfied. If the only condition of the quest is to explore an area, then the quest will be complete.

areatrigger_scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

areatrigger_scripts <-Back-to:World The `areatrigger_scripts` table Allows for an area trigger to be scripted with Trinity Script. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT PRI NO char(64) NO Description of the fields

areatrigger_tavern.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

areatrigger_tavern <-Back-to:World The `areatrigger_tavern` table Enable a trigger when player enters a city or tavern. This causes the player to enter a resting state. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED

areatrigger_teleport.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

areatrigger_teleport <-Back-to:World The `areatrigger_teleport` table Contains all the teleport triggers definition. This table is used to complete .dbc file information. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED

arena_team.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

arena_team <-Back-to:Characters The `arena_team` table This table holds the main ArenaTeam information. All created teams or all teams in the process of being created have a record in this table. Structure Field Type Attributes Key Null Default Extra Comment

arena_team_member.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

arena_team_member <-Back-to:Characters The `arena_team_member` table This table holds arena info about specific team members. All arena_team members have a record in this table. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED

auctionhouse.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

auctionhouse <-Back-to:Characters The `auctionhouse` table Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc. Structure Field Type Attributes

autobroadcast.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

autobroadcast <-Back-to:Auth The `autobroadcast` table This table contains the autobroadcast entries for your realms. Values like it's activity, position and Timer (*.On, *.Center, *.Timer) are defined within the worldserver.conf. They are chosen randomly, based on their weight.

aws-tutorial.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Hosting AzerothCore via Amazon AWS Preface: The goal with this guide is for it to be mostly via a command line. There is also the AWS Console that some will find more intuitive, however, for guide longevity (as the AWS Console UI may change) the aws-cli tool will be recommended. Also included will be grep commands to receive only the required output. If the entire output is desired simply remove the

banned_addons.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

banned_addons <-Back-to:Characters The `banned_addons` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO VARCHAR(255) SIGNED NO UNIQUE VARCHAR(255) SIGNED NO

bash_system.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

BASH system AzerothCore uses an advanced bash system that allows us to automate processes such as the sources compilation, module installation, database setup etc. For now we are using bash instead of Python to reduce external dependencies since BASH is a crossplatform scripting language that is already included with

battleground_deserters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

battleground_deserters <-Back-to:Characters The `battleground_deserters` table This table holds datas about BattleGrounds deserters. To enable storing this kind of informations, set Battleground.TrackDeserters.Enable = 1 in worldserver.config file. Structure Field

battleground_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

battleground_template <-Back-to:World The `battleground_template` table Contains information about the different battlegrounds, like how many players are needed to start, how many can be inside the same one, and the locations where each side starts. Structure Field

battlemaster_entry.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

battlemaster_entry <-Back-to:World The `battlemaster_entry` table Holds information on which NPC can start what battleground or arena. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 Entry of a creature

best-practices.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Best Practices A collection of best practices to use AzerothCore. Custom changes * NEVER add custom changes to the AzerothCore sources. Create modules instead. If you need new hooks to implement your custom changes into modules, feel free to send a PR that implements them.

bit-and-bytes-tutorial.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Bit-and_bytes-tutorial” --- # Bits and Bytes Tutorial ## Intro In computing, numbers are internally represented in binary. This means, when you use an integer type for a variable, this will internally be represented as a summation or concatenation of zeros and ones.

broadcast_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

broadcast_text The `broadcast_text` table This table (ref https://github.com/TrinityCore/TrinityCore/commit/60e87db) will have everything you need for your scripts' texts, such as: gossips, creature texts and npc_texts. Its purpose is (will be) used as a globalized table containing the texts as mentionned above, and things like their sounds, their emotes and the languages in which the texts should be said.

broadcast_text_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

broadcast_text_locale The `broadcast_text_locale` table This table will have localized texts for `broadcast_text` table. Used in gossips, creature texts and npc_texts. Its purpose is (will be) used as a globalized table containing the localized texts as mentionned above.

bugreport.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

bugreport <-Back-to:Characters The `bugreport` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT Identifier LONGTEXT SIGNED NO LONGTEXT SIGNED NO Description of the fields

build_info.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

build_info <-Back-to:Auth The `build_info` table Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED PRI NO Identifier INT SIGNED YES INT SIGNED YES INT SIGNED YES CHAR(3) SIGNED

calendar_events.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

calendar_events <-Back-to:Characters The `calendar_events` table Structure Field Type Attributes Key Null Default Extra Comment BIGINT UNSIGNED PRI NO 0 [creator][2] INT UNSIGNED NO 0 VARCHAR(255) SIGNED NO | | | | | VARCHAR(255) | SIGNED | | NO |

calendar_invites.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

calendar_invites <-Back-to:Characters The `calendar_invites` table Structure Field Type Attributes Key Null Default Extra Comment BIGINT UNSIGNED PRI NO 0 BIGINT UNSIGNED NO 0 INT UNSIGNED NO 0 INT UNSIGNED NO | | | |

changelog.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Changelog This file contains the changelogs of all big API changes. 6.0.0-dev.1 | Commit: [[https://github.com/azerothcore/azerothcore-wotlk/commit/de13bf426e162ee10cbd5470cec74122d1d4afa0|de13bf426e162ee10cbd5470cec74122d1d4afa0]] How to upgrade

channels.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

channels <-Back-to:Characters The `channels` table Information and settings for ingame, player-based chat channels (not affecting the default system channels). Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED PRI NO AUTO_INCREMENT

channels_bans.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

channels_bans <-Back-to:Characters The `channels_bans` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED PRI NO INT UNSIGNED NO Description of the fields channelId The

channels_rights.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

channels_rights <-Back-to:Characters The `channels_rights` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(128) SIGNED PRI NO INT UNSIGNED NO INT UNSIGNED NO VARCHAR(255) SIGNED NO | | | |

characters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

characters <-Back-to:Characters The `characters` table This table holds vital static information for each character. It is used to create the player objects in-game. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0

character_account_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_account_data <-Back-to:Characters The `character_account_data` table Contains data about character settings. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 TINYINT UNSIGNED PRI NO 0 INT

character_achievement.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_achievement <-Back-to:Characters The `character_achievement` table This table holds information on the achievements a character has earned/completed. Note: if you delete a “realm first” achievement from the characters database, you have to reboot the server to take it into account.

character_achievement_progress.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_achievement_progress <-Back-to:Characters The `character_achievement_progress` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO SMALLINT UNSIGNED PRI NO INT UNSIGNED NO INT

character_action.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_action <-Back-to:Characters The `character_action` table Contains all the individual button data for each character. A button is any of the places in the GUI where you can place for example a spell, item, or macro as a shortcut. Structure Field Type Attributes

character_arena_stats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_arena_stats <-Back-to:Characters The `character_arena_stats` table This table holds information about character's matchmaker rating in all team types. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO

character_aura.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_aura <-Back-to:Characters The `character_aura` table Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects.

character_banned.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_banned <-Back-to:Characters The `character_banned` table This table lists all of the characters that have been banned along with the date when (or if) the ban will expire. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED

character_battleground_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_battleground_data <-Back-to:Characters The `character_battleground_data` table This table holds information for each character in a battleground. Also hold info about their last position before joining the battleground. Structure Field Type Attributes Key

character_battleground_random.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_battleground_random <-Back-to:Characters The `character_battleground_random` table This table stores battlegrounds IDs for random battleground sessions. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0

character_brew_of_the_month.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_brew_of_the_month <-Back-to:Characters The `character_brew_of_the_month` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED NO 0 Description of the fields guid field-no-description|1

character_declinedname.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_declinedname <-Back-to:Characters The `character_declinedname` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier VARCHAR(15) SIGNED NO | | | | | VARCHAR(15) | SIGNED | | NO |

character_entry_point.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_entry_point <-Back-to:Characters The `character_entry_point` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier FLOAT SIGNED NO 0 FLOAT SIGNED NO 0

character_equipmentsets.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_equipmentsets <-Back-to:Characters The `character_equipmentsets` table This table holds info about player's equipment manager settings. Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED NO UNIQUE BIGINT SIGNED

character_gifts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_gifts <-Back-to:Characters The `character_gifts` table This table holds data about wrapped/gift items. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO 0 INT UNSIGNED PRI NO 0 INT UNSIGNED

character_glyphs.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_glyphs <-Back-to:Characters The `character_glyphs` table Contains all the individual glyph data for each character. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO TINYINT UNSIGNED PRI NO 0

character_homebind.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_homebind <-Back-to:Characters The `character_homebind` table Contains information on the location where characters get teleported when they use their Hearthstone. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI

character_instance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_instance <-Back-to:Characters The `character_instance` table Contains the instance data for characters. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 TINYINT UNSIGNED

character_inventory.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_inventory <-Back-to:Characters The `character_inventory` table Contains all the character inventory data, including the bank data. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED Unique NO 0 Global Unique Identifier

character_pet.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_pet <-Back-to:Characters The `character_pet` table This table holds the pet data for each pet summoned by anyone in the game. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0

character_pet_declinedname.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_pet_declinedname <-Back-to:Characters The `character_pet_declinedname` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 VARCHAR(12) SIGNED NO NULL VARCHAR(12)

character_queststatus.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus <-Back-to:Characters The `character_queststatus` table Holds information on the quest status of each character. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier INT

character_queststatus_daily.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus_daily <-Back-to:Characters The `character_queststatus_daily` table Holds information on the daily quest status of every player. The quest must have type = 87 or the 4096 flag at QuestFlags. Structure Field Type Attributes Key Null Default

character_queststatus_monthly.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus_monthly <-Back-to:Characters The `character_queststatus_monthly` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier INT UNSIGNED PRI NO 0 Quest Identifier

character_queststatus_rewarded.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus_rewarded <-Back-to:Characters The `character_queststatus_rewarded` table This table holds information of every rewarded quest to a player. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier

character_queststatus_seasonal.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus_seasonal <-Back-to:Characters The `character_queststatus_seasonal` table Holds information on the seasonal quest (quests with ZoneOrSort of -22) status of every player. The quests reset at the end of the corresponding eventEntry. Structure Field

character_queststatus_weekly.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_queststatus_weekly <-Back-to:Characters The `character_queststatus_weekly` table Holds information on the weekly quest status of every player. The timers reset at the same time the Raids reset. Structure Field Type Attributes Key Null Default Extra

character_reputation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_reputation <-Back-to:Characters The `character_reputation` table This table holds the reputation information for each character. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier

character_skills.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_skills <-Back-to:Characters The `character_skills` table This table holds a listing of all skill for each character. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier SMALLINT

character_social.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_social <-Back-to:Characters The `character_social` table Contains data about character's friends/ignored list. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Character Global Unique Identifier INT

character_spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_spell <-Back-to:Characters The `character_spell` table Holds information for each character's spells. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier MEDIUMINT UNSIGNED PRI

character_spell_cooldown.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_spell_cooldown <-Back-to:Characters The `character_spell_cooldown` table Holds the remaining cooldowns from either character spells or item spells for each character. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI

character_stats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_stats <-Back-to:Characters The `character_stats` table This table holds information on all the stats regarding the character. Used for external applications such as websites. See worldserver.conf: PlayerSave.Stats.* Structure Field Type Attributes Key

character_talent.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

character_talent <-Back-to:Characters The `character_talent` table Contains all the individual talent data for each character. This is only used as a storage table, values get read from here and written to character_spell, and vice-versa, when a player switches specs.

chrclasses.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

ChrClasses.dbc ''%%Back-to:DBC%%'' This DBC contains all possible player classes. Version is 3.3.5a Structure Column Name Type Notes 1 ID Integer 2 Unknown Integer 1 for Hunter, Rogue, and Shaman, 9 for Death Knight, 0 for the others. Removed in Cataclysm.

chrraces.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

ChrRaces.dbc ''%%Back-to:DBC%%'' This DBC contains all possible races, some of which are unused and unavailable to players. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2 Integer 3 FactionID iRefID Faction template ID. The order in the creation screen depends on this.

classic-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Classic Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Installation Step 1: Requirements >> Every step of the guide is divided in three tabs regarding different operating systems (Linux, macOS and Windows).

client-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Client Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. Optional << Step 7: Keeping the Server Up-to-Date Step 9: Installing a Module >> AzerothCore does not distribute a client. You will need to find your own clean 3.3.5a client on the internet.

cmake-options.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/CMake-options” --- # CMake Options ## PERFORMANCE If you want to disable performance optimizations, add this flag `-DENABLE_EXTRAS=0` Only necessary if you're debugging. ## EXTRA LOGS If you want to enable extra logs, add this flag: `-DENABLE_EXTRA_LOGS=1`

command.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

command <-Back-to:World The command table Holds help and security information for commands. This table does NOT create new commands, it only sets / overrides security and provides help. Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(50)

common-errors.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # Common Errors Did this FAQ not answer your questions? Read [How to ask for help](how-to-ask-for-help.md) on how to proceed with your question in the best way. --- ## Database-related errors #### [ACE00001](#a-hreface00001ace00001a) I can't start my Auth/WorldServer, I get: ``` [ERROR]: Table 'acore_world.table' doesn't exist Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders. ```…

conditions.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

conditions <-Back-to:World The `conditions` table This table allows you to define conditions for various systems - Gossip, loot etc. Structure

config-overrides-with-env-var.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Config Overrides with Env Var Environment variables can override config values. By default the core will listen to conf values in this order: 1. Environment variables 2. .conf file 3. Base values defined in the core Environment variables keys are autogenerated based on the keys defined in .conf file.

contribute.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Contribute” --- # Contribute You can contribute in several ways to AzerothCore: - [Commenting an open issue](#how-to-comment-an-issue) - [Opening an issue](#how-to-open-an-issue) - [Testing a pull request](#how-to-test-a-pull-request)

core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Core Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 1: Requirements Step 3: Server Setup >> Linux Core Installation macOS Core Installation Windows Core Installation
Help If you are still having problems, check: * FAQ *

core-scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # Core Scripts When dealing with Creature- and Spell scripts we should always use the new registry macros introduced in [this]() commit. ## Creature Scripts ### World Spawned Creatures ```cpp struct npc_scripted_creature : public CreatureAI { public:

corpse.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

corpse <-Back-to:Characters The `corpse` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Character Global Unique Identifier FLOAT SIGNED NO 0 FLOAT SIGNED NO 0 FLOAT SIGNED NO

cpp-code-standards.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # C++ Code Standards ## Intro ### Why are coding standards important? It makes it easier for everyone to maintain and read the written code as well as it gives us more control over it. It can also act as a safeguard to prevent errors in the code.

create-a-module.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Create-a-Module” --- # Create a Module ## How to create a module Before start we suggest you to read [Documentation about modular structure](The-Modular-Structure) to understand the way AzerothCore works.

create-a-script.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Create a Script Script vs module On AzerothCore, we don't really use the usual scripts like in other emulators. Instead, we work with modules which are way more practical to use. See Create-a-Module Scripts You still want to make a simple script before switching to modules? Read below.

creating-accounts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Creating-Accounts” --- # Creating Accounts To be able to log in to your new server you need an account. It is recommended to use security level 3 for your own account. Run the following commands in the Worldserver console.

creature.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature <-Back-to:World Table Structure Contains individual creature spawn data for each individual spawn of each individual creature in the game world. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO NULL Auto Increment

creature_addon.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_addon <-Back-to:World The `creature_addon` table The creature_addon and creature_template_addon tables define different things that are applied on creatures when they are loaded. These “different things” can be for example to have the creature be mounted, to have it emote something, to have it display an aura effect, etc. Through the use of the fields in this table, many things can be changed about the outward visual appearance of the creature. The creature_template_addon table affec…

creature_classlevelstats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_classlevelstats Table Structure This table contains the base values for creature health, mana, armor, attack power, ranged attack power, damage, and experience. Field Type Attributes Null Default Extra Comment TINYINT UNSIGNED NO

creature_equip_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_equip_template <-Back-to:World **Table: creature_equip_template** This table contains all the equipment combinations that can be sent for each creature. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI

creature_formations.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_formations <-Back-to:World The `creature_formations` table This table allows to group mobs. Members of group will follow others, and attack their targets. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO NULL

creature_model_info.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_model_info <-Back-to:World The `creature_model_info` table This table contains all models of mobs, their gender and other information that are model related. This means that when a creature uses another model, this information will change as well. Structure

creature_onkill_reputation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_onkill_reputation <-Back-to:World The `creature_onkill_reputation` table This table controls the reputation given by creatures when killed by other players. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI

creature_questender.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_questender <-Back-to:World The `creature_questender` table Holds NPC quest ender relations on which NPCs finishes which quests. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 Identifier MEDIUMINT

creature_questitem.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [creature_questitem](creature_questitem) Column | Type | Description --- | --- | --- CreatureEntry | INT UNSIGNED | Entry ID of a creature that drops quest items when the related quest is active. Idx | INT UNSIGNED | Index ItemId | INT UNSIGNED | Entry ID of an item that can be looted from the creature when the related quest is active.

creature_queststarter.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_queststarter <-Back-to:World The `creature_queststarter` table Holds NPC quest giver relations on which NPCs start which quests. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 Identifier MEDIUMINT

creature_respawn.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_respawn <-Back-to:Characters The `creature_respawn` table This table holds the respawn time when creatures should be respawned in the world. In case of a server crash, this table holds the respawn data so that the creatures don't respawn immediately on server restart. How often the respawn time is saved for creatures can be controlled in worldserver.conf.dist at SaveRespawnTimeImmediately.

creature_summon_groups.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_summon_groups <-Back-to:World Table: creature_summon_groups This table holds data about temporary summoned creatures. It is possible to group summons and create boss waves of adds etc. Structure Field Type Attributes Key Null

creature_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_template <-Back-to:World The `creature_template` table This table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table. Structure Field

creature_template_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_template_locale <-Back-to:World The `creature_template_locale` table This table is used to provide to localized clients with localized string for creatures. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT

creature_template_movement.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_template_movement <-Back-to:World This table contains the description of creatures movements, where the creature can move and attack. This table can be overriden by `creature_movement_override` Table Structure Field Type Attributes Key Null Default

creature_template_resistance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_template_resistance <-Back-to:World The `creature_template_resistance` table Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO TINYINT UNSIGNED PRI NO SMALLINT SIGNED YES Null

creature_template_spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_template_spell <-Back-to:World The `creature_template_spell` table Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO TINYINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED YES Null

creature_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_text Table: creature_text Short Description: This table holds all the speech text (whisper, say, yell, emote text in speech bubbles and in the chat window) used within SMART_SCRIPTS table and core scripts. Detailed Description:

creature_text_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

creature_text_locale <-Back-to:World The `creature_text_locale` table This table is used to provide to localized clients with localized string for creatures texts. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI

database-auth.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database Auth A * account * account_access * account_banned * account_muted * autobroadcast B * build_info I * ip_banned L * logs * logs_ip_actions M * motd R * realmcharacters * realmlist S * secret_digest U * updates * updates_include * uptime V * version_db_auth

database-characters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database Characters A * account_data * account_instance_times * account_tutorial * addons * arena_team * arena_team_member * auctionhouse B * banned_addons * battleground_deserters * bugreport C * calendar_events * calendar_invites * channels * channels_bans * channels_rights * character_account_data * character_achievement * character_achievement_progress * character_action * character_arena_stats * character_aura * character_banned * characte…

database-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 3: Server Setup Step 5: Networking >> Creating the Database in MySQL Creating the Databases and User

database-keeping-the-server-up-to-date.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> - First make sure that your core is up-to-date. If you want to know how the SQL directory works or plan to have custom changes we recommend you read

database-management-tool.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database Management Tool * mysql cli (Fastest) * SQLYog Community Edition * HeidiSQL (Best for beginners) * MySQL Workbench (already installed if you chose to install full MySQL package) * DBeaver (Multiplattform Database Management Tool)

database-manual-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Database-Manual-Setup” --- # Database Manual Setup ## How to setup the AzerothCore DB manually ### MySQL client tool In order to set up your database, you can use whatever MySQL client you like. Some examples [here](Database-client.md).

database-only-quick-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

AC Database-only quick setup This tutorial explains how to quickly setup an instance of the AC Database. Introduction Sometimes you need an AzerothCore DB up and running without having to setup the whole server, for example to use applications like

database-squash.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Database-squash” --- # Database Squash ## Introduction We do this to update the base files so that a clean install of the server is done quicker and all update files are not needed to be run, as they will already exist in the base files.

database-world.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Database World A * achievement_criteria_data * achievement_dbc * achievement_reward * achievement_reward_locale * acore_string * areatrigger * areatrigger_involvedrelation * areatrigger_scripts * areatrigger_tavern * areatrigger_teleport B * battleground_template * battlemaster_entry * broadcast_text * broadcast_text_locale C * command * conditions * creature * creature_addon * creature_classlevelstats * creature_equip_template * creature_formation…

dbc-areatrigger.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:35:36+00:00

AreaTrigger ''%%Back-to:DBC%%'' AreaTrigger.dbc This DBC contains information about the triggers of the in-game areas. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2 iRefID_Map Integer 3 X Float 4 Y Float 5 Z Float

dbc-index.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

DBC Index * Achievement * Achievement_Criteria * AreaTable * AreaTrigger * ChrClasses * ChrRaces * Emotes * Faction * FactionTemplate * Holidays * Languages * Map * PageTextMaterial * SkillLine * SummonProperties * Spell * TotemCategory

debian12-install-guide.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

AzerothCore Debian 12 Quick Install Guide This is a streamlined guide for installing AzerothCore to a Debian 12 server, securing it, and enabling one-command maintenance from your Windows PC. Table of Contents * * * * * * *

digital-ocean-video-tutorial.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

## Introduction This tutorial will walk you through the entire AzerothCore server setup process, and will help get you familiar with using Debian and Command Line Interfaces (CLI). In this tutorial, we'll be going over the following: - Looking at various tools to help you get your server up and running, such as MySQL Clients, SSH Clients, SFTP Clients, and powerful file editors. - Configuring a Droplet on DigitalOcean from scratch - Building the Core - Loading the Database

directory-structure.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Directory-Structure” --- # Directory Structure AzerothCore and our modules is following directory structure standard from hw-core: ” target=“_blank”>Standard Directory Structure This structure is conformed to our [modular architecture](The-Modular-Structure).

disables.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

disables <-Back-to:World The `disables` table This table is used to disable dungeons/bgs/spells/etc. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO NULL INT UNSIGNED PRI NO NULL TINYINT UNSIGNED

documentation-index.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: /documentation_index --- # Documentation index ## How to Install * [Installation Guide](installation) * [Installing a module](installing-a-module) ## Database * [DB auth](database-auth.md) * [DB characters](database-characters.md) * [DB world](database-world.md)

dungeon_access_requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

dungeon_access_requirements <-Back-to:World The `dungeon_access_requirements` table Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO TINYINT UNSIGNED PRI NO MEDIUMINT UNSIGNED PRI NO

dungeon_access_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

dungeon_access_template <-Back-to:World The `dungeon_access_template` table Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO AUTO_INCREMENT MEDIUMINT UNSIGNED KEY NO FK_dungeon_access_template__instance_template

emotes.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:36:02+00:00

Emotes ''%%Back-to:DBC%%'' This DBC contains emotes which can be used by NPCs. Structure Column Type Comment 1 long An ID for the emote. Must be unique. 2 str A descriptive name for the emote. 3 long Refers to an ID in this DBC file. This is the ID of the animation to play.

environment-variable.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Environment-Variable” --- # Environment Variable ### Introduction To use MySQL server on the command line, you must have the correct system path. This is usually done automatically. How to check if the MySQL server is a Environment Variable: * Press `Windows + R` and type cmd * In the CMD opened type `mysql`

event_scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [event_scripts](event_scripts) # event\_scripts ### Information Holds scripts activated whenever an event is activated, be it by an object or as the spell effect SPELL\_EFFECT\_SEND\_EVENT (61).

exitcodes.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Exit Codes AzerothCore has 3 default exit codes that are called if you shutdown, restart or crash the server. enum ShutdownExitCode { SHUTDOWN_EXIT_CODE = 0, ERROR_EXIT_CODE = 1, RESTART_EXIT_CODE = 2, }; SHUTDOWN_EXIT_CODE is called when you use the commands

exploration_basexp.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

exploration_basexp <-Back-to:World

This table holds the base experience point information needed for when a player explores a new zone.

Field Type Attributes Key Null Default TINYINT unasigned PRI NO 0 MEDIUMINT SIGNED NO 0 Description of the fields

faction.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T22:45:27+00:00

Faction Faction.dbc ''%%Back-to:DBC%%'' This DBC contains information on all of the base factions. These factions are unique and represent a faction with which a player can gain reputation. IMPORTANT: These values are used for ALL tables EXCEPT the creature_template and gameobject_template_addon tables. Structure

factiontemplate.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:36:34+00:00

FactionTemplate FactionTemplate.dbc ''%%Back-to:DBC%%'' This DBC contains information on all of the individual factions. A faction entry from this DBC contains all of the needed data to calculate hostility, friendliness, or neutrality to any other faction in this DBC.

faq.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/FAQ” tableofcontents: 1 --- # Frequently Asked Questions If you have trouble installing or compiling AzerothCore read [Common Errors](common-errors.md). Did this FAQ not answer your questions? Read [How to ask for help](how-to-ask-for-help.md) on how to proceed with your question in the best way.

file-headers.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

File Headers To make the files clean we use a standard format for new file headers. Standard header for all files: /* * This file is part of the AzerothCore Project. See AUTHORS file for Copyright information * * This program is free software; you can redistribute it and/or modify it * under the terms of the GNU Affero General Public License as published by the * Free Software Foundation; either version 3 of the License, or (at your * option) any later version. * * This program is di…

final-server-steps.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Final Server Steps Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 5: Networking Step 7: Keeping the Server Up-to-Date >> Starting the server * Run authserver and worldserver in your build folder.

freebsd.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

FreeBSD Install Dependencies You need to install the build and runtime dependancies: pkg install mysql80-server pkg install cmake pkg install boost-all Install Azerothcore Clone the project git clone https://github.com/azerothcore/azerothcore-wotlk.git --branch master --single-branch azerothcore

gameobject.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject <-Back-to:World The `gameobject` table This table holds the individual object data on each spawned game object in the world. This data along with the object's template data is read and used to instantiate the objects in the world. Structure Field Type

gameobject_addon.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_addon <-Back-to:World The `gameobject_addon` table Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 TINYINT UNSIGNED NO 0 INT UNSIGNED NO 0 Description of the fields guid gameobject.guid invisibilityType

gameobject_questender.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_questender <-Back-to:World The `gameobject_questender` table Holds game object quest taker relations. The game objects in this table should all be of type QUESTGIVER (2). Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT

gameobject_questitem.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [gameobject_questitem](gameobject_questitem) Column | Type | Description --- | --- | --- GameObjectEntry | INT UNSIGNED | Entry ID of a gameobject that contains quest items when the related quest is active. Idx | INT UNSIGNED | Index ItemId | INT UNSIGNED | Entry ID of an item that can be looted from the gameobject when the related quest is active.

gameobject_queststarter.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_queststarter <-Back-to:World The `gameobject_queststarter` table Holds game object quest giver relations. The game objects in this table should all be of type QUESTGIVER (2). Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT

gameobject_respawn.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_respawn <-Back-to:Characters The `gameobject_respawn` table This table holds the re-spawn time when game objects should be re spawned in the world. In case of a server crash, this table holds the re-spawn data so that the game objects don't re-spawn immediately on server restart. How often the re-spawn time is saved for game objects can be controlled in trinitycore.conf at SaveRespawnTimeImmediately. Usually the only objects that despawn and need to be re-spawned are chests and doo…

gameobject_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_template Contains template of all gameobjects Structure Field Type Attributes Key Null Default Extra Comment entry MEDIUMINT UNSIGNED PRI NO 0 type TINYINT UNSIGNED NO 0 displayId MEDIUMINT UNSIGNED NO

gameobject_template_addon.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_template_addon This table holds additional information on gameobjects. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 SMALLINT UNSIGNED NO 0 INT UNSIGNED NO 0

gameobject_template_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gameobject_template_locale <-Back-to:World The `gameobject_template_locale` table This table is used to provide to localized clients with localized string for gameobjects. Structure Field Type Attributes Key Null Default Extra Comment

game_event.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event Table Structure This table holds definitions for all game events that are activated or deactivated automatically by the Game Event System in the core. Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI

game_event_arena_seasons.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_arena_seasons <-Back-to:World The `game_event_arena_seasons` table This information comes from sniffs and is NOT supposed to be changed. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED NO Unique Entry of the game event.

game_event_battleground_holiday.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_battleground_holiday <-Back-to:World The `Game_event_battleground_holiday` table This table is used to add a holiday to a battleground, for things like extra reputation / honor. Structure Field Type Attributes Key Null Default Extra Comment

game_event_condition.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_condition <-Back-to:World The `game_event_condition` table This table contains conditions to meet for the specified game event to be completed. Also contains the world state fields used for reporting the given conditions progress and/or max required value. This table will do absolutely nothing if you have not set the event to be a world event.

game_event_condition_save.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_condition_save <-Back-to:Characters The `game_event_condition_save` table Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO INT UNSIGNED PRI NO 0 FLOAT SIGNED YES 0 Description of the fields

game_event_creature.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_creature <-Back-to:World The `game_event_creature` table Contains all creature instances that have to be spawned/unspawned during defined game events. Structure Field Type Attributes Key Null Default Extra Comment TINYINT SIGNED NO

game_event_creature_quest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_creature_quest <-Back-to:World The `game_event_creature_quest` table This table holds information on quests that should only be available when an event is currently taking place. Structure Field Type Attributes Key Null Default Extra Comment

game_event_gameobject.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_gameobject <-Back-to:World The `game_event_gameobject` table Contains all gameobjects instances that participate to any game event. Structure Field Type Attributes Key Null Default Extra Comment TINYINT SIGNED NO Entry of the game event. Put negative entry to remove during event.

game_event_gameobject_quest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_gameobject_quest <-Back-to:World The `game_event_gameobject_quest` table This table holds information on quests that should only be available when an event is currently taking place. Structure Field Type Attributes Key Null Default Extra Comment

game_event_model_equip.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_model_equip <-Back-to:World The `game_event_model_equip` table Contains all creature instances that need to change display id and/or equipment during defined game events. Structure Field Type Attributes Key Null Default Extra Comment TINYINT

game_event_npcflag.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_npcflag <-Back-to:World The `game_event_npcflag` table This table contains npcflags that are to be added to an NPC when the specified event is active for the creature with the given guid. Structure Field Type Attributes Key Null Default Extra

game_event_npc_vendor.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_npc_vendor <-Back-to:World The `game_event_npc_vendor` table This table allows you to change the items a vendor sells, or to create a vendor list for an NPC who does not sell items unless an event is active. Structure Field Type Attributes Key Null Default

game_event_pool.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_pool <-Back-to:World The `game_event_pool` table This table determines if a given pool is active for a given game event. Structure Field Type Attributes Key Null Default Extra Comment TINYINT SIGNED NO Entry of the game event. Put negative entry to remove during event.

game_event_prerequisite.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_prerequisite <-Back-to:World The `game_event_prerequisite` table This table contains events that must have been completed to start the given event. You can have more than one event that must be completed before the next will start. Structure Field Type

game_event_quest_condition.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_quest_condition <-Back-to:World The `game_event_quest_condition` table This table contains the mapping of a quest in a world event to the condition that it will fulfill. It also contains how much a given quest will add to a condition once that quest is completed by a player.

game_event_save.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_save <-Back-to:Characters The `game_event_save` table Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO TINYINT UNSIGNED NO 1 INT UNSIGNED NO 0 Description of the fields eventEntry

game_event_seasonal_questrelation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_event_seasonal_questrelation <-Back-to:World The `game_event_seasonal_questrelation` table Holds information on the game event seasonal quest relations to allow for resetting of quests with ZoneOrSort of -22. Structure Field Type Attributes Key Null Default

game_graveyard.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_graveyard <-Back-to:World Field Type Key Null Default INT PRI NO 0 INT NO 0 FLOAT NO 0 FLOAT NO 0 FLOAT NO 0 VARCHAR(255) YES NULL Description of the fields ID Graveyard's ID. See WorldSafeLocs.dbc Map Zone's ID of ghost position before teleportation to graveyard. See Map.dbc column 1

game_graveyard_zone.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_graveyard_zone <-Back-to:World Field Type Attributes Key Null Default Extra Comment MEDIUMINT unasigned PRI NO 0 MEDIUMINT unasigned PRI NO 0 SMALLINT unasigned NO 0 Description of the fields id Graveyard's ID. See

game_tele.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_tele <-Back-to:World Table Structure This table contains a list of teleport locations that can be used with the .tele command in-game. Entries in this table can be added/deleted manually or with the .tele add and .tele delete commands. Field Type Attributes

game_weather.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

game_weather <-Back-to:World Table Structure This table holds the percent chances for weather changes to occur in various zones. Not all zones can have their weather changed. For any given zone the percentage of all weather types for each season should total, and not exceed 100%.

getting-started.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Getting started with AzerothCore Introduction Would you like to learn about AzerothCore (AC), setup your WoW server for the first time, understand how to modify it and become able to contribute? You came to the right place! Getting started with WoW emulation might be tricky at first, but don't worry, we will be there to help you in case you encounter any issue or have any questions to ask. Just read

gm-commands.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/GM-Commands” --- # GM Commands GM commands can be entered mainly in 2 ways. Either by typing it directly into the world console window. In the world console window the leading dot (.) is not mandantory, but you can use it. The other way is using the gm command ingame in the chat console of the wow client. There, all commands must start with a leading dot, f.ex.: .gm on

gm_subsurvey.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gm_subsurvey <-Back-to:Characters The `gm_subsurvey` table This table contains the answers to the survey questions. It's linked to gm_survey. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO Auto increment INT

gm_subsurveys.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gm_subsurveys <-Back-to:Characters The `gm_subsurveys` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED PRI NO INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 longtext SIGNED

gm_survey.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gm_survey <-Back-to:Characters The `gm_survey` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO Auto Increment INT UNSIGNED NO 0 INT UNSIGNED NO 0 LONGTEXT SIGNED NO INT

gm_ticket.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gm_ticket <-Back-to:Characters The `gm_tickets` table This table stores all tickets. Note: do not insert directly into most of these columns, else the client won't update the ticket status until table reload and a logout. Structure Field Type Attributes Key Null

gossip_menu.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gossip_menu <-Back-to:World The `gossip_menu` table This table is used for displaying gossip when a player talks to an NPC with npcflag set. Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED

gossip_menu_option.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gossip_menu_option Table: gossip_menu_option This table holds information about menu options a gossip NPC can have. Examples of options: “Train me!”, “I want to unlearn my talents” Structure Field Type Attributes Key Null Default Extra

gossip_menu_option_action.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gossip_menu_option_action **Table: gossip_menu_option_action** This table holds information about what a gossip menu option is doing, redirect to gossip or showing poi on mnap. Structure Field Type Attributes Key Null Default

gossip_menu_option_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

gossip_menu_option_locale <-Back-to:World The `gossip_menu_option_locale` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED PRI NO SMALLINT UNSIGNED PRI NO text SIGNED

graveyard_zone.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

graveyard_zone <-Back-to:World The `graveyard_zone` table Contains information about zones connected to world's graveyards. This table is used to set what factions a given graveyard will accept, and also to specify the nearest graveyard to a given zone. For a list of all existing graveyard zones and their respective IDs, check out WorldSafeLocs.dbc

groups.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

groups <-Back-to:Characters The `groups` table This table holds basic info about groups. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED NO TINYINT UNSIGNED NO INT UNSIGNED

group_instance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

group_instance <-Back-to:Characters The `group_instance` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 TINYINT UNSIGNED NO 0 Description of the fields

group_member.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

group_member <-Back-to:Characters The `group_member` table This table holds info about group members. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT UNSIGNED PRI NO Unique TINYINT UNSIGNED NO

guide-to-triaging.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Guide to Triaging Introduction This guide is intended to give an overview of bug triaging for the AzerothCore project. It will cover goals, the triaging process, a summary of tools and sources, and other useful links. Goals Our goal is to take a bug report that has been submitted to the ChromieCraft issue tracker, and decide in a timely, accurate and documented manner whether it is a valid report or not. If it is, we forward it on to the AzerothCore issue tracker with added notes and documen…

guild.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild <-Back-to:Characters The `guild` table This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED

guild_bank_eventlog.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_bank_eventlog <-Back-to:Characters The `guild_bank_eventlog` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Guild Identificator INT UNSIGNED PRI NO 0 Log record identificator - auxiliary column

guild_bank_item.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_bank_item <-Back-to:Characters The `guild_bank_item` table This table holds all item information for items that are stored in the guild bank. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 TINYINT UNSIGNED

guild_bank_right.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_bank_right <-Back-to:Characters The `guild_bank_right` table This table hold informations regarding the right guild member have to withdraw, deposit etc at the guild bank. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED

guild_bank_tab.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_bank_tab <-Back-to:Characters The `guild_bank_tab` table This table holds information on all the tabs in use for all guilds that make use of the guild bank. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0

guild_eventlog.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_eventlog <-Back-to:Characters The `guild_eventlog` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO Guild Identificator INT UNSIGNED PRI NO Log record identificator - auxiliary column TINYINT

guild_member.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_member <-Back-to:Characters The `guild_member` table This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers. Structure Field Type Attributes Key Null Default Extra Comment

guild_member_withdraw.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_member_withdraw <-Back-to:Characters The `guild_member_withdraw` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED NO 0 INT UNSIGNED NO 0 INT UNSIGNED NO 0

guild_rank.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

guild_rank <-Back-to:Characters The `guild_rank` table This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has. Structure Field Type Attributes Key Null Default Extra Comment

holidays.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:34:42+00:00

Holidays holidays.dbc ''%%Back-to:DBC%%'' Structure Column Field Type Notes Extra info 0 Integer Holiday event ID 1 Integer Stage1 event length (for stage1 either as preparation or main event. See eventSchedulerType for more info) 2 Integer Stage2 event length (for stage2

holiday_dates.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

holiday_dates <-Back-to:World The `holiday_dates` table table-no-description Structure Field Type Attribute Key Null Default Extra Comment id INT UNSIGNED PRI NO date_id TINYINT UNSIGNED PRI NO date_value INT UNSIGNED NO

home.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/” --- # Home Welcome to the [AzerothCore]() project wiki. Read in: [English :gb:](home) [Spanish :es:](es/home) ## IMPORTANT NOTE {% include warning.html content=“The AzerothCore Team and Owners DO NOT in any case sponsor nor support illegal public servers. If you use these projects to run an illegal public server and not for testing and learning it is your personal choice.

hooks-bash.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Hooks-Bash” --- # Hooks Bash ## HOOKS FOR COMPILER - ON_AFTER_OPTIONS - ON_AFTER_CONFIG - ON_AFTER_BUILD

hooks-cmake.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/Hooks-Cmake” --- # Hooks CMake AFTER_LOAD_CONF BEFORE_SRC_LOAD | AFTER_SRC_LOAD AFTER_AUTHSERVER_CMAKE AFTER_WORLDSERVER_CMAKE BEFORE_GAME_LIBRARY | AFTER_GAME_LIBRARY

hooks-script.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # The ScriptAI system The ScriptAI system implemented by AC uses a special [Observer pattern]() strategy to implement an event-driven programming which is also the CORE of our modular system. This guide, together with our [module system](create-a-module.md) lets you extend the AzerothCore without patching it directly. This allows you to update your repository by keeping your additions and customizat…

how-to-ask-for-help.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-ask-for-help” --- # How to ask for help ## Need help? Do you need support with AzerothCore? No worries, we're happy to help you! Whether you have troubles installing AzerothCore, or you want to ask how-to or generic help questions,

how-to-create-a-db-pr.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-create-a-DB-PR” --- # How to create a DB PR via GitHub This is a simplified guide to easily create PRs containing DB fixes (SQL code) without bothering with the terminal, an easier alternative to the [traditional way of creating PRs](

how-to-create-a-pr.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-create-a-PR” --- # How to create a PR This guide explains how to open PRs to submit any kind of fixes (C++, SQL, etc...). If you happen to submit only DB fixes, you might give it a try to our new [simplified way of opening a PR containing SQL code](

how-to-debug.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

## Work in progress

how-to-document-code.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # How to document your code The extensive [Doxygen manual]() is well worth browsing. Doxygen provides a wide variety of options for documenting code and can be adapted for general documentation as well. This page well take you through some of the commonly used features in AzerothCore documentation.

how-to-find-trinitycore-commits-of-specific-code-addition.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-find-TrinityCore-commits-of-specific-code-addition” --- # How to find TrinityCore commits of specific code addition Sometimes we need to import something from TrinityCore, for example we see an extra line or file in the code, and we want to better know the context of that addition (i.e. the commit that introduced it).

how-to-import-dbc-data-in-db.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

How to import DBC data inside the AC database This guide will show you how to import DBC data inside the AzerothCore database and edit them. For the guide we are going to use the AreaTable.dbc as example by changing the Hyjal zone from “Normal” to

how-to-obtain-free-records.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-obtain-free-records” --- # How to obtain free records On some occasions, we need to obtain or know records whose values are not being occupied. Either because we want to insert a new value, or we want to restructure our table after a while.

how-to-restart-and-debug.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 --- # How to restart and debug AzerothCore is composed of two services: authserver and worldserver. Authserver only acts as an authenticator and a router for your realms redirecting your authorized client connections to the selected realm address. The worldserver instead handles all connections related to the game mechanics and it is the single source of truth for everything related to a single realm.

how-to-spot-db-struct-diff-commits.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-spot-db-struct-diff-commits” --- # How to spot DB struct diff commits 1) Clone a [3.3.5 TrinityCore]() and open it with [Visual Studio Code]() or any other IDE that has annotate feature (e.g. IntellIJ and similar).

how-to-test-a-pr.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-test-a-PR” --- # How to test a PR ## Introduction At AzerothCore we care about game quality and stability. Because of this, we do not push changes directly to the master branch. Instead, whenever introducing a new change, we create a new [Pull Request](

how-to-test-db-only-changes.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- redirect_from: “/How-to-test-DB-only-changes” --- # How to test DB only changes ## Introduction The main guide about [How to test a PR](How-to-test-a-PR) will work for all kind of PRs. However it is common to have PRs that only make changes to the database (typically the `world` database).

how-to-use-changelog.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

How to use changelog All breaking/notable changes to this project will be documented in the /docs/changelog/master.md file. The format is based on Keep a Changelog, and this project adheres to Semantic Versioning. This changelog should provide an easy way for the developers to upgrade their own code which is connected to AzerothCore

how-to-use-gperftool.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

How to use GPERFTool AzerothCore integrates the google performance tools library that allows you to analyse the code execution of your application when it comes to CPU and Memory. In short: thread-friendly heap-checker, heap-profiler, and cpu-profiler.

how-to-use-warden-payload-mgr.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

How to use the Warden Payload Manager The WardenPayloadMgr is responsible for maintaining custom payloads used by modules. This allows users to send custom lua payloads up to a size of 512 bytes to the game client. Some of the things you can achieve with this is:

how-to-work-with-conf-files.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

How to work with Conf Files How configuration files are composed All configuration files load their properties under 2 macro groups (you must have one of them on your configuration file header) : [authserver] -> For authserver configurations [worldserver]

importing-spell-dbc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

ARCHIVED - NOT IN USE. SAVED FOR HISTORY LESSONS Importing data to the spell_dbc table Introduction The spell_dbc contains data regarding serverside spells which are not to be found in Client DBC files as well as overrides of the DBC that are meant to improve or fix any spell.

install-with-docker.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

--- tableofcontents: 1 redirect_from: “/Install-with-Docker” --- # Install with Docker Welcome to the AzerothCore Docker guide! The example docker configurations for AzerothCore may seem non-idiomatic at times, and this document can help users get started with running an AzerothCore server in a container-based environment.

installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T22:42:55+00:00

Installation Guide Choosing a setup There are several ways to install AzerothCore, you need to choose ONE. Install from the source Supported These are the officially supported and complete ways of installing AzerothCore, for any purpose (Windows, Linux, macOS).

installing-a-module.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Installing a Module Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 8: Client Setup Adding a module is an optional step to alter the blizzlike gameplay offered by AzerothCore by default.

instance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

instance <-Back-to:Characters The `instance` table This table holds static information on all current instances that have not yet been reset. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 SMALLINT UNSIGNED

instance_encounters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

instance_encounters <-Back-to:World The `instance_encounters` table Definitions of instance encounters. Used by LFG. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Unique entry from DungeonEncounter.dbc

instance_reset.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

instance_reset <-Back-to:Characters The `instance_reset` table Date and time when heroic and raid instances will be reset (i.e. instances which have a fix reset interval, which is independent of the time, when some player(s) entered the instance). If Rate.InstanceResetTime is changed in the worldserver config, erase all data in this table and restart the server in order to repopulate it with the updated

instance_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

instance_template <-Back-to:World The `instance_template` table This table has all the templates for every instance. When a group enters an instance, a new copy of that instance is made from the values in these fields. If you want to change the spot you will start in when you enter/leave an instance, go to areatrigger_teleport

ip2location.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

IP2LOCATION With IP2LOCATION we can approximately see which country a player might be coming from using the .pinfo command. To be able to use this system you have to provide the ip2location lite database to your Authserver. Download IP2LOCATION-LITE-DB1.CSV

ip_banned.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

ip_banned <-Back-to:Auth The `ip_banned` table This table contains all of the banned IPs and the date when (or if) the ban will expire. Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(15) SIGNED PRI NO 127.0.0.1 INT

issue-tracker-standards.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Issue Tracker Standards >> Issue Tracker Always search for existing issues before you report your problem or incident. All reports are public. Never leave passwords or other confidential information visible in your report. Never upload files into issues! Use GIST for text and YouTube for video!

item_appearance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_appearance Back-to:Hotfixes The `item_appearance` table This table contains some of the appearance data regarding item hotfixes. Together with item, item_modified_appearance and item_sparse they present the means to hotfix an item. Structure

item_effect.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_effect Back-to:Hotfixes The `item_effect` table This table contains some of the item effect data regarding item hotfixes. This table is primarily used to hotfix spells on items. Structure Field Type Attributes Key Null Default Extra Comment

item_enchantment_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_enchantment_template <-Back-to:World The `item_enchantment_template` table This table holds enchantment chance information for items that should have either a random property or a random suffix attached to them. Structure Field Type Attributes Key Null

item_instance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_instance <-Back-to:Characters The `item_instance` table This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auction houses, in guild banks or in mails. Structure Field Type Attributes

item_instance_enchantments.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_instance <-Back-to:Item Instance The `item_instance\enchantments` field This Field is really a table of its own. There are 36 numerics seperated by a space Each Numeric is part of a three part Tuple of Numerics represents an enchantment as applied to the item. *

item_loot_items.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_loot_items <-Back-to:Characters The `item_loot_items` table Contains the items associated with a lootable inventory item such as a “watertight trunk” or “Bulging Sack of Gems” This table is populated the first time the player right-clicks to open an item. Rows are deleted when the player either removes an item or destroys the container item.

item_loot_money.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_loot_money <-Back-to:Characters The `item_loot_money` table Contains the money associated with a lootable inventory item such as a “Fat Sack of Coins” This table is populated the first time the player right-clicks to open an item. Rows are deleted when the player either removes the money or destroys the container item.

item_loot_storage.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_loot_\storage <-Back-to:Characters The `item_loot_\storage` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT UNSIGNED NO INT UNSIGNED NO INT SIGNED NO INT UNSIGNED

item_modified_appearance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_modified_appearance Back-to:Hotfixes The `item_modified_appearance` table This table links together the appearances and item ids in regards to item hotfixes. Together with item, item_appearance and item_sparse they present the means to hotfix an item.

item_refund_instance.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_refund_instance <-Back-to:Characters The `item_refund_instance` table This table serves as a receipt of refundable purchases during a 2 hour ingame time window. It holds information on what currency was spent to purchase the item. Structure Field Type Attributes

item_set_names.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_set_names <-Back-to:World The `item_set_names` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO VARCHAR(255) SIGNED NO TINYINT UNSIGNED NO 0 SMALLINT

item_set_names_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_set_names_locale <-Back-to:World The `item_set_names_locale` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 VARCHAR(100) SIGNED NO VARCHAR(100) SIGNED

item_soulbound_trade_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_soulbound_trade_data <-Back-to:Characters The `item_soulbound_trade_data This table stores information about which players can trade soulbound items between each other. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI

item_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_template <-Back-to:World Table Structure Holds information on every item that exists in the game. All items are created from their template stored in this table. (See additional information in the ItemPrototype.h file.) Field Type Attributes Key Null

item_template_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

item_template_locale <-Back-to:World The `item_template_locale` table This table is used to provide to localized clients with localized string for items. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED

keeping-the-server-up-to-date.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> AzerothCore developers and contributors are always working on fixing and adding new features to the core. You can always find them

keira3-internals.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

Keira3 Internals This is a collection of notes aiming to explain the internals of Keira3 for development purposes. If you just want to use Keira3, you don't need any of the following. If you want to modify Keira3, for example to improve it or to add new features, you may find this page useful.

lag_reports.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:17+00:00

lag_reports <-Back-to:Characters The \lag\_reports\ table This table stores the lag reports made by players ingame (when they click on “Help Request”). Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO Auto Increment

languages.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:37:02+00:00

Languages ''%%Back-to:DBC%%'' DBC Structure - For Version 3.3.5a This DBC contains languages that can be used in texts. The player must have competence in this language to understand what is written. Column Type Notes 1 long The ID of the language. Must be unique.

lfg_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

lfg_data <-Back-to:Characters The `lfg_data` table This table contains saved data for LFG. This table is constantly in use by the core. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier

lfg_dungeon_encounters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

lfg_dungeon_encounters <-Back-to:World The `lfg_dungeon_encounters` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Achievement marking final boss completion INT UNSIGNED NO 0 Dungeon entry from dbc

lfg_dungeon_rewards.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

lfg_dungeon_rewards <-Back-to:World The `lfg_dungeon_encounters` table table-no-description|0 Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Dungeon entry from dbc TINYINT UNSIGNED PRI NO 0 Max level at which this reward is rewarded

lfg_dungeon_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

lfg_dungeon_template <-Back-to:World Column Type Description DungeonId INT UNSIGNED Name VARCHAR(255) Position_x FLOAT Position_y FLOAT Position_z FLOAT Orientation FLOAT

lfg_entrances.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

lfg_entrances <-Back-to:World The `lfg_entrances` table Used by LFG system to teleport players on specified position. This table should be used instead of `areatrigger_teleport` tabe for all dungeons in the future. Structure Field Type Attributes Key Null

linked_respawn.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

linked_respawn <-Back-to:World The `linked_respawn` table This table links trash mobs to bosses so that if you kill the boss, the trash do not respawn before the instance is reset. Gameobjects can be linked too! Structure Field Type Attributes Key Null Default

linux-core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Linux Core Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 1: Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Getting the source code

linux-keeping-the-server-up-to-date.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Linux Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> Keeping the source Up-to-Date cd ~/azerothcore/ git pull origin master

linux-requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Linux Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Installation Guide Step 2: Core Installation >> MySQL ≥ 5.7.0 Boost ≥ 1.74 OpenSSL ≥ 3.0.x CMake ≥ 3.16

linux-restarter.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

## Introduction This tutorial will walk you through creating a script to restart AzerothCore after a shutdown, restart, or crash when using a Linux server. The easiest way to setup a restarter is by using our [integrated scripts or docker](how-to-restart-and-debug.md)

linux-server-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Linux Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Extracting DBC, Maps, VMaps & MMaps Go to your AzerothCore build directory (e.g. $HOME/build/bin/) and copy the following files to your World of Warcraft binaries directory.

locales_achievement_reward.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_achievement_reward <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Subject_loc1 VARCHAR(100) Subject_loc2 VARCHAR(100) Subject_loc3 VARCHAR(100) Subject_loc4 VARCHAR(100) Subject_loc5 VARCHAR(100) Subject_loc6 VARCHAR(100)

locales_broadcast_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_broadcast_text <-Back-to:World Column Type Description ID MEDIUMINT UNSIGNED MaleText_loc1 longtext MaleText_loc2 longtext MaleText_loc3 longtext MaleText_loc4 longtext MaleText_loc5 longtext MaleText_loc6 longtext MaleText_loc7

locales_creature_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_creature_text <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Groupid TINYINT UNSIGNED Id TINYINT UNSIGNED Text_loc1 text Text_loc2 text Text_loc3 text Text_loc4 text Text_loc5 text Text_loc6 text Text_loc7

locales_gossip_menu_option.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_gossip_menu_option <-Back-to:World Column Type Description Menu_id SMALLINT UNSIGNED Id SMALLINT UNSIGNED Option_text_loc1 text Option_text_loc2 text Option_text_loc3 text Option_text_loc4 text Option_text_loc5 text Option_text_loc6

locales_item.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_item <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Name_loc1 VARCHAR(100) Name_loc2 VARCHAR(100) Name_loc3 VARCHAR(100) Name_loc4 VARCHAR(100) Name_loc5 VARCHAR(100) Name_loc6 VARCHAR(100) Name_loc7 VARCHAR(100)

locales_item_set_names.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_item_set_names <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Name_loc1 VARCHAR(100) Name_loc2 VARCHAR(100) Name_loc3 VARCHAR(100) Name_loc4 VARCHAR(100) Name_loc5 VARCHAR(100) Name_loc6 VARCHAR(100) Name_loc7

locales_npc_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_npc_text <-Back-to:World Column Type Description ID MEDIUMINT UNSIGNED Text0_0_loc1 longtext Text0_0_loc2 longtext Text0_0_loc3 longtext Text0_0_loc4 longtext Text0_0_loc5 longtext Text0_0_loc6 longtext Text0_0_loc7 longtext

locales_page_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_page_text <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Text_loc1 longtext Text_loc2 longtext Text_loc3 longtext Text_loc4 longtext Text_loc5 longtext Text_loc6 longtext Text_loc7 longtext Text_loc8 longtext

locales_points_of_interest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_points_of_intrest <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED Icon_name_loc1 text Icon_name_loc2 text Icon_name_loc3 text Icon_name_loc4 text Icon_name_loc5 text Icon_name_loc6 text Icon_name_loc7 text

locales_quest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

locales_quest <-Back-to:World Column Type Description Id MEDIUMINT UNSIGNED Title_loc1 text Title_loc2 text Title_loc3 text Title_loc4 text Title_loc5 text Title_loc6 text Title_loc7 text Title_loc8 text Details_loc1 text

logging-configuration.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- tableofcontents: 1 --- # Logging Configuration (log4j-like) ## Setting up logging in the core ```cpp LOG_TYPE(“appender”, “LOG MESSAGE {}”, var); Example LOG_ERROR(“sql.sql”, “Unable to load creature entry {} and spawnId {}

logs.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

logs <-Back-to:Auth The `logs` table This table stores logs from Appender type database in config file. Example db appender: Appender.DB=3,5,0 Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT UNSIGNED

logs_ip_actions.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

logs_ip_actions <-Back-to:Auth The `logs_ip_actions` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT Unique Identifier INT UNSIGNED NO Account ID INT UNSIGNED NO Character Guid

log_arena_fights.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

log_arena_fights <-Back-to:Characters The `log_arena_fights` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO DATETIME SIGNED NO TINYINT UNSIGNED NO INT UNSIGNED NO INT

log_arena_memberstats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

log_arena_memberstats <-Back-to:Characters The `log_arena_memberstats` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO TINYINT UNSIGNED PRI NO CHAR(20) SIGNED NO INT UNSIGNED

log_encounter.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

log_encounter <-Back-to:Characters The `log_encounter` table Structure Field Type Attributes Key Null Default Extra Comment DATATIME SIGNED NO SMALLINT UNSIGNED NO TINYINT UNSIGNED NO TINYINT UNSIGNED NO INT

log_money.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

log_money <-Back-to:Characters The `log_money` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT UNSIGNED NO CHAR(32) SIGNED NO CHAR(32) SIGNED NO INT UNSIGNED NO

loot_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

loot_template <-Back-to:World Tables**: ***_loot_template General Well, according to vocabulary the meaning of the word “loot” is good for corpse loot and may be for some gameobjects like chests but quite unfit for fishing “loot”. Nevermind. We will use term

macos-core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

macOS Core Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 1: Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Getting the source code

macos-keeping-the-server-up-to-date.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

macOS Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> Keeping the source Up-to-Date cd ~/azerothcore/ git pull origin master

macos-requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

macOS Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Installation Guide Step 2: Core Installation >> MacOS ≥ 11 OpenSSL ≥ 3.0 Boost ≥ 1.70 MySQL ≥ 5.7.0

macos-server-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

macOS Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Extracting DBC, Maps, VMaps & MMaps Go to your AzerothCore build directory (e.g. $HOME/build/bin/) and copy the following files to your World of Warcraft binaries directory.

mail.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

mail <-Back-to:Characters The `mail` table This table contains main data about all mails in the game. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Identifier TINYINT UNSIGNED NO 0 TINYINT UNSIGNED

mail_items.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

mail_items <-Back-to:Characters The `mail_items` table This table contains data regarding items from item_instance which are being sent via email. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO 0 INT UNSIGNED PRI

mail_level_reward.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

mail_level_reward <-Back-to:World The `mail_level_reward` table On certain levels, you receive a mail with some text. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED PRI NO 0

mail_server_character.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

mail_server_character <-Back-to:Character The `mail_server_character` table This table keeps entries of which player has recieved a server mail. This prevents the same mail to be sent twice to the same player. Structure Field Type Attributes Key Null Default

mail_server_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

mail_server_template <-Back-to:Character The `mail_server_template` table This table contains information for server mail to be sent to players that meet the requirement. Mails are sent OnLogin. Structure Field Type Attributes Key Null Default Extra Comment

map.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:37:17+00:00

Map Map.dbc ''%%Back-to:DBC%%'' This DBC contains the maps list. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2 InternalName String reference to World\Map\ [...] \ 3 Flags Integer 0x100 - CAN_CHANGE_PLAYER_DIFFICULTY 4 Type

merge-process.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

AzerothCore Merge process PRs merge rate At AzerothCore, we merge only a few PRs daily, picking them from the [To Be Merged] list. Everyday we pick the oldest PRs to merge, unless there are more urgent PRs that need to be merged first for any reason. Users can request the AC Staff to give a PR a higher priority if they really need to have it merged soon, we are quite flexible with that (ex: a hook).

monitoring-azerothcore-with-grafana.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- tableofcontents: 1 --- # Monitoring AzerothCore with Grafana ## Required Software 1. [Influx DB]() 1.x - a time-series data storage. 1. [Grafana]() - graph and a dashboard builder for visualizing time series metrics. ### Installing Influx DB

motd.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

motd <-Back-to:Auth The `motd` table Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED PRI NO LONGTEXT YES NULL Description of the fields realmid RealmID for the Motd to be sent -1 for all realms A specified realm is superior to -1 (All Realms)

mysqltypescpp.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/MySQLtypesC++” --- # MySQL Types C++

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Mapping from types used in SQL queries
… networking.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Networking Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 4: Database Installation Step 6: Final Server Steps >> This guide is intended for advanced setups or just to provide more details in setting up your realm for local or internet use. In general, the default setup explained in your particular npc_spellclick_spells.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 npc_spellclick_spells <-Back-to:World The `npc_spellclick_spells` table This table holds information about spells to be cast upon receiving CMSG_SPELLCLICK. That opcode is sent for quests in which you have to loot creatures, who are already dead at spawning. Examples are npc_text.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 npc_text <-Back-to:World Table Structure This table contains the texts that are used for gossip. More research needs to be done on this table. Field Type Attributes Key Null Default Extra Comment ID MEDIUMINT UNSIGNED PRI NO 0 text0_0 longtext npc_text_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 npc_text_locale <-Back-to:World The `npc_text_locale` table This table is used to provide localized clients with localized string for npc_texts. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO npc_trainer.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 npc_trainer <-Back-to:World The `npc_trainer` table This table contains all the spells that each trainer can teach. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT SIGNED PRI NO 0 npc_vendor.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 npc_vendor <-Back-to:World General information This table holds the vendor data for all NPCs that sell items or currencies. A vendor can only hold up to 150 items (15 pages), it is hardcoded in the emulator and if you change it, the client will crash. Prices The price (in gold) for each item or currency is defined in its item template related entry as outdoorpvp_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 outdoorpvp_template <-Back-to:World Field Type Attributes Key Null Default Extra Comment TINYINT unasigned PRI NO char(64) SIGNED NO 0 text SIGNED YES NULL Description of the fields TypeId Id defined in the emulator for each PvP zone in the world. pagetextmaterial.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:37:31+00:00 PageTextMaterial ''%%Back-to:DBC%%'' PageTextMaterial.dbc This DBC contains material used to display a gossip window for quest or page text. Version is : 3.1.3 Structure Column Field Type 1 ID Integer 2 sRefCon String Content ID Name page_text.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 page_text <-Back-to:World The `page_text` table This table holds the text for letter items or any items that when moused-over turn the cursor into a magnifying glass and on right-click will open up a window where you can read the contents of the letter. Structure page_text_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 page_text_locale <-Back-to:World The `page_text_locale` table This table is used to provide localized clients with localized string for page_texts. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI petition.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 petition <-Back-to:Characters The `petition` table This table holds information on all ongoing petitions for a guild or for an arena team. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED YES petition_sign.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 petition_sign <-Back-to:Characters The `petition_sign` table This table holds information on all the signatures of a petition for either a guild or an arena team. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT pet_aura.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_aura <-Back-to:Characters The `pet_aura` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier BIGINT UNSIGNED PRI NO 0 Full Global Unique Identifier MEDIUMINT UNSIGNED pet_levelstats.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_levelstats <-Back-to:World The `pet_levelstats` table This table holds information on individual pet base stats based on level. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL pet_name_generation.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_name_generation <-Back-to:World The `pet_name_generation` table This table holds pieces of names (first and last half) that are use for pet name generation. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO pet_name_generation_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_name_generation_locale <-Back-to:World The `pet_name_generation_locale` table This table holds pieces of names (first and last half) that are use for pet name generation for locale. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT pet_spell.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_spell <-Back-to:Characters The `pet_spell` table This table holds information on individual pet spells. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier MEDIUMINT UNSIGNED PRI NO pet_spell_cooldown.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pet_spell_cooldown <-Back-to:Characters The `pet_spell_cooldown` table This table holds information on pet spell cooldowns. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier, Low part MEDIUMINT phase_area.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 phase_area Back-to:World Tables: phase_area General PhaseIds added to player by zone/area events. Each line holds one Zone or Area with one phaseId and a description. Each line is active by default. With the table conditionsyou can edit the working range of the phase. playercreateinfo.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 playercreateinfo <-Back-to:World The `playercreateinfo` table This table holds the start positions of each class-race combinations for all newly created characters. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI playercreateinfo_action.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 playercreateinfo_action <-Back-to:World Table Structure This table holds information on what default actions a brand new character should start out with. Each race-class combination can have a different default starting setup. Field Type Attributes Key Null playercreateinfo_item.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 playercreateinfo_item <-Back-to:World The `playercreateinfo_item` table This table is used for any custom items that you might want to give to characters on creation. I used to be used to hold the normal items that characters get as well, but now that info is read from CharStartOutfit.dbc playercreateinfo_skills.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 playercreateinfo_skills <-Back-to:World playercreateinfo_skills table This table holds information on what skills newly created characters should start out with. A character in this table is defined by his/her race and class combination. Structure playercreateinfo_spell_custom.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 playercreateinfo_spell_custom <-Back-to:World This table holds information on what spells newly created characters should start with if the PlayerStart.AllSpells setting is enabled in worldserver.conf. A character in this table is defined by his/her race and class combination. player_class_stats.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_class_stats <-Back-to:World The `player_class_stats` table This table holds information on what values are applied to stats for characters as they level up. All of the values in this table signify only the base stats of a class at a specific level. Structure player_factionchange_achievement.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_achievement <-Back-to:World The `player_factionchange_achievement` table Basically all achievement changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT player_factionchange_items.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_items <-Back-to:World The `player_factionchange_items` table Basically all item changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT SIGNED NO INT SIGNED PRI NO player_factionchange_quests.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_quest <-Back-to:World Column Type Description Alliance_id INT UNSIGNED Horde_id INT UNSIGNED player_factionchange_reputations.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_reputations <-Back-to:World The `player_factionchange_reputations` table Basically all faction/reputation changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO player_factionchange_spells.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_spells <-Back-to:World The `player_factionchange_spells` table Basically all spell changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT SIGNED PRI NO player_factionchange_titles.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_factionchange_titles <-Back-to:World Column Type Description Alliance_id INT Horde_id INT player_race_stats.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_race_stats <-Back-to:World The `player_race_stats` table This table holds information on modifiers for stat values applied to characters. All of the values in this table signify only the stat value modifiers based on the race of a character. Structure Field player_xp_for_level.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 player_xp_for_level <-Back-to:World The `player_xp_for_level` table Includes information on how much experience needed for next level. Comes from sniffs. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO NULL points_of_interest.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 points_of_interest <-Back-to:World The `points_of_interest` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 0 FLOAT SIGNED NO 0 MEDIUMINT points_of_interest_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 points_of_interest_locale <-Back-to:World The `locales_points_of_interest` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment D MEDIUMINT UNSIGNED PRI NO 0 locale text SIGNED YES pool_creature.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_creature <-Back-to:World The `pool_creature` table This table contains a list of creatures that are tied to a specific pool. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED NO pool_gameobject.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_gameobject <-Back-to:World The `pool_gameobject` table This table contains gameobjects that are tied to a specific pool. This table can only contain gameobjects that have a type of GAMEOBJECT_TYPE_CHEST, GAMEOBJECT_TYPE_GOOBER, GAMEOBJECT_TYPE_FISHINGHOLE. pool_pool.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_pool <-Back-to:World The `pool_pool` table This is the pool of pools table. You can create a pool with a chance of a range of pools in that pool being activated. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED pool_quest.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_quest <-Back-to:World The `pool_quest` table This table contains a list of quests that are tied to a specific pool. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED NO 0 pool_quest_save.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_quest_save <-Back-to:Characters The `pool_quest_save` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 Description of the fields pool_id pool_quest.entry. quest_id quest_template.id. pool_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pool_template <-Back-to:World The `pool_template` table Each unique pool is defined in this table. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 Pool entry INT UNSIGNED NO 0 Max number of objects (0) is no limit project-versioning.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/Project-Versioning” --- ## Project Versioning We are using the semantic versioning standard: For instance, we can have: 1.5.1-dev.1 that corresponds to: MAJOR.MINOR.PATCH-PRERELEASE More in depth: * MAJOR version when you make incompatible pvpstats_battlegrounds.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pvpstats_battlegrounds <-Back-to:Characters The `pvpstats_battlegrounds` table This table holds datas about BattleGrounds scores. To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config.dist file. Structure Field pvpstats_players.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 pvpstats_players <-Back-to:Characters The `pvpstats_players` table This table holds datas about BattleGrounds scores. To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config.dist file. Structure Field Type Attributes quest_details.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_details Table: quest_details This table handles Quest NPC emotes with emote delays. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO 0 Unique ID (quest_template.ID) SMALLINT UNSIGNED NO 0 Quest NPC Emote quest_greeting.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_greeting Table: quest_greeting This table add greeting behavior to an NPC or an Gameobject. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED Yes NO 0 TINYINT UNSIGNED Yes NO 0 SMALLINT UNSIGNED NO quest_greeting_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_greeting Table: quest_greeting This table add greeting behavior to an NPC or an Gameobject. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED Yes NO 0 TINYINT UNSIGNED Yes NO 0 VARCHAR(4) NO NO quest_mail_sender.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_mail_sender <-Back-to:World The `quest_mail_sender` table Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 Description of the fields QuestId Is the quest ID, obtained from quest_template quest_money_reward.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_money_reward Table: quest_money_reward This table enables dynamically rewarding money dependent on player's level. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO 0 Player's level MEDIUMINT quest_objectives.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_objectives <-Back-to:World Table: quest_objectives This table provides answer for a very important question. What do I need to do in order to finish a quest? Structure Field Type Attributes Null Key Default Comment MEDIUMINT UNSIGNED NO PRI 0 quest_offer_reward.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_offer_reward Table: quest_offer_reward This table is used for quests offering rewards without any required quest items (no item delivery involved). Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO quest_offer_reward_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_offer_reward_locale <-Back-to:World The `quest_offer_reward_locale` table Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO 0 VARCHAR(4) PRI NO NULL text YES NULL SMALLINT NO quest_poi.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_poi <-Back-to:World The `quest_poi` table Comes from sniffs. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 INT UNSIGNED NO 0 quest_poi_points.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_poi_points <-Back-to:World The `quest_poi_points` table Comes from sniffs. Visually speaking, this table is used to identify the X and Y coordinates on the map (not the minimap - the main map) where a quest's question mark should appear. Use the “.gps” quest_request_items.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_request_items Table: quest_request_items This table basically handles 3 quest details: * NPC Emote when quest is completed * NPC Emote when quest is incomplete * Completion text for quests requiring quest items Field Type Attributes quest_request_items_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_request_items_locale Table: quest_request_items_locale <-Back-to:World Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO VARCHAR(4) PRI NO text YES NULL SMALLINT NO quest_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_template <-Back-to:World Table: quest_template Contains all basic definitions of available quests. Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 TINYINT UNSIGNED NO 2 SMALLINT quest_template_addon.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_template_addon <-Back-to:World Table: quest_template_addon Contains extra definitions like linking quests, dependencies and requirements for the quests defined in the quest_template table to become available to the player. Structure: Field Type Attributes Key Null quest_template_locale.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_template_locale <-Back-to:World The `quest_template_locale` table This table is used to provide to localized clients with localized string for quest templates. Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI quest_tracker.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 quest_tracker <-Back-to:Character The `quest_tracker` table Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED NO 0 INT UNSIGNED NO 0 DATETIME SIGNED NO DATETIME SIGNED YES DATETIME realmcharacters.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 realmcharacters <-Back-to:Auth The `realmcharacters` table This table holds information on the number of characters each account has for each realm. The data in this table is maintained by the core. Structure Field Type Attributes Key Null Default Extra realmlist.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 realmlist <-Back-to:Auth The `realmlist` table This table sets up information on all available realms. Each row controls a different realm. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT VARCHAR(32) recovery_item.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 recovery_item <-Back-to:Characters The `recovery_item` table This table holds information about character's matchmaker rating in all team types. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT INT remote-access.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/Remote-Access” --- # Remote Access ## Introduction Azerothcore has 4 ways of interfacing with the world server. - In Game - The Console - Telnet (RA) - HTTP (SOAP) The in game menus and the console are pretty self explanatory, however you are not always able to administer the server locally nor do the first two options provide many opportunities for automation. If you want to provide a way to access your server remotely, or let software manage it the… reputation_reward_rate.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 reputation_reward_rate <-Back-to:World The `reputation_reward_rate` table Holds reputation multipliers for specific factions. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 1 reputation_spillover_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 reputation_spillover_template <-Back-to:World The `reputation_spillover_rate` table field-no-description\|0 Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED PRI NO 0 SMALLINT UNSIGNED NO 0 FLOAT SIGNED requirements.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Classic Installation Step 2: Core Installation >> Linux Requirements macOS Requirements Windows Requirements Help If you are still having problems, check: * FAQ * Common Errors * reserved_name.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 reserved_name <-Back-to:Characters The `reserved_name` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(12) SIGNED PRI NO '' Description of the fields name Name to be reserevd run-worldserver-and-authserver-in-visual-studio.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Run Worldserver and Authserver in Visual Studio Running the Worldserver and Authserver through Visual Studio has some benefits. * You can easily debug code using breakpoints or easily finding the Call Stack of a crash. * It will also let your server pause instead of crashing when you hit a crash, and you can easily just continue after your debugging. scene_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 scene_template <-Back-to:World The `scene_template` table This table is used to store necessary data for scenes to run, e.g. ScriptPackageId and Flags. Structure Field Type Attributes Key Null Default Extra Comment in(10) UNSIGNED PRI NO NONE scripts.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 scripts <-Back-to:World Tables: **_scripts This table format is used for 3 different tables to control possible scripts activated by different actions: spell_scripts: Holds scripts that can be activated by spells with effect SPELL_EFFECT_SCRIPT_EFFECT (77) or SPELL_EFFECT_DUMMY(3). script_waypoint.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 [Database Structure](Database-Structure) > [World-Database](World-Database) > [script_waypoint](script_waypoint) # script\_waypoint ###### Used by [CreatureAI]() ### Information Used for CreatureAI waypoint movement. See also [Waypoints-Information](Waypoints-Information) for general information about waypoints. secret_digest.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 secret_digest <-Back-to:Auth The `secret_digest` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO VARCHAR(100) SIGNED NO Description of the fields id The id digest. digest field-no-description\|2 server-setup.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Table of contents - Required/Optional (Not needed if you extract the files.) skillline.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:33:46+00:00 SkillLine ''%%Back-to:DBC%%'' SkillLine.dbc This DBC contains all skills. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2 iRefID_SkillLineCategory Integer 3 skillCostID Integer 4 sRefName String + Loc 5 description String + Loc skill_discovery_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 skill_discovery_template <-Back-to:World The `skill_discovery_template` table This table controls the so called “discovery” system of learning spells. This system is solely [(question)]{.emoticon .emoticon-question} used by the alchemy profession and controls the chance for a player to skill_extra_item_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 skill_extra_item_template <-Back-to:World The `skill_extra_item_template` table This table holds information about when using certain profession spells, you have the chance of creating more than one copy of the item. Structure Field Type Attributes Key Null skill_fishing_base_level.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 skill_fishing_base_level <-Back-to:World The `skill_fishing_base_level` table This table controls the minimum skill level required in fishing to fish in a certain area. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED smart_scripts.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/sai” --- # smart\_scripts [<-Back-to:World](database-world.md) The `smart_scripts` table has 31 attributes. It serves to make scripts in SQL language. The important thing is always to analyze, who is the event that motivates the execution of an action and of course, who is the objective. As a recommendation, you can review the scripts that are already inside the table, to understand how it works. The advantage, for which several use this method, is tha… sniffing-and-parsing.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- tableofcontents: 1 --- # Sniffing & Parsing This guide is to assist in obtaining thorough sniffs with ymir. This guide is written to assume you are familiar with both setting up and running the ymir sniffer at: [() Parsing deals with the translations of sniffs with the tool, Instructions and software at: [ spawn_group.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spawn_group <-Back-to:World The `spawn_group` table This table contains Spawn Group members. Structure Field Type Attributes Key Null Default Extra Comment g INT UNSIGNED PRI NO NULL TINYINT UNSIGNED PRI NO NULL spawn_group_template.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spawn_group_template <-Back-to:World The `spawn_group_template` table This table contains Spawn Group names and flags. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO NULL VARCHAR(100) NO NULL spell-aura-reference.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Spell Aura Reference ''%%Back-to:Spell Effects Reference%%'' ''%%Back-to:spell_dbc%%'' This page contains description regarding the usage of EffectMiscValue and other Spell Aura values. Contains only Spell Auras that have known usage of EffectMiscValue or other unconventional values. Version is : 3.3.5a spell-effects-reference.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:38:04+00:00 Spell ''%%Back-to:DBC%%'' Spell.dbc This DBC contains most information on all spells. These values are used by the core and a few spell_* tables. Version 3.3.5 Structure ID Name Type 0 Entry uint 1 Category uint 2 Dispel uint 3 Mechanic uint spelldifficulty_dbc.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spelldifficulty_dbc <-Back-to:World The `spelldifficulty_dbc` table This table contains spell data regarding cpp scripts. The id is called in the script, and depending on what version of the dungeon/raid the characters are in, the proper spell ID will be casted by the creature. spell_area.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_area <-Back-to:World The `spell_area` table This table is used to apply a specific spell aura to the player within an area in the game. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly. Structure Field spell_bonus_data.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_bonus_data <-Back-to:World The `spell_bonus_data` table Table used for storing custom damage/healing bonus coefficients. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 0 spell_custom_attr.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_custom_attr <-Back-to:World The `spell_custom_attr` table Table used for storing custom spell attributes. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 spell id INT UNSIGNED NO 0 SpellCustomAttributes spell_dbc.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_dbc <-Back-to:World The `spell_dbc` table This table contains data regarding serverside spells which are not to be found in Client DBC files. Spell_Effect_ID * Effect_IDs of Effect1, Effect2 and/or Effect3. Spell_Effect_Apply_Aura_ID * EffectApplyAuraName_IDs of EffectApplyAuraName1, EffectApplyAuraName2 and/or EffectApplyAuraName3. Structure Field spell_enchant_proc_data.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_enchant_proc_data <-Back-to:World The `spell_enchant_proc` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO NULL INT UNSIGNED NO 0 FLOAT UNSIGNED NO 0 FLOAT spell_group.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_group <-Back-to:World The `spell_group` table Table used to group spells for varius checks in the core. One spell may be added to many groups, but can occur in one group only once. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED spell_group_stack_rules.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_group_stack_rules <-Back-to:World The `spell_group_stack_rules` table Table defines if auras in one spell_group can't stack with each other. Notes: The table doesn't affect persistent area auras stacking or passive auras stacking (they can stack always) or spells belonging to same spell_rank (they are always subject of SPELL_GROUP_STACK_RULE_EXCLUSIVE rule) spell_learn_spell.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_learn_spell <-Back-to:World The `spell_learn_spell` table This table holds information on spells that should be learned at the same time a player learns another spell. For example the few spells that are automatically learned when a player first learns a new profession. All fields in this table use spell IDs from Spell.dbc. spell_linked_spell.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_linked_spell <-Back-to:World The `spell_linked_spell` table This table provides data for spell linking system, telling it which spells trigger what, and under which conditions. Field Type Attributes Key Null Default Extra Comment MEDIUMINT SIGNED spell_mixology.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_mixology <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED PctMod FLOAT spell_pet_auras.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_pet_auras <-Back-to:World The `spell_pet_auras` table table-no-description Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL dummy spell id TINYINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED PRI spell_proc.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_proc <-Back-to:World The `spell_proc` table This table holds information on what events (or procs) certain spells are activated. All spells in this table must have apply a SPELL_AURA_PROC_TRIGGER_SPELL (42) aura. Any entries in this table will overwrite the existing proc settings in the spell's DBC entry. spell_proc_event.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_proc_event <-Back-to:World The `spell_proc_event` table Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT SIGNED PRI 0 TINYINT SIGNED 0 SMALLINT UNSIGNED 0 INT UNSIGNED 0 INT spell_ranks.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_ranks <-Back-to:World The `spell_ranks` table Table used by the core to group different ranks of spells (the gray text seen on ranked spells) into one “spell stem”. This partly involves checks for aura stacking (e.g. different levels of the same spell). One spell can not be linked to multiple rank chains (they are spell_required.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_required <-Back-to:World The `spell_required` table Table used to add restrictions for learning spells from trainer. Player can't learn spell 'spell_id' till he learns 'req_spell', when he loses 'req_spell' 'spell_id' will be lost too. Table is used also for profession specialisations as specialisations require profession of certain rank to learn. spell_scripts.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 [Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_scripts](spell_scripts) # spell\_scripts ### Information Holds scripts that can be activated by spells with effect SPELL\_EFFECT\_SCRIPT\_EFFECT (77) or SPELL\_EFFECT\_DUMMY(3). spell_script_names.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_script_names <-Back-to:World The `spell_script_names` table Holds the spell id to ScriptName pairings for use in spell scripts. Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED UNIQUE NO NONE char(64) UNSIGNED spell_system.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 ##### This article was created and ported from Trinity core's wiki since their system is identical # Introduction: How do spells work in Azerothcore? This article is meant to introduce you to the concept of a spellcast. It's an important thing for every scripter to know in brief how this works because spells are one of the main spell_target_position.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_target_position <-Back-to:World The `spell_target_position` table This table holds coordinate information on where the player should be teleported to when a spell with target type: TARGET_DST_DB(17). Structure Field Type Attributes Key Null Default spell_threat.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 spell_threat <-Back-to:World The `spell_threat` table This table holds threat values on all spells that should either give or take away threat. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL SMALLINT sql-directory.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 SQL Directory $ is relative to the source directory. Create and drop files All create and drop files are found in the $\data\sql\create\ directory. create_mysql.sql contains the queries to create the acore user and the databases. drop_mysql.sql revokes all permissions and drops the acore user and drops all databases. This is used for MySQL 5.7. sql-standards.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- tableofcontents: 1 redirect_from: /Dealing-with-SQL-files --- # SQL Standards ## Queries ### General standards We always use backticks \` around the table- and column names. \`creature_loot_template\`. We always use single quotes around string values ' ' but NEVER around an integer. sql-versioning.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/SQL-Versioning” --- # SQL Versioning We've two kind of versions: - Chronological versioning, For accepted sql files - Versioning by id, mostly used for pending sql ## Chronological Versioning We use the good old MaNGOS-way to make sure that all the standard-operating-procedure.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Standard Operating Procedure * C++ Code Standards * SQL Standards * File Headers * Issue Tracker Standards * Wiki Standards summonproperties_dbc.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 summonproperties_dbc ''%%Back-to:Spell Effects Reference%%'' ''%%Back-to:DBC%%'' The `summonproperties_dbc` table This DBC contains Summon Properties (EffectMiscValueB) for Spell Effect SPELL_EFFECT_SUMMON (28) Version is : 3.3.5a Structure Field Type Attributes Key Null Default Extra Comment the-modular-structure.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/The-Modular-Structure” --- # The Modular Structure Based on our modular domain-based [directory structure](Directory-Structure) , the AzerothCore project allows you to add and extend game features by adding custom isolated modules, without patching the core directly. the-staging-branch.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/The-Staging-Branch” --- # The Staging Branch # NOTE: CURRENTLY DISABLED At AzerothCore, changes are submitted via PRs that are first tested and then merged to the `master`branch. However, some PRs can be hard to test. For example when a PR contains changes that potentially can affect many things. To improve our QA and make sure such modifications don't introduce bugs in the master branch, we created the `staging` branch. totemcategory.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:32:48+00:00 TotemCategory ''%%Back-to:DBC%%'' TotemCategory.dbc Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2-18 sRefName String + Loc Includes all kinds of component things.. not just totems 19 Category Integer Which category the tool belongs to (1 = totems, 3 = enchanting rods etc) transports.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 transports <-Back-to:World The `transports` table This table contains all type 15 transports (Boats and Zeppelins). All other transport types have their frame time read from TransportAnimation.dbc. Structure Field Type Attribute Key Null Default Extra Comment trinitycore-to-azerothcore-characters-migration.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/TrinityCore-to-AzerothCore-characters-migration” --- # TrinityCore to AzerothCore Character & Auth Migration Tool ### 1) Install AzerothCore Follow the Installation instructions and install a fresh setup of AzerothCore (we will need this after the conversion). unit-testing.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Unit testing at AzerothCore How to compile and run the AC unit tests * You have to compile your core by passing -DBUILD_TESTING=1 in your cmake command. For example: cd azerothcore mkdir build cd build cmake ../ -DWITH_WARNINGS=1 -DTOOLS=0 -DSCRIPTS=static -DBUILD_TESTING=1 make install -j 6 update.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/Update” --- # How to update AzerothCore to the latest stable version {% include warning.html content=“THIS IS NOT UP TO DATE. SEE DISCORD ANNOUNCEMENT CHANNEL ON WHICH COMMIT TO CHECKOUT!” %} ## Verify that you're on the latest release updatefields.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/UpdateFields” --- # UpdateFields ### General Block Value 2: OBJECT_FIELD_TYPE: Value Description ------------------------------ 3 Item 7 Bag 9 updates.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 updates <-Back-to:Auth <-Back-to:Characters <-Back-to:World The `updates` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(200) PRI NO Filename with extension of the update. CHAR(40) YES '' SHA1 hash of the sql file. ENUM RELEASED,CUSTOM,ARCHIVED updates_include.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 updates_include <-Back-to:Auth <-Back-to:Characters <-Back-to:World The `updates_include` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(200) PRI NO Directory to include. $ means relative to the source directory. ENUM RELEASED,CUSTOM,ARCHIVED upgrade-from-pre-2.0.0-to-latest-master.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/Upgrade-from-pre-2.0.0-to-latest-master” --- # Upgrade from pre 2.0.0 to latest master This is the tutorial to upgrade any existing server from a version prior to the [2.0.0 release]() to the latest `master` version. uptime.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 uptime <-Back-to:Auth The `uptime` table This table holds the server's uptime. The core will automatically update the latest entry's value until it crashes and a new record is added. Structure Field Type Attributes Key Null Default Extra Comment INT useful-sql.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- tableofcontents: 1 --- # Useful SQL snippets ## Introduction These SQL queries are intended to be fast and easy-to-use tools that can help identify and troubleshoot problems in the AzerothCore database. They're here to be a quick reference to help when looking at DB-related problems. If anyone else has any similar useful queries, let me know and I'll add them. Similarly, if you have a common problem for which you'd like a query written, feel free to get in touch. useful-tools.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Useful Tools These are the most useful tools out there for AzerothCore development. * Keira3 is a Database Editor for AzerothCore. Learn more about the tool here. * SpellWork is a tool to browse and display information about World of Wacraft spells. Learn more about the tool vehicle_accessory.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 vehicle_accessory <-Back-to:World The `vehicle_accessory` table This table is used to tell the server to spawn an additional NPC with this vehicle. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT vehicle_template_accessory.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 vehicle_template_accessory <-Back-to:World The `vehicle_template_accessory` table Records in this table can be overwritten by vehicle_accessory table Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED version.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 version <-Back-to:World The `version` table Includes information on current core and database version. Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(120) SIGNED YES NULL Core revision dumped at startup BIGINT UNSIGNED version_db_auth.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 version_db_auth <-Back-to:Auth The `version_db_auth` table Field Type Attributes Key Null Default Extra Comment VARCHAR(100) SIGNED PRI NO VARCHAR(100) SIGNED MUL YES VARCHAR(50) SIGNED YES BIT(1) SIGNED YES version_db_characters.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 version_db_characters <-Back-to:Characters The `version_db_characters` table Field Type Attributes Key Null Default Extra Comment VARCHAR(100) SIGNED PRI NO VARCHAR(100) SIGNED YES VARCHAR(50) SIGNED YES BIT(1) SIGNED version_db_world.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 [Database Structure](Database-Structure) > [World-Database](World-Database) > [version_db_world](version_db_world) Column \| Type \| Description --- \| --- \| --- Sql_rev \| VARCHAR(100) \| Required_rev \| VARCHAR(100) \| 2017_05_01_07 \| bit(1) \| vsc-requirements.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 VSC Requirements Installation Guide << Start: Installation Guide Step 2: VSC Core Installation >> Boost ≥ 1.70 - 1.74 MySQL ≥ 5.7.0 OpenSLL ≥ 1.0.x CMake ≥ 3.16 MS Visual Studio Build Tools - Git Extensions * You will need Git installed. You can get the latest version here * Install warden_action.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 warden_action <-Back-to:Characters The `warden_action` table Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED NO TINYINT UNSIGNED YES Description of the fields wardenid field-no-description\|1 action warden_checks.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 warden_checks Table: warden_checks This table contains data related to the use of the anti-cheat tool Warden, which can be enabled in Worldserver.conf Field Type Attributes Key NULL Default Comment SMALLINT UNSIGNED PRI NO auto_increment waypoints-information.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 --- redirect_from: “/Waypoints-Information” --- # Waypoints and paths ### Different kinds of waypoint paths - Waypoint paths directly attached to a creature via [creature_addon.path_id](creature_addon#path_id) use the tables [waypoint_data](waypoint_data) and [waypoint_scripts](waypoint_scripts). They can be added and manipulated using the GM '.wp' commands. - [SmartAI](smart_scripts) uses waypoint paths defined in table [waypoints](waypoints). - The table [script_waypoint… waypoints.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 waypoints <-Back-to:World Used by [[smart_scripts\|SAI]] Information Contains waypoint data, allowing creatures to move to certain X, Y, and Z coordinates. See also Waypoints-Information for general information about waypoints. Structure Field Type Attributes Key Null Default waypoint_data.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 waypoint_data <-Back-to:World Information This table contains all the path data for creatures that use waypoints and waypoint scripts directly in their creature addon definition. See also Waypoints-Information for general information about waypoints. Structure Field Type Attributes waypoint_scripts.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 [Database Structure](Database-Structure) > [World-Database](World-Database) > [waypoint_scripts](waypoint_scripts) # waypoint\_scripts ###### Used by [waypoint_data](waypoint_data) ### Information Waypoint paths directly attached to a creature via [creature_addon.path_id](creature_addon#path_id) use the tables [waypoint_data](waypoint_data) and [waypoint_scripts](waypoint_scripts). They can be added and manipulated using the GM '.wp' commands. See also [Waypoints-Informat… wiki-alerts-and-callouts.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Wiki Alerts and Callouts Alerts Alerts can be added as following. {% raw %} {% include note.html content="Add content between quotes" %} {% include tip.html content="Add content between quotes" %} {% include important.html content="Add content between quotes" %} {% include warning.html content="Add content between quotes" %} wiki-standards.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 WIKI STANDARDS FILE NAMING: DATABASE TABLES files are to be named exactly as it is in the database, ALL OTHER FILES are to be named in lowercase and to use - (dashes) for spaces. FILES SHOULD NOT contain special characters other than - (dashes). If we want a file named C++ we name it cpp. windows-core-installation.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Windows Core Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 1: Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Pulling & Compiling the source windows-keeping-the-server-up-to-date.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Windows Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> Keeping the source Up-to-Date Open your AzerothCore repository in GitExtensions. windows-requirements.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Windows Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Installation Guide Step 2: Core Installation >> {% include callout.html content=“Windows ≥ 10 Boost ≥ 1.78 MySQL ≥ 5.7.0 (Recommended version: ≥ 8.0) OpenSSL ≥ 3.0.x (Ver. 3.1 and above are not supported.) CMake ≥ 3.16 MS Visual Studio (Community) ≥ 17 (2022) (Desktop) (No previe… windows-server-setup.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Windows Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Extracting DBC, Maps, VMaps & MMaps * Browse into your build directory ( windows-vsc-core-installation.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 Windows VSC Core Installation Installation Guide << Step 1: VSC Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Pulling & Compiling the source Pulling the code * Create the directory where the source files will be located. In this guide we will use C:\Azerothcore worldstates.md Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00 worldstates <-Back-to:Characters The `worldstates` table This table holds data the Core needs to handle variables (like timer for arena point automatic flush). Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0

Mapping from types used in SQL queries

…

networking.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Networking Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 4: Database Installation Step 6: Final Server Steps >> This guide is intended for advanced setups or just to provide more details in setting up your realm for local or internet use. In general, the default setup explained in your particular

npc_spellclick_spells.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

npc_spellclick_spells <-Back-to:World The `npc_spellclick_spells` table This table holds information about spells to be cast upon receiving CMSG_SPELLCLICK. That opcode is sent for quests in which you have to loot creatures, who are already dead at spawning. Examples are

npc_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

npc_text <-Back-to:World Table Structure This table contains the texts that are used for gossip. More research needs to be done on this table. Field Type Attributes Key Null Default Extra Comment ID MEDIUMINT UNSIGNED PRI NO 0 text0_0 longtext

npc_text_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

npc_text_locale <-Back-to:World The `npc_text_locale` table This table is used to provide localized clients with localized string for npc_texts. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO

npc_trainer.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

npc_trainer <-Back-to:World The `npc_trainer` table This table contains all the spells that each trainer can teach. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT SIGNED PRI NO 0

npc_vendor.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

npc_vendor <-Back-to:World General information This table holds the vendor data for all NPCs that sell items or currencies. A vendor can only hold up to 150 items (15 pages), it is hardcoded in the emulator and if you change it, the client will crash. Prices The price (in gold) for each item or currency is defined in its item template related entry as

outdoorpvp_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

outdoorpvp_template <-Back-to:World Field Type Attributes Key Null Default Extra Comment TINYINT unasigned PRI NO char(64) SIGNED NO 0 text SIGNED YES NULL Description of the fields TypeId Id defined in the emulator for each PvP zone in the world.

pagetextmaterial.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:37:31+00:00

PageTextMaterial ''%%Back-to:DBC%%'' PageTextMaterial.dbc This DBC contains material used to display a gossip window for quest or page text. Version is : 3.1.3 Structure Column Field Type 1 ID Integer 2 sRefCon String **Content** ID Name

page_text.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

page_text <-Back-to:World The `page_text` table This table holds the text for letter items or any items that when moused-over turn the cursor into a magnifying glass and on right-click will open up a window where you can read the contents of the letter. Structure

page_text_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

page_text_locale <-Back-to:World The `page_text_locale` table This table is used to provide localized clients with localized string for page_texts. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI

petition.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

petition <-Back-to:Characters The `petition` table This table holds information on all ongoing petitions for a guild or for an arena team. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT UNSIGNED YES

petition_sign.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

petition_sign <-Back-to:Characters The `petition_sign` table This table holds information on all the signatures of a petition for either a guild or an arena team. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO INT

pet_aura.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_aura <-Back-to:Characters The `pet_aura` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier BIGINT UNSIGNED PRI NO 0 Full Global Unique Identifier MEDIUMINT UNSIGNED

pet_levelstats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_levelstats <-Back-to:World The `pet_levelstats` table This table holds information on individual pet base stats based on level. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL

pet_name_generation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_name_generation <-Back-to:World The `pet_name_generation` table This table holds pieces of names (first and last half) that are use for pet name generation. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO

pet_name_generation_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_name_generation_locale <-Back-to:World The `pet_name_generation_locale` table This table holds pieces of names (first and last half) that are use for pet name generation for locale. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT

pet_spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_spell <-Back-to:Characters The `pet_spell` table This table holds information on individual pet spells. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier MEDIUMINT UNSIGNED PRI NO

pet_spell_cooldown.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pet_spell_cooldown <-Back-to:Characters The `pet_spell_cooldown` table This table holds information on pet spell cooldowns. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 Global Unique Identifier, Low part MEDIUMINT

phase_area.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

phase_area Back-to:World Tables**:** phase_area General PhaseIds added to player by zone/area events. Each line holds one Zone or Area with one phaseId and a description. Each line is active by default. With the table conditionsyou can edit the working range of the phase.

playercreateinfo.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

playercreateinfo <-Back-to:World The `playercreateinfo` table This table holds the start positions of each class-race combinations for all newly created characters. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI

playercreateinfo_action.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

playercreateinfo_action <-Back-to:World Table Structure This table holds information on what default actions a brand new character should start out with. Each race-class combination can have a different default starting setup. Field Type Attributes Key Null

playercreateinfo_item.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

playercreateinfo_item <-Back-to:World The `playercreateinfo_item` table This table is used for any custom items that you might want to give to characters on creation. I used to be used to hold the normal items that characters get as well, but now that info is read from CharStartOutfit.dbc

playercreateinfo_skills.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

playercreateinfo_skills <-Back-to:World playercreateinfo_skills table This table holds information on what skills newly created characters should start out with. A character in this table is defined by his/her race and class combination. Structure

playercreateinfo_spell_custom.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

playercreateinfo_spell_custom <-Back-to:World This table holds information on what spells newly created characters should start with if the PlayerStart.AllSpells setting is enabled in worldserver.conf. A character in this table is defined by his/her race and class combination.

player_class_stats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_class_stats <-Back-to:World The `player_class_stats` table This table holds information on what values are applied to stats for characters as they level up. All of the values in this table signify only the base stats of a class at a specific level. Structure

player_factionchange_achievement.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_achievement <-Back-to:World The `player_factionchange_achievement` table Basically all achievement changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT

player_factionchange_items.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_items <-Back-to:World The `player_factionchange_items` table Basically all item changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT SIGNED NO INT SIGNED PRI NO

player_factionchange_quests.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_quest <-Back-to:World Column Type Description Alliance_id INT UNSIGNED Horde_id INT UNSIGNED

player_factionchange_reputations.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_reputations <-Back-to:World The `player_factionchange_reputations` table Basically all faction/reputation changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO

player_factionchange_spells.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_spells <-Back-to:World The `player_factionchange_spells` table Basically all spell changes made when player changes faction. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO INT SIGNED PRI NO

player_factionchange_titles.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_factionchange_titles <-Back-to:World Column Type Description Alliance_id INT Horde_id INT

player_race_stats.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_race_stats <-Back-to:World The `player_race_stats` table This table holds information on modifiers for stat values applied to characters. All of the values in this table signify only the stat value modifiers based on the race of a character. Structure Field

player_xp_for_level.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

player_xp_for_level <-Back-to:World The `player_xp_for_level` table Includes information on how much experience needed for next level. Comes from sniffs. Structure Field Type Attributes Key Null Default Extra Comment TINYINT UNSIGNED PRI NO NULL

points_of_interest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

points_of_interest <-Back-to:World The `points_of_interest` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 0 FLOAT SIGNED NO 0 MEDIUMINT

points_of_interest_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

points_of_interest_locale <-Back-to:World The `locales_points_of_interest` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment D MEDIUMINT UNSIGNED PRI NO 0 locale text SIGNED YES

pool_creature.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_creature <-Back-to:World The `pool_creature` table This table contains a list of creatures that are tied to a specific pool. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED NO

pool_gameobject.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_gameobject <-Back-to:World The `pool_gameobject` table This table contains gameobjects that are tied to a specific pool. This table can only contain gameobjects that have a type of GAMEOBJECT_TYPE_CHEST, GAMEOBJECT_TYPE_GOOBER, GAMEOBJECT_TYPE_FISHINGHOLE.

pool_pool.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_pool <-Back-to:World The `pool_pool` table This is the pool of pools table. You can create a pool with a chance of a range of pools in that pool being activated. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED

pool_quest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_quest <-Back-to:World The `pool_quest` table This table contains a list of quests that are tied to a specific pool. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED NO 0

pool_quest_save.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_quest_save <-Back-to:Characters The `pool_quest_save` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 Description of the fields pool_id pool_quest.entry. quest_id quest_template.id.

pool_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pool_template <-Back-to:World The `pool_template` table Each unique pool is defined in this table. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 Pool entry INT UNSIGNED NO 0 Max number of objects (0) is no limit

project-versioning.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/Project-Versioning” --- ## Project Versioning We are using the semantic versioning standard: For instance, we can have: 1.5.1-dev.1 that corresponds to: MAJOR.MINOR.PATCH-PRERELEASE More in depth: * MAJOR version when you make incompatible

pvpstats_battlegrounds.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pvpstats_battlegrounds <-Back-to:Characters The `pvpstats_battlegrounds` table This table holds datas about BattleGrounds scores. To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config.dist file. Structure Field

pvpstats_players.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

pvpstats_players <-Back-to:Characters The `pvpstats_players` table This table holds datas about BattleGrounds scores. To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config.dist file. Structure Field Type Attributes

quest_details.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_details Table: quest_details This table handles Quest NPC emotes with emote delays. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO 0 Unique ID (quest_template.ID) SMALLINT UNSIGNED NO 0 Quest NPC Emote

quest_greeting.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_greeting Table: quest_greeting This table add greeting behavior to an NPC or an Gameobject. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED Yes NO 0 TINYINT UNSIGNED Yes NO 0 SMALLINT UNSIGNED NO

quest_greeting_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_mail_sender.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_mail_sender <-Back-to:World The `quest_mail_sender` table Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 Description of the fields QuestId Is the quest ID, obtained from quest_template

quest_money_reward.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_money_reward Table: quest_money_reward This table enables dynamically rewarding money dependent on player's level. Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO 0 Player's level MEDIUMINT

quest_objectives.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_objectives <-Back-to:World Table: quest_objectives This table provides answer for a very important question. What do I need to do in order to finish a quest? Structure Field Type Attributes Null Key Default Comment MEDIUMINT UNSIGNED NO PRI 0

quest_offer_reward.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_offer_reward Table: quest_offer_reward This table is used for quests offering rewards without any required quest items (no item delivery involved). Field Type Attributes Key NULL Default Comment MEDIUMINT UNSIGNED PRI NO

quest_offer_reward_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_offer_reward_locale <-Back-to:World The `quest_offer_reward_locale` table Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO 0 VARCHAR(4) PRI NO NULL text YES NULL SMALLINT NO

quest_poi.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_poi <-Back-to:World The `quest_poi` table Comes from sniffs. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0 INT UNSIGNED PRI NO 0 INT UNSIGNED NO 0 INT UNSIGNED NO 0

quest_poi_points.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_poi_points <-Back-to:World The `quest_poi_points` table Comes from sniffs. Visually speaking, this table is used to identify the X and Y coordinates on the map (not the minimap - the main map) where a quest's question mark should appear. Use the “.gps”

quest_request_items.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_request_items Table: quest_request_items This table basically handles 3 quest details: * NPC Emote when quest is completed * NPC Emote when quest is incomplete * Completion text for quests requiring quest items Field Type Attributes

quest_request_items_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_request_items_locale Table: quest_request_items_locale <-Back-to:World Structure Field Type Attribute Key Null Default Extra Comment INT UNSIGNED PRI NO VARCHAR(4) PRI NO text YES NULL SMALLINT NO

quest_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_template <-Back-to:World Table: quest_template Contains all basic definitions of available quests. **Structure** Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 TINYINT UNSIGNED NO 2 SMALLINT

quest_template_addon.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_template_addon <-Back-to:World Table: quest_template_addon Contains extra definitions like linking quests, dependencies and requirements for the quests defined in the quest_template table to become available to the player. Structure: Field Type Attributes Key Null

quest_template_locale.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_template_locale <-Back-to:World The `quest_template_locale` table This table is used to provide to localized clients with localized string for quest templates. Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI

quest_tracker.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

quest_tracker <-Back-to:Character The `quest_tracker` table Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED NO 0 INT UNSIGNED NO 0 DATETIME SIGNED NO DATETIME SIGNED YES DATETIME

realmcharacters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

realmcharacters <-Back-to:Auth The `realmcharacters` table This table holds information on the number of characters each account has for each realm. The data in this table is maintained by the core. Structure Field Type Attributes Key Null Default Extra

realmlist.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

realmlist <-Back-to:Auth The `realmlist` table This table sets up information on all available realms. Each row controls a different realm. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT VARCHAR(32)

recovery_item.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

recovery_item <-Back-to:Characters The `recovery_item` table This table holds information about character's matchmaker rating in all team types. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO AUTO_INCREMENT INT

remote-access.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/Remote-Access” --- # Remote Access ## Introduction Azerothcore has 4 ways of interfacing with the world server. - In Game - The Console - Telnet (RA) - HTTP (SOAP) The in game menus and the console are pretty self explanatory, however you are not always able to administer the server locally nor do the first two options provide many opportunities for automation. If you want to provide a way to access your server remotely, or let software manage it the…

reputation_reward_rate.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

reputation_reward_rate <-Back-to:World The `reputation_reward_rate` table Holds reputation multipliers for specific factions. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 1

reputation_spillover_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

reputation_spillover_template <-Back-to:World The `reputation_spillover_rate` table field-no-description|0 Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED PRI NO 0 SMALLINT UNSIGNED NO 0 FLOAT SIGNED

requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Classic Installation Step 2: Core Installation >> Linux Requirements macOS Requirements Windows Requirements
Help If you are still having problems, check: * FAQ * Common Errors *

reserved_name.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

reserved_name <-Back-to:Characters The `reserved_name` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(12) SIGNED PRI NO '' Description of the fields name Name to be reserevd

run-worldserver-and-authserver-in-visual-studio.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Run Worldserver and Authserver in Visual Studio Running the Worldserver and Authserver through Visual Studio has some benefits. * You can easily debug code using breakpoints or easily finding the Call Stack of a crash. * It will also let your server pause instead of crashing when you hit a crash, and you can easily just continue after your debugging.

scene_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

scene_template <-Back-to:World The `scene_template` table This table is used to store necessary data for scenes to run, e.g. ScriptPackageId and Flags. Structure Field Type Attributes Key Null Default Extra Comment in(10) UNSIGNED PRI NO NONE

scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

scripts <-Back-to:World Tables: ***_scripts This table format is used for 3 different tables to control possible scripts activated by different actions: spell_scripts: Holds scripts that can be activated by spells with effect SPELL_EFFECT_SCRIPT_EFFECT (77) or SPELL_EFFECT_DUMMY(3).

script_waypoint.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [script_waypoint](script_waypoint) # script\_waypoint ###### Used by [CreatureAI]() ### Information Used for CreatureAI waypoint movement. See also [Waypoints-Information](Waypoints-Information) for general information about waypoints.

secret_digest.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

secret_digest <-Back-to:Auth The `secret_digest` table Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO VARCHAR(100) SIGNED NO Description of the fields id The id digest. digest field-no-description|2

server-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Table of contents * - Required/Optional (Not needed if you extract the files.)

skillline.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:33:46+00:00

SkillLine ''%%Back-to:DBC%%'' SkillLine.dbc This DBC contains all skills. Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2 iRefID_SkillLineCategory Integer 3 skillCostID Integer 4 sRefName String + Loc 5 description String + Loc

skill_discovery_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

skill_discovery_template <-Back-to:World The `skill_discovery_template` table This table controls the so called “discovery” system of learning spells. This system is solely [(question)]{.emoticon .emoticon-question} used by the alchemy profession and controls the chance for a player to

skill_extra_item_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

skill_extra_item_template <-Back-to:World The `skill_extra_item_template` table This table holds information about when using certain profession spells, you have the chance of creating more than one copy of the item. Structure Field Type Attributes Key Null

skill_fishing_base_level.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

skill_fishing_base_level <-Back-to:World The `skill_fishing_base_level` table This table controls the minimum skill level required in fishing to fish in a certain area. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED

smart_scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/sai” --- # smart\_scripts [<-Back-to:World](database-world.md) The `smart_scripts` table has 31 attributes. It serves to make scripts in SQL language. The important thing is always to analyze, who is the event that motivates the execution of an action and of course, who is the objective. As a recommendation, you can review the scripts that are already inside the table, to understand how it works. The advantage, for which several use this method, is tha…

sniffing-and-parsing.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- tableofcontents: 1 --- # Sniffing & Parsing This guide is to assist in obtaining thorough sniffs with ymir. This guide is written to assume you are familiar with both setting up and running the ymir sniffer at: [() Parsing deals with the translations of sniffs with the tool, Instructions and software at: [

spawn_group.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spawn_group <-Back-to:World The `spawn_group` table This table contains Spawn Group members. Structure Field Type Attributes Key Null Default Extra Comment g INT UNSIGNED PRI NO NULL TINYINT UNSIGNED PRI NO NULL

spawn_group_template.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spawn_group_template <-Back-to:World The `spawn_group_template` table This table contains Spawn Group names and flags. Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO NULL VARCHAR(100) NO NULL

spell-aura-reference.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Spell Aura Reference ''%%Back-to:Spell Effects Reference%%'' ''%%Back-to:spell_dbc%%'' This page contains description regarding the usage of EffectMiscValue and other Spell Aura values. Contains only Spell Auras that have known usage of EffectMiscValue or other unconventional values. Version is : 3.3.5a

spell-effects-reference.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:38:04+00:00

Spell ''%%Back-to:DBC%%'' **Spell.dbc** This DBC contains most information on all spells. These values are used by the core and a few spell_* tables. Version 3.3.5 **Structure** ID Name Type 0 Entry uint 1 Category uint 2 Dispel uint 3 Mechanic uint

spelldifficulty_dbc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spelldifficulty_dbc <-Back-to:World The `spelldifficulty_dbc` table This table contains spell data regarding cpp scripts. The id is called in the script, and depending on what version of the dungeon/raid the characters are in, the proper spell ID will be casted by the creature.

spell_area.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_area <-Back-to:World The `spell_area` table This table is used to apply a specific spell aura to the player within an area in the game. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly. Structure Field

spell_bonus_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_bonus_data <-Back-to:World The `spell_bonus_data` table Table used for storing custom damage/healing bonus coefficients. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 FLOAT SIGNED NO 0

spell_custom_attr.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_custom_attr <-Back-to:World The `spell_custom_attr` table Table used for storing custom spell attributes. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 spell id INT UNSIGNED NO 0 SpellCustomAttributes

spell_dbc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_dbc <-Back-to:World The `spell_dbc` table This table contains data regarding serverside spells which are not to be found in Client DBC files. Spell_Effect_ID * Effect_IDs of Effect1, Effect2 and/or Effect3. Spell_Effect_Apply_Aura_ID * EffectApplyAuraName_IDs of EffectApplyAuraName1, EffectApplyAuraName2 and/or EffectApplyAuraName3. Structure Field

spell_enchant_proc_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_enchant_proc_data <-Back-to:World The `spell_enchant_proc` table table-no-description Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED NO NULL INT UNSIGNED NO 0 FLOAT UNSIGNED NO 0 FLOAT

spell_group.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_group <-Back-to:World The `spell_group` table Table used to group spells for varius checks in the core. One spell may be added to many groups, but can occur in one group only once. Field Type Attributes Key Null Default Extra Comment INT UNSIGNED

spell_group_stack_rules.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_group_stack_rules <-Back-to:World The `spell_group_stack_rules` table Table defines if auras in one spell_group can't stack with each other. Notes: The table doesn't affect persistent area auras stacking or passive auras stacking (they can stack always) or spells belonging to same spell_rank (they are always subject of SPELL_GROUP_STACK_RULE_EXCLUSIVE rule)

spell_learn_spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_learn_spell <-Back-to:World The `spell_learn_spell` table This table holds information on spells that should be learned at the same time a player learns another spell. For example the few spells that are automatically learned when a player first learns a new profession. All fields in this table use spell IDs from Spell.dbc.

spell_linked_spell.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_linked_spell <-Back-to:World The `spell_linked_spell` table This table provides data for spell linking system, telling it which spells trigger what, and under which conditions. Field Type Attributes Key Null Default Extra Comment MEDIUMINT SIGNED

spell_mixology.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_mixology <-Back-to:World Column Type Description Entry MEDIUMINT UNSIGNED PctMod FLOAT

spell_pet_auras.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_pet_auras <-Back-to:World The `spell_pet_auras` table table-no-description Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL dummy spell id TINYINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED PRI

spell_proc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_proc <-Back-to:World The `spell_proc` table This table holds information on what events (or procs) certain spells are activated. All spells in this table must have apply a SPELL_AURA_PROC_TRIGGER_SPELL (42) aura. Any entries in this table will overwrite the existing proc settings in the spell's DBC entry.

spell_proc_event.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_proc_event <-Back-to:World The `spell_proc_event` table Structure Field Type Attribute Key Null Default Extra Comment MEDIUMINT SIGNED PRI 0 TINYINT SIGNED 0 SMALLINT UNSIGNED 0 INT UNSIGNED 0 INT

spell_ranks.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_ranks <-Back-to:World The `spell_ranks` table Table used by the core to group different ranks of spells (the gray text seen on ranked spells) into one “spell stem”. This partly involves checks for aura stacking (e.g. different levels of the same spell). One spell can not be linked to multiple rank chains (they are

spell_required.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_required <-Back-to:World The `spell_required` table Table used to add restrictions for learning spells from trainer. Player can't learn spell 'spell_id' till he learns 'req_spell', when he loses 'req_spell' 'spell_id' will be lost too. Table is used also for profession specialisations as specialisations require profession of certain rank to learn.

spell_scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_scripts](spell_scripts) # spell\_scripts ### Information Holds scripts that can be activated by spells with effect SPELL\_EFFECT\_SCRIPT\_EFFECT (77) or SPELL\_EFFECT\_DUMMY(3).

spell_script_names.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_script_names <-Back-to:World The `spell_script_names` table Holds the spell id to ScriptName pairings for use in spell scripts. Structure Field Type Attributes Key Null Default Extra Comment INT SIGNED UNIQUE NO NONE char(64) UNSIGNED

spell_system.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

##### This article was created and ported from Trinity core's wiki since their system is identical # *Introduction: How do spells work in Azerothcore?* This article is meant to introduce you to the concept of a spellcast. It's an important thing for every scripter to know in brief how this works because spells are one of the main

spell_target_position.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_target_position <-Back-to:World The `spell_target_position` table This table holds coordinate information on where the player should be teleported to when a spell with target type: TARGET_DST_DB(17). Structure Field Type Attributes Key Null Default

spell_threat.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

spell_threat <-Back-to:World The `spell_threat` table This table holds threat values on all spells that should either give or take away threat. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO NULL SMALLINT

sql-directory.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

SQL Directory $ is relative to the source directory. Create and drop files All create and drop files are found in the $\data\sql\create\ directory. create_mysql.sql contains the queries to create the acore user and the databases. drop_mysql.sql revokes all permissions and drops the acore user and drops all databases. This is used for MySQL 5.7.

sql-standards.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- tableofcontents: 1 redirect_from: /Dealing-with-SQL-files --- # SQL Standards ## Queries ### General standards We always use backticks \` around the table- and column names. \`creature_loot_template\`. We always use single quotes around string values ' ' but NEVER around an integer.

sql-versioning.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/SQL-Versioning” --- # SQL Versioning We've two kind of versions: - Chronological versioning, For accepted sql files - Versioning by id, mostly used for pending sql ## Chronological Versioning We use the good old MaNGOS-way to make sure that all the

standard-operating-procedure.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Standard Operating Procedure * C++ Code Standards * SQL Standards * File Headers * Issue Tracker Standards * Wiki Standards

summonproperties_dbc.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

summonproperties_dbc ''%%Back-to:Spell Effects Reference%%'' ''%%Back-to:DBC%%'' The `summonproperties_dbc` table This DBC contains Summon Properties (EffectMiscValueB) for Spell Effect SPELL_EFFECT_SUMMON (28) Version is : 3.3.5a Structure Field Type Attributes Key Null Default Extra Comment

the-modular-structure.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/The-Modular-Structure” --- # The Modular Structure Based on our modular domain-based [directory structure](Directory-Structure) , the AzerothCore project allows you to add and extend game features by adding custom isolated modules, without patching the core directly.

the-staging-branch.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/The-Staging-Branch” --- # The Staging Branch # NOTE: CURRENTLY DISABLED At AzerothCore, changes are submitted via PRs that are first tested and then merged to the `master`branch. However, some PRs can be hard to test. For example when a PR contains changes that potentially can affect many things. To improve our QA and make sure such modifications don't introduce bugs in the master branch, we created the `staging` branch.

totemcategory.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-23T07:32:48+00:00

TotemCategory ''%%Back-to:DBC%%'' TotemCategory.dbc Version is : 3.3.5a Structure Column Field Type Notes 1 ID Integer 2-18 sRefName String + Loc Includes all kinds of component things.. not just totems 19 Category Integer Which category the tool belongs to (1 = totems, 3 = enchanting rods etc)

transports.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

transports <-Back-to:World The `transports` table This table contains all type 15 transports (Boats and Zeppelins). All other transport types have their frame time read from TransportAnimation.dbc. Structure Field Type Attribute Key Null Default Extra Comment

trinitycore-to-azerothcore-characters-migration.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/TrinityCore-to-AzerothCore-characters-migration” --- # TrinityCore to AzerothCore Character & Auth Migration Tool ### 1) Install AzerothCore Follow the Installation instructions and install a fresh setup of AzerothCore (we will need this after the conversion).

unit-testing.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Unit testing at AzerothCore How to compile and run the AC unit tests * You have to compile your core by passing -DBUILD_TESTING=1 in your cmake command. For example: cd azerothcore mkdir build cd build cmake ../ -DWITH_WARNINGS=1 -DTOOLS=0 -DSCRIPTS=static -DBUILD_TESTING=1 make install -j 6

update.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/Update” --- # How to update AzerothCore to the latest stable version {% include warning.html content=“THIS IS NOT UP TO DATE. SEE DISCORD ANNOUNCEMENT CHANNEL ON WHICH COMMIT TO CHECKOUT!” %} ## Verify that you're on the latest release

updatefields.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/UpdateFields” --- # UpdateFields ### General Block Value 2: OBJECT_FIELD_TYPE: Value Description ------------------------------ 3 Item 7 Bag 9

updates.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

updates <-Back-to:Auth <-Back-to:Characters <-Back-to:World The `updates` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(200) PRI NO Filename with extension of the update. CHAR(40) YES '' SHA1 hash of the sql file. ENUM RELEASED,CUSTOM,ARCHIVED

updates_include.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

updates_include <-Back-to:Auth <-Back-to:Characters <-Back-to:World The `updates_include` table Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(200) PRI NO Directory to include. $ means relative to the source directory. ENUM RELEASED,CUSTOM,ARCHIVED

upgrade-from-pre-2.0.0-to-latest-master.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/Upgrade-from-pre-2.0.0-to-latest-master” --- # Upgrade from pre 2.0.0 to latest master This is the tutorial to upgrade any existing server from a version prior to the [2.0.0 release]() to the latest `master` version.

uptime.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

uptime <-Back-to:Auth The `uptime` table This table holds the server's uptime. The core will automatically update the latest entry's value until it crashes and a new record is added. Structure Field Type Attributes Key Null Default Extra Comment INT

useful-sql.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- tableofcontents: 1 --- # Useful SQL snippets ## Introduction These SQL queries are intended to be fast and easy-to-use tools that can help identify and troubleshoot problems in the AzerothCore database. They're here to be a quick reference to help when looking at DB-related problems. If anyone else has any similar useful queries, let me know and I'll add them. Similarly, if you have a common problem for which you'd like a query written, feel free to get in touch.

useful-tools.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Useful Tools These are the most useful tools out there for AzerothCore development. * Keira3 is a Database Editor for AzerothCore. Learn more about the tool here. * SpellWork is a tool to browse and display information about World of Wacraft spells. Learn more about the tool

vehicle_accessory.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

vehicle_accessory <-Back-to:World The `vehicle_accessory` table This table is used to tell the server to spawn an additional NPC with this vehicle. Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT

vehicle_template_accessory.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

vehicle_template_accessory <-Back-to:World The `vehicle_template_accessory` table Records in this table can be overwritten by vehicle_accessory table Structure Field Type Attributes Key Null Default Extra Comment MEDIUMINT UNSIGNED PRI NO 0 MEDIUMINT UNSIGNED

version.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

version <-Back-to:World The `version` table Includes information on current core and database version. Structure Field Type Attributes Key Null Default Extra Comment VARCHAR(120) SIGNED YES NULL Core revision dumped at startup BIGINT UNSIGNED

version_db_auth.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

version_db_auth <-Back-to:Auth The `version_db_auth` table Field Type Attributes Key Null Default Extra Comment VARCHAR(100) SIGNED PRI NO VARCHAR(100) SIGNED MUL YES VARCHAR(50) SIGNED YES BIT(1) SIGNED YES

version_db_characters.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

version_db_characters <-Back-to:Characters The `version_db_characters` table Field Type Attributes Key Null Default Extra Comment VARCHAR(100) SIGNED PRI NO VARCHAR(100) SIGNED YES VARCHAR(50) SIGNED YES BIT(1) SIGNED

version_db_world.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [version_db_world](version_db_world) Column | Type | Description --- | --- | --- Sql_rev | VARCHAR(100) | Required_rev | VARCHAR(100) | 2017_05_01_07 | bit(1) |

vsc-requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

VSC Requirements Installation Guide << Start: Installation Guide Step 2: VSC Core Installation >> Boost ≥ 1.70 - 1.74 MySQL ≥ 5.7.0 OpenSLL ≥ 1.0.x CMake ≥ 3.16 MS Visual Studio Build Tools - Git Extensions * You will need Git installed. You can get the latest version here * Install

warden_action.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

warden_action <-Back-to:Characters The `warden_action` table Structure Field Type Attributes Key Null Default Extra Comment SMALLINT UNSIGNED NO TINYINT UNSIGNED YES Description of the fields wardenid field-no-description|1 action

warden_checks.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

warden_checks Table: warden_checks This table contains data related to the use of the anti-cheat tool Warden, which can be enabled in Worldserver.conf Field Type Attributes Key NULL Default Comment SMALLINT UNSIGNED PRI NO auto_increment

waypoints-information.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

--- redirect_from: “/Waypoints-Information” --- # Waypoints and paths ### Different kinds of waypoint paths - Waypoint paths directly attached to a creature via [creature_addon.path_id](creature_addon#path_id) use the tables [waypoint_data](waypoint_data) and [waypoint_scripts](waypoint_scripts). They can be added and manipulated using the GM '.wp' commands. - [SmartAI](smart_scripts) uses waypoint paths defined in table [waypoints](waypoints). - The table [script_waypoint…

waypoints.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

waypoints <-Back-to:World **Used by [[smart_scripts|SAI]]** Information Contains waypoint data, allowing creatures to move to certain X, Y, and Z coordinates. See also Waypoints-Information for general information about waypoints. Structure Field Type Attributes Key Null Default

waypoint_data.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

waypoint_data <-Back-to:World Information This table contains all the path data for creatures that use waypoints and waypoint scripts directly in their creature addon definition. See also Waypoints-Information for general information about waypoints. Structure Field Type Attributes

waypoint_scripts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

[Database Structure](Database-Structure) > [World-Database](World-Database) > [waypoint_scripts](waypoint_scripts) # waypoint\_scripts ###### Used by [waypoint_data](waypoint_data) ### Information Waypoint paths directly attached to a creature via [creature_addon.path_id](creature_addon#path_id) use the tables [waypoint_data](waypoint_data) and [waypoint_scripts](waypoint_scripts). They can be added and manipulated using the GM '.wp' commands. See also [Waypoints-Informat…

wiki-alerts-and-callouts.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Wiki Alerts and Callouts Alerts Alerts can be added as following. {% raw %} {% include note.html content="Add content between quotes" %} {% include tip.html content="Add content between quotes" %} {% include important.html content="Add content between quotes" %} {% include warning.html content="Add content between quotes" %}

wiki-standards.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

WIKI STANDARDS FILE NAMING: DATABASE TABLES files are to be named exactly as it is in the database, ALL OTHER FILES are to be named in lowercase and to use - (dashes) for spaces. FILES SHOULD NOT contain special characters other than - (dashes). If we want a file named C++ we name it cpp.

windows-core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Windows Core Installation Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 1: Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Pulling & Compiling the source

windows-keeping-the-server-up-to-date.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Windows Keeping the Server Up-to-Date Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 6: Final Server Steps Step 8: Client Setup >> Keeping the source Up-to-Date Open your AzerothCore repository in GitExtensions.

windows-requirements.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Windows Requirements Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Start: Installation Guide Step 2: Core Installation >> {% include callout.html content=“Windows ≥ 10
Boost ≥ 1.78
MySQL ≥ 5.7.0 (Recommended version: ≥ 8.0)
OpenSSL ≥ 3.0.x (Ver. 3.1 and above are not supported.)
CMake ≥ 3.16
MS Visual Studio (Community) ≥ 17 (2022) (Desktop) (No previe…

windows-server-setup.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Windows Server Setup Installation Guide This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps. << Step 2: Core Installation Step 4: Database Installation >> Extracting DBC, Maps, VMaps & MMaps * Browse into your build directory (

windows-vsc-core-installation.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

Windows VSC Core Installation Installation Guide << Step 1: VSC Requirements Step 3: Server Setup >> Required software See Requirements before you continue. Pulling & Compiling the source Pulling the code * Create the directory where the source files will be located. In this guide we will use C:\Azerothcore

worldstates.md

Anonymous (anonymous@undisclosed.example.com) — 2024-03-15T11:08:18+00:00

worldstates <-Back-to:Characters The `worldstates` table This table holds data the Core needs to handle variables (like timer for arena point automatic flush). Structure Field Type Attributes Key Null Default Extra Comment INT UNSIGNED PRI NO 0