Scoop || Viewing stories based on popularity

Front Page · Everything · News · Code · Help! · Wishlist · Project · Scoop Sites · Dev Notes · Latest CVS changes · Development Activities

Viewing stories based on popularity
By phill , Section Help! [] Posted on Mon Sep 23, 2002 at 12:00:00 PM PST

I am wanting to redisplay stories based on popularity but use the Scoop code to display it so that all the formatting/security remains. I already have the sql statement, I just need to know where to edit so I can use it.

For the curious:
select [Whatever I need to select], COUNT(*) from comments WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 15 group by sid ORDER BY date;
I've looked through the code in the libs directory for scoop, but I cannot tell where to start. Ideally, I would think you could edit the way the sections are handled and just check for a section named 'popular' and use a different sql statement for that.
Possible or am I looking in the wrong place?

< Proposal to propose implementing "dump it" voting for edit queue | ryanthiessen.com moves to scoop >

Menu

· create account
· faq
· search
· report bugs
· Scoop Administrators Guide
· Scoop Box Exchange

Login

Make a new account

Username:

Password:

Related Links

· Scoop
· More on Feature Requests
· Also by phill

Story Views

37 Scoop users have viewed this story.

Viewing stories based on popularity | 11 comments (11 topical, 0 hidden)

Not a section (none / 0) (#1)
by theantix on Tue Sep 24, 2002 at 10:59:55 AM PST

Creating a new pseudo-section would be difficult to manage and wouldn't really be worth it in my opinion. If you want to do this, I would suggest that instead of creating a pseudo-section, and instead make a special page containing a box. The box could call the database to retrieve the stories that you want, and you could put the link to the special page on your navigation bar alongside the stories and no one would know the difference.

Also, I suggest that you look at some of the existing boxes and mimic their use the $S->db_select() function to retreive stories, you can still use all of the where clauses you could want but it would be more fitting with the rest of scoop.

re: not a section by phill, 09/25/2002 03:22:18 PM PST (none / 0)

My suggestion by theantix, 09/25/2002 03:42:03 PM PST (none / 0)

Box warning. by vwX, 10/05/2002 09:21:48 PM PST (none / 0)

msnbc.com (none / 0) (#2)
by Phantros on Wed Sep 25, 2002 at 06:07:49 AM PST

Just a moment ago I read a story at MSNBC, and at the bottom there was a "Would you recommend this story to other readers?" scale where you rated the story. It made me wonder again why there isn't a similar mechanism with scoop stories - it would be simple to use, just a rating for the story itself, and would probably be a good way of judging popularity. Was there a reason why this wasn't implemented?

4Literature - Read, write, and discuss your favorite books.

That's not that bad of an idea. by phill, 09/25/2002 07:45:31 AM PST (none / 0)

a (none / 0) (#7)
by rozirose124 on Fri Aug 28, 2020 at 11:22:13 AM PST

In this article understand the most important thing, the item will give you a keyword rich link a great useful website page: 그래프사이트

great (none / 0) (#8)
by rozirose124 on Sat Aug 29, 2020 at 01:12:56 PM PST

I should assert barely that its astounding! The blog is informational also always fabricate amazing entitys. sagame888

great (none / 0) (#9)
by rozirose124 on Mon Aug 31, 2020 at 01:57:12 AM PST

In this case you will begin it is important, it again produces a web site a strong significant internet site: 성기확대수술

great (none / 0) (#10)
by rozirose124 on Mon Aug 31, 2020 at 02:09:34 AM PST

I propose merely very good along with reputable data, consequently visualize it: 스포츠중계

great (none / 0) (#11)
by rozirose124 on Fri Sep 11, 2020 at 02:48:01 AM PST

I encourage you to read this text it is fun described ... ที่เด็ด

Viewing stories based on popularity | 11 comments (11 topical, 0 hidden)

create account | faq | search