diff options
| author | ogeraisi <ogeraisi@users.noreply.github.com> | 2017-09-11 20:23:22 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-09-11 20:23:22 +0200 |
| commit | d23682331b6584aa276a06f1473f2b239c96ea16 (patch) | |
| tree | cc1ecca1a992efb01352a7cae64ddb9ce8838abc | |
| parent | 7ed36d353af36d53a3ed69a948d09f02a9c18325 (diff) | |
DB/Creature: Dumphry <Blacksmithing Trainer>
Closes #20313
For 3.3.5 Only
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_11_00_world_335.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_11_00_world_335.sql b/sql/updates/world/3.3.5/2017_09_11_00_world_335.sql new file mode 100644 index 00000000000..9e301970ac8 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_11_00_world_335.sql @@ -0,0 +1,4 @@ +-- Dumphry <Blacksmithing Trainer> +UPDATE `creature_template` SET `npcflag` = `npcflag` |16 |64, `trainer_type` = 2 WHERE `entry` = 21209; +DELETE FROM `npc_trainer` WHERE `ID`=21209; +INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES (21209,-201004,0,0,0,0); |