[DiscordArchive] Hello, I'm trying to do some shenanigans directly manipulating the database - adding recipes for a p
[DiscordArchive] Hello, I'm trying to do some shenanigans directly manipulating the database - adding recipes for a p
Original source
Hello, I'm trying to do some shenanigans directly manipulating the database - adding recipes for a profession to a character.
It's a growing shell script to keep certain aspects in sync account wide - like flight masters, skill points, reputation... And those parts work. Now I also want to add recipes for professions.
But I haven't figured it out properly yet. It appears that a lot of info is in skilllineability_dbc (once extracted from the DBC).
Example:
```
+------+-----------+-------+-------------------+-------------------+
| ID | SkillLine | Spell | CharacterPoints_1 | CharacterPoints_2 |
+------+-----------+-------+-------------------+-------------------+
| 2371 | 197 | 2402 | 135 | 100 |
+------+-----------+-------+-------------------+-------------------+
```
This is for "Woolen Cape", a tailor (SkillLine 197) recipe. My initial thought was then that CharacterPoints_{1,2} where the required skill to learn and when it would stop giving skill points. But the game client says the recipe requires skill 75 (and not 100). So I have no idea how to see what is the requirement, beside the profession.
I basically want to look at all profession recipes for 1 character - found in `character_spell` - and then lookup which of those are for a tailor, then add them to another character. I can add a recipe, the Woolen Cape as this example, with a simple `INSERT IGNORE INTO character_spell (guid, spell) VALUES (<GUID>, 2402);` But I need a way to see the required skill for the spell, to not insert something requiring a higher skill than the character has.
Does that make sense? And does anyone know where the required skill info is hiding?
rektbyfaith
10-25-2025, 06:55 PM #1Archived author: Zoidwaffle • Posted: 2025-10-25T18:55:57.656000+00:00
Original source
Hello, I'm trying to do some shenanigans directly manipulating the database - adding recipes for a profession to a character.
It's a growing shell script to keep certain aspects in sync account wide - like flight masters, skill points, reputation... And those parts work. Now I also want to add recipes for professions.
But I haven't figured it out properly yet. It appears that a lot of info is in skilllineability_dbc (once extracted from the DBC).
Example:
```
+------+-----------+-------+-------------------+-------------------+
| ID | SkillLine | Spell | CharacterPoints_1 | CharacterPoints_2 |
+------+-----------+-------+-------------------+-------------------+
| 2371 | 197 | 2402 | 135 | 100 |
+------+-----------+-------+-------------------+-------------------+
```
This is for "Woolen Cape", a tailor (SkillLine 197) recipe. My initial thought was then that CharacterPoints_{1,2} where the required skill to learn and when it would stop giving skill points. But the game client says the recipe requires skill 75 (and not 100). So I have no idea how to see what is the requirement, beside the profession.
I basically want to look at all profession recipes for 1 character - found in `character_spell` - and then lookup which of those are for a tailor, then add them to another character. I can add a recipe, the Woolen Cape as this example, with a simple `INSERT IGNORE INTO character_spell (guid, spell) VALUES (<GUID>, 2402);` But I need a way to see the required skill for the spell, to not insert something requiring a higher skill than the character has.
Does that make sense? And does anyone know where the required skill info is hiding?
1 Guest(s)
1 Guest(s)