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
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...
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)
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?
does somebody know the Var for the "Date of Topic", so we can add it at the SELECT criteria?
Do you still require assistance with this? :)
Quote from: H on January 03, 2009, 06:53:58 AM
Do you still require assistance with this? :)
yes i do ::)