User talk:SQL/Archives/2008/April

From Wikipedia, the free encyclopedia

Contents 1 RfA Thanks 2 Diff 3 ACC tool on the Toolserver 4 Awarding Barnstar 5 Signpost updated for March 31st, 2008. 6 Starry! 7 Re. Sakotis!!!!!!!!!!!!! 8 Ref sections 9 Just passing thru ... 10 Rejection of NFCCBot 11 Something that's been driving me crazy... 12 Wikipedia:Bots/Requests for approval/DyceBot 3 13 Help! I've been thwarted! 14 Re: List of fictional Characters by IQ 15 ACC 16 Nuther Sock Puppet 17 Thanks for the whoot! 18 Thank you 19 NothingBot 20 Still a nutter sock puppet 21 Refs 22 Counts 23 What's up? 24 ACC 25 Bot request (Non-Free Content Compliance Bot) 26 Trial run complete 27 RFA thanks 28 Another sockpuppet of user:Bentedh 29 ACC 30 Comment on ANI 31 ACC 32 Priority: Low - Restore deleted article on userpage 33 Rollback Request 34 Bot down! 35 Blanked pages pull 36 Heads up 37 Signpost updated for April 7th and 14th, 2008. 38 SQLBot2 on irc://chat.freenode.net/wikipedia-en-accounts 39 New Account 40 SxWiki -- Freshmeat 41 Bot 42 User:SQL/Months 43 Bot request 44 IM SORRY 45 Banrstar 46 Add a template to the ACC tool 47 Thoughts 48 Request 49 missing ref tag bot 50 Wikipedia:Bots/Requests_for_approval/BetacommandBot_Task_9 51 Signpost updated for April 21st, 2008. 52 BNRX 53 Star Trek

RfA Thanks

Thanks, WD :) I still think you'd make an excellent administrator. SQL^{Query me!} 04:46, 1 April 2008 (UTC)

Diff

Funny! — Athaenara ✉ 07:46, 1 April 2008 (UTC)

ACC tool on the Toolserver

Hey, Milk's Favorite Cookie and I are having some trouble getting signed up with the tool, and Soxred93 says that you're rewriting it. Can you help us out or let us know when to check back? Thank you. WODUP 22:37, 31 March 2008 (UTC)

I am in the preliminary stages of writing a new tool to accomplish the same task, however, I have no source access to Soxred's project, nor his user databases that I am aware of.... My project is not yet live, nor even nearly functional. Unfortunately, given this, I am unable to assist you, and have to point you back at Soxred93, sorry :( SQL^{Query me!} 04:45, 1 April 2008 (UTC)

As far as an ETA, unfortunately, it's a complicated project, and, one of my co-workers is on vacation right now, leaving me with a greatly increased workload... I don't think I would be able to provide you with an ETA that's anything but a random number right now :( (I'm hoping within the next 30 days? Wild guess, I don't have a lot of time to work on it right now... You can see the demo so far tho at http://tools.wikimedia.de/~sql/acc (requestor interface) and http://tools.wikimedia.de/~sql/acc/acc.php (admin interface) SQL^{Query me!} 04:49, 1 April 2008 (UTC)

Awarding Barnstar

		The Barnstar of Good Humor
		Aprils fools day was a blast. Loads of users lightened up to have good old fashion fun. I want to thank you for taking part in editing this page in particular and even though I may not know you, embrace the same talk pages, or even edit with you in the near future, I'd like to award you this Barnstar for making Wikipedia a fun environment in which to contribute. Until next year. :) SynergeticMaggot (talk) 12:53, 2 April 2008 (UTC)

Signpost updated for March 31st, 2008.

Weekly Delivery

Volume 4, Issue 14	31 March 2008	About the Signpost

Wikimania 2009 to be held in Buenos Aires	Sister Projects Interview: Wikisource
WikiWorld: "Hammerspace"	News and notes: 10M articles, $500k donation, milestones
Dispatches: Featured content overview	WikiProject Report: Australia
Features and admins	Bugs, Repairs, and Internal Operational News
The Report on Lengthy Litigation

Home  |  Archives  |  Newsroom  |  Tip Line  |  Single-Page View	Shortcut : WP:POST

You are receiving this message because you have signed up for the Signpost spamlist. If you wish to stop receiving these messages, simply remove your name from the list. Ralbot (talk) 21:57, 2 April 2008 (UTC)

Starry!

		The da Vinci Barnstar
		Great job on improving the Incubez tool! Will it still be called Incubez? Soxred93 | talk bot 03:45, 3 April 2008 (UTC)

Re. Sakotis!!!!!!!!!!!!!

Hello SQL and thanks for the heads up. I've fixed that now. Regards, Húsönd 11:25, 3 April 2008 (UTC)

Ref sections

Are you re-running this query? Rich Farmbrough, 15:51 3 April 2008 (GMT).

Just passing thru ...

so I figured I'd troll your talk page Yngvarr (c) 23:06, 3 April 2008 (UTC)

Image:Grumpy Old Troll.jpg

Rejection of NFCCBot

Now that the page is unprotected, I don't think it's out of line for me to place that tag, and every word of it is true. Barring an improbably thorough and soul-searching discussion between the BAG and the community, there will not be a consensus to run that bot. If there is, it would almost certainly require a new BRFA and a new page, as there's too much bad blood on that one. It's important to establish the status of that BRFA: the BAG approved it while much of the the community opposed it. The only way the BAG could create even the appearance of a consensus was to mark it accepted and protect the page.

So some of the discussion was on the page itself, before it got protected. The discussion scattered after that, but you can find some of it on Wikipedia:Administrators' noticeboard/Betacommand and Wikipedia talk:Requests for arbitration/Betacommand 2/Proposed decision. I don't see anyone who's interested in restarting that discussion and trying to find a consensus (not since early March, at least), especially since we have better image bots running now.

