封号/解封
update MEMB_INFO set bloc_code = 1 where memb___id='帐号' ===>>> 大于0 封号 =0 解封
创建账号
insert into dbo.MEMB_INFO(memb___id, memb__pwd,memb_name,sno__numb,bloc_code,ctl1_code) values(账号, 密码,'Name','随机',0,0); 建号
N天未登录账号查询
SELECT DATEDIFF(day, DisConnectTM, GETDATE()) AS days_diff
FROM MEMB_STAT;
角色人物加属性点
update Character set Energy=32000 where Name ='角色名' 加点
攻城日志清理
USE [MuOnline]
truncate TABLE MuCastle_DATA