奇迹数据库MUONLINE常用的一些整理好的命令:

delete from character where name='角色名称' 删除角色

update character set ctlcode=1 where accountid='帐号' 封

停命令

select * from character where name='角色名称' 查找角色帐号

select * from character where accountid='帐号' 查找帐号角色

select * from MEMB_INFO where memb___id='帐号' 查找帐号的

PASSWORD

select * from MEMB_INFO where Mail_addr='abc@abc.com' 查询用本邮

件的注册的角色

select * from warehouse where AccountID='帐号' 查询仓库密码

select * from character where Strength>'6000' 变态查询

Strength（替换成其他属性也可以）=力量

delete character where accountid='帐号' 删除该帐号所有角色

delete memb_info where memb___id='帐号' 删除帐号命令

这个是SQL中添加法师全魔法的，包括0.98的3种新魔法，不过......

update character set

magiclist=0x1100000400000b000009000001000005000002000003000006000

00a00000800000c00000700000e00001000000d00000f00002600002700002800

00
where name='角色名称'

请大家切记本站:奇迹私服大全 HTTP://WWW.530IDC.COM