[Accepted][Legion]: Time-Lost Proto-Drake loot

[Dallaryen]

Title: Time-Lost Proto-Drake loot
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/45012

Patch Content:

 

UPDATE `creature_template` SET `lootid`=32491 WHERE `entry`=32491;
DELETE FROM `creature_loot_template` WHERE `entry`=32491;

 

INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES (32491,44168,98,1,0,1,1)    -- Reins of the Time-Lost Proto-Drake
VALUES (32491,44682,98,1,0,1,1)    -- Time-Forward Talisman
VALUES (32491,44663,97,1,0,1,1)    -- Abandoned Adventurer's Satchel

-- Abandoned Adventurer's Satchel is a common drop from rares in Northrend, therefore the preferred way to implement it might be different.

 

 

Edited July 10, 2017 by Dallaryen

[Tavari]

Greetings @Dallaryen,

I need some more informations about the NPC on the live realm.

Is it just the loot which is missing or can't you even target it / attack it?

I hope you answer me as soon as possible.

 

Kind regards,

Trial Developer Tavari

[Tavari]

Patch accepted.

 

But i hope next time you will do it like that

UPDATE `creature_template` SET `lootid`=32491 WHERE `entry`=32491;
DELETE FROM `creature_loot_template` WHERE `entry`=32491;

 

INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)VALUES 
(32491,44168,98,1,0,1,1),
(32491,44682,98,1,0,1,1),
(32491,44663,97,1,0,1,1);

 

[Dallaryen]

Sorry for missing comas, I had no db to test on, it is "hand-made" :-)

To answer your inquiry: to see the error in the loot I had to kill it.

 

Kind regards,
Dallaryen

[Tavari]

On 16.7.2017 at 7:22 PM, Dallaryen said:

Sorry for missing comas, I had no db to test on, it is "hand-made" :-)

To answer your inquiry: to see the error in the loot I had to kill it.

 

Kind regards,
Dallaryen

Okey thank you for the information! On the realm we have the npc is not even targetable or attackable.

Ps: My scripts are hand-made aswell.

 

Kind regards,

Trial dev Tavari.

[Dallaryen]

Curious that you asked about the rare not being attackable. The Drake became bugged on the live realm too (was working fine for many months, or since launch).  The dead corpse (maybe you have a live mob on ptr, its not clear) is not despawning, not targetable, nor attackable.  I can confirm it's been like this for 3 days now, and the server restart did not rest this.  Campers said it was killed 4 days ago around 07/27 11:30 GMT-5.

Logging started on 07/28/2017 at 01:47:30. (GMT)
02:04:51 [Dahirloznao]: todo el dia desde las 11:30
02:26:36 [Cintilla]: 11:30 en qué zona horaria? ¿qué ciudad?
02:26:48 [Dahirloznao]: mexico

The corpse can be observed (quite a spectacular view) anytime before it gets fixed in Storm Peaks (Northrend) at the coordinates:
/way 60.4, 43.4

The next spawn as expected did not happen in a +- 20 minute timeframe. If the report is dependable then Tlpd is not respawning with the corpse still there. Depends on the rares' respawn logic, that you should be able to investigate:  I checked Sha of Anger, he gets the same GUID, that means the same spawn counter on each spawn. The corpse still has the guid locked, therefore the respawn logic responsible for avoiding duplicate spawns should prohibit the spawning of a new instance. You have access to the source, you can check if this hypothesis reflects reality.

You asked for an asap answer in your first response and got it in a few minutes.
I asked you too about when the patch goes live, one week ago.  It's time you answered:  How will we (players) know that the patch went live.  The actual timing does not matter at all, as the loot worked like this for more than 6 months, and everybody accepted it.  The point here is that players are informed when the patch goes live, so they don't waste days camping in a group just to realize it was not released to live yet.

We already know you have no idea, who will merge it, or when, and generally how this works, so any bit of knowledge of the workflow applied or not applied in your work might help us figure out the possible timeframes. Feel free to explain how you as a team work together, so simple noobs who just play can understand what difficult and tedious work has to be done to copy 3 records or 6 lines of code from the test realm to live.

Looking forward to your answer.
Kind regards,
Dallaryen

 

Edited July 31, 2017 by Dallaryen

[Tavari]

@Dallaryen i will look at it

[Uskoplje1]

FIX IT!!

[Dallaryen]

Mob not despawning for a week now.
Tavari retired...
This is just how it is from now.

[Tavari]

On 3.8.2017 at 11:40 AM, Dallaryen said:

Mob not despawning for a week now.
Tavari retired...
This is just how it is from now.

I took a look at the mob and chatted with a other dev but there was no flag in the database which makes hims like that..