I coded something similar for Joomla 1.0.x.
Prerequisite for working with itemstats is an installed version of puitemstats mambot and of course an installation of eqdkp.
You can get it here

Updated.
You now can choose whether to display latest items or unique latest items.

Hello Reznor

Can you implement in Loot History somehow, the ability to display, how much each time costed, in dkp?
You can see a demonstration of what i mean here: http://www.ateamguild.com/v2/index.php (the right column).

It will be more informative that way i think

Ty again for all the hard work

Updated

Hello Reznor.

Have problem with this and also with Bossprogress.

Although i have put all the related info the module ask (i copied / paste it from my dkp config file), i have the following error:

Table ***** doesn't exist SQL=SELECT item_name, item_buyer, item_value, item_date FROM **** by item_date asc

Wrong database selected?

I have sent you the *** in a pm, as i dont want to be displayed in a pm.

What i can assume that is wrong, is maybe eqdkp plus 0.6 i use? You can check my dkp here: http://www.mysamurai.eu/v6/dkp/

Hope we can find a solution for this

Solution for everyone with similar problems:
In module configuration at "EQDKP table prefix" just enter "prefixname".
The module adds the "_" itself, entering "prefixname_" would result in "prefixname__raids" which is wrong and leads to this error message.

For everyone who's using my module with puitemstats and allakhazam to fetch item info:
allakhazam has changed its xml-url.
So every new item will be gray with no info.

To fix this, update to the right url in:

../mambots/content/itemstats/includes/allakhazam.php

Around line 99:

Code: Select all

// Retrieve the XML for this item from Allakhazam.
$xml_data = itemstats_read_url('http://wow.allakhazam.com/dev/wow/item-xml.pl?witem=' . $item_id);

and change it to:

Code: Select all

// Retrieve the XML for this item from Allakhazam.
$xml_data = itemstats_read_url('http://wow.allakhazam.com/cluster/item-xml.pl?witem=' . $item_id);

This should fix the problem.

If your already grey items don't update automatically, you have to delete the database entries afterwards to those items:

Launch phpmyadmin or mysql, select your joomla database and execute the following sql statement:

Code: Select all

DELETE FROM item_cache WHERE item_link IS NULL ;

Example in shell:

Code: Select all

$ mysql DATABASENAME
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 894056
Server version: 5.0.54 Gentoo Linux mysql-5.0.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DELETE FROM item_cache WHERE item_link IS NULL ;
Query OK, 3 rows affected (0.07 sec)

mysql> quit
Bye
$

In this case there were three gray items in puitemstat's item_cache table.

Hope this helps

Greets,
Reznor

I get an error: http://www.gilde-progressive.de

Warning: main(/configuration.php) [function.main]: failed to open stream: No such file or directory in /var/www/web7/html/Joomla3/mambots/content/itemstats/includes/itemcache.php on line 3

Fatal error: main() [function.require]: Failed opening required '/configuration.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web7/html/Joomla3/mambots/content/itemstats/includes/itemcache.php on line 3

Hello Again,

Is it easy, to have Latest Items to work with Wowdb.com ? I sychronised my site with it and dont need any joomla bot at all. You can see it here:

http://www.mysamurai.eu/v6

So we can have it without install any bot (its now well known that the bot in some sites its working and in other not).

Also, in eqdkp plus, there is the ability to have different loot pools. If we can set for example a copy of this module to be on Epics, a second one on Weapons and third one on T6, will be marvelous

I have done something like this on my site, though its manually edit
Hope you can help, ty

Hi Reznor,

i´ve installed the modul but now i have the problem that the icons do not show and the tooltip on mouseover does look ugly, as you can see www.gilde-progressive.de - here.

cerb3ros wrote:Hello Again,

Is it easy, to have Latest Items to work with Wowdb.com ? I sychronised my site with it and dont need any joomla bot at all. You can see it here:

http://www.mysamurai.eu/v6

So we can have it without install any bot (its now well known that the bot in some sites its working and in other not).

Also, in eqdkp plus, there is the ability to have different loot pools. If we can set for example a copy of this module to be on Epics, a second one on Weapons and third one on T6, will be marvelous

I have done something like this on my site, though its manually edit
Hope you can help, ty

Did I get u right, have you managed to use wowdb to show itemlinks on your site... please tell me how?