Thanks sirhara, we'd love to see an update.

Here it is, a little longer than I had hoped

The new version (2.0) is pure Wowhead, I have cleared out all the other versions of suppport so be aware of that before you download. I have moved most configurable options from the raw code into the Joomla plugin params section so you can set it up through Joomla after install.

I added support for the eqdkp DB being in a different DB to joomla (since mod_latest_loot does).

Fixed a few small bugs in the generation of tooltips and a bit of general housekeeping.

PUItemstats-2.0


============= mod_latest_loot hack ===================

I needed the following hack to make latest_loot work with my shiny wowhead itemstats. I've basically updated part of it to support joomla 1.5 properly. I'm not fluent with Joomla so I haven't bothered doing it fully, but this works for now:

mod_latest_loot.php:

Find the following section towards the end:

Code:

global $_MAMBOTS; $row = new txt(); $row->text = $output; $_MAMBOTS->loadBotGroup( 'content' ); $params =& new mosParameters( '' ); $results = $_MAMBOTS->trigger( 'onPrepareContent', array( &$row, &$params, 0 ), true );

Replace it with this:

Code:

global $mainframe; $row = new txt(); $row->text = $output; $dispatcher =& JDispatcher::getInstance(); $params =& $mainframe->getParams('com_content'); JPluginHelper::importPlugin('content'); $results = $dispatcher->trigger('onPrepareContent', array (&$row, &$params, 0)); $output = $row->text;

This is quite rushed so if you find any errors please post back here and I'll answer them. If it looks good then maybe make it your official link to stop people bugging you?

One other point, I had some problems with cached pages (even with caching disabled).

If you turn on the mod and find it doesn't work, try rewriting your page with new content (different items) as a test.

Thank you, thank you, thank you.
Will try it tonight.

Now, how about integration with Fireboard?

Thank you sirhara for your work.

I tried to install the plugin but I came across this error :

Code:

JInstaller::install: Le fichier '/home/ice/public_html/site2/tmp/install_484e5252765f1/itemstats/index.html' n'existe pas

It seems that the "itemstats" folder in the archive is empty. I unzip the archive and I can confirm that.

wow I really suck.

New zip uploaded, try the above link again and let me know.

The new zip installed like a charm.

However I still have a problem, but it's probably on my side. When I try to use it, this error comes :

Code:

Fatal error: Call to undefined method ItemStats::BuildCache() in /home/ice/public_html/site2/plugins/content/puitemstats.php on line 64

If I comment the line n°64, I get a message saying :

Code:

Erreur de chargement des modules :MySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 66 OR mm.menuid = 0 ) ORDER BY position, ordering

So probably not the plugin fault

Hmmm that's rather odd...

This is the area of the file we are talking about:

puitemstats.php:

Code:

62: require_once("itemstats/itemstats.php"); 63: $item_stats = new ItemStats($host, $user, $pass, $db); 64: $item_stats->BuildCache();

itemstats/itemstats.php:

Code:

// The main interface to the ItemStats module. class ItemStats { var $item_cache; var $info_site; var $db; var $host; var $user; var $password; // Constructor function ItemStats($host, $user, $password, $db) { $this->host = $host; $this->user = $user; $this->password = $password; $this->db = $db; $this->info_site = new InfoSite(); // Setup a ghetto destructor. register_shutdown_function(array(&$this, '_ItemStats')); } function BuildCache() { define('dbhost', $this->host); define('dbname', $this->db); define('dbuser', $this->user); define('dbpass', $this->password); define('item_cache_table', 'item_cache'); $this->item_cache = new ItemCache(); } . . .

If it survives lines 62 and 63 which is including and creating an instance of the class using the constructor I'm stunned that it can't find the BuildCache() function. Are you sure your versions of these files look the same as my code here?

I have re uploaded the files puitemstats.php and itemstats.php. And now it's working. It's really strange because the code in the files were exactly the same.

Thank you so much sirhara.

I seem to get similar problems with other joomla mods - errors reported then you go away for a while, come back then everything works... Strange.

Enjoy the plugin and please bump anyone else who has tried this and it works so I can get more confirmation. Thanks.

Just installed it and I have 2 problems. First, when I put an item link i get the following:

Code:

Failed to update item: Sun Touched Satchel (Column count doesn't match value count at row 1)

I guess this has to do with the item_cache table? I don't have it in the DB, even after uninstall/reinstall. 2nd issue, I get the following error in the website log:

Code:

PHP Notice: Undefined variable: DEBUG in /var/www/prophecy/html/plugins/content/itemstats/includes/sqlhelper.php on line 65

Note, that I dont have eqdkp installed, just the puitemstats. Thanks.

feil75 wrote:

QUOTE:
Just installed it and I have 2 problems. First, when I put an item link i get the following:

Code:

Failed to update item: Sun Touched Satchel (Column count doesn't match value count at row 1)

I guess this has to do with the item_cache table? I don't have it in the DB, even after uninstall/reinstall. 2nd issue, I get the following error in the website log:

Code:

PHP Notice: Undefined variable: DEBUG in /var/www/prophecy/html/plugins/content/itemstats/includes/sqlhelper.php on line 65

Note, that I dont have eqdkp installed, just the puitemstats. Thanks.

OK that debug handling might need changing for joomla 1.5 I'll take a look tomorrow but it's nothing to worry about just annoying. The first error is suggesting that you DO have the item_cache table but that it's the wrong "shape", i.e. the wrong number of columns, and indeed, it is!!! The fix is fairly trivial and I'll have it for you in the morning (8 hours from now ).

OK,

I've uploaded a new version use the same link above or here's that same link again:

puitemstats-2.0.zip

However you will still need to run some separate code to fix the problem. The previous version created a broken item_cache table so you need to manually delete it and let the code create a new one for you. So either using some kind of GUI manager such as phpmyadmin or use mysql from a terminal and connect to the database then delete the table. The deletion SQL is:

Code:

drop table item_cache;

Once you have deleted the table, install the updated version of the plugin and hopefully it will work this time. The bug you have found will exist for anyone who doesn't already have eqdkp installed (which would have created the correct version of the item_cache table).

Great job, works perfectly. Thanks again.

Do you have any plans to integrate with Fireboard (v1.0.4)?

I'm not using it myself, but If I get some more time I'll take a look at it.

Sirhara,

Would like to say thank you for converting this mod over to Wowhead firstly. However I have a small problem. My mouseover is working just fine and all, except that the images or icons for the items are not showing up. It is just showing the [?] box. Do the icons for these items need to be stored locally or remotely? Also, is there a way to check to see where I have it pointed to?

Thanks,
Thunda

Hmmm,

Are you using eqdkp as well or just itemstats standalone?

It might need to force an update somehow or it might be that it's not configured properly.

Go to your Joomla Administration page. Extensions -> Plugins -> PUItemstats.

Check all the parameters on the right hand side. Specifically if you want to download the icons and store them locally you need to create the "wowhead_icons" directory (or whatever you want to call it) and make it writeable by the web server. If you are unsure about this you can confirm this is the problem by just turning off local storage for a test.

If this is not your problem let me know and I'll see if there's something I need to change.

sirhara wrote:

QUOTE:
Hmmm,

Are you using eqdkp as well or just itemstats standalone?

It might need to force an update somehow or it might be that it's not configured properly.

Go to your Joomla Administration page. Extensions -> Plugins -> PUItemstats.

Check all the parameters on the right hand side. Specifically if you want to download the icons and store them locally you need to create the "wowhead_icons" directory (or whatever you want to call it) and make it writeable by the web server. If you are unsure about this you can confirm this is the problem by just turning off local storage for a test.

If this is not your problem let me know and I