Vsro Kod Paylaşım Database Sıfırlama Kodları

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
DBCC CHECKIDENT ('TB_User', RESEED, 1)
PRINT 'Cleared: TB_User'
TRUNCATE TABLE [dbo].[TB_User_Bak]
DBCC CHECKIDENT ('TB_User_Bak', RESEED, 1)
PRINT 'Cleared: TB_User_Bak'
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
DBCC CHECKIDENT ('SK_CharRenameLog', RESEED, 1)
PRINT 'Cleared: SK_CharRenameLog'
TRUNCATE TABLE [dbo].[_Punishment]
DBCC CHECKIDENT ('_Punishment', RESEED, 1)
PRINT 'Cleared: _Punishment'
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
PRINT 'Cleared: _ServiceManagerLog'
TRUNCATE TABLE [dbo].[Test_HN]
PRINT 'Cleared: Test_HN'
TRUNCATE TABLE [dbo].[_BlockedUser]
PRINT 'Cleared: _BlockedUser'
TRUNCATE TABLE [dbo].[_CasGMChatLog]
DBCC CHECKIDENT ('_CasGMChatLog', RESEED, 1)
PRINT 'Cleared: _CasGMChatLog'
TRUNCATE TABLE [dbo].[_Notice]
DBCC CHECKIDENT ('_Notice', RESEED, 1)
PRINT 'Cleared: _Notice'
TRUNCATE TABLE [dbo].[_SMCLog]
PRINT 'Cleared: _SMCLog'
TRUNCATE TABLE [dbo].[QuaySoEpoint]
DBCC CHECKIDENT ('QuaySoEpoint', RESEED, 1)
PRINT 'Cleared: QuaySoEpoint'
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
DBCC CHECKIDENT ('SK_ITEM_GuardLog', RESEED, 1)
PRINT 'Cleared: SK_ITEM_GuardLog'
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
DBCC CHECKIDENT ('SK_ItemSaleLog', RESEED, 1)
PRINT 'Cleared: SK_ItemSaleLog'
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
DBCC CHECKIDENT ('SK_PackageItemSaleLog', RESEED, 1)
PRINT 'Cleared: SK_PackageItemSaleLog'
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
DBCC CHECKIDENT ('SK_PK_UpdateLog', RESEED, 1)
PRINT 'Cleared: SK_PK_UpdateLog'
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
DBCC CHECKIDENT ('SK_ResetSkillLog', RESEED, 1)
PRINT 'Cleared: SK_ResetSkillLog'
TRUNCATE TABLE [dbo].[SK_Silk]
PRINT 'Cleared: SK_Silk'
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
DBCC CHECKIDENT ('SK_SilkBuyList', RESEED, 1)
PRINT 'Cleared: SK_SilkBuyList'
TRUNCATE TABLE [dbo].[SK_SilkGoods]
DBCC CHECKIDENT ('SK_SilkGoods', RESEED, 1)
PRINT 'Cleared: SK_SilkGoods'
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
DBCC CHECKIDENT ('SK_SubtractSilk_VAS', RESEED, 1)
PRINT 'Cleared: SK_SubtractSilk_VAS'
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
PRINT 'Cleared: SR_ShardCharNames'
TRUNCATE TABLE [dbo].[TB_Net2e]
PRINT 'Cleared: TB_Net2e'
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
PRINT 'Cleared: TB_Net2e_Bak'
TRUNCATE TABLE [dbo].[tb_paygate_trans]
DBCC CHECKIDENT ('tb_paygate_trans', RESEED, 1)
PRINT 'Cleared: tb_paygate_trans'

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_BattleHonorRank]
PRINT 'Cleared: _BattleHonorRank'
TRUNCATE TABLE [dbo].[_CharRebirth]
PRINT 'Cleared: _CharRebirth'
TRUNCATE TABLE [dbo].[_LogCashItem]
PRINT 'Cleared: _LogCashItem'
TRUNCATE TABLE [dbo].[_LogEventChar]
PRINT 'Cleared: _LogEventChar'
TRUNCATE TABLE [dbo].[_LogEventItem]
PRINT 'Cleared: _LogEventItem'
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
DBCC CHECKIDENT ('_LogEventSiegeFortress', RESEED, 1)
PRINT 'Cleared: _LogEventSiegeFortress'
TRUNCATE TABLE [dbo].[_LogSchedule]
DBCC CHECKIDENT ('_LogSchedule', RESEED, 1)
PRINT 'Cleared: _LogSchedule'
TRUNCATE TABLE [dbo].[_LogServerEvent]
DBCC CHECKIDENT ('_LogServerEvent', RESEED, 1)
PRINT 'Cleared: _LogServerEvent'

