/*
	Load this SQL Table..

CREATE TABLE IF NOT EXISTS `broadcast_log` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `account_id` int(11) unsigned NOT NULL default '0',
  `char_id` int(11) unsigned NOT NULL default '0',
  `name` varchar(30) NOT NULL DEFAULT '',
  `message` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

*/


// zhakastia,113,60,5	script	Broadcaster	811,{
prontera,155,181,5	script	Broadcaster	811,{
mes .npc_name$;
mes "Hi, I'm the Broadcaster";
mes "I can Broadcast a message for you";
next;
mes "It costs ^ff0000"+.zeny_cost+"^000000 zeny ";
mes " ";

set .@remain_delay,( @broadcast_delay - gettimetick(2) );
if( .@remain_delay > 0 ){
	mes "Sorry , but you have to wait "+.@remain_delay+" seconds.";
}else if( Zeny >= .zeny_cost ){
	mes "Would you like to broadcast ?";
	if( select( "- YES","- NO" ) == 1 ){
		mes "Please input your message.";
		input .@broadcast_message$;
		next;
		mes "Announce : ";
		mes "^0055FF"+.@broadcast_message$+"^000000";
		mes " ";
		mes "^777777Your action will be saved for future references^000000";
		if( select( "- CONTINUE","- NO" ) == 1 ){
			set @broadcast_delay,gettimetick(2) + .broadcast_delay;
			set Zeny,Zeny - .zeny_cost;
			announce "Message from "+strcharinfo(0)+": "+.@broadcast_message$,0xB1FB17;
			message strcharinfo(0),.broadcast_delay+" seconds of Broadcast Delay applied.";
			query_sql( "INSERT INTO `broadcast_log` ( `time`,`account_id`,`char_id`,`name`,`message` ) VALUES ( NOW(),"+getcharid(3)+","+getcharid(0)+",'"+escape_sql( strcharinfo(0) )+"','"+escape_sql( .@broadcast_message$ )+"' )" );
		}
	}
}
close;

OnInit:
if( strnpcinfo(2) == "" ){
	set .npc_name$,"[^0000ff Broadcaster ^000000]";
	set .zeny_cost,5000000;
	set .broadcast_delay,1;
}
end;
}


hugel.gat,90,151,5	duplicate(Broadcaster)	Broadcaster#1	114
morocc.gat,144,101,5	duplicate(Broadcaster)	Broadcaster#2	114
geffen.gat,113,65,5	duplicate(Broadcaster)	Broadcaster#3	114
payon.gat,169,238,5	duplicate(Broadcaster)	Broadcaster#4	114
alberta.gat,195,156,5	duplicate(Broadcaster)	Broadcaster#5	114
izlude.gat,127,120,5	duplicate(Broadcaster)	Broadcaster#6	114
aldebaran.gat,133,120,5	duplicate(Broadcaster)	Broadcaster#7	114
xmas.gat,142,136,5	duplicate(Broadcaster)	Broadcaster#8	114
comodo.gat,196,162,5	duplicate(Broadcaster)	Broadcaster#9	114
amatsu.gat,207,98,5	duplicate(Broadcaster)	Broadcaster#10	114
gonryun.gat,154,126,5	duplicate(Broadcaster)	Broadcaster#11	114
umbala.gat,97,157,5	duplicate(Broadcaster)	Broadcaster#12	114
louyang.gat,212,51,5	duplicate(Broadcaster)	Broadcaster#13	114
ayothaya.gat,155,121,5	duplicate(Broadcaster)	Broadcaster#14	114
einbroch.gat,56,203,5	duplicate(Broadcaster)	Broadcaster#15	114
lighthalzen.gat,153,85,5	duplicate(Broadcaster)	Broadcaster#16	114
einbech.gat,67,107,5	duplicate(Broadcaster)	Broadcaster#17	114
rachel.gat,132,117,5	duplicate(Broadcaster)	Broadcaster#18	114
yuno.gat,149,126,5	duplicate(Broadcaster)	Broadcaster#19	114