[Wikitech-l] question about user_group dump

2010-05-22 Thread zh509
Hi, everyone,

Thanks for reading. 

I am a sociological research. I have used the dump of Wikipedia English 
enwiki-20100312-user_groups.sql for my research. I am confused by 
'accountcreator' 'founder' and 'confirmed' meaning, would you please to 
introduce?

As I know, users of wikipedia can change their status by becoming helper, 
admin or joining other groups. Since when, the user groups like this data 
showed, the date this date collected? How I am supposed to do if I want the 
data showing the change of user status?

Thanks very much for help!

Zeyi


___
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l


Re: [Wikitech-l] question about user_group dump

2010-05-22 Thread Chad
On Sat, May 22, 2010 at 4:22 PM,   wrote:
> Hi, everyone,
>
> Thanks for reading.
>
> I am a sociological research. I have used the dump of Wikipedia English
> enwiki-20100312-user_groups.sql for my research. I am confused by
> 'accountcreator' 'founder' and 'confirmed' meaning, would you please to
> introduce?
>

"Confirmed" users are ones that have been granted the autoconfirmed
right explicitly.

"Accountcreator" was a special group greated for enwiki that bypasses
the account creation limits so they can help other people make accounts
for themselves.

"Founder" is a special right created for Jimmy Wales as founder of
Wikipedia. The rights have been historically been similar (recently
changed though) to that of a Steward.

> As I know, users of wikipedia can change their status by becoming helper,
> admin or joining other groups. Since when, the user groups like this data
> showed, the date this date collected? How I am supposed to do if I want the
> data showing the change of user status?
>

You'd need to check the data from the logging table to see when
user rights were changed on individual users.

-Chad

___
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l


Re: [Wikitech-l] question about user_group dump

2010-05-22 Thread Platonides
>> As I know, users of wikipedia can change their status by becoming helper,
>> admin or joining other groups. Since when, the user groups like this data
>> showed, the date this date collected? How I am supposed to do if I want the
>> data showing the change of user status?
>>
> 
> You'd need to check the data from the logging table to see when
> user rights were changed on individual users.
> 
> -Chad

Also note that some information will be inside meta logs table, and
really old sysopping actions won't be recorded at all.


___
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l