Simple Machines Community Forum

SMF Support => EspaƱol (Spanish) => Language Specific Support => Modificaciones (Mods) => Aiheen aloitti: kind - elokuu 12, 2009, 11:29:15 AP

Otsikko: Mostrar TOP POST de un FORO
Kirjoitti: kind - elokuu 12, 2009, 11:29:15 AP
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?
Otsikko: Re: Mostrar TOP POST de un FORO
Kirjoitti: lucas-ruroken - elokuu 12, 2009, 12:11:34 IP
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
Otsikko: Re: Mostrar TOP POST de un FORO
Kirjoitti: kind - elokuu 12, 2009, 03:57:32 IP
No che, no me funciona.... =/

Mira, te dejo el codigo:

$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__);
Otsikko: Re: Mostrar TOP POST de un FORO
Kirjoitti: lucas-ruroken - elokuu 12, 2009, 06:06:53 IP
 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
Otsikko: Re: Mostrar TOP POST de un FORO
Kirjoitti: kind - elokuu 12, 2009, 09:20:37 IP
sos un capo lukitas :P
me re sirvio...
Otsikko: Re: Mostrar TOP POST de un FORO
Kirjoitti: lucas-ruroken - elokuu 12, 2009, 09:48:12 IP
faaaa jajak :P
bueno me alegro qe te halla servido ;)

saludos