mxAFhhHR

1CREATE TABLE IF NOT EXISTS `bossnia` (
2  `id` int(11) unsigned NOT NULL auto_increment,
3  `mvp_name` varchar(23) NOT NULL default '',
4  `mvp_id` int(10) unsigned NOT NULL default '0',
5  `dead` smallint(1) NOT NULL DEFAULT '0',
6  `time` smallint(5) NOT NULL DEFAULT '0',
7  `time_respawn` smallint(5) NOT NULL DEFAULT '0',
8  `label` varchar(23) NOT NULL default '',
9  PRIMARY KEY  (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11
12INSERT INTO `bossnia` VALUES (NULL, 'Kiel D-01', '1734', '0', '30', '30', 'OnKiel');
13INSERT INTO `bossnia` VALUES (NULL, 'Valquíria Randgris', '1751', '1', '31', '30', 'OnValky');
14INSERT INTO `bossnia` VALUES (NULL, 'Freeoni', '1159', '1', '20', '30', 'OnFree');
15
16-	script	edinaldozeira	FAKE_NPC,{
17
18OnKiel:
19end;
20OnValky:
21end;
22OnFree:
23end;
24
25OnMinute00:OnMinute05:OnMinute10:OnMinute15:OnMinute20:OnMinute25:OnMinute30:OnMinute35:OnMinute40:OnMinute45:OnMinute50:OnMinute55:
26query_sql "UPDATE bossnia SET time_respawn=time_respawn+5 WHERE dead>=1";
27query_sql "SELECT mvp_id, time, time_respawn, dead, label FROM bossnia WHERE dead>=1",.@mvp_id,.@time,.@rtime,.@dead,.@label$;
28for(.@i=0;.@i<getarraysize(.@mvp_id);.@i++){
29if(.@rtime[.@i]>=.@time[.@i]) { // Summon MvP + Buff
30monster "bossnia",0,0,"--ja--",.@mvp_id[.@i],1,strnpcinfo(3)+"::"+.@label$[.@i];
31setunitdata $@mobid[0],UMOB_LEVEL,300;
32}
33}
34end;
35}