Home Explore Help
Register Sign In
L2j
/
l2j-server-datapack
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 178c6bc5aa
Branches Tags
l2j-server-data...
/
L2J_DataPack
/
dist
/
sql
/
game
/
grandboss_data.sql

grandboss_data.sql 2.2 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839 
  1. CREATE TABLE IF NOT EXISTS `grandboss_data` (
    2. 

  2.   `boss_id` smallint(5) unsigned NOT NULL,
    3. 

  3.   `loc_x` mediumint(6) NOT NULL,
    4. 

  4.   `loc_y` mediumint(6) NOT NULL,
    5. 

  5.   `loc_z` mediumint(6) NOT NULL,
    6. 

  6.   `heading` mediumint(6) NOT NULL DEFAULT '0',
    7. 

  7.   `respawn_time` bigint(13) unsigned NOT NULL DEFAULT '0',
    8. 

  8.   `currentHP` decimal(30,15) NOT NULL,
    9. 

  9.   `currentMP` decimal(30,15) NOT NULL,
    10. 

  10.   `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
    11. 

  11.   PRIMARY KEY (`boss_id`)
    12. 

  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    13. 

  13. 

  14. INSERT IGNORE INTO `grandboss_data` (`boss_id`,`loc_x`,`loc_y`,`loc_z`,`heading`,`currentHP`,`currentMP`) VALUES
    15. 

  15. (29001, -21610, 181594, -5734, 0, 229898.48, 667.776), -- Queen Ant (40)
    16. 

  16. (29006, 17726, 108915, -6480, 0, 622493.58388, 3793.536), -- Core (50)
    17. 

  17. (29014, 55024, 17368, -5412, 10126, 622493.58388, 3793.536), -- Orfen (50)
    18. 

  18. -- (29019, 185708, 114298, -8221, 32768, 17850000, 39960), -- Antharas (79)
    19. 

  19. (29020, 116033, 17447, 10107, -25348, 4068372, 39960), -- Baium (75)
    20. 

  20. -- (29022, 55312, 219168, -3223, 0, 858518.36, 399600), -- Zaken (60)
    21. 

  21. -- (29025, 0, 0, 0, 0, 0, 0), -- Baium (Stone) (75)
    22. 

  22. (29028, -105200, -253104, -15264, 0, 62041918, 2248572), -- Valakas (85)
    23. 

  23. -- (29066, 185708, 114298, -8221,32768, 14518000, 3996000), -- Antharas Weak (79)
    24. 

  24. -- (29067, 185708, 114298, -8221,32768, 16184000, 3996000), -- Antharas Normal (79)
    25. 

  25. (29068, 185708, 114298, -8221,32768, 62802301, 1998000), -- Antharas Strong (85)
    26. 

  26. (29118, 0, 0, 0, 0, 4109288, 1220547); -- Beleth (83)
    27. 

  27. -- (29045, -87780, -155086, -9080, 16384, 1018821.42723286, 52001.06567747795), -- Frintezza (85)
    28. 

  28. -- (29046, -87789, -153295, -9176, 16384, 1824900, 23310), -- Scarlet Van Halisha (85)
    29. 

  29. -- (29047, -87789, -153295, -9176, 16384, 898044, 4519), -- Scarlet Van Halisha (85)
    30. 

  30. -- (29099, 0, 0, 0, 0, 1703893, 111000), -- Baylor (83)
    31. 

  31. -- (29150, 0, 0, 0, 0, 8727677, 204995), -- Ekimus (82)
    32. 

  32. -- (29163, 0, 0, 0, 0, 8727677, 204995), -- Tiat (87)
    33. 

  33. -- (29175, 0, 0, 0, 0, 8727677, 204995), -- Tiat (87)
    34. 

  34. -- (29176, 0, 0, 0, 0, 0, 0), -- Zaken Day (60)
    35. 

  35. -- (29177, 0, 0, 0, 0, 0, 0), -- Freya (Throne) (85)
    36. 

  36. -- (29178, 0, 0, 0, 0, 0, 0), -- Freya (Spelling) (85)
    37. 

  37. -- (29178, 0, 0, 0, 0, 0, 0), -- Freya (Stand) (85)
    38. 

  38. -- (29178, 0, 0, 0, 0, 0, 0), -- Freya (Stand Hard) (85)
    39. 

  39. -- (29179, 0, 0, 0, 0, 0, 0), -- Zaken Day (83)
    40.