Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[SHARE] Usefull SQL scripts v3

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

 

Let's Start

 

Thx to Leki

 

Give New Characters Items:

Mages:Arcana Mace & DC Robe Set

Fighters:Angel Slayer & Drac Light Set

 

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, 108512, -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", 5779, 5767, 2407, 512, 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, 5779, 5767, 2407, 512, 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", 5779, 5767, 2407, 512, 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", 5779, 5767, 2407, 512, 6608);

 

Delete from droplist all resources

 

DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1868';
DELETE FROM droplist WHERE itemId='1869';
DELETE FROM droplist WHERE itemId='1870';
DELETE FROM droplist WHERE itemId='1871';
DELETE FROM droplist WHERE itemId='1872';
DELETE FROM droplist WHERE itemId='1873';
DELETE FROM droplist WHERE itemId='1874';
DELETE FROM droplist WHERE itemId='1875';
DELETE FROM droplist WHERE itemId='1876';
DELETE FROM droplist WHERE itemId='1877';
DELETE FROM droplist WHERE itemId='1878';
DELETE FROM droplist WHERE itemId='1879';
DELETE FROM droplist WHERE itemId='1880';
DELETE FROM droplist WHERE itemId='1881';
DELETE FROM droplist WHERE itemId='1882';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1895';
DELETE FROM droplist WHERE itemId='5549';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1890';
DELETE FROM droplist WHERE itemId='1891';
DELETE FROM droplist WHERE itemId='1892';
DELETE FROM droplist WHERE itemId='1893';
DELETE FROM droplist WHERE itemId='1889';
DELETE FROM droplist WHERE itemId='1894';
DELETE FROM droplist WHERE itemId='4039';
DELETE FROM droplist WHERE itemId='4040';
DELETE FROM droplist WHERE itemId='4041';
DELETE FROM droplist WHERE itemId='4042';
DELETE FROM droplist WHERE itemId='4043';
DELETE FROM droplist WHERE itemId='4044';
DELETE FROM droplist WHERE itemId='4046';
DELETE FROM droplist WHERE itemId='4047';
DELETE FROM droplist WHERE itemId='4045';
DELETE FROM droplist WHERE itemId='5550';
DELETE FROM droplist WHERE itemId='4048';

 

Arrows

 

DELETE FROM droplist WHERE itemId='17';
DELETE FROM droplist WHERE itemId='1341';
DELETE FROM droplist WHERE itemId='1342';
DELETE FROM droplist WHERE itemId='1343';
DELETE FROM droplist WHERE itemId='1344';
DELETE FROM droplist WHERE itemId='1345';
DELETE FROM droplist WHERE itemId='4048';

 

Potions

 

DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';

 

Cursed Bone

 

DELETE FROM droplist WHERE itemId='2508';

 

SoE

 

DELETE FROM droplist WHERE itemId='736';
DELETE FROM droplist WHERE itemId='1829';
DELETE FROM droplist WHERE itemId='1830';
DELETE FROM droplist WHERE itemId='737';
DELETE FROM droplist WHERE itemId='1538';

 

Books,Amulets

 

DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1048;
DELETE FROM `droplist` WHERE `itemId`=1049;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1051;
DELETE FROM `droplist` WHERE `itemId`=1052;
DELETE FROM `droplist` WHERE `itemId`=1053;
DELETE FROM `droplist` WHERE `itemId`=1054;
DELETE FROM `droplist` WHERE `itemId`=1055;
DELETE FROM `droplist` WHERE `itemId`=1056;
DELETE FROM `droplist` WHERE `itemId`=1057;
DELETE FROM `droplist` WHERE `itemId`=1058;
DELETE FROM `droplist` WHERE `itemId`=1059;
DELETE FROM `droplist` WHERE `itemId`=1095;
DELETE FROM `droplist` WHERE `itemId`=1096;
DELETE FROM `droplist` WHERE `itemId`=1097;
DELETE FROM `droplist` WHERE `itemId`=1098;
DELETE FROM `droplist` WHERE `itemId`=1099;
DELETE FROM `droplist` WHERE `itemId`=1150;
DELETE FROM `droplist` WHERE `itemId`=1151;
DELETE FROM `droplist` WHERE `itemId`=1152;
DELETE FROM `droplist` WHERE `itemId`=1377;
DELETE FROM `droplist` WHERE `itemId`=1378;
DELETE FROM `droplist` WHERE `itemId`=1379;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1382;
DELETE FROM `droplist` WHERE `itemId`=1383;
DELETE FROM `droplist` WHERE `itemId`=1384;
DELETE FROM `droplist` WHERE `itemId`=1385;
DELETE FROM `droplist` WHERE `itemId`=1386;
DELETE FROM `droplist` WHERE `itemId`=1387;
DELETE FROM `droplist` WHERE `itemId`=1388;
DELETE FROM `droplist` WHERE `itemId`=1389;
DELETE FROM `droplist` WHERE `itemId`=1390;
DELETE FROM `droplist` WHERE `itemId`=1391;
DELETE FROM `droplist` WHERE `itemId`=1392;
DELETE FROM `droplist` WHERE `itemId`=1393;
DELETE FROM `droplist` WHERE `itemId`=1394;
DELETE FROM `droplist` WHERE `itemId`=1395;
DELETE FROM `droplist` WHERE `itemId`=1396;
DELETE FROM `droplist` WHERE `itemId`=1397;
DELETE FROM `droplist` WHERE `itemId`=1398;
DELETE FROM `droplist` WHERE `itemId`=1399;
DELETE FROM `droplist` WHERE `itemId`=1400;
DELETE FROM `droplist` WHERE `itemId`=1401;
DELETE FROM `droplist` WHERE `itemId`=1402;
DELETE FROM `droplist` WHERE `itemId`=1403;
DELETE FROM `droplist` WHERE `itemId`=1404;
DELETE FROM `droplist` WHERE `itemId`=1405;
DELETE FROM `droplist` WHERE `itemId`=1406;
DELETE FROM `droplist` WHERE `itemId`=1407;
DELETE FROM `droplist` WHERE `itemId`=1408;
DELETE FROM `droplist` WHERE `itemId`=1409;
DELETE FROM `droplist` WHERE `itemId`=1410;
DELETE FROM `droplist` WHERE `itemId`=1411;
DELETE FROM `droplist` WHERE `itemId`=1412;
DELETE FROM `droplist` WHERE `itemId`=1413;
DELETE FROM `droplist` WHERE `itemId`=1414;
DELETE FROM `droplist` WHERE `itemId`=1415;
DELETE FROM `droplist` WHERE `itemId`=1416;
DELETE FROM `droplist` WHERE `itemId`=1417;
DELETE FROM `droplist` WHERE `itemId`=1418;
DELETE FROM `droplist` WHERE `itemId`=1512;
DELETE FROM `droplist` WHERE `itemId`=1513;
DELETE FROM `droplist` WHERE `itemId`=1514;
DELETE FROM `droplist` WHERE `itemId`=1516;
DELETE FROM `droplist` WHERE `itemId`=1515;
DELETE FROM `droplist` WHERE `itemId`=1517;
DELETE FROM `droplist` WHERE `itemId`=1518;
DELETE FROM `droplist` WHERE `itemId`=1519;
DELETE FROM `droplist` WHERE `itemId`=1520;
DELETE FROM `droplist` WHERE `itemId`=1521;
DELETE FROM `droplist` WHERE `itemId`=1522;
DELETE FROM `droplist` WHERE `itemId`=1523;
DELETE FROM `droplist` WHERE `itemId`=1524;
DELETE FROM `droplist` WHERE `itemId`=1525;
DELETE FROM `droplist` WHERE `itemId`=1526;
DELETE FROM `droplist` WHERE `itemId`=1527;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1530;
DELETE FROM `droplist` WHERE `itemId`=1531;
DELETE FROM `droplist` WHERE `itemId`=1532;
DELETE FROM `droplist` WHERE `itemId`=1533;
DELETE FROM `droplist` WHERE `itemId`=1534;
DELETE FROM `droplist` WHERE `itemId`=1535;
DELETE FROM `droplist` WHERE `itemId`=1536;
DELETE FROM `droplist` WHERE `itemId`=1537;
DELETE FROM `droplist` WHERE `itemId`=1667;
DELETE FROM `droplist` WHERE `itemId`=1668;
DELETE FROM `droplist` WHERE `itemId`=1669;
DELETE FROM `droplist` WHERE `itemId`=1670;
DELETE FROM `droplist` WHERE `itemId`=1671;
DELETE FROM `droplist` WHERE `itemId`=1856;
DELETE FROM `droplist` WHERE `itemId`=3038;
DELETE FROM `droplist` WHERE `itemId`=3039;
DELETE FROM `droplist` WHERE `itemId`=3040;
DELETE FROM `droplist` WHERE `itemId`=3041;
DELETE FROM `droplist` WHERE `itemId`=3042;
DELETE FROM `droplist` WHERE `itemId`=3043;
DELETE FROM `droplist` WHERE `itemId`=3044;
DELETE FROM `droplist` WHERE `itemId`=3045;
DELETE FROM `droplist` WHERE `itemId`=3046;
DELETE FROM `droplist` WHERE `itemId`=3047;
DELETE FROM `droplist` WHERE `itemId`=3048;
DELETE FROM `droplist` WHERE `itemId`=3049;
DELETE FROM `droplist` WHERE `itemId`=3050;
DELETE FROM `droplist` WHERE `itemId`=3051;
DELETE FROM `droplist` WHERE `itemId`=3052;
DELETE FROM `droplist` WHERE `itemId`=3053;
DELETE FROM `droplist` WHERE `itemId`=3054;
DELETE FROM `droplist` WHERE `itemId`=3055;
DELETE FROM `droplist` WHERE `itemId`=3056;
DELETE FROM `droplist` WHERE `itemId`=3057;
DELETE FROM `droplist` WHERE `itemId`=3058;
DELETE FROM `droplist` WHERE `itemId`=3059;
DELETE FROM `droplist` WHERE `itemId`=3060;
DELETE FROM `droplist` WHERE `itemId`=3061;
DELETE FROM `droplist` WHERE `itemId`=3062;
DELETE FROM `droplist` WHERE `itemId`=3063;
DELETE FROM `droplist` WHERE `itemId`=3064;
DELETE FROM `droplist` WHERE `itemId`=3065;
DELETE FROM `droplist` WHERE `itemId`=3066;
DELETE FROM `droplist` WHERE `itemId`=3067;
DELETE FROM `droplist` WHERE `itemId`=3068;
DELETE FROM `droplist` WHERE `itemId`=3069;
DELETE FROM `droplist` WHERE `itemId`=3070;
DELETE FROM `droplist` WHERE `itemId`=3071;
DELETE FROM `droplist` WHERE `itemId`=3072;
DELETE FROM `droplist` WHERE `itemId`=3073;
DELETE FROM `droplist` WHERE `itemId`=3074;
DELETE FROM `droplist` WHERE `itemId`=3075;
DELETE FROM `droplist` WHERE `itemId`=3076;
DELETE FROM `droplist` WHERE `itemId`=3077;
DELETE FROM `droplist` WHERE `itemId`=3078;
DELETE FROM `droplist` WHERE `itemId`=3079;
DELETE FROM `droplist` WHERE `itemId`=3080;
DELETE FROM `droplist` WHERE `itemId`=3081;
DELETE FROM `droplist` WHERE `itemId`=3082;
DELETE FROM `droplist` WHERE `itemId`=3083;
DELETE FROM `droplist` WHERE `itemId`=3084;
DELETE FROM `droplist` WHERE `itemId`=3085;
DELETE FROM `droplist` WHERE `itemId`=3086;
DELETE FROM `droplist` WHERE `itemId`=3087;
DELETE FROM `droplist` WHERE `itemId`=3088;
DELETE FROM `droplist` WHERE `itemId`=3089;
DELETE FROM `droplist` WHERE `itemId`=3090;
DELETE FROM `droplist` WHERE `itemId`=3091;
DELETE FROM `droplist` WHERE `itemId`=3092;
DELETE FROM `droplist` WHERE `itemId`=3093;
DELETE FROM `droplist` WHERE `itemId`=3094;
DELETE FROM `droplist` WHERE `itemId`=3095;
DELETE FROM `droplist` WHERE `itemId`=3096;
DELETE FROM `droplist` WHERE `itemId`=3097;
DELETE FROM `droplist` WHERE `itemId`=3098;
DELETE FROM `droplist` WHERE `itemId`=3099;
DELETE FROM `droplist` WHERE `itemId`=3100;
DELETE FROM `droplist` WHERE `itemId`=3101;
DELETE FROM `droplist` WHERE `itemId`=3102;
DELETE FROM `droplist` WHERE `itemId`=3103;
DELETE FROM `droplist` WHERE `itemId`=3104;
DELETE FROM `droplist` WHERE `itemId`=3105;
DELETE FROM `droplist` WHERE `itemId`=3106;
DELETE FROM `droplist` WHERE `itemId`=3107;
DELETE FROM `droplist` WHERE `itemId`=3108;
DELETE FROM `droplist` WHERE `itemId`=3109;
DELETE FROM `droplist` WHERE `itemId`=3110;
DELETE FROM `droplist` WHERE `itemId`=3111;
DELETE FROM `droplist` WHERE `itemId`=3112;
DELETE FROM `droplist` WHERE `itemId`=3113;
DELETE FROM `droplist` WHERE `itemId`=3114;
DELETE FROM `droplist` WHERE `itemId`=3115;
DELETE FROM `droplist` WHERE `itemId`=3116;
DELETE FROM `droplist` WHERE `itemId`=3117;
DELETE FROM `droplist` WHERE `itemId`=3118;
DELETE FROM `droplist` WHERE `itemId`=3429;
DELETE FROM `droplist` WHERE `itemId`=3430;
DELETE FROM `droplist` WHERE `itemId`=3431;
DELETE FROM `droplist` WHERE `itemId`=3432;
DELETE FROM `droplist` WHERE `itemId`=3941;
DELETE FROM `droplist` WHERE `itemId`=3942;
DELETE FROM `droplist` WHERE `itemId`=3944;
DELETE FROM `droplist` WHERE `itemId`=4200;
DELETE FROM `droplist` WHERE `itemId`=4201;
DELETE FROM `droplist` WHERE `itemId`=4202;
DELETE FROM `droplist` WHERE `itemId`=4203;
DELETE FROM `droplist` WHERE `itemId`=4206;
DELETE FROM `droplist` WHERE `itemId`=4207;
DELETE FROM `droplist` WHERE `itemId`=4208;
DELETE FROM `droplist` WHERE `itemId`=4906;
DELETE FROM `droplist` WHERE `itemId`=4907;
DELETE FROM `droplist` WHERE `itemId`=4908;
DELETE FROM `droplist` WHERE `itemId`=4909;
DELETE FROM `droplist` WHERE `itemId`=4910;
DELETE FROM `droplist` WHERE `itemId`=4911;
DELETE FROM `droplist` WHERE `itemId`=4912;
DELETE FROM `droplist` WHERE `itemId`=4913;
DELETE FROM `droplist` WHERE `itemId`=4914;
DELETE FROM `droplist` WHERE `itemId`=4916;
DELETE FROM `droplist` WHERE `itemId`=4917;
DELETE FROM `droplist` WHERE `itemId`=4918;
DELETE FROM `droplist` WHERE `itemId`=4919;
DELETE FROM `droplist` WHERE `itemId`=4920;
DELETE FROM `droplist` WHERE `itemId`=4922;
DELETE FROM `droplist` WHERE `itemId`=4923;
DELETE FROM `droplist` WHERE `itemId`=4924;
DELETE FROM `droplist` WHERE `itemId`=4928;
DELETE FROM `droplist` WHERE `itemId`=4929;
DELETE FROM `droplist` WHERE `itemId`=4930;
DELETE FROM `droplist` WHERE `itemId`=4931;
DELETE FROM `droplist` WHERE `itemId`=4932;
DELETE FROM `droplist` WHERE `itemId`=4933;
DELETE FROM `droplist` WHERE `itemId`=4934;
DELETE FROM `droplist` WHERE `itemId`=4935;
DELETE FROM `droplist` WHERE `itemId`=5013;
DELETE FROM `droplist` WHERE `itemId`=5014;
DELETE FROM `droplist` WHERE `itemId`=5015;
DELETE FROM `droplist` WHERE `itemId`=5809;
DELETE FROM `droplist` WHERE `itemId`=5810;
DELETE FROM `droplist` WHERE `itemId`=5811;
DELETE FROM `droplist` WHERE `itemId`=5812;
DELETE FROM `droplist` WHERE `itemId`=5813;
DELETE FROM `droplist` WHERE `itemId`=5814;
DELETE FROM `droplist` WHERE `itemId`=5815;
DELETE FROM `droplist` WHERE `itemId`=5816;
DELETE FROM `droplist` WHERE `itemId`=6350;
DELETE FROM `droplist` WHERE `itemId`=6351;
DELETE FROM `droplist` WHERE `itemId`=6352;
DELETE FROM `droplist` WHERE `itemId`=6395;
DELETE FROM `droplist` WHERE `itemId`=6396;
DELETE FROM `droplist` WHERE `itemId`=6397;
DELETE FROM `droplist` WHERE `itemId`=6398;
DELETE FROM `droplist` WHERE `itemId`=7638;
DELETE FROM `droplist` WHERE `itemId`=7639;
DELETE FROM `droplist` WHERE `itemId`=7640;
DELETE FROM `droplist` WHERE `itemId`=7641;
DELETE FROM `droplist` WHERE `itemId`=7642;
DELETE FROM `droplist` WHERE `itemId`=7643;
DELETE FROM `droplist` WHERE `itemId`=7644;
DELETE FROM `droplist` WHERE `itemId`=7645;
DELETE FROM `droplist` WHERE `itemId`=7646;
DELETE FROM `droplist` WHERE `itemId`=7647;
DELETE FROM `droplist` WHERE `itemId`=7648;
DELETE FROM `droplist` WHERE `itemId`=7649;
DELETE FROM `droplist` WHERE `itemId`=7650;
DELETE FROM `droplist` WHERE `itemId`=7651;
DELETE FROM `droplist` WHERE `itemId`=7652;
DELETE FROM `droplist` WHERE `itemId`=7653;
DELETE FROM `droplist` WHERE `itemId`=7654;
DELETE FROM `droplist` WHERE `itemId`=7655;
DELETE FROM `droplist` WHERE `itemId`=7656;
DELETE FROM `droplist` WHERE `itemId`=7657;
DELETE FROM `droplist` WHERE `itemId`=7658;
DELETE FROM `droplist` WHERE `itemId`=7659;
DELETE FROM `droplist` WHERE `itemId`=7660;
DELETE FROM `droplist` WHERE `itemId`=7661;
DELETE FROM `droplist` WHERE `itemId`=7652;
DELETE FROM `droplist` WHERE `itemId`=7663;
DELETE FROM `droplist` WHERE `itemId`=7664;
DELETE FROM `droplist` WHERE `itemId`=7665;
DELETE FROM `droplist` WHERE `itemId`=7666;
DELETE FROM `droplist` WHERE `itemId`=7667;
DELETE FROM `droplist` WHERE `itemId`=7668;
DELETE FROM `droplist` WHERE `itemId`=7669;
DELETE FROM `droplist` WHERE `itemId`=7670;
DELETE FROM `droplist` WHERE `itemId`=7671;
DELETE FROM `droplist` WHERE `itemId`=7672;
DELETE FROM `droplist` WHERE `itemId`=7673;
DELETE FROM `droplist` WHERE `itemId`=7674;
DELETE FROM `droplist` WHERE `itemId`=7675;
DELETE FROM `droplist` WHERE `itemId`=7676;
DELETE FROM `droplist` WHERE `itemId`=7835;
DELETE FROM `droplist` WHERE `itemId`=8380;
DELETE FROM `droplist` WHERE `itemId`=8381;
DELETE FROM `droplist` WHERE `itemId`=8382;
DELETE FROM `droplist` WHERE `itemId`=8383;
DELETE FROM `droplist` WHERE `itemId`=8384;
DELETE FROM `droplist` WHERE `itemId`=8385;
DELETE FROM `droplist` WHERE `itemId`=8386;
DELETE FROM `droplist` WHERE `itemId`=8387;
DELETE FROM `droplist` WHERE `itemId`=8388;
DELETE FROM `droplist` WHERE `itemId`=8389;
DELETE FROM `droplist` WHERE `itemId`=8390;
DELETE FROM `droplist` WHERE `itemId`=8391;
DELETE FROM `droplist` WHERE `itemId`=8392;
DELETE FROM `droplist` WHERE `itemId`=8393;
DELETE FROM `droplist` WHERE `itemId`=8394;
DELETE FROM `droplist` WHERE `itemId`=8395;
DELETE FROM `droplist` WHERE `itemId`=8396;
DELETE FROM `droplist` WHERE `itemId`=8397;
DELETE FROM `droplist` WHERE `itemId`=8398;
DELETE FROM `droplist` WHERE `itemId`=8399;
DELETE FROM `droplist` WHERE `itemId`=8400;
DELETE FROM `droplist` WHERE `itemId`=8401;
DELETE FROM `droplist` WHERE `itemId`=8402;
DELETE FROM `droplist` WHERE `itemId`=8616;
DELETE FROM `droplist` WHERE `itemId`=8617;
DELETE FROM `droplist` WHERE `itemId`=8877;
DELETE FROM `droplist` WHERE `itemId`=8878;
DELETE FROM `droplist` WHERE `itemId`=8879;
DELETE FROM `droplist` WHERE `itemId`=8880;
DELETE FROM `droplist` WHERE `itemId`=8881;
DELETE FROM `droplist` WHERE `itemId`=8882;
DELETE FROM `droplist` WHERE `itemId`=8883;
DELETE FROM `droplist` WHERE `itemId`=8884;
DELETE FROM `droplist` WHERE `itemId`=8885;
DELETE FROM `droplist` WHERE `itemId`=8886;
DELETE FROM `droplist` WHERE `itemId`=8888;
DELETE FROM `droplist` WHERE `itemId`=8889;
DELETE FROM `droplist` WHERE `itemId`=8890;
DELETE FROM `droplist` WHERE `itemId`=8891;
DELETE FROM `droplist` WHERE `itemId`=8945;
DELETE FROM `droplist` WHERE `itemId`=8946;

 

SQL Scripts for Delete item from droplist

 

DELETE FROM `droplist` WHERE `itemId`=Item_Id;

 

Delete from droplist all items except Adena,Coin Of Luck and RB Jewelery

DELETE FROM droplist WHERE itemId NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656);

 

All Mobs Droping 1-10 kk Adena

UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
UPDATE `droplist` SET `droplist`.`max`=10000000 WHERE `droplist`.`itemId`=57;

 

Set Min Respawn Time 1 Hour and Max Respawn Time 2 Hour for Raidboss

UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';

 

Add Skill Return to All Newbie Characters

INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1);

 

Give All Clan Skills to Clan

INSERT INTO `clan_skills` VALUES
('id clana','370','3','Clan Vitality'),
('id clana','371','3','Clan Spirituality'),
('id clana','372','3','Clan Essence'),
('id clana','373','3','Clan Lifeblood'),
('id clana','374','3','Clan Morale'),
('id clana','375','3','Clan  Clarity'),
('id clana','376','3','Clan  Might'),
('id clana','377','3','Clan Aegis'),
('id clana','378','3','Clan Empowerment'),
('id clana','379','3','Clan Magic Protection'),
('id clana','380','3','Clan Guidance'),
('id clana','381','3','Clan Agility'),
('id clana','382','3','Clan Withstand-Attack'),
('id clana','383','3','Clan Shield Boost'),
('id clana','384','3','Clan Cyclonic Resistance'),
('id clana','385','3','Clan Magmatic Resistance'),
('id clana','386','3','Clan Fortitude'),
('id clana','387','3','Clan Freedom'),
('id clana','388','3','Clan Vigilance'),
('id clana','389','3','Clan March'),
('id clana','390','3','Clan Luck'),
('id clana','391','1','Clan Imperium');

 

