Testing CloudFlare on my XF site

[motowebmaster]

Is there an option within the admincp that enables the ability to see the actual IP through CloudFlare's server network, or a file that I can edit?

 

[Jake Bunce]

Which IP address are you trying to see? The IP of the server? Of a user?

 

[motowebmaster]

The actual IP Address of the user.

 

[Jake Bunce]

There is no place in the Admin CP to view user IPs. But here is a query you can run on your database to view all IPs used by a particular user:

SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE user.username = 'admin'
GROUP BY ip.ip

Change this line appropriately to match whatever username you want:

WHERE user.username = 'admin'

 

[bottiger]

There is no place in the Admin CP to view user IPs. But here is a query you can run on your database to view all IPs used by a particular user:

SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE user.username = 'admin'
GROUP BY ip.ip

Change this line appropriately to match whatever username you want:

WHERE user.username = 'admin'

Thanks but I already used the user_id and tried selecting it from xf_ip. There were no entries. I don't know why. Maybe the registration entry gets deleted when the user falls outside the spam cleaner range?

I think Xenforo should save the last used IP per user.

 

[Jake Bunce]

It should log the IP during registration. I don't know why it's not there. But all IPs are stored in that table. There is nowhere else to look except in your server's access logs, but you can't match those records by forum username.

 

[bottiger]

Maybe it doesn't log the IP if the user signs in through Steam?

 

[Jake Bunce]

Maybe it doesn't log the IP if the user signs in through Steam?

Steam auth would be an addon. The addon may be neglecting the IP log.

 

[bottiger]

Steam auth would be an addon. The addon may be neglecting the IP log.

Do you know what line I need to add to make it record IPs during login?

 

[Jake Bunce]

An example from XenForo_ControllerPublic_Register:

		// log the ip of the user registering
		XenForo_Model_Ip::log($user['user_id'], 'user', $user['user_id'], 'register');