[psyker7]

Edited so the full instructions are near front of this post:

Be warned that this is a total hack and isn't easy to read

http://anzacsguild.c...tpoints.php.txt
http://anzacsguild.c...points.html.txt

setpoints.php belongs in the eqdkp root directory
setpoints.html belongs in the eqdkp/templates/default directory

To change point values etc, edit setpoints.php

The bit in between lines

$message = '<table width="100%" border="0" cellspacing="1" cellpadding="2">

after the ' down to the line

';

is simply an html document, copy it into a blank document to see what it will look like, do the editing then copy it back in between the quotes in the php document.
What the php does is run this html document through the itemstats parser so that everytime it comes across the [item][/item] tags it converts it to a mouseover link.

Make sure you add a "\" before every ' inside the message text.
For example:

Onyxia's Lair
becomes
Onyxia\'s Lair

Otherwise the php read closing the $message variable too early and returns an error message.

For those trying to get the [itemicon] [/itemicon] tags to work, I added a custom function to phpbb_itemstats.php

basically:

~~~~~~~~~
Open itemstats/phpbb_itemstats.php
~~~~~~~~~
AFTER
~~~~~~~~~

// Finally, replace the bbcode with the html.

		$message = str_replace($match[0], $item_html, $message);

	}

~~~~~~~~~
INSERT
~~~~~~~~~

while (preg_match('#\[itemicon\](.+?)\[/itemicon\]#s', $message, $match))

	{

		// Grab the item name.

		$item_name = $match[1];



		// Get the proper name of this item.

		$item_name = $item_stats->getItemName($item_name, true);

		//Initialize the icon

		$item_icon =  $item_name;

		

		// Add the icon to the name.
		$item_icon_link = $item_stats->getItemIconLink($item_name);
		if (!empty($item_icon_link))
		{
			$item_icon = "<img class='smallitemicon' src='" . $item_icon_link . "'> ";
		}

		// Get the tooltip html for this item and apply it to the html.

		$item_tooltip_html = $item_stats->getItemTooltipHtml($item_name);

		if (!empty($item_tooltip_html))

		{

			$item_icon = "<span " . $item_tooltip_html . ">" . $item_icon . "</span>";

		}



		// If this item has a link to the info site, add this link to the HTML.  If it doesn't have a link, it

		// means the item hasn't been found yet, so put up a link to the update page instead.

		$item_link = $item_stats->getItemLink($item_name);

		if (!empty($item_link))

		{

			$item_icon = "<a class='forumitemlink' target='_blank' href='" . $item_link . "'>" . $item_icon . "</a>";

		}

		else

		{

			$item_link = 'itemstats/updateitem.php?item=' . urlencode(urlencode($item_name));

			$item_icon = "<a class='forumitemlink' href='$item_link'>" . $item_icon . "</a>";

		}


		// Finally, replace the bbcode with the html.

		$message = str_replace($match[0], $item_icon, $message);

	}

Hope it helps


If you are having troubles, you may be using a different version of itemstats.
http://forums.eqdkp....?showtopic=3331 is the version installed on my website.
Use the "common errors" thread below that if you have trouble installing.

Also

Annoar, on Mar 1 2006, 04:22 AM, said:

for anyone who uses this there is an additional piece of info u need. everythign in the <newpage>.php that you want displated on screen is contained within apostrophes.. 'like this'. but many items names contain apostrophes such as [Mar'li's Touch], and each time the code sees an apostrophe it thinks its the stop/start of the main pair. After pulling a fair amount of my hair out i found the solution on on Anzacs setpoints.php Wherever an apostrophe is preceded by a \ its simply printed to screen and not mistaken for code. Simply write it as [item]Mar\'li\'s Touch[/item].

Hope that saves people some time/stress

[psyker7]

so you need the php to pull that from the database?

Take a look at viewnews.php....

didnt test it but something like this:

<?php
/******************************
 * EQdkp
 * Copyright 2002-2003
 * Licensed under the GNU GPL.  See COPYING for full terms.
 * ------------------
 * viewnews.php
 * Began: Sat April 5 2003
 * 
 * $Id: rules.php,v 1.3 2003/08/16 21:09:08 tsigo Exp $
 * 
 ******************************/
 
define('EQDKP_INC', true);
$eqdkp_root_path = './';
include_once($eqdkp_root_path . 'common.php');
include_once($eqdkp_root_path . 'itemstats/eqdkp_itemstats.php');



$sql = 'SELECT rules_title rules_text
		FROM CG_TKP_rules';
$result = $db->query($sql);

if ( $db->num_rows($result) == 0 )
{
	message_die($user->lang['no_rules']);
}

$cur_hash = hash_filename("rules.php");
// print"HASH::$cur_hash::<br>";

while ( $rules = $db->fetch_record($result) )
{
	
	$message = $rules['rules_text'];
	$message = nl2br($message);
	news_parse($message);
	$message = preg_replace('#(\&amp;){2,}#', '&amp;', $message);
	$message = itemstats_parse($message);
	
	$tpl->assign_block_vars('rules_row', array(
		'ROW_CLASS' => $eqdkp->switch_row_class(),
		'HEADLINE' => stripslashes($['rules_title']),
		'MESSAGE' => $message)
	);
}
$db->free_result($result);



$eqdkp->set_vars(array(
	'page_title'	=> sprintf($user->lang['title_prefix'], $eqdkp->config['guildtag'], $eqdkp->config['dkp_name']),
	'template_file' => 'rules.html',
	'display'	   => true)
);
?>

should work if you edit rules.html properly.

[psyker7]

try

<!-- INCLUDE page_header.html -->
<!-- INCLUDE sidemenu.html -->
<table width="100%" border="0" cellspacing="1" cellpadding="2">
  <!-- BEGIN rules_row -->
  <tr>
	<td>
	  <b style="font-size:13px">{rules_row.HEADLINE}</b> <br /><br />
	  {rules_row.MESSAGE}
	</td>
  </tr>
  <!-- END rules_row -->
  <tr>
	<th class="footer">&nbsp;</th>
  </tr>
</table>
<!-- INCLUDE page_tail.html -->

[psyker7]

As i said i didn't test it....

line 44 is
'HEADLINE' => stripslashes($['rules_title']),



my bad...

should be

'HEADLINE' => stripslashes($rules['rules_title']),

[psyker7]

can't be sure without actually doing it all and i'm a bit lazy to set up a database just for this
From what I figure it should be working...

Wouldn't simply having a static page be easier anyway??

[psyker7]

Few small things.

{
	message_die($user->lang['no_rules']);
}

Replace with

{
	message_die($user->lang['no_news']);
}

Try adding a ";" after

while ( $rules = $db->fetch_record($result) )
{
	
	$message = $rules['rules_text'];
	$message = nl2br($message);
	news_parse($message);
	$message = preg_replace('#(\&){2,}#', '&', $message);
	$message = itemstats_parse($message);
	
	$tpl->assign_block_vars('rules_row', array(
		'ROW_CLASS' => $eqdkp->switch_row_class(),
		'HEADLINE' => stripslashes($['rules_title']),
		'MESSAGE' => $message)
	);
}

What my page was doing but is exactly the same as what you are wanting, minus the fiddling with databases.... /shrug