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

huqiangfeng

本教程介绍奇迹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

不错，支持下楼主

ToryEvers

好帖，来顶下

a3202417

路过，学习下

yjy290448701

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

csdfgf

www.gmgongju.com先顶，好同志