[Request] Wipe everything

~~khemomo~~ · 12/11/2017, 10:28

How can I wipe everything safely, using SQL code. I saw a SQL wipe before but I tried it, I got an error something like "Name is already in use".

So if you don't mind can you please give me a clean SQL(data) Wipe? Thank you

xTwiLightx · 12/11/2017, 12:35

Code:

USE CHARACTER_01_DBF
GO

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'DELETE FROM ?'
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'DBCC CHECKIDENT (?, RESEED, 1)'
GO

Better backup your BASE_VALUE_TBL, since you'll need it's data for new characters.

~~khemomo~~ · 12/14/2017, 10:23

Quote:
Originally Posted by xTwiLightx
Code:
USE CHARACTER_01_DBF
GO

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'DELETE FROM ?'
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'DBCC CHECKIDENT (?, RESEED, 1)'
GO
Better backup your BASE_VALUE_TBL, since you'll need it's data for new characters.

I just tried to copy and paste this to my sql as new query but it says

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.

What does it mean?

xTwiLightx · 12/14/2017, 12:06

Quote:

Originally Posted by khemomo

I just tried to copy and paste this to my sql as new query but it says

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.

What does it mean?

My fault.

Code:

EXEC sp_MSForEachTable "DBCC CHECKIDENT ('?', RESEED, 1)"

~~khemomo~~ · 12/15/2017, 01:01

Quote:
Originally Posted by xTwiLightx
My fault.
Code:
EXEC sp_MSForEachTable "DBCC CHECKIDENT ('?', RESEED, 1)"

Dude, sorry for giving you another question

Do I just need to copy and paste this as new query and execute, or do I need to Execute this too?

Spoiler

Code:

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

Because I got this error while executing the one that you've given to me

Spoiler

Code:

Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'TB_VALENTINE_EVENT' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAX_INFO_TBL' does not contain an identity column.
Checking identity information: current identity value '366'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblChangeBankPW' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'MAIL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'PARTY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'RAINBOWRACE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'QUEST_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SECRET_ROOM_MEMBER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SKILLINFLUENCE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SKILL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SECRET_ROOM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TASKBAR_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TASKBAR_ITEM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAG_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblSkillPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblRestPoint' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblQuizAnswer' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblPropose' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblPocketExt' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblPocket' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblMessenger' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblMaster_all' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordEvent' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordElector' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordElection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordCandidates' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLord' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblLogout_Penya' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblHousing_Visit' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblHousing' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblGuildHouse_Furniture' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblGuildHouse' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblEvent_Board_Provide' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblElection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouplePlayer_deleted' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_validity_check' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_penya_check' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_DEL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CARD_CUBE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BILING_ITEM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BASE_VALUE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BANK_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BANK_EXT_TBL' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'COMPANY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_MEMBER_TBL' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'GUILD_COMBAT_1TO1_BATTLE_PERSON_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_BANK_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_BANK_EXT_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouplePlayer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'PlayerWar_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCampusMember' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'EVIDANCE' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_QUEST_TBL' does not contain an identity column.
Checking identity information: current identity value '1363'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'level' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCombatJoinPlayer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'JOB_SKILL_TBL' does not contain an identity column.
Checking identity information: current identity value '2304'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'INVENTORY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'INVENTORY_EXT_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_WAR_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_VOTE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'MESSENGER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAX_DETAIL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'WANTED_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouple_deleted' does not contain an identity column.
Checking identity information: current identity value '850'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblCampus' does not contain an identity column.

Thank you for your response

~~Zeljian~~ · 12/15/2017, 01:53

i have a release in the release section just copy and paste in the new query and execute.,

~~khemomo~~ · 12/15/2017, 07:33

Quote:

Originally Posted by Zeljian

i have a release in the release section just copy and paste in the new query and execute.,

Yeah and then after that when you create a character it will go and said name is already in use even if its not.

xTwiLightx · 12/15/2017, 16:33

Quote:

