BeBot - An Anarchy Online and Age Of Conan chat automaton

Age of Conan => AoC 0.6.x Custom/Unofficial modules => Topic started by: Getrix on September 22, 2009, 04:27:12 pm

Title: New Central itemDB (!item[s|reg])
Post by: Getrix on September 22, 2009, 04:27:12 pm
(http://aoc-itemdb.sjef.biz/gfx/stats.php)

Announce:
Noer announced that he would have taken down his DB as he isnt playing the game anymore (Hasnt for long time..)
I still havent decide to open up my itemDB to everyone without require ppl to ask me to get a passkey.
I may when i got time to recode some of the backend open for search/add item without passkey, but still require passkey for new functions i have planned ;)

If you wanna have access to the New Central 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 New Central itemDB. (PS: If you dont give the Botname and Dimension info, i will not reply you)

Globalchat item sniffers on following servers:
Status outdated

Server that need GlobalItemSniffer sponsors:
Status outdated

-Getrix, Fury

News/Info:
2010-01-10: Guilbots also on: Ironspine, Stygia
2009-12-01: Following servers have guildbots running against this DB: Aquilonia, Aries, Asgard, Cimmeria, Crom, Fury, Gwahlur, Hyrkania, Ishtar, Mitra, Scarlet Citadel, Set, Two Eagles, Tyranny, Wiccana
2009-11-17: Problem with host. Fix is underway.
2009-10-30: Thanks to "Yite" globalchat item sniffer is up on "Aquilonia"
2009-10-28: Noer have cut the cables on old official itemDB. As there isnt any other itemDB out there, this will probly change to official..
2009-10-08: Again sorry for problem with itemDB today. Moved to a new server. Hopefull for last time as its my new epic dedicated server :P
2009-10-03: Sorry for "downtime" today. The vhost on server was removed by mistake. Back now.
2009-09-28: Thanks to "Luclia" globalchat item sniffers are up on german server Mitra!
2009-09-28: Thanks to "keirou" globalchat item sniffers are up on Tyranny, Set, Wiccane and Cimmeria!
2009-09-24: Set guild (USA) and another Mitra guild (DE) is reporting to itemDB
2009-09-23: Mitra guild (DE) is reporting to itemDB
2009-09-22: ItemDB was moved to better host. Flush your DNS or wait if you get messages about it.

Quote from: Post background
I have for the last 6months sniffed item info from Fury and Crom (Global).
Today the alternative itemDB contains 17008 items that are reported to it by 14 guildbots (Crom,Fury,Gwahlur,Tyranny,Set,Mitra) and the two Global sniffers on Fury and Crom.

From what i can tell, it works like it supposed to do. New item gets added, and the DB is searchable.

This DB was not made to compete with Noer's official BeBot itemDB. But as he or nobody else in BeBot Dev is playing AoC and seems to not have the biggest interest for AoC i made the alternative itemDB.

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.
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 23, 2009, 01:59:20 pm
Hey getrix, is the one I was using previously still working?? Have had issues trying to call items
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 23, 2009, 02:04:47 pm
Yes, its the same DB you got from me.

If you have problem it would be great to get some info about it.
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 24, 2009, 08:29:12 am
[2009-09-24 06:23:45]   [GROUP]   [MSG]   [Third Time Lucky] Sabien: <a style="text-decoration:none" href="itemref://3875265/3875265/64/b3b63818:d1227b2e:5ec04119:cf8485bf/b3b63818:d1227b2e:5ec04119:cf8485bf">[Weaponsmith: Silveredge Sword][/link]

Warning: Mising argument 3 for Items_Core::submit_item(), called in C:\Users\XXX\Games\Bot\modules\aoc\Items.php on line 134 and defined in C:\Users\XXX\Games\Bot\modules\aoc\Items.php on line 102

Warning: Mising argument 4 for Items_Core::submit_item(), called in C:\Users\XXX\Games\Bot\modules\aoc\Items.php on line 134 and defined in C:\Users\XXX\Games\Bot\modules\aoc\Items.php on line 102

Warning: socket_connect():unable to connect
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 24, 2009, 08:54:24 am
You are sure you downloaded and replaced both files i sent you? You could try to download them again. And make sure you set Server and Passkey in settings

To me it looks like you have broken other parts of your bot. Dont get this error my self or anyone else have been reporting it. Can see in the DB that other have it working by new items is still being registered.
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 24, 2009, 05:10:28 pm
got it working again

dunno what went wrong
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 27, 2009, 11:54:33 am
Is there anyone willing to setup item sniffing bot for globalchat on servers? Im allready running this for Fury and Crom, so dont need it there.

Not recomended to run on same as Guildbot, but would be nice if someone had a free char slot they will "donate" to this use. Pm me if you are interested.
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 27, 2009, 05:15:47 pm
we have recently had a few mergers of which i was running bots for the other guilds so now have spots free
just let me know exactly how to set it up to it doesnt spam the other servers ;)
Title: .
Post by: Getrix on September 27, 2009, 06:26:21 pm
Sent you pm keirou
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Khalem on September 27, 2009, 06:39:40 pm
Given that Noer is awol and there is no way to update the database from what i can understand i would be more than happy to change the official BeBot items database for AoC to your database Getrix if that is of interest to you.

Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 27, 2009, 08:29:15 pm
@Khalem
Difference between my and Noers itemDB is that im currently and probly will require a passkey to access it. This to keep track of bots using it and where new item is comming from. To prevent abuse and fake items. (Easy to ban a bot/nick etc if so).

I have plans to put up a webpage to easy request this passkey (Almost automatic), but atm doing it manual.
Also looking into selecting language to use as AoC have own itemname for DE,FR and ES

But if this is accepted, sure i will be happy to get the changes into official packages.
It can maybe be added as alternative choice in start with underscore infront so ppl can choice themself?
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 28, 2009, 03:44:02 am
set 3 up sofar
set
cimmeria
tyranny

trying to work out how to setup my wiccana one.. can create the bot but cannot logon a toon to set the settings lol
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 28, 2009, 10:56:13 am
Nice, thanks alot for this support keirou!

Hope this will boost the DB


EDIT: Post nr 100 for me=)
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: keirou on September 28, 2009, 12:54:16 pm
the 4 busiest US servers now have global monitored, and the most progressed guild on gwahlur is monitered.
grats on post 100 :)

if i can be bothered purchasing slots i will run 2 more :p lol
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on September 28, 2009, 11:31:24 pm
Thanks to "Luclia" globalchat item sniffers are up on Mitra!
This means the DB will be feeded with German itemnames, and one step closer to supporting more language ;)
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Luclia on September 29, 2009, 11:10:27 am
NP. Its a pleasure to help :)
As i see in the DB its working good:)
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on October 08, 2009, 10:26:23 pm
Again sorry for problem with itemDB today. Moved to a new server. Hopefull for last time as its my new epic dedicated server :P

Most likely alot of ppl think they got "World's first" today. But this wasnt saved to the database, so everytime someone linked something the script didnt lookup in DB and thought everyone was linking new stuff.. ::)

Problem is solved now
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: amerigo on October 09, 2009, 08:02:06 pm
I am getting this message from bot....

[...bot]: Setting Server for module Items does not exist.


i have followed the instructions to set it up with the files... maybe i misunderstood something.
do the files realy stay as .phps ?

the bot is now unable to operate with the command !items...

what could be wrong
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on October 09, 2009, 08:26:50 pm
Quote
And move:
Core_Items.phps -> <Botfolder>/core/aoc/Items.php
Modules_Items.phps -> <Botfolder>/modules/aoc/Items.php

RTFM ;P
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Monk4y on October 19, 2009, 03:15:04 pm
this has been running great for a few months now, we havent noticed any issues yet.

thanks
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Noer on October 19, 2009, 03:47:09 pm
Is this project still running? If so we can arrange that you get the database I have. It currently features 14,340 items and around 40,000 events with who found what items first and on what server etc...
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on October 19, 2009, 03:55:50 pm
Yes, im still running and maintaining this alternative DB and have some plans for future updates.
Would be interested to see whats in your DB, and maybe sync it up with this alternative one.

The biggest difference between mine and yours is that I require passkey handed out to bot owners to prevent abuse. But so for it doesnt that seem to be any problem as ppl just pm to get it.
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on October 26, 2009, 03:14:36 pm
Quote
Announce:

Noer announced that he would take down his DB as he isnt playing the game anymore (Hasnt for long time..)
I still havent decide to open up my itemDB to everyone without require ppl to ask me to get a passkey.
I may when i got time to recode some of the backend open for search/add item without passkey, but still require passkey for new functions i have planned ;)
Title: Re: Alternative central itemDB (!item/!items/!itemreg(auto))
Post by: Getrix on October 28, 2009, 01:57:59 pm
Quote
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.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 28, 2009, 10:34:17 pm
Quote
Server that need GlobalItemSniffer sponsors:
EU: Crom, Fury, Blackscar, Skullcrusher, Hyrkania, Skullcrusher, Aquilonia
DE: Aries, Asgard
FR: Isthar, Ferox, Stygia
ES: Zingara, Indomitus

Anyone interested in putting up a global chat item sniffer?
I need to free some slots (Need it for dev bot's) and cant host for Crom and Fury anymore.

You need one free slot. And the bot will listen to Global but dont talkback to anyone exept OWNER.
Its not good solution to run it on a Guildbot..
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on October 28, 2009, 10:38:38 pm
I have a spare char slot on my bots account so can run for Crom as long as I know what to do ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on October 29, 2009, 12:29:37 pm
Same (for Crom but could run it on a different server as well) as long as you tell me what to do :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 29, 2009, 12:39:36 pm
Crom Global is up again, thanks to BoA-Gert.

Will send you a PM with info Yite.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Noevo on October 29, 2009, 08:02:52 pm
Need a little help, having a problem where i get them message "Wrong checksum for botname" when ever i do a !items xxxx.   Verified passkey and server correct in !settings, re-copied items core and moduels items files, restart bot same issue.  Nothing changed since it was working a couple days ago except the necessary changes to AOChat.php after patch.  Thoughts?

Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on October 30, 2009, 12:40:52 am
I had that - turned out I was using uppercase characters (eg. BoABot) when it should be proper case (eg Boabot).  Might be the same for you?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Noevo on October 30, 2009, 02:15:11 am
Will check it out BoA-Gert, thanks
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 30, 2009, 08:04:14 am
Was fixing some up-lower case bug in backend some days ago, but please let me know here what you find out.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Noevo on October 30, 2009, 08:35:44 pm
Changing bot name to uppercaser first letter from lowercase in conf/bot.conf did the trick. 

Thanks for the heads up BoA-Gert :)

Thats something that definetly had not changed Getrix so FYI if anyone runs into it
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 31, 2009, 12:59:03 am
Yeah, i know why you got it. The fix was client and backend fix ^^
Nothing urgent, so no need to download new version before i have time to do new stuff.
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on October 31, 2009, 05:44:37 am
Good to hear it was that and nothing else :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on November 03, 2009, 06:47:27 pm
Connected from Hyrkania, working like a charm.

Thanks *smiles wide*
Title: Re: New Central itemDB (!item[s|reg])
Post by: Monk4y on November 05, 2009, 04:03:03 pm
im getting this message now:

To [Dbot]: items hexsteel
[Dbot]: An existing connection was forcibly closed by the remote host.

its been working fine for months now - any idea what the issue could be?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 05, 2009, 04:43:37 pm
You upgraded your bot from X to 0.6.6 and overwrited the costume made .php files you used before upgrade..?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Monk4y on November 05, 2009, 06:43:41 pm
You upgraded your bot from X to 0.6.6 and overwrited the costume made .php files you used before upgrade..?

