liorclub
Forum Replies Created
-
Forum: Plugins
In reply to: [Football Pool] Reveal users predictionsThanks for the quick and detailed response!
Forum: Plugins
In reply to: [World Cup Predictor] About draw in players pointsfollowing..
- This reply was modified 6 years, 10 months ago by liorclub.
Forum: Plugins
In reply to: [World Cup Predictor] Sort user prediction after kickoffIts working.
Thanks koobeza & landowebForum: Plugins
In reply to: [World Cup Predictor] Sort user prediction after kickoffhttps://www.sizmekworldcup.com/?page_id=229&wcp=predictions&user=26
This list sorted by group and not by kickoffForum: Plugins
In reply to: [World Cup Predictor] Sort user prediction after kickoffThanks, 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,
LiorForum: Plugins
In reply to: [World Cup Predictor] Points error, prediction time changes with match resultJust 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 …
Forum: Plugins
In reply to: [World Cup Predictor] StaticticGood 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 FROMo4h_wcup_prediction
GROUP BY score , match_id) AS results
INNER JOINo4h_wcup_match
AS matches ON results.match_id = matches.match_id WHERE matches.match_id = @match_id ORDER BY results.predictors
DESC LIMIT 1Hope it helps ??
Forum: Plugins
In reply to: [World Cup Predictor] are results automatically importedmust 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 ?
Forum: Plugins
In reply to: [World Cup Predictor] Question for predictionsHi, 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.