vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   SQL Query - Display new threads first (https://vborg.vbsupport.ru/showthread.php?t=151374)

Firecracker 07-04-2007 07:51 PM

SQL Query - Display new threads first
 
I know how to do the automatic query to have all your users display new/old posts first. But what's the the query to make the all display new threads first ? I know you can set it as default for new users, but haw to mass change it for existing users?
Only automatic query is the "Thread Display Mode - Linear". No subcategory for 'New Threads First'.

Thx in advance!

snakes1100 07-05-2007 05:40 AM

admincp --> maintenance --> execute sql query --> Posts - new first/old first

Your asking for posts in one part of your post, then asking about threads, the above is for posts anyways.

Firecracker 07-05-2007 06:56 PM

Quote:

Originally Posted by snakes1100 (Post 1283255)
admincp --> maintenance --> execute sql query --> Posts - new first/old first

Your asking for posts in one part of your post, then asking about threads, the above is for posts anyways.

That's the query I already know. That was my first sentence. There doesn't seem to be an automatic query for threads though. So I'm asking what the manual query is.
Thx!


All times are GMT. The time now is 02:49 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.02372 seconds
  • Memory Usage 1,709KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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