viewing paste Unknown #20741 | 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
VoidWatch Chapter 2
 
TO Do 
Models AND SIZE
Job assignments
skill TABLE
script TP
spell lists
AIs
balancing
abysitte masks
onMobDeath block
despawn timers 
 
 
INSERT INTO `mob_pools` VALUES (9820,'Goji',1118,0x0000B10800000000000000000000000000000000,1,1,3,240,100,0,16,0,2,0,0,7,159,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9821,'Gugalanna',1119,0x0000560900000000000000000000000000000000,2,2,12,240,100,0,16,0,2,0,0,7,159,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9822,'Yatagarasu',1120,0x0000530100000000000000000000000000000000,1,1,6,240,100,0,16,1,2,0,0,7,159,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9823,'Agathos',1121,0x0000570900000000000000000000000000000000,20,5,11,240,100,0,2,2,2,0,0,7,1183,0,0,0,1,1024);
INSERT INTO `mob_pools` VALUES (9824,'Cherufe',1122,0x0000B90800000000000000000000000000000000,1,1,6,200,100,0,2,0,2,0,0,7,159,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9825,'Taweret',1123,0x0000480500000000000000000000000000000000,1,1,6,240,100,0,2,0,2,0,0,7,671,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9826,'Roly_Poly',1124,0x0000090700000000000000000000000000000000,3,3,12,240,100,0,2,0,2,0,0,7,135,0,0,1,1,0); 
INSERT INTO `mob_pools` VALUES (9827,'Laidly_Laurence',1125,0x0000EC0700000000000000000000000000000000,4,4,7,280,100,0,2,0,2,0,0,7,155,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9828,'Mellonia',1126,0x0000DD0700000000000000000000000000000000,6,6,3,240,100,0,2,2,2,0,0,7,671,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9829,'Kalos_eunomia',1127,0x0000100700000000000000000000000000000000,1,1,7,240,100,0,40,0,2,1,0,7,671,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9830,'Nympha_eunomia',1128,0x00000A0700000000000000000000000000000000,1,1,7,265,100,0,2,1,2,0,0,7,671,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9831,'Gasha',1129,0x0000370800000000000000000000000000000000,1,1,10,240,100,0,6,0,0,0,0,7,159,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9832,'Giltine',1130,0x0000550900000000000000000000000000000000,4,4,12,240,100,0,6,0,2,0,0,7,671,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9833,'Kaggen',1131,0x000038084B616767656E00000000000000000000,4,4,12,240,100,0,8,0,2,0,0,7,159,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9834,'Akvan',1132,0x00003D0800000000000000000000000000000000,4,4,7,240,100,0,3,1,2,0,32,7,1183,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9835,'Pil',1133,0x0000360800000000000000000000000000000000,4,20,12,360,100,0,2,2,2,0,0,7,159,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9836,'Lancing_Lamorak',1134,0x00009A0100000000000000000000000000000000,4,6,8,240,100,0,257,1,0,0,0,7,159,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9837,'Bhishani',1135,0x0000EF0700000000000000000000000000000000,1,1,0,240,100,0,0,0,2,0,0,0,0,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9838,'RwNwPrtMHrw',1136,0x0000140800000000000000000000000000000000,20,20,11,240,100,0,2,1,2,0,0,7,135,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9839,'Stachysaurus',1137,0x0000FC0600000000000000000000000000000000,1,1,5,240,100,0,6,0,2,0,0,7,135,0,0,0,1,0);
INSERT INTO `mob_pools` VALUES (9840,'GwynnApnudd',1138,0x0000150800000000000000000000000000000000,4,4,12,290,100,0,12,1,2,0,32,7,159,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9841,'Smierc',1139,0x0000340800000000000000000000000000000000,4,4,10,240,100,0,6,0,2,0,0,7,159,0,0,28,1,0);
INSERT INTO `mob_pools` VALUES (9842,'Gaunab',1140,0x000012084761756E616200000000000000000000,4,4,12,240,100,0,2,0,2,0,0,7,671,8,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9843,'Ocythoe',1141,0x0000130800000000000000000000000000000000,4,4,6,240,100,0,2,0,2,0,0,7,1695,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9844,'Kalasutrax',1142,0x0000110800000000000000000000000000000000,4,1,10,240,100,0,6,0,2,0,0,7,1183,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9845,'Ig-Alima',1143,0x00000B0849672D416C696D610000000000000000,1,4,12,240,100,0,2,0,2,0,0,7,1183,0,0,2,1,0);
INSERT INTO `mob_pools` VALUES (9846,'Botulus_Rex',1144,0x00000C0800000000000000000000000000000000,4,4,12,240,100,0,2,0,2,0,0,7,159,0,0,2,1,0);
 
