GM工具社区

 找回密码
 立即注册
腾迅云双11
查看: 16|回复: 0

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

[复制链接]

该用户从未签到

7

主题

10

帖子

7

贡献

新手上路

Rank: 1

积分
17
发表于 2021-4-30 18:27:11 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区

您需要 登录 才可以下载或查看,没有帐号?立即注册

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

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

小黑屋|GM工具 ( 鄂ICP备19013361号-1 )

GMT+8, 2021-5-11 19:38 , Processed in 0.073423 second(s), 27 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表