vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Create a Query to change Default View Age (https://vborg.vbsupport.ru/showthread.php?t=109616)

SnappedAgain 03-06-2006 03:18 PM

Create a Query to change Default View Age
 
I would like to know if someone could write me a query that would allow me to run it and change the Default View Age on all my forums rather than having to go into the forum manager and change it for every single forum I have.

Any Ideas? Thank in Advance :up:

Logikos 03-06-2006 05:20 PM

Go into the admincp->Maintenance->Execute SQL Query->Automatic Query->Drop Down Menu (Show all threads)->press continue. :)

SnappedAgain 03-06-2006 05:51 PM

Awesome thanks man. I ended up using the query

UPDATE forum SET daysprune = 60

also for anyone else who reads this and needs to do the same thing. After I ran the query I had to rebuild the forum and thread info before the new settings would take effect.

Thanks again LiveWire :up:

Logikos 03-06-2006 06:20 PM

No problem :)


All times are GMT. The time now is 08:08 PM.

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.00923 seconds
  • Memory Usage 1,706KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete