22-09-2010, 04:32 PM
|
#1 (permalink)
|
|
Jesus Te Ama, Mas EU Não!
Registrado em: Oct 2008
Localização: 45º 33º 34º N | 122º 41º 41º W DESTINATION: ANYWHERE Adidas
Posts: 4,133
Agradecido 6,058 Vezes em 2,106 Posts
Achei Ruim:
Acharam ruim Vezes em Posts
Meu Estado:
Pontos: 20,442, Nível: 90 |
Nome Real: Anderson Andrade
|
Query Acabe Com os Drops de Determinados Materiais (Coal, Charcoal, Silver Nugget...)
Acabe com aqueles drops indesejados.
Certos servidores ao abaixar o rate de drop item para 1, param de dropar adenas, impossibilitando assim que se diminua para 1 e não caia alguns materiais chatos.
Esta query tem a finalidade de deletar estes materiais comuns do droplist de todos os mobs.
Quais itens ele remove do drop?
|
#===========================By Setokaiba============================================
# Visite agora mesmo www.secretexperience.net | Tudo sobre Lineage II
#===========================By Setokaiba============================================
DELETE FROM droplist WHERE itemId=1663; # Steam
DELETE FROM droplist WHERE itemId=1865; # Varnish
DELETE FROM droplist WHERE itemId=1866; # Sued
DELETE FROM droplist WHERE itemId=1867; # Animal Skin
DELETE FROM droplist WHERE itemId=1868; # Thread
DELETE FROM droplist WHERE itemId=1869; # Iron Ore
DELETE FROM droplist WHERE itemId=1870; # Coal
DELETE FROM droplist WHERE itemId=1871; # Charcoal
DELETE FROM droplist WHERE itemId=1872; # Animal Bone
DELETE FROM droplist WHERE itemId=1873; # Silver Nugget
DELETE FROM droplist WHERE itemId=1874; # Oriharukon Ore
DELETE FROM droplist WHERE itemId=1875; # Stone of Purity
DELETE FROM droplist WHERE itemId=1876; # Mithril Ore
DELETE FROM droplist WHERE itemId=1877; # Adamantite Nugget
DELETE FROM droplist WHERE itemId=1878; # Braided Hemp
DELETE FROM droplist WHERE itemId=1879; # Cokes
DELETE FROM droplist WHERE itemId=1880; # Steal
DELETE FROM droplist WHERE itemId=1881; # Coarse Bone Powder
DELETE FROM droplist WHERE itemId=1882; # Leather
DELETE FROM droplist WHERE itemId=1883; # Steel Mold
DELETE FROM droplist WHERE itemId=1884; # Cord
DELETE FROM droplist WHERE itemId=1885; # High Grade Suede
#===========================By Setokaiba============================================
|
|
|