API tools faq
paste
Advertisement
Guest User

SQL Scripts from MaxCheaters.com By Dymek84

a guest
Nov 11th, 2010
1,002
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 67.74 KB | None | 0 0
raw download clone embed print report
  1.  
  2. #Top-No Grade items ON Newbie CHARACTER Spawn
  3. ##Code:
  4. REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
  5. REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
  6. REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
  7. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
  8. REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
  9. REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
  10. REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
  11. REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
  12. REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);
  13.  
  14.  
  15. #Top-D Grade items ON Newbie CHARACTER Spawn
  16. #Code:
  17. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 395, 2424, 2448, 417,225);
  18. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 395, 2424, 2448, 417,225);
  19. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 395, 2424, 2448, 417,225);
  20. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 395, 2424, 2448, 417, 2499);
  21. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082426, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 395, 2424, 2448, 417, 2499);
  22. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 437, 470, 2450, 2426, 188);
  23. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 437, 470, 2450, 2426, 188);
  24. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 437, 470, 2450, 2426, 188);
  25. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 437, 470, 2450, 2426, 188);
  26.  
  27. #Top-C Grade items ON Newbie CHARACTER Spawn
  28. #Code:
  29. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);
  30. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);
  31. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);
  32. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);
  33. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);
  34. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);
  35. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);
  36. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);
  37. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);
  38.  
  39. #Top-B Grade items ON Newbie CHARACTER Spawn
  40. #Code:
  41. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2392, 5739, 5723, 2417,6359);
  42. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2392, 5739, 5723, 2417,6359);
  43. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2392, 5739, 5723, 2417,6359);
  44. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2392, 5739, 5723, 2417, 4719);
  45. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082415, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2392, 5739, 5723, 2417, 4719);
  46. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5732, 5716, 2406, 2415, 7722);
  47. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5732, 5716, 2406, 2415, 7722);
  48. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5732, 5716, 2406, 2415, 7722);
  49. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5732, 5716, 2406, 2415, 7722);
  50.  
  51. #Top-A Grade items ON Newbie CHARACTER Spawn
  52. #Code:
  53. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2395, 5787, 5775, 2419,8682);
  54. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2395, 5787, 5775, 2419,8682);
  55. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2395, 5787, 5775, 2419,8682);
  56. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2395, 5787, 5775, 2419, 8788);
  57. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2395, 5787, 5775, 2419, 8788);
  58. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 5643);
  59. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 5643);
  60. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 5643);
  61. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 5643);
  62.  
  63. #Top-S Grade items ON Newbie CHARACTER Spawn
  64. #Code:
  65. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
  66. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
  67. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
  68. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
  69. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1086386, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
  70. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 6385, 6384, 6383, 6386, 6608);
  71. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 6385, 6384, 6383, 6386, 6608);
  72. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 6385, 6384, 6383, 6386, 6608);
  73. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 6385, 6384, 6383, 6386, 6608);
  74.  
  75. #Replace ALL 75 Lvl AND UPPER lvl Mobs spawnlist WITH your Mob
  76. #Code:
  77. UPDATE spawnlist SET `npc_templateid`="YOUR_MOB_ID" WHERE `npc_templateid` IN (SELECT id FROM npc WHERE TYPE = 'L2Monster' AND level <= '75');
  78.  
  79. #Delete FROM items ALL weapons/armor/jewelery what IS enchanted UPPER WHEN +31
  80. #Code:
  81. DELETE FROM items WHERE item_id IN (SELECT item_id FROM weapon) AND enchant_level <= "31";
  82. DELETE FROM items WHERE item_id IN (SELECT item_id FROM armor) AND enchant_level <= "31";
  83.  
  84. #Set ALL Weapons enchant TO +25 OF CHARACTER that IS IN inventory
  85. ##Quote
  86. UPDATE items SET `enchant_level`="25" WHERE `owner_id` IN (SELECT obj_Id FROM characters WHERE `char_name`="CHARACTER_NAME") AND `loc`="INVENTORY" AND `item_id` IN (SELECT item_id FROM weapon);
  87.  
  88. #Resurrect ALL Grand Bosses
  89. #Code:
  90. UPDATE grandboss_data SET STATUS="1";
  91.  
  92. #Mobs No more will be Aggresive
  93. #Code:
  94. UPDATE npc SET aggro="0" WHERE TYPE="L2Monster";
  95.  
  96. #Make ALL Items Sellable/dropable/tradeable/destroyable
  97. #Code:
  98. UPDATE armor SET sellable="true";
  99. UPDATE armor SET dropable="true";
  100. UPDATE armor SET destroyable="true";
  101. UPDATE armor SET tradeable="true";
  102. UPDATE weapon SET sellable="true";
  103. UPDATE weapon SET dropable="true";
  104. UPDATE weapon SET destroyable="true";
  105. UPDATE weapon SET tradeable="true";
  106. UPDATE etcitem SET sellable="true";
  107. UPDATE etcitem SET dropable="true";
  108. UPDATE etcitem SET destroyable="true";
  109. UPDATE etcitem SET tradeable="true";
  110.  
  111. #All Characters can Craft
  112. #Code:
  113. UPDATE char_templates SET canCraft="1";
  114.  
  115. #Replace WITH your gatekeeper ALL retail gatekeepers
  116. #Code:
  117. UPDATE spawnlist SET npc_templateid="7777" WHERE npc_templateid IN (SELECT id FROM npc WHERE TYPE="L2Teleporter" AND title="Gatekeeper");
  118.  
  119. #Change Castle owne Clan Leader name color
  120. ##Quote
  121. UPDATE characters SET name_color="COLOR_CODE" WHERE obj_id IN (SELECT leader_id FROM clan_data WHERE hasCastle="Castle_ID");
  122.  
  123. #you want TO know how many adenas IS IN your server?
  124. #Code:
  125. SELECT item_id, SUM(COUNT) FROM items WHERE item_id=57 GROUP BY item_id;
  126.  
  127. #Give NEW Characters Items:
  128. #Mages:Arcana Mace & DC Robe SET
  129. #Fighters:Angel Slayer & Drac Light SET
  130. #Code:
  131. REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
  132. REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
  133. REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
  134. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
  135. REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
  136. REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 6608);
  137. REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 6608);
  138. REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 6608);
  139. REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 6608);
  140.  
  141. #Delete FROM droplist ALL resources
  142. #Code:
  143. DELETE FROM droplist WHERE itemId='1864';
  144. DELETE FROM droplist WHERE itemId='1865';
  145. DELETE FROM droplist WHERE itemId='1866';
  146. DELETE FROM droplist WHERE itemId='1868';
  147. DELETE FROM droplist WHERE itemId='1869';
  148. DELETE FROM droplist WHERE itemId='1870';
  149. DELETE FROM droplist WHERE itemId='1871';
  150. DELETE FROM droplist WHERE itemId='1872';
  151. DELETE FROM droplist WHERE itemId='1873';
  152. DELETE FROM droplist WHERE itemId='1874';
  153. DELETE FROM droplist WHERE itemId='1875';
  154. DELETE FROM droplist WHERE itemId='1876';
  155. DELETE FROM droplist WHERE itemId='1877';
  156. DELETE FROM droplist WHERE itemId='1878';
  157. DELETE FROM droplist WHERE itemId='1879';
  158. DELETE FROM droplist WHERE itemId='1880';
  159. DELETE FROM droplist WHERE itemId='1881';
  160. DELETE FROM droplist WHERE itemId='1882';
  161. DELETE FROM droplist WHERE itemId='1884';
  162. DELETE FROM droplist WHERE itemId='1885';
  163. DELETE FROM droplist WHERE itemId='1895';
  164. DELETE FROM droplist WHERE itemId='5549';
  165. DELETE FROM droplist WHERE itemId='1886';
  166. DELETE FROM droplist WHERE itemId='1887';
  167. DELETE FROM droplist WHERE itemId='1888';
  168. DELETE FROM droplist WHERE itemId='1890';
  169. DELETE FROM droplist WHERE itemId='1891';
  170. DELETE FROM droplist WHERE itemId='1892';
  171. DELETE FROM droplist WHERE itemId='1893';
  172. DELETE FROM droplist WHERE itemId='1889';
  173. DELETE FROM droplist WHERE itemId='1894';
  174. DELETE FROM droplist WHERE itemId='4039';
  175. DELETE FROM droplist WHERE itemId='4040';
  176. DELETE FROM droplist WHERE itemId='4041';
  177. DELETE FROM droplist WHERE itemId='4042';
  178. DELETE FROM droplist WHERE itemId='4043';
  179. DELETE FROM droplist WHERE itemId='4044';
  180. DELETE FROM droplist WHERE itemId='4046';
  181. DELETE FROM droplist WHERE itemId='4047';
  182. DELETE FROM droplist WHERE itemId='4045';
  183. DELETE FROM droplist WHERE itemId='5550';
  184. DELETE FROM droplist WHERE itemId='4048';
  185.  
  186. #Arrows
  187. #Code:
  188. DELETE FROM droplist WHERE itemId='17';
  189. DELETE FROM droplist WHERE itemId='1341';
  190. DELETE FROM droplist WHERE itemId='1342';
  191. DELETE FROM droplist WHERE itemId='1343';
  192. DELETE FROM droplist WHERE itemId='1344';
  193. DELETE FROM droplist WHERE itemId='1345';
  194. DELETE FROM droplist WHERE itemId='4048';
  195.  
  196. #Potions
  197. #Code:
  198. DELETE FROM droplist WHERE itemId='1539';
  199. DELETE FROM droplist WHERE itemId='5591';
  200. DELETE FROM droplist WHERE itemId='5592';
  201.  
  202. #Cursed Bone
  203. #Code:
  204. DELETE FROM droplist WHERE itemId='2508';
  205.  
  206. #SoE
  207. #Code:
  208. DELETE FROM droplist WHERE itemId='736';
  209. DELETE FROM droplist WHERE itemId='1829';
  210. DELETE FROM droplist WHERE itemId='1830';
  211. DELETE FROM droplist WHERE itemId='737';
  212. DELETE FROM droplist WHERE itemId='1538';
  213.  
  214. #Books,Amulets
  215. #Code:
  216. DELETE FROM `droplist` WHERE `itemId`=1047;
  217. DELETE FROM `droplist` WHERE `itemId`=1048;
  218. DELETE FROM `droplist` WHERE `itemId`=1049;
  219. DELETE FROM `droplist` WHERE `itemId`=1050;
  220. DELETE FROM `droplist` WHERE `itemId`=1047;
  221. DELETE FROM `droplist` WHERE `itemId`=1050;
  222. DELETE FROM `droplist` WHERE `itemId`=1051;
  223. DELETE FROM `droplist` WHERE `itemId`=1052;
  224. DELETE FROM `droplist` WHERE `itemId`=1053;
  225. DELETE FROM `droplist` WHERE `itemId`=1054;
  226. DELETE FROM `droplist` WHERE `itemId`=1055;
  227. DELETE FROM `droplist` WHERE `itemId`=1056;
  228. DELETE FROM `droplist` WHERE `itemId`=1057;
  229. DELETE FROM `droplist` WHERE `itemId`=1058;
  230. DELETE FROM `droplist` WHERE `itemId`=1059;
  231. DELETE FROM `droplist` WHERE `itemId`=1095;
  232. DELETE FROM `droplist` WHERE `itemId`=1096;
  233. DELETE FROM `droplist` WHERE `itemId`=1097;
  234. DELETE FROM `droplist` WHERE `itemId`=1098;
  235. DELETE FROM `droplist` WHERE `itemId`=1099;
  236. DELETE FROM `droplist` WHERE `itemId`=1150;
  237. DELETE FROM `droplist` WHERE `itemId`=1151;
  238. DELETE FROM `droplist` WHERE `itemId`=1152;
  239. DELETE FROM `droplist` WHERE `itemId`=1377;
  240. DELETE FROM `droplist` WHERE `itemId`=1378;
  241. DELETE FROM `droplist` WHERE `itemId`=1379;
  242. DELETE FROM `droplist` WHERE `itemId`=1380;
  243. DELETE FROM `droplist` WHERE `itemId`=1380;
  244. DELETE FROM `droplist` WHERE `itemId`=1382;
  245. DELETE FROM `droplist` WHERE `itemId`=1383;
  246. DELETE FROM `droplist` WHERE `itemId`=1384;
  247. DELETE FROM `droplist` WHERE `itemId`=1385;
  248. DELETE FROM `droplist` WHERE `itemId`=1386;
  249. DELETE FROM `droplist` WHERE `itemId`=1387;
  250. DELETE FROM `droplist` WHERE `itemId`=1388;
  251. DELETE FROM `droplist` WHERE `itemId`=1389;
  252. DELETE FROM `droplist` WHERE `itemId`=1390;
  253. DELETE FROM `droplist` WHERE `itemId`=1391;
  254. DELETE FROM `droplist` WHERE `itemId`=1392;
  255. DELETE FROM `droplist` WHERE `itemId`=1393;
  256. DELETE FROM `droplist` WHERE `itemId`=1394;
  257. DELETE FROM `droplist` WHERE `itemId`=1395;
  258. DELETE FROM `droplist` WHERE `itemId`=1396;
  259. DELETE FROM `droplist` WHERE `itemId`=1397;
  260. DELETE FROM `droplist` WHERE `itemId`=1398;
  261. DELETE FROM `droplist` WHERE `itemId`=1399;
  262. DELETE FROM `droplist` WHERE `itemId`=1400;
  263. DELETE FROM `droplist` WHERE `itemId`=1401;
  264. DELETE FROM `droplist` WHERE `itemId`=1402;
  265. DELETE FROM `droplist` WHERE `itemId`=1403;
  266. DELETE FROM `droplist` WHERE `itemId`=1404;
  267. DELETE FROM `droplist` WHERE `itemId`=1405;
  268. DELETE FROM `droplist` WHERE `itemId`=1406;
  269. DELETE FROM `droplist` WHERE `itemId`=1407;
  270. DELETE FROM `droplist` WHERE `itemId`=1408;
  271. DELETE FROM `droplist` WHERE `itemId`=1409;
  272. DELETE FROM `droplist` WHERE `itemId`=1410;
  273. DELETE FROM `droplist` WHERE `itemId`=1411;
  274. DELETE FROM `droplist` WHERE `itemId`=1412;
  275. DELETE FROM `droplist` WHERE `itemId`=1413;
  276. DELETE FROM `droplist` WHERE `itemId`=1414;
  277. DELETE FROM `droplist` WHERE `itemId`=1415;
  278. DELETE FROM `droplist` WHERE `itemId`=1416;
  279. DELETE FROM `droplist` WHERE `itemId`=1417;
  280. DELETE FROM `droplist` WHERE `itemId`=1418;
  281. DELETE FROM `droplist` WHERE `itemId`=1512;
  282. DELETE FROM `droplist` WHERE `itemId`=1513;
  283. DELETE FROM `droplist` WHERE `itemId`=1514;
  284. DELETE FROM `droplist` WHERE `itemId`=1516;
  285. DELETE FROM `droplist` WHERE `itemId`=1515;
  286. DELETE FROM `droplist` WHERE `itemId`=1517;
  287. DELETE FROM `droplist` WHERE `itemId`=1518;
  288. DELETE FROM `droplist` WHERE `itemId`=1519;
  289. DELETE FROM `droplist` WHERE `itemId`=1520;
  290. DELETE FROM `droplist` WHERE `itemId`=1521;
  291. DELETE FROM `droplist` WHERE `itemId`=1522;
  292. DELETE FROM `droplist` WHERE `itemId`=1523;
  293. DELETE FROM `droplist` WHERE `itemId`=1524;
  294. DELETE FROM `droplist` WHERE `itemId`=1525;
  295. DELETE FROM `droplist` WHERE `itemId`=1526;
  296. DELETE FROM `droplist` WHERE `itemId`=1527;
  297. DELETE FROM `droplist` WHERE `itemId`=1528;
  298. DELETE FROM `droplist` WHERE `itemId`=1528;
  299. DELETE FROM `droplist` WHERE `itemId`=1530;
  300. DELETE FROM `droplist` WHERE `itemId`=1531;
  301. DELETE FROM `droplist` WHERE `itemId`=1532;
  302. DELETE FROM `droplist` WHERE `itemId`=1533;
  303. DELETE FROM `droplist` WHERE `itemId`=1534;
  304. DELETE FROM `droplist` WHERE `itemId`=1535;
  305. DELETE FROM `droplist` WHERE `itemId`=1536;
  306. DELETE FROM `droplist` WHERE `itemId`=1537;
  307. DELETE FROM `droplist` WHERE `itemId`=1667;
  308. DELETE FROM `droplist` WHERE `itemId`=1668;
  309. DELETE FROM `droplist` WHERE `itemId`=1669;
  310. DELETE FROM `droplist` WHERE `itemId`=1670;
  311. DELETE FROM `droplist` WHERE `itemId`=1671;
  312. DELETE FROM `droplist` WHERE `itemId`=1856;
  313. DELETE FROM `droplist` WHERE `itemId`=3038;
  314. DELETE FROM `droplist` WHERE `itemId`=3039;
  315. DELETE FROM `droplist` WHERE `itemId`=3040;
  316. DELETE FROM `droplist` WHERE `itemId`=3041;
  317. DELETE FROM `droplist` WHERE `itemId`=3042;
  318. DELETE FROM `droplist` WHERE `itemId`=3043;
  319. DELETE FROM `droplist` WHERE `itemId`=3044;
  320. DELETE FROM `droplist` WHERE `itemId`=3045;
  321. DELETE FROM `droplist` WHERE `itemId`=3046;
  322. DELETE FROM `droplist` WHERE `itemId`=3047;
  323. DELETE FROM `droplist` WHERE `itemId`=3048;
  324. DELETE FROM `droplist` WHERE `itemId`=3049;
  325. DELETE FROM `droplist` WHERE `itemId`=3050;
  326. DELETE FROM `droplist` WHERE `itemId`=3051;
  327. DELETE FROM `droplist` WHERE `itemId`=3052;
  328. DELETE FROM `droplist` WHERE `itemId`=3053;
  329. DELETE FROM `droplist` WHERE `itemId`=3054;
  330. DELETE FROM `droplist` WHERE `itemId`=3055;
  331. DELETE FROM `droplist` WHERE `itemId`=3056;
  332. DELETE FROM `droplist` WHERE `itemId`=3057;
  333. DELETE FROM `droplist` WHERE `itemId`=3058;
  334. DELETE FROM `droplist` WHERE `itemId`=3059;
  335. DELETE FROM `droplist` WHERE `itemId`=3060;
  336. DELETE FROM `droplist` WHERE `itemId`=3061;
  337. DELETE FROM `droplist` WHERE `itemId`=3062;
  338. DELETE FROM `droplist` WHERE `itemId`=3063;
  339. DELETE FROM `droplist` WHERE `itemId`=3064;
  340. DELETE FROM `droplist` WHERE `itemId`=3065;
  341. DELETE FROM `droplist` WHERE `itemId`=3066;
  342. DELETE FROM `droplist` WHERE `itemId`=3067;
  343. DELETE FROM `droplist` WHERE `itemId`=3068;
  344. DELETE FROM `droplist` WHERE `itemId`=3069;
  345. DELETE FROM `droplist` WHERE `itemId`=3070;
  346. DELETE FROM `droplist` WHERE `itemId`=3071;
  347. DELETE FROM `droplist` WHERE `itemId`=3072;
  348. DELETE FROM `droplist` WHERE `itemId`=3073;
  349. DELETE FROM `droplist` WHERE `itemId`=3074;
  350. DELETE FROM `droplist` WHERE `itemId`=3075;
  351. DELETE FROM `droplist` WHERE `itemId`=3076;
  352. DELETE FROM `droplist` WHERE `itemId`=3077;
  353. DELETE FROM `droplist` WHERE `itemId`=3078;
  354. DELETE FROM `droplist` WHERE `itemId`=3079;
  355. DELETE FROM `droplist` WHERE `itemId`=3080;
  356. DELETE FROM `droplist` WHERE `itemId`=3081;
  357. DELETE FROM `droplist` WHERE `itemId`=3082;
  358. DELETE FROM `droplist` WHERE `itemId`=3083;
  359. DELETE FROM `droplist` WHERE `itemId`=3084;
  360. DELETE FROM `droplist` WHERE `itemId`=3085;
  361. DELETE FROM `droplist` WHERE `itemId`=3086;
  362. DELETE FROM `droplist` WHERE `itemId`=3087;
  363. DELETE FROM `droplist` WHERE `itemId`=3088;
  364. DELETE FROM `droplist` WHERE `itemId`=3089;
  365. DELETE FROM `droplist` WHERE `itemId`=3090;
  366. DELETE FROM `droplist` WHERE `itemId`=3091;
  367. DELETE FROM `droplist` WHERE `itemId`=3092;
  368. DELETE FROM `droplist` WHERE `itemId`=3093;
  369. DELETE FROM `droplist` WHERE `itemId`=3094;
  370. DELETE FROM `droplist` WHERE `itemId`=3095;
  371. DELETE FROM `droplist` WHERE `itemId`=3096;
  372. DELETE FROM `droplist` WHERE `itemId`=3097;
  373. DELETE FROM `droplist` WHERE `itemId`=3098;
  374. DELETE FROM `droplist` WHERE `itemId`=3099;
  375. DELETE FROM `droplist` WHERE `itemId`=3100;
  376. DELETE FROM `droplist` WHERE `itemId`=3101;
  377. DELETE FROM `droplist` WHERE `itemId`=3102;
  378. DELETE FROM `droplist` WHERE `itemId`=3103;
  379. DELETE FROM `droplist` WHERE `itemId`=3104;
  380. DELETE FROM `droplist` WHERE `itemId`=3105;
  381. DELETE FROM `droplist` WHERE `itemId`=3106;
  382. DELETE FROM `droplist` WHERE `itemId`=3107;
  383. DELETE FROM `droplist` WHERE `itemId`=3108;
  384. DELETE FROM `droplist` WHERE `itemId`=3109;
  385. DELETE FROM `droplist` WHERE `itemId`=3110;
  386. DELETE FROM `droplist` WHERE `itemId`=3111;
  387. DELETE FROM `droplist` WHERE `itemId`=3112;
  388. DELETE FROM `droplist` WHERE `itemId`=3113;
  389. DELETE FROM `droplist` WHERE `itemId`=3114;
  390. DELETE FROM `droplist` WHERE `itemId`=3115;
  391. DELETE FROM `droplist` WHERE `itemId`=3116;
  392. DELETE FROM `droplist` WHERE `itemId`=3117;
  393. DELETE FROM `droplist` WHERE `itemId`=3118;
  394. DELETE FROM `droplist` WHERE `itemId`=3429;
  395. DELETE FROM `droplist` WHERE `itemId`=3430;
  396. DELETE FROM `droplist` WHERE `itemId`=3431;
  397. DELETE FROM `droplist` WHERE `itemId`=3432;
  398. DELETE FROM `droplist` WHERE `itemId`=3941;
  399. DELETE FROM `droplist` WHERE `itemId`=3942;
  400. DELETE FROM `droplist` WHERE `itemId`=3944;
  401. DELETE FROM `droplist` WHERE `itemId`=4200;
  402. DELETE FROM `droplist` WHERE `itemId`=4201;
  403. DELETE FROM `droplist` WHERE `itemId`=4202;
  404. DELETE FROM `droplist` WHERE `itemId`=4203;
  405. DELETE FROM `droplist` WHERE `itemId`=4206;
  406. DELETE FROM `droplist` WHERE `itemId`=4207;
  407. DELETE FROM `droplist` WHERE `itemId`=4208;
  408. DELETE FROM `droplist` WHERE `itemId`=4906;
  409. DELETE FROM `droplist` WHERE `itemId`=4907;
  410. DELETE FROM `droplist` WHERE `itemId`=4908;
  411. DELETE FROM `droplist` WHERE `itemId`=4909;
  412. DELETE FROM `droplist` WHERE `itemId`=4910;
  413. DELETE FROM `droplist` WHERE `itemId`=4911;
  414. DELETE FROM `droplist` WHERE `itemId`=4912;
  415. DELETE FROM `droplist` WHERE `itemId`=4913;
  416. DELETE FROM `droplist` WHERE `itemId`=4914;
  417. DELETE FROM `droplist` WHERE `itemId`=4916;
  418. DELETE FROM `droplist` WHERE `itemId`=4917;
  419. DELETE FROM `droplist` WHERE `itemId`=4918;
  420. DELETE FROM `droplist` WHERE `itemId`=4919;
  421. DELETE FROM `droplist` WHERE `itemId`=4920;
  422. DELETE FROM `droplist` WHERE `itemId`=4922;
  423. DELETE FROM `droplist` WHERE `itemId`=4923;
  424. DELETE FROM `droplist` WHERE `itemId`=4924;
  425. DELETE FROM `droplist` WHERE `itemId`=4928;
  426. DELETE FROM `droplist` WHERE `itemId`=4929;
  427. DELETE FROM `droplist` WHERE `itemId`=4930;
  428. DELETE FROM `droplist` WHERE `itemId`=4931;
  429. DELETE FROM `droplist` WHERE `itemId`=4932;
  430. DELETE FROM `droplist` WHERE `itemId`=4933;
  431. DELETE FROM `droplist` WHERE `itemId`=4934;
  432. DELETE FROM `droplist` WHERE `itemId`=4935;
  433. DELETE FROM `droplist` WHERE `itemId`=5013;
  434. DELETE FROM `droplist` WHERE `itemId`=5014;
  435. DELETE FROM `droplist` WHERE `itemId`=5015;
  436. DELETE FROM `droplist` WHERE `itemId`=5809;
  437. DELETE FROM `droplist` WHERE `itemId`=5810;
  438. DELETE FROM `droplist` WHERE `itemId`=5811;
  439. DELETE FROM `droplist` WHERE `itemId`=5812;
  440. DELETE FROM `droplist` WHERE `itemId`=5813;
  441. DELETE FROM `droplist` WHERE `itemId`=5814;
  442. DELETE FROM `droplist` WHERE `itemId`=5815;
  443. DELETE FROM `droplist` WHERE `itemId`=5816;
  444. DELETE FROM `droplist` WHERE `itemId`=6350;
  445. DELETE FROM `droplist` WHERE `itemId`=6351;
  446. DELETE FROM `droplist` WHERE `itemId`=6352;
  447. DELETE FROM `droplist` WHERE `itemId`=6395;
  448. DELETE FROM `droplist` WHERE `itemId`=6396;
  449. DELETE FROM `droplist` WHERE `itemId`=6397;
  450. DELETE FROM `droplist` WHERE `itemId`=6398;
  451. DELETE FROM `droplist` WHERE `itemId`=7638;
  452. DELETE FROM `droplist` WHERE `itemId`=7639;
  453. DELETE FROM `droplist` WHERE `itemId`=7640;
  454. DELETE FROM `droplist` WHERE `itemId`=7641;
  455. DELETE FROM `droplist` WHERE `itemId`=7642;
  456. DELETE FROM `droplist` WHERE `itemId`=7643;
  457. DELETE FROM `droplist` WHERE `itemId`=7644;
  458. DELETE FROM `droplist` WHERE `itemId`=7645;
  459. DELETE FROM `droplist` WHERE `itemId`=7646;
  460. DELETE FROM `droplist` WHERE `itemId`=7647;
  461. DELETE FROM `droplist` WHERE `itemId`=7648;
  462. DELETE FROM `droplist` WHERE `itemId`=7649;
  463. DELETE FROM `droplist` WHERE `itemId`=7650;
  464. DELETE FROM `droplist` WHERE `itemId`=7651;
  465. DELETE FROM `droplist` WHERE `itemId`=7652;
  466. DELETE FROM `droplist` WHERE `itemId`=7653;
  467. DELETE FROM `droplist` WHERE `itemId`=7654;
  468. DELETE FROM `droplist` WHERE `itemId`=7655;
  469. DELETE FROM `droplist` WHERE `itemId`=7656;
  470. DELETE FROM `droplist` WHERE `itemId`=7657;
  471. DELETE FROM `droplist` WHERE `itemId`=7658;
  472. DELETE FROM `droplist` WHERE `itemId`=7659;
  473. DELETE FROM `droplist` WHERE `itemId`=7660;
  474. DELETE FROM `droplist` WHERE `itemId`=7661;
  475. DELETE FROM `droplist` WHERE `itemId`=7652;
  476. DELETE FROM `droplist` WHERE `itemId`=7663;
  477. DELETE FROM `droplist` WHERE `itemId`=7664;
  478. DELETE FROM `droplist` WHERE `itemId`=7665;
  479. DELETE FROM `droplist` WHERE `itemId`=7666;
  480. DELETE FROM `droplist` WHERE `itemId`=7667;
  481. DELETE FROM `droplist` WHERE `itemId`=7668;
  482. DELETE FROM `droplist` WHERE `itemId`=7669;
  483. DELETE FROM `droplist` WHERE `itemId`=7670;
  484. DELETE FROM `droplist` WHERE `itemId`=7671;
  485. DELETE FROM `droplist` WHERE `itemId`=7672;
  486. DELETE FROM `droplist` WHERE `itemId`=7673;
  487. DELETE FROM `droplist` WHERE `itemId`=7674;
  488. DELETE FROM `droplist` WHERE `itemId`=7675;
  489. DELETE FROM `droplist` WHERE `itemId`=7676;
  490. DELETE FROM `droplist` WHERE `itemId`=7835;
  491. DELETE FROM `droplist` WHERE `itemId`=8380;
  492. DELETE FROM `droplist` WHERE `itemId`=8381;
  493. DELETE FROM `droplist` WHERE `itemId`=8382;
  494. DELETE FROM `droplist` WHERE `itemId`=8383;
  495. DELETE FROM `droplist` WHERE `itemId`=8384;
  496. DELETE FROM `droplist` WHERE `itemId`=8385;
  497. DELETE FROM `droplist` WHERE `itemId`=8386;
  498. DELETE FROM `droplist` WHERE `itemId`=8387;
  499. DELETE FROM `droplist` WHERE `itemId`=8388;
  500. DELETE FROM `droplist` WHERE `itemId`=8389;
  501. DELETE FROM `droplist` WHERE `itemId`=8390;
  502. DELETE FROM `droplist` WHERE `itemId`=8391;
  503. DELETE FROM `droplist` WHERE `itemId`=8392;
  504. DELETE FROM `droplist` WHERE `itemId`=8393;
  505. DELETE FROM `droplist` WHERE `itemId`=8394;
  506. DELETE FROM `droplist` WHERE `itemId`=8395;
  507. DELETE FROM `droplist` WHERE `itemId`=8396;
  508. DELETE FROM `droplist` WHERE `itemId`=8397;
  509. DELETE FROM `droplist` WHERE `itemId`=8398;
  510. DELETE FROM `droplist` WHERE `itemId`=8399;
  511. DELETE FROM `droplist` WHERE `itemId`=8400;
  512. DELETE FROM `droplist` WHERE `itemId`=8401;
  513. DELETE FROM `droplist` WHERE `itemId`=8402;
  514. DELETE FROM `droplist` WHERE `itemId`=8616;
  515. DELETE FROM `droplist` WHERE `itemId`=8617;
  516. DELETE FROM `droplist` WHERE `itemId`=8877;
  517. DELETE FROM `droplist` WHERE `itemId`=8878;
  518. DELETE FROM `droplist` WHERE `itemId`=8879;
  519. DELETE FROM `droplist` WHERE `itemId`=8880;
  520. DELETE FROM `droplist` WHERE `itemId`=8881;
  521. DELETE FROM `droplist` WHERE `itemId`=8882;
  522. DELETE FROM `droplist` WHERE `itemId`=8883;
  523. DELETE FROM `droplist` WHERE `itemId`=8884;
  524. DELETE FROM `droplist` WHERE `itemId`=8885;
  525. DELETE FROM `droplist` WHERE `itemId`=8886;
  526. DELETE FROM `droplist` WHERE `itemId`=8888;
  527. DELETE FROM `droplist` WHERE `itemId`=8889;
  528. DELETE FROM `droplist` WHERE `itemId`=8890;
  529. DELETE FROM `droplist` WHERE `itemId`=8891;
  530. DELETE FROM `droplist` WHERE `itemId`=8945;
  531. DELETE FROM `droplist` WHERE `itemId`=8946;
  532.  
  533. #SQL Scripts FOR DELETE item FROM droplist
  534. ##Quote
  535. DELETE FROM `droplist` WHERE `itemId`=Item_Id;
  536.  
  537. #Delete FROM droplist ALL items EXCEPT Adena,Coin OF Luck AND RB Jewelery
  538. #Code:
  539. DELETE FROM droplist WHERE itemId NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656);
  540.  
  541. #All Mobs Droping 1-10 kk Adena
  542. #Code:
  543. UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
  544. UPDATE `droplist` SET `droplist`.`max`=10000000 WHERE `droplist`.`itemId`=57;
  545.  
  546. #Set MIN Respawn TIME 1 HOUR AND MAX Respawn TIME 2 HOUR FOR Raidboss
  547. #Code:
  548. UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
  549. UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';
  550.  
  551. #Add Skill RETURN TO ALL Newbie Characters
  552. #Code:
  553. INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1);
  554. INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1);
  555. INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1);
  556. INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1);
  557. INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1);
  558. INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1);
  559. INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1);
  560. INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1);
  561. INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1);
  562. INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1);
  563. INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1);
  564.  
  565. #Give ALL Clan Skills TO Clan
  566. #Code:
  567. INSERT INTO `clan_skills` VALUES
  568. ('id clana','370','3','Clan Vitality'),
  569. ('id clana','371','3','Clan Spirituality'),
  570. ('id clana','372','3','Clan Essence'),
  571. ('id clana','373','3','Clan Lifeblood'),
  572. ('id clana','374','3','Clan Morale'),
  573. ('id clana','375','3','Clan  Clarity'),
  574. ('id clana','376','3','Clan  Might'),
  575. ('id clana','377','3','Clan Aegis'),
  576. ('id clana','378','3','Clan Empowerment'),
  577. ('id clana','379','3','Clan Magic Protection'),
  578. ('id clana','380','3','Clan Guidance'),
  579. ('id clana','381','3','Clan Agility'),
  580. ('id clana','382','3','Clan Withstand-Attack'),
  581. ('id clana','383','3','Clan Shield Boost'),
  582. ('id clana','384','3','Clan Cyclonic Resistance'),
  583. ('id clana','385','3','Clan Magmatic Resistance'),
  584. ('id clana','386','3','Clan Fortitude'),
  585. ('id clana','387','3','Clan Freedom'),
  586. ('id clana','388','3','Clan Vigilance'),
  587. ('id clana','389','3','Clan March'),
  588. ('id clana','390','3','Clan Luck'),
  589. ('id clana','391','1','Clan Imperium');
  590.  
  591. #Delete FROM Server ALL DATA OF CHARACTER that IS NOT active more THEN 1 MONTH.
  592. #Code:
  593. DELETE FROM characters WHERE lastAccess < 155520000;
  594. DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  595. DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  596. DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  597. DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  598. DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  599. DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
  600.  
  601. #Delete ALL Retail Mobs [Thx FOR Idea HouLiGaN]
  602. #Code:
  603. DELETE FROM spawnlist WHERE `npc_templateid` IN (SELECT id FROM npc WHERE TYPE = 'L2Monster');
  604. Thx TO badriniki
  605.  
  606. #0 Weight FOR items/armors/weapons:
  607. #Code:
  608. UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
  609. UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
  610. UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);
  611.  
  612. #Drop Adena 100%:
  613. #Code:
  614. UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
  615.  
  616. #When you sell, everything will cost 0 adena:
  617. #Code:
  618. UPDATE `armor` SET price=0 WHERE price > 1;
  619. UPDATE `etcitem` SET price=0 WHERE price > 1;
  620. UPDATE `weapon` SET price=0 WHERE price > 1;
  621.  
  622. #Update ALL RaidBoss 5000k hp:
  623. #Code:
  624. UPDATE `armor` SET price=0 WHERE price > 1;
  625. UPDATE `etcitem` SET price=0 WHERE price > 1;
  626. UPDATE `weapon` SET price=0 WHERE price > 1;
  627.  
  628. #Update ALL RaidBoss 5000k hp:
  629. #Code:
  630. UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.TYPE='L2Raidboss';
  631.  
  632. #Delete ALL mobs UNDER 40 lvl:
  633. #Code:
  634. DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.TYPE='L2Monster';
  635.  
  636. #Delete ALL materials AND recipes FROM db:
  637. #Code:
  638. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );
  639.  
  640. #Increase DROP rate FOR recipes:
  641. #Code:
  642. UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE TYPE='recipe');
  643.  
  644. #Delete characters AND accounts IF they do NOT CONNECT FOR 3 months:
  645. #Code:
  646. DELETE FROM characters WHERE lastAccess < 466560000;
  647. DELETE FROM accounts WHERE lastactive < 466560000;
  648.  
  649. #Add FOR ALL monsters IN DROP: Coins
  650. #Code:
  651. INSERT INTO droplist (mobId, itemid, chance, MIN, MAX,category) SELECT id, 4037, 1000000, 1, 1, 52 FROM npc WHERE TYPE='L2Monster';
  652.  
  653. #Top No-Grade IN START:(Need TO modif FOR kamaels)
  654. #Code:
  655. REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
  656. REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
  657. REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
  658. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
  659. REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
  660. REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
  661. REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
  662. REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
  663. REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);
  664.  
  665. #Add RaidBoss jewels IF you have deleted them:
  666. #Code:
  667. INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
  668. INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
  669. INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
  670. INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
  671. INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
  672. INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
  673. INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');
  674.  
  675. #Thx TO 1tm
  676.  
  677. #Delete ALL spellbooks FROM db:
  678. #Code:
  679. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );
  680.  
  681. #Increases Guards (p.def, m.def, p.atk, hp) BY 50%:
  682. #Code:
  683. UPDATE npc SET pdef = pdef * 1.5 WHERE TYPE = 'L2Guard';
  684. UPDATE npc SET hp = hp * 1.5 WHERE TYPE = 'L2Guard';
  685. UPDATE npc SET patk = patk * 1.5 WHERE TYPE = 'L2Guard';
  686. UPDATE npc SET mdef = mdef * 1.5 WHERE TYPE = 'L2Guard';
  687.  
  688. #Decreases Raidboss defense BY 40%:
  689. #Code:
  690. UPDATE npc SET pdef = pdef * 0.6 WHERE TYPE = 'L2RaidBoss';
  691. UPDATE npc SET hp = hp * 0.6 WHERE TYPE = 'L2RaidBoss';
  692. UPDATE npc SET mdef = mdef * 0.6 WHERE TYPE = 'L2RaidBoss';
  693.  
  694. #All NEW player chars spawn loc:
  695. #Code:
  696. UPDATE char_templates SET x=yourXcoordinate;
  697. UPDATE char_templates SET y=yourYcoordinate;
  698. UPDATE char_templates SET z=yourZcoordinate;
  699.  
  700. #Increases ALL chars p.def/m.def BY 10%:
  701. #Code:
  702. UPDATE char_templates SET P_DEF = P_DEF * 1.1;
  703. UPDATE char_templates SET M_DEF = M_DEF * 1.1;
  704.  
  705. #Increases ALL chars speed BY 20%:
  706. #Code:
  707. UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;
  708.  
  709. #Increases ALL chars CP. At 20lv BY 22%, at 40lv BY 44%, at 76lv BY 66%:
  710. #Code:
  711. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
  712. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
  713. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';
  714.  
  715. #MP rengerates 10 times more(unlimited mp):
  716. #Code:
  717. UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
  718.  
  719. #Teleports cost 0 adena:
  720. #Code:
  721. UPDATE teleport SET price=0;
  722.  
  723. #Create common item skill DELETE:
  724. #Code:
  725. DELETE FROM skill_trees WHERE skill_id = 1320;
  726. DELETE FROM skill_trees WHERE skill_id = 1322;
  727.  
  728. #Grade penality DELETE:
  729. #Code:
  730. DELETE FROM skill_trees WHERE skill_id = 239;
  731.  
  732. #Raidbosses always spawns WITH 70% hp:
  733. #Code:
  734. UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;
  735.  
  736. #Dies adding price reduced TO 5 adena (OR increased TO 100kk):
  737. #Code:
  738. UPDATE henna SET price=5;
  739.  
  740. #Newbie npc buffer buffes ALL buffs FROM 1lv TO 62lv:
  741. #Code:
  742. UPDATE helper_buff_list SET lower_level=1;
  743. UPDATE helper_buff_list SET upper_level=62;
  744.  
  745. #To enchant skill doesn't need exp/sp:
  746. #Code:
  747. UPDATE enchant_skill_trees SET sp=0;
  748. UPDATE enchant_skill_trees SET exp=0;
  749.  
  750. #Wooden/Devotion set, best non weapons, soulshots pack, extra gloves/boots in start:
  751. #Code:
  752. UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753;
  753. #-- kamael soe for simple soe (x10)
  754.  
  755.  
  756. UPDATE char_creation_items SET itemId='219' WHERE itemId = 10;
  757. #-- starting dagger for Sword Breaker
  758. UPDATE char_creation_items SET itemId='311' WHERE itemId = 6;
  759. #-- starting wand for Crucifix of Blessing
  760. UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;
  761. #-- starting sword for Falchion
  762. UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;
  763. #-- starting fists for Viper Fang
  764. UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;
  765. #- starting fists for Flanged Mace
  766.  
  767.  
  768. UPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;
  769. #-- starting mystics armor for Devotion armor
  770. UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;
  771. #-- starting mystics armor for Devotion armor
  772.  
  773. UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;
  774. #-- starting fifghers armor for Wooden armor
  775. UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147;
  776. #-- starting fifghers armor for Wooden armor
  777.  
  778.  
  779. INSERT INTO char_creation_items VALUES (0,43,1,'TRUE');
  780. #-- Wooden set helm
  781. INSERT INTO char_creation_items VALUES (18,43,1,'TRUE');
  782. #-- Wooden set helm
  783. INSERT INTO char_creation_items VALUES (31,43,1,'TRUE');
  784. #-- Wooden set helm
  785. INSERT INTO char_creation_items VALUES (44,43,1,'TRUE');
  786. #-- Wooden set helm
  787. INSERT INTO char_creation_items VALUES (53,43,1,'TRUE');
  788. #-- Wooden set helm
  789. INSERT INTO char_creation_items VALUES (123,43,1,'TRUE');
  790. ##- Wooden set helm
  791. INSERT INTO char_creation_items VALUES (124,43,1,'TRUE');
  792. #-- Wooden set helm
  793.  
  794. INSERT INTO char_creation_items VALUES (10,44,1,'TRUE');
  795. #-- Devotion set helm
  796. INSERT INTO char_creation_items VALUES (25,44,1,'TRUE');
  797. #-- Devotion set helm
  798. INSERT INTO char_creation_items VALUES (38,44,1,'TRUE');
  799. #-- Devotion set helm
  800. INSERT INTO char_creation_items VALUES (49,44,1,'TRUE');
  801. #-- Devotion set helm
  802.  
  803.  
  804. INSERT INTO char_creation_items VALUES (0,5590,1,'TRUE');
  805. #-- Random Boots (id:5590 - Squeaking Shoes)
  806. INSERT INTO char_creation_items VALUES (18,5590,1,'TRUE');
  807. #-- Random Boots (id:5590 - Squeaking Shoes)
  808. INSERT INTO char_creation_items VALUES (31,5590,1,'TRUE');
  809. #-- Random Boots (id:5590 - Squeaking Shoes)
  810. INSERT INTO char_creation_items VALUES (44,5590,1,'TRUE');
  811. #-- Random Boots (id:5590 - Squeaking Shoes)
  812. INSERT INTO char_creation_items VALUES (53,5590,1,'TRUE');
  813. #-- Random Boots (id:5590 - Squeaking Shoes)
  814. INSERT INTO char_creation_items VALUES (123,5590,1,'TRUE');
  815. #-- Random Boots (id:5590 - Squeaking Shoes)
  816. INSERT INTO char_creation_items VALUES (124,5590,1,'TRUE');
  817. #-- Random Boots (id:5590 - Squeaking Shoes)
  818.  
  819. INSERT INTO char_creation_items VALUES (10,5590,1,'TRUE');
  820. #-- Random Boots (id:5590 - Squeaking Shoes)
  821. INSERT INTO char_creation_items VALUES (25,5590,1,'TRUE');
  822. #-- Random Boots (id:5590 - Squeaking Shoes)
  823. INSERT INTO char_creation_items VALUES (38,5590,1,'TRUE');
  824. #-- Random Boots (id:5590 - Squeaking Shoes)
  825. INSERT INTO char_creation_items VALUES (49,5590,1,'TRUE');
  826. #-- Random Boots (id:5590 - Squeaking Shoes)
  827.  
  828.  
  829. INSERT INTO char_creation_items VALUES (0,51,1,'TRUE');
  830. #-- Random gloves (id:51 - Bracer Gloves)
  831. INSERT INTO char_creation_items VALUES (18,51,1,'TRUE');
  832. #-- Random gloves (id:51 - Bracer Gloves)
  833. INSERT INTO char_creation_items VALUES (31,51,1,'TRUE');
  834. #-- Random gloves id:51 - Bracer Gloves)
  835. INSERT INTO char_creation_items VALUES (44,51,1,'TRUE');
  836. #-- Random gloves (id:51 - Bracer Gloves)
  837. INSERT INTO char_creation_items VALUES (53,51,1,'TRUE');
  838. #-- Random gloves (id:51 - Bracer Gloves)
  839. INSERT INTO char_creation_items VALUES (123,51,1,'TRUE');
  840. #-- Random gloves (id:51 - Bracer Gloves)
  841. INSERT INTO char_creation_items VALUES (124,51,1,'TRUE');
  842. #-- Random gloves (id:51 - Bracer Gloves)
  843.  
  844. INSERT INTO char_creation_items VALUES (10,51,1,'TRUE');
  845. #-- Random gloves (id:51 - Bracer Gloves)
  846. INSERT INTO char_creation_items VALUES (25,51,1,'TRUE');
  847. #-- Random gloves (id:51 - Bracer Gloves)
  848. INSERT INTO char_creation_items VALUES (38,51,1,'TRUE');
  849. #-- Random gloves id:51 - Bracer Gloves)
  850. INSERT INTO char_creation_items VALUES (49,51,1,'TRUE');
  851. #-- Random gloves (id:51 - Bracer Gloves)
  852.  
  853.  
  854. INSERT INTO char_creation_items VALUES (0,5250,2,'TRUE');
  855. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  856. INSERT INTO char_creation_items VALUES (18,5250,2,'TRUE');
  857. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  858. INSERT INTO char_creation_items VALUES (31,5250,2,'TRUE');
  859. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  860. INSERT INTO char_creation_items VALUES (44,5250,2,'TRUE');
  861. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  862. INSERT INTO char_creation_items VALUES (53,5250,2,'TRUE');
  863. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  864. INSERT INTO char_creation_items VALUES (123,5250,2,'TRUE');
  865. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  866. INSERT INTO char_creation_items VALUES (124,5250,2,'TRUE');
  867. #-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
  868.  
  869. INSERT INTO char_creation_items VALUES (10,5262,1,'FALSE');
  870. #-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
  871. INSERT INTO char_creation_items VALUES (25,5262,1,'FALSE');
  872. #-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
  873. INSERT INTO char_creation_items VALUES (38,5262,1,'FALSE');
  874. #-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
  875. INSERT INTO char_creation_items VALUES (49,5262,1,'FALSE');
  876. #-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
  877.  
  878.  
  879. #Auto server restart:
  880.  
  881. #Every week..
  882. #Code:
  883. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");
  884. #Every two days..
  885. #Code:
  886. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");
  887. #Every 24h..
  888. #Code:
  889. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");
  890. #Every 12h..
  891. #Code:
  892. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");
  893. #Every 6h..
  894. #Code:
  895. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");
  896. #Every 3h..
  897. #Code:
  898. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");
  899.  
  900. #Thx to Leki
  901.  
  902. #Custom Spawn in Giran Castle Town & items.(For Fighters Theca Leather Armor Set and Crystal Dagger .For Mystics Karmian Robe Set and Homunkulus's Sword)
  903. #Code:
  904. UPDATE `char_templates` SET `x` = '83400',
  905. `y` = '147943',
  906. `z` = '-3404';
  907. UPDATE `char_templates` SET `items1` = '420',
  908. `items2` = '400',
  909. `items3` = '2436',
  910. `items4` = '6358',
  911. `items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
  912. UPDATE `char_templates` SET `items1` = '420',
  913. `items2` = '400',
  914. `items3` = '2436',
  915. `items4` = '6358',
  916. `items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
  917. UPDATE `char_templates` SET `items1` = '420',
  918. `items2` = '400',
  919. `items3` = '2436',
  920. `items4` = '6358',
  921. `items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
  922. UPDATE `char_templates` SET `items1` = '420',
  923. `items2` = '400',
  924. `items3` = '2436',
  925. `items4` = '6358',
  926. `items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
  927. UPDATE `char_templates` SET `items1` = '420',
  928. `items2` = '400',
  929. `items3` = '2436',
  930. `items4` = '6358',
  931. `items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
  932. UPDATE `char_templates` SET `items1` = '439',
  933. `items2` = '471',
  934. `items3` = '2430',
  935. `items4` = '2454',
  936. `items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
  937. UPDATE `char_templates` SET `items1` = '439',
  938. `items2` = '471',
  939. `items3` = '2430',
  940. `items4` = '2454',
  941. `items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
  942. UPDATE `char_templates` SET `items1` = '439',
  943. `items2` = '471',
  944. `items3` = '2430',
  945. `items4` = '2454',
  946. `items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
  947. UPDATE `char_templates` SET `items1` = '439',
  948. `items2` = '471',
  949. `items3` = '2430',
  950. `items4` = '2454',
  951. `items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;
  952.  
  953. #2x more(Str,INT,Dex,Wit,Men,Con)
  954. #Code:
  955. UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40');
  956. UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
  957. UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
  958. UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
  959. UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
  960. UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
  961. UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
  962. UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
  963. UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
  964. UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
  965. UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
  966. UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
  967. UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
  968. UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
  969. UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
  970. UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
  971. UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
  972. UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
  973. UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
  974. UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
  975. UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
  976. UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
  977. UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
  978. UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
  979. UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
  980. UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
  981. UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
  982. UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
  983. UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
  984. UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
  985. UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
  986. UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
  987. UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
  988. UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
  989. UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
  990. UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
  991. UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
  992. UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
  993. UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
  994. UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
  995. UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
  996. UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
  997. UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
  998. UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
  999. UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
  1000. UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
  1001. UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
  1002. UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
  1003. UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
  1004. UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
  1005. UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
  1006. UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
  1007. UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
  1008. UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');
  1009.  
  1010. #Make ALL raidboss 80 lvl!
  1011. #Code:
  1012. UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss"
  1013.  
  1014. #Grandboss
  1015. #Code:
  1016. UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss"
  1017.  
  1018. #Customize your guards
  1019. #Code:
  1020. UPDATE npc SET level='85' WHERE TYPE='L2Guard';
  1021. UPDATE npc SET hp='30000' WHERE TYPE='L2Guard';
  1022. UPDATE npc SET mp='30000' WHERE TYPE='L2Guard';
  1023. UPDATE npc SET patk='30000' WHERE TYPE='L2Guard';
  1024. UPDATE npc SET pdef='10000' WHERE TYPE='L2Guard';
  1025. UPDATE npc SET mdef='10000' WHERE TYPE='L2Guard';
  1026. UPDATE npc SET title='Customized Guard' WHERE TYPE='L2Guard';
  1027. UPDATE npc SET serverSideTitle='1' WHERE TYPE='L2Guard';
  1028. UPDATE npc SET serverSideTitle='1' WHERE TYPE='L2Guard';
  1029. UPDATE npc SET rhand='0' WHERE TYPE='L2Guard';
  1030. UPDATE npc SET lhand='0' WHERE TYPE='L2Guard';
  1031. UPDATE npc SET runspd='300' WHERE TYPE='L2Guard';
  1032. UPDATE npc SET ss='1' WHERE TYPE='L2Guard';
  1033. UPDATE npc SET bss='1' WHERE TYPE='L2Guard';
  1034. UPDATE npc SET ss_rate='100' WHERE TYPE='L2Guard';
  1035. UPDATE npc SET attackrange='100' WHERE TYPE='L2Guard';
  1036. UPDATE npc SET aggro='5000' WHERE TYPE='L2Guard';
  1037. UPDATE npc SET str='100' WHERE TYPE='L2Guard';
  1038. UPDATE npc SET con='100' WHERE TYPE='L2Guard';
  1039. UPDATE npc SET dex='100' WHERE TYPE='L2Guard';
  1040. UPDATE npc SET wit='100' WHERE TYPE='L2Guard';
  1041. UPDATE npc SET men='100' WHERE TYPE='L2Guard';
  1042. UPDATE npc SET str='100' WHERE TYPE='L2Guard';
  1043.  
  1044. #Make ALL the pets stronger
  1045. #Code:
  1046. UPDATE `npc` SET `hp` = `hp` * 1.5 WHERE TYPE='L2Pet';
  1047. UPDATE `npc` SET `mp` = `mp` * 1.5 WHERE TYPE='L2Pet';
  1048. UPDATE `npc` SET `patk` = `patk` * 1.5 WHERE TYPE='L2Pet';
  1049. UPDATE `npc` SET `matk` = `matk` * 1.5 WHERE TYPE='L2Pet';
  1050. UPDATE `npc` SET `pdef` = `pdef` * 1.5 WHERE TYPE='L2Pet';
  1051. UPDATE `npc` SET `mdef` = `mdef` * 1.5 WHERE TYPE='L2Pet';
  1052. UPDATE `npc` SET `runspd` = `runspd` * 1.5 WHERE TYPE='L2Pet';
  1053.  
  1054. #Delete Monsters LOWER 51 Lvl
  1055. #Code:
  1056. DELETE spawnlist FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<51 AND npc.TYPE="L2Monster";
  1057.  
  1058. #Full DATABASE DELETE
  1059. #Code:
  1060. DROP DATABASE `Database_name`;
  1061.  
  1062. #Delete FROM droplist ALL items EXCEPT 57 AND 4037(OR that items you want)
  1063. #Code:
  1064. DELETE FROM droplist WHERE itemId NOT IN (57,4037);
  1065.  
  1066. #Thx TO kikboxer
  1067.  
  1068. #Removal OF ALL things WITH defined ID at the certain CHARACTER.
  1069. #Code:
  1070. DELETE * FROM items WHERE item_id=(item id) AND owner_id=(CHARACTER id)
  1071.  
  1072. #Display OF ALL things defined CHARACTER.
  1073. #Code:
  1074. #mysql> SELECT a.name,"armor",a.crystal_type,i.COUNT,i.enchant_level FROM armor a, items i WHERE a.item_id=i.item_id AND i.owner_id=?????? UNION SELECT a.name,"weapon",a.crystal_type,i.COUNT,i.enchant_level FROM weapon a, items i WHERE a.item_id=i.item_id AND i.owner_id=?????? UNION SELECT a.name,"some",a.crystal_type,i.COUNT,i.enchant_level FROM etcitem a, items i WHERE a.item_id=i.item_id AND i.owner_id=CHARACTER id;
  1075.  
  1076.  
  1077. #0 Weight FOR items/armors/weapons:
  1078. ##Quote
  1079. UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
  1080. UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
  1081. UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);
  1082.  
  1083. #Drop Adena 100%:
  1084. #Quote
  1085. UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
  1086.  
  1087. #When you sell, everything will cost 0 adena:
  1088. #Quote
  1089. UPDATE `armor` SET price=0 WHERE price > 1;
  1090. UPDATE `etcitem` SET price=0 WHERE price > 1;
  1091. UPDATE `weapon` SET price=0 WHERE price > 1;
  1092.  
  1093. #Update ALL RaidBoss 5000k hp:
  1094. #Quote
  1095. UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.TYPE='L2Raidboss';
  1096.  
  1097. #Delete ALL mobs UNDER 40 lvl:
  1098. #Quote
  1099. DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.TYPE='L2Monster';
  1100.  
  1101. #Delete ALL materials AND recipes FROM db:
  1102. ##Quote
  1103. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );
  1104.  
  1105. #Increase DROP rate FOR recipes:
  1106. #Quote
  1107. UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE TYPE='recipe');
  1108.  
  1109. #Delete characters AND accounts IF they do NOT CONNECT FOR 3 months:
  1110. #Quote
  1111. DELETE FROM characters WHERE lastAccess < 466560000;
  1112. DELETE FROM accounts WHERE lastactive < 466560000;
  1113.  
  1114. #Add FOR ALL monsters IN DROP: Coins
  1115. #Quote
  1116. INSERT INTO droplist (mobId, itemid, chance, MIN, MAX,category) SELECT id, 4037, 1000000, 1, 1, 52 FROM npc WHERE TYPE='L2Monster';
  1117.  
  1118. #Top No-Grade IN START:(Need TO modif FOR kamaels)
  1119. #Quote
  1120. REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
  1121. REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
  1122. REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
  1123. REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
  1124. REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
  1125. REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
  1126. REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
  1127. REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
  1128. REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);
  1129.  
  1130. #Add RaidBoss jewels IF you have deleted them:
  1131. #Quote
  1132. INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
  1133. INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
  1134. INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
  1135. INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
  1136. INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
  1137. INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
  1138. INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');
  1139.  
  1140. #Thx TO 1tm
  1141. #Delete ALL spellbooks FROM db:
  1142. #Code:
  1143. DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );
  1144.  
  1145. #Increases Guards (p.def, m.def, p.atk, hp) BY 50%:
  1146. #Code:
  1147. UPDATE npc SET pdef = pdef * 1.5 WHERE TYPE = 'L2Guard';
  1148. UPDATE npc SET hp = hp * 1.5 WHERE TYPE = 'L2Guard';
  1149. UPDATE npc SET patk = patk * 1.5 WHERE TYPE = 'L2Guard';
  1150. UPDATE npc SET mdef = mdef * 1.5 WHERE TYPE = 'L2Guard';
  1151.  
  1152. #Decreases Raidboss defense BY 40%:
  1153. #Code:
  1154. UPDATE npc SET pdef = pdef * 0.6 WHERE TYPE = 'L2RaidBoss';
  1155. UPDATE npc SET hp = hp * 0.6 WHERE TYPE = 'L2RaidBoss';
  1156. UPDATE npc SET mdef = mdef * 0.6 WHERE TYPE = 'L2RaidBoss';
  1157.  
  1158. #All NEW player chars spawn loc:
  1159. #Code:
  1160. UPDATE char_templates SET x=yourXcoordinate;
  1161. UPDATE char_templates SET y=yourYcoordinate;
  1162. UPDATE char_templates SET z=yourZcoordinate;
  1163.  
  1164. #Increases ALL chars p.def/m.def BY 10%:
  1165. #Code:
  1166. UPDATE char_templates SET P_DEF = P_DEF * 1.1;
  1167. UPDATE char_templates SET M_DEF = M_DEF * 1.1;
  1168.  
  1169. #Increases ALL chars speed BY 20%:
  1170. #Code:
  1171. UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;
  1172.  
  1173. #Increases ALL chars CP. At 20lv BY 22%, at 40lv BY 44%, at 76lv BY 66%:
  1174. #This one good one FOR longer pvps..
  1175. #Code:
  1176. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
  1177. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
  1178. UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';
  1179.  
  1180. #MP rengerates 10 times more(unlimited mp):
  1181. #Good one FOR high servers who has mp potions etc..
  1182. #Code:
  1183. UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
  1184.  
  1185. #Teleports cost 0 adena:
  1186. #Code:
  1187. UPDATE teleport SET price=0;
  1188.  
  1189. #Create common item skill DELETE:
  1190. #It used AS bug at olympiad, WITH it you can buff WITH soes, mental dagers etc IN secs...
  1191. #Code:
  1192. DELETE FROM skill_trees WHERE skill_id = 1320;
  1193. DELETE FROM skill_trees WHERE skill_id = 1322;
  1194.  
  1195. #Grade penality DELETE:
  1196. #Disables grade penality...
  1197. #Code:
  1198. DELETE FROM skill_trees WHERE skill_id = 239;
  1199.  
  1200. #Raidbosses always spawns WITH 70% hp:
  1201. #More realistic that NEW spawned rb has NOT FULL hp. Good one FOR organized clans OR parties...
  1202. #Code:
  1203. UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;
  1204.  
  1205. #Dies adding price reduced TO 5 adena (OR increased TO 100kk):
  1206. #Good one FOR faction servers.
  1207. #Code:
  1208. UPDATE henna SET price=5;
  1209. #..OR TO 100kk (good one FOR high rates servers).
  1210. #Code:
  1211. UPDATE henna SET price=100000000;
  1212.  
  1213. #Newbie npc buffer buffes ALL buffs FROM 1lv TO 62lv:
  1214. #Really USE FULL newbie characters TO have ALL buffs FROM 1lv (IF yuo want U may CHANGE UPPER level TO 85, FOR daily bufer).
  1215. #Code:
  1216. UPDATE helper_buff_list SET lower_level=1;
  1217. UPDATE helper_buff_list SET upper_level=62;
  1218.  
  1219. #To enchant skill doesn't need exp/sp:
  1220. #Good one for high rates servers or faction servers..
  1221. #Code:
  1222. UPDATE enchant_skill_trees SET sp=0;
  1223. UPDATE enchant_skill_trees SET exp=0;
  1224.  
  1225. #Auto server restart:
  1226. #Every week..
  1227. #Code:
  1228. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");
  1229. #Every two days..
  1230. #Code:
  1231. #NSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");
  1232. #Every 24h..
  1233. #Code:
  1234. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");
  1235. #Every 12h..
  1236. #Code:
  1237. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");
  1238. #Every 6h..
  1239. #Code:
  1240. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");
  1241. #Every 3h..
  1242. #Code:
  1243. INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");
  1244.  
  1245. #Thx to lekino
  1246. #Custom Spawn in Giran Castle Town & items.(For Fighters Theca Leather Armor Set and Crystal Dagger .For Mystics Karmian Robe Set and Homunkulus's Sword)
  1247. ##Code:
  1248. UPDATE `char_templates` SET `x` = '83400',
  1249. `y` = '147943',
  1250. `z` = '-3404';
  1251. UPDATE `char_templates` SET `items1` = '420',
  1252. `items2` = '400',
  1253. `items3` = '2436',
  1254. `items4` = '6358',
  1255. `items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
  1256. UPDATE `char_templates` SET `items1` = '420',
  1257. `items2` = '400',
  1258. `items3` = '2436',
  1259. `items4` = '6358',
  1260. `items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
  1261. UPDATE `char_templates` SET `items1` = '420',
  1262. `items2` = '400',
  1263. `items3` = '2436',
  1264. `items4` = '6358',
  1265. `items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
  1266. UPDATE `char_templates` SET `items1` = '420',
  1267. `items2` = '400',
  1268. `items3` = '2436',
  1269. `items4` = '6358',
  1270. `items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
  1271. UPDATE `char_templates` SET `items1` = '420',
  1272. `items2` = '400',
  1273. `items3` = '2436',
  1274. `items4` = '6358',
  1275. `items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
  1276. UPDATE `char_templates` SET `items1` = '439',
  1277. `items2` = '471',
  1278. `items3` = '2430',
  1279. `items4` = '2454',
  1280. `items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
  1281. UPDATE `char_templates` SET `items1` = '439',
  1282. `items2` = '471',
  1283. `items3` = '2430',
  1284. `items4` = '2454',
  1285. `items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
  1286. UPDATE `char_templates` SET `items1` = '439',
  1287. `items2` = '471',
  1288. `items3` = '2430',
  1289. `items4` = '2454',
  1290. `items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
  1291. UPDATE `char_templates` SET `items1` = '439',
  1292. `items2` = '471',
  1293. `items3` = '2430',
  1294. `items4` = '2454',
  1295. `items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;
  1296.  
  1297. #Hope this will help you a little
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!