/*

	CREATE TABLE IF NOT EXISTS `simbang_gabi` (
		`id` int(11) unsigned NOT NULL DEFAULT '0',
		`aid` int(11) unsigned NOT NULL DEFAULT '0',
		`day` smallint(11) unsigned NOT NULL DEFAULT '0',
		`time` datetime NOT NULL default '0000-00-00 00:00:00',
		KEY `id` (`id`)
	) ENGINE=MyISAM;

*/


prontera,155,181,5	script	Sample#simbang_gabi	757,{

	set .@aid,getcharid(3);
	set .@month,gettime( 6 );
	set .@today,gettime( 5 );
	set .@hour,gettime( 4 );

	if ( .can_use ) {
		query_sql( "SELECT `day` FROM `simbang_gabi` WHERE `aid` = "+.@aid+" ORDER BY `day` DESC",.@day );
		set .@day_size,getarraysize( .@day );
		if ( .@day[0] != .@today ) {
			mes "Attendance recorded.";
			query_sql( "INSERT INTO `simbang_gabi` VALUES ( "+gettimetick(2)+","+.@aid+","+.@today+",NOW() )" );
		}
		mes "You've signed for today.";

		query_sql( "SELECT COUNT( `day` ) FROM `simbang_gabi` WHERE `aid` = "+.@aid,.@count );
		if ( .@count >= .consecutive_login ) {
			next;
			query_sql( "DELETE FROM `simbang_gabi` WHERE `aid` = "+.@aid );
			mes "You have accumulated "+.consecutive_login+" attendance! You're now reward with items.";
			if ( Sex ) {	// male
				getitem 608,10;
			}
			else {	// female
				getitem 607,100;
			}
		}

	}
	else {
		mes "Month: December";
		mes "Date: 11~25";
		mes "Time: 6PM ~ 10AM";
	}
	close;

	OnInit:
		// required how many attendance
		set .consecutive_login,14;

		set .@month,gettime( 6 );
		set .@today,gettime( 5 );
		set .@hour,gettime( 4 );

		set .can_use,1;

		set .@date,atoi( gettimestr( "%Y%m%d",21 ) );

		if (  .@date < 20141211 || .@day > 20141225 ) {
	OnClock1000:
			set .can_use,0;

	OnDay1226:
			if ( .@day > 20141225 )
				disablenpc strnpcinfo(0);
		}
		end;

	OnClock1800:
		set .can_use,1;
		end;

}