viewing paste Unknown #21201 | SQL

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
-- Bismark melee tp
-- script missing tp
-- AIs
-- onMobDeath Blocks
-- Spawn Blocks
-- Balancing
-- Rift Spawns
-- Drops and Drop tables
-- add knockback
-- move mobs and launch
 
INSERT INTO `mob_pools` VALUES (9881,'Fjalar',1181,0x0000300700000000000000000000000000000000,4,5,12,240,100,0,1,1,2,23,0,0,3,0,0,400,1,0);
INSERT INTO `mob_pools` VALUES (9882,'Bloody_Skull',1182,0x0000A70800000000000000000000000000000000,4,4,12,240,100,0,16,0,2,23,0,7,135,0,0,401,1,0);
INSERT INTO `mob_pools` VALUES (9883,'Abununnu',1183,0x0000079820000000000000000000000000000000,8,4,12,270,100,0,2,1,2,23,0,7,159,0,0,426,1,0);
INSERT INTO `mob_pools` VALUES (9884,'Gloam_Servitor_Melee',1184,0x0000E50200000000000000000000000000000000,1,1,5,240,100,0,2,1,2,23,0,0,3,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9885,'Gloam_Servitor_Mage',1185,0x0000E50200000000000000000000000000000000,5,4,5,240,100,0,2,1,2,23,0,0,3,0,0,401,1,0);
INSERT INTO `mob_pools` VALUES (9886,'Tsui-Goab',1186,0x000012084761756E616200000000000000000000,1,4,12,240,100,0,2,0,2,23,0,7,671,8,0,604,1,0);
INSERT INTO `mob_pools` VALUES (9887,'Bloodswiller_Fly',1187,0x0000C10100000000000000000000000000000000,6,2,3,240,100,0,0,0,2,23,0,0,643,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9888,'Isarukitsck',1188,0x0000058300000000000000000000000000000000,4,2,1,380,100,0,0,1,2,23,0,1089,159,0,0,423,1,0);
INSERT INTO `mob_pools` VALUES (9889,'Little_Wingman',1189,0x0000BB0600000000000000000000000000000000,2,2,1,380,100,0,0,1,2,23,0,660,1155,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9890,'Bismark',1190,0x00002C0800000000000000000000000000000000,1,4,2,240,100,0,2,1,2,23,0,7,155,0,0,440,1,0);
INSERT INTO `mob_pools` VALUES (9891,'Primordial_Pugil',1191,0x00005D0100000000000000000000000000000000,1,1,7,240,100,0,2,0,2,23,0,7,157,0,0,0,1,0);
 
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 168, 1, 255); -- Thunder 5
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 197, 1, 255); -- Thundaga 4
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 500, 1, 255); -- thundaja
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 211, 1, 255); -- burst_ii
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 213, 1, 255); -- flood_ii
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 202, 1, 255); -- Waterga 4
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 501, 1, 255); -- Waterja
INSERT INTO `mob_spell_lists` VALUES ('Bismark', 440, 173, 1, 255); -- Water 5
 
INSERT INTO `mob_family_system` VALUES (1181,'Fjalar',9,'Demon',1,40,90,140,6,3,3,3,1,5,4,3,3,3,3,1,1,1,1,1,1,1,1,1,1,1,0.875,0);
INSERT INTO `mob_family_system` VALUES (1182,'Bloody_Skull',19,'Undead',0,40,100,120,3,3,3,3,3,3,3,3,3,3,3,1,1,1,1,1,1,1,1,1,1,1,1,8);
INSERT INTO `mob_family_system` VALUES (1183,'Abununnu',9,'Demon',0,70,110,140,1,2,4,4,1,2,4,3,3,3,3,1,1,1,1,0.75,0.75,0.75,0.75,0.75,0.75,1.25,0.75,8);
INSERT INTO `mob_family_system` VALUES (1184,'Gloam_Servitor_Melee',9,'Demon',0,70,110,140,1,2,4,4,1,2,4,3,3,3,3,1,1,1,1,0.75,0.75,0.75,0.75,0.75,0.75,1.25,0.75,8);
INSERT INTO `mob_family_system` VALUES (1185,'Gloam_Servitor_Mage',9,'Demon',0,70,110,140,1,2,4,4,1,2,4,3,3,3,3,1,1,1,1,0.75,0.75,0.75,0.75,0.75,0.75,1.25,0.75,8);
INSERT INTO `mob_family_system` VALUES (1186,'Tsui-Goab',20,'Vermin',0,40,105,120,3,18,4,3,3,6,5,3,5,18,3,1,1,1,1,1,1.25,1,1,1.25,1,1.125,1.25,4);
INSERT INTO `mob_family_system` VALUES (1187,'Bloodswiller_Fly',20,'Vermin',0,40,92,90,1,3,4,3,6,6,5,3,3,3,3,1,1.25,1,1,1,1.25,0.875,1,1,1,1,1,3);
INSERT INTO `mob_family_system` VALUES (1188,'Isarukitsck',8,'Bird',1,40,120,90,3,2,1,6,6,4,5,3,3,3,3,1,1,1,1,1,1,1,1.125,0.875,0.5,1,1,6);
INSERT INTO `mob_family_system` VALUES (1189,'Little_Wingman',8,'Bird',1,40,120,90,3,2,1,6,6,4,5,3,3,3,3,1,1,1,1,1,1,1,1.125,0.875,0.5,1,1,6);
INSERT INTO `mob_family_system` VALUES (1190,'Bismark',2,'Aquan',4,40,120,140,6,5,4,5,3,3,4,4,4,2,2,1,1,1,1,1,1.25,1,1,1.25,0.75,1,1,6);
INSERT INTO `mob_family_system` VALUES (1191,'Primordial_Pugil',2,'Aquan',1,40,90,90,1,3,4,3,6,6,5,3,3,3,3,1,1,1,1,1,1.25,1,1,1.25,0.5,1,1,6);
 
