vb.org Archive - sql to disable all products

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

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

- - sql to disable all products (https://vborg.vbsupport.ru/showthread.php?t=147713)

bashy

05-20-2007 05:04 PM

sql to disable all products

Hi

I need to disable all my products so that i can eliminate a problematic 1
I do not want to do this using

Code:



         define('DISABLE_HOOKS', true);

as i need to do turn them on 1 by 1,

therefore i need the sql please to disable all products?

Adrian Schneider

05-20-2007 05:12 PM

Disable all hooks, then turn them all off. Re-enable hooks, and turn them on one by one.

bashy

05-20-2007 05:14 PM

Cheers for the q response m8
Where do i do this in vb options?
also will i still have to disable them all 1 by 1 as this is what i didnt want to have to do?

Adrian Schneider

05-20-2007 05:24 PM

do the config.php edit to disable/re-enable hooks, then under product management you can do them one at a time.

bashy

05-20-2007 05:43 PM

Ah right but that means disabling then 1 by 1...

What i have just done is, exported just the products from phpmyadmin
Opened in wordpad and replaced all 1, with 0, baring in mind there is a space before the 1 and 0 this worked very very well :)

Thanks for ya help though m8....

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00937 seconds Memory Usage 1,710KB 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)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
Messages: