Deleting Skills

[S37uP!Update]

Hello,can you please tell me how can i delete all skills (SWORD SKILLS,MAGIC SKILL)From all characters?
I have 15000+ characters to delete the skills,because i got a little bug,and only in this way i can solve it,i know how to add sword points and magic points for characters with transcender rank because if delete the skill they are not able anymore to earn skill points if they have transcender rank,but i don't know how can i delete the SWORD SKILLS and MAGIC SKILLS only from all characters,is there a querry?Or something like that?I really need it.

Happy Holidays.

[MentaL]

[cypher]

Simple. Create a new character for each class and save the skill blob data. After that just create a query for each class to update the it's skill blob data. You can do this using JOIN.

[S37uP!Update]

Simple. Create a new character for each class and save the skill blob data. After that just create a query for each class to update the it's skill blob data. You can do this using JOIN.

That's preety easy,but please tell me in what table and what colum i must look?

[Acnathon]

That's preety easy,but please tell me in what table and what colum i must look?

You can get skill data with the following:
1. Create new char
2. Note the new Char IDX
3. Run this query:

exec gamedb.dbo.cabal_tool_GetSkill 64

But instead of 64 put the new Char IDX.
This will return the skill data of the char.

[S37uP!Update]

Ok i got this code :

0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150

Where to i have to add that if i want to change the skills on one character?

[cypher]

There is a table with character_skill something like that. It should have the blob data and the char idx as columns.

[S37uP!Update]

On GameDB database to tables i have one table called cabal_skilllist_table with 2 rows,CharacterIdx here are apear the IDX of character and one more called Data but here apear <Binary> on all characters not a code like the one received it from the Querry!

[Acnathon]

On GameDB database to tables i have one table called cabal_skilllist_table with 2 rows,CharacterIdx here are apear the IDX of character and one more called Data but here apear <Binary> on all characters not a code like the one received it from the Querry!

There you go:

exec gamedb.dbo.cabal_tool_SetSkill 64, 0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150

At 64 put ur char IDX.

[S37uP!Update]

There's a little problem i guess,i didn't test it,i just want to be sure first!
Different classes have different Code!
How do i know where the code goes to right class to prevent the skills like BM,Astral Weapons,etc.
Because if i add this code from FS for example to a FA or whatever class,there will be changes in other skills like BM,Astral Weapons,etc.
And i don't want to to that only for one char,i already specified that in first topic,i have 15000+ characters!

[Yamachi]

There's a little problem i guess,i didn't test it,i just want to be sure first!
Different classes have different Code!
How do i know where the code goes to right class to prevent the skills like BM,Astral Weapons,etc.
Because if i add this code from FS for example to a FA or whatever class,there will be changes in other skills like BM,Astral Weapons,etc.
And i don't want to to that only for one char,i already specified that in first topic,i have 15000+ characters!

Please go google how to construct SQL queries...
Posted via Mobile Device

[S37uP!Update]

Pfff,Any other answers?I've talked about cabal here,not only for SQL,and i already write,from where do i know what are the WA codes with skills,BL codes with skills,etc...???!!!
Edit:

Warrior No Skills - 0x020001004D01014654010148550101499001014B7C01014E7D01014F7E0101507F010151
Blader No Skills - 0x020001004D01014656010148570101499201014B8001014E8101014F8201015083010151
Force Shielder No Skills - 0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150
Wizard No Skills - 0x640001204D01014658010148590101499401014B
Force Archer No Skills - 0xA80101204B0101434D0101465A0101485B0101499601014B8701014E8801014F890101508A010151
Force Blader No Skills - 0x02000100640001204D0101465E0101485F0101499A01014B

1 St Wizard With Some Skills - 0xA3010147C4010145A4010144FFFF01434D01014658010148590101499401014BCC010100CD010101CE010102D00009038D0014208B0014218C0014228A001423E9001424EA000925A7001426A5010166A6010167
2 Nd Wizard With Some Other Skills - 0x640001204D01014658010148590101499401014B6C00012181000122800001237A0009247F0009257D0009268B00092734010152A5010166A6010167

And other Wizard characters if they have other skills,the code are different.
How do i know what is the class wizard?If they always have other code?
And how do i run the querry for all classes to have no skills because if i'll try to delete the <Binary> from 'Data' row the character is bugged,they will not have class skills,like BM,Astral Weapon activation,and all else.

