• Updating the Player Details have become a dreadful task. So I went to mySQL database to see how things are stored. Yikes! No fault to SportsPress but WordPress makes this thing messy.

    I discovered how to automatically add a new season to existing player profiles (because you can’t add existing player details using import) using the table wp_term_relationships
    It’s setup with 3 simple columns
    object_id term_taxonomy_id term_order
    where
    object_id is the wordpress post # for the player
    and term_taxonomy_id is the post ID# for the season
    term_order is always 0
    so I created a csv file, loaded it and boom – All players on the list had the new season.

    Question:
    How do I perform a similar action to check the new season box in their profile, whether an SQL statement or csv file. I can’t figure out what the box is associated with.
    https://snag.gy/68m1s3

    I see there is another table called wp_postmeta that houses alot of the details and associations for things like current team, past team etc.
    example from table:
    meta_id post_id meta_key meta_value
    unique id player post id# sp_current_team team post id#
    But for the life of me, i can’t figure out how to check the season box.
    what’s the meta_key and meta_value for the box
    or SQL statement to run?
    Help!!!

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi!

    I’m sending this to our dev team to see if they can help you there. Please stand by

    Kind Regards,
    -Roch

    Thread Starter Aikan

    (@aikan)

    Thanks!

    Hi!

    So initially our dev team told me that it would be quite hard to do, as WP stores those as serialized arrays in the DB. But good news, the career totals will appear under each table after the next update, instead of as its own table. This way, you only need to add that player to that season and the total will automatically be displayed for that season.

    Just wait for the next update and you’ll see ??

    Kind Regards,
    -Roch

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL to Check the Season Box in Player Profile’ is closed to new replies.