02-10-2014, 06:35 PM
|
#18
|
|
|
• الانـتـسـاب » Jan 2014
|
|
• رقـم العـضـويـة » 116050
|
|
• المشـــاركـات » 7,017
|
|
• الـدولـة » Egypt
|
|
• الـهـوايـة » ;"#string n = "C
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 85
|
|
|
|
.gif)
اعمل دول فى ال _SiegeFortressStruct
كود PHP:
1 384 84 19538 1170000 22.08.2009 11:00:00 0
1 384 85 19521 580000 22.08.2009 11:00:00 0
1 384 86 19521 580000 22.08.2009 11:00:00 0
1 384 87 19521 580000 22.08.2009 11:00:00 0
1 384 88 19504 1170000 22.08.2009 11:00:00 0
1 384 89 19504 1170000 22.08.2009 11:00:00 0
1 384 90 19504 1170000 22.08.2009 11:00:00 0
1 384 91 19509 0 22.08.2009 11:00:00 0
1 384 92 19509 0 22.08.2009 11:00:00 0
1 384 93 19509 0 22.08.2009 11:00:00 0
1 384 94 19509 0 22.08.2009 11:00:00 0
1 384 95 19509 0 22.08.2009 11:00:00 0
1 384 96 19509 0 22.08.2009 11:00:00 0
1 384 97 19515 0 22.08.2009 11:00:00 0
1 384 98 19515 0 22.08.2009 11:00:00 0
1 384 99 19515 0 22.08.2009 11:00:00 0
1 384 100 19515 0 22.08.2009 11:00:00 0
1 384 101 19515 0 22.08.2009 11:00:00 0
1 384 102 19515 0 22.08.2009 11:00:00 0
1 384 103 19515 0 22.08.2009 11:00:00 0
1 384 104 19515 0 22.08.2009 11:00:00 0
1 384 105 19515 0 22.08.2009 11:00:00 0
1 384 106 19515 0 22.08.2009 11:00:00 0
1 384 107 19515 0 22.08.2009 11:00:00 0
1 384 108 19515 0 22.08.2009 11:00:00 0
6 863 137 19628 1024000 17.08.2011 12:44:42 0
6 863 138 19532 1024000 17.08.2011 12:42:48 0
6 863 139 19532 1024000 17.08.2011 12:43:59 0
6 863 140 19593 1024000 17.08.2011 12:43:01 0
6 863 141 19593 1024000 17.08.2011 12:43:31 0
6 863 142 19513 416000 17.08.2011 12:43:05 0
6 863 143 19513 416000 17.08.2011 12:43:08 0
6 863 144 19513 416000 17.08.2011 12:43:25 0
6 863 145 19513 416000 17.08.2011 12:43:37 0
6 863 146 19519 416000 17.08.2011 12:42:58 0
6 863 147 19519 416000 17.08.2011 12:43:19 0
6 863 148 19519 416000 17.08.2011 12:44:06 0
6 863 149 19519 416000 17.08.2011 12:43:53 0
6 863 150 19519 416000 17.08.2011 12:42:37 0
6 863 151 19519 416000 17.08.2011 12:42:45 0
6 863 152 19519 416000 17.08.2011 12:44:32 0
6 863 153 19519 416000 17.08.2011 12:44:37 0
6 863 154 19519 416000 17.08.2011 12:44:19 0
1 0 127 19543 0 20.08.2011 15:30:00 0
1 0 128 19543 0 20.08.2011 15:30:00 0
1 0 129 19543 0 20.08.2011 15:30:00 0
1 0 130 19543 0 20.08.2011 15:30:00 0
1 0 131 19543 0 20.08.2011 15:30:00 0
1 0 132 19543 0 20.08.2011 15:30:00 0
1 0 133 19543 0 20.08.2011 15:30:00 0
1 0 134 19543 0 20.08.2011 15:30:00 0
1 0 135 19543 0 20.08.2011 15:30:00 0
1 0 136 19543 0 20.08.2011 15:30:00 0
6 863 155 19519 416000 17.08.2011 12:44:12 0
3 848 180 19613 1632000 16.08.2011 10:25:04 0
3 848 181 19532 1024000 16.08.2011 10:24:03 0
3 848 182 19524 1024000 16.08.2011 10:24:55 0
3 848 183 19528 1024000 16.08.2011 10:24:45 0
3 848 184 19578 1632000 16.08.2011 10:23:33 0
3 848 185 19578 1632000 16.08.2011 10:24:18 0
3 848 186 19578 1632000 16.08.2011 10:23:41 0
3 848 187 19513 416000 16.08.2011 10:23:23 0
3 848 188 19513 416000 16.08.2011 10:23:13 0
3 848 189 19513 416000 16.08.2011 10:24:13 0
3 848 190 19513 416000 16.08.2011 10:24:23 0
3 848 191 19513 416000 16.08.2011 10:23:46 0
3 848 192 19513 416000 16.08.2011 10:23:52 0
3 848 193 19519 416000 16.08.2011 10:23:58 0
3 848 194 19519 416000 16.08.2011 10:24:07 0
3 848 195 19519 416000 16.08.2011 10:24:40 0
6 0 172 19543 0 20.08.2011 15:30:00 0
6 0 173 19543 0 20.08.2011 15:30:00 0
6 0 174 19543 0 20.08.2011 15:30:00 0
6 0 175 19543 0 20.08.2011 15:30:00 0
6 0 176 19543 0 20.08.2011 15:30:00 0
6 0 177 19543 0 20.08.2011 15:30:00 0
6 0 178 19543 0 20.08.2011 15:30:00 0
6 0 179 19543 0 20.08.2011 15:30:00 0
3 848 196 19519 416000 16.08.2011 10:24:35 0
3 848 197 19519 416000 16.08.2011 10:24:31 0
3 848 198 19519 416000 16.08.2011 10:24:48 0
3 848 199 19519 416000 16.08.2011 10:25:00 0
3 848 200 19517 256000 16.08.2011 10:25:25 0
3 848 201 19517 256000 16.08.2011 10:25:16 0
3 848 202 19519 416000 16.08.2011 10:25:07 0
3 0 224 19543 0 20.08.2011 15:30:00 0
3 0 225 19543 0 20.08.2011 15:30:00 0
3 0 226 19543 0 20.08.2011 15:30:00 0
3 0 227 19543 0 20.08.2011 15:30:00 0
3 0 228 19543 0 20.08.2011 15:30:00 0
3 0 229 19543 0 20.08.2011 15:30:00 0
3 0 230 19543 0 20.08.2011 15:30:00 0
3 0 231 19543 0 20.08.2011 15:30:00 0
NULL NULL NULL NULL NULL NULL NULL
بدال اللى عندك
و بدة خد باك اب الاول
كود PHP:
USE [SRO_VT_SHARD]
GO
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 Hero
|
|
|
التعديل الأخير تم بواسطة Hero ; 02-10-2014 الساعة 06:38 PM
|