MyBB Community Forums

Hello,

I am using RSS to post. There are a lot of threads with 0 views. Is it possible to remove all threads with 0 views somehow? I don't want to delete almost 9000 threads manually.

Thanks.

Are you sure they don't have any views because something's breaking the view count, as a lot of people have encountered, or are you sure nobody has read them??

I am sure noone has read them. Because it posts about 200 per day, some of them gets hits and the rest is unread.

DELETE FROM `mybb_threads` WHERE `views` = '0'

Check your table prefix first.

@OP

If you have a specific forum where you want to delete the threads, you should do:

DELETE FROM mybb_threads WHERE views=0 AND fid=$fid;

Replace $fid with the forum's fid.

Oh yeah, didn't realise that, good spot.

Worked great.

Thanks both of you.