General off-topic discussions.
User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 2:55 pm

I'm thinking about changing the right side box on the front page from 'Recent Forum Posts' to 'Recent Active Topics'. Instead of just listing the most recent posts, it would display the top 5 most active topics (most replies) with a post in the last 3 days.

What do you guys think?

User avatar
routerdork
Post Whore
Posts:
1535
Joined:
Tue Feb 22, 2011 9:40 am
Certs:
CCNA, MCDST, MCP, A+

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 3:04 pm

I like it. Advertise what's hot.

javin
Ultimate Member
Posts:
815
Joined:
Wed Aug 29, 2012 5:20 pm
Certs:
CCNA, CCNA-Voice, Security +

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 3:08 pm

As long as you leave "View New Posts", that seems like a cool idea.
Discipline

"The only real security that a man can have in this world is a reserve of knowledge, experience and ability" - Henry Ford

User avatar
Vito_Corleone
Moderator
Posts:
9850
Joined:
Mon Apr 07, 2008 10:38 am
Certs:
CCNP RS, CCNP DC, CCDP, CCIP

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 3:08 pm

javin wrote:As long as you leave "View New Posts", that seems like a cool idea.


what he said
http://blog.alwaysthenetwork.com

User avatar
jdsilva
Post Whore
Posts:
5347
Joined:
Mon Jan 17, 2005 11:01 pm
Certs:
CCNP

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 3:40 pm

Vito_Corleone wrote:
javin wrote:As long as you leave "View New Posts", that seems like a cool idea.


what he said

User avatar
wirerat
Post Whore
Posts:
5340
Joined:
Tue Mar 31, 2009 4:15 pm
Certs:
More than none

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 3:52 pm

jdsilva wrote:
Vito_Corleone wrote:
javin wrote:As long as you leave "View New Posts", that seems like a cool idea.


what he said
"See packet, be packet, you are packet. Ignore all else!" -The Networker
packetsdropped.wordpress.com

User avatar
mellowd
CCIE #38070
Posts:
13814
Joined:
Wed Jun 18, 2008 7:49 am
Certs:
CCIE (RS,SP), JNCIE-SP, BC-/SPNE/NP

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 4:08 pm

jdsilva wrote:
Vito_Corleone wrote:
javin wrote:As long as you leave "View New Posts", that seems like a cool idea.


what he said


Code: Select all
You may embed only 3 quotes within each other.


:(

User avatar
that1guy15
Post Whore
Posts:
3224
Joined:
Thu Apr 29, 2010 6:12 pm
Certs:
CCNP, CCDP, CCIP

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 4:23 pm

Im dense... so i guess i dont know how they would be different.

What about putting both up for a week or so and see what everyone things???
http://blog.movingonesandzeros.net/

User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 5:34 pm

Current code grabs all topics created in the last 3 days, sorts them by the number of replies, and displays the top 5.

Code: Select all
$threedaysago = time() - (3 * 24 * 60 * 60);

$query =
'SELECT u.user_id, u.username, u.group_id, t.topic_title, t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_last_poster_id, t.topic_replies, t.topic_time
FROM '.USERS_TABLE.' u, '.TOPICS_TABLE.' t
WHERE u.user_id = t.topic_last_poster_id
AND t.topic_time > '.$threedaysago.'
ORDER BY t.topic_replies DESC';


At first I had it grabbing all topics with a reply in the last 3 days, but that lists things like the drunk topic which wasn't really what I was looking for.

Let me know what you guys think. It can be tweaked.

User avatar
wirerat
Post Whore
Posts:
5340
Joined:
Tue Mar 31, 2009 4:15 pm
Certs:
More than none

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 5:35 pm

Looks good.
"See packet, be packet, you are packet. Ignore all else!" -The Networker
packetsdropped.wordpress.com

User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Re: Recent Forum Posts -> Recent Active Topics?

Fri Oct 26, 2012 6:42 pm

Renamed Active Forum Topics. Done for now.

Davidr
Senior Member
Posts:
485
Joined:
Wed Aug 24, 2011 1:43 am
Certs:
CCNP

Re: Recent Forum Posts -> Recent Active Topics?

Mon Oct 29, 2012 5:40 am

nice, seeing those "new people" topics every day can get boring.

I like the active topics idea.

User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 10:44 am

I'm still not happy with the results. The way it works now it grabs all topics *started* in the last 3 days and displays the one's with the most replies, but that misses a thread started a year ago that has a bunch of recent replies.

I think I should grab all posts in the past 3 days and display the topics with the most replies. Just not sure how to do that in SQL.

Davidr
Senior Member
Posts:
485
Joined:
Wed Aug 24, 2011 1:43 am
Certs:
CCNP

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 10:53 am

select all topics where creation_time = (-3 days in seconds) and post-count =_or_ bigger than (a number u consider to make it an active topic)

Davidr
Senior Member
Posts:
485
Joined:
Wed Aug 24, 2011 1:43 am
Certs:
CCNP

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 11:08 am

what about checking for when the last post was made ?

User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 11:11 am

I don't want to just consider topics created in the last 3 days. I want to consider all topics as potentially active.

User avatar
ristau5741
Post Whore
Posts:
10618
Joined:
Tue Aug 21, 2007 2:15 pm
Certs:
Instanity

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 11:11 am

OT: but where did the link to the weekly top posters go ?
Tips of the day:
- The human mind is the ultimate creation invention.
- I have so many customers, my customers have customers.
- Sausage time
- POP, stack, and store

User avatar
Steve
Site Admin
Posts:
10617
Joined:
Mon Dec 06, 2004 6:46 pm
Certs:
CCNA

Re: Recent Forum Posts -> Recent Active Topics?

Wed Oct 31, 2012 11:25 am

It hasn't moved. It's in the Site Links box.

User avatar
that1guy15
Post Whore
Posts:
3224
Joined:
Thu Apr 29, 2010 6:12 pm
Certs:
CCNP, CCDP, CCIP

Re: Recent Forum Posts -> Recent Active Topics?

Fri Nov 02, 2012 10:50 am

Maybe its just me, but Im not getting used to the change.

Before i was able to check the "Recent Activity" section for any recent comments on any thread or new threads. If i have been away for a while I could check "view your post" and then "view new post" if I wanted to see what was going on that feel off that list. Now I dont know if anything in "active topics" has been posted too since I last visited so I always now have to hit "view your post" and then "view new post" to see whats up or click on the topic and check.

For me it seems like it has added steps.

Is it just me doing things weird?
http://blog.movingonesandzeros.net/

'

Return to Forum Lobby

Who is online

Users browsing this forum: No registered users and 67 guests

      cron