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.

Query to copy built-in cash to new field

Discussion in 'Sportsbook Support' started by Regs, Mar 18, 2016.

  1. Regs

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

    I'll be soon implementing a credits/points system and will have a dedicated currency for sportsbook.

    Setting it up to use the new credit field is easy enough but I would like to transfer any current sportsbook cash each user has into the new field before flipping the switch.

    @Bob - can you supply me with a simple query I can use in phpmyadmin to copy over the data?

    Cheers,

    Regs.
     
  2. Bob

    Bob Developer Staff Member

    is the target field empty or does it have values?
     
  3. Regs

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

    It'll be empty
     
  4. Bob

    Bob Developer Staff Member

    If the new field is empty, then its a rather simple query (basically copying the data from one field to another)
    Code:
    UPDATE tableName
    SET new_field = old_field
    Code:
    UPDATE xf_user
    SET name_of_your_new_field = sportsbook_cash
     
    Regs likes this.
  5. Regs

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

    Awesome, thanks @Bob !
     
    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.