Yes. Take the 5 lines above it to the 5 lines below the error and post all of those.

$post=$DB_site->query_first("
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '$postid'
");

if (!$getperms['cangetattachment']) {
$viewattachedimages=0;
}

$postbits = getpostbit($post);

updateuserforum($thread['forumid']);

eval("dooutput(\"".gettemplate("showpost")."\");") ;
exit;
}

Which line is the line with the error in it (line 94, I think)?

LEFT JOIN customavatar ON customavatar.userid=user.userid","")."

Try changing this:

to this:

and let me know if it works. If it doesn't, make sure you put the code back as it was and we will go from there. :)

You need to delete this message. You can't post your php files for download. :) This is according to the vBulletin licensing agreement.

sorry :cry:

i resolve the problem but the quick reply don't appear :(

ok Quick reply go ON ;)

How can I set it that when you use the quick reply box, people are automatically subscribed to the thread and receive email notification when there is a reply? :)