Настройка Сервера

[deh4eg 0]

Всем доброго времени суток!Народ подскажите пожалуйста, что нужно сделать что бы убрать дроп с сервера, типо там Варнишь и т.д.не нужные вещи для ПВП сервера, что бы только несколько вещей падало, ну и соответственно квестовые вещи))Сборка - lionna

[(D)uality 700]

Могу запрос скинуть если хочешь . Советую скачать менеджер запросов - найдешь для себя много полезного

[paradizzz 10]

Cоздаёшь текстовый файл

Вписываешь это:

DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

сохраняешь в формате .sql

Жмёшь на бд сервера (в навикате) правой кнопкой, выбираешь Execute SQL File и выбираешь тот файл, который создал.

[deh4eg 0]

Cоздаёшь текстовый файл

Вписываешь это:

DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

сохраняешь в формате .sql

Жмёшь на бд сервера (в навикате) правой кнопкой, выбираешь Execute SQL File и выбираешь тот файл, который создал.

 

Дык получается, удалится Адена и то что я напишу, а мне надо что бы осталась Адена и пару вещей!Я правильно понял?)

[taste 501]

ща найду те запросы

[taste 501]

DELETE FROM droplist WHERE itemId BETWEEN 1864 AND 1895;

DELETE FROM droplist WHERE itemId BETWEEN 4039 AND 4047;

DELETE FROM droplist WHERE itemId='5550';

DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='17';

DELETE FROM droplist WHERE itemId='1341';

DELETE FROM droplist WHERE itemId='1342';

DELETE FROM droplist WHERE itemId='1343';

DELETE FROM droplist WHERE itemId='1344';

DELETE FROM droplist WHERE itemId='1345';

DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='1539';

DELETE FROM droplist WHERE itemId='5591';

DELETE FROM droplist WHERE itemId='5592';

DELETE FROM droplist WHERE itemId='2508';

DELETE FROM droplist WHERE itemId='736';

DELETE FROM droplist WHERE itemId='1829';

DELETE FROM droplist WHERE itemId='1830';

DELETE FROM droplist WHERE itemId='737';

DELETE FROM droplist WHERE itemId='1538';

DELETE FROM droplist WHERE itemId BETWEEN 1047 AND 1099;

DELETE FROM droplist WHERE itemId BETWEEN 1150 AND 1152;

DELETE FROM droplist WHERE itemId BETWEEN 1377 AND 1418;

DELETE FROM droplist WHERE itemId BETWEEN 1512 AND 1537;

DELETE FROM droplist WHERE itemId BETWEEN 1667 AND 1671;

DELETE FROM `droplist` WHERE `itemId`=1856;

DELETE FROM droplist WHERE itemId BETWEEN 3038 AND 3118;

DELETE FROM droplist WHERE itemId BETWEEN 3429 AND 3432;

DELETE FROM droplist WHERE itemId BETWEEN 3941 AND 3944;

DELETE FROM droplist WHERE itemId BETWEEN 4200 AND 4203;

DELETE FROM droplist WHERE itemId BETWEEN 4206 AND 4208;

DELETE FROM droplist WHERE itemId BETWEEN 4906 AND 4935;

DELETE FROM droplist WHERE itemId BETWEEN 5013 AND 5015;

DELETE FROM `droplist` WHERE `itemId`=5809;

DELETE FROM `droplist` WHERE `itemId`=5810;

DELETE FROM `droplist` WHERE `itemId`=5811;

DELETE FROM `droplist` WHERE `itemId`=5812;

DELETE FROM `droplist` WHERE `itemId`=5813;

DELETE FROM `droplist` WHERE `itemId`=5814;

DELETE FROM `droplist` WHERE `itemId`=5815;

DELETE FROM `droplist` WHERE `itemId`=5816;

DELETE FROM `droplist` WHERE `itemId`=6350;

DELETE FROM `droplist` WHERE `itemId`=6351;

DELETE FROM `droplist` WHERE `itemId`=6352;

DELETE FROM `droplist` WHERE `itemId`=6395;

DELETE FROM `droplist` WHERE `itemId`=6396;

DELETE FROM `droplist` WHERE `itemId`=6397;

DELETE FROM `droplist` WHERE `itemId`=6398;

DELETE FROM `droplist` WHERE `itemId`=7638;

DELETE FROM `droplist` WHERE `itemId`=7639;

DELETE FROM `droplist` WHERE `itemId`=7640;

DELETE FROM `droplist` WHERE `itemId`=7641;

DELETE FROM `droplist` WHERE `itemId`=7642;

DELETE FROM `droplist` WHERE `itemId`=7643;

DELETE FROM `droplist` WHERE `itemId`=7644;

DELETE FROM `droplist` WHERE `itemId`=7645;

DELETE FROM `droplist` WHERE `itemId`=7646;

DELETE FROM `droplist` WHERE `itemId`=7647;

DELETE FROM `droplist` WHERE `itemId`=7648;

