MySQL How to edit the Player Skills in your Database

[Cazar]

Hey there,
this is my first Tutorial here on OTLand :thumbup:

Just leave a comment if i forgot sumthing or if it was helpful
Let's begin!


1.
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'

2.

Now click on the table 'player_skills'

click on the top again on SQL and execute this

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

Then you should get this

Now you can edit them simply by clicking on

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

That was it
Your done


i wouldnt mind, by giving me a reputation

//Cazar

edit:

Or do it with this command.
quick and simply.

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

​

 

[Xonorc]

You are very roxx++
Thanks i find this
ILY <3