WoW Itemstats

[Liadan]

Mkay, for anyone else who runs SMF through a Joomla bridge and comes across the problem I had...

You need to name the table jos_wowitem_cache and NOT smf_wowitem_cache.

I wish I had tried to do that a lot sooner then I did. I guess I needed to step back and take a break from the whole problem. 'Cause it wasn't until I went to the movies with my Family and came home that I had the thought to rename the table. 

[Gigolock]

Hi DarkCloud14:

I have a HUGE problem that's driving me crazy.

I am trying to get Itemstats operative on our site.  It is not happening.

I am entering just [wowitem]17070[/wowitem] nothing more, nothing less as a test and I am getting the following error:

The used table type doesn't support FULLTEXT indexes
File: C:\Program Files\Sambar\docs\nb\reck\forums\Sources\itemstats\includes\itemcache.php
Line: 27

This is the item I am trying to get:
hxxp:wow.allakhazam.com/item.html?witem=17070 [nonactive]

Now, here's info on our system:

PHP ---------------------- 5
SMF ---------------------- Powered by SMF 1.1 RC2
mySQL ------------------- MySQL - 5.0.18-nt
Frustration --------------- 10 (to the limit) 

We looked at line 27 of said document and it says index.html - - felt lost, therefore decided to contact you instead.

Please help us ASAP.

This is our site by the way:
hxxp:reckless.nationalbiker.com [nonactive]

[DarkCloud14]

check this topic here or read some pages before...
http://www.darkcloud14.de/forum/index.php?topic=15.0

should fix your problem

[nanorus]

I'm sorry but it doesn't work completly for me. Indeed, I recover the color of item and a link towards Allakhazam but no popup displayed when mouse over the link.

I have added 2 lines in index.tempate.php :

Code Select Expand

<script language="JavaScript" type="text/javascript" src="http://mail.seigneursnoirs.com/Themes/default/itemstats/overlib/overlib.js"><!-- overLIB (c) Erik Bosrup --></script>

<link rel="stylesheet" type="text/css" href="http://mail.seigneursnoirs.com/Themes/default/itemstats/templates/itemstats.css" />

but I could noticed that a link of item towards Allakhazam is deprived of return overlib. Thus, it's normal that a popup is not displayed.

How to make to cure it ?

Sorry for my english, i'm french 

thanks you

[nanorus]

I find my problem. item_html field in item_cache table is empty. If I put toto in this field, it's working.

why the field is it empty ? 

thanks you for advance

[RobbieB]

I did your fix about the ENGINE=MyISAM" thing and I no longer get the error but even though the link works now, I dont see the item image or the little mouseover thing that is supposed to show the stats and stuff either. Additionally, all items links are appearing as same color which is blue with a red mouseover... is my site theme overriding this?

[nanorus]

for me, item_html field is empty 

[RobbieB]

nanorus same here, I just checked since you mentioned it. my item_source is set to 0 on 2 items I've tried, and item_html is empty.

[DarkCloud14]

I will post a solution when I'm at home again..
Ok I hope it's the same problem someone else had..

[DarkCloud14]

I'm sorry but it doesn't work completly for me. Indeed, I recover the color of item and a link towards Allakhazam but no popup displayed when mouse over the link.

I have added 2 lines in index.tempate.php :

Code Select Expand

<script language="JavaScript" type="text/javascript" src="http://mail.seigneursnoirs.com/Themes/default/itemstats/overlib/overlib.js"><!-- overLIB (c) Erik Bosrup --></script>

<link rel="stylesheet" type="text/css" href="http://mail.seigneursnoirs.com/Themes/default/itemstats/templates/itemstats.css" />

but I could noticed that a link of item towards Allakhazam is deprived of return overlib. Thus, it's normal that a popup is not displayed.

How to make to cure it ?

Sorry for my english, i'm french 

thanks you

you can remove these lines again from index.template.php ..
a function in Subs.php will add these two lines so it's theme independend...

[nanorus]

thanks a lot for your answer. 

I removed two lines in index.template.php

my problem is located in item_html and in item_source fields. item_html is empty and item_source is as value 0.
icon, name and color are well recovered ! 

for information, I've losses of data in my mysql database, item_cache table :

Space used:
Type              Space
Datas             432    Octets
Index              2 048 Octets
Losses             216    Octets
Total              2 480  Octets

and an example of the result of wowitemstats :

item_name Devout Crown   
item_id 16693
item_source 0
item_method find
item_link hxxp:wow.allakhazam.com/db/item.html?witem=16693 [nonactive]
item_color bluename
item_icon INV_Crown_01
item_html
item_found 1

thanks again ! 

[nanorus]

I understand has what corresponded item_source field

'0' = Allakhazam
'1' = blasc

and then of item_hml ?? 

[DarkCloud14]

Sorry for the late answer. Please take a look at the third post in this topic here:
http://www.darkcloud14.de/forum/index.php?topic=24.0

please try that and tell me if it worked..

Thanks

[RobbieB]

I don't understand what I'm supposed to do the 3rd post on that link is to another link on your forum which has someone replaceing code in allakhazam.php

I have never altered this file so when I tried searching the the exact string that was under
// Perform the search.

Code Select Expand

$data = itemstats_read_url('http://wow.allakhazam.com/dev/wow/item-search.pl?itemname=' . urlencode($name) . '&search=1');

Yet, it did not find it because when looking manually what I have under //Perform the search is significantly different then that I was supposed to find/replace.

Code Select Expand


This is what is in my file
$data = itemstats_read_url('http://wow.allakhazam.com/search.html?q=' . urlencode($name));


Is there perhaps a more up to date version of item stats that I can download? seems like the last release date is February 06, 2006

[DarkCloud14]

uhm no it's because he the poster has changed that line on his file...
the code he use will increase the search speed...

as far as I can see it's just that line he changed in his Find code
so the line you've posted is the right one ... Sorry didn't check that

[RobbieB]

I changed it to his method and I still cannot see item info when I mouse over the link, and fthe field item_html is still being left blank.

[DarkCloud14]

You replaced the three files I've posted in the topic ?!?

uhm can you pm me a link to a topic of your forum where you've tried itemstats

[DarkCloud14]

everybody with speed problems after installing itemstats please try the following:
http://www.darkcloud14.de/forum/index.php?topic=28.0

tell me if it worked...
Thanks

[RobbieB]

In your 3rd post, you talk about 3 files that you uploaded but there is no actual link to download those files. You then link to the other post about changing the code in the perform search and I didn't see any download links there either.

[DarkCloud14]

Uhm sorry Guest couldn't see the attachments. I've changed
that now so you don't have to register anymore. Please try it now