INSERT INTO `mob_family_system` VALUES (1118,'Goji',9,'Demon',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,0.875,2);
INSERT INTO `mob_family_system` VALUES (1119,'Gugalanna',9,'Demon',1,40,123,130,1,3,3,3,3,6,5,3,3,3,3,1,1,1.25,1.5,1,1,1,1,1,1,1.25,1,8);
INSERT INTO `mob_family_system` VALUES (1120,'Yatagarasu',8,'Bird',3,60,130,120,1,3,4,3,4,4,5,3,3,3,2,0.75,1.25,1,0.75,1,1.25,0.5,1,1,1,1,1,7);
INSERT INTO `mob_family_system` VALUES (1121,'Agathos',8,'Bird',4,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,0);
INSERT INTO `mob_family_system` VALUES (1122,'Cherufe',14,'Lizard',1,40,140,90,2,5,1,6,6,3,3,3,3,3,3,1,1,1,1,1,1.125,1.125,1,1,1,1,1,4);
INSERT INTO `mob_family_system` VALUES (1123,'Taweret',14,'Lizard',1,40,115,110,1,2,2,3,4,4,3,3,3,3,3,1,1,1,1,1,1.125,1,1,1,1,1,1,1);
INSERT INTO `mob_family_system` VALUES (1124,'Roly_Poly',1,'Amorph',1,40,70,140,6,3,6,3,1,5,4,3,3,3,3,0.875,1,0.75,0.75,1.25,1.25,1.25,1.125,1.125,1.125,1.125,1.125,6);
INSERT INTO `mob_family_system` VALUES (1125,'Laidly_Laurence',1,'Amorph',5,40,155,180,2,3,4,3,8,8,5,3,3,3,3,1,1,1,1,0.5,0.5,1.125,0.25,0.25,0.5,1,0.5,4);
INSERT INTO `mob_family_system` VALUES (1126,'Mellonia',20,'Vermin',0,40,90,120,4,1,4,2,3,6,6,3,3,3,3,1,1,1,1,1,1,1,1,1,1,1,1,8);
INSERT INTO `mob_family_system` VALUES (1127,'Kalos_Eunomia',20,'Vermin',1,40,90,90,1,3,4,3,6,6,5,3,3,3,3,1,1,1,1,0.5,1.125,1,1,1,1,1,1,1);
INSERT INTO `mob_family_system` VALUES (1128,'Nympha_Eunomia',20,'Vermin',1,45,90,90,1,3,4,3,6,6,5,3,3,3,3,1,1,1,1,0.875,1.125,1,1,1,1,1,1,1);
INSERT INTO `mob_family_system` VALUES (1129,'Gasha',19,'Undead',0,40,95,140,1,3,3,3,1,5,1,3,3,3,3,0.875,0.5,1.125,1.25,1.25,0.875,1,1,1,1,1.25,0.5,4);
INSERT INTO `mob_family_system` VALUES (1130,'Giltine',19,'Undead',1,40,111,140,1,3,3,3,1,5,1,3,3,3,3,0.875,0.5,1.125,1.25,1.25,0.875,0.75,0.75,0.75,0.75,1.25,0.5,8);
INSERT INTO `mob_family_system` VALUES (1131,'Kaggen',20,'Vermin',1,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 (1132,'Akvan',9,'Demon',0,40,87,140,2,3,5,3,1,2,2,3,3,3,3,1,1,1,1,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,8);
INSERT INTO `mob_family_system` VALUES (1133,'Pil',3,'Arcana',1,40,90,90,1,3,4,3,6,6,5,3,3,3,3,1,1,1,1,1,1,1,1,1,1,1,1,0);
INSERT INTO `mob_family_system` VALUES (1134,'Lancing_Lamorak',20,'Vermin',1,40,117,110,1,3,2,4,5,5,6,3,2,3,3,1,1,1,1,1,1.25,1,1,1,1,1.25,1,4);
INSERT INTO `mob_family_system` VALUES (1135,'Bhishani',18,'Unclassified',0,40,90,100,4,6,4,5,5,1,3,3,3,3,3,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,3);
INSERT INTO `mob_family_system` VALUES (1136,'RwNwPrtMHrw',18,'Unclassified',0,40,90,100,4,6,4,5,5,1,3,3,3,3,3,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,0.375,3);
INSERT INTO `mob_family_system` VALUES (1137,'Stachysaurus',14,'Lizard',1,40,140,90,2,5,1,6,6,3,3,3,3,3,3,1,1,1,1,1,1.125,1.125,1,1,1,1,1,4);
INSERT INTO `mob_family_system` VALUES (1138,'GwynnApnudd',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 (1139,'Smierc',19,'Undead',0,40,95,140,1,3,3,3,1,5,1,3,3,3,3,0.875,0.5,1.125,1.25,1.25,0.875,1,1,1,1,1.25,0.5,4);
INSERT INTO `mob_family_system` VALUES (1140,'Gaunab',20,'Vermin',1,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 (1141,'Ocythoe',8,'Bird',3,60,130,120,1,3,4,3,4,4,5,3,3,3,2,0.75,1.25,1,0.75,1,1.25,0.5,1,1,1,1,1,7);
INSERT INTO `mob_family_system` VALUES (1142,'Kalasutrax',19,'Undead',2,40,70,140,6,3,6,3,8,5,4,3,3,3,3,0.75,0.75,0.5,0.5,1.25,0.3,1,1,1,1,1,0.3,2);
INSERT INTO `mob_family_system` VALUES (1143,'Ig-Alima',9,'Demon',2,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 (1144,'Botulus_Rex',1,'Amorph',4,40,70,140,6,3,6,3,1,5,4,3,3,3,3,0.875,1,0.75,0.75,1.25,1.25,1.25,1.125,1.125,1.125,1.125,1.125,6);
 
INSERT INTO `mob_spawn_points` VALUES (16977922,'Goji','Goji',90420,0,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977923,'Gugalanna','Gugalanna',90421,5,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977924,'Yatagarasu','Yatagarasu',90422,10,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977925,'Agathos','Agathos',90423,15,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977926,'Cherufe','Cherufe',90424,20,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977927,'Taweret','Taweret',90425,25,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977928,'Roly_Poly','Roly Poly',90426,30,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977929,'Laidly_Laurence','Laidly Laurence',90427,35,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977930,'Mellonia','Mellonia',90428,40,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977931,'Kalos_Eunomia','Kalos Eunomia',90429,45,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977932,'Nympha_Eunomia','Nympha Eunomia',90430,50,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977933,'Gasha','Gasha',90431,55,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977934,'Giltine','Giltine',90432,60,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977935,'Kaggen','Kaggen',90433,65,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977936,'Akvan','Akvan',90434,70,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977937,'Pil','Pil',90435,75,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977938,'Lancing_Lamorak','Lancing Lamorak',90436,80,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977939,'Bhishani','Bhishani',90437,85,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977940,'RwNwPrtMHrw','RwNwPrtMHrw',90438,90,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977941,'Stachysaurus','Stachysaurus',90439,95,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977942,'GwynnApnudd','GwynnApnudd',90440,100,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977943,'Smierc','Smierc',90441,105,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977944,'Gaunab','Gaunab',90442,110,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977945,'Ocythoe','Ocythoe',90443,115,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977946,'Kalasutrax','Kalasutrax',90444,120,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977947,'Ig-Alima','Ig-Alima',90445,125,0,1,0);
INSERT INTO `mob_spawn_points` VALUES (16977948,'Botulus_Rex','Botulus Rex',90446,130,0,1,0);
 
 
 
INSERT INTO `mob_groups` VALUES (90420,9820,49,300,0,0,80000,100000,122,122,0); -- Goji
INSERT INTO `mob_groups` VALUES (90421,9821,49,300,0,0,80000,100000,122,122,0); -- Gugalanna
INSERT INTO `mob_groups` VALUES (90422,9822,49,300,0,0,80000,100000,122,122,0); -- Yatagarasu
INSERT INTO `mob_groups` VALUES (90423,9823,49,300,0,0,80000,100000,122,122,0); -- Agathos
INSERT INTO `mob_groups` VALUES (90424,9824,49,300,0,0,80000,100000,122,122,0); -- Cherufe
INSERT INTO `mob_groups` VALUES (90425,9825,49,300,0,0,80000,100000,122,122,0); -- Taweret
INSERT INTO `mob_groups` VALUES (90426,9826,49,300,0,0,80000,100000,125,125,0); -- Roly_Poly
INSERT INTO `mob_groups` VALUES (90427,9827,49,300,0,0,90000,100000,125,125,0); -- Laidly_Laurence
INSERT INTO `mob_groups` VALUES (90428,9828,49,300,0,0,90000,100000,125,125,0); -- Mellonia
INSERT INTO `mob_groups` VALUES (90429,9829,49,300,0,0,90000,100000,125,125,0); -- Kalos_eunomia
INSERT INTO `mob_groups` VALUES (90430,9830,49,300,0,0,90000,100000,125,125,0); -- Nympha_eunomia
INSERT INTO `mob_groups` VALUES (90431,9831,49,300,0,0,90000,100000,125,125,0); -- Gasha
INSERT INTO `mob_groups` VALUES (90432,9832,49,300,0,0,90000,100000,125,125,0); -- Giltine
INSERT INTO `mob_groups` VALUES (90433,9833,49,300,0,0,110000,100000,127,127,0); -- Kaggen
INSERT INTO `mob_groups` VALUES (90434,9834,49,300,0,0,110000,100000,127,127,0); -- Akvan
INSERT INTO `mob_groups` VALUES (90435,9835,49,300,0,0,110000,100000,127,127,0); -- Pil
INSERT INTO `mob_groups` VALUES (90436,9836,49,300,0,0,120000,100000,127,127,0); -- Lancing_Lamorak
INSERT INTO `mob_groups` VALUES (90437,9837,49,300,0,0,120000,100000,127,127,0); -- Bhishani
INSERT INTO `mob_groups` VALUES (90438,9838,49,300,0,0,120000,100000,127,127,0); -- RwNwPrtMHrw
INSERT INTO `mob_groups` VALUES (90439,9839,49,300,0,0,130000,100000,127,127,0); -- Stachysaurus
INSERT INTO `mob_groups` VALUES (90440,9840,49,300,0,0,130000,100000,127,127,0); -- GwynnApnudd
INSERT INTO `mob_groups` VALUES (90441,9841,49,300,0,0,130000,100000,127,127,0); -- Smierc
INSERT INTO `mob_groups` VALUES (90442,9842,49,300,0,0,130000,100000,132,132,0); -- Gaunab
INSERT INTO `mob_groups` VALUES (90443,9843,49,300,0,0,130000,100000,132,132,0); -- Ocythoe
INSERT INTO `mob_groups` VALUES (90444,9844,49,300,0,0,130000,100000,132,132,0); -- Kalasutrax
INSERT INTO `mob_groups` VALUES (90445,9845,49,300,0,0,130000,100000,132,132,0); -- Ig-Alima
INSERT INTO `mob_groups` VALUES (90446,9846,49,300,0,0,130000,100000,132,132,0); -- Botulus_Rex
Viewed 698 times, submitted by Guest.