Character security

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