[DiscordArchive] And for progression system, I just realize, to enable Bracket 80_1, I need to enable all the Bracket
[DiscordArchive] And for progression system, I just realize, to enable Bracket 80_1, I need to enable all the Bracket
Original source
You can use something like aowow or even wowhead wrath classic
rektbyfaith
09-26-2024, 12:28 PM #21Archived author: Revision • Posted: 2024-09-26T12:28:40.981000+00:00
Original source
You can use something like aowow or even wowhead wrath classic
Original source
> I just realize, to enable Bracket 80_1, I need to enable all the Bracket from 80_1 onward right?
no, you can enable each individually, you just need to keep in mind the SQL apply/revert files
rektbyfaith
09-26-2024, 12:28 PM #22Archived author: Nyeriah • Posted: 2024-09-26T12:28:41.394000+00:00
Original source
> I just realize, to enable Bracket 80_1, I need to enable all the Bracket from 80_1 onward right?
no, you can enable each individually, you just need to keep in mind the SQL apply/revert files
Original source
> For instance, if I do something like this, then the progression system seems only apply 80_1 bracket sql and will not apply other bracket, which will cause the vendor still selling some S8 items, etc...
There could be a bug (I believe there is as I have experienced this before too, seems to be an issue with the latest brackets created)
rektbyfaith
09-26-2024, 12:30 PM #23Archived author: Nyeriah • Posted: 2024-09-26T12:30:20.418000+00:00
Original source
> For instance, if I do something like this, then the progression system seems only apply 80_1 bracket sql and will not apply other bracket, which will cause the vendor still selling some S8 items, etc...
There could be a bug (I believe there is as I have experienced this before too, seems to be an issue with the latest brackets created)
Original source
Yeah that's what I am doing recently
rektbyfaith
09-26-2024, 12:31 PM #24Archived author: JEDI • Posted: 2024-09-26T12:31:30.230000+00:00
Original source
Yeah that's what I am doing recently
Original source
INSERT INTO acore_world.disables (sourceType, entry, comment)
SELECT 1 AS sourceType, ID AS entry, 'Progressive Disabled' AS comment
FROM acore_world.quest_template
WHERE RewardItem1 = '49426'
AND LogTitle NOT LIKE '%Daily%';
UPDATE acore_world.quest_template
SET RewardItem1 = '47241'
WHERE RewardItem1 = '49426'
AND LogTitle LIKE '%Daily%';
UPDATE acore_world.quest_template
SET RewardItem1 = '45624'
WHERE RewardItem1 = '47241'
AND LogTitle LIKE '%Daily%';
SET RewardItem1 = '45624'
WHERE RewardItem1 = '47241'
AND LogTitle LIKE '%Proof%';
DELETE FROM acore_world.npc_vendor WHERE entry='40160';
INSERT INTO acore_world.spell_dbc (ID,RecoveryTime)
(55208,72000000);
rektbyfaith
09-26-2024, 12:31 PM #25Archived author: JEDI • Posted: 2024-09-26T12:31:49.553000+00:00
Original source
INSERT INTO acore_world.disables (sourceType, entry, comment)
SELECT 1 AS sourceType, ID AS entry, 'Progressive Disabled' AS comment
FROM acore_world.quest_template
WHERE RewardItem1 = '49426'
AND LogTitle NOT LIKE '%Daily%';
UPDATE acore_world.quest_template
SET RewardItem1 = '47241'
WHERE RewardItem1 = '49426'
AND LogTitle LIKE '%Daily%';
UPDATE acore_world.quest_template
SET RewardItem1 = '45624'
WHERE RewardItem1 = '47241'
AND LogTitle LIKE '%Daily%';
SET RewardItem1 = '45624'
WHERE RewardItem1 = '47241'
AND LogTitle LIKE '%Proof%';
DELETE FROM acore_world.npc_vendor WHERE entry='40160';
INSERT INTO acore_world.spell_dbc (ID,RecoveryTime)
(55208,72000000);
Original source
Not sure if the
INSERT INTO acore_world.spell_dbc (ID,RecoveryTime)
(55208,72000000);
works as expected
rektbyfaith
09-26-2024, 12:32 PM #26Archived author: JEDI • Posted: 2024-09-26T12:32:14.699000+00:00
Original source
Not sure if the
INSERT INTO acore_world.spell_dbc (ID,RecoveryTime)
(55208,72000000);
works as expected
Original source
Others should be fine
rektbyfaith
09-26-2024, 12:32 PM #27Archived author: JEDI • Posted: 2024-09-26T12:32:22.737000+00:00
Original source
Others should be fine
Original source
And just need to find out the S8 items, something fking huge
rektbyfaith
09-26-2024, 12:32 PM #28Archived author: JEDI • Posted: 2024-09-26T12:32:41.189000+00:00
Original source
And just need to find out the S8 items, something fking huge
Original source
lol
rektbyfaith
09-26-2024, 12:32 PM #29Archived author: JEDI • Posted: 2024-09-26T12:32:42.796000+00:00
Original source
lol
Original source
After doing this the database should have rolled back to 3.2.X like
rektbyfaith
09-26-2024, 12:33 PM #30Archived author: JEDI • Posted: 2024-09-26T12:33:14.350000+00:00
Original source
After doing this the database should have rolled back to 3.2.X like