Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
New Posts & Threads Since Last visit Details »
New Posts & Threads Since Last visit
Mod Version: 1.00, by Zachery (Member) Zachery is offline
Developer Last Online: May 2017 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.5.8 Rating: (5 votes - 4.20 average) Installs: 137
Released: 10 Jun 2005 Last Update: 15 Jul 2005 Downloads: 591
Not Supported DB Changes Uses Plugins Template Edits  

Um. I think this one is fairly self explaintiory by now.

It gets a count of the newest posts and threads since their last visit.


Optionally you should add indexes on your post and thread tables for the dateline columns

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
How many threads and posts since your last visit! Gary King vBulletin 3.0 Full Releases 197 09 May 2006 19:25
[Release] Since your last visit X posts and X threads. (2.0!) Brad vBulletin 2.x Template Modifications 14 08 Jun 2003 20:28

  #76  
Old 03 Oct 2005, 17:57
calldaffer's Avatar
calldaffer calldaffer is offline
 
Join Date: Mar 2002
Currently my board has: Threads: 17,869, Posts: 182,735 and I've noticed no drag on performance...

Zachery, please tell us why you recomend against it and the longterm effects of not doing as you suggested.
Reply With Quote
  #77  
Old 03 Oct 2005, 23:53
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
If you index dateline in your post & thread tables this hack will have a negligable effect, even if run on every page, that's what indexes are for.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #78  
Old 04 Oct 2005, 01:59
Roody Roody is offline
 
Join Date: Mar 2002
Originally Posted by Nullifi3d
As your board gets bigger (more posts/threads) page load will increase. Once you board reaches a few hundred thousand posts/threads or even worse in the millions I woud fear being a member of your site.
So just putting it on the forumhome_start will prevent this issue from happening?
Reply With Quote
  #79  
Old 04 Oct 2005, 02:06
Nullifi3d Nullifi3d is offline
 
Join Date: Apr 2004
Real name: Jason
Well it's defaulted to that hook when you install the plugin. Thus, forumhome is the only page that runs the php code to get the post count. As Paul and Zach stated, if you added the indexes it will help alot. I wouldn't recommend running it on every page if you have millions of posts or don't use indexes.

Please keep in mind, I'm not a php/mysql guru, however I do know a lil bit.
Reply With Quote
  #80  
Old 04 Oct 2005, 18:42
sim tech sim tech is offline
 
Join Date: Jan 2005
Is it normal to not update very often?

My vBulletin shows that no new message have been posted if you go by the generic image which is on the left side of the forum, but the mod still says "There has been 3 new posts and 0 new threads since your last visit."

Even when I refresh the page it did not change. It does update as far as increasing... I added a test post and it now says there are 4 new posts but the default vbulletin software shows that I have already viewed them.

The only way that I can get the counter to reset is to actually log out of the message board and then back in.

Last edited by sim tech; 04 Oct 2005 at 18:45.
Reply With Quote
  #81  
Old 04 Oct 2005, 18:48
Nullifi3d Nullifi3d is offline
 
Join Date: Apr 2004
Real name: Jason
Well it counts the posts since your last visit, not the posts that you haven't viewed since your last visit.
Reply With Quote
  #82  
Old 10 Oct 2005, 11:43
predatorkill predatorkill is offline
 
Join Date: Apr 2005
Originally Posted by Reverend
My mistake,i forgot to add the navbar edit

BTW, i removed the separate (get new posts) link as there is already a link under the posts and threads counts,and i also placed it under the pm stats (same position as Gary's 3.0 hack). Just my own preference.

Thanks for the hack though Zach.

That way is better and more noticeable by the user!!!

i didnt make alter to the sql tables.I must do that?the hack works ok tho...

Nice hack!

Thanks a lot!
Reply With Quote
  #83  
Old 10 Oct 2005, 12:42
southernlady's Avatar
southernlady southernlady is offline
 
Join Date: May 2005
I slipped it down a bit to after this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That puts it in the Welcome section that is part of the user cp and under the PM messages. Liz
Reply With Quote
  #84  
Old 10 Oct 2005, 17:25
Quillz's Avatar
Quillz Quillz is offline
 
Join Date: Jan 2005
Real name: Joseph
I'd like to install this plug-in, but is running that SQL query required? I know how to access phpMyAdmin, but I don't know where to run the query. I'd like to just not do it if at all possible.
Reply With Quote
  #85  
Old 10 Oct 2005, 19:22
Nullifi3d Nullifi3d is offline
 
Join Date: Apr 2004
Real name: Jason
If you don't run the query then you'll be scanning your entire post and thread tables each time you featch the data (load the page that shows the totals). I wouldn't reccomend not running the sql query if you have more then a few thousand threads and/or posts.
Reply With Quote
  #86  
Old 10 Oct 2005, 20:32
Quillz's Avatar
Quillz Quillz is offline
 
Join Date: Jan 2005
Real name: Joseph
Originally Posted by Nullifi3d
If you don't run the query then you'll be scanning your entire post and thread tables each time you featch the data (load the page that shows the totals). I wouldn't reccomend not running the sql query if you have more then a few thousand threads and/or posts.
I installed this on my test board with 1 member and 1 post. But, just for reference, where exactly do I run this query? I know how to run it, and I know how to access phpMyAdmin. Just don't know where it goes.
Reply With Quote
  #87  
Old 10 Oct 2005, 20:42
Nullifi3d Nullifi3d is offline
 
Join Date: Apr 2004
Real name: Jason
Click the SQL link in phpmyadmin, or you can run sql queries from Maintenance >> Execute SQL Query in your forum's AdminCP.
Reply With Quote
  #88  
Old 14 Oct 2005, 22:29
LeeWicKeD LeeWicKeD is offline
 
Join Date: Feb 2005
Real name: Lee
great mod,works fine, even at vb3.5gold
Reply With Quote
  #89  
Old 15 Oct 2005, 16:27
vBarab vBarab is offline
 
Join Date: Oct 2005
Arrow newUsers

find

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

afer that

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Attached Files
File Type: txt New Posts & New User & Threads Since Last visit.txt (504 Bytes, 37 views)
Reply With Quote
  #90  
Old 27 Oct 2005, 12:43
Xtrm2Matt Xtrm2Matt is offline
 
Join Date: Aug 2002
~~~ removed ~~~

Just fixed it. Forgot to uninstall the other "New posts" hack before installing this one

Thanks anyways

Matt

Last edited by Xtrm2Matt; 27 Oct 2005 at 13:54.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 06:06.

Layout Options | Width: Wide Color: