User:Holmes.bot

open (INPUT, "< $filepageid") || &file_open_error("$filepageid");

while ($page_id=<INPUT>){

   chomp($page_id);
   push @page_ids, $page_id;

   $hits_upto_sth->execute($page_id, $start_date);
   $hits{upto}{$page_id} = $hits_upto_sth->fetchrow_array();

   $hits_daily_sth->execute($page_id, $today);
   $hits{today}{$page_id} = $hits_daily_sth->fetchrow_array();

   $hits_daily_sth->execute($page_id, $yesterday);
   $hits{yesterday}{$page_id} = $hits_daily_sth->fetchrow_array();

   $hits_range_sth->execute($page_id, $start_of_30_days,
                                      $end_of_30_days,);
   $hits{monthly}{$page_id} = $hits_range_sth->fetchrow_array();

}

Bot Approvals Group Administration Templates
Bot Templates	Output	Comments
{{BotTrial}}	Approved for trial.
{{BotExtendedTrial}}	Approved for extended trial.	The extended trial template uses the same parameters as the standard trial template (see below).
{{BotTrial|edits=50}}	Approved for trial (50 edits).	This is for a trial for a certain number of edits (this option may be combined with others)
{{BotTrial|days=7}}	Approved for trial (7 days).	This is for a trial for a certain number of days (this option may be combined with others)
{{BotTrial|userspace=yes}}	Approved for trialUserspace only.	This is a userspace only trial (this option may be combined with others)
{{BotTrial|edits=50|days=5|userspace=yes}}	Approved for trial (50 edits or 5 days)Userspace only.	This is a trial showing all the options
{{BotTrialComplete}}	Trial complete.	For use by bot the operator to report that the bot has completed its trial period.
{{BotSpeedy}}	Speedily Approved.
{{BotApproved}}	Approved.
{{BotDenied}}	Denied.
{{BotWithdrawn}}	Withdrawn by operator.
{{BotExpired}}	Request Expired.
{{BotRevoked}}	Revoked.
{{BotStatus}}	Status Unknown.
{{BotComment}}	Comment.
{{OperatorAssistanceNeeded}}	A user has requested the attention of the operator. Once the user has seen this message and replied, please remove this tag.	This will result in the bot sending a message to the operator.
{{BAGAssistanceNeeded}}	A user has requested the attention of a member of the Bot Approvals Group. Once assistance has been rendered, please deactivate this tag.	This is intended for use if urgent attention is needed or if a request is being neglected, do not use it after every comment.
{{subst:Bot Top|Status|BotName}}   OR {{subst:BT|Status|BotName}}		Includes <noinclude> tag and the appropriate bot category (when using "subst")
{{subst:Bot Bottom}} {{subst:BB}}	The above discussion is preserved as an archive of the debate. Please do not modify it. Subsequent comments should be made in a new section.	Includes </noinclude> tag (when using "subst")
{{subst:Bot Talk|Subpage|Status}}   {{subst:Bot Talk|Subpage|approved|Bot}}	== WP:RFBOT == Your recent bot approvals request has been Status. Please see the request page for details.   == WP:RFBOT == Your recent bot approvals request has been approved. Please see the request page for details. When the bot flag is set it will show up in this log.