Ordering of output

Tallman
.
Posts: 24
Joined: Thu Jul 24, 2008 10:25 pm

Ordering of output

Postby Tallman » Tue Sep 16, 2008 2:30 am

I noticed that this module only sorts by the quantity of the event (e.g. goals scored). When you have several players at the same rank, they are sorted arbitrarily. I think they should at least be sorted by lastname, firstname, so I changed lines 73 and 86 of mod_joomleague_events_statistic.php

from

Code: Select all

ORDER BY value DESC  LIMIT 0 , %s",$eventtype, $project->id, $limit);


to

Code: Select all

ORDER BY value DESC, p.lastname, p.firstname  LIMIT 0 , %s",$eventtype, $project->id, $limit);


Probably a better solution would be to add an order_by parameter to the module, and give a choice of lastname, firstname, teamname or teamname, lastname, firstname.

perry
Newbie
Posts: 2
Joined: Sun Jun 15, 2008 2:21 pm

Re: Ordering of output

Postby perry » Tue Nov 11, 2008 12:02 pm

Hi,
I've tried your solution, changing the two lines in mod_joomleague_events_statistic.php, but the output in my goal scored rank is still "not ordered" for the players at the same rank.

Have you any suggestion?
-- la natura non fa nulla di inutile --

Joomla 1.0.13 stable / Joomleague 0.92


Return to “mod_joomleague_events_statistic”

Who is online

Users browsing this forum: No registered users and 2 guests