Topic: Recent Posts and Topics in Simpleportal

[infostrides]

Hello, I will like to change the display period of Recent Posts and Topics in Simpleportal homepage.

I have used Recent Posts/Topics in my forum home (http://www.theinfostrides.com) and observed that the posts disappear after 48 hours. Is it possible to change the period?

Thank you.

[AngelinaBelle]

Actually, posts disappear from recent activity after a certain number of posts have been added to the database.
The "recent" function only looks back so many posts. This is to prvent it from checcking the ENTIRE database, all the way back to the beginning.You can see this in SSI.php. Look for the lines that include "35" in them.
Then increase that 35 to something larger, like maybe 100. that should normally be plenty.

[infostrides]

Thank you. I made the change and will be observing it.

[AngelinaBelle]

Did that solve your problem?

[infostrides]

Did that solve your problem?

Thanks. It worked. What is the implication if the value is increased above 100?

[Eliana Tamerin]

The higher the value, the more posts the database will search through. On big forums, this can bog down the server, and it can even happen on shared hosting when lots of databases are running in a high-stress environment. However, if you have a small forum on a healthy server with a sparse population...you shouldn't need to worry.

[infostrides]

The higher the value, the more posts the database will search through. On big forums, this can bog down the server, and it can even happen on shared hosting when lots of databases are running in a high-stress environment. However, if you have a small forum on a healthy server with a sparse population...you shouldn't need to worry.

Thank you.

[albertng]

Thank you. I made the change and will be observing it.

dear Angelinabelle and all experts:

I have faced the same problem.
could you kindly elaborate further the codes that need to increase from 35 to 100? and explain the code a little bit as I am a newbie.
TQ so much.

[albertng]

part of the codes and what we need to do to lengthen the period of recent posts:

Could it be modified to be based on certain number of APPROVED posts rather than after certain number of postings....TQ for your expert help.

~~~~~~~~~~~~~~~~~~~~

/ Recent post list:   [board] Subject by Poster   Date
function ssi_recentPosts($num_recent = 8, $exclude_boards = null, $include_boards = null, $output_method = 'echo', $limit_body = true)
{
   global $context, $settings, $scripturl, $txt, $db_prefix, $user_info;
   global $modSettings, $smcFunc;

   // Excluding certain boards...
   if ($exclude_boards === null && !empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0)
      $exclude_boards = array($modSettings['recycle_board']);
   else
      $exclude_boards = empty($exclude_boards) ? array() : (is_array($exclude_boards) ? $exclude_boards : array($exclude_boards));

   // What about including certain boards - note we do some protection here as pre-2.0 didn't have this parameter.
   if (is_array($include_boards) || (int) $include_boards === $include_boards)
   {
      $include_boards = is_array($include_boards) ? $include_boards : array($include_boards);
   }
   elseif ($include_boards != null)
   {
      $include_boards = array();
   }

   // Let's restrict the query boys (and girls)
   $query_where = '
      m.id_msg >= {int:min_message_id}
      ' . (empty($exclude_boards) ? '' : '
      AND b.id_board NOT IN ({array_int:exclude_boards})') . '
      ' . ($include_boards === null ? '' : '
      AND b.id_board IN ({array_int:include_boards})') . '
      AND {query_wanna_see_board}' . ($modSettings['postmod_active'] ? '
      AND m.approved = {int:is_approved}' : '');

   $query_where_params = array(
      'is_approved' => 1,
      'include_boards' => $include_boards === null ? '' : $include_boards,
      'exclude_boards' => empty($exclude_boards) ? '' : $exclude_boards,
      'min_message_id' => $modSettings['maxMsgID'] - 25 * min($num_recent, 5),
   );

   // Past to this simpleton of a function...
   return ssi_queryPosts($query_where, $query_where_params, $num_recent, 'm.id_msg DESC', $output_method, $limit_body);
}

[ccbtimewiz]

What are you asking?

[albertng]

“Actually, posts disappear from recent activity after a certain number of posts have been added to the database. The "recent" function only looks back so many posts………”

My question is how could the codes  be modified to after certain number of APPROVED posts rather than after certain number of posts as it is now....TQ for your expert help.

[albertng]

Could anybody help with my problems as above. This would be useful for many users of simple portal too...

TQ so much.

Albert Ng

[albertng]

“Actually, posts disappear from recent activity after a certain number of posts have been added to the database. The "recent" function only looks back so many posts………”

My question is how could the codes  be modified to after certain number of APPROVED posts rather than after certain number of posts as it is now....TQ for your expert help.

Could any expert help with the problem stated above? TQ.

[AngelinaBelle]

I see the number 25 in your ssi.php.

Replace the 25 to 100.

That will show more posts.