Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord

[SHARE] Usefull SQL scripts v4

EdenEternal
 Share

Recommended Posts

EdenEternal Newbie

EdenEternal

Posted
Posted

Hello Maxcheaters!

I'm Opening this topic because old one have reached 25000 characters and i can't add no more sql scripts...

 

Old Topics:

[sHARE] Usefull SQL scripts

[sHARE] Usefull SQL scripts V2

[sHARE] Usefull SQL scripts v3

 

Let's Start

 

Top-No Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

 

Top-D Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

Top-C Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

Top-B Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

Top-A Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

Top-S Grade items on Newbie Character Spawn

 

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);
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);
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);
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);
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);
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);
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);
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);
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);

 

Replace All 75 Lvl And Upper lvl Mobs spawnlist With your Mob

UPDATE spawnlist SET `npc_templateid`="YOUR_MOB_ID" WHERE `npc_templateid` IN (SELECT id FROM npc WHERE type = 'L2Monster' and level <= '75');

 

Delete from items all weapons/armor/jewelery what is enchanted upper when +31

DELETE FROM items WHERE item_id IN (SELECT item_id FROM weapon) AND enchant_level <= "31";
DELETE FROM items WHERE item_id IN (SELECT item_id FROM armor) AND enchant_level <= "31";

 

Set all Weapons enchant to +25 of character that is in inventory

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);

 

Resurrect All Grand Bosses

UPDATE grandboss_data SET status="1";

 

Mobs No more will be Aggresive

UPDATE npc SET aggro="0" WHERE type="L2Monster";

 

Make all Items Sellable/dropable/tradeable/destroyable

UPDATE armor SET sellable="true";
UPDATE armor SET dropable="true";
UPDATE armor SET destroyable="true";
UPDATE armor SET tradeable="true";
UPDATE weapon SET sellable="true";
UPDATE weapon SET dropable="true";
UPDATE weapon SET destroyable="true";
UPDATE weapon SET tradeable="true";
UPDATE etcitem SET sellable="true";
UPDATE etcitem SET dropable="true";
UPDATE etcitem SET destroyable="true";
UPDATE etcitem SET tradeable="true";

 

All Characters can Craft

 

UPDATE char_templates SET canCraft="1";

 

Replace with your gatekeeper all retail gatekeepers

 

UPDATE spawnlist SET npc_templateid="7777" WHERE npc_templateid IN (SELECT id FROM npc WHERE type="L2Teleporter" AND title="Gatekeeper");

 

Change Castle owne Clan Leader name color

 

UPDATE characters SET name_color="COLOR_CODE" WHERE obj_id IN (SELECT leader_id FROM clan_data WHERE hasCastle="Castle_ID");

 

you want to know how many adenas is in your server?

 

SELECT item_id, SUM(count) FROM items WHERE item_id=57 GROUP BY item_id;

 

If Some1 have sql script and want to share just contact

Link to comment
Share on other sites
EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 21/07/2010

 

Replace All 75 Lvl And Upper lvl Mobs spawnlist With your Mob

UPDATE spawnlist SET `npc_templateid`="YOUR_MOB_ID" WHERE `npc_templateid` IN (SELECT id FROM npc WHERE type = 'L2Monster' and level <= '75');

Link to comment
Share on other sites
EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 22/07/2010

 

Delete from items all weapons/armor/jewelery what is enchanted upper when +31

DELETE FROM items WHERE item_id IN (SELECT item_id FROM weapon) AND enchant_level <= "31";
DELETE FROM items WHERE item_id IN (SELECT item_id FROM armor) AND enchant_level <= "31";

Link to comment
Share on other sites
EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

You can make sql for new char lvl??To have custom start level??If yes share it please!

no with sql script it's impossible... you can make with java code

http://www.maxcheaters.com/forum/index.php?topic=46604.msg326004#msg326004

Link to comment
Share on other sites
EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 22/07/2010

 

Set all Weapons enchant to +25 of character that is in inventory

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);

 

 

NOT TESTED! please post if it's working

Link to comment
Share on other sites
Magaiveris Newbie

Magaiveris

Posted
Posted

Updated 22/07/2010

 

Set all Weapons enchant to +25 of character that is in inventory

 

NOT TESTED! please post if it's working

 

It's really 100% working dude ! :) I tested it ! Thanks Very great work !

 

 