sniff, yeah thats exactly what happened. thanks for the tip.

lucky i saved the mail you sent me eh :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: viggen on November 05, 2009, 10:57:26 pm
How do i remove the  info from the sever and passkey so i can revert back to original?  make the field blank so it does not search for the server.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 06, 2009, 06:59:44 am
It doesnt mather if you revert to original. Because Noer's official itemDB isnt up anymore.
Anyway, the passkey/server settings is stored in !set is not used in the original version.

There are about 60bots connected to my itemDB, so its working..
Could you follow the instructions i sent you again and tell in this topic what errors you got?
Title: Re: New Central itemDB (!item[s|reg])
Post by: viggen on November 06, 2009, 11:07:47 pm
Works now!  Thanks!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on November 13, 2009, 09:54:23 am
I send mp to getrix i waiting for have acces to your db^^
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on November 13, 2009, 12:15:50 pm
Great job this module is perfect thx a lot for your work
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 17, 2009, 08:27:41 am
Quote
2009-11-17: Problem with host. Fix is underway.

Im aware of the problem with service. Have some problem with the host that i cant solve remotly. Waiting for tech onsite to get this solved. ETA: ASAP today i hope.

NOTE: Please do not PM me problems related to this module. Keep it to this topic. It may be others having same problem or that can help you. Dont have time to reply alot of pms :P
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on November 17, 2009, 12:13:36 pm
Im assuming this is what the tech is coming out to sort out

Warning: socket_connect(): unable to connect

whenver someone in guild links an item or does item / items
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 17, 2009, 05:25:23 pm
Yes, this has todo with the host is down.
Havent been able to get intouch with the Tech yet :/

Switched to backup host, refresh your DNS cashe or just wait for it to happen....
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on November 19, 2009, 12:01:49 pm
Hi i discover a bug when i want to register a new item in french with !itemreg if in the name of item i have : é, è, à, â, ô... i have this message : There is no item reference in your item registration.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 19, 2009, 05:15:37 pm
Ye, missing the expression for French, Spanish, Russian and Polish.
Would be good if someone could give me complete list of low/upercase for this language special chars.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on November 19, 2009, 06:35:40 pm
Ok i'll send you a pm with spécial french chars
Title: Re: New Central itemDB (!item[s|reg])
Post by: xlDanek on November 19, 2009, 10:48:09 pm
I didn't check it if there is a problem, but in Germany we have also some special chars -> german "Umlaute":

Code: [Select]
lowcase: ä, ö, ü, ß
uppercase: Ä, Ö, Ü

The last one of the lowcase chars ("ß") has no uppercase. Actually, it isn't even a german "Umlaut" :D But a german special char.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on November 19, 2009, 11:54:01 pm
Code: [Select]
$itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[(.*)\]<\/font><\/a>)';

not very vell but it works^^
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 20, 2009, 12:16:05 am
Code: [Select]
$itemPattern = '...

That will fix the multilanguage support it seems.
Only problem is that it allows every character in the item name. When thinking about it, it shouldnt be the biggest problem because i can easily ban users and bots from submitting if they start to abuse with submitting false items.

Change line 49 in Core/aoc/Items.php to:
Code: [Select]
DONT USE
The current line looks like:
Code: [Select]
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zäöüßA-ZÄÖÜ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';
Not been able to verify its working on the bot, so want release file before morning.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on November 20, 2009, 01:50:08 pm
I make some test with your change and it's ok, work with french items.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 21, 2009, 04:46:41 pm
Please do not use that line anymore.

Test this for french:
Code: [Select]
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zA-ZàâçèéêîôùûÄÆÇÊÌÍÎÏÒÓÔÕÖØÙÚÛÜÝáãäåæçëìíïñòóôõöøùúûüýÿ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';
Use this for russian:
Code: [Select]
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\pL_\'&\s\-]*)\]<\/font><\/a>)';
Use this for german:
Code: [Select]
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zäöüßA-ZÄÖÜ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';
Else it will parse two items linked after each other as one item with the (.*)...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Iheaca on November 23, 2009, 03:27:35 pm
I have a bot running on Stygia, could start using it as a sniffer eventually. What would be needed ?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on November 29, 2009, 11:42:07 am
Is it actually possible to get multiple item links with one !item <id> request by sending mutiple ids?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 29, 2009, 04:43:04 pm
No, there is anyway a limit off chars being posted to chat channels.
It is possible to make a function, but i dont see to much need
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on November 29, 2009, 05:10:20 pm
I think that would be a pretty usefull feature for culture sets...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 29, 2009, 05:55:31 pm
Think it will be better to have it as a seperate command then.
Have been thinking off more functions towards the itemDB, but the spare time latly have been minimal. And im lvling a [email protected] atm, so i actuall play abit on the freetime now :P

But will have this in mind when i feel to code again.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Poonjab on November 30, 2009, 08:20:57 pm
One of my guildies recently got the recipe for Ironswill and linked the potion in guild chat but I noticed it's still not in the item DB.  The recipe shows up, but the potion itself does not show up when doing an item search for ironswill.

Is the DB still picking up new items?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 30, 2009, 10:19:47 pm
Thanks for reporting. For some reason, world first Ironswill was tagged as German.
Gonna look into why this could happen..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on December 01, 2009, 12:36:16 pm
are your "News/Info" outdated or does my bot not sniff correctly?
i use them on asgard (german) and items in guildchat (i think in global too) are visible in your http://aoc-itemdb.sjef.biz/gfx/stats.php
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 01, 2009, 01:15:13 pm
If you are running my module without own modifications, it does not sniff anything other then Guildchat and tell (!itemreg).
If you have modified it to listen to global chat, please let me know and i will give you credit. But its not recomended to run the guildbot sniffing stuff from Global..

Quote
2009-12-01: Following servers have guildbots running against this DB: Aquilonia, Aries, Asgard, Cimmeria, Crom, Fury, Gwahlur, Hyrkania, Ishtar, Mitra, Scarlet Citadel, Set, Two Eagles, Tyranny, Wiccana
Title: Re: New Central itemDB (!item[s|reg])
Post by: Poonjab on December 01, 2009, 11:16:33 pm
If you are running my module without own modifications, it does not sniff anything other then Guildchat and tell (!itemreg).
If you have modified it to listen to global chat, please let me know and i will give you credit. But its not recomended to run the guildbot sniffing stuff from Global..

Quote
2009-12-01: Following servers have guildbots running against this DB: Aquilonia, Aries, Asgard, Cimmeria, Crom, Fury, Gwahlur, Hyrkania, Ishtar, Mitra, Scarlet Citadel, Set, Two Eagles, Tyranny, Wiccana

No, not sniffing global, but also didn't use the !itemreg command.  I do know it was linked in guild chat, and I was under the impression that new items linked in guild chat would automatically get registered in the item DB.  Maybe I was wrong on that.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 02, 2009, 12:42:06 pm
it will grab from guildchat by default. Itemreg is a direct way of checking if it works. It will give you feedback nomather what your item settings are set to. Check the settings with !set items
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 11, 2009, 07:14:38 pm
I need some beta testers for DE, RU, FR, ES search support.

Anyone interested?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on December 11, 2009, 10:00:42 pm
i can test for german items
Title: Re: New Central itemDB (!item[s|reg])
Post by: Taker on December 11, 2009, 10:35:32 pm
Very nice! Thank you for access we love it!
Title: Re: New Central itemDB (!item[s|reg])
Post by: swp760 on December 12, 2009, 08:00:25 pm
Still having trouble with this module "Roll/Flip"

Does not seem output correctly on the Target line.

::: Roll verification: 1 :::
Roller: Darkmistriss
Time: 191 seconds ago
Target: '<a style='text-decoration:none" href='itemref://180450/180450/60/301a384f:d84d7441:9d0ed1ec:c0609be7/301a384f:d84d7441:9d0ed1ec:c0609be7'>[Daggamalt]'
-----------------
Range: 1 - 100
Result: 93
-----------------

The rest of the modules we are using seem work fine.
Anyone able to direct me to a fix for this.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Drizzurdeen on December 13, 2009, 04:15:58 pm
how long does it take time to see a just registert item ??

Prob: i register a german item but after registering in the db i couln't find it about !items xxx
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 13, 2009, 06:49:14 pm
You are not able to search German items on the current version...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on December 15, 2009, 12:50:08 am
I can do some betatesting for the german version too.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Taker on December 15, 2009, 11:16:49 am
Is there a way to see what mob dropped what item?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 15, 2009, 01:58:45 pm
Check aoc.YG.com, and if you are lucky someone posted a comment about where item drop.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on December 15, 2009, 06:19:20 pm
Hi, if u want beta tester for french server i'm ready
Title: Re: New Central itemDB (!item[s|reg])
Post by: bl81 on December 17, 2009, 03:31:47 am
I'm guessing this is on my end as no one else has had the problem, but do you know anything about this error:

"The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for."

Thanks
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 17, 2009, 07:08:47 am
Could you give som screenshot? I cant imagen where this error come from and how you get it screened...
Title: Re: New Central itemDB (!item[s|reg])
Post by: bl81 on December 17, 2009, 04:40:09 pm
Could you give som screenshot? I cant imagen where this error come from and how you get it screened...

That is what is returned to me from my bot when I try and search for an item using !item ItemName

I will provided a screenshot when I return home.

Thanks
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 17, 2009, 05:41:38 pm
It is not a error message i have put in the module. So it must be a new error message Funcom have added. But im not sure before i can see a image on how this shows up for you..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 17, 2009, 07:34:34 pm
What client are you using, EU/FR/ES/DE/PL/RU?
And you are using the v4 and not beta v5 itemDB?

I do not have any error messages in the backend telling you this info ... So its abit wierd..
Title: Re: New Central itemDB (!item[s|reg])
Post by: bl81 on December 17, 2009, 09:43:08 pm
I'm guessing this is on my end as no one else has had the problem, but do you know anything about this error:

"The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for."

Thanks

Wow, I feel dumb. I reset the Server  address. It appears I was missing the / on the end. Anyhow, solved the issue. Thanks.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 05, 2010, 08:09:46 pm
Could i get some feedback on the owners running non-english beta version of !items ?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on January 07, 2010, 12:01:15 am
the german version works fine, itemsearching works and adding new items works too
Title: Re: New Central itemDB (!item[s|reg])
Post by: Drizzurdeen on January 07, 2010, 04:20:49 pm
would have the german one ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Lucalus on January 08, 2010, 05:21:19 pm
Hi,

