World of Warcraft Wowhead Item tooltips for vBulletin

[sweede]

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

[sweede]

0.5.4 has been uploaded.

I noticed today on my test site that if you have existing posts with [item] tags then switch the language setting in the options and you run some of the Update Counter utilities, it clobbers the existing item tags.

That's been fixed as it tries now to do several things before giving up.

[KURTZ]

--cut--

nevermind i'm idiot :D

however just a question Sweede, i read the installation file, it says that we only need to import the product, so what about the upload folder? also what about the template edits that you put into hack's description?

thx

[Kinneas]

Great work sweede :) - I'll install shortly.

[Kinneas]

When trying to overwrite the old version or install the new version from scratch I receive the following:

Database error in vBulletin 3.7.1:

Invalid SQL:
DROP TABLE wowitemstats;

MySQL Error : Unknown table 'wowitemstats'

[KURTZ]

When trying to overwrite the old version or install the new version from scratch I receive the following:

try to uninstall the previous version then install the new ... :)

[Kinneas]

try to uninstall the previous version then install the new ... :)
I did. Same error.

[KURTZ]

I did. Same error.

just tried onto a test board this is the result:

Database error in vBulletin 3.7.1:

Invalid SQL:
DROP TABLE wowitemstats;

MySQL Error : Unknown table 'wowitemstats'
Error Number : 1051
Request Date : Friday, June 20th 2008 @ 12:02:58 PM
Error Date : Friday, June 20th 2008 @ 12:02:59 PM
Script : http://www.fniv.it/xxxx/admincp/plugin.php?do=productimport
Referrer : http://www.fniv.it/xxxx/admincp/plugin.php?do=productadd
IP Address : xxx.xxxx.xxxx
Username : admin
Classname : vB_Database
MySQL Version : 5.0.51a

[Kinneas]

I created that table just to see if that would satisfy the install script, but it still gives the same error (Even though it does drop the table).

[Kinneas]

I bypassed the problematic part of the Install script by removing the DROP TABLE line from the install code, but it still doesn't seem to work. The following plugin for bbcode_create seems to be incomplete:

<plugin active="1" executionorder="5">
<title></title>
<hookname>bbcode_create</hookname>
<phpcode />
</plugin>

[KURTZ]

Steve, we need a fix by Sweede :)

[Kinneas]

Well I had a few attempts at fixing it but haven't been able to fully. Guess we'll have to wait for Mr. Sweede :P

[Kinneas]

For the time being I've had to go back to the older version.

Some problems I found with this current version:

The Install Script seems broken. The DB error I mentioned earlier in the thread seems to stem from these lines:
<code version="0.5.0">
<installcode><![CDATA[$db->hide_errors();
$db->query_write("DROP TABLE ". TABLE_PREFIX . "wowitemstats");
$db->show_errors();]]></installcode> <uninstallcode />
</code>


I'm guessing that just shouldn't be there full stop, as directly below it there's another, longer 0.5.0 install code which also contains the DROP TABLE line.

The bbcode plugin is incomplete, which resulted in no parsing whatsoever. In the product XML it looks like this:
<plugin active="1" executionorder="5">
<title></title>
<hookname>bbcode_create</hookname>
<phpcode />
</plugin>


I think I was able to get past these two problems (Firstly by removing the naughty install code and secondly by using the code from the 0.4.5 plugin in the above), but unfortunately I was still having issues.

Although the items bolded and hyperlinked to the wowhead site, no mouseover popup showed and they didn't change color based on item quality, they were just all bold black.

Also, after installing, the links default to Spanish Wowhead (es.wowhead), which I suppose could have been by design, but then if you go to the Product Settings in ACP the language defaulted is english. Simply clicking save (without changing anything) will then set it to English.

I'm not sure how long these problems would take to fix but it might be worth re-uploading the old version in the meantime Sweede.

[sweede]

:o !

uploaded the previous version, will have a new version up soon.

[Caerydd]

Please don't worry about the crafting database :) If you're busy you're busy, and we're in no hurry. Thank you for continuing the work on this fabulous addon ^^

[AndyBaines]

Installed and seems to be working fine, thankyou. :)

[mikeylikesitz]

doesnt seem to be pulling the rollovers, it shows the item color though

edit: i want to mention that the links made before the update are still working, just not the new links

[sweede]

1) Make sure that Options -> Wowhead Item Stats -> Local power.js is set to No
2) View source of any of your forums web pages, make sure that the line
<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript" defer="defer"></script> is in the first few lines (within 10 lines)

If that isn't there, go to Plugins & Products -> Plugin Manager and find the plugin named 'WoWhead template Cache' and make sure that cache_templates is correct (if it isnt, hit edit and select it from the list).

[mikeylikesitz]

sorry, it must be a permission thing, i tried it in my admin forum and got nothing, tried it in the wow forum and it worked fine so all is well

thanks for the update

[sweede]

thats odd.. it shouldnt make a difference. In fact the tooltips should work on any vbulletin page...

[mikeylikesitz]

not sure, it is still that way if you would like to take a look, if not no biggie

[KURTZ]

Sweede, just uploaded and installed your add-on ... unfortunately it doesn't works ... :( it shows only the BBCode button and the tags [item], but nothing, no colors, nothing ...

if you need t to check-out somethings i can give you an admin account onto my test board ... ;)

edit. instead, the 0.5.1 version runs properly .... also the 0.5.1 runs with the 0.5.2 files so i think there is an issue in the .xml

[sweede]

Sweede, just uploaded and installed your add-on ... unfortunately it doesn't works ... :( it shows only the BBCode button and the tags [item], but nothing, no colors, nothing ...

if you need t to check-out somethings i can give you an admin account onto my test board ... ;)

edit. instead, the 0.5.1 version runs properly .... also the 0.5.1 runs with the 0.5.2 files so i think there is an issue in the .xml


Ok, fixed with 0.5.3

I use another product that allows me to store plugins on my local drive and edit them with a normal PHP Editor as php files. When i "Export" a product, it reads these php files and creates the XML file accordingly.

If there are any additional space after the closing ?> tag (or it is missing), it doesnt include that plugin, which has happened several times so far :)

[KURTZ]

OK it seems to be correct now ... edit: nvm it runs :P

[KURTZ]

upgraded to 5.4, just found a small issue :) i've settled into ACP 'disable underline' but the old tooltips are still underlined ... :)

[Luxus]

nice new version...
do you plan to support more then 1 language?
to post in german
use http://de.wowhead.com/?item=29434
for default lang 29434

[sweede]

nice new version...
do you plan to support more then 1 language?
to post in german
use http://de.wowhead.com/?item=29434
for default lang 29434

Yes, but not until i can figure out how to get a non-english name via URL

for example.

http://www.wowhead.com/?item=Netherwind+Pants&xml works as you would expect.

In french though,
http://fr.wowhead.com/?item=16915
it is
Pantalon de vent du N?ant

which if you put that in the URL, doesnt work
http://fr.wowhead.com/?item=Pantalon+de+vent+du+N?ant&xml

if you change the ? to e
http://fr.wowhead.com/?item=Pantalon+de+vent+du+Neant&xml

it works as expected

Now the problem is translating the ? to e and the other hundreds of characters automatically. While i can build a translation map, that doesnt appear to be the most robust solution right now.

Also, there are some characters in languages that i can't figure out the correct character to use (for example, there is this funky B looking character in German).

I don't want to rely on users knowing the item ID every time, and I haven't added a way to specify locale to the item ID (i.e. Spanish Item so you can change the displayed language in the tooltip itself.

This though, is easy and i'll get that implemented further in the week (Along with pasting wowhead URLs supporting the same mechanic).

For example, if your board is set to use French by default and someone puts something like..

Abrazo de Alanna (item is in spanish)
Alanna's Embrace (Item would be in english)
or pasting
http://de.wowhead.com/?item=13314 (item would be in german) ,

all 3 of those would be in their appropriate language

[Danoxth]

Installed and runs perfectly :)

May I make a suggestion? Is it possible to get the following format to be accepted: [item=35497]

Reason I ask is that I use the RSS feed of a popular Warcraft site and they use that sort of formating so I'm currently having to go in manually edit each item code etc.

If it's possible it'd be great, if not, no worries, just more work for me :P

[sweede]

i don't know if you can do that in bbcode..

but, i'll look and see what i can do.

Whats the RSS feed so i can review and test ?

[Danoxth]

It's MMO Champions (http://www.mmo-champion.com/) feed, which you can find here (http://www.mmo-champion.com/index.php?type=rss;action=.xml;board=2.0;sa=news;)

