diff options
| -rw-r--r-- | sql/updates/world/2014_04_02_01_world_gameobject_template.sql | 99 |
1 files changed, 99 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_02_01_world_gameobject_template.sql b/sql/updates/world/2014_04_02_01_world_gameobject_template.sql new file mode 100644 index 00000000000..4b29cb533b2 --- /dev/null +++ b/sql/updates/world/2014_04_02_01_world_gameobject_template.sql @@ -0,0 +1,99 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (1719, 3221, 17148, 17149, 17150, 17151, 17152, 37100, 42080, 42081, 42082, 42083, 42084, 42085, 42086, 42087, 42088, 42089, 42090, 42091, 42092, 42093, 42094, 178544, 184352, 186715, 186716, 186732, 186751, 186752, 187347, 187895, 190382, 190383, 190384, 190397, 190398, 190443, 194348, 194951, 194984); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `data0`, `data1`, `data2`, `data3`) VALUES +(1719, 0, 153, 'Orc Lock', 1, 0, 36, 0, 0), +(3221, 10, 245, 'Scott''s Placed Cannon', 1.04, 0, 0, 496, 0), +(17148, 9, 399, 'TEST MARBLE', 1, 388, 0, 3, 0), +(17149, 9, 399, 'TEST PARCHMENT', 1, 389, 0, 1, 0), +(17150, 9, 399, 'TEST STONE', 1, 390, 0, 2, 0), +(17151, 9, 399, 'TEST SILVER', 1, 391, 0, 4, 0), +(17152, 9, 399, 'TEST BRONZE', 1, 392, 0, 5, 0), +(37100, 10, 674, 'Green Glowing Circle', 1, 57, 0, 0, 0), +(42080, 7, 682, '05Low', 1, 5, 0, 0, 0), +(42081, 7, 682, '05Hi', 1, 5, 2, 0, 0), +(42082, 7, 682, '05Med', 1, 5, 1, 0, 0), +(42083, 7, 682, '04Low', 1, 4, 0, 0, 0), +(42084, 7, 682, '04Med', 1, 4, 1, 0, 0), +(42085, 7, 682, '04Hi', 1, 4, 2, 0, 0), +(42086, 7, 682, '03Low', 1, 3, 0, 0, 0), +(42087, 7, 682, '03Med', 1, 3, 1, 0, 0), +(42088, 7, 682, '03Hi', 1, 3, 2, 0, 0), +(42089, 7, 682, '02Low', 1, 2, 0, 0, 0), +(42090, 7, 682, '02Med', 1, 2, 1, 0, 0), +(42091, 7, 682, '02Hi', 1, 2, 2, 0, 0), +(42092, 7, 682, '01 low', 1, 1, 0, 0, 0), +(42093, 7, 682, '01Med', 1, 1, 1, 0, 0), +(42094, 7, 682, '01Hi', 1, 1, 2, 0, 0), +(178544, 23, 192, 'Meeting Stone - PT', 1, 0, 60, 22, 0), +(184352, 0, 25, '', 1, 0, 0, 3000, 0), +(186715, 7, 682, 'Craig''s Chair', 1, 3, 2, 0, 0), +(186716, 7, 682, 'Craig''s Solo Bench', 1, 1, 1, 0, 0), +(186732, 7, 682, 'Chair_Test', 1, 1, 1, 0, 0), +(186751, 7, 682, '', 1, 3, 2, 0, 0), +(186752, 7, 682, '', 1, 2, 2, 0, 0), +(187347, 3, 10, 'Craig''s Chest', 1, 57, 0, 30, 0), +(187895, 33, 7595, 'aaw', 1, 0, 0, 2, 4341), +(190382, 33, 7877, 'Wintergrasp Fortress Wall', 1, 0, 0, 17, 0), +(190383, 33, 7877, 'Wintergrasp Fortress Wall', 1, 0, 0, 17, 0), +(190384, 33, 7909, 'pattymack_wallA', 1, 0, 0, 19, 0), +(190397, 33, 7914, 'pattymac_wall_nd', 1, 0, 0, 20, 0), +(190398, 33, 7915, 'pattymac_nd_wallend', 1, 0, 0, 7, 0), +(190443, 33, 7915, '', 1, 0, 0, 7, 0), +(194348, 19, 433, 'Clayton_Test_Active_Doodad', 15.46, 0, 0, 0, 0), +(194951, 19, 8437, 'clay_test_yep_451_oh_yeah', 13.34, 0, 0, 0, 0), +(194984, 0, 7272, 'TEST - Craig''s test active doodad', 1, 0, 0, 0, 0); + + +SET @OGUID := 76871; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+49; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `orientation`) VALUES +(@OGUID+0, 1719, 451, 16414.1, -16126, 40.3909, 0, 0, 1, 0, 3.14159), -- Orc Lock +(@OGUID+1, 3221, 451, 16793.2, -15833.5, 9.4385, -0.010054, -0.038938, -0.453318, 0.890441, 0.944966), -- Scott''s Placed Cannon +(@OGUID+2, 17148, 451, 16450.5, -16070.6, 40.4495, 0, 0, 1, 0, 3.14159), -- TEST MARBLE +(@OGUID+3, 17149, 451, 16452.5, -16073.1, 40.0628, 0, 0, 1, 0, 3.14159), -- TEST PARCHMENT +(@OGUID+4, 17150, 451, 16454, -16075.3, 39.9315, 0, 0, 1, 0, 3.14159), -- TEST STONE +(@OGUID+5, 17151, 451, 16455.9, -16077.7, 39.8546, 0, 0, 1, 0, 3.14159), -- TEST SILVER +(@OGUID+6, 17152, 451, 16458.1, -16081, 39.3589, 0, 0, 1, 0, 3.14159), -- TEST BRONZE +(@OGUID+7, 21270, 451, 16345.4, -16159.3, 39.5883, 0, 0, 1, 0, 3.14159), -- Anvil +(@OGUID+8, 21271, 451, 16346.3, -16165.1, 39.6982, 0, 0, 1, 0, 3.14159), -- Forge +(@OGUID+9, 21752, 451, 16352.4, -16161.9, 39.9598, 0, 0, 1, 0, 3.14159), -- Firepit of Death +(@OGUID+10, 37100, 451, 16808.8, -15792, 0.088224, 0.030141, 0.160668, 0.986536, -0.004909, 3.15141), -- Green Glowing Circle +(@OGUID+11, 42080, 451, 16284.8, -16145.6, 40.3762, 0, 0, 1, 0, 3.14159), -- 05Low +(@OGUID+12, 42081, 451, 16269.9, -16144.9, 40.3762, 0, 0, 1, 0, 3.14159), -- 05Hi +(@OGUID+13, 42082, 451, 16276.8, -16145.2, 40.3762, 0, 0, 1, 0, 3.14159), -- 05Med +(@OGUID+14, 42083, 451, 16285.2, -16135.9, 40.3762, 0, 0, 1, 0, 3.14159), -- 04Low +(@OGUID+15, 42084, 451, 16277.2, -16135.5, 40.3772, 0, 0, 1, 0, 3.14159), -- 04Med +(@OGUID+16, 42085, 451, 16270.2, -16135.2, 40.3772, 0, 0, 1, 0, 3.14159), -- 04Hi +(@OGUID+17, 42086, 451, 16285, -16126.7, 40.2095, 0, 0, 0.99999, 0.004362, 3.13287), -- 03Low +(@OGUID+18, 42087, 451, 16276.9, -16125.3, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 03Med +(@OGUID+19, 42088, 451, 16270.4, -16125.3, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 03Hi +(@OGUID+20, 42089, 451, 16284.8, -16117.5, 40.2095, 0, 0, 0.99999, 0.004362, 3.13287), -- 02Low +(@OGUID+21, 42090, 451, 16277.2, -16116.5, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 02Med +(@OGUID+22, 42091, 451, 16270.2, -16116.1, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 02Hi +(@OGUID+23, 42092, 451, 16285.2, -16107.7, 40.3762, 0, 0, 0.99999, 0.004362, 3.13287), -- 01 low +(@OGUID+24, 42093, 451, 16277.2, -16107.2, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 01Med +(@OGUID+25, 42094, 451, 16270.3, -16106.8, 40.3772, 0, 0, 0.99999, 0.004362, 3.13287), -- 01Hi +(@OGUID+26, 174824, 451, 16359.8, -16164.9, 39.7311, 0, 0, 1, 0, 3.14159), -- Black Forge +(@OGUID+27, 174825, 451, 16358.9, -16162.1, 39.5136, 0, 0, 1, 0, 3.14159), -- Black Anvil +(@OGUID+28, 176512, 451, 16353.7, -16166.4, 40.3349, 0, 0, 1, 0, 3.14159), -- Test Lab +(@OGUID+29, 177232, 451, 16359.6, -16153.9, 40.9088, 0, 0, 0.07846, 0.996917, 0.157088), -- Moonwell +(@OGUID+30, 178544, 451, 16620.4, 16622.5, 36.1094, 0.032675, 0.015042, -0.77957, 0.625281, 1.79061), -- Meeting Stone - PT +(@OGUID+31, 184352, 451, 15630, 16355.7, 48.6109, 0, 0, 1, 0, 3.14159), -- +(@OGUID+32, 184353, 451, 15678.9, 16335.1, 49.1129, 0, 0, 1, 0, 3.14159), -- +(@OGUID+33, 184363, 451, 15613.5, 16416.7, 48.6111, 0, 0, 1, 0, 3.14159), -- +(@OGUID+34, 186715, 451, 16444.5, -16174.2, 44.9624, 0, 0, 0.868199, -0.496216, 4.18006), -- Craig''s Chair +(@OGUID+35, 186716, 451, 16213.2, -15183.2, 3.24086, 0, 0, 0.998135, -0.061049, 3.26377), -- Craig''s Solo Bench +(@OGUID+36, 186732, 451, -8905.75, 4573.31, 23.6448, 0, 0, 1, 0, 3.14159), -- Chair_Test +(@OGUID+37, 186751, 451, 16415.8, -16164.9, 40.5649, 0, 0, 0.93358, 0.358368, 2.40855), -- +(@OGUID+38, 186752, 451, 16415.2, -16170.4, 40.5657, 0, 0, 0.93358, 0.358368, 2.40855), -- +(@OGUID+39, 187347, 451, 15148.9, 15223.4, 0, 0, 0, 1, 0, 3.14159), -- Craig''s Chest +(@OGUID+40, 187895, 451, 16833.7, 16939.7, 20.3052, 0, 0, 0.999914, -0.0130896, 3.16777), -- aaw +(@OGUID+41, 190382, 451, 16745.8, 16982.7, 5.50431, 0, 0, 1, 0, 3.14159), -- Wintergrasp Fortress Wall +(@OGUID+42, 190383, 451, 16718.1, 16982.6, 4.95189, 0, 0, 1, 0, 3.14159), -- Wintergrasp Fortress Wall +(@OGUID+43, 190384, 451, 16689.6, 16983, 6.84496, 0, 0, 1, 0, 3.14159), -- pattymack_wallA +(@OGUID+44, 190397, 451, 16667.4, 16953, 6.65992, 0, 0, 0, 1, 0), -- pattymac_wall_nd +(@OGUID+45, 190398, 451, 16666.5, 16927.1, 15.5871, 0, 0, 0.030539, 0.999534, 0.061059), -- pattymac_nd_wallend +(@OGUID+46, 190443, 451, 16667.1, 16978.3, 4.25776, 0, 0, -0.00872711, 0.999962, 0.017442), -- +(@OGUID+47, 194348, 451, 4520.27, -190.178, 268.137, 0, 0, 1, 0, 3.14159), -- Clayton_Test_Active_Doodad +(@OGUID+48, 194951, 451, 4503.77, -196.116, 269.88, 0, 0, 1, 0, 3.14159), -- clay_test_yep_451_oh_yeah +(@OGUID+49, 194984, 451, -15345.1, -10695.5, -0.000004, 0, 0, 1, 0, 3.14159); -- TEST - Craig''s test active doodad |