User talk:RobertG

From Wikipedia, the free encyclopedia

Contents 1 Visiting the UK 2 Redirect-fodder for RobotG 3 ip address blocked 4 Thanks and... 5 MariahPicture 6 vandalism-like page move 7 Article name change 8 Donald Bradman 9 Bradman average 10 American Civil War categories 11 Category:Celebrity gamers ... it's baaaack! 12 my subpage 13 Your imput, puh-leeze 14 Over-agressive bot 15 Request for assistance 16 Category:Footballers who died before retiring 17 Questions from Thugchildz (talk • contribs) 18 Crocker (sport) ? 19 Bold category action! 20 Roman Catholic crime families 21 baseball all-star categories 22 Crime families vs Criminal families 23 Historic Landmark Categories 24 Flight Instructor 25 Edit summary on Trombone

[edit] Visiting the UK

P.S.: We are likely going to be in Durham and environs for a couple of weeks in July, for a conference my wife is attending. I'd be glad for any thoughts on what to look for (and look out for); we have never been to that part of the country but are very excited, and I'm afraid we may bite off more than we can chew as far as sight-seeing goes. There are day-trips built into the conference to the Western Isles and a couple of other places (incl. Edinburgh, I believe), for example, but since those are all "scripted" by the conference folks I don't worry so much about them. But I am a long-time Swallows & Amazons fan and hope to take my family to Coniston to see that area...but am not certain of how easy it will be to get there from Durham, or of how crowded it might be at that time of year. Etc. We are obviously a long way away from the departure but I figure it never hurts to think ahead a little. Hoping to stay in touch on this. Merci! --Wspencer11 (talk to me...) 13:44, 8 November 2006 (UTC)

[edit] Redirect-fodder for RobotG

I've left a comment at your toolserver request (I mention this in case your check meta: about as often as I do, i.e., not very). In short, I think the toolserver will be very little use until such time as they get replication of this database up and running, but in the meantime, you may be able to work with the database dump, or I'd be willing to help do so on your behalf. Alai 22:57, 8 November 2006 (UTC)

The dumps are freely accessible at http://download.wikipedia.org. I haven't seen much of an explanation or an entity model, but the definitions of the tables needed for this are:

CREATE TABLE `page` (
  `page_id` int(8) unsigned NOT NULL auto_increment,
  `page_namespace` int(11) NOT NULL default '0',
  `page_title` varchar(255) binary NOT NULL default ,
  `page_restrictions` tinyblob NOT NULL,
  `page_counter` bigint(20) unsigned NOT NULL default '0',
  `page_is_redirect` tinyint(1) unsigned NOT NULL default '0',
  `page_is_new` tinyint(1) unsigned NOT NULL default '0',
  `page_random` double unsigned NOT NULL default '0',
  `page_touched` varchar(14) binary NOT NULL default ,
  `page_latest` int(8) unsigned NOT NULL default '0',
  `page_len` int(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`page_id`),
  UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
  KEY `page_random` (`page_random`),
  KEY `page_len` (`page_len`));

and:

CREATE TABLE `categorylinks` (
  `cl_from` int(8) unsigned NOT NULL default '0',
  `cl_to` varchar(255) binary NOT NULL default ,
  `cl_sortkey` varchar(86) binary NOT NULL default ,
  `cl_timestamp` timestamp(14) NOT NULL,
  UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
  KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
  KEY `cl_timestamp` (`cl_to`,`cl_timestamp`));

Let me know what else I can let you know.

The queries I've run are, firstly for the #-style redirects:

 mysql WP3110 --batch -e "create table redirectcat (title varchar(255)); \
  insert redirectcat select page_title from page where page_namespace=14 and page_is_redirect=1; \
  select * from redirectcat" | tail +2 | awk '{print "*{{cl|" $1 "}}"}' | tr '_' ' ' > redirectcat

output: redirectcat

The current (as of 31st October...) article contents thereof:

 mysql WP3110 --batch -e "create table redirect_art_cat (art varchar(255), cat varchar(255)); \
  insert redirect_art_cat select page_title, title from page, redirectcat, categorylinks where page_id=cl_from and title=cl_to; \
  select * from redirect_art_cat" | tail +2 | awk '{print "*[[" $1 "]]", "{{cl|" $2 "}}"}' | tr '_' ' ' > redirect_art_cat

