[Wip] Event - Midsummer Fire Festival {70% Complete}

The reason I write this is, because I need help and am looking for volunteers who want to help out with getting it fixed before this year festival start time. So first of all I will put the code that is completed so far, there would be a lot of you that will argue about WDB data and stuff, I put it as discussion matter all data I used is from blizzard videos and comments. If anyone got a sniff /which I doubt, can bring useful arguments/ and as of scripting I would be glad, if anyone bring fixes in non or in SAI way. As of rest I will describe all that is left to be done and what I’ve troubles with /there are some parts that are in c++ core problems I will mention them/.

What has been completed* so far in links or spoilers:

http://pastebin.com/47xSBZdW[/I][/B][B][I] (updated the old one to remove the old starting quest relations swaped with game event data) this is tested, also I marked with # on titles of different fxes for easier reading.
Thx to
[B][I]DOCTOR-J76[/I][/B] post below, [B][I]http://pastebin.com/qvqg5WMZ[/I][/B] the game_event_gameobject and game_event_creature tables in the spoiler.

Game event quest relations here: [B][I]http://pastebin.com/QgZXLdQc[/I][/B]

Short list of fixes in the changelog - spoiler:

[SPOILER]Hordes’s Honor the Flame quests full data support + spawned missing camps or individual gameojbect and npcs, also corrected creature_templates/. Which involves - add missing creature_quesrelation and involvedrealation that were blocking quests, fix texts - I’ve used a correct model from wdb data and all rest were with wrong one, I checked blizzard and filled it for all, also messed up with tons of creature_template data here and removed some Double spawns and reused some of them for new guids.

Fix achievements:

– Flame keeper and Flame Warden full support with all sub-achievements

– Same goes for Extinguishers and the combined that requires all

– A Thief’s Reward

//

– Add SAI support for all flamekeepers to cast summon Scorchling on spawn /they were manualy spawned and that was wrong there is spell for all/

#1-- Add SAI for Horde Flame Eater /Didn’t want to take guids for action list, since events can do it fine/ and add for now only data for celebrants text.

#2-- Fix quests for stealing 9325/TB/,9326/UC/,9324/Org/,9332/Darnassus/,9331/Ironforge/,9330/SW/ Flames by using linked_spells to conjure the proper items on using the capital’s flames from the cleansing fires that hit players.

#3— Add the missing burning bonfires, there should be 1 for quest and 1 with wood on top of it, both have different types and functions.

#4-- Add the missing burning bonfires the npcs bunnies* /upon which on quest complete steam is casted upon/

#5-- Remove unused guids from creature_addon after removal of some double spawns /that would give warning on start-up/

#6-- Add correct data for Midsummer Bonfire

#7-- Correct size of some bonfires

#8-- Add condition for Stamp Out fire steam to target bunnies only on complete of any of the Desecrate the Fires quests

#9-- Set Eearthen Ring Elder ID: 26221 friendly to both factions as it should be

#10-- Add proper level requirements, remove disables /flag no idea why it was set/ for Earthern ring daillies and chain fix up of some quest relations / Blizzard data they were disabled on 3.3.5a before 2009, but after were not.

#11-- Delete wrong quest_relations for Silvermoon and Exodar stealing capital flames quests /they should start by the fire, not by the npc that finish it/.

#12-- Disable deprecated quests /in 2008/ from Midsummer Fire Festival

#13-- Fix relations of More Torch Tossing and Catching quests

#14-- Add missing objects and creatures from capital cities and fix some minor misc on already spawned ones

#15-- Add SAI/spwawn/data/quest support for Twilight Camp at Ashenvale + support for quest “Unusual Activity” and SAI for all mobs related. Add SAIS for all of mentioned above /data taken from Blua project specific .lua and BrantX creator/

#16-- Add SAI for quest “Unusual activity”

#17-- Add support for [Q][A/H] - An Innocent Disguise Id: 11891 + missing spawn of Briatha

#18-- Full support for quests with name Striking Back and full support for everything they are connected with

– Add missing gossip menus and options//I still don’t get the idea for all the gossips and even different for same functions, but I’m just following the WDB example. Add conditions for gossip menus. Add all missing go spawns for Striking Back quests and decorations connected with it. Add SAIs for the all the Ice Stones and lieutenants that are summoned and creatures in the area /also loots equipment, creature_template data, texts or other/.

#19-- Fix quests Incense for Summer Scorchlings and Incense for Fire Scorchlings/Add SAI support for quest end event

#20-- Add game_event data for creatures and GOs, thanks to [B][I]DOCTOR-J76[/I][/B].

#21-- Add game_event data for all possible quests and seasonal checks taken from blizzard info.

[/SPOILER]
--------------------------------- What is left to be done ---------------------------------------

3 achievements:

http://www.wowhead.c…-hot-pole-dance / - I made some changes, I’ve a lot of ideas. But generaly small list of what needs to be done:

Insert in database the spell that the achievements requires /it is missing/. Somehow make summoned bunny to be at top of the ribbon /no idea how to do tha in trinity/. Find the spell or emote? to spin when the energy from the ribbon link with the player, it 100% not a normal emote, since it would brake.

http://www.wowhead.com/achievement=272 - this also invovles fixing quest Torch Catching and Torch Tossing, this require c++, not sure, too many spells and checks are involved. -------------------------------------------------------

[B][SIZE=14px]http://pastebin.com/HhFfgPd1[/SIZE][/B] → torch tossing completed around 90%, but need some dev to write a award check or something better for when casting rewarding spells to call quest complete + to trigger only, if player has 8 stacks or 20 respectivly or in other words the npc quest giver will cast the spells randomly in very short amount of time and they need a auto check that will do all I mentioned. The spells are:

45719 for alliance on cast without specific target or somekind of check to find a corresponding one to this → /need to call quest complete {11731 - 8 stacks/ 11921 - 20 stacks – these are the ids of the quests} = trigger only, if friendly unit (player around has) 8/20 stacks of aura → 45724

46651 for horde on cast without specific target or somekind of check to find a corresponding one to this → /need to call quest complete {11922 - 8 stacks/ 11926 - 20 stacks – these are the ids of the quests} = trigger only, if friendly unit (player around has) 8/20 stacks of aura → 45724

The rewarding spells give only a visual, so they need to force call quest complete.

The other way would be to add a SAI event on friendly target has aura /+option of stacks/ and min/max repeat of event check. Currently creature has aura and target buffed with are useless for this occasion, even it don’t recognise us as targets on target buffed with spell, if I have a gossip oppened with the very npc.

http://www.wowhead.com/achievement=263 - Ahune - script for him, of his adds, of all npcs that are connected with the last 3 chapters of the chain in Slave Pens. Which leads to core releasing Holiday LFG Support. There are a lot of celebrants which have wrong model ids on guids and need to be fixed /this is for the old ones that I didn’t touch, they are not many, but requires a lot of time and researching/.

The fire pet needs to apply aura on self on spawn.

As of decorations Northend is missing fully. Dalaran needs candles and stuff - this would be best to be waited for the event and gets sniffed it would require bunnies and a lot of pathing I won’t do that since I lack data and is killing efforts with one and pointless without, also it doesn’t effect players event experience as of things they can influence on, but generaly Northend decoration is totaly missing I added only around camps and quests, around which player move around.

