Announcement

Collapse
No announcement yet.

MYSQL Query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Semperfidelis
    replied
    Cheers

    Leave a comment:


  • Steve Machol
    replied
    In vB2, '1000' is equivalent to 'all' days.

    Leave a comment:


  • N9ne
    replied
    However if your forum has been up for about 3 years, that will not show all the posts, set it to 10000 to show them all if you have a long running forum and your database is filled with posts

    Leave a comment:


  • IDN
    replied
    UPDATE forum SET daysprune=1000;

    Leave a comment:


  • Semperfidelis
    started a topic MYSQL Query

    MYSQL Query

    For all you mysql gurus out there, what query would I need to run (for vb 2.3.0) to modify all forums so they display posts from last 1000 days ?
    ie
    all posts
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X