Wipeout character & accounts

[World.o.Flyff]

How to wipeout all the acount and character on sql?

[Velmore]

Delete the database and insert a new.

[World.o.Flyff]

Originally Posted by Velmore

Delete the database and insert a new.

O.o i put alot of database of my systems and i will delete? or just comment to say you are pro? all of your comments are not direct to a question so keep quite if you don't know those problem.

sory for my bad english.!

[Velmore]

what you want to know? how to delete the database?
there is a other way you can delete every value in the database and have fun for hours

[lanzelord996]

Velmore, for what you think is the "TRUNCATE TABLE" command?
Use my query, if there are some errors, then delete the lines where the error comes from ^^

My Query:

 Spoiler

USE ACCOUNT_DBF
TRUNCATE TABLE ACCOUNT_TBL ;
TRUNCATE TABLE ACCOUNT_TBL_DETAIL ;
TRUNCATE TABLE AccountPlay ;
TRUNCATE TABLE CashHistory ;
TRUNCATE TABLE Event_PCZone_20091027 ;
TRUNCATE TABLE Event_PCZone_20091027_01 ;
TRUNCATE TABLE PCZone ;
TRUNCATE TABLE PCZoneIP ;
TRUNCATE TABLE tblEvent_Board_Provide ;
TRUNCATE TABLE tblEventRecommend ;
GO

USE CHARACTER_01_DBF
TRUNCATE TABLE armor ;
TRUNCATE TABLE BANK_EXT_TBL ;
TRUNCATE TABLE BANK_TBL ;
TRUNCATE TABLE BILING_ITEM_TBL ;
TRUNCATE TABLE CARD_CUBE_TBL ;
TRUNCATE TABLE CHARACTER_TBL ;
TRUNCATE TABLE CHARACTER_TBL_penya_check ;
TRUNCATE TABLE CHARACTER_TBL_validity_check ;
TRUNCATE TABLE COMPANY_TBL ;
TRUNCATE TABLE EVIDANCE ;
TRUNCATE TABLE GUILD_BANK_EXT_TBL ;
TRUNCATE TABLE GUILD_BANK_TBL ;
TRUNCATE TABLE GUILD_MEMBER_TBL ;
TRUNCATE TABLE GUILD_QUEST_TBL ;
TRUNCATE TABLE GUILD_TBL ;
TRUNCATE TABLE GUILD_VOTE_TBL ;
TRUNCATE TABLE GUILD_WAR_TBL ;
TRUNCATE TABLE INVENTORY_EXT_TBL ;
TRUNCATE TABLE INVENTORY_TBL ;
TRUNCATE TABLE ITEM_REMOVE_TBL ;
TRUNCATE TABLE ITEM_SEND_TBL ;
TRUNCATE TABLE JOB_SKILL_TBL ;
TRUNCATE TABLE MAIL_TBL ;
TRUNCATE TABLE MESSENGER_TBL ;
TRUNCATE TABLE PARTY_TBL ;
TRUNCATE TABLE QUEST_TBL ;
TRUNCATE TABLE RAINBOWRACE_TBL ;
TRUNCATE TABLE SECRET_ROOM_MEMBER_TBL ;
TRUNCATE TABLE SECRET_ROOM_TBL ;
TRUNCATE TABLE SKILL_TBL ;
TRUNCATE TABLE SKILLINFLUENCE_TBL ;
TRUNCATE TABLE TAG_TBL ;
TRUNCATE TABLE TASKBAR_ITEM_TBL ;
TRUNCATE TABLE TASKBAR_TBL ;
TRUNCATE TABLE TAX_DETAIL_TBL ;
TRUNCATE TABLE TAX_INFO_TBL ;
TRUNCATE TABLE TB_VALENTINE_EVENT ;
TRUNCATE TABLE tblAccountList ;
TRUNCATE TABLE tblChangeBankPW ;
TRUNCATE TABLE tblCouple_deleted ;
TRUNCATE TABLE tblCouplePlayer ;
TRUNCATE TABLE tblCouplePlayer_deleted ;
TRUNCATE TABLE tblElection ;
TRUNCATE TABLE tblEvent_Board_Provide ;
TRUNCATE TABLE tblFunnyCoin ;
TRUNCATE TABLE tblGuildHouse ;
TRUNCATE TABLE tblGuildHouse_Furniture
TRUNCATE TABLE tblHousing ;
TRUNCATE TABLE tblHousing_Visit ;
TRUNCATE TABLE tblLogout_Penya ;
TRUNCATE TABLE tblLogout_Penya_Diff_Log ;
TRUNCATE TABLE tblLord ;
TRUNCATE TABLE tblLordCandidates ;
TRUNCATE TABLE tblLordElection ;
TRUNCATE TABLE tblLordElector ;
TRUNCATE TABLE tblLordEvent ;
TRUNCATE TABLE tblLordSkill ;
TRUNCATE TABLE tblMaster_all ;
TRUNCATE TABLE tblMessenger ;
TRUNCATE TABLE tblPocket ;
TRUNCATE TABLE tblPocketExt ;
TRUNCATE TABLE tblPropose ;
TRUNCATE TABLE tblQuiz ;
TRUNCATE TABLE tblQuizAnswer ;
TRUNCATE TABLE tblRemoveItemFromGuildBank ;
TRUNCATE TABLE tblRestPoint ;
TRUNCATE TABLE tblSkillPoint ;
TRUNCATE TABLE WANTED_TBL ;
GO

