User talk:Interiot/archive2

From Wikipedia, the free encyclopedia


I usually reply here for toolserver issues (eg. issues that other people are likely to be interested in), but I may reply on your page for non-toolserver issues. If I leave a note on your talk page, I'll have it in my watchlist, so feel free to reply there.

I'll generally keep comment history as intact as possible, but I reserve the right to ruthlessly reorganize and sometimes refactor comments, to keep the page organized and keep it from growing too quickly.

Legend: Gray or = issue resolved. = outstanding todo item, = outstanding suggestion. = didn't read the red box.


[edit] Toolserver replication lag

:) Kate fixed the toolserver replication stoppage, it's slowly working its way towards real-time, hopefully it will be much better in ~24 hours. --Interiot 04:24, 16 January 2006 (UTC)

It might be a good idea to place a disclaimer along with a copy of the lag indicator on the Tool output page itself, so we don't have to keep bugging you. Titoxd(?!? - help us) 18:15, 16 January 2006 (UTC)

[edit] Analysis of Wikipedia growth (cont)

Thank you for your doing the query. I'll get on to it as soon as I can (the new semester just started). Regarding the accuracy: Yes, I expected a bit of inaccuracy at the very beginning, since the history of articles wasn't tracked properly at that time. Another source of errors is that a deleted article's history also is deleted, so no trace of it remains. Still, I do not think this will matter much. It would be nice if this matched the official article count, but that isn't very important, since any predictions will be inaccurate anyway. Amaurea 08:37, 16 January 2006 (UTC)

Well, I finally got around to doing this, and the result is at the bottom of my user page. I've made it possible to automatically update, but I'm sure it would need much more development before being good enough for the relevant page here. Comments are welcome. Amaurea 17:44, 9 February 2006 (UTC)
An example of output is here. Amaurea 18:28, 9 February 2006 (UTC)
The tool actually produces a logarithmic version too, but it isn't that informative, since the first part takes up so much room, dwarfing the rest of the graph. But it's here if you want to see it. Much more informative than the log scale image is the annual growth rate in % (light blue). Exponential growth means taht that is constant, and while there is a lot of noise, it seems to be quite constant after it calms down. Amaurea 18:28, 9 February 2006 (UTC)
Yes, the logarithmic plot could be fixed by cutting off the lower part, but that is a bit hacky, in my opinion, and the script would require regular updating to determine where to cut off unless the growth continues to behave nicely. It probably will, though. The reason I do not like the log version, though, is that it makes it impossible to see which functions fit the data best. Only the % yearly growth makes it clear that the polynomial function doesn't fit. It is very noisy, though. I could use the smooth function to make it nicer, but isn't it nice to present it like it is, too? Or perhaps making that axis logaritmic, too, would help. Amaurea 18:52, 9 February 2006 (UTC)
I've made a new plot using the smooth option in gnuplot. It looks much more well-behaved now, and it shouldn't be too different from just decreasing the resolution (better than that, perhaps?). It is in the same location as the last plot. I have also updated the log plot to not show the very start, and it looks much better now. Amaurea 14:13, 10 February 2006 (UTC)
Do you get the filledcurves option to work at all? I tried your code (the gnuplot part of it, that is, and with another dataset), and it works here. Perhaps something is wrong with your version of gnuplot? Amaurea 18:37, 9 February 2006 (UTC)

[edit] Special:Export

Sure, I'll start working on that. :) The final version of the function getSource(URL) is at User:AySz88/Java Sandbox. --AySz88^-^ 20:54, 16 January 2006 (UTC)

I updated the sandbox with the latest versions of getSource and such. I also started working on the references thing, which is also in the sandbox (but incomplete, so it crashes), and I know it works with de and ko. It produces an array of "Namespace" objects, and I might add ".addCount" methods of some kind directly into that class. --AySz88^-^ 05:26, 17 January 2006 (UTC)
Oh, and I'd better take back what I said about "final" too! :p :p --AySz88^-^ 05:27, 17 January 2006 (UTC)

Got to 1.0 of the Namespace parser - it ultimately returns a HashMap of namespaces and associates each foriegn namespace with the English name. I'm expecting the tool will want to iterate through the HashMap instead of checking each string individually. --AySz88^-^ 09:18, 20 January 2006 (UTC)

Oh, I just realized I forgot the main article space (which I assume is what index number 0 is). I'll make sure to somehow include the article namespace tomorrow. I think we'll need some way of keeping track of and incrementing a count of edits within the namespace object, so I'll try to add that too. --AySz88^-^ 05:58, 21 January 2006 (UTC)
Okay, I think I've got it to a fairly good condition, if you wish you can take a look at it and tell me what you think! :) User:AySz88/Java Sandbox#Namespace class and factory for maps and arrays. Now the contribution parser just needs to grab the HashMap from the static method Namespace.getFullMap("en"); and increment the Namespace that has a key that matches the namespace. --AySz88^-^ 23:10, 21 January 2006 (UTC)

[edit] Re: Thanks

No problem! (And my congratulations beforehand.) Your RfA page is on my watchlist, so whenever I see someone vote, I update the tally. It's not that big of a deal; I've seen candidates update their own tallies before, but I woudn't worry about it if I were you. Some users will update the tally eventually, and quite frankly, it's not that big of a deal. Thanks! Flcelloguy (A note?) 02:39, 18 January 2006 (UTC)

[edit] Your Edit Counting Tool

Hi there Interiot! I don't think we've interacted before, but I have a small question. What is your edit counter tool's relationship to the old Kate's Tool? Is it the same thing, spruced up, or something else which has replaced it altogether? I was just curious because on RfA, it seems like "Interiot's tool" is the new toy to help investigate potential admins. Good luck on your own RfA, by the way! Cheers, Bratschetalk | Esperanza 04:19, 18 January 2006 (UTC)

As far as I know, Kate's Tool is still being maintained, it's not going away. Mine is one alternative, and there are other's alternatives as well. I think the Wiki way is to have redundancies, not relying on any single person or thing to allow the system to break down. That said, I do hope to improve mine further at some point, and based on popularity, it might be one of the de-facto tools, who knows. --Interiot 04:27, 18 January 2006 (UTC)

[edit] Grayer areas?

Sure, I've added a question to that extent, per the several proposals in Wikispace to create such a layer. The poll doesn't propose more layers that are less spread apart; the poll doesn't propose anything. However, if community says that we should have such layers, I'd be happy to propose them and/or work out the details. Radiant_>|< 12:47, 18 January 2006 (UTC)

[edit] Counter

I'm not completely sure how you operate the ArbCom counter, but RomaC has withdrawn from the race. Cheers, Ingoolemo talk 17:37, 19 January 2006 (UTC)

I have the candidate-list and the withdrawn-list hard-coded for the time being. I've updated the widthdrawn list to match the official list now. Thanks for letting me know. --Interiot 17:59, 19 January 2006 (UTC)

[edit] Adminship

Seeing that you're going to enter the ranks of the cabal any time now, I salute you with this flamethrower (+25). Congratulations! You've reached mop-wielding ignomy! :D Titoxd(?!? - help us) 18:27, 19 January 2006 (UTC)
Seeing that you're going to enter the ranks of the cabal any time now, I salute you with this flamethrower (+25). Congratulations! You've reached mop-wielding ignomy! :D Titoxd(?!? - help us) 18:27, 19 January 2006 (UTC)

[edit] Admin accountability poll

I was bold and grouped your comments about an intermediate layer of user powers with mine under a new option [1], describing the difference between 'tools' and 'powers'. If you object to this, please move it back to where you had it. Thanks! -- nae'blis (talk) 19:53, 19 January 2006 (UTC)

That's a great way to organize it, actually. Thanks.  :) --Interiot 20:05, 19 January 2006 (UTC)

[edit] Contribution Tree walker

I love your tree walker. I asked user:Lupin to add it to the dev version of the popup menu gadgetry, which he graciously did. However, it may not handle weird user names well when invoked that way. Consider this URL: http://tools.wikimedia.de/~interiot/cgi-bin/contribution_tree?dbname=enwiki_p&user=Can't%20sleep,%20clown%20will%20eat%20me (this is for User:Can't sleep, clown will eat me) If you try to walk down one of the namespaces, it seems to choke on the single quote... is that because the single quote should have been urlencoded already when first invoked?

PS, I will watch here, you can answer here (I need to make a template for that!)... Oh, and congrats on your impending ascension! ++Lar: t/c 00:51, 21 January 2006 (UTC)

Ick, I was handling URLs too sloppily, I guess. That case is now fixed, but I bet the same bug will appear again in some of my older code. And thanks :). --Interiot 05:46, 21 January 2006 (UTC)

[edit] Congratulations

Hi, Interiot/archive2, Congratulations on Becoming a Sysop

Hey there. Congratulations, you've just been made a sysop! You've volunteered to do housekeeping duties that normal users sadly cannot participate in. Sysops can't do a lot of stuff: They can't delete pages just like that (except junk like "LALALALAL*&*@#@THIS_SUXX0RZ"), and they can't protect pages in an edit war they are involved in. But they can delete random junk, ban anonymous vandals, delete pages listed on Votes for deletion (provided there's a consensus) for more than one week, protect pages when asked to, and keep the few protected pages that exist on Wikipedia up to date.

Almost anything you can do can be undone, but please take a look at The Administrators' how-to guide and the Administrators' reading list before you get started (although you should have read that during your candidacy ;). Take a look before experimenting with your powers. Also, please add Administrators' noticeboard to your watchlist, as there are always discussions/requests for admins there. If you have any questions drop me a message at My talk page. Have fun!

Ilyanep (Talk) 22:06, 21 January 2006 (UTC)


Congratulations Interiot! --a.n.o.n.y.m t 22:19, 21 January 2006 (UTC)

:) Thanks to all who took the time to consider my RFA and vote. I'll do my best to use the mop carefully and in service to the encyclopedia. --Interiot 22:30, 21 January 2006 (UTC)
Congrats from me as well! Enjoy your shiny new buttons, and if you ever have a question, don't hesistate to ask me. Thanks! Flcelloguy (A note?) 22:38, 21 January 2006 (UTC)
Congratulations! :) --AySz88^-^ 22:47, 21 January 2006 (UTC)

Some editcount-cruft regarding those who voted:

  • 51 were admins (46% of the total votes)
  • the average edit count of the voters was 6763
  • the median edit count of the voters was 3970
  • the median date of the voters' first edit is April 16, 2005
  • 7 voters probably wouldn't have had suffrage if the recent arbcom suffrage rules were used for RFA
  • if the proposed 100 edits / 1 month suffrage requirements were used, all users would have had suffrage

[2] --Interiot 01:14, 22 January 2006 (UTC)

Congrats on sysopification! (looks like I'm one of those 7. =S) — TheKMantalk 02:30, 22 January 2006 (UTC)
Congrats! I know you'll use the mop wisely! --M@thwiz2020 20:39, 22 January 2006 (UTC)
Congratulations on your new role.--Dakota ~ ε 05:14, 30 January 2006 (UTC)

[edit] Request for db dump query

Hi Interiot! We haven't interacted much, but I read somewhere in your userpages that you can run queries on the database dump upon request. I was wondering if you could produce a list of articles that have not been categorized yet. I'm in no hurry so you can take your time if you choose to run this query. I'll be watching this space. Many thanks! -- Rune Welsh | ταλκ 15:37, 19 January 2006 (UTC)

Would Special:Uncategorizedpages work? (or the manually updated Category:Category needed) --Interiot 16:14, 19 January 2006 (UTC)
I was hoping for a plain text list I could search in my hard drive. Is there a way to parse the special page into a text file? -- Rune Welsh | ταλκ 16:39, 19 January 2006 (UTC)
Just happened to be reading this page, and just wanted to mention that both of the two options mentioned above are radically incomplete - i.e. they show only 10% or less of the total list; that's why a toolserver version that could be parsed offline would be so great. I'd really like that too; I may see if I can bug another toolserver account holder... JesseW, the juggling janitor 06:35, 22 January 2006 (UTC)
Well, there's two of you interested now, as long as one of you would actually use the data, I can generate it, no problem. I just need to understand the aim of it... I don't quite understand the problem with Special:Uncategorizedpages. In particular, can I use the SQL query from Special:Uncategorizedpages? It would be super-easy to generate then (though won't it be a very long list?) --Interiot 06:43, 22 January 2006 (UTC)
The greatest gripe I have with Special:Uncategorizedpages is that it is a pain to navigate, specially over slow connections. Then one cannot do searches on it, as far as I'm aware, which is useful when one actually knows what he's looking for (Latin American articles in my case). I wouldn't mind a huge download once as long as I have the data on my hard drive. Thank you for your time! Cheers. -- Rune Welsh | ταλκ 15:29, 22 January 2006 (UTC)

The report can be found here. Let me know if there's anything else you need (particularly if it comes from a Special: page, apparently those are really easy to run). --Interiot 08:50, 23 January 2006 (UTC)

Thank you very much! -- Rune Welsh | ταλκ 17:19, 23 January 2006 (UTC)

[edit] Your edit counter

image:wiki-thanks.png Hi Interiot, thank you for creating your edit counter, which is very useful. I have a request: would it be possible to have a color denoting article edits alone, rather than mixing them with category, template, and image edits? It would be useful to see at a glance how much people are contributing to the main namespace in relation to other edits. SlimVirgin (talk) 14:00, 22 January 2006 (UTC)

Sure, I've put a version that does this here. Before it goes live, would it be possible for you to look at multiple accounts with it, and see if the new information answers the questions you were hoping it would? I think the reason I left this off originally was that most users, even experienced ones, don't rack up the kinds of edits on img/cat/tmpl/portals that they do on main articles, because there's no stub sorting, there's less vandalism on those, etc. But that's all subjective, so let me know what you think. Also, an alternative I've been pondering is adding overlib tooltips to each bar, and each tooltip would list the exact numbers for each namespace. Eg:
January 2005
Mainspace: 1024 (42%)    Talk: 240 (10%)        Template: 3 (1%)   Template talk: 0 (0%)
Category: 10 (1%)        Category talk: 1 (1%)  ...
...
If that would fulfill your original need, then I can instead go ahead and implement that sooner. Let me know what you think... --Interiot 18:33, 22 January 2006 (UTC)
Thanks, Interiot. The new version is great. I also like the overlip tooltips, which gives a percentage. I don't know which I'd say would be best. The percentage is very useful, but the different colors give an immediate visual sense of where the user's priorities lie. I think if I had to choose, I'd take the colored chart, but would it be possible to have both? SlimVirgin (talk) 01:02, 23 January 2006 (UTC)
Assuming it's not a horrible nuisance, of course. SlimVirgin (talk) 01:02, 23 January 2006 (UTC)
I'm definitely doing the popups, since they're out of the way and are something users can ignore if they want to. Regarding the chart though... do you think that adding a new color to separate off articles would be more informative than other alternatives like adding new color bars to separate the mainspace from Talk:, or breaking "Project" out into separate "Wikipedia:", "Portal:", and "MediaWiki:" colors? There are 18 different namespaces, and I have to pick and choose carefully, especially because I think it takes new users some time to grok how even just the four colors correspond to editors' priorities. I want to make feature requests easy and painless, but any sort of "I think this feature would be the most beneficial because ..." explanation that you might be able to articulate more would be very helpful. --Interiot 01:49, 23 January 2006 (UTC)
For me, I like to be able to see at a glance the extent to which users are actually contributing to the encyclopedia, and for the purposes of adminship, I like to be able to see what percentage of their posts are to article talk, so I can judge whether they interact with other editors, or whether they just make their edits and move on. Those are the most important issues for me, so I'd like anything that gives me the actual percentage, or that separates those namespaces using different colors. I'd also like to see the encyclopedia edits stand out in a bright or distinctive color. This is just a wishlist, you understand. ;-) Hope it helps. SlimVirgin (talk) 02:05, 23 January 2006 (UTC)
Right. Is the concern that categories, images, and templates may be more indicative of userboxing? If so, if I moved all those over into the "Project" group, would that be satisfactory? Again, I think cats/imgs/tmplts are almost always a pretty small percentage of one's edits. But I could make a fifth color grouping.
About the colors, yeah, I spent some amount of time trying to pick a combination. I'll try to find a brighter one, I guess. As an aside, do you know anyone who's colorblind, who can confirm that my next color combination is legible to everyone? --Interiot 02:13, 23 January 2006 (UTC)
I liked the way you had it when I last looked: where the images/cats/templates were together, and the project separate. Project edits can be to policy pages, which is more substantial editing than, say, to cats, but perhaps I'm showing my own prejudices here. ;-D I don't know any color-blind Wikipedians, but I bet there's a userbox for them. ;-) SlimVirgin (talk) 02:16, 23 January 2006 (UTC)
No colorblind category, which surprises me, though I did find Category:Wikipedians who have no spleen, and of course Category:Wikipedians with tiny penises (only two entries; I wonder if they realize). SlimVirgin (talk) 02:20, 23 January 2006 (UTC)
LOLOLOL. Hilarious. :) --Interiot 02:24, 23 January 2006 (UTC)

