• 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

Andy.N

Well-known member
#3
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)
 

Jake Bunce

XenForo moderator
Staff member
#4
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)
Oh yeah. It would be important to have a WHERE condition to update only a specific user and upgrade. o_O