All pastes #134546 Raw Edit

Mine

public text v1 · immutable
#134546 ·published 2006-08-16 12:37 UTC
rendered paste body
REPLACE INTO npcskills VALUES (1761,4304,1);
UPDATE npc SET level=73,hp=4087,mp=1760 WHERE id=1761; -- Total HP=12261 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES (1761, 1867, 1, 3, 0, 142857); -- 
INSERT INTO `droplist` VALUES (1761, 1872, 1, 3, 0, 200000); -- 
INSERT INTO `droplist` VALUES (1761, 57, 2731, 5441, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1761, 3957, 1, 1, 0, 2101); -- 
INSERT INTO `droplist` VALUES (1761, 4041, 1, 1, 0, 3155); -- 
INSERT INTO `droplist` VALUES (1761, 5539, 1, 1, 0, 4202); -- 
INSERT INTO `droplist` VALUES (1761, 1875, 1, 1, 0, 16667); -- Stone of Purity
INSERT INTO `droplist` VALUES (1761, 1881, 1, 1, 0, 27027); -- 


REPLACE INTO npcskills VALUES (1762,4304,1);
UPDATE npc SET level=75,hp=4229,mp=1840 WHERE id=1762; -- Total HP=12687 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES (1762, 4042, 1, 1, 0, 5263); -- 
INSERT INTO `droplist` VALUES  (1762, 5539, 1, 1, 0, 6289); -- 
INSERT INTO `droplist` VALUES  (1762, 1894, 1, 1, 0, 14706); -- 
INSERT INTO `droplist` VALUES (1762, 1882, 1, 1, 0, 83333); -- 
INSERT INTO `droplist` VALUES (1762, 1872, 1, 3, 0, 142857); -- 
INSERT INTO `droplist` VALUES (1762, 1867, 1, 3, 0, 200000); -- 
INSERT INTO `droplist` VALUES (1762, 57, 3056, 6116, 0, 700000); -- Adena


UPDATE npc SET level=70,hp=3862,mp=1642 WHERE id=1763; -- Total HP=3862
INSERT INTO `droplist` VALUES (1763, 57, 1030, 2060, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1763, 1343, 10, 30, 0, 125000); -- 
INSERT INTO `droplist` VALUES (1763, 1872, 1, 1, 0, 125000); -- 
INSERT INTO `droplist` VALUES (1763, 1867, 1, 1, 0, 111111); -- 
INSERT INTO `droplist` VALUES (1763, 1882, 1, 1, 0, 17544); -- 
INSERT INTO `droplist` VALUES  (1763, 1894, 1, 1, 0, 14085); -- 
INSERT INTO `droplist` VALUES (1763, 6671, 1, 1, 0, 8850); -- 
INSERT INTO `droplist` VALUES (1763, 4042, 1, 1, 0, 3571); -- 
INSERT INTO `droplist` VALUES (1763, 5532, 1, 1, 0, 1783); -- 


REPLACE INTO npcskills VALUES (1764,4307,1);
UPDATE npc SET level=75,hp=4229,mp=1840 WHERE id=1764; -- Total HP=25375 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES  (1764, 57, 3090, 6180, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1764, 1873, 1, 1, 0, 142857); -- 
INSERT INTO `droplist` VALUES  (1764, 1868, 3, 9, 0, 111111); -- 
INSERT INTO `droplist` VALUES (1764, 1895, 1, 1, 0, 90909); -- 
INSERT INTO `droplist` VALUES (1764, 1876, 1, 1, 0, 62500); -- Mithril Ore
INSERT INTO `droplist` VALUES (1764, 4042, 1, 1, 0, 3937); -- 
INSERT INTO `droplist` VALUES (1764, 5535, 1, 1, 0, 3937); -- 


REPLACE INTO npcskills VALUES (1765,4307,1);
UPDATE npc SET level=75,hp=4229,mp=1840 WHERE id=1765; -- Total HP=25375 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES (1765, 57, 6440, 12880, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1765, 1895, 1, 1, 0, 200000); -- 
INSERT INTO `droplist` VALUES (1765, 1344, 60, 180, 0, 142857); -- 
INSERT INTO `droplist` VALUES (1765, 4043, 1, 1, 0, 28571); -- 
INSERT INTO `droplist` VALUES (1765, 4040, 1, 1, 0, 12195); -- 
INSERT INTO `droplist` VALUES (1765, 4042, 1, 1, 0, 11494); -- 
INSERT INTO `droplist` VALUES (1765, 5539, 1, 1, 0, 7463); -- 


