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.
And move:
Core_Items.phps -> <Botfolder>/core/aoc/Items.php
Modules_Items.phps -> <Botfolder>/modules/aoc/Items.php
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 ;)
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.
Server that need GlobalItemSniffer sponsors:
EU: Crom, Fury, Blackscar, Skullcrusher, Hyrkania, Skullcrusher, Aquilonia
DE: Aries, Asgard
FR: Isthar, Ferox, Stygia
ES: Zingara, Indomitus
You upgraded your bot from X to 0.6.6 and overwrited the costume made .php files you used before upgrade..?
2009-11-17: Problem with host. Fix is underway.
lowcase: ä, ö, ü, ß
uppercase: Ä, Ö, Ü
$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>)';
Code: [Select]$itemPattern = '...
DONT USE
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>)';
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>)';
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>)';
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>)';
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
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..Quote2009-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
Could you give som screenshot? I cant imagen where this error come from and how you get it screened...
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
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.
2010-01-10: Guilbots also on: Ironspine, Stygia
This is when using "item(s|reg)?
There shouldnt be any problem on the central server side...
!items Brustpanzer der heldenhaften Seele
I need some beta testers for DE, RU, FR, ES search support.
Anyone interested?
Server that need GlobalItemSniffer sponsors:Let me know if you want me to host a bot for Fury.
EU: Fury, Blackscar, Skullcrusher, Hyrkania, Skullcrusher
hi.you can send me this itemDB.thx for you(http://aoc-itemdb.sjef.biz/gfx/stats.php)
Announce:
Noer announced that hewouldhave 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 backgroundI 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.
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,Crom,Aquilonia, Hyrkania
DE:Mitra, Asgard
FR: Isthar, Stygia
PL and RU is abit hard because of the special chars..
-Getrix, Fury
This is a Alternative Unofficial Central itemDB, so you need to make sure you have the correct files..
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
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
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.
[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
Only open wlan at street with phone this week:p
http://aoc-itemdb.sjef.biz/bot/v5/botsearch.php?single=1&id=3861768&botname=seregbot&lang=EN&checksum=830e9eaa649a2d62ecee68625a62f3c9
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)
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.
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
Is the DB down again? We are still getting the 'Error in Query to Database' message. Any ideas? ???
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.
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.
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?
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.
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.
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 :) )
QuoteIf 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 :) )
[22:31] [Guild] [xxx]: !item 3748695
[22:31] [Guild] [xxxbot]: [Twilight Padsoles]
Will a change be required for the global sniffers? Feel free to PM when I need to change something. (sniffing aquilonia and fury)
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;
}
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>)';
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;
}
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..
@crauly:
Your setup is not correct. Follow instruction over again.
I linked you a step-by-step guide. Follow it step-by-step and it should be easy to get it work.
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
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
Dunno if i did mistake or you, but you got key for botname "Angel" and not "Abott".
Changed it now.
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...
QuoteCheck 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..
return $this -> bot -> core('items') -> search_item_db_details($words);
withreturn 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));
itemref://3800224/3800224/0/0/80/6df3ae75:8c0cf53b:e81418d0:93d4c95a/6df3ae75:8c0cf53b:e81418d0:93d4c95a/b290805c:29e627ca:b290805c:29e627ca/b290805c:29e627ca:b290805c:29e627ca
But when I manually changed it toitemref://3800224/3800224/0/0/80/0:0:0:0/0:0:0:0/0:0:0:0/0:0:0:0
it 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).
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.
So !items no longer works. I imagine the hosting is gone?
Not much action here Lol, but it was still helpful.
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 |
+------+-------+