Frankly, I've seen far less controversial things in Wikipedia space tagged with {{rejected}}.

rspeer / ɹəədsɹ 04:53, 8 April 2008 (UTC)

Oh, that wasn't directed at you, and I'm sorry for the impression that it might have been. Groups within Wikipedia can be seen to hold positions on issues, even when some of their members disagree. I saw you propose to reopen the discussion a month ago, and I commend you for that, but it was clear that you weren't speaking for the BAG at the time. The BAG's effective position was ST47's position, because they upheld his page protection.

As a corollary of this, my objection would be inaccurate if it were aimed at a particular person. It is groups that tend to be warped by self-perpetuating power, even when their members are reasonable. And ST47 doesn't approve bots, the BAG approves bots.

rspeer / ɹəədsɹ 05:34, 8 April 2008 (UTC)

Something that's been driving me crazy...

[1]

"RfAs", not "RfA's". Possession isn't the same as pluralism. :) EVula // talk // ☯ // 03:20, 8 April 2008 (UTC)

Hahaha! :P I need to fix that :) SQL^{Query me!} 14:01, 9 April 2008 (UTC)

Wikipedia:Bots/Requests for approval/DyceBot 3

As you've already commented that you think there's no problem if I run the bot, would you mind issuing approval? At least for a trial run if you think it's necessary?--Dycedarg ж 09:29, 9 April 2008 (UTC)

I'll approve it for trial... SQL^{Query me!} 12:19, 9 April 2008 (UTC)

Help! I've been thwarted!

Hey, as instructed, I need to tell you that SQL has stopped me from running, with an edit summary of test. SQLBot-Hello (talk) 14:00, 9 April 2008 (UTC)

Re: List of fictional Characters by IQ

I may very well be incorrect here, but WP:ARS#Flag an article for rescue says it goes on the main page under the AfD tag. Would you be willing to double check? Mstuczynski (talk) 17:45, 9 April 2008 (UTC)

Oops, I see you're offline. I'm going to put it back for the time being. No offense intended, please correct me if I am wrong. Mstuczynski (talk) 17:59, 9 April 2008 (UTC)

What the wikiproject says or does not say is irrelevant. That sort of wikiproject template does not belong in the mainspace. I put it on the talkpage, where relevant wikiproject tags go. SQL^{Query me!} 20:52, 9 April 2008 (UTC)

ACC

Hey. Could you delete my account again so I can register again? Thank you. WODUP 18:02, 9 April 2008 (UTC)

Sure, I was about to make a 'lost password' thing for ya... Kinda got sidetracked by real work :( I'll delete it in a moment... Try using a just numbers and letters password this time (so we can see if that's what it was) SQL^{Query me!} 20:05, 9 April 2008 (UTC)

Deleted! SQL^{Query me!} 20:06, 9 April 2008 (UTC)

And, I've approved you. Don't forget to set your welcomebot preferences. SQL^{Query me!} 01:14, 10 April 2008 (UTC)

Oh, thank you! It works! WODUP 01:48, 10 April 2008 (UTC)

No problem! :) Glad you got in finally. Musta been the PW, I'll restrict that further. SQL^{Query me!} 01:51, 10 April 2008 (UTC)

Can you approve me as well. (I registered) - Milk's favorite Cookie 01:51, 10 April 2008 (UTC) Never Mind.... - Milk's favorite Cookie 01:52, 10 April 2008 (UTC)

(u)Hehehe, yep :)

Rjd0060 Approved, User 31 (Milk's Favorite Cookie) at April 9, 2008, 12:54 am.

SQL^{Query me!} 02:02, 10 April 2008 (UTC)

Nuther Sock Puppet

User:86.20.160.24 is a sock puppet of User Bentedh. How do I report this guy every time he pops up? Can you take care of this one? --'''I am Asamuel''' (talk) 22:38, 9 April 2008 (UTC)

Y Done. If you like, you can always report clear cases to WP:ANI, or, when I'm around, I don't mind taking care of it. SQL^{Query me!} 01:17, 10 April 2008 (UTC)

Thanks for the whoot!

Your message got lost in the flurry of activity on my talk page. When you reach 10K, I'll teach you the 10K cabal's secret handshake myself. --barneca (talk) 03:20, 10 April 2008 (UTC)

Hehe! Thanks :) SQL^{Query me!} 04:04, 10 April 2008 (UTC)

Hey, if my bots edits count, I'm probably well over 20,000 SQL^{Query me!} 04:05, 10 April 2008 (UTC)

If I take 3 tries to correct my own spelling, and all those count, I don't know why bot edits wouldn't count too. --barneca (talk) 04:18, 10 April 2008 (UTC)

Well then! :) I'm well over 30,000 edits :P SQL SQLBot SQLBot-Hello SXT40 SQL^{Query me!} 04:20, 10 April 2008 (UTC)

I'm not worthy! --barneca (talk) 04:25, 10 April 2008 (UTC)

Thank you

Thank you for your support in this mess. Toddst1 (talk) 05:31, 10 April 2008 (UTC)

No problem. SQL^{Query me!} 05:42, 10 April 2008 (UTC)

NothingBot

I have responded. Nothing444 12:35, 10 April 2008 (UTC)

Still a nutter sock puppet

This IP: 78.151.105.180 (talk · contribs · deleted contribs · page moves · block user · block log) is yet another sock puppet of Bentedh. Thanks for the time. --'''I am Asamuel''' (talk) 18:21, 10 April 2008 (UTC)