DELETE FROM `droplist` WHERE `itemId`=7649;

DELETE FROM `droplist` WHERE `itemId`=7650;

DELETE FROM `droplist` WHERE `itemId`=7651;

DELETE FROM `droplist` WHERE `itemId`=7652;

DELETE FROM `droplist` WHERE `itemId`=7653;

DELETE FROM `droplist` WHERE `itemId`=7654;

DELETE FROM `droplist` WHERE `itemId`=7655;

DELETE FROM `droplist` WHERE `itemId`=7656;

DELETE FROM `droplist` WHERE `itemId`=7657;

DELETE FROM `droplist` WHERE `itemId`=7658;

DELETE FROM `droplist` WHERE `itemId`=7659;

DELETE FROM `droplist` WHERE `itemId`=7660;

DELETE FROM `droplist` WHERE `itemId`=7661;

DELETE FROM `droplist` WHERE `itemId`=7652;

DELETE FROM `droplist` WHERE `itemId`=7663;

DELETE FROM `droplist` WHERE `itemId`=7664;

DELETE FROM `droplist` WHERE `itemId`=7665;

DELETE FROM `droplist` WHERE `itemId`=7666;

DELETE FROM `droplist` WHERE `itemId`=7667;

DELETE FROM `droplist` WHERE `itemId`=7668;

DELETE FROM `droplist` WHERE `itemId`=7669;

DELETE FROM `droplist` WHERE `itemId`=7670;

DELETE FROM `droplist` WHERE `itemId`=7671;

DELETE FROM `droplist` WHERE `itemId`=7672;

DELETE FROM `droplist` WHERE `itemId`=7673;

DELETE FROM `droplist` WHERE `itemId`=7674;

DELETE FROM `droplist` WHERE `itemId`=7675;

DELETE FROM `droplist` WHERE `itemId`=7676;

DELETE FROM `droplist` WHERE `itemId`=7835;

DELETE FROM `droplist` WHERE `itemId`=8380;

DELETE FROM `droplist` WHERE `itemId`=8381;

DELETE FROM `droplist` WHERE `itemId`=8382;

DELETE FROM `droplist` WHERE `itemId`=8383;

DELETE FROM `droplist` WHERE `itemId`=8384;

DELETE FROM `droplist` WHERE `itemId`=8385;

DELETE FROM `droplist` WHERE `itemId`=8386;

DELETE FROM `droplist` WHERE `itemId`=8387;

DELETE FROM `droplist` WHERE `itemId`=8388;

DELETE FROM `droplist` WHERE `itemId`=8389;

DELETE FROM `droplist` WHERE `itemId`=8390;

DELETE FROM `droplist` WHERE `itemId`=8391;

DELETE FROM `droplist` WHERE `itemId`=8392;

DELETE FROM `droplist` WHERE `itemId`=8393;

DELETE FROM `droplist` WHERE `itemId`=8394;

DELETE FROM `droplist` WHERE `itemId`=8395;

DELETE FROM `droplist` WHERE `itemId`=8396;

DELETE FROM `droplist` WHERE `itemId`=8397;

DELETE FROM `droplist` WHERE `itemId`=8398;

DELETE FROM `droplist` WHERE `itemId`=8399;

DELETE FROM `droplist` WHERE `itemId`=8400;

DELETE FROM `droplist` WHERE `itemId`=8401;

DELETE FROM `droplist` WHERE `itemId`=8402;

DELETE FROM `droplist` WHERE `itemId`=8616;

DELETE FROM `droplist` WHERE `itemId`=8617;

DELETE FROM `droplist` WHERE `itemId`=8877;

DELETE FROM `droplist` WHERE `itemId`=8878;

DELETE FROM `droplist` WHERE `itemId`=8879;

DELETE FROM `droplist` WHERE `itemId`=8880;

DELETE FROM `droplist` WHERE `itemId`=8881;

DELETE FROM `droplist` WHERE `itemId`=8882;

DELETE FROM `droplist` WHERE `itemId`=8883;

DELETE FROM `droplist` WHERE `itemId`=8884;

DELETE FROM `droplist` WHERE `itemId`=8885;

DELETE FROM `droplist` WHERE `itemId`=8886;

DELETE FROM `droplist` WHERE `itemId`=8888;

DELETE FROM `droplist` WHERE `itemId`=8889;

DELETE FROM `droplist` WHERE `itemId`=8890;

DELETE FROM `droplist` WHERE `itemId`=8891;

DELETE FROM `droplist` WHERE `itemId`=8945;

DELETE FROM `droplist` WHERE `itemId`=8946;

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

но то что тебе дал предыдущий человек тоже ок запрос.оставляет дроп только адены.попродуй сначало его

[deh4eg 0]

А при заливке этого кода - DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1') квест итемы остаются?)

[SmokiMo 892]

Автоматическое сообщение

 

 

Эта тема была перемещена из "Форум для новичков" в "Архив".