Latest Admin Actions on Admin CP Index

Latest Admin Actions on Admin CP Index
Developer: derekivey
Version: 1.0.4 (Date bug fixed).
vBulletin Version: 3.5
File Edits: 0
Template Edits: 0
New Phrases: 1
Uses Plugins: Yes!
Difficulty: Easy

Description: This hack adds a table on the index of the Admin CP that shows the latest admin actions. It only shows it to super admins, but you can have it show up for regular admins by removing the if statement. It's setup to show the latest 10 actions as default, but you can change that by editing the variable in the code.

This hack is for vBulletin 3.5. If you are using vBulletin 3.0.x, use this hack
3.6.0 Version is located here.

Thanks goes to Hellraider for translating this hack to German.

I am still learning php, and will try and help you if you have any problems with this hack.

I have added a screen shot of this hack in action below.

Please click If you installed this hack.

Thanks!

[derekivey]

Updated hack to version 1.0.1. The only change is that I edited the code to make it more vBulletin complient. Thanks goes to MarcoH64 for telling me how.

[derekivey]

This hack has now been updated to version 1.0.2. The only change is that I edited it to add another query to show the admin's username instead of their userid. Let me know if you have any problems.

Derek

[Gizmo5h1t3]

installed it, works fine

[Andreas]

You are using that Query in a loop ... really not a good idea.

My suggestion:

Hook: admin_index_main

PHP Code:

if (can_access_logs($vbulletin->config['SpecialUsers']['canviewadminlog'])) 
{ 
    print_table_break();
    print_table_header($vbphrase['latest_admin_actions'], 7);
    print_cells_row(array('<b>Log ID</b>', '<b>UserID</b>', '<b>Date</b>', '<b>Script</b>', '<b>Action</b>', '<b>Extra Info</b>', '<b>IP Address</b>',), 0, 0, -5, 'top', 1, 1);
    $number_of_actions = 10; // Change this to the amount of admin actions you want shown.
    $sql = "SELECT adminlog.*, user.username FROM " . TABLE_PREFIX . "adminlog
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = adminlog.userid)
        ORDER BY adminlogid DESC LIMIT $number_of_actions";
    $sqlr = $db->query($sql);
    while($sr = $db->fetch_array($sqlr)) 
    {
        if (!$sr['extrainfo'])
        {
            $sr['extrainfo'] = 'N/A';
        }
        if (!$sr['action'])
        {
            $sr['action'] = 'None';
        }
        $sr['dateline'] = vbdate($vbulletin->options['logdateformat']);
        print_cells_row(array($sr['adminlogid'], "<a href=\"user.php?do=edit&amp;userid=$sr[userid]\">$sr[username]</a>", $sr['dateline'], $sr['script'], $sr['action'], $sr['extrainfo'], $sr['ipaddress'],), 0, 0, -5, 'top', 1, 1);
    }
    print_table_break();
} 


[derekivey]

Making it a plugin wouldn't work, because The hook is between the server load and the quick links so, it splits them up. I'll just make those changes and keep it as a code modification.

[Andreas]

The Code I posted above does work just fine as a Plugin on localhost

[derekivey]

Really? It looks like this for me...

[Andreas]

Yep, that's how it looks for me too.
Not ideal, but better then File Edits IMHO.

Btw: IIRC the Hook will be moved in RC3

[derekivey]

Ok, I will make this a plugin when RC3 comes...