output: redirect_art_cat

I've just noticed that some of the #redirects from categories are cross-namespace, which is a little boggling.

Lastly, the article contents of the categories in WP cat redirects (which seem to have been fixed, already):

 mysql WP3110 --batch -e "create table redirect_WCD_arts (art_id int(8), cat varchar(255));  \
  insert redirect_WCD_arts select cl.cl_from, page_title from page as c, categorylinks as wcd, categorylinks as cl  \
    where cl.cl_to=page_title and c.page_namespace=14 and c.page_id=wcd.cl_from and wcd.cl_to='Wikipedia_category_redirects';  \
  select page_title, cat from redirect_WCD_arts, page where page_namespace=0 and art_id=page_id"  \
    | tail +2 | awk '{print "*[[" $1 "]]", "{{cl|" $2 "}}"}' | tr '_' ' ' > redirect_WCD_arts

output: redirect_WCD_arts

I can rerun these fairly readily after each dump, since I'm already building the page and categorylinks tables for other purposes anyway.

The category redlinks should be fairly easy to obtain too, I'll write and run that a bit later. (That seems much harder to fix automatically though, isn't it?) Alai 18:49, 9 November 2006 (UTC)

Here we are: User:Alai/catredlinks. Obviously being now ten days old, some of them have been bluelinked by now, and some may have been emptied... Alai 01:49, 10 November 2006 (UTC)

You're very welcome. No, I'm just working with the two "current versions" table I mentioned above (and pagelinks, this time, but not regularly so). Specifically that's http://download.wikipedia.org/enwiki/20061031/enwiki-20061031-page.sql.gz and http://download.wikipedia.org/enwiki/20061031/enwiki-20061031-categorylinks.sql.gz. Let me just check I understand the requested tweak correctly: you want the categories on User:Alai/redirect_art_cat, but without the duplication of categories, and the articles?

The cross-namespace redirects do seem pretty broken, so you it might be OK just to remove them. In some cases it might be better to add a link to a "see also" section, in others there may be a related category to "repair" it too. In an ideal world, other editors would get the hint and do that themselves if the bot removes them, but I wouldn't be shocked if some low-level grumble about it.

The "WCD" list is obviously redundant if your 'bot is going to scan all of those categories anyway; I thought you were considering modifying it to use only those with 'signs of habitation'. Tradeoff between extra (bot) work, and extra 'lag' in picking up errors, I suppose. Alai 18:40, 10 November 2006 (UTC)

[edit] ip address blocked

robertg a couple of days ago you blocked wikipedia to a certain ip address for 'persistant vandalism' i would just like to say that the ip was that of a secondary school and that a couple of year 7s found it funny to post certain 'corrections' as they have been dealt with, i would with all due respect, to unblock this ip address. Kind Regards Jamsterlavery —The preceding unsigned comment was added by Jamsterlavery (talk • contribs) 9 November 2006.

[edit] Thanks and...

LOL, remember that time you thought I vandalised my userpage? And then someone actually vandalised your userpage with similar content, and it struck me as funny? Mak (talk) 00:19, 10 November 2006 (UTC)

[edit] MariahPicture

Robert, as the other editors and I have been discussing, i am not in violation with copyright, read our discussion please. Fair use images ARE aloud to be used. AND PLEASE, do not make an assumption as to whether or not I am waisting my time, and others. —The preceding unsigned comment was added by Violinist1 (talk • contribs) 11 November 2006.

It wasn't an assumption, it was an observation. A fair use image must actually be used under the terms of fair use: it is not good enough merely to assert that the use is fair: to do so does waste time. I saw that this image had been removed before, and that you had simply replaced it again in spite of a big comment explaining that fair use images were not likely to be available. I did not realise that you had not had this explained to you; this was a mistake, and I apologise. --RobertG ♬ talk 14:48, 11 November 2006 (UTC)

[edit] vandalism-like page move

Hi

Thanks for the "ancient" mop and bucket job. Could you please help with this new one?: Some normal user "reverted" i.e. circumvented the following admin page move http://en.wikipedia.org/w/index.php?title=Finlandswedes&diff=84847660&oldid=84803373 --Espoo 06:22, 13 November 2006 (UTC)

