Search results

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...

The NPCs you rescue for Emergency Response (Alliance version, Horde NPCs looked to already be fine) are supposed to be on the ground incapacitated. They were not. It's purely visual but I figured I'd fix it anyways while I was there. REPLACE INTO `creature_template_addon` (`entry`, `path_id`...

The quest "Get Back Here!" sends you back to Pearlfin Village to talk to a version of Admiral Taylor that isn't accessible. After some checking I found the phasing spell for it was not set to autocast so it was not being applied properly so you never see that spawn of Taylor. This will fix the...

In the uninstanced Temple of the Jade Serpent, Fei is supposed to offer two quests, and then a third after completing these. Unfortunately the exclusive groups were set to positive instead of negative numbers for these, which meant you could only do one of the two and be locked out of the other...

While leveling in Jade Forest I got repeatedly attacked by swarms of level 90 Siftworms while trying to do quests in the Arboretum, so I dug around a bit and found they're meant to be non-hostile unless you're on the Order of the Cloud Serpent daily for them. I set them to the proper faction the...

These were tested in 4.3.4 so I can't guarantee everything will work in MoP, yeah. It's possible they changed armor to not be a stat anymore there. Armor in Cata is typically automatically calculated based on item level, item type, and rarity. (Rarity is only factored in for earlier stuff...