TRUNCATE WIPE DATABASE LOUIS V34

Started by PowerNet, Aug 26, 2023, 07:05 PM

PowerNet

Esto lo arme en base a los Files Louis, ya que muchos nos complicamos la vida al querer reiniciar todo y no esta todo como queremos.
Espero que les sirva...
Creo que ya todos saben poner la función "TRUNCATE" en nuestro SQL.
Esto se hace siempre haciendo una nueva consulta en el sql.


Delete from Character
TRUNCATE TABLE "AccountCharacter"
TRUNCATE TABLE "BlockHardwareID"
TRUNCATE TABLE "BlockIP"
TRUNCATE TABLE "CashLog"
TRUNCATE TABLE "CashShopData"
TRUNCATE TABLE "CashShopInventory"
TRUNCATE TABLE "CashShopPeriodicItem"
TRUNCATE TABLE "CustomAttack"
TRUNCATE TABLE "CustomAttackOffline"
TRUNCATE TABLE "CustomBattlePassData"
TRUNCATE TABLE "CustomBattlePassReward"
TRUNCATE TABLE "CustomCommandDelay"
TRUNCATE TABLE "CustomDailyReward"
TRUNCATE TABLE "CustomFlag"
TRUNCATE TABLE "CustomGift"
TRUNCATE TABLE "CustomItemBank"
TRUNCATE TABLE "CustomJewelBank"
TRUNCATE TABLE "CustomLuckyWheel"
TRUNCATE TABLE "CustomNpcQuest"
TRUNCATE TABLE "CustomQuest"
TRUNCATE TABLE "CustomSkin"
TRUNCATE TABLE "CustomStore"
TRUNCATE TABLE "CustomStoreOffline"
TRUNCATE TABLE "EventAuction"
TRUNCATE TABLE "EventAuctionReward"
TRUNCATE TABLE "EventEntryCount"
TRUNCATE TABLE "EventLeoTheHelper"
TRUNCATE TABLE "EventSantaClaus"
TRUNCATE TABLE "ExtWarehouse"
TRUNCATE TABLE "GameServerInfo"
TRUNCATE TABLE "Gens_Duprian"
TRUNCATE TABLE "Gens_Reward"
TRUNCATE TABLE "Gens_Varnert"
TRUNCATE TABLE "Gens_Rank"
TRUNCATE TABLE "GremoryCase"
TRUNCATE TABLE "Guild"
TRUNCATE TABLE "GuildMember"
TRUNCATE TABLE "HelperData"
TRUNCATE TABLE "ItemLog"
TRUNCATE TABLE "LOG_CREDITOS"
TRUNCATE TABLE "LuckyCoin"
TRUNCATE TABLE "LuckyItem"
TRUNCATE TABLE "Marry"
TRUNCATE TABLE "MasterSkillTree"
TRUNCATE TABLE "MEMB_INFO"
TRUNCATE TABLE "MEMB_STAT"
TRUNCATE TABLE "MK_Server"
TRUNCATE TABLE "OptionData"
TRUNCATE TABLE "PShopItemValue"
TRUNCATE TABLE "QuestKillCount"
TRUNCATE TABLE "QuestWorld"
TRUNCATE TABLE "RankingBattleRoyale"
TRUNCATE TABLE "RankingBloodCastle"
TRUNCATE TABLE "RankingCastleSiegeKills"
TRUNCATE TABLE "RankingCastleSiegeTime"
TRUNCATE TABLE "RankingChaosCastle"
TRUNCATE TABLE "RankingDevilSquare"
TRUNCATE TABLE "RankingDuel"
TRUNCATE TABLE "RankingGvG"
TRUNCATE TABLE "RankingIllusionTemple"
TRUNCATE TABLE "RankingKingGuild"
TRUNCATE TABLE "RankingKingPlayer"
TRUNCATE TABLE "RankingPvpChampionship"
TRUNCATE TABLE "RankingTvT"
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 "WarehouseGuild"

Créditos: samsunggon
  •