сделать епиков 80 лвл

JohnyDap · 4 мая, 2020

всем привет ребят есть у кого sql запрос что бы сделать гранд босов 80 лвл? и дать им нормальные статы для 80 лвла

Изменено 7 мая, 2020 пользователем JohnyDap

NewbieUser · 4 мая, 2020

7 минут назад, JohnyDap сказал:

всем привет ребят есть у кого sql запрос что бы сделать гранд босов 80 лвл?

их не так уж и много, поправь в базе руками лвл да и все

JohnyDap · 4 мая, 2020

Только что, NewbieUser сказал:

их не так уж и много, поправь в базе руками лвл да и все

да я так и делал криво работает ..сборка л2код ncspawn говорит надо запросом как то

NewbieUser · 4 мая, 2020

4 минуты назад, JohnyDap сказал:

да я так и делал криво работает ..сборка л2код ncspawn говорит надо запросом как то

так это его сборка ведь?
проси у него запрос

JohnyDap · 4 мая, 2020

1 минуту назад, NewbieUser сказал:

так это его сборка ведь?
проси у него запрос

нету у него говорит

NewbieUser · 4 мая, 2020

1 минуту назад, JohnyDap сказал:

нету у него говорит

лол

Smowk · 4 мая, 2020

38 минут назад, JohnyDap сказал:

нету у него говорит


UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss";

еще:

-- Все обычные РБ будут 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2RaidBoss';
-- Все Эпик РБ будут 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2GrandBoss';
-- Вся охрана любого босса(Эпик или Обычный) будет 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2Minion';

Спойлер


Вытаскивает чара из под текстур
UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='Ник чара';
====================================================================================================================================

Теперь НПС Класса Монстер - не агриться
UPDATE npc SET aggro="0" WHERE type=[L2Monster];
====================================================================================================================================

Шанс дропа клановых яиц 75%
UPDATE droplist SET chance='7500000' WHERE ItemId in (8158, 8159, 8160, 8161, 8162, 8163, 8164, 8165, 8166, 8167, 8168, 8169, 8170, 8171, 8172, 8173, 8174, 8175, 8176);
====================================================================================================================================

Убираем из дропа весь мусор, кроме аденки
DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')
====================================================================================================================================

Все вещи можно продать/обменять/удалить
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";
====================================================================================================================================

Изменить титул всем нпсам на сервере
UPDATE `npc` SET `title`='Титул'
====================================================================================================================================

Изменить титул определенного нпса
UPDATE `npc` SET `title`='Титул' WHERE (`id`='ID NPC');
====================================================================================================================================

Эти зaпpocы пoнижaют физ.aтк./маг. атк./маг.деф/физ.деф в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Minion';
====================================================================================================================================

Забанить определенного персонажа.
UPDATE `characters` SET `accesslevel`='-100' WHERE (`obj_Id`='ИД Чара')
====================================================================================================================================

Увеличить время восстановление маны в 10 раз
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
====================================================================================================================================

Дать определенному персонажу статус героя официально
NSERT INTO `heroes` VALUES ('ИД Чара', 'Ник Чара', 'ID профы', 'Побед', 'Игр');
====================================================================================================================================

Запрос который удалит неиспользуемые акки*(где нету персов)
DELETE FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);
====================================================================================================================================

А такой запрос выведет логин, IP с которого заходили последний раз на этот акк и уровень доступа для акков на которых нет чаров
SELECT `login`,`lastIP`,`access_level`
FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);
====================================================================================================================================

Удаляет счёт пк/пвп со всех игроков
UPDATE`characters`SET`pkkills`='0';
UPDATE`characters`SET`pvpkills`='0';
====================================================================================================================================

Удаляет карму со всех игроков
UPDATE`characters`SET`karma`='0';
====================================================================================================================================

Все персонажи могут крафтить не смотря на рассу
UPDATE char_templates SET canCraft="1";
====================================================================================================================================

Изменяем цвет имя Лорда определенного замка (Скобки обязательны)
UPDATE characters SET name_color="Код Цвета" WHERE obj_id IN (SELECT leader_id FROM clan_data WHERE hasCastle="Castle_ID");
====================================================================================================================================

Это запросы чтоб выдавать всем игрокам нублес
UPDATE `characters` SET `subpledge`='1'
UPDATE `characters` SET `nobless`='1'
====================================================================================================================================

