Latest Admin Actions on Admin CP Index

[derekivey]

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 (https://vborg.vbsupport.ru/showthread.php?p=745518)
3.6.0 Version is located here (https://vborg.vbsupport.ru/showthread.php?t=117976).

Thanks goes to Hellraider for translating this hack to German. (http://www.vbhacks-germany.com/forum/showthread.php?t=3087)

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 https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=93245) 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

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...

[Andreas]

RC3 is out, update? :)

[derekivey]

Haven't had a chance to upgrade my test board to RC3 yet. Will look into it.

Derek

[derekivey]

Ok... I have upgraded it to version 1.0.3. It only works on vBulletin RC3, it will not work on RC 1 or 2. It now uses plugins instead of file edits. Let me know if you have any problems with it.

Derek

[MarsNIIT]

Please help me error :(

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT adminlog.*, user.username FROM abc_adminlog
LEFT JOIN abc_user AS user ON (user.userid = adminlog.userid)
ORDER BY adminlogid DESC LIMIT 10;

MySQL Error : Unknown table 'adminlog'
Error Number : 1051
Date : Tuesday, September 13th 2005 @ 04:23:49 AM
Script : http://www.forums.niitvn.info/x_AdminCP/index.php?do=home
Referrer : http://www.forums.niitvn.info/x_AdminCP/index.php?do=nav
IP Address : 58.186.11.53
Username : MarsNIIT
Classname : vb_database

[derekivey]

Please help me error :(

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT adminlog.*, user.username FROM abc_adminlog
LEFT JOIN abc_user AS user ON (user.userid = adminlog.userid)
ORDER BY adminlogid DESC LIMIT 10;

MySQL Error : Unknown table 'adminlog'
Error Number : 1051
Date : Tuesday, September 13th 2005 @ 04:23:49 AM
Script : http://www.forums.niitvn.info/x_AdminCP/index.php?do=home
Referrer : http://www.forums.niitvn.info/x_AdminCP/index.php?do=nav
IP Address : 58.186.11.53
Username : MarsNIIT
Classname : vb_database

Ok, Thanks for letting me know. I think it's a problem with the hack, that only happens when people are using a table prefix. I will take a look at this when I get home and find a fix for it.

Derek

[derekivey]

Ok, Thanks for letting me know. I think it's a problem with the hack, that only happens when people are using a table prefix. I will take a look at this when I get home and find a fix for it.

Derek

Ok, It's now fixed. Please redownload the zip file and delete the old plugin, then import the one in the zip file. It should now work.

Derek

[Boofo]

Can you have the window set to a certain size and scroll if we change the amount of lines for the info?

[derekivey]

Can you have the window set to a certain size and scroll if we change the amount of lines for the info?

Don't know, I will take a look and see later.

Derek

[Brinnie]

sorry if this is sutpid question, but will it show what the mods did.

because i already know what I did... I'm only concerned about what others do.

[derekivey]

It just grabs the data out of the admin log and shows what the admins did...

[Snake]

Thanks. Works fine on 3.5 Gold.

[derekivey]

Great :)

[JWalker05]

Is it supposed to just show the current time/date for every action??? Everytime I refresh it says the current time/date for every action...

[derekivey]

Hmm, Just noticed that. I'll take a look at it.

[derekivey]

Ok, Uninstall the plugin and redownload it here, and reinstall the new one. The bug is now fixed.

Thanks,
Derek

[JWalker05]

Works great now.

Thanks!

[derekivey]

No Problem :)

[ShadowOne]

works great for me....thank you

[derekivey]

Please click install if you are using this hack.

Thanks :)

[Will]

nice mod/plugin Derek

[derekivey]

Thanks Will :).