Forums :: Blogs :: Blog Entry for 4 September 2005 20:49:21 GMT

4th September 2005 20:49:21 GMT
Blog Entry for 4 September 2005 20:49:21 GMT
Rob
Rob's avatar

Seraphic/8X
85 post(s) since
24th November 2004 22:22:29 GMT
The top menu has been removed from the main page.  This way it looks like the left menu has been re-ordered for the remaining pages.

The Most Active Threads link in the menus now actually lists the most active threads, assuming there are any.  Previously, it was just a header for the items underneath, but now details of recently-active threads are listed in the Forums Main Page.

The most active threads are calculated diferently, too.  Formerly...

SELECT t.title, t.id, COUNT(p.id) AS postCount
FROM threads t LEFT JOIN posts p ON t.id = p.threadId
WHERE p.date > ".(time()-(60*60*24*14))."
GROUP BY t.id
ORDER BY postCount DESC, t.title
LIMIT 0, 5;

In English: the top five threads with the most threads in the past two weeks, in descending order.  This has now become...

SELECT t.title, t.id, AVG(p.date) AS averageDate
FROM threads t LEFT JOIN posts p ON t.id = p.threadId
GROUP BY t.id
ORDER BY averageDate DESC
LIMIT 0, 5;

In English: the top five threads with the highest average date, in descending order.
"Prepare for an oblivion for which there is no preparation." - O'Malley (Red Vs Blue)

Add Post

You must be Archangel/1B or greater to add posts to this thread.

Valid XHTML 1.1 Strict Valid CSS