Delete from Server All Data of Character that is not active more then 1 month.

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

 

Delete all Retail Mobs [Thx For Idea HouLiGaN]

DELETE FROM spawnlist WHERE `npc_templateid` IN (SELECT id FROM npc WHERE type = 'L2Monster');

 

if some1 have script share and i will post!

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 15/07/2010

 

Delete from droplist all items except Adena,Coin Of Luck and RB Jewelery

DELETE FROM droplist WHERE itemId NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656);

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 16/07/2010

 

All Mobs Droping 1-10 kk Adena

UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
UPDATE `droplist` SET `droplist`.`max`=10000000 WHERE `droplist`.`itemId`=57;

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 16/07/2010

 

Set Min Respawn Time 1 Hour and Max Respawn Time 2 Hour for Raidboss

UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';

EdenEternal Newbie

EdenEternal

Posted
  • Author
Posted

Updated 17/07/2010

 

Add Skill Return to All Newbie Characters

INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1);
INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1);

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • Atom
      L2j aCis Toggle Movement Fix

      By Atom · Posted

      I think that solves the freeze thing, anyway great share! 
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking Orders!
    • Splicho
      NimeraCP: A Modern Web Control Panel for L2java

      By Splicho · Posted

      Introducing: Daily & Weekly Missions!   I've released a major panel update with a new Missions system and expanded language support.   Players can now complete daily and weekly missions directly through the panel and claim rewards such as balance or items. Mission progress is tied to in-game activity and supported panel actions, and the update also adds a dedicated Missions page, dashboard mission previews, claimable mission indicators, and full admin tools for creating and managing missions.   The Roll page now shows the potential reward drops below the roll container.   Alongside this, I’ve expanded the panel’s language support with new locale options, including Bulgarian, Czech, Georgian, Lithuanian, Polish, Romanian, Japanese, Simplified Chinese, and Traditional Chinese.     The Demo is now updated with the new features for you to try out!
    • GX-Ext
      Source+Server+Cliente - L2Devs files (L2Devs.com)

      By GX-Ext · Posted

      I sell complete packs. If you want to add an item, NPC, etc., you have to do that yourselves. Your friend bought the pack; he's the one who needs to configure his server type. He received what he bought as agreed, and I'm saying this without knowing who you're talking about, because anyone who buys something receives what was agreed upon.   Regards. mmmmm L2Velmore ????   If that's the one, I see everything went well... if I remember correctly you were crying over $100, I gave you a better price, and I suppose you made thousands with that... And you're still coming back to complain? :=)
    • Medson™
      L2j aCis Toggle Movement Fix

      By Medson™ · Posted

      I know many people have struggled with this specific issue and had trouble setting up the correct behavior for Toggle skills in aCis. By default, toggles interrupt the player's movement (retail-like), which often feels clunky to players who prefer a smoother, more modern experience. I've prepared a clean solution that eliminates this "freeze" and allows for fluid movement while toggling your auras. Below is the code on how to achieve this. Hope it helps! Changes in PlayerAI.java: Modified doActiveIntention to properly update the active state without stalling. Removed the forced stop() during toggle casting. Added a MoveToLocation broadcast to ensure other players see your movement correctly (prevents visual "teleporting" or desync). Best regards 😃 diff --git a/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/ai/type/PlayerAI.java b/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/ai/type/PlayerAI.java index ba0425a..1b2658d 100644 --- a/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/ai/type/PlayerAI.java +++ b/aCis_gameserver/java/net/sf/l2j/gameserver/model/actor/ai/type/PlayerAI.java @@ -28,6 +28,7 @@  import net.sf.l2j.gameserver.network.serverpackets.ActionFailed;  import net.sf.l2j.gameserver.network.serverpackets.AutoAttackStart;  import net.sf.l2j.gameserver.network.serverpackets.ChairSit; +import net.sf.l2j.gameserver.network.serverpackets.MoveToLocation;  import net.sf.l2j.gameserver.network.serverpackets.MoveToLocationInVehicle;  import net.sf.l2j.gameserver.network.serverpackets.MoveToPawn;  import net.sf.l2j.gameserver.network.serverpackets.StopMove; @@ -159,7 +160,10 @@      @Override      public synchronized void doActiveIntention()      { -        doIdleIntention(); +        prepareIntention(); +        _currentIntention.updateAsActive(); +        if (!getActor().isMoving()) +            thinkIdle();      }            @Override @@ -280,8 +284,9 @@                    if (skill.isToggle())          { -            getActor().getMove().stop();              getActor().getCast().doToggleCast(skill, target); +            if (getActor().isMoving()) +                getActor().broadcastPacket(new MoveToLocation(getActor()));          }          else          { https://pastebin.com/twZujZ3Y

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..