paidExpiryDate does not clear

[pilot830]

After a users premium account expires, their level_id on the users table does revert back to 1 (free), but their paidExpiryDate value is still the due date of their expiry

+---------------------+----------+
| paidExpiryDate | level_id |
+---------------------+----------+
| 2016-04-16 03:26:07 | 1 |
+---------------------+----------+

Shouldn't the paidexpirydate revert back to NULL or 0000-00-00 00:00:00 ?

i mean because right now its 2016-05-11 and they haven't upgraded again, yet the value is still 2016-04-16, it should clear

 

[enricodias4654]

No, it shouldn't. You will lose information if you reset this.

 

[pilot830]

No, it shouldn't. You will lose information if you reset this.

Lose what information? their past orders are still logged in the premium_order table and the payment_log table..

 

[enricodias4654]

Imagine that you are sending an email marketing campaign sending a coupon code to all accounts that expired 1 week ago. You will need to perform complex queries in the log tables to do it.

Also a user can be premium without paying, you can manually set the paidExpiryDate in the admin to give someone some days. This feature can also be used to add some days to all users as a compensation in case of problems with your server/script. In that case there is no logs and the information is lost.

There is absolutely no reason to clear paidExpiryDate at all.