Перейти к содержанию
Авторизация  
rooti

Дроп С Рб

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

Как бы так...

добавить всем РБ (L2RaidBoss), определённый итем.

сборка pw

 

в droplist ведь нет значения L2RaidBoss, как быть?

 

вариант, вырезать всех РБ по сортировке, в excel перелить и поставить дроп...

Изменено пользователем rooti

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


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


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);

 

 

 

сам спросил, сам ответил...

Изменено пользователем rooti

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


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


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);

 

 

 

сам спросил, сам ответил...

genius-mem.jpg

пишется 1 запрос по типу монстра, а не каждому отдельный

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


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

genius-mem.jpg

пишется 1 запрос по типу монстра, а не каждому отдельный

 

 

да ШТО ты говоришь

а то б*ть type, или class стоит в droplist?

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


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

INSERT INTO `droplist` SELECT id, 'ид','мин','мак','категория','шанс', FROM `npc` WHERE `type` = 'L2RaidBoss';

и не благодариmini-happy.png

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


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

INSERT INTO `droplist` SELECT id, 'ид','мин','мак','категория','шанс', FROM `npc` WHERE `type` = 'L2RaidBoss';

и не благодариmini-happy.png

ты смотрел ветку droplist?

aassaz.jpg

где б*ять тут type?

я бы не спрашивал, если бы было все так просто

Изменено пользователем rooti

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


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

ты смотрел ветку droplist?

 

где б*ять тут type?

 

 

ты смотрел его запрос?

WHERE 'type' = 'L2RaidBoss'

айди не нужно вручную писать, а можно взять из другой таблицы 6.png

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


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

ты смотрел ветку droplist?

aassaz.jpg

где б*ять тут type?

я бы не спрашивал, если бы было все так просто

лол

FROM `npc` WHERE `type` = 'L2RaidBoss';

если в таблице нпц тип=л2реидбосс

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


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

Вставляй по отдельности)

 

INSERT INTO `droplist` VALUES ('0001(ID РБ)', '4037(Дроп)', '1(Мин)', '10(Макс)', '1(Кол-во)', '100(Шанс)');

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


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

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

Вы должны быть пользователем, чтобы оставить комментарий

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

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
Авторизация  

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

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×
×
  • Создать...