I had a brief look, and it appears the article is now at Swedish-speaking Finns and has not sustained any obvious collateral damage: I can't see that anything needs doing. Am I overlooking something? --RobertG ♬ talk 15:00, 13 November 2006 (UTC)

Yes, it was fixed again by the same admin; for some strange reason the change didn't appear on my watchlist although the page is on my watchlist, which is why i didn't realise my request for your help was unnecessary. It seems the watchlist doesn't always show page moves? --Espoo 20:26, 13 November 2006 (UTC)

[edit] Article name change

Hi Robert! just to ensure I get this right I thought it best to check with you. I have just noticed that the Milnsbridge article has been incorrectly titled, It is a small village close to me and links from the Huddersfield article, the correct spelling is Milnesbridge. Would this be better followed up as a page name change request, or in view as Milnsbridge (without the 'e') is the local pronunciation and assumed spelling, would it be better as a redirect. That way anyone spelling it incorrectly would be taken to the correct page. I could then follow up and correct the links as required. Richard Harvey 20:57, 14 November 2006 (UTC)

Well! I Think a can of worms may open here :). I used to live, briefly, on Dowker Street, opposite a company called Taylor Valves. Their website shows them to be in Milnesbridge, as do several others in Google. I just went into the local council website and used their visitor car parking search facility. Visitor info Parking the dropdown box in the search shows Milnesbridge. Yet elsewhere their own website also refers to both spellings on the main search facility. I have an old Kirklees street map which shows Milnsbridge plus another which has Milnesbridge. ??? I will follow this up locally before doing anything further on here. Thanks; I think? :) Richard Harvey 10:03, 15 November 2006 (UTC)

[edit] Donald Bradman

What did you mean by "Hussey makes statement as previously cast currently untrue" in your edit summary? Ansell 10:23, 27 November 2006 (UTC)

[edit] Bradman average

While I take your point about duplicating the lists, Hussey's achievement is not yet relevant to the Bradman text, as it specifies batsmen whose careers have ended. --Dweller 11:58, 27 November 2006 (UTC)

Hussey's average appears in the lead of the Bradman article. I suppose we'll now have to edit the lead every time Australia plays a Test ! Tintin (talk) 12:06, 27 November 2006 (UTC)

Let's hope England get him out cheaply a few times! --RobertG ♬ talk 12:10, 27 November 2006 (UTC)

[edit] American Civil War categories

While I applaud and agree with the decision to replace all "State in the Civil War" categories with "State in the American Civil War," (the right decision), this should have been run by the WP:ACW, who monitors Civil War articles and created them using the original format. Nice work and again, the right thing to do, but please keep us in the loop so that we do not continually write new articles using the older cats (as I did this morning). Thanks!! Scott Mingus 16:43, 27 November 2006 (UTC)

RobertG, the bot missed Vermont and Virginia. Please run it for these two states as well to be consistent. Thanks on behalf of the ACW task force. Scott Mingus 19:27, 27 November 2006 (UTC)

[edit] Category:Celebrity gamers ... it's baaaack!

You closed the CfD for this back on 2006-11-02, and now it's back and being repopulated ... see history of Asia Carrera. —72.75.93.131 (talk • contribs) 23:51, 28 November 2006 (UTC)

[edit] my subpage

Dear RobertG, thanks for your edit in my subpage.Sorry for inconvinience. It is a work,just to make list of categories which include Turkey/turkish related articles, to insert some templates them by using bot. Thanks again. regards. Must^TC 05:09, 30 November 2006 (UTC)

[edit] Your imput, puh-leeze

I have started a discussion here about a comment that you added to WP:PROD. I would greatly value your imput on my take on the situation. Cheers. youngamerican (ahoy hoy) 17:02, 30 November 2006 (UTC)

Thanks. My main concern is that Wikipedia is going to grow faster than the number of committed users and non-burnt out admins can handle. Think about how many great users and admins have given up the ghost due to wikistress and whatnot. Regardless, thanks for your prompt reply. Cheers. youngamerican (ahoy hoy) 18:31, 30 November 2006 (UTC)

[edit] Over-agressive bot

When this bot made the edit Bot: Removing Category:Unemotional fictional characters per CFD, see Wikipedia:Categories for deletion/Log/2006 November 23 -- 08:49, December 1, 2006 It looks like it got just a little too agressive. In addition to the change described, it also moved a bunch of categories down. Until I scroll down (using the diff tool in popups)), I thought the bot had deleted all categories and was considering reverting the change. (That is another feature of popups. Reverts are just one click away.) -Will Pittenger 22:23, 1 December 2006 (UTC)

