[LF] Need DB developers for the Emucoach repack projects
What's new

Minor fixes v14 (Abyssal Depths)

Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
Location
France
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);
 
Last edited:
Jenniy

Jenniy

I collect profile flairs.
Gold Supporter
Silver Supporter
MoP Premium
Senior User
354
2020
72
A wonderful load of fixes, Thank you!
 
Likon69

Likon69

Mythical User
Silver Supporter
Superior Member
1,367
2020
595
Are these changes going to be added in the next update? Because I don't know how to fix it myself :(
 
Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
Location
France
Are these changes going to be added in the next update? Because I don't know how to fix it myself :(
Click to expand...

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

Likon69

Mythical User
Silver Supporter
Superior Member
1,367
2020
595
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.
Click to expand...
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

Blackvision

Mythical User
Super Moderator
Gold Supporter
2,316
2015
278
Location
Denmark
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
Click to expand...
Just take a backup of your world DB, so if something does brake, you just import the old one
 
Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
Location
France
Likon69 said:
I really don't want to study all this but thanks for the advice. I will wait for the update
Click to expand...

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
Click to expand...

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.

heidi.png
 
Last edited:
Kein666

Kein666

Gold Supporter
Veteran Member
96
2019
47
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
 
Likon69

Likon69

Mythical User
Silver Supporter
Superior Member
1,367
2020
595
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.
Click to expand...
Wow that's good, I'm a developer now: D. Thank you to all of you.
I successfully saved and corrected the database!
 
You must log in or register to reply here.
Top