I changed the color scheme on the counter to lighten it up a bit. If anybody has better suggestions, or if anybody can confirm whether this is suitable for users with colorblindness of one type or another, I'd appreciate it. For what it's worth, I'm pulling my color schemes from ColorBrewer and ColorSchemer. Compare the original to the new. --Interiot 03:32, 23 January 2006 (UTC)

If I may chip in as a color-blind person, I must say the "new" color scheme works wonders. Good stuff. -- Rune Welsh | ταλκ 03:55, 23 January 2006 (UTC)

[edit] Editcount link script

Hi

Under WP:KATE or something like that there is a script for creating a static link to Kate's edit counter in the user options in the top-right hand corner of the Monobook script.

I have the modded the script slightly to point to yours, you might want to take a look at it, borrow it, steal it, make any comments or moderations you want, or whatever. It's at User:Haza-w/Interiot code. haz (user talk) 10:52, 23 January 2006 (UTC)

[edit] Stupid Question

Hi Interiot,

This is something I've always wondered, but felt was too stupid to ask. You're so nice, though, and well-qualified to answer, that I'm finally just going for it: Why are the best user-created tools, including yours, resident at the .de (German) server? Best wishes, Xoloz the idiot 18:17, 23 January 2006 (UTC)

Actually, the best tools (where best = fastest, most mature/polished/bugfree, highest uptime) are those located at Special:Specialpages. If best is defined as (less people care about downtime, lots of bugs can exist, queries can be inefficient and the DB can lag like crazy, but new ideas are rapidly prototyped), then the toolserver might be considered the best. The reason it's at .de is, as the m:toolserver page says, Sun Microsystems donated the hardware for the toolserver to Wikimedia Deutschland, so the hardware is owned by them. The toolserver obviously has access to most language's data though. --Interiot 18:36, 23 January 2006 (UTC)

[edit] Oh, great uncatagorized list maker!

The list of uncatagorized pages is very useful! I just used it to catagorize about 60 rivers! I downloaded the list, hacked up a quick script to pull out the items with the word "River" in them, and formatted the result in wiki-form(see this user page of mine); going through it, I found 60 rivers I could easily catagorize, and I did! 60 down, only 66,000+ to go! Wheee! We should really annouce this great tool of yours more widely; also, if you want to hack on it to display a clickable, filtered(either strict text or regexp) list, that would be even cooler. Yay, yay, yay - we can actually do catagorizing in a sane way now! JesseW, the juggling janitor 08:25, 24 January 2006 (UTC)

Glad it worked out for you. :) Ultimately though, sometimes you get lucky and queries can help a lot, but they don't usually identify 90+% of the pages (especially without being able to grep through the wikitext itself, which, unfortunately is not available on the toolserver for the time being). So the tools can't always be used by a wide range of people. But if anybody is willing to do mostly mindless edits all day long, I've got thousands of little edits that need to be done. Anyway, let me know if there are other queries I can run for you... --Interiot 10:29, 24 January 2006 (UTC)
What do you mean "they don't usually identify 90+% of the pages"? Is the uncat'ed list larger than 66,000? Regarding semi-mindless edits, contact User:Bluemoose, and the guy writing Humanbot - they have semi-automated tools for this sort of thing... I will keep you in mind if I need further queries, though... JesseW, the juggling janitor 05:37, 25 January 2006 (UTC)
I mean... there's always human variation in how things are done. You can grep for "River", but not all rivers have "River" in the name (Danube, Rio Grande). You can look for all articles under Category:Album stubs that link to an article with the word "punk" in it (internal links are listed in the database, and are pretty easy to search), and stick those in Category:Punk rock album stubs, that only fetches probably 5% of the articles [3]. (though, in that case, 5% is still helpful). Some searches work better, some worse. One more thing: if you know a little SQL, you can run queries on your own at http://www.wikisign.org/, on ~2 month old version of the database. Cheers. --Interiot 14:35, 25 January 2006 (UTC)

[edit] RFA Thanks

Please accept my embarrassingly belated thank you for supporting my RfA, which much to my surprise passed 102/1/1, earning me minor notoriety. I am grateful for all the supportive comments, and have already started doing the things people wanted me to be able to do. And hopefully nothing else... Just zis  Guy, you know? [T]/[C] AfD? 12:49, 24 January 2006 (UTC)

[edit] Edit counter majigger

Got a question for you. How feasible would it be for you to add a "Sysop: True/false" output line to your edit counter? Every so often, I see a user who I think would make a great admin, and I check their edit count to see how feasible a RfA would be, and so it would be really nice to add that kind of line to it. As it stands, I have to go find the list of admins, then hunt for their name...not as easy. Just a suggestion. Great work on it, by the way; I like the little graph at the bottom. Take care. —BorgHunter ubx (talk) 00:02, 28 January 2006 (UTC)

Easy, it's done. The "user group" line will show up just as with Special:Listusers (eg. one of boardvote, bot, bureaucrat, checkuser, developer, or sysop). --Interiot 05:49, 28 January 2006 (UTC)
Awesome! Thank you. —BorgHunter ubx (talk) 16:17, 28 January 2006 (UTC)
Can I suggest for non-admin's instead of a "-" mark which made me wonder what the heck is a user group was, maybe something else? — Moe ε 16:37, 28 January 2006 (UTC)
Suggestions? Lackey? Peon? Proletarian? :) Member? User? Or I could do like Special:Listusers does, and remove the "User group" line if a user don't have any assigned. --Interiot 16:49, 28 January 2006 (UTC)
User sounds approriate, unless you want to break it to Registered User and Anonymous User xaosflux Talk/CVU 16:58, 28 January 2006 (UTC)
I'd be in favor of removing the line entirely in the interests of simplicity. —BorgHunter ubx (talk) 17:10, 28 January 2006 (UTC)
Much better with User! But do you have any control over over it saying unknown namespace 100 and unknown namespace 101? It might be better to add Portal and Portal talk. Sorry, but I thought it would make it better. :-D — Moe ε 17:20, 28 January 2006 (UTC)
I vote for "user" too, because Special:Listusers's way always seemed like the lazy way to go, and IMHO it isn't clear to first-time users either. Regarding namespace-100 and 101... yeah, there are technical complications why it's that way, and why I haven't already fixed it. It should be fixed soon though. --Interiot 17:32, 28 January 2006 (UTC)
How about you use this dirty trick, making one call to Special:Export daily, and caching the result? That would be a temporary fix... Titoxd(?!? - help us) 19:31, 28 January 2006 (UTC)
Since I wrote that document, that's exactly what I'm going to do. :) The part that will take a bit of time is that the edit counter is somewhat old code, and I have to upmerge it to use my latest utility library where the namespace code is at. At the same time I'm going to add popups to the monthly bars that use the same namespace names (and lists monthly namespace total/percentage), and will also link the edit counter's top namespace list over to the contribution tree. Add the three editcounter features at once. But higher priority than that is the code for the Wikipedia:Proposed deletion test run since that's starting soon. --Interiot 19:56, 28 January 2006 (UTC)
Done, "unknown namespace" fixed, and contribution tree linked. Also, I added a (browse) link for image uploads, since that was pretty easy. --Interiot 23:16, 28 January 2006 (UTC)
Nice! :D But now you're going to have to add a CSS to your contribution tree utility, so it matches the editcounter. ;). By the way, could you feasibly remove the _p at the end of the database name without impacting the tool? It is a minor nuisance, like the two parallel lines on Trinitron monitors.
Also, I was wondering if Kate would let you host a JAR file on the tool server. We're working on Flcelloguy's Tool, and the major bug that was bugging us is close to being fixed, so we may soon release a new version. However, the thing that people always complain about is about them having to compile it themselves... Titoxd(?!? - help us) 23:41, 28 January 2006 (UTC)
Okay, popups should be working for Opera and Firefox folks everyone. MSIE renders it pretty poorly though. --Interiot 06:17, 29 January 2006 (UTC)

[edit] Java edit counter

(\r). The bug is fixed, and Lar is willing to host the file for us, which I'll ask about when we release v4.0. I'm not sure if you have a copy of the tool in your local machine, but if you do, would you mind having a look at it and tell us what you think? Titoxd(?!? - help us) 02:10, 29 January 2006 (UTC)

[edit] Edit Counter..agian

*sigh* Sorry to interupt you again but can I make another suggestion? I saw you just added the pop-ups for each month pulling up stats for edits. Can I suggest instead of pop-ups, make it a link on the month?

Example:
Instead of the pop-up stats, it would read:
2006/01 (which would link to the monthly stats).

This way you can see a clear visual of the contributions, by month, and this could probably help with the contribution tree. — Moe ε 07:15, 29 January 2006 (UTC)

[edit] Re:Edit Counter

There is no specific problem in viewing the pop-ups but it might be beneficial to make it a link, like my suggestion above, since other programs have problems with viewing it. It also looks a little sloppy to have a pop-up. Sorry if you didn't clearly understand my previous message. I'll try to give a better example.

Example using my edit count : My suggestion is no pop-up and make a link instead. So instead of viewing the pop-up you would see this:


2005/07 2658
2005/08 1881
2005/09 751
2005/10 479
2005/11 1837
2005/12 1531
2006/01 2481


Maybe you could make the red links go to your contribution tree? I hope this example is better. — Moe ε 15:19, 29 January 2006 (UTC)

It should be a link already. The popups look sloppy in MSIE, but look gorgeous in Opera and pretty good in Firefox. --Interiot 18:34, 29 January 2006 (UTC)
I use MSIE, but now for some reason it looks better. I think is was my computer. Thanks — Moe ε 20:17, 29 January 2006 (UTC)

[edit] Edit counter problem w/ ö

The counter dosnt work for my name anymore. The same thing happened a while ago whit kate to. /Grön 11:16, 29 January 2006 (UTC)

Fixed. --Interiot 18:34, 29 January 2006 (UTC)

[edit] Yet another suggestion

Hiya, Have you considered adding a time-based (either as in "time of day", "day of the week" and/or "time of year") histogram to the Editcount? Best regards, --Tournesol 11:31, 29 January 2006 (UTC)

Ha, that's a bit brilliant! No, I hadn't thought of that. I'm not sure time of year would be that useful yet, as even the old timers have only five years of editing, and I doubt there's a strong pattern there anyway (or if there is one, it's not hard to pick out by eye from the current graph). But time of day, that's actually something that the database will spit out quite easily. :) My only worry is that some people might consider it a privacy issue? I don't know.       It will take some time to code, but I can run preliminary data, and my own daily-histogram is very interesting to me, so I'll probably code this up. --Interiot 18:34, 29 January 2006 (UTC)
A tiny comment on the time of day graph: could you force the vertical axis to always go down to zero? For example, Angela's graph only goes down to 100. This is a cute feature, but the way :-) Lupin|talk|popups 20:46, 29 January 2006 (UTC)
Good idea. Also, if anybody has any comments on the privacy issue, let me know. I don't think it's a huge deal, but especially for people with very consistent sleeping patterns, it does tend to give a good idea of where they're located in the world, and whether they tend to edit at the beginning of their day, or the end of their day. While this is data that you might figure out about people you tend to run into a lot on-wiki, it's not something that has necessarily been easy to see about random strangers before. --Interiot 20:55, 29 January 2006 (UTC)
Realy great feture, I like it a lot, your counter is just geting better every day. And as by the privcy issue, this is data that anyone can harvest and analyse themself, so it's realy not ypur foult, anyone can do it /Grön 20:57, 29 January 2006 (UTC)
Ultimately though, it doesn't do anything to improve the encyclopedia per-se (other than perhaps let others draw random conclusions about how much one might edit in the middle of the night, or how much they might be a globe-trotter, or possibly whether they tend to edit a lot at work or not, and possibly even when they arrive at work. (and makes previously seemingly insignficant details such as whether one goes to univeristy or not, and what city one lives near, much more important facts than they were, and are things that people may want to keep hidden more). For instance, my graph clearly shows that I get in to work at 10:30am CST (since I disclose on my user page that I live near Chicago), and that my lowest point of editing is at 6am, and I have a spike in editing at 3am. I'm not sure these sorts of things help us build an encyclopedia... --Interiot 22:44, 29 January 2006 (UTC)
I think they're useful—It's helpful to know, for example, that User:Filiocht never edits on the weekend, so that I know when to expect a response from him if I leave a note on his talk page. It also might help people figure out when dedicated vandal-fighters are likely to be around, so that they can plug the gaps. And by the way, that list of uncategorized pages is awesome. --Spangineer (háblame) 05:38, 30 January 2006 (UTC)

[edit] Pop-up and problem on some characters

Hi Interiot, your editcount is really very useful. I want to report you a minor bug. For example in this in edits by namespace part Şablon or Kullanıcı can be seen correctly but on popup window, they are not ok. It must be about charsets.--Ugur Basak 12:37, 29 January 2006 (UTC)

It's a known problem that I'm trying to solve. For some reason, in one setting I get Grön's bug, but if I fix it, then I get your bug. I'll have it fixed soon though. --Interiot 18:34, 29 January 2006 (UTC)
Okay, it should be fixed now. By the way, is "(main)" appropriate? There's no translation for the mainspace, of course, since it's a blank string. So most likely it has to be English? If so, is there a simpler word that would be better? --Interiot 22:22, 29 January 2006 (UTC)
Interiot, you are doing really great job. I've checked it and see it's fixed, also you add a new feature, graph. In Turkish Wikipedia, we use the (ana) for (main). Whenever you want to change it you can change it to (ana). Thanks--Ugur Basak 22:44, 29 January 2006 (UTC)
The issue is that I don't want to go to the trouble of translating it into all 216 languages (the other namespaces are already translated, and available via automatic means), so I wanted to pick something that would work for most people without having to do language-specific changes. Which probably means something in Basic English, unless some other creative solution can be arrived at. --Interiot 22:53, 29 January 2006 (UTC)
So (main) can be the most proper word for it. Most of the peoples, who use your tool, are active on en:wiki. --Ugur Basak 22:57, 29 January 2006 (UTC)
Well, the other people should use it too, of course. :) --Interiot 05:47, 30 January 2006 (UTC)

[edit] Your tool rocks

Just throwing out that your tool is awesome. Thanks for making it! Matt Yeager (Talk?) 22:26, 29 January 2006 (UTC)

Thanks.  :) --Interiot 22:44, 29 January 2006 (UTC)

I just wanted to toss my thanks along also! I love the improvments you're making to your already awesome tool! If I may ask, what tool are you using to generate the graphs? --lightdarkness 04:23, 30 January 2006 (UTC)

Thanks. I'm using gnuplot, and it's been a little painful. If anyone has experience using the filledcurves option to fill in the area below the line, and doesn't mind helping out a bit, I'd definitely appreciate it. --Interiot 04:35, 30 January 2006 (UTC)
the new features are blowing my mind!--Alhutch 05:14, 30 January 2006 (UTC)
I don't really have much experience with the filledcurves option, but I just tried it, and it seems to work ok. What is your problem? Amaurea 17:56, 9 February 2006 (UTC)

I love the new graph content. Great job!--ragesoss 05:31, 30 January 2006 (UTC)

Very nice additions. --TantalumTelluride 05:37, 30 January 2006 (UTC)

[edit] PROD

Thanks for creating the toolserver auto-log for the PROD page. I was wondering, is it possible that it remembers past PRODs (that is, keep a log of pages that had a PROD template even if it was removed later). It would be a nice way to keep track of how many pages end up deleted or improved, and it's a possible way to detect a WP:POINTer who goes mass-removing PROD tags. Radiant_>|< 08:23, 30 January 2006 (UTC)

  • Let's see... I think it's okay if the timer resets if the tag is removed and added back (because it implies a dispute). I think it's also okay (statistically speaking) if the CRON runs every 10-15 minutes or so. Of more importance than tracking the "unPRODded" articles is having a list of what is PRODded now. Later on, links to the diffs where it was added/removed are very nice, and so would the edit summary of removal. I think we should start with just the toolserver log; there's one user who really wants an on-wiki log, but he mainly seems to want it for statistics, and the primary goal here is finding out if this actually works in practice. Thanks! Radiant_>|< 15:23, 30 January 2006 (UTC)
    • Looks good. I assume it's sorted by date? Just a few cosmetic suggestions... maybe include a page header ("proposed deletions"); "date last tagged" should perhaps be "time last tagged"; and "prod reason" should be "reason for deletion". And you need to either not display the "cat sort key" column, or add a line at the top explaining what that means because people will be confused otherwise. Oh and I have a feeling the font will turn out to be too large, but we'll see. Radiant_>|< 16:18, 30 January 2006 (UTC)
      • What is the meaning of the Category Sort Key? it's not speaking to me, it seems randomly derived from something... (maybe make the col heads clickable to let people see what the cols mean?) Also I added one junk test of my own, I want to see what happens when it goes away... (you can reply here, I watch, as is my practice, threads I start) ++Lar: t/c 16:25, 31 January 2006 (UTC)
        • I've removed it. It was part of my attempt to reduce PROD's dependence on the toolserver, since the toolserver is a single machine, and thus has noticably less uptime than wikipedia with its redundant array of servers. But that hasn't happened, and so it's not useful at this point. --Interiot 17:05, 31 January 2006 (UTC)

