huqiangfeng 发表于 2021-4-30 18:27:11

【奇迹教程】奇迹1.03H各职业自动三转SQL语句

本教程介绍奇迹1.03H如何实现人物400等级后实现自动三转一、奇迹自动三转就是用sql查询分析器执行SQL语句，当角色到达400等级时候，数据库触发器触发执行。1、先打开SQL的触发器，不会使用SQL触发器可以参考：触发器使用2、在触发器中选择数据库为：“Muonline”，复制下面的SQL语句，点击执行即可。3、那如果你已经送点了，如果修改数据那，请您参考：触发器中的SQL如何修改注意：如果你在执行时候提示“对象名错误”或者“对象名已经存下”等信息，需要修改下面蓝色标注代码 第一条开头数据把 CREATE 创建意思，可以修改为：ALTER 修改意思，提示类似错误两个开头语句可以互相替换下即可恢复正常。CREATE TRIGGER 法师自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=3
UPDATE Character SET Character.Quest=0xEADAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=1
SET NOCOUNT OFF
CREATE TRIGGER 战士自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=19
UPDATE Character SET Character.Quest=0xAAF6FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=17
SET NOCOUNT OFF
CREATE TRIGGER 弓箭自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=35
UPDATE Character SET Character.Quest=0xEADAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=33
SET NOCOUNT OFF
CREATE TRIGGER 魔剑自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=50
UPDATE Character SET Character.Quest=0xFFEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=48
SET NOCOUNT OFF
CREATE TRIGGER 圣导自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=66
UPDATE Character SET Character.Quest=0xFFEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=64
SET NOCOUNT OFF
CREATE TRIGGER 召唤自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=83
UPDATE Character SET Character.Quest=0xEAEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=80
SET NOCOUNT OFF

arenas 发表于 2021-5-15 16:00:29

不错，支持下楼主

ToryEvers 发表于 2021-6-22 14:44:23

好帖，来顶下

a3202417 发表于 2021-7-8 01:24:07

路过，学习下

yjy290448701 发表于 2021-10-16 20:54:01

学习了，不错，讲的太有道理了

csdfgf 发表于 2022-4-20 20:03:42

www.gmgongju.com先顶，好同志
页: [1]
查看完整版本: 【奇迹教程】奇迹1.03H各职业自动三转SQL语句