Minor fixes v14 (Abyssal Depths)

Stiga · May 23, 2021

NPC spawns

https://www.wowhead.com/npc=42114/alliance-sea-scout -- https://www.wowhead.com/quest=26125/secure-seabrush -- missing npcs

SQL:

-- https://www.wowhead.com/npc=42114/alliance-sea-scout -- missing npc for https://www.wowhead.com/quest=26125/secure-seabrush
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6041.74, 5859.73, -779.412, 3.51584, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -5939.96, 5906.44, -783.474, 4.25411, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -5980.89, 6066.88, -789.532, 4.7489, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6082.16, 6144.82, -797.22, 0.307462, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6059.15, 6062.09, -791.168, 5.40863, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6087.93, 6013.95, -787.892, 5.55156, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6121.82, 5962, -791.508, 1.08657, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6141.1, 5920.2, -798.947, 6.00788, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6184.52, 5930.48, -798.215, 0.203787, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6229.79, 5966.2, -795.902, 4.26744, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6211.4, 6000.31, -793.708, 4.7913, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/npc=41908/orako -- https://www.wowhead.com/quest=26086/orako -- missing npc

SQL:

-- https://www.wowhead.com/npc=41908/orako -- https://www.wowhead.com/quest=26086/orako -- missing npc
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 41908, 0, 5145, 4974, 1, 1, 0, 0, -6289.59, 6488.69, -865.304, 5.5524, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);

Quests:

https://www.wowhead.com/quest=26122/environmental-awareness -- https://www.wowhead.com/item=56821/oil-extrusion-pump -- item not working (work-a-round)

SQL:

-- https://www.wowhead.com/quest=26122/environmental-awareness -- item not working (work-a-round)
UPDATE quest_template SET RequiredItemID1 = 0 WHERE id=26122; -- value was 56818
UPDATE quest_template SET RequiredItemCount1 = 0 WHERE id=25972; -- value was 4
UPDATE quest_template SET RequiredItemID2 = 0 WHERE id=26122; -- value was 56819
UPDATE quest_template SET RequiredItemCount2 = 0 WHERE id=25972; -- value was 4
UPDATE quest_template SET RequiredItemID3 = 0 WHERE id=26122; -- value was 56820
UPDATE quest_template SET RequiredItemCount3 = 0 WHERE id=25972; -- value was 4

https://www.wowhead.com/quest=26088/here-fishie-fishie -- https://www.wowhead.com/item=56813/fish-hat -- item not working (work-a-round)

SQL:

-- https://www.wowhead.com/quest=26088/here-fishie-fishie -- https://www.wowhead.com/item=56813/fish-hat -- item not working (work-a-round)
UPDATE quest_template SET RequiredItemID1 = 0 WHERE id=26088; -- value was 56569
UPDATE quest_template SET RequiredItemCount1 = 0 WHERE id=26088; -- value was 30

https://www.wowhead.com/quest=26072/into-the-totem -- https://www.wowhead.com/item=56801/erunaks-confinement-totem -- item not working (work-a-round just kill npcs)

SQL:

-[URL='https://www.wowhead.com/quest=26071/clearing-the-defiled']- [/URL][URL='https://www.wowhead.com/quest=26071/clearing-the-defiled']https://www.wowhead.com/quest=26072/into-the-tot[/URL]em -[URL='https://www.wowhead.com/item=56801/erunaks-confinement-totem']- [/URL][URL='https://www.wowhead.com/item=56801/erunaks-confinement-totem']https://www.wowhead.com/item=56801/erunaks-confinement-tot[/URL]em -- item not working (work-a-round just kill npcs)
UPDATE quest_template SET RequiredNpcOrGo1 = 41644 WHERE id=26072; -- value was 42027

https://www.wowhead.com/object=203456/stonespeakers-luring-totem --gameobject not working manual spawn -- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- quest https://www.wowhead.com/quest=26111/it-will-come
https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- not hostile fix

SQL:

-- https://www.wowhead.com/object=203456/stonespeakers-luring-totem --gameobject not working manual spawn -- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- quest https://www.wowhead.com/quest=26111/it-will-come
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 41648, 0, 5145, 5103, 1, 1, 0, 0, -5647.59, 6311.62, -1079.42, 2.81285, 300, 0, 0, 45516, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- not hostile fix
UPDATE creature_template SET faction_a = 16 WHERE entry=41648; -- value was 35
UPDATE creature_template SET faction_h = 16 WHERE entry=41648; -- value was 35

-- https://www.wowhead.com/quest=26154/twilight-extermination -- https://www.wowhead.com/item=57172/attuned-runestone-of-binding -- item not working to bound (work-a-round kill npc instead

SQL:

-- https://www.wowhead.com/quest=26154/twilight-extermination -- https://www.wowhead.com/item=57172/attuned-runestone-of-binding -- item not working to bound (work-a-round kill npc instead)
UPDATE quest_template SET RequiredNpcOrGo1 = 47969 WHERE id=26154;-- values was 42343