v5 Database in german works fine, but i get an error in log:
(http://lucalus.lu.funpic.de/error.jpg)

Is there a solution for my Problem?

Regards

Title: Re: New Central itemDB (!item[s|reg])
Post by: Baldrick on January 09, 2010, 11:14:43 am
If I'm not mistaken, this is just a PHP warning that can safely be ignored.
You can turn off deprecation warnings in your PHP configuration so you don't get spammed with those. It does not affect the functionality of this script.


Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on January 09, 2010, 10:09:12 pm
Hi community,

when I'm using the command !items 3841964 I'll get the following error message in my bot console and now item will be shown in guild chat:

Code: [Select]
Warning: socket_connect(): unable to connect [0]: Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht ordnungsgemäß reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat.
Do I have to change the item server (var $server = 'http://aocdb.lunevo.net/';) in the Items.php file? Seems that the server if offline or somethin else?

Plase help! Thanx

Dill
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 09, 2010, 11:33:07 pm
Read whats on the first post in this topic.
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on January 10, 2010, 06:20:44 am
the 5 bots im running are
Global Sniffer on Tyranny(US), Wiccana(US), Set(US), Cimmeria(US)
Guild Sniffer on Gwahlur(US)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 10, 2010, 12:08:38 pm
Quote
2010-01-10: Guilbots also on: Ironspine, Stygia
Title: Re: New Central itemDB (!item[s|reg])
Post by: Gauche on January 10, 2010, 07:37:11 pm
Hi, no problem on ishtar, !item work fine ^^
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on January 11, 2010, 01:38:25 pm
The german version works for me fine too, havent discovered any problems yet.
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on January 14, 2010, 02:34:43 am
with US Server mergers coming up I should have all servers covered with bots :D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on January 17, 2010, 02:46:24 pm
Alright, the global item sniffer in Hyrkania should be up and running now. [edit] Ohh, and Blackscar is joining us shortly together with Zingara, so they don't need one anymore [/edit]
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 23, 2010, 10:16:32 pm
Do i have any russian users of this bot active on this forum?

Im in progress of fetching enough russian item names to test it with search...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Drizzurdeen on January 23, 2010, 11:38:14 pm
i could make a bot running on the russian server is this would help
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 23, 2010, 11:48:27 pm
Need someone to test "!items russianitem" to check if it works to search russian words
Title: Re: New Central itemDB (!item[s|reg])
Post by: Hikuro on February 07, 2010, 01:51:15 pm
I got error message after new patch.


"Error in query to databaze"

Does anyone know what to do pls ??

Thank you  for reply
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on February 07, 2010, 02:19:14 pm
This is when using "item(s|reg)?

There shouldnt be any problem on the central server side...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on February 07, 2010, 02:53:45 pm
This is when using "item(s|reg)?

There shouldnt be any problem on the central server side...

Hmm, possibly he has overwritten the new item db changes with the standard files? I think it's needed to update the item DB changes after installing the new 0.6.7 update :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on February 08, 2010, 12:18:21 pm
Is there a way to search the DB for german Items?

Code: [Select]
!items Brustpanzer der heldenhaften Seele
Cheers, Dill
Title: Re: New Central itemDB (!item[s|reg])
Post by: snyder on February 08, 2010, 02:52:19 pm
not working, message is same as for hikuro and i have getrix file instad of default one
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on February 08, 2010, 03:04:43 pm
@ Dillinger
Thats actually the only possibility:

I need some beta testers for DE, RU, FR, ES search support.

Anyone interested?

Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on February 08, 2010, 03:28:22 pm
Jo, I got it with v5.0 (Beta)!

Thanx mate!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on February 15, 2010, 02:22:16 pm
Server that need GlobalItemSniffer sponsors:
EU: Fury, Blackscar, Skullcrusher, Hyrkania, Skullcrusher
Let me know if you want me to host a bot for Fury.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on February 15, 2010, 08:49:10 pm
have been traveling the last days. Im back home this night and will reply passkey requests within 18hrs
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on February 16, 2010, 05:08:38 am
Getrix, Unfortunatly I will only be keeping up the guild bot on wiccana.
Wicbot, setbot, tyrbot and cimbot have been retired.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on February 16, 2010, 11:39:03 pm
Ok global bot on fury is up and running now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: yokozuna on March 02, 2010, 02:43:21 am
I'm entering a very noob question...

I've followed Getrix guidelines after asking passkey for itemdb.

But i can't use the command !settings for anything? Why is that?

Thanks in advance!

Edit: Issue solved! I wasn't logged as the owner of bot! Thx!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on March 02, 2010, 09:29:43 pm
By default you must log in as OWNER to modify the settings for any module.

Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on March 09, 2010, 09:13:48 am
I'm getting a lot of "No items" being returned for item codes that were working fine last week...anyone else seeing that?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2010, 01:11:01 pm
Whenever you get this problem, could you make a note on what search string you use?
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on March 09, 2010, 05:30:57 pm
Will do - I do know that 2 items that keep getting this atm are the T1 and T2 ToS shields...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on March 09, 2010, 05:59:25 pm
Mimir [TELL]    [INC]   Yite: !items storm harbor
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=storm+harbor&botname=Mimir&pre=%21&checksum=xxxxxxxxxxxxxxxxxxxx
Mimir [TELL]    [OUT]   -> Yite: Didnt find anything
Mimir [TELL]    [INC]   Yite: !items shedu
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=shedu&botname=Mimir&pre=%21&checksum=xxxxxxxxxxxxxxxxxxxx
Mimir [TELL]    [OUT]   -> Yite: Didnt find anything
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2010, 10:16:50 pm
Found the problem, it was a old mass add of items from a bot that have been tagget as non-english.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on March 19, 2010, 12:24:35 pm
Another not found: Sepulcher's Ward (T1 ranger shield)

Mimir [GROUP]   [MSG]   [Niflheim] Ankt: <a style="text-decoration:none" href="itemref://3772163/3772163/80/7c188a53:6bcbba1c:5aa7b7cf:70ebe609/7c188a53:6bcbba1c:5aa7b7cf:70ebe609">[Sepulcher's Ward][/link]
Mimir [GROUP]   [MSG]   [Niflheim] Belu: !items Sepulcher's Ward
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=Sepulcher%27s+Ward&botname=Mimir&pre=%21&checksum=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Mimir [GROUP]   [MSG]   [Niflheim] Mimir: Didnt find anything
Mimir [GROUP]   [MSG]   [Niflheim] Belu: !items Sepulcher
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=Sepulcher&botname=Mimir&pre=%21&checksum=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Mimir [GROUP]   [MSG]   [Niflheim] Mimir: [link]Search result for: 'Sepulcher'[/link]

Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on April 01, 2010, 08:46:16 pm
Mimir [GROUP]   [MSG]   [Niflheim] Siniay: <a style="text-decoration:none" href="itemref://3800385/3800385/80/31171bc4:b774b74c:33e78633:1dfeedba/31171bc4:b774b74c:33e78633:1dfeedba">[Skyshear Tasset][/link]
Mimir [GROUP]   [MSG]   [Niflheim] Belu: !items skyshear
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=skyshear&botname=Mimir&pre=%21&checksum=xxxxxxxxxx
Mimir [GROUP]   [MSG]   [Niflheim] Mimir: [link]Search result for: 'skyshear'[/link]
Mimir [GROUP]   [MSG]   [Niflheim] Belu: !items skyshear tasset
Mimir [Items]   [URL]   http://aoc-itemdb.sjef.biz/v4/botsearch.php?search=skyshear+tasset&botname=Mimir&pre=%21&checksum=xxxxxxxxxx
Mimir [GROUP]   [MSG]   [Niflheim] Mimir: Didnt find anything

Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 07, 2010, 12:18:46 pm
Both was tagged with wrong language.
Thanks for report.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on April 07, 2010, 06:38:30 pm
Occasionaly I also get a foreign language item back in a list, do you wish to be notified of those as well?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 07, 2010, 06:48:52 pm
Yeah sure.
When i get time i will finish some new backend stuff that would prevent this abit better in the long run.
Title: Re: New Central itemDB (!item[s|reg])
Post by: alekseyvip on April 13, 2010, 04:05:03 pm
(http://aoc-itemdb.sjef.biz/gfx/stats.php)

Announce:
Noer announced that he would have taken down his DB as he isnt playing the game anymore (Hasnt for long time..)
I still havent decide to open up my itemDB to everyone without require ppl to ask me to get a passkey.
I may when i got time to recode some of the backend open for search/add item without passkey, but still require passkey for new functions i have planned ;)

If you wanna have access to the New Central 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 New Central itemDB. (PS: If you dont give the Botname and Dimension info, i will not reply you)

Globalchat item sniffers on following servers:
Fury(EU), Crom(EU), Aquilonia(EU), Gwahlur(US), Tyranny(US), Wiccane(US), Set(US) and Mitra(DE).

Server that need GlobalItemSniffer sponsors:
EU: Fury, Blackscar, Skullcrusher, Hyrkania, Skullcrusher
DE: Aries, Asgard
FR: Isthar, Ferox, Stygia
ES: Zingara, Indomitus
PL and RU is abit hard because of the special chars..

-Getrix, Fury

News/Info:
2010-01-10: Guilbots also on: Ironspine, Stygia
2009-12-01: Following servers have guildbots running against this DB: Aquilonia, Aries, Asgard, Cimmeria, Crom, Fury, Gwahlur, Hyrkania, Ishtar, Mitra, Scarlet Citadel, Set, Two Eagles, Tyranny, Wiccana
2009-11-17: Problem with host. Fix is underway.
2009-10-30: Thanks to "Yite" globalchat item sniffer is up on "Aquilonia"
2009-10-28: Noer have cut the cables on old official itemDB. As there isnt any other itemDB out there, this will probly change to official..
2009-10-08: Again sorry for problem with itemDB today. Moved to a new server. Hopefull for last time as its my new epic dedicated server :P
2009-10-03: Sorry for "downtime" today. The vhost on server was removed by mistake. Back now.
2009-09-28: Thanks to "Luclia" globalchat item sniffers are up on german server Mitra!
2009-09-28: Thanks to "keirou" globalchat item sniffers are up on Tyranny, Set, Wiccane and Cimmeria!
2009-09-24: Set guild (USA) and another Mitra guild (DE) is reporting to itemDB
2009-09-23: Mitra guild (DE) is reporting to itemDB
2009-09-22: ItemDB was moved to better host. Flush your DNS or wait if you get messages about it.

Quote from: Post background
I have for the last 6months sniffed item info from Fury and Crom (Global).
Today the alternative itemDB contains 17008 items that are reported to it by 14 guildbots (Crom,Fury,Gwahlur,Tyranny,Set,Mitra) and the two Global sniffers on Fury and Crom.

From what i can tell, it works like it supposed to do. New item gets added, and the DB is searchable.

This DB was not made to compete with Noer's official BeBot itemDB. But as he or nobody else in BeBot Dev is playing AoC and seems to not have the biggest interest for AoC i made the alternative itemDB.

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.
hi.you can send me this itemDB.thx for you
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on April 13, 2010, 04:11:27 pm

If you wanna have access to the New Central 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 New Central itemDB. (PS: If you dont give the Botname and Dimension info, i will not reply you)

 :-\

ps That's Getrix you need to PM not me :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 13, 2010, 04:53:18 pm
And i do not care to reply if you dont care to read the first post with info :P
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on April 20, 2010, 12:43:28 am
The 'Amulet of Good Fortune' is not listed:

[TELL]   [INC]   Kyr: !item 4048092
[TELL]   [OUT]   -> Kyr: No items
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 20, 2010, 06:58:15 am
Tagget as ES :/ Fixed
Title: Re: New Central itemDB (!item[s|reg])
Post by: Glaiver on April 28, 2010, 07:19:47 pm
wtf

[10:52] [Guild] [Glaiver]: !items invincible
[10:52] [Guild] [Exxobot]: A socket operation was attempted to an unreachable network.

I can confirm it was working after 1.06
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 29, 2010, 07:57:25 am
I dont think this has anything todo with itemDB.
Could you please check if your settings is correct or if your DNS is having problem looking up aoc-itemdb.sjef.biz?
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on May 04, 2010, 11:45:26 am
Another item not being found although it's being reported as already in the database is Diabolical Opus...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 04, 2010, 01:49:38 pm
Fixed, thanks
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 06, 2010, 07:06:51 am
Looks like host is having problem.
Will get back with more info and probly up anytime.

EDIT: Problem with routers in datacenter. Problem should be fixed asap by tech's onsite.
EDIT2: Shoul be up again
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on May 07, 2010, 01:01:36 am
These 3 are from the [Armorsmith: Signets of the Glorious City ] recipe:

Energetic Band
To [Bot]: !item 4048073
[Bot]: No items

Dreamer's Keepsake
To [Bot]: !item 4048084
[Bot]: No items

Ring of Protection
To [Bot]: !item 4048091
[Bot]: No items


Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on May 07, 2010, 11:01:35 am
I have been running a global sniffer for some time now, but with the upcoming new expansion, i would really need that character slot free for a new character.

Of coarse my guild bot (Powbot) will keep adding items to the database whenever it finds them. We will never stop using the DB :)..

Still a great module and database, hope you find a new global sniffer soon enough for Hyrkania. Globby will stop existing in a few days.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Jippo on May 09, 2010, 11:16:12 pm
Actually i cant find the Oiled Gastraphetes with the german Version  ( Geölte Gastraphetes )

Log:
Stadtbot [TELL] [INC]   Jippo: !items Gastra
Stadtbot [Items]        [URL]   http://aoc-itemdb.sjef.biz/bot/v5/botsearch.php?
search=Gastra&botname=Stadtbot&pre=%21&lang=de&checksum=ed7ce033d4ce6089b2529a5812e7fe2a

I also got the problem, that i cant register that item?

Log:
Stadtbot [TELL] [INC]   Jippo: !itemreg <a style="text-decoration:none" href="it
emref://3857918/3857918/68/e39e1b7d:506e56f1:33040aae:861a5fba e39e1b7d:506e56f1
:33040aae:861a5fba">[Ge÷lte Gastraphetes][/link]
Stadtbot [TELL] [OUT]   -> Jippo: There is no item reference in your item registration.

Is it because of the "ö" ?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 10, 2010, 08:43:40 am
Your "ö" for some reason ends up in "÷"
I checked the db and can find items with "ö" so there should be working.
Maybe its something with your OS install. Or even php version that do not support german special char?

Items reported by 'Kyr' should be fixed.
Title: Re: New Central itemDB (!item[s|reg])
Post by: GBH on May 14, 2010, 02:41:49 pm
Since the update I'm getting the following when anyone checks for items

[Xxxxxxx] Xxxxxxx: !items heroic soul
[Xxxxxxx] Xxxxxxx: Error in query to database

Everything seems to be the same it's just happened since the update to Rise of the Godslayer. Any ideas?

G
Title: Re: New Central itemDB (!item[s|reg])
Post by: Hughie on May 23, 2010, 07:43:24 pm
I guess i am using quite an old version now... Is there any way to tell if i got the current version and where to download the newest version of these files?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 23, 2010, 11:42:29 pm
There is non official supported itemDB for AoC.
The ones in the package is no longer up and probly should have been removed from the setup.

This is a Alternative Unofficial Central itemDB, so you need to make sure you have the correct files..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Runemy on May 24, 2010, 02:28:40 pm
Let me know if you need a sniffer on Aquilonia
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on May 24, 2010, 02:44:19 pm
Globalchat item sniffers on following servers:
Fury(EU), Crom(EU), Aquilonia(EU), Gwahlur(US), Tyranny(US), Wiccane(US), Set(US) and Mitra(DE).

Server that need GlobalItemSniffer sponsors:
EU: Fury, Crom, Aquilonia, Hyrkania
DE: Mitra, Asgard
FR: Isthar, Stygia
PL and RU is abit hard because of the special chars..

-Getrix, Fury

I'm still running bots on Fury and Aquilonia so Fury can be crossed off the "Server that need GlobalItemSniffer sponsors" list.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 24, 2010, 07:00:57 pm
Thanks Yite, crossed out.

I have lost track on what servers are having active sniffers. Will look into it when i have chance.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Hughie on May 25, 2010, 05:02:40 pm
This is a Alternative Unofficial Central itemDB, so you need to make sure you have the correct files..

Just trying to do that  ;)

