Autor Topic: Formatear Base de Datos  (Visto 900 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline darkjano on: September 04, 2017, 05:45:36 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 623
  • Gracias recibida: 230
  • cl
Que tal gente, vengo a aportarles este pequeño script, es algo sencillo pero a mas de alguno puede servirle.

Sirve para limpiar la base de datos, eliminar personajes, cuentas, etc..

Citar
truncate table AccountCharacter
truncate table CashShopData
truncate table CashShopInventory
truncate table CashShopPeriodicItem
truncate table Character
truncate table EventLeoTheHelper
truncate table Evento_Resets
truncate table EventSantaClaus
truncate table Guild
truncate table GuildMember
truncate table HelperData
truncate table LuckyCoin
truncate table LuckyItem
truncate table MasterSkillTree
truncate table QuestKillCount
truncate table QuestWorld
truncate table RankingBloodCastle
truncate table RankingChaosCastle
truncate table RankingDevilSquare
truncate table RankingDuel
truncate table RankingIllusionTemple
truncate table T_CGuid
truncate table T_FriendList
truncate table T_FriendMail
truncate table T_FriendMain
truncate table T_PetItem_Info
truncate table T_WaitFriend
truncate table warehouse
truncate table MEMB_CREDITS
truncate table MEMB_STAT
truncate table MUCore_Ban
truncate table MUCore_Change_Passwords
truncate table MUCore_PayPal_Donate_Transactions
truncate table MUCore_Shop_Logs
truncate table MUCore_temp_passwords
truncate table MEMB_INFO

En caso que quieran conservar las cuentas eliminen la linea que marque en rojo

Gracias:


Offline Tauro14 #1 on: August 01, 2019, 09:22:46 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 208
  • Gracias recibida: 1163
  • ar
hola borra los baules tbm y stores?

Offline adryan #2 on: August 06, 2019, 02:44:54 PM

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 49
  • Gracias recibida: 5
  • ar
hola borra los baules tbm y stores?
yo use esta y borra todo
USE MuOnline
DELETE MEMB_INFO
DELETE CHARACTER
DELETE MEMB_STAT
DELETE warehouse
DELETE GuildMember
DELETE Guild
DELETE AccountCharacter
DELETE ExtWareHouse
DELETE VI_CURR_INFO
DELETE GameServerInfo
DELETE MuCastle_MONEY_STATISTICS
DELETE MuCastle_REG_SIEGE
DELETE MuCastle_SIEGE_GUILDLIST
DELETE BotPet
DELETE ExtendedWarehouse
DELETE T_MU2003_DATA
DELETE T_FriendList
DELETE T_FriendMail
DELETE T_FriendMain
DELETE T_PeriodItem
DELETE T_PetItem_Info
DELETE T_Regcount_Check
DELETE T_WaitFriend
DELETE Admin

Gracias:


 

Related Topics

  Subject / Started by Replies Last post
9 Replies
998 Views
Last post September 04, 2016, 09:19:42 PM
by Odisk
0 Replies
282 Views
Last post May 07, 2018, 02:50:26 PM
by Yalc
2 Replies
346 Views
Last post May 16, 2018, 09:40:43 PM
by niahinti
1 Replies
242 Views
Last post June 14, 2018, 01:56:25 PM
by josexluis
8 Replies
475 Views
Last post August 31, 2018, 12:57:05 PM
by Dariox84