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).
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