奇迹私服|奇迹SF|奇迹私发网
103各职业分开送点
文章作者:453mu私服自助发布网 文章来源:453mu私服自助发布网 更新时间:2022-1-2 8:56:07 
 

CREATE TRIGGER [冲值送VIP] ON [dbo].[MEMB_INFO]
after Insert
as
UPDATE MEMB_INFO SET myCash = myCash+myCashVIP,member=1,myCashVIP = 0
FROM Inserted
Where Inserted.myCashVIP >= 100


删除指定分区的帐号
DELETE FROM memb_info WHERE servercode =1


CREATE TRIGGER [清空新人装备栏] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Inventory=0 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name


圣导送统率:

CREATE TRIGGER [圣导统率] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=3000
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name

CREATE TRIGGER 法师送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=500
FROM Inserted
Where Inserted.Class=0
and Character.name=Inserted.name
SET NOCOUNT OFF

CREATE TRIGGER 精灵送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=500
FROM Inserted
Where Inserted.Class=32
and Character.name=Inserted.name
SET NOCOUNT OFF

CREATE TRIGGER 战士送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=300
FROM Inserted
Where Inserted.Class=16
and Character.name=Inserted.name
SET NOCOUNT OFF

CREATE TRIGGER 魔剑送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=700
FROM Inserted
Where Inserted.Class=48
and Character.name=Inserted.name
SET NOCOUNT OFF

CREATE TRIGGER 圣导送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=300
FROM Inserted
Where Inserted.Class=64
and Character.name=Inserted.name
SET NOCOUNT OFF


CREATE TRIGGER 召唤送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=500
FROM Inserted
Where Inserted.Class=80
and Character.name=Inserted.name
SET NOCOUNT OFF


CREATE TRIGGER 角士送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=500
FROM Inserted
Where Inserted.Class=96
and Character.name=Inserted.name
SET NOCOUNT OFF

 
浏览次数:536
上一篇:【DATA】文件详细说明
下一篇:奇迹教程系列-item.txt与item.bmd文件介绍
 
相关文章:103各职业分开送点
文章评论

当前没有评论

发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
表情:
验证码:点击我更换图片
最新文章
· 1.03H全职自动3转SQL代码
· 整理-奇迹各类版本介绍-国内
· 奇迹教程系列-item.txt与it
· 103各职业分开送点
· 【DATA】文件详细说明
· 服务器端口以及多区设置教程
· 奇迹物品代码表(2)
· 奇迹物品编号表(1)
· 卓越属性调用表
· 删除数据库送点触发器
热门文章
· 奇迹物品代码表(2)
· 奇迹物品编号表(1)
· 整理-奇迹各类版本介绍-国内
· 【DATA】文件详细说明
· 奇迹教程系列-item.txt与it
· 奇迹MU客户端修改大全
· 奇迹起名特殊符号大全
· 删除数据库送点触发器
· 103各职业分开送点
· 服务器端口以及多区设置教程