Hoş Geldin, Ziyaretçi!

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yapŞimdi kayıt ol
dsgn kguard
ROLLET
vsupload kguardedgeakademi
cleopatra legacy
ecr-online rebels reklam

vSRO Çözüldü Kale savaşını dogru ayarlamama ragmen kayıtlar açılmıyor ve savas baslamıyor

O

ohshet48

.
Katılım
19 Ara 2019
Mesajlar
85
Alınan Beğeni
15
Ödül Puanları
8
Konum
mugla
Kale savaşını dogru ayarlamama ragmen kayıtlar açılmıyor ve savas baslamıyor. bu konuda bana yardım edecek birisi varmıdır ?
 
Tarihe göre sırala Oylara göre sırala
İnternational

İnternational

.
.
Katılım
7 May 2019
Mesajlar
803
Alınan Beğeni
329
Ödül Puanları
63
Konum
Germany
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
Sa ilk önce yedek al bu query okut ardından tekrar smc ayarı yapıp smc tarihini 2030 olarakta ayarlamıyı unutma sonra shard manageri resetle düzelicektir kalelerinin açık olup olmadıgınıda kontrol et bunları yaptıktan sonra hiç bir sıkıntın kalmayacaktır.



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'
 
Oyla 0
DragonSlayer

DragonSlayer

Old School
Administrator
Katılım
13 May 2019
Mesajlar
3,555
Çözümler
69
Alınan Beğeni
5,906
Ödül Puanları
213
Konum
Lutsk
Smc'ye etlinlik oluştururken dikkat edilmesi gereken yer kesinlikle tarih.. bu daha önce temple uniquelerinde benim de başıma gelmişti. Her seferinde unutuyordum. Şu an Sheduler'i açtığımda ilk yaptığım iş tarihi 2030 yapmak.
Çözülmüştür umarım.
 
Oyla 0
O

ohshet48

.
Katılım
19 Ara 2019
Mesajlar
85
Alınan Beğeni
15
Ödül Puanları
8
Konum
mugla
DarkSlayer' Alıntı:
Smc'ye etlinlik oluştururken dikkat edilmesi gereken yer kesinlikle tarih.. bu daha önce temple uniquelerinde benim de başıma gelmişti. Her seferinde unutuyordum. Şu an Sheduler'i açtığımda ilk yaptığım iş tarihi 2030 yapmak.
Çözülmüştür umarım.
Genişletmek için tıkla ...
çözulmuyor işte resrartlayınca 2020 oluyo tekrar
 
Oyla 0
O

ohshet48

.
Katılım
19 Ara 2019
Mesajlar
85
Alınan Beğeni
15
Ödül Puanları
8
Konum
mugla
İnternational' Alıntı:
Sa ilk önce yedek al bu query okut ardından tekrar smc ayarı yapıp smc tarihini 2030 olarakta ayarlamıyı unutma sonra shard manageri resetle düzelicektir kalelerinin açık olup olmadıgınıda kontrol et bunları yaptıktan sonra hiç bir sıkıntın kalmayacaktır.



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'
Genişletmek için tıkla ...
smc ayarı 2030 yapıyorum restart atınca tekrar 2020 oluyor
 
Oyla 0
DragonSlayer

DragonSlayer

Old School
Administrator
Katılım
13 May 2019
Mesajlar
3,555
Çözümler
69
Alınan Beğeni
5,906
Ödül Puanları
213
Konum
Lutsk
ohshet48' Alıntı:
çözulmuyor işte resrartlayınca 2020 oluyo tekrar
Genişletmek için tıkla ...
Elimdeki işi bitirip halen çözülmemişse size dönücem.. yedeklerinizi alın kenara.. komple temizleyip sıfırdan yapalım uzaktan bağlanarak. Yine sorun çıkarırsa files değiştirmek çözebilir ama o en son iş.
 
Oyla 0
Sieger

Sieger

𝐕𝐒𝐑𝐎 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫, 𝐏𝐊𝟐 𝐄𝐝𝐢𝐭𝐨𝐫
Premium
.
Katılım
6 Şub 2019
Mesajlar
2,410
Çözümler
5
Alınan Beğeni
6,158
Ödül Puanları
303
Konum
vsroeditor.com
Execute yapmana gerek yok, tarihi ayarla ADD de ve exelerini yeniden başlat. Bu kadar.
 
Oyla 0
Cevap yazmak için giriş yap yada kayıt ol.
  Benzer konular Forum Tarih
80 Cap Freya Online v2 | 80 CAP | ONLY CH | JOB BASED | ACTIVITY | REAL 300$ KALE SAVAŞ ÖDÜLÜ | GO 12.04.2024 SRO Private Server Tanıtım Forumu 5 190
vSRO Yardım makaleyi sökmek VSRO Sorunlar ve Çözümleri 0 70
vSRO Paylaşım NPC'leri kaleye bağlama (Query ile) VSRO Kod Paylaşımları 10 731
vSRO Çözüldü client crash (jangan kale) Çözümlenen Sorun Başlıkları 5 625
vSRO Çözüldü Jangan Kale Region Kaç ? Çözümlenen Sorun Başlıkları 1 563

Benzer konular

Konular

10.2K

Mesajlar

120.7K

Kullanıcılar

10.1K

Son üye

mrquake

Uyarı
vSRO.ORG; 5651 Sayılı Kanun kapsamında BTK tarafından onaylı Yer Sağlayıcı'dır. Bu sebeple içerikleri kontrol etme ya da araştırma yükümlülüğü yoktur. Hukuka ve mevzuata aykırı olduğunu düşündüğünüz içeriği BURADAN bildirebilirsiniz. İletişime geçilmesi halinde ilgili kanunlar ve yönetmelikler çerçevesinde gerekli işlemler yapılacaktır.
Community platform by XenForo® © 2010-2021 XenForo Ltd.
XenForo Style eTiKeT™ 2020
XenForo 2 Türkçe 🇹🇷 eTiKeT™ 2021
Tepki lideri konular
AdBlock Detected

Anlıyoruz, reklamlar can sıkıcı!

Elbette, reklam engelleme yazılımı reklamları engellemede harika bir iş çıkarır, ancak aynı zamanda web sitemizin faydalı özelliklerini de engeller. En iyi site deneyimi için lütfen AdBlocker'ınızı devre dışı bırakın.

AdBlock'u Devre Dışı Bıraktım.