How to delete char in SQL ?

Hi, i want to delete char in sql. My database is rly big and i want to delete char FOREVER. Is it possible ?

Yes,it's possible.
Here you go Regards

What a retarded,he is asking to clean his database from characters..Not delete the character from the account.

Anyway,you can use this query (deletes all characters/items/Guilds etc stored in the shard database).

You may pick whatever you need to be deleted and execute it.

Credits to kelly2009 @RZ

No i want to 1 char delete forever in sql.

Quote:

Originally Posted by magicanoo What a retarded,he is asking to clean his database from characters..Not delete the character from the account. Anyway,you can use this query (deletes all characters/items/Guilds etc stored in the shard database). You may pick whatever you need to be deleted and execute it. PHP Code:     USE [SRO_VT_SHARD]     GO     TRUNCATE TABLE [dbo].[_Chest]     TRUNCATE TABLE [dbo].[_ChestInfo]     TRUNCATE TABLE [dbo].[_User]     TRUNCATE TABLE [dbo].[_OpenMarket]     DELETE FROM [dbo].[_AccountJID]      TRUNCATE TABLE [dbo].[_GuildWar]     TRUNCATE TABLE [dbo].[_GuildMember]     TRUNCATE TABLE [dbo].[_GuildChest]     TRUNCATE TABLE [dbo].[_SiegeFortressStruct]     TRUNCATE TABLE [dbo].[_SiegeFortressObject]     TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]     DELETE FROM [dbo].[_SiegeFortress]     INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)     INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)     INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)     UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'     DELETE FROM [dbo].[_Guild] WHERE ID > 0     DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0     TRUNCATE TABLE [dbo].[_InventoryForAvatar]     TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]     TRUNCATE TABLE [dbo].[_BlockedWhisperers]     TRUNCATE TABLE [dbo].[_TrainingCampMember]     TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]     DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0     TRUNCATE TABLE [dbo].[_TimedJob]     TRUNCATE TABLE [dbo].[_StaticAvatar]     TRUNCATE TABLE [dbo].[_Inventory]     TRUNCATE TABLE [dbo].[_Memo]     TRUNCATE TABLE [dbo].[_FleaMarketNetwork]     TRUNCATE TABLE [dbo].[_Friend]     TRUNCATE TABLE [dbo].[_CharSkillMastery]     TRUNCATE TABLE [dbo].[_CharSkill]     TRUNCATE TABLE [dbo].[_InvCOS]     DELETE FROM [dbo].[_CharCOS] WHERE ID > 0     DELETE FROM [dbo].[_Char] WHERE CharID > 0     TRUNCATE TABLE [dbo].[_CharCollectionBook]     TRUNCATE TABLE [dbo].[_CharInstanceWorldData]     TRUNCATE TABLE [dbo].[_CharNameList]     TRUNCATE TABLE [dbo].[_CharNickNameList]     TRUNCATE TABLE [dbo].[_CharQuest]     TRUNCATE TABLE [dbo].[_ClientConfig]     TRUNCATE TABLE [dbo].[_DeletedChar]     TRUNCATE TABLE [dbo].[_GPHistory]     TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]     TRUNCATE TABLE [dbo].[_ItemPool]     DELETE FROM [dbo].[_Items] WHERE ID64 > 0     TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]     TRUNCATE TABLE [dbo].[_TimedJobForPet]     TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]     TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)     INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)     EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]     DELETE FROM [dbo].[_TrainingCamp]     TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]     TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]     TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]  Credits to kelly2009 @RZ

What happens if we execute all of the code above ?

WOW.............really are allot of useless people on here giving out answers without reading the questions....lol he don't want to clean his database or wipe it out he just wants to maintain it there is 2 ways you can do this hadescik you can pic and choose what chars to delete 1 at a time using the first script or use the 2nd one to go by last login date and get rid of chars not being played in awhile BUT it will give you a few errors which is ok just write down the chars that show errors and then run the first script with their names and you will be good to go .

script #1

Quote:

USE [SRO_VT_SHARD] go declare @CharID int , @CharName varchar(16) --coded by Mountain_Man33 set @CharName = 'CharName' 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

script #2

Quote:

SELECT al.CharID, uwc.UserJID FROM SRO_VT_SHARD.dbo._User uwc LEFT JOIN SRO_VT_SHARD.dbo._Char al ON uwc.CharID = al.CharID WHERE LastLogout < '2014-07-22 23:59:59' AND Deleted=0 AND CurLevel <141 --coded by Mountain_Man33 UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [Deleted] = 1 WHERE LastLogout < '2014-07-22 23:59:59' AND Deleted=0 AND CurLevel <141

you can change the time you want to set for last logout then once your done reboot the server and it will delete all the chars selected .
good luck and let me know if you need help with it .

in tb user

_Char
in SRO_VT_SHARD

Sorry have to bump. Why do I get "Failed to connect to server (C10)" when I set "Deleted" to "1" in _Char Table when I try to login?

Quote:

Originally Posted by Zodiao Yes,it's possible. Here you go PHP Code: USE SRO_VT_SHARD--Or your DB name. UPDATE _CHAR SET DELETED='1' WHERE CHARNAME16 like '%CHARNAMEHERE%'  Regards

Denger C10 Error