|
You last visited: Today at 01:43
Advertisement
New Year's surprise!
Discussion on New Year's surprise! within the Atlantica Online forum part of the MMORPGs category.
08/01/2020, 10:42
|
#421
|
elite*gold: 0
Join Date: Mar 2013
Posts: 156
Received Thanks: 28
|
In client 3.23.14 NPC move only if game window not active
fix -___- change graphics settings on 4 or 5
|
|
|
08/01/2020, 14:47
|
#422
|
elite*gold: 0
Join Date: Aug 2015
Posts: 149
Received Thanks: 28
|
any way to reduce ram usage?its using like 10 gb ram it never did that much before
im using Alfa files clean install on new pc
also wrong server code at_inca db [] when opening atlantica.exe (serverside)
edit:fixed EXEC sp_configure 'remote access', 1; RECONFIGURE; and restart
but still the server is eating more ram than usual
|
|
|
08/02/2020, 20:50
|
#423
|
elite*gold: 50
Join Date: Apr 2015
Posts: 781
Received Thanks: 235
|
Anyone who uses the script to restore or install the database!
In the script for installing LinkedServer.sql, in some cases, an error occurs with the SQL provider.
This prevents the server from functioning properly.
It is recommended to replace the global variable "@@SERVERNAME" with the MSSQL server address in all rows, I replaced with the local IP address '127.0.0.1'.
You can check if there is such a problem if you make a test connection on the Linked Server. Failure will result in an error. The error behavior of the server will be as follows: everything starts, the client is authorized, after selecting the server there is no answer to enter to the game.
Also, if you have an empty table [AT_GameDB01].[dbo].[tbl_CityHall], you must fill it in. With an empty table, the server behavior is: City bets and city rules are valid until the server is rebooted. After reloading, the rules to cities are lost.
Filling the table is done as follows:
Quote:
insert tbl_CityHall select 100, VillageUnique, 0, 0, 0 from tbl_Village where ServerID = 100 order by VillageUnique
|
In this query, 100 is ServerID.
|
|
|
08/04/2020, 12:15
|
#424
|
elite*gold: 0
Join Date: Aug 2019
Posts: 24
Received Thanks: 1
|
The phrase appears when you open the box in the game.
1. The item is not available, or the location within the inventory has been changed.
2. ailed to use the item. you've failed to get an item.
|
|
|
08/04/2020, 14:30
|
#425
|
elite*gold: 50
Join Date: Apr 2015
Posts: 781
Received Thanks: 235
|
Quote:
Originally Posted by YunJong
The phrase appears when you open the box in the game.
1. The item is not available, or the location within the inventory has been changed.
2. ailed to use the item. you've failed to get an item.
|
Basically, this behavior is associated with LinkedServers. A lot of different errors are written to the files error logs of managers and servers. Check ODBC and LinkedServers.
There may also be empty boxes. In this case, they do not open. This means that there is an item box, but there are no items in it.
|
|
|
08/06/2020, 01:58
|
#426
|
elite*gold: 0
Join Date: Aug 2015
Posts: 149
Received Thanks: 28
|
the atlantica from alfa is a piece of ****,the boxes and magic dont work i had to use CI to give me items and pass tutorial also the enemies are bugged DONT USE IT
|
|
|
08/13/2020, 13:41
|
#427
|
elite*gold: 0
Join Date: Aug 2019
Posts: 24
Received Thanks: 1
|
Quote:
Originally Posted by x123x123x
Basically, this behavior is associated with LinkedServers. A lot of different errors are written to the files error logs of managers and servers. Check ODBC and LinkedServers.
There may also be empty boxes. In this case, they do not open. This means that there is an item box, but there are no items in it.
|
I set it up from scratch, but the box doesn't open the same way.
|
|
|
08/13/2020, 14:13
|
#428
|
elite*gold: 50
Join Date: Apr 2015
Posts: 781
Received Thanks: 235
|
Quote:
Originally Posted by YunJong
I set it up from scratch, but the box doesn't open the same way.
|
What do you have in your manager files, for example, are there error log files?
If so, what records are there?
Here is an example of a record that there is no stored procedure:
(error log file named ErrorQuery_20200804.txt in AtlanticaDBManager)
|
|
|
08/15/2020, 07:50
|
#429
|
elite*gold: 0
Join Date: Aug 2019
Posts: 24
Received Thanks: 1
|
Quote:
Originally Posted by x123x123x
What do you have in your manager files, for example, are there error log files?
If so, what records are there?
Here is an example of a record that there is no stored procedure:
(error log file named ErrorQuery_20200804.txt in AtlanticaDBManager)
|
2020/08/15 14:37:36 0719
AT_GameDB01.dbo.rsp_PersonItemRemoveAndAdd
100
6
0
0
4
1876114186
23
20904
One
0
0
2
1876114184
18
21010
One
0
0
0
0
0
5
0
0
0
0
0
0
0
0
0
0
One
System
42000 MSDTC of [Microsoft][ODBC SQL Server Driver][SQL Server]server'DESKTOP-N8IDKIL' cannot be used.
I see a phrase like this
|
|
|
08/15/2020, 11:45
|
#430
|
elite*gold: 50
Join Date: Apr 2015
Posts: 781
Received Thanks: 235
|
You do not have ODBC and\or linked servers configured.
The MSDTC service may also not be enabled to work with the network.
error generates MSDTC service: 42000 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.
On some operating systems, the MSDTC service stops arbitrarily and needs to be restarted.
|
|
|
08/15/2020, 15:41
|
#431
|
elite*gold: 0
Join Date: Aug 2019
Posts: 24
Received Thanks: 1
|
Quote:
Originally Posted by x123x123x
You do not have ODBC and\or linked servers configured.
The MSDTC service may also not be enabled to work with the network.
error generates MSDTC service: 42000 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.
On some operating systems, the MSDTC service stops arbitrarily and needs to be restarted.
|
Same symptoms appear
|
|
|
08/15/2020, 19:54
|
#432
|
elite*gold: 50
Join Date: Apr 2015
Posts: 781
Received Thanks: 235
|
You can execute such a query in the database:
result:
Quote:
name | network_name | status | id | collation_name | connect_timeout | query_timeout | AccountDB | NULL | rpc,rpc out,data access,use remote collation | 1 | NULL | 0 | 0 | AT_AccountDB | NULL | rpc,rpc out,data access,use remote collation | 2 | NULL | 0 | 0 | AT_Community | NULL | rpc,rpc out,data access,use remote collation | 11 | NULL | 0 | 0 | AT_GAMEDB01 | NULL | rpc,rpc out,data access,use remote collation | 3 | NULL | 0 | 0 | ATLANTICA | NULL | rpc,rpc out,data access,use remote collation | 12 | NULL | 0 | 0 | AtlanticaAPI | NULL | rpc,rpc out,data access,use remote collation | 4 | NULL | 0 | 0 | atlanticagamelog | NULL | rpc,rpc out,data access,use remote collation | 5 | NULL | 0 | 0 | ATLANTICALOG | NULL | rpc,rpc out,data access,use remote collation | 13 | NULL | 0 | 0 | AtlanticaWeb | NULL | rpc,rpc out,data access,use remote collation | 6 | NULL | 0 | 0 | BRIDGE | NULL | rpc,rpc out,data access,use remote collation | 7 | NULL | 0 | 0 | CEMETERY\SQL | CEMETERY\SQL | rpc,rpc out,use remote collation | 0 | NULL | 0 | 0 | CHAtlanticaDB | NULL | rpc,rpc out,data access,use remote collation | 8 | NULL | 0 | 0 | gngmember | NULL | rpc,rpc out,data access,use remote collation | 9 | NULL | 0 | 0 | GNGWEB | NULL | rpc,rpc out,data access,use remote collation | 10 | NULL | 0 | 0 | INTERDB | NULL | rpc,rpc out,data access,use remote collation | 14 | NULL | 0 | 0 | LC_BILLING | NULL | rpc,rpc out,data access,use remote collation | 16 | NULL | 0 | 0 | LKDBRIDGE | NULL | rpc,rpc out,data access,use remote collation | 20 | NULL | 0 | 0 | MEMBER | NULL | rpc,rpc out,data access,use remote collation | 17 | NULL | 0 | 0 | NDOORS | NULL | rpc,rpc out,data access,use remote collation | 19 | NULL | 0 | 0 | NDOORSI | NULL | rpc,rpc out,data access,use remote collation | 18 | NULL | 0 | 0 | NGMDB | NULL | rpc,rpc out,data access,use remote collation | 15 | NULL | 0 | 0 |
|
I can connect use TeamViewer. You have an explicit configuration error. These linked servers cannot connect to databases.
-----------------------------------------------------------------------
To create ODBC faster, you can use the script:
1. MSSQL must be run on the same computer in a single instance.
2. Authorization rights with MSSQL = Windows Authentication.
3. Run after restoring databases and before creating linked servers.
4. The MSDTC service must be stopped when the script is started.
This service must be started after creating linked servers in MSSQL.
5. The script requires operating system administrator privileges.
6. System DSNs are created with TCP\IP connection and dynamic port.
Create any .bat file, copy/paste, start with administrator rights:
Quote:
@echo off
cls
echo Search MSSQL Servers:
setlocal enabledelayedexpansion
FOR /F "usebackq" %%a IN (`osql.exe -L`) DO (
set result=%%a
echo !result!
)
echo Setup ODBC...
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=AT_Account|server=!result!|database=AT_Accoun t|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=AT_Community|server=!result!|database=AT_Comm unity|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=AT_GameDB01|server=!result!|database=AT_GameD B01|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=AT_InterDB01|server=!result!|database=AT_Inte rDB01|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=AT_NGMDB|server=!result!|database=AT_NGMDB|tr usted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=ATLANTICA|server=!result!|database=ATLANTICA| trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=atlanticagamelog|server=!result!|database=atl anticalog|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=Atlanticalog|server=!result!|database=Atlanti calog|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=Bridge|server=!result!|database=Bridge|truste d_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=LC_Billing|server=!result!|database=LC_Billin g|trusted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=LKDBRIDGE|server=!result!|database=Bridge|tru sted_connection=yes"}
odbcconf.exe /a {configsysdsn "SQL Server" "DSN=MEMBER|server=!result!|database=MEMBER|truste d_connection=yes"}
echo ODBC installed!
timeout /t 30
|
The script search for MSSQL instances on the system.
It takes a few seconds.
Copies MSSQL instance name to variable "result".
Then creates the system DSNs.
|
|
|
08/16/2020, 10:05
|
#433
|
elite*gold: 0
Join Date: Aug 2019
Posts: 24
Received Thanks: 1
|
Quote:
Originally Posted by x123x123x
You can execute such a query in the database:
result:
I can connect use TeamViewer. You have an explicit configuration error. These linked servers cannot connect to databases.
-----------------------------------------------------------------------
To create ODBC faster, you can use the script:
1. MSSQL must be run on the same computer in a single instance.
2. Authorization rights with MSSQL = Windows Authentication.
3. Run after restoring databases and before creating linked servers.
4. The MSDTC service must be stopped when the script is started.
This service must be started after creating linked servers in MSSQL.
5. The script requires operating system administrator privileges.
6. System DSNs are created with TCP\IP connection and dynamic port.
Create any .bat file, copy/paste, start with administrator rights:
The script search for MSSQL instances on the system.
It takes a few seconds.
Copies MSSQL instance name to variable "result".
Then creates the system DSNs.
|
x123x123x. Thank you.
I was successful in this part.
Sorry.
Let me just one more question.
Are there any more version upgrades?
Or is there any way to add mounts or items?
|
|
|
08/21/2020, 10:47
|
#434
|
elite*gold: 0
Join Date: Aug 2015
Posts: 149
Received Thanks: 28
|
you cant even make the server run and you want to mess with the files...
|
|
|
08/26/2020, 06:38
|
#435
|
elite*gold: 0
Join Date: Mar 2020
Posts: 7
Received Thanks: 1
|
I have a question, can't we play the recent version? Because this version is quite old and does not have the current new character classes. I want to experience new character classes.
|
|
|
Similar Threads
|
VipSrO Hapy New Year Surprise Start Acc 120 Lvl
01/30/2020 - SRO PServer Advertising - 8 Replies
VipSrO PvP serverimiz adı üstünde PvP serverdir.. Bu amaçla 110 olan başlangıç charları yılbaşı eventi olarak 120 ye yükseltilmiştir.. Bundan böyle yeni oyuncularımız 120 level ve 5m sp + Full nova set ile başlayacaktır..
VipSrO Online Silkroad PvP Server 120 Start + 5m SP + Full Nova Set + Max Level 120 + All Map Open
Max Level 120
Client version: v1.404
ServerFiles: Vietnam Silkroad
Start 120 Level + 5m SP + nova full set Gift
|
ScriptVessel (surprise, surprise)
12/31/2006 - Conquer Online 2 - 3 Replies
Hi,
Before I purchase ScriptVessel can people please post any feedback on stability, ease of use, features, developer support, etc.
Just wandering as it appears to be mixed reception upto now.
thx in advance
|
All times are GMT +2. The time now is 01:43.
|
|