R2one

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Forum: Plugins
    In reply to: [Football Pool] Ranking order and display.
    Thread Starter R2one

    (@r2one)

    11 years, 10 months ago

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

    Forum: Plugins
    In reply to: [Football Pool] Ranking order and display.
    Thread Starter R2one

    (@r2one)

    11 years, 10 months ago

    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!

Viewing 2 replies - 1 through 2 (of 2 total)