Mass Unstick

[isman]

Can someone please come up with a code the will mass unstick threads. While working on my development site I prune most of the posts so the database is smaller but it takes me forever to unstick those stupid posts.

I'm sure it can't be that hard, I'm just not savvy enough to figure it out.

Thanks in advance.

isman

[Mystis]

Run this sql query on your vb database :)
UPDATE thread set sticky=0 where sticky=1

[Xenon]

you don't need the where clause here

UPDATE thread SET sticky=0 is enough here ;)