Last modified: 2014-01-03 15:42:20 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-51. Summary: List all indef-blocked IPs and all blocked IP ranges on enwikibooks Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Mike.lifeguard <mike.lifeguard+ts@gmail.com> Date: Fri, 14 Nov 2008 02:17:24 ------------------------------------------------------------------------------- I suppose those are actually separate queries, but can we get a list of all the indefblocked IPs on enwikibooks, plus all rangeblocks currently in effect, whatever their length? Preferably as a table with the time stamp, blocking admin and the reason. Thanks
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@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).
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+bugs@gmail.com