I have your files from 29.09.2010, v4 if i am not mistaken, last changeline in the "core" file is from 2009-07-03. As the downloadlink from your PM is not working anymore i assume there are newer versions of these files... but i saw nothing in this thread. So my question is: how do i get the new version and how do i know when there are new versions.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 25, 2010, 05:11:27 pm
Thats a working version. But make sure you have both core and module files.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tomate on May 25, 2010, 08:40:50 pm
I could run one on Asgard. Drop me a PM if needed  :D
Title: Re: New Central itemDB (!item[s|reg])
Post by: GBH on May 27, 2010, 12:59:37 pm
Since the update I'm getting the following when anyone checks for items

[Xxxxxxx] Xxxxxxx: !items heroic soul
[Xxxxxxx] Xxxxxxx: Error in query to database

Everything seems to be the same it's just happened since the update to Rise of the Godslayer. Any ideas?

G

My Itemdb query is still giving the exact same message. Is no one else having this problem or can at least give me a hint as to why this might have suddenly stopped working? I'm pretty self sufficient with the bot code but delving into these things is usually a royal PITA so I was hoping for a hint before I did.

G
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on May 27, 2010, 03:26:44 pm
Now you're saying this happened since the update to ROTGS, now when you updated your bot files did you just replace the AOChat or did you unpack the entiner 0.6.8 release in there?

If the latter then you'd have to revisit the PM from Getrix with instructions on file replacements as the alternative item db has custom versions of the Items.php files:
<Botfolder>/core/aoc/Items.php
<Botfolder>/modules/aoc/Items.php
Title: Re: New Central itemDB (!item[s|reg])
Post by: GBH on May 28, 2010, 11:25:22 am
Now you're saying this happened since the update to ROTGS, now when you updated your bot files did you just replace the AOChat or did you unpack the entiner 0.6.8 release in there?

If the latter then you'd have to revisit the PM from Getrix with instructions on file replacements as the alternative item db has custom versions of the Items.php files:
<Botfolder>/core/aoc/Items.php
<Botfolder>/modules/aoc/Items.php

I feel like such a noob now. Thanks very much. Thats what happens when you assume a major change like this has been incorporated into the main tree by now :/

Interestingly, is there any reason why when I do "!items heroic" it doesn't show either the legs (Tasset), head (Helm) or the hands (Gauntlets) of the guardian T2 set? I'm positive it used to. If I do itemreg it tells me it's already been discovered yet doesn't show up in a search.

Cheers again

G

G

Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on May 28, 2010, 12:05:34 pm
Interestingly, is there any reason why when I do "!items heroic" it doesn't show either the legs (Tasset), head (Helm) or the hands (Gauntlets) of the guardian T2 set? I'm positive it used to. If I do itemreg it tells me it's already been discovered yet doesn't show up in a search.
Most of the times this happens when it's flagged as a different language, if you can post the output of the item links Getrix normally fixes it.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 28, 2010, 01:02:08 pm
Fixed language problem with the three heroic items.
Im waiting for YG to do another item rip and then i will run some sync on the database again to make sure items are correctly flagged.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 28, 2010, 01:36:40 pm
There is 150+ bots running the file without problem.
Try to copy the content of file again, because the problem must be on your side.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Deraltemeister on May 30, 2010, 01:00:21 pm
Hi! I cant' use settings for the two new Items.php.
I copied the right *.phps to the right folders and renamed them to "Items.php". The bot was restarted, too.
!settings was used by owner of the bot.
Today i changed "Botname" at the "bot.conf" to "botname" (letters lower case), restarted but also without effect. Anybody got an idea what's going wrong?

----------
[18:41] /tell botname !settings Items Server http://aoc-itemdb.sjef.biz/
[18:41] [botname]: Setting Server for module Items does not exist.

[18:44] /tell botname !settings Items Passkey XXXXXX
[18:44] [botname]: Setting Passkey for module Items does not exist.

[18:45] /tell botname !settings Items Language DE
[18:45] [botname]: Setting Language for module Items does not exist.

[18:45] /tell botname !help Items
[18:45] [botname]: Items does not exist or you do not have access to it.

[18:46] /tell botname !Items
[18:46] [botname]: /tell botname !help
----------

Regards
Deraltemeister
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on May 30, 2010, 05:37:22 pm
Make sure the character you use realy are Owner.
And also make sure you did copy the two files correctly.

The probly you are having is mostlikely due to one of the checkpoints over. The files works without problem for the others, so it must be something on your end.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Deraltemeister on May 30, 2010, 09:07:49 pm
Lazy "Deraltemeister" coded the links to the 2 Items.phps into html and right cklicked and saved them...  :o Did it now with copy and paste... Be ashamed of myself.  :-[

Works great now! Thx!  ;D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Shendar on June 12, 2010, 04:48:27 pm
I'd like to use new DB scripts. Sent forum PM with bot and server name a week ago - no reply so far. PM script timed out so I don't know if it was sent or not. Please let me know if I need to resend bot info.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on June 12, 2010, 06:08:41 pm
Resend please. I have been sending to everyone in my inbox. So if you havent recieved mostlikly lost in space
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on June 13, 2010, 03:01:05 pm
Seems i am getting constant errors trying to connect to database.

Went through my PM's and went to redownload the files, but they arent loading either :(

has the host gone down?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on June 13, 2010, 03:41:17 pm
the file and db is on different sites. Only sharing same domain. Check if you can get sjef.biz out your dns. Had some problem with .biz domains couple days ago also.
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on June 13, 2010, 03:43:22 pm
strange... cannot access the following sites

http://aoc-itemdb.sjef.biz/
http://www.conanstats.com/
http://www.conanchat.com/

dunno whats wrong :S
Title: Re: New Central itemDB (!item[s|reg])
Post by: Ylfang on June 14, 2010, 10:15:23 pm
thx :) works like a charm
Title: Re: New Central itemDB (!item[s|reg])
Post by: Primal on June 27, 2010, 06:23:28 pm
Thanks, work like a dream!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on July 20, 2010, 05:59:32 pm
[16:54] To [Mimir]: !items sunsteel
[16:54] [Mimir]:



Not Found
The requested URL /v4/botsearch.php was not found on this server.

Apache/2.2.8 (Ubuntu) Server at aoc-itemdb.sjef.biz Port 80


Title: Re: New Central itemDB (!item[s|reg])
Post by: Justine on July 20, 2010, 06:23:49 pm
[16:54] To [Mimir]: !items sunsteel
[16:54] [Mimir]:



Not Found
The requested URL /v4/botsearch.php was not found on this server.

Apache/2.2.8 (Ubuntu) Server at aoc-itemdb.sjef.biz Port 80





Same Error for us as well.  It was working fine about 5 days ago or so? I went out of town and I know I had used it before then.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on July 20, 2010, 08:40:30 pm
Up again now. Thx for report
Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on July 30, 2010, 11:35:18 am
Who can generate me a ID for my Guild on EU server Mitra? At this time, I can't get in touch with Getrix, maybe he's on holiday? ^^

Thanx for your quick reply!

dill
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on July 30, 2010, 11:56:30 am
Getrix is the only person able to do this.
Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on July 31, 2010, 11:12:36 am
*grmbl* thanx Yite
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 03, 2010, 07:26:27 pm
just wanted to tell im on holiday, back next week.
Only open wlan at street with phone this week:p
Title: Re: New Central itemDB (!item[s|reg])
Post by: Drizzurdeen on August 04, 2010, 12:32:18 am
Quote
Only open wlan at street with phone this week:p

this must be enough ;) ...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 05, 2010, 05:39:10 pm
no, its only a simpel android phone so can't do much more then browse singel pages :/
Please stop spam me request for access. I will reply in start of next week. Spamming will just give me more work and i even want reply you..
Title: Re: New Central itemDB (!item[s|reg])
Post by: dillinger on August 08, 2010, 12:33:29 pm
Roger that, thanx 4 your info Getrix! Enjoy your holidays.

