|
You last visited: Today at 14:25
Advertisement
[RELEASE] PROPER VSRO Database Wipe Script
Discussion on [RELEASE] PROPER VSRO Database Wipe Script within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
10/23/2015, 16:15
|
#1
|
elite*gold: 2 
Join Date: Aug 2011
Posts: 833
Received Thanks: 1,130
|
[RELEASE] PROPER VSRO Database Wipe Script
A long time ago I made a PROPER script for wiping my vsro database.
This script is the proper way of wiping the database using existing procedures and primary index resets. This script WILL NOT fuck up fortress war like the other one everyone uses.
Included is account, shard and log database.
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/24/2015, 16:07
|
#2
|
elite*gold: 0
Join Date: Jul 2015
Posts: 613
Received Thanks: 192
|
Good job, Keep it up
|
|
|
|
|
10/25/2015, 12:58
|
#3
|
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
|
What about dat huh ?
Code:
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
|
|
|
|
|
10/25/2015, 15:56
|
#4
|
elite*gold: 0
Join Date: Feb 2008
Posts: 962
Received Thanks: 650
|
Quote:
Originally Posted by Gummiℯs
What about dat huh ?
Code:
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
|
You think that line will work as a valid account? are you that retarded?
|
|
|
|
|
10/25/2015, 19:26
|
#5
|
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
|
Quote:
Originally Posted by magicanoo
You think that line will work as a valid account? are you that retarded?
|
Nope it won't work -_- but Why did he put this line? 
About @****** Iam Sure that you are speaking about your filter.
|
|
|
|
|
10/25/2015, 20:55
|
#6
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by Gummiℯs
Nope it won't work -_- but Why did he put this line?
About @****** Iam Sure that you are speaking about your filter. |
Have you ever reset the identity value? No? Ok.
|
|
|
|
|
10/26/2015, 01:20
|
#7
|
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
|
Quote:
Originally Posted by Exo
Have you ever reset the identity value? No? Ok.
|
Are you speaking with yourself ?
|
|
|
|
|
10/26/2015, 21:34
|
#8
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
|
Reseeding the table "_Char" will **** up the first created character on the server, including everything created within that instance, e.g. Chest, Inventory, Guild property, etc. (and bugging some created afterwards, not always the case).
Just a warning to those who are using such queries without any know-how.
You should rather drop the FKs with all its links instead of reseeding that table.
And yes, the manually created "account" won't do anything. Wasted some lines there.
|
|
|
|
|
10/28/2015, 15:24
|
#9
|
elite*gold: 2
Join Date: Aug 2011
Posts: 833
Received Thanks: 1,130
|
Quote:
Originally Posted by Gummiℯs
What about dat huh ?
Code:
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
|
I use a -1 id based account id for the websites I make & guest sessions... it not a real account.
if a cookie session is used with no account id, that row is selected instead.
if you don't want it, just comment it out.
Quote:
Originally Posted by blapanda
Reseeding the table "_Char" will fuck up the first created character on the server, including everything created within that instance, e.g. Chest, Inventory, Guild property, etc. (and bugging some created afterwards, not always the case).
Just a warning to those who are using such queries without any know-how.
You should rather drop the FKs with all its links instead of reseeding that table.
And yes, the manually created "account" won't do anything. Wasted some lines there.
|
No it doesn't fuck it up. resetting the CURRENT index to zero, which means the next entry will be 1.
And you cant drop the table because those 5 tables have a 0 based rows for a dummy char / guild.
|
|
|
|
|
10/28/2015, 18:54
|
#10
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
|
That "dummy" is doing nothing, actually. Everybody gets rid of it.
|
|
|
|
|
10/28/2015, 19:50
|
#11
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Quote:
Originally Posted by Timlock
No it doesn't **** it up. resetting the CURRENT index to zero, which means the next entry will be 1.
And you cant drop the table because those 5 tables have a 0 based rows for a dummy char / guild.
|
i already tested it and ****** my _char table
|
|
|
|
|
10/29/2015, 10:00
|
#12
|
elite*gold: 294
Join Date: Sep 2013
Posts: 1,410
Received Thanks: 635
|
Quote:
Originally Posted by Timlock
A long time ago I made a PROPER script for wiping my vsro database.
This script is the proper way of wiping the database using existing procedures and primary index resets. This script WILL NOT fuck up fortress war like the other one everyone uses.
Included is account, shard and log database.
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]
|
Yo, that delete from _char where CharID > 0 is simple, but this will keep the primary index of the charIDs. Better prepare a truncate statement and a following insert statement of the dummy character to get the index back to 0 or 1.
ups nvm. I havent seen " DBCC CHECKIDENT (_Char, RESEED, 0) "
|
|
|
|
|
11/26/2015, 21:05
|
#13
|
elite*gold: 260
Join Date: Nov 2015
Posts: 31
Received Thanks: 9
|
Thanks for the scripts, I changed the RESEEDs to 1 though.
|
|
|
|
Similar Threads
|
[Help]How To Wipe Database[Help]
01/07/2011 - EO PServer Hosting - 4 Replies
I Need To Wipe My Database But Dont Know How. I have Searched And Searched But Still No Look. Would Appreciate The Help Thanks
I Need To Wipe My Database But Dont Know How. I have Searched And Searched But Still No Look. Would Appreciate The Help Thanks
|
[Release] PSC Database Script
02/27/2010 - Metin2 PServer Guides & Strategies - 56 Replies
Hallo,
ich hatte langeweile und hab euch mal ein Paysafecard-Script geschrieben, das die Accountid und die Paysafecard-Nummer in der Database speichert ;)
Es ist nichts besonderes aber könnte anderen helfen.
Anleitung:
Die config.php in dem Ordner 'inc' anpassen.
Die install.php im Ordner 'install' über xampp/webspace oder sonstiges ausführen (Xampp: http://localhost/install/install.php)
Danach könnt ihr das Script benutzen ;)
MFG
P.S. Datei im Anhang!
|
All times are GMT +1. The time now is 14:26.
|
|
![[RELEASE] PROPER VSRO Database Wipe Script](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-proper-vsro-database-wipe-script_ltr.gif){kind=small}
