Last modified: 2014-01-03 15:46:24 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-63. Summary: List of indef blocked IP addresses on en.wiki with "proxy" or "tor" in the block message Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Nakon <nakonwiki@gmail.com> Date: Wed, 13 May 2009 15:30:43 ------------------------------------------------------------------------------- I am attempting to compile a list of IP addresses on en.wiki that are blocked indef as a result of a proxy check or tor check. If a plaintext list could be generated with just an IP address on each line, I would appreciate it.
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Wed, 13 May 2009 17:19:31 ------------------------------------------------------------------------------- I ran this query: SELECT ipb_address, ipb_reason FROM ipblocks WHERE ipb_expiry = "infinity" AND ipb_user = 0; Output is available here: http://toolserver.org/~mzmcbride/dbq/dbq-63.txt.gz It's 21422 rows. I would've filtered it for you, but the ipb_reason field is a bit difficult to tell if it was a proxy / Tor sometimes (things like administrator.net hit for "tor", etc.). By my count, about 18,000 entries will match your criteria.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: nakonwiki@gmail.com, b@mzmcbride.com