/ Register

  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.

Query to copy built-in cash to new field

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

  1. Mar 18, 2016 #1
    Regs

    Regs Active Member AMS Premium SC Premium Pickem Power Rankings Sportsbook 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. Mar 18, 2016 #2
    Bob

    Bob Developer Staff Member

    is the target field empty or does it have values?
     
  3. Mar 18, 2016 #3
    Regs

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

    It'll be empty
     
  4. Mar 18, 2016 #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. Mar 18, 2016 #5
    Regs

    Regs Active Member AMS Premium SC Premium Pickem Power Rankings Sportsbook 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.
    Accept Learn More...