Miscellaneous Hacks - New posts and reputation comments.

This modification is no longer available or supported.

The 3.6 port of this simple hack with some small changes.

This displays the number of new posts since your last visit & the number of new reputation comments since you last checked your usercp - both are displayed in the welcome panel.

Changes ;

* Fixed bug of them not showing on error pages.
* Either can be now turned off with a setting in vBulletin Options > Display New Posts and Reputation.

Notes:

If upgrading from the 3.5 version then you will need to re-do the template changes.
Versions 3.21+ do not require any manual template changes. See Post #167


History:

v3.11 : Initial vb 3.6 release, bug fixs and settings added.
v3.12 : Updated for Version Checking.
v3.13 : Internal code updates, not released.
v3.14 : Phrases Updated.
v3.15 : Minor code changes (not released).
v3.16 : Changes to the way displayed messages are built.
v3.17 : SQL Changes to use slave.
v3.18 : Fixed broken Index creation (on install).
v3.19 : Internal development version (not released).
v3.20 : Internal development version (not released).
v3.21 : Manual template edits removed, seperate settings group added.
v3.22 : Links prefix added.
v3.23 : Added forum viewing permissions check to count.

[Paul M]

vBulletin Options > Display New Posts and Reputation.

[Kamakazy]

aaah, great...

your a gem... thanks...

[Paul M]

Version 3.23

Since it's been asked about a number of times, I have updated the New Posts count to exclude forums that a member does not have permission to view (similar to the Unread Posts modification).

[deezelpope]

Oh dear! Everything was running great, then I updated and now I'm getting this:

Database error in vBulletin 3.6.4:Invalid SQL: SELECT COUNT(post.dateline) AS pcount FROM post AS post FORCE INDEX (dateline) INNER JOIN thread AS thread USING (threadid) WHERE dateline > 1192722160 AND thread.forumid IN (03,59,5,44,52,7,14,54,53,49,47,48,55,43,32,41,31, 42,6,56,57,58,8,15,16,17,26,9,18,20,50,46,19,10,40 ,22,21,12,34,35,13,36,37,38);MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, October 18th 2007 @ 04:32:28
PMScript : http://www.badgirljammieclub.com/community/private.php
Referrer : http://www.badgirljammieclub.com/community/private.php?do=newpm&pmid=4321
IP Address :
Username : GilferKnight
Classname : vb_database

[Canis Firebrand]

I can't recall if I or someone else asked this before.

Can this and the Display Unread Posts add-on be used together?

The reason I ask and what my users want would be satisfied if they can.

Currently, I use the Display Unread Posts one to have it display any unread posts since their last visit. Other uses want a total count of all unread posts, not just since their last visit. Since there isn't an option to let them choose which way to have the product display, I thought of adding this one as well.

Then, I could set the Display New Posts addon to show all posts since their last login. Then use the Unread Posts addon to display the count of all unread posts.

As long as both addons would display the code, would there be any clashes in the two running at the same time? Would both addons display the code?

I'd like to have it read something like

You have 5 New Posts since your last visit and 20 unread posts total.

I know I'd have to edit the phrasing myself to fix, but aside from that, would what I am looking to be achieve be possible with these two add-ons installed?

[Paul M]

Originally Posted by deezelpope

Oh dear! Everything was running great, then I updated and now I'm getting this:

Database error in vBulletin 3.6.4:Invalid SQL: SELECT COUNT(post.dateline) AS pcount FROM post AS post FORCE INDEX (dateline) INNER JOIN thread AS thread USING (threadid) WHERE dateline > 1192722160 AND thread.forumid IN (03,59,5,44,52,7,14,54,53,49,47,48,55,43,32,41,31, 42,6,56,57,58,8,15,16,17,26,9,18,20,50,46,19,10,40 ,22,21,12,34,35,13,36,37,38);MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Thursday, October 18th 2007 @ 04:32:28
PMScript : http://www.badgirljammieclub.com/community/private.php
Referrer : http://www.badgirljammieclub.com/community/private.php?do=newpm&pmid=4321
IP Address :
Username : GilferKnight
Classname : vb_database

Hmm, odd that I don't get that, but it's easily fixed, just re-download and install.

[Paul M]

Originally Posted by Canis Firebrand

Can this and the Display Unread Posts add-on be used together?

I bit of an odd thing to do, but you can run them both together if you want, you should disable the reputation section of one of them, otherwise that will run twice.

[deezelpope]

Originally Posted by Paul M

Hmm, odd that I don't get that, but it's easily fixed, just re-download and install.

Oh, I know, isn't it? Alrighty, I'll try it. Kinda freaked out again and shaking...*sigh*

I did the overwrite with the 3.23...seems ok now. Thank you, Paul.

[subnet_rx]

This seems to now make auto template edits and negates the manual old template edits. Can this be turned back on? I don't display the new posts and rep at the top of the info box, I display them at the bottom.

[SBlueman]

I have a bit of a problem....

I modified my site some and got rid of the usual vbulletin section where you'd normally see this. I added a login menu at the top of the site and when people are logged in they would see all this information. Now the new posts information is showing up underneath the Welcome, [username] section and the reputation part of this mod is not showing up at all. This is my code:

<table width="880" border="0" cellpadding="1" cellspacing="1" background="http://img150.imageshack.us/img150/3619/cellpic13702babzk1.png">
    <tr>
	<td>&nbsp;</td> 
      <td><font color="#000000" size="1"><phrase 1="$bbuserinfo[username]"><strong>$vbphrase[welcome_x]</strong></phrase></font></td>
      <td><div align="center"><if condition="$show[pcount]"><font color="#000000" size="1"><strong>$bbuserinfo[pcount]</strong></font></if> 
        </div></td>
      <td><div align="center"><font size="1"><phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]"><font color="#000000"><strong>$vbphrase[last_visited_x_at_y]</strong></font></phrase></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show['pmstats']"><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]"><font color="#000000"><strong>$vbphrase[private_messages_nav]</strong></font></phrase></if></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show['pmwarning']"><strong><phrase 1="$vbphrase[pmpercent_nav_compiled]"><font color="#000000">$vbphrase[your_pm_box_is_x_full]</font></phrase></strong></if></font></div></td>
      <td><div align="center"><font size="1"><if condition="$show[npr_reputation]"><font color="#000000"><strong>$vbphrase[npr_reputation]</strong></font></if></font></div></td>
      <td class="vbmenu_control"><a href="login.php?$session[sessionurl]do=logout&amp;logouthash=$bbuserinfo[logouthash]" onclick="return log_out('$vbphrase[sure_you_want_to_log_out]')"><strong><font size="1">$vbphrase[log_out]</font></strong></a></td>
    </tr>
  </table>

Is there anything I can do to keep this on my site? Or do I have to give it up because it won't work with my custom setup?

This is my site: http://gridironfans.com/