gItemStats - World of Warcraft Itemstats

[Gryphon]

What is it?
-gItemStats is a modification for vBulletin which allows you to display popup World of Warcraft item information on your fourms.

See this thread (https://vborg.vbsupport.ru/showthread.php?t=182100) for the continuation of this modification.

Check out my iGoogle homepage gadget for World of Warcraft item database searching. (http://www.google.com/ig/directory?url=rsnook.googlepages.com/wowdb.xml)
https://vborg.vbsupport.ru/

[Oll1]

Thank you very much!

I like the new Itemsstats with socket support :)

*thumbs up*

[wstahlhut]

I do see some oddness if you edit a post with item BBcode in them...

[ethics]

Anyway to make it so we can add a button for the editor? I know there's a way to do that with the custom bb code option in the admin. But need to know what replacements to use in the code.

[bprell]

I was wondering if someone could walk me through a standard install process. I feel kind of dumb because the instructions just say to upload it and it should work. I'm not going to lie, I'm not very well-versed in vBulletin (or mods to it) as of yet. Here's what I did:

1) Uploaded the "include" and "itemstats" folder to my vbulletin directory on the web server.

2) Tried a test post...that didn't work. The text just showed up at My Item

3) Realized that I never imported the included "product-gItemStats.xml" so I did that.

4) Tried another post. Still didn't work, but this time the text was indicated to be a hyperlink. It did quickly flash to an error page that said:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'DBUSER'@'localhost' (using password: YES) in E:\websites\forum_name\forums\itemstats\includes\s qlhelper.php on line 30
string(40) "Unable to connect to SQL host: localhost"

Still didn't work after that.

My problem is, I'm not sure if I missed a simple step that is just not causing it to work, or if I legitimately need to go in and edit something (not sure what that would be). I just know that I followed the instructions to "upload it and go" and I'm not having very much success.

If anyone could help me shed a little light on this, it would be greatly appreciated. Even if its just a matter of "ok dummy, here's exactly what you need to do, step by step", that's fine. Just not real sure what to do from here.

Thanks in advance!

[Gryphon]

Well, I was afraid of that. Looks like you did everything correctly, however I tried to avoid having people need to edit any files but it looks like it might be something I can't get away from. Let me investigate it a bit more and see what I can find out.

If anyone has mysql connect errors, they can enter their database information into itemstats/config.php, and if this is the case, then the gItemStats options probably will not work correctly as well, for these options you will have to adjust in itemstats/config_itemstats.php

I tried to make it automatically use the vBulletin config, but depending on certain server configurations this may not work as the Itemstats config will probably reset what I have tried to set...if that makes any sense.

[bprell]

Out of curiosity, I tried to edit the config.php file with my mySQL information. Still did not work and got the error

Failed to update item: Netherwind Crown (Table 'forums.item_cache' doesn't exist)
Failed to update item: Netherwind Crown (Table 'forums.item_cache' doesn't exist)

Not the end of the world. I think I'll back off the change to the file I just did and wait to hear something more fun and exciting from someone that knows what they are doing (versus me monkeying around with stuff and screwing it up) :)

Thanks for responding!

[Gryphon]

wstahlhut, what kind of oddness? It appears to work fine for me.

Ethics, I will look into doing that.

bprell, I am currently working on a fix for this.

*Edit: A fix is up, let me know if this works for you.

[wstahlhut]

when you edit or quote this is what the quoted code looks like

[URL="http://www.thottbot.com/?i=Schematic%3A%20Crashin%27%20Thrashin%27%20Robot"][Schematic: Crashin' Thrashin' Robot]</span>[/URL ]
[URL="http://wow.allakhazam.com/db/item.html?witem=23885&locale=enUS"][Schematic: Remote Mail Terminal][/URL ]
[URL="http://www.thottbot.com/?i=Pauldrons%20of%20the%20Wardancer"][Pauldrons of the Wardancer]</span>[/URL ]

I did break the [URL] bbcode here so you can see...

[Gryphon]

Hmm interesting, I can not get my forums to reproduce that.

[bprell]

wstahlhut, what kind of oddness? It appears to work fine for me.

Ethics, I will look into doing that.

bprell, I am currently working on a fix for this.

*Edit: A fix is up, let me know if this works for you.

Well something is definitely up. As soon as I uploaded the code it brought my vbulletin to its knees....won't hit the main page at all. Tried backing it out but that didn't help anything...must've overwritten some file somewhere. :(

The error I'm receiving is the following:

Fatal error: Cannot redeclare handle_bbcode_item() (previously declared in E:\websites\flockofemu\forums\includes\functions_g itemstats.php:767) in E:\websites\flockofemu\forums\itemstats\vbulletin_ itemstats.php on line 10

You can see the error yourself if you'd like. www.flockofemu.com . If you have any thoughts, they'd be appreciated.

(I know this isn't the place for vbulletin support...it's my own deal as I'm the one that uploaded the code. Just figured I'd respond and see if anyone else knew anything.)

[Gryphon]

Yeah, the product needed to be updated prior to upload the files.

You should be able to delete the contents of itemstats\vbulletin_itemstats.php to recover functionality and get the product installed.

[bprell]

Just to verify what you're saying, I deleted the actual contents of that file while leaving everything else in tact. This is the error the forums are giving:

Warning: require_once(E:\websites\flockofemu\forums/includes/functions_gitemstats.php) [function.require-once]: failed to open stream: No such file or directory in \global.php(356) : eval()'d code on line 5

Fatal error: require_once() [function.require]: Failed opening required 'E:\websites\flockofemu\forums/includes/functions_gitemstats.php' (include_path='.;C:\php5\pear') in E:\websites\flockofemu\forums\global.php(356) : eval()'d code on line 5

I apologize for continuing to post this here as you're kind of my "lifeline" right now. :) If I need to take this to another place, just let me know.

Thanks again.

[Gryphon]

It looks like functions_gitemstats.php is not uploaded possibly?

v1.02 is updated to prevent this from happening if the files are not available on the server.

[bprell]

Just wanted to let you know that this resolved my issue...I'll post another update once I get a chance to load the new code. Thanks again for all of your help!

[Masked Crusader]

bprell, so does everything work the way he says at the top?

[Masked Crusader]

WORKS FREAKING PERFECT! I HAVE BEEN LOOKING FOR THIS FOR AGES!

Blackjack, I owe you a beer bud.

[Andaas]

Installed and it's working great, thank you very much.

I'm curious though about integrating the [ item ] tags with the wysiwyg editor; is there an easy way to do this? I've got some users that are trying to edit long posts with items, and if you view ItemStats links in the advanced editor, it basically eats them, replacing them with normal hyperlinks.

Thanks again. :)

[Gryphon]

Ah, maybe that is what was happening to wstahlhut, I did not look at the wysiwyg editor, I hate that thing :D

I'll look into it.

[Andaas]

I believe that is the same problem, yes.

I too hate the wysiwyg editor, but I leave it enabled on my forums because some people do like it. :D

[wstahlhut]

yep yep, that would correct

[Scathefire]

is there any way we can pull from wowhead as the item site? It is so much faster and cleaner than thott/alaka-spam

[Gryphon]

No there is not, Itemstats was created by someone else and these are the sites he has coded for and it appears that he will no longer be updating the parser. I might look into doing it myself, but I don't personally use Wowhead.

[Kaelon]

This is a great product. I've installed it, and found it to be a major upgrade over the previous ItemStats (especially with no file editing).

Recently, someone else overcame the WYSIWYG "oddness" (the item tagged text appears as a hyperlink to the Allakhazam or Thottbot material) by simply having it always reverse transcripted to |item|itemname|/item|. Is there a way that could be done here so that compatibility with the WYGIWYG editor can be ensured?

Thanks!

[Gryphon]

Yeah I think I saw that on another addon as well. I was going to take a look and see how they did it, I just have not had time to look it up yet. I hope to have a fix for that soon.

[Reeve of shinra]

Im getting this error message on any forum i visit with this installed...

Fatal error: Cannot redeclare handle_bbcode_item() in /home/warcraft/domains/landofwarcraft.com/public_html/board/itemstats/vbulletin_itemstats.php on line 6

[turnipofdoom]

I absolutely love this for the WoW site I admin, what I wouldn't give to see one for my EQ2 site. Thanks again for this great mod!

[tgitm]

This sort of works for me.

The popup works, with sockets, but the item icon wont display.

[eduardobarcello]

When I make a post with like, 200 itens on it (bank parses), it crashes the thread. It may seem odd that someone would post 200 itens, but its perfect for guildbanks to post their contents. I did make the parsing mod merge all stacks to reduce the amount of iten links, but still we will get 200 iten links sometimes and it'll crash the thread, and I have to disable the ItemStats mod, post 100 itens, load it, then post more 100 in another post, reload it, then it'll work.

Any advice for this problem? (besides telling the guildbanks to not be such packrats hehe)

[Kaelon]

When I make a post with like, 200 itens on it (bank parses), it crashes the thread. It may seem odd that someone would post 200 itens, but its perfect for guildbanks to post their contents. I did make the parsing mod merge all stacks to reduce the amount of iten links, but still we will get 200 iten links sometimes and it'll crash the thread, and I have to disable the ItemStats mod, post 100 itens, load it, then post more 100 in another post, reload it, then it'll work.

Any advice for this problem? (besides telling the guildbanks to not be such packrats hehe)
Have you tried setting the gItemStats config to parse the Item information upon clicking, rather than upon rendering the thread? Not sure if the crashing is a database error or, more appropriately, a JavaScript error, but that might help debug it.

[eduardobarcello]

This is what happens: Someone post a long list of , anything from 150 and up. They click "post", the thread or new post is posted, but then it gets stuck for about 1 minute because its trying to open the thread with the new post, until their web browser just shows a timeout message. The new post (or new thread) however gets posted fine. But anyone trying to access it simply gets stuck and their browser times out. To me (the admin), the vBulletin then sends the following email every time someone tries to access those threads:

Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE vbsession
SET lastactivity = 1173694527, location = '/showthread.php?p=2048', incalendar = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'
WHERE sessionhash = 'c49796a3afa908442d40da90485c1fac';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013

The option define('automatic_search', false); in the config_itemstats.php is set to false.
Now what I do when someone post long item banks and the thread gets stuck is, I disable the mod, divide their post in half (copy and cut off the ending half of the itens), save and load the thread to make sure it loads fine without getting stuck, then I post again with the ending half of the itens and load the thread once more. Once it loads, it's there forever.

[Gryphon]

eduardobarcello; automatic_search is set by the gItemStats vBulletin options, config.php and config_itemstats.php is not used at all.

The problem with adding 200 item's is that it has to open 200 thottbot/alla/etc pages one at a time at the time of posting (with auto search on) in order to retrieve the information about each item. This can be a lengthy process depending on how quickly your server can talk to the database site and how well it can process the resulting information.

Support for this addon is a little tricky as the code that actually does the retrieving of the item data is done by code not written by me and I am not quite prepared to support that, however I will attempt to, but it may not be in a timely manner. Basically what I am providing here is ease of installation of Itemstats (http://itemstats.free.fr/) by eliminating the need for editing config files.

Reeve of shinral; I am not quite sure why that is happening for you. It would appear that you might have two [item] modifications which declare that function?

[istvan]

would it be possible to add support for www.wowhead.com to this plugin for what i noticed that site is 9 out of 10 times way faster then the others
nvm saw the answer in another post now

[Kinneas]

Great work! Been waiting for something like this for a while.

*Installs*

[Synth]

Installed and working great! Thanks for your work:up:

[Kimimaru]

best addon :)

big thanks works great!

But .... do not work!

[Kaelon]

best addon :)

