Jump to content

User talk:JaGa/Archive 5

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
Archive 1←Archive 3Archive 4Archive 5Archive 6Archive 7→Archive 10

Lonelypages Toolserver PHP Pages (etc)

These appear to be broken with the error:

Database error:

Table 'enwiki_p.page' doesn't exist

I was using http://toolserver.org/~jason/Lonelypages.php linked from Wikipedia:Orphan (enwiki). twilsonb (talk) 06:59, 4 August 2009 (UTC)

HTML bug in disambig tool

Hi, Jason. In your Disambiguation Pages with Links tool, your program is not converting ampersands in page titles into HTML & entities. For example, for the disambig page A&M, your report generates the following line (copied from the latest report):

<tr><td>   2673. <a href="http://wiki.riteme.site/wiki/A%26M">A&M</a></td> <td align="right">  <a href="http://wiki.riteme.site/w/index.php?title=Special:WhatLinksHere&target=A%26M&namespace=0">68 links</a></td></tr>

The text inside the first <a> element should be A&amp;M instead of A&M. Thanks! --R'n'B (call me Russ) 21:01, 25 August 2009 (UTC)

Hi, R'n'B. I tweaked the page. Could you confirm that's what you were looking for? Thanks. BTW the Daily Disambig is addictive. I really like what you've done there. --JaGatalk 22:15, 26 August 2009 (UTC)
Thanks, it seems to work fine (except that now I have to go back and fix all the old entries in my database, which I should be able to do today). --R'n'B (call me Russ) 11:23, 27 August 2009 (UTC)

Source code

Hi, I was looking for source code of your scripts to count disambiguation pages and links, but it seems you dont upload them to SVN or they arent open sourced? Justass (talk) 22:08, 30 August 2009 (UTC)

I haven't released the source. It's working, but it's messy and would be hard to understand. I want to fix the code up before releasing - so I won't have answer for my sloppy code. I'm afraid it'll be a while before I do so, though, since I'm pretty busy these days. --JaGatalk 18:16, 6 September 2009 (UTC)

Hi JaGa! I recently asked for help at the Village Pump for getting the number of pages that link to a given page (Wikipedia:Village_pump_(technical)#Counting_the_number_of_articles_that_"link_here"). Folks there suggested that your Toolserver program as a good starting point. I've looked at your utility and it seems quite appropriate, do you think that you could help me adapt it for my needs? Specifically, I would like an online utility that would count the number of links to any specified page. I am a programmer and have some experience with the API, but your help would be extremely valuable. Thanks, -Sligocki (talk) 02:02, 4 September 2009 (UTC)

Well, as I mentioned above, I haven't released my code yet. Do you have a Toolserver account? All my stuff is PHP that runs against the toolserver's replicated Wikipedia database; you have to get access to that for my stuff to be of any value. This link should get you started if that's the path you want to take. --JaGatalk 18:22, 6 September 2009 (UTC)

No update today?

Your toolserver pages don't seem to have updated this morning. --R'n'B (call me Russ) 12:22, 20 September 2009 (UTC)

I checked it out, the script was hung up. I killed it and restarted - hopefully we'll see results in about 15 minutes or so. --JaGatalk 13:31, 20 September 2009 (UTC)
Hmmm, it seems to be hanging in the same step of the process. It'll take some investigation - probably won't be able to get to this until tonight. --JaGatalk 13:45, 20 September 2009 (UTC)
I've dug into it, and there's a query that used to take seconds now hanging indefinitely. I don't see anything wrong with the database or the other queries, so maybe it's something with the data itself. I'll have to look closer; dab updates may be offline for a bit while I investigate. --JaGatalk 23:01, 20 September 2009 (UTC)
I've been hammering away at this; the data looks fine, the code looks fine, but a complicated query that once took seconds now takes at least half a day. I'm going to re-write it as a stored procedure tonight and see if that helps. Sorry for the delay; I hope to have the reporting back online by tomorrow. --JaGatalk 07:08, 22 September 2009 (UTC)
OK, I've converted that sucker to use cursors, and it's working again. --JaGatalk 20:16, 22 September 2009 (UTC)
Great, thanks! --R'n'B (call me Russ) 00:06, 23 September 2009 (UTC)

Alfonso Domínguez

Thank you for the note about this article. I hadn't noticed the vandalism, and see that you reverted it. Best regards. Jogurney (talk) 21:25, 24 September 2009 (UTC)

No worries. My apologies for not noticing that it was vandalized before I placed the tag. --JaGatalk 21:27, 24 September 2009 (UTC)

Thank you!

Thank you...thank you. :) Wikipedia Cleaner is AWESOME. Best tool I've ever found for disamming. It's made it much faster and easier. Early month is easier anyway because the disams tend to be more obvious. But thank you. :) --User:Woohookitty Diamming fool! 12:02, 2 October 2009 (UTC)