The bonfires are really complexed system and there is spell that use a artkit /displayid modifier/ to turn off graphics on bonfires, which is not suppported by our core I think, when a bunny cast the spell on them /since it’s not possible to actualy cast it on it/.

please move the questrelations & spawns to the game_event tables, as they are only active during the game event. we might add a way to auto-clear the quests on event-start

Okay, thanks for pointing it, doing it.

I hope I got it correctly. All that don’t involve the event story should be to game event seasonal quest relations /generaly that are including same type of quests for multiple places/ and rest to game event creature/gos quest relations.

everything for midsummer only appears with midsummer event active, thus is related to the game_event tables, and you should put as much on there as you can /emoticons/default_smile.png

I did the seasonal quest relations for the reseting quest on different years, but I don’t get why I must set the game event go/creature quest relations when the quest zoneorsort defines the event for which they should be applied and on for?

Or it doesn’t act as restricter?

Since all these stuff already dissapear and appear correctly without setting the mentioned above, so I’m wondering.

P.S.: Roger.

simply because then all the relations are in 1 table, semantics is all i can think off, but its best practise to just do it /emoticons/default_smile.png

[SPOILER]DELETE FROM game_event_gameobject WHERE guid IN

(51596,52357,50996,50855,50750,50747,52277,52467,51350,50692,52548,52284,51349,164258,164282,164283,52517,50934,16430,164308,164309,164310,164311,51791,50690,52560,52333,52329,52511,50740,50741,50869,52399,52334,164381,164383,164384,164385,164386,164388,164414,164415,164416,164420,164421,164422,164423,164424,164425,164426,164427,164429,164430,164431,164432,164434,164435,164459,164460,164461,164462,164463,164464,164466,164468,164470,164473,164474,164476,164479,164480,164481,164482,164483,164507,164509,164510,164511,164512,164513,164514,164515,164516,164517,164518,164519,164520,164521,164522,164524,164525,164527,164528,164529,164530,164531,164532,164534,164535,164536,164537,164538,164539,164540,165334,164564,164565,164566,164567,164568,164571,164572,164573,164575,164577,164578,164579,164580,164581,164582,164583,164584,164608,164609,164610,164612,164613,164614,164615,164616,164617,164618,164620,164621,164622,164623,164624,164625,164626,164628,164629,164630,164631,164632,164633,164634,164635,164638,164639,164640,164641,164642,164643,164644,164668,164670,165359,164672,164673,164674,164675,164676,164677,164678,164679,164680,164681,164682,164683,164727,164728,164729,164730,164731,164732,164733,164735,164736,164737,164738,164739,164740,164741,164742,211540,211541,211542,211543,211544,211545,211546,164707,164708,164711,164712,164713,164714,164715,164716,164717,164718,164719,164720,164721,164722,164723,164726,164766,164767,164768,164769,164770,164771,164772,164773,164774,164775,164776,164778,164779,164780,164781,164783,164784,164785,164786,164787,164788,164812,164813,164814,164815,164816,164817,164818,164819,164820,164821,164822,164823,164825,164826,164827,165383,165384,164852,164853,164854,164855,164856,164857,164858,164859,164861,164862,164863,164864,164865,164866,164867,164868,164869,164870,164894,164895,164896,164897,164898,164899,164900,164901,164902,164903,164904,164905,164906,164907,164908,164909,164910,164911,164913,164914,164915,164916,164917,164918,164919,164920,164921,164922,164923,164924,164974,164975,164976,164977,164978,164979,164980,164981,164982,164983,164984,164985,165408,165034,165038,165039,165040,165041,165042,165043,165044,165045,165046,165047,165048,165049,165050,165051,165052,165053,165054,165055,165056,165057,165058,165059,165060,165062,165063,165064,165066,165067,165068,165069,165070,165071,165072,165074,165075,165077,165078,165079,165080,165081,165105,165106,165107,165108,165109,165110,165111,165009,165010,165012,165013,165014,165015,165016,165019,165020,165021,165022,165023,165024,165025,165026,165027,165028,165029,165030,165031,165032,165033,165112,165115,165116,165117,165118,165119,165120,165121,165145,165146,165147,165148,165149,165150,165151,165152,165153,165154,165156,165157,165160,165161,165162,165163,165164,165165,165166,165167,165168,165169,165170,165171,165172,165173,165174,165175,165176,165358,165177,165178,165179,165180,165181,165182,165183,165184,165185,165186,165187,165188,165189,165190,165191,165192,165193,165194,165195,165196,165197,165198,165199,165200,165201,165202,165203,165204,165205,165206,165208,165209,165210,165211,165212,165213,165214,165215,165216,165217,165218,165219,165220,165221,165222,165223,165224,165225,165226,165227,165229,165230,165231,165232,165233,165234,165235,165236,165237,165238,165239,165240,165241,165242,165243,165244,165245,165246,165247,165248,165249,165250,165251,165252,165253,165254,165255,165256,165257,165259,165260,165409,165410,165411,49313,165412,165413,165414,165415,165416,165417,165418,165419,165420,165421,165422,165423,165424,165425,165426,165427,165428,165429,165430,165431,165432,165433,165434,165435,165436,165437,165438,165439,165440,165441,165442,165443,165444,165445,165446,165447,165448,165449,165450,165451,165452,165453,165454,165455,165456,165457,165458,165459,165460,165461,165462,165463,165464,165465,165466,165467,165468,165469,165470,165471,165472,165473,165474,165475,165476,165477,165478,165479,165480,165481,165482,165483,165484,165485,165509,165510,165511,165512,165513,165514,165515,165516,165517,165518,165519,165520,165521,165522,165523,165524,165525,165550,165551,165552,165553,165554,165555,165556,165557,165581,165582,165583,165607,165608,165609,165610,165612,165613,165614,165615,165616,165617,165618,165677,165678,165679,165680,165681,165682,165683,165684,165685,165686,165687,165688,165689,165690,165691,165715,165723,165747,165748,165749,165773,165774,165800,165801,165802,165803,165827,165828,165829,165830,165831,165832,165833,165834,165835,165837,165838,165839,165840,165841,165842,165843,165844,165845,165846,165847,165848,165849,165850,165851,165852,165853,165854,165855,165856,165857,165858,165859,165860,165862,165886,165887,165888,165889,165890,165914,165915,165916,165917,165918,165919,165920,165921,165922,165923,165924,165925,165926,165951,165952,165953,165954,165955,165956,165957,165958,165959,165960,165961,165962,165963,165964);

INSERT INTO game_event_gameobject (eventEntry, guid) VALUES

(1,51596),

(1,52357),

(1,50996),

(1,50855),

(1,50750),

(1,50747),

(1,52277),

(1,52467),

(1,51350),

(1,50692),

(1,52548),

(1,52284),

(1,51349),

(1,164258),

(1,164282),

(1,164283),

(1,52517),

(1,50934),

(1,16430),

(1,164308),

(1,164309),

(1,164310),

(1,164311),

(1,51791),

(1,50690),

(1,52560),

(1,52333),

(1,52329),

(1,52511),

(1,50740),

(1,50741),

(1,50869),