UPDATE npc SET level=75,hp=1057,mp=1840 WHERE id=1766; -- Total HP=1057
INSERT INTO `droplist` VALUES (1766, 57, 6500, 13000, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1766, 1868, 3, 9, 0, 250000); -- 
INSERT INTO `droplist` VALUES (1766, 1873, 2, 6, 0, 66667); -- 
INSERT INTO `droplist` VALUES  (1766, 5549, 1, 1, 0, 66667); -- 
INSERT INTO `droplist` VALUES (1766, 1889, 1, 1, 0, 50000); -- 
INSERT INTO `droplist` VALUES (1766, 4044, 1, 1, 0, 20408); -- 
INSERT INTO `droplist` VALUES (1766, 5535, 1, 1, 0, 7937); -- 


REPLACE INTO npcskills VALUES (1767,4311,1);
UPDATE npc SET level=70,hp=3862,mp=1642 WHERE id=1767; -- Total HP=1931 & strong/feeble type skill was 4311, so a mult of 0.5 was applied
INSERT INTO `droplist` VALUES (1767, 57, 600, 1200, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1767, 1868, 1, 1, 0, 125000); -- 
INSERT INTO `droplist` VALUES (1767, 1873, 1, 1, 0, 32258); -- 
INSERT INTO `droplist` VALUES (1767, 5549, 1, 1, 0, 6623); -- 
INSERT INTO `droplist` VALUES (1767, 1889, 1, 1, 0, 4545); -- 
INSERT INTO `droplist` VALUES (1767, 4044, 1, 1, 0, 1401); -- 


REPLACE INTO npcskills VALUES (1768,4307,1);
UPDATE npc SET level=73,hp=4087,mp=1760 WHERE id=1768; -- Total HP=24522 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES (1768, 57, 6190, 12380, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1768, 1866, 1, 3, 0, 166667); -- 
INSERT INTO `droplist` VALUES  (1768, 1871, 4, 12, 0, 83333); -- 
INSERT INTO `droplist` VALUES (1768, 1877, 1, 1, 0, 31250); -- 
INSERT INTO `droplist` VALUES  (1768, 4040, 1, 1, 0, 15873); -- 
INSERT INTO `droplist` VALUES (1768, 5536, 1, 1, 0, 7874); -- 
INSERT INTO `droplist` VALUES  (1768, 4041, 1, 1, 0, 7299); -- 
INSERT INTO `droplist` VALUES (1768, 5162, 1, 1, 0, 458); -- 


REPLACE INTO npcskills VALUES (1769,4307,1);
UPDATE npc SET level=70,hp=3862,mp=1642 WHERE id=1769; -- Total HP=23174 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES (1769, 57, 610, 1220, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1769, 1868, 1, 1, 0, 125000); -- 
INSERT INTO `droplist` VALUES (1769, 1873, 1, 1, 0, 32258); -- 
INSERT INTO `droplist` VALUES  (1769, 5549, 1, 1, 0, 6623); -- 
INSERT INTO `droplist` VALUES (1769, 1889, 1, 1, 0, 4545); -- 
INSERT INTO `droplist` VALUES (1769, 4044, 1, 1, 0, 1401); -- 


REPLACE INTO npcskills VALUES (1770,4307,1);
UPDATE npc SET level=73,hp=4087,mp=1760 WHERE id=1770; -- Total HP=24522 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES (1770, 57, 6000, 12000, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1770, 1868, 1, 1, 0, 125000); -- 
INSERT INTO `droplist` VALUES  (1770, 1873, 1, 1, 0, 32258); -- 
INSERT INTO `droplist` VALUES  (1770, 5549, 1, 1, 0, 6623); -- 
INSERT INTO `droplist` VALUES (1770, 1889, 1, 1, 0, 4545); -- 
INSERT INTO `droplist` VALUES (1770, 4044, 1, 1, 0, 1401); -- 


REPLACE INTO npcskills VALUES (1771,4307,1);
UPDATE npc SET level=70,hp=3862,mp=1642 WHERE id=1771; -- Total HP=23174 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES  (1771, 57, 5430, 10860, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1771, 5536, 1, 1, 0, 3937); -- 
INSERT INTO `droplist` VALUES (1771, 730, 1, 1, 0, 787); -- 


REPLACE INTO npcskills VALUES (1772,4307,1);
UPDATE npc SET level=75,hp=4229,mp=1840 WHERE id=1772; -- Total HP=25375 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES  (1772, 57, 6290, 12580, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1772, 5532, 1, 1, 0, 5319); -- 
INSERT INTO `droplist` VALUES (1772, 5543, 1, 1, 0, 2283); -- 
INSERT INTO `droplist` VALUES (1772, 730, 1, 1, 0, 1522); -- 


REPLACE INTO npcskills VALUES (1773,4307,1);
UPDATE npc SET level=73,hp=4087,mp=1760 WHERE id=1773; -- Total HP=24522 & strong/feeble type skill was 4307, so a mult of 6 was applied
INSERT INTO `droplist` VALUES  (1773, 57, 5730, 11460, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1773, 5535, 1, 1, 0, 9346); -- 
INSERT INTO `droplist` VALUES (1773, 730, 1, 1, 0, 850); -- 


