User talk:Kotepho/Archive 04/header
Zzz
Deleted pages reports
How did you create these reports (Template talk:Deletedpage#How temporary is this?) ? Could you tell me how to create them and/or create them again? —Centrx→talk • 21:03, 30 July 2006 (UTC)
- From database dumps (the 7-02-06 set, see also m:Database dumps), various queries, some awk/perl/sed, etc. I'll grab the 7-17 dumps and rerun it if you want, but it will take several hours to download everything, source it, etc though; or I'll make a page with all of the queries and scripts if you want. Kotepho 21:16, 30 July 2006 (UTC)
- Rough draft at User:Kotepho/reports/queries,_scripts,_and_scratch, most of them are pretty straight forward. Kotepho 00:37, 31 July 2006 (UTC)
Updated from the 8-10-2006 dumps. Kotepho 02:56, 16 August 2006 (UTC)
Admin reports
I like your admin actions reports. I have a question that may have an obvious answer... Is there a way to link a user's name to the user numbers listed on your reports? (I know my own because it is shown in my preferences). NoSeptember 21:44, 30 July 2006 (UTC)
- I can look up anyone's you want, and interiot[correction: User:TDS, http://tools.wikimedia.de/~tim/mapping/] had a tool (that since 404s, at least last I checked, maybe I'll drop him a message) that could be done to do it. The `user` table is not included in dumps (it has your password and stuff, so thats good), and that is the only table that it is easy to do userid <-> username matching from (bad =(). Currently I grep stub-meta-history (as a tab delimited file generated from the xml dump) for any userid I want, but I haven't bothered to make a script to generate a list or ask someone with toolserver access to dump a list. Kotepho 21:55, 30 July 2006 (UTC)
- With only approximately 1000 admins, if there was a way to get a list of admins linked to user ID, I would find that quite useful. If it strikes your fancy to get such a list generated at some point that would be great. (Honestly, I don't understand half of what you wrote above ;). NoSeptember 22:03, 30 July 2006 (UTC)
- Haha, sorry for the jargon. I made a list of all users that had an edit that hasn't been deleted as of 7-02-06, so that should work. It is 4 megs compressed though. Put it in the database and I'm re-running a few of the reports now. Some things may be a little wonky still though... there are 15 user id's that ended up with the user name of 0 though and there are two of The Epopt, TMC, Tarquin, TUF-KAT, Conversion script (blame a vandal for that one!), and Dysprosia. Kotepho 23:28, 30 July 2006 (UTC)
- Bummer, some of the userids that I ended up with as 0 are admins and/or have multiple usernames listed in edit histories associated with that userid. That is just annoying. Why would I ever assume that a user id or username would be unique, it would only you know.. make sense.. and the schema lists them are primary and unique keys... Other than a few usernames being 0, or duplicated User:Kotepho/reports/admin/month/block is updated with names. Guess I'll trawl through history some more to figure out the rest manually. Kotepho 04:21, 31 July 2006 (UTC)
- All should be updated. Still a few issues with names though, 4 people I cannot identify and the duplicates (probably due to renames done by hand, such as TMC.. who used to be named after a large barnyard animal). The total of all time(really, old as the logging table.. I'm not going to bother finding all of the old logs spread around and parsing their disparate formats for what little information is there) is off by 1210, apparently some admin(s) no longer has any edits or something =(
- On a semi-related issue, I think I should say that basing any decisions on these numbers (hi WT:RFA!) is intellectually bankrupt in my mind, but you can go with it if you want. Funny curiousity and pretty graphs are cool though. Kotepho 23:02, 31 July 2006 (UTC)
- Thanks for all the work. now I will start playing with it :). NoSeptember 20:41, 1 August 2006 (UTC)
Thanks!
Thanks for fixing my bad template on The Colbert Report! Servers aren't being very responsive for me right now. –RHolton≡– 03:47, 1 August 2006 (UTC)
- Me neither... I didn't get a new message banner even. I think this means the Colbert Report and Wikipedia tied. No vandalism, but you can't edit at all. Kotepho 03:49, 1 August 2006 (UTC)
TfD nomination of Template:Betterfact
Template:Betterfact has been nominated for deletion. You are invited to comment on the discussion at the template's entry on the Templates for Deletion page. Thank you. dryguy 21:33, 16 August 2006 (UTC)