Problem with admin level

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
Your SQL is working fine. Your workbench is not fully compatible.
Try to remove it and reinstall:
Code:
sudo apt-get install mysql-workbench
It that refresh doesn't work try to add your value manually in your mysql-mariadb.

mysql>
Code:
use swgemu;
select * from accounts;
update accounts set admin_level='15' where username='Your_account_name';
 
Last edited:

kalkosh

New Member
Joined
Aug 26, 2018
Messages
18
Oh nice thank you i try that when i come back of jobs in 5 hours.

Modders and community swg always top thank thank thank
 

kalkosh

New Member
Joined
Aug 26, 2018
Messages
18
Im so sorry but the first try dont match

https://imageshack.com/i/pn3MNr8Zj

And for the second try. I have not the quality for execute this command. I cant find my sql mariadb i find just mysql workbench.

Im a very noob with this software.

I need to learn my sql and oracle machine... lool this task is hard level for me dont speak corectly english dont have the qwerty keyboard....
 

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
Im so sorry but the first try dont match
I said you to remove and reinstall.


And for the second try. I have not the quality for execute this command. I cant find my sql mariadb i find just mysql workbench.
Open a terminal:
su
password: 123456 or 12345678.

You're a superuser now.


Code:
mysql -u root -p
show databases;
use swgemu;
select * from accounts;
update accounts set admin_level='15' where username='Your_account_name';
flush privileges;
 
Last edited:

kalkosh

New Member
Joined
Aug 26, 2018
Messages
18
Thx for all of you times passed for me.

In first time this week due to jobs i was very busy and i have not tested all solution.

2nd after tested all, my servor is verry buged i choice to erase all and reinstal a fresh instalation.

I come back to you if needed after. Thx bro ans sys maybe^^
 

Downstown

New Member
Joined
Aug 27, 2019
Messages
8
I'm having the same issue. I tried the manual way since I keep getting an error trying to run mysql workbench (operating system not compatible)

I type:
update accounts set admin_level='15' where username='Your_account_name';

and replace 'Your_account_name' with my two created toons...example:

update accounts set admin_level='15' where username='Lukewarm_skywater';

.......or.......

update accounts set admin_level='15' where username='Jinx';

This comes up.....

MariaDB [swgemu]> update accounts set admin_level='15' where username='Lukewarm Skywater';
Query OK, 0 rows affected (0.010 sec)
Rows matched: 0 Changed: 0 Warnings: 0

and nothing changes. Any ideas?

I'm using the new Mod The Galaxy setup guide with Linux Mint 20.1
 
Last edited:

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
That command changes the 'admin_level' column value to '15' from your 'accounts' table in a specific 'username', not your characters info. So try to put your account instead of your toon names.

By the other hand, if you want to add Ghost Mode in a toon, you'll need to make it into the game using /setgodmode. But you need another admin toon to do that.
 
Last edited:

Downstown

New Member
Joined
Aug 27, 2019
Messages
8
Thank you for the information. I see that my admin level is now '15' but none of the admin commands work. i.e. /setspeed 10; /invul etc.
 

Aeryna

Moderator
Staff member
Moderator
Joined
Oct 10, 2017
Messages
359
Unzip this file into your main folder and replace the user.cfg.
Maybe your client is not activated to be administrator.
 

Attachments

Downstown

New Member
Joined
Aug 27, 2019
Messages
8
Unzip this file into your main folder and replace the user.cfg.
Maybe your client is not activated to be administrator.
Sorry for not replying earlier. I was on vacation and just noticed this. I’m pretty sure I had that in my user.confg. I think the problem may have been my fault. I’ve been trying to find a way to get Mustafar and Kashyyyk working with mobs, buildings, instances, loot, etc. and tried adding some files from Sunrunner II, only because some of the folks here at Mod the Galaxy contributed to them, and I guess my attempts to get them working keep failing.

Thank you for your tips and advice with questions I’ve had over time.
 
Top Bottom