(Help) Delete Char!

hi.. i get this code from member ragezone

Code:

---

USE SRO_VT_SHARD
DECLARE @CharID INT;
SET @CharID = '122'
DELETE FROM _CharSkill
WHERE (CharID = @CharID)
DELETE FROM _CharSkillMastery
WHERE (CharID = @CharID)
DELETE FROM _GuildMember
WHERE (CharID = @CharID)
DELETE FROM _Inventory
WHERE (CharID = @CharID)
DELETE FROM _StaticAvatar
WHERE (CharID = @CharID)
DELETE FROM _User
WHERE (CharID = @CharID)
DELETE FROM _CharTrijob
WHERE (CharID = @CharID)
DELETE FROM _InventoryForAvatar
WHERE (CharID = @CharID)
DELETE FROM _CharQuest
WHERE (CharID = @CharID)
DELETE FROM _TimedJob
WHERE (CharID = @CharID)
DELETE FROM _Char
WHERE (CharID = @CharID)

---

that is single char delete.. how to group delete..
example i need delete from charId 122 to 4000
"SET @CharID = '122'to'4000'"

How? please help.

PHP Code:

---

USE SRO_VT_SHARD

Declare @Counter int, @CharID int;
SET @Counter = 122
while (@Counter <= 4000)
BEGIN 
SET @CharID = @Counter

DELETE FROM _CharSkill
WHERE (CharID = @CharID)
DELETE FROM _CharSkillMastery
WHERE (CharID = @CharID)
DELETE FROM _GuildMember
WHERE (CharID = @CharID)
DELETE FROM _Inventory
WHERE (CharID = @CharID)
DELETE FROM _StaticAvatar
WHERE (CharID = @CharID)
DELETE FROM _User
WHERE (CharID = @CharID)
DELETE FROM _CharTrijob
WHERE (CharID = @CharID)
DELETE FROM _InventoryForAvatar
WHERE (CharID = @CharID)
DELETE FROM _CharQuest
WHERE (CharID = @CharID)
DELETE FROM _TimedJob
WHERE (CharID = @CharID)
DELETE FROM _Char
WHERE (CharID = @CharID)

SET @Counter = @Counter + 1
END 


---

OR

PHP Code:

---

USE SRO_VT_SHARD
Declare @FROM int, @TO int;

SET @FROM = 122;
SET @TO = 4000;

DELETE FROM _CharSkill
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _CharSkillMastery
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _GuildMember
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _Inventory
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _StaticAvatar
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _User
WHERE ((CharID BETWEEN @FROM AND @TO)
DELETE FROM _CharTrijob
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _InventoryForAvatar
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _CharQuest
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _TimedJob
WHERE (CharID BETWEEN @FROM AND @TO)
DELETE FROM _Char
WHERE (CharID BETWEEN @FROM AND @TO) 


---

and a little off-topic, how to reduce delay of 7days char deletation?

Quote:

---

Originally Posted by hatibudak

hi.. i get this code from member ragezone

Code:

---

USE SRO_VT_SHARD
DECLARE @CharID INT;
SET @CharID = 122
DELETE FROM _CharSkill
WHERE (CharID = @CharID)
DELETE FROM _CharSkillMastery
WHERE (CharID = @CharID)
DELETE FROM _GuildMember
WHERE (CharID = @CharID)
DELETE FROM _Inventory
WHERE (CharID = @CharID)
DELETE FROM _StaticAvatar
WHERE (CharID = @CharID)
DELETE FROM _User
WHERE (CharID = @CharID)
DELETE FROM _CharTrijob
WHERE (CharID = @CharID)
DELETE FROM _InventoryForAvatar
WHERE (CharID = @CharID)
DELETE FROM _CharQuest
WHERE (CharID = @CharID)
DELETE FROM _TimedJob
WHERE (CharID = @CharID)
DELETE FROM _Char
WHERE (CharID = @CharID)

---

that is single char delete.. how to group delete..
example i need delete from charId 122 to 4000
"SET @CharID = '122'to'4000'"

How? please help.

---

Code:

---

USE SRO_VT_SHARD
DELETE FROM _CharSkill
DELETE FROM _CharSkillMastery
DELETE FROM _GuildMember
DELETE FROM _Inventory
DELETE FROM _StaticAvatar
DELETE FROM _User
DELETE FROM _CharTrijob
DELETE FROM _InventoryForAvatar
DELETE FROM _CharQuest
DELETE FROM _TimedJob
DELETE FROM _Char
WHERE CharID BETWEEN '122' AND '4000'

---

well try this one

This is work fine.. Ty Caipi :)

Code:

---

USE SRO_VT_SHARD

Declare @Counter int, @CharID int;
SET @Counter = 122
while (@Counter <= 4000)
BEGIN
SET @CharID = @Counter

DELETE FROM _CharSkill
WHERE (CharID = @CharID)
DELETE FROM _CharSkillMastery
WHERE (CharID = @CharID)
DELETE FROM _GuildMember
WHERE (CharID = @CharID)
DELETE FROM _Inventory
WHERE (CharID = @CharID)
DELETE FROM _StaticAvatar
WHERE (CharID = @CharID)
DELETE FROM _User
WHERE (CharID = @CharID)
DELETE FROM _CharTrijob
WHERE (CharID = @CharID)
DELETE FROM _InventoryForAvatar
WHERE (CharID = @CharID)
DELETE FROM _CharQuest
WHERE (CharID = @CharID)
DELETE FROM _TimedJob
WHERE (CharID = @CharID)
DELETE FROM _Char
WHERE (CharID = @CharID)

SET @Counter = @Counter + 1
END

---

Nati114:
The statement has been terminated.
FK__CharCOS__Char
FK__CharTrijobSafeTrade__CharTrijob

if you want to delete every information, use this:

Code:

---

USE SRO_VT_SHARD
DELETE FROM _CharSkill
DELETE FROM _CharSkillMastery
DELETE FROM _GuildMember
DELETE FROM _Inventory
DELETE FROM _StaticAvatar
DELETE FROM _User
DELETE FROM _CharTrijob
DELETE FROM _CharTrijobSafeTrade
DELETE FROM _InventoryForAvatar
DELETE FROM _CharQuest
DELETE FROM _TimedJob
DELETE FROM _TimedJobForPet
DELETE FROM _Char
DELETE FROM _CharCollectionBook
DELETE FROM _CharInstanceWorldData
DELETE FROM _CharNameList
DELETE FROM _CharNickNameList
DELETE FROM _ClientConfig
DELETE FROM _DeletedChar
DELETE FROM _ExploitLog
DELETE FROM _FleaMarketNetwork
DELETE FROM _Friend
DELETE FROM _GuildMember
DELETE FROM _TrainingCampMember
DELETE FROM _TrainingCampSubMentorHonorPoint
WHERE CharID BETWEEN '0' AND '30000'
DELETE FROM _CharCOS where ID BETWEEN '0' AND '30000'
DELETE FROM _Chest where UserJID BETWEEN '0' AND '30000'
DELETE FROM _ChestInfo where JID BETWEEN '0' AND '30000'
DELETE FROM _GPHistory where GuildID BETWEEN '0' AND '30000'
DELETE FROM _Guild where ID BETWEEN '1' AND '30000'
DELETE FROM _GuildChest where GuildID BETWEEN '0' AND '30000'
DELETE FROM _GuildWar where ID BETWEEN '0' AND '30000'
DELETE FROM _InvCOS where COSID BETWEEN '0' AND '30000'
DELETE FROM _TrainingCampBuffStatus where CampID BETWEEN '0' AND '30000'

---

Simple script because im not developer... remember to use twice