[Request Help] Issue with Fortress War

[_NeverGiveUp_]

i want any one help me to make Fortress War in my server when i make it not work need any one help me




Thx

i need any one make for me Fortress War in my server all player hate me in my server no Fortress War not work


when i make any thing here _SiegeFortressStruct

get error in SQL



i hope to found one help me

[mertcoskun]

here is.Change your _InsertSiegeFortressStruct procedure with this one

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





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

Enjoy

[_NeverGiveUp_]

Originally Posted by mertcoskun

here is.Change your _InsertSiegeFortressStruct procedure with this one

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





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

Enjoy

you skype or msn or yahoo pls?

[ღ ∂ Ropp]

[ droppx3 ]
Add me I'll help you.

[_NeverGiveUp_]

Originally Posted by ღ ∂ropp

[ droppx3 ]
Add me I'll help you.

this [ droppx3 ] skype??

[•ᵔBeGodOfWarᵔ•]

Originally Posted by _NeverGiveUp_

this [ droppx3 ] skype??

Ye her skype email is droppx3
You can press skype icon to know what is the person skype id if he got / add it into his profile
also you can know what is the id of all messengers when any member add full of them by the icon under the membership info ../

regards

[Disco Teka]

#moved all posts to this thread

Please do not create more than 1 thread for the same case.
And use the right section.

#closed (on request)