Итемы/броня/оружие весит 0
UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);
====================================================================================================================================

Дроп адены 100%
UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
====================================================================================================================================

Продажа всего по 0 адены (в магазин)
UPDATE `armor` SET price=0 where price > 1;
UPDATE `etcitem` SET price=0 where price > 1;
UPDATE `weapon` SET price=0 where price > 1;
====================================================================================================================================

У РБ будет 5кк хп
UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';
====================================================================================================================================

Удалить всех мобов ниже 40 лвла
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster';
====================================================================================================================================

Удалить все материалы и рецепты нах из БД
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );
====================================================================================================================================

Назначить шанс выпадения рецептов
UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');
====================================================================================================================================

Удаление всего из дропа, кроме аден и других неболших полезностей(лайф_стоны, заточки, рб_бижа, вещи на клан_скилы с рб, всякие банки с острова дино, ключи, камни_аа и еще всякого)
DELETE FROM droplist WHERE itemId NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757,8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,6571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8167,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,6672,6661);
====================================================================================================================================

Запрос на удаление вещи с определённым ID из дропа
DELETE FROM `droplist` WHERE `itemId`=Item_Id;
====================================================================================================================================

Удалить из дропа кости
DELETE FROM droplist WHERE itemId='2508';
====================================================================================================================================

Удалить из дропа банки
DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';
====================================================================================================================================

Удалить из дропа стрелы
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';
====================================================================================================================================

Добавить новым персонажам S шмот (магам - Аркану и ДК сет, воинам - ангел слеер и драконик сет)
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 skill_trees WHERE skill_id = 239;
====================================================================================================================================

Телепорт будет стоить 0 аден
UPDATE teleport SET price=0;
====================================================================================================================================

МП регенерируется на 10% дольше
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
====================================================================================================================================

Увеличить персонажам СП на 20 лвле на 22%, на 40 лвле на 44%, на 76 лвле на 66%
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';
====================================================================================================================================

Добавить персонажам на 20% больше спида
UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;
====================================================================================================================================

Удалить все аккаунты и персонажей, которые не соизволили появиться в игре в течении 3 месяцев
DELETE FROM characters WHERE lastAccess < 466560000;
DELETE FROM accounts WHERE lastactive < 466560000;
====================================================================================================================================

Замутить во всех мобов дроп колов

insert into droplist (mobId, itemid, min, max,category, chance) select id, 4037, 1, 1, 1, 1000000 from npc where type='L2Monster';

L2ReflectionBoss
L2Boss
L2RaidBoss
====================================================================================================================================

При создании персонажа, он будет в топ НГ
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);
====================================================================================================================================

Добавить бижу в РБ, если вы удалили её
INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');
====================================================================================================================================

Добавить гвардам 50% П дефа, М дефа, П атаки и ХП
UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';
====================================================================================================================================

Понизить у РБ П деф, М деф и ХП на 40%
UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';
====================================================================================================================================

Увеличить время респауна мобов в 3 раза
UPDATE `spawnlist` SET `respawnDelay` = `respawn_min_delay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawn_max_delay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;
====================================================================================================================================

Установить время респауна РБ от 1 часа до двух
UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';
====================================================================================================================================

Сделать всех петов сильнее (классная вещь) или сделай себе ручного антараса
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mp` = `mp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type='L2Pet';
====================================================================================================================================

Удалить все вещи с определённым ID и определённого персонажа   пример
 DELETE FROM items WHERE item_id='12237' AND owner_id='268741464';
====================================================================================================================================

Месторождение чаров в гиране с ТОП шмотом. (Для воинов это - тека и кристал дагер, для магов это - кармиан и хомка)
UPDATE `char_templates` SET `x` = '83400',
`y` = '147943',
`z` = '-3404';
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;
====================================================================================================================================

Увеличение в 2 раза таких показателей, как Str,Int,Dex,Wit,Men,Con
UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40'); 
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22'); 
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36'); 
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21'); 
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23'); 
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27'); 
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39'); 
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43'); 
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27'); 
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36'); 
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25'); 
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32'); 
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24'); 
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47'); 
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');
====================================================================================================================================

Все РБ станут 80 лвлом
UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss";

====================================================================================================================================
Все Игроки в базе Онлайн 

UPDATE characters SET `online`=1;
====================================================================================================================================
Все Игроки в Базе  на Оф Трейде 
UPDATE characters SET `online`=2;


====================================================================================================================================

Все гранд босы станут 80 лвлом
UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss";
====================================================================================================================================

Настройка статов у гвардов
UPDATE npc SET level='85' where type='L2Guard';
UPDATE npc SET hp='30000' where type='L2Guard';
UPDATE npc SET mp='30000' where type='L2Guard';
UPDATE npc SET patk='30000' where type='L2Guard';
UPDATE npc SET pdef='10000' where type='L2Guard';
UPDATE npc SET mdef='10000' where type='L2Guard';
UPDATE npc SET title='Customized Guard' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET rhand='0' where type='L2Guard';
UPDATE npc SET lhand='0' where type='L2Guard';
UPDATE npc SET runspd='300' where type='L2Guard';
UPDATE npc SET ss='1' where type='L2Guard';
UPDATE npc SET bss='1' where type='L2Guard';
UPDATE npc SET ss_rate='100' where type='L2Guard';
UPDATE npc SET attackrange='100' where type='L2Guard';
UPDATE npc SET aggro='5000' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
UPDATE npc SET con='100' where type='L2Guard';
UPDATE npc SET dex='100' where type='L2Guard';
UPDATE npc SET wit='100' where type='L2Guard';
UPDATE npc SET men='100' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
====================================================================================================================================

Авторестарт сервера каждую неделю
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 2 дня
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 24 часа
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 12 часов
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");
====================================================================================================================================

Авторестарт сервера каждые 6 часов
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");
====================================================================================================================================

Авторестарт сервера каждые 3 часа
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");
====================================================================================================================================

Рейд босы всегда будут появляться с 70% хп
UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;
====================================================================================================================================

Newbie бафер (уже от грации) будет бафать вас от 1 лвла до 62
UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;
====================================================================================================================================

Для заточки скилов вам не нужно будет тратить xp и exp
UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;
====================================================================================================================================

Вы будете стартовать с вуден сетом, лучшим НГ оружием, набором сосок екстра перчатками и ботинками
UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753; 
-- kamael soe for simple soe (x10)
UPDATE char_creation_items SET itemId='219' WHERE itemId = 10; 
-- starting dagger for Sword Breaker
UPDATE char_creation_items SET itemId='311' WHERE itemId = 6; 
-- starting wand for Crucifix of Blessing
UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;
-- starting sword for Falchion
UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;
-- starting fists for Viper Fang
UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;
-- starting fists for Flanged MaceUPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;
-- starting fifghers armor for Wooden armor
UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147; 
-- starting fifghers armor for Wooden armorINSERT INTO char_creation_items VALUES (0,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (18,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (31,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (44,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (53,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (123,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (124,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (10,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (25,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (38,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (49,44,1,'true');
-- Devotion set helmINSERT INTO char_creation_items VALUES (0,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (18,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (31,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (44,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (53,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (123,5590,1,'true');
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (124,5590,1,'true');
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (10,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (25,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (38,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (49,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)INSERT INTO char_creation_items VALUES (0,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (18,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (31,51,1,'true');
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (44,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (53,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (123,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (124,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (10,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (25,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (38,51,1,'true');
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (49,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)INSERT INTO char_creation_items VALUES (0,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (18,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (31,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (44,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (53,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (123,5250,2,'true');
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (124,5250,2,'true');
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (10,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (25,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (38,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (49,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
====================================================================================================================================

Месторождение чаров будет по заданным координатам
PDATE char_templates SET x=yourXcoordinate;
UPDATE char_templates SET y=yourYcoordinate;
UPDATE char_templates SET z=yourZcoordinate;
====================================================================================================================================

Добавить всем персонажам на 10% больше П дефа и М дефа
UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;
====================================================================================================================================

Изменено 4 мая, 2020 пользователем Smowk

La2Hero · 4 мая, 2020

Спасибо добрым форумчанам :rofl: Джонни ответил тебе на форуме кода, дал запрос

Edgar · 4 мая, 2020

2 часа назад, Smowk сказал:


UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss";

еще:


-- Все обычные РБ будут 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2RaidBoss';
-- Все Эпик РБ будут 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2GrandBoss';
-- Вся охрана любого босса(Эпик или Обычный) будет 80 лвл
UPDATE `npc` SET `level` = 80 WHERE `type` = 'L2Minion';

+ (Скрыть контент)



Вытаскивает чара из под текстур
UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='Ник чара';
====================================================================================================================================

Теперь НПС Класса Монстер - не агриться
UPDATE npc SET aggro="0" WHERE type=[L2Monster];
====================================================================================================================================

Шанс дропа клановых яиц 75%
UPDATE droplist SET chance='7500000' WHERE ItemId in (8158, 8159, 8160, 8161, 8162, 8163, 8164, 8165, 8166, 8167, 8168, 8169, 8170, 8171, 8172, 8173, 8174, 8175, 8176);
====================================================================================================================================

Убираем из дропа весь мусор, кроме аденки
DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')
====================================================================================================================================

Все вещи можно продать/обменять/удалить
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";
====================================================================================================================================

Изменить титул всем нпсам на сервере
UPDATE `npc` SET `title`='Титул'
====================================================================================================================================

Изменить титул определенного нпса
UPDATE `npc` SET `title`='Титул' WHERE (`id`='ID NPC');
====================================================================================================================================

Эти зaпpocы пoнижaют физ.aтк./маг. атк./маг.деф/физ.деф в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2Minion';
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Minion';
====================================================================================================================================

Забанить определенного персонажа.
UPDATE `characters` SET `accesslevel`='-100' WHERE (`obj_Id`='ИД Чара')
====================================================================================================================================

Увеличить время восстановление маны в 10 раз
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
====================================================================================================================================

Дать определенному персонажу статус героя официально
NSERT INTO `heroes` VALUES ('ИД Чара', 'Ник Чара', 'ID профы', 'Побед', 'Игр');
====================================================================================================================================

Запрос который удалит неиспользуемые акки*(где нету персов)
DELETE FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);
====================================================================================================================================

А такой запрос выведет логин, IP с которого заходили последний раз на этот акк и уровень доступа для акков на которых нет чаров
SELECT `login`,`lastIP`,`access_level`
FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);
====================================================================================================================================

Удаляет счёт пк/пвп со всех игроков
UPDATE`characters`SET`pkkills`='0';
UPDATE`characters`SET`pvpkills`='0';
====================================================================================================================================

Удаляет карму со всех игроков
UPDATE`characters`SET`karma`='0';
====================================================================================================================================

Все персонажи могут крафтить не смотря на рассу
UPDATE char_templates SET canCraft="1";
====================================================================================================================================

Изменяем цвет имя Лорда определенного замка (Скобки обязательны)
UPDATE characters SET name_color="Код Цвета" WHERE obj_id IN (SELECT leader_id FROM clan_data WHERE hasCastle="Castle_ID");
====================================================================================================================================

Это запросы чтоб выдавать всем игрокам нублес
UPDATE `characters` SET `subpledge`='1'
UPDATE `characters` SET `nobless`='1'
====================================================================================================================================

Итемы/броня/оружие весит 0
UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);
====================================================================================================================================

Дроп адены 100%
UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
====================================================================================================================================

Продажа всего по 0 адены (в магазин)
UPDATE `armor` SET price=0 where price > 1;
UPDATE `etcitem` SET price=0 where price > 1;
UPDATE `weapon` SET price=0 where price > 1;
====================================================================================================================================

У РБ будет 5кк хп
UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';
====================================================================================================================================

Удалить всех мобов ниже 40 лвла
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster';
====================================================================================================================================

Удалить все материалы и рецепты нах из БД
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );
====================================================================================================================================

Назначить шанс выпадения рецептов
UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');
====================================================================================================================================

Удаление всего из дропа, кроме аден и других неболших полезностей(лайф_стоны, заточки, рб_бижа, вещи на клан_скилы с рб, всякие банки с острова дино, ключи, камни_аа и еще всякого)
DELETE FROM droplist WHERE itemId NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757,8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,6571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8167,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,6672,6661);
====================================================================================================================================

Запрос на удаление вещи с определённым ID из дропа
DELETE FROM `droplist` WHERE `itemId`=Item_Id;
====================================================================================================================================

Удалить из дропа кости
DELETE FROM droplist WHERE itemId='2508';
====================================================================================================================================

Удалить из дропа банки
DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';
====================================================================================================================================

Удалить из дропа стрелы
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';
====================================================================================================================================

Добавить новым персонажам S шмот (магам - Аркану и ДК сет, воинам - ангел слеер и драконик сет)
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 skill_trees WHERE skill_id = 239;
====================================================================================================================================

Телепорт будет стоить 0 аден
UPDATE teleport SET price=0;
====================================================================================================================================

МП регенерируется на 10% дольше
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;
====================================================================================================================================

Увеличить персонажам СП на 20 лвле на 22%, на 40 лвле на 44%, на 76 лвле на 66%
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';
====================================================================================================================================

Добавить персонажам на 20% больше спида
UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;
====================================================================================================================================

Удалить все аккаунты и персонажей, которые не соизволили появиться в игре в течении 3 месяцев
DELETE FROM characters WHERE lastAccess < 466560000;
DELETE FROM accounts WHERE lastactive < 466560000;
====================================================================================================================================

Замутить во всех мобов дроп колов

insert into droplist (mobId, itemid, min, max,category, chance) select id, 4037, 1, 1, 1, 1000000 from npc where type='L2Monster';

L2ReflectionBoss
L2Boss
L2RaidBoss
====================================================================================================================================

При создании персонажа, он будет в топ НГ
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);
====================================================================================================================================

Добавить бижу в РБ, если вы удалили её
INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');
====================================================================================================================================

Добавить гвардам 50% П дефа, М дефа, П атаки и ХП
UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';
====================================================================================================================================

Понизить у РБ П деф, М деф и ХП на 40%
UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';
====================================================================================================================================

Увеличить время респауна мобов в 3 раза
UPDATE `spawnlist` SET `respawnDelay` = `respawn_min_delay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawn_max_delay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;
UPDATE `spawnlist` SET `respawnDelay` = `respawnDelay`*3;
====================================================================================================================================

