[Vivi Ornitier]

i'm waaay to busy to do anything else right now. I'm working hard on my site, which i'm gonna release soon, not to mention the forums.

One quik update here: i noticed that the functions.php can add couple hundreds of queries depending on the number of posts in a thread.here's the fix:

find in showthread.php (twice):

	LEFT JOIN userfield ON userfield.userid=user.userid

below it add

	LEFT JOIN items_user ON items_user.userid=user.userid

[b]change the functions.php part to:

	if($post[item0]!='No Item') {
	$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[itid0]\"><img src=\"{imagesfolder}/itemshop/prs.gif\" border=\"0\"></a> ";
	} else {
	$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\"> ";
	}


$nr=1;
while ($nr <= 3) {
$xc="item$nr";
	if($post[$xc]!='No Item') {
		$xvv = "item$nr";
		$xv = "itid$nr";
		$xvvv = "icon$nr";
		if(empty($post[$xvvv])) {
		$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvv].gif\" border=\"0\"></a> ";
		} else {
		$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvvv].gif\" border=\"0\"></a> ";
		}
	} else {
	$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\"> ";
	}
$nr++;
}