Wikipedia:Bots/Requests for approval/SXT-404Bot 2

The following discussion is an archived debate. Please do not modify it. Subsequent comments should be made in a new section. The result of the discussion was

Approved.

SXT-404Bot 2 (now known as SQLBot)

SQLBot:

SXT-404Bot

Operator: SQL ^{Query me!}

Automatic or Manually Assisted: Automatic

Programming Language(s): PHP via SxWiki

Function Summary: Tag article talk pages with wikiproject templates

Edit period(s) (e.g. Continuous, daily, one time run): Until completed

Edit rate requested: 5-10 edits per min, maxlag 5

Already has a bot flag (Y/N): Y

Function Details: I'd like to start out, tagging Category:Japanese mythology mythology the template {{jmyth}}, I'd like to move on after that, to Category:Astrology, Category:Cryptozoology, Category:Intelligent design, and, Category:Occult. (See the request (permlink) for more information) SQL ^{Query me!} 21:07, 19 November 2007 (UTC)[reply]

Also, obviously, if the page already contains the template in question, it will skip that page. I have yet to write the code, but, will likely do so tonight. SQL ^{Query me!} 21:18, 19 November 2007 (UTC)[reply]

Actually, I got the code done already... SQL ^{Query me!} 21:36, 19 November 2007 (UTC)[reply]

Discussion

Approved for trial (50 edits). Please provide a link to the relevant contributions and/or diffs when the trial is complete. - Have fun! —Reedy Boy 21:37, 19 November 2007 (UTC)[reply]

Completed the trial. There were a few bad edits at first... I was rushing to get it ready before work, and, the result was two things: (1) I was 15 mins late for work, and (2) sloppy, bad code.

You can find the logged results at User:SXT-404Bot/tagem.log. I went beyond the categories I said that I would, because there was not enough to be changed in them to complete the trial. I'll be finishing the posted request, if approved. SQL ^{Query me!} 06:49, 20 November 2007 (UTC)[reply]

Also. I accidentally exceeded the requested edits per min. I accidentally removed the sleep() call, in sxPostPage(), while testing the framework. Bug was fixed in this revision.SQL ^{Query me!} 07:02, 20 November 2007 (UTC)[reply]

Just a note, this bot has been renamed to User:SQLBot. SQL ^{Query me!} 08:38, 20 November 2007 (UTC)[reply]

There were some concerns raised on my talkpage about the bot not putting tags in existing {{WikiProjectBannerShell}} templates. Granted it's after my run, but, I got it fixed, see test here, in this revision to the bot's code. SQL ^{Query me!} 21:17, 20 November 2007 (UTC)[reply]

Would it be possible for me to get another trial, say... 25 edits, to make sure I have the banner shell thing nailed down (and, the epm thing) SQL ^{Query me!} 07:18, 22 November 2007 (UTC)[reply]

Approved for trial (25 edits). Please provide a link to the relevant contributions and/or diffs when the trial is complete. -- Cobi^(t|c|b|cn) 07:28, 22 November 2007 (UTC)[reply]

Thanks, Cobi! Second trial completed (and, slightly exceeded) SQL ^{Query me!} 08:22, 22 November 2007 (UTC)[reply]

Oh no. We're gonna have to block the bot for that ;) —Reedy Boy 21:44, 24 November 2007 (UTC)[reply]

D'oh! :( SQL ^{Query me!} 09:39, 25 November 2007 (UTC)[reply]

Approved. The edits do look quite good and looking through the contributions, there seems to be no errors this time round. The bot shall run with a flag - good luck. — E ^talk_BAG 09:43, 25 November 2007 (UTC)[reply]

The above discussion is preserved as an archive of the debate. Please do not modify it. Subsequent comments should be made in a new section.