[lacasuela]

hi every one..

i would like to ask this:

can i show published news ordered by the number of votes?


thanks..

[redwine]

Open /index.php and go to line 35:

if(!isset($_REQUEST['search'])){$search->orderBy = "link_published_date DESC";}

Change it to:

if(!isset($_REQUEST['search'])){$search->orderBy = "link_votes DESC";}

[lacasuela]

thanks rewine.... another question

can i mix link_published_date and link_votes?

[gen3ric]

This is a good question, I've been curious if it was possible to order the front page by number of votes in the last X number of hours.

[gen3ric]

Hey redwine, what I think would be cool is if the published stories sorted by # of votes over the past 4 hours. That way, every 4 hours, the order of the front page will be determined by the stories that received the most votes during that 4 our time period.

The reason I don't want to just sort them by number of votes is because I don't want an entry that was submitted 3 days ago and has since received a bunch of votes to still be at the top.

[keg01]

Older thread but we never give up, do we?

@lacasuela: If you want to sort by both published date and votes, just decide which takes precendence and do one of the following in the sql statement referenced by redwine:

 link_published_date DESC, link_votes DESC
 link_votes DESC, link_published_date DESC

@gen3ric

What a provocative question! I couldn't help but take a look. I think there are potential issues with this approach like what happens if there's no published links in the 4 hour interval? Blank home page!

Maybe not an issue with your volumes. In any case, I think this will do it in 3 steps (based on 9.8.2) ...

1. ==========
index.php line 34 replace:

if(!isset($_REQUEST['search'])){$search->orderBy = "link_published_date DESC";}

with:

if(!isset($_REQUEST['search'])){$search->orderBy = "link_votes DESC, link_published_date DESC";}

2. ==========
index.php near line 46 insert:

$search->filterToTimeFrame = "custom";

after existing line:

$search->fitlerToStatus = "published";

3. ==========
libs/search.php near line 50 find:

if ($this->filterToTimeFrame == 'today') {

and insert above that entry this conditional:

                if ($this->filterToTimeFrame == 'custom') {
                        $tsdt = date('YmdHis', strtotime("- 4 hours"));
                        $fsdt = date('YmdHis', strtotime("now"));
                        $from_where .= " AND (link_published_date >= $tsdt AND link_published_date <= $fsdt) ";
                }

Note that this is definitely a hack (hard-coded custom interval is not elegant) and untested. But I think it changes your default published links tab to only display items published in the past 4 hours sorted by highest vote getters. Neat idea ... call it your "what-have-you-done-for-me-lately" filter ...

If it works for you, remember me! If not, we never met .

Cheers from Brookhaven!

Originally Posted by gen3ric

Hey redwine, what I think would be cool is if the published stories sorted by # of votes over the past 4 hours. That way, every 4 hours, the order of the front page will be determined by the stories that received the most votes during that 4 our time period.

The reason I don't want to just sort them by number of votes is because I don't want an entry that was submitted 3 days ago and has since received a bunch of votes to still be at the top.

[keg01]

As a trouble-shooting tool, I wanted sql to compare against the modified pligg code I suggested. If you hack the code as proposed, here is some sql I think gets the same link result set in a different way and might be helpful in testing:

SELECT 
link_id, 
link_author, 
link_votes, 
link_published_date, 
link_title, link_summary 
FROM pligg_links 
WHERE 
link_published_date > now() - INTERVAL 4 HOUR AND
link_status='published' 
ORDER BY link_votes DESC, link_published_date DESC

[keg01]

For those stumbling on this thread beware! There is a serious flaw in this approach that will adversely affect your seo. Unless your site is crawled within the interval you define in the custom search, those items become unreachable via web search results because they are never crawled - not good!

If anyone has worked with "gravity"-type sorting of published items and has an approach that doesn't have this type of problem, this would be a great place to share!