INSERT INTO `mob_groups` VALUES (90481,9881,49,300,0,0,110000,100000,127,127,0,0); -- Fjalar
INSERT INTO `mob_groups` VALUES (90482,9882,49,300,0,0,20000,100000,120,120,0,0); -- Bloody_Skull
INSERT INTO `mob_groups` VALUES (90483,9883,49,300,0,0,110000,100000,128,128,0,0); -- Abununnu
INSERT INTO `mob_groups` VALUES (90484,9884,49,300,0,0,40000,100000,120,120,0,0); -- Gloam_Servitor_Melee
INSERT INTO `mob_groups` VALUES (90485,9885,49,300,0,0,40000,100000,120,120,0,0); -- Gloam_Servitor_Mage
INSERT INTO `mob_groups` VALUES (90486,9886,49,300,0,0,110000,100000,128,128,0,0); -- Tsui-Goab
INSERT INTO `mob_groups` VALUES (90487,9887,49,300,0,0,15000,100000,120,120,0,0); -- Bloodswiller_Fly
INSERT INTO `mob_groups` VALUES (90488,9888,49,300,0,0,110000,100000,127,127,0,0); -- Isarukitsck
INSERT INTO `mob_groups` VALUES (90489,9889,49,300,0,0,20000,100000,120,120,0,0); -- Little_Wingman
INSERT INTO `mob_groups` VALUES (90490,9890,49,300,0,0,120000,100000,132,132,0,0); -- Bismark
INSERT INTO `mob_groups` VALUES (90491,9891,49,300,0,0,12000,100000,120,120,0,0); -- Primordial_Pugil
 
INSERT INTO `mob_spawn_points` VALUES (16977922,'Fjalar','Fjalar',90481,0,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977923,'Bloody_Skull','Bloody_Skull',90482,5,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977924,'Abununnu','Abununnu',90483,10,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977925,'Gloam_Servitor_Melee','Gloam_Servitor_Melee',90484,15,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977926,'Gloam_Servitor_Mage','Gloam_Servitor_Mage',90485,20,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977927,'Tsui-Goab','Tsui-Goab',90486,25,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977928,'Bloodswiller_Fly','Bloodswiller_Fly',90487,30,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977929,'Isarukitsck','Isarukitsck',90488,35,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977930,'Little_Wingman','Little_Wingman',90489,40,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977931,'Bismark','Bismark',90490,45,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977932,'Primordial_Pugil','Primordial_Pugil',90491,50,0,1,0);
 
-- Fjalar (1181)
INSERT INTO `mob_skill` VALUES (1857,1181,1456,'VW_Hellsnap',1,15.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1858,1181,1460,'VW_Hellclap',4,10.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1859,1181,1457,'VW_Cackle',1,15.0,2000,1000,4,0,0,0); -- script
INSERT INTO `mob_skill` VALUES (1860,1181,1462,'VW_Necrobane',1,15.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1861,1181,1461,'VW_Necropurge',1,15.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1862,1181,1458,'VW_Bilgestorm',1,15.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1863,1181,1459,'VW_Thundris_shriek',1,15.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2557,1181,1456,'Dunur_Strike',1,15.0,2000,1000,4,0,0,0); -- animation / script
INSERT INTO `mob_skill` VALUES (2556,1181,1459,'Bilfrost_Squall',1,15.0,2000,1000,4,0,0,0); -- animation / script
 
-- Bloody_Skull (1182)
INSERT INTO `mob_skill` VALUES (2255,1182,1463,'VW_Corpse_Breath',1,15.0,2000,1500,4,0,0,0);
 