Dill
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 08, 2010, 09:52:33 pm
There im back from +30*c and sunny days with upto 50*c =)

I have added and replied all request.
If you didnt get any resend request as it was abit messy in my inbox now.

Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 11, 2010, 11:03:22 pm
Serverpark where the central database is having maintance, so there will be some downtime.
Not sure how long it will take before it is back stable but shouldnt be to many hours.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Ricky1252 on August 14, 2010, 07:44:44 pm
followed all instructions and for some reason getting this message when trying to see an item....   "sorry <name>, you dont have access to this service."
i checked the key several times it is the same so im not sure whats wrong xD
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 16, 2010, 10:13:24 pm
Please provide OS and bit (32/64bit) where your bot is running
Title: Re: New Central itemDB (!item[s|reg])
Post by: Ricky1252 on August 17, 2010, 02:33:02 am
Windows 7 64 bit
Title: Re: New Central itemDB (!item[s|reg])
Post by: SalmonSeller on August 21, 2010, 02:58:02 am
As regards the two files copied over does it matter that they end in the extension *.phps - all the other just end in *.php

I have put the relevant files where they were supposed to go, but all I get back when using the !items XXXX is to check the !help menu. I copy them over, restart the bot, put in the domain name, passkey and set english as the language - !item, !items, etc seems to do nothing, just to check the !help menu.

Any ideas?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 21, 2010, 12:07:21 pm
Copy paste the content into new file as if you download it may get some extra text that shouldnt be there.
Title: Re: New Central itemDB (!item[s|reg])
Post by: SalmonSeller on August 21, 2010, 02:53:23 pm
All sorted now! Thank you  :D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on August 28, 2010, 06:01:58 am
i dont know if getrix got my mail... but i need you assistance on setting this up so i can use it.   please let me know what i need to do.  ty
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 28, 2010, 03:24:25 pm
Read the start of topic is the minimal requirement of getting it work...
Title: Re: New Central itemDB (!item[s|reg])
Post by: maikee on August 29, 2010, 03:39:55 pm
hi.

i have a problem with the language option
i have registered the passkey and the server adress.

when i register the language DE following message contains: "Setting language for module items does not exist."

how i solve the problem?

Edit: i have exactly copy the 2 php files
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 29, 2010, 03:55:42 pm
Recheck that you have followed the Readme step by step. Im pritty sure you have missed something there.
Title: Re: New Central itemDB (!item[s|reg])
Post by: maikee on August 29, 2010, 04:10:10 pm
i have follow the instructions step by step once again.

i can only register the server url and the passkey.
but i can't register the language
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on September 01, 2010, 09:08:51 am
i read something somewhere that if there are two folders with the same name within a folder (modules) then they may cancel one out or something.

I have done all the steps provided to me but when i go into the game to set the items server or password... any of them i get this message ::: Setting Server for module Items does not exist. :::

when i double checked to see if i had the folders in the right places with the right name and the "_" in front of it... it was all there but there was already a folder titled items.php in both required folders.   could it be that because those are there... they are interrupting the new items folder?  do i just delete them or move them? 
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on September 01, 2010, 02:06:08 pm
Re-read the instructions .. twice :D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on September 01, 2010, 11:23:02 pm
yes ty... i re read them more than twice.  i was sure to follow that "specific" instruction as it seemed to be the most important one.  but if i may.... i am new to this and i have tried to figure out what i am doing wrong on my own (after reading the instructions twice).  I followed the "instructions" to the best of my ability and provided what i thought was the issue.... and what i did.  If i need to list exactly what i did, step by step, to get some assistance... then i will.  please let me know.  otherwise i would appreciate a little help in getting this going please.

again... i have no experience in any of this... this is the biggest thing i have ever had to handle on my own, relating to computers... im a quick learner though.  I can see that this specific topic is obviously not favored... but anyone that can be so kind as to provide me with a little bit more useful information, other than re-reading the instructions, i would greatly appreciate it.

please help a girl out.

ty
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 02, 2010, 07:08:18 am
First of all, there is files and not folders you are dealing with.
Copy the text in the files as Readme says and remember to restart the bot when this is done. Then you should be ready to go.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on September 02, 2010, 09:16:51 am
* Rename the existing files as per the readme
* Download the new files
* copy the new files to the right folder with the right name
* restart the bot
* set the server and passkey

If you have difficulty with any of these steps please let us know which one.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on September 02, 2010, 11:48:52 am
ok.. ill give it a try ty yite and get
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 02, 2010, 11:59:38 am
To add something to step 2 of Yite, downloading files fails because server adds color codes to the .phps files.
Browse to the files linked, copy all text and then past it into files with same file name localy on your computer
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on September 02, 2010, 06:14:15 pm
ok now i understand what to do.  i have to actually go to that link and copy the info.  see im such a noob.  question though... so i just copy all that info and put it in the corresponding folder... do i replace the content already in that folder or add the copied txt at the start or the end of the existing txt?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Tsamoonia on September 02, 2010, 08:10:32 pm
you know.. im sorry.  forget that question... i guess for me it takes re reading 10 times to fully understand.  Yay!  Short Bus!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on September 08, 2010, 11:18:59 pm
Server down?

Bot giving me a: no route to host
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 09, 2010, 07:08:21 am
Not sure if there was any problem yesterday, but atm its working from here.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on September 09, 2010, 08:39:55 am
All fine here again as well, would blame my isp if it wasn't so that my bot is hosted in France and I'm in the UK and couldn't access the bot server from both locations.

Oh well all good now :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Spreadicus on September 18, 2010, 03:54:22 pm
Is the query server down? the last day and a half ive been getting "Error in query to database"

seems to happen sometimes then works again.

Title: Re: New Central itemDB (!item[s|reg])
Post by: Spreadicus on September 22, 2010, 12:59:09 pm
been down now for a few days, any word on the status?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Runemy on September 22, 2010, 03:39:47 pm
Working fine at our end mate, sure you didn't do an upgrade and forgot a little setting somewhere?
Title: Re: New Central itemDB (!item[s|reg])
Post by: muso on September 29, 2010, 02:16:23 pm
To [seregbot]: !item 3841907
[15:07] [Seregbot]: Wrong checksum (Error Code: 502)

i did try this morning and everything worked fine i dont know what happend

 :(  any idea what is this?

Code: [Select]
http://aoc-itemdb.sjef.biz/bot/v5/botsearch.php?single=1&id=3861768&botname=seregbot&lang=EN&checksum=830e9eaa649a2d62ecee68625a62f3c9
Title: Re: New Central itemDB (!item[s|reg])
Post by: muso on September 30, 2010, 02:26:25 pm
still the same error any one can manage this issue?
Title: Re: New Central itemDB (!item[s|reg])
Post by: muso on September 30, 2010, 11:42:38 pm
hahooooooo pls!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 01, 2010, 12:00:42 pm
Make sure you have followed the instructions carefully.
Title: Re: New Central itemDB (!item[s|reg])
Post by: muso on October 01, 2010, 02:52:54 pm
Well when i setuped first time it was work, then cuple hours leater dosnt!
I did again and followed your instr.. but i get same error;
Code: [Select]
seregbot [2010-10-01 13:05:25]  [TELL]  [INC]   Muso: !item 3841911
seregbot [2010-10-01 13:05:25]  [TELL]  [OUT]   -> Muso: Wrong checksum (Error Code: 502)


so what i should check? setup again?
Title: Re: New Central itemDB (!item[s|reg])
Post by: muso on October 02, 2010, 05:30:01 am
ok i found out what is wrong! The seregbot is wrong, the bot name is Seregbot with (S) and the code sending lowercase "s"! I tried and work wit Seregbot!
ty
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 02, 2010, 08:14:30 am
Then you have ninja changed it so it got broke :P
Every small step being made can make fatal outfits..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Bear1968 on October 04, 2010, 09:26:01 pm
Thanks Getrix!
....For adding making a great game just a bit better!
I came here today with a problem so I read all the most recent posts in this thread and was unable to find my answer and then I went back to the PM you sent with my log in info for the DB and realised that the lo gin is stored in db and not Bebot files.
Problem solved.
Just wanted to post and say THANKS!!!!!!
 ;)
Title: Missing items in database?
Post by: Kentarii on October 07, 2010, 11:10:58 am
Hi Getrix,

First let me thank you for running this database. Don't know what I would do without it :)

But I'm curious about something... the database seems to be missing some items even though I'm sure they were in there before.
An example of that is: Tome of the Black Gale (previous id: 3774412)

And there are some other items which are missing in the database:
Archdeacon's Armbands of the Eighteen Pits
Archpriest's Straps of the Nine Springs
Blade's Belt of Charred Earth
Blade's Cord of Waning Dusk
Book: The Direct and the Indirect
Sage's Armbands of the Crumbling Tower
Sage's Belt of the Eldritch
Sage's Belt of the Purple Sun
Scholar's Belt of the Effulgent Blade
Shadow's Straps of the Hidden Palace
Wolf's Armbands of World's Edge
Wolf's Gauntlets of the Grasslands

I have a list of a few more items at home, but do you know if there's anything blocking these items from getting added to the DB?

-K
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 07, 2010, 12:28:19 pm
Hi

There is some small bug in v5 that i have been working on fixing. Just not got the time to complete the changes.
Will try to speed up the changes that are planned for v6 and release that.

Are you sure all the names on the list are existing items? I didnt find most of them on YG or my database...

Tagged wrong, fixed:
Tome of the Black Gale
Sage's Armbands of the Crumbling Tower

Not discovered/linked to a bot sniffer  (Not even YG):
Archdeacon's Armbands of the Eighteen Pits
Archpriest's Straps of the Nine Springs
Blade's Belt of Charred Earth
Blade's Cord of Waning Dusk
Book: The Direct and the Indirect
Sage's Belt of the Eldritch
Sage's Belt of the Purple Sun
Scholar's Belt of the Effulgent Blade
Shadow's Straps of the Hidden Palace
Wolf's Armbands of World's Edge
Wolf's Gauntlets of the Grasslands

Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on October 07, 2010, 11:29:19 pm
Not everything in the above post was in the database before.
Just posted random items which I know haven't found their way to the database for some reason.

Hopefully a sniffer will pick them up soon.
But one more specific case: Gyas's Fetters
I'm pretty sure I've linked that to my guildbot before. Think I deleted it though... think a guildmate has it, I'll get back to you on that.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on October 14, 2010, 02:03:24 am
This is the Ibis Xbow:
[Guild] [guildie]: !items krakensbane
[Guild] [bot]: Error in query to database

~Kyr
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on October 14, 2010, 07:47:38 am
[Guild] [Nick]: !items krakensbane
[Guild] [Bot]: Search result for: 'krakensbane'

It worked for me.
By the message you got there could have been some problem with sql at the time you queried.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Masterdo on October 19, 2010, 08:54:43 am
A guild member has the Sage's Belt of Purple Sun, and linked it many times in guild and global chat, yet it doesn't appear in the searches. We are on Wiccana US. Item number seems to be 4491048.

Even though a bot is sniffing global, is every bot sniffing the guild chat? Or only those that also check global?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on October 19, 2010, 09:55:29 am
Even though a bot is sniffing global, is every bot sniffing the guild chat? Or only those that also check global?
Every guildbot will sniff guildchat and tells.

The most likely reason the item won't get into the db is because it is already there in a different language.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on November 02, 2010, 02:01:36 am
Do you need the whole itemref-link to be able to add items to your database or is it sufficient with the in game item id? I'm not exactly sure how AoC build the itemref hashes, but perhaps you know?

