how useful actually are freshie counts on the index page?
would it be just as useful if there was some indication that a given forum had freshies > 0? like what if the row were highlighted or something like that?
would it be just as useful if there was some indication that a given forum had freshies > 0? like what if the row were highlighted or something like that?
hm, i'm just gonna ditch the freshie counts. it takes a lot of time to count freshies:
$sql = "SELECT ttf_forum.*, ".
" COUNT( * ) - COUNT( ttf_thread_new.last_view ) AS freshies, ".
" ttf_forum_new.last_view ".
"FROM ttf_forum ".
"LEFT JOIN ttf_thread USING ( forum_id ) ".
"LEFT JOIN ttf_thread_new ".
" ON ( ttf_thread.thread_id = ttf_thread_new.thread_id ".
" && ttf_thread_new.user_id = '{$ttf["uid"]}' ".
" && ttf_thread.date < ttf_thread_new.last_view ) ".
"LEFT JOIN ttf_forum_new ".
" ON ( ttf_forum.forum_id = ttf_forum_new.forum_id ".
" && ttf_forum_new.user_id = '{$ttf["uid"]}' ".
" && ttf_forum.date >= ttf_forum_new.last_view ) ".
"GROUP BY ttf_forum.forum_id ";
seriously, though, if you really dig on freshie counts--tell me.
they tell me how much of a bad person I am
i love freshies like nestor loves mashin'
I never look at the counts; they overwhelm me.
They work well if you're either on top of ttf posts or you're a liar (who marks all as read). For anyone else it might be somewhat irrelevant.
It might be interesting to see everybody's last freshie count in their profile :) and in manage users?
Maybe there should be a way to stop using freshie counts in the edit profile section so as to increase forum speed.
Just a few fresh ideas :D
It might be interesting to see everybody's last freshie count in their profile :) and in manage users?
Maybe there should be a way to stop using freshie counts in the edit profile section so as to increase forum speed.
Just a few fresh ideas :D
I still think 'catch up' is the best way to manage freshies.
it's coming. :)
ok this has been bothering me lately.
1. come to ttf, freshies are bold, new posts to read!
2. open up threads I want to look at, post in some, close others.
3. go back to index, forums that I have posted in still have bolded freshie counts.
4. click on each of these forums so they're not bold anymore and I can tell when there are actually new posts by people other than me.
can we exclude posts by oneself from triggering freshy count bolding somehow?
1. come to ttf, freshies are bold, new posts to read!
2. open up threads I want to look at, post in some, close others.
3. go back to index, forums that I have posted in still have bolded freshie counts.
4. click on each of these forums so they're not bold anymore and I can tell when there are actually new posts by people other than me.
can we exclude posts by oneself from triggering freshy count bolding somehow?
agreed. this has bugged me for a while :P
Agreed.