Cheers for the quick response :)

[Deepdog009]

Super Beauts... :cool:

[pewp]

nevermind, reinstalled, works great. Thanks!

[tuaguild]

i still like mine lol but yours is pretty awesome there man

[Kinneas]

No problems seen so far on this version :) Thanks sweede!

[crombiecrunch]

any chance to get this to work with http://aoc.mmodb.com/ for age of conan?

[sweede]

It's MMO Champions (http://www.mmo-champion.com/) feed, which you can find here (http://www.mmo-champion.com/index.php?type=rss;action=.xml;board=2.0;sa=news;)

Cheers for the quick response :)


Yay for mmo-champ !

Create a new plugin
Product WoW Head ItemStats
Hook Location rssposter_parse_rss[b]

Title[B] Rss Test

Plugin PHP Code

$pattern = '/\/i';
$replacement = '[item]\\1';
$item['description'] = preg_replace($pattern, $replacement, $item['description']);

You might have to wait a while for mmo champ to post news with that tag in it.

it will change to [item]12345 , which should work out correctly

[sweede]

any chance to get this to work with http://aoc.mmodb.com/ for age of conan?

hmmmmmmmmmmmm

maybe, but not in this product

[KURTZ]

hmmmmmmmmmmmm

maybe, but not in this product

i need that! :p

[Dsru123]

worked great, but WoWhead JS script you have to add to headinclude in all styles you use was causing login error. After login you would get a blank screen untill you opened up same page in browser again. Been looking for a fix, but after some checking its the js script thats causing the login blank screen.

[tuaguild]

yeah try mine it is gitemstats with wowhead support

[sweede]

worked great, but WoWhead JS script you have to add to headinclude in all styles you use was causing login error. After login you would get a blank screen untill you opened up same page in browser again. Been looking for a fix, but after some checking its the js script thats causing the login blank screen.


what ?

your post makes absolutly no sense at all.

You should not have to edit any files, templates, anything, to use this product. you do not need to upload any files or change any configuration settings if you do not want to, its totally plug and play.

[tuaguild]

yeah he is right the javascript is there just to produce the tooltip

[Dsru123]

Yep, your right. I thought you had to do the WoWhead steps from there "vB how to" forum post, then instal your plugin. I was adding the Wowhead script to my styles headinclude, hence having the problem. After I reverted back to my orginal styles and just used your plugin, it works great.

I feel so cheap and used! I will go stand in corner now and review how read install instructions correctly!

[Slaxi]

thanks for this mod. Works fine.

[Asgorath]

I'm having some pretty bad performance problems since upgrading to the 3.7 version of this plugin. From looking at the SQL error messages as pages time out, it appears as if the caching isn't working or something.

This is a common error, for example:

Database error in vBulletin 3.7.2:



Invalid SQL:

INSERT INTO itemstat_cache

( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )

VALUES (

'32837',

'Warglaive of Azzinoth',

'5',

'INV\_Weapon\_Glave\_01',

'www',

'<table><tr><td><b class=\"q5\">Warglaive of Azzinoth</b><br />Binds when picked up<br />Unique<table width=\"100\%\"><tr><td>Main Hand</td><th>Sword</th></tr></table><table width=\"100\%\"><tr><td>214 - 398 Damage</td><th>Speed 2.80</th></tr></table>(109.3 damage per second)<br />+22 Agility<br />+29 Stamina<!--e--><br />Durability 125 / 125<br />Classes: Warrior, Rogue<br />Requires Level 70</td></tr></table><table><tr><td><span class=\"q2\">Equip: Improves hit rating by 21&nbsp;<small>(1.33\%&nbsp;@&nbsp;L70)</small>.</span><br /><span class=\"q2\">Equip: Increases attack power by 44.</span><br /><br /><span class=\"q\">The Twin Blades of Azzinoth (0/2)</span><div class=\"q0 indent\"><span><!--si32838-->Warglaive of Azzinoth</span><br /><span><!--si32837-->Warglaive of Azzinoth</span></div><br /><span class=\"q0\"><span>(2) Set: Your melee attacks have a chance to increase your haste rating by 450 for 10 sec.</span><br /><span>(2) Set: Increases attack power by 200 when fighting Demons.</span></span></td></tr></table>' );;



MySQL Error : MySQL server has gone away

The thing is, that particular item is definitely in the database (there's a link on the front page, and I've manually inspected the table to confirm), so I'm not sure why the plugin is trying to insert the data again.

Has anyone else experienced this? I've uninstalled and re-downloaded/reinstalled the plugin several times now, to no avail. Our website is here, for reference:

http://www.wastedepicsguild.com/

[Kinneas]

Sweede, just for clarification, is this mod supposed to run a query every time a page with these items on loads? Or is it supposed to be a one time query to populate a database table?

I only ask because I notice a significant delay when viewing one particular thread on my Guild forum where we list all the rare crafts our members have. The page can take up to a minute to load with 120+ queries being made. This happens every time the page is loaded.

[sweede]

What it does is the following..


