##############################################################
## MOD Title: Itemstats
## MOD Author: John Ohl < NA > (John Ohl) http://forums.eqdkp.com/index.php?showtopic=3331
## MOD Description: Item stats download from Allakhazam, including item set bonuses.
## MOD Version: 1.3.1
##
## Installation Level: easy
## Installation Time: 1 Minute using EM
## Files To Edit: 2
##  includes/bbcode.php
##  templates/subSilver/overall_header.tpl
## Included Files: 42
##
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##   Be sure to adjust the settings in your itemstats/config.php
## before installing this MOD to avoid any problems after installed...
#################################################################
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
Open 'itemstats/config.php'.  This file contains all configurations for itemstats.  You'll see the following lines in this file:

define('dbhost', 'localhost');
define('dbname', 'DBNAME');
define('dbuser', 'DBUSER');
define('dbpass', 'DBPASS');
define('item_cache_table', 'item_cache')

Simply replace the 'localhost', 'itemdb', 'user', 'pass' and 'items_cache' strings with values that match your SQL setup.  Leave this file open for now, you might need it in the next part.

2. Icon store
You may wish to create a local store of icons on your server.  This helps to reduce the bandwidth between your server and allakhazam.  I would say it also speeds up your page refreshes, but it's actually the opposite in my case.  I still use my own local cache out of respect for Allakhazam's bandwith.  The default installation points to allakhazam.  If you wish to change this, open 'itemstats/config.php' and look for the following lines:

define('ICON_STORE_LOCATION', 'http://wow.allakhazam.com/images/icons/');
define('ICON_EXTENSION', '.png');

3. Stylesheet: itemstats/itemstats.css
This stylesheet is used to display the HTML for this mod.  You can modify this file to match your taste.  It has some comments that try to explain where each style is used.

#
#-----[ COPY ]------------------------------------------
#
copy *.php to *.php
copy includes/*.* to includes/*.*
copy overlib/*.* to overlib/*.*
copy overlib/Mini/*.* to overlib/Mini/*.*
copy templates/*.* to templates/*.*
copy templates/*.* to templates/subSilver/*.*

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE 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)
);

#
#-----[ OPEN ]------------------------------------------
#
includes/bbcode.php
#
#-----[ FIND ]------------------------------------------
#
define("BBCODE_UID_LEN", 10);
#
#-----[ AFTER, ADD ]------------------------------------------
#
include('./itemstats/phpbb_itemstats.php');
#
#-----[ FIND ]------------------------------------------
#
global $lang, $bbcode_tpl;
#
#-----[ AFTER, ADD ]------------------------------------------
#

// Parse text for ItemStats mod
$text = itemstats_parse($text);
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl
#
#-----[ FIND ]------------------------------------------
#
link rel="stylesheet"
#
#-----[ AFTER, ADD ]------------------------------------------
#
<link rel="stylesheet" href="itemstats/templates/itemstats.css" type="text/css">

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM