· 8 years ago · Mar 06, 2018, 11:48 PM
1--
2-- Table structure for grandboss_data
3--
4CREATE TABLE IF NOT EXISTS `grandboss_data` (
5 `boss_id` INTEGER NOT NULL DEFAULT 0,
6 `loc_x` INTEGER NOT NULL DEFAULT 0,
7 `loc_y` INTEGER NOT NULL DEFAULT 0,
8 `loc_z` INTEGER NOT NULL DEFAULT 0,
9 `heading` INTEGER NOT NULL DEFAULT 0,
10 `respawn_time` BIGINT NOT NULL DEFAULT 0,
11 `currentHP` DECIMAL(8,0) DEFAULT NULL,
12 `currentMP` DECIMAL(8,0) DEFAULT NULL,
13 `status` TINYINT NOT NULL DEFAULT 0,
14 PRIMARY KEY(`boss_id`)
15);
16
17INSERT IGNORE INTO `grandboss_data` VALUES
18
19(29001, -21610, 181594, -5734, 0, 0, 229898, 667, 0), -- Queen Ant
20(29006, 17726, 108915, -6480, 0, 0, 162561, 575, 0), -- Core
21(29014, 55024, 17368, -5412, 10126, 0, 325124, 1660, 0), -- Orfen
22(29019, 185708, 114298, -8221, 32768, 0, 13090000, 22197, 0), -- Antharas
23(29020, 115762, 17116, 10077, 8250, 0, 4068372, 3347, 0), -- Baium
24(29022, 55312, 219168, -3223, 0, 0, 858518, 1975, 0), -- Zaken
25(29028, 213004, -114890, -1595, 0, 0, 16660000, 22197, 0), -- Valakas
26(29065, -123348, -248881, -15537, 44732, 0, 1532678, 4255, 0), -- Sailren
27(29066, 185708, 114298, -8221, 32768, 0, 11186000, 1998000, 0), -- Antharas Weak (85)
28(29067, 185708, 114298, -8221, 32768, 0, 14518000, 1998000, 0), -- Antharas Normal (85)
29(29068, 185708, 114298, -8221, 32768, 0, 17850000, 1998000, 0), -- Antharas Strong (85)
30(29062, 0, 0, 0, 0, 0, 0, 0, 0), -- High Priestess van Halter
31(29045, 0, 0, 0, 0, 0, 1216600, 11100, 0), -- Frintezza
32(29054, 0, 0, 0, 0, 0, 300000, 2000, 0), -- Benom
33(29046, 174231, -88006, -5115, 0, 0, 1824900, 23310, 0), -- Scarlet Van Halisha (85)
34(29047, 174231, -88006, -5115, 0, 0, 898044, 4519, 0); -- Scarlet Van Halisha (85)