Ravauvial
Member
Ok read all the tutors about SQL, and still have a problem.
to begin I started with Mystic sqlite database [forgottenserver.s3db] renamed it to [roxor.s3db].
Useing [sqliteadmin] I open it. all is good so far.
I notice in groups I have 3 types:
1 - player, 2 - a gamemaster, 3 - a god.
I want to add some and change to 6 types:
1 - Player, 2 - Tutor, 3 - Senior Tutor, 4 - Gamemaster, 5 - Community Manager, 6 - God
So I retype all the info in rename and change what I want
id - name - flags - access - maxdepotitems - maxviplist -
1 - Player - 0 - 0 - 0 - 0 -
2 - Tutor - 0 - 1 - 2000 - 100 -
3 - Senior Tutor - 0 - 2 - 4000 - 200 -
4 - Gamemaster - 0 - 3 - 6000 - 300 -
5 - Community Manager - 0 - 4 - 8000 - 400 -
6 - God - 0 - 5 - 10000 - 500 -
Ok all good right.
I create a player named Gamemaster and one called God I change the group_ID to 4 for Gamemaster and 6 for God
All good It saves.
Now I logon and type /commands look at the bottom and it says Access = 1 on both accounts.
Gamemaster should say 4 and God should say 6. am I doing somthing wrong?
to begin I started with Mystic sqlite database [forgottenserver.s3db] renamed it to [roxor.s3db].
Useing [sqliteadmin] I open it. all is good so far.
I notice in groups I have 3 types:
1 - player, 2 - a gamemaster, 3 - a god.
I want to add some and change to 6 types:
1 - Player, 2 - Tutor, 3 - Senior Tutor, 4 - Gamemaster, 5 - Community Manager, 6 - God
So I retype all the info in rename and change what I want
id - name - flags - access - maxdepotitems - maxviplist -
1 - Player - 0 - 0 - 0 - 0 -
2 - Tutor - 0 - 1 - 2000 - 100 -
3 - Senior Tutor - 0 - 2 - 4000 - 200 -
4 - Gamemaster - 0 - 3 - 6000 - 300 -
5 - Community Manager - 0 - 4 - 8000 - 400 -
6 - God - 0 - 5 - 10000 - 500 -
Ok all good right.
I create a player named Gamemaster and one called God I change the group_ID to 4 for Gamemaster and 6 for God
All good It saves.
Now I logon and type /commands look at the bottom and it says Access = 1 on both accounts.
Gamemaster should say 4 and God should say 6. am I doing somthing wrong?