Sql Запрос

[LimewaX 41]

Добрый день!

подскажите скл запрос на добавление в дроп мобам с1 по 10 лвл

спасибо!

[Mr.Smith 128]

Добрый день!

подскажите скл запрос на добавление в дроп мобам с1 по 10 лвл

спасибо!

Что то типо этого, тестируйте:

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, Id_предмета, Шанс_дропа, 1, 1, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '1';
INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, Id_предмета, Шанс_дропа, 1, 1, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` < '10';

Изменено 21 июня, 2014 пользователем Mr.Smith

[123456789 1]

напиши в гугле

полезные sql Запросы, и если что то свое хочешь меняй ид т.д

[RetZs 71]

Добрый день!

подскажите скл запрос на добавление в дроп мобам с1 по 10 лвл

спасибо!

Под какую сборку вам данный запрос нужен?

[LimewaX 41]

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 300, 400, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '1' AND `type` = 'L2Monster' AND `level` < '5';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 400, 500, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '5' AND `type` = 'L2Monster' AND `level` < '10';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 500, 600, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '10' AND `type` = 'L2Monster' AND `level` < '15';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 600, 700, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '15' AND `type` = 'L2Monster' AND `level` < '20';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 700, 800, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '20' AND `type` = 'L2Monster' AND `level` < '25';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 800, 900, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '25' AND `type` = 'L2Monster' AND `level` < '30';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 900, 1000, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '30' AND `type` = 'L2Monster' AND `level` < '35';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1000, 1100, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '35' AND `type` = 'L2Monster' AND `level` < '40';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1100, 1200, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '40' AND `type` = 'L2Monster' AND `level` < '44';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1200, 1300, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '45' AND `type` = 'L2Monster' AND `level` < '50';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1300, 1400, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '50' AND `type` = 'L2Monster' AND `level` < '55';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1400, 1500, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '55' AND `type` = 'L2Monster' AND `level` < '60';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1500, 1600, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '60' AND `type` = 'L2Monster' AND `level` < '65';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1600, 1700, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '65' AND `type` = 'L2Monster' AND `level` < '70';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1700, 1800, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '70' AND `type` = 'L2Monster' AND `level` < '75';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 1800, 2200, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '75' AND `type` = 'L2Monster' AND `level` < '80';

INSERT INTO `droplist` (mobId, itemid, chance, min, max, category) SELECT id, 57, 700000, 2200, 3000, 0 FROM `npc` WHERE `type` = 'L2Monster' AND `level` > '80' AND `type` = 'L2Monster' AND `level` < '87';

 

 

80 лвлу не хочет добавлять дроп((((

 

з.ы всё разобрался, спасибо всем.

Изменено 21 июня, 2014 пользователем LimewaX