On Saturday 21 September 2002 03:31 am, you wrote:
I've restored the UseMod-era (through January 2002) edit histories to the database. (With a few caveats, notes and exceptions; please see http://www.wikipedia.org/wiki/Wikipedia%3AUsemod_article_histories%C2%A0)
The earliest edit retained in the database is [[UuU]] by an anonymous user at eiffel.demon.co.uk from 8:08 pm PST on January 16, 2001: http://www.wikipedia.org/w/wiki.phtml?title=UuU&oldid=291430
-- brion vibber (brion @ pobox.com)
Coolness - many thanks!
Now if Andre can rerun the user edit stats again then maybe we can get a better breakdown of stats. Hopefully at least Larry is close to my count -- if he isn't, then I must accept the fact that I really don't have a life outside of Wikiland. But then there still is the issue of UseMod deleting old histories, so we may never have an accurate tally.
-- Daniel Mayer (aka mav)
Now if Andre can rerun the user edit stats again then maybe we can get a better breakdown of stats. Hopefully at least Larry is close to my count -- if he isn't, then I must accept the fact that I really don't have a life outside of Wikiland. But then there still is the issue of UseMod deleting old histories, so we may never have an accurate tally.
I didn't need to do that, Brion already did it for me. And, no, Larry is not coming close to you. In fact, he somehow managed to keep himself down to number 200 on the list. You got 1000 extra edits behind your name, and it seems that AxelBoldt is the only one who has significantly more than that (moving him up from #4 to #2 on the list).
Wondering how it's possible that Larry scores so low, my first guess is that the software considers his old edits as being anonymous. Either no user can be connected to those edits, or 'LMS' is not recognized by the software as being a user. It's not just Larry either - Jimbo only appears at #155 and again at #196.
Andre
Andre Engels wrote:
Wondering how it's possible that Larry scores so low, my first guess is that the software considers his old edits as being anonymous. Either no user can be connected to those edits, or 'LMS' is not recognized by the software as being a user. It's not just Larry either - Jimbo only appears at #155 and again at #196.
Yeah, I forgot to take that into account. Login names that don't have an exactly same named equivalent on the new system got imported marked as anonymous (internal user id number = 0). I've redone the query to include anonymous edits (we have some very active non-logged in users as well!) However it still doesn't amalgamate multiple accounts for the same person.
Larry_Sanger is at #31 with 2155 edits.
Also keep in mind that many early edits were automatically deleted by the usemod software, so a lot of pre-Fall 2001 stuff is still going to be underrepresented.
For the curious, the queries were: SELECT count(*),cur_user_text FROM cur GROUP BY cur_user_text SELECT count(*),old_user_text FROM old GROUP BY old_user_text
I then dropped them through a little perl script to add them, sort them and spit out a table. Probably could be done more efficiently, but meh.
-- brion vibber (brion @ pobox.com)
wikipedia-l@lists.wikimedia.org