On 10/06/12 19:38, Gregor Martynus wrote:
Thanks Petr!
Besides the XML dumps, are there also direct SQL dumps available?
No. The dumps are in XML precisely to avoid publishing db-specific schemas in SQL files... and filtering the output in the process. I could make you a sql dump, but it'd be preferable if we fixed the XML dumps.
It looks like indeed there are some things missing, e.g. namespaces. It also seems that wikipedia has information not only about the performer, but also about the target. I don't see such a thing in the XML dump … am I missing something?
It may be a bug in the log creation code.
Another question regarding the log actions. I made a list of all actions grouped by types: https://gist.github.com/2906718
I wonder if there is a page describing the meanings of the actions? I searched for such a help page, but couldn't find anything useful yet. If there is no such thing yet, I'd love to contribute it, I'd just need a hint how and where to do it, as I'm not familiar with wikipedia myself, I'm just helping out a friend making her dissertation
I don't think so, you'd need to browse the code. Although they have quite explanatory names.
I'll try to provide some info for them:
abusefilter modify
Modify an abusefilter entry. Made by Abusefilter extension.
block block unblock reblock
User blocking actions. Self-explanatory :)
delete delete
Delete a page.
event
Hide a log entry.
restore
Restore one or more revisions
revision
Hide a revision
gblblock whitelist
Probably provided by GlobalBlocking extension. I don't think this should appear on this wiki. I thought GlobalBlocking was only managed at metawiki.
import interwiki upload
Usage of Special:Import. Importing from a different wiki, or by uploading a file.
move move move_redir
Move a page to a new title or move overwriting a redirect in the new title.
newusers autocreate
The account was automatically created because the user was logged in at another wiki.
create
The user registered an account.
create2
Someone (log_user_text) created an account for somewhere else.
newusers
Seems like log action used by old entries. Seems last used in 2006.
patrol patrol
To patrol a revision.
protect modify move_prot protect unprotect
renameuser renameuser
Renameuser extension, rename a user account.
review approve approve-a approve-i approve-ia unapprove
Provided by Flaggedrevs extension.
rights autopromote rights
Changes to the user groups.
stable config reset
Provided by Flaggedrevs extension.
upload overwrite upload
Upload a new file, or upload a new version of a file.