[мануал] Удаляем Дроп
Запросы:
Удаление ВСЕГО дропа кроме адены (также бижи с РБ или камней с катов)
DELETE FROM droplist WHERE itemId != '57';
Запрос на удаление всего кроме спойла и адены:
DELETE FROM droplist WHERE itemId != '57' AND category !='-1';
А вот запрос на удаление всего (также и спойла) кроме адены и камней в катах:
DELETE FROM droplist WHERE itemId != '57' AND itemId != '6360' AND itemId != '6361' AND itemId != '6362';
А вот запрос на удаление всего кроме спойла, адены и камней.
DELETE FROM droplist WHERE itemId != '57' AND itemId != '6360' AND itemId != '6361' AND itemId != '6362' AND category !='-1';
Запрос на возвращение бижи их владельцам (возвращаем артефакты РейдБоссам)
INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');
Желательно всё делать при выключенном сервере!
— www.l2club.ru
Не проще для ПВП воспользоваться SQL запросом
(важно, посмотрите чтобы у вас в таблице droplist был столбец category)
DELETE FROM droplist WHERE category='1';
DELETE FROM droplist WHERE category='2';
и выдержка
-- Information about category:
-- Only one drop will be given per category, except in the cases when category is -1.
-- Category -1 is used for SPOIL/SWEEP drops only! Do NOT change this.
-- In general, category 0 is for adena and 1 seal stone color (each seal stone color should be in a different category).
-- In general, category 1 is for full drops and parts of equipable items. However, you can change this.
-- In general, category 2 is for all other items. However, you can change this.
-- In general, more categories are only used for RBs who have 1 item per category (i.e. do not really drop categorized)
-- You can create more categories as you see fit. Just make sure the "category" number is non-negative!!
-- Also, it is NOT a problem if category numbers are skipped (so you can have -1, 1, 5, 10 as your categories).
--
-- If you wish to allow more than one item to be given from the same category, you can
-- split them up over several categories.
-- In addition, RBs and Grandbosses (mainly) may have the exact same item repeated in multiple categories.
-- This allows mobs to give 1 copy of the drop to each of several people (if they are lucky enough to get the drops).
-- Calculation for each drop, when in categories, is equivallent in chance as when outside of categories.
-- First, the sum of chances for each category is calculated as category chance. If the category is selected
-- for drops (i.e. its chance is successful), then exactly 1 item from that category will be selected, with
-- such a chance that the overall probability is maintained unchanged.
— 20