-- Abununnu (1183)
INSERT INTO `mob_skill` VALUES (303,1183,303,'VW_Soul_Drain',0,7.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (304,1183,304,'VW_Hecatomb_Wave',4,10.0,2000,2000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (307,1183,307,'VW_Demonic_Howl',1,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (892,1183,311,'VW_Condemnation',4,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2116,1183,311,'Hellborn_Yawp',4,10.0,2000,1500,4,0,0,0); -- animation / script
INSERT INTO `mob_skill` VALUES (2565,1183,304,'Accurst_Spear',1,10.0,2000,1500,4,0,0,0); -- animation / script
 
-- Gloam_Servitor_Melee (1184)
INSERT INTO `mob_skill` VALUES (303,1184,303,'VW_Soul_Drain',0,7.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (304,1184,304,'VW_Hecatomb_Wave',4,10.0,2000,2000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (307,1184,307,'VW_Demonic_Howl',1,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (892,1184,311,'VW_Condemnation',4,10.0,2000,1500,4,0,0,0);
 
-- Gloam_Servitor_Mage (1185)
INSERT INTO `mob_skill` VALUES (303,1185,303,'VW_Soul_Drain',0,7.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (304,1185,304,'VW_Hecatomb_Wave',4,10.0,2000,2000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (307,1185,307,'VW_Demonic_Howl',1,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (892,1185,311,'VW_Condemnation',4,10.0,2000,1500,4,0,0,0);
 
-- Tsui-Goab (1186)
INSERT INTO `mob_skill` VALUES (2360,1186,1922,'Mantis_Melee',0,7.0,2000,0,4,16,0,0);
INSERT INTO `mob_skill` VALUES (2361,1186,1923,'Mantis_Melee2',0,7.0,2000,0,4,16,0,0);
INSERT INTO `mob_skill` VALUES (2362,1186,1924,'Mantis_Melee_Jump',0,15.0,2000,0,4,16,0,3);
INSERT INTO `mob_skill` VALUES (2495,1186,1923,'VW_Slicing_Sickle',4,18.0,2000,1000,4,0,0,3);
INSERT INTO `mob_skill` VALUES (2496,1186,1926,'VW_Raptorial_Claw',1,15.0,2000,1000,4,0,0,3);
INSERT INTO `mob_skill` VALUES (2497,1186,1927,'VW_Phlegm_Expulsion',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2498,1186,1928,'VW_Macerating_Bile',1,20.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2500,1186,1924,'Death_Prophet',1,15.0,8000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2499,1186,1929,'Preying_Posture',0,7.0,2000,1000,1,0,0,0);
INSERT INTO `mob_skill` VALUES (2553,1186,1926,'Immolating_Claw',1,25.0,2000,1000,4,0,0,3);
INSERT INTO `mob_skill` VALUES (2630,1186,1925,'Exorender',4,12.0,2000,1000,4,0,0,0); -- script
 
-- Bloodswiller_Fly (1187)
INSERT INTO `mob_skill` VALUES (62,1187,401,'VW_Somersault',0,7.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (403,1187,403,'VW_Cursed_Sphere',2,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (404,1187,404,'VW_Venom',0,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1368,1187,401,'Debilitating_Drone',1,17.0,2000,1500,4,0,0,0); -- animation / script
 
-- Isarukitsck (1188)
INSERT INTO `mob_skill` VALUES (1460,1188,1162,'VW_Frigid_Shuffle',1,18.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1459,1188,1161,'VW_Beak_Lunge',0,7.0,2000,1500,4,0,0,5);
INSERT INTO `mob_skill` VALUES (1457,1188,1159,'VW_Yawn',1,18.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1458,1188,1160,'VW_Wing_Slap',0,7.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2563,1188,1159,'Whiteout',1,18.0,2000,1500,4,0,0,0); -- animation / script
 
-- Little_Wingman (1189)
INSERT INTO `mob_skill` VALUES (1457,1189,1159,'VW_Yawn',1,10.0,2000,1500,4,0,0,0);
INSERT INTO `mob_skill` VALUES (1459,1189,1161,'VW_Beak_Lunge',0,7.0,2000,1500,4,0,0,0);
 
-- Bismark (1190) -- Needs Spoof Melee
INSERT INTO `mob_skill` VALUES (2620,1190,2012,'Thar_She_Blows',1,18.0,2000,5000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2619,1190,2010,'Waterspout',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2618,1190,2011,'Angry_Seas',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2617,1190,2009,'Blowhole_Blast',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2616,1190,2008,'Depht_Charge',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2615,1190,2007,'Baleen_Gurge',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2614,1190,2006,'Caudal_Capacitor',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2613,1190,2005,'Deep_Sea_Dirge',1,18.0,2000,1000,4,0,0,0);
INSERT INTO `mob_skill` VALUES (2612,1190,2004,'Echolocation',1,18.0,2000,1000,4,0,0,0); -- script
 
-- Primordial_Pugil (1191)
INSERT INTO `mob_skill` VALUES (385,1191,973,'VW_Recoil_Dive',4,10.0,2000,1500,4,0,0,0);
 
Viewed 768 times, submitted by unknown.