USE LOGGING_01_DBF
TRUNCATE TABLE CHARACTER_TBL ;
TRUNCATE TABLE LOG_BILLING_ITEM_TBL ;
TRUNCATE TABLE LOG_CHARACTER_TBL ;
TRUNCATE TABLE LOG_DEATH_TBL ;
TRUNCATE TABLE LOG_GAMEMASTER_TBL ;
TRUNCATE TABLE LOG_GUILD_BANK_TBL ;
TRUNCATE TABLE LOG_GUILD_DISPERSION_TBL ;
TRUNCATE TABLE LOG_GUILD_SERVICE_TBL ;
TRUNCATE TABLE LOG_GUILD_TBL ;
TRUNCATE TABLE LOG_GUILD_WAR_TBL ;
TRUNCATE TABLE LOG_HONOR_TBL ;
TRUNCATE TABLE LOG_INS_DUNGEON_TBL ;
TRUNCATE TABLE LOG_ITEM_EVENT_TBL ;
TRUNCATE TABLE LOG_ITEM_REMOVE_TBL ;
TRUNCATE TABLE LOG_ITEM_SEND_TBL ;
TRUNCATE TABLE LOG_ITEM_TBL ;
TRUNCATE TABLE LOG_LEVELUP_TBL ;
TRUNCATE TABLE LOG_LOGIN_TBL ;
TRUNCATE TABLE LOG_PK_PVP_TBL ;
TRUNCATE TABLE LOG_QUEST_TBL ;
TRUNCATE TABLE LOG_RESPAWN_TBL ;
TRUNCATE TABLE LOG_SKILL_FREQUENCY_TBL ;
TRUNCATE TABLE LOG_SVRDOWN_TBL ;
TRUNCATE TABLE LOG_UNIQUE_TBL ;
TRUNCATE TABLE LOG_USER_CNT_TBL ;
TRUNCATE TABLE tblCampus_PointLog ;
TRUNCATE TABLE tblCampusLog ;
TRUNCATE TABLE tblChangeNameHistoryLog ;
TRUNCATE TABLE tblChangeNameLog ;
TRUNCATE TABLE tblGuildHouse_FurnitureLog ;
TRUNCATE TABLE tblGuildHouseLog ;
TRUNCATE TABLE tblGuildHouseLog ;
TRUNCATE TABLE tblLogExpBox ;
TRUNCATE TABLE tblPetLog ;
TRUNCATE TABLE tblQuestLog ;
TRUNCATE TABLE tblQuizAnswerLog ;
TRUNCATE TABLE tblQuizLog ;
TRUNCATE TABLE tblQuizUserLog ;
TRUNCATE TABLE tblSkillPointLog ;
TRUNCATE TABLE tblSystemErrorLog ;
TRUNCATE TABLE tblTradeDetailLog ;
TRUNCATE TABLE tblTradeItemLog ;
TRUNCATE TABLE tblTradeLog ;
GO

[©ross]

@lanzelord Das Script enthält spalten die es in der Offi DB NICHT giebt.
(hab ich dir schonmal in Skype gesagt)

Berichtige das, dann ist es ein nutzbares Script.

[alfredico]

USE [DB_NAME]

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO
EXEC sp_MSForEachTable 'DELETE FROM ?'
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
GO

You have to restore BASE_VALUE_TBL on CHARACTER_01_DBF