把红名关起来

把红名关起来
CREATE TRIGGER [Restrict_map] ON [dbo].[Character]
after update

as

Update [Character] set
[Character].MapNumber=6
[Character].MapPosX=80
[Character].MapPosY=60
From Inserted
Where Inserted.PKlive>5 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name

当PKlive>5的时候就把人物传送去6号地图坐标为80,60的地方!