You can edit the function score_match() in file wcp-reports.class.php, changing:
ORDER BY
points DESC
To:
ORDER BY
points DESC, display_name
Thanks, I will implement thid tomorrow and update you if its working.
Another sort I would like to do is on user prediction page, How to sort it by match kickoff and not by groups?
Thanks in advance,
Lior
What is the link of your website?
http://www.sizmekworldcup.com/?page_id=229&wcp=predictions&user=26
This list sorted by group and not by kickoff
Same “issue”, i think it’s better to sort it by kickoff. landoweb, which SQL is responsible for this report?
OK, found it. It’s line 1388. Delete sort_order in ORDER BY so it would look like:
$sql = "SELECT is_group,
h.name AS home_team_name, a.name AS away_team_name, is_result,
p.home_goals, p.away_goals, p.home_penalties, p.away_penalties,
m.home_goals AS mhg, m.away_goals AS mag, m.home_penalties AS mhp, m.away_penalties AS map,
h.country AS home_country, a.country AS away_country, points
FROM
{$wpdb->prefix}{$this->prefix}match m,
{$wpdb->prefix}{$this->prefix}prediction p,
{$wpdb->prefix}{$this->prefix}stage s,
{$wpdb->prefix}{$this->prefix}team h,
{$wpdb->prefix}{$this->prefix}team a
WHERE
m.stage_id = s.stage_id AND p.match_id = m.match_id AND
m.home_team_id = h.team_id AND m.away_team_id = a.team_id AND
p.user_id = %d $throttle
ORDER BY
kickoff";
@koobeza
Please inform the link of your website so that I can mark the topic as resolved. 🙂
Thanks. Issue resolved then.
Its working.
Thanks koobeza & landoweb
