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

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

Author Topic: New: Bebot Local Items database w/Icons!  (Read 89587 times)

0 Members and 1 Guest are viewing this topic.

Offline kuznechik

  • Contributor
  • *******
  • Posts: 60
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #15 on: May 02, 2006, 11:43:25 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.
Ones that has too big reqs. Clear example is 230 control brain, it has no "current-day" twin.

http://auno.org/ao/db.php?id=219326 - old
http://auno.org/ao/db.php?id=235589 - new
For my orgbot I've just dumped and dropped all symbs then cleared dump from oldies and re-added it to db.
Can't send you dump due to diff DB format :)
Kuznechik, proud bot admin of Disciples of Omni-Tek, Rimor.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #16 on: May 03, 2006, 01:50:18 am »
Ahhh ok, I took a look and compared closely.
 Basically any Symbiant that has a AOID starting with 235 or 236 is ingame were as Symbiants that start with an AOID of 219 or 220 aren't.

I can fix that easy enough in my parsing script as it writes each item out to the database I'll have it make the lowid = highid where name like '%Symbiant,%'.

-------------Edit-------
And appearently my logic failed the first time through about the ID's, there are a couple of exceptions.
Pretty sure I got it right now, here's a correctly parsed set of Symbs for items table:
ftp://xen.afraid.org/bebot_files/bebot16.2.3symbs.sql

Running that script will delete all current Symbiants listed in your items table and reinsert the correct current set.
« Last Edit: May 03, 2006, 06:22:56 am by Xenixa »
<<< 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 #17 on: May 03, 2006, 10:04:54 am »
Thanks again =)

-jj-

Offline kuznechik

  • Contributor
  • *******
  • Posts: 60
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #18 on: May 03, 2006, 11:20:27 am »
You've killed brumal chest symb and love child symb :)
It's unique Ado drop that can be installed in implant places.
(I've dropped them too on my 1st try :))
Kuznechik, proud bot admin of Disciples of Omni-Tek, Rimor.

Offline Tsuyoi

  • BeBot User
  • **
  • Posts: 30
  • Karma: +0/-0
  • BigT
    • Adrenaline Rush Forums
Re: New: Bebot Local Items database w/Icons!
« Reply #19 on: May 03, 2006, 03:39:01 pm »
I went thru and just manually rewrote em all for nothing yesterday :(

Oh, btw, I noticed that "Enduring Support Brain" gives 0 results while "Enduring Brain Support" gives the correct result.  I've always enjoyed the convience of being able to mix 'n match my query, anyway this can be done w/ this Items?

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #20 on: May 04, 2006, 03:15:54 am »
I went thru and just manually rewrote em all for nothing yesterday :(

Oh, btw, I noticed that "Enduring Support Brain" gives 0 results while "Enduring Brain Support" gives the correct result.  I've always enjoyed the convience of being able to mix 'n match my query, anyway this can be done w/ this Items?

No, the SQL db search uses LIKE '%$name%'  so if the words you use aren't in the order the appear in the name field they won't get a hit. The only way I can think of doing an 'out of order' serach is to use Soundex, but that takes more server overhead and just makes things more complicated. Also it can cause it to return more items than you wanted. Easier just to search the name properly.

Oh, and I never even knew of those Brumal and Love Child symbs before. Here's the info to put those back in:
Code: [Select]
insert into `items` (`lowid`,`highid`,`lowql`,`highql`,`name`,`icon`) values (245306,245306,150,150,'Brumal Chest Symbiant of Endurance',215183);
insert into `items` (`lowid`,`highid`,`lowql`,`highql`,`name`,`icon`) values (245895,245895,250,250,'Head Symbiant of the Love Child',215189);
<<< 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 #21 on: May 05, 2006, 06:09:48 am »
k, Didn't know if the LIKE had the ability to do an out-of-order search.  Thanks for all your work Xen, love the module :)

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #22 on: May 09, 2006, 03:37:14 am »
Fixed a bug in Items.php I have posted here that would cause AORC+(build 48) to crash on a multi-item search return. New version on FTP link in first post of this thread.

Oh one of the side effect bugs that also had to be fixed was changing the function make_item in bot.php
The quotes surrounding the itemref:// aren't needed and they play havok with external chat clients.

Change from:
Code: [Select]
function make_item($lowid, $highid, $ql, $name)
{
return "<a href=\"itemref://" . $lowid . "/" . $highid . "/" . $ql . "\">" . $name . "</a>";
}
To:
Code: [Select]
function make_item($lowid, $highid, $ql, $name)
{
return "<a href=itemref://" . $lowid . "/" . $highid . "/" . $ql . ">" . $name . "</a>";
}
« Last Edit: May 09, 2006, 05:09:55 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 #23 on: May 10, 2006, 05:34:17 pm »
There is a problem with the kyr weapons (perhaps some other items too, not sure though).
The !items search can't show interpolated ones.

There aren't the correct lowID/highID in the table, I think the entries for the weapon in game are mixed with entries for those AI guns that never made it in game (all those with wrong icons).

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #24 on: May 11, 2006, 04:33:46 pm »
Ya I noticed that myself about 2 days ago, haven't had much time to sit and play with the parsing script to make Kyr'Ozch items correctly.
<<< Hack's in Zend Studio

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

Offline Pharexys

  • BeBot Apprentice
  • ***
  • Posts: 117
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #25 on: May 13, 2006, 02:13:08 pm »
nice work, using it and rawks :P

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #26 on: May 22, 2006, 06:23:04 pm »
OK... Fixed my parsing script and got Kyr'Ozch items to come out right.

Run this SQL script against your current items table to fix'em up
(Note: It'll remove every single Kyr item first before adding in the correct Kyr items):
ftp://xen.afraid.org/bebot_files/kyrozch-items.sql

The main Items SQL script in the first post has also been updated to reflect those item fixes along with a few other items I found along the way. Also the Symbiant Fixes discussed earlier here and the 1 Combined Commando's item fix are in there.

Known issue:
- Omni-Pol, Life Guard, and some other Omni labeled armors still not parsing correctly(namely the ones that start with "Advanced" or "Quality". I'll be working on those parsing filters as time permits, not really highly searched items so... meeeh.
<<< Hack's in Zend Studio

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

Offline captainwinky

  • BeBot User
  • **
  • Posts: 32
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #27 on: May 23, 2006, 06:05:56 am »
excellent module.  even better now  ;D
nice work.

Offline buff

  • BeBot User
  • **
  • Posts: 36
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #28 on: June 08, 2006, 05:41:56 am »
well tried it but it seems there's problem w/ fuzzy nano input hood
it won't show the correct data so if u can look into it it would be nice to have it fixed :)

Offline Joeynumbahz

  • BeBot Rookie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #29 on: June 09, 2006, 01:47:10 am »
Helps if you explain the problem a little further... ;-)

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


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


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

* Who's Online
  • Dot Guests: 111
  • 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