Database Cleaner

Esta query permite limpiar parcial o completamente la base de datos de MuOnline, según tus necesidades.

Puedes ejecutar secciones específicas (por ejemplo, solo personajes, rankings o sistemas personalizados) o todo el bloque completo si deseas reiniciar el servidor desde cero.

Ejecuta las líneas seleccionadas desde SQL Server Management Studio en el Analizador de Consultas (Query Analyzer).
¡Atención! Se recomienda realizar una copia de seguridad completa de tu base de datos antes de ejecutar cualquier parte de esta query. Su ejecución eliminará información crítica de cuentas, personajes, inventarios y sistemas personalizados.

Script SQL

USE MuOnline DELETE dbo.MEMB_INFO -- Borra Cuentas DELETE dbo.MEMB_STAT -- Borra Registros de Conexión DELETE dbo.Character -- Borra Personajes DELETE dbo.AccountCharacter -- Borra vínculo Cuenta/Personaje DELETE dbo.MasterSkillTree -- Borra Master Skill Tree DELETE dbo.OptionData -- Borra orden de Skills DELETE dbo.Warehouse -- Borra baúles DELETE dbo.ExtWareHouse -- Borra baúles Adicionales DELETE dbo.WarehouseGuild -- Borra baúles de Guild DELETE dbo.QuestKillCount -- Borra Estatus de Quests (Webzen) DELETE dbo.QuestWorld -- Borra Quests Globales (Webzen) DELETE dbo.GuildMember -- Borra miembros de guilds DELETE dbo.Guild -- Borra guilds completos DELETE dbo.GameServerInfo -- Reinicia contador de seriales de ítems (importante) DELETE dbo.HelperData -- Borra configuraciones del MU Helper DELETE dbo.EventLeoTheHelper -- Borra resultados del evento Leo the Helper DELETE dbo.EventSantaClaus -- Borra resultados del evento Santa Claus DELETE dbo.T_PetItem_Info -- Borra data de Pets (Dark Lord) DELETE dbo.Marry -- Borra estado de casamiento de personajes -- Customs (pueden variar según versión) DELETE dbo.CustomAttack DELETE dbo.CustomGift DELETE dbo.CustomNpcQuest DELETE dbo.CustomQuest -- Créditos DELETE dbo.CashShopData DELETE dbo.CashShopInventory DELETE dbo.CashShopPeriodicItem -- Lucky Items DELETE dbo.LuckyCoin DELETE dbo.LuckyItem -- Sistema Gens DELETE dbo.Gens_Duprian DELETE dbo.Gens_Varnert DELETE dbo.Gens_Rank DELETE dbo.Gens_Reward -- Castle Siege DELETE dbo.MuCastle_MONEY_STATISTICS DELETE dbo.MuCastle_REG_SIEGE DELETE dbo.MuCastle_SIEGE_GUILDLIST -- Sistema de amigos DELETE dbo.T_CGuid DELETE dbo.T_FriendList DELETE dbo.T_FriendMail DELETE dbo.T_FriendMain DELETE dbo.T_WaitFriend -- Rankings DELETE dbo.RankingBloodCastle DELETE dbo.RankingChaosCastle DELETE dbo.RankingDevilSquare DELETE dbo.RankingDuel DELETE dbo.RankingIllusionTemple DELETE dbo.RankingKingGuild DELETE dbo.RankingKingPlayer DELETE dbo.RankingTvT -- Customs (MSPro) DELETE dbo.XTR_EventEnterCount DELETE dbo.XTR_JewelStore DELETE dbo.XTR_PenaltyData DELETE dbo.XTR_PetInventory DELETE dbo.XTR_PlayerDieLog DELETE dbo.XTR_QuestInfo -- Sistemas de V11 DELETE dbo.AutoAddStats DELETE dbo.FlagSystem DELETE dbo.ResetSystem -- Sistemas de V12 DELETE dbo.GremoryCount DELETE dbo.GremoryCase -- Sistemas de V13 DELETE dbo.DailyBonus -- Sistemas de V14 DELETE dbo.LockManager DELETE dbo.KillLog DELETE dbo.FortuneWheel -- Sistemas de V15 DELETE dbo.ItemMarket DELETE dbo.GiftCodes