Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[FAQ] Updated FAQ - Ep 3.x/4.x

[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
As the old FAQ got outdated and closed due to irrelevance and spam, I'm starting this new one here.
We all saw similar topics pop up in the Help Section lately and some ppl still seem to have difficulties with using the search function. You might have an easier life, checking this.

First of all
This is a pure knowledge share! If you have a question about something, post it in the Help Section. If it's related to one of these FAQs, please link (quote) the FAQ post to your Help Thread! If you reply, reply with an FAQ & Answer or do not reply.

FAQs - Structure
I'm looking for you guys to help me with this! If you have a frequently asked question and the solution for it, share your knowledge here! Necroposting rules don't apply to this thread! This thread is an FAQ and cannot get inactive as such, so feel free to post your knowledge!

Please maintain a general structure:
Question/Problem: Short and descriptive title of the FAQ
Solution:
Brief explanation of what is needed to be done to solve this problem
It would also be great if you could title your reply with the FAQs title. You can also post several FAQ's in one reply.
If you post something that has already been answered like this on the forum, please quote the original poster to give him proper credits for his efforts!

This is also aiming to be a short question & answer thread. If your solution takes a lot of things to do you might want to consider creating a new Tutorial for it ;)

FAQs - Index
A list of all FAQs posted here. Links will be kept up to date.

  1. Can't set period of DeclarationOfWar when starting the field server
  2. Normal users DC from the Game after 5-10 minutes
  3. Launcher Error: "Please download the game again ... newest version: 0.0.0.0"
  4. "Fail to connect DBServer - Wrong DB Password"
 
