Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
Reload this Page New Posts & Threads Since Last visit
FAQ Community Calendar Today's Posts Search

Reply
Page 15 of 17 « First 51314 15 1617
 
Thread Tools
New Posts & Threads Since Last visit Details »»
New Posts & Threads Since Last visit
MOD Information
The Developer
Zachery's Avatar
 
Version: 1.00, by Zachery Zachery is offline
Developer Last Online: May 2017 Show Printable Version Email this Page
Version: 3.5.8 Rating:
Released: 06-09-2005 Last Update: 07-14-2005 Installs: 137
DB Changes Uses Plugins Template Edits
 
No support by the author.

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]

Show Your Support

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

Comments
  #142  
Old 08-07-2006, 11:58 AM
Chris Blount Chris Blount is offline
 
Join Date: Mar 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This already works in VB 3.6.
Reply With Quote
  #143  
Old 08-08-2006, 09:41 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It is already working for 3.6.
Reply With Quote
  #144  
Old 08-09-2006, 10:10 AM
Conspiracy Conspiracy is offline
 
Join Date: Apr 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I ran the query and I got this error

Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `thread` ADD INDEX ( `dateline` )' at line 1
why?
I've installed it on another forum and it was fine, I'm not good with MySQL so I wouldn't know where to look for the right syntax, could someone help ?
Reply With Quote
  #145  
Old 10-06-2006, 03:29 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
uber late response but what version of mysql?
Reply With Quote
  #146  
Old 11-13-2006, 03:10 AM
ChopBam's Avatar
ChopBam ChopBam is offline
 
Join Date: Apr 2006
Location: California
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.
Reply With Quote
  #147  
Old 11-13-2006, 03:47 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.
Reply With Quote
  #148  
Old 03-06-2007, 05:44 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Anyone using this with MySQL5?
Reply With Quote
  #149  
Old 03-06-2007, 05:57 PM
Smoothie Smoothie is offline
 
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
any chance of fixing the "you don't have the permission to read"?
Reply With Quote
  #150  
Old 03-06-2007, 06:02 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Smoothie View Post
any chance of fixing the "you don't have the permission to read"?
Hmmm?
Reply With Quote
  #151  
Old 03-06-2007, 06:06 PM
Smoothie Smoothie is offline
 
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ChopBam View Post
I believe I found a problem with this one.
I just noticed that the number of new posts includes posts you don't have the permission to read, and I'm sure this applies to threads too.
Quote:
Originally Posted by Zachery View Post
Yea, 9/10 times it shouldn't be a big issue. Adding permissions to the query will only make things more comlicated.
That
Reply With Quote
Reply
Page 15 of 17 « First 51314 15 1617

« Previous Thread | Next Thread »

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 04:10 PM.

Contact Us - Archive - Top

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.04608 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
  • (4)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
  • (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