Blocked, and, the target page is now locked. Hopefully, he'll get bored and find something else to do... SQL^{Query me!} 18:30, 10 April 2008 (UTC)

Refs

Oh interesting, I ran a regex and got 16000 hits I think it was. They are all fixed up. I also ran the fix-up for some thousands that used Template:TlGR - which was what reminded me. And I changed the dummy data for {{Infobox settlement}} not to include </ref> so that problem is now reduced. All the best. Rich Farmbrough, 20:33 10 April 2008 (GMT).

Hmm, Wow, another 16,000 eh? :) Hopefully there'll be more next month :P SQL^{Query me!} 20:36, 10 April 2008 (UTC)

Counts

I saw your post on Yamla's talk page, and looked at my own editcount using that count tool. I like the way it counts user rights changes and other admin actions too: according to it, I've done over 300 user rights changes! Wow! :) Acalamari 21:00, 10 April 2008 (UTC)

Hah! Wow, 300 rights changes already? So, you've done about 1/4 of all of the rollbackers then! Neat! :) SQL^{Query me!} 21:02, 10 April 2008 (UTC)

I saw your post on Yamla's page too. That thing is waaaay faster than Interiot's! I've put it on my userpage for future reference. bibliomaniac15 Hey you! Stop lazing around and help fix this article instead! 21:03, 10 April 2008 (UTC)

Roughly a quarter of the rollbackers, yes. :) At the moment, I'm the only one who has given more than 100 people rollback, and I am second to Cecropia by number of user rights changes on the entire English Wikipedia (see here). That's a good counter of yours: very fast. :) Acalamari 21:14, 10 April 2008 (UTC)

Hehe, thanks guys :) It's lagged tho, I forget by how much right now (last I looked it was about 4 hrs behind), but, lagged nonetheless :( SQL^{Query me!} 21:33, 10 April 2008 (UTC)

What's up?

Hey -- What's with the incivility, telling MZMcBride to "Get the fuck out" (GTFO, no?), and telling me to go away? Why shouldn't people be able to communicate with you? Collaborative editing is kinda the mechanism used here, ya know? If you're having a vandalism problem, I'd be happy to semi-protect your talkpage for you. SQL^{Query me!} 15:55, 11 April 2008 (UTC)

Because, I don't come here often enough to see the need to have discussions on my talk page, and when I do come here, I don't want to have to worry about why someone is leaving me a message. So I don't want any at all, because I do not care. --Charitwo ^talk 16:09, 11 April 2008 (UTC)

ACC

Whatever happened to this? I ran into it again - Milk's favorite Cookie 01:04, 12 April 2008 (UTC)

Devs haven't done it yet, it seems. I know a bug was filed (and is still open) however. SQL^{Query me!} 01:06, 12 April 2008 (UTC)

Bot request (Non-Free Content Compliance Bot)

Would you be able to respond to this? Thanks. Carcharoth (talk) 02:10, 12 April 2008 (UTC)

Responded, I really feel that that bot's becoming a HUGE waste of time. If I've been curt about it, I'm sorry, but, I'm losing my patience with dealing with so much drama from a bot with 0 edits, that, in my opinion seems like it isn't even ever going to run. I would be tempted to invalidate / withdraw the damn BRFA just to not have to deal with it anymore, at this point. SQL^{Query me!} 02:19, 12 April 2008 (UTC)

Furthermore, 90% of what I was doing today, was maintenance. I hope I'm still allowed to do that, without getting sucked into a RFAR :(. SQL^{Query me!} 02:21, 12 April 2008 (UTC)

Of course you are still allowed to do maintenance. It's not a big problem. I understand that it is was really rather unfortunate that your maintenance happened to coincide with the withdrawal and make it look worse than it is. It is the out-of-process withdrawal that was the problem, and I should have picked up on that earlier. Sorry about that. Carcharoth (talk) 02:31, 12 April 2008 (UTC)

It just seems pointless to me. Put me back in if you like, from my end, it does not matter at all. I'd actually been meaning to remove myself from that for a long time. I can see tho, how that might not look good now... I honestly hadn't thought about all the hubbub around editing that page, at the time, and, I didn't think one less operator would make a big difference. The whole thing's rather frustrating, sorry... SQL^{Query me!} 02:39, 12 April 2008 (UTC)

You putting yourself back in would "revalidate" it (and emphasise how silly it all is, I agree), but there is no way I am doing that. It has to come direct from you or no-one. Carcharoth (talk) 02:51, 12 April 2008 (UTC)

Welp, then invalid it is, in my opinion at least. I still would really have liked to see it re-opened for further discussion as I've said in a buncha places, but, if we're honest with ourselves, at this point that's a waste of everyone's time. Right now, I've simply got too much else going on, projectwise, to operate a bot such as that one, that would consume large amounts of time. On the other hand, I think it's been superseeded (hmm. Firefox AND I can't figure out how to spell that one), by at least three other bots (one, even by it's main operator), if I recall correctly, and, therefore is unlikely ever to run, so, it really wouldn't matter if I re-listed myself. However, I think, it'd be best for all involved, if we just get it put behind us right now. And, the simplest, most logical way I see, to achieve that end, is to remain off it, and accept the eventual invalidation / expiration / consider it a withdrawn brfa. However, that's just my opinion. SQL^{Query me!} 02:58, 12 April 2008 (UTC)

Trial run complete

My bot finished the trial run. Would you mind approving it now?--Dycedarg ж 21:10, 11 April 2008 (UTC)

I'm sorry, but, in all but the simplest of cases (say... interwiki.py, or category.py etc), it's generally a good idea for a different person to approve the bot, from the person that approved the trial. That way there are less crazy accusations, and, more eyes on the potential bot. I will look over the contribs, and comment on it however. SQL^{Query me!} 00:42, 12 April 2008 (UTC)

