Welcome to the Free Talk Live bulletin board system!
This board is closed to new users and new posts.  Thank you to all our great mods and users over the years.  Details here.
185859 Posts in 9829 Topics by 1371 Members
Latest Member: cjt26
Home Help
+  The Free Talk Live BBS
|-+  Free Talk Live
| |-+  General
| | |-+  Locking threads
Pages: [1]   Go Down

Author Topic: Locking threads  (Read 4850 times)

0 Members and 1 Guest are viewing this topic.

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Locking threads
« on: March 08, 2011, 09:49:31 PM »

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.   :lol:)

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:

Code: [Select]
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:

Code: [Select]
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';
« Last Edit: March 08, 2011, 09:58:01 PM by /sbin/libmand »
Logged

John Shaw

  • Global Moderator
  • *****
  • Offline Offline
  • Posts: 17244
    • View Profile
    • Think Twice Productions
Re: Locking threads
« Reply #1 on: March 08, 2011, 09:59:34 PM »

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:

Seems like a waste of time considering that you're the only person with a history of doing that shit to annoying levels.
Logged
"btw its not a claim. Its documented fact."

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Re: Locking threads
« Reply #2 on: March 08, 2011, 10:00:53 PM »

That's subjective.
Logged

Amazing Richard

  • Guest
Re: Locking threads
« Reply #3 on: March 08, 2011, 10:09:19 PM »

I don't get it. What's so bad about Gene's thread that he decided to lock it??? Are you saying that spambots are attracted to large threads....so long threads= lots of spam, and Gene does not want to bring spam to the BBS, therefore he locked the thread???
Logged

The ghost of a ghost of a ghost

  • Owned by Brasky. Deal with it.
  • Offline Offline
  • Posts: 1026
    • View Profile
Re: Locking threads
« Reply #4 on: March 08, 2011, 10:26:05 PM »

I don't get it. What's so bad about Gene's thread that he decided to lock it??? Are you saying that spambots are attracted to large threads....so long threads= lots of spam, and Gene does not want to bring spam to the BBS, therefore he locked the thread???
That's it.....Exactly!
Logged

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Re: Locking threads
« Reply #5 on: March 08, 2011, 10:30:52 PM »

I was just kidding about Gene - the persistence and size of that thread has been joked about for quite some time now.  I'm sure Gene had better reasons to lock it than just spam-bots.

This thread is mostly about preserving information externally, which isn't as simple as just getting all the new posts, because people can edit their posts afterwards and fuck up history entirely.  There's no easy way to find modified posts, only newly posted ones.  So it's reasonable for a scraper script to get a list of updated threads, and then loop through all the pages.  That works perfectly - except for super-long threads, there you have to decide how many of the last pages you want to check for edits.  If the script re-scrapes the whole Christian Anarchy thread, then that's 31 megs of bandwidth (without HTTP compression) per bot per iteration.  An archivist bot might also want to revisit all inactive unlocked threads for gaps and necro-edits after a while...  And good thing this forum has a reasonable robots.txt crawl-delay setting, nhliberty's is 3 minutes between hits!

No big deal really, but locking old threads does help a bit.
« Last Edit: March 08, 2011, 10:36:40 PM by /sbin/libmand »
Logged

Zhwazi

  • Recovering Ex-Anarchocapitalist
  • Offline Offline
  • Posts: 3102
    • View Profile
    • Ana.rchist.net
Re: Locking threads
« Reply #6 on: March 08, 2011, 10:50:27 PM »

When I read the subject my first thought was multiprocessor synchronization. XP
Logged

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Re: Locking threads
« Reply #7 on: March 09, 2011, 12:16:32 AM »

Actually, yes...   See, the Internet is just one ginormous multi-core multi-threaded multi-everything wisdom computation machine, and this forum is its leading CPU.  Someday I'm going to post something so Libmantastic that, without any fuss, the stars will go out...   :lol:
Logged

BonerJoe

  • Guest
Re: Locking threads
« Reply #8 on: March 09, 2011, 12:39:15 AM »

You want some locked threads? I'll give you some locked threads.
Logged

anarchir

  • Extraordinaire
  • Offline Offline
  • Posts: 5103
  • No victim, no crime.
    • View Profile
    • Prepared Security
Re: Locking threads
« Reply #9 on: March 09, 2011, 12:43:09 AM »

I think Gene locked the thread because he was tired of getting stuck in a corner logically with his debates. So, he waited for the first opportunity to lock it that wouldnt make it seem like he was a sore loser, Libman provided the opportunity, and he went for it. When the heat dies down he'll open it back up again.
Logged
Good people disobey bad laws.
PreparedSecurity.com - Modern security and preparedness for the 21st century.
 [img width= height= alt=Prepared Security]http://www.prepareddesign.com/uploads/4/4/3/6/4436847/1636340_orig.png[/img]

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Re: Locking threads
« Reply #10 on: March 09, 2011, 01:34:40 AM »

Bingo.  And...

Logged

Alex Libman

  • Offline Offline
  • Posts: 264
    • View Profile
    • libman.org
Re: Locking threads
« Reply #11 on: March 09, 2011, 11:57:52 PM »

Other potential solutions to optimize crawling (and possibly some other things):

  • Disable post editing (and possibly deleting) after some time period.

  • Add a query option to show all thread messages on one page (I don't mean the print mode, which is very lossy of formatting and other stuff).

  • Fix the thread HTTP response headers to report the timestamp last message was posted or modified.  (Currently the "Date" and "Last-Modified" headers report the current time, and the "Expires" is fixed to "Mon, 26 Jul 1997 05:00:00 GMT".  If those are needed that way for caching reasons than the actual date could be reported in a new custom header pair.)

  • Let me set up something like "bbs-archive.freetalklive.com" containing a static HTML archive of each thread.  (I'll maintain it and pay for CDN hosting, you just provide permission and sub-domain CNAME pointer.)  You can then losslessly delete old threads from the live BBS and set up redirecting to the static archive.  This would reduce your hosting costs and accelerate everything quite a bit.
Logged

Riddler

  • Guest
Re: Locking threads
« Reply #12 on: March 12, 2011, 09:50:46 AM »

bababababababababababababababababababababababa
Logged
Pages: [1]   Go Up
+  The Free Talk Live BBS
|-+  Free Talk Live
| |-+  General
| | |-+  Locking threads

// ]]>

Page created in 0.024 seconds with 32 queries.