|
You last visited: Today at 21:48
Advertisement
VSRO DB CLEAR
Discussion on VSRO DB CLEAR within the SRO Private Server forum part of the Silkroad Online category.
10/21/2015, 20:18
|
#1
|
elite*gold: 0 
Join Date: Sep 2011
Posts: 38
Received Thanks: 0
|
VSRO DB CLEAR
VSRO DB CLEAR FULL QUERY i need
|
|
|
|
10/21/2015, 22:21
|
#2
|
elite*gold: 0
Join Date: Jun 2012
Posts: 113
Received Thanks: 59
|
next time you should use the search engine
change database names with your's
Code:
USE [SRO_VT_SHARD_INIT]
GO
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_OpenMarket]
DELETE FROM [dbo].[_AccountJID]
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildChest]
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
DELETE FROM [dbo].[_SiegeFortress]
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_Char] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]
TRUNCATE TABLE [dbo].[_ItemPool]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]
Code:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[TB_Ref_ItemName]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[SK_DownLevelLog]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
Code:
USE [Log_DB]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]
|
|
|
|
|
10/23/2015, 16:08
|
#3
|
elite*gold: 2
Join Date: Aug 2011
Posts: 833
Received Thanks: 1,130
|
I made a better one, which WONT fuck up fortress war. It uses some existing procedures to reset the db.
Code:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]
TRUNCATE TABLE [dbo].[__TrijobRanking__]
TRUNCATE TABLE [dbo].[__TrijobRankingStatus__]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasData]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_LoginLogoutStatistics]
--[dbo].[_ModuleVersion]
--[dbo].[_ModuleVersionFile]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_OldBlockedUser]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_RefCountryNameAndCode]
--TRUNCATE TABLE [dbo].[_SecurityDescription]
--TRUNCATE TABLE [dbo].[_SecurityDescriptionGroup]
--TRUNCATE TABLE [dbo].[_SecurityDescriptionGroupAssign]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_Shard]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
--[dbo].[_ShardService]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[_WriteOutResetPlayTime]
TRUNCATE TABLE [dbo].[BOOKS]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[SK_DownLevelLog]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_SHL]
TRUNCATE TABLE [dbo].[SK_Silk] -- item mall silk table, one row per user.
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkChange_BY_Web]
TRUNCATE TABLE [dbo].[SK_SilkGoods] -- packages available to buy online
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_CharNames]
TRUNCATE TABLE [dbo].[SR_ShardCharNames] -- character names per shard id
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[tb_partnerInfo]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[TB_Ref_ItemName]
TRUNCATE TABLE [dbo].[TB_User] -- game account database
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[tmp]
DBCC CHECKIDENT (TB_User, RESEED, 0)
SET IDENTITY_INSERT [dbo].[TB_User] ON
INSERT INTO [dbo].[TB_User] ([JID],[StrUserID],[password],[sec_primary],[sec_content],[AccPlayTime],[LatestUpdateTime_ToPlayTime])
VALUES (-1,'Anonymous','password',3,3,0,0)
SET IDENTITY_INSERT [dbo].[TB_User] OFF
USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_OpenMarket]
DELETE FROM [dbo].[_AccountJID]
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildChest]
DELETE FROM [dbo].[_SiegeFortressBattleRecord]
DELETE FROM [dbo].[_SiegeFortressRequest]
DELETE [dbo].[_SiegeFortressStoneState]
EXEC _SiegeFortressResetStructUpgradeLevel_NoTx 1, 0
EXEC _SiegeFortressResetStructUpgradeLevel_NoTx 3, 0
EXEC _SiegeFortressResetStructUpgradeLevel_NoTx 6, 0
DELETE FROM [dbo].[_SiegeFortressStruct]
WHERE RefObjID IN
(SELECT [ID] FROM _RefObjCommon WITH (NOLOCK)
WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 5 AND TypeID4 = 6)
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
UPDATE [dbo].[_SiegeFortress] SET [GuildID] = 0,[TaxRatio] = 0,[Tax] = 0,[NPCHired] = 0,[TempGuildID] = 0,[Introduction] = 'This fortress is free!',[CreatedDungeonTime] = NULL,[CreatedDungeonCount] = 0
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_Char] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]
TRUNCATE TABLE [dbo].[_ItemPool]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
TRUNCATE TABLE [dbo].[_BindingOptionWithItem]
TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_Log_SEEK_N_DESTROY_ITEM_FAST]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45),(46),(47),(48),(49),(50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterActivity]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberActivity]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderActivity]
TRUNCATE TABLE [dbo].[_TrijobRanking4WEB]
UPDATE [dbo].[_TrijobRewards] SET [Reward] = 0
--TRUNCATE TABLE [dbo].[_BlackNameList]
DBCC CHECKIDENT (_Guild, RESEED, 0)
DBCC CHECKIDENT (_AlliedClans, RESEED, 0)
DBCC CHECKIDENT (_Char, RESEED, 0)
DBCC CHECKIDENT (_CharCOS, RESEED, 0)
DBCC CHECKIDENT (_Items, RESEED, 0)
DBCC CHECKIDENT (_TrainingCamp, RESEED, 0)
USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]
|
|
|
|
|
10/23/2015, 20:29
|
#4
|
elite*gold: 0
Join Date: Jun 2012
Posts: 113
Received Thanks: 59
|
Quote:
Originally Posted by Timlock
I made a better one, which WONT **** up fortress war. It uses some existing procedures to reset the db.
[/code]
|
if you got any troubles anyway with fortress you can always reset it with this query
Code:
USE [SRO_VT_SHARD_INIT]
GO
EXEC _ResetSiegeFortress
|
|
|
|
|
10/23/2015, 21:21
|
#5
|
elite*gold: 0
Join Date: Oct 2015
Posts: 113
Received Thanks: 22
|
Code:
USE [SRO_VT_SHARD_INIT]
GO
EXEC _ResetSiegeFortress
This procedure is not existing in my clean database so its not a standard one 
|
|
|
|
|
10/23/2015, 22:29
|
#6
|
elite*gold: 0
Join Date: Jun 2012
Posts: 113
Received Thanks: 59
|
Quote:
Originally Posted by Hynix1337
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
|
|
|
|
|
10/23/2015, 23:00
|
#7
|
elite*gold: 0
Join Date: Oct 2015
Posts: 113
Received Thanks: 22
|
Quote:
Originally Posted by SnapPop
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
|
np thank you i found it in csro-r db 
|
|
|
|
Similar Threads
|
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?
|
All times are GMT +2. The time now is 21:48.
|
|
