Worgen Quest #853

kem008 · 2013-03-09T20:38:09Z

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

#833 bugged cinema can crash the worldserver.exe

Loukie · 2013-03-10T02:12:29Z

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;

Loukie · 2013-03-10T02:20:21Z

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;

kem008 · 2013-03-10T10:55:43Z

Oo so the problem it was with the quest flag?

kem008 · 2013-03-10T14:01:52Z

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

ImageDev · 2013-03-10T15:28:31Z

@Loukie please add these to PR.

kem008 · 2013-03-10T16:19:36Z

Okay but first we have fix the cinema on the worgen quests #833

Bootz · 2013-03-11T15:29:26Z

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.

kem008 · 2013-03-11T16:03:02Z

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.

Loukie · 2013-03-11T19:01:46Z

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?

kem008 · 2013-03-11T20:47:47Z

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.

Loukie · 2013-03-12T02:06:04Z

as far as i can remember the dk quest line work just fine.

Bootz · 2013-03-12T02:45:36Z

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.

Loukie · 2013-03-12T14:59:30Z

cant we just use the inport old repo db or did the structure change that much?

Loukie · 2013-03-12T15:11:10Z

@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?

kem008 · 2013-03-12T16:34:33Z

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?

Loukie · 2013-03-12T16:44:17Z

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

Loukie · 2013-03-12T16:48:23Z

noob question how do i add PR

Loukie · 2013-03-12T17:12:47Z

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, '');

kem008 · 2013-03-12T17:13:59Z

What is changed?

Loukie · 2013-03-12T17:19:30Z

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

Loukie · 2013-03-12T17:41:26Z

This is one of the changes

kem008 · 2013-03-12T17:51:01Z

oo man can you upload it again? :D
The picture was sned it in the uploading proccess

Loukie · 2013-03-12T18:12:33Z

the worgen on the left i had to add myself not sure if it is right but it looks better

Loukie · 2013-03-12T18:14:59Z

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.

Loukie · 2013-03-12T18:16:36Z

thx to all skiyfire staff for doing a g8 job so far

kem008 · 2013-03-12T18:17:59Z

Oo nice job man :D

kem008 · 2013-03-12T18:18:42Z

Here is my FULL world database :D
https://github.com/kem008/SkyfireEMU_FULL_DATABASE

Loukie · 2013-03-12T18:38:34Z

how far long are you with your stormglen village?
also is this the latest skyfire db v11

kem008 · 2013-03-12T19:37:04Z

Yee I have added everything and your sql too :D

Loukie · 2013-03-13T01:37:12Z

thx

ImageDev · 2013-03-13T02:15:31Z

@Loukie our db's will not matchup, thus the same as our older db...
Between structure changes we also.have re-guid'd a lot of the tables....
Hince why a lot of db work has to get corrected b4 tested for merger from PR's

Loukie · 2013-03-13T03:43:02Z

ok i understand thx @ImageDev

kem008 · 2013-03-13T09:06:14Z

Loukie did you tested the cinema in the worgen starting zone when we save somebody from the worgens with a horse and when we finish it we got a cinema and then the worldserver crash.
#833

Loukie · 2013-03-14T01:52:04Z

i have tested it yes and mine works 100% i havent had any crashes so far in worgen area or the worgen questline

Raydeon · 2013-03-14T03:11:05Z

Just so you know (and I KNOW I've said this before), I have all of the spawns for duskhaven 95-99% Correct. I also have the quest line working with full cinemas 100% blizzlike up through the transfer to the new area. However, I refuse to upload this until it is finished because I am simply sick of repeated bug reports for the same thing over and over again. If I upload this, then people move to the next area I haven't finished and spam the bug reporter EVEN THOUGH WE KEEP SAYING IT IS NOT FINISHED. Currently, my real job has most of my time taken up, so someday I will finish it and upload it. Most all of what I have seen in the Trinity 434 for the worgen area is either old, incomplete, or simply incorrect. I refuse to push more broken crap into the db, especially after all the hard work to fix all the bad crap that was in there before.

Baeumchen · 2013-09-22T13:14:58Z

This will fix, that you can't accept Quests. It's for every single Quest in the Worgen Quest Line, even for the class Quests. //Unfortunately i wasn't able to fix the Quest "Evacuate the Marchant Square" and "Salvage the Supplies".

//EDIT: Sql removed due to fix is in a File Pull Request now.

SkyFire · 2013-09-22T14:00:57Z

Please fork the repository. Make a proper Sql file and then issue a pull request. Then we will test it and you will get proper credit.

ghost assigned Raydeon Mar 12, 2013

Baeumchen mentioned this issue Sep 23, 2013

Fix can't accept Quests for Worgen Quest Line #936

Merged

kem008 unassigned Raydeon Aug 3, 2014

Worgen Quest #853

Worgen Quest #853

Comments

kem008 commented Mar 9, 2013

Loukie commented Mar 10, 2013

Loukie commented Mar 10, 2013

kem008 commented Mar 10, 2013

kem008 commented Mar 10, 2013

ImageDev commented Mar 10, 2013

kem008 commented Mar 10, 2013

Bootz commented Mar 11, 2013

kem008 commented Mar 11, 2013

Loukie commented Mar 11, 2013

kem008 commented Mar 11, 2013

Loukie commented Mar 12, 2013

Bootz commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

kem008 commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

kem008 commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

kem008 commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

Loukie commented Mar 12, 2013

kem008 commented Mar 12, 2013

kem008 commented Mar 12, 2013

Loukie commented Mar 12, 2013

kem008 commented Mar 12, 2013

Loukie commented Mar 13, 2013

ImageDev commented Mar 13, 2013

Loukie commented Mar 13, 2013

kem008 commented Mar 13, 2013

Loukie commented Mar 14, 2013

Raydeon commented Mar 14, 2013

Baeumchen commented Sep 22, 2013

SkyFire commented Sep 22, 2013