(1,52399),

(1,52334),

(1,164381),

(1,164383),

(1,164384),

(1,164385),

(1,164386),

(1,164388),

(1,164414),

(1,164415),

(1,164416),

(1,164420),

(1,164421),

(1,164422),

(1,164423),

(1,164424),

(1,164425),

(1,164426),

(1,164427),

(1,164429),

(1,164430),

(1,164431),

(1,164432),

(1,164434),

(1,164435),

(1,164459),

(1,164460),

(1,164461),

(1,164462),

(1,164463),

(1,164464),

(1,164466),

(1,164468),

(1,164470),

(1,164473),

(1,164474),

(1,164476),

(1,164479),

(1,164480),

(1,164481),

(1,164482),

(1,164483),

(1,164507),

(1,164509),

(1,164510),

(1,164511),

(1,164512),

(1,164513),

(1,164514),

(1,164515),

(1,164516),

(1,164517),

(1,164518),

(1,164519),

(1,164520),

(1,164521),

(1,164522),

(1,164524),

(1,164525),

(1,164527),

(1,164528),

(1,164529),

(1,164530),

(1,164531),

(1,164532),

(1,164534),

(1,164535),

(1,164536),

(1,164537),

(1,164538),

(1,164539),

(1,164540),

(1,165334),

(1,164564),

(1,164565),

(1,164566),

(1,164567),

(1,164568),

(1,164571),

(1,164572),

(1,164573),

(1,164575),

(1,164577),

(1,164578),

(1,164579),

(1,164580),

(1,164581),

(1,164582),

(1,164583),

(1,164584),

(1,164608),

(1,164609),

(1,164610),

(1,164612),

(1,164613),

(1,164614),

(1,164615),

(1,164616),

(1,164617),

(1,164618),

(1,164620),

(1,164621),

(1,164622),

(1,164623),

(1,164624),

(1,164625),

(1,164626),

(1,164628),

(1,164629),

(1,164630),

(1,164631),

(1,164632),

(1,164633),

(1,164634),

(1,164635),

(1,164638),

(1,164639),

(1,164640),

(1,164641),

(1,164642),

(1,164643),

(1,164644),

(1,164668),

(1,164670),

(1,165359),

(1,164672),

(1,164673),

(1,164674),

(1,164675),

(1,164676),

(1,164677),

(1,164678),

(1,164679),

(1,164680),

(1,164681),

(1,164682),

(1,164683),

(1,164727),

(1,164728),

(1,164729),

(1,164730),

(1,164731),

(1,164732),

(1,164733),

(1,164735),

(1,164736),

(1,164737),

(1,164738),

(1,164739),

(1,164740),

(1,164741),

(1,164742),

(1,211540),

(1,211541),

(1,211542),

(1,211543),

(1,211544),

(1,211545),

(1,211546),

(1,164707),

(1,164708),

(1,164711),

(1,164712),

(1,164713),

(1,164714),

(1,164715),

(1,164716),

(1,164717),

(1,164718),

(1,164719),

(1,164720),

(1,164721),

(1,164722),

(1,164723),

(1,164726),

(1,164766),

(1,164767),

(1,164768),

(1,164769),

(1,164770),

(1,164771),

(1,164772),

(1,164773),

(1,164774),

(1,164775),

(1,164776),

(1,164778),

(1,164779),

(1,164780),

(1,164781),

(1,164783),

(1,164784),

(1,164785),

(1,164786),

(1,164787),

(1,164788),

(1,164812),

(1,164813),

(1,164814),

(1,164815),

(1,164816),

(1,164817),

(1,164818),

(1,164819),

(1,164820),

(1,164821),

(1,164822),

(1,164823),

(1,164825),

(1,164826),

(1,164827),

(1,165383),

(1,165384),

(1,164852),

(1,164853),

(1,164854),

(1,164855),

(1,164856),

(1,164857),

(1,164858),

(1,164859),

(1,164861),

(1,164862),

(1,164863),

(1,164864),

(1,164865),

(1,164866),

(1,164867),

(1,164868),

(1,164869),

(1,164870),

(1,164894),

(1,164895),

(1,164896),

(1,164897),

(1,164898),

(1,164899),

(1,164900),

(1,164901),

(1,164902),

(1,164903),

(1,164904),

(1,164905),

(1,164906),

(1,164907),

(1,164908),

(1,164909),

(1,164910),

(1,164911),

(1,164913),

(1,164914),

(1,164915),

(1,164916),

(1,164917),

(1,164918),

(1,164919),

(1,164920),

(1,164921),

(1,164922),

(1,164923),

(1,164924),

(1,164974),

(1,164975),

(1,164976),

(1,164977),

(1,164978),

(1,164979),

(1,164980),

(1,164981),

(1,164982),

(1,164983),

(1,164984),

(1,164985),

(1,165408),

(1,165034),

(1,165038),

(1,165039),

(1,165040),

(1,165041),

(1,165042),

(1,165043),

(1,165044),

(1,165045),

(1,165046),

(1,165047),

(1,165048),

(1,165049),

(1,165050),

(1,165051),

(1,165052),

(1,165053),

(1,165054),

(1,165055),

(1,165056),

(1,165057),

(1,165058),

(1,165059),

(1,165060),

(1,165062),

(1,165063),

(1,165064),

(1,165066),

(1,165067),

(1,165068),

(1,165069),

(1,165070),

(1,165071),

(1,165072),

(1,165074),

(1,165075),

(1,165077),

(1,165078),

(1,165079),

(1,165080),

(1,165081),

(1,165105),

(1,165106),

(1,165107),

(1,165108),

(1,165109),

(1,165110),

(1,165111),

(1,165009),

(1,165010),

(1,165012),

(1,165013),

(1,165014),

(1,165015),

(1,165016),

(1,165019),

(1,165020),

(1,165021),

(1,165022),

(1,165023),

(1,165024),

(1,165025),

(1,165026),

(1,165027),

(1,165028),

(1,165029),

(1,165030),

(1,165031),

(1,165032),

(1,165033),

(1,165112),

(1,165115),

(1,165116),

(1,165117),

(1,165118),

(1,165119),

(1,165120),

(1,165121),

(1,165145),

(1,165146),

(1,165147),

(1,165148),

(1,165149),

(1,165150),

(1,165151),

(1,165152),

(1,165153),

(1,165154),

(1,165156),

(1,165157),

(1,165160),

(1,165161),

(1,165162),

(1,165163),

(1,165164),

(1,165165),

(1,165166),

(1,165167),

(1,165168),

(1,165169),

(1,165170),

(1,165171),

(1,165172),

(1,165173),

(1,165174),

(1,165175),

(1,165176),

(1,165358),

(1,165177),

(1,165178),

(1,165179),

(1,165180),

(1,165181),

(1,165182),

(1,165183),

(1,165184),

(1,165185),

(1,165186),

(1,165187),

(1,165188),

(1,165189),

(1,165190),

(1,165191),

(1,165192),

(1,165193),

(1,165194),

(1,165195),

(1,165196),

(1,165197),

(1,165198),

(1,165199),

(1,165200),

(1,165201),

(1,165202),

(1,165203),

(1,165204),

(1,165205),

(1,165206),

(1,165208),

