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: New: Bebot Local Items database w/Icons!  (Read 47724 times)

0 Members and 2 Guests are viewing this topic.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
New: Bebot Local Items database w/Icons!
« on: May 01, 2006, 02:34:49 pm »
I know, I know, been a long time coming.
What with Vhab posting a remote version it kinda spurred me on to parse out a version that'll work with Bebot on a local level. I mean we have that speedy MySQL server sitting there why not use it eh?

Anyway, you'll need two files to see the Icons.
1.) The updated version on the Items database in this file bebot-items16.2.3.zip
2.) This updated Items.php
3.) (OPTIONAL) Clusters SQL File (Note: Must load main Items SQL script before loading this one)

16.3 UPDATE: 16.3.01 Items Update for Bebot is HERE! Just run the sql there against your bots database to update the Items table.

Some notes: Replace Items.php with the file above(make back up of original just incase) in the /modules folder
Use what ever method you're accustomed to update the items table with the SQL script file in that .zip. It will drop the current table before recreating it with the new data.

A special note about the Items database I have posted here:
 I'll say it bluntly. It was a PITFA to get it to parse correctly. A couple items may have their QL ranges off a bit but for the most part they are correct. I'm still perfecting my XML to SQL parsing script which is a very customized version of Angels AODBXMLparser v2.7

I tried to filter out as much of the crap items that players can't use, but I was getting rather tired browsing the unfiltered Items table looking for stuff to remove. For those wondering which got filtered, here's the SQL ran against the raw XML converted items table.
Code: [Select]
  $db -> query("delete from aodb_temp where ql = '' and icon = '';");
  $db -> query("delete from aodb_temp where name = ''
  or ql = ''
  or name regexp '\_001'
  or name regexp '\_300'
  or name regexp '\_400'
  or name regexp '.abiff'
  or name regexp 'abilityitem'
  or name regexp '\_boss'
  or name regexp 'dummy\_'
  or name regexp 'plc\_'
  or name regexp 'check\_'
  or name regexp 'Cluster -'
  or name regexp 'Implant:'
  or name regexp 'Equip\_'
  or name regexp 'Lootgiver'
  or name regexp 'RINGEVENT\_'
  or name regexp 'wearable'
  or name regexp 'NPC Pet Creation Item'
  or name regexp 'Construction Kit '
  ;");
  $db -> query("delete from aodb_temp where name = 'Combined Commando\'s Headwear' and icon = '0';");
  $db -> query("delete from aodb_temp where name like '%Kyr\'ozch%' and itemtype = 'Weapon' and icon < 90000");

Altogether those SQL statements removed approx 55kto 60k items.  :o Basically it halved what was there.
Attached a Pic of what a Multi-Item search will look like. Single item search returns places link in chat.
« Last Edit: August 30, 2006, 03:03:11 am by Xenixa »
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #1 on: May 01, 2006, 02:44:17 pm »
Nice work, really got to test this out!

Only one small request: could you please include the cluster in a next version?
It's often helpful to know how much a cluster of given QL buffs, and on which spots the cluster sits.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #2 on: May 01, 2006, 03:24:34 pm »
Sure, I can do one with and one without Clusters.

I'll hopefully have a better output of the SQL that correctly groups and sorts. I found a few nasty surprises in that version I have posted above. Nothing major but quite annoying really.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #3 on: May 01, 2006, 03:26:06 pm »
Seeing your filtering, why don't you just make a table with only the cluster, and make it available as add on?
Would be less work I guess.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #4 on: May 01, 2006, 03:32:00 pm »
Hmmm, thats even a better idea. :) Make a fully filtered version as I have now, then a seperate Bebot-Clusters.sql or whatever I call it when finished. Gotta head out to work right now but I should have time tonight to hash out something.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #5 on: May 01, 2006, 07:56:40 pm »
Hmm it appears to just use one icon on mine, ie. !items commando find the items but all with the head item icon :-)

Cheers,

-jj-

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #6 on: May 01, 2006, 10:17:56 pm »
Yeah, there is an error in the code for multiple results - it always shows the icon of the first result only.

Code: [Select]
$inside .= "<img src=rdb://" . $result[0][5] . ">"; 17 lines from the end needs to be
Code: [Select]
$inside .= "<img src=rdb://" . $result[$i][5] . ">";

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #7 on: May 02, 2006, 01:56:39 am »
I changed the $inside method to use foreach. It's much more efficient than for($i blah blah blah ... but I seemed to have placed the wrong version on my ftp server early this morning.

Or:
Code: [Select]
foreach ($result as $list)
        {
        $inside .= "<img src=rdb://" . $list[5] . ">\n";
            $inside .= "<a href='itemref://" . $list[0] . "/" . $list[1] . "/" . (($ql == 0) ? $list[3] : $ql) . ">" .
$list[4] . "</a> <font color=CCCCTextColor>[QL " .
$list[2] . "-" . $list[3] . "]</font>\n\n";
            }

Also fixed a problem with searching for items with apostrophys in the name.
Updated and Correct Items.php is on my ftp server now. Same link as above.

« Last Edit: May 02, 2006, 02:58:47 am by Xenixa »
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #8 on: May 02, 2006, 02:57:20 am »
And as requested by Alreadythere

ftp://xen.afraid.org/bebot_files/bebot16.2.3clusters.sql

Using that SQL script assumes you already loaded an items table onto your bots database.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #9 on: May 02, 2006, 08:30:50 am »
Thanks Xenixa, thats perfect, and the additional clusters are useful :-)

Just one thing I found in the .sql, the combined commando headwear entries can be changed to the below, as this item is bugged in the database and appears twice (one type doesn't appear in the game).

insert into `items` (`lowid`,`highid`,`lowql`,`highql`,`name`,`icon`) values (246657,246658,1,300,'Combined Commando\'s Headwear',256311);

Thanks again :-D

-jj-

Offline kuznechik

  • Contributor
  • *******
  • Posts: 60
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #10 on: May 02, 2006, 09:12:49 am »
Was prehistoric symbs filtered in this database?
Would be nice.
Kuznechik, proud bot admin of Disciples of Omni-Tek, Rimor.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #11 on: May 02, 2006, 11:27:18 am »
Thanks for the cluster!

Personally I removed the following items from the table, as I felt they just clutter it:
LIKE '%Compiled Algorithm%'
LIKE '%Photon Particle Emitter%'

Ok, I lost PPPE(shape soft/hard) this way. But I won't miss that in my table.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #12 on: May 02, 2006, 12:42:13 pm »
Updated the main Items SQL again. I reparsed it using some better logic to sort low & high id's and ql's. Old one had a bunch were the low and high were reversed.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

Offline Tsuyoi

  • BeBot User
  • **
  • Posts: 30
  • Karma: +0/-0
  • BigT
    • Adrenaline Rush Forums
Re: New: Bebot Local Items database w/Icons!
« Reply #13 on: May 02, 2006, 05:01:36 pm »
Was prehistoric symbs filtered in this database?
Would be nice.

Not exactly sure how the output is parsed, but the db entries have a lowid of the old symbs and highid of the new ones.  I'm guessing you could just copy over the highid to the lowid since it's not a ql range, but I'm not sure..

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #14 on: May 02, 2006, 11:31:00 pm »
Was prehistoric symbs filtered in this database?
Would be nice.

Not too sure what you mean by prehistoric symbs. All the Symbiants in the database are included in this copy. Even the ones that don't drop.
<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky

 

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