I did it! I got Gene to lock up his
Christian Anarchy thread! What finally did it was mentioning what a hazard that thread was to
scraper scripts that loop through
recently active threads. (Though do think that the
Jesushomoerotisation and the
Satanist threads might have softened him up...
a bit.
)
Then I noticed something interesting - posts on locked threads have a "Delete" button, but no "Modify" button, which means there's no significant reason for a scraper script to download a thread once it's locked! (Or, even if it follows
thread ID enumeration instead of parsing through
category indexes, there's no reason to download more than one page - this forum has ~8,000 second or latter pages.)
So - locking big old threads that you don't want necro'd is good for this forum. Most importantly, it would remove ambiguity about when an attempt to enrich an old thread by appending to it would be unwelcome.
I'm not positive, but I think admins could simply lock all "orphaned" threads from users that have "cycled" or deleted their accounts by running:
UPDATE smf_topics SET locked=1 WHERE id_member_started=0; |
And to lock all threads that haven't been active for a certain number of days (until the thread starter explicitly unlocks them) would be something like:
UPDATE smf_topics t, smf_messages m SET t.locked=1 WHERE t.id_last_msg = m.id_msg AND DATE(FROM_UNIXTIME(m.posterTime)) < '2011-01-01'; |