mass extend user upgrades

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

XenForo moderator
Staff member
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