sql запросы

vzakone · 17 октября, 2016

День в радость ,кто поделится sql запросами чтоб с тиров падал дроп лсов 100% ,и очистить лишний дроп никти всякие и атк далие с мобов падают, буду благодарен. зборка lucera .

DeluxeMD · 17 октября, 2016

заходишь в игру жмешь Шифт клик на Тира удаляешь лишний дроп и изменяешь процент выпадение ЛСов

vzakone · 17 октября, 2016

дроп мусора с любых мобов есть( поетому запрос прошу

SystemOfADown · 17 октября, 2016

Удаляет весь лишний дроп, оставляя только адену, клан яйца, лски и эпик бижу

DELETE FROM droplist WHERE itemId IN (select `item_id` FROM skill_spellbooks);
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM etcitem WHERE itemId<>57 AND itemId<>5569 AND itemId<>5571 AND itemId<>5573 AND `name` NOT LIKE '%life stone%' AND `icon` NOT LIKE '%etc_raid%');
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM weapon);
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM armor WHERE itemId<>6656 AND itemId<>6657 AND itemId<>6657 AND itemId<>6658 AND itemId<>6659 AND itemId<>6660 AND itemId<>6661 AND itemId<>6662);

Изменено 17 октября, 2016 пользователем SystemOfADown

vzakone · 17 октября, 2016

Удаляет весь лишний дроп, оставляя только адену, клан яйца, лски и эпик бижу

DELETE FROM droplist WHERE itemId IN (select `item_id` FROM skill_spellbooks);
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM etcitem WHERE itemId<>57 AND itemId<>5569 AND itemId<>5571 AND itemId<>5573 AND `name` NOT LIKE '%life stone%' AND `icon` NOT LIKE '%etc_raid%');
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM weapon);
DELETE FROM droplist WHERE itemId IN (select `item_id` FROM armor WHERE itemId<>6656 AND itemId<>6657 AND itemId<>6657 AND itemId<>6658 AND itemId<>6659 AND itemId<>6660 AND itemId<>6661 AND itemId<>6662);

спасибо,а можно запрос на 1005 дроп лсов?

OrmJevil · 17 октября, 2016

спасибо,а можно запрос на 1005 дроп лсов?

UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=тут айди лс

Будет падать 100% со всех у кого он был в дроплисте

OrmJevil · 17 октября, 2016

Для удаление можешь ещё использовать такой зарос DELETE FROM droplist WHERE itemId NOT IN (*,*,*); где * пишешь ID которое нужно оставить в игре а остальное все удалиться ( только очень внимательно пиши айди ) лучше всего back up базы сделать , мало ли

vzakone · 17 октября, 2016

UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=тут айди лс

Будет падать 100% со всех у кого он был в дроплисте

хм чтото ерор кидает

OrmJevil · 17 октября, 2016

А какой именно ?

Ежик · 17 октября, 2016

День в радость ,кто поделится sql запросами чтоб с тиров падал дроп лсов 100% ,и очистить лишний дроп никти всякие и атк далие с мобов падают, буду благодарен. зборка lucera .

Вытаскивает чара из под текстур
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;
====================================================================================================================================

vzakone · 17 октября, 2016

Вытаскивает чара из под текстур
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;
====================================================================================================================================

спасибо ,а есть запрос дроп 100% с епиков.

Ежик · 17 октября, 2016

спасибо ,а есть запрос дроп 100% с епиков.

Меняеш пару строк и вот тебе запрос.

Войти

sql запросы

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

vzakone 2

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

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

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

DeluxeMD 73

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

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

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

vzakone 2

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

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

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

SystemOfADown 27

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

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

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

vzakone 2

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

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

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

OrmJevil 397

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

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

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

OrmJevil 397

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

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

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

vzakone 2

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

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

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

OrmJevil 397

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

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

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

Ежик 53

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

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

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

vzakone 2

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

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

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

Ежик 53

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

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

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

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

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

Войти

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

Сайт

Активность

Магазин

My Details