[edit] Tool

A great tool. One note - I'm not sure if you realise but on Kate's a list of possible usernames is shown as you type in a new username - a feature yours is lacking. Just wodered if you knew or not. Good luck! Ian13|talk 17:16, 30 January 2006 (UTC)

  • Yeah, Kate's is fully Web 2.0 compliant, mine is not. :) It might be something I implement eventually, especially because I can copy the existing code. Is it something others use frequently? --Interiot 17:22, 30 January 2006 (UTC)
    • Well, It can be useful (orjust interesting to see similar names) - Shows up WoW accounts quite well too. Ian13|talk 17:41, 30 January 2006 (UTC)

[edit] Privacy issues with the daily/weekly graph

I'm happy to discuss privacy issues with the daily/weekly graphs more. The graphs have gotten very positive responses, so I don't think I'll remove them ever, but there are some users, particularly ones who edit from work, who may have qualms about the graphs. I don't want to discourage anyone from editing, so I can opt-out specific users from the graphs. Please email me, or /msg Interiot on IRC, or otherwise if you'd like me to opt you out of it. Or if anyone has general thoughts on privacy, feel free to discuss it here... --Interiot 18:50, 30 January 2006 (UTC)

[edit] feature requests

Hey Interiot, I thought of a couple things that you might want to consider adding to your already great edit counter. In the popups, would it be possible to add the edits/page ratio by month? It'd help give an idea of what the person was working on during that month—stub sorting, sending an article through FAC, etc. For people like me who constantly change tasks, it'd be a nice addition. Also, I doubt this is possible mostly because it hasn't been done yet, but is there any way to count minor edits? --Spangineer (háblame) 21:50, 30 January 2006 (UTC)

  • Yeah, edits/day would be good. As far as minor edits, probably not in the immediate future. All signs point to that data being really slow retrieve from the database (there's no index on that or on the edit summary), though if I figure out a way around that, I'll definitely put that up. --Interiot 15:18, 31 January 2006 (UTC)
    • Sorry, I meant edits/page—the edits/day ratio is pretty easy to calculate, and not very useful, since all of the months have about the same number of days. I figure that it could count all distinct pages edited during that specific month, even if some of those pages had been edited previously, and then divide the total edit count by that number. --Spangineer (háblame) 20:53, 31 January 2006 (UTC)
      • I probably can't discount pages that were ever edited anytime in the past, I don't think the database will give me that. But the database will readily tell me the number of distinct pages edited in one particular month (ignoring edits in other months). Which is still helpful, because people who tend to edit a page 15 times without using preview, do tend to do that more or less in one month's time. And I'll add this at some point. --Interiot 20:58, 31 January 2006 (UTC)
        • Exactly what I was referring to; sorry for the confusion. --Spangineer (háblame) 22:02, 31 January 2006 (UTC)

[edit] Another tool

Hi. We're currently trying to get the bootcamp up and running, and I was wondering if it would be possible for Wikimedia to host a web-based IRC client for us. I noticed you have toolserver access, so I figured you might be good to ask. The client is PJIRC, modified to autoconnect and autojoin freenode and #wikipedia-bootcamp, with no possibility to join other channels or servers. All the IRC commands have been deactivated, with the exception of /msg, /me and /nick. It's written in Java, is released under the GPL license, and a working copy can be found at my site here. The idea is basically to have a button or a link someplace on the WP:BC page, and if nescesary also on some other pages, to enable new users to get help on IRC without having to download and install their own client, and also without having to know any commands. Thanks in advance. Bjelleklang - talk 00:33, 31 January 2006 (UTC)

Hi again. Thought about requesting an account for myself, but some of the other users involved on WP:BC told me it would be easier to ask an existing user. Will try to get my own account there, as there's been some talk about expanding the system and offer other languages to use it as well, and if so, we're going to need additional configs for the client. Thanks for the help! Bjelleklang - talk 15:26, 31 January 2006 (UTC)

[edit] Editcounter

Nice improvements, keep up the good work. --Cool CatTalk|@ 15:09, 31 January 2006 (UTC)

  • Thanks.  :) --Interiot 15:18, 31 January 2006 (UTC)

[edit] PROD started

I think it's no big deal if people are already placing templates, as long as we don't actually delete anything until five days after the "official" start. Radiant_>|< 15:43, 31 January 2006 (UTC)

[edit] Award

Interiot is awarded this Barnstar for all his brilliant (and too revealing) edit counting tool. Latinus 23:44, 31 January 2006 (UTC)
Interiot is awarded this Barnstar for all his brilliant (and too revealing) edit counting tool. Latinus 23:44, 31 January 2006 (UTC)

That edit counter of yours is brilliant (and reveals a bit too much information). Take a Barnstar! Latinus 23:44, 31 January 2006 (UTC)

Heck yeah. Every week (or day) I think you've added the final excellent feature... but nope. Always more excellent features from Interiot. --Allen 02:51, 2 February 2006 (UTC)
I third that - awesome feature - well in! Deano (Talk) 22:47, 14 February 2006 (UTC)
I fourth that -- your counter is obsessive-compulsive heaven! -- Puffball 09:24, 28 February 2006 (UTC)

[edit] Counter request: Current time on graphs

Hi Interiot. I have an idea for the new graphs you've added to your edit counter--a vertical red line showing the current time or day. This would let users more easily see what the average contribution rate is at the current time. ~MDD4696 00:49, 1 February 2006 (UTC)

  • Brilliant! That should show up now. --Interiot 02:03, 1 February 2006 (UTC)
    • Please add a note someplace on the page telling us what the line is -- I've been confused about it for a while (though not so confused that I bothered to come here and find out what it means until today). Thanks for the great tool! Ewlyahoocom 10:19, 9 March 2006 (UTC)

[edit] Fair use images

Hello.
I've been recently notified that, according to Wikipedia fair use policy, fair use images may not be used outside article namespade, and that I have 35 of them on my userpage. Could you please help me finding which ones of the images I have in that page are fair use, so that I can remove those and only those?
Thanks in advance, --Fibonacci 04:02, 1 February 2006 (UTC)

I switched all of the images to be links, rather than inline. Feel free to revert if you don't like. Hope I helped... JesseW, the juggling janitor 07:34, 1 February 2006 (UTC)
That was precisely what I wanted to do... to the fair use images and not the others. --Fibonacci 07:47, 1 February 2006 (UTC)

[edit] Toolserver request

I was wondering if you could create a toolserver script that would list all duplicate entries from the block, delete and protect logs made in the past week. That is, a list of all pages that were (un)deleted or (un)protected twice or more by the same admin, and of all users that were (un)blocked twice or more by the same admin, within the last week. This should help in putting a break on wheel warring. >Radiant< 11:13, 1 February 2006 (UTC)

[edit] Another request for edit counter

Would be posible known distinct pages edits for namespace?

Something like...

Namespace Edits Disctinct pages
(Main) 3000 1500
Discusión 100 6
Usuario 100 1
Usuario Discusión 500 50
Wikipedia 200 100
Wikipedia Discusión 2 1

Yrithinnd 12:25, 1 February 2006 (UTC) sorry for my english :(

I think it would be an easy thing to do by combining the contribution tree and the edit counter. The names of edited pages are already displayed, and all that needs to be done is count them. We're doing something similar with Flcelloguy's Tool. Titoxd(?!? - help us) 03:11, 2 February 2006 (UTC)
  • Yep, the mechanics are super-easy (SELECT COUNT(DISTINCT page_id) ...). Work issues and WP:PROD code development are taking priority, but I'll add it sooner or later. --Interiot 03:17, 2 February 2006 (UTC)

[edit] Error

Software error:

Unable to connect to database: Host 'login-services.zedler.knams.wikimedia.org' is not allowed to connect to this MySQL server at /home/interiot/public_html/perllib/ZedlerUtils.pm line 43.

For help, please send mail to the webmaster (zedler-admins@wikimedia.org), giving this error message and the time and date of the error.

--Cool CatTalk|@ 22:55, 2 February 2006 (UTC)

Yeah, the toolserver was down for maintenance for a little bit. I thought about posting a notice, but I didn't know how long it would be done for.
Also, there will probably be some downtime this Saturday, I think. There is a new harddrive being installed, which should allow the replication lag to be kept lower than it has been. Apparently the replication lag is caused by a limit in disk I/O, caused by users running queries that use a lot of IO. --Interiot 19:14, 3 February 2006 (UTC)

[edit] request

Is it posible for the editcounter to complare two users. As in how common their editis are. (to primarily find out revert wars/stalking/or sockpuppetary) --Cool CatTalk|@ 22:56, 2 February 2006 (UTC)

It can also compare deleted edits (just statistics) assuming that can be done. (for deleted stalking/revert wars to be presented as evidence when necesary) --Cool CatTalk|@ 22:58, 2 February 2006 (UTC)

[edit] Header of undead list

Hi. I just wanted to let you know that the header of your undead list says: "This lists all articles tagged with a death category but not a birth category." I think it should be the other way around :-)

PS: The edit count tool is great. —Whouk (talk) 13:04, 3 February 2006 (UTC)

Done. --Interiot 16:11, 3 February 2006 (UTC)


Thank you for producing the list. BTW you might want to exclude articles in Category:Year of death missing, Category:Disappeared people, Category:Possibly living people, Category:People lost at sea, Category:Living classical composers. -- User:Docu
Done. (except for the classical composers since, um, Category:Living people isn't supposed to have any subcategories) --Interiot 00:54, 6 February 2006 (UTC)
Great, thanks. I fed it to the bot. The ones missing are likely to be "composers" (I didn't change the settings yet for those), a few entries where I was too tired to get the charset right, pre-1900 entries, and those with Category:Year of birth missing. For the last group a list like Wikipedia:People_by_year/Reports/Canadians/Likely could simplify adding year of death categories , before adding the remaining to Living people. -- User:Docu
BTW entries with a sortkey starting with "*" could be ignored, e.g. Interbellum_generation. -- User:Docu
Would you be so kind and update the list once more? The Category:Year of birth missing entries should be gone by now. -- User:Docu

[edit] editcount and article count

Hiya. Would it be possible to take a look at the code for your edit counter? I've found a MediaWiki feature request that I think might be very useful and easy to implement, but it would require cross-wiki database access (which I don't know how to do). Thanks! GeorgeStepanek\talk 21:11, 3 February 2006 (UTC)

  • :) Warning: it's my oldest code, and has been spaghettified as more features get added:
http://tools.wikimedia.de/~interiot/cgi-bin/count_edits?code
http://tools.wikimedia.de/~interiot/perllib/ZedlerUtils.pm
http://tools.wikimedia.de/~interiot/cgi-bin/queries/user24?code
http://tools.wikimedia.de/~interiot/cgi-bin/queries/user7?code
  • Specifically regarding that bugzilla bug though, are you looking for something like this? That data is part of the wiki metadata. --Interiot 22:10, 3 February 2006 (UTC)
    • Thank you! The code doesn't look too bad: I've seen much worse. (8000 lines of truly awful C++ code... oh the horror, the horror.) The user_groups data looks promising, but it's very out of date, so I think a live query is more along the lines of what Catherine Munro is looking for. GeorgeStepanek\talk

[edit] Response

Thanks for your comments! I really appreciate being, well, appreciated :)

I think that clarifying the pseudo-namespaces would help (I'll read over it, it's probably a good idea) but I doubt you'll get people to delete the "wrong" shortcuts once they exist. But at least discouraging furhter "wrong" ones would be useful.

The wheelwar detector doesn't have to run frequently, daily would be fine. The object isn't really to detect (and stop) wheel wars in progress, but to find out how large the problem actually is and who the problem admins are. I hear far too many complaints about admin abuse to not investigate it (generally those complaints don't even specify which admin they're talking about, and most may well be unfounded; but the atmosphere that "admins are evil" is not good for the 'pedia).

Yours, >Radiant< 00:18, 4 February 2006 (UTC)

  • Yay, we're live! I have two small requests for your toolserver page... first, could you please add a brief summary of how PROD works at the top (so that people know these pages won't be deleted immediately). And second, maybe for lengthy article titles (or comments) it would be possible to use a smaller font than for most comments. Not sure, but I hope that it'd improve legibility so I thought I'd ask. >Radiant< 11:26, 4 February 2006 (UTC)
    • Both toolserver and PROD template get a bit confused if people leave bulleted, multi-line, signed remarks ([[4]], near the bottom). Of course they shouldn't be doing that in the first place. Just FYI. >Radiant< 14:18, 4 February 2006 (UTC)

[edit] Music stubs

You left two stubs not created ((indie)) and ((pop)). The indie can be done without, those fit into rock music and a couple others. On the otherhand the ((pop)) stub template really should be created, as many of these do not make reference to another genre. There are problably 100 or more album stubs that can be placed into the ((pop)) stub. Will you look into this for me? (as I have no clue on how to create any stub templates). Thanks Eagle (talk) (desk) 02:42, 4 February 2006 (UTC)

P.S respond on my talk page or on Category talk:Album stubs. Thanks

Ok. I am going to ring their doorbell. ThanksEagle (talk) (desk) 16:04, 4 February 2006 (UTC)

[edit] WP:PROD trackers

Both the current and live trackers are producing html that looks like <a href="(link)" />(text)</a>, which is invalid html, drives Tidy absolutely nuts, and would probably break on a standards-compliant browser, if such a beast really existed. Also, inspection of User:Crypticbot/Proposed deletion's history reveals the following articles were at one time marked {{prod}} but had their tags removed before you started keeping track of them, and could stand being put into your database by hand:

Time nominated Article Reason for deletion
02/04 03:33 Alternate (talk) dictdef already in Wiktionary in a much better state
02/04 00:30 List of notable Veterans of other conflicts Unmaintainable; potentially huge; "Other" than what?
02/04 00:27 Dark fall: The journal Unreferenced; not notable; more about story than game
02/04 00:05 Abahani no content, and no indication of notability, no sources

Cryptic (talk) 18:37, 4 February 2006 (UTC)

Oh, and it would be keen if, for the main article links, it output html that looked like http://en.wikipedia.org/wiki/Conscious_Media instead of http://en.wikipedia.org/w/index.php?title=Conscious_Media; this matches the html produced by Conscious Media and the category page, so folks' browsers will know the link has been visited and color it appropriately wherever it appears. —Cryptic (talk) 18:42, 4 February 2006 (UTC)

No need to change your utility functions, just filter their output before printing them:

use CGI::Util qw(unescape);
my $fullname_link = unescape(ZedlerUtils::link_to_article($fullname));
unless ($fullname_link =~ /&/)
  {
    $fullname_link =~ s!/index\.php\?title=!iki/!;
    # quotes and question marks break links; all other characters are link-safe or not permitted in article names anyway
    $fullname_link =~ s/'/&#39;/g;    # or s/"/&quot;/g if you start delimiting the link with double-quotes instead
    $fullname_link =~ s/\?/%3F/g;
  }

and stick $fullname_link in your printf instead of the link_to_article call. This doesn't break unicode urls if they're correctly formed in the initial index.php url; display problems are fixed by including a <meta http-equiv="Content-type" content="text/html; charset=utf-8" /> in a <head> section. —Cryptic (talk) 20:10, 4 February 2006 (UTC)

  • On a related note, when clicking on entries on the PROD history tracker, it starts throwing 404 errors. Titoxd(?!? - help us) 20:21, 4 February 2006 (UTC)
    • Yes, tinkering with the guts of my utility functions is never a good idea. :) Nonetheless, I think it should be working now. --Interiot 20:22, 4 February 2006 (UTC)

[edit] Reply

The log is looking good! Sorry, I don't do IRC or IM much, mainly for lack of time. Talkpaging ok with you? For the "exprod" log, maybe for a deletion you could find the deleting user and deletion reason (generally A7, it seems), but that's not really important. I'd like to have it sorted by "current status" though. And maybe for "other" status pages, it would be possible to detect the first template on the page (e.g. "cleanup" or "mergeto") and show that. Just brainstorming actually. Thanks for your help~ >Radiant< 22:55, 4 February 2006 (UTC)

  • I think displaying entries per 50 (or 100) is better than by day. I suppose other people want other sort orders, so you should probably use chronological as a default and by-current-status as an alternative; I'll just bookmark a link to the latter. Good luck, and thanks for the effort! >Radiant< 03:07, 5 February 2006 (UTC)

[edit] Edit count tool for a non-wikimedia wiki?