I'm at 3,300 now. LOL Yes. I have no life. :) It helps that this month, the ones around 100 are pretty easy and straightforward. --User:Woohookitty Diamming fool! 12:10, 6 October 2009 (UTC)
Heh, yeah, I'm making a run at #2 but you could probably stop working today and I still wouldn't catch you! I'm hoping we get the OK to expand the list for November - 250 isn't enough anymore :) --JaGatalk 13:03, 6 October 2009 (UTC)

"rural southern Ohio"

Proctorvegas ain't that rural, at least compared to Meigs County. :) youngamerican (wtf?) 14:29, 7 October 2009 (UTC)

True that. Really I could probably leave out "rural" altogether, as it's more or less covered by "southern Ohio" - unless you include Cincy, I suppose. --JaGatalk 15:09, 7 October 2009 (UTC)

Monthly disambig list

So, I did a test run to make sure my new script is working correctly, and I got this: User:R'n'B/Wikipedia:Disambiguation pages with links/October 2009. It lists the top 500 pages from your tool as of October 14, but with the link counts as of October 15 (so there are a few stray cats and dogs near the bottom of the list). [Incidentally, in case you are interested, I am now keeping all the daily link counts in a user database on the Toolserver.] Is this how you think I should generate the monthly list, apart from the day of the month of course? Also, what would you do if (heaven forbid) the Toolserver was down on the last day of the month? I've assumed that you would use the top 500 from the last day for which data is available, but maybe that's not right? --R'n'B (call me Russ) 21:42, 15 October 2009 (UTC)

  • Yeah, the script just grabs the top 500 from the table that's created when the daily disambig update runs, so it'd just get the latest available. I could run the dab update just before I make the monthly list, but then we'd get those oddballs I was talking about earlier.
  • You could use the link counts from October 14 as well, just so the list wouldn't look weird. That way, instead of everyone asking "Why is this article with only 4 links in the list???", they'd just discover the occasional dab that had already been finished, which is already quite common.
  • I didn't know you had a Toolserver account! Those aren't easy to come by. I'm amazed with the things you've been doing with the data - none of it ever occurred to me! Checking TDD is a highlight of lunch for me these days, and it's fantastic to be able to chart our progress. I look forward to 100-DPL and up Zero Day. --JaGatalk 21:59, 15 October 2009 (UTC)

Coin

FYI, I cannot see why Coin is on your list of dab pages with incoming links; it isn't a dab page now and doesn't seem to have been one recently. --Una Smith (talk) 03:10, 16 October 2009 (UTC)

Oct 15 edit. --JaGatalk 06:54, 16 October 2009 (UTC)
Doh. --Una Smith (talk) 13:55, 16 October 2009 (UTC)

Maltese nobility

Hi. You left this message on maltese nobility "This article may require cleanup to meet Wikipedia's quality standards. Please improve this article if you can. (October 2009)." - How can I help? Mobile historian (talk) 20:46, 28 October 2009 (UTC)

Hi! Thanks for the offer. I would expect the article Maltese nobility to be about the history of nobility, different titles, etc. (for instance, see French nobility or German nobility), and then the information about individuals to be split into other list articles (such as all the articles in Category:Lists of French nobility). As it stands, the article is much, much too long. And all the different tables makes the table of contents downright intimidating. I'd start with removing content into sub-articles and go from there. It would also be good to split some of the long text sections into sub-sections to improve readability (see Wikipedia:Layout and Wikipedia:Headings). Let me know if you have questions! --JaGatalk 21:28, 28 October 2009 (UTC)

