gItemStats - World of Warcraft Itemstats
 

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

See this thread for the continuation of this modification.

Check out my iGoogle homepage gadget for World of Warcraft item database searching.
https://vborg.vbsupport.ru/

Thank you very much!

I like the new Itemsstats with socket support :)

*thumbs up*

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

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.

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 [item] My Item[/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:
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!

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.

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

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!

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.

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

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

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

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:

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

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.

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:

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.

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.

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!

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

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

Blackjack, I owe you a beer bud.

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. :)

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.

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

yep yep, that would correct

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

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.

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!

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.

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

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!

This sort of works for me.

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

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.

This is what happens: Someone post a long list of [item][/item], 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.

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

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

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

*Installs*

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

best addon :)

big thanks works great!

But [itemico]....[/itemico] do not work!

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

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

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.

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.