diff options
| -rw-r--r-- | sql/updates/world/master/2023_04_15_02_world.sql | 172 |
1 files changed, 172 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_04_15_02_world.sql b/sql/updates/world/master/2023_04_15_02_world.sql new file mode 100644 index 00000000000..2d3ad93fc8d --- /dev/null +++ b/sql/updates/world/master/2023_04_15_02_world.sql @@ -0,0 +1,172 @@ +SET @CGUID := 3000065; +SET @OGUID := 3001381; +SET @POOL := 5705; +SET @EVENT := 9; + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=48999 WHERE (`ID`=1 AND `CreatureID` IN (51323,47405,44047,39117,39100,33996,12428,10665,10055,6785,5759,5750,5725,5724,5695,5688,4773,4731,3548,3547,2310,2309,2210,2209,2137,2136,2135,2134,2132,2131,2130,2129,2128,2127,2118,2114,1941,1746,1745,1744,1743,1742,1738,1652,1515,1499)); + +-- Models +DELETE FROM `creature_model_info` WHERE `DisplayID`=109482; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(109482, 0.382999986410140991, 1.5, 0, 48999); + +UPDATE `creature_model_info` SET `VerifiedBuild`=48999 WHERE `DisplayID` IN (100727, 36615, 38601, 51457, 51456, 35626, 2177, 45952, 2176, 77405, 77407, 77406, 7118, 11411, 35607, 35603, 4129, 33228, 31313, 31311, 31249, 24719, 29754, 29130, 29026, 28313, 28304, 28118, 28120, 24890, 10721, 4449, 12475, 10670, 10672, 10671, 11904, 10720, 10033, 9999, 9274, 5508, 4179, 4176, 10192, 4107, 4039, 8190, 3945, 2789, 1418, 1141, 1639, 1635, 3521, 3529, 3528, 3533, 11426, 2861, 2856, 1634, 1638, 1631, 1637, 1601, 1599, 1603, 1602, 1600, 1604, 1632, 3520, 2854, 2859, 2860, 2857, 2853, 2862, 1666, 3517, 47211, 9021, 1201, 1200, 1649, 3514, 304); +UPDATE `creature_model_info` SET `BoundingRadius`=0.620783627033233642, `VerifiedBuild`=48999 WHERE `DisplayID`=10853; + +UPDATE `creature_template_model` SET `VerifiedBuild`=48999 WHERE (`Idx`=0 AND `CreatureID` IN (38980,11945,3547,12428,63069,1525,10665,2209,43359,3548,5695,55659,2310,129912,1738,73644,51323,35169,4773,1547,4075,174170,2210,5750,2118,1499,12343,620,1553,2114,27870,17252,2135,2127,2314,2132,32642,47400,5688,73641,32641,10716,1941,1742,1743,2131,44047,12341,11156,4731,47415,63073,12922,1515,5759,38981,47405,1746,2137,39100,33996,12342,2130,1652,2211,38976,10055,1745,2136,34238,6785,1526,2134,14558,2309,39117,37574,5724,1560,197265,61366,73640,2128,61905,43124,2311,1744,2129,5725)) OR (`Idx`=1 AND `CreatureID` IN (43359,55659,51323,4075,27870,2211,38976,37574,61366)) OR (`Idx`=2 AND `CreatureID` IN (55659,51323,4075,27870,2211,61366)) OR (`Idx`=3 AND `CreatureID` IN (51323,27870,2211)); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (197265,38976,27870,10716)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(197265, 0, 0, 0, 2401, 48999), +(38976, 0, 0, 0, 75, 48999), +(27870, 0, 0, 0, 298, 48999), +(10716, 0, 0, 0, 75, 48999); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=48999 WHERE (`DifficultyID`=0 AND `Entry` IN (174170,129912,73644,73641,73640,63073,61905,61366,55659,51323,47415,47405,47400,44047,43359,43124,39117,39100,38980,37574,35169,34238,33996,32791,32642,32641,14558,12428,12343,12342,12341,11945,11156,10665,10055,6785,5759,5750,5725,5724,5695,5688,4773,4731,4075,3548,3547,2314,2311,2310,2309,2211,2210,2209,2137,2136,2135,2134,2132,2131,2130,2129,2128,2127,2118,2114,1941,1746,1745,1744,1743,1742,1738,1652,1560,1553,1547,1526,1525,1515,1499,620)); +UPDATE `creature_template_scaling` SET `LevelScalingDeltaMin`=0, `LevelScalingDeltaMax`=0, `VerifiedBuild`=48999 WHERE (`Entry`=63069 AND `DifficultyID`=0); +UPDATE `creature_template_scaling` SET `ContentTuningID`=75, `VerifiedBuild`=48999 WHERE (`Entry`=12922 AND `DifficultyID`=0); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1; +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`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 32798, 0, 85, 159, '0', 0, 0, 0, 0, 2237.427001953125, 248.7291717529296875, 33.65734100341796875, 2.914699792861938476, 120, 0, 0, 361340, 28784, 0, 0, 0, 0, 48999), -- Spring Gatherer (Area: Brill - Difficulty: 0) CreateObject1 +(@CGUID+1, 32837, 0, 85, 159, '0', 0, 0, 0, 1, 2241.442626953125, 260.8663330078125, 33.65694427490234375, 2.373647689819335937, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48999); -- Noblegarden Merchant (Area: Brill - Difficulty: 0) CreateObject1 + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+60; +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, 113768, 0, 85, 159, '0', 0, 0, 2224.3701171875, 318.531005859375, 33.573699951171875, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+1, 113768, 0, 85, 159, '0', 0, 0, 2226.22998046875, 332.584991455078125, 33.57360076904296875, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+2, 113768, 0, 85, 159, '0', 0, 0, 2275.75, 288.2969970703125, 35.8842010498046875, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+3, 113768, 0, 85, 159, '0', 0, 0, 2266.989990234375, 325.785003662109375, 34.81570053100585937, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+4, 113768, 0, 85, 159, '0', 0, 0, 2292.93994140625, 295.52099609375, 33.527801513671875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+5, 113768, 0, 85, 159, '0', 0, 0, 2234.919921875, 256.678985595703125, 38.50370025634765625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+6, 113768, 0, 85, 159, '0', 0, 0, 2284.68994140625, 299.743011474609375, 36.862701416015625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+7, 113768, 0, 85, 159, '0', 0, 0, 2313.300048828125, 298.292999267578125, 36.31480026245117187, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+8, 113768, 0, 85, 159, '0', 0, 0, 2247.389892578125, 220.113006591796875, 33.574798583984375, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+9, 113768, 0, 85, 159, '0', 0, 0, 2268.260009765625, 233.5850067138671875, 33.69060134887695312, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+10, 113768, 0, 85, 159, '0', 0, 0, 2264.22998046875, 281.4219970703125, 38.56010055541992187, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+11, 113768, 0, 85, 159, '0', 0, 0, 2268.929931640625, 292.09698486328125, 38.55830001831054687, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+12, 113768, 0, 85, 159, '0', 0, 0, 2243.25, 255.1649932861328125, 38.505401611328125, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+13, 113768, 0, 85, 159, '0', 0, 0, 2267.31005859375, 320.264007568359375, 38.44390106201171875, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+14, 113768, 0, 85, 159, '0', 0, 0, 2259.8701171875, 266.459991455078125, 33.68849945068359375, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+15, 113768, 0, 85, 159, '0', 0, 0, 2249.820068359375, 330.875, 36.35770034790039062, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+16, 113768, 0, 85, 159, '0', 0, 0, 2294.5400390625, 256.571014404296875, 38.93349838256835937, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+17, 113768, 0, 85, 159, '0', 0, 0, 2280.1201171875, 226.9239959716796875, 33.9468994140625, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+18, 113768, 0, 85, 159, '0', 0, 0, 2254.010009765625, 318.489990234375, 33.69060134887695312, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+19, 113768, 0, 85, 159, '0', 0, 0, 2264.679931640625, 324.295013427734375, 37.55250167846679687, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+20, 113768, 0, 85, 159, '0', 0, 0, 2246.860107421875, 246.3419952392578125, 33.69150161743164062, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+21, 113768, 0, 85, 159, '0', 0, 0, 2229.64990234375, 295.531005859375, 36.52610015869140625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+22, 113768, 0, 85, 159, '0', 0, 0, 2304.820068359375, 258.35101318359375, 36.22169876098632812, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+23, 113768, 0, 85, 159, '0', 0, 0, 2238.31005859375, 302.87200927734375, 33.632598876953125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+24, 113768, 0, 85, 159, '0', 0, 0, 2233.590087890625, 305.42401123046875, 35.49129867553710937, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+25, 113768, 0, 85, 159, '0', 0, 0, 2249.68994140625, 337.790008544921875, 39.80630111694335937, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+26, 113768, 0, 85, 159, '0', 0, 0, 2238.550048828125, 271.907989501953125, 35.32059860229492187, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+27, 113768, 0, 85, 159, '0', 0, 0, 2336.860107421875, 269.738006591796875, 34.220001220703125, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+28, 113768, 0, 85, 159, '0', 0, 0, 2232.6298828125, 236.4579925537109375, 33.5959014892578125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+29, 113768, 0, 85, 159, '0', 0, 0, 2237.81005859375, 239.4969940185546875, 33.65549850463867187, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+30, 113768, 0, 85, 159, '0', 0, 0, 2229.449951171875, 222.8040008544921875, 33.58140182495117187, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+31, 113768, 0, 85, 159, '0', 0, 0, 2275.2099609375, 270.79998779296875, 39.8291015625, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+32, 113768, 0, 85, 159, '0', 0, 0, 2248.5, 297.636993408203125, 34.5998992919921875, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+33, 113768, 0, 85, 159, '0', 0, 0, 2261.090087890625, 269.993011474609375, 35.17490005493164062, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+34, 113768, 0, 85, 159, '0', 0, 0, 2225.169921875, 291.09698486328125, 36.64530181884765625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+35, 113768, 0, 85, 159, '0', 0, 0, 2279.320068359375, 253.457000732421875, 34.59640121459960937, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+36, 113768, 0, 85, 159, '0', 0, 0, 2256.340087890625, 324.12799072265625, 33.65000152587890625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+37, 113768, 0, 85, 159, '0', 0, 0, 2241.2900390625, 266.7449951171875, 35.32049942016601562, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+38, 113768, 0, 85, 159, '0', 0, 0, 2245.090087890625, 242.5780029296875, 33.68539810180664062, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+39, 113768, 0, 85, 159, '0', 0, 0, 2225.4599609375, 243.240997314453125, 33.57440185546875, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+40, 113768, 0, 85, 159, '0', 0, 0, 2304.580078125, 303.792999267578125, 38.9337005615234375, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+41, 113768, 0, 85, 159, '0', 0, 0, 2218.340087890625, 326.714996337890625, 33.57400131225585937, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+42, 113768, 0, 85, 159, '0', 0, 0, 2253.6298828125, 308.60198974609375, 33.69060134887695312, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+43, 113768, 0, 85, 159, '0', 0, 0, 2327.669921875, 271.490997314453125, 33.76340103149414062, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+44, 113768, 0, 85, 159, '0', 0, 0, 2216.580078125, 270.954986572265625, 33.5885009765625, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+45, 113768, 0, 85, 159, '0', 0, 0, 2304.449951171875, 263.511993408203125, 38.83810043334960937, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+46, 113768, 0, 85, 159, '0', 0, 0, 2261.580078125, 343.506988525390625, 33.57379913330078125, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+47, 113768, 0, 85, 159, '0', 0, 0, 2265.159912109375, 347.70001220703125, 33.57709884643554687, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+48, 113768, 0, 85, 159, '0', 0, 0, 2243.510009765625, 302.970001220703125, 39.810699462890625, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+49, 113768, 0, 85, 159, '0', 0, 0, 2226.35009765625, 313.22601318359375, 33.57469940185546875, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+50, 113768, 0, 85, 159, '0', 0, 0, 2299.3701171875, 253.6999969482421875, 33.57519912719726562, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+51, 113768, 0, 85, 159, '0', 0, 0, 2255.820068359375, 299.696014404296875, 38.559600830078125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+52, 113768, 0, 85, 159, '0', 0, 0, 2233.2900390625, 339.730987548828125, 33.57360076904296875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+53, 113768, 0, 85, 159, '0', 0, 0, 2271.909912109375, 277.436004638671875, 33.69060134887695312, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+54, 113768, 0, 85, 159, '0', 0, 0, 2275.760009765625, 271.389007568359375, 33.6885986328125, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+55, 113768, 0, 85, 159, '0', 0, 0, 2258.0400390625, 328.014007568359375, 33.57960128784179687, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+56, 113768, 0, 85, 159, '0', 0, 0, 2280.550048828125, 264.85198974609375, 34.1277008056640625, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+57, 113768, 0, 85, 159, '0', 0, 0, 2258.820068359375, 331.14898681640625, 33.59650039672851562, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+58, 113768, 0, 85, 159, '0', 0, 0, 2259.89990234375, 269.25201416015625, 38.457000732421875, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject1 +(@OGUID+59, 113768, 0, 85, 159, '0', 0, 0, 2274.489990234375, 220.389007568359375, 33.70220184326171875, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 300, 255, 1, 48999), -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 +(@OGUID+60, 113768, 0, 85, 159, '0', 0, 0, 2248.10009765625, 307.697998046875, 36.00139999389648437, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 300, 255, 1, 48999); -- Brightly Colored Egg (Area: Brill - Difficulty: 0) CreateObject2 + +UPDATE `pool_template` SET `description`='Noblegarden - Brill - Brightly Colored Egg' WHERE `entry`=@POOL; + +DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` BETWEEN @OGUID+0 AND @OGUID+60; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(1, @OGUID+0, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+1, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+2, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+3, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+4, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+5, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+6, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+7, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+8, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+9, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+10, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+11, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+12, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+13, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+14, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+15, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+16, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+17, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+18, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+19, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+20, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+21, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+22, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+23, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+24, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+25, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+26, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+27, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+28, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+29, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+30, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+31, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+32, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+33, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+34, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+35, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+36, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+37, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+38, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+39, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+40, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+41, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+42, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+43, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+44, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+45, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+46, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+47, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+48, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+49, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+50, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+51, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+52, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+53, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+54, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+55, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+56, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+57, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+58, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+59, @POOL, 0, 'Noblegarden - Brightly Colored Egg'), +(1, @OGUID+60, @POOL, 0, 'Noblegarden - Brightly Colored Egg'); + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+1; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1); |