[DiscordArchive] maybe the corpse decays before the SAI despawntimer hits?
[DiscordArchive] maybe the corpse decays before the SAI despawntimer hits?
Original source
we have the same tc has atm
rektbyfaith
11-27-2021, 05:28 PM #11Archived author: Nyeriah • Posted: 2021-11-27T17:28:36.913000+00:00
Original source
we have the same tc has atm
Original source
if the forcedrespawn data was sent right away yeah you wouldn't have such issues
rektbyfaith
11-27-2021, 05:29 PM #12Archived author: Nyeriah • Posted: 2021-11-27T17:29:12.954000+00:00
Original source
if the forcedrespawn data was sent right away yeah you wouldn't have such issues
Original source
DespawnorUnsummon should be sent on death. to override the hardcoded values in the core
rektbyfaith
11-27-2021, 05:29 PM #13Archived author: Malcrom • Posted: 2021-11-27T17:29:21.758000+00:00
Original source
DespawnorUnsummon should be sent on death. to override the hardcoded values in the core
Original source
imo you could pr the sql as-is seeing how the sql is fine
rektbyfaith
11-27-2021, 05:30 PM #14Archived author: Nyeriah • Posted: 2021-11-27T17:30:44.379000+00:00
Original source
imo you could pr the sql as-is seeing how the sql is fine
Original source
then I or someone else could look into that issue with the forced update
rektbyfaith
11-27-2021, 05:31 PM #15Archived author: Nyeriah • Posted: 2021-11-27T17:31:18.839000+00:00
Original source
then I or someone else could look into that issue with the forced update
Original source
It used to work perfectly in TC unless they broke it
rektbyfaith
11-27-2021, 05:34 PM #16Archived author: Malcrom • Posted: 2021-11-27T17:34:10.080000+00:00
Original source
It used to work perfectly in TC unless they broke it
Original source
Also I notice sometimes the loot system doesn't drop anything when it should. Thats weird
rektbyfaith
11-27-2021, 05:35 PM #17Archived author: Malcrom • Posted: 2021-11-27T17:35:31.492000+00:00
Original source
Also I notice sometimes the loot system doesn't drop anything when it should. Thats weird
Original source
```
-- Update loot for Entry 1508 : Young Scavenger
SET @NPC := 1508;
DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@NPC,0,@REFBEAST,100,0,1,0,1,1, 'Young Scavenger - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,@REFBEAST,30,0,1,1,1,1, 'Young Scavenger - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,11111,.2,0,1,0,1,1, 'Young Scavenger - (Small Pouch ReferenceTable)'),
(@NPC,0,@REFGREY0,20,0,1,0,1,1, 'Young Scavenger - (Grey 1-5 EXP 0 ReferenceTable)'),
(@NPC,3265,0,90,1,1,0,1,1, 'Young Scavenger - Scavenger Paw');
-- Update loot for Entry 1512 : Duskbat
SET @NPC := 1512;
DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@NPC,0,@REFBEAST,100,0,1,0,1,1, 'Duskbat - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,@REFBEAST,30,0,1,1,1,1, 'Duskbat - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,11111,.2,0,1,0,1,1, 'Duskbat - (Small Pouch ReferenceTable)'),
(@NPC,0,@REFGREY0,20,0,1,0,1,1, 'Duskbat - (Grey 1-5 EXP 0 ReferenceTable)'),
(@NPC,3264,0,90,1,1,0,1,1, 'Duskbat - Duskbat Wing');
```
rektbyfaith
11-27-2021, 05:38 PM #18Archived author: Malcrom • Posted: 2021-11-27T17:38:10.425000+00:00
Original source
```
-- Update loot for Entry 1508 : Young Scavenger
SET @NPC := 1508;
DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@NPC,0,@REFBEAST,100,0,1,0,1,1, 'Young Scavenger - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,@REFBEAST,30,0,1,1,1,1, 'Young Scavenger - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,11111,.2,0,1,0,1,1, 'Young Scavenger - (Small Pouch ReferenceTable)'),
(@NPC,0,@REFGREY0,20,0,1,0,1,1, 'Young Scavenger - (Grey 1-5 EXP 0 ReferenceTable)'),
(@NPC,3265,0,90,1,1,0,1,1, 'Young Scavenger - Scavenger Paw');
-- Update loot for Entry 1512 : Duskbat
SET @NPC := 1512;
DELETE FROM `creature_loot_template` WHERE `Entry`=@NPC;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@NPC,0,@REFBEAST,100,0,1,0,1,1, 'Duskbat - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,@REFBEAST,30,0,1,1,1,1, 'Duskbat - (Beast 1-5 EXP 0 ReferenceTable)'),
(@NPC,0,11111,.2,0,1,0,1,1, 'Duskbat - (Small Pouch ReferenceTable)'),
(@NPC,0,@REFGREY0,20,0,1,0,1,1, 'Duskbat - (Grey 1-5 EXP 0 ReferenceTable)'),
(@NPC,3264,0,90,1,1,0,1,1, 'Duskbat - Duskbat Wing');
```
Original source
These two have had empty loot which is impossible with the SQL shown
rektbyfaith
11-27-2021, 05:38 PM #19Archived author: Malcrom • Posted: 2021-11-27T17:38:48.701000+00:00
Original source
These two have had empty loot which is impossible with the SQL shown
Original source
```
-- Beast Reference loot for level 1 to 5
SET @REFBEAST := @REF + 2;
INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@REFBEAST,4865,0,40,0,1,1,1,1, 'Beast 1-5 - Ruined Pelt'),
(@REFBEAST,7074,0,30,0,1,1,1,1, 'Beast 1-5 - Chipped Claw'),
(@REFBEAST,7073,0,30,0,1,1,1,1, 'Beast 1-5 - Broken Fang');
```
rektbyfaith
11-27-2021, 05:39 PM #20Archived author: Malcrom • Posted: 2021-11-27T17:39:29.710000+00:00
Original source
```
-- Beast Reference loot for level 1 to 5
SET @REFBEAST := @REF + 2;
INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(@REFBEAST,4865,0,40,0,1,1,1,1, 'Beast 1-5 - Ruined Pelt'),
(@REFBEAST,7074,0,30,0,1,1,1,1, 'Beast 1-5 - Chipped Claw'),
(@REFBEAST,7073,0,30,0,1,1,1,1, 'Beast 1-5 - Broken Fang');
```
1 Guest(s)
1 Guest(s)