Dell Dropitem

[AM0S 16]

Кто поделится скриптом для зачистки от дропа амулетов книг кусков от НГ до Б грейда включительно???

 

Спасибка преогромнейшая....

[Морпех 1]

Кто поделится скриптом для зачистки от дропа амулетов книг кусков от НГ до Б грейда включительно???

 

Спасибка преогромнейшая....

скриптом ? оО первый раз слышу) может SQL запросом ?

[Admiralio 0]

Вот держи, когда-то давно писал, что нужно, сам допишешь.

Запрос удаляет из дропа все вещи, кроме указанных.

Так-же для удобства, я все названия вещей закоментил.

Скрытый текст

-- чистка дропа
DELETE FROM droplist WHERE itemId NOT IN (
17, -- Wooden Arrow
57, -- Adena
725, -- Healing Drug
726, -- Mana Drug
727, -- Healing Potion
728, -- Healing Potion
729, -- Scroll: Enchant Weapon (A)
730, -- Scroll: Enchant Armor (A)
736, -- Scroll of Escape
737, -- Scroll of Resurrection
858, -- Tateossian Earring
889, -- Tateossian Ring
920, -- Tateossian Necklace
947, -- Scroll: Enchant Weapon (
948, -- Scroll: Enchant Armor (
951, -- Scroll: Enchant Weapon ©
952, -- Scroll: Enchant Armor ©
956, -- Scroll: Enchant Armor (D)
955, -- Crystal Scroll: Enchant Weapon (D)
959, -- Scroll: Enchant Weapon (S)
960, -- Scroll: Enchant Armor (S)
1341, -- Bone Arrow
1342, -- Iron Arrow
1343, -- Silver Arrow
1344, -- Mithril Arrow
1345, -- Shining Arrow
1419, -- Blood Mark
1538, -- Blessed Scroll of Escape
1539, -- Greater Healing Potion
1540, -- Quick Healing Potion
1661, --  Thief Key
1829, -- Scroll of Escape: Clan Hall
1830, -- Scroll of Escape: Castle
1831, -- Antidote
1832, -- Greater Antidote
1833, -- Bandage
1834, -- Emergency Dressing
1864, -- Stem
1865, -- Varnish
1866, -- Suede
1867, -- Animal Skin 1868, -- Thread
1869, -- Iron Ore
1870, -- Coal
1871, -- Charcoal
1872, -- Animal Bone
1873, -- Silver Nugget
1874, -- Oriharukon Ore
1875, -- Stone of Purity
1876, -- Mithril Ore
1877, -- Adamantite Nugget
1878, -- Braided Hemp
1879, -- Cokes
1880, -- Steel
1881, -- Coarse Bone Powder
1882, -- Leather
1883, -- Steel Mold
1884, -- Cord
1885, -- High Grade Suede
1886, -- Silver Mold
1887, -- Varnish of Purity
1888, -- Synthetic Cokes
1889, -- Compound Braid
1890, -- Mithril Alloy
1891, -- Artisan's Frame
1892, -- Blacksmith's Frame
1893, -- Oriharukon
1894, -- Crafted Leather
1895, -- Metallic Fiber
4037, -- Coin of Luck
4039, -- Mold Glue
4040, -- Mold Lubricant
4041, -- Mold Hardener
4042, -- Enria
4043, -- Asofe
4044, -- Thons
4045, -- Maestro Holder
4046, -- Maestro Anvil Lock
4047, -- Craftsman Mold
4048, -- Maestro Mold
5591, -- CP Potion
5592, -- Greater CP Potion
5593, -- SP Scroll: Low Grade
5594, -- Medium Grade
5595, -- High Grade
6360, -- Blue Seal Stone
6361, -- Green  Seal Stone
6362, -- Red  Seal Stone
6364, -- Forgotten Blade
6365, -- Basalt Battlehammer
6366, -- Imperial Staff
6367, -- Angel Slayer
6368, -- Shining Bow
6369, -- Dragon Hunter Axe
6370, -- Saint Spear
6371, -- Demon Splinter
6372, -- Heaven's Divider
6535, -- Fishing Shot: non-grade
6536, -- Fishing Shot: D-grade
6537, -- Fishing Shot: C-grade
6538, -- Fishing Shot: B-grade
6539, -- Fishing Shot: A-grade
6540, -- Fishing Shot: S-grade
6569, -- Blessed Scroll: Enchant Weapon (A)
6570, -- Blessed Scroll: Enchant Armor (A)
6571, -- Blessed Scroll: Enchant Weapon (
6572, -- Blessed Scroll: Enchant Armor (
6573, -- Blessed Scroll: Enchant Weapon ©
6574, -- Blessed Scroll: Enchant Armor ©
6575, -- Blessed Scroll: Enchant Weapon (D)
6576, -- Blessed Scroll: Enchant Armor (D)
6577, -- Blessed Scroll: Enchant Weapon (S)
6578, -- Blessed Scroll: Enchant Armor (S)
6579, -- Arcana Mace
6580, -- Tallum Blade*Dark Legion's Edge
6652, -- Scroll: Protection of Valakas 6653, -- Scroll: Flames of Valakas 6654, -- Scroll: Flames of Valakas 6655, -- Scroll: Slay Valakas 6656, -- Earring of Antharas 6657, -- Necklace of Valakas 6658, -- Ring of Baium
6659, -- Zaken's Earring
6660, -- Ring of Queen Ant
6661, -- Earring of Orfen
6662, -- Ring of Core
6665, -- Deluxe Chest Key - Grade 1
6666, -- Deluxe Chest Key - Grade 2
6667, -- Deluxe Chest Key - Grade 3
6668, -- Deluxe Chest Key - Grade 4
6669, -- Deluxe Chest Key - Grade 5
6670, -- Deluxe Chest Key - Grade 6
6671, -- Deluxe Chest Key - Grade 7
6672, -- Deluxe Chest Key - Grade 8
6673, -- Festival Adena
6674, -- Sealed Imperial Crusader Breastplate
6675, -- Sealed Imperial Crusader Gaiters
6676, -- Sealed Imperial Crusader Gauntlet
6677, -- Sealed Imperial Crusader Boots
6678, -- Sealed Imperial Crusader Shield
6679, -- Sealed Imperial Crusader Helmet
6680, -- Sealed Draconic Leather Armor
6681, -- Sealed Draconic Leather Glove
6682, -- Sealed Draconic Leather Boots
6683, -- Sealed Draconic Leather Helmet
6684, -- Sealed Major Arcana Robe
6685, -- Sealed Major Arcana Glove
6686, -- Sealed Major Arcana Boots
6687, -- Sealed Major Arcana Circlet
7575, -- Draconic Bow
8056,-- Key of Splendor Room
8158, -- Memento Mori: C-Grade
8159, -- Memento Mori: B-Grade
8160, -- Memento Mori: A-Grade
8161, -- Dragon Heart: C-Grade
8162, -- Dragon Heart: B-Grade
8163, -- Dragon Heart: A-Grade
8164, -- Earth Egg: C-Grade
8165, -- Earth Egg: B-Grade
8166, -- Earth Egg: A-Grade
8167, -- Nonliving Nucleus: C-Grade
8168, -- Nonliving Nucleus: B-Grade
8169, -- Nonliving Nucleus: A-Grade
8170, -- Angelic Essence: C-Grade
8171, -- Angelic Essence: B-Grade
8172, -- Angelic Essence: A-Grade
8175, -- Cradle of Creation
8176, -- Destruction Tombstone
8177, -- Raid Challenger's Circlet
8178, -- Raid Adventurer's Circlet
8179, -- Raid Master's Circlet
8180, -- Circlet of Ice Fairy Sirra
8191, -- Frintezza's Necklace
8273, -- Anteroom Key
8275, -- Key of Darkness
8627, -- Elixir of Life (S-Grade)
8633, -- Elixir of Mental Strength (S-Grade)
8723, -- Life Stone: level 46
8724, -- Life Stone: level 49
8725, -- Life Stone: level 52
8726, -- Life Stone: level 55
8727, -- Life Stone: level 58
8728, -- Life Stone: level 61
8729, -- Life Stone: level 64
8730, -- Life Stone: level 67
8731, -- Life Stone: level 70
8732, -- Life Stone: level 76
8733, -- Mid-Grade Life Stone: level 46
8734, -- Mid-Grade Life Stone: level 49
8735, -- Mid-Grade Life Stone: level 52
8736, -- Mid-Grade Life Stone: level 55
8737, -- Mid-Grade Life Stone: level 58
8738, -- Mid-Grade Life Stone: level 61
8739, -- Mid-Grade Life Stone: level 64
8740, -- Mid-Grade Life Stone: level 67
8741, -- Mid-Grade Life Stone: level 70
8742, -- Mid-Grade Life Stone: level 76
8743, -- High-Grade Life Stone: level 46
8744, -- High-Grade Life Stone: level 49
8745, -- High-Grade Life Stone: level 52
8746, -- High-Grade Life Stone: level 55
8747, -- High-Grade Life Stone: level 58
8748, -- High-Grade Life Stone: level 61
8749, -- High-Grade Life Stone: level 64
8750, -- High-Grade Life Stone: level 67
8751, -- High-Grade Life Stone: level 70
8752, -- High-Grade Life Stone: level 76
8753, -- Top-Grade Life Stone: level 46
8754, -- Top-Grade Life Stone: level 49
8755, -- Top-Grade Life Stone: level 52
8756, -- Top-Grade Life Stone: level 55
8757, -- Top-Grade Life Stone: level 58
8758, -- Top-Grade Life Stone: level 61
8759, -- Top-Grade Life Stone: level 64
8760, -- Top-Grade Life Stone: level 67
8761, -- Top-Grade Life Stone: level 70
8762, -- Top-Grade Life Stone: level 76
8954, -- Blue Primeval Crystal
8955, -- Green Primeval Crystal
8956, -- Red Primeval Crystal
9546, -- Fire Stone
9547, -- Water Stone
9548, -- Earth Stone
9549, -- Wind Stone
9550, -- Dark Stone
9551, -- Divine Stone
9552, -- Fire Crystal
9553, -- Water Crystal
9554, -- Earth Crystal
9555, -- Wind Crystal
9556, -- Dark Crystal
9557, -- Divine Crystal
9573, -- Life Stone: level 80
9574, -- Mid-Grade Life Stone: level 80
9575, -- High-Grade Life Stone: level 80
9576, -- Top-Grade Life Stone: level 80
9648, -- Transform Sealbook - Onyx Beast
9649, -- Transform Sealbook - Death Blader
9650, -- Transform Sealbook - Grail Apostle
9651, -- Transform Sealbook - Unicorn
9652, -- Transform Sealbook - Lilim Knight
9653, -- Transform Sealbook - Golem Guardian
9654, -- Transform Sealbook - Inferno Drake
9655, -- Transform Sealbook - Dragon Bomber
9674, -- Darion's Badge
9685, --  Gate Key: Darkness
9686, --  Gate Key: Destruction
9687, --  Gate Key: Blood
9703, --  Gate Key: Kamael
9704, --  Gate Key: Archives
9705, --  Gate Key: Observation
9706, --  Gate Key: Spicula
9707, --  Gate Key: Harkilgamed
9708, --  Gate Key: Rodenpicula
9709, --  Gate Key: Arviterre
9710, --  Gate Key: Katenar
9712, --  Gate Key: Massive Cavern
9714, --  Key of the Evil Eye
9791, -- Transform Sealbook - Onyx Beast
9897, -- Scroll of Transformation - Pig
10035, -- Battle Manual - Change Life Stone
10131, -- Onyx Beast Transform Scroll
10132, -- Death Blader Transform Scroll
10133, -- Grail Apostle Transform Scroll
10134, -- Unicorn Transform Scroll
10135, -- Lilim Knight Transform Scroll
10136, -- Golem Guardian Transform Scroll
10137, -- Inferno Drake Transform Scroll
10138, -- Dragon Bomber Transform Scroll
10170, -- Baylor's Earring
10274, -- Rabbit Transformation Scroll
10279, -- Onyx Beast Transform Scroll
10288, -- Transform Sealbook - Divine Knight
10289, -- Transform Sealbook - Divine Warrior
10290, -- Transform Sealbook - Divine Rogue
10291, -- Transform Sealbook - Divine Healer
10292, -- Transform Sealbook - Divine Wizard
10293, -- Transform Sealbook - Divine Enchanter
10294, -- Transform Sealbook - Divine Summoner
10295, -- Transform Sealbook - Zaken
10296, -- Transform Sealbook - Anakim
10297, -- Transform Sealbook - Venom
10298, -- Transform Sealbook - Gordon
10299, -- Transform Sealbook - Ranku
10300, -- Transform Sealbook  - Kechi
10301, -- Transform Sealbook - Demon Prince
10302, -- Transform Sealbook - Heretic
10303, -- Transform Sealbook - Vale Master
10304, -- Transform Sealbook - Saber Tooth Tiger
10305, -- Transform Sealbook - Oel Mahum
10306, -- Transform Sealbook - Doll Blader
10414, -- Agathion Exchange Coupon
10483, -- Life Stone - level 82
10484, -- Mid-Grade Life Stone - level 82
10485, -- High-Grade Life Stone - level 82
10486, -- Top-Grade Life Stone - level 82
12754, -- Accessory Life Stone - level 46
12755, -- Accessory Life Stone - level 49
12756, -- Accessory Life Stone - level 52
12757, -- Accessory Life Stone - level 55
12758, -- Accessory Life Stone - level 58
12759, -- Accessory Life Stone - level 61
12760, -- Accessory Life Stone - level 64
12761, -- Accessory Life Stone - level 67
12762, -- Accessory Life Stone - level 70
12763, -- Accessory Life Stone - level 76
12821, -- Accessory Life Stone - level 80
12822, -- Accessory Life Stone - level 82
12840, -- Accessory Life Stone - level 46
12841, -- Accessory Life Stone - level 49
12842, -- Accessory Life Stone - level 52
12843, -- Accessory Life Stone - level 55
12844, -- Accessory Life Stone - level 58
12845, -- Accessory Life Stone - level 61
12846, -- Accessory Life Stone - level 64
12847, -- Accessory Life Stone - level 67
12848, -- Accessory Life Stone - level 70
12849, -- Accessory Life Stone - level 76
12850, -- Accessory Life Stone - level 80
12851, -- Accessory Life Stone - level 82
13555, -- Combined Transformation Scroll
13800, -- Frog Transformation Scroll
13801, -- Young Child Transformation Scroll
13824, -- Ancient Seal Stone of Mammon
14008, -- Accessory Type Life Stone - level 84
14166, -- Life Stone - level 84
14167, -- Mid-Grade Life Stone - level 84
14168, -- High-Grade Life Stone - level 84
14169, -- Top-Grade Life Stone - level 84
20364, -- Omen Beast Transformation Scroll
20365, -- Death Blader Transformation Scroll
20366, -- Grail Apostle Transformation Scroll
20367, -- Unicorn Transformation Scroll
20368, -- Lilim Knight Transformation Scroll
20369, -- Golem Guardian Transformation Scroll
20370, -- Inferno Drake Transformation Scroll
20371 -- Dragon Bomber Transformation Scroll
);

[AM0S 16]

скриптом ? оО первый раз слышу) может SQL запросом ?

 

ну да )))

 

 

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

[Admiralio 0]

Ну, дописать вручную не проблема. Этот запрос я кстати в ручную составлял.

Чтобы удобнее искать вещи, товетую раскодировать itemname-e.dat в клиенте.

[AM0S 16]

ау тебя есть такой ?

[Admiralio 0]

На, держи, если сам не можешь раскодировать.

Жми чтобы скачать.