1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Resolved Resetting Survivor pools - Season postponements issue.

Discussion in 'Pickem Support' started by BIGLLC, Jun 1, 2020.

  1. BIGLLC

    BIGLLC New Member Pickem

    With our football season now restarting, I have fired up Pickem again.

    The issue I am having is that the Survivor pickem pools are now showing as closed with all players eliminated.

    How can we reset them?
     
  2. Bob

    Bob Developer Staff Member

    There is not a function for that, so it would have to be handled manually. If I can get phpMyAdmin and Admin CP access, I can do it for you. Start a conversation with me to discuss the process and provide me with the credentials :) Won't be able to get to it until sometime tomorrow tho.
     
  3. BIGLLC

    BIGLLC New Member Pickem

    I don't think I can give you access to the DB, but with instructions we could do it ourselves.
     
  4. Bob

    Bob Developer Staff Member

    If you don't want my help, you can always do it yourself via editing each player in the Pool.

    Admin CP >> Pickem >> Pools

    Click on the "Players" link for the specific Survivor Pool. This will bring up a listing of all the players that that specific Survivor Pool. You can edit EACH ONE (one by one) and reset that individual players pool data.

    Example, here is a player in a Survivor Pool. You can see that there are several inputs (this being a triple elimination pool).

    Selection_999(136).png

    What you will want to do is re-set all of those to their initial settings:

    Player status: Active
    Strikes received: No strikes
    Week strike 1 received: No strike
    Week strike 2 received: No strike
    Week strike 3 received: No strike
    Week eliminated: Not eliminated

    You'll need to do that for all the players in the Pool.

    NOW... before doing this, make sure that there are not any weeks that are not going to be played... eg, if there is a WEEK for this actual week, but games in reality are not being played, you remove that week from the season before doing any of this "resetting", other wise, that week is going to be processed, whether the actual games are played or not and that is going to effect the system.

    Anyway... if you have a lot of players in the pool, this process could take you awhile (which is why I volunteered my free time for a non support issue to help out a fellow sports nut). Im not a teacher and this is not something that I am going to write a guide or how-to for.

    With that said, I do have plans to add a "Reset Pool" for Survivor pools. Not much good right now, but will come in handy in the future.

    PS... another thing you could do would be to create a new pool and have all the members join the new pool. It would start with the current week of the season (we do this for Mid Season Pools).
     
  5. BIGLLC

    BIGLLC New Member Pickem

    Given a recent data breach, access to the database etc is kept pretty tight.

    Thanks for your help - I never got to do it anyway. Might start from a later round.

    Getting people to re-join a new pool just leaks players. Better to do as much for them as possible.
     
  6. tajhay

    tajhay Active Member AMS Premium SC Premium Sportsbook Pickem Power Rankings Survivor

    We ended up creating new pools for players to join.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.