R>Guild Package NPC

[GodKnows Jhomz]

Anyone have this kind of Guild Package NPC?

Need in a Guild

Need Guild Level 50

Need Minimum 10 Online Members (Total 11 Including Guild Master)

Need 255/120 All Members

One Guild Package Per Account

Can be set the Reward for Guild Members And for Guild Master.

I hope someone have this script and share it with me and for anyone who needs it.
Thanks!

[Normynator]

//Script by Normynator v1.0
prontera,163,172,4	script	Guild Reward	79,{ 
	mes "Hi";
	query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id);
	//mes .@guild_id;
	query_sql( "SELECT `name`, `guild_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv );
	.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ );
	for( .@i = 0; .@i < .@size; .@i++ ){
		if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++;
	}
	mes "Guild Name: " + .@name$;
	mes "Guild Level: " + .@guild_lv;
	mes "Members online: " + .@m;
	
	if(.@guild_lv == 50 && .@m == 11){
		next;
		if (#GuildReward){
			mes "You already got your item.";
			close;
		}
		set #GuildReward, 1;
		mes "A Berry for you";
		getitem 607, 1; 
		close;
	}
	close;
}

255/120 all members, or only the members which are online?

[GodKnows Jhomz]

//Script by Normynator v1.0
prontera,163,172,4	script	Guild Reward	79,{ 
	mes "Hi";
	query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id);
	//mes .@guild_id;
	query_sql( "SELECT `name`, `guild_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv );
	.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ );
	for( .@i = 0; .@i < .@size; .@i++ ){
		if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++;
	}
	mes "Guild Name: " + .@name$;
	mes "Guild Level: " + .@guild_lv;
	mes "Members online: " + .@m;
	
	if(.@guild_lv == 50 && .@m == 11){
		next;
		if (#GuildReward){
			mes "You already got your item.";
			close;
		}
		set #GuildReward, 1;
		mes "A Berry for you";
		getitem 607, 1; 
		close;
	}
	close;
}

255/120 all members, or only the members which are online?

 

Yes, 255/120 all members. Even its offline

[Normynator]

//Script by Normynator v1.1
prontera,163,172,4	script	Guild Reward	79,{ 
	mes "Hi";
	query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id);
	//mes .@guild_id;
	query_sql( "SELECT `name`, `guild_lv`, `average_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv, .@guild_av );
	.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ );
	for( .@i = 0; .@i < .@size; .@i++ ){
		if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++;
	}
	mes "Guild Name: " + .@name$;
	mes "Guild Level: " + .@guild_lv;
	mes "Guild Average Level: " + .@guild_av;
	mes "Members online: " + .@m;
	
	if(.@guild_lv == 50 && .@m == 11 && .@guild_av == 255){
		next;
		if (#GuildReward){
			mes "You already got your item.";
			close;
		}
		set #GuildReward, 1;
		mes "A Berry for you";
		getitem 607, 1; 
		close;
	}
	close;
}

Hope it works

[GodKnows Jhomz]

//Script by Normynator v1.1
prontera,163,172,4	script	Guild Reward	79,{ 
	mes "Hi";
	query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id);
	//mes .@guild_id;
	query_sql( "SELECT `name`, `guild_lv`, `average_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv, .@guild_av );
	.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ );
	for( .@i = 0; .@i < .@size; .@i++ ){
		if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++;
	}
	mes "Guild Name: " + .@name$;
	mes "Guild Level: " + .@guild_lv;
	mes "Guild Average Level: " + .@guild_av;
	mes "Members online: " + .@m;
	
	if(.@guild_lv == 50 && .@m == 11 && .@guild_av == 255){
		next;
		if (#GuildReward){
			mes "You already got your item.";
			close;
		}
		set #GuildReward, 1;
		mes "A Berry for you";
		getitem 607, 1; 
		close;
	}
	close;
}

Hope it works

 

Thanks for this. Gonna try this tomorrow and i'll tell you if it works.