User:SQLBot

From Wikipedia, the free encyclopedia

This user account is a bot operated by SQL (talk). It is not a sock puppet, but rather an automated or semi-automated account for making repetitive edits that would be extremely tedious to do manually. Administrators: if this bot is malfunctioning or causing harm, please block it.

Some of this bot's functions are run from the toolserver. Please be very careful if you need to block this bot.

[graph/hist] Toolserver status
Last update	23:00, 12 June 2008 (UTC)
MySQL vandale	up
MySQL zedler	up
MySQL yarrow	up
Replag s1	0h 0m 0s
Replag s2	0h 0m 6s
Replag s3	0h 1m 55s
More information...

I'm approved!, Task 2 Task 3, Task 4

As stated above, my maintainer is User:SQL.

Thanks for stopping by!

Contents 1 Task 1 2 Task 2 2.1 Stage 1 2.2 Stage 2 3 Task 3 4 Task 4 5 Task 5 6 Misc tasks 7 IRC

[edit] Task 1

To search Special:BrokenRedirects use the same query as mediawiki uses for broken redirects, and, report them at User:SQL/BRedir. I'm run daily via cron on the toolserver.

Source code: get_bredir.php not presently available (I'm lazy)

[edit] Task 2

Presently running stage 1 Presently Broken :(

[edit] Stage 1

To search for articles with <ref> tags, but, no {{Reflist}}, {{References}} or, <references /> tags, and, dump the article names to a file.

[edit] Stage 2

To either post the file of article names, to a subpage of my userpage, or, to automatically correct them. This will depend, on how many there are. (Presently manually pasting first run @ User:SQL/Reflist)

Source code: User:SQLBot/Reflist.php

[edit] Task 3

Tag various talkpages pages whose pages are in in various categories with various wikiproject templates. Skip if template's already there.

• Approval for trial
• Activity log
• Source code
• Bot request (permlink)
• Stop the bot! -- Change the text on this page from go to stop, to stop the bot from performing this task. If you do so, please log it at User talk:SQLBot/tagem.run, including the reason why, to facilitate troubleshooting.

[edit] Task 4

• Updating wikiproject watchlists like this one (Daily)
• Source code
• Approval
• If you would like a watchlist kept up to date for your wikiproject, just let me know on my talkpage.

[edit] Task 5

• This task is approved by BAG.
• Keeping Wikipedia:Bureaucrats' noticeboard/RfB Report, and, User:SQL/RfX Report up to date
• Source code (rfx bot)
• Updating User:SQL/RfX Report/Potential problems, a report on potential SPA's at RfX
• Stop this task (Change "go" to "stop", admins only)

[edit] Misc tasks

1. Updating {{NUMBEROFROLLBACKERS}}, a template that functions in a similar manner to "magic words" like {{NUMBEROFUSERS}} and gives the number of users in the rollback user group. (Every 6 hours, sometimes more frequently)

   Source code: User:SQLBot/nroll.php

2. Keeping User:SQL/Unblocked TOR, a list of unblocked TOR exit nodes that allow wikipedia access, updated (hourly)

   Source code: User:SQL/Unblocked TOR/Source

3. Updating the SxWiki bot framework source, whenever I make changes to it. Project moved to this sourceforge

   Source code: User:SQLBot/postcode.php

4. Updating User:SQL/AORStats, a snapshot of admin/crat/rollbacker counts, taken every 3 days.

   Source code: User:SQLBot/tally.php

5. Maintaining User:SQL/Funky_TOR and User:SQL/Funky_TOR/Admin_Stats, lists of possibly stale TOR nodes on Wikipedia.

   Source code: User:SQLBot/ctor2.php

[edit] IRC

1. Cheap knock-off backup bot for #wikipedia-en-unblock.

   Source code: User:SQLBot/rfubot.php

   Instructions: User:SQLBot/RFUBot Instructions