Register for your free account! | Forgot your password?

You last visited: Today at 22:43

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Jangan Fortress

Discussion on Jangan Fortress within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2017
Posts: 110
Received Thanks: 36
Jangan Fortress

Hi guys
I have a problem now want to attack jangan fortress, but nothing happens at Teleport gate 1 or gate 2 or gate 3?

can someone help please
Dacks87 is offline  
Old 07/04/2020, 04:47   #2
 
elite*gold: 57
The Black Market: 1/0/0
Join Date: Apr 2020
Posts: 73
Received Thanks: 18
HTML Code:
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
HTML Code:
USE SRO_VT_SHARD
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'
Nario7 is offline  
Old 07/04/2020, 04:48   #3
 
elite*gold: 57
The Black Market: 1/0/0
Join Date: Apr 2020
Posts: 73
Received Thanks: 18
HTML Code:
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
HTML Code:
USE SRO_VT_SHARD
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'
Nario7 is offline  
Reply

« Unique notice | Cap 100 Hybrid Spear or Full Int »

Similar Threads Similar Threads
Jangan Fortress war manger
06/25/2016 - SRO Private Server - 1 Replies
hey guys , Jangan fortress war manger is disabled so i can't upgrade or fix towers,gates and heart is there is any way to enable it ?
Jangan Fortress Teleport Gate 2 Bug
11/22/2015 - SRO Private Server - 3 Replies
Everytime I get close to that Gate, client crash. Really dont know the reason of this problem. Someone knows something about that error? Also GameServer.exe or ShardManager.exe give no error. Thanks
How To Fix Jangan Fortress ?
05/05/2012 - SRO Private Server - 0 Replies
why i cant atk Jangan Fortress in my private server ? i can select the gates but cant atk them its looking like this http://store1.up-00.com/Mar12/9BJ09188.jpg tnx :handsdown:
Jangan Fortress time
10/19/2011 - SRO Private Server - 0 Replies
............
[BUG] Entering Jangan Fortress by walking through Chaos Maze
04/06/2011 - Silkroad Online - 8 Replies
http://img687.imageshack.us/i/sro2011040314265609. jpg/ I've seen people doing this, I also seen a video but I can't find it somehow. Could someone please upload it?



All times are GMT +1. The time now is 22:44.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.