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.

[Jinson]

I also had problems getting reset to work, here's how i fixed mine ->

-- Files --
admin/stats_admin_activity.php
admin/stats_admin_activity_all.php

Replaced the top part just after the include of application_top.php

// added by Jinson on 12th July 2008. Because this script was
// originally written expecting register globals to be on
$action = $_GET['action'];

switch($action) {

// clean out the admin_activity_log
    case 'clean_admin_activity_log':
      $db->Execute("delete from " . TABLE_ADMIN_ACTIVITY);
      $db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY);
      $messageStack->add_session(SUCCESS_CLEAN_ADMIN_ACTIVITY_LOG, 'success');
      unset($_SESSION['reset_admin_activity_log']);
      zen_redirect(zen_href_link(stats_admin_activity));
    break;
    } // eof: action
unset($action); 

[Steven300]

Thanks Jinson, that's a big help.

Have you uploaded this change to the contributions area?

[Steven300]

Ok I have uploaded the suggested change.

Should be approved within the next couple of days.

Hopefully that's the end of the reset problems.

[ccembd]

Thanks you to the both of you. I am sorry I have not gotten to this yet, I have been overwhelmed with other changes needing to be done to my site and did a bit of damage in the process. I figured I had till the next reset time to do these changes.

Thanks again for all your help, I will go make the changes now. Cat