[edit] Request for assistance

User:Mike Selinker asked if I would see if I could find a bot owner willing to help with a "blizzard" of recently closed nominations at WP:UCFD. I've seen you fairly active at WP:CFD, so I thought I would ask : ) - jc37 08:21, 2 December 2006 (UTC)

I'm really sorry, but my bot uses the pywikipedia framework, which tends to group categories together at the bottom of the article, and I have found Wikipedians get very tetchy indeed if this happens! I stick to the article and image namespaces. Sorry I can't oblige. Try one of the other bots at the top of Wikipedia:Categories for discussion/Working? Someone with the dot net framework version 2 installed (I haven't) could probably do it all with the auto Wiki browser. --RobertG ♬ talk 17:34, 2 December 2006 (UTC)

I'll pick one at random and ask : )

Also, I was going through the older CfD pages, and there are quite a few closed discussions at least as far back as Nov. 12th that haven't been "completed". If you have time to check into those : )

Anyway, thanks for the quick response, and I hope you're having a great day : ) - jc37 17:59, 2 December 2006 (UTC)

[edit] Category:Footballers who died before retiring

"Category:Footballers who died before retiring"

I see that it has been decided that the existing category Category:Footballers who died tragically young should be deleted or renamed as above. At present the existing category is still "live". Can I simply move this or do I need to start from scratch? Either way, can you leave the existing category live for a day or two to give me time to deal with it - I will send you a note when it is done.

Various other names were suggested e.g. "Category:Footballers who died during their playing careers" or "Category:Footballers who died while active". I must admit that I prefer the first of these but I'm happy to go alnog with whatever you suggest. Daemonic Kangaroo 17:25, 4 December 2006 (UTC)

[edit] Questions from Thugchildz (talk • contribs)

I don't get why any body gets to edit the Cricket article and only users get to edit the baseball article? there's edits like "it is super gay" on there and still it can be edited by anyone? Why is the baseball article have different standerds? —The preceding unsigned comment was added by Thugchildz (talk • contribs) 6 December 2006.

I think "it is super gay" is vandalism. Isn't it? —The preceding unsigned comment was added by Thugchildz (talk • contribs) 6 December 2006.

I had mini poster with the picture which i scaned. so i dont think self made tag is the one. So can you tell me the tag that would go with that? —The preceding unsigned comment was added by Thugchildz (talk • contribs) 6 December 2006.

ah that person was me on tripod, so can we please get on with it ... —The preceding unsigned comment was added by Thugchildz (talk • contribs) 9 December 2006.

[edit] Crocker (sport) ?

I suspect this article is bogus. It's hard to find out much about it. It could be a cross between cricket and soccer. Whether it has actually ever been played, or is merely a product of someone's fantasy, is hard to determine. Also, congrats on weeding entries by that User:Thugchildz, who is evidently a cricket fancier and has been messing with everything he can find that vaguely has anything to do with cricket. Wahkeenah 09:37, 7 December 2006 (UTC)

• Thanks for your note. I had also run across this [1] so there does seem to be some evidence for its existence. The question is, how many impromptu schoolyard games merit attention here? Although the lack of much information about early baseball and cricket suggests they were given the same non-attention by chroniclers as we are suggesting giving to "crocker". d:) Wahkeenah 09:46, 7 December 2006 (UTC)

[edit] Bold category action!

Thank you for dealing with the American and National League All-Stars categories at WP:CFD. That debate sat for two weeks. Unfortunately, your actions may knock Hank Aaron out of the Wikipedia record books :) . Dr. Submillimeter 13:59, 8 December 2006 (UTC)

FYI, you might want to check what I had to do here. Apologies if fixing the duplicate categories was next on the bot's list and I just jumped the gun! :) —Wknight94 (talk) 16:23, 8 December 2006 (UTC)

[edit] Roman Catholic crime families

The Five Families. Does this change your vote? TonyTheTiger 16:36, 8 December 2006 (UTC)

Actually after further review, I side with you. TonyTheTiger 17:09, 8 December 2006 (UTC)

[edit] baseball all-star categories

