Resetear y limpiar a 0 todas las cuentas del Server MU

CreadorMU

Curious
gemgem
Administrator
Programmer C++
3D Designer
Special Effects
Marketing
WebMaster
Linux OS
Android Dev
A.I Trainer

Reputation:

Con este SQL Query se puede formatear todas las cuentas a 0, y así empezar de nuevo.

SQL:
PASO 1:

USE MuOnline
DELETE MEMB_INFO
DELETE CHARACTER
DELETE MEMB_STAT
DELETE warehouse
DELETE ExtWareHouse
DELETE GuildMember
DELETE Guild
DELETE AccountCharacter
DELETE ExtWareHouse
DELETE GameServerInfo
DELETE MuCastle_MONEY_STATISTICS
DELETE MuCastle_REG_SIEGE
DELETE MuCastle_SIEGE_GUILDLIST
DELETE T_FriendList
DELETE T_FriendMail
DELETE T_FriendMain
DELETE T_PetItem_Info
DELETE T_WaitFriend


PASO 2:


Update MasterSkillTree
set [MasterPoint] = MasterLevel,
MasterSkill = 0


PASO 3:

Update dbo.character
set ResetCount = '0'
 
Back
Top