diff options
| author | Francesco Borzì <borzifrancesco@gmail.com> | 2021-04-27 13:28:28 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-04-27 13:28:28 +0200 |
| commit | 1904409d0653aaa088a09b47aa710caa1acf99cf (patch) | |
| tree | b0d9476b864872a4e5a210200df1e60607bb7cb5 /docs | |
| parent | 071dfa8052bb3e5c3f533dd629a3427cea96f29d (diff) | |
| download | wiki-1904409d0653aaa088a09b47aa710caa1acf99cf.tar.gz wiki-1904409d0653aaa088a09b47aa710caa1acf99cf.tar.bz2 wiki-1904409d0653aaa088a09b47aa710caa1acf99cf.zip | |
docs: create importing-spell-dbc.md placeholder
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/importing-spell-dbc.md | 18 |
1 files changed, 18 insertions, 0 deletions
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 |
