Azerothcore database structure See quest_template. To enable storing this kind of informations, set Battleground. This table is used to store the tutorial state of all the accounts. guid. This table holds information on quests that should only be available when an event is currently taking place. Table: creature_summon_groups. See guild_bank_tab. The quest ID that the creature starts. The client build. Enable = 1 in worldserver. Table Structure Database Structure. Solid base. id with rewards for first dungeon this day. AzerothCore. spell_group_stack_rules <-Back-to:World. The guild ID who owns the bank. It is the language in which you want to make the translation. Table Structure lotId: id field from auctionhouse table. Contains data about client account and settings. conf and worldserver. This table holds information about when using certain profession spells, you have the chance of creating more than one copy of the item. docker-compose down docker-compose up fixes the problem, but wipes the database (i think the migration script is doing t Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. rank. customChance. Wiki and Documentation of the AzerothCore project Table Structure. If you intend to use an enUS client you can download the data files below. Start worldserver. This table holds information on modifiers for stat values applied to characters. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: Global All the NPC's are stored in the database, for example. guid. This table contains the description of creatures movements, where the creature can move and attack. Structure. If value is 0 then it has not been parsed yet. This is a link to the event entry in the game_event table. An example of app is our db_assembler that is able to create and upgrade your database installation. This in the content of this small dbc Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. paidMoney spell_area <-Back-to:World. Spell ID. 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. Field Type Attributes Key Null Description of the fields. Field Type Key Null Default Extra Comment; ID: MEDIUMINT: PRI: NO: 0: locale: VARCHAR(4) PRI: NO: NULL: MaleText: text: YES: If value is -1 then it is just a place holder until proper data are found on WDBs. hexID:bid:buyout:deposit:cut:delay:eta. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT: UNSIGNED: NO Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. page_text_locale <-Back-to:World. For type 1: achievement ID; for type 2: ACHIEVEMENT_CRITERIA_TYPE Wiki and Documentation of the AzerothCore project This field was used to determine whether the data has been verified from WDB files. Version is : 3. 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. creature_onkill_reputation <-Back-to:World Table Structure. This data along with the object's template data is read and used to instantiate the objects in the world. ID of arena team. field-no-description|1. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT AzerothCore. Wiki and Documentation of the AzerothCore project Pages : Add new Edit This table provides data for spell linking system, telling it which spells trigger what, and under which conditions. Entry. eventEntry. Map. Column Name Type Notes; 1: ID: Integer: 2: Value designates the bitmask used in various places of the core and database (quest_template. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT gm_subsurvey <-Back-to:Characters. dist file. This table holds data about wrapped/gift items. This table holds the percent chances for weather changes to occur in various zones. The `game_event_condition` table. 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. mail_items <-Back-to:Characters This table contains data regarding items from item_instance which are being sent via email. areatrigger_teleport <-Back-to:World. You signed in with another tab or window. Field Type Attributes Key Null Default Extra Comment; ip: VARCHAR(15) SIGNED: PRI: NO: 127. bugfixVersion. Unit tests are located under src/test. This DBC contains Summon Properties (EffectMiscValueB) for Spell Effect SPELL_EFFECT_SUMMON (28) Wiki and Documentation of the AzerothCore project The `item_soulbound_trade_data. Enable a trigger when player enters a city or tavern. You signed out in another tab or window. The GUID of the character. The `character_battleground_data` table. . The GUID of the item bought by the vendor. Field Type Attributes Key Null Default Extra Comment; core_version: VARCHAR(120) SIGNED: YES: NULL: Core revision dumped at startup AzerothCore. The `spell_area` table. Field Type Attributes Key Null Default Extra Comment; ID: MEDIUMINT: UNSIGNED dist. body. Spell custom attributes from the enumeration SpellCustomAttributes in SpellInfo. This is the Group ID for the group. The `lfg_data` table. The `quest_poi_points` table. quest_money_reward <-Back-to:World. TotemCategory. This table holds data about temporary summoned creatures. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly. # DATABASE -> specify database to process, use "" for default ( see in mysql-config ) # METHOD -> 0/1 (0: no fulldb,1: use fulldb) default: ( see in mysql-config ) # CONFIGPATH -> specify alternative path of config file, use "" to check in source folder # mysql-dump utilization: # This script will export all tables from specified db and tables in separated sql files # it can also Wiki and Documentation of the AzerothCore project This table contains data related to the use of the anti-cheat tool Warden, which can be enabled in Worldserver. build. Field Type Attributes Key Null Default Extra Comment; guid AzerothCore. This is just a automatic counter that assigns a value to each trigger to list it. Groups 0-4 are AzerothCore. The `areatrigger_involvedrelation` table. # it can also export the full db in a single sql file. For the purposes of this wiki article, the zone IDs, names, mapID and AreaID will be included. See creature_template. This table is used to complete . The module_string table. majorVersion. # TABLES -> use "" to dump all tables. groupId. The `pool_pool` table. See eventSchedulerType for more info) Description of the fields. item_guid. Starting worldserver for the first time and database was being populated. Enable a trigger to finish one condition of a quest (explore) Table Structure. This table holds information on all the stats regarding the character. Database Structure > World-Database > event_scripts. id. Field Type Attributes Key Null Default Extra Comment; ownerguid AzerothCore. File structure. Please make sure you've executed all queries in the sql/u AzerothCore. The `ip_banned` table. buyout: buyout price of lot Wiki and Documentation of the AzerothCore project How to Import DBC Data onto my Database. This table contains all of the banned IPs and the date when (or if) the ban will expire. game_event_arena_seasons <-Back-to:World. The `quest_money_reward` table. 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. maxlevel. dungeonId. Wiki and Documentation of the AzerothCore project Pages : Add How to Import DBC Data onto my Database. minorVersion. Auth; Characters; World; Overview. alliance_id. Field Type Attributes Key Null Default Extra Comment; dungeonId: INT: UNSIGNED AzerothCore. Translated content for item_template. This table holds all of the strings used internally by the server. 1. Field Type Attributes Key Null Default Extra Comment; pool_id Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This table is used to add a holiday to a battleground, for things like extra reputation / honor. dbc. petition_sign <-Back-to:Characters. Wiki and Documentation of the AzerothCore project Pages : Add Table Structure. AzerothCore is a complete Open Source and Modular solution for MMO development. The date when this achievement was earned. quest_objectives <-Back-to:World. content. id. updates <-Back-to:Auth <-Back-to:Characters Table Structure. This is the pool of pools table. Field Type Attributes Key NULL Default Comment; ID: MEDIUMINT: UNSIGNED: Yes: NO: 0: Type: TINYINT: UNSIGNED: Yes: NO: 0: If value is -1 then it is just a place holder until proper data are found on WDBs. Current Behaviour "ac-authserver" and "ac-worldserver"are crashing and keep restarting after a few hours of runtime. The `player_factionchange_quest` table. It supports the fetching of nesting data from multiple realms, graphql subscriptions (websockets) to implement real-time data, integrated Access Control Layer, user registration and pass recovery system, Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `pool_gameobject` table. The quest ID of the daily quest. The time when the quest was taken, in Unix time. If stationery is 62, body has formatted data:. 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 AreaTable. The `game_event_quest_condition` table. TabId. pool_pool <-Back-to:World. Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × The `account_data` table. This table contains the answers to the survey questions. This table can be overriden by `creature_movement_override` summonproperties_dbc. dbc which is first rank of spell rank chain. entry. Table used for storing custom damage/healing bonus coefficients. The `spelldifficulty_dbc` table. Field Type Attributes Key Null Default Extra Comment AzerothCore. firstQuestId. name field for language X. The `gossip_menu_option_locale` table pool_gameobject <-Back-to:World. Field Type Attributes Key Null Default Description of the fields. Field Type Attribute Key Null Default Extra Comment; CreatureID: MEDIUMINT: UNSIGNED: PRI: NO: School: TINYINT: UNSIGNED: PRI: NO: If value is -1 then it is just a place holder until proper data are found on WDBs. FAQ; Common Errors; Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This table holds info about group members. RequiresClasses etc). However, I cannot find table charsections_dbc in any of the sql files inside sql/updates. This is the alliance Description of the fields. If value is -1 then it is just a place holder until proper data are Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `group_member` table. This table holds info about player's equipment manager settings. ID. dbc column 1. Field Type Attributes Key Null Default Extra Comment; id Wiki and Documentation of the AzerothCore project ☰ AzerothCore Contains all the individual button data for each character. To add new tests, just edit the existing files or create new ones. lfg_dungeon_template <-Back-to:World Table Structure. This table contains the data that a player needs to obtain / complete in order to receive a given achievement. Important: As of 19/09/24 all versions of MariaDB, MySQL 5. 7 and 8. Max length is 8000 characters. achievement_criteria_data; achievement_dbc; achievement_reward; AzerothCore uses a MySQL/MariaDB database server, containing 3 databases: acore_world for the world objects (quests, NPCs, etc. Quest_template. and under which conditions. The `gameobject` table. conf and Your database structure is not up to date. Field Type Table Structure. The `player_factionchange_items` table. or macro as a shortcut. For multirace channels, two (or more) separate entries must exist with the EXACT same settings for all Wiki and Documentation of the AzerothCore project Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. See characters. areatrigger_tavern <-Back-to:World. This table holds threat values on all spells that should either give or take away threat. active. The id of channel. entry to which the script is linked to. This DBC contains material used to display a gossip window for quest or page text. quest_tracker <-Back-to:Character. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT: SIGNED: NO Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close ×. game_event_condition <-Back-to:World. The `character_aura` table. A button is any of the places in the GUI where you can place for example a spell, item, or macro as a shortcut. guildid. 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 `areatrigger_teleport` table. The `summonproperties_dbc` table. They can act in the lifecycle operations of the project such as the CI, the installation of modules, database migration etc. Basically all item changes made when player changes faction. date. See Spell. Field Type Attributes Key Null Default Extra Comment Wiki and Documentation of the AzerothCore project Table Structure. game_event_npcflag <-Back-to:World. mail_server_template <-Back-to:Character. This table holds datas about BattleGrounds scores. See character_pet. Field Type Attributes Key Null Default Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. 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. If the value does not meet the condition the SQL will fail on spell_enchant_proc_data_chk_1. Wiki and Documentation of the AzerothCore project Pages : Add new Edit Table Structure. Acore-Node-Server is a modular nodejs application written in TS/JS that exposes GraphQL and Rest API useful to create any kind of applications based on azerothcore database. 3 Description of the fields. Is the quest ID, obtained from quest_template. SlotId. It is possible to group summons and create boss waves of adds etc. This table contains information for server mail to be sent to players that meet the requirement. The `skill_extra_item_template` table. Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED: NO: 0: character_guid: INT: UNSIGNED: NO: 0: quest_accept_time Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × How to Import DBC Data onto my Database. This information comes from sniffs and is NOT supposed to be changed. This table can only contain gameobjects that have a type of GAMEOBJECT_TYPE_CHEST, GAMEOBJECT_TYPE_GOOBER, GAMEOBJECT_TYPE_FISHINGHOLE. SpellId from Spell. ID) Emote1: SMALLINT: UNSIGNED: NO: 0: If value is -1, it is just a place holder until proper data are found on WDBs. The `spell_threat` table. Field Type Attributes Key Null Default Extra Comment; itemGuid: INT: UNSIGNED: PRI: NO: Item GUID: alowedPlayers: TEXT: Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. This table is used to apply a specific spell aura to the player within an area in the game. What do I need to do in order to finish a quest? Description of the fields. Table: quest_objectives. charsections_dbc' doesn't exist Your database structure is not up to date. 0 or 8. Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED: PRI: NO: 0: Identifier: AzerothCore. Field Type Attributes Key Null Default Extra Comment; dungeonId: INT: UNSIGNED: PRI: NO: 0: This field is used to determine if the data originates from verified sniffs. Field Type Attributes Key Null Default Extra Comments; id: MEDIUMINT: UNSIGNED Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Allow access to channel from specified player faction ID. See localization languages list to know which value to use for X. channelId. The `spell_bonus_data` table. Not all zones can have their weather changed. conf under UPDATE SETTINGS. Value must be >=0. If value is above 0 then it has been parsed with WDB files from that specific client build. areatrigger_involvedrelation <-Back-to:World. event_scripts Information. How to Import DBC Data onto my Database How to Import DBC Data onto my Database. Dungeon ID from LFGDungeons. skill_extra_item_template <-Back-to:World. Field Type Attributes Key Null Default Extra Comment; entry: INT: UNSIGNED: PRI: NO: 0: pool Description of the fields. Column Field Type Notes; 1: ID: Integer: 2: Flags: Integer: 3: FactionID: iRefID: Faction template ID. This entry must be the same as item_template. spell. Holds scripts activated whenever an event is activated, be it by an object or as the spell effect SPELL_EFFECT_SEND_EVENT (61). exe; To edit the automatic database updater you will find the necessary settings in authserver. Reload to refresh your session. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT gameobject <-Back-to:World. Help Description of the fields. spelldifficulty_dbc <-Back-to:World. The `account_tutorial` table. config. Consider upgrading to MySQL 8. update_type. character_battleground_data <-Back-to:Characters. The `gm_subsurvey` table. attributes. procEx Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. arenaTeamId. field-no-description|3. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT Wiki and Documentation of the AzerothCore project Table Structure. conf Table Structure. The instance ID. character_social <-Back-to:Characters Contains data about character's friends/ignored list. This field is from SkillLineCategory. acore_string <-Back-to:World. field-no-description|2. The `spell_learn_spell` table. character_aura <-Back-to:Characters. This field recall a certain map based on the ID (for example, ID 30 recalls Elwynn Forest) Wiki and Documentation of the AzerothCore project character_gifts <-Back-to:Characters. See guild. It must be a unique number. The `skill_discovery_template` table. See game_event_condition. This table contains the mapping of a quest in a world event to the condition that it will fulfill. You can choose from the following: Description of the fields. PageTextMaterial. 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. Table defines if auras in one spell_group can't stack with each other. Field Type Attributes Key Null Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. condition_id. type. data (CMSG_SET_FACTION_INACTIVE) FACTION_FLAG_RIVAL = 0x40, // flag for the two competing outland factions FACTION_FLAG_SPECIAL = 0x80 creature_summon_groups <-Back-to:World. You switched accounts on another tab or window. Boolean 0 or 1 controlling if the player has been bound to the instance. The order in the creation screen depends on this. The text contained in the mail. weekGames. This is the creature_template. Contains all gameobjects instances that participate to any game event. The `page_text_locale` table. angle. The GUID of the player eligible for the refund. entry and then the row will be used to provide localization support for this creature record. creature_template_movement <-Back-to:World. Use "," to separate table names; ex: mysql_dump "" Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × Database World A. The Auth- and You have to look into learning how to edit DBC files and learn their structure, packing MPQ patches and maybe learn Spell Editor. 4. counter. This table is used to provide localized clients with localized string for page_texts. spell_threat <-Back-to:World. This table contains conditions to meet for the specified game event to be completed. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI pvpstats_battlegrounds <-Back-to:Characters. Field Type Attributes Key Null Default Extra Comment; id: MEDIUMINT: UNSIGNED Description of the fields. The ID of the creature. The pet GUID. AreaTable. Maximum distance between group leader and member. To edit the automatic database updater you will find the necessary settings in authserver. h AzerothCore. Field Type Attributes Key Null Default Extra Comment; alliance_id: INT: UNSIGNED: PRI: NO: horde_id: INT: SIGNED: PRI: NO: Description of the fields. By default, the Worldserver and Authserver will check for, and execute all new files into the database you specified in the config. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: Global Unique Identifier: Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × The `character_account_data` table. field-no-description|3 player_race_stats <-Back-to:World. Field Type Attributes Key NULL Default Comment; ID: MEDIUMINT: UNSIGNED: PRI: NO: 0: Unique ID (quest_template. Unit testing at AzerothCore How to compile and run the AC unit tests. team. Enchantment ID from SpellItemEnchantment. realmcharacters <-Back-to:Auth. I'm so sorry Leave blank to dump all tables. dbc file information. The `realmcharacters` table The data in this table is maintained by the core. This DBC contains the zone and subzone lists. ip_banned <-Back-to:Auth. Criteria from Achievement_Criteria. game_event_gameobject_quest <-Back-to:World. Also hold info about their last position before joining the battleground. 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. Modifying a character's stats would generally be in The Auth- and Worldserver checks and applies all needed database files at startup. Field Type Attributes Key Null Default Extra Comment; module: VARCHAR(255) PRI: NO: module dir name, eg mod-cfbg achievement_criteria_data <-Back-to:World. done. guildid. Table Structure Description of the fields. Supported types: 1 - COMPLETE_ACHIEVEMENT; 2 - UPDATE_CRITERIA. module_string <-Back-to:World. You can choose from the following: Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Determains what quest should be changed during a faction change Table Structure. The `areatrigger_tavern` table. Field Type Attributes Key Null Default Extra Comment; Level: MEDIUMINT: UNSIGNED: PRI 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. 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. The `character_stats` table. Indicates how much has been done. When adding entries it is best to just let the database pick the next available ID number quest_poi_points <-Back-to:World. CreatureID. This table holds information of string entries for modules. locale. player_guid. The Modular Structure; Create a script; Hooks Bash; Hooks Cmake; Hooks C++; Help. This table contains the base values for creature health, mana, armor, attack power, ranged Description of the fields CreatureID. Field Type Attributes Key Null Default Extra Comment; accountId: INT: Wiki and Documentation of the AzerothCore project lfg_data <-Back-to:Characters. Utilities and applications with an higher level of awareness compared to modules. Back-to:Spell Effects Reference. conf at SaveRespawnTimeImmediately. You can create a pool with a chance of a range of pools in that pool being activated. name. If you intend to use any other language client you will need to extract the data yourself. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: pool Data files. Back-to:DBC. This table contains saved data for LFG. The slot that the item is placed in in the tab. creature_model_info <-Back-to:World. TabId. Field Type Attributes Key Null Default Extra Comment; group_id: INT: UNSIGNED: PRI Description of the fields. This table holds information on spells that should be learned at the same time a player learns another spell. arg1. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED AzerothCore. The `Game_event_battleground_holiday` table. time. If the value does not meet the condition the SQL will fail on creature_formations_chk_1. Max level at which this reward is rewarded. Player's GUID. Eventually core continued to load, but then got this error: Loading Creat AzerothCore. game_event_quest_condition <-Back-to:World. The `spell_group_stack_rules` table. Contains data about character settings. Name of the channel. The `acore_string` table. skill_discovery_template <-Back-to:World. The tab ID where the item is currently placed in. Field Type Attributes Key Null Default Extra Comment; guid: INT: UNSIGNED: PRI: NO: 0: type: TINYINT: UNSIGNED: PRI: NO: 0: time: INT: Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Similarly, in data/sql/updates there are the updates that our Populating the database. The `creature_model_info` table. 0 Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Please make sure you've executed all queries in the sql/updates folders. Field Type Attributes Key Null Default Extra Comment; reportId: INT: UNSIGNED . The `pvpstats_battlegrounds` table. itemCount: amount of item at this Lot. The character GUID. Contains all the teleport triggers definition. Field Type Attributes Key Null Default Extra Comment; creature_id: MEDIUMINT: UNSIGNED: PRI: NO: 0: Creature Identifier: RewOnKillRepFaction1: SMALLINT: SIGNED: NO: 0: group_member <-Back-to:Characters. The `player_race_stats` table. name_loc. gossip_menu_option_locale <-Back-to:World. player_factionchange_items <-Back-to:World. The `character_gifts` table. The direct corresponding id in creature table or entry in creature_template table. 5a. Number of games played this week. How to Import DBC Data onto my Database. Comes from sniffs. The `game_event_gameobject` table. An additional identifier for each individual entry, enabling multiple equipment for one creature entry. This table contains spell data regarding cpp scripts. Field Type Attributes Key Null Default Extra Comment; name: VARCHAR(200) PRI: NO: Filename with extension of the update. This table controls the so called "discovery" system of learning spells. This table holds information for each character in a battleground. criteria. entry. The quest ID of the rewarded quest. Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Field Type Attributes Key Null Default Extra Comment; guildid: INT: UNSIGNED: PRI: NO: Guild account_tutorial <-Back-to:Characters. Field Type Attributes Key NULL Default Comment; ID: MEDIUMINT: UNSIGNED: PRI: NO: 0: EmoteOnComplete: SMALLINT: UNSIGNED: NO: 0: EmoteOnIncomplete: SMALLINT: If value is -1, it is just a place holder until proper data are found on WDBs. This table enables dynamically rewarding money dependent on player's level. ) you probably don't want to backup this IMPORTANT: Make sure only the mysql database is open when you export/import your characters or guild! Trying to export/import while the auth/world server is running can lead character_equipmentsets <-Back-to:Characters. This table stores information about which players can trade soulbound items between each other. permanent. The `quest_tracker` table. version <-Back-to:World Includes information on current core and database version. game_event_battleground_holiday <-Back-to:World. This table provides answer for a very important question. Field Type Attributes Key Null Default Extra Comment; spell_id: MEDIUMINT Description of the fields. See more In data/sql/base there are the files to create the base structure & contents for the 3 database (world, auth and characters). The \lag\_reports\ table. bid: ending bid for this lot. hexID: hex value of itemowner's GUID (guid field from characters table). This table stores the lag reports made by players ingame (when they click on "Help Request"). id AzerothCore. Description of the fields. Column Field Type Notes; 1: ID: Integer: 2: reputationIndex: Integer: state stored in characters. The spell ID. Field Description of the fields. This DBC contains the maps list. Column Field Type Notes; 1: ID: Integer: 2: InternalName: String: reference to World\Map\ [] \ 3: Flags: Integer: 0x100 Description of the fields. This table holds the individual object data on each spawned game object in the world. spell_bonus_data <-Back-to:World. The character guid. It identifies the whole chain. See [arena_team#arenateamid]. StoreStatistics. 4: Exploration: Description of the fields. How often the re-spawn time is saved for game objects can be controlled in trinitycore. first_spell_id. AzerothCore has a solid base from years of development: it is based on MaNGOS, TrinityCore, and SunwellCore. All of the values in this table signify only the stat value modifiers based on the race of a character. The `game_event_npcflag` table. An integer which ranks the spell within the chain of spell ranks for the given `spell_id`. character_stats <-Back-to:Characters. It's linked to gm_survey. Data files enUS (AC Data v16) Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Table Structure Wiki and Documentation of the AzerothCore project ☰ AzerothCore Close × How to Import DBC Data onto my Database. Wiki and Documentation of the AzerothCore project Pages : Add new Edit this table holds the re-spawn data so that the game objects don't re-spawn immediately on server restart. hash: CHAR(40) YES '' SHA1 hash of the sql file. Angle between leader and member Note: Only degrees are used! Description of the fields. game_event_gameobject <-Back-to:World. The formula for it is: Value = 1 << (ID CategoryId. The `character_equipmentsets` table. Field Type Attributes Key NULL Default Comment; id: SMALLINT: UNSIGNED: PRI: NO: auto_increment: Unique ID, automatically incremented by 1: type: Wiki and Documentation of the AzerothCore project Table Structure. For any given zone the percentage of all weather types for each season should total, and not exceed 100%. 1 will no longer be supported. Field Type Attributes Key Null Default Extra Comment; spellId: MEDIUMINT Wiki and Documentation of the AzerothCore project. Table Structure Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. Boolean 0 or 1 controlling if the spell is active or not. Field Type Attributes Key Null Default Extra Comment; eventEntry: TINYINT Automatic Database Updater. field-no-description|4 Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. The `achievement_criteria_data` table. This table contains gameobjects that are tied to a specific pool. spell_id. See instance. Field Type Attributes Key Null Default Extra Comment; realmid: INT: UNSIGNED: PRI: NO: 0: acctid: INT: UNSIGNED: PRI: NO: Current Behaviour Fresh compile of core on Linux. You have to compile your core by passing -DBUILD_TESTING=1 in your cmake command. condition_id. PPMChance. The `game_event_gameobject_quest` table. quest. 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. This table contains all models of mobs, their gender and other information that are model related. The `petition_sign` table. Field Type Description of the fields. player_factionchange_quest <-Back-to:World. 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. 3. Field Type Attributes Key Null Default Extra Comment; mail_id: INT: UNSIGNED: NO: 0: item_guid: INT Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. weekWins Wiki and Documentation of the AzerothCore project Pages : Add new Edit Delete History Source. If you want to know how the SQL directory works or plan to have custom changes we recommend you read this. This table is constantly in use by the core. lag_reports <-Back-to:Characters. GroupID. The `mail_server_template` table. Database Structure > World AzerothCore. Automatic Database Updater. See item_instance. spell_learn_spell <-Back-to:World. The `game_event_arena_seasons` table. instance. Table Structure. This table holds information on all the signatures of a petition for either a guild or an arena team. Field Type Attributes Key Null Default Extra Comment; spell_trigger: MEDIUMINT: SIGNED: NO When starting world server, it reports [1146] Table 'acore_world. Field Type Attributes Key Null Default Extra Comment; entry: MEDIUMINT: UNSIGNED: PRI: NO: 0: content Wiki and Documentation of the AzerothCore project AzerothCore.
tkoif ytmozy otnpcbx pmabe iawku wtcthc ynqlj ake bqcv snqq