Fortress Problem

[mahmoudzare]

Hello,
IHave Game Online and Players Asked Me To Make Fortress 1 town only (jangan)

and i have Used This Query To Delete Fortress .

 Spoiler

USE [SRO_VT_SHARD]
GO

truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress

Then i Have Added This For SiegeFortressStruct_ table

 Spoiler

1 0 84 19538 936000 2011-10-20 15:06:00.000 0
1 0 85 19521 464000 2011-10-20 15:06:00.000 0
1 0 86 19521 464000 2011-10-20 15:06:00.000 0
1 0 87 19521 464000 2011-10-20 15:06:00.000 0
1 0 88 19504 936000 2011-10-20 15:06:00.000 0
1 0 89 19504 936000 2011-10-20 15:06:00.000 0
1 0 90 19504 936000 2011-10-20 15:06:00.000 0
1 0 91 19509 0 2011-10-20 15:06:00.000 0
1 0 92 19509 0 2011-10-20 15:06:00.000 0
1 0 93 19509 0 2011-10-20 15:06:00.000 0
1 0 94 19509 0 2011-10-20 15:06:00.000 0
1 0 95 19509 0 2011-10-20 15:06:00.000 0
1 0 96 19509 0 2011-10-20 15:06:00.000 0
1 0 97 19515 0 2011-10-20 15:06:00.000 0
1 0 98 19515 0 2011-10-20 15:06:00.000 0
1 0 99 19515 0 2011-10-20 15:06:00.000 0
1 0 100 19515 0 2011-10-20 15:06:00.000 0
1 0 101 19515 0 2011-10-20 15:06:00.000 0
1 0 102 19515 0 2011-10-20 15:06:00.000 0
1 0 103 19515 0 2011-10-20 15:06:00.000 0
1 0 104 19515 0 2011-10-20 15:06:00.000 0
1 0 105 19515 0 2011-10-20 15:06:00.000 0
1 0 106 19515 0 2011-10-20 15:06:00.000 0
1 0 107 19515 0 2011-10-20 15:06:00.000 0
1 0 108 19515 0 2011-10-20 15:06:00.000 0
1 0 127 19543 0 2011-10-20 16:25:00.000 0
1 0 128 19543 0 2011-10-20 16:25:00.000 0
1 0 129 19543 0 2011-10-20 16:25:00.000 0
1 0 130 19543 0 2011-10-20 16:25:00.000 0
1 0 131 19543 0 2011-10-20 16:25:00.000 0
1 0 132 19543 0 2011-10-20 16:25:00.000 0
1 0 133 19543 0 2011-10-20 16:25:00.000 0
1 0 134 19543 0 2011-10-20 16:25:00.000 0
1 0 135 19543 0 2011-10-20 16:25:00.000 0
1 0 136 19543 0 2011-10-20 16:25:00.000 0
3 0 180 19610 936000 2011-10-19 22:00:00.000 0
3 0 181 19521 464000 2011-10-19 22:00:00.000 0
3 0 182 19521 464000 2011-10-19 22:00:00.000 0
3 0 183 19521 464000 2011-10-19 22:00:00.000 0
3 0 184 19575 936000 2011-10-19 22:00:00.000 0
3 0 185 19575 936000 2011-10-19 22:00:00.000 0
3 0 186 19575 936000 2011-10-19 22:00:00.000 0
3 0 187 19509 0 2011-10-19 22:00:00.000 0
3 0 188 19509 0 2011-10-19 22:00:00.000 0
3 0 189 19509 0 2011-10-19 22:00:00.000 0
3 0 190 19509 0 2011-10-19 22:00:00.000 0
3 0 191 19509 0 2011-10-19 22:00:00.000 0
3 0 192 19509 0 2011-10-19 22:00:00.000 0
3 0 193 19515 0 2011-10-19 22:00:00.000 0
3 0 194 19515 0 2011-10-19 22:00:00.000 0
3 0 195 19515 0 2011-10-19 22:00:00.000 0
3 0 196 19515 0 2011-10-19 22:00:00.000 0
3 0 197 19515 0 2011-10-19 22:00:00.000 0
3 0 198 19515 0 2011-10-19 22:00:00.000 0
3 0 199 19515 0 2011-10-19 22:00:00.000 0
3 0 200 19515 0 2011-10-19 22:00:00.000 0
3 0 201 19515 0 2011-10-19 22:00:00.000 0
3 0 202 19515 0 2011-10-19 22:00:00.000 0
3 0 224 19543 0 2011-10-19 22:00:00.000 0
3 0 225 19543 0 2011-10-19 22:00:00.000 0
3 0 226 19543 0 2011-10-19 22:00:00.000 0
3 0 227 19543 0 2011-10-19 22:00:00.000 0
3 0 228 19543 0 2011-10-19 22:00:00.000 0
3 0 229 19543 0 2011-10-19 22:00:00.000 0
3 0 230 19543 0 2011-10-19 22:00:00.000 0
3 0 231 19543 0 2011-10-19 22:00:00.000 0
6 0 137 19625 464000 2011-10-19 15:10:00.000 0
6 0 138 19521 464000 2011-10-19 15:10:00.000 0
6 0 139 19521 464000 2011-10-19 15:10:00.000 0
6 0 140 19590 464000 2011-10-19 15:10:00.000 0
6 0 141 19590 464000 2011-10-19 15:10:00.000 0
6 0 142 19509 0 2011-10-19 15:10:00.000 0
6 0 143 19509 0 2011-10-19 15:10:00.000 0
6 0 144 19509 0 2011-10-19 15:10:00.000 0
6 0 145 19509 0 2011-10-19 15:10:00.000 0
6 0 146 19515 0 2011-10-19 15:10:00.000 0
6 0 147 19515 0 2011-10-19 15:10:00.000 0
6 0 148 19515 0 2011-10-19 15:10:00.000 0
6 0 149 19515 0 2011-10-19 15:10:00.000 0
6 0 150 19515 0 2011-10-19 15:10:00.000 0
6 0 151 19515 0 2011-10-19 15:10:00.000 0
6 0 152 19515 0 2011-10-19 15:10:00.000 0
6 0 153 19515 0 2011-10-19 15:10:00.000 0
6 0 154 19515 0 2011-10-19 15:10:00.000 0
6 0 155 19515 0 2011-10-19 15:10:00.000 0
6 0 172 19543 0 2011-10-19 15:10:00.000 0
6 0 173 19543 0 2011-10-19 15:10:00.000 0
6 0 174 19543 0 2011-10-19 15:10:00.000 0
6 0 175 19543 0 2011-10-19 15:10:00.000 0
6 0 176 19543 0 2011-10-19 15:10:00.000 0
6 0 177 19543 0 2011-10-19 15:10:00.000 0
6 0 178 19543 0 2011-10-19 15:10:00.000 0
6 0 179 19543 0 2011-10-19 15:10:00.000 0
1 0 118 19641 80000 2011-10-20 17:42:59.000 0
3 0 221 23934 80000 2011-10-20 17:43:26.000 0
1 0 117 19641 80000 2011-10-20 17:43:37.000 0
1 0 116 19642 80000 2011-10-20 17:44:14.000 0
1 0 124 19642 80000 2011-10-20 17:44:50.000 0
1 0 126 19550 80000 2011-10-20 17:45:29.000 0
1 0 114 19641 80000 2011-10-20 17:46:09.000 0
1 0 113 19641 80000 2011-10-20 17:46:46.000 0
3 0 222 23934 80000 2011-10-20 17:47:11.000 0
1 0 122 19643 80000 2011-10-20 17:47:22.000 0
3 0 220 19640 80000 2011-10-20 17:47:53.000 0
1 0 121 19643 80000 2011-10-20 17:48:07.000 0
3 0 215 19640 80000 2011-10-20 17:48:54.000 0
1 0 120 19643 80000 2011-10-20 17:49:10.000 0
3 0 213 19640 80000 2011-10-20 17:49:48.000 0
1 0 119 19643 80000 2011-10-20 17:49:54.000 0
1 0 112 19641 80000 2011-10-20 17:50:44.000 0
3 0 211 19640 80000 2011-10-20 17:50:59.000 0
1 0 111 19641 80000 2011-10-20 17:51:23.000 0
3 0 210 19640 80000 2011-10-20 17:51:48.000 0
1 0 115 19642 80000 2011-10-20 17:52:27.000 0
1 0 123 19642 80000 2011-10-20 17:53:17.000 0
3 0 219 19640 80000 2011-10-20 17:53:27.000 0
3 0 217 19640 80000 2011-10-20 17:55:13.000 0
1 0 110 19643 80000 2011-10-20 17:56:16.000 0
3 0 218 19640 80000 2011-10-20 17:56:34.000 0
3 0 216 19640 80000 2011-10-20 17:57:10.000 0
1 0 109 19643 80000 2011-10-20 17:57:54.000 0
3 0 214 19640 80000 2011-10-20 17:58:15.000 0
3 0 212 19640 80000 2011-10-20 17:59:14.000 0
3 0 223 19640 80000 2011-10-20 17:59:51.000 0
3 0 209 19640 80000 2011-10-20 18:00:30.000 0
3 0 208 19640 80000 2011-10-20 18:01:29.000 0
3 0 207 19640 80000 2011-10-20 18:02:15.000 0
6 0 167 19640 80000 2011-10-20 18:02:20.000 0
3 0 206 23933 80000 2011-10-20 18:02:56.000 0
6 0 171 19640 80000 2011-10-20 18:03:36.000 0
3 0 205 23933 80000 2011-10-20 18:03:45.000 0
3 0 204 23933 80000 2011-10-20 18:04:25.000 0
3 0 203 23933 80000 2011-10-20 18:05:10.000 0
6 0 169 23932 80000 2011-10-20 18:05:16.000 0
6 0 168 23932 80000 2011-10-20 18:05:55.000 0
6 0 166 19640 80000 2011-10-20 18:06:32.000 0
6 0 156 19640 80000 2011-10-20 18:07:08.000 0
6 0 162 23932 80000 2011-10-20 18:07:49.000 0
6 0 163 23932 80000 2011-10-20 18:08:27.000 0
6 0 164 23932 80000 2011-10-20 18:09:04.000 0
6 0 165 23932 80000 2011-10-20 18:09:47.000 0
6 0 170 19640 80000 2011-10-20 18:10:29.000 0
6 0 161 19640 80000 2011-10-20 18:11:13.000 0
6 0 157 19640 80000 2011-10-20 18:11:59.000 0
6 0 160 19640 80000 2011-10-20 18:12:36.000 0
6 0 158 23932 80000 2011-10-20 18:13:14.000 0
6 0 159 23932 80000 2011-10-20 18:13:59.000 0
NULL NULL NULL NULL NULL NULL NULL

