Author Topic: Boss loot table module (Read 70090 times)

Malosar · « **Reply #30 on:** February 06, 2007, 03:58:16 pm »

ok made the corrections, added in the extra loot and the HI data. Not sure if HI is complete as not many good sources for that. Updated my original post with the new SQL data. Between the 3 of us we can hopefully come up with a more comprehensive and accurate db.

Maybe you can post any corrects/additions in sql format?

pusikas · « **Reply #31 on:** February 06, 2007, 06:37:10 pm »

I am kinda done with the Adonis mobs. Prolly some missing still, but reliable info is scarce. Now, my MySQL is not very good. What would be a convenient way to give you the data? Select it into another table and dump the table? What would the commands for that be? Our bossid columns most likely differ, since I fiddled with the table a while ago, and I did not apply your changes before starting on Adonis. I could generate two tables from the output of

Code: [Select]

SELECT * FROM boss_name WHERE location like '%Adonis%';
SELECT bossname, itemid FROM boss_loot l JOIN boss_name n ON (n.bossid = l.bossid) WHERE location LIKE '%Adonis%';

for example, or whatever works well.

Malosar · « **Reply #32 on:** February 06, 2007, 06:48:09 pm »

Well I'll need the itemids so the 2nd select giving me the bossname and the itemid is perfect. I'll enter all the data into my db, and any JJ might have for me about HI then post a new version of the sql.

pusikas · « **Reply #33 on:** February 06, 2007, 10:05:50 pm »

OK, I know how to dump the result of a SELECT into a table, but how do I dump a table as a series of INSERT statements?

pusikas · « **Reply #34 on:** February 06, 2007, 10:12:39 pm »

Nvm, I think I found out. Check if you can use this.

Should make two tables, dump1 and dump2. I hope...

I put in all the ado mobs that I know to have non-pattern loot at all, plus their location where I could get it. Was too lazy to walk to the snatching souldredge to heck his coordinates...

Malosar · « **Reply #35 on:** February 07, 2007, 03:59:48 pm »

ok entered in the extra bosses and drops from Adonis. I left out some of yours as I don't consider quest items and armor to be boss loot. Also I left my JAME data pretty much intact as there is little data around to accurately tell me which ones it does/doesn't drop.

Also updated my whereis db with your location data and included the whereis db and module with my original post along with the loot updates.

Thanks for your extras, I'd left out quite a bit in Adonis lol

pusikas · « **Reply #36 on:** February 07, 2007, 07:33:39 pm »

Quote from: Malosar on February 07, 2007, 03:59:48 pm

I left out some of yours as I don't consider quest items and armor to be boss loot.

I can agree to the quest items, but for several reasons I think that the undercover and sanguisugent armor should stay. Some people actually use that stuff (some buff useful skills like CL or T&S), and it only drops off bosses. People use the bossloot module to find out what items of interest a boss drops, or to find out what boss drops a certain item. In both cases, the armor information might be considered interesting. It's not like too much info hurts anyone, or the database is getting too big - quite the opposite. The info is there - why not use it?
And I often hear questions like "Does anyone know if there are mobs in adonis that drop Pernicious armor?". Those questions could be answered with the armor included. I might agree that stuff like outsider and killer's armor is quite uninteresting, tho. But at least sanguisugent, pernicious, bootlegger and saboteur armor should stay in the DB, as these have real uses and only drop from bosses.
And please tell me the difference between pernicious armor and, say, FRN. Both drop only from certain kinds of bosses, but across all the playfields. FRN is in the DB, so should the armor.

Working on added info about ely atm... half the eremites are missing...

Malosar · « **Reply #37 on:** February 07, 2007, 07:54:07 pm »

Well if you happened to have a comprehensive drop list for all the armor types then it would be a good thing to include, but there was only a few in your list which had it. If you get to the point where you have details across multiple zones then please share!

I'm also starting to think along the way somewhere I lost some of my entries in my db, maybe I had reverted to an earlier version somewhere as I know some of the adonis ones you put in I definitely had beforehand. And i'm seeing more missing as well.

I guess eventually we'll end up with a complete db. Thanks for helping out with updating this.

pusikas · « **Reply #38 on:** February 07, 2007, 10:13:18 pm »

As I said, I am atm collecting locations for ely, and I have half a list for scheol ready. If it pleases you more, mebbe I prepare an update with the armor some day. You are right that it makes more sense to include it completely or not at all.

BTW, I copied most of the info for ado form aowiki.de, crosschecked it with comments from auno.org and a thread on the german official forum. Still, I did not get most of the adonis info firsthand, so there might be errors.

Heffalomp · « **Reply #39 on:** April 14, 2007, 05:27:23 pm »

Annyone got a helpfile for the !whois part?

pusikas · « **Reply #40 on:** April 15, 2007, 12:29:55 am »

Helpfile? !whois?

Malosar · « **Reply #41 on:** April 15, 2007, 03:58:29 pm »

I assume you mean the !whereis support I added into the bossloot module. Information on it can be found at aodevs.com.

chek · « **Reply #42 on:** June 21, 2009, 12:47:50 am »

how install this module?

Temar · « **Reply #43 on:** June 22, 2009, 04:05:43 am »

you normaly put the module in custom/modules
then simple start or restart your bot

Temar · « **Reply #44 on:** June 22, 2009, 04:06:45 am »

Altho this is posted in 0.2.x which is very old and will not work with latest version and there is no support module for it

Author Topic: Boss loot table module (Read 70090 times)

Malosar

Re: Boss loot table module

pusikas

Re: Boss loot table module

Malosar

Re: Boss loot table module

pusikas

Re: Boss loot table module

pusikas

Re: Boss loot table module

Malosar

Re: Boss loot table module

pusikas

Re: Boss loot table module

Malosar

Re: Boss loot table module

pusikas

Re: Boss loot table module

Heffalomp

Re: Boss loot table module

pusikas

Re: Boss loot table module

Malosar

Re: Boss loot table module

chek

Re: Boss loot table module

Temar

Re: Boss loot table module

Temar

Re: Boss loot table module