Code to not approve sites

[sitegiant]

I have a few directories that I let get away from me (in approving links). Now i have large directories with tons and tons of unapproved spam. I'm looking for a code where I can add the mySQL and not approve any of them.

Here is a code to approve all links.

UPDATE PLD_LINK SET `STATUS` = '2'

that works great to approve all submitted, but that would ruin my directories.

this is a code that was suggested before

UPDATE PLD_LINK SET `STATUS` = '0' WHERE `LINK_TYPE` = x

2 is approved, 1 is pending, so I am assuming 0 is unapproved.

UPDATE PLD_LINK SET `STATUS` = '0' WHERE `LINK_TYPE` = '1'

so I tried this and got no results, I did this

UPDATE PLD_LINK SET `STATUS` = '1' WHERE `LINK_TYPE` = '2'

and it unapproved what was there.

so the problem looks like its the zero.

It sure would help if someone had the anser for me here. Thanks.

[James]

you can set them to 1 OR upgrade so you can do bulk ... that is the extent of your options

[sitegiant]

but bulk, isn't that only 25 at a time on verison 3?

[David]

Well in version 3, you have control over how many listings appear per page in admin, so you can check all on 100+ if you wanted.

[sitegiant]

but with 45000 links that will still be quite a bit of work to delete them all.