Help Query Code Char delete

JamalXd · 06/01/2012, 03:15

hi guys. my db have char delete bug.7500 account waiting delete.

this codes only 1x account deleted. i dont want 7500 account manuel delete.Anyone help me query code?.

DELETE FROM _InventoryForAvatar WHERE charid = '81935'
DELETE FROM _Inventory WHERE charid = '81935'
DELETE FROM _CharSkillMastery WHERE charid = '81935'
DELETE FROM _CharSkill WHERE charid = '81935'
DELETE FROM _CharTrijob WHERE charid = '81935'
DELETE FROM _User WHERE charid = '81935'
DELETE FROM _StaticAvatar WHERE charid = '81935'
DELETE FROM _TimedJob WHERE charid = '81935'
DELETE FROM _char WHERE charid = '81935'

One people help me can edit sql code for delete delete _invontory from _char where deleted = '1' example.this code delete all _invontory :S all chars

sorry my eng bad:S

abosekena · 06/20/2012, 19:23

this easy
Make Pm me to skype:- where_love2003
and i tell you how you make it

~~CuteSpear~~ · 04/19/2013, 23:23

if you want to delete all characters from Database use it in SRO_VT_SHARD
truncate table _OpenMarket
print 'Cleaned _OpenMarket'
truncate table _CharSkill
print 'Cleaned _CharSkill'
truncate table _CharSkillMastery
print 'Cleaned _CharSkillMastery'
truncate table _GuildMember
print 'Cleaned _GuildMember'
truncate table _BlockedWhisperers
print 'Cleaned _BlockedWhisperers'
truncate table _Inventory
print 'Cleaned _Inventory'
truncate table _InventoryForAvatar
print 'Cleaned _InventoryForAvatar'
truncate table _InventoryForLinkedStorage
print 'Cleaned _InventoryForLinkedStorage'
truncate table _TrainingCampMember
print 'Cleaned _TrainingCampMember'
truncate table _TrainingCampSubMentorHonorPoint
print 'Cleaned _TrainingCampSubMentorHonorPoint'
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL
print 'Cleaned _TrainingCampHonorRank'
truncate table _TrainingCampBuffStatus
print 'Cleaned _TrainingCampBuffStatus'
delete from _TrainingCamp
print 'Cleaned _TrainingCamp'
truncate table _StaticAvatar
print 'Cleaned _StaticAvatar'
truncate table _User
print 'Cleaned _User'
truncate table _Friend
print 'Cleaned _Friend'
truncate table _Memo
print 'Cleaned _Memo'
truncate table _TimedJob
print 'Cleaned _TimedJob'
truncate table _CharTrijobSafeTrade
print 'Cleaned _CharTrijobSafeTrade'
delete from _CharTrijob
print 'Cleaned _CharTrijob'
truncate table _InvCOS
print 'Cleaned _InvCOS'
delete from _CharCOS where ID > 0
print 'Cleaned _CharCOS'
delete from _Char where charid > 0
print 'Cleaned _Char'
truncate table _Chest
print 'Cleaned _Chest'
truncate table _ChestInfo
print 'Cleaned _ChestInfo'
truncate table _ItemPool
print 'Cleaned _ItemPool'
delete from _Items where ID64 > 0
print 'Cleaned _Items'
delete from _AccountJID
print 'Cleaned _AccountJID'
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
print 'Cleaned _AlliedClans'
truncate table _GuildWar
print 'Cleaned _GuildWar'
truncate table _CharNameList
print 'Cleaned _CharNameList'
truncate table _CharQuest
print 'Cleaned _CharQuest'
truncate table _ClientConfig
print 'Cleaned _ClientConfig'
truncate table _DeletedChar
print 'Cleaned _DeletedChar'
truncate table _SiegeFortressStoneState
print 'Cleaned _SiegeFortressStoneState'
truncate table _SiegeFortressRequest
print 'Cleaned _SiegeFortressRequest'
truncate table _SiegeFortressObject
print 'Cleaned _SiegeFortressObject'
truncate table _SiegeFortressItemForge
print 'Cleaned _SiegeFortressItemForge'
truncate table _SiegeFortressBattleRecord
print 'Cleaned _SiegeFortressBattleRecord'
update _SiegeFortressStruct SET OwnerGuildID = '0'
print 'Cleaned _SiegeFortressStruct'
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
print 'Cleaned _SiegeFortress'
truncate table _CharNickNameList
print 'Cleaned _CharNickNameList'
truncate table _GPHistory
print 'Cleaned _GPHistory'
truncate table _GuildChest
print 'Cleaned _GuildChest'
delete from _Guild where ID > 0
print 'Cleaned _Guild'
delete from _AlliedClans where ID > 0
print 'Cleaned _AlliedClans'

~~◄:●:►SanToS◄:●:►~~ · 04/20/2013, 00:16

Quote:

Originally Posted by CuteSpear

