collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 2 Guests are viewing this topic.

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« 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?
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« 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. :)
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« 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.
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« 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?
Luuv  Bot-Keeper of Vengeance ^^*

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #34 on: February 06, 2007, 10:12:39 pm »
Nvm, I think I found out. Check if you can use this.  ;D 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...
« Last Edit: February 06, 2007, 10:17:02 pm by pusikas »
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« 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
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #36 on: February 07, 2007, 07:33:39 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.  ;D

Working on added info about ely atm... half the eremites are missing...
« Last Edit: February 07, 2007, 07:40:39 pm by pusikas »
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« 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.
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« 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.
« Last Edit: February 07, 2007, 10:20:25 pm by pusikas »
Luuv  Bot-Keeper of Vengeance ^^*

Offline Heffalomp

  • BeBot Apprentice
  • ***
  • Posts: 80
  • Karma: +0/-0
Re: Boss loot table module
« Reply #39 on: April 14, 2007, 05:27:23 pm »
Annyone got a helpfile for the !whois part?
"Ubuntu" is an ancient African word, meaning "I can't configure Slackware"

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #40 on: April 15, 2007, 12:29:55 am »
Helpfile? !whois?
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« 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.
Eternalist
General of The Syndicate

Offline chek

  • BeBot Rookie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: Boss loot table module
« Reply #42 on: June 21, 2009, 12:47:50 am »
how install this module?

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Boss loot table module
« 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

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Boss loot table module
« 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

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 473
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal