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

奇迹私服技术
风之恋奇迹私服技术,为您提供最权威的奇迹私服架设教程,奇迹私服技术教程,奇迹私服合区教程,最新最全的奇迹私服技术教程供您学习参考
摘 要

本教程介绍奇迹私服1.03H如何实现人物400等级后实现自动三转一、奇迹私服自动三转就是用sql查询分析器执行SQL语句,当角色到达400等级时候,数据库触发器触发执行。1、先打开SQL的触发

Rookie博客,奇迹私服私服博客。欢迎访问www.www.fzlqiji.com

本教程介绍奇迹私服1.03H如何实现人物400等级后实现自动三转7h9rookie博客-奇迹私服私服 Blog

一、奇迹私服自动三转就是用sql查询分析器执行SQL语句,当角色到达400等级时候,数据库触发器触发执行。7h9rookie博客-奇迹私服私服 Blog

1、先打开SQL的触发器,不会使用SQL触发器可以参考:触发器使用7h9rookie博客-奇迹私服私服 Blog

2、在触发器中选择数据库为:“Muonline”,复制下面的SQL语句,点击执行即可。7h9rookie博客-奇迹私服私服 Blog

3、那如果你已经送点了,如果修改数据那,请您参考:触发器中的SQL如何修改7h9rookie博客-奇迹私服私服 Blog

注意:如果你在执行时候提示“对象名错误”或者“对象名已经存下”等信息,需要修改下面蓝色标注代码 第一条开头数据把 CREATE 创建意思,可以修改为:ALTER 修改意思,提示类似错误两个开头语句可以互相替换下即可恢复正常。7h9rookie博客-奇迹私服私服 Blog

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
7h9rookie博客-奇迹私服私服 Blog


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
7h9rookie博客-奇迹私服私服 Blog


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
7h9rookie博客-奇迹私服私服 Blog


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
7h9rookie博客-奇迹私服私服 Blog


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
7h9rookie博客-奇迹私服私服 Blog


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
7h9rookie博客-奇迹私服私服 Blog

7h9rookie博客-奇迹私服私服 Blog

Rookie博客,奇迹私服私服博客。欢迎访问www.www.fzlqiji.com
最新奇迹发布网,手游新版奇迹sf私发网,复古奇迹私发网 奇迹手游sf,奇迹sf发布,奇迹私发网 手游,全民奇迹9.0无限钻石,99阶超变奇迹手游版,全民奇迹坐骑无限版本,奇迹手游哪个好玩,奇迹手游,奇迹mu手游 奇迹mu,奇迹mu官网手游版,奇迹手机版,奇迹官方,手机版奇迹现在哪个好,奇迹私发网

评论留言

我要留言

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。