Is it possible that you could modify your code or explain to me how I would modify it myself (since I don't know Perl) so I can use it on my own wiki? Thanks. --Jediarchives11 02:46, 5 February 2006 (UTC)

[edit] PROD shorthand

So you mean people should just mention WP:NOT, WP:V etc in PROD nominations? I was going more for clear, natural language explanations in the actual nominations. It's been my experience that many people won't click a link to read more, especially not if its a link to a page of longwinded rules and guidelines. A simple, 30-word explanation would help most people... referring them to guidelines would just make them scratch their heads even more. At least that's how I see it. --W.marsh 03:43, 5 February 2006 (UTC)

Still, 30 words isn't long-winded, and while not being particularly helpful to newbies isn't WP:BITEing them, it isn't really an optimal solution either. I say this not because I love newbies, but because I love reducing the common mistakes made by newbies (which in turn increase work for you and me usually). But we'll see how it goes as is... I blanked my comment on the PROD talk page because I didn't want to start a convoluted argument there. --W.marsh 03:51, 5 February 2006 (UTC)

[edit] PROD bug

It is catching a ref to the PROD template, on

02/06 00:44        User:Flcelloguy/Signpost/News and notes 6  (reason not found)

Please fix. Thanks for all your work! JesseW, the juggling janitor 06:19, 6 February 2006 (UTC)

It makes a link to the Wikipedia:Proposed deletion, so it is caught by the Whatlinkshere... I don't know what to do. Perhaps make a new page linking to the period in {{PROD}} (like this.) or something more sophisticated you can cook up. Titoxd(?!? - help us) 06:21, 6 February 2006 (UTC)
The article was in Category:Proposed deletion, and so would have been deleted with or without my tool. I've removed it from the category. --Interiot 06:47, 6 February 2006 (UTC)

[edit] noindex, nofollow

Can you include <meta name="robots" content="noindex,nofollow" /> on the contributions tree thing like the edit counter tool? Thank you. -- WB 02:11, 7 February 2006 (UTC)

Heh [5]. Yeah, I'll do that shortly. --Interiot 02:15, 7 February 2006 (UTC)
Holy crap, that's alot... Perhaps robots.txt will make the job faster. -- WB 04:54, 7 February 2006 (UTC)
Is this going to be done any soon? I hope I'm not pressuring you etc. As far as I know, these outputs are not even full HTML documents (just HTML tables, etc.) Thanks. -- WB 04:14, 20 February 2006 (UTC)

[edit] Diligence rewarded

Image:Barnstar of Diligence.png I award this Barnstar of Diligence to Interiot, for his excellent work on a variety of toolserver scripts. >Radiant< 23:32, 7 February 2006 (UTC)

[edit] cool script

well, thanks you very much for your version of editcount, we're having quite much fun right now :)

Darkoneko 18:51, 8 February 2006 (UTC)

about french unicode issues, I've found no problem so far : éè!& (and some other I don't remember) are looking normal. Darkoneko 05:25, 9 February 2006 (UTC)

[edit] Sabot separation image

Excellent image; great that you found it and thanks for adding it to Sabot Georgewilliamherbert 21:13, 8 February 2006 (UTC)

[edit] Speedy log?

Would you be willing to make a log in the same format as the PROD log, but for Category:Candidates for speedy deletion? What would be nice would be to be able to see all the reasons on one page... Thanks again for all your great work! JesseW, the juggling janitor 10:28, 9 February 2006 (UTC)

It should be applied to a number of things, actually. :) Though I still have to do some work to get prod's history tracker up to snuff. I'm surprised it hasn't happened yet, but if toolserver replication lag were ever tog get very large, or if the toolserver were to go down for 15+ minutes, the history tracker would choose the wrong history for all removals during that time (it's just random guessing based on guessed removal time). It's something I'll hopefully write decent code for soon.
Also, I have an idea for a new project that might be even sexier, and I kind of want to work on that instead. :) It will be sort of a "Wikiproject Watchlist", that lets you see all pages that have changed in the last 24 hours under any subdirectory of, for instance, Category:Automobiles. I have a prototype, but it's very slow (eg. 5+ minute query). I'm hoping that, by caching the list of pages that are being watched, and automatically updating that page list every 24 hours, that I think that will make the "what pages have changed in the last couple minutes" query much faster. Also, I think it should make category-intersection queries like "what automobile articles are currently marked as cleanup" much easier as well. If I can get this to work, I think it would be something of a boon to wikiprojects. Many wikiprojects are doing this for important articles, but this would let them track more minor articles as well. --Interiot 14:46, 9 February 2006 (UTC)
Also, per Radiant!'s departure, perhaps deletion and blocking aren't the safest places to hang out these days, perhaps it's better to stick to working in the mainspace for now. (I've even removed WP:PROD from my watchlist for now) --Interiot 15:21, 9 February 2006 (UTC)

Have you seen Duesentrieb's CatScan? AFAIK, it can do: Changes in the last hour in Category:Automobiles and subcats, Articles in a subcat of both Category:Automobiles and Category:Wikipedia cleanup. If you haven't looked into it, I would strongly advise it... ;-) JesseW, the juggling janitor 04:37, 10 February 2006 (UTC)

Regarding the danger of hanging out in deletion and blocking areas; well, I work on WP:CP, CAT:CSD, and PROD (rather than AfD or 3RR) for that reason. Less emotion in those areas. Wherever you work will benefit from your skill. Thanks. JesseW, the juggling janitor 04:37, 10 February 2006 (UTC)

[edit] Software error

As noted on the PROD talk page, there's a software error showing at the bottom of the history log. —Whouk (talk) 13:42, 10 February 2006 (UTC)

[edit] Minor bug in Contribution Tree

The link from page http://tools.wikimedia.de/~interiot/cgi-bin/contribution_tree?namespace=0&user=Doug%20Bell&dbname=enwiki_p to the article Comparison of Java to C++ does not work. The link http://en.wikipedia.org/w/index.php?title=Comparison_of_Java_to_C++ drops the ++ when resolving to http://en.wikipedia.org/wiki/Comparison_of_Java_to_C instead of keeping it and resolving to http://en.wikipedia.org/wiki/Comparison_of_Java_to_C++

Doug Bell talkcontrib 13:24, 11 February 2006 (UTC)

Interiot: Perhaps handle the + as an HTML entity? Titoxd(?!? - help us) 17:23, 11 February 2006 (UTC)
Yeah, my latest linking code resolves the problem, I just had to make contribution_tree use my latest util-library code. It should be all fixed now. --Interiot 17:53, 11 February 2006 (UTC)

[edit] Request for PROD

Hi, great work on tools! I wish I could anything like that. But I wonder if it would be possible to add one more feature to the prod log: that is a number of people who have clicked on the link to article or on the diff when it was nominated? I believe it would raise some red flags when an article would not have been reviewed by anybody. It was happening quite often on AfD when entries had to be re-listed to get more votes. Thanks! Renata 01:23, 12 February 2006 (UTC)

Brilliant! Sort of a tasks-lite. I'll try to get this implemented ASAP. --Interiot 17:51, 12 February 2006 (UTC)
Good that you like it :) But I also wanted to draw your attention that it can be clicked as "open in new window". And as far as I know it is very hard to track such clicks, no?
Also, I worked for 4 hours yersterday on prod hunting for authors who have removed prod with no sound reason. So I came up with another idea: separate ex-prod'ed articles into deleted and removed otherwise. So now there would be 3 logs: with active prod template, pages deleted via prog (there is not much to do about them anyways), and pages with removed prog template (those might need review). I hope it won't be too hard? (ps. the column "current status" is absolutely brilliant, the most helpful feature of all)
Also, just a question, how/when would someone archive the logs? 'Cause they are getting bigger by the minute. Renata 17:56, 12 February 2006 (UTC)
I'll do something similar to what the google redirect-link-tracking thing does (eg. when you click on a google search result, it first goes to a google-internal script that records the link was clicked on, and then redirects to the final location). It adds latency, but doesn't have other major side-effects, and given its large utility, I think it's definitely worth it. And yeah, I'll start cropping the history results sooner or later. Yeah, Radiant really liked the current status too, and made me promise to make that column sortable at some point. --Interiot 18:02, 12 February 2006 (UTC)
What I can say, good luck and welcome to Wikipedia! :D I don't know if there is a way to say THANK YOU for all you've done here. Renata 18:42, 12 February 2006 (UTC)
Just had to drop a note, please don't crop the logs, just divide them up into pages, for the same reason as we don't any other old logs... But I'm sure that was what you meant. JesseW, the juggling janitor 21:46, 12 February 2006 (UTC)
Well, truncating the display is trivial. But if you insist, I suppose that can be what I meant. --Interiot 21:52, 12 February 2006 (UTC)

[edit] Proposed deletion date format

As a non-American, the American date format (today, 13 Feb, being 2/13, for instance) used on the proposed deletion page is intensely irritating. Could you please change it to use something more international? Probably either ISO 8601 or using textual names (so today would be 2006-2-13 or 13 Feb / Feb 13). Hairy Dude 04:00, 13 February 2006 (UTC)

[edit] Stall image

G'day. I notice you recently added an image to Stall (flight), sourced from NASA. Unfortunately there are some significant errors in the image, so I have removed it from the page and made my concerns known on the talk page there and at Image talk:StallFormation.gif. I'd appreciate your input to see if we can find an alternative, since a image like it (but correct!) would definitely benefit the article. Graham 05:59, 13 February 2006 (UTC)

[edit] PROD

Would you mind checking what's going on at [6] ? It's been stalled since this morning, and is currently 11 hours behind. Thanks, {{User:Vacuum/sig}} 22:06, 13 February 2006 (UTC)

[edit] Important WikiProject Automobiles Discussion

Hello! As a Wikipedia:WikiProject Automobiles member, I just thought you might want to input your opinions on an important discussion we're currently having about whether articles regarding similar vehicles should be merged into one or split by brand. If you would like to comment or read further, please see Wikipedia talk:WikiProject Automobiles#Articles of Similar Vehicles. Thank you in advance for your thoughts and feedback. Airline 23:43, 13 February 2006 (UTC)

[edit] Message from the Kindness Fairy

Hello Interiot. In celebration of Random Acts of Kindness Week, I want to thank you for all the great tools you have created. Us faeries aren't big fans of technology (no love there), but I must say, your tools really are useful and have helped us to better understand each other. Thank you. The Kindness Fairy 05:38, 14 February 2006 (UTC)

[edit] Edit counts strangely not updated.

Hello! I think I have got a problem. After I changed my preference of the look of my nickname (in My preferences) my edit counts were not updated. I made a couple of edits on Wikipedia (english version) and the counts stayed at 2792. I hope you can give me your advise on this situation soon. Thank You. Siva1979Talk to me 12:38, 14 February 2006 (UTC)

Toolserver replication was down, but an admin just fixed it. The replication lag should reduce to zero over the next couple hours. --Interiot 14:06, 14 February 2006 (UTC)
Thank You for enlightening me about the existence of a toolserver. As I am currently a newbie here (about 1 month editing), I am still not aware about some minor details about the function and intricate details of Wikipedia and Wikimedia. I am learning all the time. Thanks! Siva1979Talk to me 14:15, 14 February 2006 (UTC)

[edit] Userbox RSS Feed

Hello. I viewed your userbox rss feed page and think its a really cool thing. Well, I updated my userboxes a couple of days before that and my userbox count was not updated. I just wondered how often its updated. You can let me know at my user page. Thanks:) --Think Fast 01:38, 15 February 2006 (UTC)

Thanks for you speedy response. --Think Fast 02:30, 15 February 2006 (UTC)

[edit] Feature suggestion :)

I'm sure this will tax your coding powers! Include a link to your [7] and/or a one liner about/showing the replicaiton lag (currently 17 hours plus) to help people understand the limitaitons of the toolserver. Rich Farmbrough. 15:48, 16 February 2006 (UTC)

Looks like replication is down.... Rich Farmbrough. 15:57, 16 February 2006 (UTC)
I recently wrote a brief summary of replication lag at m:Toolserver/Introduction, but the page doesn't have many links yet. Yes, replication is down, I'm trying to contact a toolserver admin. --Interiot 16:00, 16 February 2006 (UTC)

[edit] Toolserver Replication lag

Could you possibly find a spot to place the current lag time on your Edit Counter? It's just an extra step to check the PROD counter for current lag :-P If not, no worries. Cheers! --lightdarkness (talk) 22:49, 16 February 2006 (UTC)

Yeah, I should do this. Hrm hrm. --Interiot 22:59, 16 February 2006 (UTC)
Instead of checking prod, I check Interiot's main page (http://tools.wikimedia.de/~interiot/). Speaking of which, why is the lag now about 2 days (really 1 day 22 hours)? Does it have anything to do with the recent server problems? Thanks. --M@thwiz2020 23:12, 17 February 2006 (UTC)
I think so, but I haven't heard much. Anyway, Kate has returned, and has done the necessary magic to get replication working again [8], hopefully it will be back to real-time sometime this weekend. --Interiot 23:14, 17 February 2006 (UTC)
Kate's back? I thought she was on an indefinite wikibreak. Well, the lag still exists, but it's a few hours less than it was prevously. Speaking of the original question, all it would involve would be putting:
<iframe src="cgi-bin/replag?text" width=700 height=40 frameborder=0 style="margin-left:5em; margin-top:-1em"></iframe>
on the edit count page. --M@thwiz2020 01:02, 18 February 2006 (UTC)

[edit] A small problem

I made a small number of edits today and they are not showing up on the edit counter, can you please fix this? The Eye of Timaeus 23:48, 16 February 2006 (UTC)

It's the replication lag on the Toolserver, it should be fixed soon, just a matter of when a toolserver admin can fix the problem. But in case you have to know now, your current edit count is: 748 --lightdarkness (talk) 23:52, 16 February 2006 (UTC)

[edit] please remove the deletion box

If you agree that the revised userbox is OK, as it seems you do at Template talk:User CDP-USA, then would you please remove the deletion box on the main page. Apparently, I as the creator am not allowed to do so. We all must be WikiLegal.
--  IS Guðsþegn – UTCE – 03:11, 17 February 2006 (UTC)

[edit] articles listed as PROD

Hi. Is it possible to get a list of all articles that have been listed for the PROD process? I'm not technically minded, so I don't have a clue at all. It would be useful in analysing the process. Steve block talk 09:26, 17 February 2006 (UTC)

(Sorry for replying to a question on your talk page, Interiot) Er, just use the previous nomination log - AFAIK, it's complete... JesseW, the juggling janitor 09:36, 17 February 2006 (UTC)
Ah. Is there any way of getting that to spit out numbers, namely the number of articles prodded and the number of articles deleted? I lost count at either 400 or 500. Steve block talk 21:24, 19 February 2006 (UTC)

[edit] Toolserver Inquery

Hello again Interiot! I was wondering if you could do me a favor. I've currently proposed a bot to maintain a stat page on Wikipedia, and I was planning on getting the edit counts from the toolserver, more specificly your tool. A user has asked if this would cause any stress on the toolserver, I expressed that there would be no more than 1 hit per hour, but if you could possible post on the WT:B page your opinion on the impact, I'd greatly appreciate it. Thanks. --lightdarkness (talk) 12:09, 17 February 2006 (UTC)

Thanks a lot for commenting there, I really appreciate it. After reading your comments, I was wondering if you could possibly do me a favor. In your spare time, could you possibly make a file on your toolserver account that just spits out a users editcount? Nothing fancy at all, just a script that takes in a variable through the URL, and spits out just their edit count. This way, it would be even less of a stress for me to run this bot, while still reeping the benefits of the counts on the toolserver. --lightdarkness (talk) 21:40, 17 February 2006 (UTC)

[edit] Edit Counter

I was wondering wether there is something wrong with the server. I've gotten used to checking there to see how long a user has been editing here but for 2 or 3 days now my counter (that's what comes up first) is stuck at the same number. Wasn't sure if you were aware of any problem... --Mmounties 16:21, 17 February 2006 (UTC)

Replication is down on the toolserver, it needs to be correct by one of the Toolserver admins and then it should be all peachy, but if you want to know your current edit count, it's 852. --lightdarkness (talk) 16:42, 17 February 2006 (UTC)

[edit] Prod lag

I saw the hit count on the prod log, neat, thank you! But I wonder if you know that Toolserver database replication lag is: 1 day, 20 hours behind real-time! Can something be done? Renata 00:57, 18 February 2006 (UTC)

Toolserver replication was down for a while, but is working now. Hopefully it will be resolved sometime this weekend. --Interiot 01:18, 18 February 2006 (UTC)

[edit] Edit Counter

How much longer is your edit counter not going to be working? Moe ε 01:59, 18 February 2006 (UTC)

Two days. --Interiot 02:00, 18 February 2006 (UTC)

[edit] Scales on when-editing graphs

