Every games displayed with version 4.1

  • Resolved idbx

    (@idbx)


    9 years, 10 months ago

    Hi,

    I have just installed WP League Manager 4.1.

    My main issue is that now every games appear in the tab, not only the games of the day.
    Really, it is not very nice to see more then 50 games at the same time.

    What should we do so that games are displeayed per day like in the previous version?

    Thanks for this great plugin!

    Chris

    https://www.ads-software.com/plugins/leaguemanager/

Viewing 16 replies (of 16 total)

  • After some debug, I’ve found the issue.

    Version 3.9.1.1
    In file core.php in the function getMatchDay(); there is a call to prepare method of $wpdb, that convert all season value to integer. If you set that value to 2015/16, as most used, you have 2015 in query that select match day.

    You should change this:
    405: $sql = "SELECT id, match_day, DATEDIFF(NOW(), date) AS datediff FROM {$wpdb->leaguemanager_matches} WHERE league_id = '%d' AND season = '%d' ORDER BY datediff ASC";

    with:
    405: $sql = "SELECT id, match_day, DATEDIFF(NOW(), date) AS datediff FROM {$wpdb->leaguemanager_matches} WHERE league_id = '%d' AND season = '%s' ORDER BY datediff ASC";

    This because the prepare method convers all value to integer if called with %d. if you want a decimal value (ie 2015/16) you must call with %s.

    Hope it will be fixed in the next update also in the other case.

    hope it’s helpfull

Viewing 16 replies (of 16 total)
  • The topic ‘Every games displayed with version 4.1’ is closed to new replies.