Admin Activity Report [support thread]

[Steven300]

This is the support thread for the Admin Activity Report contribution.

Whenever you visit a page in admin, an activity is logged in a database table.

Such data can prove useful when trying to determine who has been altering what, as well as making sure that your admin area hasn't been compromised.

Until now, any lookup had to be done directly from the database using a utility like phpMyAdmin. With this contribution, you can quickly and easily view this data within your admin area, in a nicely presented format.

Features include:
1. Ability to empty the database table's data
2. Highlights any visits to the login page from an unknown IP address.

Installation is simple with only 8 new files. No database modification.
No overwriting or overriding of files.

This mod can be found in the Downloads section:
http://www.zen-cart.com/index.php?ma...oducts_id=1030

[ccembd]

Thank you so much for this. All works except the reset function. But it is still very useful to see what who is doing what and where.

Thanks again for this useful contribution.

[Steven300]

Thanks ccembd, I'm pleased you found it useful. You mentioned that the reset function doesn't work. Could you describe what happens? And does this happen for both pages?

[ccembd]

When I used the reset button actually nothing happened. It didn't reset. It successfully reset when I used the reset button in Tools: Store Manager. I verfied this by going back and opening the Admin Activity Log which I now have thanks to you.

Hope this helps,
Cat

[Steven300]

Yep it does help It's an interesting issue because the reset function has worked for others. I'm wondering whether it could be a database prefix problem. Anyway I'll have a proper look and see if I can figure out what might be wrong.

[Steven300]

Okay I think this might work.

In the following file:
admin/stats_admin_activity.php

Find:

$db->Execute("delete from " . TABLE_ADMIN_ACTIVITY_LOG);
$db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY_LOG); 

Change to:

$db->Execute("delete from " . TABLE_ADMIN_ACTIVITY);
$db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY); 

If it does work, you'll need to make the same change to:
admin/stats_admin_activity_all.php

Either way, let me know.

[KissedbyPix]

1.3.8 new version not upgrade.

I am completely new to the admin side of zen and would like to install this mod myself. (everything else was done for me)

If someone can walk me through installing this mod I would be forever grateful.

Steven, you could make a mint writing a zen for dummies book...lol
thank you for being completely ZENned

[Steven300]

Steven, you could make a mint writing a zen for dummies book...lol

Well it's a nice idea but I don't think I could handle the number of refunds

Okay first thing to do is to make sure you have a good ftp program such as FileZilla to upload the mod's files.

Next you will want to make a backup of your site. This is always good practice to do before installing any mod. Backup all of your site's files, and your database as well.

You should have at some point changed your site's admin folder to something different for security purposes. If not, then you don't need to follow this next step. In the mod's files, change the name of the admin folder to match the name of the admin folder on your site.

Now you can upload all the mod's files. With FileZilla you can do this all in one go, as opposed to one file at a time. In the ftp program, connect to your site and navigate to the site's root directory where you should see your admin folder. Then in your ftp program, navigate to and upload the admin folder from the mod to your site's root directory. All the files should transfer across in their correct places.

Finally in your actual admin panel, go to Reports->Admin Activity and the admin activity report should be displayed. You might need to hit the refresh button before the new menu option shows up.

Sorry if some of my instructions are too simple, but I don't know what level you are at.

[KissedbyPix]

Got it! thank you so much!

[dab]

I know this mod is written for ZC 1.38 but is there any reason that it shouldn't work correctly on 1.37.
I have tried on a 1.37 test site and it seems ok, but I would be interested in any comments before I use it on a live site.