Joomla Module / SMF - hot topics

[bkl]

hello,

i'm using joomla 1.0.12 + SMF 1.1.7 (unwrapped) + the "recent Topic Mod"
it would be nice to get another list of "top topics of the week"

Do you know an existing joomla mod, which is able to show this list?

i mean a list, like the one from the board-statistics (top by answers or by clicks) during a certain timeperiod (last 7 days)

cheers

[palofdru]

What criteria are you using to determine "Top" ??

SMF has functions (prebuilt) Top Views, and Top Replies

http://www.simplemachines.org/community/ssi_examples.php

You can unzip your mod , make a few changes and zip it back up - then install it as you like.

Upload your Joomla mod or post the code and we'll take a look and show you what to edit.

It's really quite easy.


PS. I dont think the version of Joomla you have is the most secure version though...

[bkl]

wow, that ssi feature is new for me 

and "ssi_topTopicsViews" is the right part of it, but do you think it is possible to add a time-period to the SELECT criteria? (top topics of the last 7 days)

Code Select Expand


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__);

unfortunately every change in ssi.php would be lost by the next upgrade, right?

[bkl]

does somebody know the Var for the "Date of Topic", so we can add it at the SELECT criteria?

[H]

Do you still require assistance with this?

[bkl]

Do you still require assistance with this?

yes i do