sql to disable all products

[bashy]

Hi

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

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]

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

[bashy]

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]

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

[bashy]

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....