Advertisement:

Author Topic: Joomla Module / SMF - hot topics  (Read 10863 times)

Offline bkl

  • Newbie
  • *
  • Posts: 9
Joomla Module / SMF - hot topics
« on: November 10, 2008, 08:49:46 AM »
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

Offline palofdru

  • Jr. Member
  • **
  • Posts: 203
Re: Joomla Module / SMF - hot topics
« Reply #1 on: November 12, 2008, 08:31:54 AM »
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...
My best suggestion to you is that you do whatever you feel like doing, for whatever reason you choose to make, without any required explanation nor justification. You probably will, so hop to it!

boo hoo!

Offline bkl

  • Newbie
  • *
  • Posts: 9
Re: Joomla Module / SMF - hot topics
« Reply #2 on: November 17, 2008, 03:09:31 AM »
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]
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?
« Last Edit: November 17, 2008, 03:15:01 AM by bkl »

Offline bkl

  • Newbie
  • *
  • Posts: 9
Re: Joomla Module / SMF - hot topics
« Reply #3 on: December 08, 2008, 05:32:31 AM »
does somebody know the Var for the "Date of Topic", so we can add it at the SELECT criteria?

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Joomla Module / SMF - hot topics
« Reply #4 on: January 03, 2009, 06:53:58 AM »
Do you still require assistance with this? :)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline bkl

  • Newbie
  • *
  • Posts: 9
Re: Joomla Module / SMF - hot topics
« Reply #5 on: January 05, 2009, 03:45:13 AM »
Do you still require assistance with this? :)

yes i do  ::)