Now All Can`t Register For Fortress , and I Have Changed my Smc




Any One Here Can Help Me Please ?

[Eslam Galull]

Now All Can`t Register For Fortress , and I Have Changed my Smc

-try make it everyday from blabla to blabla

- use correct SiegeFortressStruct table

try this

1.

 Spoiler

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_InsertSiegeFortressStruct]
@FortressID INT
AS
DECLARE @RefEventStructID INT
DECLARE @StructCodeName VARCHAR(129)
DECLARE @FortressName VARCHAR(129)

IF @FortressID <= 0
BEGIN
RETURN -1
END

-- Get the FortressName (FORTRESS_JANGAN)
SELECT @FortressName = CodeName128 FROM _RefSiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID
--print(@FortressName)

-- Get the GroupCodeName (GROUP_FORTRESS_JANGAN)
DECLARE @FortressGroupCodeName VARCHAR(129)
SELECT @FortressGroupCodeName = GroupCodeName128 FROM _RefGame_World_Config WHERE [Value] = @FortressName
--print(@FortressGroupCodeName)

-- Get the WorldCodeName (INS_FORT_JA)
DECLARE @FortressWorldCodeName VARCHAR(129)
SELECT @FortressWorldCodeName = WorldCodeName128 FROM _RefGame_World WHERE ConfigGroupCodeName128 = @FortressGroupCodeName
--print(@FortressWorldCodeName)

