[Request] Wipe in SQL

[Yolo143]

The title said

Can I request to the Wipe injection in sql, I saw that before but I can't search it anymore thank you

[Wezzy_Dev]

Originally Posted by Yolo143

The title said

Can I request to the Wipe injection in sql, I saw that before but I can't search it anymore thank you

Here you go.
Copy the content below and go to sql new query and paste it and then execute it

 Spoiler

USE ACCOUNT_DBF
GO
DELETE FROM PCZoneIP
DELETE FROM PCZone
DELETE FROM tblEventRecommend
DELETE FROM tblEvent_Board_Provide
DELETE FROM Event_PCZone_20091027_01
DELETE FROM Event_PCZone_20091027
DELETE FROM CashHistory
DELETE FROM AccountPlay
DELETE FROM ACCOUNT_TBL_DETAIL
DELETE FROM ACCOUNT_TBL
GO
USE CHARACTER_01_DBF
GO
DELETE FROM tblCouple_deleted
DELETE FROM tblCouple
DELETE FROM tblCampus
DELETE FROM tblAccountList
DELETE FROM TB_VALENTINE_EVENT
DELETE FROM TAX_INFO_TBL
DELETE FROM tblCombatInfo
DELETE FROM tblChangeBankPW
DELETE FROM MAIL_TBL
DELETE FROM PARTY_TBL
DELETE FROM RAINBOWRACE_TBL
DELETE FROM QUEST_TBL
DELETE FROM SECRET_ROOM_MEMBER_TBL
DELETE FROM SKILLINFLUENCE_TBL
DELETE FROM SKILL_TBL
DELETE FROM SECRET_ROOM_TBL
DELETE FROM TASKBAR_TBL
DELETE FROM TASKBAR_ITEM_TBL
DELETE FROM TAG_TBL
DELETE FROM tblSkillPoint
DELETE FROM tblRestPoint
DELETE FROM tblRemoveItemFromGuildBank
DELETE FROM tblQuizAnswer
DELETE FROM tblQuiz
DELETE FROM tblPropose
DELETE FROM tblPocketExt
DELETE FROM tblPocket
DELETE FROM tblMessenger
DELETE FROM tblMaster_all
DELETE FROM tblLordSkill
DELETE FROM tblLordEvent
DELETE FROM tblLordElector
DELETE FROM tblLordElection
DELETE FROM tblLordCandidates
DELETE FROM tblLord
DELETE FROM tblLogout_Penya_Diff_Log
DELETE FROM tblLogout_Penya
DELETE FROM tblHousing_Visit
DELETE FROM tblHousing
DELETE FROM tblGuildHouse_Furniture
DELETE FROM tblGuildHouse
DELETE FROM tblFunnyCoin
DELETE FROM tblEvent_Board_Provide
DELETE FROM tblElection
DELETE FROM tblCouplePlayer_deleted
DELETE FROM CHARACTER_TBL_validity_check
DELETE FROM CHARACTER_TBL_penya_check
DELETE FROM CHARACTER_TBL_DEL
DELETE FROM CHARACTER_TBL
DELETE FROM CARD_CUBE_TBL
DELETE FROM BILING_ITEM_TBL
DELETE FROM BANK_TBL
DELETE FROM BANK_EXT_TBL
DELETE FROM armor
DELETE FROM COMPANY_TBL
DELETE FROM GUILD_MEMBER_TBL
DELETE FROM GUILD_COMBAT_1TO1_TENDER_TBL
DELETE FROM GUILD_COMBAT_1TO1_BATTLE_TBL
DELETE FROM GUILD_COMBAT_1TO1_BATTLE_PERSON_TBL
DELETE FROM GUILD_BANK_TBL
DELETE FROM GUILD_BANK_EXT_TBL
DELETE FROM tblCouplePlayer
DELETE FROM tblCampusMember
DELETE FROM EVIDANCE
DELETE FROM GUILD_QUEST_TBL
DELETE FROM tblCombatJoinGuild
DELETE FROM level
DELETE FROM JOB_SKILL_TBL
DELETE FROM tblCombatJoinPlayer
DELETE FROM ITEM_SEND_TBL
DELETE FROM ITEM_REMOVE_TBL
DELETE FROM INVENTORY_TBL
DELETE FROM INVENTORY_EXT_TBL
DELETE FROM GUILD_WAR_TBL
DELETE FROM GUILD_TBL
DELETE FROM GUILD_VOTE_TBL
DELETE FROM MESSENGER_TBL
DELETE FROM TAX_DETAIL_TBL
DELETE FROM WANTED_TBL
GO
USE LOGGING_01_DBF
GO
DELETE FROM LOG_DEATH_TBL
DELETE FROM LOG_CHARACTER_TBL
DELETE FROM LOG_BILLING_ITEM_TBL
DELETE FROM CHARACTER_TBL
DELETE FROM LOG_GUILD_SERVICE_TBL
DELETE FROM LOG_GUILD_DISPERSION_TBL
DELETE FROM LOG_GUILD_BANK_TBL
DELETE FROM LOG_GAMEMASTER_TBL
DELETE FROM LOG_SKILL_FREQUENCY_TBL
DELETE FROM LOG_RESPAWN_TBL
DELETE FROM LOG_QUEST_TBL
DELETE FROM LOG_PK_PVP_TBL
DELETE FROM LOG_LOGIN_TBL
DELETE FROM LOG_LEVELUP_TBL
DELETE FROM LOG_ITEM_TBL
DELETE FROM tblTradeLog
DELETE FROM tblTradeItemLog
DELETE FROM tblTradeDetailLog
DELETE FROM tblSystemErrorLog
DELETE FROM tblSkillPointLog
DELETE FROM tblQuizUserLog
DELETE FROM tblQuizLog
DELETE FROM tblQuizAnswerLog
DELETE FROM tblQuestLog
DELETE FROM tblPetLog
DELETE FROM tblLogExpBox
DELETE FROM tblGuildHouseLog
DELETE FROM tblGuildHouse_FurnitureLog
DELETE FROM tblChangeNameLog
DELETE FROM tblChangeNameHistoryLog
DELETE FROM tblCampusLog
DELETE FROM tblCampus_PointLog
DELETE FROM LOG_USER_CNT_TBL
DELETE FROM LOG_ITEM_SEND_TBL
DELETE FROM LOG_ITEM_REMOVE_TBL
DELETE FROM LOG_ITEM_EVENT_TBL
DELETE FROM LOG_INS_DUNGEON_TBL
DELETE FROM LOG_HONOR_TBL
DELETE FROM LOG_GUILD_WAR_TBL
DELETE FROM LOG_GUILD_TBL
DELETE FROM LOG_UNIQUE_TBL
DELETE FROM LOG_SVRDOWN_TBL
GO
USE RANKING_DBF
GO
DELETE FROM RANKING_TBL

[Sedrika]

You should also shrink the database after doing that at least.

[xTwiLightx]

Originally Posted by Sedrika

You should also shrink the database after doing that at least.

You'll better go with removing the old database files and using scripts to create a new one. Shrinking is bad use-case, since it causes a lot fragmentation.

Also, truncate table should be used instead of delete from.