奇迹MU自动转职触发器使用此触发器后，所有新建角色自动完成转职，之后无需再进行转职任务。 CREATE TRIGGER 自动转职 ON CharacterAFTER INSERT AS SET NOCOUNT ON UPDATE Character SET Class=1 FROM Inserted WHERE Inserted.Class=0 and Character.account...
奇迹MU自动转职触发器使用此触发器后，所有新建角色自动完成转职，之后无需再进行转职任务。 CREATE TRIGGER 自动转职 ON CharacterAFTER INSERT AS SET NOCOUNT ON UPDATE Character SET Class=1 FROM Inserted WHERE Inserted.Class=0 and Character.account...
CREATE TRIGGER [pvp] ON [dbo].[Character]AFTER UPDATEASBEGINSET NOCOUNT ON; IF EXISTS (SELECT 1 FROM Inserted WHERE Inserted.PKlevel > 4) BEGIN UPDATE c SET c.MapNumber = 6, ...
UPDATE memb_info SET AccountLevel = 1, AccountExpireDate = DATEADD(day, 3, GETDATE()); //全体增加3天VIP会员体验 CREATE TABLE Cards ( Id INT IDENTITY(1,1) PRIMARY KEY, CardNumber VARCHAR(16) NOT...
当运行一个指令时提示服务器: 消息 468，级别 16，状态 9，过程 WZ_DISCONNECT_MEMB，行 10无法解决 equal to 运算中 "Chinese_PRC_CS_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。.这是由于数据库编码不一至造成的,把select @find_id = S.memb___id from MEMB_STAT S INN...
一个简单的排名演示Select c.AccountID as Account, c.Name as CharName, c.Resets as CharResets, c.cLevel as CharLevel, (case when c.MapNumber = 0 then 'Lorencia' when c.MapNumber = 1...
What this does?add a new column in your MEMB_STAT table for total online time for the user EVER!Does it can count in HOUR, DATE, Minutes?yesDo I need this?no idea, it's your lifeWhat can I do with ...
取消新人注册送点CREATE TRIGGER [Restrict_IntLUP] ON [dbo].[Character]after InsertasUpdate [Character] set [Character].LevelUpPoint=0 From InsertedWhere [Character].accountid=inserted.accountidand [Characte...
XT803装备编码计算ID_MuEMU.rar
今天交大家在奇迹私服里怎么卡黑王马和狼，PK的时候卡马和狼是没有反射伤害的停顿延迟的！先交大家在奇迹私服里卡黑王马的步骤！首先就是带上黑王马找一个奇迹私服里的朋友交易，，在交易的时候就拿下奇迹sf黑王马，自己就按取消，对方就按Esc键，就是这样卡的，不过需要两个人有一定的默契度！卡奇迹sf炎狼兽的步骤和卡黑王马是一样的！
打开ResetSystem.xml文件 <!-- (0: 关闭, 1: 开启) --> <enabled>1</enabled>minlevel最低转生等级 最高转生等级maxlevel