View source for I24 Common Setup Issues

How to debug a few common issues that can occur during/after setup...

== ERROR: Player.txt error ==
 
When running '''mapserver.exe''' you will come across an error pertaining to ''player.txt''.
 
* Player.txt error message: 
*::''[need image]''
 
* Solution: In '''MapServer\srv\srv_init.c''' comment out line #437:
*: <code>// playerCreatedStoryArc_GenerateData();</code>

== ERROR: Loading costumes ==

* If you really want to use the I24 costumes.bin with the leaked source, delete "InternalProducts" from ParseMaskSet[], ParseCostumeCostumeTexSet[], ParseCostumeCostumeGeoSet[], and ParseCostumeBone[] in Common/gameData/costume_data.c and fix whatever compile errors you get as a result
* Need to update client side too
** Results before:
** After modification:

== ERROR: Loading templates for Dbserver.exe ==

You will begin getting errors once you try to launch dbserver.exe around “Loading Templates….”. To resolve this issue, you must run <code>mapserver.exe -productionmode -templates</code> to generate new templates and attribute files (for any missing attributes).
 
Templates location: '''Root_Directory_ServerFiles\<data folder specified in gamedatadir.txt>\server\db\templates'''. Folder should look like the following:
: ''[Need image]]''

Location of template files:
 
Additionally, you will need to create a '''coh_data\attributes''' directory in your C:\ drive.
The '''mapserver.exe''' will drop '''.attribute''' files that will need to be moved to the templates folder mentioned before (templates location).

Contents of attributes folder after '''mapserver.exe''' runs successfully:
 
In case you just want to jump right in, [[https://drive.google.com/file/d/12RdWodoUtOezqPTjMBZ76D-MJ6C_JwE0/view here are the template files]].

Also, [[https://drive.google.com/file/d/1Gva4G9BMcSwC7VySIz71rN6vTYwdNks0/view here is the maps.db file]].

== ERROR: Version difference between client/server ==
 
Add version.ini in the server executable directory, containing:
:: <code>Version=XXXXX</code>
where XXXXX is the client version.

== ERROR: Character slot issue ==
in dbserver\clientcomm.c:
* Change lines #1045-46 to: 
*: <code>if (con)</code>
*: <code>{ con->logged_in = 1; con->slot_count = 20; }</code>


Users have been able to bypass this using accountStatus = 1 and VIPShard = 1.
:: <pre>UPDATE [cohauth].[dbo].[user_account] SET [subscription_flag] = 1 WHERE [account] = 'youraccountnamehere'</pre>

== SQL: Setting up SQL database for servers ==
 
Requirements:
Microsoft SQL Express edition or SQL Server (2012 recommended)

[https://drive.google.com/file/d/1Vh0gn7X14ZVoqV7VC6-5orbCjAHnsAla/view CoH DB Schemas are located here].

== SQL: Invalid precision values ==
 
Connecting to the SQL server with dbserver produces “Invalid precision value” errors.
* Don’t use the “SQL Server” ODBC driver in your connection string in '''servers.cfg'''.
* Instead, use “SQL Server Native Client XX.0” ''(depending on what version you have installed, check Data Sources (ODBC) for possible Drivers)''

== SQL: Acquiring ODBC driver version and setting it up in servers.cfg ==
 
* To get your OBDC driver version, you must open ODBC Data Sources in Windows. 
** Once ODBC Data Source Administrator is open, navigate to the “Drivers” tab as shown:
*::''[Need image]''
* After acquiring the SQL Server Native Client version you have, you will need to edit the '''servers.cfg''' located in your '''Root_Directory_ServerFiles\<data folder>''' specified in '''<gamedatadir.txt>\server\db''' directory. The following line needs to be edited with your SQL Server Native Client driver:
 
:: <code>SqlLogin "Driver={Your_DriverVer};server=127.0.0.1;database=cohdb;trusted_connection=Yes;"</code>