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.

[Zigidias]

Originally Posted by lanc3lot

Is this fix, a way to add the Item code, on the editor??

If not, anyone who managed to do it?

uh a fix? such as where it leaves the [item] [/item] bbcode intact

[aholtzmann]

Originally Posted by Borgs8472

I must have missed something because I don't have a item_cache_table anywhere. Have uninstalled and reinstalled the xml file several times.

What could I have missed? :/

Sadly, nothing. The table must be created manually. I suggest getting the 1.3.1 Update for ItemStats and use it's documentation (which includes the SQL commands to create the table correctly) to update your installation.

[Borgs8472]

^ ^
ah cool. I'll give it another go with that in mind then

[y2krazy]

Is there a way to use this for other RPGs, such as Guild Wars? Ty.

[mosummers]

Can someone help me with an issue? I seem to have itemstats working fine.... the only issue is the image is not showing up.... I modified the config.php in the itemstats dir to read:

define('ICON_STORE_LOCATION_HTTP', 'http://www.servername.com/halcyonguild/eqdkp/icons/');
define('ICON_EXTENSION', '.png');

This is the location of my icons. Any idea why it is not showing up? Just get the red x in IE, and get nothing in firefox.

---

Another very interesting thing. If I have more than one item listed:

i.e.

[item]Item name 1[/item]
[item]Item name 2[/item]

Then only item name 2 shows up - and item name 1 doesn't hover...

If I add below it:

[item]Item name 3[/item]

Then item name 3 hovers ok (without the pic) and itemname 1 and 2 lose their hovers.

Please see pic for example. As you can see the hover works fine, but only for the last item. All prior items have lost their color and the hover. If I add a new item via edit, then the working hover goes away and it works then on the newest item only.

I am running Itemstats 1.3.1

Thank you!

-----------------

*EDIT: I fixed the problem with the picture not showing up. The file itemcache.php had in its first line:

include_once(dirname(__FILE__) . '/../config.php');

This needed to be changed to:

include_once(dirname(__FILE__) . '/config.php');

The problem with it erasing the prior item's hoverability howver persists. The last one entered is the only one that works.

Edit #2:

Resolved. Needed to add 'item' to the var $unparsed_tags in class_bbcode_alt.php

[Htd]

After searching through these threads I think I have a new one here. I've installed the original 1.2, then 1.31 on top of that (replacing all old files). I've got my config.php set to a working database, and the table created. After following all the instructions I can get vBulletin (3.5) to recognize the bbcode (it puts it as a link) but there is no popup and the link is incorrect. Attached is a screenshot of the link, then code used to make the link, and the URL the link points to (the mouse is hovering over the link). Any ideas?

[aholtzmann]

It sounds like you forgot to add the Overlib script line to the headinclude of your style/theme. Or perhaps your Z-Layer is off for some reason.

[Htd]

Originally Posted by aholtzmann

It sounds like you forgot to add the Overlib script line to the headinclude of your style/theme. Or perhaps your Z-Layer is off for some reason.

hmm, no the overlib stuff is there ok. I see that one problem is that the onmouseover does not seem to be doing anything at all, whereas the onclick is linking to the updateitem.php (this seems wrong to me). Doesn't the onclick link to allakhazam and the onmouseover run the .js to popup the stats?

[aholtzmann]

Originally Posted by Htd

hmm, no the overlib stuff is there ok. I see that one problem is that the onmouseover does not seem to be doing anything at all, whereas the onclick is linking to the updateitem.php (this seems wrong to me). Doesn't the onclick link to allakhazam and the onmouseover run the .js to popup the stats?

The update link is by design, it allows the code to try to update the database if an item isn't found on a previous pass. Usually the mouseover on an uncached item shows an "Item not found" hover but it might not if it cannot access the database at all.

Make sure the code can connent to your DB server and that your item_cache table uses this structure;

CREATE TABLE IF NOT EXISTS `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 `name` (`item_name`),
FULLTEXT KEY `data` (`item_html`)
)

Good luck.

[arachaic]

I've updated to v1.3.1, and made the necessary changes by uploading the folder and overwriting the 1.2 files in the itemstats folder.

Everything is working fine, but the mouseover produces this effect (see attached pic).

Using: vB 3.5.4

Anything I can do to perfect this?

Thanks.