stewardry
Provides useful statistics for stewards about the given project.
Database connection failed: Unknown database '_p'
No database selected
SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) FROM recentchanges ORDER BY rc_timestamp DESC LIMIT 1No database selected
INSERT INTO u_pathoschild.137162871555971400 (p_id, p_group) SELECT ug_user, ug_group FROM user_groups WHERE ug_group="sysop" OR ug_group="bureaucrat" ORDER BY ug_userNo database selected
/* ip=185.15.59.197, request=Array
(
[wiki] => global
)
*/UPDATE u_pathoschild.137162871555971400 SET p_name=(SELECT user_name FROM user WHERE user_id=u_pathoschild.137162871555971400.p_id)No database selected
/* ip=185.15.59.197, request=Array
(
[wiki] => global
)
*/UPDATE u_pathoschild.137162871555971400 SET p_last_edit=(SELECT MAX(rev_timestamp) FROM revision WHERE rev_user=p_id)No database selected
/* ip=185.15.59.197, request=Array
(
[wiki] => global
)
*/UPDATE u_pathoschild.137162871555971400 SET p_last_sysop=(SELECT MAX(log_timestamp) FROM logging WHERE log_user=u_pathoschild.137162871555971400.p_id AND log_type IN ("block","delete","protect"))No database selected
/* ip=185.15.59.197, request=Array
(
[wiki] => global
)
*/UPDATE u_pathoschild.137162871555971400 SET p_last_bureaucrat=(SELECT MAX(log_timestamp) FROM logging WHERE log_user=u_pathoschild.137162871555971400.p_id AND log_type IN ("makebot","renameuser","rights"))Generated data
Table of contents
sysops
No active sysops on this wiki.
bureaucrats
No active bureaucrats on this wiki.
Query completed in 0.008 seconds.
This tool is written and copyright by Jesse Plamondon-Willard (Pathoschild). You may freely use, distribute, and modify this script in any way and for any purpose, so long as you cite the above name as original author.
