Most visitors online was 10387 , on 26 Apr 2024
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!Server Verification Error.
Help please.
Server Verification Error.
Help please
*AccountServer*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"
#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"
Server Verification Error.
Help please.
Server Verification Error.
Help please
So im using Ketchup VS2019's Files.. And like, theres no chatbox appearing at all.. How can i fix this ?
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 themYou must be registered to see links
(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.1You must be registered to see links
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!
The Salt for This Tutorial is Sunkist right??
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.Thank you Very Much Mr. Ketchup Appreciate all your work.
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 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 themYou must be registered to see links
(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.1You must be registered to see links
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!
Neuz title is set inside the "kCommon.h"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.
#define NEUZ_TITLE "TEXT HERE"
Neuz title is set inside the "kCommon.h"
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/Code:#define NEUZ_TITLE "TEXT HERE"