I wanted to play a little more with the thread icons and relate them to recent posting history - kinda like when you click on your/any profile page, yet get a custom "zeitgeist" of your last 20 posts - so I whipped up some threadwh.php and threadxwh.php pages. Next time you're bored, change your "thread.php" or "threadx.php" URL by putting that "wh" before the ".php" and you'll not only see the thread, but each user will also have their 12 most recent tagged posts show up, like this example I'm going to hide from the web crawlers because I don't want them crawling links like this...
{ Sorry, you must be logged in to see this text! }
Those are all linked to posts, as well.
This particular feature will probably never make it out of "beta" due to it making more database queries than I am comfortable having ALL the time, but it's another way to look at and play with this information you cheerfully provide us for free with EVERY visit so consider it just another way for me to say "thanks."
It's also a reminder that I'm always looking for new gimmicks, so if you've got any ideas, please let me know!
Originally posted by Guru ZimWe can just pre-compile the list of threads and have it be one extra join. The writes will happen in newthread or newpost.
If you want to do this I can show you how to make it efficient.