Recent content by kureji

Thanks for the update! You might want to have future updates in code blocks next time, hit the triple dots and then then </> button, set the language to SQL and then your code will look like this: DELETE FROM `creature_text` WHERE `entry` = 53494; INSERT INTO `creature_text` VALUES (53494, 0...

Here is the SQL code for your suggested change. UPDATE creature_template_addon SET auras=0 WHERE entry=25596;

I ran this dungeon and saw Dathorohan was level 62 and I was like... that can't be right let me check what he was in cata. So according to https://wowpedia.fandom.com/wiki/Balnazzar_(tactics) in cataclysm, they got rid of the grand crusader phase and it's just balnazaar waiting for you in strat...

So while fixing the tier 11 for the vendors, I noticed two errors in the DBC. The first is that there isn't an entry for an item cost of Leggings of the Forlorn Protector, they all require that and the normal version of the pants, I believe 3097 was supposed to be just the token but it's a...

Next up I needed to update the inventory of the justice quartermaster to tier 12 level. I was a little smarter this time around and utilized variables to minimize my manual data entry. SELECT 1 INTO @slot; -- variable for keeping track of slot number SELECT 3038 INTO @j22; -- declare...

So I was looking through the VP and JP vendors and realized that their inventory isn't correct for 4.3.4 and also that an NPC was missing from Orgrimmar. So I decided to work on updating their inventory (and oh boy what a job this is) First this will add the missing NPC: -- missing NPC Rugok...

Thanks for the update, btw the second code snip has an extra comma

While going through ZF, I was attacked by the dustwraith rare elite and noticed that he was not attackable despite being aggressive. Had to use gm codes to kill him. Looked through the db and found his unit flags and faction were not correct. This fixes it: --...

I was able to complete the Nexus but I don't remember the part with the drakes, that part may still be broken but I was able to beat every boss and complete all the quests. Well now that I think about it.. there was a room with a skull on the map but I couldn't figure out how to make a boss...

So I was running The Nexus on normal and I noticed that the Crysalline Frayers levels were all over the place. Checking the database it showed level 66-80. That didn't mesh with what I remember from my WOTLK days so I looked up what they should be. Took me a while to finally find a video of...

Due some chat on the discord, I looked more into Goram and how he never had loot available. Apparently there are two Gorams and the wrong one was placed in Orgrimmar. This should switch it to the correct Goram, or at least the not bugged goram. UPDATE creature SET id = 46572 WHERE guid=171241...

[Location, Faction, Race] Scholomance, Horde. All characters I've tried. [Name, Type] Lady Illucia Barov, creature (10502) [Problem Description] Summons two level 70 "Summoned Bloodwarder Reservist" (id 20078) every 60 seconds. [How it should work] This boss should not be summoning any mobs...

This might be a bug that is blizz-like, not sure... Jandice Barov spawns adds that are level 61 despite scholo being scaled down for Cata. This will fix the stats to be closer to what they should be. -- https://www.wowhead.com/npc=11439/illusion-of-jandice-barov UPDATE creature_template SET...

You're right, I missed the space. Thanks! Updated.

I wanted to try and fix the bugged out questline that starts your entry into Icecrown. Here are the fixes that I've applied Quest: Scourge Tactics The webbed crusaders had the wrong phase, easy enough fix. -- https://www.wowhead.com/quest=13008/scourge-tactics UPDATE creature SET phaseMask = 2...