DBQ-51 List all indef-blocked IPs and all blocked IP ranges on enwikibooks
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:42 PM

Description

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

Version: unspecified
Severity: minor

Details

Reference: bz59306

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:22 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59306.

JiraBugConverter created this task.Jan 3 2014, 3:42 PM

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;

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

DBQ-51 List all indef-blocked IPs and all blocked IP ranges on enwikibooksClosed, ResolvedPublicActions