The W
June 7, 2009 - birthdaybritney.jpg
Views: 178994908
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
28.3.24 0638
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
(406 newer) Next thread | Previous thread
User
Post (4 total)
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 8 days
Last activity: 3 days
ICQ:  
#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: 8 days
Last activity: 15 hours
ICQ:  
#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: 8 days
Last activity: 3 days
ICQ:  
#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: 8 days
Last activity: 15 hours
ICQ:  
#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
(406 newer) Next thread | Previous thread
Google will eventually sort it all out. For now, if you want to search for a term on the site, bring up Google and try it like this: punisher site:the-w.com You'll get These results I'm not bringing back the old search. Sorry.
- Guru Zim, The Search Engine (2004)
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-2024 Brothers Zim

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