Paylaşım SQL ARADIĞINIZ QUERYLER

Katılım
26 Ara 2018
Mesajlar
17
Tepkime puanı
20
Puanları
3
Konum
Kocaeli - Bursa
Kredi
0.00[TL]
vsro
Honor Fixleme

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

Kale Fixleme

USE SRO_VT_SHARD
--- Constantineople Fortress olan DB lerin kullanılmaması önerilmektedir. Kullanılması durumunda Cons FW çalışmayacaktır.
TRUNCATE TABLE _RefSiegeFortressRewards
TRUNCATE TABLE _SiegeFortressStruct
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','1','1','24995','1')
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','3','1','24995','1')
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','6','1','24997','1')
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','1','5','60','0')
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','3','5','60','0')
INSERT INTO _RefSiegeFortressRewards (Service,FortressID,RewardTypeID,RewardValue,RewardCount) VALUES ('1','6','5','60','0')
DROP TABLE [dbo].[_SiegeFortress]
GO
CREATE TABLE [dbo].[_SiegeFortress] (
[FortressID] int NOT NULL ,
[GuildID] int NOT NULL DEFAULT (0) ,
[TaxRatio] smallint NOT NULL DEFAULT (0) ,
[Tax] bigint NOT NULL DEFAULT (0) ,
[NPCHired] tinyint NOT NULL DEFAULT (0) ,
[TempGuildID] int NOT NULL DEFAULT (0) ,
[Introduction] varchar(120) NULL ,
[CreatedDungeonTime] datetime NULL ,
[CreatedDungeonCount] tinyint NULL DEFAULT (0) ,
[IntroductionModificationPermission] tinyint NOT NULL DEFAULT (1))
GO
INSERT INTO [dbo].[_SiegeFortress] ([FortressID], [GuildID], [TaxRatio], [Tax], [NPCHired], [TempGuildID], [Introduction], [CreatedDungeonTime], [CreatedDungeonCount], [IntroductionModificationPermission]) VALUES (N'1', N'0', N'0', N'0', N'0', N'0', null, null, N'0', N'1')
GO
GO
INSERT INTO [dbo].[_SiegeFortress] ([FortressID], [GuildID], [TaxRatio], [Tax], [NPCHired], [TempGuildID], [Introduction], [CreatedDungeonTime], [CreatedDungeonCount], [IntroductionModificationPermission]) VALUES (N'3', N'0', N'0', N'0', N'0', N'0', null, null, N'0', N'1')
GO
GO
INSERT INTO [dbo].[_SiegeFortress] ([FortressID], [GuildID], [TaxRatio], [Tax], [NPCHired], [TempGuildID], [Introduction], [CreatedDungeonTime], [CreatedDungeonCount], [IntroductionModificationPermission]) VALUES (N'6', N'0', N'0', N'0', N'0', N'0', null, null, N'0', N'1')
GO
GO
CREATE INDEX [IX__SiegeFortress] ON [dbo].[_SiegeFortress]
([GuildID] ASC)
WITH (FILLFACTOR = 90)
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD PRIMARY KEY ([FortressID])
GO
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '84', '19538', '936000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '85', '19521', '464000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '86', '19521', '464000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '87', '19521', '464000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '88', '19504', '936000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '89', '19504', '936000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '90', '19504', '936000', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '91', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '92', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '93', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '94', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '95', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '96', '19509', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '97', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '98', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '99', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '100', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '101', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '102', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '103', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '104', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '105', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '106', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '107', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '108', '19515', '0', '2011-10-20 15:06:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '127', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '128', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '129', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '130', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '131', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '132', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '133', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '134', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '135', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '136', '19543', '0', '2011-10-20 16:25:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '180', '19610', '936000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '181', '19521', '464000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '182', '19521', '464000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '183', '19521', '464000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '184', '19575', '936000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '185', '19575', '936000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '186', '19575', '936000', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '187', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '188', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '189', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '190', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '191', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '192', '19509', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '193', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '194', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '195', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '196', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '197', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '198', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '199', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '200', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '201', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '202', '19515', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '224', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '225', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '226', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '227', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '228', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '229', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '230', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '231', '19543', '0', '2011-10-19 22:00:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '137', '19625', '464000', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '138', '19521', '464000', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '139', '19521', '464000', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '140', '19590', '464000', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '141', '19590', '464000', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '142', '19509', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '143', '19509', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '144', '19509', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '145', '19509', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '146', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '147', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '148', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '149', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '150', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '151', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '152', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '153', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '154', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '155', '19515', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '172', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '173', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '174', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '175', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '176', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '177', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '178', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '179', '19543', '0', '2011-10-19 15:10:00.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '118', '19641', '80000', '2011-10-20 17:42:59.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '221', '23934', '80000', '2011-10-20 17:43:26.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '117', '19641', '80000', '2011-10-20 17:43:37.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '116', '19642', '80000', '2011-10-20 17:44:14.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '124', '19642', '80000', '2011-10-20 17:44:50.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '126', '19550', '80000', '2011-10-20 17:45:29.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '114', '19641', '80000', '2011-10-20 17:46:09.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '113', '19641', '80000', '2011-10-20 17:46:46.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '222', '23934', '80000', '2011-10-20 17:47:11.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '122', '19643', '80000', '2011-10-20 17:47:22.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '220', '19640', '80000', '2011-10-20 17:47:53.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '121', '19643', '80000', '2011-10-20 17:48:07.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '215', '19640', '80000', '2011-10-20 17:48:54.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '120', '19643', '80000', '2011-10-20 17:49:10.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '213', '19640', '80000', '2011-10-20 17:49:48.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '119', '19643', '80000', '2011-10-20 17:49:54.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '112', '19641', '80000', '2011-10-20 17:50:44.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '211', '19640', '80000', '2011-10-20 17:50:59.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '111', '19641', '80000', '2011-10-20 17:51:23.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '210', '19640', '80000', '2011-10-20 17:51:48.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '115', '19642', '80000', '2011-10-20 17:52:27.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '123', '19642', '80000', '2011-10-20 17:53:17.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '219', '19640', '80000', '2011-10-20 17:53:27.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '217', '19640', '80000', '2011-10-20 17:55:13.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '110', '19643', '80000', '2011-10-20 17:56:16.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '218', '19640', '80000', '2011-10-20 17:56:34.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '216', '19640', '80000', '2011-10-20 17:57:10.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'1', '0', '109', '19643', '80000', '2011-10-20 17:57:54.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '214', '19640', '80000', '2011-10-20 17:58:15.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '212', '19640', '80000', '2011-10-20 17:59:14.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '223', '19640', '80000', '2011-10-20 17:59:51.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '209', '19640', '80000', '2011-10-20 18:00:30.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '208', '19640', '80000', '2011-10-20 18:01:29.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '207', '19640', '80000', '2011-10-20 18:02:15.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '167', '19640', '80000', '2011-10-20 18:02:20.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '206', '23933', '80000', '2011-10-20 18:02:56.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '171', '19640', '80000', '2011-10-20 18:03:36.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '205', '23933', '80000', '2011-10-20 18:03:45.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '204', '23933', '80000', '2011-10-20 18:04:25.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'3', '0', '203', '23933', '80000', '2011-10-20 18:05:10.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '169', '23932', '80000', '2011-10-20 18:05:16.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '168', '23932', '80000', '2011-10-20 18:05:55.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '166', '19640', '80000', '2011-10-20 18:06:32.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '156', '19640', '80000', '2011-10-20 18:07:08.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '162', '23932', '80000', '2011-10-20 18:07:49.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '163', '23932', '80000', '2011-10-20 18:08:27.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '164', '23932', '80000', '2011-10-20 18:09:04.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '165', '23932', '80000', '2011-10-20 18:09:47.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '170', '19640', '80000', '2011-10-20 18:10:29.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '161', '19640', '80000', '2011-10-20 18:11:13.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '157', '19640', '80000', '2011-10-20 18:11:59.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '160', '19640', '80000', '2011-10-20 18:12:36.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '158', '23932', '80000', '2011-10-20 18:13:14.000', '0')
INSERT INTO [dbo].[_SiegeFortressStruct] ([FortressID], [OwnerGuildID], [RefEventStructID], [RefObjID], [HP], [MakeDate], [State]) VALUES (N'6', '0', '159', '23932', '80000', '2011-10-20 18:13:59.000', '0')
UPDATE _RefSiegeFortress set Service = '0'
UPDATE _RefSiegeFortress set Service = '1' WHERE FortressID = '1'
UPDATE _RefSiegeFortress set Service = '1' WHERE FortressID = '3'
UPDATE _RefSiegeFortress set Service = '1' WHERE FortressID = '6'



