ارجو دخول الخبراء

[loverslove]

كل اما انزل دول وقت FW يجبلى DC
http://im90.gulfup.com/0Yq9NA.png

[Hero]

يبقا اتاكد من ال ID بتعهم فى الميديا

[loverslove]

اتأكدت وبيحصل DC اعمل ايه

[Hero]

اول ما بتشتريهم بيجيلك DC ? و بتعرف تدخل تانى ولا اية بلظبط

[loverslove]

اول اما ادوس عليها وعلم على مكان النزول يجلى DC

[loverslove]

فين ال add items

[Hero]

بص يا وحش خد الاسم كوبى و ضور علية فى ال itemdata فى الميديا و اتاكد من ال ID و بعدين اتاكد من ال 4 تابات اللى فى الداتا بيز بتوع ال add item

[loverslove]

ايه موضوع الادد ايتم ده

[loverslove]

انا بخده من NPC عادى انا بيجلى Dc انا احى انزله وقت FW

[Hero]

اللى هما
refshopgoods
refscrapofpackageitem
refpricepolicyofitem
refpackageitem

[loverslove]

وبعد مخدهم ؟

[Hero]

يا باشا تخدهم انا بقولك شوف كود الايتم اللى فى الداتا بيز من التابات دول
خلية زى اللى فى الميديا

[loverslove]

اتأكدت وطلع صح

[Hero]

اتاكد من ال 4 تاب فى الداتا بيز خلتهم فى الميديا ؟

[loverslove]

اوك حتأكد وحرد عليك بجد متشكر على المساعده

[Hero]

تحت امرك اهم حاجة اهتم بلموضوع

[loverslove]

أتأكدت وطلعو صح

[Hero]

اعمل دول فى ال _SiegeFortressStruct
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
بدال اللى عندك
و بدة خد باك اب الاول
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

[loverslove]

مفيش حل ؟

[Hero]

طيب اول ما بتنزلهم ازاى و انت جايب صورتهم
لو اول ما بتكتب الكود بيجيلك Dc اتاكد من ال bsr فى ال itemdata

[loverslove]

اناكدت انا بقولك اول مبدوس عليهم واحدد المكان الحينزل فيه وادوس yes يجلى DC

[Hero]

يبقا هيا غلط من الاول