diff options
| -rw-r--r-- | sql/updates/world/2013_06_24_01_world_misc.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2013_06_24_02_world_misc.sql | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/updates/world/2013_06_24_01_world_misc.sql b/sql/updates/world/2013_06_24_01_world_misc.sql index 1379c6cbc75..54487e129de 100644 --- a/sql/updates/world/2013_06_24_01_world_misc.sql +++ b/sql/updates/world/2013_06_24_01_world_misc.sql @@ -91,8 +91,8 @@ INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `positi (@OGUID+1, 179122, 469, 1, 1, -7691.453, -1040.233, 440.6851, 3.752462, 0, 0, 0.9537169, -0.3007059, 7200, 255, 1), (@OGUID+2, 153723, 469, 1, 1, -7752.402, -1155.65, 396.6956, 3.33359, 0, 0, 0.9537169, -0.3007059, 7200, 255, 1), (@OGUID+3, 179148, 469, 1, 1, -7510.984, -1094.69, 476.5545, 5.340709, 0, 0, 0, 1, 7200, 255, 1), -(@OGUID+4, 149045, 469, 1, 1, -6904.809, -1206.778, 178.5116, 2.984498, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -(@OGUID+5, 149046, 469, 1, 1, -6900.417, -1339.326, 239.6519, 3.394674, 0, 0, 1, -4.371139E-08, 7200, 255, 24), +(@OGUID+4, 149045, 469, 1, 1, -6904.809, -1206.778, 178.5116, 2.984498, 0, 0, 1, -4.371139E-08, 7200, 255, 1), +(@OGUID+5, 149046, 469, 1, 1, -6900.417, -1339.326, 239.6519, 3.394674, 0, 0, 1, -4.371139E-08, 7200, 255, 1), (@OGUID+6, 161536, 469, 1, 1, -6756.733, -1166.698, 187.0418, 1.317723, 0, 0, 0.9969173, -0.07845917, 7200, 255, 1), (@OGUID+7, 179113, 469, 1, 1, -7629.542, -1017.326, 413.3823, 6.06502, 0, 0, 0.9537169, -0.3007059, 7200, 255, 1), (@OGUID+8, 179112, 469, 1, 1, -7628.558, -1012.672, 413.3823, 5.750863, 0, 0, 0.9537169, -0.3007059, 7200, 255, 1), diff --git a/sql/updates/world/2013_06_24_02_world_misc.sql b/sql/updates/world/2013_06_24_02_world_misc.sql new file mode 100644 index 00000000000..9468fd00b8b --- /dev/null +++ b/sql/updates/world/2013_06_24_02_world_misc.sql @@ -0,0 +1,2 @@ +UPDATE `gameobject` SET `state`=1 WHERE `guid` IN (56162,56163); -- correct? +DELETE FROM `linked_respawn` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); |