big thanks works great!

But .... do not work!
Yep, it seems like [itemico] functionality has not been included or introduced in this hack. Any thoughts of making this available?

[Kimimaru]

is this the same version like http://itemstats.free.fr/news.php?

[Gryphon]

Yes it is the same, though I left out [itemico]. I didn't think anyone used it, it does the exact same thing as [item].

I can include it.

[mdroschak]

I have an issue with my Socket's showing up as Red X's

Everything else works great.

Any ideas?

EDIT: Here is what i noticed. If i pull from Allakazham i get red X's in the sockets. If i pull from Thottbot i get everything to show up. The only problem is the Text that is supposed to be green is showing up as Orange on the item name.

[Kimimaru]

have you an example for this problem? a link?

[mdroschak]

have you an example for this problem? a link?

Here are two pictures attached.

The first one is when itemstats is set to pull for Thottbot. As you can see everything looks ok but the colors are orange. Even the socket images show up fine, although in my example this paticular item does not have sockets.

In the 2nd picture that is when itemstats pulls from allakazham as you can see the colors are correct but the socket images show up as Red X's... I'm assuming it has to do with the websites but im sure there has to be a way to fix it, maybe a change with the code or an adjustment that has to be made.

[Kimimaru]

The first one is when itemstats is set to pull for Thottbot. As you can see everything looks ok but the colors are orange. Even the socket images show up fine, although in my example this paticular item does not have sockets.

I have the same problem by that item. By other items the tooltip is green.

In the 2nd picture that is when itemstats pulls from allakazham as you can see the colors are correct but the socket images show up as Red X's... I'm assuming it has to do with the websites but im sure there has to be a way to fix it, maybe a change with the code or an adjustment that has to be made.

i have copy the socket images on my server. (allakhazam).

example: http://www.dragonhearts-guild.de/images/redsocket.png

Thottbot:
http://your_website.com/en/Interface/ItemSocketingFrame/UI-EmptySocket-Red.gif

[mdroschak]

Do the itemstats pull the socket images much like they pull the item image? I run all my images locally and believe i have the most updated set of images on my server. Even if i change it to pull from Alla it still comes up with red X's..

My guess is that they havent update their socket images yet or something.

Can you zip up all your socket images and put them up here so i can download them? I copied that socket image you posted and put it into my images, cleared my item_cache and it still does not find the redsocket.png.. Is there an other file that controls the socket images?

BTW how did you make those modules show up the item stats "last 5 loot" on the left of your page? Does that pull from EQDKP?

[mdroschak]

ok, I got it.

Here is the fix for Allakazham.

The problem is in how ItemStats parses data from Allakhazam. It seems Allakhazam changed its design slightly after the parser was written. I fixed it like so...

open includes/allakhazam.php

Go to line 105

