The W
Views: 100065123
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
25.10.14 2346
The W - the-w.com Site Feedback - Something to fool around with because we're bored
This thread has 8 referrals leading to it
Register and log in to post!
Thread rated: 8.60
Pages: 1
(166 newer) Next thread | Previous thread
User
Post (4 total)
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 2 hours
AIM:  
ICQ:  
Y!:
#1 Posted on | Instant Rating: 8.35
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!





Promote this thread!
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 1 day
Last activity: 1 day
AIM:  
#2 Posted on | Instant Rating: 8.84
We 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.




Sign up for Folding@Home and join our team. PM me for details.

Ignorance is bliss for you, hell for me.
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 2 hours
AIM:  
ICQ:  
Y!:
#3 Posted on | Instant Rating: 8.35
    Originally posted by Guru Zim
    We 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.
....zuhhh?



Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 1 day
Last activity: 1 day
AIM:  
#4 Posted on | Instant Rating: 8.84
1) Make a table with 7 entries

id | 1 | 2 | 3 | 4 | 5 | 6 |

2) If the thread you are posting in has a thread icon, then find your ID, and put the link into 5 into 6, 4 into 5, 3 into 4,

(update foo set 6 = 5, 5 = 4, 4 = 3, 3 = 2, 2 = 1, 1 = CurrentLink where id = id)

3) join foo back to the userid when you do the user info portion




Sign up for Folding@Home and join our team. PM me for details.

Ignorance is bliss for you, hell for me.
Thread rated: 8.60
Pages: 1
Thread ahead: the-w.com topics of interest: October 2010
Next thread: What's that?
Previous thread: the-w.com topics of interest: September 2010
(166 newer) Next thread | Previous thread
Due to a strange confluence of events - and the fact that I now get paged whenever there's a new account AND whenever we hit a megaclick, I accidentally ended up on one of these for the first time in....ever? I'm too lazy to go back and check.
Related threads: the-w.com topics of interest: September 2010 - Cubs and @IAmJericho conspire to set new all-time visitor record for The W - Why is Dolf dancing at the W? - More...
The W - the-w.com Site Feedback - Something to fool around with because we're boredRegister and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.074 seconds.