diff options
| author | kaelima <kaelima@live.se> | 2012-04-12 01:32:56 +0200 |
|---|---|---|
| committer | kaelima <kaelima@live.se> | 2012-04-12 01:32:56 +0200 |
| commit | 636d553aa83106e57efae5bef0d20d5ed31e98c3 (patch) | |
| tree | 7dcb599855e45cd4c1da4e87ad828af672f6c842 | |
| parent | f60e9a4f8470ad1aee888795a54bf40b8ad0ae98 (diff) | |
DB/WDB: Remove temp entry 68686 and replace with existing wdbverified
(doesnt really fix anything, just for the sake of using proper entries)
| -rw-r--r-- | sql/updates/world/2012_04_12_01_world_creature_template.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_12_01_world_creature_template.sql b/sql/updates/world/2012_04_12_01_world_creature_template.sql new file mode 100644 index 00000000000..bfe7b698ae9 --- /dev/null +++ b/sql/updates/world/2012_04_12_01_world_creature_template.sql @@ -0,0 +1,6 @@ +UPDATE `creature_template` SET `WDBVerified`=12340 WHERE `entry`=40624; -- Verified + +-- Remove temp entry 68686 and replace with wdb verified 38686 +UPDATE `creature_template` SET `difficulty_entry_3`=38686 WHERE `entry`=36950; +UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`exp`=2,`faction_A`=84,`faction_H`=84,`mindmg`=488,`maxdmg`=642,`attackpower`=782,`unit_flags`=32832,`dynamicflags`=8,`minrangedmg`=363,`maxrangedmg`=521,`rangedattackpower`=121 WHERE `entry`=38686; +DELETE FROM `creature_template` WHERE `entry`=68686; |