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 Symbol keep vote.svg 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  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)
 * 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 and, 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)
 * Why don't yo go ahead and run a live trial for 2 days on template:Adminstats. --uǝʌǝsʎʇɹnoɟʇs (st47) 12:16, 8 March 2008 (UTC)
 * Alright, she's a going. :) SQL Query me!  12:47, 8 March 2008 (UTC)
 * 2 days up, trial complete. SQL Query me!  03:44, 12 March 2008 (UTC)
 * --uǝʌǝsʎʇɹnoɟʇs (st47) 21:22, 13 March 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.