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