office,89,72,3	script	Guard#prison	8W_SOLDIER,{
	set .@player_cid, getcharid(0);
	set .@player_aid, getcharid(3);
	set .@charname$, strcharinfo(0);
	sleep2 500;
	query_sql "SELECT `vdate`,unix_timestamp(`ban_until`),`ban_until`,`rcat_id`, `ref` FROM rules_log WHERE `char_id` = "+.@player_cid+" ORDER BY `vdate` DESC LIMIT 1",.@vdate$,.@unixban,.@bantime$,.@rcat_id,.@link$;
	if (!.@rcat_id) {  close; }
	
	//Get Violation Info
	query_sql "SELECT count(rcat_id) FROM rules_log WHERE `rcat_id` = "+.@rcat_id+" AND `account_id` = "+.@player_aid,.@count;
	query_sql "SELECT `rcat_desc`,`penalty1`,`penalty2`,`penalty3` FROM rules_cat WHERE `rcat_id` = "+.@rcat_id,.@rcat_desc$,.@penalty1,.@penalty2,.@penalty3;

	mes " Hello ^00CC00"+strcharinfo(0)+"^000000!";
	mes " You have been held here because one of your character have violated certain rules and regulations:";
	next;
	mes " Violation: ^FF0000"+.@rcat_desc$+"^000000";
	mes " Offense Count: ^FF0000"+.@count+" Offense^000000";
	mes " Date Filed: ^FF0000"+.@vdate$+"^000000";
	mes " Jail Until: ^FF0000"+.@bantime$+"^000000";
	
	if(.@penalty1 == 3) { set .@penalty1,.@penalty1; mes "Please request a character ^FF0000RENAME^000000 at ^FF0000fb.com/amatsuragnarok/messages^000000 so that we can process your release";}
	if(.@penalty1 >= 100 && .@penalty1 <=199) { set .@penalty1,.@penalty1-100; 	mes "1st Offense: ^FF0000"+.@penalty1+" minutes^000000 MUTE"; }
	if(.@penalty1 >= 200 && .@penalty1 <=299) { set .@penalty1,.@penalty1-200; 	mes "1st Offense: ^FF0000"+.@penalty1+" day(s)^000000 BAN"; }
	if(.@penalty1 == 300 ) 			{ 					mes "1st Offense: ^FF0000Permanent Ban^000000";}

	if(.@penalty2 >= 100 && .@penalty2 <=199) { set .@penalty2,.@penalty2-100; 	mes "2nd Offense: ^FF0000"+.@penalty2+" minutes(s)^000000 MUTE"; }
	if(.@penalty2 >= 200 && .@penalty2 <=299) { set .@penalty2,.@penalty2-200; 	mes "2nd Offense: ^FF0000"+.@penalty2+" day(s)^000000 BAN"; }
	if(.@penalty2 == 300 ) 			{ 					mes "2nd Offense: ^FF0000Permanent Ban^000000";}

	if(.@penalty3 >= 100 && .@penalty3 <=199) { set .@penalty3,.@penalty3-100; 	mes "3rd Offense: ^FF0000"+.@penalty3+" minutes(s)^000000 MUTE"; }
	if(.@penalty3 >= 200 && .@penalty3 <=299) { set .@penalty3,.@penalty3-200; 	mes "3rd Offense: ^FF0000"+.@penalty3+" day(s)^000000 BAN"; }
	if(.@penalty3 == 300 ) 			{ 					mes "3rd Offense: ^FF0000Permanent Ban^000000";}
	if (.@link$) mes "Reference: ^FF0000"+.@link$+"^000000";
	close;
	
}

office	mapflag	nomemo
office	mapflag	noreturn
office	mapflag	noteleport
office	mapflag	nowarp