Two things: First of all, would you mind clarifying how this does not qualify as being one of the simplest types of cases? At least 60 other people besides me use the plugin I'm using, many of which use it in bot mode; Kingbotk alone has over 375,000 edits. Second of all, both my previous bot requests were approved by the same person who approved the trial, weren't even commented on by anyone other than me and the approver let alone more than one BAG member, and were all my original code to boot. Did something change with regards to how BAG members do things? If so, why? If I sound impatient I apologize, but this is really starting to try my patience as this is the longest I've ever had to wait for bot approval, especially considering that this is by far the least controversial and prone to error bot I have ever run. The second bot request was approved within 48 hours, and it was editing in mainspace, not on talk pages. Oh, I'll also point out Wikipedia:Bots/Requests for approval/SoxBot 4, which was virtually the same request as mine is, was approved within 2 hours.--Dycedarg ж 03:40, 12 April 2008 (UTC)

I don't think it's so much as things have changed since then, as it is that I do things differently (for the better, I hope). However, you make a really good point about the AWB plugin. Tell ya what, I'll go do it. :) SQL^{Query me!} 03:44, 12 April 2008 (UTC)

Thank you very much.--Dycedarg ж 03:50, 12 April 2008 (UTC)

RFA thanks

Thanks for your support in my RFA, that didn't quite make it and ended at 120/47/13. There was a ton of great advice there, that I'm going to go on. Maybe someday. If not, there are articles to write! Thanks for your support. Lawrence § t/e 18:06, 12 April 2008 (UTC)

Another sockpuppet of user:Bentedh

User:78.151.105.180 is back from its block, and is vandalizing pages with more of his "Bentedh" nonsense, such as Fabrique Nationale de Herstal, and Ruger P series. He also vandalized Koalorka's, and Asams10's pages.--LWF (talk) 00:52, 13 April 2008 (UTC)

Thanks, for the heads up. I've re-blocked them for a week this time, with anon-only turned off. If they come up again, I'll start protecting the affected articles. SQL^{Query me!} 05:08, 13 April 2008 (UTC)

Yet another one is back. This time it's user:86.20.160.24, and he also got user:Daniel J. Leivick.--LWF (talk) 13:11, 13 April 2008 (UTC)

Got 'em, for a week also. I protected the articles they seem to like to hit for a week as well (semi-protected, at least.) Good work :) SQL^{Query me!} 17:04, 13 April 2008 (UTC)

ACC

Yeah - I ran into it again. There is a huge backlog you may want to take care of. - Milk's favorite Cookie 17:43, 13 April 2008 (UTC)

Comment on ANI

I think you and I have run into a terminology issue about bots. Where in this hierarchy would you say that bot approval becomes necessary?

1. Admin deletes 1000 pages by manually clicking delete and typing summary each time. This definitely does not require bot approval.
2. Admin makes javascript to have a one-click delete tab, which fills in the summary and deletes when clicked. Admin uses that 1000 times.
3. Admin makes a list of pages, each page has a link to click to delete it. Admin goes through and clicks them all. Now it isn't necessary to load each page in a tab first.
4. Admin makes javascript to automate the clicking, so that the admin makes a single list of pages and clicks once.
5. Same as #4, but instead of javascript the admin uses python. Admin makes a list of 1000 pages and runs a script to delete them from the command line.
6. Admin makes a script that watches recent changes and deletes certain types of pages whenever they are created. This definitely requires bot approval.

I can accept if you think that level 4 needs bot approval, although historically we have not required it. I don't see how we can say that level 4 doesn't need approval but level 5 does; they have identical behavior from the point of view of the server, and everyone else but the Admin. The same hierarchy can be applied to edits instead of deletions. In that case, Twinkle essentially includes functionality 4. — Carl (CBM · talk) 14:21, 14 April 2008 (UTC)

I honestly probably (from a personal opinion standpoint) lean more towards level 4 as described. However, how many actions does TW generate per click? I've only really ever used it for pre-admin stuff like reverting, so, my guess is... 1? I'm ok with that. The user carefully, and deliberately chose to perform action X. Not process Y using algorithm N chose to perform action Z or X or Q depending on the output of the regex.

Now, thinking about the 'list' example, I suppose, it would depend on how the list is generated. In the case we're talking about, did the user go, and personally look at 11,000 pages, histories, etc, and add them to a list, or, again, did an automated process use an SQL query, to simply list pages based on a certain criteria, and then, the user's javascript deleter, automatically deleted them. Honestly, that sounds a lot like a bot to me, especially as the only human input to the process, is running the query, then running the script. In order to protect the project, mass-actions that require no real human input, should probably generally be discussed with the community, thoroughly documented, and most likely have source code available.

Let me give you a good example, of how I do it. User:SQL/BRedir, User:SQLBot automatically generates a list of broken redirects every so often via a series of SQL queries, and, I personally review each of them, histories, and whatnot, then I deliberately choose to delete, fix, leave alone, or whatnot. I would not, for instance, run an easy-to-make script, to make that choice for me, without the consent of the community. I hope, this helps :) SQL^{Query me!} 14:45, 14 April 2008 (UTC)

Personally, I am also somewhat troubled by the possibility of someone making a "big mistake". It might be better if I had phrased the bullets above in terms of the volume of edits in addition to the way they're made. I reassure myself that there is little that can actually be done to permanently damage things.

Twinkle has the ability to delete an image and in the same action remove its uses from all articles. It also has the ability to "batch protect" pages, something I have never tried. There are other javascript programs floating around that will, for example, delete all the pages linked from a specified page.

