This procedure is not existing in my clean database so its not a standard one
ooops my bad forgot that i was using csro-r , forgive me long time no work with vsro 2 years maybe more xD
anyway still useful for you, so if you need them here they are
Code:
USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_ResetSiegeFortressStruct] Script Date: 10/23/2015 10:22:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_ResetSiegeFortressStruct]
@FortressID INT
AS
DECLARE @RefEventStructID INT
DECLARE @StructCodeName VARCHAR(129)
DECLARE @FortressName VARCHAR(129)
IF @FortressID <= 0
BEGIN
RETURN -1
END
SELECT @FortressName = CodeName128 FROM _RefSiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID
DECLARE FortressStructCursor CURSOR FOR
SELECT [ID],strParam1 FROM _RefEventZone WITH (NOLOCK) WHERE Service = 1 AND strParam2 = (
SELECT _RefGame_World.WorldCodeName128 FROM _RefGame_World
JOIN _RefGame_World_Config
ON _RefGame_World.ConfigGroupCodeName128 = _RefGame_World_Config.GroupCodeName128
WHERE _RefGame_World_Config.Value = @FortressName
AND _RefGame_World_Config.ValueCodeName128 = 'REF_SIEGE_FORTRESS'
)
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로 세팅!
INSERT INTO [dbo]._SiegeFortressStruct VALUES ( @FortressID, 0, @RefEventStructID, @RefObjID, @MaxHP, GetDate(), 0)
END
ELSE
BEGIN
-- 이미 있으면 초기화
UPDATE [dbo]._SiegeFortressStruct
SET FortressID = @FortressID, OwnerGuildID = 0, RefEventStructID = @RefEventStructID, RefObjID = @RefObjID
, HP = @MaxHP, MakeDate = GetDate(), State = 0
WHERE FortressID = @FortressID AND RefEventStructID = @RefEventStructID
END
FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
END
CLOSE FortressStructCursor
DEALLOCATE FortressStructCursor
RETURN 0
GO
Code:
USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_ResetSiegeFortress] Script Date: 10/23/2015 10:22:28 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_ResetSiegeFortress]
AS
DECLARE @FortressID INT
DECLARE FortressCursor CURSOR FAST_FORWARD FOR
SELECT FortressID FROM _RefSiegeFortress WITH (NOLOCK) WHERE Service = 1
OPEN FortressCursor
FETCH NEXT FROM FortressCursor INTO @FortressID
WHILE (@@fetch_status = 0)
BEGIN
IF NOT EXISTS (SELECT * FROM _SiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID)
BEGIN
-- 레퍼런스 테이블에서 포트리스 인스턴스를 미리 만든다. 값은 모두 default로 세팅!
INSERT INTO [dbo]._SiegeFortress(FortressID) VALUES ( @FortressID )
-- 요새 내 구조물을 세팅한다.
EXEC _ResetSiegeFortressStruct @FortressID
END
ELSE
BEGIN
--이미 있으면 초기화 하자
-- 레퍼런스 테이블에서 포트리스 인스턴스를 미리 만든다. 값은 모두 default로 세팅!
Update [dbo]._SiegeFortress Set GuildID = 0, TaxRatio = 0, Tax = 0, NPCHired = 0, TempGuildID = 0
where FortressID = @FortressID
-- 요새 내 구조물을 세팅한다.
EXEC _ResetSiegeFortressStruct @FortressID
END
FETCH NEXT FROM FortressCursor INTO @FortressID
END
CLOSE FortressCursor
DEALLOCATE FortressCursor
TRUNCATE TABLE _SiegeFortressBattleRecord
GO
Code:
USE [SRO_VT_SHARD_INIT]
GO
EXEC _ResetSiegeFortress
ooops my bad forgot that i was using csro-r , forgive me long time no work with vsro 2 years maybe more xD
anyway still useful for you, so if you need them here they are
Code:
USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_ResetSiegeFortressStruct] Script Date: 10/23/2015 10:22:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_ResetSiegeFortressStruct]
@FortressID INT
AS
DECLARE @RefEventStructID INT
DECLARE @StructCodeName VARCHAR(129)
DECLARE @FortressName VARCHAR(129)
IF @FortressID <= 0
BEGIN
RETURN -1
END
SELECT @FortressName = CodeName128 FROM _RefSiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID
DECLARE FortressStructCursor CURSOR FOR
SELECT [ID],strParam1 FROM _RefEventZone WITH (NOLOCK) WHERE Service = 1 AND strParam2 = (
SELECT _RefGame_World.WorldCodeName128 FROM _RefGame_World
JOIN _RefGame_World_Config
ON _RefGame_World.ConfigGroupCodeName128 = _RefGame_World_Config.GroupCodeName128
WHERE _RefGame_World_Config.Value = @FortressName
AND _RefGame_World_Config.ValueCodeName128 = 'REF_SIEGE_FORTRESS'
)
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로 세팅!
INSERT INTO [dbo]._SiegeFortressStruct VALUES ( @FortressID, 0, @RefEventStructID, @RefObjID, @MaxHP, GetDate(), 0)
END
ELSE
BEGIN
-- 이미 있으면 초기화
UPDATE [dbo]._SiegeFortressStruct
SET FortressID = @FortressID, OwnerGuildID = 0, RefEventStructID = @RefEventStructID, RefObjID = @RefObjID
, HP = @MaxHP, MakeDate = GetDate(), State = 0
WHERE FortressID = @FortressID AND RefEventStructID = @RefEventStructID
END
FETCH NEXT FROM FortressStructCursor INTO @RefEventStructID, @StructCodeName
END
CLOSE FortressStructCursor
DEALLOCATE FortressStructCursor
RETURN 0
GO
Code:
USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_ResetSiegeFortress] Script Date: 10/23/2015 10:22:28 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_ResetSiegeFortress]
AS
DECLARE @FortressID INT
DECLARE FortressCursor CURSOR FAST_FORWARD FOR
SELECT FortressID FROM _RefSiegeFortress WITH (NOLOCK) WHERE Service = 1
OPEN FortressCursor
FETCH NEXT FROM FortressCursor INTO @FortressID
WHILE (@@fetch_status = 0)
BEGIN
IF NOT EXISTS (SELECT * FROM _SiegeFortress WITH (NOLOCK) WHERE FortressID = @FortressID)
BEGIN
-- 레퍼런스 테이블에서 포트리스 인스턴스를 미리 만든다. 값은 모두 default로 세팅!
INSERT INTO [dbo]._SiegeFortress(FortressID) VALUES ( @FortressID )
-- 요새 내 구조물을 세팅한다.
EXEC _ResetSiegeFortressStruct @FortressID
END
ELSE
BEGIN
--이미 있으면 초기화 하자
-- 레퍼런스 테이블에서 포트리스 인스턴스를 미리 만든다. 값은 모두 default로 세팅!
Update [dbo]._SiegeFortress Set GuildID = 0, TaxRatio = 0, Tax = 0, NPCHired = 0, TempGuildID = 0
where FortressID = @FortressID
-- 요새 내 구조물을 세팅한다.
EXEC _ResetSiegeFortressStruct @FortressID
END
FETCH NEXT FROM FortressCursor INTO @FortressID
END
CLOSE FortressCursor
DEALLOCATE FortressCursor
TRUNCATE TABLE _SiegeFortressBattleRecord
GO
Code:
USE [SRO_VT_SHARD_INIT]
GO
EXEC _ResetSiegeFortress
VSRO Clear client 01/21/2015 - SRO Private Server - 3 Replies is there any link to download clear client version >= 188
I tried to find a lot using google, search tool here but nothing help. Someone has server files vsro based and translated to english?
I wanna original DB without customs. If someone has please share it with me.
Clear Stats Without Soul Clear? 03/15/2010 - 12Sky2 - 0 Replies Just as the topic says, is there a way to reset your stats without a Soul Clear? I imagine it's possible, but does anybody know how?
