Sql

[BiTaCbka 50]

Здравствуйте, помогите написать sql запрос.

1. Нужно удалить с дропа оружие и броню до B-grade.

2. Нужно урезать шанс дропа всех точек.

[VREDNbIi 145]

DELETE FROM `droplist` WHERE `itemid` IN (SELECT item_id FROM `armor` WHERE `crystal_type` IN ( Грейд ));

UPDATE `droplist` SET `chance` = `chance`*1 WHERE `itemId` IN ( ID_Заточки );

[r2ndom 72]

Удаление оружия до B-grade

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE crystal_type= 'none' OR crystal_type= 'd' OR crystal_type= 'c');

Удаление армор до B-grade

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE crystal_type= 'none' OR crystal_type= 'd' OR crystal_type= 'c');

 

Шанс дропа заточек только ручками.

[r2ndom 72]

Шанс дропа всех заточек 100%

UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=730;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=729;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=731;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=732;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=947;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=948;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=949;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=950;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=951;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=952;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=953;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=954;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=955;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=956;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=957;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=958;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=959;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=960;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=961;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=962;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6569;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6570;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6571;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6572;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6573;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6574;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6575;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6576;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6577;
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=6578;