[intellected]

Originally posted by Overgrow
I like this, except for the JOIN on the table that it adds with every showthread. Maybe a more efficient solution would be to modify newreply and newthread so that whenever a 666-user posts, it is automatically made visible=0? Or would that put it in the moderation queue...

Have you run this on a sizeable board and is there much of a hit with the join?

I don't know much about database performance - are joins that heavy? You solution would be better performance-wise, but it would take away the advantage of the user seeing his own posts. If they were invisible, he/she would probably get suspicious.

The solution would be to add a "hellban" column to the post table... I'll see what I can do.