Db Sıfırlama Query

USE Panel
TRUNCATE TABLE _OnlineOffline
TRUNCATE TABLE _Tickets
TRUNCATE TABLE _TicketsAnswer
TRUNCATE TABLE AdminLog
TRUNCATE TABLE adminloginlog
TRUNCATE TABLE Epins
TRUNCATE TABLE MarketLog
TRUNCATE TABLE UniqueRanking
TRUNCATE TABLE PvpKillHistory
TRUNCATE TABLE PvpKills
TRUNCATE TABLE adminloginlog
TRUNCATE TABLE WheelLog


USE RemoLogger
TRUNCATE TABLE _Disconnect
TRUNCATE TABLE _LogGlobal
TRUNCATE TABLE _LogNotice
TRUNCATE TABLE _Notice
TRUNCATE TABLE _PM
TRUNCATE TABLE _PM_Incoming
TRUNCATE TABLE _RecallUser
TRUNCATE TABLE _UniqueLogger

USE KGuardEDGE
TRUNCATE TABLE _CharCustoms
TRUNCATE TABLE _Log_Chat
TRUNCATE TABLE _Log_KillLog
TRUNCATE TABLE _Log_LoginLogout
TRUNCATE TABLE _Log_Teleport
TRUNCATE TABLE _Rank_UniqueRank
TRUNCATE TABLE _Log_PKStatus
TRUNCATE TABLE _Rank_JobRank
TRUNCATE TABLE _Live_Unique


TRUNCATE TABLE _DeveloperCommands
TRUNCATE TABLE _EngagedBuffs
TRUNCATE TABLE _ItemChest
TRUNCATE TABLE _Live_Party
TRUNCATE TABLE _Live_Party_Members
TRUNCATE TABLE _LockedItemSerials
TRUNCATE TABLE _Log_DailyReward


TRUNCATE TABLE _Log_KillLog
TRUNCATE TABLE _Log_LoginLogout
TRUNCATE TABLE _Log_Player
TRUNCATE TABLE _Log_Scroll
TRUNCATE TABLE _Log_Teleport

USE [master]
GO
DBCC SHRINKDATABASE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO
DBCC UPDATEUSAGE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO

USE [model]
GO
DBCC SHRINKDATABASE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO
DBCC UPDATEUSAGE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO

USE [msdb]
GO
DBCC SHRINKDATABASE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO
DBCC UPDATEUSAGE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO

USE [tempdb]
GO
DBCC SHRINKDATABASE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC SHRINKDATABASE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO
DBCC UPDATEUSAGE ('SRO_VT_ACCOUNT') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_SHARD') WITH NO_INFOMSGS;
DBCC UPDATEUSAGE ('SRO_VT_LOG') WITH NO_INFOMSGS;
GO

uSE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
DBCC CHECKIDENT ('TB_User', RESEED, 1)
PRINT 'Cleared: TB_User'


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_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'
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

USE MaxiGuard_User


TRUNCATE TABLE _AchievementStatus
TRUNCATE TABLE _ActiveBuffs
TRUNCATE TABLE _AvailableIcons
TRUNCATE TABLE _AvailableTitles
TRUNCATE TABLE _CharChest

TRUNCATE TABLE _CharCustomTag
TRUNCATE TABLE _CharCustomTitle
TRUNCATE TABLE _CharIcon
TRUNCATE TABLE _CharIconRightSide
TRUNCATE TABLE _CharnameColor
TRUNCATE TABLE _CharPinLock
TRUNCATE TABLE _CharPinTrustedDevices
TRUNCATE TABLE _CommandLogs
TRUNCATE TABLE _DynamicRank_Custom1
TRUNCATE TABLE _DynamicRank_Custom2
TRUNCATE TABLE _DynamicRank_Custom3

TRUNCATE TABLE _TitleColor