Qatar 2020 Times are off

  • Resolved Belindo

    (@belindo)


    2 years, 1 month ago

    My time settings are correctly (Amsterdam), but after importing the csv from within the plugin, as of the Round of 16, matches start at 19:00 and 20:00 CET. In the match settings, the UTC times are 18:00 and 19:00. However, all matches starting at 19:00 CET actually start at 16:00 CET according to the FIFA schedule, so the UTC time should be 15:00

    I’ve changed it manually right now, but for new users it might be handy if the provided CSV is fixes

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author AntoineH

    (@antoineh)

    Hi @belindo,

    Good catch! To be honest, I just took this file from the forum, translated the names of teams and added some images, but never checked all the times in the schedule.

    I now made some changes to the schedule and released a new version with this corrected file.

    If we already have users and predictions, to update the dates in bulk, any way or have to do manually?

    Plugin Author AntoineH

    (@antoineh)

    You can’t do a bulk import from the admin, because that will remove all predictions.

    You should manually change the dates via the admin. Or, if the matches were created from an import & overwrite, then the match IDs should be the same as mine and then you can run the following database script to update all matches with the correct times *)

    UPDATE pool_wp_matches SET play_date='2022-11-20 16:00' WHERE id=1;
UPDATE pool_wp_matches SET play_date='2022-11-21 13:00' WHERE id=2;
UPDATE pool_wp_matches SET play_date='2022-11-21 16:00' WHERE id=3;
UPDATE pool_wp_matches SET play_date='2022-11-21 19:00' WHERE id=4;
UPDATE pool_wp_matches SET play_date='2022-11-22 10:00' WHERE id=5;
UPDATE pool_wp_matches SET play_date='2022-11-22 13:00' WHERE id=6;
UPDATE pool_wp_matches SET play_date='2022-11-22 16:00' WHERE id=7;
UPDATE pool_wp_matches SET play_date='2022-11-22 19:00' WHERE id=8;
UPDATE pool_wp_matches SET play_date='2022-11-23 10:00' WHERE id=9;
UPDATE pool_wp_matches SET play_date='2022-11-23 13:00' WHERE id=10;
UPDATE pool_wp_matches SET play_date='2022-11-23 16:00' WHERE id=11;
UPDATE pool_wp_matches SET play_date='2022-11-23 19:00' WHERE id=12;
UPDATE pool_wp_matches SET play_date='2022-11-24 10:00' WHERE id=13;
UPDATE pool_wp_matches SET play_date='2022-11-24 13:00' WHERE id=14;
UPDATE pool_wp_matches SET play_date='2022-11-24 16:00' WHERE id=15;
UPDATE pool_wp_matches SET play_date='2022-11-24 19:00' WHERE id=16;
UPDATE pool_wp_matches SET play_date='2022-11-25 10:00' WHERE id=17;
UPDATE pool_wp_matches SET play_date='2022-11-25 13:00' WHERE id=18;
UPDATE pool_wp_matches SET play_date='2022-11-25 16:00' WHERE id=19;
UPDATE pool_wp_matches SET play_date='2022-11-25 19:00' WHERE id=20;
UPDATE pool_wp_matches SET play_date='2022-11-26 10:00' WHERE id=21;
UPDATE pool_wp_matches SET play_date='2022-11-26 13:00' WHERE id=22;
UPDATE pool_wp_matches SET play_date='2022-11-26 16:00' WHERE id=23;
UPDATE pool_wp_matches SET play_date='2022-11-26 19:00' WHERE id=24;
UPDATE pool_wp_matches SET play_date='2022-11-27 10:00' WHERE id=25;
UPDATE pool_wp_matches SET play_date='2022-11-27 13:00' WHERE id=26;
UPDATE pool_wp_matches SET play_date='2022-11-27 16:00' WHERE id=27;
UPDATE pool_wp_matches SET play_date='2022-11-27 19:00' WHERE id=28;
UPDATE pool_wp_matches SET play_date='2022-11-28 10:00' WHERE id=29;
UPDATE pool_wp_matches SET play_date='2022-11-28 13:00' WHERE id=30;
UPDATE pool_wp_matches SET play_date='2022-11-28 16:00' WHERE id=31;
UPDATE pool_wp_matches SET play_date='2022-11-28 19:00' WHERE id=32;
UPDATE pool_wp_matches SET play_date='2022-11-29 15:00' WHERE id=33;
UPDATE pool_wp_matches SET play_date='2022-11-29 15:00' WHERE id=34;
UPDATE pool_wp_matches SET play_date='2022-11-29 19:00' WHERE id=35;
UPDATE pool_wp_matches SET play_date='2022-11-29 19:00' WHERE id=36;
UPDATE pool_wp_matches SET play_date='2022-11-30 15:00' WHERE id=37;
UPDATE pool_wp_matches SET play_date='2022-11-30 15:00' WHERE id=38;
UPDATE pool_wp_matches SET play_date='2022-11-30 19:00' WHERE id=39;
UPDATE pool_wp_matches SET play_date='2022-11-30 19:00' WHERE id=40;
UPDATE pool_wp_matches SET play_date='2022-12-01 15:00' WHERE id=41;
UPDATE pool_wp_matches SET play_date='2022-12-01 15:00' WHERE id=42;
UPDATE pool_wp_matches SET play_date='2022-12-01 19:00' WHERE id=43;
UPDATE pool_wp_matches SET play_date='2022-12-01 19:00' WHERE id=44;
UPDATE pool_wp_matches SET play_date='2022-12-02 15:00' WHERE id=45;
UPDATE pool_wp_matches SET play_date='2022-12-02 15:00' WHERE id=46;
UPDATE pool_wp_matches SET play_date='2022-12-02 19:00' WHERE id=47;
UPDATE pool_wp_matches SET play_date='2022-12-02 19:00' WHERE id=48;
UPDATE pool_wp_matches SET play_date='2022-12-03 15:00' WHERE id=49;
UPDATE pool_wp_matches SET play_date='2022-12-03 19:00' WHERE id=50;
UPDATE pool_wp_matches SET play_date='2022-12-04 15:00' WHERE id=51;
UPDATE pool_wp_matches SET play_date='2022-12-04 19:00' WHERE id=52;
UPDATE pool_wp_matches SET play_date='2022-12-05 15:00' WHERE id=53;
UPDATE pool_wp_matches SET play_date='2022-12-05 19:00' WHERE id=54;
UPDATE pool_wp_matches SET play_date='2022-12-06 15:00' WHERE id=55;
UPDATE pool_wp_matches SET play_date='2022-12-06 19:00' WHERE id=56;
UPDATE pool_wp_matches SET play_date='2022-12-09 15:00' WHERE id=57;
UPDATE pool_wp_matches SET play_date='2022-12-09 19:00' WHERE id=58;
UPDATE pool_wp_matches SET play_date='2022-12-10 15:00' WHERE id=59;
UPDATE pool_wp_matches SET play_date='2022-12-10 19:00' WHERE id=60;
UPDATE pool_wp_matches SET play_date='2022-12-13 19:00' WHERE id=61;
UPDATE pool_wp_matches SET play_date='2022-12-14 19:00' WHERE id=62;
UPDATE pool_wp_matches SET play_date='2022-12-17 15:00' WHERE id=63;
UPDATE pool_wp_matches SET play_date='2022-12-18 15:00' WHERE id=64;

    *) but please always do a database backup before running any scripts.

    thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Qatar 2020 Times are off’ is closed to new replies.