New Year's surprise!

[x123x123x]

Originally Posted by LySaoran

I missing something ???




Help me please.

You have MSSQL running port 4300. You must change to a different port in the MSSQL configuration.

[LySaoran]

Originally Posted by x123x123x

You have MSSQL running port 4300. You must change to a different port in the MSSQL configuration.

Right ? I don't see any port 4300

[x123x123x]

That's right, wrong look. There, first the addresses with the port are indicated, and then the application.

The client stops because the client is waiting for a response from the game server to enter the lobby (where characters are created or already exist). Communication takes place using port 4300.

[LySaoran]

Originally Posted by x123x123x

That's right, wrong look. There, first the addresses with the port are indicated, and then the application.

The client stops because the client is waiting for a response from the game server to enter the lobby (where characters are created or already exist). Communication takes place using port 4300.

... I don't know how to check and change sqlservr.exe port 0.0.0.0:4300 >.< ...

[x123x123x]

This is not sql on this port, but Atlantica.exe is the game server.
Need to check the firewall. The server or client appears to be locked by it.

Reset the firewall to default. Enable notifications and then start the server. In notifications, allow the use of the network. Just start the client and also allow the network to be used.

[LySaoran]

Originally Posted by x123x123x

That's right, wrong look. There, first the addresses with the port are indicated, and then the application.

The client stops because the client is waiting for a response from the game server to enter the lobby (where characters are created or already exist). Communication takes place using port 4300.

Originally Posted by x123x123x

This is not sql on this port, but Atlantica.exe is the game server.
Need to check the firewall. The server or client appears to be locked by it.

Reset the firewall to default. Enable notifications and then start the server. In notifications, allow the use of the network. Just start the client and also allow the network to be used.

Update:

[x123x123x]

Originally Posted by LySaoran

Update:

Is the server running or stopped?
It occupies the port when the application starts, but it itself can wait for the database and not accept clients.

[LySaoran]

Originally Posted by x123x123x

Is the server running or stopped?
It occupies the port when the application starts, but it itself can wait for the database and not accept clients.

Yup, my SQL Server is running. When I play Atlantica ver 3.02.11, it's normal. I can login and play, but with this version, I just login by master account anh have block background...

[x123x123x]

What's going on in your authorization? AccountDBManager.exe и AuthServer.exe
You should see the answers from the game server, like these:

[LySaoran]

Originally Posted by x123x123x

What's going on in your authorization? AccountDBManager.exe и AuthServer.exe
You should see the answers from the game server, like these:

Here please.

[x123x123x]

You need to see the procedures in the database:
dbo.rsp_IDNumGet
dbo.rasp_OneTimeKeymake
dbo.rasp_IDNumGet_GetNdoorsMember_USA
There's probably a mistake in one of them. A common error in the dbo.rasp_IDNumGet_GetNdoorsMember_USA procedure is a query to an empty table. You can start with that. What's in it? This is the [AT_AccountDB] database.


You may be fetching data from table [dbo].[tbl_Member] - this will be an error.

This table is made for double registration, i.e. first registration on the site, and then a game account is already created. There is no site and it makes no sense to use this mechanism, so we immediately turn to the table of game accounts ([dbo].[tbl_Account]).

[LySaoran]

Originally Posted by x123x123x

You need to see the procedures in the database:
dbo.rsp_IDNumGet
dbo.rasp_OneTimeKeymake
dbo.rasp_IDNumGet_GetNdoorsMember_USA
There's probably a mistake in one of them. A common error in the dbo.rasp_IDNumGet_GetNdoorsMember_USA procedure is a query to an empty table. You can start with that. What's in it? This is the [AT_AccountDB] database.


You may be fetching data from table [dbo].[tbl_Member] - this will be an error.

This table is made for double registration, i.e. first registration on the site, and then a game account is already created. There is no site and it makes no sense to use this mechanism, so we immediately turn to the table of game accounts ([dbo].[tbl_Account]).

Yes, I think I miss something when create database. Can you send me all script code for SQL ? Drom 0:35:00 in this video (

). I think I need rebuild Database.

[x123x123x]

I'm not using a very good database. You can try using it. But you will need to delete ODBC and Linked Servers and then recreate them.
My database backup is now:


For the GameMaster (GM), you need to correct the IP address to your IP.
[AT_AccountDB].[dbo].[tbl_MasterIP]

You may also need to change the GameMaster password in the scalar function to your password.
[AT_AccountDB].[dbo].[rf_IsMasterPW]

In table [AT_AccountDB].[dbo].[tbl_ManagerIP], you must specify the IDNum of your GM.
IDNum is taken from table [AT_AccountDB].[dbo].[tbl_Account]

There are 3 accounts. 2 GM accounts + 1 account without a password (password changed to SecondKey when and how I don't remember).
Login1: test
Password1: asdfqwerty
Login2: testacc
Password2: asdfqwerty

[YunJong]

Character. Where is it deleted?

[x123x123x]

Originally Posted by YunJong

Character. Where is it deleted?

Characters are removed gamely from the client.
You can also delete a character using the procedure: [AT_GameDB01]. [dbo]. [rasp_PersonTotalInfoDelete]
This procedure has input data:

@ IDNum - > from table dbo.tbl_Person
@ PersonID - > from table dbo.tbl_Person
@ Name - > from table dbo.tbl_Person