Trinitycore: DB/Misc: fix Worgen intro

[ReyDonovan]

Description:
fix change phases start worgen area
CHANGEME Description of the problem or issue here.
not works
Current behaviour:

CHANGEME Tell us what happens.
If this is a crash, post the crashlog (upload to https://gist.github.com/).

Expected behaviour:

CHANGEME Tell us what should happen instead.

Steps to reproduce the problem:
fix test in game works

-- worgen intro
UPDATE `creature_template` SET `npcflag` = 0 WHERE `entry` = 34884; -- not questgiver

UPDATE `quest_template_addon` SET `ExclusiveGroup` = -14093 WHERE `ID` IN (14098, 14093);

DELETE FROM `conditions` WHERE `SourceEntry`=4756;
DELETE FROM `conditions` WHERE `SourceGroup`=170 AND `ConditionValue1`=14078;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(26, 169, 4756, 0, 0, 28, 0, 14078, 0, 0, 1, 0, 0, '', 'Phase 169 until Quest 14078 not complete'),
(26, 170, 0, 0, 0, 28, 0, 14078, 0, 0, 0, 0, 0, '', 'Phase 170 until Quest 14078 complete');


DELETE FROM `spell_area` WHERE `area`=4756;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
(59073, 4756, 14078, 0, 0, 0, 2, 1, 64, 0), -- phase 170
(49416, 4756, 14078, 0, 0, 0, 2, 1, 64, 0); -- Generic Quest Invisibility 1

Branch(es): master

CHANGEME 3.3.5, master or both

TC rev. hash/commit: 41c4fec

CHANGEME Copy the result of server debug command (if you need to run it from client get prat addon)

Operating system: CHANGEME OS win10 Pro

[shamage]

after I implemented the modifications, I received an error message

1054 - Unknown column 'autocast' in 'field list'

minor adjustment :

-- worgen intro
UPDATE `creature_template` SET `npcflag` = 0 WHERE `entry` = 34884; -- not questgiver
UPDATE `quest_template_addon` SET `ExclusiveGroup` = -14093 WHERE `ID` IN (14098, 14093);
DELETE FROM `conditions` WHERE `SourceEntry`=4756;
DELETE FROM `conditions` WHERE `SourceGroup`=170 AND `ConditionValue1`=14078;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(26, 169, 4756, 0, 0, 28, 0, 14078, 0, 0, 1, 0, 0, '', 'Phase 169 until Quest 14078 not complete'),
(26, 170, 0, 0, 0, 28, 0, 14078, 0, 0, 0, 0, 0, '', 'Phase 170 until Quest 14078 complete');
DELETE FROM `spell_area` WHERE `area`=4756;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES
(59073, 4756, 14078, 0, 0, 0, 2, 1, 64, 0), -- phase 170
(49416, 4756, 14078, 0, 0, 0, 2, 1, 64, 0); -- Generic Quest Invisibility 1

@ReyDonovan - good work , thanks - phasing is works :)

TrinityCore rev. c2d61e05cf3d 2018-06-29 22:38:38 +0200 (master branch) (Win64, RelWithDebInfo, Static)
Using SSL version: OpenSSL 1.0.2o 27 Mar 2018 (library: OpenSSL 1.0.2o 27 Mar 2018)
Using Boost version: 1.67.0
Using MySQL version: 5.7.21
Using CMake version: 3.11.1
Compiled on: Windows 10.0.17134
Automatic database updates are enabled for the following databases: Auth, Characters, World, Hotfixes
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in ./maps. Total size: 900650049 bytes
vmaps directory located in ./vmaps. Total size: 5127494765 bytes
mmaps directory located in ./mmaps. Total size: 6432765312 bytes
Using enUS DBC Locale as default. All available DBC locales: enUS
Using World DB: TDB 735.00

[ReyDonovan]

-- worgen intro
UPDATE `creature_template` SET `npcflag` = 0 WHERE `entry` = 34884; -- not questgiver

UPDATE `quest_template_addon` SET `ExclusiveGroup` = -14093 WHERE `ID` IN (14098, 14093);

DELETE FROM `conditions` WHERE `SourceEntry`=4756;
DELETE FROM `conditions` WHERE `SourceGroup`=170 AND `ConditionValue1`=14078;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(26, 169, 4756, 0, 0, 28, 0, 14078, 0, 0, 1, 0, 0, '', 'Phase 169 until Quest 14078 not complete'),
(26, 170, 0, 0, 0, 28, 0, 14078, 0, 0, 0, 0, 0, '', 'Phase 170 until Quest 14078 complete');

DELETE FROM `spell_area` WHERE `area`=4756;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES
(59073, 4756, 14078, 0, 0, 0, 2, 1, 64, 0), -- phase 170
(49416, 4756, 14078, 0, 0, 0, 2, 1, 64, 0); -- Generic Quest Invisibility 1

fix sql error
8 queries executed, 8 success, 0 errors, 0 warnings

[illfated]

@ReyDonovan & @shamage - F.Y.I. - if you want to see the SQL code syntax highlighted (MarkDown) for the code you put in your comments, you can use ```sql on top of your code blocks.

[shamage]

@illfated - edited :)

[dio85]

26 169 0 0 0 28 0 14078 0 0 0 0 0 Phase 170 until Quest 14078 complete
26 169 4756 0 0 8 0 14078 0 0 1 0 0 Phase 169 until Quest 14078 not complete
26 170 0 0 0 28 0 14091 0 0 0 0 0 Phase out 169 Quest 14078

work correcly for me.

[shamage]

@dio85 : your phasing ( phase 170 ) adjustment works on Map 654 , Area 4755 ?

or the command is needed : .mod phase 170

Command: .mod phase 170 [Player: Olive (GUID Full: 0x08000400000000000000000000000008 Type: Player Entry: 0 Low: 8) (Account: 1) X: -1631.771118 Y: 1305.292725 Z: 19.664343 Map: 654 (Gilneas2) Area: 4755 (Gilneas City) Zone: Gilneas Selected: (GUID Full: 0x00000000000000000000000000000000 Type: None Entry: 0 Low: 0)]

[dio85]

i not need the command :D work for me fully. Have many defext in my db, but panda and wod and legion spawned. Need much more work, but yeah :D

[dio85]

if u have 7.3.5 sniffs plss share for me! thanks :)

[dio85]

And the answer for, why have 2 169 phase... need 1 in-and out. if u dont go out 169,170 phase mob spawned on area... so that not very good for u

[shamage]

@dio85 :
I still do not know very much - I'm just learning the basics, so I do not even control the taste ( sniffs )
but I try to know what to do as soon as possible

[dio85]

Me2 :) the database is easy. core hard.. 💃

[msoky]

@Killyana could you merge this to master branch? thx :) it works well

[Killyana]

The phasing is wrong, I will cherry pick some stuff from 4.3.4 later.

[dio85]

why? in cataclysm use too 169,170, etc,etc phases. just wotlk use pahse 1,2.

[shamage]

@dio85 -
would it be possible to add a modification to phase 170 ? ( I mean passing from phase 169 to phase 170 )

[dio85]

Sure, in worgen are have many many phase change.... maybe 10.. 14... 15.. so ...