[MOD] view new posts number since last visit [1.0.0]

[angelside]

view new posts number since last visit

This is very simple modification for phpbb3.b4


Classification: Add-on
phpBB Part: header

MOD Name: view new posts number since last visit
MOD Version: 1.0.0
Author: Alexis Canver
MOD Description: This mod show "view new posts number" since last visit

Works with:

• phpBB 3.0 BETA 4
  

Features:

• show "view new posts number" since last visit
  

Language: English

Licence: GNU General Public License v2

Installation Level: Easy
Installation Time: 1 Minute
Format: Spoilers
Download File: (Spoilers below)

view new posts number since last visit

Spoiler:

Code: Select all

#
#-----[ OPEN ]------------------------------------------------
#

includes/functions.php

#
#-----[ FIND ]------------------------------------------------
#

   // Which timezone?
   $tz = ($user->data['user_id'] != ANONYMOUS) ? strval(doubleval($user->data['user_timezone'])) : strval(doubleval($config['board_timezone']));

#
#-----[ AFTER ADD ]-------------------------------------------
#

if( $user->data['user_id'] != ANONYMOUS )
{
   $sql = "SELECT COUNT(post_id) as total
         FROM " . POSTS_TABLE . "
         WHERE post_time >= " . $user->data['session_last_visit'];
   $result = $db->sql_query($sql);
   if( $result )
   {
      $row = $db->sql_fetchrow($result);
      $user->lang['SEARCH_NEW'] = $user->lang['SEARCH_NEW'] . " (" . $row['total'] . ")";
      
   }
}

#
#-----[ FIND ]------------------------------------------------
#

      'PRIVATE_MESSAGE_INFO_UNREAD'   => $l_privmsgs_text_unread,

#
#-----[ AFTER ADD ]-------------------------------------------
#

      'L_SEARCH_NEW'   => $user->lang['SEARCH_NEW'],

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

[Handyman]

Hey Alexis... nice work!
Add a poll to this topic... it should be as follows:

How would you rate this mod?

• Excellent!
  
• Very good
  
• Good
  
• Fair
  
• Poor
  

Thanks... and nice mod

~Handyman

[angelside]

Thanks, I added.

[kuld33p]

good

[LEW21 Janusz]

Next SQL query for so small improvement... Sorry, I will not use it.

[Zain]

it's true that it adds yet another query, but from a lot of forums I visit people see that function as 'required'. since they use it all the time. and, especially if one uses forums, i becomes highly usefull IMO, because you don't need to look through forums in order to find it

and AFAIK there isn't any way to join a COUNT query, or is there? I never heard of it neway

[Highway of Life]

Use this instead...

Code: Select all

if ($user->data['is_registered'])
{
    $sql = 'SELECT COUNT(post_id) as total
        FROM ' . POSTS_TABLE . '
        WHERE post_time >= ' . $user->data['session_last_visit'];
    $result = $db->sql_query($sql);
    $new_posts_count = $db->sql_fetchfield('total');
    $db->sql_freeresult($result);
}

Then in the template assign vars:

Code: Select all

'NEW_POSTS_COUNT' => $new_posts_count,

Make sure the template has: <!-- IF S_USER_LOGGED_IN --> before using {NEW_POSTS_COUNT}

Edit: @Zain, yes, there is... I've done it joining 4 tables... what did you need it for?

[Zain]

well, Handyman said it was another query ( extra load ) but I didn't know if there is a way to inner join a COUNT query, since if it is, you can ( IMO ) easily combine it with another query

[Highway of Life]

There is no other global query calling anything that it could be combined with...

However, it's a VERY light query, and if someone is really concerned about the extra query, they could send it to the cache. (or just not use the MOD )
BTW, it was Lew, not Handyman.

[Zain]

my bad my bad. quick query? maybe, maybe not. if one hasn't come in a long while.. :mrgreen:

oeh, I'm in your sig
/me should put some attention in GD