Knowledgebase: General Q&A
Can I disable user account expiration or set them all (globally) to 2030 ?
Posted by Esvon Support on 08 February 2011 09:19 AM
To make all the existing user accounts expire on 31 Dec 2037 you can run the following query from Admin Area -> SQL Command
(assuming "ec4_" is the tables prefix you use):

UPDATE ec4_user SET exp_date=FROM_UNIXTIME(2145823200),
hw_pay_plan="[SUB_FREE-2145823200]"

For new user accounts to have max. possible expiration date,
go to Admin Area -> Price Plans and make sure that "SUB" plans have "9999" value in "Expires, days"

Comments (0)
Help Desk Software by Kayako Fusion