Wikipedia:Bots/Requests for approval/SQLBot-Hello

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.

SQLBot-Hello

Operator: SQL ^{Query me!}

Automatic or Manually Assisted: Automatic

Programming Language(s): PHP / SxWiki Lite

Function Summary: Welcoming users whose accounts were created at Wikipedia:ACC

Edit period(s) (e.g. Continuous, daily, one time run): As needed, probably hourly

Edit rate requested: Maxlag 5

Already has a bot flag (Y/N): N (Does not need or want the bot flag, either)

Function Details: SQLBot-Hello will welcome users, who have requested accounts on the Toolserver ACC app (link: http://tools.wikimedia.de/~sql/acc/ ), whos accounts have been created.

How it works:

An account creator will be able to specify if or if not they wish to have SQLBot-Hello welcome the users they create
If they choose to have SQLBot-Hello do so, they may specify a signature (I'm fairly sure most of the welcome templates allow this), and, select a template to use from a dropdown box. Therefore, the bot will not be signing it's own name to the welcomes.
I will have SQLBot-Hello run through the backlog db hourly, crontabbed, welcoming the applicable new users.
Default behavior will be not to welcome, unless explicitly turned on.

Notes:

The TS ACC App is not yet active (it's nearly complete, and is presently ready to use, but, is not in use yet)
I haven't written any of the bot code yet.
I know, welcomebots are often denied. I believe that this one is different, as it's not randomly welcoming people, but, is directed by users to welcome specific editors.
I've just created the bot-user, so, I might have to wait a couple days to become autoconfirmed.

Supported templates, format examples:

{{subst:|welcome|username}} usersig
{{subst:|w-screen|sig=usersig}}

Those are the only 2 I could find right now, that would work with specified sigs.

Discussion

this is a frequently denied bot. β^_command 14:58, 4 April 2008 (UTC)[reply]

I should note, that a similar bot ran at Wikipedia:ACC without problems for a very long time, run by User:ST47. SQL ^{Query me!} 14:59, 4 April 2008 (UTC)[reply]

Approved for trial (75 edits). Please provide a link to the relevant contributions and/or diffs when the trial is complete. 75 edits, because there is a large amount of requests. The reason I approve for trial so early is because it's opt-in, and shouldn't be too much of a problem. Also, I approve this welcome bot both because there has been a similar one in the past, and because it's not welcoming all users creating an account. Soxred93 | talk bot 15:06, 4 April 2008 (UTC)[reply]

Just wanted to check in; I've started implementing this in a very limited fashion, seems to be going OK so far (only 5 in tho) SQL ^{Query me!} 14:51, 9 April 2008 (UTC)[reply]

Alright, it's running per-user. SQL ^{Query me!} 16:19, 9 April 2008 (UTC)[reply]

There was a slight bug. It would link "my talkpage" to the welcomed user's talkpage. Mistyped a variable.... Fixed! [1] SQL ^{Query me!} 17:33, 9 April 2008 (UTC)[reply]

Re Betacommand's comment: The frequently denied bot is a bot which welcomes all new users. This is only welcoming those users who have their accounts created for them by one of the ACC volunteers. This bot is just a replacement for one that was running before the Wikipedia:ACC process was reformed. Stwalkerster [ talk ] 20:14, 9 April 2008 (UTC)[reply]

Another slight bug. Sometimes users beat SQLBot-Hello to the welcome. I added a 'blank page check'. If the page isn't blank, the bot will now skip it. fixed SQL ^{Query me!} 03:18, 10 April 2008 (UTC)[reply]

What if a user blanks the welcome of the user who beat your bot? Will it re-welcome? And what if they have the other welcome DB-user'd before the bot gets to it? MBisanz ^talk 03:20, 10 April 2008 (UTC)[reply]

Addressed most of these issues by adding new-page detection. update. As far as the {{Db-user}} issue goes, the bot runs every few mins, and, only runs once per user. It's highly unlikely that a userpage would get CSD'ed and actually deleted that fast. Plus, if the bot saw the CSD, it would skip anyhow. SQL ^{Query me!} 03:38, 10 April 2008 (UTC)[reply]

Ok, I'm happy with this bot then. MBisanz ^talk 03:40, 10 April 2008 (UTC)[reply]

Trial complete, 75 edits made (some where tests and development, 71 users welcomed. SQL ^{Query me!} 14:27, 10 April 2008 (UTC)[reply]

Approved. MaxSem^{(Han shot first!)} 05:37, 13 April 2008 (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.