_ _ First let me say that the edit count tool needs nothing more to make it wonderful. And i keep thinking of not-so-stupid ways to make what it already does even more useful. In particular, i think the graphs of when in the day and when in the week the user tends to edit are helpful with vandals, both in ruling out hypotheses about the context the edits are made in, and in at least suggesting whether a specific block is likely to affect the vandal at all.
_ _ (I wonder whether it might be a more powerful tool against IP vandals with the ability to graph by namespace and/or "degrees of separation" from specific articles that have been related to previous vandalism by the same IP. Conceivably these could be part of establishing sonar-like signatures of vandals and of others sharing an IP, and make surveillance for vandalism more efficient.)
_ _ But i write today with what i hope are some much quicker SMOPs. I've gotten reasonably good at relating UTC times to the present moment, but at the other conversion problems (e.g. inferring what time zones are most consistent with an IP's usage pattern, and determining when in my local time i should apply a block that will be effective) i am clumsy enough to make it attractive to get back to editing and leave the enforcement to colleagues. My intuition is that one feature could significantly reduce my frustration level. Namely, i'd like a client-side control -- i think those triangular controls (triangular for my IE at least, and Java-provided, i think) on Recent changes, for hiding or showing the full series of rapid-fire edits by one editor on one page, must be implemented similarly to what i have in mind. The control i have in mind would have 24 settings, or for simplicity maybe just 12 (representing two time adjacent zones, each pair by the average of their offsets). I would try out hypotheses (edits mostly during day, edits mostly in evening) by setting roughly what i think is the editor's time zone, and -- ta-da! -- auxiliary scales below the two graphs would label them with the editor's corresponding local time. Then, having arrived at a theory of where on the graphs their next vandalism is likely, i switch to my own time zone (and the one next door), and see when i should come back to monitor for trouble, or to set up a "pinpoint blocking raid".
_ _ Having said that, its almost pointless to bother mentioning putting a line of text below the day-of-week table with the names of the days. Not a big deal, but a presumably cheap amenity, even if (in order to assure match up) they have to be on a separate graphic of precisely the same width.
_ _ I will continue to venerate you at my desktop virtual Interiot altar even if your priorities are in entirely different directions, so thanks for the opportunity to maybe play a small role in making it better.
--Jerzyt 04:57, 18 February 2006 (UTC)

[edit] Template:user bush

You just deleted the template that I worked very hard on. Please bring it back, or at least let me have the code so I can just keep it on my page! Please, Im having a really bad day already.Weatherman90 17:20, 18 February 2006 (UTC)\

Thank You!Weatherman90 18:02, 18 February 2006 (UTC)

[edit] Adding contributions

Hello. User:Dschor is placed upon temporary probation and restricted from article construction. Despite this, he has made an sandbox in his talkpage for making contributions upon his return (here). As such, I took the liberty of making them for him, and I was wondering if it possible to add 4 edits to his mainspace edit count beacuse they are rightfully his edits, and I feel he is entitled to it. Please respond on my talkpage. -ZeroTalk 17:15, 19 February 2006 (UTC)

First of all, he already has the edits counted where he made then. More importantly, Dschor is not on probation. He is banned, and currently has no right to edit Wikipedia at all. -Splashtalk 17:18, 19 February 2006 (UTC)
Third, edit counts shouldn't matter that much. Four, many editors have a much bigger skew in their edit counts, since they previously did a lot of editing under a different account, or when not logged in. --Interiot 17:20, 19 February 2006 (UTC)
My aplogies; in the context I utilized "probation", I was speaking of his ban. I've replied on my talkapge. -ZeroTalk 17:35, 19 February 2006 (UTC)

[edit] Edit counter crashing

I'm trying to use jaws for windows, a screen reader, to access your edit counting tool. However, it crashes completely on jaws 5.1 (the version I use) and sometimes crashes in a demo of 7.0 (the latest version. The computer completely freezes, so I can't get any error logs. The only thing I could find that seemed unfamiliar or likely to cause jaws to crash were the on-mouse-over and popup links in the months contribution table. I'm not that familiar with advanced html, but it would be easier if the on-mouse-over links to the user's contributions were replaced with normal links that open in a new window, if possible.

Also, I'd like to see stats on the percentage of minor edits made/the number of new articles created. This would be useful for providing a quick overview of a user's style.

Thanks, Graham/pianoman87 talk 12:54, 20 February 2006 (UTC)

[edit] There might be something wrong with your userbox counter

About a month ago I made a (silly) userbox that I noticed your template counter didn't pick up. It's Template:User Shot in Reno. I was amused, wondering how long the little box would survive in the current climate, but I thought, if this demonstrated a bug in your acquisition of templates, you might want to know about it. Regards, JDoorjam Talk 21:47, 20 February 2006 (UTC)

[edit] Userbox history

For what it's worth, it appears that {{user piano-1}} may be one of the first non-babel and non-directly-wikipedia-related userboxes created on enwiki, by Yummifruitbat on 28 May, 2005, created "to illustrate idea". --Interiot 19:36, 21 February 2006 (UTC)

[edit] question about tools development

Hi, Interiot. I've got a couple ideas for tools. Displaying metrics, really. identifying trending and such. I have an idea of what the sql would look like, but I am not familiar enough with what the schema looks like to actually visualize the data. I'm quite accomplished with web-based tools, and I'd love the opportunity to be able to prototype some of the things I would like to put together. I understand that only administrators have access to SQL. Is it possible I could have read-only access to a slave database to mock up tools? I have seen User:Topbanana's page on making a mirror database, but the downloads are fragmented and difficult to reconstruct into a working, "offline" copy. Alternatively, I suppose I could look at the source for the tool(s) you have, and hack in my own sql. The problem with that is I am primarily a perl programmer. What do you think?

... aa:talk 06:01, 23 February 2006 (UTC)
  • Replied on the other page, but the short of it is: anybody can get a toolserver account, not just admins. Also, all my tools are in perl, and I also have a lot of toolserver-coding info here. --Interiot 16:43, 23 February 2006 (UTC)

[edit] Thanks for your voting!

Thanks!

Hi, thanks for your voting on my RFA. It has finished with the result 88/14/9, and I am promoted. I am really overwhelmed with the amount of support I have got. With some of you we have edited many articles as a team, with some I had bitter arguments in the past, some of you I consider to be living legends of Wikipedia and some nicks I in my ignorance never heard before. I love you all and I am really grateful to you.

If you feel I can help you or Wikipedia as a human, as an editor or with my newly acquired cleaning tools, then just ask and I will be happy to assist. If you will feel that I do not live up to your expectation and renegade on my promises, please contact me. Maybe it was not a malice but just ignorance or a short temper. Thank you very much, once more! abakharev 07:34, 24 February 2006 (UTC)

[edit] Editcounter suggestions/requests

In order to cancel out some of the noise in edit counts I wonder if any of the following suggestions might be implemented:

  1. Do not count an edit if the previous edit to the same page was done by the same user within the last hour (or whatever short time period seems reasonable.) This would reduce the differences between people that use the preview button and people that just save a lot. (Or alternately, just list the count of the edits that meet these criteria and let the user do the math.)
  2. Provide counts for minor and major edits.
  3. Provide a count of edits that are simple reversions of content to a previous version. (Maybe this is not so easy?)
  4. Provide a tool that lists "major" edits by a person. A major edit would be one that a) was not a simple reversions of content to a previous version and b) has a net diff of at least X characters. (Would be a nice tool if X could be specified, but even a fixed X would be nice.) In determining major edits, it would be nice if (1) above was used to combine several consecutive edits into a single "major" edit. This would be most useful with the contribution tree to locate the major edits from a person.

Thoughts? – Doug Bell talkcontrib 08:38, 26 February 2006 (UTC)

Heck, I'd be happy if I could just do the major/minor one.  :) Unfortunately, those suggestions are all slow queries, which basically makes such reports impossible to use for on-demand CGI scripts. Some caching / batch reporting can be done, allowing me to use slower queries, and that's somewhere on my list somewhere. But the complexity of a caching/batch user interface, and complexity of the coding makes it seem somewhat less useful/important.
Also, the wikitext of pages is currently not available on the toolserver, so reports that deal with "x bytes changed" probably won't be possible until the wikitext starts being replicated. --Interiot 08:44, 26 February 2006 (UTC)

[edit] Edit count bot

My script has only made 6 queries per day, I don't think that I'm the cause of the increased traffic :P Also, regarding getting someone to run the query on the toolserver, is it even possible to mass get the edit counts of certain usernames? If not, I'd need everyones edit count above 2,500, and then I'd have to filter out those that don't wish to be on the list. --lightdarkness (talk) 17:02, 26 February 2006 (UTC)

We are updating the list for every user over 2,500 who wants to be on the list. From my understanding, there are many users who don't wish to be included. However, I do have a solution for getting data. Would it be possible for you to generate a list of the edit counts for all users over 2,500, and then I'll take those results and filter them out with a script running on my own box. That way I still just get the data for these users, while benefitting the toolserver. Could that be arranged? --lightdarkness (talk) 17:28, 26 February 2006 (UTC)

[edit] editcounter

The recent inclusion of adminactions :) You are the best, great job /Grön sv 19:26, 27 February 2006 (UTC)

Lovely. As soon as we get things ready to publish Flcelloguy's Tool, we learn that we have to add yet another new feature! Will it ever end? :P Hehe... no, great job. That is actually quite useful, especially seeing some impressive stats like these... by the way, do you mind having a look at the tool (the new code is visible at the Java Sandbox and give us your critique? Titoxd(?!? - help us) 21:21, 27 February 2006 (UTC)
Yeah, Curps was the obvious first one to try, though JesseW was another one that surprised me (apparently they're semi-autoed as well). I haven't been contributing whole lot of admin work lately, I'll have to pick it up again. (Yeah, I'll have to look at your tool sometime, though I'm a bit busy at the moment) --Interiot 21:29, 27 February 2006 (UTC)

Great addition! But oh man, there are so many possibilities from here—maybe a total admin action count right under edit count, perhaps a green line on the graphs to show the distribution of admin actions through the day and week (maybe on a different scales?), and maybe on the bar chart a distinction in the total count: instead of "Month - Total count - Bar", it could be "Month - Edit count/Admin action count - Bar". --Spangineer (háblame) 22:32, 27 February 2006 (UTC)

Aha, this is all part of my evil plan. I get everyone to realize all the useful things the toolserver can do, people's brains start churning, everyone gets a toolserver account, and then I can start start posting {{SoCodeIt}} whenever people ask for new features. :) --Interiot 22:53, 27 February 2006 (UTC)
That'd only work if it was just as easy to write in some weird computer language (Pearl? Java? Is that like the C++ I learned in my sophomore year of college?) as it is to write in English. Even for the average wikipedian, who's more techno-savy than the vast majority of the population (I mean, come on, we figured out what "edit this page" means), we'll always just stand awestruck before the people who can make all sorts of cool little internet gadgets. I think it's a more advanced form of the disease that strikes family members of today's teenagers that causes them to constantly repeat, "My computer's broken. Can you fix it for me?" I guess the only thing to do is get used to it. --Spangineer (háblame) 04:01, 28 February 2006 (UTC)

[edit] PROD Idea

Just an idea, but it was pointed out to me that we should notify the original author about "their" article being proposed. Wondering if it would be possible to make the current PROD system or a PROD bot to auto notify the user? I am unfamilar with bot programming on wikipedia, but if it isn't too hard to pick up (ie if you could point me in the right direction of say a bot howto) I'd try to make something. I am by no means a programmer, but I have wrote hundreds of shell/perl/VDS scripts (VDS is a quick and dirty scripting language for windows). Mike (T C) 22:11, 27 February 2006 (UTC)

I haven't done any bot programming myself yet, though I plan to try to look into Pearle code perhaps sometime. I don't know. Was it agreed that this might be good policy? I'm of the general opinion that it's not. Taken to the extreme, one can assume that the person who created the page implicitely thinks it shouldn't be deleted, and so no article should be deleted via prod, ever. --Interiot 22:21, 27 February 2006 (UTC)
IT wasen't agreed that it is policy, I just seems to get slammed a lot for not doing it, so I figured instead of having people go through the list one by one and doing it I'd suggest it to you instead. Mike (T C) 01:09, 3 March 2006 (UTC)

[edit] Your edit counter

Doesn't seem to be updating the edit count ILovePlankton 16:50, 28 February 2006 (UTC)

It's caused by toolserver database replication lag, the problem should resolve itself automatically over time. --Interiot 17:44, 28 February 2006 (UTC)
Ok thank you ILovePlankton 17:48, 28 February 2006 (UTC)
Any idea why the replication lag is 3 hours behind? --Optichan 20:46, 28 February 2006 (UTC)
Please see User:Interiot/ReplagFAQ. A toolserver user was running a long query overnight, but now Wikipedia is generally slow, and that's making the replication lag worse. --Interiot 22:02, 28 February 2006 (UTC)

[edit] Article creation

I often see a request of people who want to see which articles they've created because they haven't been tracking their activity and if you forget, it's pretty hard to retrace. Could you write some sort of tool that extracts first edits from an article's history to alow creation counts and easy lists of created pages? Please post a quick note on my talk if you reply here. - Mgm|(talk) 18:12, 28 February 2006 (UTC)

It's a very slow query, so I can't make it publically accessible (if very many people hit it, even accidentally, it would cause the toolserver's replication lag to grow). However, I can run it on request. Please see here for your results. The "namespace" number comes from here, with 0 being the article mainspace. (cc'd to your talk) --Interiot 18:36, 28 February 2006 (UTC)
  • Thanks. Can I refer people asking this on the help disk to you? - Mgm|(talk) 22:57, 28 February 2006 (UTC)
    • Sure. Are there a lot of these kind of queries? At some point I'll need to set up a system where anyone can request longer queries to be run overnight... if there are a lot of these kind of queries, I can implement this sooner rather than later. --Interiot 23:09, 28 February 2006 (UTC)

[edit] Saint

Thou art now a saint!
Thou art now a saint!

I hereby decree you are now Saint Interiot of the Awesome, Amazing, Kick@$$ Edit Counter, now that you put the admin actions in; you've opened up a can of worms though, since now everytime I think of something new, I'll be running over here to suggest it! :-D Essjay TalkContact 07:18, 1 March 2006 (UTC)

/me gets in line to venerate at the chapel of Saint Interiot... ;-) JesseW, the juggling janitor 07:25, 1 March 2006 (UTC)

[edit] Average edits/day

It looks like the average edits/day is low. It should just be the simple calculation (total edits)/(number of days from first edit until now). I've made almost 150 edits in a month and it says that my average edits/day is 1.62, when it should be almost 5. --Gandalf 07:32, 1 March 2006 (UTC)

[edit] Young Orphans / Images

…is brilliant! Would it be possible to include "talk" and "contributions" links next to the user name? Cheers for another excellent tool! —Phil | Talk 09:53, 1 March 2006 (UTC)

[edit] RfA thanks

Thank you for voting on my RfA, it passed with a final tally of 68/0/0 so I'm now an administrator. If there's anything I can do to help, you feel I've done something wrong, or there's just something you want to tell, don't hesitate to use my talk page. Thanks. - Bobet 10:32, 1 March 2006 (UTC)

[edit] Magmatron

OK, Interiot, please tell me, what are the criteria for deleting an obviously unworthy character - I simply don't know. Crzrussian 15:45, 1 March 2006 (UTC)

Thx, very helpful. Crzrussian 16:03, 1 March 2006 (UTC)
Gone! Crzrussian 19:36, 1 March 2006 (UTC)

[edit] Yet another idea...

Dunno if this is the sort of thing that your tools could conceivably handle, but I'd quite like a "which edit first/last contains a given text string" tool. OTOH an update to the new admin-actions, to show just admin-actions broken down into blocks, protects, etc would be useless but fun :-) William M. Connolley 21:25, 1 March 2006 (UTC).

Yeah, hopefully I can implement the first one at some point, that's something I hate doing manually. It probably won't happen for a while though, because the wikitext of pages isn't available on the toolserver currently. For the second one (admin action graph)... I generally clump things together in the monthly bar-graph, I mean, there's really a lot of things it could be broken out into, and there are only so many colors. And the admin-actions are broken out in the popup. I don't know, maybe there's another way to display the data, I don't know. --Interiot 21:51, 1 March 2006 (UTC)
It would really have to be a separate graph, drawn only for admins. I think it would be fun, but it might have disadvantages, with people trying to keep up their ban-count or something :-) William M. Connolley 17:17, 2 March 2006 (UTC)

[edit] Sha. Zaam.

Barnstars?  Phah!  You Rock!
Barnstars? Phah! You Rock!

Each time I check out your edit counter, I say to myself, "Jeff, there is no dag gurn way that this here edit counting contrapulation ken git any better <spit><ptang!>." But then I fire up my old crank-powered computerizer, and what do my eyes behold? A better counter. It's a work of art. A thing of beauty. You've heard this a billion times about your tools, no doubt, but keep up the awesome work. --Jeffrey O. Gustafson - Shazaam! - <*> 10:01, 2 March 2006 (UTC)

*grin* Well, for what it's worth, most recent ideas have come from other users, so... keep 'em coming I guess. --Interiot 16:39, 2 March 2006 (UTC)

[edit] Edit counter Avg edits/day not accurate

