用数据库软件navicat连接数据库~~~~~~~~~~~~~~~
连接数据库按F6,复制下面代码粘贴进去按回车就行了。注意讲解一下
(外挂只能刷满点券,无法自定义点券数量! 下面代码是超过1亿点券会自动清0!所以你自己充值满点券应该也会清0,不要超过1亿即可!)
CREATE DATABASE IF NOT EXISTS `taiwan_billing`; USE `taiwan_billing`; DROP TRIGGER IF EXISTS `cash_cera`; CREATE TRIGGER `cash_cera` BEFORE UPDATE ON `cash_cera` FOR EACH ROW IF (new.cera >= 100000000 OR new.cera <= 0 ) THEN SET new.cera = 0;END IF; DROP TRIGGER IF EXISTS `cash_cera_point`; CREATE TRIGGER `cash_cera_point` BEFORE UPDATE ON `cash_cera_point` FOR EACH ROW IF (new.cera_point >= 100000000 OR new.cera_point <= 0 ) THEN SET new.cera_point = 0;END IF; |