当前位置 :| 主页>架设技术>

快速清理奇迹mu数据库账号代码!

来源: 作者: 点击:
快速清理奇迹mu数据库账号代码!
大家都知道,在奇迹mu架设好后,都需要进行一段时间的测试,当然测试完需要正式开服的时候,就需要清空数据库里测试玩家的信息,好在开服的时候做到公平竞争,但你去网站后台清理账号,一个一个的清理速度又过慢,绝大多数GM又不懂得该如何处理数据库的问题,今天无度就给大家发一个快速清理数据库账号的代码。

use Muonline
delete from MEMB_STAT
delete from MEMB_INFO
delete from Character
delete from AccountCharacter
delete from warehouse
delete from BFB_SBK
delete from VI_CURR_INFO
delete from ExtWareHouse
delete from GuildMember
delete from Guild
delete from ItemLog
delete from MuCastle_DATA
delete from OptionData
delete from T_CGuid
delete from T_FriendList
delete from T_FriendMail
delete from T_FriendMain
delete from T_MU2003_EVENT
delete from T_PetItem_Info
delete from T_RegCount_Check
delete from T_WaitFriend
delete from T_MasterLevelSystem

当然了,在清理数据库的时候,需要清理两次,才能保证数据库清理得更佳干净,还不快去试试?