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.
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
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.
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.
Code:
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
Code:
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.
Code:
SELECT * FROM `player_skills` WHERE `player_id` = (SELECT `id` FROM `players` WHERE `name` = "Player Name")
Last edited: