search

TheGhostGroup / trinitydb

Early Trinitycore Databases Backup from code.google.com/p/trinitydb
0 stars 1 forks source link

[Quest] Cuergo's Gold. Requested key will never be looted #73

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
TC ver: 10498
TDB: TDB: TDB_335.11.35.1_10413 (+CORE PATCHES)

This quest ( http://www.wowhead.com/quest=2882 ) can not be completed, since to 
open chest, you need a Cuergo's Key ( http://www.wowhead.com/item=9275 ).

According to wowhead, it is dropped by pirates of that zone, but I killed 
everybody several times, and it will never be looted.

Also, I searched in creature_loot_template and item_loot_template and item=9275 
is not inside any of those two, so that is why I post this as a DB bug.

Maybe missings rows from *_loot_template for this item?

Original issue reported on code.google.com by StormB...@gmail.com on 23 Nov 2010 at 7:30

GoogleCodeExporter commented 9 years ago 
Sorry, I did not do a good SQL search. It seems that data is already in DB:
select * from creature_loot_template where item=9275;
+-------+------+---------------------+----------+---------+---------------+-----
-----+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | 
maxcount |
+-------+------+---------------------+----------+---------+---------------+-----
-----+
|  7899 | 9275 |                -100 |        1 |       0 |             1 |     
   1 |
|  7901 | 9275 |                -100 |        1 |       0 |             1 |     
   1 |
|  7902 | 9275 |                -100 |        1 |       0 |             1 |     
   1 |
+-------+------+---------------------+----------+---------+---------------+-----
-----+
And seems correct, please close this issue, I will open one as a core issue.

Original comment by StormB...@gmail.com on 23 Nov 2010 at 7:41

GoogleCodeExporter commented 9 years ago 
no, the Pirates, which drop this item, should spawn when you klick on this 
mast, where the treausre appears, but they don´t so it must be fixxed, that 
the pirates and the chest spawn ;)

Original comment by oldB...@gmail.com on 19 Dec 2010 at 1:48