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.