-- 1. 恢复18:00的完整备份（必须带NORECOVERY，保留日志恢复能力） RESTORE DATABASE [mu] FROM DISK = 'c:\sql\mu_FULL_1800.bak' -- 18:00的完整备份 WITH NORECOVERY, -- 关键：不完成恢复，允许继续恢复日志 REPLACE; -- 覆盖现有数据库（谨慎使用） -- ...
-- 1. 恢复18:00的完整备份（必须带NORECOVERY，保留日志恢复能力） RESTORE DATABASE [mu] FROM DISK = 'c:\sql\mu_FULL_1800.bak' -- 18:00的完整备份 WITH NORECOVERY, -- 关键：不完成恢复，允许继续恢复日志 REPLACE; -- 覆盖现有数据库（谨慎使用） -- ...
找到了主手和副手的库存：竖起大拇指：和插槽 前 12 个块，每个块 16 字节，是装备的物品。236 个 16 字节的块。8x8 主库存 = 64 个插槽装备 = 12 个装备插槽ExtendedInventory 1 = 32 个插槽ExtendedInventory 2 = 32 个插槽法典：[B]//Equipped Items[/B] 0F18FF0000000000004000FF...
MuHelper.h#pragma once #include "ProtocolDefines.h" //#define PICK_TIMER 1002 struct CUSTOM_PICK_INFO { BYTE IsPickingEnable; BYTE IsPickingExcItem; BYTE IsPickingZen; BYT...
之前都是使用网站注册时自动加VIP，后来发现其实有更简单的方法USE MuOnline IF EXISTS (SELECT name FROM sysobjects WHERE name = '增加VIP') DROP TRIGGER 增加VIP GO CREATE TRIGGER 增加VIP ON dbo.memb_info AFTER INSERT AS BEGIN DECLARE @...
请输入密码访问
This Guide will show you how to make an AutoReset Script using SQL Server Agent.To create a new job go to: Start>All Programmes>Microsoft SQL Server>Enterprise Manager...Then Find "Managem...
奇迹MU，等级达到150级后自动转职触发器，非创立角色就直接转职这样的好处是免除做转职任务，又防止了转生后，1级就可以穿转职后的职业装备CREATE TRIGGER [自动转职] ON [dbo].[Character] AFTER UPDATE AS BEGIN SET NOCOUNT ON; UPDATE C SET C.Class = 1 FROM [d...
奇迹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...