[Bug 59306] DBQ-51 List all indef-blocked IPs and all blocked IP ranges on enwikibooks

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59306

Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---

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: b...@mzmcbride.com, mike.lifeguard+b...@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59306] DBQ-51 List all indef-blocked IPs and all blocked IP ranges on enwikibooks

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59306

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: MZMcBride mzmcbr...@gmail.com
Date: Fri, 14 Nov 2008 02:30:44
---

Ran query. 

 SELECT CONCAT(| [[User talk:,ipb_address,]]\n| ,ipb_by_text,\n| 
 ,ipb_timestamp,\n| nowiki,ipb_reason,/nowiki\n|-)  
FROM ipblocks  
WHERE ipb_expiry = infinity  
AND ipb_user = 0;

Filtered out entries that contain
(proxies|proxy|tor\|`tor`|checkuser|school) in ipb_reason.

Results posted to http://en.wikipedia.org/w/index.php?oldid=251690830 (yeah,
posted to en.wiki, not en.wikibooks; sue me).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l