Kale Fixleme 2

USE [SRO_VT_SHARD]
GO
DELETE FROM _SiegeFortressStruct
WHERE RefObjID IN (SELECT [ID] FROM _RefObjCommon WITH (NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 5 AND TypeID4 = 6)
UPDATE _SiegeFortressStruct SET OwnerGuildID=0
UPDATE _SiegeFortress SET GuildID=0, TaxRatio=0, Tax=0, NPCHired=0, TempGuildID=0, Introduction=NULL,
CreatedDungeonTime=NULL, CreatedDungeonCount=NULL, IntroductionModificationPermission=1


VT_ACC Temizleme

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
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].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]


VT_LOG Temizleme

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]


VT_SHARD Temizleme

USE [SRO_VT_SHARD]
GO
truncate table _OpenMarket
print 'Temizlendi: _OpenMarket'
truncate table _CharSkill
print 'Temizlendi: _CharSkill'
truncate table _CharSkillMastery
print 'Temizlendi: _CharSkillMastery'
truncate table _GuildMember
print 'Temizlendi: _GuildMember'
truncate table _BlockedWhisperers
print 'Temizlendi: _BlockedWhisperers'
truncate table _Inventory
print 'Temizlendi: _Inventory'
truncate table _InventoryForAvatar
print 'Temizlendi: _InventoryForAvatar'
truncate table _InventoryForLinkedStorage
print 'Temizlendi: _InventoryForLinkedStorage'
truncate table _TrainingCampMember
print 'Temizlendi: _TrainingCampMember'
truncate table _TrainingCampSubMentorHonorPoint
print 'Temizlendi: _TrainingCampSubMentorHonorPoint'
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL
print 'Temizlendi: _TrainingCampHonorRank'
truncate table _TrainingCampBuffStatus
print 'Temizlendi: _TrainingCampBuffStatus'
delete from _TrainingCamp
print 'Temizlendi: _TrainingCamp'
truncate table _StaticAvatar
print 'Temizlendi: _StaticAvatar'
truncate table _User
print 'Temizlendi: _User'
truncate table _Friend
print 'Temizlendi: _Friend'
truncate table _Memo
print 'Temizlendi: _Memo'
truncate table _TimedJob
print 'Temizlendi: _TimedJob'
truncate table _CharTrijobSafeTrade
print 'Temizlendi: _CharTrijobSafeTrade'
delete from _CharTrijob
print 'Temizlendi: _CharTrijob'
truncate table _InvCOS
print 'Temizlendi: _InvCOS'
delete from _CharCOS where ID > 0
print 'Temizlendi: _CharCOS'
delete from _Char where charid > 0
print 'Temizlendi: _Char'
truncate table _Chest
print 'Temizlendi: _Chest'
truncate table _ChestInfo
print 'Temizlendi: _ChestInfo'
truncate table _ItemPool
print 'Temizlendi: _ItemPool'
delete from _Items where ID64 > 0
print 'Temizlendi: _Items'
delete from _AccountJID
print 'Temizlendi: _AccountJID'
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
print 'Temizlendi: _AlliedClans'
truncate table _GuildWar
print 'Temizlendi: _GuildWar'
truncate table _CharNameList
print 'Temizlendi: _CharNameList'
truncate table _CharQuest
print 'Temizlendi: _CharQuest'
truncate table _ClientConfig
print 'Temizlendi: _ClientConfig'
truncate table _DeletedChar
print 'Temizlendi: _DeletedChar'
truncate table _SiegeFortressStoneState
print 'Temizlendi: _SiegeFortressStoneState'
truncate table _SiegeFortressRequest
print 'Temizlendi: _SiegeFortressRequest'
truncate table _SiegeFortressObject
print 'Temizlendi: _SiegeFortressObject'
truncate table _SiegeFortressItemForge
print 'Temizlendi: _SiegeFortressItemForge'
truncate table _SiegeFortressBattleRecord
print 'Temizlendi: _SiegeFortressBattleRecord'
update _SiegeFortressStruct SET OwnerGuildID = '0'
print 'Temizlendi: _SiegeFortressStruct'
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
print 'Temizlendi: _SiegeFortress'
truncate table _CharNickNameList
print 'Temizlendi: _CharNickNameList'
truncate table _GPHistory
print 'Temizlendi: _GPHistory'
truncate table _GuildChest
print 'Temizlendi: _GuildChest'
delete from _Guild where ID > 0
print 'Temizlendi: _Guild'
delete from _AlliedClans where ID > 0
print 'Temizlendi: _AlliedClans'


İTEM SİLME

USE [SRO_VT_SHARD]
Exec [Dbo].[_SEEK_N_DESTROY_ITEM] 'ITEM_CODED_BY_OSTA__MALL_AVATAR_W_NASRUN'


UNIQUE SLOTLARI

select * from _RefObjCommon where CodeName128 like '%MOB_TQ_WHITESNAKE%'
select * from Tab_RefTactics where dwObjID like '%14997%'
select * from Tab_RefNest where dwTacticsID like '%33500%'


[VSROUYARI]Biraz olsun faydam dokunduysa ne mutlu bana :) İyi forumlar[/VSROUYARI]
 
Üst