• Resolved pantsman28

    (@pantsman28)


    There doesn’t seem to be a quick way to replace fixture start times.
    need to bulk change the start time from 8.30pm to 8.15pm.

    The plugin doen’t give this option for quick edit.

    Only way around this is a find and replace in the database, but not sure what or where to rewrite the script?

    Any ideas

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Savvas

    (@savvasha)

    You can try a 3nd-party plugin like Bulk edit publish date.

    Thanks,
    Savvas

    Thread Starter pantsman28

    (@pantsman28)

    before I try on my local version. Will this change the fixture dates? or only change the scheduled/publish date?

    not sure if these are separate entities?

    Thread Starter pantsman28

    (@pantsman28)

    Doesn’t work. it changes all the fixture dates to the same day and time.
    Tested on a handful of fixtures, does change the time but also the dates they play.
    Glad I didn’t do this on a live site.

    Roch

    (@rochesterj)

    Hi there!

    Thanks for your reply.

    Indeed, doing that on a live site or without a backup is not a good idea.

    As for your request, unfortunately we don’t have a feature for this at the moment, so it requires some custom coding. You can hire a developer to do that for you or use a plugin (it’s unfortunate that Savvas’ suggestion didn’t work, that’s the easiest path).

    Thanks!

    Thread Starter pantsman28

    (@pantsman28)

    it’s a shame and something to consider for a future release.

    Instead of custom coding is there not a way to put a rewrite into sql for a quick fix.
    UPDATE wp_posts SET post_content = replace(post_date,'20:30:00', '20:15:00'); UPDATE wp_posts SET post_content = replace(post_date_gmt,'20:30:00', '20:15:00');

    but this doesn’t seem to change anything

    Thread Starter pantsman28

    (@pantsman28)

    found away to update this area, without additional plugins or development costs.

    UPDATE wp_posts SET post_date = replace(post_date,'20:30:00', '20:15:00'); UPDATE wp_posts SET post_date_gmt = replace(post_date_gmt,'20:30:00', '20:15:00');

    Roch

    (@rochesterj)

    That’s awesome, thanks for sharing this!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘change to fixture time’ is closed to new replies.