• 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

Regs

Active Member
AMS Premium
SC Premium
Pick'em
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.
 
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
 
Back
Top