|
封号 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 玩家帐号
|