The article is not about Nobility in general but about the Maltese Nobility, what it is made of, the different titles, how they were created, amended and succeeded, the laws etc. A consensus was reached in 2006 to merge all the articles on Maltese Nobility because some people thought them too repetitive, so it is a tough call to shorten the article. We cannot compare Maltese nobility to French nobility or German nobility, or Italian Nobility because of the conclusions of the British-appointed Royal Commission. Unlike other European nobilities, all locally-created Maltese titles and successions, and foreign registrations are recorded and copies of those grants and relative documentation are easily available from the National Library of Malta. The references are noted down individually in the article and all this raw data is also backed up by reliable third-party publications.

Some of that published raw data was not picked up by the Commission. To complicate matters further, while the Royal Commission allowed some fiefs and unregistered foreign titles to form part of the Maltese Nobility on the basis of a direct recognition, it disallowed some recognised foreign titles and it even overlooked some locally-created titles! To make matters worse, a later committee made some retroactive changes and now the Republican government has not abolished the nobility but only "withdrawn recognition", meaning that the titles are still alive. There are different rules for fiefs and titles, and most of the titles have their own peculiar history and the grants were never streamlined into a uniform mode of succession. Added to this is that the foreign titles remained subject to the laws of the sending country. In terms of the Grand Masters' legislation, even some of the cadet male lines were considered to be forming part of the nobility. All these issues are highlighted objectively but to do so requires some explanation. Special attention was made to state facts and documented I will try split the long text sections into sub-sections, but will that not make the table of contents even longer? Mobile historian (talk) 11:36, 29 October 2009 (UTC)

Long is OK for a TOC; having a TOC that stretches across the page is not OK. Table names should not be the titles of sections. And the tables should be put into proper wiki tables (Help:Table), if they must be kept. But you should think about cutting down the size of the article, if you aren't allowed to move content out; it's just a matter of time until someone decides to revert your work to a cleaner-looking version, such as this one. --JaGatalk 17:15, 29 October 2009 (UTC)
Oh, and there really should be a lead section before the TOC - check out the Layout link above. I would put the photo above the TOC as well. --JaGatalk 17:17, 29 October 2009 (UTC)

Lol, you're really hard on this  :)) !! I'm cutting it down to something much shorter, but I think I will still need to create a stub. How do I do that please? I'm also having problems formatting the tables Mobile historian (talk) 19:10, 30 October 2009 (UTC)

Hi again. I really tried hard over the weekend, but as soon as I put it up, someone else reverted it. Can you please help? Thank you. Mobile historian (talk) 19:14, 3 November 2009 (UTC)

  • Hey, you're OK - it was a mistaken revert by a bot - someone else, uh, reverted the reversion. Great work by the way! It looks a LOT better - I think your work will be safe. --JaGatalk 20:08, 3 November 2009 (UTC)


Thank you for all your help! Mobile historian (talk) 11:17, 5 November 2009 (UTC)

Feeling kind of bad

I think next month I'm going to take it easy on the DAB challenge. It should be fun, not domination :) --User:Woohookitty Disamming fool! 04:21, 31 October 2009 (UTC)

  • Bah, humbug! That's like asking Babe Ruth to hit less home runs to give the other fellas a chance. :) The project is moving forward at the rate of awesome, much of it due to your efforts. All the same, 9000+ is a LOT of edits, so I would understand if you need a break of sorts - I'm (probably? possibly? I have to move this month) going to cut back myself - looks like November will belong to J04n. But I'm 100% positive no one will resent if you continue to amaze. --JaGatalk 09:51, 31 October 2009 (UTC)

Thanks

Thanks for all your help at Ohio Mayor's Courts! Much appreciated, Neutralitytalk 09:05, 1 November 2009 (UTC)

No problem! I did a couple of counties, and then realized I could do the counties with a spreadsheet, and then realized I could do the towns with a more complicated spreadsheet, and the OCD did the rest... --JaGatalk 16:06, 2 November 2009 (UTC)

DAB Challenge list

So, I see that Babyface is on my list, but not on yours. Babyface (disambiguation) was on the October 31 list, but later the page was moved to the primary title. I guess it fell off your list when it changed from being a disambig to being a redirect; however, if the redirect is to another disambig page, it really should stay on. Just a thought. --R'n'B (call me Russ) 18:50, 4 November 2009 (UTC)