USE [SRO_VT_SHARD]
GO
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
TRUNCATE TABLE _CharCollectionBook
PRINT 'Cleared: _CharCollectionBook'
TRUNCATE TABLE _OpenMarket
PRINT 'Cleared: _OpenMarket'
TRUNCATE TABLE _CharSkill
PRINT 'Cleared: _CharSkill'
TRUNCATE TABLE _CharSkillMastery
PRINT 'Cleared: _CharSkillMastery'
TRUNCATE TABLE _GuildMember
PRINT 'Cleared: _GuildMember'
TRUNCATE TABLE _BlockedWhisperers
PRINT 'Cleared: _BlockedWhisperers'
TRUNCATE TABLE _Inventory
PRINT 'Cleared: _Inventory'
TRUNCATE TABLE _InventoryForAvatar
PRINT 'Cleared: _InventoryForAvatar'
TRUNCATE TABLE _InventoryForLinkedStorage
PRINT 'Cleared: _InventoryForLinkedStorage'
TRUNCATE TABLE _TrainingCampMember
PRINT 'Cleared: _TrainingCampMember'
TRUNCATE TABLE _TrainingCampSubMentorHonorPoint
PRINT 'Cleared: _TrainingCampSubMentorHonorPoint'
UPDATE _TrainingCampHonorRank SET CampID = NULL, Rank = NULL
PRINT 'Cleared: _TrainingCampHonorRank'
TRUNCATE TABLE _TrainingCampBuffStatus
PRINT 'Cleared: _TrainingCampBuffStatus'
DELETE FROM _TrainingCamp
PRINT 'Cleared: _TrainingCamp'
DBCC CHECKIDENT ('_TrainingCamp', RESEED, 1)
TRUNCATE TABLE _StaticAvatar
PRINT 'Cleared: _StaticAvatar'
TRUNCATE TABLE _User
PRINT 'Cleared: _User'
TRUNCATE TABLE _Friend
PRINT 'Cleared: _Friend'
TRUNCATE TABLE _Memo
PRINT 'Cleared: _Memo'
DBCC CHECKIDENT ('_Memo', RESEED, 1)
TRUNCATE TABLE _TimedJob
PRINT 'Cleared: _TimedJob'
DBCC CHECKIDENT ('_TimedJob', RESEED, 1)
TRUNCATE TABLE _TimedJobForPet
PRINT 'Cleared: _TimedJobForPet'
DBCC CHECKIDENT ('_TimedJobForPet', RESEED, 1)
TRUNCATE TABLE _CharTrijobSafeTrade
PRINT 'Cleared: _CharTrijobSafeTrade'
DELETE FROM _CharTrijob
PRINT 'Cleared: _CharTrijob'
TRUNCATE TABLE _InvCOS
PRINT 'Cleared: _InvCOS'
DELETE FROM _CharCOS WHERE ID > 0
PRINT 'Cleared: _CharCOS'
DBCC CHECKIDENT ('_CharCOS', RESEED, 0)
DELETE FROM _Char WHERE CharID > 0
PRINT 'Cleared: _Char'
DBCC CHECKIDENT ('_Char', RESEED, 0)
TRUNCATE TABLE _Chest
PRINT 'Cleared: _Chest'
TRUNCATE TABLE _ChestInfo
PRINT 'Cleared: _ChestInfo'
TRUNCATE TABLE _ItemPool
PRINT 'Cleared: _ItemPool'
DELETE FROM _Items WHERE ID64 > 0
PRINT 'Cleared: _Items'
DBCC CHECKIDENT ('_Items', RESEED, 0)
DELETE FROM _AccountJID
PRINT 'Cleared: _AccountJID'
UPDATE _AlliedClans SET Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
PRINT 'Cleared: _AlliedClans'
TRUNCATE TABLE _GuildWar
PRINT 'Cleared: _GuildWar'
DBCC CHECKIDENT ('_GuildWar', RESEED, 1)
TRUNCATE TABLE _CharNameList
PRINT 'Cleared: _CharNameList'
TRUNCATE TABLE _CharQuest
PRINT 'Cleared: _CharQuest'
TRUNCATE TABLE _ClientConfig
PRINT 'Cleared: _ClientConfig'
TRUNCATE TABLE _DeletedChar
PRINT 'Cleared: _DeletedChar'
TRUNCATE TABLE _SiegeFortressStoneState
PRINT 'Cleared: _SiegeFortressStoneState'
TRUNCATE TABLE _SiegeFortressRequest
PRINT 'Cleared: _SiegeFortressRequest'
TRUNCATE TABLE _SiegeFortressObject
PRINT 'Cleared: _SiegeFortressObject'
DBCC CHECKIDENT ('_SiegeFortressObject', RESEED, 1)
TRUNCATE TABLE _SiegeFortressItemForge
PRINT 'Cleared: _SiegeFortressItemForge'
TRUNCATE TABLE _SiegeFortressBattleRecord
PRINT 'Cleared: _SiegeFortressBattleRecord'
UPDATE _SiegeFortressStruct SET OwnerGuildID = '0'
PRINT 'Cleared: _SiegeFortressStruct'
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
PRINT 'Cleared: _SiegeFortress'
TRUNCATE TABLE _CharNickNameList
PRINT 'Cleared: _CharNickNameList'
TRUNCATE TABLE _GPHistory
PRINT 'Cleared: _GPHistory'
DBCC CHECKIDENT ('_GPHistory', RESEED, 1)
TRUNCATE TABLE _GuildChest
PRINT 'Cleared: _GuildChest'
DELETE FROM _Guild WHERE ID > 0
PRINT 'Cleared: _Guild'
DBCC CHECKIDENT ('_Guild', RESEED, 0)
TRUNCATE TABLE _BindingOptionWithItem --@@
PRINT 'Cleared: _BindingOptionWithItem'
TRUNCATE TABLE _ExploitLog
PRINT 'Cleared: _ExploitLog'
TRUNCATE TABLE _Log_SEEK_N_DESTROY_ITEM_FAST --@@
PRINT 'Cleared: _Log_SEEK_N_DESTROY_ITEM_FAST'
DELETE FROM _AlliedClans WHERE ID > 0
DBCC CHECKIDENT ('_AlliedClans', RESEED, 0)
PRINT 'Cleared: _AlliedClans'
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@