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();

}

BAG tools

v t e Bot Approvals Group Administration Templates
Bot Templates	Output	Comments
{{Bot trial}}	Approved for trial. Please provide a link to the relevant contributions and/or diffs when the trial is complete.
{{Bot trial\|edits=50}}	Approved for trial (50 edits). Please provide a link to the relevant contributions and/or diffs when the trial is complete.	This is for a trial for a certain number of edits (this option may be combined with others)
{{Bot trial\|days=7}}	Approved for trial (7 days). Please provide a link to the relevant contributions and/or diffs when the trial is complete.	This is for a trial for a certain number of days (this option may be combined with others)
{{Bot trial\|edits=50\|days=7\|first=yes}}	Approved for trial (50 edits or 7 days, whichever happens first). Please provide a link to the relevant contributions and/or diffs when the trial is complete.	This is for a trial with a race condition, where either a singular day/time limit may result in either too much or too little information
{{Bot trial\|userspace=yes}}	Approved for trial (userspace only). Please provide a link to the relevant contributions and/or diffs when the trial is complete.	This is a userspace only trial (this option may be combined with others)
{{BotExtendedTrial}}	Approved for extended trial. Please provide a link to the relevant contributions and/or diffs when the trial is complete.	The extended trial template uses the same parameters as the standard trial template (see above).
{{Bot trial complete}}	Trial complete.	For use by the bot operator to report that the bot has completed its trial period.
{{BotOnHold}}	On hold.
{{BotSpeedy}}	Speedily Approved.
{{BotApproved}}	Approved.
{{BotExpired}}	Request Expired.
{{BotWithdrawn}}	Withdrawn by operator.
{{BotDenied}}	Denied.
{{BotRevoked}}	Revoked.
{{BotComment}}	Comment.
{{Operator assistance needed}}	A user has requested the attention of the operator. Once the operator has seen this message and replied, please deactivate this tag.	This will result in the bot sending a message to the operator.
{{BAG assistance needed}}	A user has requested the attention of a member of the Bot Approvals Group. Once assistance has been rendered, please deactivate this tag by replacing it with `{{t\|BAG assistance needed}}`.	This is intended for use if urgent attention is needed or if a request is being neglected (wait seven days first).
{{BOTREQ\|advertise}} {{BOTREQ\|badidea}} {{BOTREQ\|confusing}}	Needs wider discussion. Not a good task for a bot. Idea is not well explained.	Provides a variety of common messages for bot requests and BRFAs (see template documentation for details).


{{subst:Bot Top\|Status\|BotName #}}	The following discussion is an archived debate. Please do not modify it.* Subsequent comments should be made in a new section.*	Includes <noinclude> tag and the appropriate bot category (when using "subst")
{{subst:Bot Bottom}}	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.