how can i record specific npc announcement?

[nuna 2]

Example: during woe. I would like to record all the break announcement that can be seen on an npc.

Npc will show:

 

[NPCname]

Kriemhild castle has been conquered by playername1 of the guildname1.

close;

[luizragna 41]

It's a very simple example:

announcement.sql:

DROP TABLE IF EXISTS `announcements`;
CREATE TABLE IF NOT EXISTS `announcements` (
  
  `time` DATETIME NOT NULL DEFAULT '00-00-0000 00:00:00',
  `announcement` VARCHAR(50) NOT NULL DEFAULT '',

  PRIMARY KEY (`time`)
) ENGINE=MYISAM;

 

announce.txt:

prontera,159,180,3	script	Announcer Girl	1_F_MARIA,{


set .@announcement$,"Hello "+strcharinfo(PC_NAME)+" from World";

announce(""+.@announcement$+"", bc_all);

query_sql("INSERT INTO `announcements` (announcement,time) VALUES ('"+.@announcement$+"',NOW() )");

end;
}

 

[AnnieRuru 958]

https://rathena.org/board/topic/115821-how-can-i-record-specific-npc-announcement/
spot another same topic in rathena

both answer provided are different ...
maybe you should elaborate more about how you want to do the "record the break announcement" ...