masterovoy clear db queries & recalculate stats

_a_clear_log.php

            $queries = array(
                'delete from `s_robots_log` where YEAR(dtlabel) <> YEAR(CURDATE())',
                'delete from `s_visits_log` where YEAR(dtlabel) <> YEAR(CURDATE())',
                'truncate table `s_robots_stat`',
//                'truncate table `s_visits_stat`',
                'truncate table a_ua_ranges',
                'truncate table a_log',
                'truncate table a_http_error',

                // restore stats
                'insert into s_robots_stat (statdate, dtmonth, dtday, hosts, hits) select date(dtlabel),dtmonth, '.
                'dtday,count(logid), count(distinct ip) from s_robots_log group by dtmonth,dtday',

                'insert into s_visits_stat (statdate, dtmonth, dtday, hosts, hits) '.
                'select date(dtlabel),dtmonth,dtday,count(logid) as hits, count(distinct ip) as '.
                'hosts from s_visits_log group by dtmonth,dtday'
            );