Re: [Toolserver-l] Where's a convenient list of all active Wikipedia bots

2012-01-31 Thread Petr Onderka
All bots on a given wiki have a row in the user_groups table with ug_group set to 'bot'. So, you can use that to get the list of all bot accounts on a wiki. Petr Onderka [[User:Svick]] On Tue, Jan 31, 2012 at 10:12, Philipp Zedler phil...@neue-musik.com wrote: Hallo! I'm needing a list of all

Re: [Toolserver-l] Where's a convenient list of all active Wikipedia bots

2012-01-31 Thread Simon Walker
Not all bots are in the bot group though, IIRC ClueBot isn't, and neither are a few others. Simon On Jan 31, 2012 9:31 AM, Petr Onderka gsv...@gmail.com wrote: All bots on a given wiki have a row in the user_groups table with ug_group set to 'bot'. So, you can use that to get the list of all

Re: [Toolserver-l] Where's a convenient list of all active Wikipedia bots

2012-01-31 Thread Petr Onderka
ClueBots certainly are in the group: mysql select user_name from user_groups join user on user_id = ug_user where ug_group = 'bot' and user_name like 'Clue%'; +-+ | user_name | +-+ | ClueBot | | ClueBot II | | ClueBot III | | ClueBot IV | | ClueBot NG | | ClueBot

Re: [Toolserver-l] Where's a convenient list of all active Wikipedia bots

2012-01-31 Thread Philipp Zedler
Hallo Petr and Simon (and everyone else), thank you very much for your replies! All bots on a given wiki have a row in the user_groups table with ug_group set to 'bot'. So, you can use that to get the list of all bot accounts on a wiki. I'm now using this solution by Petr in my program and it