Quilboar Treasures Exile's Reach

[malcrom]

Description

SQL for Quilboar Treasures. Cpp script to be added in future.

SQL fix

-- Quilboar Treasures full SQL
SET @OGUID := XXXXXXXX;

-- Spawn
DELETE FROM `gameobject` WHERE `guid`=@OGUID;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`phaseUseFlags`,`PhaseId`,`PhaseGroup`,`terrainSwapMap`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`ScriptName`,`VerifiedBuild`) VALUES
(@OGUID,329918,2175,10424,10588,0,0,0,0,-1,97.05903,-2497.2744,95.8364,2.089356,-0.10423422,-0.07056904,0.86100674,0.49277037,300,255,1,'',50000);

-- Addon data
DELETE FROM `gameobject_template_addon` WHERE `entry`=329918;
INSERT INTO `gameobject_template_addon` (`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`,`artkit4`,`WorldEffectID`,`AIAnimKitID`) VALUES
(329918,0,2113536,0,0,0,0,0,0,0,2437,0);

-- Tracker quest
DELETE FROM `quest_template` WHERE `ID` IN (56579,56571);
INSERT INTO `quest_template` (`ID`,`QuestType`,`RewardXPMultiplier`,`RewardMoneyMultiplier`,`RewardArtifactXPMultiplier`,`Flags`,`LogTitle`) VALUES
(56579,2,1,1,1,1024, '[Hidden Tracker] Quilboar Treasures Vignette'),
(56571,2,1,1,1,1024, '[Hidden Tracker] Quilboar Treasures');

-- Visibility condition
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=32 AND `SourceGroup`=8 AND `SourceEntry`=329918 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(32,8,329918,0,0,47,0,56579,64,0,1,0,0,'','Spawn of gameobject with entry 329918 requires Quest 56579 not rewarded');

-- Loot
SET @ID := 97512;
DELETE FROM `gameobject_loot_template` WHERE `Entry`=@ID;
INSERT INTO `gameobject_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(@ID,169819,0,100,0,1,0,1,1,'Quilboar Treasures - Handful of Blood Shards'),
(@ID,174803,0,100,0,1,1,1,1,'Quilboar Treasures - Stitched Cloth Bracers'),
(@ID,174804,0,100,0,1,2,1,1,'Quilboar Treasures - Stitched Leather Bracers'),
(@ID,174805,0,100,0,1,3,1,1,'Quilboar Treasures - Linked Mail Bracers'),
(@ID,174806,0,100,0,1,4,1,1,'Quilboar Treasures - Dented Plate Bracers');

-- Loot Conditions
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=@ID;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(4,@ID,174803,0,0,15,0,400,0,0,0,0,0,'','Item drops for cloth wearer'),
(4,@ID,174803,0,0,47,0,56571,64,0,1,0,0,'','Item drops if quest 56571 is not rewarded'),
(4,@ID,174804,0,0,15,0,3592,0,0,0,0,0,'','Item drops for leather wearer'),
(4,@ID,174804,0,0,47,0,56571,64,0,1,0,0,'','Item drops if quest 56571 is not rewarded'),
(4,@ID,174805,0,0,15,0,4168,0,0,0,0,0,'','Item drops for mail wearer'),
(4,@ID,174805,0,0,47,0,56571,64,0,1,0,0,'','Item drops if quest 56571 is not rewarded'),
(4,@ID,174806,0,0,15,0,35,0,0,0,0,0,'','Item drops for plate wearer'),
(4,@ID,174806,0,0,47,0,56571,64,0,1,0,0,'','Item drops if quest 56571 is not rewarded');

Branch

master

TC rev. hash/commit

TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win64, Release, Static) Using SSL version: OpenSSL 1.1.1t 7 Feb 2023 (library: OpenSSL 1.1.1t 7 Feb 2023) Using Boost version: 1.73.0 Using MySQL version: 80033 Using CMake version: 3.26.4 Compiled on: Windows 10.0.19045

[malcrom]

Closing this again because I plan on getting proper phasing for all chest and doing a pr with c++ scripts. Also I am closing not deleting the code so no need to get snotty with me.