FREE MOD - DeeEmm Record user ID with IP address

You can (fairly) easily record the userid along with the ip address by adding an extra field to the database table and modifying member.php

Here's how...

Add the following fields to the sys_ip_members_visits table in database

ALTER TABLE `sys_ip_members_visits` ADD `UserID` INT( 10 ) NOT NULL

ALTER TABLE `sys_ip_members_visits` ADD `UserName` VARCHAR( 30 ) NOT NULL

Then search for following line in member.php

$sInsertSQL = "INSERT INTO `sys_ip_members_visits` SET `From`='{$sCurLongIP}', `DateTime`=NOW()";

Replace it with

$aMemberInfo = getProfileInfoDirect($member['ID']);
$sUserName = $aMemberInfo['NickName'];

$sInsertSQL = "INSERT INTO `sys_ip_members_visits` SET `From`='{$sCurLongIP}', `DateTime`=NOW(), `UserID`='{$sUserID}', `UserName`='{$sUserName}'";

Now edit inc/classes/BxDolAdminIPBlocklist.php

Find

<tr>
 <td>{$sFromC}</td>
 <td>{$sDatatimeC}</td>
 </tr>

Change it to

<tr>
 <td>ID</td>
 <td>UserName</td>
 <td>{$sFromC}</td>
 <td>{$sDatatimeC}</td>
 </tr>

Find

$sLastDT = $aIPList['DateTime'];

Add After

$sUserID = $aIPList['UserID'];
$sUserName = $aIPList['UserName'];

Find

$sTableRes .= "<tr><td>{$sFrom}</td><td>{$sLastDT}</td></tr>";

Replace it with

$sTableRes .= "<tr><td>{$sUserID}</td><td>{$sUserName}</td><td>{$sFrom}</td><td>{$sLastDT}</td></tr>";

All Done!!

Now the userid will be recorded with the ip address and displayed in the table on the admin page.

Please Note:

• Please do not post support questions in the product reviews box, these will be ignored.
• Please do not post support questions by PM - I am not your personal support network.
• Your inability to install software is not my problem, I am happy to help, but if it really is beyond your capability - pay a professional.
• There is a support forum for posting support questions, both here, and on my site.
• If you want to engage my services direct, visit my website and send me an enquiry, including a detailed scope of works. I will then provide you with a fixed price quotation. My standard rate is AU$100/hour.
• If you download one of my products - install the product and try it - if you have an issue - ask a question in the support forum, if you like the product. THEN post your review.
• If you post a review BEFORE trying a product - what exactly are you reviewing??? That you managed to download the mod okay?? In this case - please post a comment on your OWN profile congratulating yourself.
• If I have helped you - why not show some love by leaving a nice positive review on MY profile.
• If I have pissed you off - GOOD - You probably deserved it  :)
• When leaving reviews, please consider that the MODS I post are generally free, and that I have given my time freely for YOUR benefit. I feel this is a generous action (see rate above), so if for some reason the mod is not quite what you need, instead of posting a bad review - why not turn that bitterness into something positive, and go hug a tree or something.