If you want, I can provide you with a list with approx 350 items.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 02, 2010, 07:14:10 am
The hash is for me uknown how to calculate.
Thats why i use guild/global sniffer to get thoes and ppl need to link them.

Tho the list can be usefull to search for wrong tagged items.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on November 02, 2010, 09:34:42 am
You can view the list here: http://pastebin.com/myT81u9V
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 02, 2010, 10:45:30 am
Thanks, following items where found and tag fixed:

Quote
Arm-straps of Dark Malice
Armbands of Celestial Radiance
Bindings of Black Oblivion
Bracers of Black Oblivion
Brigand's Armguards of the Khan
Captain's Chestplate of Dynastic Rule
Hood of Dark Malice
Hood of the Ravenflight
Leggings of Dark Malice
Padsoles of Dark Malice
Pilgrim's Belt of Shimmering Light
Shendoh of Conflagrant Flame
Stalker's Armbands of the Silent Kill
Traumatic Reflection
Tunic of Dark Malice
Venturer's Leggings of Grinning Skulls

Have the changes i wanted todo with database on my plans this week, but still can't promise if i get done.
The changes will hopefully prevent to much wrong tagging
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on November 05, 2010, 12:27:05 am
I think [Vise of the Anointed] 3773832 is mistagged as well.

[Teeth of the Drowned] 3770713 is tagged as Rare instead of Epic.
When clicking on link you get a text saying [Trident of Heroic Soul] which is old name.

[Zukala's Rites] 3773744 is probably mistagged
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 05, 2010, 02:38:16 pm
[Vise of the Anointed] and [Zukala's Rites] was mistagged.

[Trident of Heroic Soul] deleted
[Teeth of the Drowned] fixed Rare->Epic

Thanks for report
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on November 05, 2010, 07:34:57 pm
Thanks mate, can you check up on Cang-Jei's Grin as well?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 06, 2010, 12:12:10 am
Fixed Cang-Jei's Grin
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 09, 2010, 06:26:12 pm
Looks like server host is having some problem atm. Hopefull its getting sorted quick
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 10, 2010, 12:52:34 pm
Still havent got the problem sorted..

There is no need to PM me with problems related to !item(s|reg).
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on November 10, 2010, 12:59:46 pm
As a quick relief to your bot becoming unresponsive after someone does:
* !item
* !items
* links something in guild chat
move (rename) the Items.php in your core/modules/aoc directory to _Items.php and restart your bot.
Yes this will throw an error when someone does any of the above commands but at least it keeps your bot responsive.

(Don't forget to rename it back and restart after the hosting issue is resolved)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 10, 2010, 04:11:50 pm
I changed the DNS of host untill i get intouch with the tech. You will get a "Sorry" page instead of hanging when your DNS is updated right.
If i dont get stuff sorted i will look on the backup and get it running on alternative server.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 11, 2010, 12:17:52 pm
It should be back up again now.
If you still get the "Sorry, problem with itemDB. Will be back ASAP!", flush your DNS on bot host.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on November 11, 2010, 12:28:21 pm
Nice to have it back again  :D
Title: Re: New Central itemDB (!item[s|reg])
Post by: SalmonSeller on November 12, 2010, 07:48:31 am
Is the DB down again? We are still getting the 'Error in Query to Database' message. Any ideas?  ???
Title: Re: New Central itemDB (!item[s|reg])
Post by: Karsta on November 12, 2010, 08:28:35 am
Is the DB down again? We are still getting the 'Error in Query to Database' message. Any ideas?  ???

I get that also.
Dont know how to flush DNS on host if that matters.
Title: Re: New Central itemDB (!item[s|reg])
Post by: SalmonSeller on November 12, 2010, 09:00:52 am
Now getting this message:

Auch, itemDB is down! (Error Code: 501)


Ill' just disable it in the meantime I guess.  ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 12, 2010, 05:10:30 pm
Reported the problem to sponsor again. There is some problem on host machine that they are making stuff go slow.

Auch, itemDB is down! (Error Code: 501) <- This messages shows the webservice is running, so bot should not be having problem with !items other then not getting a correct reply
Title: Re: New Central itemDB (!item[s|reg])
Post by: dragonjr on November 13, 2010, 07:18:39 pm
ok i have had this mod or a awhile and now i go to use !items <name> it comes up with i don't find anything what is cuasing this and how do i fix it ???
thanks
Title: Re: New Central itemDB (!item[s|reg])
Post by: ViperJuice on November 13, 2010, 07:52:30 pm
Same as above poster - getting "didnt find anything" when querying the Items DB now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: dragonjr on November 14, 2010, 01:40:24 am
its working now
Title: Re: New Central itemDB (!item[s|reg])
Post by: Miron on November 15, 2010, 03:09:21 pm
Hey there :) Items command is working fine at my guild's bot except from the times I am trying to search for "Lemurian Firestick". I get the reply "Didn't find anything" but when I try to itemreg it say that other people before me have register this item.

Any ideas?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on November 15, 2010, 03:17:42 pm
Most likely in the db under another name, Getrix can probably locate it but if you want to make it easier copy and paste the relevant link from your bebot log from when you tried the itemreg
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 15, 2010, 06:36:53 pm
Looks like the problem with host has been solved now. Hopefully it will not go down like this again.

Lemurian Firestick - wrong tagged, fixed now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 22, 2010, 08:01:14 pm
As probly most have noticed, its down again. I have been intouch with server tech and they gonna give me a new server. Not sure when im getting this up and are able to get backup from the old one. But hopefully within 24hrs.

EDIT: Should be up running on new server now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Zorrna on November 27, 2010, 07:33:33 pm
we got still Error in query to database
is there something what i must change?

LG

PS please help and sorry for my bad english
Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on November 30, 2010, 01:34:13 pm
Hiya,

One of our bot users has given me a few item id's that should be known but do not give back results:
3750837, 3750879, 3750887, 3749689, 3751300
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on November 30, 2010, 04:39:37 pm
Thanks for reporting, thoes item should now work.
Title: Re: New Central itemDB (!item[s|reg])
Post by: ViperJuice on December 03, 2010, 10:27:17 am
Getrix, check on item 3770716 when you have a chance. Returns: No items
Should be Guardian T3 Polearm Triton's Depths.
Has been missing from the items db for some time now
Title: Re: New Central itemDB (!item[s|reg])
Post by: gpucka on December 10, 2010, 09:24:51 pm
Not sure why, but for the last few days the !items command only returns

Error in query to database

Has something changed? do I need a new access code?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on December 10, 2010, 10:52:35 pm
ItemDB is up and running fine.
If you have problem, check every setting and maybe do the install procedure all over again.
Title: Re: New Central itemDB (!item[s|reg])
Post by: gpucka on December 11, 2010, 12:09:45 am
OK did a re-install of both modules and the settings and it is working again, thx
Title: Re: New Central itemDB (!item[s|reg])
Post by: talrain on January 18, 2011, 07:07:42 pm
I went thru the setup instructions twice and both times im getting this error when looking up items:

To [Bearbot]: !items heroic
[Bearbot]: Sorry, your search didn't give any result.
To [Bearbot]: !items cloud
[Bearbot]: Sorry, your search didn't give any result.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Huesos on January 18, 2011, 07:20:02 pm
I went thru the setup instructions twice and both times im getting this error when looking up items:

To [Bearbot]: !items heroic
[Bearbot]: Sorry, your search didn't give any result.
To [Bearbot]: !items cloud
[Bearbot]: Sorry, your search didn't give any result.

You get your code for your bot from Getrix? and set it up with your bot ? (!settings items) you then give the bot the code. It tells you the command in there, and set up the right addy(url) for the database.
Title: Re: New Central itemDB (!item[s|reg])
Post by: talrain on January 19, 2011, 04:13:12 am
I went thru the setup instructions twice and both times im getting this error when looking up items:

To [Bearbot]: !items heroic
[Bearbot]: Sorry, your search didn't give any result.
To [Bearbot]: !items cloud
[Bearbot]: Sorry, your search didn't give any result.

You get your code for your bot from Getrix? and set it up with your bot ? (!settings items) you then give the bot the code. It tells you the command in there, and set up the right addy(url) for the database.

yes to all those questions.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 19, 2011, 07:02:09 am
Added a debug so "error" message returning should include the search string central gets from you. Could you do another check and see if you get back the same as you input?
Title: Re: New Central itemDB (!item[s|reg])
Post by: talrain on January 19, 2011, 08:51:44 am
Added a debug so "error" message returning should include the search string central gets from you. Could you do another check and see if you get back the same as you input?

just did another check for the same items. same result.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on January 19, 2011, 11:01:27 am
Firewall?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 19, 2011, 06:20:02 pm
Try the following commands and post result here, not only "same result"
!items test
!item 223114
!items swift
!item 3770643
!item 4617973

Also if you get a link when searching, whats the "version" number?

I dont think its any Firewall blocking it, the reply he gets is not writtin in the local file he has, but from central db.
Title: Re: New Central itemDB (!item[s|reg])
Post by: talrain on January 20, 2011, 01:48:22 am
Try the following commands and post result here, not only "same result"
!items test
!item 223114
!items swift
!item 3770643
!item 4617973

Also if you get a link when searching, whats the "version" number?

I dont think its any Firewall blocking it, the reply he gets is not writtin in the local file he has, but from central db.

[Guild] [Talrain]: !items test
[Guild] [Bearbot]: Sorry, your search 'test' didn't give any result.
[Guild] [Talrain]: !item 223114
[Guild] [Bearbot]: [Pink Cookie]
[Guild] [Talrain]: !items swift
[Guild] [Bearbot]: Sorry, your search 'swift' didn't give any result.
[Guild] [Talrain]: !item 3770643
[Guild] [Bearbot]: [Glove of the Swift Talon]
[Guild] [Talrain]: !item 4617973
[Guild] [Bearbot]: [Warlord's Maxim of Chaos]

not seeing any version number.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 20, 2011, 07:02:32 am
I forgot to ask if you have looped the Readme file atleast 3times and followed the step-by-step...
Getting the reply you have doesnt seem logic to me..

Before you go over your files, do this one more try:
!item 223114

If you still get "[Pink Cookie]" make sure your DNS is up2date.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Darkosar on January 20, 2011, 10:57:28 pm
Hello,

is it possible to get access for the itemdb? Send a PM but didnt read your signature. That would be great. Thanks so far

Title: Re: New Central itemDB (!item[s|reg])
Post by: talrain on January 21, 2011, 05:13:37 am
I forgot to ask if you have looped the Readme file atleast 3times and followed the step-by-step...
Getting the reply you have doesnt seem logic to me..

Before you go over your files, do this one more try:
!item 223114

If you still get "[Pink Cookie]" make sure your DNS is up2date.

To [Bearbot]: !item 223114
[Bearbot]: [Hyena Testicles]
Kzinn has logged off.
To [Bearbot]: !items swift
[Bearbot]: Sorry, your search 'swift' didn't give any result.
To [Bearbot]: !item 3770643
[Bearbot]: [Glove of the Swift Talon]


I've followed the readme 4 times now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 21, 2011, 08:56:12 am
Do the step over again, STEP - BY - STEP and take your time on each step to make you do it right.
300 others have made it correct, you did not follow it correctly or maybe too quick and overlooked what you should do.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Mulkiber on January 21, 2011, 04:33:59 pm
Hey Getrix,

Darkosar showed me your Items DB and i love it - perhaps you can send me a Access Key too?

The Botname ist: Rebirthbot
Dimension: Mitra
Guild: -=Rebirth=-

Thanks a lot, great module, nice work.

So far Mulkiber
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on January 21, 2011, 05:25:58 pm
Quote
If you wanna have access to the New Central 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 New Central itemDB. (PS: If you dont give the Botname and Dimension info, i will not reply you)
the me in that quote would be Getrix (not me :) )
Title: Re: New Central itemDB (!item[s|reg])
Post by: Mulkiber on January 21, 2011, 05:57:28 pm
Quote
If you wanna have access to the New Central 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 New Central itemDB. (PS: If you dont give the Botname and Dimension info, i will not reply you)
the me in that quote would be Getrix (not me :) )

Or u read the signature where you can see that he has no time for reply
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on January 21, 2011, 06:54:09 pm
Not for questions no but if you want access to the db pmíng him is the way to go.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Cuval on January 27, 2011, 06:38:38 pm
!item 3748695 gives 'no items' reply, but i do have that item id in our depot. I think this is another broken item :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on January 27, 2011, 10:32:02 pm
Quote
[22:31] [Guild] [xxx]: !item 3748695
[22:31] [Guild] [xxxbot]: [Twilight Padsoles]

English is working...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on January 28, 2011, 12:15:13 pm
For the record I tried this last night (english) and it didn't return anything for me either. Will try again tonight.

Also now that I know the item name I will check !items Twilight Padsoles as well
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on January 28, 2011, 06:17:40 pm
[GROUP] [MSG]   [Niflheim] Yite: !item 3748695
[GROUP] [MSG]   [Niflheim] Mimir: No items
[GROUP] [MSG]   [Niflheim] Yite: !items Twilight Padsoles
[GROUP] [MSG]   [Niflheim] Mimir: [link]Search result for: 'Twilight Padsoles'[/
link]
[GROUP] [MSG]   [Niflheim] Yite: !item 3746057
[GROUP] [MSG]   [Niflheim] Mimir: <a style='text-decoration:none' href='itemref:
//3746057/3746057/41/f08bf971:223c9b5f:45bd7b20:d7e42adb/f08bf971:223c9b5f:45bd7
b20:d7e42adb'>[Twilight Padsoles][/link]
[GROUP] [MSG]   [Niflheim] Yite: !item 223114
[GROUP] [MSG]   [Niflheim] Mimir: <a style='text-decoration:none' href='itemref:
//223114/223114/1/2908bea1:82ca5bcd:3f6bc0a9:2fe0aef2/2908bea1:82ca5bcd:3f6bc0a9
:2fe0aef2'>[Hyena Testicles][/link]
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on February 07, 2011, 09:39:29 pm
Hi Getrix,

Can you please look at the various Jovus necklaces which are quest rewards from Crow's Nest?
I don't think they are showing up in english.
Spirit of Jovus
Fury of Jovus
Lost Soul of Jovus
Steadfastness of Jovus

Same thing with the Jovian capes, only the Heavy Jovian Cape appears in the search, the ones below does not show:
Jovian Battle Cape
Jovian Faith Cape
Jovian Spirit Cape
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on February 07, 2011, 10:13:12 pm
Typo for item: !item 4514779
[Gauntles of Fearless Souls] lvl: 80

Missing in english:
Warlord's Arrows - [Kriegsherren-Pfeile] - 4617974
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on February 09, 2011, 09:02:08 am
Forgot to tell, i fixed this some days ago.
Thanks for headsup!
Title: Heaven's Kal Gum
Post by: Kyr on March 04, 2011, 08:28:07 am
To [bot]: !items Heaven's Kal Gum
[bot]: Didnt find anything

This is a nice blue sin dagger.  Can't seem to find it in the database. 
I had my guildie drop it in guild chat and he didn't get the message that he was first on the server to discover it.

 ;D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 04, 2011, 11:32:51 am
Fixed [Heaven's Kal Gum] "!item 4685622"
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on March 06, 2011, 01:31:46 pm
Thank you Getrix!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kyr on March 08, 2011, 08:58:07 pm
Since the latest patch the links are not working...

Anyone else seeing this problem?

~Kyr
Title: Re: New Central itemDB (!item[s|reg])
Post by: Maxie on March 09, 2011, 10:53:19 am
Yep, all item links broken from bot. They changed the format on it and added some stuff.

Old:
<a style="text-decoration:none" href="itemref://3777378/3777378/80/26169193:d9ee30c4:53fcfaba:143976a2/26169193:d9ee30c4:53fcfaba:143976a2">[Fine Steelsilk Belt][/link]

New:
<a style="text-decoration:none" href="itemref://3777378/3777378/0/80/26169193:d9ee30c4:53fcfaba:143976a2/26169193:d9ee30c4:53fcfaba:143976a2/b290805c:29e627ca:b290805c:29e627ca">[Fine Steelsilk Belt][/link]
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on March 09, 2011, 11:57:43 am
They probably added a new quality level for the new Dreamworld gfx...
Does this mean we have to update all the links in Getrix's ItemDB?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2011, 02:58:26 pm
Just arrived home from 2day job trip, patching my game now so will look into the changes ASAP.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Maxie on March 09, 2011, 03:36:33 pm
It seems to be the same addition on all items. First the 0 as third parameter and then /b290805c:29e627ca:b290805c:29e627ca at the end.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2011, 03:38:51 pm
Yeah, that was what i also found out.
So "items"+"item" should work now, just hardcoded that new numbers into search-function for now.
"itemreg" needs abit more edit and also localy for everyone... Hang on for new file.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2011, 04:09:52 pm
To get register new item work, new version of bebot item files are needed.
Founded here:
http://aoc-itemdb.sjef.biz/code/v5/Core_Items.phps
http://aoc-itemdb.sjef.biz/code/v5/Modules_Items.phps

This was abit quickfix to get it work. New version will arrive later when i get the time to add all the stuff i have in mind..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Yite on March 09, 2011, 05:21:51 pm
Will a change be required for the global sniffers? Feel free to PM when I need to change something. (sniffing aquilonia and fury)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Maxie on March 09, 2011, 06:14:43 pm
Thanks, Getrix =)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on March 09, 2011, 06:54:16 pm
Thanks Getrix :)

