vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Changing thr default style with SQL (https://vborg.vbsupport.ru/showthread.php?t=81651)

hasan2k 05-17-2005 11:48 PM

Changing thr default style with SQL
 
I want to write a shell script that will trigger changing of default style for my forum every few hours.

Can someone please tell me the sql needed to change the default style in the forum database.

I cant seem to find what table sets the default style.

cinq 05-18-2005 12:29 AM

I think this can be done with vb scheduled tasks ( crons ).
Just create a file which will update the default style field in the db with a randomly generated styleid ( a random number based on all styles' styleid present in the db ) and set the task to run every few hours.

hasan2k 05-18-2005 04:27 AM

Quote:

Originally Posted by cinq
Just create a file which will update the default style field in the db with a randomly generated styleid ( a random number based on all styles' styleid present in the db ) and set the task to run every few hours.

Hi

You did not read my question. I know once I create the file that changes the style id it can be cronned to run at certain intervals.

My question is:

What SQL code to write to change the style id in the database.(read my first post)

cinq 05-18-2005 04:49 AM

table setting
varname styleid

hasan2k 05-18-2005 04:58 AM

Quote:

Originally Posted by cinq
table setting
varname styleid

What is the SQL code


All times are GMT. The time now is 10:54 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.01030 seconds
  • Memory Usage 1,712KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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