mic_none

Wikipedia:Bots/Requests for approval/SQLBot-Hello Source: en.wikipedia.org/wiki/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

[edit]

Operator: SQLQuery 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

[edit]
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. SQLQuery 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) SQLQuery me! 14:51, 9 April 2008 (UTC)[reply]
Alright, it's running per-user. SQLQuery 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] SQLQuery 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 SQLQuery 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. SQLQuery 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. SQLQuery 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.