热血江湖卡号手把手教你怎么解决

热血江湖解决卡号问题，在服务端还没有运行的时候。

点工具→在点分析查询器 运用以下命令（这样就可以把命令增加到触发器上了）

CREATE TRIGGER Exit_update ON [dbo].[TBL_Char]

AFTER UPDATE

AS

BEGIN

SET NOCOUNT ON

update TBL_Char

set FLD_MENOW = ‘101’

,[TBL_Char].FLD_X = ‘511’

,[TBL_Char].FLD_Y = ‘1028’

FROM Inserted

WHERE TBL_Char.FLD_NAME = Inserted.FLD_NAME and Inserted.FLD_Y=’0′

end

以下命令在 查询里（没有分析哦 就查询里就可以了）

SELECT FLD_LEVEL AS Expr1, FLD_NAME AS Expr2, FLD_ID AS Expr3, TBL_Char.*

FROM TBL_Char

WHERE (FLD_NAME = ‘角色名) ←这里写上角色名称（对付单一角色使用）

SELECT FLD_LEVEL AS Expr1, FLD_NAME AS Expr2, FLD_ID AS Expr3, TBL_Char.*

FROM TBL_Char

WHERE (FLD_Y = ‘0’) 查询Y坐标为0的用户