It works even though the hashes doesn't match.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 09, 2011, 07:01:01 pm
Will a change be required for the global sniffers? Feel free to PM when I need to change something. (sniffing aquilonia and fury)


This two function needs to be this in Core/AoC/Items.php

Code: [Select]
function parse_items($itemText)
    {
        $itemPattern = $this -> get_pattern();
        $items = array();

        $count = preg_match_all('/'.$itemPattern.'/i', $itemText, $matches, PREG_SET_ORDER);

        foreach($matches as $match)
        {
            $item['lowid']   = $match[2];
            $item['highid']  = $match[3];
            $item['ql']      = $match[5];
            $item['lowcrc']  = $match[6];
            $item['highcrc'] = $match[7];
            $item['colour']  = $match[9];
            $item['name']    = $match[10];
            $items[] = $item;
        }
        return $items;
    }

If you have this on line 46: (Else fix the function get_pattern)
Code: [Select]
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zA-Z0-9_\'&\s\-\:]*)\]<\/font><\/a>)';
Not sure if you have this function or not:

Code: [Select]
function get_pattern() {
        $language = $this -> bot -> core("settings") -> get("Items", "Language");
            if ($language == "RU") {
          $item_pattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\pL_\'&\s\-]*)\]<\/font><\/a>)';   
        }
        elseif ($language == "FR")  {
          $item_pattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zA-ZàâçèéêîôùûÄÆÇÊÌÍÎÏÒÓÔÕÖØÙÚÛÜÝáãäåæçëìíïñòóôõöøùúûüýÿ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';
            }
        elseif ($language == "DE") {
          $item_pattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zäöüßA-ZÄÖÜ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';   
        }
        else {
          $item_pattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zA-Z0-9_\'&\s\-\:]*)\]<\/font><\/a>)';   
        }
        return $item_pattern;
    }
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on March 24, 2011, 07:50:11 pm
im getting 502 errors.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on March 24, 2011, 10:27:06 pm
This was solved.
Error was that botname was with all characters low in botname.conf variable.

Next version whenever it will be live will probly have a fix for this userproblem ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: keirou on March 25, 2011, 09:41:09 am
its was the age old pebkac issue :)

me
Title: Re: New Central itemDB (!item[s|reg])
Post by: crauly on April 02, 2011, 07:52:34 pm
To get register new item work, new version of bebot item files are needed.
Founded here:
http://aoc-itemdb.sjef.biz/code/v5/Core_Items.phps
http://aoc-itemdb.sjef.biz/code/v5/Modules_Items.phps

This was abit quickfix to get it work. New version will arrive later when i get the time to add all the stuff i have in mind..

I have been tring to get the item db to work for some time, ever since the new engine came out, with no success.  I have the steps and have tried them numerous times. Not sure if perhaps something else is wrong.

I am getting a response in game "the requested name is vaild, but no date of the requested type was found."

the item i used for a test was "!items bluesteel"

I got an error in the dos window...

http://aoc-itemdb.sjef.bizbot/v5/botsearch.php?s
earch=bluesteel&botname=Lastlaugh&pre=%21&lang=EN&checksum=bc20f72ad9b608547e553
9d16c7b5bc0
Lastlaugh [ERROR]       [tools] Coult not connect to server aoc-itemdb.sjef.bizb
ot:80 (http://aoc-itemdb.sjef.bizbot/v5/botsearch.php?search=bluesteel&botname=L
astlaugh&pre=%21&lang=EN&checksum=bc20f72ad9b608547e5539d16c7b5bc0) Reason (The
requested name is valid, but no data of the requested type was found.
)
Lastlaugh [TELL]        [OUT]   -> Bloodax: The requested name is valid, but no
data of the requested type was found.

Further I checked under !settings and the password and my password shows as the old one i used to access the DB and the server shows as http://aoc-itemdb.sjef.biz

Hope i can get some help.  Either way thanks.  It was great while it lasted.

:)
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on April 02, 2011, 11:35:58 pm
If I do that search I get nothing returned (and no errors) - just checked as double checked the updates on both guild and global sniffer as I have customisation on my !items searching (shows who can make it by cross-referencing the !gitems module); I can see that the new code works as an item just got registered as world first (Frenzied War Hammer) but get nothing on that bluesteel search - if that helps ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 04, 2011, 09:22:24 am
@crauly:
Your setup is not correct. Follow instruction over again.

@BoA-Gert:
Make sure you have "Botname" in conf and not "botname".
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert on April 04, 2011, 11:03:19 am
Getrix - it's working fine for me; was just responding to Crauly that I wasn't getting anything back for bluesteel (other searches were fine)...for some reason over the weekend some searches weren't returning results but they are now with no changes to the bots.
Title: Re: New Central itemDB (!item[s|reg])
Post by: crauly on April 08, 2011, 09:21:48 pm
@crauly:
Your setup is not correct. Follow instruction over again.


Which part isnt correct, the settings portion or the file setup part?

And If i remember correctly i should have a

_items.php
items.php
Core_Items.phps

All in the <Botfolder>/core/aoc/ folder?

and

_items.php
items.php
Modules_Items.phps

all in the <Botfolder>/modules/aoc folder

They way i am understanding the instructions is to download the files, "save as" "all files" and i change the .html to phps.  Then i go in to the respective folder /core/aoc and /modules/aoc and change the files Items.php to _Items.php.  Then i put the two above mentioned downloaded files into the to respective folders, Core_Items.phps into /core/aoc and Modules_Items.phps into the modules/aoc folder?

thnks for the reply :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 09, 2011, 12:18:25 am
I linked you a step-by-step guide. Follow it step-by-step and it should be easy to get it work.
Title: Re: New Central itemDB (!item[s|reg])
Post by: crauly on April 18, 2011, 11:24:11 pm
I linked you a step-by-step guide. Follow it step-by-step and it should be easy to get it work.

