|
You last visited: Today at 00:51
Advertisement
[Request Help] Issue with Fortress War
Discussion on [Request Help] Issue with Fortress War within the SRO Private Server forum part of the Silkroad Online category.
05/05/2012, 23:18
|
#1
|
elite*gold: 0
Join Date: Apr 2012
Posts: 40
Received Thanks: 21
|
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
|
|
|
05/06/2012, 17:41
|
#2
|
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
|
here is.Change your _InsertSiegeFortressStruct procedure with this one
Code:
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
|
|
|
05/06/2012, 17:49
|
#3
|
elite*gold: 0
Join Date: Apr 2012
Posts: 40
Received Thanks: 21
|
Quote:
Originally Posted by mertcoskun
here is.Change your _InsertSiegeFortressStruct procedure with this one
Code:
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?
|
|
|
05/06/2012, 19:36
|
#4
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,163
Received Thanks: 1,161
|
[ droppx3 ]
Add me I'll help you.
|
|
|
05/06/2012, 21:46
|
#5
|
elite*gold: 0
Join Date: Apr 2012
Posts: 40
Received Thanks: 21
|
Quote:
Originally Posted by ღ ∂ropp
[ droppx3 ]
Add me I'll help you.
|
this [ droppx3 ] skype??
|
|
|
05/06/2012, 22:13
|
#6
|
elite*gold: 0
Join Date: Jan 2012
Posts: 1,867
Received Thanks: 1,091
|
Quote:
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
|
|
|
05/06/2012, 23:25
|
#7
|
elite*gold: 325
Join Date: Dec 2008
Posts: 14,543
Received Thanks: 8,717
|
#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)
|
|
|
All times are GMT +2. The time now is 00:51.
|
|