From 1904409d0653aaa088a09b47aa710caa1acf99cf Mon Sep 17 00:00:00 2001 From: Francesco Borzì Date: Tue, 27 Apr 2021 13:28:28 +0200 Subject: docs: create importing-spell-dbc.md placeholder --- docs/importing-spell-dbc.md | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 docs/importing-spell-dbc.md (limited to 'docs') diff --git a/docs/importing-spell-dbc.md b/docs/importing-spell-dbc.md new file mode 100644 index 0000000..ce5be91 --- /dev/null +++ b/docs/importing-spell-dbc.md @@ -0,0 +1,18 @@ +# Importing data to the spell_dbc table + +## Introduction + +The [spell_dbc](spell_dbc.md) 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. + +In order to add overrides for a spell in the `spell_dbc` table, you first need to import the base data about that spell from the Client DBC files (unless that spell has already been imported). + +There are around 50k spells in the Client DBC files, you can import one spell or the whole set to the `spell_dbc` table of your local AC database in order to be able to work on them and add your overrides. + +When you import the spell from the DBC, you'll get an `INSERT IGNORE` query with all the default values. Save this query somewhere, you'll need it to submit your PR fix. +After you have imported the spell(s), you can use tools such as [Keira3](https://www.azerothcore.org/Keira3/) to easily get the `UPDATE` query containing your overrides. + +When submitting a PR with a `spell_dbc` fix for a certain spell, if that spell was not present in the `spell_dbc` table before, you have to include both the `INSERT IGNORE` and the `UPDATE` query in your PR. + +## How to import spells from the DBC files to the spell_dbc table + +TODO -- cgit