aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2018-10-10 07:13:48 +0200
committerGitHub <noreply@github.com>2018-10-10 07:13:48 +0200
commitd3044f0d38243c0b230ec53d459e12096f74a1e4 (patch)
treede0a15f41fdb98f66b4a60fe85ee4838ff3a6e18
parent8fa9b63ef1efe98871afeedf0df9a8747285a41c (diff)
DB: Typo fix.
-rw-r--r--sql/updates/world/3.3.5/2018_10_09_20_world_335.sql15
1 files changed, 1 insertions, 14 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_09_20_world_335.sql b/sql/updates/world/3.3.5/2018_10_09_20_world_335.sql
index 7005bac3c6a..e9c0ddf9cde 100644
--- a/sql/updates/world/3.3.5/2018_10_09_20_world_335.sql
+++ b/sql/updates/world/3.3.5/2018_10_09_20_world_335.sql
@@ -1,14 +1 @@
---
-DELETE FROM `creature` WHERE `guid` IN (86845,86846,86847,86851,86852,86853,86854,86855,86857);
-INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
-(86845, 28987, 0, 1, 1, 0, 0, -10897, -379, 40.018, 2.893, 300, 0, 0, 0, 0, 0),
-(86846, 1001, 0, 1, 1, 0, 0, -10912, -388, 40.632, 0.812, 300, 0, 0, 0, 0, 0),
-(86847, 1098, 0, 1, 1, 0, 0, -10533, -1128, 26.287, 4.084, 300, 0, 0, 0, 0, 0),
-(86851, 1099, 0, 1, 1, 0, 0, -10531, -1129, 26.093, 3.882, 300, 0, 0, 0, 0, 0),
-(86852, 1100, 0, 1, 1, 0, 0, -10526, -1128, 26.277, 3.621, 300, 0, 0, 0, 0, 0),
-(86853, 1101, 0, 1, 1, 0, 0, -10533, -1124, 26.347, 4.318, 300, 0, 0, 0, 0, 0),
-(86854, 1203, 0, 1, 1, 0, 0, -10552.4, -1316.49, 43.5212, 0.063056, 300, 0, 0, 0, 0, 0),
-(86855, 1204, 0, 1, 1, 0, 0, -10584, -1173, 28.568, 6.069, 300, 0, 0, 0, 0, 0),
-(86857, 1436, 0, 1, 1, 0, 0, -10929, -386, 40.186, 0.816, 300, 0, 0, 0, 0, 0);
-
-UPDATE `creature` SET `spawndist`=0 AND `MovementType`=0 WHERE `guid` IN (6133,6127);
+UPDATE `gameobject_loot_template` SET `Chance`=100 WHERE `Item`=6172;