Changing Skills

[Xoin]

I Tried everything but i couldn't find it, where am i supposed to change the skills of the characters on a sql serv(tfs for 8.21), also i would like to know where i put to every one learn spells without having to buy them ?

 

[EvulMastah]

-,-

table player_skills
data/spells/spells.xml -> needlearn="0"

 

[Xoin]

i could fix the spells, but i didn't find the name of the character on the player skills

 

[EvulMastah]

There is player_id

run this in the SQL part:

SELECT name, id FROM players;

There will come the table which will look something like this:
Player1 | 1
Player2 | 2

 

[Jonern]

If you want to find a players skills easily with one query, run this:

SELECT * FROM player_skills WHERE player_id = (SELECT id FROM players WHERE name = 'Xoin');

Change the name (here I used Xoin) to what ever you like.