case 3:
		mes "[Guild Pack Info]";
		//check if the guild is approved
		query_sql(SELECT `guild_id` FROM `guildpack_guilds` WHERE `guild_id` = "+.@guild_id+", .@guild_id2;
			if (.@guild_id != .@guild_id2) { //error }
				mes "[Guild Pack Info]";
				mes "I'm sorry but you do not belong here";
				close2;
			}
		// check if any guild members have ALREADY obtained a guild package
		if (query_sql("SELECT `name`,guild_name FROM guildpack_members " + 
		      "LEFT JOIN guildpack_guilds ON guildpack_members.guild_id=guildpack_guilds.guild_id " + 
		      "WHERE account_id IN (SELECT account_id FROM guild_member WHERE guild_id="+getcharid(2)+") LIMIT 1", .@name$,.@guild$) > 0) {
			mes "^0000FF"+.@name$+"^FF0000 already received a guild pack while in ^0000FF"+.@guild$+"^000000.";
			mes "Each account can only receive a guild pack once.";
			close;
		}
		// check if any players have already obtained a guild package (from that MAC address)
		if (query_sql("SELECT `name`,guild_name FROM guildpack_members " + 
		      "LEFT JOIN guildpack_guilds ON guildpack_members.guild_id=guildpack_guilds.guild_id " + 
		      "WHERE mac IN (SELECT last_mac FROM guild_member LEFT JOIN login ON guild_member.account_id=login.account_id WHERE guild_id="+getcharid(2)+") LIMIT 1", .@name$,.@guild$) > 0) {
			mes "^0000FF"+.@name$+"^FF0000 already received a guild pack while in ^0000FF"+.@guild$+"^000000.";
			mes "Each person can only receive a guild pack once per MAC address.";
			close;
		}
		//check if the player have already gotten their guild package
		if (query_sql("SELECT `name`,guild_name FROM guildpack_members " + 
		      "LEFT JOIN guildpack_guilds ON guildpack_members.guild_id=guildpack_guilds.guild_id " + 
		      "WHERE status IN (SELECT status FROM guild_member LEFT JOIN login ON guild_member.account_id=login.account_id WHERE guild_id="+getcharid(2)+") LIMIT 1", .@name$,.@guild$) > 0) {
			mes "^0000FF"+.@name$+"^FF0000 already received a guild pack while in ^0000FF"+.@guild$+"^000000.";
			mes "Each person can only receive a guild pack once.";
			close;
		
		//success
		mes "Get your Guild Pack?";
		if (select("No:Yes, continue") == 1) close;
			for (set .@i,0; .@i<.guild_size; set .@i,.@i+1) {
				query_sql "SELECT `master` FROM `guild` WHERE `guild_id` = "+.@guild_id+", .@master$;
				if (.@master$ == strcharinfo(0)) { getitem 30001, 1; //leader }
				else { getitem 30002, 1; }