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

shilli · « **Reply #15 on:** January 11, 2007, 04:01:38 am »

Quote from: Malosar on January 11, 2007, 02:20:51 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 (#

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

pusikas · « **Reply #16 on:** January 11, 2007, 08:45:19 am »

This of course only works if you have a local items database.

Malosar · « **Reply #17 on:** January 11, 2007, 02:13:14 pm »

Quote from: shilli on January 11, 2007, 04:01:38 am

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

Metaphblade · « **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.

Malosar · « **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.

jjones666 · « **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

Metaphblade · « **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

Malosar · « **Reply #22 on:** February 02, 2007, 02:03:58 pm »

Quote from: jjones666 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

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.

jjones666 · « **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-

Malosar · « **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

Malosar · « **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.

pusikas · « **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.

Scrupulous Hiathin is written Scrupulous Hiathlin

Malosar · « **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.

pusikas · « **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.

jjones666 · « **Reply #29 on:** February 06, 2007, 03:38:37 pm »

Quote from: Malosar 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.

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

-jj-

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

shilli

Re: Boss loot table module

pusikas

Re: Boss loot table module

Malosar

Re: Boss loot table module

Metaphblade

Re: Boss loot table module

Malosar

Re: Boss loot table module

jjones666

Re: Boss loot table module

Metaphblade

Re: Boss loot table module

Malosar

Re: Boss loot table module

jjones666

Re: Boss loot table module

Malosar

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

jjones666

Re: Boss loot table module