User is deleted from WordPress but is stayed in the leaderboard

  • Resolved csandreas1

    (@csandreas1)


    6 years, 3 months ago

    Well users predict scores but when they are deleted from WordPress they are stayed in the leaderboard (empty row) as shown in the figure below. How can i manually delete the user from the Joomsport tables in the Database? Maybe i can add a simple if(user_exists) in the code as well

    • This topic was modified 6 years, 3 months ago by csandreas1.
    • This topic was modified 6 years, 3 months ago by csandreas1.
    • This topic was modified 6 years, 3 months ago by csandreas1.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor irenejs

    (@irenejs)

    Hi,
    To fix it manually please go to the file:

    /wp-content/plugins/joomsport-prediction/sportleague/classes/objects/class-jsport-prediction-prleaders.php

    Find the line:
    ." FROM {$wpdb->jswprediction_round_users} as u "

    and replace by:

    ." FROM {$wpdb->jswprediction_round_users} as u "
." JOIN {$wpdb->prefix}users as usr ON usr.ID = u.user_id”

    You need to replace it twice in the same document please!

    Also find the line:
    ." FROM {$wpdb->jswprediction_round_users} as u"

    replace by:

    ." FROM {$wpdb->jswprediction_round_users} as u "
." JOIN {$wpdb->prefix}users as usr ON usr.ID = u.user_id”

    We will improve reported issue in the future versions
    Let me know if any further support is required.
    Kind regards
    Irene

    • This reply was modified 6 years, 3 months ago by irenejs.
    Plugin Contributor irenejs

    (@irenejs)

    Please pay your attention that my initial answer was edited, I have put additional line to the second modification.

    Apologies for inconveniences
    Kind regards
    Irene

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘User is deleted from WordPress but is stayed in the leaderboard’ is closed to new replies.