If Anyone want to adapt this for armor use it.

 

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 armor);

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing


  • Posts

    • djvogans
      [L2OFF ]Lineage2DEX.com Autumn Season x25

      By djvogans · Posted

      /data/attachments/4/4519-0e10f165cf34562cd44d346d47967752.jpg Dear friends! September 27 we start Event for Olympiad games on Open Beta server Start Olympiad games in 19:00 (UTC +3) September 27 Fights will be till 23:40, then we get Heroes (after 00:00) All who get Hero status, will receive 500 ToDs. Best 5 Hero, who will get the most PTS, will get 800 ToDs instead of 500. ToDs you will get on your Master Account balance No class vs class fights Enchant Level Restrictions: S gr +6, A gr + 7, C/B gr + 16. On Olympiad, all items that higher than restriction level will be removed, and you won't be able to use them or wear them Talent Tree avaible only Tier 1 (same like will be on 1st Oly cycle on Live server) Skill enchant lvl: 15 max for 2nd profession, 7 for 3rd profession - its global rules for all Beta Good luck to Everyone!  
    • Salty Mike
      Buying Eternity autofarm Like for L2jMobius Autofarm

      By Salty Mike · Posted

      I'm currently working on an advanced auto-farm compatible with older chronicles (C4, IL, HF, etc) and older L2J-Mobius builds. https://imgur.com/a/LJS2OMC
    • gamezbd
      Gamez Aion 4.6 Classic Server

      By gamezbd · Posted

      GamezAION 4.8 High Quality Relaunch Coming Friday 4th October 2024   All Latest Retail Skin Appearances Unique RvR Battlegrounds (Guardian) (Battle of Gods) Added New PvPvE Map with Seasonal Ranking System Active Anticheat System & Shugo Console Support   Download links available on website   https://gamezaion.com Join the Action!
    • ExistO
      Lin2Age NOSTALGIA

      By ExistO · Posted

      🌟 Step Into Lin2Age C4 – Your Nostalgic Journey Awaits! 🌟 Get ready for an unforgettable adventure filled with fierce battles ⚔️, mighty clans 👑, and epic quests 🌍! Lin2Age is a custom Lineage 2 server designed to bring you the ultimate classic experience, enriched with modern features. Whether you're a battle-hardened veteran or a fresh-faced newcomer, there's a place for everyone in our world! 🛡️✨   🔥 Why Lin2Age is Your Best Choice 🔥 ✅ Dynamic Events & Rewards: Enjoy thrilling features like TVT, Magic Roulette, Daily Rewards, measures to enhance your gameplay. ✅ Advanced Security Features: Enjoy robust protections with Anti-Bot measures, Password Lock, and Raid Boss Information to keep your adventures safe and secure. ✅ Balanced Gameplay for All: Dive into a harmonious blend of PvP, PvE, and crafting! Lin2Age combines the finest elements from Scions of Destiny MasterWork and Interlude, ensuring an immersive experience for every playstyle! 🛡️⚔️ ✅ Epic Gear & AIO Buffer: Equip Legendary Armor and powerful jewels! Our All-In-One Buffer is at your service, empowering you to dominate the battlefield! 💎💪 ✅ Unique Custom Features: Embark on exclusive quests 📜 and take on formidable raid bosses 🐉! Lin2Age is filled with thrilling content that keeps your adventures lively and exciting. 🎯🎮 ✅ Thriving Community: Join a vibrant community where teamwork and friendship thrive! Whether leading a clan or joining one, support is always at your fingertips! 🤝👑 ✅ Regular Updates & Events: Experience continuous excitement! With frequent updates, fresh custom content, and epic events, Lin2Age is always evolving, thanks to your invaluable feedback! 🔄🏆 ✅ Smooth, Lag-Free Experience: Enjoy uninterrupted gameplay on our top-tier servers—say goodbye to lag! 🚀⚡   💎 Fair Play Above All 💎 At Lin2Age, we champion a balanced and equitable gaming experience. Our No Pay-to-Win policy ensures that success comes from skill, strategy, and teamwork, not your wallet! 💪 Everything you need to thrive can be earned through quests, crafting, and epic battles! 🏆🎮   🔑 Key Features You’ll Love 🔑 🔹 Rates: EXP x45, SP x45, ADENA x300—meticulously balanced for your enjoyment! 🔹 Custom Classes & Skills: Discover unique classes and skills that make PvP combat dynamic! ⚔️ 🔹 Epic Raid Bosses: Challenge yourself against custom bosses for legendary loot! 💀🏹 🔹 Clan Wars & Sieges: Test your strength in exhilarating clan wars and castle sieges! 🏰⚔️ 🔹 Dedicated Support Team: Our active Game Masters are committed to ensuring fairness and smooth gameplay! 👥🛡️ ⚔️ Join the Lin2Age Beta Test – Adventurers Needed! 🛡️ Are you ready to experience the glory of Lineage 2, reimagined for a new generation? 🌍 Become part of our exclusive beta test and help shape the future of Lin2Age! 🚀✨ Start your epic journey today. Welcome to Lin2Age C4! 💬 Connect with Us on Discord Join our community, stay updated, and take part in the latest events! Discord: https://discord.gg/qKJnQ7Kp5X Youtube: https://www.youtube.com/watch?v=nnO-J_uAqvg https://prnt.sc/b3tRHlxT6YS7
    • Porthos
      Buying Eternity autofarm Like for L2jMobius Autofarm

      By Porthos · Posted

      Mobius already has auto-play.

  • Topics

×
×
  • Create New...