Last edited:
[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
Can't set period of DeclarationOfWar when starting the field server

So with this post I'm gonna set an example of how to do this.

Problem: Can't set period of DeclarationOfWar when starting the Field Server
Solution:
The server is unable to setup war times due to wrong data in atum2_db_1.dbo.td_DeclarationOfWar as initially mentioned by PanKJ in this post.
While you should set your Declaration of War using the Admin Tool, this SQL query will init the Declaration of War table so that the Field Server boots:

Code:
USE atum2_db_1
GO

DROP TABLE dbo.td_DeclarationOfWar
GO

CREATE TABLE dbo.td_DeclarationOfWar (
	Influence		TINYINT,
	MSWarStep		TINYINT,
	NCP			INT,
	MSNum               	INT,
	MSAppearanceMap     	INT,
	MSWarStepStartTime  	datetime,	
	MSWarStepEndTime	datetime,
	MSWarStartTime		datetime,	
	MSWarEndTime		datetime,
	SelectCount		TINYINT,
	GiveUp			BIT,
	MSWarEndState		TINYINT
)
CREATE UNIQUE CLUSTERED INDEX idx_on_DeclarationOfWar ON td_DeclarationOfWar(Influence, MSWarStep)
GO

INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 1, 0, 0, 0, GetDate(), DateAdd(day, 7, GetDate()), DateAdd(day, 3, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 2, 0, 0, 0, DateAdd(day, 7, GetDate()), DateAdd(day, 14, GetDate()), DateAdd(day, 10, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 3, 0, 0, 0, DateAdd(day, 14, GetDate()), DateAdd(day, 21, GetDate()), DateAdd(day, 17, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 4, 0, 0, 0, DateAdd(day, 21, GetDate()), DateAdd(day, 28, GetDate()), DateAdd(day, 24, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 5, 0, 0, 0, DateAdd(day, 28, GetDate()), DateAdd(day, 35, GetDate()), DateAdd(day, 31, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (2, 99, 0, 0, 0, DateAdd(day, 35, GetDate()), DateAdd(day, 42, GetDate()), DateAdd(day, 38, GetDate()), NULL, 3, 0, 0)

INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 1, 0, 0, 0, GetDate(), DateAdd(day, 7, GetDate()), DateAdd(day, 3, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 2, 0, 0, 0, DateAdd(day, 7, GetDate()), DateAdd(day, 14, GetDate()), DateAdd(day, 10, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 3, 0, 0, 0, DateAdd(day, 14, GetDate()), DateAdd(day, 21, GetDate()), DateAdd(day, 17, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 4, 0, 0, 0, DateAdd(day, 21, GetDate()), DateAdd(day, 28, GetDate()), DateAdd(day, 24, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 5, 0, 0, 0, DateAdd(day, 28, GetDate()), DateAdd(day, 35, GetDate()), DateAdd(day, 31, GetDate()), NULL, 3, 0, 0)
INSERT INTO dbo.td_DeclarationOfWar (Influence, MSWarStep, NCP, MSNum, MSAppearanceMap, MSWarStepStartTime, MSWarStepEndTime
										, MSWarStartTime, MSWarEndTime, SelectCount, GiveUp, MSWarEndState)
	VALUES (4, 99, 0, 0, 0, DateAdd(day, 35, GetDate()), DateAdd(day, 42, GetDate()), DateAdd(day, 38, GetDate()), NULL, 3, 0, 0)
GO

Edit: I also just release an updated script by me that sets the MS times to Saturdays and Sundays, 20:00 Server time. Have a look: http://forum.ragezone.com/f613/sql-script-mothership-war-saturdays-1109185/
 
Last edited:
[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
Normal users DC from the Game after 5-10 minutes

Question/Problem: Normal users DC from the Game after 5-10 minutes
Solution:
It's most likely due to a mismatching HackShield Checksum File "AntiCpX.hsb". The file is located in this folder: "YourServer\Config\Security\HackShield"

The simplest way around this is disabling the HackShield by Code, if you have access to the source. This is covered by my tutorial: Disabling HackShield

If you wish to use the HackShield:

Several HackShield SDKs were released here:

To generate this HackShield file...
...there is all sdk documentation in this share so read it and all will working fine
 
Last edited:
[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
Launcher Error: "Please download the game again ... newest version: 0.0.0.0"

Question/Problem: Launcher Error: "Please download the game again ... newest version: 0.0.0.0"
Solution:

If you get the error message from the Launcher that says:
Please download the game again.
URL: yoururl.com.
Newest version: X.X.X.X

Your client version (located at the VersionInfo.ver file at the client) is either lower than the minimum reinstall version (located in the global.cfg file) or higher than the current server version (located in the versions.cfg) file.

This most likely happens, when you forget to adjust the client and / or server versions so here is a list of things that you should check in case you have this error (originally posted here):

  1. Check the Client/VersionInfo.ver file in your Client. Make sure it matches the Servers latest version entry
    Code:
    LauncherVersion		1.0.0.0
    
    ClientVersion		[COLOR=#FF0000]1.0.0.0[/COLOR]
    WindowDegreeNew		1920x1080 (high)
    
    WindowMode		1
    
    AccountName
    ServerGroupName
  2. Check the Server/Config/versions.cfg file and make sure it has valid entries

    It should look something like this:
    Code:
    ClientVersion		0.0.0.0	[COLOR=#FF0000]1.0.0.0[/COLOR]
    
    LauncherVersion		1.0.0.0
    DeleteFileListVersion	1.0.0.0
    NoticeVersion		0.0.0.0
  3. Check the Server/Config/global.cfg file for the required minimum version ($CLIENT_REINSTALL_VERSION) and make sure that its lower than the Version that you set up in the versions.cfg

    Code:
    $CLIENT_REINSTALL_VERSION	= [COLOR=#FF0000]0.9.9.9[/COLOR]



    If all of this didn't help:

  4. Check the Update Server settings. FTP is bugged since 3.5 so you will have to use a HTTP Update server, that can be installed locally (xampp, Apache) or hosted on a webserver (would be recommended if you want to run the game online). So the update server type ($AUTO_UPDATE_SERVER_TYPE) must be HTTP

    Code:
    $AUTO_UPDATE_SERVER_TYPE	= [COLOR=#FF0000]HTTP[/COLOR]
  5. The Pre Server must be able to connect to your HTTP Server. Check if you inserted the correct URLs as well as connection settings in the global.cfg under the Settings which have a ..._HTTP_... in it. (check if the URLs work with your browser. If your browser can't connect to them, the launcher can't either.)

    Code:
    $DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]SERVER_IP1		= [COLOR=#FF0000]yourserver.com[/COLOR]
    $DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]SERVER_IP2		= [COLOR=#FF0000]yourserver.com[/COLOR]
    $DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]SERVER_PORT		= [COLOR=#FF0000]80[/COLOR]
    $DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]SERVER_ACCOUNT		= anonymous
    $DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]SERVER_PASSWORD		=
    
    $CLIENT_UPDATE_DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]DIR		= [COLOR=#FF0000]//Ace/autoupdate/aceonline/[/COLOR]
    $LAUNCHER_FILE_DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]PATH	= [COLOR=#FF0000]//Ace/autoupdate/launcher/Launcher.atm[/COLOR]
    $DELETE_FILE_LIST_DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]PATH	= [COLOR=#FF0000]//Ace/autoupdate/deletefilelist/deletefilelist.txt[/COLOR]
    $NOTICE_FILE_DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]PATH		= [COLOR=#FF0000]//Ace/autoupdate/notice/notice.txt[/COLOR]
    $VERSION_LIST_FILE_DOWNLOAD[COLOR=#FF0000]_HTTP_[/COLOR]PATH	= [COLOR=#FF0000]//Ace/autoupdate/aceonline/versionlist.ver[/COLOR]
  6. Check if the Update Server has the necessary files and the correct file system
  7. Check the server logs for any Problems regarding the Patching (PreServer logs)
 
[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
Fail to connect DBServer - Wrong DB Password

Problem: "Fail to connect DBServer - Wrong DB Password"
Solution:

First of all it's worth to note that this error log will be written at any problem during the establishment of the connection to the database server, not only when the password is wrong. This is due to horrible logging as usual

This problem can almost always be resolved by connecting to your database target using the SQL Server Management Studio with the login data you added to the configuration files. If that won't connect, neither will your server. The error you're getting there is a ton more helpful than the logging output.

That being said, the most common reasons for database connections to fail are:
  • TCP network data is not configured correctly for the SQL server
    Check in the Configuration Manager under Network and your SQL Server instance
    This is also nicely explained in St34lth4ng3l's complete guide to making a 4.2 server under Database Setup
  • The server does not allow SQL authentication
    This can also be changed after the installation via the Management Studio
  • You did or did not XOR the credentials in the global.cfg
    This depends on the binaries you're using. Try one or the other
  • Your db password contains special characters like ";"
    This was pointed out by decarvk here. Avoid using special characters for your authentication data
  • The username is wrong
  • The password is wrong
 
Back
Top