Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2009, 09:47 PM
gersforum@gmail gersforum@gmail is offline
 
Join Date: Oct 2006
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Forum Prune

Seeing as vB decided to make it so only their coders could understand and complete this task - How do you do it?

I'm on the page to prune but I'm asked some seriously dumb questions when all I want to do is clear posts over 365 days old.. My db is close to 1/2gb and needs seriously cleaning..

Can someone kind enough put up a recommended setting for each question please.

Kind regards
Reply With Quote
  #2  
Old 01-05-2009, 10:22 PM
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Location: Hamilton, Ontario
Posts: 378
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Original post date is at least '365' days ago

Original post date is at most '0' days ago
- Note: leave this at 0 to specify no limit.

Last post date is at least '365' days ago

Last post date is at most '0' days ago
- Note: leave this at 0 to specify no limit.

View Options
Thread has at Least '0' Replies

Thread has at Most '-1' Replies
- Note: leave this at -1 to specify no limit.

Thread has at Least '0' Views

Thread has at Most '-1' Views
- Note: leave this at -1 to specify no limit.

Status Options
Thread is sticky: Thread remains at top of list thread listings
Yes No Either

Thread State

Visible
Awaiting Moderation
Deleted
Any

Thread Status

Open
Closed
Redirect
Not Redirect
Any
Reply With Quote
  #3  
Old 01-06-2009, 01:34 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's just a darned shame we still have no method of offloading the pruned data. It all has to be deleted.
Reply With Quote
  #4  
Old 01-06-2009, 01:37 AM
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Location: Hamilton, Ontario
Posts: 378
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You could back it up from MySQL if you wanted, but if threads aren't used for over a year or so I don't see the point of keeping them unless they contain reference information.
Reply With Quote
  #5  
Old 01-06-2009, 01:44 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd like to keep our old posts just for posterity. Offload them to an easily searchable text file, maybe using the Print routines. Absurd to force us to keep old posts in the db.
Reply With Quote
  #6  
Old 01-11-2009, 01:04 AM
joshskeety joshskeety is offline
 
Join Date: May 2004
Location: Virginia
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I cant believe there is not a hack or something to auto offload a post into another database as an archive so you can archive by year..

Seems logical, not sure why it hasn't been done yet...
Reply With Quote
  #7  
Old 02-10-2011, 09:07 PM
enbro enbro is offline
 
Join Date: Jan 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've seen this type of feature in other discussion board software.....the ability to prune old messages into an HTML file that you post on the web for users to view, like an archive.
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 09:22 AM.


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.04677 seconds
  • Memory Usage 2,213KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete