vsro

Vsro Çar Silme

PrinceOfPersia

Member
Moderator
9 Nis 2020
46
18
8
Merhaba,bu kod sayesinde istediğiniz bir çarı DB'den hızlıca silebilirsiniz.Çarıd yazan yere çar ıd sını yazarak Sql'e execute yapın.

SQL:
USE [SRO_VT_SHARD]
go
declare @CharID int , @CharName varchar(16)
set @CharName = 'Çarıd'
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
 
Üst