[DiscordArchive] Mardum even had phasegroups right?
[DiscordArchive] Mardum even had phasegroups right?
Original source
Mardum even had phasegroups right?
rektbyfaith
12-02-2022, 06:25 PM #1Archived author: ModoX • Posted: 2022-12-02T18:25:25.786000+00:00
Original source
Mardum even had phasegroups right?
Original source
yep
rektbyfaith
12-02-2022, 06:26 PM #2Archived author: funjoker • Posted: 2022-12-02T18:26:09.139000+00:00
Original source
yep
Original source
and phaseuseflags
rektbyfaith
12-02-2022, 06:26 PM #3Archived author: funjoker • Posted: 2022-12-02T18:26:13.073000+00:00
Original source
and phaseuseflags
Original source
<:lul:995412674320019516>
rektbyfaith
12-02-2022, 06:26 PM #4Archived author: funjoker • Posted: 2022-12-02T18:26:16.548000+00:00
Original source
<:lul:995412674320019516>
Original source
it's actually kinda "hardcore"
rektbyfaith
12-02-2022, 06:26 PM #5Archived author: funjoker • Posted: 2022-12-02T18:26:24+00:00
Original source
it's actually kinda "hardcore"
Original source
but once you run Mardum
rektbyfaith
12-02-2022, 06:26 PM #6Archived author: funjoker • Posted: 2022-12-02T18:26:28.565000+00:00
Original source
but once you run Mardum
Original source
you prolly can fix any zone
rektbyfaith
12-02-2022, 06:26 PM #7Archived author: funjoker • Posted: 2022-12-02T18:26:35.803000+00:00
Original source
you prolly can fix any zone
Original source
ok still got some data here
rektbyfaith
12-02-2022, 06:27 PM #8Archived author: funjoker • Posted: 2022-12-02T18:27:45.748000+00:00
Original source
ok still got some data here
Original source
```sql
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-196030 AND `spell_effect`=193525 AND `type`=0;
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-193525 AND `spell_effect`=82238 AND `type`=0;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
(-196030, 193525, 0, ''),
(-193525, 82238, 0, 'Update Phase');
DELETE FROM `spell_area` WHERE `spell`=196030 AND `area`=7705 AND `quest_start`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES
(196030, 7705, 0, 40076, 0, 0, 2, 3, 64, 1);
DELETE FROM `serverside_spell_effect` WHERE `SpellID`=196030 AND `EffectIndex`=0 AND `DifficultyID`=0;
INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES
(196030, 0, 0, 6, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);
```
rektbyfaith
12-02-2022, 06:28 PM #9Archived author: funjoker • Posted: 2022-12-02T18:28:42.091000+00:00
Original source
```sql
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-196030 AND `spell_effect`=193525 AND `type`=0;
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=-193525 AND `spell_effect`=82238 AND `type`=0;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
(-196030, 193525, 0, ''),
(-193525, 82238, 0, 'Update Phase');
DELETE FROM `spell_area` WHERE `spell`=196030 AND `area`=7705 AND `quest_start`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES
(196030, 7705, 0, 40076, 0, 0, 2, 3, 64, 1);
DELETE FROM `serverside_spell_effect` WHERE `SpellID`=196030 AND `EffectIndex`=0 AND `DifficultyID`=0;
INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES
(196030, 0, 0, 6, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);
```
Original source
```sql
DELETE FROM `serverside_spell` WHERE `Id`=196030 AND `DifficultyID`=0;
INSERT INTO `serverside_spell` (`Id`, `DifficultyID`, `CategoryId`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `AttributesEx11`, `AttributesEx12`, `AttributesEx13`, `AttributesEx14`, `Stances`, `StancesNot`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryCategory`, `StartRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags1`, `AuraInterruptFlags2`, `ChannelInterruptFlags1`, `ChannelInterruptFlags2`, `ProcFlags`, `ProcChance`, `ProcCharges`, `ProcCooldown`, `ProcBasePPM`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `Speed`, `LaunchDelay`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `ContentTuningId`, `SpellName`, `ConeAngle`, `ConeWidth`, `MaxTargetLevel`, `MaxAffectedTargets`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `SpellFamilyFlags4`, `DmgClass`, `PreventionType`, `AreaGroupId`, `SchoolMask`, `ChargeCategoryId`) VALUES
(196030, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 8, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, -1, 0, 0, 0, 'Start: Quest Invis', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
```
rektbyfaith
12-02-2022, 06:28 PM #10Archived author: funjoker • Posted: 2022-12-02T18:28:46.810000+00:00
Original source
```sql
DELETE FROM `serverside_spell` WHERE `Id`=196030 AND `DifficultyID`=0;
INSERT INTO `serverside_spell` (`Id`, `DifficultyID`, `CategoryId`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `AttributesEx11`, `AttributesEx12`, `AttributesEx13`, `AttributesEx14`, `Stances`, `StancesNot`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryCategory`, `StartRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags1`, `AuraInterruptFlags2`, `ChannelInterruptFlags1`, `ChannelInterruptFlags2`, `ProcFlags`, `ProcChance`, `ProcCharges`, `ProcCooldown`, `ProcBasePPM`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `Speed`, `LaunchDelay`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `ContentTuningId`, `SpellName`, `ConeAngle`, `ConeWidth`, `MaxTargetLevel`, `MaxAffectedTargets`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `SpellFamilyFlags4`, `DmgClass`, `PreventionType`, `AreaGroupId`, `SchoolMask`, `ChargeCategoryId`) VALUES
(196030, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 8, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, -1, 0, 0, 0, 'Start: Quest Invis', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
```
1 Guest(s)
1 Guest(s)