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

0 Members and 1 Guest are viewing this topic.

Offline shilli

  • BeBot Rookie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: Boss loot table module
« Reply #15 on: January 11, 2007, 04:01:38 am »
You just need to delete that entry from the item db if you want.

delete from items where lowid = 260685;

tnx but i did find the error i need the itemsdb to get this to workcan sow plz can someone link it for me


Table 'bebot.items' doesn't exist
MySQL error (# 7) on query: SELECT lowid, highid, highql, name FROM items


                                                WHERE lowid = '245659'
Table 'bebot.items' doesn't exist
MySQL error (# 8) on query: SELECT lowid, highid, highql, name FROM items


                                                WHERE lowid = '245677'
Table 'bebot.items' doesn't exist
MySQL error (# 9) on query: SELECT lowid, highid, highql, name FROM items


                                                WHERE lowid = '245676'
Table 'bebot.items' doesn't exist
MySQL error (# 10) on query: SELECT lowid, highid, highql, name FROM items


                                                WHERE lowid = '246277'
Table 'bebot.items' doesn't exist
Threshold of 10 errors in 30 seconds reached. Supressing error output for 30 sec
onds

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #16 on: January 11, 2007, 08:45:19 am »
This of course only works if you have a local items database. :)
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #17 on: January 11, 2007, 02:13:14 pm »

tnx but i did find the error i need the itemsdb to get this to workcan sow plz can someone link it for me


You need sql from here and if you want, you can use your local db with a different items.php here
Eternalist
General of The Syndicate

Offline Metaphblade

  • BeBot User
  • **
  • Posts: 49
  • Karma: +0/-0
Re: Boss loot table module
« Reply #18 on: February 01, 2007, 08:44:18 am »
I can do a "!boss loot item" and it will work fine, but when i try to do a name, i get the following error.


Code: [Select]
Fatal error: Cannot use string offset as an array in C:\php\modules\boss.php on line 72
*****Edit*****
This error only occurs when i use !boss name beast  i can use heart or other names, just not beast.
« Last Edit: February 01, 2007, 08:46:18 am by Metaphblade »

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #19 on: February 01, 2007, 03:18:34 pm »
I've updated the php file in my original post. Grab it and see if it fixes your problem, which only occurs in php5. You don't need to download the sql again.
Eternalist
General of The Syndicate

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: Boss loot table module
« Reply #20 on: February 02, 2007, 12:03:55 am »
- Triggers are changed to !bossloot (you can change this back easily enough if u don't like it)
- Icons are added to loot output (by Axl)
- Loot output changed slightly
- !bossloot check in tell will check your !items database against the bossloot database and highlight missing/incorrect items.
- Includes PHP5 fix.

http://www.jjones.co.uk/files/boss.php

Offline Metaphblade

  • BeBot User
  • **
  • Posts: 49
  • Karma: +0/-0
Re: Boss loot table module
« Reply #21 on: February 02, 2007, 08:32:25 am »
Thanks  :)  seeing as how i was already using Malosar's version, i just re-downloaded his to make sure there were no additional unforseen problems.  It worked like a charm  :)

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #22 on: February 02, 2007, 02:03:58 pm »
- Triggers are changed to !bossloot (you can change this back easily enough if u don't like it)
- Icons are added to loot output (by Axl)
- Loot output changed slightly
- !bossloot check in tell will check your !items database against the bossloot database and highlight missing/incorrect items.
- Includes PHP5 fix.

http://www.jjones.co.uk/files/boss.php

Nice JJ, that boss check is handy, and tbh I think I like !bossloot better :) . Since it's fixed for all now, maybe add it in the modules posts for 2.x

I really don't know why I didn't fix it before, the answer was right in front of me and mentioned a couple of times lol.
« Last Edit: February 02, 2007, 02:07:29 pm by Malosar »
Eternalist
General of The Syndicate

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: Boss loot table module
« Reply #23 on: February 02, 2007, 02:18:56 pm »
Actually, the PHP5 issue in the plugin was on my todo list for ages also, so I'm really glad you fixed it :-)  I didn't wanna post any of the changes I'd made until it was fully working.

Next step really should be to sync the SQL with the !whereis webpage that was posted on the aodevs forum I guess (grrrr, so many things to do and so little time!).

I'll add the plugin to the A-Z later.

Thanks for your feedback and obviously the code in the first place :-)

Btw, using my 17.0.0.5 !items database, there were the 2 shade items dropping from LOTV that needed changing to the non nodrop version and a Phatmos items that just needed deleting in my database - same for yours?  If you could post the updated SQL I'd be grateful, I had some other additions in mine which are kinda silly (for a certain engineer in our org).

Cheers,

-jj-
« Last Edit: February 02, 2007, 02:20:40 pm by jjones666 »

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #24 on: February 02, 2007, 03:33:16 pm »
Great idea on incorporating with whereis which I use on my bot. I modified the module to show links instead of a location, and added links when showing a list of bosses for a specific loot. Whereis module from aodevs required of course :)

I also fixed those shade items entries for Lord of the Void you mentioned, and removed the phatmos loot.

I've updated my original post to reflect these changes. I also left in the "location" column for boss_name as people can use it to update their whereis databases if they wish. If it's notquite what you were thinking or would like it another way I'll give it a go as im not very busy at work lately :)
« Last Edit: February 02, 2007, 03:43:38 pm by Malosar »
Eternalist
General of The Syndicate

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #25 on: February 02, 2007, 04:34:52 pm »
Here's an updated whereis sql which also contains all the location data for all the boss entries in my db.
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #26 on: February 06, 2007, 03:42:52 am »
Dunno if this in the latest version of the boss_name table, I think I found some typos. Not 100% sure, I did not set out and check every single mob:
Anasis Favorite (should be Anansis Favorite)
Anitaaps Shadow (I think it should be Aniitaps Shadow), and missing the low-QL of the 220 version of the piercing evil
Apprentice Beasthandler drops Lava Capsule as well, at least my guide says that
I was told the Conflagrant spirit does not drop the ql260 version of the gun
Crete drops the conflagrant gun, and also the head symbiant of the love child
Distracted Snake Tamer drops snake tamer shield and guard
Ishimk'Imk drops the mark of the fisher king
Punctilious Hiathin is written Punctilious Hiathlin or Punctlious Hiathlin - not entirely sure.  ;D
Scrupulous Hiathin is written Scrupulous Hiathlin
Luuv  Bot-Keeper of Vengeance ^^*

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: Boss loot table module
« Reply #27 on: February 06, 2007, 02:10:08 pm »
Yeah it was never really a complete db, didn't know about the spelling errors either. It's also missing the hollow island bosses and loot as well. If I get a chance I'll correct and update the db, otherwise if you do so beforehand, please post here for others.

edit: got some time so updating it now.
« Last Edit: February 06, 2007, 02:44:55 pm by Malosar »
Eternalist
General of The Syndicate

Offline pusikas

  • BeBot Apprentice
  • ***
  • Posts: 161
  • Karma: +0/-0
Re: Boss loot table module
« Reply #28 on: February 06, 2007, 03:24:06 pm »
Am updating it as well, mebbe we can merge results somehow. It currently misses a lot of Ado bosses, and I'd like to add HI as well. Problem is getting a decent list of the bossloot that includes the locations as well. "NW ado" isn't exactly verbose. Would be grateful for any nice links. Otherwise I'll shoulder my knapsack and go visit the bosses myself. :)
Luuv  Bot-Keeper of Vengeance ^^*

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: Boss loot table module
« Reply #29 on: February 06, 2007, 03:38:37 pm »
Yeah it was never really a complete db, didn't know about the spelling errors either. It's also missing the hollow island bosses and loot as well. If I get a chance I'll correct and update the db, otherwise if you do so beforehand, please post here for others.

edit: got some time so updating it now.

I've done HI bosses already the other day, just didn't post yet.  Will do later if you didn't complete yet.

-jj-

 

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