-- https://www.wowhead.com/quest=26194/defending-the-rift -- (horde) -- https://www.wowhead.com/quest=26193/defending-the-rift -- (alliance) -- submarine event not working (work-a-round)
-- https://www.wowhead.com/npc=44540/legionnaire-nazgrim -- (horde) -- https://www.wowhead.com/npc=44490/captain-taylor -- (alliance) -- missing spawn after event

SQL:

-- https://www.wowhead.com/quest=26194/defending-the-rift -- (horde) -- https://www.wowhead.com/quest=26193/defending-the-rift -- (alliance) -- submarine event not working (work-a-round)
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=26194;-- value was 42565
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=26194; -- value was 1
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=26193;-- value was 42565
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=26193; -- value was 1
-- https://www.wowhead.com/npc=44540/legionnaire-nazgrim -- (horde) -- https://www.wowhead.com/npc=44490/captain-taylor -- (alliance) --  missing spawn after event
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 44540, 0, 5145, 5047, 1, 1, 0, 0, -5847.33, 5405.84, -1221.27, 5.68217, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 44490, 0, 5145, 5047, 1, 1, 0, 0, -5861.2, 5381.56, -1220.97, 5.63269, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);

Jenniy · May 24, 2021

A wonderful load of fixes, Thank you!

Blackvision · May 24, 2021

CADIRETO · May 24, 2021

Thank you!! great!

Kein666 · May 24, 2021

Tnx a lot!

Likon69 · May 24, 2021

Are these changes going to be added in the next update? Because I don't know how to fix it myself

Blackvision · May 24, 2021

Likon69 said:
Are these changes going to be added in the next update? Because I don't know how to fix it myself

Yes.

Stiga · May 25, 2021

Are these changes going to be added in the next update? Because I don't know how to fix it myself

A lot of these are not fixes, just work-a-rounds so players can advance as closely as possible to the original (quests etc) while real fixes are found and tested.
As for applying the fixes look for the guides and help here in the forum. I'm sure there are some posts on how to run SQL queries here somewhere.
First thing is to get a tool like HeidiSQL (free) and connect to the database.

Likon69 · May 25, 2021

Stiga said:
A lot of these are not fixes, just work-a-rounds so players can advance as closely as possible to the original (quests etc) while real fixes are found and tested.
As for applying the fixes look for the guides and help here in the forum. I'm sure there are some posts on how to run SQL queries here somewhere.
First thing is to get a tool like HeidiSQL (free) and connect to the database.

I installed HeidiSQL and managed to connect. But I can see that it's complicated. I'll wait for an update to avoid breaking my repack. Thanks for the info

Blackvision · May 25, 2021

Likon69 said:
I installed HeidiSQL and managed to connect. But I can see that it's complicated. I'll wait for an update to avoid breaking my repack. Thanks for the info

Just take a backup of your world DB, so if something does brake, you just import the old one

Likon69 · May 25, 2021

Blackvision said:
Just take a backup of your world DB, so if something does brake, you just import the old one

I really don't want to study all this but thanks for the advice. I will wait for the update

Stiga · May 26, 2021

Likon69 said:
I really don't want to study all this but thanks for the advice. I will wait for the update

I installed HeidiSQL and managed to connect. But I can see that it's complicated. I'll wait for an update to avoid breaking my repack. Thanks for the info

Well done by connecting.
You can just select the world database (make a copy first as suggested above just in case) and copy paste the code above into a querie (tab marked query) and run it.
(Run button is the blue arrow). As you can see I have some backup DBs.

Simplistic guide but I'm sure there are better more detailed ones somewhere here. Have a look.

Kein666 · May 26, 2021

Hi guys, for the right World database backup, after "Export database as SQL" these options are good? :

create database
create tables
data: insert
max insert size: 1024K
output: single .sql file

Blackvision · May 26, 2021

Kein666 said:
Hi guys, for the right World database backup, after "Export database as SQL" these options are good? :

create database

create tables

data: insert

max insert size: 1024K

output: single .sql file

Looks about right yes.

Likon69 · May 26, 2021

Stiga said:
Well done by connecting.
You can just select the world database (make a copy first as suggested above just in case) and copy paste the code above into a querie (tab marked query) and run it.
(Run button is the blue arrow). As you can see I have some backup DBs.

Simplistic guide but I'm sure there are better more detailed ones somewhere here. Have a look.

Wow that's good, I'm a developer now: D. Thank you to all of you.
I successfully saved and corrected the database!

warcraftlife · May 26, 2021

ExO · Jun 7, 2021

Executed in the upcoming V15 DB.
Thanks for your contribution!

Search

Minor fixes v14 (Abyssal Depths)

Stiga

Jenniy

I collect profile flairs.

Blackvision

CADIRETO

Kein666

Likon69

Blackvision

Stiga

Likon69

Blackvision

Likon69

Stiga

Kein666

Blackvision

Likon69

warcraftlife

ExO