[SOLVED] Where/How can I edit skills of players?

[dizoxur]

I'm just wondering, where can I edit them? Will give rep!

 

[menfes]

Do you have sqlite or mysql = phpMyadmin?

 

[Cazar]

Just click in your Database on the table 'players'

then click at the top on SQL and execute this.

SELECT * FROM `players` WHERE NAME = "CHARACTERNAME"

example Paladin Sample.

Then you will get this

Just remember his 'id'

and click table 'player_skills'

click on the top again SQL and execute this

SELECT * FROM `player_skills` WHERE PLAYER_ID = "YOURPLAYERID"

Then you should get this

just edit them then

1. Fist
2. Club
3. Sword
4. Axe
5. Shielding
6. Distance
7. Fishing


Rep++ if i helped you

//Cazar

 

[menfes]

@up
That's for mysql
If you use it, then Cazars post is pretty helpful.

 

[Cazar]

@up
That's for mysql
If you use it, then Cazars post is pretty helpful.

i think he use mysql
cuz on sqlite is it much easier

//Cazar

 

[dizoxur]

Thanks alot, added rep! yup, mysql!

 

[Cykotitan]

all in 1 query:

SELECT * FROM `player_skills` WHERE `player_id` = (SELECT `id` FROM `players` WHERE `name` = "Player Name")

 

[menfes]

Cykotian pro mazzter?? GZ!!