REQUEST: Sort "Search Results" by Views, Thread Starter

[theflow]

I'd like to be able to click the column heading and have the Search Results list re-sort. Does this hack already exist? Is the level of complexity to produce this hack high, medium, low?

[Admin]

In the template searchresults replace
<tr align="center">
<td bgcolor="{tableheadbgcolor}" align="left"><smallfont color="{tableheadtextcolor}"><b>Topic</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="left"><smallfont color="{tableheadtextcolor}"><b>Forum</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" nowrap><smallfont color="{tableheadtextcolor}"><b>Author</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Replies</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Views</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Date</b></smallfont></td>
</tr>
with
<tr align="center">
<td bgcolor="{tableheadbgcolor}" align="left"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=title&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Topic</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" align="left"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=forum&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Forum</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" nowrap><b><a href="search.php?action=showresults&searchid=$searchid&sortby=poster&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Author</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" nowrap><b><a href="search.php?action=showresults&searchid=$searchid&sortby=replies&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Replies</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=views&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Views</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=lastpost&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Date</smallfont></a></b></td>
</tr>

In the template searchresults_threadonly replace
<tr align="center">
<td bgcolor="{tableheadbgcolor}" colspan="3"><smallfont color="{tableheadtextcolor}"><b>Thread</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" nowrap><smallfont color="{tableheadtextcolor}"><b>Thread Starter</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="left" nowrap><smallfont color="{tableheadtextcolor}"><b>Forum</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Replies</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Views</b></smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="left" nowrap><smallfont color="{tableheadtextcolor}"><b>Last Post</b></smallfont></td>
</tr>
with
<tr align="center">
<td bgcolor="{tableheadbgcolor}" colspan="3"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=title&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Thread</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" nowrap><b><a href="search.php?action=showresults&searchid=$searchid&sortby=poster&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Thread Starter</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" align="left" nowrap><b><a href="search.php?action=showresults&searchid=$searchid&sortby=forum&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Forum</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=replies&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Replies</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}"><b><a href="search.php?action=showresults&searchid=$searchid&sortby=views&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Views</smallfont></a></b></td>
<td bgcolor="{tableheadbgcolor}" align="left" nowrap><b><a href="search.php?action=showresults&searchid=$searchid&sortby=lastpost&sortorder=$newsortorder"><smallfont color="{tableheadtextcolor}">Last Post</smallfont></a></b></td>
</tr>

In search.php add
if ($sortorder=="ascending") {
$newsortorder = "desc";
} else {
$newsortorder = "ascending";
}
right before
if ($search['showposts']==1) {
$navbits .= gettemplate("nav_joiner",0);
(towards the end of the file)

This should do what you want. If you wanna give it a try I send you a PM with my demo board.

[theflow]

Originally posted by FireFly
In the template searchresults replace...

Firefly, this looks promising. I would like to try it. Your track record to date has been very impressive, so I have high hopes for this. Thank you.

[Admin]

I'm online, so you could try it on my demo boards. :)

Thanks. :)

[Admin]

I updated the code so now the links are in the right color, not black.

[theflow]

Originally posted by FireFly
I updated the code so now the links are in the right color, not black.

Thanks! Now fly to London, knock knock knock on door, hand code to vB team, insist they install imediately, or reveal bomb strapped to chest, set to detonate in 5 minutes.

[Admin]

I ain't no crazy Arab, man!

[theflow]

But you're coming close to parting the Red Sea around here...

thus won't surprise me in the least if, as your reward, others will start swatting at you when they should be using flypaper

[Admin]

I don't want people to start swat me. :(

[theflow]

Originally posted by FireFly
I don't want people to start swat me. :(

Then you may have to periodically dim your firefly wattage so as not to outshine and intimidate others...:) But in all seriousness, you're doing a phenomenal job helping so many people with code solutions and hacks.

I fully expect that your current 7.84 posts per day must increase to 20 per day such that within 2 months you have solved 75% of all outstanding hack requests. (standing ovation!)

[Admin]

*blushes* Thanks. :)