Updating original script which was posted for this npc at 54cb925f8bea76ddbb364208df/sql/old/3.3.5a/TDB49_to_TDB50_updates/world/2012_09_26_00_world_misc.sql#L7
so that it also replaces http://www.wowhead.com/item=31763/druid-signal as well as the felsworn gas mask
(cherry picked from commit 6dd8e2beef61d44635ec9e38fe120e33c8a968b2)
(cherry picked from commit ffbaf80aebce981ac026a69ef96cc89c480ba2f4)
Updating my previous script for this as my prior work was no longer working as intended, was no longer in sync with spawn of caged human and when this changed to squirrel, toad, rabbit, sheep only the name of the npc changed the the appearance never changed,
deleting the permament spawn of caged human Apothecary Keever after he casts the teleport spell
(cherry picked from commit 833b5b9e16eb32b56d056448ba0aaf83cab557d8)
More fixes to make these behave properly ie the first quest been optional (not necessary) but if quest it leads to is already taken
(cherry picked from commit 8f70cc8d792d5e494d65269da5c08135ddf4cc6d)
Script https://youtu.be/R5Wm6Xsxz-M?t=5m40s
still seem to be missing a spell here which may still be missing from spell dbc which should have a effect (6 aura) effectapply auraname (139 force reaction) and effectmiscvalue 1001 (yes am looking for the spell which should cause all ogres in blades edge to become neutral once this is turned in.
(cherry picked from commit 9f89717915c73bde77491b165dadcf4f2bcd7a41)
Abjurist Belmara, Cohlien Frostweaver, Conjurer Luminrath and Battle-Mage Dathric each should become neutral to players once there associated quest is rewarded
(cherry picked from commit 420732e961e2577c8a5b0053ab0169142f0b47ec)
Changes to script so that credit is only given at end of event rather than after first wave of mobs due to timer aura been removed on evade
(cherry picked from commit 4b6930e2d0a5b37ae1eb697964cfe785b8dfb2a6)
DB/SAI: Add missing charmed flags to blight geists which is required for when they are charmed as part of it roll's downhill.
(cherry picked from commit f2c351158b527b3dc8493cf1edd841ddad2de579)
Fix script so that if player does not sucessfully kill the hardknuckle matriach it does not remain hostile as an invisible mob to players doing damage to players who get in agro range.
(cherry picked from commit a261056f58b76ff58b64e278105aa9069ac13210)
Fix bad target for script for move to position which was using target 1 instead of 8 which was causing npc to walk through wall and dissapear on quest accept
(cherry picked from commit e263654c77fbbe94f3af2d462aaf203c9c4f6ec8)
* Rescript underbog lord has regrowth is not linked to hp as was previously scripted infact you don't even have to damage npc for it to use this abilitie and it should stack 10 times increasing damage by 150% not only cast once hp is below 50%, also cast knock-away on range instead of ic so it only uses this abilitie If there is a target in range rather than ic even if there is no target in range
* Naturalist bite - make gossip and option available in heroic mode too not only normal mode
(cherry picked from commit 7bfc62639a8d6d378900c7878a0d1763e62344ee)
Remove part of script which rings bell at start of nights event when his nightly script activates as this should no longer be needed.
(cherrypicked from d535b98b057f20012653af6af496d9f22f055a83)
1) Prevent Quetz'lun Worshipper and Serpent-Touched Berserker from becoming unkillable if player on Foundation for Revenge agros but does not kill it
2) Add some missing effects for Leading the Ancestors Home
3) Supplies to the Crossroads and The Disruption ends should be able to be taken together
4) The Spirits of Stonetalon is optional breadcrumb and Goblin Invaders should be takable without it
5) Fix a lot of other breadcrumb quests as appears did not previously push to tc or cant find commit
(cherry picked from commit 4bc5a5be32bc79277e6e86a1a7e7084cc5e780c8)
Update some sql scripts to summon creatures via spell instead of just summoning and kill the startup errors caused by my last commit to fix the spells.
(cherry picked from commit c70edcfcead012811621203e789adc8d19ce6e69)
Move from cpp to db, also added some missing detail
(cherry picked from commit cefed89c38bcd7bb7562df51f9e932878084c5da)
Remove obsolete file
(cherry picked from commit 9be0362606971e40f47543462f133125e995279d)
Remove reference to eastern plaguelands script
(cherry picked from commit 1fc8e2d5f28964bfb69304760e0d9333a45aee28)
1) Player no longer needs to make killing blow on ghouls for Darrowshire Spirit to spawn
2) Use correct server side spell to summon darroshire spirit
3) Add missing spirit particles and make it so the gossip is actually displayed rather than setting non selectable flags which causes gossip to immedietley close, in sniffs from 3.3.0 and 4.2.2 cant see any updates to unit flags and gossip is already in db.
Will remove core scripts later as want to try and convert the last cpp script in eastern plaguelands after these
(cherry picked from commit d308d471c1385dc06f8a63e4099c30f246af0fa8)
Fix charmed flags for npcs involved with
* Basic Chemistry
* Killing two scourge with one skeleton
* Army of the Damned
(cherry picked from commit e4bbde02d2d1c9facc7e6f77210f154321295342)
* Ducals horse will no longer start wp when the freed alliance prisoner mounts wp will now only start when player mounts
* Quest credit given to stored target rather than closest player on wp complete
* On player dismounting or player not mounting for 5 mins after spawn will cause ducals horse to despawn
* Silverbrook Worgen will despawn when OOC rather than these building up making quest harder for next player.
(cherry picked from commit 6c351c5160ec28bab439d51670f552f452ec5489)
event flags again.
(cherry picked from commit 2730576823c6733a6201426019ddca3f7dbba081)
Remove space
(cherry picked from commit c07bd6d467856c2fe2de742abe6bc60aec315750)
Even though this was meant to have been fixed once the last commit did not actually fix this
also condition for the periodic spell so that it only targets silverbrook worgen rather than agroing neutral deers and stags, hostile npcs like bears and conquest hold guards will still attack the horse but the condition prevents the periodic threat spell from hitting anything other than silverbrook worgen.
(cherry picked from commit f7f00d2f08e862dd7ec047b93a595f9f675bbdcf)
* Appeasing the Great Rainstone/Gods like Shiny Things update so sai actually works on sholazar guardians so sai runs on charmed creature, also rescript glinting dirt as previous had stopped working
* Teleport This! Charmed flags are needed here so that credit spell is cast when payer uses controlled npc to blow up teleporter.
* Updates to blueleaf tubers as previous fix stopped working due to negative respawn time on spell focus objects
(cherry picked from commit ebc0190d3b68555bfae4b2b1d2ea0409ef1035c7)
The timed action lists for this script now need event flags so they run while charmed and so that Karsius actually gets summoned.
(cherry picked from commit 79578eab4063e77369659e120d484cd42e519766)
Rename 2016_09_14_03_world.sql to 2016_09_14_03_world.sql
(cherry picked from commit 6913286cb9a367321b9876c789d264a0dd4ed300)
* NPC should turn towards invoker and stay facing for a short duration before turning back towards pillar when says line asking about his dog.
* Npc should only have fork equipped when he turns towards player at all other times has hammer equipped
* Added script for when periodically hammers the notice pillar
(cherry picked from commit 2b992d4cb0c1764c3b3e0f4d314b338fe74a96f6)
http://www.wowhead.com/quest=7493/the-journey-has-just-begun should become available when either level 60 or 80 version of Onyxias head quest is turned not only the level 60 version
(cherry picked from commit 01e5a5b4e799dc5448dd25ea663288bb3caf8593)
Remove all loot from summoned zombie http://www.wowhead.com/npc=10698/summoned-zombie as these npcs where rather generous on TC as they are meant to drop no loot.
(cherry picked from commit 0a4b4dec0994d80a2409923511771bd662ea8dfb)
1) Update to conditions for Zombiefest as previous conditions appear to have stopped working correctly
2) Update for Dark Subjugator to prevent these becoming bugged, also correct unit flags for the sentrys to prevent these from agroing player if too close and dropping immune subjugator if killed
3) Conditions to prevent console spam from Bone Warrior closes#17655
(cherry picked from commit c515cdc636beefa83bb1a022a18f34ca053dcd53)
1) http://www.wowhead.com/quest=11631/vision-of-air so there is actually visual rather than quest been immedietly completed when quest item used
2) Event for turn in of http://www.wowhead.com/quest=11695/the-horn-of-elemental-fury
3) A small fix for Subjugated Iskalder so this npc has to be taken back the the bone witch rather than credit been given on spawn and npc not moving (due to bad follow action),
(cherry picked from commit e7cfb08cb5dce8c99d2e4f70d287a76deba70a98)
1) Venomhide Hatchling - add text emotes for when fed.
2) Silkwing Larva - Metamorphis into Silkwing.
3) Fix Rise, Obsidion, The Emissary and last 3 quests from Battle at Valhalas Chain again since previously using sai action to start attack would force remove immune_to_pc flags.
(cherry picked from commit 21430746b62be066d333bf511c8725b3460f0082)
1) Fix http://www.wowhead.com/quest=1144/willix-the-importer so this quest does not complete as soon as taken so that players actually have to do the escort before been able to return quest
2) Remove XP at kill from several creatures which dont give xp on retail
3) Put alliance/horde versions of Reigns of the Grand War Mammoth (VOA) into seperate loot groups so chance for drop is actually 1% rather than been 1% chance of reference loot been called then been a 50/50 chance of which factions mount dropped which in fact reduced chance to 0.5% as if opposite factions dropped then not visible
4) Update to text target for one text from Rohin the Decaying
5) Move spell focus for http://www.wowhead.com/quest=12569/crocolisk-mastery-the-ambush so its on top of log and not behind it so position matches doing quest on retail
(cherry picked from commit f941dad158a4bce837e5ab89d4af5502b33570b7)
* Corrections to vehicle id and spells (Soo-holu previously had vehicleid 134 in sniff both are 257)
* Move spell focus for summoning Soo-holu with http://www.wowhead.com/item=39266/tainted-crystal to correct place
* On summon texts for when summoned
* Add some broadcasttext ids I forgot to add in my last commit.
(cherry picked from commit c42f0bd83049385b20d2b53524f7459103ec57df)
Add missing reward mail when either version of Return to the Orphanage in Shattrath is returned
Horde (185) - Subject: Thank you! Body: Dear, $n,$B$BThank you for taking me out during Children's Week. Lady Liadrin, the leader of the Blood Knights, has asked that I be released to her custody for training in Silvermoon City!$B$BI just wanted to thank you for taking me to see my friend, Hch'uu, as well as the Dark Portal, the Throne of the Elements, and the Caverns of Time. I like my toy dragon very much!$B$BI'm sure that you're taking good care of my pet. Please tell him that I miss him!$B$BSincerely,$B$BSalandria
Alliance (184) - Subject: Thank you! Body: $n,$B$BThank you for the time that we spent together during Children's Week. Did you know that Farseer Nobundo has asked the orphan matron to allow me to study with him at the Exodar?$B$BThank you for taking me to all of those neat places, and to visit my brother, Jheel. I miss him almost as much as I miss you. And, the Ring of Observance, the Dark Portal and the Caverns of Time were neato!$B$BI'm sure that you're taking good care of my pet. Tell him that I miss him, too!$B$BLove,$B$BDornaa
(cherry picked from commit e4a22f94e79a538b3adef64f619964b384b4b843)
Actually add the sql to last commit
(cherry picked from commit 9566b94688a17f7480e89d6627ca6d43f93125c7)
When you accept quest where you receive item to summon Goregek, Dajik, Zepik, Lafoo, Jaloot or Moodle the guardian for which player just received item is also summoned automatically.
(cherry picked from commit 4a85b652f2ebb601dae8fd7be2857daff9b1d8c1)
Waypoints again since have more experience and had a lot more wp than needed previously
A couple of cosmetic fixes for this quest
(cherry picked from commit 732ec94d9b38eee0acaed6b514292eb65f68b243)
Properly script http://www.wowhead.com/quest=11282/a-lesson-in-fear#comments so that you actually have to kill Winterskorn Defenders to get the named npcs to spawn, added missing texts for the yell for when they spawn
(cherry picked from commit 2640f37c665b2a11b7801f9e039ef7de1909ff83)
* Player mounts on gossip select rather than gymer only been summoned on gossip select and player still having to click vehicle to mount and sometimes a swarm of gymers been on spot
* Creature texts group ids 8 & 9 are exactly the same text which was previously both been displayed in sniff only displayed once
Creature text group 10 is dismount text but this never gets displayed as gymer despawns as soon as dismounted (this is bug as in sniff charmed by gets set to 0/0 and gymer says line then despawns a few seconds later on tc the vehicle despawns as soon as player dismounts, also
Edit
Delete post
Report this post
Information
Quote
Post#1 » 22 Mar 2016 19:04
Fix the mounting part of this so player gets mounted on gossip select instead of gossip only spawning and player still having to click gymer to actually mount once summoned
Creature texts group ids 8 & 9 are exactly the same text which was previously both been displayed in sniff only displayed once
Creature text group 10 is dismount text but this never gets displayed as gymer despawns as soon as dismounted (this is bug as in sniff charmed by gets set to 0/0 and gymer says line before despawn
Use the correct spell to summon gymer, previous used the spell which is triggered by the one that is meant to be used
get rid of the spellcast of ride vehicle hard coded as this is not used on this vehicle in sniff either. Also the line 'FREE!!! Soon you will feel the wrath of the storm king!'' is not part of script for the storm king's vengence as was previously scripted this is said on reward of http://www.wowhead.com/quest=12916/our-only-hope
* Use the correct spell to summon gymer, previous used the spell which is triggered by the one that is meant to be used
get rid of the spellcast of ride vehicle hard coded as this is not used on this vehicle in sniff either.
(cherry picked from commit bf4727c0f8e72786337361391c980caf42724548)
Rename 2016_04_22_00_world.sql to 2016_04_22_00_world.sql
(cherry picked from commit ddf8925bdef5fe7b54f01fad2676abae7d07fe74)
1) Rescript Natural Remedies with all visuals and event rather than only spawning Goliathon
2) Raging Colossus will now summon Raging Shardling
3) Added missing spells to event with Earthbinder Galandria when the Earthbinder is turned in, also ensuring that the whisper takes places when quest taken from Tola'thion
(cherry picked from commit 7f00d185f4dd9fbb9da867c840b39f1174586ee3)
Use proper spells to summon enraged wyverns, gryphons, hippogryphs and felbats instead of directly summoning with SAI action 12, also remove second line of all scripts as all of these used 2 lines of sai to summon two npcs on agro, the spells summon 2 in one cast so only one line needed.
(cherry picked from commit 83efabefe896146cf6d55d0341abed2a47c7459f)
1) Despawn npcs summoned by flight masters when ooc
2) Demon Portal Guardian Script by @Kodekc
3) Correct Broadcast text id for Vim'gol the Vile by @tkrokli closes#16882
(cherry picked from commit 9ed4bb4ad135eaa4caa23eccdc5166944f237272)
Closes#16891
Condition is to shut up Wintersorn Berserker which otherwise still speaks ooc.
(cherry picked from commit 1f7d6ee93a5950420807ad0878224601d39a2b8a)
* Few Updates for Grizzly Hills Giant and Runed Giant so these actually enter into combat and fight each other
* Grizzly Hills Giants above Thor Modan will throw the occasional tree as well as boulders
* Player texts for the Runic Prophecys
(cherry picked from commit ddb5c0bf96bd8fae6b6c3fefa392adcb63c7fa7e)
1) Respawn Shredder Parts for Outland Sucks
2) Fix How to Serve Goblins so Moh, Manni and Jakk walk out of cage and say line instead of doing nothing
3) Script Foreman Razelcraz, Maiden of Grief, Gan''arg Sapper and Camera Shaker
4) Script a couple of turn in events.
(cherry picked from commit 993c266260ff6c30f788e530b314d6fb7f457ea0)
Closes#16746
The update to gameobjet flags is a hack but this object even though should be clickable should not despawn this is due to been temp spawned by spell similar issue as with https://github.com/TrinityCore/TrinityCore/issues/12842
(cherry picked from commit df7554b6ea4dee16853811fe02b4e70fe2c9e957)
Updates my previous script from before I actually sniffed this
The Aldur'thar Sentry will now actually grab the Dark Subjugator and drop of edge,
(cherry picked from commit 431da2ffc9844f7cedaa481b7765ff1cf09a4eb6)
* script turn in event with ghostwing grabbing Olakin Sainrith
* phasing at Blackwatch
will also kill Table `vehicle_template_accessory`: creature template entry 31432 has no data in npc_spellclick_spells from previous commit
(cherry picked from commit 1cb718d9e77d58a08f0f3f3fbcea863ff837f6d3)
Properly script http://www.wowhead.com/quest=12243/fire-upon-the-waters
1) Delete the kill credit npcs which do not exist in sniff
2) Spawn the proper bunnies for this quest
3) Add missing burning effect
(cherry picked from commit a3b2144750d4824a6b3d94766e7019f940a9a470)
Fix a problem, previous worked for me due to have duplicated timed action lists as originally got id wrong ie 22335 instead of 22355, had corrected id but failed to update the action to call timed action lists but failed to spot this has had timed action lists with both ids.
(cherry picked from commit c0c94d0e3179cdd336783890116f0cb7afbda5ca)
Script all instances of Kwee Q. Peddlefeet to give option to give Lovely Charm Collector's Kit. Player does not need quest for this option to be available, gossip menu already existed in db and all but 2 of the Kwee Q. Peddlefeet already had gossip menu set in creature template but no gossip npc flags.
(cherry picked from commit 67b6f382878ea5d6c41bfe140e8210fbcf14dcc2)
Dr-J