rendered paste bodyNORMAL
mysql> select * from creature_loot_template where entry ='31125'
-> ;
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 31125 | 1 | 100 | 1 | 0 | -34209 | 1 |
| 31125 | 2 | 100 | 1 | 0 | -34210 | 1 |
| 31125 | 3 | 1 | 1 | 0 | -34203 | 1 |
| 31125 | 40752 | 100 | 1 | 0 | 2 | 2 |
+-------+-------+---------------------+----------+---------+---------------+----------+
4 rows in set (0,02 sec)
mysql> select * from reference_loot_template where entry='34209';
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 34209 | 39492 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39493 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39495 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39497 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39498 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39500 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39515 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39517 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39519 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39523 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39528 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39530 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39538 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39539 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39543 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39544 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39546 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39547 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39554 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39555 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39557 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39558 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39560 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39564 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39579 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39580 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39582 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39588 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39589 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39591 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39592 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39593 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39595 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39597 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39606 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39607 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39609 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39611 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39612 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39617 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39618 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39620 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39622 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39623 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39624 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39626 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39629 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39630 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39632 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39633 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39634 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39636 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39638 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39639 | 0 | 1 | 1 | 1 | 1 |
| 34209 | 39641 | 0 | 1 | 1 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
55 rows in set (0,04 sec)
mysql> select * from reference_loot_template where entry='34210';
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 34210 | 40781 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40782 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40783 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40801 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40802 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40803 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40840 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40841 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40842 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40904 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40925 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40937 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40988 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40989 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 40999 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41005 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41025 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41031 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41085 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41135 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41141 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41162 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41203 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41284 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41291 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41296 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41302 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41308 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41314 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41653 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41659 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41665 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41765 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41771 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41857 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41862 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41872 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41919 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41925 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41938 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41950 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41957 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 41969 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 42001 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 42003 | 0 | 1 | 1 | 1 | 1 |
| 34210 | 42015 | 0 | 1 | 1 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
46 rows in set (0,00 sec)
mysql> select * from reference_loot_template where entry='34203';
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 34203 | 43959 | 0 | 1 | 1 | 1 | 1 |
| 34203 | 44083 | 0 | 1 | 1 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
2 rows in set (0,00 sec)
HERO
select difficulty_entry_1 from creature_template where entry='31125';
+--------------------+
| difficulty_entry_1 |
+--------------------+
| 31722 |
+--------------------+
1 row in set (0,01 sec)
select * from creature_loot_template where entry ='31722' -> ;
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 31722 | 1 | 100 | 1 | 0 | -34208 | 2 |
| 31722 | 2 | 100 | 1 | 0 | -34211 | 2 |
| 31722 | 3 | 1 | 1 | 0 | -34203 | 1 |
| 31722 | 40752 | 100 | 1 | 0 | 2 | 2 |
+-------+-------+---------------------+----------+---------+---------------+----------+
4 rows in set (0,02 sec)
* from reference_loot_template where entry='34208';+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 34208 | 45337 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45338 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45341 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45343 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45345 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45347 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45351 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45353 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45355 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45357 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45360 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45362 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45367 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45370 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45371 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45376 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45379 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45383 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45384 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45387 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45388 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45392 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45394 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45397 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45399 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45401 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45403 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45406 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45409 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45414 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45416 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45419 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45420 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45426 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45427 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45430 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 45432 | 0 | 1 | 1 | 1 | 1 |
| 34208 | 46131 | 0 | 1 | 1 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
38 rows in set (0,00 sec)
mysql> select * from reference_loot_template where entry='34211';
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 34211 | 40804 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40805 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40806 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40844 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40845 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40846 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40879 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40880 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40888 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40926 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40938 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40974 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40975 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 40982 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41000 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41006 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41026 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41032 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41048 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41054 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41059 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41064 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41069 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41074 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41136 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41142 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41198 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41204 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41224 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41229 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41234 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41286 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41292 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41297 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41303 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41616 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41620 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41624 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41629 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41634 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41639 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41654 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41666 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41766 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41772 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41831 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41835 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41839 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41863 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41873 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41880 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41884 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41892 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41897 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41902 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41908 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41926 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41939 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41958 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 41970 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42004 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42016 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42028 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42029 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42030 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42031 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42032 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42033 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42062 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42063 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42064 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42065 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42066 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42067 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42068 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42114 | 0 | 1 | 1 | 1 | 1 |
| 34211 | 42115 | 0 | 1 | 1 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
77 rows in set (0,01 sec)