Booya
collapse collapse

Menu

* User Info

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

* Search


* Board Stats

  • stats Total Members: 1066
  • stats Total Posts: 18273
  • stats Total Topics: 2482
  • stats Total Categories: 7
  • stats Total Boards: 31
  • stats Most Online: 323

Author Topic: New Central itemDB (!item[s|reg])  (Read 378429 times)

0 Members and 8 Guests are viewing this topic.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
Re: New Central itemDB (!item[s|reg])
« Reply #315 on: October 02, 2011, 09:32:29 pm »
You are not supposed to search for items by ID.
!item ID <- Show item by ID
!items NAME <- search for item by name

This works for everyone else and must be something wrong from your side as you are doing search by ID and not name in the search string. I cannot fix that problem for you.
Check if you have made a comalias for !item pointing to !items (!help comalias)

Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline wabbit

  • BeBot Rookie
  • *
  • Posts: 8
Re: New Central itemDB (!item[s|reg])
« Reply #316 on: October 02, 2011, 09:56:29 pm »
We search like this in guild chat.

!items tiger

Then the bot returns with the search results and we click the search results link for "tiger".

Now the window is open showing the search results for "Tiger"

We click the desired item "Tiger Blood" and it sends an automatic tell to the bot for an item number like this.

To [Gbot]: !item 4495692

The bot returns with this.

[Gbot]: Sorry, your search '4495692' didn't give any result.

I can add a screenshot if needed

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
Re: New Central itemDB (!item[s|reg])
« Reply #317 on: October 02, 2011, 10:59:34 pm »
Quote
Check if you have made a comalias for !item pointing to !items (!help comalias)
I can see in backlog that your bot search by item number, but it should search by item name. So check the comalias...

Screenshot can be helpfull..
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline wabbit

  • BeBot Rookie
  • *
  • Posts: 8
Re: New Central itemDB (!item[s|reg])
« Reply #318 on: October 02, 2011, 11:24:45 pm »
Quote
Check if you have made a comalias for !item pointing to !items (!help comalias)
I can see in backlog that your bot search by item number, but it should search by item name. So check the comalias...

Screenshot can be helpfull..

That is exactly what the problem was!

Somehow we had a comalias pointing to !item . Thanks dude!

Offline BoA-Gert

  • BeBot User
  • **
  • Posts: 45
Re: New Central itemDB (!item[s|reg])
« Reply #319 on: October 13, 2011, 01:30:11 am »
Had a lot of MySQL crashes when Crom came back up briefly on the global sniffer for Crom - seems the new Russian chat causes some problems for the Crom sniffer...

Offline Harth

  • BeBot Rookie
  • *
  • Posts: 2
Re: New Central itemDB (!item[s|reg])
« Reply #320 on: April 10, 2012, 07:28:00 am »
Hi, Is this still running and available?


Cheers

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
Re: New Central itemDB (!item[s|reg])
« Reply #321 on: April 12, 2012, 07:19:50 am »
Its not been shutdown  ;)
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Harth

  • BeBot Rookie
  • *
  • Posts: 2
Re: New Central itemDB (!item[s|reg])
« Reply #322 on: April 12, 2012, 07:37:20 am »
How would i go about... getting the database address and password? : ;D

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
Re: New Central itemDB (!item[s|reg])
« Reply #323 on: April 12, 2012, 08:51:13 am »
By reading the topic and first post
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Miron

  • BeBot Rookie
  • *
  • Posts: 7
Re: New Central itemDB (!item[s|reg])
« Reply #324 on: June 17, 2012, 09:39:10 pm »
Hello there, my guild bot started giving "Error in query to database" for some reason. Haven't change anything on my guild bot for ages so I am wondering if there is something wrong with items db or the problem is at my side. Thanks in advance. :)

Offline cynara

  • BeBot Rookie
  • *
  • Posts: 1
