block-Forums.php error !!!

Corporal Joined: Apr 14, 2003 Posts: 64

hi there

I have installed ver 6.5
but there is seemse to be a problem with forums block.

only the new topics are being dispayed by time posted
and does not apply for replies

so for example, if somebody opens an new topic
that topic will stay on top of forums block
until another NEW topic has been posted

in short words, forums block
is only working for NEW TOPICS
and NOT for NEW REPLIES

any idea?

thank you

p.s. this is my code fot block-forums.php

Quote:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com) */
/* http://phpnuke.org */
/* */
/* This is a 2 min hack of the old forum block to work with the phpBB2 */
/* port. */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
if (eregi("block-Forums.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}
global $prefix, $dbi, $sitename;
$result = sql_query("SELECT forum_id, topic_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_time DESC LIMIT 10", $dbi);
$content = "<center> Last Subisions</center> ";
while(list($forum_id, $topic_id, $topic_title) = sql_fetch_row($result, $dbi)) {

$topic_title = substr("$topic_title", 0,15);
$result1 = sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'", $dbi );
list( $auth_view, $auth_read ) = sql_fetch_row( $result1, $dbi );
if( ( $auth_view != 2 ) or ( $auth_read != 2 ) ) {
$content .= "<img src=\"images/blocks/icon_mini_message.gif\" border=\"0\" alt=\"\" width=\"13\" height=\"14\">&<a href=\"postt.html$topic_id\">$topic_title...</a> ";
}
}
$content .= " <center><a href=\"modules.php?name=Forums\">Forums</a></center>";

?>

Can anyone help? Crying or Very sad

Posted: Thu Jun 12, 2003 12:47 pm

Try this block instead.
http://www.nukecops.com/postp20498.html#20498

mikem