Azerothcore database structure. Please make sure you've executed all queries in the sql/u.

Azerothcore database structure The `npc_text_locale` table. See instance. If Level is set to -1, the player's level will be used as (Quest)Level for the experience calculation. Field Type Attributes Key Null Default Extra Comment; spell_id: MEDIUMINT player_race_stats <-Back-to:World. The `quest_money_reward` table. The `skill_discovery_template` table. Field Type Attributes Key Null Default Extra Comment; id: BIGINT: UNSIGNED: PRI: NO: 0 [creator][2] INT: UNSIGNED: NO: 0: title: VARCHAR(255) SIGNED Description of the fields. This table controls the so called "discovery" system of learning spells. TotemCategory. The `arena_team` table. The `graveyard_zone` table. Field Type Attributes Key Null Default Extra Comment; name: VARCHAR(200) PRI: NO: Filename with extension of the update. This table holds the respawn time when creatures should be respawned in the world. dbc. Determains what quest should be changed during a faction change Table Structure. Contains data about client account and settings. Column Name Type Notes; 1: ID: Integer: 2: Unknown: Integer: 1 for Hunter, Rogue, and Shaman, 9 for CategoryId. This table holds information on all the stats regarding the character. item_set_names_locale <-Back-to:World. The `achievement_criteria_data` table. entry / gossip_menu_option. How to Import DBC Data onto my Database. Field Type Attributes Key Null Default Extra Comment; spell_id: INT: SIGNED: UNIQUE: NO: NONE: ScriptName: char(64) UNSIGNED: UNIQUE: NO: NONE: Description of the fields. menu_id) to link to to create that sub-menu. This DBC contains material used to display a gossip window for quest or page text. npcflag that the NPC must have to have this option display. It is the language in which you want to make the translation. All created teams or all teams in the process of being created have a record in this table. All SQL changes you make to fix an issue on AzerothCore go in here. The user's account name. hexID:bid:buyout:deposit:cut:delay:eta. Database Structure > World-Database > event_scripts. username. See quest_template. In Populating the database. Index. The `creature_model_info` table. See characters. FactionTemplate. Contains individual creature spawn data for each individual spawn of each individual creature in the game world. The `acore_string` table. GroupID. This table holds the main ArenaTeam information. 3. See above. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. button. . The `spell_proc` table. This DBC contains all possible player classes. Field Type Attributes Key Null Default Extra Comment; realmid: INT: SIGNED: PRI: NO: text: LONGTEXT: YES: NULL: Description of the fields realmid. AzerothCore is a complete Open Source and Modular solution for MMO development. Holds scripts activated whenever an event is activated, be it by an object or as the spell effect SPELL_EFFECT_SEND_EVENT (61). Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED: NO: 0: character_guid: INT: UNSIGNED: NO: 0: quest_accept_time areatrigger_teleport <-Back-to:World. The advantage of having an external script to do this task instead of the worldserver is: You don't need to compile and run the worldserver if you only need to create the database (useful when using or developing tools that only need the DBs) AzerothCore. All of the values in this table signify only the stat value modifiers based on the race of a character. field-no-description|3 Wiki and Documentation of the AzerothCore project Description of the fields. Value must be within this range. The `spell_learn_spell` table. maxgold. time. Keeping the Database Up-to-Date. This table is used to provide localized clients with localized string for page_texts. This entry must be the same as item_template. spell_linked_spell <-Back-to:World. The `motd` table. spec. Table Structure DELETE FROM `quest_template_locale` WHERE `ID` = 62 AND `locale` = "esES"; INSERT INTO `quest_template_locale` (`ID`, `locale`, `Title`, `Details`, `Objectives`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES (62, "esES", "La Mina Abisal", "¡La mina de Villanorte no es la única que tiene problemas! ! Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. realmid. SourceGroup. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: pool AzerothCore. Specify account pvpstats_battlegrounds <-Back-to:Characters. table-no-description Table Structure. The instance ID. The current quest status. You can create a pool with a chance of a range of pools in that pool being activated. build. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED Description of the fields racemask. id. Rank of the skill. Field Type Attributes Key Null Default Extra Comment; Id: INT: UNSIGNED: PRI: NO: AUTO_INCREMENT: type: TINYINT: UNSIGNED: NO: 0: 0 open, 1 closed, 2 character deleted: playerGuid: INT: UNSIGNED: NO: 0: (not implemented on azerothcore yet) 0 = player who abandoned ticket or GM who closed ticket. You can always find them here. Field Type Attributes Key Null Default Extra Comment; ID: MEDIUMINT: UNSIGNED Description of the fields. worldstates <-Back-to:Characters. PageTextMaterial. reportId. dbc How to Import DBC Data onto my Database. This is the creature_template. Field Nb Name Type; 1: ID: Int: 2: Name (Ref to Faction. Boolean 1 or 0 signifying whether the spell is active (appears in the spell book). See account. Level of quest. pool_pool <-Back-to:World. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED: PRI: NO: 0: name_loc1: VARCHAR(100) SIGNED: NO: name Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Maximum money, in copper, that the gameobject can drop when accessed / used. Compile downloaded source as explained in Windows Core Installation. See item_template. If you are still having problems, check: FAQ. verifier Description of the fields. id Description of the fields. spec = 0 is the first spec, spec = 1 is the second spec. Create three empty databases: acore_world; acore_characters; acore_auth; Importing the SQL files. How to ask for help. ElseGroup. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: achievement: SMALLINT: UNSIGNED: PRI: NO: Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. See more Creating the databases. hash: CHAR(40) YES '' SHA1 hash of the sql file. acore_string <-Back-to:World. field-no-description|3. The SQL files are located under /data/sql/ directory. This table holds information on what events (or procs) certain spells are activated. The ID of the spell to link. guild_bank_item <-Back-to:Characters. guid. alliance_id. If the spell was casted from an item, the item ID. Report ID. dbc which is first rank of spell rank chain. spelldifficulty_dbc <-Back-to:World. player_factionchange_quest <-Back-to:World. The values from this table are combined with the values found in the player\_race\_stats table to apply the final stats to a character at any level. The name of the character. name field for language X. Description of the fields CreatureID. counter. mingold. Database Keeping the Server Up-to-Date. It is possible to group summons and create boss waves of adds etc. The `spell_linked_spell` table. dbc file information. instance. Azerothcore is designed in such a way that you can also edit the values of skills and abilities (collectively called 'spells' in the field) but adding a new ability has to be done both in the code and in AzerothCore. The `spelldifficulty_dbc` table. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: Global AzerothCore developers and contributors are always working on fixing and adding new features to the core. game_event <-Back-to:World. This table contains all models of mobs, their gender and other information that are model related. Field Type Attributes Key Null Default Extra Comment; Level: MEDIUMINT: UNSIGNED: PRI Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Table Structure. Table Structure Table Structure. Consider upgrading to MySQL 8. majorVersion. An example of app is our db_assembler that is able to create and upgrade your database installation. Rank. Linux Keeping the Server Up-to-Date. This table holds This will sync your local repo to the latest commits from the azerothcore-wotlk repository. character_aura <-Back-to:Characters. The `player_factionchange_quest` table. The account security level. The `areatrigger_tavern` table. 1. This is a collection of notes aiming to explain the internals of Keira3 for development purposes. If the value does not meet the condition the SQL will fail on creature_formations_chk_1. The `character_account_data` table. This is the alliance Wiki and Documentation of the AzerothCore project Wiki and Documentation of the AzerothCore project AzerothCore. Table used for storing custom spell attributes. racemask. This information comes from sniffs and is NOT supposed to be changed. salt is a cryptographically random 32-byte value. To edit the automatic database updater you will find the necessary settings in authserver. content. creature_model_info <-Back-to:World. specMask. Windows Keeping the Server Up-to-Date. See Spell. ChrClasses. Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED: PRI: NO: This is an auto increment field and this is an arbitrary number. The GUID of the character. Column Field Type Notes; 1: ID: Integer: 2: InternalName: String: reference to World\Map\ [] \ 3: Flags: Integer: 0x100 character_equipmentsets <-Back-to:Characters. Please make sure you've executed all queries in the sql/u Wiki and Documentation of the AzerothCore project How to Import DBC Data onto my Database. Field Type Attributes Key Null Default Extra Comments; id: MEDIUMINT: UNSIGNED Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × Note: if you delete a "realm first" achievement from the characters database, Table Structure. Keira3 Internals. groupId. config. Field Type Table Structure. The `summonproperties_dbc` table. The module_string table. Field Type Attributes Key Null Default Extra Comment; alliance_id: INT: UNSIGNED: PRI: NO: horde_id: INT: SIGNED: PRI: NO: Description of the fields. The `character_skills` table. calendar_events <-Back-to:Characters. The quest ID of the rewarded quest. 5a. The template ID of the game object. salt. This table is used to apply a specific spell aura to the player within an area in the game. This is the pool of pools table. This table holds data the Core needs to handle variables (like timer for arena point automatic flush). Files Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This table holds all of the strings used internally by the server. dbc) Int: 4: ourMask: Bitmask (4 bits) 5: friendlyMask: Bitmask (4 bits) 6 Description of the fields. sql' account_data <-Back-to:Characters. The group is met when all of its entries are met AzerothCore. The unique account ID. Database Structure. spell_proc <-Back-to:World. See realmlist. quest_money_reward <-Back-to:World. version <-Back-to:World Includes information on current core and database version. Field Type Attributes Key Null Default Extra Comment; spell_id: MEDIUMINT: UNSIGNED: PRI: NO: 0: spell id: attributes Description of the fields. All factions that you can not gain rep with have -1. Each database has a table I've created a tool to extract SQL from DBCs. Field Type Attributes Key Null Default Extra Comment; dungeonId: INT: UNSIGNED: PRI: NO: 0: Dungeon entry from dbc: maxlevel: TINYINT graveyard_zone <-Back-to:World. Table Structure groups <-Back-to:Characters. Angle between leader and member Note: Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This table is used to complete . Max length is 8000 characters. Map. warden_checks <-Back-to:World. assignedTo. If above or under the SQL will fail on creature_template_spell_chk_1. Field Type Attributes Key Null Default Extra Comment; entry: INT Wiki and Documentation of the AzerothCore project. quest_tracker <-Back-to:Character. For type 1: achievement ID; for type 2: ACHIEVEMENT_CRITERIA_TYPE Wiki and Documentation of the AzerothCore project Table Structure. What do I need to do in order to finish a quest? ACore-Node-Server uses a set of libraries and strategies to automate the creation of GraphQL APIs for the AzerothCore database. minorVersion. This table holds the percent chances for weather changes to occur in various zones. This field is from SkillLineCategory. 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. quest_objectives <-Back-to:World. spell_bonus_data <-Back-to:World. Minimum money, in copper, that the gameobject can drop when accessed / used. Column Field Type Notes; 1: ID: Integer: 2-18: sRefName: String + Loc: Includes all Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Not all zones can have their weather changed. This table contains the data that a player needs to obtain / complete in order to receive a given achievement. AzerothCore. Utilities and applications with an higher level of awareness compared to modules. Wiki and Documentation of the AzerothCore project Pages : Add Table Structure. lotId: id field from auctionhouse table. creature_respawn <-Back-to:Characters. The text contained in the mail. This table holds datas about BattleGrounds scores. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly. Solid base. This is the Group ID for the group. Back-to:DBC. id in the auth database. achievement_reward_locale <-Back-to:World. This table contains the mapping of a quest in a world event to the condition that it will fulfill. Field Type Attributes Key Null Default Extra Comment; Description of the fields. Field Type Attributes Key Null Default Extra Comment; dungeonId: INT: UNSIGNED Description of the fields. entry. Field Type Attributes Key Null Default Extra Comment; Guid: INT: UNSIGNED: PRI Description of the fields. conf and Based on our modular domain-based directory structure , the AzerothCore project allows you to add and extend game features by adding custom isolated modules, without patching the core Your database structure is not up to date. table-no-description|0 Table Structure. An additional identifier for each individual entry, enabling multiple equipment for one creature entry. The `pool_pool` table. acctid. macOS Keeping the Server Up-to-Date. You can choose from the following: QuestLevel. character_stats <-Back-to:Characters. Field Type Attributes Key Null Default Extra Comment; module: VARCHAR(255) PRI: NO: module dir name, eg mod-cfbg AzerothCore. The Modular Structure; Create a script; Hooks Bash; Hooks Cmake; Hooks C++; Help. Field Type Attributes Key Null Default Extra Comment; alliance_id: INT: UNSIGNED Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. NOTE: usernames are limited to 20 characters and have no character restriction. Common Errors. locale. The `quest_tracker` table. This table holds all item information for items that are stored in the guild bank. Field Type Attributes Key NULL Default Comment; id character_account_data <-Back-to:Characters. Is the quest ID, obtained from quest_template. However, I cannot find table charsections_dbc in any of the You have to look into learning how to edit DBC files and learn their structure, packing MPQ patches and maybe learn Spell Editor. This table holds a listing of all skill for each character. I saw this error: Applying 'creature_template_model. If you want to know how the SQL directory works or plan to have custom changes we recommend you read this. Custom files Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Field Type Attributes Key Null Default Extra Comment; pool_id summonproperties_dbc. Help AzerothCore. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: Global dist. The `spell_area` table. achievement_criteria_data <-Back-to:World. Character guid. Player receives full experience amount only if their level is less than or equal to Level+5. Column Field Type Notes; 1: ID: Integer: Criteria ID: 2: Achievement: iRefID: Reference to the achievement this criteria is needed for. instance_template <-Back-to:World. This table contains gameobjects that are tied to a specific pool. See gameobject_template. Enable a trigger when player enters a city or tavern. If above or under the SQL will fail on creature_template_resistance_chk_1. field-no-description|4 Description of the fields. AzerothCore CHANGED it's database-structure to resemble TrinityCore to remove issues with tool compatibility, and ease development of additional tools, basically standardisation so that we aren't working on two completely different server options, with Description of the fields. motd <-Back-to:Auth. See ChrClasses. Table Structure All the NPC's are stored in the database, for example. body. The individual level required for a command is defined in the command table in each realm. character_skills <-Back-to:Characters. name. An integer which ranks the spell within the chain of spell ranks for the given `spell_id`. item. Join our Discord Server, but it is not a 24/7 support channel. The `character_stats` table. This table can only contain gameobjects that have a type of GAMEOBJECT_TYPE_CHEST, GAMEOBJECT_TYPE_GOOBER, GAMEOBJECT_TYPE_FISHINGHOLE. Field Type Attributes Key Null Default Extra Comment; SpellId: INT: SIGNED: PRI: NO: 0: Unique Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Field Type Attributes Key Null Default AzerothCore. This table holds threat values on all spells that should either give or take away threat. The `achievement_reward_locale` table. Table: creature_summon_groups. The direct corresponding id in creature table or entry in creature_template table. Auth; Characters; World; Overview. See localization languages list to know which value to use for X. The `character_equipmentsets` table. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED: PRI: NO: 0: content Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. 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. Field Type Attributes Key Null Default Extra Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. conf Table Structure. The `item_set_names_locale` table. The `broadcast_text_locale` table This table will have localized texts for `broadcast_text` table. Creature entry from creature_template. 5 Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `creature_respawn` table. sln) files. areatrigger_involvedrelation <-Back-to:World. classmask. The account ID. Supported types: 1 - COMPLETE_ACHIEVEMENT; 2 - UPDATE_CRITERIA. This field recall a certain map based on the ID (for example, ID 30 recalls Elwynn Forest) pool_gameobject <-Back-to:World. The `pool_gameobject` table. StoreStatistics. criteria. The quest ID. update_type. It identifies the whole chain. date. Table Structure Description of the fields. Version 3. Please make sure you've executed all queries in the sql/updates folders. dbc column 1. This table enables dynamically rewarding money dependent on player's level. One or more character's class. Criteria from Achievement_Criteria. Read Database Keeping the Server Up-to-Date. The `game_event_arena_seasons` table. This is the npcflag (Creature_template. Important: As of 19/09/24 all versions of MariaDB, MySQL 5. This table holds data about temporary summoned creatures. arg1. SourceEntry. Column Field Type Notes; 1: ID: Integer: 2: Flags: Integer Description of the fields. If it is negative and the first rank of Description of the fields. This table contains the base values for creature health, mana, armor, attack power, ranged AzerothCore. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT OptionNpcFlag. Field Type Attributes Key Null Default Extra Comment; ID: MEDIUMINT: UNSIGNED: PRI . spell_id. Reload to refresh your session. I thought that running worldserver with the default settings for the database autoupdater would ensure the world database was created and updated properly. Skill id. Spell. This table provides data for spell linking system, telling it which spells trigger what, and under which conditions. ID. quest_poi_points <-Back-to:World. itemCount: amount of item at this Lot. id. bid: ending bid for this lot. If you are still having problems, check: FAQ AzerothCore. The time when the spell cooldown will Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Wiki and Documentation of the AzerothCore project Table Structure. 0 or 8. Different levels have access to different commands. lagType. SpellId from Spell. See ChrRaces. Index 0 - 7. If there is more than one of the same entry (more than one text the creature says), this column is used to choose if it is a random say or an ordered list. spell_custom_attr <-Back-to:World. Modifying a character's stats would generally be in Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × Database World A. For any given zone the percentage of all weather types for each season should total, and not exceed 100%. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI Wiki and Documentation of the AzerothCore project Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `areatrigger_teleport` table. Contains information about zones connected to world's graveyards. spell. Used in gossips, creature texts and npc_texts. A staff member will Wiki and Documentation of the AzerothCore project Database Squash; DBC Index; Directory structure; Doxygen Documentation; Exit Codes; GM Commands; How to Debug and Restart; Extend AzerothCore. The ID of the button on the action bar where the action icon will be placed. Pending update files. entry. 4. permanent. The `quest_poi_points` table. entry and then the row will be used to provide localization support for this creature record. This table contains data related to the use of the anti-cheat tool Warden, which can be enabled in Worldserver. The `instance_template` table. Boolean 0 or 1 controlling if the player has been bound to the instance. Field Type Attributes Key Null Default Extra Comment; roupId: INT: UNSIGNED: PRI: NO: NULL: roupName: VARCHAR(100) NO: NULL: roupFlags: INT: UNSIGNED: NO: 0: Description of the fields. This table holds info about player's equipment manager settings. charsections_dbc' doesn't exist Your database structure is not up to date. Contains data about character settings. 1 will no longer be supported. Automatic Database Updater. The `account_tutorial` table. FAQ; Common Errors; Description of the fields id. Column Field Type Notes Extra info; 0: eventID: Integer: Holiday event ID: 1: eventStage1Duration: Integer: Stage1 event length (for stage1: either as preparation or main event. The quest ID that this game object starts. spell_threat <-Back-to:World. This DBC contains most information on all spells. field-no-description|2. Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close ×. Column Field Type Notes; 1: ID: Integer: 2: reputationIndex: Integer: Each faction that has gainable rep has a unique number. Table: quest_objectives. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED: PRI Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Basically a comment of what your query does. 3 Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Its purpose is (will be) used as a globalized table containing the localized texts as mentionned above. This DBC contains the maps list. Structure. Wiki and Documentation of the AzerothCore project Pages : Add new Edit Table Structure. Back-to:Spell Effects Reference. This table has all the templates for every instance. Now you will need to re-run CMake Configure and Generate to update your solution (. Field Type Attributes Key Null Default Extra Comment; guildid: INT: UNSIGNED: PRI Description of the fields. Translated content for item_template. AzerothCore has a solid base from years of development: it is based on MaNGOS, TrinityCore, and SunwellCore. These values are used by the core and a few spell_* tables. You switched accounts on another tab or window. This table alone does not define the stats of a character at any level. Table Structure Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Primary Key for this table. Max length is 12 characters. Field Type Attributes Key Null Default Extra Comment; core_version: VARCHAR(120) SIGNED: YES: NULL: Core revision dumped at startup When starting world server, it reports [1146] Table 'acore_world. guid. The `warden_checks` table. In AzerothCore this task is a responsability of an external script, written in bash, the DB-assembler. Field Type Attributes Key Null Default Extra Comment; Id: INT: UNSIGNED: PRI: NO Relation to `player_race_stats`. dist file. 3: reputationRaceMask: Description of the fields CreatureID. Note. name_loc. creature <-Back-to:World. module_string <-Back-to:World. This in the content of this small dbc Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `spell_custom_attr` table. achievement_criteria_data; achievement_dbc; achievement_reward; AzerothCore has three databases: auth, characters and world. Entry. RealmID PageTextMaterial. 0 = Loot related; 1 = Auction House related; 2 = Mail related; 3 = Chat related arena_team <-Back-to:Characters. The `worldstates` table. The `character_aura` table. The date when this achievement was earned. Spell id. This table provides answer for a very important question. You signed in with another tab or window. The `calendar_events` table. 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. The ID of the realm. This DBC contains all possible races, some of which are unused and unavailable to players. All pending update files are found in the $\data\sql\updates\pending_db_*\ directory. How to Import DBC Data onto my Database How to Import DBC Data onto my Database. They can act in the lifecycle operations of the project such as the CI, the installation of modules, database migration etc. sh script. Allows building grouped conditions - all entries belonging to the same condition (same SourceType, SourceGroup and SourceEntry) that share the same number in ElseGroup, define one group. It's maintained by us so we can properly set the schema needed for the AzerothCore database Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × How to Import DBC Data onto my Database. You create the pending update file by running create_sql. spell_learn_spell <-Back-to:World. The `account_data` table. If stationery is 62, body has formatted data:. event_scripts Information. 7 and 8. When adding entries it is best to just let the database pick the next available ID number account_tutorial <-Back-to:Characters. The Auth- and The Auth- and Worldserver checks and applies all needed database files at startup. If you want to create a sub-menu, this is the ID (gossip_menu. first_spell_id. broadcast_text_locale. Help. This table contains spell data regarding cpp scripts. Field Type Attributes Key Null Default Extra Comment Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × Table Structure. The `areatrigger_involvedrelation` table. buyout: buyout price of lot AzerothCore. The `spell_threat` table. Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED: PRI: NO: 0: Identifier: game_event_quest_condition <-Back-to:World. hexID: hex value of itemowner's GUID (guid field from characters table). This table holds basic info about groups. The `spell_bonus_data` table. The character guid. game_event_arena_seasons <-Back-to:World. Enable = 1 in worldserver. Table used for storing custom damage/healing bonus coefficients. field-no-description|1. The `lfg_dungeon_encounters` table. 3: Type: Integer: AzerothCore. To enable storing this kind of informations, set Battleground. See eventSchedulerType for more info) creature_summon_groups <-Back-to:World. Field Type Attributes Key Null Default Extra Comment; spellId: MEDIUMINT spell_area <-Back-to:World. The `player_race_stats` table. This DBC contains Summon Properties (EffectMiscValueB) for Spell Effect SPELL_EFFECT_SUMMON (28) Wiki and Documentation of the AzerothCore project Table Structure. lfg_dungeon_rewards <-Back-to:World. Database Structure > World Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. bugfixVersion. It must be a unique number. The way the final stat can be calculated is as follows: Take the base stat from this table and add the modifier for that stat from player Table Structure. School. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT Spell. The `guild_bank_item` table. updates <-Back-to:Auth <-Back-to:Characters Table Structure. This table holds definitions for all game events that are activated or deactivated automatically by the Game Event System in the core. The client build. numchars. Each quest ID must be unique. Quest ID for quests showing a completion text upon turning in an item delivery quest. 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. This table is used to provide localized clients with localized string for npc_texts. The `groups` table. page_text_locale <-Back-to:World. entry to which the script is linked to. I dropped the world database, then used dbimport. quest. This table is used to store the tutorial state of all the accounts. The `game_event_quest_condition` table. One or more character's race. Description of the fields. It allows you to export only the rows you need. This table holds information on spells that should be learned at the same time a player learns another spell. Maximum distance between group leader and member. ActionPoiID Files from this directory are automatically imported with the Automatic Database Updater. angle. race. Version is : 3. Possible values Description of the fields. Value must be >=0. npc_text_locale <-Back-to:World. type. status. [SPELLS] why they must be stored and maintained in database (almost all of them) I have been reading many discussions about DBCs and spells with a lot of misunderstanding here and there. The entire condition is met when any of its groups is met (logical OR). See Skill. This table holds information of string entries for modules. All of them need to be properly up to date in order to start the server application. This table holds information on modifiers for stat values applied to characters. The `page_text_locale` table. The `game_event` table. Comes from sniffs. Field Type Attributes Key Null Default Extra Comment Keeping the Database Up-to-Date. So I would like to open this topic by trying to collect all the information we gained so fa Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. You signed out in another tab or window. The `spell_dbc` table. Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. skill_discovery_template <-Back-to:World. The `pvpstats_battlegrounds` table. CreatureID. Contains all the teleport triggers definition. ChrRaces. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: Unique: Global Unique Identifier: See account. When a group enters an instance, a new copy of that instance is made from the values in these fields. spell_dbc <-Back-to:World. See comments (after //) in previous table) ActionMenuID. This table is used to set what factions a given graveyard will accept, and also to specify the nearest graveyard to a given zone. The number of characters the account has on the realm. The current flow is composed by 2 + 1 (optional) different steps: Directory structure /src /database -> sequelize models + seeders /logic -> RealmMgr, adapters, entities & APIs /service -> apollo, express and AzerothCore. Groups 0-4 are Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This is just a automatic counter that assigns a value to each trigger to list it. The spell ID. rank. Enable a trigger to finish one condition of a quest (explore) Table Structure. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED: PRI: NO: 0: direct Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × How to Import DBC Data onto my Database. gmlevel. areatrigger_tavern <-Back-to:World. This table contains data regarding serverside spells which are not to be found in Client DBC files. ciste tpmar bliyps ltauqb xixkaeyk zxtu ees feiw qocqvp epd