Is there a way to search for partial IP addresses? Some of the staff uses it to cross-check suspicious members. I tried a wildcard (like 127.0.0.*) and that didn't work, and neither did entering just a partial bit of the address (127.0.0).
Could this be because of the way the IP address is stored?
I don't think there is a way to do that, but you can use a query:
JOIN `xf_user` ON (`xf_user`.`user_id` = `xf_ip`.`user_id`)
WHERE `ip` >= INET_ATON('22.214.171.124') AND `ip` <= INET_ATON('126.96.36.199')
GROUP BY `xf_ip`.`user_id`
I'm not sure how this query may perform on larger databases. With 100 results this query took 0.78 seconds on my database with 1216900 rows.
XenForo stores IP addresses a number, so this searches inclusively from 1443966976 to 1443971071.