[Problem Description] https://streamable.com/lx27km When you arrive near the village the npc/mount disappear
UPDATE creature set phaseMask=3 WHERE id IN (29639, 29708);
UPDATE creature_template SET speed_run=3 WHERE entry=29709;
UPDATE creature SET id=29709 WHERE id=29708;
[After Sql...
The Day that Deathwing Came seems not properly fixed in v16. 0. https://www.emucoach.com/forums/threads/v13-character-model-change.7321/post-79320
I got this screen from a friend ,sadly I'm not able to reproduce the bug and become invisible but I found a way to avoid the insivible issue...
Hey guys,
I'm going to release a Custom Stairs Event and I would like to disable the ability to use the flying mount in certain zone (876 - GmIsland).
I made some attempt:
The 1st was adding a spell for certain area like here:
REPLACE INTO `spell_area` (`spell`, `area`, `quest_start`...
[Location, Faction, Race] Grizzly Hills--Dun Argol, Horde, Blood Elf.
[Name, Type] Bringing Down the Iron Thane, Quest.
[Problem Description] EMP doesn't remove the shield from Iron Thane Furyhammer and stun "The Anvil".
Befor: https://streamable.com/6okbob
[How it should work] I have removed...
This is a temp fix which prevents the boss from jumping in the air.
UPDATE spell_script_names SET spell_id=101815 WHERE ScriptName='spell_baine_pulverize';
Run this query to fix that.
UPDATE creature_template SET minlevel=85, maxlevel=85, faction_a=14, faction_h=14 WHERE entry=54995;
You can then fix the hp at your convenience from creature_template > Health_mod.
You should mount the cannons to see the boats...
The problem with this quest is that the cannon damage is too low to kill the boats.
This query should solve this problem.
UPDATE creature_template SET spell1=93729 WHERE entry=48283;
We have found the same problem. Just try to run this query in your world db...
UPDATE creature_template SET unit_flags=512 WHERE entry=38306;
Restart the server and then you should be able to complete the quest.
[Location, Faction, Race] Dragon Soul (Raid)
[Name, Type] Warlord Zon'ozz, Creatures
[Problem Description] Warlord Zon'ozz summons a Void of the Unmaking. This void travels forward until it encounters a player, then freezes and the boss casts "Black Blood Eruption" .
[How it should work] When...
[Location, Faction, Race] Throne of the Tides (Dungeon).
[Name, Type] Mindbender Ghur'sha, Creature
[Problem Description] When Eunak reaches 50% healt, Mindbender Ghur'sha does not come off from Erunak's head.
[How it should work] When the encounter begins, Mindbender Ghur'sha has taken...
If you already have his creature in "creature_template", just run the query.
Also use this query to update the gossip menu :
UPDATE creature_template SET gossip_menu_id=65000 WHERE entry=867584;
We had the same problem on v13.1 so i used his creature to make you choose the tp location.
UPDATE creature_template SET gossip_menu_id=65000 WHERE entry=867584;
DELETE FROM creature WHERE id = 867584;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`...
Character dying in Stormwind still get send to a wrong graveyard and miss the spirit healer for the Horde .
Here is a temp fix for V13.1. Should work for 13.0 too.
UPDATE game_graveyard_zone SET faction=0 WHERE id=854 AND ghost_zone=1519;
UPDATE game_graveyard_zone SET id=106, faction=469 WHERE...