Originally Posted by khemomo

Dude, sorry for giving you another question

Do I just need to copy and paste this as new query and execute, or do I need to Execute this too?

Spoiler

Code:

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

Because I got this error while executing the one that you've given to me

Spoiler

Code:

Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'TB_VALENTINE_EVENT' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAX_INFO_TBL' does not contain an identity column.
Checking identity information: current identity value '366'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblChangeBankPW' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'MAIL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'PARTY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'RAINBOWRACE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'QUEST_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SECRET_ROOM_MEMBER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SKILLINFLUENCE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SKILL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'SECRET_ROOM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TASKBAR_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TASKBAR_ITEM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAG_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblSkillPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblRestPoint' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblQuizAnswer' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblPropose' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblPocketExt' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblPocket' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblMessenger' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblMaster_all' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordEvent' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordElector' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordElection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLordCandidates' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblLord' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblLogout_Penya' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblHousing_Visit' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblHousing' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblGuildHouse_Furniture' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblGuildHouse' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblEvent_Board_Provide' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblElection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouplePlayer_deleted' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_validity_check' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_penya_check' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL_DEL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CHARACTER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'CARD_CUBE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BILING_ITEM_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BASE_VALUE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BANK_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'BANK_EXT_TBL' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'COMPANY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_MEMBER_TBL' does not contain an identity column.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'GUILD_COMBAT_1TO1_BATTLE_PERSON_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_BANK_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_BANK_EXT_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouplePlayer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'PlayerWar_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCampusMember' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'EVIDANCE' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_QUEST_TBL' does not contain an identity column.
Checking identity information: current identity value '1363'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'level' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCombatJoinPlayer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'JOB_SKILL_TBL' does not contain an identity column.
Checking identity information: current identity value '2304'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'INVENTORY_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'INVENTORY_EXT_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_WAR_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'GUILD_VOTE_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'MESSENGER_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'TAX_DETAIL_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'WANTED_TBL' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tblCouple_deleted' does not contain an identity column.
Checking identity information: current identity value '850'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 3
'tblCampus' does not contain an identity column.

Thank you for your response

Quote:

Msg 7997, Level 16, State 1, Line 3
'tblCouple_deleted' does not contain an identity column.

Lines like this one are just for information purpose. The script tries to uncheck indexes on every table - if a table doesn't have one, this line will appear.

You'll have to copy my script and replace

Code:

USE CHARACTER_01_DBF

by

Code:

USE ACCOUNT_DBF

if you also want to wipe account data and

Code:

USE LOGGING_01_DBF

for the logging data - basically, the script with all single "DELETE FROM" statements does the same as my does; except the fact that IDENTITY columns are being reset in mine.

~~khemomo~~ · 12/15/2017, 23:44

I'am curious how they made a script for database. I tried on my ACCOUNT_DBF > Script Database as > CREATE to > New Query Editor Window.

but its incomplete I mean all my custome code in character STR or something in account is cannot be seen.

Something just like this [Code is being cut to make it short]

[ATTACH]Here's the sample what I want to do to my Database[/ATTACH]

Spoiler

Code:

