Solved Creating a GM? (SQL)

[Xionic]

Alright, so I got a new issue, lol. Ive been trying different things and just can figure it out, ive tried all the tuts in the tutorial section and its not workin... so not really sure what to do my server is SQL TFS v 0.3.2 (Crying Damson)

 

[Pitufo™]

Well in your database go to your table "players" and go to edit mode of any player...

Now in column "group_id" set the position of the player.

To see which position is for each number go to table "groups"

 

[Guitar Freak]

Alright, so I got a new issue, lol. Ive been trying different things and just can figure it out, ive tried all the tuts in the tutorial section and its not workin... so not really sure what to do my server is SQL TFS v 0.3.2 (Crying Damson)

First of all make a character in-game using the account manager, a normal character.

Now, are you using MySQL or SQLite?

If you're using SQLite, you need to open your database (usually called schema.sqlite) using any "SQLite program" and find the table accounts and the table players.

If you're using MySQL, enter your localhost (http://127.0.0.1/phpmyadmin/) and import your database, etc. Then again, enter your database and find the tables accounts and players.

Then pick the player's account you created and in the accounts table change the group_id to 3, and in the players table change the group_id to 6.

This is for a GOD char. If you want a GM, go to the groups table and find the id of GMs there cause I dont remember it And then change the group_id in the players table.

Cheers~

 

[Xionic]

Both replies solved my question, i greatly appreiciate all the help though!!! ++rep