vb.org Archive - Closing the forums with a query

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Closing the forums with a query (https://vborg.vbsupport.ru/showthread.php?t=47068)

filburt1

12-28-2002 03:46 PM

Closing the forums with a query

IIRC this alone doesn't do it:
[sql]
UPDATE setting SET value = "0" WHERE varname = "bbactive"
[/sql]
What's the other query?

Dean C

12-28-2002 04:07 PM

Whats IIRC?

filburt1

12-28-2002 04:08 PM

If I recall correctly.

DrkFusion

12-28-2002 04:46 PM

[sql]UPDATE setting SET value='0' WHERE varname='bbactive'[/sql]
Try that with single quotes./

filburt1

12-28-2002 06:26 PM

No there's some completely different query I thought.

Dean C

12-28-2002 07:04 PM

Lmfao i thought it was a technical term...

NTLDR

12-28-2002 07:30 PM

You need to update the options template with the values stored in the settings table for this to take effect.

vB looks at the options template and not at the setting table for all the vBulletin Options.

filburt1

12-28-2002 07:41 PM

Ah yes. :) Remember the query?

Xenon

12-28-2002 08:10 PM

in admin/options.php you can find this:

PHP Code:


		
			
$optionstemplate=generateoptions();

  $DB_site->query("UPDATE template SET template='$optionstemplate' WHERE title='options'");

i think the easiest way is a replace query, this one i think is the right one:

Code:

UPDATE template REPLACE(template, '$bbactive=1', '$bbactive=0') WHERE title='options'

filburt1

12-28-2002 08:13 PM

Thanks, it looks like that'll work. :)

I don't understand why vB doesn't just read from the setting table...:confused:

All times are GMT. The time now is 07:05 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01075 seconds Memory Usage 1,725KB 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_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: