rooti 764 Опубликовано 9 декабря, 2012 (изменено) Как бы так... добавить всем РБ (L2RaidBoss), определённый итем. сборка pw в droplist ведь нет значения L2RaidBoss, как быть? вариант, вырезать всех РБ по сортировке, в excel перелить и поставить дроп... Изменено 9 декабря, 2012 пользователем rooti Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Abnormal 254 Опубликовано 9 декабря, 2012 type 'RaidBoss' берется из таблицы нпц Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
rooti 764 Опубликовано 9 декабря, 2012 (изменено) INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25001, 9912, 1500, 4000, 1, 1000000); для РБ 25001 ИТЕМ 9912 min 1500 max 4000 chance 100% для всех L2RaidBoss INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25001, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25004, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25007, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25010, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25016, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25019, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25020, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25023, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25026, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25029, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25032, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25035, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25038, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25041, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25044, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25047, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25050, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25051, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25054, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25057, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25060, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25063, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25064, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25067, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25070, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25073, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25076, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25079, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25082, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25085, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25088, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25089, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25092, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25095, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25098, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25099, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25102, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25103, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25106, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25109, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25112, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25115, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25118, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25119, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25122, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25125, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25126, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25127, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25128, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25131, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25134, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25137, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25140, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25143, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25146, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25149, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25152, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25155, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25158, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25159, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25162, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25163, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25166, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25169, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25170, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25173, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25176, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25179, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25182, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25185, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25188, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25189, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25192, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25198, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25199, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25202, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25205, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25208, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25211, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25214, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25217, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25220, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25223, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25226, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25229, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25230, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25233, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25234, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25235, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25238, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25241, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25244, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25245, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25248, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25249, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25252, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25255, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25256, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25259, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25260, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25263, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25266, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25269, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25272, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25273, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25276, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25277, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25280, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25281, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25282, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25283, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25286, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25290, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25293, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25296, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25299, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25302, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25305, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25306, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25309, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25312, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25315, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25316, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25319, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25322, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25325, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25328, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25352, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25354, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25357, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25360, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25362, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25365, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25366, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25369, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25372, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25373, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25375, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25378, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25380, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25383, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25385, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25388, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25391, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25392, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25394, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25395, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25398, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25401, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25404, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25407, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25410, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25412, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25415, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25418, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25420, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25423, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25426, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25429, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25431, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25434, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25437, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25438, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25441, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25444, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25447, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25450, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25453, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25456, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25460, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25463, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25467, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25470, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25473, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25475, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25478, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25481, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25484, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25487, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25490, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25493, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25496, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25498, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25501, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25504, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25506, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25509, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25512, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25514, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25517, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25523, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25524, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25527, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29062, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29065, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29056, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29060, 9912, 1500, 4000, 1, 1000000); сам спросил, сам ответил... Изменено 9 декабря, 2012 пользователем rooti Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
taste 501 Опубликовано 9 декабря, 2012 INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25001, 9912, 1500, 4000, 1, 1000000); для РБ 25001 ИТЕМ 9912 min 1500 max 4000 chance 100% для всех L2RaidBoss INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25001, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25004, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25007, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25010, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25016, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25019, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25020, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25023, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25026, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25029, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25032, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25035, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25038, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25041, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25044, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25047, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25050, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25051, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25054, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25057, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25060, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25063, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25064, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25067, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25070, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25073, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25076, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25079, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25082, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25085, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25088, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25089, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25092, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25095, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25098, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25099, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25102, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25103, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25106, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25109, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25112, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25115, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25118, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25119, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25122, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25125, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25126, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25127, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25128, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25131, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25134, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25137, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25140, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25143, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25146, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25149, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25152, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25155, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25158, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25159, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25162, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25163, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25166, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25169, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25170, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25173, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25176, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25179, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25182, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25185, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25188, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25189, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25192, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25198, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25199, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25202, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25205, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25208, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25211, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25214, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25217, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25220, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25223, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25226, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25229, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25230, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25233, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25234, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25235, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25238, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25241, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25244, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25245, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25248, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25249, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25252, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25255, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25256, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25259, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25260, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25263, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25266, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25269, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25272, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25273, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25276, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25277, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25280, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25281, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25282, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25283, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25286, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25290, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25293, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25296, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25299, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25302, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25305, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25306, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25309, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25312, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25315, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25316, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25319, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25322, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25325, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25328, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25352, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25354, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25357, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25360, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25362, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25365, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25366, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25369, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25372, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25373, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25375, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25378, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25380, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25383, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25385, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25388, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25391, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25392, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25394, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25395, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25398, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25401, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25404, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25407, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25410, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25412, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25415, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25418, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25420, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25423, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25426, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25429, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25431, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25434, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25437, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25438, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25441, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25444, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25447, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25450, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25453, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25456, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25460, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25463, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25467, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25470, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25473, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25475, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25478, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25481, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25484, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25487, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25490, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25493, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25496, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25498, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25501, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25504, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25506, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25509, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25512, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25514, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25517, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25523, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25524, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (25527, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29062, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29065, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29056, 9912, 1500, 4000, 1, 1000000);INSERT INTO droplist (mobId, itemId, min , max , category , chance ) VALUES (29060, 9912, 1500, 4000, 1, 1000000); сам спросил, сам ответил... пишется 1 запрос по типу монстра, а не каждому отдельный Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
rooti 764 Опубликовано 9 декабря, 2012 пишется 1 запрос по типу монстра, а не каждому отдельный да ШТО ты говоришь а то б*ть type, или class стоит в droplist? Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
taste 501 Опубликовано 9 декабря, 2012 INSERT INTO `droplist` SELECT id, 'ид','мин','мак','категория','шанс', FROM `npc` WHERE `type` = 'L2RaidBoss'; и не благодари Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
rooti 764 Опубликовано 9 декабря, 2012 (изменено) INSERT INTO `droplist` SELECT id, 'ид','мин','мак','категория','шанс', FROM `npc` WHERE `type` = 'L2RaidBoss'; и не благодари ты смотрел ветку droplist? где б*ять тут type? я бы не спрашивал, если бы было все так просто Изменено 9 декабря, 2012 пользователем rooti Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Abnormal 254 Опубликовано 9 декабря, 2012 ты смотрел ветку droplist? где б*ять тут type? ты смотрел его запрос? WHERE 'type' = 'L2RaidBoss' айди не нужно вручную писать, а можно взять из другой таблицы Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Demoncool 1110 Опубликовано 9 декабря, 2012 ты смотрел ветку droplist? где б*ять тут type? я бы не спрашивал, если бы было все так просто лол FROM `npc` WHERE `type` = 'L2RaidBoss'; если в таблице нпц тип=л2реидбосс Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
•°•°•PsycHoO•°•°• 1581 Опубликовано 9 декабря, 2012 Вставляй по отдельности) INSERT INTO `droplist` VALUES ('0001(ID РБ)', '4037(Дроп)', '1(Мин)', '10(Макс)', '1(Кол-во)', '100(Шанс)'); Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
rooti 764 Опубликовано 9 декабря, 2012 //close, всем спать Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
•°•°•PsycHoO•°•°• 1581 Опубликовано 9 декабря, 2012 //close, всем спать Норм отношение к людям которые откликнулись... Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты