- 精华
- 阅读权限
- 130
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2020-10-9
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
发表于 2022-4-11 10:26:21
|
显示全部楼层
本帖最后由 feir 于 2022-4-11 10:30 编辑
装备变极品触发器:连上数据库,执行以下代码,打到装备后穿上,然后重进游戏装备就变成+15和极品属性了。 - CREATE DEFINER = `root`@`localhost` TRIGGER `item_no_cost` BEFORE UPDATE ON `mu_items` FOR EACH ROW begin
- if new.durability >0 and new.durability<100 then
- set new.durability = new.durability+200;
- end if;
- if new.container_type=0 then
- set new.socket= 7;
- set new.other_stats ='1,2,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32';
- set new.stones = '4018,105;4019,114;4020,101;4021,107;4022,129;4023,109;4024,113';
- set new.runes='4501;4502;4503;4504;4505';
- set new.zhuijia_level=7;
- if new.star_level<15 then
- set new.star_level=15;
- set new.once_max_star_level=15;
- end if;
- if new.star_level<50 and new.slot = 13 then
- set new.star_level=50;
- set new.once_max_star_level=50;
- end if;
- end if;
- end;
复制代码
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?注册
x
|