How do I make a GM account?

[tzu-theory]

Title says it all. I am brand new and just got my server up and running.

[tzu-theory]

I have edited the account access to 255 but I am still getting the "Your Access Level is not high enough...." etc...

[joligario]

How did you edit the account access? And what are you typing to get the message about not being high enough?

[csb4623]

In your accounts table there is a status column that can be 1 to 255. I think it defaults 20.

run UPDATE account SET status = 255 where id = x;

change x to your account id

that will make you the highest level gm. You can also go into the commands table and change the min value of the specific commands.

[waeweas]

Originally Posted by csb4623

In your accounts table there is a status column that can be 1 to 255. I think it defaults 20.

run UPDATE account SET status = 255 where id = x;

change x to your account id

that will make you the highest level gm. You can also go into the commands table and change the min value of the specific commands.

Where do you find the accounts table so that I can edit the status column? I just don't know where to access the access level to change my account :/

Can anyone please help?

[waeweas]

This is what I am seeing, where do I go from here?

[joligario]

You are looking at the structure. You need to be looking at the data.

[waeweas]

Originally Posted by joligario

You are looking at the structure. You need to be looking at the data.

Sorry, incredibly new to this, where do I go to look at the data?

[Uleat]

The tab that your on says: "Table: account"

You want the tab to the right of it that says: "Data"

[waeweas]

Data was completely blank. Thank you for the quick replies! MUCH appreciated!

[waeweas]

Also, im taking a look at my tables, isn't there supposed to be one that says Logon?

[Maze_EQ]

UPDATE account SET status = 255 where id = 1;

Seeing you'd be the first account made.

Before trying to run something as simple as EQEMU you may want to learn basic SQL.

It can be a daunting task.

Also go ask Captain Sparrow for NaviCAT, makes things much easier for beginners.

P.S. l2sql noob. (had to be an ass)

[waeweas]

I used MariaDB and it said when I used command UPDATE account SET status = 255 where id = 1;



Thing is, my account isnt being stored in the database when I log in. I have a blank account data page



How can I solve this

[waeweas]

I FIGURED IT OUT!! I did not configure the mariaDB right.

[demonstar55]

I usually do ./world flag username 255