Hello guys.
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
my advice is : you can use it.
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