My concern about items 3 and 4 is that there is no more review by the admin in either case. If the admin makes a list of pages and uses procedure 2 at breakneck speed, things are hardly better. This makes me think that the real thing we want to encourage is good decision making. — Carl (CBM · talk) 15:55, 14 April 2008 (UTC)

Indeed, it does come down to that. Interesting about TW as a sidenote, I didn't know it deleted stuff. I mostly just use it to place block notices. SQL^{Query me!} 17:40, 14 April 2008 (UTC)

If I may chime in (saw a link in the BAG channel) I think point 3 would also be considered a bot, as you're making automatic edits and you aren't manually reviewing them. --uǝʌǝsʎʇɹoɟʇs(st47) 17:57, 14 April 2008 (UTC)

I'd be glad to move this discussion to a bot noticeboard if there is more general interest; I just didn't want to do it on ANI where it's so noisy. It's a complex issue to decide which things are "bots", and maybe the bot policy can be clarified somewhat.

For item 3, because the admin manually initiates each edit, and only uses a web browser, I can't see that it's a "bot" in the ordinary sense. It is an assisted editing system, like Wikipedia:Bot_policy#Assisted_editing_guidelines describes, certainly. For example, Twinkle does have a function to unlink all backlinks to a page with a single click, and we don't classify Twinkle as a bot. — Carl (CBM · talk) 18:18, 14 April 2008 (UTC)

In an important sense, all of #1 to #5 are "manually reviewed" in the sense that the editor has made a list of pages through some other means. In the case of edits to article content, we can ask for a person to look at a diff as a sign of manual review, but there is no diff for a deletion. — Carl (CBM · talk) 18:19, 14 April 2008 (UTC)

Wow. Thank you for the notice, CBM. I literally *just noticed* that the entire policy apparently has been completely re-written, and put up as policy. SQL^{Query me!} 18:45, 14 April 2008 (UTC)

ACC

Yep. Click here - Milk's favorite Cookie 20:15, 14 April 2008 (UTC)

Holy... wow... [16:19:03] <SQLBot2> Open requests: 63, Admin requests: 0, Banned: 25, Site users: 14, Site admins: 18, Awaiting approval: 0 SQL^{Query me!} 20:17, 14 April 2008 (UTC)

Would it be "illegal" if I changed my IP and did it. Or rather - would it work? And delete the image ASAP. - Milk's favorite Cookie 20:19, 14 April 2008 (UTC)

(ec)I don't think it would matter in the scheme of things :) BTW -- I deleted that image, as it contained IP's and emails... SQL^{Query me!} 20:21, 14 April 2008 (UTC)

Nope. Won't work. - Milk's favorite Cookie 20:31, 14 April 2008 (UTC)

LP? May I ask you favorite song by them? - MILK'S FAVORITE COOKIE ^(Talk) 02:09, 15 April 2008 (UTC)

Not really sure, I like a lot of the older remixes it'd be impossible to pick just one! :) (Hmm, I forget the name, but... The one with "Mr. Hun"... I love that beat!) I've been more into Audioslave and the like lately :) SQL^{Query me!} 04:08, 15 April 2008 (UTC)

Priority: Low - Restore deleted article on userpage

Hi SQL, could you please restore the EyeOS article on my userpage for clean-up? (G11: Blatant advertising). If possible restore the talk page in my userpage too, as i was not involved with the article and have no idea of what was going on (in case there is any useful info). Iunaw (talk) 09:36, 13 April 2008 (UTC)

Heya! It looks like User:David Gerard has restored it already. [2] SQL^{Query me!} 17:05, 13 April 2008 (UTC)

I've seen it :) It has been restored and improved a lot in just a couple of hours. Thank you for checking it! Iunaw (talk) 14:48, 15 April 2008 (UTC)

Rollback Request

Hi there. I would like to receive the right to Rollback. If you could please review my contributions and then reply with your decision. it would be greatly appreciated.

Thank you, --Aremith ^Talk 04:36, 15 April 2008 (UTC)

Y Done SQL^{Query me!} 05:02, 15 April 2008 (UTC)

Merci Beaucoup. =) --Aremith ^Talk 05:09, 15 April 2008 (UTC)

• Thanks from me too! :) Acalamari 15:41, 15 April 2008 (UTC)

Bot down!

Oh noes! Someone in unblock-en killed meh! SQLBot (talk) 09:30, 16 April 2008 (UTC)

Blanked pages pull

Hi there! Could you, please, fix the formatting on User:SQL/Blanked. I attempted to, but did not realize that the bot would override everything on the next run. Thanks for the great tool, by the way!—Ëzhiki (Igels Hérissonovich Ïzhakoff-Amursky) • (yo?); 22:04, 16 April 2008 (UTC)

It's actually that way because it is transcluded to a table, User:SQL/PlzFix. SQL^{Query me!} 22:45, 16 April 2008 (UTC)

Ah, gotcha. I guess I'll just have to transclude it to a table of my own. Thanks.—Ëzhiki (Igels Hérissonovich Ïzhakoff-Amursky) • (yo?); 00:55, 17 April 2008 (UTC)

Yep, sorry! SQL^{Query me!} 00:57, 17 April 2008 (UTC)

Heads up

[3] - From your only article ;) dihydrogen monoxide (H₂O) 07:40, 17 April 2008 (UTC)

Hehehe! You stoled my peekture! :) Thanks for the notice, consider it deleted! :) SQL^{Query me!} 07:43, 17 April 2008 (UTC)

Signpost updated for April 7th and 14th, 2008.

Sorry, it seems that the bot quit before completing its run last week. Here is the last two weeks' worth of Signpost. Ralbot (talk) 09:06, 17 April 2008 (UTC)

Weekly Delivery

Volume 4, Issue 15	7 April 2008	About the Signpost

