Discussion in 'XenForo Questions and Support' started by Blue, Jun 26, 2011.
Could someone post a query that would show all IPs used by a user?
SELECT * FROM `xf_ip` WHERE `user_id` =1337
Change 1337 to the users id number
Does Xenforo have an index on IPs by default? I know vb didn't and we had to add one or else our moderators will kill the forums hunting down ban evaders.
Yes I see an index for IPs in the schema. XenForo also stores IPs as integers which has performance benefits, especially when you are searching for a range of IPs.
Thanks for the info! I just bought a license to play around with and haven't had a chance to look at it yet.
Separate names with a comma.