- 最后登录
- 2023-3-26
- 在线时间
- 74 小时
- 注册时间
- 2022-10-4
- 阅读权限
- 150
- 精华
- 0
- 积分
- 7580
- 帖子
- 2414
 
|
发表于 2022-10-8 12:20:49
|显示全部楼层
大家都知道,在奇迹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
当然了,在清理数据库的时候,需要清理两次,才能保证数据库清理得更佳干净,还不快去试试? |
|