April Fools' pranks result in temporary blocks for six admins	WikiWorld: "Apples and oranges"
News and notes: 100 x 5,000, milestones	Wikipedia in the News
Dispatches: Reviewers achieving excellence	Features and admins
Bugs, Repairs, and Internal Operational News	The Report on Lengthy Litigation

Volume 4, Issue 16	14 April 2008	About the Signpost

From the editor
Interview with the team behind one of the 2,000th featured articles	Image placeholders debated
WikiWorld: "Pet skunk"	News and notes: Board meeting, milestones
Wikipedia in the News	Dispatches: Featured article milestone
Features and admins	Bugs, Repairs, and Internal Operational News
The Report on Lengthy Litigation

Home  |  Archives  |  Newsroom  |  Tip Line  |  Single-Page View	Shortcut : WP:POST

You are receiving this message because you have signed up for the Signpost spamlist. If you wish to stop receiving these messages, simply remove your name from the list. Ralbot (talk) 09:06, 17 April 2008 (UTC)

SQLBot2 on irc://chat.freenode.net/wikipedia-en-accounts

Put simply, I kiled it. (Accidentally.) Here's what happened:

<Stwalkerster> !stats
<Stwalkerster> !status
* SQLBot2 has quit (Remote closed the connection)

Please can you reinstate the bot ASAP, an preferably fix the bug? Thanks, Stwalkerster [ talk ] 19:30, 17 April 2008 (UTC)

Yep, it does that when I'm not logged into the toolserver, and, I don't know why :( I'm going to try to fix that in a bit, before I put it back up. SQL^{Query me!} 19:51, 17 April 2008 (UTC)

New Account

I noticed that you created a new account. Is it a sockpuppet or an alternative account?--RyRy5 (talk) 02:27, 18 April 2008 (UTC)

Actually, I just created about 130 accounts. I help out with the Account creation assistance process (as a matter of fact, I designed our present queuing interface. :) SQL^{Query me!} 02:29, 18 April 2008 (UTC)

Tra has a lot of socks ;) Milk’s Favorite Cookie ^(Talk) 02:31, 18 April 2008 (UTC)

Oh, I was just making sure. Thanks.--RyRy5 (talk) 02:32, 18 April 2008 (UTC)

No problem, good to see you're keeping an eye out! :) SQL^{Query me!} 02:49, 18 April 2008 (UTC)

SxWiki -- Freshmeat

Hey,

I've just released a new SxWiki Pro Beta version (0.2), and I announced the Pro branch on Freshmeat. Please let me know if and when you release a new Lite version, so I can announce it as well (in a perfect world you should be able to announce it yourself here, but I'm not sure that's the case). --Gutza ^{T T+} 23:59, 18 April 2008 (UTC)

Hehe, sure. BTW -- you may want to check yours... Recently, the category API was updated, and it broke mine (at least, getting categories broke). SQL^{Query me!} 04:22, 19 April 2008 (UTC)

You mean getCat()? That's one of the reasons for the release... :-) But thanks for the heads-up, anyway! --Gutza ^{T T+} 12:09, 19 April 2008 (UTC)

Bot

You seem really experienced with bots. I was wondering if you can help me out for an automatic one? I have a good idea and there is a script all written. See [4][5][6] of things I want it to do. (That was the script) Can you help? Thanks, Milk’s Favorite Cookie ^(Talk) 00:41, 19 April 2008 (UTC)

Shouldn't be much to do, other than submit a BRFA, if the script's already written :) SQL^{Query me!} 16:13, 19 April 2008 (UTC)

Well - yeah - of course. I'm not experienced with anything perl or python. This is what I need help on. How to get everything started. Milk’s Favorite Cookie ^(Talk) 16:15, 19 April 2008 (UTC)

Me either, unfortunately. py and perl may as well be greek for the most part, to me. SQL^{Query me!} 16:16, 19 April 2008 (UTC)

What exactly do you use? Milk’s Favorite Cookie ^(Talk) 16:17, 19 April 2008 (UTC)

PHP and AWB usually. Been doing AWB a lot more lately, as I have had too much other stuff on my plate to develop any new scripts. SQL^{Query me!} 16:18, 19 April 2008 (UTC)

AWB can't work by itself can it? Can you help me with PHP? Milk’s Favorite Cookie ^(Talk) 16:20, 19 April 2008 (UTC)

AWB can, just needs to be set up for it (load a category, define regexes for what you want changed, and hit start....) As far as PHP, I don't think I'd be up to teaching anyone a large programming language, but, I learned from the manual located at http://php.net ... SQL^{Query me!} 16:25, 19 April 2008 (UTC)

here is the script. Can AWB go through Special:Random and use the script on every page it passes by? Milk’s Favorite Cookie ^(Talk) 16:32, 19 April 2008 (UTC)

User:SQL/Months

Hi,

I have started to slowly fix incoming links to the redirects listed at User:SQL/Months#Redirects, which you generated per this bot request. Links to those redirects contravene WP:MOSDATE, as well as the instructions given at Template:Cite web and Template:Cite news (most incoming links reflect values assigned to "accessdate" parameters of the two templates). I have initiated a deletion nomination of a small number of these redirects here and will proceed with the rest if there is consensus for their deletion.

I'm not sure to what extent you're involved in the centralised discussion, but I thought you might to know (well, actually, B.Wind reminded me...). Cheers, Black Falcon ^(Talk) 03:46, 20 April 2008 (UTC)

Heh, I'm not involved at all... Someone posted a botrequest, and it seemed interesting :) SQL^{Query me!} 04:51, 20 April 2008 (UTC)

Bot request