[cypher]

The next time you ask a question, ask it properly. When you ask a question that seems generic, you will be told to find your information somewhere else. Also, don't "pff" at a moderator when he tells you not to ask generic SQL questions here.

[S37uP!Update]

Ok,ok...i got it...can you help with my problem?And idk what's wrong with "Pfff" it's only a mode to refer to a something...i didn't write that for offense or something else!
And sorry Yamachi if maked you sad or angry,i didn't want that :) i just typed "Pfff" because i need some info's about the cabal codes what i typed above.

[emi]

First, chill it out, you are too nervous. This is easy.
All you have to do is to 'update' each class with no skills. Now google around for the SQL keyword hinted above.

[S37uP!Update]

First, chill it out, you are too nervous. This is easy.
All you have to do is to 'update' each class with no skills. Now google around for the SQL keyword hinted above.

Ok,now really...your answer don't have a sense...seriously...i was not angry but your reply is without sense...really...i already got that from Yamachi,and i still need a answer (HOW DO I KNOW WHAT ARE THE WA CLASS,BI CLASS,WI CLASS,ETC...IF THEY ALWAYS HAVE DIFFERENTE CODE BECAUSE OF DIFFERENT SKILLS).
Read the reply's above!

[emi]

Because you are looking in the wrong direction.
NO ONE is going to help you with that attitude.

[S37uP!Update]

When i ask for help,any one posted reply without sense , only chumpy and Acnathon gaved some informations,but not enough...now i hope i can get a proper answer even if you think my atitude is wrong,that's your opinion,i asked for help really nice...but you guys think my atitude is wrong,anyway sorry to all,hope to get a good answer so i can solve that faster as i can,now emi if you know how can i solve that maybe you can help me,because from chumpy and/or Yamachi i got answers really slowly...

[emi]

All you have to do is to replace for each class with the proper code.
To do so you have to use a querry that updates that data but you have to do for each class.
You should you use 'where' clause in the querry.

HINT:there are lots of ways to find out the class of chars.
You have your answers, now build the querry. Google can really help you.

[S37uP!Update]

And can you tell me one way how can i find ?

[S37uP!Update]

Hello,i got this script from release section and i edited:

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE cabal_sp_DelAccount
@UserNum int	
	
AS
BEGIN

IF NOT EXISTS (SELECT [UserNum] FROM [account].[dbo].[cabal_auth_table] WHERE [UserNum] = @UserNum)
RETURN -1
	
DECLARE @i int, @max int, @del int, @rowcount int, @gl bit;
	               
SET @i  = @UserNum * 8;
SET @max = @i + 5
SET @gl = 0;
	 
BEGIN TRAN
WHILE @i < @max
BEGIN
IF EXISTS (SELECT [CharacterIdx] FROM [gamedb].[dbo].[cabal_character_table] WHERE [CharacterIdx] = @i)
BEGIN
DELETE FROM [gamedb].[dbo].[cabal_skilllist_table] WHERE [CharacterIdx] = @i
END
END
 
SET @i = @i + 1
END

ELSE
BEGIN

COMMIT TRAN
RETURN -2
END
COMMIT TRAN

RETURN @del
END
GO

Please tell me if is alright this querry to delete the skills from all characters,and if is ok please tell me how can i exclude some skills to don't be deleted?
Skills like:BM,BM2,Astral bike,Astral board,Astral weapons,etc.

[SpeedDevil]

I think the easiest way would be to create 6 new characters and give them the skills you want them to keep. You can then copy the Binary Data from those characters over to all the other characters which have the same class.

There is one thing I'm not sure about, some of the skills you mentioned that you want to keep are leveled by the characters Class Rank so you'd have to check if that copy method works on characters with a different Class Rank, giving them the correct leveled skill.

Make some backups and start testing is what I'd say, queries for that described above shouldn't be too difficult.

[S37uP!Update]

Thanks for the answer speeddevil,but how to i know what are the classes with skills?Because the binary code are different,if there are different skills,doesn't matter if there's same class,if the skills are different,the binary are total different,nothing same!

[Acnathon]

Thanks for the answer speeddevil,but how to i know what are the classes with skills?Because the binary code are different,if there are different skills,doesn't matter if there's same class,if the skills are different,the binary are total different,nothing same!

