SQL query to update account upgrade timestamp

[Andy.N]

I would I change the Start date of a member in Account Upgrade?

 

[Jake Bunce]

UPDATE xf_user_upgrade_active
SET start_date = UNIX_TIMESTAMP('2010-01-15 00:00:00')

That should do it.

 

[Andy.N]

Thanks Jake,
Here is another from xfrocks

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]

Thanks Jake,
Here is another from xfrocks

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.