Query to approve all pending links

[Moncal]

Could someone please provide me with a query that would approve all the pending links in my database? I haven't been able to keep up and there are over 500 to check. There is no way I can approve all those and I would just like to go through and delete the obvious ones then worry about any that slip through latter.

Thanks

[yktan]

Hi Moncal,

Pending links have a status of 1 and active links have a status of 2 in the database. So, to query all pending links, just do something like:
Content visible to registered users only.
Similarly, to set all pending links to be active, just do something like:
Content visible to registered users only.

I hope this is what you meant.

Regards,
yktan

[Ap0s7le]

yktan is totally correct.

Ah, ain't it nice to be right? haha I'm goofy, someone please shoot me?

-Casey

[Jim_Westergren]

If that is done, will the approval notification be sent as usual?

[David]

Content visible to registered users only.

I would say "no" Jim

[Moncal]

Content visible to registered users only.

Thankyou, that's exactly what I am looking for. I try that out as soon as I get my directory upgraded to RC5.2.

[Moncal]

I finally got around to it. I just painlessly added 446 links to my directory! I'm almost to the 1000 mark.

[Jim_Westergren]

Well done.

I just went through 100, about 250 more to go.

I never reach zero as tomorrow there are 50 more .... :)