vanillaforums/Garden — Issue #1271: IP ban using '%' not working?
Author: elifarley
Created: 2011-12-16 23:57:51+00:00
State: open

Yesterday, I added an IP ban to '61.191.191.%' (see a SQL export below for more details)

```sql
INSERT INTO `GDN_Ban` (`BanID`, `BanType`, `BanValue`, `Notes`, `CountUsers`, `CountBlockedRegistrations`, `InsertUserID`, `DateInserted`)
VALUES (7, 'IPAddress', '61.191.191.%', '', 0, 0, 2, '2011-12-15 01:48:52');
```

Today, a spammer from 61.191.191.142 managed to confirm his email address and then showed up as a new applicant. (sql export below)

```sql
INSERT INTO `GDN_User` (`UserID`, `Name`, `Password`, `HashMethod`, `Photo`, `About`, `Email`, `ShowEmail`, `Gender`, `CountVisits`, `CountInvitations`, `CountNotifications`, `InviteUserID`, `DiscoveryText`, `Preferences`, `Permissions`, `Attributes`, `DateSetInvitations`, `DateOfBirth`, `DateFirstVisit`, `DateLastActive`, `LastIPAddress`, `DateInserted`, `InsertIPAddress`, `DateUpdated`, `UpdateIPAddress`, `HourOffset`, `Score`, `Admin`, `Banned`, `Deleted`, `CountUnreadConversations`, `CountDiscussions`, `CountUnreadDiscussions`, `CountComments`, `CountDrafts`, `CountBookmarks`)
VALUES(1650, 'Preantsat', '$P$BF4xYn1c3ml5eZ0SZ7u1MrLzzZQjaq0', 'Vanilla', NULL, NULL, 'santaaqc@hotmail.com', 0, 'm', 0, 0, NULL, NULL, 'purple moncler vest\r\ngreen ski jacket\r\ndesigner mens jackets [...] been injudicious with trusty of generate admitting gravitation appreciably the connected complete witnessed in olympian totes. \r\nMoncler Shoes sales\r\nmoncler shoes[...]\r\n', NULL, '', 'a:2:{s:19:"ConfirmedEmailRoles";a:1:{i:0;i:4;}s:12:"TransientKey";s:12:"22MA7MMK155F";}', NULL, NULL, '2011-12-16 23:38:10', '2011-12-16 23:38:10', '61.191.191.142', '2011-12-16 23:38:10', NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
```