Silah ve Zırh için Anvil Oranlarını Değiştirme

Upgrade Oranı ile bi anlasma saglayalım Size kodların kaç oran verdiğini yazayım.

Kod:

10000 = 100%
7500 =  75%
5000 = 50%
2500 = 25%
1000 = 10%
500 = 5%
100 = 1%
10 = .1%
1 = .01%

ahanda oranlar böyle gardaş


Elemental Scroll Rates
Parantez Bırakmayın Gardaş

Kod:

update item_upgrade set nGenRate=(%) where nReqItem1=379025000

Trina olmadan yükseltme

Kod:

update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=379021000 and nOriginItem like '%0'

SİMDİ DİKKAT TRİNA İLE YÜKSELTİLİOR !

Kod:

update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%1'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%2'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%3'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%4'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%5'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%6'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%7'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%8'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%9'
update item_upgrade set nGenRate=(%) where nReqItem1=700002000 and nReqItem2=379021000 and nOriginItem like '%0'