Yeah, I was piqued to see the #1 disambig fall off my list. I agree with what you're saying, but it would be pretty complicated to implement. Or at least, I don't know how I'd do it, so it seems complicated to me. :D --JaGatalk 22:30, 4 November 2009 (UTC)

Hi JaGa!

If I want to work on disambiguation pages with a number links below those on the top 500 list, I can scroll through the "Disambiguation Pages With Links" report to find them. However, this is time-consuming and inefficient.

So is there any way for you to add a search box where the number of links can be searched for? Or a range of numbers? For example, if I want to see a list of all disamb pages with 45 links, I could enter "45" to display the list.

I would like to do this because I find it far more satisfying to work on pages that are NOT on the monthly top-500 list. I have a better chance of working on pages covering subjects that I actually know something about!

Best Regards, and keep up the good work! -- Biglovinb (talk) 19:01, 6 November 2009 (UTC)

Great! I look forward to it. -- Biglovinb (talk) 19:08, 9 November 2009 (UTC)

Heads up regarding your Orphaned images tool on the toolserver

Hi,

Noticed that a lot of images are showing up on the result that are in fact used via an image redirect, take File:Cyclone Larry damage in Edmonton 3.jpg for example your tool reported it as orphanded, but if you look at it's link page, you'll see that it's used via it's redirect File:115802075 71c36b15ed o.jpg. These unfortunately don't show up as direct "file links", so you probably need to look for "image links" under the general links table (sorry not quite sure how the database layout works) instead to get a true list of unused images. --Sherool (talk) 17:51, 21 November 2009 (UTC)

Thanks for the heads up. The image scripts are badly in need of an overhaul; I'm hoping to get to them next month. --JaGatalk 19:22, 21 November 2009 (UTC)
Done. The redirect issue is taken care of. --JaGatalk 05:56, 8 December 2009 (UTC)

Wikipedia:Articles for deletion/Toby McFarlan Pond

I "voted" weak keep, based on what I've found. Can you comment? Bearian (talk) 19:13, 5 December 2009 (UTC)

Deletion Issue

Dear JaGa, I would like to suggest that when you're nominating files for deletion you provide objective reasons based on clearly listed Wikipedia policy documentation, as opposed to clearly subjective value judgements, (such as "Worthless image. Makes me wish there was a speedy for "obvious junk"" as per the comment you gave when nominating this file). Whilst the example I gave was of a unencyclopedic image, the fact is that its almost irrelevant whether or not it was as comments like that not only betray an underlying bias on your behalf, but undermines the necessity for images like that to be deleted in the first place. Your judgement is neither infallible nor inscrutable, unlike and in contrast to actual objective Wikipedia policy guidelines. What you think of an image is absolutely meaningless in terms of file deletion, and I am sure that if you are consistently failing to provide real reasons for deletion, you will eventually make a error based on your taste that will result in something of value being deleted.--P.Marlow (talk) 19:56, 6 December 2009 (UTC)

Chill out, dude. If I'm wrong, people will point out my mistake. You think it'll get deleted just because I called it junk? I was hoping someone would say, "oh, there is a way, you just overlooked it, here you go". --JaGatalk 00:08, 7 December 2009 (UTC)
Yeah, my apologizes, the image in question was one that was genuinely in need of deletion. I had confused it with something else, as a thread on the deletion discussion page pointed out, so my rant at you was unjustified. Sorry for bothering you, P.Marlow (talk) 14:33, 24 December 2009 (UTC)
No problem. If I'd realized the misunderstanding from the beginning, I wouldn't have left the snarky message above, which feels pretty cringe-worthy now. I'm relieved you aren't angry about it. Thanks much for the message. --JaGatalk 08:07, 27 December 2009 (UTC)

Preacher.jpg

HI JaGa. User:Nicknack009 is no longer active, so I've taken the liberty to add the image to two articles myself (Preacher (Comics) and List of characters in Preacher). Regards, Cavila (talk) 08:45, 8 December 2009 (UTC).

Cool. Thanks. --JaGatalk 14:50, 8 December 2009 (UTC)

Re:Deletion of the RX-93 Nu Gundam image

Actually, the message left above your for the exact some thing :) I've got the info I need, so go ahead and axe it. TomStar81 (Talk) 17:40, 8 December 2009 (UTC)

Re:Orphaned non-free image File:Wthi-tv.png

