The Cellar - View Single Post

Skunks · 03-15-2005, 01:29 PM

Let's arbitrarily say that a thread has to have had no replies for a week to count as 'dead'. (A few days is probably more realistic, but we can tweak numbers later.)

The 'thread killer' (or, rather, the person who gets the 'kill') would be the last person to have posted.

So it would be a fairly simple bit of mysql: find the number of threads with no new posts in the past week & in which person y had posted last. It could probably be done in one query by someone who knows more about mysql/vB than I.

03-15-2005, 01:29 PM	#4
Skunks I thought I changed this. Join Date: Nov 2002 Location: western nowhere, ny Posts: 412	Let's arbitrarily say that a thread has to have had no replies for a week to count as 'dead'. (A few days is probably more realistic, but we can tweak numbers later.) The 'thread killer' (or, rather, the person who gets the 'kill') would be the last person to have posted. So it would be a fairly simple bit of mysql: find the number of threads with no new posts in the past week & in which person y had posted last. It could probably be done in one query by someone who knows more about mysql/vB than I.