if you want to delete all characters from Database use it in SRO_VT_SHARD
truncate table _OpenMarket
print 'Cleaned _OpenMarket'
truncate table _CharSkill
print 'Cleaned _CharSkill'
truncate table _CharSkillMastery
print 'Cleaned _CharSkillMastery'
truncate table _GuildMember
print 'Cleaned _GuildMember'
truncate table _BlockedWhisperers
print 'Cleaned _BlockedWhisperers'
truncate table _Inventory
print 'Cleaned _Inventory'
truncate table _InventoryForAvatar
print 'Cleaned _InventoryForAvatar'
truncate table _InventoryForLinkedStorage
print 'Cleaned _InventoryForLinkedStorage'
truncate table _TrainingCampMember
print 'Cleaned _TrainingCampMember'
truncate table _TrainingCampSubMentorHonorPoint
print 'Cleaned _TrainingCampSubMentorHonorPoint'
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL
print 'Cleaned _TrainingCampHonorRank'
truncate table _TrainingCampBuffStatus
print 'Cleaned _TrainingCampBuffStatus'
delete from _TrainingCamp
print 'Cleaned _TrainingCamp'
truncate table _StaticAvatar
print 'Cleaned _StaticAvatar'
truncate table _User
print 'Cleaned _User'
truncate table _Friend
print 'Cleaned _Friend'
truncate table _Memo
print 'Cleaned _Memo'
truncate table _TimedJob
print 'Cleaned _TimedJob'
truncate table _CharTrijobSafeTrade
print 'Cleaned _CharTrijobSafeTrade'
delete from _CharTrijob
print 'Cleaned _CharTrijob'
truncate table _InvCOS
print 'Cleaned _InvCOS'
delete from _CharCOS where ID > 0
print 'Cleaned _CharCOS'
delete from _Char where charid > 0
print 'Cleaned _Char'
truncate table _Chest
print 'Cleaned _Chest'
truncate table _ChestInfo
print 'Cleaned _ChestInfo'
truncate table _ItemPool
print 'Cleaned _ItemPool'
delete from _Items where ID64 > 0
print 'Cleaned _Items'
delete from _AccountJID
print 'Cleaned _AccountJID'
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
print 'Cleaned _AlliedClans'
truncate table _GuildWar
print 'Cleaned _GuildWar'
truncate table _CharNameList
print 'Cleaned _CharNameList'
truncate table _CharQuest
print 'Cleaned _CharQuest'
truncate table _ClientConfig
print 'Cleaned _ClientConfig'
truncate table _DeletedChar
print 'Cleaned _DeletedChar'
truncate table _SiegeFortressStoneState
print 'Cleaned _SiegeFortressStoneState'
truncate table _SiegeFortressRequest
print 'Cleaned _SiegeFortressRequest'
truncate table _SiegeFortressObject
print 'Cleaned _SiegeFortressObject'
truncate table _SiegeFortressItemForge
print 'Cleaned _SiegeFortressItemForge'
truncate table _SiegeFortressBattleRecord
print 'Cleaned _SiegeFortressBattleRecord'
update _SiegeFortressStruct SET OwnerGuildID = '0'
print 'Cleaned _SiegeFortressStruct'
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
print 'Cleaned _SiegeFortress'
truncate table _CharNickNameList
print 'Cleaned _CharNickNameList'
truncate table _GPHistory
print 'Cleaned _GPHistory'
truncate table _GuildChest
print 'Cleaned _GuildChest'
delete from _Guild where ID > 0
print 'Cleaned _Guild'
delete from _AlliedClans where ID > 0
print 'Cleaned _AlliedClans'

He Only want to delete 1 character

aw_elkady · 11/15/2013, 00:15

Quote:

Originally Posted by ◄:●:►SanToS◄:●:►

He Only want to delete 1 character

i think this good query by me .

PHP Code:


			
USE SRO_VT_SHARD_NEW--Or your DB name.

--=============================================

-- by Mr.Abd eljwad elKady

-- ctpsro online

-- join us http://ctpsro.tk/

--=============================================

UPDATE _CHAR

SET DELETED='1'

WHERE CurLevel = 1 ---> No Lvel u wont to delete

--=============================================

-- by Mr.Abd eljwad elKady

-- ctpsro online

-- join us http://ctpsro.tk/

--=============================================

InPanic~Honey · 11/16/2013, 22:26

aw_elkady thats the biggest **** Query ever

if u wanna delete 1 Char use this :

Code:

USE [SRO_VT_SHARD]
-- Query by InPanic-Kev
declare @CharID int , @CharName varchar(16)

set @CharName = 'CharName'
set @CharID = ( select CharID from _Char where CharName16 = @CharName )

exec [_DeleteCharPermanently] @CharID

CastieI · 11/17/2013, 20:24

Quote:

Originally Posted by JamalXd

hi guys. my db have char delete bug.7500 account waiting delete.

this codes only 1x account deleted. i dont want 7500 account manuel delete.Anyone help me query code?.

DELETE FROM _InventoryForAvatar WHERE charid = '81935'
DELETE FROM _Inventory WHERE charid = '81935'
DELETE FROM _CharSkillMastery WHERE charid = '81935'
DELETE FROM _CharSkill WHERE charid = '81935'
DELETE FROM _CharTrijob WHERE charid = '81935'
DELETE FROM _User WHERE charid = '81935'
DELETE FROM _StaticAvatar WHERE charid = '81935'
DELETE FROM _TimedJob WHERE charid = '81935'
DELETE FROM _char WHERE charid = '81935'

I think you want to delete all chars, if that is right simply remove the where clause in your query;

DELETE FROM _InventoryForAvatar
DELETE FROM _Inventory
DELETE FROM _CharSkillMastery
DELETE FROM _CharSkill
DELETE FROM _CharTrijob
DELETE FROM _User
DELETE FROM _StaticAvatar
DELETE FROM _TimedJob
DELETE FROM _char

That's already enough.