World of Warcraft [item]-bbcode.

This is in reply to this thread.

Download the product-itemstats.xml, vb_itemstats.php and 'itemstats_1.2.zip'.
Unzip itemstats_1.2.zip to your forum-root (ie http://your.site.tld/forum/itemstats), and follow the basic setup instructions in doc/config.txt.

Copy vb_itemstats.php into your itemstats-folder.

Paste the following two lines into the bottom of your headinclude-template

<link rel="stylesheet" href="itemstats/templates/itemstats.css" type="text/css">
<script type="text/javascript" src="itemstats/overlib/overlib.js"><!-- overLIB (c) Erik Bosrup --></script>

Lastly, upload the product-itemstats.xml into your product manager, and you should be all set.

Link items with [item]Item name[/item].
The first time the item is loaded might take some time, as it fetches info from allakhazam.com. From then on it will be cached in the database, and should load instantly.

[Grant]

I think this needs some better instructions on how to install it and with the DB creation and everything like that .. coz I am clueless ..lol

[Grant]

Anyone able to help me with this? There are to many diff files and things its just confusing, and I'd like to somehow install this.

[twsphere]

Originally Posted by exilera

It all seems to be working OK. I had an issue, but uploading the modified files and emptying the database table as mentioned in this thread fixed that problem.

However, the icons won't display. I get a red X inside a box where the Icon is supposed to show. Would anyone happen to know why that might be?

Thanks!

well i got in the same promble ..someones can teach us how to fix it ?

[Boofer]

ok this is working sortof. I can see the mouseovers and they are properly displayed. The problem is if you edit the post for any reason the links become hyperlinks to Allakhazam. Apparently this is because of parsing? I have no idea. Is there a fix?

[tweak]

How do u create the DB Item cache table?? And how come there is no VB instructions just phpbb? Im lost would love to use this

[Grant]

Ok I got it all working cept for the No images .. like there are no icons on the mouseover and I get a </ span > at the end of them all if I make a new line.

any fixes would be great

[Grant]

any fixes for this yet? or ideas? would be much appreciated.

[tweak]

Originally Posted by Grant

Ok I got it all working cept for the No images .. like there are no icons on the mouseover and I get a </ span > at the end of them all if I make a new line.

any fixes would be great

any help on how u got the DB to work?? I installed it but it wont load anything i link??

[Grant]

You just need to create the table.. if you have never run EQDKP before then it might be a little hard knowing what that table is, but in phpMyAdmin, do an SQL dump using the following code:

CREATE TABLE `item_cache` (
  `item_name` varchar(100) NOT NULL default '',
  `item_link` varchar(100) default NULL,
  `item_color` varchar(20) NOT NULL default '',
  `item_icon` varchar(50) NOT NULL default '',
  `item_html` text NOT NULL,
  UNIQUE KEY `item_name` (`item_name`),
  FULLTEXT KEY `item_html` (`item_html`)
) TYPE=MyISAM;

That should get it working anyway ..

[Grant]

With the whole icon not showing problem, I noticed that the link in the config file to the icons is http://wow.allakhazam.com/images/icons but then I checked the source of a post that has the itemlink in it and the source says http://wow.allakhazam.com/image/icons .. which is why I think it's not working.

I've tried finding the file that seems to change the link but I can't find it. If anyone knows where It may be found, would be much appreciated.. I've tried uploading the icons locally to my server and then changing the link in the config, but it looks like the alla link is hard coded, and its wrong.