[zurih]

Link14716 thanks for the explanation

rake,
I'm getting database error when adding those lines
I added

PHP Code:

LEFT JOIN ".TABLE_PREFIX."forum ON (thread.forumid = forum.forumid) 


I've done it wrong?

here is the code, just tell where to add the thing u wrote

PHP Code:

SELECT pagetext, thread.*,thread.iconid AS threadiconid $previewfield
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin
WHERE open = '1'
AND thread.dateline > $cut
AND forumid NOT IN (0$limitfids)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 5"); 


plus, what should I add to display it in the template?

like this is the thread title:

PHP Code:

$thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 68)); 


thanks