You added a message on my main account (Evice) mentioning deleting Wthitv.png. You can delete it, because the image is outdated (the station it's for uses a different logo now). By the way, this is Evice on a college computer. --GastonRabbit (talk) 23:49, 10 December 2009 (UTC)

Thanks for the message, Evice. --JaGatalk 00:01, 11 December 2009 (UTC)

Re: Orphaned non-free image File:Ira brazilian band.jpg

I have my doubts about the legality of the supposedly free image on commons [1] - it looks like a scan from a book or magazine, yet the uploader claims it as his own work. The band has split up which means getting new/free photographs of them will be impossible. Still, I'm not supposed to replace the image that's currently on WP with the "free" one from commons. Do you have any suggestions on how to proceed in this case? XXX antiuser 06:12, 11 December 2009 (UTC)

  • I agree completely - there's no way that's a free image. The thing to do is to bring the image into Wikipedia with a fair use rationale, but we should be able to describe the source of the image. I'm going to poke around and see if I can find it. --JaGatalk 11:48, 11 December 2009 (UTC)
    • Found it! The image can be attributed to here. (You have to click on IRA! then fotos.) --JaGatalk 13:35, 11 December 2009 (UTC)
      • Thanks. I've gone and replaced the image in the article with the old one, since at least that one has a proper fair use rationale, as it's a low resolution version of the image that was provided by their management company for use by the media. XXX antiuser 00:54, 12 December 2009 (UTC)
        • Shrug You could've done that in the first place and saved me the trouble of finding the attribution for that other image. But oh well, all's well that ends well. --JaGatalk 06:49, 12 December 2009 (UTC)

Response to Orphaned images tags

Hi JaGa,

You placed the following tags on my talk page regarding several images that seem to be orphaned and are to be deleted, I guess;

  • Orphaned non-free image File:KresoK.jpg
  • Orphaned non-free image File:Odjava.jpg
  • Orphaned non-free image File:Show Introduction.jpg
  • Orphaned non-free image File:SegmentCredits.jpg

These images are included in article that had been deleted at an AfD and was placed into my user space (userfied by admin) to keep working on. The article in question is at http://wiki.riteme.site/wiki/User:Turqoise127/Kresimir_Chris_Kunej I was under the impression that such userfications allowed for images to remain in article. Please advise if I need to do something or if this is ok. Turqoise127 (talk) 16:59, 14 December 2009 (UTC)

File housekeeping

Those images would better tagged with {{db-f2}}. Thanks, MrKIA11 (talk) 17:01, 14 December 2009 (UTC)

It's a challenge keeping up with you. Ha. Many more and someone might think we're bots. MrKIA11 (talk) 22:18, 14 December 2009 (UTC)
Ha! I was wondering if you had some nifty admin-y tool to clear them out so quickly. I'm a toolserver writer, and I whipped up a script to identify orphaned images with EN pages yet hosted on Commons. So I'll be going through these from time to time. Your db-f2 suggestion inspired me to put this together, BTW, so thanks for that. --JaGatalk 23:02, 14 December 2009 (UTC)
No, unfortunately no nifty tool, just a bunch of tabs. :) MrKIA11 (talk) 23:18, 14 December 2009 (UTC)
I just took a look at your tool, expecting to see just the code, but it actually has an interface. If you want, I can just go through that myself, instead of you tagging them and them me deleting them. That also clogs up CSD, if I wasn't deleting them right away. It might take a while to go through over 3600, but if you leave the tool, it should be done within a week. MrKIA11 (talk) 23:21, 14 December 2009 (UTC)
Hey, yeah, that'd be fantastic! No problem leaving the tool in place. Should I also plod away on them, or just leave it to you? --JaGatalk 00:36, 15 December 2009 (UTC)
I have no problem doing them myself, but if you want it done quicker, you might let other admins know about the tool. Tagging the pages (especially with Twinkle) seems to be causing some backlash ↓↓ MrKIA11 (talk) 16:27, 15 December 2009 (UTC)
Sounds good. How would I find these possibly-interested admins? (and yeah, I'm holding off on Twinkle-ing it for now.) --JaGatalk 17:49, 16 December 2009 (UTC)

I went to go delete some more of those orphaned images, but I got this error: 

Database error:

Table 'u_jason.image_orphans' doesn't exist

Is something wrong, or have they all been deleted in the time I've been gone? Thanks, MrKIA11 (talk) 15:55, 19 January 2010 (UTC)

Heya! Yeah, there's a problem on the Toolserver, where all my reports run. They've done an "upgrade", and for some reason now several of the database tables my reports depend on have been deleted. I've started a support request at the Toolserver to try to understand what's happened and if recovery is possible. I'll drop a note here when it's all sorted. --JaGatalk 16:23, 19 January 2010 (UTC)

bogus speedy deletion notices

You placed four notices of proposed speedy deletion on my talk page for images that, so far as I can see, have nothing at all to do with me, and which appear not to have been, in fact, proposed for speedy deletion. You might want to try to determine who, if anyone, should have gotten such notice, and/or if there is any issue with these images. Cheers! Mwanner | Talk 01:33, 15 December 2009 (UTC)

Confusing talk page message

In consideration of users who are less experienced and knowledgeable than I, can you please try to be more careful with your use of talk page templages? This message is entirely confusing, as following the link takes me to a completely normal image page for an image hosted on commons, with no obvious deletion notices or even a history of notices. I'm clueful enough to navigate to Special:Log and see that there must have been a dead image page there on EnWP, but other people are not so experienced and would probably be left concerned that there was an impending deletion of some media they contributed. In cases where there is just a useless dead image page on enwp for an image on commons there is probably no reason to notify the uploader, but at a minimum any such notification should be clear and not just a vague boilerplate. Cheers. --Gmaxwell (talk) 16:14, 15 December 2009 (UTC)

It's put there automatically by the csd tab. There doesn't seem to be a way to disable it. --JaGatalk 17:31, 15 December 2009 (UTC)
It is only possible if you import the script manually, rather than using it as a gadget. But it is generally a good thing to leave, the exception being mass nominations of pages created be the same person. MrKIA11 (talk) 19:09, 15 December 2009 (UTC)

Toolserver downtime

There was a brief Toolserver outage this morning, and your daily disambiguation page script didn't run. You might want to run in manually. Cheers! --R'n'B (call me Russ) 14:29, 16 December 2009 (UTC)

Better redirect

Thanks for the improvement on my disamb on street gang. I did not recognize that option and agree it is better. I learn something new every day here. Baccyak4H (Yak!) 19:44, 21 December 2009 (UTC)

My pleasure. Thanks for the note! --JaGatalk 03:08, 22 December 2009 (UTC)

Happy Holidays

} You too, JO4n. Hope to see you around. --JaGatalk 08:09, 27 December 2009 (UTC)

