数据库恢复后要建两个JOB,分别定时
an hour:delete debarip 删debarip 表( 一小时)和
//------------------
delete debarip
update users set activeflag=1 where todaynum>0
//--------------------
将当天点击数归零(一天)
/*********************************************/
INSERT INTO self_today_stat (id,todayshow,sumshow) SELECT * FROM stat WHERE (id = 1)
--set activeflag is befortoday
update users set activeflag=1 where todaynum>0
update users set activeflag=0 where todaynum=0
update users set todaynum=0
update stat set todayshow=0
/*********************************************/