https://bugzilla.wikimedia.org/show_bug.cgi?id=16378


David <[EMAIL PROTECTED]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[EMAIL PROTECTED]
             Status|RESOLVED                    |REOPENED
         Resolution|WONTFIX                     |




--- Comment #3 from David <[EMAIL PROTECTED]>  2008-11-18 17:26:05 UTC ---
Thank you for the comments, I appreciate the explanation.

I'll reopen this bug (just this once), to request it be marked for future
development, because I would find this functionality useful on Wikipedia and
also on my installation of MediaWiki.

I've used a query like this to find out who is the creator of a given page, but
that won't be of much use to find all pages started by a given user:

SELECT p.page_id AS page_id, MIN(r.rev_id) AS first_revision_id, r.rev_user as
user_id
FROM page AS p 
LEFT JOIN revision AS r ON(p.page_id = r.rev_page)
WHERE p.page_title = 'Title'

How about storing the user id of the person who made the first revision of each
page right in the page table? page_first_user or so?  What would the downsides
of doing something like that be?

Thanks.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to