vb.org Archive - Add-On Releases - World of Warcraft Wowhead Item tooltips for vBulletin

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

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Add-On Releases - World of Warcraft Wowhead Item tooltips for vBulletin (https://vborg.vbsupport.ru/showthread.php?t=183035)

Quote:

Originally Posted by Dsru123 (Post 1563602)

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.

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

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!

thanks for this mod. Works fine.

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:

Quote:

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<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 <small>(1.33\% @ 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>Warglaive of Azzinoth</span><br /><span>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/

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.

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.: [item]Some Item[/item] will search by item name, [item=1234]Some Item[/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.

Quote:

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:

Quote:

Page generated in 14.04858 seconds with 130 queries

Would you consider this normal behaviour?

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

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?

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

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

Quote:

Originally Posted by Kinneas (Post 1587459)

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.

you enable debugging mode.

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

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

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!

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:

Any chance of a php4 version of this?

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

What I ended up with when I tried to drop an [item]something[/item] in a new thread is this:

Code:

Fatal error:  Class 'wowhead' not found in /home/jabouty/public_html/forums/includes/functions_wysiwyg.php(115) : eval()'d code on line 28

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

Code:

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

Quote:

Originally Posted by Chris-777 (Post 1598004)

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.

Quote:

Originally Posted by Cloudrunner (Post 1606190)

What I ended up with when I tried to drop an [item]something[/item] in a new thread is this:

Code:

Fatal error:  Class 'wowhead' not found in /home/jabouty/public_html/forums/includes/functions_wysiwyg.php(115) : eval()'d code on line 28

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

Bingo!

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

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:
[s]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.[/s]

Quote:

Originally Posted by dlan (Post 1607435)

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.

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?

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

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

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.

The error still there
I tried it with following item:

[item]Verm?chtnis[/item]

http://www.communitas-draconis.de/fo...ead.php?t=5883

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

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?

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.

Update to the latest, 0.5.6.

when linking an item, you would use something like [item=debug]Ph?nixring der Wiedergeburt[/item]

It will produce something similar to

Code:

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.

Quote:

Originally Posted by maf1973 (Post 1621871)

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.

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

Code:

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?nixri...edergeburt&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>

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

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.

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

http://de.wowhead.com/?item=Ph?nixri...edergeburt&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.

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

Quote:

Originally Posted by civy (Post 1630794)

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

Quote:

Originally Posted by sweede (Post 1630806)

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

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

Great mod btw :)

Quote:

Originally Posted by civy (Post 1630919)

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01544 seconds Memory Usage 1,959KB 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 (5)bbcode_code_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: