Dolphin - Record user Name and 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

{$sFromC}{$sDatatimeC}

Change it to

IDUserName{$sFromC}{$sDatatimeC}

Find

$sLastDT = $aIPList['DateTime'];

Add After

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

Find

$sTableRes .= "{$sFrom}{$sLastDT}";

Replace it with

$sTableRes .= "{$sUserID}{$sUserName}{$sFrom}{$sLastDT}";

All Done!!

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