Help!

Hi JaGa,

I have been using the new option to enter number of links on the disambiguation list, and it has been working great! I came across the page "Central High School", which lists numerous high schools with the same name. The standard long list of identical names for different locations.

User:Stallions2010 recently changed "Central High School (Keller, Texas)" to "Central High School (Fort Worth, Texas)". This change included a REDIRECT. His summary basically says that the school is located in Fort Worth, not Keller, and that it "just makes sense" to make the change. Well, I did some research and found that Keller is a suburb of Fort Worth, but it is also a separate city with its own school district. The school's website [2] specifically says it is in Keller, and so does its listing on the Keller School District website [3].

My problem is that his change has created a new page for a school that does not exist (the Fort Worth one). I want to remove the REDIRECT, delete the Fort Worth school's page, and restore the Keller school's page. His contributions page lists the entire process he went through.

I honestly don't know what the procedure is for this. I have never done a Revert or Undo where there was a REDIRECT involved. The Undo option seems a little too simple in this case, and I don't want to mess things up. I looked in the Help section for directions, but it's very difficult to find stuff in there.

Can you either do the changes so that I can see how to do it, or refer me to the correct procedure so I can do it myself?

After the changes are done, I'll edit the "Central High School" page to show the proper listing in Keller. I will also add a note that it is a suburb of Fort Worth. Hopefully that will make things accurate.

Thanks in advance for your help! -- Biglovinb (talk) 09:54, 30 December 2009 (UTC)

WP:RFD is where you get a redirect deleted Josh Parris 02:25, 31 December 2009 (UTC)
  • Heya, happy new year! Sorry I didn't get to this sooner - I've been on a nice long holiday break. I'm going to request the Central High School (Keller, Texas) redirect be deleted so I can move the Fort Worth one back into the proper place. The move would convert the Fort Worth article into a redirect to Keller, but that is probably a good thing since there's obviously confusion about its location. I'll use a G6 speedy delete and see if that does the trick. --JaGatalk 06:11, 5 January 2010 (UTC)

