| Vivi Ornitier |
05-11-2002 07:26 PM |
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):
Code:
LEFT JOIN userfield ON userfield.userid=user.userid
below it add
Code:
LEFT JOIN items_user ON items_user.userid=user.userid
[b]change the functions.php part to:
Code:
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++;
}
|
More Information