Default Rank - SQlite

[ConductorWon]

Hello everyone,

 

I am setting up a fresh server and trying to get my departments set up. I want my players to have the ability to jump between departments depending on where they are playing. (I.E. BCSO when in the county, LSPD when in the city) but I want them to be able to change their call sign to match our community standard. The only way I've found to be able to do this is by them having a rank. Is there a way to have a default rank set to each department so when someone joins the department it automatically gives them the default rank?

 

Just to reiterate, I'm using SQlite.

[Starian]

Hello @ConductorWon,

Yes there's indeed a way but the solution i can offer you needs a mysql database.

If you're fine with that follow the steps below.

 

1st. Log in to your managing software for your database.

2nd. Create the rank ingame using the CAD System.

3rd. In your database look for the colum ranks

there you can change a couple of numbers.
Look for your default Rank in my case Cadet and change the Number from whaterver it states there to 0 and it should work.

 

Good Luck and Kind Regards,

 

~ Starian

 

 

[ConductorWon]

Does it have to be mysql for it to work? I downloaded the SQlite file for my server and opened it in DB Brwoser for SQlite and I have a rank number column but they are all already 0

I'm trying to avoid mysql because my server is linux based and I would rather not go through the hassle of setting up a GUI and a VNC just to manage the database

 

[Starian]

I would need to check once i'm at home.

allthough you don't need to use a GUI to manage the database, there are  plenty of programs out there to manage it.

installing phpmyadmin is also a common thing to manage databases.

[ConductorWon]

Would I be able to use that to manage it remotely on my machine?

[Starian]

Yes, both would work on your machine, you just need to connect to it

phpmyadmin is like a website, if you want to use a tool i would suggest HeidiSQL as it is free and easy to use.

 

Installing a MySQL Database is another thing but there are plenty of tutorials if you just google for them.

Edited July 19, 2021 by Starian

[ConductorWon]

I've installed a MYSQL Database before so I know how to do that I thought it just had to be controlled from the machine it was installed on, I didnt know there was a way to access remotely.

 

[ConductorWon]

I got it to work with MytSQL Thank you for the help!

[Starian]

Thats great to hear

 

Mark the Topic as solved so other players can maybe get advice out of the topic.

 

Kind Regards,

 

~ Starian

[TheCipher01]

This content has been locked by the Community Team. If you feel this was a mistake, please report this reply with a valid reason.