New ToolServer report

I've a suggestion for a new ToolServer report: Most viewed disambiguation pages, modeled on http://stats.grok.se/ (except I'm just after an aggregate number, not a pretty graph) -- I'd love to know what pages were attracting the most traffic, as that implies that the incoming links have a greater need to be stomped than the dab page with the most incoming links. I don't know what kind of window you'd use for the query, 24hrs, 1 week or a month. Josh Parris 02:25, 31 December 2009 (UTC)

  • Hi Josh, I'd like to help, but I've really no idea how to put it together. It's great to see how you're moving the project forward though. --JaGatalk 06:19, 5 January 2010 (UTC)

From reading the data model, page.page_counter ought to be sampled periodically (daily for example) and recorded; the difference between samples is the number of page views in that time period. Your current reports run daily against all dab pages, don't they? And toolserver gives you your own private database to store stuff in, so in the same cron job as the regenerating the disambig report, grab the page_counter values for each dab page from the replicated database and store them in your private database. Josh Parris 03:42, 7 January 2010 (UTC)

Josh, I have some ideas how to do this, on an episodic basis. However, if you examine page view stats before and after all incoming links are fixed, you will see that in many cases the page view stats do not change much. Ergo, the page views are from Wikipedia's search box, or linking in from outside Wikipedia. Related to this phenomenon, there are requested move discussions right now on Talk:Lincoln and Talk:EA. --Una Smith (talk) 04:56, 7 January 2010 (UTC)
Una, even if that is the case (which is counter-intuitive, but I'll take your word for it) a central location of the most viewed dab pages would inform the priority for disambig-cleanup tagging. Josh Parris 23:23, 9 January 2010 (UTC)
For reference, the page.page_counter column isn't populated on enwiki, so this technique doesn't work. Darn. Josh Parris 22:57, 7 February 2010 (UTC)

Is this new?

Looks like I got credit on the scoreboard for making Intel a redirect to Intel Corporation instead of to Intel (disambiguation). Is that new? I don't remember getting credit for those before. :) It's how I'm somehow at almost 3000 already. I'm not THAT good. :) --User:Woohookitty Disamming fool! 05:29, 2 January 2010 (UTC)

No, you just lucked out :D - changing a redirect to point away from a dab has always been an option for big points - similar to how you can get a ton of points for fixing a template. Happy new year BTW! --JaGatalk 06:21, 5 January 2010 (UTC)

Addbot orphan tagging tasks

I have started a review ofAddbots orphan tagging tasks to see what people want, Please see Wikipedia:Bots/Requests_for_approval/Addbot_22 ·Add§hore· Talk To Me! 17:30, 9 January 2010 (UTC)

This hasn't updated in 45+ hours. Looks like something is gumming up the works. Thought you should know. Ulric1313 (talk) 05:36, 13 January 2010 (UTC)

Yeah, all my scripts are broken right now :(. I'm concerned my databases on the toolserver have been deleted (again). Or maybe they're only moving things around. Thanks for the note. --JaGatalk 05:46, 13 January 2010 (UTC)
Waaaaaaaaaaaaaaaaaaaaaaah. :) --User:Woohookitty Disamming fool! 09:18, 14 January 2010 (UTC)
:) I know how you feel. Looks like the data is actually there, but the updates are broken. So that's much better. Just gotta figure out why none of the updates are working. --JaGatalk 00:40, 16 January 2010 (UTC)

Suggestion, placing "Last Updated at HH:MM Month Day, Year" to the top (or bottom) of the Short leaderboard?  Guy M | Talk  21:56, 16 January 2010 (UTC)

Good idea. Won't be able to get to that immediately, but it's a good idea. --JaGatalk 00:28, 17 January 2010 (UTC)

Hi JaGa, I am new to DAB challenge. I noticed that the leaderboard is'nt updating, I am sure you know that already. I just wanted to ask if the edits done now still be tallied once the leaderboard is fixed. Thanks--Theo10011 (talk) 16:32, 22 January 2010 (UTC)