I didnt receive any link nor is there a link in ur comment. 
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 19, 2011, 10:48:31 am
Checking up, you are not registered with any bots on my itemDB..
So have you at all requested access?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on April 19, 2011, 07:42:56 pm
Hi Getrix,

Can you check up on this item in the english db?
Commander's Chestplate of Heaven's Pass - 4496022

I couldn't reg it since it's already added.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on April 19, 2011, 11:12:30 pm
funcom changed the itemlink code, so gentrix need to update his code

for example Brokat: (red is new)

<a style="text-decoration:none" href="itemref://3861365/3861365/0/75/18235be1:373f2be9:ce47b7f5:a10a2aa7/18235be1:373f2be9:ce47b7f5:a10a2aa7/b290805c:29e627ca:b290805c:29e627ca"><font color=#6ea7>[Brokat]</font></a>
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 20, 2011, 10:47:07 am
@Kentarii: Commander's Chestplate of Heaven's Pass fixed, wrong tagged.
Still haven't fixed what i was gonna fix there :/

Margon: That proble should allready be fixed. If they haven't changed another time or maybe you haven't get the latest files you need localy at your bot?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Margon on April 20, 2011, 08:18:44 pm
my bot and the module works fine.. but i noticed some days ago that funcom changed the itemcode..
it was only an idea that your code for item detection was wrong ^^
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 21, 2011, 09:10:52 am
Item's are being registrated.
But i can see your link has another new hash. In start it was all the same, so gonna look into it soon if its are random generated or what..
Title: Re: New Central itemDB (!item[s|reg])
Post by: tank on May 08, 2011, 05:32:54 am
Hello all,
I am having some issues with the items command.  I've tested my bots connection to the new server through a direct !item command and that works fine.  The !items command always tells me it cannot find anything matching.

I've tried downloading the file again and that hasn't helped.  Any thoughts??

Thanks,
tank
Title: Re: New Central itemDB (!item[s|reg])
Post by: tank on May 08, 2011, 03:55:55 pm
I'm not sure what fixed this, but it's working fine now!  It figures that would happen as soon as I post for help!

Thanks for the great module!!
tank
Title: Re: New Central itemDB (!item[s|reg])
Post by: Holagox on June 23, 2011, 03:14:52 am
Hi All,

How do I get access to the ItemDB, I sent a PM to Getrix, but get no answer, can you help me?

MFG

Holagox
Title: Re: New Central itemDB (!item[s|reg])
Post by: Drizzurdeen on June 23, 2011, 02:39:27 pm
just write a pm to getrix ;) .... sometimes u have to wait a "litle" bit ^^
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kentarii on July 27, 2011, 02:27:54 pm
Just a little entry with wrong english name:

Search result for: 'zarallo'
Language: 'EN'
Item founds: '1'

[Amulette de Zarallo] lvl: 80

English should be [Amulet of Zarallo]
Item id  4085423
Title: Re: New Central itemDB (!item[s|reg])
Post by: Warmongers on July 28, 2011, 11:24:49 pm
[Chatbot]: Error in query to database

I PM'ed Gettrix but no reply. Anyone else getting this error? Pass key is in and server is set to: http://aoc-itemdb.sjef.biz/

Tools settings
force_sockets:  Off
get_site:  Sockets


Any help much appreciated. We are running it on Deathwish.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Oolwe on July 29, 2011, 10:33:58 am
Just a little entry with wrong english name:

Search result for: 'zarallo'
Language: 'EN'
Item founds: '1'

[Amulette de Zarallo] lvl: 80

English should be [Amulet of Zarallo]
Item id  4085423

Does the db allow search query in French or any other game language pls ?
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on July 29, 2011, 11:15:49 am
@Kentarii: Fixed the wrong tagged item "Amulet of Zarallo"

@Warmongers: Dunno what you are messing with :P

@ Eelwo: Yes, latest version of itemDB supports other then EN search.
Title: Re: New Central itemDB (!item[s|reg])
Post by: SalmonSeller on August 28, 2011, 09:07:49 am
So we currently have an issue where the items search function works fine, up until you click on the link. Or in our case, not click. The items can be searched for and the items code spams in chat, but the item link that appears is just text (rare, epic items, enchanted - doesn't matter). Any ideas? Or any code I need to check and report back on? Any help much appreciated.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on August 28, 2011, 10:26:27 am
And this problem you got about half a year ago? :P

http://bebot.shadow-realm.org/aoc-0-6-x-customunofficial-modules/alternative-central-itemdb-%28!item!items!itemreg%28auto%29%29/msg17068/#msg17068
Title: New Central itemDB (!item[s|reg])
Post by: GaRoN on September 14, 2011, 08:50:06 am
Can some one help me ?? I have a problem that !items tell me "unknown host"

I'ved look in all the messages here in this thread , but didn't find anything to fix it...

Code: [Select]
BOT [2011-09-13 16:18:02] [Items] [URL] http://aoc-itemdb.sjef.bizbot/v5/botsearch.php?search=G%FCrtel&botname=BOT&pre=%21&lang=DE&checksum=ffd09d9f540937d424529dbe212ac668

Warning: socket_connect(): Host lookup failed [-10001]: Unknown host in /...../BeBot/main/14_Tools.php on line 171
BOT [2011-09-13 16:18:02] [GROUP] [MSG] BOT: Unknown host

A few weeks ago everything was fine, but I had to clean my DB by wrong /not existing Char inserted

 so I don't know whats wrong and what host have changed
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 14, 2011, 10:02:56 am
take a good look on the url u have set, its not correct. error is telling you whats wrong...
Title: Re: New Central itemDB (!item[s|reg])
Post by: GaRoN on September 14, 2011, 09:17:06 pm
Yeah .. it was the wrong url .. I've used an old I think .. but I thought it was the new ^^
sry for the unnecessary pm Getrix

Greets GaRoN
Title: Re: New Central itemDB (!item[s|reg])
Post by: kolguy on September 23, 2011, 09:59:22 pm
i followed all the instructions sent to me by getrix and after that i get the following error

Abott [Items]   [URL]   http://aoc-itemdb.sjef.biz/bot/v5/botsearch.php?search=dagga&botname=Abott&pre=%21&lang=EN&checksum=4159df4cd7429335aed980d8f1d24e1f

Abott [GROUP]   [MSG]   [Angel] Abott: Sorry Abott, you dont have access to this
 service.

that is for anything i try with the items command.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 24, 2011, 05:00:46 pm
Dunno if i did mistake or you, but you got key for botname "Angel" and not "Abott".
Changed it now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: kolguy on September 25, 2011, 07:36:47 pm
Dunno if i did mistake or you, but you got key for botname "Angel" and not "Abott".
Changed it now.

ah thanks its working now.
Title: Re: New Central itemDB (!item[s|reg])
Post by: wabbit on October 02, 2011, 09:02:07 pm
Im still having problems when we click on the item search link.

Sorry, your search '4570221' didn't give any result.

Is what we get on any item we click. I have seen your post on page 19 and downloaded those new files which you say corrects this but it does not. I have redownloaded and installed the mod 20+ times and it just will not display the item and stats when we click the link for it.  :'(
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix 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)

Title: Re: New Central itemDB (!item[s|reg])
Post by: wabbit 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
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix 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..
Title: Re: New Central itemDB (!item[s|reg])
Post by: wabbit 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!
Title: Re: New Central itemDB (!item[s|reg])
Post by: BoA-Gert 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...
Title: Re: New Central itemDB (!item[s|reg])
Post by: Harth on April 10, 2012, 07:28:00 am
Hi, Is this still running and available?


Cheers
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 12, 2012, 07:19:50 am
Its not been shutdown  ;)
Title: Re: New Central itemDB (!item[s|reg])
Post by: Harth on April 12, 2012, 07:37:20 am
How would i go about... getting the database address and password? : ;D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on April 12, 2012, 08:51:13 am
By reading the topic and first post
Title: Re: New Central itemDB (!item[s|reg])
Post by: Miron 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. :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: cynara 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).
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix 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.
Title: Re: New Central itemDB (!item[s|reg])
Post by: RaZeR 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.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Goratt 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.


Title: Re: New Central itemDB (!item[s|reg])
Post by: WeZoN 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."
Title: Re: New Central itemDB (!item[s|reg])
Post by: Emirri on September 04, 2013, 11:46:21 pm
Hi, I have installed the phps, updated with Cynaras code but I still get this when trying to search:

Wrong checksum (Error Code: 502)

Any clues guys? Thanks for help :)
Title: Re: New Central itemDB (!item[s|reg])
Post by: dragonjr on September 13, 2013, 01:47:18 am
after the EU and US server merge my DB does't work i dont know if the item codeing changed or its because my bot name had to change and i have to change something with that any info on this would be great thanks .


this is what i get
[Guild] [Sininstyle]: !items gold
[Guild] [Dragonsr]: Error in query to database

[Guild] [Sininstyle]: !items firestick
[Guild] [Dragonsr]: Error in query to database
Title: Re: New Central itemDB (!item[s|reg])
Post by: dragonjr on September 16, 2013, 03:30:19 am
thank you very much Getrix for your help i got it working  ;D
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 16, 2013, 04:45:30 pm
Im going to cleanup the database and fix servermerge problematic for active bots, but can take some before i get time todo it.
Just PM me if you are in hurry to get your bot work after merge. Still need bot and servername to fix it..
Title: Re: New Central itemDB (!item[s|reg])
Post by: Zamali on March 15, 2014, 08:00:46 am
Hi Getrix,

I started a new bot and need a new authkey for the items database please.

Bot: Scyphos
Dimension: Crom

Thankyou!
Title: Re: New Central itemDB (!item[s|reg])
Post by: Getrix on September 12, 2016, 08:51:06 am
Yo!

Its been years since i played AoC, but i have stille mantained the itemDB (Not much work, super-uber-stable-host)..
But have come to the day where im doing a server/host cleanup and moving to new hosts..


Is there anyone playing the game and feel this DB is still  must have?


Some DB stats:
500 bots added, from start..

Search queried:
+------+--------+
| year | total  |
+------+--------+
| 2009 | 424226 |
| 2010 | 945343 |
| 2011 | 472590 |
| 2012 | 233203 |
| 2013 | 145303 |
| 2014 |  70917 |
| 2015 |  36604 |
| 2016 |  17572 |
+------+--------+

Items added:
+------+-------+
| year | total |
+------+-------+
| 2009 | 45287 |
| 2010 | 55280 |
| 2011 | 21423 |
| 2012 |  7706 |
| 2013 |  3349 |
| 2014 |  1192 |
| 2015 |   758 |
| 2016 |   358 |
+------+-------+
Title: Re: New Central itemDB (!item[s|reg])
Post by: aoc_botter on September 17, 2016, 07:06:44 pm
Hi,

I have just set up a new bot. I haven't gotten around to installing this module, but wouldn't running this if you still plan on maintaining it.

Server: Crom
Bot: Dancingbot
Title: Re: New Central itemDB (!item[s|reg])
Post by: Halfdead on April 29, 2018, 03:43:48 am
So !items no longer works. I imagine the hosting is gone?

Not much action here Lol, but it was still helpful.
Title: Re: New Central itemDB (!item[s|reg])
Post by: Kakahu on May 16, 2018, 09:22:47 pm
So !items no longer works. I imagine the hosting is gone?

Not much action here Lol, but it was still helpful.

I can't imagine that server took much bandwidth or even saw much usage.  It is probably something any of us could have running on a spare computer.