/*
	// run this Query in your SQL Machine

		ALTER TABLE  `login` ADD  `gpack_time` DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00';

*/

prontera,155,171,5	script	Guild Pack	757,{
.@guild_id = getcharid(2);
.@char_id = getcharid(0);

query_sql( "SELECT `gpack_time` FROM `login` WHERE `account_id` = "+getcharid(3),.@time$ );

if( !.@guild_id ){
	mes "You dont have a guild.";

}else if( .@time$ != "0000-00-00 00:00:00" ){
	mes "You already claimed Gpack since ^FF0000"+.@time$+"^000000";

}else if( getguildmasterid( .@guild_id ) != .@char_id ){
	mes "You're not Guild Master.";

}else{
	mes "Note : if your member who previously claimed Gpack may not be able to claim it again.";
	mes "Offline member will not be able to claim it.";
	if( select( "Continue, take Gpack","Cancel" ) == 1 ){
		query_sql( "SELECT `account_id`,`gpack_time` FROM `login` WHERE `gpack_time` = '0000-00-00 00:00:00' AND `account_id` IN ( SELECT `account_id` FROM `guild_member` WHERE `guild_id` = "+.@guild_id+" )",.@aid,.@gtime$ );
		.@size = getarraysize( .@aid );
		dispbottom ""+.@size;
		for( .@i = 0; .@i < .@size; .@i++ )
			if( .@gtime$[.@i] == "0000-00-00 00:00:00" ){
				// rewards.
				getitem 512,1,.@aid[.@i];
				getitem 512,2,.@aid[.@i];
				getitem 512,3,.@aid[.@i];
				.@count++;
			}
		query_sql( "UPDATE `login` SET `gpack_time` = NOW() WHERE `gpack_time` = '0000-00-00 00:00:00' AND `account_id` IN ( SELECT `account_id` FROM `guild_member` WHERE `guild_id` = "+.@guild_id+" )" );
	}
	mes "Total "+.@count+" member gained rewards.";
}
close;
}