Code: Select all
SELECT COUNT(*) AS RangeCount FROM ac_BannedIPs WHERE StoreId = @storeId AND IPRangeStart <= @ipNumber AND IPRangeEnd >= @ipNumber
Thankfully the code I was concerned about only issued 1 query
Code: Select all
SELECT COUNT(*) AS RangeCount FROM ac_BannedIPs WHERE StoreId = @storeId AND IPRangeStart <= @ipNumber AND IPRangeEnd >= @ipNumber