实现自动赠送历练
CREATE TRIGGER [song] ON [dbo].[TBL_Char]
after Insert
as
Update [TBL_Char] set FLD_FIGHT_EXP=100000
From Inserted
Where [TBL_Char].FLD_ID=inserted.FLD_ID
and [TBL_Char].FLD_NAME=inserted.FLD_NAME
update TBL_Char set FLD_MENOW=101,FLD_X=613.6401,FLD_Y=365.9651
where FLD_MENOW='0'
update TBL_Char set FLD_FIGHT_EXP=100000
where FLD_FIGHT_EXP<100000
实现自动赠送历练-自动解决卡号问题 FLD_FIGHT_EXP=100000 是10W历练,可以自己修改
使用方法:在TBL_Char上右键->所有任务->管理触发器->把上面改好后贴粘进去
上线发装备的触发器
CREATE TRIGGER [song] ON [dbo].[TBL_Char]
after Insert
as
Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x029402000000000037DC143C01000000000000000000000000000000000000000000000000039402000000000037DC143C01000000000000000000000000000000000000000000000000049402000000000037DC143C01000000000000000000000000000000000000000000000000E78802000000000037DC143C01000000000000000000000000000000000000000000000000E88802000000000037DC143C01000000000000000000000000000000000000000000000000E68802000000000037DC143C01000000000000000000000000000000000000000000000000B4C90100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000056D10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B5C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B6C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B7C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000ACC90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B9C90100000000002CDC143C01000000000000004052D777C8F7CB3C0000000000000000005BD10100000000002CDC143C01000000000000004052D777C8F7CB3C0000000000000000005AD10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B8C90100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000054D10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000ADC90100000000002CDC143C01000000000000008649D777C8F7CB3C0000000000000000006BBA02000000000094CA9A3B0F270000000000000000000000000000000000000000000000E76202000000000095CA9A3B0F270000000000000000000000000000000000000000000000F6D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000E26A1100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F5D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F7D00100000000002DDC143C01000000000000004052D777C8F7CB3C0000000000000000000F721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000010721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000011721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000012721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000013721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000014721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000029BC02000000000041EEF8050100000000000000000000000000000000000000000000000041BC02000000000041CFEE0B010000000000000000000000000000000000000000000000004BBC02000000000041B0E4110100000000000000000000000000000000000000000000000070BC0200000000004172D01D0100000000000000000000000000000000000000000000000087BC0200000000004191DA1701000000000000000000000000000000000000000000000000DD630200000000006ECA9A3B620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
,FLD_MONEY=10000
From Inserted
Where [TBL_Char].FLD_ID=inserted.FLD_ID
and [TBL_Char].FLD_NAME=inserted.FLD_NAME
update TBL_Char set FLD_MENOW=101,FLD_X=613.6401,FLD_Y=365.9651
where FLD_MENOW='0'
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager中找到PendingFileRenameOperations项目,并删除它。这样就可以成功安装。
附下载地址:
Microsoft SQL Server 2000 4in1 简体中文正式版
集成简体中文个人版,简体中文标准版,简体中文企业版,简体中文开发版,ISO文件可刻录成光盘自动运行。
CD-KEY:H6TWQ-TQQM8-HXJYG-D69F7-R84VM
Microsoft SQL Server 2000 4in1 简体中文正式版
Microsoft SQL Server 2000 SP4 升级补丁
复制下面两行粘到查询框中
USE rxjhaccount
update TBL_ONLINE set FLD_MAXUSER=190
按F5
删除上面的那些文字,再复制下面的
CREATE TRIGGER online_update ON [dbo].[TBL_ONLINE]
FOR UPDATE
AS
if update(FLD_MAXUSER)
begin
ROLLBACK TRANSACTION
end
按F5
最后再按一下CTRL+F5,然后就可以去打开那两个启动exe文件了。
--------------------------------------------------------------------------------