[ Новые сообщения · Участники · Правила форума · Поиск · RSS ]
  • Страница 1 из 1
  • 1
Модератор форума: Zeqp, Hood, LLITOPM, MistorY  
Форум » LineAge2 » Сервер » Полезные SQL запросы (Удаление дриопа и тд..)
Полезные SQL запросы
defaultNick2746Дата: Понедельник, 17.08.2009, 15:34:57 | Сообщение # 1
Рядовой
Сообщений: 4
Награды: 1
Писал не сам, просто собрал всё в 1ом месте.

[HIDE=1]Удаление всех вещей с определённым ID у определнного персонажа.

Код

Code
DELETE * FROM items WHERE item_id=(ид того что удалить) AND owner_id=(ИД перса, у когорого удалить)

Снижение цен во всех магазинах до 1 адены:

Код

Code
update etcitem set price=1 where price > 1;
update weapon set price=1 where price > 1;
update armor set price=1 where price > 1;

Показ всех вещей определённого чара:

Код
mysql>

Code
select a.name,"armor",a.crystal_type,i.count,i.enchant_level from armor a, items i where a.item_id=i.item_id and i.owner_id=[COLOR="DarkOrange"]идчара[/COLOR] union select a.name,"weapon",a.crystal_type,i.count,i.enchant_level from weapon a, items i where a.item_id=i.item_id and i.owner_id=[COLOR="DarkOrange"]идчара[/COLOR] union select a.name,"some",a.crystal_type,i.count,i.enchant_level from etcitem a, items i where a.item_id=i.item_id and i.owner_id=[COLOR="DarkOrange"]идчара[/COLOR];

Убирает вес:

Code
update etcitem set weight=1 where weight> 1;
update weapon set weight=1 where weight> 1;
update armor set weight=1 where weight > 1;

Дропаются только адены:

Код

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

Шанс дропа аден 100% вместо 70%

Code
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;

Удаляем всё, кроме вещей с ID 57, 77, 107

Код

Code
DELETE FROM droplist WHERE itemId NOT IN (57,77,107);

удаляем нпц (в том числе мобов) выше 51 лвл с респа (не удаляя их с сервака). ЛВЛ моба выставляет в конце запросов.
Код:

Code
DELETE spawnlist FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<51;

удаляем с респа только мобов свыше 51 лвл:

Код

Code
DELETE spawnlist FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<51 AND npc.type="L2Monster";

удалить с респа и удалить с сервака мобов свыше 51 лвл:

Code
DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<51 AND npc.type="L2Monster";

Скрипт для очистки базы ява сервера:
суть простая, удаляются чары и все вещи и прочее ниже определенного времени или не заходившие с какого то времени.

Code
UPDATE characters SET online=0;
DELETE FROM characters WHERE lastAccess < 1191211200;
DELETE FROM accounts WHERE lastactive < 1191211200;
DELETE FROM characters WHERE level < 75;
DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_subpledges WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_wars WHERE clan1 NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_wars WHERE clan2 NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM auction_bid WHERE bidderId NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clanhall_functions WHERE hall_id NOT IN (SELECT ID FROM clanhall WHERE ownerId <> '0');
UPDATE clanhall SET paidUntil='0' WHERE ownerId NOT IN (SELECT clan_id FROM clan_data);
UPDATE clanhall SET ownerId='0' WHERE ownerId NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM account_data WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM account_data WHERE account_name NOT IN (SELECT account_name FROM characters);
DELETE FROM account_data WHERE value NOT IN (SELECT obj_Id FROM characters);
DELETE FROM items WHERE loc <> 'clanwh' and owner_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM items WHERE loc = 'clanwh' and owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_quests WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_friends WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_subclasses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM couples WHERE player1Id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM couples WHERE player2Id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM pets where item_obj_id not in (SELECT object_id FROM items);
DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM forums WHERE forum_owner_id <> '0' AND forum_owner_id NOT IN (SELECT clan_id FROM clan_data);

Удаление дропа ресурсов со всех мобов. Он безопасен, удаляет дроп варнишей, молдов, скинов и прочего

