FIX: Only 1 lootdrop per mob

[Trumpcard]

Heres the loot table for a scrawny gnoll
I think the data is just really off for this zones, most other zones seem to be fairly decent..
mysql> select * from lootdrop_entries where lootdrop_id = 12417;
+-------------+---------+--------------+------------+--------+
| lootdrop_id | item_id | item_charges | equip_item | chance |
+-------------+---------+--------------+------------+--------+
| 12417 | 1028 | 1 | 0 | 1 |
| 12417 | 5015 | 1 | 0 | 2 |
| 12417 | 5019 | 1 | 0 | 3 |
| 12417 | 5020 | 1 | 0 | 3 |
| 12417 | 5023 | 1 | 0 | 1 |
| 12417 | 6011 | 1 | 0 | 5 |
| 12417 | 6014 | 1 | 0 | 3 |
| 12417 | 7008 | 1 | 0 | 2 |
| 12417 | 7009 | 1 | 0 | 1 |
| 12417 | 7010 | 1 | 0 | 1 |
| 12417 | 13025 | 1 | 0 | 51 |
| 12417 | 13915 | 1 | 0 | 18 |
| 12417 | 19630 | 1 | 0 | 36 |
| 12417 | 20178 | 1 | 0 | 4 |
| 12417 | 20179 | 1 | 0 | 2 |
| 12417 | 20181 | 1 | 0 | 1 |
| 12417 | 27392 | 1 | 0 | 33 |
| 12417 | 27405 | 1 | 0 | 20 |
| 12417 | 27409 | 1 | 0 | 17 |
| 12417 | 27417 | 1 | 0 | 6 |
| 12417 | 27421 | 1 | 0 | 9 |
| 12417 | 27423 | 1 | 0 | 10 |
| 12417 | 27424 | 1 | 0 | 6 |
| 12417 | 27427 | 1 | 0 | 7 |
+-------------+---------+--------------+------------+--------+


Any item with a probility over 5 is most likely going to be there, and a prob. of 10 will DEF. be there, so the solution is to either accept really low probabilty drops, (Cloth shirt by this table has a prob. of 1 or 10 based on how you calculate it, patch of gnoll fur will be either 51 or 510%) , fix the data to be correct, or code in a 'cludge' factor to account for skewed chances of a drop.

Say, do a precheck on chance, and normalize it if it's over 10. (Divide by 10).
That will fix the drops for most everybody.

Personally, i'd rather see the probabilities correct in the database with it being just a standard probability, ie. 1-100, the you just need a rand()%100 to compare against.

Lurker/Drawde/Khoung , since you guys are the primary data team, how do you think it should be handled?


Edit: Actually , on playing around with it, the low numbers arent that bad for creatures with 10+ drops, but maybe instead of using *10, have it * (LOOTDROPMOD) which could be a variable.

Up it to 2 if you want to slighty increase the frequency of drops on your server, or 3, etc.

I'll see about that.. If *10 is too high, set it down to 1 - 5 and see where it seems balanced at for you.