Guide : How to Create Atlantica Online Server

[x123x123x]

No, I use the same version of Express. The server name is specified during installation, and nothing prevents him to change.

[joshy9]

Originally Posted by x123x123x

No, I use the same version of Express. The server name is specified during installation, and nothing prevents him to change.

reinstalled everything since suddenly i couldnt connect and i still cant ugh this is getting annoying lol... knowing i could add things to the game and i cant even get the server running lol.

[nephren]

Make sure to enable TCP/IP at SQL Configurations ;-)

[joshy9]

Originally Posted by nephren

Make sure to enable TCP/IP at SQL Configurations ;-)

they are enabled but still fail :/ i even tried this on my laptop and it even fails on there so i am guessing something is missing? but i have followed everything in this thread. and all ports are open with firewall open so that isnt a problem.

[x123x123x]

This problem TCP/IP configure SQL Server.

Quick start.
Not fully functional game server.
(install mssql, configure mssql, restore DB, create ODBC, config servers, start servers - OS Windows Server 2012 R2 Standard)
~1 hour video:

[joshy9]

Originally Posted by x123x123x

This problem TCP/IP configure SQL Server.

Quick start.
Not fully functional game server.
(install mssql, configure mssql, restore DB, create ODBC, config servers, start servers - OS Windows Server 2012 R2 Standard)
~1 hour video:

oh nice this may be a big help i will uninstall everything and start from scratch. hopefully this will get me going lol.

[x123x123x]

There's still a lot needs to be corrected. For example do linked against servers, extend the time for GM (GM so the entrance was a regular user - time ran out). Enable MSDTC service. Create a table of logs for stored procedures.
Then I showed only the minimum at which the server has started and enter the game.

[joshy9]

Originally Posted by x123x123x

There's still a lot needs to be corrected. For example do linked against servers, extend the time for GM (GM so the entrance was a regular user - time ran out). Enable MSDTC service. Create a table of logs for stored procedures.
Then I showed only the minimum at which the server has started and enter the game.

the video helped alot finally a success now could you explain what you just said please

Enable MSDTC? , GM Extend time? and create a table of logs? how do i do those? also where to change game settings like bonus exp etc

many thanks for all this help i hope i can return in the future.

[x123x123x]

Start MSSQL Server Management Studio
New Query (DB master)
GM extend time:

USE [AT_AccountDB]
GO

UPDATE [dbo].[tbl_Account]
   SET 
   [MasterLevelExpireTime] = '2100-12-06 21:33:00.000',
   [MasterLevelValue] = 120
 WHERE ID = 'testacc' OR ID = 'archonus'

Create a table of logs stored procedures:

USE [AT_GameDB01]
GO

