Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[VS22] Full Setup Guide For Ketchup Files

Initiate Mage
Joined
Apr 2, 2021
Messages
3
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Server Verification Error.
Help please.
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums




Server Verification Error.
Help please
 
Initiate Mage
Joined
Apr 2, 2021
Messages
3
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Make sure the MSGVER matches source and server.
*AccountServer*
AddTail( -1, 1, "Ketchup V18 (VS19)", "127.0.0.1", 0, 1, 1000 );
AddTail( 1, 1, "Channel-1", "127.0.0.1", 1, 1, 1000 );
DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "sa"
DB_PWD_LOGIN "09213524123"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"
DB_PWD_LOG "09213524123"
MSG_VER "20100412"
TEST
SKIP_TRACKING
NOLOG

*loginserver*
DB "127.0.0.1" //
DB-ip-addressCore "127.0.0.1" //
Core-ip-address
AddCache("127.0.0.1");MSG_VER "20100412" // must match Neuz.exe, if not set default = "20100412"
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

*AccountServer*
AddTail( -1, 1, "Ketchup V18 (VS19)", "127.0.0.1", 0, 1, 1000 );
AddTail( 1, 1, "Channel-1", "127.0.0.1", 1, 1, 1000 );
DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "sa"
DB_PWD_LOGIN "09213524123"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"
DB_PWD_LOG "09213524123"
MSG_VER "20100412"
TEST
SKIP_TRACKING
NOLOG

*loginserver*
DB "127.0.0.1" //
DB-ip-addressCore "127.0.0.1" //
Core-ip-address
AddCache("127.0.0.1");MSG_VER "20100412" // must match Neuz.exe, if not set default = "20100412"

and kCommon.h must match as well.

This guide and these files work as long as you follow the guide just fine.
 
Initiate Mage
Joined
Apr 2, 2021
Messages
3
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

#define NEUZ_TITLE "Ketchup V18 (VS19)"
#define NEUZ_IPSET "127.0.0.1"
#define NEUZ_CPORT "5400"
#define NEUZ_BHASH "sunkist"#define NEUZ_PHASH "kikugalanet"
#define NEUZ_MSGVR "20100412"
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

#define NEUZ_TITLE "Ketchup V18 (VS19)"
#define NEUZ_IPSET "127.0.0.1"
#define NEUZ_CPORT "5400"
#define NEUZ_BHASH "sunkist"
#define NEUZ_PHASH "kikugalanet"
#define NEUZ_MSGVR "20100412"

Read the guide, do step by step and try again.
 
Skilled Illusionist
Joined
Apr 21, 2010
Messages
378
Reaction score
96
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Server Verification Error.
Help please.
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums




Server Verification Error.
Help please

1. My guide is proven to be successful if you follow it step by step
2. Why do you only post your configs as a responds? How selfish + extremely lazy...
3. I got a lot of info by just using Google: "Server Verification Error FlyFF" (again, extremely lazy...)
4. Delete everything and start my guide from the beginning..
 
Initiate Mage
Joined
Apr 6, 2021
Messages
2
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

So im using Ketchup VS2019's Files.. And like, theres no chatbox appearing at all.. How can i fix this ?
 
Skilled Illusionist
Joined
Apr 21, 2010
Messages
378
Reaction score
96
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

So im using Ketchup VS2019's Files.. And like, theres no chatbox appearing at all.. How can i fix this ?

Be more specific.

And this is a Guide thread. If you have problems with the files, go to that specific thread..
 
Initiate Mage
Joined
May 13, 2021
Messages
6
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

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

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

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

This guide has too many images, please download them
(they have corresponding names)
Pass: RageZone


Guide:

1. Install Visual Studio 2019 Community

Downloads:
Code:
[URL="https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&rel=16"]Visual Studio 2019 Community[/URL]
[URL="https://www.microsoft.com/en-us/download/details.aspx?id=35"]DirectX 9[/URL]

1.1 Download the VS2019 Community and DirectX 9 files

1.2 Install DirectX 9

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

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

Downloads:
Code:
[URL="https://www.microsoft.com/en-us/Download/details.aspx?id=101064"]SQL Server 2019 Express[/URL]
[URL="https://aka.ms/ssmsfullsetup"]SQL Server Management Studio[/URL]
[URL="https://www.microsoft.com/en-us/download/details.aspx?id=36434"]SQL Native Client 11[/URL]

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

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

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

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

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

3.1 Opening .sln file for the first time

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

4.1 Compile source all at once

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

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)

5.1 Configure resource .ini files

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

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

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

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)

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

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)

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)

8.1 General

8.1.1
8.1.2 Write down your WAN-IP (ipv4)

8.2 Resource

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

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

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

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

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!


Thank you for this Wonderful Guide Mr. Groxy101

anyhow, I am a noob creating a Private server for just only me and my pals.

Could you teach me how to create an account for them using SQL?
I tried to make an account for them with SQL tutorials that I found but whenever I try to login, the game says "Log in details incorrect, Please Try again."

Appreciate your help!
 
Initiate Mage
Joined
May 13, 2021
Messages
6
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

The Salt for This Tutorial is Sunkist right??
 
Initiate Mage
Joined
May 13, 2021
Messages
6
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Thank you Very Much Mr. Ketchup Appreciate all your work.:lol:



One Last Question if you don't mind,


I noticed that the Arrow that guide you to quests does not work, some of my friends are new to this game and this will be a big help for them. any Idea how to fix this one? I know this is asking a lot but, could you help out a newbie? I'm not taking profit because of this, it's just a way for me and the pals to play privately and relieve stress from work, we are a total of 12 players in my newly opened server..
 
