Mostrar TOP POST de un FORO

[kind]

Bueno, estuve analizando la funsion del SSI.php que es esta: <?php ssi_topTopicsReplies(); ?>
pero no logre modificarla para que tome los mejores post de X foros, si puediese ser de varios seria mejor, alguien sabe?

[lucas-ruroken]

podrias buscar en el SSI.php la funcion esa
y donde hace la consulta agregar
where b.ID_BOARD = 'x'

donde x es el id de tu foro

Saludos

[kind]

No che, no me funciona.... =/

Mira, te dejo el codigo:

Koodi [Valitse] Laajenna

$request = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}topics
WHERE num" . ($type != 'replies' ? 'Views' : 'Replies') . " != 0
ORDER BY num" . ($type != 'replies' ? 'Views' : 'Replies') . " DESC
LIMIT 100", __FILE__, __LINE__);
$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
$topic_ids[] = $row['ID_TOPIC'];
mysql_free_result($request);
}
else
$topic_ids = array();

$request = db_query("
SELECT m.subject, m.ID_TOPIC, t.numViews, t.numReplies
FROM ({$db_prefix}topics AS t, {$db_prefix}messages AS m, {$db_prefix}boards AS b)
WHERE m.ID_MSG = t.ID_FIRST_MSG
AND t.ID_BOARD = b.ID_BOARD" . (!empty($topic_ids) ? "
AND t.ID_TOPIC IN (" . implode(', ', $topic_ids) . ")" : '') . "
AND $user_info[query_see_board]" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND b.ID_BOARD != $modSettings[recycle_board]" : '') . "
ORDER BY t.num" . ($type != 'replies' ? 'Views' : 'Replies') . " DESC
LIMIT $num_topics", __FILE__, __LINE__);

[lucas-ruroken]

 WHERE m.ID_MSG = t.ID_FIRST_MSG
depues de eso agrega

and b.ID_BOARD = 'idtuforo'

y si queres agregar mas pone

and b.ID_BOARD y asiii

[kind]

sos un capo lukitas
me re sirvio...

[lucas-ruroken]

faaaa jajak
bueno me alegro qe te halla servido

saludos