(1,165209),

(1,165210),

(1,165211),

(1,165212),

(1,165213),

(1,165214),

(1,165215),

(1,165216),

(1,165217),

(1,165218),

(1,165219),

(1,165220),

(1,165221),

(1,165222),

(1,165223),

(1,165224),

(1,165225),

(1,165226),

(1,165227),

(1,165229),

(1,165230),

(1,165231),

(1,165232),

(1,165233),

(1,165234),

(1,165235),

(1,165236),

(1,165237),

(1,165238),

(1,165239),

(1,165240),

(1,165241),

(1,165242),

(1,165243),

(1,165244),

(1,165245),

(1,165246),

(1,165247),

(1,165248),

(1,165249),

(1,165250),

(1,165251),

(1,165252),

(1,165253),

(1,165254),

(1,165255),

(1,165256),

(1,165257),

(1,165259),

(1,165260),

(1,165409),

(1,165410),

(1,165411),

(1,49313),

(1,165412),

(1,165413),

(1,165414),

(1,165415),

(1,165416),

(1,165417),

(1,165418),

(1,165419),

(1,165420),

(1,165421),

(1,165422),

(1,165423),

(1,165424),

(1,165425),

(1,165426),

(1,165427),

(1,165428),

(1,165429),

(1,165430),

(1,165431),

(1,165432),

(1,165433),

(1,165434),

(1,165435),

(1,165436),

(1,165437),

(1,165438),

(1,165439),

(1,165440),

(1,165441),

(1,165442),

(1,165443),

(1,165444),

(1,165445),

(1,165446),

(1,165447),

(1,165448),

(1,165449),

(1,165450),

(1,165451),

(1,165452),

(1,165453),

(1,165454),

(1,165455),

(1,165456),

(1,165457),

(1,165458),

(1,165459),

(1,165460),

(1,165461),

(1,165462),

(1,165463),

(1,165464),

(1,165465),

(1,165466),

(1,165467),

(1,165468),

(1,165469),

(1,165470),

(1,165471),

(1,165472),

(1,165473),

(1,165474),

(1,165475),

(1,165476),

(1,165477),

(1,165478),

(1,165479),

(1,165480),

(1,165481),

(1,165482),

(1,165483),

(1,165484),

(1,165485),

(1,165509),

(1,165510),

(1,165511),

(1,165512),

(1,165513),

(1,165514),

(1,165515),

(1,165516),

(1,165517),

(1,165518),

(1,165519),

(1,165520),

(1,165521),

(1,165522),

(1,165523),

(1,165524),

(1,165525),

(1,165550),

(1,165551),

(1,165552),

(1,165553),

(1,165554),

(1,165555),

(1,165556),

(1,165557),

(1,165581),

(1,165582),

(1,165583),

(1,165607),

(1,165608),

(1,165609),

(1,165610),

(1,165612),

(1,165613),

(1,165614),

(1,165615),

(1,165616),

(1,165617),

(1,165618),

(1,165677),

(1,165678),

(1,165679),

(1,165680),

(1,165681),

(1,165682),

(1,165683),

(1,165684),

(1,165685),

(1,165686),

(1,165687),

(1,165688),

(1,165689),

(1,165690),

(1,165691),

(1,165715),

(1,165723),

(1,165747),

(1,165748),

(1,165749),

(1,165773),

(1,165774),

(1,165800),

(1,165801),

(1,165802),

(1,165803),

(1,165827),

(1,165828),

(1,165829),

(1,165830),

(1,165831),

(1,165832),

(1,165833),

(1,165834),

(1,165835),

(1,165837),

(1,165838),

(1,165839),

(1,165840),

(1,165841),

(1,165842),

(1,165843),

(1,165844),

(1,165845),

(1,165846),

(1,165847),

(1,165848),

(1,165849),

(1,165850),

(1,165851),

(1,165852),

(1,165853),

(1,165854),

(1,165855),

(1,165856),

(1,165857),

(1,165858),

(1,165859),

(1,165860),

(1,165862),

(1,165886),

(1,165887),

(1,165888),

(1,165889),

(1,165890),

(1,165914),

(1,165915),

(1,165916),

(1,165917),

(1,165918),

(1,165919),

(1,165920),

(1,165921),

(1,165922),

(1,165923),

(1,165924),

(1,165925),

(1,165926),

(1,165951),

(1,165952),

(1,165953),

(1,165954),

(1,165955),

(1,165956),

(1,165957),

(1,165958),

(1,165959),

(1,165960),

(1,165961),

(1,165962),

(1,165963),

(1,165964);

DELETE FROM game_event_creature WHERE guid IN

(94696,94723,94698,94724,94513,86426,86487,202758,94710,94518,94656,94694,86386,94786,209666,209667,209668,209669,209670,209673,209675,209925,209926,209927,209928,209929,209930,210411,210412,210413,210414,210415,210416,210420,210425,210426,210427,210428,210429,210677,210682,210683,210684,210685,210686,210944,210946,210947,210948,210949,210950,210951,210982,210983,210984,210985,211249,211256,211257,211258,211259,211260,211261,211540,211541,211542,211543,211544,211545,211546,211513,211520,211521,211522,211523,211524,211790,211791,211792,211793,211794,211797,212038,212039,212040,212041,212042,212043,212289,212290,212291,212292,212293,212295,212536,212537,212538,212539,212540,212541,212598,212599,212600,212601,212602,212603,212604,212847,212848,212849,212850,212851,212852,213103,213104,213105,213106,213108,213109,213113,213114,213115,213116,213117,213118,213358,213359,213360,213361,213363,213364,213096,213097,213098,213099,213100,213101,213374,213375,213376,213377,213378,213628,213629,213630,213631,213632,213633,213642,213643,213644,213645,213646,213647,213650,213651,213652,213653,213654,213712,213716,213717,213718,213719,213720,213727,213728,213729,213731,213732,213733,213737,213738,213739,213740,213741,213742,213746,213747,213748,213749,213751,213752,213790,213791,213792,213793,213794,213795,265409,265410,265411,265486,265412,265413,265414,265415,265416,265417,265418,265419,265420,265421,265422,265423,265424,265425,265426,265427,265428,265429,265430,265431,265432,265433,265434,265435,265436,265437,265438,265439,265440,265441,265442,265443,265444,265445,265446,265447,265448,265449,265450,265451,265452,265453,265454,265455,265456,265457,265458,265459,265460,265461,265462,265463,265464,265465,265466,265467,265468,265469,265470,265471,265472,265473,265474,265475,265476,265477,265478,265479,265480,265481,265482,265483,265484,265485,265736,202766,202767,265978,266222,266223,266224,266229,266232,266233,94739,266689,266690,266691,266692,266693,266694,266695,266696,266697,266698,266699,266700,266701,266702,267430,267431,267432,267433,267434,267435,267436,267437,267438,267439,267440,267441,267442,267443,267444,267445,267446,267447,267448,267449,267450);

INSERT INTO game_event_creature (eventEntry, guid) VALUES

(1,94696),

(1,94723),

(1,94698),

(1,94724),

(1,94513),

(1,86426),

(1,86487),

(1,202758),

(1,94710),

(1,94518),

(1,94656),

(1,94694),