DECLARE FortressStructCursor CURSOR FOR
SELECT [ID],strParam1 FROM _RefEventZone WITH (NOLOCK) WHERE Service = 1 AND strParam2 = @FortressWorldCodeName

OPEN FortressStructCursor
FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
WHILE (@@fetch_status = 0)
BEGIN
DECLARE @RefObjID INT
DECLARE @Link INT

SET @RefObjID = 0
SET @Link = 0

SELECT @RefObjID = [ID], @Link = Link FROM _RefObjCommon WITH (NOLOCK) WHERE CodeName128 = @StructCodeName
IF @RefObjID <= 0
BEGIN
FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
CONTINUE
END

DECLARE @MaxHP INT
SELECT @MaxHP = MaxHP FROM _RefObjChar WITH (NOLOCK) WHERE [ID] = @Link
IF @MaxHP < 0
BEGIN
FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
CONTINUE
END

IF NOT EXISTS (SELECT * FROM _SiegeFortressStruct WITH (NOLOCK) WHERE RefEventStructID = @RefEventStructID)
BEGIN
-- ·¹ÆÛ·±½º Å×ÀÌºí¿¡¼* Æ÷Æ®¸®½º ÀνºÅϽº¸¦ ¹Ì¸® ¸¸µç´Ù. °ªÀº ¸ðµÎ default·Î ¼¼ÆÃ!
-- Translation: Create a table in advance on the fortress instance reference. All values ​​are set to default!
INSERT INTO [dbo]._SiegeFortressStruct VALUES ( @FortressID, 0, @RefEventStructID, @RefObjID, @MaxHP, GetDate(), 0)
END

FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
END

CLOSE FortressStructCursor
DEALLOCATE FortressStructCursor

RETURN 0
-- by Daxter

__________________________________________
And execute for each fortress

Code:
________________________________________
-- Jangan
EXEC [dbo].[_InsertSiegeFortressStruct]
@FortressID = 1
-- Hotan
EXEC [dbo].[_InsertSiegeFortressStruct]
@FortressID = 3
-- Bandit
EXEC [dbo].[_InsertSiegeFortressStruct]
@FortressID = 6

2.

 Spoiler

1 0 84 19538 936000 2011.10.20. 15:06:00 0
1 0 85 19521 464000 2011.10.20. 15:06:00 0
1 0 86 19521 464000 2011.10.20. 15:06:00 0
1 0 87 19521 464000 2011.10.20. 15:06:00 0
1 0 88 19504 936000 2011.10.20. 15:06:00 0
1 0 89 19504 936000 2011.10.20. 15:06:00 0
1 0 90 19504 936000 2011.10.20. 15:06:00 0
1 0 91 19509 0 2011.10.20. 15:06:00 0
1 0 92 19509 0 2011.10.20. 15:06:00 0
1 0 93 19509 0 2011.10.20. 15:06:00 0
1 0 94 19509 0 2011.10.20. 15:06:00 0
1 0 95 19509 0 2011.10.20. 15:06:00 0
1 0 96 19509 0 2011.10.20. 15:06:00 0
1 0 97 19515 0 2011.10.20. 15:06:00 0
1 0 98 19515 0 2011.10.20. 15:06:00 0
1 0 99 19515 0 2011.10.20. 15:06:00 0
1 0 100 19515 0 2011.10.20. 15:06:00 0
1 0 101 19515 0 2011.10.20. 15:06:00 0
1 0 102 19515 0 2011.10.20. 15:06:00 0
1 0 103 19515 0 2011.10.20. 15:06:00 0
1 0 104 19515 0 2011.10.20. 15:06:00 0
1 0 105 19515 0 2011.10.20. 15:06:00 0
1 0 106 19515 0 2011.10.20. 15:06:00 0
1 0 107 19515 0 2011.10.20. 15:06:00 0
1 0 108 19515 0 2011.10.20. 15:06:00 0
1 0 127 19543 0 2011.10.20. 16:25:00 0
1 0 128 19543 0 2011.10.20. 16:25:00 0
1 0 129 19543 0 2011.10.20. 16:25:00 0
1 0 130 19543 0 2011.10.20. 16:25:00 0
1 0 131 19543 0 2011.10.20. 16:25:00 0
1 0 132 19543 0 2011.10.20. 16:25:00 0
1 0 133 19543 0 2011.10.20. 16:25:00 0
1 0 134 19543 0 2011.10.20. 16:25:00 0
1 0 135 19543 0 2011.10.20. 16:25:00 0
1 0 136 19543 0 2011.10.20. 16:25:00 0
3 0 180 19610 936000 2011.10.19. 22:00:00 0
3 0 181 19521 464000 2011.10.19. 22:00:00 0
3 0 182 19521 464000 2011.10.19. 22:00:00 0
3 0 183 19521 464000 2011.10.19. 22:00:00 0
3 0 184 19575 936000 2011.10.19. 22:00:00 0
3 0 185 19575 936000 2011.10.19. 22:00:00 0
3 0 186 19575 936000 2011.10.19. 22:00:00 0
3 0 187 19509 0 2011.10.19. 22:00:00 0
3 0 188 19509 0 2011.10.19. 22:00:00 0
3 0 189 19509 0 2011.10.19. 22:00:00 0
3 0 190 19509 0 2011.10.19. 22:00:00 0
3 0 191 19509 0 2011.10.19. 22:00:00 0
3 0 192 19509 0 2011.10.19. 22:00:00 0
3 0 193 19515 0 2011.10.19. 22:00:00 0
3 0 194 19515 0 2011.10.19. 22:00:00 0
3 0 195 19515 0 2011.10.19. 22:00:00 0
3 0 196 19515 0 2011.10.19. 22:00:00 0
3 0 197 19515 0 2011.10.19. 22:00:00 0
3 0 198 19515 0 2011.10.19. 22:00:00 0
3 0 199 19515 0 2011.10.19. 22:00:00 0
3 0 200 19515 0 2011.10.19. 22:00:00 0
3 0 201 19515 0 2011.10.19. 22:00:00 0
3 0 202 19515 0 2011.10.19. 22:00:00 0
3 0 224 19543 0 2011.10.19. 22:00:00 0
3 0 225 19543 0 2011.10.19. 22:00:00 0
3 0 226 19543 0 2011.10.19. 22:00:00 0
3 0 227 19543 0 2011.10.19. 22:00:00 0
3 0 228 19543 0 2011.10.19. 22:00:00 0
3 0 229 19543 0 2011.10.19. 22:00:00 0
3 0 230 19543 0 2011.10.19. 22:00:00 0
3 0 231 19543 0 2011.10.19. 22:00:00 0
6 0 137 19625 464000 2011.10.19. 15:10:00 0
6 0 138 19521 464000 2011.10.19. 15:10:00 0
6 0 139 19521 464000 2011.10.19. 15:10:00 0
6 0 140 19590 464000 2011.10.19. 15:10:00 0
6 0 141 19590 464000 2011.10.19. 15:10:00 0
6 0 142 19509 0 2011.10.19. 15:10:00 0
6 0 143 19509 0 2011.10.19. 15:10:00 0
6 0 144 19509 0 2011.10.19. 15:10:00 0
6 0 145 19509 0 2011.10.19. 15:10:00 0
6 0 146 19515 0 2011.10.19. 15:10:00 0
6 0 147 19515 0 2011.10.19. 15:10:00 0
6 0 148 19515 0 2011.10.19. 15:10:00 0
6 0 149 19515 0 2011.10.19. 15:10:00 0
6 0 150 19515 0 2011.10.19. 15:10:00 0
6 0 151 19515 0 2011.10.19. 15:10:00 0
6 0 152 19515 0 2011.10.19. 15:10:00 0
6 0 153 19515 0 2011.10.19. 15:10:00 0
6 0 154 19515 0 2011.10.19. 15:10:00 0
6 0 155 19515 0 2011.10.19. 15:10:00 0
6 0 172 19543 0 2011.10.19. 15:10:00 0
6 0 173 19543 0 2011.10.19. 15:10:00 0
6 0 174 19543 0 2011.10.19. 15:10:00 0
6 0 175 19543 0 2011.10.19. 15:10:00 0
6 0 176 19543 0 2011.10.19. 15:10:00 0
6 0 177 19543 0 2011.10.19. 15:10:00 0
6 0 178 19543 0 2011.10.19. 15:10:00 0
6 0 179 19543 0 2011.10.19. 15:10:00 0
1 0 118 19641 80000 2011.10.20. 17:42:59 0
3 0 221 23934 80000 2011.10.20. 17:43:26 0
1 0 117 19641 80000 2011.10.20. 17:43:37 0
1 0 116 19642 80000 2011.10.20. 17:44:14 0
1 0 124 19642 80000 2011.10.20. 17:44:50 0
1 0 126 19550 80000 2011.10.20. 17:45:29 0
1 0 114 19641 80000 2011.10.20. 17:46:09 0
1 0 113 19641 80000 2011.10.20. 17:46:46 0
3 0 222 23934 80000 2011.10.20. 17:47:11 0
1 0 122 19643 80000 2011.10.20. 17:47:22 0
3 0 220 19640 80000 2011.10.20. 17:47:53 0
1 0 121 19643 80000 2011.10.20. 17:48:07 0
3 0 215 19640 80000 2011.10.20. 17:48:54 0
1 0 120 19643 80000 2011.10.20. 17:49:10 0
3 0 213 19640 80000 2011.10.20. 17:49:48 0
1 0 119 19643 80000 2011.10.20. 17:49:54 0
1 0 112 19641 80000 2011.10.20. 17:50:44 0
3 0 211 19640 80000 2011.10.20. 17:50:59 0
1 0 111 19641 80000 2011.10.20. 17:51:23 0
3 0 210 19640 80000 2011.10.20. 17:51:48 0
1 0 115 19642 80000 2011.10.20. 17:52:27 0
1 0 123 19642 80000 2011.10.20. 17:53:17 0
3 0 219 19640 80000 2011.10.20. 17:53:27 0
3 0 217 19640 80000 2011.10.20. 17:55:13 0
1 0 110 19643 80000 2011.10.20. 17:56:16 0
3 0 218 19640 80000 2011.10.20. 17:56:34 0
3 0 216 19640 80000 2011.10.20. 17:57:10 0
1 0 109 19643 80000 2011.10.20. 17:57:54 0
3 0 214 19640 80000 2011.10.20. 17:58:15 0
3 0 212 19640 80000 2011.10.20. 17:59:14 0
3 0 223 19640 80000 2011.10.20. 17:59:51 0
3 0 209 19640 80000 2011.10.20. 18:00:30 0
3 0 208 19640 80000 2011.10.20. 18:01:29 0
3 0 207 19640 80000 2011.10.20. 18:02:15 0
6 0 167 19640 80000 2011.10.20. 18:02:20 0
3 0 206 23933 80000 2011.10.20. 18:02:56 0
6 0 171 19640 80000 2011.10.20. 18:03:36 0
3 0 205 23933 80000 2011.10.20. 18:03:45 0
3 0 204 23933 80000 2011.10.20. 18:04:25 0
3 0 203 23933 80000 2011.10.20. 18:05:10 0
6 0 169 23932 80000 2011.10.20. 18:05:16 0
6 0 168 23932 80000 2011.10.20. 18:05:55 0
6 0 166 19640 80000 2011.10.20. 18:06:32 0
6 0 156 19640 80000 2011.10.20. 18:07:08 0
6 0 162 23932 80000 2011.10.20. 18:07:49 0
6 0 163 23932 80000 2011.10.20. 18:08:27 0
6 0 164 23932 80000 2011.10.20. 18:09:04 0
6 0 165 23932 80000 2011.10.20. 18:09:47 0
6 0 170 19640 80000 2011.10.20. 18:10:29 0
6 0 161 19640 80000 2011.10.20. 18:11:13 0
6 0 157 19640 80000 2011.10.20. 18:11:59 0
6 0 160 19640 80000 2011.10.20. 18:12:36 0
6 0 158 23932 80000 2011.10.20. 18:13:14 0
6 0 159 23932 80000 2011.10.20. 18:13:59 0