/*
	// add this sql table
		
	CREATE TABLE IF NOT EXISTS `guild_package_log` (
		`id` int(11) unsigned NOT NULL,
		`guild_id` int(11) unsigned NOT NULL,
		`name` varchar(30) NOT NULL DEFAULT '',
		`account_id` int(11) unsigned NOT NULL,
		`time` datetime NOT NULL default '0000-00-00 00:00:00',
		PRIMARY KEY ( `id` )
	) ENGINE=MyISAM;

*/


/*
	in your guild package script...
	BEFORE they claimed the guild package, add this line
*/

mes "Claim Guild Package";
query_sql( "SELECT `account_id`,`master`,`time` FROM `guild_package_log` WHERE `guild_id` = "+.@guild_id+" LIMIT 1",.@aid,.@master$,.@time$ );
if( !.@aid ){
	// get guild packet
	getitem 512,1;
	getitem 512,2;
	getitem 512,3;
	query_sql( "INSERT INTO `guild_package_log` VALUES ( "+gettimetick(0)+","+.@guild_id+",'"+escape_sql( strcharinfo(0) )+"',"+getcharid(3)+",NOW() )" );
}
else{
	mes "Already claimed by "+.@master$+" on "+.@time$;
}