Original phpBB port block forums bug - fix

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

That code is from the original phpBB port that Tom released when things were called _topicsbb and _forums. These days they are now _bbtopics, etc. All you have to do is simply change the table names to the ones that exist today. Example, change _topicsbb to _bbtopics.

Posted: Wed Jan 15, 2003 9:42 am

That's right, auth_view is part of the bbforums table.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Ok, so for today's tables, the code should be like this:

Code:

$result1 = sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where t.forum_id=f.forum_id and (f.auth_view=0||1||2||3) ORDER BY t.topic_last_post_id DESC LIMIT 10", $dbi);