NPC Script Recruit Guild - Help me!

[feehcarvalhoce]

Hi friends, I'm making an NPC for the player to see a list of Guilds on the server and choose one to apply to, but when I try to force him to register the player in SQL in the guild_member, it doesn't count, the player can't join the guild . Can anyone give me this support?

 

Script:

 

caspen,107,190,5    script    Guild Recruitment    4_F_SON,{
    // Variables
    set .@gname$, "";
    set .@gcount, 0;

    // Check if the player is already in a guild
    if (getcharid(2) != 0) {
        mes "^FF0000[Guild Recruitment]^000000";
        mes "You are already part of a guild. Please leave your current guild before creating a new one.";
        close;
    }

    // Welcome message
    mes "^FF0000[Guild Recruitment]^000000";
    mes "Welcome to the recruitment system!";
    next;
    mes "^FF0000[Guild Recruitment]^000000";
    mes "Here you can request to join one of the guilds.";
    next;

    // SQL query to get guild names
    query_sql "SELECT g.name FROM `guild` g", .@gname$;

    // Check if any guilds were found
    if (.@gname$ == "") {
        mes "^FF0000[Guild Recruitment]^000000";
        mes "No guilds found.";
    } else {
        mes "^FF0000[Guild Recruitment]^000000";
        mes "Available guilds:";

        // Display guild names
        for (set .@i, 0; .@i < getarraysize(.@gname$); set .@i, .@i + 1) {
            mes "- " + .@gname$[.@i];
            set .@gcount, .@gcount + 1;
        }

        // Ask for player's choice
        mes "Enter the number of the guild to request an invitation:";
        input .@gchoice, 1, .@gcount;

        if (.@gchoice < 1 || .@gchoice > .@gcount) {
            mes "Invalid choice.";
        } else {
            // Send invitation to the chosen guild
            set .@selectedGuild$, .@gname$[.@gchoice - 1];
            mes "You have requested an invitation to the guild: " + .@selectedGuild$;

            // Sending the invitation (replace with correct logic)
            // Here, you should have the logic to find the guild master
            set .@guildId, query_sql("SELECT id FROM `guild` WHERE name = '" + .@selectedGuild$ + "' LIMIT 1");

            // If the guild exists, send the invitation
            if (.@guildId) {
                // Example of inviting the guild master
                // guild_invite(getmasterid(.@guildId), getcharid(0));
                query_sql("INSERT INTO guild_member (guild_id, char_id, account_id, exp, position, online, lv, class, name, hair, hair_color, clothes_color, body, head_top, head_mid, head_bottom, shield, weapon, robe, last_login, memo, membersonline, fame) VALUES (" + .@guildId + ", " + getcharid(0) + ", " + getcharid(3) + ", 0, 0, 0, " + baselevel + ", " + class + ", '" + escape_sql(strcharinfo(0)) + "', " + hair + ", " + haircolor + ", " + clothcolor + ", 0, " + readparam(8) + ", " + readparam(9) + ", " + readparam(10) + ", 0, 0, 0, NOW(), '', 0, 0)");
            } else {
                mes "Error sending the invitation. Guild not found.";
            }
        }
    }

    close;
}

[Magnetix]

Won't this breach the privacy of a guild if anyone is allowed to join?

To answer your question, you shouldn't modify data in the database directly if the char/account/party/guild are loaded by the server. You can, however, do this by modifying the source. I don't know if one exist but you can create a script command that will remotely invoke the normal way of joining a guild and use them in your script.