php防恶意刷新，过度抓取页面脚本

CREATE TABLE `v_ip_limited` ( `ip` char(20) NOT NULL, `type` tinyint(1) NOT NULL COMMENT '0��white 1��black', PRIMARY KEY (`ip`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; CREATE TABLE `v_ip_limited_times` ( `ip` char(20) NOT NULL, `first_time` datetime NOT NULL, `times` tinyint(3) NOT NULL, PRIMARY KEY (`ip`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; CREATE TABLE `v_ip_lasttime` ( `ip` char(20) NOT NULL, `last_time` datetime NOT NULL, PRIMARY KEY (`ip`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; delimiter // CREATE PROCEDURE `pro_del_ip`(IN nowtime DATETIME) BEGIN DECLARE p_ip CHAR(60) DEFAULT ''; DECLARE done INT DEFAULT 0; DECLARE temp_cur CURSOR FOR SELECT ip FROM v_ip_lasttime where TIME_TO_SEC(TIMEDIFF(nowtime,last_time)) > 60; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1; DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; INSERT INTO v_order_autocomment_log(pro_name,pro_run_time,pro_status) VALUES('pro_del_ip',nowtime,'failure'); END; START TRANSACTION; OPEN temp_cur; REPEAT FETCH temp_cur INTO p_ip; delete from v_ip_limited_times where ip=p_ip; delete from v_ip_lasttime where ip=p_ip; UNTIL done END REPEAT; CLOSE temp_cur; COMMIT; END;//