Code
DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1867';
DELETE FROM droplist WHERE itemId='1868';
DELETE FROM droplist WHERE itemId='1869';
DELETE FROM droplist WHERE itemId='1870';
DELETE FROM droplist WHERE itemId='1871';
DELETE FROM droplist WHERE itemId='1872';
DELETE FROM droplist WHERE itemId='1873';
DELETE FROM droplist WHERE itemId='1874';
DELETE FROM droplist WHERE itemId='1875';
DELETE FROM droplist WHERE itemId='1876';
DELETE FROM droplist WHERE itemId='1877';
DELETE FROM droplist WHERE itemId='1878';
DELETE FROM droplist WHERE itemId='1879';
DELETE FROM droplist WHERE itemId='1880';
DELETE FROM droplist WHERE itemId='1881';
DELETE FROM droplist WHERE itemId='1882';
DELETE FROM droplist WHERE itemId='1883';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1889';
DELETE FROM droplist WHERE itemId='1890';
DELETE FROM droplist WHERE itemId='1891';
DELETE FROM droplist WHERE itemId='1892';
DELETE FROM droplist WHERE itemId='1893';
DELETE FROM droplist WHERE itemId='1894';
DELETE FROM droplist WHERE itemId='1895';

Удаление дропа:

Ресурсы

Code
[HIDE=10]DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1868';
DELETE FROM droplist WHERE itemId='1869';
DELETE FROM droplist WHERE itemId='1870';
DELETE FROM droplist WHERE itemId='1871';
DELETE FROM droplist WHERE itemId='1872';
DELETE FROM droplist WHERE itemId='1873';
DELETE FROM droplist WHERE itemId='1874';
DELETE FROM droplist WHERE itemId='1875';
DELETE FROM droplist WHERE itemId='1876';
DELETE FROM droplist WHERE itemId='1877';
DELETE FROM droplist WHERE itemId='1878';
DELETE FROM droplist WHERE itemId='1879';
DELETE FROM droplist WHERE itemId='1880';
DELETE FROM droplist WHERE itemId='1881';
DELETE FROM droplist WHERE itemId='1882';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1895';
DELETE FROM droplist WHERE itemId='5549';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1890';
DELETE FROM droplist WHERE itemId='1891';
DELETE FROM droplist WHERE itemId='1892';
DELETE FROM droplist WHERE itemId='1893';
DELETE FROM droplist WHERE itemId='1889';
DELETE FROM droplist WHERE itemId='1894';
DELETE FROM droplist WHERE itemId='4039';
DELETE FROM droplist WHERE itemId='4040';
DELETE FROM droplist WHERE itemId='4041';
DELETE FROM droplist WHERE itemId='4042';
DELETE FROM droplist WHERE itemId='4043';
DELETE FROM droplist WHERE itemId='4044';
DELETE FROM droplist WHERE itemId='4046';
DELETE FROM droplist WHERE itemId='4047';
DELETE FROM droplist WHERE itemId='4045';
DELETE FROM droplist WHERE itemId='5550';
DELETE FROM droplist WHERE itemId='4048';[/HIDE]

Стрелы

Code
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';

Potions

Code
[HIDE=10]DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';[/HIDE]

Cursed Bone

Code
[HIDE=10]DELETE FROM droplist WHERE itemId='2508';[/HIDE]

SoE

Code
[HIDE=10]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';[/HIDE]

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

Таким макаром можно удалять из дропа вещи только типа трецептов, кусков, ресурсов/

Вот например:
Как сделать что бы со всех мобов падало от 1кк до 7кк аден.

Ответ:
Вот запросы:

Code
UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
UPDATE `droplist` SET `droplist`.`max`=7000000 WHERE `droplist`.`itemId`=57;

На многих серверах при перекупании заточек игроки не могут зайти в игру
Запрос что бы почистить ивентарь от заточек
Code
delete from items where item_id=730 and owner_id=268634479;

ДК и арка у магов , драк и дагер у файтеров при старте
пять последних цыфр это айди шмоток

Code
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 6608);

