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

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18365
  • 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 78538 times)

0 Members and 4 Guests are viewing this topic.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #30 on: June 09, 2006, 02:18:41 am »
Pretty easy to fix just searching the item on Auno then comparing the values in your local table. That is looking at whats currently parsed the low and high ID and QL's didn't come out right.

Or in SQL
Code: [Select]
delete from `items` where `lowid`='248764'
update `items` set `lowid`='248763',`highid`='248764',`lowql`='1',`highql`='220',`name`='Fuzzy Nano Input Hood',`icon`='41157' where `lowid`='248763'
« Last Edit: June 09, 2006, 02:31:21 am by Xenixa »
<<< Hack's in Zend Studio

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

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: New: Bebot Local Items database w/Icons!
« Reply #31 on: June 20, 2006, 05:16:31 pm »
Is it possible you could make a separate SQL of the entire list of implants? Not even the original db's have all the implants and I need them for a module im making.
Eternalist
General of The Syndicate

Offline Wolfbiter

  • Contributor
  • *******
  • Posts: 149
  • Karma: +0/-0
    • KAZE
Re: New: Bebot Local Items database w/Icons!
« Reply #32 on: June 25, 2006, 11:46:27 am »
Seems the enforcer tier2/chosen armor is missing in the sql.
« Last Edit: June 25, 2006, 11:56:14 am by Wolfbiter »
Too many toons.

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #33 on: June 25, 2006, 01:14:48 pm »
Works here - did u try reimporting?

-jj-

Offline Wolfbiter

  • Contributor
  • *******
  • Posts: 149
  • Karma: +0/-0
    • KAZE
Re: New: Bebot Local Items database w/Icons!
« Reply #34 on: June 25, 2006, 05:17:06 pm »
This is odd.. I searched the .sql and didn't find anything, but now when I searched for the id it came up.. so I did a reimport (as you said) and it seems to be working now, quite odd.
Thanks.
Too many toons.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #35 on: August 28, 2006, 03:37:25 pm »
Just so ya'll know. I am still around and I do still run a Bebot. I just had one killer busy Summer this year.

Anywho. With 16.3 coming I will be parsing out an updated items sql with 16.3 items added and hopefully finish fixing some of the filters for RK armors with 'Advanced', 'Quality' and what not in their names. I have a rudimentary XML file with items added in 16.3 from the Test server but kind of want to hold off on using it until FC blesses the data fit for live.
<<< 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 #36 on: August 30, 2006, 03:04:35 am »
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.
<<< 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 #37 on: August 30, 2006, 12:50:32 pm »
Cheers Xen!

-jj-

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: New: Bebot Local Items database w/Icons!
« Reply #38 on: August 30, 2006, 05:02:08 pm »
awesome thanks.
Eternalist
General of The Syndicate

Offline Dabaron

  • BeBot Apprentice
  • ***
  • Posts: 163
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #39 on: September 02, 2006, 03:03:52 am »
Love the update... thanks for that!!

Side note, anyone happen to have an idea as to why the pictures for the new items don't show?  The icon field in the sql database is set for them and is right but they don't show... I'm kind of at a loss here.

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #40 on: September 03, 2006, 01:30:17 am »
Which items don't show? I havn't seen any that didnt have an Icon appear in a multi-item hit.
Single item hits only place a ref in chat so you don't have to open a window to click the item. Saves a click if you will. :)
<<< Hack's in Zend Studio

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

Offline porter

  • BeBot User
  • **
  • Posts: 28
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #41 on: September 10, 2006, 06:24:28 pm »
Very nice module! I noticed something yesterday that is easy to fix and should help people who type too much details into a query :)

It did not seem to find "Hud upgrade: enhanced target acquisition" because of the colon in the search criteria. I changed the detail where spaces are converted to wildcards to also convert colon and some other punctuation. That way even if people search items with some misplaced quotes, commas or with that ":" in the exact right place the bot finds the item. The commas and brackets etc. are a matter of taste and most of the time useless I suppose, but it does seem to require the colon to be treated at least.

Code: [Select]
$punctuation=array(":"," ","'",'"',"(",")",",");
      $name2 = str_replace($punctuation, "%", $name);
        $name2 = str_replace("%%", "%", $name2);

Offline Dabaron

  • BeBot Apprentice
  • ***
  • Posts: 163
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #42 on: September 11, 2006, 08:46:06 am »
Which items don't show? I havn't seen any that didnt have an Icon appear in a multi-item hit.
Single item hits only place a ref in chat so you don't have to open a window to click the item. Saves a click if you will. :)

All 16.3 items show with no icon in mine for some odd reason.  I can't seem to locate the source of the problem.

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: New: Bebot Local Items database w/Icons!
« Reply #43 on: September 11, 2006, 02:02:53 pm »
All 16.3 items show with no icon in mine for some odd reason.  I can't seem to locate the source of the problem.

Do you have the updated items.php from the first post?
Eternalist
General of The Syndicate

Offline Xenixa

  • Contributor
  • *******
  • Posts: 307
  • Karma: +0/-0
Re: New: Bebot Local Items database w/Icons!
« Reply #44 on: September 12, 2006, 04:59:19 pm »
Very nice module! I noticed something yesterday that is easy to fix and should help people who type too much details into a query :)

It did not seem to find "Hud upgrade: enhanced target acquisition" because of the colon in the search criteria. I changed the detail where spaces are converted to wildcards to also convert colon and some other punctuation. That way even if people search items with some misplaced quotes, commas or with that ":" in the exact right place the bot finds the item. The commas and brackets etc. are a matter of taste and most of the time useless I suppose, but it does seem to require the colon to be treated at least.

Code: [Select]
$punctuation=array(":"," ","'",'"',"(",")",",");
      $name2 = str_replace($punctuation, "%", $name);
        $name2 = str_replace("%%", "%", $name2);
This would be becuase of the way a colon is stored in MySQL. It's stored as an html entity.
Or in this case
Code: [Select]
$name = str_replace(":", ":", $name);It's the only punctuation case in the database that gets html entity encoded. Everything else in the array you added gets recorded directly or is handled by the addslashes() function.
<<< Hack's in Zend Studio

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

 

* Recent Posts
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 ]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm ]

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