Ranking order and display.

+1 for

” for the next version would it be possible to create games 5 by 5, 10 by 10 … instead creating the games one by one ? ”

To change the order you would have to change the get_ranking_order() function in admin/class-football-pool-score-calculation.php.

About the games admin: I will add it to my feature list. Not sure when I will be able to implement it, though.

Tip: if you want to add a lot of games simultaneously you can use the csv import function. I use it myself all the time.
I have an Excel file that contains columns for all match data and a column where I concatenate all that info from one row in a csv format (e.g. =A1 & “;” & B1 & “;” & C1). Copy & paste that column in a text file and import the file. Just make sure you add the column headings as the first row, surround your values with double quotes (if needed) and save the text as UTF-8 without BOM (use Notepad++ or a similar editor).

Thanks for the tips to change the order. I haden’t looked into this file … oops ??

I will test the Excel file, personally i use a txt file with lines game like this:
INSERT INTOpool_wp_matches` VALUES (351, 1, 19, 8, NULL, NULL, ‘2014-05-05 7:30:00 p.m. ‘, 36);
INSERT INTO pool_wp_matches VALUES (352, 1, 12, 4, NULL, NULL, ‘2014-05-06 7:45:00 p.m. ‘, 36);`
And after a SQL query to import this into the database. it or CSV for people who don’t want annoy it is not intuitive.

thanks for all!

@ R2one :

Could you tell me what change in

get_ranking_order() function in admin/class-football-pool-score-calculation.php

to do to have

ORDER BY:
1 / POINTS
2 / TOTAL GAME PREDICTION
3 / # FULL SCORE

???

TY

NAno.

I’ve change this :

After the line 645 :

COALESCE( MAX( s.total_score ), 0 ) AS points,

Add a line like this (nbpred it’s for total game pred)

COUNT(user_id) AS nbpred,

After, near the line 662 :

ORDER BY points DESC, full DESC, toto DESC, bonus DESC, "

Add the nbpred in this line :

ORDER BY points DESC, nbpred DESC, full DESC, toto DESC, bonus DESC, "