mass extend user upgrades

[GKBlaze]

Does anyone know how I can mass extend all active user upgrades by a certain amount of time? I remember doing this in vBulletin by running a sql query. If there is no traditional way to accomplish this can someone help me write the sql query?

Thank you in advance

 

[Jake Bunce]

https://xenforo.com/community/threads/upgrade-active-user-upgrade-accounts.15693/#post-206321

 

[GKBlaze]

https://xenforo.com/community/threads/upgrade-active-user-upgrade-accounts.15693/#post-206321

What is the *60*60*24? could you take a moment and write query that increases for 2 days? Thanks for your help.

 

[Jake Bunce]

What is the *60*60*24? could you take a moment and write query that increases for 2 days? Thanks for your help.

That is 60 seconds times 60 minutes times 24 hours.

This is 2 days:

UPDATE xf_user_upgrade_active
SET end_date = end_date + 2*60*60*24