grandboss_data.sql 2.0 KB

123456789101112131415161718192021222324252627282930313233
  1. CREATE TABLE IF NOT EXISTS `grandboss_data` (
  2. `boss_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  3. `loc_x` mediumint(6) NOT NULL DEFAULT '0',
  4. `loc_y` mediumint(6) NOT NULL DEFAULT '0',
  5. `loc_z` mediumint(6) NOT NULL DEFAULT '0',
  6. `heading` mediumint(6) NOT NULL DEFAULT '0',
  7. `respawn_time` bigint(13) unsigned NOT NULL DEFAULT '0',
  8. `currentHP` decimal(30,15) NOT NULL,
  9. `currentMP` decimal(30,15) NOT NULL,
  10. `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  11. PRIMARY KEY (`boss_id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  13. INSERT IGNORE INTO `grandboss_data` VALUES
  14. (29001, -21610, 181594, -5734, 0, 0, 229898.48, 667.776, 0), -- Queen Ant (40)
  15. (29006, 17726, 108915, -6480, 0, 0, 622493.58388, 3793.536, 0), -- Core (50)
  16. (29014, 55024, 17368, -5412, 10126, 0, 622493.58388, 3793.536, 0), -- Orfen (50)
  17. (29019, 185708, 114298, -8221, 32768, 0, 17850000, 39960, 0), -- Antharas (79)
  18. (29020, 116033, 17447, 10104, 40188, 0, 4068372, 39960, 0), -- Baium (75)
  19. (29022, 55312, 219168, -3223, 0, 0, 858518.36, 399600, 0), -- Zaken (60)
  20. (29028, -105200, -253104, -15264, 0, 0, 223107426.1796109, 4497143.692870192, 0), -- Valakas (85)
  21. (29066, 185708, 114298, -8221,32768, 0, 14518000, 3996000, 0), -- Antharas Weak (79)
  22. (29067, 185708, 114298, -8221,32768, 0, 16184000, 3996000, 0), -- Antharas Normal (79)
  23. (29068, 185708, 114298, -8221,32768, 0, 204677324.07859, 3996000, 0), -- Antharas Strong (85)
  24. (29118, 0, 0, 0, 0, 0, 4109288, 1220547, 0); -- Beleth (83)
  25. -- (29045, 0, 0, 0, 0, 0, 1018821.42723286, 52001.06567747795, 0), -- Frintezza (85)
  26. -- (29046, 0, 0, 0, 0, 0, 1824900, 23310, 0), -- Scarlet Van Halisha (85)
  27. -- (29047, 174238, -89792, -5002, 0, 0, 898044, 4519, 0), -- Scarlet Van Halisha (85)
  28. -- (29099, 0, 0, 0, 0, 0, 1703893, 111000, 0), -- Baylor (83)
  29. -- (29150, 0, 0, 0, 0, 0, 8727677, 204995, 0), -- Ekimus (?)
  30. -- (29151, 0, 0, 0, 0, 0, 6690, 204995, 0), -- Feral (?)
  31. -- (29152, 0, 0, 0, 0, 0, 6690, 204995, 0), -- Feral (?)
  32. -- (29163, 0, 0, 0, 0, 0, 8727677, 204995, 0), -- Tiat (87)