Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Unread Posts and Reputation Comments (welcome box) Details »»
Unread Posts and Reputation Comments (welcome box)
Version: 1.25, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.6.x Rating:
Released: 08-13-2006 Last Update: 10-17-2007 Installs: 556
Uses Plugins Auto-Templates
Translations  
No support by the author.

This modification is no longer available or supported.

Note: The unread posts portion of this hack only works if you use the database thread marking system.

This will display the actual number of posts that are still considered unread by you (and will show up in a 'getnew' search).

Versions 1.22+ also display the number of new reputation comments since you last checked your usercp.

There is the option to count the unread posts since your last visit, or all posts considered unread. This setting reflects the divider in the 'getnew' search display. There is also the option to disable the unread posts display or the new reputation comments display.

All settings are located in vBulletin Options > Display Unread Posts and Reputation.

To install this hack unzip the xml file and import it using the ACP Product Manager.


History:

v1.11 : First Release for vb 3.6 - various changes.
v1.12 : Updated for Version Checking.
v1.13 : Phrases Updated.
v1.14 : Dependancies updated, URL's updated.
v1.15 : Minor phrasing changes.
v1.16 : Changes to the way displayed messages are built.
v1.17 : SQL Changes to use slave.
v1.18 : Fixed broken Index creation (on install).
v1.19 : Modified slightly to exclude moderated or soft deleted posts (unless moderator).
v1.20 : Duplicate line of code removed.
v1.21 : ATCS and disable options added.
v1.22 : New reputation comments added. ATCS removed as now unnecessary.
v1.23 : Bug fixes. Added links prefix setting.
v1.24 : Fix reputation comments not being marked as read.
v1.25 : Permission check updated to include 'canviewthreads'.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #102  
Old 10-27-2006, 12:26 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Pretty much as it says - one displays the count of posts unread since your last visit date. The other counts all unread posts (as determined by the days setting in the database marking settings).
Reply With Quote
  #103  
Old 11-03-2006, 02:24 PM
Speechless Speechless is offline
 
Join Date: Nov 2005
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

very nice, i've installed it and it's working fine, but it appeared on the default vb template only, how can i add it to my customized template navbar ?
Reply With Quote
  #104  
Old 11-08-2006, 09:34 AM
Tulsa Tulsa is offline
 
Join Date: Jul 2005
Location: Broken Arrow, Oklahoma
Posts: 475
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It would be really slick if you'd toss in an option for ajax refresh on this hack.
Reply With Quote
  #105  
Old 11-08-2006, 04:36 PM
apiasto's Avatar
apiasto apiasto is offline
 
Join Date: Oct 2006
Posts: 348
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thnx , like it
Reply With Quote
  #106  
Old 11-08-2006, 09:12 PM
FireFish's Avatar
FireFish FireFish is offline
 
Join Date: Jan 2006
Location: Yipppikayeh, Mofoh!!!
Posts: 106
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice Mod; Quick question if anyone could help:

I'm running 3.6.2 & for some reason, it shows up in the Welcome area twice.

Example:
26 Unread Posts since your last visit.

26 Unread Posts since your last visit.

Anything I can do about this?
Reply With Quote
  #107  
Old 11-08-2006, 11:04 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you edited you navbar ?
Reply With Quote
  #108  
Old 11-08-2006, 11:17 PM
FireFish's Avatar
FireFish FireFish is offline
 
Join Date: Jan 2006
Location: Yipppikayeh, Mofoh!!!
Posts: 106
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M
Have you edited you navbar ?
I PM'd you
Reply With Quote
  #109  
Old 11-09-2006, 05:28 PM
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Location: Alabama
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I keep getting database errors like this:

Quote:
<!--
Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM post as post
INNER JOIN thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(1, 2, 3, 28, 23, 4, 5, 6, 7, 8, 27, 14, 16, 17, 18, 19, 20, 21, 22, 9, 10, 11, 12, 13)
AND thread.sticky IN (0,1) AND thread.visible IN (0,1,2)
AND thread.lastpost &gt; IF(threadread.readtime IS NULL, , threadread.readtime)
AND thread.lastpost &gt; IF(forumread.readtime IS NULL, , forumread.readtime)
AND thread.lastpost &gt;
AND post.dateline &gt; IF(threadread.readtime IS NULL, , threadread.readtime)
AND post.dateline &gt; IF(forumread.readtime IS NULL, , forumread.readtime)
AND post.dateline &gt;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' threadread.readtime)
AND thread.lastpost &gt; IF(forumread.readtime IS NULL, , ' at line 9
Error Number : 1064
Date : Thursday, November 9th 2006 @ 11:31:48 AM
Script : vBulletin Template Conditionals List - vBulletin Zone
Referrer : (vBSEO Article) List of Commonly Used Template Conditionals - vBulletin-Fans.com
IP Address : 24.214.88.63
Username : Brent
Classname : vB_Database
-->
I was looking through my plugins to see which deal with the threadread.readtime and this one had it.

Any suggestions on what is causing the database error?

The error happens when clicking on a link from another site to a thread on my site.

It doesn't happen everytime
Reply With Quote
  #110  
Old 11-11-2006, 03:58 AM
ICY ICE ICY ICE is offline
 
Join Date: Oct 2006
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Paul got it installed in 3.6.2 and works perfectly.

Thanks!
Reply With Quote
  #111  
Old 11-11-2006, 09:59 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BamaStangGuy
I keep getting database errors like this:



I was looking through my plugins to see which deal with the threadread.readtime and this one had it.

Any suggestions on what is causing the database error?

The error happens when clicking on a link from another site to a thread on my site.

It doesn't happen everytime
I have no idea what that SQL query is, it's certainly nothing to do with this mod.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:38 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04993 seconds
  • Memory Usage 2,313KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete