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 31951 times)

0 Members and 1 Guest are viewing this topic.

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Boss loot table module
« on: May 11, 2006, 03:02:00 am »
I created this for my guild and figured others may find it useful for their guild/raidbots as well. Basically allows you to lookup a loot table either by the name of a boss (returns loot for that name) or the name of an item (returns bosses it drops from).

I've added loottables for pretty much all SL dynas that have specific loot, RK uniques, and most of the wanted loot from most dungeons. Feel free to correct/modify/add to the existing data. If you make large additions to it, try to post them here for others to add. Also advise if I have made any mistakes with loot drops or missing loots/bosses. Most of the data has come from various sites, some of which are quite dated and concrete data is not available.

I've included the ability to add items to the db ingame however it only currently works with an itemref. eg. you must post the item into the command. Would probably be good to add in adding via lowid as well, which is how is matches bossid's to items in the boss_loot table.

This module requires the items db which is standard with bebot. I have not tested it with the upgraded itemsdb posted recently however as long as the column names are identical and the lowids match then it should be fine.

Update: Using JJs slightly modified version for command change, loot layout with icons. Incorporated php5 fix. Also added !whereis lookup links. This requires the whereis module which I ahve included below with the SQL data as well.

Commands:

!bossloot name name of boss - searches the db for that name, can be partial and will return loottables for each match.

!bossloot loot name of item - searches the db for each boss that drops that item. Will return results for each item if multiple found.

!bossloot add <itemref>/name of boss/location - Adds an item to the db. It will check whether the item already exists under the boss name so the name of the boss MUST be exact. The location will not overwrite if the boss already exists, so you can put anything for location if adding to an existing droptable. However you must include something for location.

!bossloot check - Can only be done in a tell. Correlates data between the boss db and the items db for missing information. (thanks JJ)

Personally it's a lot easier updating loot tables in the db itself, using a frontend like phpmyadmin, sqlyog or similar.
« Last Edit: February 07, 2007, 04:58:41 pm by Malosar »
Eternalist
General of The Syndicate

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Boss loot table module
« Reply #1 on: May 11, 2006, 03:57:11 pm »
Nice, thanks :)

Offline tabsl

  • BeBot Rookie
  • *
  • Posts: 6
  • Karma: +0/-0
Re: Boss loot table module
« Reply #2 on: May 12, 2006, 10:52:38 am »
Very nice, except one bug.

Code: [Select]
[2006-05-12 08:36:03]   [GROUP] [MSG]   [<<< Shadowmoon Association >>>] Tabsl: !boss name beast
Fatal error: Cannot use string offset as an array in /home/teibl/aobots/smooni2/modules/boss.php on line 72


The error occurs also if i type in "!boss name the" or "!boss name the beast".

Some ideas? :)


*edit*
I removed The Beast from sql db.. now it's not crashing again but only shows Beasthandler and so on..

*edit2*

Code: [Select]
[2006-05-12 12:00:38]   [GROUP] [MSG]   [<<< Shadowmoon Association >>>] Tabsl: !boss loot gaily
Fatal error: Cannot use string offset as an array in /home/teibl/aobots/smooni2/modules/boss.php on line 105

seems the same bug, maybe someone will find out whats wrong :)
« Last Edit: May 12, 2006, 02:07:14 pm by tabsl »

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #3 on: May 12, 2006, 08:36:59 pm »
That error actually occurs if one of the items it's looking up is not found or bugged. Did you add to the beast loot table or something? I tried both of those and not getting the same error.

Also try changing on line 72 and 105, from $boss[0][0] to $boss[0] as suggested by someone to me previously however it didn't work for me in that specific instance. It might be a php version difference?
Eternalist
General of The Syndicate

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #4 on: May 13, 2006, 11:41:45 pm »
Also see this post regarding the error in php5.
Eternalist
General of The Syndicate

Offline tabsl

  • BeBot Rookie
  • *
  • Posts: 6
  • Karma: +0/-0
Re: Boss loot table module
« Reply #5 on: May 15, 2006, 10:33:38 am »
Thanks for the info, hope it will be fixed  8)
Otherwise it's a very funny module  ;D

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #6 on: May 15, 2006, 04:54:53 pm »
I'll see if I can recode around the problem sometime. However it works fine for me so it wont exactly be high on my todo list  ;D
Eternalist
General of The Syndicate

Offline buff

  • BeBot User
  • **
  • Posts: 36
  • Karma: +0/-0
Re: Boss loot table module
« Reply #7 on: November 28, 2006, 06:47:59 pm »
Fatal error: Cannot use string offset as an array in D:\RK2\Wyraid\modules\boss.
php on line 72

D:\RK2\Wyraid>pause
Press any key to continue . . .

got this message when i tried to do !boss name a or !boss name hezak
not sure if there's anything wrong w/ code :(

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #8 on: November 30, 2006, 03:39:18 pm »
It doesn't work with php5. I haven't recoded around it.
Eternalist
General of The Syndicate

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: Boss loot table module
« Reply #9 on: November 30, 2006, 04:06:33 pm »
It'll crash with PHP 5 if there is an empty entry in the database.  Like boss 78 with no loot allocated to it or so.  Just make sure there are no empty entries and it will work fine.

-jj-

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #10 on: November 30, 2006, 04:28:17 pm »
It'll crash with PHP 5 if there is an empty entry in the database.  Like boss 78 with no loot allocated to it or so.  Just make sure there are no empty entries and it will work fine.

-jj-

Actually I don't think it works at all as there is a bug when using
Code: [Select]
[0][0]offsets in a foreach loop in php5 afaicr. I've never run php5 so I can't really test it and no idea how many bebot users actually use this module with php5.
« Last Edit: December 05, 2006, 09:27:01 pm by Malosar »
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #11 on: January 10, 2007, 05:46:40 pm »
It does not produce error for me, but it is not really working, either. Watch this:
Code: [Select]
!boss loot asteroid
Items not found in boss loot:
Shoulderpads of Asteroid Calling
Code: [Select]
!boss name Tuqusk
Boss: Tuqusk
Loot:
Armplates of Meteorite Assembly
Boots of Stolen Comet Speed
Copy of The Excalibur
Exact Copy of The Excalibur
Gauntlets of Star Confabulation
Moon Watcher Helmet
Overcoat of the Firmament
Shoulderpads of Asteroid Calling
Vest of Torpid Sunrays
Location: Inferno, South of Frontier
------------------------------------
If I search for armplates or meteor, I get the merlin dragons... I can't see why atm. Any ideas? My bot does not give any error messages, btw.
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #12 on: January 10, 2007, 06:09:18 pm »
It's because of the stupid extra set of pads in the itemdb introduced in 16.3, the nodrop version of the pads. The module gets the highest value for the lowid and thats not in the boss loot db.

You could delete the entry from the items db. Item lowid 260685.
« Last Edit: January 10, 2007, 06:12:12 pm by Malosar »
Eternalist
General of The Syndicate

Offline shilli

  • BeBot Rookie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: Boss loot table module
« Reply #13 on: January 10, 2007, 07:33:30 pm »
hey the boos loot in bebot dosent show loot only boss name and loc  and i get a error msg that lowid   do i need to make a table with items  in the database i9 have items.php and thats works fine

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #14 on: January 11, 2007, 02:20:51 am »
You just need to delete that entry from the itemdb if you want.

delete from items where lowid = 260685;
Eternalist
General of The Syndicate

 

* 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: 517
  • 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