Forums / General Questions / MySQL quary admin log who change the product value?

MySQL quary admin log who change the product value?

Views: 532

Results 1 to 2 of 2
5 Mar 2015, 4:28 AM
#1
explorer1979 avatar

explorer1979

Inactive

Join Date:
Jan 2007
Posts:
377
Plugin Contributions:
0

MySQL quary admin log who change the product value?

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.

5 Mar 2015, 4:56 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: MySQL quary admin log who change the product value?

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.