The Avg edits/day should be calculated from the day of the first edit to the current day. It seem to use the last day of the current month to determine the number of days. – Doug Bell talkcontrib 15:46, 2 March 2006 (UTC)

Okay okay, it's fixed. It was actually total_edits / (num_months * 30.42), but yes, I can see how this can skew newer users quite a bit. --Interiot 16:39, 2 March 2006 (UTC)

[edit] Suggestion

Would it be possible to have deleted edits on the color-coded bar graph? Cool, if possible. --ZsinjTalk 20:44, 2 March 2006 (UTC)

Where'd you get so many deletes? [9] I suppose it might be possible. Would they have to be in a different color, or could they use the existing colors (eg. image edits could show up as yellow, even if deleted) --Interiot 20:59, 2 March 2006 (UTC)

[edit] Mindspillage

Alright! I have an associate in my Mindspillage vandalism! HAHAHAHAHAHA </crazed vandal> :-) Essjay TalkContact 01:59, 3 March 2006 (UTC)

[edit] Edit counter tool info as requested



=== code samples of both original Kate's tool and my modded version that works perfectly with yours ===

//Kate's tool link script

  //  Add a "Kate" link to your monobook "personal menu" list at the very
   //  top of the page.
   //
   //  Indicate where you would like "Kate" to appear:
   //    pt-userpage, pt-mytalk, pt-preferences,
   //    pt-watchlist, pt-mycontris, pt-logout
   //
 gsKateInsertBefore = 'pt-logout'; // leave blank to append after "logout"
   //
 function KateLink()
 {
   var user = document.getElementById( 'pt-userpage').firstChild.firstChild.data;
 
   var li = document.createElement( 'li' );
     li.id = 'pt-kate';
 
     var a = document.createElement( 'a' );
       a.appendChild( document.createTextNode( 'Kate' ) ); // eh, the css makes the text lowercase
       a.href = 'http://tools.wikimedia.de/~kate/cgi-bin/count_edits?dbname=enwiki&user=' + user;
 
     li.appendChild( a );
 
   if ( ! gsKateInsertBefore ) // append to end (right) of list
   {  document.getElementById( 'pt-logout' ).parentNode.appendChild( li );
   }
   else
   {  var before = document.getElementById( gsKateInsertBefore )
       before.parentNode.appendChild( li, before );
   }
 }
    if ( window.addEventListener ) window.addEventListener( 'load', KateLink, false );
 else if ( window.attachEvent      ) window.attachEvent   ( 'onload', KateLink );





//Interiot's tool link script

  //  Add a "Interiot" link to your monobook "personal menu" list at the very
   //  top of the page.
   //
   //  Indicate where you would like "Interiot" to appear:
   //    pt-userpage, pt-mytalk, pt-preferences,
   //    pt-watchlist, pt-mycontris, pt-logout
   //
 gsInteriotInsertBefore = 'pt-logout'; // leave blank to append after "logout"
   //
 function InteriotLink()
 {
   var user = document.getElementById( 'pt-userpage').firstChild.firstChild.data;
 
   var li = document.createElement( 'li' );
     li.id = 'pt-interiot';
 
     var a = document.createElement( 'a' );
       a.appendChild( document.createTextNode( 'Interiot' ) ); // eh, the css makes the text lowercase
       a.href = 'http://tools.wikimedia.de/~interiot/cgi-bin/count_edits?user=Pegasus1138&dbname=enwiki_p';
 
     li.appendChild( a );
 
   if ( ! gsInteriotInsertBefore ) // append to end (right) of list
   {  document.getElementById( 'pt-logout' ).parentNode.appendChild( li );
   }
   else
   {  var before = document.getElementById( gsInteriotInsertBefore )
       before.parentNode.appendChild( li, before );
   }
 }
    if ( window.addEventListener ) window.addEventListener( 'load', InteriotLink, false );
 else if ( window.attachEvent      ) window.attachEvent   ( 'onload', InteriotLink );


[edit] examples

  • [10] - run through Kate's
  • [11] - same string run through only changing which counter
  • [12] - proper string run through Interiot's


The fact that they use a different format for their strings while not a "problem" causes issues when trying to implement them both in url string sets. Your tool also does not allow for the +user part of the string which Kate's does, granted I do not entirely understand the purpose of it though. Pegasus1138Talk | Contribs | Email ---- 04:08, 3 March 2006 (UTC)

Pegasus1138Talk | Contribs | Email ---- 04:08, 3 March 2006 (UTC)
Nevermind, it was an issue with something else I was doing with my JS interacting badly with the other scripts. Pegasus1138Talk | Contribs | Email ---- 20:52, 3 March 2006 (UTC)

[edit] Edit counts and privacy policy

Hello,

Some time ago I wrote the following about Kate's edit count tool. The same can be said about your tool.

Kate ( http://tools.wikimedia.de/~kate/cgi-bin/count_edits?user= ) might be considered a breach of policy §7 Privacy_policy#User_data which states : Data on users, such as the times at which they edited and the number of edits they have made are publicly available via "user contributions" lists, and occasionally in aggregated forms published by other users. Kate is not an other user but a tool displayed on a website owned by the Wikimedia Foundation. Kate is not an "occasional" publication, but a systematic tool available 24 hours a day, and providing informations on all users, not a smaller set of users selected on a particular occasion. The "disclaimer" section on Kate's main page seems to be the result of an inaccurate reading of the above mentioned §7. Kate is a controversial tool : see en:Wikipedia:Editcountitis for further reading.--Theo F 10:36, 4 January 2006 (UTC)

m:Talk:Privacy_policy#Possible_problems

I would not need to make these critics if you provided an "opt in" system instead of "opt out".

Best regards

Teofilo talk 12:03, 3 March 2006 (UTC)

I understand your point regarding the difficulty to check people's identity. That problem would be removed if your tool became a part of Mediawiki itself, wouldn't it? People would be abe to select an option in their Mediawiki preferences "Do I want to make my stats public YES/NO ?", with a "NO" default value. What I feel uncomfortable in the present situation, is that people are not told from the beginning, when they create an account, that they are going to be "copped" that way. I think they should be told, and have at least the option to disconsider opening an account or contributing to Wikipedia if they dislike this people-tracking. But it would be better if it were possible to contribute peacefully to Wikipedia without having to become the prey of people's curiosity. Teofilo talk 18:33, 3 March 2006 (UTC)
it's possible to, for instance, create a new account every day : Although this is technically possible (and quite cumbersome) this is frowned upon, as people generally think that multiple account holders do this to cheat votes. Teofilo talk 07:48, 4 March 2006 (UTC)
There are several pieces of code at en:Wikipedia:WikiProject edit counters : My God ! I think that talented people who have advanced knowledges in computing should use their talents to make Mediawiki less intrusive, not more. For an example of what less intrusive means, see the Checkuser tool : These data are only stored for one week, so edits made prior to that will not be shown via CheckUser. m:CheckUser Policy Teofilo talk 08:12, 4 March 2006 (UTC)
The edit counter will probably not be integrated with MediaWiki itself. You can try to bring it up with mediawiki devs if you really feel strongly about it, but it's almost certainly not a feature they'll implement.
One of the principles that should be respected when dealing with personal data is that collecting such data should be proportionate to the needs of the particular business concerned. If these data are really necessary, there should be no problem in inserting them inside Mediawiki. If they are not necessary, they should be deleted as needless. Teofilo talk 09:01, 4 March 2006 (UTC)

Just to add that teo, on fr:, has very often a point of view shared only by himself ;D Alvaro 13:33, 9 March 2006 (UTC)

[edit] Ultimate frisbeeterians

I did the undelete. However, it's still an orphan (and I think it still has the CSD tag). I'll leave dispensation to you, though. Geogre 14:52, 3 March 2006 (UTC)

[edit] Edit count graph

I couldn't email you, but I would like an edit count graph for me of my edits from my first, to current. Is this possible? -- Mac Davis]] ☢ ญƛ. 04:45, 4 March 2006 (UTC)

I would like a line graph of my edit frequency from Jan 2005 to now. The editcount thing gives me edits per week, and edits over time of day.

[edit] Note to self:

Generate the list of articles created for Brian0918, after tweaking the script's output slightly. --Interiot 05:30, 4 March 2006 (UTC)

Here is an example of a report I can generate for users. The query takes approx 5 - 15 minutes to run, so I can't make it an end-user runnable query unfortunately. --Interiot 17:10, 4 March 2006 (UTC)
Also, make sure everything on this page is either 1) finished, 2) it's on my Todo list, or 3) I'm not going to do it, and then archive this long page already! --Interiot 05:33, 4 March 2006 (UTC)

[edit] village pump fun

Hi Interiot, I made some fun using your counter, listing how often myself and others have visited our village pump on Dutch wikipedia. (See this if you like). I wonder if it is possible to list the other way around, I mean, a list of contributors whith the number of edits for an individual article. Or does it exist already? (No priority of course, its just for fun). Thanks for the nice counter anyway. Pieter1 18:41, 5 March 2006 (UTC)

[edit] PROD

Would it be possible to show the user who proposed the article for deletion on Proposed Deletion: current nominations? I think people will (wisely) more carefully review entries if they are made by users they don't know. Cheers, —Ruud 01:00, 6 March 2006 (UTC)

  • Yeah, I'll add this when I get a chance. --Interiot 15:23, 8 March 2006 (UTC)

[edit] Deleted edits

Is it still possible to see deleted contributions using one of your tools, or do you know of one that allows this? I'm trying to track down which article by Dreamzweaver got deleted. - Mgm|(talk) 09:26, 6 March 2006 (UTC)

I've been meaning to ask you about this; I know Kate had a deleted contribs viewer, but it was turned off when the policy changed. Since admins are able to view deleted edits, and your tools are capable of determining if a user is an admin, could we get an admin-only viewer for user's deleted edits? Essjay TalkContact 12:30, 6 March 2006 (UTC)
The tools are able to determine which usernames are sysops, but they're not able to verify that a specific person using my tools is tied to a specific username... we don't have access to passwords on the toolserver, and we're not otherwise able to authenticate someone as a specific user (barring more complicated means like me hand-verifying people, or via a tool that asks a specific user to place a specific word on their talk page, and then allows the user to create a separate password for my tools (toolserver tools can verify that a specific user made a specific edit)).
It's possible that Kate's contribution viewer got taken down because it showed the edit summary of each contribution, and that edit summary sometimes had personal information in them as well. As such, I have a temporary version here that only shows the article/time of the revisions (no edit summary), but I don't know whether it fits with existing policy or not. (it does show normal users somewhat more information than is available via Special:Log, for instance) --Interiot 14:20, 6 March 2006 (UTC)
Any hope of getting this linked from the "deleted edits" line in the edit counter, or is this supposed to be more clandestine? Essjay TalkContact 10:34, 9 March 2006 (UTC)

[edit] create an article 'Interiot's tool'

Hi, There is no article listed under 'Interiot's tool'. Why don't you create a page that links to your tool? - Richardcavell 08:51, 7 March 2006 (UTC)

  • Anyone is free to create an article for it. For now, WP:KATE covers it to some extent (especially because my tool can be used with the popups just like Kate's). --Interiot 15:23, 8 March 2006 (UTC)

[edit] Would be more active on irc except

I seem to be k-lined. Not sure why. I emailed staff@freenode.net, and I haven't heard anything back. Interestingly, I was k-lined while I was sleeping. I'm sure it's an error. IRC isn't required to hack perl, but it helps to be able to talk to your fellow hackers. Harumph. ... aa:talk 03:26, 8 March 2006 (UTC)

[edit] Q re your edit counter

Hi. When I look at the edit count, there is a "deleted edits" item. What does this refer to? Thanks! Slowmover 16:46, 9 March 2006 (UTC)

[edit] Admin counts?

Hi Interiot,

Your edit counter is really really great, thank you very much for your hard work! Especially useful when examining sysop candidates's edits :-P

I was wondering if you could hack a little something. Knowing how many sysop are needed is kinda difficult now that the usual statistics are not anymore computed, but very important as it determined how picky/pushy we need to be.

Another way to determine that would be to know how much admin edits (the red bar in your tool) are done on a specific wikipedia in one month, divided by the number of sysop (in order to have an idea of the load on one admin. If we find 2,000, we're probably in need for new sysop :) ). As you seem to already compute the sum of admin edits per user, it seems to me it could be determined as well. Could you try to find the time to hack a small report tool that would give a result page once in a while?

Or maybe replace the very active wikipedians counter that was kept up-to-date in the statistics before? It could prove useful for the same task I think.

Thanks for your time spent at reading this!

Eden - Talk 11:46, 10 March 2006 (UTC)

[edit] Proposed Deletion: previous nominations

Hello, Interiot. First a word of appreciation for your marvellous work in supporting the {{prod}} process, which I rate a big success and an improvement over the old model of "afd everything"! Can I suggest a small change to the previous nominations list query? Could it show only nominations that have been deleted or deprodded in, say, the last week or so (perhaps with a little cgi form at the top to allow date selection)? Currently it shows all, and this makes the page absolutely enormous, which probably puts some unnecessary strain on the toolserver (not to mention my browser :-)). Just an idea. Thanks. --RobertGtalk 12:04, 10 March 2006 (UTC)

Yeah, I'm going to do something like that soon (well, soonish, I'm going to be pretty busy in the next two weeks). I actually proposed truncating the view like that, and several people strongly protested, saying they only wanted the (next 50) links instead, so it will take a bit of time to sort that out. --Interiot 15:15, 10 March 2006 (UTC)

[edit] Redirect to subsection

There's probably a better place to ask this (feel free to redirect me ;-) but I thought maybe you would know this. Do you know if there is a reason a redirect to a subsection in an article will only redirect to the top of the article? (I.e. #REDIRECT [[User talk:Interiot#Redirect to subsection]] as a link will get to this subsection, but as a redirect will get to the top of this page.) I guess I'm wondering if this is something to ask about getting fixed, or if there is a reason it works the way it does. Thanks, – Doug Bell talkcontrib 17:51, 10 March 2006 (UTC)

[edit] Curious attribution

Hey there. Your tool indicates i uploaded this photo Image:WORONLDS3.jpg which is Image:WORONLDS3.jpg. Not me, I have never seen that image before. Moriori 20:13, 10 March 2006 (UTC)

