0 Потребители и 1 Гост преглежда(т) тази тема.
+-------+--------------------+| entry | difficulty_entry_1 |+-------+--------------------+| 20912 | 21601 |+-------+--------------------+
INSERT INTO `creature_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(21601, 33861, -100, 1, 1, 1, 1);
Само един предмет ли дропи?
SELECT * FROM creature_template WHERE entry='21601'
+-------+--------------------+--------------------+--------------------+-------------+-------------+----------+----------+----------+----------+-----------------------+---------+----------+----------------+----------+----------+-----+-----------+-----------+---------+------------+-----------+-------+------+--------+--------+-----------+-------------+----------------+----------------+-----------------+------------+------------+--------------+--------+--------------+---------------+---------------+--------------+-------------+-------------+-------------------+------+------------+--------+----------------+----------+-------------+-------------+-------------+-------------+-------------+-------------+--------+--------+--------+--------+--------+--------+--------+--------+----------------+-----------+---------+---------+--------+--------------+-------------+------------+----------+-----------+--------------+------------+------------+------------+------------+------------+------------+------------+-------------+--------------+----------------------+-------------+------------+-------------+| entry | difficulty_entry_1 | difficulty_entry_2 | difficulty_entry_3 | KillCredit1 | KillCredit2 | modelid1 | modelid2 | modelid3 | modelid4 | name | subname | IconName | gossip_menu_id | minlevel | maxlevel | exp | faction_A | faction_H | npcflag | speed_walk | speed_run | scale | rank | mindmg | maxdmg | dmgschool | attackpower | dmg_multiplier | baseattacktime | rangeattacktime | unit_class | unit_flags | dynamicflags | family | trainer_type | trainer_spell | trainer_class | trainer_race | minrangedmg | maxrangedmg | rangedattackpower | type | type_flags | lootid | pickpocketloot | skinloot | resistance1 | resistance2 | resistance3 | resistance4 | resistance5 | resistance6 | spell1 | spell2 | spell3 | spell4 | spell5 | spell6 | spell7 | spell8 | PetSpellDataId | VehicleId | mingold | maxgold | AIName | MovementType | InhabitType | Health_mod | Mana_mod | Armor_mod | RacialLeader | questItem1 | questItem2 | questItem3 | questItem4 | questItem5 | questItem6 | movementId | RegenHealth | equipment_id | mechanic_immune_mask | flags_extra | ScriptName | WDBVerified |+-------+--------------------+--------------------+--------------------+-------------+-------------+----------+----------+----------+----------+-----------------------+---------+----------+----------------+----------+----------+-----+-----------+-----------+---------+------------+-----------+-------+------+--------+--------+-----------+-------------+----------------+----------------+-----------------+------------+------------+--------------+--------+--------------+---------------+---------------+--------------+-------------+-------------+-------------------+------+------------+--------+----------------+----------+-------------+-------------+-------------+-------------+-------------+-------------+--------+--------+--------+--------+--------+--------+--------+--------+----------------+-----------+---------+---------+--------+--------------+-------------+------------+----------+-----------+--------------+------------+------------+------------+------------+------------+------------+------------+-------------+--------------+----------------------+-------------+------------+-------------+| 21601 | 0 | 0 | 0 | 0 | 0 | 19943 | 0 | 0 | 0 | Harbinger Skyriss (1) | | NULL | 0 | 72 | 72 | 1 | 16 | 16 | 0 | 1.71 | 1.14286 | 1 | 1 | 304 | 436 | 0 | 296 | 13 | 2000 | 0 | 2 | 832 | 8 | 0 | 0 | 0 | 0 | 0 | 268 | 399 | 40 | 10 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9588 | 12532 | | 1 | 3 | 8 | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 167 | 1 | 0 | 619069439 | 1 | | 12340 |+-------+--------------------+--------------------+--------------------+-------------+-------------+----------+----------+----------+----------+-----------------------+---------+----------+----------------+----------+----------+-----+-----------+-----------+---------+------------+-----------+-------+------+--------+--------+-----------+-------------+----------------+----------------+-----------------+------------+------------+--------------+--------+--------------+---------------+---------------+--------------+-------------+-------------+-------------------+------+------------+--------+----------------+----------+-------------+-------------+-------------+-------------+-------------+-------------+--------+--------+--------+--------+--------+--------+--------+--------+----------------+-----------+---------+---------+--------+--------------+-------------+------------+----------+-----------+--------------+------------+------------+------------+------------+------------+------------+------------+-------------+--------------+----------------------+-------------+------------+-------------+
INSERT INTO `creature_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(21601, 23572, 100, 0, 1, 1, 1),(21601, 1, 100, 1, 0, -1000, 1),(21601, 2, 100, 1, 0, -1001, 1);INSERT INTO `reference_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(1000, 29252, 25, 1, 1, 1, 1),(1000, 29248, 21, 1, 1, 1, 1),(1000, 29241, 19, 1, 1, 1, 1),(1000, 29360, 13, 1, 1, 1, 1),(1000, 28416, 12, 1, 1, 1, 1);INSERT INTO `reference_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(1001, 30581, 0, 1, 1, 1, 1),(1001, 30575, 0, 1, 1, 1, 1),(1001, 30582, 0, 1, 1, 1, 1);
Table 'creature_loot_template' entry 21601 isn't creature entry and not referenced from loot, and then useless.
Table 'reference_loot_template' entry 1000 (reference id) not exist but used as loot id in DB.Table 'reference_loot_template' entry 1001 (reference id) not exist but used as loot id in DB.
INSERT INTO `creature_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(21601, 33861, -100, 0, 1, 1, 1),(21601, 23572, 100, 0, 1, 1, 1),(21601, 1, 100, 1, 0, -1000, 1),(21601, 2, 100, 1, 0, -1001, 1);INSERT INTO `reference_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(1000, 29252, 25, 1, 1, 1, 1),(1000, 29248, 21, 1, 1, 1, 1),(1000, 29241, 19, 1, 1, 1, 1),(1000, 29360, 13, 1, 1, 1, 1),(1000, 28416, 12, 1, 1, 1, 1);INSERT INTO `reference_loot_template` (`entry`,`item`,`chanceorquestchance`,`lootmode`,`groupid`,`mincountorref`,`maxcount`) VALUES(1001, 30581, 0, 1, 1, 1, 1),(1001, 30575, 0, 1, 1, 1, 1),(1001, 30582, 0, 1, 1, 1, 1);UPDATE `creature_template` SET `lootid`=21601 WHERE `entry`=21601;
UPDATE `creature_template` SET `lootid`=21601 WHERE `entry`=21601;