Re: New Central itemDB (!item[s|reg])
« Reply #325 on: November 24, 2012, 10:40:53 am »
It seems that in update 4.0, which is currently on testlive, the item links will change a little bit.    Here's a fix to make the old links (returned by the item database server) work with the 4.0 game client: in the command_handler function in Items.php, replace
Code: [Select]
return $this -> bot -> core('items') -> search_item_db_details($words);
with
Code: [Select]
return preg_replace(
    '#itemref://([0-9a-f]*)/([0-9a-f]*)/0/([1-9][0-9]?)/([0-9a-f:]*)/([0-9a-f:]*)/([0-9a-f:]*)([^/0-9a-f:])#i',
    'itemref://$1/$2/0/0/$3/$4/$5/$6/$6$7',
    $this -> bot -> core('items') -> search_item_db_details($words));

P.S.  With some further experimentation, it seems that most of the digit salad at the end of the link is completely irrelevant, as long as there's something there.  E.g. I linked a Bloodseraph's Chestguard in a tell to the bot and the logs showed that the bot received this link:
Code: [Select]
itemref://3800224/3800224/0/0/80/6df3ae75:8c0cf53b:e81418d0:93d4c95a/6df3ae75:8c0cf53b:e81418d0:93d4c95a/b290805c:29e627ca:b290805c:29e627ca/b290805c:29e627ca:b290805c:29e627caBut when I manually changed it to
Code: [Select]
itemref://3800224/3800224/0/0/80/0:0:0:0/0:0:0:0/0:0:0:0/0:0:0:0it worked just as fine.  So the main thing seems to be that you now need to have 4 groups of 4 numbers, whereas before this update you had 3 groups of 4 numbers.  The "/80/" segment is the item level that gets displayed when you click the item link (you can change it and the game will show a different level in the tooltip).
« Last Edit: November 24, 2012, 11:14:43 am by cynara »

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
Re: New Central itemDB (!item[s|reg])
« Reply #326 on: November 25, 2012, 02:55:16 pm »
Thanks for the headsup.

The digitsalad was relevant before, because if you put wrong values on some items you could crash the gameclient actually..
This is probly fixed by now, but to make sure it doesnt this will still be best to have in the link.

Will look at backend of itemDB when this hits liveserver to add needed changes.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline RaZeR

  • BeBot User
  • **
  • Posts: 28
Re: New Central itemDB (!item[s|reg])
« Reply #327 on: November 27, 2012, 09:55:04 am »
very interesting. I dare say the extra field will be used for the crafting revamp, where you can craft items with innate bonus stats (seemingly dependent on throwing in extra ingredients during the crafting process). They probably store the bonus stats while keeping the base stats and graphics the same.

Offline Goratt

  • BeBot Rookie
  • *
  • Posts: 2
Re: New Central itemDB (!item[s|reg])
« Reply #328 on: April 04, 2013, 10:17:46 am »
Hi all,

I need to have details on how to connect my Bot to new Items Central Database

My info is:
Bot: Myrmidonbot
Dimension: Crom

Thx in advance.



Offline WeZoN

  • Global Moderator
  • *****
  • Posts: 92
Re: New Central itemDB (!item[s|reg])
« Reply #329 on: April 04, 2013, 08:18:26 pm »
Hi all,

I need to have details on how to connect my Bot to new Items Central Database

My info is:
Bot: Myrmidonbot
Dimension: Crom

Thx in advance.



I'll just copy what Getrix wrote in the very first post. 


"If you wanna have access to the Alternative itemDB, please send me a PM with Botname and AoC dimension and i will replie ASAP with link to modified module files, passkey and small info to get you up and run against Alternative itemDB."

 

* Recent Posts

NEED Help Bebot on Ubuntu 16 with PHP 7.2 by bitnykk
[June 08, 2018, 11:47:01 am]


New Central itemDB (!item[s|reg]) by Kakahu
[May 16, 2018, 09:22:47 pm]


Tradeskill's Recipes Module by bitnykk
[February 17, 2018, 01:49:04 pm]


Twink helper Module by bitnykk
[February 04, 2018, 11:07:24 pm]


Some slight issues! by bitnykk
[October 04, 2017, 11:53:10 am]

* Who's Online

  • Dot Guests: 106
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Forum Staff

Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator