1. REGISTRATION REQUIREMENTS:

    Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to 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.

Can someone remind me which option will give people the default starting cash once they hit 0?

Discussion in 'Sportsbook Support' started by RobParker, Nov 1, 2018.

  1. RobParker

    RobParker Member SC Premium Pickem Sportsbook

    I'm sure this is/was an option but I can't seem to find it.
     
  2. Bob

    Bob Developer Staff Member

    You might be referring to the "Cash to poor" feature that is part of Sportsbook 1.x (Sportsbook Options).

    SB 2.0 does not have a "Cash to poor" system (removed on purpose as it was only a temp solution for a couple of the early Sportsbook license holders).

    If you are running SB 2.0, Id suggest looking into one of the really nice cash/points systems so that you members can actually EARN (by posting) to get more cash ;) (yes, I am a MEANY lol)
     
    ZackM and RobParker like this.
  3. RobParker

    RobParker Member SC Premium Pickem Sportsbook

    Exactly what I meant, thanks!

    We don't really want to install a points systems. Is there any other way to do it?

    Could I manually just run an SQL query to add the default back to anyone who's at 0?

    If that's possible, could you help with the query?
     
  4. Bob

    Bob Developer Staff Member

    Ya, a simply SQL query will do the trick ;) Here are a couple examples. Replace 500 with the amount you want to give them

    This will set the Sportsbook cash to 500 for all users that have exactly 0.
    Code:
    UPDATE xf_user
    SET xa_sb_cash = 500
    WHERE xa_sb_cash = 0
    This will set the Sportsbook cash to 500 for all users that have less than 10.
    Code:
    UPDATE xf_user
    SET xa_sb_cash = 500
    WHERE xa_sb_cash < 10
     
  5. RobParker

    RobParker Member SC Premium Pickem Sportsbook

    Thanks!
     
    Bob likes this.
  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.