This procedure deletes all the characters if you or someone else make to actively.
original procedure :
Code:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[InitializeShardDB] Script Date: 05/21/2012 17:37:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[InitializeShardDB] as truncate table _CharSkill truncate table _CharSkillMastery truncate table _GuildMember truncate table _Inventory truncate table _StaticAvatar truncate table _User truncate table _Friend truncate table _Memo truncate table _TimedJob truncate table _InvCOS delete from _CharCOS where ID > 0 delete from _Char where charid > 0 truncate table _Chest truncate table _ItemPool delete from _Items where ID64 > 0 delete from _AccountJID truncate table _GuildChest update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 truncate table _GuildWar delete from _Guild where ID > 0 delete from _AlliedClans where ID > 0 truncate table _CharNameList truncate table _CharQuest truncate table _ClientConfig truncate table _DeletedChar exec _LinkRefRegions
Code:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[InitializeShardDB] Script Date: 05/21/2012 17:37:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[InitializeShardDB] as exec _LinkRefRegions