103
104
105
106
107
108
109

  <ItemGroup>
  <Reference Include="GameLib, Version=0.2.2039.20837, Culture=neutral">
    <HintPath>Dlls\GameLib.dll</HintPath>
  </Reference>
  <Reference Include="Net, Version=1.0.0.0, Culture=neutral, processorArchitecture=MSIL">
    <HintPath>Dlls\Net.dll</HintPath>
  </Reference>

11
12
13
14
15
16
17

  GlobalSection(SourceCodeControl) = preSolution
    SccNumberOfProjects = 1
    SccProjectUniqueName0 = DragonsSpine.csproj
    SccProjectName0 = \u0022$/Dragons\u0020Spine\u00202005/DragonsSpine\u0022,\u0020
    SccLocalPath0 = .
    SccProvider0 = MSSCCI:Microsoft\u0020Visual\u0020SourceSafe
  EndGlobalSection

 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101

public static int Main(string[] args)
{
  SetInstance(new DragonsSpineMain());
  m_settings = GameServerSettings.Load();

  #region Initialize Console
  WinConsole.Initialize();

  //// to make Debug or Trace output to the console, do the following.
  ////Debug.Listeners.Remove("default");
  ////Debug.Listeners.Add(new TextWriterTraceListener(new ConsoleWriter(...)));

  Console.SetError(new ConsoleWriter(Console.Error, ConsoleColor.Red | ConsoleColor.Intensified | ConsoleColor.WhiteBG, ConsoleFlashMode.FlashUntilResponse, true));
  //WinConsole.Color = ConsoleColor.Blue | ConsoleColor.Intensified | ConsoleColor.BlueBG;
  WinConsole.Flash(true);
  #endregion
  //WinConsole.Visible = false;
  DragonsSpineMain main = new DragonsSpineMain(); // create our main class
  DragonsSpineMain.ServerStatus = DragonsSpineMain.ServerState.Starting;
  Utils.Log(APP_NAME + " " + APP_VERSION, Utils.LogType.SystemGo);

124
125
126
127
128
129
130
131
132
133
134
135
136
137

public bool FillLand() // fill this land with the appropriate maps
{
  try
  {
    DAL.DBWorld.LoadMaps(this);

    string mapBase = "..\\..\\maps";

    foreach (Map map in this.Maps)
    {
      if (!map.LoadMap(mapBase + "\\" + map.Name + ".txt", this.FacetID, this.LandID, map.MapID))
      {
        Utils.Log("Land.FillLand() failed while loading map file for " + map.Name + ".", Utils.LogType.SystemFailure);
      }

124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141

public bool FillLand() // fill this land with the appropriate maps
{
  try
  {
    DAL.DBWorld.LoadMaps(this);

    string mapBase = Utils.GetStartupPath() +
    ".." + Path.DirectorySeparatorChar + ".." + Path.DirectorySeparatorChar +
    "maps";

    foreach (Map map in this.Maps)
    {
      string mapFilename = mapBase + Path.DirectorySeparatorChar + map.Name + ".txt";
      if (!map.LoadMap(mapFilename, this.FacetID, this.LandID, map.MapID))
      {
        Utils.Log("Land.FillLand() failed while loading map file " + mapFilename +
          " for " + map.Name + ".", Utils.LogType.SystemFailure);
      }

236
237
238
239
240
241

public static string GetStartupPath()
{
  Assembly executingAssembly = Assembly.GetExecutingAssembly();
  string exeName = Path.GetFileNameWithoutExtension(executingAssembly.Location);
  return (Path.GetDirectoryName(executingAssembly.Location) + @"\");
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

FROM mcr.microsoft.com/mssql/server:2017-latest

# Create a config directory
RUN mkdir -p /usr/config
WORKDIR /usr/config

# Bundle config source
COPY docker/. /usr/config
COPY EntireDB-minimal.sql /usr/config/
COPY EntireDB-production.sql /usr/config/

# Grant permissions for our scripts to be executable
RUN chmod +x /usr/config/entrypoint.sh
RUN chmod +x /usr/config/configure-db.sh

ENV ACCEPT_EULA=Y
ENV SA_PASSWORD=TempBadPassw0rd
RUN ["./configure-db.sh"]

ENTRYPOINT ["./entrypoint.sh"]

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

#!/bin/bash

# Start SQL Server
/opt/mssql/bin/sqlservr &

# Wait 60 seconds for SQL Server to start up by ensuring that 
# calling SQLCMD does not return an error code, which will ensure that sqlcmd is accessible
# and that system and user databases return "0" which means all databases are in an "online" state
# https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-2017 

DBSTATUS=1
ERRCODE=1
i=0

while [[ $((DBSTATUS + ERRCODE)) -ne 0 ]] && [[ $i -le 60 ]]; do
  i=$(( i + 1 ))
  echo "Checking server status ($i of 60)..."
  DBSTATUS=$(/opt/mssql-tools/bin/sqlcmd -h -1 -t 1 -U sa -P $SA_PASSWORD -Q "SET NOCOUNT ON; Select SUM(state) from sys.databases")
  ERRCODE=$?
  sleep 1
done

echo $DBSTATUS
echo $ERRCODE
if [[ $DBSTATUS -ne 0 ]] || [[ $ERRCODE -ne 0 ]]; then 
  echo "SQL Server took more than 60 seconds to start up or one or more databases are not in an ONLINE state"
  exit 1
fi

# Run the setup script to create the DB and the schema in the DB
echo "Adding production database..."
/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P $SA_PASSWORD -d master -v MYDATABASE="production" -i EntireDB-production.sql > production.out
echo "Adding minimal database..."
/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P $SA_PASSWORD -d master -v MYDATABASE="minimal" -i EntireDB-minimal.sql > minimal.out
echo "Databases added"
sleep 1
echo "Shutting down the database..."
/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P $SA_PASSWORD -Q "SHUTDOWN"
sleep 1
echo "Done"

1
2
3
4

#!/bin/bash

# Start SQL Server with password reset to SQLSERVR_SA_PASSWORD
/opt/mssql/bin/sqlservr --reset-sa-password

1
2
3
4
5
6
7
8

FROM mono:6

ADD . /source
WORKDIR /source/DragonsSpine

RUN xbuild /p:Configuration=Debug DragonsSpine.sln

CMD [ "mono", "--debug", "bin/Debug/DragSpinExp.exe" ]

14
15
16
17
18

  <add key="UnderworldEnabled" value="False"/>
  <add key="NPCSkillGain" value="True"/>
<add key="SQL_CONNECTION" value="User ID='sa';Password='StrongPassw0rd';Initial Catalog='minimal';Data Source='tcp:sql,1433';Connect Timeout=15"/>
</appSettings>
<runtime>

15
16
17
18

  <add key="NPCSkillGain" value="True"/>
  <add key="SQL_CONNECTION"
    value="User ID='sa';Password='TempBadPassw0rd';Initial Catalog='TempDatabaseName';Data Source='tcp:sql,1433';Connect Timeout=15"/>
</appSettings>

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

#!/bin/bash

if [ -z "$SQLSERVR_SA_PASSWORD" ]; then
  echo "The SQLSERVR_SA_PASSWORD environment variable must be set to the password for the 'sa'"
  echo " user on the SQL server."
  exit 1
fi

if [ -z "$SQLSERVR_DB_NAME" ]; then
  echo "The SQLSERVR_DB_NAME environment variable must be set to name of the database on the SQL"
  echo " server to use for this instance of the game server."
  exit 1
fi

sed -i s/TempBadPassw0rd/$SQLSERVR_SA_PASSWORD/ bin/Debug/DragSpinExp.exe.config
sed -i s/TempDatabaseName/$SQLSERVR_DB_NAME/ bin/Debug/DragSpinExp.exe.config

mono --debug bin/Debug/DragSpinExp.exe

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

FROM mono:6

ADD . /source
WORKDIR /source/DragonsSpine

RUN xbuild /p:Configuration=Debug DragonsSpine.sln

# Grant permissions for our scripts to be executable
RUN chmod +x entrypoint.sh

# The entrypoint script relies on both SQLSERVR_SA_PASSWORD and SQLSERVR_DB_NAME environment
#  variables being set.
ENTRYPOINT ["./entrypoint.sh"]