Guild Script

[rans]

Can i Request for a npc script that will invite you to a certain guild 
for example four guild

Upon on 1st login there will be 4 npc (4 guild)
you will choose which NPC or guild you want to join.
..

Also a npc that will change your guild (if you want to move on another guild) - disabled during woe time
 

Edited July 24, 2014 by Ako si Ranz

[Thanna20]

On 8/12/2014 at 10:23 AM, Emistry said:

it would be better to use source mod.

http://upaste.me/648510601a30ea563

 

try change

map->       // map_
guild->     // guild_

Hello sir, can I request a mirror of this source. upaste.me is on maintenance for about 3 days now.

Thank you.

[Normynator]

I tried to make a working script. but I still have the problem that I have to restart the server the make it work but i am still working on the problem

prontera,155,160,5	script	Guild	70,{
	mes "Join Guild!";
	if(select("Join:Cancel") -1) end;
	mes getcharid(3);
	mes getcharid(0);
	mes strcharinfo(0);
	next;
	atcommand "@kick "+strcharinfo(0);
	query_sql("INSERT INTO `guild_member` (guild_id, account_id, char_id, position, name) VALUES ('1', "+getcharid(3)+", "+getcharid(0)+", '1', '"+strcharinfo(0)+"')");
	query_sql("UPDATE `rathena`.`char` SET `guild_id` = '1' WHERE `char`.`char_id` = "+getcharid(0));
	end;
}

This is not the requested script but maybe you like it too.

The script lists all guilds and tell the guildmembers if some1 wants to join.

//by Normynator

prontera,155,160,5    script    Guild    70,{

function makeCategory;
function guildMember;    

    query_sql("SELECT guild_id FROM `guild`", @id$);    
    for([email protected] = 0; [email protected] < getarraysize(@id$); [email protected]++){
        dispbottom @id$[[email protected]];
    }
        
    mes "[Guild Joiner]";
    mes "Which Guild do you want to join?";
    set [email protected],select(makeCategory()) -1;
    next;
    
    mes "You selected: " + @gl$[[email protected] -1];
    mes "Do you want to join this Guild?";
    if(select("Yes:No") -1) end;
    next;
    
    mes "The Npc sent a request to the Guild";
    query_sql("SELECT name FROM `guild_member` WHERE guild_id = "+ @id$[[email protected] - 1], @m$);
    for([email protected] = 0; [email protected] < getarraysize(@m$); [email protected]++){
        //dispbottom @m$[[email protected]];
        message @m$[[email protected]], "Player "+  strcharinfo(0)+ " wants to Join your Guild!";
        set @m$[[email protected]], "";
    }
    end;
    
    function makeCategory {
        set [email protected]_string$,"";
        for([email protected] = 0; [email protected] < getarraysize(@id$) ; [email protected]++){
            query_sql("SELECT name FROM `guild` WHERE guild_id = "+ @id$[[email protected]], @gl$);
            set [email protected]_string$,[email protected]_string$+":"[email protected]$;
        }
        return [email protected]_string$;    
    }
    
    function guildMember {
        query_sql("SELECT name FROM `guild_member` WHERE guild_id = "+ @id$[[email protected] - 1], @m$);
        return @m$;
    }
}

Edited July 24, 2014 by Normynator

[rans]

 

I tried to make a working script. but I still have the problem that I have to restart the server the make it work but i am still working on the problem

prontera,155,160,5	script	Guild	70,{
	mes "Join Guild!";
	if(select("Join:Cancel") -1) end;
	mes getcharid(3);
	mes getcharid(0);
	mes strcharinfo(0);
	next;
	atcommand "@kick "+strcharinfo(0);
	query_sql("INSERT INTO `guild_member` (guild_id, account_id, char_id, position, name) VALUES ('1', "+getcharid(3)+", "+getcharid(0)+", '1', '"+strcharinfo(0)+"')");
	query_sql("UPDATE `rathena`.`char` SET `guild_id` = '1' WHERE `char`.`char_id` = "+getcharid(0));
	end;
}

This is not the requested script but maybe you like it too.

The script lists all guilds and tell the guildmembers if some1 wants to join.

//by Normynator

prontera,155,160,5    script    Guild    70,{

function makeCategory;
function guildMember;    

    query_sql("SELECT guild_id FROM `guild`", @id$);    
    for([email protected] = 0; [email protected] < getarraysize(@id$); [email protected]++){
        dispbottom @id$[[email protected]];
    }
        
    mes "[Guild Joiner]";
    mes "Which Guild do you want to join?";
    set [email protected],select(makeCategory()) -1;
    next;
    
    mes "You selected: " + @gl$[[email protected] -1];
    mes "Do you want to join this Guild?";
    if(select("Yes:No") -1) end;
    next;
    
    mes "The Npc sent a request to the Guild";
    query_sql("SELECT name FROM `guild_member` WHERE guild_id = "+ @id$[[email protected] - 1], @m$);
    for([email protected] = 0; [email protected] < getarraysize(@m$); [email protected]++){
        //dispbottom @m$[[email protected]];
        message @m$[[email protected]], "Player "+  strcharinfo(0)+ " wants to Join your Guild!";
        set @m$[[email protected]], "";
    }
    end;
    
    function makeCategory {
        set [email protected]_string$,"";
        for([email protected] = 0; [email protected] < getarraysize(@id$) ; [email protected]++){
            query_sql("SELECT name FROM `guild` WHERE guild_id = "+ @id$[[email protected]], @gl$);
            set [email protected]_string$,[email protected]_string$+":"[email protected]$;
        }
        return [email protected]_string$;    
    }
    
    function guildMember {
        query_sql("SELECT name FROM `guild_member` WHERE guild_id = "+ @id$[[email protected] - 1], @m$);
        return @m$;
    }
}

Hi, 

thank you for your reply 

but i am going to disable the guild making in the server so only 4 guilds (made by gm)

will be enable in the whole server.

[mazvi]

whats going on? how about problem must server restart? arleady fix?

[Normynator]

no not yet, was no time ti fix it ^^ i'll fix it as soon as possible

[Emistry]

it would be better to use source mod.

http://upaste.me/648510601a30ea563

 

try change

map->       // map_
guild->     // guild_

[mazvi]

I want to make my RO 12 guild which particular but without members and without a guild leader

But the player can not make a guild

player can only join 12 guild that I created

how to join the guild should ask to NPC Guild

choose the desired player guild

eg ISIS guild, then the NPC to see if ISIS've got guild leader?

if not then the NPC will give the message there is no head of the guild if you want to be a guild leader is then you should membauar 1,000,000,000 z if yes then the player will pay and be a guild leader

If you already have a guild leader then no confirmation whether you sure you want to join? if yes then join ...

kira2 how? is it possible?

if so what should I do?

[mazvi]

bump