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

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:

Quote:

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.

Can't set period of DeclarationOfWar when starting the field server
Normal users DC from the Game after 5-10 minutes
Launcher Error: "Please download the game again ... newest version: 0.0.0.0"
"Fail to connect DBServer - Wrong DB Password"

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-s...rdays-1109185/

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:

Hackshield SDK (Build 235)
Hackshield SDK (Build 296)

To generate this HackShield file...

Quote:

Originally Posted by decarvk

...there is all sdk documentation in this share so read it and all will working fine

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:

Quote:

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):

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 1.0.0.0 WindowDegreeNew 1920x1080 (high) WindowMode 1 AccountName ServerGroupName

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 1.0.0.0 LauncherVersion 1.0.0.0 DeleteFileListVersion 1.0.0.0 NoticeVersion 0.0.0.0

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 = 0.9.9.9

If all of this didn't help:

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 = HTTP

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_HTTP_SERVER_IP1 = yourserver.com $DOWNLOAD_HTTP_SERVER_IP2 = yourserver.com $DOWNLOAD_HTTP_SERVER_PORT = 80 $DOWNLOAD_HTTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_HTTP_SERVER_PASSWORD = $CLIENT_UPDATE_DOWNLOAD_HTTP_DIR = //Ace/autoupdate/aceonline/ $LAUNCHER_FILE_DOWNLOAD_HTTP_PATH = //Ace/autoupdate/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_HTTP_PATH = //Ace/autoupdate/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_HTTP_PATH = //Ace/autoupdate/notice/notice.txt $VERSION_LIST_FILE_DOWNLOAD_HTTP_PATH = //Ace/autoupdate/aceonline/versionlist.ver

Check if the Update Server has the necessary files and the correct file system
Check the server logs for any Problems regarding the Patching (PreServer logs)

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