From 0f16b4a19598ef6835285201addd8136caa023b8 Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Sun, 21 Mar 2021 15:32:39 +0100 Subject: chore(c_t): Add c_t_r & c_t_s (#392) * chore(c_t): Add c_t_r & c_t_s * fix table * Update creature_template_resistance.md * Update creature_template_resistance.md * Update creature_template_spell.md --- docs/creature_template.md | 30 -------------------- docs/creature_template_resistance.md | 54 ++++++++++++++++++++++++++++++++++++ docs/creature_template_spell.md | 49 ++++++++++++++++++++++++++++++++ docs/database-world.md | 2 ++ 4 files changed, 105 insertions(+), 30 deletions(-) create mode 100644 docs/creature_template_resistance.md create mode 100644 docs/creature_template_spell.md (limited to 'docs') diff --git a/docs/creature_template.md b/docs/creature_template.md index e48a861..6e1a49a 100644 --- a/docs/creature_template.md +++ b/docs/creature_template.md @@ -50,20 +50,6 @@ This table contains the description of creatures. Each spawned creature is an in | [lootid](#lootid) | mediumint(8) unsigned | NO | | 0 | | | | [pickpocketloot](#pickpocketloot) | mediumint(8) unsigned | NO | | 0 | | | | [skinloot](#skinloot) | mediumint(8) unsigned | NO | | 0 | | | -| [resistance1](#resistancex) | smallint(6) | NO | | 0 | | | -| [resistance2](#resistancex) | smallint(6) | NO | | 0 | | | -| [resistance3](#resistancex) | smallint(6) | NO | | 0 | | | -| [resistance4](#resistancex) | smallint(6) | NO | | 0 | | | -| [resistance5](#resistancex) | smallint(6) | NO | | 0 | | | -| [resistance6](#resistancex) | smallint(6) | NO | | 0 | | | -| [spell1](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell2](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell3](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell4](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell5](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell6](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell7](#spellx) | mediumint(8) unsigned | NO | | 0 | | | -| [spell8](#spellx) | mediumint(8) unsigned | NO | | 0 | | | | [PetSpellDataId](#petspelldataid) | mediumint(8) unsigned | NO | | 0 | | | | [VehicleId](#vehicleid) | mediumint(8) unsigned | NO | | 0 | | | | [mingold](#mingold) | mediumint(8) unsigned | NO | | 0 | | | @@ -511,22 +497,6 @@ The ID of the pickpocketing loot template that this creature should use to gener The ID of the skinning loot template that this creature should use to generate skinning loots. See [skinning_loot_template.entry](http://www.azerothcore.org/wiki/loot_template#loot_template-Entry) -**resistancex** - -| resistancex | school | -|-------------|--------| -| 1 | Holy | -| 2 | Fire | -| 3 | Nature | -| 4 | Frost | -| 5 | Shadow | -| 6 | Arcane | - -#### spellx - -Spell ID that can be used for Mind Control of this creature.  -For vehicle creatures: spell on action bar with position X. - #### PetSpellDataId ID, found in CreatureSpellData.dbc, that displays what spells the pet has in the client. diff --git a/docs/creature_template_resistance.md b/docs/creature_template_resistance.md new file mode 100644 index 0000000..0ca44d9 --- /dev/null +++ b/docs/creature_template_resistance.md @@ -0,0 +1,54 @@ +# creature_template_resistance + +[<-Back-to:World](database-world.md) + +**The \`creature_template_resistance\` table** + +**Structure** + +| Field | Type | Attribute | Key | Null | Default | Extra | Comment +:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- +[CreatureID][1] | mediumint(8) | UNSIGNED | PRI | NO +[School][2] | tinyint(6) | UNSIGNED | PRI | NO +[Resistance][3] | smallint(6) | SIGNED | | YES | Null +[VerifiedBuild][4] | smallint(5) | SIGNED | | YES | 0 + +[1]: #creatureid +[2]: #school +[3]: #resistance +[4]: #verifiedbuild + +**Description of the fields** + +### CreatureID + +Creature entry from [creature_template.entry](creature_template#entry). + +### School + +Value must be within this range. If above or under the SQL will fail on `creature_template_resistance_chk_1`. + +Value | Name +:- | :- +1 | SPELL_SCHOOL_HOLY +2 | SPELL_SCHOOL_FIRE +3 | SPELL_SCHOOL_NATURE +4 | SPELL_SCHOOL_FROST +5 | SPELL_SCHOOL_SHADOW +6 | SPELL_SCHOOL_ARCANE + +### Resistance + +Resistance value. + +### VerifiedBuild + +This field was used to determine whether a template has been verified from WDB files. + +If value is 0 then it has not been parsed yet. + +If value is above 0 then it has been parsed with WDB files from that specific client build. + +If value is -1 then it is just a place holder until proper data are found on WDBs. + +If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity. diff --git a/docs/creature_template_spell.md b/docs/creature_template_spell.md new file mode 100644 index 0000000..06b5f49 --- /dev/null +++ b/docs/creature_template_spell.md @@ -0,0 +1,49 @@ +# creature_template_spell + +[<-Back-to:World](database-world.md) + +**The \`creature_template_spell\` table** + +**Structure** + +| Field | Type | Attribute | Key | Null | Default | Extra | Comment +:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- +[CreatureID][1] | mediumint(8) | UNSIGNED | PRI | NO +[Index][2] | tinyint(6) | UNSIGNED | PRI | NO | 0 +[Spell][3] | mediumint(5) | UNSIGNED | | YES | Null +[VerifiedBuild][4] | smallint(5) | SIGNED | | YES | 0 + +[1]: #creatureid +[2]: #index +[3]: #spell +[4]: #verifiedbuild + +**Description of the fields** + +### CreatureID + +Creature entry from [creature_template.entry](creature_template#entry). + +### Index + +Value must be within this range. If above or under the SQL will fail on `creature_template_spell_chk_1`. + +Index 0 - 7. + +Spell position on actionbar for vehicle creatures. + +### Spell + +Spell ID that can be used for Mind Control of a creature. + +### VerifiedBuild + +This field was used to determine whether a template has been verified from WDB files. + +If value is 0 then it has not been parsed yet. + +If value is above 0 then it has been parsed with WDB files from that specific client build. + +If value is -1 then it is just a place holder until proper data are found on WDBs. + +If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity. diff --git a/docs/database-world.md b/docs/database-world.md index 09e9d21..4fd7a82 100644 --- a/docs/database-world.md +++ b/docs/database-world.md @@ -34,6 +34,8 @@ The world database has information basically related to creatures, objects, item - [creature_template](creature_template.md) - [creature_template_addon](creature_addon.md) - [creature_template_locale](creature_template_locale.md) +- [creature_template_resistance](creature_template_resistance.md) +- [creature_template_spell](creature_template_spell.md) - [creature_text](creature_text.md) - [creature_text_locale](creature_text_locale.md) - [disables](disables.md) -- cgit