diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-06-18 00:02:15 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-06-18 00:02:51 +0100 |
| commit | 425efd876e03127ee3a5b9f3d655bf86d5c6b5c2 (patch) | |
| tree | 5a281984ec42c3e135f59549350eda680a2bd945 | |
| parent | 9be16be7b355ae95d4d28d0d33dea9859eb0bad1 (diff) | |
SQL: Fix an sql error on commit 4c23eb9fe2e147f69206. Thanks StewieGriffin
| -rw-r--r-- | sql/old/3.3.5a/2011_06_17_21_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_18_01_world_misc.sql | 9 |
2 files changed, 10 insertions, 1 deletions
diff --git a/sql/old/3.3.5a/2011_06_17_21_world_misc.sql b/sql/old/3.3.5a/2011_06_17_21_world_misc.sql index bfc6742b0b2..acdd8239f21 100644 --- a/sql/old/3.3.5a/2011_06_17_21_world_misc.sql +++ b/sql/old/3.3.5a/2011_06_17_21_world_misc.sql @@ -1,5 +1,5 @@ UPDATE `creature_template` SET `baseattacktime`=2000,`speed_run`=0.99206 WHERE `entry`=35321; -UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`spell1`=51421 WHERE `entry`=28366 +UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`spell1`=51421 WHERE `entry`=28366; UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`exp`=2,`minlevel`=75,`maxlevel`=75,`baseattacktime`=2000,`speed_run`=3.42857,`VehicleId`=107 WHERE `entry`=35299; UPDATE `creature_model_info` SET `bounding_radius`=0.3055,`combat_reach`=1,`gender`=2 WHERE `modelid`=27101; UPDATE `creature_model_info` SET `bounding_radius`=0.434,`combat_reach`=1.4,`gender`=0 WHERE `modelid`=29862; diff --git a/sql/updates/world/2011_06_18_01_world_misc.sql b/sql/updates/world/2011_06_18_01_world_misc.sql new file mode 100644 index 00000000000..acdd8239f21 --- /dev/null +++ b/sql/updates/world/2011_06_18_01_world_misc.sql @@ -0,0 +1,9 @@ +UPDATE `creature_template` SET `baseattacktime`=2000,`speed_run`=0.99206 WHERE `entry`=35321; +UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`spell1`=51421 WHERE `entry`=28366; +UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`exp`=2,`minlevel`=75,`maxlevel`=75,`baseattacktime`=2000,`speed_run`=3.42857,`VehicleId`=107 WHERE `entry`=35299; +UPDATE `creature_model_info` SET `bounding_radius`=0.3055,`combat_reach`=1,`gender`=2 WHERE `modelid`=27101; +UPDATE `creature_model_info` SET `bounding_radius`=0.434,`combat_reach`=1.4,`gender`=0 WHERE `modelid`=29862; + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=35299; +INSERT INTO `npc_spellclick_spells` VALUES +(35299,46598,0,0,0,1,0,0,0); |