Which tool is this? (sorry, I have so many tools, I don't really remember them all myself) If it's ~daniel/WikiSense/Gallery.php, then it's de:User:Duesentrieb's tool, and you'd want to ask him about it instead. --20:27, 10 March 2006 (UTC)

[edit] Whatlinkshere toolserver tool

Essentially...

A tool to seperate out the main namespace in the "Whatlinkshere" request. Several people have expressed interest. It will increase productivity.

Background (reading this is optional)

Hi Interiot, I have an idea for something on the toolserver.

Several people have expressed interest in being able to view just the main namespace when using "Whatlinkshere". These people are doing link repair at Wikipedia:Disambiguation pages with links. Currently, "Whatlinkshere" doesn't filter by namespace but we would like to view just the Main namespace.

Bug 4624 (a namespace filter for "Whatlinkshere") has been filed with no response (the feature may induce too much server load, or maybe someone just needs to write a patch for Mediawiki).

The tool would be quite similar to the edit counter. A user enters the page name, and the tool returns a namespace breakdown like the edit counter (or just the Main namespace, since that's what is important). A note of the replication lag would be useful too.

I would expect load to be small, since normal operation would involve submiting a request, spending 20 minutes working through the output and then submiting again. There couldn't be more than a handful of people doing this from around the world at any one time.

I have asked pgk about it, and he said it's on his list but to ask you too.--Commander Keane 17:07, 11 March 2006 (UTC)

Actually pgk has just implemented it--Commander Keane 18:24, 11 March 2006 (UTC)
Meh. Me too. Though mine works on non-mainspace stuff too, and works for image links and template links (though it doesn't do redirects and double-redirects like whatlinkshere does). [13] [14] Anyway, obviously, it's a fast query, mine simply orders things differently from how Special:WLH does, and hopefully these sorting options can be made avialable in mediawiki sometime. --Interiot 18:48, 11 March 2006 (UTC)

[edit] Size of bars

Hello Interiot, sorry to bother you, but I just found that the size of the bars in your edit counter is not proportional to the number of edits. For example, a bar indicating 650 edits can be bigger than one indicating 700. You probably know this or the problem may have another source, for which you are not responsible, if that's the case, just ignore this. Anyway, your tool is very good. Thanks! Afonso Silva 11:00, 12 March 2006 (UTC)

Thanks for the answer! I found that with my own counting - [15] - I don't know if it is a problem caused by my browser, I use mozilla firefox. Perhaps a print screen will also help - Image:AfonsoSilva_Interiot.PNG - I hope I can upload such image without problem, you may delete it. Regards! Afonso Silva 18:51, 12 March 2006 (UTC)

[edit] Counter Lag

My contribution count has stayed the same for the past 3 days, although I have made many edits. Is it just me? Or are other people having trouble. Weatherman90 18:12, 12 March 2006 (UTC)

Not only you. My counter stays since yesterday evening. Greetings, --Thomas Goldammer (Talk) 21:39, 12 March 2006 (UTC)
Well, for what it's worth, I added the replag description and displayed the current replag in the counter. Kate and Zedbot seem to be away for now, so there's not much I can do at the moment to try to get it fixed. --Interiot 22:20, 12 March 2006 (UTC)

[edit] counter

woa, the new stats about sysop actions (delete/block/etc.) are really cool... thank you, I've dreamt of something like that for a long time :) ...but the result is kinda scary at the same time : my number of deletion is almost half my number of edits, and I've blocked no less than 500 people ^^; wikiholism is bad.

But, since these stats doesn't reflect on the "Total edits" number, don't you think it may be better to add a small separation (well, it could just be an horizontal line) between the "normal" and "sysopspecial" (since anybody can move a page) stats ? It should prevent people from making any confusion about that, and prevent you from receiving "why does the total edit number show (normal number) instead of (number+move and other special actions) ?" and other similar questions.

Darkoneko 10:15, 13 March 2006 (UTC)

[edit] Hmm...a glitch?

Both yours and Kate's counters have held me at 3893 edits for my past several edits (at least six). What could that be about? -- §HurricaneERIC§Damagesarchive 02:24, 14 March 2006 (UTC)

Derrie, The database replication lag is currently 1 day, 12 hours behind real-time.. You might want to check that before posting here... ;-) JesseW, the juggling janitor 02:28, 14 March 2006 (UTC)
Maybe I'm just stupid, but I've been using it for several months and this has never happened before or at least I haven't noticed it. And Jessie, I honestly had no idea what replication lag was and nor was I aware that I was expected to. Try and cut us less technologically advanced people some slack. -- §HurricaneERIC§Damagesarchive 02:43, 14 March 2006 (UTC)
It's just that I get this question 12 times a week (I am happy to help users, but the same questions over and over gets a little old after a while). Also, there's a blinking section of text on the edit counter, clicking on the link there should hopefully help explain more. If there's a better way to explain the concept, feel free to make suggestions as to what's still unclear. --Interiot 02:59, 14 March 2006 (UTC)

[edit] Admin counts

Hi Interiot. User:Kate used to run a list of administrator edit counts [16][17]. She had a script to update them daily, but unfortunately her lists haven't updated since December. Could you take over that job, please? She provides her SQL query, so it might be very easy to set up (assuming the database scheme hasn't changed since then). Thanks, dbenbenn | talk 10:19, 14 March 2006 (UTC)

Well, Kate is still around (Kate is the primary admin on the toolserver, the one who works to keep replication lag low, and thus is more or less critical to any tools I work on). Kate just doesn't read User talk:Kate very often. I can put it on my todo list I guess... I don't have the code to do that yet. I actually need to get several of my reports to update regularly, and post themselves on-wiki, but that's not working yet. --Interiot 16:01, 14 March 2006 (UTC)

[edit] Size of bars in edit counter

The bars in [18] aren't proportionally consistent with the displayed edit counts. As of when the link above was added, I had 1113 edits in February and 1144 edits in March, yet the February bar is longer than the March bar. – Doug Bell talkcontrib 20:17, 16 March 2006 (UTC)

[edit] Sandbox Cats

Hi - you may want to deactivate the categories in User:Interiot/Sandbox/Security_engineering, as they're currently showing up in Category:Cryptography and Category:Security. Also: love the editcount tool - very spiffy! Regards, Ziggurat 20:44, 16 March 2006 (UTC)

[edit] Counter

Can you add a chart for all the edits? It's great to see the charts for every month and I think it would be great to have a chart for all the edits. -nagytibi ! ? 09:33, 17 March 2006 (UTC)

[edit] User:Samstayton's Harassment

User:Interiot, thank you for your comments on the Luxury vehicles aritcle page. Unfortunately, User:Samstayton has started harassing me on Wikipedia. Please notice this comment he left on User talk:Samstayton which insulted me quite a bit

  • This creature Zouf is obnoxious, vicious,juvenile and ignorant. He has plenty of time to waste, he writes all sorts of non-sense and runs to an administrator like a dog behind its tail to the master. The edits he has done so far are pitiful. I feel sorry for wikipedia and this guy. May God bless his parents. He claims to use proper grammer. His edits on "lexus" dated 00:50, 15 March 2006 clearly show his skill. It is harrowing. Samstayton 05:52, 12 March 2006 (UTC). Samstayton 05:52, 12 March 2006 (UTC)

Also, he added this text after he had already left another comment with that timestamp, so that it would seem he left it almost 5 days ago. This is not the first time he has personally attacked me. I would like for me to use Wikipedia without being harrassed, and Samstayton is not letting that happen. I would be appreciative if you would look into this. I am trying not to respond personally and keep this as "business oriented" as possible. Thanks a lot! --Zouf 13:47, 17 March 2006 (UTC)

Interiot: There's been a WP:RFI placed about this- are you ok dealing with it as I see you've done some work on it already? Feel free to remove and/or archive the request from WP:RFI if you think this situation is over. Cheers, Petros471 18:09, 17 March 2006 (UTC)

  • I'm busy with work issues for the next week or two, and probably don't have time to follow up, sorry. It's possible that Samstayton has stopped editing? If not, he should be reminded of our policy on civility, and that excessive personal attacks can result in a temporary block. --Interiot 18:46, 17 March 2006 (UTC)
Ok, I'll keep an eye out for a few more days, but he does seem to have stopped for now (the last problem being the edit described above made on the 17th). Petros471 12:51, 19 March 2006 (UTC)

[edit] Counter and "Portaal" namespace on nl.wikipedia

Hi Interiot,

A small remark for the results of your counter for nlwiki_p (example: [19]): "Unknown namespace 100" = "Portaal" and "Unknown namespace 101" = "Overleg portaal". Keep up the good work! Best regards, Tdevries 00:44, 19 March 2006 (UTC)

[edit] Interiot Counter Bias

Looking Over this data, there is a significant error in the edits/page category. At the least, the heading is more correctly stated as 'Saved Edits per Day'.

I go out of my way to NOT save until the edit is 'well cooked', so the edits/page number is missing the larger high quality edits I do make. Or is that edits/10 minutes data counting preview looks as well? In other word, what's it counting as an edit? Not a gripe, save as one computer pro to another, I think the heading needs the title I suggest, assuming my inference is correct on the save (vs preview) is the basis of the counter. I'm amazed at a thousand edits, not that I care!

  • Would really be interesting to see the ability of taking the data set over a given range of dates. My edits per day is way down as I went south to help the Hurricane Katrina recovery after a long August vacation, so was inactive for the best part of seven months, less a few long weekends and one two week break back home near Boston. Your activity data reflects that quite clearly!
  • The edits per 10 minute span means what? That chart should be 'up sized', if you like a further reaction (Call it a delayed design review <G>) The axes of both charts are tough on tired old eyes like mine (51y.o.). Also, what's the 'Deleted Edits' category counting? Do I have to go pick a fight somewhere!?

Thanks, great work!

  • Got a spell checker yet for IE6? No? Perhaps I need to downgrade that great to good... sigh.
Keep it up! FrankB 04:47, 19 March 2006 (UTC)
The edit counter just counts saved edits, as there is no way to measure how many times an editor hit "preview" for his or her edit. Previews are not recorded in the database, and as a result, are less costly on the servers and are recommended by developers. However, there really is no technical method to determine whether a particular edit is fixing a redirect or creating an article from scratch, sadly. That's why editors, when looking at someone's contributions, are encouraged to look at the quality of someone's contributions, not just the quantity.
As for the deleted edits, that is the number of edits attributed to you that were made to pages which were eventually deleted. A high number of deleted edits is not particularily "bad", per se, as it can also mean a high number of correctly tagged speedies. Also, the minute data spans your entire contribution history, as the number of edits that are within a ten-minute span are lumped together to make the graph.
As for taking the data over a given range, it is possible to do it on the toolserver, but it would require a complete redoing of the interface of Interiot's tool. However, Flcelloguy's Tool has the data structure backend necessary to support that and is currently under development, so you don't have to wait too long for that. Titoxd(?!? - help us) 05:01, 19 March 2006 (UTC)

[edit] Long Bomb (Hail Mary Pass)

Hi again. Something occured which leads to a longish technical question. Thought I'd keep your talk uncluttered. No particular urgency, but a 'gut feel/knee jerk' answer would be nice! FrankB 20:52, 19 March 2006 (UTC)

Can't you just open the "new messages" link in a new tab / new window? --Interiot 00:34, 20 March 2006 (UTC)

[edit] Edit count

Welcome back from your holiday. I like your edit count too - here is my page. To me it looks a bit spikey. Have you considered a normal distribution blur, like this? Stephen B Streater 21:51, 21 March 2006 (UTC)

Still on a trip, I'm just editing much less frequently than I normally do. I don't know, my gut feeling is that it would be even spikier. That is, I doubt that many people's editing patterns are consistent on a daily level, but it are much more likely to be stable over monthly-chunks. (people like SimonP would probably be consistent over 24 hours, but very few users edit at that rate.) --Interiot 22:10, 21 March 2006 (UTC)
The blur will make it less spikey if the charts cover the same overall time periods as now. Replace each number with, say, 5 numbers with weighting 1/16, 4/16, 6/16, 4/16, 1/16 - making the top of the spike half the height, but wider. If you blur it enough, the graphs gently meander up and down. I can give you more details if you are interested in making the graphs smoother. Stephen B Streater 22:48, 21 March 2006 (UTC)
But it would make the popups quite a bit more difficult (eg. they should probably still be monthly, but that'd require something like Flash to do properly). I think it would be interesting to see, but the bars have some amount of functionality now (popups, clickable), and I don't think the continuous graph would enhance the functionality (and would make the functional stuff harder to implement). --Interiot 23:18, 21 March 2006 (UTC)
I hadn't noticed the pop-ups on the bars - thanks for pointing these out. I wasn't suggesting changing these. I suppose I'll just have to make a few thousand edits until the graphs smooth out a bit more. Stephen B Streater 07:27, 22 March 2006 (UTC)

[edit] Edit counter

I can't get the edit counter to work. I enter a user name (even my own) and it says "This user does not seem to have any edits, or they don't exist". I've tried different cases, as well as prepending "user:", but I can't get it to work. What am I doing wrong? Bubba73 (talk), 03:59, 22 March 2006 (UTC)

This works. *shrug* make sure you're using enwiki? --Interiot 07:01, 22 March 2006 (UTC)
The one that works is this. If I click on the userbox on my page, it takes me here, note that the "_p" is missing. Although that one gives my stats, if I enter a user name from there, it give the "not found" message. Bubba73 (talk), 20:47, 22 March 2006 (UTC)

[edit] Specific edit #

Would it be possible to add a "lookup specific edit #"? I see a lot of people posting their 1000, 2000, etc. edits, but I'm quite sure I'll be missing it then. Or is there a trick to this, maybe through "my contributions"? Thanks, dewet| 10:10, 22 March 2006 (UTC)

Hrm. The trick I'd use would be to 1) go to Special:Contributions, 2) click on one of the 20/50/100/200/500 links, 3) change the limit number in the URL to be 1000 (or whichever), 4) click on "earliest", and 5) note the edit at the top of the page. This works up to your 5000th edit. Beyond that, you have to hit the "previous 1000" (or whatever) link, but then that's tricksy because it's not REALLY the previous 1000, it's the previous 999, along with 1 edit that it already showed you (change the limit to either "1" or "2", and then hit next/previous to see what I mean). --Interiot 11:28, 22 March 2006 (UTC)

[edit] Editcounter

First off, nice job with the editcounter! Secondly, not so nice ;-). Your editcounter, along with the whole toolserver stopped working in IE for me a few weeks ago. It works fine in Firefox, but not in IE. Here is what happens:

  1. I load up the editcounter(for example) through the link on my userpage
  2. Works fine
  3. I type any user I haven't searched for before's username box or the address bar
  4. It either fails to load, or takes several minutes too.

This happens with any new page on the toolserver. Who should I tell this to, and what should I do about it?

Prodego talk 19:22, 22 March 2006 (UTC)

Did you miss this message? Prodego talk 23:32, 23 March 2006 (UTC)
No. It's a bug that should be fixed, but I don't think it's a particularly serious issue. (if you don't start out with a link that has enwiki, then it's fine.) Fix the link/userbox, and move on. (when I archive my talk page, I'll try to make sure it either gets fixed, or gets put on my todo list). --Interiot 23:51, 23 March 2006 (UTC)
Well I tried clearing my brower cashe, deleting files ect, and then entered "tools.wikimedia.de" into the address bar, but it still took over 5 minutes to load. Are you sure this is the problem? If it is, how do I 'fix' it? Prodego talk 19:28, 24 March 2006 (UTC)
Oh, got you confused with a different. Hrm, it looks like the java server is down, so the root page (http://tools.wikimedia.de/) won't load properly. However, the edit counter should generally load properly, even for usernames that don't exist. If, however, you're using Kate's counter (http://tools.wikimedia.de/~kate/cgi-bin/count_edits), then it looks like it doesn't finish loading for non-existent usernames. If this is the issue... either use my edit counter, or just assume that when it fails to load for 10+ seconds, that that means the user doesn't exist. --Interiot 22:09, 24 March 2006 (UTC)
That sounds just like the problem I am having; thanks for the help, and explanation! This makes me wonder why Firefox worked so much faster. In Firefox the toolserver pages would load in seconds, in IE several minutes. I guess I know which is better now ;-) Any idea why the server would be down, BTW? Again, thanks Prodego talk 00:20, 25 March 2006 (UTC)

[edit] Edit counter

Still about the edit counter: I went to [20], clicked on the contribs of December 2005, and I got [21], which contains a contrib from July. Maybe something strange with that "999999" in the URL? Best, 151.100.59.2 20:05, 22 March 2006 (UTC)

Aha... the limit= value I'm using includes the admin actions as well, so it's catching the page-protect you did. Hrm hrm. Okay, the problem should be fixed now. --Interiot 20:09, 22 March 2006 (UTC)

[edit] Deleted edits

Hi,

Your editcounter says that I have one deleted edit. I wanted to ask what deleted edits are and if it's possible for me to find out which edit that is. Can you please enlighten me? Thank you.

P.S. That Zen Master story is brilliant. Loom91 13:16, 23 March 2006 (UTC)

  • Deleted edits are when a page you edit one is deleted. See here. --Interiot 21:33, 23 March 2006 (UTC)

[edit] {{legend}}

