actions for adminstats

SELECT DISTINCT log_type FROM logging;
abusefilter = modify/""
block = block unblock reblock
contentmodel = change
delete log_action!="delete" and log_action!="restore" and log_action!="revision" and log_action!="event" and log_action!="delete_redir" and log_action!="flow-restore-topic" and log_action!="flow-delete-topic" and log_action!="flow-restore-post" and log_action!="flow-delete-post"
gblblock = d/whitelist
managetags = create/delete/deactivate/activate
massmessage = failure/send/skipbadns/skipnouser
merge = merge
move = move/move_redir
protect = "protect" and log_action!="unprotect" and log_action!="modify" and log_action!="move_prot"
renameuser = renameuser
review
rights = rights/autopromote
stable = "config" and log_action!="reset"  and log_action!="modify" and log_action!="move_stable"
upload = "overwrite" and log_action!="upload"
newusers = autocreate/byemail/create/create2/newusers

SQL

use ruwiki_p;
SELECT logging.*, user.user_name from logging join user on user.user_id = logging.log_user where (log_user in (select ug_user from user_groups where ug_group = sysop) and log_type = "move") limit 100 ;

SQL

Checking query status...