diff options
| -rw-r--r-- | sql/updates/world/2014_06_23_00_world_gameobject.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2014_06_23_00_world_gameobject.sql b/sql/updates/world/2014_06_23_00_world_gameobject.sql new file mode 100644 index 00000000000..a9be0afd0f4 --- /dev/null +++ b/sql/updates/world/2014_06_23_00_world_gameobject.sql @@ -0,0 +1,12 @@ +-- +SET @GUID = 13278; + +DELETE FROM `gameobject` WHERE guid BETWEEN @GUID+0 AND @GUID+6; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@GUID+0,194955,571,1,1,5988.04,4473.78,-87.3617,1.74533,0,0,0.766045,0.642787,180,255,1), +(@GUID+1,194955,571,1,1,6073.83,4463.66,-84.9872,-0.820303,0,0,-0.398748,0.91706,180,255,1), +(@GUID+2,194955,571,1,1,6130.8,4462.61,-84.544,2.75761,0,0,0.981626,0.190814,180,255,1), +(@GUID+3,194955,571,1,1,6075.99,4523.62,-81.0092,0.698132,0,0,0.34202,0.939693,180,255,1), +(@GUID+4,194955,571,1,1,6012.03,4517.3,-86.8614,0.872664,0,0,0.422618,0.906308,180,255,1), +(@GUID+5,194955,571,1,1,6092.64,4425.49,-83.9704,-2.72271,0,0,-0.978147,0.207914,180,255,1), +(@GUID+6,194955,571,1,1,6102.15,4497.03,-81.3401,-2.63544,0,0,-0.968147,0.250383,180,255,1); |