Last modified: 2014-01-03 16:09:37 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61459, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59459 - DBQ-181 Need to access deletion logs of articles by a specific user
DBQ-181 Need to access deletion logs of articles by a specific user
Status: RESOLVED FIXED
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized major
: ---
Assigned To: Bugzilla Bug Importer (valhallasw)
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 16:09 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-01-03 16:09 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 16:09:32 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-181.
Summary: Need to access deletion logs of articles by a specific user
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>

-------------------------------------------------------------------------------
From: Kevin Wayne Williams <kww@kwwilliams.com>
Date: Mon, 09 Apr 2012 17:26:50
-------------------------------------------------------------------------------

For building an abuse case against a user that spans project boundaries, I need to get the deletion logs for every article created by the user that have subsequently been deleted on all Wikimedia projects. Currently, I am looking at TBrandley, but I know that this query would be useful against many similar problematic editors. 

Note that I am not asking for a tool that allows me to view the deleted articles, or anything else that would be restricted to admins on the various projects. Users of all levels are allowed to see the deletion logs, there's just no way to search by creating user.
Comment 1 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:09:34 UTC
-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Thu, 12 Apr 2012 01:39:27
-------------------------------------------------------------------------------

First of all some notes on the data: The query gets a list of pages the user created which are now deleted (this can also include pages where the first revision(s) have been deleted, but not the entire page) and then it gets the FULL deletion log for those pages (so that there might be more than one entry for one page and you have to find out at your own which belongs to the given user and which doesn't). So, as you see, the given data should be reviewed per hand.

Script:  
http://toolserver.org/~hoo/dbq/dbq-181.sh  
Result:  
http://toolserver.org/~hoo/dbq/dbq-181.txt (plain text)
Comment 2 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:09:35 UTC
-------------------------------------------------------------------------------
From: Nathan Marshall <nathanmarshall@hotmail.com.au>
Date: Fri, 13 Apr 2012 20:43:21
-------------------------------------------------------------------------------

Go for it
Comment 3 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:09:37 UTC
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: hoo@online.de
CC list: hoo@online.de

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links