I see that the table on Wikipedia:Bots/Requests_for_approval lists PseudoBot as being request-expired, even though the request was un-expired. Is this an error or have I misunderstood the process? Pseudomonas_(talk) 16:11, 19 April 2008 (UTC)

Fixed, sorry :) SQL^{Query me!} 16:13, 19 April 2008 (UTC)

Thanks! Trial #2 completed with minimal problems (AFAICT just two cases where ClueBot got there first) Pseudomonas_(talk) 10:47, 21 April 2008 (UTC)

IM SORRY

im sorry --qwerty —Preceding comment was added at 07:17, 23 April 2008 (UTC)

Banrstar

		The Barnstar of Good Humour
		I, Mm40, hereby give you this barn star for your comments while declining an unblock on User talk:Sanjeev450. Keep up the good work. And, how much does an unblock cost? Me what do u want? Your Hancock Please 15:45, 23 April 2008 (UTC)

Heh. Depends on the amount of aggravation it's likely to cause me :) SQL^{Query me!}

Add a template to the ACC tool

Howdy. Could you please add User:WODUP/Welcome as a welcome template on the ACC tool? Thank you. WODUP 08:05, 23 April 2008 (UTC)

Y Done with one minor typo (I had it adding extra }}'s on the end apparently) See: User talk:Aimi bukhari for an example of how it looks :) SQL^{Query me!} 08:24, 23 April 2008 (UTC)

Thanks! By the way and in case you don't have anything better to do :), there's a wicked backlog of requests, 233, and I can't do it; I hit my six-per-day limit with my regular account. :( Otherwise, I left a note on WT:ACC summoning help, and I'll get few more creations tomorrow. WODUP 08:47, 23 April 2008 (UTC)

Oh, wow. I use a bot account, to do as many as I want at a time :) I'll get on them shortly. SQL^{Query me!} 01:57, 24 April 2008 (UTC)

Thoughts

I don't know Maha Pizza (Block log), but he seemed to have erupted to what he felt was misproper administrative action on him after he made some efforts to make contributions. Obviously, his reaction by blanking his user page and replacing it with generic cursing was a disaster but being that he's a very new editor and was not given a chance to accommodate his thinking, I think you should shorten his ban to 1-3 months... I've seen worse behavior get a slap on the wrist and he may mature later on to become constructive. If after 3 months he returns as a bad editor, there's no problem in extending the block. Jaakobou^{Chalk Talk} 14:11, 23 April 2008 (UTC)

AFAIK, he's not banned, merely blocked. You make a good point, and, I'll do just that. You may have missed however, that user joining the Unblock IRC channel, and going off on us there, too. I'm willing to give them another chance, however. I'll move it to a 30d block (from the time of my initial block). SQL^{Query me!} 01:54, 24 April 2008 (UTC)

I think ChrisO should have asked someone else to review the issue rather than directly block someone he's in conflict with on another article (Haven't examined the block itself but ChrisO is a reasonable editor). I might have been really upset also by such a block, though I don't think I'd have reacted the way Maha Pizza did (IRC also eh?). Anyways, I'm not sure he'd even be interested in giving Wikipedia a second try and also not sure he can be productive, but I felt he could be permitted to return (eventually) if he were to choose trying to be constructive.

Thank you for your time, Jaakobou^{Chalk Talk} 02:31, 24 April 2008 (UTC)

Request

Since you were kind enough to offer (and install) protection for my pages a while ago, I'm turning to you. I'm back on the 'vandal hunt' and on april 20 I had a lot of vandalism and harasment from an IP hopping troll (see [7]). TravisTX protected my page for two days (see [8]), but now the troll is back again as [9]. Would you mind protecting my User and Talk page for a longer period? A month or so? I'm getting truly fed up with this harassment. Thanks  Channel ®    09:29, 23 April 2008 (UTC)

I've done so, you should probably create a small unprotected talkpage for anons to communicate with you on, linked from your main talk. Let me know if you need anything else. SQL^{Query me!} 01:57, 24 April 2008 (UTC)

Thanks!  Channel ®    07:13, 24 April 2008 (UTC)

missing ref tag bot

I saw you were involved in the "Unclosed ref tags" discussion and thought you might be interested in the related "Need a bot to find corrupted REFLIST outputs" discussion. What do you think of my algorithm proposal? -- Low Sea (talk) 07:04, 24 April 2008 (UTC)

Wikipedia:Bots/Requests_for_approval/BetacommandBot_Task_9

I'm a little puzzled that you'd approve this bot for trial. I've tried to explain how this bot will create deletion backlogs likely to be emptied carelessly and specifically asked Betacommand to consult with Mets501 on this. While everyone's screwing around like the only important question is whether or not this should be run on a separate account, nobody actually seems to care about whether or not the end result of the bot's work will be a net positive. I don't want to sound like a dick but I will shutdown the bot if it starts throwing hundreds of images in backlogs that will take hours to sift through (if done as carefully as needed). There is no rush to start this bot, whether it's on trial or working at full speed. And it's not like a conversation with Mets501 would kill anyone. Pascal.Tesson (talk) 02:31, 24 April 2008 (UTC)

I understand (trying to clear a backlog of 200+ account requests right now myself). I did read your concern, and, it's my opinion that it would not be an issue. I would consider improper tagging a bug, and, encourage notifying Betacommand if you see it, and, blocking if he does not respond. I'm sorry, that I only addressed the account thing, in my statement, but I read the whole thing, and, thought it would be worth it to let it run for a few days, and return for comment. If you felt like I didn't take your concerns into consideration, I'm very sorry if I gave that impression -- it wasn't my intention. If I did not think that the bot would end up being a net positive for the project, I would not have approved it for trial, however. SQL^{Query me!} 02:49, 24 April 2008 (UTC)