(1,86386),

(1,94786),

(1,209666),

(1,209667),

(1,209668),

(1,209669),

(1,209670),

(1,209673),

(1,209675),

(1,209925),

(1,209926),

(1,209927),

(1,209928),

(1,209929),

(1,209930),

(1,210411),

(1,210412),

(1,210413),

(1,210414),

(1,210415),

(1,210416),

(1,210420),

(1,210425),

(1,210426),

(1,210427),

(1,210428),

(1,210429),

(1,210677),

(1,210682),

(1,210683),

(1,210684),

(1,210685),

(1,210686),

(1,210944),

(1,210946),

(1,210947),

(1,210948),

(1,210949),

(1,210950),

(1,210951),

(1,210982),

(1,210983),

(1,210984),

(1,210985),

(1,211249),

(1,211256),

(1,211257),

(1,211258),

(1,211259),

(1,211260),

(1,211261),

(1,211540),

(1,211541),

(1,211542),

(1,211543),

(1,211544),

(1,211545),

(1,211546),

(1,211513),

(1,211520),

(1,211521),

(1,211522),

(1,211523),

(1,211524),

(1,211790),

(1,211791),

(1,211792),

(1,211793),

(1,211794),

(1,211797),

(1,212038),

(1,212039),

(1,212040),

(1,212041),

(1,212042),

(1,212043),

(1,212289),

(1,212290),

(1,212291),

(1,212292),

(1,212293),

(1,212295),

(1,212536),

(1,212537),

(1,212538),

(1,212539),

(1,212540),

(1,212541),

(1,212598),

(1,212599),

(1,212600),

(1,212601),

(1,212602),

(1,212603),

(1,212604),

(1,212847),

(1,212848),

(1,212849),

(1,212850),

(1,212851),

(1,212852),

(1,213103),

(1,213104),

(1,213105),

(1,213106),

(1,213108),

(1,213109),

(1,213113),

(1,213114),

(1,213115),

(1,213116),

(1,213117),

(1,213118),

(1,213358),

(1,213359),

(1,213360),

(1,213361),

(1,213363),

(1,213364),

(1,213096),

(1,213097),

(1,213098),

(1,213099),

(1,213100),

(1,213101),

(1,213374),

(1,213375),

(1,213376),

(1,213377),

(1,213378),

(1,213628),

(1,213629),

(1,213630),

(1,213631),

(1,213632),

(1,213633),

(1,213642),

(1,213643),

(1,213644),

(1,213645),

(1,213646),

(1,213647),

(1,213650),

(1,213651),

(1,213652),

(1,213653),

(1,213654),

(1,213712),

(1,213716),

(1,213717),

(1,213718),

(1,213719),

(1,213720),

(1,213727),

(1,213728),

(1,213729),

(1,213731),

(1,213732),

(1,213733),

(1,213737),

(1,213738),

(1,213739),

(1,213740),

(1,213741),

(1,213742),

(1,213746),

(1,213747),

(1,213748),

(1,213749),

(1,213751),

(1,213752),

(1,213790),

(1,213791),

(1,213792),

(1,213793),

(1,213794),

(1,213795),

(1,265409),

(1,265410),

(1,265411),

(1,265486),

(1,265412),

(1,265413),

(1,265414),

(1,265415),

(1,265416),

(1,265417),

(1,265418),

(1,265419),

(1,265420),

(1,265421),

(1,265422),

(1,265423),

(1,265424),

(1,265425),

(1,265426),

(1,265427),

(1,265428),

(1,265429),

(1,265430),

(1,265431),

(1,265432),

(1,265433),

(1,265434),

(1,265435),

(1,265436),

(1,265437),

(1,265438),

(1,265439),

(1,265440),

(1,265441),

(1,265442),

(1,265443),

(1,265444),

(1,265445),

(1,265446),

(1,265447),

(1,265448),

(1,265449),

(1,265450),

(1,265451),

(1,265452),

(1,265453),

(1,265454),

(1,265455),

(1,265456),

(1,265457),

(1,265458),

(1,265459),

(1,265460),

(1,265461),

(1,265462),

(1,265463),

(1,265464),

(1,265465),

(1,265466),

(1,265467),

(1,265468),

(1,265469),

(1,265470),

(1,265471),

(1,265472),

(1,265473),

(1,265474),

(1,265475),

(1,265476),

(1,265477),

(1,265478),

(1,265479),

(1,265480),

(1,265481),

(1,265482),

(1,265483),

(1,265484),

(1,265485),

(1,265736),

(1,202766),

(1,202767),

(1,265978),

(1,266222),

(1,266223),

(1,266224),

(1,266229),

(1,266232),

(1,266233),

(1,94739),

(1,266689),

(1,266690),

(1,266691),

(1,266692),

(1,266693),

(1,266694),

(1,266695),

(1,266696),

(1,266697),

(1,266698),

(1,266699),

(1,266700),

(1,266701),

(1,266702),

(1,267430),

(1,267431),

(1,267432),

(1,267433),

(1,267434),

(1,267435),

(1,267436),

(1,267437),

(1,267438),

(1,267439),

(1,267440),

(1,267441),

(1,267442),

(1,267443),

(1,267444),

(1,267445),

(1,267446),

(1,267447),

(1,267448),

(1,267449),

(1,267450);

[/SPOILER]

Holy shi…

[SPOILER]Use this good sir.

[/SPOILER]

[/SPOILER]

 -- Don't forget this! 

@DOCTOR-J76,

Ah, good job. I was working on the quests part, will add it soon.

P.S.: I updated the first post with quest relations /based on events/, did the seasonal checking also.

hello

good work!!

but this will be add to the TC??

regards

Well, I tried to make it with TC standarts as much as possible. But still the update is too big, I doubt someone will look on it, before this year festival, around 11 days are remaining. I would be finishing it by now, but lost around 1 month from exams. A lot of stuff left to be fixed, some in core saddly /around almost all, I can’t do nothing about them/.

I found a partial fix for Burning Hot Pole Dancer (achievement).

http://webcache.goog…lient=firefox-a

combined with this stuff I wrote most likely would fix it partly:

[CODE]-- GO had nonexisting spell, set the correct existing one
UPDATE gameobject_template SET data10=29708 WHERE entry=181605;
– Set SAI for Ribbon Pole Target Bunny
SET @RibbonBunny := 17066;
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= @RibbonBunny;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@RibbonBunny;
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
(@RibbonBunny,0,0,1,25,0,100,0,0,0,0,0,11,45422,0,0,0,0,0,1,0,0,0,0,0,0,0,‘RibbonBunny - On spawn - Cast Summon flame circles bunny’),
(@RibbonBunny,0,1,0,61,0,100,0,0,0,0,0,85,29705,0,0,0,0,0,1,0,0,0,0,0,0,0,‘RibbonBunny - Linked with event 0 - Cast Ribbon Pole Channel Test on player who dones’‘t have aura from it’);
– TO DO: The script is not ok atm, the player must be invoker, so the bunny make him cast spell on itself.
– Ribbon Pole Channel can target only players
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry IN (29705);
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition ,ErrorTextId,ScriptName,Comment) VALUES
(13,1,29705,0,0,31,0,4,0,0,0,0,‘’,‘Ribbon Pole Channel target can be only player’);
– Set SAI for Flower Circle Bunny
SET @FlowerBunny := 25303;
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= @FlowerBunny;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@FlowerBunny;
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
(@FlowerBunny,0,0,0,60,0,100,0,5000,5000,10000,10000,11,46842,0,0,0,0,0,1,0,0,0,0,0,0,0,‘RibbonBunny - OOC - Cast blue flame flower’),
(@FlowerBunny,0,1,0,60,0,100,0,10000,10000,10000,10000,11,46836,0,0,0,0,0,1,0,0,0,0,0,0,0,‘RibbonBunny - OOC - Cast Fire Patch’);
– Spell link for Pole Channel to trigger Experience buff
DELETE FROM spell_linked_spell WHERE spell_trigger=29715;
INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES
(29715, 29175, 0, ‘Pole Channel trigger Experience buff on each proc’);
[/sql]
To do: The spell that gives xp bonus should stack each time it is repeated when there is active aura from it or something like that and for some reason max allowed stacks are 1? Should be 20.