Установить время респауна РБ от 1 часа до двух
UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';
====================================================================================================================================

Сделать всех петов сильнее (классная вещь) или сделай себе ручного антараса
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mp` = `mp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type='L2Pet';
====================================================================================================================================

Удалить все вещи с определённым ID и определённого персонажа   пример
 DELETE FROM items WHERE item_id='12237' AND owner_id='268741464';
====================================================================================================================================

Месторождение чаров в гиране с ТОП шмотом. (Для воинов это - тека и кристал дагер, для магов это - кармиан и хомка)
UPDATE `char_templates` SET `x` = '83400',
`y` = '147943',
`z` = '-3404';
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;
====================================================================================================================================

Увеличение в 2 раза таких показателей, как Str,Int,Dex,Wit,Men,Con
UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40'); 
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22'); 
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36'); 
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21'); 
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23'); 
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27'); 
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39'); 
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43'); 
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27'); 
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36'); 
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25'); 
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32'); 
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24'); 
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47'); 
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');
====================================================================================================================================

Все РБ станут 80 лвлом
UPDATE npc SET `level`=80 WHERE `type`="L2RaidBoss";

====================================================================================================================================
Все Игроки в базе Онлайн 

UPDATE characters SET `online`=1;
====================================================================================================================================
Все Игроки в Базе  на Оф Трейде 
UPDATE characters SET `online`=2;


