SkyFire.406a
SkyFire.406a copied to clipboard
ProjectSkyfire
Worgen Quest
Something bugged with this quest because it is on the Questrelation and Involved relation and it isnt has any quest chain but the npc dont want to give me the quest I have to add it with gm commands
http://www.wowhead.com/quest=14404 http://www.wowhead.com/quest=14405
https://github.com/ProjectSkyfire/SkyFireEMU/issues/833 bugged cinema can crash the worldserver.exe
try this myne works 100%.
-- Escape By Sea
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14405;
-- Not Quite Shipshape
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14404;
Here is some more fixes for duskahvaen
-- Grandma's Cat
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14401;
UPDATE creature_template SET faction_A = 68, faction_H = 68 WHERE entry = 36461;
DELETE FROM creature WHERE id=36461;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(15456176, 36461, 654, 1, 1, 0, 0, -2094.98, 2336.6, 8.01807, 2.16393, 300, 0, 0, 343, 0, 0, 0, 0, 0);
-- Ready to Go
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14402;
-- Hold the Line
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14347;
-- You Can't Take 'Em Alone
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14348;
UPDATE quest_template SET ReqCreatureOrGOId1 = 36231 WHERE entry = 14348;
-- Holding Steady
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14366;
-- The Allens' Storm Cellar
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14367;
-- Escape By Sea
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14405;
-- Not Quite Shipshape
UPDATE quest_template SET QuestFlags = 8 WHERE entry = 14404;
-- Unleash the Beast
UPDATE creature_template SET faction_A = 68, faction_H = 68 WHERE entry = 36810;
-- Two By Sea
DELETE FROM creature WHERE id=36283;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
(@, 36283, 654, 1, 65534, 0, 0, -2138.32, 2505.71, 4.84951, 5.89379, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2155.99, 2523.33, 5.12479, 5.60713, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2149.2, 2550.58, 4.22256, 5.72886, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2123.19, 2541.28, 5.47634, 5.88201, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2120.96, 2564.52, 5.32531, 5.8074, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2105.19, 2546.77, 4.97786, 6.10978, 300, 0, 0, 420, 0, 0, 0, 0, 0),
(@, 36283, 654, 1, 65534, 0, 0, -2077.58, 2604.6, 5.22659, 4.94997, 300, 0, 0, 1370, 0, 0, 0, 0, 0);
UPDATE creature_template SET minlevel = 7, maxlevel = 7, mechanic_immune_mask = 0 WHERE entry = 36283;
UPDATE creature_template SET unit_flags = 16384, type_flags = 393256, VehicleId = 438, movementId = 207 WHERE entry = 36283;
DELETE FROM npc_spellclick_spells WHERE npc_entry=36283;
INSERT INTO npc_spellclick_spells (npc_entry, spell_id, cast_flags, user_type) values(36283,69434,1,0);
UPDATE creature_template SET minlevel = 6, maxlevel = 7, faction_A = 68, faction_H = 68, mingold = 7, maxgold = 11, Health_mod = 137.0 WHERE entry = 36397;
UPDATE creature_template SET minlevel = 6, maxlevel = 7, faction_A = 68, faction_H = 68, mingold = 7, maxgold = 11, Health_mod = 137.0 WHERE entry = 36399;
-- dark ranger
UPDATE creature_template SET faction_A = 16, faction_H = 16 WHERE entry = 36312;
Yee I fixed a lot of quest now and I have added a custom quest to get out from gilneas and I have added some spell to learn it with thequest end script runnig wild and the apprentice riding :D
Okay but first we have fix the cinema on the worgen quests https://github.com/ProjectSkyfire/SkyFireEMU/issues/833
be patient, when Raydeon has these quests done he, he will move them into repo, if your wanting to help, submit a Pull Request, and assign it to him. adding reports for areas unfinished or not yet gotten to... only helps very little... to none. bcuz we are mostly aware of the issues that lay ahead of us... alot of times we have to work our way up to the problem, to fix them, (ie: quest chains) as not to break prequels, or anything else involved with the bugged, or broken quest/item/npc/spell/go/ etc.
Ok I cant upload the fixes of the world database I can only update my fully world database Because I dont know what I did for fix the worgen quest lines.
at this point it is pointless working on the quest line because the phasing for this map is not correct for now it will help but in the long run it will cost you double work to fix everything again after the phasing is corrected @ImageDev the database fixes i have added came from skyfire forum some time back i was surprised to see that it was not applied in the new databse repo and there is still problem with creature 36283 in duskhaven you cant mount them im not sure but i thing there phasemask is also wrong it is 65534 i think it must me 1?
Ye a lot of problem but I am making an update for the worgen quest lines but idot knownow what i have fixed XD. I am thinking about the dk quest lines end I think it isnt has quest start and quest end scripts. Because I tested a monsterwow repck database on the skyfire emu and the dk end was worked fine.
somethings didn't make it into master db branch, from SQL/updates/world... (the fun of split a project(core/db), right arm forgets to talk to left, things get overlooked.) been catching alot of things that was fixed in core repo SQL(or not grandfathered in from old World SQL) that went missing not just from this updatepack but every update pack, for some reason there's been some dropped SQL imports or just missed them (since like rev.4/5) the joy is, figuring out which ones.
@Loukie someone has bjorked dk's with autocompletes and shit... (this area was near blizzlike) im going through them slowly try and get back to the way it was prior... db side gotten hosed... the script side was pretty much unphased by these changes.
cant we just use the inport old repo db or did the structure change that much?
@Bootz i had a look at TrinityCore last night and notice they too are using C++ and the way they code is very similar to SkyfireCore maybe we can compair our core scripts to TrinityCore maybe we are lucky and it work same for the database?
If I have to make a sql updates it take a lot of time for me. Can I make a db repo with the full database?
it is better to build on the structure we have if you want to use your db repo you will have to make sure it is 100% the same as ours tabel names and columns
hey @Bootz here is an update i have done from Trinity i had to restructure because there stucture is not the same this is creature_template_addon_for_Map_Duskhaven_654. please have a look at this and let me know
DELETE FROM `creature_template_addon` WHERE `entry` IN (36198,36698,36798,36797,36449,36286,36453,36628,36631,36602,50247,34571,36132,36170,50252,36652,36695,36632,36190,36630,36713,36629,44125,50567,38791,50574,36651,36717);
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(36198, 0, 0, 0x0, 0x1, 0, ''),
(36698, 0, 0, 0x0, 0x1, 0, '69196'),
(36798, 0, 0, 0x0, 0x1, 0, '69196'),
(36797, 0, 0, 0x0, 0x1, 0, '69196'),
(36449, 0, 0, 0x0, 0x1, 0, ''),
(36286, 0, 0, 0x0, 0x1, 0, ''),
(36453, 0, 0, 0x0, 0x1, 0, ''),
(36628, 0, 0, 0x0, 0x1, 0, ''),
(36631, 0, 0, 0x0, 0x1, 0, ''),
(36602, 0, 0, 0x0, 0x2, 0, ''),
(50247, 0, 0, 0x0, 0x1, 0, ''),
(34571, 0, 0, 0x0, 0x1, 0, ''),
(36132, 0, 0, 0x0, 0x1, 0, ''),
(36170, 0, 0, 0x0, 0x1, 0, ''),
(50252, 0, 0, 0x0, 0x1, 0, ''),
(36652, 0, 0, 0x0, 0x1, 0, ''),
(36695, 0, 0, 0x0, 0x1, 0, ''),
(36632, 0, 0, 0x0, 0x1, 0, ''),
(36190, 0, 0, 0x3, 0x1, 0, ''),
(36630, 0, 0, 0x8, 0x1, 0, ''),
(36713, 0, 0, 0x0, 0x1, 0, ''),
(36629, 0, 0, 0x0, 0x1, 0, ''),
(44125, 0, 0, 0x0, 0x1, 0, ''),
(50567, 0, 0, 0x0, 0x101, 0, ''),
(38791, 0, 0, 0x0, 0x1, 0, ''),
(50574, 0, 0, 0x0, 0x101, 0, ''),
(36651, 0, 0, 0x0, 0x1, 0, ''),
(36717, 0, 0, 0x0, 0x1, 0, '');
there was no entries for them so infact you can take out
DELETE FROM creature_template_addon WHERE entry IN (36198,36698,36798,36797,36449,36286,36453,36628,36631,36602,50247,34571,36132,36170,50252,36652,36695,36632,36190,36630,36713,36629,44125,50567,38791,50574,36651,36717);
INSERT INTO creature_template_addon (entry, path_id, mount, bytes1, bytes2, emote, auras
so you can stort query from INSERT INTO
oo man can you upload it again? :D The picture was sned it in the uploading proccess
the worgen on the left i had to add myself not sure if it is right but it looks better
i think for now i will work only on the spwans i can still remember more or less where npc must go from retail ill start working on quest once the aura problem is sorted.
Here is my FULL world database :D https://github.com/kem008/SkyfireEMU_FULL_DATABASE
how far long are you with your stormglen village? also is this the latest skyfire db v11