REPLACE INTO npcskills VALUES (1774,4304,1);
UPDATE npc SET level=80,hp=4551,mp=2043 WHERE id=1774; -- Total HP=13653 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES  (1774, 57, 4120, 8240, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1774, 1868, 3, 9, 0, 200000); -- 
INSERT INTO `droplist` VALUES  (1774, 1876, 1, 1, 0, 125000); -- Mithril Ore
INSERT INTO `droplist` VALUES  (1774, 1895, 1, 1, 0, 71429); -- 


REPLACE INTO npcskills VALUES (1775,4304,1);
UPDATE npc SET level=85,hp=4813,mp=2253 WHERE id=1775; -- Total HP=14441 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES  (1775, 57, 5640, 11280, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1775, 1871, 1, 3, 0, 333333); -- 
INSERT INTO `droplist` VALUES  (1775, 1866, 1, 1, 0, 55556); -- 
INSERT INTO `droplist` VALUES (1775, 5220, 1, 1, 0, 27778); -- 


REPLACE INTO npcskills VALUES (1776,4304,1);
UPDATE npc SET level=83,hp=4716,mp=2168 WHERE id=1776; -- Total HP=14150 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES (1776, 57, 4020, 8040, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1776, 1872, 1, 3, 0, 142857); -- 
INSERT INTO `droplist` VALUES (1776, 1344, 45, 135, 0, 142857); -- 
INSERT INTO `droplist` VALUES (1776, 1882, 1, 1, 0, 47619); -- 
INSERT INTO `droplist` VALUES (1776, 1867, 10, 15, 0, 28571); -- 
INSERT INTO `droplist` VALUES (1776, 5487, 1, 1, 0, 18868); -- 
INSERT INTO `droplist` VALUES  (1776, 4042, 1, 1, 0, 9524); -- 
INSERT INTO `droplist` VALUES (1776, 1894, 1, 1, 0, 9524); -- 


REPLACE INTO npcskills VALUES (1777,4304,1);
UPDATE npc SET level=85,hp=4813,mp=2253 WHERE id=1777; -- Total HP=14441 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES (1777, 57, 4070, 8140, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES  (1777, 1869, 2, 6, 0, 111111); -- 
INSERT INTO `droplist` VALUES (1777, 1344, 30, 90, 0, 100000); -- 
INSERT INTO `droplist` VALUES (1777, 1880, 1, 1, 0, 83333); -- Steel
INSERT INTO `droplist` VALUES (1777, 1864, 5, 15, 0, 83333); -- 
INSERT INTO `droplist` VALUES  (1777, 4043, 1, 1, 0, 8130); -- 
INSERT INTO `droplist` VALUES  (1777, 5550, 1, 1, 0, 8130); -- 
INSERT INTO `droplist` VALUES  (1777, 5487, 1, 1, 0, 8130); -- 


REPLACE INTO npcskills VALUES (1778,4304,1);
UPDATE npc SET level=83,hp=4716,mp=2168 WHERE id=1778; -- Total HP=14150 & strong/feeble type skill was 4304, so a mult of 3 was applied
INSERT INTO `droplist` VALUES  (1778, 57, 4220, 8440, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1778, 1895, 1, 1, 0, 100000); -- 
INSERT INTO `droplist` VALUES (1778, 4042, 1, 1, 0, 32258); -- 
INSERT INTO `droplist` VALUES (1778, 4043, 1, 1, 0, 21739); -- 
INSERT INTO `droplist` VALUES (1778, 6346, 1, 1, 0, 21739); -- 
INSERT INTO `droplist` VALUES (1778, 4040, 1, 1, 0, 10989); -- 
INSERT INTO `droplist` VALUES (1778, 6342, 1, 1, 0, 10989); -- 


REPLACE INTO npcskills VALUES (1779,4303,1);
UPDATE npc SET level=80,hp=4551,mp=2043 WHERE id=1779; -- Total HP=9102 & strong/feeble type skill was 4303, so a mult of 2 was applied
INSERT INTO `droplist` VALUES (1779, 57, 2570, 5140, 0, 700000); -- Adena
INSERT INTO `droplist` VALUES (1779, 1344, 10, 30, 0, 333333); -- 
INSERT INTO `droplist` VALUES (1779, 4041, 1, 1, 0, 13889); -- 
INSERT INTO `droplist` VALUES (1779, 4044, 1, 1, 0, 6993); -- 
INSERT INTO `droplist` VALUES (1779, 4039, 1, 1, 0, 6993); -- 
INSERT INTO `droplist` VALUES (1779, 1894, 1, 1, 0, 6993); --