====================================================================================================================================

Все гранд босы станут 80 лвлом
UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss";
====================================================================================================================================

Настройка статов у гвардов
UPDATE npc SET level='85' where type='L2Guard';
UPDATE npc SET hp='30000' where type='L2Guard';
UPDATE npc SET mp='30000' where type='L2Guard';
UPDATE npc SET patk='30000' where type='L2Guard';
UPDATE npc SET pdef='10000' where type='L2Guard';
UPDATE npc SET mdef='10000' where type='L2Guard';
UPDATE npc SET title='Customized Guard' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET serverSideTitle='1' where type='L2Guard';
UPDATE npc SET rhand='0' where type='L2Guard';
UPDATE npc SET lhand='0' where type='L2Guard';
UPDATE npc SET runspd='300' where type='L2Guard';
UPDATE npc SET ss='1' where type='L2Guard';
UPDATE npc SET bss='1' where type='L2Guard';
UPDATE npc SET ss_rate='100' where type='L2Guard';
UPDATE npc SET attackrange='100' where type='L2Guard';
UPDATE npc SET aggro='5000' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
UPDATE npc SET con='100' where type='L2Guard';
UPDATE npc SET dex='100' where type='L2Guard';
UPDATE npc SET wit='100' where type='L2Guard';
UPDATE npc SET men='100' where type='L2Guard';
UPDATE npc SET str='100' where type='L2Guard';
====================================================================================================================================

Авторестарт сервера каждую неделю
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 2 дня
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 24 часа
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");
====================================================================================================================================

Авторестарт сервера каждые 12 часов
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360");
====================================================================================================================================

Авторестарт сервера каждые 6 часов
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");
====================================================================================================================================

Авторестарт сервера каждые 3 часа
INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360");
====================================================================================================================================

Рейд босы всегда будут появляться с 70% хп
UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7;
====================================================================================================================================

Newbie бафер (уже от грации) будет бафать вас от 1 лвла до 62
UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;
====================================================================================================================================

Для заточки скилов вам не нужно будет тратить xp и exp
UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;
====================================================================================================================================

Вы будете стартовать с вуден сетом, лучшим НГ оружием, набором сосок екстра перчатками и ботинками
UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753; 
-- kamael soe for simple soe (x10)
UPDATE char_creation_items SET itemId='219' WHERE itemId = 10; 
-- starting dagger for Sword Breaker
UPDATE char_creation_items SET itemId='311' WHERE itemId = 6; 
-- starting wand for Crucifix of Blessing
UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;
-- starting sword for Falchion
UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;
-- starting fists for Viper Fang
UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;
-- starting fists for Flanged MaceUPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;
-- starting fifghers armor for Wooden armor
UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147; 
-- starting fifghers armor for Wooden armorINSERT INTO char_creation_items VALUES (0,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (18,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (31,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (44,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (53,43,1,'true');
-- Wooden set helm
INSERT INTO char_creation_items VALUES (123,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (124,43,1,'true'); 
-- Wooden set helm
INSERT INTO char_creation_items VALUES (10,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (25,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (38,44,1,'true');
-- Devotion set helm
INSERT INTO char_creation_items VALUES (49,44,1,'true');
-- Devotion set helmINSERT INTO char_creation_items VALUES (0,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (18,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (31,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (44,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (53,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (123,5590,1,'true');
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (124,5590,1,'true');
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (10,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (25,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (38,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (49,5590,1,'true'); 
-- Random Boots (id:5590 - Squeaking Shoes)INSERT INTO char_creation_items VALUES (0,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (18,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (31,51,1,'true');
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (44,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (53,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (123,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (124,51,1,'true'); 
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (10,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (25,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (38,51,1,'true');
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (49,51,1,'true');
-- Random gloves (id:51 - Bracer Gloves)INSERT INTO char_creation_items VALUES (0,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (18,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (31,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (44,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (53,5250,2,'true'); 
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (123,5250,2,'true');
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (124,5250,2,'true');
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (10,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (25,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (38,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (49,5262,1,'false');
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
====================================================================================================================================

Месторождение чаров будет по заданным координатам
PDATE char_templates SET x=yourXcoordinate;
UPDATE char_templates SET y=yourYcoordinate;
UPDATE char_templates SET z=yourZcoordinate;
====================================================================================================================================

Добавить всем персонажам на 10% больше П дефа и М дефа
UPDATE char_templates SET P_DEF = P_DEF * 1.1;
UPDATE char_templates SET M_DEF = M_DEF * 1.1;
====================================================================================================================================

Зачем ты все копипастишь? Ссылку на первоисточник дать не вариант?

Smowk · 5 мая, 2020

18 часов назад, Edgar сказал:

Зачем ты все копипастишь? Ссылку на первоисточник дать не вариант?

а что нельзя ?

Были мысли. но собрал все в одно.

Изменено 5 мая, 2020 пользователем Smowk

Войти

сделать епиков 80 лвл

Рекомендуемые сообщения

JohnyDap 34

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

NewbieUser 19

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

JohnyDap 34

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

NewbieUser 19

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

JohnyDap 34

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

NewbieUser 19

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Smowk 46

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

La2Hero 71

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Edgar 356

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Smowk 46

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Создать учетную запись

Войти

Последние посетители 0 пользователей онлайн

Сайт

Активность

Магазин

My Details