I can't say for certain, but I expect the leaderboard to properly count fixes once this is cleared up. Some of the tables and procedures in my Toolserver schema have been deleted, and it depends on what's gone. The fact that the leaderboard still exists is encouraging. I'm just hoping to have this fixed before the end of the month! --JaGatalk 17:53, 23 January 2010 (UTC)
I'm really sorry about this, but it turns out I was wrong. The tables that account for the state of disambigs as of Jan 1 have been deleted (I have no idea why and the Toolserver people aren't being very helpful), making it impossible to update even if other problems are resolved. It looks like January is a wash; we'll just have to wait for the new contest in February. --JaGatalk 11:49, 29 January 2010 (UTC)

Uncategorized articles

Quick question: a number of articles that are listed as uncategorized by your toolserver for uncategorized pages are actually in the hidden category Category:Redirects to Wiktionary. Is there a way to exclude those? The category isn't directly applied to articles, but is transcluded by the {{wi}} template — perhaps add that template as something that the toolserver should skip? Bearcat (talk) 07:39, 3 February 2010 (UTC)

That should be doable. I'll try to get it in within the next week. --JaGatalk 09:23, 3 February 2010 (UTC)
Done. Sorry for the delay. --JaGatalk 10:24, 20 February 2010 (UTC)
No worries. Looks like it worked; I didn't comprehensively go through the entire list or anything, but one of the first bunches of items on the list used to be a set of Wiktionary redirects from word suffixes (-est, -ing, that kind of thing) and they're all gone. Thanks! Bearcat (talk) 04:16, 21 February 2010 (UTC)

DAB challenge

Hi JaGa, I just wanted to point out the current leaderboard. There seems to be some problem, its stopped updating sometime yesterday and now its all wrong. the top positions have changed as well and the number of edits, it went from edits in 1000s to barely 100s by the top leaders. Please can you look into it. Thanks for all your help.--Theo10011 (talk) 15:01, 7 February 2010 (UTC)

Look like its regenerating daily instead of from 2/1. --User:Woohookitty Disamming fool! 19:54, 7 February 2010 (UTC)
Yeah. The data is still there, but the join isn't picking everything up any more. I'll look into it. Toolserver's giving me fits these days. --JaGatalk 20:49, 7 February 2010 (UTC)

Localization of some of your tools for Wiki-pt

Hi! We were wondering at wiki-pt if you would be interested in adapting some of your tools (or all of them, if you feel inclined to do that) in order for them to work in another language version of Wikipedia, namely the portuguese one? We are interested in particular with your DAB pages tools. Thank you in advance for any reply. GoEThe (talk) 17:26, 12 February 2010 (UTC)

Hi, thanks for the interest. Due to some Toolserver changes, I first have to overhaul all of my En-wiki tools - half of them aren't working at present. Maybe later? --JaGatalk 10:25, 20 February 2010 (UTC)

Hello Jason -- I am trying to develop a bot that can count the number of links in the "What links here" page of any article (not just DAB pages). Is there some way that I could get the source for the Disambiguation link count script so that I can modify it to do so? Thanks -- Jrtayloriv (talk) 21:26, 18 February 2010 (UTC)

Sure, send me an email and I'll get it for you. --JaGatalk 10:26, 20 February 2010 (UTC)

Wikiout

ManishEarthTalk • Stalk 05:17, 27 February 2010 (UTC) 

explain
select
	page_title, 
	page_len/count(pl_title) as bytes_per_link, 
	page_len/sum(length(pl_title)+4) as text_to_link_ratio, 
	count(pl_title) as links 
from page, categorylinks, pagelinks 
where cl_from=page_id 
and cl_to="All_disambiguation_pages" 
and pl_from=page_id
and page_namespace=0 
and not exists (select 1 from templatelinks where tl_from=page_id and tl_namespace=10 and tl_title='Short_pages_monitor')
group by page_title
order by bytes_per_link desc, links desc
;

Needs to be run periodically, and sortable; basic effect is to supply pages that are suspiciously large. An enhancement would be to run it through a bot that pulls the actual page down and strips comments out before calculating these metrics. Josh Parris 10:57, 7 March 2010 (UTC)

Retrieved from "https://wiki.riteme.site/w/index.php?title=User_talk:JaGa/Archive_5&oldid=1235154487"