R2one

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, "

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!