diff options
| -rw-r--r-- | sql/updates/world/master/2023_07_31_00_world.sql | 325 |
1 files changed, 325 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_07_31_00_world.sql b/sql/updates/world/master/2023_07_31_00_world.sql new file mode 100644 index 00000000000..b05a72c76ca --- /dev/null +++ b/sql/updates/world/master/2023_07_31_00_world.sql @@ -0,0 +1,325 @@ +SET @CGUID := 851261; +SET @OGUID := 502252; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+93; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `VerifiedBuild`) VALUES +(@CGUID+0, 140253, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8359.654296875, 666.609375, 97.23799896240234375, 0.162257343530654907, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+1, 140253, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8333.0673828125, 635.76214599609375, 95.719482421875, 1.657125830650329589, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+2, 140253, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8332.6630859375, 638.0867919921875, 95.79345703125, 3.712284564971923828, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+3, 140253, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8331.7080078125, 636.967041015625, 95.6412811279296875, 3.299002408981323242, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+4, 140253, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8357.9599609375, 666.93231201171875, 97.23799896240234375, 3.400092124938964843, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+5, 3681, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8307.9345703125, 697.86761474609375, 88.658660888671875, 3.830827713012695312, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+6, 3681, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8273.572265625, 682.16937255859375, 86.02608489990234375, 3.867586612701416015, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: Stormwind City - Difficulty: 0) CreateObject1 +(@CGUID+7, 141079, 0, 1519, 1519, '0', 11595, 0, 0, 1, -8186.61962890625, 739.09375, 73.84515380859375, 0.404043078422546386, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Stormwind City - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+8, 4423, 0, 1519, 1519, '0', 11595, 0, 0, 0, -8164.67333984375, 750.4111328125, 71.03708648681640625, 5.674059391021728515, 120, 0, 0, 4070, 0, 0, 0, 0, 50585), -- Darnassian Protector (Area: Stormwind City - Difficulty: 0) CreateObject1 (Auras: 244971 - Set Health (Random 15%-55%)) (possible waypoints or random movement) +(@CGUID+9, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8153.47900390625, 727.63714599609375, 70.71832275390625, 2.718510150909423828, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+10, 50305, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8149.7568359375, 739.421875, 69.4141387939453125, 2.636651515960693359, 120, 0, 0, 90335, 7196, 0, 0, 0, 50585), -- Moon Priestess Lasara (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+11, 140403, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8156.16845703125, 726.1961669921875, 70.73529052734375, 1.321698665618896484, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+12, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8158.3369140625, 730.0850830078125, 71.15277099609375, 5.72299051284790039, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+13, 14555, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8144.5537109375, 772.17364501953125, 70.7628631591796875, 5.406215667724609375, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Swift Mistsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+14, 14556, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8147.1181640625, 768.263916015625, 71.37005615234375, 3.972687482833862304, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Swift Frostsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+15, 4730, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8144.65478515625, 765.982666015625, 71.05660247802734375, 1.755637288093566894, 120, 0, 0, 124211, 0, 0, 0, 0, 50585), -- Lelanai (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+16, 50307, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8146.876953125, 745.140625, 68.64325714111328125, 2.459374427795410156, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Lord Candren (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+17, 141079, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8141.10400390625, 753.74481201171875, 68.3470611572265625, 3.950974225997924804, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+18, 14602, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8142.6318359375, 773.6632080078125, 70.498138427734375, 4.904886722564697265, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Swift Stormsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+19, 141079, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8131.96728515625, 777.734375, 69.69577789306640625, 4.659540176391601562, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+20, 4753, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8142.24658203125, 770.982666015625, 70.4398040771484375, 1.945174217224121093, 120, 0, 0, 135503, 0, 0, 0, 0, 50585), -- Jartsam (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+21, 141054, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8119.4033203125, 746.50897216796875, 67.13828277587890625, 3.392504692077636718, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Volunteer Farmhand (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: 275732 - Hold Pumpkin) (possible waypoints or random movement) +(@CGUID+22, 12358, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8139.55224609375, 777.79864501953125, 70.4983367919921875, 5.922245025634765625, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Riding Striped Frostsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+23, 12359, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8140.625, 774, 70.16071319580078125, 4.728158950805664062, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Riding Spotted Frostsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+24, 12360, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8128.84033203125, 776.22052001953125, 68.94378662109375, 3.437875986099243164, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Riding Striped Nightsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+25, 35168, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8124.98291015625, 783.4774169921875, 69.94570159912109375, 1.335671186447143554, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Striped Dawnsaber (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+26, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8124.59716796875, 729.9930419921875, 67.7743072509765625, 4.251955032348632812, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+27, 141054, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8110.57763671875, 765.94769287109375, 67.28433990478515625, 6.280703067779541015, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Volunteer Farmhand (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: 275732 - Hold Pumpkin) +(@CGUID+28, 140403, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8123.1962890625, 728.22393798828125, 67.56597900390625, 3.221469402313232421, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+29, 141030, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8113.64404296875, 743.88543701171875, 67.21701812744140625, 3.795926094055175781, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+30, 141079, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8103.38720703125, 794.16668701171875, 67.696319580078125, 2.126575708389282226, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+31, 141020, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8036.71533203125, 774.53472900390625, 66.99069976806640625, 3.449296474456787109, 120, 0, 0, 238, 0, 0, 0, 0, 50585), -- Ancient of Lore (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (Auras: 244971 - Set Health (Random 15%-55%)) +(@CGUID+32, 141030, 0, 1519, 5316, '0', 11595, 0, 0, 1, -8107.533203125, 769.34893798828125, 67.36767578125, 5.45548868179321289, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+33, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8117.16845703125, 707.8663330078125, 69.69719696044921875, 4.286679267883300781, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+34, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8116.84033203125, 703.513916015625, 69.81890869140625, 2.411498785018920898, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+35, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8103.24658203125, 711.44268798828125, 67.63482666015625, 1.274312496185302734, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+36, 140403, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8105.7119140625, 718.3507080078125, 67.45516204833984375, 3.897825956344604492, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+37, 140403, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8119.423828125, 703.02777099609375, 69.65029144287109375, 1.081589579582214355, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+38, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8118.31591796875, 707.07464599609375, 69.83172607421875, 4.730370521545410156, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+39, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8102.0400390625, 714.54339599609375, 67.4774322509765625, 4.275997161865234375, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+40, 140253, 0, 1519, 5316, '0', 11595, 0, 0, 0, -8121.71728515625, 705.5382080078125, 69.76389312744140625, 0.052547365427017211, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@CGUID+41, 141054, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8081.91943359375, 794.41082763671875, 67.31024169921875, 5.428259849548339843, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Volunteer Farmhand (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: 275732 - Hold Pumpkin) +(@CGUID+42, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8082.60791015625, 789.02606201171875, 67.379058837890625, 5.656858444213867187, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+43, 141079, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8091.8994140625, 804.73614501953125, 67.62110137939453125, 2.256125688552856445, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+44, 140403, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8078.17041015625, 709.7274169921875, 69.8505096435546875, 6.15483856201171875, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+45, 141079, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8087.33349609375, 703.3819580078125, 70.28668212890625, 1.410944342613220214, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+46, 55273, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8089.65966796875, 814.86114501953125, 69.593017578125, 5.2138824462890625, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Swift Mountain Horse (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+47, 140253, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8075.14404296875, 709.98089599609375, 70.03603363037109375, 4.894083499908447265, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Darnassian Refugee (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+48, 55285, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8087.69091796875, 812.81597900390625, 68.91998291015625, 1.672116756439208984, 120, 0, 0, 124211, 0, 0, 0, 0, 50585), -- Astrid Langstrump (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+49, 140403, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8076.814453125, 707.27777099609375, 70.01813507080078125, 0.171963512897491455, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+50, 140403, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8072.67724609375, 708.2274169921875, 69.890625, 2.943119049072265625, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Displaced Gilnean Refugee (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+51, 55272, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8089.64892578125, 818.03900146484375, 69.8152618408203125, 4.784740447998046875, 120, 4, 0, 112919, 0, 1, 0, 0, 50585), -- Mountain Horse (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+52, 55272, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8086.236328125, 816.3038330078125, 68.89261627197265625, 4.323762893676757812, 120, 0, 0, 112919, 0, 0, 0, 0, 50585), -- Mountain Horse (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+53, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8062.80224609375, 769.80035400390625, 67.54749298095703125, 4.438759326934814453, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+54, 141054, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8058.69970703125, 765.154541015625, 67.3733673095703125, 0.214562878012657165, 120, 0, 0, 119, 0, 0, 0, 0, 50585), -- Volunteer Farmhand (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: 275732 - Hold Pumpkin) +(@CGUID+55, 2041, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8075.158203125, 695.29168701171875, 69.5783233642578125, 2.023583173751831054, 120, 0, 0, 4070, 0, 0, 0, 0, 50585), -- Ancient Protector (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: 244971 - Set Health (Random 15%-55%)) +(@CGUID+56, 55272, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8075.93017578125, 826.25030517578125, 69.21858978271484375, 2.165841102600097656, 120, 4, 0, 112919, 0, 1, 0, 0, 50585), -- Mountain Horse (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+57, 3681, 0, 1519, 9171, '0', 11595, 0, 0, 0, -8097.603515625, 841.21636962890625, 70.13033294677734375, 1.211682915687561035, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+58, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8049.65478515625, 779.78302001953125, 67.7374267578125, 5.897857666015625, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+59, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8045.2587890625, 762.54339599609375, 67.30615234375, 0.951750636100769042, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+60, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8049.41845703125, 770.22222900390625, 67.83240509033203125, 0.327275335788726806, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+61, 141079, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8056.65625, 804.81427001953125, 67.10089874267578125, 2.430029630661010742, 120, 0, 0, 169379, 0, 0, 0, 0, 50585), -- Darnassus Sentinel (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+62, 141030, 0, 1519, 9171, '0', 11595, 0, 0, 1, -8045.705078125, 787.7430419921875, 67.19185638427734375, 5.309984683990478515, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@CGUID+63, 7553, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8032.0771484375, 746.03875732421875, 69.69097900390625, 3.842066764831542968, 120, 2, 0, 27, 0, 1, 0, 0, 50585), -- Great Horned Owl (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+64, 7555, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8030.443359375, 750.72760009765625, 69.28243255615234375, 2.71743631362915039, 120, 2, 0, 27, 0, 1, 0, 0, 50585), -- Hawk Owl (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+65, 141030, 0, 1519, 5397, '0', 11595, 0, 0, 1, -8036.001953125, 759.2413330078125, 67.68115997314453125, 1.61740875244140625, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+66, 8665, 0, 1519, 5397, '0', 11595, 0, 0, 1, -8033.265625, 749.91839599609375, 68.4066162109375, 6.101261138916015625, 120, 0, 0, 118565, 0, 0, 0, 0, 50585), -- Shylenai (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+67, 141030, 0, 1519, 5397, '0', 11595, 0, 0, 1, -8033.3818359375, 789.265625, 66.61988067626953125, 4.489844322204589843, 120, 0, 0, 238, 191, 0, 0, 0, 50585), -- Darnassian Druid (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+68, 3681, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8021.4462890625, 737.61517333984375, 72.2440948486328125, 0.49685215950012207, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+69, 3681, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8035.2412109375, 842.61383056640625, 67.02942657470703125, 1.388147830963134765, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+70, 55273, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8074.16015625, 865.14105224609375, 70.3338623046875, 1.927739262580871582, 120, 8, 0, 112919, 0, 1, 0, 0, 50585), -- Swift Mountain Horse (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+71, 3681, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8049.25439453125, 919.55072021484375, 73.20572662353515625, 0.180551812052726745, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+72, 3681, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8050.98291015625, 668.23193359375, 75.08429718017578125, 5.270574092864990234, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+73, 3681, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8074.08837890625, 674.619873046875, 70.72637939453125, 5.464650154113769531, 120, 8, 0, 2035, 0, 1, 0, 0, 50585), -- Wisp (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@CGUID+74, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8102.99462890625, 769.83331298828125, 67.36767578125, 5.023986339569091796, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+75, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8079.38525390625, 786.6944580078125, 67.5884552001953125, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+76, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8109.330078125, 746.18927001953125, 67.21202850341796875, 2.428702831268310546, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+77, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8107.265625, 774.08331298828125, 67.36767578125, 5.023986339569091796, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+78, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8062.38525390625, 774.3367919921875, 67.736114501953125, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+79, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8117.2744140625, 741.1007080078125, 67.2430572509765625, 2.428702831268310546, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+80, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8086.77783203125, 790.18927001953125, 67.36767578125, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+81, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8064.45849609375, 763.8992919921875, 67.29254150390625, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+82, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8114.56103515625, 747.75, 67.189239501953125, 2.428702831268310546, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+83, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8111.4150390625, 739.6875, 67.2447967529296875, 2.428702831268310546, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+84, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8067.7431640625, 771.576416015625, 67.491302490234375, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+85, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8059.1025390625, 771.810791015625, 67.7586822509765625, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+86, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8112.43603515625, 769.6163330078125, 67.36767578125, 5.023986339569091796, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+87, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8121.06591796875, 741.8507080078125, 67.2380218505859375, 2.428702831268310546, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+88, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8107.3212890625, 764.3819580078125, 67.36767578125, 5.023986339569091796, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+89, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8084.36279296875, 784.44268798828125, 67.41738128662109375, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+90, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8104.39404296875, 765.93231201171875, 67.36767578125, 5.023986339569091796, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+91, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8079.5224609375, 791.654541015625, 67.42498779296875, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+92, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8089.17529296875, 788.47918701171875, 67.36767578125, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622), -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +(@CGUID+93, 141036, 0, 1519, 5397, '0', 11595, 0, 0, 0, -8067.9931640625, 767.420166015625, 67.35634613037109375, 0, 120, 0, 0, 119, 0, 0, 0, 0, 50622); -- Pumpkin Stalker (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 (Auras: 275711 - Grow Pumpkin) +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+93; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+1, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+2, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+3, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '244971'), -- Darnassian Protector - 244971 - Set Health (Random 15%-55%) +(@CGUID+9, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+10, 0, 29256, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Moon Priestess Lasara +(@CGUID+11, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+12, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+13, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Swift Mistsaber +(@CGUID+14, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Swift Frostsaber +(@CGUID+15, 0, 0, 8, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Lelanai +(@CGUID+16, 0, 2402, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Lord Candren +(@CGUID+18, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Swift Stormsaber +(@CGUID+20, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Jartsam +(@CGUID+22, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Riding Striped Frostsaber +(@CGUID+23, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Riding Spotted Frostsaber +(@CGUID+24, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Riding Striped Nightsaber +(@CGUID+25, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Striped Dawnsaber +(@CGUID+26, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+28, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+31, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, '244971'), -- Ancient of Lore - 244971 - Set Health (Random 15%-55%) +(@CGUID+34, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+35, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+36, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+37, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+38, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+39, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+40, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+47, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Darnassian Refugee +(@CGUID+49, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+50, 0, 0, 0, 0, 0, 1, 0, 0, 16023, 0, 0, 0, ''), -- Displaced Gilnean Refugee +(@CGUID+55, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '244971'), -- Ancient Protector - 244971 - Set Health (Random 15%-55%) +(@CGUID+63, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Great Horned Owl +(@CGUID+64, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Hawk Owl +(@CGUID+66, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''); -- Shylenai + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+45; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 292776, 0, 1519, 5316, '0', 11595, 0, -8150.17529296875, 742.3992919921875, 69.93271636962890625, 2.155409574508666992, 0, 0, 0.880873680114746093, 0.473351389169692993, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+1, 293422, 0, 1519, 5316, '0', 11595, 0, -8155.876953125, 728.63018798828125, 71.06943511962890625, 2.770315885543823242, 0, 0, 0.982818603515625, 0.184574022889137268, 120, 255, 1, 50585), -- Campfire (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+2, 292776, 0, 1519, 5316, '0', 11595, 0, -8150.875, 728.3680419921875, 70.61585235595703125, 0.496363222599029541, 0, 0, 0.245641708374023437, 0.969360709190368652, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+3, 293325, 0, 1519, 5316, '0', 11595, 0, -8148.12353515625, 729.03125, 70.56125640869140625, 3.939198017120361328, -0.02928733825683593, 0.024878501892089843, -0.92107677459716796, 0.387480169534683227, 120, 255, 1, 50585), -- Alliance Supplies (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+4, 292769, 0, 1519, 5316, '0', 11595, 0, -8161.18603515625, 726.76910400390625, 70.90948486328125, 0.942725896835327148, 0.064159870147705078, -0.02944564819335937, 0.455132484436035156, 0.887620925903320312, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+5, 292776, 0, 1519, 5316, '0', 11595, 0, -8158.56103515625, 724.7430419921875, 70.59011077880859375, 2.853896856307983398, 0, 0, 0.989671707153320312, 0.143352344632148742, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+6, 292776, 0, 1519, 5316, '0', 11595, 0, -8149.09375, 743.74652099609375, 69.92592620849609375, 6.136510372161865234, 0, 0, -0.07327175140380859, 0.997312009334564208, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+7, 292769, 0, 1519, 5316, '0', 11595, 0, -8151.8818359375, 725.77777099609375, 70.54827117919921875, 2.475042343139648437, 0.009595870971679687, -0.02659034729003906, 0.944470405578613281, 0.327378273010253906, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+8, 293324, 0, 1519, 5316, '0', 11595, 0, -8149.625, 742.7257080078125, 68.9080963134765625, 2.659974336624145507, 0.019940853118896484, 0.02582550048828125, 0.970722198486328125, 0.237978637218475341, 120, 255, 1, 50585), -- Table (Human, Small) (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+9, 292776, 0, 1519, 5316, '0', 11595, 0, -8146.8505859375, 727.15802001953125, 70.5587158203125, 2.371193408966064453, 0.064692020416259765, 0.003939628601074218, 0.925389289855957031, 0.373435497283935546, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+10, 293325, 0, 1519, 5316, '0', 11595, 0, -8147.98779296875, 725.59722900390625, 70.53685760498046875, 3.476716518402099609, 0, 0, -0.98599433898925781, 0.166778787970542907, 120, 255, 1, 50585), -- Alliance Supplies (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+11, 194282, 0, 1519, 5316, '0', 11595, 0, -8146.77587890625, 741.342041015625, 68.87461090087890625, 2.732044219970703125, 0, 0, 0.979106903076171875, 0.203346133232116699, 120, 255, 1, 50585), -- Darnassus Banner (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+12, 292769, 0, 1519, 5316, '0', 11595, 0, -8127.2431640625, 725.06597900390625, 68.34482574462890625, 1.127305269241333007, -0.00721025466918945, 0.027539253234863281, 0.533863067626953125, 0.845091640949249267, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+13, 293422, 0, 1519, 5316, '0', 11595, 0, -8125.42041015625, 727.4149169921875, 67.95139312744140625, 4.677936553955078125, 0, 0, -0.71918201446533203, 0.694821715354919433, 120, 255, 1, 50585), -- Campfire (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+14, 292769, 0, 1519, 5316, '0', 11595, 0, -8120.24658203125, 709.951416015625, 69.7899322509765625, 5.35622406005859375, 0, 0, -0.44706439971923828, 0.894501745700836181, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+15, 292769, 0, 1519, 5316, '0', 11595, 0, -8122.04541015625, 705.46875, 69.6644744873046875, 0.112917803227901458, 0, 0, 0.056428909301757812, 0.998406648635864257, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+16, 292776, 0, 1519, 5316, '0', 11595, 0, -8121.7412109375, 703.232666015625, 69.38541412353515625, 3.472620487213134765, 0, 0, -0.98633384704589843, 0.164759114384651184, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+17, 292776, 0, 1519, 5316, '0', 11595, 0, -8101.56787109375, 716, 67.38541412353515625, 5.941944122314453125, 0, 0, -0.16979408264160156, 0.985479533672332763, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+18, 292769, 0, 1519, 5316, '0', 11595, 0, -8108.7587890625, 719.4913330078125, 67.46527862548828125, 5.130315780639648437, 0, 0, -0.54503822326660156, 0.838411211967468261, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+19, 293422, 0, 1519, 5316, '0', 11595, 0, -8118.423828125, 704.81597900390625, 69.73636627197265625, 5.154026031494140625, 0, 0, -0.53506088256835937, 0.844813466072082519, 120, 255, 1, 50585), -- Campfire (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+20, 292776, 0, 1519, 5316, '0', 11595, 0, -8105.8505859375, 719.578125, 67.34896087646484375, 3.584412574768066406, 0, 0, -0.97558879852294921, 0.21960526704788208, 120, 255, 1, 50585), -- Boxes (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+21, 293422, 0, 1519, 5316, '0', 11595, 0, -8106.94091796875, 717.18231201171875, 67.5069427490234375, 4.515601158142089843, 0, 0, -0.77314949035644531, 0.634223818778991699, 120, 255, 1, 50585), -- Campfire (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+22, 293422, 0, 1519, 5316, '0', 11595, 0, -8102.65625, 712.67706298828125, 67.46527862548828125, 4.780049800872802734, 0, 0, -0.6827850341796875, 0.730619311332702636, 120, 255, 1, 50585), -- Campfire (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+23, 292769, 0, 1519, 5316, '0', 11595, 0, -8113.93408203125, 700.96527099609375, 69.8542022705078125, 2.314877033233642578, 0, 0, 0.915777206420898437, 0.40168657898902893, 120, 255, 1, 50585), -- Tent (Area: Olivia's Pond - Difficulty: 0) CreateObject1 +(@OGUID+24, 292769, 0, 1519, 9171, '0', 11595, 0, -8100.0556640625, 711.01043701171875, 67.6319427490234375, 2.83452010154724121, 0, 0, 0.988236427307128906, 0.152933791279792785, 120, 255, 1, 50585), -- Tent (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+25, 292776, 0, 1519, 9171, '0', 11595, 0, -8075.31787109375, 711.125, 69.92751312255859375, 3.651014089584350585, 0, 0, -0.96773624420166015, 0.251965433359146118, 120, 255, 1, 50585), -- Boxes (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+26, 292769, 0, 1519, 9171, '0', 11595, 0, -8074.8662109375, 704.50177001953125, 70.078125, 1.800108075141906738, 0, 0, 0.783360481262207031, 0.62156766653060913, 120, 255, 1, 50585), -- Tent (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+27, 292776, 0, 1519, 9171, '0', 11595, 0, -8078.76904296875, 707.310791015625, 69.85263824462890625, 5.421472549438476562, 0, 0, -0.4176492691040039, 0.908608317375183105, 120, 255, 1, 50585), -- Boxes (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+28, 293422, 0, 1519, 9171, '0', 11595, 0, -8074.75, 707.57989501953125, 70.0069427490234375, 2.796839475631713867, 0, 0, 0.985179901123046875, 0.171524211764335632, 120, 255, 1, 50585), -- Campfire (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+29, 292769, 0, 1519, 9171, '0', 11595, 0, -8080.9912109375, 704.25518798828125, 69.86946868896484375, 0.639443635940551757, 0, 0, 0.314302444458007812, 0.949322938919067382, 120, 255, 1, 50585), -- Tent (Area: Stormwind Embassy - Difficulty: 0) CreateObject1 +(@OGUID+30, 293316, 0, 1519, 5397, '0', 11595, 0, -8124.28125, 745.53302001953125, 68.30655670166015625, 2.112448453903198242, 0, 0, 0.870503425598144531, 0.492162376642227172, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+31, 293316, 0, 1519, 5397, '0', 11595, 0, -8123.61279296875, 745.48785400390625, 68.0386962890625, 3.894083023071289062, 0, 0, -0.93005084991455078, 0.367430835962295532, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+32, 293316, 0, 1519, 5397, '0', 11595, 0, -8056.611328125, 765.20831298828125, 68.18384552001953125, 3.816581487655639648, 0, 0, -0.94358730316162109, 0.331123828887939453, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+33, 293316, 0, 1519, 5397, '0', 11595, 0, -8124.3125, 745.76214599609375, 67.7071685791015625, 0.662882328033447265, 0, 0, 0.325406074523925781, 0.945574402809143066, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+34, 293320, 0, 1519, 5397, '0', 11595, 0, -8115.173828125, 764.73089599609375, 67.28433990478515625, 0.613031744956970214, 0, 0, 0.301738739013671875, 0.953390657901763916, 120, 255, 1, 50622), -- Wheelbarrow (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+35, 293316, 0, 1519, 5397, '0', 11595, 0, -8057.3662109375, 765.48089599609375, 68.3967437744140625, 0.764587759971618652, 0, 0, 0.373049736022949218, 0.927811324596405029, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+36, 293320, 0, 1519, 5397, '0', 11595, 0, -8056.66650390625, 765.17364501953125, 67.44791412353515625, 3.112622022628784179, 0, 0, 0.999895095825195312, 0.014484762214124202, 120, 255, 1, 50622), -- Wheelbarrow (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+37, 293316, 0, 1519, 5397, '0', 11595, 0, -8115.21728515625, 764.451416015625, 68.3623809814453125, 2.766490936279296875, 0, 0, 0.982463836669921875, 0.186453282833099365, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+38, 293316, 0, 1519, 5397, '0', 11595, 0, -8056.51416015625, 765.47052001953125, 68.69519805908203125, 5.266149520874023437, 0, 0, -0.48688316345214843, 0.873467147350311279, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+39, 293316, 0, 1519, 5397, '0', 11595, 0, -8083.26904296875, 797.951416015625, 68.38580322265625, 1.64708411693572998, 0, 0, 0.733557701110839843, 0.679627180099487304, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+40, 293316, 0, 1519, 5397, '0', 11595, 0, -8114.470703125, 764.87847900390625, 68.19017791748046875, 4.548123836517333984, 0, 0, -0.76273441314697265, 0.64671182632446289, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+41, 293316, 0, 1519, 5397, '0', 11595, 0, -8082.6181640625, 798.328125, 68.17254638671875, 4.699076652526855468, 0, 0, -0.71179771423339843, 0.702384531497955322, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+42, 293316, 0, 1519, 5397, '0', 11595, 0, -8115.19287109375, 764.66668701171875, 67.76422119140625, 1.316926836967468261, 0, 0, 0.611902236938476562, 0.790933430194854736, 120, 255, 1, 50622), -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+43, 293320, 0, 1519, 5397, '0', 11595, 0, -8082.625, 798.263916015625, 67.39994049072265625, 3.995177030563354492, 0, 0, -0.91029834747314453, 0.413952797651290893, 120, 255, 1, 50622), -- Wheelbarrow (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+44, 293320, 0, 1519, 5397, '0', 11595, 0, -8124.26025390625, 745.80035400390625, 67.13889312744140625, 6.242174625396728515, 0, 0, -0.02050399780273437, 0.999789774417877197, 120, 255, 1, 50622), -- Wheelbarrow (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 +(@OGUID+45, 293316, 0, 1519, 5397, '0', 11595, 0, -8082.7431640625, 798.59375, 68.66246795654296875, 6.148646354675292968, 0, 0, -0.06721878051757812, 0.997738242149353027, 120, 255, 1, 50622); -- Grown Pumpkin (Area: The Wollerton Stead - Difficulty: 0) CreateObject1 + +-- Creature Template +UPDATE `creature_template` SET `unit_flags3`=16777216, `flags_extra`= 128 WHERE `entry`=141036; -- Pumpkin Stalker + +-- Creature Template Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (7555, 7553); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`)VALUES +(7555, 0, 0, 1, 0, 0, 0, NULL), +(7553, 0, 0, 1, 0, 0, 0, NULL); + +DELETE FROM `creature_movement_override` WHERE `SpawnId` = (@CGUID+70); +INSERT INTO `creature_movement_override` (`SpawnId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(@CGUID+70, 1, 0, 0, 0, 0, 2, NULL); + +-- SAI +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` IN (141030, 55273, 4753); + +-- Darnassian Druids ai +DELETE FROM `smart_scripts` WHERE `entryOrGuid` IN (-(@CGUID+67), -(@CGUID+62), -(@CGUID+58), -(@CGUID+60), -(@CGUID+59), -(@CGUID+65)) AND `source_type` = 0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+67), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'), +(-(@CGUID+62), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'), +(-(@CGUID+58), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'), +(-(@CGUID+60), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'), +(-(@CGUID+59), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'), +(-(@CGUID+65), 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 275766, 0, 0, 0, 0, 0, 10, (@CGUID+31), 141020, 0, 0, 0, 0, 0, 'OnRespawn - cast "Nature Channeling" - to Ancient of Lore'); + + -- Jartsam smart ai +DELETE FROM `smart_scripts` WHERE `entryOrGuid` = -(@CGUID+20) AND `source_type` = 0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+20), 0, 0, 0, 34, 0, 100, 0, 2, 3, 0, 0, 80, 475300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 3 - Self: Start timed action list id #Jartsam #0 (475300) (update out of combat)'), +(-(@CGUID+20), 0, 1, 0, 34, 0, 100, 0, 2, 5, 0, 0, 80, 475300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 5 - Self: Start timed action list id #Jartsam #0 (475300) (update out of combat)'), +(-(@CGUID+20), 0, 2, 0, 34, 0, 100, 0, 2, 8, 0, 0, 80, 475300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 8 - Self: Start timed action list id #Jartsam #0 (475300) (update out of combat)'); + + -- Timed list 475300 smart ai +SET @ENTRY := 475300; +DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, 9, 0, 0, 0, 0, 100, 1, 1000, 1000, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set stand state to KNEEL'), +(@ENTRY, 9, 1, 0, 0, 0, 100, 1, 19000, 19000, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 19 seconds - Self: Remove stand state KNEEL'); + +-- Waypoints for CGUID+8 +SET @PATH := ((@CGUID+8) * 10) << 3; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8227.643, 741.5139, 73.8475, NULL, 0), +(@PATH, 1, -8239.884, 729.8542, 74.83382, NULL, 0), +(@PATH, 2, -8255.366, 712.2049, 78.33671, NULL, 0), +(@PATH, 3, -8271.368, 695.9913, 82.5428, NULL, 0), +(@PATH, 4, -8281.063, 686.9167, 85.55091, NULL, 0), +(@PATH, 5, -8276.606, 670.0347, 89.80533, NULL, 0), +(@PATH, 6, -8288.325, 656.5174, 93.30846, NULL, 0), +(@PATH, 7, -8276.606, 670.0347, 89.80533, NULL, 0), +(@PATH, 8, -8281.063, 686.9167, 85.55091, NULL, 0), +(@PATH, 9, -8271.368, 695.9913, 82.5428, NULL, 0), +(@PATH, 10, -8255.366, 712.2049, 78.33671, NULL, 0), +(@PATH, 11, -8239.884, 729.8542, 74.83382, NULL, 0), +(@PATH, 12, -8227.643, 741.5139, 73.8475, NULL, 0), +(@PATH, 13, -8218.026, 753.5364, 73.22575, NULL, 0), +(@PATH, 14, -8207.185, 764.7674, 72.83836, NULL, 0), +(@PATH, 15, -8200.446, 768.6285, 72.64775, NULL, 0), +(@PATH, 16, -8193.795, 769.6493, 72.61282, NULL, 0), +(@PATH, 17, -8183.707, 763.6893, 71.99033, NULL, 0), +(@PATH, 18, -8159.83, 747.0104, 70.21533, NULL, 0), +(@PATH, 19, -8153.337, 739.6337, 69.53963, NULL, 0), +(@PATH, 20, -8143.182, 731.4393, 70.18753, NULL, 0), +(@PATH, 21, -8137.686, 725.1371, 69.91486, NULL, 0), +(@PATH, 22, -8127.95, 717.2952, 69.28402, NULL, 0), +(@PATH, 23, -8137.686, 725.1371, 69.91486, NULL, 0), +(@PATH, 24, -8143.182, 731.4393, 70.18753, NULL, 0), +(@PATH, 25, -8153.337, 739.6337, 69.53963, NULL, 0), +(@PATH, 26, -8159.83, 747.0104, 70.21533, NULL, 0), +(@PATH, 27, -8183.707, 763.6893, 71.99033, NULL, 0), +(@PATH, 28, -8193.795, 769.6493, 72.61282, NULL, 0), +(@PATH, 29, -8200.446, 768.6285, 72.64775, NULL, 0), +(@PATH, 30, -8207.185, 764.7674, 72.83836, NULL, 0), +(@PATH, 31, -8218.026, 753.5364, 73.22575, NULL, 0); + +UPDATE `creature` SET `position_x`= -8227.643, `position_y`= 741.5139, `position_z`= 73.8475, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+8; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+8; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`, `auras`) VALUES +(@CGUID+8, @PATH, 1, '244971'); + +-- Waypoints for CGUID+20 +SET @PATH := ((@CGUID+20) * 10) << 3; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8137.802, 772.0903, 69.4111, NULL, 0), +(@PATH, 1, -8133.849, 774.5261, 69.18727, NULL, 0), +(@PATH, 2, -8132.412, 775.3281, 69.15266, NULL, 0), +(@PATH, 3, -8131.106, 775.9705, 69.11031, NULL, 21321), +(@PATH, 4, -8135.688, 775.2917, 69.51897, NULL, 0), +(@PATH, 5, -8137.418, 776.4254, 69.89052, NULL, 20750), +(@PATH, 6, -8138.665, 771.6476, 69.57033, NULL, 0), +(@PATH, 7, -8140.59, 770.0018, 70.03521, NULL, 0), +(@PATH, 8, -8142.247, 770.9827, 70.4398, NULL, 20950); + +UPDATE `creature` SET `position_x`= -8137.802, `position_y`= 772.0903, `position_z`= 69.4111, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+20; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+20; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+20, @PATH, 1); + +-- Waypoints for CGUID+33 +SET @PATH := ((@CGUID+33) * 10) << 3; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8113.547, 710.5, 69.21209, NULL, 0), +(@PATH, 1, -8109.365, 714.0347, 68.10353, NULL, 0), +(@PATH, 2, -8107.375, 716.2969, 67.56371, NULL, 31033), +(@PATH, 3, -8113.547, 710.5, 69.21209, NULL, 0), +(@PATH, 4, -8116.434, 709.4896, 69.56734, NULL, 0), +(@PATH, 5, -8117.168, 707.8663, 69.6972, NULL, 30966); + +UPDATE `creature` SET `position_x`= -8113.547, `position_y`= 710.5, `position_z`= 69.21209, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+33; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+33; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+33, @PATH, 1); + +-- Waypoints for CGUID+44 +SET @PATH := ((@CGUID+44) * 10) << 3; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8086.072, 708.7236, 69.10401, NULL, 0), +(@PATH, 1, -8093.484, 706.8698, 68.6935, NULL, 0), +(@PATH, 2, -8102.16, 707.5382, 68.27814, NULL, 0), +(@PATH, 3, -8109.16, 707.7227, 69.32103, NULL, 0), +(@PATH, 4, -8115.337, 706.2118, 69.75192, NULL, 30914), +(@PATH, 5, -8109.278, 707.7222, 69.38297, NULL, 0), +(@PATH, 6, -8102.277, 707.5381, 68.23401, NULL, 0), +(@PATH, 7, -8093.484, 706.8698, 68.6935, NULL, 0), +(@PATH, 8, -8086.217, 708.6927, 69.08749, NULL, 0), +(@PATH, 9, -8080.202, 709.9896, 69.71763, NULL, 0), +(@PATH, 10, -8078.17, 709.7274, 69.85051, NULL, 30844); + +UPDATE `creature` SET `position_x`= -8086.072, `position_y`= 708.7236, `position_z`= 69.10401, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+44; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+44; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+44, @PATH, 1); |