CRZ
Big Brother
Administrator
   
   
     
  
 
Since: 9.12.01
From: ミネアポリス
Since last post: 2 hours
Last activity: 27 min.
|  #1 Posted on 20.10.10 1704.57 | 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: 5 hours
| AIM: |  |
| | |
| #2 Posted on 20.10.10 1710.29 | 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: 2 hours
Last activity: 27 min.
| #3 Posted on 20.10.10 1712.11 | 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: 5 hours
| AIM: | |
| | |
| #4 Posted on 20.10.10 1716.12 | 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