vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Mysql Query Help.... (https://vborg.vbsupport.ru/showthread.php?t=40008)

ladyfyre 06-18-2002 03:10 PM

Mysql Query Help....
 
Could one of you help me structure a query?

I have over 250 different forums, and each of them seems to be set to use my "main" style theme, and is over-riding user selected styles. So....i need to the value of the styleoverride field (in the forum table) to 0 for every forum (i am fairly certain this is it)....but was wanting to use a query instead of trying to use the CP for updating ALLLLLL of them by hand...

can one of you tell me how to structure the query to accomplish this?

Would this be correct?

UPDATE forum SET styleoverride=0;

Xenon 06-18-2002 03:22 PM

yep, this query is correct

ladyfyre 06-18-2002 03:24 PM

thanks :)

Wooohoooo!!!!! maybe i am not as hopeless as i thought.

Xenon 06-18-2002 03:38 PM

training creates masters ;)
(german speech badly translated ;))

little thing:
in SQL you don't need to end a query with ;


All times are GMT. The time now is 03:45 AM.

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.01951 seconds
  • Memory Usage 1,704KB
  • 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