Deleting Skills

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.

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.

:wink:

Quote:

---

Originally Posted by 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.

---

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

Quote:

---

Originally Posted by S37uP!Update

:wink:

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:

Code:

---

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.

Ok i got this code :

0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150

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

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

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!

Quote:

---

Originally Posted by 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!

---

There you go:

Code:

---

exec gamedb.dbo.cabal_tool_SetSkill 64, 0x020001004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150

---

At 64 put ur char IDX.

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!

Quote:

---

Originally Posted by 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!

---

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

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:

Code:

---

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.

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.

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.

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.

Quote:

---

Originally Posted by 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.

---

Ok,now really...your answer don't have a sense...seriously...i was not angry :blink: 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!