快速封号的方法 推荐
封号
use muonline
UPDATE [MuOnline].[dbo].[Character]
SET [CtlCode]=1
WHERE Name=名字 --------------------->查询分析启里面执行
解封
use muonline
UPDATE [MuOnline].[dbo].[Character]
SET [CtlCode]=0
WHERE Name=名字
----------------------------------------------------------这个是删档的
先打开sql下MuOnlie数据库,新建一个存储过程,内容如下:----------->在查询分析启里面执行
CREATE PROCEDURE [Delete_ID]
@c_UserCode VARCHAR(100) --人员代码
AS
SET NOCOUNT ON
delete MEMB_INFO where memb___id = @c_UserCode
delete AccountCharacter where id = @c_UserCode
delete Character where AccountID = @c_UserCode
delete VI_CURR_INFO where memb___id = @c_UserCode
delete warehouse where AccountID = @c_UserCode
delete Guild where G_Master = @c_UserCode
delete GuildMember where Name = @c_UserCo
RETURN
GO
然后保存即可.
好了,先确定外挂人物的帐号(具体方法就不用说了吧),然后打开sql查询分析器,执行以下语句:
exec Delete_ID 玩家帐号
|
