//Script by Normynator v1.2
prontera,163,172,4	script	Guild Reward	79,{
	query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id);
	query_sql( "SELECT `name`, `master`, `guild_lv`, `average_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@master$, .@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 "[ "+ strnpcinfo(1) +" ]";
	mes "The Guild Package Contains:";
	mes .count + "x " + getitemname(.reward);
	next;
	mes "[ "+ strnpcinfo(1) +" ]";
	mes "You need:";
	mes "Guild Lv " + .gl;
	mes "Average Lv " + .ga;
	mes "Members Online " + .gm;
	next;
	if(.@master$ == strcharinfo(0)){
		mes "Guild Name: " + .@name$;
		if(.@guild_lv < .gl){
			mes "Guild Level: ^FF0000" + .@guild_lv + "^000000 of req " + .gl;
		}else mes "Guild Level: ^00FF00" + .@guild_lv + "^000000";
		if(.@guild_av < .ga){
			mes "Guild Average: ^FF0000" + .@guild_av + "^000000 of req. " + .ga;
		}else mes "Guild Average: ^00FF00" + .@guild_av + "^000000";
		if(.@m < .gm){
			mes "Guild Members online: ^FF0000" + .@m + "^000000 of req. " + .gm;
		}else mes "Members online: ^00FF00" + .@m + "^000000";
		
		
		if(.@guild_lv == .gl && .@m >= .gm && .@guild_av == .ga && $ready != 0){
			next;
			mes "[ "+ strnpcinfo(1) +" ]";
			mes "Do want to get the the reward now?";
			if(select("Yes:No") -1) end;
			announce "Guild Master " +.@master$ + " of " + .@name$ + " has acquired the Guild Package for his Guild", 0;
			set #GuildReward, 1;
			set $ready, .@guild_id;
			startnpctimer;
			for( .@i = 0; .@i < .@size; .@i++ ){
				if(attachrid(getcharid(3,.@name_m$[ .@i ]))){
					getitem .reward, .count;
				}
			}
			if(#GuildReward != 1){
				mes "You get " + .gmcount + "x " + getitemname(.gmreward);
				getitem .gmreward, .gmcount; 
				close;
			}else close;
		}else mes "This is not possible at the moment!";
	}else{
		//if($ready == .@guild_id && #GuildReward != 1){
		//	mes "You get " + .count + "x " + getitemname(.reward);
		//	getitem .reward, .count; 
		//	set #GuildReward, 1;
		//	close;
		//}else{
			mes "Sorry it's not for you.";
			close;
		//}
	}
OnTimer604800:
	set $ready, 0;
	stopnpctimer;
	setnpctimer 0;
	end;
	
OnInit:
	.reward = 607; 	//Reward item#
	.gmreward = 607;//Guild Master Reward
	.count = 1; 	//Count
	.gmcount = 10; 	// Guild master count
	.gl = 50;		//guildlevel
	.ga = 99;		//guild average_lv
	.gm = 1;		// members online
	
	end;
}