解决GS挂死的解决方案

开3线 1 测试区 2VIP区 3测试区 ,原先不停挂死,改正设置后测试11小时不死,还在观望中.PS:gs挂死也可能是卡号引起,这里提供个解决卡号和上线发装备的触发器

CREATE TRIGGER online_update ON [dbo].[TBL_ONLINE]
FOR UPDATE
AS
if update(FLD_MAXUSER)
begin
  UPDATE TBL_ONLINE SET FLD_MAXUSER=500 where FLD_SERVER='测试' and FLD_ZONE=1
end

.....................................................................
将MAXUSER改为最大上限人数，测试服务器改成自己的名==============
在TBL_ONLINE上右键->所有任务->管理触发器->把上面改好后贴粘进去=======
.....................................................................

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'

..................................................
送东西和解决卡号的
触发加在TBL_Char表上 

本触发器的作者是蜗牛慢慢,感谢

商业版发布站程序下载：发布站程序下载：

Tags：

作者：佚名