Tewiki:User-wise Log stats

SQL

set @actor1:="Chaduvari";
select actor_id into @actorid from actor where actor_name=@actor1;
select count(log_actor) into @all from logging
where log_actor=@actorid;
-- and log_action="delete";

select count(log_actor) into @deletes from logging
where log_actor=@actorid
and log_action="delete";

select count(log_actor) into @restores from logging
where log_actor=@actorid
and log_action="restore";

select count(log_actor) into @moves from logging
where log_actor=@actorid
and log_action="move";

select count(log_actor) into @merges from logging
where log_actor=@actorid
and log_action="merge";

select count(log_actor) into @blocks from logging
where log_actor=@actorid
and log_action="block";

select count(log_actor) into @patrols from logging
where log_actor=@actorid
and log_action="patrol";

select count(log_actor) into @reverts from logging
where log_actor=@actorid
and log_action="revert";

select count(log_actor) into @thanks from logging
where log_actor=@actorid
and log_action="thank";

select count(log_actor) into @protects from logging
where log_actor=@actorid
and log_action="protect";

select count(log_actor) into @unprotects from logging
where log_actor=@actorid
and log_action="unprotect";

select count(log_actor) into @move_redirs from logging
where log_actor=@actorid
and log_action="move_redir";

select count(log_actor) into @delete_redirs from logging
where log_actor=@actorid
and log_action="delete_redir";


select @all,@actor1,@deletes,@restores,@moves,@merges,@blocks,@patrols,@reverts,@thanks,@protects,@unprotects,@move_redirs,@delete_redirs;
SQL

Checking query status...