Well, gee, nice to know you ask people's opinions and then discard them without even commenting on the objection. I'm sure happy I took the time to voice my concerns. What exactly is the rush here? What I was asking for is simple to implement: two bot operators need to speak to one another. Ask around: I'm not exactly a hothead around here. But I'm not kidding: I will shut the bot down if we start getting hundreds of images that have to be checked by hand. That's what BAG is supposed to do man. Listen to concerns, find ways to fix them, approve bots once the concerns are addressed. Pascal.Tesson (talk) 04:36, 24 April 2008 (UTC)

Hey hey hey. That's not how I meant that. I have no doubt that you will block the bot in question, should it prove to be problematic. If it proves needed, heck, I'd support that action. However, simply generating a valid backlog, is not blockable. Falsely generating a backlog, is blatant disruption. As I said above, I did consider your objections. There is no deadline, but, I thought it was time, to move away from the theoretical, and see how the bot actually operates, in the wild. If your concerns prove to be a real problem, I assure you, I will not approve it (however, I try not to approve those bots which I have trialed). As above, I did not just discard your opinions, I did honestly take them into consideration. SQL^{Query me!} 04:51, 24 April 2008 (UTC)

See, I get that feeling that you don't even understand my concern. There is some value to the argument that images in violation of NFCC should be removed ASAP and so fast-tracking BcB's approval in that context makes some sense. This task on the other hand is not an urgent one. It could be done now, next week or next year: nobody would care. This is non-essential cleanup so there's absolutely no reason to authorize it until the community feels that it's ready to go. I've been one of the most active admins clearing the commons dupes categories so I do feel it's my responsibility to explain to BAG that the current bot will do more harm than good and I'd humbly suggest that I'm in a privileged position to do so. I've explained this as clearly as I can and if you still don't understand, let me know and I will explain it to you in more detail. But the bottom line is this: don't approve bots, even for trials, when the community is telling you that the bot's specifications fall short of what is needed. Pascal.Tesson (talk) 14:20, 24 April 2008 (UTC)

Pascal.Tesson, please understand that I will be talking with mets about cordination. I am also planning to run BCBot at a lot fewer image per day than with NFCC tagging. right now Im only thinking 100-500 images per day, until people get used to this task Im only thinking 100. β^{_{command 2}} 14:41, 24 April 2008 (UTC)

Well I'm glad to hear that but my point still stands: that discussion with Mets should occur before the bot's approval, not after. And it's unreasonable for SQL to authorize trial before these arrangements are made. This is why we have a bots approval process. People in the community speak out, the bot operator tries to address the concerns, maybe tweaks the bot a bit and only then does the bot go to work. Betacommand, I really have more of a quarrel with SQL then with you on this. SQL should be the one saying to you "can you make this coordination with Mets work?". (Though of course, I'd probably be less pissed about the whole thing if you did coordinate with him ASAP). Pascal.Tesson (talk) 17:32, 24 April 2008 (UTC)

I am planning to try and have the issues with Mets resolved within the next 72 hours. β^{_{command 2}} 17:46, 24 April 2008 (UTC)

I have concerns about how the bot is going to operate, because Betacommand is spinning ludicrous tales about "polydimensional programming" to cover for something. The general community isn't buying it, and I doubt that the BAG -- stacked with technical expertise as it is -- would fall for it either. My guess is that "polydimensional programming" means that his code has become unmaintainable and he's not sure how it works anymore. This bot was seriously not ready for approval, nor was the community ready to approve it.

I suppose we can hope he actually leaves good enough logs to fix it this time. rspeer / ɹəədsɹ 05:51, 24 April 2008 (UTC)

Rspeer, stop making personal attacks. Just becuase Im using a non-notable program implimentation design, they are a dime a dozen. I know exactly my code works, If I really wanted I could spend 10+ hours re-writing and testing the code to make it use seperate accounts, but you know what? its not worth the time. β^{_{command 2}} 14:30, 24 April 2008 (UTC)

Signpost updated for April 21st, 2008.

Weekly Delivery

Volume 4, Issue 17	21 April 2008	About the Signpost

BLP deletion rules discussed amidst controversial AFD	Threat made against high school on Wikipedia, student arrested
Global login, blocking features developed	WikiWorld: "Disruptive technology"
News and notes: Wikimania security, German print Wikipedia, milestones	Wikipedia in the News
Dispatches: Monthly updates of styleguide and policy changes	WikiProject Report: The Simpsons
Features and admins	Bugs, Repairs, and Internal Operational News
The Report on Lengthy Litigation

Home  |  Archives  |  Newsroom  |  Tip Line  |  Single-Page View	Shortcut : WP:POST

You are receiving this message because you have signed up for the Signpost spamlist. If you wish to stop receiving these messages, simply remove your name from the list. Ralbot (talk) 16:30, 25 April 2008 (UTC)

BNRX

Hey man, just thought I'd let you know that User:SQL/RfX Report doesn't seem to working, if you weren't already aware. Thanks! GlassCobra 16:55, 27 April 2008 (UTC)

Fixed. The RFBag silliness broke it. SQL^{Query me!} 01:34, 28 April 2008 (UTC)

Star Trek

I'm glad that you were able to get it fixed. Interesting about that Twinkle function. I guess I'll have to look into that. Is is documented somewhere? -- Gogo Dodo (talk) 15:43, 28 April 2008 (UTC)

This seems to have gotten it. Dunno if it's documented, I was pointed towards it on IRC :) SQL^{Query me!} 20:16, 28 April 2008 (UTC)

I noticed that. I'll have to experiment with Twinkle and the undelete thing. For some unknown reason, I've been resisting using Twinkle. -- Gogo Dodo (talk) 00:10, 29 April 2008 (UTC)