Parse BBCode item tag
Query database for existing Item name or Item ID (depending on the bbcode tag, i.e.: Some Item will search by item name, Some Item will search by number.
If item is found
Return proper HTML replacement code
If item NOT found in database
Query wowhead.com/?item=Some+Item&xml
process XML and save quality information, complete Item name, raw XML data and item id.
Returns proper HTML replacement code


It does this for each item in the database. The only time you *should* have any "lag" in page view is when the post is first made and it has to query each item.

Of course, your posts should also be cached as already parsed templates, which the bbcode replacement wouldnt be done.

[Kinneas]

Edit:

Okay, well I just did a test. I emptied the itemstat_cache table and loaded the page again. The first time it took (understandably) a very long time to load, finishing with the following stats:

Page generated in 60.50909 seconds with 282 queries

Then I reloaded the page. It was quicker, but it still took a considerably longer amount of time with a lot of queries:

Page generated in 14.04858 seconds with 130 queries

Would you consider this normal behaviour?

[sweede]

Whoa.

Unless you're using ipowerweb (a friend of mine runs a guild site on this host and its horrible), that does seem a little long.

Is this a vbulletin thread/post or other ?

I wonder if there is a way i can code around this though...

If the page is a normal vbb post, the post is usually cached already processed. If the page isn't though, there is no caching done (for example, a custom vba bbcode page).

[Kinneas]

I'm not using ipowerweb. Other aspects of the forum load quickly and without issue.

It is a fairly standard vBulletin thread. Would you like me to PM you the current list in the thread for testing?

[Kinneas]

This is very odd. On a fresh install on my test board it does what it's supposed to do.

[Kinneas]

And it's all working okay on my Live site now. How bizarre lol.

I re-uploaded the files and reinstalled the product from scratch just in case, but the problem was still happening. For some reason it isn't anymore.

Sorry for wasting your time mate :P

[Asgorath]

Edit:

Okay, well I just did a test. I emptied the itemstat_cache table and loaded the page again. The first time it took (understandably) a very long time to load, finishing with the following stats:



Then I reloaded the page. It was quicker, but it still took a considerably longer amount of time with a lot of queries:



Would you consider this normal behaviour?

How are you generating those stats? I'd like to run some tests on my site as well.

[sweede]

you enable debugging mode.

add something like $config['misc']['debug'] = true; , i think.

there are also products that do close to the same thing.

[Asgorath]

Nevermind, this was a configuration error on my part. I'd disabled post caching to get the original ItemStats working (the one where you had to manually click on a link to fetch the item information), and had forgotten to re-enable it after switching to this plugin. Sorry for the confusion!

[LittleB@]

I just installed this and ran into problems while previewing/editing using advanced WYSIWYG editor, came back here to see if anyone had the same problem and noticed that this was supposed to be sorted in:

0.4.5
* Fixed issue with WYSIWYG editor loosing item links when editing a post

Any idea why I'm still getting this? :erm:

[Guest210212002]

Any chance of a php4 version of this?

[Cloudrunner]

So I uploaded the files, uploaded the product xml and fired it up.

What I ended up with when I tried to drop an something in a new thread is this:Fatal error: Class 'wowhead' not found in /home/jabouty/public_html/forums/includes/functions_wysiwyg.php(115) : eval()'d code on line 28Any thoughts?

I ran through the code and found a wowhead_item class, but not a wowhead class. So i changed the call for the new wowhead class in the Wowhead WYSIWYG parser plugin to wowhead_item and got the following:Fatal error: Call to undefined method wowhead_item::wowhead_http_get() in /home/jabouty/public_html/forums/includes/functions_wysiwyg.php(115) : eval()'d code on line 30 so obviously that doesn't work...Stuck now...but I'm probably just blind as to the fix.

edit: Interesting. If I copy paste from a previously linked code, ie copy paste a link off this: http://www.wowhead.com/?items=2.10#0-2-3+1 which alot of my users will do, and I get the crash error when using wysiwyg. Kill the wysiwyg formatting by removing the link and the coloring and it works. So copy pasting off a linked name causes issues. Thoughts from here?

edit2: perhaps cleaning anything within container of all links and formatting prior to parsing it will help...just a thought...

[sweede]

Any chance of a php4 version of this?

I hate to say this, because it's awefully.... a jackass of me, but PHP 5 was released more than 4 years ago. If your host hasnt updated or wont update you to php5 , it's time to get a new host.

[sweede]

What I ended up with when I tried to drop an something in a new thread is this:Fatal error: Class 'wowhead' not found in /home/jabouty/public_html/forums/includes/functions_wysiwyg.php(115) : eval()'d code on line 28Any thoughts?


you were right, change the line $o = new wowhead(); in the wysiwyg plugin to wowhead_item();

go down to the next line, change
$xmlfile = $o->wowhead_http_get($url, 8192);
to
$xmlfile = $o->getHTTP($url);


Also, to give a little background information. When I wrote the last update, i pretty much re-coded every line because I found a product release tool on the german vbb site. without going into to much detail, the test site that i dev on runs the exact same code that the XML product file contains.

However, why it works on my test server, I don't know, because it shouldnt. The wowhead class shouldnt exist on my test server.

The zip file has been updated (0.5.5 now)

[Cloudrunner]

Bingo!

Testing as we speak. If anyone can break it my users will find a way lol. Great job thus far.

[dlan]

Ok, so i tried to use a test item the Thunderfury. See what happens... the wowhead is psychic :P so it finds and returns the data even when you don't enter the complete correct item name. For example try 'Thunderfury' instead of 'Thunderfury, Blessed Blade of the Windseeker'.

But the initial select sql command you run to check if it's been cached doesn't work that way. It checks for the exact name, so it tries to re-cache it. BOOM error.

I'm probably wrong on the reason there is the error but something is wrong.



EDIT: For now i added a condition before saving the item that checks the name to be the exact. But look into it sweede. Great job!


Initial post:
Even though i see the item on the database it tries to add it again. Seems like the caching doesn't work for me.

I made 'id' the primary key because i only care about one language (english) and that should make things easier.

[sweede]

Ok, so i tried to use a test item the Thunderfury. See what happens... the wowhead is psychic :P so it finds and returns the data even when you don't enter the complete correct item name. For example try 'Thunderfury' instead of 'Thunderfury, Blessed Blade of the Windseeker'.

But the initial select sql command you run to check if it's been cached doesn't work that way. It checks for the exact name, so it tries to re-cache it. BOOM error.

I'm probably wrong on the reason there is the error but something is wrong.



EDIT: For now i added a condition before saving the item that checks the name to be the exact. But look into it sweede. Great job!


Initial post:
Even though i see the item on the database it tries to add it again. Seems like the caching doesn't work for me.

I made 'id' the primary key because i only care about one language (english) and that should make things easier.

Wowhead.com defaults to searching for an item when it can't find the name in the URL and returns the closest match, if any. Some items are so unique that you can pretty much shorthand them, such as the Thunderfury.

It may be possible to create something like a "also known as" field and do a quick look there also, but that may cause way more problems than it will solve.

i'll sleep on it and see if i cant think of a better method, or if anyone has one to suggest.

[maf1973]

Hi,
i installed the 0-5-5 Version ... unfortunately it doesn't works ...
It shows only the BBCode button and the tags [item], but after Post it shows only []

Any Ideas?

[sweede]

you need to tell me way more information than that..

the URL to the post, the item name you tried to use (i.e. My Item ) , etc.

[maf1973]

I re-uploaded the files and reinstalled the product.
Now it works.

What is the table name of the stored items?
I found only itemstats_cache but there are no entries.

I created the table wowitemstats manually:

CREATE TABLE wowitemstats (
item_name varchar(100) NOT NULL default '',
item_id varchar(100) default '0',
item_color varchar(20) NOT NULL default '',
UNIQUE KEY item_name (item_name) );

Hope this will help to cache the items.

[maf1973]

The error still there
I tried it with following item:

Verm?chtnis

http://www.communitas-draconis.de/forum/showthread.php?t=5883

It shows only golden [] and the itemstats_cache table fills with empty (zero) entries...

[sweede]

My product does not create a table called "itemstats_cache"

You probably had another itemstat like product that obviously is conflicting with mine.

However, since your URL you linked seems to work fine, i will assume that there is no issue?

[maf1973]

Hello,
i have first uninstalled your mod and the table itemstats_chache was dropped, after i reinstall your mod the table was created.

Please follow my link, i use item "Phönixring der Wiedergeburt" and the same error happen again, only golden [] are shown.

[sweede]

Update to the latest, 0.5.6.

when linking an item, you would use something like Ph?nixring der Wiedergeburt

It will produce something similar to

17:09:02 called in wowhead_item::__construct:70 Version:0.5.6
17:09:02 called in wowhead_item::__construct:71 Array
(
[vbulletin] => vBulletin
[app_tools] => App Tools
[devtools] => Developer Tools
[app_form] => Guild Application Form
[installcodes] => Installationscode-Generator
[releasebuilder] => Release Builder
[adv_cmps] => vBadvanced CMPS
[vde] => vBulletin Development Environment
[wowcharbbcode] => WoW BB Code
[wowhead_itemstats] => WoW Head ItemStats
)

17:09:02 called in wowhead_item::__construct:74 Array
(
[0] =>
[1] => wowhead_itemstats_bold => (1)
[2] => wowhead_itemstats_underline => (0)
[3] => wowhead_itemstats_newwindow => (1)
[4] => wowhead_itemstats_q => (#ffd100)
[5] => wowhead_itemstats_q0 => (#9d9d9d)
[6] => wowhead_itemstats_q1 => (#ffffff)
[7] => wowhead_itemstats_q2 => (#1eff00)
[8] => wowhead_itemstats_q3 => (#0070dd)
[9] => wowhead_itemstats_q4 => (#a335ee)
[10] => wowhead_itemstats_q5 => (#ff8000)
[11] => wowhead_itemstats_q6 => (#e5cc80)
[12] => wowhead_itemstats_q7 => (#ff0000)
[13] => wowhead_itemstats_q8 => (#ffff98)
[14] => wowhead_debug => (0)
[15] => wowhead_language => (www)
[16] => wowhead_power_js => (no)
)

17:09:02 called in wowhead_item::__construct:76
<Table name="itemstat_cache">
<Field name="id" type="int(7)" null="NO" key="MUL" default="" autoincrement="false"/>
<Field name="name" type="varchar(70)" null="NO" key="" default="" autoincrement="false"/>
<Field name="quality" type="int(1)" null="NO" key="" default="" autoincrement="false"/>
<Field name="icon" type="varchar(60)" null="NO" key="" default="" autoincrement="false"/>
<Field name="lang" type="varchar(5)" null="NO" key="" default="" autoincrement="false"/>
<Field name="htmlTooltip" type="longtext" null="NO" key="" default="" autoincrement="false"/>
</Table>
Number of Rows:4
17:09:02 called in wowhead_item::start:272 www
17:09:02 called in wowhead_item::start:298 SELECT * FROM itemstat_cache WHERE name like 'Major Healing Potion'
17:09:02 called in wowhead_item::start:311 Getting New Item
17:09:02 called in wowhead_item::getHTTP:160 http://www.wowhead.com/?item=major+healing+potion&xml
17:09:02 called in wowhead_item::getHTTP:177 <?xml version="1.0" encoding="UTF-8"?><wowhead><item id="13446"><name><![CDATA[Major Healing Potion]]></name><level>55</level><quality id="1">Common</quality><class id="0"><![CDATA[Consumables]]></class><subclass id="1"><![CDATA[Potions]]></subclass><icon displayId="24152">INV_Potion_54</icon><inventorySlot id="0"></inventorySlot><htmlTooltip><![CDATA[<table><tr><td><b class="q1">Major Healing Potion</b><br />Requires Level 45</td></tr></table><table><tr><td><span class="q2">Use: Restores 1050 to 1750 health. (2 Min Cooldown)</span></td></tr></table>]]></htmlTooltip><createdBy><spell id="17556" name="Major Healing Potion" icon="INV_Potion_54" minCount="1" maxCount="1"><reagent id="13464" name="Golden Sansam" quality="1" icon="INV_Misc_Herb_SansamRoot" count="2" /><reagent id="13465" name="Mountain Silversage" quality="1" icon="INV_Misc_Herb_MountainSilverSage" count="1" /><reagent id="8925" name="Crystal Vial" quality="1" icon="INV_Drink_06" count="1" /></spell></createdBy><link>http://www.wowhead.com/?item=13446</link></item></wowhead>
17:09:02 called in wowhead_item::start:338 Array
(
[xml] => <?xml version="1.0" encoding="UTF-8"?><wowhead><item id="13446"><name><![CDATA[Major Healing Potion]]></name><level>55</level><quality id="1">Common</quality><class id="0"><![CDATA[Consumables]]></class><subclass id="1"><![CDATA[Potions]]></subclass><icon displayId="24152">INV_Potion_54</icon><inventorySlot id="0"></inventorySlot><htmlTooltip><![CDATA[<table><tr><td><b class="q1">Major Healing Potion</b><br />Requires Level 45</td></tr></table><table><tr><td><span class="q2">Use: Restores 1050 to 1750 health. (2 Min Cooldown)</span></td></tr></table>]]></htmlTooltip><createdBy><spell id="17556" name="Major Healing Potion" icon="INV_Potion_54" minCount="1" maxCount="1"><reagent id="13464" name="Golden Sansam" quality="1" icon="INV_Misc_Herb_SansamRoot" count="2" /><reagent id="13465" name="Mountain Silversage" quality="1" icon="INV_Misc_Herb_MountainSilverSage" count="1" /><reagent id="8925" name="Crystal Vial" quality="1" icon="INV_Drink_06" count="1" /></spell></createdBy><link>http://www.wowhead.com/?item=13446</link></item></wowhead>
[id] => 13446
[name] => Major Healing Potion
[icon] => INV_Potion_54
[htmlTooltip] => <table><tr><td><b class="q1">Major Healing Potion</b><br />Requires Level 45</td></tr></table><table><tr><td><span class="q2">Use: Restores 1050 to 1750 health. (2 Min Cooldown)</span></td></tr></table>
[quality] => 1
[lang] => www
)

17:09:02 called in wowhead_item::SaveItem:215 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'13446',
'Major Healing Potion',
'1',
'INV\_Potion\_54',
'www',
'<table><tr><td><b class=\"q1\">Major Healing Potion</b><br />Requires Level 45</td></tr></table><table><tr><td><span class=\"q2\">Use: Restores 1050 to 1750 health. (2 Min Cooldown)</span></td></tr></table>' );
17:09:02 called in wowhead_item::getHTTP:160 http://fr.wowhead.com/?item=13446&xml
17:09:02 called in wowhead_item::getHTTP:177 <?xml version="1.0" encoding="UTF-8"?><wowhead><item id="13446"><name><![CDATA[Potion de soins majeure]]></name><level>55</level><quality id="1">Classique</quality><class id="0"><![CDATA[Consommables]]></class><subclass id="1"><![CDATA[Potions]]></subclass><icon displayId="24152">INV_Potion_54</icon><inventorySlot id="0"></inventorySlot><htmlTooltip><![CDATA[<table><tr><td><b class="q1">Potion de soins majeure</b><br />Niveau 45 requis</td></tr></table><table><tr><td><span class="q2">Utiliser?*: Rend 1050 to 1750 points de vie. (2 min de recharge)</span></td></tr></table>]]></htmlTooltip><createdBy><spell id="17556" name="Potion de soins majeure" icon="INV_Potion_54" minCount="1" maxCount="1"><reagent id="13464" name="Sansam doré" quality="1" icon="INV_Misc_Herb_SansamRoot" count="2" /><reagent id="13465" name="Sauge-argent des montagnes" quality="1" icon="INV_Misc_Herb_MountainSilverSage" count="1" /><reagent id="8925" name="Fiole de cristal" quality="1" icon="INV_Drink_06" count="1" /></spell></createdBy><link>http://fr.wowhead.com/?item=13446</link></item></wowhead>
17:09:02 called in wowhead_item::SaveItem:254 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'13446',
'Potion de soins majeure',
'1',
'INV\_Potion\_54',
'fr',
'<table><tr><td><b class=\"q1\">Potion de soins majeure</b><br />Niveau 45 requis</td></tr></table><table><tr><td><span class=\"q2\">Utiliser*: Rend 1050 to 1750 points de vie. (2 min de recharge)</span></td></tr></table>' );
17:09:02 called in wowhead_item::getHTTP:160 http://de.wowhead.com/?item=13446&xml
17:09:02 called in wowhead_item::getHTTP:177 <?xml version="1.0" encoding="UTF-8"?><wowhead><item id="13446"><name><![CDATA[Erheblicher Heiltrank]]></name><level>55</level><quality id="1">Verbreitet</quality><class id="0"><![CDATA[Verbrauchbar]]></class><subclass id="1"><![CDATA[Tränke]]></subclass><icon displayId="24152">INV_Potion_54</icon><inventorySlot id="0"></inventorySlot><htmlTooltip><![CDATA[<table><tr><td><b class="q1">Erheblicher Heiltrank</b><br />Benötigt Stufe 45</td></tr></table><table><tr><td><span class="q2">Benutzen: Stellt 1050 to 1750 Gesundheit wieder her. (2 Min. Abklingzeit)</span></td></tr></table>]]></htmlTooltip><createdBy><spell id="17556" name="Erheblicher Heiltrank" icon="INV_Potion_54" minCount="1" maxCount="1"><reagent id="13464" name="Goldener Sansam" quality="1" icon="INV_Misc_Herb_SansamRoot" count="2" /><reagent id="13465" name="Bergsilbersalbei" quality="1" icon="INV_Misc_Herb_MountainSilverSage" count="1" /><reagent id="8925" name="Kristallphiole" quality="1" icon="INV_Drink_06" count="1" /></spell></createdBy><link>http://de.wowhead.com/?item=13446</link></item></wowhead>
17:09:02 called in wowhead_item::SaveItem:254 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'13446',
'Erheblicher Heiltrank',
'1',
'INV\_Potion\_54',
'de',
'<table><tr><td><b class=\"q1\">Erheblicher Heiltrank</b><br />Ben?tigt Stufe 45</td></tr></table><table><tr><td><span class=\"q2\">Benutzen: Stellt 1050 to 1750 Gesundheit wieder her. (2 Min. Abklingzeit)</span></td></tr></table>' );
17:09:02 called in wowhead_item::getHTTP:160 http://es.wowhead.com/?item=13446&xml
17:09:02 called in wowhead_item::getHTTP:177 <?xml version="1.0" encoding="UTF-8"?><wowhead><item id="13446"><name><![CDATA[Poción de sanación sublime]]></name><level>55</level><quality id="1">Común</quality><class id="0"><![CDATA[Consumibles]]></class><subclass id="1"><![CDATA[Pociones]]></subclass><icon displayId="24152">INV_Potion_54</icon><inventorySlot id="0"></inventorySlot><htmlTooltip><![CDATA[<table><tr><td><b class="q1">Poción de sanación sublime</b><br />Necesitas ser de nivel 45</td></tr></table><table><tr><td><span class="q2">Uso: Restaura 1050 to 1750 p. de salud. (Tiempo de reutilización: 2 min)</span></td></tr></table>]]></htmlTooltip><createdBy><spell id="17556" name="Poción de sanación sublime" icon="INV_Potion_54" minCount="1" maxCount="1"><reagent id="13464" name="Sansam dorado" quality="1" icon="INV_Misc_Herb_SansamRoot" count="2" /><reagent id="13465" name="Salviargenta de montaña" quality="1" icon="INV_Misc_Herb_MountainSilverSage" count="1" /><reagent id="8925" name="Vial de cristal" quality="1" icon="INV_Drink_06" count="1" /></spell></createdBy><link>http://es.wowhead.com/?item=13446</link></item></wowhead>
17:09:02 called in wowhead_item::SaveItem:254 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'13446',
'Poci?n de sanaci?n sublime',
'1',
'INV\_Potion\_54',
'es',
'<table><tr><td><b class=\"q1\">Poci?n de sanaci?n sublime</b><br />Necesitas ser de nivel 45</td></tr></table><table><tr><td><span class=\"q2\">Uso: Restaura 1050 to 1750 p. de salud. (Tiempo de reutilizaci?n: 2 min)</span></td></tr></table>' );
17:09:02 called in wowhead_item::printItemURL:379 <a id="itemlink" class="q1" style=" font-weight: bold;" href="http://www.wowhead.com/?item=13446" target="_blank">[Major Healing Potion]</a>


This will list your installed plugins (for conflicts), your wowhead itemstats settings, the appropriate table information (which my bad, is itemstat_cache) and some general steps that the code goes through.

[sweede]

Hello,
i have first uninstalled your mod and the table itemstats_chache was dropped, after i reinstall your mod the table was created.

Please follow my link, i use item "Ph?nixring der Wiedergeburt" and the same error happen again, only golden [] are shown.

Oh wait a second.

some characters (especialy german) don't translate to URL syntax.

I build a URL by adding the name to the URL. ?item=My+Item

Some special characters (such as ?) don't have a compatible URL code.

basicly, if you can make
http://de.wowhead.com/?item=Ph?nixring+der+Wiedergeburt work,

let me know.

[maf1973]

"Ph?nixring+der+Wiedergeburt" did not work :(
Any other ideas?

10:09:39 called in wowhead_item::__construct:68 Array
(
[0] =>
[1] => wowhead_power_js => (1)
[2] => wowhead_language => (de)
[3] => wowhead_debug => (0)
[4] => wowhead_itemstats_q8 => (#ffff98)
[5] => wowhead_itemstats_q7 => (#ff0000)
[6] => wowhead_itemstats_q5 => (#ff8000)
[7] => wowhead_itemstats_q6 => (#e5cc80)
[8] => wowhead_itemstats_q4 => (#a335ee)
[9] => wowhead_itemstats_q3 => (#0070dd)
[10] => wowhead_itemstats_q2 => (#1eff00)
[11] => wowhead_itemstats_q1 => (#ffffff)
[12] => wowhead_itemstats_q0 => (#9d9d9d)
[13] => wowhead_itemstats_q => (#ffd100)
[14] => wowhead_itemstats_newwindow => (1)
[15] => wowhead_itemstats_underline => (1)
[16] => wowhead_itemstats_bold => (1)
)

10:09:39 called in wowhead_item::__construct:70
<Table name="itemstat_cache">
<Field name="id" type="int(7)" null="NO" key="MUL" default="" autoincrement="false"/>
<Field name="name" type="varchar(70)" null="NO" key="" default="" autoincrement="false"/>
<Field name="quality" type="int(1)" null="NO" key="" default="" autoincrement="false"/>
<Field name="icon" type="varchar(60)" null="NO" key="" default="" autoincrement="false"/>
<Field name="lang" type="varchar(5)" null="NO" key="" default="" autoincrement="false"/>
<Field name="htmlTooltip" type="longtext" null="NO" key="" default="" autoincrement="false"/>
</Table>
Number of Rows:368
10:09:39 called in wowhead_item::start:266 de
10:09:39 called in wowhead_item::start:292 SELECT * FROM itemstat_cache WHERE name like 'Ph?nixring+der+Wiedergeburt'
10:09:39 called in wowhead_item::start:305 Getting New Item
10:09:39 called in wowhead_item::getHTTP:154 http://de.wowhead.com/?item=ph?nixring+der+wiedergeburt&xml
10:09:39 called in wowhead_item::getHTTP:171 <?xml version="1.0" encoding="UTF-8"?><wowhead><error><![CDATA[Item 'ph?nixring der wiedergeburt' not found!]]></error></wowhead>
10:09:39 called in wowhead_item::start:332 Array
(
[xml] => <?xml version="1.0" encoding="UTF-8"?><wowhead><error><![CDATA[Item 'ph?nixring der wiedergeburt' not found!]]></error></wowhead>
[id] =>
[name] =>
[icon] =>
[htmlTooltip] =>
[quality] =>
[lang] => de
)

10:09:39 called in wowhead_item::SaveItem:209 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'',
'',
'',
'',
'de',
'' );
10:09:39 called in wowhead_item::getHTTP:154 http://www.wowhead.com/?item=&xml
10:09:39 called in wowhead_item::getHTTP:171 <?xml version="1.0" encoding="UTF-8"?><wowhead><error>Item not found!</error></wowhead>
10:09:39 called in wowhead_item::SaveItem:248 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'',
'',
'',
'',
'www',
'' );
10:09:39 called in wowhead_item::getHTTP:154 http://fr.wowhead.com/?item=&xml
10:09:40 called in wowhead_item::getHTTP:171 <?xml version="1.0" encoding="UTF-8"?><wowhead><error>Item not found!</error></wowhead>
10:09:40 called in wowhead_item::SaveItem:248 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'',
'',
'',
'',
'fr',
'' );
10:09:40 called in wowhead_item::getHTTP:154 http://es.wowhead.com/?item=&xml
10:09:40 called in wowhead_item::getHTTP:171 <?xml version="1.0" encoding="UTF-8"?><wowhead><error>Item not found!</error></wowhead>
10:09:40 called in wowhead_item::SaveItem:248 INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'',
'',
'',
'',
'es',
'' );
10:09:40 called in wowhead_item::printItemURL:373 <a id="itemlink" class="q" style="text-decoration: none; font-weight: bold;" href="http://de.wowhead.com/?item=" target="_blank">[]</a>

[sweede]

the ? is causing your problem.

I do see other problems though not related to yours.

Lets see if wowhead can be of any help
http://www.wowhead.com/?forums&topic=41052&p=394948

[sweede]

Maf, until wowhead and i figure out a solution, the best work around will be to use the english name when making a post. the product will cache all languages of the item (which btw, is a workaround for the problem and won't be needed once the problem is fixed).

later when you post the german translated item, it will work.

[sweede]

The non-english character issues have been corrected on Wowheads site.

http://de.wowhead.com/?item=Ph?nixring+der+Wiedergeburt&xml or http://de.wowhead.com/?item=Gew?nder+der+M??igung&xml

will work correctly now.

I still will need to update my product to remove a few hacks.

[civy]

Has something changed with wowhead? Item stats now has a expected identifier error and mouseover no longer displays the item.

[sweede]

Has something changed with wowhead? Item stats now has a expected identifier error and mouseover no longer displays the item.

to make matters worse, it's only an IE bug. Firefox appears to work fine

[civy]

to make matters worse, it's only an IE bug. Firefox appears to work fine

Glad its not just me:). Been making alot of changes to the forum and thought i'd broke it:)

[civy]

I swapped to the local power.js and it works fine. Guess I'll just have to keep it updated.

Great mod btw :)

[nazguluk]

I swapped to the local power.js and it works fine. Guess I'll just have to keep it updated.

Great mod btw :)

Nice... thanks for the tip. I created a basic html page

<a href="http://www.wowhead.com/widgets/power.js>Download</a>

right clicked on the text and did a save as and replaced my power.js file in the root of my forums directory and that fixed it for me

[sweede]

Nice... thanks for the tip. I created a basic html page

<a href="http://www.wowhead.com/widgets/power.js>Download</a>

right clicked on the text and did a save as and replaced my power.js file in the root of my forums directory and that fixed it for me

They must have fixed it on their end.

[Bumpaneer]

First off, thanks for the addon, it works great for just about everything.

The one problem I am having is with an RSS feed import. Pulling from wowinsider, they have had lots of items pulled from wotlk.wowhead.com Whenever these items are parsed, it comes back Item #XXXXX not found! (XXXXX replaced for item number). Is there any way to correct this behaviour? It seems it is trying to find the item at www.wowhead.com instead of the correct wotlk.wowhead.com.

http://www.wowinsider.com/2008/09/28/ask-a-beta-tester-more-mounts-raid-gear-and-emotes/

Above is an example of one of the stories I recently imported. The link for the Mammoth was incorrectly replaced.

Thanks

[mikeylikesitz]

i have a feeling that it will be fixed when wowhead moves the wotlk db to the main db

[CtrlAltDel]

So if I simply just paste a WH link, ie http://www.wowhead.com/?item=37828

The site breaks, but if i use item tags and the name it works. I had your old version installed, then removed it and installed this one.

[sweede]

Right now, as the mod sits,

http://wotlk.wowhead.com/?item=16243 will not work (it shouldn't break the site though). Instead it -should- default to
http://www.wowhead.com/?item=16243 (notice the sub-domain prefix change).

If you posted an item that doesnt exist in live, you should get an item not found message instead.

So, nothing really should "break". I do however, have a temporary hack fix (hax!) in mind, but i won't be able to write and test it until tomorrow morning (working 12hrs/day sucks!). I need to sleep sometime :)


Also, "the site breaks", tells me nothing about your problem. A link to the actual post, a php error message or something would give me an idea of whats going on.

[CtrlAltDel]

Here is how the site 'breaks'.

From Quick Reply or from the Reply page, i type the following.
http://www.wowhead.com/?item=31051
Submit the form

It just takes me to a white page.

If I use the item tags and the item name, it works fine.

I even updated my power.js and updated the md5sum also
also tried using the external power.js too

Things seem really strange with your install file now. Post the old version please, that one worked, or add it back in the old post.

This one has two database tables added, wowitemstats and itemstat_cache, nothing is in the former and the later has some entries and a ton of empty entries

[Danoxth]

It all works and dandy, but for some reason it's causing an error message when just a WoWhead URL is used on it's own.

Example
[ url ] http://www.wowhead.com/?item=32325 [ /url ] works fine.

http://www.wowhead.com/?item=32325 on it's own causes this error:

Fatal error: Call to private method wowhead_item::getHTTP() from context '' in xxxxxxxxxxxxx\includes\functions_newpost.php(175) : eval()'d code on line 35

Regular links work fine, and the forum automatically pops the [ url ] tags on them no problem, It's only for WoWhead ones that it throws a bit of a hissy fit.

Any ideas?

[hunteds911]

Anyone get this error when installing on Vbulletin Version: 3.7.3 Patch Level 1?

"The following dependencies were not met:
This product is not compatible with version 4.4.9 of PHP. (Compatible starting with 5.0)"


Ok so I am like duh... But here is the issue I am showing 4.4.9 how do I get to 5.0 to run the hack? Or is there a version of this that will work with 4.4.9

[sweede]

It all works and dandy, but for some reason it's causing an error message when just a WoWhead URL is used on it's own.

Example
[ url ] http://www.wowhead.com/?item=32325 [ /url ] works fine.

http://www.wowhead.com/?item=32325 on it's own causes this error:



Regular links work fine, and the forum automatically pops the [ url ] tags on them no problem, It's only for WoWhead ones that it throws a bit of a hissy fit.

Any ideas?

Thats so weird, i thought i fixed that problem with the 0.5.6...



Ok so I am like duh... But here is the issue I am showing 4.4.9 how do I get to 5.0 to run the hack? Or is there a version of this that will work with 4.4.9

Tell your host to upgrade to php 5 , it has been marked stable for 4 years now ( http://news.php.net/php.announce/50 ).

[Danoxth]

Thats so weird, i thought i fixed that problem with the 0.5.6...


I've just double checked and it's definitely the 0.5.6 version I'm using =/

[sweede]

I've just double checked and it's definitely the 0.5.6 version I'm using =/

it should be fixed for real this time :)

for some reason i had marked the method getHTTP as a private class, meaning you can't call it directly (i.e. $obj = new wowhead_item(); $x = $obj->getHTTP() ).

I thought i fixed that like.. 3 versions ago but thats what i get for working until 6am 3-4 days week :(

[CtrlAltDel]

Great making that method public fixed my problems!

Thanks for checking on this sweede!

[istvan]

I've gotten some questions if it would be possible to get spell-id's also working as a mouseover like the item-id's

[Elbulus]

Any news on the Wotlk.wowhead.com haxxor ? ;p

[DeathSoul]

hmz - I have a problem when trying to link items;

linking items with just;
http://www.wowhead.com/?item=34185
for eksample works.

But using
Sword Breaker's Bulwark
Does not work;
here's what a url shows when i try mouseover after posting with the [item] codes;
http://www.wowhead.com/?item={option}

Any idea what's wrong?

(oh and if i try and edit the post - the links will not work anymore, as they stand as html in the edit window, and not as or http://www.wowhead.com/?item=34185

[squidsoup]

Hi Sweede, this is awesome - thank you so much! Much easier to install than itemstats and way less code. Brilliant!

[Rhyseh]

Absolutely brilliant addon. I'm looking around for spell mouseovers atm. It would be great if we could get this addon to do it.

[forumrunt]

Works like a charm thanks

[OblivionMage]

Causes:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/mmoqqcom/public_html/guidewiki/forums/includes/class_core.php on line 408


In pages with a lot of <item></item> links (takes longer the more there are until it gives that error). I tried about 450-500 tags to get that error.


Any ideas on how to optimize?

[sweede]

Causes:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/mmoqqcom/public_html/guidewiki/forums/includes/class_core.php on line 408


In pages with a lot of <item></item> links (takes longer the more there are until it gives that error). I tried about 450-500 tags to get that error.


Any ideas on how to optimize?

umm.. don't make a single post with 450-500 items ?

Each item is looked up in your local cache for the item ID (wowhead requires item ID to create the tooltip).

If it is not found, it will make a request to wowhead.com (example; http://www.wowhead.com/?item=Netherweave&xml ) to get the XML data w/the item ID.

I cache most of the information in the XML for future use.

vbulletin then creates the item link that the wowheads power.js will process.


The largest time spent is the http request to wowhead.com. if each request took just 1/10th of a second, 450 requests would still take 45s or longer, since each request is sequential.

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

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 Name , 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-warcraft/2506-naxxramas-raid-guide-wotlk.html). If you want it to look just like an item link, just add font/color tags inside of the URL tag.

[sweede]

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-warcraft/2506-naxxramas-raid-guide-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 133 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]

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

[Didzi]

There is a problem with the last object [/item] [item] version no longer works...

[sweede]

There is a problem with the last object [/item] [item] version no longer works...

I'm sorry, but that makes no sense at all, but I did fix it.

0.5.7a wont give you a SQL error when viewing a post.

[Didzi]

The BBCODE tags still doesn't work...

[Michad]

Figured it out. 5-7a doesn't have the full code in the xml since its more of an update than anything.

Actually 5-7a is missing alot of code. You might want to fix that.

[sweede]

Figured it out. 5-7a doesn't have the full code in the xml since its more of an update than anything.

Actually 5-7a is missing alot of code. You might want to fix that.

:o


fixed for real this time i think

[Didzi]

Nice,

A bug still remains with the french version. When the base sql accents are properly put, but in messages the accents utf8 format dont properly display cf image

https://vborg.vbsupport.ru/

[sweede]

Nice,

A bug still remains with the french version. When the base sql accents are properly put, but in messages the accents utf8 format dont properly display cf image

http://ultima.usuga.net/imagehosting/1498b83fa6f17e.jpg

That's really odd..

I don't generate tooltips with this code.

the only thing I do is make the item linking look pretty, like actual wow item links.

you can take a wowhead.com URL and paste it into a post, the URL that is created will be wowhead tooltip enabled.

I just add the [] and change the text color to the item quality color. Sometimes i fix/correct the name but thats only on rare occasions.

THe problem you're having doesnt seem to be a vublletin issue at all, but ive been wrong often in this thread ( :0 ) and i'm not ashamed to say i could be wrong here..e.

[Michad]

Any chance of getting an update to this that would query spells as well? I swear ive seen this in action on the Elitist Jerks forums.

[HolyKiller]

2 Michad: I don't know what Elitist Jerks forum is, but on my old forum based on phpBB i have mod for wowhead tooltips and users can use [item] for items, [spell] for spells or [quest] for quests.

So i thing, it IS possible to do it :)

EDIT: Finally, i found homepage for that mod: HERE (http://wowhead.crackpot.us/)

EDIT2: LoL, new version can link achievements, crafts, and itemsets ...


So, maybe this can help you for make new version :)

[sweede]

2 Michad: I don't know what Elitist Jerks forum is, but on my old forum based on phpBB i have mod for wowhead tooltips and users can use [item] for items, [spell] for spells or [quest] for quests.

you can do

Holy Light (http://www.wowhead.com/?spell=48782)


and get spell, quest, anything as a tooltip that wowhead will provide.

I'm not sure how that addon you linked gets spells (go to wowhead.com and search for holy light and look how many things it returns), but i'll look and what its doing.

[jluerken]

Is there a way to get a working version for php 4.3.x ?

[y2krazy]

For some reason, the tooltips are not showing up. Any ideas as to why the item is pulled correctly, links to the correct Wowhead URL and gets colored properly, but no tooltip shows up? Thanks.

The latest .zip file released is missing some files, including power.js compared to the older .zip file. Am I missing some files if I only downloaded the newest .zip?

~ Sean

[sweede]

Don't check "Local power.js"

if you really want to, you can download the power.js from wowhead.com (http://www.wowhead.com/widgets/power.js) and put it in your clientscript folder.

[y2krazy]

Don't check "Local power.js"
This didn't solve my issue. I still do not see a tooltip when hovering over an item link.

~ Sean

[sweede]

URL to example post ?

[y2krazy]

URL to example post ?
The board I use is a dev board, which is always closed. Umm... for a general overview:

The item gets processed fine. The color of the text is correct (purple for epic, etc.). The item name is right. The item link on Wowhead is right. The ONLY issue is that the item tooltip (like on some other sites) does not popup when you hover over the item. That is the only problem I am having.

Thanks.

~ Sean

[sweede]

view page source, search for power.js and paste that here.

[y2krazy]

Hmph. I just checked the link from home and it seems to work just fine. Maybe it's an issue with some out-of-date software on my work PC. >.>

~ Sean

[Bumpaneer]

Is there any way that this mod could respect the subdomain of wowhead that is being referenced? For example, when a link is made to something on the PTR section of wowhead (http://ptr.wowhead.com/?item=45440), this addon causes that link to get messed up if the item does not exist in the normal wowhead database (it gets translated to http://www.wowhead.com/?item=45440). Ideally the addon should respect the subdomain of the link I enter, keeping ptr.wowhead.com instead of replacing it with www.wowhead.com

[sweede]

Is there any way that this mod could respect the subdomain of wowhead that is being referenced? For example, when a link is made to something on the PTR section of wowhead (http://ptr.wowhead.com/?item=45440), this addon causes that link to get messed up if the item does not exist in the normal wowhead database (it gets translated to http://www.wowhead.com/?item=45440). Ideally the addon should respect the subdomain of the link I enter, keeping ptr.wowhead.com instead of replacing it with www.wowhead.com

Currently this is intended.

I will have to change how that whole URL to itemcode thing works to allow urls like ptr.wowhead.com to work.

however, it will also allow people to properly use wowhead links for spells, quests, etc; so it'll be a couple days before i get the new code written.

[4yBak]

how I can add support for russian language (Default Wowhead item link langauge). An example russian link from wowhead - http://ru.wowhead.com/?item=40194

[sweede]

how I can add support for russian language (Default Wowhead item link langauge). An example russian link from wowhead - http://ru.wowhead.com/?item=40194

sorry, tons of horrible pc issues. i'll get that updated tomorrow though.

[4yBak]

I receive 2 times this error using your modification:
Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT * FROM itemstat_cache WHERE id like http://ru.wowhead.com/?spell=23214;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://ru.wowhead.com/?spell=23214' at line 1
Error Number : 1064
Request Date : Friday, April 3rd 2009 @ 05:26:20 PM
Error Date : Friday, April 3rd 2009 @ 05:26:20 PM
Script : http://forumlink/newthread.php?do=postthread&f=5
Referrer : http://forumlink/newthread.php?do=newthread&f=5

[bigcurt]

How is this looking?

[y2krazy]

How is this looking?
Works fine on 3.8.1.

~ Sean

[pooslokka]

what is this mod really, all sample / screen shot links are not working :(

[Juravieal]

What would cause the item popups to work perfectly in one thread, and not in another? Same forum, posted by the same user. Im at a loss here.

[J.Walter]

What would cause the item popups to work perfectly in one thread, and not in another? Same forum, posted by the same user. Im at a loss here.

Same here :(

[tatu]

Hello, i'm french and i have installed this script. And i have a little problem with some special caracter.
I have search a little, and there is a compatibility problem from UTF-8 to ISO-8859-1.
i put the original link of wowhead : http://fr.wowhead.com/?item=40071

[sweede]

I updated to add Russian support and made an attempt to allievate database queries and any perceived load issues from it.

Multiple language support will not work with 0.6.0 !!

Tatu, I do not have any control over the display of the tooltip.

[sweede]

I receive 2 times this error using your modification:
Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT * FROM itemstat_cache WHERE id like http://ru.wowhead.com/?spell=23214;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://ru.wowhead.com/?spell=23214' at line 1
Error Number : 1064
Request Date : Friday, April 3rd 2009 @ 05:26:20 PM
Error Date : Friday, April 3rd 2009 @ 05:26:20 PM
Script : http://forumlink/newthread.php?do=postthread&f=5
Referrer : http://forumlink/newthread.php?do=newthread&f=5

I do not support anything but items at this time.

if you need to link a spell, using the URL tags will work, do not use item tags.
Spell (http://ru.wowhead.com/?spell=23214)

[sweede]

just a quick update,

I do have a rudimentary spell, quest, achievement support worked out.

There may be a bbcode tag for this but i don't think i'll have one.

There is no reliable, accurate method to get a proper spell ID from a keyword (for example, search wowhead.com for `Blood boil' )

Achievements are the same way.

Yes yes i know that someone write a rather complex set of "interfaces" to pull stuff from wowhead but i want something light that requires very little configuration and maintenance.

Support for spells etc will be done by pasting wowhead URLs.

The lookup is done and the name is retrieved and stored for so that it doesnt keep hitting wowhead for lookups.

[HolyKiller]

2 Sweede: Excelent!! Finally i have no problem with loading page with a LOT items in posts. I tried to send post with 200 items. Post sending took about 10s. Any another post show is loaded almost instantly.

[4yBak]

version 0.6.0 don't work with russian links, for example I put link http://ru.wowhead.com/?item=45244 and then this url convert to next code:
(http://ru.wowhead.com/?item=45244)

and when I use code Наголенники молниеносной расправы I was receive an error:
12:06:49 called in wowhead_item::start:415 Item not found!

[sweede]

Russian text is getting mangled in php / vbulletin on my test server. I don't think php is compiled with proper support for russian characters.

i won't be able to get to that one just yet, sorry :(


However, about the memory load on the improved cache..
I write a script to crawl wowhead and import tons of items, and modified my code a little bit to show memory used before the cache variable is created and after.

Number of Rows: 12483
05:06:13 called in wowhead_item::CreateCache:54 Memory before: 3,782,776
05:06:14 called in wowhead_item::CreateCache:65 Memory after: 9,260,188 ( 5,477,412)


12480 items using 5.4mb of memory or 438 bytes per item. I don't consider this to bad since most databases will only have 400-500 items, maybe 1,000, which would put memory around 440k

Going to push through and crawl item IDs up to 55,000 and see how large i can make this.

[HolyKiller]

2 sweede: One of my users found this bug:

If you have some hyperlinks to wowhead in post and use WYSWIG editor, after save changes the wowhead links are totaly broken.

Try next steps:

- Post new post like this:
Wowhead (http://wowhead.com/?faction=1011)
Google (http://google.com)


- Then edit this post (ajax or advanced edit, it doesn't matter) with WYSWIG enabled and save it again.

- After this, you get post with this exactly:

fhioasdfhosdfsad
Google (http://google.com)


Can you look at this please? Lot of users on my forum wrote a very nice guides with many hyperlinks to wowhead, so when someone edit post in WYSWIG and save it, ALL of them will be lost :(


Thanks

Holy

[sweede]

Disable WYSIWYG for now, and go to (provided you are admin and can make yourself superadmin in the config file) Execute SQL Query,
from the automatic query select "Show Standard Editor Toolbar"

Some of that is fixed in 0.6.0

the rest will be fixed when i upload 0.6.1

Update.

[HolyKiller]

2 sweede: Upgraded to 0.6.1 and links now stay OK, but the text are changed by Wowhead title.

Use this:

click me (http://www.wowhead.com/?faction=1011)


and after edit in WYSIWYG you get this:

Lower City (http://www.wowhead.com/?faction=1011)

Anyway thanks again for fastest fix previous bug :)

EDIT: Sorry, i see, this is a new feature. Looks cool and works fine for achivs, spells, quests, ... etc. EXCELENT!!

But, bad thig is what i wrote before edit. Modifing ALL the hyperlinks text not good in some case. So, maybe limit that for links inside some TAGS will be better ... like a

http://www.wowhead.com/?quest=10985 -> this will be autohyperlinked to [A Distraction for Akama] (http://www.wowhead.com/?quest=10985). I know, this is not a "item" exactly, but it is easiest way for users ... ONE TAG do LOT of MAGIC :)

BTW: Please add brackets ( "[" and "]" ) in autohyperlink

[4yBak]

version 0.6.1
1) links like http://ru.wowhead.com/?faction=935 work perfect (without any errors and russian link names also displayed correctly)
2) if I post 2 different wowhead (english) links I see a bug with wrong link names (I was use standart editor). Example:
posting
http://www.wowhead.com/?item=28742
http://www.wowhead.com/?item=39216
and after saving this post I see next:
[Pantaloons of Repentance]
[Pantaloons of Repentance]
where first link for [Pantaloons of Repentance] correctly show tooltip for link for item http://www.wowhead.com/?item=28742 and has correct link name, but for link http://www.wowhead.com/?item=39216 I see also correct tooltip but wrong link name.
When I add one more links - it's also use link name from previous wowhead link.

[sweede]

version 0.6.1
1) links like http://ru.wowhead.com/?faction=935 work perfect (without any errors and russian link names also displayed correctly)

It's hard for me to test any type of character set like russian or any type of chinese/korean language. The next release will have a slightly different way of debugging that will make it easier to debug strange bugs such as..

2) if I post 2 different wowhead (english) links I see a bug with wrong link names (I was use standart editor). Example:
posting
http://www.wowhead.com/?item=28742
http://www.wowhead.com/?item=39216
and after saving this post I see next:
[Pantaloons of Repentance]
[Pantaloons of Repentance]
where first link for [Pantaloons of Repentance] correctly show tooltip for link for item http://www.wowhead.com/?item=28742 and has correct link name, but for link http://www.wowhead.com/?item=39216 I see also correct tooltip but wrong link name.
When I add one more links - it's also use link name from previous wowhead link.

I noticed some other odd behavior and i was working on a replacement, but i think i'll just quickly fix this and rewrite the entire class for a 0.7.x series.

[sweede]

2 sweede: Upgraded to 0.6.1 and links now stay OK, but the text are changed by Wowhead title.

Use this:

click me (http://www.wowhead.com/?faction=1011)


and after edit in WYSIWYG you get this:

Lower City (http://www.wowhead.com/?faction=1011)

Anyway thanks again for fastest fix previous bug :)

EDIT: Sorry, i see, this is a new feature. Looks cool and works fine for achivs, spells, quests, ... etc. EXCELENT!!

Ya, it should overwrite whatever name you try to give it to its correct warcraft name. But there are issues with it and since i hacked a lot of the code together it's difficult to fix. I need to re-think and re-write most of the code.


But, bad thig is what i wrote before edit. Modifing ALL the hyperlinks text not good in some case. So, maybe limit that for links inside some TAGS will be better ... like a

http://www.wowhead.com/?quest=10985 -> this will be autohyperlinked to [A Distraction for Akama] (http://www.wowhead.com/?quest=10985). I know, this is not a "item" exactly, but it is easiest way for users ... ONE TAG do LOT of MAGIC :)

BTW: Please add brackets ( "[" and "]" ) in autohyperlink

I was looking at making something like..

Lower City or
[item=quest]10985[/quest]

which would return what you would expect.

[HolyKiller]

Yea your idea is perfect.

/target Sweede
/bow

Thanks :)

[etzero]

Does anyone else see a 30 sec delay when Wowhead is down for maintenance?

When I try to refresh pages, even those that have no wowhead links, the page hangs and on the bottom left it says "looking up wowhead.com" or something similar. Eventually it times out and the page loads. This only happens when wowhead is down or under maintenance.

[4yBak]

etzero, I confirm it too.

[sweede]

the zip package should include a power.js file to upload and there is a vbulletion option to change to use power.js locally instead of getting it from wowhead

[paulomt1]

very nice mode :) ty

any news about quest and spell feature?

[rstan]

have been using this for a couple years. just switched to wowhead-tooltips.com, there is no vb integration can be integrated just like itemstats instructions. everything works except for the profile tab which is just showing name, guild icon and not the full table thats parsed into in the database. there is integration for everything but vb for some reason. maybe sweede can hook it up??? it basicly does item, spell, achievements, armory profile, quests, npc, item sets and guild tags.

[abouthere]

rstan - I have also been using the tooltip mod you mention for quite a while, albeit on a PHPBB forum. I've been looking for the same thing on vB but not yet found it...

[ArcVieh]

I come from germany and my vB 3.7.1 is utf-8, the database too. If i use the german locale in the addon, there are problems with '????' in the linked itemnames.

Example: Muster: Sch?rpe der uralten Kraft => 45102

Table: itemstat_cache
Name: Muster: Sch
htmltooltip: <table><tr><td><b class="q4">Muster: Sch

Where is the problem?

k, i fixed:
$xmlobj->parse('utf-8');

Thx

[sweede]

Thanks for fixing the issue :)

http://dramaloot.com/forums/f74/test-8670/

in just a second i'm going to upload a minor update which will allow you to specificly the language of an item.

41502 will show you the german name of the item ID.

Also supports PTR wowhead finally (only in english)

49968

Chilled Heart of the Glacier

[lav0s]

think you could make one like this for vB4?

[sweede]

There will be one for vb4 before to long. I still want to get some of the other features ive planned for so long in to the 3.8 one before i look at what i need to make it work with 4.0 (i don't think it would take much anyways).

[Poag]

Some play shows this version works at creating the links in vb4 B5 but no tooltips.

*waits for v4 proper versions* :D

[quarum]

Looking forward to a vB4 version indeed!

[sweede]

I'll try to have a proper vb4 version out before new year, now that its been released.

I don't know how you guys can stop playing wow long enough to update your forums though, the new Dungeon group finder and ICC just take up all my time !

[Kinneas]

Tell me about it. Geared my new loladin in full T9 Ret and Tank sets already. Just when you think you can play less they reel you in with more :P

Damn Warcrack.

Looking forward to the vB 4 version :)

[KrisJacobs]

The v0.71 Product XML file is working flawlessly on my vB 3.8.4!

Marked installed - thank you Sweede! :)

[HolyKiller]

Sweede already have full T10 from ICC HC, so now he can update this perfect hack for us. ^^

I belive version for vB 4 will be here soon :p

[sweede]

lol i wish. i need to stop working 12hrs day to update the guild forums to 4.0 so i can update the rest of the mods.

[MrShides]

Sweede we are all eagerly awaiting an update!

[lav0s]

sweede in case you need any help, just ask and i'll be willing to help you

[3clipse]

great mod and had been trying to make it work myself in vbulletin 4 and have had some success with the 0.7.1 version on vbulletin 4 after manually inserting the wowhead power.js link into headinclude, might be a decent dirty fix for people needing something until sweede can knock something up:

find in headinclude:

/external.php?type=RSS2&amp;forumids={vb:raw foruminfo.forumid}" />
</vb:if>
</vb:if>

add under:

<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript"></script>

[bc641990]

Works great just the white link problem on a white background is bothering me. I have changed the color in the Admin CP and it continues to stay white. I have checked page source and it is showing that it is attempting to change but no change is made. The Wowhead color seems to still be over riding this.

Using vBulletin 3.8.5
product-wowhead_itemstats_0.7.1.xml

Any solutions yet?

[sub_ubi]

Currently broken - not sure if wowhead changed something or what. As of now, adding items that haven't been added before does not work, it just leaves an orange "[]". I've attempted this on three different forums, including the plugin author's.

[sweede]

wowhead changed their URL format for items (And i'm sure many other things).

I uploaded a minor update.

As for the future of this plugin, we've decided not to move forward with vbb 4.0 for some time, probably not for another 2-3 months, if we ever do. I don't think there is much that needs to be changes for vbb 4.0 though, just the header include template and that should be it.

Expanding beyond what my guild currently needs hasn't been a primary goal for me, more or less something to do when i have spare time. However, since i just bought a house and have a whole lot of moving and fixing to do, i have very little spare time left.

[sub_ubi]

Thanks for the fast update, sweede! I'm not switching to 4.0 for a good while either.

A couple changes to the xml to restore URL functionality,

Line 321
return $u['scheme'] . "://" . $u['host'] . $u['path'] . $u['query'] . $u['fragment'];

line 488
".wowhead.com/item=" . $this->_item['id'] . "\"" . $target . ">[" . $this->_item['name'] . "]</a>";

line 507
if(eregi("wowhead.com\/", $text))

line 512
if(!eregi("\item=", $text))

line 575
if(eregi("wowhead.com\/", $text[0]))

line 609
if(eregi("wowhead.com\/", $href))

[sweede]

Thanks, i integrated those changed to the 0.7.3 release and thought, might as well put it in the 3.8 mod section.

https://vborg.vbsupport.ru/showthread.php?p=2016775