Ayuda En Una Consulta

[arkarian]

Bueno pues tengo este codigo, pero lo que no entiendo de aqui, que este codigo mira la base y mira que rango tiene el foro, si el foro no es visible, o si para verlo hace falta registrarse pues no aparece el foro en el portal, entonces yo quisiera que esto no fuera asi, si no que , mostrara todos los foros, sean visibles o no, esten registrados o no, como modifico este codigo para quitar eso?

este mod es el recent_ topic para ezportal.

Código: Seleccionar todo

 /////////////////////////////////////////////////////////
 //          Comienza los Ultimos Mensajes              //
/////////////////////////////////////////////////////////

$sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";

if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}

$forum_data = array();

while( $row = $db->sql_fetchrow($result) )
{
	$forum_data[] = $row;
}

$is_auth_ary = array();

$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);

if( $CFG['exceptional_forums'] == '' )
{
	$except_forum_id = '\'start\'';
}
else
{
	$except_forum_id = $CFG['exceptional_forums'];
}

for ($i = 0; $i < count($forum_data); $i++)
{
	if ((!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_read']) or (!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_view']))
	{
		if ($except_forum_id == '\'start\'')
		{
			$except_forum_id = $forum_data[$i]['forum_id'];
		}
		else
		{
			$except_forum_id .= ',' . $forum_data[$i]['forum_id'];
		}
	}
}

// Posible esto??

$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
		FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u
		WHERE t.forum_id NOT IN (" . $except_forum_id . ")
			AND t.topic_status <> 2
			AND p.post_id = t.topic_last_post_id
			AND p.poster_id = u.user_id
		ORDER BY p.post_id DESC
		LIMIT " . $CFG['number_recent_topics'];
		
if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query recent topics information', '', __LINE__, __FILE__, $sql);
}

$number_recent_topics = $db->sql_numrows($result);

// Aqui es de donde se llama desde portal_body.tpl

$recent_topic_row = array();

while ($row = $db->sql_fetchrow($result))
{
	$recent_topic_row[] = $row;
}
for ($i = 0; $i < $number_recent_topics; $i++)
{
	$template->assign_block_vars('recent_topic_row', array(
		'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_row[$i]['post_id']) . '#' .$recent_topic_row[$i]['post_id'],
		'L_TITLE' => $recent_topic_row[$i]['topic_title'],
		'U_POSTER' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $recent_topic_row[$i]['user_id']),
		'S_POSTER' => $recent_topic_row[$i]['username'],
		'S_POSTTIME' => create_date($board_config['default_dateformat'], $recent_topic_row[$i]['post_time'], $board_config['board_timezone'])
		)
	);
}
  /////////////////////////////////////////////////
 //           Finaliza los Ultimos Mensajes     //
/////////////////////////////////////////////////

[esnola]

Prueba a cambiar :

Código: Seleccionar todo

<?php////////
//De aqui para abajo

$SQL = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
        FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u
        WHERE t.forum_id NOT IN (" . $except_forum_id . ")
            AND t.topic_status <> 2
            AND p.post_id = t.topic_last_post_id
            AND p.poster_id = u.user_id
        ORDER BY p.post_id DESC
        LIMIT " . $CFG['number_recent_topics']; 

Por esto:

Código: Seleccionar todo

<?php /////////////
//Copia de aqui para abajo

$SQL = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
        FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u
        WHERE  t.topic_status <> 2
            AND p.post_id = t.topic_last_post_id
            AND p.poster_id = u.user_id
        ORDER BY p.post_id DESC
        LIMIT " . $CFG['number_recent_topics'];

[arkarian]

gracias, me aparece a trozos, es decir, ya me aparece pero vacio, el hueco esta pero no aparece los recent topics,

http://img221.imageshack.us/img221/3867/dibujoeq2.png