[phrankle]

Does anyone know of a way to sort search results by the number of votes? For a given tag, I'd like the story with the most votes to show up on the top of the search results page.

In libs/search.php I changed

$sortarray[$thelink['link_id']] = $thelink['link_date'];
}
asort($sortarray);

to

$sortarray[$thelink['link_id']] = $thelink['link_votes'];
}
asort($sortarray);

That almost did it. The list is reversed, though -- the story with the most votes is the last result. I tried changing "asort" to "arsort" but that didn't change anything. Any ideas?

[phrankle]

No thoughts? I'm using 9.9.5, by the way.

[gjrb29]

Any idea on this? I would like to know as well?

[cmstheme]

Open /libs/search.php and find around LINE 178:

PHP Code:

asort($sortarray); 


then replace with:

PHP Code:

arsort($sortarray); 


References:
PHP: asort - Manual
PHP: arsort - Manual

[gjrb29]

Thank you Cmstheme :-)

[phrankle]

Originally Posted by cmstheme

Open /libs/search.php and find around LINE 178:

PHP Code:

asort($sortarray); 


then replace with:

PHP Code:

arsort($sortarray); 


References:
PHP: asort - Manual
PHP: arsort - Manual

Thanks for the response, but that unfortunately didn't work for me. As I wrote in my original post, I've already tried it.

Changing "asort" to "arsort" only affects the order when I'm using

$sortarray[$thelink['link_id']] = $thelink['link_date'];
}

when I use

$sortarray[$thelink['link_id']] = $thelink['link_votes'];
}

(when I'm sorting by vote number instead of date)

it doesn't do anything.

[cmstheme]

My previous post was for Pligg Beta 9.9.5 and for date sort only.

Here's how to sort search results (by standard search or by tags) by votes on Pligg 1.0.0. The file to be edit is /libs/search.php

Find:

PHP Code:

$this->sql = "SELECT link_id, link_date, link_published_date $from_where $search_clause "; 


replace with:

PHP Code:

$this->sql = "SELECT link_id, link_date, link_published_date, link_votes $from_where $search_clause "; 


Find the two (2) instances of:

PHP Code:

$newfoundlinks[$link_id->link_id]['link_id'] = $link_id->link_id; 


below that, add:

PHP Code:

$newfoundlinks[$link_id->link_id]['link_votes'] = $link_id->link_votes; 


Find:

PHP Code:

$sortarray[$thelink['link_id']] = $thelink['link_date']; 


replace with:

PHP Code:

$sortarray[$thelink['link_id']] = $thelink['link_votes']; 


In Pligg 1.0.0, the search search results are already ordered in reverse order, thus no need to change the asort/arsort thing.

[phrankle]

Amazing! Thank you so much.