[HIDE]
USE [SRO_VT_SHARD]
go
declare @CharID int , @CharName varchar(16)
set @CharName = 'CharAdıYaz'
set @CharID = ( select CharID from _Char where CharName16 = @CharName )
DELETE FROM _InventoryForAvatar WHERE CharID = @CharID
DELETE FROM _Inventory WHERE CharID = @CharID
DELETE FROM _CharSkillMastery WHERE CharID = @CharID
DELETE FROM _CharSkill WHERE CharID = @CharID
DELETE FROM _CharTrijob WHERE CharID = @CharID
DELETE FROM _User WHERE CharID = @CharID
DELETE FROM _StaticAvatar WHERE CharID = @CharID
DELETE FROM _TimedJob WHERE CharID = @CharID
DELETE FROM _Char WHERE CharID = @CharID
--DELETE FROM _CharQuest where CharID = @CharID
[/HIDE]
USE [SRO_VT_SHARD]
go
declare @CharID int , @CharName varchar(16)
set @CharName = 'CharAdıYaz'
set @CharID = ( select CharID from _Char where CharName16 = @CharName )
DELETE FROM _InventoryForAvatar WHERE CharID = @CharID
DELETE FROM _Inventory WHERE CharID = @CharID
DELETE FROM _CharSkillMastery WHERE CharID = @CharID
DELETE FROM _CharSkill WHERE CharID = @CharID
DELETE FROM _CharTrijob WHERE CharID = @CharID
DELETE FROM _User WHERE CharID = @CharID
DELETE FROM _StaticAvatar WHERE CharID = @CharID
DELETE FROM _TimedJob WHERE CharID = @CharID
DELETE FROM _Char WHERE CharID = @CharID
--DELETE FROM _CharQuest where CharID = @CharID
[/HIDE]
