Admin Activity Report [support thread]

[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

[nguyenkhv]

Hi Steven,
I have questions on the activity report.

1 Why some recrods are hihg lighted RED?
2. sometimes, the Admin ID is 0?
Thanks,