/****** Object:  Table [dbo].[c_ProcData]    Script Date: 06.06.2016 13:51:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[c_ProcData](
	[Seq] [int] IDENTITY(1,1) NOT NULL,
	[Reg_Date] [datetime] NOT NULL CONSTRAINT [DF_c_ProcData_Reg_Date]  DEFAULT (getdate()),
	[ProcedureName] [varchar](100) NULL,
	[Details] [varchar](max) NULL,
	[nDetails] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[Seq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Before turning on the need to create a linked against MSDTC servers and enable RPC ('True' in property linked server):

exec sp_addlinkedserver 'AT_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'AT_GAMEDB01','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'AccountDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'AccountDB','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'AT_Community','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'AT_Community','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'ATLANTICA','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'ATLANTICA','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'ATLANTICALOG','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'ATLANTICALOG','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'BRIDGE','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'BRIDGE','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'INTERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'INTERDB','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'NGMDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'NGMDB','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'LC_BILLING','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'LC_BILLING','false',null,'sa','qweQWE123'

exec sp_addlinkedserver 'MEMBER','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'MEMBER','false',null,'sa','qweQWE123'

MSDTC

1. Click Start, click Run, type dcomcnfg and then click OK to open Component Services.
2. In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator and then click Local DTC.
3. Right click Local DTC and click Properties to display the Local DTC Properties dialog box.
4. Click the Security tab.
5. Check mark "Network DTC Access" checkbox.
6. Finally check mark "Allow Inbound" and "Allow Outbound" checkboxes.
7. Click Apply, OK.
8. A message will pop up about restarting the service.
9. Click OK and That's all.

Bonus Exp and more setting
x:\gameserver\serverinfo\eng(all)\
Exp -> x:\..\eng\BONUSTIMEINFO.TXT
All server files are not necessarily encode.
It is easier to work with them. On the server is not affected.
Synchronize the client-server changes, for example if you have added the item in the game or change quests.

[joshy9]

Originally Posted by x123x123x

Before turning on the need to create a linked against MSDTC servers and enable RPC ('True' in property linked server):

where do i find and do this in again please? im having a brain dead moment lol

[x123x123x]

*properties


Sorry bad text - google translate
for the GM needs more like this:

USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbl_MasterIP]
           ([IP])
     VALUES
           ('127.0.0.1')
GO


USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbla_ManagerIP]
           ([IP])
     VALUES
           ('127.0.0.1')
GO


USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbla_masterip]
           ([IP])
     VALUES
           ('127.0.0.1')
GO

[ger12]

Good afternoon, can someone help me connect a server?

Skype: contacto.tech.life

[joshy9]

Originally Posted by x123x123x

*properties


Sorry bad text - google translate
for the GM needs more like this:

USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbl_MasterIP]
           ([IP])
     VALUES
           ('127.0.0.1')
GO


USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbla_ManagerIP]
           ([IP])
     VALUES
           ('127.0.0.1')
GO


USE [AT_AccountDB]
GO


INSERT INTO [dbo].[tbla_masterip]
           ([IP])
     VALUES
           ('127.0.0.1')
GO

yay i got it up and running now just some questions

can i make a new account into a gm account?
do you know how to edit the drop rates?
also can i clean all accounts and chars, guilds and nations?

many thanks for all the help

[x123x123x]

can i make a new account into a gm account?

Only theoretically can present scheme.
Edit existing the GM.
Create new account (user) and its data to replace the GM data.
The procedure has to create the GM, but I could not make out completely.
The most simple - replace md5 hash of the password in Account table.
GM "archonus" easily edited.

do you know how to edit the drop rates?

If you need to edit the item to Monster, then you need to go to the game GM in windowed mode, press F10, select сhariteminfo click OK in the dialog box, and in the window that appears, change the drop into a monster.

Rates drop from monsters I was not looking.

also can i clean all accounts and chars, guilds and nations?

I can not see, I have a database in the recovery stage, and there is no access to the functionality. Unsuccessful experiment with backup. My DB status "read only".

[joshy9]

Originally Posted by x123x123x

Only theoretically can present scheme.
Edit existing the GM.
Create new account (user) and its data to replace the GM data.
The procedure has to create the GM, but I could not make out completely.
The most simple - replace md5 hash of the password in Account table.
GM "archonus" easily edited.


If you need to edit the item to Monster, then you need to go to the game GM in windowed mode, press F10, select сhariteminfo click OK in the dialog box, and in the window that appears, change the drop into a monster.

Rates drop from monsters I was not looking.


I can not see, I have a database in the recovery stage, and there is no access to the functionality. Unsuccessful experiment with backup. My DB status "read only".

ok one last thing and i know this was mentioned before but how do i change the stamina from 60 to 1000 without doing the .ciall whatever the command is haha. i think someone said something in the server data persondatacount.ndt i think but i dont know what to edit as it says 50 100 50 for the standara high and low etc

edit - nevermind i sorted the stamina but i have a problem i get error when using the F8-F10 and using an option i get a window popping up with a title named vewr3dsf and error fds3df: -1