Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> cznews forums not showing

I used echo mysql_error(); directly after $result_bb and I get the following.

Unknown column 't.topic_last_post_id' in 'on clause'

I think the error is mysql 5, telli this is a modded version of $result_bb.

Fix it to fit the default for others please

$result_bb = "SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id, u.username, u.user_id, p.poster_id, p.post_time FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f, ".$prefix."_bbposts p, ".$prefix."_users u WHERE p.post_id = t.topic_last_post_id AND u.user_id = p.poster_id AND t.forum_id=f.forum_id AND f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT $offset_posts, $postnum";

Still some issues to sort out with Auth for groups and what not.

I fixed the auth just need to put the original back together and I will post the modifications.

thanks floppy. itching to try this out.