Locked Tables Enhancements

Hi Martyn,

The idea of lock the backend in certain hours is really good and I thought to add it in the past, but finally I discarded it because I thought the backend was protected enough with all the other features.

My thoughts are that a cron action shuts down the backend at a certain time of day and then activates it the following morning thereby protecting certain parts of the backend, such as product changes etc but still allows purchases.
As I write this I can see that this would need to allow new order creation etc. Would this be possible?
I use virtuemart btw.

This would be possible but doing it manually. This is: there is an option to lock the tables you desire into Global configuration -> Lock tables. If you set the "Easy view" to "No" you will be able to add, for instance, virtuemart_products or any other table.

This would prevent any unauthorized modification. But you should launch a "Lock tables" task manually from Control Center every evening and an "Unlock tables" task every morning. Or if you are able to distinguish which tables are not modified during a customer purchase then you can lock all of them because you will be sure it will not affect your business.

I don't recommend this option on ecommerce or live sites because during a purchase there are many affected tables but if you are able to locate all of them (for instance using a test environment) then you will be fully protected against unauthorized changes.

Regards,
Jose

You're welcome!

Regarding to the "sticky" buttons of the other post, I will add the improvement in the next version (1.1.30).

Regards,
Jose