User:Holmes.bot

open (INPUT, "< $filepageid") || &file_open_error("$filepageid"); while ($page_id=){ 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; }