MySQL quary admin log who change the product value?

[explorer1979]

Hi All,

I can using the Server's phpmyadmin.

And I am using ZC 1.3.9h now, will be plan upgrade to ZC 1.5.3 later

And I know ZC have a admin log table on it build-in.

For me, my store have more than one admin, on ZC 1.3.9h, for example

Admin A on today
Who change the product id #10407, from Products Quantity 10 to 100.

Then Admin B on three day later
407, from Products Quantity 100 to 150.

Do the log have record this? If so, how to using SQL script to find the record locked on this quick and easy?
Why I need run this type of SQL script is since other store admin tell me, he!!! Someone change the product quantity, it is not right, who do this etc questions, so I need a quick and easy way to see the log.

And, this record, special on the detail side of view, ZC 1.3.9h vs 1.5.3 or above, do they on detail record will different? Mean ZC 1.5.3 or up record above step on the admin log more detail than ZC 1.3.9h etc.


Thank you.

[DrByte]

Yes, v1.5.3 records more detail than v1.3.9. And v1.5.4 does much more.

Both v1.5.3 and v1.5.4 include an Activity Log viewer in the Admin. There isn't one for v1.3.9.

To view the details in v1.3.9 you'll need to use phpMyAdmin.