liorclub

Thanks for the quick and detailed response!

following..

• This reply was modified 6 years, 10 months ago by liorclub.

Its working.
Thanks koobeza & landoweb

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

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

Just and offer, haven’t tried it,
but may-be you can remove the match score, and go to match settings for first match, update match time to be after the prediction time.
Than, enter the match score again and mark it as finished.

hope it helps …

Good for premium version ??

I wrote this query for most predicted score by match id
You can run it on your DB and than display it on your website (better than nothing)
just change @match_id to you match id and run.
you can remove LIMIT 1 to get how many predictors for each game.

SELECT results.score,results.predictors FROM (
SELECT CONCAT(CAST(home_goals AS CHAR(2)), ‘:’,CAST(away_goals AS CHAR(2))) AS score, count(match_id) AS predictors, match_id FROM o4h_wcup_prediction
GROUP BY score , match_id) AS results
INNER JOIN o4h_wcup_match AS matches ON results.match_id = matches.match_id WHERE matches.match_id = @match_id ORDER BY results.predictors
DESC LIMIT 1

Hope it helps ??

must have it on v2 ??

landoweb,
that doesn’t work, see this:

My page include:
[world-cup-predictor results=1 kickoff=1]

but match results are still sorted by groups

https://www.sizmekworldcup.com/?page_id=17

Is there any workaround for that ?

Hi, it’s not an official reply, but I’m pretty sure I read somewhere (can’t find it now) that users can make predictions till kickoff time of each game.