Bilgi vSRO Veritabanı Sıfırlama Query

[ForumKolik]

Merhabalar, sizlere işinize yarayacak bir Query paylaşacağım.
Database dosyalarınızı sıfırlamak ve içerisindeki kayıtları silmek istiyorsanız bu Queryleri kullanabilirsiniz.

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo]._ShardCurrentUser

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

USE [SRO_VT_SHARD]
GO
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _OpenMarket
truncate table _Inventory
truncate table _CharNickNameList
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampBuffStatus
truncate table _CharCollectionBook
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
update _SiegeFortressStruct set OwnerGuildID=0
update _SiegeFortress set GuildID=0
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
delete from _SiegeFortressStruct
truncate table _gphistory

-- F1 FIX
UPDATE _RefCharDefault_Quest SET Service = 1
delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0
--- Honor Fix
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
--- KALE FIX
insert into _SiegeFortress values (1,0,0,0,0,0,NULL,NULL,0,1)
insert into _SiegeFortress values (3,0,0,0,0,0,NULL,NULL,0,1)
insert into _SiegeFortress values (6,0,0,0,0,0,NULL,NULL,0,1)

insert into _SiegeFortressStruct values (1,0,84,19538,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,85,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,86,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,87,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,88,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,89,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,90,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,91,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,92,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,93,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,94,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,95,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,96,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,97,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,98,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,99,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,100,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,101,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,102,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,103,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,104,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,105,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,106,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,108,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,127,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,128,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,129,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,130,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,131,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,132,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,133,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,134,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,135,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,136,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,180,19610,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,181,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,182,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,183,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,184,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,185,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,186,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,187,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,188,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,189,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,190,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,191,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,192,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,193,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,194,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,195,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,196,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,197,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,198,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,199,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,200,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,201,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,202,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,224,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,225,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,226,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,227,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,228,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,229,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,230,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,231,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,137,19625,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,138,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,139,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,140,19590,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,141,19590,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,142,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,143,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,144,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,145,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,146,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,147,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,148,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,149,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,150,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,151,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,152,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,153,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,154,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,155,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,172,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,173,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,174,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,175,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,176,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,177,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,178,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,179,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,118,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,221,23934,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,117,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,116,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,124,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,126,19550,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,114,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,113,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,222,23934,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,122,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,220,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,121,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,215,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,120,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,213,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,119,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,112,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,211,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,111,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,210,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,115,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,123,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,219,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,217,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,110,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,218,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,216,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,109,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,214,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,212,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,223,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,209,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,208,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,207,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,167,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,206,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,171,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,205,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,204,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,203,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,169,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,168,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,166,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,156,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,162,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,163,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,164,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,165,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,170,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,161,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,157,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,160,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,158,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,159,23932,80000,getdate(),0)

print 'Honor Fix'
print 'F1 Fix'
print 'Kale Fix'