[Guide]How to manually setup accounts!

[Commodus]

Hello!

 

In this guide i will explain you how to setup the accounts of your server manually!

 

I searched the forum for such a guide but i didn't find anything. (keyword : ''setup accounts'')

 

Lets start :

 

Open the loginserver folder and open the file startSQLAccountManager.bat.

 

It will look like this :

 

Please choose an option:
1 - Create new account or update existing one (change pass and access level)
2 - Change access level
3 - Delete existing account (this option _keeps_ character files)
4 - List accounts & access levels
5 - Exit

Your choice:

 

 

How to create new account :

 

Select option 1

Enter a username: mxc

Enter a password: account

Enter access level: 0

Press any key to close.

Account is created, you can see it in database in table accounts.

This can be done while your server is online.You don't need to restart your server.

 

 

How to update an existing account :

 

To change account's password or access level, select option 1.

Enter desired username: mxc

Enter new password: account

Enter new access level: 100

This can be done while your server is online.You don't need to restart your server.

 

 

How to change the access level :

 

Select option 2

Enter desired username: mxc

Enter new access level: 100

When you put the username and the access level you will see :

Account mxc has been updated.

Press any key to close.

This can be done while your server is online.You don't need to restart your server.

 

 

How to delete an account :

 

Select option 3

Enter desired username: mxc

When you put the username you will see :

Do you really want to delete this account ? Y/N :

To confirm deletion type Y (Y not y) and press Enter.

After confirming the deletion you will see:

Account mxc has been deleted.

Press any key to close.

This can be done while your server is online.You don't need to restart your server.

 

Note: Characters associated to this account will NOT be deleted.

 

You can delete the characters of this account by going to the table ''characters'' in your database.

 

 

How to view accounts and their access levels :

 

Choose option 4 and press Enter.

You will see all accounts listed with their access level, like this:

mxc -> 0

maxcheaters -> 100

_______________________________________________________________________________

 

If you see an account with a minus access lvl for example -100 this means that this account is banned.

_______________________________________________________________________________

 

Number of accounts: 3678.

Press any key to close.

This can be done while your server is online.You don't need to restart your server.

 

 

If you don't want to make anything of these operations :[/color]

 

Select the option 5 to exit and any key to close.

 

Credits : Commodus,L2JServer.

[Grim.]

wow!

good work commodus........

well it is very easy....

[BS®]

good work mate.Nice Guide!Some ppl dont know this things :).Thanks for the guide

[Justice]

Awsome work tnx :)

[~Greedy~]

Great guide for newbies :) awsome work dude

[mg13gr]

Nice one m8. Kinda useful.

 

Keep sharing. :)

[KnightOnline]

Thanks Man

[Nabzor]

Amazing guide. Keep sharing mate.

 

 

 

 

[SirDarkAngel]

Thanks for share , very usefull :D