[DiscordArchive] so will there be a table?
[DiscordArchive] so will there be a table?
Original source
its not so simple as converting that value
rektbyfaith
06-23-2023, 09:01 PM #11Archived author: Tea • Posted: 2023-06-23T21:01:15.815000+00:00
Original source
its not so simple as converting that value
Original source
you need to know what the previous value in that field was
rektbyfaith
06-23-2023, 09:01 PM #12Archived author: Tea • Posted: 2023-06-23T21:01:28.480000+00:00
Original source
you need to know what the previous value in that field was
Original source
oh joy
rektbyfaith
06-23-2023, 09:01 PM #13Archived author: Malcrom • Posted: 2023-06-23T21:01:45.712000+00:00
Original source
oh joy
Original source
```sql
-- Loot for Abandoned Treasure Chest
SET @ID := 99780;
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,5376,0,100,0,1,0,1,1,'Abandoned Treasure Chest - Broken Mirror'),
(@ID,5368,0,100,0,1,0,1,1,'Abandoned Treasure Chest - Empty Wallet'),
(@ID,174807,0,100,0,1,1,1,1,'Abandoned Treasure Chest - Stitched Cloth Belt'),
(@ID,174808,0,100,0,1,2,1,1,'Abandoned Treasure Chest - Stitched Leather Cinch'),
(@ID,174809,0,100,0,1,3,1,1,'Abandoned Treasure Chest - Linked Mail Chain'),
(@ID,174810,0,100,0,1,4,1,1,'Abandoned Treasure Chest - Dented Plate Waistguard');
-- Conditions for class loot
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=99780 AND `SourceEntry` IN (174807,174808,174809,174810) AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(4,@ID,174807,0,0,15,0,400,0,0,0,0,0,'','Item drops for cloth wearer'),
(4,@ID,174808,0,0,15,0,3592,0,0,0,0,0,'','Item drops for leather wearer'),
(4,@ID,174809,0,0,15,0,4168,0,0,0,0,0,'','Item drops for mail wearer'),
(4,@ID,174810,0,0,15,0,35,0,0,0,0,0,'','Item drops for plate wearer');
```
rektbyfaith
06-23-2023, 09:02 PM #14Archived author: Malcrom • Posted: 2023-06-23T21:02:20.079000+00:00
Original source
```sql
-- Loot for Abandoned Treasure Chest
SET @ID := 99780;
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,5376,0,100,0,1,0,1,1,'Abandoned Treasure Chest - Broken Mirror'),
(@ID,5368,0,100,0,1,0,1,1,'Abandoned Treasure Chest - Empty Wallet'),
(@ID,174807,0,100,0,1,1,1,1,'Abandoned Treasure Chest - Stitched Cloth Belt'),
(@ID,174808,0,100,0,1,2,1,1,'Abandoned Treasure Chest - Stitched Leather Cinch'),
(@ID,174809,0,100,0,1,3,1,1,'Abandoned Treasure Chest - Linked Mail Chain'),
(@ID,174810,0,100,0,1,4,1,1,'Abandoned Treasure Chest - Dented Plate Waistguard');
-- Conditions for class loot
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=99780 AND `SourceEntry` IN (174807,174808,174809,174810) AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(4,@ID,174807,0,0,15,0,400,0,0,0,0,0,'','Item drops for cloth wearer'),
(4,@ID,174808,0,0,15,0,3592,0,0,0,0,0,'','Item drops for leather wearer'),
(4,@ID,174809,0,0,15,0,4168,0,0,0,0,0,'','Item drops for mail wearer'),
(4,@ID,174810,0,0,15,0,35,0,0,0,0,0,'','Item drops for plate wearer');
```
Original source
that is from this chest
rektbyfaith
06-23-2023, 09:02 PM #15Archived author: Malcrom • Posted: 2023-06-23T21:02:29.254000+00:00
Original source
that is from this chest
Original source
I assume a quest for the chest and one for the loot?
rektbyfaith
06-23-2023, 09:02 PM #16Archived author: Malcrom • Posted: 2023-06-23T21:02:48.390000+00:00
Original source
I assume a quest for the chest and one for the loot?
Original source
```sql
SET @OGUID := 100000001;
-- Abandoned Treasure Chest
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,339770,2175,10424,10453,0,0,0,0,-1,-108.31944,-2448.0696,15.123479,3.8863368,-0.0104961395,-0.01776886,-0.93119335,0.36394104,7200,255,1,'',44730);
-- Add addon data
DELETE FROM `gameobject_template_addon` WHERE `entry`=339770;
INSERT INTO `gameobject_template_addon` (`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`,`artkit4`,`WorldEffectID`,`AIAnimKitID`) VALUES
(339770,0,2113536,2,18,0,0,0,0,0,0,0);
```
rektbyfaith
06-23-2023, 09:03 PM #17Archived author: Malcrom • Posted: 2023-06-23T21:03:39.320000+00:00
Original source
```sql
SET @OGUID := 100000001;
-- Abandoned Treasure Chest
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,339770,2175,10424,10453,0,0,0,0,-1,-108.31944,-2448.0696,15.123479,3.8863368,-0.0104961395,-0.01776886,-0.93119335,0.36394104,7200,255,1,'',44730);
-- Add addon data
DELETE FROM `gameobject_template_addon` WHERE `entry`=339770;
INSERT INTO `gameobject_template_addon` (`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`,`artkit4`,`WorldEffectID`,`AIAnimKitID`) VALUES
(339770,0,2113536,2,18,0,0,0,0,0,0,0);
```
Original source
the chest
rektbyfaith
06-23-2023, 09:03 PM #18Archived author: Malcrom • Posted: 2023-06-23T21:03:42.771000+00:00
Original source
the chest
Original source
the chest is easy because its a vignette
rektbyfaith
06-23-2023, 09:05 PM #19Archived author: Tea • Posted: 2023-06-23T21:05:00.215000+00:00
Original source
the chest is easy because its a vignette
Original source
so it has data in Vignette.db2, that has a questid column
rektbyfaith
06-23-2023, 09:05 PM #20Archived author: Tea • Posted: 2023-06-23T21:05:13.695000+00:00
Original source
so it has data in Vignette.db2, that has a questid column
1 Guest(s)
1 Guest(s)