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 Symbol keep vote.svg 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 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:


 * welcome usersig
 * w-screen

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)
 * I should note, that a similar bot ran at ACC without problems for a very long time, run by User:ST47. SQL Query me!  14:59, 4 April 2008 (UTC)
 * 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! 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 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. 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. update. As far as the 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)
 * Max S em(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.