USE [master]
--RAISERROR( 'Step 1: Clearing backup history',0,1) WITH NOWAIT
GO
EXEC msdb.dbo.sp_delete_database_backuphistory [MENTION=515436]database[/MENTION]_name = N'CHARACTER_01_DBF'
GO
EXEC msdb.dbo.sp_delete_database_backuphistory [MENTION=515436]database[/MENTION]_name = N'RANKING_DBF'
GO
EXEC msdb.dbo.sp_delete_database_backuphistory [MENTION=515436]database[/MENTION]_name = N'ITEM_DBF'
GO
EXEC msdb.dbo.sp_delete_database_backuphistory [MENTION=515436]database[/MENTION]_name = N'ACCOUNT_DBF'
GO
--RAISERROR( 'Step 2: Dropping logins if exists',0,1) WITH NOWAIT
IF EXISTS (SELECT name FROM sys.servers WHERE (server_id != 0) AND [name] = 'ACCOUNT')
EXEC master.dbo.sp_dropserver [MENTION=485444]server[/MENTION]=N'ACCOUNT', [MENTION=313617]Drop[/MENTION]logins='droplogins'
GO
IF EXISTS (SELECT name FROM sys.servers WHERE (server_id != 0) AND [name] = 'CHR01')
EXEC master.dbo.sp_dropserver [MENTION=485444]server[/MENTION]=N'CHR01', [MENTION=313617]Drop[/MENTION]logins='droplogins'
GO
IF EXISTS (SELECT name FROM sys.servers WHERE (server_id != 0) AND [name] = 'RANKING')
EXEC master.dbo.sp_dropserver [MENTION=485444]server[/MENTION]=N'RANKING', [MENTION=313617]Drop[/MENTION]logins='droplogins'
GO
IF EXISTS (SELECT name FROM sys.servers WHERE (server_id != 0) AND [name] = 'LOG01')
EXEC master.dbo.sp_dropserver [MENTION=485444]server[/MENTION]=N'LOG01', [MENTION=313617]Drop[/MENTION]logins ='droplogins'
GO
--RAISERROR( 'Step 3: Deleting if databases if exists',0,1) WITH NOWAIT
GO
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'CHARACTER_01_DBF')
DROP DATABASE [CHARACTER_01_DBF]
GO
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'RANKING_DBF')
DROP DATABASE [RANKING_DBF]
GO
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'LOGGING_01_DBF')
DROP DATABASE [LOGGING_01_DBF]
GO
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'ACCOUNT_DBF')
DROP DATABASE [ACCOUNT_DBF]
GO
--RAISERROR( 'Step 4: Create [CHARACTER_01_DBF',0,1) WITH NOWAIT
GO
CREATE DATABASE [CHARACTER_01_DBF]
GO
ALTER DATABASE [CHARACTER_01_DBF] SET COMPATIBILITY_LEVEL = 110
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET ARITHABORT OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET  READ_WRITE 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET  MULTI_USER 
GO
ALTER DATABASE [CHARACTER_01_DBF] SET PAGE_VERIFY CHECKSUM  
GO
USE [CHARACTER_01_DBF]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [CHARACTER_01_DBF] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
--RAISERROR( 'Step 5: Create [ACCOUNT_DBF',0,1) WITH NOWAIT

From their own database? how they get this? thank you

this just most likely having a backup for their database without the data of the players (Name job loggins characters) its just like the code/data.

I wanted to know how they did it because I still stick with restoring database from backup lol.

flyffdev · 12/16/2017, 09:47

why dont you delete the database and execute your database again? or restore your clean database again?

~~khemomo~~ · 12/16/2017, 11:25

Quote:

Originally Posted by flyffdev

why dont you delete the database and execute your database again? or restore your clean database again?

Because I did some changes in database and forget what i Edit there and I accidentally delete my backup for my clean database. So i was wondering how to get a clean (No character no login datas) database script again.

flyffdev · 12/16/2017, 13:12

Use AiO Database Script of sedrika and add all you need to add there?

KingKeesie · 12/17/2017, 19:43

Wtf man, is it that hard? if try getting some backups and restore database. If it´s says database already exist go to sql folder and delete the files from that particular database or use a query to do so. End of story should be enough information tho

~~khemomo~~ · 12/18/2017, 01:08

Quote:

Originally Posted by KingKeesie

Wtf man, is it that hard? if try getting some backups and restore database. If it´s says database already exist go to sql folder and delete the files from that particular database or use a query to do so. End of story should be enough information tho

WTF man, I don't know if you read some of my reply but thank you for your response.

#closerequest Thank you.

KingKeesie · 12/18/2017, 09:56

Quote:

Originally Posted by khemomo

WTF man, I don't know if you read some of my reply but thank you for your response.

#closerequest Thank you.

Lel