You could try the following:

1. Create 1 new character from each class and add the skills you want to keep for them.
2. Note down their skills binary (also their class).
3. Create a query that selects character ids by their class (example: select all characteridxs where the class is WA).
4. Update the selected ids (selected by the characters class) with the new binarys from step 2.

Also note this:

There is one thing I'm not sure about, some of the skills you mentioned that you want to keep are leveled by the characters Class Rank so you'd have to check if that copy method works on characters with a different Class Rank, giving them the correct leveled skill.

& this:
Its just a theory... i never tried this but i hope it helps/works.

[S37uP!Update]

Hmmm,i will try that,i will come with a post if that's working and i will make a guide for that becuase maybe there's some one else who need that.

[alissonpierre]

I believe that this solves their many questions ....
and help many others who may be needing it.

DECLARE
	@CH_STYLE int,
	@NAME varchar(200),
	@CHARACTERIDX int,
	@Class_ int,
	@N_CHAR_MAX int

SET @N_ACCOUNT_MAX = 34000
	
SET @CHARACTERIDX = 8

WHILE (@CHARACTERIDX <= @N_CHAR_MAX)
BEGIN

	IF EXISTS (SELECT * FROM GAMEDB.DBO.CABAL_CHARACTER_TABLE WHERE CHARACTERIDX=@CHARACTERIDX)
	BEGIN

		SET @NAME = (SELECT NAME FROM GAMEDB.DBO.CABAL_CHARACTER_TABLE WHERE CHARACTERIDX=@CHARACTERIDX)
		SET @CH_STYLE = (SELECT STYLE FROM GAMEDB.DBO.CABAL_CHARACTER_TABLE WHERE CHARACTERIDX=@CHARACTERIDX)

		SET @Class_ = (select ((((@CH_STYLE % 67108864) % 131072) % 8192) % 256) - (( convert(int, round(convert(float, ((((@CH_STYLE % 67108864) % 131072) % 8192) % 256)) / convert(float, 8), 0)) - 1) * 8))

		--Warrior
		IF(@Class_=9)
		BEGIN

			PRINT N'IDX GU = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR GU = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)

			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0x020001004D01014654010148550101499001014B7C01014E7D01014F7E0101507F010151
			WHERE CharacterIdx = @CHARACTERIDX

		END


		--Wizard
		IF(@Class_=11)
		BEGIN
			PRINT N'IDX MA = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR MA = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)

			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0x640001204D01014658010148590101499401014B
			WHERE CharacterIdx = @CHARACTERIDX
			
		END


		--Blader
		IF(@Class_=10)
		BEGIN
			PRINT N'IDX DU = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR DU = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)

			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0x020001004D01014656010148570101499201014B8001014E8101014F8201015083010151
			WHERE CharacterIdx = @CHARACTERIDX
			
		END


		--Force Archer
		IF(@Class_=4 OR @Class_=12)
		BEGIN
			PRINT N'IDX AA = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR AA = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)

			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0xA80101204B0101434D0101465A0101485B0101499601014B8701014E8801014F890101508A010151
			WHERE CharacterIdx = @CHARACTERIDX
			
		END


		--Force Shielder
		IF(@Class_=5 OR @Class_=13)
		BEGIN
			PRINT N'IDX GA = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR GA = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)
			
			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150
			WHERE CharacterIdx = @CHARACTERIDX
			
		END


		-- Force Blader
		IF(@Class_=6 OR @Class_=14)
		BEGIN
			PRINT N'IDX EA = ' + STR(@CHARACTERIDX)
			PRINT N'CHAR EA = ' + @NAME
			PRINT N'Style = ' + STR(@CH_STYLE)

			UPDATE GAMEDB.DBO.cabal_skilllist_table
			SET Data = 0x02000100640001204D0101465E0101485F0101499A01014B
			WHERE CharacterIdx = @CHARACTERIDX
			
		END

	END
	
	SET @CHARACTERIDX = @CHARACTERIDX + 1
	
END

Example:
SET @N_CHAR_MAX = 34000
@N_CHAR_MAX = maximum number of characters (characteridx) you have in your database.

SET @CHARACTERIDX = 8
@CHARACTERIDX = first characteridx that will be searched in the database and that will set the new Data Skill for later, be enhanced and redo the whole process again.

I hope that helps.