What to do after server setup ?

09/19/2017 21:28 BrotalityElite#1

Okay , I know it's not just me , I have done research , Watched numerous videos , I have gotten as far as getting my server set up I have all green arrows , I just need to know what I need to to next .
This is just a test server I'm attempting to setup . And I'm using 5.4 server files from [Admin]Grr . SQL Express 2014 , & SQL Management 2014

Can anyone let me know what else I'll need ? I just need direction not to be spoon fed . All anyone talks about is just the Server Setup itself not what you need / Need to do after to actually get in the game . I am new to this and I'm more than willing to learn and share with the rest of the community .

Completed .
SQL setup
Server File Placements
Configuring Firewalls/Server Files
Attached DB in Management

09/19/2017 23:05 Velocity.#2

that is not true, there are multiple tutorials on a full setup on how to get a server running.
you haven't looked hard enough.
[Only registered and activated users can see links. Click Here To Register...]

09/20/2017 00:07 BrotalityElite#3

Saying that I actually got the client to work (so far) but is there any way I can create more accounts in the DB without the OMG Web through SQL Management ?

09/20/2017 02:14 sominus#4

Using SQL Management (or any other manager) is mandatory if you want to make a server (even a test one). Everything is stored on DBs.

Just go to ps_userdata.dbo.users_master (users_detail is not needed), and add a new row (manually), try to understand what every value means there. Copy the values from the GM account.

Just remember:

Code:

UserUID: must be unique (cant have duplicated values). In some releases this field is autonumeric, but sometimes you have to put the number there.
Admin: 1=GM / 0=normal player
AdminLevel: 0=normal player / other values=GM
Status: 0=normal player / other values=GM
UserType: A=GM / N=normal player

The other fields, you can copy values from the GM account.

Search the PROFNERWOSOL "Guide to Shaiya Configuration" here on the forums.

09/20/2017 03:59 killer2p#5

or setup a webserver (local) and use any registration script in it

09/20/2017 05:11 BrotalityElite#6

Thank you guys for taking the time to help out . I managed to get into my test server , client working . so now I can actually start on the real tasks like editing etc .