phpBB.de

New post count on index

Description:
Displays the number of posts next to the "New posts" link on the board index.

view new posts number since last visit
Description:
This mod show "view new posts number" since last visit

Title: New post count on index
Description:
Displays the number of posts next to the "New posts" link on the board index.
Version:
1.0.2
Installation Level:
Easy
Installation Time:
~3minutes
Author
Username: christian
Email: milanoa@centrum.cz
Name: Vaclav Krejza
WWW: http://www.phpbb.cz

Files to Edit
index.php
Included Files
No files have been included with this MOD.
-------------------------------------------------------------------------------
Disclaimer
For security purposes, please check: http://www.phpbb.com/mods/ for the latest version of this MOD. Downloading this MOD from other sites could cause malicious code to enter into your phpBB Forum. As such, phpBB will not offer support for MODs not offered in our MODs database, located at: http://www.phpbb.com/mods/

Author Notes
MOD History
2007-09-20 - Version 1.0.2
[Fix] Memory optimalization of SQL query.
[Fix] Fixed for MODX validity
2007-08-06 - Version 1.0.1
[Fix] Properly find the number of posts, in compilance with the DBAL.
2007-08-04 - Version 1.0.0
Initial release

License
This MOD has been licensed under the following license:

http://opensource.org/licenses/gpl-license.php GNU General Public License v2

Other Notes
Before adding this MOD to your forum, you should back up all files related to this MOD

This MOD was designed for phpBB3.0.0 and may not function as stated on other phpBB versions. MODs for phpBB3.0 will not work on phpBB2.0 and vice versa.
--------------------------------------------------------------------------------
Open: index.php
Find
Tip: This may be a partial find and not the whole line.

Code: Alles auswählen

// Assign index specific vars
$template->assign_vars(array(

Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.

Code: Alles auswählen

$sql = 'SELECT COUNT(post_id) as count
    FROM ' . POSTS_TABLE . ' 
		WHERE post_time > ' . $user->data['user_lastvisit'] . '
    AND poster_id != ' . $user->data['user_id'];

$result = $db->sql_query($sql);
$post_count = $db->sql_fetchfield('count', false, $result);
$db->sql_freeresult($result);

Find
Tip: This may be a partial find and not the whole line.

Code: Alles auswählen

'BIRTHDAY_LIST'	=> $birthday_list,

Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Alles auswählen

 'NEW_POST_COUNT' => $post_count ,

--------------------------------------------------------------------------------
Save all files. End of MOD.
You have finished the installation for this MOD. Upload all changed files to your website. If the installation went bad, simply restore your backed up files.
MOD UA XSLT File Copyright © 2007 The phpBB Group, this MOD is copyright to the authors listed above.

Open: styles/prosilver/template/index_body.html

Find
Tip: This may be a partial find and not the whole line.

Code: Alles auswählen

<li><a href="{U_SEARCH_UNANSWERED}">{L_SEARCH_UNANSWERED}</a><!-- IF S_USER_LOGGED_IN --> &bull; <a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a><!-- ENDIF --> &bull; <a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></li>

In-line Find
Tip: This is a partial match of a line for in-line operations.

Code: Alles auswählen

{L_SEARCH_NEW}

In-line Add after

Code: Alles auswählen

 ({NEW_POST_COUNT})