Wikipedia:Bots/Requests for approval/SQLBot 5

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 5

Operator: SQL ^{Query me!}

Automatic or Manually Assisted:

Programming Language(s): PHP, and SxWiki PHP Bot Framework

Function Summary: Create, and keep up to date, admin stats subtemplates

Edit period(s) (e.g. Continuous, daily, one time run): Daily, at the toolserver's most off-peak time, preferably

Edit rate requested: Maxlag 5, up to 851 ({{NUMBEROFADMINS}}) edits per run. Appx 6 EPM in early testing.

Already has a bot flag (Y/N): Y

Function Details: I would like, to keep template subpages, closely resembling Template:Adminstats/SQL up to date, preferably using Template:Adminstats instead of inside my userspace. The bot would only generate stats for those transcluding the template on their user, user talk, or, subpage of the above. Also, skinnable, using |style=pagename (Pagename would contain the format you want it in, see the deleted revisions to User:East718/test for an example). (Thanks, to East718 for MAJOR help with the templates, and, the main regex)

As always, full source available, at User:SQLBot/adminstats.php.

Discussion

NOTE: Bot is presently running, daily, inside my userspace, if anyone wants to try it. SQL ^{Query me!} 10:53, 8 March 2008 (UTC)[reply]

Having spent an hour with SQL beating out bugs, I can confirm that the bot works great (any possible problems of scale aside). The correct revisions to be looking at for the skinning system are [1] and [2], by the way. east.718 at 10:54, March 8, 2008

Indeed, there may be some problems of scale, should we eventually get enough admins, using it, to make the run time greater than 24 hours. At present, it seems to take a little less than ten seconds, per admin. At present, that would mean eight thousand six hundred and forty admins using the bot at once. SQL ^{Query me!} 11:01, 8 March 2008 (UTC)[reply]

Why don't yo go ahead and run a live trial for 2 days on template:Adminstats.

Approved for trial. Please provide a link to the relevant contributions and/or diffs when the trial is complete. --uǝʌǝs ʎʇɹnoɟ ʇs(st47) 12:16, 8 March 2008 (UTC)[reply]

Alright, she's a going. :) SQL ^{Query me!} 12:47, 8 March 2008 (UTC)[reply]

2 days up, trial complete. SQL ^{Query me!} 03:44, 12 March 2008 (UTC)[reply]

Approved. --uǝʌǝs ʎʇɹnoɟ ʇs(st47) 21:22, 13 March 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.