eqDKP 1.4.0 Installation

#
#-----[ SQL, REQUEST ]------------------------------------------
#

DROP TABLE IF EXISTS `wardb_itemcache`;
CREATE TABLE `wardb_itemcache` (
  `id` int(32) NOT NULL,
  `name_en` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
#-----[ OPEN ]------------------------------------------
#

eqdkp/templates/default/page_header.html

#
#-----[ FIND ]------------------------------------------
#

</head>

#
#-----[ BEFORE, ADD ]------------------------------------------
#

<script src="http://www.wardb.com/js/extooltips.js" type="text/javascript"></script>

#
#-----[ OPEN ]------------------------------------------
#

eqdkp/includes/functions_paths.php

#
#-----[ FIND ]------------------------------------------
#

function item_path($id = null)
{
	if ( !is_null($id) )
    {

#
#-----[ AFTER, ADD ]------------------------------------------
#

		return 'http://www.wardb.com/item.aspx?id='.wardb_getRealId($id).'" class="wardb-item-full-small';

#
#-----[ FIND ]------------------------------------------
#

    $admin = ( defined('IN_ADMIN') ) ? 'admin/' : '';
    return path_default("{$admin}listitems.php");
}

#
#-----[ AFTER, ADD ]------------------------------------------
#

function wardb_getRealId($id)
{
	global $db;
	$name = $db->query_first("SELECT `item_name` FROM `__items` WHERE (`item_id` = '" . $db->escape($id) . "')");
	$result = $db->query_first("SELECT `id` FROM `wardb_itemcache` WHERE `name_en` = '".str_replace("'", "\'", $name)."'");
	if ($result) {
		return $result;
	} else {
		$id = file_get_contents("http://www.wardb.com/ajaxIDLookup.aspx?type=1&name=".urlencode($name));
		if ($id != "" and $id != "0") {
			$db->query("INSERT INTO `wardb_itemcache` SET `name_en` = '".str_replace("'", "\'", $name)."', id = '".$id."'");
			return $id;
		} else
			return 0;
	}
}

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