Also the bunny that is summoned from the ribbon pole should be somehow posititioned always in the top of the GO and the 2nd one in the bottom like it is.

And lastly as described in the SAI I need to make the player that use the pole invoker to the summoned unit, so it can use invoker cast on him to cast on it. No idea how to do this.

P.S.:

The non-existing spell from the go maybe is unknown spellscript that do what I mentioned. And honnestly I’m tired of guesses, so I will leave what is left to be done to sniffers and guys who actualy are good at scripting. Atleast for this year.

[/CODE]

http://www.wowhead.com/achievement=272 - this also invovles fixing quest Torch Catching and Torch Tossing, this require c++, not sure, too many spells and checks are involved.

The core is currently able to deal with such achievements. The question is just, how the worldserver can manage it, that the player can cast this spell. This could be done via spell_linked_spell for example, so not only C++ possible here.

Makro spam of: .cast 45280 works like a charm - after 40 casts in 15 seconds the achievement is correctly triggered, I can also provide screenshots, if neccessary. ^^

Well, I made long ago some hacky fix:

[CODE]-- There are 2 spells involved ID - 46711 Set Flag: all torch returning quests are complete triggered by ID - 46709 Has Completed all Torch Quests /that should change somehow Torch Juggler target to caster not cone infront of it, no idea how to do it and the spells do nothing atm/.
– Allows achievement Torch Juggler
DELETE FROM achievement_criteria_data WHERE criteria_id=6937;
INSERT INTO achievement_criteria_data (criteria_id, type, value1, value2, ScriptName) VALUES
(6937, 16, 341, 0, ‘’);
– Spell link for Throw Torch with on hit trigger Juggle Torch for the target
DELETE FROM spell_linked_spell WHERE spell_trigger=45819;
INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES
(45819, 45638, 0, ‘Throw Torch with on hit trigger Juggle Torch for the target’);
– Spell link for Throw Torch with on hit trigger Juggle Torch for the target
DELETE FROM spell_linked_spell WHERE spell_trigger=45638;
INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES
(45638, 45276, 0, ‘Throw Torch with on hit trigger Juggle Torch for the target’);
DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry IN (45638);
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition ,ErrorTextId,ScriptName,Comment) VALUES
(17,0,45638,0,0,31,0,4,0,0,0,0,‘’,‘Torch juggler target can be only player’);
– this is all I could do for now, 2 leaks it give torch once they are thrown since no way to make the effect of 2nd spell apply after 1st ends /since it hits no target, maybe c++ has a way and torch animation fall on ground thanks to the thing I described in the top. Otherwise timing, awarding ans such is working as it should, but visualy nothing I can do…[/sql]

For me it was necessary to edit the achievement criteria for some reason. The achievement works correctly, but the catch-up is not done, all torchs fall on ground, so I reversed it to link with it on torch throw to trigger the achievement spell. This is a hack, but the only thing that actualy worked with spell link for me (the 15 sec 40 torchs work like this). I tried it blizzard way and most of the spells are broken as of, they don’t throw high in the sky, but just above the head. And the catch torch part works only for those that are not needed. But this is pretty messed up by Blizzard, if you check the spells connected with this - they are like 20 that could be about it.That is why I think a sniff here would be awesome. I just can’t be sure what is for torch tossing/torch catching and what is for this, there are 10 obvious, but rest are not. Also to gain this achievement player must get aura for having completed torch tossing/torch catching. I’ve no idea how to make this also, without c++. I tried with conditions, but the spell with the aura had some problems.

I’ve also tried some stuff with Ahune, but it’s just in testing phase like 40% complete and not blizzlike + is boss in SAI… and generaly is covering the normal instance, not the holiday one, but still some stuff may be used for the actual fix as data.

I it did yesterday, so it’s having a lot of bugs and is not thinked out. For example Spikes are surely needing a C++ script, if spell link them it would be a mess.

[spoiler]

[sql]
– SAI for Ahune Adds
– 25755, Ahunite Hailstone
SET @ENTRY := 25755;
SET @SPELL_CHILLING_AURA := 46542;
SET @SPELL_PULVERIZE := 2676;
UPDATE creature_template SET minlevel=80,maxlevel=80,exp=2,faction_a=16,faction_h=16, mindmg = 600, maxdmg = 1500, attackpower = 642, dmg_multiplier = 2, minrangedmg = 345, maxrangedmg = 509, rangedattackpower = 103,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE 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,0,0,1,25,0,100,0,0,0,0,0,11,@SPELL_CHILLING_AURA,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahunite Hailstone - On spawn - Cast Chilling Aura on self’),
(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,120,0,0,0,0,0,0,‘Ahunite Hailstone - Linked with previous event - Start attack’),
(@ENTRY,0,2,0,0,0,100,0,2000,3000,7000,8000,11,@SPELL_PULVERIZE,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Ahunite Hailstone - In combat - Pulverize’);
– 25756, Ahunite Coldwave
SET @ENTRY := 25756;
SET @SPELL_BITTER_BLAST := 46406;
UPDATE creature_template SET minlevel=80,maxlevel=80,exp=2,faction_a=16,faction_h=16, mindmg = 500, maxdmg = 1000, attackpower = 642, dmg_multiplier = 1, minrangedmg = 345, maxrangedmg = 509, rangedattackpower = 103,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE 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,0,0,0,25,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,120,0,0,0,0,0,0,‘Ahunite Coldwave - On spawn - Attack start’),
(@ENTRY,0,1,0,0,0,100,0,0,0,5000,5000,11,@SPELL_BITTER_BLAST,0,0,0,0,0,5,0,0,0,0,0,0,0,‘Ahunite Coldwave - Bitter Blast’);
– 25757, Ahunite Frostwind
SET @ENTRY := 25757;
SET @SHIELD := 12550;
SET @BUFFET := 46568;
UPDATE creature_template SET unit_class=2,minlevel=80,maxlevel=80,exp=2,faction_a=16,faction_h=16, mindmg = 500, maxdmg = 1000, attackpower = 642, dmg_multiplier = 1, minrangedmg = 345, maxrangedmg = 509, rangedattackpower = 103,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE 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,0,0,1,25,0,100,0,0,0,0,0,11,@SHIELD,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahunite Frostwind - On spawn - Cast Lightning Shield on self’),
(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,120,0,0,0,0,0,0,‘Ahunite Frostwind - Linked with previous event - Move Attack start’),
(@ENTRY,0,2,0,0,0,100,0,2000,3000,7000,8000,11,@BUFFET,0,0,0,0,0,6,0,0,0,0,0,0,0,‘Ahunite Frostwind - Wind Buffet’);
– Add proper creature_template for Ahune
DELETE FROM creature_template WHERE entry=25740;
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified) VALUES (25740, 26338, 0, 0, 0, 0, 23344, 0, 0, 0, ‘Ahune’, ‘The Frost Lord’, ‘’, 0, 82, 82, 1.5, 14, 14, 0, 1.2, 1.14286, 1, 1, 4000, 4500, 0, 2000, 7.5, 2000, 0, 1, 4, 8, 0, 0, 0, 0, 0, 278, 413, 58, 4, 72, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘SmartAI’, 0, 1, 1, 45, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 617299803, 0, ‘’, 12340);
– Add quest givers and takers in Slave Pens and other triggers or background npcs.
UPDATE creature_template SET minlevel=70,maxlevel=70,exp=2,AIName=‘SmartAI’ WHERE entry=25710; – Numa Claudsister
UPDATE creature_template SET minlevel=70,maxlevel=70,exp=2,AIName=‘SmartAI’ WHERE entry=25697; – Luma Skymother
UPDATE creature_template SET minlevel=71,maxlevel=75,exp=2,unit_class=2,AIName=‘SmartAI’ WHERE entry=25754; – Earthen Ring Flamecaller
DELETE FROM creature WHERE guid IN (277451);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType) VALUES
(277451, 25710, 547, 15, 1, 0, 0, 136.594, -117.766, -1.59055, 3.99904, 300, 0, 0, 42, 0, 0); – Numa
DELETE FROM creature WHERE guid IN (278038,278040,278041);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES
(278038, 15214, 547, 1, 1, 0, 0, -62.151, -160.632, -1.80114, 3.40964, 300, 0, 0, 7212, 0, 0, 0, 0, 0), – World trigger for floor ice background
(278040, 15214, 547, 1, 1, 0, 0, -92.7159, -226.697, -1.23048, 1.61735, 300, 0, 0, 7212, 0, 0, 0, 0, 0); – World trigger for floor ice background
DELETE FROM game_event_creature WHERE guid IN (277451,278038,278040);
INSERT INTO game_event_creature (guid, evententry) VALUES
(‘277451’, ‘1’), – Numa
(‘278038’, ‘1’), – Trigger
(‘278040’, ‘1’); – Trigger
– SAI for Invisible World Triggers
DELETE FROM smart_scripts WHERE entryorguid IN (-278038,-278040);
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
(-278038,0,0,0,25,0,100,0,0,0,0,0,11,45937,0,0,0,0,0,1,0,0,0,0,0,0,0,‘World Invisible Trigger - On spawn - Cast Summoning Visual for Ahune (Persistent area aura)’),
(-278040,0,0,0,25,0,100,0,0,0,0,0,11,45937,0,0,0,0,0,1,0,0,0,0,0,0,0,‘World Invisible Trigger - On spawn - Cast Summoning Visual for Ahune (Persistent area aura)’);
– Adjusting object to show with the correct size.
UPDATE gameobject_template SET size = 2 WHERE entry =187882;
– Adding object to instance
DELETE FROM gameobject WHERE guid IN (440701,440795,440768,440770,440772,440774,440776,440778,440794);
INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
(440701, 187882, 547, 15, 1, -62.151, -160.632, -1.80114, 3.40964, 0, 0, 0.703812, 0.710386, 300, 0, 1),
(440795, 188072, 547, 15, 1, -62.151, -160.632, -1.60114, 3.40964, 0, 0, 0.703812, 0.710386, 300, 0, 1),
(440768, 188072, 547, 1, 1, -115.786, -165.893, -1.66515, 4.75578, 0, 0, 0.691601, -0.72228, 300, 0, 1),
(440770, 188072, 547, 1, 1, -74.1158, -185.036, -4.76683, 6.07289, 0, 0, 0.104954, -0.994477, 300, 0, 1),
(440772, 188072, 547, 1, 1, -76.3954, -219.601, -2.90177, 5.23173, 0, 0, 0.501843, -0.864959, 300, 0, 1),
(440774, 188072, 547, 1, 1, -117.218, -204.541, -1.46281, 2.93994, 0, 0, 0.994921, 0.100657, 300, 0, 1),
(440776, 188072, 547, 1, 1, -75.4573, -241.928, -3.45162, 5.10371, 0, 0, 0.556144, -0.831086, 300, 0, 1),
(440778, 188072, 547, 1, 1, -103.946, -244.089, -0.97587, 4.39607, 0, 0, 0.809652, -0.58691, 300, 0, 1),
(440794, 188073, 547, 1, 1, -89.0057, -115.807, -2.04007, 1.80505, 0, 0, 0.784892, 0.619632, 300, 0, 1);
DELETE FROM game_event_gameobject WHERE guid IN (440701,440795,440768,440770,440772,440774,440776,440778,440794);
INSERT INTO game_event_gameobject (guid, evententry) VALUES
(440701,1),
(440795,1),
(440768,1),
(440770,1),
(440772,1),
(440774,1),
(440776,1),
(440778,1),
(440794,1);
– Ice Stone relations for Ahune
DELETE FROM gameobject_involvedrelation WHERE id=188152;
INSERT INTO gameobject_involvedrelation (id, quest) VALUES (‘188152’,‘11691’);
– Make one of the Flamecallers have sitting visual
DELETE FROM creature_addon WHERE guid=202737;
INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote, auras) VALUES
(202737, 0, 0, 1, 0, 0, ‘’);
– Make one Ahune Submerged
DELETE FROM creature_template_addon WHERE entry=25740;
INSERT INTO creature_template_addon (entry, path_id, mount, bytes1, bytes2, emote, auras) VALUES
(25740, 0, 0, 9, 1, 0, ‘18950 45954’);
– Add support for Ahune Ice Stone
SET @Script := 18788200;
UPDATE gameobject_template SET AIName= ‘SmartGameObjectAI’ WHERE entry=187882;
DELETE FROM smart_scripts WHERE source_type=1 AND entryorguid=187882;
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguid=@Script;
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
(187882,1,0,0,62,0,100,0,11389,0,0,0,80,@Script,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Stone - On gossip option select - Run script’),
– Script 00
(@Script,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Actionlist - On action 0 - Close gossip’),
(@Script,9,1,0,0,0,100,0,1000,1000,0,0,12,25740,6,60000,0,0,0,8,0,0,0,-101.045273, -227.940460, -1.353198, 1.409736,‘Actionlist - On action 1 - Summon Ahune’),
(@Script,9,2,0,0,0,100,0,0,0,0,0,12,25865,6,60000,0,0,0,8,0,0,0,-101.045273, -227.940460, -1.353198, 1.409736,‘Actionlist - On action 2 - Summon Core’),
(@Script,9,3,0,0,0,100,0,1000,1000,0,0,45,0,1,0,0,0,0,1,0,0,0,0,0,0,0,‘Actionlist - Action 3 - Dataset 1 on Ahune Event Trigger’),
(@Script,9,4,0,0,0,100,0,1000,1000,0,0,70,600,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Actionlist - Action 4 - Respawn object /make it reappear after 100 secs/’);
– Add missing gossip menus and options
DELETE FROM gossip_menu_option WHERE menu_id IN (11389);
INSERT INTO gossip_menu_option (menu_id,id,option_icon,option_text,option_id,npc_option_npcflag,action_menu_id,action_poi_id,box_coded,box_money,box_text) VALUES
(11389,0,0, ‘Disturb the stone and summon Lord Ahune.’,1,1,0,0,0,0, ‘’); – Ahune’‘s Ice Stone
DELETE FROM gossip_menu WHERE entry IN (11389);
INSERT INTO gossip_menu (entry,text_id) VALUES
(11389,12524);
– Add conditions for gossip menus
DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup IN (11389);
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition ,ErrorTextId,ScriptName,Comment) VALUES
(15,11389,0,0,0,28,0,11691,0,0,0,0,’',‘Ice Stone - For Gossip player must have the daily quest’);
– SAI for Ahune
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=25740;
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
(25740,0,0,1,25,0,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - On spawn - Remove bytes for submerged visual’),
(25740,0,1,0,61,0,100,0,0,0,0,0,11,46402,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - Linked with event 0 - Cast Ahune Resurface’),
(25740,0,2,3,4,0,100,1,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - On aggro - Set EventPhase 1’),
(25740,0,3,0,61,0,100,0,0,0,0,0,75,18950,0,0,0,0,0,9,25865,0,70,0,0,0,0,‘Ahune - Linked with previous event - Add aura detect invisibility on crystal as trigger since data set did nothing’),
(25740,0,4,9,0,0,100,0,60000,60000,90000,90000,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - IC - Set EventPhase 2’),
(25740,0,5,10,0,0,100,0,90000,90000,90000,90000,22,3,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - IC - Set EventPhase 3’),
– Phase I,
(25740,0,6,0,0,1,100,0,0,0,30000,30000,12,25755,4,60000,0,0,0,8,0,0,0,-93.825562,-210.518204,-1.1671461,1.671461,‘Ahune - IC - Summon Ahunite Hailstone’),
(25740,0,7,0,0,1,100,0,0,0,9000,9000,12,25756,4,60000,0,0,0,8,0,0,0,-81.332069,-216.803482,-2.205609,2.120709,‘Ahune - IC - Summon Ahunite Coldwave’),
(25740,0,8,0,0,1,100,0,0,0,9000,9000,12,25756,4,60000,0,0,0,8,0,0,0,-81.332069,-216.803482,-2.205609,2.120709,‘Ahune - IC - Summon Ahunite Coldwave’),
– Phase II
(25740,0,9,0,61,2,100,0,0,0,0,0,90,9,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - IC - Set field bytes for submerge’),
– Phase III
(25740,0,10,0,61,4,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - IC - Remove field bytes for submerge’),
(25740,0,11,0,0,4,100,0,0,0,30000,30000,12,25755,4,60000,0,0,0,8,0,0,0,-93.825562,-210.518204,-1.1671461,1.671461,‘Ahune - IC - Summon Ahunite Hailstone’),
(25740,0,12,0,0,4,100,0,0,0,9000,9000,12,25756,4,60000,0,0,0,8,0,0,0,-102.682007,-212.935059,-1.303376,1.165664,‘Ahune - IC - Summon Ahunite Coldwave’),
(25740,0,13,0,0,4,100,0,0,0,9000,9000,12,25756,4,60000,0,0,0,8,0,0,0,-102.682007,-212.935059,-1.303376,1.165664,‘Ahune - IC - Summon Ahunite Coldwave’),
(25740,0,14,0,0,4,100,0,0,0,9000,9000,12,25757,4,60000,0,0,0,8,0,0,0,-81.332069,-216.803482,-2.205609,2.120709,‘Ahune - IC - Summon Ahunite Coldwind’),
– On death
(25740,0,15,0,6,0,100,0,0,0,0,0,11,62043,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ahune - On death - Cast Ahune dies achievement credit’);
– Core update
UPDATE creature_template SET AIName=‘SmartAI’,exp=2,minlevel=82,maxlevel=82,unit_flags=4,mechanic_immune_mask=617299803,faction_A=14,faction_H=14,type_flags=8 WHERE entry=25865;
– SAI for Ahune’s Core
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=25865;
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
(25865,0,0,0,25,0,100,0,0,0,0,0,11,16380,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Core - On spawn - Set unseen’),
(25865,0,1,2,23,0,100,0,18950,1,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,‘Ice Core - On creature has aura - Start attack for aggro’),
(25865,0,2,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Core - Linked with previous event - Set phase 2’),
(25865,0,3,0,0,1,100,0,90000,90000,90000,90000,28,16380,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Core - IC - Set seen’),
(25865,0,4,0,0,1,100,0,90000,90000,90000,90000,11,16380,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Core - IC - Set unseen’),
(25865,0,5,7,6,1,100,0,0,0,0,0,37,0,0,0,0,0,0,9,25740,0,30,0,0,0,0,‘Ice Core - On death - Kill Ahune’),
(25865,0,6,7,61,1,100,0,0,0,0,0,50,187892,180000,0,0,0,0,8,0,0,0,-98.188896,-195.562225,-1.525354,4.792638,‘Ice Core - On Linked with previous event - Spawn chest’),
(25865,0,7,0,61,1,100,0,0,0,0,0,45,0,1,0,0,0,0,8,0,0,0,-98.188896,-195.562225,-1.525354,4.792638,‘Ice Core - On Linked with previous event - Data set 0 1 to chest’);
– Add support for Ahune Ice Chest
UPDATE gameobject_template SET AIName= ‘SmartGameObjectAI’ WHERE entry=187892;
DELETE FROM smart_scripts WHERE source_type=1 AND entryorguid=187892;
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
(187892,1,0,0,38,0,100,0,0,1,0,0,99,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Ice Stone - On data set 0 1 - Set loot ready for chest’);
[/CODE]

I’ve always tought that someone would be interested in fisnishing this before this year festival, so I didn’t post my workarounds or just quitted on parts that required c++, but since the day almost come, I post some stuff. The last one needs a lot of editing. I’ll prorabbably change it till the the end of the day.

A request for the future. Please do not delete by GUID as some servers will not have the same spawn guid’s as yours. Delete instead by

DELETE FROM $table where $entryid IN ($list) AND Position_X BETWEEN $x1 AND $x2 … (y, z and map). This will make it much more accurate.

except that these things should be done on a CLEAN tc db so as to have totally matching guids

Well, this was supposed to be made for clean trinity, but it became old so maybe some guids are already taken. :confused:

All used guids are modified before pushing. When developing a script you should use a high starting guid that is unlikely to be used by Trinity in the next 10 years.

We will use proper ones when the script is ready to be committed.

Try it, but it is not finish

Its a fix for the text, gossip and quest.

https://github.com/T…ore/issues/6886