• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Need query to show all IPs by user

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

Jake Bunce

XenForo moderator
Staff member
#5
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.