Loot table problems, sql or source code related?
I have noticed more and more that the items toward the end of a loot table do not drop off of mobs much, if ever. For instance:
Code:
INSERT INTO loottable VALUES ('4570', 'Sebilite_Juggernaut', '2240', '14824', '0'); -- Sebilite_Juggernaut level is 57
INSERT INTO loottable_entries VALUES ('4570', '4570', '77', '15'); -- Sebilite_Juggernaut has 77 total items
INSERT INTO lootdrop VALUES ('4570', 'Sebilite_Juggernaut');
INSERT INTO lootdrop_entries VALUES (4570, 10036, 1, 1, '2'); -- Sebilite_Juggernaut gets Black Sapphire
INSERT INTO lootdrop_entries VALUES (4570, 4522, 1, 0, '2'); -- Sebilite_Juggernaut gets Blood Ember Helm
INSERT INTO lootdrop_entries VALUES (4570, 22503, 1, 1, '2'); -- Sebilite_Juggernaut gets Blue Diamond
INSERT INTO lootdrop_entries VALUES (4570, 4515, 1, 0, '2'); -- Sebilite_Juggernaut gets Cobalt Helm
INSERT INTO lootdrop_entries VALUES (4570, 10037, 1, 1, '2'); -- Sebilite_Juggernaut gets Diamond
INSERT INTO lootdrop_entries VALUES (4570, 10033, 1, 1, '2'); -- Sebilite_Juggernaut gets Fire Emerald
INSERT INTO lootdrop_entries VALUES (4570, 10049, 1, 0, '2'); -- Sebilite_Juggernaut gets Fire Emerald Ring
INSERT INTO lootdrop_entries VALUES (4570, 10053, 1, 1, '2'); -- Sebilite_Juggernaut gets Jacinth
INSERT INTO lootdrop_entries VALUES (4570, 10035, 1, 1, '2'); -- Sebilite_Juggernaut gets Ruby
INSERT INTO lootdrop_entries VALUES (4570, 10051, 1, 0, '2'); -- Sebilite_Juggernaut gets Ruby Crown
INSERT INTO lootdrop_entries VALUES (4570, 65265, 1, 1, '2'); -- Sebilite_Juggernaut gets Rune of Association
INSERT INTO lootdrop_entries VALUES (4570, 10034, 1, 1, '2'); -- Sebilite_Juggernaut gets Sapphire
INSERT INTO lootdrop_entries VALUES (4570, 7222, 1, 1, '2'); -- Sebilite_Juggernaut gets Sebilite Croaking Dirk
INSERT INTO lootdrop_entries VALUES (4570, 19278, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Acumen
INSERT INTO lootdrop_entries VALUES (4570, 19227, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Aegis
INSERT INTO lootdrop_entries VALUES (4570, 19223, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Antidote
INSERT INTO lootdrop_entries VALUES (4570, 19402, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Asphyxiate
INSERT INTO lootdrop_entries VALUES (4570, 19416, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Augment
INSERT INTO lootdrop_entries VALUES (4570, 19277, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Bane of Nife
INSERT INTO lootdrop_entries VALUES (4570, 19400, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Bedlam
INSERT INTO lootdrop_entries VALUES (4570, 19419, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Bonds of Tunare
INSERT INTO lootdrop_entries VALUES (4570, 19250, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Breath of Karana
INSERT INTO lootdrop_entries VALUES (4570, 19473, 1, 0, '2'); -- Sebilite_Juggernaut gets Spell: Cannibalize IV
INSERT INTO lootdrop_entries VALUES (4570, 19307, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Conjure Corpse
INSERT INTO lootdrop_entries VALUES (4570, 19312, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Devouring Darkness
INSERT INTO lootdrop_entries VALUES (4570, 19364, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Dyzil\'s Deafening Decoy
INSERT INTO lootdrop_entries VALUES (4570, 19311, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Emissary of Thule
INSERT INTO lootdrop_entries VALUES (4570, 19222, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Enforced Reverence
INSERT INTO lootdrop_entries VALUES (4570, 19396, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Enlightenment
INSERT INTO lootdrop_entries VALUES (4570, 19336, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Evacuate
INSERT INTO lootdrop_entries VALUES (4570, 19214, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Exile Undead
INSERT INTO lootdrop_entries VALUES (4570, 19411, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Eye of Tallon
INSERT INTO lootdrop_entries VALUES (4570, 19255, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Fist of Karana
INSERT INTO lootdrop_entries VALUES (4570, 19344, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Flaming Sword of Xuzl
INSERT INTO lootdrop_entries VALUES (4570, 19395, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Forlorn Deeds
INSERT INTO lootdrop_entries VALUES (4570, 19252, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Frost
INSERT INTO lootdrop_entries VALUES (4570, 19401, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Gift of Pure Thought
INSERT INTO lootdrop_entries VALUES (4570, 19247, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Girdle of Karana
INSERT INTO lootdrop_entries VALUES (4570, 19341, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Invert Gravity
INSERT INTO lootdrop_entries VALUES (4570, 19259, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Legacy of Thorn
INSERT INTO lootdrop_entries VALUES (4570, 19282, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Malosini
INSERT INTO lootdrop_entries VALUES (4570, 19414, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Manasink
INSERT INTO lootdrop_entries VALUES (4570, 19370, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Manastorm
INSERT INTO lootdrop_entries VALUES (4570, 19218, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Mark of Karn
INSERT INTO lootdrop_entries VALUES (4570, 19331, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Markar\'s Discord
INSERT INTO lootdrop_entries VALUES (4570, 19363, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Muzzle of Mardu
INSERT INTO lootdrop_entries VALUES (4570, 16240, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Paralyzing Earth
INSERT INTO lootdrop_entries VALUES (4570, 19335, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Pillar of Flame
INSERT INTO lootdrop_entries VALUES (4570, 19288, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Pox of Bertoxxulous
INSERT INTO lootdrop_entries VALUES (4570, 19309, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Quivering Veil of Xarn
INSERT INTO lootdrop_entries VALUES (4570, 19417, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Rage of Zomm
INSERT INTO lootdrop_entries VALUES (4570, 19256, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Regrowth of the Grove
INSERT INTO lootdrop_entries VALUES (4570, 19332, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Retribution of Al\'Kabor
INSERT INTO lootdrop_entries VALUES (4570, 19410, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Sedulous Subversion
INSERT INTO lootdrop_entries VALUES (4570, 19258, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Spirit of Oak
INSERT INTO lootdrop_entries VALUES (4570, 19253, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Succor
INSERT INTO lootdrop_entries VALUES (4570, 19281, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Talisman of the Brute
INSERT INTO lootdrop_entries VALUES (4570, 19280, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Talisman of the Cat
INSERT INTO lootdrop_entries VALUES (4570, 19289, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Talisman of the Raptor
INSERT INTO lootdrop_entries VALUES (4570, 19284, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Talisman of the Rhino
INSERT INTO lootdrop_entries VALUES (4570, 19286, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Talisman of the Serpent
INSERT INTO lootdrop_entries VALUES (4570, 19339, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Tears of Prexus
INSERT INTO lootdrop_entries VALUES (4570, 19225, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: The Unspoken Word
INSERT INTO lootdrop_entries VALUES (4570, 19285, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Tigir\'s Insects
INSERT INTO lootdrop_entries VALUES (4570, 19391, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Torment of Argli
INSERT INTO lootdrop_entries VALUES (4570, 19425, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Trucidation
INSERT INTO lootdrop_entries VALUES (4570, 19393, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Umbra
INSERT INTO lootdrop_entries VALUES (4570, 19287, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Unfailing Reverence
INSERT INTO lootdrop_entries VALUES (4570, 19348, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Velocity
INSERT INTO lootdrop_entries VALUES (4570, 19342, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Vengeance of Al\'Kabor
INSERT INTO lootdrop_entries VALUES (4570, 19290, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Voice of the Berserker
INSERT INTO lootdrop_entries VALUES (4570, 19413, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Wake of Karana
INSERT INTO lootdrop_entries VALUES (4570, 19221, 1, 0, '1'); -- Sebilite_Juggernaut gets Spell: Word of Restoration
INSERT INTO lootdrop_entries VALUES (4570, 10032, 1, 1, '1'); -- Sebilite_Juggernaut gets Star Ruby
INSERT INTO lootdrop_entries VALUES (4570, 10048, 1, 0, '1'); -- Sebilite_Juggernaut gets Star Ruby Earring
INSERT INTO lootdrop_entries VALUES (4570, 6478, 1, 0, '1'); -- Sebilite_Juggernaut gets Undead Dragon Sinew
INSERT INTO lootdrop_entries VALUES (4570, 65347, 1, 1, '1'); -- Sebilite_Juggernaut gets Words of Capacity
I noticed that any item after Spell: Breath of Karana does not drop, no matter how I change the numbers. For instance, I changed all item chances to 1 and the first one to 23 (so it equals 100), but that didnt help. I also changed the mulitplier to someting lower like 7, and increased the probability to 50 but no difference.
I also duplicated the same problem with giants in kael:
Code:
INSERT INTO loottable VALUES ('5483', 'Lieutenant_Stormeye', '0', '0', '0'); -- Lieutenant_Stormeye level is
INSERT INTO loottable_entries VALUES ('5483', '5483', '33', '15'); -- Lieutenant_Stormeye has 33 total items
INSERT INTO lootdrop VALUES ('5483', 'Lieutenant_Stormeye');
INSERT INTO lootdrop_entries VALUES (5483, 24945, 1, 0, '4'); -- Lieutenant_Stormeye gets Eroded Leather Boots
INSERT INTO lootdrop_entries VALUES (5483, 24946, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Bracelet
INSERT INTO lootdrop_entries VALUES (5483, 24947, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Cap
INSERT INTO lootdrop_entries VALUES (5483, 24948, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Gloves
INSERT INTO lootdrop_entries VALUES (5483, 24943, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Leggings
INSERT INTO lootdrop_entries VALUES (5483, 24944, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Sleeves
INSERT INTO lootdrop_entries VALUES (5483, 24942, 1, 0, '3'); -- Lieutenant_Stormeye gets Eroded Leather Tunic
INSERT INTO lootdrop_entries VALUES (5483, 25000, 1, 1, '3'); -- Lieutenant_Stormeye gets Giant Militia Longsword
INSERT INTO lootdrop_entries VALUES (5483, 25003, 1, 0, '3'); -- Lieutenant_Stormeye gets Lieutenant\'s Helm
INSERT INTO lootdrop_entries VALUES (5483, 24935, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Tunic
INSERT INTO lootdrop_entries VALUES (5483, 24936, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Leggings
INSERT INTO lootdrop_entries VALUES (5483, 24937, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Sleeves
INSERT INTO lootdrop_entries VALUES (5483, 24938, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Boots
INSERT INTO lootdrop_entries VALUES (5483, 24939, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Bracer
INSERT INTO lootdrop_entries VALUES (5483, 24940, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Coif
INSERT INTO lootdrop_entries VALUES (5483, 24941, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Chain Gauntlets
INSERT INTO lootdrop_entries VALUES (5483, 24928, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Breastplate
INSERT INTO lootdrop_entries VALUES (5483, 24929, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Greaves
INSERT INTO lootdrop_entries VALUES (5483, 24930, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Vambraces
INSERT INTO lootdrop_entries VALUES (5483, 24931, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Boots
INSERT INTO lootdrop_entries VALUES (5483, 24932, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Bracer
INSERT INTO lootdrop_entries VALUES (5483, 24933, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Helmet
INSERT INTO lootdrop_entries VALUES (5483, 24934, 1, 0, '3'); -- Lieutenant_Stormeye gets Corroded Plate Gauntlets
INSERT INTO lootdrop_entries VALUES (5483, 24949, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Robe
INSERT INTO lootdrop_entries VALUES (5483, 24950, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Pantaloons
INSERT INTO lootdrop_entries VALUES (5483, 24951, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Sleeves
INSERT INTO lootdrop_entries VALUES (5483, 24952, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Boots
INSERT INTO lootdrop_entries VALUES (5483, 24953, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Wristband
INSERT INTO lootdrop_entries VALUES (5483, 24954, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Turban
INSERT INTO lootdrop_entries VALUES (5483, 24955, 1, 0, '3'); -- Lieutenant_Stormeye gets Torn Enchanted Silk Gloves
Always drops 5 or so erroded, maybe a 1-2 chain, and no silk.
Any ideas? I looked in loottable.cpp but was not able to pinpoint what would cause this, if it is a code issue. |
Linear Mode
