[question] Убрать дроп
15 replies107 viewsCurrently viewing: 1
· 06/06/2009, 05:30 PM
Вот запрос, в ковычках напиши ID то что тебе нужно оставить.... Думаю проще варианта не найти....
Код
DELETE FROM droplist WHERE itemId NOT IN (57,77,107);
Вот самый оптимальный вариант что нужно на сервере, если нету крафтинга....
Код
### Other ###
DELETE FROM droplist WHERE itemId NOT IN (57,6360,6361,6362,6673,5575);
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;
DELETE FROM `droplist` WHERE `mobId`='29001';
DELETE FROM `droplist` WHERE `mobId`='29006';
DELETE FROM `droplist` WHERE `mobId`='29014';
DELETE FROM `droplist` WHERE `mobId`='29019';
DELETE FROM `droplist` WHERE `mobId`='29020';
DELETE FROM `droplist` WHERE `mobId`='29022';
DELETE FROM `droplist` WHERE `mobId`='29028';
DELETE FROM `droplist` WHERE `mobId`='29066';
DELETE FROM `droplist` WHERE `mobId`='29067';
DELETE FROM `droplist` WHERE `mobId`='29068';
### Valakas ###
REPLACE INTO `droplist` VALUES (29028,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29028,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29028,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29028,6657,1,1,4,1000000); -- Necklace of Valakas
### Baium ###
REPLACE INTO `droplist` VALUES (29020,6622,1,5,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29020,6658,1,1,2,1000000); -- Ring of Baium
REPLACE INTO `droplist` VALUES (29020,1538,1,59,3,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29020,3936,1,39,4,1000000); -- Blessed Scroll of Resurrection
### Zaken ###
REPLACE INTO `droplist` VALUES (29022,6622,1,5,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29022,6659,1,1,2,1000000); -- Zaken\'s Earring
### Antharas ###
REPLACE INTO `droplist` VALUES (29019,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29019,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29019,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29019,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29066,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29066,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29066,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29066,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29067,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29067,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29067,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29067,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29068,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29068,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29068,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29068,6656,1,1,4,1000000); -- Earring of Antharas
### Queen Ant ###
REPLACE INTO `droplist` VALUES (29001,6622,1,3,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29001,6660,1,1,2,1000000); -- Ring of Queen Ant
### Core ###
REPLACE INTO `droplist` VALUES (29006,6622,1,1,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29006,6662,1,1,2,1000000); -- Ring of Core
### Orfen ###
REPLACE INTO `droplist` VALUES (29014,6622,1,1,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29014,6661,1,1,2,1000000); -- Earring of Orfen
DELETE FROM droplist WHERE itemId NOT IN (57,6360,6361,6362,6673,5575);
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;
DELETE FROM `droplist` WHERE `mobId`='29001';
DELETE FROM `droplist` WHERE `mobId`='29006';
DELETE FROM `droplist` WHERE `mobId`='29014';
DELETE FROM `droplist` WHERE `mobId`='29019';
DELETE FROM `droplist` WHERE `mobId`='29020';
DELETE FROM `droplist` WHERE `mobId`='29022';
DELETE FROM `droplist` WHERE `mobId`='29028';
DELETE FROM `droplist` WHERE `mobId`='29066';
DELETE FROM `droplist` WHERE `mobId`='29067';
DELETE FROM `droplist` WHERE `mobId`='29068';
### Valakas ###
REPLACE INTO `droplist` VALUES (29028,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29028,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29028,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29028,6657,1,1,4,1000000); -- Necklace of Valakas
### Baium ###
REPLACE INTO `droplist` VALUES (29020,6622,1,5,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29020,6658,1,1,2,1000000); -- Ring of Baium
REPLACE INTO `droplist` VALUES (29020,1538,1,59,3,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29020,3936,1,39,4,1000000); -- Blessed Scroll of Resurrection
### Zaken ###
REPLACE INTO `droplist` VALUES (29022,6622,1,5,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29022,6659,1,1,2,1000000); -- Zaken\'s Earring
### Antharas ###
REPLACE INTO `droplist` VALUES (29019,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29019,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29019,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29019,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29066,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29066,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29066,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29066,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29067,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29067,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29067,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29067,6656,1,1,4,1000000); -- Earring of Antharas
### Antharas ###
REPLACE INTO `droplist` VALUES (29068,1538,1,59,1,1000000); -- Blessed Scroll of Escape
REPLACE INTO `droplist` VALUES (29068,3936,1,39,2,1000000); -- Blessed Scroll of Resurrection
REPLACE INTO `droplist` VALUES (29068,6622,1,5,3,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29068,6656,1,1,4,1000000); -- Earring of Antharas
### Queen Ant ###
REPLACE INTO `droplist` VALUES (29001,6622,1,3,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29001,6660,1,1,2,1000000); -- Ring of Queen Ant
### Core ###
REPLACE INTO `droplist` VALUES (29006,6622,1,1,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29006,6662,1,1,2,1000000); -- Ring of Core
### Orfen ###
REPLACE INTO `droplist` VALUES (29014,6622,1,1,1,1000000); -- Secret Book of Giants
REPLACE INTO `droplist` VALUES (29014,6661,1,1,2,1000000); -- Earring of Orfen
0
· 06/06/2009, 05:44 PM
Если не знаешь как вставлять, то возьми любой SQL файл, да вставь все эти строчки, далее как обычно заливаешь в базу.
0
· 06/06/2009, 05:51 PM
wwds: мля, у кого есть такой файл??? нужно только адена и дроп с рб
Я же тебе только что кинул, там адена и дроп РБ....
0
· 06/06/2009, 05:56 PM
Назови его как тебе нравится,я тебе уже прикрепленный файл кинул.... Не тормози. Да, потом в навикат.
0
· 06/06/2009, 06:08 PM
зделай сначала бэкап базы на всякий случай, а так да как только зальёшь скуэль запрос он всё поудаляет и будет так как задуманно в запросе :)
0
Войдите или зарегистрируйтесь чтобы ответить



