Recent content by orangefire

You can permanently spawn any NPC into the world using .npc add [ID] in-game GM command. Easiest way to find creature IDs is usually Wowhead, it shows them in the link after npc=. For example Goram the Horde guild vendor is 46572 since his Wowhead link is https://www.wowhead.com/npc=46572/goram...

I feel like it might be getting a bit spammy starting so many threads, so I renamed this one and will just add the rest of my work on Kun-Lai here. Fixed some quest requirements for the Muskraw Ranch chain. REPLACE INTO `quest_template` (`Id`, `Method`, `Level`, `MinLevel`, `MaxLevel`...

Fixed a couple quests that were available earlier than they should be here. REPLACE INTO `quest_template` (`Id`, `Method`, `Level`, `MinLevel`, `MaxLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `LimitTime`, `RequiredClasses`, `RequiredRaces`, `RequiredSkillId`, `RequiredSkillPoints`...

Binan Village mostly had issues with quests being available too early or not accessible at all. The Road to Kun-Lai was also flagged weirdly and not accessible. (This and most of my fixes are for the Alliance side of the questline for now. Once I run this character through everything I'll run...

Stoneplow had a few issues. Most prominently the phasing was messed up, all the NPCs in the village would disappear after completing Warn Stoneplow. The fields didn't have phasing implemented at all and several mobs had the wrong phasing, the quest progression was incorrect and several quests...

The quests in this area were rather out of order and some were inaccessible entirely. I reworked the quest progression for this series to match the intended order. Ambassador Han was also not spawned to the Alliance area at all so I added him where he's supposed to be. INSERT INTO `conditions`...

I noticed the quest Sha Can Awe was not working well, I wasn't getting credit which I later realized was only one of the two defender entries was actually scripted. I fixed the acolytes to have the proper scripting, made Anduin do his light explosion visual, and fixed the defenders to properly...

The Krasarang River area was being phased for the quest "Unsafe Passage" but never removing that phasing once the quest was complete, which meant some creatures needed for later quests in the series weren't accessible anymore. I fixed it to properly end the Unsafe Passage phasing after the quest...

When I did Crane Mastery: Needlebeak I was first struck by the presence of two copies of this unique named creature and second by the fact that it made no effort to attack me while I fought it, so I decided to pull the creature up in my database and figure out what was going on. For some reason...

The rare Qu'Nas in Karasang Wilds was punching me so I double checked Wowhead and confirmed he was in fact supposed to use a sword, so I fixed him to use the sword from the screenshots. Small detail but I figured it's still better to post the fix than not post it. UPDATE creature SET...

I noticed the quest progression of the Nessingwary Safari chain was a bit broken, so I setup the proper conditions with it. This will make it so that: Tortoise Mastery requires completion of Stag Mastery, Fox Mastery, and Mushan Mastery: Darkhide. Parental Mastery requires completion of...

This quest was being offered after you first meet Mudmug, which seemed weird and a bit confusing so I found its actual requirements and added them in as conditions so it won't be offered until the appropriate point. REPLACE INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`...

A lot of mobs in Stormstout Brewery were level 90 on normal even though it's a level 85 dungeon. I made some adjustments to set their levels to what they're supposed to be. UPDATE creature_template SET minlevel = 85, maxlevel = 85 WHERE entry IN (59461, 65522); UPDATE creature_template SET...

In the open world questline around Stormstout Brewery I noticed all the mobs would phase out as soon as I completed "Clear the Way". Not even turned in, just got my 10 kills and everything else disappeared rendering my other quests impossible to complete except theoretically with dropping and...

I noticed Mudmug was very unreliable about actually giving credit when gathering water so I dug into the quest a bit. His script was set to not repeat for some reason, so he would gather water, then could never credit it again unless he reset somehow. This will fix it to give the proper 4 credit...