1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL query to update account upgrade timestamp

Discussion in 'XenForo Questions and Support' started by Andy.N, Dec 1, 2011.

  1. Andy.N

    Andy.N Well-Known Member

    I would I change the Start date of a member in Account Upgrade?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    UPDATE xf_user_upgrade_active
    SET start_date = UNIX_TIMESTAMP('2010-01-15 00:00:00')
    
    That should do it.
     
    Andy.N likes this.
  3. Andy.N

    Andy.N Well-Known Member

    Thanks Jake,
    Here is another from xfrocks
    Code:
    update `xf_user_upgrade_active` set start_date = X where user_id = Y and user_upgrade_id = Z

    X: the unix timestamp of the date you want to set
    Y: the user id
    Z: 1 or 2 (the user upgrade id)
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Oh yeah. It would be important to have a WHERE condition to update only a specific user and upgrade. o_O
     

Share This Page