The Arcive of Official vBulletin Modifications Site.

New Posts & Threads Since Last visit · **Released**: 06-09-2005

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
[sql]
ALTER TABLE `post` ADD INDEX ( `dateline` );
ALTER TABLE `thread` ADD INDEX ( `dateline` );
[/sql]

Nullifi3d · #82 10-04-2005, 05:48 PM

Well it counts the posts since your last visit, not the posts that you haven't viewed since your last visit.

predatorkill · #83 10-10-2005, 10:43 AM

Quote:

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!

southernlady · #84 10-10-2005, 11:42 AM

I slipped it down a bit to after this:

Code:

<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>

That puts it in the Welcome section that is part of the user cp and under the PM messages. Liz

Quillz · #85 10-10-2005, 04:25 PM

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.

Nullifi3d · #86 10-10-2005, 06:22 PM

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.

Quillz · #87 10-10-2005, 07:32 PM

Quote:

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.

Nullifi3d · #88 10-10-2005, 07:42 PM

Click the SQL link in phpmyadmin, or you can run sql queries from Maintenance >> Execute SQL Query in your forum's AdminCP.

LeeWicKeD · #89 10-14-2005, 09:29 PM

great mod,works fine, even at vb3.5gold

vBarab · #90 10-15-2005, 03:27 PM

find

PHP Code:


			
$newthreads = number_format($getnewthreads['count']);

afer that

PHP Code:


			
// Users

$getnewUsers = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE  1 AND joindate >= '{$vbulletin->userinfo['lastvisit']}'"); 

$newUsers = number_format($getnewUsers['count']);

Xtrm2Matt · #91 10-27-2005, 11:43 AM

~~~ removed ~~~

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

Thanks anyways

Matt

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.11239 seconds Memory Usage 2,305KB 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 (1)bbcode_code (2)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!