diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-02-05 14:00:12 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-02-05 14:00:12 +0100 |
| commit | d06d90ed5e58c749216d3e20dcb20d5aff24ed56 (patch) | |
| tree | bb03fe40d4e5d545e874e5740924adef85db90de | |
| parent | 965ecdfaf8cf106c5186432b85e272105a2d0028 (diff) | |
DB/Creatures: Remove trainer_type for units that are not a trainer.
Fixes #228
| -rw-r--r-- | sql/updates/world/2011_02_05_2_world_creature_template.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_05_2_world_creature_template.sql b/sql/updates/world/2011_02_05_2_world_creature_template.sql new file mode 100644 index 00000000000..d193a81eb79 --- /dev/null +++ b/sql/updates/world/2011_02_05_2_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Update Trainertype where unit is NOT a trainer: +UPDATE `creature_template` SET `trainer_type`=0 WHERE entry IN (1300,1703,2855,2870,5749,5750,5753,5815,6027,6328,6373,6374,6376,6382,11048,11050,11051,15494,12776,16639,16649,16703,16727,16746,23535); |