vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   New Posts & Threads Since Last visit (https://vborg.vbsupport.ru/showthread.php?t=82774)

Nullifi3d 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 10-10-2005 10:43 AM

Quote:

Originally Posted by Reverend
My mistake,i forgot to add the navbar edit :o

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 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 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 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 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 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 10-14-2005 09:29 PM

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

vBarab 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 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


All times are GMT. The time now is 07:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01378 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete