Sort user prediction after kickoff

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?

https://www.sizmekworldcup.com/?page_id=229&wcp=predictions&user=26
This list sorted by group and not by kickoff

https://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. ??

As you wish. https://euleo.kunastudio.pl/jak-obstawiali-inni/?wcp=predictions&user=30

Thanks. Issue resolved then.

Its working.
Thanks koobeza & landoweb