Last modified: 2008-02-08 00:35:11 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 T3699, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 1699 - Special page to list deleted contributions of a user
Special page to list deleted contributions of a user
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
unspecified
All All
: Normal enhancement with 17 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 1713 2639 8017 8686 9914 10122 10251 10492 10525 (view as bug list)
Depends on:
Blocks: 10464
  Show dependency treegraph
 
Reported: 2005-03-15 15:03 UTC by Piotr Matuszewski
Modified: 2008-02-08 00:35 UTC (History)
11 users (show)

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


Attachments
A specialpage extension for Sysops (13.90 KB, text/plain)
2006-11-16 16:01 UTC, Aaron Schulz
Details

Description Piotr Matuszewski 2005-03-15 15:03:10 UTC
To decide if some user or IP should be blocked one should know the previous
behaviour. As the deleted articles do not show in user's contribution list, it
is difficult to see if that person is a persistent vandal or just learns what
they can do. Many vandals tend to create articles that get deleted soon. If
there was an option to list contributions to deleted articles it would make
things easier.
Comment 1 Goplat 2005-03-26 18:34:39 UTC
*** Bug 1713 has been marked as a duplicate of this bug. ***
Comment 2 Zigger 2005-08-06 12:50:47 UTC
*** Bug 2639 has been marked as a duplicate of this bug. ***
Comment 3 Zigger 2005-08-06 12:54:53 UTC
Bug 1713 and bug 2639 requested that only sysops be able to see the deletions.

Bug 881 requested that deletions also be shown in watchlists.
Comment 4 Brion Vibber 2006-03-13 02:06:57 UTC
Removed bogus dependency.

This bug is dependent on reworking the page deletion system to be based off of revision 
deletion flags.
Comment 5 Melancholie 2006-03-13 02:17:55 UTC
But when a non-sysop or an IP wants to have a look on the 
previous, deleted edits of a suspicious user (Special:
Contributions/...) the bug 5237 has to be resolved before, or am I 
wrong? Unless you want to restrict this bug to sysops, the 
dependency wasn't "bogus", I would say.
Comment 6 Brion Vibber 2006-03-13 02:20:48 UTC
No, these are separate issues.
Comment 7 Aaron Schulz 2006-11-16 15:58:55 UTC
I wrote a DeletedContribs viewer here:
http://www.mediawiki.org/wiki/DeletedContributions

However, two things must be pointed out:
*This requires the relavent SQL query for indexing. I don't know how expensive
that is.
*The current archiver (Article.php) skips rev_deleted, so "apply these
restrictions to Sysops" is lost when the page is archived, so it just shows as
normal here. This extension does check for ar_deleted, but it is not stored at
mw_hidden currently
Comment 8 Aaron Schulz 2006-11-16 16:01:13 UTC
Created attachment 2714 [details]
A specialpage extension for Sysops
Comment 9 Ilmari Karonen 2006-11-28 03:40:51 UTC
I just independently wrote and committed a special page for browsing deleted
contributions (r17968).  At a quick glance, it seems to be fairly similar the
VoA's patch.  (Great minds think alike... :-)
Comment 10 Rob Church 2006-11-28 09:56:27 UTC
With appropriate indexes on the archive table, perhaps we could evaluate the
performance cost of a UNION (which would allow us to integrate the lists in some
wonderful form) against separate pages...

...then again, separate pages do offer a nice, simple, end-user friendly way of
separating the information.
Comment 11 Rob Church 2007-01-18 10:31:22 UTC
*** Bug 8686 has been marked as a duplicate of this bug. ***
Comment 12 Aaron Schulz 2007-05-14 21:54:36 UTC
*** Bug 8017 has been marked as a duplicate of this bug. ***
Comment 13 Aaron Schulz 2007-05-14 21:54:42 UTC
*** Bug 9914 has been marked as a duplicate of this bug. ***
Comment 14 Ilmari Karonen 2007-05-14 22:04:01 UTC
My implementation of Special:DeletedContributions, together with a
QueryPage-based rewrite of Special:Contributions and a branched-out
Special:NewbieContributions is at
[http://svn.wikimedia.org/viewvc/mediawiki/branches/vyznev/].

The reason it's not in the trunk is that the QueryPage-based paging turned out
to be too inefficient, and I lack the familiarity with MySQL needed to optimize
it properly.  Losing the inheritance from QueryPage would also necessarily move
all sorts of ugly low-level detail back into the Special:Contributions code,
unless perhaps some kind of a more efficient replacement was written for
QueryPage first.

If you think you can do something with it, feel free to pick it up from where I
dropped it.
Comment 15 Aaron Schulz 2007-05-14 22:10:53 UTC
Using cu_changes to get recent deleted edits (3 months old) is the only viable
solution.

cuc_this_oldid not having a corresponding rev_id when joined on revision should
signify a deleted edit. These could be listed (timestamp links do undelete could
be used perhaps).
Comment 16 Guy Chapman 2007-05-14 22:20:40 UTC
Not to let the best be the enemy of the good, simply returning a list of the
deleted articles to which the user contributed at some point would be a huge
step forward, it certainly does not need to be integrated with contribution
history to be seriously useful.
Comment 17 Titoxd 2007-05-14 22:35:54 UTC
(In reply to comment #16)
> Not to let the best be the enemy of the good, simply returning a list of the
> deleted articles to which the user contributed at some point would be a huge
> step forward, it certainly does not need to be integrated with contribution
> history to be seriously useful.

Actually, that would be essentially the same query.

What is needed is an index that associates ar_user_text and perhaps
ar_timestamp, or if we are going to go for pages as well, ar_user_text and
ar_namespace/ar_title.
Comment 18 Aryeh Gregor (not reading bugmail, please e-mail directly) 2007-06-03 19:33:21 UTC
*** Bug 10122 has been marked as a duplicate of this bug. ***
Comment 19 Aaron Schulz 2007-06-14 02:45:38 UTC
*** Bug 10251 has been marked as a duplicate of this bug. ***
Comment 20 slakr 2007-06-22 04:03:48 UTC
Wouldn't it just be easier to look on the bright side of things and instead of listing deleted contribs, list all page creates?  That way we can add it to `logging` without worrying about all this index nonsense and just let all page creations be logged outright, so that when deleted page creations are listed, they're simply shown as redlinks.
Comment 21 Mets501 2007-06-22 04:13:48 UTC
What if a page is created, deleted, and then created by another user.
Who gets credit for the "create"?
Comment 22 Guy Chapman 2007-06-22 15:48:05 UTC
I don't think create-only will work.  If an account is tag-teaming with socks, or making large numbers of biased edits to a stub which then gets deleted as a result, it won't show up.
Comment 23 Aaron Schulz 2007-06-23 14:48:53 UTC
Committed to SVN as "DeletedContributions" in /extensions.
Comment 24 Aaron Schulz 2007-06-23 18:01:18 UTC
See r23295.
Comment 25 lɛʁi לערי ריינהארט 2008-01-06 00:12:33 UTC
*** Bug 10492 has been marked as a duplicate of this bug. ***
Comment 26 lɛʁi לערי ריינהארט 2008-01-06 00:12:51 UTC
*** Bug 10525 has been marked as a duplicate of this bug. ***

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


Navigation
Links