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]

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