Add-On Releases - World of Warcraft Wowhead Item tooltips for vBulletin

** Discontinued thread !
See https://vborg.vbsupport.ru/showthread.php?t=239911 for current thread in 3.8 modification areas.

[OblivionMage]

Does using <item=(ID)></item> make it any more efficient?

[retrofade]

any solutions for those of us who are running older versions of PHP?

Nevermind, just read the stupid "upgrade" comment from the developer.

[sweede]

Originally Posted by OblivionMage

Does using <item=(ID)></item> make it any more efficient?

I beleive that right now it still looks up the name from wowhead.

if you did

[item=12345]Item Name[/item] , it should bypass the http get.

What i have done in the past on my own server is download a list of item id -> item name from wowhead.com itself. I can do that again at regular intervals and have those available. That will prevent the http get completly.

[Noxious]

just an idea, but could you add something like [spell] tags so it does the same thing with spells as it does with items?

[smokejax]

removed - just noticed the post above mine..

^^^ SEE ABOVE ^^^

[OblivionMage]

It seems to load all of the links on loading the page.

If you go to, say:
http://www.wowguideonline.com/inscription.html
(This is just an example)
It seems to load the item tooltips once you hover over the items, rather then do it all in advance, although I suppose this could be achived with adding the item id / link.

just an idea, but could you add something like [spell] tags so it does the same thing with spells as it does with items?

WoWHead doesn't have spell tags, but if you link the text to the URL of the spell, it should come up as a tooltip (for example: http://guidewiki.com/forums/world-wa...ide-wotlk.html). If you want it to look just like an item link, just add font/color tags inside of the URL tag.

[sweede]

Originally Posted by OblivionMage

It seems to load all of the links on loading the page.

If you go to, say:
http://www.wowguideonline.com/inscription.html
(This is just an example)
It seems to load the item tooltips once you hover over the items, rather then do it all in advance, although I suppose this could be achived with adding the item id / link.


WoWHead doesn't have spell tags, but if you link the text to the URL of the spell, it should come up as a tooltip (for example: http://guidewiki.com/forums/world-wa...ide-wotlk.html). If you want it to look just like an item link, just add font/color tags inside of the URL tag.

The tooltip display and information is pulled from wowhead servers in real time. the only overhead it adds to your rendered page is changing Runic Mana Potion to <a href="wowheadlink" style=whatever>runic mana potion</a>

Wowhead supports spell tooltips, the problem is that it doesnt have XML data of the spell so you would have to know the spell ID. it would be easy to do [spell]133[/spell] and have that turn into a link for wowhead (Mage fireball Rank 1) , but i don't expect everyone to know the spell ID of every spell , nor do i want to create some type of database of information linking spell names with spell IDs (since many spell IDs could have the same name).

[smokejax]

Isn't this the xml feed information?
http://www.wowhead.com/?powered

[HolyKiller]

I'm using this MOD on my forum, but if user use a LOT of [item] tags (one of my user wrote a nice Druid guide and use 33 tags in one post), the page get loading TOOOO SLOOOOOOOOW (more than 30sec).

What's wrong? I thing, if the items are cached in my DB, the mod should never connect to wowhead again due to collecting information about items, right? Because they are already cached in DB.

BTW: After 14 days my item_cache table have about 12MB

Forum is hosted on professional hosting company with excelent servers. Database is really fast and some friend using the same hosting for so HUGE database with HIGH BW and the don't have problems like i have.

So, any ideas what's wrong?

OR

Is there any way to integrate some function for LIMINT numbers of [item] TAGs in one post?

Thanks a lot for help

Holy

[sweede]

Originally Posted by HolyKiller

I'm using this MOD on my forum, but if user use a LOT of [item] tags (one of my user wrote a nice Druid guide and use 33 tags in one post), the page get loading TOOOO SLOOOOOOOOW (more than 30sec).

What's wrong? I thing, if the items are cached in my DB, the mod should never connect to wowhead again due to collecting information about items, right? Because they are already cached in DB.

BTW: After 14 days my item_cache table have about 12MB

Forum is hosted on professional hosting company with excelent servers. Database is really fast and some friend using the same hosting for so HUGE database with HIGH BW and the don't have problems like i have.


So, any ideas what's wrong?

OR

Is there any way to integrate some function for LIMINT numbers of [item] TAGs in one post?


Thanks a lot for help

Holy

I've explained in this thread what happens.

when you first make a post with an item that hasnt been seen before, the product will have to hit wowhead.com for each item and the new item info (mainly the itemid).

After which, it performs a rather quick and light query to get the itemid.

typically, the post with an item that isnt seen yet will take a few seconds longer because of the wowhead query (which i need to capture and gracefully exit in case of a timeout).

After which, responses will be far faster.

For example this page.
http://underthemain.net/forums/showthread.php?t=12

No items in the table and the initial post
* Page Generation 1.21796 seconds
* Memory Usage 5,730KB
* Queries Executed 145 (?)

going back to the main forums then clicking on the post i just made.
* Page Generation 0.51620 seconds
* Memory Usage 5,032KB
* Queries Executed 11 (?)


When vbulletin updates the post cache, it re-queries the database for the items but it wont (shouldnt) hit wowhead.com again, since the only thing i need is the itemID.

One thing that it does do though that I will have to remove, is that it also gets the translations from wowhead.com