Refloating: [VS22] Full Setup Guide For Ketchup Files

Graymer · Jun 1, 2024

This is a refloat of the Guide to make a Flyff Private server from Ketchup, that had been lost and fallenfate found digging.

To view the content, you need to sign in or register

Also let me share THE youtube video that as of now, is a visual tutorial of how to setup the server from Spidpex
I hope everyone finds this thread helpful.
The links in this post do not work for me (google errors) but if they do for you, please share the files or reupload them.

This guide is specifically made for the following files only:

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

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

This guide has too many images, please download them
To view the content, you need to sign in or register

(they have corresponding names)
Pass: RageZone
Guide:
1. Install Visual Studio 2022 Community
Spoiler:
Downloads:
Code:

To view the content, you need to sign in or register

To view the content, you need to sign in or register

1.1 Download the VS2022 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 2022 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:
Code:

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

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 until 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.7 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.8 Go to the Ketchup database folder (K15-VS22\Database) and select "1. Database.sql" click "Open"
2.5.9 Click "Execute"
2.5.13 Top left, click "File", click "Open", click "File.." (CTRL+O)
2.5.14 Go to the Ketchup database folder (K15-VS22\Database) and select "2. Account (Optional).sql", click "Open"
2.5.15 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.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 (K15-VS22\Source\Source\All) and open "all.sln"
3.1.2 In the "How do you want to open this file?" select "Visual Studio 2022", 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 K15-VS22 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 K15-VS22 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 (K15-VS22\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 (K15-VS22\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 (K15-VS22\Server\Resource)
5.2.2 Run the "- Merge.exe" program
5.2.3 Open your ResClient folder (K15-VS22\Server\ResClient)
5.2.4 Copy all files (data.res, dataSub1.res, dataSub2.res, Flyff.a)
5.2.5 Open your Client folder (K15-VS22\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 (K15-VS22\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 (K15-VS22\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 (K15-VS22\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 (K15-VS22\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 (K15-VS22\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 2022 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 "K15-VS22\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 (K15-VS22\Server)
7.1.3 Copy your "Script" folder
7.1.4 Open your Source folder (K15-VS22\Source\Source)
7.1.5 Paste your "Script folder" into the Source folder (Source\Source)
7.1.6 Open the Script folder (K15-VS22\Source\Source\Script)
7.1.7 Open the "WorldServer.ini" file
7.1.8 Change the "ResourceFolder" to your Resource path (C:\Users\*\Desktop\K15-VS22\Server\Resource)
7.1.9 Open Visual Studio 2022 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 2022 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
To view the content, you need to sign in or register

8.1.2 Write down your WAN-IP (ipv4)
8.2 Resource
Spoiler:
8.2.1 Open your Resource folder (K15-VS22\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 (K15-VS22\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!

Ron · Jun 20, 2024

I checked all the related posts. All links are already dead, they won't work for anyone. He scrubbed everything.

The effort is appreciated, but unless someone has working download links, this thread is useless and should not be a sticky. Stickies need to have working links.

Graymer · Jun 20, 2024

Thanks for the complain and 0 help.

At least now we have the tutorial and the files needed, in case someone has them
To me the links work, source only on Github. Google Drive does give an error.
The video is updated and contains all the files necessary on
To view the content, you need to sign in or register
Some if not all the video files are V15, same as the first link of the post
To view the content, you need to sign in or register

I see that you are a member for almost 20 years, maybe you can chip in with some files?

Ron · Jun 20, 2024

For context, this thread was marked as a Sticky when I first replied.

Graymer said:
Thanks for the complain and 0 help.

At least now we have the tutorial and the files needed, in case someone has them

To me the links work, source only on Github. Google Drive does give an error.

The video is updated and contains all the files necessary on
To view the content, you need to sign in or register

Some if not all the video files are V15, same as the first link of the post
To view the content, you need to sign in or register

I see that you are a member for almost 20 years, maybe you can chip in with some files?

A tutorial for files no one is posting here is useless.

I have nothing to post in FlyFF. I'm invested in other games. I can't do them all even though I want to.

I am just tired of seeing everyone posting content with dead links all over the forum. I am also tired of mods marking threads as stickies with broken links/unusable/incomplete files.

Work with people to get the files, clean them, and release them, before you waste time re-posting a guide that no one here can use.

Y'all complain about "real developers" not wanting to help, but then you post threads like this. And then mods sticky them on top.

If you want to rebuild the section, post content people can actually use. Post something of your own. Stop copy/pasting other peoples' threads and not actually contributing anything towards solving the actual problem this section is currently facing.

Get the files, make a guide, make sure the content you post people are actually able to consume. Otherwise what is the point of your post?

Nothing.

Edit-
Ketchup's content is gone, he chose to take it with him. Stop trying to keep it alive and go start something new instead. FlyFF doesn't need everyone reposting Ketchup's content with dead or partial download links. FlyFF needs someone to step up and build new content around information that is actually accessible.