Quote:
Originally Posted by Zothen
Just keep in mind that
1. many mobs dont even got a loottable (id)
2. some mobs share the same loottable so there may be duplicate entries after your sql commands ( maybe "distinct" is preventing that, i am no sql expert  ) |
Yes that is true, this was just a quick and dirty sql for the most part. Only mobs with loottables will activate. And the 'distinct' should prevent the duplicates as you stated.
I actually encountered a forest drakeling with a crude defiant spear. You could see the spear graphic along his side and it looked like it was jousting. Wish I had captured the jpg.
I was working to make it more intuitive by insuring that only humanoid mobs drop the items but got sidetracked. I will resume at some point. I am a C++/SQL developer and have been spending more time looking at the code lately.