[FULL SETUP GUIDE] Ketchup VS2019 files

[Groxy101]

This full setup guide is made for the VS2019 files from Ketchup (both K15/K18 will work).

[VS19] V15 - Tested & Fully Working.
[VS19] V18 Files (Retail Content & V19 Formats)

Installing on Windows 10 (will also work on server 2016/2019)

This guide has too many images, please download them HERE - updated 12-2-2020
(they have corresponding names)
Pass: RageZone


Guide:

1. Install Visual Studio 2019 Community

Spoiler:

Downloads:

Visual Studio 2019 Community
DirectX 9

1.1 Download the VS2019 Community and DirectX 9 files

1.2 Install DirectX 9

Spoiler:

1.2.1 Right click the "dxwebsetup.exe" file and "Run as administrator"
1.2.2 Click "I accept the agreement" and click "Next"
1.2.3 Uncheck "Install the Bing bar" and click "Next"
1.2.4 Click "Next"
1.2.5 Wait untill download & install is finished
1.2.6 click "Finish"

1.3 Install Visual Studio 2019 Community

Spoiler:

1.3.1 Right click the "vs_community_*.exe" file and "Run as administrator"
1.3.2 Click "Continue"
1.3.3 Wait untill download & install is finished
1.3.4 Select ".NET desktop development" & "Desktop development with C++" and
CHECK "C++ MFC for latest v142 build tools (x86 & x64)"
UNCHECK "Test Adapter for Boost.Text", "Test Adapter for Google Test", "Live Share"
Check the image below to check if you selected everything!!!
Click "Install"
1.3.5 Uncheck "Start after installation" and wait untill download & install is finished
1.3.6 When you see the "Installation succeeded!" window, you can close it (Don't start Visual Studio!)

2. Install/Configure SQL Server 2019 & Management

Spoiler:

Downloads:

SQL Server 2019 Express
SQL Server Management Studio
SQL Native Client 11

2.1 Download the Server 2019 Express, Management Studio & Native Client 11 files

2.1.1 Select the "ENU\x64\msodbcsql.msi" file (Native Client 11)

2.2 Install SQL Native Client 11

Spoiler:

2.2.1 Right click the "msodbcsql.msi" file and "Install"
2.2.2 Click "Next"
2.2.3 Click "I accept the terms in the license agreement" and click "Next"
2.2.4 At "ODBC Driver for SQL Server SDK" click the dropdown icon and select "Will be installed on local hard drive" and click "Next"
2.2.5 Click "Install"
2.2.6 Click "Finish"
2.2.7 Restart your computer

2.3 Install Server 2019 Express

Spoiler:

2.3.1 Right click the "SQL2019-SSEI-Expr.exe" file and "Run as administrator"
2.3.2 Select the "Custom" installation
2.3.3 Click "Install"
2.3.4 Wait untill download & install is finished
2.3.5 Click "New SQL Server stand-alone installation or add features to an existing installation"
2.3.6 Check "I accept the license terms and Privacy Statement" and click "Next"
2.3.7 Click "Next"
2.3.8 Wait untill all tasks are completed
2.3.9 Ignore the "Windows Firewall" warning for now and click "Next" (disabling your Firewall is NOT RECOMMENDED!)
2.3.10 Leave the default "Instance Features" and click "Next"
2.3.11 Leave the default "Named instance" as "SQLExpress" and click "Next"
2.3.12 Click "Next"
2.3.13 Click "Next"
2.3.14 Select "Mixed Mode" and type a secure password (write this password down) + confirm and click "Next" (don't delete the "Specify SQL Server Administrators", I have mine removed from the screenshot only!)
2.3.15 Click "Accept" and click "Next"
2.3.16 Click "Accept" and click "Next"
2.3.17 Wait untill the installation is finished
2.3.18 Click "Close" after checking every status is "Succeeded" (details showing: Install successful)

2.4 Install Server Management Studio

Spoiler:

2.4.1 Right click the "SSMS-Setup-ENU.exe" file and "Run as administrator"
2.4.2 Click "Install"
2.4.3 Wait untill download & install is finished
2.4.4 When finished, click "Close"

2.5 Configure SQL server

Spoiler:

2.5.1 Open "Microsoft SQL Server Management Studio 18"
2.5.2 Select Authentication: "SQL Server Authentication", Login: "sa", Password: "The secure password you wrote down", check "Remember password" and click "Connect"

2.5.3 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.4 Go to the Ketchup database folder (K18\Database) and select "- Edit Me Before Executing.sql" click "Open"
2.5.5 Change "DESKTOP-SH6G9M7" to your own computer name (Right click Windows button, System, Device name)
2.5.6 Click "Execute"

2.5.7 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.8 Go to the Ketchup database folder (K18\Database) and select "1. Database.sql" click "Open"
2.5.9 Click "Execute"

2.5.10 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.11 Go to the Ketchup database folder (K18\Database) and select "2. Deadlock.sql", click "Open"
2.5.12 Click "Execute"

2.5.13 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.14 Go to the Ketchup database folder (K18\Database) and select "3. Account.sql", click "Open"
2.5.15 Click "Execute"

2.5.16 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.17 Go to the Ketchup database folder (K18\Database) and select "4. Ranking.sql", click "Open"
2.5.18 Click "Execute"

2.5.19 Close "Microsoft SQL Server Management Studio 18" (Click NO, for not saving the .sql files)

2.5.20 Open "ODBC Data Sources (32-bit)" as Administrator

2.5.21 Click "Add"
2.5.22 Scroll all the way down, select "SQL Server Native Client 11.0" and click "Finish"
2.5.23 Name: character01 / Server: YOURCOMPUTERNAME\SQLEXPRESS click "Next"
2.5.24 Select "With Integrated Windows authentication" and click "Next"
2.5.25 Check "Change the default database to:" select "CHARACTER_01_DBF" and click "Next"
2.5.26 Click "Finish"
2.5.27 Click "Test Data Source"
2.5.28 It has to say "TESTS COMPLETED SUCCESSFULLY!" and click "OK"
2.5.29 Click "OK"

2.5.30 Click "Add"
2.5.31 Scroll all the way down, select "SQL Server Native Client 11.0" and click "Finish"
2.5.32 Name: log01 / Server: YOURCOMPUTERNAME\SQLEXPRESS click "Next"
2.5.33 Select "With Integrated Windows authentication" and click "Next"
2.5.34 Check "Change the default database to:" select "LOGGING_01_DBF" and click "Next"
2.5.35 Click "Finish"
2.5.36 Click "Test Data Source"
2.5.37 It has to say "TESTS COMPLETED SUCCESSFULLY!" and click "OK"
2.5.38 Click "OK"

2.5.39 Click "Add"
2.5.40 Scroll all the way down, select "SQL Server Native Client 11.0" and click "Finish"
2.5.41 Name: login / Server: YOURCOMPUTERNAME\SQLEXPRESS click "Next"
2.5.42 Select "With Integrated Windows authentication" and click "Next"
2.5.43 Check "Change the default database to:" select "ACCOUNT_DBF" and click "Next"
2.5.44 Click "Finish"
2.5.45 Click "Test Data Source"
2.5.46 It has to say "TESTS COMPLETED SUCCESSFULLY!" and click "OK"
2.5.47 Click "OK"

2.5.48 Click "Add"
2.5.49 Scroll all the way down, select "SQL Server Native Client 11.0" and click "Finish"
2.5.50 Name: ranking / Server: YOURCOMPUTERNAME\SQLEXPRESS click "Next"
2.5.51 Select "With Integrated Windows authentication" and click "Next"
2.5.52 Check "Change the default database to:" select "RANKING_DBF" and click "Next"
2.5.53 Click "Finish"
2.5.54 Click "Test Data Source"
2.5.55 It has to say "TESTS COMPLETED SUCCESSFULLY!" and click "OK"
2.5.56 Click "OK"

2.5.57 Close the ODBC window (click "OK")

3. How to open source files

Spoiler:

3.1 Opening .sln file for the first time

Spoiler:

3.1.1 Go to the Ketchup Source "All" folder (K18\Source\Source\All) and open "all.sln"
3.1.2 In the "How do you want to open this file?" select "Visual Studio 2019", check "Always use this app to open .sln files" and click "OK"
3.1.3 Make sure to Create an Account and sign in to Visual Studio
3.1.4 Select your "color theme" (I always set it to "Dark" mode) and click "Start Visual Studio"
3.1.5 Wait until Visual Studio is done preparing for first use
3.1.6 When Visual Studio is done preparing it should open the source (check right side, AccountServer, CacheServer, etc)

4. How to compile source

Spoiler:

4.1 Compile source all at once

Spoiler:

4.1.1 Follow the 3.1 steps and open your source in Visual Studio
4.1.2 Right click "Solution 'all' (8 of 8 projects)" and select "Batch Build.."
4.1.3 Click "Rebuild" and wait until the build is done
4.1.4 Check if "Rebuild All: 8 succeeded" (NOTE: The clean source will always compile "8 succeeded")
4.1.5 Don't forget to run the "-Move Compiles.bat" file (in the K18 root folder)

4.2 Compile source separate

Spoiler:

4.2.1 Follow the 3.1 steps and open your source in Visual Studio
4.2.2 Right click a specific server (or Neuz) and click "Rebuild"
4.2.3 Wait until the rebuild is done (shouldn't take long because it's only building 1 .exe file)
4.2.4 Check if "Rebuild All: 1 succeeded"
4.2.5 Don't forget to run the "-Move Compiles.bat" file (in the K18 root folder)

5. How to setup your server (Resource + Source)

Spoiler:

5.1 Configure resource .ini files

Spoiler:

5.1.1 Open your Program folder (K18\Server\Program)
5.1.2 Open the "AccountServer.ini" file
5.1.3 Change "PASS" to your own SQL password (DB_PWD_LOGIN/DB_PWD_LOG)
5.1.4 Save the file
5.1.5 Open the "Certifier.ini" file
5.1.6 Change "PASS" to your own SQL password
5.1.7 Save the file
5.1.8 Open your Script folder (K18\Server\Script)
5.1.9 Open the "DatabaseServer.ini" file
5.1.10 Change "PASS" to your own SQL password (DB_PWD_CHARACTER/DB_PWD_LOG)
5.1.11 Save the file

5.2 Use merger program

Spoiler:

5.2.1 Open your Resource folder (K18\Server\Resource)
5.2.2 Run the "- Merge.exe" program
5.2.3 Open your ResClient folder (K18\Server\ResClient)
5.2.4 Copy all files (data.res, dataSub1.res, dataSub2.res, Flyff.a)
5.2.5 Open your Client folder (K18\Client)
5.2.6 Paste the files (3x .res file + Flyff.a) into the client folder (Replace the files in the destination)

This merge has to be done every time you change something in the RESOURCE folder!

5.3 Starting your server

Spoiler:

5.3.1 Open your Program folder (K18\Server\Program)
5.3.2 Right click "1. Account.exe" and click "Run as Administrator"
5.3.3 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.4 The Account server is now running

5.3.5 Right click "2. Certifier.exe" and click "Run as Administrator"
5.3.6 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.7 The Certifier server is now running

5.3.8 Open your Resource folder (K18\Server\Resource)
5.3.9 Right click "3. Database.exe" and click "Run as Administrator"
5.3.10 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.11 The Database server is now running

5.3.12 Open your Program folder (K18\Server\Program)
5.3.13 Right click "4. Core.exe" and click "Run as Administrator"
5.3.14 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.15 The Core server is now running

5.3.16 Right click "5. Login.exe" and click "Run as Administrator"
5.3.17 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.18 The Login server is now running

5.3.19 Right click "6. Cache.exe" and click "Run as Administrator"
5.3.20 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.21 The Cache server is now running

5.3.22 Open your Resource folder (K18\Server\Resource)
5.3.23 Right click "7. World.exe" and click "Run as Administrator"
5.3.24 Check also "Private Networks, such as my home.." and click "Allow access"
5.3.25 Leave the World Server on "Not responding"
5.3.26 After about 30 seconds (depending on your computer) the World server is running

5.3.27 Open your Client folder (K18\Client) and run "- Start Game.bat"
5.3.28 Your Neuz will now load - login with Account: test / Password: test
5.3.29 Make a new character
5.3.30 Login, have fun playing!

6. Change Visual Studio settings for debugging Neuz

Spoiler:

6.1 Open Visual Studio 2019 and select the "all.sln" file
6.2 Right click your "Neuz" solution and click "Properties"
6.3 On the left side, go to the "Debugging" tab
6.4 Change "Command Arguments" to "sunkist" / "Working Directory" to your "K18\Client" folder / "Debugger Type" to "Native Only" and click "Apply"

7. How to debug server files (new instance or attach debug)

Spoiler:

7.1 Running a new instance (start a new debug from Visual Studio)

Spoiler:

World Server debug example

7.1.1 Run all your server .exe files except for the Worldserver (don't start the Worldserver)
7.1.2 Open your Server folder (K18\Server)
7.1.3 Copy your "Script" folder
7.1.4 Open your Source folder (K18\Source\Source)
7.1.5 Paste your "Script folder" into the Source folder (Source\Source)
7.1.6 Open the Script folder (K18\Source\Source\Script)
7.1.7 Open the "WorldServer.ini" file
7.1.8 Change the "ResourceFolder" to your Resource path (C:\Users\*\Desktop\K18\Server\Resource)
7.1.9 Open Visual Studio 2019 and select the "all.sln" file
7.1.10 Right click "WorldServer" solution and select "Debug", "Start New Instance"
7.1.11 Your WorldServer will now start in debug mode. If it crashes, you will get a debug log

7.2 Running an attached debug (debug an already running proces)

Spoiler:

World Server debug example

7.2.1 Run all your server files (also WorldServer)
7.2.2 Open Visual Studio 2019 and select the "all.sln" file
7.2.3 At the top, go to "Debug" and select "Attach to Process.."
7.2.4 Select the "7. World.exe" process and click "Attach"
7.2.5 Select "Restart under different credentials" (Visual Studio will restart)
7.2.6 At the top, go to "Debug" and select "Attach to Process.."
7.2.7 Select the "7. World.exe" process and click "Attach"
7.2.8 Visual Studio is now debugging the running WorldServer process

8. How to make your server public (and change default ports)

Spoiler:

8.1 General

Spoiler:

8.1.1 Find out what your WAN-IP is
8.1.2 Write down your WAN-IP (ipv4)

8.2 Resource

Spoiler:

8.2.1 Open your Resource folder (K18\Server\Program)
8.2.2 Open the "AccountServer.ini" file
8.2.3 Change BOTH "127.0.0.1" to your "WAN-IP" and save the file
8.2.4 Open the "CacheServer.ini" file
8.2.5 Change the default Cache port "5400" to something else (between 1024 to 49151) - DON'T CHANGE THE 127.0.0.1
8.2.6 Write down the new Cache port and save the file
8.2.7 Open the "Loginserver.ini" file
8.2.8 Change the "AddCache(127.0.0.1);" to your "WAN-IP" and save the file - DON'T CHANGE THE OTHER 127.0.0.1

8.3 Source

Spoiler:

8.3.1 Go to the Ketchup Source "All" folder (K18\Source\Source\All) and open "all.sln"
8.3.2 Open the file "kCommon.h" in the Solution Items tab
8.3.3 Scroll down and change NEUZ_IPSET "127.0.0.1" to your "WAN-IP" (you could also change it to your domain name)
8.3.4 Also change the NEUZ_CPORT "5400" to the port you have set in step 8.2.5
8.3.5 Press CTRL + SHIFT + F and search for "23000" (Find All)
8.3.6 There is only one search result, double click that one
8.3.7 Change the "PN_CERTIFIER 23000" to something else (between 1024 to 49151) - NOT THE SAME AS THE CACHE PORT AND TRY TO NOT HAVE THE SAME IN THE PORT LIST (msghdr.h)
8.3.8 Write down the port you just changed (This is the Certifier server port)
8.3.9 On line 1456 (in the same area) you will find "PN_LOGINSRVR 28000"
8.3.10 Change this port (28000) to something else (between 1024 to 49151) - NOT THE SAME AS THE CACHE PORT AND TRY TO NOT HAVE THE SAME IN THE PORT LIST (msghdr.h)
8.3.11 Write down the port you just changed (This is the Login server port)
8.3.12 Save the "msghdr.h" and "kCommon.h" file
8.3.13 Use step 4 to compile the source and copy the .exe files to the right folders

8.4 Firewall

Spoiler:

8.4.1 Open "Windows Defender Firewall with Advanced Security"
8.4.2 Go to "Inbound Rules" and click "New Rule.." on the right side
8.4.3 Select "Port" and click "Next"
8.4.4 In "Specific local ports:" add the three ports you wrote down (Cache, Cert, Login) and click "Next"
8.4.5 Click "Next" again
8.4.6 Click "Next" again
8.4.7 Give it a name and click "Finish"

8.5 Portforward

Spoiler:

NOTE: If you are using a VPS, this step is not needed (you only have to open the ports in the VPS firewall)

8.5.1 Open the Windows 10 "Command Prompt" window
8.5.2 Type: ipconfig
8.5.3 Write down the "Default Gateway" IP-address
8.5.4 Open your browser and go this Default Gateway IP-address (your Router)
8.5.5 Log into your router (most of the time it's: admin/admin, but check your router, and change the admin/admin login... security risk..)
8.5.6 Go to the Forwarding menu in your router (mine is a TP-Link, yours might be a different one)
8.5.7 Click on "Add New..."
8.5.8 Add your CHANGED ports to the new entry (the service/internal ports have to be the same) - YOU NEED TO MAKE A NEW ENTRY FOR EVERY PORT!
8.5.9 IP-address = the computer your hosting it on (check Command Prompt: ipconfig)
8.5.10 Protocol = TCP
8.5.11 Click save (Don't forget to add all the ports) - CACHE/CERT/LOGIN

8.6 Run the server

Spoiler:

8.6.1 Run your .exe files as shown in step 5.3
8.6.2 Upload your CLIENT folder and give it to friends

QUESTIONS?
As you can see I used specific numbers for the Guide steps.
If you have any questions, please use those specific numbers in your post!

[MentaL_BOT]

[Ketchup]

Great guide, thanks for your contribution!

I'm sure this will help quite a bit of people.

[Percuflex]

What a great guide and Great job !
Thank you :)

[TheSoySauce]

a well made guide! thank you!

[seriousone]

Awesome guide, thank you! Anxiously waiting for the final piece.

[Groxy101]

Awesome guide, thank you! Anxiously waiting for the final piece.

Added the final piece - Enjoy

8. How to make your server public (and change default ports)
Don't forget to download the new images!

[sasuke]

Added the final piece - Enjoy

8. How to make your server public (and change default ports)
Don't forget to download the new images!

can anyone give me the directx9 the download link is dead

[Ketchup]

can anyone give me the directx9 the download link is dead

https://download.cnet.com/DirectX-9-...-77507663.html

[sasuke]

@Ketchup thanks bro

what directive do we install for windows 10 pro?

[Ketchup]

@Ketchup thanks bro

what directive do we install for windows 10 pro?

Sorry just noticed that, use this one attached instead.

[sasuke]

@Ketchup thanks

[Stromacube]

Hi

i opened all.sln in VS but everytime i try to rebuild in batch build i get all failed and errors with afxwin.h and some like these , do you have a solution ?

[Ketchup]

Hi

i opened all.sln in VS but everytime i try to rebuild in batch build i get all failed and errors with afxwin.h and some like these , do you have a solution ?

You don't need to batch build with my source.

Simply extract it, right click All and hit Build.

[Stromacube]

yeah i did it thank you ,

[Bombsy]

I keep getting this error while trying to build the solutions. Can someone please help?

Severity Code Description Project File Line Suppression StateError C1083 Cannot open include file: 'afxwin.h':

I tried to right click all and hit build but i get the same error.