Can you please stop the bot and reconsider? This is a very bad decision and didn't get appropriate consideration... the all-star categories by year were very useful. All of the baseball editors except Wknight in the CFD voted to keep, the categorization people were the only ones voting to merge. Also your bot is screwing up with people who went to many all-star games, e.g. [2] so if nothing else that needs to be fixed. --W.marsh 16:45, 8 December 2006 (UTC)

On second thought I guess I can live with it... it's just frustrating how many pages you have to watch like a hawk to have any idea a big change is being considered. At any rate, can you modify the bot so it isn't leaving dozens of the same category in many baseball articles? Thanks. --W.marsh 16:52, 8 December 2006 (UTC)

I just meant that baseball article editors might have some perspective on baseball articles that people who don't really know or care about baseball have... after all the articles aren't being read by categorization enthusiasts, they're being read by baseball fans. Your bot is leaving potentially dozens of copies of the same category in articles... even with AWB that should be easilly enough fixed using Regex. But if the only reply you have is one as snooty as the last one, please don't bother. --W.marsh 17:06, 8 December 2006 (UTC)

Ah, semantics. By "screwing up" I didn't exactly mean "ruining", just uh, "producing a less than perfect result", as in, leaving a bunch of copies of the same category around. --W.marsh 17:12, 8 December 2006 (UTC)

Well I came across wrong too, I just felt it was urgent because the bot was running and reversing such a thing could be very tedius. Anyway I'll see if I can put together an AWB script to do it myself... shouldn't be that hard. --W.marsh 17:22, 8 December 2006 (UTC)

I think AWB removes duplicate categories automatically, doesn't it? I don't think it requires a regex. In fact, I once asked someone why they had removed a category from Lee Smith (baseball) and it turned out AWB had done it without his even realizing (while I didn't realize it was a duplicate to begin with). —Wknight94 (talk) 17:45, 8 December 2006 (UTC)

[edit] Crime families vs Criminal families

Thanks for your previous participation at Wikipedia:Categories_for_deletion/Log/2006_December_8#Category:Crime_family. I would appreciate your comments on the latest conversation. TonyTheTiger 21:01, 9 December 2006 (UTC)

[edit] Historic Landmark Categories

Could you tell me what's going on with the elimination of supposed duplication of categories for historic landmarks? It's a bit confusing. I find that the pages to which these two category links lead are quite different. Just as one example, "Category:Registered Historic Places in Georgia (US state)" contains 35 pages, while the Georgia section of the List of National Historic Landmarks by state (which contains the Georgia portion of the large category "Category:National Historic Landmarks of the United States") contains only 8 pages. The reason for this discrepancy is apparently the fact that (as it says on the National Historic Landmarks category page) "All NHLs are also listed on the National Register of Historic Places, but not all Register properties are NHLs." It looks to me as though Wikipedia has made the decision to eliminate a supposed duplicate category which is not in fact a duplicate at all, but a larger set. I first noticed this on the Fox Theatre (Atlanta) page, from which your robot recently removed the link to Registered Historic Places in Georgia, which is the larger category at the state level. If one or the other is to be eliminated, it ought to be the smaller one, though I don't think either of them can be removed without damaging the usefulness of the site. Whyaduck 06:10, 13 December 2006 (UTC)

OK, thanks. I see what's going on now. Something is still confusing me about the "by state" page that links from the main list of "Category:National Historic Landmarks of the United States", though. In the main list, one of the first things you see is the link to the article on the Ahwahnee Hotel in California, but there is no mention of the Ahwahnee in the California section of the "by state" list. It turns out that lots of things on the main list aren't on the "by state" list. It seems as though the "by state" page would get the same content as the national list, and any article added to the category would automatically end up on both lists. Isn't there any way to get that to happen? Sometimes its useful to have a list by state rather than a national alphabetical list, but that's not really available if the lists don't have the same content. Whyaduck 13:52, 13 December 2006 (UTC)

[edit] Flight Instructor

Flight Instructor is an official government title, and should be capitalized like Professional Engineer. See that article for further info. Please revert your changes. Dhaluza 13:43, 13 December 2006 (UTC)

[edit] Edit summary on Trombone

I think he meant Baritone horn, rather than either of your options... :-) David Underdown 09:36, 14 December 2006 (UTC)