Wikipedia:Bots/Requests for approval/SQLBot-Hello

{{Newbot|SQLBot-Hello}}

Operator: SQL^{Query me!}

Automatic or Manually Assisted: Automatic

Programming Language(s): PHP / [http://sxwiki.sf.net 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.

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

::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)

:::{{BotTrial|edits=75}} 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)

::::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)

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

There was a slight bug. It would link "my talkpage" to the welcomed user's talkpage. Mistyped a variable.... Fixed! [http://en.wikipedia.org/w/index.php?title=User%3ASQLBot-Hello%2Fsqlbot-hello.php&diff=204494138&oldid=204479024] SQL^{Query me!} 17:33, 9 April 2008 (UTC)

: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)

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. [http://en.wikipedia.org/w/index.php?title=User%3ASQLBot-Hello%2Fsqlbot-hello.php&diff=204612955&oldid=204534546 fixed] SQL^{Query me!} 03:18, 10 April 2008 (UTC)

: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)

Addressed most of these issues by adding new-page detection. [http://en.wikipedia.org/w/index.php?title=User%3ASQLBot-Hello%2Fsqlbot-hello.php&diff=204615470&oldid=204612955 update]. As far as the {{t1|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)

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

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

:{{BotApproved}} MaxSem^{(Han shot first!)} 05:37, 13 April 2008 (UTC)

: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.