Experienced Elementalist
Joined
Jan 7, 2020
Messages
257
Reaction score
97
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Thank you Very Much Mr. Ketchup Appreciate all your work.:lol:



One Last Question if you don't mind,


I noticed that the Arrow that guide you to quests does not work, some of my friends are new to this game and this will be a big help for them. any Idea how to fix this one? I know this is asking a lot but, could you help out a newbie? I'm not taking profit because of this, it's just a way for me and the pals to play privately and relieve stress from work, we are a total of 12 players in my newly opened server..
This is a common problem you will find in every flyff sources around the internet. At this moment there is no public fix for it So either you find a way to fix it or you just ignore it.
 
Initiate Mage
Joined
May 15, 2021
Messages
10
Reaction score
1
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

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

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

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

This guide has too many images, please download them
(they have corresponding names)
Pass: RageZone


Guide:

1. Install Visual Studio 2019 Community

Downloads:
Code:
[URL="https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&rel=16"]Visual Studio 2019 Community[/URL]
[URL="https://www.microsoft.com/en-us/download/details.aspx?id=35"]DirectX 9[/URL]

1.1 Download the VS2019 Community and DirectX 9 files

1.2 Install DirectX 9

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

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

Downloads:
Code:
[URL="https://www.microsoft.com/en-us/Download/details.aspx?id=101064"]SQL Server 2019 Express[/URL]
[URL="https://aka.ms/ssmsfullsetup"]SQL Server Management Studio[/URL]
[URL="https://www.microsoft.com/en-us/download/details.aspx?id=36434"]SQL Native Client 11[/URL]

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

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

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

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

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

3.1 Opening .sln file for the first time

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

4.1 Compile source all at once

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

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)

5.1 Configure resource .ini files

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

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

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

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)

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

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)

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)

8.1 General

8.1.1
8.1.2 Write down your WAN-IP (ipv4)

8.2 Resource

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

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

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

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

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!

Hi, Newbie here.
I have directX12. Do I still need the directX9 for it to work?



I have downloaded everything and follow all steps.
Everything is working fine. thank you!



I have downloaded everything and follow all steps.
Everything is working fine. thank you!



Hi, I'm back with a newb question xD

I've been trying to look for the answer of this 'cause it's so shameful for asking a lot of questions from you guys. I know that Y'all are busy but I just can't find the solution :-(

How can I change the Neuz title or the server name or even put a logo if it's not too much to ask? I found something like
#define NEUZ_TITLE "ketchup v15 vs19" in kCommon.h and changed the name inside the quote and quote into something then saved it but nothing has changed. also tried doing a full rebuild on all.sln but still nothing has changed xD. I know this is a no brainer for some but I really have a hard time here. anyone's help is much appreciated.
 
Experienced Elementalist
Joined
Jan 7, 2020
Messages
257
Reaction score
97
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Hi, Newbie here.
I have directX12. Do I still need the directX9 for it to work?



I have downloaded everything and follow all steps.
Everything is working fine. thank you!



I have downloaded everything and follow all steps.
Everything is working fine. thank you!



Hi, I'm back with a newb question xD

I've been trying to look for the answer of this 'cause it's so shameful for asking a lot of questions from you guys. I know that Y'all are busy but I just can't find the solution :-(

How can I change the Neuz title or the server name or even put a logo if it's not too much to ask? I found something like
#define NEUZ_TITLE "ketchup v15 vs19" in kCommon.h and changed the name inside the quote and quote into something then saved it but nothing has changed. also tried doing a full rebuild on all.sln but still nothing has changed xD. I know this is a no brainer for some but I really have a hard time here. anyone's help is much appreciated.
Neuz title is set inside the "kCommon.h"
Code:
#define NEUZ_TITLE	"TEXT HERE"
You have recompile to make the changes inside the game. Plus this is a guide section if you have any question you can ask here: https://forum.ragezone.com/f483/
 
Initiate Mage
Joined
May 15, 2021
Messages
10
Reaction score
1
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Neuz title is set inside the "kCommon.h"
Code:
#define NEUZ_TITLE    "TEXT HERE"
You have recompile to make the changes inside the game. Plus this is a guide section if you have any question you can ask here: https://forum.ragezone.com/f483/

Ohh, ok. thanks! will post a new thread next time :)

I've successfully changed the neuz title. thanks mucho :)
 
Initiate Mage
Joined
Mar 10, 2017
Messages
2
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

:$::blink:A:\DOWNLOAD FILES\K18\K18\Source\Source\_database\DbManager.cpp, 2247 LogDB Connect

anyone can help me ?

when i open 3. Database.exe always
Groxy101 - [VS22] Full Setup Guide For Ketchup Files - RaGEZONE Forums
 
Initiate Mage
Joined
Mar 10, 2017
Messages
2
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

i fix this problem :)
everything is working from 1. account.exe to 7.world.exe no errors
but i have 1 last problem im stock at select channel , i click create character then im stock there then i restart my client then im stock now in select channel.

update : when i create character (Name Already In Use )
what should i do
 
Last edited:
Initiate Mage
Joined
Sep 11, 2021
Messages
4
Reaction score
0
Re: [FULL SETUP GUIDE] Ketchup VS2019 files

Hi, i'm trying to run the server, without any kind of modifications.
AccountServer and Certifier are running fine, but i cant run the DatabaseServer
When i try to start it, it not start, and no error...
Can somebody help me please?
 
Back
Top