if (preg_match_all('#<img class="esock" src="/images/(.*?)\.png".*?/>#s', $item['html'], $matches_sockets)) { foreach ($matches_sockets[0] as $key_socket => $match_socket) $item['html'] = str_replace($matches_sockets[0][$key_socket], '<img src="' . $path_images_sockets . $matches_sockets[1][$key_socket] . '.png" alt="' . $matches_sockets[1][$key_socket] . '"/>', $item['html']); }

Replace with


if (preg_match_all('#<span class="esock"><img src="/images/(.*?)\.png".*?/>#s', $item['html'], $matches_sockets)) { foreach ($matches_sockets[0] as $key_socket => $match_socket) $item['html'] = str_replace($matches_sockets[0][$key_socket], '<span class="esock"><img src="' . $path_images_sockets . $matches_sockets[1][$key_socket] . '.png" alt="' . $matches_sockets[1][$key_socket] . '"/>', $item['html']); }

Clear your item_cache information and thats it.

Fixed it for me


EDIT: The only socket Image I have problems with is the Meta Socket. Everything else shows up perfect. Anyone have the .png file for that?

[Kimimaru]

Allakhazam:

Red (http://wow.allakhazam.com/images/redsocket.png)
Blue (http://wow.allakhazam.com/images/bluesocket.png)
Yellow (http://wow.allakhazam.com/images/yellowsocket.png)
Meta (http://wow.allakhazam.com/images/metasocket.png)

Thottbot:

Red (http://i.thottbot.com/en/Interface/ItemSocketingFrame/UI-EmptySocket-Red.gif)
Blue (http://i.thottbot.com/en/Interface/ItemSocketingFrame/UI-EmptySocket-Blue.gif)
Yellow (http://i.thottbot.com/en/Interface/ItemSocketingFrame/UI-EmptySocket-Yellow.gif)
Meta (http://i.thottbot.com/en/Interface/ItemSocketingFrame/UI-EmptySocket-Meta.gif)

[mdroschak]

Cool thanks!

I downloaded all the images but still have problems with the meta socket image.

I tried changing the socket image location in my allazahzam.php file to be local but that didn't work.

Which file did you change for your local socket images?

[Crapforum]

Nice mod.

Too bad it doesnt work okay on my site.
The popup works in the preview but doesn't popup when i actually post it.

http://www.crapforum.nl/showthread.php?t=30423

The posted url looks like this: http://www.mydomain.nl/\'http://www.thottbot.com/?i=Destroyer Chestguard\'


any help appriciated.

never mind, this mod rocks....had a conflict with a badly written replacement mod.

[phace]

I was wondering if it's at all possible to change the color of an item when using itemstats. The one I would like to change in particular is the 'quality1' items that appear as white links which blend in almost entirely with the light backgrounds in vBulletin.

Any ideas?

[Crapforum]

I was wondering if it's at all possible to change the color of an item when using itemstats. The one I would like to change in particular is the 'quality1' items that appear as white links which blend in almost entirely with the light backgrounds in vBulletin.

Any ideas?


I had the same problem, fixed it with a background color.

you can change the colors in: .\itemstats\templates\itemstats.css

.whitename, .quality1 { background-color: #000000; color: #FFFFFF; font-weight: bold; }

[phace]

That will work, thank you very much. :)

[ChiliVB]

Just wanted to say this installation worked great!

It also resolves an issue I was having with long item names not saving properly in the database with the itemstats 1.5.5 version for Vbulletin I downloaded from Yahourt's site. And, this installation required no manual edits or workarounds to allow for the new socket images.

But, best of all, if any of you utilize Stefan's vB Code [table] mod for banks, points, etc. Blackjack's mod'd version of itemstats works great with it. (Previous versions would not parse corrently and were truncated making itemstats unusable in the tables.) *happy snoopy dance*

[hostvn]

error

Fatal error: Cannot redeclare getstrcssstyle() (previously declared in d:/www/vhosts/localhost/httpdocs/demo/includes/functions_gitemstats.php:90) in d:/www/vhosts/localhost/httpdocs/demo/itemstats/itemstats.php on line 31

[Gryphon]

Thanks ChiliVB, though note that there is nothing different about this and Yahourt's. I pretty much simply manage the config.php via vBulletin's options :)

error

Fatal error: Cannot redeclare getstrcssstyle() (previously declared in d:/www/vhosts/localhost/httpdocs/demo/includes/functions_gitemstats.php:90) in d:/www/vhosts/localhost/httpdocs/demo/itemstats/itemstats.php on line 31


Make sure you are not running another itemstats product, like Sparkz's modification. itemstats/itemstats.php is not loaded in my modification, that is being loaded by another mod which is conflicting.

[ChiliVB]

Thanks ChiliVB, though note that there is nothing different about this and Yahourt's. I pretty much simply manage the config.php via vBulletin's options :)
Yes, but your version helped me to find a very small change in the config that made alot the difference in trying to use itemstats with the table mod. The table codes inserted by allakhazam don't work with the vbtable, but the html format used for the itemstats by thottbot does.

I have a question:

1. I was trying to get the View_cache.php file to work with the gitemstats cache. But I couldn't seem to get the right combination of your 'MasterServer' database info from the functions file to get it the authentication to work. I'd like to able to use this feature instead of having to login to PhP MyAdmin if possible.

Have you tried doing this to see if its possible with your configuration?

[Gryphon]

For view_cache you will need to to edit the itemstats/config.php and enter your database information. The "item_cache_table" is "prefixgitemstats" if you have a prefix, otherwise just "gitemstats".

It will not abide by the vBulletin config, so you will need to edit config_itemstats.php to what you want as well.

[npregean]

I know that a lot of people have been having issues with socket images appearing, but I'm having an issue with no images appearing at all. I did not change the path where Icons are stored (it's still "http://wow.allakhazam.com/images/icons/") and the Icon extension is still ".png"

Please check out a test post that I made below. What could be going wrong here? Any help or suggestions would truly be appreciated.

http://www.battlegroundforums.com/bgtest323/forum/showthread.php?t=6615

[colicab-d]

Anyway to get this working properly via Vbavdanced CMS?

[Gryphon]

It should work fine. I don't know much about vBAdvanced however, I use my own cms. Someone will have to give me more information about what needs to be done in order for it to work.

[Kimimaru]

Anyway to get this working properly via Vbavdanced CMS?

yes, what is your problem?

[npregean]

I just posted a message above and it seems to have been ignored...there is an apparent issue with this plugin in my situation and I'd like to have it addressed if possible.

http://www.battlegroundforums.com/bgtest323/forum/showthread.php?t=6615

Notice how the image icon for the item does not appear when you scroll over the item link. Why would this be happening? Does anyone have any idea? As I said, I have the images linked correctly in the vB Options area. I've also tried clearing the item cache in the database several times and even modified the popup HTML template to try to force a static URL image link, but even then the icon image did not appear.

The forum is integrated into the Subdreamer CMS, but I'm not sure why this would be causing an issue because the only integration involves wrapping some HTML around the header/footer and user system integration. It would have no affect on the HTML/CSS or even Javascript output on the page.

All I'm asking is for someone to take a look at it please...could be a quick fix with OverLib that I'm not aware of or something (because I'm not too familiar with OverLib).

[Gryphon]

Your icon is pointing to:
http://wow.allakhazam.com/templates/wow/images/icons/INV_Weapon_Bow_09.png

The actual icon is at:
http://wow.allakhazam.com/images/icons/INV_Weapon_Bow_09.png

Somehow /templates/wow is appearing in your url, do you have anything that is referencing that line?

[npregean]

Your icon is pointing to:
http://wow.allakhazam.com/templates/wow/images/icons/INV_Weapon_Bow_09.png

The actual icon is at:
http://wow.allakhazam.com/images/icons/INV_Weapon_Bow_09.png

Somehow /templates/wow is appearing in your url, do you have anything that is referencing that line?

Ah, thanks for looking into this for me and I'm glad you were able to find that. I have some replacement variables that are being set because of a customized WoW style for my forum. All "images/icons" text is being replaced with "templates/wow/images/icons" I think I can fix this by removing the replacement variable setting for "images/icons" and just put the files in that directory into the default "images/icons" folder.

You might want to take note that the style I'm using is a customized version of this WoW vB style:
https://vborg.vbsupport.ru/showthread.php?t=104614

So anyone who uses that style will have to modify the replacement variables in the same way that I do, and will have to move the files from "templates/wow/images/icons" into the default "images/icons" directory.

I'll let you know if my fix works.

Thanks again!

[npregean]

Actually I just checked it, and the default icons are the same as the icons for the style...so all that had to be done was to remove the "images/icons" replacement variable for my custom style, and it's all fixed. Thanks again for finding that for me, that was a HUGE help!

[aviendha]

hello i have installed your plugin, and first of all i want to congratulate you because the installation was so simple and plain.

I have one problem

If i make 28348en it works but i have the query in french. How i can get the querys in English?¿

[Gryphon]

I am not sure how the languages work. I have not tried to use them at all, I just provided them as they were in the Itemstats config. My usual method is to use Moonglade Cowl.

[shadowhaxor]

Maybe I missed it, but is there anyway to stop the item code form breaking if you reply to it?

Example, if you goto http://www.quietstormguild.com and make a item post. If you reply to it, t breaks and turns into a bad hyperlink :(

[Gryphon]

I imagine that you are using the WYSIWYG editor. That has some adverse effect on the code. I will attempt to fix this, but I am not sure how soon.

[aviendha]

the method Moonglade Cowl worked for mee too ^^
It did the query to thotbot instead of allakhazam

But i have another problem Moonglade Cowl still shows plain text here.
I have downloaded an icons package, but i don't know where is the string to reemplace the path.

Thankyou for your soon reply

[Gryphon]

You can have it query Alla with the gItemStats options, just make it the first option.

[itemico] I have not implemented, I didn't realize it was something different than [item] so I left it out of the code. They looked like they did the same thing and that [itemco] was just an alias for [item]. I will look into adding that.

[colicab-d]

the problem im having is that in Vb Adanced CMS when i posted item to the new sectio, They are fine in the original ofrum post, but when looked at via the news page (Vbacmps) they dont have there colour coding (i.e purple for epic) and dont diplay the item tooltip.

Just a white link to the item on thottbot

[shadowhaxor]

Guess there isn't update to the gitemstats when someone makes a reply and the item code gets turned into a highlighted mess :(

[Andaas]

Guess there isn't update to the gitemstats when someone makes a reply and the item code gets turned into a highlighted mess :(

Just explain to your forum users that they should not use the WYSIWYG editor when working with item links (or you can even disable it yourself ;) ).

[Gryphon]

Sorry, I have not looked into that issue at all yet.

[ixian]

I can't get this to work at all. With php errors on I get stuff like:

Failed to update item: Clever Hat (Table 'forums.gitemstats' doesn't exist)

Looks like it is looking for db tables that aren't there? I uploaded all the files to their correct locations and imported the product.

[ixian]

I fixed it, bit of a pain but I can't blame this on the modder here, it's the Itemstats code that has issues.

First, it didn't create the tables, which is because a function in itemstats.php is supposed to create them if they don't exist, but it doesn't specifiy InnoDB or myISAM for the table type - if you have a database that supports both this script will attempt to create it as InnoDB and the problem there unlike myISAM InnoDB doesn't support "fulltext" indexing of columns, which is what is specified for the last column (item_html). As a result the entire query fails, none of the tables are created, and you have issues.

I fixed this easily enough by creating the tables manually via the mySQL command line and specifying myISAM as the table type. Then the addon worked like a charm.

From there, I decided to merge this with another install of Itemstats I have running, for my Joomla CMS front end. Rather than have the forum version and the Joomla version use different databases and directories I ended up modding the Joomla version so that it worked off the forums. PM me if you want to know how or maybe I'll post it up here if there is enough interest.

Also, I don't seem to have the WYSIWYG problem? I can quote a post just fine and the item link remains the same. Is there something else I should be looking for?

[ixian]

the problem im having is that in Vb Adanced CMS when i posted item to the new sectio, They are fine in the original ofrum post, but when looked at via the news page (Vbacmps) they dont have there colour coding (i.e purple for epic) and dont diplay the item tooltip.

Just a white link to the item on thottbot

This means the javascript call is being pulled out of the header, or the plugin hook in this mod isn't inserting it in to Vbadvanced headers, which is more likely.

You can add it in manually at the end of your headinclude template and see if that fixes it. The code is:


<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>


You may need to adjust the above paths based on your settings/directories.

[clayjones]

The mod was working for me briefly, now all links are returning "This object doesn't exist or website is busy". Anyone else having this issue?

EDIT: I figured it out. I hate cpanel. It was running automated scripts to reconfigure my box, it added my box as a dns resolver (I'm running named to resolve my guild's domain). But I have recursion off, so the mod couldn't resolve allakhazam.com or any of the others. I fixed resolv.conf by removing my server, removed the empty entries in the gitemstatscache table, restarted apache, and it works now. Not mod related (although a server not found message would be nice :) ).

[spaceman33]

Hi.

I installed this but can only get it to work if I enclose the item tags with code tags.

Read through this topic but can't find anyone else having had a similar problem.

Any idea?

You should be able to see the post at http://www.hborea.us/forums/showthread.php?p=5599&posted=1#post5599

Thanks for any assistance.

[Finger78]

I have tried EVERYTHING i can think of to remove the link to itemstats.free.fr that pops up with the item window when you mouse over it, yes including turning the display item to false within the config_itemstats.php

Can anyone please tell me what I have to do to get this to go away?

I've even go so far as to try and remove every single link in all the php's etc within all the files I downloaded here and still nothing.

Any clues???

I went to the dev site for Iteomstats and downloaded and uploaded the newest version and again set the code to false and still no luck

[Gryphon]

There is an option to remove it in the vB options. And it will not be removed from cached tooltips, only new tooltips.

[Finger78]

ya thanks for that fixed it right up. TY

[nsaklas]

Hmmm - latest version of the mod works great for me with vbulletin alone, but my news feeder to my Vbadvanced CMS isn't picking up the items. Any advice? Not terribly sure which files I need to mod to get itemstats to work on my news posts...

[nsaklas]

NM -- figured it out, had to add some changes to the headerinclude file

[Kimimaru]

can you include this in the mod, http://forums.eqdkp.com/index.php?showtopic=9342&st=0

[Zaeolos]

I am having trouble getting the socket images to show up. Does anyone have any ideas for me?

[istvan]

would it be possible to make something in the plugin to reset the database / to force an update since some of the items change in patches the stats wont be correct i think

[nykshawn]

having some issues with this .. when i post a new thread, it takes me to a blank page. Also, when replying to a post containing the item code, it also takes me to a blank page. thoughts, anyone?

[Didzi]

can you include this in the mod http://forums.eqdkp.com/index.php?showtopic=9439

[matt2cacnio]

this looks like a good addon and good job with it. Just one problem. When I do [item]tags and post, that topic is giving me a white page with this error:

Fatal error: Class 'ParseAllakhazam' not found in /XXXXXXX/forum/includes/functions_gitemstats.php on line 200

It would show up on preview topic/post but if I dont use the addon (IE [item]) in the post, the post will be fine. Any way I can get this working Blackjack?

Thanks

[nykshawn]

this looks like a good addon and good job with it. Just one problem. When I do [item]tags and post, that topic is giving me a white page with this error:

Fatal error: Class 'ParseAllakhazam' not found in /XXXXXXX/forum/includes/functions_gitemstats.php on line 200

It would show up on preview topic/post but if I dont use the addon (IE [item]) in the post, the post will be fine. Any way I can get this working Blackjack?

Thanks

This is exactly the same issue I'm having. I'm running vbulletin 3.6.7

[KipLarson]

Will there be a fix for the problems that crop up when you try to edit a post with an item already in it?

I know you have it listed as a Known Issue, but just wondering if this will be fixed.

[The Fathom]

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO xzxplugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'gIS: Itemstats - AdminCP', 'admin_global', 'if (!defined(\'ITEMSTATS_LOADED\') && file_exists(DIR . \'/includes/functions_gitemstats.php\'))\r\n{\r\n require_once(DIR . \'/includes/functions_gitemstats.php\');\r\n}', 'gItemStats');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, July 17th 2007 @ 12:37:47 PM
Script : http://forum.xazax.com/admincp/plugin.php
Referrer : http://forum.xazax.com/admincp/plugin.php?do=productadd
IP Address : 80.127.223.56
Username : XXXXXXXXX
Classname : vb_database


Don't know what i am doing wrong :(

[Gryphon]

You are trying to install a mod for vBulletin version 3.6 on vBulletin 3.5.

Try this addon (https://vborg.vbsupport.ru/showthread.php?t=134603), it will allow you to install 3.6 mods on 3.5.

[The Fathom]

ok script runs now. but now i see this on top of my webpage

Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)
Failed to update item: Cape of the Brotherhood (Table 'xzxvbull.xzxgitemstats' doesn't exist)

[Gryphon]

Itemstats, code I did not write which is included in the mod, handles the creation of a cache table in the database. For some reason it is not creating the table, you will have to create it manually, the structure is found in itemstats/includes/itemcache.php

[The Fathom]

I realy have no idea how hahahha

[Deepdog009]

Gryphon great job with this one...

I have a minor update that uses the WOWHEADS feed, let me know if its worth doing?

Its another bbcode that uses less resources...

Keep the ball rolling...:up:

[Phr057]

I can't seem to get mine to either install correctly or work with vBadvanced. Anyone getting the same problem or know a fix?

[Noxious]

anyone know how to fix the enchants as i can't seem to get this mod to show any of the enchants using the [item] tags

[sweede]

Noxious: You can't add item enchants or socket data too itemstats codes. I'm sure that it may be possible, but currently it isnt (of course, i havent checked itemstats source in a long time).

Deepdog009 , care to share your changes? One thing that i did was instead of having a mouseover link (i.e. [itemname] ) , i changed it so that it pastes the HTML tooltip itself where ever you add the item bbcode ( )

[Deepdog009]

Noxious: You can't add item enchants or socket data too itemstats codes. I'm sure that it may be possible, but currently it isnt (of course, i havent checked itemstats source in a long time).

Deepdog009 , care to share your changes? One thing that i did was instead of having a mouseover link (i.e. [itemname] ) , i changed it so that it pastes the HTML tooltip itself where ever you add the item bbcode ( )

Hey Sweede,,,

Sure no prob,,,

I posted here because I had the code, but I didn't want 2 post unless its ok with Gryphon...

Its a little different than this mod so I was going 2 release as add-on...

Gryphon Mod is outstanding,,, show yo love and support it folks

N-E ways PM me and I will give U more info...

[Ciderhelm]

Any ideas on how to get this to work with the arcade? I'm getting the following error:

Fatal error: Cannot redeclare cleanhtml() (previously declared in .../public_html/forums/arcade.php:5292) in .../public_html/forums/includes/functions_gitemstats.php on line 742

[pewp]

deepdog i sent you a PM

i found that there is a wowhead mod made for the original itemstats code

http://forums.eqdkp.com/index.php?showtopic=9342

so if there is anyway to integrate this into it. i tried installing it the way they say, but it doesn't seem to work.

[Deepdog009]

deepdog i sent you a PM

i found that there is a wowhead mod made for the original itemstats code

http://forums.eqdkp.com/index.php?showtopic=9342

so if there is anyway to integrate this into it. i tried installing it the way they say, but it doesn't seem to work.

Yeap, It works like that one, but its not completely the same. It needs some improvements so Im sending it over 2 Gryphon so he can work his magic on it.

One problem is that I cant find the code on my computer. I will check again on the morrow...

When I find it I will send it...:eek:

[Breid125]

There's something strange in how VBull is parsing the information that it's passing to Itemstats.

My database has a number of entries that look like the following:
Gloves of the Fallen D efender
Gloves of the Fallen H ero

I've also noticed that when I click on the link to "Update" the item, the shortcut that it's giving me is including those spaces and such.

For example:
/vbull/itemstats/updateitem.php?item=Gloves%2Bof%2Bthe%2BFallen%2BD efender
/vbull/itemstats/updateitem.php?item=Pauldrons%2Bof%2Bthe%2BVanquis hed%2BDefender
vbull/itemstats/updateitem.php?item=Helm%2Bof%2Bthe%2BFallen%2BCha mpion

Any thoughts?

[manub]

I would really like to see the wowhead version :)

anyway thumbs up, great mod!

[maelfius]

I would love to see a couple changes to this mod.

1) Ability to assign a absolute path to the itemstats directory and/or xmlcache directory. I use VBadvanced and do not have my forums in the same directory as my "entry" page. I had to do a minor edit to ensure everything loaded every time.

2) I'd like to see support for the [itemico] tag (shows the item icon vs. the text [Epix Item blah] in the post).

Other than that, this is pretty slick not needing to edit the files directly to get it working.

Last thing, the view_cache, clear_cache etc files need the config.php edited to match your vbulletin install (and gitemstats table) or you cannot perform the maintenance actions. Perhaps you might want to hook these into the VBulletin information as well with the next release (should be just hacking the config.php file).

Cheers!

[dangre]

Great mod man! Love it.

There`s only one thing i couldn`t work out.

The item links work perfectly except for one thing, the picture of the item itself doesn? t show up.

All i get is red X`s

[Caerydd]

To get it working with vba (which would be nice for my purposes, but at present the link to the thottbot item is fine) it needs the global variable entered in vba's config

I'm not entirely sure what the global variable for gitemstats would be.

It isn't gItemstats.

[manub]

I also need some info to get it work with vbAdvanced.

Can someone help me? :)

[Caerydd]

I'm going to do some experimenting tonight (although I'm a non-coder, so...um..) so I'll let you know if I get it to work.

[manub]

Thank you.

[troyani]

There is an option to remove it in the vB options. And it will not be removed from cached tooltips, only new tooltips.
Could you give me a hint where to disable the "itemstats.free.fr" link in the tooltip? Couldn't find anything.
Really great Addon, thanks for his!

[manub]

No news for getting it to work in homepage with vbAdvanced?

[pestilence]

same it works on my forums but on my vbadvanced homepage it causes an error

[jluerken]

Hi Gryphon, thanks for this mod, its working fine for me except one thing.

Itemstats is not showing the socket images, instead its showing the text like YELLOW SOCKET.

Any Idea how to fix this?

[MaxBentum13]

Hi all,

I'm having the same problem with the socket images not showing up. In the admincp I changed the Allakhazam Socket Image Path but the spit out HTML stays the same, whatever I fill in there.

Generated HTML
<span class=\'esock\'><img src=\'/images/redsocket.png\' alt=\'red\' />&nbs

I have the images local stored in right path: http://www.instance51.com/instance51/images/redsocket.png

URL (http://www.instance51.com/instance51/) of my forum.

Hope someonce can help me out here.

Greets

[MaxBentum13]

I found out that in the table "gitemstats" in field "item_html" the path to the images is wrong.

Example:
<span class='esock'><img src='/images/redsocket.png' alt='red' />& ........cut

When I change this manually with phpmyadmin to:
<span class='esock'><img src='images/redsocket.png' alt='red' />& ........cut

it does work. It seems that change the path in admincp doesn't seems to affect any. I deleted the record, filled the field with some bullshit but the same HTML is generated. I even changed the function_gitemstats.php but also that doesn''t seems to affect the generated html. Anyone?

Greets

[HunterZ]

Is it possible to disable or alter the item link coloring? My forum's default style/theme has a light background and you can't see the white text used for common quality items.

Edit: My forum just choked on an incorrect tag formation. I want to post details but I don't want it to be used as an exploit to cripple forums.

Also, the itemico tag doesn't seem to work - I guess it's not supported?

Lastly, I would also like to see wowhead support.

[Gryphon]

Is it possible to disable or alter the item link coloring? My forum's default style/theme has a light background and you can't see the white text used for common quality items.

Edit: My forum just choked on an incorrect tag formation. I want to post details but I don't want it to be used as an exploit to cripple forums.

Also, the itemico tag doesn't seem to work - I guess it's not supported?

Lastly, I would also like to see wowhead support.

To edit the colors, edit the css. Itemico is not currently supported in the mod.

I am currently working on re-writing this mod from the ground up and it will probably support wowhead (bleh) linking.

[Elbulus]

I am currently working on re-writing this mod from the ground up and it will probably support wowhead (bleh) linking.

Havent got a clue why but today one of our members made a post that linked a load of pots etc and not one of them is showing corretcly and now nothing is linking :(

Heres a link to the post :http://www.soulbound.info/Forum/showthread.php?p=625

I've uninstalled and deleted all the files associated with itemlink and reinstalled tryed again and still not getting any links for the items it's just showing a link to query it..

Any ideas ?


Also any ETA on the new version :p

[Cloudrunner]

He edited the post...

With WYSIWYG editor this does not cooperate if you edit the post. He'll need to redo the <something? when editing it again...

[Elbulus]

He edited the post...

With WYSIWYG editor this does not cooperate if you edit the post. He'll need to redo the <something? when editing it again...

See thats the odd thing when you goto edit there still in the >NAME< Format...They just don't seem to be pulling the data when clicked :/ Have turned off the WYSIWYG editor now just trying to sort out why it aint pulling the data

[christofer]

any update on getting this working with vBadvanced?

[jluerken]

Hi Gpryhon,

if you have ipbArcade installed and activate your product, the Arcade stops working.

Error message:
Fatal error: Cannot redeclare cleanhtml() (previously declared in /arcade.php:5415) in /includes/functions_gitemstats.php on line 742

If I disable your product the Arcade is working fine again. Can you please check this?

[Gryphon]

Hmm, I ran into that issue myself, thought I had fixed that in the release. Uploaded a fix.

[jluerken]

Hi Gryphon,

thanks for the fast update. I did not had much time to check it but the error message is gone now. THANKS!

[Marcellus]

I haven't installed this particular mod yet, but the way I fixed the WYSIWG editor problem with other itemstat mods was by making a quick and easy file edit in the class_bbcode_alt.php file.

Find:
var $unparsed_tags = array(

add under this line:

'item',

See if this fixes your WYSIWYG issues. :)

[Grimbone]

When I goto post mutiple items my page seems to hang at the posting screen. It works fine if I post 1 or 2 items but not when i post multiple.

I also get the following error sent to me via email after it hangs...

MySQL Error : MySQL server has gone away
Error Number : 2006

Any Idea on why this is happening?

[Ciderhelm]

Havent got a clue why but today one of our members made a post that linked a load of pots etc and not one of them is showing corretcly and now nothing is linking :(

Heres a link to the post :http://www.soulbound.info/Forum/showthread.php?p=625

I've uninstalled and deleted all the files associated with itemlink and reinstalled tryed again and still not getting any links for the items it's just showing a link to query it..

Any ideas ?


Also any ETA on the new version :p

This issue cropped right up on our forums too. It has nothing to do w/ the WYSIWYG editor. Am still looking for a fix.

[yukonjak21]

I am a total nub with vBulletin. I am trying to install this mod and it doesn't seem to work for me. I downloaded the new one (gItemStats v1.03), uploaded it to my site, and installed it via AdminCP. When I got to test it on a new forum thread (<item>Emerald Ripper</item>) it doesn't work. I don't get an error just exactly what i typed (<item>Emerald Riper</item). Did i miss a step or 2? Based on the instrucitons, i didn't have to edit/modify any files. Please help!

[Elbulus]

I am a total nub with vBulletin. I am trying to install this mod and it doesn't seem to work for me. I downloaded the new one (gItemStats v1.03), uploaded it to my site, and installed it via AdminCP. When I got to test it on a new forum thread (<item>Emerald Ripper</item>) it doesn't work. I don't get an error just exactly what i typed (<item>Emerald Riper</item). Did i miss a step or 2? Based on the instrucitons, i didn't have to edit/modify any files. Please help!

It's not <ITEM> NAME </ITEM>

It's NAME

[Robbeh]

Please forgive my apparant newbness, I'm having a slight issue.

I've installed the mod but whenever I do item name it links to http://www.mywebsite.net/forum/itemstats/updateitem.php?item=item name

Where can I set the default site used to look up the item (I'd like to use wowhead...)?

Many thanks for your help.

[Newfarm]

Works very well for me, just jumping on the bandwagon for wanting wowhead support ;)

[Newfarm]

Wowhead.com has now made a .js that'll do most of the work, I'm pondering how one could potentially integrate these two. Wowheads version requires the users to input either a link to the item or the itemid trough the vbb implementation one of their users posted on the forums.

However, mixing this hack with the .js might just solve that as the .js from wowhead generates the correct tooltip (which looks a tad smoother then the one from this hack, rounded corners and everything ;p) and doesn't really need an itemcache.

Being able to just do Perdition's Blade and having that trigger the .js would be downright cool :).

[Robbeh]

Please forgive my apparant newbness, I'm having a slight issue.

I've installed the mod but whenever I do item name it links to http://www.mywebsite.net/forum/itemstats/updateitem.php?item=item name

Where can I set the default site used to look up the item (I'd like to use wowhead...)?

Many thanks for your help.

I still can't get this to work, infact it's getting worse, I've now noticed that it's not possible to start new threads, everyone gets "This page cannot be displayed" whenever the mod is enabled and anyone tries to click "New thread".

:(

[Newfarm]

Allmost sounds as if your whole forum is sat up a bit weird, what's the url of it ?

(note that I don't actually have anything to do with this mod, I've just done my own fair share of mistakes in config :p)

[DDolphins]

I'm having a similar problem on my site now too. As listed above when the item is linked its a basic link color with the url

http://www.battlegroundwarriors.com/itemstats/updateitem.php?item=Spellfire+Robe

This is happening with just about any item now originally I was able to use itemstats and everything was running fine but now it just spits back that url.

Any suggestions?

[Robbeh]

Allmost sounds as if your whole forum is sat up a bit weird, what's the url of it ?

(note that I don't actually have anything to do with this mod, I've just done my own fair share of mistakes in config :p)

www.visual-waste.net/caution

It's rather odd, I've found that everything works fine unless they're an [item] tag somewhere in the thread.

If there is an [item] tag then the following things occur:

1. Trying to post a quick reply fails and gives the error "The following error has occured:"

Useful huh...

2. Clicking "Post reply" or "Go advanced" spits out a "Page cannot be displayed" error.

If I remove the mod then everything's fine, quite odd :(

[manub]

Waiting for wowhead support, lots of items like the Black Temple / Mount Hyjal gems can't be linked that way :(

[jaykresge]

Well, someone got WoWhead support working with Itemstats. Please keep in mind, this is Itemstats, not the gItemStats mod on this page. I have not yet tried this. I want to see if Gryphon plans to integrate this into a gItemStats update.

http://forums.eqdkp.com/index.php?showtopic=9342

[Gryphon]

I do not plan on making any modifications to this mod any time soon, with tooltip tools available from Thottbot (http://thottbot.com/x/power) and Wowhead (http://www.wowhead.com/?powered) it makes this mod severe overkill (not that it wasn't before the tools became available). I have barely started rewriting the mod from the ground up which will trim out much of the fat and bugs.

[Newfarm]

Actually, I don't agree with this mod's function being surplussed; it might be more then what's needed now, but for all intents and purposes it's far, far faster and more user friendly to use Stoppable Force then Stoppable force.

That alone is priceless.

[Gryphon]

That is what I will provide again in the next version, however you do not need 50 files and slow page scraping to do it as the current Itemstats method uses, it can be hugely simplified and faster and with less bugs.

[Newfarm]

Oh yeah, I see that ;). As I posted earlier, I imagine all that's needed is for the updateitem script to pull the itemid off wowhead, store that in it's database for future use (as in, just the item_id field allready in the database), let wowhead's JS do, well, all the work while having the local script automagically generate the correct urls for the JS to parse ;).

Unfortunately it's just a whee bit outside my reach when it comes to modifying code so I can't really be of any help.

Just know that your efforts are valued by a lot of people and is well worth pursuing :).

[rstan]

Worked fine for me up until last night when I upgraded to 1.03 from 1.02. Random items are not being found. Some have even went to not found that were already in the cache.

Fire-Cord of the Magus....not found
Bark-Gloves of Ancient Wisdom.....not found

Chestguard of the Vanquished Champion....updated to not not found when already in cache
i remember now i could only get tier items to show by using ala only...but now when i select ala only it cant find anything...hmmm
vb 3.6.8

[rstan]

ok there is a new ala file that is not included in this latest release...

/itemstats/includes/allakhazam.php

get from itemstats site

[sweede]

That is what I will provide again in the next version, however you do not need 50 files and slow page scraping to do it as the current Itemstats method uses, it can be hugely simplified and faster and with less bugs.


I don't know how you missed it, but the package you install and upload doesnt require most of the php code from the /itemstats/ folder. Only the templates, some of the include files, js and css files.

I have already re-written the gItemStats to be far more "lean" to use than what is downloaded currently. I could probably get rid of a few more files if i had to and make them part of the functions_gitemstats.php file or even a vbulletin plugin.

Also, using the wowhead provided .js in your website doesnt let you cache the item code to your server making repeat visits MUCH MUCH faster.

(g)ItemStats isnt going to be replaced by any means.

[sweede]

Oh yeah, I see that ;). As I posted earlier, I imagine all that's needed is for the updateitem script to pull the itemid off wowhead, store that in it's database for future use (as in, just the item_id field allready in the database), let wowhead's JS do, well, all the work while having the local script automagically generate the correct urls for the JS to parse ;).

Unfortunately it's just a whee bit outside my reach when it comes to modifying code so I can't really be of any help.

Just know that your efforts are valued by a lot of people and is well worth pursuing :).


i could probably whip this up in like, 20 minutes...

it'll give me something to do tomorrow for sure.

[sweede]

I have the parser working as it should be,
http://dramaloot.com/test2.php
what happens is you do the normal whatever , and it goes off to grab the xml from wowhead (it needs to get the item id). after parsing the XML, it writes a URL link in the proper format
<a class="q4" href="http://www.wowhead.com/?item=32239">[Slippers of the Seacaller]</a>

So now, I need to implement caching, because having to hit wowhead each page refresh is pretty inefficent.

I don't think i'll be able to have the entire thing as a plugin w/no external files to upload, but i dont think that will be a problem.

The cache will use the existing gItemStats tables because it stores the two things you need, the item id and the item name.

[Newfarm]

Awesome, that's really, really cool! Keep it up :)

[sweede]

My own release.
While i could be a jerk and post as my own plugin, i wouldnt have made this if it wasnt for Gryphon anyways.

This replaced gItemStats mod all together

install the attached XML file

then un-install the gItemStats

after that, you can delete the itemstats folder and the /includes/functions_gitemstats.php file

My plugin creates a new database table and copies the needed data (item name, item id and item quality) from your existing gitemstats table.

I don't see it being a challege to modify it so that it would either use thottbot or wowhead, but i prefer wowhead so i'm not changing it :)

actually, hold on a few. i used to use the itemstats_parse() function in other areas, so im going to replace that in my addon.

[sweede]

Since the main functions load up in global_start , you can use itemstats_parse("item name"); in things like custom pages and VBAdvanced modules.

I already had two custom modules written that used the gItemStats method itemstats_parse("Guild Tabard");

so i adapted it to work with that also.

[Gryphon]

My originial intention with gItemStats was just make ItemStats a simple upload and configure via vB options.

It appears you are doing exactly what I am working on for my revamp of the code. I never suggested there would be no caching.

*Edit, posted while I was posting. Any reason you include xml parser code when vBulletin already has it's own class?

[Ninok]

Since the main functions load up in global_start , you can use itemstats_parse("item name"); in things like custom pages and VBAdvanced modules.

I already had two custom modules written that used the gItemStats method itemstats_parse("Guild Tabard");

so i adapted it to work with that also.

I imported this into my board and it works, but for some reason the "A class=q4" is no where to be found. So the links are showing up incorrectly. I will wait for Gryphon to release his update and see if he allows wowhead and whatnot.

[sweede]

go to any page in your browser and view source

Look for


<!-- WoWHead Mouseover-Tooltips -->
<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript"></script>
<!-- /WoWHead Mouseover-Tooltips -->

somewhere in your header (the template is wowhead_headerinclude)

[Ninok]

go to any page in your browser and view source

Look for


<!-- WoWHead Mouseover-Tooltips -->
<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript"></script>
<!-- /WoWHead Mouseover-Tooltips -->

somewhere in your header (the template is wowhead_headerinclude)

I looked for sometype of include, and it didn't exist.
I had to manually add that line to the header of the style, and now it works. With is was Bold like iteam stats though. That really made it stand out against darkers styles.

[sweede]

odd.

create a new template named
wowhead_headerinclude

put the
<!-- WoWHead Mouseover-Tooltips -->
<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript"></script>
<!-- /WoWHead Mouseover-Tooltips --> in it and that should fix it.

[Gryphon]

You didn't include any templates in your product, that is why it is missing.

[sweede]

You didn't include any templates in your product, that is why it is missing.

It's weird, i can't seem to export a product with the template.

i updated the product (and added the template ;) ) and included an option to make the item link text BOLD (via style tag).

however, i run into a problem when trying to update the post cache.
says it can't find the handle_bbcode function that i create in global_start. based on this, i don't think i can make the whole package a single XML file and we may have to upload a functions_wowitemstats.php file and include that in both bbcode_create and global_start.

[sweede]

*Edit, posted while I was posting. Any reason you include xml parser code when vBulletin already has it's own class?

Because i'm just starting out dealing with vbb hacking/plugins, etc.

dang, the vbb xml class is hot.

i'll have yet another update here shortly.

[sweede]

Sorry Gryphon, i didn't feel right spamming your thread with my updates,

https://vborg.vbsupport.ru/showthread.php?t=163987

[pjfry]

Hi,

first thnks a lot for this nice mod. But I have a little Problem. On my Site i have installed this mod but it works only correctly wen t write French Item Name. When I write the English or German Name i get only a grey Item with the folloing tooltip:

The Object don't exist, or website is busy. Click to search again.

Wenn I write 18822de and then the German Item Name in a new Post Hammer des wirbelnden Nethers it works fine. The 18822 is the Item ID.

Can anyone help me?

I'm sorry for my not perfect english, but I hope you can understand my Problem! ;)

Greetings

Fry

[HunterZ]

I'm thinking of having one installation of ItemStats that feeds both my EQdkp installation and my vBulletin installation (currently I have separate installations integrated into each as plugins, the vBulletin one being this gItemStats plugin). Should I dump this gItemStats plugin and start with ItemStats directly to accomplish this, or is there a better way to transition?

I see that ItemStats has a module for vBulletin - does it work fine with 3.6.8?

[jluerken]

Hi,

first thnks a lot for this nice mod. But I have a little Problem. On my Site i have installed this mod but it works only correctly wen t write French Item Name. When I write the English or German Name i get only a grey Item with the folloing tooltip:


I have the same issue here.
When I enter "18822de" it is working fine. When I enter Itemname_in_German I only get a grey item link.

Can you please check this Gryphon?

[joergh]

I have the same problem, would be great if you could help us Gryphon.

Thank you very much

joergh

[dblclick]

IM not sure if there is still any support for this...but here is my problem

When tooltip pops up i get a "object doesnt exist or web site is busy error"

example:

http://www.athesisguild.com/forum/showthread.php?t=24

anyideas?

Thanks

[acrine]

Just wanted to say thanks for this MoD. I've been fighting with other similar mods for a week and this worked for me out of the box.

THANK YOU!!!

[Maniac199]

Hmm, i got the mod installed fine and it appears to be working but whenever i put an item in it just says the item does not exist. Also the item is entered correctly!. Any ideas?

[jluerken]

Gryphon are you still supporting this product?
You give good support to your Teamspeak Product but this mod is marked as supported but people are waiting for an answer regarding several issues.
Do you have an idea how to fix them?

[Gryphon]

It is partially supported, my part of which there isn't much to support. I created this product as a configuration front for Yahourt's Itemstats and that configuration part of the product is what I support. Any problems with fetching data etc is caused by that script which is no longer supported by Yahourt.

However, I have written a replacement that, so far, eliminates all the uploaded files and is simply a product. It still needs optimization so I have not released it yet.

[Paradigm]

I have fixed the problem for the grey links. Find the config.php in your itemstats folder locate this
define('dbhost', 'localhost');
define('dbname', 'DBNAME');
define('dbuser', 'DBUSER');
define('dbpass', 'DBPASS');
define('item_cache_table', 'item_cache');


and add this

/*define('dbhost', 'localhost');
define('dbname', 'DBNAME');
define('dbuser', 'DBUSER');
define('dbpass', 'DBPASS');
define('item_cache_table', 'item_cache');*/

You are just commenting that code so it doesn't write over another php file that has your DBs username and password info in it.

It worked for me and I hope it works for others too!

[Masked Crusader]

The tags will be properly parsed in preview and when I'm redirected back to the post after submitting it. But on subsequent reloads of the page, the link will be not be parsed.

It seems to be a problem with the postcache or something.

[Cloudrunner]

Any progress on the new product Gryphon?

[pewp]

is there anyway to get the mouseover tool tip to be transparent? I had a version of the itemstats prior to upgrading to 3.6.9 that stopped wroking for some reason and it had transparent mouseovers.

[atomhead]

why is itemstats included if there's 'no file modification necessary'? do i still have to configure itemstats? because this isn't working otherwise.

[tuaguild]

gryphon there is a wowhead mod for itemstats take a look at http://forums.eqdkp.com/index.php?showtopic=9342 i have used it before but i dont know how to make it work with your addon

I tried looking at your code for functions_gitemstats.php and i couldnt find a way to insert all the information needed for parsing wowhead. I think someone will be able to do this and i like Itemstats as opposed to Sweede's addon due to flexibility. It is just a matter of adding the extra wowhead code for the parsing. Anyone have any ideas?

Well Guys i did it i got a working version of this parsing wowhead for the tooltips. I will post a version of it if it is allowed by gryphon but i will not do so until oked by him or i will send him the entire package to post. In this version you just have to type the name like Warglaive of Azzinoth and the mouseover will show up

[tuaguild]

Hello guys. I wanted everyone to know that i do have a RELEASEABLE VERSION of gItemstats with WoWHead item caching. I am going to be speaking with Gryphon about release options and weather i can release it myself or have him release it. Please be patient as i will be providing all the support for this addon
Lyco AKA TUAGuild

[GuaRRand]

i get a </span> behind every linked item, i dont see the image and it takes ages to load... as in 10-15 seconds for a page...

I like the idea, but it seems to be failing on my site..

Anything i need to updated/alter?

[tuaguild]

Also GuarRand I think you should uninstall the product delete all the files on the server and re upload it i had the same problem out of the original itemstats and it was due to decay of files in transfer

I havent recieved word from gryphon on my package but as soon as i hear something i will post it up.

[tuaguild]

New Version
Please see this post for new version with WoWHead Support
Also i am doing all support for gItemstats If you have a problem with your gItemstats installation please update to the new version and post support questions there.
https://vborg.vbsupport.ru/showthread.php?t=182100