Code
DELETE FROM droplist WHERE itemId='8904';
DELETE FROM droplist WHERE itemId='8900';
DELETE FROM droplist WHERE itemId='8902';
DELETE FROM droplist WHERE itemId='8907';
DELETE FROM droplist WHERE itemId='8903';
DELETE FROM droplist WHERE itemId='8908';
DELETE FROM droplist WHERE itemId='8906';
DELETE FROM droplist WHERE itemId='8905';
DELETE FROM droplist WHERE itemId='8901';
DELETE FROM droplist WHERE itemId='8899';

#02:50:00 -время рестарта/выключения

Код
Для рестарта:

Code
INSERT ignore into global_tasks values (99, 'restart', 'TYPE_GLOBAL_TASK', 2147483647, '1', 'сюда время рестарта в формате 02:50:00', '600');

Для выключения:

Code
INSERT ignore into global_tasks values (99, 'shutdown', 'TYPE_GLOBAL_TASK', 2147483647, '1', 'сюда время выключения в формате 02:50:00', '600');

Добавлено (17.08.2009, 15:34:57)
---------------------------------------------
Таблица global_tasks

Вот выкладую запрос на удаление всех книг для скилов и амулетов с дроплиста. Может кому-то понадобится

Code
DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1048;
DELETE FROM `droplist` WHERE `itemId`=1049;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1047;
DELETE FROM `droplist` WHERE `itemId`=1050;
DELETE FROM `droplist` WHERE `itemId`=1051;
DELETE FROM `droplist` WHERE `itemId`=1052;
DELETE FROM `droplist` WHERE `itemId`=1053;
DELETE FROM `droplist` WHERE `itemId`=1054;
DELETE FROM `droplist` WHERE `itemId`=1055;
DELETE FROM `droplist` WHERE `itemId`=1056;
DELETE FROM `droplist` WHERE `itemId`=1057;
DELETE FROM `droplist` WHERE `itemId`=1058;
DELETE FROM `droplist` WHERE `itemId`=1059;
DELETE FROM `droplist` WHERE `itemId`=1095;
DELETE FROM `droplist` WHERE `itemId`=1096;
DELETE FROM `droplist` WHERE `itemId`=1097;
DELETE FROM `droplist` WHERE `itemId`=1098;
DELETE FROM `droplist` WHERE `itemId`=1099;
DELETE FROM `droplist` WHERE `itemId`=1150;
DELETE FROM `droplist` WHERE `itemId`=1151;
DELETE FROM `droplist` WHERE `itemId`=1152;
DELETE FROM `droplist` WHERE `itemId`=1377;
DELETE FROM `droplist` WHERE `itemId`=1378;
DELETE FROM `droplist` WHERE `itemId`=1379;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1380;
DELETE FROM `droplist` WHERE `itemId`=1382;
DELETE FROM `droplist` WHERE `itemId`=1383;
DELETE FROM `droplist` WHERE `itemId`=1384;
DELETE FROM `droplist` WHERE `itemId`=1385;
DELETE FROM `droplist` WHERE `itemId`=1386;
DELETE FROM `droplist` WHERE `itemId`=1387;
DELETE FROM `droplist` WHERE `itemId`=1388;
DELETE FROM `droplist` WHERE `itemId`=1389;
DELETE FROM `droplist` WHERE `itemId`=1390;
DELETE FROM `droplist` WHERE `itemId`=1391;
DELETE FROM `droplist` WHERE `itemId`=1392;
DELETE FROM `droplist` WHERE `itemId`=1393;
DELETE FROM `droplist` WHERE `itemId`=1394;
DELETE FROM `droplist` WHERE `itemId`=1395;
DELETE FROM `droplist` WHERE `itemId`=1396;
DELETE FROM `droplist` WHERE `itemId`=1397;
DELETE FROM `droplist` WHERE `itemId`=1398;
DELETE FROM `droplist` WHERE `itemId`=1399;
DELETE FROM `droplist` WHERE `itemId`=1400;
DELETE FROM `droplist` WHERE `itemId`=1401;
DELETE FROM `droplist` WHERE `itemId`=1402;
DELETE FROM `droplist` WHERE `itemId`=1403;
DELETE FROM `droplist` WHERE `itemId`=1404;
DELETE FROM `droplist` WHERE `itemId`=1405;
DELETE FROM `droplist` WHERE `itemId`=1406;
DELETE FROM `droplist` WHERE `itemId`=1407;
DELETE FROM `droplist` WHERE `itemId`=1408;
DELETE FROM `droplist` WHERE `itemId`=1409;
DELETE FROM `droplist` WHERE `itemId`=1410;
DELETE FROM `droplist` WHERE `itemId`=1411;
DELETE FROM `droplist` WHERE `itemId`=1412;
DELETE FROM `droplist` WHERE `itemId`=1413;
DELETE FROM `droplist` WHERE `itemId`=1414;
DELETE FROM `droplist` WHERE `itemId`=1415;
DELETE FROM `droplist` WHERE `itemId`=1416;
DELETE FROM `droplist` WHERE `itemId`=1417;
DELETE FROM `droplist` WHERE `itemId`=1418;
DELETE FROM `droplist` WHERE `itemId`=1512;
DELETE FROM `droplist` WHERE `itemId`=1513;
DELETE FROM `droplist` WHERE `itemId`=1514;
DELETE FROM `droplist` WHERE `itemId`=1516;
DELETE FROM `droplist` WHERE `itemId`=1515;
DELETE FROM `droplist` WHERE `itemId`=1517;
DELETE FROM `droplist` WHERE `itemId`=1518;
DELETE FROM `droplist` WHERE `itemId`=1519;
DELETE FROM `droplist` WHERE `itemId`=1520;
DELETE FROM `droplist` WHERE `itemId`=1521;
DELETE FROM `droplist` WHERE `itemId`=1522;
DELETE FROM `droplist` WHERE `itemId`=1523;
DELETE FROM `droplist` WHERE `itemId`=1524;
DELETE FROM `droplist` WHERE `itemId`=1525;
DELETE FROM `droplist` WHERE `itemId`=1526;
DELETE FROM `droplist` WHERE `itemId`=1527;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1528;
DELETE FROM `droplist` WHERE `itemId`=1530;
DELETE FROM `droplist` WHERE `itemId`=1531;
DELETE FROM `droplist` WHERE `itemId`=1532;
DELETE FROM `droplist` WHERE `itemId`=1533;
DELETE FROM `droplist` WHERE `itemId`=1534;
DELETE FROM `droplist` WHERE `itemId`=1535;
DELETE FROM `droplist` WHERE `itemId`=1536;
DELETE FROM `droplist` WHERE `itemId`=1537;
DELETE FROM `droplist` WHERE `itemId`=1667;
DELETE FROM `droplist` WHERE `itemId`=1668;
DELETE FROM `droplist` WHERE `itemId`=1669;
DELETE FROM `droplist` WHERE `itemId`=1670;
DELETE FROM `droplist` WHERE `itemId`=1671;
DELETE FROM `droplist` WHERE `itemId`=1856;
DELETE FROM `droplist` WHERE `itemId`=3038;
DELETE FROM `droplist` WHERE `itemId`=3039;
DELETE FROM `droplist` WHERE `itemId`=3040;
DELETE FROM `droplist` WHERE `itemId`=3041;
DELETE FROM `droplist` WHERE `itemId`=3042;
DELETE FROM `droplist` WHERE `itemId`=3043;
DELETE FROM `droplist` WHERE `itemId`=3044;
DELETE FROM `droplist` WHERE `itemId`=3045;
DELETE FROM `droplist` WHERE `itemId`=3046;
DELETE FROM `droplist` WHERE `itemId`=3047;
DELETE FROM `droplist` WHERE `itemId`=3048;
DELETE FROM `droplist` WHERE `itemId`=3049;
DELETE FROM `droplist` WHERE `itemId`=3050;
DELETE FROM `droplist` WHERE `itemId`=3051;
DELETE FROM `droplist` WHERE `itemId`=3052;
DELETE FROM `droplist` WHERE `itemId`=3053;
DELETE FROM `droplist` WHERE `itemId`=3054;
DELETE FROM `droplist` WHERE `itemId`=3055;
DELETE FROM `droplist` WHERE `itemId`=3056;
DELETE FROM `droplist` WHERE `itemId`=3057;
DELETE FROM `droplist` WHERE `itemId`=3058;
DELETE FROM `droplist` WHERE `itemId`=3059;
DELETE FROM `droplist` WHERE `itemId`=3060;
DELETE FROM `droplist` WHERE `itemId`=3061;
DELETE FROM `droplist` WHERE `itemId`=3062;
DELETE FROM `droplist` WHERE `itemId`=3063;
DELETE FROM `droplist` WHERE `itemId`=3064;
DELETE FROM `droplist` WHERE `itemId`=3065;
DELETE FROM `droplist` WHERE `itemId`=3066;
DELETE FROM `droplist` WHERE `itemId`=3067;
DELETE FROM `droplist` WHERE `itemId`=3068;
DELETE FROM `droplist` WHERE `itemId`=3069;
DELETE FROM `droplist` WHERE `itemId`=3070;
DELETE FROM `droplist` WHERE `itemId`=3071;
DELETE FROM `droplist` WHERE `itemId`=3072;
DELETE FROM `droplist` WHERE `itemId`=3073;
DELETE FROM `droplist` WHERE `itemId`=3074;
DELETE FROM `droplist` WHERE `itemId`=3075;
DELETE FROM `droplist` WHERE `itemId`=3076;
DELETE FROM `droplist` WHERE `itemId`=3077;
DELETE FROM `droplist` WHERE `itemId`=3078;
DELETE FROM `droplist` WHERE `itemId`=3079;
DELETE FROM `droplist` WHERE `itemId`=3080;
DELETE FROM `droplist` WHERE `itemId`=3081;
DELETE FROM `droplist` WHERE `itemId`=3082;
DELETE FROM `droplist` WHERE `itemId`=3083;
DELETE FROM `droplist` WHERE `itemId`=3084;
DELETE FROM `droplist` WHERE `itemId`=3085;
DELETE FROM `droplist` WHERE `itemId`=3086;
DELETE FROM `droplist` WHERE `itemId`=3087;
DELETE FROM `droplist` WHERE `itemId`=3088;
DELETE FROM `droplist` WHERE `itemId`=3089;
DELETE FROM `droplist` WHERE `itemId`=3090;
DELETE FROM `droplist` WHERE `itemId`=3091;
DELETE FROM `droplist` WHERE `itemId`=3092;
DELETE FROM `droplist` WHERE `itemId`=3093;
DELETE FROM `droplist` WHERE `itemId`=3094;
DELETE FROM `droplist` WHERE `itemId`=3095;
DELETE FROM `droplist` WHERE `itemId`=3096;
DELETE FROM `droplist` WHERE `itemId`=3097;
DELETE FROM `droplist` WHERE `itemId`=3098;
DELETE FROM `droplist` WHERE `itemId`=3099;
DELETE FROM `droplist` WHERE `itemId`=3100;
DELETE FROM `droplist` WHERE `itemId`=3101;
DELETE FROM `droplist` WHERE `itemId`=3102;
DELETE FROM `droplist` WHERE `itemId`=3103;
DELETE FROM `droplist` WHERE `itemId`=3104;
DELETE FROM `droplist` WHERE `itemId`=3105;
DELETE FROM `droplist` WHERE `itemId`=3106;
DELETE FROM `droplist` WHERE `itemId`=3107;
DELETE FROM `droplist` WHERE `itemId`=3108;
DELETE FROM `droplist` WHERE `itemId`=3109;
DELETE FROM `droplist` WHERE `itemId`=3110;
DELETE FROM `droplist` WHERE `itemId`=3111;
DELETE FROM `droplist` WHERE `itemId`=3112;
DELETE FROM `droplist` WHERE `itemId`=3113;
DELETE FROM `droplist` WHERE `itemId`=3114;
DELETE FROM `droplist` WHERE `itemId`=3115;
DELETE FROM `droplist` WHERE `itemId`=3116;
DELETE FROM `droplist` WHERE `itemId`=3117;
DELETE FROM `droplist` WHERE `itemId`=3118;
DELETE FROM `droplist` WHERE `itemId`=3429;
DELETE FROM `droplist` WHERE `itemId`=3430;
DELETE FROM `droplist` WHERE `itemId`=3431;
DELETE FROM `droplist` WHERE `itemId`=3432;
DELETE FROM `droplist` WHERE `itemId`=3941;
DELETE FROM `droplist` WHERE `itemId`=3942;
DELETE FROM `droplist` WHERE `itemId`=3944;
DELETE FROM `droplist` WHERE `itemId`=4200;
DELETE FROM `droplist` WHERE `itemId`=4201;
DELETE FROM `droplist` WHERE `itemId`=4202;
DELETE FROM `droplist` WHERE `itemId`=4203;
DELETE FROM `droplist` WHERE `itemId`=4206;
DELETE FROM `droplist` WHERE `itemId`=4207;
DELETE FROM `droplist` WHERE `itemId`=4208;
DELETE FROM `droplist` WHERE `itemId`=4906;
DELETE FROM `droplist` WHERE `itemId`=4907;
DELETE FROM `droplist` WHERE `itemId`=4908;
DELETE FROM `droplist` WHERE `itemId`=4909;
DELETE FROM `droplist` WHERE `itemId`=4910;
DELETE FROM `droplist` WHERE `itemId`=4911;
DELETE FROM `droplist` WHERE `itemId`=4912;
DELETE FROM `droplist` WHERE `itemId`=4913;
DELETE FROM `droplist` WHERE `itemId`=4914;
DELETE FROM `droplist` WHERE `itemId`=4916;
DELETE FROM `droplist` WHERE `itemId`=4917;
DELETE FROM `droplist` WHERE `itemId`=4918;
DELETE FROM `droplist` WHERE `itemId`=4919;
DELETE FROM `droplist` WHERE `itemId`=4920;
DELETE FROM `droplist` WHERE `itemId`=4922;
DELETE FROM `droplist` WHERE `itemId`=4923;
DELETE FROM `droplist` WHERE `itemId`=4924;
DELETE FROM `droplist` WHERE `itemId`=4928;
DELETE FROM `droplist` WHERE `itemId`=4929;
DELETE FROM `droplist` WHERE `itemId`=4930;
DELETE FROM `droplist` WHERE `itemId`=4931;
DELETE FROM `droplist` WHERE `itemId`=4932;
DELETE FROM `droplist` WHERE `itemId`=4933;
DELETE FROM `droplist` WHERE `itemId`=4934;
DELETE FROM `droplist` WHERE `itemId`=4935;
DELETE FROM `droplist` WHERE `itemId`=5013;
DELETE FROM `droplist` WHERE `itemId`=5014;
DELETE FROM `droplist` WHERE `itemId`=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;
 
ZeqpДата: Понедельник, 31.08.2009, 13:24:13 | Сообщение # 2
Лейтенант
Сообщений: 74
Награды: 2
Респект братка
всё работает! cool cool
Заслужил награду и +1
 
defaultNick2746Дата: Воскресенье, 28.03.2010, 16:14:19 | Сообщение # 3
Рядовой
Сообщений: 4
Награды: 1
Удаляем хлам который дропиться с епик босов
delete from droplist where mobId="ТУТ АЙДИ ЕПИК БОСА" and inemId!="ТУТ АФДИ РБ БИЖЫ КОТОРУЮ НУЖНО ОСТАВИТЬ";

почти на всех сборках при редактирование дропа с валика, тараса, бюма и т д сервер пишет "HTML was too long"

Сообщение отредактировал defaultNick2746 - Воскресенье, 28.03.2010, 16:14:49
 
Форум » LineAge2 » Сервер » Полезные SQL запросы (Удаление дриопа и тд..)
  • Страница 1 из 1
  • 1
Поиск: