[Darco]

I stopped playing WoW a few months ago. As some of you probably noticed, I no longer provide any support for this mod. If someone wants to take up ownership, feel free. Please don't PM me asking for help. I probably won't answer.

The file attachment has been removed. Attachments have caused high bandwidth usage and this particular attachment has been downloaded over 145,000 times. Because of its popularity, I've moved it to SourceForge for hosting. -- tsigo

itemstats v1.2
==============

itemstats is just another version of the many mods that exists to add some item stats to your web pages. I don't take credit for any ideas. I found a mod that does this on these forums, picked the ideas apart and decided to make a complete overhaul of it. The main goal was to create a mod that is as self-containted as possible, and to require the most minimal changes to the system you are incorporating it in. Mostly, I just did this because I was bored and needed something to entertain myself. So take it for what it's worth.


Features:

- Item stats download from Allakhazam, including item set bonuses.

- Databased cached items to speed up the reload time of items, and make data easily accessible from multiple sources (EQdkp and phpBB installations can share data easily).

- Support for local or remote icon cache for items.

- Quick and easy to follow instructions on how to modify your EQdkp and phpBB installations.

- Minimal changes to the EQdkp and phpBB code for easy re-installation in case of upgrades.

- Easily change the look of your item display with the included stylesheet.

- Fairly clean, commented and modular code if you feel like making any changes, or are just curious on how things work.


EQdkp features:

- "mouseover" tooltips for icon and color coded item listing on the following pages: 'List Items', 'View Member', 'View Raid', 'View Event'.

- Display of item stats and links to info sites on the 'View Item' page

- New [item][/item] bbcode to the news page which creates item colored links to Allakhazam with mouse over tooltip. (The bbcode won't appear as a button in the news entry screen like other bbcodes, you'll need to manually type out the codes in your news message, ex. [item]Uber Item of Dragon Killing[/item])


phpBB features:

- New [item][/item] bbcode which creates item colored links to Allakhazam with mouse over tooltip. (The bbcode won't appear as a button in the posting screen like other bbcodes, you'll need to manually type out the codes in your message, ex. [item]Uber Item of Dragon Killing[/item])


Installation:

Download the attached zip file, unzip somewhere and follow the instructions contained in these files:

'itemstats/doc/config.txt' - Basic configuration, do this first
'itemstats/doc/eqdkp_install.txt' - How to install for EQdkp 1.0.13
'itemstats/doc/phpbb_install.txt' - How to install for phpBB 2.0.17

Change History:

Version 1.2
- Fixed regular expression to match changes to Allakhazam's search page.

Version 1.11
- Fixed a small error with the cURL code.
- Removed the reference in the xml_set_object call

Version 1.1
- Added support for cURL
- Moved all configuration options into one file (itemstats/config.php).
- Fixed item HTML for some recipes.
- Item cache database table is now created by the code if it doesn't exist.

Version 1.0
- Initial Version

Download
http://sourceforge.n...lease_id=381547

[Darco]

junesix, on Aug 23 2005, 02:37 PM, said:

Great work Darco. The feature set is amazing in this package. Do you have a website to show off some of the capabilities? I've done a bit of work on my own dkp site but if this is easier to use and has more features, I'd change over in a heartbeat.

Thanks, I started playing around with this stuff, and it got a little out of hand. It got to a point where I liked how it was setup so I thought I'd share it. Aside from the set bonuses and phpbb part, it does pretty much the same as the stuff you'll find here. Just coded a bit differently, and hopefully a little easier to install.

[Darco]

CREATE TABLE IF NOT EXISTS `item_cache` (
  `item_name` varchar(100) NOT NULL default '',
  `item_link` varchar(100) default NULL,
  `item_color` varchar(20) NOT NULL default '',
  `item_icon` varchar(50) NOT NULL default '',
  `item_html` text NOT NULL,
  UNIQUE KEY `name` (`item_name`),
  FULLTEXT KEY `data` (`item_html`)
)

I'll add it to the config.txt file for future versions, or even better yet, I should just add this to the code itself.

[Darco]

Sak, on Aug 23 2005, 06:43 PM, said:

Tried this out and working fine.

One thing though.. after I installed it cant load the memberdatabase for some reason.

DKPsite

Sak.

I see what you mean. This is strange because installing this mod should not involved making any changes to the listmembers.php file, since no items are displayed on that page. Your member database seems to be intact. I clicked on one of your raids, and then click on one of the attendees and his view member page looked fine. If you did make some changes to this file while installing this mod, either my instructions were bad or you made a mistake.

If you still haven't found the problem, maybe you can try this. Download EQdkp again, and extract only the listmembers.php file out of it. Open up the file, and open your version of this same file. Do a search for the error message that appears on your page in both files, something like "Could not obtain member information". Then start comparing code around there to see if something doesn't match up. If your file hasn't been modified, it should match up perfectly. If there are differences, then that might be the problem. Maybe you can fix it, or post the differences here.

[Telamon]

I´ve got a problem with Itemstats.
I installed all like you descriped it in your docs...
And now look at this:

http://telamon.te.oh...istitems.php?s=

Allakhazam was busy or this item does not exist. Click to search again.

Whats my mistake?

[Darco]

I'll try changing the way I open/read urls and release a new version soon. I'm not really sure I can fix that problem by changing the code. It looks like a server configuration thing. I wish I knew more about it. I'm pretty new to all this php stuff.

[Telamon]

Telamon, on Aug 23 2005, 07:57 PM, said:

I´ve got a problem with Itemstats.
I installed all like you descriped it in your docs...
And now look at this:

http://telamon.te.oh...istitems.php?s=

Allakhazam was busy or this item does not exist. Click to search again.

Whats my mistake?

Cant nobody help me?