aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-03-08 22:12:33 +0100
committerKillyana <morphone1@gmail.com>2018-03-08 22:12:33 +0100
commit631bca762e269144fbe457a760685c2430043899 (patch)
tree5d159a6ec261802db29cd31b9f9ce3bdcf51f0bf /sql/updates
parent17645888292bf9df25e25ac6d600d46f4be007eb (diff)
DB/Conditions: Throw Booze
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2018_03_08_09_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_08_09_world.sql b/sql/updates/world/3.3.5/2018_03_08_09_world.sql
new file mode 100644
index 00000000000..2fe2522cb3b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_03_08_09_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `creature` WHERE `guid`=64984;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(64984,23746,530,0,0,1,1,0,0,6718.222656, -7594.638672, 126.092712,0.413325,7200,0,0,0,0,0,0,0,0,"",0);
+UPDATE `conditions` SET `ConditionValue1`=3, `ConditionValue2`=23746, `ConditionValue3`=64984 WHERE `SourceEntry` IN (42391) AND `SourceTypeOrReferenceId`=13;