vb.org Archive - Add-On Releases - gItemStats

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Add-On Releases - gItemStats - World of Warcraft Itemstats (https://vborg.vbsupport.ru/showthread.php?t=141177)

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:

Quote:

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!

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

Quote:

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!

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

Code:

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

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01272 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: