User talk:Kotepho

From Wikipedia, the free encyclopedia

Archives: 01 02 03
/reports
bot

Contents 1 Zzz 2 Deleted pages reports 3 Admin reports 4 Thanks! 5 TfD nomination of Template:Betterfact 6 My Bot 7 {{botlinks|BOTepho}} 8 BOTepho's bot flag 9 Deleted pages 10 TawkerBotTorA

[edit] Zzz

Oh dear

[edit] 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)

Making a page with the queries would be good so anyone can do it without starting from scratch. —Centrx→talk • 23:42, 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] My Bot

Sorry that was a glitch it has been fixed thank you for identifing it. if I can co anything for you just drop me a line. Betacommand 03:39, 27 August 2006 (UTC)

[edit] {{botlinks|BOTepho}}

As a Member of Wikipedia:Bots/Approvals group I am just letting you know that we are awaitng a responce about your trial run. Betacommand ^{(talk • contribs • Bot)} 06:18, 11 September 2006 (UTC)

eh? What more do you want? Kotepho 15:26, 11 September 2006 (UTC)

just some diffs and a summery of the trial run. Betacommand ^{(talk • contribs • Bot)} 15:39, 11 September 2006 (UTC)

Like this? Do I need to go into more detail, or what? Kotepho 15:45, 11 September 2006 (UTC)

[edit] BOTepho's bot flag

Hi. Per Betacommand's final approval [1], I've granted a bot flag to your bot account, BOTepho. Cheers, Redux 20:00, 11 September 2006 (UTC)

[edit] Deleted pages

Hi there! We've been working on removing old protected/deleted pages. Your list has been very helpful for that, so thanks. Could you please regenerate it some time in the near future? >Radiant< 13:50, 22 September 2006 (UTC)

Done. Kotepho 20:10, 22 September 2006 (UTC)

[edit] TawkerBotTorA

Howdy! In the Tor bot RfA, your oppose seems to suggest that you're under the mistaken impression that the user running the bot is not an admin. You may wish to update your text appropriately and change the oppose reason. - CHAIRBOY (☎) 16:51, 9 October 2006 (UTC)

I am not ignorant of that fact. Kotepho 16:57, 9 October 2006 (UTC)

You wrote:

until someone with a clue that is also an admin steps up to run and maintain it

.

The above quote indicates that are aware that he's an admin, you are instead calling him clueless. If that is a mistake, you may wish to update your text appropriately, otherwise it becomes a civility issue. There are plenty of good reasons to oppose the RfA, please pick another one instead. - CHAIRBOY (☎) 17:14, 9 October 2006 (UTC)