Greetings. I like the {{legend}} additions to the plate articles! I thought you might want to look at some maps I made using MS-Paint. (I know, I know, but it's all I had.)

  1. At Kalahari Basin, the map shows the basin in orange and the desert in red.
  2. At Roman_Empire#Historians.27_viewpoints_on_the_evolution_of_Imperial_Rome, the colors on the map aren't very good, so I was wondering what you might be willing to do on that one.

All the best, – Quadell (talk) (bounties) 00:02, 24 March 2006 (UTC)

[edit] Question/request about edit counter

Hi Interiot. First, let me say that your editcount tool is really, really great. Extremely useful for all sorts of things. In light of that, I have a request: as I understand the color scheme you have now, the green color covers both edits made to articles directly, and edits made to Talk:. Is that correct?

If so, would it be possible to make these two different colors? The reason I ask is that these sorts of things always come up in RfA's and similar; people are discussing if a given user has too much Talk: edits, not enough Talk: edits, etc. It would be convenient to see this in the color distribution as well.

Of course, there may be some technical reason why this might be hard to implement, and if so, then don't go through too much trouble. But if it's a quick thing, it would make your incredibly useful tool even more useful. Thanks! --Deville (Talk) 16:04, 25 March 2006 (UTC)

[edit] zh-yue Wikipedia

The Cantonese Wikipedia (zh-yue) is now open. See if you can add it to the editcount program. --Deryck C. 06:48, 26 March 2006 (UTC)

I don't really control the list. Also, the data isn't yet replicated to the toolserver, so there's more to it than just adding it to the list. I've made a request to the toolserver admin to have it replicated though. Ping me again in a couple days if it's not working by then. --Interiot 07:09, 26 March 2006 (UTC)

[edit] Edit counter suggestion

Hi Interiot,

First, I love your counter. Great tool. (I definitely have editcountitis).

Just one suggestion/request. Could it generate a chart of edits per day (or maybe month) over time? If not, your tool is still awesome, but I think that chart or something like it would make a great addition.

Thanks, -Reuvenk[T][C] 08:48, 26 March 2006 (UTC)

[edit] Edit counter suggestion, redux

Hey Interiot; for the edit counter, on the count-per-page type/action, can you make a new column for percentage of total edits? (As in (main) | 377 | 24.5%)? Thanks, Jjjsixsix (t)/(c) @ 01:14, 27 March 2006 (UTC)

[edit] List of car models

According to me, the list is a valid part of Wikipedia whereas the article is a for-deletion candidate. --Just my 2 cents -- Hemanshu 07:59, 31 March 2006 (UTC)

[edit] April edit counter

Hey Interiot. I was just looking up my edit count and saw all my edits for the month of April was rolling over into March. Is this supposed to be happening? Moe ε 19:26, 1 April 2006 (UTC)

It's the replication lag - your edit count displays your number of edits c. 20 hours ago, that'd be abour 23:30, 31 March UTC [22]. Edwy (talk) 19:30, 1 April 2006 (UTC)

[edit] Editcount

Hi. Could you explain me why at my edit count [23] my only contribution displayed for April is my last? --81.9.133.60 21:22, 2 April 2006 (UTC)

[edit] Your tool

Your wonderful/evil/dealy tool seems to be updating very slowly. It now has a backlog of 1 day, 8 hours. Is everything ok? JoshuaZ 14:10, 3 April 2006 (UTC)

It's now 1 day, 12 hours! (I make that about 2 a.m., April 2, UTC.) --Thelb4 14:06, 3 April 2006 (UTC)
Latest update time can be found here. It's updating, but very slowly. Toolserver admins aren't around much, so it's not clear what's causing it. --Interiot 16:10, 3 April 2006 (UTC)
For some reason your tool is counting some of todays edits but not edits made on April 1st or 2nd. Weird, huh? Jedi6-(need help?) 20:05, 3 April 2006 (UTC)
The link you're clicking on exhibits that behavior, but that's... kind of an odd side-effect between toolserver replag and wiki real-time data, and doesn't indicate any deeper problems with the namespace breakdowns or anything. --Interiot 20:10, 3 April 2006 (UTC)

[edit] Tiny editcounter bug

Here [24], it shows "browse) -->" after the deleted edits. I guess this has something to do with the dashes in the username and only commenting out instead of deleting the "browse deleted edits" bit? Anyway, thanks a lot for your tool, I had a lot of fun with it already. Kusma (討論) 00:25, 4 April 2006 (UTC)

Ahh, strange bug. It only occurs for usernames with "--" in them, but anyway, it's fixed. Thanks for letting me know. --Interiot 09:44, 4 April 2006 (UTC)

[edit] Graph of replication lag?

It would be a really cool thing if you added a historical graph to your replication lag display. If there was an easy way to see how the lag has been changing over time, people (like me) wouldn't worry that the toolserver was stuck when it was really just running slow. Hope you enjoyed your trip in March. JesseW, the juggling janitor 01:20, 4 April 2006 (UTC)

Yeah, I'm thinking more and more about that. This has been one of those thing that I hadn't wanted to spend time on, because someone should really spend time to fix the root problems, rather than someone spending time to indicate when problems are occuring. But maybe I'll go ahead and code this up. Yeah, I enjoyed the trip of course. Now I just have to get over this jetlag... --Interiot 09:44, 4 April 2006 (UTC)

[edit] Mummified previous PRODs

First off, thank you for all your work creating the PROD utility pages on the toolserver! Unfortunately, while the current nominations just suffer from the normal ~1 day replication lag, the previous nominations seem to remain stuck in March. Is this a normal lag effect or another bug altogether? Best, Sandstein 15:29, 4 April 2006 (UTC)

Ahh, I wondered if that might happen. It's a bug, I'll try to fix it, thanks for letting me know. --Interiot 01:08, 5 April 2006 (UTC)

[edit] List of Wikiprojects

Hello, Interiot. Is it possible for you to generate a query for all pages that are on the Wikipedia namespace, that contain "WikiProject", "WikiPortal" or a variant in its name, and to list the number of edits in their history, as well as to determine the last edit on that page? That would be useful for obtaining a list of active WikiProjects for the List of WikiProjects (woefully out of date) and the Work Via WikiProjects lists, as I really wouldn't know where to start if running a database dump query... Titoxd(?!? - help us) 00:31, 5 April 2006 (UTC)

It turned out to be a pretty easy query... here you go. I left the #edits part off, because that would slow the query down a whole lot, but if you really really need it, I can see if I can make a manually-updated version of it or something. --Interiot 01:08, 5 April 2006 (UTC)

This might also be useful within the editcounter to determine where Wikipedians spend their time—whether on WP:AFD, WP:FPC, WP:FAC, WP:FLC, or WP:PR, etc. In most cases, no one posts more than a few times to each of the pages in these sections, but the cumulative edits in these areas can be significant. Maybe incorporate it into the contribution tree? Or set up something that divides the edits to each section by month, not unlike the edit counter? Granted, the alphabetization option of the contribution tree can help a user get a handle on this, so maybe it isn't particularly necessary. —Spangineer[es] (háblame) 00:51, 6 April 2006 (UTC)

It might be nice, but it would make the contribution tree decidedly language-specific, when right now, it's trying its best to work for all languages. (things can be translated, yes, but I'm not that experienced or that hard working :). This is one place where a {{SoPatchIt}} tag would be good... if there's anybody out there who'd want to implement this, I'd gladly work with them as necessary to get these sorts of features added on to the existing code (if they weren't hard-set on forking, I guess). --Interiot 00:59, 6 April 2006 (UTC)

[edit] Marshall Teague edit

I really would like you to reconsider the removal of the category on Marshall Teague. Why can't a NASCAR driver who had an impact on Hudson, also qualify as a automotive biography? How does adding his name hurt the category? Stude62 01:38, 6 April 2006 (UTC)

[edit] No optout-list chance for german wikipedians?

Well, I have to draw your attention to the sad fact that your formal promise (included in the description of your famous edit counter even im Wikipedia-de) to reshape the size of information about WP-authors, namely the revelation of the days and hours of their contributions, DOESN'T WORK as far as I tested it.

Yes, I got the message You must be logged in and have a valid e-mail address in your preferences to send e-mail to other users. And I tell you honestly I have fulfilled those conditions. Nevertheless it won't set to work what it should do.

I want you to make it work even for those outside the huge english-speaking branch of wikipedia like me. And I tell you that I see it as a menace, to be spied out like that. (In my own nation, Germany, it is even judged as a broken law to spy out personal privacy like that. But in USA they are VERY greedy for data collecting about everybody, I know that.) Now I just want to get rid of those time budget spying and online publication for anybody else. Would you please see to it, that it might be accomplished SOON.

For your instruction, to go out the way of misunderstandings, I have newly made an English-WP second account under the same name but I want your help for my original account Justus Nussbaum at de.wikipedia.org. Thank you in advance for seeing to it quite soon. -- Justus Nussbaum 18:54, 7 April 2006 (UTC)

You're in the opt-out list now. For the record, I'm not violating anyone's privacy, as the data will always exist, per GFDL compliance, and anyone can still create the graph via offline tools. My tool does make it much easier to access the data though, and in cases where that might disuade people from editing, I'm happy to opt them out. --Interiot 20:31, 7 April 2006 (UTC)

[edit] new mini-tool

This is a not-completely-public tool, but in case anyone is interested... This is a tool that lists long-running queries on the toolserver, because longer queries can definitely increase the replication lag. Queries that are running for an hour or more are usually mistakenly created by the owner, who forgot to kill the long-running query. Queries that run for, say, 10 minutes or more, and which run very frequently (eg. via a public CGI script), are something that hopefully the user can optimize or cache, to limit its impact on the replication lag. --Interiot 06:35, 10 April 2006 (UTC)

I just saw a 3-second query on the toolserver. Is it supposed to list all queries or just long-running ones? Titoxd(?!? - help us) 06:46, 10 April 2006 (UTC)
It lists all 2+ second queries (it's not really all that public or polished of a tool). It's just that I have people frequently asking me about replication lag. As far as I know, the only two episodic/non-systemic causes of replication lag are 1) long-running queries (which, as I said, are often accidental), and 2) sometimes replication stops, and Kate has to manually restart it (I haven't heard why replication randomly stops). The continuously-long replag this past week though may be more of a systemic issue... Kate isn't around very much, but Tim Starling had some ideas about what it might be (though there might not be a direct/easy fix). --Interiot 06:55, 10 April 2006 (UTC)

[edit] More privs

You should now have the ability to query the mysql replication status directly without the need to check the timestamps etc. Try "show slave status\G" next time you are logged on, column Seconds_Behind_Master (duh!). Though I believe Kate has said this can sometimes not match reality. --pgk(talk) 16:09, 10 April 2006 (UTC)

Woo, awesome. :) I've now added a few fields from that (that I thought were useful, and couldn't negatively impact security) to the zedbot,blame script. More information, yay. (hopefully the error message that's displayed couldn't have security implications?) --Interiot 22:55, 10 April 2006 (UTC)

[edit] Your Whatlinkshere tool

I saw you advertise your whatlinkshere tool on Template:High-traffic, and I wanted to let you know it is appreciated. Is it possible for you to add in a feature that will organize the list by the date added (in the date= parameter)? If you could, that would make the tool a million times more useful. Thanks, Mysekurity [m!] 21:49, 10 April 2006 (UTC)

It's possible, I suppose (I did something similar in the {{prod}} tracker, for instance), but it takes some amount of work and isn't always reliable. A better solution is to make the template include a category, since the wikipedia database itself records the date/time that an article was added to a category [25]. It's a little-known fact, but it's damn useful sometimes. --Interiot 22:12, 10 April 2006 (UTC)
That's a very cool feature I didn't know about. How hard would it be to use that feature to generate a history of all the pages that have at some time been in a arbitrary category? Is the date added info removed at the same time as the page is removed from the category? Anything like a reverse-history feature for categories would be extremely cool. JesseW, the juggling janitor 22:44, 10 April 2006 (UTC)
Yeah, unfortunately, the wikipedia database itself only stores transaction dates for category-addition, not for category-removal, or anything else. I do have some code that frequently checks up on a category, and records entries that it sees disappear (I'm using it for the {{prod}} history tracker), but it's something I can only do for a smaller number of entries, and it's something that's prone to breakage (eg. the prod history is currently down). In limited use, it's definitely useful, though I agree that if it were possible to be done for every category, that would be neato-keen. I think somebody needs to start wooing Brion so we can get some crazy schema changes implemented on the primary servers. :) --Interiot 23:08, 10 April 2006 (UTC)
It's funny that you bring a category up; I proposed adding a category (using the date added as the piped text, and thus organizing the articles by date), but Lifeisunfair (a.k.a. David Levy) was opposed. I was wondering about the ProD tool (which is beautiful, btw), and its application with this conundrum. I'd greatly appreciate any insight you have on this matter, and I agree it would be interesting to see some kinda category-finder thing. Good luck with Brion, and thanks, Mysekurity [m!] 00:18, 11 April 2006 (UTC)

[edit] A question/favour

Regarding your Wikiproject tool, could something similar be done for Portals? How complicated would it be to do? Steve block talk 09:21, 11 April 2006 (UTC)

Ahh, that's what you wanted originally. Okay, they're available in the same script now, wikiprojects sorted on top, portals sorted on the bottom. Is there a version of {{inactive}} that's used for Portals? I couldn't find one. Or are you mostly interested in just a comprehensive list of portals? --Interiot 10:08, 11 April 2006 (UTC)

[edit] Usability suggestion for the edit counter

Hi Interiot, when using the edit counter for other projects than the english wikipedia, it's always a bit lenghty to scroll through the menu to the right wiki. Duesentrieb's wiki selection is much faster. It would be nice if you could change the interface. greetings and thanks for your great tool :-) --Elian Talk 09:21, 11 April 2006 (UTC)

Well, if you're using Internet Explorer, once you click on the dropdown, you can hit "d" to jump to the "da" / "de" section, that's less scrolling. If you're using a better browser, you can type "dewiki" or "dewikt" to jump right to the entry you want.
I'll think about it. Duesentrieb's user interfaces are definitely more polished than mine (I hate interfaces, and think everyone should throw away their mouse, use the command line, and drive a stick shift), and my scripts would be improved if I imitated his. On the other hand, you can't choose meta.wikimedia.org from his.  :) --Interiot 10:04, 11 April 2006 (UTC)
I'm using firefox. Typing works there as well, but lots of people don't use their keyboard (for totally uncomprehensible reasons, I agree with your opinions about command line interfaces ;-) Just think about it (and I'll remind Duesentrieb to add meta). One other thing: I just discovered [26] - could we have a german version? I'm currently busy with the de:Wikipedia:WikiProjekt Portale and this would be a great help. Naming conventions are almost the same: "Wikipedia:WikiProjekt Name" (Category:WikiProjekt) for projects and "Portal:Name" (Category:Portal + subcategories) for portals. --Elian Talk 12:21, 11 April 2006 (UTC)
How 'bout Category:Inactive WikiProjects, does that have an analogue on dewiki? --Interiot 12:27, 11 April 2006 (UTC)
No, but I can create one ;-) We have enough inactive Wikiprojects to justify this category. Call it Category:Inaktives WikiProjekt. For the Edit counter GUI: I played around a little bit, you can see (and take, if you like) the results on [27] and [28]. I have two left hands with HTML so there are some flaws (footer should be really at the foot of the page, top image is cut a bit) but I think it presents the important element, the input form, more prominently (and who is reading the disclaimer anyway?). --Elian Talk 13:36, 11 April 2006 (UTC)
The HTML isn't really the issue, there's underlying code to be written (and if I did it, I'd want to do it in such a way that I could re-use the code across my growing pile of other tools). Could you create the category, and then let me know, so I can test/verify my code works? (that is, if you intend to create it in the first place... IMHO, it's useful in the current script, but it's up to you) --Interiot 13:40, 11 April 2006 (UTC)
Category is created: de:Kategorie:Inaktives WikiProjekt and has already two entries... --Elian Talk 14:01, 11 April 2006 (UTC)

Here you go: de_wikiprojects. It'd be nice if you could post the link semi-prominently somewhere, just so people know about it, so the tools work isn't wasted. Also, the existing descriptive text is in English, I can replace any of it with a german translation if you want (though the "Replication lag is 1 minute, 17 seconds" and "476 rows generated in 0.46 seconds" text is auto-generated, and would take more work to swap out). --Interiot 14:41, 11 April 2006 (UTC)

coooool :-) Thank you so much! Most germans speak english quite well so it's not really necessary to translate. But anyway, here is a translation. --Elian Talk
  • Dies ist eine dynamische Liste aktiver und inaktiver WikiProjekte und Portale der deutschsprachigen Wikipedia.
  • Es ist eine Variante der englischen Version. Den Autor erreichst du auf en:User talk:Interiot.
  • Die "letzter Edit"-Spalten zeigen an, vor wievielen Tagen der letzte Edit auf der Projekt- bzw. Diskussionsseite war.
  • "Aktiv" zeigt an, ob eine Seite in der Kategorie:Inaktives WikiProjekt gelistet ist.
  • Replication lag is 4 seconds.
  • Page=Seite
  • Last main page edit=Letzter Edit
  • Last talk page edit=Letzter Edit auf Diskussionsseite
  • Active?=Aktiv?

[edit] Summary of deleted edits?

I understand that deleted edits can no longer be viewed, but how about providing access to a summary of deleted edits by namespace? Cheers! BD2412 T 18:00, 11 April 2006 (UTC)

From my understanding, the deleted-edits viewer was removed, because edit summaries could show bad things. I have a provisional tool that doesn't show the edit summary [29], but I don't know if it's acceptable or not.
Though maybe my current tool isn't so good, because malicious people can use article titles that contain private information? If so, maybe I should switch over to your suggestion? --Interiot 18:09, 11 April 2006 (UTC)
Actually, I'm more interested in seeing how many deleted edits I have in each namespace than seeing those particular edits or articles (although I find that interesting as well). Thanks for your time! BD2412 T 02:09, 12 April 2006 (UTC)

[edit] Edit counter

I just wanted to congratulate you for removing the replication lag on the edit counter. Now we can all resume having it open in a second tab and refreshing every minute. _-M o P-_ 21:40, 11 April 2006 (UTC)

It's not my doing... Kate is the one who does the hard work of keeping the toolserver humming. But yeah, it's good to see that things are back and working again. --Interiot 21:45, 11 April 2006 (UTC)

[edit] Toolserver is effectively down

So, last night, there was an architectural change to make en.wikipedia.org faster. As a side effect, the toolserver currently no longer receives replication updates from enwiki. Some admin work on the toolserver will be needed to allow the toolserver to receive updates from enwiki again. Kate is the primary admin on the toolserver. I'm not personally able to do anything to fix this, though I'll pass along any status updates I get. Note that the kowiki_p, mswiki_p, thwiki_p, and jawiki_p servers have long been in the same position enwiki_p is now in, and a technical solution hasn't been found for those yet, so it's possible that the toolserver will be down for some time, at least for enwiki.

There are various people who may be able to speed resolution of this issue (Wikimedia Deutschland owns the server, and have a final say in what happens on it; the core Mediawiki developers, and possibly a few other people, may have some suggestions about possible technical solutions). But it still may be some time before the toolserver is available for enwiki, given how long the asian servers have been unavailable. --Interiot 13:56, 12 April 2006 (UTC)